@Override
public List<I_AD_Table> retrieveAllTables(final Properties ctx, final String trxName) {
final IQueryBuilder<I_AD_Table> queryBuilder =
Services.get(IQueryBL.class).createQueryBuilder(I_AD_Table.class, ctx, trxName);
queryBuilder.orderBy().addColumn(I_AD_Table.COLUMNNAME_TableName);
return queryBuilder.create().list();
}
@Override
public List<I_M_HU> retrieveTUHUsForModel(final Object model) {
final IQueryBuilder<I_M_HU> queryBuilder =
retrieveTUHUAssignmentsForModelQuery(model).andCollect(I_M_HU_Assignment.COLUMN_M_TU_HU_ID);
queryBuilder.orderBy().addColumn(I_M_HU.COLUMN_M_HU_ID);
// NOTE: this method will NOT exclude destroyed HUs.
// Before changing this, please carefully check the depending API.
return queryBuilder.create().list();
}
public IQueryBuilder<I_M_HU_Assignment> retrieveHUAssignmentsForModelQuery(
final Properties ctx, final int adTableId, final int recordId, final String trxName) {
final IQueryBuilder<I_M_HU_Assignment> queryBuilder =
Services.get(IQueryBL.class).createQueryBuilder(I_M_HU_Assignment.class, ctx, trxName);
applyCommonTopLevelFilters(queryBuilder, adTableId)
.addEqualsFilter(I_M_HU_Assignment.COLUMN_Record_ID, recordId);
queryBuilder.orderBy().addColumn(I_M_HU_Assignment.COLUMN_M_HU_Assignment_ID);
return queryBuilder;
}
public IQueryBuilder<I_M_Material_Tracking> createQueryBuilder(
final IMaterialTrackingQuery queryVO) {
Check.assumeNotNull(queryVO, "queryVO not null");
final IQueryBuilder<I_M_Material_Tracking> queryBuilder =
queryBL
.createQueryBuilder(I_M_Material_Tracking.class)
.setContext(getCtx(), getTrxName())
.addOnlyContextClient()
.addOnlyActiveRecordsFilter();
final IQueryOrderByBuilder<I_M_Material_Tracking> orderBy = queryBuilder.orderBy();
//
// M_Product_ID
final int productId = queryVO.getM_Product_ID();
Check.assume(productId > 0, "productId > 0");
queryBuilder.addEqualsFilter(I_M_Material_Tracking.COLUMN_M_Product_ID, productId);
//
// C_BPartner_ID
final int bpartnerId = queryVO.getC_BPartner_ID();
queryBuilder.addInArrayFilter(I_M_Material_Tracking.COLUMN_C_BPartner_ID, null, bpartnerId);
orderBy.addColumn(I_M_Material_Tracking.COLUMN_C_BPartner_ID, Direction.Descending, Nulls.Last);
// TODO: ValidFrom, ValidTo
//
// Processed
final Boolean processed = queryVO.getProcessed();
if (processed != null) {
queryBuilder.addEqualsFilter(I_M_Material_Tracking.COLUMN_Processed, processed);
}
//
// Linked documents
final List<?> linkedModels = queryVO.getWithLinkedDocuments();
if (linkedModels != null && !linkedModels.isEmpty()) {
final IQuery<I_M_Material_Tracking_Ref> materialTrackingRefQuery =
createMaterialTrackingRefQueryForModels(linkedModels);
if (materialTrackingRefQuery != null) {
queryBuilder.addInSubQueryFilter(
I_M_Material_Tracking.COLUMN_M_Material_Tracking_ID,
I_M_Material_Tracking_Ref.COLUMN_M_Material_Tracking_ID,
materialTrackingRefQuery);
}
// TODO
}
return queryBuilder;
}
private final Iterator<I_GL_JournalLine> retrieveGLJournalLines() {
final I_C_TaxDeclaration taxDeclaration = getC_TaxDeclaration();
final IQuery<I_C_TaxDeclarationLine> existingTaxDeclarationLinesQuery =
createQueryBuilder(I_C_TaxDeclarationLine.class).create();
final ICompositeQueryFilter<I_GL_JournalLine> taxAccountableFilter =
queryBL
.createCompositeQueryFilter(I_GL_JournalLine.class)
.setJoinOr()
.addEqualsFilter(I_GL_JournalLine.COLUMN_DR_AutoTaxAccount, true)
.addEqualsFilter(I_GL_JournalLine.COLUMN_CR_AutoTaxAccount, true);
final IQueryBuilder<I_GL_JournalLine> queryBuilder =
createQueryBuilder(I_GL_JournalLine.class)
//
// Only invoices from reporting interval
.addBetweenFilter(
I_GL_JournalLine.COLUMN_DateAcct,
taxDeclaration.getDateFrom(),
taxDeclaration.getDateTo(),
DateTruncQueryFilterModifier.DAY)
//
// Only those which are processed
.addEqualsFilter(I_GL_JournalLine.COLUMN_Processed, true)
//
// Only those which are about taxes
.filter(taxAccountableFilter)
//
// Only those which were not already included in other tax declaration
.addNotInSubQueryFilter(
I_GL_JournalLine.COLUMN_GL_JournalLine_ID,
I_C_TaxDeclarationLine.COLUMN_GL_JournalLine_ID,
existingTaxDeclarationLinesQuery)
//
;
queryBuilder
.orderBy()
.addColumn(I_GL_JournalLine.COLUMN_DateAcct)
.addColumn(I_GL_JournalLine.COLUMN_GL_JournalLine_ID); // to have a predictable order
return queryBuilder
.create()
// guaranteed because we are inserting in C_TaxDeclarationLine and in our query we check to
// not have the record already there
.setOption(IQuery.OPTION_GuaranteedIteratorRequired, true)
//
.iterate(I_GL_JournalLine.class);
}
@Override
public <T extends I_M_ShipperTransportation> List<T> retrieveOpenShipperTransportations(
final Properties ctx, final Class<T> clazz) {
final IQueryBuilder<T> queryBuilder =
Services.get(IQueryBL.class)
.createQueryBuilder(clazz, ctx, ITrx.TRXNAME_None)
.addEqualsFilter(I_M_ShipperTransportation.COLUMNNAME_Processed, false)
.addEqualsFilter(
I_M_ShipperTransportation.COLUMNNAME_DocStatus,
X_M_ShipperTransportation.DOCSTATUS_Entwurf) // Drafts
;
queryBuilder.orderBy().addColumn(I_M_ShipperTransportation.COLUMNNAME_DocumentNo);
return queryBuilder.create().list();
}
@Override
public List<I_M_HU> retrieveTopLevelHUsForModel(final Object model, final String trxName) {
final Properties ctx = InterfaceWrapperHelper.getCtx(model);
final int adTableId = InterfaceWrapperHelper.getModelTableId(model);
final int recordId = InterfaceWrapperHelper.getId(model);
final IQueryBL queryBL = Services.get(IQueryBL.class);
final IQueryBuilder<I_M_HU> queryBuilder =
queryBL
.createQueryBuilder(I_M_HU_Assignment.class, ctx, trxName)
.addEqualsFilter(I_M_HU_Assignment.COLUMN_AD_Table_ID, adTableId)
.addEqualsFilter(I_M_HU_Assignment.COLUMN_Record_ID, recordId)
.addOnlyActiveRecordsFilter()
//
// Collect top level HUs
.andCollect(I_M_HU_Assignment.COLUMN_M_HU_ID);
//
// 07612: Order by HU ID to preserve allocation order (i.e highest HU quantities / full HUs
// first)
queryBuilder.orderBy().addColumn(I_M_HU.COLUMN_M_HU_ID);
final List<I_M_HU> husTopLevel = queryBuilder.create().list(I_M_HU.class);
//
// Guard: make sure all those HUs are really top level
// Normally, this shall not happen. But we could have the case when the TU was joined to a LU
// later and the HU assignment was not updated.
final IHandlingUnitsBL handlingUnitsBL = Services.get(IHandlingUnitsBL.class);
for (final Iterator<I_M_HU> husTopLevelIterator = husTopLevel.iterator();
husTopLevelIterator.hasNext(); ) {
final I_M_HU hu = husTopLevelIterator.next();
if (!handlingUnitsBL.isTopLevel(hu)) {
husTopLevelIterator.remove();
continue;
}
}
// NOTE: this method will NOT exclude destroyed HUs.
// Before changing this, please carefully check the depending API.
return husTopLevel;
}
@Override
protected String doIt() throws Exception {
if (p_Target_Directory == null) throw new FillMandatoryException("Target_Directory");
if (p_EntityType == null) throw new FillMandatoryException("EntityType");
final IQueryBuilder<I_EXP_Format> queryBuilder =
Services.get(IQueryBL.class).createQueryBuilder(I_EXP_Format.class).setContext(this);
if (p_FilterBy_AD_Client_ID) {
queryBuilder.addInArrayFilter(I_EXP_Format.COLUMNNAME_AD_Client_ID, 0, getAD_Client_ID());
}
if (p_EntityType != null) {
queryBuilder.addEqualsFilter(I_EXP_Format.COLUMNNAME_EntityType, p_EntityType);
}
queryBuilder
.orderBy()
.addColumn(I_EXP_Format.COLUMNNAME_EXP_Format_ID) // to have a predictible order
;
final List<I_EXP_Format> expFormats = queryBuilder.create().list();
final CanonicalXSDGenerator engine = new CanonicalXSDGenerator();
for (final I_EXP_Format format : expFormats) {
if (!format.isActive()) continue;
engine.addEXPFormat(format);
// metas-ts: commenting out for now, because taskes very long when there are many export
// formats and it never helped me so far (mainly because it doesn't export embedded formats)
// createTestModel(format);
}
createTestModelsIndex(expFormats);
final String schemaFile = getSchemaFile().getAbsolutePath();
engine.saveToFile(schemaFile);
addLog("Created schema file: " + schemaFile);
return "OK";
}
/** Initialize all panel fields and editors based on {@link #asiTemplate}. */
private final void initAttributes() {
final Properties ctx = getCtx();
final boolean isProductWindow = isProductWindow();
final boolean isProcessParameter = isProcessParameter();
final boolean isPureProductASI = isPureProductASI();
final boolean allowSelectExistingASI = isAllowSelectExistingASI();
final MAttributeSet as = asiTemplate.getMAttributeSet();
Check.assumeNotNull(as, "attribute set not null");
final boolean isASITemplateNew = asiTemplate.getM_AttributeSetInstance_ID() <= 0;
//
// Show Select existing ASI (if allowed)
if (allowSelectExistingASI) {
// New/Edit - Selection
if (isASITemplateNew) // new ASI
cbNewEdit.setText(msgBL.getMsg(ctx, "NewRecord"));
else cbNewEdit.setText(msgBL.getMsg(ctx, "EditRecord"));
cbNewEdit.addActionListener(this);
centerPanel.add(cbNewEdit, new ALayoutConstraint(m_row++, 0));
bSelectExistingASI.setText(msgBL.getMsg(ctx, "SelectExisting"));
bSelectExistingASI.addActionListener(this);
centerPanel.add(bSelectExistingASI, null);
}
//
// Fetch M_Attributes
final List<MAttribute> attributes;
if (isProductWindow) {
attributes = Arrays.asList(as.getMAttributes(false)); // non-instance attributes
} else if (isPureProductASI) {
// Regular product's attribute set instance attributes
attributes = Arrays.asList(as.getMAttributes(true)); // all instance attributes
} else if (isProcessParameter) {
final IQueryBuilder<MAttribute> attributesQueryBuilder =
queryBL
.createQueryBuilder(MAttribute.class)
.setContext(ctx, ITrx.TRXNAME_None)
.addOnlyActiveRecordsFilter()
.addOnlyContextClient();
attributesQueryBuilder
.orderBy()
.addColumn(I_M_Attribute.COLUMNNAME_Name)
.addColumn(I_M_Attribute.COLUMNNAME_M_Attribute_ID);
attributes = attributesQueryBuilder.create().list(MAttribute.class);
} else {
attributes = Collections.emptyList();
}
//
// Create attributes UI editors
for (final MAttribute attribute : attributes) {
if (!attributeExcludeBL.isExcludedAttribute(
attribute, as, m_AD_Column_ID, attributeContext.isSOTrx())) {
addAttributeLine(attribute);
}
}
//
// Lot
if (isPureProductASI && as.isLot()) {
CLabel label = new CLabel(msgBL.translate(ctx, "Lot"));
label.setLabelFor(fieldLotString);
centerPanel.add(label, new ALayoutConstraint(m_row++, 0));
centerPanel.add(fieldLotString, null);
fieldLotString.setText(asiTemplate.getLot());
// M_Lot_ID
// int AD_Column_ID = 9771; // M_AttributeSetInstance.M_Lot_ID
// fieldLot = new VLookup ("M_Lot_ID", false,false, true,
// MLookupFactory.get(getCtx(), m_WindowNo, 0, AD_Column_ID, DisplayType.TableDir));
final String sql =
"SELECT M_Lot_ID, Name "
+ "FROM M_Lot l "
+ "WHERE EXISTS (SELECT M_Product_ID FROM M_Product p "
+ "WHERE p.M_AttributeSet_ID="
+ asiTemplate.getM_AttributeSet_ID()
+ " AND p.M_Product_ID=l.M_Product_ID)";
fieldLot = new CComboBox<>(DB.getKeyNamePairs(sql, true));
label = new CLabel(msgBL.translate(ctx, "M_Lot_ID"));
label.setLabelFor(fieldLot);
centerPanel.add(label, new ALayoutConstraint(m_row++, 0));
centerPanel.add(fieldLot, null);
if (asiTemplate.getM_Lot_ID() > 0) {
for (int i = 1; i < fieldLot.getItemCount(); i++) {
KeyNamePair pp = fieldLot.getItemAt(i);
if (pp.getKey() == asiTemplate.getM_Lot_ID()) {
fieldLot.setSelectedIndex(i);
fieldLotString.setEditable(false);
break;
}
}
}
fieldLot.addActionListener(this);
// New Lot Button
if (asiTemplate.getMAttributeSet().getM_LotCtl_ID() > 0) {
if (Env.getUserRolePermissions().isTableAccess(MLot.Table_ID, false)
&& Env.getUserRolePermissions().isTableAccess(MLotCtl.Table_ID, false)
&& !asiTemplate.isExcludeLot(m_AD_Column_ID, attributeContext.isSOTrx())) {
centerPanel.add(bLot, null);
bLot.addActionListener(this);
}
}
// Popup
fieldLot.addMouseListener(new VPAttributeDialog_mouseAdapter(this)); // popup
mZoom = new CMenuItem(msgBL.getMsg(ctx, "Zoom"), Images.getImageIcon2("Zoom16"));
mZoom.addActionListener(this);
popupMenu.add(mZoom);
} // Lot
//
// SerNo
if (isPureProductASI && as.isSerNo()) {
CLabel label = new CLabel(msgBL.translate(ctx, "SerNo"));
label.setLabelFor(fieldSerNo);
fieldSerNo.setText(asiTemplate.getSerNo());
centerPanel.add(label, new ALayoutConstraint(m_row++, 0));
centerPanel.add(fieldSerNo, null);
// New SerNo Button
if (asiTemplate.getMAttributeSet().getM_SerNoCtl_ID() != 0) {
if (Env.getUserRolePermissions().isTableAccess(MSerNoCtl.Table_ID, false)
&& !asiTemplate.isExcludeSerNo(m_AD_Column_ID, attributeContext.isSOTrx())) {
centerPanel.add(bSerNo, null);
bSerNo.addActionListener(this);
}
}
} // SerNo
//
// GuaranteeDate.
// We are displaying it if we deal with a pure product ASI (i.e. user is not editing the ASI
// from product window),
// and if:
// * the attribute set requires a GuaranteeDate
// * or if the ASI has a GuaranteeDate already set
if (isPureProductASI && (as.isGuaranteeDate() || asiTemplate.getGuaranteeDate() != null)) {
CLabel label = new CLabel(msgBL.translate(ctx, "GuaranteeDate"));
label.setLabelFor(fieldGuaranteeDate);
if (isASITemplateNew) {
Date guaranteeDate = asiTemplate.getGuaranteeDate();
if (guaranteeDate == null) {
guaranteeDate =
attributesBL.calculateBestBeforeDate(
ctx,
m_M_Product_ID, // product
attributeContext.getC_BPartner_ID(), // vendor bpartner
Env.getDate(ctx) // dateReceipt
);
}
fieldGuaranteeDate.setValue(guaranteeDate);
} else {
fieldGuaranteeDate.setValue(asiTemplate.getGuaranteeDate());
}
centerPanel.add(label, new ALayoutConstraint(m_row++, 0));
centerPanel.add(fieldGuaranteeDate, null);
fieldGuaranteeDateDisplayed = true;
} // GuaranteeDate
// Make sure we have at least something to edit or something to select,
// else there is no point in showing empty this window.
if (m_row == 0) {
throw new AdempiereException("@PAttributeNoInfo@");
}
//
// New/Edit Window
if (allowSelectExistingASI) {
cbNewEdit.setSelected(isASITemplateNew);
cmd_newEdit();
}
//
// Attrribute Set Instance Description
{
final CLabel labelDescription = new CLabel(msgBL.translate(ctx, "Description"));
labelDescription.setLabelFor(fieldDescription);
fieldDescription.setText(asiTemplate.getDescription());
fieldDescription.setEditable(false);
centerPanel.add(labelDescription, new ALayoutConstraint(m_row++, 0));
centerPanel.add(fieldDescription, null);
}
// Window usually to wide (??)
{
final Dimension dd = centerPanel.getPreferredSize();
dd.width = Math.min(500, dd.width);
centerPanel.setPreferredSize(dd);
}
} // initAttribute