o j2@sH ddlmZddlmZddlmZmZmZmZm Z m Z m Z m Z m Z mZmZmZddlmZddlmZddlmZmZddlmZdd lmZdd lmZdd lmZ dd lmZdd l!m"Z"m!Z!m#Z#dd l$Z$dd l%Z%dd l&Z&dd l'Z(dd l)Z)dd l*Z*dd l+Z+dd l*Z*dd lmZddl,m-Z-dd l.Z.ddl/m0Z0m1Z1m2Z2ddl3m4Z4ddl5m6Z6m7Z7ddl8m9Z9ddl:m;Z;ddl!m!Z!mm?Z?ddl@mAZAdd lBZBddlmZdd lCZCddlmZdd lDZDddl>mEZEddlFmGZGddl3mHZHdd lmZddlmZmZddlImJZJddlKmLZLddlMmNZNddlmZddlmZdd lCZCGdddeNZOGdd d e6ZPd!d"ZQd#d$ZRdd%lmSZSeSZGd&d'd'eNZTGd(d)d)eNZUdd*l!m#Z#dd lmZGd+d,d,eNZVGd-d.d.eNZWGd/d0d0eNZXGd1d2d2eNZYGd3d4d4eNZZGd5d6d6eNZ[Gd7d8d8eNZ\Gd9d:d:eNZ]Gd;d<dd>eNZ_ddl!m!Z!mttj dddd dYSwttj ddd d dS) Nr>F)rrDr5z"Profile image deleted successfullyrfailedzProfile not foundzID not providedzUser ID is required) rrTrPrWdeleterr,r.r[rrrQ)r_r`rFrJrdrdrers0     zVerifyotpAPIView.deleteN)rhrirjrPrrdrdrdrers 'rc@s*eZdZefZddZddZddZdS)ProfileupdateAPIViewcKs|d}|dur[zrB)rEr<rMf_nameZl_namerJrFrr5rqFailedTCompany not foundr)rPrrTrrFrWrXrEr<rMr\ last_namer,r.r[rr)r_r`kwargsrFracompanyprr:rdrdrerPs:      zProfileupdateAPIView.getc Cs|j}z"|d}tjj|jjd}||_|tt j dddddWSt yH}ztt j dddd t |dWYd}~Sd}~wtyj}ztt jdddd t |dWYd}~Sd}~ww) N prof_photor>rDr5zProfile updated successfullyrrTMissing required field: An error occurred: )r:rPrrTrarFrWrr,r.HTTP_201_CREATEDKeyErrorrQr^r{r)r_r`r:Zphotakerrdrdrerf s4       zProfileupdateAPIView.postc Cs|j}|jd}|jd}|jd}|jd}zKtjj|d}tjj|d} |d| _|d| _|d| _|d| _| |d|_|d|_ |d|_ |d|_ | t tjd d dd d WSty{t tjd d ddd YSw)Nrphone_noemail_idr\r>rZ first_namesrrDr5User updated successfullyrrTSomething went wrong)r:rPrrTrr2r\rr<rrMrErWr,r.rrrQ) r_r`rFr:rrrr\mmsdrdrdreput3s<                zProfileupdateAPIView.putN)rhrirjr$rrrPrfrrdrdrdrers ( &rc@s,eZdZddZddZddZddZd S) RegisterAPIViewc Ks||d}|durezFtjj|d}tjj|jd}|jr'|jjdkr'|jj}nd}|j|j|j |j |j ||j |j |j|j|j|jd }ttjddd|dWStydttjd dd d d YSw|jd }t|zg}|jdd} |jdd} |jdd} |jdd} |jdd} |dkrtjjdddd}n tjjdddd}| r|j| d}| r|j| d}| r|j| d}| r|j| d}| rzt| }|dvr|j|d}Wn tyYnw|D]"}tjj|jd}|j|j|j |j |j|j |j |jd }||qttjddd|dWSty=ttj d dd d!d YSw)"NrFrrprB) rEr<rMaddresspincoderJ firstnamelastnamegenderdojr3rFrr5rqrTrrvalZ vendornamerr<rMr.2r@r)r.rNz-user_idrZname__icontainsZemail__icontainsZphone__icontains)Zpincode__icontains)rr@r-)rErFrMrr<rrMr.r)!rPrrTrrFrWrXrEr<rMrrr\rrrr3r,r.r[rrGETr|rstriprorder_byint ValueErrorr?appendrQ)r_r`rrFrarrr:rr2rr<rM status_param companiesZ status_intusersZ company_datardrdrerPhs                   zRegisterAPIView.getc Cs"|j}zH|d}|d}|d}|d}|d}|d}t|} t||| d} | t|||||| d} | ttjd d dd d WSt yn} zttj d d ddt | d WYd} ~ Sd} ~ wt y} zttj d d ddt | d WYd} ~ Sd} ~ ww)NZ employeenamer<Z mobilenumberrrr3)r2r<r3)r3rEr<rMrrarDr5z New User Registered successfullyrrTrr)r:rPrrrrr,r.rrrQr^r{r) r_r`r:rEr<rMrrr3hashed_passwordvan profile_datarrdrdrerfsJ            zRegisterAPIView.postc Cs|jd}|j}|jd}|dkr6tjj|d}|jdkr#d|_nd|_|ttj dddd d S|d kr]tjj|d}|jdkrJd|_nd|_|ttj dddd d S|rtjj|d}|d|_ |d |_ |d|_ |d|_ |d|_|d|_|d|_|ttj ddddd Sztjj|d}tjj|d} |d|_|d|_|d|_|d|_|d|_|d|_|d|_|d|_|d|_|d|_|d|_|d |_|d!|_|d"|_|d#|_ |d$|_!|d%|_"|d&|_#|d'|_$|d(|_%||d| _&|d)| _'|d*| _(|d| _t)|d(| _%| ttj dddd+d WSt*yQttj+d,dd-d.d YSw)/Nrctc1r>rr@rDr5zWFH updated successfullyrrzInactive updated successfullygrossptuanpanaccountreimz#Salary details updated successfullyrrEpemailshift marriedstatusrr<rMrcitystatecountryr department designationrN authorityrrWempcoder3rrrrTr),rrPr:rrTZwfhrr,r.rrrrrrrrrrErrrrr<rMrrrrr department_iddesignation_idrN authority_idrrWrr3r2r\rrrrQ) r_r`rFrr:rZpoZmeowrrrdrdrer1s                                          zRegisterAPIView.putcOs||d}z#tjj|d}|tjj|d}|ttjdddddWSty=ttj ddd d dYSw) NrFr>rrDr5zCompany deleted successfullyrrT No data found) rPrrTrrr,r.r[rr)r_rrZ company_idrrrdrdrers$     zRegisterAPIView.deleteN)rhrirjrPrfrrrdrdrdrergs B _rc@r0)CompanydashboardAPIViewcCsz[ddlm}|jj}tjj|d}ddlm}ddlm }|jj}|}d}d}d} d} d} d} d } d}d}d }d }d }||| | | | ||| ||||d }t t j d dd|dWSt ypt t jdddddYSw)Nr)rrYrr r@) totalenquiry totalvendortotalenquirytodaydate activevendorinactivevendor monthdatatotalvendorlastmonthcurrent_month_enquirylast_month_enquirycurrent_month_auctionlast_month_auctioncurrent_month_productlast_month_productrDr5rqrTrr)django.utils.timezonerrarFrrTrcountrrr,r.r[rr)r_r`roprrZ current_daterrrrrrrrrrrrr:rdrdrerPs\       zCompanydashboardAPIView.getNrhrirjrPrdrdrdrers rc@seZdZdddZdS)CheckcompanyAPIViewNc Cs|jd}|jd}|jd}|jdp|jd}td||||s-|s-|s-|rht}|r9|t|dO}|rB|t|dO}|rK|t|d O}|rT|t|d O}tj|}tt j d d d|d Stt j dd dddt j dS)NrMr<r2 gstnumbergstz Check Params:)rE)rMr;)r rDr5)r.r4rrTz!No phone, email, or GST provided.rr-) rrPr|r rrTrrr,r.r[rQ) r_r`rFrMr<rEr queryrrdrdrerPs8     zCheckcompanyAPIView.getrmr rdrdrdrer sr c@eZdZdZefZddZdS)DashboardapiAPIViewa} GET /dashboardapi/?date=YYYY-MM-DD - Late count: Setting.shift_start + Setting.grace_minutes (NOT hardcoded) - Holiday / Weekly-off: Holiday table + Setting.weekly_off - Holiday/Weekly-off nu iruntha, "Absent" concept illa (working day illa), so absent_list empty-a return aagum, is_holiday/is_weekly_off flag-a paathu frontend banner kaatikkum. cCs|jd}z|rt|dnt}Wn ty#t}Ynwt}t ||}||}| |dv}t |p>|}t j jdd} | } tj j|dd} | } | j|dd } g}|s| jd d d }| j|d }|D]}t|ddr||jjnd}||j|j|dqs| dkrt| | dnd}| dkrt| | dnd}tdddd| | |dd| | |d||d|dd|dd|d|ddt|dpdd|dDdt ||||d d!S)"Nr%Y-%m-%d weekly_offrr-Present)rr. late_after)Z in_time__gt employee_idTflatZid__inphoto)rFrEimagerdrrDr5z Active Staff)labelZpresenttotalpercentz Late Entry shift_start%I:%M %p shift_end grace_minutesweekly_off_namescSh|]}t|qSrdDAY_KEYS.0irdrdre mz*DashboardapiAPIView.get..)rendr!rr) Zn_dataZs_dataZabsent_employeesZ selected_dater is_holiday holiday_name is_weekly_off is_off_dayr.r:)rrPrstrptimerdate_clstodayrget_attendance_configget_holiday_mapweekdayboolr rTrrr values_listexcludegetattrbuild_absolute_urirrXrrFrErr,strftimesorted)r_r`date_str target_datecfg holiday_maphol_namer.r/Zall_emp total_countZ present_today present_count late_count absent_listZpresent_emp_idsZ absent_empsempZ image_urlZ p_percentZ l_percentrdrdrerP)sx            zDashboardapiAPIView.getNrhrirj__doc__r$rrrPrdrdrdrers rc@r0)StudentClassCountAPIViewc Csz(tjj|dd}tjj|dd}t||dtddd||dd WStyE}ztd t|itj d WYd}~Sd}~ww) Nr) student_id session_typer@ZjsabdbsdsmdbasmdbsandrrDr5) normal_count special_countr0r4r-) rrTrrr|r,r{r^r.rQ)r_r`rFrMrNrrdrdrerP{s  "zStudentClassCountAPIView.getNr rdrdrdrerJzrrJc@s6eZdZd ddZddZddZdd Zd d ZdS) EmployeeAPIViewNc Cs|durkzPtjj|d}|j|j|j|j|j|jr|jjnd|jr%|jjnd|j r-|j jnd|j r5|j jnd|j |j |j rD| |j jndd }tt jddd|dWStjyjtt jdddd d YSwzZtjd }g}t|d D]8\}}tjj|jd }|||j|j|j|jr|jjnd|j r|j jnd|j |j|j r| |j jndd q{t|dtt jddd|dWSty} ztt jdddt| d WYd} ~ Sd} ~ ww)NrzN/A) rFrEmobileagerrZdepartment_namerZdesignation_namerr. profile_picrDr5rqrTzNo employee foundr -created_atrr>) rowrFrErPrrr.rOrRZHHHHHHHHHHHHHHHHHHHH)r rTrPrFrErPrQrrrrr.rr;rXr,r[rUrallr enumeraterusers_idrrOr|r{rQr^) r_r`rFrGr: employeesZemp_listindexrbrrdrdrerPst        zEmployeeAPIView.getc Cs|jsdS|jj}tj|sdSz-t|\}}|sWdStj||dd}|s*WdS||dtt d|j Wd St ya}zt d |j d |d t |fWYd }~Sd }~ww)u Employee photo-வில் face encoding எடுத்து save பண்ணும். எந்த size photo-வும் handle பண்ணும். Returns: (success: bool, message: str) )FPhoto இல்லை)Fu2Photo file கிடைக்கவில்லை)Fu>Photo-ல் முகம் தெரியவில்லைrZknown_face_locationsZ num_jitters)Fu$Face encode ஆகவில்லைrz[Encoding] Saved for: )TzEncoding savedz[Encoding Error] : FN) rpathosrpreprocess_imageface_recognitionface_encodings save_encodinginvalidate_cacher|rEr{r^)r_employeeZ photo_path img_arrayface_locations encodingsrrdrdre_save_face_encodingBs2  z#EmployeeAPIView._save_face_encodingc Cs |j}|jd}z|d}|d}|rtjj|dnd}|r(tjj|dnd}|dp0d}|d} |dpA|d } |d } |sVttj d d d ddWS| ddd} t | } | dd }|}d}t jj|dr||}|d7}t jj|dsxt || d}|td| || | ||d}|tjj||d|d| |||d||j|jjr|jndd }d}|r||\}}|std|jd|ttjdd dd||dWSty}zttj d d d d t|dWYd}~Sd}~ww)!NrRrrrrErr<rPrMrrr5TzName is requiredr @123r)r2r=)rNr3rErMrrarWrQr) rErPrQrrrrrrW created_byrZz[Warning] Encoding failed for r\rDzEmployee created successfully)r.r4r9encoding_statusZlogin_usernameError: )r:FILESrPrrTrrr,r.rQreplacerlowerrrrrrr rrFrais_authenticatedrhr|rErr{r^)r_r`r:rRZdept_idZdesig_idZdeptZdesigrEr<rMr raw_passwordrZ base_usernamer2counterrrrdrmokrrdrdrerfgs               zEmployeeAPIView.postc Cs|j}|jd}z tjj|d}d|vr!tjj|dd|_d|vr0tjj|dd|_|dr>|d|j  n|j }||j k}||_ |d|j |_ |d|j |_ |d|j |_ |d |j|_|d |j|_|rv||_|d }|j} | rzNtjj| d} tjj| d } || _ |d| j| _|d| j | _ |r|| _|r|d dd} t| } | | _|| _| | | _| |rdnd}Wntjyd}Yn tjyd}Ynwd}|s|jr|js||\}}|std|j d|tdddd||dWStjy)tdddddYSt yG}ztd ddt!|dWYd}~Sd}~ww)!NrRrrrrErPrQrrr.zProfile link illarprirrjzProfile & password update aachuzProfile update aachuzUser record kedaikalazProfiles record kedaikalau!Photo மாறவில்லைz%[Warning] Encoding update failed for r\rrDr5zEmployee updated successfully)r.r9rmprofile_statusrrEmployee not foundr.r9r)"r:rorPr rTrrrrrErrPrQrrr.rrrWrrrMrWrprr3r2rUface_encoding_datarhr|r,r{r^)r_r`rFr:rRrGnew_nameZ name_changedrvr?Zvan_userZ profile_objrsrrmrurrdrdrers "   zEmployeeAPIView.putcCsVztjj|d}|tdddddWStjy*tdddd dYSw) NrrrDr5zEmployee deletedrxrrz Not found)r rTrPrr,rU)r_r`rFrGrdrdrers zEmployeeAPIView.deleterm)rhrirjrPrhrfrrrdrdrdrerOs /%T ^rOc@r0)FetchdesignationAPIViewcCsHtjj|d}g}|D] }||j|jdq ttjddd|dS)N)r)rErFrDr5rq) rrTrrrErFr,r.r[)r_r`rFrr:r(rdrdrerPDs  zFetchdesignationAPIView.getNr rdrdrdrer{Crr{c@r0)StudentStatusAPIViewcCsnz$tjj|d}|jdkrd|_nd|_|tddd|jddWStjy6td d id d YSw) Nrrr@rrDr5Status updated successfullyr. new_statusr9r4zStudent not foundrr-)r rTrPr.rr,rU)r_r`rFstudentrdrdrepatchYs  zStudentStatusAPIView.patchNrhrirjrrdrdrdrer|Xrr|)rr%rr)rr r rr)rgids last_reload,FcCst}tZ|s|tdtkr WddStjjddjdd}gg}}|D]}|}|durA| || |j q,|td<|td<|td<t dt |d WddS1scwYdS) NrT)Zface_encoding_data__isnullr)ryrgrz[Cache] z encodings loaded.) time_moduler% _cache_lock_encoding_cache CACHE_TTLr rTr9 get_encodingrrFr|len)forcerrXrgrrGencrdrdreload_encoding_caches,   "rcCs2t dtd<WddS1swYdS)Nrr)rrrdrdrdrercs "rccCst|trt|d}n|dtt|d}|j \}}t d|d|t ||}|dkr\d|}| t ||t ||ftj}|j \}}t d|d|t||}|dkrd|}| t ||t ||ftj}|j \}}t d |d|t|d }t|d }t|d }t|}tj|d dd}t dt|d|r||fStj|d dd}t dt|d|r||fStt|d} tj| d dd}t dt|d|r| |fS|dkrt d||nd} | d| ftj} t| } tj| d dd}t dt|d|r/| |fS|tj} t| }tj|d dd}t dt|d|rS||fS|gfS)u source: uploaded file object அல்லது file path string 5 different attempts-ல் face detect பண்ணும்: 1. Normal HOG 2. HOG + upsample (small photos) 3. Extra brightness (dark photos) 4. 800px width resize (portrait photos) 5. Horizontally flipped (selfie mirror issue) Returns: (img_array, face_locations) RGBrz[DEBUG] Original size: xrrz[DEBUG] Upscaled to: iz[DEBUG] Downscaled to: g333333?g?g?Zhogr)modelZnumber_of_times_to_upsamplez[DEBUG] Attempt 1 (HOG): z facesr@z$[DEBUG] Attempt 2 (HOG upsample=2): g?z"[DEBUG] Attempt 3 (extra bright): i z![DEBUG] Attempt 4 (800w resize): z[DEBUG] Attempt 5 (flipped): N) isinstancer^ropenconvertseekioBytesIOreadsizer|minresizerZLANCZOSmaxrZ BrightnessZenhanceZContrastZ Sharpnessnparrayr`rfr transposeZFLIP_LEFT_RIGHT)sourceZpil_imgwhshortscalelongrelocsZ bright_arrZnew_hZresizedZ resize_arrZflippedZflip_arrrdrdrer_sj           r_c@r)AttendanceAPIViewc CszQ|jdt}|jd}tjj|dd}|r$|j|d}g}t |dD]\}}| ||j |j j |j j |j|j|jdq+ttjdd d|d WStyq}zttjd d d t|d WYd}~Sd}~ww)NrrLrrS)rLr)rTrFZ studentId studentNamer.rLrrDr5rqrTr)rrPrr3 isoformatrrTrrrVrrFrrr.rLr,r[r{rQr^) r_r`Z query_daterLZ attendancesZattendance_listrYattrrdrdrerPes<      zAttendanceAPIView.getc Cs|jd}|stddiddSzt|\}}|s"tddiddWStj||dd}|s5tdd iddWS|d }ttd }td }|sOtdd iddWSt||} t t | } t | | } t d| dd| dkrxtddiddWS|| } tjj| d} t}t}|jd}tjj| j|d||dd\}}|s||_|d| j}d}nd| j}d}td|| j|t| ddd WSty}zt d!|td"t|id#dWYd}~Sd}~ww)$Nrr9zImage requiredrr-uமுகம் சரியாக தெரியவில்லை! நேரடியாக camera-ஐ பாருங்கள்.rr[uமுகம் தெரிகிறது ஆனால் encode ஆகவில்லை. மீண்டும் முயற்சிக்கவும்.rrgruqபதிவு செய்யப்பட்ட முகங்கள் எதுவும் இல்லை!z[DEBUG] Best match distance: z.4fz (threshold: 0.50)?ubயார் என்று அடையாளம் காண முடியவில்லை!rrZ location_namer)r.in_timelocation)rrdefaultsu@வெளியேறும் நேரம் பதிவு: outu!வருகை பதிவு: inrDrk)rEactionZdistance)r.r9r:z[ERROR] Attendance post: r4i)rorPr,r_r`rarrZ face_distancerrargminfloatr|r rTrrrr%r:r get_or_createrFout_timerrEroundr{r^)r_r` uploaded_filererfZtarget_encodingsZ target_encZknown_encodingsZ known_idsZface_distancesZbest_idxZ best_distanceemp_idZ found_userr3Znow_timerrcreatedmsgrrrdrdrerfs              zAttendanceAPIView.postNrhrirjrPrfrdrdrdrercs rc@4eZdZefZd ddZddZddZdd ZdS) DesignationAPIViewNc Cs(|dur9ztjj|d}|j|j|j|jd}ttj ddd|dWSt y8ttj ddddd YSwzEd }g}tj D].}|d 7}z t jj|jd}|j}Wn t jybd }Ynw|||j|j|j|d qCttj ddd|dWSt yttj ddddd YSw)Nr)rFrE descriptionrrDr5rqrTrrrrr)rTrFrErr)rrTrPrFrErrr,r.r[rrrUrrUr)r_r`rFrr:rYZ designationsrrdrdrerPsd          zDesignationAPIView.getc Cs|j}z'tjj|d|dtjj|dd|jd}|tt j ddddd WSt yK}ztt j d dd d |d WYd}~Sd}~ww) NrErrr)rErrrlrDr5z Designation created successfullyrrTr) r:rrTrrrPrarr,r.rrrQ)r_r`r:rrrdrdrerfs,   zDesignationAPIView.postcCs|j}z,tjj|d}|d|_|d|_tjj|dd|_|t t j dddddWSt yDt t j d dd d dYSw) NrrErrrDr5z Designation updated successfullyrrTr)r:rrTrPrErrrrr,r.r[rr)r_r`rFr:rrdrdrer-s&      zDesignationAPIView.putcCs||dur2ztjj|d}|ttjdddddWSty1ttjdddddYSwttj dddddS) NrrDr5z Designation deleted successfullyrrrr) rrTrPrr,r.r[rrrQ)r_r`rFrrdrdrerDs*     zDesignationAPIView.deleterm rhrirjr$rrrPrfrrrdrdrdrers  8 rc@r) DepartmentAPIViewNcC|dur7ztjj|d}|j|j|jd}ttjddd|dWSt y6ttj ddddd YSwz*d }g}tj D]}|d 7}| ||j|j|jd qAttjddd|dWSt yvttj ddddd YSw) NrrFrErrDr5rqrTrrrr)rTrFrEr) rrTrPrFrErr,r.r[rrrUrr_r`rFrr:rYrrdrdrerP_T         zDepartmentAPIView.getc Cs|j}ztjj|d|d|jd}|ttjdddddWSt yC}zttj ddd d |dWYd}~Sd}~ww) NrEr)rErrlrDr5zDepartment created successfullyrrTr) r:rrTrrarr,r.rrrQ)r_r`r:rrrdrdrerfs*   zDepartmentAPIView.postc Cs|j}z"tjj|d}|d|_|d|_|ttj dddddWSt y:ttj ddd d dYSt y[}zt |ttjddd d dWYd}~Sd}~ww) NrrErrDr5Department updated successfullyrrTrr)r:rrTrPrErrr,r.r[rrr{r|rQr_r`rFr:rrrdrdrers4       zDepartmentAPIView.putcCh|dur2ztjj|d}|ttjdddddWSty1ttjdddddYSwdSNrrDr5zDepartment deleted successfullyrrr rrTrPrr,r.r[rrr_r`rFrrdrdrer"    zDepartmentAPIView.deletermrrdrdrdrer\s  1 r)DecimalInvalidOperation)rr rz%I:%M%p%H:%M:%S%H:%Mc Cst|dvrdSt|tr |St|dd}tD]}z t|| WSt y1Yqwt d|d)zl '09:30 AM', '9:30AM', '09:30', '09:30:00' -> datetime.time Invalid na ValueError raise pannum. NrN.rInvalid time ''. Use hh:mm AM/PM format.) rdt_timer^rupperrp TIME_FORMATSrr1r%rvaluerawfmtrdrdre parse_times  rc Cs,zt|WSttfyt|dwNz must be a number.)r TypeErrorrrfieldrdrdre parse_ints  rc Cs2ztt|WStttfyt|dwr)rr^rrrrrdrdre parse_decimals rcCs"t|tr|St|dvS)N)rtrueyeson)rr7r^rrqrrdrdre parse_bool s r)MonTueWedThuFriSatSuncC(tdt|}|ddd|ddSNrr02d:rrZ total_minutesrdrdrefmt_hhmm" rc stjjdd\}}|jptdd}|jptdd}t|jpd}dd|jp'd d Dfd dt t D}t t|t|d }||||||t|jpSd dS)u Setting table (pk=1) -la irundhu shift timing, grace period, weekly off days edukkum. Monthly + Today rendu API-um idhe function-a use pannanum — settings maathi na rendu idathulayum automatic-a update aagum. rpkrrcS(h|]}|r|ddqSNrkrtitler'prdrdrer)5 (get_attendance_config..r,ch|] \}}|vr|qSrdrdr'r(nmZ off_namesrdrer): minutesr)settingrr r!rrr"half_day_hoursN)rrTrrr%r rr!rsplitrVr%rcombiner2r3rrr r _rr Zgracerrrdrrer4' s( r4cCs tjj||gd}dd|DS)uLHoliday table -la irundhu {date_obj: name} — date range kku eduthu tharum. date__rangecSsi|]}|j|jqSrdrrEr'rrdrdre P z#get_holiday_map..N)r rTr) start_dateend_dateqsrdrdrer5M sr5cCst|ddp t|ddp dS)NrErr—)r:rGrdrdreemp_display_nameS srcCs"t|ddpt|ddpt|jS)NrPr)r:r^rFrrdrdreemp_display_codeW s"rcCt|o||dkSNrr7rr@rdrdreis_late[ r#ipcCsZ|djsdS|r |s dSt}t||t||}|}|tkr'dSt|tS)z Total worked time (out_time - in_time) 8 hours-a thaandi irundha, andha extra seconds mattum OT-a return pannum. in_time/out_time illama irundha, or out_time < in_time (data issue) irundha, OT = 0. r rN)overtime_enabledr2r3rr total_secondsSTANDARD_WORK_SECONDSr)rrr@dZworkedZ worked_secrdrdre ot_secondsd s  r)c@s(eZdZdZddZddZddZdS) SettingAPIViewu=Single settings row (pk=1) — GET fetch, PUT partial update.cCstjjdd\}}|S)Nrr)rrTr)r_r rrdrdrern szSettingAPIView.get_objectc Cs|}|jr |jdnd|jr|jdnddd|jpddD|j|jdur0t|jnd|j |j |j |j |j d }ttjdd d|d S) NrcSsg|]}|r|qSrdrdr'r(rdrdre r*z&SettingAPIView.get..rrr) rr rr!r r%geofence_enabledface_sensitivity company_name time_zonerDr5rq)rnrr<r rrr!r rr%r-r.r/r0r,r.r[)r_r`r r:rdrdrerP s" zSettingAPIView.getc Cs|}|j}dd}zd|vr||d|_d|vr$||d|_d|vr<|d}t|tr7d|n|p:d|_d|vrHt |d|_ d |vrTt |d |_ d |vr`t |d |_d |vrlt |d |_d |vrv|d |_d |vr|d pd|_d|vr|dpd|_|jjr|jnd|_|Wn%ttfy}zttjdddt|dtjdWYd}~Sd}~wwttjdddd||jddS)Nc Ssf|dvrdSt|dd}dD]}z t||WSty*Yqwtd|d)Nrrrrrr)r^rrrprr1r%rrrdrdrer s z&SettingAPIView.put..parse_timerr rrrr!r r%r-r.r/r0rr5Trr-rDzSettings updated successfullyr:r8)rnr:rPrr rlistjoinrrr!rr r7r%r-r.rr/r0rarr updated_byrrrr,r.rQr^r[)r_r`r r:rZworrdrdrer sV      zSettingAPIView.putN)rhrirjrIrnrPrrdrdrdrer*| s  r*c@s,eZdZdZd ddZddZd ddZdS) HolidayAPIViewu%Holiday CRUD — List / Add / Delete.NcCs|dur.)r rTrPrUr,r.rr[rFrEr^rrUr)r_r`rFrholidaysrdrdrerP s.     zHolidayAPIView.getcCs|jdpd}|jdpd}|r|s'ttjdddddtjd Szt|d WntyGttjdddd dtjd YSwt j j |||j j rT|j ndd }ttjd ddd|j|jt|jddtjd S)NrErrrr5TzName and date are required.rr-rz"Date must be in YYYY-MM-DD format.)rErrlrDzHoliday added successfullyr6r8)r:rPrr,r.rQrr1rr rTrrarrrrFrEr^r)r_r`rEZdate_valholidayrdrdrerf sD     zHolidayAPIView.postcCs|durttjdddddtjdSz tjj|d}Wntjy5ttjdddddtjdYSw|ttj d ddd dS) Nrr5TzHoliday id required in URL.rr-rr5rDzHoliday deleted) r,r.rQr rTrPrUrrr[)r_r`rFr8rdrdrer s2    zHolidayAPIView.deleterm)rhrirjrIrPrfrrdrdrdrer4 s   r4c@r0)EmployeeMiniListAPIViewcCs:tjjddd}dd|D}ttjddd|dS) Nrr-rEcSs"g|] }|jt|t|dqS)rFrEr6)rFrrr'rrdrdrer,* z/EmployeeMiniListAPIView.get..rDr5rq)r rTrrr,r.r[)r_r`rXr:rdrdrerP( s zEmployeeMiniListAPIView.getNr rdrdrdrer9' rr9)r%r-c Cs|sdSt|tr=z'dd|dddD}t|dkr+|dt|dks t|}Wnttfy<YdSwt |drF| }|j d|j d |j }tj dtj d }td||S) ze OT = out_time - 6:45 PM out_time illa na (None / empty) -> OT = 0 (calculate pannaadhu) rcSg|]}t|qSrd)rr'rrdrdrer, r*z%ot_seconds_static..rNrkr%r)rr^rrrrrrrhasattrr%hourminutesecondOT_STARTr)rrr@partsZout_secZ start_secrdrdreot_seconds_static s"      rGc@eZdZdZddZdS)MonthattendanceAPIViewa Status per day: P / A / H (Holiday table) / W (Setting.weekly_off) / '--' (future) Late = in_time > shift_start + grace_minutes (Setting table) 3 Late = 0.5 day cut from Present (effective_present) OT = out_time - 6:45 PM (static) Check-in irundhu check-out illa (past date) = A + no_checkout flag Optional filter: ?employee_id= (illa na ellame varum) c!s|jd}|stdditjdSz t|ddWnty/tdditjdYSwj dkrFj j d d d d t d d }nj j d d d t d d }fd dt |jd D}tt||jdpx|jd}tjjd d}|r|dkr|j|d}tjj|gd} t} g} |D]fdd| D} d} }}d}i}|D]}|d}d}d}|}|v}|dv}|rd}nf|rd}na|| krd}nZ|| vr2| |}|jdkr+|js|| krd}|d 7}d}n;d }| d 7} t|jr|d 7}|jrt|j|jnd}|dkr*||7}t|d!}n d}|d 7}nd}|d 7}||||d"||<q|d#}t|d$d%}ttd| |d%}t |d&}t |d&d!} | !j"t#t$| |||d'd(| d'||||d) qtfd*d|D| d+d,d-d,d.d/d,t%d0pd1d2dDd3d4d5dt%&Dd6tj'dS)7Nrr4!val is required. Use ?val=YYYY-MMr--01rInvalid val format. Use YYYY-MM ryearmonthdaydaysrPrQcg|] }t|dqSrRrr& first_dayrdrer, z.MonthattendanceAPIView.get..rrKrUrrcs i|] }|jjkr|j|qSrd)rrFrr'rrrdrer  z.MonthattendanceAPIView.get..r00:00FrHW--rATPrr.ot no_checkoutr-rkrr@r@rr) rFrEr6 total_presenteffective_present total_absenttotal_otrE half_day_cutslate_deduction attendancec Jg|]!}|d|j|d|d|dv|v|dqSrz%dz%ar)rZday_numdisplayday_namer.r,r-r<rQr6rPr+r@rArdrer,c  rrr r!rr"cSr#rdr$r&rdrdrer)u r*z-MonthattendanceAPIView.get..z3 Late = 0.5 day deduction)rr r!rrZ late_rulecS g|] \}}|d|dqSrrr<r'r(nrdrdrer,x )rSreportconfigr7)(rrPr,r.rQrr1rrrPrprOrrangerSr4r5r rTrrr2r3r<r6rr#rrGrrrrrrFrrr=itemsr[)!r_r`rrrlast_daydates_in_month emp_paramrXZall_attendancer3Z final_report emp_recordstotal_ptotal_arE total_ot_secattendance_maprQday_str ot_displayrewdr,r. status_coderecsecrjrkrg total_ot_h total_ot_mrd)r@rGrXrArerP s    "                      zMonthattendanceAPIView.getNrhrirjrIrPrdrdrdrerI  rIc@rH)TodayAttendanceAPIViewuZ Settings + Holiday table wise, particular date-oda present/absent. ✅ Past date la check-in irundhu check-out illa na -> ABSENT list la varum (no_checkout = True, in_time kaattum). Admin out time update pannalaam illa delete pannalaam. ✅ Innaiku (today) check-out illa na innum velai la irukkaanga -> PRESENT. cCs||jd}z|rt|dnt}Wnty(tddit j dYSwt}t }t ||}||}| |dv}|rFdn|rJdnd} |jd } tjjd d} | re| d kre| j| d } tjj|| d d} g} g}| D]r}|j}t|j|}|j|jt|t|t|ddr|jjnd|jr|jdnd|jr|jdnd|rdnd||jdddd }|js||krd|d<||qv|jrt |j|jnd}t!|d|d<|d|d<| |qvdd| D}dd| j"|d D}t#||d!d"d#}t|$| t%|||t&| t&|t&|t#| d$d"d#||d%d|d&d|d'|d(dd)d* t j'dS)+Nrrr4Invalid date. Use YYYY-MM-DDr-rr8workingrrrUr)rZ employee__inrdrrr`LatezOn TimeFr]r) attendance_idrFrEr6rrrZ entry_statuslaterreot_time ot_minutesTrerrrcSsg|]}|jqSrdrrZrdrdrer, z.TodayAttendanceAPIView.get..c Ss<g|]}d|jt|t|t|ddr|jjndddqS)NrF)rrFrEr6rre)rFrrr:rrXr;rdrdrer, s rcSs|d |dfS)NrerErdrrdrdre, rz,TodayAttendanceAPIView.get..keycSs|dS)NrErdrrdrdrer8 srr r!rrr r!r) rday_typer,r-r.rDZ absent_countZno_checkout_count present_listrFr{)(rrPrr1rr2r3rr,r.rQr4r5r6r rTrrselect_relatedrdr#rrFrrr:rrXr<rrrrGrr9r=rr7rr[)r_r`r>r?r3r@rArBr.rrrXrecordsrZno_checkout_listrrGritemrZ recorded_idsZ plain_absentrFrdrdrerP s                  zTodayAttendanceAPIView.getNrrdrdrdrer rrc@r0)UpdateAttendanceOutTimeAPIViewc Cs`t|jdpd}|stdditjdSd}dD]}z t|| }Wq2t y1Yqw|dur?tdditjdSz t j dj|d }Wnt jy^tdd itjdYSw|j}|durot|d ro| }|dur||krtdd |d ditjdS||_|t|j|j}td|j|j|j|jd t|ddtjdS)Nrrr4z)out_time is required. Use HH:MM (24-hour)r-)rrz%Invalid out_time. Use HH:MM (24-hour)rdrAttendance record not foundr%z Out time must be after in time (r)zOut time updatedr)r9rrrrr)r^r:rPrr,r.rQrr1r%rrrTrrUrrrAr<rrrGrFrrrrr[) r_r`rZout_strparsedrrZin_trrdrdrerJ s`    z$UpdateAttendanceOutTimeAPIView.patchNrrdrdrdrerH rkrc@r0)DeleteAttendanceAPIViewcCsTz tjj|d}WntjytdditjdYSw|tdditjdS)Nrr4rr-r9zAttendance deleted) rrTrPrUr,r.rrr[)r_r`rrrdrdrer s zDeleteAttendanceAPIView.deleteN)rhrirjrrdrdrdrer rkrc@rH)EmployeeDashboardAPIViewz GET /employee-dashboard/?employee_id= employee_id kudukkalana, login panna user-oda user_data-la irundhu employee_id anuppanum (frontend already anuppum). cCsp|jd}|stdditjdSz tjj|d}Wntjy-tdditjdYSwt }t }|j dd}|j d krQ|j |jdddd tdd }n|j |j ddd tdd }t||}tjj|d d} tjj|j|d} ||v} ||dv} | rd} n| rd} n| r| jdkrt| j|rdnd} nd} tjj|j||gd}dd|D}d}}}|}|t||kr||dv}||v}|s|s||}|r|jdkr|d7}t|j|r|d7}n|d7}|tdd 7}|t||ks|d}t|dd}ttd||d}ttjddd|jt|t|t |ddr4|j!j"ndd |#| | rH| jrH| j$d!nd"| rV| j%rV| j%$d!nd"d#|d$$d!|d%$d!|d&|d'$d!t&d(d)|dDt&|d*pd+d,|dDd-d.d/t&|'D| r| j(#| j)d0ndd1|$d2||||||d3d4d5tjdS)6Nrr4employee_id is requiredr-rrwr)rQrMrNrRrT) date__gterrrrr z Weekly OffrrNot Checked InrrcSi|]}|j|qSrdrrZrdrdrer r*z0EmployeeDashboardAPIView.get..rrkrr@rDr5r)rFrEr6rrr`)rr.rrrr r!rcss|]}t|VqdSrmr$r&rdrdre z/EmployeeDashboardAPIView.get..r"cSr#rdr$r&rdrdrer) r*z/EmployeeDashboardAPIView.get..)rr+r!rrZweekly_off_dayscSsg|] \}}||dqS)r)r)r'd2rxrdrdrer, s z0EmployeeDashboardAPIView.get..r) this_monthnext%B %Y) month_labelrfrgrhrErjrk)rdr3rr7Z month_summaryrq)*rrPr,r.rQr rTrUrr4r2r3rprPrOrr5r rrfirstrrFr6r#rrrrr[rrr:rrXrr<rr=r}rrE)r_r`rrGr@r3 month_start month_endZmonth_holidaysupcomingZ today_recZis_holiday_todayZis_weekly_off_todayZ today_statusZ month_recordsZ rec_by_daterrrEr(Zis_offZis_holrrjrkrgrdrdrerP s    "            3zEmployeeDashboardAPIView.getNrrdrdrdrer  rc@rH)EmployeeAttendanceAPIViewa  GET /employee-attendance/?employee_id=&date=YYYY-MM-DD date illama kudutha, today edukkum. Status: Present / Late / H (Holiday table) / W (Setting.weekly_off) / Absent / Not Checked In OT = out_time - 6:45 PM (static), out_time irundha mattum cCs0|jd}|stdditjdSz tjj|d}Wntjy-tdditjdYSw|jd}z|r?t |d nt }WntyVtdd itjdYSwt}t||}||}||d v} tjj|j|d } d } d } |rd} n>| rd} n9| r| jdkrt| j|} | jrt| j| jnd } | rdnd} n| rd} n|t krd} n |t krd} nd} ttjddd|jt|t|d|| | | r| jr| jdnd| r| jr| jdndt| d|dt || |dd|dd|d|dddd d!tjdS)"Nrr4rr-rrwrrrrrFrr^r_rrAbsentr`rrDr5r:rr)r.rrrrr-rr r!rr)rdrrecordr,r.r{rq)!rrPr,r.rQr rTrUrrr1rr2r3rr4r5r6rrrFrr#rrrGr[rrrr<rr7)r_r`rrGr>r?r@rArBr.rrrZ record_statusrdrdrerP- s               zEmployeeAttendanceAPIView.getNrrdrdrdrer$  rc@rH) EmployeeMonthlyAttendanceAPIViewz GET /employee-monthly-attendance/?employee_id=&val=YYYY-MM Same day-status rules as MonthattendanceAPIView, but scoped to ONE employee and returns a single "row" object instead of a list. OT = out_time - 6:45 PM (static) cs|jd}|jd}|stdditjdS|s"tdditjdSz tjj|d}Wntjy>tdditj dYSwz t |d d  Wnt y]tdd itjdYSwjd krtjjd d d dtd d}njjd d dtd d}fddt|jd D}tt|ddtjj|j|gdD}t}d} } } d} i} |D]}|d }d}d}|}|v}|dv}|rd}nh|rd}nc||krd}n\||vr;||}|jdkr4|js||krd}| d 7} d}n;d }| d 7} t|jr| d 7} |jr"t |j|jnd}|dkr3| |7} t!|d!}n d}| d 7} nd}| d 7} ||||d"| |<q| d#}t"|d$d%}t"t#d| |d%}t$| d&}t$| d&d!}ttj%d'd(d|jt&|t'|d)fd*d|D| || |d+d,|d+| ||| d-d.d/d0d/d1d2d/t(d3pd4d5dDd6d7dt()Dd8d9tj%dS):Nrrr4rr-rJrrwrKrrLrMrrNrRrTcrUrVrr&rWrdrer,KrYz8EmployeeMonthlyAttendanceAPIView.get..cSrrdrrZrdrdrerRsz8EmployeeMonthlyAttendanceAPIView.get..rrr]Frr^r_r`rraTrbrrcrkrr@r@rDr5r:c rmrnrqr+rrrdrer,rsrr)rfrgrhrirErjrkrlrrr r!rr"cSr#rdr$r&rdrdrer)r*z7EmployeeMonthlyAttendanceAPIView.get..)rr r!rrcSrtrurvrwrdrdrer,ry)rdrSrTr{Zholidays_this_monthrq)*rrPrr,r.rQr rTrUrrr1rrrPrprOrr|rSr4r5rrrFr2r3r<r6rr#rrGrrrrr[rrr=r})r_r`rrrGr~rrr3rrrErrrQrrrerr,r.rrrrjrkrgrrrd)r@rXrArerP's      "                   -z$EmployeeMonthlyAttendanceAPIView.getNrrdrdrdrerrr) LeaveRequestscCsn|j|jt|jt|j|j|j|j|j |j |j |j |j r'|j dnd|jr3|jdd Sdd S)Nz%Y-%m-%d %I:%M %p) rFr employee_nameZ employee_code leave_typerr days_countrr. admin_note applied_at reviewed_at)rFrrrdrrrrrrrr.rrr<r)lvrdrdre leave_jsons  rc@s eZdZdZddZddZdS)EmployeeLeaveAPIViewz GET /employee-leave/?employee_id= -> list own leave requests POST /employee-leave/ {employee_id, leave_type, start_date, end_date, description} cCsX|jd}|stdditjdStjj|dd}ttj dddd d |Dd S) Nrr4rr-rrdrDr5cSr>rdrr'rrdrdrer,r*z,EmployeeLeaveAPIView.get..rq) rrPr,r.rQrrTrrr[)r_r`rleavesrdrdrerPs   zEmployeeLeaveAPIView.getc Cs6|j}|d}|stdditjdSz tjj|d}Wntjy/tdditjdYSw|dd}|d }|d }|d pFd }zt |d  } t |d  } Wnt tfyotdditjdYSw| | kr}tdditjdStjj||| | |dd} ttjddddt| dtjdS)Nrr4rr-rrwrCasualrrrrrz1start_date/end_date required in YYYY-MM-DD format$End date cannot be before start datePending)rdrrrrr.rDr5zLeave request submittedr8)r:rPr,r.rQr rTrUrrrr1rrrrrrr) r_r`r:rrGrZ start_strZend_strrrrrrdrdrerfsP      zEmployeeLeaveAPIView.postN)rhrirjrIrPrfrdrdrdrers rc@s0eZdZdZddZddZddZdd Zd S) EmployeeLeaveDetailAPIViewz GET /employee-leave// PUT /employee-leave// -- edit, only allowed while status="Pending" DELETE /employee-leave// -- cancel, only allowed while status="Pending" cCs.z tjdj|dWStjyYdSw)Nrdr)rrTrrPrUr_rFrdrdrerns z%EmployeeLeaveDetailAPIView.get_objectcCs<||}|stdditjdSttjdddt|dS)Nr4Leave request not foundr-rDr5rq)rnr,r.rr[rr_r`rFrrdrdrerP%s  zEmployeeLeaveDetailAPIView.getcCs$||}|stdditjdS|jdkr#tdd|jditjdS|j}z d|vr6t|dd|_ d |vrEt|d d|_ Wnt yXtdd itjdYSw|j |j krhtdd itjdSd |vrq|d |_ d |vr| d p{d|_|ttjddddt|dS)Nr4rr-ru&Cannot edit — this leave is already rrrrDates must be YYYY-MM-DDrrrrrDr5zLeave request updatedr8)rnr,r.rrQr:rr1rrrrrrPrrrr[r)r_r`rFrr:rdrdrer/s>      zEmployeeLeaveDetailAPIView.putcCsf||}|stdditjdS|jdkr#tdd|jditjdS|ttjdddd d S) Nr4rr-ru(Cannot cancel — this leave is already rrDr5zLeave request cancelledr)rnr,r.rrQrr[rrdrdrerRs   z!EmployeeLeaveDetailAPIView.deleteN)rhrirjrIrnrPrrrdrdrdrers  #rc@rH)AdminLeaveListAPIViewz GET /admin-leave/?employee_id=&status=&val=YYYY-MM employee_id="all" or omitted -> every employee status omitted -> every status val omitted -> every month c Cstjd}|jd}|r|dkr|j|d}|jd}|r,|dkr,|j|d}|jd}|rQztt| d\}}|j||d }Wn t yPYnwt t j d d dd d |D|jdd|jdd|jddddS)NrdrrUrr.r-r-)Zstart_date__yearZstart_date__monthrDr5cSr>rdrrrdrdrer,r*z-AdminLeaveListAPIView.get..rApprovedRejected)pendingZapprovedrejectedr.r4r:summary)rrTrrUrrPrmaprrrr,r.r[r)r_r`rr status_filterrrOrPrdrdrerPms0          zAdminLeaveListAPIView.getNrrdrdrdrerdrrc@rH)AdminLeaveActionAPIViewzX PUT /admin-leave//action/ {status: "Approved" | "Rejected", admin_note?} cCsz tjdj|d}WntjytdditjdYSw|jd}|dvr3tdditj dS||_|jd p=d pAd|_ |j j rJ|j nd|_t|_|ttjd d dd |t|dS)Nrdrr4rr-r.)rrrz-status must be Approved, Rejected, or PendingrrrDr5zLeave marked as r8)rrTrrPrUr,r.rr:rQrrrarr reviewed_byrrrrr[r)r_r`rFrrrdrdrers,   zAdminLeaveActionAPIView.putN)rhrirjrIrrdrdrdrers rc@rH)TodayUpcomingLeaveAPIViewu GET /leave-today-upcoming/?employee_id= Used by the admin "View Employee" screen — shows who's on Approved leave today, and Approved leaves starting in the next 30 days. cCs|jd}t}tjjddd}|r |dkr |j|d}|j||d}|j||tdd d  d }t t j d d ddd|Ddd|DddS)Nrrr-rdrUr)start_date__lteZ end_date__gterrR)Zstart_date__gtrrrDr5cSr>rdrrrdrdrer,r*z1TodayUpcomingLeaveAPIView.get..cSr>rdrrrdrdrer,r*)r3rrq) rrPr2r3rrTrrrrr,r.r[)r_r`rr3rZ today_leavesZupcoming_leavesrdrdrerPs$      zTodayUpcomingLeaveAPIView.getNrrdrdrdrerrr)rr) transaction)r*Countr )r FeeClientFee FeePaymentTcCs>t}t|rt|t|kS||kSrm)rris_aware localtimer)dtrrdrdre _is_todays rcC,|r t|jt|kr dStot|j S)zGPayment-ah collect pannina employee mattum (same day-na) edit pannalam.FN)r^collected_by_idEMPLOYEE_EDIT_SAME_DAY_ONLYr created_at)paymentrrdrdre_can_edit_paymentsrcCr)zoFee record-ah create pannina employee mattum (same day-na) service / due date / fee amount ellam maathalam.FN)r^rYrrr)feerrdrdre _can_edit_feesrcCs|j|j|j|j|j|jdS)NrF client_coderErP gst_numberr.r)crdrdre client_jsonsrc CsP|j|jt|j|jd|j|j|j|j r|j jnd|j r"|j j ndddS)Nrr)rFrE)rFfee_idamount payment_date payment_mode reference_nonote collected_by) rFrr^rrr<rrrrrE)rrdrdre payment_jsons rc Cs|jt|j|jdkr|jn|jpdt|j|j|j d|j r&|j dndt|j t|j |j d }|rBdd|jD|d<|S)NOtherr) rFclientservice fee_amountbilling_frequencydue_date next_due_date paid_amountbalancepayment_statuscSr>rd)rrrdrdrer,:r*zfee_json..payments)rFrrr service_otherr^rrrr<rr r r r rU)f with_paymentsr:rdrdrefee_json,s  rc@r)FeeClientListAPIViewcCsj|jdd}tjjdd}|r$|t|dt|dBt|dB}ttj dd dd d |Dd S) Nsearchrrr-rZclient_code__icontains)Zmobile__icontainsrDr5cSr>rd)rr'rrdrdrer,Qr*z,FeeClientListAPIView.get..rq) rrPrrrTrr r,r.r[)r_r`rclientsrdrdrerPCs  zFeeClientListAPIView.getcCsR|j}|dp d}|dpd}|s tdditjdSt|dkr/tdditjdS|r@td |s@tdd itjdSt j j |d d  }|rattj d ddd|jddt|dS|rt j j |d d }|rttj d ddd|jddt|dSt j j||pd|d|dd}ttjd ddddt|dtjdS)NrErrPr4zClient name is requiredr-r@zClient name is too shortz\d{10}z'Mobile number must be exactly 10 digitsr) name__iexactr.rDr5zA client named "z" already exists.T)r.r4r9Zalready_existsr:)rPr.z2A client with this mobile number already exists ("z").rr)rErPrrz Client addedF)r:rPrr,r.rQrrR fullmatchrrTrrr[rErrr)r_r`r:rErPZexisting_by_nameexistingrrdrdrerfTs\      zFeeClientListAPIView.postNrrdrdrdrerBs rc@r0)FeeClientDetailAPIViewcCsz tjj|d}WntjytdditjdYSwtjj|dj t dddp-d }t jj|d  d d  }ttjd ddit|t||rR|jdnd|rZt|jndddS)Nrr4Client not foundr- client_idr trrfee__client_id -payment_daterSrDr5%d-%m-%Y)pending_balancelast_payment_datelast_payment_amountrq)rrTrPrUr,r.rrr aggregater*rrrr[rr^rr<r)r_r`rFrr# last_paymentrdrdrerPs*"  zFeeClientDetailAPIView.getNr rdrdrdrerrrc@r0)FeeDetailAPIViewcCsfztjddj|d}Wntjy"tdditjdYSwttj dddt |d d d S) Nrr rr4Fee record not foundr-rDr5Trrq) rrTrprefetch_relatedrPrUr,r.rr[r)r_r`rFrrdrdrerPs  zFeeDetailAPIView.getNr rdrdrdrer(rr(c@r0)AdminFeesListAPIViewc Cstjdd}|jd}|jd}|jd}|jd}|jd}|rAz|jt|d d }Wn t y@Ynw|r[z|jt|d d }Wn t yZYnw|rg|d krg|j|d }|rs|d krs|j|d }|r|d kr|j|d }| d}|j tdddpd}|j tdddpd} ttjddddd|Dt|t| t|| |jdd |jdd |jdd ddS)Nrr fromtorr.rr)Z due_date__gte)Z due_date__lterU)r )r)Zpayments__collected_by_id -due_daterrrrr rDr5cSr>rdrr'rrdrdrer,r*z,AdminFeesListAPIView.get..rPartialPaid) total_billedtotal_collected total_pending pending_countZ partial_countZ paid_countr)rrTrr+rrPrrr1rrdistinctrr&r*r,r.r[r^r) r_r`rfrom_strto_strrrZservice_filterr4r5rdrdrerPsN                zAdminFeesListAPIView.getNr rdrdrdrer,rr,cCsp|jd}|jd}|jd}|r|dkr|j|d}|r*|dkr*|j|d}|r6|dkr6|j|d}|S) uemployee_id / service / payment_mode — AdminFeesSummary & EmployeeCollectionReport rendayum idhu 3 filters-ah share pannikuranga.rrrrUr fee__servicerN)rrPr)Z payment_qsr`rrrrdrdre_apply_common_filterss         r?c@r0)AdminFeesSummaryAPIViewc Cst}tjddd}t||}t|j|djt dddp!dt|j|j |j d jt dddp5dt|j|j d jt dddpGdt|j|d jt dddpXdd }|}|j d }|j d}|rz|jt|dd}Wn tyYnw|rz|jt|dd }Wn tyYnw|djt ddd}dd|D} |jt dddpd} ttjddd|t| | ddS)Nr fee__clientrrrrrrpayment_date__yearZpayment_date__month)rDZpayment_date__lte)r3r this_yearZ till_todayr-r.rZpayment_date__gter=)r-totalcSs"g|] }|dt|ddqS)r=r)rrr^r'rTrdrdrer,8r<z/AdminFeesSummaryAPIView.get..rDr5)countsall_services_total by_servicerq)rr3rrTrr?r^rr&r*rOrPrrPrr1rvaluesannotaterr,r.r[) r_r`r3base_qsrKZrange_qsr9r:Zby_service_rowsrMrLrdrdrerP sn       zAdminFeesSummaryAPIView.getNr rdrdrdrer@ rr@c@rH)EmployeeFeesAPIViewu GET /employee-fees/?employee_id=&from=&to= ✅ Date-wise filter — "from"/"to" kudukkaama vittal, DEFAULT-a "TODAY" oru naaள் data mattume varum (munnadi "whole month" default-a irundhuchu, ippo employee login pண்ணும்போதே "today's collection" first-a தெரியும்). "from"/"to" kudutha, andha range-oda data varum. Old "month=YYYY-MM" param-um still support pண்ணுrom (backward-compatible). c s|jdstdditjdS|jd}|jd}|jd}tjjdd d }|s2|r|rNzt |d  }|j|d }Wn t yMYnw|rjzt |d  }|j|d }Wn t yiYnw|r|r||kr|t d kr}dnt |d d}nZ|r|rt |d ddt |d d}n@d}n=|rztt|d\} } |j| | d}t | | dd}Wnt ytdditjdYSwt } |j| d}d}|d}|jtdddpd} ttjddd|t| |fd d!|Dd"d#S)$Nrr4rr-r-r.rPr;rrArrGrETodayz%d %b %Yz%d %bu – zSelected rangerrCrrzmonth must be YYYY-MMrBr!rrrrrDr5c sNg|]#}it||jj|jjj|jjj|jjt|p!t|jdqS))rr client_namerZcan_edit) rrrrrrErrrrrrdrer,s z+EmployeeFeesAPIView.get..)rr5 payment_countr rq)rrPr,r.rQrrTrrrr1rrr3r<rrrrr&r*r[r^r) r_r`r9r:Z month_strr Z from_dateZto_dateZ range_labelrOrPr3r5rdrTrerPWst            zEmployeeFeesAPIView.getNrrdrdrdrerQLs rQc@rH)EmployeeCollectionReportAPIViewu GET /employee-collection-report/?employee_id=&from=&to=&service=&payment_mode=&client_id= ── employee_id="all" (illa kudukkaama vittal) ── "mode": "all" — ella employees-oda totals-um oru list-a varum (idha vachu "All Employees" filter-la, andha date range-oda ella employees collection-um oru table-a paakalam). ── employee_id= ── "mode": "employee" — andha ஒரு employee-oda full report (Total Clients, Total Collections, payment history table) — munnadi maari thaan. client_id kூda kudutha, adhoda mேlே oru "client_summary" block-um varum: andha client-ku last payment eppo, evlo, இப்போது pending balance evlo nu. (client_summary — andha client-oda ella employees payments-um vachu calculate aagum, ellai ippove filter panna employee mattum illa — "last paid when/how much" nu client-oda real status idhு.) c Cs|jd}|jd}|jd}|jd}|jd}|jd}|r*|dkrtjdd d }|rLz|jt|d d }Wn t yKYnw|rfz|jt|d d }Wn t yeYnw|rr|dkrr|j|d}|r~|dkr~|j|d}|r|dkr|j|d}| ddj t dt dt ddddd} |jt dddpd} ttjddddt| dd | Dd!d"Sz tjj|d#} Wntjytd$d%itjd&YSwtjj|d'dd }|rz|jt|d d }Wn t yYnw|r$z|jt|d d }Wn t y#Ynw|r2|dkr2|j|d}|r@|dkr@|j|d}|rN|dkrN|j|d}|d(}|jt dddp_d} | d} d} |r|dkrzEtjj|d#}tjj|d)jt d*ddpd}tjj|dd+d,}|j|jt||r|jd-nd|rt|j ndd.} Wn tjyYnwttjdddd/| j| t| | d0d |Dd1d"S)2Nrr-r.rrrrUrrArrrGrEr<r>rrcollected_by__namerrFr T)r8)rrUrrHrrrrDr5cSs8g|]}|d|dp dt|d|d|ddqS)rrWrrrUr)rrtotal_collectionsrU total_clientsrIrJrdrdrer,s  z7EmployeeCollectionReportAPIView.get..)moderXrXrqrr4rwr-r;rrr r!rSr")rrEr#r$r%rdcSs6g|]}|jd|jjj|jjt|j|jdqS)r")rrrrr) rr<rrrErr^rrrrdrdrer,;s )rZrrYrXclient_summaryr )!rrPrrTrrrr1rrrNrOr*rrr&r,r.r[r^r rUrr8rrrrrrErr<r)r_r`rr9r:rrrrrowsrXrdrYr[rr#r'rdrdrerPs                       "   z#EmployeeCollectionReportAPIView.getNrrdrdrdrerVs rVZPtsImh5xd6D9V8yaSQoifOPlrj41c2TELqFwp7BkHCKeNAXgJYWWpKkENHqSL35VRrnJ6XlF8xBIgZfC4cCszt|jjpd}|stdWdS|dddddd}|dr.|dd }t|d ks8| sCtd |WdSt j j |d j td ddpSd}|j|}|jdkrd|jrd|jn|j}d|jjd|jdd|d|dd|jd|jdd }d}tddd} d|dd|d d!} tj|| | d"d#} td$| j| jd%kr| } | d&d'urtd(|Wd'Std)| WdStd*| jd+| jWdSty} ztd)| WYd } ~ dSd } ~ ww),z9Payment save aana apparam client-ku Fast2SMS SMS anuppum.rzClient mobile number missingFz+91rir0rN zInvalid client mobile number: )rrrrrrzHi zW, Manju Associates Payment Received Successfully We have received your payment of Rs.z,.0fz for z. Balance: Rs.z Collected by: z Date: r"z; Thank you for choosing Manju Associates. Have a nice day!z#https://www.fast2sms.com/dev/bulkV2zapplication/json) authorizationacceptz content-typeqenglishr)router9languageZflashnumbersZ sms_details)headersjsontimeoutzFast2SMS Response: %srreturnTz!Payment SMS sent successfully to zFast2SMS SMS failed: zFast2SMS HTTP Error r\) r^rrPrloggerr4rp startswithrisdigitrrTrr&r*rrr rErrr<FAST2SMS_API_KEYrequestsrfinfotextrrhrPr{ exception)rrrdrM total_paidr rbodyrXrgr:r7resultrrdrdresend_payment_smsXs         rvc@r0)FeePaymentCreateAPIViewc Cs|j}|d}|stdditjdSz tjj|d}Wntjy/tdditjdYSw|d}|s@tdditjdSzt t |}|d krMt Wnt t fybtdd itjdYSw|d }|rz t jj|d}Wnt jytdd itjdYSw|d }|d} |r| stdditjdSz tjj|d} WntjytdditjdYSwz t| d} WntytdditjdYSw|d|} zt t | } | d krt Wnt t fytdditjdYSwt jj| |dd|d| |dd| |d}|d}z|r+t|dnt}WntyCtdditjdYSwtjj|||||dd|d|d d!}|t|||ttjd"d#dd$t|d%d&d'tjdS)(Nrr4rr-rrwrzamount is requiredrz&amount must be a valid positive numberrr)rrz7client_id and due_date are required to create a new feerrzdue_date must be YYYY-MM-DDrz*fee_amount must be a valid positive numberrz GST Filingr rMonthly)rrr rrrrlrzpayment_date must be YYYY-MM-DDrCashrr)rrrrrrrrDr5zPayment recordedTr*r8)r:rPr,r.rQr rTrUrrr^rrrrrr1rrrr3rrefresh_from_dbrvrr)r_r`r:rrdrrrrZ due_date_strZ fee_clientrZfee_amount_rawrZpayment_date_strrrrdrdrerfs                 zFeePaymentCreateAPIView.postNrgrdrdrdrerwrrwc@r0)ClientHistoryAPIViewc s\|jd}|stdditjdSz tjj|d}Wntjtfy/tdditj dYSwt jj |d d d }|jtd td td d }tjj |d dd dd}|}ddttjdddt|t|dprdt|dpydt|dpdd|r|jdt|j|jr|jjnddnddd|Dfd d|Dd!d"S)#Nrr4zclient_id is requiredr-rrrrr/rr r )rpaidrrrrr!rScSs|jdkr|jS|jp dS)Nr)rr )rrdrdresvcz%ClientHistoryAPIView.get..svcrDr5rr|r)Z total_feersr6r"r)rrrcSr>rdr0r1rdrdrer,r*z,ClientHistoryAPIView.get..c sHg|] }|j|j|jdt|j|j|j|jr|jj nddqS)r"r)rFrrrrrr) rFrrr<r^rrrrrErr}rdrer,s  )rtotalsr'feesr rq)rrPr,r.rQrrTrUrrrrrrr&r*rrr[rr^rr<rrrE)r_r`rrrrr lastrdrrerP}sJ        zClientHistoryAPIView.getNr rdrdrdrer{|rr{c@s4eZdZddZddZddZddZd d Zd S) FeePaymentDetailAPIViewcCs2z tjdddj|dWStjyYdSw)NrrArr)rrTrrPrUrrdrdrerns z"FeePaymentDetailAPIView.get_objectc Csx|j}t||jt|j|j|jt|j|j |j d|j r$|j dndt|j t|j|jd t||t||dS)Nr) rFrrr rrrrr r r )rrZcan_edit_paymentZ can_edit_fee)rrrFrrrr r^rrrr<rr r r rr)r_rrrrdrdre_details"  zFeePaymentDetailAPIView._detailcCsL||}|stdditjdS|jd}ttjddd|||dS)Nr4Payment not foundr-rrDr5rq)rnr,r.rrrPr[rr_r`rFrrrdrdrerPs    zFeePaymentDetailAPIView.getc s||}|stdditjdS|jd}|s#tdditjdS|j}t||}t ||}t r4dnd}|sG|sGtdd|d itj dSd } d } |set fd d | Dretdd|d itj dS|st fdd | Drtdd|d itj dSdd} dd} dd} |j }|j}|j}tt|j}z|rdvr| d}dr| d}drddtjdjD}d|vr| dWSd}|r7dvr| d}drddtjdjD}d|vr| d WSd!rd"dtjd!jD}d!|vr| d#WSd$r&| d$nd}d%r4| d%nd}nd}}WnttfyL| d&YStyY| d'YSw|jj|jd(jtdd)d*pntd+}|||kr| d,||d-|d.St !|rt"|o||j#k}t"d!od!|j$k}||_drd|_%d/vrňd/pd&pd|_'d!rЈd!|_$|r||_#|r||_(n |s|r|)|_(|*|r#||_ ||_||_d0vr d0pd&p d|_+d1vrd1pd&pd|_,|*n|-Wdn 1s2wY||}ttj.d2d3dd4|/||d5S)6Nr4rr-rrz (same day only)rz5Only the employee who entered this record can edit itr)rrrrr)rr rrrrc3|]}|vVqdSrmrdr'kr:rdrerrz.FeePaymentDetailAPIView.put..zYou can't edit this paymentc3rrmrdrrrdrerrzOYou can't edit the fee details (service / due date / fee amount) of this recordcSstd|itjdS)Nr4r-)r,r.rQ)rrdrdrebadz(FeePaymentDetailAPIView.put..badcSst|dS)Nr)rr1rrrdrdre parse_datez/FeePaymentDetailAPIView.put..parse_datecSstt|}|dkr t|S)Nr)rr^r)rvrdrdre parse_moneys z0FeePaymentDetailAPIView.put..parse_moneyrrrcSh|]}|dqSrrdrrdrdrer)r*z.FeePaymentDetailAPIView.put..zInvalid payment moderrcSrrrdrrdrdrer) r*zInvalid servicercSrrrdrrdrdrer)$r*zInvalid billing frequencyrrz&Amount must be a valid positive numberrrrrr]uTotal collected (₹u") would exceed the fee amount (₹).r rrrDr5zRecord updatedr8)0rnr,r.rr:rPrQrrrrrVanyrrrrr^rr_meta get_fieldchoicesrrrrr r9rFr&r*ratomicr7rrrrr rcompute_next_due_daterrrrecalcr[r)r_r`rFrrrZcan_payZcan_feeZruleZpay_keysZfee_keysrrrZ new_amountZ new_pay_dateZnew_modeZnew_fee_amountvalidZnew_dueZ new_next_dueothersZ due_changedZ freq_changedrdrrers                   *              zFeePaymentDetailAPIView.putcCst||}|stdditjdS|jdp|jd}t||s*tdditjdS| ttj ddddd S) Nr4rr-rz9Only the employee who entered this payment can cancel it.rDr5zPayment removedr) rnr,r.rrrPr:rrVrr[rrdrdrer^s   zFeePaymentDetailAPIView.deleteN)rhrirjrnrrPrrrdrdrdrers  |rc@rH)EmployeeStatusAPIViewu Active / Inactive toggle mattum. geostatus-ஐ இதுல தொடாது — அது தனி concept, தனி button, தனி API (கீழ EmployeeGeoStatusAPIView). cCstz tjj|d}WntjytdddddddYSw|jdkr'd nd|_|td d d|jd d S)Nr>rrr5rwr.r4r-rr@rrDr}r~)rrTrPrUr,r.rr_r`rFrdrdrdrerts" zEmployeeStatusAPIView.patchNrhrirjrIrrdrdrdrerns rc@rH)EmployeeGeoStatusAPIViewu ✅ புது API — "Anywhere Attendance" / WFH toggle. geostatus = 1 -> office geofence-ஐ bypass பண்ணி எங்கிருந்தும் attendance mark பண்ணலாம் geostatus = 2 (அல்லது default) -> office radius-க்குள் தான் attendance mark பண்ண முடியும் PATCH /employee-geostatus// cCsz tjj|d}WntjytdddddddYSwt|d|jd kr,d nd |_|td d d|j|jd krDd dSddS)Nr>rrr5rwrr-ZRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRrr@rrDzAnywhere attendance enabledu9Anywhere attendance disabled — office location required)r.Z new_geostatusr9)rrTrPrUr,r|rOrrrdrdrers*  zEmployeeGeoStatusAPIView.patchNrrdrdrdrerrrc@r) AnnAPIViewNcCr) Nr)rFrrrDr5rqrTrrrr)rTrFrr) r rTrPrFrrr,r.r[rrrUrrrdrdrerP.rzAnnAPIView.getc Cs|j}z'|d}|d}tjj|d|d|jd}|ttjdddddWSt yK}zttj ddd d |dWYd}~Sd}~ww) Nrr)rrrlrDr5z!Announcement created successfullyrrTr) r:r rTrrarr,r.rrrQ)r_r`r:rrrrrdrdrerf_s.   zAnnAPIView.postc Cs|j}z*|d}|d}tjj|d}|d|_|d|_|ttj dddddWSt yBttj ddd d dYSt yc}zt |ttjddd d dWYd}~Sd}~ww) NrrrrDr5z!Announcement updated successfullyrrTrr)r:r rTrPrrrr,r.r[rrr{r|rQ)r_r`rFr:rrrrrdrdrerys8       zAnnAPIView.putcCrr) r rTrPrr,r.r[rrrrdrdrerrzAnnAPIView.deletermrrdrdrdrer+s  1 $rc@r) LeaveAPIViewNc Cs|dur=z#tjj|d}|j|j|j|j|j|jd}t tj ddd|dWSt y<t tj ddddd YSwzrdrdrerPsf          zLeaveAPIView.getc Cs|j}zc|d}|d}t|d|d|d|d|jd}|tjj|jd}tjj|jd}|j}d} d} d |j d |d |d | d } |j} t | | t j |gd} | ttjdddddWSty}zttjdddd|dWYd}~Sd}~ww)NrEtotaldayr leavedate)rrrrrlr>z+https://pearlpackagingindia.com/manageleave Leave requestz Hi am z,, This is my leave request for z. Total days: z[ You can log in using the following link and check: z) rrt from_emailr.rDr5z"Leave request created successfullyrrTr)r:r rarrrTrPrr<rEr&rEMAIL_HOST_USERsendr,r.rrrQ)r_r`r:ZcasualmanZ leave_requestjkZmeesiro login_urlrrtwer<rrdrdrerfs^     zLeaveAPIView.postc Cs|j}z,tjj|d}|d|_|d|_|d|_|d|_|t t j ddddd WSt yDt t j d dd d d YStye}zt|t t jd dd d d WYd}~Sd}~ww)NrrErrrrDr5rrrTrr)r:r rTrPrrrrrr,r.r[rrr{r|rQrrdrdrer6s8         zLeaveAPIView.putcCrrrrrdrdrerUrzLeaveAPIView.deletermrrdrdrdrers  =D rc@s$eZdZefZdddZddZdS)ManageleaveAPIViewNc Cs|dur?z%tjj|d}|j|j|jt|j|j|j d}t t j ddd|dWSt y>t t jddddd YSwzkd }g}tjj|jd }|D]O}tjj|jd D]D}|d 7}|j} | d} z|j} tjj| d} | jd| j} Wnttjfyd} Ynw|||j|j|j|j| |j | dqXqNt t j ddd|dWSt yt t jddddd YSw)Nr)rFrErrrrrDr5rqrTrrr)r)rlrrriUnknown)rTrFrrrrr.r2)r rTrPrFrrrrrrr,r.r[rrrrrar?rr<rYrr\rrrUr)r_r`rFrr:rYrZerpmrr>r?rr2rdrdrerPksz          zManageleaveAPIView.getc Cs|j}z+z|ddurt|dnd}Wn ttfy"d}Ynw|d}|dd}|dd}|dkr;d}n |dkrBd }nd }z_tjj|d } || _|d d| _|d d| _ || _ || _ |dd| _ | |dkrztjj| jd} | jdurd| _t| j| _| Wntjytd| jdYnwWntjytd|dtt jdddddYWSwz>tjj|jd} tjj| jd} | j} d} d}d|d|d|d| d }| j}t|d t||tj|gd!}|Wn!tjy"td| jdtt jdddd"dYWSwtt jd#ddd$dWStyEtt jdddddYStyj}ztd%|tt jdddd&dWYd}~Sd}~ww)'Nrr.rErrr3rrrrrrr>rzProfile for user ID z does not exist.zLeaveRequest with ID rr5Trrz,https://pearlpackagingindia.com/leaverequestrz$ Your leave request z is z. Total days: zU You can log in using the following link and check: z zSending email to recipientrz(Profile not found for email notificationrDzRequest updated successfullyzError occurred: r) r:rrrrPr rTrrrrr.rrrrYZ total_leaverrUr|r,rrar<r&rrrr[rr{rQ)r_r`rFr:ZrtostamlnamesrrrrrrrrtZrecipient_emailr<rrdrdrers                zManageleaveAPIView.putrm)rhrirjr$rrrPrrdrdrdrerhs  Lrc@r0) FpAPIViewc Cs|j}z/|di}|d}|d}t|}tjj|d}||_|ttj dddddWSt yS}zttj d dd d |dWYd}~Sd}~ww) Nrr<r3r;rDr5zPassword reset successfullyrrTr) r:rPrrrTr3rr,r.r[rrQ) r_r`r:rr<r3rrrrdrdrerfus,      zFpAPIView.postNrgrdrdrdrerqs rcCrrrrrdrdrerrcstjjdd\}}|jptdd}|jptdd}t|jpd}dd|jp'd d Dfd dt t D}t t|t|d }||||||d S)NrrrrrrcSrrrrrdrdrer)rrrrcrrdrdrrrdrer)r r )r rr r!rr)rrTrrr%r rr!rrrVr%rrr2r3rrrdrrer4s$cCrr r!r"rdrdrer#r$cCsH|r||dkr dSt}t||t||d}t|dS)Nr rr)r2r3rrrr&)rr@r(diffrdrdrers rc@eZdZdddZddZdS) SalaryAPIViewNc Cs|dur7ztjj|d}|j|j|jd}ttjddd|dWSt y6ttj ddddd YSwzt }t |jd |j}t |jd |j}t||d }d dl m} | ||d } | |||} tdd d } d} d }g}tjD]}|d 7}tjj|j| | d}|jdd}d }|jddD]}|jr|j| kr|d 7}q|dd}td||}|id|d|jd|jd|jdt|jdt|j dt|j!dt|j"dt|j#dt|j$d |d!|d"|d#|d$|d%t|j%d&t|j&t|j't|j(t|j)t|j*||d't+|q{ttjddd|dWSt,yX}zt+d(|ttj-dddt.|d WYd}~Sd}~ww))NrrrDr5rqrTrrrPrOrrrrrk)rrZ date__lterr-rrrTrFrErr grossSalarybasichra conveyanceotherAllowanceZ totalDaysZ workingDaysZ presentDaysZ lateCountZ lateDeductionfixedPTpfLimit)advancerd reimbursement incentiverPrOrn)/rrTrPrFrErr,r.r[rrrrrrrPrOcalendar monthrangerr%r rUrrrrrrrrrrrrrrrrrrdrrr|r{rQr^)r_r`rFrr:rrPrOrrrrZ LATE_TIMEZLATES_PER_DAY_CUTrYrZ attendance_qsZ present_daysrErZlate_deduction_daysZ working_daysrrdrdrerPs                        zSalaryAPIView.getc Cs|j}ztjj|d}|d|j|_|d|j|_|d|j|_|d|j|_|d|j|_|d|j |_ |d|j |_ |d |j |_ |d |j |_ |d |j |_ |d |j|_|d |j|_|d|j|_|ttjdddd|jddWStjyttjdddddYSty}ztd|ttjdddddWYd}~Sd}~ww)NrrrrrrrrrrrrdrrrDr5z Employee z updated successfullyrrTrwrnz"Something went wrong during update)r:r rTrPrrrrrrrrrrrdrrrr,r.r[rErUrr{r|rQ)r_r`rFr:rdrrdrdrerCsJ      zSalaryAPIView.putrm)rhrirjrPrrdrdrdrers  qrc@r)PayslipAPIViewNc Cs |durztjj|d}id|jd|jd|jd|jd|jd|jd|j d |j d |j d |j d |j d |jd|jd|jd|jd|jd|jid|jd|jd|jd|jd|jd|jd|jd|jd|jd|jd|jd|jd|j d |j!d!|j"d"|j#}t$t%j&d#d$d|d%WStj'yt$t%j(d&d$d'd(d)YSwz0d*}g}tj)D]}|d+7}|*||j|j|j"|j#d,t+|qt$t%j&d#d$d|d%WSt,y}zt+d-|t$t%j-d&d$d't.|d)WYd}~Sd}~ww).NrrFempnameempidemppanr grosssalary perdaysalary basicsalaryrrotherallowancer workingdaysbaiscnewhranew conveyancenewotherallowancenewgrosspayvariablepfgrosspflessesilesslessptpfesibankrrnetpayrdrrtopayrPrDr5rqrTzPayslip not foundrrr)rTrFrErrPrn)/r rTrPrFrrrrrrrrrrrrrrrrrrrrrrrrrrrrdrrrrPr,r.r[rUrrUrr|r{rQr^)r_r`rFrr:rYrrrdrdrerP|s      !#        zPayslipAPIView.getc CsBzw|jdg}|sttjdddddWSg}g}ddd d d d d dddddd }|D]-}|d}|d}|t|t|} z tjj|d} Wn tj yWYq-wt jj | | d } | rm|d| j | _ |d| j| _|d| j| _|d| j| _|d| j| _|d| j| _|d| j| _|d| j| _|d | j| _|d!| j| _|d"| j| _|d#| j| _|d$| j| _|d%| j| _|d&| j| _|d'| j| _|d(| j| _|d)| j| _|d*| j| _|d+| j | _ |d,| j!| _!|d-| j"| _"|d.| j#| _#|d/| j$| _$|d0| j%| _%|d1| j&| _&|d2| j'| _'|d3| j(| _(|d4| j)| _)|d5| j*| _*|d6| j+| _+| | _,d7| _| -|.|q-t jj/d@id| d|dd8d|dd8d|dd8d|dd9d|dd9d|dd9d|dd9d|dd9d |d d9d!|d!d9d"|d"d9d#|d#d9d$|d$d9d%|d%d9d&|d&d9d'|d'd9d(|d(d9d)|d)d9d*|d*d9d+|d+d9d,|d,d9d-|d-d9d.|d.d9d/|d/d8d0|d0d8d1|d1d9d2|d2d9d3|d3d9d4|d4d9d5|d5d9d6|d6d9d| d:d7|.|q-ttj0d;ddt1|dWSt2y} zt3d?| ttjdddt| dWYd} ~ Sd} ~ ww)ANZpayslipsrr5Tu,Payslip data இல்லைrJanuaryFebruaryMarchAprilMayJuneJulyAugust SeptemberOctoberNovemberDecember) rr@rkrrrrrrr^ rMrPrdr)rdrPrrrrrrrrrrrrrrrrrrrrrrrrrrrrdrrrrrr]r.rDz created, z updated)r.r4r9rupdatedzPayslip Error: rd)4r:rPr,r.rQrr^r rTrUr rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrdrrrrPrrrr[rr{r|) r_r`Z payslips_dataZ created_listZ updated_listZ MONTH_NAMESrZ month_valr month_nameZemployee_instancerrrdrdrerfs0                                      !# %   zPayslipAPIView.postrmrrdrdrdrerys  Xrc@r0) ProductactivestatusupdateAPIViewc Csz(tjj|d}|jdkrd|_|nd|_|ttjdddddWStyI}zttjddd d |dWYd}~Sd}~ww) Nrrr@rDr5zQuote accepted successfullyrrTr) rrTrPr.rr,rrrQ)r_r`rFZvenrrdrdrer^s(     z$ProductactivestatusupdateAPIView.putN)rhrirjrrdrdrdrer\rkr)ValidationError) Paginator)IntegrityErrorr)rPrefetchProtectedErrorr ) FileResponser) FormParserMultiPartParser) TokenError) DOC_TYPE_CHOICES STATUS_ACTIVESTATUS_INACTIVEClientClientDocument ClientServicerRenewalHistoryServicerkr^2irrcCtjrtStS)z=Today's date. Works whether settings.USE_TZ is True or False.N)rUSE_TZr localdaterr3rdrdrdre today_datercCr )zFCurrent date and time. Works whether settings.USE_TZ is True or False.N)rr rrrrrdrdrdre now_localrrcKs4|ddd|d}|r||d<||t||dS)NrDr5rqr9r-)updater,)r:r9r6extrartrdrdrerDs   rDcCs*|ddd|d}|r||d<t||dS)Nrr5Trerrorsr-r+)r9r6rrtrdrdrers rcCs(|jrtStjj|jdjdddS)Nr>rNTr)r] ADMIN_ROLErrTrrFr8rrprdrdreget_rolesrcCs0|rtfnttf}t|j|vrtdtjSdS)zKReturns an error Response if this user may not use the API, otherwise None.z&You do not have permission to do this.N)r EMPLOYEE_ROLErrarr.rV)r` admin_onlyallowedrdrdre check_roles rc Csztt|jddd}Wn ttfyd}Ynwz t|jdt}Wn ttfy4t}Ynwtt|dt}t ||}| |}|j |j ||j ||d}|j|fS)z>?page=2&page_size=10 -> (rows of that page, pagination info)pager page_size)rrrZ total_pageshas_next has_previousN)rrrrPrr PAGE_SIZEr MAX_PAGE_SIZErget_pagernumber num_pagesrr object_list)r`querysetrr paginatorpage_objrprdrdrepaginates*   r'cCs.t|drdd|jDSdd|jiS)z4Django ValidationError -> {"field": "first message"} message_dictcSs6i|]\}}||r|ddkrdn|r|dndqS)rzThis field cannot be blank.zThis field is required.z Invalid valuerd)r'rrrdrdrers*zerror_dict..__all__z; N)rAr(r}r2messages)excrdrdre error_dicts r,cCstt|Srm)riterrNrrdrdre first_errorrr/cCs|dvS)N)TrrrTruerYesrdrrdrdreto_boolror2cCs|r|dSdS)Nr"rrvr(rdrdrefmt_daterr4cCs|r d|ddSdS)Nz XXXX XXXX rrdrrdrdre mask_aadhaarr~r7cCs.|rdtt|dd|ddSdS)NXrrr5r)rrr6rdrdre mask_accounts.r9c@r) MeAPIViewzGGET /api/v1/me/ -> who owns this token + role (checked on the server).c Cs|j}tjj|jd}|dur|jdkrtdtjSt |j|j |j |j |j |r,|jnd|r2|jnd|r;|jdSddS)Nr>r@rA)rFrEr2r<rGrMrNrO)rarrTrrFrr.rrVrDr2r\r<r]rMrNrO)r_r`rarJrdrdrerPs    z MeAPIView.getNrHrdrdrdrer: r:c@r) LogoutAPIViewzJPOST /api/v1/logout/ {"refresh": "..."} -> blacklists the refresh token.cCs8z t|jdWn tyYnwttjdS)NrHr-)rr:rPZ blacklistrr,r.ZHTTP_205_RESET_CONTENT)r_r`rdrdrerfs   zLogoutAPIView.postNrhrirjrIr$rrrfrdrdrdrer<r;r<cCs$|j|j|jt|ddt|jdS)N clients_count)rFrEr.r>r)rFrEr.r:r4r)srdrdreservice_to_dict$s  r@c@@eZdZdZefZd ddZddZddZd d Z d d Z dS)ServiceAPIViewa GET /api/v1/services/ list, 10 per page (?page=&search=&status=) GET /api/v1/services/?val=options all services for dropdowns GET /api/v1/services/?val=summary counts for dashboard GET /api/v1/services// one service POST /api/v1/services/ create (admin) PUT /api/v1/services// update (admin) DELETE /api/v1/services// delete (admin) Nc Csbt|}|r|S|dur2ztjjtddj|d}Wntjy+tdtj YSwt t |S|j dd}|dkrQtj dd dd }t d d |DS|d krmtj}tjjtd}t ||||dStjjtdd d} |j dd} |j d d} | r| j| d} | dvr| jt| d} t|| \}} t dd |D| dS)Nclient_servicesr>rService not foundrroptionsrErFr.cSs(g|]}|d|d|dtkdqS)rFrEr.)rrinactive)rrZrdrdrer,Is(z&ServiceAPIView.get..rr-)ractiverGrrrrcSr>rd)r@r'r?rdrdrer,Xr* pagination)rr rTrOrrPrUrr.rrDr@rrrNrrrrrr') r_r`rFdeniedr?rr\rrHservicesrrrprdrdrerP:s6   zServiceAPIView.getc Cs<|j}d|vr |d|_d|vr|d|_z|jpd|_|WntyA}zt|}tt||dWYd}~Sd}~wwt j j |jdj |j dr[d}t|d|idS|ra|j|_|j|_z|WntyztdtjYSwt j jtdd j|j d}tt||rd nd |rtjd Stjd S) NrEr.rr.)rrz(A service with this name already exists.rCrDzService created successfullyzService updated successfullyr9r6)r:rEr.r clean_fieldsrr,rr/r rTrr9rrrarlr3rrrrOrrPrDr@rr[)r_r`rcreatingr:rrrrdrdre_saveZs@      zServiceAPIView._savecCs&t|dd}|r |S|j|tddS)NTrrQ)rrRr r_r`rMrdrdrerf{s zServiceAPIView.postcCsXt|dd}|r |Sz tjj|d}Wntjy#tdtjYSw|j||ddS)NTrSrrEFrT) rr rTrPrUrr.rrR)r_r`rFrMrrdrdrers zServiceAPIView.putcCsrt|dd}|r |Sz tjj|dWntjy%tdtjYSt y3tdtj YSwt ddS)NTrSrrEzOThis service is used by clients and can't be deleted. Mark it Inactive instead.zService deleted successfullyr9) rr rTrPrrUrr.rrrrDr_r`rFrMrdrdrers   zServiceAPIView.deleterm rhrirjrIr$rrrPrRrfrrrdrdrdrerB.s  ! rB)rE business_namerrrrMr<raadhaargstin bank_nameaccount_holderaccount_numberifscr.notesc Cs,|j|j||j|j|j|jt|jdS)N)rFdoc_typeZdoc_type_label original_name content_typerremarksZ uploaded_at) rFraget_doc_type_displayrbrcrrdr4rr3rdrdredocument_to_dictsrfcCstjtdtjdddS)zEClients with services + documents loaded in 2 extra queries (no N+1).rCr)r$ documentsN)rrTr+rrrrdrdrdreclient_querysetsrhc Cst|jddd}id|jd|jd|jd|jd|jd |jd |j d |j d |j d |j d|j d|r>|jnt|jd|jd|jd|rQ|jnt|jd|jddd|D|jt|jt|j|rzdd|jDng|j|jt|jt|jdS)zXList + exports use masked Aadhaar / account number. full=True is only for the edit form.cS |jjSrmrrErq)csrdrdrer z client_to_dict..rrFrrErYrrrrMr<rr[rZr\r]r^r_rNcSs6g|]}|j|jj|jr|jndt|jdqS)N)rFrE renewal_date renewal_label) service_idrrErmrr4r'rkrdrdrer,sz"client_to_dict..cSr>rd)rfr+rdrdrer,r*)file_deliveredfile_delivered_onZdocuments_countrgr.r`r updated_atN)r=rCrUrFrrErYrrrrMr<rr[rZr7r\r]r^r9r_rqr4rrrrgr.r`rrs)rfulllinksrdrdreclient_to_dicts^      rvcCstd}|j}|dd}|dd}|dd}|dd}|dvr5|jt|d}|d vrA|j|d kd }|rM|jt|d }|rz|t|d t|dBt|dBt|dBt|dBt|dBt|dBt|dB}|S)N-idrrr.rrqrIr-)r]rr)rq)Zclient_services__service_idr)Zbusiness_name__icontainsrrr)Zpan__icontains)Zgstin__icontains)Zcity__icontains) rhrrrPrrrrmr )r`rrrrr deliveredrdrdrefiltered_clientss6 ryc Cs4|dvrgSt|tstddigt}}|D]~}t|ts&tddiz t|d}Wnttfy>tddiw||vrItddi| |d}|d}|dvrzt t |dd d  }Wn tyvtdd iwt d d d |krt dddksntddi|||fq|S)zX[{"service_id": 3, "renewal_date": "2026-10-10"}, ...] -> [(3, date(2026,10,10)), ...]rrNzServices must be a list.zInvalid service selected.roz#The same service is selected twice.Nrmr^rz"Renewal date must be a valid date.r4rMzRenewal date is out of range.)rr1rsetdictrrPrraddrr1r^rr)rr\seenrTrorenewalZraw_daterdrdreparse_service_rowss8            & rc@rA) ClientAPIViewaz GET /api/v1/clients/ list, 10 per page (?page=&search=&status=1|2&service=&file_delivered=0|1) GET /api/v1/clients/?val=summary dashboard numbers + latest clients GET /api/v1/clients/?val=excel download Excel (same filters) GET /api/v1/clients/?val=pdf download PDF (same filters) GET /api/v1/clients// full details POST /api/v1/clients/ create (admin + employee) PUT /api/v1/clients// update (admin + employee) - also used to toggle file_delivered DELETE /api/v1/clients// delete (admin only) NcCst|}|r|S|dur.z tj|d}Wntjy%tdtjYSwtt |ddS|j dd}|dkrltj }tj j td }tj j td d  }td dd } t|||||d d| DdS|dvrtt|dt} z|dkrt| } d} d} nt| } d\} } WntytdtjYSwt| | d}dtdd| d|d<|St|t|\}}tdd|D|dS)NrrTrtrrrr-F)r.rqrwrcSr>rdrvrrdrdrer,5r*z%ClientAPIView.get..)rrHrGZ file_pendingr)excelpdfrzAapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheetZxlsx)application/pdfrz6Install on the server: pip install openpyxl reportlab)rczattachment; filename="clients-rr"zContent-DispositioncSr>rdrrrdrdrer,Ir*rK)rrhrPrrUrr.rrDrvrrTrrrrr1ry EXPORT_LIMITbuild_clients_excelbuild_clients_pdf ImportErrorZHTTP_501_NOT_IMPLEMENTEDrrr')r_r`rFrMrrrrHrrrcontentrcextr7r\rprdrdrerP sL     zClientAPIView.getc s|j}tD]}||vrt||||dur||ndqd|vr7t|dp&d}|r2||_n|r7d|_d|vrRt|d}|rJ|jsJt |_ |sOd|_ ||_z| d|vrbt | dnd}Wnty} zt| } tt| | dWYd} ~ Sd} ~ wwi} |jsd| d<|jsd| d <|jrtjj|jd j|jd } | rd | jd | jd| d<dD].\}} t||} | rtjjd(i|| ij|jd }|r| d|jd|jd| |<qi|dur-ddtjjdd|DdDtt|kr d| d<n!|rtn t|jjdddt fdd|Dr-d| d<| r8tt| | dSzot!"`|rE|j#|_$|j#|_%|&|durdd|j'D}|D]+\}}|(|d}|durxt)jj*|||d q^|j+|kr||_+|j&d!gd"q^|,D]}|-qWdn 1swYWnt.ytd#t/j0YSwt1j |jd }t2t3|dd$|rd%nd&|rt/j4d'St/j5d'S))NrrrqrNr.zClient name is required.rEzMobile number is required.rM)rrz Client ID z is already used by r))rPAN)rZAadhaarz already belongs to client z (rcSrrdrrJrdrdrer}r*z'ClientAPIView._save..cSg|]\}}|qSrdrdr'sidrrdrdrer,}r*z'ClientAPIView._save..rz+One or more selected services do not exist.roTrc3s*|]\}}|jtko|vVqdSrm)r.rralreadyfoundrdrers(z&ClientAPIView._save..z*Inactive services can't be newly assigned.cSrrdrorprdrdrerr*)rrormrm update_fieldszMAnother client already uses one of these details (Client ID / PAN / Aadhaar).rzClient created successfullyzClient updated successfullyrOrd)6r:CLIENT_TEXT_FIELDSsetattrr^rrrr2rqrrrvalidate_fieldsrrPrr,rr/rErMrrTrr9rrr:r rr}rCr8rrrrarlr3rrUpoprrrmrNrrr.rrhrDrvrr[)r_r`rrQr:rtypedrxZ service_rowsrrclashrrotherrrorlinkleftoverrdrrerRLs     $ "             zClientAPIView._savecCs"t|}|r|S|j|tddS)NTrT)rrRrrUrdrdrerfszClientAPIView.postcCsTt|}|r|Sz tjj|d}Wntjy!tdtjYSw|j||ddS)NrrFrT) rrrTrPrUrr.rrR)r_r`rFrMrrdrdrerszClientAPIView.putcCsVt|dd}|r |Sz tjj|dWntjy%tdtjYSwt ddS)NTrSrrzClient deleted successfullyrV) rrrTrPrrUrr.rrDrWrdrdrers  zClientAPIView.deletermrXrdrdrdrers ,X rc@r)RenewalAPIViewz GET /api/v1/renewals/?when=tomorrow|today|week|overdue&search=&page= Default = tomorrow: clients whose renewal date is one day away (shown every day). Only ACTIVE clients are listed. `counts` gives the number for every tab. c s4t|}|r|Stttdddtdttdddtdd}|jdd }||vr6d }tjd d j d t d  || dd}|jdd }|rt| t|dt|dBt|dBt|dBt|dB}t ||\}}fdd|D} fdd|D} t| || |dS)NrrR)rmr)Zrenewal_date__gtZrenewal_date__lte)Zrenewal_date__lt)tomorrowr3weekZoverduewhenrrrF)Zrenewal_date__isnullZclient__statusrmZ client__namerr)Zclient__name__icontains)Zclient__client_code__icontains)Zclient__phone__icontains)Z client__business_name__icontains)Zservice__name__icontainsc sRg|]%}|j|j|jj|jj|jj|jj|jj|j t |j|jj d qS)) rFrrrSrYrM service_namermrnZ days_left) rFrrrrErYrMrrmrr4rSrp)r3rdrer,s   z&RenewalAPIView.get..cs i|] \}}||qSrd)rr)r'rEra)baserdrerr\z&RenewalAPIView.get..)rLrKrr3)rrr rrrPrrTrrrrrr'r}rDr) r_r`rMtabsrr\rZ page_rowsrpr:rKrd)rr3rerPs>   zRenewalAPIView.getNrHrdrdrdrers rc Cs8ztt|dddWSttfyYdSw)z9'2026-10-10' -> date, or None when it is not a real date.Nr^r)rr1r^rrrrrdrdre read_dates rc@r)RenewalRenewAPIViewa POST /api/v1/renewals//renew/ ("Mark renewed" button) { "new_date": "2027-10-10", next renewal date (required) "renewed_on": "2026-10-09", day it was renewed (default today, not in the future) "old_date": "2026-10-10", the date the screen showed (stops double click / two staff) "remarks": "paid by UPI" } Saves a RenewalHistory row and moves the service to the new renewal date. c Csjt|}|r|S|j}t}i}|}|ddvr>t|d}|dur)d|d<n||kr2d|d<n |tdddkr>d|d<t|d}|durNd |d<n"tddd|kr`td d d ksfnd |d<n |rp||krpd|d<t|dpwd} t| dkrd|d<|rt t ||dSt zt jddj|d} Wnt jyt dtjYWdSw| jjtkrt dWdSt|dpddd} | jr| jnd} | r| | krt dtjWdStjj| j| j| j||| |jd|| _| jdgdWdn 1swYt| j| j | jj!|t"|dd d!S)"N renewed_onrz"Renewed date must be a valid date.z$Renewed date can't be in the future.rzrzRenewed date is out of range.new_datezNext renewal date is required.r{rMr|z"Next renewal date is out of range.z1Next renewal date must be after the renewed date.rdrz#Remarks can be 255 letters at most.r.rrrzRenewal not foundzThis client is inactive.old_dater^z:This renewal was already updated. Please refresh the list.)rrrrrrdrlrmr)rFrrrmrnzRenewal saved successfullyrV)#rr:rrPrrr^rrrr/rrrrTselect_for_updaterrUr.rrrrmrrrrrrarrDrFrrEr4) r_r`rFrMr:r3rrrrdrZshowncurrentrdrdrerfsn   &         zRenewalRenewAPIView.postNr=rdrdrdrers rc@r)ClientRenewalHistoryAPIViewz[GET /api/v1/clients//renewal-history/?page=&service= newest first, 10 per pagec Cst|}|r|Stjj|dstdtjStjj|d dd}|j dd }| r7|jt|d}t||\}}dd |D}t||d S) Nrrrrrlrrc SsTg|]&}|j|j|jjt|jt|jt|j|j|j r$|j j p#|j j nddqS)r)rFrorrrrrdZdone_by) rFrorrEr4rrrrdrlr\r2rrdrdrer,Rs  z3ClientRenewalHistoryAPIView.get..rK)rrrTrrrr.rrrrrPrrmrr'rD) r_r`rrMhistoryrr\rpr:rdrdrerPEs   zClientRenewalHistoryAPIView.getNrHrdrdrdrerAr;r))s%PDF-rr)sjpgz image/jpeg)sPNG  pngz image/pngcCs>|d}|dtD]\}}}||r||fSq dS)zPLooks at the real file bytes (not the file name) -> (ext, content_type) or None.rrN)rrUPLOAD_SIGNATURESrl)rhead signaturerrcrdrdre sniff_uploadgs    rc@s6eZdZdZefZeefZddZ ddZ ddZ dS) ClientDocumentAPIViewa POST /api/v1/clients//documents/ multipart: file, doc_type, remarks GET /api/v1/client-documents// the file (login needed; ?download=1 to save) DELETE /api/v1/client-documents// removes the record AND the file from the media folder Saved in MEDIA_ROOT/client_documents// - never served as a public /media/ link. c Cst|}|r|Sz tjj|d}Wntjy!tdtjYSw|jd}|j dp/d }|j dp9d dd}|sJtd dd id S|t t vrXtd dd id S|j d kretd dd id S|j tddkr|dtd}t|d|id St|} | sd}t|d|id S|jtkrtdtdS| \} } tj|jdd} d| |_t|||| | |j ||jd} | tt| dtjdS)NrrfilerarrdrrzPlease choose a file.r.zInvalid document type.rzThe file is empty.iz#File is too large. Maximum size is z MB.z'Only PDF, JPG or PNG files are allowed.zA client can have at most z documents.zupload.)rrarrbrcrrdrlzDocument uploaded successfullyrO)rrrTrPrUrr.rror:rr~rr MAX_UPLOAD_MBrrgrMAX_DOCS_PER_CLIENTr^r]basenamerErrarrDrfr)r_r`rrMruploadrardrkindrrcrbdocrdrdrerf{sF      zClientDocumentAPIView.postc Cst|}|r|Sztjj|d}|jd}Wntjttfy*t dt j YSwt ||j p1d|jddk|jp@d|jd}d |d <d |d <|S) NrrbFile not foundzapplication/octet-streamZdownloadrz document-)rc as_attachmentfilenameZnosniffzX-Content-Type-Optionszprivate, no-storez Cache-Control)rrrTrPrrrUFileNotFoundErrorrrr.rrrcrrbrF)r_r`rFrMrhandler7rdrdrerPs" zClientDocumentAPIView.getcCsRt|}|r|Sz tjj|dWntjy#tdtjYSwt ddS)NrrzDocument deleted successfullyrV) rrrTrPrrUrr.rrDrWrdrdrers zClientDocumentAPIView.deleteN) rhrirjrIr$rrrrZparser_classesrfrPrrdrdrdrerqs( rcCsXg}t|jdddD]}||jr!|jjdt|jdn|jjq d|S)NcSrirmrjrrdrdrerrlzservices_text..rz (renewal r, ) r=rCrUrrmrrEr4r2)rrFrkrdrdre services_texts0 rcCsddlm}ddlm}m}m}ddlm}|}|j}d|_ gd}| dd|Dt |d D]*\} \} } | |j || _ |jd | d } |d d d | _|ddd| _|dd d| _q2d|jd _|D]R} | | j| j| j| j| j| j| j| j| jt| j| jt | | j!| j"t#| j$| j%| j&t'krdnd| j(rdndt)| j*| j+d,t-dd| j./Dt)| j0gqe|j1ddD]}|D] } |dd d| _qqdD]}t2d|j3d D] }d|j||d _4qqd |_5|j6|j7_8t9:}|;||<S)!Nr)Workbook) AlignmentFont PatternFill)get_column_letterZClients)) Client ID )z Client Name)zShop / Business Name)z Shop Address&)ZCity)ZPincoder^)ZMobile)Emailr)rr)r)ZGSTINr)zServices (renewal dates)()z Bank Name)zAccount Holder)z Account No.r)ZIFSCr)Statusr^)zFile Deliveredr)z Delivered Onr)ZNotes")Z Documentsr)zAdded OnrMcSrrdrd)r'rrrdrdrer,r*z'build_clients_excel..r)rTcolumnTZFFFFFF)boldcolorZsolidZ6B0F14)ZfgColorcenter)Zvertical wrap_textActiveInactiveZ DeliveredrrcSsh|]}|qSrd)rer+rdrdrer)r*z&build_clients_excel..r@)Zmin_rowtop)rrr^rf@ZC2)=ZopenpyxlrZopenpyxl.stylesrrrZopenpyxl.utilsrrHrrrVZcolumn_dimensionswidthcellZfontfill alignmentZrow_dimensionsheightrrErYrrrrMr<rr7rZr[rr\r]r9r^r_r.rrqr4rrr`r2r=rgrUr iter_rowsr|Zmax_row number_formatZ freeze_panes dimensionsZ auto_filterrefrrrgetvalue)rrrrrrwbwsrgr(rrrrrTcolr[bufferrdrdrersJ    $  rcsddlmddlmddlmmddlm}m }ddl m ddl m m}m}m}m}|dd d d d }|d |dd}|d|jd|} |ffdd fdd} fdddDg} |D]} ddt| jdddD} | | j|d| jd| j|| | j| j| | jod| j| jod t| j| jod!| j| | | | j d"!d#d$| j"| j#fD| | j$| j%| j&od%t'| j&| j(od&| j(| | j)t*krd'nd(| j+rd)nd*gqffd+d,}t,-}||d-d-d-d.d/d0d1}dd2gd3}|| fd4d|Dd5d6}|.|d7d8d9/d:fd;dgfd?d8d=d@/dAfdBdCdDgdE| dFdGt0dHdIt1|dJ| dK|d5dL|g}|j2|||dM|3S)NNr)escape)colors)A4 landscape)ParagraphStylegetSampleStyleSheet)r) ParagraphSimpleDocTemplateSpacerTable TableStyler Helveticarr)fontNameZfontSizeZleadingrzHelvetica-Bold)parentrr)rZ textColorcst|pddd|S)Nr z
)r^rp)rqstyle)rrrdrerb szbuild_clients_pdf..Pcsddd|DS)Nrcs|]}|r|VqdSrmrd)r'lrdrdrer rz3build_clients_pdf..stack..)r2)lines)rbrdrestack sz build_clients_pdf..stackcsg|]}|qSrdrdr)rbrrdrer, rz%build_clients_pdf..)rzClient / BusinessZContactzPAN / Aadhaar / GSTINZServicesAddressZBankrcSs0g|]}|jj|jrdt|jndqS)z - r)rrErmr4rprdrdrer, s"cSrirmrjrrdrdrer rlz#build_clients_pdf..rzz
zPAN: z Aadhaar: zGST: ricsrrmrdr?rdrdrer rz$build_clients_pdf..zA/c: zIFSC: rrzFile: Deliveredz File: Pendingcsl||dd|j|ddd|dddd|j|dS)NrrrMrzManju Associates - ConfidentialrzPage )Z saveStateZsetFontZ setFillColorZgreyZ drawStringZdrawRightStringrZ restoreState)Zcanvasr)rrrrrdrefooter s   * z!build_clients_pdf..footerrMrz Client ListzManju Associates)ZpagesizeZ leftMarginZ rightMarginZ topMarginZ bottomMarginrZauthorr)(\µ?333333?Q?r ?rrr csg|]}|qSrdrdrZ)rrdrer,( r*r)Z colWidthsZ repeatRowsZ BACKGROUNDrr)rz#6B0F14ZROWBACKGROUNDS)rrrrz#FBF1DEZGRIDg?z#D9C9A3)ZVALIGNrrZTOP)Z TOPPADDINGrrrk)Z BOTTOMPADDINGrrrkzManju Associates - Client ListZTitlez Generated on z%d-%m-%Y %H:%Mz | z client(s)ZNormalr)Z onFirstPageZ onLaterPages)4Zxml.sax.saxutilsrZ reportlab.librZreportlab.lib.pagesizesrrZreportlab.lib.stylesrrZreportlab.lib.unitsrZreportlab.platypusrrrrrwhiter=rCrUrrrErYrMr<rrZr7r[rr2rrr\r]r^r9r_r.rrqrrsetStyleZHexColorrrbuildr)rrrrrrrrrstylesr r:rZ service_linesr rrZratiostableZstoryrd) rrbrrrrrrrrersb       8"0  " " r)Frm) django.confrZdjango.shortcutsrmodelsrrrrr r r r r rrrdjango.core.exceptionsrZrest_framework.exceptionsrdjango.contrib.authrrZrest_framework_simplejwt.tokensrdjango.contrib.auth.hashersrdjango.contrib.auth.modelsr django.utilsrZdjtzrrrZcv2r`r^numpyrsysror django.httprbase64PILrrrdjango.db.modelsr Zrest_framework.genericsr!r" serializersr#Zrest_framework.permissionsr$r%rhdjango.core.mailr&Zschool.settingsr'ZpdfkitrRrr(django.utils.cryptor)r*Zrest_framework.responser,rest_frameworkr.Zrest_framework.viewsr/r1rlrrrrrrrrrr rrJrOr{r|rr2rrLockrrrrcr_rrrrdecimalrrrrrrrr%rr4r5rrr#r'r)r*r4r9rErGrIrrrrrrrrrrrrr django.dbrrrrrrrrrrrrrrr(r,r?r@rQrVlogging getLoggerrhrkrnrvrwr{rrrrrrrrrrrrdjango.core.paginatorrrrrrZrest_framework.parsersrrZ#rest_framework_simplejwt.exceptionsrrrrrrrrr rrrrrrrrrr[rDrQrrrr'r,r/r2r4r7r9r:r<r@rBrrfrhrvryrrrrrrrrrrrrrdrdrdres0 8                         Zg & ICJ+]5    b   \wy       &UV   jv< { &?L)!        P/@b  =h?4*9 &   *d)          ,   k   ( . 3F   P .