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> 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> 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 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 otherAttr = new HashMap(); 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> fileList = systemService.findForJdbc(fileSql, user.getId()); return fileList; } }