o %si@sddlmZddlmZddlmZddlZddlZddlZddl Z ddl Z ddl m Z ddl Z ddl ZddlmZddlmZddlmZejejejeddlZeZedd Zd Zd Zd Zd dZ ddZ!ddZ"ddZ#ddZ$ddZ%edgddZ&ddZ'ddZ(d d!Z)d"d#Z*d$d%Z+d&d'Z,d(d)Z-d*d+Z.d,d-Z/d.d/Z0d0d1Z1d2d3Z2d4d5Z3d6d7Z4d8d9Z5d:d;Z6dd?Z8d@dAZ9dBdCZ:dDdEZ;dFdGZedJgdMdNZ?dS)O)log)api_view) JsonResponseN)timezone) defaultdict) HTTPBasicAuthz"Starting the PPP Automation scripthttps://scic.crm.dynamics.com$6e5989aa-4fd1-4015-8648-8f75609d607b(tH58Q~s1P3BPDSOJihcaCLeMxdkU-UkjKyag6aSh$95f69e7d-1811-4ab9-9b5a-eba95d3eba9bcCsld|d}d||td}tj||d}|jdkr%td|dStd |j t d |j ) Nz"https://login.microsoftonline.com/z /oauth2/tokenclient_credentials) grant_type client_id client_secretresource)datazToken retrieved successfully access_tokenzFailed to retrieve token: ) base_urlrequestspost status_codeloggerinfojsongeterrortext Exception)rr tenant_id token_urlpayloadresponser#-/var/www/html/PPP_Automation/ppp_app/views.py get_tokens   r%c Csd}d}d}d}z`t|||}d|d}d|dd d d }tj||d }|d } | d d} | d d} d|| dd d d} ddd} |d| d}tj|| | d}td|jd||jWSty}ztd|d|WYd}~dSd}~ww)Nr r r rhhttps://scic.crm.dynamics.com/api/data/v9.1/trit_cerequests?$filter=_trit_eventregistrationid_value eq ''Bearer odata.maxpagesize=50004.0 AuthorizationPreferOData-MaxVersion OData-Versionheadersvaluertrit_cerequestidz @odata.etagapplication/json)r,zIf-Match Content-Typer.r/s) statecode statuscodez/api/data/v9.1/trit_cerequests()r1rz!Status code at update_no_request  for z:Error at update_no_request retrieving odata and record_id ) r%rrrpatchrrrr)eventregistrationidrrrrtokentrit_cerequests_api_urlr1 event_reqdt record_idetagupdate_headers update_data update_urlupdate_responseer#r#r$update_no_request3sB   $rJc Csd}d}d}t|||}d|dddd}zAd|d }tj||d }|d }t|} td t| d |t| dkrGd} | WSt| dkrRd} | WSd} | WSt yq} zt d| WYd} ~ dSd} ~ ww)Nr r r r(r)r*r+r&r'r0r2zce request count z for event registration id rTFz!Error in validation of CE Requestz>Error at ce_request_validation_api function and the error is: r%rrrpd DataFramerrlenrr) r>rrrr?r1r@rArBdf CE_REQ_ValrIr#r#r$ce_request_validation_apiis6     rQc Csd}d}d}d}t|||}d|dddd}z"d |}tj||d }|} | d } t| } | d } | d WStyT} ztd| WYd} ~ dSd} ~ ww)Nr r r rr(r)r*r+nhttps://scic.crm.dynamics.com/api/data/v9.1/trit_courseassignments?$filter=_trit_eventregistrationid_value eq r0r2r9rz8Error at courseassignment_statuscode and the error is - ) r%rrrrLrMrrr)r>rrrrr?r1trit_courseassignment_api_urlr"resrcourseassigment_dfrrIr#r#r$courseassignment_statuscodes,    rVc Cs d}d}d}t|||}d|dddd}z^d|d }tj||d }|}|d g} | s:td |gWS|d d d} d| d } tj| |d } | } | d }g}|D] }||dq^td||WSty}ztd|gWYd}~Sd}~ww)Nr r r r(r)r*r+zWhttps://scic.crm.dynamics.com/api/data/v9.1/msevtmgt_events?$filter=trit_eventcode eq 'r'r0r2zNo event found for eventcode: rmsevtmgt_eventidzlhttps://scic.crm.dynamics.com/api/data/v9.1/msevtmgt_eventregistrations?$filter=_msevtmgt_eventid_value eq 'msevtmgt_eventregistrationidzevent registration ids list z4Error at event_name_uuid function and the error is: ) r%rrrrrappendrr) eventcoderrrr?r1 event_api_urlrArT event_dataevent_id"msevtmgt_eventregistration_api_urlmsevtmgt_eventregistration_reqmsevtmgt_eventregistration_resres1er_listerrIr#r#r$event_name_uuids@     rdc Cs\ztd}|}tdWnty*}ztd|WYd}~nd}~wwz |d|f|}WntyR}ztd|WYd}~nd}~wwz?|rtt j t j }|d||f| |ddd d WSt j t j }|d |||f| |dd d d WSty}ztd|WYd}~dSd}~ww)Nz'/var/www/html/PPP_Automation/db.sqlite3zGConnected to SQLite database at /var/www/html/PPP_Automation/db.sqlite3z/Error at connection sqlitedb and the error is: zN SELECT * FROM ppp_events WHERE qs_ppp_event_code = ? z1Error at retrieving event code and the error is: z UPDATE ppp_events SET qs_ppp_last_modified_date = ? WHERE qs_ppp_event_code = ? rz Event is already Trigged for PPPT statusCodemessageisEventTriggedAlreadyz INSERT INTO ppp_events (qs_ppp_event_code, qs_ppp_created_date, qs_ppp_last_modified_date) VALUES (?, ?, ?) zEvent is new to PPPFz>Error at retrieving updating the event code and the error is: )sqlite3connectcursorrrrrexecutefetchonedatetimenowrutccommitclose) event_codeconnrkrIrecordutc_nowr#r#r$check_eventcode_existsV  rwGETcCsF|jdkr!td|jd}td|zz;|sztddddddWW|ryz/d }d|i}d d i}tj|||d }td |d|jd|td |d|jWSt yx}zt d|d|WYd}~Sd}~wwSzt |}Wntt y}zht d|tdddddWYd}~WW|rz/d }d|i}d d i}tj|||d }td |d|jd|td |d|jWSt y}zt d|d|WYd}~Sd}~wwSd}~wwtd|d|t|ddWW|rWz/d }d|i}d d i}tj|||d }td |d|jd|td |d|jWSt yV}zt d|d|WYd}~Sd}~wwSt y}zjt d|tddddddWYd}~W|rz/d }d|i}d d i}tj|||d }td |d|jd|td |d|jWSt y}zt d|d|WYd}~Sd}~wwSd}~ww|r z/d }d|i}d d i}tj|||d }td |d|jd|td |d|jWwt y}zt d|d|WYd}~wd}~wwwdS)Nrxz#Received GET request at validateapirZzThe Event code is: z#Missing ?eventcode= in query stringrestatusz0https://corporateallibot.scic.com/PPP-Automationr5r4)rr1zPOST to z completed with status z and post response zFailed to POST to : zcheck_eventcode_exist failed: z"Internal error at event code check)rfrgzResponse for Eventcode  F)safez(Error at validate api and the error is: zInternal server error) methodrrrxrrrrrrrrw)requestrZurlr!r1 post_responserIrTr#r#r$ validateapis    "  "" " "rc Csxz d}||||d}td|tj||d}|dWSty;}ztd|WYd}~dSd}~ww)a Fetch the instructor approval ID based on provided parameters. Parameters: product_id (str): The unique identifier for the product. state_id (str): The unique identifier for the state. delivery_method (int): The code representing the delivery method. license_type (int): The code representing the type of license. Returns: str or None: The instructor approval ID if found, otherwise None. zMhttps://webapi.scic.com/OrganizerPython/api/PythonAPI/GetInstructorapprovalId) ProductIdStateIdDeliveryMethod TypeofLicensez1Fetching instructor approval ID with parameters: )paramsr"z'Error fetching instructor approval ID: N)rrrrrrr) product_idstate_iddelivery_method license_typerrr"rIr#r#r$fetch_instructor_approval_idWsrc Cs@d}d}d}d}zt|||}Wnty)}z dd|iWYd}~Sd}~wwd|d d d d }|d }dd i} zDtj|||d} | jdvrWtd| jddi} W| S| jdkrhtdddi} W| Std| j| jdd| jd| ji} W| Sty}ztd|dd|i} WYd}~| Sd}~ww)z Creates a new record in the Dynamics 365 CRM system using the OData API. Parameters: new_record (dict): The record data to be created in the CRM. Returns: dict: A dictionary containing the status of the operation. r r r rr{zDFailed to get token at function ce_request_odata and the error is - Nr(r)r*r+z/api/data/v9.2/trit_cerequestsnullr;)rzLRecord created successfully with status code at unction ce_request_odata: %sSuccessz1No content to update at function ce_request_odatazSuccess with no changeszz)check_poll_requirements..r:zInvalid format, missing colon: r6r-zSkipping invalid format: zError processing r|cSrr)rintr#r#r#r$rr Sufficient Insufficient)ProductHourzRequired Pollsz Total PollsStatusrz" Products with insufficient polls:z"#####Insufficient data starts#####z #####Insufficient data ends#####z2This product have sufficient polls for every hour.yes)emptyanyrrrrsplitrsplitrNjoinraddritemsrangerYrLrMcolumns)rpolls_by_product_hourrrowrproduct_hour_partparts product_hourpoll_numrhourrIrequired_polls_per_hourproduct_poll_summaryhourstotal_poll_countsummary_records hour_data total_polls summary_dfinsufficient_pollsr#r#r$check_poll_requirementssj     "         rc Cs4tjddd}tjddd}tjddd}d}d}d}t|||}d |d d d d } d |d} tj| | d} | } | d} t| }td||dd}td|d}z|dddkrtd| D]\}}|d|kr|d}td||d}|WSqn|WS|dddkrtd| D]\}}|d|kr|d}td||d}|WSq|WS|dddkrtd| D]\}}|d|kr|d}td||d}|WSq|WStd|WSt y}ztd |WYd}~dSd}~ww)!NzG/var/www/html/PPP_Automation/ppp_app/AO and AM state and statecode.xlsxAO) sheet_nameAMCCr r r r(r)r*r+zJhttps://scic.crm.dynamics.com/api/data/v9.1/products?$filter=productid eq z &$select=namer0r2zao am states product table - namerz AO,AM&CC - r6z!This event number is in AO statesstateidrzAO state name is z CE requestzThis event is in AM stateszAM state name is zThis event is in CC stateszCC state name is z'It doesn't comes under AO or AM productz!fails at ao_am_states function - ) rL read_excelr%rrrrMrrrr) trit_productraoamccrrrr?r1product_api_urlr"rTrrAO_AM_CCno_of_cerequestindexrrrIr#r#r$ ao_am_states+s|           rc Cst|}|d}i}|D]\}}td|d||ddk}t|}|||<q|D]}|dkrc Csd}d}d}t|||}d|dddd}zd|}tj||d }|}|d } t| } | jr=td |WdSd | j vrXtd |td| j WdS| | d dk} | jrntd|WdS| dd} | dd} | dd} | d d}| dd}| dd}| dd}| dd}| dd}| dd}|d|}| dd}| | | ||||||d WSt y}ztd|WYd}~dSd}~ww)Nr r r r(r)r*r+zUhttps://.crm.dynamics.com/api/data/v9.1/trit_licenses?$filter=_trit_contact_value eq r0r2z"No license data found for contact r9z:'statuscode' column not found in license data for contact zAvailable columns: r6z4No active licenses (statuscode=1) found for contact _trit_contact_valuerr8_trit_stateid_value trit_rlicensetrit_lineofauthorityrrcr726_firstnameonlicensecr726_lastnameonlicenser~trit_typeoflicense) trit_license_trit_contact_valuetrit_license_statecodertrit_license_statuscoderAr license_idName_on_licenserEz-Error at function licenses and the error is: ) r%rrrrLrMrrrrtolistr)r5rrrr?r1r;r"rTrr<rFrGrrHrArrIrJfnln full_nametrit_license_trit_typeoflicenserIr#r#r$licenses>sd                rPc Csz1d}d}d}t|||}d|dddd}d|}tj||d }|} | d } t| } | WStyL} ztd | WYd} ~ dSd} ~ ww) Nr r r r(r)r*r+fhttps://scic.crm.dynamics.com/api/data/v9.1/trit_courseassignments?$filter=trit_courseassignmentid eq r0r2z6Error at function course_assignment and the error is: r)) course_assignment_idr]rrrr?r1rSr"rTrtrit_courseassignmentrIr#r#r$course_assignments(   rTc Csd}d}d}t|||}d|dddd}z&d|}tj||d }|}|d } t| } | d | d | d dWStd|dYdS)Nr r r r(r)r*r+ghttps://scic.crm.dynamics.com/api/data/v9.1/trit_pollquestions?$filter=_trit_courseassignment_value eq r0r2rrrrrrzThis Evenregistration z doesn't contains poll questions)r%rrrrLrMrr) rRrrrr?r1trit_pollquestions_api_urlr"rTrtrit_pollquestionsr#r#r$rs$   rc CsDd}d}d}zbt|||}d|dddd}d|d }zdtj||d }||d g} | s=td WWd S| dd} td| d|d } tj| |d } | | d g} | sptdWWd St| }| |d<td|Wntj y}zt d|WYd}~nd}~ww| D]\}}z|d}|rtd|t j |d}td|nd}|d}|d}|dkrd|vr|jdks |dkrd|vs |dkrd|vs |d krd|vs |d!krd|vs |d!krd"|vrd#|j|d$f<td%|d&nd |j|d$f<td%|d'WqtyV}zt d(|d)|d*|d |j|d$f<WYd}~qd}~ww|d$}td+||dkWStj y}zt d|WYd}~d Sd}~wty}zt d,|WYd}~d Sd}~ww)-a! Validates the designation logic based on state, designation, and contact data. :param state_id: The state code as a string. :param contact_data: The contact identifier to filter designation awards. :return: True if the validation conditions are met, False otherwise. r r r r(r)r*r+zQhttps://scic.crm.dynamics.com/api/data/v9.1/trit_states?$filter=trit_stateid eq 'r'r0r2z.No state data found for the provided state_id.FrrzState name retrieved: zchttps://scic.crm.dynamics.com/api/data/v9.1/trit_designationawards?$filter=_trit_contact_value eq 'z1No designation awards found for the contact data.rzinfo of designation df: zAPI request failed: Ntrit_awarddatez awarded date z%Y-%m-%d_trit_designation_valueALz$c75f2772-389c-e911-a819-000d3a1ca508iNJz$89a1dfa4-cd65-ef11-bfe2-000d3a99f7aaNVUTz$cb5f2772-389c-e911-a819-000d3a1ca508TLGSzRow z: Validated as True (LGS).z: Validated as False (LGS).zError processing row r|z for contact zTotal valid LGS entries: zUnexpected error: )r%rrraise_for_statusrrrrLrMRequestExceptionrrrnstrptimeyearatrsum)r contact_datarrrtokensr1 state_api_urlstate_response state_data state_namedesignation_award_api_urlr"designation_datadesignation_dfrIidxraward_date_str award_date designationrow_state_name row_errorgroup_designation api_error general_errorr#r#r$ validate_lgss         rxc Csi}d}d}d}t|||}zJ|D]B\}}|d}d|} d|dddd } tj| | d } | jd krI| } | d g} t| }|||<qt d |d| jq|WSt yt}zt d|iWYd}~Sd}~ww)a Fetch poll questions for each course assignment and return a dictionary of DataFrames. Parameters: trit_courseassignment (DataFrame): DataFrame containing course assignments. client_id (str): Client ID for authentication. client_secret (str): Client Secret for authentication. tenant_id (str): Tenant ID for authentication. Returns: dict: A dictionary where keys are `ca_id` and values are DataFrames containing poll questions. r r r trit_courseassignmentidrUr(r)r*r+r0rr2z Failed to fetch data for ca_id: z. Status Code: zError in fetch_poll_questions: N) r%rrrrrrLrMrrrr)rS dataframesrrrr?rrca_idrWr1r"rTrrOrIr#r#r$fetch_poll_questionshs6       r|c Csd|}d}d}d}t|||}d|dddd}ztj||d }|}|d } t| } | WStyO} ztd | tWYd } ~ Sd } ~ ww) ze This is used to retrieve all course assignments records based on event registration ID rRr r r r(r)r*r+r0r29Error at function course_assignment_df and the error is: Nr)) event_reg_idrSrrrr?r1r"rTrrSrIr#r#r$course_assignment_dfs*   rc Cszi}|D]\}}d}d}d}t|||}d|dddd}d|} tj| |d } | } | d g} t| } | d tjtd }gggd }t |tjr| D]N\}}|d |d|d |d|d |d|j s|D])}|r| ddd}d|d}|d ||d d|d |qyqU|||<q|WSty}ztd|tWYd}~Sd}~ww)a Process course assignments and generate a structured dictionary. Args: test_fpq (dict): A dictionary where keys are `ca_id` and values are DataFrames. client_id (str): Client ID for API authentication. client_secret (str): Client Secret for API authentication. tenant_id (str): Tenant ID for API authentication. Returns: dict: Processed data for all course assignments. r r r r(r)r*r+rQr0r2trit_admincomment)dtyperVrrrrNrz : questionTr})rr%rrrrLrMSeriesobject isinstancerrYrrrrrr)test_fpq result_datar{rOrrrr?r1rSr"rTr$comments_retrieval_course_assignmentrpqrrrr  joined_datarIr#r#r$process_course_assignmentssX      rc.CsX d}z td|d}d}t|}td|t|}t|}g}|D]\}}td|t|} | d} | d} t| } | d} | d }t| }|durjt d | d |dd |fWS| d }t|| d }| d}| d}| d}| d}t ||| |||}t || }td|t | }t||}|dd}td|d }|dur|dkrtd|}td|d|d}td|t|}td|z^t|}| d}td|| d}td|| d}td|| d}td || d }| d!} | d}td"|t ||}td|Wn tyl}!zt d#t d$|!WYd}!~!nd}!~!ww|d%krtd&td't|} | d} t| } zKzC| d(d)krtd*d+}"n2| d(d,krtd-d.}"n#| d(d/krtd0d1}"n| d(d2krtd3d4}"ntd5Wnty}!ztd6td7|!d}!~!wwzC| d8d9vrtd:d}#n2| d8d)krtd;d<}#n#| d8d,krtd=d>}#n| d8d/kr&td?d@}#ntdAWntyG}!ztdBtdC|!d}!~!wwza| dd,krXtdDdE}$nP| dd)krgtdFdG}$nA| dd/krvtdHdI}$n2| ddJkrtdKdL}$n#| ddMkrtdNdO}$n| ddPkrtdQdR}$ntdSWnty}!ztdTtdU|!d}!~!ww|"|#|$dV}%tdW|%Wn ty}!ztdXtdY|!WYd}!~!nd}!~!ww| d} tdZ| | d8}&td[|&| d(}'td\| td]|z|| ||||||%|||d%d^ }(td_|(Wn tyZ}!ztd`tda|!WYd}!~!nd}!~!ww|d%krtdb| d(d)kr| d8dcvr| d,krtdd|de| |d}zt|}|d}|d}t|Wn ty}!ztdftdg|!WYd}!~!nd}!~!ww|dhdkrtdd|di|ddurtdd|djzt ||}td|Wn ty }!ztdktdl|!WYd}!~!nd}!~!ww|d krtdm|dnhdo})gdp}*d }t||}| d }tdq||drkrF|dskrFtdtn|duvrW|dvkrWtdwn|dxvrh|dykrhtdzn|d{vry|d|krytd}n||*vs||)vr|d~krtdnv||)vrddddddd}+|d},|+ |,}-|-r||-krtd|-d|,dnI|s|r| dd)krtdn4| dd,krtdn%| dd/krtdntdn||*vs||)vrJ|d~krJtdzt|tdtd|Wn%ty@}!ztd|dtd|!dWYd}!~!nd}!~!wwtd|ntdzt|Wn%tyz}!ztd|dtd|!dWYd}!~!nd}!~!wwtd|n|dkrtd|dnrtdnltdnftdn`tdnZ|d%krtdnO|dkrtdnDtdzt|tdtd|Wn%ty}!ztd|dtd|!dWYd}!~!nd}!~!wwtd|||fWSWdSty+}!ztd|!dWYd}!~!dSd}!~!ww) SS type - 314310000 Not a SS type - 314310001 Delivery Mechanism - 314310001 - Webinar Trit ce declination other than "314310000 - Credit Already Satisfied","314310001 - GrandFathered","Not Licensed - 314310002"s Nz(entered No_cerequest_check function for &No info acquired due to condition failcourse assign - Processing DataFrame for ca_id: r(rWr.r'Failed to get license info for contact , skipping event registration FrIrJrrErLGS Validated - trit_percentattendedrpercentage_attendance_check - %came into percentage_attendance_checkBIn courseassignment attendance percentage value present and it is r~r5 contactID - license check License type - rAResident License State id - line of authority - rType of License - =This is where we retrieve License details - comment to checkXException raised in cerequest_check function, while trying to get the license details - r6!Satisfied lic_check = 1 condition one Licenser-rThe sales channel is SS typeSS or 314310000r%The sales channel is High School typeHigh School or 314310001rThe sales channel is LS typeLS or 314310002yThe sales channel is UNIV typeUNIV or 314310009]The Sales channel is is None or other than these 314310000, 314310001, 314310002 or 3143100093Condition where we check ss type - comment to checkException in checking ss type r$ 314310000 314310001 314310002ce declination is none+ce declination is Credits Already SatisfiedCredits Already Satisfiedce declination is Grandfathered Grandfatheredce declination is Not Licensed Not Licensed^The CE declination reason is not None neither they are these 314310000, 314310001 or 314310002:Condition where we check ce declination - comment to checkException in ce declination - Delivery Mechanism is webinarWebinarDelivery Mechanism is Classroom Classroom Delivery Mechanism is Self-Paced Self-Pacedr7Delivery Mechanism is BlendedBlendedtDelivery Mechanism is Corp-WBCorp-WBu Delivery Mechanism is Corp-Class Corp-ClasspThe Delivery Mechanism is not in any of these 314310000, 314310001, 314310002, 314310003, 314310004 or 314310005>Condition where we check delivery mechanism - comment to check"Exception in delivery mechanism - z Sales ChannelzCE Declination reasonzDelivery MechanismHReturning Sales Channel, CE Declination reason and Delivery Mechanism - ZCondition where we check ss type, ce declination and delivery mechanism - comment to checkGException in checking ss type, ce declination and delivery mechanism - Delivery Mechanisms - ce declination reason Event ID - Event Registration id - zEvent Registration idzEvent IDz Contact IDz License IDz Name on LicensezType Of LicensezState ID in LicenseSc_CE_dec_del_mechz Validated LGSzLine Of AuthorityzResident LicensezActive LicensePDictionary of values Details_before_entering_condition_trit_rlicense_equal_to_1 MDetails_before_entering_condition_trit_rlicense_equal_to_1 - comment to checkHException in Details_before_entering_condition_trit_rlicense_equal_to_1 it is a resident licenserrrThis \ satisfied trit_type as SS & trit_cedeclinationreason is None and delivery method Webinar - ETry to get the license information for the contact - comment to checkBException in Try to get the license information for the contact - rG have only one license have stateid valueZLGS Validation inside - Check if the license has a valid state id value - comment to checkWException in LGS Validation inside - Check if the license has a valid state id value -  This #'s State comes under Non-LGS states$33805427-a600-ea11-a826-000d3a1ca610$861d0c2a-a600-ea11-a825-000d3a1cadb6$881d0c2a-a600-ea11-a825-000d3a1cadb6$9544192b-a600-ea11-a827-000d3a1cac04$8b44192b-a600-ea11-a827-000d3a1cac04$d21d0c2a-a600-ea11-a825-000d3a1cadb6$cb1d0c2a-a600-ea11-a825-000d3a1cadb6$c91d0c2a-a600-ea11-a825-000d3a1cadb6$ab1d0c2a-a600-ea11-a825-000d3a1cadb6$7c1d0c2a-a600-ea11-a825-000d3a1cadb6$40805427-a600-ea11-a826-000d3a1ca610$3c805427-a600-ea11-a826-000d3a1ca610zprod - rFz`'7c1d0c2a-a600-ea11-a825-000d3a1cadb6' and percentage_attendance_check >= 70 no ce request checkrrUzR# Attendance meets the threshold of 85% for specified states. no ce request check rrZzR# Attendance meets the threshold of 90% for specified states. no ce request check rrrdzS# Attendance meets the threshold of 100% for specified states. no ce request check PzR# Attendance meets the threshold of 80% for specified states. no ce request check b_\YSCrrr6+trit_courseassignment_trit_instructionhours$# Attendance meets the threshold of % for z hours. no ce request check zP/C . no ce request check zL/H. no ce request check zP/C & L/H. no ce request check zlCe request declined with both attendance percentage and poll count conditions failing. no ce request check zQCe request declined due to attendance percentage in Non-LGS. no ce request check zpassed at trit_license_trit_stateid_value not in State_Code or trit_license_trit_stateid_value in specified_states) and percentage_attendance_check < 80 with r<zFailed at trit_license_trit_stateid_value not in State_Code or trit_license_trit_stateid_value in specified_states) and percentage_attendance_check < 80 function No_cerequest_check for z. no ce request check Error: z7no ce request check completed for eventregistration id z*Failed at function No_cerequest_check for TThis Event Registration ID - zM comes under LGS state, So no CE Request can be created. no ce request check zGfailed at trit_license_trit_residentstate is none. no ce request check zWtrit_license_statecode either have no license or multiple license. no ce request check z|It failed trit_type == 314310000 or trit_cedeclinationreason is None or delivery method is not webinar. no ce request check z2it is a non-resident license. no ce request check zMMore than one license so CE requests can not be created. no ce request check z No License. no ce request check zyAttendance percentage is none so no CE request can be created escaped in the first condition itself. no ce request check zlpassed Attendance percentage is none so no CE request can be created escaped in the first condition itself. )rrrr|rrr,r0rPrrrrxr:rTr>rrJ).r*rinfo_after_percentage_checkca_dffpqpcaoverall_ce_request_event_reg_idr{rOrcr(rWevrrlicrI license_namerrrstate_approval_idval_LGScontcapercentage_attendance_checkce_request_createdpercentage_checkr5 lic_checktrit_license_trit_licensetyperArrIsales_channel_typece_decliDel_Mechrdmt_type:Details_before_entering_condition_trit_rlicense_equal_to_1specified_states State_Codeattendance_thresholdsinstruction_hoursrequired_percentager#r#r$No_cerequest_checksF                                                 &                        r&c1CsZd} ztd|d}d}t|}td|t|}t|}g}|D ]e\}}td|t|} | d} | d} t| } | d} | d }td |t| }|durrt d | d |dd |fWS| d}| d}| d}| d}| d}t ||| |||}t || }td|t | }t||}|dd}td|d }|du r|dk rtd|}td|d|d}td|t|}td|z^t|}| d}td|| d}td|| d}td || d}td!|| d}| d"} | d}td#|t ||}td|Wn tyj}!zt d$t d%|!WYd}!~!nd}!~!ww|d&k rtd'td(t|} | d} t| } zKzC| d)d*krtd+d,}"n2| d)d-krtd.d/}"n#| d)d0krtd1d2}"n| d)d3krtd4d5}"ntd6Wnty}!ztd7td8|!d}!~!wwzC| d9d:vrtd;d}#n2| d9d*krtd<d=}#n#| d9d-krtd>d?}#n| d9d0kr$td@dA}#ntdBWntyE}!ztdCtdD|!d}!~!wwza| dd-krVtdEdF}$nP| dd*kretdGdH}$nA| dd0krttdIdJ}$n2| ddKkrtdLdM}$n#| ddNkrtdOdP}$n| ddQkrtdRdS}$ntdTWnty}!ztdUtdV|!d}!~!ww|"|#|$dW}%tdX|%Wn ty}!ztdYtdZ|!WYd}!~!nd}!~!ww| d} td[| | d9}&td\|&| d)}'td]| td^|z|| ||||||%|||d&d_ }(td`|(Wn tyX}!ztdatdb|!WYd}!~!nd}!~!ww|d&k rtdc| d)d*k r| d9ddv r| d-k rtde|df| |d}zt|}|d}|d}t|Wn ty}!ztdgtdh|!WYd}!~!nd}!~!ww|didk rtde|dj|ddu rtde|dkzt ||}td|Wn ty }!ztdltdm|!WYd}!~!nd}!~!ww|d k rtdn|dohdp})gdq}*d }t||}|drkr|dskrtdttdu|t||d}tdv|||(|di||||dw}||| d}t ||| ||| }|d|D]s}+tdxz t|+ dyWn tdzY|+}t|d{|d|d}| d||d~| d|d|d|d|d|d|d|d&d},z t|,d}Wqrty}!zt d|,t d|!WYd}!~!qrd}!~!ww|||fWS|dvr|dkrtdtd|t||d}tdv|d}||(|di||||dw}||| d}t ||| ||| }|d|D]q}+tdxz t|+ dyWn tdzY|+}t|d{|d|d}| d||d~| d|d|d|d|d|d|d|d&d},zt|,Wq;ty}!ztd|,td|!WYd}!~!q;d}!~!ww|||fWS|dvrw|dkrwtdtd|t||d}tdv|d}||(|di||||dw}||| d}t ||| ||| }|d|D]l}+tdxz t|+ dyWn tdzY|+}d{|d|d}| d||d~| d|d|d|d|d|d|d|d&d},zt|,Wqtyn}!ztd|,td|!WYd}!~!qd}!~!ww|||fWS|dvr9|dkr9tdtd|t||d}tdv|d}||(|di||||dw}||| d}t ||| ||| }|d|D]l}+tdxz t|+ dyWn tdzY|+}d{|d|d}| d||d~| d|d|d|d|d|d|d|d&d},zt|,Wqty0}!ztd|,td|!WYd}!~!qd}!~!ww|||fWS||*vsC||)vr/|dkr/td|t||d}tdv|d}||(|di||||dw}||| d}t ||| ||| }tdt|tdt|td||d|D]}+tdxz |+}td|Wnty}!ztd|!WYd}!~!nd}!~!ww|+}d{|d|d}| d||d~| d|d|d|d|d|d|d|d&d},t|,zt|,Wqty'}!ztd|,td|!WYd}!~!qd}!~!ww||fWS||)v rHddddddd}-|d}.|- |.}/|/ r||/krktd|/d|.dt||d}td|d}||(|di||||dw}||| d}t ||| ||| }|d|D]u}+tdxzt|+Wn tdzY|+}d{|d|d}| d||d~| d|d|d|d|d|d|d|d&d},t|,zt|,Wn#ty}!ztd|,td|!WYd}!~!nd}!~!ww||fWStd|/d|.dt|np| s| rt|tdt||d}tdv|d}| dd*k rRtd| d"}t|||}0nK| dd-k rktd| d"}t|||}0n2| dd0k rtdz | d"}t|||}0Wn| d"}t|||}0Yntdd}0||(|di||||dw}|||fWStdt||d}| d}t ||| |||}|}td||d|D]j}+zt|+Wn tdzY|+}d{|d|d}| d||d~| d|d|d|d|d|d|d|dKd&d },zt|,Wn#t y>}!ztd|,td|!WYd}!~!nd}!~!wwt| qېnA||*v sR||)v r|dk rtdt||d}td|| d}t ||| ||| }td||d|D]y}+zt|+Wn tdzY|+}tdd{|d|d}| d||d~| d|d|d|d|d|d|d|dKd&d },t|,z t|,tdWn#t y}!ztd|,td|!WYd}!~!nd}!~!wwt| qt|ntdt||d}| d}t ||| |||}|}td||d|D]j}+zt|+Wn tdzY|+}d{|d|d}| d||d~| d|d|d|d|d|d|d|dKd&d },zt|,Wn#t y}!ztd|,td|!WYd}!~!nd}!~!wwt| q2n|dk rtd|dntdt|ntdt|ntdt|ntdt|n|d&k rtdt|n|dk rtdntdt||d}| d}t ||| |||}|}td||d|D]j}+zt|+Wn tdzY|+}d{|d|d}| d||d~| d|d|d|d|d|d|d|dKd&d },zt|,Wn#t y}!ztd|,td|!WYd}!~!nd}!~!wwt| q|||fWSWdSt y}!z t|!WYd}!~!dSd}!~!ww)rNz%entered cerequest_check function for rrrr(rWr.rz Product ID: rrFrIrJrrErrrrrrrr~r5rrrrArrrrrrrr6rrr-rrrrrrrrrrrrrrrr$rrrrrrrrrrrrrrrrrr7rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrGrrrrrrrrrrz PR state 70%z3# Check for AO&AM products - based on percentage 1 zno of ce requests )Course_Assignment_IDzLicensee detailsz7Licensee have active license or not(0 - Active License) Product_ID PercentagerzNo of CE Requestz ce creationrzno approv id exceptionz/msevtmgt_eventregistrations(r:z/msevtmgt_events(z /contacts(z /products(z/trit_licenses(z/trit_instructorapprovals()#trit_EventRegistrationId@odata.bindtrit_msevtmgt_Event@odata.bindrtrit_ParticipantId@odata.bindtrit_ProductId@odata.bind$trit_ParticipantLicenseId@odata.bindcr726_StateApproval@odata.bindr9TzFailed to submit record: rrrzHI or VA State & >= 85%z3# Check for AO&AM products - based on percentage 2 rrz TX, ND >= 90%z3# Check for AO&AM products - based on percentage 3 rrzMD, MI, MN state and = 100 %z3# Check for AO&AM products - based on percentage 4 rz3# Check for AO&AM products - based on percentage 5 ztype of state_approval_id - zLength of state_approval_id: zstate approval list - zExtracted state approval ID: zno approv id exception - rrrrrrrrrrz hours.zNumber of CE requests: z(# Attendance does NOT meet the required z6# Created cerequest based on polls for specified staterrrrzVCe request declined with both attendance percentage and poll count conditions failing z into 7 - ) r*r+rr,r-r.r/r9r8zinto 6z into 6 - z into the loopzpassed the else statementz;Ce request declined due to attendance percentage in Non-LGSr z7 comes under LGS state, So no CE Request can be createdz1failed at trit_license_trit_residentstate is nonezAtrit_license_statecode either have no license or multiple licensezfIt failed trit_type == 314310000 or trit_cedeclinationreason is None or delivery method is not webinarzit is a non-resident licensez7More than one license so CE requests can not be createdz No LicensezcAttendance percentage is none so no CE request can be created escaped in the first condition itself)rrrr|rrr,r0rPrrrrxr:rTr>rrrYrtyperNr"rr)1r*rr r r r rr{rOrcr(rWrrrrrIrrrrrrrrrrrr5rrrArrIrrrrrrr r!r"salrr#r$r%LOAr#r#r$cerequest_checks                                               &                                                                                                                                                 r3c Csz8t|}|durtd|dd|dWSt|tr0t|dkr0|\}}}d|||dWSdd t|d WSty_}ztd |t d dt||dWYd}~Sd}~ww) Nz8cerequest_check returned None for eventregistration_id: rzcerequest_check returned None)r{rgr~rsuccess)r{r ce_createdr~warningzUnexpected return format)r{rgrz Error in ce_request_last_check: Full traceback:) r3rrrtuplerNstrrr exception)r*ceno_of_requestscreatedreg_idrIr#r#r$ce_request_last_check s8  r?POSTc Csz6|jdkr4|jd}|stdddddWStd|t|}td |td |d WSWdSty`}ztd |t d tdt |dddWYd}~Sd}~ww)Nr@ eventreg_idrzeventreg_id is required)r{rgryrzz.Processing CE request for event registration: z CE result: r4)r{r"zError in index_ce_request: r7r}) rrrrrrr?rrr:r9)rr*r;rIr#r#r$index_ce_request s:    rBc Cs@z|jdkr|jd}|stddiddWSt|}td||s1tdd|id dWSg}g}g}|D]}td |zst|}t|}|d urm|d ksX|d krmtd|t |} | || dnH|durtd|| |zt |Wn0t y} zt d|d| WYd} ~ nd} ~ wwtd|td|d|Wq9t y} zt d|d| | |t| dWYd} ~ q9d} ~ ww|||d} td| td|iWSWdSt y} zt| td| tdt| iddWYd} ~ Sd} ~ ww)Nr@rZrzeventcode is requiredryrzz*event registration id list index function z,No event registrations found for eventcode: izEvent Registration ID: Frrzevent registration ids false: )id last_checkTzevent registration ids true: z Error in No_cerequest_check for r|zevent registration ids else: z2This Event Registration ID has unexpected result: z - zError in event registration id )rCr)z event reg idszeligible to check ce listalready_exists_listzindex details invalid_ce_listzerror at index exception r})rrrrrdrrrQrVr?rYr&rrr9) rrZ event_reg_idsrFrE valid_idsersis_valid status_checkr;rIr r#r#r$r sv     " 3  r)@asynciorrest_framework.decoratorsr django.httprossysrrninspectrripandasrL collectionsr requests.authrpathrYrdirname__file__LogUtils getRootLoggerrrrrrrr%rJrQrVrdrwrrrrrrrrrr"r,r0r:r>rPrTrrxr|rrr&r3r?rBrr#r#r#r$s       6&$42 =(C1/}<PJ+.'0}""i6%LIR4