y{j[K<dZddlmZddlmZddlmZddlmZGddejZ Gdd ejZ dd l Z Gd d ejZ Gd dejZGddejZGddejZy )u Accounting models for the Kalingar Trust Portal. Design decisions: - StaffProfile: Lightweight model for non-member staff (e.g. Accountants). Keeps the Member table clean — only actual temple members live there. - AccountTransaction uses SOFT DELETE (is_deleted flag). Financial records are NEVER hard-deleted so the audit trail is preserved and receipt numbers are never reused, even after soft-deletion. - change_log (JSONField) stores an append-only list of edit history entries so previous values are never silently overwritten. - No approval workflow — transactions count toward totals immediately. An optional approval step (is_approved, approved_by) could be added later without schema breakage. )models)User)ValidationError)timezoneceZdZdZdgZej eejdZ ejddZ ejddd d Z ejd dddd Z ejdedZejddZej"dZej"dZGddZdZy) StaffProfileu A non-member staff user such as an Accountant. Separate from Member so the membership table is not polluted with non-member records. Admin users (is_staff=True) do NOT need a StaffProfile — they are identified by the Django User flag. ) ACCOUNTANT Accountant staff_profile on_delete related_namez Full Name max_length verbose_nameTzFull Name (Tamil)rblankdefaultrz Phone Number)runiquenullrrr )rchoicesrActiverr auto_now_addauto_nowceZdZdZdZy)StaffProfile.Metaz Staff ProfilezStaff ProfilesN)__name__ __module__ __qualname__rverbose_name_plural;/var/www/kalinger_portal/trust-backend/accounting/models.pyMetar#6s & .r)r+cB|jd|jdSNz ())nameget_role_displayselfs r*__str__zStaffProfile.__str__:s#))Bt4467q99r)N)r$r%r&__doc__ ROLE_CHOICESr OneToOneFieldrCASCADEuser CharFieldr/name_taphonerole BooleanField is_active DateTimeField created_at updated_atr+r3r(r)r*rrs %L 6   _ D 6  s EDf#T2TghG F  4d$]k lE 6  |\ D$##DxHI%%%48J%%%t4J//:r)rceZdZdZddgZej ddZej dddd Zejdd Z ejddd Z ej dedddZ gdZ ej de ddZejdZej"eej&dddZej*dZej*dZGddZdZy) AccountHeadz A category (aka "account head") under which income/expenses are recorded. Examples: "Kovil Kodai 2026", "Monthly Maintenance", "General Fund". )KodairD)GeneralrEi,zAccount Head NamerTrzAccount Head Name (Tamil)rrrzDescription (Tamil)rrrrTyperrrrr))AssetrJ) LiabilityrK)EquityrL)RevenuerM)ExpenserNrM Account Typerrrrrcreated_account_headsr rrrrr ceZdZdgZdZdZy)AccountHead.Meta -created_atz Account Headz Account HeadsNr$r%r&orderingrr'r(r)r*r+rUis!?% -r)r+c|jSN)r/r1s r*r3zAccountHead.__str__ns yyr)N)r$r%r&r4 TYPE_CHOICESrr9r/r: TextField descriptiondescription_ta head_typeACCOUNT_TYPE_CHOICES account_typer=r> ForeignKeyrSET_NULL created_byr?r@rAr+r3r(r)r*rCrCBs! L 6  s9L MDf#T2TopG"&""r:K%V%%D"K`aN   |4I$6##3Y#L$##D1I""" d$,J&%%48J%%%t4J.. r)rCNceZdZgdZgdZddgZejdejdZ ejdd Z ejd ed Z ejd ed Zejdej ddddZejdej ddddZejddddZejddddZejddddZejd eddZej.ddZej.ddd !Zejeej ddd"d#ZGd$d%Zd&Zd'Zy()) TrustAccount)Cashrh)Bankri Commoditiesrk)) Trust_Directz Trust Direct)Memberrm) Member_Familyz Member Family)rr)InactiveroTF) primary_keyreditablez Account NamerrrO)rrrzAssociated Entity Typemembers.Membertrust_accountszCustodian Memberr rrrrcustodian_trust_accountszCustodian Family MemberdrzAccount Numberrz Bank Namez Branch NamerStatusrPz Created Date)rrzDeactivated Date)rrrcreated_trust_accounts Created ByceZdZdgZdZdZy)TrustAccount.Meta account_name Trust AccountzTrust AccountsNrWr(r)r*r+r|s"#& .r)r+c:|jd|jdSr-)r}rar1s r*r3zTrustAccount.__str__s###$Bt'8'8&9;;r)c|jdk(r0|jr|jr |js t dyy)NrizcBank fields (account number, bank name, branch name) are strictly mandatory for Bank account types.)raaccount_number bank_name branch_namerr1s r*cleanzTrustAccount.cleansH    &&&dnnDDTDT%'LMMEU 'r)N)r$r%r&r`ENTITY_TYPE_CHOICESSTATUS_CHOICESr UUIDFielduuiduuid4 account_idr9r}raassociated_entity_typerbrcmember family_memberrrrstatusr? created_datedeactivated_daterrdr+r3rr(r)r*rfrfxs   N "!!dDJJQVWJ#6##sPL#6##r;O^lmL-V--EXgA V  FOO$d%4FF&F%%FOO$d/>WM &V%%D"[klN   CtRVabI"&""crXefK V  ^Xdl mF'6''TWL+v++TPbc""" d$-LJ // <Mr)rfceZdZdZddgZgdZejeejdZ ejdejddd d Z eje ejdddd ZejdeZej"ddZej&ZejdeZejdgddddZejdddZejddddZejdddZejdejdddd Zej6ddd !Zej6ddd"!ZejdddZejdddd#Zej6dd$Z ej6ddd%!Z!ejdddZ"ejFd&dd'Z$eje%ejd(Z&ejNd)*Z(ejd+ejRddd,Z*ejVe,d-Z-ej\d.Z/ej\d/Z0Gd0d1Z1d2Z2d3Z3fd4Z4xZ5S)5AccountTransactionu A single financial transaction — either Debit or Credit. See module docstring for soft-delete and audit-log rationale. )DEBITDebit)CREDITCredit)rg) Bank Transferr)UPIr)Chequer)rrrj) Journal Entryr transactionsr zmembers.TaxMasterTaccounting_transactionsz2Link to the tax event this transaction relates to.)r rrr help_textr~ru rr ) max_digitsdecimal_placesr))Goldr)Silverr)OtherrrzCommodity TyperIr)rrrzDonor Name (Tamil)r2rsdonation_transactionsz3Link to registered member if the donor is a member.zPurpose / RemarksrGzPurpose / Remarks (Tamil)zPaid To (Tamil)rFzPurpose/Description (Tamil)ztransaction_proofs/ upload_torrentered_transactionsFrQReceiptrS)rrrr ceZdZddgZdZdZy)AccountTransaction.Metaz-transaction_daterVzAccount TransactionzAccount TransactionsNrWr(r)r*r+rs'7, 4r)r+cn|jd|jd|jjS)Nu ₹u — )get_transaction_type_displayamount account_headr/r1s r*r3zAccountTransaction.__str__s=00234 }E$$))* , r)ci}|j|jdkrd|d<|jr4|jtjj kDrd|d<|j sH|j r< tjj|j }|jsd|d <|r t|y#tj$rd |d <Y(wxYw) zModel-level validation.Nrz!Amount must be greater than zero.rz)Transaction date cannot be in the future.transaction_datepkz=Cannot create a transaction under a deactivated Account Head.rzAccount Head does not exist.) rrrnowdateraccount_head_idrCobjectsgetr> DoesNotExistr)r2errorsheads r*rzAccountTransaction.clean%s ;; "t{{a'7BF8   T%:%:X\\^=P=P=R%R)TF% &ww4// H"**..$2F2F.G~~(>* !&) ) ++ H)G~& Hs<;CC C c|j|jdu}d}d}|sC tjj |j}|j }|j }t|$|i||r-||j k7s||j k7rddl m }||||j r$ddl m }||j |j yy#tj$rYwxYw)Nr)recalculate_member_financials) full_cleanrrrrrrrsupersaveutilsr) r2argskwargsis_new orig_member orig_dateorigr __class__s r*rzAccountTransaction.save:s D   )11555A"kk  11   d%f% K4;;6)tG\G\:\ < )+y A ;; < )$++t7L7L M &22  sACC.-C.)6r$r%r&r4TRANSACTION_TYPE_CHOICESPAYMENT_MODE_CHOICESrrbrCPROTECTrrc tax_eventrf trust_accountr9transaction_type DecimalFieldr DateFieldr payment_modecommodity_type donor_name donor_name_ta donor_contactrr\purpose purpose_tapaid_to paid_to_tapurpose_descriptionpurpose_description_tabill_reference FileFieldproof_documentr entered_byr= is_deletedr7receipt_number JSONFieldlist change_logr?r@rAr+r3rr __classcell__rs@r*rrs   %6$$v~~#L"!!v ,EFI &F%% N$M (v''7!V Bq AF'v'')#6##3L&V%%[B-=N "!!SbIJ$F$$4ZnoM$F$$$KM V  FOO ,CGF fB(G"!!B0J f#T2FG!!!SbWhiJ*&**rB-V--D"Spq%V%%D"MN&V%%'t$N #"" +J %$$U3J&V&&V^^ #N"!!$d;J%%%48J%%%t4J55  **NNr)rceZdZdZej dddZddgZej ded d Zejd ejddd dZ ej ddddZ ej ddddZ ejdddZej ej$dZejeej*ddZej dej0dd Zej4d Zej8d!dd"ZGd#d$Zd%Zfd&Z e!d)d'Z"e#d*d(Z$xZ%S)+raa Receipt generated for a member's payment, broken down across multiple AccountTransactions. receipt_number is sequential, FISCAL-year scoped, and NEVER reused. Format: / e.g. 2026-27/00001 Fiscal year runs April-March: 1-Apr-2026 to 31-Mar-2027 -> "2026-27" 1-Apr-2025 to 31-Mar-2026 -> "2025-26" TF)rrrq)Taxuகொடை வரி (Tax))Seethanau&சீதன வரி (Seethana Vari)rrz Receipt TyperPrsreceiptszMember / Family Headrurrz Donor Namerz Father Namerrz Total Amount)rrrz Receipt Datercreated_receiptsrz)r rrrhz Payment Moderz receipts/rceZdZdgZdZdZy) Receipt.Metaz -generated_atrReceiptsNrWr(r)r*r+rs#$ (r)r+c|jSrZ)rr1s r*r3zReceipt.__str__s"""r)c||js |j|j|_t||i|yrZ)rgenerate_receipt_number receipt_typerr)r2rrrs r*rz Receipt.saves6"""&">">t?P?P"QD   d%f%r)c|tj}|jdk\r |jn|jdz }t |dzdd}|d|S)z Return the fiscal-year label for *dt* (defaults to now). April-March cycle: 1-Apr-2026 to 31-Mar-2027 -> "2026-27" Nr-)rrmonthyearstr)dtstart end_shorts r*_fiscal_year_stringzReceipt._fiscal_year_stringsV :B88q=bggk N23' )%%r)c ddlm}|j}|dk(r'|jd}|dddd|d}|d}n|d }|j 5|j j d j| jd j}|r, t|jjd ddz}nd}||dcdddS#ttf$rd}Y#wxYw#1swYyxYw)a Atomically generate the next sequential receipt number for the current fiscal year (April-March). Uses SELECT ... FOR UPDATE on the last receipt row so that two concurrent transaction saves cannot read the same sequence value and produce a duplicate. The unique=True DB constraint remains as a last-resort safety net. Format: / Seethana Format: -S/ r) transactionrrrNrz-S//F)nowait)receipt_number__startswithz-receipt_number05d) django.dbrrsplitatomicrselect_for_updatefilterorder_byfirstintr ValueError IndexError) clsrdb_transaction fiscal_yearpartsyy_yyprefixlastseqs r*rzReceipt.generate_receipt_numbers! <--/ : %%%c*EQx}oQuQxj1Ewc]F#}A&F  " " $ ( ""%"06:+, d1177$6##3U#LV  FOO$d+F "!!SbWcdJ"&""crXefK&6&&a#L$6## #L#"" '!J $6##"77# L (6''T:LvTH)) #&  & &)()(r)rc4eZdZdZgdZej deZej dZej dZ ejddZ eje ejdd Zej d ZGd d Zd Zy)AuditLogzq Centralized log for all critical operations (Create, Update, Delete) particularly for transactions. ))CREATECreate)UPDATEUpdate)DELETEDeleterrrw)rT)rr)r rrrceZdZdgZdZdZy) AuditLog.Metaz -timestampz Audit Logz Audit LogsNrWr(r)r*r+r-s >" *r)r+cl|jd|jd|jd|jS)N z #z at )action model_name record_id timestampr1s r*r3zAuditLog.__str__s2++a04>>2B$t~~FVWWr)N)r$r%r&r4ACTION_CHOICESrr9r0r1r2rchangesrbrrc performed_byr?r3r+r3r(r)r*r%r%sN V  ^ DF!!!S1J   C0IfT5G$6$$TV__4W[\L$$$$7I++ Xr)r%)r4r rdjango.contrib.auth.modelsrdjango.core.exceptionsr django.utilsrModelrrCrrfrrr%r(r)r*r;s +2! :6<< :N-&,,-h 5M6<<5Mx]N]NHz(fllz(@Xv||Xr)