<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@page import="net.sf.json.JSONArray"%>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.*" %>
<%@page import="weaver.hrm.User"%>
<%@page import="weaver.hrm.HrmUserVarify"%>
<%@page import="weaver.formmode.service.RemindJobService"%>
<%@page import="net.sf.json.JSONObject"%>
<%@page import="weaver.formmode.task.TaskService"%>
<%@page import="weaver.systeminfo.systemright.CheckSubCompanyRight"%>
<%@page import="weaver.formmode.virtualform.VirtualFormHandler"%>
<%@ page import="weaver.systeminfo.SystemEnv"%>
<%@ page import="org.jdom.Document"%>
<%@ page import="weaver.servicefiles.ResetXMLFileCache"%>
<%@page import="com.weaver.formmodel.util.StringHelper"%>
<%@page import="com.weaver.formmodel.util.DateHelper"%>

<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="ScheduleXML" class="weaver.servicefiles.ScheduleXML" scope="page" />
<%
out.clear();
User user = HrmUserVarify.getUser (request , response) ;
if(!HrmUserVarify.checkUserRight("FORMMODEAPP:All", user)){
	response.sendRedirect("/notice/noright.jsp");
	return;
}
String operation = Util.null2String(request.getParameter("operation"));

RemindJobService remindJobService = new RemindJobService();
TaskService taskService = new TaskService();
if(operation.equals("saveorupdate")) {
	String conditionssql = Util.null2String(request.getParameter("conditionssql"));
	request.setAttribute("conditionssql",conditionssql);
	String id = remindJobService.saveOrUpdate(request,user);
	request.setAttribute("id",id);
	taskService.doAction(request);
	response.getWriter().println("<script type=\"text/javascript\">parent.parent.refreshRemindJob("+id+");</script>");
} else if(operation.equals("delete")) {
  	int id = Util.getIntValue(request.getParameter("id"));
  	taskService.doAction(request);
  	remindJobService.delete(id);
  	String appid = request.getParameter("appid");
	List<Map<String,Object>> dataList = remindJobService.getRemindJobByModeIds(Util.getIntValue(appid));
	
	String firstId = "";
	if (dataList != null && dataList.size() > 0) 
		firstId = Util.null2String(((Map<String,Object>)dataList.get(0)).get("id"));
	response.getWriter().println("<script type=\"text/javascript\">parent.parent.refreshRemindJob("+firstId+");</script>");
}else if(operation.equals("getRemindJobByModeIdWithJSON")){
	int appId = Util.getIntValue(request.getParameter("appid"));
	int fmdetachable = Util.getIntValue(request.getParameter("fmdetachable"));
	int subCompanyId = Util.getIntValue(request.getParameter("subCompanyId"));
	JSONArray remindJobArr = new JSONArray();
	if(fmdetachable==1){
		remindJobArr = remindJobService.getRemindJobByModeIdWithJSONDetach(appId,user.getLanguage(),subCompanyId);
	}else{
		remindJobArr = remindJobService.getRemindJobByModeIdWithJSON(appId,user.getLanguage());
	}
	out.print(remindJobArr.toString());
	out.flush();
	out.close();
	return;
}else if(operation.equals("getModesByFormId")){
	String fmdetachable = Util.null2String(request.getParameter("fmdetachable"));
	String subCompanyId = Util.null2String(request.getParameter("subCompanyId"));
	String formid = Util.null2String(request.getParameter("formid"));
	String remindtype = Util.null2String(request.getParameter("remindtype"));
	String formtype = Util.null2String(request.getParameter("formtype"));
	String sql = "select id,modename from modeinfo where isdelete=0 and formid="+StringHelper.empty2Null(formid);
	if(fmdetachable.equals("1")){
      	CheckSubCompanyRight mSubRight = new CheckSubCompanyRight();
		int[] mSubCom = mSubRight.getSubComByUserRightId(user.getUID(),"ModeSetting:All",0);
		String subCompanyIds = "";
		for(int i=0;i<mSubCom.length;i++){
			if(i==0){
				subCompanyIds += ""+mSubCom[i];
			}else{
				subCompanyIds += ","+mSubCom[i];
			}
		}
		if(subCompanyIds.equals("")){
			sql+= " and 1=2 ";
		}else{
			sql+= " and subCompanyId in ("+subCompanyIds+") ";
		}
  }
	rs.executeSql(sql);
	String datype = rs.getDBType();
	JSONObject resultObject = new JSONObject();
	JSONArray jsonArray = new JSONArray();
	while(rs.next()){
		JSONObject jsonObject = new JSONObject();
		String id = rs.getString("id");
		String modename = rs.getString("modename");
		jsonObject.put("value",id);
		jsonObject.put("text",modename);
		jsonArray.add(jsonObject);
	}	
	if(datype.equals("sqlserver")){
		sql = "select a.fieldname,a.detailtable,a.fieldlabel from workflow_billfield a where  a.billid="+StringHelper.empty2Null( formid)+" and  a.fieldhtmltype not in (6,7) order by detailtable ";
	}else{
		sql = "select a.fieldname,a.detailtable,a.fieldlabel from workflow_billfield a where  a.billid="+StringHelper.empty2Null( formid)+" and  a.fieldhtmltype not in (6,7) order by detailtable desc";
	}
	
	rs.executeSql(sql);
	JSONArray fieldArray = new JSONArray();
	while(rs.next()){
		JSONObject jsonObject = new JSONObject();
		String id = rs.getString("id");
		String fieldname = rs.getString("fieldname");
		String detailtable = rs.getString("detailtable");
		int fieldlabel = Util.getIntValue(rs.getString("fieldlabel"), 0);
	    String indexdesc = SystemEnv.getHtmlLabelName(fieldlabel,user.getLanguage());
		if(detailtable != null && !detailtable.equals("")){
			String tempdetailtable = detailtable.substring(detailtable.length()-1,detailtable.length());
			if(!formtype.equals(tempdetailtable)){
				continue;
			}
			indexdesc += "("+SystemEnv.getHtmlLabelName(17463,user.getLanguage())+tempdetailtable+")";
			fieldname = detailtable+"."+fieldname;
		}
		jsonObject.put("value",fieldname);
		jsonObject.put("text",indexdesc);
		fieldArray.add(jsonObject);
	}
	resultObject.put("modedata",jsonArray);
	resultObject.put("fielddata",fieldArray);
	out.print(resultObject.toString());
	out.flush();
	out.close();
	return;
}else if(operation.equals("getModesByFormIdAndField")){
	String fmdetachable = Util.null2String(request.getParameter("fmdetachable"));
	String subCompanyId = Util.null2String(request.getParameter("subCompanyId"));
	String formid = Util.null2String(request.getParameter("formid"));
	String remindtype = Util.null2String(request.getParameter("remindtype"));
	String formtype = Util.null2String(request.getParameter("formtype"));
	String sql = "select id,modename from modeinfo where isdelete=0 and formid="+formid;
	if(fmdetachable.equals("1")){
      	CheckSubCompanyRight mSubRight = new CheckSubCompanyRight();
		int[] mSubCom = mSubRight.getSubComByUserRightId(user.getUID(),"ModeSetting:All",0);
		String subCompanyIds = "";
		for(int i=0;i<mSubCom.length;i++){
			if(i==0){
				subCompanyIds += ""+mSubCom[i];
			}else{
				subCompanyIds += ","+mSubCom[i];
			}
		}
		if(subCompanyIds.equals("")){
			sql+= " and 1=2 ";
		}else{
			sql+= " and subCompanyId in ("+subCompanyIds+") ";
		}
  }
	rs.executeSql(sql);
	String datype = rs.getDBType();
	JSONObject resultObject = new JSONObject();
	JSONArray jsonArray = new JSONArray();
	while(rs.next()){
		JSONObject jsonObject = new JSONObject();
		String id = rs.getString("id");
		String modename = rs.getString("modename");
		jsonObject.put("value",id);
		jsonObject.put("text",modename);
		jsonArray.add(jsonObject);
	}	
	if(datype.equals("sqlserver")){
		sql = "select a.fieldname,a.detailtable,a.fieldlabel from workflow_billfield a where  a.billid="+StringHelper.empty2Null(formid)+" and  a.fieldhtmltype not in (6,7) order by detailtable ";
	}else{
		sql = "select a.fieldname,a.detailtable,a.fieldlabel from workflow_billfield a where  a.billid="+StringHelper.empty2Null(formid)+" and  a.fieldhtmltype not in (6,7) order by detailtable desc";
	}
	
	rs.executeSql(sql);
	JSONArray fieldArray = new JSONArray();
	while(rs.next()){
		JSONObject jsonObject = new JSONObject();
		String id = rs.getString("id");
		String fieldname = rs.getString("fieldname");
		String detailtable = rs.getString("detailtable");
		int fieldlabel = Util.getIntValue(rs.getString("fieldlabel"), 0);
	    String indexdesc = SystemEnv.getHtmlLabelName(fieldlabel,user.getLanguage());
		if(detailtable != null && !detailtable.equals("")){
			String tempdetailtable = detailtable.substring(detailtable.length()-1,detailtable.length());
			if(!formtype.equals(tempdetailtable)){
				continue;
			}
			indexdesc += "("+SystemEnv.getHtmlLabelName(17463,user.getLanguage())+tempdetailtable+")";
			fieldname = detailtable+"."+fieldname;
		}
		jsonObject.put("value",fieldname);
		jsonObject.put("text",indexdesc);
		fieldArray.add(jsonObject);
	}
	
	//---2----
	sql = "select a.id,a.fieldname,a.detailtable,a.fieldlabel from workflow_billfield a where a.billid="+StringHelper.empty2Null(formid)+" and a.fieldhtmltype=3 and a.type=1 order by a.id asc,detailtable asc";
	rs.executeSql(sql);
	JSONArray mainHrmArray = new JSONArray();
	JSONArray allHrmArray = new JSONArray();
	while(rs.next()){
		JSONObject jsonObject = new JSONObject();
		String id = rs.getString("id");
		String fieldname = rs.getString("fieldname");
		String detailtable = rs.getString("detailtable");
		int fieldlabel = Util.getIntValue(rs.getString("fieldlabel"), 0);
	    String labelname = SystemEnv.getHtmlLabelName(fieldlabel,user.getLanguage());
		if(StringHelper.isEmpty(detailtable)){
			jsonObject.put("id",id);
			jsonObject.put("fieldname",fieldname);
			jsonObject.put("labelname",labelname);
			mainHrmArray.add(jsonObject);
		}else{
			if(detailtable.substring(detailtable.length()-1,detailtable.length()).equals(formtype)){
				labelname += "(" + SystemEnv.getHtmlLabelName(126218, user.getLanguage()) +formtype+")";
			}else{
				continue;
			}
		}
		jsonObject.put("value",id);
		jsonObject.put("text",labelname);
		allHrmArray.add(jsonObject);
	}
	
	//---3----
	sql = "select detailtable from workflow_billfield where billid = "+StringHelper.empty2Null(formid)+" group by detailtable";
	rs.executeSql(sql);
	JSONArray detailtableArray = new JSONArray();
	while(rs.next()){
		JSONObject jsonObject = new JSONObject();
		String detailtable = rs.getString("detailtable");
		jsonObject.put("detailtablename",detailtable);
		if(detailtable.length() > 0){
			jsonObject.put("detailtable",detailtable.substring(detailtable.length()-1,detailtable.length()));
		}else{
			jsonObject.put("detailtable",detailtable);
		}
		detailtableArray.add(jsonObject);
	}
	
	resultObject.put("modedata",jsonArray);
	resultObject.put("fielddata",fieldArray);
	resultObject.put("mainHrmdata",mainHrmArray);
	resultObject.put("allHrmata",allHrmArray);
	resultObject.put("detailtabledata",detailtableArray);
	
	out.print(resultObject.toString());
	out.flush();
	out.close();
	return;
}else if(operation.equals("getHrmFieldByFormId")){
	String formid = Util.null2String(request.getParameter("formid"));
	String sql = "select a.id,a.fieldname,b.labelname from workflow_billfield a,HtmlLabelInfo b where a.billid="+StringHelper.empty2Null(formid)+" and a.fieldlabel=b.indexid and b.languageid=7 and a.fieldhtmltype=3 and a.type=1 and a.detailtable='' order by a.id";
	rs.executeSql(sql);
	JSONArray jsonArray = new JSONArray();
	while(rs.next()){
		JSONObject jsonObject = new JSONObject();
		String id = rs.getString("id");
		String fieldname = rs.getString("fieldname");
		String labelname = rs.getString("labelname");
		jsonObject.put("id",id);
		jsonObject.put("fieldname",fieldname);
		jsonObject.put("labelname",labelname);
		jsonArray.add(jsonObject);
	}
	out.print(jsonArray.toString());
	out.flush();
	out.close();
	return;
}else if(operation.equals("initRemindData")){
	int id = Util.getIntValue(request.getParameter("id"));
	out.print(SystemEnv.getHtmlLabelName(82254,user.getLanguage()));//后台正在重构数据......
	out.flush();
	out.close();
	return;
}else if(operation.equals("changeFormType")){
	String formid = Util.null2String(request.getParameter("formid"));
	String sql = "select detailtable from workflow_billfield where billid = "+StringHelper.empty2Null(formid)+" group by detailtable";
	rs.executeSql(sql);
	JSONArray jsonArray = new JSONArray();
	while(rs.next()){
		JSONObject jsonObject = new JSONObject();
		String detailtable = rs.getString("detailtable");
		jsonObject.put("detailtablename",detailtable);
		if(detailtable.length() > 0){
			jsonObject.put("detailtable",detailtable.substring(detailtable.lastIndexOf("dt")+2,detailtable.length()));
		}else{
			jsonObject.put("detailtable",detailtable);
		}
		jsonArray.add(jsonObject);
	}
	out.print(jsonArray.toString());
	out.flush();
	out.close();
	return;
}else if(operation.equals("getHrmField")){
    String formid = Util.null2String(request.getParameter("formid"));
	String formtype = Util.null2String(request.getParameter("formtype"));
	String sql = "select a.id,a.fieldname,b.labelname,a.detailtable from workflow_billfield a,HtmlLabelInfo b where a.billid="+StringHelper.empty2Null(formid)+" and a.fieldlabel=b.indexid and b.languageid=7 and a.fieldhtmltype=3 and a.type=1 order by a.id asc,detailtable asc";
	rs.executeSql(sql);
	JSONArray fieldArray = new JSONArray();
	while(rs.next()){
		JSONObject jsonObject = new JSONObject();
		String fieldid = rs.getString("id");
		String labelname = rs.getString("labelname");
		String detailtable = rs.getString("detailtable");
		if(detailtable != null && !detailtable.equals("")){
			if(detailtable.substring(detailtable.length()-1,detailtable.length()).equals(formtype)){
				labelname += "(" + SystemEnv.getHtmlLabelName(126218, user.getLanguage()) +formtype+")";
			}else{
				continue;
			}
		}
		jsonObject.put("value",fieldid);
		jsonObject.put("text",labelname);
		fieldArray.add(jsonObject);
	}
	out.print(fieldArray.toString());
	out.flush();
	out.close();
	return;
}else if(operation.equals("getSqlText")){
	int id = Util.getIntValue(request.getParameter("id"), 0);
	int type = Util.getIntValue(request.getParameter("type"), 0);
	String formid = Util.null2String(request.getParameter("formid"), "0");
	Map map = remindJobService.getRemindJobById(id);
	String fieldname = "";
	if(type==1){//短信
		fieldname = "isRemindSMS";
	}else if(type==2){
		fieldname = "isRemindEmail";
	}else if(type==3){
		fieldname = "isRemindWorkflow";
	}else if(type==4){
		fieldname = "isRemindWeChat";
	}else if(type==5){
		fieldname = "isRemindEmobile";
	}
	String sql = taskService.getDqtxSqlwhere(map,fieldname);
	JSONObject jsonObject = new JSONObject();
	jsonObject.put("sql",sql);
	boolean isvirtualform = VirtualFormHandler.isVirtualForm(formid);
	String vdatasource="";
	boolean f=false;
	if(isvirtualform){
        Map<String, Object> vFormInfo = new HashMap<String, Object>();
        vFormInfo = VirtualFormHandler.getVFormInfo(formid);
        vdatasource = Util.null2String(vFormInfo.get("vdatasource")); // 虚拟表单数据源
        f = rs.executeSql(sql,vdatasource);
    }else{
        f = rs.executeSql(sql);
    }    
	String errorMsg = "";
	int count = 0;
	int count1 = 0;
	if(f){
		count = rs.getCounts();
		String sql1 = "select 1 from mode_reminddata_all where lastdate='"+DateHelper.getCurrentDate()+"' and remindjobid="+id+" and "+fieldname+"=1";
		rs.execute(sql1);
		count1 = rs.getCounts();
	}else{
		errorMsg = SystemEnv.getHtmlLabelName(129564,user.getLanguage());
	}
	jsonObject.put("count",count);
	jsonObject.put("count1",count1);
	jsonObject.put("errorMsg",errorMsg);
	out.print(jsonObject.toString());
	out.flush();
	out.close();
	return;
}
%>