Package com.commander4j.db

Examples of com.commander4j.db.JDBUserReport

300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
    btn4jRefresh.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e)
      {
        if (jListUserReports.isSelectionEmpty() == false)
        {
          JDBUserReport reportid = (JDBUserReport) ((JDBListData) jListUserReports.getSelectedValue()).getObject();
          populateListUserReports(reportid.getReportID());
        } else
        {
          populateListUserReports("");
        }

      }
    });
    btn4jRefresh.setText(lang.get("btn_Refresh"));
    btn4jRefresh.setMnemonic('0');

    btn4jRun.setBounds(20, 156, 126, 29);
    panelButtons.add(btn4jRun);
    btn4jRun.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent arg0)
      {
        if (jListUserReports.isSelectionEmpty() == false)
        {
          JDBUserReport reportid = (JDBUserReport) ((JDBListData) jListUserReports.getSelectedValue()).getObject();
          reportid.getUserReportProperties();
          if (reportid.isParamDateRequired())
          {
            reportid.setParamFromDate(JUtility.getTimestampFromDate(domDateFrom.getDate()));
            reportid.setParamToDate(JUtility.getTimestampFromDate(domDateTo.getDate()));
          }
          label4j_statusBar.setText("Please wait....");
          if (reportid.runReport() == false)
          {
            JUtility.errorBeep();
            label4j_statusBar.setText(reportid.getErrorMessage());
            JOptionPane.showMessageDialog(Common.mainForm, reportid.getErrorMessage(), "Error", JOptionPane.ERROR_MESSAGE);
          } else
          {
            label4j_statusBar.setText("Created : " + reportid.getExportFilename());
          }
        }
      }
    });
    btn4jRun.setText(lang.get("btn_Run"));
View Full Code Here
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
  private void copyReport()
  {
    if (jListUserReports.isSelectionEmpty() == false)
    {
      JDBUserReport reportid = (JDBUserReport) ((JDBListData) jListUserReports.getSelectedValue()).getObject();
      String newid = JOptionPane.showInputDialog(Common.mainForm, "Copy report [" + reportid.getReportID() + "] to NEW Report ID");
      if (newid != null)
      {
        if (newid.equals("") == false)
        {
          newid = newid.toUpperCase();
          reportid.getUserReportProperties();
          reportid.setReportID(newid);
          reportid.create(newid);
          reportid.update();
          populateListUserReports(newid);
        }
      }
    }
  }
View Full Code Here
475
476
477
478
479
480
481
482
483
484
  {
    if (Common.userList.getUser(Common.sessionID).isModuleAllowed("FRM_ADMIN_USER_REPORT_EDIT"))
    {
      if (jListUserReports.isSelectionEmpty() == false)
      {
        JDBUserReport reportid = (JDBUserReport) ((JDBListData) jListUserReports.getSelectedValue()).getObject();
        JLaunchMenu.runForm("FRM_ADMIN_USER_REPORT_PROP", reportid.getReportID());
      }
    }
  }
View Full Code Here
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
  private void deleteReport()
  {
    if (jListUserReports.isSelectionEmpty() == false)
    {
      JDBUserReport reportid = (JDBUserReport) ((JDBListData) jListUserReports.getSelectedValue()).getObject();
      int n = JOptionPane.showConfirmDialog(Common.mainForm, "Delete User Report " + reportid.getReportID() + " ?", "Confirm", JOptionPane.YES_NO_OPTION);
      if (n == 0)
      {

        reportid.delete();
        populateListUserReports("");
      }
    }
  }
View Full Code Here
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
  }

  private void addReport()
  {

    JDBUserReport rpt = new JDBUserReport(Common.selectedHostID, Common.sessionID);

    String reportId = JOptionPane.showInputDialog(Common.mainForm, "Enter new Report ID");
    if (reportId != null)
    {
      if (reportId.equals("") == false)
      {
        reportId = reportId.toUpperCase();
        rpt.setReportID(reportId);
        if (rpt.create(reportId) == false)
        {
          JUtility.errorBeep();
          JOptionPane.showMessageDialog(Common.mainForm, rpt.getErrorMessage(), "Error", JOptionPane.ERROR_MESSAGE);
        } else
        {

          JLaunchMenu.runForm("FRM_ADMIN_USER_REPORT_PROP", reportId);
        }
View Full Code Here
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
  private void setButtonState()
  {
    if (jListUserReports.getSelectedIndex() > -1)
    {
      JDBUserReport reportid = (JDBUserReport) ((JDBListData) jListUserReports.getSelectedValue()).getObject();

      domDateFrom.setEnabled(reportid.isParamDateRequired());
      domDateTo.setEnabled(reportid.isParamDateRequired());
      button_CalendardomDateFrom.setEnabled(reportid.isParamDateRequired());
      button_CalendardomDateTo.setEnabled(reportid.isParamDateRequired());
      jListShifts.setEnabled(reportid.isParamDateRequired());
      button4j_Backwards.setEnabled(reportid.isParamDateRequired());
      button4j_Forwards.setEnabled(reportid.isParamDateRequired());

      btn4jAdd.setEnabled(Common.userList.getUser(Common.sessionID).isModuleAllowed("FRM_ADMIN_USER_REPORT_ADD"));
      btn4jEdit.setEnabled(Common.userList.getUser(Common.sessionID).isModuleAllowed("FRM_ADMIN_USER_REPORT_EDIT"));
      btn4jDelete.setEnabled(Common.userList.getUser(Common.sessionID).isModuleAllowed("FRM_ADMIN_USER_REPORT_DELETE"));
      btn4jRun.setEnabled(Common.userList.getUser(Common.sessionID).isModuleAllowed("FRM_ADMIN_USER_REPORT_RUN"));
View Full Code Here
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
  private void populateListUserReports(String defaultitem)
  {
    DefaultComboBoxModel defComboBoxMod = new DefaultComboBoxModel();

    JDBUserReport tempUserReport = new JDBUserReport(Common.selectedHostID, Common.sessionID);

    LinkedList<JDBListData> tempUserReportList = new LinkedList<JDBListData>();

    tempUserReportList = tempUserReport.getUserReportIds();

    int sel = -1;
    for (int j = 0; j < tempUserReportList.size(); j++)
    {
      defComboBoxMod.addElement(tempUserReportList.get(j));
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
    setPasswordVerify("");
  }

  private void init() {
    userGroupMembership = new JDBUserGroupMembership(getHostID(), getSessionID());
    userReport = new JDBUserReport(getHostID(), getSessionID());

    dbPasswordExpiryCalendar = Calendar.getInstance();
    dbPasswordExpiryCalendar.add(Calendar.DATE, -1 * Common.user_password_expiry_days);
    dbPasswordExpiryDate = dbPasswordExpiryCalendar.getTime();

View Full Code Here
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
    btn4jRefresh.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e)
      {
        if (jListUserReports.isSelectionEmpty() == false)
        {
          JDBUserReport reportid = (JDBUserReport) ((JDBListData) jListUserReports.getSelectedValue()).getObject();
          populateListUserReports(reportid.getReportID());
        } else
        {
          populateListUserReports("");
        }

      }
    });
    btn4jRefresh.setText(lang.get("btn_Refresh"));
    btn4jRefresh.setMnemonic('0');

    btn4jRun.setBounds(20, 156, 126, 29);
    panelButtons.add(btn4jRun);
    btn4jRun.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent arg0)
      {
        if (jListUserReports.isSelectionEmpty() == false)
        {
          JDBUserReport reportid = (JDBUserReport) ((JDBListData) jListUserReports.getSelectedValue()).getObject();
          reportid.getUserReportProperties();
          if (reportid.isParamDateRequired())
          {
            reportid.setParamFromDate(JUtility.getTimestampFromDate(domDateFrom.getDate()));
            reportid.setParamToDate(JUtility.getTimestampFromDate(domDateTo.getDate()));
          }
          label4j_statusBar.setText("Please wait....");
          if (reportid.runReport() == false)
          {
            JUtility.errorBeep();
            label4j_statusBar.setText(reportid.getErrorMessage());
            JOptionPane.showMessageDialog(Common.mainForm, reportid.getErrorMessage(), lang.get("err_Error"), JOptionPane.ERROR_MESSAGE,Common.icon_confirm);
          } else
          {
            label4j_statusBar.setText("Created : " + reportid.getExportFilename());
          }
        }
      }
    });
    btn4jRun.setText(lang.get("btn_Run"));
View Full Code Here
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
  private void copyReport()
  {
    if (jListUserReports.isSelectionEmpty() == false)
    {
      JDBUserReport reportid = (JDBUserReport) ((JDBListData) jListUserReports.getSelectedValue()).getObject();
      String newid = JOptionPane.showInputDialog(Common.mainForm, "Copy report [" + reportid.getReportID() + "] to NEW Report ID");
      if (newid != null)
      {
        if (newid.equals("") == false)
        {
          newid = newid.toUpperCase();
          reportid.getUserReportProperties();
          reportid.setReportID(newid);
          reportid.create(newid);
          reportid.update();
          populateListUserReports(newid);
        }
      }
    }
  }
View Full Code Here
TOP

Related Classes of com.commander4j.db.JDBUserReport

  • au.com.bytecode.opencsv.CSVWriter
  • com.commander4j.app.JInternalFrameUserReportAdmin
  • com.commander4j.db.JDBUser
  • com.commander4j.email.JeMail
  • com.commander4j.util.JExcel
  • com.commander4j.util.JFileFilterCSV
  • com.commander4j.util.JFileFilterMDB
  • com.commander4j.util.JFileFilterPDF
  • com.commander4j.util.JFileFilterXLS
  • com.healthmarketscience.jackcess.Database
    • 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.