update

whycrzg

2021-02-23 351b9a53cb9ecebdf8f79db0117f540d9c42c2a4

 src/main/java/com/fgkj/services/User_task_changeService.java

@@ -1,13 +1,12 @@
package com.fgkj.services;

import com.fgkj.dto.PageBean;
import com.fgkj.dto.ServiceModel;
import com.fgkj.dto.Task_Batt_Test;
import com.fgkj.dto.User_task_change;
import com.fgkj.dto.*;
import com.fgkj.mapper.TestDaoFactory;
import com.fgkj.mapper.UtilityFactory;
import com.fgkj.mapper.impl.User_infMapper;
import com.fgkj.mapper.impl.User_task_changeMapper;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@@ -23,7 +22,14 @@
   //4.1作业变更申请
   public ServiceModel add(User_task_change obj) {
      ServiceModel model = new ServiceModel();
      Boolean bl=mapper.add(obj);
      Boolean bl= null;
      try {
         bl = mapper.add(obj);
      } catch (Exception e) {
         e.printStackTrace();
         model.setMsg("提交变更申请失败!");
         return model;
      }
      if(bl){
         model.setCode(1);
         model.setMsg("提交变更申请成功!");
@@ -37,7 +43,14 @@
   //4.5作业变更查询(审批)
   public ServiceModel update(User_task_change obj) {
      ServiceModel model = new ServiceModel();
      Boolean bl=mapper.update(obj);
      Boolean bl= null;
      try {
         bl = mapper.update(obj);
      } catch (Exception e) {
         e.printStackTrace();
         model.setMsg("作业审批失败!");
         return model;
      }
      if(bl){
         model.setCode(1);
         model.setMsg("作业审批成功!");
@@ -64,85 +77,42 @@


   @Resource
   private User_infMapper userInfMapper;
   private UtilityFactoryService utilityFactoryService;
   //4.5作业变更查询
    public ServiceModel serchByCondition(Task_Batt_Test obj) {
    public ServiceModel serchByCondition(Task_Batt_Test bmd) {
      ServiceModel model = new ServiceModel();
      PageBean pageBean = obj.getPageBean();
      int curr = (pageBean.getPageCurr() - 1) * pageBean.getPageSize();
      pageBean.setPageCurr(curr);
      List<Task_Batt_Test> list = mapper.serchByCondition(obj);   //TODO 待测试，数据不足
      //分页
      PageBean pageBean = bmd.getPageBean();
      PageHelper.startPage(pageBean.getPageNum(),pageBean.getPageSize(),true);
      List<Task_Batt_Test> list = mapper.serchByCondition(bmd);   //TODO 待测试，数据不足
      System.out.println("list.size() = " + list.size());
      if (list != null && list.size() > 0) {
         //去掉limit条件后的总数
         int number=mapper.getLimtitNumber();
         if(list!=null&&list.size()>0){
            list.get(list.size()-1).setPageBean(new PageBean());
            list.get(list.size()-1).getPageBean().setPageAll(number);
         }
         for (int i = 0; i < list.size(); i++) {
            System.out.println("list = " + list.get(i));
            System.out.println("getUsr_id = " + list.get(i).getUchange().getUsr_id());
            /***
             * {
             *   binf=BattInf{
             *     stationName='山西省-太原市-迎泽区-局机房119-局机房站-1',
             *     battGroupName='电池组1',
             *   },
             *   uchange=User_task_change[
             *     num=1,
             *     usr_id=1001,
             *     master_id=0,
             *     appoint_uid=1001,
             *     copy_uids=1001,
             *     change_type_id=0,
             *     task_type_id=0,
             *     task_rc_num=10580,
             *     BattgroupId=1000001,
             *     change_reason=有新的任务,
             *     old_executor_ids=1001,
             *     old_task_exe_time=ThuSep0800: 00: 00CST2016,
             *     new_executor_ids=0,
             *     new_task_exe_time=TueSep0600: 00: 00CST2016,
             *     change_ask_time=ThuSep0811: 32: 02CST2016,
             *     change_ask_time1=null,
             *     change_ask_time_limit=ThuSep0811: 32: 02CST2016,
             *     task_change_approve_time=SatOct2217: 13: 55CST2016,
             *     task_change_approve_time1=null,
             *     task_change_approve_res=1,
             *     remark=通过
             *   ],
             *   uinf=null,
             *   pageBean=null
             * }
             */

            //SELECT GROUP_CONCAT(DISTINCT(uname))as unames from db_user.tb_user_inf where locate(uid,?);
            String Uname = userInfMapper.searchUnams(list.get(i).getUchange().getUsr_id().toString());
//            String Uname = UtilityFactory.UidsToUnames(list.get(i).getUchange().getUsr_id().toString());
//            System.out.println("list = " + list.get(i));
//            System.out.println("getUsr_id = " + list.get(i).getUchange().getUsr_id());
            String Uname = utilityFactoryService.UidsToUnames(list.get(i).getUchange().getUsr_id().toString());
            list.get(i).getBinf().setStationName2(Uname);

//            String Cname = UtilityFactory.UidsToUnames(list.get(i).getUchange().getCopy_uids());
            String Cname = userInfMapper.searchUnams(list.get(i).getUchange().getCopy_uids());
//            String Cname = userInfMapper.searchUnams(list.get(i).getUchange().getCopy_uids());
            String Cname = utilityFactoryService.UidsToUnames(list.get(i).getUchange().getCopy_uids());
            list.get(i).getBinf().setStationName3(Cname);

//            String Aname = UtilityFactory.UidsToUnames(list.get(i).getUchange().getAppoint_uid().toString());
            String Aname = userInfMapper.searchUnams(list.get(i).getUchange().getAppoint_uid().toString());
            String Aname = utilityFactoryService.UidsToUnames(list.get(i).getUchange().getAppoint_uid().toString());
            list.get(i).getBinf().setStationName4(Aname);
            //  System.out.println(Uname+"  "+Cname+"   "+Aname);
//            String task_type = TestDaoFactory.getTaskType(list.get(i).getUchange().getTask_type_id());
            String task_type = TestDaoFactory.getTaskType(list.get(i).getUchange().getTask_type_id());
            list.get(i).getBinf().setStationName5(task_type);

//            String change_type = TestDaoFactory.getChangeType(list.get(i).getUchange().getChange_type_id());
            String change_type = TestDaoFactory.getChangeType(list.get(i).getUchange().getChange_type_id());
            list.get(i).getBinf().setStationName6(change_type);

//            String Oname = UtilityFactory.UidsToUnames(list.get(i).getUchange().getOld_executor_ids());
            String Oname = userInfMapper.searchUnams(list.get(i).getUchange().getOld_executor_ids());
            String Oname = utilityFactoryService.UidsToUnames(list.get(i).getUchange().getOld_executor_ids());
            list.get(i).getBinf().setStationName7(Oname);

//            String Nname = UtilityFactory.UidsToUnames(list.get(i).getUchange().getNew_executor_ids());
            String Nname = userInfMapper.searchUnams(list.get(i).getUchange().getNew_executor_ids());
            String Nname = utilityFactoryService.UidsToUnames(list.get(i).getUchange().getNew_executor_ids());
            list.get(i).getBinf().setStationName8(Nname);

            String approve_res = TestDaoFactory.getApprove_res(list.get(i).getUchange().getTask_change_approve_res());
@@ -153,8 +123,9 @@
//         System.out.println(t.getBinf());
//      }
      if (list != null && list.size() > 0) {
         PageInfo<Task_Batt_Test> pageInfo = new PageInfo<>(list);
         model.setCode(1);
         model.setData(list);
         model.setData(pageInfo);
      }
      // System.out.println(model);
      return model;