提交 | 用户 | age
|
a6a76f
|
1 |
package com.yc.action.grid; |
F |
2 |
|
|
3 |
import java.io.BufferedInputStream; |
|
4 |
import java.io.FileInputStream; |
|
5 |
import java.io.FileOutputStream; |
|
6 |
import java.io.IOException; |
|
7 |
import java.io.InputStream; |
|
8 |
import java.io.OutputStream; |
|
9 |
import java.util.Enumeration; |
|
10 |
import java.util.List; |
|
11 |
import java.util.Map; |
|
12 |
import java.util.Properties; |
|
13 |
|
|
14 |
import javax.servlet.http.HttpServletRequest; |
|
15 |
import javax.servlet.http.HttpServletResponse; |
|
16 |
import javax.servlet.http.HttpSession; |
|
17 |
|
|
18 |
import org.springframework.context.annotation.Scope; |
|
19 |
import org.springframework.dao.DataAccessException; |
|
20 |
import org.springframework.dao.EmptyResultDataAccessException; |
|
21 |
import org.springframework.stereotype.Controller; |
|
22 |
import org.springframework.ui.Model; |
|
23 |
import org.springframework.ui.ModelMap; |
|
24 |
import org.springframework.web.bind.annotation.RequestMapping; |
|
25 |
import org.springframework.web.servlet.ModelAndView; |
|
26 |
|
|
27 |
import com.google.gson.Gson; |
|
28 |
import com.yc.entity._sys_AttendanceReport; |
|
29 |
import com.yc.factory.FactoryBean; |
|
30 |
import com.yc.multiData.SpObserver; |
|
31 |
import com.yc.service.BaseService; |
|
32 |
import com.yc.utils.IPUtil; |
|
33 |
import com.yc.utils.SessionKey; |
|
34 |
import com.yc.utils.ThreeJSON; |
|
35 |
|
|
36 |
|
|
37 |
/*** |
|
38 |
* 考勤加卡 |
|
39 |
* |
|
40 |
**/ |
|
41 |
@SuppressWarnings("all") |
|
42 |
@Controller("attendanceReport") |
|
43 |
@Scope("prototype") |
|
44 |
@RequestMapping("/attend.do") |
|
45 |
public class AttendanceReport extends com.yc.action.BaseAction { |
|
46 |
|
|
47 |
|
|
48 |
@RequestMapping(params = "m=save") |
|
49 |
public void save(HttpServletRequest request, HttpServletResponse resp,int t,int u,String fl) { |
|
50 |
BaseService based = (BaseService) FactoryBean.getBean("BaseService"); |
|
51 |
try{ |
|
52 |
String fild="startdate"; |
|
53 |
if(t==2) fild="enddate"; |
|
54 |
String d= com.yc.utils.DateUtil.toDay(); |
|
55 |
if(u==0){//新增 |
|
56 |
|
|
57 |
String sql="insert into _sys_AttendanceReport(usercode,username,StartIPAddr,startdate,StartBrowseAgent,today) values(?,?,?,?,?,?)"; |
|
58 |
if(t==2) |
|
59 |
sql="insert into _sys_AttendanceReport(usercode,username,EndIPAddr,enddate,EndBrowseAgent,today) values(?,?,?,?,?,?)"; |
|
60 |
int num=0; |
|
61 |
try{ |
|
62 |
SpObserver.setDBtoInstance("_"+request.getSession().getAttribute(SessionKey.DATA_BASE_ID)); |
|
63 |
num=based.getJdbcTemplate().update(sql, |
|
64 |
request.getSession().getAttribute(SessionKey.USERCODE), |
|
65 |
request.getSession().getAttribute(SessionKey.USER_NAME), |
|
66 |
IPUtil.getIpAddr(request),d,request.getHeader("user-agent"), |
|
67 |
com.yc.utils.DateUtil.toDayDate()); |
|
68 |
}finally{ |
|
69 |
SpObserver.setDBtoInstance(); |
|
70 |
} |
|
71 |
this.printJson(resp, d); |
|
72 |
}else{//修改 |
|
73 |
|
|
74 |
String sql="update _sys_AttendanceReport set startdate=?, StartIPAddr=?,StartBrowseAgent=? where usercode=? and today=?"; |
|
75 |
if(t==2){ |
|
76 |
sql="update _sys_AttendanceReport set enddate=?,EndIPAddr=?,EndBrowseAgent=? where usercode=? and today=?"; |
|
77 |
|
|
78 |
} |
|
79 |
int num=0; |
|
80 |
try{ |
|
81 |
SpObserver.setDBtoInstance("_"+request.getSession().getAttribute(SessionKey.DATA_BASE_ID)); |
|
82 |
num=based.getJdbcTemplate(). |
|
83 |
update(sql, |
|
84 |
d,IPUtil.getIpAddr(request),request.getHeader("user-agent"),request.getSession().getAttribute(SessionKey.USERCODE),com.yc.utils.DateUtil.toDayDate()); |
|
85 |
}finally{ |
|
86 |
SpObserver.setDBtoInstance(); |
|
87 |
} |
|
88 |
this.printJson(resp, d); |
|
89 |
} |
|
90 |
}catch(Exception e){ |
|
91 |
this.printJson(resp, "error;"+e.getMessage()); |
|
92 |
} |
|
93 |
} |
|
94 |
@RequestMapping(params = "m=load") |
|
95 |
public ModelAndView load(HttpServletRequest request, HttpServletResponse resp, ModelMap model) { |
|
96 |
try{ |
|
97 |
BaseService based = (BaseService) FactoryBean.getBean("BaseService"); |
|
98 |
|
|
99 |
HttpSession session=request.getSession(); |
|
100 |
Map<String,Object> map =null; |
|
101 |
|
|
102 |
try{ |
|
103 |
SpObserver.setDBtoInstance("_"+request.getSession().getAttribute(SessionKey.DATA_BASE_ID)); |
|
104 |
map=based.getJdbcTemplate().queryForMap("select * from _sys_AttendanceReport where usercode=? and ((datediff(d,startdate,?)=0 or datediff(d,EndDate,?)=0))", |
|
105 |
session.getAttribute(com.yc.utils.SessionKey.USERCODE),com.yc.utils.DateUtil.toDayDate(),com.yc.utils.DateUtil.toDayDate()); |
|
106 |
}finally{ |
|
107 |
SpObserver.setDBtoInstance(); |
|
108 |
} |
|
109 |
model.addAttribute("list",map); |
|
110 |
return new ModelAndView("/general/attendance",model); |
|
111 |
}catch(EmptyResultDataAccessException e1){ |
|
112 |
|
|
113 |
return new ModelAndView("/general/attendance"); |
|
114 |
} |
|
115 |
catch(Exception e){ |
|
116 |
return new ModelAndView("/general/attendance","error",e.getMessage()); |
|
117 |
} |
|
118 |
|
|
119 |
} |
|
120 |
|
|
121 |
} |