/** * Copyright © 2015-2020 JeePlus All rights reserved. */ package com.jeeplus.modules.sign.web; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.shiro.authz.annotation.Logical; import org.apache.shiro.authz.annotation.RequiresPermissions; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.ModelAttribute; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.multipart.MultipartFile; import org.springframework.web.servlet.mvc.support.RedirectAttributes; import com.google.common.collect.Lists; import com.jeeplus.common.config.Global; import com.jeeplus.common.persistence.Page; import com.jeeplus.common.utils.DateUtils; import com.jeeplus.common.utils.MyBeanUtils; import com.jeeplus.common.utils.StringUtils; import com.jeeplus.common.utils.excel.ExportExcel; import com.jeeplus.common.utils.excel.ImportExcel; import com.jeeplus.common.web.BaseController; import com.jeeplus.modules.sign.entity.FormSign; import com.jeeplus.modules.sign.service.FormSignService; import com.jeeplus.modules.sportsign.service.SportSignService; /** * 签到Controller * @author jinlong * @version 2016-04-19 */ @Controller @RequestMapping(value = "${adminPath}/sign/formSign") public class FormSignController extends BaseController { @Autowired private FormSignService formSignService; @Autowired private SportSignService sportSignService; @ModelAttribute public FormSign get(@RequestParam(required=false) String id) { FormSign entity = null; if (StringUtils.isNotBlank(id)){ entity = formSignService.get(id); } if (entity == null){ entity = new FormSign(); } return entity; } /** * 签到成功列表页面 * @throws ParseException */ @RequiresPermissions("sign:formSign:list") @RequestMapping(value = {"list", ""}) public String list(FormSign formSign, HttpServletRequest request, HttpServletResponse response, Model model) throws ParseException { String aa=request.getParameter("signTime"); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); // DateFormat d1 = DateFormat.getDateInstance(); //默认语言(汉语)下的默认风格(MEDIUM风格,比如:2008-6-16 20:54:53) Date date=new Date(); Date datenow=date; if(aa!=null) { datenow = sdf.parse(aa); } formSign.setSignTime(datenow); System.out.println(formSign.getSignTime()+"-------------------------------------"); String bb=request.getParameter("signTimeRang"); if(bb==null) formSign.setSignTimeRang("0"); String signtype=request.getParameter("signType"); if(signtype==null) formSign.setSignType("1"); Page page = formSignService.findPage(new Page(request, response), formSign); model.addAttribute("page", page); System.out.println("signTime----"+aa+"-------------------------------------"); System.out.println("signTimeRang-----"+bb+"-------------------------------------"); String cc=request.getParameter("UserDepIDList"); //System.out.println("UserDepIDList----"+request.getParameterValues("UserDepIDList").toString()+"-------------------------------------"); String dd=request.getParameter("signUserID"); System.out.println("SignUserID----"+dd+"-------------------------------------"); String ee=request.getParameter("userName"); System.out.println("userName----"+ee+"-------------------------------------"); //if(cc==null) // formSign.setUserDepIDList(new String[]{"0"}); return "modules/sign/formSignList"; } /** * 查看,增加,编辑签到成功表单页面 */ @RequiresPermissions(value={"sign:formSign:view","sign:formSign:add","sign:formSign:edit"},logical=Logical.OR) @RequestMapping(value = "form") public String form(FormSign formSign, Model model) { model.addAttribute("formSign", formSign); return "modules/sign/formSignForm"; } /** * 保存签到成功 */ @RequiresPermissions(value={"sign:formSign:add","sign:formSign:edit"},logical=Logical.OR) @RequestMapping(value = "save") public String save(FormSign formSign, Model model, RedirectAttributes redirectAttributes) throws Exception{ if (!beanValidator(model, formSign)){ return form(formSign, model); } if(!formSign.getIsNewRecord()){//编辑表单保存 FormSign t = formSignService.get(formSign.getId());//从数据库取出记录的值 MyBeanUtils.copyBeanNotNull2Bean(formSign, t);//将编辑表单中的非NULL值覆盖数据库记录中的值 formSignService.save(t);//保存 }else{//新增表单保存 formSignService.save(formSign);//保存 } addMessage(redirectAttributes, "保存签到成功成功"); return "redirect:"+Global.getAdminPath()+"/sign/formSign/?repage"; } /** * 删除签到成功 */ @RequiresPermissions("sign:formSign:del") @RequestMapping(value = "delete") public String delete(FormSign formSign, RedirectAttributes redirectAttributes) { formSignService.delete(formSign); addMessage(redirectAttributes, "删除签到成功成功"); return "redirect:"+Global.getAdminPath()+"/sign/formSign/?repage"; } /** * 批量删除签到成功 */ @RequiresPermissions("sign:formSign:del") @RequestMapping(value = "deleteAll") public String deleteAll(String ids, RedirectAttributes redirectAttributes) { String idArray[] =ids.split(","); for(String id : idArray){ formSignService.delete(formSignService.get(id)); } addMessage(redirectAttributes, "删除签到成功成功"); return "redirect:"+Global.getAdminPath()+"/sign/formSign/?repage"; } /** * 导出excel文件 */ @RequiresPermissions("sign:formSign:export") @RequestMapping(value = "export", method=RequestMethod.POST) public String exportFile(FormSign formSign, HttpServletRequest request, HttpServletResponse response, RedirectAttributes redirectAttributes) { try { String fileName = "签到成功"+DateUtils.getDate("yyyyMMddHHmmss")+".xlsx"; Page page = formSignService.findPage(new Page(request, response, -1), formSign); new ExportExcel("签到成功", FormSign.class).setDataList(page.getList()).write(response, fileName).dispose(); return null; } catch (Exception e) { addMessage(redirectAttributes, "导出签到成功记录失败!失败信息:"+e.getMessage()); } return "redirect:"+Global.getAdminPath()+"/sign/formSign/?repage"; } /** * 导入Excel数据 */ @RequiresPermissions("sign:formSign:import") @RequestMapping(value = "import", method=RequestMethod.POST) public String importFile(MultipartFile file, RedirectAttributes redirectAttributes) { try { int successNum = 0; ImportExcel ei = new ImportExcel(file, 1, 0); List list = ei.getDataList(FormSign.class); for (FormSign formSign : list){ formSignService.save(formSign); } addMessage(redirectAttributes, "已成功导入 "+successNum+" 条签到成功记录"); } catch (Exception e) { addMessage(redirectAttributes, "导入签到成功失败!失败信息:"+e.getMessage()); } return "redirect:"+Global.getAdminPath()+"/sign/formSign/?repage"; } /** * 下载导入签到成功数据模板 */ @RequiresPermissions("sign:formSign:import") @RequestMapping(value = "import/template") public String importFileTemplate(HttpServletResponse response, RedirectAttributes redirectAttributes) { try { String fileName = "签到成功数据导入模板.xlsx"; List list = Lists.newArrayList(); new ExportExcel("签到成功数据", FormSign.class, 1).setDataList(list).write(response, fileName).dispose(); return null; } catch (Exception e) { addMessage(redirectAttributes, "导入模板下载失败!失败信息:"+e.getMessage()); } return "redirect:"+Global.getAdminPath()+"/sign/formSign/?repage"; } }