ERROR - 2025-12-05 15:09:05 --> Get Today Earning Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}}
ERROR - 2025-12-05 15:09:05 --> get today earning response: Array
(
    [code] => RP001
    [status] => FAILED
    [errors] => Array
        (
            [0] => Data not found
        )

    [message] => Data not found
    [data] => Array
        (
        )

)

ERROR - 2025-12-05 15:09:06 --> Get Monthly Earning Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}}
ERROR - 2025-12-05 15:09:06 --> Get Today Revenue Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}}
ERROR - 2025-12-05 15:09:06 --> Get Monthly Revenue Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}}
ERROR - 2025-12-05 15:09:14 --> Get Merchant Balance Api Response: {"code":"RP000","status":"SUCCESS","errors":[],"message":"Fetched Successfully","data":{"total_balance":6005279731.49}}
ERROR - 2025-12-05 15:12:33 --> Get Today Earning Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}}
ERROR - 2025-12-05 15:12:33 --> get today earning response: Array
(
    [code] => RP001
    [status] => FAILED
    [errors] => Array
        (
            [0] => Data not found
        )

    [message] => Data not found
    [data] => Array
        (
        )

)

ERROR - 2025-12-05 15:12:33 --> Get Monthly Earning Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}}
ERROR - 2025-12-05 15:12:33 --> Get Today Revenue Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}}
ERROR - 2025-12-05 15:12:33 --> Get Monthly Revenue Api Response: {"code":"RP001","status":"FAILED","errors":["Data not found"],"message":"Data not found","data":{}}
ERROR - 2025-12-05 15:13:09 --> Get BBPS Merchant Balance Api Response: {"code":"RP000","status":"SUCCESS","message":"Wallet balance generated.","totalBalance":"16729"}
ERROR - 2025-12-05 15:13:09 --> Get BBPS API Balance Api Response: {"code":"RP000","status":"SUCCESS","message":"Api wallet balance generated.","totalBalance":"1998690"}
ERROR - 2025-12-05 15:44:40 --> 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-05 00:00:00'
AND `cust_txn_initiate_datetime` <= '2025-12-05 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-05 00:00:00
                    [1] => 1
                )

            [cust_txn_initiate_datetime.1] => Array
                (
                    [0] => 2025-12-05 23:59:59
                    [1] => 1
                )

            [response_code] => Array
                (
                    [0] => 1
                    [1] => 1
                )

        )

    [bindMarker:protected] => ?
    [startTime:protected] => 1764929679.8923
    [endTime:protected] => 1764929680.0235
    [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] => 35
                    [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] => 1764929679.8915
            [connectDuration:protected] => 0.000701904296875
            [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] => 35
                    [warning_count] => 0
                )

            [resultMode] => 0
        )

)

ERROR - 2025-12-05 16:18:41 --> 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-05 00:00:00'
AND `cust_txn_initiate_datetime` <= '2025-12-05 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-05 00:00:00
                    [1] => 1
                )

            [cust_txn_initiate_datetime.1] => Array
                (
                    [0] => 2025-12-05 23:59:59
                    [1] => 1
                )

            [response_code] => Array
                (
                    [0] => 1
                    [1] => 1
                )

        )

    [bindMarker:protected] => ?
    [startTime:protected] => 1764931721.5013
    [endTime:protected] => 1764931721.5229
    [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] => 108
                    [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] => 1764931721.5005
            [connectDuration:protected] => 0.00070977210998535
            [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] => 108
                    [warning_count] => 0
                )

            [resultMode] => 0
        )

)