meidu2021/daju/target/classes/cn/com/lzt/personalfile/controller/PersonalFileController.java

package cn.com.lzt.personalfile.controller;

import java.util.HashMap;
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.model.json.DataGrid;
import org.jeecgframework.core.util.ResourceUtil;
import org.jeecgframework.minidao.pojo.MiniDaoPage;
import org.jeecgframework.tag.core.easyui.TagUtil;
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.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;

import cn.com.lzt.common.entity.TSysFileEntity;
import cn.com.lzt.personalfile.dao.PersonalfileDao;

/**
 * 个人附件
 * */
@Controller
@RequestMapping("/PersonalFileController")
public class PersonalFileController extends BaseController{
	// 下载路径
	private static final String showAndDownUrl = ResourceUtil.getConfigByName("showAndDownUrl");
	@Autowired
	private SystemService systemService;
	
	@Autowired
	private PersonalfileDao filedao;
	
	
	@RequestMapping(params = "main")
	public ModelAndView list(HttpServletRequest request) {
		TSUser user = ResourceUtil.getSessionUser();
		String fileSql = "select count(*) as count from t_b_personalImage where userid = ?";
		List<Map<String,Object>> fileList = systemService.findForJdbc(fileSql, user.getId());
		request.setAttribute("total", fileList.get(0).get("count"));
		return new ModelAndView("cn/com/lzt/personalfile/personalfilehome");
	}
	@RequestMapping(params = "main-2")
	public ModelAndView list2(HttpServletRequest request) {
		TSUser user = ResourceUtil.getSessionUser();
		String fileSql = "select count(*) as count from t_b_personalImage where userid = ?";
		List<Map<String,Object>> fileList = systemService.findForJdbc(fileSql, user.getId());
		request.setAttribute("total", fileList.get(0).get("count"));
		return new ModelAndView("cn/com/lzt/personalfile/personalfilehome2");
	}
	
	@RequestMapping(params = "personalfilemessage")
	public ModelAndView personalfilemessage(HttpServletRequest request) {
		request.setAttribute("showAndDownUrl", showAndDownUrl);
		return new ModelAndView("cn/com/lzt/personalfile/personalfile-message");
	}
	@RequestMapping(params = "datagridmessage")
	public void datagridmessage(String fileName, HttpServletRequest request, HttpServletResponse response,
			DataGrid dataGrid) {
		MiniDaoPage<TSysFileEntity> page = filedao.messagefileList(ResourceUtil.getSessionUser().getId(), 
				fileName, dataGrid.getPage(), dataGrid.getRows());
		// 设置是否预览Flg
		for (int i = 0; i < page.getResults().size(); i++) {
			TSysFileEntity tSysFileEntity = page.getResults().get(i);
			String name = tSysFileEntity.getFileName();
			String fileType = name.substring(name.lastIndexOf(".") + 1);
			if ("jpg".equals(fileType) || "png".equals(fileType) || "pdf".equals(fileType)) {
				tSysFileEntity.setIsPreviewFlg("1");
			} else {
				tSysFileEntity.setIsPreviewFlg("0");
			}
		}
		dataGrid.setResults(page.getResults());
		dataGrid.setTotal(page.getTotal());
		Map<String,Object> otherAttr = new HashMap<String,Object>();
		otherAttr.put("showAndDownUrl", showAndDownUrl);
		dataGrid.setObj(otherAttr);
		TagUtil.datagrid(response, dataGrid);
	}
	@SuppressWarnings({ "unchecked", "rawtypes" })
	@RequestMapping(params = "getimagelist", method = RequestMethod.POST)
	@ResponseBody
	public Object getimagelist(int rows,int page) {
		String fileSql = "select id,accUrl,createtime from t_b_personalImage where userid = ?";
		TSUser user = ResourceUtil.getSessionUser();
		List<Map<String,Object>> fileList = systemService.findForJdbc(fileSql, user.getId());
		return fileList;
	}

}