📄 saledeptcustractlist.java
字号:
/*
*
*/
package com.jobcn.task;
import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.sql.*;
import com.jobcn.database.DataBase;
/**
* @remark:
* @author: Stephen
* @date: 2005-3-21
* @version:
* @upd_remark:
* @upd_user:
* @upd_date:
*/
final public class SALEDeptCusTractList extends AbstractCreateHtml {
//constructer1
public SALEDeptCusTractList() {
super(new StringBuffer(1024));
}
//constructer2
public SALEDeptCusTractList(StringBuffer sb) {
super(sb);
}
public void printHeader() {
sb.append("<html>\n");
sb.append("<head>\n");
sb.append(" <title>本月签单团队排行榜</title>\n");
sb.append(" <link href=\"/BOSS_CSS/css.css\" rel=\"stylesheet\" type=\"text/css\">\n");
sb.append(" <meta http-equiv=\"content-Type\" content=\"text/html; charset=GBK\">\n");
sb.append("</head>\n");
}
public void printBody() {
java.text.DecimalFormat nf = new java.text.DecimalFormat("###,###"); //整数number
// format
//java.text.DecimalFormat Pernf = new java.text.DecimalFormat("###0.00"); //百分比
String strDate = (new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm"))
.format(new java.util.Date());
String strYear = strDate.substring(0, 4);
String strMonth = strDate.substring(5, 7);
String strDay = strDate.substring(8, 10);
//String strYearMonth = strDate.substring(0, 7);
//String strIMonth = String.valueOf(Integer.parseInt(strMonth));
//String strIDay = String.valueOf(Integer.parseInt(strDay));
DataBase db = new DataBase();
Connection DBConn = null;
Statement stmt = null;
ResultSet RS = null;
String SQL = "";
//String DepartId="";
String DepartName = "", personName = "", personExt = "";
int tractmoney = 0, TotalNum = 0;
String deptChartData = "";
/*
* SQL=?
*/
SQL = "select "
+ " bb.departId DepartId, "
+ " bb.departName DepartName, "
+ " bb.personName personName, "
+ " bb.personExt personExt, "
+ " TractMoney "
+ "from ( "
+ " select top 100 percent "
+ " c.Id DepartId, "
+ " c.Name DepartName, "
+ " sum(convert(float,tractMoney)) TractMoney "
+ " from "
+ " fncustractrec a,HRPerson b,baseDepartment c "
+ " where "
+ " Left(convert(varchar(10),tractdate,120),7)='"
+ strDate.substring(0, 7)
+ "' and "
+ " a.PersonId=b.Id and b.DepartId = c.Id "
+ " group by c.Id,c.Name "
+ " ) aa, "
+ " ( "
+ " select top 100 percent "
+ " a.Id departId, "
+ " a.name departName, "
+ " b.name personName, "
+ " b.OfficePhone_Ext personExt "
+ " from baseDepartment a,HRPerson b,basepart c,HRPerDepartPart d "
+ " where " + " a.name like '%销售%' "
+ " and c.name like '%经理%' " + " and a.id=d.departmentid "
+ " and c.id=d.partid " + " and b.id=d.personid "
+ " and (b.stateId='1701' or b.stateId='1702') "
+ " order by a.id " + " ) bb "
+ "where aa.DepartId =* bb.departId "
+ "order by DepartId ,TractMoney desc";
//System.out.println(SQL);
try {
DBConn = db.connect();
stmt = db.createStatement(DBConn);
sb.append("<body topmargin='0' leftmargin='0' oncontextmenu='return false;' ondragstart='return false;' onsource='return false;' onselectstart='return false;'>\n");
sb.append("<center>\n");
sb.append("<table border=\"0\" width=\"600\">\n");
sb.append("<tr bgcolor=\"#FFFFFF\" align=\"center\">\n");
sb.append("<td>\n");
sb.append("<img id=\"imgsrc\">\n");
sb.append("</td>\n");
sb.append("<td valign='top'>\n");
sb.append("<table border=\"0\" cellpadding=\"4\" width=\"350\" cellspacing=\"1\" bgcolor=\"#CCCCCC\">\n");
sb.append("<tr bgcolor=\"#FAE8CC\" align=\"center\">\n");
sb.append("<td colspan=\"5\"><font size=3>【" + strYear + "年"
+ strMonth + "月" + strDay
+ "日】签单<font color=\"red\">团队</font>龙虎榜</font></td>\n");
sb.append("</tr>\n");
sb.append("<tr bgcolor=\"#FAE8CC\" align=\"center\">\n");
sb.append("<td width=\"12%\">名次</td>\n");
sb.append("<td width=\"25%\">部门名称</td>\n");
sb.append("<td width=\"25%\">部门经理</td>\n");
sb.append("<td width=\"13%\">分机</td>\n");
sb.append("<td width=\"25%\">签单金额</td>\n");
sb.append("</tr>\n");
RS = db.getRS(stmt, SQL);
int i = 0;
while(RS.next() && !RS.isAfterLast()) {
//DepartId = RS.getString("DepartId");
DepartName = RS.getString("DepartName");
personName = RS.getString("personName");
personExt = RS.getString("personExt");
tractmoney = RS.getInt("tractmoney");
TotalNum = TotalNum + tractmoney;
deptChartData = deptChartData + DepartName.replaceAll("销售", "")
+ "," + Integer.toString(tractmoney) + ",";
i = i + 1;
sb.append("<tr align='center' bgcolor='#FFFFFF' onmouseover=\"this.bgColor='#c8ca74';\" onmouseout=\"this.bgColor='#ffffff';\">\n");
sb.append("<td>" + i + "</td>\n");
sb.append("<td>" + DepartName + "</td>\n");
sb.append("<td>" + personName + "</td>\n");
sb.append("<td>" + personExt + "</td>\n");
sb.append("<td align='right'>" + nf.format(tractmoney)
+ "</td>\n");
sb.append("</tr>\n");
}
sb.append("<tr align='right' bgcolor='#FAE8CC'><td colspan='4'>签单总额</td><td>"
+ nf.format(TotalNum) + "</td></tr>\n");
deptChartData = deptChartData.substring(0,deptChartData.length() - 1);
sb.append("</table>\n");
sb.append("</td>\n");
sb.append("</tr>\n");
sb.append("</table>\n");
sb.append("</center>\n");
sb.append("</body>\n");
sb.append("<script language=\"javascript\">\n");
sb.append("window.imgsrc.src=\"/BOSS_util/chart_java.jsp?TopTitle="
+ strYear
+ "年"
+ strMonth
+ "月各部签单业绩分布图&BottomTitle=销售部门&CoordColor=FF6600&chartData="
+ deptChartData + "\";\n");
//sb.append("<br>\n");
//sb.append(" setTimeout(\"this.location.reload()\",1*60*1000);\n");
sb.append("</script>\n");
RS.close();
stmt.close();
DBConn.close();
} catch(Exception e) {
System.out.println(e.getMessage());
try {
RS.close();
stmt.close();
DBConn.close();
} catch(SQLException sqle) {
System.out.println(sqle.getMessage());
}
}
}
public static void main(String[] args) {
String localPath = "html\\";
String fileName = "SALEDeptCusTractList.html";
long times = System.currentTimeMillis();
String strDate = (new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm")).format(new java.util.Date());
SALEDeptCusTractList creator = new SALEDeptCusTractList(new StringBuffer(10240));
boolean ret = creator.create(localPath, fileName);
if(ret) {
times = (System.currentTimeMillis() - times) / 1000;
System.out.println(localPath + fileName + "生成成功,时间:" + strDate + " 耗时" + times + "秒");
try {
Runtime rt = Runtime.getRuntime();
String[] cmd = new String[3];
cmd[0] = "cmd.exe";
cmd[1] = "/C";
cmd[2] = "bat\\copySALEDeptCusTractList.bat";
Process proc = rt.exec(cmd);
InputStream isError = proc.getErrorStream();
InputStreamReader isrError = new InputStreamReader(isError);
BufferedReader brError = new BufferedReader(isrError);
InputStream isOutput = proc.getInputStream();
InputStreamReader isrOutput = new InputStreamReader(isOutput);
BufferedReader brOutput = new BufferedReader(isrOutput);
int retc = proc.waitFor();
if(retc==0){
System.out.println(cmd[2]+"执行成功");
String line = null;
while ((line = brOutput.readLine()) != null)
System.out.println(">>" + line);
}
else{
System.out.println(cmd[2]+"执行失败");
String line = null;
while ((line = brError.readLine()) != null)
System.out.println(">>" + line);
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -