ERP_Preprocessor / config.py
hariqueen's picture
Setup ERP Preprocessor files
bd6d9a2 verified
raw
history blame
2.26 kB
"""
์„ค์ • ํŒŒ์ผ ๋ฐ ๊ฒฝ๋กœ ๊ด€๋ฆฌ ๋ชจ๋“ˆ
"""
import os
from datetime import datetime
# ๊ธฐ๋ณธ ํŒŒ์ผ ๊ฒฝ๋กœ ์„ค์ •
INPUT_DIR = os.path.join(os.getcwd(), 'input')
OUTPUT_DIR = os.path.join(os.getcwd(), 'output')
MAPPING_DIR = os.path.join(os.getcwd(), 'mapping')
TEMPLATE_DIR = os.path.join(os.getcwd(), 'templates')
# ๋””๋ ‰ํ† ๋ฆฌ๊ฐ€ ์—†์œผ๋ฉด ์ƒ์„ฑ
for directory in [INPUT_DIR, OUTPUT_DIR, MAPPING_DIR, TEMPLATE_DIR]:
if not os.path.exists(directory):
os.makedirs(directory)
# ํ˜„์žฌ ๋‚ ์งœ ์ •๋ณด
CURRENT_DATE = datetime.now().strftime("%Y%m%d")
# ๋ Œํƒˆ์‚ฌ ์„ค์ • (์ถ”ํ›„ ๋‹ค๋ฅธ ๋ Œํƒˆ์‚ฌ๊ฐ€ ์ถ”๊ฐ€๋  ์ˆ˜ ์žˆ์Œ)
RENTAL_COMPANIES = {
'ํ•œ๊ตญ๋ Œํƒˆ': {
'input_file': os.path.join(INPUT_DIR, 'ํ•œ๊ตญ๋ Œํƒˆ_๋ Œํƒˆ๋ฃŒ.csv'),
'mapping_file': os.path.join(MAPPING_DIR, 'test.json'),
'erp_form_file': os.path.join(TEMPLATE_DIR, 'erp_form.csv'),
'output_csv': os.path.join(OUTPUT_DIR, f'์ž๋™์ „ํ‘œ_ํ•œ๊ตญ๋ Œํƒˆ_{CURRENT_DATE}.csv'),
'output_excel': os.path.join(OUTPUT_DIR, f'์ž๋™์ „ํ‘œ_ํ•œ๊ตญ๋ Œํƒˆ_{CURRENT_DATE}.xlsx'),
'partner_code': '101388', # ๊ฑฐ๋ž˜์ฒ˜ ์ฝ”๋“œ (ํ•œ๊ตญ๋ Œํƒˆ: 101388)
'cost_center': '5020', # ์ฝ”์ŠคํŠธ์„ผํ„ฐ(์šด์˜2)
'expense_acct': '53000', # ๊ธฐ๋ณธ ๋น„์šฉ ๊ณ„์ •
'payable_acct': '25300', # ๋ฏธ์ง€๊ธ‰๊ธˆ ๊ณ„์ •
'id_write': '00616', # ์‚ฌ์›๋ฒˆํ˜ธ (๊น€ํ•˜๋ฆฌ)
'cd_company': '1200', # ํšŒ์‚ฌ ์ฝ”๋“œ
'cd_pc': '1200', # ํšŒ๊ณ„๋‹จ์œ„
'cd_wdept': '1010', # ์ž‘์„ฑ๋ถ€์„œ
'amount_field': '3์›”๋ Œํƒˆ๋ฃŒ', # ๊ธˆ์•ก ํ•„๋“œ๋ช…
'team_fields': ['3์›” ๋ณ€๊ฒฝPJT', '2์›” PJT'], # ํŒ€ ์ •๋ณด ํ•„๋“œ๋ช… (์šฐ์„ ์ˆœ์œ„ ์ˆœ)
'note_prefix': 'ํ…Œ์ŠคํŠธ ํ•œ๊ตญ๋ Œํƒˆใˆœ_PC ๋ Œํƒˆ๋ฃŒ', # ์ ์š” ์ ‘๋‘์–ด
}
}
# ๊ธฐ๋ณธ ์„ค์ •๊ฐ’
DEFAULT_ENCODING = 'utf-8'
CSV_OUTPUT_ENCODING = 'utf-8-sig' # Excel์—์„œ ํ•œ๊ธ€์ด ๊นจ์ง€์ง€ ์•Š๋„๋ก BOM ํฌํ•จ
# ERP ๊ด€๋ จ ์„ค์ •
ERP_DATA_ROW_START = 4 # ๋ฐ์ดํ„ฐ ์‹œ์ž‘ ํ–‰ (5ํ–‰)
ERP_DOCUMENT_TYPE = '11' # ์ „ํ‘œ์œ ํ˜• (11: ์ผ๋ฐ˜)
ERP_APPROVAL_STATUS = '1' # ์Šน์ธ์—ฌ๋ถ€ (1: ๋ฏธ๊ฒฐ/์ž„์‹œ)
ERP_PROCESS_STATUS = 'N' # ์ „ํ‘œ์ฒ˜๋ฆฌ๊ฒฐ๊ณผ (N: ๋ฏธ์ฒ˜๋ฆฌ/์ž„์‹œ)
ERP_DOCUMENT_GUBUN = '3' # ์ „ํ‘œ๊ตฌ๋ถ„ (3: ๋Œ€์ฒด์ „ํ‘œ)