
    +h9                         S SK Jr  S SKJr  S SKJr  S SKJr  S SKJ	r	J
r
JrJr  S SKJr  S SKJrJr  S SKJrJrJrJrJrJrJrJrJr   " S	 S
\\5      r " S S\\5      r " S S\\5      r " S S\\5      rg)    )JsonResponse)render)View)LoginRequiredMixin)F
FloatFieldCountSum)Team)ProgramsProjects)	ExpenditureIncomesHRExpenditureEquipmentExpenditureTravelExpenditureIECExpenditureAccommodationExpenditureMiscellaneousExpenditureOfficeExpenditurec                       \ rS rSrS rSrg)DashboardViews   c                 N   [         R                  R                  5       n[        R                  R                  5       n[        R                  R                  5       n[
        R                  R                  5       n[        R                  R                  5       n[        R                  R                  5       n[        R                  R                  5       n[        R                  R                  5       n	[        R                  R                  5       n
[        R                  R                  5       n[        R                  R                  5       nSUR                  ;   Ga  UR                  S   S:w  Ga  [
        R                  R                  UR                  S   S9n[        R                  R                  UR                  S   S9n[        R                  R                  UR                  S   S9n[        R                  R                  UR                  S   S9n[        R                  R                  UR                  S   S9n	[        R                  R                  UR                  S   S9n
[        R                  R                  UR                  S   S9n[        R                  R                  UR                  S   S9nUR                  =(       a    UR                  S   nUR                  UR                  S   S9R                  5       nUR                  UR                  S   S9nOSnSUR                  ;   Ga  UR                  S   S:w  a  UR                  UR                  S   S9nUR                  UR                  S   S	9nUR                  UR                  S   S
9nUR                  UR                  S   S9nU	R                  UR                  S   S9n	U
R                  UR                  S   S9n
UR                  UR                  S   S9nUR                  UR                  S   S9nUR                  S   nOSnUR!                  [#        S5      S9S   =(       d    SnUR!                  [#        S5      S9S   =(       d    SnUR!                  [#        S5      S9S   =(       d    SnUR!                  [#        S5      S9S   =(       d    SnU	R!                  [#        S5      S9S   =(       d    Sn	U
R!                  [#        S5      S9S   =(       d    SnUR!                  [#        S5      S9S   =(       d    SnUR!                  [#        S 5      S!9S    =(       d    SnXg-   U-   U	-   U-   U-   U-   nUR%                  5       nUR%                  5       n['        US"UUX#XMUS#.5      $ )$NprojectAll
project_idexpenditure__project_id)program_team__project_iddate payment_datehr_expence_dateequipment_expence_datetravel_expence_dateiec_expence_dateaccomodation_expence_datemiscellaneous_expence_dateoffice_expence_datereceived_amount)income_amountr5   r   	hr_amountr6   equipment_amountr8   travel_amountr:   
iec_amountr<   accommodation_amountr>   miscellaneous_amountr@   office_amountrB   zdashboard.html)r5   expenditure_amountteambeneficiariesprojectsr   r"   )r   objectsallr   r   r   r   r   r   r   r   r   r   GETfilterdistinct	aggregater
   countr   )selfrequestrE   rF   rG   r5   r6   r8   r:   r<   accomodation_amountr@   rB   r   r"   r>   rD   s                    %/var/www/html/KUNJ/dashboard/views.pygetDashboardViews.get   sd    ||! ((,,.##'')++-!))--/	/77;;=)11557#++//1
6>>BBD7??CCE)11557#I(>%(G#OO22I@V2WM%--44w{{[dOe4fI3;;BB]d]h]hir]sBt-55<<W^WbWbclWm<nM'//66QXQ\Q\]fQg6hJ":"B"B"I"Idkdodopydz"I"{#;#C#C#J#Jelepepqze{#J#| -55<<W^WbWbclWm<nMkk<gkk)&<G;;'++i:P;QZZ\D)00gkk)>T0UMG W[[ W[[%8B%>)00F@S0TM!((7;;v;N(OI/66PWP[P[\bPc6d)00w{{SYGZ0[M#**gkk&>Q*RJ"5"<"<Y`YdYdekYl"<"m#7#>#>\c\g\ghn\o#>#p )00w{{SYGZ0[M;;v&DD%//DU@V/WXghmlm''C4D'EkRWVW	+55M_I`5abtuzyz%//O@T/UVefkjk))s<7H)I,W\[\
2<<TWXnTo<p  rH   I   N  MN3==UXYoUp=q  sI   J   O  NO%//O@T/UVefkjk&9MIJVYmm  qE  E  HU  Uzz|%++-g/Mj|  HL  |D  dh  2i  j  	j     N__name__
__module____qualname____firstlineno__rS   __static_attributes__rV   rU   rR   r   r      s    8jrU   r   c                       \ rS rSrS rSrg)ExpenditureChartViewM   c           	      V   [         R                  R                  5       n[        R                  R                  5       n[        R                  R                  5       n[
        R                  R                  5       n[        R                  R                  5       n[        R                  R                  5       n[        R                  R                  5       nSUR                  ;   Ga:  UR                  S   S:w  Ga&  [         R                  R                  UR                  S   S9n[        R                  R                  UR                  S   S9n[        R                  R                  UR                  S   S9n[
        R                  R                  UR                  S   S9n[        R                  R                  UR                  S   S9n[        R                  R                  UR                  S   S9n[        R                  R                  UR                  S   S9nSUR                  ;   a  UR                  S   S:w  a  UR                  UR                  S   S9nUR                  UR                  S   S9nUR                  UR                  S   S9nUR                  UR                  S   S	9nW	R                  UR                  S   S
9n	UR                  UR                  S   S9nUR                  UR                  S   S9nUR                  [        S5      S9S   =(       d    SnUR                  [        S5      S9S   =(       d    SnUR                  [        S5      S9S   =(       d    SnUR                  [        S5      S9S   =(       d    SnUR                  [        S5      S9S   =(       d    SnUR                  [        S5      S9S   =(       d    SnUR                  [        S5      S9S   =(       d    SnSUS.SUS.SUS.S US.S!US.S"US.S#US./n
[        S$U
0S%S&9$ )'Nr   r   r   r"   r#   r&   r(   r*   r,   r.   r0   r2   r6   r7   r   r8   r9   r:   r;   r<   r=   r>   r?   r@   rA   rB   rC   z	HR AmountnameyzEquipment AmountzTravel Amountz
IEC AmountzAccomodation AmountzMiscellaneous AmountzOffice AmountamountsFsafe)r   rH   rI   r   r   r   r   r   r   rJ   rK   rM   r
   r   )rO   rP   r6   r8   r:   r<   r>   r@   rB   rQ   rd   s              rR   rS   ExpenditureChartView.getO   s     "))--/	/77;;=)11557#++//1
7??CCE7??CCE)11557#I(>%(G%--44w{{[dOe4fI3;;BB]d]h]hir]sBt-55<<W^WbWbclWm<nM'//66QXQ\Q\]fQg6hJ#;#C#C#J#Jelepepqze{#J#| #;#C#C#J#Jelepepqze{#J#| -55<<W^WbWbclWm<nMW[[ W[[%8B%>!((7;;v;N(OI/66PWP[P[\bPc6d)00w{{SYGZ0[M#**gkk&>Q*RJ"5"<"<Y`YdYdekYl"<"m#7#>#>\c\g\ghn\o#>#p )00w{{SYGZ0[M''C4D'EkRWVW	+55M_I`5abtuzyz%//O@T/UVefkjk))s<7H)I,W\[\
3==UXYoUp=q  sI   J   O  NO3==UXYoUp=q  sI   J   O  NO%//O@T/UVefkjk "	2(0@A%];"*5+3GH,4HI%];
 Y0u==rU   rV   NrW   rV   rU   rR   r^   r^   M   s    />rU   r^   c                       \ rS rSrS rSrg)IncomeChartView   c                 v   [         R                  R                  5       nSUR                  ;   a/  UR                  S   S:w  a  UR	                  UR                  S   S9nSUR                  ;   a/  UR                  S   S:w  a  UR	                  UR                  S   S9nUR                  [        S5      S9S   =(       d    S	nUR                  [        S
5      S9S
   =(       d    S	nUR                  [        S5      S9S   =(       d    S	nUR                  [        S5      S9S   =(       d    S	nUR                  [        S5      S9S   =(       d    S	nUR                  [        S5      S9S   =(       d    S	nUR                  [        S5      S9S   =(       d    S	n	UR                  [        S5      S9S   =(       d    S	n
UR                  [        S5      S9S   =(       d    S	nUR                  [        S5      S9S   =(       d    S	nSUS.SUS.SUS.S US.S!US.S"US.S#U	S.S$U
S.S%US.S&US./
n[        S'U0S(S)9$ )*Nr   r   r   r"   r#   r$   human_resourcerl   r   camp_expenses)rn   training_expenses)ro   equipment_expensesrp   travel_expensesrr   material_expencesrt   administrative_expenses)rv   accomodation_expensesrw   monitoring_expenses)ry   miscellaneous_expensesrz   zHuman Resourcera   zCamp ExpenseszTraining ExpenseszEquipment ExpenseszTravel ExpenseszMaterial ExpenceszAdministrative ExpenseszAccomodation ExpenseszMonitoring ExpenseszMiscellaneous Expensesincome_resultFre   )r   rH   rI   rJ   rK   rM   r
   r   )rO   rP   incomes_datarl   rn   ro   rp   rr   rt   rv   rw   ry   rz   incomess                 rR   rS   IncomeChartView.get   s   **,#I(>%(G'..GKK	<R.SLW[[ W[[%8B%>'..gkk&>Q.RL &//EUAV/WXhinmn$..s??S.TUdejij(22sK^G_2`atuzyz)33MaIb3cdxy~}~&003GXCY0Z[lmrqr(22sK^G_2`atuzyz"."8"8SVWpSq"8"r  tM  #N  #S  RS , 6 6sSjOk 6 l  nE  !F  !K  JK*443OdKe4fg|}  C  BC!-!7!7QTUmQn!7!o  qI  "J  "O  NO '^<%];)1BC*2DE'?)1BC/7NO-5JK+3FG.6LM
 W
 	rU   rV   NrW   rV   rU   rR   ri   ri      s    &rU   ri   c                       \ rS rSrS rSrg)IncomeExpenditureChartView   c                 |	   [         R                  R                  5       n[        R                  R                  5       n[        R                  R                  5       n[
        R                  R                  5       n[        R                  R                  5       n[        R                  R                  5       n[        R                  R                  5       nSUR                  ;   Ga,  UR                  S   S:w  Ga  UR                  UR                  S   S9n[        R                  R                  UR                  S   S9n[        R                  R                  UR                  S   S9n[
        R                  R                  UR                  S   S9n[        R                  R                  UR                  S   S9n[        R                  R                  UR                  S   S9n[        R                  R                  UR                  S   S9nSUR                  ;   a  UR                  S   S:w  a  UR                  UR                  S   S9nUR                  UR                  S   S9nUR                  UR                  S   S	9nUR                  UR                  S   S
9nUR                  UR                  S   S9nW	R                  UR                  S   S9n	UR                  UR                  S   S9nUR                  [        S5      S9S   =(       d    Sn
UR                  [        S5      S9S   =(       d    SnUR                  [        S5      S9S   =(       d    SnUR                  [        S5      S9S   =(       d    SnUR                  [        S5      S9S   =(       d    SnUR                  [        S5      S9S   =(       d    SnUR                  [        S5      S9S   =(       d    SnUR                  [        S5      S9S   =(       d    SnUR                  [        S5      S 9S   =(       d    SnUR                  [        S!5      S"9S!   =(       d    SnUR                  [        S#5      S$9S#   =(       d    SnUR                  [        S%5      S&9S%   =(       d    SnXXX/nX4XVXx/n[        UUS'.S(S)9$ )*Nr   r   r   r   r"   r#   r$   r&   r(   r*   r,   r.   r0   rl   rm   r   rp   rq   rr   rs   rt   ru   rw   rx   rz   r{   r6   r7   r8   r9   r:   r;   r<   r=   r>   r?   r@   rA   )r|   amount_resultFre   )r   rH   rI   r   r   r   r   r   r   rJ   rK   rM   r
   r   )rO   rP   r}   r6   r8   r:   r<   r>   r@   rQ   rl   rp   rr   rt   rw   rz   r~   rd   s                     rR   rS   IncomeExpenditureChartView.get   s   **,!))--/	/77;;=)11557#++//1
7??CCE7??CCE#I(>%(G'..GKK	<R.SL%--44w{{[dOe4fI3;;BB]d]h]hir]sBt-55<<W^WbWbclWm<nM'//66QXQ\Q\]fQg6hJ#;#C#C#J#Jelepepqze{#J#| #;#C#C#J#Jelepepqze{#J#| W[[ W[[%8B%>'..gkk&>Q.RL!((7;;v;N(OI/66PWP[P[\bPc6d)00w{{SYGZ0[M#**gkk&>Q*RJ"5"<"<Y`YdYdekYl"<"m#7#>#>\c\g\ghn\o#>#p %//EUAV/WXhinmn)33MaIb3cdxy~}~&003GXCY0Z[lmrqr(22sK^G_2`atuzyz , 6 6sSjOk 6 l  nE  !F  !K  JK!-!7!7QTUmQn!7!o  qI  "J  "O  NO''C4D'EkRWVW	+55M_I`5abtuzyz%//O@T/UVefkjk))s<7H)I,W\[\
3==UXYoUp=q  sI   J   O  NO3==UXYoUp=q  sI   J   O  NO![p  JK_v$%
  	rU   rV   NrW   rV   rU   rR   r   r      s    1rU   r   N) django.httpr   django.shortcutsr   django.viewsr   django.contrib.auth.mixinsr   django.db.modelsr   r   r	   r
   hr_department.modelsr   program_department.modelsr   r   finance_department.modelsr   r   r   r   r   r   r   r   r   r   r^   ri   r   rV   rU   rR   <module>r      sp    $ #  9 6 6 % 8 J  J  J:j' :j@1>-t 1>l(($ (Z3!3T 3rU   