o rPh@sZddlmZddlmZddlmZmZddlmZddl Z e e Z GdddeZ dS)) BaseCommand)timezone)PaymentUnreconciledPayment)CustomerNc@s8eZdZdZddZddZddZdd Zd d Zd S) Commandz?Find and reconcile paybill payments that might have been missedcCsf|jdtddd|jdtdd|jdtd d|jd td d|jd td d|jdddddS)Nz --days-backz6Number of days to look back for payments (default: 30))typedefaulthelpz--transaction-idz+Specific M-Pesa transaction ID to reconcile)r r z --customer-idz%Customer ID for manual reconciliationz--amountz,Transaction amount for manual reconciliationz--phonez/Customer phone number for manual reconciliationz--create-unreconciled store_truez3Create unreconciled payment record for manual entry)actionr ) add_argumentintstrfloat)selfparserrW/var/www/html/optinet_system/payments/management/commands/reconcile_paybill_payments.py add_arguments s> zCommand.add_argumentscOs:|dr ||dS|dr||dS||dS)Ncreate_unreconciledtransaction_id)"create_manual_unreconciled_paymentreconcile_specific_transactionscan_for_missing_payments)rargsoptionsrrrhandle.s zCommand.handlec Cst|d|d|dgs|j|jddSztjj|dd}|r8|j|j d|j WdSt jj|dd}|rV|j|j d |j WdSt jj |d|d|d|d d td d ddd }|j|jd|j |jd|d|jd|d|jd|d|jdWdSty}z|j|jdt|WYd}~dSd}~ww)z.Create an unreconciled payment record manuallyramountphonezKFor manual entry, you must provide: --transaction-id, --amount, and --phoneNmpesa_receipt_numberPayment already exists: )rz%Unreconciled payment already exists: customer_id MANUAL_ENTRYManualEntryaccount_not_foundz%Manually created unreconciled payment) r phone_numberraccount_referencetransaction_time first_name last_namereasonnoteszCreated unreconciled payment: zTransaction ID: Amount: KES zPhone: z5 You can now resolve this payment in the admin panel.z%Error creating unreconciled payment: )allstdoutwritestyleERRORrobjectsfilterfirstWARNING payment_idridcreategetrnowSUCCESS Exceptionr)rrexisting_paymentexisting_unreconciled unreconcilederrrr6sd   z*Command.create_manual_unreconciled_paymentc Cs|d}|d}|s|j|jddSztjj|d}|s3|j|jd|WdSt jj|d}|rO|j|j d|j WdS|d }|sc|j|jd WdSt jj ||d d ||d dd|dt d }ddlm}|j||d||j dd|j|jd|jd|j |jd|jd|j|jd|WdSty} z|j|jdt| WYd} ~ dSd} ~ ww)z Reconcile a specific transactionrr$zFYou must provide --customer-id for specific transaction reconciliationN)r$zCustomer not found: r!r#rz,You must provide --amount for reconciliationmpesa completedr zMANUAL-z#Manually reconciled paybill payment) customerrpayment_methodstatusr"mpesa_phone_numberreference_numberr/ completed_atr)CustomerBalanceServicez'Manual M-Pesa payment reconciliation - )rHr description reference_id processed_byz Payment reconciled successfully!z Payment ID: z Customer: z - r0zError reconciling payment: )r=r2r3r4r5rr6r7r8rr9r:r<rr>customers.servicesrN add_balancer?r$ display_namer@r) rrrr$rHexistingrpaymentrNrDrrrrnsz       z&Command.reconcile_specific_transactioncCs|d}|jd|dtjjdttj|dd}|jd|d|d kr@|jd |jd |jd |jd |jd|jd|jddS)z-Scan for potentially missing paybill payments days_backz2Scanning for missing paybill payments in the last z days...pending)days)rJcreated_at__gtezFound z unreconciled paymentsrz& To view unreconciled payments, visit:z.Admin Panel > Payments > Unreconciled Paymentsz!Or go to: /payments/unreconciled/z# To manually add a missing payment:zpython manage.py reconcile_paybill_payments --create-unreconciled --transaction-id=XXXXXXXX --amount=1000 --phone=254712345678 --customer-id=OPT000001z% To reconcile a specific transaction:zkpython manage.py reconcile_paybill_payments --transaction-id=XXXXXXXX --customer-id=OPT000001 --amount=1000N) r2r3rr6r7rr> timedeltacount)rrrWunreconciled_countrrrrs"      z!Command.scan_for_missing_paymentsN) __name__ __module__ __qualname__r rrrrrrrrrr s!8 Jr)django.core.management.baser django.utilsrpayments.modelsrrcustomers.modelsrlogging getLoggerr^loggerrrrrrs