o Hh@s\ddlmZddlmZddlmZddlmZmZddl m Z ddl Z GdddeZ dS) ) BaseCommand)timezone)Decimal)PaymentUnreconciledPayment)CustomerNc@s eZdZdZddZddZdS)Commandz3Find payments that should be marked as unreconciledcCs&|jdddd|jdtddddS) Nz--create-missing store_truezHCreate unreconciled payment records for payments without valid customers)actionhelpz--daysz)Number of days to look back (default: 30))typedefaultr ) add_argumentint)selfparserrW/var/www/html/optinet_system/payments/management/commands/find_unreconciled_payments.py add_arguments s zCommand.add_argumentsc Os|d}|d}t}|tj|d}|jd|d|g}tjjd||d}|D]} g} | j s@| j s@| d| j rZz | j } | j sO| d Wn | d Y| j ry| j j ryz| j j } | j sn| d Wn | d Y| j rz8| j } t| trt| } d} d | vr| d } | rz tjj| dWntjy| d| dYnwWnty}z| d|WYd}~nd}~ww| r| | | dq1tjj||d}|jdt|d|jd||D]}|d} |d} |jd| j|jd| j|jd| j|jd| j|jdd| |rtjj| jd}|s| jrd } | jpTd!}| j rz"| j } t| trht| } d | vrq| d } d"| vrz| d"}WnYtjj | j|| j| | j!p| jd#d$d| | j d%}|jd&|j"q|r|jd'|j"q|jd(q|s|jd)|jd*dS)+Ncreate_missingdays)rzChecking payments from z to mpesa)payment_methodcreated_at__gtecreated_at__ltezNo customer or invoice linkedzCustomer has no customer_idzCustomer relationship brokenz#Invoice customer has no customer_idz$Invoice customer relationship broken BillRefNumber) customer_idzAccount reference 'z ' not foundzError parsing callback data: )paymentissues)rrz Found z" potentially unreconciled paymentsz'Existing unreconciled payment records: rrz Payment ID: z Amount: KES zDate: z Receipt: zIssues: z, )transaction_idUNKNOWNMSISDN system_errorz,Auto-created from existing payment. Issues: )r phone_numberamountaccount_referencetransaction_timereasonnotes callback_datau+ → Created unreconciled payment record: u+ → Unreconciled payment already exists: u: → No receipt number, cannot create unreconciled recordzB To create unreconciled payment records, run with --create-missingz Done!)#rnow timedeltastdoutwritedaterobjectsfiltercustomerinvoiceappendrmpesa_callback_data isinstancestrjsonloadsrget DoesNotExist Exceptionrcountlen payment_idr& created_atmpesa_receipt_numberjoinfirstmpesa_phone_numbercreate completed_atid)rargsoptionsr days_backend_date start_dateproblematic_paymentsmpesa_paymentsrrr3r+ account_refeexisting_unreconcileditemexistingphone unreconciledrrrhandles                  zCommand.handleN)__name__ __module__ __qualname__r rrWrrrrr s r) django.core.management.baser django.utilsrdecimalrpayments.modelsrrcustomers.modelsrr9rrrrrs