}
}
}
{
jButtonSearch1 = new JButton4j(Common.icon_search);
jDesktopPane1.add(jButtonSearch1);
jButtonSearch1.setText(lang.get("btn_Search"));
jButtonSearch1.setBounds(14, 176, 129, 32);
jButtonSearch1.setMnemonic(java.awt.event.KeyEvent.VK_S);
jButtonSearch1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
buildSQL();
populateList();
}
});
}
{
jTextFieldMaterial = new JTextField4j();
jDesktopPane1.add(jTextFieldMaterial);
jTextFieldMaterial.setBounds(134, 44, 120, 21);
}
{
jTextFieldLocation = new JTextField4j();
jDesktopPane1.add(jTextFieldLocation);
jTextFieldLocation.setBounds(594, 44, 98, 21);
}
{
jLabel1 = new JLabel4j_std();
jDesktopPane1.add(jLabel1);
jLabel1.setText(lang.get("lbl_Material"));
jLabel1.setBounds(1, 44, 121, 21);
jLabel1.setHorizontalAlignment(SwingConstants.TRAILING);
}
{
jLabel3 = new JLabel4j_std();
jDesktopPane1.add(jLabel3);
jLabel3.setText(lang.get("lbl_Location_ID"));
jLabel3.setBounds(485, 44, 103, 21);
}
{
ComboBoxModel<JDBUom> jComboBox2Model = new DefaultComboBoxModel<JDBUom>(uomList);
jComboBoxUOM = new JComboBox4j<JDBUom>();
jDesktopPane1.add(jComboBoxUOM);
jComboBoxUOM.setModel(jComboBox2Model);
jComboBoxUOM.setBounds(865, 75, 130, 23);
jComboBoxUOM.setMaximumRowCount(12);
}
{
jLabel4 = new JLabel4j_std();
jDesktopPane1.add(jLabel4);
jLabel3.setHorizontalAlignment(SwingConstants.TRAILING);
jLabel4.setText(lang.get("lbl_Pallet_UOM"));
jLabel4.setBounds(764, 77, 96, 21);
jLabel4.setHorizontalAlignment(SwingConstants.TRAILING);
}
{
jButtonHelp = new JButton4j(Common.icon_help);
jDesktopPane1.add(jButtonHelp);
jButtonHelp.setText(lang.get("btn_Help"));
jButtonHelp.setBounds(582, 176, 129, 32);
jButtonHelp.setMnemonic(lang.getMnemonicChar());
}
{
jButtonClose = new JButton4j(Common.icon_close);
jDesktopPane1.add(jButtonClose);
jButtonClose.setText(lang.get("btn_Close"));
jButtonClose.setBounds(866, 176, 129, 32);
jButtonClose.setMnemonic(lang.getMnemonicChar());
jButtonClose.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
JDBQuery2.closeStatement(listStatement);
dispose();
}
});
}
{
jButtonPrint = new JButton4j(Common.icon_report);
jDesktopPane1.add(jButtonPrint);
jButtonPrint.setText(lang.get("btn_Print"));
jButtonPrint.setBounds(298, 176, 129, 32);
jButtonPrint.setEnabled(Common.userList.getUser(Common.sessionID).isModuleAllowed("RPT_PALLETS"));
jButtonPrint.setMnemonic(lang.getMnemonicChar());
jButtonPrint.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
print();
}
});
}
{
jButtonPrint = new JButton4j(Common.icon_report);
jDesktopPane1.add(jButtonPrint);
jButtonPrint.setText(lang.get("btn_Print_Summary"));
jButtonPrint.setBounds(440, 176, 129, 32);
jButtonPrint.setEnabled(Common.userList.getUser(Common.sessionID).isModuleAllowed("RPT_HIST_SUMMARY"));
jButtonPrint.setMnemonic(lang.getMnemonicChar());
jButtonPrint.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
print_summary();
}
});
}
{
jLabel10 = new JLabel4j_std();
jDesktopPane1.add(jLabel10);
jLabel10.setText(lang.get("lbl_Limit"));
jLabel10.setHorizontalAlignment(SwingConstants.TRAILING);
jLabel10.setBounds(661, 145, 87, 21);
}
{
ComboBoxModel<String> jComboBoxSortByModel = new DefaultComboBoxModel<String>(new String[] { "TRANSACTION_REF,SSCC", "TRANSACTION_TYPE,TRANSACTION_SUBTYPE", "TRANSACTION_DATE,SSCC", "MATERIAL,BATCH_NUMBER", "MATERIAL,PROCESS_ORDER", "BATCH_NUMBER,MATERIAL", "PROCESS_ORDER", "QUANTITY",
"DATE_OF_MANUFACTURE", "STATUS", "LOCATION_ID", "UOM", "EAN", "VARIANT" });
jComboBoxSortBy = new JComboBox4j<String>();
jDesktopPane1.add(jComboBoxSortBy);
jComboBoxSortBy.setModel(jComboBoxSortByModel);
jComboBoxSortBy.setBounds(330, 143, 299, 23);
}
{
ComboBoxModel<String> jComboBoxDefaultPalletStatusModel = new DefaultComboBoxModel<String>(Common.palletStatusIncBlank);
jComboBoxPalletStatus = new JComboBox4j<String>();
jDesktopPane1.add(jComboBoxPalletStatus);
jComboBoxPalletStatus.setModel(jComboBoxDefaultPalletStatusModel);
jComboBoxPalletStatus.setBounds(844, 44, 150, 23);
}
{
jLabel15 = new JLabel4j_std();
jDesktopPane1.add(jLabel15);
jLabel15.setText(lang.get("lbl_Pallet_Status"));
jLabel15.setHorizontalAlignment(SwingConstants.TRAILING);
jLabel15.setBounds(731, 44, 108, 21);
}
{
jToggleButtonSequence = new JToggleButton();
jToggleButtonSequence.setSelected(true);
jDesktopPane1.add(jToggleButtonSequence);
jToggleButtonSequence.setBounds(637, 145, 21, 21);
jToggleButtonSequence.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
setSequence(jToggleButtonSequence.isSelected());
}
});
}
{
jLabelQuantity = new JLabel4j_std();
jDesktopPane1.add(jLabelQuantity);
jLabelQuantity.setText(lang.get("lbl_Pallet_Quantity"));
jLabelQuantity.setHorizontalAlignment(SwingConstants.TRAILING);
jLabelQuantity.setBounds(1, 110, 121, 21);
}
{
jFormattedTextFieldQuantity = new JQuantityInput(new BigDecimal("0"));
jDesktopPane1.add(jFormattedTextFieldQuantity);
jFormattedTextFieldQuantity.setFont(Common.font_std);
jFormattedTextFieldQuantity.setHorizontalAlignment(SwingConstants.TRAILING);
jFormattedTextFieldQuantity.setBounds(161, 110, 70, 21);
jFormattedTextFieldQuantity.setVerifyInputWhenFocusTarget(false);
jFormattedTextFieldQuantity.setEnabled(false);
}
{
jLabel2 = new JLabel4j_std();
jDesktopPane1.add(jLabel2);
jLabel2.setText(lang.get("lbl_Material_Batch"));
jLabel2.setHorizontalAlignment(SwingConstants.TRAILING);
jLabel2.setBounds(266, 44, 77, 21);
}
{
jTextFieldBatch = new JTextField4j();
jDesktopPane1.add(jTextFieldBatch);
jTextFieldBatch.setBounds(347, 44, 100, 21);
}
{
jLabelProcessOrder = new JLabel4j_std();
jDesktopPane1.add(jLabelProcessOrder);
jLabelProcessOrder.setText(lang.get("lbl_Process_Order"));
jLabelProcessOrder.setHorizontalAlignment(SwingConstants.TRAILING);
jLabelProcessOrder.setBounds(691, 110, 144, 21);
}
{
jTextFieldProcessOrder = new JTextField4j();
jDesktopPane1.add(jTextFieldProcessOrder);
jTextFieldProcessOrder.setBounds(844, 110, 119, 21);
}
{
jTextFieldEAN = new JTextField4j();
jDesktopPane1.add(jTextFieldEAN);
jTextFieldEAN.setBounds(594, 77, 119, 21);
jTextFieldEAN.setFocusCycleRoot(true);
}
{
jLabel5 = new JLabel4j_std();
jDesktopPane1.add(jLabel5);
jLabel5.setText(lang.get("lbl_Material_UOM_EAN"));
jLabel5.setHorizontalAlignment(SwingConstants.RIGHT);
jLabel5.setHorizontalTextPosition(SwingConstants.RIGHT);
jLabel5.setBounds(485, 77, 103, 21);
}
{
jLabel6 = new JLabel4j_std();
jDesktopPane1.add(jLabel6);
jLabel6.setText("/");
jLabel6.setHorizontalAlignment(SwingConstants.CENTER);
jLabel6.setHorizontalTextPosition(SwingConstants.RIGHT);
jLabel6.setBounds(714, 77, 10, 21);
}
{
jTextFieldVariant = new JTextField4j();
jDesktopPane1.add(jTextFieldVariant);
jTextFieldVariant.setBounds(725, 77, 21, 21);
jTextFieldVariant.setFocusCycleRoot(true);
}
{
jCheckBoxQuantity = new JCheckBox4j();
jDesktopPane1.add(jCheckBoxQuantity);
jCheckBoxQuantity.setBackground(new java.awt.Color(255, 255, 255));
jCheckBoxQuantity.setBounds(129, 110, 21, 21);
jCheckBoxQuantity.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
if (jCheckBoxQuantity.isSelected())
{
jFormattedTextFieldQuantity.setValue(0);
jFormattedTextFieldQuantity.setEnabled(true);
}
else
{
jFormattedTextFieldQuantity.setValue(0);
jFormattedTextFieldQuantity.setEnabled(false);
}
}
});
}
{
jLabel7 = new JLabel4j_std();
jDesktopPane1.add(jLabel7);
jLabel7.setText(lang.get("lbl_Sort_By"));
jLabel7.setHorizontalAlignment(SwingConstants.TRAILING);
jLabel7.setBounds(161, 145, 158, 21);
}
{
SpinnerNumberModel jSpinnerIntModel = new SpinnerNumberModel();
jSpinnerIntModel.setMinimum(1);
jSpinnerIntModel.setMaximum(100000);
jSpinnerIntModel.setStepSize(1);
jSpinnerLimit = new JSpinner();
jDesktopPane1.add(jSpinnerLimit);
jSpinnerLimit.setModel(jSpinnerIntModel);
JSpinner.NumberEditor ne = new JSpinner.NumberEditor(jSpinnerLimit);
ne.getTextField().setFont(Common.font_std);
jSpinnerLimit.setEditor(ne);
jSpinnerLimit.setBounds(776, 145, 73, 21);
jSpinnerLimit.setValue(1000);
jSpinnerLimit.getEditor().setSize(45, 21);
}
{
jCheckBoxLimit = new JCheckBox4j();
jDesktopPane1.add(jCheckBoxLimit);
jCheckBoxLimit.setBackground(new java.awt.Color(255, 255, 255));
jCheckBoxLimit.setBounds(755, 145, 21, 21);
jCheckBoxLimit.setSelected(true);
jCheckBoxLimit.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
if (jCheckBoxLimit.isSelected())
{
jSpinnerLimit.setEnabled(true);
}
else
{
jSpinnerLimit.setEnabled(false);
}
}
});
}
{
jButtonLookupProcessOrder = new JButton4j(Common.icon_lookup);
jDesktopPane1.add(jButtonLookupProcessOrder);
jButtonLookupProcessOrder.setBounds(963, 110, 21, 21);
jButtonLookupProcessOrder.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
JLaunchLookup.dlgCriteriaDefault = "Ready";
JLaunchLookup.dlgAutoExec = true;
if (JLaunchLookup.processOrders())
{
jTextFieldProcessOrder.setText(JLaunchLookup.dlgResult);
}
}
});
}
{
jButtonLookupBatch = new JButton4j(Common.icon_lookup);
jDesktopPane1.add(jButtonLookupBatch);
jButtonLookupBatch.setBounds(446, 44, 21, 21);
jButtonLookupBatch.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
JLaunchLookup.dlgCriteriaDefault = jTextFieldMaterial.getText();
JLaunchLookup.dlgAutoExec = true;
if (JLaunchLookup.materialBatches())
{
jTextFieldBatch.setText(JLaunchLookup.dlgResult);
}
}
});
}
{
jButtonLookupMaterial = new JButton4j(Common.icon_lookup);
jDesktopPane1.add(jButtonLookupMaterial);
jButtonLookupMaterial.setBounds(253, 44, 21, 21);
jButtonLookupMaterial.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
JLaunchLookup.dlgAutoExec = false;
JLaunchLookup.dlgCriteriaDefault = "";
if (JLaunchLookup.materials())
{
jTextFieldMaterial.setText(JLaunchLookup.dlgResult);
}
}
});
}
{
jButtonLookupLocation = new JButton4j(Common.icon_lookup);
jDesktopPane1.add(jButtonLookupLocation);
jButtonLookupLocation.setBounds(691, 44, 21, 21);
jButtonLookupLocation.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
JLaunchLookup.dlgAutoExec = true;
JLaunchLookup.dlgCriteriaDefault = "Y";
if (JLaunchLookup.locations())
{
jTextFieldLocation.setText(JLaunchLookup.dlgResult);
}
}
});
}
{
jTextFieldSSCC = new JTextField4j();
jDesktopPane1.add(jTextFieldSSCC);
jTextFieldSSCC.setBounds(134, 77, 140, 21);
}
{
jLabelSCC = new JLabel4j_std();
jDesktopPane1.add(jLabelSCC);
jLabelSCC.setText(lang.get("lbl_Pallet_SSCC"));
jLabelSCC.setBounds(1, 77, 121, 21);
jLabelSCC.setHorizontalAlignment(SwingConstants.TRAILING);
}
{
jLabel8_1 = new JLabel4j_std();
jLabel8_1.setHorizontalAlignment(SwingConstants.TRAILING);
jLabel8_1.setText(lang.get("lbl_Despatch_No"));
jLabel8_1.setBounds(266, 77, 77, 21);
jDesktopPane1.add(jLabel8_1);
}
{
jTextFieldDespatch_No = new JTextField4j();
jTextFieldDespatch_No.setFocusCycleRoot(true);
jTextFieldDespatch_No.setBounds(347, 77, 119, 21);
jDesktopPane1.add(jTextFieldDespatch_No);
}
{
jLabel1_1 = new JLabel4j_std();
jLabel1_1.setHorizontalAlignment(SwingConstants.TRAILING);
jLabel1_1.setText(lang.get("lbl_Transaction_Ref"));
jLabel1_1.setBounds(485, 110, 103, 21);
jDesktopPane1.add(jLabel1_1);
}
{
transactionDateFrom = new JDateControl();
transactionDateFrom.setBounds(154, 7, 128, 25);
transactionDateFrom.setEnabled(false);
jDesktopPane1.add(transactionDateFrom);
}
{
jCheckBoxTransactionDate = new JCheckBox4j();
jCheckBoxTransactionDate.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
if (jCheckBoxTransactionDate.isSelected())
{
transactionDateFrom.setEnabled(true);
transactionDateTo.setEnabled(true);
calendarButtontransactionDateFrom.setEnabled(true);
calendarButtontransactionDateTo.setEnabled(true);
}
else
{
transactionDateFrom.setEnabled(false);
transactionDateTo.setEnabled(false);
calendarButtontransactionDateFrom.setEnabled(false);
calendarButtontransactionDateTo.setEnabled(false);
}
}
});
jCheckBoxTransactionDate.setBackground(new Color(255, 255, 255));
jCheckBoxTransactionDate.setBounds(129, 9, 21, 21);
jDesktopPane1.add(jCheckBoxTransactionDate);
}
{
jLabel1_2 = new JLabel4j_std();
jLabel1_2.setHorizontalAlignment(SwingConstants.TRAILING);
jLabel1_2.setText(lang.get("lbl_Transaction_Date"));
jLabel1_2.setBounds(1, 12, 121, 21);
jDesktopPane1.add(jLabel1_2);
}
{
jLabel1_3 = new JLabel4j_std();
jLabel1_3.setHorizontalAlignment(SwingConstants.TRAILING);
jLabel1_3.setText(lang.get("lbl_Transaction_Type"));
jLabel1_3.setBounds(495, 11, 93, 21);
jDesktopPane1.add(jLabel1_3);
}
{
jLabel1_4 = new JLabel4j_std();
jLabel1_4.setHorizontalAlignment(SwingConstants.TRAILING);
jLabel1_4.setText(lang.get("lbl_Transaction_Subtype"));
jLabel1_4.setBounds(721, 11, 140, 23);
jDesktopPane1.add(jLabel1_4);
}
{
comboBoxTransactionType = new JComboBox4j<String>();
comboBoxTransactionType.setModel(new DefaultComboBoxModel<String>(Common.transactionTypes));
comboBoxTransactionType.setBounds(593, 11, 124, 23);
jDesktopPane1.add(comboBoxTransactionType);
}
{
comboBoxTransactionSubtype = new JComboBox4j<String>();
comboBoxTransactionSubtype.setModel(new DefaultComboBoxModel<String>(Common.transactionSubTypes));
comboBoxTransactionSubtype.setBounds(865, 11, 130, 23);
jDesktopPane1.add(comboBoxTransactionSubtype);
}
{
jTextFieldTransaction_Ref = new JTextField4j();
jTextFieldTransaction_Ref.setBounds(595, 110, 87, 21);
jDesktopPane1.add(jTextFieldTransaction_Ref);
}
{
transactionDateTo = new JDateControl();
transactionDateTo.setBounds(347, 7, 128, 25);
transactionDateTo.setEnabled(false);
jDesktopPane1.add(transactionDateTo);
}
{
final JButton4j exportXlsButton = new JButton4j(Common.icon_XLS);
exportXlsButton.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
export();
}
});
exportXlsButton.setText(lang.get("btn_Excel"));
exportXlsButton.setBounds(724, 176, 129, 32);
jDesktopPane1.add(exportXlsButton);
}
{
jTextFieldUser = new JTextField4j();
jTextFieldUser.setBounds(348, 110, 119, 21);
jDesktopPane1.add(jTextFieldUser);
}
{
jLabel5_1 = new JLabel4j_std();
jLabel5_1.setHorizontalAlignment(SwingConstants.TRAILING);
jLabel5_1.setText(lang.get("lbl_User_ID"));
jLabel5_1.setBounds(266, 110, 77, 21);
jDesktopPane1.add(jLabel5_1);
}
{
jButtonClear = new JButton4j(Common.icon_clear);
jButtonClear.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
clearFilter();
}
});