n^j0 F d Z ddlZddlmZ ddlmZ ddlmZmZ ddl m
Z
ddl m Z m
Z
ddlmZ dd lmZ dd
lmZmZ d d lmZmZmZmZmZ d d
l m Z m Z m Z m Z d Z!d Z"e ed d Z#e ed d Z$e ed d-d Z%e ed eddg d Z&e ed d Z'e ed d-d Z(e ed eddg d Z)e ed d Z*e ed! d-d" Z+e ed# eddg d$ Z,e ed% d& Z-e ed' d-d( Z.e ed) eddg d* Z/e ed% d+ Z0d, Z1y).u'
revenue/views.py
================
Function-based views for Revenue Management (Module 4).
Includes CRUD endpoints, dashboard, and report with Excel export.
NOTE: ``horilla.decorators`` (NOT ``horilla_views.cbv_methods``) must be
used here — the latter expects a CBV ``self`` first-argument.
N)date)messages)QSum HttpResponse)get_object_or_404render) gettext_lazy)require_http_methods)login_requiredpermission_required )RevenueHeadFormRevenueItemFormRevenueRecordFormRevenueReportFilterFormRevenueSubHeadForm) RevenueHead RevenueItem
RevenueRecordRevenueSubHeadc t d S )zCStandard HTMX response to close the open modal and reload the page.zwr 1/var/www/python-projects/worksol/revenue/views.py_close_modal_reloadr & s r c t d S )z;Standard response after a delete triggered from a list row.zOr r r r _hx_delete_responser 1 s r zrevenue.view_revenueheadc > t j }|j }|j }t j
j
| }|j
| }|j t d d xs d}|j t d d xs d}t j
j
| j ddd j t d
j d }t j
j d d
d j dd d d } |||| |t j
j
d j t j
j
d j d}
t! | d|
S )N)transaction_date__year)transaction_date__monthamounttr% r item__sub_head__head__iditem__sub_head__head__codeitem__sub_head__head__name)totalz-totalitem__sub_head__head
department recorded_by-transaction_date -created_at
T is_active) ytd_total mtd_totalby_headrecent current_year
head_count
item_countzrevenue/dashboard.html)r todayyearmonthr objectsfilter aggregater valuesannotateorder_byselect_relatedr countr r
) requestr9 r6
current_month ytd_records mtd_recordsr2 r3 head_totalsr5 contexts r revenue_dashboardrJ @ sy
JJLE::LKKM ''..l.SK $$]$KK%%H
%6s;@qI%%H
%6s;@qI $$L$I *,HJf g H
& ( ,,-C\S`a %} 5cr ; $!))0040@FFH!))0040@FFHG '3W ==r c t j j d j d j d }t | dd|i S )NTr0 sub_headsnamezrevenue/head_list.htmlheads)r r< r= prefetch_relatedrA r
)rD rN s r revenue_head_listrP k sL ""T"2 + & &
'3gu5E FFr zrevenue.add_revenueheadc J |rt t | nd }t | j xs d | }| j dk( rI|j r9|j
t j | t d t S t | d|t d |d u d S )NpkinstancePOSTzRevenue head saved. revenue/partials/form_modal.html Revenue Headformtitle is_create) r r r rV methodis_validsaver success_r r
rD rS rU rZ s r revenue_head_formrc v 9; 4H 7<</4( CD~~ DMMO !$9":;"$$ *. 1D@PQ r zrevenue.delete_revenueheadrV DELETEc t t | }d|_ |j dg t j
| t
d t S )NrR Fr1
update_fieldszRevenue head deactivated.)r r r1 r_ r r` ra r rD rS objs r revenue_head_deleterk F KB
/CCMHHK=H) Wa ; <= r zrevenue.view_revenuesubheadc | j j d }t j j d j d j
dd }|r|j | }t | dd|i S ) NheadTr0
head__namerM )head_idzrevenue/sub_head_list.htmlrL )GETgetr r< r= rB rA r
)rD rp qss r revenue_sub_head_listrt st kkoof%G & & & 6 E Ef M V Vf
B
YYwY
' '7+r9J KKr zrevenue.add_revenuesubheadc |rt t | nd }i }|s | j j d |d< t | j
xs d || }| j dk( rI|j r9|j t j | t d t S t | d|t d |d u d S ) NrR rn )rU initialrV zRevenue sub-head saved.rW zRevenue Sub-HeadrY )r r rq rr r rV r] r^ r_ r r` ra r r
)rD rS rU rv rZ s r revenue_sub_head_formrw s <> B74HG
!++//&1 gll 2dXw WD~~ DMMO !$=">?"$$ *"4 5HPTDTU r z revenue.delete_revenuesubheadc t t | }d|_ |j dg t j
| t
d t S )NrR Fr1 rg z Revenue sub-head deactivated.)r r r1 r_ r r` ra r ri s r revenue_sub_head_deletery sF Nr
2CCMHHK=H) Wa ? @A r zrevenue.view_revenueitemc | j j d }t j j d j d j
ddd }|r|j | }t | d d
|i S ) Nsub_headTr0 sub_head__headsub_head__head__namesub_head__namerM ) sub_head_idzrevenue/item_list.htmlitems)rq rr r r< r= rB rA r
)rD sub_idrs s r revenue_item_listr sw [[__Z
(F # #d # 3 B BCS T ] ] 0&
B
YY6Y
* '3gr] CCr zrevenue.add_revenueitemc J |rt t | nd }t | j xs d | }| j dk( rI|j r9|j
t j | t d t S t | d|t d |d u d S )NrR rT rV zRevenue item saved.rW z Revenue ItemrY ) r r r rV r] r^ r_ r r` ra r r
rb s r revenue_item_formr rd r zrevenue.delete_revenueitemc t t | }d|_ |j dg t j
| t
d t S )NrR Fr1 rg zRevenue item deactivated.)r r r1 r_ r r` ra r ri s r revenue_item_deleter rl r zrevenue.view_revenuerecordc t j j ddd j dd }| j j d }|r|j
| }t | dd |i S )
Nr* r+ r, r- r. item)item_idzrevenue/record_list.htmlrecords)r r< rB rA rq rr r= r
)rD rs r s r revenue_record_listr sl
- - m
h"M2 kkoof%G
YYwY
' '5 2 GGr zrevenue.add_revenuerecordc |rt t | nd }t | j xs d || j }| j
dk( r{|j
rk|j d }| j |_ |j t j | t d d|j iz t S t | d|t d |d u d
S ) NrR )rU request_userrV F)commitz Revenue record %(ref)s saved.refrW zRevenue RecordrY )r r r rV userr] r^ r_ r, r r` ra reference_numberr r
)rD rS rU rZ records r revenue_record_formr s ;= 26$H W\\ 1THSZS_S_ `D~~ DMMO%( $\\
!$C"DvOfOfGg"gh"$$ *"2 3(dBRS r z revenue.delete_revenuerecordc t t | }|j }|j t j
| t
d d|iz t S )NrR z Revenue record %(ref)s deleted.r )r r r deleter r` ra r )rD rS rj r s r revenue_record_deleter sL Mb
1C
CJJL Wa A BeS\ QR r c t | j xs d }t j j ddd j d }|j
r|j }|j d r|j |d }|j d r|j |d }|j d r|j |d }|j d
r|j |d
}|j t d
d xs d}| j j d dk( r t | S ||||j d}t | d| S )Nr* r+ r, r- date_from)transaction_date__gtedate_to)transaction_date__lte)r+ revenue_head)r* r# r$ r% r exportexcel)rZ r r) rC zrevenue/report.html)r rq r r< rB rA r^ cleaned_datarr r= r> r _export_revenue_excelrC r
)rD rZ rs dr) rI s r revenue_reportr sF #7;;#6$ 7D - - m
h"# }} 55 ; @B 55 9 >B 55 a o6B 55 .0ABB LL3x=L )# . 3!E {{x G+$R(( G '0' ::r c dd l }ddlm}m} |j }|j
}d|_ g d} |dd } |dd
}t |d D ]' \ } }
|j d | |
} || _ || _
) t | d
D ] \ } }
|j |
j |
j j d |
j j |
j j" j$ j& |
j j" j& |
j j& |
j( rt+ |
j( ndt- |
j. |
j0 |
j2 r|
j2 j5 ndg
|j6 D ]D } t9 d | D d }t; |dz d |j< | d j> _ F tC jD }|jG | |jI d tK |jM d }d|d< |S )Nr )Font PatternFillzRevenue Report)
z Reference #zTransaction Datez Revenue CoderX zSub-HeadItem
Departmentu Amount (₦) Descriptionz Recorded ByTFFFFFF)boldcolorsolid2C7BE5)fgColorr )rowcolumnvalue z%Y-%m-%d c 3 ` K | ]& }t t |j xs d ( yw)r N)lenstrr ).0cells r z(_export_revenue_excel..e s# Bds3tzz /R01Bs ,.r/ )default ( zAapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet) content_typez*attachment; filename="revenue_report.xlsx"zContent-Disposition)'openpyxlopenpyxl.stylesr r Workbookactiver[ enumerater fontfillappendr transaction_datestrftimer coder{ rn rM r+ r floatr# descriptionr,
get_full_namecolumnsmaxmincolumn_dimensions
column_letterwidthioBytesIOr_ seekr read)rs r r r wbwsheaders header_font header_fillcolhr row_idxrecmax_lenbufresponses r r r A s 1 B B BHG D1K gx8KGQ' Qww1Sw2
""a(
) )* 5 HHMM HH " " ' ' HH " " HHMM#&>>C r #** OO/2COO ) ) +B
zz PBcBBO;>w{B;O SV 1 128P
**,CGGCLHHQK
XH 'SH
"# Or )N)2__doc__r datetimer django.contribr django.db.modelsr r django.httpr django.shortcutsr r
django.utils.translationr ra django.views.decorators.httpr horilla.decoratorsr
r formsr r r r r modelsr r r r r r rJ rP rc rk rt rw ry r r r r r r r r r r r r sw
# # $ 6 6 = B L K /0!> 1 !>R /0G 1 G ./ 0 12vx()! * 3 ! 23L 4 L 12 3 " 45vx()! * 6 ! /0D 1 D ./ 0 12vx()! * 3 ! 12H 3 H 01
2
34vx()! * 5 ! 12 ; 3 ;@0r