ERROR - 2025-06-09 11:43:12 --> Get Merchant Balance Response : {"code":"RP000","status":"SUCCESS","errors":[],"message":"Success","data":{"useable_balance":0,"available_balance":0,"cutoff_money":0,"status":"Active","callback_url":null,"comment":null}} ERROR - 2025-06-09 11:43:12 --> Get Admin Merchant Balance:Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Success [data] => Array ( [useable_balance] => 0 [available_balance] => 0 [cutoff_money] => 0 [status] => Active [callback_url] => [comment] => ) ) ERROR - 2025-06-09 12:34:33 --> 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-06-09 00:00:00' AND `cust_txn_initiate_datetime` <= '2025-06-09 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-06-09 00:00:00 [1] => 1 ) [cust_txn_initiate_datetime.1] => Array ( [0] => 2025-06-09 23:59:59 [1] => 1 ) [response_code] => Array ( [0] => 1 [1] => 1 ) ) [bindMarker:protected] => ? [startTime:protected] => 1749452673.0747 [endTime:protected] => 1749452673.0845 [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] => 1997 [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] => 1749452673.0737 [connectDuration:protected] => 0.00096988677978516 [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] => 1997 [warning_count] => 0 ) [resultMode] => 0 ) ) ERROR - 2025-06-09 12:35:59 --> Get Today Earning Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2025-06-09 12:35:59 --> get today earning response: Array ( [code] => RP001 [status] => FAILED [errors] => Array ( [0] => Data not found ) [message] => Data not found [data] => Array ( ) ) ERROR - 2025-06-09 12:35:59 --> Get Monthly Earning Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2025-06-09 12:36:00 --> Get Today Revenue Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}} ERROR - 2025-06-09 12:36:00 --> Get Monthly Revenue Api Response: {"code":"RP000","status":"SUCCESS","errors":[],"message":"Fetched Successfully","data":{"0":{"status":"CREATED","total_amount":"6689","total_count":"9"}}} ERROR - 2025-06-09 12:36:04 --> Get Merchant Balance Api Response: {"code":"RP000","status":"SUCCESS","errors":[],"message":"Fetched Successfully","data":{"total_balance":6003834826.96}} ERROR - 2025-06-09 12:38:43 --> Get BBPS Transaction Report Api Response: {"code":"RP000","status":"SUCCESS","data":{"recordsTotal":"1182","recordsFiltered":"1182","data":[{"merchantId":"262","orderId":"66a2032f2e86frpbbps613ece117ed6f8e","billerId":"JVVNL0000RAJ01","billerName":"Jaipur Vidyut Vitran Nigam (JVVNL)","custMobile":"9319194255","amount":0,"txn_dateTime":"2025-06-05 18:40:15","trxn_status":"initiate"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps56c11e5a0f57589","billerId":"BANK00000NATKB","billerName":"Bank of Baroda","custMobile":"9319194255","amount":0,"txn_dateTime":"2025-06-03 13:05:26","trxn_status":"initiate"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps9481c0bae25a72c","billerId":"BANK00000NATKB","billerName":"Bank of Baroda","custMobile":"1234567890","amount":0,"txn_dateTime":"2025-06-02 14:56:24","trxn_status":"initiate"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps9b63c225baba855","billerId":"BANK00000NATKB","billerName":"Bank of Baroda","custMobile":"1234567890","amount":0,"txn_dateTime":"2025-06-02 14:55:38","trxn_status":"initiate"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps0080c7c9f3f0d93","billerId":"BANK00000NATKB","billerName":"Bank of Baroda","custMobile":"1234567890","amount":0,"txn_dateTime":"2025-06-02 14:42:02","trxn_status":"initiate"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps72ac6adcd692b00","billerId":"BANK00000NATKB","billerName":"Bank of Baroda","custMobile":"1234567890","amount":0,"txn_dateTime":"2025-05-29 14:32:12","trxn_status":"initiate"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps1ec9f53f1759a98","billerId":"BANK00000NATKB","billerName":"Bank of Baroda","custMobile":"1234567890","amount":0,"txn_dateTime":"2025-05-29 14:29:55","trxn_status":"initiate"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps823ae5c23d50447","billerId":"BANK00000NATKB","billerName":"Bank of Baroda","custMobile":"8888877777","amount":0,"txn_dateTime":"2025-05-29 14:28:30","trxn_status":"initiate"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps49ae2fa2395f612","billerId":"BANK00000NATKB","billerName":"Bank of Baroda","custMobile":"8888877777","amount":0,"txn_dateTime":"2025-05-29 14:27:15","trxn_status":"initiate"},{"merchantId":"262","orderId":"66a2032f2e86frpbbps4ec5a53aaf2fc27","billerId":"BANK00000NATKB","billerName":"Bank of Baroda","custMobile":"8888877777","amount":0,"txn_dateTime":"2025-05-29 14:26:18","trxn_status":"initiate"}]}} ERROR - 2025-06-09 12:38:43 --> GET BBPS REPORT : Array ( [code] => RP000 [status] => SUCCESS [data] => Array ( [recordsTotal] => 1182 [recordsFiltered] => 1182 [data] => Array ( [0] => Array ( [merchantId] => 262 [orderId] => 66a2032f2e86frpbbps613ece117ed6f8e [billerId] => JVVNL0000RAJ01 [billerName] => Jaipur Vidyut Vitran Nigam (JVVNL) [custMobile] => 9319194255 [amount] => 0 [txn_dateTime] => 2025-06-05 18:40:15 [trxn_status] => initiate ) [1] => Array ( [merchantId] => 262 [orderId] => 66a2032f2e86frpbbps56c11e5a0f57589 [billerId] => BANK00000NATKB [billerName] => Bank of Baroda [custMobile] => 9319194255 [amount] => 0 [txn_dateTime] => 2025-06-03 13:05:26 [trxn_status] => initiate ) [2] => Array ( [merchantId] => 262 [orderId] => 66a2032f2e86frpbbps9481c0bae25a72c [billerId] => BANK00000NATKB [billerName] => Bank of Baroda [custMobile] => 1234567890 [amount] => 0 [txn_dateTime] => 2025-06-02 14:56:24 [trxn_status] => initiate ) [3] => Array ( [merchantId] => 262 [orderId] => 66a2032f2e86frpbbps9b63c225baba855 [billerId] => BANK00000NATKB [billerName] => Bank of Baroda [custMobile] => 1234567890 [amount] => 0 [txn_dateTime] => 2025-06-02 14:55:38 [trxn_status] => initiate ) [4] => Array ( [merchantId] => 262 [orderId] => 66a2032f2e86frpbbps0080c7c9f3f0d93 [billerId] => BANK00000NATKB [billerName] => Bank of Baroda [custMobile] => 1234567890 [amount] => 0 [txn_dateTime] => 2025-06-02 14:42:02 [trxn_status] => initiate ) [5] => Array ( [merchantId] => 262 [orderId] => 66a2032f2e86frpbbps72ac6adcd692b00 [billerId] => BANK00000NATKB [billerName] => Bank of Baroda [custMobile] => 1234567890 [amount] => 0 [txn_dateTime] => 2025-05-29 14:32:12 [trxn_status] => initiate ) [6] => Array ( [merchantId] => 262 [orderId] => 66a2032f2e86frpbbps1ec9f53f1759a98 [billerId] => BANK00000NATKB [billerName] => Bank of Baroda [custMobile] => 1234567890 [amount] => 0 [txn_dateTime] => 2025-05-29 14:29:55 [trxn_status] => initiate ) [7] => Array ( [merchantId] => 262 [orderId] => 66a2032f2e86frpbbps823ae5c23d50447 [billerId] => BANK00000NATKB [billerName] => Bank of Baroda [custMobile] => 8888877777 [amount] => 0 [txn_dateTime] => 2025-05-29 14:28:30 [trxn_status] => initiate ) [8] => Array ( [merchantId] => 262 [orderId] => 66a2032f2e86frpbbps49ae2fa2395f612 [billerId] => BANK00000NATKB [billerName] => Bank of Baroda [custMobile] => 8888877777 [amount] => 0 [txn_dateTime] => 2025-05-29 14:27:15 [trxn_status] => initiate ) [9] => Array ( [merchantId] => 262 [orderId] => 66a2032f2e86frpbbps4ec5a53aaf2fc27 [billerId] => BANK00000NATKB [billerName] => Bank of Baroda [custMobile] => 8888877777 [amount] => 0 [txn_dateTime] => 2025-05-29 14:26:18 [trxn_status] => initiate ) ) ) ) ERROR - 2025-06-09 12:38:56 --> Get BBPS Ledger Report Api Response: {"code":"RP000","status":"SUCCESS","data":{"recordsTotal":"169","recordsFiltered":"169","data":[{"merchantId":"1","orderId":"1bppse0ec45ad672e286953d6ea52670fbd35","openingBalance":"1234","closingBalance":"1335","creditAmount":"101","debitAmount":0,"transaction_type":"Wallet Recharge","transaction_dateTime":"2025-02-20 14:12:11"},{"merchantId":"175","orderId":"175bppsd77c6b1af853deaade6b1d431a51e84d","openingBalance":"257574","closingBalance":"266551","creditAmount":"8977","debitAmount":0,"transaction_type":"Wallet Recharge","transaction_dateTime":"2025-02-05 17:44:40"},{"merchantId":"1","orderId":"1bppsb555ec1525e80ce719b6862fcdb39f95","openingBalance":"0","closingBalance":"1234","creditAmount":"1234","debitAmount":0,"transaction_type":"Wallet Recharge","transaction_dateTime":"2025-02-03 12:18:32"},{"merchantId":"802","orderId":"45","openingBalance":"7782","closingBalance":"8673","creditAmount":"891","debitAmount":0,"transaction_type":"Wallet Recharge","transaction_dateTime":"2024-09-20 16:16:15"},{"merchantId":"802","orderId":"40145","openingBalance":"6891","closingBalance":"7782","creditAmount":"891","debitAmount":0,"transaction_type":"Wallet Recharge","transaction_dateTime":"2024-09-20 16:16:08"},{"merchantId":"802","orderId":"demo12340103445","openingBalance":"6000","closingBalance":"6891","creditAmount":"891","debitAmount":0,"transaction_type":"Wallet Recharge","transaction_dateTime":"2024-09-20 16:15:59"},{"merchantId":"802","orderId":"demo12340903445","openingBalance":"4800","closingBalance":"6000","creditAmount":"1200","debitAmount":0,"transaction_type":"Wallet Recharge","transaction_dateTime":"2024-09-20 12:22:57"},{"merchantId":"802","orderId":"demo12300903445","openingBalance":"3600","closingBalance":"4800","creditAmount":"1200","debitAmount":0,"transaction_type":"Wallet Recharge","transaction_dateTime":"2024-09-19 17:45:51"},{"merchantId":"802","orderId":"demo188903445","openingBalance":"2400","closingBalance":"3600","creditAmount":"1200","debitAmount":0,"transaction_type":"Wallet Recharge","transaction_dateTime":"2024-09-19 16:11:38"},{"merchantId":"802","orderId":"demo1903445","openingBalance":"1200","closingBalance":"2400","creditAmount":"1200","debitAmount":0,"transaction_type":"Wallet Recharge","transaction_dateTime":"2024-09-19 16:09:08"}]}} ERROR - 2025-06-09 13:02:30 --> Get Merchant Balance Response : {"code":"RP000","status":"SUCCESS","errors":[],"message":"Success","data":{"useable_balance":0,"available_balance":0,"cutoff_money":0,"status":"Active","callback_url":null,"comment":null}} ERROR - 2025-06-09 13:02:30 --> Get Admin Merchant Balance:Array ( [code] => RP000 [status] => SUCCESS [errors] => Array ( ) [message] => Success [data] => Array ( [useable_balance] => 0 [available_balance] => 0 [cutoff_money] => 0 [status] => Active [callback_url] => [comment] => ) )