createhtml.java

一个用于监控WEB服务器和数据库服务器的客户端程序。

            //sb.append("<center><font color='red' size='4'>统计数据时间：" + strDate + "</font>(数据每分钟统计一次)</center>\n");

            sb.append("<table border='0' >\n");
            sb.append("<tr><td width=50>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td><td>\n");
            sb.append("<table border=0 width='1000' align='center'>\n");
            sb.append("<tr valign=\"top\"><tr><td >\n");

            sb.append("<img src=\"/BOSS_util/chart_java.jsp?TopTitle=" + strYear + "年" + strIMonth + "月各部签单业绩分布图&BottomTitle=销售部门&CoordColor=FF6600&chartData=" + deptChartData + "\">\n");
            sb.append("<img src=\"/BOSS_util/chart_java.jsp?TopTitle=" + strYear + "年" + strIMonth + "月" + strIDay + "日各部签单业绩分布图&BottomTitle=销售部门&CoordColor=FF6600&chartData=" + deptDayChartData + "\">\n");
            sb.append("</td></tr>\n");
            sb.append("</table>\n");
            sb.append("</td></tr><tr><td width=50>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td><td>\n");

            sb.append("<form name=\"thisForm\" method=\"post\">\n");
            sb.append("<table border='0' cellpadding='0' width='750' cellspacing='0' bgcolor='#CCCCCC'>\n");
            sb.append("<tr align='center' bgcolor='#FAE8CC'>\n");
            sb.append("<td colspan='10' height='58' id='companydest' style='border-left: 1px solid #CCCCCC; border-right: 1px solid #CCCCCC; border-top: 1px solid #CCCCCC; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px'>\n");
            sb.append("</td></tr></table>\n");

            sb.append("<table border='0' cellpadding='4' width='750' cellspacing='1' bgcolor='#CCCCCC'>\n");

            sb.append("<tr bgcolor='#FAE8CC' align='center'>\n");
            sb.append("	<td colspan='10'><font size=3>【" + strYear + "年" + strMonth + "月】<font color='red'>销售经理誓言目标</font>签单数及部门进度（单位：元） </font></td>\n");
            sb.append("</tr>\n");
            sb.append("<tr bgcolor='#FAE8CC' align='center'>\n");
            sb.append("	<td width='10%'>部门名称</td>\n");
            sb.append("	<td width='8%'>部门经理</td>\n");

            sb.append("	<td width='4%'>分机</td>\n");
            sb.append("	<td width='12%'>销售经理誓言目标签单数①	</td>\n");
            sb.append("	<td width='10%'>本月已签单数②</td>\n");
            sb.append("	<td width='10%'>本日签单数</td>\n");

            sb.append("	<td width='10%'>部门达成率 ②/①</td>\n");

            sb.append("	<td width='12%'>达成率图示</td>\n");
            sb.append("	<td width='6%'>是否<br>达标</td>\n");
            sb.append("	<td width='10%'>部门名称</td>\n");
            sb.append("</tr>\n");

            RS1 = stmt.executeQuery(SQL + " order by DestAchieveRate desc");
            while (RS1.next()) {
                DepartName = RS1.getString("DepartName");
                PersonName = RS1.getString("PersonName");
                PersonExt = RS1.getString("PersonExt");
                ManagerDestMoney = RS1.getInt("ManagerDestMoney");
                TractMoney = RS1.getInt("TractMoney");
                TractMoney_Today = RS1.getInt("TractMoney_Today");
                DestAchieveRate = RS1.getDouble("DestAchieveRate");

                ManagerDestMoneyTotal += ManagerDestMoney;
                TractMoneyTotal += TractMoney;
                TractMoney_TodayTotal += TractMoney_Today;

                sb.append("<tr align='center' bgcolor='#FFFFFF' onmouseover=\"this.bgColor='#c8ca74';\" onmouseout=\"this.bgColor='#ffffff';\">\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(ManagerDestMoney) + "</td>\n");
                sb.append("<td align='right'>" + nf.format(TractMoney) + "</td>\n");
                sb.append("<td align='right'>" + nf.format(TractMoney_Today) + "</td>\n");

                if (ManagerDestMoney == 0) {
                    sb.append("<td><font color=red>没定目标额</font></td>\n");
                } else
                    sb.append("<td>" + Pernf.format(DestAchieveRate * 100) + "%</td>\n");

                sb.append("<td><table border='1' width='100%' height='100%' cellpadding='0' cellspacing='0'        style='border-collapse: collapse;border-style:none'><tr><td><img src='/boss_util/JavaImaging_Percent.jsp?width=90&height=16&percent="
                                + Pernf.format(DestAchieveRate) + "'></td></tr></table></td>\n");
                if (ManagerDestMoney == 0)
                    sb.append("<td ></td>\n");
                else if (TractMoney >= ManagerDestMoney)
                    sb.append("<td ><font color=blue size=3><b>√</b></font></td>\n");//★√×
                else
                    sb.append("<td ><font color=red size=3><b>×</b></font></td>\n");

                sb.append("<td >" + DepartName + "</td></tr>\n");
                sb.append("</tr>\n");
            }

            //公司整体目标达成率
            ComDestAchieveRate = (double) TractMoneyTotal / (double) ComDestTractMoney;

            sb.append("<tr align='center' bgcolor='#FAE8CC'><td colspan='3'>总　　　计</td>\n");
            sb.append("<td align='right'>" + nf.format(ManagerDestMoneyTotal) + "</td>\n");
            sb.append("<td align='right'>" + nf.format(TractMoneyTotal) + "</td>\n");
            sb.append("<td align='right'>" + nf.format(TractMoney_TodayTotal) + "</td>\n");
            sb.append("<td align='right' colspan=4>&nbsp;</td>\n");

            sb.append("</tr>\n");
            sb.append("<tr align='center' bgcolor='#FAE8CC'>\n");
            sb.append("<td colspan=3  nowrap>本月整体销售目标为：" + nf.format(ComDestTractMoney) + "</td><td colspan=2  align='right'>本月已签单额为：" + nf.format(TractMoneyTotal) + "</td>\n");
            sb.append("<td nowrap>总体达成率：</td>\n");

            if (ComDestTractMoney == 0) {
                sb.append("<td><font color=red>没定目标额</font></td>\n");
            } else
                sb.append("<td>" + Pernf.format(ComDestAchieveRate * 100) + "%</td>\n");

            sb.append("<td><table border='1' width='100%' height='100%' cellpadding='0' cellspacing='0'  style='border-collapse: collapse;border-style:none'><tr><td><img src='/boss_util/JavaImaging_Percent.jsp?width=90&height=16&percent="
                            + Pernf.format(ComDestAchieveRate) + "'>　</td></tr></table></td>\n");
            sb.append("<td colspan=2 align='center' >排序方式：部门达成率</td>\n");
            sb.append("</tr>\n");

            sb.append("</table>\n");
            sb.append("</form>\n");
            sb.append("</td>\n");
            sb.append("</tr>\n");
            sb.append("</table>\n");
            sb.append("</body>\n");

            sb.append("<script language=\"javaScript\">\n");
            sb.append("	window.companydest.innerHTML=\"<b><font color='red' size='6'>本月销售目标倒数：" + nf.format(ComDestTractMoney - TractMoneyTotal) + "元</font> </b><a name='top0'></a>\"\n");

            sb.append("	setTimeout(\"this.location.reload()\",1*60*1000);\n");
            sb.append("</script>\n");

            RS1.close();
            stmt.close();
            DBConn.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
            try {
                RS1.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_dest.html";
        String strDate = (new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm")).format(new java.util.Date());
        CreateHtml creator = new CreateHtml(new StringBuffer(10240));

        boolean ret = creator.create(localPath, fileName);
        if (ret) {
            System.out.println(localPath+fileName+"生成成功,时间:" + strDate);
            try {
                Runtime.getRuntime().exec("bat\\copySALEDeptCusTractList_dest.bat");
                System.out.println("bat\\copySALEDeptCusTractList_dest.bat执行成功");
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
}