ČilPddlZddlmZddlmZddlmZmZmZddl m Z ddl m Z ddl mZddlmZdd lmZdd lmZdd lmZdd lmZmZmZmZmZmZmZdd lm Z ddl!m"Z"ejFe$Z%de&de&fdZ'dZ(dZ)dZ*dZ+dZ,de&fdZ-dZ.dZ/dZ0dZ1dZ2dZ3ddZ4y) N)time)ZoneInfo) transactionIntegrityErrormodels)Q)timezone)urlparsestatus)Response)User) CompanyType)Company OfficeHoursHoliday SalesTimingCompanyBotSettingsCompanyHistoryService)ProfileServices)get_company_timeurlreturnc|s|Std|vr|nd|}|jj}|jdr|dd}|j dS)ag Normalize a website URL into a consistent comparable format. This function ensures all website URLs are stored and compared in a uniform way by removing protocol, 'www', trailing slashes, and converting to lowercase. Steps performed: 1. Adds 'http://' if the URL has no scheme (so it can be parsed). 2. Extracts the domain part (netloc) only. 3. Removes 'www.' prefix if present. 4. Converts to lowercase. 5. Removes any trailing slashes. Example: >>> normalize_website("https://www.ABC.com/") 'abc.com' >>> normalize_website("abc.com") 'abc.com' >>> normalize_website("http://abc.com:8000/test") 'abc.com:8000' Args: url (str): The website URL to normalize. Returns: str: Normalized domain (e.g. "abc.com") or the original value if empty/None. z://zhttp://zwww.N/)r netloclower startswithrstrip)rparsedrs =/var/www/html/dp2/backend_v2.1/server/apps/companies/utils.pynormalize_websiter$s^:  Uc\c ?F ]] "F   == c tjj|d}|j}t |}t |j jdz }d}|j}tjj||||dj}|rd}tjj|ddj}|r3|j|jcxkxr|jknc} nd} t jj|dj#d } g} | D]} t%| d s| j&j(s'| j&j*d | j&j,j/} | j1| d | j2| rd j5| nd }| ||r |j6nd||j8|dS#tj:$r ddddd dcYStj:$r ddddd dcYSt<$r*}t>jAd|ddddd dcYd}~Sd}~wwxYw)z8 Check if it's sales time based on phone number T phone_number is_activeFcompanybotsstart_date__lte end_date__gter)hazel)r,botr)) companiesr)profile have id , No advisor dataNo holiday today.)is_office_hours is_holidayholiday_messagetimezone_offset company_name advisor_datai)r9r:r;r<r>)r9r<r:r;r>zcheck_sales_time_by_phone N)!robjectsgetr,rint utcoffset total_secondsdaterfilterfirstr start_timerend_timerselect_relatedhasattrr3r( first_name last_namestripappendidjoinmessagename DoesNotExist Exceptionloggerwarning)r(r1r, current_timer<r:todayholiday sales_timing is_sales_time company_users advisor_listuser advisor_namer>es r#check_sales_time_by_phonerbAspM  ((,,,RV,W++'0 l446DDFMN !!#//((! ) %'  J"**11'wZ^1_eeg (33|7H7H7JclNcNccM!M ++,  . #   !DtY'DLL,E,E"&,,"9"9!:!DLL|j4}|j@jCDcgc]}|j0| vr| |j0!}}|r|j@jE|| j|Og}|jG}|D]I}|jtI||dddd|d|jjd|jKtHj"jK|dddddtM|dtM||jG|r|nd|jj|jGd}t||stjNStjPScc}wcc}wcc}w#1swYxYw#tR$r3}tddtU|itjVcYd}~Sd}~wwxYw) zOApply current company's holidays to all user's companies with bot relationshipserrorNo active companyr confirmF*You must confirm to apply to all companiesTr)rPNo other companies found edit_company!No permission to edit any companyrddenied_companiesr,r-z$No holidays found in current company company__in)r,rSrR start_dateend_dater) bulk_replacerN Replaced z holidays from  → r, updated_byaction model_name object_iddetailsd batch_sizezHolidays applied to companiesrR applied_counttotal_companiesskipped_companiessource_company items_countOperation failed: ),r_active_companyr r HTTP_400_BAD_REQUESTdatarAr2rFexcluderPexistshas_company_permissionrOrSHTTP_403_FORBIDDENrr@prefetch_relatedvalidate_holidaysratomicdeleterbot_nameitemsr)savecreaterRrrrsr-allsetcountr bulk_createlen HTTP_200_OKHTTP_206_PARTIAL_CONTENTrUstrHTTP_500_INTERNAL_SERVER_ERROR)requestr_user_companiesallowed_companiesdeniedr,current_holidaysvalidation_errorr1 source_botscreated_holidays target_botsr target_bot source_botrZ new_holiday matching_bots history_logsr response_dataras r#apply_holidays_to_all_companiesrs <Q>Q>V>V=WW\]d]i]i\jk %-  " " . .| . Lu"|.c2C.D-EZP !23-335+1t"1166+113   f.@.@ttTZTsTsttG,%E" !P p$6s1vh"?@InInoopspS+AS R>,S SS 7B S $S ;B6S 1A7S)S>S  SS T"(T TTc  tjj|d}|j}t |j}tj}t|}tjd tjd |tjd |tjd ||jjdz }|jdj}d}|j!} tjd| t"jj%||||dj'} tjd| | rd} t(jj||} tjd| | j*sd} n |j-} | j.| cxkxr| j0knc}tjd|j2tjd|j4tjd|tjd| j.tjd| j0tjd| tjd|| xr|} d}t6jj%|ddj9d}g}|D]j}t;|ds|j<j>s'tAjB|}|j<j>}|jEd |d!|d"l|r|d#jG|d#zz }|jHr|d$|jHd%z }|d&z }g}|D]}t;|ds|j<j>s'|j<jJd#|j<jLjO}|jE|d'|j2d(jG|}tQ|}|j4| | r | jRnd|tU|| r|s|nd)||d*S#tj $r dddddddd cYSwxYw#t(j $rd} YwxYw)+ab Check if company is currently in working hours based on phone number Args: phone_number (str): Company phone number Returns: dict: { 'is_office_hours': bool, # false if holiday OR outside working hours, true if NOT holiday AND within working hours 'is_holiday': bool, # true if today is a holiday, false otherwise 'holiday_message': str, # Holiday message if applicable, None otherwise 'timezone_offset': int, # UTC offset like -7 'transfer_instructions': str # Transfer instructions for the company } Tr'zno company configuresFr8rzCompany not foundr7)r=r9r:r;r<transfer_instructionsr>zN================================= COMPANY INFO ===============================zCurrent time UTC: zCurrent company time: zCompany timezone: r*%AzToday date in timezone: r+z Holiday : )r,dayzOffice hours: z company id: zcompany name: z current day: zoffice_hours.start_time: zoffice_hours.end_time: zcurrent_time_only: zis_within_hours: r?)r2r) is_availabler3)r_z-If the user wants to reach, speak or talk to  then transfer to ; r4zFIf the user wants to schedule a meeting then transfer the call to BDC z) and say 'I'll transfer you to our BDC'; zIf the user asks for an advisor who is not in the list, say 'I'm sorry, we don't have an advisor by that name at our company. Would you like to connect with someone else?'r5r6z`Cannot transfer calls in off hours or holidays. Please record a message for the advisor instead.)r=r9r;r:r<rr> service_costs)+rr@rAr,rrTrr nowrrVinforCrDstrftimerrErrFrGris_openrrHrIrPrSrrJrKr3r(rresolve_display_namerOrQ bdc_numberrLrMrNget_company_services_for_botrRrB)r(company_bot_settingsr,company_timezonecurrent_time_utccurrent_time_companyr< current_dayr:rYrZ office_hoursr9current_time_onlyis_within_hoursrr]user_instructionsr_r` advisor_phoner^r>servicess r#get_company_working_infor s" 199==% > '..  0 01 ||~+G4 KK`a KK$%5$678 KK()=(>?@ KK$%5$678+446DDFMO'//5;;=KJ % % 'E KK*5'23oo$$ !,* %  eg   KK*WI&'  "**../  n\N34###O!5 9 9 ; *559JclNcNccO KK,wzzl3 4 KK.7 8 KK- }5 6 KK3L4K4K3LM N KK1,2G2G1HI J KK-.?-@A B KK+O+<= >#-n@O LL''(nY  4 # (A(A*??TJL LL55M  $ $? ~M_`m_nnpq  *;! '..g../ '||~88D*33D9??A 0557 ( "aJB{HaJB{H%):FhFoo,,$//-  "%J"//,,  "'^_i_n_n^opBCSBTTV&W W !& /#LL%:   * * #*P    6s1vh?@#*V   s$EEF20F28/F-'F2-F2cLtjj||||||S)z&Helper function to log company changesrw)rr@r)r,r_ryrzr{r|s r#log_company_changerfs2  ! ! ( ( ) r%c6|jtjdtjdz}|jry|D]G}|js|j s|j|j kDs7d|j dcSy)zValidate holidays dataT)start_date__isnull)end_date__isnullz:Invalid holidays: some holidays are missing start/end datezInvalid holiday "z%": start date must be before end dateN)rFrrrrrrsrS)holidaysinvalid_holidaysrZs r#rrrsD)FHHd,KK K   '"2"2w7I7IGL\L\7\&w||n4YZ Z r%c|jdjtjdtjdz}|jryy)zValidate office hours dataT)rstart_time__isnullend_time__isnullz?Invalid office hours: some open days are missing start/end timeNrFrrr)r invalid_hourss r#validate_office_hoursr sU ''( fD)FHHd,KK P r%c|jtjdtjdz}|jryy)zValidate sales timings dataTrrz>Invalid sales timings: some timings are missing start/end timeNr ) sales_timingsinvalid_timingss r#validate_sales_timingsrs@#**D)FHHd,KKOO r%c |j}|jstdditjS|j j ddstdditjS|jjdj|jj }|jstdd itjSg}g}|D]A}|jd |r|j|'|j|jC|std |d tjS|j j|j} | js/tdd|j#ditjS|r'|| } | rtd| itjS t%j&5|j j|j)g} |D]}| D]} |d)d|i|j*j,D cic]M} | jdk7r<| jdk7r-| j.s!| jt1| | jOc} }| j||j j3| d}g}| j5}|D]Z}|jt7||d|dd|d|j#d|jjd|j\t6j j3|dddd|dt9|dt9||j5|r|nd|jj| j5d }t||stj:Stj<Scc} w#1swYxYw#t>$r}tA|}d!|vr4tdd"|j#d#itjcYd}~Sd$|vr"tdd%itjcYd}~Stdd&|itjcYd}~Sd}~wtB$r tdd'itjcYStD$r3}tdd(tA|itjFcYd}~Sd}~wwxYw)*a} Generic utility to apply current company's data to all user's companies Args: request: Django request object model_class: The model class (OfficeHours, SalesTiming, etc.) model_name: String name for logging (e.g., 'OfficeHours', 'SalesTiming') validation_func: Optional custom validation function Returns: Response object rdrer rfFrgTrhrirjrkrlrmrozNo z found in current companyrpr,rPir~rtNrur4z from rvrwr}z applied to rrzUNIQUE constraint failedz Duplicate z found. Please try again.zFOREIGN KEY constraint failedzInvalid company referencezData constraint violation: zPermission deniedr)$r_rr r rrrAr2rFrrPrrrOrSrr@rrrr_metafields auto_createdgetattrrrrrrrrrPermissionErrorrUr)r model_classrzvalidation_funcr_rrrr, current_datar new_recordsitemfield new_recordcreated_recordsrrrra error_msgs r#apply_to_all_companies_bulkr s <#>@ @ , 9W&AB6KfKfg gW(CI;&OPY_YtYtu u Z"56v?X?XYY p$6s1vh"?@InInoopsO9)AO->AO(C O-A9O9O9(O--O62O99 S6=R?S6 R%S6+R S6)S6;S6(S1+S61S6r)5loggingdatetimerzoneinfor django.dbrrrdjango.db.modelsr django.utilsr urllib.parser rest_frameworkr rest_framework.responser apps.core.modelsrapps.companies.constantsrapps.companies.modelsrrrrrrrapps.userprofile.servicesrutils.timezone_utilsr getLogger__name__rVrr$rbrrdb_shell_testingrrrrrrr rr rr%r#r2s99!!!,!0 61   8 $$3$3$NQ hsplbJ*0Kf Ss S AT n   qpr%