123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253 |
- package com.its.op.controller;
- import com.its.op.entity.its.cctv.TbCctvCtlr;
- import com.its.op.entity.its.code.TbCmmnCd;
- import com.its.op.entity.its.facility.TbFcltFailOcrrType;
- import com.its.op.entity.its.ifsc.TbIfsc;
- import com.its.op.entity.its.ifsc.TbIfscTraf;
- import com.its.op.entity.its.ifsc.TbIfscVrtxArr;
- import com.its.op.entity.its.link.TbLink;
- import com.its.op.entity.its.link.TbLinkTraf;
- import com.its.op.entity.its.link.TbLinkVrtxArr;
- import com.its.op.entity.its.node.TbNode;
- import com.its.op.entity.its.road.TbRoad;
- import com.its.op.entity.its.road.TbRoadTraf;
- import com.its.op.entity.its.road.TbRoadVrtxArr;
- import com.its.op.entity.its.rse.TbRseCtlr;
- import com.its.op.entity.its.scrs.TbScIxrCmraMngm;
- import com.its.op.entity.its.scrs.TbScIxrMngm;
- import com.its.op.entity.its.scrs.TbScSgnlCtlr;
- import com.its.op.entity.its.scrs.TbScSgnlIxrMngm;
- import com.its.op.entity.its.unit.TbUnitSyst;
- import com.its.op.entity.its.vds.TbVdsCtlr;
- import com.its.op.entity.its.vms.TbVmsCtlr;
- import com.its.op.entity.its.vms.TbVmsIfsc;
- import com.its.op.entity.its.vms.TbVmsSymbLib;
- import com.its.op.entity.its.wcam.TbWcamCtlr;
- import com.its.op.global.*;
- import io.swagger.annotations.Api;
- import io.swagger.annotations.ApiOperation;
- import lombok.RequiredArgsConstructor;
- import lombok.extern.slf4j.Slf4j;
- import org.springframework.http.MediaType;
- import org.springframework.http.ResponseEntity;
- import org.springframework.validation.annotation.Validated;
- import org.springframework.web.bind.annotation.GetMapping;
- import org.springframework.web.bind.annotation.RequestMapping;
- import org.springframework.web.bind.annotation.RestController;
- import java.util.List;
- @Slf4j
- @RequiredArgsConstructor
- @Validated
- @RestController
- @RequestMapping("/api/reload")
- @Api(tags = "00.공통-88.데이터베이스 리로드")
- public class ReloadDatabaseController {
- private final TbUnitSystManager unitSystManager;
- private final TbNodeManager nodeManager;
- private final TbLinkManager linkManager;
- private final TbIfscManager ifscManager;
- private final TbRoadManager roadManager;
- private final TbLinkVrtxArrManager linkVrtxManager;
- private final TbIfscVrtxArrManager ifscVrtxManager;
- private final TbRoadVrtxArrManager roadVrtxManager;
- private final TbCctvCtlrManager cctvCtlrManager;
- private final TbVmsCtlrManager vmsCtlrManager;
- private final TbVdsCtlrManager vdsCtlrManager;
- private final TbRseCtlrManager rseCtlrManager;
- private final TbWcamCtlrManager wcamCtlrManager;
- private final TbScIxrManager scIxrManager;
- private final TbScSgnlIxrManager scSgnlIxrManager;
- private final TbScSgnlCtlrManager scSgnlCtlrManager;
- private final TbScIxrCmraManager scIxrCmraManager;
- private final CmmnCdManager cmmnCdManager;
- private final CmmnFcltCdManager cmmnFcltCdManager;
- private final TbVmsIfscManager vmsIfscManager;
- private final TbVmsSymbLibManager vmsSymbLibManager;
- /******************************************************************************************************************/
- @ApiOperation(value = "시스템 UNIT 정보", response = TbUnitSyst.class, responseContainer = "ArrayList")
- @GetMapping(path="/unit", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbUnitSyst>> reloadUnitSyst() {
- List<TbUnitSyst> result = this.unitSystManager.reload();
- return ResponseEntity.ok(result);
- }
- /******************************************************************************************************************/
- @ApiOperation(value = "NODE 정보", response = TbNode.class, responseContainer = "ArrayList")
- @GetMapping(path="/node", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbNode>> reloadNode() {
- List<TbNode> result = this.nodeManager.reload();
- return ResponseEntity.ok(result);
- }
- /******************************************************************************************************************/
- @ApiOperation(value = "LINK 정보", response = TbLink.class, responseContainer = "ArrayList")
- @GetMapping(path="/link", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbLink>> reloadLink() {
- List<TbLink> result = this.linkManager.reload();
- return ResponseEntity.ok(result);
- }
- @ApiOperation(value = "IFSC 정보", response = TbIfsc.class, responseContainer = "ArrayList")
- @GetMapping(path="/ifsc", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbIfsc>> reloadIfsc() {
- List<TbIfsc> result = this.ifscManager.reload();
- return ResponseEntity.ok(result);
- }
- @ApiOperation(value = "ROAD 정보", response = TbRoad.class, responseContainer = "ArrayList")
- @GetMapping(path="/road", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbRoad>> reloadRoad() {
- List<TbRoad> result = this.roadManager.reload();
- return ResponseEntity.ok(result);
- }
- /******************************************************************************************************************/
- @ApiOperation(value = "LINK 소통 정보", response = TbLinkTraf.class, responseContainer = "ArrayList")
- @GetMapping(path="/link-traf", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbLinkTraf>> reloadLinkTraf() {
- this.linkManager.loadTraf(true);
- List<TbLinkTraf> result = this.linkManager.getTrafList();
- return ResponseEntity.ok(result);
- }
- @ApiOperation(value = "IFSC 소통 정보", response = TbIfscTraf.class, responseContainer = "ArrayList")
- @GetMapping(path="/ifsc-traf", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbIfscTraf>> reloadIfscTraf() {
- this.ifscManager.loadTraf(true);
- List<TbIfscTraf> result = this.ifscManager.getTrafList();
- return ResponseEntity.ok(result);
- }
- @ApiOperation(value = "ROAD 소통 정보", response = TbRoadTraf.class, responseContainer = "ArrayList")
- @GetMapping(path="/road-traf", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbRoadTraf>> reloadRoadTraf() {
- this.roadManager.loadTraf(true);
- List<TbRoadTraf> result = this.roadManager.getTrafList();
- return ResponseEntity.ok(result);
- }
- /******************************************************************************************************************/
- @ApiOperation(value = "LINK VRTX 정보", response = TbLinkVrtxArr.class, responseContainer = "ArrayList")
- @GetMapping(path="/link-vrtx", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbLinkVrtxArr>> reloadLinkVrtxArr() {
- List<TbLinkVrtxArr> result = this.linkVrtxManager.reload();
- return ResponseEntity.ok(result);
- }
- @ApiOperation(value = "IFSC VRTX 정보", response = TbIfscVrtxArr.class, responseContainer = "ArrayList")
- @GetMapping(path="/ifsc-vrtx", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbIfscVrtxArr>> reloadIfscVrtxArr() {
- List<TbIfscVrtxArr> result = this.ifscVrtxManager.reload();
- return ResponseEntity.ok(result);
- }
- @ApiOperation(value = "ROAD VRTX 정보", response = TbRoadVrtxArr.class, responseContainer = "ArrayList")
- @GetMapping(path="/road-vrtx", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbRoadVrtxArr>> reloadRoadVrtxArr() {
- List<TbRoadVrtxArr> result = this.roadVrtxManager.reload();
- return ResponseEntity.ok(result);
- }
- /******************************************************************************************************************/
- @ApiOperation(value = "CCTV 정보", response = TbCctvCtlr.class, responseContainer = "ArrayList")
- @GetMapping(path="/cctv", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbCctvCtlr>> reloadCctvCtlr() {
- List<TbCctvCtlr> result = this.cctvCtlrManager.reload();
- return ResponseEntity.ok(result);
- }
- @ApiOperation(value = "VMS 정보", response = TbVmsCtlr.class, responseContainer = "ArrayList")
- @GetMapping(path="/vms", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbVmsCtlr>> reloadVmsCtlr() {
- List<TbVmsCtlr> result = this.vmsCtlrManager.reload();
- return ResponseEntity.ok(result);
- }
- @ApiOperation(value = "VDS 정보", response = TbVdsCtlr.class, responseContainer = "ArrayList")
- @GetMapping(path="/vds", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbVdsCtlr>> reloadVdsCtlr() {
- List<TbVdsCtlr> result = this.vdsCtlrManager.reload();
- return ResponseEntity.ok(result);
- }
- @ApiOperation(value = "RSE 정보", response = TbRseCtlr.class, responseContainer = "ArrayList")
- @GetMapping(path="/rse", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbRseCtlr>> reloadRseCtlr() {
- List<TbRseCtlr> result = this.rseCtlrManager.reload();
- return ResponseEntity.ok(result);
- }
- @ApiOperation(value = "WCAM 정보", response = TbWcamCtlr.class, responseContainer = "ArrayList")
- @GetMapping(path="/wcam", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbWcamCtlr>> reloadWcamCtlr() {
- List<TbWcamCtlr> result = this.wcamCtlrManager.reload();
- return ResponseEntity.ok(result);
- }
- /******************************************************************************************************************/
- @ApiOperation(value = "교차로 정보", response = TbScIxrMngm.class, responseContainer = "ArrayList")
- @GetMapping(path="/sc-ixr", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbScIxrMngm>> reloadScIxr() {
- List<TbScIxrMngm> result = this.scIxrManager.reload();
- return ResponseEntity.ok(result);
- }
- @ApiOperation(value = "신호교차로 정보", response = TbScSgnlIxrMngm.class, responseContainer = "ArrayList")
- @GetMapping(path="/sc-sgnl-ixr", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbScSgnlIxrMngm>> reloadScSgnlIxr() {
- List<TbScSgnlIxrMngm> result = this.scSgnlIxrManager.reload();
- return ResponseEntity.ok(result);
- }
- @ApiOperation(value = "신호제어기 정보", response = TbScSgnlCtlr.class, responseContainer = "ArrayList")
- @GetMapping(path="/sc-sgnl", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbScSgnlCtlr>> reloadScSgnl() {
- List<TbScSgnlCtlr> result = this.scSgnlCtlrManager.reload();
- return ResponseEntity.ok(result);
- }
- @ApiOperation(value = "교차로카메라 정보", response = TbScIxrCmraMngm.class, responseContainer = "ArrayList")
- @GetMapping(path="/sc-ixr-cmra", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbScIxrCmraMngm>> reloadScIxrCmra() {
- List<TbScIxrCmraMngm> result = this.scIxrCmraManager.reload();
- return ResponseEntity.ok(result);
- }
- /******************************************************************************************************************/
- @ApiOperation(value = "공통 코드 정보", response = TbCmmnCd.class, responseContainer = "ArrayList")
- @GetMapping(path="/cmmn-cd", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbCmmnCd>> reloadCmmnCd() {
- List<TbCmmnCd> result = this.cmmnCdManager.reload();
- return ResponseEntity.ok(result);
- }
- /******************************************************************************************************************/
- @ApiOperation(value = "시설물 코드 정보", response = TbFcltFailOcrrType.class, responseContainer = "ArrayList")
- @GetMapping(path="/cmmn-fclt-cd", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbFcltFailOcrrType>> reloadCmmnFcltCd() {
- List<TbFcltFailOcrrType> result = this.cmmnFcltCdManager.reload();
- return ResponseEntity.ok(result);
- }
- /******************************************************************************************************************/
- @ApiOperation(value = "VMS IFSC 정보", response = TbVmsIfsc.class, responseContainer = "ArrayList")
- @GetMapping(path="/vms-ifsc", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbVmsIfsc>> reloadVmsIfsc() {
- List<TbVmsIfsc> result = this.vmsIfscManager.reload();
- return ResponseEntity.ok(result);
- }
- @ApiOperation(value = "VMS 심볼 라이브러리 정보", response = TbVmsSymbLib.class, responseContainer = "ArrayList")
- @GetMapping(path="/vms-symb-lib", produces = MediaType.APPLICATION_JSON_VALUE)
- public ResponseEntity<List<TbVmsSymbLib>> reloadVmsSymbLib() {
- List<TbVmsSymbLib> result = this.vmsSymbLibManager.reload();
- return ResponseEntity.ok(result);
- }
- }
|