chartframe.jsp

国外的一套开源CRM

<%@ page import="com.sourcetap.sfa.util.UserInfo" %>
<% UserInfo userInfo  = (UserInfo) session.getAttribute("userInfo"); %>
<%
String chartNumber = request.getParameter("chart");
String displayTitle = "";
String chartName = "";
String codeType = "";
String sql = "";
StringBuffer sbSql = new StringBuffer("No sql string specified");


		//set the chart and title
       switch ( Long.valueOf(chartNumber).intValue() ) {
            case 1: 
				displayTitle = "Current Work Load";
				chartName = "assignedIssueChart"; 
				break;
			case 2: 
				displayTitle = "Issue Status";
				chartName = "sqlChart"; 
				codeType = "STATUS_ID"; 
				break;
			case 3: 
				displayTitle = "Issue Priority";
				chartName = "sqlChart"; 
				codeType = "PRIORITY_ID"; 
				break;
			case 4: 
				displayTitle = "Issue Type";
				chartName = "sqlChart"; 
				codeType = "ISSUE_TYPE_ID";
				break;	
			case 5: 
				displayTitle = "Issue Summary";
				chartName = "sqlChart";
				sbSql = new StringBuffer("select count(i.issue_id) as amount, ");
				sbSql.append(" concat( c.first_name, ' ', c.last_name, ': ', code.code_value ) as name ");
				sbSql.append(" from it_issue i, ");
				sbSql.append(" code, ");
				sbSql.append(" contact c ");
				sbSql.append(" where i.status_id <> 'C' ");
				sbSql.append(" and i.assigned_to like  ");
				sbSql.append("'%" + userInfo.getPartyId() + "%' ");
				sbSql.append(" and i.status_id <> 'X' ");
				sbSql.append(" and code.code_type_id = 'PRIORITY_ID' ");
				sbSql.append(" and code.code_id = i.priority_id ");
				sbSql.append(" and c.contact_id = i.assigned_to ");
				sbSql.append(" group by concat( c.first_name, ' ', c.last_name, ': ', code.code_value ) ");
				sbSql.append(" order by concat( c.first_name, ' ', c.last_name, ': ', code.code_value ) ");
				sql = sbSql.toString();
				break;	
        }
        
		
		if ( sql == null || sql == "" ){
			sbSql = new StringBuffer("select count(i.issue_id) as amount, code.code_value as name ");
			sbSql.append(" from it_issue i, ");
			sbSql.append(" code ");
			sbSql.append(" where i.status_id <> 'C' ");
			sbSql.append(" and i.status_id <> 'X' ");
			sbSql.append(" and code.code_type_id = '" + codeType + "' ");
			sbSql.append(" and code.code_id = i." + codeType );
			sbSql.append(" group by code.code_value ");
			sbSql.append(" order by code.code_value ");
			sql = sbSql.toString();
		}
		chartName = chartName + "?sql=" + sql;
		session.setAttribute("chartSql", sql );
 %>



<FRAMESET ROWS="50, *" BORDER="0" FRAMEBORDER="no" FRAMESPACING="0">
 <FRAME NAME="titleFrame" MARGINWIDTH="0" MARGINHEIGHT="0" SCROLLING="AUTO" SRC="chartTitle?title=<%=displayTitle%>">
 </FRAME>
 <FRAME NAME="graphFrame" MARGINWIDTH="0" MARGINHEIGHT="0" SCROLLING="AUTO" SRC="<%=response.encodeURL(chartName)%>" >
 </FRAME>
</FRAMESET>