meidu2021/daju/target/classes/cn/com/lzt/contractsale/controller/ContractSaleController.java

package cn.com.lzt.contractsale.controller;
import cn.com.lzt.common.controller.BaseLztController;
import cn.com.lzt.common.util.DictUtil;
import cn.com.lzt.common.util.LztUtil;
import cn.com.lzt.common.view.JsonDataModelAndView;
import cn.com.lzt.contractsale.entity.ContractSaleEntity;
import cn.com.lzt.contractsale.page.ContractSalePage;
import cn.com.lzt.contractsale.service.ContractSaleServiceI;
import cn.com.lzt.contractsaleitem.entity.ContractSaleItemEntity;
import cn.com.lzt.project.entity.ProjectEntity;
import cn.com.lzt.project.service.ProjectServiceI;
import cn.com.lzt.tools.DecimalUtils;
import cn.com.lzt.workflow.service.WorkflowServiceI;
import com.xcgl.utils.OrderNumTools;
import com.xcgl.utils.XcglDateUtils;
import com.xcgl.weixin.entity.WXAjaxJson;
import org.apache.commons.lang.xwork.StringUtils;
import org.apache.log4j.Logger;
import org.jeecgframework.core.beanvalidator.BeanValidators;
import org.jeecgframework.core.common.exception.BusinessException;
import org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery;
import org.jeecgframework.core.common.model.json.AjaxJson;
import org.jeecgframework.core.common.model.json.DataGrid;
import org.jeecgframework.core.constant.Globals;
import org.jeecgframework.core.util.*;
import org.jeecgframework.poi.excel.ExcelImportUtil;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.entity.ImportParams;
import org.jeecgframework.poi.excel.entity.vo.NormalExcelConstants;
import org.jeecgframework.tag.core.easyui.TagUtil;
import org.jeecgframework.tag.vo.datatable.SortDirection;
import org.jeecgframework.web.system.pojo.base.TSUser;
import org.jeecgframework.web.system.service.SystemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpStatus;
import org.springframework.http.MediaType;
import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.util.UriComponentsBuilder;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.validation.ConstraintViolation;
import javax.validation.Validator;
import java.io.IOException;
import java.net.URI;
import java.text.ParseException;
import java.util.*;

/**   
 * @Title: Controller
 * @Description: 销售合同
 * @author onlineGenerator
 * @date 2019-05-09 17:25:32
 * @version V1.0   
 *
 */
@Controller
@RequestMapping("/contractSaleController")
public class ContractSaleController extends BaseLztController {
	/**
	 * Logger for this class
	 */
	private static final Logger logger = Logger.getLogger(ContractSaleController.class);

	@Autowired
	private ContractSaleServiceI contractSaleService;
	@Autowired
	private SystemService systemService;
	@Autowired
	private Validator validator;
	@Autowired
	private WorkflowServiceI workflowService;
	
	@Autowired
	private ProjectServiceI projectServiceI;

	/**
	 * 销售合同列表 页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "list")
	public ModelAndView list(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/contractsale/contractSaleList");
	}

	/**
	 * easyui AJAX请求数据
	 * 
	 * @param request
	 * @param response
	 * @param dataGrid
	 * @param user
	 */

	@RequestMapping(params = "datagrid")
	public void datagrid(ContractSaleEntity contractSale,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		String containAdd = request.getParameter("containAdd");
		String zone = request.getParameter("zone")  ;
		CriteriaQuery cq = new CriteriaQuery(ContractSaleEntity.class, dataGrid);
		String contractCode = request.getParameter("code");  
		String contractName = request.getParameter("name"); 
		String contractDescription = request.getParameter("description"); 
		//清除项目名称，此名称设置为了简称
		contractSale.setProjectname(null);
		contractSale.setType(Globals.CONTRACT_TYPE_SALE);
		//查询条件组装器
		if(StringUtils.isNotBlank(contractCode)){
			//模糊查询
			cq.like("code", "%"+contractCode+"%");
			contractSale.setCode(null);
		}
		if(StringUtils.isNotBlank(contractName)){
			//模糊查询
			cq.like("name", "%"+contractName+"%");
			contractSale.setName(null);
		}
		if(StringUtils.isNotBlank(contractDescription)){
			//模糊查询
			cq.like("description", "%"+contractDescription+"%");
			contractSale.setDescription(null);
		}
		if(StringUtils.isNotEmpty(zone)) {
			List<String> projectid = systemService.findListbySql("select id from t_b_project where zone = '"+zone+"'");
			if(projectid.size() > 0) {
				cq.in("projectid", projectid.toArray());
			}else {
				cq.eq("projectid", "##");
			}
		}
		String endDateMonth = request.getParameter("endDateMonth");

		if(StringUtils.isNotBlank(endDateMonth)){
			try {
				Date endMonth = DateUtils.parseDate(endDateMonth,"yyyy-MM");
				Calendar c = Calendar.getInstance();
				c.setTime(endMonth);
				c.set(Calendar.DAY_OF_MONTH,1);
				Date endDateBegin = c.getTime();
				c.add(Calendar.MONTH,1);
				c.add(Calendar.MILLISECOND,-1);
				Date endDateEnd = c.getTime();
				cq.ge("enddate",endDateBegin);
				cq.le("enddate",endDateEnd);
			} catch (ParseException e) {
				e.printStackTrace();
			}
		}
		//查询条件组装器
		org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, contractSale);
		try{
			String isproject = request.getParameter("isproject"); 
			if(StringUtils.isNotEmpty(isproject)) {
				//增加权限处理
				TSUser user = ResourceUtil.getSessionUser();
				// 所属项目及兼职项目id
				List<String> projectList = projectServiceI.getProjectsByUserid(user.getId());
				cq.in("projectid", projectList.toArray());
			}
		//自定义追加查询条件
		}catch (Exception e) {
			throw new BusinessException(e.getMessage());
		}
		cq.add();
		this.contractSaleService.getDataGridReturn(cq, true);
		if(StringUtils.isNotEmpty(containAdd) && containAdd.equals("1")) {
			String addAmountSql = "select contractid,sum(ifnull(addamount,0)) as addamount from t_b_contract_sale where type = '"+Globals.CONTRACT_TYPE_SALE_ADDING+"' group by contractid";
			List<Map<String,Object>> amountRes = systemService.findForJdbc(addAmountSql);
			HashMap<String,Double> addMap = new HashMap<String, Double>();
			for(Map<String,Object> value:amountRes) {
				if(value.get("contractid") != null)
					addMap.put(value.get("contractid").toString(),Double.valueOf(value.get("addamount").toString()));
			}
			List<ContractSaleEntity> result = dataGrid.getResults();
			for(ContractSaleEntity contract: result) {
				if(addMap.containsKey(contract.getId())) {
					contract.setTotaladd(addMap.get(contract.getId()));
				}else {
					contract.setTotaladd(DecimalUtils.ZERO);
				}
				contract.setTotaladdandamount(contract.getTotalamount()+contract.getTotaladd());
			}
		}
		dataGrid.setFooter("code:合计,totaladdandamount");
		TagUtil.datagrid(response, dataGrid);
	}

	/**
	 * 删除销售合同
	 * 
	 * @return
	 */
	@RequestMapping(params = "doDel")
	@ResponseBody
	public AjaxJson doDel(ContractSaleEntity contractSale, HttpServletRequest request) {
		AjaxJson j = new AjaxJson();
		contractSale = systemService.getEntity(ContractSaleEntity.class, contractSale.getId());
		String message = "销售合同删除成功";
		try{
			contractSaleService.delMain(contractSale);
			systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
		}catch(Exception e){
			e.printStackTrace();
			message = "销售合同删除失败";
			throw new BusinessException(e.getMessage());
		}
		j.setMsg(message);
		return j;
	}

	/**
	 * 批量删除销售合同
	 * 
	 * @return
	 */
	 @RequestMapping(params = "doBatchDel")
	@ResponseBody
	public AjaxJson doBatchDel(String ids,HttpServletRequest request){
		AjaxJson j = new AjaxJson();
		String message = "销售合同删除成功";
		try{
			for(String id:ids.split(",")){
				ContractSaleEntity contractSale = systemService.getEntity(ContractSaleEntity.class,
				id
				);
				contractSaleService.delMain(contractSale);
				systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
			}
		}catch(Exception e){
			e.printStackTrace();
			message = "销售合同删除失败";
			throw new BusinessException(e.getMessage());
		}
		j.setMsg(message);
		return j;
	}

	/**
	 * 添加销售合同
	 * 
	 * @param ids
	 * @return
	 */
	@RequestMapping(params = "doAdd")
	@ResponseBody
	public AjaxJson doAdd(ContractSaleEntity contractSale,ContractSalePage contractSalePage, HttpServletRequest request) {
		List<ContractSaleItemEntity> contractSaleItemList =  contractSalePage.getContractSaleItemList();
		AjaxJson j = new AjaxJson();
		contractSale.setName(contractSale.getName().trim());
		String message = "添加成功";
		try{
			//设置合同初始状态为已签订
			contractSale.setBusstatus(Globals.CONTRACT_STATUS_SIGN);
			//设置合同类型为外包合同
			if(StringUtils.isEmpty(contractSale.getType())) {
				contractSale.setType(Globals.CONTRACT_TYPE_SALE);
			}
			//清除合同名中的空格，可能是由于从其他文件复制文本导致
			contractSale.setName(contractSale.getName().trim());
			contractSale.setTotalincome(DecimalUtils.ZERO);
			contractSale.setTotalinvoice(DecimalUtils.ZERO);
			//如果合同编码为空，则按照编码规则设置默认编码（合同编码可编辑，用户签订合同时，合同上可能已经有编码）
			if(StringUtil.isEmpty(contractSale.getCode())) {
				contractSale.setCode(OrderNumTools.generateNextBillCode(Globals.CODE_PREFIX_CONTRACT_SALE,"t_b_contract_sale","code",4));
			}
			contractSaleService.addMain(contractSale, contractSaleItemList);
			systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO);
		}catch(Exception e){
			e.printStackTrace();
			message = "销售合同添加失败";
			throw new BusinessException(e.getMessage());
		}
		j.setMsg(message);
		return j;
	}
	/**
	 * 更新销售合同
	 * 
	 * @param ids
	 * @return
	 */
	@RequestMapping(params = "doUpdate")
	@ResponseBody
	public AjaxJson doUpdate(ContractSaleEntity contractSale,ContractSalePage contractSalePage, HttpServletRequest request) {
		//清除合同名中的空格，可能是由于从其他文件复制文本导致
		contractSale.setName(contractSale.getName().trim());
		List<ContractSaleItemEntity> contractSaleItemList =  contractSalePage.getContractSaleItemList();
		AjaxJson j = new AjaxJson();
		String message = "更新成功";
		try{
			contractSaleService.updateMain(contractSale, contractSaleItemList);
			systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
		}catch(Exception e){
			e.printStackTrace();
			message = "更新销售合同失败";
			throw new BusinessException(e.getMessage());
		}
		j.setMsg(message);
		return j;
	}

	/**
	 * 销售合同新增页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "goAdd")
	public ModelAndView goAdd(ContractSaleEntity contractSale, HttpServletRequest req) {
		if (StringUtil.isNotEmpty(contractSale.getId())) {
			contractSale = contractSaleService.getEntity(ContractSaleEntity.class, contractSale.getId());
			contractSale.setType(Globals.CONTRACT_TYPE_SALE);
		}else {
			contractSale.setPaytype("Quarterly");
			contractSale.setType(Globals.CONTRACT_TYPE_SALE);
			contractSale.setCanExe(Globals.YES);
		}
		req.setAttribute("contractSalePage", contractSale);
		return new ModelAndView("cn/com/lzt/contractsale/contractSale-add");
	}
	
	/**
	 * 销售合同编辑页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "goUpdate")
	public ModelAndView goUpdate(ContractSaleEntity contractSale, HttpServletRequest req) {
		if (StringUtil.isNotEmpty(contractSale.getId())) {
			contractSale = contractSaleService.getEntity(ContractSaleEntity.class, contractSale.getId());
			req.setAttribute("contractSalePage", contractSale);
		}
		return new ModelAndView("cn/com/lzt/contractsale/contractSale-update");
	}
	
	
	/**
	 * 加载明细列表[服务明细]
	 * 
	 * @return
	 */
	@RequestMapping(params = "contractSaleItemList")
	public ModelAndView contractSaleItemList(ContractSaleEntity contractSale, HttpServletRequest req) {
	
		//===================================================================================
		//获取参数
		String id0 = contractSale.getId();
		String oralContractId = req.getParameter("oralContractId");
		//===================================================================================
		try{
			String hql0 = "from ContractSaleItemEntity where 1 = 1 AND cONTRACTID =? ";
			//查询-服务明细
			if(StringUtils.isNotEmpty(id0)) {
		    	List<ContractSaleItemEntity> contractSaleItemEntityList = systemService.findHql(hql0,id0);
				req.setAttribute("contractSaleItemList", contractSaleItemEntityList);
			}else if(StringUtils.isNotEmpty(oralContractId)) {
				List<ContractSaleItemEntity> contractSaleItemEntityList = systemService.findHql(hql0,oralContractId);
				req.setAttribute("contractSaleItemList", contractSaleItemEntityList);
			}
		}catch(Exception e){
			logger.info(e.getMessage());
		}
		return new ModelAndView("cn/com/lzt/contractsaleitem/contractSaleItemList");
	}

    /**
    * 导出excel
    *
    * @param request
    * @param response
    */
    @RequestMapping(params = "exportXls")
    public String exportXls(ContractSaleEntity contractSale,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid,ModelMap map) {
    	CriteriaQuery cq = new CriteriaQuery(ContractSaleEntity.class, dataGrid);
		String contractCode = request.getParameter("code");  
		String contractName = request.getParameter("name"); 
		String contractDescription = request.getParameter("description"); 

		contractSale.setType(Globals.CONTRACT_TYPE_SALE);
		//查询条件组装器
		if(StringUtils.isNotBlank(contractCode)){
			//模糊查询
			cq.like("code", "%"+contractCode+"%");
			contractSale.setCode(null);
		}
		if(StringUtils.isNotBlank(contractName)){
			//模糊查询
			cq.like("name", "%"+contractName+"%");
			contractSale.setName(null);
		}
		if(StringUtils.isNotBlank(contractDescription)){
			//模糊查询
			cq.like("description", "%"+contractDescription+"%");
			contractSale.setDescription(null);
		}
		//查询条件组装器
		org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, contractSale);
		try{
			String isproject = request.getParameter("isproject"); 
			if(StringUtils.isNotEmpty(isproject)) {
				//增加权限处理
				TSUser user = ResourceUtil.getSessionUser();
				// 所属项目及兼职项目id
				List<String> projectList = projectServiceI.getProjectsByUserid(user.getId());
				cq.in("projectid", projectList.toArray());
			}
		//自定义追加查询条件
		}catch (Exception e) {
			throw new BusinessException(e.getMessage());
		}
		cq.addOrder("startdate", SortDirection.desc);
		cq.add();
    	List<ContractSaleEntity> list=this.contractSaleService.getListByCriteriaQuery(cq, false);
    	
    	// 增加：补充协议金额
    	String addAmountSql = "select contractid,sum(ifnull(addamount,0)) as addamount from t_b_contract_sale where type = '"+Globals.CONTRACT_TYPE_SALE_ADDING+"' group by contractid";
		List<Map<String,Object>> amountRes = systemService.findForJdbc(addAmountSql);
		HashMap<String,Double> addMap = new HashMap<String, Double>();
		for(Map<String,Object> value:amountRes) {
			if(value.get("contractid") != null)
				addMap.put(value.get("contractid").toString(),Double.valueOf(value.get("addamount").toString()));
		}
		for(ContractSaleEntity contract: list) {
			if(addMap.containsKey(contract.getId())) {
				contract.setTotaladd(addMap.get(contract.getId()));
			}else {
				contract.setTotaladd(DecimalUtils.ZERO);
			}
			contract.setTotaladdandamount(contract.getTotalamount()+contract.getTotaladd());
		}
		
        map.put(NormalExcelConstants.FILE_NAME,"销售合同"+DateUtils.yyyymmddhhmmss.format(new Date()));
        map.put(NormalExcelConstants.CLASS,ContractSaleEntity.class);
        map.put(NormalExcelConstants.PARAMS,new ExportParams("销售合同列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
            "导出信息"));
        map.put(NormalExcelConstants.DATA_LIST,list);
        return NormalExcelConstants.JEECG_EXCEL_VIEW;
	}

    /**
	 * 通过excel导入数据
	 * @param request
	 * @param
	 * @return
	 */
	@RequestMapping(params = "importExcel", method = RequestMethod.POST)
	@ResponseBody
	public AjaxJson importExcel(HttpServletRequest request, HttpServletResponse response) {
		AjaxJson j = new AjaxJson();
		MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
		Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
		for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
			MultipartFile file = entity.getValue();// 获取上传文件对象
			ImportParams params = new ImportParams();
			params.setTitleRows(2);
			params.setHeadRows(2);
			params.setNeedSave(true);
			try {
				List<ContractSalePage> list =  ExcelImportUtil.importExcel(file.getInputStream(), ContractSalePage.class, params);
				ContractSaleEntity entity1=null;
				for (ContractSalePage page : list) {
					entity1=new ContractSaleEntity();
					MyBeanUtils.copyBeanNotNull2Bean(page,entity1);
		            contractSaleService.addMain(entity1, page.getContractSaleItemList());
				}
				j.setMsg("文件导入成功！");
			} catch (Exception e) {
				j.setMsg("文件导入失败！");
				logger.error(ExceptionUtil.getExceptionMessage(e));
			}finally{
				try {
					file.getInputStream().close();
				} catch (IOException e) {
					e.printStackTrace();
				}
			}
			}
			return j;
	}
	/**
	* 导出excel 使模板
	*/
	@RequestMapping(params = "exportXlsByT")
	public String exportXlsByT(ModelMap map) {
		map.put(NormalExcelConstants.FILE_NAME,"销售合同");
		map.put(NormalExcelConstants.CLASS,ContractSalePage.class);
		map.put(NormalExcelConstants.PARAMS,new ExportParams("销售合同列表", "导出人:"+ ResourceUtil.getSessionUser().getRealName(),
		"导出信息"));
		map.put(NormalExcelConstants.DATA_LIST,new ArrayList());
		return NormalExcelConstants.JEECG_EXCEL_VIEW;
	}
	/**
	* 导入功能跳转
	*
	* @return
	*/
	@RequestMapping(params = "upload")
	public ModelAndView upload(HttpServletRequest req) {
		req.setAttribute("controller_name", "contractSaleController");
		return new ModelAndView("common/upload/pub_excel_upload");
	}

 	
 	@RequestMapping(method = RequestMethod.GET)
	@ResponseBody
	public List<ContractSaleEntity> list() {
		List<ContractSaleEntity> listContractSales=contractSaleService.getList(ContractSaleEntity.class);
		return listContractSales;
	}
	
	@RequestMapping(value = "/{id}", method = RequestMethod.GET)
	@ResponseBody
	public ResponseEntity<?> get(@PathVariable("id") String id) {
		ContractSaleEntity task = contractSaleService.get(ContractSaleEntity.class, id);
		if (task == null) {
			return new ResponseEntity(HttpStatus.NOT_FOUND);
		}
		return new ResponseEntity(task, HttpStatus.OK);
	}
 	
 	@RequestMapping(method = RequestMethod.POST, consumes = MediaType.APPLICATION_JSON_VALUE)
	@ResponseBody
	public ResponseEntity<?> create(@RequestBody ContractSalePage contractSalePage, UriComponentsBuilder uriBuilder) {
		//调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息.
		Set<ConstraintViolation<ContractSalePage>> failures = validator.validate(contractSalePage);
		if (!failures.isEmpty()) {
			return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
		}

		//保存
		List<ContractSaleItemEntity> contractSaleItemList =  contractSalePage.getContractSaleItemList();
		
		ContractSaleEntity contractSale = new ContractSaleEntity();
		try{
			MyBeanUtils.copyBeanNotNull2Bean(contractSale,contractSalePage);
		}catch(Exception e){
            logger.info(e.getMessage());
        }
		contractSaleService.addMain(contractSale, contractSaleItemList);

		//按照Restful风格约定，创建指向新任务的url, 也可以直接返回id或对象.
		String id = contractSalePage.getId();
		URI uri = uriBuilder.path("/rest/contractSaleController/" + id).build().toUri();
		HttpHeaders headers = new HttpHeaders();
		headers.setLocation(uri);

		return new ResponseEntity(headers, HttpStatus.CREATED);
	}
	
	@RequestMapping(value = "/{id}", method = RequestMethod.PUT, consumes = MediaType.APPLICATION_JSON_VALUE)
	public ResponseEntity<?> update(@RequestBody ContractSalePage contractSalePage) {
		//调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息.
		Set<ConstraintViolation<ContractSalePage>> failures = validator.validate(contractSalePage);
		if (!failures.isEmpty()) {
			return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
		}

		//保存
		List<ContractSaleItemEntity> contractSaleItemList =  contractSalePage.getContractSaleItemList();
		
		ContractSaleEntity contractSale = new ContractSaleEntity();
		try{
			MyBeanUtils.copyBeanNotNull2Bean(contractSale,contractSalePage);
		}catch(Exception e){
            logger.info(e.getMessage());
        }
		contractSaleService.updateMain(contractSale, contractSaleItemList);

		//按Restful约定，返回204状态码, 无内容. 也可以返回200状态码.
		return new ResponseEntity(HttpStatus.NO_CONTENT);
	}

	@RequestMapping(value = "/{id}", method = RequestMethod.DELETE)
	@ResponseStatus(HttpStatus.NO_CONTENT)
	public void delete(@PathVariable("id") String id) {
		ContractSaleEntity contractSale = contractSaleService.get(ContractSaleEntity.class, id);
		contractSaleService.delMain(contractSale);
	}
	@RequestMapping(params = "goView")
	public ModelAndView goView(ContractSaleEntity contract,  HttpServletRequest request) {
		String taskId = request.getParameter("taskId");
		//【我发起的流程】-【详情】中查看业务数据时，只看单据信息，不预览审批流程
		if(StringUtils.isEmpty(taskId)) {
			contract = contractSaleService.getEntity(ContractSaleEntity.class, contract.getId());
			request.setAttribute("contractSalePage", contract);
			request.setAttribute("viewFlag", "1");
			return new ModelAndView("cn/com/lzt/contractsale/contractSale-update");
		}
		 request.setAttribute("url", "contractSaleController.do?goUpdate&load=detail&id="+workflowService.getBpmDataId(taskId));
		 Map<String, Object> taskDetails = workflowService.getTaskDetails(taskId);
		 request.setAttribute("busititle", "销售合同详细信息");
		 request.setAttribute("id", workflowService.getBpmDataId(taskId));
		 request.setAttribute("bpmLogList", taskDetails.get("bpmLogList"));
		 request.setAttribute("taskId", taskDetails.get("taskId"));
		 request.setAttribute("taskName", taskDetails.get("taskName"));
		 request.setAttribute("task", taskDetails.get("task"));
		 request.setAttribute("transitionList", taskDetails.get("transitionList"));
	     request.setAttribute("nextCodeCount", taskDetails.get("nextCodeCount"));
		 request.setAttribute("bpmLogListCount", taskDetails.get("bpmLogListCount"));
		 request.setAttribute("bpmLogNewList", taskDetails.get("bpmLogNewList"));
		 request.setAttribute("bpmLogNewListCount", taskDetails.get("bpmLogNewListCount"));
		 request.setAttribute("histListNode", taskDetails.get("histListNode"));
		 request.setAttribute("histListSize", taskDetails.get("histListSize"));
		 request.setAttribute("turnbackTaskId", taskDetails.get("turnbackTaskId"));
		 request.setAttribute("height", "678px");
		 return new ModelAndView("cn/com/lzt/workflow/task-option");
	}
	
	@RequestMapping(params = "goUpdateMobile")
	public ModelAndView goUpdateMobile(ContractSaleEntity contract, HttpServletRequest req) {
		if (StringUtil.isNotEmpty(contract.getId())) {
			contract = contractSaleService.getEntity(ContractSaleEntity.class, contract.getId());
			ContractSaleEntity contractPage = new ContractSaleEntity();
			try {
				MyBeanUtils.copyBeanNotNull2Bean(contract, contractPage);
			}catch (Exception e) {
				logger.error(e.getMessage());
			}
			if(StringUtil.isNotEmpty(contractPage.getProjectid())) {
				contractPage.setProjectname(((ProjectEntity)systemService.getEntity(ProjectEntity.class, contractPage.getProjectid())).getAbbreviation());
			}
			//重新设置字典，前台得到名称
			contractPage.setPaytype(DictUtil.formatToTypeName(contractPage.getPaytype(),"paymode"));
			contractPage.setServicecontent(DictUtil.formatToTypeName(contractPage.getServicecontent(),"servicetype"));
			req.setAttribute("entity", contractPage);
		}
		Map<String, Object> data = LztUtil.copyReqAttributes(new String[]{
				"entity"});
		return new JsonDataModelAndView(WXAjaxJson.success(data));
	}
	/**
	 * 选择合同列表界面
	 * 应用场景：支付申请时，先选择合同
	 * */
	@RequestMapping(params = "selectlist")
	public ModelAndView selectlist(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/contractsale/selectContractList");
	}
	/**
	 * 选择合同列表加载数据
	 * 应用场景：支付申请时，先选择合同
	 * */
	@RequestMapping(params = "selRefDatagridByUser")
	public void selRefDatagridByUser(ContractSaleEntity contractSale,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		CriteriaQuery cq = new CriteriaQuery(ContractSaleEntity.class, dataGrid);
		TSUser user = ResourceUtil.getSessionUser();
		//@TODO 查询用户所属角色，财务、行政角色可以查询所有合同 
		//@TODO 先查询出所有此用户所属项目，包括所属项目和兼职项目
		String roleSql = "select rolecode from t_s_role where id in (select roleid from t_s_role_user where userid = ?)";
		List<Map<String, Object>> roleMapList = systemService.findForJdbc(roleSql, user.getId());
		String roles = "";
		if(roleMapList != null && roleMapList.size()>0) {
			for (Map<String, Object> roleMap :roleMapList) {
				roles += (roleMap.get("rolecode").toString()+",");
			}
		}
		if(roles.indexOf("admin") == -1 
				&& (roles.indexOf("P_XMNQ,") > -1 //项目内勤
						|| roles.indexOf("P_XMJL,") > -1)/*项目经理*/) {
			// 所属项目及兼职项目id
			List<String> projectList = projectServiceI.getProjectsByUserid(user.getId());
			cq.in("projectid", projectList.toArray());
		}
		
		
		String contractCode = request.getParameter("code");  
		String contractName = request.getParameter("name"); 
		String contractDescription = request.getParameter("description"); 
		String projectname = request.getParameter("projectname");  
		String customername = request.getParameter("customername"); 

		contractSale.setType(Globals.CONTRACT_TYPE_SALE);
		//查询条件组装器
		if(StringUtils.isNotBlank(contractCode)){
			//模糊查询
			cq.like("code", "%"+contractCode+"%");
			contractSale.setCode(null);
		}
		if(StringUtils.isNotBlank(contractName)){
			//模糊查询
			cq.like("name", "%"+contractName+"%");
			contractSale.setName(null);
		}
		if(StringUtils.isNotBlank(contractDescription)){
			//模糊查询
			cq.like("description", "%"+contractDescription+"%");
			contractSale.setDescription(null);
		}
		if(StringUtils.isNotBlank(projectname)){
			//模糊查询
			cq.like("projectname", "%"+projectname+"%");
			contractSale.setProjectname(null);
		}
		if(StringUtils.isNotBlank(customername)){
			//模糊查询
			cq.like("customername", "%"+customername+"%");
			contractSale.setCustomername(null);
		}
		contractSale.setBpmStatus(Globals.BPM_STATUS_FINISHED.toString());
		//contractSale.setBusstatus(Globals.CONTRACT_STATUS_ACTIVE);
		contractSale.setType(Globals.CONTRACT_TYPE_SALE);
		contractSale.setCanExe(Globals.YES);
		
		cq.add();
		//查询条件组装器
		org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, contractSale);
		try{
		//自定义追加查询条件
		}catch (Exception e) {
			throw new BusinessException(e.getMessage());
		}
		this.contractSaleService.getDataGridReturn(cq, true);
		TagUtil.datagrid(response, dataGrid);
		
//		
//		String contractCode = request.getParameter("code");  
//		String contractName = request.getParameter("name"); 
//		String contractDescription = request.getParameter("description"); 
//		String contractProject = request.getParameter("projectid");  
//		String contractCustomer = request.getParameter("customerid");  
//		String contractStartDate_begin = request.getParameter("startdate_begin");  
//		String contractStartDate_end = request.getParameter("startdate_end");  
//		StringBuffer sbCondition = new StringBuffer();
//		//默认查询条件
//		sbCondition.append("  bpmStatus = '")
//		.append(Globals.BPM_STATUS_FINISHED)
//		.append("' and busstatus = '")
//		.append(Globals.CONTRCAT_STATUS_ACTIVE)
//		.append("' ")
//		.append(" and type = '")
//		.append(Globals.CONTRCAT_TYPE_SALE)
//		.append("' ");;
//		
//		//查询条件组装器
//		//模糊查询
//		if(StringUtils.isNotBlank(contractCode)){
//			sbCondition.append(" and code like '").append(contractCode).append("'");
//		}
//		if(StringUtils.isNotBlank(contractName)){
//			sbCondition.append(" and name like '").append(contractName).append("'");
//		}
//		if(StringUtils.isNotBlank(contractDescription)){
//			sbCondition.append(" and description like '").append(contractDescription).append("'");
//		}
//		String hql0 = "from ContractSaleEntity where  "+sbCondition.toString() +" order by startdate desc";
//		List<ContractSaleEntity> contractList = systemService.findHql(hql0);
//		dataGrid.setResults(contractList);
//		TagUtil.datagrid(response, dataGrid);
	}
	/**
	 * 销售合同列表 ：运营部使用
	 * 
	 * @return
	 */
	@RequestMapping(params = "list4Shangwu")
	public ModelAndView list4Yunying(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/contractsale/contractSaleList4Shangwu");
	}
	/**
	 * 销售合同列表 ：运营部使用
	 * 
	 * @return
	 */
	@RequestMapping(params = "list4Jishu")
	public ModelAndView list4Project(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/contractsale/contractSaleList4Jishu");
	}
	/**
	 * 销售合同列表 页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "listmodify")
	public ModelAndView listmodify(HttpServletRequest request) {
		String readOnly = "false";
		if(StringUtils.isNotEmpty(request.getParameter("readOnly"))); 
			readOnly = request.getParameter("readOnly");
		request.setAttribute("readOnly", readOnly);
		request.setAttribute("contractid", request.getParameter("contractid"));
		return new ModelAndView("cn/com/lzt/contractsale/contractSaleModifyList");
	}

	/**
	 * easyui AJAX请求数据
	 * 
	 * @param request
	 * @param response
	 * @param dataGrid
	 * @param user
	 */

	@RequestMapping(params = "datagridModify")
	public void datagridModify(ContractSaleEntity contractSale,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		CriteriaQuery cq = new CriteriaQuery(ContractSaleEntity.class, dataGrid);
		String contractCode = request.getParameter("code");  
		String contractName = request.getParameter("name"); 
		String contractDescription = request.getParameter("description"); 
		contractSale.setType(Globals.CONTRACT_TYPE_SALE_ADDING);
		//查询条件组装器
		if(StringUtils.isNotBlank(contractCode)){
			//模糊查询
			cq.like("code", "%"+contractCode+"%");
			contractSale.setCode(null);
		}
		if(StringUtils.isNotBlank(contractName)){
			//模糊查询
			cq.like("name", "%"+contractName+"%");
			contractSale.setName(null);
		}
		if(StringUtils.isNotBlank(contractDescription)){
			//模糊查询
			cq.like("description", "%"+contractDescription+"%");
			contractSale.setDescription(null);
		}
		//查询条件组装器
		org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, contractSale);
		try{
		//自定义追加查询条件
		}catch (Exception e) {
			throw new BusinessException(e.getMessage());
		}
		cq.add();
		this.contractSaleService.getDataGridReturn(cq, true);
		TagUtil.datagrid(response, dataGrid);
	}
	/**
	 * 销售合同新增页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "goModifyAdd")
	public ModelAndView goAddModify(ContractSaleEntity contractSale, HttpServletRequest req) {
		if (StringUtil.isNotEmpty(contractSale.getId())) {
			contractSale = contractSaleService.getEntity(ContractSaleEntity.class, contractSale.getId());
			contractSale.setType(Globals.CONTRACT_TYPE_SALE_ADDING);
			req.setAttribute("contractSalePage", contractSale);
		}else {
			ContractSaleEntity oralContractSale = contractSaleService.getEntity(ContractSaleEntity.class, contractSale.getContractid());
			contractSale.setContractname(oralContractSale.getName());
			contractSale.setStartdate(oralContractSale.getStartdate());
			contractSale.setEnddate(oralContractSale.getEnddate());
			contractSale.setNextbiddingdate(oralContractSale.getNextbiddingdate());
			contractSale.setServicecontent(oralContractSale.getServicecontent());
			contractSale.setProjectid(oralContractSale.getProjectid());
			contractSale.setProjectname(oralContractSale.getProjectname());
			contractSale.setCustomerid(oralContractSale.getCustomerid());
			contractSale.setCustomername(oralContractSale.getCustomername());
			contractSale.setPaytype(oralContractSale.getPaytype());
			
			contractSale.setType(Globals.CONTRACT_TYPE_SALE_ADDING);
			req.setAttribute("contractSalePage", contractSale);
		}
		return new ModelAndView("cn/com/lzt/contractsale/contractSaleModify-add");
	}
	
	/**
	 * 销售合同编辑页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "goModifyUpdate")
	public ModelAndView goUpdateModify(ContractSaleEntity contractSale, HttpServletRequest req) {
		if (StringUtil.isNotEmpty(contractSale.getId())) {
			contractSale = contractSaleService.getEntity(ContractSaleEntity.class, contractSale.getId());
			ContractSaleEntity oralContractSale = contractSaleService.getEntity(ContractSaleEntity.class, contractSale.getContractid());
			contractSale.setContractname(oralContractSale.getName());
			req.setAttribute("contractSalePage", contractSale);
		}
		return new ModelAndView("cn/com/lzt/contractsale/contractSaleModify-update");
	}
	
	/**
	 * 外包合同续签页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "goRenew")
	public ModelAndView goRenew(ContractSaleEntity contract, HttpServletRequest req) {
		String oralContractId = contract.getId();
		if (StringUtil.isNotEmpty(oralContractId)) {
			try {
				ContractSaleEntity contractOral = contractSaleService.getEntity(ContractSaleEntity.class, contract.getId());
				contract = new ContractSaleEntity();
				MyBeanUtils.copyBeanNotNull2Bean(contractOral,contract);
				//设置续签后的起止日期
				int contractDays = XcglDateUtils.differentDays(contract.getStartdate(), contract.getEnddate());
				Date startdate = XcglDateUtils.addDateDay(contract.getEnddate(), 1);
				Date enddate = XcglDateUtils.addDateDay(startdate, contractDays);
				//清空部分数据，设置默认值*****
				contract.setId(null);
				contract.setSigndate(null);
				contract.setStartdate(startdate);
				contract.setEnddate(enddate);
				contract.setTotalincome(DecimalUtils.ZERO);
				contract.setTotalinvoice(DecimalUtils.ZERO);
				contract.setBpmStatus(Globals.BPM_STATUS_Normal.toString());
				contract.setBusstatus(Globals.CONTRACT_STATUS_SIGN);
				contract.setCreateBy(null);
				contract.setCreateDate(null);
				contract.setCreateName(null);
				contract.setUpdateBy(null);
				contract.setUpdateDate(null);
				contract.setUpdateName(null);
				contract.setCode(null);
				contract.setAddamount(null);
				contract.setTotaladdandamount(contract.getTotalamount());
			} catch (Exception e) {
				logger.error(e.getMessage());
			}
			req.setAttribute("oralContractId", oralContractId);
			req.setAttribute("contractSalePage", contract);
		}
		return new ModelAndView("cn/com/lzt/contractsale/contractSale-renew");
	}
}