Ë
    TMýj~  ã                   óÄ   — d dl Z d dl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 d dlmZ d dlmZ  ej"                  e«      Z ed	«      Zd
„ Zd„ Zd„ Zd„ Zd„ Zd„ Zy)é    N)ÚDecimal)Úmessages)ÚJsonResponse)ÚredirectÚrender)Útimezone)ÚLoan)Ústaff_loansÚ0c                 ó6  — t        t        | xs d«      «      } | dk  rdnd}t        | «      } t        | «      }| |z
  }t        |«      }t	        |«      dkD  r'|d d |dd  }}t        j                  dd|«      dz   |z   }|r|d	t        |d
z  «      d›�z  }|› d|› �S )Nr   Ú-Ú é   éýÿÿÿz(\d)(?=(\d\d)+$)z\1,Ú,Ú.éd   Ú02du   â‚¹)r   ÚstrÚabsÚintÚlenÚreÚsub)ÚvalueÚsignÚwholeÚpaiseÚsÚheadÚtails          úN/var/www/html/nexus_chitfund_web/controllers/Staff/PaymentinvoiceController.pyÚ_moneyr#      s²   € Ü”C˜š
 “OÓ$€Eà˜!’)‰3 €DÜ�‹J€Eä�‹J€EØ�E‰M€EäˆE‹
€Aä
ˆ1ƒv�‚zØ�s˜�V˜Q˜r˜s˜VˆdˆÜ�F‰FÐ&¨°Ó5¸Ñ;¸dÑBˆáØ	ˆq”�U˜S‘[Ó! #Ð&Ð'Ñ'ˆàˆV�3�q�cˆ?Ðó    c                 óh   — t        j                  dd| xs d«      }t        |«      dk\  rd|dd  z   S dS )Nz\Dr   é
   Ú91iöÿÿÿ)r   r   r   )ÚphoneÚdigitss     r"   Ú_whatsapp_numberr*   0   s9   € Ü�V‰V�E˜2˜uš{¨Ó+€FÜ"% f£+°Ò"3ˆ4�&˜˜�,ÑÐ;¸Ð;r$   c                 óì  — | j                   j                  d«      j                  dd«      }g }t        }| j                  xs t        }| j
                  xs t        }t        |d¬«      D �]  \  }}||j                  z  }|dkD  rt        |j                  |z
  t        «      nt        }t        ||z
  t        «      }	|j                  ||j                  j                  d«      t        |j                  «      |j                  «       |j                  |j                  r|j                  j                   ndt        |«      |dkD  t        |	«      |	dkD  |j#                  «       |j$                  d	k(  d
œ«       �Œ
 |S )NÚcollected_byÚpayment_dateÚidé   )Ústartr   ú%d %b %Yr   Ú	completed)ÚsnoÚdateÚamountÚmethodÚ
method_keyr,   ÚextraÚ	has_extraÚbalanceÚhas_balanceÚstatusÚis_completed)ÚpaymentsÚselect_relatedÚorder_byÚZEROÚ
due_amountÚtotal_payableÚ	enumerater5   ÚmaxÚappendr-   Ústrftimer#   Úget_payment_method_displayÚpayment_methodr,   ÚnameÚget_payment_status_displayÚpayment_status)
Úloanr>   ÚrowsÚrunning_paidrB   rC   ÚnumberÚpaymentr8   r:   s
             r"   Úbuild_invoice_payment_rowsrR   9   sY  € à�}‰}×+Ñ+Øóç�hˆ~˜tÓ$ð ð €Dä€LØ—‘Ò(¤D€JØ×&Ñ&Ò.¬$€Mä$ X°Q×7Ð7‰ˆ�à˜Ÿ™Ñ&ˆð ˜AŠ~ô �—‘ Ñ+¬TÔ2Ü#'ð 	ô
 �m lÑ2´DÓ9ˆà�‰ØØ×(Ñ(×1Ñ1°*Ó=Ü˜WŸ^™^Ó,à×8Ñ8Ó:Ø!×0Ñ0ð ×'Ò'ð ×$Ñ$×)Ò)Ø-0ô ˜E“]Ø ™ä˜g“Ø" Q™;à×8Ñ8Ó:Ø#×2Ñ2°kÑAñ)
ö 	ð 8ðD €Kr$   c                 óV  — | j                   xs t        }| j                  xs t        }| j                  j	                  d«      j                  dd«      }t        }t        }d}|D ]C  }|dz  }||j                  z  }|dkD  rt        |j                  |z
  t        «      nt        }||z  }ŒE t        ||z
  t        «      }	|dkD  r#t        t        ||z  «      | j                  «      }
nd}
| d| j                  d›�t        j                  «       j                  d«      | j                  j                   t#        | j$                  «      t'        | j(                  «      t'        |«      | j+                  «       | j                  |
| j                  |
z
  |t'        |«      t'        |	«      t'        |«      d	œS )
Nr,   r-   r.   r   r/   zNEXUS-Ú03dr1   )rM   Ú
invoice_noÚinvoice_dateÚbranchÚwhatsapp_numberÚloan_amountrB   Úpayment_typeÚ
total_duesÚ	paid_duesÚpending_duesÚtotal_paymentsÚ
total_paidÚtotal_pendingÚtotal_extra)rB   rA   rC   r>   r?   r@   r5   rE   Úminr   Únumber_of_duesr.   r   Ú	localdaterG   ÚplacerJ   r*   Úphone_numberr#   rY   Úget_payment_type_display)rM   rB   rC   r>   r_   ra   r^   rQ   r8   r`   r\   s              r"   Úbuild_invoice_contextrh   n   s’  € à—‘Ò(¤D€JØ×&Ñ&Ò.¬$€Mà�}‰}×+Ñ+Øóç�hˆ~˜tÓ$ð ô €JÜ€KØ€Nãˆà˜!ÑˆØ�g—n‘nÑ$ˆ
ð ˜AŠ~ô �—‘ Ñ+¬TÔ2Ü#'ð 	ð
 	�uÑ‰ð ô ˜¨
Ñ2´DÓ9€Mà�A‚~ÜÜ�
˜jÑ(Ó)Ø×Ñó
‰	ð
 ˆ	ð à˜tŸw™w s˜mÐ,Ü ×*Ñ*Ó,×5Ñ5°jÓAà—*‘*—/‘/Ü+¨D×,=Ñ,=Ó>ä˜d×.Ñ.Ó/Ü˜ZÓ(à×5Ñ5Ó7à×)Ñ)ØØ×+Ñ+¨iÑ7à(Ü˜ZÓ(Ü Ó.Ü˜kÓ*ñ+ð r$   c                 ó&  — | j                   j                  dd«      j                  «       }	 t        | t        j
                  j                  dd«      «      j                  t        |«      ¬«      }	 t        |«      }t%        | d
|«      S # t        j                  t        t        f$ r$ t        j                  | d«       t        d«      cY S w xY w# t        $ r: t         j#                  d|«       t        j                  | d	«       t        d«      cY S w xY w)Nr.   r   re   Úcustomer©r.   úLoan not found.zstaff:loan_registersz"payment_invoice failed for loan %sz%Unable to load the payment statement.zstaffpanel/payment_invoice.html)ÚGETÚgetÚstripr
   r	   Úobjectsr?   r   ÚDoesNotExistÚ
ValueErrorÚ	TypeErrorr   Úerrorr   rh   Ú	ExceptionÚloggerÚ	exceptionr   )ÚrequestÚloan_idrM   Úcontexts       r"   Úpayment_invoicer{   ¯   sÿ   € à�k‰k�o‰o˜d BÓ'×-Ñ-Ó/€Gð0Ü˜7¤D§L¡L×$?Ñ$?ÀÈÓ$TÓU×YÑYÜ�7‹|ð Zó 
ˆð0Ü'¨Ó-ˆô  ØØ)Øóð øô- ×Ñœz¬9Ð5ò 0ä�‰�wÐ 1Ô2ÜÐ.Ó/Ò/ð0ûô ò 0ä×ÑØ0Øô	
ô
 	�‰ØØ3ô	
ô
 Ð.Ó/Ò/ð0ús%   ¬AB Á0C Â?C
Ã	C
ÃA DÄDc                 óž  — | j                   j                  dd«      j                  «       }	 t        | «      j                  t	        |«      ¬«      }t        |«      }t        d|dœ«      S # t        j                  t        t        f$ r t        ddg dœd	¬
«      cY S t        $ r* t        j                  d|«       t        ddg dœd¬
«      cY S w xY w)Nr.   r   rk   T)ÚsuccessÚdataFrl   )r}   Úmessager~   i”  )r<   z'payment_invoice_data failed for loan %szUnable to load payment history.iô  )rm   rn   ro   r
   r   rR   r   r	   rq   rr   rs   ru   rv   rw   )rx   ry   rM   rN   s       r"   Ústaff_payment_invoice_datar€   Ú   sà   € à�k‰k�o‰o˜d BÓ'×-Ñ-Ó/€GðÜ˜7Ó#×'Ñ'¬3¨w«<Ð'Ó8ˆä)¨$Ó/ˆäØØñ
ó ð 	øô
 ×Ñœz¬9Ð5ò äØØ(Øñ
ð ô	ò 	ô ò ä×ÑØ5Øô	
ô
 ØØ8Øñ
ð ô	ò 	ðús   ¬<A) Á)/CÂ/CÃC)r   ÚloggingÚdecimalr   Údjango.contribr   Údjango.httpr   Údjango.shortcutsr   r   Údjango.utilsr   ÚNexusApp.modelsr	   ÚNexusApp.utils.staff_scoper
   Ú	getLoggerÚ__name__rv   rA   r#   r*   rR   rh   r{   r€   © r$   r"   Ú<module>rŒ      s\   ðã 	Û Ý å #Ý $ß -Ý !å  Ý 2à	ˆ×	Ñ	˜8Ó	$€áˆsƒ|€òò2<ò.òj9òB#óV!r$   