JavaWeb 基于SSM的汽车维修管理系统

package com.chillax.controller; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.chillax.bean.Car; import com.chillax.bean.Order; import com.chillax.bean.OrderPart; import com.chillax.bean.OrderWorker; import com.chillax.bean.Part; import com.chillax.bean.SStation; import com.chillax.bean.User; import com.chillax.bean.Worker; import com.chillax.service.CarService; import com.chillax.service.OrderPartService; import com.chillax.service.OrderService; import com.chillax.service.OrderWorkerService; import com.chillax.service.PartService; import com.chillax.service.StationService; import com.chillax.service.WorkerService; import com.chillax.utils.BaseController; import com.chillax.utils.DateUtils; import com.chillax.utils.StringUtil; @Controller @RequestMapping("/order") public class OrderController extends BaseController { private final Integer WARNING_COUNT=20; @Resource private CarService carService; @Resource private StationService stationService; @Resource private PartService partService; @Resource private OrderPartService orderPartService; @Resource private OrderWorkerService orderWorkerService; @Resource private WorkerService workerService; @Resource private OrderService orderService; /** 页面跳转 预定页面 */ @RequestMapping("/toPreOrder") public String toPreOrder(HttpServletRequest request, HttpSession session, String carId) { return "order/preOrder"; } /** 订单预定 */ @RequestMapping("/preOrder") @ResponseBody public Integer preOrder(HttpServletRequest request, HttpSession session, String imgurls, String arriveTime, String desc) { // User user=(User)session.getAttribute("userOn"); SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); Date arrDate = null; try { arrDate = format.parse(arriveTime); } catch (ParseException e) { e.printStackTrace(); } Car car = (Car) session.getAttribute("preCar"); car.setCarState(1); int updateCar = carService.updateByPrimaryKeySelective(car); Order order = new Order(); order.setOrderId(StringUtil.getStringId()); order.setCarId(car.getCarId()); order.setoDescribe(desc); // 0 预约中 1预约成功 2正在执行 3完成 4拒绝 order.setoState("0"); order.setArriveTime(arrDate); order.setOrdertime(new Date()); order.setImgUrls(imgurls); int updateOrder = orderService.insertSelective(order); return updateOrder+updateCar; } /** 订单操作 */ @RequestMapping("/manage") public String manageOrder(HttpServletRequest request, HttpSession session,String orderId) { Map<String, Object> paramMap=new HashMap<String, Object>(); paramMap.put("orderId", orderId); //通过id查出只能是一条数据 List<Map<String, Object>> order = orderService.selectOrderByAttr(paramMap); String[] imgurls = order.get(0).get("imgUrls").toString().split(","); //查询所有待使用的机床 List<SStation> stations=stationService.selectAll(new HashMap<String, Object>(){{put("s_state", "完好待使用");}}); //查询所有空闲的工人 state=1空闲 2在忙 0离职 List<Worker> workers = workerService.selectWorkersByAttr(new Worker(){{setwState(1);}}); //查询所有可使用零件 List<Part> parts = partService.selectAll(); request.setAttribute("imgurls",imgurls); request.setAttribute("dealOrder",order.get(0)); request.setAttribute("stations",stations); request.setAttribute("workers",workers); request.setAttribute("parts",parts); return "order/manageOrder"; } /** 页面跳转 */ @RequestMapping("/list") public String workList(HttpServletRequest request, HttpSession session,String state) { Map<String, Object> paramMap=new HashMap<String, Object>(); paramMap.put("state", state); List<Map<String, Object>> order = orderService.selectOrderByAttr(paramMap); session.setAttribute("order", order); request.setAttribute("state", state); return "order/order_list"; } /** */ @RequestMapping("/accept") @ResponseBody public String acceptOrder(HttpServletResponse response,HttpServletRequest request,String orderId, String remark,String stationId) { String success="1"; //获取订单id 机床id 员工id集合 零件id num集合 String selectedWorker=request.getParameter("selectedWorker"); String[] workers = selectedWorker.split(","); String selParts=request.getParameter("parts"); JSONArray parts=JSONArray.parseArray(selParts); //修改订单状态 修改机床状态 更新order-worker order-part表 try { Order order = orderService.selectByPrimaryKey(orderId); order.setStationId(Integer.parseInt(stationId)); order.setoState("1");//1进行中 order.setRemark(remark); order.setBegintime(new Date()); orderService.updateByPrimaryKeySelective(order);//更新order SStation station = stationService.selectByPrimaryKey(Integer.parseInt(stationId)); station.setsState("完好在使用"); stationService.updateByPrimaryKeySelective(station); for(int i=0;i<parts.size();i++){ JSONObject jo = parts.getJSONObject(i); String pId = jo.get("id").toString(); int num = Integer.parseInt(jo.get("num").toString()); orderPartService.insert(new OrderPart(orderId, pId,num)); Part part = partService.selectByPrimaryKey(pId); part.setPartNum(part.getPartNum()-num); partService.updateByPrimaryKeySelective(part); } for(String id :workers){ orderWorkerService.insert(new OrderWorker(orderId,id)); Worker worker = workerService.selectByPrimaryKey(id); worker.setwState(0);//忙碌 workerService.updateByPrimaryKeySelective(worker); } } catch (Exception e) { success="0"; } return success; } /** 修改订单*/ @RequestMapping("/edit") public String edit(HttpServletRequest request,String orderId){ Map<String, Object> paramMap=new HashMap<String, Object>(); paramMap.put("orderId", orderId); //通过id查出只能是一条数据 List<Map<String, Object>> order = orderService.selectOrderByAttr(paramMap); String[] imgurls = order.get(0).get("imgUrls").toString().split(","); //查询机床 SStation station = stationService.selectByPrimaryKey(Integer.parseInt(order.get(0).get("s_id").toString())); //查询工人 0在忙 1 空闲 List<Map<String, Object>> selWorkers = orderWorkerService.selectByOrderId(order.get(0).get("o_id").toString()); //查询所有零件 List<Map<String, Object>> selParts = orderPartService.selectByOrderId(order.get(0).get("o_id").toString()); //查询所有待使用的机床 List<SStation> stations=stationService.selectAll(new HashMap<String, Object>(){{put("s_state", "完好待使用");}}); //查询所有空闲的工人 state=1空闲 2在忙 0离职 List<Worker> workers = workerService.selectWorkersByAttr(new Worker(){{setwState(1);}}); //查询所有可使用零件 List<Part> parts = partService.selectAll(); request.setAttribute("imgurls",imgurls); request.setAttribute("dealOrder",order.get(0)); request.setAttribute("stations",stations); request.setAttribute("workers",workers); request.setAttribute("parts",parts); request.setAttribute("station",station);//已选中station request.setAttribute("selWorkers",selWor