sqlchart.jsp

国外的一套开源CRM

<%@ include file="/includes/chartheader.jsp" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.awt.*" %>
<%@ page import="com.sourcetap.sfa.sql.*" %>
<%@ page import="org.ofbiz.entity.util.SequenceUtil" %>
<%@ page import="org.ofbiz.core.security.*" %>
<%@ page import="org.ofbiz.entity.*" %>
<%@ page import="org.ofbiz.entity.model.*" %> 
<%@ page import="org.ofbiz.base.util.*" %>
<%@ page import="com.sourcetap.sfa.ui.*" %>
<%@ page import="com.sourcetap.sfa.event.*" %>
<%@ page import="com.sourcetap.sfa.util.UserInfo" %>

<jsp:useBean id="delegator" type="org.ofbiz.entity.GenericDelegator" scope="application" />
<% UserInfo userInfo  = (UserInfo) session.getAttribute("userInfo"); 
   String module = "sqlChart";
%>

function Populate(){
	setTitle("Pipline");
	setAxis("Number of Issues");
	<%
	
	String sql = request.getParameter("sql");
	
	if (sql == null){
		sql = session.getAttribute("chartSql").toString();
		Debug.logVerbose("sqlChart sql = " +  sql, "sqlChart" );
	}
	
	Connection connection = null;
	PreparedStatement preparedStatement = null;
	ResultSet rs = null;
      try{
        SQLUtil sqlUtil = new SQLUtil();
        connection = sqlUtil.getConnection(delegator);
        preparedStatement = connection.prepareStatement(sql);
        rs = preparedStatement.executeQuery();
	
		String valueName = "";
		int x = 0;
		int y = 100;
		boolean lbStop = false;
		Double  ldTemp = new Double(0.0);
		double  ldSimple = 0;
		//new Double(returnAmount)
		
		while ( rs.next() ){
				x++;
				valueName = rs.getString("name");
				ldSimple = rs.getDouble("amount"); 
				ldTemp = Double.valueOf(Double.toString(ldSimple));
				y = ldTemp.intValue();
				if (y < 1) {
					y = 1;
				}
				%>
				addChartValue(<%=y%>,"<%=valueName%>", true);
				<% 	
		}
		
	  } catch(SQLException e){ 
        Debug.logError(e.getMessage(), module);
        ByteArrayOutputStream baos = new ByteArrayOutputStream();
        e.printStackTrace(new PrintWriter(baos));
        Debug.logError(new String(baos.toByteArray()), module);
      } catch(Exception e){
        e.printStackTrace();
        Debug.logError(e.getMessage(), module);
        ByteArrayOutputStream baos = new ByteArrayOutputStream();
        e.printStackTrace(new PrintWriter(baos));
        Debug.logError(new String(baos.toByteArray()), module);
      } finally {
        try{
          //if(resultSet != null) resultSet.close();
          if(preparedStatement != null) preparedStatement.close();
          if(connection != null) connection.close();
        } catch (SQLException e){
          Debug.logError(e.getMessage(), module);
          ByteArrayOutputStream baos = new ByteArrayOutputStream();
          e.printStackTrace(new PrintWriter(baos));
          Debug.logError(new String(baos.toByteArray()), module);
        }
      }	
		  
	%>
		
}
<%@ include file="/includes/chartfooter.jsp" %>