加拿大MES项目
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
wu
2023-12-11 7f1806c6a01318f3b1eff38da7c7c41ae82ff8c0 
 springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java


@@ -5,27 +5,42 @@


import java.util.List;


import java.util.Map;




import javax.servlet.http.Cookie;


import javax.servlet.http.HttpServletRequest;




import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.context.annotation.Bean;




import com.example.springboot.mapper.HomeMapper;


import com.example.springboot.mapper.SpianMapper;


import com.example.springboot.security.constant.SystemConstant;


import com.example.springboot.security.util.JwtUtil;


import com.example.springboot.security.util.SecurityUtil;


import com.example.springboot.service.HomeService;


import com.example.springboot.service.JdbcConnections;


import com.example.springboot.service.North_Glass_Buffer1Service;


import com.example.springboot.service.OutSliceServive;


import com.example.springboot.service.PermissionService;


import com.example.springboot.service.SpianService;




import cn.hutool.core.util.StrUtil;




import com.example.springboot.common.Result;


import com.example.springboot.component.Plchome;


import com.example.springboot.component.S7control;


import com.example.springboot.entity.CarPosition;


import com.example.springboot.entity.StorageCage;


import com.example.springboot.entity.User;


import com.example.springboot.entity.alarmmg;


import com.example.springboot.entity.north_glass_buffer1;


import com.example.springboot.entity.Out_slice;


import com.example.springboot.entity.Permission;


import com.example.springboot.entity.Queue;


import com.example.springboot.entity.RolePermission;




import org.springframework.web.bind.annotation.*;


import org.springframework.web.context.request.RequestContextHolder;


import org.springframework.web.context.request.ServletRequestAttributes;




@RestController


@RequestMapping("/home")


@@ -51,6 +66,15 @@


  @Autowired


  private JdbcConnections jdbcConnections;




  // 获取当前登录用户权限


  @GetMapping("/SelectPermissionByUserName")


  public Result SelectPermissionByUserName(String username) {


    Map<String, Object> map = new HashMap<>();


    List<RolePermission> permission = homeMapper.SelectPermissionByUserName(username);


    map.put("permission", permission);


    return Result.success(map);


  }




  // 查询理片笼使用情况


  @GetMapping("/load")


  public Result selectAll() {


@@ -63,6 +87,7 @@


  // 查询理片笼玻璃情况


  @GetMapping("/loads")


  public Result selectRack() {




    List<StorageCage> storageCagelist1 = homeMapper.selectRack1();


    List<StorageCage> storageCagelist2 = homeMapper.selectRack2();


    List<StorageCage> storageCagelist3 = homeMapper.selectRack3();


@@ -115,7 +140,7 @@


  @GetMapping("/UpdateTask")


  public Result UpdateTask(Integer types, Integer shelfrack, String glassid) {


    Map<String, Object> map = new HashMap<>();


    homeMapper.UpdateTask(types);


    homeMapper.UpdateTask(types,glassid);


    StorageCage glass = homeMapper.SelectGlassInfo(glassid);


    if (types == 0) {


      homeMapper.UpdateCageTask1(glassid);


@@ -166,11 +191,22 @@


    if (result == null) {


      north_glass_buffer1 north_glass_buffer1 = jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(glassid, "", "");


      String flip = jdbcConnections.SelectFlipByFrameBarcode(north_glass_buffer1.getFrameBarcode());


      String position = jdbcConnections.SelectPositionByFrameBarcode(north_glass_buffer1.getFrameBarcode());


      int sequence=homeMapper.SelectMaxSquence();


      homeMapper.AddOutSliceS(glassid, flip, north_glass_buffer1.getFrameBarcode(),


          north_glass_buffer1.getglasslengthmm().toString(), north_glass_buffer1.getglassheightmm().toString(),sequence,position);


      map.put("message2", "200");


      if (flip != null) {


        String position = jdbcConnections.SelectPositionByFrameBarcode(north_glass_buffer1.getFrameBarcode());


        if (position != null) {


          int sequence = homeMapper.SelectMaxSquence();


          homeMapper.AddOutSliceS(glassid, flip, north_glass_buffer1.getFrameBarcode(),


              north_glass_buffer1.getglasslengthmm().toString(), north_glass_buffer1.getglassheightmm().toString(),


              sequence, position);


          map.put("message2", "200");


        } else {


          map.put("message2", "300");


        }




      } else {


        map.put("message2", "400");


      }




    } else {


      map.put("message2", "500");


    }


@@ -225,6 +261,7 @@


    } else {


      homeMapper.Inglassid(queue, cage, cell, tier);


      spianMapper.UpdataAddCage1(queue.getglasswidth(), cage, cell);


      map.put("message", "200");


    }


    return Result.success(map);


  }


@@ -247,8 +284,10 @@


      map.put("message", "300");


    } else {


      homeMapper.InsertQueueGlassId(queue, id);


      // 调用伍存储过程


      spianService.selectAll(queue.getglassId());


      if (id == 1) {


        // 调用伍存储过程


        spianService.selectAll(queue.getglassId());


      }


      map.put("message", "200");


    }


    return Result.success(map);


@@ -285,27 +324,11 @@


  @PostMapping("/SelectAluminumFrameInfoById")


  public Result SelectAluminumFrameInfoById(String FrameBarcode) throws SQLException {


    String flip = jdbcConnections.SelectFlipByFrameBarcode(FrameBarcode);


    List<north_glass_buffer1> listAluminumFrame=north_Glass_Buffer1Service.SelectAluminumFrameInfoById(FrameBarcode);


    List<north_glass_buffer1> listAluminumFrame = north_Glass_Buffer1Service.SelectAluminumFrameInfoById(FrameBarcode);


    Map<String, Object> map = new HashMap<>();


    map.put("listAluminumFrame", listAluminumFrame);


    map.put("flip", flip);


    return Result.success(map);


  }




  // 查询出片队列数据


  @PostMapping("/SelectProductionqueue")


  public Result SelectProductionqueue() throws SQLException {


    List<Out_slice> listoutslice = homeMapper.SelectProductionqueue();


    for (Out_slice out_slice : listoutslice) {


      out_slice


          .setnorth_glass_buffer1s(jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(out_slice.getGlassId(), "", ""));


      out_slice.setstorageCage(homeMapper.SelectStorageGlassById(out_slice.getGlassId()));


    }


    Map<String, Object> maps = new HashMap<>();


    maps.put("listoutslice", listoutslice);


    // Plchome.isAllowQueue=false;


    return Result.success(maps);




  }




  // 根据玻璃id删除出片队列玻璃


@@ -319,7 +342,7 @@




  // 添加铝框id对应玻璃到出片队列


  @PostMapping("/AddOutSliceS")


  public Result AddOutSliceS(@RequestBody String[][] AluminumFrames) {


  public Result AddOutSliceS(@RequestBody String[][] AluminumFrames) throws SQLException {


    outSliceServive.AddOutSliceS(AluminumFrames);


    Map<String, Object> map = new HashMap<>();


    map.put("message", "200");


@@ -332,7 +355,7 @@


    Plchome.isAllowQueue = isAllowQueue;


    if (isAllowQueue == true) {


      for (Out_slice out_slice2 : out_slice) {


        homeMapper.UpdateOutSliceSequence(out_slice2.getGlassId(),out_slice2.getSequence());


        homeMapper.UpdateOutSliceSequence(out_slice2.getGlassId(), out_slice2.getSequence());


      }


    }


    Map<String, Object> map = new HashMap<>();


@@ -348,4 +371,12 @@


    map.put("message", "200");


    return Result.success(map);


  }




  //手动完成任务


  @PostMapping("/CompleteQueue")


  public Result CompleteQueue(String id,String frameid,String glassid) {


    return outSliceServive.CompleteQueue(id,frameid,glassid);


    


  }


  


}