派遣记录，单位数据内网推送

Administrator

2021-08-24 c9424db1c23fcddd6f4eabdb5e3ef51d2c208613

 src/main/java/org/springblade/modules/dispatcher/controller/DispatcherController.java

@@ -129,17 +129,30 @@
      //List<String> list = Arrays.asList(dispatcher.getUserIds().split(","));
      //计算派遣人数
      //dispatcher.setNum(list.size());
      boolean status = false;
      if (dispatcher.getId()==null){
         User user = new User();
         user.setId(Long.parseLong(dispatcher.getUserIds()));
         user.setDispatch("0");
         userService.updateById(user);

         //新增派遣记录
         status = dispatcherService.save(dispatcher);

         //数据同步
         String s1 =
            "insert into sys_dispatcher(id,dispatcherTime,dispatcher_unit_id,user_ids,end_time,dept_id,jurisdiction) " +
            "values(" + "'" + dispatcher.getId() + "'" + "," +
               "'" + new SimpleDateFormat("yyyy-MM-dd").format(dispatcher.getDispatchertime()) + "'" + "," +
               "'" + dispatcher.getDispatcherUnitId() + "'" + "," +
               "'" + dispatcher.getUserIds() + "'" + "," +
               "'" + new SimpleDateFormat("yyyy-MM-dd").format(dispatcher.getEndTime()) + "'" + "," +
               "'" + dispatcher.getDeptId() + "'" + "," +
               "'" +dispatcher.getJurisdiction() + "'" + ");" +
            "update blade_user set dispatch = " + "'" + user.getDispatch() + "'" +
               " " +"where id = " + "'" + user.getId() + "'";
         FtpUtil.sqlFileUpload(s1);
      }
      else {
      }else {
            //查询当前派遣记录
            Dispatcher dispatcher1 = dispatcherService.getById(dispatcher.getId());
            if (!dispatcher1.getUserIds().equals(dispatcher.getUserIds())){
@@ -155,15 +168,27 @@
               user1.setDispatch("0");
               userService.updateById(user1);

               //修改
               status = dispatcherService.updateById(dispatcher);

               //内网同步
               String s1 =
                  "update blade_user set dispatch = " + "'" + user.getDispatch() + "'" +
                     " " +"where id = " + "'" + user.getId() + "';"+
                  "update sys_dispatcher set dispatcherTime = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(dispatcher.getDispatchertime()) + "'" +
                     ",dispatcher_unit_id = " + "'" + dispatcher.getDispatcherUnitId() + "'" +
                     ",user_ids = " + "'" + dispatcher.getUserIds() + "'" +
                     ",end_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(dispatcher.getEndTime()) + "'" +
                     ",dept_id = " + "'" + dispatcher.getDeptId() + "'" +
                     ",jurisdiction = " + "'" + dispatcher.getJurisdiction() + "'" +
                     " " +"where id = " + "'" + user.getId() + "';"+
                  "update blade_user set dispatch = " + "'" + user1.getDispatch() + "'" +
                     " " +"where id = " + "'" + user1.getId() + "'";
               FtpUtil.sqlFileUpload(s1);
            }

      }
      return R.status(dispatcherService.saveOrUpdate(dispatcher));
      return R.status(status);
   }