package com.jeeplus.modules.sign.web;
|
|
import java.text.ParseException;
|
import java.text.SimpleDateFormat;
|
import java.util.Date;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.UUID;
|
|
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.scheduling.annotation.Scheduled;
|
import org.springframework.stereotype.Controller;
|
import org.springframework.ui.Model;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RequestMethod;
|
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.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.sys.utils.DictUtils;
|
|
@Controller
|
@RequestMapping(value = "${adminPath}/sign/sign")
|
public class SignController extends BaseController {
|
|
@Autowired
|
private FormSignService formSignService;
|
|
|
public static final Map<String,String> ORDER_BY_MAP=new HashMap<String,String>(){{
|
put("cardId ASC", " card_id ASC ");
|
put("userName ASC", " user_name ASC ");
|
put("userSex ASC", " user_sex ASC ");
|
put("userDuty ASC", " user_duty ASC ");
|
put("depId ASC", " dep_id ASC");
|
put("signType ASC", " signType ASC ");
|
put("signCount ASC", " signCount ASC "); //
|
put("cardId DESC", " card_id DESC ");
|
put("userName DESC", " user_name DESC ");
|
put("userSex DESC", " user_sex DESC ");
|
put("userDuty DESC", " user_duty DESC ");
|
put("depId DESC", " dep_id DESC");
|
put("signType DESC", " signType DESC ");
|
put("signCount DESC", " signCount DESC ");
|
}};
|
|
|
@RequiresPermissions("sign:sign:signList")
|
@RequestMapping(value = {"signList", ""})
|
public String signList(FormSign formSign, HttpServletRequest request, HttpServletResponse response, Model model) throws ParseException {
|
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
|
|
if(null == formSign.getSignTime()){
|
formSign.setSignTime(new Date());
|
formSign.setEndTime(sdf.format(formSign.getSignTime()));
|
formSign.setSignTimeRang("0");
|
}
|
|
if( null!= formSign.getSignType() && formSign.getSignType().equals("-1")){
|
System.out.println("--------------------------- 查询未签到数据！");
|
}
|
if(null== formSign.getSignType()){
|
formSign.setSignType("0");
|
}
|
String orderBy=request.getParameter("orderBy");
|
if(ORDER_BY_MAP.containsKey(orderBy)){
|
formSign.setOrderByStr(ORDER_BY_MAP.get(orderBy));
|
}
|
// System.out.println("orderby = "+ orderBy);
|
Page<FormSign> page = formSignService.findSignListPage(new Page<FormSign>(request, response), formSign);
|
if(ORDER_BY_MAP.containsKey(orderBy)){
|
page.setOrderBy(orderBy);
|
}
|
model.addAttribute("page", page);
|
|
return "modules/signList/formSignList";
|
|
}
|
|
@RequiresPermissions(value={"sign:sign:view","sign:sign:add","sign:sign:edit"},logical=Logical.OR)
|
@RequestMapping(value = "detail")
|
public String detail(HttpServletRequest request, HttpServletResponse response, Model model) {
|
String start =request.getParameter("start");
|
String end =request.getParameter("end");
|
String signType =request.getParameter("signType");
|
String uid =request.getParameter("uid");
|
|
// model.addAttribute("formSign", formSign);
|
Map<String, Object> map = new HashMap<String, Object>();
|
map.put("uid", uid);
|
map.put("start", start);
|
map.put("end", end);
|
map.put("signType", signType);
|
|
List<FormSign> detaillist = formSignService.findDetaillist(map);
|
model.addAttribute("detaillist", detaillist);
|
return "modules/signList/formSignDetail";
|
}
|
|
@RequiresPermissions(value={"sign:sign:view","sign:sign:add","sign:sign:edit"},logical=Logical.OR)
|
@RequestMapping(value = "repair")
|
public String repair( HttpServletRequest request, Model model) {
|
String signType = request.getParameter("signType");
|
String id = request.getParameter("id");
|
FormSign formSign = null;
|
if("7".equals(signType) || "8".equals(signType)){
|
formSign= new FormSign();
|
formSign.setId( UUID.randomUUID().toString() );
|
formSign.setSignTime(new Date());
|
formSign.setSignUserID(id);
|
formSign.setSignType("5");
|
}else{
|
formSign= formSignService.get(id);
|
}
|
model.addAttribute("formSign", formSign);
|
return "modules/signList/repairSign";
|
}
|
|
|
@RequiresPermissions(value={"sign:sign:add","sign:sign:edit"},logical=Logical.OR)
|
@RequestMapping(value = "save")
|
public String save(FormSign formSign, Model model,HttpServletRequest request, HttpServletResponse response, RedirectAttributes redirectAttributes) throws Exception{
|
if (!beanValidator(model, formSign)){
|
return signList(formSign, request, response, model); //(formSign,request,response, model);
|
}
|
if(!formSign.getIsNewRecord()){//编辑表单保存
|
FormSign t = formSignService.get(formSign.getId());//从数据库取出记录的值
|
MyBeanUtils.copyBeanNotNull2Bean(formSign, t);//将编辑表单中的非NULL值覆盖数据库记录中的值
|
formSignService.save(t);//保存
|
}else{//新增表单保存
|
formSignService.save(formSign);//保存
|
}
|
addMessage(redirectAttributes, "保存签到成功成功");
|
// model.addAttribute("formSign", formSign);
|
// return "modules/signList/repairSign";
|
return "redirect:"+Global.getAdminPath()+"/sign/sign/?repage";
|
|
}
|
|
|
|
|
/*
|
@Scheduled(cron = "0 10 10 * * ?")
|
public void task (){
|
|
Date now = new Date();
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
|
List<String> list = formSignService.findCardList( ) ;
|
|
if(null!=list){
|
for (String uid : list) {
|
for (int i = 0; i < 2; i++) {
|
Map<String, Object> map = new HashMap<String,Object>();
|
map.put("signCardId", uid);
|
map.put("signTime", now);
|
map.put("signType", i+1);
|
formSignService.insertSign( map );
|
}
|
}
|
}
|
|
System.out.println("定时任务完成！----------------------------");
|
}
|
*/
|
/**
|
* 导出excel文件
|
*/
|
@RequiresPermissions("sign:sign: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<FormSign> page = formSignService.findPage(new Page<FormSign>(request, response, -1), formSign);
|
Page<FormSign> page = formSignService.findSignListPage(new Page<FormSign>(request, response,-1), formSign);
|
//Sign里的deptid 转换成dictType 显示在excel中
|
DictUtils.setSignDictType(page.getList());
|
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:sign: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<FormSign> 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";
|
}
|
|
|
|
|
}
|
