Blame view

src/com/fh/controller/sunvote/homework/HomeworkController.java 41.1 KB
be2f84a1   孙向锦   添加课后作业基础模块数据
1
2
3
4
5
6
  package com.fh.controller.sunvote.homework;
  
  import java.io.PrintWriter;
  import java.text.DateFormat;
  import java.text.SimpleDateFormat;
  import java.util.ArrayList;
6dd8580c   孙向锦   修改报表数据
7
  import java.util.Calendar;
a764d288   孙向锦   修改课后练bug
8
9
  import java.util.Collections;
  import java.util.Comparator;
be2f84a1   孙向锦   添加课后作业基础模块数据
10
11
12
13
  import java.util.Date;
  import java.util.HashMap;
  import java.util.List;
  import java.util.Map;
a479f295   孙向锦   添加了报表逻辑
14
  
be2f84a1   孙向锦   添加课后作业基础模块数据
15
  import javax.annotation.Resource;
a479f295   孙向锦   添加了报表逻辑
16
  
be2f84a1   孙向锦   添加课后作业基础模块数据
17
18
  import org.springframework.beans.propertyeditors.CustomDateEditor;
  import org.springframework.stereotype.Controller;
f7e4dd61   孙向锦   根据客户UI的需求进行修改
19
  import org.springframework.util.StringUtils;
be2f84a1   孙向锦   添加课后作业基础模块数据
20
21
22
23
24
  import org.springframework.web.bind.WebDataBinder;
  import org.springframework.web.bind.annotation.InitBinder;
  import org.springframework.web.bind.annotation.RequestMapping;
  import org.springframework.web.bind.annotation.ResponseBody;
  import org.springframework.web.servlet.ModelAndView;
a479f295   孙向锦   添加了报表逻辑
25
  
5162dcee   孙向锦   添加上传作业接口
26
27
28
  import com.fh.bean.HomeClass;
  import com.fh.bean.Homework;
  import com.fh.bean.HomeworkQuestion;
2514d928   孙向锦   添加课后作ye,API
29
  import com.fh.controller.api.ResponseGson;
be2f84a1   孙向锦   添加课后作业基础模块数据
30
31
  import com.fh.controller.base.BaseController;
  import com.fh.entity.Page;
fcd1fe57   孙向锦   报表数据
32
  import com.fh.service.sunvote.coursemanagement.CourseManagementManager;
a479f295   孙向锦   添加了报表逻辑
33
34
  import com.fh.service.sunvote.homework.HomeworkManager;
  import com.fh.service.sunvote.homework.HomeworkReportManager;
5162dcee   孙向锦   添加上传作业接口
35
  import com.fh.service.sunvote.homeworkproblem.HomeworkProblemManager;
68056c63   孙向锦   添加学生人数
36
  import com.fh.service.sunvote.student.StudentManager;
b3c44d84   孙向锦   课后练bug修复
37
38
  import com.fh.service.sunvote.teacher.TeacherManager;
  import com.fh.service.sunvote.teacher.impl.TeacherService;
be2f84a1   孙向锦   添加课后作业基础模块数据
39
  import com.fh.util.AppUtil;
a479f295   孙向锦   添加了报表逻辑
40
  import com.fh.util.Jurisdiction;
be2f84a1   孙向锦   添加课后作业基础模块数据
41
42
  import com.fh.util.ObjectExcelView;
  import com.fh.util.PageData;
f7e4dd61   孙向锦   根据客户UI的需求进行修改
43
  import com.fh.util.StringUtil;
a479f295   孙向锦   添加了报表逻辑
44
  import com.google.gson.Gson;
be2f84a1   孙向锦   添加课后作业基础模块数据
45
  
a479f295   孙向锦   添加了报表逻辑
46
  /**
6de2192e   孙向锦   答案统计
47
48
   * 说明:作业 创建人:FH Q313596790 
   * 创建时间:2019-03-07
be2f84a1   孙向锦   添加课后作业基础模块数据
49
50
   */
  @Controller
a479f295   孙向锦   添加了报表逻辑
51
  @RequestMapping(value = "/homework")
be2f84a1   孙向锦   添加课后作业基础模块数据
52
  public class HomeworkController extends BaseController {
a479f295   孙向锦   添加了报表逻辑
53
54
55
  
  	String menuUrl = "homework/list.do"; // 菜单地址(权限用)
  	@Resource(name = "homeworkService")
be2f84a1   孙向锦   添加课后作业基础模块数据
56
  	private HomeworkManager homeworkService;
a479f295   孙向锦   添加了报表逻辑
57
58
  	@Resource(name = "homeworkReporService")
  	private HomeworkReportManager homeworkReporService;
02c4ed52   孙向锦   更新上传作业接口
59
60
  
  	@Resource(name = "homeworkproblemService")
5162dcee   孙向锦   添加上传作业接口
61
  	private HomeworkProblemManager homeworkproblemService;
fcd1fe57   孙向锦   报表数据
62
63
64
65
66
67
  	
  	@Resource(name="coursemanagementService")
  	private CourseManagementManager coursemanagementService;
  	
  	@Resource(name="homeworkReporService")
  	private HomeworkReportManager homeworkReporkService;
68056c63   孙向锦   添加学生人数
68
69
70
  	
  	@Resource(name="studentService")
  	private StudentManager studentService;
b3c44d84   孙向锦   课后练bug修复
71
72
73
  	
  	@Resource(name = "teacherService")
  	private TeacherManager teacherService;
a479f295   孙向锦   添加了报表逻辑
74
75
76
77
  
  	/**
  	 * 保存
  	 * 
be2f84a1   孙向锦   添加课后作业基础模块数据
78
79
80
  	 * @param
  	 * @throws Exception
  	 */
a479f295   孙向锦   添加了报表逻辑
81
82
83
  	@RequestMapping(value = "/save")
  	public ModelAndView save() throws Exception {
  		logBefore(logger, Jurisdiction.getUsername() + "新增Homework");
be2f84a1   孙向锦   添加课后作业基础模块数据
84
85
86
  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		pd = this.getPageData();
a479f295   孙向锦   添加了报表逻辑
87
  		pd.put("HOMEWORK_ID", this.get32UUID()); // 主键
be2f84a1   孙向锦   添加课后作业基础模块数据
88
  		homeworkService.save(pd);
a479f295   孙向锦   添加了报表逻辑
89
  		mv.addObject("msg", "success");
be2f84a1   孙向锦   添加课后作业基础模块数据
90
91
92
  		mv.setViewName("save_result");
  		return mv;
  	}
a479f295   孙向锦   添加了报表逻辑
93
94
95
96
  
  	/**
  	 * 删除
  	 * 
be2f84a1   孙向锦   添加课后作业基础模块数据
97
98
99
  	 * @param out
  	 * @throws Exception
  	 */
a479f295   孙向锦   添加了报表逻辑
100
101
102
  	@RequestMapping(value = "/delete")
  	public void delete(PrintWriter out) throws Exception {
  		logBefore(logger, Jurisdiction.getUsername() + "删除Homework");
be2f84a1   孙向锦   添加课后作业基础模块数据
103
104
105
106
107
108
  		PageData pd = new PageData();
  		pd = this.getPageData();
  		homeworkService.delete(pd);
  		out.write("success");
  		out.close();
  	}
a479f295   孙向锦   添加了报表逻辑
109
110
111
112
  
  	/**
  	 * 修改
  	 * 
be2f84a1   孙向锦   添加课后作业基础模块数据
113
114
115
  	 * @param
  	 * @throws Exception
  	 */
a479f295   孙向锦   添加了报表逻辑
116
117
  	@RequestMapping(value = "/edit")
  	public ModelAndView edit() throws Exception {
be2f84a1   孙向锦   添加课后作业基础模块数据
118
119
120
  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		pd = this.getPageData();
02c4ed52   孙向锦   更新上传作业接口
121
  
a479f295   孙向锦   添加了报表逻辑
122
  		mv.addObject("msg", "success");
be2f84a1   孙向锦   添加课后作业基础模块数据
123
124
125
  		mv.setViewName("save_result");
  		return mv;
  	}
a479f295   孙向锦   添加了报表逻辑
126
127
128
129
  
  	/**
  	 * 列表
  	 * 
be2f84a1   孙向锦   添加课后作业基础模块数据
130
131
132
  	 * @param page
  	 * @throws Exception
  	 */
a479f295   孙向锦   添加了报表逻辑
133
134
135
  	@RequestMapping(value = "/list")
  	public ModelAndView list(Page page) throws Exception {
  		logBefore(logger, Jurisdiction.getUsername() + "列表Homework");
be2f84a1   孙向锦   添加课后作业基础模块数据
136
137
  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
b3c44d84   孙向锦   课后练bug修复
138
  		pd = this.getPageData();
8a43805a   孙向锦   修改bug
139
  		if(pd.get("SCHOOL_ID") == null && pd.get("TEACHER_ID") == null){
91de7adc   孙向锦   添加管理员页面
140
141
  			pd.put("TEACHER_ID", getTeacherID());
  		}
a479f295   孙向锦   添加了报表逻辑
142
143
  		String keywords = pd.getString("keywords"); // 关键词检索条件
  		if (null != keywords && !"".equals(keywords)) {
be2f84a1   孙向锦   添加课后作业基础模块数据
144
145
146
  			pd.put("keywords", keywords.trim());
  		}
  		page.setPd(pd);
1ee08611   jack   1.英文翻译(2)
147
  		page.setLangIsChina(isChineseLanguageClient());
a479f295   孙向锦   添加了报表逻辑
148
  		List<PageData> varList = homeworkService.list(page); // 列出Homework列表
1ee08611   jack   1.英文翻译(2)
149
150
151
152
153
154
  		if(isChineseLanguageClient()){
  			mv.setViewName("sunvote/homework/homework_list");
  		}else{
  			mv.setViewName("sunvote/homework/en_homework_list");
  		}
  		
be2f84a1   孙向锦   添加课后作业基础模块数据
155
156
  		mv.addObject("varList", varList);
  		mv.addObject("pd", pd);
a479f295   孙向锦   添加了报表逻辑
157
  		mv.addObject("QX", Jurisdiction.getHC()); // 按钮权限
be2f84a1   孙向锦   添加课后作业基础模块数据
158
159
  		return mv;
  	}
a479f295   孙向锦   添加了报表逻辑
160
161
162
163
  
  	/**
  	 * 去新增页面
  	 * 
be2f84a1   孙向锦   添加课后作业基础模块数据
164
165
166
  	 * @param
  	 * @throws Exception
  	 */
a479f295   孙向锦   添加了报表逻辑
167
168
  	@RequestMapping(value = "/goAdd")
  	public ModelAndView goAdd() throws Exception {
be2f84a1   孙向锦   添加课后作业基础模块数据
169
170
171
172
173
174
175
  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		pd = this.getPageData();
  		mv.setViewName("sunvote/homework/homework_edit");
  		mv.addObject("msg", "save");
  		mv.addObject("pd", pd);
  		return mv;
a479f295   孙向锦   添加了报表逻辑
176
  	}
2c6bc93d   孙向锦   更新作业
177
  
85ea5817   孙向锦   布置练习更新
178
179
180
181
182
183
184
185
186
187
188
  	/**
  	 * 去新增页面
  	 * 
  	 * @param
  	 * @throws Exception
  	 */
  	@RequestMapping(value = "/goAdd2")
  	public ModelAndView goAdd2() throws Exception {
  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		pd = this.getPageData();
5b1fa3bc   孙向锦   修复bug
189
190
191
  		// 添加科目ID
  		pd.put("TEACHER_ID", getTeacherID());
  		pd.put("SUBJECT_ID", homeworkService.querySubjectId(pd));
1ee08611   jack   1.英文翻译(2)
192
193
194
195
196
  		if(isChineseLanguageClient()){
  			mv.setViewName("sunvote/homework/homework_edit2");
  		}else{
  			mv.setViewName("sunvote/homework/en_homework_edit2");
  		}
85ea5817   孙向锦   布置练习更新
197
  		mv.addObject("msg", "save");
8952fd04   孙向锦   添加浏览功能
198
  		mv.addObject("operation", "add");
85ea5817   孙向锦   布置练习更新
199
200
201
  		mv.addObject("pd", pd);
  		return mv;
  	}
a479f295   孙向锦   添加了报表逻辑
202
  
5b1fa3bc   孙向锦   修复bug
203
  	/**                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
a479f295   孙向锦   添加了报表逻辑
204
205
  	 * 去修改页面
  	 * 
be2f84a1   孙向锦   添加课后作业基础模块数据
206
207
208
  	 * @param
  	 * @throws Exception
  	 */
a479f295   孙向锦   添加了报表逻辑
209
210
  	@RequestMapping(value = "/goEdit")
  	public ModelAndView goEdit() throws Exception {
be2f84a1   孙向锦   添加课后作业基础模块数据
211
212
213
  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		pd = this.getPageData();
a479f295   孙向锦   添加了报表逻辑
214
  		pd = homeworkService.findById(pd); // 根据ID读取
be2f84a1   孙向锦   添加课后作业基础模块数据
215
216
217
218
  		mv.setViewName("sunvote/homework/homework_edit");
  		mv.addObject("msg", "edit");
  		mv.addObject("pd", pd);
  		return mv;
a479f295   孙向锦   添加了报表逻辑
219
  	}
5162dcee   孙向锦   添加上传作业接口
220
  
8fb81e72   =   1.增加练习列表页和布置练习页面
221
222
223
224
225
226
227
228
229
230
231
232
  	/**
  	 * 去修改页面
  	 * 
  	 * @param
  	 * @throws Exception
  	 */
  	@RequestMapping(value = "/goEdit2")
  	public ModelAndView goEdit2() throws Exception {
  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		pd = this.getPageData();
  		pd = homeworkService.findById(pd); // 根据ID读取
85ea5817   孙向锦   布置练习更新
233
  		pd.put("QUESTIONS", homeworkproblemService.listProblem(pd));
fcd1fe57   孙向锦   报表数据
234
  		pd.put("TEACHER_ID", getTeacherID());
1ee08611   jack   1.英文翻译(2)
235
236
237
238
239
  		if(isChineseLanguageClient()){
  			mv.setViewName("sunvote/homework/homework_edit2");
  		}else{
  			mv.setViewName("sunvote/homework/en_homework_edit2");
  		}
8fb81e72   =   1.增加练习列表页和布置练习页面
240
  		mv.addObject("msg", "edit");
8952fd04   孙向锦   添加浏览功能
241
242
243
244
245
246
  		mv.addObject("operation", "edit");
  		mv.addObject("pd", pd);
  		return mv;
  	}
  	
  	/**
892c3766   =   1、增加练习报表页面
247
  	 * 去预览页面
8952fd04   孙向锦   添加浏览功能
248
249
250
251
252
253
254
255
256
257
258
  	 * 
  	 * @param
  	 * @throws Exception
  	 */
  	@RequestMapping(value = "/goView")
  	public ModelAndView goView() throws Exception {
  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		pd = this.getPageData();
  		pd = homeworkService.findById(pd); // 根据ID读取
  		pd.put("QUESTIONS", homeworkproblemService.listProblem(pd));
fcd1fe57   孙向锦   报表数据
259
  		pd.put("TEACHER_ID", getTeacherID());
1ee08611   jack   1.英文翻译(2)
260
261
262
263
264
  		if(isChineseLanguageClient()){
  			mv.setViewName("sunvote/homework/homework_view");
  		}else{
  			mv.setViewName("sunvote/homework/en_homework_view");
  		}
8952fd04   孙向锦   添加浏览功能
265
266
  		mv.addObject("msg", "edit");
  		mv.addObject("operation", "view");
892c3766   =   1、增加练习报表页面
267
268
269
  		mv.addObject("pd", pd);
  		return mv;
  	}
94ab1e18   孙向锦   删除重复的action
270
  
a28085c0   孙向锦   修改班级编辑bug
271
  	
6dd8580c   孙向锦   修改报表数据
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
  	public static String getWeekStart(int cur){
  		SimpleDateFormat format  = new SimpleDateFormat("YYYY-MM-dd");  
  		Calendar ca = Calendar.getInstance();  
  		ca.setFirstDayOfWeek(Calendar.MONDAY);  
  		int a = ca.getFirstDayOfWeek();
  		ca.set(Calendar.DAY_OF_WEEK, a); // Sunday  
  		ca.add(Calendar.DATE, cur * 7);
  		String weekEnd = format.format(ca.getTime());  
  		return weekEnd;
  	}
  	
  	public static String getWeekEnd(int cur){
  		SimpleDateFormat format  = new SimpleDateFormat("YYYY-MM-dd");  
  		Calendar ca = Calendar.getInstance();  
  		ca.setFirstDayOfWeek(Calendar.MONDAY);  
  		int a = ca.getFirstDayOfWeek();
  		ca.set(Calendar.DAY_OF_WEEK, a+6); // Sunday  
  		ca.add(Calendar.DATE, cur * 7);
  		String weekEnd = format.format(ca.getTime());  
  		return weekEnd + " 23:59:59";
  	}
  	
a28085c0   孙向锦   修改班级编辑bug
294
295
  	
  	/**
f7e4dd61   孙向锦   根据客户UI的需求进行修改
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
  	 * 传入homework_id 
  	 * 查询该场课后练的整体情况,最高分,最低分,平均分,总分,总题数,未答人数等
  	 * 未答人数列表
  	 * @return
  	 * @throws Exception
  	 */
  	@RequestMapping(value = "/report2")
  	public ModelAndView report2() throws Exception {
  		PageData pageData = this.getPageData();
  		ModelAndView modelAndView = getModelAndView();
  		
  		String homeworkId = pageData.getString("HOMEWORK_ID");
  		if(!StringUtils.isEmpty(homeworkId.trim())){
  			pageData = homeworkService.findById(pageData);
  			List<PageData> data = homeworkReporkService.findNoAnswerByHomeworkID(pageData);
  			pageData.put("NO_COUNT", data.size());
d7348237   jack   1.修改课后练报表页面
312
  			modelAndView.addObject("page_data", pageData); // 报表统计情况
f7e4dd61   孙向锦   根据客户UI的需求进行修改
313
314
315
316
  			modelAndView.addObject("data", data);// 未答学生列表
  			
  		}
  		if(isChineseLanguageClient()){
e9e81463   jack   1.添加金太阳id(id=7)识别
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
  			modelAndView.setViewName("sunvote/homework/homework_report_bak");
  		}else{
  			modelAndView.setViewName("sunvote/homework/en_homework_report");
  		}
  		
  		return modelAndView;
  	}
  	
  	/**
  	 * 传入homework_id 
  	 * 查询该场课后练的整体情况,最高分,最低分,平均分,总分,总题数,未答人数等
  	 * 未答人数列表
  	 * @return
  	 * @throws Exception
  	 */
  	@RequestMapping(value = "/report2_goldsun")
  	public ModelAndView report2_goldsun() throws Exception {
  		PageData pageData = this.getPageData();
  		ModelAndView modelAndView = getModelAndView();
  		
  		String homeworkId = pageData.getString("HOMEWORK_ID");
  		if(!StringUtils.isEmpty(homeworkId.trim())){
  			pageData = homeworkService.findById(pageData);
  			List<PageData> data = homeworkReporkService.findNoAnswerByHomeworkID(pageData);
  			pageData.put("NO_COUNT", data.size());
  			modelAndView.addObject("page_data", pageData); // 报表统计情况
  			modelAndView.addObject("data", data);// 未答学生列表
  			
  		}
  		if(isChineseLanguageClient()){
d7348237   jack   1.修改课后练报表页面
347
  			modelAndView.setViewName("sunvote/homework/homework_report");
f7e4dd61   孙向锦   根据客户UI的需求进行修改
348
  		}else{
d7348237   jack   1.修改课后练报表页面
349
  			modelAndView.setViewName("sunvote/homework/en_homework_report");
f7e4dd61   孙向锦   根据客户UI的需求进行修改
350
351
352
  		}
  		
  		return modelAndView;
f7e4dd61   孙向锦   根据客户UI的需求进行修改
353
354
355
356
357
358
359
360
361
  	}
  	
  	
  	/**
  	 * 传入homework_id 
  	 * index 第几题
  	 * @return
  	 * @throws Exception
  	 */
16ba76b9   孙向锦   添加编码
362
  	@RequestMapping(value = "/homeworkindex",produces = "text/html;charset=UTF-8")
f7e4dd61   孙向锦   根据客户UI的需求进行修改
363
364
365
366
367
368
369
  	@ResponseBody
  	public Object homeworkindex() throws Exception {
  		PageData pageData = this.getPageData();
  		
  		String homeworkId = pageData.getString("HOMEWORK_ID");
  		String index = pageData.getString("INDEX");
  		int indexint = Integer.parseInt(index);
27a15f6c   孙向锦   课后练bug修改
370
  		List<PageData> data = homeworkReporkService.findByHomeworkID(pageData);
6de2192e   孙向锦   答案统计
371
372
373
  		pageData = homeworkService.findById(pageData);
  		pageData.put("RANK", indexint);
  		pageData = homeworkproblemService.findByCodeAndRank(pageData);
6de2192e   孙向锦   答案统计
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
  		String optionNumStr = pageData.getString("OPTION_NUM");
  		String rightAnswer = pageData.getString("RIGHT_ANSWER");
  		rightAnswer = rightAnswer.toUpperCase();
  		int optionNum = Integer.parseInt(optionNumStr);
  		
  		List<List<String>> resultData = new ArrayList();
  		for (int i = 0; i < optionNum; i++) {
  			List<String> optionAnswer = new ArrayList();
  			resultData.add(optionAnswer);
  			for (PageData pd : data) {
  				String answer = pd.getString("ANSWER");
  				if (!StringUtils.isEmpty(answer)) {
  					String[] answers = answer.split(";");
  					if (answers.length >= indexint - 1) {
  						String ans = answers[indexint - 1];
  						String[] anss = ans.split(",");
  						if (anss != null && anss.length == 2) {
  							char option = (char)('A' + i) ;
  							if(anss[0] != null){
  								if(anss[0].contains("" + option)){
27a15f6c   孙向锦   课后练bug修改
394
  									optionAnswer.add(pd.getString("STUDENT_NAME") + "(" + anss[0] + ")");
6de2192e   孙向锦   答案统计
395
  								}
f7e4dd61   孙向锦   根据客户UI的需求进行修改
396
397
  							}
  						}
f7e4dd61   孙向锦   根据客户UI的需求进行修改
398
399
400
401
  					}
  				}
  			}
  		}
6de2192e   孙向锦   答案统计
402
403
404
  		Map<String,Object> map = new HashMap();
  		map.put("ANSWER", rightAnswer);
  		map.put("DATA", resultData);
f12ed244   孙向锦   添加分数回传
405
  		map.put("SCORE", pageData.getString("SCORE"));
6de2192e   孙向锦   答案统计
406
  		return new Gson().toJson(map);
f7e4dd61   孙向锦   根据客户UI的需求进行修改
407
408
409
410
411
412
  		
  	}
  	
  	
  	
  	/**
e9e81463   jack   1.添加金太阳id(id=7)识别
413
  	 * 练习报表
a28085c0   孙向锦   修改班级编辑bug
414
415
416
417
418
419
420
  	 * 
  	 * @param
  	 * @throws Exception
  	 */
  	@RequestMapping(value = "/report")
  	public ModelAndView report() throws Exception {
  		ModelAndView mv = this.getModelAndView();
e9e81463   jack   1.添加金太阳id(id=7)识别
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
  		PageData pd = new PageData();
  		pd = this.getPageData();
  		if(pd.get("SCHOOL_ID") == null || "".equals(pd.get("SCHOOL_ID").toString().trim())){
  			pd.put("TEACHER_ID", getTeacherID());
  		}
  		
  		
  		if(pd.get("CURRENT_WEEK") == null && pd.get("START_DATE") == null && pd.get("END_DATE") == null){
  			pd.put("CURRENT_WEEK", "0");
  			String currentWeek = pd.getString("CURRENT_WEEK");
  			int current = Integer.parseInt(currentWeek);
  			pd.put("START_DATE", getWeekStart(current));
  			pd.put("END_DATE", getWeekEnd(current));
  		}else if(pd.get("CURRENT_WEEK") != null){
  			String currentWeek = pd.getString("CURRENT_WEEK");
  			int current = Integer.parseInt(currentWeek);
  			pd.put("START_DATE", getWeekStart(current));
  			pd.put("END_DATE", getWeekEnd(current));
  		}
  		
  		// 班级信息
  		List<PageData> list = coursemanagementService.listTeacherClass(pd);
  		for(PageData temp : list){
  			temp.remove("HEADMASTER_ID");
  			temp.remove("SCHOOL_ID");
  			temp.remove("GRADE_ID");
  			temp.remove("TEACHER_ID");
  			temp.remove("KEYBOARD_TYPE");
  			temp.remove("BASESTATION_ID");
  			temp.put("CLASS_ID", temp.get("ID"));
  			temp.remove("ID");
  		}
  		if(pd.get("CLASS_ID") == null && list.size() > 0){
  			pd.put("CLASS_ID", list.get(0).get("CLASS_ID"));
  		}
  		pd.put("CLASSES", list);
  		
  		if (pd.get("CLASS_ID") != null) {
  			// 对应班级数据
  			PageData data = new PageData();
  			List<PageData> studentList = studentService.findByClassId(pd);
  			pd.put("COMPLETE_COUNT", "1");
  			List<PageData> homeworkList = homeworkService.listAll(pd);
  			List<PageData> dataList = homeworkService.report(pd);
  			for (PageData stuPd : studentList) {
  				double all = 0;
  				double get = 0;
  				int sc = 0 ;
  				int ac = 0 ;
  				for (PageData dpd : dataList) {
  					if (stuPd.get("ID") != null && dpd.get("STUDENT_ID") != null && dpd.get("STUDENT_ID").equals(stuPd.get("ID")) && isIn(dpd.getString("HOMEWORK_ID"),homeworkList)) {
  						stuPd.put(dpd.get("HOMEWORK_ID"),
  								dpd.get("STUDENT_SCORE"));
  						try {
  							get += Double.parseDouble(dpd.get("STUDENT_SCORE")
  									.toString());
  						} catch (Exception ex) {
  
  						}
  						try {
  							all += Double.parseDouble(dpd.get("PAPER_SCORE")
  									.toString());
  						} catch (Exception ex) {
  
  						}
  						try {
  							sc += Integer.parseInt(dpd.get("COMPLETE_COUNT")
  									.toString());
  						} catch (Exception ex) {
  
  						}
  						try {
  							ac += Integer.parseInt(dpd.get("QUESTION_COUNT")
  									.toString());
  						} catch (Exception ex) {
  							
  						}
  						
  					}
  				}
  				stuPd.put("STUDENT_ALL_SCORE", get);
  				stuPd.put("PAPER_ALL_SCORE", all);
  				stuPd.put("COMPLETE_COUNT", sc);
  				stuPd.put("ALL_COUNT", ac);
  				stuPd.remove("SCHOOL_ID");
  				stuPd.remove("SEX");
  				stuPd.remove("CLASS_ID");
  				stuPd.remove("NUMBER");
  				stuPd.put("STUDENT_ID", stuPd.get("ID"));
  				stuPd.remove("ID");
  			}
  			
  			for (PageData hpd : homeworkList) {
  				hpd.remove("QUESTION_COUNT");
  				hpd.remove("COMPLETE_COUNT");
  				hpd.remove("SUBJECT_ID");
  				hpd.remove("SCHOOL_ID");
  				hpd.remove("GRADE_ID");
  				hpd.remove("SUMBIT_DATE");
  				hpd.remove("MODIFY_DATE");
  				hpd.remove("TEACHER_ID");
  				hpd.remove("CREATE_DATE");
  				hpd.remove("CLASS_ID");
  				hpd.remove("CODE");
  				hpd.remove("GET_MAX_SCORE");
  				hpd.remove("HOMEWORK_DESC");
  			}
  			data.put("HOMEWORKS", homeworkList);//
  			data.put("STUDENTS", studentList);
  			pd.put("DATA", data);
  		}else{
  			pd.put("CLASS_ID", "");
  		}
  		pd.remove("JSON");
  		if(isChineseLanguageClient()){
  			mv.setViewName("sunvote/homework/homework_report_bak");
  		}else{
  			mv.setViewName("sunvote/homework/en_homework_report");
  		}
  		mv.addObject("pd", pd);
  		return mv;
  	}
  	
  	/**
  	 * 练习报表
  	 * 
  	 * @param
  	 * @throws Exception
  	 */
  	@RequestMapping(value = "/report_goldsun")
  	public ModelAndView report_goldsun() throws Exception {
  		ModelAndView mv = this.getModelAndView();
a28085c0   孙向锦   修改班级编辑bug
553
554
  		PageData pd = new PageData();
  		pd = this.getPageData();
b3c44d84   孙向锦   课后练bug修复
555
556
557
  		if(pd.get("SCHOOL_ID") == null || "".equals(pd.get("SCHOOL_ID").toString().trim())){
  			pd.put("TEACHER_ID", getTeacherID());
  		}
6dd8580c   孙向锦   修改报表数据
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
  		
  		
  		if(pd.get("CURRENT_WEEK") == null && pd.get("START_DATE") == null && pd.get("END_DATE") == null){
  			pd.put("CURRENT_WEEK", "0");
  			String currentWeek = pd.getString("CURRENT_WEEK");
  			int current = Integer.parseInt(currentWeek);
  			pd.put("START_DATE", getWeekStart(current));
  			pd.put("END_DATE", getWeekEnd(current));
  		}else if(pd.get("CURRENT_WEEK") != null){
  			String currentWeek = pd.getString("CURRENT_WEEK");
  			int current = Integer.parseInt(currentWeek);
  			pd.put("START_DATE", getWeekStart(current));
  			pd.put("END_DATE", getWeekEnd(current));
  		}
  		
  		// 班级信息
fcd1fe57   孙向锦   报表数据
574
  		List<PageData> list = coursemanagementService.listTeacherClass(pd);
6dd8580c   孙向锦   修改报表数据
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
  		for(PageData temp : list){
  			temp.remove("HEADMASTER_ID");
  			temp.remove("SCHOOL_ID");
  			temp.remove("GRADE_ID");
  			temp.remove("TEACHER_ID");
  			temp.remove("KEYBOARD_TYPE");
  			temp.remove("BASESTATION_ID");
  			temp.put("CLASS_ID", temp.get("ID"));
  			temp.remove("ID");
  		}
  		if(pd.get("CLASS_ID") == null && list.size() > 0){
  			pd.put("CLASS_ID", list.get(0).get("CLASS_ID"));
  		}
  		pd.put("CLASSES", list);
  		
41bc74d2   孙向锦   添加空判断
590
591
592
593
  		if (pd.get("CLASS_ID") != null) {
  			// 对应班级数据
  			PageData data = new PageData();
  			List<PageData> studentList = studentService.findByClassId(pd);
0a4dfe03   孙向锦   修改报表数据不应该出现的bug
594
  			pd.put("COMPLETE_COUNT", "1");
41bc74d2   孙向锦   添加空判断
595
596
597
598
599
  			List<PageData> homeworkList = homeworkService.listAll(pd);
  			List<PageData> dataList = homeworkService.report(pd);
  			for (PageData stuPd : studentList) {
  				double all = 0;
  				double get = 0;
1cbf6605   孙向锦   作业报表更新
600
601
  				int sc = 0 ;
  				int ac = 0 ;
41bc74d2   孙向锦   添加空判断
602
  				for (PageData dpd : dataList) {
a2414076   孙向锦   修改谢曲提交过来的bug
603
  					if (stuPd.get("ID") != null && dpd.get("STUDENT_ID") != null && dpd.get("STUDENT_ID").equals(stuPd.get("ID")) && isIn(dpd.getString("HOMEWORK_ID"),homeworkList)) {
41bc74d2   孙向锦   添加空判断
604
605
606
607
608
609
610
611
612
613
614
615
616
617
  						stuPd.put(dpd.get("HOMEWORK_ID"),
  								dpd.get("STUDENT_SCORE"));
  						try {
  							get += Double.parseDouble(dpd.get("STUDENT_SCORE")
  									.toString());
  						} catch (Exception ex) {
  
  						}
  						try {
  							all += Double.parseDouble(dpd.get("PAPER_SCORE")
  									.toString());
  						} catch (Exception ex) {
  
  						}
1cbf6605   孙向锦   作业报表更新
618
619
620
621
622
623
624
625
626
627
628
629
630
  						try {
  							sc += Integer.parseInt(dpd.get("COMPLETE_COUNT")
  									.toString());
  						} catch (Exception ex) {
  
  						}
  						try {
  							ac += Integer.parseInt(dpd.get("QUESTION_COUNT")
  									.toString());
  						} catch (Exception ex) {
  							
  						}
  						
76263c7c   孙向锦   添加报表百分比数据
631
  					}
6dd8580c   孙向锦   修改报表数据
632
  				}
41bc74d2   孙向锦   添加空判断
633
634
  				stuPd.put("STUDENT_ALL_SCORE", get);
  				stuPd.put("PAPER_ALL_SCORE", all);
1cbf6605   孙向锦   作业报表更新
635
636
  				stuPd.put("COMPLETE_COUNT", sc);
  				stuPd.put("ALL_COUNT", ac);
41bc74d2   孙向锦   添加空判断
637
638
639
640
  				stuPd.remove("SCHOOL_ID");
  				stuPd.remove("SEX");
  				stuPd.remove("CLASS_ID");
  				stuPd.remove("NUMBER");
22e695bf   孙向锦   添加学生ID传送
641
  				stuPd.put("STUDENT_ID", stuPd.get("ID"));
41bc74d2   孙向锦   添加空判断
642
  				stuPd.remove("ID");
bd553929   孙向锦   修改接口
643
  			}
a764d288   孙向锦   修改课后练bug
644
  			
41bc74d2   孙向锦   添加空判断
645
646
647
648
649
650
651
652
653
654
655
656
657
658
  			for (PageData hpd : homeworkList) {
  				hpd.remove("QUESTION_COUNT");
  				hpd.remove("COMPLETE_COUNT");
  				hpd.remove("SUBJECT_ID");
  				hpd.remove("SCHOOL_ID");
  				hpd.remove("GRADE_ID");
  				hpd.remove("SUMBIT_DATE");
  				hpd.remove("MODIFY_DATE");
  				hpd.remove("TEACHER_ID");
  				hpd.remove("CREATE_DATE");
  				hpd.remove("CLASS_ID");
  				hpd.remove("CODE");
  				hpd.remove("GET_MAX_SCORE");
  				hpd.remove("HOMEWORK_DESC");
41bc74d2   孙向锦   添加空判断
659
660
661
662
663
664
  			}
  			data.put("HOMEWORKS", homeworkList);//
  			data.put("STUDENTS", studentList);
  			pd.put("DATA", data);
  		}else{
  			pd.put("CLASS_ID", "");
fcd1fe57   孙向锦   报表数据
665
  		}
76263c7c   孙向锦   添加报表百分比数据
666
  		pd.remove("JSON");
1ee08611   jack   1.英文翻译(2)
667
668
669
670
671
  		if(isChineseLanguageClient()){
  			mv.setViewName("sunvote/homework/homework_report");
  		}else{
  			mv.setViewName("sunvote/homework/en_homework_report");
  		}
a28085c0   孙向锦   修改班级编辑bug
672
673
674
  		mv.addObject("pd", pd);
  		return mv;
  	}
4431f0b7   孙向锦   报表页面
675
676
  	
  	
a2414076   孙向锦   修改谢曲提交过来的bug
677
678
679
680
681
682
683
684
685
686
687
  	private boolean isIn(String homeworkId,List<PageData> data){
  		if(data != null && homeworkId != null){
  			for(PageData pd : data){
  				if(homeworkId.equals(pd.get("HOMEWORK_ID"))){
  					return true;
  				}
  			}
  		}
  		return false;
  	}
  	
4431f0b7   孙向锦   报表页面
688
689
690
691
692
693
694
695
696
697
698
699
  	/**
  	 * 去修改页面
  	 * 
  	 * @param
  	 * @throws Exception
  	 */
  	@RequestMapping(value = "/student")
  	public ModelAndView student() throws Exception {
  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		pd = this.getPageData();
  		pd.put("TEACHER_ID", getTeacherID());
4431f0b7   孙向锦   报表页面
700
701
702
703
704
705
706
707
708
709
710
711
  		if(pd.get("CURRENT_WEEK") == null && pd.get("START_DATE") == null && pd.get("END_DATE") == null){
  			pd.put("CURRENT_WEEK", "0");
  			String currentWeek = pd.getString("CURRENT_WEEK");
  			int current = Integer.parseInt(currentWeek);
  			pd.put("START_DATE", getWeekStart(current));
  			pd.put("END_DATE", getWeekEnd(current));
  		}else if(pd.get("CURRENT_WEEK") != null){
  			String currentWeek = pd.getString("CURRENT_WEEK");
  			int current = Integer.parseInt(currentWeek);
  			pd.put("START_DATE", getWeekStart(current));
  			pd.put("END_DATE", getWeekEnd(current));
  		}
6a210cdd   孙向锦   添加数据
712
  		String studentId = pd.getString("STUDENT_ID") ;
40af1dd5   jack   1、修改学生报表界面(2)
713
  		//pd.remove("STUDENT_ID");
6a210cdd   孙向锦   添加数据
714
715
  		List<PageData> dataList = homeworkService.report(pd);
  		pd.put("DATA", dataList);
80838e9c   孙向锦   修改时间不能使用的bug
716
717
718
719
  		if(pd.get("CLASS_ID") != null){
  			List<PageData> studentList = studentService.findByClassId(pd);
  			pd.put("STUDENTS", studentList);
  		}
4431f0b7   孙向锦   报表页面
720
  		pd.remove("JSON");
6a210cdd   孙向锦   添加数据
721
  		pd.put("STUDENT_ID", studentId);
1ee08611   jack   1.英文翻译(2)
722
723
724
725
726
727
  		if(isChineseLanguageClient()){
  			mv.setViewName("sunvote/homework/homework_student_report");
  		}else{
  			mv.setViewName("sunvote/homework/en_homework_student_report");
  		}
  		
4431f0b7   孙向锦   报表页面
728
  		mv.addObject("pd", pd);
6a210cdd   孙向锦   添加数据
729
730
  		Gson gson = new Gson();
  		mv.addObject("data",gson.toJson(pd));
4431f0b7   孙向锦   报表页面
731
732
733
  		return mv;
  	}
  	
6a210cdd   孙向锦   添加数据
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
  	/**
  	 * 去修改页面
  	 * 
  	 * @param
  	 * @throws Exception
  	 */
  	@RequestMapping(value = "/student_data", produces = "application/json;charset=UTF-8")
  	@ResponseBody
  	public String studentData() throws Exception {
  		PageData pd = new PageData();
  		pd = this.getPageData();
  		pd.put("TEACHER_ID", getTeacherID());
  		if(pd.get("CURRENT_WEEK") == null && pd.get("START_DATE") == null && pd.get("END_DATE") == null){
  			pd.put("CURRENT_WEEK", "0");
  			String currentWeek = pd.getString("CURRENT_WEEK");
  			int current = Integer.parseInt(currentWeek);
  			pd.put("START_DATE", getWeekStart(current));
  			pd.put("END_DATE", getWeekEnd(current));
  		}else if(pd.get("CURRENT_WEEK") != null){
  			String currentWeek = pd.getString("CURRENT_WEEK");
  			int current = Integer.parseInt(currentWeek);
  			pd.put("START_DATE", getWeekStart(current));
  			pd.put("END_DATE", getWeekEnd(current));
  		}
  		String studentId = pd.getString("STUDENT_ID") ;
  		pd.remove("STUDENT_ID");
  		List<PageData> dataList = homeworkService.report(pd);
  		pd.put("DATA", dataList);
  		if(pd.get("CLASS_ID") != null){
  			List<PageData> studentList = studentService.findByClassId(pd);
  			pd.put("STUDENTS", studentList);
  		}
  		pd.remove("JSON");
  		pd.put("STUDENT_ID", studentId);
  		Gson gson = new Gson();
  		return gson.toJson(pd);
  	}
  	
4431f0b7   孙向锦   报表页面
772
773
774
775
776
777
778
779
780
781
782
783
784
785
  	
  	/**
  	 * 去修改页面
  	 * 
  	 * @param
  	 * @throws Exception
  	 */
  	@RequestMapping(value = "/homework_report")
  	public ModelAndView homework_report() throws Exception {
  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		pd = this.getPageData();
  		pd.put("TEACHER_ID", getTeacherID());
  		
4431f0b7   孙向锦   报表页面
786
787
788
789
790
791
792
793
794
795
796
797
  		if(pd.get("CURRENT_WEEK") == null && pd.get("START_DATE") == null && pd.get("END_DATE") == null){
  			pd.put("CURRENT_WEEK", "0");
  			String currentWeek = pd.getString("CURRENT_WEEK");
  			int current = Integer.parseInt(currentWeek);
  			pd.put("START_DATE", getWeekStart(current));
  			pd.put("END_DATE", getWeekEnd(current));
  		}else if(pd.get("CURRENT_WEEK") != null){
  			String currentWeek = pd.getString("CURRENT_WEEK");
  			int current = Integer.parseInt(currentWeek);
  			pd.put("START_DATE", getWeekStart(current));
  			pd.put("END_DATE", getWeekEnd(current));
  		}
80838e9c   孙向锦   修改时间不能使用的bug
798
799
  		if(pd.get("HOMEWORK_ID") != null){
  			List<PageData> dataList = homeworkService.report(pd);
a764d288   孙向锦   修改课后练bug
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
  			Collections.sort(dataList,new Comparator<PageData>(){
  
  				@Override
  				public int compare(PageData o1, PageData o2) {
  					String o1GetScore = o1.getString("STUDENT_SCORE");
  					String o2GetScore = o2.getString("STUDENT_SCORE");
  					float o1score = 0 ;
  					float o2score = 0 ;
  					try{
  						o1score = Float.parseFloat(o1GetScore);
  					}catch(Exception e){
  						o1score = -1 ;
  					}
  					try{
  						o2score = Float.parseFloat(o2GetScore);
  					}catch(Exception e){
  						o2score = -1 ;
  					}
  					return  o1score - o2score > 0 ? -1 : 1;
  				}
  				
  			});
  			for(int i = 0 ; i < dataList.size(); i++){
  				PageData tpd1 = dataList.get(i);
  				if(i == 0){
  					tpd1.put("RANK", (i+1));
  				}else{
  					PageData tpd2 = dataList.get(i-1);
  					String o1GetScore = tpd1.getString("STUDENT_SCORE");
  					String o2GetScore = tpd2.getString("STUDENT_SCORE");
  					float o1score = 0 ;
  					float o2score = 0 ;
  					try{
  						o1score = Float.parseFloat(o1GetScore);
  					}catch(Exception e){
  						o1score = -1 ;
  					}
  					try{
  						o2score = Float.parseFloat(o2GetScore);
  					}catch(Exception e){
  						o2score = -1 ;
  					}
  					if(o2score - o1score == 0){
  						tpd1.put("RANK",tpd2.get("RANK"));
  					}else{
  						tpd1.put("RANK", (i+1));
  					}
  				}
  			}
80838e9c   孙向锦   修改时间不能使用的bug
849
850
851
852
853
854
855
  			pd.put("DATA", dataList);
  		}
  		if(pd.get("CLASS_ID") != null){
  			List<PageData> studentList = studentService.findByClassId(pd);
  			pd.put("STUDENTS", studentList);
  		}
  		
c93a7724   孙向锦   添加试卷描述
856
857
  		pd.put("HOMEWORKINFO", homeworkService.findById(pd));
  		
4431f0b7   孙向锦   报表页面
858
859
860
861
862
  		pd.remove("JSON");
  		mv.setViewName("sunvote/homework/homework_item_report");
  		mv.addObject("pd", pd);
  		return mv;
  	}
6a210cdd   孙向锦   添加数据
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
  	
  	
  	@RequestMapping(value = "/homework_report_data" , produces = "application/json;charset=UTF-8")
  	@ResponseBody
  	public String homeworkReportData() throws Exception {
  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		pd = this.getPageData();
  		pd.put("TEACHER_ID", getTeacherID());
  		
  		if(pd.get("CURRENT_WEEK") == null && pd.get("START_DATE") == null && pd.get("END_DATE") == null){
  			pd.put("CURRENT_WEEK", "0");
  			String currentWeek = pd.getString("CURRENT_WEEK");
  			int current = Integer.parseInt(currentWeek);
  			pd.put("START_DATE", getWeekStart(current));
  			pd.put("END_DATE", getWeekEnd(current));
  		}else if(pd.get("CURRENT_WEEK") != null){
  			String currentWeek = pd.getString("CURRENT_WEEK");
  			int current = Integer.parseInt(currentWeek);
  			pd.put("START_DATE", getWeekStart(current));
  			pd.put("END_DATE", getWeekEnd(current));
  		}
  		if(pd.get("HOMEWORK_ID") != null){
  			List<PageData> dataList = homeworkService.report(pd);
  			pd.put("DATA", dataList);
  		}
  		if(pd.get("CLASS_ID") != null){
  			List<PageData> studentList = studentService.findByClassId(pd);
  			pd.put("STUDENTS", studentList);
  		}
  		
  		pd.remove("JSON");
  		Gson gson = new Gson();
  		return gson.toJson(pd);
  	}
4431f0b7   孙向锦   报表页面
898
  
a28085c0   孙向锦   修改班级编辑bug
899
  
a479f295   孙向锦   添加了报表逻辑
900
901
902
903
  
  	/**
  	 * 批量删除
  	 * 
be2f84a1   孙向锦   添加课后作业基础模块数据
904
905
906
  	 * @param
  	 * @throws Exception
  	 */
a479f295   孙向锦   添加了报表逻辑
907
  	@RequestMapping(value = "/deleteAll")
be2f84a1   孙向锦   添加课后作业基础模块数据
908
  	@ResponseBody
a479f295   孙向锦   添加了报表逻辑
909
910
  	public Object deleteAll() throws Exception {
  		logBefore(logger, Jurisdiction.getUsername() + "批量删除Homework");
a479f295   孙向锦   添加了报表逻辑
911
912
  		PageData pd = new PageData();
  		Map<String, Object> map = new HashMap<String, Object>();
be2f84a1   孙向锦   添加课后作业基础模块数据
913
914
915
  		pd = this.getPageData();
  		List<PageData> pdList = new ArrayList<PageData>();
  		String DATA_IDS = pd.getString("DATA_IDS");
a479f295   孙向锦   添加了报表逻辑
916
  		if (null != DATA_IDS && !"".equals(DATA_IDS)) {
be2f84a1   孙向锦   添加课后作业基础模块数据
917
  			String ArrayDATA_IDS[] = DATA_IDS.split(",");
015d5970   孙向锦   更新删除接口
918
  			homeworkService.deleteHomeworkAll(ArrayDATA_IDS);
be2f84a1   孙向锦   添加课后作业基础模块数据
919
  			pd.put("msg", "ok");
a479f295   孙向锦   添加了报表逻辑
920
  		} else {
be2f84a1   孙向锦   添加课后作业基础模块数据
921
922
923
924
925
926
  			pd.put("msg", "no");
  		}
  		pdList.add(pd);
  		map.put("list", pdList);
  		return AppUtil.returnObject(pd, map);
  	}
a479f295   孙向锦   添加了报表逻辑
927
928
929
930
  
  	/**
  	 * 导出到excel
  	 * 
be2f84a1   孙向锦   添加课后作业基础模块数据
931
932
933
  	 * @param
  	 * @throws Exception
  	 */
a479f295   孙向锦   添加了报表逻辑
934
935
936
937
938
939
  	@RequestMapping(value = "/excel")
  	public ModelAndView exportExcel() throws Exception {
  		logBefore(logger, Jurisdiction.getUsername() + "导出Homework到excel");
  		if (!Jurisdiction.buttonJurisdiction(menuUrl, "cha")) {
  			return null;
  		}
be2f84a1   孙向锦   添加课后作业基础模块数据
940
941
942
  		ModelAndView mv = new ModelAndView();
  		PageData pd = new PageData();
  		pd = this.getPageData();
a479f295   孙向锦   添加了报表逻辑
943
  		Map<String, Object> dataMap = new HashMap<String, Object>();
be2f84a1   孙向锦   添加课后作业基础模块数据
944
  		List<String> titles = new ArrayList<String>();
a479f295   孙向锦   添加了报表逻辑
945
946
947
948
949
950
951
952
953
954
955
  		titles.add("作业代码"); // 1
  		titles.add("作业名称"); // 2
  		titles.add("科目ID"); // 3
  		titles.add("班级ID"); // 4
  		titles.add("年级ID"); // 5
  		titles.add("学校ID"); // 6
  		titles.add("需要完成时间"); // 7
  		titles.add("创建时间"); // 8
  		titles.add("修改时间"); // 9
  		titles.add("完成次数"); // 10
  		titles.add("总分"); // 11
be2f84a1   孙向锦   添加课后作业基础模块数据
956
957
958
  		dataMap.put("titles", titles);
  		List<PageData> varOList = homeworkService.listAll(pd);
  		List<PageData> varList = new ArrayList<PageData>();
a479f295   孙向锦   添加了报表逻辑
959
  		for (int i = 0; i < varOList.size(); i++) {
be2f84a1   孙向锦   添加课后作业基础模块数据
960
  			PageData vpd = new PageData();
a479f295   孙向锦   添加了报表逻辑
961
962
963
964
965
966
967
968
969
970
971
  			vpd.put("var1", varOList.get(i).getString("CODE")); // 1
  			vpd.put("var2", varOList.get(i).getString("NAME")); // 2
  			vpd.put("var3", varOList.get(i).getString("SUBJECT_ID")); // 3
  			vpd.put("var4", varOList.get(i).getString("CLASS_ID")); // 4
  			vpd.put("var5", varOList.get(i).getString("GRADE_ID")); // 5
  			vpd.put("var6", varOList.get(i).getString("SCHOOL_ID")); // 6
  			vpd.put("var7", varOList.get(i).getString("COMPLETE_DATE")); // 7
  			vpd.put("var8", varOList.get(i).getString("CREATE_DATE")); // 8
  			vpd.put("var9", varOList.get(i).getString("MODIFY_DATE")); // 9
  			vpd.put("var10", varOList.get(i).get("COMPLETE_COUNT").toString()); // 10
  			vpd.put("var11", varOList.get(i).get("ALL_SCORE").toString()); // 11
be2f84a1   孙向锦   添加课后作业基础模块数据
972
973
974
975
  			varList.add(vpd);
  		}
  		dataMap.put("varList", varList);
  		ObjectExcelView erv = new ObjectExcelView();
a479f295   孙向锦   添加了报表逻辑
976
  		mv = new ModelAndView(erv, dataMap);
be2f84a1   孙向锦   添加课后作业基础模块数据
977
978
  		return mv;
  	}
a479f295   孙向锦   添加了报表逻辑
979
  
be2f84a1   孙向锦   添加课后作业基础模块数据
980
  	@InitBinder
a479f295   孙向锦   添加了报表逻辑
981
  	public void initBinder(WebDataBinder binder) {
be2f84a1   孙向锦   添加课后作业基础模块数据
982
  		DateFormat format = new SimpleDateFormat("yyyy-MM-dd");
a479f295   孙向锦   添加了报表逻辑
983
984
985
986
987
988
989
990
991
992
993
994
995
996
  		binder.registerCustomEditor(Date.class, new CustomDateEditor(format,
  				true));
  	}
  
  	/**
  	 * 批量删除
  	 * 
  	 * @param
  	 * @throws Exception
  	 */
  	@RequestMapping(value = "/homereport", produces = "application/json;charset=UTF-8")
  	@ResponseBody
  	public String getHomeReport() throws Exception {
  		PageData pd = this.getPageData();
a28085c0   孙向锦   修改班级编辑bug
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
  		if(pd.get("HOMEWORK_ID") != null && !"".equals(pd.get("HOMEWORK_ID").toString().trim())){
  			pd = homeworkService.findById(pd);
  			if(pd != null){
  				List<PageData> data = homeworkReporService.findByHomeworkID(pd);
  				pd.put("STUDENTS", data);
  			}else{
  				pd.put("HOMEWORK_ID", "no");
  			}
  		}else{
  			pd.put("HOMEWORK_ID", "no data"); 
  		}
a479f295   孙向锦   添加了报表逻辑
1008
1009
  		Gson gson = new Gson();
  		return gson.toJson(pd);
be2f84a1   孙向锦   添加课后作业基础模块数据
1010
  	}
a28085c0   孙向锦   修改班级编辑bug
1011
1012
  	
  	
5162dcee   孙向锦   添加上传作业接口
1013
  
2514d928   孙向锦   添加课后作ye,API
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
  	/**
  	 * 列表
  	 * 
  	 * @param page
  	 * @throws Exception
  	 */
  	@RequestMapping(value = "/listdata", produces = "application/json;charset=UTF-8")
  	@ResponseBody
  	public String listdata(Page page) throws Exception {
  		PageData pd = new PageData();
  		pd = this.getPageData();
  		String keywords = pd.getString("keywords"); // 关键词检索条件
  		if (null != keywords && !"".equals(keywords)) {
  			pd.put("keywords", keywords.trim());
  		}
  		page.setPd(pd);
  		List<PageData> varList = homeworkService.list(page); // 列出Homework列表
  		Gson gson = new Gson();
  		return gson.toJson(varList);
  	}
5162dcee   孙向锦   添加上传作业接口
1034
1035
1036
  
  	@RequestMapping(value = "/savedata", produces = "application/json;charset=UTF-8")
  	@ResponseBody
2514d928   孙向锦   添加课后作ye,API
1037
1038
1039
  	public String savedata() throws Exception {
  		PageData pd = new PageData();
  		pd = this.getPageData();
5162dcee   孙向锦   添加上传作业接口
1040
  		pd.put("HOMEWORK_ID", this.get32UUID());
0786f023   孙向锦   修改教师不能删除的bug
1041
  		pd.put("SUBJECT_ID", homeworkService.querySubjectId(pd));
2514d928   孙向锦   添加课后作ye,API
1042
1043
1044
1045
1046
  		homeworkService.save(pd);
  		ResponseGson<String> responseGson = new ResponseGson<String>();
  		responseGson.setData(pd.getString("HOMEWORK_ID"));
  		return responseGson.toJson();
  	}
02c4ed52   孙向锦   更新上传作业接口
1047
  
5162dcee   孙向锦   添加上传作业接口
1048
1049
1050
1051
1052
1053
1054
1055
  	@RequestMapping(value = "/uploadHomework", produces = "application/json;charset=UTF-8")
  	@ResponseBody
  	public String uploadHomework() throws Exception {
  		PageData pd = new PageData();
  		pd = this.getPageData();
  		DateFormat format = new SimpleDateFormat("yyyy-MM-dd");
  		String data = pd.getJsonString();
  		ResponseGson<String> responseGson = new ResponseGson<String>();
02c4ed52   孙向锦   更新上传作业接口
1056
  
5162dcee   孙向锦   添加上传作业接口
1057
  		Homework homework = Homework.parse(data);
02c4ed52   孙向锦   更新上传作业接口
1058
  
b3c44d84   孙向锦   课后练bug修复
1059
1060
1061
  		pd.put("ID", getTeacherID());
  		PageData tmpd = teacherService.findById(pd);
  		
5162dcee   孙向锦   添加上传作业接口
1062
  		PageData hpd = new PageData();
02c4ed52   孙向锦   更新上传作业接口
1063
1064
1065
  		if (homework != null) {
  			hpd.put("CODE", get32UUID());
  			hpd.put("NAME", homework.getNAME());
5b1fa3bc   孙向锦   修复bug
1066
  			if(homework.getSUBJECT_ID() == null){
0786f023   孙向锦   修改教师不能删除的bug
1067
  				pd.put("TEACHER_ID", homework.getTEACHER_ID());
5b1fa3bc   孙向锦   修复bug
1068
1069
1070
1071
1072
  				List<PageData> slist = homeworkService.querySubjectId(pd);
  				if(slist.size() > 0){
  					homework.setSUBJECT_ID(slist.get(0).getString("SUBJECT_ID"));
  				}
  			}
02c4ed52   孙向锦   更新上传作业接口
1073
1074
1075
1076
1077
1078
1079
1080
  			hpd.put("SUBJECT_ID", homework.getSUBJECT_ID());
  			hpd.put("ALL_SCORE", homework.getALL_SCORE());
  			hpd.put("HOMEWORK_DESC", homework.getHOMEWORK_DESC());
  			hpd.put("QUESTION_COUNT", homework.getQUESTION_COUNT());
  			hpd.put("CREATE_DATE", format.format(new Date()));
  			hpd.put("MODIFY_DATE", format.format(new Date()));
  			hpd.put("COMPLETE_COUNT", 0);
  			hpd.put("TEACHER_ID", homework.getTEACHER_ID());
b3c44d84   孙向锦   课后练bug修复
1081
  			hpd.put("SCHOOL_ID", tmpd.get("SCHOOL_ID"));
02c4ed52   孙向锦   更新上传作业接口
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
  			hpd.put("COMPLETE_DESC", "");
  
  			if (homework.getCLASSLIST() != null
  					&& homework.getCLASSLIST().size() > 0
  					&& homework.getQUESTIONS() != null
  					&& homework.getQUESTIONS().size() > 0) {
  				for (HomeClass homeclass : homework.getCLASSLIST()) {
  					hpd.put("CLASS_ID", homeclass.getCLASS_ID());
  					hpd.put("COMPLETE_DATE", homeclass.getCOMPLETE_DATE());
  					hpd.put("HOMEWORK_ID", this.get32UUID());
  					homeworkService.save(hpd);
  				}
  
  				for (HomeworkQuestion homeworkQuestion : homework
  						.getQUESTIONS()) {
  					PageData qpd = new PageData();
  					qpd.put("RANK", homeworkQuestion.getRANK());
  					qpd.put("CODE", hpd.get("CODE"));
  					qpd.put("NAME", homeworkQuestion.getNAME());
  					qpd.put("OPTION_NUM", homeworkQuestion.getOPTION_NUM());
  					qpd.put("SCORE", homeworkQuestion.getSCORE());
  					qpd.put("RIGHT_ANSWER", homeworkQuestion.getRIGHT_ANSWER());
  					qpd.put("TYPE", homeworkQuestion.getTYPE());
  					qpd.put("HOMEWORKPROBLEM_ID", this.get32UUID());
  					qpd.put("HOMEWORK_ID", hpd.get("CODE"));
  					homeworkproblemService.save(qpd);
  				}
  
85ea5817   孙向锦   布置练习更新
1110
  				responseGson.setData(hpd.getString("CODE"));
02c4ed52   孙向锦   更新上传作业接口
1111
1112
1113
1114
1115
  			} else {
  				responseGson.setDataError();
  			}
  		} else {
  			responseGson.setDataError();
5162dcee   孙向锦   添加上传作业接口
1116
  		}
5162dcee   孙向锦   添加上传作业接口
1117
1118
  		return responseGson.toJson();
  	}
2c6bc93d   孙向锦   更新作业
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
  
  	@RequestMapping(value = "/updateHomework", produces = "application/json;charset=UTF-8")
  	@ResponseBody
  	public String updateHomework() throws Exception {
  		PageData pd = new PageData();
  		pd = this.getPageData();
  		DateFormat format = new SimpleDateFormat("yyyy-MM-dd");
  		String data = pd.getJsonString();
  		ResponseGson<String> responseGson = new ResponseGson<String>();
  
  		Homework homework = Homework.parse(data);
b3c44d84   孙向锦   课后练bug修复
1130
1131
  		pd.put("ID", getTeacherID());
  		PageData tmpd = teacherService.findById(pd);
2c6bc93d   孙向锦   更新作业
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
  		PageData hpd = new PageData();
  		if (homework != null) {
  			if (homework.getHOMEWORK_ID() != null
  					&& !"".equals(homework.getHOMEWORK_ID().trim())) {
  				hpd.put("HOMEWORK_ID", homework.getHOMEWORK_ID());
  				hpd = homeworkService.findById(hpd);
  				if(hpd != null){
  					hpd.put("NAME", homework.getNAME());
  					hpd.put("SUBJECT_ID", homework.getSUBJECT_ID());
  					hpd.put("ALL_SCORE", homework.getALL_SCORE());
  					hpd.put("HOMEWORK_DESC", homework.getHOMEWORK_DESC());
  					hpd.put("QUESTION_COUNT", homework.getQUESTION_COUNT());
  					hpd.put("CREATE_DATE", format.format(new Date()));
  					hpd.put("MODIFY_DATE", format.format(new Date()));
  					hpd.put("COMPLETE_COUNT", 0);
  					hpd.put("TEACHER_ID", homework.getTEACHER_ID());
  					hpd.put("COMPLETE_DESC", "");
b3c44d84   孙向锦   课后练bug修复
1149
  					hpd.put("SCHOOL_ID", tmpd.get("SCHOOL_ID"));
2c6bc93d   孙向锦   更新作业
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
  					if(homeworkService.findByCode(hpd).size() > 1){
  						hpd.put("CODE", get32UUID());
  						for (HomeClass homeclass : homework.getCLASSLIST()) {
  							hpd.put("CLASS_ID", homeclass.getCLASS_ID());
  							hpd.put("COMPLETE_DATE", homeclass.getCOMPLETE_DATE());
  							homeworkService.edit(hpd);
  						}
  						for (HomeworkQuestion homeworkQuestion : homework
  								.getQUESTIONS()) {
  							PageData qpd = new PageData();
  							qpd.put("RANK", homeworkQuestion.getRANK());
  							qpd.put("CODE", hpd.get("CODE"));
  							qpd.put("NAME", homeworkQuestion.getNAME());
  							qpd.put("OPTION_NUM", homeworkQuestion.getOPTION_NUM());
  							qpd.put("SCORE", homeworkQuestion.getSCORE());
  							qpd.put("RIGHT_ANSWER",
  									homeworkQuestion.getRIGHT_ANSWER());
  							qpd.put("TYPE", homeworkQuestion.getTYPE());
  							qpd.put("HOMEWORKPROBLEM_ID", this.get32UUID());
  							qpd.put("HOMEWORK_ID", hpd.get("CODE"));
  							homeworkproblemService.save(qpd);
  						}
  						responseGson.setData(hpd.getString("CODE"));
  					}else{
  						for (HomeClass homeclass : homework.getCLASSLIST()) {
  							hpd.put("CLASS_ID", homeclass.getCLASS_ID());
  							hpd.put("COMPLETE_DATE", homeclass.getCOMPLETE_DATE());
  							homeworkService.edit(hpd);
  						}
  						homeworkproblemService.deleteByCode(hpd);
  						for (HomeworkQuestion homeworkQuestion : homework
  								.getQUESTIONS()) {
  							PageData qpd = new PageData();
  							qpd.put("RANK", homeworkQuestion.getRANK());
  							qpd.put("CODE", hpd.get("CODE"));
  							qpd.put("NAME", homeworkQuestion.getNAME());
  							qpd.put("OPTION_NUM", homeworkQuestion.getOPTION_NUM());
  							qpd.put("SCORE", homeworkQuestion.getSCORE());
  							qpd.put("RIGHT_ANSWER",
  									homeworkQuestion.getRIGHT_ANSWER());
  							qpd.put("TYPE", homeworkQuestion.getTYPE());
  							qpd.put("HOMEWORKPROBLEM_ID", this.get32UUID());
  							qpd.put("HOMEWORK_ID", hpd.get("CODE"));
  							homeworkproblemService.save(qpd);
  						}
  						responseGson.setData(hpd.getString("CODE"));
  					}
  				}else{
  					responseGson.setDataError();
  				}
  			} else {
  				responseGson.setDataError();
  			}
  		} else {
  			responseGson.setDataError();
  		}
  		return responseGson.toJson();
  	}
f7e4dd61   孙向锦   根据客户UI的需求进行修改
1208
1209
  	
  	
be2f84a1   孙向锦   添加课后作业基础模块数据
1210
  }