crmSellChanceAction.jsp
4.71 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
<%@page import="weaver.conn.RecordSet"%>
<%@ page import="weaver.hrm.HrmUserVarify"%>
<%@page import="weaver.hrm.User"%>
<%@page import="java.io.IOException"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@page import="weaver.general.*"%>
<%@page import="net.sf.json.JSONObject"%>
<%--新建商机提醒上级--%>
<%@page import="java.sql.Timestamp" %>
<%@page import="java.util.*" %>
<%@page import="weaver.systeminfo.SystemEnv"%>
<jsp:useBean id="ResourceComInfo" class="weaver.hrm.resource.ResourceComInfo" scope="page" />
<jsp:useBean id="SysRemindWorkflow" class="weaver.system.SysRemindWorkflow" scope="page" />
<%
User user = HrmUserVarify.checkUser(request, response);
if(user == null){
out.println("无用户，请登录");
return;
}
int language = user.getLanguage();
String userid = String.valueOf(user.getUID());
String action = Util.null2String(request.getParameter("action"));
if("saveSellChance".equals(action)){
JSONObject resultObj = new JSONObject();
try {
RecordSet rs = new RecordSet();
String subject = Util.null2String(request.getParameter("subject"));//商机名称
String selltypesid = Util.null2String(request.getParameter("selltypesid")); //商机类型
String customerid = Util.null2String(request.getParameter("customerid"));//客户id
String predate = Util.null2String(request.getParameter("predate"));//销售预期
String preyield = Util.null2String(request.getParameter("preyield"));//预期收益
String sellstatusid = Util.null2String(request.getParameter("sellstatusid"));//商机状态
String probability = Util.null2String(request.getParameter("probability"));//可能性
//String comefromid = Util.null2String(request.getParameter("comefromid"));//商机来源
String sufactor = Util.null2String(request.getParameter("sufactor"));//成功因素
if(!"".equals(customerid)){
String fields = "subject,selltypesid,customerid,creater,endtatusid";//comefromid,
String values = "'"+subject+"','"+selltypesid+"','"+customerid+"',"+userid+",0";//'"+comefromid+"',
if(!"".equals(predate)){
fields+=",predate";
values+=",'"+predate+"'";
}
if(!"".equals(preyield)){
fields+=",preyield";
values+=","+preyield;
}
if(!"".equals(sellstatusid)){
fields+=",sellstatusid";
values+=","+sellstatusid;
}
if(!"".equals(probability)){
fields+=",probability";
values+=","+probability;
}
if(!"".equals(sufactor)){
fields+=",sufactor";
values+=","+sufactor;
}
String sql = "insert into CRM_SellChance ("+fields+") values("+values+")";
rs.executeSql(sql);
resultObj.put("status", "1");
rs.executeProc("CRM_SellChance_SMAXID","");
rs.next();
String sellchanceid = rs.getString("sellchanceid");
//新建商机提醒
rs.executeSql("select * from crm_customerSettings where id=-1");
rs.first();
String Sell_addRemind = Util.null2String(rs.getString("sell_rmd_create"));//是否开启创建商机提醒。
String Sell_addRemindTo = Util.null2String(rs.getString("sell_rmd_create2"));//是否开启创建商机提醒。
String CurrentUser = ""+user.getUID();
String CurrentUserName = ""+user.getUsername();
Date newdate = new Date();
long datetime = newdate.getTime();
Timestamp timestamp = new Timestamp(datetime);
String CurrentDate = (timestamp.toString()).substring(0, 4) + "-" + (timestamp.toString()).substring(5, 7) + "-" + (timestamp.toString()).substring(8, 10);
if("Y".equals(Sell_addRemind)){
//通知客户提醒对象
String operators = ResourceComInfo.getManagerID(CurrentUser);//默认提醒直接上级
if("2".equals(Sell_addRemindTo)) {
operators = ResourceComInfo.getManagersIDs(CurrentUser);//所有上级
}
/*添加客户销售机会触发工作流*/
String Subject=SystemEnv.getHtmlLabelName(15249,user.getLanguage());
Subject+=":"+subject;
String SWFAccepter=operators;
String SWFTitle=SystemEnv.getHtmlLabelName(15249,user.getLanguage());
SWFTitle += ":"+subject;
SWFTitle += "-"+CurrentUserName;
SWFTitle += "-"+CurrentDate;
String SWFRemark="<a href=/CRM/sellchance/ViewSellChance.jsp?id="+sellchanceid+"&CustomerID="+customerid+">"+Util.fromScreen2(Subject,user.getLanguage())+"</a>";
String SWFSubmiter=CurrentUser;
SysRemindWorkflow.setCRMSysRemind(SWFTitle,Util.getIntValue(customerid),Util.getIntValue(SWFSubmiter),SWFAccepter,SWFRemark);
}
}else{
resultObj.put("status", "0");
resultObj.put("errMsg", SystemEnv.getHtmlLabelName(502001,language)+"！");
}
}catch(Exception ex) {
ex.printStackTrace();
resultObj.put("status", "0");
resultObj.put("errMsg", ex.getMessage());
}finally{
try{
out.print(resultObj.toString());
out.flush();
}catch(IOException ex){
ex.printStackTrace();
}
}
}
%>