config_for_custom_bills.py 2.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. # Path helper because Linux and Windows Paths are written differently
  2. from pathlib import Path
  3. # Bill specific Config
  4. OUTPUT_MONTH = 3 # -1 for last Month
  5. OUTPUT_YEAR = 2022 # -1 for current year
  6. OUTPUT_CUSTOMER = 'Bentomax'
  7. # User specific Parameter (COMMENT/UNCOMMENT USER AND SYSTEM)
  8. # Danny Config
  9. # USER = 'Danny'
  10. # SYSTEM = USER + ''
  11. # Nokko Config
  12. USER = 'Nokko'
  13. # SYSTEM = USER + 'Windows'
  14. SYSTEM = USER + 'Ubuntu'
  15. GLOBAL_TOOLS_DIR_PATH = {
  16. 'Danny': Path("C:/Users/Danny/Desktop/EnD and Investment/Tools/"),
  17. 'NokkoUbuntu': Path('/home/nokko/Dokumente/Business/EnD/Python/Tools/'),
  18. 'NokkoWindows': Path("E:/Business/END/PythonProjekte/Tools/")
  19. }
  20. WORKTIME_TABLE_PATH = GLOBAL_TOOLS_DIR_PATH[SYSTEM] / Path('time_recoder/time_recorded_tables/')
  21. WORKTIME_TABLE_NAME = {
  22. 'Danny': 'work_time_danny.xlsx',
  23. 'NokkoUbuntu': 'nokko_ubuntu.xlsx',
  24. 'NokkoWindows': 'nokko_windows.xlsx'
  25. }
  26. OVERTIME_TABLE_NAME = {
  27. 'Danny': 'overtime_danny.xlsx',
  28. 'Nokko': 'overtime_nokko.xlsx'
  29. }
  30. # Docx Builder
  31. DOCX_INPUT_PATH = GLOBAL_TOOLS_DIR_PATH[SYSTEM] / Path('fast_excel_to_bill/test_folder/Templates/templeta.docx')
  32. LIST_OF_KEYS = ['Arbeitszeit', 'Task']
  33. ROUND_TIME = 60
  34. SAVE_OVERTIME_IN_TABLE = WORKTIME_TABLE_PATH / OVERTIME_TABLE_NAME[USER]
  35. 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
  36. list_of_place_holders = ['?Netto?','?zzgl.?', '?gesamt?', 'insertdate'] # variable cuz search can be implemented
  37. # Burden Date
  38. payment_request_range = 30 # variable cuz customer contract data can be found
  39. income_per_hour = 28 # variable cuz search of employee core data
  40. FIRST_TABLE_KEYS = ['KW', 'Zeit in Stunden', 'Betrag in Euro']
  41. NUMBER_OF_COLUMNS_FIRST_TABLE = len(FIRST_TABLE_KEYS)
  42. SECOND_TABLE_KEYS = ['KW', 'Leistungsübersicht']
  43. NUMBER_OF_COLUMNS_SECOND_TABLE = len(SECOND_TABLE_KEYS) # variable cuz searching of number of columns can be done
  44. # Excel Pathes
  45. employee_worktime_table_pathes = [#WORKTIME_TABLE_PATH / WORKTIME_TABLE_NAME['Danny'],
  46. WORKTIME_TABLE_PATH / WORKTIME_TABLE_NAME['NokkoUbuntu'],
  47. WORKTIME_TABLE_PATH / WORKTIME_TABLE_NAME['NokkoWindows']] # Variable cuz search of dir of tables can be implemented