ERROR - 2025-12-10 11:43:29 --> 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` >= '2025-12-10 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-10 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] => 2025-12-10 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-10 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1765347209.3859 [endTime:protected] => 1765347209.4828 [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] => 26 [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] => 1765347209.3851 [connectDuration:protected] => 0.00072693824768066 [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] => 26 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2025-12-10 12:19:50 --> 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` >= '2025-12-10 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-10 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] => 2025-12-10 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-10 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1765349390.6897 [endTime:protected] => 1765349390.7244 [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] => 1 [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] => 110 [warning_count] => 0 ) [resultID] => mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 1 [type] => 0 ) [protectIdentifiers] => 1 [reservedIdentifiers:protected] => Array ( [0] => * ) [escapeChar] => ` [likeEscapeStr] => ESCAPE '%s' [likeEscapeChar] => ! [pregEscapeChar:protected] => Array ( [1] => ` [0] => ` [3] => ` [2] => ` ) [dataCache] => Array ( ) [connectTime:protected] => 1765349390.6888 [connectDuration:protected] => 0.00085806846618652 [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] => 1 [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] => 110 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2025-12-10 12:20:12 --> 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` >= '2025-12-10 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-10 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] => 2025-12-10 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-10 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1765349412.5183 [endTime:protected] => 1765349412.5468 [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] => 1 [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] => 113 [warning_count] => 0 ) [resultID] => mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 1 [type] => 0 ) [protectIdentifiers] => 1 [reservedIdentifiers:protected] => Array ( [0] => * ) [escapeChar] => ` [likeEscapeStr] => ESCAPE '%s' [likeEscapeChar] => ! [pregEscapeChar:protected] => Array ( [1] => ` [0] => ` [3] => ` [2] => ` ) [dataCache] => Array ( ) [connectTime:protected] => 1765349412.5175 [connectDuration:protected] => 0.00077700614929199 [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] => 1 [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] => 113 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2025-12-10 12:45:09 --> 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 - 2025-12-10 12:58:57 --> 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 - 2025-12-10 13:15:25 --> 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` >= '2025-12-10 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-10 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] => 2025-12-10 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-10 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1765352725.2938 [endTime:protected] => 1765352725.3177 [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] => 1 [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] => 211 [warning_count] => 0 ) [resultID] => mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 1 [type] => 0 ) [protectIdentifiers] => 1 [reservedIdentifiers:protected] => Array ( [0] => * ) [escapeChar] => ` [likeEscapeStr] => ESCAPE '%s' [likeEscapeChar] => ! [pregEscapeChar:protected] => Array ( [1] => ` [0] => ` [3] => ` [2] => ` ) [dataCache] => Array ( ) [connectTime:protected] => 1765352725.2931 [connectDuration:protected] => 0.00069904327392578 [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] => 1 [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] => 211 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2025-12-10 14:28:16 --> 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` >= '2025-12-10 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-10 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] => 2025-12-10 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-10 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1765357096.0092 [endTime:protected] => 1765357096.0335 [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] => 1 [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] => 274 [warning_count] => 0 ) [resultID] => mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 1 [type] => 0 ) [protectIdentifiers] => 1 [reservedIdentifiers:protected] => Array ( [0] => * ) [escapeChar] => ` [likeEscapeStr] => ESCAPE '%s' [likeEscapeChar] => ! [pregEscapeChar:protected] => Array ( [1] => ` [0] => ` [3] => ` [2] => ` ) [dataCache] => Array ( ) [connectTime:protected] => 1765357096.0083 [connectDuration:protected] => 0.00081396102905273 [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] => 1 [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] => 274 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2025-12-10 14:42: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` >= '2025-12-10 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-10 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] => 2025-12-10 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-10 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1765357978.1821 [endTime:protected] => 1765357978.1979 [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] => 1 [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] => 307 [warning_count] => 0 ) [resultID] => mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 1 [type] => 0 ) [protectIdentifiers] => 1 [reservedIdentifiers:protected] => Array ( [0] => * ) [escapeChar] => ` [likeEscapeStr] => ESCAPE '%s' [likeEscapeChar] => ! [pregEscapeChar:protected] => Array ( [1] => ` [0] => ` [3] => ` [2] => ` ) [dataCache] => Array ( ) [connectTime:protected] => 1765357978.1813 [connectDuration:protected] => 0.00076198577880859 [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] => 1 [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] => 307 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2025-12-10 15:00:34 --> 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-12-10' ERROR - 2025-12-10 15:00:34 --> 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-12-10' ORDER BY `id` DESC LIMIT 10 ERROR - 2025-12-10 16:19:03 --> 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(387): CodeIgniter\Database\BaseConnection->query() #4 /var/www/html/adminrunpaisa/app/Controllers/Member/Member.php(3205): App\Models\Member\MemberModel->getRetailerDMTlist() #5 /var/www/html/adminrunpaisa/system/CodeIgniter.php(927): App\Controllers\Member\Member->showRetailersDMTList() #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(387): CodeIgniter\Database\BaseConnection->query() #3 /var/www/html/adminrunpaisa/app/Controllers/Member/Member.php(3205): App\Models\Member\MemberModel->getRetailerDMTlist() #4 /var/www/html/adminrunpaisa/system/CodeIgniter.php(927): App\Controllers\Member\Member->showRetailersDMTList() #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-12-10 16:19:03 --> 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(387): CodeIgniter\Database\BaseConnection->query() 3 APPPATH/Controllers/Member/Member.php(3205): App\Models\Member\MemberModel->getRetailerDMTlist() 4 SYSTEMPATH/CodeIgniter.php(927): App\Controllers\Member\Member->showRetailersDMTList() 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-12-10 16:19: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(3873): App\Models\Member\MemberModel->getMemberDetails() #5 /var/www/html/adminrunpaisa/system/CodeIgniter.php(927): App\Controllers\Member\Member->activeservices() #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(3873): App\Models\Member\MemberModel->getMemberDetails() #4 /var/www/html/adminrunpaisa/system/CodeIgniter.php(927): App\Controllers\Member\Member->activeservices() #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-12-10 16:19: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(3873): App\Models\Member\MemberModel->getMemberDetails() 4 SYSTEMPATH/CodeIgniter.php(927): App\Controllers\Member\Member->activeservices() 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-12-10 17:07: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') = '2025-12-10' ERROR - 2025-12-10 17:07: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') = '2025-12-10' ORDER BY `id` DESC LIMIT 10 ERROR - 2025-12-10 17:11:42 --> 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` >= '2025-12-10 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-10 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] => 2025-12-10 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-10 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1765366902.3305 [endTime:protected] => 1765366902.3565 [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] => 1 [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] => 104 [warning_count] => 0 ) [resultID] => mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 1 [type] => 0 ) [protectIdentifiers] => 1 [reservedIdentifiers:protected] => Array ( [0] => * ) [escapeChar] => ` [likeEscapeStr] => ESCAPE '%s' [likeEscapeChar] => ! [pregEscapeChar:protected] => Array ( [1] => ` [0] => ` [3] => ` [2] => ` ) [dataCache] => Array ( ) [connectTime:protected] => 1765366902.3297 [connectDuration:protected] => 0.00074100494384766 [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] => 1 [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] => 104 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2025-12-10 17:13:27 --> 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-12-10' ERROR - 2025-12-10 17:13:27 --> 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-12-10' ORDER BY `id` DESC LIMIT 10 ERROR - 2025-12-10 17:15:40 --> Get Sql Query history filter All payout Report : SELECT `order_id`, `agent_id`, `distributor_id`, `amount`, `time`, `status`, `FUNDTRANSNO` FROM `oz_money_transfer_history` WHERE DATE_FORMAT(time,'%Y-%m-%d') >= '2025-10-09' AND DATE_FORMAT(time,'%Y-%m-%d') <= '2025-12-09' ORDER BY `time` DESC LIMIT 10 ERROR - 2025-12-10 17:16:09 --> Get Sql Query Archive filter Count transaction Report : SELECT COUNT(txn_id) AS total_count_data FROM `oz_money_trnx_archive` ERROR - 2025-12-10 17:16:09 --> Get Sql Query Archive filter All transaction Report : SELECT `txn_id`, `txn_order_id`, `txn_agentid`, `txn_opbal`, `txn_crdt`, `txn_dbdt`, `txn_clbal`, `txn_checktime`, `txn_type`, `txn_time`, `txn_date`, `txn_ip`, `txn_comment` FROM `oz_money_trnx_archive` ORDER BY `txn_id` DESC LIMIT 10 ERROR - 2025-12-10 17:16:36 --> Get Sql Query archive filter count payout Report : SELECT COUNT(id) AS total_count_fund_data FROM `oz_money_transfer_archive` ERROR - 2025-12-10 17:16:36 --> Get Sql Query archive filter All payout Report : SELECT `id`, `order_id`, `agent_id`, `distributor_id`, `info`, `status`, `time`, `update_time`, `amount`, `com_amount`, `cashback`, `retailer_com`, `retailer_gst`, `retailer_tds`, `distributor_com`, `distributor_gst`, `distributor_tds`, `api_com`, `api_gst`, `admin_com`, `resp`, `ip`, `callbackresp`, `checksum`, `payout_id`, `FUNDTRANSNO`, `payout_partner`, `txn_mode`, `merchant_info` FROM `oz_money_transfer_archive` ORDER BY `id` DESC LIMIT 10 ERROR - 2025-12-10 17:19:08 --> Get Today Earning Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2025-12-10 17:19:08 --> get today earning response: Array ( [code] => RP001 [status] => FAILED [errors] => Array ( [0] => Data not found ) [message] => Data not found [data] => Array ( ) ) ERROR - 2025-12-10 17:19:08 --> Get Monthly Earning Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2025-12-10 17:19:08 --> Get Today Revenue Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2025-12-10 17:19:08 --> Get Monthly Revenue Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2025-12-10 17:19:13 --> Get Merchant Balance Api Response: {"code":"RP000","status":"SUCCESS","errors":[],"message":"Fetched Successfully","data":{"total_balance":6005279731.49}}