/** Refresh Query */
private void refresh() {
String sql = m_sql;
int pos = m_sql.lastIndexOf(" ORDER BY ");
if (!showAll.isSelected()) {
sql = m_sql.substring(0, pos) + s_sqlWhereSameWarehouse;
if (s_sqlMinLife.length() > 0) sql += s_sqlMinLife;
sql += m_sql.substring(pos);
}
//
log.finest(sql);
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
pstmt = DB.prepareStatement(sql, null);
pstmt.setInt(1, m_M_Product_ID);
if (!showAll.isSelected()) {
pstmt.setInt(2, m_M_Warehouse_ID);
}
rs = pstmt.executeQuery();
m_table.loadTable(rs);
} catch (Exception e) {
log.log(Level.SEVERE, sql, e);
} finally {
DB.close(rs, pstmt);
rs = null;
pstmt = null;
}
enableButtons();
}
/**
* Static Init
*
* @throws Exception
*/
private void jbInit() throws Exception {
mainPanel.setLayout(mainLayout);
this.getContentPane().add(mainPanel, BorderLayout.CENTER);
// North
northPanel.setLayout(new ALayout());
northPanel.add(showAll, new ALayoutConstraint(0, 0));
showAll.addActionListener(this);
this.getContentPane().add(northPanel, BorderLayout.NORTH);
// Center
mainPanel.add(centerScrollPane, BorderLayout.CENTER);
centerScrollPane.getViewport().add(m_table, null);
// South
mainPanel.add(confirmPanel, BorderLayout.SOUTH);
mainPanel.setPreferredSize(new Dimension(SCREEN_WIDTH, SCREEN_HEIGHT));
confirmPanel.addActionListener(this);
}
/** Update which fields status (read-only/read-write) based on New ASI/Edit ASI checkbox. */
private final void cmd_newEdit() {
final boolean rw = cbNewEdit.isSelected();
log.config("R/W=" + rw + " " + asiTemplate);
// Lot
final boolean isNewLot = asiTemplate == null || asiTemplate.getM_Lot_ID() <= 0;
fieldLotString.setEditable(rw && isNewLot);
if (fieldLot != null) {
fieldLot.setReadWrite(rw);
}
bLot.setReadWrite(rw);
// Serial No
fieldSerNo.setReadWrite(rw);
bSerNo.setReadWrite(rw);
// Guarantee Date
fieldGuaranteeDate.setReadWrite(rw);
// Attribute Editors
for (final CEditor editor : attributeId2editor.values()) {
editor.setReadWrite(rw);
}
} // cmd_newEdit
/** 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
