123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263 |
- # Path helper because Linux and Windows Paths are written differently
- from pathlib import Path
- # Bill specific Config
- OUTPUT_MONTH = 3 # -1 for last Month
- OUTPUT_YEAR = 2022 # -1 for current year
- OUTPUT_CUSTOMER = 'Bentomax'
- # User specific Parameter (COMMENT/UNCOMMENT USER AND SYSTEM)
- # Danny Config
- # USER = 'Danny'
- # SYSTEM = USER + ''
- # Nokko Config
- USER = 'Nokko'
- # SYSTEM = USER + 'Windows'
- SYSTEM = USER + 'Ubuntu'
- GLOBAL_TOOLS_DIR_PATH = {
- 'Danny': Path("C:/Users/Danny/Desktop/EnD and Investment/Tools/"),
- 'NokkoUbuntu': Path('/home/nokko/Dokumente/Business/EnD/Python/Tools/'),
- 'NokkoWindows': Path("E:/Business/END/PythonProjekte/Tools/")
- }
- WORKTIME_TABLE_PATH = GLOBAL_TOOLS_DIR_PATH[SYSTEM] / Path('time_recoder/time_recorded_tables/')
- WORKTIME_TABLE_NAME = {
- 'Danny': 'work_time_danny.xlsx',
- 'NokkoUbuntu': 'nokko_ubuntu.xlsx',
- 'NokkoWindows': 'nokko_windows.xlsx'
- }
- OVERTIME_TABLE_NAME = {
- 'Danny': 'overtime_danny.xlsx',
- 'Nokko': 'overtime_nokko.xlsx'
- }
- # Docx Builder
- DOCX_INPUT_PATH = GLOBAL_TOOLS_DIR_PATH[SYSTEM] / Path('fast_excel_to_bill/test_folder/Templates/templeta.docx')
- LIST_OF_KEYS = ['Arbeitszeit', 'Task']
- ROUND_TIME = 60
- SAVE_OVERTIME_IN_TABLE = WORKTIME_TABLE_PATH / OVERTIME_TABLE_NAME[USER]
- docx_output_dir_path = GLOBAL_TOOLS_DIR_PATH[SYSTEM] / Path('fast_excel_to_bill/test_folder/') # Variable cuz search of dir of customer can be implemeted
- list_of_place_holders = ['?Netto?','?zzgl.?', '?gesamt?', 'insertdate'] # variable cuz search can be implemented
- # Burden Date
- payment_request_range = 30 # variable cuz customer contract data can be found
- income_per_hour = 28 # variable cuz search of employee core data
- FIRST_TABLE_KEYS = ['KW', 'Zeit in Stunden', 'Betrag in Euro']
- NUMBER_OF_COLUMNS_FIRST_TABLE = len(FIRST_TABLE_KEYS)
- SECOND_TABLE_KEYS = ['KW', 'Leistungsübersicht']
- NUMBER_OF_COLUMNS_SECOND_TABLE = len(SECOND_TABLE_KEYS) # variable cuz searching of number of columns can be done
- # Excel Pathes
- employee_worktime_table_pathes = [#WORKTIME_TABLE_PATH / WORKTIME_TABLE_NAME['Danny'],
- WORKTIME_TABLE_PATH / WORKTIME_TABLE_NAME['NokkoUbuntu'],
- WORKTIME_TABLE_PATH / WORKTIME_TABLE_NAME['NokkoWindows']] # Variable cuz search of dir of tables can be implemented
|