frontpage_jsp.java

国外的一套开源CRM

    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("MN") ? " selected" : "") + ">MN");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("MO") ? " selected" : "") + ">MO");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("MS") ? " selected" : "") + ">MS");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("MT") ? " selected" : "") + ">MT");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("NC") ? " selected" : "") + ">NC");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("ND") ? " selected" : "") + ">ND");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("NE") ? " selected" : "") + ">NE");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("NH") ? " selected" : "") + ">NH");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("NJ") ? " selected" : "") + ">NJ");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("NM") ? " selected" : "") + ">NM");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("NV") ? " selected" : "") + ">NV");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("NY") ? " selected" : "") + ">NY");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("OH") ? " selected" : "") + ">OH");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("OK") ? " selected" : "") + ">OK");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("OR") ? " selected" : "") + ">OR");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("PA") ? " selected" : "") + ">PA");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("PR") ? " selected" : "") + ">PR");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("RI") ? " selected" : "") + ">RI");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("SC") ? " selected" : "") + ">SC");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("SD") ? " selected" : "") + ">SD");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("TN") ? " selected" : "") + ">TN");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("TX") ? " selected" : "") + ">TX");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("UT") ? " selected" : "") + ">UT");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("VA") ? " selected" : "") + ">VA");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("VI") ? " selected" : "") + ">VI");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("VT") ? " selected" : "") + ">VT");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("WA") ? " selected" : "") + ">WA");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("WI") ? " selected" : "") + ">WI");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("WV") ? " selected" : "") + ">WV");
    returnString.append("<option" + (selected != null && selected.equalsIgnoreCase("WY") ? " selected" : "") + ">WY");
    returnString.append("</select>");
    return returnString.toString();
  }




    int daysSinceLastSale(String ownerId, int daysFromHire, GenericDelegator delegator) throws GenericEntityException{
      //find last sale
      Calendar lastSale = Calendar.getInstance();
      HashMap fields = new HashMap();
      fields.put("dealStatusId", "10"); //Sold
      fields.put("ownerId", ownerId);
      ArrayList order = new ArrayList();
      order.add("actualCloseDate");
      order.add("DESC");
      List deals = delegator.findByAnd("Deal", fields, order);
      if(deals.size() >= 1){
        GenericValue details[] = (GenericValue[])deals.toArray(new GenericValue[0]);
        GenericValue deal = details[deals.size()-1];
        lastSale.setTime(deal.getDate("actualCloseDate"));
      } else {
        // No sales yet. Return the number of days since hire.
        return daysFromHire;
      }
      //calc time since last sale
      int returnInt = CalendarUtil.differenceBetweenDates(lastSale, Calendar.getInstance(), Calendar.DAY_OF_YEAR);
      return returnInt;
    }

    int daysSinceLastLeadConversion(String ownerId, int daysFromHire, GenericDelegator delegator) throws GenericEntityException{
      // Find last lead conversion
      Calendar lastLeadConversion = Calendar.getInstance();
      HashMap fields = new HashMap();
      fields.put("statusId", "50"); // Converted
      fields.put("leadOwnerId", ownerId);
      ArrayList order = new ArrayList();
      order.add("convertedDate");
      order.add("DESC");
      List leadL = delegator.findByAnd("Lead", fields, order);
      if(leadL.size() >= 1){
        GenericValue details[] = (GenericValue[])leadL.toArray(new GenericValue[0]);
        GenericValue leadGV = details[leadL.size()-1];
        lastLeadConversion.setTime(leadGV.getTimestamp("convertedDate"));
      } else {
        // No lead conversions yet. Return the number of days since hire.
        return daysFromHire;
      }
      // Calc time since last conversion
      int returnInt = CalendarUtil.differenceBetweenDates(lastLeadConversion, Calendar.getInstance(), Calendar.DAY_OF_YEAR);
      return returnInt;
    }

    double calculateYearlyQuota(String partyId, GenericDelegator delegator) throws GenericEntityException {
        double yearlyQuotaAmount = 0.0;
        HashMap fields = new HashMap();
        fields.put("year", String.valueOf(Calendar.getInstance().get(Calendar.YEAR)));
        fields.put("contactId", partyId);
        List forecastL = delegator.findByAnd("Forecast", fields);
        Iterator forecastI = forecastL.iterator();
        while (forecastI.hasNext()) {
            GenericValue forecastGV = (GenericValue)forecastI.next();
            double quotaAmount = forecastGV.getDouble("quotaAmount")==null ?
                0.0 : forecastGV.getDouble("quotaAmount").doubleValue();
            yearlyQuotaAmount += quotaAmount;
        }
        return yearlyQuotaAmount;
    }

    double calculateYearlySales(String ownerId, GenericDelegator delegator) throws GenericEntityException {
      double actual = 0.0;

      Calendar start = Calendar.getInstance();
      start.set(Calendar.MONTH, Calendar.JANUARY);
      start.set(Calendar.DAY_OF_MONTH, 1);

      Calendar end = Calendar.getInstance();
      end.set(Calendar.MONTH, Calendar.DECEMBER);
      end.set(Calendar.DAY_OF_MONTH, 31);

      ArrayList list = new ArrayList();
      list.add(new EntityExpr("dealStatusId", EntityOperator.EQUALS, "10")); // Sold
      list.add(new EntityExpr("ownerId", EntityOperator.EQUALS, ownerId));
      list.add(new EntityExpr("actualCloseDate", EntityOperator.LESS_THAN_EQUAL_TO, new java.sql.Date( end.getTime().getTime() )));
      list.add(new EntityExpr("actualCloseDate", EntityOperator.GREATER_THAN_EQUAL_TO, new java.sql.Date( start.getTime().getTime() )));

      List opps = delegator.findByAnd("Deal", list, null);
      GenericValue oppDetails[] = (GenericValue[])opps.toArray(new GenericValue[0]);
      GenericValue oppDetail;
      for(int i=0;i<oppDetails.length;i++){
        oppDetail = oppDetails[i];
        actual = actual + oppDetail.getDouble("amount").doubleValue();
      }
      return actual;
    }

    double calculateYearlyExpenses(String ownerId, GenericDelegator delegator) throws GenericEntityException {
      double actual = 0.0;

      Calendar start = Calendar.getInstance();
      start.set(Calendar.MONTH, Calendar.JANUARY);
      start.set(Calendar.DAY_OF_MONTH, 1);

      Calendar end = Calendar.getInstance();
      end.set(Calendar.MONTH, Calendar.DECEMBER);
      end.set(Calendar.DAY_OF_MONTH, 31);

      ArrayList list = new ArrayList();
      list.add(new EntityExpr("expenseOwnerId", EntityOperator.EQUALS, ownerId));
      list.add(new EntityExpr("expenseDate", EntityOperator.LESS_THAN_EQUAL_TO, new java.sql.Date(end.getTime().getTime())));
      list.add(new EntityExpr("expenseDate", EntityOperator.GREATER_THAN_EQUAL_TO, new java.sql.Date(start.getTime().getTime())));

      List expenses = delegator.findByAnd("Expense", list, null);
      GenericValue expenseDetails[] = (GenericValue[])expenses.toArray(new GenericValue[0]);
      GenericValue expenseDetail;
      for(int i=0;i<expenseDetails.length;i++){
        expenseDetail = expenseDetails[i];
        actual = actual + expenseDetail.getDouble("expenseAmount").doubleValue();
      }
      return actual;

    }

    int calculateLeadsConverted(String partyId, Calendar start, Calendar end, GenericDelegator delegator) throws GenericEntityException {
        ArrayList list = new ArrayList();
        list.add(new EntityExpr("leadOwnerId", EntityOperator.EQUALS, partyId));
        list.add(new EntityExpr("statusId", EntityOperator.EQUALS, "50"));
        list.add(new EntityExpr("convertedDate", EntityOperator.GREATER_THAN_EQUAL_TO, new java.sql.Date(start.getTime().getTime())));
        list.add(new EntityExpr("convertedDate", EntityOperator.LESS_THAN_EQUAL_TO, new java.sql.Date(end.getTime().getTime())));
        List leadL = delegator.findByAnd("Lead", list, null);
        return leadL.size();
    }

    int calculateLeadsAssigned(String partyId, Calendar start, Calendar end, GenericDelegator delegator) throws GenericEntityException {
        ArrayList list = new ArrayList();
        list.add(new EntityExpr("leadOwnerId", EntityOperator.EQUALS, partyId));
        list.add(new EntityExpr("assignedDate", EntityOperator.GREATER_THAN_EQUAL_TO, new java.sql.Date(start.getTime().getTime())));
        list.add(new EntityExpr("assignedDate", EntityOperator.LESS_THAN_EQUAL_TO, new java.sql.Date(end.getTime().getTime())));
        List leadL = delegator.findByAnd("Lead", list, null);

        return leadL.size();
    }

    Date getHireDate(String partyId, GenericDelegator delegator) throws GenericEntityException {
      HashMap fields = new HashMap();
      fields.put("contactId", partyId);
      GenericValue contact = delegator.findByPrimaryKey("Contact", fields);
      Date hireDate = contact.getDate("hireDate");
      if ( hireDate == null )
		hireDate = Calendar.getInstance().getTime();
      return hireDate;
    }

    GenericValue[] getQuarterlyOpportunities(String ownerId, GenericDelegator delegator, int fyStartMonth ) throws GenericEntityException {
      Calendar cal = Calendar.getInstance();
      ArrayList list = new ArrayList();
      list.add(new EntityExpr("ownerId", EntityOperator.EQUALS, ownerId));
      list.add(new EntityExpr("projectedCloseDate", EntityOperator.LESS_THAN_EQUAL_TO, new java.sql.Date( CalendarUtil.getMaximumQuarterDate((cal.get(Calendar.MONTH) + 1),cal.get(Calendar.YEAR), fyStartMonth).getTime())));
      list.add(new EntityExpr("dealStatusId", EntityOperator.NOT_EQUAL, "70")); // Not lost
      ArrayList order = new ArrayList();
      order.add("projectedCloseDate");
      List dealList = delegator.findByAnd("Deal", list, order);
      return (GenericValue[])dealList.toArray(new GenericValue[0]);
    }

    GenericValue[] getRecentLeads(String ownerId, GenericDelegator delegator) throws GenericEntityException {