作者主页:夜未央5788
简介:Java领域优质创作者、Java项目、学习资料、技术互助
文末获取源码
项目介绍
本系统主要围绕管理人员、业主、维修人员、维修部门管理层人员对物业管理中的维修管理的各方面应用进行开发。
项目分为管理员、管理层、业主、维修人员四种角色;
管理员主要功能包括:
人员管理、公告管理、维修管理、个人中心等;
管理层主要功能包括:
维修报表统计、报修情况、投诉情况、个人中心等;
维修人员主要功能包括:
维修任务、我的维修任务、我的消息、个人中心等;
业主主要功能包括:
首页、我的报修、个人中心等功能;
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。
2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA;
3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可
4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS;
5.数据库:MySql 5.7版本;
6.是否Maven项目: 否;查看源码目录中是否包含pom.xml;若包含,则为maven项目,否则为非maven项目
技术栈
1. 后端:Spring SpringMVC Hibernate
2. 前端:JSP+css+javascript+bootstrap+jQuery
使用说明
1. 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件;
2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;
若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行;
3. 将项目中db.properties配置文件中的数据库配置改为自己的配置;
4. 运行项目,在浏览器中输入http://localhost:8080 登录
管理员用户密码:admin/123
管理层用户密码:manage/123
维修人员用户密码:张三/123
业主用户密码:abc/123
运行截图
相关代码
UserController
package com.www.controller;
import java.io.IOException;
import java.net.URLDecoder;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.ui.ModelMap;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.servlet.ModelAndView;
import com.www.entity.Repairtask;
import com.www.entity.User;
import com.www.service.UserService;
import com.www.util.HttpUtil;
import com.www.util.Page;
import com.www.util.Pagination;
@Controller
public class UserController {
@Resource
private UserService userService;
@RequestMapping(value = "/touser")
protected ModelAndView toupdate(HttpServletRequest request,
HttpServletResponse response, HttpSession session) throws Exception {
request.setCharacterEncoding("UTF-8");
Map<String, Object> map = new HashMap<String, Object>();
System.out.println("进来了?。。。。。");
String name = "";
Cookie[] cookies = request.getCookies();
if (cookies != null) {
for (int i = 0; i < cookies.length; i++) {
if (cookies[i].getName().equals("username")) {
name = URLDecoder.decode(cookies[i].getValue(), "utf-8");
System.out.println("登录名" + name
+ "<<<<<<<<<<<======>>>>>>>>>");
}
}
}
User user = userService.findbyName(name);
String type = user.getType();
map.put("user", user);
if (type.equals("管理员")) {
return new ModelAndView("admin/account_user", map);
} else if (type.equals("维修人员")) {
return new ModelAndView("repair/account_user", map);
} else if (type.equals("业主")) {
return new ModelAndView("owner/account_user", map);
} else {
return new ModelAndView("manage/account_user", map);
}
}
@RequestMapping(value = "/user", method = RequestMethod.POST)
protected ModelAndView update(HttpServletRequest request,
HttpServletResponse response, HttpSession session,
@Validated User user) throws Exception {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html");
response.setCharacterEncoding("UTF-8");
System.out.println("进来了?。。。。。");
ModelMap map = new ModelMap();
System.out.println(user.toString() + "==============");
String name = request.getParameter("username");
String type = request.getParameter("type");
int id = Integer.parseInt(request.getParameter("userid"));
int gender = Integer.parseInt(request.getParameter("gender"));
String tel = request.getParameter("tel");
String pass = request.getParameter("password1");
String sql = "update from User set tel='" + tel + "',PassWord='" +
pass + "',type='" +
type + "',gender='" +
gender + "'where id=" + id;
userService.update_user(sql);
String result = "success";
map.addAttribute("result", result);
// map.put("result", result);
// userService.updateUser(user);
if (type.equals("管理员")) {
return new ModelAndView("redirect:/user/list", map);
} else if (type.equals("维修人员")) {
return new ModelAndView("redirect:/repairtask/list", map);
} else if (type.equals("业主")) {
return new ModelAndView("redirect:/repairtask/list", map);
} else {
return new ModelAndView("redirect:/repairtask/list", map);
}
}
@RequestMapping(value = "/user/list")
protected ModelAndView list(HttpServletRequest request,
HttpServletResponse response, HttpSession session) throws Exception {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html");
response.setCharacterEncoding("UTF-8");
System.out.println("进来了?。userlist。。。。");
HttpUtil util = new HttpUtil(request, response);
int startRow = util.parseInt(Pagination.START_ROW);
Map<String, Object> map = new HashMap<String, Object>();
String sql = "from User";
List<User> l = new ArrayList<User>();
Page page = userService.findPageByHQL(sql, startRow, 6, null);
if (page != null && page.getList() != null) {
List lists = page.getList();
for (int i = 0; i < lists.size(); i++) {
User user = (User) lists.get(i);
l.add(user);
}
}
map.put("list", l);
map.put("page", page);
System.out.println("我到这里了。。。");
return new ModelAndView("admin/userlist", map);
}
@RequestMapping(value = "/user/tosend")
protected ModelAndView tosend(HttpServletRequest request,
HttpServletResponse response, HttpSession session) throws Exception {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html");
response.setCharacterEncoding("UTF-8");
System.out.println("进来了?。userlist。。。。");
String type="维修人员";
HttpUtil util = new HttpUtil(request, response);
int startRow = util.parseInt(Pagination.START_ROW);
Map<String, Object> map = new HashMap<String, Object>();
StringBuffer hql = new StringBuffer("from User where 1=1 ");
List param = new ArrayList();
if (type != null && !"".equals(type)) {
hql.append(" and type=?");
param.add(type);
System.out.println(param + "param'''''''''''''333===");
}
List<User> l = new ArrayList<User>();
Page page = userService.findPageByHQL(hql.toString(), startRow, 9, param.toArray());
if (page != null && page.getList() != null) {
List lists = page.getList();
for (int i = 0; i < lists.size(); i++) {
User user = (User) lists.get(i);
l.add(user);
}
}
map.put("list", l);
map.put("page", page);
System.out.println("我到这里了。。。");
return new ModelAndView("admin/touserlist", map);
}
// 删除某个用户
@RequestMapping(value = "/user/{id}/del")
protected ModelAndView del(HttpServletRequest request,
HttpServletResponse response, @PathVariable int id)
throws Exception {
System.out.println("..del.....进来没有?");
userService.delete(id);
return new ModelAndView("redirect:/user/list");
}
/* 跳转到修改页面 */
@RequestMapping(value = "/user/{id}/update")
public String update(@PathVariable int id, Model model) {
model.addAttribute("user", userService.load(id));
return "admin/user_update";
}
/* 修改用户信息 将接收到的页面的值修改过来-----》跳到显示页面 */
@RequestMapping(value = "/user/{id}/update", method = RequestMethod.POST)
public ModelAndView updateUser(HttpServletRequest request,
HttpServletResponse response, @PathVariable int id,
@Validated User user) throws Exception, IOException {
response.setContentType("text/html");
response.setCharacterEncoding("UTF-8");
System.out.println("进来没有");
User u = userService.load(id);
u.setAdress(user.getAdress());
u.setType(user.getType());
u.setTel(user.getTel());
userService.modify(u);
ModelAndView andView = new ModelAndView();
andView.setViewName("redirect:/user/list");
return andView;
}
@RequestMapping(value = "/user/toadd")
protected ModelAndView toadd(HttpServletRequest request,
HttpServletResponse response) throws Exception {
System.out.println("进来了?。。。toaddtoaddtoadd。。");
System.out.println("我到这里了。。。");
return new ModelAndView("admin/useradd");
}
// 增加用户
@RequestMapping(value = "/user/add")
protected String add(HttpServletRequest request,
HttpServletResponse response) throws Exception {
System.out.println("进来了?。。。add add。。");
int gender = Integer.parseInt(request.getParameter("gender"));// 项目
String type = request.getParameter("type");// 维修种类
String password = request.getParameter("passWord");
String username = request.getParameter("username");// 维修内容
String adress = request.getParameter("adress");
String tel = request.getParameter("tel");
User user = new User();
user.setGender(gender);
user.setTel(tel);
user.setAdress(adress);
user.setType(type);
user.setPassWord(password);
user.setUserName(username);
userService.add(user);
System.out.println("我到这里了。。。");
return "redirect:/user/list";
}
}
RepairTaskController
package com.www.controller;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.math.BigDecimal;
import java.net.URLDecoder;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Random;
import javax.annotation.Resource;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.PathVariable;
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.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.servlet.ModelAndView;
import com.www.bean.TaskReportBean;
import com.www.entity.Repairtask;
import com.www.service.RepairTaskService;
import com.www.util.DwrService;
import com.www.util.HttpUtil;
import com.www.util.Page;
import com.www.util.Pagination;
@Controller
@RequestMapping("/repairtask")
public class RepairTaskController {
@Resource
private RepairTaskService repairTaskService;
//供维修人员看到的全部维修任务
@RequestMapping(value = "/list")
protected ModelAndView list(HttpServletRequest request,
HttpServletResponse response) throws Exception {
System.out.println("进来了?。。。。。");
HttpUtil util = new HttpUtil(request, response);
int startRow = util.parseInt(Pagination.START_ROW);
Map<String, Object> map = new HashMap<String, Object>();
String name="";
String sql = "from Repairtask where 1=1 order by createtime desc";
List<Repairtask> l = new ArrayList<Repairtask>();
Page page = repairTaskService.findPageByHQL(sql, startRow, 9, null);
if (page != null && page.getList() != null) {
List lists = page.getList();
for (int i = 0; i < lists.size(); i++) {
Repairtask repairtask = (Repairtask) lists.get(i);
l.add(repairtask);
}
}
map.put("list", l);
map.put("page", page);
System.out.println("我到这里了。。。");
return new ModelAndView("repair/repairlist", map);
}
// 维修人员 ======我的维修任务
@RequestMapping(value = "/mylist")
protected ModelAndView mylist(HttpServletRequest request,
HttpServletResponse response) throws Exception {
HttpUtil util = new HttpUtil(request, response);
int startRow = util.parseInt(Pagination.START_ROW);
System.out.println("进来了?。。。。。");
String name = "";
Cookie[] cookies = request.getCookies();
if (cookies != null) {
for (int i = 0; i < cookies.length; i++) {
if (cookies[i].getName().equals("username")) {
name = URLDecoder.decode(cookies[i].getValue(), "utf-8");
System.out.println("登录名" + name
+ "<<<<<<<<<<<======>>>>>>>>>");
}
}
}
Map<String, Object> map = new HashMap<String, Object>();
String reqBody = name;
System.out.println(reqBody + "req....................");
StringBuffer hql = new StringBuffer("from Repairtask where 1=1");
System.out.println(hql + "hql================");
List param = new ArrayList();
if (reqBody != null && !"".equals(reqBody)) {
hql.append(" and workpeople =?");
param.add(reqBody);
System.out.println(param + "param'''''''''''''333===");
}
hql.append(" order by grabtime desc");
List<Repairtask> l = new ArrayList<Repairtask>();
Page page = repairTaskService.findPageByHQL(hql.toString(), startRow,
9, param.toArray());
if (page != null && page.getList() != null) {
List lists = page.getList();
for (int i = 0; i < lists.size(); i++) {
Repairtask repairtask = (Repairtask) lists.get(i);
l.add(repairtask);
}
}
// List list = repairTaskService.findAll(hql.toString(),
// param.toArray());
map.put("list", l);
map.put("page", page);
System.out.println("我到这里了。。。");
return new ModelAndView("repair/myrepairlist", map);
}
// 业主 ======我的报修
@RequestMapping(value = "/ownerlist")
protected ModelAndView ownerlist(HttpServletRequest request,
HttpServletResponse response) throws Exception {
HttpUtil util = new HttpUtil(request, response);
int startRow = util.parseInt(Pagination.START_ROW);
System.out.println("进来了?。。。。。");
String name = "";
Cookie[] cookies = request.getCookies();
if (cookies != null) {
for (int i = 0; i < cookies.length; i++) {
if (cookies[i].getName().equals("username")) {
name = URLDecoder.decode(cookies[i].getValue(), "utf-8");
System.out.println("登录名" + name
+ "<<<<<<<<<<<======>>>>>>>>>");
}
}
}
Map<String, Object> map = new HashMap<String, Object>();
String reqBody = name;
System.out.println(reqBody + "req....................");
StringBuffer hql = new StringBuffer("from Repairtask where 1=1");
System.out.println(hql + "hql================");
List param = new ArrayList();
if (reqBody != null && !"".equals(reqBody)) {
hql.append(" and repairpeople =?");
param.add(reqBody);
System.out.println(param + "param'''''''''''''333===");
}
hql.append(" order by createtime desc");
List<Repairtask> l = new ArrayList<Repairtask>();
Page page = repairTaskService.findPageByHQL(hql.toString(), startRow,
9, param.toArray());
if (page != null && page.getList() != null) {
List lists = page.getList();
for (int i = 0; i < lists.size(); i++) {
Repairtask repairtask = (Repairtask) lists.get(i);
l.add(repairtask);
}
}
// List list = repairTaskService.findAll(hql.toString(),
// param.toArray());
map.put("list", l);
map.put("page", page);
System.out.println("我到这里了。。。");
return new ModelAndView("owner/repairlist", map);
}
//管理员 ======我的报修
@RequestMapping(value = "/adminlist")
protected ModelAndView adminlist(HttpServletRequest request,
HttpServletResponse response) throws Exception {
HttpUtil util = new HttpUtil(request, response);
int startRow = util.parseInt(Pagination.START_ROW);
System.out.println("进来了?。。。。。");
Map<String, Object> map = new HashMap<String, Object>();
StringBuffer hql = new StringBuffer("from Repairtask where 1=1");
System.out.println(hql + "hql================");
List<Repairtask> l = new ArrayList<Repairtask>();
Page page = repairTaskService.findPageByHQL(hql.toString(), startRow,
9, null);
if (page != null && page.getList() != null) {
List lists = page.getList();
for (int i = 0; i < lists.size(); i++) {
Repairtask repairtask = (Repairtask) lists.get(i);
l.add(repairtask);
}
}
// List list = repairTaskService.findAll(hql.toString(),
// param.toArray());
map.put("list", l);
map.put("page", page);
System.out.println("我到这里了。。。");
return new ModelAndView("admin/repairlist", map);
}
@RequestMapping(value = "/listreport")
protected ModelAndView listreport(HttpServletRequest request,
HttpServletResponse response) throws Exception {
HttpUtil util = new HttpUtil(request, response);
Map<String, Object> map = new HashMap<String, Object>();
int startRow = util.parseInt(Pagination.START_ROW);
System.out.println("进来了?。。。。。");
String starttime=request.getParameter("startTime");
String endtime=request.getParameter("endTime");
System.out.println(starttime+".........");
System.out.println(endtime+".........");
StringBuffer sql = new StringBuffer();
sql.append( "select sum(case taskstatus when 1 then 2 else 1 end) ,sum(case taskstatus when 2 then 1 else 2 end) ,Avg(repairtime),Avg(responsetime),workpeople from repairtask");
if(starttime!=null&&endtime!=null){
starttime = starttime+" 00:00:00";
endtime = endtime+" 23:59:59";
sql.append(" where createtime>='"+starttime+"' and finishtime<='"+endtime+"'");
System.out.println(sql.toString()+".......time........");
}
sql.append(" group by workpeople");
System.out.println(sql.toString()+"..sql.toString()..");
List list = repairTaskService.findAllbySql(sql.toString(), null);
Page page = repairTaskService.findPageBySQL(sql.toString(), startRow, 9, null);
System.out.println(page + "page'''''''''''===");
List<TaskReportBean> reportList = new ArrayList<TaskReportBean>();
TaskReportBean bean = null;
Object[] obj = null;
for (int i = 0; i < list.size(); i++) {
bean = new TaskReportBean();
obj = (Object[]) list.get(i);
bean.setGrabConut(obj[0] != null ? obj[0].toString() : "");
bean.setFinishCount(obj[1] != null ? obj[1].toString() : "");
if (obj[2] != null) {
double a = Double.parseDouble(obj[2].toString());
bean.setAvgRepair(obj[2] != null ? new BigDecimal(a / 3600)
.setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue()
+ "" : "");
}
if (obj[3] != null) {
double a = Double.parseDouble(obj[3].toString());
bean.setAvgResponse(obj[3] != null ? new BigDecimal(a / 3600)
.setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue()
+ "" : "");
}
bean.setWorkpeople(obj[4] != null ? obj[4].toString() : "");
reportList.add(bean);
}
map.put("page", page);
map.put("list", list);
map.put("reportList", reportList);
System.out.println("我到这里了。。。");
return new ModelAndView("manage/repair_report", map);
}
//跳转到业主报修页面
@RequestMapping(value = "/toadd")
protected ModelAndView toadd(HttpServletRequest request,
HttpServletResponse response) throws Exception {
System.out.println("进来了?。。。toaddtoaddtoadd。。");
System.out.println("我到这里了。。。");
return new ModelAndView("owner/repairadd");
}
// 增加维修任务 ===业主
@RequestMapping(value = "/add")
protected String add(HttpServletRequest request,
HttpServletResponse response) throws Exception {
System.out.println("进来了?。。。add add。。");
String name="";
Cookie[] cookies = request.getCookies();
if (cookies != null) {
for (int i = 0; i < cookies.length; i++) {
if (cookies[i].getName().equals("username")) {
name = URLDecoder.decode(cookies[i].getValue(), "utf-8");
System.out.println("登录名" + name
+ "<<<<<<<<<<<======>>>>>>>>>");
}
}
}
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");// 设置日期格式
String time = df.format(new Date());// new Date()为获取当前系统时间
Timestamp now = new Timestamp(System.currentTimeMillis());
String project = request.getParameter("project");// 项目
System.out.println(project + "???????????????????project");
String category = request.getParameter("maintain");// 维修种类
System.out.println(category + "???????????????????maintain");
String content = request.getParameter("content");// 维修内容
String adress = request.getParameter("adress");
System.out.println(adress + "__________adress___________");
String tel = request.getParameter("tel");
System.out.println(adress + "__________tel___________");
Repairtask repairtask = new Repairtask();
repairtask.setRepairproject(project);
repairtask.setRepaircontent(content);
repairtask.setCreatetime(now);
repairtask.setTel(tel);
repairtask.setAdress(adress);
repairtask.setRepairtype(category);
repairtask.setTaskstatus(0);
repairtask.setRepairpeople(name);
repairTaskService.Save(repairtask);
System.out.println("我到这里了。。。");
return "redirect:/repairtask/ownerlist";
}
@RequestMapping(value = "/admintoadd")
protected ModelAndView admintoadd(HttpServletRequest request,
HttpServletResponse response) throws Exception {
System.out.println("进来了?。。。toaddtoaddtoadd。。");
System.out.println("我到这里了。。。");
return new ModelAndView("admin/repairadd");
}
// 增加维修任务
@RequestMapping(value = "/adminadd")
protected String adminadd(HttpServletRequest request,
HttpServletResponse response) throws Exception {
System.out.println("进来了?。。。add add。。");
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");// 设置日期格式
String time = df.format(new Date());// new Date()为获取当前系统时间
String name =request.getParameter("repairpeople");
Timestamp now = new Timestamp(System.currentTimeMillis());
String project = request.getParameter("project");// 项目
System.out.println(project + "project");
String category = request.getParameter("maintain");// 维修种类
System.out.println(category + "maintain");
String content = request.getParameter("content");// 维修内容
String adress = request.getParameter("adress");
System.out.println(adress + "__________adress___________");
String tel = request.getParameter("tel");
System.out.println(adress + "__________tel___________");
Repairtask repairtask = new Repairtask();
repairtask.setRepairproject(project);
repairtask.setRepaircontent(content);
repairtask.setCreatetime(now);
repairtask.setTel(tel);
repairtask.setAdress(adress);
repairtask.setRepairtype(category);
repairtask.setTaskstatus(0);
repairtask.setRepairpeople(name);
repairTaskService.Save(repairtask);
System.out.println("我到这里了。。。");
return "redirect:/repairtask/adminlist";
}
// 取消某条维修任务
@RequestMapping(value = "/{id}/admindel")
protected ModelAndView admindel(HttpServletRequest request,
HttpServletResponse response, @PathVariable int id)
throws Exception {
System.out.println("..admindel.....进来没有?");
repairTaskService.delRepairtask(id);
return new ModelAndView("redirect:/repairtask/adminlist");
}
/* 跳转到修改页面 */
@RequestMapping(value = "/{id}/adminupdate")
public String adminupdate(@PathVariable int id, Model model) {
model.addAttribute("repairTask", repairTaskService.load(id));
return "admin/repairtask_update";
}
/* 修改维修任务 将接收到的页面的值修改过来-----》跳到显示页面 */
@RequestMapping(value = "/{id}/adminupdate", method = RequestMethod.POST)
public ModelAndView updateUser(HttpServletRequest request,
HttpServletResponse response, @PathVariable int id,
@Validated Repairtask repairtask) throws Exception, IOException {
response.setContentType("text/html");
response.setCharacterEncoding("UTF-8");
System.out.println("进来没有 ===== adminupdate");
// Repairtask repairTask 接收修改后的值
Repairtask repair = repairTaskService.load(id);
// u.setUsername(repairtask.getUsername());
// u.setPassword(repairtask.getPassword());
repair.setAdress(repairtask.getAdress());
repair.setRepaircontent(repairtask.getRepaircontent());
repair.setTel(repairtask.getTel());
repair.setRepairpeople(repairtask.getRepairpeople());
repair.setRepairtype(repairtask.getTel());
Timestamp now = new Timestamp(System.currentTimeMillis());
String project = request.getParameter("project");// 项目
System.out.println(project + "project");
String category = request.getParameter("maintain");// 维修种类
System.out.println(category + "maintain");
// String repairname = GetCookie.getusername();
repair.setCreatetime(now);
// repair.setRepairpeople(repairpeople);
repair.setRepairtype(category);
repairTaskService.update(repair);
ModelAndView andView = new ModelAndView();
andView.setViewName("redirect:/repairtask/adminlist");
return andView;
}
// 取消某条维修任务 === 业主
@RequestMapping(value = "/{id}/del")
protected ModelAndView del(HttpServletRequest request,
HttpServletResponse response, @PathVariable int id)
throws Exception {
System.out.println("..del.....进来没有?");
repairTaskService.delRepairtask(id);
return new ModelAndView("redirect:/repairtask/ownerlist");
}
/* 跳转到修改页面 业主*/
@RequestMapping(value = "/{id}/update")
public String update(@PathVariable int id, Model model) {
model.addAttribute("repairTask", repairTaskService.load(id));
return "owner/repairtask_update";
}
/* 修改维修任务 将接收到的页面的值修改过来-----》跳到显示页面 业主 */
@RequestMapping(value = "/{id}/update", method = RequestMethod.POST)
public ModelAndView ownerupdate(HttpServletRequest request,
HttpServletResponse response, @PathVariable int id,
@Validated Repairtask repairtask) throws Exception, IOException {
response.setContentType("text/html");
response.setCharacterEncoding("UTF-8");
System.out.println("进来没有=====业主");
// Repairtask repairTask 接收修改后的值
Repairtask repair = repairTaskService.load(id);
// u.setUsername(repairtask.getUsername());
// u.setPassword(repairtask.getPassword());
repair.setAdress(repairtask.getAdress());
repair.setRepaircontent(repairtask.getRepaircontent());
repair.setTel(repairtask.getTel());
Timestamp now = new Timestamp(System.currentTimeMillis());
System.out.println(repairtask.getRepairproject()+"......");
String project = request.getParameter("project");// 项目
System.out.println(project + "???????????????????project");
String category = request.getParameter("maintain");// 维修种类
System.out.println(category + "???????????????????maintain");
// String repairname = GetCookie.getusername();
repair.setCreatetime(now);
// repair.setRepairpeople(repairpeople);
//repair.setRepairtype(category);
repairTaskService.update(repair);
ModelAndView andView = new ModelAndView();
andView.setViewName("redirect:/repairtask/ownerlist");
return andView;
}
// 修改任务状态和抢单人 ===点击抢单按钮时执行
@RequestMapping(value = "/{id}/grab")
public String grab(HttpServletRequest request, @PathVariable int id)
throws Exception, IOException {
String name = "";
Cookie[] cookies = request.getCookies();
if (cookies != null) {
for (int i = 0; i < cookies.length; i++) {
if (cookies[i].getName().equals("username")) {
name = URLDecoder.decode(cookies[i].getValue(), "utf-8");
System.out.println("登录名" + name
+ "<<<<<<<<<<<======>>>>>>>>>");
}
}
}
List time = repairTaskService.findAllbySql(
"SELECT TIMESTAMPDIFF(SECOND,createtime,now()) FROM repairtask WHERE id="
+ id, null);
String times = time.get(0).toString();
int second = Integer.parseInt(times);
System.out.println(second + "...........second...........");
Timestamp now = new Timestamp(System.currentTimeMillis());
String queryString = "update from Repairtask set taskstatus=1 ,workpeople='"
+ name
+ "' ,grabtime='"
+ now
+ "' , responsetime="
+ second
+ " where id=" + id;
repairTaskService.updateSome(queryString);
return "redirect:/repairtask/mylist";
}
// 修改任务状态和抢单人 ===点击抢单按钮时执行
@RequestMapping(value = "/{repairid}/{username}/tograb")
public String tograb(HttpServletRequest request,HttpServletResponse response, @PathVariable int repairid,@PathVariable String username)
throws Exception, IOException {
response.setContentType("text/html");
response.setCharacterEncoding("UTF-8");
request.setCharacterEncoding("UTF-8");
byte bb[];
bb = username.getBytes("ISO-8859-1"); //以"ISO-8859-1"方式解析name字符串
username= new String(bb, "UTF-8"); //再用"utf-8"格式表示name
System.out.println(username+"..........username=======");
List time = repairTaskService.findAllbySql(
"SELECT TIMESTAMPDIFF(SECOND,createtime,now()) FROM repairtask WHERE id="
+ repairid, null);
String times = time.get(0).toString();
int second = Integer.parseInt(times);
System.out.println(second + "...........second...........");
Timestamp now = new Timestamp(System.currentTimeMillis());
String queryString = "update from Repairtask set taskstatus=4 ,workpeople='"
+ username
+ "' ,grabtime='"
+ now
+ "' , responsetime="
+ second
+ " where id=" + repairid;
repairTaskService.updateSome(queryString);
return "redirect:/repairtask/mylist";
}
/* 维修人员=== 跳转到提交任务页面 */
@RequestMapping(value = "/{id}/tosumbit")
public String tosumbit(@PathVariable int id, Model model) {
System.out.println("进来了?。。tosumbit。。");
model.addAttribute("repairTask", repairTaskService.load(id));
return "repair/repairapeople_submit";
}
/* 将接收到的页面的值修改过来--保存数据---》跳到显示页面 */
@RequestMapping(value = "/{id}/tosumbit", method = RequestMethod.POST)
public ModelAndView updateUser(HttpServletRequest request,
HttpServletResponse response, @PathVariable int id,
@Validated Repairtask repairtask,
@RequestParam("cfile") MultipartFile cfile) throws Exception,
IOException {
response.setContentType("text/html");
response.setCharacterEncoding("GBK");
System.out.println("进来没有");
Repairtask r = repairTaskService.load(id);
r.setAdress(repairtask.getAdress());
System.out.println(repairtask.getAdress() + "<<<<<<地址》》》》》》》");
r.setRepaircontent(repairtask.getRepaircontent());
System.out.println(repairtask.getRepaircontent() + "<<<<<<维修内容》》》》》》》");
r.setTel(repairtask.getTel());
System.out.println(repairtask.getTel() + "<<<<<<tel》》》》》》》");
r.setTaskstatus(2);
Timestamp now = new Timestamp(System.currentTimeMillis());
r.setFinishtime(now);
// MultipartHttpServletRequest rm = (MultipartHttpServletRequest)
// request;
// CommonsMultipartFile cfile = (CommonsMultipartFile)
// rm.getFile("doc");
// 存储图片的物理路径
System.out.println("进来没有");
String fileName = "";
String suffix = "";
if (cfile != null) {
byte[] bfile = cfile.getBytes();
SimpleDateFormat format = new SimpleDateFormat("yyyyMMddHHmmssSSS");
fileName = format.format(new Date());
Random random = new Random();
for (int i = 0; i < 3; i++) {
fileName = fileName + random.nextInt(9);
}
String origFileName = cfile.getOriginalFilename();
suffix = origFileName.substring(origFileName.lastIndexOf("."));
String path = request.getSession().getServletContext()
.getRealPath("/");
String path_url = path + "/upload/" + fileName + suffix;
// u.setPicurl(fileName + suffix);
r.setPicurl(fileName + suffix);
System.out.println(path_url + "/");
OutputStream out = new FileOutputStream(new File(path_url));
out.write(bfile);
out.flush();
out.close();
}
List time = repairTaskService.findAllbySql(
"SELECT TIMESTAMPDIFF(SECOND,grabtime,now()) FROM repairtask WHERE id="
+ id, null);
String times = time.get(0).toString();
int second = Integer.parseInt(times);
System.out.println(second + "...........second...........");
r.setRepairtime(second);
repairTaskService.update(r);
// service.updateUser(u);
// return "redirect:/showall";
// return new ModelAndView("redirect:/showall");
ModelAndView andView = new ModelAndView();
// andView.addObject("file",fileName + suffix);
andView.setViewName("redirect:/repairtask/list");
return andView;
}
// 修改任务状态和抢单人
@RequestMapping(value = "/{id}/cancel")
public String cancel(HttpServletRequest request, @PathVariable int id)
throws Exception, IOException {
System.out.println("/{id}/canle");
String queryString = "update from Repairtask set taskstatus=0 ,workpeople="
+ null + ",grabtime=" + null + " where id=" + id;
repairTaskService.updateSome(queryString);
return "redirect:/repairtask/mylist";
}
// 计算
// 我的维修
@RequestMapping(value = "/report")
protected ModelAndView report(HttpServletRequest request,
HttpServletResponse response) throws Exception {
System.out.println("进来了?。。。。。");
String name = "";
Cookie[] cookies = request.getCookies();
if (cookies != null) {
for (int i = 0; i < cookies.length; i++) {
if (cookies[i].getName().equals("username")) {
name = URLDecoder.decode(cookies[i].getValue(), "utf-8");
System.out.println("登录名" + name
+ "<<<<<<<<<<<======>>>>>>>>>");
}
}
}
Map<String, Object> map = new HashMap<String, Object>();
String reqBody = name;
System.out.println(reqBody + "req....................");
StringBuffer hql = new StringBuffer("from Repairtask where 1=1");
System.out.println(hql + "hql================");
List param = new ArrayList();
if (reqBody != null && !"".equals(reqBody)) {
hql.append(" and workpeople =?");
param.add(reqBody);
System.out.println(param + "param'''''''''''''333===");
}
List list = repairTaskService.findAll(hql.toString(), param.toArray());
map.put("list", list);
System.out.println("我到这里了。。。");
return new ModelAndView("myrepairlist", map);
}
// 跳转到确认任务完成
@RequestMapping(value = "/{id}/sure")
protected ModelAndView tosure(HttpServletRequest request,
HttpServletResponse response, @PathVariable int id)
throws Exception {
System.out.println("进来了?。。。tosure。。");
System.out.println("我到这里了。tosure。。");
return new ModelAndView("owner/ownerrepairok");
}
// 确认任务完成
@RequestMapping(value = "/{id}/sure", method = RequestMethod.POST)
protected String sure(HttpServletRequest request,
HttpServletResponse response, @PathVariable int id)
throws Exception {
System.out.println("进来了?。。。sure sure。。");
String suggest = request.getParameter("suggest");
System.out.println(suggest + "<<<<<<===responsetime====>>>>");
String satisfaction = request.getParameter("satisfaction");
String queryString = "update from Repairtask set taskstatus=3, suggest='"
+ suggest + "',satisfaction='" + satisfaction + "' where id=" + id;
repairTaskService.updateSome(queryString);
System.out.println("我到这里了。。。");
return "redirect:/repairtask/ownerlist";
}
// 跳转到确认任务完成
@RequestMapping(value = "/{id}/adminsure")
protected ModelAndView admintosure(HttpServletRequest request,
HttpServletResponse response, @PathVariable int id)
throws Exception {
System.out.println("进来了?。。。tosure。。");
System.out.println("我到这里了。tosure。。");
return new ModelAndView("owner/ownerrepairok");
}
// 确认任务完成
@RequestMapping(value = "/{id}/adminsure", method = RequestMethod.POST)
protected String adminsure(HttpServletRequest request,
HttpServletResponse response, @PathVariable int id)
throws Exception {
System.out.println("进来了?。。。sure sure。。");
String suggest = request.getParameter("suggest");
System.out.println(suggest + "<<<<<<===responsetime====>>>>");
String satisfaction = request.getParameter("satisfaction");
String queryString = "update from Repairtask set taskstatus=3 , suggest='"
+ suggest + "',satisfaction='" + satisfaction + "' where id=" + id;
repairTaskService.updateSome(queryString);
System.out.println("我到这里了。。。");
return "redirect:/repairtask/adminlist";
}
@RequestMapping(value = "/gettask")
@ResponseBody
protected Repairtask getRepair(HttpServletRequest request) throws Exception {
String reqBody = DwrService.getJsonByRequest(request);
//String reqBody = request.getParameter("rid");
int id=Integer.parseInt(reqBody);
// String [] req = reqBody.split("&");
Repairtask note = null;
List param = new ArrayList();
StringBuffer hql = new StringBuffer(" from Repairtask where 1=1");
if (reqBody != null && !"".equals(reqBody)) {
System.out.println(reqBody+"=====");
hql.append(" and id = ?");
param.add(id);
}
List<Repairtask> list = repairTaskService.find(hql.toString(), param.toArray());
if (list != null && list.size() > 0) {
note = (Repairtask) list.get(0);
}
System.out.println("note============" + note);
return note;
}
@RequestMapping(value = "/change")
public void change(HttpServletRequest request,
HttpServletResponse response
) throws Exception, IOException {
System.out.println("进来了????change");
response.setContentType("text/html");
response.setCharacterEncoding("UTF-8");
request.setCharacterEncoding("UTF-8");
int id=Integer.parseInt(request.getParameter("id"));
System.out.println(id+"================changeflag");
String queryString = "update from Repairtask set taskstatus=5 where id=" + id;
repairTaskService.updateSome(queryString);
}
}
如果也想学习本系统,下面领取。关注并回复:125ssh