예제 #1
0
  /**
   * Creates a new <code>AccountingEntryDialog</code> to let the user edit an existing entry.
   *
   * @param parent This dialog's parent frame.
   * @param modal Whether this dialog should be modal or not.
   * @param dbcon A connection to the database where the accounting information is stored.
   * @param ID The ID of the entry to be edited.
   * @see salssuite.server.module.AccountingModule#buildDatabase
   */
  public AccountingEntryDialog(java.awt.Frame parent, boolean modal, Connection dbcon, int ID) {
    this(parent, modal, dbcon);
    this.ID = ID;

    // overwrite default values loaded in other constructor
    try {
      ResultSet entry = stmt.executeQuery("SELECT * FROM accounting " + "WHERE id = " + ID);
      entry.next();

      date = entry.getString("date");
      String[] dateParts = Util.parseDateString(date);
      dayInput.setText(dateParts[2]);
      monthInput.setText(dateParts[1]);
      yearInput.setText(dateParts[0]);

      time = entry.getString("time");
      String[] timeParts = Util.parseTimeString(time);
      hourInput.setText(timeParts[0]);
      minutesInput.setText(timeParts[1]);
      secondsInput.setText(timeParts[2]);

      outgoInput.setText(entry.getString("outgo").replaceAll("-", ""));
      incomeInput.setText(entry.getString("income"));
      descriptionInput.setText(entry.getString("description"));
    } catch (SQLException e) {
      JOptionPane.showMessageDialog(
          this,
          "Fehler bei der Kommunikation mit der" + " Datenbank",
          "Netzwerkfehler",
          JOptionPane.ERROR_MESSAGE);
      e.printStackTrace();
      return;
    }

    setTitle("Eintrag bearbeiten");
    outgoInput.requestFocus();
  }
  /**
   * Sets the order represented by this component. The visual representation is done accordingly.
   *
   * @param orderID The order to be represented.
   * @param companyID The company which has ordered something.
   */
  public void setOrder(int orderID, int companyID) {

    this.orderID = orderID;

    try {

      // fetch data from the database
      ResultSet order = stmt.executeQuery("SELECT * FROM orders WHERE " + "id = " + orderID);
      order.next();

      // do visual representation
      IDDisplay.setText("" + orderID);
      companyInput.setText("" + order.getInt("companyId"));
      String[] date = Util.parseDateString(order.getString("date"));
      String[] time = Util.parseTimeString(order.getString("time"));

      if (!(date == null) && !(time == null)) {
        dayInput.setText(date[2]);
        monthInput.setText(date[1]);
        yearInput.setText(date[0]);
        hourInput.setText(time[0]);
        minuteInput.setText(time[1]);
      }

      if (order.getInt("processed") == 1) isOrderProcessedCheckbox.setSelected(true);
      else isOrderProcessedCheckbox.setSelected(false);

      if (order.getInt("paid") == 1) isOrderPaidCheckbox.setSelected(true);
      else isOrderPaidCheckbox.setSelected(false);

      // process the wares belonging to this order
      ResultSet orderedWares =
          stmt.executeQuery(
              "SELECT wareId, pieces FROM"
                  + " orderParts WHERE orderId = "
                  + orderID
                  + " ORDER BY (wareId)");

      while (orderedWares.next()) {

        Statement stmt2 = client.getDatabaseConnection().createStatement();
        ResultSet ware =
            stmt2.executeQuery(
                "SELECT name FROM goods " + "WHERE id = " + orderedWares.getInt("wareId"));
        ware.next();

        // new entry for ware display
        String wareEntry = "";
        wareEntry += orderedWares.getInt("wareId") + " // ";
        wareEntry += ware.getString("name") + " // ";
        wareEntry += orderedWares.getInt("pieces");

        wareListModel.addElement(wareEntry);
      }

    } catch (SQLException e) {
      JOptionPane.showMessageDialog(
          client,
          "Fehler bei der Kommunikation" + "mit der Datenbank.",
          "Netzwerkfehler",
          JOptionPane.ERROR_MESSAGE);
      e.printStackTrace();
      return;
    }

    // update total numbers
    updateTotalNumbers();
  }