|
版本: |
BeX5V3.1 |
小版本号: |
|
|
|
数据库: |
Oracle |
服务器操作系统: |
Windows |
应用服务器: |
Tomcat |
客户端操作系统: |
Windows 7 |
浏览器: |
Firefox |
|
|
//本月受理
String HOT_LINE_NUMBER = "select count(M.TRANS_FLAG) from MA_HOT_LINE M where M.TRANS_FLAG>=1 and HOT_LINE_TIME between to_date('2015-01-01','yyyy-mm-dd') and to_date('2015-01-31','yyyy-mm-dd')";
//已办件
String HOT_LINE_TAKEN = "select count(M.TRANS_FLAG) from MA_HOT_LINE M where M.TRANS_FLAG>=11 and HOT_LINE_TIME between to_date('2015-01-01','yyyy-mm-dd') and to_date('2015-01-31','yyyy-mm-dd')";
//已办占比 =已办件/本月受理
//正在办理=本月受理-已办件
//HOT_LINE_DISPOSE = HOT_LINE_NUMBER - HOT_LINE_TAKEN;
HOT_LINE_DISPOSE = count(HOT_LINE_NUMBER) - count(HOT_LINE_TAKEN);
//正办占比=正在办理/本月受理
//HOT_LINE_ZHENGBAN = HOT_LINE_DISPOSE/HOT_LINE_NUMBER;
HOT_LINE_ZHENGBAN = count(HOT_LINE_DISPOSE)/count(HOT_LINE_NUMBER);
D:\BeX5\model\BIZ\szrx\hotLineReport\logic\code\dsrc\HotLineReport.java:74: 错误: 找不到符号
HOT_LINE_DISPOSE = count(HOT_LINE_NUMBER) - count(HOT_LINE_TAKEN);
^
符号: 方法 count(String)
位置: 类 HotLineReport
D:\BeX5\model\BIZ\szrx\hotLineReport\logic\code\dsrc\HotLineReport.java:74: 错误: 找不到符号
HOT_LINE_DISPOSE = count(HOT_LINE_NUMBER) - count(HOT_LINE_TAKEN);
^
符号: 方法 count(String)
位置: 类 HotLineReport
D:\BeX5\model\BIZ\szrx\hotLineReport\logic\code\dsrc\HotLineReport.java:78: 错误: 找不到符号
HOT_LINE_ZHENGBAN = count(HOT_LINE_DISPOSE)/count(HOT_LINE_NUMBER);
^
符号: 方法 count(String)
位置: 类 HotLineReport
D:\BeX5\model\BIZ\szrx\hotLineReport\logic\code\dsrc\HotLineReport.java:78: 错误: 找不到符号
HOT_LINE_ZHENGBAN = count(HOT_LINE_DISPOSE)/count(HOT_LINE_NUMBER);
^
符号: 方法 count(String)
位置: 类 HotLineReport
|
|