package cn.com.lzt.publicpage.controller;

import cn.com.lzt.arrangeduty.dto.ProjectDepartDto;
import cn.com.lzt.common.entity.WebUploadEntity;
import cn.com.lzt.common.service.TSysFileServiceI;
import cn.com.lzt.partner.entity.PartnerEntity;
import cn.com.lzt.personnelbasearchivesmanage.entity.PersonnelBaseArchivesManageEntity;
import cn.com.lzt.relatedunits.entity.RelatedUnitsEntity;
import cn.com.lzt.useractiviti.data.dao.UseractivitiDataDao;
import cn.com.lzt.warehouse.entity.WarehouseEntity;
import org.apache.commons.lang.xwork.StringUtils;
import org.apache.log4j.Logger;
import org.hibernate.criterion.Property;
import org.jeecgframework.core.common.controller.BaseController;
import org.jeecgframework.core.common.exception.BusinessException;
import org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery;
import org.jeecgframework.core.common.model.json.DataGrid;
import org.jeecgframework.core.constant.Globals;
import org.jeecgframework.core.util.ResourceUtil;
import org.jeecgframework.core.util.StringUtil;
import org.jeecgframework.core.util.oConvertUtils;
import org.jeecgframework.tag.core.easyui.TagUtil;
import org.jeecgframework.tag.vo.datatable.SortDirection;
import org.jeecgframework.web.system.pojo.base.TSDepart;
import org.jeecgframework.web.system.pojo.base.TSRoleUser;
import org.jeecgframework.web.system.pojo.base.TSUser;
import org.jeecgframework.web.system.pojo.base.TSUserOrg;
import org.jeecgframework.web.system.service.SystemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;

/**
 * 提供一些共用的页面，例如人员选择页面、供应商选择界面、客户选择界面、区域选择页面等
 * 
 * */
@Controller
@RequestMapping("/publicpageController")
public class PublicPageController  extends BaseController {
	/**
	 * Logger for this class
	 */
	private static final Logger logger = Logger.getLogger(PublicPageController.class);

//	@Autowired
//	private PartnerServiceI partnerService;
	@Autowired
	private SystemService systemService;
	// 下载路径
	private static final String showAndDownUrl = ResourceUtil.getConfigByName("showAndDownUrl");
	@Autowired
	private TSysFileServiceI tSysFileService;

	@Autowired
	private UseractivitiDataDao useractivitiDataDao;
	/**
	 * 所有供应商选择弹窗页面跳转路径
	 * 列表页弹窗
	 * @author liujie
	 * 2017-12-13
	 * @param request
	 * @return
	 */
	@RequestMapping(params = "supplierSelect")
	public ModelAndView supplierSelect(HttpServletRequest request) {
		//return new ModelAndView("cn/com/lzt/arrangeduty/dutyMealTable");
		ModelAndView mv = new ModelAndView("cn/com/lzt/publicpage/supplierSelect");
		String ids = oConvertUtils.getString(request.getParameter("ids"));
		mv.addObject("ids", ids);
		return mv;
		
	}
	@RequestMapping(params = "supplierSelectDatagrid")
	public void supplierSelectDatagrid(RelatedUnitsEntity relatedUnitsEntity, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
// 		TSUser tSUser=ResourceUtil.getSessionUser();
		CriteriaQuery cq = new CriteriaQuery(RelatedUnitsEntity.class, dataGrid);
		String code = request.getParameter("unitCode");  
		String name = request.getParameter("unitName"); 
		//查询条件组装器
		if(StringUtils.isNotBlank(code)){
			//模糊查询
			cq.like("unitCode", "%"+code+"%");
			relatedUnitsEntity.setUnitCode(null);
		}
		if(StringUtils.isNotBlank(name)){
			//模糊查询
			cq.like("unitName", "%"+name+"%");
			relatedUnitsEntity.setUnitName(null);
		}
		
		//查询条件组装器
		org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, relatedUnitsEntity, request.getParameterMap());
		try{
		//自定义追加查询条件
		}catch (Exception e) {
			throw new BusinessException(e.getMessage());
		}
		cq.add();
		this.systemService.getDataGridReturn(cq, true);
		TagUtil.datagrid(response, dataGrid);
		
//		List<RelatedUnitsEntity> PartnerEntityList=partnerService.findHql(" from RelatedUnitsEntity where  1=1");
//		dataGrid.setResults(PartnerEntityList);
//		TagUtil.datagrid(response, dataGrid);
	}
	/**
	 * 所有客户选择弹窗页面跳转路径
	 * 列表页弹窗
	 * @author liujie
	 * 2017-12-13
	 * @param request
	 * @return
	 */
	@RequestMapping(params = "customerSelect")
	public ModelAndView customerSelect(HttpServletRequest request) {
		//return new ModelAndView("cn/com/lzt/arrangeduty/dutyMealTable");
		ModelAndView mv = new ModelAndView("cn/com/lzt/publicpage/customerSelect");
		String ids = oConvertUtils.getString(request.getParameter("ids"));
		mv.addObject("ids", ids);
		return mv;
		
	}
	@RequestMapping(params = "customerSelectDatagrid")
	public void customerSelectDatagrid(PartnerEntity partnerEntity, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
// 		TSUser tSUser=ResourceUtil.getSessionUser();
		CriteriaQuery cq = new CriteriaQuery(PartnerEntity.class, dataGrid);
		
		 // 用户帐号模糊查询
        if(partnerEntity.getName() != null && !"".equals(partnerEntity.getName().trim())){
        	partnerEntity.setName("*" + partnerEntity.getName() + "*");
        }
        // 用户姓名模糊查询
        if(partnerEntity.getCode() != null && !"".equals(partnerEntity.getCode().trim())){
        	partnerEntity.setCode("*" + partnerEntity.getCode() + "*");
        }
//		List<PartnerEntity> PartnerEntityList=systemService.findHql(" from PartnerEntity where  1=1");
//		dataGrid.setResults(PartnerEntityList);
        try{
			//查询条件组装器
			org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, partnerEntity);
		}catch (Exception e) {
			throw new BusinessException(e.getMessage());
		}
		this.systemService.getDataGridReturn(cq, true);
		TagUtil.datagrid(response, dataGrid);
	}
	@RequestMapping(params = "userSelect")
	public ModelAndView userSelect(HttpServletRequest req) {
		//return new ModelAndView("cn/com/lzt/arrangeduty/dutyMealTable");
		ModelAndView mv = new ModelAndView("cn/com/lzt/publicpage/userSelect");
		String checkbox =oConvertUtils.getString(req.getParameter("checkbox"), "false");
		req.setAttribute("checkbox", checkbox);
		return mv;
	}

	@RequestMapping(params = "carSelect")
	public ModelAndView carSelect(HttpServletRequest req) {
		//return new ModelAndView("cn/com/lzt/arrangeduty/dutyMealTable");
		ModelAndView mv = new ModelAndView("cn/com/lzt/publicpage/carSelect");
		String checkbox =oConvertUtils.getString(req.getParameter("checkbox"), "true");
		req.setAttribute("checkbox", checkbox);
		return mv;
	}

	@RequestMapping(params = "userSelectSameDepart")
	public ModelAndView userSelectSameDepart(HttpServletRequest req) {
		ModelAndView mv = new ModelAndView("cn/com/lzt/publicpage/userSelectSameDepart");
		return mv;
	}

	@RequestMapping(params = "roadSectionSelect")
	public ModelAndView roadSectionSelect(HttpServletRequest req) {
		//return new ModelAndView("cn/com/lzt/arrangeduty/dutyMealTable");
		ModelAndView mv = new ModelAndView("cn/com/lzt/publicpage/roadSectionSelect");
		String checkbox =oConvertUtils.getString(req.getParameter("checkbox"), "true");
		req.setAttribute("checkbox", checkbox);
		return mv;
	}

	/**
	 * 文件管理表列表 页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "tSysFileList")
	public ModelAndView tSysFileList(HttpServletRequest request, HttpServletRequest req,WebUploadEntity webUpload) {
		if (null == webUpload) {
			webUpload = new WebUploadEntity();
		}
		String busiId = request.getParameter("busiId");
		String encryptpdf = request.getParameter("encryptpdf");
		String download = StringUtils.isEmpty(request.getParameter("download"))?"true":request.getParameter("download");
		String curUserName = ResourceUtil.getSessionUser().getUserName();
		req.setAttribute("curUserName", curUserName);
		req.setAttribute("webUpload", webUpload);
		req.setAttribute("showAndDownUrl", showAndDownUrl);
		req.setAttribute("busiId", busiId);
		req.setAttribute("encryptpdf", encryptpdf);
		req.setAttribute("download", download);
		
		return new ModelAndView("cn/com/lzt/publicpage/tSysFileList");
	}
	
	
	@RequestMapping(params = "fileUploader")
	public ModelAndView fileUploader(HttpServletRequest request, HttpServletRequest req,WebUploadEntity webUpload) {
		if (null == webUpload) {
			webUpload = new WebUploadEntity();
		}
		String busiId = request.getParameter("busiId");
		String encryptpdf = request.getParameter("encryptpdf");
		String curUserName = ResourceUtil.getSessionUser().getUserName();
		req.setAttribute("curUserName", curUserName);
		req.setAttribute("webUpload", webUpload);
		req.setAttribute("showAndDownUrl", showAndDownUrl);
		req.setAttribute("busiId", busiId);
		req.setAttribute("encryptpdf", encryptpdf);
		
		return new ModelAndView("cn/com/lzt/publicpage/fileUploader");
	}
	
	@RequestMapping(params = "projectSelect")
	public ModelAndView projectSelect(HttpServletRequest request) {
		//return new ModelAndView("cn/com/lzt/arrangeduty/dutyMealTable");
		ModelAndView mv = new ModelAndView("cn/com/lzt/publicpage/projectSelect");
		String ids = oConvertUtils.getString(request.getParameter("ids"));
		String auth = StringUtils.isEmpty(request.getParameter("auth"))?"0":request.getParameter("auth");
		mv.addObject("ids", ids);
		request.setAttribute("auth", auth);
		return mv;
		
	}
	
	/**
     * 文件上传通用跳转
     *
     * @param req
     * @return
     */
    @RequestMapping(params = "commonUpload")
    public ModelAndView commonUpload(HttpServletRequest req) {
    	String extend = req.getParameter("extend");
		String uploader = req.getParameter("uploader");
		req.setAttribute("extend", extend);
    	req.setAttribute("uploader", uploader);
        return new ModelAndView("cn/com/lzt/publicpage/uploadView");
    }
    @RequestMapping(params = "departSelect")
    public ModelAndView departSelect(HttpServletRequest req) {
    	String checkbox = "false";
    	if(StringUtils.isNotEmpty(req.getParameter("checkbox")) && req.getParameter("checkbox").equals("true")) {
    		checkbox = "true";
    	}
    	String ids = "";
    	if(StringUtils.isNotEmpty(req.getParameter("ids")) ) {
    		ids = req.getParameter("ids");
    	}
    	req.setAttribute("ids", ids);
    	req.setAttribute("checkbox", checkbox);
        return new ModelAndView("cn/com/lzt/publicpage/departSelect");
    }
    
    
    @RequestMapping(params = "departDatagrid")
	public void departDatagrid(TSDepart tSDepart, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
// 		TSUser tSUser=ResourceUtil.getSessionUser();
		CriteriaQuery cq = new CriteriaQuery(TSDepart.class, dataGrid);
		
		 // 模糊查询
        if(StringUtils.isNotEmpty(tSDepart.getDepartname())){
        	tSDepart.setDepartname("*" + tSDepart.getDepartname() + "*");
        }
        if(StringUtils.isNotEmpty(tSDepart.getOrgCode())){
        	tSDepart.setOrgCode("*" + tSDepart.getOrgCode() + "*");
        }
        
        cq.eq("TSPDepart.id", "4028e4a55f6c84ec015f6ca5c6ab0001");
		//查询条件组装器
		org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tSDepart, request.getParameterMap());
		try{
		//自定义追加查询条件
		}catch (Exception e) {
			throw new BusinessException(e.getMessage());
		}
		cq.add();
		this.systemService.getDataGridReturn(cq, true);
		TagUtil.datagrid(response, dataGrid);
	}
    
    @RequestMapping(params = "clothingSelectAll")
    public ModelAndView clothingSelectAll(HttpServletRequest req) {
        return new ModelAndView("cn/com/lzt/publicpage/clothingSelect");
    }
    
    @RequestMapping(params = "clothingSelectByUser")
    public ModelAndView clothingSelectByUser(HttpServletRequest req) {
    	String userid = req.getParameter("userid");
    	req.setAttribute("userid", userid);
        return new ModelAndView("cn/com/lzt/publicpage/clothingSelectByUser");
    }
    @RequestMapping(params = "warehouseSelect")
	public ModelAndView warehouseSelect(HttpServletRequest request) {
    	String isauth = request.getParameter("isauth");
    	request.setAttribute("isauth", isauth);
		ModelAndView mv = new ModelAndView("cn/com/lzt/publicpage/warehouseSelect");
//		String ids = oConvertUtils.getString(request.getParameter("ids"));
//		mv.addObject("ids", ids);
		return mv;
		
	}
    
    @RequestMapping(params = "warehousedatagrid")
	public void warehousedatagrid(WarehouseEntity warehouse,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		CriteriaQuery cq = new CriteriaQuery(WarehouseEntity.class, dataGrid);
		String isauth = request.getParameter("isauth");
		if(!StringUtil.isEmpty(warehouse.getWarehouseName())){
			warehouse.setWarehouseName("*" + warehouse.getWarehouseName() + "*");
		}
		if(StringUtils.isNotEmpty(isauth) && isauth.equals("1")) {
			warehouse.setResponsiblePerson(ResourceUtil.getSessionUser().getId());
		}
		//查询条件组装器
		org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, warehouse, request.getParameterMap());
		try{
			//自定义追加查询条件
	        String[] unitstate = new String[]{Globals.Enable_Forbidden, Globals.Enable_Normal};
	        cq.in("status", unitstate);
			cq.eq("deleteFlag", Globals.Delete_Normal.toString());
			cq.addOrder("createDate", SortDirection.desc);
		}catch (Exception e) {
			throw new BusinessException(e.getMessage());
		}
		cq.add();
		systemService.getDataGridReturn(cq, true);
		Collections.sort(dataGrid.getResults());
		TagUtil.datagrid(response, dataGrid);
	}

    @RequestMapping(params = "userSelectSameAndSubDepart")
	public ModelAndView userSelectSameAndSubDepart(HttpServletRequest req) {
		ModelAndView mv = new ModelAndView("cn/com/lzt/publicpage/userSelectSameAndSubDepart");
		return mv;
	}
    /**
	 * 部门和角色选择用户的用户显示列表
	 * 
	 * @param request
	 * @param response
	 * @param dataGrid
	 */
	@RequestMapping(params = "datagridUser")
	public void datagridUser(TSUser user,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		String departid = request.getParameter("departid");
		String roleid = request.getParameter("roleid");
		CriteriaQuery cq = new CriteriaQuery(TSUser.class, dataGrid);

		// 用户帐号模糊查询
		if(user.getUserName() != null && !"".equals(user.getUserName().trim())){
			user.setUserName("*" + user.getUserName() + "*");
		}
		// 用户姓名模糊查询
		if(user.getRealName() != null && !"".equals(user.getRealName().trim())){
			user.setRealName("*" + user.getRealName() + "*");
		}
		user.setDepartid(null);
		org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, user);
		cq.eq("deleteFlag", Globals.Delete_Normal);
		List<String> departidList = new ArrayList<>();
		TSUser sessionUser = ResourceUtil.getSessionUser();
		if (StringUtils.isBlank(departid)) {//默认所有部门
			List<ProjectDepartDto>  departDtoList = useractivitiDataDao.getUserAllDep(sessionUser.getId(), null);
			for(ProjectDepartDto departDto : departDtoList) {
				String sqlQryDepart = " select id from t_s_depart where id = '" + departDto.getId() + "' or parentdepartid = '" + departDto.getId() + "'";
				List<String> qryDepartList = systemService.findListbySql(sqlQryDepart);
				departidList.addAll(qryDepartList);
			}

		}else {
			String sqlQryDepart = " select id from t_s_depart where id = '"+departid+"' or parentdepartid = '"+departid+"'";
			departidList = systemService.findListbySql(sqlQryDepart);
		}
		CriteriaQuery subCq = new CriteriaQuery(TSUserOrg.class);
		subCq.setProjection(Property.forName("tsUser.id"));
		subCq.in("tsDepart.id", departidList.toArray());
//			subCq.eq("ifpluralism", Globals.PLURALISM_NO.toString());
		subCq.eq("status", Globals.BELONG_STATUS_NORMAL.toString());
		subCq.add();
		cq.add(Property.forName("id").in(subCq.getDetachedCriteria()));
		cq.add();
		String userid = "";
		if (StringUtils.isNotBlank(roleid)) {
			List<TSRoleUser> roleUsers = systemService.findByProperty(TSRoleUser.class, "TRole.roleid", oConvertUtils.getInt(roleid, 0));
			if (roleUsers.size() > 0) {
				for (TSRoleUser tRoleUser : roleUsers) {
					userid += tRoleUser.getTSUser().getId() + ",";
				}
			}
			cq.in("userid", oConvertUtils.getInts(userid.split(",")));
			cq.add();
		}
		this.systemService.getDataGridReturn(cq, true);
		List<TSUser> cfeList = new ArrayList<TSUser>();
		for (Object o : dataGrid.getResults()) {
			if (o instanceof TSUser) {
				TSUser cfe = (TSUser) o;
				if (cfe.getId() != null && !"".equals(cfe.getId())) {
					List<TSRoleUser> roleUser = systemService.findByProperty(TSRoleUser.class, "TSUser.id", cfe.getId());
					PersonnelBaseArchivesManageEntity pbame = systemService.findUniqueByProperty(PersonnelBaseArchivesManageEntity.class, "userid", cfe.getId());
					if (pbame != null) {
						cfe.setPositionStatus(pbame.getPositionStatus());
						cfe.setContractStime(pbame.getCreateDate());
						cfe.setDutiesId(pbame.getBelongDutiesid());
						cfe.setOrgIds(departid);
						cfe.setPostId(pbame.getInPostid());
					}
					if (roleUser.size() > 0) {
						String roleName = "";
						for (TSRoleUser ru : roleUser) {
							roleName += ru.getTSRole().getRoleName() + ",";
						}
						roleName = roleName.substring(0, roleName.length() - 1);
						cfe.setUserKey(roleName);
					}
					// 只显示 已入职、已转正
//					if(cfe.getPositionStatus()==null) continue;//有时候是null
					String includeLeave = request.getParameter("includeLeave");
					if(StringUtils.equals(includeLeave,"true")) {
						cfeList.add(cfe);
					}else {
						cfeList.add(cfe);
//						delete-刘梦祥-2021年11月19日17:55:03（在职状没有业务逻辑，暂时删除）
//						if (cfe.getPositionStatus() != null && (cfe.getPositionStatus().equals("1") || cfe.getPositionStatus().equals("2")))
//							cfeList.add(cfe);
					}
				}
			}
		}
		dataGrid.setResults(cfeList);
		TagUtil.datagrid(response, dataGrid);
	}
	
	 @RequestMapping(params = "departSelectproject")
	    public ModelAndView departSelectProject(HttpServletRequest req) {
	    	String checkbox = "false";
	    	if(StringUtils.isNotEmpty(req.getParameter("checkbox")) && req.getParameter("checkbox").equals("true")) {
	    		checkbox = "true";
	    	}
	    	String ids = "";
	    	if(StringUtils.isNotEmpty(req.getParameter("ids")) ) {
	    		ids = req.getParameter("ids");
	    	}
	    	req.setAttribute("ids", ids);
	    	req.setAttribute("checkbox", checkbox);
	        return new ModelAndView("cn/com/lzt/publicpage/departSelect-project");
	    }
	    
	    
	    @RequestMapping(params = "departProjectDatagrid")
		public void departProjectDatagrid(TSDepart tSDepart, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
//	 		TSUser tSUser=ResourceUtil.getSessionUser();
			CriteriaQuery cq = new CriteriaQuery(TSDepart.class, dataGrid);
			
			 // 模糊查询
	        if(StringUtils.isNotEmpty(tSDepart.getDepartname())){
	        	tSDepart.setDepartname("*" + tSDepart.getDepartname() + "*");
	        }
	        tSDepart.setDeptCode("P_*");
	        
	        cq.eq("TSPDepart.id", "4028e4a55f6c84ec015f6ca5c6ab0001");
			//查询条件组装器
			org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tSDepart, request.getParameterMap());
			try{
			//自定义追加查询条件
			}catch (Exception e) {
				throw new BusinessException(e.getMessage());
			}
			cq.add();
			this.systemService.getDataGridReturn(cq, true);
			TagUtil.datagrid(response, dataGrid);
		}
}