o ÕKœhã@shddlZddlmZddlmZddlmZmZddlm Z ddl m Z ddl m Z Gdd „d eƒZdS) éN)Ú BaseCommand)Útimezone)ÚPaymentÚUnreconciledPayment)ÚCustomer)ÚSystemSettings)Ú MpesaServicec@seZdZdZdd„ZdS)ÚCommandzDebug M-Pesa payment issuesc Osš|j d¡|j d¡t ¡}gd¢}g}|D] }| |¡s$| |¡q|r>|j |j dd |¡›¡¡|j d¡n$|j |j  d¡¡|j d| d ¡›¡|j d | d d ¡›d ¡|j d¡z t ƒ}|  ¡}|r}|j |j  d¡¡n |j |j d¡¡Wn!t y©} z|j |j dt | ƒ›¡¡WYd} ~ nd} ~ ww|j d¡tjjdt ¡tjddd d¡dd…} | rñ|j d|  ¡›d¡| D]} |j d| j›d| j›d| j›d| j›¡q×n |j |j d¡¡|j d ¡tjjd!d" ¡} | d#kr$|j |j d$| ›d%¡¡|j d&¡n |j |j  d'¡¡|j d(¡tjjd)d*jd+d,} i}| D]F}|j}| d-¡rZ| d.d#¡d/|d.<qC| d0¡rl| d1d#¡d/|d1<qC| d2¡r~| d3d#¡d/|d3<qC| d4d#¡d/|d4<qC|j d5¡|  ¡D]\}}|j d|›d6|›d7¡q”|j d8¡|j d9¡|j d:¡|j d;¡|j d<¡|j d=¡dS)>Nz*=== M-Pesa Payment System Diagnostics === z#1. Checking M-Pesa Configuration...)Ú consumer_keyÚconsumer_secretÚbusiness_short_codeÚpasskeyÚ callback_urlu⌠Missing M-Pesa settings: z, z5Please configure these in Settings > System Settings u!✅ M-Pesa configuration completezCallback URL: rz Environment: Ú environmentÚsandboxÚ z%2. Testing M-Pesa API Connectivity...u$✅ M-Pesa API connection successfulu%⌠Failed to get M-Pesa access tokenu⌠M-Pesa API Error: z 3. Recent Payment Activity...Úmpesaé)Údays)Úpayment_methodÚcreated_at__gtez -created_atéu ✅ Found z recent M-Pesa payments:z - z: KES z (z) - u&âš ï¸ No recent M-Pesa payments foundz% 4. Checking Unreconciled Payments...Úpending)Ústatusruâš ï¸ z% unreconciled payments need attentionzCheck: /payments/unreconciled/u$✅ No pending unreconciled paymentsz1 5. Checking Customer Phone Format Consistency...T)Ú phone__isnullÚ)Úphonez+254Ú internationaléÚ254Ú country_codeÚ0ÚlocalÚotherz!Phone number formats in database:z: z customersz === Diagnostics Complete ===z"If payments are still not working:z/1. Check server logs for M-Pesa callback errorsz-2. Verify callback URL is publicly accessiblez33. Test STK push with a known customer phone numberz54. Check /payments/unreconciled/ for pending payments)!ÚstdoutÚwriterÚget_mpesa_settingsÚgetÚappendÚstyleÚERRORÚjoinÚSUCCESSrÚget_access_tokenÚ ExceptionÚstrrÚobjectsÚfilterrÚnowÚ timedeltaÚorder_byÚcountÚ payment_idÚamountrÚ created_atÚWARNINGrrÚexcluderÚ startswithÚitems)ÚselfÚargsÚoptionsÚmpesa_settingsÚrequired_settingsÚmissing_settingsÚsettingÚ mpesa_serviceÚ access_tokenÚeÚrecent_paymentsÚpaymentÚ unreconciledÚcustomers_with_phonesÚ phone_formatsÚcustomerrÚ format_typer5©rNúQ/var/www/html/optinet_system/payments/management/commands/debug_mpesa_payments.pyÚhandle s†    €  €*€ÿ þ ý.ÿ            zCommand.handleN)Ú__name__Ú __module__Ú __qualname__ÚhelprPrNrNrNrOr s r )ÚjsonÚdjango.core.management.baserÚ django.utilsrÚpayments.modelsrrÚcustomers.modelsrÚsettings.modelsrÚpayments.servicesrr rNrNrNrOÚs