/** Descripción de Método */
private void displayLocator() {
MLocator l = (MLocator) fLocator.getSelectedItem();
if (l == null) {
return;
}
//
m_M_Locator_ID = l.getM_Locator_ID();
fWarehouseInfo.setText(l.getWarehouseName());
fX.setText(l.getX());
fY.setText(l.getY());
fZ.setText(l.getZ());
fValue.setText(l.getValue());
getWarehouseInfo(l.getM_Warehouse_ID());
// Set Warehouse
int size = fWarehouse.getItemCount();
for (int i = 0; i < size; i++) {
KeyNamePair pp = (KeyNamePair) fWarehouse.getItemAt(i);
if (pp.getKey() == l.getM_Warehouse_ID()) {
fWarehouse.setSelectedIndex(i);
continue;
}
}
} // displayLocator
/** Descripción de Método */
private void loadFile() {
log.info("");
JFileChooser chooser = new JFileChooser();
chooser.setDialogType(JFileChooser.OPEN_DIALOG);
chooser.setDialogTitle(Msg.getMsg(Env.getCtx(), "AttachmentNew"));
int returnVal = chooser.showOpenDialog(this);
if (returnVal != JFileChooser.APPROVE_OPTION) {
return;
}
//
String fileName = chooser.getSelectedFile().getName();
log.config(fileName);
File file = chooser.getSelectedFile();
if (m_attachment.addEntry(file)) {
cbContent.addItem(fileName);
cbContent.setSelectedIndex(cbContent.getItemCount() - 1);
m_change = true;
}
} // getFileName
/**
* Descripción de Método
*
* @param index
* @return
*/
public String getFileName(int index) {
String fileName = null;
if (cbContent.getItemCount() > index) {
fileName = (String) cbContent.getItemAt(index);
}
return fileName;
} // getFileName
/** Descripción de Método */
private void initLocator() {
log.fine("");
// Load Warehouse
String sql = "SELECT M_Warehouse_ID, Name FROM M_Warehouse";
if (m_only_Warehouse_ID != 0) {
sql += " WHERE M_Warehouse_ID=" + m_only_Warehouse_ID;
}
String SQL =
MRole.getDefault().addAccessSQL(sql, "M_Warehouse", MRole.SQL_NOTQUALIFIED, MRole.SQL_RO)
+ " ORDER BY 2";
try {
PreparedStatement pstmt = DB.prepareStatement(SQL);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
fWarehouse.addItem(new KeyNamePair(rs.getInt(1), rs.getString(2)));
}
rs.close();
pstmt.close();
} catch (SQLException e) {
log.log(Level.SEVERE, "warehouse", e);
}
log.fine("Warehouses=" + fWarehouse.getItemCount());
// Load existing Locators
m_mLocator.fillComboBox(m_mandatory, true, true, false);
log.fine(m_mLocator.toString());
fLocator.setModel(m_mLocator);
fLocator.setValue(m_M_Locator_ID);
fLocator.addActionListener(this);
displayLocator();
//
fCreateNew.setSelected(false);
fCreateNew.addActionListener(this);
enableNew();
//
fWarehouse.addActionListener(this);
fX.addKeyListener(this);
fY.addKeyListener(this);
fZ.addKeyListener(this);
// Guarda el ID de la ubicación con la cual se invocó el constructor
// de este diálogo. Este ID se utiliza en caso de cancelar el diálogo
// para recuperar el valor que tenía previamente el ID de ubicación.
m_OriginalLocatorID = m_M_Locator_ID;
// Update UI
pack();
} // initLocator
/** 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
/** Descripción de Método */
private void dynInit() {
createMenu();
// comboZoom.addActionListener(this);
// Change Listener to set Page no
// centerScrollPane.getViewport().addChangeListener( this );
// Max Page
m_pageMax = m_viewPanel.getPageCount();
spinnerModel.setMaximum(new Integer(m_pageMax));
spinner.addChangeListener(this);
fillComboReport(m_reportEngine.getPrintFormat().getID());
// View Panel Mouse Listener
m_viewPanel.addMouseListener(
new MouseAdapter() {
public void mouseClicked(MouseEvent e) {
if (SwingUtilities.isRightMouseButton(e)) {
mouse_clicked(e, true);
} else if (e.getClickCount() > 1) {
mouse_clicked(e, false);
}
}
});
// fill Drill Options (Name, TableName)
comboDrill.addItem(new ValueNamePair(null, ""));
String sql =
"SELECT t.AD_Table_ID, t.TableName, e.PrintName, NULLIF(e.PO_PrintName,e.PrintName) "
+ "FROM AD_Column c "
+ " INNER JOIN AD_Column used ON (c.ColumnName=used.ColumnName)"
+ " INNER JOIN AD_Table t ON (used.AD_Table_ID=t.AD_Table_ID AND t.IsView='N' AND t.AD_Table_ID <> c.AD_Table_ID)"
+ " INNER JOIN AD_Column cKey ON (t.AD_Table_ID=cKey.AD_Table_ID AND cKey.IsKey='Y')"
+ " INNER JOIN AD_Element e ON (cKey.ColumnName=e.ColumnName) "
+ "WHERE c.AD_Table_ID=? AND c.IsKey='Y' "
+ "ORDER BY 3";
boolean trl = !Env.isBaseLanguage(Env.getCtx(), "AD_Element");
if (trl) {
sql =
"SELECT t.AD_Table_ID, t.TableName, et.PrintName, NULLIF(et.PO_PrintName,et.PrintName) "
+ "FROM AD_Column c"
+ " INNER JOIN AD_Column used ON (c.ColumnName=used.ColumnName)"
+ " INNER JOIN AD_Table t ON (used.AD_Table_ID=t.AD_Table_ID AND t.IsView='N' AND t.AD_Table_ID <> c.AD_Table_ID)"
+ " INNER JOIN AD_Column cKey ON (t.AD_Table_ID=cKey.AD_Table_ID AND cKey.IsKey='Y')"
+ " INNER JOIN AD_Element e ON (cKey.ColumnName=e.ColumnName)"
+ " INNER JOIN AD_Element_Trl et ON (e.AD_Element_ID=et.AD_Element_ID) "
+ "WHERE c.AD_Table_ID=? AND c.IsKey='Y'"
+ " AND et.AD_Language=? "
+ "ORDER BY 3";
}
try {
PreparedStatement pstmt = DB.prepareStatement(sql);
pstmt.setInt(1, m_reportEngine.getPrintFormat().getAD_Table_ID());
if (trl) {
pstmt.setString(2, Env.getAD_Language(Env.getCtx()));
}
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
String tableName = rs.getString(2);
String name = rs.getString(3);
String poName = rs.getString(4);
if (poName != null) {
name += "/" + poName;
}
comboDrill.addItem(new ValueNamePair(tableName, name));
}
rs.close();
pstmt.close();
} catch (SQLException e) {
log.log(Level.SEVERE, "Drill", e);
}
if (comboDrill.getItemCount() == 1) {
labelDrill.setVisible(false);
comboDrill.setVisible(false);
} else {
comboDrill.addActionListener(this);
}
revalidate();
} // dynInit
