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

The following examples show how to use org.jeecgframework.poi.excel.entity.vo.NormalExcelConstants#JEECG_EXCEL_VIEW . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: JformGraphreportHeadController.java From jeecg with Apache License 2.0

6 votes

@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;
}

Example 2

Source File: JformOrderCustomer2Controller.java From jeecg with Apache License 2.0

5 votes

/**
 * 导出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;
}

Example 3

Source File: TSCompanyPositionController.java From jeecg with Apache License 2.0

5 votes

/**
 * 导出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;
}

Example 4

Source File: JeecgDemoExcelController.java From jeecg with Apache License 2.0

5 votes

/**
 * 导出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;
}

Example 5

Source File: JeecgListDemoController.java From jeecg with Apache License 2.0

5 votes

/**
 * 导出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;
}

Example 6

Source File: JeecgListDemoController.java From jeecg with Apache License 2.0

5 votes

/**
 * 导出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;
}

Example 7

Source File: TSDictTableConfigController.java From jeecg with Apache License 2.0

5 votes

/**
 * 导出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;
}

Example 8

Source File: JeecgDemoExcelController.java From jeecg with Apache License 2.0

5 votes

/**
 * 导出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;
}

Example 9

Source File: JformOrderMainController.java From jeecg with Apache License 2.0

5 votes

/**
* 导出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;
}

Example 10

Source File: OrganzationController.java From jeecg with Apache License 2.0

5 votes

/**
 * 导出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;
}

Example 11

Source File: OrganzationController.java From jeecg with Apache License 2.0

5 votes

/**
 * 导出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;
}

Example 12

Source File: SuperQueryMainController.java From jeecg with Apache License 2.0

5 votes

/**
* 导出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;
}

Example 13

Source File: UserController.java From jeecg with Apache License 2.0

5 votes

/**
 * 导出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;
}

Example 14

Source File: TsBlackListController.java From jeecg with Apache License 2.0

5 votes

/**
 * 导出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;
}

Example 15

Source File: MultiUploadController.java From jeecg with Apache License 2.0

5 votes

/**
 * 导出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;
}

Example 16

Source File: TSFillRuleController.java From jeecg with Apache License 2.0

5 votes

/**
 * 导出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;
}

Example 17

Source File: TSFillRuleController.java From jeecg with Apache License 2.0

5 votes

/**
 * 导出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;
}

Example 18

Source File: TSCompanyPositionController.java From jeecg with Apache License 2.0

5 votes

/**
 * 导出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;
}

Example 19

Source File: JfromOrderController.java From jeecg with Apache License 2.0

5 votes

/**
* 导出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;
}

Example 20

Source File: CgformTemplateController.java From jeecg with Apache License 2.0

5 votes

/**
 * 导出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;
}