ERROR - 2025-12-23 16:47:57 --> 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-23 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-23 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-23 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-23 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1766488677.613 [endTime:protected] => 1766488677.6383 [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] => 391 [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] => 1766488677.6124 [connectDuration:protected] => 0.00055503845214844 [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] => 391 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2025-12-23 16:53:09 --> 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-23' ERROR - 2025-12-23 16:53:09 --> 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-23' ORDER BY `id` DESC LIMIT 10 ERROR - 2025-12-23 16:55:51 --> 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-23 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-23 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-23 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-23 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1766489151.6476 [endTime:protected] => 1766489151.6762 [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] => 404 [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] => 1766489151.647 [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.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] => 404 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2025-12-23 16:56: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-23 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-23 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-23 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-23 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1766489184.9642 [endTime:protected] => 1766489185.0192 [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] => 405 [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] => 1766489184.8466 [connectDuration:protected] => 0.11750984191895 [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] => 405 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2025-12-23 18:21:37 --> 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-23 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-12-23 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-23 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-12-23 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1766494297.8624 [endTime:protected] => 1766494297.9734 [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] => 15 [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] => 1766494297.8619 [connectDuration:protected] => 0.0005040168762207 [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] => 15 [warning_count] => 0 ) [resultMode] => 0 ) )