Spaces:
Sleeping
Sleeping
| """ | |
| ์ค์ ํ์ผ ๋ฐ ๊ฒฝ๋ก ๊ด๋ฆฌ ๋ชจ๋ | |
| """ | |
| 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: ๋์ฒด์ ํ) |