/**
 * 
 */
package cn.com.lzt.dbquery.controller;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.jeecgframework.core.common.controller.BaseController;
import org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery;
import org.jeecgframework.core.common.model.json.DataGrid;
import org.jeecgframework.core.util.JeecgDataAutorUtils;
import org.jeecgframework.core.util.ResourceUtil;
import org.jeecgframework.minidao.pojo.MiniDaoPage;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.entity.vo.NormalExcelConstants;
import org.jeecgframework.tag.core.easyui.TagUtil;
import org.jeecgframework.web.system.service.SystemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

import cn.com.lzt.dbquery.dao.DbQueryUserMiniDao;
import cn.com.lzt.dbquery.dto.DbQueryUserByAgeDto;
import cn.com.lzt.dbquery.dto.DbQueryUserByCertDto;
import cn.com.lzt.dbquery.dto.DbQueryUserByEduDto;
import cn.com.lzt.dbquery.dto.DbQueryUserByGenderDto;
import cn.com.lzt.dbquery.dto.DbQueryUserByHujidiDto;
import cn.com.lzt.dbquery.dto.DbQueryUserByHukouDto;
import cn.com.lzt.dbquery.dto.DbQueryUserByJiaojinDto;
import cn.com.lzt.dbquery.dto.DbQueryUserByUserEventDto;
import cn.com.lzt.dbquery.dto.DbQueryUserByUserOperateDto;
import cn.com.lzt.dbquery.dto.DbQueryUserByWorkExperDto;
import cn.com.lzt.duties.entity.DutiesEntity;

@Controller
@RequestMapping("/dbQueryUserController")
public class DbQueryUserController extends BaseController {
	
	@Autowired
	private SystemService systemService;
	@Autowired
	private DbQueryUserMiniDao queryUserMiniDao;
	
	@RequestMapping(params = "queryByAgeList")
	public ModelAndView queryByAgeList(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/dbquery/queryByAgeList");
	}

	@RequestMapping(params = "queryByAgeDatagrid")
	public void queryByAgeDatagrid(DbQueryUserByAgeDto inDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		if(inDto.getMinBirth() == null && inDto.getMaxBirth() == null) {
			dataGrid.setResults(new ArrayList<DbQueryUserByAgeDto>());
			TagUtil.datagrid(response, dataGrid);
			return;
		}
		MiniDaoPage<DbQueryUserByAgeDto> list = queryUserMiniDao.queryUserByAge(inDto, authSql);
		dataGrid.setTotal(list.getTotal());
		dataGrid.setResults(list.getResults());
		TagUtil.datagrid(response, dataGrid);		
	}
	
	@RequestMapping(params = "queryByCertList")
	public ModelAndView queryByCertList(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/dbquery/queryByCertList");
	}

	@RequestMapping(params = "queryByCertDatagrid")
	public void queryByCertDatagrid(DbQueryUserByCertDto inDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		/*if(inDto.getCertId() == null) {
			dataGrid.setResults(new ArrayList<DbQueryUserByCertDto>());
			TagUtil.datagrid(response, dataGrid);
			return;
		}*/
		MiniDaoPage<DbQueryUserByCertDto> list = queryUserMiniDao.queryUserByCert(inDto, authSql);
		Map<String, Object> map = queryUserMiniDao.queryUserByCertTotal(inDto);
		dataGrid.setTotal(list.getTotal());
		dataGrid.setResults(list.getResults());
		dataGrid.setFooter("total:" + map.get("total") + ",certCount:" + map.get("certCount") + ",percent:" + map.get("percent"));
		TagUtil.datagrid(response, dataGrid);	
	}
	

	@RequestMapping(params = "queryByEduList")
	public ModelAndView queryByEduList(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/dbquery/queryByEduList");
	}

	@RequestMapping(params = "queryByEduDatagrid")
	public void queryByEduDatagrid(DbQueryUserByEduDto inDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		MiniDaoPage<DbQueryUserByEduDto> list = queryUserMiniDao.queryUserByEdu(inDto, authSql);
		dataGrid.setTotal(list.getTotal());
		dataGrid.setResults(list.getResults());
		TagUtil.datagrid(response, dataGrid);	
	}
	
	@RequestMapping(params = "queryByGenderList")
	public ModelAndView queryByGenderList(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/dbquery/queryByGenderList");
	}

	@RequestMapping(params = "queryByGenderDatagrid")
	public void queryByGenderDatagrid(DbQueryUserByGenderDto inDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		MiniDaoPage<DbQueryUserByGenderDto> list = queryUserMiniDao.queryUserByGender(inDto, authSql);
		dataGrid.setTotal(list.getTotal());
		dataGrid.setResults(list.getResults());
		TagUtil.datagrid(response, dataGrid);	
	}
	
	/**
	 * 导出Gender_excel
	 * 
	 * @param request
	 * @param response
	 */
	@RequestMapping(params = "exportXls_gender")
	public String exportXls_gender(DbQueryUserByGenderDto inDto,HttpServletRequest request,HttpServletResponse response
			, DataGrid dataGrid,ModelMap modelMap) {
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		MiniDaoPage<DbQueryUserByGenderDto> list = queryUserMiniDao.queryUserByGender(inDto, authSql);
		modelMap.put(NormalExcelConstants.FILE_NAME,"项目在职人数统计");
		modelMap.put(NormalExcelConstants.CLASS,DbQueryUserByGenderDto.class);
		modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("项目在职人数统计", "截止在司日期:"+inDto.getInMonth(),
			"导出信息"));
		modelMap.put(NormalExcelConstants.DATA_LIST,list.getResults());
		return NormalExcelConstants.JEECG_EXCEL_VIEW;
	}
	
	@RequestMapping(params = "queryByHujidiList")
	public ModelAndView queryByHujidiList(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/dbquery/queryByHujidiList");
	}

	@RequestMapping(params = "queryByHujidiDatagrid")
	public void queryByHujidiDatagrid(DbQueryUserByHujidiDto inDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		MiniDaoPage<DbQueryUserByHujidiDto> list = queryUserMiniDao.queryUserByHujidi(inDto, authSql);
		dataGrid.setTotal(list.getTotal());
		dataGrid.setResults(list.getResults());
		TagUtil.datagrid(response, dataGrid);	
	}
	
	@RequestMapping(params = "queryByHukouList")
	public ModelAndView queryByHukouList(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/dbquery/queryByHukouList");
	}

	@RequestMapping(params = "queryByHukouDatagrid")
	public void queryByHukouDatagrid(DbQueryUserByHukouDto inDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		MiniDaoPage<DbQueryUserByHukouDto> list = queryUserMiniDao.queryUserByHukou(inDto, authSql);
		dataGrid.setTotal(list.getTotal());
		dataGrid.setResults(list.getResults());
		TagUtil.datagrid(response, dataGrid);	
	}
	
	@RequestMapping(params = "queryByJiaojinList")
	public ModelAndView queryByJiaojinList(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/dbquery/queryByJiaojinList");
	}

	@RequestMapping(params = "queryByJiaojinDatagrid")
	public void queryByJiaojinDatagrid(DbQueryUserByJiaojinDto inDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		MiniDaoPage<DbQueryUserByJiaojinDto> list = queryUserMiniDao.queryUserByJiaojin(inDto, authSql);
		dataGrid.setTotal(list.getTotal());
		dataGrid.setResults(list.getResults());
		TagUtil.datagrid(response, dataGrid);	
	}
	
	@RequestMapping(params = "queryByUserEventList")
	public ModelAndView queryByUserEventList(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/dbquery/queryByUserEventList");
	}

	@RequestMapping(params = "queryByUserEventDatagrid")
	public void queryByUserEventDatagrid(DbQueryUserByUserEventDto inDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		MiniDaoPage<DbQueryUserByUserEventDto> list = queryUserMiniDao.queryUserByUserEvent(inDto, authSql);
		dataGrid.setTotal(list.getTotal());
		dataGrid.setResults(list.getResults());
		TagUtil.datagrid(response, dataGrid);	
	}
	
	@RequestMapping(params = "queryByUserOperateList")
	public ModelAndView queryByUserOperateList(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/dbquery/queryByUserOperateList");
	}

	@RequestMapping(params = "queryByUserOperateDatagrid")
	public void queryByUserOperateDatagrid(DbQueryUserByUserOperateDto inDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		MiniDaoPage<DbQueryUserByUserOperateDto> list = queryUserMiniDao.queryUserByUserOperate(inDto, authSql);
		dataGrid.setTotal(list.getTotal());
		dataGrid.setResults(list.getResults());
		TagUtil.datagrid(response, dataGrid);	
	}
	
	@RequestMapping(params = "queryByWorkExperList")
	public ModelAndView queryByWorkExperList(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/dbquery/queryByWorkExperList");
	}

	@RequestMapping(params = "queryByWorkExperDatagrid")
	public void queryByWorkExperDatagrid(DbQueryUserByWorkExperDto inDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		MiniDaoPage<DbQueryUserByWorkExperDto> list = queryUserMiniDao.queryUserByWorkExper(inDto, authSql);
		dataGrid.setTotal(list.getTotal());
		dataGrid.setResults(list.getResults());
		TagUtil.datagrid(response, dataGrid);	
	}
	
}