📄 prodfunlogimpl.java
字号:
else if(sQueryType.equals("apply")) {
dt = getAllEveryList(_map,"1");
}
else if(sQueryType.equals("cancel")) {
dt = getAllEveryList(_map,"4");
}
else if(sQueryType.equals("close")) {
dt = getAllEveryList(_map,"2");
}
}
return dt;
}
/**获取程控功能受理情况按条件总计的条数
*
* @param _map
* @return
*/
private int getAccessLogSum(Map _map) {
DacClient db = new DacClient();
try {
StringBuffer sql = new StringBuffer();
StringBuffer sql1 = new StringBuffer();
List oParam = new ArrayList();
buildAcceptResultSQL(_map,sql,oParam);
sql1.append("select sum(\"受理总量\") from(");
sql1.append(sql).append(")");
Object ap[] = new Object[oParam.size()];
for (int i = 0; i < ap.length; i++) {
ap[i] = oParam.get(i);
}
String sum = db.getStringFromSqlQuery(sql1.toString(), ap);
//System.out.println("总记数：" + sum);
return Integer.parseInt(sum);
} catch (Exception e) {
FileLogger.getLogger().warn(e.getMessage(), e);
}
return 0;
}
/**获取程控功能受理失败原因查询总计的条数
*
* @param _map
* @return
*/
private int getFailCauseSum(Map _map) {
DacClient db = new DacClient();
try {
StringBuffer sql = new StringBuffer();
StringBuffer sql1 = new StringBuffer();
List oParam = new ArrayList();
buildFailCauseSQL(_map,sql,oParam);
sql1.append("select count(1) from(");
sql1.append(sql).append(")");
Object ap[] = new Object[oParam.size()];
for (int i = 0; i < ap.length; i++) {
ap[i] = oParam.get(i);
}
String sum = db.getStringFromSqlQuery(sql1.toString(), ap);
//System.out.println("总记数：" + sum);
return Integer.parseInt(sum);
} catch (Exception e) {
FileLogger.getLogger().warn(e.getMessage(), e);
}
return 0;
}
private int getEverySum(Map _map,String action) {
DacClient db = new DacClient();
try {
StringBuffer sql = new StringBuffer();
StringBuffer sql1 = new StringBuffer();
List oParam = new ArrayList();
buildEverySQL(_map,sql,oParam,action);
sql1.append("select count(1) from(");
sql1.append(sql).append(")");
Object ap[] = new Object[oParam.size()];
for (int i = 0; i < ap.length; i++) {
ap[i] = oParam.get(i);
}
String sum = db.getStringFromSqlQuery(sql1.toString(), ap);
//System.out.println("总记数：" + sum);
return Integer.parseInt(sum);
} catch (Exception e) {
FileLogger.getLogger().warn(e.getMessage(), e);
}
return 0;
}
/**获取程控功能受理失败原因查询总计的条数
*
* @param _map
* @return
*/
private int getSum(Map _map) {
DacClient db = new DacClient();
try {
StringBuffer sql = new StringBuffer();
StringBuffer sql1 = new StringBuffer();
List oParam = new ArrayList();
buildListSQL(_map,sql,oParam);
sql1.append("select count(1) from(");
sql1.append(sql).append(")");
Object ap[] = new Object[oParam.size()];
for (int i = 0; i < ap.length; i++) {
ap[i] = oParam.get(i);
}
String sum = db.getStringFromSqlQuery(sql1.toString(), ap);
//System.out.println("总记数：" + sum);
return Integer.parseInt(sum);
} catch (Exception e) {
FileLogger.getLogger().warn(e.getMessage(), e);
}
return 0;
}
public String getSum(ServletRequest request, ServletResponse response, Map _map) {
String sum = "0";
String sQueryType = (String) _map.get("queryType");
if(sQueryType == null || sQueryType.equals("0")) {
sum = String.valueOf(getAccessLogSum(_map));
}
else {
if(sQueryType.equals("4")) {
sum = String.valueOf(getFailCauseSum(_map));
}
else if(sQueryType.equals("3")) {
_map.put("progressstate", "3");//受理成功
sum = String.valueOf(getSum(_map));
}
else if(sQueryType.equals("2")) {
_map.put("progressstate", "2");//受理中
sum = String.valueOf(getSum(_map));
}
else if(sQueryType.equals("1")) {
_map.put("progressstate", "1");//等待受理
sum = String.valueOf(getSum(_map));
}
else if(sQueryType.equals("ohter")) {
sum = String.valueOf(getFailCauseSum(_map));
}
else if(sQueryType.equals("every")) {
sum = String.valueOf(getEverySum(_map,""));
}
else if(sQueryType.equals("apply")) {
sum = String.valueOf(getEverySum(_map,"1"));
}
else if(sQueryType.equals("cancel")) {
sum = String.valueOf(getEverySum(_map,"4"));
}
else if(sQueryType.equals("close")) {
sum = String.valueOf(getEverySum(_map,"2"));
}
}
return sum;
}
/**用于分页
*
*/
protected int getRptListCount(Map _map) {
int count = 0;
String sQueryType = (String) _map.get("queryType");
if(sQueryType == null || sQueryType.equals("0")) {
count =getAccessLogCount(_map);
}
else {
if(sQueryType.equals("4")) {
count = getFailCauseSum(_map);
}
else if(sQueryType.equals("3")) {
_map.put("progressstate", "3");//受理成功
count = getSum(_map);
}
else if(sQueryType.equals("2")) {
_map.put("progressstate", "2");//受理中
count = getSum(_map);
}
else if(sQueryType.equals("1")) {
_map.put("progressstate", "1");//等待受理
count = getSum(_map);
}
else if(sQueryType.equals("ohter")) {
count = getFailCauseSum(_map);
}
else if(sQueryType.equals("every")) {
count = getEverySum(_map,"");
}
else if(sQueryType.equals("apply")) {
count = getEverySum(_map,"1");
}
else if(sQueryType.equals("cancel")) {
count = getEverySum(_map,"4");
}
else if(sQueryType.equals("close")) {
count = getEverySum(_map,"2");
}
}
return count;
}
private int getAccessLogCount(Map _map) {
DacClient db = new DacClient();
try {
StringBuffer sql = new StringBuffer();
StringBuffer sql1 = new StringBuffer();
List oParam = new ArrayList();
buildAcceptResultSQL(_map,sql,oParam);
sql1.append("select count(1) from(");
sql1.append(sql).append(")");
Object ap[] = new Object[oParam.size()];
for (int i = 0; i < ap.length; i++) {
ap[i] = oParam.get(i);
//System.out.println("%%%%%%%%%%%%%%%%%%%"+ap[i]);
}
//System.out.println("%%%%%%%%%%%%%%%%%%%"+sql1.toString());
String count = db.getStringFromSqlQuery(sql1.toString(), ap);
//System.out.println("记录数：" + count);
return Integer.parseInt(count);
} catch (Exception e) {
FileLogger.getLogger().warn(e.getMessage(), e);
}
return 0;
}
public static String[] getStatisticType(String sStatisticType,String sStartTime,String sEndTime) {
String result[] = new String[4];
String str = "";
String timeFormat = "";
if(sStatisticType != null) {
if(sStatisticType.equals("1")) {
str = "yyyy-mm";
timeFormat = "yyyy-mm";
if(sStartTime != null && !sStartTime.equals("")) {
sStartTime = sStartTime.substring(0, 7)+"-1";
}
if(sEndTime != null && !sEndTime.equals("")) {
sEndTime = sEndTime.substring(0, 5)+
String.valueOf(Integer.parseInt(sEndTime.substring(5,7))+1)+
"-1";
}
}
else {
str = "yyyy-mm-dd";
timeFormat = "yyyy-mm-dd hh24:mi:ss";
if(sStartTime != null && !sStartTime.equals("")) {
sStartTime = sStartTime+" 00:00:00";
}
if(sEndTime != null && !sEndTime.equals("")) {
sEndTime = sEndTime+" 23:59:59";
}
}
}
else {
str = "yyyy-mm-dd";
timeFormat = "yyyy-mm-dd hh24:mi:ss";
if(sStartTime != null && !sStartTime.equals("")) {
sStartTime = sStartTime+" 00:00:00";
}
if(sEndTime != null && !sEndTime.equals("")) {
sEndTime = sEndTime+" 23:59:59";
}
}
result[0] = str;
result[1] = timeFormat;
result[2] = sStartTime;
result[3] = sEndTime;
return result;
}
public String genHtml(Map _map) {
DataTable dt = getRptList(_map);
StringBuffer _sb = new StringBuffer();
String sQueryType = (String) _map.get("queryType");
String sProdfun = (String) _map.get("PRODFUN");
String tilte = getFunName(_map);
String sFunType = getFunType(_map);
if ( dt != null && dt.getRows().getCount() > 0 ) {
_sb.append("<table>");
try {
com.doone.data.DataColumnCollection dcs = dt.getColumns();
int colcount = dcs.getCount();
_sb.append("<tr>");
for (int icol = 0;icol<colcount-1;icol++){
com.doone.data.DataColumn dc = dcs.getDataColumn(icol);
String columnName = dc.getColumnName();
if((sQueryType == null || sQueryType.equals("0"))) {
if(columnName.equals("开/套餐新装总量") || columnName.equals("取消总量") || columnName.equals("设置总量")|| columnName.equals("关闭总量")|| columnName.equals("变更总量")) {
_sb.append("<td class=\"body_td\" align=\"center\" nowrap><b><font color=\"red\">");
_sb.append(columnName);
_sb.append("</font></b></TD>");
}
else {
if (columnName.equals("受理总量")) {
_sb.append("<td class=\"body_td\" align=\"center\" nowrap><b>");
_sb.append(columnName);
_sb.append("</b></TD>");}
else
{_sb.append("<td class=\"body_td\" align=\"center\" nowrap><b><font color=\"blue\">");
_sb.append(columnName);
_sb.append("</font></b></TD>");}
}
}
else {
if(columnName.equals("FUNCODE")) {
_sb.append("<td class=\"body_td\" align=\"center\" nowrap style=\"display:none;\"><b>");
_sb.append(columnName);
_sb.append("</b></TD>");
}
else {
_sb.append("<td class=\"body_td\" align=\"center\" nowrap><b>");
_sb.append(columnName);
_sb.append("</b></TD>");
}
}
}
_sb.append("</tr>");
for(int iresult=0;iresult<dt.getRows().getCount(); iresult++){
_sb.append("<tr height=\"20\">");
DataRow drresult = dt.getRow(iresult);
for (int icol=0; icol<colcount-1;icol++){
if((sQueryType == null || sQueryType.equals("0"))) {
_sb.append("<td class=\"body_td\" align=\"left\" nowrap>");
if(icol == 2) {
if(!drresult.getString(icol).trim().equals("0")) {
String time = drresult.getString("受理时间").trim();
_sb.append("<a href='javascript:' title='"+time+"受理成功的"+tilte+"' onclick='getLog(\""+time+"\",\"3\",\""+sFunType+"\",\""+sProdfun+"\");'><font color=\"red\">");
_sb.append(drresult.getString(icol).trim().equals("")?" ":drresult.getString(icol).trim());
_sb.append("</font></a>");
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -