CRITICAL - 2026-09-08 13:09:11 --> Undefined array key "messages" in APPPATH/Controllers/Member/Member.php on line 608. 1 APPPATH/Controllers/Member/Member.php(608): 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-09-08 13:09:37 --> Undefined array key "messages" in APPPATH/Controllers/Member/Member.php on line 608. 1 APPPATH/Controllers/Member/Member.php(608): 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-09-08 13:14:38 --> Undefined array key "messages" in APPPATH/Controllers/Member/Member.php on line 608. 1 APPPATH/Controllers/Member/Member.php(608): 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-09-08 13:19:52 --> Undefined array key "messages" in APPPATH/Controllers/Member/Member.php on line 608. 1 APPPATH/Controllers/Member/Member.php(608): 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-09-08 13:31:33 --> Undefined array key "messages" in APPPATH/Controllers/Member/Member.php on line 608. 1 APPPATH/Controllers/Member/Member.php(608): 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-09-08 13:35:34 --> Undefined array key "messages" in APPPATH/Controllers/Member/Member.php on line 608. 1 APPPATH/Controllers/Member/Member.php(608): 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-09-08 13:39:08 --> FIle Upload Response : {"status":400,"error":400,"messages":{"error":"File type not allowed. Allowed types: application/pdf, image/jpeg, image/jpg, image/png, image/gif"}} ERROR - 2026-09-08 13:40:55 --> FIle Upload Response : {"status":400,"error":400,"messages":{"error":"File type not allowed. Allowed types: application/pdf, image/jpeg, image/jpg, image/png, image/gif"}} ERROR - 2026-09-08 14:10:28 --> FIle Upload Response : {"status":400,"error":400,"messages":{"error":"File type not allowed. Allowed types: application/pdf, image/jpeg, image/jpg, image/png, image/gif"}} CRITICAL - 2026-09-08 14:24:14 --> Call to undefined function App\Controllers\Admin\AesDecryption() in APPPATH/Controllers/Admin/Admin.php on line 7087. 1 SYSTEMPATH/CodeIgniter.php(927): App\Controllers\Admin\Admin->partnerconfiguration() 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 - 2026-09-08 14:24:54 --> 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-09-08 00:00:00' AND `cust_txn_initiate_datetime` <= '2026-09-08 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-09-08 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2026-09-08 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1788857694.4532 [endTime:protected] => 1788857694.4672 [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.25 [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.46-0ubuntu0.22.04.4 [server_version] => 80046 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 370 [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] => 1788857694.4526 [connectDuration:protected] => 0.00057291984558105 [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.25 [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.46-0ubuntu0.22.04.4 [server_version] => 80046 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 370 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2026-09-08 19:58:48 --> Get Merchant Balance Api Response: {"code":"RP000","status":"SUCCESS","errors":[],"message":"Fetched Successfully","data":{"total_balance":6005124354.774}} ERROR - 2026-09-08 19:58:57 --> 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-09-08 19:58:58 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 974 [recordsFiltered] => 974 [data] => Array ( [0] => Array ( [merchant_order_id] => ordererti00023 [order_id] => 1rppd30cb2382c1c96d06571d133f796 [merchant_id] => 1 [partner_payout_id] => 260727133623544039 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:36:12 [status] => CREATED [utrno] => ) [1] => Array ( [merchant_order_id] => ordererti00022 [order_id] => 1rpp128948cffc981e58937bb73f3527 [merchant_id] => 1 [partner_payout_id] => 260727133516241290 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:35:12 [status] => CREATED [utrno] => ) [2] => Array ( [merchant_order_id] => ordererti00021 [order_id] => 1rpp9509cfc5648bb35cc1a371f8126f [merchant_id] => 1 [partner_payout_id] => 260727133502149715 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:34:22 [status] => CREATED [utrno] => ) [3] => Array ( [merchant_order_id] => ordererti00020 [order_id] => 1rppfab1676717ed223413d7ced4eea4 [merchant_id] => 1 [partner_payout_id] => 260727132348072788 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:23:35 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => ordererti00019 [order_id] => 1rppe03fe06e63e5c1c2a74b5e7a8b5a [merchant_id] => 1 [partner_payout_id] => 260727131502914614 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:14:35 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => ET000000000000014 [order_id] => 442rpp2570460cc9cb4af1a140c8936eec [merchant_id] => 442 [partner_payout_id] => [amount] => 105 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-07-24 17:17:07 [status] => CREATED [utrno] => ) [6] => Array ( [merchant_order_id] => ET000000000000013 [order_id] => 442rpp56e5ff221ce85d22e127621fd3ef [merchant_id] => 442 [partner_payout_id] => [amount] => 100 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-07-24 17:15:57 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => ET000000000000012 [order_id] => 442rpp57e4f0d9208d2b0b9d6415f922db [merchant_id] => 442 [partner_payout_id] => [amount] => 100 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-07-24 17:11:03 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => ET000000000000011 [order_id] => 442rpp1de5e166a95b3154c69d1f7f3d7d [merchant_id] => 442 [partner_payout_id] => [amount] => 101 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-07-24 16:53:56 [status] => CREATED [utrno] => ) [9] => Array ( [merchant_order_id] => ordererti00018 [order_id] => 1rppddc952ff2c502886a3417f681658 [merchant_id] => 1 [partner_payout_id] => 260724153408768422 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-24 15:33:39 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2026-09-08 19:59:26 --> 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-09-08 19:59:27 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 974 [recordsFiltered] => 974 [data] => Array ( [0] => Array ( [merchant_order_id] => ordererti00023 [order_id] => 1rppd30cb2382c1c96d06571d133f796 [merchant_id] => 1 [partner_payout_id] => 260727133623544039 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:36:12 [status] => CREATED [utrno] => ) [1] => Array ( [merchant_order_id] => ordererti00022 [order_id] => 1rpp128948cffc981e58937bb73f3527 [merchant_id] => 1 [partner_payout_id] => 260727133516241290 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:35:12 [status] => CREATED [utrno] => ) [2] => Array ( [merchant_order_id] => ordererti00021 [order_id] => 1rpp9509cfc5648bb35cc1a371f8126f [merchant_id] => 1 [partner_payout_id] => 260727133502149715 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:34:22 [status] => CREATED [utrno] => ) [3] => Array ( [merchant_order_id] => ordererti00020 [order_id] => 1rppfab1676717ed223413d7ced4eea4 [merchant_id] => 1 [partner_payout_id] => 260727132348072788 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:23:35 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => ordererti00019 [order_id] => 1rppe03fe06e63e5c1c2a74b5e7a8b5a [merchant_id] => 1 [partner_payout_id] => 260727131502914614 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:14:35 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => ET000000000000014 [order_id] => 442rpp2570460cc9cb4af1a140c8936eec [merchant_id] => 442 [partner_payout_id] => [amount] => 105 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-07-24 17:17:07 [status] => CREATED [utrno] => ) [6] => Array ( [merchant_order_id] => ET000000000000013 [order_id] => 442rpp56e5ff221ce85d22e127621fd3ef [merchant_id] => 442 [partner_payout_id] => [amount] => 100 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-07-24 17:15:57 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => ET000000000000012 [order_id] => 442rpp57e4f0d9208d2b0b9d6415f922db [merchant_id] => 442 [partner_payout_id] => [amount] => 100 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-07-24 17:11:03 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => ET000000000000011 [order_id] => 442rpp1de5e166a95b3154c69d1f7f3d7d [merchant_id] => 442 [partner_payout_id] => [amount] => 101 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-07-24 16:53:56 [status] => CREATED [utrno] => ) [9] => Array ( [merchant_order_id] => ordererti00018 [order_id] => 1rppddc952ff2c502886a3417f681658 [merchant_id] => 1 [partner_payout_id] => 260724153408768422 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-24 15:33:39 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2026-09-08 19:59:31 --> 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] => 970 ) ERROR - 2026-09-08 19:59:31 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 974 [recordsFiltered] => 974 [data] => Array ( [0] => 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] => ) [1] => 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] => ) [2] => 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] => ) [3] => 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-09-08 19:59:43 --> 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-09-08 19:59:43 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 974 [recordsFiltered] => 974 [data] => Array ( [0] => Array ( [merchant_order_id] => ordererti00023 [order_id] => 1rppd30cb2382c1c96d06571d133f796 [merchant_id] => 1 [partner_payout_id] => 260727133623544039 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:36:12 [status] => CREATED [utrno] => ) [1] => Array ( [merchant_order_id] => ordererti00022 [order_id] => 1rpp128948cffc981e58937bb73f3527 [merchant_id] => 1 [partner_payout_id] => 260727133516241290 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:35:12 [status] => CREATED [utrno] => ) [2] => Array ( [merchant_order_id] => ordererti00021 [order_id] => 1rpp9509cfc5648bb35cc1a371f8126f [merchant_id] => 1 [partner_payout_id] => 260727133502149715 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:34:22 [status] => CREATED [utrno] => ) [3] => Array ( [merchant_order_id] => ordererti00020 [order_id] => 1rppfab1676717ed223413d7ced4eea4 [merchant_id] => 1 [partner_payout_id] => 260727132348072788 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:23:35 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => ordererti00019 [order_id] => 1rppe03fe06e63e5c1c2a74b5e7a8b5a [merchant_id] => 1 [partner_payout_id] => 260727131502914614 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:14:35 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => ET000000000000014 [order_id] => 442rpp2570460cc9cb4af1a140c8936eec [merchant_id] => 442 [partner_payout_id] => [amount] => 105 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-07-24 17:17:07 [status] => CREATED [utrno] => ) [6] => Array ( [merchant_order_id] => ET000000000000013 [order_id] => 442rpp56e5ff221ce85d22e127621fd3ef [merchant_id] => 442 [partner_payout_id] => [amount] => 100 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-07-24 17:15:57 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => ET000000000000012 [order_id] => 442rpp57e4f0d9208d2b0b9d6415f922db [merchant_id] => 442 [partner_payout_id] => [amount] => 100 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-07-24 17:11:03 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => ET000000000000011 [order_id] => 442rpp1de5e166a95b3154c69d1f7f3d7d [merchant_id] => 442 [partner_payout_id] => [amount] => 101 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-07-24 16:53:56 [status] => CREATED [utrno] => ) [9] => Array ( [merchant_order_id] => ordererti00018 [order_id] => 1rppddc952ff2c502886a3417f681658 [merchant_id] => 1 [partner_payout_id] => 260724153408768422 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-24 15:33:39 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2026-09-08 20:01:31 --> Transaction Transaction Payload Api data : Array ( [merchant_id] => [order_id] => [merchant_order_id] => 1f0c5796ebcceda201e [from_date] => [to_date] => [account_number] => [utr_no] => [status] => [length] => 10 [start] => 0 ) ERROR - 2026-09-08 20:01:31 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [0] => No Result Found ) ) ERROR - 2026-09-08 20:01:36 --> Transaction Transaction Payload Api data : Array ( [merchant_id] => [order_id] => 1f0c5796ebcceda201e [merchant_order_id] => [from_date] => [to_date] => [account_number] => [utr_no] => [status] => [length] => 10 [start] => 0 ) ERROR - 2026-09-08 20:01:36 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [0] => No Result Found ) ) ERROR - 2026-09-08 20:01:45 --> Transaction Transaction Payload Api data : Array ( [merchant_id] => [order_id] => 1wtpsvYEGjbisi4EsCa9X5hTfQGmyMOvFAkV [merchant_order_id] => [from_date] => [to_date] => [account_number] => [utr_no] => [status] => [length] => 10 [start] => 0 ) ERROR - 2026-09-08 20:01:46 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [0] => No Result Found ) ) ERROR - 2026-09-08 20:01:51 --> Transaction Transaction Payload Api data : Array ( [merchant_id] => [order_id] => [merchant_order_id] => 1wtpsvYEGjbisi4EsCa9X5hTfQGmyMOvFAkV [from_date] => [to_date] => [account_number] => [utr_no] => [status] => [length] => 10 [start] => 0 ) ERROR - 2026-09-08 20:01:51 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [0] => No Result Found ) ) ERROR - 2026-09-08 20:02:27 --> Transaction Transaction Payload Api data : Array ( [merchant_id] => [order_id] => [merchant_order_id] => [from_date] => [to_date] => [account_number] => [utr_no] => 1771928793879841 [status] => [length] => 10 [start] => 0 ) ERROR - 2026-09-08 20:02:27 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [0] => No Result Found ) ) ERROR - 2026-09-08 20:02:37 --> Transaction Transaction Payload Api data : Array ( [merchant_id] => [order_id] => [merchant_order_id] => [from_date] => [to_date] => [account_number] => [utr_no] => 665795276 [status] => [length] => 10 [start] => 0 ) ERROR - 2026-09-08 20:02:37 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [0] => No Result Found ) ) ERROR - 2026-09-08 20:03:32 --> 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-09-08 20:03:32 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 974 [recordsFiltered] => 974 [data] => Array ( [0] => Array ( [merchant_order_id] => ordererti00023 [order_id] => 1rppd30cb2382c1c96d06571d133f796 [merchant_id] => 1 [partner_payout_id] => 260727133623544039 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:36:12 [status] => CREATED [utrno] => ) [1] => Array ( [merchant_order_id] => ordererti00022 [order_id] => 1rpp128948cffc981e58937bb73f3527 [merchant_id] => 1 [partner_payout_id] => 260727133516241290 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:35:12 [status] => CREATED [utrno] => ) [2] => Array ( [merchant_order_id] => ordererti00021 [order_id] => 1rpp9509cfc5648bb35cc1a371f8126f [merchant_id] => 1 [partner_payout_id] => 260727133502149715 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:34:22 [status] => CREATED [utrno] => ) [3] => Array ( [merchant_order_id] => ordererti00020 [order_id] => 1rppfab1676717ed223413d7ced4eea4 [merchant_id] => 1 [partner_payout_id] => 260727132348072788 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:23:35 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => ordererti00019 [order_id] => 1rppe03fe06e63e5c1c2a74b5e7a8b5a [merchant_id] => 1 [partner_payout_id] => 260727131502914614 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-27 13:14:35 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => ET000000000000014 [order_id] => 442rpp2570460cc9cb4af1a140c8936eec [merchant_id] => 442 [partner_payout_id] => [amount] => 105 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-07-24 17:17:07 [status] => CREATED [utrno] => ) [6] => Array ( [merchant_order_id] => ET000000000000013 [order_id] => 442rpp56e5ff221ce85d22e127621fd3ef [merchant_id] => 442 [partner_payout_id] => [amount] => 100 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-07-24 17:15:57 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => ET000000000000012 [order_id] => 442rpp57e4f0d9208d2b0b9d6415f922db [merchant_id] => 442 [partner_payout_id] => [amount] => 100 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-07-24 17:11:03 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => ET000000000000011 [order_id] => 442rpp1de5e166a95b3154c69d1f7f3d7d [merchant_id] => 442 [partner_payout_id] => [amount] => 101 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-07-24 16:53:56 [status] => CREATED [utrno] => ) [9] => Array ( [merchant_order_id] => ordererti00018 [order_id] => 1rppddc952ff2c502886a3417f681658 [merchant_id] => 1 [partner_payout_id] => 260724153408768422 [amount] => 3000.13 [service_charge] => 6.1 [service_gst] => 1.098 [txn_dateTime] => 2026-07-24 15:33:39 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2026-09-08 20:03:40 --> 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] => 30 ) ERROR - 2026-09-08 20:03:40 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 974 [recordsFiltered] => 974 [data] => Array ( [0] => Array ( [merchant_order_id] => 26052896334358902 [order_id] => 369rpp45332d3c8edd3d28ac39fd52a336 [merchant_id] => 369 [partner_payout_id] => NA [amount] => 101 [service_charge] => NA [service_gst] => 0 [txn_dateTime] => 2026-05-28 15:45:43 [status] => CREATED [utrno] => ) [1] => Array ( [merchant_order_id] => 26052896095977802 [order_id] => 369rpp83d376c0a3e3b9d57cfdc7c58a6a [merchant_id] => 369 [partner_payout_id] => [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2026-05-28 15:06:00 [status] => CREATED [utrno] => ) [2] => Array ( [merchant_order_id] => 26052679321351302 [order_id] => 369rpp3ae108a25edff6846a034c9de14b [merchant_id] => 369 [partner_payout_id] => [amount] => 101 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2026-05-26 16:30:14 [status] => CREATED [utrno] => ) [3] => 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] => ) [4] => 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] => ) [5] => 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] => ) [6] => 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] => ) [7] => 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] => ) [8] => 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] => ) [9] => 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] => ) ) ) ) ERROR - 2026-09-08 20:03:47 --> Transaction Transaction Payload Api data : Array ( [merchant_id] => [order_id] => [merchant_order_id] => [from_date] => [to_date] => [account_number] => [utr_no] => [status] => SUCCESS [length] => 10 [start] => 0 ) ERROR - 2026-09-08 20:03:47 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 6 [recordsFiltered] => 6 [data] => Array ( [0] => Array ( [merchant_order_id] => 190104678192259 [order_id] => 400rpp1a72117711491b1874c654383e3e2d [merchant_id] => 400 [partner_payout_id] => pout_QnlsNcCAlRLPBF [amount] => 13 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-07-01 14:58:51 [status] => SUCCESS [utrno] => QnlsNcCAlRLPBF ) [1] => Array ( [merchant_order_id] => 190104671730463 [order_id] => 400rppf0a91cc5f9395df13c2295f3484bda [merchant_id] => 400 [partner_payout_id] => pout_QnlsKe7BaW2qnY [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-07-01 14:50:45 [status] => SUCCESS [utrno] => QnlsKe7BaW2qnY ) [2] => Array ( [merchant_order_id] => 551b4a35fbc645a5b610b32b9ea11921 [order_id] => 393rppabda029ae80359974483856420e944 [merchant_id] => 393 [partner_payout_id] => pout_QmD1P2FpJ9SVri [amount] => 10 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-06-27 15:08:10 [status] => SUCCESS [utrno] => QmD1P2FpJ9SVri ) [3] => Array ( [merchant_order_id] => order657195067244999459148399560 [order_id] => 398rppe791f10e6eb3400f8f89962585f92 [merchant_id] => 398 [partner_payout_id] => pout_QnnHctIVvItMIb [amount] => 80 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-06-25 15:22:07 [status] => SUCCESS [utrno] => QnnHctIVvItMIb ) [4] => Array ( [merchant_order_id] => order000212345678900002123456789005 [order_id] => 339rpp5237bda431790fe96668e265245bdc23 [merchant_id] => 339 [partner_payout_id] => NA [amount] => 2000 [service_charge] => 343 [service_gst] => 61.74 [txn_dateTime] => 2025-04-08 15:33:28 [status] => SUCCESS [utrno] => ) [5] => 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-09-08 20:04:14 --> 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-09-08 20:04:21 --> Get Ledger Report API Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 1679 [recordsFiltered] => 1679 [data] => Array ( [0] => Array ( [order_id] => 1rppd30cb2382c1c96d06571d133f796 [merchant_id] => 1 [opening_balance] => 2999838801.222 [credit_balance] => 0 [debit_balance] => 3007.328 [txn_dateTime] => 2026-07-27 13:36:21 [closing_balance] => 2999835793.894 [txn_type] => IMPS [txn_message] => Payout transaction ) [1] => Array ( [order_id] => 1rpp128948cffc981e58937bb73f3527 [merchant_id] => 1 [opening_balance] => 2999841808.55 [credit_balance] => 0 [debit_balance] => 3007.328 [txn_dateTime] => 2026-07-27 13:35:16 [closing_balance] => 2999838801.222 [txn_type] => IMPS [txn_message] => Payout transaction ) [2] => Array ( [order_id] => 1rpp9509cfc5648bb35cc1a371f8126f [merchant_id] => 1 [opening_balance] => 2999844815.878 [credit_balance] => 0 [debit_balance] => 3007.328 [txn_dateTime] => 2026-07-27 13:35:01 [closing_balance] => 2999841808.55 [txn_type] => IMPS [txn_message] => Payout transaction ) [3] => Array ( [order_id] => 1rppfab1676717ed223413d7ced4eea4 [merchant_id] => 1 [opening_balance] => 2999847823.206 [credit_balance] => 0 [debit_balance] => 3007.328 [txn_dateTime] => 2026-07-27 13:23:45 [closing_balance] => 2999844815.878 [txn_type] => IMPS [txn_message] => Payout transaction ) [4] => Array ( [order_id] => 1rppe03fe06e63e5c1c2a74b5e7a8b5a [merchant_id] => 1 [opening_balance] => 2999850830.534 [credit_balance] => 0 [debit_balance] => 3007.328 [txn_dateTime] => 2026-07-27 13:15:02 [closing_balance] => 2999847823.206 [txn_type] => IMPS [txn_message] => Payout transaction ) [5] => Array ( [order_id] => 442payoutb915f3f2b433720f5e6938406fa8e3d1 [merchant_id] => 442 [opening_balance] => 0 [credit_balance] => 1000 [debit_balance] => 0 [txn_dateTime] => 2026-07-24 16:09:37 [closing_balance] => 1000 [txn_type] => Fund Request [txn_message] => Fund Request Approved ) [6] => Array ( [order_id] => 1rppddc952ff2c502886a3417f681658 [merchant_id] => 1 [opening_balance] => 2999853837.862 [credit_balance] => 0 [debit_balance] => 3007.328 [txn_dateTime] => 2026-07-24 15:34:08 [closing_balance] => 2999850830.534 [txn_type] => IMPS [txn_message] => Payout transaction ) [7] => Array ( [order_id] => 1rpp570b04ecd2da51729e7f9883fe48 [merchant_id] => 1 [opening_balance] => 2999856845.19 [credit_balance] => 0 [debit_balance] => 3007.328 [txn_dateTime] => 2026-07-24 15:31:16 [closing_balance] => 2999853837.862 [txn_type] => IMPS [txn_message] => Payout transaction ) [8] => Array ( [order_id] => 1rppa98d59b5490a964590175b04915f [merchant_id] => 1 [opening_balance] => 2999853837.862 [credit_balance] => 3007.328 [debit_balance] => 0 [txn_dateTime] => 2026-07-24 15:29:48 [closing_balance] => 2999856845.19 [txn_type] => IMPS [txn_message] => Payout refund ) [9] => Array ( [order_id] => 1rppa98d59b5490a964590175b04915f [merchant_id] => 1 [opening_balance] => 2999856845.19 [credit_balance] => 0 [debit_balance] => 3007.328 [txn_dateTime] => 2026-07-24 15:29:47 [closing_balance] => 2999853837.862 [txn_type] => IMPS [txn_message] => Payout transaction ) ) ) ) ERROR - 2026-09-08 20:04:36 --> Get History Ledger Transaction Report API Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 6 [recordsFiltered] => 6 [data] => Array ( [0] => Array ( [order_id] => 175rppe8f3c6a80f3e697e1d420ddac17dc491 [merchant_id] => 175 [opening_balance] => 495971.68 [credit_balance] => 0 [debit_balance] => 1007.08 [txn_dateTime] => 2024-09-04 16:05:14 [closing_balance] => 494964.6 [txn_type] => IMPS ) [1] => Array ( [order_id] => 175rppe212bff785da7bc4ded96eaff5057c3f [merchant_id] => 175 [opening_balance] => 496978.76 [credit_balance] => 0 [debit_balance] => 1007.08 [txn_dateTime] => 2024-09-04 16:05:12 [closing_balance] => 495971.68 [txn_type] => IMPS ) [2] => Array ( [order_id] => 175rpp5c9b97bb03bc5a6564424fa2810f6187 [merchant_id] => 175 [opening_balance] => 497985.84 [credit_balance] => 0 [debit_balance] => 1007.08 [txn_dateTime] => 2024-09-04 16:05:09 [closing_balance] => 496978.76 [txn_type] => IMPS ) [3] => Array ( [order_id] => 175rpp0ff2622f2e8051c7b187954cc2d9c75c [merchant_id] => 175 [opening_balance] => 498992.92 [credit_balance] => 0 [debit_balance] => 1007.08 [txn_dateTime] => 2024-09-04 16:05:06 [closing_balance] => 497985.84 [txn_type] => IMPS ) [4] => Array ( [order_id] => 175rppab4b287bdd4d1913cce0712a69fd5a34 [merchant_id] => 175 [opening_balance] => 500000 [credit_balance] => 0 [debit_balance] => 1007.08 [txn_dateTime] => 2024-09-04 16:05:03 [closing_balance] => 498992.92 [txn_type] => IMPS ) [5] => Array ( [order_id] => 175payoute24587dd757df2a8c2fd6ed8d914d2af [merchant_id] => 175 [opening_balance] => 0 [credit_balance] => 500000 [debit_balance] => 0 [txn_dateTime] => 2024-09-04 13:23:47 [closing_balance] => 500000 [txn_type] => Fund Request ) ) ) ) ERROR - 2026-09-08 20:04:44 --> 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 [partner_payout_id] => pout_Ot5AiQgerHQ53W [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 [partner_payout_id] => pout_Ot5AfvcXhl78xa [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2024-09-04 07:55:10 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2026-09-08 20:07:22 --> 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-09-08' ERROR - 2026-09-08 20:07:22 --> 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-09-08' ORDER BY `id` DESC LIMIT 10 ERROR - 2026-09-08 20:07:40 --> 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-09-08' ERROR - 2026-09-08 20:07:40 --> 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-09-08' ORDER BY `id` DESC LIMIT 10