o 'h&w@sHddlmZmZmZddlmZddlmZddlm Z ddl m Z m Z ddl mZddlmZddlmZdd lmZdd lmZmZdd lmZdd lmZd dlmZmZddlmZddl m!Z!ddl"Z"ddl#Z#ddl$m%Z%m&Z&m'Z'm(Z(m)Z)e#*e+Z,Gdddee Z-eddZ.eddZ/eddZ0eddZ1eddZ2edd Z3ed!d"Z4ed#d$Z5eed%gd&d'Z6eed%gd(d)Z7eed%gd*d+Z8eed%gd,d-Z9eed%gd.d/Z:eed%gd0d1Z;eed%gd2d3Zed8d9Z?ed:d;Z@dS)<)renderget_object_or_404redirect)login_required)LoginRequiredMixin)ListView) JsonResponse HttpResponse) csrf_exempt)require_http_methods)messages) Paginator)QSum)modelstimezone)PaymentUnreconciledPaymentCustomer)InvoiceN)has_financial_accessEmployeeRequiredMixinCustomerRequiredMixinhas_permissionget_user_permissionscs4eZdZeZdZdZdZddZfddZ Z S)PaymentListViewzpayments/payment_list.htmlpaymentscCsztjddd}|jjd}|r,|t |dt |dBt |dBt |dB}|jjd }|r;|j|d }|S) Ncustomerinvoice -created_atsearch)payment_id__icontains)customer__first_name__icontains)customer__last_name__icontains)mpesa_receipt_number__icontainsstatusr)) robjectsselect_relatedprefetch_relatedorder_byrequestGETgetfilterr)selfqueryset search_query status_filterr7./var/www/html/optinet_system/payments/views.py get_queryset#s  zPaymentListView.get_querysetc sztjd i|}|jjdd|d<|jjdd|d<tj|d<|}||d<|j t dd d p8d |d <|S)Nr$r5r)r6status_choicestotal_paymentsamount)totalr>r total_amountr7) superget_context_datar/r0r1rSTATUS_CHOICESr9count aggregaterr)r3kwargscontextr4 __class__r7r8rA7s  z PaymentListView.get_context_data) __name__ __module__ __qualname__rmodel template_namecontext_object_name paginate_byr9rA __classcell__r7r7rGr8rsrcCsjt|dst|dtdS|jdkrt|dtdStj}t jj dd}||d}t |d |S) zCreate a new payment recordcreate_paymentz.You do not have permission to create payments.payments:payment_listPOSTzPayment created successfully.sentr*) customersinvoicespayments/payment_form.html rr errorrmethodsuccessrr+allrr2rr/rUrVrFr7r7r8rQGs      rQcCslt|dst|dtdS|jdkrt|dtdStj}t jj dd}||dd }t |d |S) zRecord a cash paymentrecord_cash_paymentz3You do not have permission to record cash payments.rRrSz#Cash payment recorded successfully.rTr*cash)rUrV payment_typerWrXr]r7r7r8r^]s      r^c CsPt|ds tdddS|jdkr!zddl}||j}|d}|d d }|d d }|d d }|r>|r>|sFtdddWSzddlm }|j j|d}Wn|j ygtdddYWSwzt |} | dksu| dkr~tdddWWSWnt ytdddYWSwddlm} | } | j|t| |j|d} | ddkrddlm} | j j| d| dd | ||j|dtdd| dd WS| d!| d"d#}tdd$|dWS|jytdd%dYSty }ztd&t|tdd't|dWYd}~Sd}~wwtdd(dS))z%Initiate M-Pesa STK Push for customerinitiate_stk_pushF0You do not have permission to initiate STK push.)r[messagerSrN customer_id phone_numberr:r= descriptionzAccount Top-upz=Missing required fields: customer_id, phone_number, or amountridzCustomer not foundripz+Amount must be between KES 1 and KES 70,000zInvalid amount format) MpesaService)rer=account_referencetransaction_desc ResponseCode0MpesaTransactionCheckoutRequestIDMerchantRequestID)checkout_request_idmerchant_request_idr=rerjrkTzQSTK Push sent successfully! Customer should receive M-Pesa prompt on their phone.)r[rcrr errorMessageResponseDescriptionz Unknown errorz Failed to send STK Push. Error: zInvalid JSON datazSTK Push error: zError processing STK Push: Invalid request method)rrrZjsonloadsbodyr1stripcustomers.modelsrr+ DoesNotExistfloat ValueErrorpayments.servicesristk_pushintrdpayments.modelsrocreateJSONDecodeError ExceptionloggerrYstr)r/rwdatardrer=rfrr! amount_floatri mpesa_serviceresponsero error_messageer7r7r8customer_stk_pushts                  rcCs>t|ds tdddS|jdkrtdddStdddS) zInitiate M-Pesa STK PushrarYrbr)rcrSr[zSTK Push initiatedrv)rrrZr/r7r7r8mpesa_stk_pushs  rcCs&t|ds tdddStdddS)zCheck M-Pesa account balancecheck_mpesa_balancerYz3You do not have permission to check M-Pesa balance.rr[z0.00)r)balancerrrr7r7r8r rcCs&t|ds tdddStdgdS)zGet M-Pesa balance historyview_mpesa_balance_historyrYz:You do not have permission to view M-Pesa balance history.rr[)r)historyrrr7r7r8get_mpesa_balance_historyrrcCst|dst|dtdStjjddd}|j d}|r=|t |dt |d Bt |d Bt |d Bt |d B}|j d }|rK|j|d}t |d}|j d}| |}|||tj d}t|d|S)zList unreconciled paymentsview_unreconciled_paymentsz9You do not have permission to view unreconciled payments.zdashboard:homependingr*z-transaction_timer$)transaction_id__icontains)phone_number__icontains)account_reference__icontainsfirst_name__icontainslast_name__icontainsr)r page)unreconciled_paymentsr5r6r;z#payments/unreconciled_payments.html)rr rYrrr+r2r.r0r1rr get_pagerBr)r/rr5r6 paginator page_numberpage_objrFr7r7r8unreconciled_payments_lists:         rcCst|dst|dtdStt|d}|jdkr4d|_|j|_ t |_ | t|dtdStjt|jdt|jd Bt|jd B}||d }t|d |S) zResolve an unreconciled paymentresolve_unreconciled_paymentzdWSty)}ztd?t|tdd@dWYd}~Sd}~ww)AzHandle M-Pesa STK callbackprocess_mpesa_callbackz1Permission denied for M-Pesa callback processing.rPermission Denied ResultCode ResultDesczM-Pesa callback received: indentBody stkCallbackrrprCallbackMetadataItemNameValueAmountMpesaReceiptNumberr: PhoneNumberTransactionDateNrn)rrrdFound customer z from STK account referencezNo customer found with ID: z2No STK transaction found for checkout_request_id: z(Falling back to phone number matching...254rm++254rz with phone format: zError finding customer: mpesa completedzSTK-zSTK Push payment - r!r=payment_methodr)mpesa_receipt_numbermpesa_phone_numbermpesa_callback_datareference_numbernotes completed_atCustomerBalanceServicezM-Pesa payment - r!r=rf reference_id processed_byz*Payment created successfully for customer : KES z$Error creating payment for customer : rUnknownzSTK Pushaccount_not_found) transaction_idrer=rjtransaction_timerrreason callback_datazCustomer not found for phone z,, created unreconciled payment with receipt z%Error creating unreconciled payment: z!STK Push failed with result code SuccesszM-Pesa callback error: Error)!rrwarningrrwrxryinfodumpsr1rror+r2firstrjrrd startswithappendrrYrrrrrcustomers.servicesr add_balancer django.utilsr)r/rr result_coderrcallback_metadataritemnamevaluer=rretransaction_dater!rompesa_transaction phone_formats phone_formatrrr payment_errordjango_timezoneunreconciled_errorr7r7r8mpesa_callback<s                        rc Cst|dstdtdddSzt|j}tdtj|dd| d d }| d d }| d d }| dd }| dd }| dd }| dd }| dd } | dd } | dd } | dd } | dd } |rr|stdtdddWSd}|rz{t j j |d }|s| g}| dr|d| dd|d| n5| dr|d| dd|d| ddn| dr|| dd|d| d d|D]}t j j |d! }|rtd"|jd#|nqWnty}ztd$t|WYd}~nd}~ww|rzt|dst|dtdStt|d}d|i}t|d|S)zGenerate payment receiptview_payment_receiptz4You do not have permission to view payment receipts.rRrrzpayments/payment_receipt.htmlrr rYrrrrr/rrrFr7r7r8payment_receipt    r1cCr,)zView payment detailsview_payment_detailz3You do not have permission to view payment details.rRr.rzpayments/payment_detail.htmlr/r0r7r7r8payment_detailr2r4)Adjango.shortcutsrrrdjango.contrib.auth.decoratorsrdjango.contrib.auth.mixinsrdjango.views.genericr django.httprr django.views.decorators.csrfr django.views.decorators.httpr django.contribr django.core.paginatorr django.db.modelsrr django.dbrrrrrr{rbilling.modelsrrwloggingaccounts.permissionsrrrrr getLoggerrIrrrQr^rrrrrrrrrr!r#r%r'r)r+r1r4r7r7r7r8s            *   `    &     v