Ë
    �Oýj^S  ã                   óX  — d dl Z d dlmZ d dlmZmZ d dlmZ d dlm	Z	 d dl
m
Z
 d dlmZ d dlmZmZ d d	lmZmZ d d
lmZmZmZ d dlmZ d dlmZmZ d dlmZ d dlmZ d dlm Z  d dl!m"Z" d dl#m$Z$  e jJ                  e&«      Z'd„ Z(d„ Z)d„ Z*d„ Z+d„ Z,e d„ «       Z-d„ Z.d„ Z/e d„ «       Z0d„ Z1y)é    N)Úmake_password)ÚtransactionÚIntegrityError)Úredirect)Úmessages)Údatetime)ÚJsonResponse)ÚDecimalÚInvalidOperation)Úencrypt_passwordÚdecrypt_password)Ú	AdminUserÚPlaceÚStaff)Úrender)ÚCountÚQ)Úreverse)Úescape)Úrequire_POST)Úvalidate_email)ÚValidationErrorc                 ó:   — 	 t        | «       y# t        $ r Y yw xY w)NTF)r   r   )Úvalues    úE/var/www/html/nexus_chitfund_web/controllers/Admin/StaffController.pyÚ_is_valid_emailr      s$   € ðÜ�uÔØøÜò Ùðús   ‚ Ž	™c                 óº   — 	 t        | «      }|j                  «       r|dk  s|t        d«      k\  ry|j                  «       j                  dk\  S # t        $ r Y yw xY w)NFr   Ú	100000000éþÿÿÿ)r
   r   Ú	is_finiteÚas_tupleÚexponent)r   Úamounts     r   Ú_is_valid_salaryr$      s_   € ðÜ˜“ˆð ×ÑÔ ¨!¢¨v¼ÀÓ9MÒ/MØØ�?‰?Ó×%Ñ%¨Ñ+Ð+øô	 ò Ùðús   ‚A Á	AÁAc                 óì   — | j                   j                  d«      D �cg c]#  }|j                  «       j                  «       sŒ"|‘Œ% }}t	        t
        j                  j                  |¬«      «      S c c}w )NÚplaces)Úid__in)ÚPOSTÚgetlistÚstripÚisdigitÚlistr   ÚobjectsÚfilter)ÚrequestÚvÚidss      r   Ú_selected_placesr2   *   s[   € Ø—l‘l×*Ñ*¨8Ô4Ó
LÑ4�¸¿¹»	×8IÑ8IÕ8KŠ1Ð4€CÐ
LÜ”—‘×$Ñ$¨CÐ$Ó0Ó1Ð1ùò Ms   ž#A1ÁA1c                 ón
  — t         j                  dd| j                  i¬«       | j                  dk7  rt        dddœd¬	«      S t        j
                  j                  «       j                  d
«      j                  «       }|r|j                  sd}n/	 t        |j                  j                  dd«      «      }d|dz   d›�}| j                  j                  dd«      j                  «       }| j                  j                  dd«      j                  «       }| j                  j                  dd«      j                  «       j!                  «       }| j                  j                  dd«      j                  «       }| j                  j                  dd«      j                  «       }| j                  j                  dd«      j                  «       }	| j                  j                  dd«      j                  «       }
| j                  j                  dd«      j                  «       }| j                  j                  dd«      j                  «       }i }|sd|d<   nt#        |«      dkD  rd|d<   |sd|d<   nXt#        |«      dk  rd|d<   nDt%        |«      sd|d<   n3t        j
                  j'                  |¬ «      j)                  «       rd!|d<   |sd"|d<   nt#        |«      d#k  rd$|d<   |sd%|d<   n#|j+                  «       rt#        |«      dk7  rd&|d<   |sd'|d<   n	|d(vrd)|d<   |
sd*|d<   nt-        |
«      sd+|d<   |sd,|d<   |sd-|d<   nO	 t/        j0                  |d.«      j3                  «       }|t/        j4                  «       j3                  «       kD  rd/|d<   |	sd1|d<   n	 t/        j0                  |	d.«       |r)t         j7                  d3d4|i¬«       t        d|d5œd¬	«      S 	 t9        |«      }t;        j<                  «       5  t        j
                  j?                  ||||r|nd |||	|
||d6¬7«      }|j@                  jC                  tE        | «      «       t         j                  d8d9|jF                  i¬«       d d d «       t        d:d;d<d=œ«      S # t        $ r d}Y �Œ×w xY w# t        $ r	 d0|d<   Y �Œw xY w# t        $ r	 d2|d<   Y �Œw xY w# 1 sw Y   ŒTxY w# tH        $ r- t         jK                  d>||d?œ¬«       t        dd@dœd¬	«      cY S tL        $ r( t         jK                  dA«       t        ddBdœdC¬	«      cY S w xY w)DNzStaff creation startedÚmethod©Úextrar(   ÚerrorúInvalid request method.©ÚstatusÚmessageé�  ©r:   ÚidÚEMP001ÚEMPÚ é   Ú03dÚnameÚphoneÚgenderÚdate_of_birthÚaddressÚjoining_dateÚsalaryÚemailÚpasswordzName is required.éÿ   z"Name cannot exceed 255 characters.zEmail is required.é
   z*Email must be at least 10 characters long.zEnter a valid email address.©Úemail__iexactz!This email is already registered.zPassword is required.é   z,Password must be at least 8 characters long.zPhone number is required.z'Phone number must be exactly 10 digits.zGender is required.©ÚmaleÚfemaleÚotherzInvalid gender selection.zSalary is required.zEnter a valid salary amount.zAddress is required.zDate of birth is required.ú%Y-%m-%dz&Date of birth cannot be in the future.z&Invalid date format for date of birth.zJoining date is required.z%Invalid date format for joining date.z/Staff creation failed due to validation errors.Úerrors©r:   rW   ÚActive)rD   rE   rF   rG   rH   Úemployee_idrI   rJ   rK   rL   r:   z"Staff record created successfully.Ústaff_idÚsuccesszStaff added successfully.ú/admin/staff_list/©r:   r;   Úredirect_urlz6Staff creation failed due to database integrity error.)rK   rZ   ú$Email or Employee ID already exists.z/Unexpected error occurred while creating staff.z+Staff could not be added. Please try again.éô  )'ÚloggerÚinfor4   r	   r   r-   ÚallÚorder_byÚlastrZ   ÚintÚreplaceÚ
ValueErrorr(   Úgetr*   ÚlowerÚlenr   r.   Úexistsr+   r$   r   ÚstrptimeÚdateÚtodayÚwarningr   r   ÚatomicÚcreater&   Úsetr2   r>   r   Ú	exceptionÚ	Exception)r/   Ú
last_staffrZ   Úlast_numrD   rE   rF   rG   rH   rI   rJ   rK   Ústaff_passwordrW   Údob_dateÚencrypted_passwordÚstaffs                    r   Ú
storestaffr}   /   s%  € Ü
‡K�KÐ(°¸7¿>¹>Ð0J€KÔKà‡~�~˜ÒÜ¨7Ð?XÑ YÐbeÔfÐfä—‘×"Ñ"Ó$×-Ñ-¨dÓ3×8Ñ8Ó:€JÙ˜Z×3Ò3Ø‰ð	#Ü˜:×1Ñ1×9Ñ9¸%ÀÓDÓEˆHØ ¨1¡¨SÐ1Ð2ˆKð
 �<‰<×Ñ˜F BÓ'×-Ñ-Ó/€DØ�L‰L×Ñ˜W bÓ)×/Ñ/Ó1€EØ�\‰\×Ñ˜h¨Ó+×1Ñ1Ó3×9Ñ9Ó;€FØ—L‘L×$Ñ$ _°bÓ9×?Ñ?ÓA€MØ�l‰l×Ñ˜y¨"Ó-×3Ñ3Ó5€GØ—<‘<×#Ñ# N°BÓ7×=Ñ=Ó?€LØ�\‰\×Ñ˜h¨Ó+×1Ñ1Ó3€FØ�L‰L×Ñ˜W bÓ)×/Ñ/Ó1€EØ—\‘\×%Ñ% j°"Ó5×;Ñ;Ó=€Nà€Fñ Ø,ˆˆvŠÜ	ˆT‹�SŠØ=ˆˆv‰ñ Ø.ˆˆwŠÜ	ˆU‹�bŠØFˆˆwŠÜ˜UÔ#Ø8ˆˆwŠÜ	�‰×	Ñ	¨EÐ	Ó	2×	9Ñ	9Ô	;Ø=ˆˆw‰ñ Ø4ˆˆzÒÜ	ˆ^Ó	˜qÒ	 ØKˆˆzÑñ Ø5ˆˆwŠØ�]‰]Œ_¤ E£
¨bÒ 0ØCˆˆw‰ñ Ø0ˆˆxÒØ	Ð1Ñ	1Ø6ˆˆxÑáØ0ˆˆxÒÜ˜fÔ%Ø9ˆˆxÑáØ2ˆˆyÑáØ">ˆˆÒð	Oô  ×(Ñ(¨¸
ÓC×HÑHÓJˆHàœ(Ÿ.™.Ó*×/Ñ/Ó1Ò1Ø*R��Ñ'ñ
 Ø!<ˆˆ~Òð	Mä×Ñ˜l¨JÔ7ñ
 Ü�‰ÐHÐQYÐ[aÐPbˆÔcÜ w¸&ÑAÈ#ÔNÐNð.Ü-¨nÓ=ÐÜ×ÑÕ!Ü—M‘M×(Ñ(ØØØÙ/<™mÀ$ØØ'Ø)ØØØ+Øð )ó ˆEð �L‰L×ÑÔ-¨gÓ6Ô7Ü�K‰KÐ<ÀZÐQV×QYÑQYÐDZˆKÔ[÷ "ô" Ø'Ø:Ø$8ñó ð 	øôS ò 	#Ø"‹Kð	#ûôJ ò 	OØ&NˆF�?Ô#ð	Oûô ò 	MØ%LˆF�>Ô"ð	Mú÷ "Ð!ûô, ò Ü×ÑØDàØ*ñð 	ô 	
ô ØØ=ñ
ð ôò 	ô
 ò Ü×ÑØ=ô	
ô ØØDñ
ð ôò 	ðúsh   Â.R ÍAR ÎR. ÏS Ï:A6SÑ0S ÒRÒRÒR+Ò*R+Ò.S Ò?S ÓSÓS Ó3T4Ô-T4Ô3T4c                 óz  — | j                   j                  d«      dk7  rt        dddœd¬«      S 	 t        | j                  j                  dd	«      «      }t        | j                  j                  d
d«      «      }t        | j                  j                  dd«      «      }| j                  j                  dd«      j                  «       }t        j                  j                  «       j                  d«      j                  t        d«      ¬«      j                  d«      }|j                  «       }|rj|j                  t        |¬«      t        |¬«      z  t        |¬«      z  t        |¬«      z  t        |¬«      z  t        |¬«      z  «      j!                  «       }|j                  «       }|dk(  r||d  n||||z    }g }	t#        ||d	z   ¬«      D �]¤  \  }
}t%        |j&                  xs d«      }t%        |j(                  xs d«      }t%        |j*                  xs d«      }t%        |j,                  xs d«      }t%        dj/                  d„ |j0                  j                  «       D «       «      xs d«      }d |› d!|› d"|› d#|› d$�	}|j2                  }t5        d%«      › d&|j6                  › �}d'|› d(|› d)�}|j8                  }t;        |d*«      r|j=                  d+«      n|xs d}|j>                  xs djA                  «       d,k(  }|rd-nd.}|rd/nd0}|rd1nd}d2|› d3|› d4|j6                  › d5|› d6�	}t5        d7|j6                  g¬8«      }d9|› d:|j6                  › d;�}|	jC                  |
||||||d<œ«       �Œ§ t        ||||	d=œ«      S # tD        $ r+ tF        jI                  d>«       t        d	ddg d?d@œdA¬«      cY S w xY w)BNzx-requested-withÚXMLHttpRequestr7   zInvalid request.r9   r<   r=   ÚdrawrB   Ústartr   ÚlengthrN   zsearch[value]rA   r&   Úcollections)Úcollection_countz-id)Úname__icontains)Úemployee_id__icontains)Úphone__icontains)Úemail__icontains)Úaddress__icontains)Úplaces__name__icontainséÿÿÿÿ©r�   Ú-z, c              3   ó4   K  — | ]  }|j                   –— Œ y ­w)N)rD   )Ú.0Úps     r   Ú	<genexpr>zview_staff.<locals>.<genexpr>å   s   è ø€ Ð*LÑ;K°a¨1¯6­6Ñ;Kùs   ‚zNo location assignedz`
                <div class="d-flex flex-column">
                    <span class="fw-semibold">z6</span>
                    <small class="text-muted">z�</small>
                    <small class="text-secondary">
                        <i class="bi bi-geo-alt me-1"></i>
                        z¢
                    </small>
                    <small class="text-primary">
                        <i class="bi bi-pin-map me-1"></i>
                        z4
                    </small>
                </div>zadmin:staff_collection_detailsz?id=zY
                <div class="d-flex align-items-center gap-2">
                    <span>z%</span>
                    <a href="z‹" class="btn btn-outline-primary btn-sm">
                        <i class="bi bi-eye"></i>
                    </a>
                </div>Ústrftimez%d-%m-%YÚactiverY   ÚInactiveztext-successztext-dangerÚcheckedzx
                <div class="d-flex flex-column align-items-start gap-1">
                    <span class="status-label z">zˆ</span>
                    <input type="checkbox"
                           class="status-toggle"
                           data-id="z"
                           zT
                           aria-label="Change staff status">
                </div>zadmin:edit_staff)Úargsz\
                <div class="d-flex align-items-center gap-2">
                    <a href="a   " class="btn btn-warning btn-sm" title="Edit Staff">
                        <i class="bi bi-pencil-square"></i>
                    </a>
                    <button type="button"
                            class="btn btn-danger btn-sm delete-staff"
                            data-id="a  "
                            data-bs-toggle="modal"
                            data-bs-target="#delete"
                            title="Delete Staff">
                        <i class="bi bi-trash"></i>
                    </button>
                </div>)ÚDT_RowIndexÚstaff_detailsrE   rƒ   rI   r:   Úaction)r€   ÚrecordsTotalÚrecordsFilteredÚdatazview_staff failedzCould not load staff.)r€   rš   r›   rœ   r7   ra   )%Úheadersrj   r	   rg   ÚGETr*   r   r-   rd   Úprefetch_relatedÚannotater   re   Úcountr.   r   ÚdistinctÚ	enumerater   rD   rZ   rH   rE   Újoinr&   r„   r   r>   rI   Úhasattrr’   r:   rk   Úappendrv   rb   ru   )r/   r€   r�   r‚   Úsearchrœ   Úrecords_totalÚrecords_filteredÚrowsÚresultÚindexÚrowrD   rZ   rH   rE   Úplace_namesr˜   r„   Úcollections_urlrƒ   ÚjoiningrI   Ú	is_activeÚstatus_labelÚstatus_classr•   r:   Úedit_urlr™   s                                 r   Ú
view_staffrµ   Â   s  € Ø‡�×ÑÐ-Ó.Ð2BÒBÜ wÐ;MÑNÐWZÔ[Ð[ðtÜ�7—;‘;—?‘? 6¨1Ó-Ó.ˆÜ�G—K‘K—O‘O G¨QÓ/Ó0ˆÜ�W—[‘[—_‘_ X¨rÓ2Ó3ˆØ—‘—‘ °"Ó5×;Ñ;Ó=ˆä�}‰}× Ñ Ó"×3Ñ3°HÓ=×FÑFÜ" =Ó1ð Gó 
ç
‰(�5‹/ð 	ð Ÿ
™
›ˆáØ—;‘;Ü &Ô)Ü¨6Ô2ñ3ä VÔ,ñ-ô  VÔ,ñ-ô  vÔ.ñ	/ô
 ¨FÔ3ñ4ó÷ ‰h‹jð ð  Ÿ:™:›<Ðà%¨š|ˆt�E�F‰|°°e¸EÀF¹NÐ1KˆàˆÜ# D°¸±	×:Ð:‰JˆE�3ä˜#Ÿ(™(š/ cÓ*ˆDÜ  §¡Ò!7°CÓ8ˆKÜ˜SŸ[™[Ò/¨CÓ0ˆGÜ˜3Ÿ9™9Ò+¨Ó,ˆEÜ  §¡Ñ*L¸3¿:¹:¿>¹>Ô;KÓ*LÓ!LÒ!fÐPfÓgˆKð!/à/3¨fð 5/Ø/:¨mð <ð !˜	ð "ð %˜ð &ðˆMð  #×3Ñ3ÐÜ!(Ð)IÓ!JÐ KÈ4ÐPS×PVÑPVÈxÐXˆOðà+Ð,ð -Ø-Ð.ð /ðˆKð ×&Ñ&ˆGÜ;BÀ7ÈJÔ;W˜7×+Ñ+¨JÔ7Ð^eÒ^lÐilˆLð Ÿ™Ò) r×0Ñ0Ó2°hÑ>ˆIÙ'0™8°jˆLÙ-6™>¸MˆLÙ#,‘i°"ˆGð/à/;¨n¸B¸|¸nð M%ð &)§V¡V Hð -Ø#˜9ð %ðˆFô Ð1¸¿¹¸ÔAˆHðà&˜Zð (&ð
 '*§f¡f Xð .ðˆFð �M‰MØ$Ø!.ØØ*Ø ,Ø Ø ñö ðK ;ô^ ØØ)Ø/Øñ	
ó ð 	øô ò Ü×ÑÐ,Ô-ÜØ q¸QØÐ!8ñ
ð ôò 	ðús   °MN Î1N:Î9N:c                 óš  — | j                   j                  dd«      j                  «       }| j                   j                  dd«      j                  «       j                  «       }|dvrt	        dddœd¬	«      S 	 t
        j                  j                  |¬
«      }	 ||_	        |j                  dg¬«       t        j                  d|j                  |dœ¬«       t	        dd|› d�|dœ«      S # t
        j                  t        f$ r t	        dddœd¬	«      cY S w xY w# t        $ r( t        j                  d«       t	        dddœd¬	«      cY S w xY w)Nr>   rA   r:   )rY   r”   r7   zInvalid status value.r9   r<   r=   ©r>   úStaff not found.é”  )Úupdate_fieldsz"Staff status updated successfully.)r[   Ú
new_statusr5   r\   zStaff status updated to Ú.)r:   r;   r»   zupdate_staff_status failedz0Could not update staff status. Please try again.ra   )r(   rj   r*   Ú
capitalizer	   r   r-   ÚDoesNotExistri   r:   Úsaverb   rc   r>   rv   ru   )r/   r[   r»   r|   s       r   Úupdate_staff_statusrÀ   =  sF  € à�|‰|×Ñ  bÓ)×/Ñ/Ó1€HØ—‘×!Ñ! (¨BÓ/×5Ñ5Ó7×BÑBÓD€JàÐ/Ñ/Ü wÐ;RÑSÐ\_Ô`Ð`ð\Ü—‘×!Ñ! XÐ!Ó.ˆð|Ø!ˆŒØ�
‰
 ( ˆ
Ô,Ü�‰Ð8ÈUÏXÉXÐeoÑ@pˆÔqÜØØ1°*°¸QÐ?Ø$ñ
ó ð 	øô ×Ñ¤
Ð+ò \Ü wÐ;MÑNÐWZÔ[Ò[ð\ûô ò |Ü×ÑÐ5Ô6Ü wÐ;mÑnÐwzÔ{Ò{ð|ús%   Á8 C* ÂAD Ã*)DÄDÄ.E
Å	E
c                 ó®  — | j                   dk7  r!t        j                  | d«       t        d«      S | j                  j                  dd«      j                  «       }	 t        j                  j                  |¬«      }	 |j                  }|j                  «        t        j                  dd	|i¬
«       t        j                  | d«       t        d«      S # t        j                  t        f$ r$ t        j                  | d«       t        d«      cY S w xY w# t         $ r8 t        j#                  d«       t        j                  | d«       Y t        d«      S w xY w)Nr(   r8   zadmin:staff_listr>   rA   r·   r¸   zStaff deleted successfully.r[   r5   zdelete_staff failedz)Could not delete staff. Please try again.)r4   r   r7   r   r(   rj   r*   r   r-   r¾   ri   rD   Údeleterb   rc   r\   rv   ru   )r/   r[   r|   Ú
staff_names       r   Údelete_staffrÄ   W  s$  € Ø‡~�~˜ÒÜ�‰�wÐ 9Ô:ÜÐ*Ó+Ð+à�|‰|×Ñ  bÓ)×/Ñ/Ó1€Hð,Ü—‘×!Ñ! XÐ!Ó.ˆð
MØ—Z‘Zˆ
Ø�‰ŒÜ�‰Ð1¸*ÀhÐ9OˆÔPÜ×Ñ˜Ð"?Ô@ô
 Ð&Ó'Ð'øô ×Ñ¤
Ð+ò ,Ü�‰�wÐ 2Ô3ÜÐ*Ó+Ò+ð,ûô ò MÜ×ÑÐ.Ô/Ü�‰�wÐ KÕLäÐ&Ó'Ð'ð	Mús%   Á C Á=AD Ã:DÄDÄ4EÅEc                 ó’
  — t         j                  d| j                  |dœ¬«       | j                  dk7  rt        dddœd¬	«      S 	 t        j
                  j                  |¬
«      }| j                  j                  dd«      j                  «       }| j                  j                  dd«      j                  «       }| j                  j                  dd«      j                  «       j                  «       }| j                  j                  dd«      j                  «       }| j                  j                  dd«      j                  «       }| j                  j                  dd«      j                  «       }| j                  j                  dd«      j                  «       }	| j                  j                  dd«      j                  «       }
| j                  j                  dd«      j                  «       }i }|sd|d<   nt        |«      dkD  rd|d<   |
sd|d<   nrt        |
«      dk  rd|d<   n^t        |
«      sd|d<   nMt        j
                  j                  |
¬ «      j!                  |j"                  ¬
«      j%                  «       rd!|d<   |rt        |«      d"k  rd#|d<   |sd$|d<   n#|j'                  «       rt        |«      dk7  rd%|d<   |sd&|d<   n	|d'vrd(|d<   |	sd)|d<   nt)        |	«      sd*|d<   |sd+|d<   |sd,|d<   nO	 t+        j,                  |d-«      j/                  «       }|t+        j0                  «       j/                  «       kD  rd.|d<   |sd0|d<   n	 t+        j,                  |d-«       |r)t         j                  d2d3|i¬«       t        d|d4œd¬	«      S 	 t3        j4                  «       5  ||_        ||_        ||_        ||_        ||_        ||_         |	|_!        |
|_"        |rtG        |«      |_$        |jK                  «        |jL                  jO                  tQ        | «      «       t         j                  d5d|j"                  i¬«       t        d6d7d8d9œ«      cd d d «       S # t        j                  t        f$ r, t         j                  dd|i¬«       t        dddœd¬	«      cY S w xY w# t        $ r	 d/|d<   Y �Œrw xY w# t        $ r	 d1|d<   Y �Œhw xY w# 1 sw Y   y xY w# tR        $ r, t         jU                  d:d|
i¬«       t        dd;dœd¬	«      cY S tV        $ r( t         jU                  d<«       t        dd=dœd>¬	«      cY S w xY w)?Nzstaff updated started)r4   r[   r5   r(   r7   r8   r9   r<   r=   r·   z$staff update failed:staff not found.r[   zstaff member not found.r¹   rD   rA   rE   rF   rG   rH   rI   rJ   rK   rL   zname is required.rM   z!name cannot exceed 255 characterszemail is requiredrN   z)email must me at least 10 character long.zenter a valid email address.rO   z2this email is already registereed by another staffrQ   z.new password must be atleast 8 character long.zphone number is  requiredzplease enter a valid phone nozgender is required.rR   zinvalid gender selection.zsalary is requiredzenter a valid salary amount.zaddress is requiredzDOB is required.rV   z%date of birth could not be in future.z&invalid date format for date of birth.zjoining date is requiredz%invalid date format for joining date.z,staff update failed due to validation errorsrW   rX   z#staff recorded updated successfullyr\   zstaff updated successfully.r]   r^   z3staff update failed due to database integrity errorr`   z&unexpected error occour staff updated z+staff could not be updated.please try againra   ),rb   rc   r4   r	   r   r-   rj   r¾   ri   rq   r(   r*   rk   rl   r   r.   Úexcluder>   rm   r+   r$   r   rn   ro   rp   r   rr   rD   rE   rF   rG   rH   rI   rJ   rK   r   rL   r¿   r&   rt   r2   r   ru   rv   )r/   r[   r|   rD   rE   rF   rG   rH   rI   rJ   rK   ry   rW   rz   s                 r   Úupdate_staffrÇ   o  së  € Ü
‡K�KÐ'¸¿¹ÐRZÑ.[€KÔ\à‡~�~˜ÒÜ wÐ;TÑUÐ^aÔbÐbð_Ü�m‰m×Ñ 8ÐÓ,ˆð
 
�‰×	Ñ	˜& Ó	$×	*Ñ	*Ó	,€DØ
�,‰,×
Ñ
˜7 2Ó
&×
,Ñ
,Ó
.€EØ�<‰<×Ñ˜H RÓ(×.Ñ.Ó0×6Ñ6Ó8€FØ—,‘,×"Ñ" ?°2Ó6×<Ñ<Ó>€MØ�L‰L×Ñ˜Y rÓ*×0Ñ0Ó2€GØ—‘×!Ñ! .°Ó4×:Ñ:Ó<€LØ�<‰<×Ñ˜H RÓ(×.Ñ.Ó0€FØ
�,‰,×
Ñ
˜7 2Ó
&×
,Ñ
,Ó
.€EØ—<‘<×#Ñ# J¨rÓ2×8Ñ8Ó:€Nà€FáØ*ˆˆvŠÜ	ˆT‹�3ŠØ:ˆˆv‰áØ+ˆˆwŠÜ	ˆU‹�BŠØCˆˆwŠÜ˜UÔ#Ø6ˆˆwŠÜ	�‰×	Ñ	¨EÐ	Ó	2×	:Ñ	:¸e¿h¹hÐ	:Ó	G×	NÑ	NÔ	PØLˆˆw‰áœ#˜nÓ-¨aÒ/ØKˆˆzÑáØ3ˆˆwŠØ�]‰]Œ_¤ E£
¨B¢Ø7ˆˆw‰áØ.ˆˆxÒØ	Ð0Ñ	0Ø4ˆˆxÑáØ-ˆˆxÒÜ˜fÔ%Ø7ˆˆxÑáØ/ˆˆyÑáØ 2ˆˆÒð	NÜ×&Ñ& }°ZÓ@×EÑEÓGˆHØœ(Ÿ.™.Ó*×/Ñ/Ó1Ò1Ø(O��Ñ'ñ Ø9ˆˆ~Òð	KÜ×Ñ˜l¨:Ô6ñ Ü�‰ÐEÈXÐV\ÐL]ˆÔ^Ü g°vÑ>ÀcÔJÐJðsÜ×ÑÕ!ØˆEŒJØˆEŒKØˆEŒLØ -ˆEÔØ!ˆEŒMØ+ˆEÔØˆEŒLØˆEŒKáÜ!1°.Ó!A�”à�J‰JŒLØ�L‰L×ÑÔ-¨gÓ6Ô7Ü�K‰KÐ=ÀZÐPU×PXÑPXÐDYˆKÔZäØ"Ø7Ø3ñ!ó ÷# "Ñ!øôW ×ÑœjÐ
)ò _Ü�‰Ð=ÀZÐPXÐDYˆÔZÜ gÐ8QÑRÐZ]Ô^Ò^ð_ûôv ò 	NØ%MˆV�OÔ$ð	Nûô ò 	KØ#JˆF�>Ô"ð	Kú÷ "Ð!ûô, ò oÜ×ÑÐNÐV]Ð^cÐUdÐÔeÜ wÐ:`ÑaÐjmÔnÒnÜò sÜ×ÑÐAÔBÜ gÐ8eÑfÐnqÔrÒrðsúso   Á Q$ Ë=AR, ÍS ÎS" Î*B0SÑ	S" Ñ$AR)Ò(R)Ò,R>Ò=R>ÓSÓSÓSÓS" ÓS" Ó"2UÔ-UÕUc                 ó`  — | j                   j                  dd«      j                  «       }	 t        j                  j                  |¬«      }t        |j                  «      }|st        dd	dœd
¬«      S t        d|dœ«      S # t        j
                  t        f$ r t        dddœd¬«      cY S w xY w)Nr>   rA   r·   r7   r¸   r9   r¹   r=   zDPassword cannot be decrypted. Please type a new password and update.r<   r\   )r:   rL   )
r(   rj   r*   r   r-   r¾   ri   r	   r   rL   )r/   r[   r|   Úplains       r   Úview_staff_passwordrÊ   à  s²   € à�|‰|×Ñ  bÓ)×/Ñ/Ó1€Hð\Ü—‘×!Ñ! XÐ!Ó.ˆô ˜UŸ^™^Ó,€EÙÜØØ]ñ
ð ôð 	ô
  9¸%Ñ@ÓAÐAøô ×Ñ¤
Ð+ò \Ü wÐ;MÑNÐWZÔ[Ò[ð\ús   ¬ B Â)B-Â,B-c                 ó  — ddl m}m} ddlm} | j
                  j                  dd«      j                  «       }|j                  «       st        dg i«      S t        |«      }t        |j                  j                  |¬«      j                  dd¬	«      «      }|j                  j                  |¬
«      j                  dd«      j!                  «       }g }|D ]ø  }|j"                  xs t%        d«      }	t%        d«      }
 ||«      D ]Ç  }|
}|
t%        t'        |d   «      «      z  }
|d   |vrŒ'|	dkD  rt        ||	z  «      dz   nd}|j)                  |j*                  j,                  |j.                  j0                  |j*                  j2                  t5        ||j6                  «      |d   |d   |d   |d   |d   |d   |d   dkD  rdnddœ«       ŒÉ Œú |j9                  d„ d¬«       t;        |d¬«      D ]
  \  }}||d<   Œ t        d|i«      S )zUGET /admin/staff_collection_data/?id=<staff id> - every payment this staff collected.r   )ÚLoanÚLoanPayment)Ú_history_rowsr>   rA   rœ   )Úcollected_by_idT)Úflat)Úpayments__collected_by_idÚplaceÚcustomerÚ0Úpaid_due_amountrB   Úpayment_methodÚpayment_date_isoÚpending_amountÚpending_clearedÚextra_amountÚYesÚNo)rD   rÒ   rE   Ú
due_numberrÕ   rÖ   Úpayment_daterØ   rÙ   rÚ   Úextra_clearedc                 ó   — | d   S )NrÞ   © )Úrs    r   Ú<lambda>z'staff_collection_data.<locals>.<lambda>  s	   € ˜a Ò/ó    )Úkeyr   rŒ   Úsno)ÚNexusApp.modelsrÌ   rÍ   Ú+controllers.Admin.AdminloanreportControllerrÎ   rž   rj   r*   r+   r	   rg   rt   r-   r.   Úvalues_listÚselect_relatedr¢   Ú
due_amountr
   Ústrr¦   rÓ   Úcustomer_namerÒ   rD   Úphone_numberÚminÚnumber_of_duesÚsortr£   )r/   rÌ   rÍ   rÎ   r[   ÚmineÚloansr«   ÚloanÚdueÚrunningr­   ÚbeforerÝ   Úirâ   s                   r   Ústaff_collection_datarù   ñ  s÷  € ç1ÝIà�{‰{�‰˜t RÓ(×.Ñ.Ó0€HØ×ÑÔÜ˜V R˜LÓ)Ð)Ü�8‹}€Häˆ{×"Ñ"×)Ñ)¸(Ð)ÓC×OÑOÐPTÐ[_ÐOÓ`Óa€DØ�L‰L×Ñ¸(ÐÓC×[Ñ[Ð\cÐeoÓp×yÑyÓ{€Eà€FÛˆØ�o‰oÒ-¤¨£ˆÜ˜#“,ˆÙ  Ö&ˆCØˆFØ”wœs 3Ð'8Ñ#9Ó:Ó;Ñ;ˆGØ�4‰y Ñ$ØØ36¸²7œ˜V s™]Ó+¨aÒ/ÀˆJØ�M‰MØŸ™×3Ñ3ØŸ™Ÿ™ØŸ™×3Ñ3Ü! *¨d×.AÑ.AÓBØ#&Ð'8Ñ#9Ø"%Ð&6Ñ"7Ø #Ð$6Ñ 7Ø"%Ð&6Ñ"7Ø#&Ð'8Ñ#9Ø # NÑ 3Ø*-¨nÑ*=ÀÒ*A¡Àtñõ ñ 'ð ð, ‡K�KÑ/¸€KÔ>Ü˜&¨×*‰ˆˆ1Øˆˆ%Šð +ä˜ Ð(Ó)Ð)rä   )2ÚloggingÚdjango.contrib.auth.hashersr   Ú	django.dbr   r   Údjango.shortcutsr   Údjango.contribr   r   Údjango.httpr	   Údecimalr
   r   ÚNexusApp.utils.cryptor   r   rç   r   r   r   r   Údjango.db.modelsr   r   Údjango.urlsr   Údjango.utils.htmlr   Údjango.views.decorators.httpr   Údjango.core.validatorsr   Údjango.core.exceptionsr   Ú	getLoggerÚ__name__rb   r   r$   r2   r}   rµ   rÀ   rÄ   rÇ   rÊ   rù   rá   rä   r   Ú<module>r
     sª   ðÛ Ý 5ß 1Ý %Ý #Ý Ý $ß -ß Dß 3Ñ 3Ý #ß %Ý Ý $Ý 5Ý 1Ý 2ð 
ˆ×	Ñ	˜8Ó	$€òò,ò2ò
Qòfxðv ñ|ó ð|ò2(ò0nsðb ñBó ðBó '*rä   