U - i @s\ddlmZmZmZddlmZddlmZddlmZddl Z ddl Z ddZ dd Z dS) )requestjsonify current_app)closing)connect_to_database)datetimeNcCs,tjd}t|d|tj}||kS)NRAZORPAY_WEBHOOK_SECRETzutf-8)rconfighmacnewencodehashlibsha256 hexdigest)payload signaturesecretgenerated_signaturer7/var/www/html/api-medvista/Services/Billing/Webhooks.pyverify_webhook_signatures rc Cstj}tjd}t||s.tddddfSt}|d}t}zzTt |j dd8}|dkrj|d d d d }|d d d d }t |d d d dd}| d|f| rtddddfW5QRWWS| d|f| } | s,tddddfW5QRWWS| d| d ||tt|f| d| d f|n |dkrttddddfW5QRWWfSQRXWnVtk r} z6|r|tdt| dddfWYWSd} ~ XYnXW5|r |XdS)NzX-Razorpay-SignaturezInvalid webhook signatureT)messageerrorievent) dictionaryzpayment.capturedrpaymententityidorder_idamountdzl SELECT id FROM payments WHERE transaction_id = %s zPayment already processedFz SELECT id, total_amount FROM invoices WHERE gateway_order_id = %s zInvoice not foundia+ INSERT INTO payments ( invoice_id, amount, payment_method, transaction_id, payment_date, status, gateway_response ) VALUES (%s, %s, 'razorpay', %s, %s, 'completed', %s) zW UPDATE invoices SET status = 'paid' WHERE id = %s zrefund.processedzWebhook processedzError processing webhook: i)rdataheadersgetrrget_jsonrclosercursorfloatexecutefetchonernowstrcommit Exceptionrollback) rrZ webhook_data event_type connectionr' payment_idrrinvoiceerrrhandle_razorpay_webhooksX    &$  .:r5) flaskrrr contextlibrconfrrr r rr5rrrrs