CRITICAL - 2025-08-18 10:26:57 --> Call to undefined method CodeIgniter\Session\Session::unset() in APPPATH/Controllers/Auth.php on line 96. 1 SYSTEMPATH/CodeIgniter.php(927): App\Controllers\Auth->loadAdminLoginOtp() 2 SYSTEMPATH/CodeIgniter.php(482): CodeIgniter\CodeIgniter->runController() 3 SYSTEMPATH/CodeIgniter.php(351): CodeIgniter\CodeIgniter->handleRequest() 4 FCPATH/index.php(67): CodeIgniter\CodeIgniter->run() ERROR - 2025-08-18 10:52:38 --> Config Data Array ( [0] => Array ( [id] => 5 [service] => de [partner] => d [sub_partner] => RAZORPAY [config] => {"key_id":"K3ZZODd0Ky92bENtdmVnUEhOa1l1UT09","secret_key":"Q2YxZ01RWlVsa2dEbGhnTUppNFV3UT09","base_url":"K3ZZODd0Ky92bENtdmVnUEhOa1l1UT09","salt":"K3ZZODd0Ky92bENtdmVnUEhOa1l1UT09","mode":"K3ZZODd0Ky92bENtdmVnUEhOa1l1UT09","public_key":"K3ZZODd0Ky92bENtdmVnUEhOa1l1UT09"} ) [1] => Array ( [id] => 4 [service] => pg [partner] => razorpay [sub_partner] => razorpay [config] => {"key_id":"Vy9KTC9UV05RWmRGTUN2UHBhZWs5bTlDREl0alI4aTBXV2RPMlk4ckpLQT0=","secret_key":"bkRBMVRVaWVDTng3NmJMVHNndkJiMnM3NFlwZEJhSy9EZEpYb2hpSjcraz0=","base_url":"OHNGVkF1Y2xucTMvQzFESm40djFSOXVmQkZJZ1Q1ZE1ES05ZTFhPUXNmND0=","salt":"","mode":"","public_key":"eFhpZXFTZGo5RllrMnJKeU9JcHVEWFRHVytuWWZ3Rk5kNE9VenVpY1prMD0="} ) [2] => Array ( [id] => 1 [service] => pg [partner] => cashfree [sub_partner] => cashfree [config] => {"key_id":"102212e67e7888beb8005b2b94212201","secret_key":"4fa31e64c2752981f772f46229632c93c2c877a2","base_url":"https://sandbox.cashfree.com/","salt":"","mode":"","public_key":""} ) ) ERROR - 2025-08-18 10:52:38 --> Config Decode K3ZZODd0Ky92bENtdmVnUEhOa1l1UT09 ERROR - 2025-08-18 10:52:38 --> Config Decode Vy9KTC9UV05RWmRGTUN2UHBhZWs5bTlDREl0alI4aTBXV2RPMlk4ckpLQT0= ERROR - 2025-08-18 10:52:38 --> Config Decode 102212e67e7888beb8005b2b94212201 ERROR - 2025-08-18 14:19:11 --> Get Sql Query Live filter count Topup Report : SELECT COUNT(id) AS total_count_topup_data FROM `oz_pg_trnx_details` WHERE DATE_FORMAT(cust_txn_initiate_datetime,'%Y-%m-%d') = '2025-08-18' ERROR - 2025-08-18 14:19:11 --> Get Sql Query live filter All topup Report : SELECT `id`, `cust_id`, `order_id`, `txn_amount`, `pg_partner`, `service_charge`, `gst_amount`, `credit_amount`, `api_charge`, `api_gst`, `distributor_com`, `distributor_gst`, `distributor_tds`, `admin_com`, `paytm_txn_id`, `bank_txn_id`, `txn_currency`, `gateway_name`, `txn_bank_name`, `payment_mode`, `response_code`, `cust_txn_initiate_datetime`, `paytm_txn_datetime`, `txn_status`, `txn_status_desc`, `cust_checksum_hash`, `is_amount_settled`, `isPaymentProcessed`, `open_bal`, `close_bal`, `callback_response`, `customer_info`, `merchant_info`, `txn_mode`, `razorpay_orderid`, `last_updated_by`, `rp_response` FROM `oz_pg_trnx_details` WHERE DATE_FORMAT(cust_txn_initiate_datetime,'%Y-%m-%d') = '2025-08-18' ORDER BY `id` DESC LIMIT 10 ERROR - 2025-08-18 14:23:47 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 869 [recordsFiltered] => 869 [data] => Array ( [0] => Array ( [merchant_order_id] => order1254667893 [order_id] => 413rppabfbdc89649db732054d0498e5d7 [merchant_id] => 413 [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 16:28:30 [status] => CREATED [utrno] => ) [1] => Array ( [merchant_order_id] => GP2508140635ADBA7C [order_id] => 403rppb3ea604382bb9b12deebd3d49b0d [merchant_id] => 403 [amount] => 101 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 12:05:39 [status] => CREATED [utrno] => ) [2] => Array ( [merchant_order_id] => GP250814062784A36C [order_id] => 403rpp1ccb456fdb9b59f54d5ebc6211e9 [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 11:57:16 [status] => CREATED [utrno] => ) [3] => Array ( [merchant_order_id] => GP2508140626C68086 [order_id] => 403rpp904fa87713796857a2ef46baf233 [merchant_id] => 403 [amount] => 110 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 11:56:14 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => order1254667892 [order_id] => 413rpp3dfc805743b0fced9fd5c3e09fb4 [merchant_id] => 413 [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 20:37:03 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => GP2508131201FA8FEC [order_id] => 403rppb55e29be5374f2991137fbe7ccb8 [merchant_id] => 403 [amount] => 105 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 17:31:51 [status] => CREATED [utrno] => ) [6] => Array ( [merchant_order_id] => GP2508131159A4627D [order_id] => 403rpp6f30b623652abf27ad3d1076eb4f [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 17:29:51 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => GP25081307060CF9C1 [order_id] => 403rpp651a82ccd6834276e3f69b156988 [merchant_id] => 403 [amount] => 999 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 12:36:04 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => GP25081304511CC5E4 [order_id] => 403rppfc06757cddb6f8646b38565b31e6 [merchant_id] => 403 [amount] => 101 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 10:21:53 [status] => CREATED [utrno] => ) [9] => Array ( [merchant_order_id] => GP2508130451FECCDF [order_id] => 403rppbdf2aa1cdfeac875101c90a85124 [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 10:21:16 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2025-08-18 14:23:53 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 869 [recordsFiltered] => 869 [data] => Array ( [0] => Array ( [merchant_order_id] => order1254667893 [order_id] => 413rppabfbdc89649db732054d0498e5d7 [merchant_id] => 413 [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 16:28:30 [status] => CREATED [utrno] => ) [1] => Array ( [merchant_order_id] => GP2508140635ADBA7C [order_id] => 403rppb3ea604382bb9b12deebd3d49b0d [merchant_id] => 403 [amount] => 101 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 12:05:39 [status] => CREATED [utrno] => ) [2] => Array ( [merchant_order_id] => GP250814062784A36C [order_id] => 403rpp1ccb456fdb9b59f54d5ebc6211e9 [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 11:57:16 [status] => CREATED [utrno] => ) [3] => Array ( [merchant_order_id] => GP2508140626C68086 [order_id] => 403rpp904fa87713796857a2ef46baf233 [merchant_id] => 403 [amount] => 110 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 11:56:14 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => order1254667892 [order_id] => 413rpp3dfc805743b0fced9fd5c3e09fb4 [merchant_id] => 413 [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 20:37:03 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => GP2508131201FA8FEC [order_id] => 403rppb55e29be5374f2991137fbe7ccb8 [merchant_id] => 403 [amount] => 105 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 17:31:51 [status] => CREATED [utrno] => ) [6] => Array ( [merchant_order_id] => GP2508131159A4627D [order_id] => 403rpp6f30b623652abf27ad3d1076eb4f [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 17:29:51 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => GP25081307060CF9C1 [order_id] => 403rpp651a82ccd6834276e3f69b156988 [merchant_id] => 403 [amount] => 999 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 12:36:04 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => GP25081304511CC5E4 [order_id] => 403rppfc06757cddb6f8646b38565b31e6 [merchant_id] => 403 [amount] => 101 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 10:21:53 [status] => CREATED [utrno] => ) [9] => Array ( [merchant_order_id] => GP2508130451FECCDF [order_id] => 403rppbdf2aa1cdfeac875101c90a85124 [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 10:21:16 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2025-08-18 14:24:00 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 869 [recordsFiltered] => 869 [data] => Array ( [0] => Array ( [merchant_order_id] => order1254667893 [order_id] => 413rppabfbdc89649db732054d0498e5d7 [merchant_id] => 413 [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 16:28:30 [status] => CREATED [utrno] => ) [1] => Array ( [merchant_order_id] => GP2508140635ADBA7C [order_id] => 403rppb3ea604382bb9b12deebd3d49b0d [merchant_id] => 403 [amount] => 101 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 12:05:39 [status] => CREATED [utrno] => ) [2] => Array ( [merchant_order_id] => GP250814062784A36C [order_id] => 403rpp1ccb456fdb9b59f54d5ebc6211e9 [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 11:57:16 [status] => CREATED [utrno] => ) [3] => Array ( [merchant_order_id] => GP2508140626C68086 [order_id] => 403rpp904fa87713796857a2ef46baf233 [merchant_id] => 403 [amount] => 110 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 11:56:14 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => order1254667892 [order_id] => 413rpp3dfc805743b0fced9fd5c3e09fb4 [merchant_id] => 413 [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 20:37:03 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => GP2508131201FA8FEC [order_id] => 403rppb55e29be5374f2991137fbe7ccb8 [merchant_id] => 403 [amount] => 105 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 17:31:51 [status] => CREATED [utrno] => ) [6] => Array ( [merchant_order_id] => GP2508131159A4627D [order_id] => 403rpp6f30b623652abf27ad3d1076eb4f [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 17:29:51 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => GP25081307060CF9C1 [order_id] => 403rpp651a82ccd6834276e3f69b156988 [merchant_id] => 403 [amount] => 999 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 12:36:04 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => GP25081304511CC5E4 [order_id] => 403rppfc06757cddb6f8646b38565b31e6 [merchant_id] => 403 [amount] => 101 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 10:21:53 [status] => CREATED [utrno] => ) [9] => Array ( [merchant_order_id] => GP2508130451FECCDF [order_id] => 403rppbdf2aa1cdfeac875101c90a85124 [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 10:21:16 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2025-08-18 14:25:46 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 869 [recordsFiltered] => 869 [data] => Array ( [0] => Array ( [merchant_order_id] => order1254667893 [order_id] => 413rppabfbdc89649db732054d0498e5d7 [merchant_id] => 413 [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 16:28:30 [status] => CREATED [utrno] => ) [1] => Array ( [merchant_order_id] => GP2508140635ADBA7C [order_id] => 403rppb3ea604382bb9b12deebd3d49b0d [merchant_id] => 403 [amount] => 101 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 12:05:39 [status] => CREATED [utrno] => ) [2] => Array ( [merchant_order_id] => GP250814062784A36C [order_id] => 403rpp1ccb456fdb9b59f54d5ebc6211e9 [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 11:57:16 [status] => CREATED [utrno] => ) [3] => Array ( [merchant_order_id] => GP2508140626C68086 [order_id] => 403rpp904fa87713796857a2ef46baf233 [merchant_id] => 403 [amount] => 110 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 11:56:14 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => order1254667892 [order_id] => 413rpp3dfc805743b0fced9fd5c3e09fb4 [merchant_id] => 413 [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 20:37:03 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => GP2508131201FA8FEC [order_id] => 403rppb55e29be5374f2991137fbe7ccb8 [merchant_id] => 403 [amount] => 105 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 17:31:51 [status] => CREATED [utrno] => ) [6] => Array ( [merchant_order_id] => GP2508131159A4627D [order_id] => 403rpp6f30b623652abf27ad3d1076eb4f [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 17:29:51 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => GP25081307060CF9C1 [order_id] => 403rpp651a82ccd6834276e3f69b156988 [merchant_id] => 403 [amount] => 999 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 12:36:04 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => GP25081304511CC5E4 [order_id] => 403rppfc06757cddb6f8646b38565b31e6 [merchant_id] => 403 [amount] => 101 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 10:21:53 [status] => CREATED [utrno] => ) [9] => Array ( [merchant_order_id] => GP2508130451FECCDF [order_id] => 403rppbdf2aa1cdfeac875101c90a85124 [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 10:21:16 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2025-08-18 14:25:50 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [0] => No Result Found ) ) ERROR - 2025-08-18 14:25:55 --> Get Transaction Report API Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 2 [recordsFiltered] => 2 [data] => Array ( [0] => Array ( [merchant_order_id] => order123456789041234567890123456757 [order_id] => 175rpp0ff2622f2e8051c7b187954cc2d9c75c [merchant_id] => 175 [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 07:55:28 [status] => FAILED [utrno] => ) [1] => Array ( [merchant_order_id] => order12345678901234567890123456757 [order_id] => 175rppab4b287bdd4d1913cce0712a69fd5a34 [merchant_id] => 1 [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 07:55:10 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2025-08-18 14:25:58 --> Get Transaction Report API Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [0] => No Result Found ) ) ERROR - 2025-08-18 14:26:05 --> Get Archive Transaction Report API Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 2 [recordsFiltered] => 2 [data] => Array ( [0] => Array ( [merchant_order_id] => order123456789041234567890123456757 [order_id] => 175rpp0ff2622f2e8051c7b187954cc2d9c75c [merchant_id] => 175 [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 02:25:28 [status] => FAILED [utrno] => ) [1] => Array ( [merchant_order_id] => order12345678901234567890123456757 [order_id] => 175rppab4b287bdd4d1913cce0712a69fd5a34 [merchant_id] => 1 [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 02:25:10 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2025-08-18 14:26:12 --> Get Archive Transaction Report API Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 2 [recordsFiltered] => 2 [data] => Array ( [0] => Array ( [merchant_order_id] => order123456789041234567890123456757 [order_id] => 175rpp0ff2622f2e8051c7b187954cc2d9c75c [merchant_id] => 175 [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 02:25:28 [status] => FAILED [utrno] => ) [1] => Array ( [merchant_order_id] => order12345678901234567890123456757 [order_id] => 175rppab4b287bdd4d1913cce0712a69fd5a34 [merchant_id] => 1 [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 02:25:10 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2025-08-18 14:26:19 --> Get Archive Transaction Report API Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 2 [recordsFiltered] => 2 [data] => Array ( [0] => Array ( [merchant_order_id] => order123456789041234567890123456757 [order_id] => 175rpp0ff2622f2e8051c7b187954cc2d9c75c [merchant_id] => 175 [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 02:25:28 [status] => FAILED [utrno] => ) [1] => Array ( [merchant_order_id] => order12345678901234567890123456757 [order_id] => 175rppab4b287bdd4d1913cce0712a69fd5a34 [merchant_id] => 1 [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 02:25:10 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2025-08-18 14:27:00 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 869 [recordsFiltered] => 869 [data] => Array ( [0] => Array ( [merchant_order_id] => order1254667891 [order_id] => 413rpp7ce02937f7ef659a1ed10ea362d3 [merchant_id] => 413 [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-18 14:23:41 [status] => REFUND [utrno] => ) [1] => Array ( [merchant_order_id] => GP2508080537A9E50D [order_id] => 403rpp37b6ae3da27866d636f7595804dc [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-18 11:07:40 [status] => REFUND [utrno] => ) [2] => Array ( [merchant_order_id] => order1254667893 [order_id] => 413rppabfbdc89649db732054d0498e5d7 [merchant_id] => 413 [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 16:28:30 [status] => CREATED [utrno] => ) [3] => Array ( [merchant_order_id] => GP2508140635ADBA7C [order_id] => 403rppb3ea604382bb9b12deebd3d49b0d [merchant_id] => 403 [amount] => 101 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 12:05:39 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => GP250814062784A36C [order_id] => 403rpp1ccb456fdb9b59f54d5ebc6211e9 [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 11:57:16 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => GP2508140626C68086 [order_id] => 403rpp904fa87713796857a2ef46baf233 [merchant_id] => 403 [amount] => 110 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 11:56:14 [status] => CREATED [utrno] => ) [6] => Array ( [merchant_order_id] => order1254667892 [order_id] => 413rpp3dfc805743b0fced9fd5c3e09fb4 [merchant_id] => 413 [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 20:37:03 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => GP2508131201FA8FEC [order_id] => 403rppb55e29be5374f2991137fbe7ccb8 [merchant_id] => 403 [amount] => 105 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 17:31:51 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => GP2508131159A4627D [order_id] => 403rpp6f30b623652abf27ad3d1076eb4f [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 17:29:51 [status] => CREATED [utrno] => ) [9] => Array ( [merchant_order_id] => GP25081307060CF9C1 [order_id] => 403rpp651a82ccd6834276e3f69b156988 [merchant_id] => 403 [amount] => 999 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 12:36:04 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2025-08-18 14:27:10 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 869 [recordsFiltered] => 869 [data] => Array ( [0] => Array ( [merchant_order_id] => order1254667891 [order_id] => 413rpp7ce02937f7ef659a1ed10ea362d3 [merchant_id] => 413 [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-18 14:23:41 [status] => REFUND [utrno] => ) [1] => Array ( [merchant_order_id] => GP2508080537A9E50D [order_id] => 403rpp37b6ae3da27866d636f7595804dc [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-18 11:07:40 [status] => REFUND [utrno] => ) [2] => Array ( [merchant_order_id] => order1254667893 [order_id] => 413rppabfbdc89649db732054d0498e5d7 [merchant_id] => 413 [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 16:28:30 [status] => CREATED [utrno] => ) [3] => Array ( [merchant_order_id] => GP2508140635ADBA7C [order_id] => 403rppb3ea604382bb9b12deebd3d49b0d [merchant_id] => 403 [amount] => 101 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 12:05:39 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => GP250814062784A36C [order_id] => 403rpp1ccb456fdb9b59f54d5ebc6211e9 [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 11:57:16 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => GP2508140626C68086 [order_id] => 403rpp904fa87713796857a2ef46baf233 [merchant_id] => 403 [amount] => 110 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-14 11:56:14 [status] => CREATED [utrno] => ) [6] => Array ( [merchant_order_id] => order1254667892 [order_id] => 413rpp3dfc805743b0fced9fd5c3e09fb4 [merchant_id] => 413 [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 20:37:03 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => GP2508131201FA8FEC [order_id] => 403rppb55e29be5374f2991137fbe7ccb8 [merchant_id] => 403 [amount] => 105 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 17:31:51 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => GP2508131159A4627D [order_id] => 403rpp6f30b623652abf27ad3d1076eb4f [merchant_id] => 403 [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 17:29:51 [status] => CREATED [utrno] => ) [9] => Array ( [merchant_order_id] => GP25081307060CF9C1 [order_id] => 403rpp651a82ccd6834276e3f69b156988 [merchant_id] => 403 [amount] => 999 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-08-13 12:36:04 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2025-08-18 14:29:33 --> Config Data Array ( [0] => Array ( [id] => 5 [service] => de [partner] => d [sub_partner] => RAZORPAY [config] => {"key_id":"K3ZZODd0Ky92bENtdmVnUEhOa1l1UT09","secret_key":"Q2YxZ01RWlVsa2dEbGhnTUppNFV3UT09","base_url":"K3ZZODd0Ky92bENtdmVnUEhOa1l1UT09","salt":"K3ZZODd0Ky92bENtdmVnUEhOa1l1UT09","mode":"K3ZZODd0Ky92bENtdmVnUEhOa1l1UT09","public_key":"K3ZZODd0Ky92bENtdmVnUEhOa1l1UT09"} ) [1] => Array ( [id] => 4 [service] => pg [partner] => razorpay [sub_partner] => razorpay [config] => {"key_id":"Vy9KTC9UV05RWmRGTUN2UHBhZWs5bTlDREl0alI4aTBXV2RPMlk4ckpLQT0=","secret_key":"bkRBMVRVaWVDTng3NmJMVHNndkJiMnM3NFlwZEJhSy9EZEpYb2hpSjcraz0=","base_url":"OHNGVkF1Y2xucTMvQzFESm40djFSOXVmQkZJZ1Q1ZE1ES05ZTFhPUXNmND0=","salt":"","mode":"","public_key":"eFhpZXFTZGo5RllrMnJKeU9JcHVEWFRHVytuWWZ3Rk5kNE9VenVpY1prMD0="} ) [2] => Array ( [id] => 1 [service] => pg [partner] => cashfree [sub_partner] => cashfree [config] => {"key_id":"102212e67e7888beb8005b2b94212201","secret_key":"4fa31e64c2752981f772f46229632c93c2c877a2","base_url":"https://sandbox.cashfree.com/","salt":"","mode":"","public_key":""} ) ) ERROR - 2025-08-18 14:29:33 --> Config Decode K3ZZODd0Ky92bENtdmVnUEhOa1l1UT09 ERROR - 2025-08-18 14:29:33 --> Config Decode Vy9KTC9UV05RWmRGTUN2UHBhZWs5bTlDREl0alI4aTBXV2RPMlk4ckpLQT0= ERROR - 2025-08-18 14:29:33 --> Config Decode 102212e67e7888beb8005b2b94212201 ERROR - 2025-08-18 14:30:47 --> Get Sql Query Live filter count Topup Report : SELECT COUNT(id) AS total_count_topup_data FROM `oz_pg_trnx_details` WHERE DATE_FORMAT(cust_txn_initiate_datetime,'%Y-%m-%d') = '2025-08-18' ERROR - 2025-08-18 14:30:47 --> Get Sql Query live filter All topup Report : SELECT `id`, `cust_id`, `order_id`, `txn_amount`, `pg_partner`, `service_charge`, `gst_amount`, `credit_amount`, `api_charge`, `api_gst`, `distributor_com`, `distributor_gst`, `distributor_tds`, `admin_com`, `paytm_txn_id`, `bank_txn_id`, `txn_currency`, `gateway_name`, `txn_bank_name`, `payment_mode`, `response_code`, `cust_txn_initiate_datetime`, `paytm_txn_datetime`, `txn_status`, `txn_status_desc`, `cust_checksum_hash`, `is_amount_settled`, `isPaymentProcessed`, `open_bal`, `close_bal`, `callback_response`, `customer_info`, `merchant_info`, `txn_mode`, `razorpay_orderid`, `last_updated_by`, `rp_response` FROM `oz_pg_trnx_details` WHERE DATE_FORMAT(cust_txn_initiate_datetime,'%Y-%m-%d') = '2025-08-18' ORDER BY `id` DESC LIMIT 10 ERROR - 2025-08-18 17:48:54 --> Error connecting to the database: mysqli_sql_exception: No such file or directory in /var/www/html/adminrunpaisa/system/Database/MySQLi/Connection.php:171 Stack trace: #0 /var/www/html/adminrunpaisa/system/Database/MySQLi/Connection.php(171): mysqli->real_connect() #1 /var/www/html/adminrunpaisa/system/Database/BaseConnection.php(382): CodeIgniter\Database\MySQLi\Connection->connect() #2 /var/www/html/adminrunpaisa/system/Database/BaseConnection.php(561): CodeIgniter\Database\BaseConnection->initialize() #3 /var/www/html/adminrunpaisa/app/Models/Member/MemberModel.php(59): CodeIgniter\Database\BaseConnection->query() #4 /var/www/html/adminrunpaisa/app/Controllers/Member/Member.php(333): App\Models\Member\MemberModel->getMemberDetails() #5 /var/www/html/adminrunpaisa/system/CodeIgniter.php(927): App\Controllers\Member\Member->updateMember() #6 /var/www/html/adminrunpaisa/system/CodeIgniter.php(482): CodeIgniter\CodeIgniter->runController() #7 /var/www/html/adminrunpaisa/system/CodeIgniter.php(351): CodeIgniter\CodeIgniter->handleRequest() #8 /var/www/html/adminrunpaisa/index.php(67): CodeIgniter\CodeIgniter->run() #9 {main} Next CodeIgniter\Database\Exceptions\DatabaseException: No such file or directory in /var/www/html/adminrunpaisa/system/Database/MySQLi/Connection.php:215 Stack trace: #0 /var/www/html/adminrunpaisa/system/Database/BaseConnection.php(382): CodeIgniter\Database\MySQLi\Connection->connect() #1 /var/www/html/adminrunpaisa/system/Database/BaseConnection.php(561): CodeIgniter\Database\BaseConnection->initialize() #2 /var/www/html/adminrunpaisa/app/Models/Member/MemberModel.php(59): CodeIgniter\Database\BaseConnection->query() #3 /var/www/html/adminrunpaisa/app/Controllers/Member/Member.php(333): App\Models\Member\MemberModel->getMemberDetails() #4 /var/www/html/adminrunpaisa/system/CodeIgniter.php(927): App\Controllers\Member\Member->updateMember() #5 /var/www/html/adminrunpaisa/system/CodeIgniter.php(482): CodeIgniter\CodeIgniter->runController() #6 /var/www/html/adminrunpaisa/system/CodeIgniter.php(351): CodeIgniter\CodeIgniter->handleRequest() #7 /var/www/html/adminrunpaisa/index.php(67): CodeIgniter\CodeIgniter->run() #8 {main} CRITICAL - 2025-08-18 17:48:54 --> Unable to connect to the database. Main connection [MySQLi]: No such file or directory in SYSTEMPATH/Database/BaseConnection.php on line 418. 1 SYSTEMPATH/Database/BaseConnection.php(561): CodeIgniter\Database\BaseConnection->initialize() 2 APPPATH/Models/Member/MemberModel.php(59): CodeIgniter\Database\BaseConnection->query() 3 APPPATH/Controllers/Member/Member.php(333): App\Models\Member\MemberModel->getMemberDetails() 4 SYSTEMPATH/CodeIgniter.php(927): App\Controllers\Member\Member->updateMember() 5 SYSTEMPATH/CodeIgniter.php(482): CodeIgniter\CodeIgniter->runController() 6 SYSTEMPATH/CodeIgniter.php(351): CodeIgniter\CodeIgniter->handleRequest() 7 FCPATH/index.php(67): CodeIgniter\CodeIgniter->run() ERROR - 2025-08-18 18:02:32 --> Get Sql Query Live filter count Topup Report : SELECT COUNT(id) AS total_count_topup_data FROM `oz_pg_trnx_details` WHERE DATE_FORMAT(cust_txn_initiate_datetime,'%Y-%m-%d') = '2025-08-18' ERROR - 2025-08-18 18:02:32 --> Get Sql Query live filter All topup Report : SELECT `id`, `cust_id`, `order_id`, `txn_amount`, `pg_partner`, `service_charge`, `gst_amount`, `credit_amount`, `api_charge`, `api_gst`, `distributor_com`, `distributor_gst`, `distributor_tds`, `admin_com`, `paytm_txn_id`, `bank_txn_id`, `txn_currency`, `gateway_name`, `txn_bank_name`, `payment_mode`, `response_code`, `cust_txn_initiate_datetime`, `paytm_txn_datetime`, `txn_status`, `txn_status_desc`, `cust_checksum_hash`, `is_amount_settled`, `isPaymentProcessed`, `open_bal`, `close_bal`, `callback_response`, `customer_info`, `merchant_info`, `txn_mode`, `razorpay_orderid`, `last_updated_by`, `rp_response` FROM `oz_pg_trnx_details` WHERE DATE_FORMAT(cust_txn_initiate_datetime,'%Y-%m-%d') = '2025-08-18' ORDER BY `id` DESC LIMIT 10