U - iJ@s|ddlmZmZddlmZddlmZmZddlmZm Z ddl Z ddl Z e j ej ejfdZddZd d Zd d ZdS) )requestjsonify)closing)connect_to_databaseConfig)datetime timedeltaN)authc CsZt}dddg}|D](}||krtd|dddfSqt}zzt|jdd}|d |df|}|std ddd fW5QRWWS|d d krtddddfW5QRWWvS|d|d|d|d| d| df|d|df|dp(d}||dkr|d|df| dr| ddkrz|d|dfnHt }|t dd|t ddd |d}|d||||df| td d!dd"fW5QRWW`SQRXWnPtk rF} z0|td#t| ddd$fWYWSd} ~ XYnXW5|XdS)%N invoice_idamountZpayment_methodMissing required field: Tmessageerror dictionarya SELECT i.id, i.total_amount, i.status, i.subscription_id, s.package_id, s.user_id, s.billing_cycle FROM invoices i LEFT JOIN subscriptions s ON i.subscription_id = s.id WHERE i.id = %s zInvoice not foundstatuspaidzInvoice already paidz INSERT INTO payments ( invoice_id, amount, payment_method, transaction_id, status, gateway_response ) VALUES (%s, %s, %s, %s, 'completed', %s) Ztransaction_idZgateway_responsez SELECT SUM(amount) as paid_amount FROM payments WHERE invoice_id = %s AND status = 'completed' paid_amountr total_amountzW UPDATE invoices SET status = 'paid' WHERE id = %s subscription_id billing_cyclelifetimez UPDATE subscriptions SET status = 'active', end_date = NULL WHERE id = %s daysm)monthlyannuala? UPDATE subscriptions SET status = 'active', start_date = %s, end_date = %s, next_billing_date = %s WHERE id = %s zPayment recorded successfullyFzError recording payment: )rget_jsonrrclosercursorexecutefetchonegetrnowrcommit Exceptionrollbackstr) datarequired_fieldsfield connectionr%invoicer start_dateend_dateer67/var/www/html/api-medvista/Services/Billing/Payments.pyrecord_payment sr & &     :r8c Cst}dg}|D](}||krtd|dddfSqt}zzJt|jdd.}|d|df|}|stdddd fW5QRWWHSt t |d d }||d d |dd|d| d| drdnddd}| dr|d| dd|d<t j j|d}|d|d|df|td|dtj|d |d | ddddd fW5QRWW`SQRXWnPtk r} z0|td!t| ddd"fWYWSd} ~ XYnXW5|XdS)#Nr r Tr rram SELECT i.id, i.total_amount, i.currency_id, i.subscription_id, s.billing_cycle, p.package_name FROM invoices i LEFT JOIN subscriptions s ON i.subscription_id = s.id LEFT JOIN packages p ON s.package_id = p.id WHERE i.id = %s AND i.status = 'unpaid' zUnpaid invoice not foundrrd currency_idZinvoice_r subscriptionzone-time)r rtype)r currencyreceiptZpayment_capturenotesZcustomer_emailZ customer_name)emailnamecustomer)r.z UPDATE invoices SET gateway_order_id = %s, gateway_type = 'razorpay' WHERE id = %s idzRazorpay order created package_namezInvoice PaymentF)rorder_id razorpay_keyr r> product_namerr!zError creating Razorpay order: r")rr#rrr$rr%r&r'intfloatr(clientordercreater*rRAZORPAY_KEY_IDr+r,r-) r.r/r0r1r%r2Zamount_in_paiseZ order_datarazorpay_orderr5r6r6r7create_razorpay_orderjs`&     :rPcCsHt}dddg}|D](}||krtd|dddfSqt}zzR|jdd:}|d |d|df|}|std ddd fW5QRWWS|d |dk}zJ|rtj |d|d|dd n tj |d|d|ddWn@t j jk rBtddddfYW5QRWWSX|r2tj|d}td|d|d}|dkrtj|d} |d|d|dt| dd| d|ddt| dit| f|j} |d|dft} |ddkr0| tdd} |d | | | |d!fnJ|dd"krf| td#d} |d | | | |d!fn|d$| |d!f|td%|| d&d'd(fW5QRWWS|d)kr|d*|df|td+||dd,dfW5QRWW8Std-|d.|d&d,d(fW5QRWWSn`tj|d} | d} |d/|d|dt| dd| d|d| t| dit| f|j} | d0krB|d|dft} |ddkr| tdd} |d1| | | |d!fnJ|dd"kr,| td#d} |d1| | | |d!fn|d2| |d!fn| d3kr^|d*|df|td4| | | d0kd5d(fW5QRWWSW5QRXWnt j jk rtd6dddfYWhStk r.}zB|td7t|td8t|ddd9fWYWSd:}~XYnXW5|rB|Xd:S);z^ SECURE payment verification - verifies subscription status instead of payment status payment_idrF signaturezMissing field: Tr rra SELECT s.id AS subscription_id, s.billing_cycle, s.user_id, s.razorpay_subscription_id, i.id AS invoice_id, i.total_amount AS amount, i.status AS invoice_status FROM subscriptions s LEFT JOIN invoices i ON s.id = i.subscription_id WHERE (s.razorpay_subscription_id = %s OR i.gateway_order_id = %s) AND i.status IN ('draft', 'pending', 'unpaid') ORDER BY i.created_at DESC LIMIT 1 z*No pending invoice found for this payment.rrazorpay_subscription_id)razorpay_payment_idrSrazorpay_signature)rTrazorpay_order_idrUzInvalid payment signature.zSubscription Status: r) authenticatedactiveaT INSERT INTO payments ( invoice_id, user_id, amount, payment_method, transaction_id, payment_date, status, acquirer_data, razorpay_payment ) VALUES (%s, %s, %s, %s, %s, NOW(), %s, %s, %s) r user_idr r9method completedZ acquirer_datazx UPDATE invoices SET status = 'paid' WHERE id = %s rrrra9 UPDATE subscriptions SET status='active', start_date=%s, end_date=%s, next_billing_date=%s WHERE id = %s rr ra= UPDATE subscriptions SET status='active', start_date=%s, end_date=NULL, next_billing_date=NULL WHERE id = %s z1Subscription verified and activated successfully.F)rsubscription_statusrQr) cancelledexpiredza UPDATE invoices SET status = 'failed' WHERE id = %s zSubscription is )rr\rzSubscription is in z statea< INSERT INTO payments ( invoice_id, user_id, amount, payment_method, transaction_id, payment_date, status, acquirer_data, razorpay_payment ) VALUES (%s, %s, %s, %s, %s, NOW(), %s, %s, %s) )capturedZ authorizedz UPDATE subscriptions SET status='active', start_date=%s, end_date=%s, next_billing_date=%s WHERE id = %s z UPDATE subscriptions SET status='active', start_date=%s, end_date=NULL, next_billing_date=NULL WHERE id = %s )failedr^zPayment verified and recorded.)rpayment_statusrQrzInvalid signature.zPayment verification error: zVerification failed: r"N)rr#rrr$r%r&r'rKutility%verify_subscription_payment_signatureverify_payment_signaturerazorpayerrorsSignatureVerificationErrorr<fetchprintpaymentrJjsondumpsr( lastrowidrr)rr*r+r,r-)r.r/r0r1r%subscription_dataZis_subscriptionZsubscription_detailsr\Zpayment_detailsrQr3r4rbr5r6r6r7verify_payment_directlys" &  ,          $:rp)flaskrr contextlibrconfrrrrrfrlClientrNRAZORPAY_KEY_SECRETrKr8rPrpr6r6r6r7s _L