ERROR - 2026-02-16 12:15:21 --> Get Sql Query: CodeIgniter\Database\Query Object ( [originalQueryString:protected] => SELECT `cust_id`, SUM(txn_amount) as amount FROM `oz_pg_trnx_details` WHERE `cust_txn_initiate_datetime` >= :cust_txn_initiate_datetime: AND `cust_txn_initiate_datetime` <= :cust_txn_initiate_datetime.1: AND `response_code` = :response_code: GROUP BY `cust_id` ORDER BY `amount` DESC LIMIT 10 [finalQueryString:protected] => SELECT `cust_id`, SUM(txn_amount) as amount FROM `oz_pg_trnx_details` WHERE `cust_txn_initiate_datetime` >= '2026-02-16 00:00:00' AND `cust_txn_initiate_datetime` <= '2026-02-16 23:59:59' AND `response_code` = 1 GROUP BY `cust_id` ORDER BY `amount` DESC LIMIT 10 [binds:protected] => Array ( [cust_txn_initiate_datetime] => Array ( [0] => 2026-02-16 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2026-02-16 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1771224321.4563 [endTime:protected] => 1771224321.6002 [errorCode:protected] => [errorString:protected] => [db] => CodeIgniter\Database\MySQLi\Connection Object ( [DSN:protected] => [port:protected] => 3306 [hostname:protected] => localhost [username:protected] => rpdevelopment [password:protected] => rpdevelopment [database:protected] => runpaisa_new [DBDriver] => MySQLi [subdriver:protected] => [DBPrefix:protected] => [pConnect:protected] => [DBDebug:protected] => [charset:protected] => utf8 [DBCollat:protected] => utf8_general_ci [swapPre:protected] => [encrypt:protected] => [compress:protected] => [strictOn:protected] => [failover:protected] => Array ( ) [lastQuery:protected] => CodeIgniter\Database\Query Object *RECURSION* [connID] => mysqli Object ( [affected_rows] => 0 [client_info] => mysqlnd 8.1.2-1ubuntu2.18 [client_version] => 80102 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 2 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 8.0.37-0ubuntu0.22.04.3 [server_version] => 80037 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 673 [warning_count] => 0 ) [resultID] => mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 0 [type] => 0 ) [protectIdentifiers] => 1 [reservedIdentifiers:protected] => Array ( [0] => * ) [escapeChar] => ` [likeEscapeStr] => ESCAPE '%s' [likeEscapeChar] => ! [pregEscapeChar:protected] => Array ( [1] => ` [0] => ` [3] => ` [2] => ` ) [dataCache] => Array ( ) [connectTime:protected] => 1771224321.4556 [connectDuration:protected] => 0.00067496299743652 [pretend:protected] => [transEnabled] => 1 [transStrict] => 1 [transDepth:protected] => 0 [transStatus:protected] => 1 [transFailure:protected] => [aliasedTables:protected] => Array ( ) [queryClass:protected] => CodeIgniter\Database\Query [deleteHack] => 1 [mysqli] => mysqli Object ( [affected_rows] => 0 [client_info] => mysqlnd 8.1.2-1ubuntu2.18 [client_version] => 80102 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 2 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 8.0.37-0ubuntu0.22.04.3 [server_version] => 80037 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 673 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2026-02-16 12:47:51 --> FIle Upload Response : {"success":true,"message":"File uploaded successfully","data":{"file_id":317,"image_id":"1771226271d4e9d51a352a51dc06773d12fc18fa303bfadafa97c63944f967faea3db4bbd6","filename":"7830cc4936fca50c1c60a81d7e9fce34.enc","mime_type":"image/jpeg","size":53174,"encrypted":true,"storage_mode":"local","uploaded_at":"2026-02-16 07:17:51"}} ERROR - 2026-02-16 12:47:51 --> FIle Upload Response : {"success":true,"message":"File uploaded successfully","data":{"file_id":318,"image_id":"1771226271358bbabc5cb08f85c7b4e2bb1ab81f1a168d72c4a8eea3594ef3ad0796c46310","filename":"ba5d67507dac2bfab4021194e299e081.enc","mime_type":"image/jpeg","size":53174,"encrypted":true,"storage_mode":"local","uploaded_at":"2026-02-16 07:17:51"}} ERROR - 2026-02-16 12:47:51 --> FIle Upload Response : {"success":true,"message":"File uploaded successfully","data":{"file_id":319,"image_id":"1771226271114aef6a21588ee6f1f88ecb2cd470c5afcb904def81bc54fe769916a3c1de5d","filename":"c823f7e13e4b5294f6025fb296f97bbb.enc","mime_type":"image/jpeg","size":53174,"encrypted":true,"storage_mode":"local","uploaded_at":"2026-02-16 07:17:51"}} ERROR - 2026-02-16 12:47:51 --> FIle Upload Response : {"success":true,"message":"File uploaded successfully","data":{"file_id":320,"image_id":"1771226271d4de1c7eb14f70a9c7b3c7b6b20d777ba6da5f061434a715f6d7c26dc294e511","filename":"0cd2bc5c730e57f188cc6405233b4014.enc","mime_type":"image/jpeg","size":53174,"encrypted":true,"storage_mode":"local","uploaded_at":"2026-02-16 07:17:51"}} ERROR - 2026-02-16 12:47:51 --> FIle Upload Response : {"success":true,"message":"File uploaded successfully","data":{"file_id":321,"image_id":"1771226271f7dd372a5d595c9fa9f5585334aa33208dd6a6baeaabd2656f137b8e5a58df72","filename":"03244215c60fdd0444e8cd9c97b1d2fe.enc","mime_type":"image/jpeg","size":53174,"encrypted":true,"storage_mode":"local","uploaded_at":"2026-02-16 07:17:51"}} CRITICAL - 2026-02-16 12:47:51 --> Undefined array key "messages" in APPPATH/Controllers/Member/Member.php on line 595. 1 APPPATH/Controllers/Member/Member.php(595): CodeIgniter\Debug\Exceptions->errorHandler() 2 SYSTEMPATH/CodeIgniter.php(927): App\Controllers\Member\Member->updateDocumentData() 3 SYSTEMPATH/CodeIgniter.php(482): CodeIgniter\CodeIgniter->runController() 4 SYSTEMPATH/CodeIgniter.php(351): CodeIgniter\CodeIgniter->handleRequest() 5 FCPATH/index.php(67): CodeIgniter\CodeIgniter->run() ERROR - 2026-02-16 12:48:00 --> FIle Upload Response : {"success":true,"message":"File uploaded successfully","data":{"file_id":322,"image_id":"177122628000a5007b3c522cf800d33ae7f414f252b1be731b55684302b4583368659c9cd1","filename":"486474bfd4e2afbecec635911ae889a0.enc","mime_type":"image/jpeg","size":53174,"encrypted":true,"storage_mode":"local","uploaded_at":"2026-02-16 07:18:00"}} ERROR - 2026-02-16 12:48:00 --> FIle Upload Response : {"success":true,"message":"File uploaded successfully","data":{"file_id":323,"image_id":"17712262801dddf38fb2aa5101349637fb66f1a272bc85612dbcc9513a421aa0a07aa8a7e9","filename":"fb81e8bc6d9c8d0f0b15279c97c44ee4.enc","mime_type":"image/jpeg","size":53174,"encrypted":true,"storage_mode":"local","uploaded_at":"2026-02-16 07:18:00"}} ERROR - 2026-02-16 12:48:00 --> FIle Upload Response : {"success":true,"message":"File uploaded successfully","data":{"file_id":324,"image_id":"1771226280a445e8718023ddeb2c2a2e4947c9ffc8485027ba643b2c089fafe81e366dd746","filename":"45fd62e281b44d869a256d564a882e61.enc","mime_type":"image/jpeg","size":53174,"encrypted":true,"storage_mode":"local","uploaded_at":"2026-02-16 07:18:00"}} ERROR - 2026-02-16 12:48:00 --> FIle Upload Response : {"success":true,"message":"File uploaded successfully","data":{"file_id":325,"image_id":"17712262800fa5c0c89aee0bbc015a6f129b0c6472ebbbbd87d8957504d65ee05df26378f6","filename":"072aaf5bd9d76e56b27aa760122153c4.enc","mime_type":"image/jpeg","size":53174,"encrypted":true,"storage_mode":"local","uploaded_at":"2026-02-16 07:18:00"}} ERROR - 2026-02-16 12:48:00 --> FIle Upload Response : {"success":true,"message":"File uploaded successfully","data":{"file_id":326,"image_id":"17712262804d8c5553dc10f7d52a00118a3c244a1fd025eca407a822d789881b3221cf9e85","filename":"66803ca5ea70c6912b14d9848347dbfb.enc","mime_type":"image/jpeg","size":53174,"encrypted":true,"storage_mode":"local","uploaded_at":"2026-02-16 07:18:00"}} CRITICAL - 2026-02-16 12:48:00 --> Undefined array key "messages" in APPPATH/Controllers/Member/Member.php on line 595. 1 APPPATH/Controllers/Member/Member.php(595): CodeIgniter\Debug\Exceptions->errorHandler() 2 SYSTEMPATH/CodeIgniter.php(927): App\Controllers\Member\Member->updateDocumentData() 3 SYSTEMPATH/CodeIgniter.php(482): CodeIgniter\CodeIgniter->runController() 4 SYSTEMPATH/CodeIgniter.php(351): CodeIgniter\CodeIgniter->handleRequest() 5 FCPATH/index.php(67): CodeIgniter\CodeIgniter->run() CRITICAL - 2026-02-16 12:50:28 --> Undefined array key "mt_charge_2000" in APPPATH/Views/Admin/members/update-member.php on line 867. 1 APPPATH/Views/Admin/members/update-member.php(867): CodeIgniter\Debug\Exceptions->errorHandler() 2 SYSTEMPATH/View/View.php(213): include('APPPATH/Views/Admin/members/update-member.php') 3 SYSTEMPATH/View/View.php(216): CodeIgniter\View\View->CodeIgniter\View\{closure}() 4 SYSTEMPATH/Common.php(1134): CodeIgniter\View\View->render() 5 APPPATH/Controllers/Member/Member.php(383): view() 6 SYSTEMPATH/CodeIgniter.php(927): App\Controllers\Member\Member->updateMember() 7 SYSTEMPATH/CodeIgniter.php(482): CodeIgniter\CodeIgniter->runController() 8 SYSTEMPATH/CodeIgniter.php(351): CodeIgniter\CodeIgniter->handleRequest() 9 FCPATH/index.php(67): CodeIgniter\CodeIgniter->run() ERROR - 2026-02-16 12:54:25 --> 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') = '2026-02-16' ERROR - 2026-02-16 12:54:25 --> 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') = '2026-02-16' ORDER BY `id` DESC LIMIT 10 ERROR - 2026-02-16 12:59:01 --> Get Today Earning Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2026-02-16 12:59:01 --> get today earning response: Array ( [code] => RP001 [status] => FAILED [errors] => Array ( [0] => Data not found ) [message] => Data not found [data] => Array ( ) ) ERROR - 2026-02-16 12:59:02 --> Get Monthly Earning Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2026-02-16 12:59:02 --> Get Today Revenue Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2026-02-16 12:59:02 --> Get Monthly Revenue Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2026-02-16 12:59:30 --> Get Merchant Balance Api Response: {"code":"RP000","status":"SUCCESS","errors":[],"message":"Fetched Successfully","data":{"total_balance":6005279731.49}} ERROR - 2026-02-16 13:00:54 --> Get Payout Default Charge Master Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Success [data] => Array ( [0] => Array ( [id] => 1 [min_amount] => 1 [max_amount] => 1000 [transaction_type] => imps [charge] => 6 ) [1] => Array ( [id] => 2 [min_amount] => 1001 [max_amount] => 25000 [transaction_type] => imps [charge] => 342 ) [2] => Array ( [id] => 3 [min_amount] => 25001 [max_amount] => 200000 [transaction_type] => imps [charge] => 10 ) ) ) ERROR - 2026-02-16 13:01:35 --> Transaction Transaction Payload Api data : Array ( [merchant_id] => [order_id] => [merchant_order_id] => [from_date] => [to_date] => [account_number] => [utr_no] => [status] => [length] => 10 [start] => 0 ) ERROR - 2026-02-16 13:01:35 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 941 [recordsFiltered] => 941 [data] => Array ( [0] => Array ( [merchant_order_id] => order12345678901234567890123456752e [order_id] => 1rpp09ea3d7d25f79f2c41cec3656b35 [merchant_id] => 1 [partner_payout_id] => [amount] => 3000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-01-23 14:25:50 [status] => CREATED [utrno] => ) [1] => Array ( [merchant_order_id] => order12345678901234567890123456752d [order_id] => 1rpp07169ec7007aba3e9c734737b7c3 [merchant_id] => 1 [partner_payout_id] => [amount] => 3000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-01-23 14:25:26 [status] => CREATED [utrno] => ) [2] => Array ( [merchant_order_id] => order12345678901234567890123456752c [order_id] => 1rpp4c99aca875095a055ff18a62bc6f [merchant_id] => 1 [partner_payout_id] => [amount] => 3000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-01-23 14:24:55 [status] => CREATED [utrno] => ) [3] => Array ( [merchant_order_id] => order12345678901234567890123456752b [order_id] => 1rpp251fcd3477588bbbb3b981b41c0c [merchant_id] => 1 [partner_payout_id] => [amount] => 3000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-01-23 14:24:31 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => order12345678901234567890123456752a [order_id] => 1rppcc26849242e7ac78383f416a9024 [merchant_id] => 1 [partner_payout_id] => [amount] => 3000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-01-23 14:22:04 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => W251226174944ZULV [order_id] => 352rpp2f85499a83fa04e745a18366fd48 [merchant_id] => 352 [partner_payout_id] => [amount] => 1 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-12-26 17:49:46 [status] => CREATED [utrno] => ) [6] => Array ( [merchant_order_id] => W251226174906DJXV [order_id] => 352rpp7db711a86e1c487acc699301ebcb [merchant_id] => 352 [partner_payout_id] => [amount] => 1 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-12-26 17:49:08 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => GP2511050530A41BE6 [order_id] => 403rpp1dd5e0a9f5bfbe0452212cb2b8ed [merchant_id] => 403 [partner_payout_id] => pout_Rbwf2G0W7oljl8 [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-11-05 11:00:35 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => GP2511031254EF5F93 [order_id] => 403rpp7e05b11778ee10202b616676c62f [merchant_id] => 403 [partner_payout_id] => pout_RbH5a1xeuZnBI7 [amount] => 5000 [service_charge] => 342 [service_gst] => 61.56 [txn_dateTime] => 2025-11-03 18:24:32 [status] => CREATED [utrno] => ) [9] => Array ( [merchant_order_id] => GP2511031145E22F6D [order_id] => 403rpp313faa2947bbef7200d484ea4387 [merchant_id] => 403 [partner_payout_id] => pout_RbFyuYbjuS9JsX [amount] => 1001 [service_charge] => 342 [service_gst] => 61.56 [txn_dateTime] => 2025-11-03 17:15:51 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2026-02-16 13:02:33 --> Transaction Transaction Payload Api data : Array ( [merchant_id] => [order_id] => [merchant_order_id] => [from_date] => [to_date] => [account_number] => [utr_no] => [status] => [length] => 10 [start] => 20 ) ERROR - 2026-02-16 13:02:33 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 941 [recordsFiltered] => 941 [data] => Array ( [0] => Array ( [merchant_order_id] => order12574667896 [order_id] => 413rpp6c67e933107bc6491f540ddae0b6 [merchant_id] => 413 [partner_payout_id] => pout_RDWmUm0c6B1x0T [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-09-04 18:05:45 [status] => CREATED [utrno] => ) [1] => Array ( [merchant_order_id] => order1254667897 [order_id] => 413rppafd83e1a336052a56ba25134b3a7 [merchant_id] => 413 [partner_payout_id] => pout_RDWROGqu9pyMs9 [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-09-04 17:46:44 [status] => CREATED [utrno] => ) [2] => Array ( [merchant_order_id] => order1254667896 [order_id] => 413rpp7f45562b0521429a82a9ff0cc370 [merchant_id] => 413 [partner_payout_id] => pout_RD67L92u3wQlbF [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-09-03 16:04:58 [status] => CREATED [utrno] => ) [3] => Array ( [merchant_order_id] => GP2509021133594185 [order_id] => 403rppa5bdde8d8fef6c5ac91e3c530145 [merchant_id] => 403 [partner_payout_id] => pout_RCiba876aiKGxR [amount] => 300 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-09-02 17:03:56 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => GP250902111330FDCF [order_id] => 403rpp2513c01505b3236b6f7cef2d2d73 [merchant_id] => 403 [partner_payout_id] => NA [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-09-02 16:43:36 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => GP25090210532189D0 [order_id] => 403rppdfa5fbcb214eecc718182f6bf715 [merchant_id] => 403 [partner_payout_id] => pout_RChvNIFooRvzSy [amount] => 250 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-09-02 16:23:54 [status] => CREATED [utrno] => ) [6] => Array ( [merchant_order_id] => GP2509021044EE8585 [order_id] => 403rpp40e5d9ccb675e3d14f16cfb712bf [merchant_id] => 403 [partner_payout_id] => pout_RChkm7oYDHTrIW [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-09-02 16:14:52 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => GP25090210330E60E3 [order_id] => 403rpp30392c36e6b8ab805e383e78ad97 [merchant_id] => 403 [partner_payout_id] => pout_RChaJuR9uObEen [amount] => 1001 [service_charge] => 342 [service_gst] => 61.56 [txn_dateTime] => 2025-09-02 16:03:54 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => GP25090210336A12A9 [order_id] => 403rpp633260b636af135e027565fe6c5b [merchant_id] => 403 [partner_payout_id] => pout_RChaH9HLWLqOjc [amount] => 101 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-09-02 16:03:06 [status] => CREATED [utrno] => ) [9] => Array ( [merchant_order_id] => GP25090210322F0B5E [order_id] => 403rppacc5aa857d18f354eab92a72a9d0 [merchant_id] => 403 [partner_payout_id] => pout_RChaELmjQIJvDQ [amount] => 1001 [service_charge] => 342 [service_gst] => 61.56 [txn_dateTime] => 2025-09-02 16:02:30 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2026-02-16 13:02:38 --> Transaction Transaction Payload Api data : Array ( [merchant_id] => [order_id] => [merchant_order_id] => [from_date] => [to_date] => [account_number] => [utr_no] => [status] => [length] => 10 [start] => 940 ) ERROR - 2026-02-16 13:02:38 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 941 [recordsFiltered] => 941 [data] => Array ( [0] => Array ( [merchant_order_id] => order12345678901234567890123456757 [order_id] => 175rppab4b287bdd4d1913cce0712a69fd5a34 [merchant_id] => 1 [partner_payout_id] => pout_Ot5AfvcXhl78xa [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 13:25:10 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2026-02-16 13:02:42 --> Transaction Transaction Payload Api data : Array ( [merchant_id] => [order_id] => [merchant_order_id] => [from_date] => [to_date] => [account_number] => [utr_no] => [status] => [length] => 10 [start] => 930 ) ERROR - 2026-02-16 13:02:42 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 941 [recordsFiltered] => 941 [data] => Array ( [0] => Array ( [merchant_order_id] => q11123qorder126735690431234567890123456757 [order_id] => 175rppcd99c4c45b6fe6d7aebe384272c37b0d [merchant_id] => 175 [partner_payout_id] => pout_OuE4taTCF9Ar3J [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-07 14:50:10 [status] => CREATED [utrno] => ) [1] => Array ( [merchant_order_id] => 11123order123435690431234567890123456757 [order_id] => 175rppff783937479730a0c2db0b7960b38eee [merchant_id] => 175 [partner_payout_id] => pout_Ot5d07oLF60OMa [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 17:58:29 [status] => CREATED [utrno] => ) [2] => Array ( [merchant_order_id] => 123order123435690431234567890123456757 [order_id] => 175rpp2c1d7cd1e45c2bfac9d95d186080cc59 [merchant_id] => 175 [partner_payout_id] => pout_Ot5cxC3gswUvSv [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 17:58:22 [status] => CREATED [utrno] => ) [3] => Array ( [merchant_order_id] => order123435637383390431234567890123456757 [order_id] => 175rppa4ef78bf212c75cb0157411b33d29a62 [merchant_id] => 175 [partner_payout_id] => pout_Ot59bcrRbLYYcA [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 13:25:48 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => order12343563783390431234567890123456757 [order_id] => 175rpp21bcc8dd899999014cb04fec915e9f67 [merchant_id] => 175 [partner_payout_id] => pout_Ot59BzhOqfPM3l [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 13:25:45 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => order1234356378390431234567890123456757 [order_id] => 175rppaa30f39cbb65b66e6dce29f8d7b05777 [merchant_id] => 175 [partner_payout_id] => pout_Ot5ArGL3w7cLbG [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 13:25:42 [status] => FAILED [utrno] => Ot5ArGL3w7cLbG ) [6] => Array ( [merchant_order_id] => order123435637839041234567890123456757 [order_id] => 175rppe8f3c6a80f3e697e1d420ddac17dc491 [merchant_id] => 175 [partner_payout_id] => pout_Ot5AoofqJgMqWv [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 13:25:39 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => order12343567839041234567890123456757 [order_id] => 175rppe212bff785da7bc4ded96eaff5057c3f [merchant_id] => 175 [partner_payout_id] => pout_Ot5Amo9POInlDX [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 13:25:35 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => order1234356789041234567890123456757 [order_id] => 175rpp5c9b97bb03bc5a6564424fa2810f6187 [merchant_id] => 175 [partner_payout_id] => pout_Ot5AkTZf6f1LR2 [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 13:25:32 [status] => CREATED [utrno] => ) [9] => Array ( [merchant_order_id] => order123456789041234567890123456757 [order_id] => 175rpp0ff2622f2e8051c7b187954cc2d9c75c [merchant_id] => 175 [partner_payout_id] => pout_Ot5AiQgerHQ53W [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 13:25:28 [status] => FAILED [utrno] => ) ) ) ) ERROR - 2026-02-16 13:02:44 --> Transaction Transaction Payload Api data : Array ( [merchant_id] => [order_id] => [merchant_order_id] => [from_date] => [to_date] => [account_number] => [utr_no] => [status] => [length] => 10 [start] => 920 ) ERROR - 2026-02-16 13:02:44 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 941 [recordsFiltered] => 941 [data] => Array ( [0] => Array ( [merchant_order_id] => 012345678911234567891123456789 [order_id] => 269rppd6d3cdedfb45ce4fc2b60e7c6dd639a7 [merchant_id] => 269 [partner_payout_id] => NA [amount] => 1000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2024-09-11 12:18:32 [status] => CREATED [utrno] => ) [1] => Array ( [merchant_order_id] => 123456789112345678911234567899 [order_id] => 269rpp10e6b6872bedb911a2536ea8c85e6392 [merchant_id] => 269 [partner_payout_id] => NA [amount] => 1000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2024-09-11 12:15:52 [status] => CREATED [utrno] => ) [2] => Array ( [merchant_order_id] => 123456789112345678911234567892 [order_id] => 269rppb402b023f907e6e5ceb69c4b397d4e7a [merchant_id] => 269 [partner_payout_id] => NA [amount] => 1000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2024-09-11 12:09:03 [status] => CREATED [utrno] => ) [3] => Array ( [merchant_order_id] => 123456789112345678911234567890 [order_id] => 269rpp2df55622f3873a1f8a7fcb1d098620bc [merchant_id] => 269 [partner_payout_id] => NA [amount] => 1000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2024-09-11 12:04:13 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => ORD123456789012345678901234567890 [order_id] => 269rpp54809a1617031a4906526a59bea8ee78 [merchant_id] => 269 [partner_payout_id] => NA [amount] => 1000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2024-09-11 12:02:54 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => 123456789112345678911234567891 [order_id] => 269rppf3229ec3423738856de99effbfb31067 [merchant_id] => 269 [partner_payout_id] => NA [amount] => 1000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2024-09-11 12:01:27 [status] => CREATED [utrno] => ) [6] => Array ( [merchant_order_id] => order12345678901234567890123456754509 [order_id] => 175rpp6c9b005b5dc9e7544f4e26a09c17b743 [merchant_id] => 175 [partner_payout_id] => pout_Ov0yaAFTX5fSOe [amount] => 3000 [service_charge] => 10 [service_gst] => 1.8 [txn_dateTime] => 2024-09-09 14:43:15 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => order12345678901234567890123456754567 [order_id] => 1rpp5664bdbabbd03d7150edf7d0ffd08f21 [merchant_id] => 1 [partner_payout_id] => NA [amount] => 3000 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2024-09-09 12:37:26 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => q11123qorder123435690431234567890123456757 [order_id] => 175rppefcaf13aff9d5f72c32b8e876f36ec21 [merchant_id] => 175 [partner_payout_id] => pout_Ot5d5O83bO7UrU [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-07 17:58:42 [status] => FAILED [utrno] => Ot5d5O83bO7UrU ) [9] => Array ( [merchant_order_id] => 11123qorder123435690431234567890123456757 [order_id] => 175rppd9b5bd1e7274923f1554553a15ac1e58 [merchant_id] => 175 [partner_payout_id] => pout_Ot5d2JiQoh8y0X [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-07 17:58:39 [status] => SUCCESS [utrno] => Ot5d2JiQoh8y0X ) ) ) ) ERROR - 2026-02-16 13:03:23 --> Transaction Transaction Payload Api data : Array ( [merchant_id] => [order_id] => [merchant_order_id] => [from_date] => [to_date] => [account_number] => [utr_no] => [status] => [length] => 10 [start] => 0 ) ERROR - 2026-02-16 13:03:23 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 941 [recordsFiltered] => 941 [data] => Array ( [0] => Array ( [merchant_order_id] => order12345678901234567890123456752e [order_id] => 1rpp09ea3d7d25f79f2c41cec3656b35 [merchant_id] => 1 [partner_payout_id] => [amount] => 3000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-01-23 14:25:50 [status] => CREATED [utrno] => ) [1] => Array ( [merchant_order_id] => order12345678901234567890123456752d [order_id] => 1rpp07169ec7007aba3e9c734737b7c3 [merchant_id] => 1 [partner_payout_id] => [amount] => 3000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-01-23 14:25:26 [status] => CREATED [utrno] => ) [2] => Array ( [merchant_order_id] => order12345678901234567890123456752c [order_id] => 1rpp4c99aca875095a055ff18a62bc6f [merchant_id] => 1 [partner_payout_id] => [amount] => 3000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-01-23 14:24:55 [status] => CREATED [utrno] => ) [3] => Array ( [merchant_order_id] => order12345678901234567890123456752b [order_id] => 1rpp251fcd3477588bbbb3b981b41c0c [merchant_id] => 1 [partner_payout_id] => [amount] => 3000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-01-23 14:24:31 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => order12345678901234567890123456752a [order_id] => 1rppcc26849242e7ac78383f416a9024 [merchant_id] => 1 [partner_payout_id] => [amount] => 3000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-01-23 14:22:04 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => W251226174944ZULV [order_id] => 352rpp2f85499a83fa04e745a18366fd48 [merchant_id] => 352 [partner_payout_id] => [amount] => 1 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-12-26 17:49:46 [status] => CREATED [utrno] => ) [6] => Array ( [merchant_order_id] => W251226174906DJXV [order_id] => 352rpp7db711a86e1c487acc699301ebcb [merchant_id] => 352 [partner_payout_id] => [amount] => 1 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-12-26 17:49:08 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => GP2511050530A41BE6 [order_id] => 403rpp1dd5e0a9f5bfbe0452212cb2b8ed [merchant_id] => 403 [partner_payout_id] => pout_Rbwf2G0W7oljl8 [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-11-05 11:00:35 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => GP2511031254EF5F93 [order_id] => 403rpp7e05b11778ee10202b616676c62f [merchant_id] => 403 [partner_payout_id] => pout_RbH5a1xeuZnBI7 [amount] => 5000 [service_charge] => 342 [service_gst] => 61.56 [txn_dateTime] => 2025-11-03 18:24:32 [status] => CREATED [utrno] => ) [9] => Array ( [merchant_order_id] => GP2511031145E22F6D [order_id] => 403rpp313faa2947bbef7200d484ea4387 [merchant_id] => 403 [partner_payout_id] => pout_RbFyuYbjuS9JsX [amount] => 1001 [service_charge] => 342 [service_gst] => 61.56 [txn_dateTime] => 2025-11-03 17:15:51 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2026-02-16 13:03:58 --> Transaction Transaction Payload Api data : Array ( [merchant_id] => [order_id] => [merchant_order_id] => [from_date] => [to_date] => [account_number] => [utr_no] => [status] => [length] => 10 [start] => 0 ) ERROR - 2026-02-16 13:03:58 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 941 [recordsFiltered] => 941 [data] => Array ( [0] => Array ( [merchant_order_id] => order12345678901234567890123456752e [order_id] => 1rpp09ea3d7d25f79f2c41cec3656b35 [merchant_id] => 1 [partner_payout_id] => [amount] => 3000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-01-23 14:25:50 [status] => CREATED [utrno] => ) [1] => Array ( [merchant_order_id] => order12345678901234567890123456752d [order_id] => 1rpp07169ec7007aba3e9c734737b7c3 [merchant_id] => 1 [partner_payout_id] => [amount] => 3000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-01-23 14:25:26 [status] => CREATED [utrno] => ) [2] => Array ( [merchant_order_id] => order12345678901234567890123456752c [order_id] => 1rpp4c99aca875095a055ff18a62bc6f [merchant_id] => 1 [partner_payout_id] => [amount] => 3000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-01-23 14:24:55 [status] => CREATED [utrno] => ) [3] => Array ( [merchant_order_id] => order12345678901234567890123456752b [order_id] => 1rpp251fcd3477588bbbb3b981b41c0c [merchant_id] => 1 [partner_payout_id] => [amount] => 3000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-01-23 14:24:31 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => order12345678901234567890123456752a [order_id] => 1rppcc26849242e7ac78383f416a9024 [merchant_id] => 1 [partner_payout_id] => [amount] => 3000 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-01-23 14:22:04 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => W251226174944ZULV [order_id] => 352rpp2f85499a83fa04e745a18366fd48 [merchant_id] => 352 [partner_payout_id] => [amount] => 1 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-12-26 17:49:46 [status] => CREATED [utrno] => ) [6] => Array ( [merchant_order_id] => W251226174906DJXV [order_id] => 352rpp7db711a86e1c487acc699301ebcb [merchant_id] => 352 [partner_payout_id] => [amount] => 1 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-12-26 17:49:08 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => GP2511050530A41BE6 [order_id] => 403rpp1dd5e0a9f5bfbe0452212cb2b8ed [merchant_id] => 403 [partner_payout_id] => pout_Rbwf2G0W7oljl8 [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-11-05 11:00:35 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => GP2511031254EF5F93 [order_id] => 403rpp7e05b11778ee10202b616676c62f [merchant_id] => 403 [partner_payout_id] => pout_RbH5a1xeuZnBI7 [amount] => 5000 [service_charge] => 342 [service_gst] => 61.56 [txn_dateTime] => 2025-11-03 18:24:32 [status] => CREATED [utrno] => ) [9] => Array ( [merchant_order_id] => GP2511031145E22F6D [order_id] => 403rpp313faa2947bbef7200d484ea4387 [merchant_id] => 403 [partner_payout_id] => pout_RbFyuYbjuS9JsX [amount] => 1001 [service_charge] => 342 [service_gst] => 61.56 [txn_dateTime] => 2025-11-03 17:15:51 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2026-02-16 13:15:58 --> Get Sql Query: CodeIgniter\Database\Query Object ( [originalQueryString:protected] => SELECT `cust_id`, SUM(txn_amount) as amount FROM `oz_pg_trnx_details` WHERE `cust_txn_initiate_datetime` >= :cust_txn_initiate_datetime: AND `cust_txn_initiate_datetime` <= :cust_txn_initiate_datetime.1: AND `response_code` = :response_code: GROUP BY `cust_id` ORDER BY `amount` DESC LIMIT 10 [finalQueryString:protected] => SELECT `cust_id`, SUM(txn_amount) as amount FROM `oz_pg_trnx_details` WHERE `cust_txn_initiate_datetime` >= '2026-02-16 00:00:00' AND `cust_txn_initiate_datetime` <= '2026-02-16 23:59:59' AND `response_code` = 1 GROUP BY `cust_id` ORDER BY `amount` DESC LIMIT 10 [binds:protected] => Array ( [cust_txn_initiate_datetime] => Array ( [0] => 2026-02-16 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2026-02-16 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1771227958.2478 [endTime:protected] => 1771227958.2771 [errorCode:protected] => [errorString:protected] => [db] => CodeIgniter\Database\MySQLi\Connection Object ( [DSN:protected] => [port:protected] => 3306 [hostname:protected] => localhost [username:protected] => rpdevelopment [password:protected] => rpdevelopment [database:protected] => runpaisa_new [DBDriver] => MySQLi [subdriver:protected] => [DBPrefix:protected] => [pConnect:protected] => [DBDebug:protected] => [charset:protected] => utf8 [DBCollat:protected] => utf8_general_ci [swapPre:protected] => [encrypt:protected] => [compress:protected] => [strictOn:protected] => [failover:protected] => Array ( ) [lastQuery:protected] => CodeIgniter\Database\Query Object *RECURSION* [connID] => mysqli Object ( [affected_rows] => 0 [client_info] => mysqlnd 8.1.2-1ubuntu2.18 [client_version] => 80102 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 2 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 8.0.37-0ubuntu0.22.04.3 [server_version] => 80037 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1053 [warning_count] => 0 ) [resultID] => mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 0 [type] => 0 ) [protectIdentifiers] => 1 [reservedIdentifiers:protected] => Array ( [0] => * ) [escapeChar] => ` [likeEscapeStr] => ESCAPE '%s' [likeEscapeChar] => ! [pregEscapeChar:protected] => Array ( [1] => ` [0] => ` [3] => ` [2] => ` ) [dataCache] => Array ( ) [connectTime:protected] => 1771227958.2473 [connectDuration:protected] => 0.00052881240844727 [pretend:protected] => [transEnabled] => 1 [transStrict] => 1 [transDepth:protected] => 0 [transStatus:protected] => 1 [transFailure:protected] => [aliasedTables:protected] => Array ( ) [queryClass:protected] => CodeIgniter\Database\Query [deleteHack] => 1 [mysqli] => mysqli Object ( [affected_rows] => 0 [client_info] => mysqlnd 8.1.2-1ubuntu2.18 [client_version] => 80102 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 2 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 8.0.37-0ubuntu0.22.04.3 [server_version] => 80037 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1053 [warning_count] => 0 ) [resultMode] => 0 ) )