/**
   * @see
   *     org.kuali.kfs.module.ar.document.service.InvoiceRecurrenceService#isValidEndDateAndTotalRecurrenceNumber(Date,Date,int,String)
   */
  @Override
  public boolean isValidEndDateAndTotalRecurrenceNumber(
      Date recurrenceBeginDate,
      Date recurrenceEndDate,
      Integer totalRecurrenceNumber,
      String recurrenceIntervalCode) {

    if (ObjectUtils.isNull(recurrenceBeginDate)
        || ObjectUtils.isNull(recurrenceIntervalCode)
        || ObjectUtils.isNull(recurrenceEndDate)
        || ObjectUtils.isNull(totalRecurrenceNumber)) {
      return true;
    }

    Calendar beginCalendar = Calendar.getInstance();
    beginCalendar.setTime(recurrenceBeginDate);
    Date beginDate = recurrenceBeginDate;
    Calendar endCalendar = Calendar.getInstance();
    endCalendar.setTime(recurrenceEndDate);
    Date endDate = recurrenceEndDate;
    Calendar nextCalendar = Calendar.getInstance();
    Date nextDate = beginDate;

    int totalRecurrences = 0;
    int addCounter = 0;
    String intervalCode = recurrenceIntervalCode;
    if (intervalCode.equals("M")) {
      addCounter = 1;
    }
    if (intervalCode.equals("Q")) {
      addCounter = 3;
    }
    /* perform this loop while begin_date is less than or equal to end_date */
    while (!(beginDate.after(endDate))) {
      beginCalendar.setTime(beginDate);
      beginCalendar.add(Calendar.MONTH, addCounter);
      beginDate = KfsDateUtils.convertToSqlDate(beginCalendar.getTime());
      totalRecurrences++;

      nextDate = beginDate;
      nextCalendar.setTime(nextDate);
      nextCalendar.add(Calendar.MONTH, addCounter);
      nextDate = KfsDateUtils.convertToSqlDate(nextCalendar.getTime());
      if (endDate.after(beginDate) && endDate.before(nextDate)) {
        totalRecurrences++;
        break;
      }
    }
    if (totalRecurrences != totalRecurrenceNumber.intValue()) {
      return false;
    }

    return true;
  }
 @Override
 protected boolean isValidDate() {
   Date startDate = Date.valueOf("2005-04-30");
   Date endDate = Date.valueOf("2005-06-01");
   Date parsingDate = Date.valueOf(getYear() + "-" + getMonth() + "-" + "01");
   if (parsingDate.after(startDate) && parsingDate.before(endDate)) return true;
   else return false;
 }
 private void validateHomework(Homework homework, Errors errors) {
   if (homework.getStartDate().after(homework.getEndDate()))
     errors.rejectValue("homework.endDate", "date", "Start date cannot be after end date");
   java.sql.Date currDate = getCurrentDate();
   if (currDate.after(homework.getStartDate()))
     errors.rejectValue("homework.startDate", "date", "Start date cannot be before today");
   if (currDate.after(homework.getEndDate()))
     errors.rejectValue("homework.endDate", "date", "End date cannot be before today");
   if (homework.getNumAttempts() < 0)
     errors.rejectValue("homework.numAttempts", "date", "Attempts should be 0 or more ");
   if (homework.getCorrectPts() <= 0)
     errors.rejectValue("homework.correctPts", "date", "Points cannot be less than 1");
   if (homework.getIncorrectPts() < 0)
     errors.rejectValue("homework.incorrectPts", "date", "Points cannot be less than 0");
   int maxQuestions =
       this.questionService.getNumberOfQuestionsInTheTopic(homework.getTopic(), errors);
   if (homework.getNumQuestions() > maxQuestions)
     errors.rejectValue(
         "homework.numQuestions", "date", "This topic has " + maxQuestions + "questions");
 }
  public static IntervalXYDataset createDatasetBar() throws Exception {
    IntervalXYDataset dataset1 = null;
    Object[][] chart = null;
    Object[][] chart_qu = null;
    TCarRecordDao tdao = new TCarRecordDao();
    TimeSeries s1, s2;
    TimeSeriesCollection dataset = new TimeSeriesCollection();
    try {
      if (type == 0) {
        // 从DAO层获得数据,以天为统计单位,数据线以天为单位
        chart = tdao.getCarRecodebyTimearea_day(timefrom, timeto, 1);
        chart_qu = tdao.getCarRecodebyTimearea_day(timefrom, timeto, 0);
        s1 = new TimeSeries("入场柱形", Day.class);
        s2 = new TimeSeries("出场柱形", Day.class);
      } else {

        // 传进DAO层的数据是年月,数据线以月的单位
        Date date = java.sql.Date.valueOf(timefrom);
        Date date_t = java.sql.Date.valueOf(timeto);
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        String newdate_from = sdf.format(date);
        String timefrom_temp = newdate_from.substring(0, 7);
        String newdate_to = sdf.format(date_t);
        String timeto_temp = newdate_to.substring(0, 7);
        chart = tdao.getCarRecodebyTimearea_month(timefrom_temp, timeto_temp, 1);
        chart_qu = tdao.getCarRecodebyTimearea_month(timefrom_temp, timeto_temp, 0);
        s1 = new TimeSeries("入场柱形", Month.class);
        s2 = new TimeSeries("出场柱形", Month.class);
      }

      s1.clear();
      Date d, min_r = null, min_c = null, max_r = null, max_c = null;
      double h;
      if (chart != null && chart.length > 0) { // 数据为空的处理
        System.out.println("ff");
        min_r = (Date) chart[0][1];
        max_r = (Date) chart[0][1];
        for (int i = 0; i < chart.length; i++) {
          d = (Date) chart[i][1];
          if (d.before(min_r)) min_r = d;
          if (d.after(max_r)) max_r = d;
          h = new Double(chart[i][0].toString());
          // 添加数据,0是以天为单位,1是以月为单位
          if (type == 0) s1.add(new Day(d.getDate(), (d.getMonth() + 1), (d.getYear() + 1900)), h);
          else s1.add(new Month((d.getMonth() + 1), (d.getYear() + 1900)), h);
        }
        dataset.addSeries(s1);
      } else s1 = null;

      s2.clear();

      if (chart_qu != null && chart_qu.length > 0) {
        min_c = (Date) chart_qu[0][1];
        max_c = (Date) chart_qu[0][1];
        for (int i = 0; i < chart_qu.length; i++) {
          d = (Date) chart_qu[i][1];
          if (d.before(min_c)) min_c = d;
          if (d.after(max_c)) max_c = d;
          h = new Double(chart_qu[i][0].toString());
          if (type == 0) s2.add(new Day(d.getDate(), (d.getMonth() + 1), (d.getYear() + 1900)), h);
          else s2.add(new Month((d.getMonth() + 1), (d.getYear() + 1900)), h);
        }
        dataset.addSeries(s2);
      } else s2 = null;

      // 取得有数据的时间段的开始和结束
      if (min_c != null && min_r != null) min = min_c.before(min_r) ? min_c : min_r;
      else if (min_c != null) min = min_c;
      else if (min_r != null) min = min_r;
      else min = null;

      if (max_c != null && max_r != null) max = max_c.before(max_r) ? max_r : max_c;
      else if (max_c != null) max = max_c;
      else if (max_r != null) max = max_r;
      else max = null;

      int seriesCount = dataset.getSeriesCount(); // 一共有多少个序列,目前为一个
      for (int i = 0; i < seriesCount; i++) {
        int itemCount = dataset.getItemCount(i); // 每一个序列有多少个数据项
        for (int j = 0; j < itemCount; j++) {
          if (highValue_Y < dataset.getYValue(i, j)) { // 取第i个序列中的第j个数据项的最大值
            highValue_Y = (int) dataset.getYValue(i, j);
          }
          if (minValue_Y > dataset.getYValue(i, j)) { // 取第i个序列中的第j个数据项的最小值
            minValue_Y = (int) dataset.getYValue(i, j);
          }
        }
      }

      dataset1 = dataset;
      return dataset1;
    } catch (Exception e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
      return dataset1;
    }
  }
  /**
   * Launches the interactive account manager.
   *
   * @param args ignored
   */
  public static void main(String[] args) {
    // LOW rework this crap
    Util.printSection("Account Management");

    _log.info("Please choose:");
    // _log.info("list - list registered accounts");
    _log.info("reg - register a new account");
    _log.info("rem - remove a registered account");
    _log.info("prom - promote a registered account");
    _log.info("dem - demote a registered account");
    _log.info("ban - ban a registered account");
    _log.info("unban - unban a registered account");
    _log.info("quit - exit this application");

    BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
    L2AccountManager acm = new L2AccountManager();

    String line;
    try {
      while ((line = br.readLine()) != null) {
        line = line.trim();
        Connection con = null;
        switch (acm.getState()) {
          case USER_NAME:
            line = line.toLowerCase();
            try {
              con = L2Database.getConnection();
              PreparedStatement ps =
                  con.prepareStatement("SELECT superuser FROM account WHERE username LIKE ?");
              ps.setString(1, line);
              ResultSet rs = ps.executeQuery();
              if (!rs.next()) {
                acm.setUser(line);

                _log.info("Desired password:"******"User name already in use.");
                acm.setState(ManagerState.INITIAL_CHOICE);
              }
              rs.close();
              ps.close();
            } catch (SQLException e) {
              _log.error("Could not access database!", e);
              acm.setState(ManagerState.INITIAL_CHOICE);
            } finally {
              L2Database.close(con);
            }
            break;
          case PASSWORD:
            try {
              MessageDigest sha = MessageDigest.getInstance("SHA");
              byte[] pass = sha.digest(line.getBytes("US-ASCII"));
              acm.setPass(HexUtil.bytesToHexString(pass));
            } catch (NoSuchAlgorithmException e) {
              _log.fatal("SHA1 is not available!", e);
              Shutdown.exit(TerminationStatus.ENVIRONMENT_MISSING_COMPONENT_OR_SERVICE);
            } catch (UnsupportedEncodingException e) {
              _log.fatal("ASCII is not available!", e);
              Shutdown.exit(TerminationStatus.ENVIRONMENT_MISSING_COMPONENT_OR_SERVICE);
            }
            _log.info("Super user: [y/n]");
            acm.setState(ManagerState.SUPERUSER);
            break;
          case SUPERUSER:
            try {
              if (line.length() != 1) throw new IllegalArgumentException("One char required.");
              else if (line.charAt(0) == 'y') acm.setSuper(true);
              else if (line.charAt(0) == 'n') acm.setSuper(false);
              else throw new IllegalArgumentException("Invalid choice.");

              _log.info("Date of birth: [yyyy-mm-dd]");
              acm.setState(ManagerState.DOB);
            } catch (IllegalArgumentException e) {
              _log.info("[y/n]?");
            }
            break;
          case DOB:
            try {
              Date d = Date.valueOf(line);
              if (d.after(new Date(System.currentTimeMillis())))
                throw new IllegalArgumentException("Future date specified.");
              acm.setDob(d);

              _log.info("Ban reason ID or nothing:");
              acm.setState(ManagerState.SUSPENDED);
            } catch (IllegalArgumentException e) {
              _log.info("[yyyy-mm-dd] in the past:");
            }
            break;
          case SUSPENDED:
            try {
              if (line.length() > 0) {
                int id = Integer.parseInt(line);
                acm.setBan(L2BanReason.getById(id));
              } else acm.setBan(null);

              try {
                con = L2Database.getConnection();
                PreparedStatement ps =
                    con.prepareStatement(
                        "INSERT INTO account (username, password, superuser, birthDate, banReason) VALUES (?, ?, ?, ?, ?)");
                ps.setString(1, acm.getUser());
                ps.setString(2, acm.getPass());
                ps.setBoolean(3, acm.isSuper());
                ps.setDate(4, acm.getDob());
                L2BanReason lbr = acm.getBan();
                if (lbr == null) ps.setNull(5, Types.INTEGER);
                else ps.setInt(5, lbr.getId());
                ps.executeUpdate();
                _log.info("Account " + acm.getUser() + " has been registered.");
                ps.close();
              } catch (SQLException e) {
                _log.error("Could not register an account!", e);
              } finally {
                L2Database.close(con);
              }
              acm.setState(ManagerState.INITIAL_CHOICE);
            } catch (NumberFormatException e) {
              _log.info("Ban reason ID or nothing:");
            }
            break;
          case REMOVE:
            acm.setUser(line.toLowerCase());
            try {
              con = L2Database.getConnection();
              PreparedStatement ps =
                  con.prepareStatement("DELETE FROM account WHERE username LIKE ?");
              ps.setString(1, acm.getUser());
              int cnt = ps.executeUpdate();
              if (cnt > 0) _log.info("Account " + acm.getUser() + " has been removed.");
              else _log.info("Account " + acm.getUser() + " does not exist!");
              ps.close();
            } catch (SQLException e) {
              _log.error("Could not remove an account!", e);
            } finally {
              L2Database.close(con);
            }
            acm.setState(ManagerState.INITIAL_CHOICE);
            break;
          case PROMOTE:
            acm.setUser(line.toLowerCase());
            try {
              con = L2Database.getConnection();
              PreparedStatement ps =
                  con.prepareStatement("UPDATE account SET superuser = ? WHERE username LIKE ?");
              ps.setBoolean(1, true);
              ps.setString(2, acm.getUser());
              int cnt = ps.executeUpdate();
              if (cnt > 0) _log.info("Account " + acm.getUser() + " has been promoted.");
              else _log.info("Account " + acm.getUser() + " does not exist!");
              ps.close();
            } catch (SQLException e) {
              _log.error("Could not promote an account!", e);
            } finally {
              L2Database.close(con);
            }
            acm.setState(ManagerState.INITIAL_CHOICE);
            break;
          case DEMOTE:
            acm.setUser(line.toLowerCase());
            try {
              con = L2Database.getConnection();
              PreparedStatement ps =
                  con.prepareStatement("UPDATE account SET superuser = ? WHERE username LIKE ?");
              ps.setBoolean(1, false);
              ps.setString(2, acm.getUser());
              int cnt = ps.executeUpdate();
              if (cnt > 0) _log.info("Account " + acm.getUser() + " has been demoted.");
              else _log.info("Account " + acm.getUser() + " does not exist!");
              ps.close();
            } catch (SQLException e) {
              _log.error("Could not demote an account!", e);
            } finally {
              L2Database.close(con);
            }
            acm.setState(ManagerState.INITIAL_CHOICE);
            break;
          case UNBAN:
            acm.setUser(line.toLowerCase());
            try {
              con = L2Database.getConnection();
              PreparedStatement ps =
                  con.prepareStatement("UPDATE account SET banReason = ? WHERE username LIKE ?");
              ps.setNull(1, Types.INTEGER);
              ps.setString(2, acm.getUser());
              int cnt = ps.executeUpdate();
              if (cnt > 0) _log.info("Account " + acm.getUser() + " has been unbanned.");
              else _log.info("Account " + acm.getUser() + " does not exist!");
              ps.close();
            } catch (SQLException e) {
              _log.error("Could not demote an account!", e);
            } finally {
              L2Database.close(con);
            }
            acm.setState(ManagerState.INITIAL_CHOICE);
            break;
          case BAN:
            line = line.toLowerCase();
            try {
              con = L2Database.getConnection();
              PreparedStatement ps =
                  con.prepareStatement("SELECT superuser FROM account WHERE username LIKE ?");
              ps.setString(1, line);
              ResultSet rs = ps.executeQuery();
              if (rs.next()) {
                acm.setUser(line);

                _log.info("Ban reason ID:");
                acm.setState(ManagerState.REASON);
              } else {
                _log.info("Account does not exist.");
                acm.setState(ManagerState.INITIAL_CHOICE);
              }
              rs.close();
              ps.close();
            } catch (SQLException e) {
              _log.error("Could not access database!", e);
              acm.setState(ManagerState.INITIAL_CHOICE);
            } finally {
              L2Database.close(con);
            }
            break;
          case REASON:
            try {
              int ban = Integer.parseInt(line);
              con = L2Database.getConnection();
              PreparedStatement ps =
                  con.prepareStatement("UPDATE account SET banReason = ? WHERE username LIKE ?");
              ps.setInt(1, ban);
              ps.setString(2, acm.getUser());
              ps.executeUpdate();
              _log.info("Account " + acm.getUser() + " has been banned.");
              ps.close();
            } catch (NumberFormatException e) {
              _log.info("Ban reason ID:");
            } catch (SQLException e) {
              _log.error("Could not ban an account!", e);
            } finally {
              L2Database.close(con);
            }
            acm.setState(ManagerState.INITIAL_CHOICE);
            break;
          default:
            line = line.toLowerCase();
            if (line.equals("reg")) {
              _log.info("Desired user name:");
              acm.setState(ManagerState.USER_NAME);
            } else if (line.equals("rem")) {
              _log.info("User name:");
              acm.setState(ManagerState.REMOVE);
            } else if (line.equals("prom")) {
              _log.info("User name:");
              acm.setState(ManagerState.PROMOTE);
            } else if (line.equals("dem")) {
              _log.info("User name:");
              acm.setState(ManagerState.DEMOTE);
            } else if (line.equals("unban")) {
              _log.info("User name:");
              acm.setState(ManagerState.UNBAN);
            } else if (line.equals("ban")) {
              _log.info("User name:");
              acm.setState(ManagerState.BAN);
            } else if (line.equals("quit")) Shutdown.exit(TerminationStatus.MANUAL_SHUTDOWN);
            else _log.info("Incorrect command.");
            break;
        }
      }
    } catch (IOException e) {
      _log.fatal("Could not process input!", e);
    } finally {
      IOUtils.closeQuietly(br);
    }
  }
示例#6
0
  /**
   * This is the main controller logic for item selection servlet. This determines whether to show a
   * list of items for a WorkOrder, add a item, edit a item's detail information, or delete a item.
   * The product_action parameter is past to this servlet to determine what action to perform. The
   * product_action parameter is a button defined by JSPs related to product presentation screens.
   *
   * <p>The default action is to show all product related to a parent WorkOrder.
   *
   * @param req HttpServlet request
   * @param resp HttpServlet response
   */
  public void doPost(HttpServletRequest req, HttpServletResponse resp)
      throws ServletException, IOException {
    WorkOrderDetailRemote workorderdetEJBean = null;

    securityChecks(req, resp);

    // Get the current session
    HttpSession session = req.getSession(false);
    if (session == null) return;

    String sTmp = "";

    // Get a new business logic EJB (custInfoEJBean)
    USFEnv.getLog().writeDebug("getting buslogic EJB", this, null);
    try {
      workorderdetEJBean = workorderdetHome.create();
      USFEnv.getLog().writeDebug("EJBean Created", this, null);
    } catch (CreateException e) {
      String errorMsg = "Critical Exception in ItemsServlet";
      USFEnv.getLog().writeCrit(errorMsg + " failed EJB creation", this, e);
      errorJSP(req, resp, errorMsg);
      return;
    } catch (RemoteException e) {
      String errorMsg = "Critical Exception in ItemsServlet";
      USFEnv.getLog().writeCrit(errorMsg + " failed EJB connect", this, e);
      errorJSP(req, resp, errorMsg);
      return;
    } catch (Exception e) {
      String errorMsg = "Critical Exception no EJB created";
      USFEnv.getLog().writeCrit(errorMsg + " failed EJB creation", this, e);
      errorJSP(req, resp, errorMsg);
      return;
    }

    try {

      // Button user pressed in the itemselection.jsp
      String sJSPAction = req.getParameter("product_action");
      USFEnv.getLog().writeWarn("product_action from JSP: " + sJSPAction, this, null);

      short year = Short.valueOf((String) session.getValue("Iyear")).shortValue();
      long customerId = Long.valueOf((String) session.getValue("rcustId")).longValue();
      long applicationId = Long.valueOf((String) session.getValue("rappid")).longValue();
      long workorderId = 0;
      long bkId = 0;
      long billkeyId = 0;
      long bsId = 0;
      long wodId = 0;
      String editflag = "";
      String bsNm = "";

      java.sql.Date strtDate = null;
      java.sql.Date endDate = null;
      String prodError = "";

      // Check to make sure session does have an WorkOrder ID
      if (session.getValue("WorkOrderId") != null) {
        // If Yes get the parent WorkOrder ID from session
        workorderId = Long.valueOf((String) session.getValue("WorkOrderId")).longValue();
      }

      // Button Action from JSP is empty then show the Default page of the
      // Product Listing.
      if (USFUtil.isBlank(sJSPAction)) {
        USFEnv.getLog().writeDebug("Display product list for FRN.", this, null);
        // list items for parent Work Order Number

        Vector billingsystems = null;

        WrkOrdrDets workorderdets = new WrkOrdrDets();

        billingsystems = workorderdets.getBillingSystems();

        req.setAttribute("BillingSystems", billingsystems);

        for (int s = 0; s < billingsystems.size(); s++)
          USFEnv.getLog()
              .writeDebug("INSIDE BILLING SYSTEMS " + billingsystems.elementAt(s), this, null);

        listProducts(workorderId, workorderdetEJBean, session, req, resp);
        return;
      }

      // Button action from JSP is to Add a new Item
      else if (sJSPAction.equals("add")) {
        // Remove the Product Object from session
        session.removeValue("prodObj");

        editflag = "addnew";
        req.setAttribute("editflag", editflag);

        // Read the Item and the Billing System for adding the New
        // Item.
        String formProdBsId = (String) req.getParameter("formProdId");
        String formProdId = formProdBsId.substring(0, formProdBsId.indexOf("|"));
        String formProdName = formProdBsId.substring(formProdBsId.indexOf("|") + 1);
        long rscId = (new Long(formProdId).longValue());
        // bsId = (new Long( formBsId ).longValue()) ;
        String billSystem = formProdName.substring(0, formProdName.indexOf("-"));
        String itemName = formProdName.substring(formProdName.indexOf("-") + 1);

        BlgSys blgSys = new BlgSys();
        bsId = blgSys.getBsId(billSystem);

        // Create db connection for EJB
        workorderdetEJBean.connect();

        // Get the WorkOrder Object.
        WorkOrder woObj = workorderdetEJBean.getWorkOrderInfo(workorderId);

        // Get the list of Billing Keys for the Billing System.
        String[] blgKeys = workorderdetEJBean.getBillingKeys(customerId, bsId);

        // Release db connection for EJB
        workorderdetEJBean.release();

        // If no Billing Keys for the Billing System selected then redirect
        // to the List Items screen and show the error Message.
        if (blgKeys == null) {
          BlgSys blgsys = new BlgSys();
          Hashtable bSysList = (Hashtable) blgsys.searchBlgSys();
          //	Hashtable bSysList = (Hashtable) USFEnv.getBillSystems();

          // Set the JSP error message
          req.setAttribute("errorMsg", "No BTNs for Billing System " + billSystem);

          // list products for parent WorkOrder Number
          listProducts(workorderId, workorderdetEJBean, session, req, resp);
          return;
        }

        req.setAttribute("prodcredit", "N");
        req.setAttribute("bsystem", String.valueOf(bsId));
        req.setAttribute("bkList", blgKeys);
        req.setAttribute("prodId", formProdId);
        String wid = String.valueOf(workorderId);

        session.putValue("workorderId", wid);

        req.setAttribute("billingsystem", billSystem);

        req.setAttribute("itemname", itemName);

        // Include the JSP to Edit Product
        includeJSP(req, resp, ITEM_JSP_PATH, "editItem");
        return;
      }

      // Button action from JSP is to Edit a Product
      else if (sJSPAction.equals("edit")) {
        String bsysid = req.getParameter("bsId");
        session.putValue("bysysidforedit", bsysid);

        wodId = (new Long((String) req.getParameter("wodId"))).longValue();
        // bkId = (new Long( (String) req.getParameter("bkId"))).longValue() ;

        session.putValue("workorderdetid", String.valueOf(wodId));

        bsId = (new Long((String) req.getParameter("bsId"))).longValue();

        BlgSys blgSys = new BlgSys();
        bsNm = blgSys.getBsName(bsId);

        // Create db connection for EJB
        workorderdetEJBean.connect();

        // WorkOrder woObj = workorderdetEJBean.getWorkOrderInfo(workorderId);

        // Get the WorkOrder Number Object
        WrkOrdrDets wodets_obj = new WrkOrdrDets();
        wodets_obj = workorderdetEJBean.getProductInfo(wodId);

        // Get the List of Billing Keys for the Billing System.
        String[] blgKeys = workorderdetEJBean.getBillingKeys(customerId, bsId);

        // Check if the Item has any Credits. If any credits then Billing
        // Key is not Editable else Editable.
        if (workorderdetEJBean.hasCredits(wodId)) {
          req.setAttribute("prodcredit", "Y");
        } else {
          req.setAttribute("prodcredit", "N");
        }

        // Release db connection for EJB
        workorderdetEJBean.release();

        // If Item Object is not null (which generally is the case) then
        // set the Attributes for the JSP.
        if (wodets_obj != null) {
          // Put the Item Object in session
          editflag = "edit";
          session.putValue("wodets", wodets_obj);
          req.setAttribute("editflag", editflag);

          // Set the attributes for the Billing System, Billing Key List,
          req.setAttribute("bkList", blgKeys);
          req.setAttribute("bsname", bsNm);

          // Include the JSP to Edit the Item.
          includeJSP(req, resp, ITEM_JSP_PATH, "editItem");
          return;
        }

        // If Item Object is null (which generally should not Occur) show
        // the Default page of Item List for the WorkOrder Number
        else {
          // Set the JSP error message
          req.setAttribute(
              "errorMsg", "Product Key - " + wodId + " Information not available in the Data Base");

          // list items for parent WorkOrder Number
          listProducts(workorderId, workorderdetEJBean, session, req, resp);
          return;
        }

      }

      // Button action from JSP is to Delete an Item
      else if (sJSPAction.equals("delete")) {
        String formWodId = req.getParameter("wodId");

        wodId = (new Long((String) req.getParameter("wodId"))).longValue();

        // Create db connection for EJB
        workorderdetEJBean.connect();

        // Delete the Item
        if (workorderdetEJBean.deleteProduct(wodId)) {
          req.setAttribute("errorMsg", "Product Key - " + wodId + " Deleted");
        } else {
          req.setAttribute(
              "errorMsg",
              "Deletion Failed. Product Key - " + wodId + " is associated with amounts.");
        }
        // Release db connection for EJB
        workorderdetEJBean.release();

        // Show the Item List screen
        listProducts(workorderId, workorderdetEJBean, session, req, resp);
        return;

      }

      // Button action from JSP is to Save a Product. This includes Insertion
      // of New Product or Updation of an Existing Product.

      else if (sJSPAction.equals("save")) {
        boolean save = false;
        boolean newProd = false;
        // long qty=0;

        // Read the Billing System Id
        String formBsId = (String) req.getParameter("bs_id");

        String bsysid = (String) req.getParameter("bsysid");
        /*
        String trans_type = (String) req.getParameter("trans_type");

        //String quantity = (String) req.getParameter("qty");
        String quantity="";
        if (!(req.getParameter("qty").equals("")))
        {
        	quantity=(String) req.getParameter("qty");

        	qty = (new Long(quantity).longValue());
        } */
        String prod_stat = (String) req.getParameter("prod_stat");

        double nrcg_dscnt =
            (new Double((String) req.getParameter("NonRecurringDiscount"))).doubleValue();

        double rcg_dscnt =
            (new Double((String) req.getParameter("RecurringDiscount"))).doubleValue();

        String start_month = (String) req.getParameter("strt_month");
        String start_day = (String) req.getParameter("strt_day");
        String start_year = (String) req.getParameter("strt_year");
        String end_month = (String) req.getParameter("end_month");
        String end_day = (String) req.getParameter("end_day");
        String end_year = (String) req.getParameter("end_year");

        String start_date = start_month + "-" + start_day + "-" + start_year;

        String end_date = end_month + "-" + end_day + "-" + end_year;

        long wrkordrid = (new Long((String) session.getValue("WorkOrderId"))).longValue();

        String for_editing = req.getParameter("for_editing");
        String for_new = req.getParameter("for_new");

        String formBkId = (String) req.getParameter("bk_id");

        String formBKId = formBkId.substring(0, formBkId.indexOf("|"));

        String formBTN = formBkId.substring(formBkId.indexOf("|") + 1);

        billkeyId = (new Long(formBKId)).longValue();

        try {
          bsId = (new Long((String) req.getParameter("bs_id"))).longValue();
        } catch (Exception e) {
          USFEnv.getLog().writeDebug("Exception is " + e, this, null);
        }

        RHCCBlgKeys blgkeys = new RHCCBlgKeys();

        if (for_editing.equals("editing")) {
          blgkeys.setRbkId(billkeyId);
          blgkeys.setRbkKeys(formBTN);
          blgkeys.setBsId(new Long(bsysid).longValue());
        }

        if (for_new.equals("new")) {
          blgkeys.setRbkId(billkeyId);
          blgkeys.setRbkKeys(formBTN);
          blgkeys.setBsId(bsId);
        }

        int index = 0;

        WrkOrdrDets wod_obj = new WrkOrdrDets();

        // wod_obj.setTxTyp(trans_type);
        // wod_obj.setQty(qty);
        wod_obj.setNonRcrgDscnt(nrcg_dscnt);
        wod_obj.setRcrgDscnt(rcg_dscnt);
        wod_obj.setRBKID(billkeyId);
        wod_obj.setWodStat(prod_stat);
        wod_obj.setWOID(wrkordrid);

        if (!(start_date.equals(""))) {
          strtDate =
              new java.sql.Date((new SimpleDateFormat("MM-dd-yyyy")).parse(start_date).getTime());
          wod_obj.setStrtDat(strtDate);
        }
        // Else if the Start Date is null update the Item Object Date to
        // null
        else {
          wod_obj.setStrtDat(null);
        }

        // If Item Service End Date is not null read the date and update
        // the Item Object with the date
        if (!(end_date.equals(""))) {
          endDate =
              new java.sql.Date((new SimpleDateFormat("MM-dd-yyyy")).parse(end_date).getTime());
          wod_obj.setEndDat(endDate);
        }
        // Else if the End Date is null update the Item Object Date to null
        else {
          wod_obj.setEndDat(null);
        }

        // Check if the Start Date is after the End Date or equals End Date
        if ((strtDate != null) && (endDate != null) && (strtDate.after(endDate))) {
          prodError = "Product Service Start Date is after Product Service End Date. \n";
          index = 1;
        } else if ((strtDate != null) && (endDate != null) && (strtDate.equals(endDate))) {
          prodError = "Product Service Start Date equals Product Service End Date. \n";
        }

        workorderdetEJBean.connect();

        if (for_editing.equals("editing")) {
          long workorderdetID = (new Long((String) session.getValue("workorderdetid"))).longValue();
          wod_obj.setWODID(workorderdetID);

          if (index == 0) {
            save = workorderdetEJBean.saveProduct(wod_obj);
          }

          if (save) {
            prodError =
                prodError + "<BR> Product Key - " + wod_obj.getWODID() + " Information updated";
            req.setAttribute("error", prodError);
          } else {
            prodError = prodError + "<BR> Failed to update Product Information";
            req.setAttribute("error", prodError);
          }
        }

        if (for_new.equals("new")) {
          if (index == 0) {
            int prodId = Integer.parseInt(req.getParameter("prod_Id"));
            wod_obj.setProd_id(prodId);
            save = workorderdetEJBean.saveProduct(wod_obj);
          }

          if (save) {
            prodError =
                prodError + "<BR> Product Key - " + wod_obj.getWODID() + " Information Saved";
            req.setAttribute("error", prodError);
          } else {
            prodError = prodError + "<BR> Failed to Save Product Information";
            req.setAttribute("error", prodError);
          }
        }

        workorderdetEJBean.release();

        listProducts(wrkordrid, workorderdetEJBean, session, req, resp);
      }

    } // End of try block
    catch (Exception e) {
      if (workorderdetEJBean != null) {
        // calling bean release method
        try {
          workorderdetEJBean.release();
        } catch (Exception ex) {
          USFEnv.getLog().writeCrit(" Exception in calling release() method ", this, e);
        }
      }
      String errorMsg = "Processing Exception in Items Servlet: ";
      USFEnv.getLog().writeCrit(errorMsg, this, e);
      errorJSP(req, resp, errorMsg);
    } // End of catch block
  } // end of doPost()
示例#7
0
  /** Non-exception-aware version of the above. */
  protected Status trySendRetentionEmail(int memberId, Date secondEmailCutoff, NewStuff filler) {
    SpamRecord spamRec = _spamRepo.loadSpamRecord(memberId);
    Date last = spamRec == null ? null : spamRec.retentionSent;
    Status status = last == null ? null : Status.lookup(spamRec.retentionStatus);

    if (last != null && last.after(secondEmailCutoff) && status != null && status.success) {
      // spammed recently, skip
      return Status.TOO_RECENTLY_SPAMMED;
    }

    // load the member
    MemberRecord mrec = _memberRepo.loadMember(memberId);
    if (mrec == null) {
      log.warning("Member deleted during retention mailing?", "memberId", memberId);
      return Status.MEMBER_DELETED;
    }

    // skip placeholder addresses
    if (MemberMailUtil.isPlaceholderAddress(mrec.accountName)) {
      return Status.PLACEHOLDER_ADDRESS;
    }

    // skip invalid addresses
    if (!MailUtil.isValidAddress(mrec.accountName)) {
      return Status.INVALID_ADDRESS;
    }

    // oh look, they've logged in! maybe the email(s) worked. clear counter
    boolean persuaded = (last != null) && mrec.lastSession.after(last);
    if (persuaded) {
      spamRec.retentionCountSinceLogin = 0;
      // fall through, we'll send a mail and save the record below

    } else if (status == Status.NOT_ENOUGH_FRIENDS || status == Status.NOT_ENOUGH_NEWS) {
      // reset legacy failures, we now send filler for these people
      spamRec.retentionCountSinceLogin = 0;
      // fall through, we'll send a mail and save the record below

    } else if (spamRec != null && spamRec.retentionCountSinceLogin >= 2) {
      // they are never coming back... oh well, there are plenty of other fish in the sea
      return Status.LOST_CAUSE;
    }

    // sending the email could take a while so update the spam record here to reduce window
    // where other peers may conflict with us. NOTE: we do plan to run this job on multiple
    // servers some day
    _spamRepo.noteRetentionEmailSending(memberId, spamRec);

    // choose a successful result based on previous attempts
    status = Status.SENT_DORMANT;
    if (persuaded) {
      status = Status.SENT_PERSUADED;
    } else if (spamRec == null || spamRec.retentionCount == 0) {
      status = Status.SENT_LAPSED;
    }

    // now send the email
    MailContent content = sendRetentionEmail(mrec, null, filler, true);

    // NOTE: this is sort of redundant but increases the integrity of the spam record and
    // reduces chance of a user getting two emails when we are 1M strong
    _spamRepo.noteRetentionEmailResult(memberId, status.value);

    // log an event for successes. the result is the lapse status
    if (status.success) {
      _eventLog.retentionMailSent(
          mrec.memberId,
          mrec.visitorId,
          status.name(),
          content.subjectLine,
          content.bucket.name,
          content.numFriends,
          content.numPersonalMessages,
          mrec.isValidated());
    }

    return status;
  }
示例#8
0
  public static int addPlan(Plan plan)
      throws SQLException, TextFormatException, JSONException, NoSuchAlgorithmException,
          UnsupportedEncodingException {

    if (plan == null) {
      logger.error("Can't add empty plan");
      return -1;
    }

    String SQLCommand = null;
    DBUtil du = DBUtil.getDBUtil();
    ResultSet rs;

    String title = plan.getTitle();
    String siteIDs = plan.getSiteIDs();
    int organizer = plan.getOrganizer();
    Date startTime = plan.getStartTime();
    Date endTime = plan.getEndTime();
    String describe = plan.getDescribe();
    if (Util.isEmpty(siteIDs)
        || organizer < 0
        || startTime == null
        || endTime == null
        || startTime.after(endTime)) {
      logger.error("illegal plan");
      return -1;
    }
    SQLCommand =
        " insert into "
            + tableName
            + " ( title, siteIDs, startTime, endTime, organizer, participants, budget, groupNum, groupNumMax, isDone, information ) "
            + " values ( '"
            + title
            + "' , '"
            + siteIDs
            + "' , '"
            + startTime
            + "' , '"
            + endTime
            + "' , "
            + organizer
            + " , '"
            + plan.getParticipants()
            + "' , "
            + plan.getBudget()
            + " , "
            + plan.getGroupNum()
            + " , "
            + plan.getGroupNumMax()
            + " , false , '"
            + describe
            + "')";
    System.out.println(SQLCommand);
    rs = du.executeUpdate(SQLCommand);
    rs.next();
    int planID = rs.getInt(1);
    // Plan new_plan = new Plan(planID, title, siteIDs, startTime, endTime, organizer,
    // plan.getParticipants(), plan.getBudget(), plan.getGroupNum(), plan.getGroupNumMax(),
    // plan.getTalkStreamID(), false);
    /*
    User user = new User();
    String orig_plans =new UserManager().selectUser(organizer).getPlans();
    user.setPlans(new JSONHelper().addToArray(orig_plans, planID));
    new UserManager().editUser(organizer, user);

    Vector<Integer> siteIDVector =new JSONHelper().convertToArray(siteIDs);
    for(int j=0;j<siteIDVector.size();j++){
        int siteID = siteIDVector.get(j);
        SQLCommand = " insert into " + relationTableName +"( userID, siteID, startTime, endTime, planID )" +
                    " values ( " + organizer + " , " + siteID + " , '" + startTime + "' , '" + endTime + "' , " + planID + ")";
        du.executeUpdate(SQLCommand);
    }
    */
    return planID;
  }
示例#9
0
  private void refresh() {
    // validasi input
    Date tanggalmulai = null;
    try {
      tanggalmulai = Date.valueOf(jTextFieldTanggalMulai.getText());
    } catch (IllegalArgumentException e) {
      return;
    }
    Date tanggalselesai = null;
    try {
      tanggalselesai = Date.valueOf(jTextFieldTanggalSelesai.getText());
    } catch (IllegalArgumentException e) {
      return;
    }

    if (tanggalmulai.after(tanggalselesai)) {
      JOptionPane.showMessageDialog(null, "tanggal mulai harus sebelum tanggal selesai");
      return;
    }

    Ruang ruangterpilih = (Ruang) jComboBoxRuang.getModel().getSelectedItem();
    int idruang = ruangterpilih.getId();

    // refresh

    try {
      Transaksi[] alltransaksi =
          this.getMainMenu().getDbc().getTransaksi(idruang, tanggalmulai, tanggalselesai);
      DefaultTableModel model = new DefaultTableModel();
      model.addColumn("id");
      model.addColumn("Nama Kegiatan");
      model.addColumn("Jenis Kegiatan");
      model.addColumn("Tanggal");
      model.addColumn("Waktu Mulai");
      model.addColumn("Waktu Selesai");
      model.addColumn("");
      model.addColumn("");

      // aksi hapus
      Action delete =
          new AbstractAction() {
            @Override
            public void actionPerformed(ActionEvent e) {
              JTable table = (JTable) e.getSource();
              int modelRow = Integer.valueOf(e.getActionCommand());
              int id = (int) table.getModel().getValueAt(modelRow, 0);
              int confirm =
                  JOptionPane.showConfirmDialog(
                      null,
                      "Yakin menghapus transaksi ini?",
                      "Konfirmasi",
                      JOptionPane.YES_NO_OPTION);
              if (confirm == JOptionPane.YES_OPTION) {
                try {
                  getMainMenu().getDbc().deleteTransaksiById(id);
                } catch (SQLException ex) {
                  JOptionPane.showMessageDialog(null, "error: " + ex);
                  Logger.getLogger(jPanelData.class.getName()).log(Level.SEVERE, null, ex);
                }
              }
              refresh();
            }
          };
      // aksi ubah
      Action edit =
          new AbstractAction() {
            @Override
            public void actionPerformed(ActionEvent e) {
              JTable table = (JTable) e.getSource();
              int modelRow = Integer.valueOf(e.getActionCommand());

              TableModel model = table.getModel();
              final JDialog frame = new JDialog(getMainMenu(), "Ubah Data Transaksi", true);
              jPanelEditTransaksi panelinput =
                  new jPanelEditTransaksi(frame, getMainMenu().getDbc());
              panelinput.setTargetId((int) model.getValueAt(modelRow, 0));
              Kuliah k;
              try {
                k = getMainMenu().getDbc().getKuliahTransaksi((int) model.getValueAt(modelRow, 0));
                if (k != null) panelinput.setKuliah(k);
              } catch (SQLException ex) {
                Logger.getLogger(jPanelTransaksi.class.getName()).log(Level.SEVERE, null, ex);
              }
              panelinput.setNamaKegiatan((String) model.getValueAt(modelRow, 1));
              panelinput.setJenisKegiatan((String) model.getValueAt(modelRow, 2));
              panelinput.setTanggalMulai((Date) model.getValueAt(modelRow, 3));
              panelinput.setWaktuMulai((Time) model.getValueAt(modelRow, 4));
              panelinput.setWaktuSelesai((Time) model.getValueAt(modelRow, 5));

              frame.getContentPane().add(panelinput);
              frame.pack();
              frame.setVisible(true);
              refresh();
            }
          };
      for (int i = 0; i < alltransaksi.length; i++) {
        Object[] p = new Object[8];
        p[0] = alltransaksi[i].getId();
        p[1] = alltransaksi[i].getNama_kegiatan();
        p[2] = alltransaksi[i].getJenis_kegiatan();
        p[3] = alltransaksi[i].getTanggal();
        p[4] = alltransaksi[i].getStart_time();
        p[5] = alltransaksi[i].getFinish_time();
        p[6] = "Ubah";
        p[7] = "Hapus";
        model.addRow(p);
      }
      jTable1.setModel(model);

      ButtonColumn buttonColumnDelete = new ButtonColumn(jTable1, delete, 7);
      buttonColumnDelete.setMnemonic(KeyEvent.VK_D);

      ButtonColumn buttonColumnEdit = new ButtonColumn(jTable1, edit, 6);
      buttonColumnEdit.setMnemonic(KeyEvent.VK_D);

      jTable1.removeColumn(jTable1.getColumnModel().getColumn(0));
    } catch (SQLException ex) {
      JOptionPane.showMessageDialog(null, "Error" + ex);
      Logger.getLogger(jPanelData.class.getName()).log(Level.SEVERE, null, ex);
    }
  }