o Ў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_signaturerS/Users/harjaapdhillon/Desktop/newidea/medvista_backend/Services/Billing/Webhooks.pyverify_webhook_signatures rc CsTtj}tjd}t||stddddfSt}|d}t}zzt|j dd}|dkr|d d d d }|d d d d }t |d d d dd}| d|f| rxtddddfWdWW|rw| SS| d|f| } | stddddfWdWW|r| SS| d| d ||tt|f| d| d f|n|dkr tddddfWdWW|r| SS1swYWn0ty} z#|r|tdt| dddfWYd} ~ W|r| SSd} ~ wwW|r| dSdS|r)| ww)NzX-Razorpay-SignaturezInvalid webhook signatureT)messageerrorievent) dictionaryzpayment.capturedrpaymentZentityidorder_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_jsonrrcursorfloatexecutefetchoneclosernowstrcommit Exceptionrollback) rrZ webhook_dataZ event_type connectionr% payment_idrrinvoiceerrrhandle_razorpay_webhooks   = =  = 8( =  r3) flaskrrr contextlibrconfrrr r rr3rrrrs