o Hi%@sddlZddlZddlZddlmZddlmZddlmZddl m Z m Z m Z ddl mZddlmZddlmZdd lmZmZmZdd lmZmZd d lmZmZmZd d lmZm Z m!Z!m"Z"m#Z#ddl$m%Z%ddZ&ddZ'dZ(dZ)GdddeZ*GdddeZ+GdddeZ,ddZ-Gddde j.Z/Gdd d e j.Z0Gd!d"d"e j.Z1Gd#d$d$e j2Z3Gd%d&d&eZ4Gd'd(d(eZ5Gd)d*d*eZ6Gd+d,d,eZ7Gd-d.d.eZ8Gd/d0d0eZ9dS)1N)cache)Count)timezone)viewsetsstatusgenerics)action)Response)APIView)IsAuthenticated IsAdminUserAllowAny)MultiPartParser FormParser)RegisteredMemberAttendanceRecordScannerAssignment)RegisteredMemberSerializerAttendanceRecordSerializerScannerAssignmentSerializerScanBarcodeSerializerCSVUploadSerializer)Eventc Csd}t|t|}}t||}t||}t|ddt|t|t|dd} |dtt| td| S)z1Return distance in metres between two GPS points.i6ar)mathradianssincosatan2sqrt) lat1lng1lat2lng2Rp1p2dpdlar+self_checkin_radius_m).0er+r+r, 2s z4PublicActiveCheckInEventView.get..)robjectsfilterselect_relatedr )selfr6eventsdatar+r+r,r3.s  z PublicActiveCheckInEventView.getN__name__ __module__ __qualname____doc__r permission_classesr3r+r+r+r,r:* r:c@r9)PublicSelfCheckInViewz Public self-check-in with: - Geofence validation (GPS must be within radius of venue) - IP rate limiting (max 5 per IP per 10 minutes) - Package / category validation - One-time check-in per member per event c CsR|jd}|jdp d}|jd}|jd}|r |s+tdddd tjd St|}d |}t|d }|d krItdddd tjd St ||ddzt j dj|dddd} Wnt j yvtdddd tjd YSw|dus|durtdddd tjd Sz t|t|} } Wnttfytdddd tjd YSw| jrt| jnt} | jrt| jnt} | jpd}tt| | | | }||krtdd|d|d|dd tjd Sz tj d!j|d"}Wntj ytdd#d$d tjd YSw|jr*| jr*|j| jkr*tdd%d&|jjd'| jjd(d)S| jra| jd*kra|jp9d}| j|vratdd+d,|jpMd-d.| j d/|jp[d-| jd0St!j j"|| d1d2#}|rtdd|j$|j%d3|j%&d4d5d6St!j j'|| d1t()dd7}tdd|j$|jpd|j%d8|j$d9d:tj*d S);Nevent_idregistration_coder?latitude longitudeFz)Event and registration code are required.MISSING_FIELDS)successmessagecoderself_checkin_rate_rzJToo many check-in attempts. Please wait a few minutes before trying again. RATE_LIMITEDriXr>T)r@r;r<r=z8Self check-in is not currently available for this event.EVENT_UNAVAILABLEzKYour location is required. Please enable GPS/location access and try again. GPS_REQUIREDzInvalid GPS coordinates. GPS_INVALIDi OUT_OF_RANGEzBYou must be at the event venue to self check-in. You appear to be zm away (maximum allowed: z$m). Please move closer to the venue.)r]r_ distance_mr^event_categoryregistration_code__iexactzBRegistration code not found. Please check your code and try again. NOT_FOUNDCATEGORY_MISMATCHzYou are registered under "" but this event belongs to "z+". Please check with the registration desk.)r]r_r^ALLPACKAGE_MISMATCHzYour package "N/Az" does not include access to zE. Please visit the registration desk if you believe this is an error.)r]r_r^ package_namerBCHECK_INmemberevent scan_typezYou have already checked in at z%H:%M on %d %b %Y.)r]already_checked_in member_name check_in_timer^rurvrw scan_time recorded_byz Welcome, z%! Your attendance has been confirmed.)r]ryrzrrr{r^)+rOr3r5r rHTTP_400_BAD_REQUESTr8rHTTP_429_TOO_MANY_REQUESTSsetrrJrL DoesNotExistHTTP_404_NOT_FOUNDfloat ValueError TypeErrorself_checkin_latDEFAULT_VENUE_LATself_checkin_lngDEFAULT_VENUE_LNGrFintr-rrir>rArBrruppertitlerrKfirst full_namer}strftimecreaternowHTTP_201_CREATED)rMr6rXrYrZr[iprate_keyattemptsrvlatlng venue_lat venue_lngradiusdistanceru pkg_upperexistingrecordr+r+r,postJs                           zPublicSelfCheckInView.postN)rQrRrSrTr rUrr+r+r+r,rW@s rWc@r9)PublicMemberLookupViewz@Public endpoint: look up member name/email by registration code.cCsn|jdd}|stddiSztjj|d}td|j|jp!ddWStjy6tddd YSw) Nr_r?foundFrjT)rremailzRegistration code not found.)rr^) query_paramsr3r5r rrJrrr)rMr6r_rur+r+r,r3s  zPublicMemberLookupView.getNrPr+r+r+r,rrVrcCsB|jstjStjj|jd}|jr|jdkr|j|jd}|S)a%Return members eligible for an event based on category + package match. Rules (mirrors ScanBarcodeView package check): - event.event_type == 'ALL' (or blank): every member in the category qualifies. - otherwise: only members whose package_name contains the event_type string. )riro)package_name__icontains)r>rrJnonerKrB)rvqsr+r+r,get_members_for_events  rc@s*eZdZeZegZdZddZddZ dS)RegisteredMemberViewSetNc CsHtjd}|jjd}|jjd}|jjd}|jjd}|jjd}|rWztjdj|d}t|j d d d }|j |d }Wntj yV| }Yn w|r_|j |d }|rs|j |d|j |dB|j |dB}|r{|j |d}|r|rt jj |ddj dd d } |dkr|j | d }|S|dkr|j| d }|S)Nri category_idrXsearchpayment_statusattendedr>r@r@Tflat)id__in)event_category_id)full_name__icontains)registration_code__icontains)email__icontains)payment_status__iexactrs)rXrw member_idyesno)rrJrLallr6rr3rr values_listrKrrrexclude) rMrrrXrrrrv eligible_idschecked_in_idsr+r+r, get_querysetsL       z$RegisteredMemberViewSet.get_querysetcC|jdvr tgStgSN)listretrieverr r rMr+r+r,get_permissions z'RegisteredMemberViewSet.get_permissions) rQrRrSrserializer_classr rUpagination_classrrr+r+r+r,rs  !rc@s&eZdZeZegZddZddZdS)AttendanceRecordViewSetcCs`tjddd}|jjd}|jjd}|r |j|d}|r.|j|d|j|dB}|S) Nrurvr~rXrrX)member__full_name__icontains)$member__registration_code__icontains)rrJrLrr6rr3rK)rMrrXrr+r+r,r&s z$AttendanceRecordViewSet.get_querysetcCrrrrr+r+r,r1rz'AttendanceRecordViewSet.get_permissionsN) rQrRrSrrr rUrrr+r+r+r,r"s  rc@eZdZeZegZddZdS)ScannerAssignmentViewSetcCsRtjdd}|jjd}|jjd}|r|j|d}|r'|j|d}|S)Nuserrvuser_idrX)rr)rrJrLrr6rr3rK)rMrrrXr+r+r,r;s  z%ScannerAssignmentViewSet.get_querysetN)rQrRrSrrr rUrr+r+r+r,r7rVrc@r)MyAssignmentsViewcCstjj|jjdddS)NT)rr<rv)rrJrKr6rrLrr+r+r,rJs zMyAssignmentsView.get_querysetN)rQrRrSrrr rUrr+r+r+r,rFrVrc@eZdZegZddZdS)ScanBarcodeViewc Cst|jd}|st|jtjdS|jd}|jd}|j dd}z t j dj |d}Wnt j yEtd d d tjdYSw|jjsbtj j|j|d d }|sbtd dd tjdSd}d} z&tj dj |d}|j|j|j|jr~|jjnd|jpd|jpddd} Wn tj yYnw|durtd d ddS|jr|jr|j|jkrtd d d d|jjd|jjd| dS|jr|jdkr|jpd} |j| vrtd d d d|jpdd|j d| dSt!t"j j||dj#dd d } |d!vrd| vrtd d d"|$d#d$ d%| d&S|| vrEt"j j |||d'} |%|} td d | j&|| d(| 'd)| j(| d*St"j j)|||t*+|jd+}|%|} d,d-d.d/}td d |j&|| | |d0|j(| d*S)1NrOr`rYrXrwrsr>rFzEvent not found.r]r^T)rrvr<z#You are not assigned to this event.ri)rYrq attendance)rrrYrirrrsourcez9Registration code not found. Member is not in the system.)r]already_attendedr^z/Category mismatch: member is registered under "rnz".)r]rpackage_mismatchr^ruror?z!Access denied. Member's package "z" does not include z.. Please advise member on correct entry point.)rurvr)SESSION CHECK_OUTzCannot record _ u# — member has not checked in yet.)r]rr^rurtz%Member has already been recorded for rx)r]rattendance_record_idrwattendance_statusr^r}rur|zCheck-In recorded successfully.zSession Verification recorded.z Check-Out recorded successfully.)rsrrzScan recorded.),rrOis_validr errorsrrvalidated_datar5r3rrJrLrrr is_superuserrrKexistsHTTP_403_FORBIDDENrrrrYrirArrrr>rBrrrrrreplaceget_attendance_statusr@get_scan_type_displayr}rrr)rMr6 serializerrYrXrwrvhas_assignmentru member_datarexisting_typesrrrscan_type_labelsr+r+r,rSs              zScanBarcodeView.postN)rQrRrSr rUrr+r+r+r,rP rc@s"eZdZegZeegZddZdS) UploadCSVViewc Cst|jd}|st|jtjdS|jd}|jd}ddl m }d}|rDz |j j|d}Wn|j yCtdd itj dYSwz|d }tt|}d} d} g} t|d d D]g\} } | d d}|sx| d| dq`| dd| dd| dd| dd| dd| dd| ddpdd}|r||d<tj j||d\}}|r| d7} q`| d7} q`td| | | d| d| dd WSty}ztdt|itjdWYd}~Sd}~ww)!Nrr`csv_filerr EventCategoryrerrorEvent category not found.z utf-8-sigr)startzRegistration Coder?zRow z%: Missing registration code, skipped.Emailz Full NameStatuszPayment Statusz Package NamezPackage DescriptionzActivity Price)rrrrrrpackage_descriptionactivity_pricerirYdefaultsrTzImport complete. z created, z updated.)r]createdupdatedrr^)rrOrr rrrrr3apps.events.modelsrrJrrreaddecodecsv DictReaderioStringIO enumerater5appendrupdate_or_create Exceptionstr)rMr6rrrrridecodedreader created_count updated_countrirowreg_coderrrrHr+r+r,rsh         "zUploadCSVView.postN) rQrRrSr rUrrparser_classesrr+r+r+r,rs rc@r)UndoAttendanceViewcCsz tjddj|d}Wntjy tdditjdYSw|jj s4|j |jkr4tdditj dS|j j }|jj}|tdd |d |d d S) NrurvrrzAttendance record not found.r`z/You can only undo records you scanned yourself.TzAttendance for z at z has been removed.r)rrJrLr3rr rrrrr~rrurrvrAdelete)rMr6 record_idrrz event_namer+r+r,r s"zUndoAttendanceView.deleteN)rQrRrSr rUrr+r+r+r,rrrc@r)DashboardStatsViewc Cs(|jd}tjjddd}|r|j|d}|jddd}|jddjd dd}tjj|d  }t jj|d d  d  }t jj|dd  d  }t jj|dd  d  } t jj|d d  d  t jj|dd  d  } |rt||ddnd} g} | dD]s} t|  }t jj| d d d  }t jj| dd d  }t jj| dd d  }t jj| d d d  t jj| dd d  }|rt||ddnd}| | j| j| j||||||d qt|||| | | | | dS)NrXFT)r=r<rr@r)r>r)event_category_id__inrs) event_id__inrwrurrdrr start_date)rvrw) r@rAdate total_members checked_insessions checked_outfull_attendance percentage)rtotal_checked_intotal_sessionstotal_checked_outtotal_full_attendanceattendance_percentage total_events event_stats)rr3rrJrKrrdistinctrcountrvaluesorder_by intersectionroundrrr@rArrr )rMr6rX events_qs event_ids category_idsrr#r$r%r&attendance_pctr)rv members_count ev_checked_in ev_sessionsev_checked_outev_fullpctr+r+r,r38s         zDashboardStatsView.getN)rQrRrSr rUr3r+r+r+r,r5rrc@r9) EMSConfigViewzJReturns EMS integration config available to the frontend (no credentials).cCs2ddlm}t|jo |j}t||jgddS)Nrsettings)AGM CONFERENCETRAININGEXPOGALAWORKSHOP) configuredbase_url event_types) django.confr<boolEMS_API_USERNAMEEMS_API_PASSWORDr EMS_API_BASE_URL)rMr6r<rCr+r+r,r3s zEMSConfigView.getN)rQrRrSrTr rUr3r+r+r+r,r:rVr:c@r9)ImportFromEMSViewa1 Pull paid registrations from the external ICTAZ EMS API and upsert them as RegisteredMember records in this system. POST body: event_category_id (int) - our EventCategory pk to link members to ems_event_type (str) - EMS eventType param, e.g. 'AGM', 'CONFERENCE' c Cs\ddlm}ddlm}ddlm}|jd}|jdpd}|s-t d d it j d S|s8t d d it j d S|j r>|j sGt d d it jd Sz |jj|d}Wn|jyct d dit jd YSwz |}||} Wn ty} zt d dt| it jd WYd} ~ Sd} ~ wwt| tst d dit jd Sd} d} d} | D]v}|dpd}|s| d7} q|dpd}|dpd}|dpd|dpd||dpd|dpd|dpd|||dpd|dpddd }tjj||d\}}|r| d7} q| d7} qt d|j|t| | | | d t jd S)!Nrr;rr) EMSApiClientrems_event_typer?detailzevent_category_id is required.r`zems_event_type is required.zeEMS API credentials are not configured. Set EMS_API_USERNAME and EMS_API_PASSWORD in the environment.)pkrzFailed to fetch from EMS API: z(Unexpected response format from EMS API.registrationCode trainingNamepackageOrActivityNamefullName userEmailmembershipNumberdocumentNumber phoneNumber paymentStatuspriceactive) rrrimembership_numberdocument_number phone_numberrrrrrrrT)r]rirM total_fetchedrrskipped)rFr<rr ems_servicerLrOr3r5r rrrHrIHTTP_503_SERVICE_UNAVAILABLErJrrfetch_paid_registrationsr r HTTP_502_BAD_GATEWAY isinstancerrrrAlen HTTP_200_OK)rMr6r<rrLrrMr>client members_dataexcr r skipped_countentryr training_namerrrrurr+r+r,rs         zImportFromEMSView.postN)rQrRrSrTr rUrr+r+r+r,rKs rK):rrrdjango.core.cacherdjango.db.modelsr django.utilsrrest_frameworkrrrrest_framework.decoratorsrrest_framework.responser rest_framework.viewsr rest_framework.permissionsr r r rest_framework.parsersrrmodelsrrr serializersrrrrrrrr-r8rrr:rWrr ModelViewSetrrr ListAPIViewrrrrrr:rKr+r+r+r,sF        ,  B]