Ë
    ° kV#  ã                   ó\  — d dl Z d dl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mZmZ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 d dl	m	Z	m Z  d dl!m"Z" d dl#m$Z$m%Z%m&Z&  e jN                  e(«      Z)ddgdgdgdgdœZ*d„ Z+d„ Z,d„ Z-d„ Z.d„ Z/d„ Z0y)é    N)ÚtransactionÚIntegrityError)Úredirect)Úmessages)Údatetime)ÚJsonResponse)ÚDecimalÚInvalidOperation)Ú	AdminUserÚStaffÚLoanÚPlaceÚLoanPayment)ÚrenderÚget_object_or_404)ÚQ)Úreverse)Úescape)Úrequire_POST)ÚSum)r   Ú	timedelta)Útimezone)Ú
date_rangeÚrange_labelÚxlsx_responseÚpayment_dateÚidÚloan__customer__customer_nameÚcollected_by__nameÚamount)é   é   é   é   c                 ó˜  — | dvry	 t        j                  |d«      j                  «       }| dk(  r||fS | dk(  r.|t        |j                  «       ¬«      z
  }||t        d¬«      z   fS |j                  d¬	«      }|t        d
¬«      z   j                  d¬	«      }||t        d¬«      z
  fS # t        $ r t	        j
                  «       }Y Œ�w xY w)zM(start, end) dates for daily / weekly (Mon-Sun) / monthly, or None for 'all'.)ÚdailyÚweeklyÚmonthlyNz%Y-%m-%dr&   r'   )Údaysé   r!   )Údayé    )	r   ÚstrptimeÚdateÚ
ValueErrorr   Ú	localdater   ÚweekdayÚreplace)ÚperiodÚdate_strr+   ÚstartÚ
next_months        úG/var/www/html/nexus_chitfund_web/controllers/Admin/ReportsController.pyÚ_report_ranger8   )   sÔ   € àÐ3Ñ3Øð#Ü×Ñ ¨*Ó5×:Ñ:Ó<ˆð �ÒØ�CˆxˆØ�ÒØ”i S§[¡[£]Ô3Ñ3ˆØ�eœi¨QÔ/Ñ/Ð/Ð/Ø�K‰K˜AˆKÓ€EØœ)¨Ô,Ñ,×5Ñ5¸!Ð5Ó<€JØ�*œy¨aÔ0Ñ0Ð0Ð0øô ò #Ü× Ñ Ó"Šð#ús   ‡$B) Â)C	ÃC	c           	      óÔ  — i }t         j                  j                  | ¬«      j                  d«      j	                  dd«      }|D ]-  }|j                  |j                  g «      j                  |«       Œ/ i }|j                  «       D �]^  }|d   j                  }|j                  xs t        d«      }|j                  }t        d„ |D «       t        d«      «      }	t        d«      }
t        |«      D ]ò  \  }}|dkD  r|
|z  n
t        d«      }|dkD  r|
|z
  |z   n|
|j                  z   }t!        ||«      }t#        ||
z
  t        d«      «      }t#        ||j                  z
  t        d«      «      }t#        |j                  |z
  t        d«      «      }|
|j                  z  }
t%        |«      |	|k\  rdnd	t%        |«      |dkD  r|t'        |«      d
z
  k  rdnd	dœ||j(                  <   Œô �Œa |S )aL  
    Pending / extra for every payment of the given loans (same rule as Paid Due History):
      need    = what was still owed on the current due just before this payment
      pending = need - paid     (paid less than the due)
      extra   = paid - need     (paid ahead, goes to the next due)
    Returns {payment_id: {...}}.
    )Úloan_id__inÚloan__customerr   r   r   Ú0c              3   ó4   K  — | ]  }|j                   –— Œ y ­w©N)r    )Ú.0Úps     r7   Ú	<genexpr>z!_report_ledger.<locals>.<genexpr>Q   s   è ø€ Ð2©E q˜!Ÿ(�(©Eùs   ‚ÚYesÚNor!   )Úpending_amountÚpending_clearedÚextra_amountÚextra_cleared)r   ÚobjectsÚfilterÚselect_relatedÚorder_byÚ
setdefaultÚloan_idÚappendÚvaluesÚloanÚ
due_amountr	   Útotal_payableÚsumÚ	enumerater    ÚminÚmaxÚfloatÚlenr   )Úloan_idsÚby_loanÚpaymentsr@   ÚledgerÚitemsrP   ÚduerR   Ú
final_paidÚrunningÚidxÚdoneÚtargetÚneedÚpendingÚextras                    r7   Ú_report_ledgerrg   <   sº  € ð €Gä×Ñ×"Ñ"¨xÐ"Ó8ß	‰Ð(Ó	)¯(©(°>À4Ó*Hð ó ˆØ×Ñ˜1Ÿ9™9 bÓ)×0Ñ0°Õ3ð ð €FØ—‘×!ˆØ�Q‰x�}‰}ˆØ�o‰oÒ-¤¨£ˆØ×*Ñ*ˆÜÑ2©EÓ2´G¸C³LÓAˆ
Ü˜#“,ˆä Ö&‰FˆC�Ø&)¨A¢g�G˜c’M´7¸3³<ˆDØ-0°1ªW�W˜t‘^ cÒ)¸'ÀAÇHÁHÑ:LˆFÜ˜ Ó/ˆFÜ�v Ñ'¬°«Ó6ˆDä˜$ §¡™/¬7°3«<Ó8ˆGÜ˜Ÿ™ 4™¬°«Ó6ˆEØ�q—x‘xÑˆGô #(¨£.Ø,6¸&Ò,@¡5ÀdÜ % e£à*/°!ª)¸¼cÀ%»jÈ1¹nÒ8L¡ÐRVñˆF�1—4‘4ŠLò 'ð "ð0 €Mó    c                 óÒ  — | j                   j                  dd«      j                  «       j                  «       }| j                   j                  dd«      j                  «       }| j                   j                  dd«      j                  «       }t        j
                  j                  ddd«      }|j                  «       }t        ||«      }|r|j                  |¬	«      }t        | «      \  }}|r|j                  |¬
«      }|r|j                  |¬«      }|rO|j                  t        |¬«      t        |¬«      z  t        |¬«      z  t        |¬«      z  t        |¬«      z  «      }||fS )zˆPayments matching the period buttons, the From / To payment-date range and the search box.
    Returns (queryset, total before filters).r3   Úallr.   Ú zsearch[value]Úloan__placer;   Úcollected_by)Úpayment_date__range)Úpayment_date__gte)Úpayment_date__lte)Ú(loan__customer__customer_name__icontains)Ú'loan__customer__phone_number__icontains)Úloan__place__name__icontains)Úcollected_by__name__icontains)Úpayment_method__icontains)ÚGETÚgetÚstripÚlowerr   rH   rJ   Úcountr8   rI   r   r   )	Úrequestr3   r4   ÚsearchÚqsÚtotalÚperiod_ranger5   Úends	            r7   Ú_report_querysetr�   h   s;  € ð �[‰[�_‰_˜X uÓ-×3Ñ3Ó5×;Ñ;Ó=€FØ�{‰{�‰˜v rÓ*×0Ñ0Ó2€HØ�[‰[�_‰_˜_¨bÓ1×7Ñ7Ó9€Fä	×	Ñ	×	+Ñ	+¨MÐ;KÈ^Ó	\€BØ�H‰H‹J€Eä  ¨Ó2€LÙØ�Y‰Y¨<ˆYÓ8ˆä˜GÓ$�J€Eˆ3ÙØ�Y‰Y¨ˆYÓ/ˆÙ
Ø�Y‰Y¨ˆYÓ-ˆáØ�Y‰YÜ°vÔ>Ü¸Ô?ñ@ä¨VÔ4ñ5ô ¨fÔ5ñ6ô ¨&Ô1ñ	2ó
ˆð ˆuˆ9Ðrh   c           	      ó´  — | j                   j                  d«      | j                  j                  | j                  j                  | j                  j
                  j                  | j                  r| j                  j                  nd| j                  «       t        | j                  «      dœ}|j                  |j                  | j                  i «      «       |S )Nz%d-%m-%YÚAdmin)r.   ÚcustomerÚphoneÚplaceÚstaffÚpayment_methodr    )r   ÚstrftimerP   Úcustomer_nameÚphone_numberr†   Únamerm   Úget_payment_method_displayrW   r    Úupdaterw   r   )r@   r\   Úrows      r7   Ú_report_rowr�   ‡   s”   € à—‘×'Ñ'¨
Ó3Ø—F‘F×(Ñ(Ø—‘×$Ñ$Ø—‘—‘×"Ñ"Ø()¯ª�—‘×$Ò$¸GØ×6Ñ6Ó8Ü˜Ÿ™“/ñ€Cð ‡J�Jˆv�z‰z˜!Ÿ$™$ Ó#Ô$Ø€Jrh   c                 óÐ  — t        | «      \  }}t        |j                  dd«      «      }t        |D �ch c]  }|j                  ’Œ c}«      }g t        d«      }}t        |d¬«      D ]«  \  }}t        ||«      }	||j                  z  }|	j                  dd«      |	j                  dd«      }}
|j                  ||	d	   |	d
   |	d   |	d   |	d   |	d   |j                  |
|
dkD  r|	j                  dd«      nd||dkD  r|	j                  dd«      ndg«       Œ­ t        | «      \  }}| j                  j                  dd«      j                  «       j                  «       }t        || j                  j                  d	d«      j                  «       «      }dt!        ||«      › �}|r|d|j#                  «       › dt!        |Ž › �z  }t%        ddg d¢|||rddddddd|g¬«      S d¬«      S c c}w )zUExcel of every payment matching the Reports page filters (not only the visible page).ú-payment_dateú-idr<   r!   ©r5   rD   r   rF   r.   r„   r…   r†   r‡   rˆ   rE   Ú-rG   r3   rj   rk   zPayment date: z | z: Úcollection_reportzCollection Report)zS.NoÚDateÚCustomerÚPhoner   r   ÚModeÚAmountÚPendingzPending ClearedÚExtrazExtra ClearedÚTotalN)ÚsubtitleÚtotals)r�   ÚlistrK   rg   rM   r	   rT   r�   r    rw   rN   r   rv   rx   ry   r8   r   Útitler   )r{   r}   Ú_r[   r@   r\   Úbodyr~   ÚiÚrre   rf   r5   r€   r3   r   rŸ   s                    r7   Úreports_exportr§   •   só  € ä˜WÓ%�E€BˆÜ�B—K‘K °Ó7Ó8€HÜ±Ó9±¨1˜QŸY›Y°Ñ9Ó:€Fà”g˜c“lˆ%€DÜ˜(¨!×,‰ˆˆ1Ü˜˜6Ó"ˆØ�—‘ÑˆØŸ™Ð/°Ó3°Q·U±U¸>È1Ó5M�ˆØ�‰Øˆq�‰y˜!˜J™-¨¨7©°Q°w±ZÀÀ7ÁÈQÐO_ÑM`Ø�H‰H�gÀÈ!Â˜qŸu™uÐ%6¸Ô<ÐQTØ°%¸!²)�1—5‘5˜¨#Ô.Àð
õ 	ð	 -ô ˜GÓ$�J€Eˆ3Ø�[‰[�_‰_˜X uÓ-×3Ñ3Ó5×;Ñ;Ó=€FÜ  ¨¯©¯©¸ÀÓ)D×)JÑ)JÓ)LÓM€LØ¤¨E°3Ó 7Ð8Ð9€HÙØ�c˜&Ÿ,™,›.Ð)¨¬K¸Ð,FÐ+GÐHÑHˆÜØÐ0ò	Aà�xÙ;?�˜˜R  R¨¨R°Ð7ôKð Kð
 FJôKð Kùò' :s   ³G#c           	      óV  — | j                   j                  d«      dk7  rt        dddœd¬«      S d„ } || j                  j                  d	«      d
«      }	 t	        | «      \  }}|j                  «       } || j                  j                  d«      d«      }|t        v rK| j                  j                  dd«      dk(  } |j                  t        |   D �cg c]  }|rd|z   n|‘Œ c}Ž }n|j                  dd«      }t         || j                  j                  d«      d«      d«      }	 || j                  j                  d«      d«      }
t        |
dk(  r||	d n||	|	t        |
d
«      z    «      }t        |D �ch c]  }|j                  ’Œ c}«      }g }t        ||	d
z   ¬«      D ]5  \  }}d|i}|j                  t        ||«      «       |j                  |«       Œ7 t        ||||dœ«      S c c}w c c}w # t         $ r+ t"        j%                  d«       t        |ddg ddœd¬«      cY S w xY w)zRAJAX (DataTables server-side) for /admin/reports/ - one row per collected payment.zx-requested-withÚXMLHttpRequestÚerrorzInvalid request.)ÚstatusÚmessagei�  )r«   c                 óH   — 	 t        | «      S # t        t        f$ r |cY S w xY wr>   )ÚintÚ	TypeErrorr/   )ÚvalueÚdefaults     r7   Úto_intzreports_data.<locals>.to_int¹   s*   € ð	Ü�u“:ÐøÜœ:Ð&ò 	ØŠNð	ús   ‚
 �! !Údrawr!   zorder[0][column]éÿÿÿÿzorder[0][dir]ÚascÚdescr•   r’   r“   r5   r   Úlengthé
   Nr”   ÚDT_RowIndex)r³   ÚrecordsTotalÚrecordsFilteredÚdatazreports_data failedzCould not load reports.)r³   rº   r»   r¼   rª   iô  )Úheadersrw   r   rv   r�   rz   ÚREPORT_SORTrK   rV   r¡   rg   rM   rT   rŽ   r�   rN   Ú	ExceptionÚloggerÚ	exception)r{   r²   r³   r}   r~   ÚfilteredÚ	order_colr¶   Úfr5   r·   Úpager@   r\   r¼   r¥   r�   s                    r7   Úreports_datarÆ   ´   s!  € à‡�×ÑÐ-Ó.Ð2BÒBÜ wÐ;MÑNÐWZÔ[Ð[òñ �'—+‘+—/‘/ &Ó)¨1Ó-€Dð$Ü$ WÓ-‰	ˆˆEØ—8‘8“:ˆñ ˜7Ÿ;™;Ÿ?™?Ð+=Ó>ÀÓCˆ	ØœÑ#Ø—;‘;—?‘? ?°EÓ:¸fÑDˆDØ�—‘ÄÈYÒAWÓXÑAW¸A©4  a¢°QÑ 6ÐAWÑXÐY‰Bà—‘˜_¨eÓ4ˆBä‘F˜7Ÿ;™;Ÿ?™?¨7Ó3°QÓ7¸Ó;ˆÙ˜Ÿ™Ÿ™¨Ó1°2Ó6ˆÜ &¨B¢,�B�u�v‘J°B°u¸UÄSÈÐQRÃ^Ñ=SÐ4TÓUˆä±DÓ 9±D¨q §£°DÑ 9Ó:ˆàˆÜ˜d¨%°!©)×4‰DˆAˆqØ  !Ð$ˆCØ�J‰J”{ 1 fÓ-Ô.Ø�K‰K˜Õð 5ô
 ØØ!Ø'Øñ	
ó ð 	ùò! Yùò !:øô ò Ü×ÑÐ.Ô/ÜØ¨!ÀÈ2Ø.ñ
ð ôò 	ðús3   ÁA>G4 ÃG*Ã#BG4 Å6G/Æ	A G4 Ç*
G4 Ç41H(È'H()1ÚloggingÚreÚ	django.dbr   r   Údjango.shortcutsr   Údjango.contribr   r   Údjango.httpr   Údecimalr	   r
   ÚNexusApp.modelsr   r   r   r   r   r   r   Údjango.db.modelsr   Údjango.urlsr   Údjango.utils.htmlr   Údjango.views.decorators.httpr   r   r   Údjango.utilsr   ÚNexusApp.utils.excelr   r   r   Ú	getLoggerÚ__name__rÀ   r¾   r8   rg   r�   r�   r§   rÆ   © rh   r7   Ú<module>rØ      s—   ðó Û 	ß 1Ý %Ý #Ý Ý $ß -ç EÕ Eß 6Ý Ý Ý $Ý 5Ý  ß (Ý !ç GÑ Gà	ˆ×	Ñ	˜8Ó	$€ð 	˜ÐØ'Ð(ØÐØ€zñ	€ò1ò&)òXò>òKó>0rh   