public class CCTelInfoSynJob extends QuartzJobBean {
private String synchrDate;
private CCTelSynService ccTelSynService;
private ICCTelInfoService ccTelInfoService;
private MailSenderService mailSenderSerivce =
(MailSenderService) ContextHolder.getBean("mailSenderService");
@Override
protected void executeInternal(JobExecutionContext context) throws JobExecutionException {
String dateString = null;
try {
System.out.println(
"synchronize cc 话务和满意度数据 at " + this.synchrDate + "of time " + DateUtil.getCurrentDate());
if (synchrDate.equalsIgnoreCase(
"current")) { // 默认是current代表每天同步当天的，如果是测试需要修改成null表示cc表任意时间数据都同步
// dateString = DateUtil.convertDateToString(DateUtil.getCurrentDate());
dateString = getDateTime("yyyy-MM-dd HH", new Date());
} else {
dateString = synchrDate;
}
ccTelSynService.saveCCTel2Native(dateString);
// 2010-09-08 modified by huzh for 返回既没进行话务反馈又没进行邮件反馈的CCCallInfo begin
// List<CCCallInfo> list = ccTelInfoService.getUnEmailCCCallInfo();
List<CCCallInfo> list = ccTelInfoService.getNoFeedBackofCCCall();
// 2010-09-08 modified by huzh for 返回既没进行话务反馈又没进行邮件反馈的CCCallInfo begin
this.sendEmailAndChangeFlag(list);
// ccTelInfoService.userSendEmail(mailSenderSerivce);
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* @Methods Name sendEmailAndChangeFlag @Create In Aug 14, 2009 By lee
*
* @param list void
*/
private void sendEmailAndChangeFlag(List<CCCallInfo> list) {
String url = PropertiesUtil.getProperties("cc.web.endUrl"); // 获取邮件页面
String rootPath = PropertiesUtil.getProperties("system.web.url"); // 获取项目根路径
for (int i = 0; i < list.size(); i++) {
CCCallInfo ccc = (CCCallInfo) list.get(i);
String customerItcode = ccc.getCustomerItcode();
String callId = ccc.getCallId();
// 在url中传参数：dataId,isExist
String dataId = ccc.getEvent().getId().toString();
String isExist = ccTelInfoService.isFeedback(callId) ? "s" : "f";
UserInfo userInfo = ccTelInfoService.getUserInfoByItCode(customerItcode);
String realUrl = rootPath + url + "?dataId=" + dataId + "&isExist=" + isExist;
if (userInfo != null) {
if ("s".equals(isExist)) { // 存在满意度
mailSenderSerivce.sendMimeMail(
userInfo.getEmail(),
null,
null,
"IT温馨提示:请"
+ userInfo.getRealName()
+ "/"
+ userInfo.getUserName()
+ "及时查看您所提交事件的处理情况。",
this.eventHtmlSatContent(userInfo, realUrl, ccc.getEvent()),
null);
} else {
mailSenderSerivce.sendMimeMail(
userInfo.getEmail(),
null,
null,
"IT温馨提示:请"
+ userInfo.getRealName()
+ "/"
+ userInfo.getUserName()
+ "及时查看您所提交事件的处理情况。",
this.eventNoSatHtmlContent(userInfo, realUrl, ccc.getEvent()),
null);
}
}
// mailSenderSerivce.sendSimplyMail("*****@*****.**", null, null, "事件处理情况",
// "事件处理情况");
ccc.setMailFlag(1);
ccTelInfoService.save(ccc);
}
}
public String getSynchrDate() {
return synchrDate;
}
public void setSynchrDate(String synchrDate) {
this.synchrDate = synchrDate;
}
public CCTelSynService getCcTelSynService() {
return ccTelSynService;
}
public void setCcTelSynService(CCTelSynService ccTelSynService) {
this.ccTelSynService = ccTelSynService;
}
public ICCTelInfoService getCcTelInfoService() {
return ccTelInfoService;
}
public void setCcTelInfoService(ICCTelInfoService ccTelInfoService) {
this.ccTelInfoService = ccTelInfoService;
}
public String getDateTime(String aMask, Date aDate) {
SimpleDateFormat df = null;
String returnValue = "";
// if (aDate == null) {
// log.error("aDate is null!");
// } else {
df = new SimpleDateFormat(aMask);
returnValue = df.format(aDate);
// }
return (returnValue);
}
// 邮件格式5 eventHtmlcontent3
// private String eventHtmlSatContent(UserInfo creator, String url,Event event) {
//
// StringBuilder sb = new StringBuilder();
// NumberFormat currencyFormat = NumberFormat.getNumberInstance();
// SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
// Date date = new Date();
// String dateString = dateFormat.format(date);
//
// sb.append("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
// sb.append("<html>");
// sb.append("<head>");
// sb.append("<title> 您已经成功提交一个问题，编号为("+event.getEventCisn()+"）”我们会尽快解决并向您反馈。谢谢</title>");
//
// sb.append("<meta http-equiv=\"keywords\" content=\"keyword1,keyword2,keyword3\">");
// sb.append("<meta http-equiv=\"description\" content=\"this is my page\">");
// sb.append("<meta http-equiv=\"content-type\" content=\"text/html; charset=GBK\">");
// // sb.append(" <!--<link rel=\"stylesheet\" type=\"text/css\"
// // href=\"./styles.css\">-->");
// sb.append("<!--<link rel=\"stylesheet\" type=\"text/css\" href=\"./styles.css\">-->");
//
// sb.append("< style type=\"text/css\">");
// sb.append("<!--");
// sb.append(".STYLE1 {");
// sb.append("font-size: 14px;");
// sb.append("line-height:20px;");
// sb.append("}");
// sb.append(".STYLE2 {");
// sb.append("font-family:'楷体_GB2312';");
// sb.append("font-size: 14px;");
// sb.append("}");
// sb.append("-->");
// sb.append(" </style>");
// sb.append("</head>");
// sb.append("<body>");
//
// sb.append("<div align=\"center\">");
// sb.append("<table width=\"1000px\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
// sb.append("<tr>");
// sb.append("<td >");
// sb.append("<div align=\"center\" >");
// sb.append("<div align=\"center\">邮件通知");
// sb.append("</div>");
// sb.append("</div>");
// sb.append("</td>");
// sb.append("</tr>");
// sb.append("<tr>");
// sb.append("<td class=\"STYLE1\">尊敬的"+creator.getRealName()+"/"+creator.getItcode()+"您好:");
// sb.append("</td>");
// sb.append("</tr>");
// sb.append("<tr>");
// sb.append("<td class=\"STYLE1\" style=\"text-indent:2em\">");
// sb.append("您提出的"+"<font style='font-weight:
// bold'>"+event.getSummary()+"</font>（事件编号为"+event.getEventCisn()+"），现在已经处理完毕。同时我们为您编写了该问题的处理文档，以期对您日后的工作中有所帮助！您可以点击" + "<a href=" + url + ">"
// + "链接</a>"+"访问,谢谢！");
// sb.append("</td>");
// sb.append("</tr>");
// sb.append("<tr>");
// sb.append("<td class=\"STYLE2\">");
// sb.append("<br>感谢您使用集团IT服务，如果您对我们有任何意见和建议,可以发送邮件到[email protected],或者拨打IT服务建议及投诉热线7888-0。");
// sb.append("</td>");
// sb.append("</tr>");
// sb.append("<tr>");
// sb.append("<td class=\"STYLE1\" align=\"right\">");
// sb.append("<br>信息系统部");
// sb.append("</td>");
// sb.append("</tr>");
// sb.append("<tr>");
// sb.append("<td class=\"STYLE1\" align=\"right\">");
// sb.append(dateString);
// sb.append("</td>");
// sb.append("</tr>");
// sb.append("</table>");
// sb.append("</div>");
// sb.append("</body>");
// sb.append("</html>");
// return sb.toString();
// }
private String eventHtmlSatContent(UserInfo creator, String url, Event event) {
StringBuilder sb = new StringBuilder();
NumberFormat currencyFormat = NumberFormat.getNumberInstance();
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
Date date = new Date();
String dateString = dateFormat.format(date);
sb.append("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
sb.append("<html>");
sb.append(" <head>");
sb.append(" <title>PO Details</title>");
sb.append(" <meta http-equiv=\"keywords\" content=\"keyword1,keyword2,keyword3\">");
sb.append(" <meta http-equiv=\"description\" content=\"this is my page\">");
sb.append(" <meta http-equiv=\"content-type\" content=\"text/html; charset=GBK\">");
sb.append(" <!--<link rel=\"stylesheet\" type=\"text/css\" href=\"./styles.css\">-->");
sb.append("<style type=\"text/css\">");
sb.append("<!--");
sb.append(".STYLE1 {");
sb.append("font-size: 14px;");
sb.append("line-height:20px;");
sb.append("}");
sb.append(".STYLE2 {");
sb.append("font-family:'楷体';");
sb.append("font-size: 14px;");
sb.append("}");
sb.append("-->");
sb.append("</style>");
sb.append(" </head>");
sb.append(" <body>");
sb.append(" <div align=\"center\">");
sb.append(
" <table width=\"900\" height=\"200\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
sb.append(" <tr>");
sb.append(
" <td height=\"29\" colspan=\"3\" nowrap><div align=\"center\" class=\"STYLE1\"><h3>邮件通知</h3></div></td>");
sb.append(" </tr>");
sb.append(" <tr>");
sb.append(
" <td class=\"STYLE1\">尊敬的"
+ creator.getRealName()
+ "/"
+ creator.getUserName()
+ "，您好：</td>");
sb.append(" </tr>");
sb.append(" <br>");
sb.append("<tr>");
sb.append("<td class=\"STYLE1\" style=\"text-indent:2em\">");
sb.append(
"您提交的事件（"
+ "事件名称：<font style='font-weight: bold'>"
+ event.getSummary()
+ "</font>"
+ "，事件编号：<font style='font-weight: bold'>"
+ event.getEventCisn()
+ "</font>），现在已经处理完毕。同时我们为您编写了该问题的处理文档，以期对您日后的工作中有所帮助！您可以"
+ "<a href="
+ url
+ ">"
+ "点击链接</a>"
+ "访问，谢谢！");
sb.append("</td>");
sb.append("</tr>");
sb.append("<tr>");
sb.append("<td style=\"font-family:楷体\">");
sb.append("<br>感谢您使用集团IT服务，如果您对我们有任何意见和建议,可以发送邮件到[email protected],或者拨打IT服务建议及投诉热线7888-0。");
sb.append("</td>");
sb.append("</tr>");
sb.append("<tr>");
sb.append("<td class=\"STYLE1\" align=\"right\">");
sb.append("<br>信息系统部");
sb.append("</td>");
sb.append("</tr>");
sb.append("<tr>");
sb.append("<td class=\"STYLE1\" align=\"right\">");
sb.append(dateString);
sb.append("</td>");
sb.append("</tr>");
sb.append("<tr>");
sb.append("<td style=\"FILTER:alpha(opacity=30);font-size:10px\" align=\"left\">");
sb.append("<br>本邮件由集团IT服务系统（ITSS）自动发送，请勿直接回复。");
sb.append("</td>");
sb.append("</tr>");
sb.append(" </table>");
sb.append(" </div>");
sb.append(" </body>");
sb.append("</html>");
return sb.toString();
}
// 邮件格式6 eventHtmlcontent6
// private String eventNoSatHtmlContent(UserInfo creator, String url,Event event) {
//
//
// StringBuilder sb = new StringBuilder();
// NumberFormat currencyFormat = NumberFormat.getNumberInstance();
// SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
// Date date = new Date();
// String dateString = dateFormat.format(date);
//
// sb.append("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
// sb.append("<html>");
// sb.append("<head>");
// sb.append("<title> 您已经成功提交一个问题，编号为("+event.getEventCisn()+"）”我们会尽快解决并向您反馈。谢谢</title>");
//
// sb.append("<meta http-equiv=\"keywords\" content=\"keyword1,keyword2,keyword3\">");
// sb.append("<meta http-equiv=\"description\" content=\"this is my page\">");
// sb.append("<meta http-equiv=\"content-type\" content=\"text/html; charset=GBK\">");
// // sb.append(" <!--<link rel=\"stylesheet\" type=\"text/css\"
// // href=\"./styles.css\">-->");
// sb.append(" <!--<link rel=\"stylesheet\" type=\"text/css\" href=\"./styles.css\">-->");
//
// sb.append("<style type=\"text/css\">");
//
// sb.append("<!--");
// sb.append(".STYLE1 {");
// sb.append("font-size: 14px;");
// sb.append("line-height:20px;");
// sb.append("}");
// sb.append(".STYLE2 {");
// sb.append("font-family:'楷体_GB2312';");
// sb.append("font-size: 14px;");
// sb.append("}");
//
//
// sb.append("-->");
// sb.append("</style>");
// sb.append("</head>");
// sb.append("<body>");
// sb.append("<div align=\"center\">");
// sb.append("<table width=\"1000px\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
// sb.append("<tr>");
// sb.append("<td style=\"font-size:20px\" align=\"center\">事件进展通知</td>");
// sb.append("</tr>");
// sb.append("<tr>");
// sb.append("<td
// class=\"STYLE1\">尊敬的"+creator.getRealName()+"/"+creator.getItcode()+"您好:</td>");
// sb.append("</tr>");
// sb.append("<tr>");
// sb.append("<td class=\"STYLE1\" style=\"padding-left:2em\">");
// sb.append("您提出的"+"<font style='font-weight:
// bold'>"+event.getSummary()+"</font>（事件编号为"+event.getEventCisn()+"），现在已经处理完毕。");
// sb.append("<br>同时我们为您编写了该问题的处理文档，以期对您日后的工作中有所帮助！您可以点击" + "<a href=" + url + ">"
// + "链接</a>" + "访问。");
// sb.append("<br>为了帮助我们提高IT服务质量，请您在确认后抽出20-30秒的时间对我们的IT服务进行满意度评价，谢谢！");
// sb.append("</td>");
// sb.append("</tr>");
// sb.append("<tr>");
// sb.append("<td class=\"STYLE2\">");
// sb.append("<br>感谢您使用集团IT服务，如果您对我们有任何意见和建议,可以发送邮件到[email protected],或者拨打IT服务建议及投诉热线7888-0。");
// sb.append("</td>");
// sb.append("</tr>");
// sb.append("<tr>");
// sb.append("<td class=\"STYLE1\" align=\"right\">");
// sb.append("<br>信息系统部");
// sb.append("</td>");
// sb.append("</tr>");
// sb.append("<tr>");
// sb.append("<td class=\"STYLE1\" align=\"right\">");
// sb.append(dateString);
// sb.append("</td>");
// sb.append("</tr>");
// sb.append("</table>");
// sb.append("</div>");
// sb.append("</body>");
// sb.append("</html>");
// return sb.toString();
// }
private String eventNoSatHtmlContent(UserInfo creator, String url, Event event) {
StringBuilder sb = new StringBuilder();
NumberFormat currencyFormat = NumberFormat.getNumberInstance();
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
Date date = new Date();
String dateString = dateFormat.format(date);
sb.append("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
sb.append("<html>");
sb.append(" <head>");
sb.append(" <title>PO Details</title>");
sb.append(" <meta http-equiv=\"keywords\" content=\"keyword1,keyword2,keyword3\">");
sb.append(" <meta http-equiv=\"description\" content=\"this is my page\">");
sb.append(" <meta http-equiv=\"content-type\" content=\"text/html; charset=GBK\">");
sb.append(" <!--<link rel=\"stylesheet\" type=\"text/css\" href=\"./styles.css\">-->");
sb.append("<style type=\"text/css\">");
sb.append("<!--");
sb.append(".STYLE1 {");
sb.append("font-size: 14px;");
sb.append("line-height:20px;");
sb.append("}");
sb.append(".STYLE2 {");
sb.append("font-family:'楷体';");
sb.append("font-size: 14px;");
sb.append("}");
sb.append("-->");
sb.append("</style>");
sb.append(" </head>");
sb.append(" <body>");
sb.append(" <div align=\"center\">");
sb.append(
" <table width=\"900\" height=\"200\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
sb.append(" <tr>");
sb.append(
" <td height=\"29\" colspan=\"3\" nowrap><div align=\"center\" class=\"STYLE1\"><h3>邮件通知</h3></div></td>");
sb.append(" </tr>");
sb.append(" <tr>");
sb.append(
" <td class=\"STYLE1\">尊敬的"
+ creator.getRealName()
+ "/"
+ creator.getUserName()
+ "，您好：</td>");
sb.append(" </tr>");
sb.append(" <br>");
sb.append("<tr>");
sb.append("<td class=\"STYLE1\" style=\"padding-left:2em\">");
sb.append(
"您提交的事件（"
+ "事件名称：<font style='font-weight: bold'>"
+ event.getSummary()
+ "</font>"
+ "，事件编号：<font style='font-weight: bold'>"
+ event.getEventCisn()
+ "</font>），现在已经处理完毕。");
sb.append(
"<br>同时我们为您编写了该问题的处理文档，以期对您日后的工作中有所帮助！您可以" + "<a href=" + url + ">" + "点击此链接</a>" + "访问。");
sb.append("<br>为了帮助我们提高IT服务质量，请您在确认后抽出20-30秒的时间对我们的IT服务进行满意度评价，谢谢！");
sb.append("</td>");
sb.append("</tr>");
sb.append("<tr>");
sb.append("<td style=\"font-family:楷体\">");
sb.append("<br>感谢您使用集团IT服务，如果您对我们有任何意见和建议，可以发送邮件到[email protected]，或者拨打IT服务建议及投诉热线7888-0。");
sb.append("</td>");
sb.append("</tr>");
sb.append("<tr>");
sb.append("<td class=\"STYLE1\" align=\"right\">");
sb.append("<br>信息系统部");
sb.append("</td>");
sb.append("</tr>");
sb.append("<tr>");
sb.append("<td class=\"STYLE1\" align=\"right\">");
sb.append(dateString);
sb.append("</td>");
sb.append("</tr>");
sb.append("<tr>");
sb.append("<td style=\"FILTER:alpha(opacity=30);font-size:10px\" align=\"left\">");
sb.append("<br>本邮件由集团IT服务系统（ITSS）自动发送，请勿直接回复。");
sb.append("</td>");
sb.append("</tr>");
sb.append(" </table>");
sb.append(" </div>");
sb.append(" </body>");
sb.append("</html>");
return sb.toString();
}
}
@SuppressWarnings("serial")
public class ObjectView extends BaseServlet {
private PageManager pageManager = (PageManager) ContextHolder.getBean("pageManager");
private MetaDataManager metaDataManager =
(MetaDataManager) ContextHolder.getBean("metaDataManager");
private Service service = (Service) ContextHolder.getBean("baseService");
private PageModelService pageModelService =
(PageModelService) ContextHolder.getBean("pageModelService");
private PagePanelService pagePanelService =
(PagePanelService) ContextHolder.getBean("pagePanelService");
// private PagePanelColumnService pagePanelColumnService =
// (PagePanelColumnService)ContextHolder.getBean("pagePanelColumnService");
private PagePanelBtnService pagePanelBtnService =
(PagePanelBtnService) ContextHolder.getBean("pagePanelBtnService");
// private ConfigItemService configItemService = (ConfigItemService)
// ContextHolder.getBean("configItemService");
private PageGroupPanelService pgps =
(PageGroupPanelService) ContextHolder.getBean("pageGroupPanelService");
// private RequirementService rs = (RequirementService)
// ContextHolder.getBean("requirementService");
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("gbk");
response.setCharacterEncoding("gbk");
String msg = "";
String method = request.getParameter("method");
if (StringUtils.isBlank(method)) {
msg = "Error: no method specified.";
} else {
if (method.trim().equalsIgnoreCase("save")) {
msg = forSave(request);
} else if (method.trim().equalsIgnoreCase("saveSingleForm")) {
msg = forSaveSingleForm(request);
} else if (method.trim().equalsIgnoreCase("saveSingleFormForLook")) {
msg = forSaveSingleFormForLook(request);
} else if (method.trim().equalsIgnoreCase("query")) {
msg = forQuery(request);
} else if (method.trim().equalsIgnoreCase("html")) {
msg = forHtmlQuery(request);
} else if (method.trim().equalsIgnoreCase("head")) {
msg = forHead(request);
} else if (method.trim().equalsIgnoreCase("listHead")) {
msg = forListHead(request);
} else if (method.trim().equalsIgnoreCase("pageModel")) {
msg = forModel(request); // 如取动态分组面板，调用forModel2，但目前还不能保存
} else if (method.trim().equalsIgnoreCase("pageModelButton")) {
msg = forModelButton(request);
} else if (method.trim().equalsIgnoreCase("look")) {
msg = forLook(request);
} else if (method.trim().equalsIgnoreCase("pagePanelButton")) {
msg = forPanelButton(request);
} else if (method.trim().equalsIgnoreCase("gridTreeHead")) {
msg = forGridTreeHead(request);
}
}
response.setContentType("text/plain");
PrintWriter out = response.getWriter();
out.println(msg);
out.flush();
out.close();
}
/**
* 为树形列表提供表头 @Methods Name forGridTreeHead @Create In Mar 13, 2009 By lee
*
* @param request
* @return String
*/
private String forGridTreeHead(HttpServletRequest request) {
String panelName = request.getParameter("panelname");
PagePanel pagePanel = pagePanelService.findPagePanel(panelName);
if (pagePanel == null) return null;
// String className = pagePanel.getSystemMainTable().getClassName();
// List<UserTableSetting> utss = metaDataManager.getUserColumnForList(getClass(className));
// PagePanel panel=pagePanelService.findPagePanel(panelName);
List<PagePanelColumn> pagePanelColumns = pageManager.getUserPagePanelColumn(panelName);
String json = "";
for (PagePanelColumn ppcolumn : pagePanelColumns) { // 改成遍历
Column column = ppcolumn.getColumn();
String tableName = ppcolumn.getSystemMainTable().getTableName();
String propertyName = column.getPropertyName();
json += "{name:" + "'" + tableName + "$" + propertyName + "'" + "},";
}
// json+="{name:'_id'},";
json += "{name:'_parent'},";
json += "{name:'_level'},";
json += "{name:'_lft'},";
json += "{name:'_rgt'},";
json += "{name:'_is_leaf'}";
json = "[" + json + "]";
return json;
}
private String forModelButton(HttpServletRequest request) {
String keyName = request.getParameter("modelName");
PageModel model = pageModelService.findPageModel(keyName);
String json = "[";
List<PageModelBtn> pmbs = pageModelService.findPageModelBtnByModel(model);
if (pmbs.isEmpty()) {
json += "";
} else {
for (PageModelBtn pmb : pmbs) {
if (pmb.getIsDisplay() == 1) {
json += "{";
json += "\"btnName\":\"" + pmb.getBtnName() + "\",";
json += "\"container\":\"" + pmb.getPageModel().getName() + "\",";
json +=
"\"containerTable\":\""
+ pmb.getPageModel().getSystemMainTable().getTableName()
+ "\",";
json += "\"method\":\"" + pmb.getMethod() + "\",";
json += "\"link\":\"" + pmb.getLink() + "\",";
json +=
"\"nextPageModel\":\""
+ (pmb.getNextPageModel() == null ? "" : pmb.getNextPageModel().getName())
+ "\",";
json += "\"imageUrl\":\"" + pmb.getImageUrl() + "\"";
json += "},";
}
}
if (json.length() > 1) json = json.substring(0, json.length() - 1);
}
json += "]";
return json;
}
private String forPanelButton(HttpServletRequest request) {
String keyName = request.getParameter("panelName");
PagePanel panel = pagePanelService.findPagePanel(keyName);
String json = "[";
List<PagePanelBtn> ppbs = pagePanelBtnService.findPanelBtnByPanel(panel);
if (ppbs.isEmpty()) {
json += "";
} else {
for (PagePanelBtn ppb : ppbs) {
if (ppb.getIsDisplay() != null && ppb.getIsDisplay() == 1) {
json += "{";
json += "\"btnName\":\"" + ppb.getBtnName() + "\",";
json += "\"container\":\"" + ppb.getPagePanel().getName() + "\",";
json +=
"\"containerTable\":\""
+ ppb.getPagePanel().getSystemMainTable().getTableName()
+ "\",";
json += "\"method\":\"" + ppb.getMethod() + "\",";
json += "\"link\":\"" + ppb.getLink() + "\",";
json +=
"\"nextPageModel\":\""
+ (ppb.getNextPageModel() == null ? "" : ppb.getNextPageModel().getName())
+ "\",";
json += "\"imageUrl\":\"" + ppb.getImageUrl() + "\"";
json += "},";
}
}
if (json.length() > 1) json = json.substring(0, json.length() - 1);
}
json += "]";
return json;
}
private String genPagePanelJson(PageModelPanel pmp) {
String json = "";
PagePanel panel = pmp.getPagePanel();
String divFloat = pmp.getDivFloat();
String fcolumnPropName = "";
String pcolumnPropName = "";
json += "{";
json += "\"panelname\":\"" + panel.getName() + "\",";
json += "\"title\":\"" + panel.getTitle() + "\",";
if (panel.getGroupFlag() != null && panel.getGroupFlag().intValue() == 0) {
json += "\"panelTableName\":\"" + panel.getSystemMainTable().getTableCnName() + "\",";
json += "\"clazz\":\"" + panel.getSystemMainTable().getClassName() + "\",";
// 如果model根面板属于可编辑面板，如财务面板改成editorGrid，它就引用配置项
if (panel.getXtype().getName().equalsIgnoreCase("editorgrid")
|| panel.getXtype().getName().equalsIgnoreCase("grid")) {
SystemMainTable subTable = panel.getSystemMainTable();
List<PageModelPanelTable> pmpts =
this.pageModelService.findPageModelPanelTableBySub(pmp.getPageModel(), panel, subTable);
for (PageModelPanelTable pmpt : pmpts) {
// 配置项面板
PagePanel parentPanel = pmpt.getParentPagePanel();
// 配置项父表
SystemMainTable parentTable = parentPanel.getSystemMainTable();
SystemMainTableColumn parentPanelTablePColumn = pmpt.getParentPanelTablePColumn();
// ConfigItem$id
pcolumnPropName =
parentTable.getTableName() + "$" + parentPanelTablePColumn.getPropertyName();
SystemMainTableColumn subFc = pmpt.getSubPanelTableFColumn();
fcolumnPropName = subFc.getPropertyName();
}
}
}
json += "\"fcolumnName\":\"" + fcolumnPropName + "\",";
json += "\"pcolumnName\":\"" + pcolumnPropName + "\",";
json += "\"xtype\":\"" + panel.getXtype().getName() + "\",";
json += "\"groupFlag\":\"" + panel.getGroupFlag() + "\",";
Integer readonlyFlag = pmp.getReadonly();
if (readonlyFlag == null) readonlyFlag = 0;
json += "\"readonlyFlag\":\"" + readonlyFlag + "\",";
json += "\"queryFlag\":\"" + panel.getQueryFlag() + "\",";
json += "\"divFloat\":\"" + divFloat + "\",";
json += "\"order\":\"" + pmp.getOrder() + "\"";
Set<PagePanelRelation> childpprs = panel.getChildPagePanels();
if (!childpprs.isEmpty()) { // 遍历分组面板下面的面板
json += ",\"childPagePanels\":[";
for (PagePanelRelation ppr : childpprs) {
json += this.genPagePanelJson(ppr);
json += ",";
}
json = json.substring(0, json.length() - 1);
json += "]";
}
json += "}";
return json;
}
/**
* 单个面板生成JSON方法 @Methods Name genPagePanelJson @Create In Apr 20, 2009 By sa
*
* @param panel
* @return String
*/
@SuppressWarnings("unused")
private String genPagePanelJson(PagePanel panel) {
String json = "";
// PagePanel panel = pmp.getPagePanel();
// String divFloat = pmp.getDivFloat();
String fcolumnPropName = "";
String pcolumnPropName = "";
json += "{";
json += "\"panelname\":\"" + panel.getName() + "\",";
json += "\"title\":\"" + panel.getTitle() + "\",";
if (panel.getGroupFlag() != null && panel.getGroupFlag().intValue() == 0) {
json += "\"panelTableName\":\"" + panel.getSystemMainTable().getTableCnName() + "\",";
json += "\"clazz\":\"" + panel.getSystemMainTable().getClassName() + "\",";
// 此处缺少面板中多表的关系处理
//
// if(panel.getXtype().getName().equalsIgnoreCase("editorgrid")||panel.getXtype().getName().equalsIgnoreCase("grid")){
// SystemMainTable subTable = panel.getSystemMainTable();
// List<PageModelPanelTable> pmpts = this.pageModelService.findPageModelPanelTableBySub(
// pmp.getPageModel(), panel, subTable);
// for(PageModelPanelTable pmpt : pmpts){
// //配置项面板
// PagePanel parentPanel = pmpt.getParentPagePanel();
// //配置项父表
// SystemMainTable parentTable = parentPanel.getSystemMainTable();
// SystemMainTableColumn parentPanelTablePColumn = pmpt.getParentPanelTablePColumn();
// //ConfigItem$id
// pcolumnPropName =
// parentTable.getTableName()+"$"+parentPanelTablePColumn.getPropertyName();
// SystemMainTableColumn subFc = pmpt.getSubPanelTableFColumn();
// fcolumnPropName = subFc.getPropertyName();
// }
//
// }
}
json += "\"fcolumnName\":\"" + fcolumnPropName + "\",";
json += "\"pcolumnName\":\"" + pcolumnPropName + "\",";
json += "\"xtype\":\"" + panel.getXtype().getName() + "\",";
json += "\"groupFlag\":\"" + panel.getGroupFlag() + "\",";
// Integer readonlyFlag = pmp.getReadonly();
// if(readonlyFlag==null) readonlyFlag=0;
// json += "\"readonlyFlag\":\""+readonlyFlag+"\",";
json += "\"queryFlag\":\"" + panel.getQueryFlag() + "\",";
// json += "\"divFloat\":\""+divFloat+"\"";
// json += "\"order\":\""+pmp.getOrder()+"\"";
Set<PagePanelRelation> childpprs = panel.getChildPagePanels();
if (!childpprs.isEmpty()) { // 遍历分组面板下面的面板
json += ",\"childPagePanels\":[";
for (PagePanelRelation ppr : childpprs) {
json += this.genPagePanelJson(ppr);
json += ",";
}
json = json.substring(0, json.length() - 1);
json += "]";
}
json += "}";
return json;
}
private String genPagePanelJson(PagePanelRelation pmp) {
String json = "";
PagePanel panel = pmp.getPagePanel();
String fcolumnPropName = "";
String pcolumnPropName = "";
json += "{";
json += "\"panelname\":\"" + panel.getName() + "\",";
json += "\"title\":\"" + panel.getTitle() + "\",";
if (panel.getGroupFlag() != null && panel.getGroupFlag().intValue() == 0) {
json += "\"panelTableName\":\"" + panel.getSystemMainTable().getTableCnName() + "\",";
json += "\"clazz\":\"" + panel.getSystemMainTable().getClassName() + "\",";
List<PageGroupPanelTable> list =
this.pgps.findGroupPanelTableBySub(pmp.getParentPagePanel(), panel);
PageGroupPanelTable pgpt = null;
if (list != null && !list.isEmpty()) {
pgpt = list.iterator().next();
}
if (pgpt != null) {
SystemMainTableColumn fcolumn = pgpt.getSubPanelTableFColumn();
fcolumnPropName = fcolumn.getPropertyName();
SystemMainTable parentPanelTable = pgpt.getParentPanelTable();
String pptableName = parentPanelTable.getTableName();
SystemMainTableColumn pc = pgpt.getParentPanelTablePColumn();
pcolumnPropName = pc.getPropertyName();
pcolumnPropName = pptableName + "$" + pcolumnPropName;
}
}
json += "\"fcolumnName\":\"" + fcolumnPropName + "\",";
json += "\"pcolumnName\":\"" + pcolumnPropName + "\",";
json += "\"xtype\":\"" + panel.getXtype().getName() + "\",";
Integer readonlyFlag = pmp.getReadonly();
if (readonlyFlag == null) readonlyFlag = 0;
json += "\"readonlyFlag\":\"" + readonlyFlag + "\",";
json += "\"groupFlag\":\"" + panel.getGroupFlag() + "\",";
json += "\"queryFlag\":\"" + panel.getQueryFlag() + "\",";
json += "\"order\":\"" + pmp.getOrder() + "\"";
Set<PagePanelRelation> childpprs = panel.getChildPagePanels();
if (!childpprs.isEmpty()) {
json += ",\"childPagePanels\":[";
for (PagePanelRelation ppr : childpprs) {
json += this.genPagePanelJson(ppr);
json += ",";
}
json = json.substring(0, json.length() - 1);
json += "]";
}
json += "}";
return json;
}
private String forModel(HttpServletRequest request) {
String keyName = request.getParameter("name");
// String dataId = request.getParameter("dataId");
// 根据model的关键字取model，此方法是考虑新的分组面板思想而设计的，底层主动获取分组面板的子面板
PageModel model = pageModelService.findPageModel$$$$$(keyName);
String json = "";
json = "{\"pageModel\":[{";
json += "\"name\":\"" + model.getName() + "\",";
json += "\"title\":\"" + model.getTitle() + "\",";
json += "\"modelTableName\":\"" + model.getSystemMainTable().getTableName() + "\",";
json += "\"pagePathType\":\"" + model.getPagePanelType().getName() + "\",";
json += "\"pagePath\":\"" + model.getPagePath() + "\"";
json += "}],";
// end
List<PageModelPanel> pmps = model.getPagePanels();
if (pmps.isEmpty()) {
json = ""; // 告诉页面model没有选择panel
return json;
} // end按钮生成
// 生成panel
json += "\"panels\":[";
for (PageModelPanel item : pmps) { // 遍历model下的根面板
// 生成pageModel下面板json
json += this.genPagePanelJson(item); // 进入递归方法，传入分组面板
json += ",";
}
json = json.substring(0, json.length() - 1);
json += "]}";
// *******************************************************************
System.out.println(json);
return json;
}
// private String forModelConfigItem(HttpServletRequest request) {
// String keyName = request.getParameter("name");
// String dataId = request.getParameter("dataId");
// //根据model的关键字取model，此方法是考虑新的分组面板思想而设计的，底层主动获取分组面板的子面板
// PageModel model = pageModelService.findPageModel$$$$$(keyName);
// String json = "";
// json="{\"pageModel\":[{";
// json += "\"name\":\""+model.getName()+"\",";
// json += "\"title\":\""+model.getTitle()+"\",";
// json += "\"modelTableName\":\""+model.getSystemMainTable().getTableName()+"\",";
// json += "\"pagePathType\":\""+model.getPagePanelType().getName()+"\",";
// json += "\"pagePath\":\""+model.getPagePath()+"\"";
// json+="}],";
// List<PageModelPanel> pmps = null;
//
//// 如果配置项id不空，调用我们的配置项服务获取动态的panel
// if(StringUtils.isNotBlank(dataId)&& !dataId.equals("0")){
// pmps = configItemService.findPageModelPanel(keyName, dataId);
// }else{
// pmps = model.getPagePanels();
// }
// if(pmps.isEmpty()){
// json=""; //告诉页面model没有选择panel
// return json;
// }//end按钮生成
//
// //生成panel
// json+="\"panels\":[";
// for(PageModelPanel item : pmps){ //遍历model下的根面板
// //生成pageModel下面板json
// json+= this.genPagePanelJson(item); //进入递归方法，传入分组面板
// json+=",";
//
// }
// json = json.substring(0, json.length()-1);
// json += "]}";
// //*******************************************************************
// System.out.println(json);
// return json;
// }
/**
* 保存使用的元数据 @Methods Name forSave @Create In Sep 9, 2008 By yang
*
* @param request
* @return @ReturnType String
*/
private String forSave(HttpServletRequest request) {
String json = "";
String id = request.getParameter("id");
String modelName = request.getParameter("modelname");
String panelName = request.getParameter("panelname");
PagePanel panel = pagePanelService.findPagePanel(panelName);
List<PagePanelColumn> pagePanelColumns = pageManager.getUserPagePanelColumn(panelName);
Map<String, Object> dataMap = null;
if (StringUtils.isNotBlank(id)) {
List<Map<String, Object>> listMap = null;
// 此代码有问题应该用下面的
// listMap = configItemService.getRequireCIDataForEdit(modelName, panelName, id);
// }else{
listMap = pageManager.getPagePanelDataForEdit(modelName, panelName, id);
// }
if (listMap != null && !listMap.isEmpty()) {
if (panel.getXtype().getName().equals("form")) {
dataMap = listMap.iterator().next();
String webContext = request.getContextPath();
dataMap.put("webContext", webContext);
json = CoderForSave.encode(pagePanelColumns, dataMap, true);
} else if (panel.getXtype().getName().equals("editorgrid")) {
int total = listMap.size();
json = CoderForList.encode(pagePanelColumns, listMap, Long.valueOf(total));
}
}
} else {
dataMap = pageManager.getPagePanelDataForAdd(panelName);
json = CoderForSave.encode(pagePanelColumns, dataMap, false);
}
return json;
}
/**
* 只读预览功能 @Methods Name forLook @Create In 2009-3-13 By sa
*
* @param request
* @return String
*/
private String forLook(HttpServletRequest request) {
String json = "";
String id = request.getParameter("id");
String modelName = request.getParameter("modelname");
String panelName = request.getParameter("panelname");
PagePanel panel = pagePanelService.findPagePanel(panelName);
List<PagePanelColumn> pagePanelColumns = pageManager.getUserPagePanelColumn(panelName);
Map<String, Object> dataMap = null;
if (StringUtils.isNotBlank(id)) {
List<Map<String, Object>> listMap =
pageManager.getPagePanelDataForLook(modelName, panelName, id);
if (listMap != null && !listMap.isEmpty()) {
if (panel.getXtype().getName().equals("form")) {
dataMap = listMap.iterator().next();
json = CoderForLook.encode(pagePanelColumns, dataMap, true);
} else if (panel.getXtype().getName().equals("editorgrid")) {
int total = listMap.size();
json = CoderForList.encode(pagePanelColumns, listMap, Long.valueOf(total));
}
}
} else {
dataMap = pageManager.getPagePanelDataForAdd(panelName);
json = CoderForLook.encode(pagePanelColumns, dataMap, false);
}
return json;
}
/**
* 获取单Form面板元数据 @Methods Name forSaveSingleForm @Create 2009-3-4 By lee
*
* @param request
* @return @ReturnType String
*/
private String forSaveSingleForm(HttpServletRequest request) {
String json = "";
String id = request.getParameter("id");
String panelName = request.getParameter("panelname");
PagePanel panel = pagePanelService.findPagePanel(panelName);
SystemMainTable smt = panel.getSystemMainTable();
String tableName = smt.getTableName();
String className = smt.getClassName();
Class clazz = null;
try {
clazz = Class.forName(className);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
List<PagePanelColumn> pagePanelColumns = pageManager.getUserPagePanelColumn(panelName);
Map<String, Object> dataMap = null;
if (StringUtils.isNotBlank(id)) {
if (panel.getXtype().getName().equals("form")) {
Object obj = service.find(clazz, id, true);
dataMap = metaDataManager.getEntityDataForEdit(obj, tableName);
json = CoderForSave.encode(pagePanelColumns, dataMap, true);
} else {
json = null;
}
} else {
dataMap = pageManager.getPagePanelDataForAdd(panelName);
json = CoderForSave.encode(pagePanelColumns, dataMap, false);
}
return json;
}
/**
* 获取单Form面板元数据 @Methods Name forSaveSingleFormForLook @Create 2009-4-20 By daijf
*
* @param request
* @return @ReturnType String
*/
private String forSaveSingleFormForLook(HttpServletRequest request) {
String json = "";
String id = request.getParameter("id");
String panelName = request.getParameter("panelname");
PagePanel panel = pagePanelService.findPagePanel(panelName);
SystemMainTable smt = panel.getSystemMainTable();
String tableName = smt.getTableName();
String className = smt.getClassName();
Class clazz = null;
try {
clazz = Class.forName(className);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
List<PagePanelColumn> pagePanelColumns = pageManager.getUserPagePanelColumn(panelName);
Map<String, Object> dataMap = null;
if (StringUtils.isNotBlank(id)) {
if (panel.getXtype().getName().equals("form")) {
Object obj = service.find(clazz, id, true);
dataMap = metaDataManager.getEntityDataForLook(obj, tableName);
json = CoderForLook.encode(pagePanelColumns, dataMap, true);
} else {
json = null;
}
} else {
dataMap = pageManager.getPagePanelDataForAdd(panelName);
json = CoderForLook.encode(pagePanelColumns, dataMap, false);
}
return json;
}
/**
* 保存配置项信息 @Methods Name forSaveConfigItem @Create In 2008-12-31 By sa
*
* @param request
* @return String
*/
// private String forSaveConfigItem(HttpServletRequest request) {
// String json = "";
// String id = request.getParameter("id");
//
// String modelName = request.getParameter("modelname");
// String panelName = request.getParameter("panelname");
// PagePanel panel=pagePanelService.findPagePanel(panelName);
// List<PagePanelColumn> pagePanelColumns=pageManager.getUserPagePanelColumn(panelName);
//
// Map<String, Object> dataMap = null;
// if (StringUtils.isNotBlank(id)) {
// List<Map<String,Object>> listMap = configItemService.getPagePanelDataForEdit(modelName,
// panelName, id);
// if(listMap!=null&& !listMap.isEmpty()){
// if(panel.getXtype().getName().equals("form")){
// dataMap = listMap.iterator().next();
// json = CoderForSave.encode(pagePanelColumns, dataMap, true);
//
// }else if(panel.getXtype().getName().equals("editorgrid")){
// int total = listMap.size();
// json = CoderForList.encode(pagePanelColumns, listMap, Long.valueOf(total));
// }
// }
//
// } else {
// dataMap = pageManager.getPagePanelDataForAdd(panelName);
// json = CoderForSave.encode(pagePanelColumns, dataMap , false);
// }
//
// return json;
// }
//
// private String forSaveRequireConfigItem(HttpServletRequest request) {
// String json = "";
// String id = request.getParameter("id");
//
// String modelName = request.getParameter("modelname");
// String panelName = request.getParameter("panelname");
// PagePanel panel=pagePanelService.findPagePanel(panelName);
// List<PagePanelColumn> pagePanelColumns=pageManager.getUserPagePanelColumn(panelName);
//
// Map<String, Object> dataMap = null;
// if (StringUtils.isNotBlank(id)) {
// List<Map<String,Object>> listMap = configItemService.getRequireCIDataForEdit(modelName,
// panelName, id);
// if(listMap!=null&& !listMap.isEmpty()){
// if(panel.getXtype().getName().equals("form")){
// dataMap = listMap.iterator().next();
// json = CoderForSave.encode(pagePanelColumns, dataMap, true);
//
// }else if(panel.getXtype().getName().equals("editorgrid")){
// int total = listMap.size();
// json = CoderForList.encode(pagePanelColumns, listMap, Long.valueOf(total));
// }
// }
//
// } else {
// dataMap = pageManager.getPagePanelDataForAdd(panelName);
// json = CoderForSave.encode(pagePanelColumns, dataMap , false);
// }
//
// return json;
// }
/**
* 使用EXTJS组件绘制查询面板时需要使用的元数据和关联数据 @Methods Name forQuery @Create In Aug 30, 2008 By yang
*
* @param request
* @return @ReturnType String
*/
@SuppressWarnings("unchecked")
private String forQuery(HttpServletRequest request) {
String json = "";
// String id = request.getParameter("id");
String panelName = request.getParameter("panelname");
PagePanel panel = pagePanelService.findPagePanel(panelName);
SystemMainTable smt = panel.getSystemMainTable();
String className = smt.getClassName();
Class clazz = this.getClass(className);
List<UserTableQueryColumn> userQueryColumns = metaDataManager.getUserColumnForQuery(clazz);
Map queryMap = this.pageManager.getPagePanelDataForQuery(panelName);
json = CoderForFind.encode(queryMap, userQueryColumns);
return json;
}
/**
* 使用Html绘制查询面板时需要使用的元数据和关联数据 @Methods Name forHtmlQuery @Create In 2009-1-2 By sa
*
* @param request
* @return String
*/
@SuppressWarnings("unchecked")
private String forHtmlQuery(HttpServletRequest request) {
String json = "";
String className = request.getParameter("clazz");
Class clazz = getClass(className);
List<UserTableQueryColumn> userQueryColumns = metaDataManager.getUserColumnForQuery(clazz);
Map queryMap = metaDataManager.getEntityDataForAdd(clazz);
json = ExtHtmlBuilder.genQueryHtml(queryMap, userQueryColumns);
return json;
}
/**
* GridPanel表头使用的元数据, 不需要数据 @Methods Name forHead @Create In 2009-1-2 By sa
*
* @param request
* @return @ReturnType String
*/
private String forListHead(HttpServletRequest request) {
String json = "";
String panelName = request.getParameter("panelname");
// PagePanel panel=pagePanelService.findPagePanel(panelName);
List<PagePanelColumn> pagePanelColumns = pageManager.getUserPagePanelColumn(panelName);
json = CoderForHead.encode(pagePanelColumns);
return json;
}
/**
* EditorGridPanel表头，需要关联数据，如下拉列表或是否列表 @Methods Name forHead @Create In 2009-1-2 By sa
*
* @param request
* @return String
*/
private String forHead(HttpServletRequest request) {
String json = "";
String panelName = request.getParameter("panelname");
// PagePanel panel=pagePanelService.findPagePanel(panelName);
List<PagePanelColumn> pagePanelColumns = pageManager.getUserPagePanelColumn(panelName);
Map<String, Object> dataMap = null;
dataMap = pageManager.getPagePanelDataForAdd(panelName); // editorGrid使用forAdd是否合适
json = CoderForHead.encode(pagePanelColumns, dataMap);
return json;
}
private Class getClass(String className) {
Class clazz = null;
try {
clazz = Class.forName(className);
} catch (ClassNotFoundException e) {
System.out.print("类名：" + className + "不正确！");
e.printStackTrace();
}
return clazz;
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
// /**
// * 增加使用的元数据
// *
// * @Methods Name forAdd
// * @Create In Aug 30, 2008 By yang
// * @param request
// * @return
// * @ReturnType String
// */
// @SuppressWarnings("unchecked")
// private String forAdd(HttpServletRequest request) {
// String json = "";
// String pClazz = request.getParameter("clazz");
// Class<Object> clazz = getClass(pClazz);
// List<UserTableSetting> columns = metaDataManager
// .getUserColumnForEdit(clazz);
// Map<String, Object> addMap = metaDataManager.getEntityDataForAdd(clazz);
// json = CoderForAdd.encode(addMap, columns);
// return json;
// }
//
// /**
// * 修改使用的元数据
// *
// * @Methods Name forEdit
// * @Create In Aug 30, 2008 By yang
// * @param request
// * @return
// * @ReturnType String
// */
// private String forEdit(HttpServletRequest request) {
// String json = "";
// String id = request.getParameter("id");
// String className = request.getParameter("clazz");
// Class clazz = getClass(className);
// List<UserTableSetting> columns = metaDataManager
// .getUserColumnForEdit(clazz);
// if (StringUtils.isNotBlank(id)) {
// Object detail = (Object) service.find(clazz, id, true);
// Map<String, Object> editMap = metaDataManager.getEntityDataForEdit(
// clazz, id);
// json = CoderForEdit.encode(editMap, columns);
// } else {
// json = "no id is specified.";
// }
//
// return json;
// }
//
// if (StringUtils.isNotBlank(id)) {
// dataMap = pageManager.getPagePanelDataForEdit(panelName, id);
// json = CoderForHead.encode(pagePanelColumns, dataMap, true);
// } else {
// dataMap = pageManager.getPagePanelDataForAdd(panelName);
// json = CoderForHead.encode(pagePanelColumns, dataMap , false);
// }
}