Java Code Examples for org.jeecgframework.poi.excel.entity.vo.NormalExcelConstants#JEECG_EXCEL_VIEW

@RequestMapping(params = "exportXls")
public String  exportXls(JformGraphreportHeadEntity jformGraphreportHead,HttpServletRequest request,HttpServletResponse response
		, DataGrid dataGrid,ModelMap map) {
	CriteriaQuery cq = new CriteriaQuery(JformGraphreportHeadEntity.class, dataGrid);
	//查询条件组装器
	org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, jformGraphreportHead);

	List<JformGraphreportHeadEntity> dataList= this.jformGraphreportHeadService.getListByCriteriaQuery(cq,false);
	List<JformGraphreportHeadPage> pageList=new ArrayList<JformGraphreportHeadPage>();
	if(dataList!=null&&dataList.size()>0){
		String hql0 = "from JformGraphreportItemEntity where 1 = 1 AND cGREPORT_HEAD_ID = ? ";
		for(JformGraphreportHeadEntity headEntity:dataList){
			List<JformGraphreportItemEntity> itemEntities = systemService.findHql(hql0,headEntity.getId());
			pageList.add(new JformGraphreportHeadPage(itemEntities,headEntity));
		}
	}

	map.put(NormalExcelConstants.FILE_NAME,"图表配置");
	map.put(NormalExcelConstants.CLASS,JformGraphreportHeadPage.class);
	map.put(NormalExcelConstants.PARAMS,new ExportParams("图表配置","导出信息"));
	map.put(NormalExcelConstants.DATA_LIST, pageList);
	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
 * 导出excel 使模板
 * 
 * @param request
 * @param response
 */
@RequestMapping(params = "exportXlsByT")
public String exportXlsByT(JformOrderCustomer2Entity jformOrderCustomer2,HttpServletRequest request,HttpServletResponse response
		, DataGrid dataGrid,ModelMap modelMap) {
   	modelMap.put(NormalExcelConstants.FILE_NAME,"订单客户信息");
   	modelMap.put(NormalExcelConstants.CLASS,JformOrderCustomer2Entity.class);
   	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("订单客户信息列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
   	"导出信息"));
   	modelMap.put(NormalExcelConstants.DATA_LIST,new ArrayList());
   	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
 * 导出excel
 * 
 * @param request
 * @param response
 */
@RequestMapping(params = "exportXls")
public String exportXls(TSCompanyPositionEntity tSCompanyPosition,HttpServletRequest request,HttpServletResponse response
		, DataGrid dataGrid,ModelMap modelMap) {
	CriteriaQuery cq = new CriteriaQuery(TSCompanyPositionEntity.class, dataGrid);
	org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tSCompanyPosition, request.getParameterMap());
	List<TSCompanyPositionEntity> tSCompanyPositions = this.tSCompanyPositionService.getListByCriteriaQuery(cq,false);
	modelMap.put(NormalExcelConstants.FILE_NAME,"职务管理");
	modelMap.put(NormalExcelConstants.CLASS,TSCompanyPositionEntity.class);
	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("职务管理列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
		"导出信息"));
	modelMap.put(NormalExcelConstants.DATA_LIST,tSCompanyPositions);
	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
 * 导出excel
 * 
 * @param request
 * @param response
 */
@RequestMapping(params = "exportXls")
public String exportXls(JeecgDemoExcelEntity jeecgDemoExcel,HttpServletRequest request,HttpServletResponse response
		, DataGrid dataGrid,ModelMap modelMap) {
	CriteriaQuery cq = new CriteriaQuery(JeecgDemoExcelEntity.class, dataGrid);
	org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, jeecgDemoExcel, request.getParameterMap());
	List<JeecgDemoExcelEntity> jeecgDemoExcels = this.jeecgDemoExcelService.getListByCriteriaQuery(cq,false);
	modelMap.put(NormalExcelConstants.FILE_NAME,"excel导入导出测试表");
	modelMap.put(NormalExcelConstants.CLASS,JeecgDemoExcelEntity.class);
	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("excel导入导出测试表列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
		"导出信息"));
	modelMap.put(NormalExcelConstants.DATA_LIST,jeecgDemoExcels);
	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
 * 导出excel
 * 
 * @param request
 * @param response
 */
@RequestMapping(params = "exportXls")
public String exportXls(JeecgDemoEntity jeecgDemo,HttpServletRequest request,HttpServletResponse response
		, DataGrid dataGrid,ModelMap modelMap) {
	CriteriaQuery cq = new CriteriaQuery(JeecgDemoEntity.class, dataGrid);
	org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, jeecgDemo, request.getParameterMap());
	List<JeecgDemoEntity> jeecgDemos = this.jeecgDemoService.getListByCriteriaQuery(cq,false);
	modelMap.put(NormalExcelConstants.FILE_NAME,"jeecg_demo");
	modelMap.put(NormalExcelConstants.CLASS,JeecgDemoEntity.class);
	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("jeecg_demo列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),"导出信息"));
	modelMap.put(NormalExcelConstants.DATA_LIST,jeecgDemos);
	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
 * 导出excel 使模板
 * 
 * @param request
 * @param response
 */
@RequestMapping(params = "exportXlsByT")
public String exportXlsByT(JeecgDemoEntity jeecgDemo,HttpServletRequest request,HttpServletResponse response
		, DataGrid dataGrid,ModelMap modelMap) {
   	modelMap.put(NormalExcelConstants.FILE_NAME,"jeecg_demo");
   	modelMap.put(NormalExcelConstants.CLASS,JeecgDemoEntity.class);
   	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("jeecg_demo列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
   	"导出信息"));
   	modelMap.put(NormalExcelConstants.DATA_LIST,new ArrayList());
   	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
 * 导出excel
 * 
 * @param request
 * @param response
 */
@RequestMapping(params = "exportXls")
public String exportXls(TSDictTableConfigEntity tSDictTableConfig,HttpServletRequest request,HttpServletResponse response
		, DataGrid dataGrid,ModelMap modelMap) {
	CriteriaQuery cq = new CriteriaQuery(TSDictTableConfigEntity.class, dataGrid);
	org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tSDictTableConfig, request.getParameterMap());
	List<TSDictTableConfigEntity> tSDictTableConfigs = this.tSDictTableConfigService.getListByCriteriaQuery(cq,false);
	modelMap.put(NormalExcelConstants.FILE_NAME,"字典表授权配置");
	modelMap.put(NormalExcelConstants.CLASS,TSDictTableConfigEntity.class);
	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("字典表授权配置列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
		"导出信息"));
	modelMap.put(NormalExcelConstants.DATA_LIST,tSDictTableConfigs);
	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
 * 导出excel 使模板
 * 
 * @param request
 * @param response
 */
@RequestMapping(params = "exportXlsByT")
public String exportXlsByT(JeecgDemoExcelEntity jeecgDemoExcel,HttpServletRequest request,HttpServletResponse response
		, DataGrid dataGrid,ModelMap modelMap) {
   	modelMap.put(NormalExcelConstants.FILE_NAME,"excel导入导出测试表");
   	modelMap.put(NormalExcelConstants.CLASS,JeecgDemoExcelEntity.class);
   	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("excel导入导出测试表列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
   	"导出信息"));
   	modelMap.put(NormalExcelConstants.DATA_LIST,new ArrayList());
   	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
* 导出excel 使模板
*/
@RequestMapping(params = "exportXlsByT")
public String exportXlsByT(ModelMap map) {
	map.put(NormalExcelConstants.FILE_NAME,"订单主信息");
	map.put(NormalExcelConstants.CLASS,JformOrderMainPage.class);
	map.put(NormalExcelConstants.PARAMS,new ExportParams("订单主信息列表", "导出人:"+ ResourceUtil.getSessionUser().getRealName(),
	"导出信息"));
	map.put(NormalExcelConstants.DATA_LIST,new ArrayList());
	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
 * 导出excel 使模板
 *
 * @param request
 * @param response
 */
@RequestMapping(params = "exportXlsByT")
public String exportXlsByT(TSDepart tsDepart,HttpServletRequest request,HttpServletResponse response
		, DataGrid dataGrid,ModelMap modelMap) {
	modelMap.put(NormalExcelConstants.FILE_NAME,"组织机构表");
	modelMap.put(NormalExcelConstants.CLASS,TSDepart.class);
	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("组织机构表列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
			"导出信息"));
	modelMap.put(NormalExcelConstants.DATA_LIST,new ArrayList());
	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
 * 导出excel
 *
 * @param request
 * @param response
 */
@RequestMapping(params = "exportXls")
public String exportXls(TSDepart tsDepart, HttpServletRequest request, HttpServletResponse response
		, DataGrid dataGrid, ModelMap modelMap) {
	CriteriaQuery cq = new CriteriaQuery(TSDepart.class, dataGrid);
	org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tsDepart, request.getParameterMap());
	cq.addOrder("orgCode", SortDirection.asc);
	List<TSDepart> tsDeparts = this.systemService.getListByCriteriaQuery(cq,false);
	/*List<TSDepart> finalTsDeparts = new ArrayList<TSDepart>();
	List<TSDepart> tsDeparts = systemService.getSession().createSQLQuery("select * from t_s_depart where length(org_code) = 3 order by org_code asc").addEntity(TSDepart.class).list();
	for(TSDepart tsDepart1:tsDeparts){
		finalTsDeparts.add(tsDepart1);
		String orgcode1 = tsDepart1.getOrgCode();
		List<TSDepart> tsDeparts1 = systemService.getSession().createSQLQuery("select * from t_s_depart where org_code like :orgcode and length(org_code)=6 order by org_code asc").addEntity(TSDepart.class).setString("orgcode",orgcode1+"%").list();
		for(TSDepart tsDepart2:tsDeparts1){
			finalTsDeparts.add(tsDepart2);
			String orgcode2 = tsDepart2.getOrgCode();
			List<TSDepart> tsDeparts2 = systemService.getSession().createSQLQuery("select * from t_s_depart where org_code like :orgcode and length(org_code)=9 order by org_code asc").addEntity(TSDepart.class).setString("orgcode",orgcode2+"%").list();
			for(TSDepart tsDepart3:tsDeparts2){
				finalTsDeparts.add(tsDepart3);
			}
		}
	}*/
	modelMap.put(NormalExcelConstants.FILE_NAME,"组织机构表");
	modelMap.put(NormalExcelConstants.CLASS,TSDepart.class);
	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("组织机构表列表", "导出人:"+ ResourceUtil.getSessionUser().getRealName(),
			"导出信息"));
	modelMap.put(NormalExcelConstants.DATA_LIST,tsDeparts);
	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
* 导出excel 使模板
*/
@SuppressWarnings( "rawtypes"   )
@RequestMapping(params = "exportXlsByT")
public String exportXlsByT(ModelMap map) {
	map.put(NormalExcelConstants.FILE_NAME,"高级查询");
	map.put(NormalExcelConstants.CLASS,SuperQueryMainPage.class);
	map.put(NormalExcelConstants.PARAMS,new ExportParams("高级查询列表", "导出人:"+ ResourceUtil.getSessionUser().getRealName(),
	"导出信息"));
	map.put(NormalExcelConstants.DATA_LIST,new ArrayList());
	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
 * 导出excel
 *
 * @param request
 * @param response
 */
@RequestMapping(params = "exportXls")
public String exportXls(TSUser tsUser,HttpServletRequest request,HttpServletResponse response
		, DataGrid dataGrid,ModelMap modelMap) {
	CriteriaQuery cq = new CriteriaQuery(TSUser.class, dataGrid);
	org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tsUser, request.getParameterMap());
	List<TSUser> tsUsers = this.userService.getListByCriteriaQuery(cq,false);
	//导出的时候处理一下组织机构编码和角色编码
	for(int i=0;i<tsUsers.size();i++){
		TSUser user = tsUsers.get(i);
		//托管
		systemService.getSession().evict(user);
		String id = user.getId();

		String queryRole = "select * from t_s_role where id in (select roleid from t_s_role_user where userid=:userid)";
		List<TSRole> roles = systemService.getSession().createSQLQuery(queryRole).addEntity(TSRole.class).setString("userid",id).list();
		String roleCodes = "";
		for(TSRole role:roles){
			roleCodes += ","+role.getRoleCode();
		}
		user.setUserKey(roleCodes.replaceFirst(",", ""));
		String queryDept = "select * from t_s_depart where id in (select org_id from t_s_user_org where user_id=:userid)";
		List<TSDepart> departs = systemService.getSession().createSQLQuery(queryDept).addEntity(TSDepart.class).setString("userid",id).list();
		String departCodes = "";
		for(TSDepart depart:departs){
			departCodes += ","+depart.getOrgCode();
		}
		user.setDepartid(departCodes.replaceFirst(",", ""));

	}
	modelMap.put(NormalExcelConstants.FILE_NAME,"用户表");
	modelMap.put(NormalExcelConstants.CLASS,TSUser.class);
	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("用户表列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
			"导出信息"));
	modelMap.put(NormalExcelConstants.DATA_LIST,tsUsers);
	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
 * 导出excel 使模板
 * 
 * @param request
 * @param response
 */
@RequestMapping(params = "exportXlsByT")
public String exportXlsByT(TsBlackListEntity tsBlackList,HttpServletRequest request,HttpServletResponse response
		, DataGrid dataGrid,ModelMap modelMap) {
   	modelMap.put(NormalExcelConstants.FILE_NAME,"黑名单");
   	modelMap.put(NormalExcelConstants.CLASS,TsBlackListEntity.class);
   	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("黑名单列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
   	"导出信息"));
   	modelMap.put(NormalExcelConstants.DATA_LIST,new ArrayList());
   	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
 * 导出excel
 * 
 * @param request
 * @param response
 */
@RequestMapping(params = "exportXls")
public String exportXls(MultiUploadEntity multiUpload,HttpServletRequest request,HttpServletResponse response
		, DataGrid dataGrid,ModelMap modelMap) {
	CriteriaQuery cq = new CriteriaQuery(MultiUploadEntity.class, dataGrid);
	org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, multiUpload, request.getParameterMap());
	List<MultiUploadEntity> multiUploads = this.multiUploadService.getListByCriteriaQuery(cq,false);
	modelMap.put(NormalExcelConstants.FILE_NAME,"测试多文件上传");
	modelMap.put(NormalExcelConstants.CLASS,MultiUploadEntity.class);
	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("测试多文件上传列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
		"导出信息"));
	modelMap.put(NormalExcelConstants.DATA_LIST,multiUploads);
	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
 * 导出excel 使模板
 * 
 * @param request
 * @param response
 */
@RequestMapping(params = "exportXlsByT")
public String exportXlsByT(TSFillRuleEntity tSFillRule,HttpServletRequest request,HttpServletResponse response
		, DataGrid dataGrid,ModelMap modelMap) {
   	modelMap.put(NormalExcelConstants.FILE_NAME,"填值规则表");
   	modelMap.put(NormalExcelConstants.CLASS,TSFillRuleEntity.class);
   	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("填值规则表列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
   	"导出信息"));
   	modelMap.put(NormalExcelConstants.DATA_LIST,new ArrayList());
   	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
 * 导出excel
 * 
 * @param request
 * @param response
 */
@RequestMapping(params = "exportXls")
public String exportXls(TSFillRuleEntity tSFillRule,HttpServletRequest request,HttpServletResponse response
		, DataGrid dataGrid,ModelMap modelMap) {
	CriteriaQuery cq = new CriteriaQuery(TSFillRuleEntity.class, dataGrid);
	org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tSFillRule, request.getParameterMap());
	List<TSFillRuleEntity> tSFillRules = this.tSFillRuleService.getListByCriteriaQuery(cq,false);
	modelMap.put(NormalExcelConstants.FILE_NAME,"填值规则表");
	modelMap.put(NormalExcelConstants.CLASS,TSFillRuleEntity.class);
	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("填值规则表列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
		"导出信息"));
	modelMap.put(NormalExcelConstants.DATA_LIST,tSFillRules);
	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
 * 导出excel 使模板
 * 
 * @param request
 * @param response
 */
@RequestMapping(params = "exportXlsByT")
public String exportXlsByT(TSCompanyPositionEntity tSCompanyPosition,HttpServletRequest request,HttpServletResponse response
		, DataGrid dataGrid,ModelMap modelMap) {
   	modelMap.put(NormalExcelConstants.FILE_NAME,"职务管理");
   	modelMap.put(NormalExcelConstants.CLASS,TSCompanyPositionEntity.class);
   	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("职务管理列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
   	"导出信息"));
   	modelMap.put(NormalExcelConstants.DATA_LIST,new ArrayList());
   	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
* 导出excel 使模板
*/
@RequestMapping(params = "exportXlsByT")
public String exportXlsByT(ModelMap map) {
	map.put(NormalExcelConstants.FILE_NAME,"订单列表");
	map.put(NormalExcelConstants.CLASS,JfromOrderPage.class);
	map.put(NormalExcelConstants.PARAMS,new ExportParams("订单列表列表", "导出人:"+ ResourceUtil.getSessionUser().getRealName(),
	"导出信息"));
	map.put(NormalExcelConstants.DATA_LIST,new ArrayList());
	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}
 

/**
 * 导出excel
 * 
 * @param request
 * @param response
 */
@RequestMapping(params = "exportXls")
public String exportXls(CgformTemplateEntity cgformTemplate,HttpServletRequest request,HttpServletResponse response
		, DataGrid dataGrid,ModelMap modelMap) {
	CriteriaQuery cq = new CriteriaQuery(CgformTemplateEntity.class, dataGrid);
	org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, cgformTemplate, request.getParameterMap());
	List<CgformTemplateEntity> cgformTemplates = this.cgformTemplateService.getListByCriteriaQuery(cq, false);
	modelMap.put(NormalExcelConstants.FILE_NAME,"自定义模板");
	modelMap.put(NormalExcelConstants.CLASS,CgformTemplateEntity.class);
	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("自定义模板列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
		"导出信息"));
	modelMap.put(NormalExcelConstants.DATA_LIST, cgformTemplates);
	return NormalExcelConstants.JEECG_EXCEL_VIEW;
}