Ah!dZddlZddlZddlZddlZddlZddlmZddlm Z ddl m Z ddl m Z ddlmZddlmZdd lmZdd lmZmZmZddlZddlZdd lmZdd lmZdd lmZmZm Z m!Z!m"Z"m#Z#ddl$m%Z%m&Z&m'Z'm(Z(m)Z)m*Z*m+Z+m,Z,m-Z-m.Z.m/Z/m0Z0m1Z1ddl2m2Z2m3Z3ddl4Z4ddl5Z5ddl6Z6ddl7Z7ddl8Z8ddl9m:Z:ejvejxddl=m>Z? ddl=m@Z@ddl=Z=ddlBmCZCmDZDmEZEmFZFmGZGe2jjdZJdZKdZLdZMdgZNdZOdhdZPdZQdZRdZSd ZTd!ZUd"ZVd#ZWd$ZXdid%ZYd&ZZd'Z[d(Z\d)Z]d*Z^d+Z_d,Z`d-Zad.Zbd/Zcd0Zdd1Zed2Zfd3Zgd4Zhd5Zid6Zjd7Zkd8Zld9Zmd:Znd;Zodhd<Zpdhd=Zqdhd>Zrd?Zsd@ZtdAZudBZvdCZwdDZxdEZydFZzdGZ{dHZ|dIZ}dJZ~dKZdLZdMZdNZdjdOZdPZdQZdRedSedTefdUZddddddddddddVdW dXedYeedZeed[eed\eed]eed^eed_eed`eedaeedbeedceeeefddedTeeeeeeffdeZdkdfefdgZy#eA$rdZ@YdwxYw)lu Hier sind die alleinstehende Funktionen Funktionen: - send_msg_telegram: Asynchrones Senden einer HTML-formatierten Nachricht an IT Gruppe - generate_uid: Generiert eine einzigartige UID Imports: - random: Für die Generierung zufälliger Nummern. - string: Für den Zugriff auf Zeichensätze. - telegram: Für die Interaktion mit der Telegram API. - telegram.ext: Für die Verwaltung von Telegram Bots und deren Nachrichtenverarbeitung. N)service_account)build)MediaFileUpload) HttpError) Credentials)InstalledAppFlow)secure_filename)OptionalDictTuple)geocoder)region_code_for_country_code)headers_tookanjson_api_key_tookanPLANDAY_CLIENT_IDPLANDAY_REFRESH_TOKEN lara_bot_id onduty_it) get_all_data_from_fk_tableget_value_by_idget_data_from_fk_tableget_all_user_idget_cred_google_service_accupdate_child_datainsert_child_datadelete_child_datainsert_partner_dbupdate_partner_datadelete_partner_dataget_doc_fk_tableinsert_docs_db)datetime timedelta)ZoneInfo)level) __version__)__version_info__)rrrrr) ApplicationCommandHandler ContextTypesMessageHandlerfilters%Y%m%dcrKtj|}|j||dd{y7w)u Senden Nachrichten an Telegramuser/Grupper Args: TOKEN String: Token für Telegram Bot msg String: Nachricht id int: id für den Chat HTML) parse_modeN)telegramBot send_message)TOKENmsgidbots 1/home/janakan/Projects/talentsphere/standalone.pysend_msg_telegramr99s1 ,,u C  2sv  666s -757ct} tj}tj|}|dt tj ddddzjdddz}dt tj dd ddzjd d d}dt tj dd ddzjd d d}d |z|z|z}||vr|j||S) u Generiert eine UID mit der vorgegebenen Vorlage. Dies wurde von der Gastro Kurier GmbH vorgegeben. Returns: str: rückgabe einer UID 0000000riNi0000iUID) rstringascii_uppercaserandomchoicehexrandintzfilladd) existing_uidsletters first_charpart1part2part3 hex_values r8 generate_uidrQGs$%M ((]]7+ i#fnnQ .J*KAB*OOVVWXYZ\Z]^^#fnnQ56qr::AA!DRSI#fnnQ56qr::AA!DRSIEME)E1 M )   i (  zgoogle/credentials.jsonz%https://www.googleapis.com/auth/drivec |jj|ddj}y#t$rO}t j d||j jdk(rt j d|Yd}~yd}~wwxYw)Nr6TfileIdfieldssupportsAllDriveszAn error occurred: %sizFolder with ID %s not found.F)filesgetexecuterloggingerrorrespstatus)service folder_idfolderr\s r8check_folder_existsrbest$$IdUY$Zbbd  -u5 ::   # MM8) D s03 B ABB cJt} tjj|t} tdd|}t||sd |d S|d |r|gngd } |jj|ddj}|jd}|S#t $r }t jd|Yd}~yd}~wwxYw#t $r }t jd|Yd}~y d}~wwxYw#t$r } t jd| Yd} ~ yd} ~ wwxYw)an Creates a folder in Google Drive with the given name, within a specified parent folder. Args: folder_name (str): The name of the folder to create. parent_id (str): The ID of the parent folder in which to create the new folder (default is set). Returns: str: The URL of the created folder, or a message indicating an error. scopes.Failed to load service account credentials: %sN*Error loading service account credentials.drivev3 credentials%Failed to build the Drive service: %s!Error building the Drive service.zParent folder with ID z not found or inaccessible.z"application/vnd.google-apps.folder)namemimeTypeparentsid, webViewLinkT)bodyrVrW webViewLinkz,An error occurred during folder creation: %szError creating the folder.)rrrfrom_service_account_infoSCOPES Exceptionr[r\rrbrXcreaterZrYr) folder_name parent_id cred_jsonrker_ file_metadatafile folder_urlr\s r8create_google_folderrps$,-I<%11KK fL& 3;? w 2' {2MNN8"+I;M,}}%%=ARfj%kssuXXm, 5 < FJ;< 3 =qA23( , DeL+,sG%B!C AC9! C *CC  C6C11C69 D"DD"c L|||d||ddd}|jttjd|t}|j }|ddk(r|j dk(r|d d Stjttd |d |jd ty)z_summary_ Args: phone (_type_): Phonenumber username (_type_): username firstname (_type_): firstname lastname (_type_): lastname email (_type_): email Returns: fleet_id int: Id of Tookan z 0800!Dinner1558633z-120)emailphoneusernamepassword first_name last_nameteam_idtimezonez&https://api.tookanapp.com/v2/add_agentjsonheadersr^datafleet_idzTookan acc creation fail of :  | TalentsphereN) updaterrequestspostrr status_codeasynciorunr9rtextr)rr firstnamelastnamervalresponsers r8create_tookan_accrs! CJJ"#}}ECYghH ==?D H~   3 &< + + KK!+1MeWTVW_WdWdVeet/uxABC rRc|||d}|jttjd|t}|j }|ddk(ryy)a Blocks or unblocks a user in the Tookan system based on the provided fleet ID and block status. Args: fleet_id (int): The unique identifier for the Tookan user to be blocked or unblocked. block_status (int): The status indicating whether to block (1) or unblock (0) the user. Default is 1 (block). Returns: dict: The response data from the Tookan API, indicating success or failure of the operation. )r block_status block_reasonz4https://api.tookanapp.com/v2/block_and_unblock_fleetrr^rTF)rrrrrr)rrreasonrrrs r8update_tookan_user_statusrsU$ C JJ"#}}SZ]guvH ==?D H~ rRctt}tjd||}|j }|j dk(r|ddr|ddSy)a Retrieves the department name of a Planday employee using their unique Planday ID. This function sends a GET request to the Planday API to fetch employee details based on the provided Planday ID. It extracts and returns the department name from the response data. Parameters: - planday_id (int): The unique identifier of the employee in the Planday system. Returns: - str or None: The name of the department associated with the employee if found; otherwise, None. Raises: - requests.exceptions.RequestException: An error from the `requests` library if the HTTP request fails. - KeyError: If the expected 'departmentNames' key is not found in the JSON response. Note: - Ensure that the Planday API credentials and client ID are correctly configured in the environment. - The function assumes that the employee has at least one department assigned; if not, it returns None. .https://openapi.planday.com/hr/v1.0/employees/)rrremployeeGroupsN)get_planday_tokanrrrYrr) planday_idplanday_headersrrs r8get_user_planday_employeeGroupsrsa*((9:O||LZLYcrsH ==?Ds" <( )< 01 1 rRc\tt}d|}|ytj|}d|di} t j |i|ddi|}t |j|j|jdk(ryy #tj$r}t d |d}~wwxYw) a Reactivates a Planday employee account and assigns them to specified employeeGroups. This function sends a PUT request to the Planday API to reactivate an employee account identified by the provided Planday ID. It also assigns the employee to the given list of department IDs. Parameters: - planday_id (int): The unique identifier of the employee in the Planday system. - employeeGroups (list of int): A list of department IDs to which the employee will be assigned upon reactivation. Returns: - bool: True if the reactivation and assignment were successful (HTTP status code 200), False otherwise. Raises: - requests.exceptions.RequestException: An error from the `requests` library if the HTTP request fails. Note: - Ensure that the Planday API credentials and client ID are correctly configured in the environment. - The function assumes that the provided department IDs are valid and exist in the Planday system. rNTr Content-Typeapplication/jsonrrFRequest failed: ) rrrloadsrputprintrrRequestException)rrrurlpayloadrr{s r8+move_planday_acc_from_DNF_to_employeeGroupsrs*((9:O ::, GCZZ/N.)9:G<< KK8JK  h""HMM2   3 &  $ $  $% sA BB+B&&B+c|ddd}tjd|}tj|j}|d}d|z|d}|S) a Obtain authorization headers for accessing the Planday API by using a refresh token to request a new access token. This function sends a POST request to the Planday authentication endpoint with the client ID, grant type, and a predefined refresh token. It extracts the access token from the response and prepares an authorization header that can be used in subsequent API requests to Planday. Parameters: - client_id (str): The client ID associated with the Planday API credentials. Returns: - dict: A dictionary containing the headers necessary for authenticated API requests. This includes: - 'Authorization': A bearer token format of the access token. - 'X-ClientId': The client ID passed to the function. Raises: - requests.exceptions.RequestException: An error from the `requests` library if the HTTP request fails. - KeyError: If the expected 'access_token' is not found in the JSON response. Note: - The refresh token is hardcoded in the function, which is not recommended for production code. It's advisable to secure such tokens and make them configurable through secure means. refresh_tokenUZnpFHpVpkKmkBx6y4AG5A) client_id grant_typerz$https://id.planday.com/connect/tokenr access_tokenz Bearer %s) Authorizationz X-ClientId)rrrrr)r data_plandayresponse_planday json_resp token_plandayrs r8rr(s^0"+/\tvL}}%KR^_ +001In-M%}4G NrRc|jd}td}|D]$}|djd}||k(s|dcSy)aY Retrieve the department ID for a given department name from a list of departments. This function splits the provided department name to extract the last word, which is assumed to represent a unique department code. It then queries a fictional database or data structure containing department details and searches for a matching department code within these details to return the corresponding department ID. Parameters: - department_name (str): The full name of the department, where the last word is expected to be a unique code. Returns: - int or None: The unique department ID corresponding to the given department name. Returns None if no matching department is found. Raises: - KeyError: If 'department_name' key is not found in any item of the planday_departments list. Example Usage: >>> get_department_id("Finance Department A123") 101 # Assuming '101' is the ID associated with "Finance Department A123" Note: - The function `get_all_data_from_fk_table` is assumed to be a pre-existing function that retrieves all department data from a source such as a database or a flat file. The structure of the returned data is assumed to be a list of dictionaries, where each dictionary represents a department with keys including 'department_name' and 'department_id'. planday_departmentsdepartment_name department_idNsplitr)r ou_code_inputritemou_code_plandays r8get_department_idrMs^:$))+B/M45JK#)01779"= m +( ()rRc|jd}td}|D]$}|djd}||k(s|dcSy)a Retrieves the unique group ID associated with a specified department name from a predefined list of employee groups. This function extracts the last word from the given department name, treating it as a unique identifier code. It then searches through a dataset of employee groups for a matching code. If a match is found, the associated group ID is returned. Parameters: - department_name (str): The name of the department, where the last word is expected to be the unique identifier code. Returns: - int or None: The group ID associated with the provided department name if found, otherwise None. Raises: - KeyError: If 'name' or 'groupId' keys are missing in any of the dictionaries within the list returned by `get_all_data_from_fk_table`. Note: - The `get_all_data_from_fk_table` function is assumed to access a database or some form of persistent storage to retrieve a list of dictionaries, each representing an employee group with at least 'name' and 'groupId' keys. - This function does not handle multiple matches; it returns the group ID for the first match found. Example Usage: >>> get_employee_group_id("Sales Division X200") 500 # Assuming '500' is the group ID for "Sales Division X200" This function is particularly useful for systems where department or group identifiers are embedded in descriptive text fields and consistency in naming conventions is maintained. rplanday_employee_grouprngroupIdNr)rrplanday_groupsrrs r8get_employee_group_idrqs_<$))+B/M/0HIN#v,,,.r2 m + ? "# rRc |d|d|d| } t| } tt}tdd|d}t |}t ||t |}t|}||||g|g||dd|| | | d }tjd || }|j}t ||jd k(r|d dStjttd |j dt"y)a Creates a new employee account on the Planday platform using provided personal and departmental details. This function compiles an employee's information into a formatted request to the Planday API. It handles the assembly of complex objects like addresses and phone numbers, resolves department and group IDs, and posts this data to the Planday HR endpoint to create an employee record. Parameters: - firstname (str): The first name of the employee. - lastname (str): The last name of the employee. - email (str): The email address of the employee. - department (str): The department ID used to fetch the department's name and unique identifier. - phone (str): The employee's cell phone number. - prefix (str): The dial code prefix for the employee's phone number. - address (str): The street address of the employee. - postal_code (str): The postal code of the employee's address. - location (str): The city or locality of the employee's address. - salutation_id (int): The ID used to fetch and determine the salutation and gender of the employee. - country (str): The country of the employee's address. - birthDate (str): The birth date of the employee in ISO 8601 format (YYYY-MM-DD). Returns: - int or None: Returns the unique Planday employee ID if the creation is successful, otherwise None. Raises: - requests.exceptions.RequestException: If the HTTP request to the Planday API fails. - KeyError: If expected keys are missing from the API response. Example Usage: >>> create_planday_acc("John", "Doe", "john.doe@example.com", "5", "555-1234", "+1", "123 Elm St", "90210", "Springfield", 1, "USA", "1980-01-01") 12345 # Assuming the Planday API returns an employee ID of 12345 Note: - This function directly interacts with external services (Planday API) and expects certain helper functions to provide necessary preprocessing of input data (e.g., `get_department_id`, `get_gender`). - The function assumes that all helper functions are implemented correctly and available in the scope. - It is assumed that the API keys and client IDs are correctly configured in the environment. ,  users_regionr6regionN) firstNamelastNameuserName departmentsr cellPhonecellPhoneCountryIdcellPhoneCountryCodegenderstreet1 birthDatez-https://openapi.planday.com/hr/v1.0/employeesrrrzPlanday acc creation fail: r) get_genderrrrrrrget_country_code_by_dial_coderrrrrrr9rrr)rrr departmentrprefixaddress postal_codelocation gender_idcountryrrrrrremployeeGroup_idphone_country_coderrrs r8create_planday_accrsP K=(2gY?G  "F'(9:O%nd:xPO%o6M /=),_=6v>%+,$QRj 2 C}}LVelopH ==?D $Ks"F|D!! KK!+1LX]]O[j/kmvwx rRcT|#tjjd}tt}|||d}d|} t j |||}t|j|j|jdk(ryy#t j$r }Yd}~yd}~wwxYw) a Deactivates an employee account on the Planday platform using the provided employee ID. Sends a PUT request with required JSON payload. Parameters: - employee_id (int): The employee's ID. - reason (str): Reason for deactivation. - keep_shifts (bool): Whether to keep the employee's existing shifts. - date (str): Deactivation date in YYYY-MM-DD format. Defaults to today. Returns: - bool: True if successful (204), False otherwise. Nz%Y-%m-%d)dater keepShiftsz9https://openapi.planday.com/hr/v1.0/employees/deactivate/rrTF) r"todaystrftimerrrrrrrr) employee_idr keep_shiftsrrrrrr{s r8deactivate_planday_accrs  |~~((4'(9:O!G Fk] SC <<_7K h""HMM2   3 &  $ $sAB B'"B'ctt}ddgi}d|} tj|||}t |j |j |j dk(ryy#tj$r }Yd}~yd}~wwxYw)Nrih)rrrTF)rrrrrrrr)rrrrrr{s r8move_planday_acc_DNFrs'(9:O6(G ;;- HC <<_7K h""HMM2   3 &  $ $sAA$$B<Bctdd|d}t|}tt}d|}d|gi} t j |i|ddi|}|j d k(ry y #tj$r}td |d }~wwxYw)ak Reactivates an employee account on the Planday platform using the provided employee ID and assigns them to the given department. Parameters: - employee_id (int): The employee's ID. - department (int): The internal region ID which maps to a Planday department. Returns: - bool: True if successful (204), False otherwise. rr6rz9https://openapi.planday.com/hr/v1.0/employees/reactivate/rrrrrTFrN) rrrrrrrrr) rrrrrrrrr{s r8reactivate_planday_accrs&ndJQO%o6M'(9:O Ek] SC  G << KK8JK    3 &  $ $  $% s-A##B 6BB ci}g}tjD]c}t|dd}|stj|}|dkDs.d|}|j |||j |j||de|j ddtd|Ds|j ddddt|jd Dcgc] \}}||d  }}}|jd ||fScc}}w) Nalpha_2r+)r region_code dial_codez+383XKc3,K|] }|ddk(yw)rrN).0xs r8 z,get_country_dialing_codes..Ss;Aq4';sKosovoc$t|dddS)Nrr)intrs r8z+get_country_dialing_codes..Yss1Q48}rR)key)rrc |dS)Nrrr s r8r z+get_country_dialing_codes..[s 9rR) pycountry countriesgetattr phonenumberscountry_code_for_region setdefaultappendrnanysorteditemssort) unique_codesrcrcccdialdrcountry_dial_codes_uniques r8get_country_dialing_codesr BsLI  X Q 4 (   1 1" 5 6rd8D  # #D" -   QUV W XFD) ;; ;XdQWXY <--/5LM! Aq*!!NN-N. $i // !sC<c|jdsd|z} t|dd}t|}|S#t$r }Yd}~yd}~wwxYw)a Converts a telephone dialing code to its corresponding ISO country code. This function normalizes the input dial code to ensure it starts with a '+', and then attempts to map this dialing code to a country's ISO code using the country's numeric code. The conversion relies on parsing the dial code into a numeric country code and then finding the corresponding ISO country code. Parameters: - dial_code (str): The international telephone dialing prefix for a country, which may or may not start with '+'. Returns: - str or None: The ISO country code associated with the given dial code if found; otherwise, None. Raises: - ValueError: If the conversion of the dial code to an integer fails or if the `region_code_for_country_code` does not recognize the numeric country code. Example Usage: >>> get_country_code_by_dial_code('+1') 'US' # Assuming '+1' corresponds to the United States Notes: - The function prints an error message and returns None if it encounters an error during the process, including improper input formats or unrecognized dial codes. - It assumes the presence of a `region_code_for_country_code` function or similar utility that maps numeric country codes to their ISO country codes. This function is particularly useful for applications that need to associate telephone numbers with countries, such as in telecommunications software or geographic data processing. rrN) startswithrrrv)r country_coderr{s r8rr_sTB    $)O 9QR=) 2<@  s3 AAcd|k(ryy)a Determines the gender based on the provided salutation. This function compares the given salutation to common gender-specific titles used in French ("Monsieur") and German ("Herr") to determine the gender. If the salutation matches these male titles, it returns 'Male'. Otherwise, it assumes the gender is 'Female'. Parameters: - salutation (str): The salutation or title used to address an individual, typically indicating their gender. Returns: - str: 'Male' if the salutation indicates a male individual, 'Female' otherwise. Example Usage: >>> get_gender("Monsieur") 'Male' >>> get_gender("Frau") 'Female' Note: - This function currently supports a limited range of salutations and assumes any non-specified salutations are female. Additional salutations can be added to expand coverage or improve accuracy. - The function is designed with specific cultural norms in mind and might not be applicable globally without modifications. rMaleFemaler) salutations r8rrs4 JrRcd}|dD]}|djd}|djd}|||}|||}i}i}t|jj|j} | D]4} |j | } |j | } | | k7s+| || <| || <6|r|ni||<|r|ni||<|S)a Analyzes changes between 'content_old' and 'content_new' within the provided data dictionary, identifying differences in dictionary-formatted string values. This function processes a list of rows contained in `data_dict`. Each row is expected to have two entries: 'content_old' and 'content_new', which are strings that represent dictionaries. It compares these dictionary entries for each row, extracts differences, and updates the rows with dictionaries reflecting changes in values for overlapping keys. Parameters: - data_dict (dict): A dictionary containing keys 'data' and 'columns'. 'data' should be a list of lists where each inner list represents a row of data. 'columns' should be a list of column names indicating where 'content_old' and 'content_new' are positioned. Returns: - dict: The same `data_dict` input dictionary where the 'content_old' and 'content_new' fields in each row have been replaced with dictionaries only containing keys that had different values between old and new. Raises: - IndexError: If 'content_old' or 'content_new' are not found in the 'columns' list. - SyntaxError, ValueError: These exceptions may be raised and caught within the helper function `load_dict` due to improper formatting or content in the string representations of the dictionaries. Example Usage: >>> data = { 'columns': ['id', 'content_old', 'content_new'], 'data': [ [1, "{ 'a': 1, 'b': 2 }", "{ 'a': 1, 'b': 3 }"] ] } >>> compare_detailed_changes(data) {'columns': ['id', 'content_old', 'content_new'], 'data': [[1, {}, {'b': 3}]]} Note: - The function assumes the string representations in 'content_old' and 'content_new' are valid Python dictionaries expressed as strings. Errors in formatting can lead to empty dictionaries being processed. c tj|S#t$r }icYd}~Sd}~wt$r }icYd}~Sd}~wwxYwNast literal_eval SyntaxError ValueError)rr{s r8 load_dictz:compare_detailed_changes_administration..load_dicts; ##D) ) I I s  ?'? ?:??rcolumns content_old content_new)indexsetkeys intersectionrY) data_dictr0row index_old index_newr2r3differences_olddifferences_new common_keysr  old_value new_values r8'compare_detailed_changes_administrationrAsN Di(..}= i(..}= I/ I/ +**,-::;;K;K;MN  1C#,I#,II%'0$'0$  1-<I,;I'D* rRc d}|D]}|jdgD] }|| |jdgD]r}d}d|dvr|dd}||d|d<d|d <|d }|d k(r d |d<||d <|d k7r|djdd|dk(rd |d <|djd dt|jdgD]}|djdxs|djd}|djdd|||d d k(rd |d<n|d dk(rd |d <n d|d<d|d <|r||d<|djd d|jdgD]} | djdxs| djd| d<|| | ds | drd | d<n| ds | drd | d <n d| d<d| d <| d d k(rd | d<n| d dk(rd | d <n d| d<d| d <| djd d|S)aY Compares old and new content in a list of user data entries to identify changes, additions, and deletions, and marks each entry accordingly. Process: - Defines a helper function `compare_content` that: - Compares `content_old` and `content_new` for each row to identify differences. - Stores differences in separate dictionaries, `differences_old` and `differences_new`. - Flags new keys in `content_new` that do not exist in `content_old`. - Extracts the `operation` field to track whether the entry was inserted, updated, or deleted. - Iterates through each user, partner, children, and file data entry in `data_list`: - Compares the content of each entry and marks entries as added or deleted based on the operation. - Adds metadata like deletion reasons, identifiers, and other relevant attributes. Args: - data_list (list of dicts): List of dictionaries where each dictionary contains user data, including old and new content, operations, and other metadata. Returns: - list of dicts: The modified `data_list` with additional keys indicating added or deleted entries, and populated with old/new content differences. Example Usage: - Use this function to track changes across user data, showing added, deleted, or modified records. Notes: - Assumes data entries contain fields like `content_old`, `content_new`, and `operation` for comparisons. - Handles cases where some data fields are missing or added between old and new content. c |jdi}|jdi}i}i}t|jj|jj dh}|D]4}|j|}|j|}||k7s+|||<|||<6|jd|jdd} | |d<|r|ni|d<|r|ni|d<|jD]}||vs||||<|S)a Compares `content_old` and `content_new` within a row to identify field changes, tracking differences and storing them in `differences_old` and `differences_new`. Process: - Retrieves shared keys between old and new content, ignoring `operation`. - Checks for differences in each common key and stores them. - Flags any new keys in `content_new` that are not in `content_old`. - Extracts `operation` from either old or new content. Args: - row (dict): A dictionary containing `content_old` and `content_new`. Returns: - dict: The modified row with differences and operation flags. r2r3 operationN)rYr5r6r7 difference) r9r2r3r<r=r>r r?r@rDs r8compare_contentz7compare_detailed_changes_users..compare_contents*&ggmR0 ggmR0 +**,-::;;K;K;MNYY[fZgh  1C#,I#,II%'0$'0$  1 OOKd1ST $K0?_RM0?_RM##% 8C+%'23'7$ 8 rR user_data partner_dataNpartner_delete_reasonr3FdeletedaddedrDdeleteT delete_reasoninsert children_datar2rUserId identifier files_datarn)rYpop) data_listrFentryuser_row partner_rowrMrD child_rowr files_rows r8compare_detailed_changes_usersrZs@.bH< +r2 &H H % &!99^R8 >K M&+m*DD +M :;R S K (&+K "#(K $K0IH$)- I&/< O,H$M*../FMH$'+ G$  & * *; =' >,?B7 1+> $ R8 # R8 &??>2>&??>2>'OOOR@'OOOR@$r:$r:%( }$E  Iy [ ! ( (((*   } M 2 2*3}+=+>?  %,,#%#,.   #m"4 4*3}+=+>?  %,,#,#%. %((8:J$K  Iy ^ $ + +((-    3'7#8 8-c2B.C.DE  (//#%#,1  ! "S)9%: :-c2B.C.DE  (//#,#%1 %((9;L$M  Iy _ % , ,((.    !C(9$: :.s3D/E/FG  )00#%#,2  " #c*;&< <.s3D/E/FG  )00#,#%2 %($G  Iy \ " ) )((+   ~ ^!4 4+C,?,@A  &--#%#,/   3~#6 6+C,?,@A  &--#,#%/  !ku"n OrRclt|trtj|}n|}d|vr|gggdS|S)a Converts a flat dictionary to a structure with 'user_data', 'children_data', and 'partner_data' if they don't already exist. If they already exist, it leaves the structure unchanged. If 'user_data', 'children_data', or 'partner_data' fields are missing, it wraps the original data into 'user_data' and sets 'children_data' and 'partner_data' as empty lists. rG)rGrOrHrfstrr,r-) json_data json_data_defs r8rgrg6sJ)S!((3 ! )#(  rRcgd}|D]a}|dk(rd}n|}|dk(rtddd}ntd|zdd}|D]-}||vst||t|d k(s&|d ||</c|S) a Replaces foreign key identifiers in a given dictionary with their corresponding descriptive data from database tables. This function examines specified keys in the input dictionary that are considered foreign keys. For each foreign key, it fetches the actual descriptive data from a database table using a helper function `get_data_from_fk_table`. It then replaces the numeric foreign key ID in the dictionary with the fetched descriptive data. Parameters: - data (dict): A dictionary containing key-value pairs, where the keys include foreign key references that need to be resolved to more descriptive data. Returns: - dict: The modified dictionary where foreign key values have been replaced with their corresponding descriptive data. Raises: - KeyError: If a key expected to contain a foreign key ID does not exist in the dictionary. - ValueError: If there are issues converting data types during comparisons or data fetching. Example Usage: >>> data_dict = { 'approval': '1', 'civil_status': '2', 'fleet': '3' } >>> updated_data = get_fk_data_from_dict(data_dict) >>> print(updated_data) {'approval': 'Approved', 'civil_status': 'Married', 'fleet': 'FleetName'} Notes: - The `get_data_from_fk_table` function is assumed to return a list of dictionaries, each containing an 'id' and a 'description' key. The function uses these keys to replace the foreign key IDs in the `data` dictionary. - This function only updates the dictionary if the foreign key is present and a match is found; otherwise, the original values remain unchanged. - The table name is generated by prefixing 'users_' to the key, except for 'salutation', which maps to 'salution' in the database. This function is useful for resolving foreign keys to human-readable information before presenting data in user interfaces or reports. ) approval civil_statusfleetrr'status_application status_worktyprpartner_approvalr'salutionrusers_approvalrTusers_r6 description)rrz)rkey_listr key_db real_datareals r8get_fk_data_from_dictrOsZWH , FF $ $./?DII.x&/@!TJI Dd{tCy>Sd_4 $] 3DI  ( KrRcj|D]}|jdgD]$}t|d|d<t|d|d<&|jdgD]$}t|d|d<t|d|d<&|jdgD]$}t|d|d<t|d|d<&|S)a Processes a list of dictionaries containing 'user_data' and 'children_data', replacing foreign key identifiers in 'content_old' and 'content_new' with descriptive data using get_fk_data_from_dict. Args: - data_list (list): A list of dictionaries, where each dictionary contains 'user_data' and 'children_data', and each data item has 'content_old' and 'content_new' keys. Returns: - list: The processed list with foreign key IDs replaced by descriptive data in 'content_old' and 'content_new'. rGr2r3rHrO)rYr)rTrUrVrXs r8process_fk_data_for_listrs W +r2 UH&;H]L".!5!5!!5!<8):KK(--J rRcFtj}|j}|Sr*)r"ryear)r current_years r8get_current_yearrs <<>L $$L rRcg}|jD]\}}|jds|dd}t|d}|dk(rd}n'|dk(rd}n|dk(rd }n|d k(rd }n|d k(rd }n|dk(rd}t||krJd|}||vr|j d||in|j dt it||krJ||||<d|}||v||d<|D]}d |vrd|d < d|d <|S)Nchildr?r FirstnamerLastnamerGenderr Birthdate birth_date Allowanceschild_allowancesNotenote childUserIdra childDeleterLrr)rr"rrirrQ) form_datachildrenr valuefieldr4 user_id_key delete_keyrs r8extract_children_datarsXHoo'#@ U >>' ""IEBLE #$*$#(" +%$,&*&h-5( +E73 )+OOY +0F$GHOOY $?@h-5(&+HUOE "'ug.J(2i(?HUOH %G#@H* U *()E$ %()E$ % * OrRc t|d<|S)aU Adds a unique user ID to the provided data dictionary. Process: - Generates a unique identifier for the user by calling `generate_uid()`. - Adds this generated ID to the `data_dict` under the key 'user_id'. - Returns the modified dictionary with the added 'user_id'. Args: - data_dict (dict): The dictionary containing user data that will be augmented with a new 'user_id'. Returns: - dict: The input dictionary with an additional key-value pair: - 'user_id' (str): The unique identifier generated for the user. Example Usage: - Use this function to add a unique 'user_id' to user data before saving it to a database or performing other operations. Notes: - This function assumes the existence of `generate_uid`, a function that generates unique IDs. ra)rQ)r8s r8 add_user_idrs0(>Ii rRc.t}g}|D]}|jddd}|d|vrt|d|d<nt}t |||d|d<|jddd k(rt |dd|d<|j ||S) u Updates information for each child associated with a user, determining whether to insert, update, or delete child data based on the provided input. Process: - Retrieves all existing user IDs to check if each child ID already exists. - For each child entry in `childrens_data`: - If the child ID exists, updates the child’s data. - If the child ID does not exist, inserts new child data with a unique ID. - If a 'delete' flag is set to True, deletes the child data. - Records the operation performed for each child ('insert', 'update', or 'delete') and stores it in a list. Args: - childrens_data (list of dict): List of dictionaries containing data about each child, including 'user_id' and 'delete' flags. - user_id (str): The unique identifier of the user to whom the children are associated. Returns: - list of dicts: A list where each dictionary contains: - 'user_id': The ID of the child processed. - 'operation': The operation performed ('insert', 'update', 'delete') for that child. Example Usage: - When updating children information for a user, this function decides for each child whether to insert, update, or delete the data and returns a summary of the actions taken. Notes: - Assumes the existence of helper functions like `get_all_user_id`, `delete_child_data`, `update_child_data`, `generate_uid`, and `insert_child_data` for performing database operations. raNrarDrrDrNrLFT)rrYrrQrrr)childrens_datarauser_idsresults child_dataoperation_resultchild_ids r8update_childrensrs@ HG%) '1~~i'@tT i H , j ),4 [ )$~H j'8 <,4 [ ) >>(E *d 2 j3 4,4 [ ) '(-)2 NrRct}|xsgDchc]}|| }}|jdddd}d|vr|ddk(rt|dd|d<|S|jdd|vrd|vr|ddk(rt|d |d<|S|jdd|vrt }t |||d |d<|Scc}w) a Updates partner information for a user, determining whether to insert, update, or delete partner data based on the provided input. Process: - Retrieves all existing user IDs to check if the specified partner ID already exists. - Checks the `partner_delete` flag in `partner_data` to determine if the partner should be deleted. - If the partner exists and is not marked for deletion, updates their information. - If the partner ID is new, generates a unique ID and inserts the new partner data. - Records the operation performed ('insert', 'update', or 'delete') for audit purposes. Args: - partner_data (dict): Dictionary containing data about the partner, including 'partner_id' and 'partner_delete'. - user_id (str): The unique identifier of the user to whom the partner is associated. Returns: - dict: A dictionary containing: - 'user_id': The partner ID or None if not provided. - 'operation': The operation performed ('insert', 'update', 'delete', or None if no operation was executed). Example Usage: - When partner information is updated, this function decides whether to insert, update, or delete the partner data and returns a summary of the action taken. Notes: - Assumes the existence of helper functions like `get_all_user_id`, `delete_partner_data`, `update_partner_data`, `generate_uid`, and `insert_partner_db` for database operations. N partner_idrpartner_deleteyesrLrDnorrN)rrYrrrQr)rHraruclean_user_idsrrs r8update_partnerr]s> H"*.bCAQ]aCNC$0#3#3L$#GVZ[<'L9I,Je,SL67(0%    , - ?DTXdDdiuwGjHLPjPL)(0%    , -^ C!^ ,<(0% 1Ds B;B;ctddd}|Dcgc].}t|jdt|k(s*|d0}}|r|drd|d|dd }|Sd|d }|Scc}w) uP Generates a message for notifying Jan about a new Planday account creation for a user, including the relevant approval description if found. Process: - Retrieves a list of approval descriptions from the 'users_approval' foreign key table. - Searches the approval list to find a description matching `approval_id`. - Constructs a message for Jan containing the user’s name and relevant approval description. - If no matching approval description is found, constructs a message indicating that no approval was located. Args: - user_name (str): The name of the user for whom a Planday account was created. - approval_id (str or int): The ID of the approval related to the user's Planday account creation. Returns: - str: A formatted message for notifying Jan about the new Planday account and its approval status. Example Usage: - When a new Planday account is created, call this function to generate a message notifying Jan, including approval details if available. Notes: - This function assumes `get_data_from_fk_table` retrieves a list of approvals from a foreign key table with details including 'id' and 'description'. - The message includes a link to Jan's Telegram profile using his Telegram user ID (6391610367). rrTr6rruFHallo Jan, für den Mitarbeiter z0 wurde ein Planday-Account mit der Genehmigung "u" erstellt. Bitte überprüfen!uk wurde ein Planday-Account erstellt, aber es wurde keine passende Genehmigung gefunden. Bitte überprüfen!)rrzrY) user_name approval_id approval_listrr~rs r8inform_jan_bc_user_new_plandayrs:++;QEM+8`Q3quuT{;KsS^O_;_- `H`HQK((1{2bcklmcnbop&& K ((1{3&& Kas +A$A$c $|g}g}|D]ejD cic]\}} |jdk7s|| c} }tfd|Dd} | d<|jgg} |r3|sd}d|vr|j dd|d|d<| j|g} t |t rtj|}|r2|D]-} | j| d| d| jddd/||| | d }|Scc} }w) a: Converts the given user and children data into the required structure with 'user_data' and 'child_data' keys. Args: - user_data (dict): Dictionary representing the main user data. - children_data (list[dict]): List of dictionaries representing the children data. - children_operations (list[dict]): List of dictionaries representing operations for each child. Returns: - dict: A dictionary with 'user_data' (list of user details) and 'children_data' (list of children details), including operation details for each child. rLc3XK|]!}|djdk(s|d#yw)rarDN)rY)roprs r8rz+convert_to_log_structure..s0wBQST]Q^bgbkbklubvQv;ws* *NrDrr6rn)r6rnrD)rGrOrHrR) rlowernextrrSrfrzr,r-rY)rGrOchildren_operationsrHpartner_operation file_listformatted_user_dataformatted_children_datakvchild_operationformatted_partner_dataformatted_file_listr} final_datars @r8convert_to_log_structurersR %+! ."'++-I$!Q17793HAIw:Mwy}~-k &&u- .  $  | +   -t 4$5k$B [! %%l3)S!$$Y/  zD  & &T$Zf\`\d\deprv\w'x y z )0.) J QJs D D ct|tr,|D]%}|jD]\}}|dk(s d||<'|St|tr#|jD]\}}|dk(s d||<|S)N)rflistrdict)rrUr rs r8replace_empty_with_noner s$ &E#kkm & UB;!%E#J & & K D$ **, !JC{ S  ! KrRcd|d|d}|jj|ddddj}|jdg}|sy |d d S) aI Find the Google Drive folder ID based on folder name within a specified parent folder. Args: service: Authenticated Google Drive service instance. folder_name (str): Name of the folder. parent_id (str): ID of the parent folder. Returns: str: Folder ID if found, None otherwise. z8mimeType='application/vnd.google-apps.folder' and name='z' and ' ' in parentsrhzfiles(id, name)T)qspacesrVincludeItemsFromAllDrivesrWrXNrr6)rXrrZrY)r_rxryqueryrfolderss r8find_folder_idrsG{mSZ[dZeeq rE}}##eGDUrvJN#OWWYHll7B'G  1:d rRc"t} tjj|t} tdd|}t|||}|sd gSg}|D]} | jd d } tj| \} } | sd } | |gd} t| | } |jj| |ddj!}|j#| |d|ddd|S#t $r#}t jd|dgcYd}~Sd}~wwxYw#t $r#}t jd|d gcYd}~Sd}~wwxYw#t $r9}d| d|}t j||j#|Yd}~3d}~wwxYw)a Uploads multiple files to Google Drive to a specified folder by folder name, within a specified parent folder. Automatically determines the MIME type of each file based on its extension. Args: file_paths (list of str): List of file paths. folder_name (str): The name of the Google Drive folder where the files will be uploaded. parent_id (str): ID of the parent folder where the target folder resides. Returns: list: A list of URLs or error messages for each file uploaded. rdrfrgNrhrirjrlrmz!Folder not found or inaccessible./rzapplication/octet-stream)rnrp)mimetyperqT)rr media_bodyrVrWrsr6rN)rnrr6rDzError uploading the file r)rrrrtrurvr[r\rrr mimetypes guess_typerrXrwrZr) file_pathsrxryrzrkr{r_r`r file_path file_name mime_type_r|mediar}r\ error_messages r8upload_files_to_google_driver.s,-I>%11KK fL& 5;? w Y?I 344G * OOC(,  ++I6 12I!{  I> *==?))}Wh}A)BJJLD NNIT-5HtTXzhpq r%*0 NW > FJ<==> 5 =qA3445> *7 {"UGLM MM- ( NN= ) ) *sS%C.DA E . D7DDD E &E>E E  F.F  Fct} tjj|t} tdd|}t|||}|t jd gS d |d }|jj|dd ddj}|jdg} | D cgc]} d| djvs| } } | S#t $r }t jd|Yd}~yd}~wwxYw#t $r }t jd|Yd}~y d}~wwxYwcc} w#t $r"}t jd|gcYd}~Sd}~wwxYw)a List all files in a specified Google Drive folder using the folder name. Args: service: Authenticated Google Drive service instance. folder_name (str): The name of the folder. parent_id (str): The ID of the parent folder (default is 'root' for the main directory). Returns: list: A list of dictionaries, each containing details about the files within the folder. rdrfNrgrhrirjrlrm Folder not found or inaccessible'rzGfiles(id, name, mimeType, size, webViewLink, createdTime, modifiedTime)T)rrrVrWrrXDELETEDrnzFailed to retrieve files: %s)rrrrtrurvr[r\rrrXrrZrYupper) rxryrzrkr{r_r`rrrXr}filtered_filess r8list_files_in_folderrmsr,-I<%11KK fL& 3;? w Y?I 89 I;l+--/&&wHQeiEI&JRRT GR(+0Z4IT&\EWEWEY4Y$ZZ+ < FJ;< 3 =qA23[  4a8 se%CD'AD55D0D0D5 D!C<<D D- D((D-0D55 E >EE E ct} tjj|t} tdd|}t|||}|t jd y |jj|d d j}||jdgvr|St jdy#t $r }t jd|Yd}~yd}~wwxYw#t $r }t jd|Yd}~y d}~wwxYw#t $r }t jd|Yd}~yd}~wwxYw)a Get a specific file in a specified Google Drive folder using the folder name and file ID. Args: folder_name (str): The name of the folder. file_id (str): The ID of the file to retrieve. parent_id (str): The ID of the parent folder (default is 'root' for the main directory). Returns: dict: A dictionary containing details about the file if found, or None if the file is not found. rdrfNrgrhrirjrlrmrzIid, name, mimeType, size, webViewLink, createdTime, modifiedTime, parentsTrTrpz,File is not located in the specified folder.zFailed to retrieve file: %s)rrrrtrurvr[r\rrrXrYrZinfo) rxfile_idryrzrkr{r_r`r}s r8get_file_by_id_in_folderrs4,-I<%11KK fL& 3;? w Y?I 89}}""^"#  ')  B/ /K LLG H= < FJ;< 3 =qA230  3Q7sM%CC.&AD,D C+ C&&C+. D7DD E#D>>Ecd|}tt}||d} tj|i|ddi|}|jdk(ryy#tj $r}t d |d}~wwxYw) Nr)rrrrrrTFr)rrrrrrr)rrrrrrrr{s r8reset_planday_namers ::, GC'(9:O G << KK8JK    3 &  $ $  $% s-A A1A,,A1cg}i}|D]k}|jds#|jds|jds8||}|s@t|jsV|jdr|tdd}d}n2|jdr|tdd}d}n|tdd}d}t |j}|}d|} d |} |j | dj d d} |j | dj d d} | r| } | r| d | } ||d | }d ||<tjjd|}|j||j|n||fS)a Saves uploaded files to a temporary directory, modifies filenames with date information if available, and returns paths and statuses of saved files. Process: - Iterates over each uploaded file, filtering to include only files with allowed prefixes. - For valid files: - Extracts an identifier and prefix from the file key to construct a modified file name. - Checks if corresponding start and end dates are provided in `form` and appends them to the filename. - Saves the file to a temporary directory with the modified name. - Tracks saved file paths and filenames with statuses in dictionaries. Args: - files (dict): A dictionary of uploaded files, typically from `request.files`. - form (dict): A dictionary of form data, typically from `request.form`. Returns: - tuple: A list of saved file paths and a dictionary with filenames and their statuses. Example Usage: - After uploading multiple files, this function saves each to `/tmp` and modifies filenames with any provided start and end dates. Notes: - The function assumes `allowed_file` is defined to validate file extensions. - Dates are expected in 'YYYY-MM-DD' format and are reformatted to 'YYYYMMDD' for filenames. - Files are saved in `/tmp`, and the saved paths are returned for further processing. file_front_ file_back_file_Nfront_back_r startDate_endDate_-_to_rCreatedz/tmp) r" allowed_filefilenamerir rYrospathjoinsaver)rXformrrfile_keyr}rQrrstart_date_key end_date_key start_dateend_date date_partrs r8save_files_tmprs<JI/)##M2h6I6I,6W[c[n[nov[w X L/""=1%c-&8&9: !$$\2%c,&7&89  %c'lm4 't}}5H H **6N%j\2L."5==c2FJxx b199#rBH$ #-,d8* =I$Xj\9+>#,Ih  VX6I IIi   i (_/)d y  rRc`hd}d|vxr%|jdddj|vS)a Checks if a file has an allowed extension based on predefined allowed file types. Process: - Defines a set of allowed extensions for files. - Checks if the file has an extension by looking for a period ('.') in the filename. - Extracts the file extension by splitting the filename on the last period. - Verifies if the extension (converted to lowercase) is in the set of allowed extensions. Args: - filename (str): The name of the file to check. Returns: - bool: True if the file has an allowed extension, otherwise False. Example Usage: - For a file "document.pdf", the function will return True if 'pdf' is in `ALLOWED_EXTENSIONS`. - For a file "image.bmp", the function will return False if 'bmp' is not in `ALLOWED_EXTENSIONS`. Notes: - This function assumes that only the last period in the filename indicates the extension. - File extensions are case-insensitive. >jpgpdfpngtxtjpeg.r)rsplitr)rALLOWED_EXTENSIONSs r8rr>s:4> (? WxsA6q9??AEWWWrRc Lg}|D],} tj||j|dd.|S#t$r|j|ddYPt$r|j|ddYnt $r(}|j|dt |dYd}~d}~wwxYw)a Attempts to delete each file in a list of file paths and records the result of each operation. Process: - Iterates through each file path in `file_paths`. - Tries to delete the file at each path and records the status of each deletion attempt. - Handles different exceptions to capture specific errors: - `FileNotFoundError`: File does not exist at the specified path. - `PermissionError`: Insufficient permissions to delete the file. - Other exceptions are recorded with the specific error message. Args: - file_paths (list of str): List of file paths to attempt deletion. Returns: - list of dicts: Each dictionary contains: - 'file_path' (str): The path of the file attempted for deletion. - 'status' (str): Indicates the result ('deleted', 'not found', 'permission denied', or 'error'). - 'error' (str, optional): Error message if an unspecified exception occurred. Example Usage: - Given a list of file paths, the function will attempt to delete each one, returning a list of status results. Notes: - This function provides detailed feedback for each file deletion attempt, useful for auditing and debugging. rJ)rr^z not foundzpermission deniedr\)rr^r\N)rremoverFileNotFoundErrorPermissionErrorrvrz)rrrr{s r8 remove_filesr*^s8G Y  Y IIi NNiH I Y( N! L NNkJ K T NN>QR S Y NNgPSTUPVW X X Ys!)6B#B#3B#;BB#c`tjd}|j|}|r|dSdS)as Extracts a date from a file name based on an 8-digit pattern (YYYYMMDD format). Process: - Compiles a regular expression to match exactly 8 consecutive digits in the filename. - Searches the filename for occurrences of 8-digit sequences. - If any dates are found, returns the last one in the list. - If no dates are found, returns None. Args: - filename (str): The name of the file from which to extract a date. Returns: - str or None: The extracted date string in 'YYYYMMDD' format if found, otherwise None. Example Usage: - For a filename "report_20221130_final.pdf", the function will return "20221130". - If no 8-digit sequence is present, the function returns None. Notes: - This function assumes the date format is always 'YYYYMMDD' and looks for an exact 8-digit match. z\d{8}rN)recompilefindall)r date_patterndatess r8extract_date_from_filenamer1s72::h'L   *E59'4'rRc0tjd}i}|xsgD]}|jdxsdj}|j |}|s:|j \} } t j| dj} |j| } | | | kDs| || <d|vrTd|vrO|d|dk(rCt jtdj} |d| kDrt|||yyyyy#t$rYwxYw) z url_name: list of dicts like {'name': 'front_approval_20300620', 'url': '...', 'id': '...', 'operation': 'insert'} z^(front|back)_approval_(\d{8})$rnrr-Nfrontbackz Europe/Zurich) r,r-rYstripmatchgroupsr"strptimerr/rr$r)rurl_namerrpatfoundrrnmsideyyyymmddrprev today_zurichs r8/check_if_docs_are_valid_and_update_planday_namerAs# **7 8C EB  &B--/ IIdO h !!(H5::CCE >L ( z:y A )1PO   s,$D  DDcZg}|D]}|djjdd}g}|ddk(r|jd|n0|ddk(r(|jd||jd ||Dcic]}|d }}|Dcic]}|d }}d } |D]<} |D]5} | | dvs d || <d | dvsd| dvrd } t| d} | s1| || <7>t |j } d}| r| s|ddk(rd}n{|ddk(r(d}|j D]}|st |kDsd}nMnK|ddk(rCd}|j D].}|s|jd\}}|t cxkr|kr*nd}n|j|d| s|ndd|Scc}wcc}w)a Checks if required documents are present and meet expiration or validity criteria based on the given specifications. Process: - For each document specification in `document_specs`: - Normalizes the document name to create the expected file names based on the `sites` value. - Checks if required files exist in `file_metadata` and if they are expired or deleted. - Extracts dates from file names to validate document dates or ranges. - Determines document status: - Status 1 if all required files are present and meet date requirements. - Status 0 if any required file is missing, expired, or deleted. Args: - document_specs (list of dict): Specifications for each required document, containing 'name', 'sites', and 'needed_date' keys. - file_metadata (list of dict): Metadata for each available file, containing 'name' and optionally dates or status. Returns: - list of dicts: Each dictionary contains the document name and its status: - 'status' 1 if all requirements are met (file presence, date validity). - 'status' 0 if any requirement fails. Example Usage: - `document_specs` specifies documents to check, including number of required sides and date needs. - `file_metadata` contains files, and the function verifies if all required documents are present and valid. Notes: - The function uses helper functions like `extract_date_from_filename` to extract dates from file names. - Assumes a `today` variable is defined externally, representing the current date for date comparisons. rnrrsitesrrr<rr FNTEXPIREDrr needed_dater )rnr^)r5rrr1allvaluesrr)document_specsr|rdoc base_namerequired_filesrn file_exists file_dates file_expiredr}req_fileextracted_dateall_files_presentdocument_statusrrrs r8check_document_requirementsrSs4>G?dK%%'//S9  w<1   ! !K {"; < \Q   ! !F9+"6 7  ! !E)"5 60>>ttU{> >-;D* >tF|+,0K) DL0If4M'+ &@V %MN%/= 8, > > 2 2 45 \=!Q&"#]#q("#&--/D *+ ]#q("#&--/"D/3zz&/A, H *e ?x ?./O!" F l`abc?dB Ni?QJ{{1~H8##J{{1~H8## rRc t}|Dcic] }|d|d }}|D]E}|d}|jD]+\}}||vs t|\} } t||| | |dEGycc}w)a< Inserts document details for a user into the database based on file information. Process: - Retrieves document foreign key mappings from the database to match file names with document types. - Loops through each file in `url_name` and matches the file name with a document type from `doc_dict`. - Extracts start and end dates from the file name, if available, and inserts these details into the database. - Calls `insert_docs_db` to perform the actual database insertion for each matched document. Args: - url_name (list of dicts): List of dictionaries, each containing 'name' (file name) and 'url' (file URL) keys. - user_id (str): Unique identifier for the user to whom the documents belong. Returns: - None Example Usage: - If `url_name` contains files with names matching known document types, those documents are processed and inserted into the database with associated metadata (e.g., start and end dates). Notes: - This function assumes access to `get_doc_fk_table` to fetch document types and `insert_docs_db` for database insertion. - It also assumes `extract_dates` is a helper function to extract date ranges from the file name. - Error handling is not included and could be added for robustness. rnr6rN)r rrXr!) r9radocsrIdoc_dictrXrdoc_namedoc_idrrs r8insert_users_docr^Fs8  D2673F SY&7H7 =!) 0  Hf8#'4X'>$ Hw HeElS  8sA,ct} tjj|t} tdd|}d |i} |jj||d j}|S#t $r }t jd|Yd}~yd}~wwxYw#t $r }t jd|Yd}~yd}~wwxYw#t $r }t jd |Yd}~yd}~wwxYw) NrdrfrgrhrirjrlrmrnT)rUrrrWzFailed to rename file: %s) rrrrtrurvr[r\rrXrrZ)rrnrzrkr{r_r| updated_files r8 rename_filerats+-I<%11KK fL& 3;? TNM}}--W=dh-iqqs  < FJ;< 3 =qA23  115sF%A7B#1C7 B BB # C ,CC  C8C33C8c|jdd}tj|}i}|D]}d|dvsd|dvrd||d<|S)Nr"rrnrDr)rrr) files_jsoncorrected_jsonrX files_dictr}s r8 convert_filesrgsn''S1N JJ~ &EJ- V $ T&\(A $- 4< - rRct|trtj|}t |ddd}g}|D]}|j |d|dd||d<t|S)a Adds current Google Drive file information to the provided user data. Process: - Checks if the `data` parameter is a string and converts it to a dictionary if necessary. - Retrieves a list of files associated with the user's Google Drive folder. - Converts each file entry to a simplified dictionary with only the file ID and name. - Updates the `data` dictionary to include the current file list under the 'files_data' key. Args: - data (str or dict): The user data, which may include previous records of files or other information. If `data` is a string, it will be converted to a dictionary. Returns: - str: The updated user data as a string, now including a 'files_data' key containing the current file list. Example Usage: - If `data` is a string representation of a dictionary, the function first converts it, retrieves the list of current files, and adds them to `data`. The function then returns the modified data as a string. Notes: - This function assumes `list_files_in_folder` is a helper function that fetches files from a Google Drive folder using the user's unique `user_id`. rGrrar6rn)r6rnrR)rfrzr,r-rr)r files_listfinal_file_listr}s r8add_current_filesrks6$%&d;&7&:9&EFJOId4j$v,GHI)D t9rRct|trtj|}|j dgD]}|d|vs d|d<t|S)NrRr6rLrD)rfrzr,r-rY)r ids_to_remover}s r8remove_files_by_file_idrnsZ$%r*) : & (D ) t9rRcPt|trtj|}|Sr*ryrs r8 str_to_listrps!$% KrRcg}|D])} tj|}|j|+|S#ttf$r }Yd}~Bd}~wwxYw)a0 Converts a list containing string representations of dictionaries into a list of actual dictionaries. Args: - data_list (list): List containing string representations of dictionaries. Returns: - list[dict]: A list of dictionaries parsed from the input list of strings. N)r,r-rr/r.)rTconverted_listr parsed_itemr{s r8parse_file_datarts]N **40K  ! !+ .  K(   s&3A A cd|}tt}ddgi}tj|||}|jdk(s|jdk(ryy) Nrri\)rrrTF)rrrrr)rrrrrs r8put_driver_in_11KA_in_plandayrvs\ ::, GC'(9:O6(G||CwGHs"x';';s'B rRc |r/|r-|jdd}|jdd}d|d|}n6|r|jdd}d|}n|r|jdd}d|}nd}g}|D]}tjj|\}} tjj | \} } | || } tjj || } tj || |j| |S)a Appends a date suffix (validFrom and/or validUntil) to each file name in the given file paths. Args: file_paths (list): List of file paths to rename. valid_from (str): Start date in the format 'YYYY-MM-DD'. Defaults to None. valid_until (str): End date in the format 'YYYY-MM-DD'. Defaults to None. Returns: list: List of updated file paths with the date suffix. r rr)rrrrsplitextrrenamer)r valid_from valid_untilformatted_fromformatted_untilfile_name_suffixfile_paths_with_datesr directoryoriginal_file_namernext new_file_namenew_paths r8append_date_suffix_to_filesr s$k#++C4%--c26~.a/@A %--c26/0 #++C4~.//(* d(;% %GG$$%78 c&!1 23%8 77<< =9 $!$$X. / ! rRcXtjd|}|r|jdSdS)z Extracts the file ID from a Google Drive file URL. Args: url (str): The Google Drive file URL. Returns: str: The extracted file ID, or None if the URL does not contain a valid file ID. z/d/([a-zA-Z0-9_-]+)rN)r,rVrW)rr6s r8extract_google_drive_file_idr0 s* II,c 2E"5;;q>,,rRc@g}|D]}|j|||Sr*)r) dict_in_lostr new_listrs r8create_list_with_specificr= s+H#S "# OrRold_datanew_datareturnct|dk(r,t|dtttfrt|d}|s t dt fd|DS)z Return True if any of the explicitly provided keys differ between old_data and new_data. Usage: address_changed(old, new, "address", "postal_code", "location", "country") # or address_changed(old, new, *my_keys_tuple) rrzSPass the keys to compare, e.g. address_changed(old, new, 'address', 'postal_code').c3K|]9}tj|tj|k7;ywr*) _normalizerY)rrrrs r8rz value_changed..R s0Xaz(,,q/*ja.IIXs?A)rirfrtupler5r/r)rrr6s`` r8 value_changedrC sR 4yA~*T!WtUC.@AT!W~ noo XSWX XXrRg4@) rrrrrr phone_prefix phone_numberr brith_dateextratimeoutrrrrrrrrrrrrrc $|sytt} t| tsyi}t d||||fDrg}|r|j |j djd|xsd|xsdfDj }|r|j ||r|j |j djd|D}|r||d <|||d <|||d <| | |d <||#|xsd|xsdj }|r||d<| | |d<| r | jD] \}}| |||<|syt|d|} tj|i| ddi|| }|jdk(ryd } |j}|jdxs|jdxs t!|}d|fS#t$r}dd d|fcYd }~Sd }~wwxYw#t$r|j"xsd}Yd|fSwxYw)aA Update a Planday employee in one call. Only provided args are sent. Returns: (ok, status_code, error_message) - ok=True if API returned 204 No Content - status_code is the HTTP status (or None if request failed before HTTP) - error_message is a concise description if not ok )FNzMissing planday_id)FNzAuth headers not availablec3$K|]}|du ywr*r)rrs r8rz*update_planday_employee.. s LQ1D= Lsrc3&K|] }|s| ywr*rrps r8rz*update_planday_employee.. sLa!Lrrc3&K|] }|s| ywr*rrs r8rz*update_planday_employee.. s2!A2rrNrrrrr)FNz#No fields to update (empty payload)rrr)rrrFzRequest error: r)TNerror_descriptionmessagez Unknown error)rrrfrrrr5rrrrrrvrrrYrzr)rrrrrrrrrrrrrrrpartstownrnumberrrrr]r{err_textrs r8update_planday_employeerT sl> 2((9:O ot ,:!#G L7K7"K LL ELL1xxLK$52x~2#FLLRRT  LL  ELL1))2u22 !(GI ) ' )   l&> &B' (:';<BBD #)GK    KKM DAq}   C 'N ::, GC4|| KK8JK   3H0yy{88/0TDHHY4GT3t9 8  4tqc2334 099/ 8 0s1G AG0 G-G("G-(G-0HH empty_to_nonect|trDtjdd|tj}|r|dk(s|j dk(ry|S|S)Nz ^\s+|\s+$r)flagsnone)rfrzr,subUNICODEr)rrss r8rr sG!S FF<Qbjj 9 a2gf)< HrR)!1idjXBYaU6B5vcB5GiR3bKWScLvNowdfI)u GekündigtTNrU)T)__doc__rDrBr[rr google.oauth2rgoogleapiclient.discoveryrgoogleapiclient.httprgoogleapiclient.errorsrgoogle.oauth2.credentialsrgoogle_auth_oauthlib.flowrwerkzeug.utilsr typingr r r r rr phonenumbers.phonenumberutilrsetuprrrrrrmodelsrrrrrrrrrrrr r!r"r#rrr,rr,zoneinfor$ basicConfigINFOr1r&TG_VERr' ImportError telegram.extr(r)r*r+r,rrrr9rQSERVICE_ACCOUNT_FILErurbrrrrrrrrrrrrr rrrArZr]rwrgrrrrrrrrrrrrrrrrrrr*r1rArSrXr^rargrkrnrprtrvrrrrboolrrzobjectfloatrrrrrRr8rsb   )+0,16*((!Eww^^^^(  ',,'*')[[  ) 721 2 2 .,`"H0:-^#J")H$NDL%P(%P0:*X>FR\~Zz2DLB -^>?B9v.b>@ *=~(T2h8T!nX@3l(BB:cL +\0,,^  * (!V - YDYDYDY*"!%"! $#"&"& $)-)nnc] n # n sm nc]n n}n3-n3-n C=n  !n$ Df% &%n()n* tXc]HSM1 2+n`  iL'&'sH33H>=H>