9ZhF ddlZddlZddlZddlZddlmZddlmZddlm Z ddl m Z ddl m Z ddlmZddlmZddlZddlZdd lmZdd lmZdd lmZmZmZmZdd lmZmZdd lmZm Z ddl!Z!ddl"Z"ddl#Z#ddl$Z$ddl%Z%ejLejNddl(m)Z* ddl(m+Z+ddl(Z(ddl-m.Z.m/Z/m0Z0m1Z1m2Z2dZ3dgZ4dZ5dZ6de7de7de8fdZ9dZ:dZ;d'dZd Z?d'd!Z@d"ZAd#ZBd$ZCd%ZDd&ZEy#e,$rdZ+YYwxYw)(N)service_account)build)MediaFileUpload) HttpError) Credentials)InstalledAppFlow)secure_filename)geocoder)region_code_for_country_code)headers_tookanPLANDAY_CLIENT_IDPLANDAY_REFRESH_TOKENALLOWED_EXTENSIONS)get_cred_google_service_accget_data_from_fk_table)datetime timedelta)level) __version__)__version_info__)rrrrr) ApplicationCommandHandler ContextTypesMessageHandlerfilterscrKtj|}|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 /var/www/html/crm/standalone.pysend_msg_telegramr'$s1 ,,u C  2sv  666s -757z%https://www.googleapis.com/auth/drivecg}|D])} tj|}|j|+|S#ttf$r}t d|d|Yd}~Sd}~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. zError parsing item: z Error: N)ast literal_evalappend ValueError SyntaxErrorprint) data_listconverted_listitem parsed_itemes r&parse_file_datar45ssN **40K  ! !+ .  K(  (is; <  s&3AAAc`d|vxr)|jdddjtvS)N.)rsplitlowerr)filenames r& allowed_filer;Ks7 (? D ??3 "1 % + + -1C CDold_datanew_datareturncg}|D]Q}|j|}|j|}t|t|k7s=|j|||dS|S)u[ Vergleicht alte und neue Daten und gibt eine Liste von Änderungen zurück. Args: old_data (dict): Alte Daten aus der Datenbank. new_data (dict): Neue Daten aus dem Formular. Returns: list: Liste von Änderungen, z.B. [{"field": "email", "old": "old@example.com", "new": "new@example.com"}, ...] )fieldoldnew)getstrr+)r=r>changeskeyold_valnew_vals r&compare_changesrJPseG,,s#,,s# w<3w< ' NN   Nr<cd|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 parentsdrivezfiles(id, name)T)qspacesfieldsincludeItemsFromAllDrivessupportsAllDrivesfilesNrr$)rSlistexecuterD)service folder_name parent_idqueryresponsefolderss r&find_folder_idr\isG{mSZ[dZeeq rE}}##eGDUrvJN#OWWYHll7B'G  1:d r<c |jj|ddj}y#t$rO}t j d||j jdk(rt j d|Yd}~yd}~wwxYw)Nr$T)fileIdrPrRzAn error occurred: %sizFolder with ID %s not found.F)rSrDrUrloggingerrorrespstatus)rV folder_idfolderr`s r&check_folder_existsre~st$$IdUY$Zbbd  -u5 ::   # MM8) D s03 B ABB c8t} tjj|t} tdd|}t|||}|sd gSg}|D]} | jd d } tj| \} } | sd } | |gd} t| 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}~>d}~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. scopes.Failed to load service account credentials: %s*Error loading service account credentials.NrMv3 credentials%Failed to build the Drive service: %s!Error building the Drive service.z!Folder not found or inaccessible./zapplication/octet-stream)nameparents)mimetypeid, webViewLinkT)body media_bodyrPrR webViewLinkr$insert)rrurlr$ operationzError uploading the file z: )rrrfrom_service_account_infoSCOPES Exceptionr_r`rr\split mimetypes guess_typer.rrScreaterUr+) file_pathsrWrX cred_jsonrmr3rVrcresults file_path file_name mime_type_ file_metadatamediafiler` error_messages r&upload_files_to_google_drivers,-I>%11KK fL& 5;? w Y?I 344G * OOC(,  ++I6 12I!{ i I> *==?))}Wh}A)BJJLD NNIT-5HtTXzhpq r'*2 NY > FJ<==> 5 =qA3445@ *7 {"UGLM MM- ( NN= ) ) *sS%C9D((A E9 D%D D% D%( E1E EE F .FFct} 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. rgriNrjrMrkrlrnroz Folder not found or inaccessible'rLzGfiles(id, name, mimeType, size, webViewLink, createdTime, modifiedTime)T)rNrOrPrRrQrSDELETEDrrzFailed to retrieve files: %s)rrrr|r}r~r_r`rr\rSrTrUrDupper) rWrXrrmr3rVrcrYrrSrfiltered_filess r&list_files_in_folderrsr,-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|}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) NrgrirjrMrkrlrnrorrT)r^rvrRzFailed to rename file: %s) rrrr|r}r~r_r`rrSupdaterU)file_idrrrrmr3rVr updated_files r& rename_filers+-I<%11KK fL& 3;? TNM}}--W=dh-iqqs  < FJ;< 3 =qA23  115sF%A7B#1C7 B BB # C ,CC  C8C33C8cg}g}t}tjD]} |j}t j |}|rqdt |jz}||vrU|j||j|t j|d|jd|jid}||vr'|j|dd|jddi|jdd i|jd |jd ||fS#t$r&}td|jd|Yd}~.d}~wwxYw) N+) dial_code region_codecountryzError processing country: z, z+383XKKosovoMoroccoc$t|dddS)Nrr7)intxs r&z+get_country_dialing_codes..5s#a nQR.@*Ar<)rGc |dS)Nrrs r&rz+get_country_dialing_codes..7s Qy\r<)set pycountry countriesalpha_2 phonenumbersexample_numberrE country_codeaddr+region_code_for_numberrrr~r.sort) country_dial_codes country_namesseen_dial_codesrrrrr3kosovo_dial_codes r&get_country_dialing_codesr s|MeO&&D D"??L)88FN#n&A&A"BB O3#'' 2&--%.'3'J'J>'Z/"((!7<<*D$.!!)#    x  9  AB12 } ,,/ D .w||nBqcB C C DsBD## E,E  EcJt} 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. rgriNrjrMrkrlrnrozParent folder with ID z not found or inaccessible.z"application/vnd.google-apps.folder)rrmimeTypersruT)rvrPrRrxz,An error occurred during folder creation: %szError creating the folder.)rrrr|r}r~r_r`rrerSrrUrDr) rWrXrrmr3rVrr folder_urlr`s r&create_google_folderr;s$,-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"ctddDcic]}t|d|d}}tddDcic]}t|d|d}}|jjDcic]4\}}|dvr+|j ds|j ds ||d vrdn|6}}}d |vr|d |vr ||d |d <d |vr|d |vr ||d |d <i}d}|jj d |r|jj d |xsd|} |jj d ||jj d||jj d||jj d||jj d|d|t| <|dz }|jj d |r||dScc}wcc}wcc}}w)Ncompany_industryr7r$ descriptioncompany_statusrow_idr$ submitActioncontact_rSNoneindustryrb contact_name_ contact_id_new_contact_email_contact_phone_contact_prefix_contact_job_title_)rremailphoneprefix job_titlecompanycontacts)rrEformitems startswithrD) requestr1 industry_map status_maprGvalcompany_fieldsri contact_ids r&get_company_new_data_from_formrks,E[\npqErsTCT OT-%88sLsCYZjlmCno4#d4j/4 #66oJo **, C 6 6z*w' c\)ds2N^#z(Bl(R%1.2L%Mz">!nX&>*&L#-nX.F#Gx H A ,,  ]1#. /\\%% A3&78Fd1#J LL$$}QC%89\\%%qc&:;\\%%qc&:;ll&&'<= )),>qc*BC % Z! Q ,,  ]1#. /" 9tosG(G-09G2c`tddDcic]}t|d|d}}tddDcic]}t|d|d}}tddDcic]}t|d|d}}|jjDcic]4\}}|dvr+|j d s|j d s ||d vrdn|6}}}d|vr|d|vr ||d|d<d |vr|d |vr ||d |d <d |vr|d |vr ||d |d <d|iScc}wcc}wcc}wcc}}w)Nrr7r$rcommunication_methodcompany_contact_personrrrSrcommunicated_over company_usercustomer_interactions)rrErrr)rr1 company_mapcommunication_over_mapcompany_contact_person_maprGrcustomer_interactions_fieldss r&,get_customer_interactions_new_data_from_formrsDZ[dfgDhiD3tDz?D$77iKiOef|~PABtc$t*otM/BBBBSikCEFTG"H4#d4j/4 3F"F"H"H **,$ C 6 6z*w' c\)ds2$ $005QR[5\`k5k2=>Z[d>e2f$Y/::?[\o?puK@K|S)NrrBrCrrDrE)r=r>rFrGrIrHs r&$get_change_diff_customer_interactionrsvG !!89??AU W2377< w<3w< '|djD]x\}}|dj|i}|jD]K\}}|j|}t|t|k7s/||dvri|d|<||d|d||<Mz|S)Nrrrrr) r=r>rFrGrIrHcid new_contact old_contacts r&get_change_diffrs"G !+113G W9%))#. w<3w< '.5g&FGI s #G %Z0668Q[z*..sB7 '--/ QLC!ooc*G7|s7|+gj11/1GJ',8?0P #C(-  QQ Nr<cv|rt|jdk(ry t|S#t$rYywxYw)u?Konvertiert value in einen Integer, falls möglich, sonst None.noneN)rEr9rr,)values r& parse_intrs= CJ$$&&05z s , 88)!1ihoY1RD5HNY1itj_lkcdPhp3aWM8j6kt)Frandomstringr_os google.oauth2rgoogleapiclient.discoveryrgoogleapiclient.httprgoogleapiclient.errorsrgoogle.oauth2.credentialsrgoogle_auth_oauthlib.flowrwerkzeug.utilsr rrr phonenumbers.phonenumberutilr setupr r rrmodelsrrrrrequestsjsonr)rre basicConfigINFOrrTG_VERr ImportError telegram.extrrrrrr'r}r4r;dictrTrJr\rerrrrrrrrrrrr<r&rs  )+0,16*!E^^F(  ',,'*')[[ 7 2 2,D ddt2* >B(V0,-\.,`!H4 2e '&'s#C99DD