liuxiaolong
2019-05-09 0d1d88cdb668e75ea8609417ac18ae19947e9525
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
/**
 * Copyright &copy; 2015-2020 <a href="http://www.jeeplus.org/">JeePlus</a> All rights reserved.
 */
package com.jeeplus.modules.test.web.one;
 
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.utils.DateUtils;
import com.jeeplus.common.utils.MyBeanUtils;
import com.jeeplus.common.config.Global;
import com.jeeplus.common.persistence.Page;
import com.jeeplus.common.web.BaseController;
import com.jeeplus.common.utils.StringUtils;
import com.jeeplus.common.utils.excel.ExportExcel;
import com.jeeplus.common.utils.excel.ImportExcel;
import com.jeeplus.modules.test.entity.one.FormLeave;
import com.jeeplus.modules.test.service.one.FormLeaveService;
 
/**
 * 请假单Controller
 * @author lgf
 * @version 2016-03-13
 */
@Controller
@RequestMapping(value = "${adminPath}/test/one/formLeave")
public class FormLeaveController extends BaseController {
 
    @Autowired
    private FormLeaveService formLeaveService;
    
    @ModelAttribute
    public FormLeave get(@RequestParam(required=false) String id) {
        FormLeave entity = null;
        if (StringUtils.isNotBlank(id)){
            entity = formLeaveService.get(id);
        }
        if (entity == null){
            entity = new FormLeave();
        }
        return entity;
    }
    
    /**
     * 请假单列表页面
     */
    @RequiresPermissions("test:one:formLeave:list")
    @RequestMapping(value = {"list", ""})
    public String list(FormLeave formLeave, HttpServletRequest request, HttpServletResponse response, Model model) {
        Page<FormLeave> page = formLeaveService.findPage(new Page<FormLeave>(request, response), formLeave); 
        model.addAttribute("page", page);
        return "modules/test/one/formLeaveList";
    }
 
    /**
     * 查看,增加,编辑请假单表单页面
     */
    @RequiresPermissions(value={"test:one:formLeave:view","test:one:formLeave:add","test:one:formLeave:edit"},logical=Logical.OR)
    @RequestMapping(value = "form")
    public String form(FormLeave formLeave, Model model) {
        model.addAttribute("formLeave", formLeave);
        return "modules/test/one/formLeaveForm";
    }
 
    /**
     * 保存请假单
     */
    @RequiresPermissions(value={"test:one:formLeave:add","test:one:formLeave:edit"},logical=Logical.OR)
    @RequestMapping(value = "save")
    public String save(FormLeave formLeave, Model model, RedirectAttributes redirectAttributes) throws Exception{
        if (!beanValidator(model, formLeave)){
            return form(formLeave, model);
        }
        if(!formLeave.getIsNewRecord()){//编辑表单保存
            FormLeave t = formLeaveService.get(formLeave.getId());//从数据库取出记录的值
            MyBeanUtils.copyBeanNotNull2Bean(formLeave, t);//将编辑表单中的非NULL值覆盖数据库记录中的值
            formLeaveService.save(t);//保存
        }else{//新增表单保存
            formLeaveService.save(formLeave);//保存
        }
        addMessage(redirectAttributes, "保存请假单成功");
        return "redirect:"+Global.getAdminPath()+"/test/one/formLeave/?repage";
    }
    
    /**
     * 删除请假单
     */
    @RequiresPermissions("test:one:formLeave:del")
    @RequestMapping(value = "delete")
    public String delete(FormLeave formLeave, RedirectAttributes redirectAttributes) {
        formLeaveService.delete(formLeave);
        addMessage(redirectAttributes, "删除请假单成功");
        return "redirect:"+Global.getAdminPath()+"/test/one/formLeave/?repage";
    }
    
    /**
     * 批量删除请假单
     */
    @RequiresPermissions("test:one:formLeave:del")
    @RequestMapping(value = "deleteAll")
    public String deleteAll(String ids, RedirectAttributes redirectAttributes) {
        String idArray[] =ids.split(",");
        for(String id : idArray){
            formLeaveService.delete(formLeaveService.get(id));
        }
        addMessage(redirectAttributes, "删除请假单成功");
        return "redirect:"+Global.getAdminPath()+"/test/one/formLeave/?repage";
    }
    
    /**
     * 导出excel文件
     */
    @RequiresPermissions("test:one:formLeave:export")
    @RequestMapping(value = "export", method=RequestMethod.POST)
    public String exportFile(FormLeave formLeave, HttpServletRequest request, HttpServletResponse response, RedirectAttributes redirectAttributes) {
        try {
            String fileName = "请假单"+DateUtils.getDate("yyyyMMddHHmmss")+".xlsx";
            Page<FormLeave> page = formLeaveService.findPage(new Page<FormLeave>(request, response, -1), formLeave);
            new ExportExcel("请假单", FormLeave.class).setDataList(page.getList()).write(response, fileName).dispose();
            return null;
        } catch (Exception e) {
            addMessage(redirectAttributes, "导出请假单记录失败!失败信息:"+e.getMessage());
        }
        return "redirect:"+Global.getAdminPath()+"/test/one/formLeave/?repage";
    }
 
    /**
     * 导入Excel数据
 
     */
    @RequiresPermissions("test:one:formLeave: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<FormLeave> list = ei.getDataList(FormLeave.class);
            for (FormLeave formLeave : list){
                formLeaveService.save(formLeave);
            }
            addMessage(redirectAttributes, "已成功导入 "+successNum+" 条请假单记录");
        } catch (Exception e) {
            addMessage(redirectAttributes, "导入请假单失败!失败信息:"+e.getMessage());
        }
        return "redirect:"+Global.getAdminPath()+"/test/one/formLeave/?repage";
    }
    
    /**
     * 下载导入请假单数据模板
     */
    @RequiresPermissions("test:one:formLeave:import")
    @RequestMapping(value = "import/template")
    public String importFileTemplate(HttpServletResponse response, RedirectAttributes redirectAttributes) {
        try {
            String fileName = "请假单数据导入模板.xlsx";
            List<FormLeave> list = Lists.newArrayList(); 
            new ExportExcel("请假单数据", FormLeave.class, 1).setDataList(list).write(response, fileName).dispose();
            return null;
        } catch (Exception e) {
            addMessage(redirectAttributes, "导入模板下载失败!失败信息:"+e.getMessage());
        }
        return "redirect:"+Global.getAdminPath()+"/test/one/formLeave/?repage";
    }
    
 
}