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") | |
| CURRENT_MONTH = datetime.now().strftime("%m") # νμ¬ μ (01-12) | |
| # λ νμ¬ μ€μ (μΆν λ€λ₯Έ λ νμ¬κ° μΆκ°λ μ μμ) | |
| RENTAL_COMPANIES = { | |
| 'νκ΅λ ν': { | |
| 'input_file': os.path.join(INPUT_DIR, 'νκ΅λ ν_λ νλ£.csv'), | |
| 'mapping_file': os.path.join(MAPPING_DIR, 'team_name_mapping.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}.xls'), | |
| 'partner_code': '101388', # κ±°λμ² μ½λ (νκ΅λ ν: 101388) | |
| 'cost_center': '5020', # μ½μ€νΈμΌν°(μ΄μ2) | |
| 'expense_acct': '53000', # κΈ°λ³Έ λΉμ© κ³μ | |
| 'payable_acct': '25300', # λ―Έμ§κΈκΈ κ³μ | |
| 'cd_company': '1200', # νμ¬ μ½λ | |
| 'cd_pc': '1200', # νκ³λ¨μ | |
| 'cd_wdept': '1010', # μμ±λΆμ | |
| 'amount_field': f'{CURRENT_MONTH}μλ νλ£', # κΈμ‘ νλλͺ (νμ¬ μ κΈ°μ€) | |
| 'team_fields': [f'{CURRENT_MONTH}μ λ³κ²½PJT', f'{int(CURRENT_MONTH)-1}μ 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: λ체μ ν) |