consomerservice.java
来自「电信的网厅的整站代码」· Java 代码 · 共 396 行
JAVA
396 行
package com.doone.fj1w.fjmgr.order;
import java.util.Map;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import com.doone.data.DataTable;
import com.doone.util.FileLogger;
public class ConsomerService {
static private FileLogger log = new FileLogger();
public ConsomerService() {
}
/**
* <p>
* 分类方式的行.
* </p>
*
* @param request
* @param response
* @param _map
* @return
*/
static public int getOrderMethodCount(ServletRequest request,
ServletResponse response, Map _map) {
return 1;
}
/**
* <p>
* 数据查询的分类方式，对每个分类的统计.
* </p>
*
* @param request
* @param response
* @param _map
* @return
*/
static public String getOrderMethod(ServletRequest request,
ServletResponse response, Map _map) {
try {
/**
* 状态 statu: 0: 所有订单 1: 待处理 7:回退 3: 暂存 2: 转派 4: 已作废 5: 已完成 6: 自己锁定
* 8:归档
*/
boolean flag = false;
String param_Statu = (String) _map.get("STATE");
String[] statu = new String[] { "1", "3", "2", "4", "5", "6", "8" };
String[] statuName = new String[] { "待处理", "暂存", "转派", "已作废",
"已完成", "自己锁定", "归档" };
StringBuffer _sb = new StringBuffer();
_sb.append("<table>");
_sb.append("<tr>");
_sb.append("<td style='cursor: default;'>");
if (param_Statu == null || param_Statu.equals("0")) {
// 显示所有
for (int i = 0; i < statu.length; i++) {
// 厦门不用显示归档.
String citycode = (String) _map.get("CITY");
if (statu[i].equals("8") && citycode.equals("0592")) {
continue;
}
DataTable _dt = ConsomerDAO.getOrderMethod(_map, statu[i]);
if (_dt == null)
continue;
try {
int count = _dt.getRow(0).getInt("count");
if (count == 0)
continue;
_sb
.append("<a href='javascript:' onclick='fnStateClick(this)'");
_sb.append(" name='ACTION' value='");
_sb.append(statu[i]);
_sb.append("' style='color: white;'>");
_sb.append(statuName[i]);
_sb.append("</a>(<font color='red'>");
_sb.append(count);
_sb.append("</font>) ");
flag = true;
} catch (RuntimeException rux) {
log.warn(rux.getMessage(), rux);
}
}
}
else {
DataTable _dt = ConsomerDAO.getOrderMethod(_map, param_Statu);
if (_dt != null && _dt.getRows().getCount() > 0) {
try {
int count = _dt.getRow(0).getInt("count");
if (count > 0) {
int i = 0;
for (; i < statu.length
&& !statu[i].equals(param_Statu); i++)
;
_sb
.append("<a href='javascript:' onclick='fnStateClick(this)'");
_sb.append(" name='ACTION' value='");
_sb.append(param_Statu);
_sb.append("' style='color: white;'>");
_sb.append(statuName[i]);
_sb.append("</a>(<font color='red'>");
_sb.append(count);
_sb.append("</font>) ");
flag = true;
}
} catch (RuntimeException rux) {
log.warn(rux.getMessage(), rux);
}
}
}
if (!flag) {
_sb.append("<font color='red'>没有符合以上条件的查询记录结果。</font>");
}
_sb.append("</td>");
_sb.append("</tr>");
_sb.append("</table>");
return _sb.toString();
} catch (Exception ex) {
log.warn(ex.getMessage(), ex);
}
return "";
}
/**
* <p>
* 获取查询内容表的所有行总数.
* </p>
*
* @param request
* @param response
* @param _map
* @return
*/
static public int getOrderCount(ServletRequest request,
ServletResponse response, Map _map) {
try {
if (_map == null)
return 0;
return ConsomerDAO.getOrderListCount(_map, (String) _map
.get("ACTION"));
} catch (Exception ex) {
log.warn(ex.getMessage(), ex);
}
return 0;
}
/**
* <p>
* 获取查询内容表的内容视图.
* </p>
*
* @param request
* @param response
* @param _map
* @return
*/
static public String getOrderList(ServletRequest request,
ServletResponse response, Map _map) {
StringBuffer _sb = new StringBuffer();
try {
int pageSize = Integer.parseInt((String) _map.get("pageSize"));
int currentPage = Integer
.parseInt((String) _map.get("currentPage"));
if (pageSize == -1 || currentPage == -1) {
log.info("页面参数为空。");
}
else {
log.info("pageSize:" + String.valueOf(pageSize));
log.info("currentPage:" + String.valueOf(currentPage));
}
int startrecord = currentPage * pageSize;
DataTable _dt = ConsomerDAO.getOrderList(_map, startrecord,
pageSize);
_sb.append("<table>");
if (_dt != null) {
for (int i = 0; i < _dt.getRows().getCount(); i++) {
String prodorderid = _dt.getRow(i).getString("appealid");
String weborder = _dt.getRow(i).getString("weborder");
// 业务类型，很多
String oparettype = _dt.getRow(i).getString(
"appealtypename");
String appeacontent = _dt.getRow(i).getString(
"appeacontent");
if (appeacontent != null && appeacontent.length() > 15) {
appeacontent = appeacontent.substring(0, 15) + "...";
}
String creatime = CommonMethod.formatResult(_dt.getRow(i)
.getString("createtime"));
if (creatime != null && creatime.length() > 16)
creatime = creatime.substring(0, 16);
// 用户锁定的用户id
String locksid = _dt.getRow(i).getString("lockstaffid");
if (locksid == null || locksid.equals(""))
locksid = "";
else {
locksid = ProdorderDAO.getStaffCode(locksid);
}
_sb.append("<tr key='");
_sb.append(prodorderid);
_sb.append("' type='2'>");
_sb
.append("<td class=\"body_td\" align=\"center\" nowrap>");
_sb
.append("<a href=\"javascript:\" onclick='window.setTimeout(\"fn_dblClick();\",10);'>");
_sb.append(weborder);
_sb.append("</a>");
_sb
.append("</td><td class=\"body_td\" align=\"left\" nowrap>");
if (oparettype != null && !oparettype.equals("")
&& !oparettype.equals("无")) {
_sb.append(oparettype);
}
else {
_sb.append("客户建议");
}
_sb.append("</td>");
_sb.append("<td class=\"body_td\" align=\"left\" nowrap>");
_sb.append(appeacontent);
_sb.append("</td>");
_sb.append("<td class=\"body_td\" align=\"left\" nowrap>");
_sb.append(creatime);
_sb.append("</td>");
_sb.append("<td class=\"body_td\" align=\"left\" nowrap>");
_sb.append(_dt.getRow(i).getString("statu"));
_sb.append("</td>");
_sb.append("<td class=\"body_td\" align=\"left\" nowrap>");
_sb
.append((locksid == null || locksid.equals("")) ? " "
: locksid);
_sb.append("</td></tr>");
}
}
_sb.append("</table>");
} catch (Exception rux) {
log.warn(rux.getMessage(), rux);
}
return _sb.toString();
}
/**
* <code>
* 获取建议投诉列表
* </code>
*
* @param citycode
* @return
*/
public static DataTable getAppealOrderList(ServletRequest request,
ServletResponse response, Map _map) {
try {
if (_map == null)
return null;
String city = (String) _map.get("CITYCODE");
return ConsomerDAO.getOrderList(city);
} catch (java.sql.SQLException sqlx) {
log.warn(sqlx.getMessage(), sqlx);
}
return null;
}
/** **************************************单个工单************************************** */
/**
* <p>
* 获取工单的历史审核记录
* </p>
*
* @param request
* @param response
* @param _map
* @return
*/
static public String getOrderHistory(ServletRequest request,
ServletResponse response, Map _map) {
try {
if (_map == null || _map.get("WEBORDER") == null) {
log.warn("请输入投诉建议的WEBORDER号.");
return "";
}
int pageSize = Integer.parseInt((String) _map.get("pageSize"));
int currentPage = Integer
.parseInt((String) _map.get("currentPage"));
if (pageSize == -1 || currentPage == -1) {
log.info("页面参数为空。");
}
else {
log.info("pageSize:" + String.valueOf(pageSize));
log.info("currentPage:" + String.valueOf(currentPage));
}
int startrecord = currentPage * pageSize;
StringBuffer _sb = new StringBuffer();
DataTable _dt = AppealHisDAO.getOrderHistory((String) _map
.get("WEBORDER"), startrecord, pageSize);
_sb.append("<table>");
if (_dt != null) {
for (int i = 0; i < _dt.getRows().getCount(); i++) {
String appealid = _dt.getRow(i).getString("APPEALID");
String time = _dt.getRow(i).getString("CREATETIME");// 受理时间
// 业务状态
String statu = _dt.getRow(i).getString("statu");
// 用户锁定的用户id
String locksid = _dt.getRow(i).getString("lockstaffid");
if (locksid == null || locksid.equals(""))
locksid = "";
else {
locksid = ProdorderDAO.getStaffCode(locksid);
}
_sb.append("<tr key='");
_sb.append(appealid);
_sb.append("' type=''>");
_sb
.append("<td class=\"body_td\" align=\"center\" nowrap>");
_sb.append(time);
_sb
.append("</td><td class=\"body_td\" align=\"left\" nowrap>");
_sb.append(statu);
_sb.append("</td>");
_sb.append("<td class=\"body_td\" align=\"left\" nowrap>");
_sb
.append((locksid == null || locksid.equals("")) ? " "
: locksid);
_sb.append("</td></tr>");
}
}
_sb.append("</table>");
return _sb.toString();
} catch (Exception ex) {
log.warn(ex.getMessage(), ex);
}
return "";
}
/**
* <code>获取不归档的工单历史记录总数</code>
*
* @param request
* @param response
* @param _map
* @return
*/
static public int getOrderHistoryCount(ServletRequest request,
ServletResponse response, Map _map) {
try {
if (_map == null || _map.get("WEBORDER") == null) {
log.warn("请输入投诉建议的WEBORDER号.");
return 0;
}
DataTable _dt = AppealHisDAO.getOrderHistoryCount((String) _map
.get("WEBORDER"));
if (_dt == null || _dt.getRows().getCount() == 0)
return 0;
return _dt.getRow(0).getInt("count");
} catch (Exception ex) {
log.warn(ex.getMessage(), ex);
}
return 0;
}
/** ************************************************************************************* */
}
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?