Examples of JDBControl

Examples of com.commander4j.db.JDBControl

132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
    }
  }

  public static void init()
  {
    JDBControl ctrl = new JDBControl(Common.selectedHostID, Common.sessionID);
    ctrl.getProperties("COMPANY NAME");
    stdparams.put("COMPANY_NAME", ctrl.getKeyValue());
    ctrl.getProperties("PLANT");
    stdparams.put("PLANT", ctrl.getKeyValue());
    stdparams.put("SUBREPORT_DIR", System.getProperty("user.dir")+File.separator+"reports"+File.separator);
    System.getProperty("user.dir");
    ctrl.getProperties("LABEL_HEADER_COMMENT");

    DefaultJasperReportsContext jasperContext = DefaultJasperReportsContext.getInstance();
        JRPropertiesUtil.getInstance(jasperContext).setProperty("net.sf.jasperreports.awt.ignore.missing.font", "true");
        JRPropertiesUtil.getInstance(jasperContext).setProperty("net.sf. jasperreports.properties", Common.report_path+"default.jasperreports.properties");
View Full Code Here

Examples of com.commander4j.db.JDBControl

89
90
91
92
93
94
95
96
97
98
99
100
101
    JDBMaterialLocation matlocn = new JDBMaterialLocation(getHostID(), getSessionID());
    JDBLocation locn = new JDBLocation(getHostID(), getSessionID());
    JDBMaterialUom matuom = new JDBMaterialUom(getHostID(), getSessionID());
    JDBUom uomdb = new JDBUom(getHostID(), getSessionID());
    JDBInterface inter = new JDBInterface(getHostID(), getSessionID());
    JDBControl ctrl = new JDBControl(getHostID(), getSessionID());

    String defaultBatchStatus = ctrl.getKeyValue("DEFAULT BATCH STATUS");

    inter.getInterfaceProperties("Material Definition", "Input");

    material = JUtility.replaceNullStringwithBlank(gmh.getXMLDocument().findXPath("//message/messageData/materialDefinition/material").trim());
    setErrorMessage("Material " + material + " updated.");
View Full Code Here

Examples of com.commander4j.db.JDBControl

1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
                    }

                    if (updateCtrl)
                    {
                      JDBControl ctrl = new JDBControl(Common.selectedHostID, Common.sessionID);
                      if (ctrl.getProperties("SCHEMA VERSION"))
                      {
                        ctrl.setKeyValue(String.valueOf(updrst.schema_requiredVersion));
                        ctrl.update();
                      } else
                      {
                        ctrl.create("SCHEMA VERSION", String.valueOf(updrst.schema_requiredVersion), "Schema Version");
                      }
                      JOptionPane.showMessageDialog(me, "Schema Version now set to " + String.valueOf(JVersion.getSchemaVersion()), "Control Table", JOptionPane.INFORMATION_MESSAGE);

                    }

                  }
                } else
                {
                  JOptionPane.showMessageDialog(me, "No Schema update Required", "Connection to (" + hst.getSiteDescription() + ")", JOptionPane.INFORMATION_MESSAGE);
                }

                if (updrst.program_updateRequired)
                {
                  JDBControl ctrl = new JDBControl(Common.selectedHostID, Common.sessionID);

                  if (ctrl.getProperties("PROGRAM VERSION"))
                  {
                    ctrl.setKeyValue(JVersion.getProgramVersion());
                    ctrl.update();
                  } else
                  {
                    ctrl.create("PROGRAM VERSION", JVersion.getProgramVersion(), "Program Version");
                  }
                  JOptionPane.showMessageDialog(me, "Program Version now set to " + JVersion.getProgramVersion(), "Control Table", JOptionPane.INFORMATION_MESSAGE);

                }
                Common.hostList.getHost(Common.selectedHostID).disconnect(Common.sessionID);
View Full Code Here

Examples of com.commander4j.db.JDBControl

74
75
76
77
78
79
80
81
82
83
84
85
86
    inter.getInterfaceProperties("Pallet Status Change", "Output");
    String device = inter.getDevice();

    JDBPalletHistory palhistfrom = new JDBPalletHistory(getHostID(), getSessionID());
    JDBPalletHistory palhistto = new JDBPalletHistory(getHostID(), getSessionID());
    JDBControl ctrl = new JDBControl(getHostID(), getSessionID());
   
    String origin = ctrl.getKeyValue("DEFAULT_LOCATION");
    JDBMHN mhn = new JDBMHN(getHostID(), getSessionID());
    JDBMHNReasons mhnReasons = new JDBMHNReasons(getHostID(), getSessionID());

    ResultSet rsFrom = palhistfrom.getInterfacingData(transactionRef, "STATUS CHANGE", "FROM", Long.valueOf(1), "SSCC", "asc");
View Full Code Here

Examples of com.commander4j.db.JDBControl

355
356
357
358
359
360
361
362
363
364
365
366
    uomList.addAll(uom.getInternalUoms());

    initGUI();
    final JHelp help = new JHelp();
    help.enableHelpOnButton(jButtonHelp, JUtility.getHelpSetIDforModule("FRM_ADMIN_MATERIAL_EDIT"));
    JDBControl ctrl = new JDBControl(Common.selectedHostID, Common.sessionID);
    expiryMode = ctrl.getKeyValue("EXPIRY DATE MODE");
    SwingUtilities.invokeLater(new Runnable() {
      public void run() {
        jTextFieldProcessOrder.requestFocus();
        jTextFieldProcessOrder.setCaretPosition(jTextFieldProcessOrder.getText().length());
View Full Code Here

Examples of com.commander4j.db.JDBControl

177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
      }
      {
        jButtonExcel = new JButton4j(Common.icon_XLS);
        jButtonExcel.addActionListener(new ActionListener() {
          public void actionPerformed(final ActionEvent e) {
            JDBControl control = new JDBControl(Common.selectedHostID, Common.sessionID);

            JExcel export = new JExcel();
            buildSQL();
            export.saveAs("label_history.xls", control.getControlDataResultSet(listStatement), Common.mainForm);
          }
        });
        jButtonExcel.setText(lang.get("btn_Excel"));
        jButtonExcel.setMnemonic(lang.getMnemonicChar());
        jButtonExcel.setBounds(306, 349, 106, 30);
View Full Code Here

Examples of com.commander4j.db.JDBControl

25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
  public JeMail(String host, String session)
  {
    setHostID(host);
    setSessionID(session);

    JDBControl ctrl = new JDBControl(getHostID(), getSessionID());

    if (SMTP_HOST_LOADED.equals("N/A") == true)
    {
      SMTP_AUTH_REQD = ctrl.getKeyValueWithDefault("MAIL_SMTP_AUTH_REQD", "true", "SMTP Authentication Reqd");
      SMTP_HOST_NAME = ctrl.getKeyValueWithDefault("MAIL_SMTP_HOST_NAME", "mail.testsmtp.com", "SMTP Server for sending emails");
      SMTP_AUTH_USER = ctrl.getKeyValueWithDefault("MAIL_SMTP_AUTH_USER", "mailUser", "SMTP Username");
      SMTP_AUTH_PWD = ctrl.getKeyValueWithDefault("MAIL_SMTP_AUTH_PWD", "mailPassword", "SMTP Password");
      MAIL_SMTP_PORT = ctrl.getKeyValueWithDefault("MAIL_SMTP_PORT", "25", "SMTP Port");
      MAIL_SMTP_SSL_PORT = ctrl.getKeyValueWithDefault("MAIL_SMTP_SSL_PORT", "465", "SMTP SSL Port");
      SMTP_FROM_ADRESS = ctrl.getKeyValueWithDefault("MAIL_SMTP_FROM_ADRESS", "Commander4j", "From Email");
      SMTP_USE_SSL = ctrl.getKeyValueWithDefault("MAIL_SMTP_USE_SSL", "False", "Use SSL");
      SMTP_USE_TLS = ctrl.getKeyValueWithDefault("MAIL_SMTP_USE_TLS", "False", "Use TLS");
      SMTP_HOST_LOADED = host;
    }

  }
View Full Code Here

Examples of com.commander4j.db.JDBControl

34
35
36
37
38
39
40
41
 
  public JDBAutoLabellerTableModel(String host,String session)
  {
    setHostID(host);
    setSessionID(session);
    ctrl = new JDBControl(getHostID(),getSessionID());
    ssccPrefix = ctrl.getKeyValue("SSCC PREFIX");
  }
View Full Code Here

Examples of com.commander4j.db.JDBControl

429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
    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();
        }
View Full Code Here

Examples of com.commander4j.db.JDBControl

165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
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
216
217
218
219
220
221
222
223
          JUtility.initEANBarcode();
          JLaunchReport.init();
          Common.init();

          JDBUser user = new JDBUser(getHostID(), getSessionID());
          JDBControl ctrl = new JDBControl(getHostID(), getSessionID());
          JeMail mail = new JeMail(getHostID(), getSessionID());

          user.setUserId("INTERFACE");
          user.setPassword("INTERFACE");
          Common.userList.addUser(getSessionID(), user);

          enableEnterfaceStatusEmails = Boolean.parseBoolean(ctrl.getKeyValueWithDefault("INTERFACE EMAIL NOTIFY", "false", "Email startup and shutdown events :- true or false"));

          interfaceEmailAddresses = ctrl.getKeyValueWithDefault("INTERFACE ADMIN EMAIL", "someone@somewhere.com", "Email address for startup and shutdown events.");

          StringConverter stringConverter = new StringConverter();
          ArrayConverter arrayConverter = new ArrayConverter(String[].class, stringConverter);
          arrayConverter.setDelimiter(';');
          arrayConverter.setAllowedChars(new char[] { '@','_' });
          String[] emailList = (String[]) arrayConverter.convert(String[].class, interfaceEmailAddresses);
          siteName = Common.hostList.getHost(getHostID()).getSiteDescription();

          if (user.login())
          {

            if (enableEnterfaceStatusEmails == true)
            {
              try
              {
                String subject = "";
                if (houseKeeping == true)
                {
                   subject = "Commander4j "+JVersion.getProgramVersion()+" Interface maintenance restart for [" + siteName + "] on "+JUtility.getClientName();
                }
                else
                {
                  subject = "Commander4j "+JVersion.getProgramVersion()+" Interface startup for [" + siteName + "] on "+JUtility.getClientName();
                }
                mail.postMail(emailList, subject, "Interface service has started.", "", "");
              }
              catch (Exception ex)
              {
                logger.error("InterfaceThread Unable to send emails");
              }
            }
           
            houseKeeping = false;
           
            logger.debug("Interface Logged on successfully");

            logger.debug("Starting Threads....");

            secondsBeforeHousekeeping = Integer.valueOf(ctrl.getKeyValueWithDefault("INTERFACE HOUSEKEEPING INTERVAL", "86400", "Frequency in seconds."));
            secondsRemaining = secondsBeforeHousekeeping;

            startupThreads();

            while ((shutdown == false) & (houseKeeping == false))
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.