ERROR - 2025-12-08 12:40:17 --> 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-08 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-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] => 2025-12-08 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-08 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1765177817.1067 [endTime:protected] => 1765177817.2138 [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] => 96 [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] => 1765177817.1059 [connectDuration:protected] => 0.00074887275695801 [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] => 96 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2025-12-08 12:53:28 --> 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-08 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-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] => 2025-12-08 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-08 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1765178608.5753 [endTime:protected] => 1765178608.5844 [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] => 122 [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] => 1765178608.5745 [connectDuration:protected] => 0.00073814392089844 [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] => 122 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2025-12-08 13:15:09 --> 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-08 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-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] => 2025-12-08 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-08 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1765179909.0654 [endTime:protected] => 1765179909.0947 [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] => 181 [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] => 1765179909.0644 [connectDuration:protected] => 0.00088691711425781 [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] => 181 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2025-12-08 13:22:09 --> GET BBPS MERCHANT CHARGES DATA RESPONSE : ERROR - 2025-12-08 13:22:13 --> Get Merchant Balance Response : {"code":"RP000","status":"SUCCESS","errors":[],"message":"Success","data":{"code":"RP001","status":"FAILED","message":"Something went wrong. Please try again.","data":[]}} ERROR - 2025-12-08 13:22:13 --> Get Admin Merchant Balance:Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Success [data] => Array ( [code] => RP001 [status] => FAILED [message] => Something went wrong. Please try again. [data] => Array ( ) ) ) ERROR - 2025-12-08 13:22:19 --> Payout charges data: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Success [data] => Array ( [0] => Array ( [default_charge_id] => 3 [transaction_type] => imps [charge] => 10 [min_amount] => 25001 [max_amount] => 200000 ) [1] => Array ( [default_charge_id] => 2 [transaction_type] => imps [charge] => 342 [min_amount] => 1001 [max_amount] => 25000 ) [2] => Array ( [default_charge_id] => 1 [transaction_type] => imps [charge] => 6 [min_amount] => 1 [max_amount] => 1000 ) ) ) ERROR - 2025-12-08 13:22:19 --> Array data: Array ( [0] => Array ( [default_charge_id] => 3 [transaction_type] => imps [charge] => 10 [min_amount] => 25001 [max_amount] => 200000 ) [1] => Array ( [default_charge_id] => 2 [transaction_type] => imps [charge] => 342 [min_amount] => 1001 [max_amount] => 25000 ) [2] => Array ( [default_charge_id] => 1 [transaction_type] => imps [charge] => 6 [min_amount] => 1 [max_amount] => 1000 ) ) CRITICAL - 2025-12-08 14:14:31 --> 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(532): 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 - 2025-12-08 14:52:49 --> 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-08' ERROR - 2025-12-08 14:52:49 --> 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-08' ORDER BY `id` DESC LIMIT 10 ERROR - 2025-12-08 14:54: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-08 14:54: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-08 15:02:11 --> 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-08 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-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] => 2025-12-08 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-08 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1765186331.4778 [endTime:protected] => 1765186331.4909 [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] => 132 [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] => 1765186331.4769 [connectDuration:protected] => 0.00083208084106445 [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] => 132 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2025-12-08 15:03:34 --> Get Today Earning Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2025-12-08 15:03:34 --> get today earning response: Array ( [code] => RP001 [status] => FAILED [errors] => Array ( [0] => Data not found ) [message] => Data not found [data] => Array ( ) ) ERROR - 2025-12-08 15:03:34 --> Get Monthly Earning Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2025-12-08 15:03:34 --> Get Today Revenue Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2025-12-08 15:03:34 --> Get Monthly Revenue Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2025-12-08 15:03:41 --> Get Merchant Balance Api Response: {"code":"RP000","status":"SUCCESS","errors":[],"message":"Fetched Successfully","data":{"total_balance":6005279731.49}} ERROR - 2025-12-08 15:04:50 --> 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 - 2025-12-08 15:05:55 --> Get Today Earning Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2025-12-08 15:05:55 --> get today earning response: Array ( [code] => RP001 [status] => FAILED [errors] => Array ( [0] => Data not found ) [message] => Data not found [data] => Array ( ) ) ERROR - 2025-12-08 15:05:55 --> Get Monthly Earning Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2025-12-08 15:05:55 --> Get Today Revenue Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2025-12-08 15:05:55 --> Get Monthly Revenue Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2025-12-08 15:06:04 --> 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 - 2025-12-08 15:06:04 --> Get Transaction Report Api Response: Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Data fetched successfully. [data] => Array ( [recordsTotal] => 934 [recordsFiltered] => 934 [data] => Array ( [0] => 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] => ) [1] => 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] => ) [2] => 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] => ) [3] => Array ( [merchant_order_id] => GP25101307289626DC [order_id] => 403rpp9a7e36eac12af443f28451c32be7 [merchant_id] => 403 [partner_payout_id] => pout_RSsKis38Dj8vFS [amount] => 1001 [service_charge] => 342 [service_gst] => 61.56 [txn_dateTime] => 2025-10-13 12:58:11 [status] => CREATED [utrno] => ) [4] => Array ( [merchant_order_id] => GP2509090628415470 [order_id] => 403rpp21c1c2de070e59e2ea022e97ff8d [merchant_id] => 403 [partner_payout_id] => pout_RFP9QYv4yCEMBy [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-09-09 11:58:16 [status] => CREATED [utrno] => ) [5] => Array ( [merchant_order_id] => BPay5126176913 [order_id] => 413rppa23afcd9f01d0de953a0fd253742 [merchant_id] => 413 [partner_payout_id] => pout_RF6kQHE6kcBdea [amount] => 101 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-09-08 17:55:25 [status] => CREATED [utrno] => ) [6] => Array ( [merchant_order_id] => BPay7677774612 [order_id] => 413rppd450e940d2da7103b7fd76a21783 [merchant_id] => 413 [partner_payout_id] => pout_RF6f883DugDXGe [amount] => 105 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-09-08 17:53:41 [status] => CREATED [utrno] => ) [7] => Array ( [merchant_order_id] => BPay8812876907 [order_id] => 413rpp8d482602fcfb4f627062dab311b9 [merchant_id] => 413 [partner_payout_id] => pout_RF6f883DugDXGe [amount] => 100 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-09-08 17:51:44 [status] => CREATED [utrno] => ) [8] => Array ( [merchant_order_id] => order1234567893 [order_id] => 413rpp6d4600aef46582b18ae68acaefe4 [merchant_id] => 413 [partner_payout_id] => pout_RF6UZOYy9KnovH [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-09-08 17:43:08 [status] => CREATED [utrno] => ) [9] => Array ( [merchant_order_id] => order1234567892 [order_id] => 413rppf1e3dc0cd487a0f33e820eb8b81c [merchant_id] => 413 [partner_payout_id] => pout_RF5DO7zw3Mpj9P [amount] => 1000 [service_charge] => 6 [service_gst] => 1.08 [txn_dateTime] => 2025-09-08 16:25:34 [status] => CREATED [utrno] => ) ) ) ) ERROR - 2025-12-08 15:09:09 --> Get BBPS Merchant Balance Api Response: {"code":"RP000","status":"SUCCESS","message":"Wallet balance generated.","totalBalance":"16729"} ERROR - 2025-12-08 15:09:09 --> Get BBPS API Balance Api Response: {"code":"RP000","status":"SUCCESS","message":"Api wallet balance generated.","totalBalance":"1998690"} ERROR - 2025-12-08 15:14:44 --> Get BBPS Transaction Report Api Response: {"code":"RP000","status":"SUCCESS","data":{"recordsTotal":"1268","recordsFiltered":"1268","data":[{"merchantId":"262","orderId":"66a2032f2e86frpbbps07aca710e908c45cb","billerId":"BSNL00000NATHL","billerName":"BSNL","custMobile":"1234567890","amount":"40","txn_dateTime":"2025-10-27 14:41:33","trxn_status":"initiate"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps04df6488937e21f2b","billerId":"BSNL00000NATHL","billerName":"BSNL","custMobile":"1234567890","amount":"73","txn_dateTime":"2025-10-13 14:20:10","trxn_status":"initiate"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps0513cd77d6099b6ca","billerId":"BSNL00000NATHL","billerName":"BSNL","custMobile":"1234567890","amount":"40","txn_dateTime":"2025-10-13 13:27:52","trxn_status":"initiate"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps529abddb9ea5118a1","billerId":"BSNL00000NATHL","billerName":"BSNL","custMobile":"1234567890","amount":"41","txn_dateTime":"2025-10-11 10:59:29","trxn_status":"initiate"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps299ef999a1eca612c","billerId":"BSNL00000NATHL","billerName":"BSNL","custMobile":"1234567890","amount":"443","txn_dateTime":"2025-10-10 15:42:47","trxn_status":"initiate"},{"merchantId":"355","orderId":"67e51b21dc1aarpbbpsa642ef5ad6d74c07a","billerId":"TNEB00000TND01","billerName":"Tamil Nadu Power Distribution Corporation Limited (TNPDCL)","custMobile":"7021398101","amount":"120","txn_dateTime":"2025-09-27 13:06:00","trxn_status":"initiate"},{"merchantId":"355","orderId":"67e51b21dc1aarpbbpsbbedee69f01a62e03","billerId":"CSPDCL000CHH01","billerName":"Chattisgarh State Power Distribution Co. Ltd.","custMobile":"7021398101","amount":"1225","txn_dateTime":"2025-09-10 16:36:00","trxn_status":"initiate"},{"merchantId":"355","orderId":"67e51b21dc1aarpbbps0f6d7e0bc906a40e7","billerId":"CSPDCL000CHH01","billerName":"Chattisgarh State Power Distribution Co. Ltd.","custMobile":"7021398101","amount":"1225","txn_dateTime":"2025-09-10 16:36:00","trxn_status":"initiate"},{"merchantId":"355","orderId":"67e51b21dc1aarpbbps339b194b124e00090","billerId":"CSPDCL000CHH01","billerName":"Chattisgarh State Power Distribution Co. Ltd.","custMobile":"7021398101","amount":"1225","txn_dateTime":"2025-09-10 16:36:00","trxn_status":"initiate"},{"merchantId":"355","orderId":"67e51b21dc1aarpbbps6935961988abe3643","billerId":"CSPDCL000CHH01","billerName":"Chattisgarh State Power Distribution Co. Ltd.","custMobile":"7021398101","amount":"1225","txn_dateTime":"2025-09-10 16:36:00","trxn_status":"initiate"}]}} ERROR - 2025-12-08 15:14:44 --> GET BBPS REPORT : Array ( [code] => RP000 [status] => SUCCESS [data] => Array ( [recordsTotal] => 1268 [recordsFiltered] => 1268 [data] => Array ( [0] => Array ( [merchantId] => 262 [orderId] => 66a2032f2e86frpbbps07aca710e908c45cb [billerId] => BSNL00000NATHL [billerName] => BSNL [custMobile] => 1234567890 [amount] => 40 [txn_dateTime] => 2025-10-27 14:41:33 [trxn_status] => initiate ) [1] => Array ( [merchantId] => 262 [orderId] => 66a2032f2e86frpbbps04df6488937e21f2b [billerId] => BSNL00000NATHL [billerName] => BSNL [custMobile] => 1234567890 [amount] => 73 [txn_dateTime] => 2025-10-13 14:20:10 [trxn_status] => initiate ) [2] => Array ( [merchantId] => 262 [orderId] => 66a2032f2e86frpbbps0513cd77d6099b6ca [billerId] => BSNL00000NATHL [billerName] => BSNL [custMobile] => 1234567890 [amount] => 40 [txn_dateTime] => 2025-10-13 13:27:52 [trxn_status] => initiate ) [3] => Array ( [merchantId] => 262 [orderId] => 66a2032f2e86frpbbps529abddb9ea5118a1 [billerId] => BSNL00000NATHL [billerName] => BSNL [custMobile] => 1234567890 [amount] => 41 [txn_dateTime] => 2025-10-11 10:59:29 [trxn_status] => initiate ) [4] => Array ( [merchantId] => 262 [orderId] => 66a2032f2e86frpbbps299ef999a1eca612c [billerId] => BSNL00000NATHL [billerName] => BSNL [custMobile] => 1234567890 [amount] => 443 [txn_dateTime] => 2025-10-10 15:42:47 [trxn_status] => initiate ) [5] => Array ( [merchantId] => 355 [orderId] => 67e51b21dc1aarpbbpsa642ef5ad6d74c07a [billerId] => TNEB00000TND01 [billerName] => Tamil Nadu Power Distribution Corporation Limited (TNPDCL) [custMobile] => 7021398101 [amount] => 120 [txn_dateTime] => 2025-09-27 13:06:00 [trxn_status] => initiate ) [6] => Array ( [merchantId] => 355 [orderId] => 67e51b21dc1aarpbbpsbbedee69f01a62e03 [billerId] => CSPDCL000CHH01 [billerName] => Chattisgarh State Power Distribution Co. Ltd. [custMobile] => 7021398101 [amount] => 1225 [txn_dateTime] => 2025-09-10 16:36:00 [trxn_status] => initiate ) [7] => Array ( [merchantId] => 355 [orderId] => 67e51b21dc1aarpbbps0f6d7e0bc906a40e7 [billerId] => CSPDCL000CHH01 [billerName] => Chattisgarh State Power Distribution Co. Ltd. [custMobile] => 7021398101 [amount] => 1225 [txn_dateTime] => 2025-09-10 16:36:00 [trxn_status] => initiate ) [8] => Array ( [merchantId] => 355 [orderId] => 67e51b21dc1aarpbbps339b194b124e00090 [billerId] => CSPDCL000CHH01 [billerName] => Chattisgarh State Power Distribution Co. Ltd. [custMobile] => 7021398101 [amount] => 1225 [txn_dateTime] => 2025-09-10 16:36:00 [trxn_status] => initiate ) [9] => Array ( [merchantId] => 355 [orderId] => 67e51b21dc1aarpbbps6935961988abe3643 [billerId] => CSPDCL000CHH01 [billerName] => Chattisgarh State Power Distribution Co. Ltd. [custMobile] => 7021398101 [amount] => 1225 [txn_dateTime] => 2025-09-10 16:36:00 [trxn_status] => initiate ) ) ) ) ERROR - 2025-12-08 15:14:53 --> Get BBPS Ledger Report Api Response: {"code":"RP000","status":"SUCCESS","data":{"recordsTotal":"262","recordsFiltered":"262","data":[{"merchantId":"262","orderId":"66a2032f2e86frpbbps07aca710e908c45cb","openingBalance":"994","closingBalance":"1034","creditAmount":"40","debitAmount":0,"transaction_type":"refund","transaction_dateTime":"2025-10-27 14:42:46"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps07aca710e908c45cb","openingBalance":"1034","closingBalance":"994","creditAmount":0,"debitAmount":"40","transaction_type":"bbps","transaction_dateTime":"2025-10-27 14:42:45"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps04df6488937e21f2b","openingBalance":"961","closingBalance":"1034","creditAmount":"73","debitAmount":0,"transaction_type":"refund","transaction_dateTime":"2025-10-13 14:24:14"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps04df6488937e21f2b","openingBalance":"1034","closingBalance":"961","creditAmount":0,"debitAmount":"73","transaction_type":"bbps","transaction_dateTime":"2025-10-13 14:24:13"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps04df6488937e21f2b","openingBalance":"1034","closingBalance":"961","creditAmount":0,"debitAmount":"73","transaction_type":"bbps","transaction_dateTime":"2025-10-13 14:23:42"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps04df6488937e21f2b","openingBalance":"961","closingBalance":"1034","creditAmount":"73","debitAmount":0,"transaction_type":"refund","transaction_dateTime":"2025-10-13 14:23:42"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps04df6488937e21f2b","openingBalance":"1034","closingBalance":"961","creditAmount":0,"debitAmount":"73","transaction_type":"bbps","transaction_dateTime":"2025-10-13 14:21:09"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps04df6488937e21f2b","openingBalance":"961","closingBalance":"1034","creditAmount":"73","debitAmount":0,"transaction_type":"refund","transaction_dateTime":"2025-10-13 14:21:09"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps529abddb9ea5118a1","openingBalance":"993","closingBalance":"1034","creditAmount":"41","debitAmount":0,"transaction_type":"refund","transaction_dateTime":"2025-10-11 11:27:01"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps529abddb9ea5118a1","openingBalance":"1034","closingBalance":"993","creditAmount":0,"debitAmount":"41","transaction_type":"bbps","transaction_dateTime":"2025-10-11 11:27:00"}]}} ERROR - 2025-12-08 15:45:33 --> Config Data Array ( [0] => Array ( [id] => 6 [service] => pg [partner] => razorpay [sub_partner] => razorpaycrowpefast [config] => {"key_id":"rzp_test_R79GAyU1RrZl3Q","secret_key":"ULyS9uOeCjnydmDnJuFZbF7U","base_url":"https://api.razorpay.com/v1/","salt":"","mode":"","public_key":""} ) [1] => Array ( [id] => 5 [service] => pg [partner] => razorpay [sub_partner] => razorpaycrowpeedu [config] => {"key_id":"rzp_test_R6kolnwA9V5krf","secret_key":"1HFK6QJeSXCBDSj3pM2nT4rG","base_url":"https://api.razorpay.com/v1/","salt":"","mode":"","public_key":""} ) [2] => Array ( [id] => 4 [service] => pg [partner] => razorpay [sub_partner] => razorpay [config] => {"key_id":"Vy9KTC9UV05RWmRGTUN2UHBhZWs5bTlDREl0alI4aTBXV2RPMlk4ckpLQT0=","secret_key":"bkRBMVRVaWVDTng3NmJMVHNndkJiMnM3NFlwZEJhSy9EZEpYb2hpSjcraz0=","base_url":"OHNGVkF1Y2xucTMvQzFESm40djFSOXVmQkZJZ1Q1ZE1ES05ZTFhPUXNmND0=","salt":"","mode":"","public_key":"eFhpZXFTZGo5RllrMnJKeU9JcHVEWFRHVytuWWZ3Rk5kNE9VenVpY1prMD0="} ) [3] => Array ( [id] => 1 [service] => pg [partner] => cashfree [sub_partner] => cashfree [config] => {"key_id":"102212e67e7888beb8005b2b94212201","secret_key":"4fa31e64c2752981f772f46229632c93c2c877a2","base_url":"https://sandbox.cashfree.com/","salt":"","mode":"","public_key":""} ) ) ERROR - 2025-12-08 15:45:33 --> Config Decode rzp_test_R79GAyU1RrZl3Q ERROR - 2025-12-08 15:45:33 --> Config Decode rzp_test_R6kolnwA9V5krf ERROR - 2025-12-08 15:45:33 --> Config Decode Vy9KTC9UV05RWmRGTUN2UHBhZWs5bTlDREl0alI4aTBXV2RPMlk4ckpLQT0= ERROR - 2025-12-08 15:45:33 --> Config Decode 102212e67e7888beb8005b2b94212201 ERROR - 2025-12-08 15:48:49 --> 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-08 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-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] => 2025-12-08 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-08 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1765189129.3337 [endTime:protected] => 1765189129.3557 [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] => 263 [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] => 1765189129.333 [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] => 263 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2025-12-08 16:32:23 --> 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-08 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-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] => 2025-12-08 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-08 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1765191743.3874 [endTime:protected] => 1765191743.4395 [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] => 349 [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] => 1765191743.2823 [connectDuration:protected] => 0.1050169467926 [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] => 349 [warning_count] => 0 ) [resultMode] => 0 ) )