탄소배출 시뮬레이터 (Carbon Emission Simulator)

[USER] SIMULATION NEW

1.Common
  1) simulation name
    - 자동생성 checkbox: REMOVE
    - inputbox: editable (default)

2.시뮬레이션 유형 (simulation type)
  1) if 트윈형(T) and 탄소배출량 예측(TS02) is selected
    a) 적용 모델 (model)
      - selectbox options: show data with AI_MODEL_YN='Y' (DeepL-1/DeepL-2)
      - hide 추가(Add) button

3.데이터 입력 (input data)
  1) when previous selected simulation type is 트윈형(T)
    - clear 데이터 가져오기 / 데이터 미리보기 area
  2) 데이터 가져오기 > 데이터베이스 연결 (Database connect)
    a) Databse selectbox
      - apply disable style (gray color ?)
    b) when import DB data (if 가져오기(import) button clicks)
      - display only input data FACTOR into Grid (currently, all FACTOR is displayed)
      - Grid column name : apply with {FACTOR_COLUMN} (alias is applied with FACTOR_NAME on DB_sensor.sql)
    c) if 적용 모델(MODEL) is not selected
      - alert error msg.("적용 모델을 선택해주세요.")

  3) 데이터 가져오기 > 데이터 파일 불러오기 (import csv file)
    a) when import DB data
      - same issue with No 3-2)-b)
      - TIME column is shown on last wrong (test witha attach csv file)
        ("TIME" column should display with "create_dt")
      a-1) 데이터 전처리 (data preporcessing)
        - error happens: " [KeyError : 'create_dt']"

  4) 데이터 전처리 (data preprocessing) (Common)
      a) if API takes long time (when DB data import)
        - show progress bar
        - if it is done successfully, alert msg.("데이터 전처리가 정상적으로 수행되었습니다.")

4.시뮬레이션 실행 (RUN SIMULATION)
  1) if simulation type is 트윈형(T) and 데이터 가져오기 > 데이터베이스 연결 (Database connect)
    - currently, EC_SIMULATION_RESULT data is not created
  2) if 1) if simulation type is 트윈형(T) and 데이터 가져오기 > 데이터 파일 불러오기 (Import data file) (TEST: test_data.csv)
    a) EC_SIMULATION_RESULT data : 
      - RESULT_DT : set by INPUT data's datetime ([TEST RESULT] 1st row's datetime is set into all row)

[USER] SIMULATION NEW

1.데이터 전처리 (data preprocess) button

  1) enable/disable
    - if 데이터 미리보기 (preview input data) is done, enable it (if not, disable)

  2) if clicks
    - call API : POST ​/model​/Preprocessing
    - apply API result(cleaned values) into 데이터 미리보기 (preview input data) Grid

2.시뮬레이션 실행 (RUN SIMULATION)

  1) if 데이터 미리보기 (preview input data) Grid's any column value has NULL(empty)
    - alert error msg.("값이 없는 입력 데이터 항목이 존재합니다.<br>데이터 전처리를 수행해주세요.")

[SIMULATION NEW]

1.if 시뮬레이션 유형(simulation type) is selected with

  1) 일반형(ST01)
    a) 적용 모델 (model)
      - don't show model with AI_MODEL_YN='Y' (DeepL-1/DeepL-2)

  2) 트윈형(ST02)
    a) 시뮬레이션 기간 (simulation period)
      a-1) period type (5분/시간/일) : Hide(all)
        - fixed with 5분(PT01)
      a-2) not set default period(today) (default: empty)
    b) 적용 모델 (model)
      b-1) if TWIN_SIMUL_TYPE is selected with 탄소배출량 예측(TS02)
               - can select only model with AI_MODEL_YN='Y' (DeepL-1/DeepL-2)
             else, display all MODEL (currently, AI_MODEL is not shown)

  3) if simulation type is selected again, clear previous fields
    - 분야 (ENERGY_CLS) is not cleared
    - add default option: '선택하세요' (select)

2.데이터 미리보기 (input data preview)

  1) if TWIN_SIMUL_TYPE is selected with 모델별 비교(TS01)
    a) 시뮬레이션 기간 > {PERIOD_TO}
      - can select until today on datepicker
      - but if 탄소배출량 예측(TS02), datepicker selection is no limit

    b) if AI_MODEL (DeepL-1/DeepL-2) is included in 적용 모델 (model)
         - get input data from {PERIOD_FR - 1day} ~ {PERIOD_TO}
           ex) if PERIOD_FR = '2024-10-24', get from '2024-10-23'  [Test] if  '2024-10-24' ~  '2024-10-24', get '2024-10-22' ~  '2024-10-24' (wrong) ->  TO_BE:  '2024-10-23' ~  '2024-10-24'
       else
         - get input data from {PERIOD_FR} ~ {PERIOD_TO}  [Test] if  '2024-10-24' ~  '2024-10-24', get '2024-10-23' ~  '2024-10-24' (wrong)) -> TO_BE:  '2024-10-24' ~  '2024-10-24'

    c) if MODEL is changed or added
      c-1) As-is: input data Grid is changed during some time
            To-be: just clear input data Grid

  2) if TWIN_SIMUL_TYPE is selected with 탄소배출량 예측(TS02)
    a) 시뮬레이션 기간 (simulation period)
      - get input data with {PERIOD_FR - 1day - interval} ~ {PERIOD_FR - 1day}
      - ex) if simulation period is 2024.08.01 ~ 2024.08.10 (interval: 10 days)
            get input data with 2024.07.22 ~ 2024.07.31

      [Test] if  '2024-10-24' ~  '2024-10-24', get '2024-10-22' ~  '2024-10-23' (wrong)) -> TO_BE: '2024-10-23' ~  '2024-10-23' : {PERIOD_FR - 1day - 0} ~ {PERIOD_FR - 1day}

  3) when import input data(가져오기), show progress bar

[USER] SIMULATION NEW

1.데이터 전처리 (data preprocessing)

2.RUN SIMULATION

• alert error msg (p31 on #612 : 탄소배출 시뮬레이터_화면정의서_v1.91_en_20241024.pptx)

[Test]

2.RUN SIMULATION

  1) when  input data field with NULL is existed
    a) alert msg (change)

      as-is) "값이 없는 입력 데이터 항목이 존재합니다.<br>데이터 전처리를 수행해주세요."
      to-be) "시뮬레이션 실행중 오류가 발생되었습니다.<br>Null 값이 있을 경우 시뮬레이션이 동작하지 않을 수 있습니다.<br>데이터셋을 확인해 보시기 바랍니다." (No 2 on p31)

[USER] SIMULATION NEW

1.시뮬레이션 실행 (RUN SIMULATION) > 데이터베이스 연결 (Database connect)

  1) 데이터 전처리 (date preprocessing) after import DB input data
    - import DB input data (simulation period: 2024-08-01 ~ 2024-08-02)
    - if run, no data is displayed (not work)
  2) 시뮬레이션 실행 (run simulation)
    - currently, input & result data is not created into DB

2.Run SIMULATION
  1) if MODEL is AI type (M30/M31)
    a) call API (http://218.232.78.85:9005/apidocs/)
      a-1) parameter change
        - start_date, end_date : set by selected simulation period
      a-2) response result
        - "date" : {RESULT_DT}
        - predicted_met" : {RESULT_VALUE}

[TEST]

SIMULATION TYPE: 모델별 비교(TS01), MODEL: DeepL-2, simulation period: 2024-08-02 ~ 2024-08-02, import DB data

1) RESULT DATA (check if it's right)
   - first RESULT_DT: 2024-08-01 00:00:00, last RESULT_DT: 2024-08-02 23:15:00

2) SIMULATION RESULT (/eoco2/simulation) page
  a) List/Chart
    - non-DB data (2024-07-31) is shown wrong

[USER] SIMULATION NEW

1.Run SIMULATION

  1) Test Case
    - simulation type: 모델별 비교(TS01)
    - applied MODEL: Reg-3, DeepL-2
    - simulation period: 2024-08-02 ~ 2024-08-02
    - input data: import DB data

 2) Input Data
    - get 2024-08-01 ~ 2024-08-02

 3) Simulation Result
   1) if MODEL is not AI model (Reg-3)
     - make Simulation Result of simulation period (2024-08-02 ~ 2024-08-02)

   2) if MODEL is AI model (DeepL-2)
     - make Simulation Result with API result

  3) when make Simulation Result (EC_SIMULATION_RESULT)
    a) if MODEL's RESULT_DT is same 
      - UPDATE EC_SIMULATION_RESULT
        + MODEL_CNT, MODEL_NO_n / RESULT_VALUE_n
    b) else
        INSERT EC_SIMULATION_RESULT

[TEST Result]

1.EC_SIMULATION_RESULT
  - if RESULT_DT='2024-08-02', MODEL_CNT=1 (should be 2) - fix

2.SIMULATION RESULT (/eoco2/simulation) page
  a) List/Chart
    - Reg-3 MODEL result is not displayed
  b) 시뮬레이션 결과 데이터 > excel download
    - apply like List data

[USER] SIMULATION NEW

1.데이터 입력 (input data)
  1) 데이터 가져오기 > 데이터베이스 연결 (Database connect)
    a) if selected MODEL is AI type(DeepL-1)
      a-1) FACTOR: BREEDING_NUMBER (F01)
        - get from {EC_FARM.LIVESTOCK_CNT} and set same value

[USER] SIMULATION NEW

1.Run SIMULATION

  1) if MODEL is AI MODEL (DeepL-1,Deep-2)
    a) "start_date/end_date" parameter when call API
      - currently, start_date is set with input data's create_dt because of API error
      - set by selected simulation period 

[USER] NEW SIMULATION

1.RUN SIMULATION
  1) DB: EC_SIMULATION_INPUT (if import DB input data)

    a)As-is
      - INSERT all input data

    b)To-be
      b-1) save into the file (file name: simulation/yyyymmdd/{SIMUL_SEQ}.json)
        - save json format data
          (currently, "create_dt":1722438000000 (wrong) - fix)
        - current DB INSERT logic is kept for future

      [TEST]
      if MODEL is AI MODEL (DeepL-1 / DeepL-2)
        - make json file with API json parameter (including start_date/end_date/records)

      b-2) INSERT EC_SIMULATION_INPUT (one row)
        - FILE_YN='Y'
        - INPUT_DT: current datetime
        - INPUT_FILE: created file name of b-1)

  2) 데이터 전처리(data preprocessing)

    - if it's done, the preprocessing result data should save into the file
    - when import data file(csv), the preprocessing result data should save into the csv file.

[ADMIN] NEW SIMULATION

1.데이터 가져오기 (Import input data) > DB 데이터 (DB data) / 데이터 파일 (data file)
  1) 가져오기 (import) button
    - if clicks, show progress bar until import input data is displayed into Grid list
    - currently, page is stopped until the data is loaded into Grid list