Spaces:
Sleeping
Sleeping
File size: 2,339 Bytes
a47e303 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 |
"""
μ€μ νμΌ λ° κ²½λ‘ κ΄λ¦¬ λͺ¨λ
"""
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: λ체μ ν) |