Package com.commander4j.db

Examples of com.commander4j.db.JDBPallet

2091
2092
2093
2094
2095
2096
2097
2098
2099
2100
2101
2102
2103
    }
  }

  private void populateList()
  {
    JDBPallet pallet = new JDBPallet(Common.selectedHostID, Common.sessionID);

    JDBPalletTableModel palletTable = new JDBPalletTableModel(pallet.getPalletDataResultSet(listStatement));

    TableRowSorter<JDBPalletTableModel> sorter = new TableRowSorter<JDBPalletTableModel>(palletTable);

    jTable1.setRowSorter(sorter);
View Full Code Here
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
    if (rowCount >= 0)
    {
      int[] rows = jTable1.getSelectedRows();

      JDBPallet temp = new JDBPallet(Common.selectedHostID, Common.sessionID);

      int n = JOptionPane.showConfirmDialog(Common.mainForm, "Delete " + String.valueOf(rowCount) + " SSCC(s) from Master Hold Notice " + jTextFieldMHN.getText() + " ?", "Confirm",
          JOptionPane.YES_NO_OPTION);
      if (n == 0)
      {

        for (int l = 0; l < rows.length; l++)
        {
          String sscc = jTable1.getValueAt(rows[l], JDBMHNPalletTableModelProperties.SSCC_Col).toString();
          temp.getPalletProperties(sscc);
          if (temp.getStatus().equals("Unrestricted"))
          {
            temp.updateMHNDecision("");
            temp.updateMHNNumber("");
            jStatusText.setText("SSCC "+sscc+" removed from MHN "+masterHoldNoticeNumber);
            Rectangle progressRect = jStatusText.getBounds(); 
            progressRect.x = 0; 
            progressRect.y = 0; 
            jStatusText.paintImmediately( progressRect );
View Full Code Here
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
                        if (rowCount >= 0)
                        {
                          int[] rows = jTable1.getSelectedRows();

                          JDBPallet temp = new JDBPallet(Common.selectedHostID, Common.sessionID);

                          int n = JOptionPane.showConfirmDialog(Common.mainForm, "Update Decision  of " + String.valueOf(rowCount) + " SSCC(s) from Master Hold Notice "
                              + jTextFieldMHN.getText() + " to " + decisionList.get(xx).getDescription() + " ?", "Confirm", JOptionPane.YES_NO_OPTION);
                          if (n == 0)
                          {
                            save();
                            for (int l = 0; l < rows.length; l++)
                            {
                              String sscc = jTable1.getValueAt(rows[l], JDBMHNPalletTableModelProperties.SSCC_Col).toString();
                              temp.getPalletProperties(sscc);
                              temp.updateMHNDecision(decisionList.get(xx).getDecision());
                              if (decisionList.get(xx).getStatus().equals("")==false)
                              {
                                temp.updateStatus(decisionList.get(xx).getStatus());

                                jStatusText.setText("SSCC "+sscc+" updated to  "+decisionList.get(xx).getStatus());
                                Rectangle progressRect = jStatusText.getBounds(); 
                                progressRect.x = 0; 
                                progressRect.y = 0; 
View Full Code Here
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
            sscc = bcode.getStringforAppID("00");

            if (bcode.isValidSSCCformat(sscc) == true)
            {

              JDBPallet pallet = new JDBPallet(Common.sd.getData(sessionID, "selectedHost"), sessionID);

              if (pallet.getPalletProperties(sscc))
              {
                pallet.setDateOfManufacture(JUtility.getSQLDateTime());

                if (pallet.confirm())
                {

                  int confirmCount = Integer.valueOf(Common.sd.getData(sessionID, "confirmCount"));
                  confirmCount++;
                  session.setAttribute("_ErrorMessage", "SSCC " + sscc + " confirmed.");
                  saveData(session, "confirmCount", String.valueOf(confirmCount), false);
                  logger.debug(sscc + " confirmed. (" + String.valueOf(confirmCount) + ")");
                } else
                {
                  session.setAttribute("_ErrorMessage", pallet.getErrorMessage());
                }
              } else
              {
                session.setAttribute("_ErrorMessage", "SSCC not found.");
              }
View Full Code Here
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
1368
1369
1370
1371
1372
1373
1374
1375
1376
            sscc = bcode.getStringforAppID("00");

            if (bcode.isValidSSCCformat(sscc) == true)
            {

              JDBPallet pallet = new JDBPallet(Common.sd.getData(sessionID, "selectedHost"), sessionID);

              if (pallet.delete(sscc))
              {
                int deleteCount = Integer.valueOf(Common.sd.getData(sessionID, "deleteCount"));
                deleteCount++;
                session.setAttribute("_ErrorMessage", "SSCC " + sscc + " deleted.");
                saveData(session, "deleteCount", String.valueOf(deleteCount), false);
                logger.debug(sscc + " deleted. (" + String.valueOf(deleteCount) + ")");
              } else
              {
                session.setAttribute("_ErrorMessage", pallet.getErrorMessage());
              }

            } else
            {
              session.setAttribute("_ErrorMessage", bcode.getErrorMessage());
View Full Code Here
1448
1449
1450
1451
1452
1453
1454
1455
1456
1457
1458
1459
1460
1461
1462
1463
1464
1465
1466
1467
1468
1469
1470
1471
1472
1473
1474
1475
1476
1477
            sscc = bcode.getStringforAppID("00");

            if (bcode.isValidSSCCformat(sscc) == true)
            {

              JDBPallet pallet = new JDBPallet(Common.sd.getData(sessionID, "selectedHost"), sessionID);
              pallet.setDateOfManufacture(JUtility.getSQLDateTime());

              if (pallet.getPalletProperties(sscc))
              {

                session.setAttribute("_ErrorMessage", "");
                if (pallet.isConfirmed())
                {
                  session.setAttribute("material", pallet.getMaterial());
                  session.setAttribute("location", pallet.getLocationID());
                  session.setAttribute("despatchNo", pallet.getDespatchNo());
                  session.setAttribute("batch", pallet.getBatchNumber());
                  session.setAttribute("processOrder", pallet.getProcessOrder());
                  session.setAttribute("palletStatus", pallet.getStatus());
                  session.setAttribute("batchStatus", pallet.getMaterialBatchStatus());
                  session.setAttribute("quantity", String.valueOf(pallet.getQuantity()));
                  session.setAttribute("uom", pallet.getUom());
                  session.setAttribute("dom", pallet.getDateOfManufacture().toString().substring(0, 16));
                  session.setAttribute("expiry", pallet.getMaterialBatchExpiryDate().toString().substring(0, 16));
                  error = false;
                  saveData(session, "lastSSCCinfo", "", true);
                  response.sendRedirect("palletInfoDisplay.jsp");
                } else
                {
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
89
    try
    {
      if (cache.containsKey(row)==false)
      {
        mResultSet.absolute(row + 1);
        final JDBPallet prow = new JDBPallet(Common.selectedHostID, Common.sessionID);
        prow.getPropertiesfromResultSet(mResultSet);
        cache.put(row, prow);
      }
      switch (col)
      {
      case SSCC_Col:
View Full Code Here
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
    if (rowCount >= 0)
    {
      int[] rows = jTable1.getSelectedRows();

      JDBPallet temp = new JDBPallet(Common.selectedHostID, Common.sessionID);
      JDBControl ctrl = new JDBControl(Common.selectedHostID, Common.sessionID);
      JDBMHNDecisions decis = new JDBMHNDecisions(Common.selectedHostID, Common.sessionID);

      int n = JOptionPane.showConfirmDialog(Common.mainForm, "Assign selected SSCC's to Master Hold Notice [" + mhnnumber + "  ?", "Confirm", JOptionPane.YES_NO_OPTION);
      if (n == 0)
      {

        String initalDecision = ctrl.getKeyValueWithDefault("MHN INITIAL DECISION", "Pending", "Decision for pallets added to MHN");
        String initialStatus = "";
        if (decis.getDecisionProperties(initalDecision) == true)
        {
          initialStatus = decis.getStatus();
        }
        else
        {
          initialStatus = "";
        }

        for (int l = 0; l < rows.length; l++)
        {
          String sscc = jTable1.getValueAt(rows[l], JDBMHNPalletTableModelAssign.SSCC_Col).toString();
          temp.getPalletProperties(sscc);
          temp.updateMHNNumber(mhnnumber);
          temp.updateMHNDecision(initalDecision);
          if (initialStatus.equals("") == false)
          {
            temp.updateStatus(initialStatus);
          }
          jStatusText.setText("SSCC "+sscc+" added to MHN "+mhnnumber);
          Rectangle progressRect = jStatusText.getBounds(); 
          progressRect.x = 0; 
          progressRect.y = 0; 
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
  public Boolean processMessage(GenericMessageHeader gmh)
  {
    Boolean result = false;

    JDBPallet pal = new JDBPallet(getHostID(), getSessionID());
    JDBMaterial mat = new JDBMaterial(getHostID(), getSessionID());

    String sscc = gmh.getXMLDocument().findXPath("//message/messageData/productionDeclaration/SSCC").trim();
    confirmed = gmh.getXMLDocument().findXPath("//message/messageData/productionDeclaration/confirmed").trim().toUpperCase();

    if (pal.getPalletProperties(sscc) == false)
    {
      pal.setSSCC(sscc);
      pal.setProcessOrder(gmh.getXMLDocument().findXPath("//message/messageData/productionDeclaration/processOrder").trim());
      pal.setUom(gmh.getXMLDocument().findXPath("//message/messageData/productionDeclaration/productionUOM").trim());
      if (pal.populateFromProcessOrder() == true)
      {

        pal.setBatchNumber(gmh.getXMLDocument().findXPath("//message/messageData/productionDeclaration/batch").trim());
        pal.setQuantity(new BigDecimal(gmh.getXMLDocument().findXPath("//message/messageData/productionDeclaration/productionQuantity").trim()));

        String prodDateString = gmh.getXMLDocument().findXPath("//message/messageData/productionDeclaration/productionDate").trim();
        Timestamp prodDateTime = JUtility.getTimeStampFromISOString(prodDateString);

        String expireString = gmh.getXMLDocument().findXPath("//message/messageData/productionDeclaration/expiryDate").trim();
        Timestamp expireTime = JUtility.getTimeStampFromISOString(expireString);

        if (expireTime == null)
        {
          result = false;
          setErrorMessage("SSCC " + pal.getSSCC() + " Expiry Date in wrong format (" + expireString + ") yyyy-mm-ddThh:mm:ss");
        }
        else
        {

          pal.setBatchExpiry(JUtility.getTimestampFromDate(mat.getRoundedExpiryTime(expireTime)));

          if (pal.getBatchExpiry().before(prodDateTime))
          {
            result = false;
            setErrorMessage("SSCC " + pal.getSSCC() + " has Expiry Date before Production Date.");
          }
          else
          {

            if (pal.create("PROD DEC", "CREATE") == false)
            {
              result = false;
              setErrorMessage("SSCC " + pal.getSSCC() + " "+pal.getErrorMessage());
            }
            else
            {
              result = true;
              setErrorMessage("SSCC " + pal.getSSCC() + " created.");
            }
          }
        }

      }
      else
      {
        result = false;
        setErrorMessage("SSCC " + pal.getSSCC() + " " +pal.getErrorMessage());
      }

    }
    else
    {
      result = true;
      // setErrorMessage("SSCC " + pal.getSSCC() + " already exists.");
    }

    if (result == true)
    {
      if (confirmed.equals("Y"))
      {
        if (pal.isConfirmed() == false)
        {

          String prodDateString = gmh.getXMLDocument().findXPath("//message/messageData/productionDeclaration/productionDate").trim();
          Timestamp prodDateTime = JUtility.getTimeStampFromISOString(prodDateString);

          pal.setDateOfManufacture(prodDateTime);

          if (pal.confirm() == false)
          {
            result = false;
            setErrorMessage(pal.getErrorMessage());
          }
          else
          {
            setErrorMessage("SSCC " + pal.getSSCC() + " confirmed.");
          }
        }
        else
        {
          setErrorMessage("SSCC " + pal.getSSCC() + " already confirmed.");
          result = false;
        }
      }
    }
    pal = null;
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
   
    if (desp.getDespatchProperties(getDespatchNo()))
    {
      Long txn = desp.getTransactionRef();
      LinkedList<String> assignedList = new LinkedList<String>();
      JDBPallet pal = new JDBPallet(getHost(),getSession());
      OutgoingDespatchConfirmation odc;
      OutgoingDespatchPreAdvice opa;
      OutgoingEquipmentTracking oet;
     
      assignedList.clear();
      assignedList.addAll(desp.getAssignedSSCCs());
     
      for (int j = 0; j < assignedList.size(); j++)
      {
        if (pal.getPalletProperties(assignedList.get(j)))
        {
          logger.debug("Background confirmation processing SSCC="+assignedList.get(j));
          pal.writePalletHistory(txn, "DESPATCH", "FROM");
          pal.setLocationID(desp.getLocationIDTo());
          pal.updateLocationID();
          pal.writePalletHistory(txn, "DESPATCH", "TO");
        }
      }
     
      pal = null;
View Full Code Here
TOP

Related Classes of com.commander4j.db.JDBPallet

  • com.commander4j.app.JInternalFrameDespatch
  • com.commander4j.app.JInternalFrameMHNAssign
  • com.commander4j.app.JInternalFrameMHNProperties
  • com.commander4j.app.JInternalFramePalletAdmin
  • com.commander4j.bar.JEANBarcode
  • com.commander4j.messages.IncommingDespatchConfirmation
  • com.commander4j.messages.IncommingPalletStatusChange
  • com.commander4j.messages.IncommingProductionDeclarationConfirmation
  • com.commander4j.messages.OutgoingPalletDelete
  • com.commander4j.messages.OutgoingPalletSplit
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.