activitycalendar.jsp

国外的一套开源CRM

		case 3:
			calendar.set(Calendar.MONTH, Calendar.MARCH);
			calendar.set(Calendar.YEAR, year);
			calendar.set(Calendar.DAY_OF_MONTH, day);
			break;
		case 4:
			calendar.set(Calendar.MONTH, Calendar.APRIL);
			calendar.set(Calendar.YEAR, year);
			calendar.set(Calendar.DAY_OF_MONTH, day);
			break;
		case 5:
			calendar.set(Calendar.MONTH, Calendar.MAY);
			calendar.set(Calendar.YEAR, year);
			calendar.set(Calendar.DAY_OF_MONTH, day);
			break;
		case 6:
			calendar.set(Calendar.MONTH, Calendar.JUNE);
			calendar.set(Calendar.YEAR, year);
			calendar.set(Calendar.DAY_OF_MONTH, day);
			break;
		case 7:
			calendar.set(Calendar.MONTH, Calendar.JULY);
			calendar.set(Calendar.YEAR, year);
			calendar.set(Calendar.DAY_OF_MONTH, day);
			break;
		case 8:
			calendar.set(Calendar.MONTH, Calendar.AUGUST);
			calendar.set(Calendar.YEAR, year);
			calendar.set(Calendar.DAY_OF_MONTH, day);
			break;
		case 9:
			calendar.set(Calendar.MONTH, Calendar.SEPTEMBER);
			calendar.set(Calendar.YEAR, year);
			calendar.set(Calendar.DAY_OF_MONTH, day);
			break;
		case 10:
			calendar.set(Calendar.MONTH, Calendar.OCTOBER);
			calendar.set(Calendar.YEAR, year);
			calendar.set(Calendar.DAY_OF_MONTH, day);
			break;
		case 11:
			calendar.set(Calendar.MONTH, Calendar.NOVEMBER);
			calendar.set(Calendar.YEAR, year);
			calendar.set(Calendar.DAY_OF_MONTH, day);
			break;
		case 12:
			calendar.set(Calendar.MONTH, Calendar.DECEMBER);
			calendar.set(Calendar.YEAR, year);
			calendar.set(Calendar.DAY_OF_MONTH, day);
			break;
	}
	return calendar;
}

String monthHeader(int year, int month, String showUserPartyId) {
	StringBuffer returnString = new StringBuffer();
	if (month == Calendar.FEBRUARY) {
  		daysInMonth[2] = ((year % 400 == 0) || ((year % 4 == 0) && (year % 100 !=0))) ? 29 : 28;
	}

	returnString.append("<A CLASS=\"tabularSectionAnchorSelected\" HREF=\"/sfa/control/activityCalendar?" +
		"action=month&amp;month=" + ((month != 1) ? (month - 1) : 12) + "&amp;year=" + ((month != 1) ? year : (year - 1)) +
		"&amp;showUserPartyId=" + showUserPartyId +
		" \"><</a>&nbsp;");
	returnString.append(monthLabel[month]);
	returnString.append("&nbsp;");
	returnString.append(year);
	returnString.append("&nbsp;<A CLASS=\"tabularSectionAnchorSelected\" HREF=\"/sfa/control/activityCalendar?" +
		"action=month&amp;month=" + ((month != 12) ? (month + 1) : 1) + "&amp;year=" +  ((month != 12) ? year : (year + 1)) +
		"&amp;showUserPartyId=" + showUserPartyId +
		" \">></a>&nbsp;");
	return returnString.toString();
}



/**
*
* makeDay
*
*/
public String makeDay(int month, int year, int day, GenericDelegator delegator){

  Calendar calendar = getCalendar(month, year, day);
  calendar.set(Calendar.HOUR, 6);
  calendar.set(Calendar.MINUTE, 0);
  calendar.set(Calendar.AM_PM, Calendar.AM);

  StringBuffer returnString = new StringBuffer();
  SimpleDateFormat simpleDateFormat = new SimpleDateFormat("hh:mm aaa");
  SimpleDateFormat headerFormat = new SimpleDateFormat("EEEE, MMMM d, yyyy");
  SimpleDateFormat defaultDateFormat = new SimpleDateFormat("yyyy-mm-dd");
  SimpleDateFormat dayTimeDF = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss a");
 try{
  GenericValue genericValue = null;
  Vector results = null;
  returnString.append("<table border=0 style=\"border: 0.02cm solid black; border-collapse: collapse;  \" cellpadding=\"0\" width=\"100%\" >");
  returnString.append("<tr height=\"50\"><td colspan=\"2\"> ");
  returnString.append("<a href=\"/sfa/control/activityCalendar?action=day&amp;day=");
    if(day == 1){
      if(month == 1){
        //go back to previous year
        returnString.append("31&amp;month=12&amp;year=" + (year-1));
      } else {
        //in current year
        returnString.append(daysInMonth[month-1] + "&amp;month=" + (month-1) + "&amp;year="+year);
      }
    } else {
      returnString.append(day-1 + "&amp;month=" + month + "&amp;year="+year);
    }
  returnString.append("\"><</a>&nbsp;");
  returnString.append(headerFormat.format(calendar.getTime()));
  returnString.append("&nbsp;<a href=\"/sfa/control/activityCalendar?action=day&amp;day=");
    if(day == daysInMonth[month]){
      if(month == 12){
        //go to next year
        returnString.append("1&amp;month=1&amp;year=" + (year+1));
      } else {
        //in current year
        returnString.append("1&amp;month=" + (month+1) + "&amp;year="+year);
      }
    } else {
      returnString.append(day+1 + "&amp;month=" + month + "&amp;year="+year);
    }
  returnString.append("\">></a>");
  returnString.append("&nbsp;<a href=\"/sfa/control/activityCalendar?action=week&amp;month=" + month + "&amp;day=" + day + "&amp;year=" +  year + " \">week</a>");
  returnString.append("&nbsp;<a href=\"/sfa/control/activityCalendar?action=month&amp;month=" + month + "&amp;day=" + day + "&amp;year=" +  year + " \">month</a>");
  returnString.append("</td></tr>");

  List activityCol = findActivitiesByDate(month, day, year, delegator);
GenericValue activities[] = (GenericValue[])activityCol.toArray(new GenericValue[0]);
  GenericValue activity = null;

  String key = "";
  Timestamp ts1 = null;
  Timestamp ts2 = null;
  for(int i=0;i<25;i++){
    calendar.add(Calendar.MINUTE, 30);
    key = simpleDateFormat.format(calendar.getTime());
    returnString.append("<tr><td height=\"10\" style=\"border: 0.02cm solid black; border-collapse: collapse; \" width=\"15%\" >&nbsp;");
    returnString.append(key);
    returnString.append("</td>");
    returnString.append("<td style=\"border: 0.02cm solid black; border-collapse: collapse; \" >");
    if(activityCol != null && activityCol.size() > 0){

      for(int j=0;j<activities.length;j++){
        activity = activities[j];
        ts1 = activity.getTimestamp("openStartTime");
        ts2 = new Timestamp(calendar.getTime().getTime());
        if(ts1.compareTo(ts2) == 0){
          returnString.append("<a href=\"/sfa/control/activity/activityPopup?activityId=" + activity.getString("activityId") + "&action=search\"> <b>name:</b>" + activity.getString("activityName") + " <br><b>description:</b>" + activity.getString("activityDescription") + "</a>");
        }

      }
    } else {
      returnString.append("&nbsp;");
    }
    returnString.append("&nbsp;</td></tr>");
  }
    returnString.append("</table>");

} catch (Exception e) { e.printStackTrace(); }
  return returnString.toString();
}


public String makeWeek(int month, int year, int day, GenericDelegator delegator){

  Calendar calendar = getCalendar(month, year, day);

  StringBuffer returnString = new StringBuffer();

  int dayOfWeek = calendar.get(Calendar.DAY_OF_WEEK);
  int firstDay = (((day - dayOfWeek) + 1) <= 0 ? 1 : ((day - dayOfWeek) + 1));
  int lastDay = daysInMonth[month];
  int prePadDays = ((day - dayOfWeek) > 0 ? 0 : new BigInteger(String.valueOf((day - dayOfWeek))).abs().intValue());
  int postPadDays = ((lastDay - firstDay) < 7 ? (6 - (lastDay - firstDay)) : 0 );
  int midDays = 0;
  if(prePadDays != 0){
    midDays = 7 - prePadDays;
  } else if(postPadDays != 0){
    midDays = 7 - postPadDays;
  } else {
    midDays = 7;
  }

  List activityCol = findActivitiesByWeek(month, year, day, delegator);
  GenericValue activities[] = (GenericValue[])activityCol.toArray(new GenericValue[0]);
  GenericValue activity = null;

  java.sql.Date ts1, ts2;

  returnString.append("<table style=\"border: 0.02cm solid black; border-collapse: collapse; table-layout: fixed; \"  width=\"100%\" ><tr height=\"50\">");
  returnString.append("<td colspan=\"7\">");
  calendar.add(Calendar.WEEK_OF_MONTH, -1);
  returnString.append(" <a href=\"/sfa/control/activityCalendar?action=week&amp;month=" + (calendar.get(Calendar.MONTH) + 1) + "&amp;day=" + calendar.get(Calendar.DAY_OF_MONTH) + "&amp;year=" +  calendar.get(Calendar.YEAR) + " \"><</a> ");
  returnString.append(monthLabel[month] + " " + firstDay);
  calendar = getCalendar(month, year, day);
  calendar.add(Calendar.WEEK_OF_MONTH, 1);
  returnString.append(" <a href=\"/sfa/control/activityCalendar?action=week&amp;month=" + (calendar.get(Calendar.MONTH) + 1) + "&amp;day=" + calendar.get(Calendar.DAY_OF_MONTH) + "&amp;year=" +  calendar.get(Calendar.YEAR) + " \">></a> ");
  returnString.append(" - ");
  calendar = getCalendar(month, year, day);
  calendar.add(Calendar.DAY_OF_MONTH, 7);
  if(month == (calendar.get(Calendar.MONTH) + 1))
    returnString.append(calendar.get(Calendar.DAY_OF_MONTH));
  else
    returnString.append(monthLabel[(calendar.get(Calendar.MONTH) + 1)] + " " + calendar.get(Calendar.DAY_OF_MONTH));

  returnString.append(", " + calendar.get(Calendar.YEAR));
  returnString.append("&nbsp;<a href=\"/sfa/control/activityCalendar?action=month&amp;month=" + month + "&amp;day=" + day + "&amp;year=" +  year + " \">month</a>");
  returnString.append("</td></tr>");
  returnString.append("<tr height=\"50\">");
  for(int i = 0; i < 7; i++) {
    returnString.append("<td style=\"border: 0.02cm solid black; border-collapse: collapse; table-layout: fixed; \"   >" + dayLabel[i] + "</td>");
  }
  returnString.append("</tr>");
  returnString.append("<tr height=\"200\" valign=\"top\">");
  for(int i=0; i<prePadDays; i++){
    returnString.append("<td style=\"border: 0.02cm solid black; border-collapse: collapse; table-layout: fixed; \" bgcolor=\"#CFCFCF\">&nbsp;</td>");
  }

  calendar = getCalendar(month, year, day);
  calendar.set(Calendar.DAY_OF_MONTH, firstDay);
  for (int i = 0; i < midDays; i++) {
    if ((day == firstDay) && (month == currentMonth) && (year == currentYear)) {
      returnString.append("<td style=\"border: 0.02cm solid black; border-collapse: collapse; table-layout: fixed; \" bgcolor=\"#C0C0C0\" >");
    } else {
      returnString.append("<td style=\"border: 0.02cm solid black; border-collapse: collapse; table-layout: fixed; \" >");
    }
    returnString.append("<a href=\"/sfa/control/activityCalendar?action=day&amp;day=" + firstDay + "&amp;month=" + month + "&amp;year=" + year + " \">" + firstDay + "</a><br>");

    for(int j=0;j<activities.length;j++){
      activity = activities[j];
      ts1 = activity.getDate("openDate");
      ts2 = new java.sql.Date(calendar.getTime().getTime());
      if(ts1.compareTo(ts2) == 0){
        returnString.append("<a href=\"/sfa/control/activity/activityPopup?activityId=" + activity.getString("activityId") + "&action=search\"> <b>name:</b>" + activity.getString("activityName") + " <br><b>description:</b>" + activity.getString("activityDescription") + "</a>");
      } else {
      }
    }

    returnString.append("</td>");
    firstDay++;
    calendar.set(Calendar.DAY_OF_MONTH, firstDay);
  }

  for(int ix=0; ix<postPadDays; ix++) {
    returnString.append("<td  style=\"border: 0.02cm solid black; border-collapse: collapse; table-layout: fixed; \"  bgcolor=\"#CFCFCF\">&nbsp;</td>");
  }
  returnString.append("</tr><table>");
  return returnString.toString();
}

public List findActivitiesByDate(int month, int day, int  year, GenericDelegator delegator){
  Calendar cal = Calendar.getInstance();
  cal.set(Calendar.MONTH, (month - 1));
  cal.set(Calendar.DAY_OF_MONTH, day);
  cal.set(Calendar.YEAR, year);
  HashMap searchFieldNames = new HashMap();
  searchFieldNames.put("openDate", new java.sql.Date(cal.getTime().getTime()));
  List returnCol = null;
  try {
    returnCol = delegator.findByAnd(ENTITY, searchFieldNames, null);
  } catch (GenericEntityException e){ e.printStackTrace();
  }
  return returnCol;
}

public List findActivitiesByDate(String date, GenericDelegator delegator){
  HashMap searchFieldNames = new HashMap();
  searchFieldNames.put("openDate", date);
  List returnCol = null;
  try {
    returnCol = delegator.findByLike(ENTITY, searchFieldNames, null);