PHP Warning:  Module 'soap' already loaded in Unknown on line 0

Warning: Module 'soap' already loaded in Unknown on line 0
Psy Shell v0.9.12 (PHP 7.3.33 — cli) by Justin Hileman
New version is available (current: v0.9.12, latest: v0.12.24)
>>> echo "===USER-PAYOUTS-STRUCTURE===";
===USER-PAYOUTS-STRUCTURE===⏎
>>> $c = DB::select("DESCRIBE user_payouts"); foreach($c as $col) { echo $col->Field."|".$col->Type."
... "; }
id|int
payout_id|varchar(10)
user_id|int
method_code|char(25)
account|varchar(255)
amount|decimal(10,2)
cashback_amount|decimal(10,2)
reward_amount|decimal(10,2)
status|enum('created','processing','completed','declined','failed','approved_manually','approved_automatically')
api_status|varchar(25)
api_response|json
note|varchar(500)
payment_ref_num|varchar(255)
paid_at|date
created_at|datetime
updated_at|datetime
local_currency|varchar(3)
local_amount|decimal(10,2)
currency_rate|double
fees_amount|double(10,2)
local_fees_amount|double(10,2)
final_amount|double(10,2)
local_final_amount|double(10,2)
fees_data|json
is_reset|tinyint(1)
amount_egp|decimal(10,2)
amount_sar|decimal(10,2)
amount_aed|decimal(10,2)
amount_kwd|decimal(10,2)
>>> echo "===USER-PAYOUTS-SUMS===";
===USER-PAYOUTS-SUMS===⏎
>>> $up = DB::select("SELECT COUNT(*) as cnt, SUM(amount) as total, MIN(amount) as min_amt, MAX(amount) as max_amt, AVG(amount) as avg_amt FROM user_payouts")[0];
=> {#1027
     +"cnt": 9332,
     +"total": "2264455.08",
     +"min_amt": "0.00",
     +"max_amt": "88571.62",
     +"avg_amt": "242.654852",
   }
>>> echo "user_payouts_count: ".$up->cnt."
... ";
user_payouts_count: 9332
>>> echo "user_payouts_total_amount: ".$up->total."
... ";
user_payouts_total_amount: 2264455.08
>>> echo "user_payouts_min: ".$up->min_amt."
... ";
user_payouts_min: 0.00
>>> echo "user_payouts_max: ".$up->max_amt."
... ";
user_payouts_max: 88571.62
>>> echo "user_payouts_avg: ".$up->avg_amt."
... ";
user_payouts_avg: 242.654852
>>> echo "===USER-PAYOUTS-SAMPLE-30===";
===USER-PAYOUTS-SAMPLE-30===⏎
>>> $up2 = DB::select("SELECT * FROM user_payouts ORDER BY id DESC LIMIT 30");
=> [
     {#1028
       +"id": 9466,
       +"payout_id": "d65f841956",
       +"user_id": 230013,
       +"method_code": "e-wallet",
       +"account": "01019244122",
       +"amount": "1.47",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "successful",
       +"api_response": "{"vat": 0.0698, "fees": 0.4988, "amount": 55.42, "issuer": "vodafone", "msisdn": "01019244122", "comment1": "", "bank_name": null, "full_name": "", "reference": null, "created_at": "2026-09-16 06:17:58.931961", "updated_at": "2026-09-16 06:18:00.907489", "status_code": "200", "reference_id": "023754836657", "transaction_id": "5e9e5a73-612a-4bf2-a067-dde922653984", "status_description": "تم إيداع 55.4 جنيه إلى رقم 01019244122 بنجاح", "disbursement_status": "successful", "aman_cashing_details": null, "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": null,
       +"payment_ref_num": "5e9e5a73-612a-4bf2-a067-dde922653984",
       +"paid_at": "2026-09-16",
       +"created_at": "2026-09-14 11:50:24",
       +"updated_at": "2026-09-16 06:18:00",
       +"local_currency": "EGP",
       +"local_amount": "75.42",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 1.08,
       +"local_final_amount": 55.42,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "75.50",
       +"amount_sar": "5.51",
       +"amount_aed": "5.39",
       +"amount_kwd": "0.46",
     },
     {#1024
       +"id": 9465,
       +"payout_id": "7934daecd7",
       +"user_id": 402963,
       +"method_code": "e-wallet",
       +"account": "01156139115",
       +"amount": "1.68",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "successful",
       +"api_response": "{"vat": 0.0834, "fees": 0.5958, "amount": 66.2, "issuer": "etisalat", "msisdn": "01156139115", "comment1": "", "bank_name": null, "full_name": "", "reference": null, "created_at": "2026-09-16 06:17:51.732433", "updated_at": "2026-09-16 06:17:55.242603", "status_code": "200", "reference_id": "023754835270", "transaction_id": "c1a04bd7-f3f8-4814-a422-0ba04e81d1e6", "status_description": "amount is deposited successfully", "disbursement_status": "successful", "aman_cashing_details": null, "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": null,
       +"payment_ref_num": "c1a04bd7-f3f8-4814-a422-0ba04e81d1e6",
       +"paid_at": "2026-09-16",
       +"created_at": "2026-09-14 11:49:32",
       +"updated_at": "2026-09-16 06:17:55",
       +"local_currency": "EGP",
       +"local_amount": "86.20",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 1.29,
       +"local_final_amount": 66.2,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "86.28",
       +"amount_sar": "6.30",
       +"amount_aed": "6.17",
       +"amount_kwd": "0.52",
     },
     {#1019
       +"id": 9464,
       +"payout_id": "58b005",
       +"user_id": 403702,
       +"method_code": "e-wallet",
       +"account": "01029554735",
       +"amount": "2.12",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "successful",
       +"api_response": "{"vat": 0.1117, "fees": 0.7982, "amount": 88.69, "issuer": "vodafone", "msisdn": "01029554735", "comment1": "", "bank_name": null, "full_name": "", "reference": null, "created_at": "2026-09-16 06:17:46.568004", "updated_at": "2026-09-16 06:17:49.023085", "status_code": "200", "reference_id": "023754834062", "transaction_id": "ddb4baa9-59df-4bc9-a4fb-f6b2f986c75e", "status_description": "تم إيداع 88.7 جنيه إلى رقم 01029554735 بنجاح", "disbursement_status": "successful", "aman_cashing_details": null, "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": null,
       +"payment_ref_num": "ddb4baa9-59df-4bc9-a4fb-f6b2f986c75e",
       +"paid_at": "2026-09-16",
       +"created_at": "2026-09-14 11:48:42",
       +"updated_at": "2026-09-16 06:17:49",
       +"local_currency": "EGP",
       +"local_amount": "108.69",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 1.73,
       +"local_final_amount": 88.69,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "108.88",
       +"amount_sar": "7.95",
       +"amount_aed": "7.78",
       +"amount_kwd": "0.66",
     },
     {#1026
       +"id": 9463,
       +"payout_id": "f94fb7431e",
       +"user_id": 402972,
       +"method_code": "e-wallet",
       +"account": "01030006151",
       +"amount": "2.73",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "successful",
       +"api_response": "{"vat": 0.1513, "fees": 1.0806, "amount": 120.07, "issuer": "vodafone", "msisdn": "01030006151", "comment1": "", "bank_name": null, "full_name": "", "reference": null, "created_at": "2026-09-16 06:17:41.687815", "updated_at": "2026-09-16 06:17:43.721851", "status_code": "200", "reference_id": "023754833050", "transaction_id": "cb40aafa-a7f5-46c3-af34-ca81a2a580ed", "status_description": "تم إيداع 120.1 جنيه إلى رقم 01030006151 بنجاح", "disbursement_status": "successful", "aman_cashing_details": null, "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": null,
       +"payment_ref_num": "cb40aafa-a7f5-46c3-af34-ca81a2a580ed",
       +"paid_at": "2026-09-16",
       +"created_at": "2026-09-14 11:47:03",
       +"updated_at": "2026-09-16 06:17:43",
       +"local_currency": "EGP",
       +"local_amount": "140.07",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 2.34,
       +"local_final_amount": 120.07,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "140.21",
       +"amount_sar": "10.24",
       +"amount_aed": "10.02",
       +"amount_kwd": "0.85",
     },
     {#1025
       +"id": 9462,
       +"payout_id": "ac7d870be3",
       +"user_id": 381403,
       +"method_code": "e-wallet",
       +"account": "01011254411",
       +"amount": "2.91",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "successful",
       +"api_response": "{"vat": 0.1632, "fees": 1.1659, "amount": 129.54, "issuer": "vodafone", "msisdn": "01011254411", "comment1": "", "bank_name": null, "full_name": "", "reference": null, "created_at": "2026-09-16 06:17:35.656331", "updated_at": "2026-09-16 06:17:37.968206", "status_code": "200", "reference_id": "023754831779", "transaction_id": "df503552-d578-4c8c-8758-0b181dcafa4a", "status_description": "تم إيداع 129.5 جنيه إلى رقم 01011254411 بنجاح", "disbursement_status": "successful", "aman_cashing_details": null, "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": null,
       +"payment_ref_num": "df503552-d578-4c8c-8758-0b181dcafa4a",
       +"paid_at": "2026-09-16",
       +"created_at": "2026-09-14 11:46:04",
       +"updated_at": "2026-09-16 06:17:38",
       +"local_currency": "EGP",
       +"local_amount": "149.54",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 2.52,
       +"local_final_amount": 129.54,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "149.46",
       +"amount_sar": "10.91",
       +"amount_aed": "10.68",
       +"amount_kwd": "0.90",
     },
     {#1023
       +"id": 9461,
       +"payout_id": "01c83ac195",
       +"user_id": 405843,
       +"method_code": "e-wallet",
       +"account": "01228393823",
       +"amount": "4.32",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "successful",
       +"api_response": "{"vat": 0.2545, "fees": 1.818, "amount": 202.0, "issuer": "bank_wallet", "msisdn": "01228393823", "comment1": "", "bank_name": null, "full_name": "", "reference": null, "created_at": "2026-09-16 06:17:28.895809", "updated_at": "2026-09-16 06:17:31.885636", "status_code": "200", "reference_id": "023754830569", "transaction_id": "bf9866ec-1fb3-4b00-8a4f-2db15dfda0d6", "status_description": "amount is deposited successfully", "disbursement_status": "successful", "aman_cashing_details": null, "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": null,
       +"payment_ref_num": "bf9866ec-1fb3-4b00-8a4f-2db15dfda0d6",
       +"paid_at": "2026-09-16",
       +"created_at": "2026-09-14 11:23:58",
       +"updated_at": "2026-09-16 06:17:31",
       +"local_currency": "EGP",
       +"local_amount": "222.00",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 3.93,
       +"local_final_amount": 202.0,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "221.88",
       +"amount_sar": "16.20",
       +"amount_aed": "15.85",
       +"amount_kwd": "1.34",
     },
     {#1022
       +"id": 9460,
       +"payout_id": "9d7f448988",
       +"user_id": 24929,
       +"method_code": "e-wallet",
       +"account": "01018586698",
       +"amount": "5.15",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "successful",
       +"api_response": "{"vat": 0.3079, "fees": 2.1996, "amount": 244.4, "issuer": "vodafone", "msisdn": "01018586698", "comment1": "", "bank_name": null, "full_name": "", "reference": null, "created_at": "2026-09-16 06:17:23.710363", "updated_at": "2026-09-16 06:17:25.596860", "status_code": "200", "reference_id": "023754829392", "transaction_id": "e51b42f1-443a-4d2d-99d5-60a88c7a488f", "status_description": "تم إيداع 244.4 جنيه إلى رقم 01018586698 بنجاح", "disbursement_status": "successful", "aman_cashing_details": null, "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": null,
       +"payment_ref_num": "e51b42f1-443a-4d2d-99d5-60a88c7a488f",
       +"paid_at": "2026-09-16",
       +"created_at": "2026-09-14 11:17:45",
       +"updated_at": "2026-09-16 06:17:25",
       +"local_currency": "EGP",
       +"local_amount": "264.40",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 4.76,
       +"local_final_amount": 244.4,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "264.50",
       +"amount_sar": "19.31",
       +"amount_aed": "18.90",
       +"amount_kwd": "1.60",
     },
     {#1021
       +"id": 9459,
       +"payout_id": "4026faedf4",
       +"user_id": 403486,
       +"method_code": "bank-transfer-eg",
       +"account": " EG410002013301330331000001508",
       +"amount": "6.50",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "8000",
       +"api_response": "{"vat": 1.4, "fees": 10.0, "amount": "314.01", "issuer": "bank_card", "bank_code": "MISR", "full_name": "Ahmed Mohamed Mohamed Ahmed", "reference": null, "created_at": "2026-09-16 06:17:18.807891", "updated_at": "2026-09-16 06:17:19.839158", "status_code": "8000", "transaction_id": "3218142e-0d18-49e3-a4b2-2a2d566fd92a", "bank_card_number": "EG410002013301330331000001508", "status_description": "Transaction received and validated successfully. Dispatched for being processed by the bank", "disbursement_status": "pending", "bank_transaction_type": "cash_transfer", "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": null,
       +"payment_ref_num": "3218142e-0d18-49e3-a4b2-2a2d566fd92a",
       +"paid_at": null,
       +"created_at": "2026-09-14 11:17:00",
       +"updated_at": "2026-09-16 13:29:48",
       +"local_currency": "EGP",
       +"local_amount": "334.01",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 6.11,
       +"local_final_amount": 314.01,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "333.84",
       +"amount_sar": "24.38",
       +"amount_aed": "23.86",
       +"amount_kwd": "2.02",
     },
     {#1017
       +"id": 9458,
       +"payout_id": "0728b9059f",
       +"user_id": 406573,
       +"method_code": "bank-transfer-eg",
       +"account": "EG280003017750010117440010180",
       +"amount": "409.53",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "8000",
       +"api_response": "{"vat": 2.9166, "fees": 20.8325, "amount": "20832.47", "issuer": "bank_card", "bank_code": "NBE", "full_name": "’Marwa abd elaaal Mohamed", "reference": null, "created_at": "2026-09-16 06:17:13.824280", "updated_at": "2026-09-16 06:17:14.877260", "status_code": "8000", "transaction_id": "c9bd6ec8-d4dd-4514-bad4-37a6797814ca", "bank_card_number": "EG280003017750010117440010180", "status_description": "Transaction received and validated successfully. Dispatched for being processed by the bank", "disbursement_status": "pending", "bank_transaction_type": "cash_transfer", "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": null,
       +"payment_ref_num": "c9bd6ec8-d4dd-4514-bad4-37a6797814ca",
       +"paid_at": null,
       +"created_at": "2026-09-14 11:16:27",
       +"updated_at": "2026-09-16 13:28:46",
       +"local_currency": "EGP",
       +"local_amount": "21032.47",
       +"currency_rate": 51.3578,
       +"fees_amount": 3.89,
       +"local_fees_amount": 200.0,
       +"final_amount": 405.63,
       +"local_final_amount": 20832.47,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "21033.46",
       +"amount_sar": "1535.74",
       +"amount_aed": "1502.98",
       +"amount_kwd": "126.95",
     },
     {#1016
       +"id": 9457,
       +"payout_id": "3662285bd8",
       +"user_id": 403461,
       +"method_code": "bank-transfer-eg",
       +"account": "1130587705949",
       +"amount": "104.10",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "8000",
       +"api_response": "{"vat": 1.4, "fees": 10.0, "amount": "5239.51", "issuer": "bank_card", "bank_code": "QNB", "full_name": "Ahmed Alaa Abdelrahim", "reference": null, "created_at": "2026-09-16 06:17:10.512046", "updated_at": "2026-09-16 06:17:11.530050", "status_code": "8000", "transaction_id": "1abd67cf-cca1-4821-8b71-240d1820148f", "bank_card_number": "1130587705949", "status_description": "Transaction received and validated successfully. Dispatched for being processed by the bank", "disbursement_status": "pending", "bank_transaction_type": "cash_transfer", "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": null,
       +"payment_ref_num": "1abd67cf-cca1-4821-8b71-240d1820148f",
       +"paid_at": null,
       +"created_at": "2026-09-14 11:15:51",
       +"updated_at": "2026-09-16 13:27:44",
       +"local_currency": "EGP",
       +"local_amount": "5346.44",
       +"currency_rate": 51.3578,
       +"fees_amount": 2.08,
       +"local_fees_amount": 106.93,
       +"final_amount": 102.02,
       +"local_final_amount": 5239.51,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "5346.58",
       +"amount_sar": "390.38",
       +"amount_aed": "382.05",
       +"amount_kwd": "32.27",
     },
     {#1020
       +"id": 9456,
       +"payout_id": "4974912782",
       +"user_id": 407179,
       +"method_code": "e-wallet",
       +"account": "01098800002",
       +"amount": "30.61",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "successful",
       +"api_response": "{"vat": 1.9409, "fees": 13.8637, "amount": 1540.41, "issuer": "vodafone", "msisdn": "01098800002", "comment1": "", "bank_name": null, "full_name": "", "reference": null, "created_at": "2026-09-16 06:17:04.490740", "updated_at": "2026-09-16 06:17:06.696232", "status_code": "200", "reference_id": "023754825515", "transaction_id": "d3bf2d2b-5a76-4c43-bbda-bbd3315e6585", "status_description": "تم إيداع 1540.4 جنيه إلى رقم 01098800002 بنجاح", "disbursement_status": "successful", "aman_cashing_details": null, "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": null,
       +"payment_ref_num": "d3bf2d2b-5a76-4c43-bbda-bbd3315e6585",
       +"paid_at": "2026-09-16",
       +"created_at": "2026-09-14 08:49:02",
       +"updated_at": "2026-09-16 06:17:06",
       +"local_currency": "EGP",
       +"local_amount": "1571.85",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.61,
       +"local_fees_amount": 31.44,
       +"final_amount": 29.99,
       +"local_final_amount": 1540.41,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "1572.13",
       +"amount_sar": "114.79",
       +"amount_aed": "112.34",
       +"amount_kwd": "9.49",
     },
     {#1014
       +"id": 9455,
       +"payout_id": "45c019cc86",
       +"user_id": 405724,
       +"method_code": "bank-transfer-eg",
       +"account": "EG740037002708181020702036735",
       +"amount": "7.22",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "8000",
       +"api_response": "{"vat": 1.4, "fees": 10.0, "amount": "349.72", "issuer": "bank_card", "bank_code": "QNB", "full_name": "MOHAMED AMIR", "reference": null, "created_at": "2026-09-16 06:17:00.466101", "updated_at": "2026-09-16 06:17:01.501781", "status_code": "8000", "transaction_id": "a0e7e12f-93fb-4403-b2f1-62f6251532b1", "bank_card_number": "EG740037002708181020702036735", "status_description": "Transaction received and validated successfully. Dispatched for being processed by the bank", "disbursement_status": "pending", "bank_transaction_type": "cash_transfer", "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": null,
       +"payment_ref_num": "a0e7e12f-93fb-4403-b2f1-62f6251532b1",
       +"paid_at": null,
       +"created_at": "2026-09-10 13:01:39",
       +"updated_at": "2026-09-16 13:26:42",
       +"local_currency": "EGP",
       +"local_amount": "369.72",
       +"currency_rate": 51.1986,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 6.83,
       +"local_final_amount": 349.72,
       +"fees_data": "{"type": "percentage", "amount": 5, "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "369.66",
       +"amount_sar": "27.08",
       +"amount_aed": "26.50",
       +"amount_kwd": "2.24",
     },
     {#1067
       +"id": 9454,
       +"payout_id": "bef586a071",
       +"user_id": 406238,
       +"method_code": "e-wallet",
       +"account": "01060373918",
       +"amount": "4.73",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "successful",
       +"api_response": "{"vat": 0.2808, "fees": 2.0056, "amount": 222.85, "issuer": "vodafone", "msisdn": "01060373918", "comment1": "", "bank_name": null, "full_name": "", "reference": null, "created_at": "2026-09-16 06:16:56.211655", "updated_at": "2026-09-16 06:16:58.067074", "status_code": "200", "reference_id": "023754823852", "transaction_id": "36ccf809-5d95-4d41-ac00-d6b109b5ea28", "status_description": "تم إيداع 222.8 جنيه إلى رقم 01060373918 بنجاح", "disbursement_status": "successful", "aman_cashing_details": null, "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": "1",
       +"payment_ref_num": "36ccf809-5d95-4d41-ac00-d6b109b5ea28",
       +"paid_at": "2026-09-16",
       +"created_at": "2026-09-07 09:12:26",
       +"updated_at": "2026-09-16 06:16:58",
       +"local_currency": "EGP",
       +"local_amount": "242.85",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 4.34,
       +"local_final_amount": 222.85,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "35.06",
       +"amount_sar": "2.55",
       +"amount_aed": "2.50",
       +"amount_kwd": "0.21",
     },
     {#1068
       +"id": 9453,
       +"payout_id": "ca77de8272",
       +"user_id": 405586,
       +"method_code": "bank-transfer-eg",
       +"account": "EG270002051905190333000027309",
       +"amount": "49.95",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "8000",
       +"api_response": "{"vat": 1.4, "fees": 10.0, "amount": "2513.92", "issuer": "bank_card", "bank_code": "MISR", "full_name": "MAHMOUD ALI AHMED", "reference": null, "created_at": "2026-09-16 06:16:51.606895", "updated_at": "2026-09-16 06:16:52.636564", "status_code": "8000", "transaction_id": "873368d8-b493-48f3-af71-32ac2540d3bf", "bank_card_number": "EG270002051905190333000027309", "status_description": "Transaction received and validated successfully. Dispatched for being processed by the bank", "disbursement_status": "pending", "bank_transaction_type": "cash_transfer", "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": "1",
       +"payment_ref_num": "873368d8-b493-48f3-af71-32ac2540d3bf",
       +"paid_at": null,
       +"created_at": "2026-09-07 09:12:09",
       +"updated_at": "2026-09-16 13:25:39",
       +"local_currency": "EGP",
       +"local_amount": "2565.22",
       +"currency_rate": 51.3578,
       +"fees_amount": 1.0,
       +"local_fees_amount": 51.3,
       +"final_amount": 48.95,
       +"local_final_amount": 2513.92,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "1376.18",
       +"amount_sar": "100.13",
       +"amount_aed": "97.94",
       +"amount_kwd": "8.21",
     },
     {#1069
       +"id": 9452,
       +"payout_id": "a457f819d6",
       +"user_id": 405582,
       +"method_code": "e-wallet",
       +"account": "01007817857",
       +"amount": "0.53",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "declined",
       +"api_status": null,
       +"api_response": null,
       +"note": "1",
       +"payment_ref_num": null,
       +"paid_at": null,
       +"created_at": "2026-09-07 09:12:06",
       +"updated_at": "2026-09-14 11:09:32",
       +"local_currency": "EGP",
       +"local_amount": "27.13",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 0.14,
       +"local_final_amount": 7.13,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "27.13",
       +"amount_sar": "2.06",
       +"amount_aed": "2.02",
       +"amount_kwd": "0.17",
     },
     {#1070
       +"id": 9451,
       +"payout_id": "8aae1527b",
       +"user_id": 405290,
       +"method_code": "bank-transfer-eg",
       +"account": "EG280005200300000203067461001",
       +"amount": "0.31",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "declined",
       +"api_status": null,
       +"api_response": null,
       +"note": "1",
       +"payment_ref_num": null,
       +"paid_at": null,
       +"created_at": "2026-09-07 09:11:53",
       +"updated_at": "2026-09-14 11:11:38",
       +"local_currency": "EGP",
       +"local_amount": "15.71",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": -0.08,
       +"local_final_amount": -4.29,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "15.71",
       +"amount_sar": "1.19",
       +"amount_aed": "1.18",
       +"amount_kwd": "0.10",
     },
     {#1071
       +"id": 9450,
       +"payout_id": "f4f7567cca",
       +"user_id": 405167,
       +"method_code": "e-wallet",
       +"account": "01101312758",
       +"amount": "4.64",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "successful",
       +"api_response": "{"vat": 0.2753, "fees": 1.9666, "amount": 218.51, "issuer": "etisalat", "msisdn": "01101312758", "comment1": "", "bank_name": null, "full_name": "", "reference": null, "created_at": "2026-09-16 06:16:44.368525", "updated_at": "2026-09-16 06:16:47.849219", "status_code": "200", "reference_id": "023754821589", "transaction_id": "e8d757c4-a399-43df-aaa8-5a0f8e144110", "status_description": "amount is deposited successfully", "disbursement_status": "successful", "aman_cashing_details": null, "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": "1",
       +"payment_ref_num": "e8d757c4-a399-43df-aaa8-5a0f8e144110",
       +"paid_at": "2026-09-16",
       +"created_at": "2026-09-07 09:11:48",
       +"updated_at": "2026-09-16 06:16:47",
       +"local_currency": "EGP",
       +"local_amount": "238.51",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 4.25,
       +"local_final_amount": 218.51,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "53.80",
       +"amount_sar": "4.05",
       +"amount_aed": "3.96",
       +"amount_kwd": "0.33",
     },
     {#1072
       +"id": 9449,
       +"payout_id": "07061146c8",
       +"user_id": 404928,
       +"method_code": "e-wallet",
       +"account": "01100417838",
       +"amount": "0.08",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "declined",
       +"api_status": null,
       +"api_response": null,
       +"note": "1",
       +"payment_ref_num": null,
       +"paid_at": null,
       +"created_at": "2026-09-07 09:11:40",
       +"updated_at": "2026-09-14 11:12:55",
       +"local_currency": "EGP",
       +"local_amount": "4.02",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": -0.31,
       +"local_final_amount": -15.98,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "4.02",
       +"amount_sar": "0.30",
       +"amount_aed": "0.29",
       +"amount_kwd": "0.02",
     },
     {#1073
       +"id": 9448,
       +"payout_id": "a30eb19",
       +"user_id": 404917,
       +"method_code": "e-wallet",
       +"account": "01099095293",
       +"amount": "0.74",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "declined",
       +"api_status": null,
       +"api_response": null,
       +"note": "1",
       +"payment_ref_num": null,
       +"paid_at": null,
       +"created_at": "2026-09-07 09:11:36",
       +"updated_at": "2026-09-14 11:08:12",
       +"local_currency": "EGP",
       +"local_amount": "37.76",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 0.35,
       +"local_final_amount": 17.76,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "37.76",
       +"amount_sar": "2.78",
       +"amount_aed": "2.72",
       +"amount_kwd": "0.22",
     },
     {#1074
       +"id": 9447,
       +"payout_id": "a3ee3ea60f",
       +"user_id": 404842,
       +"method_code": "bank-transfer-eg",
       +"account": "EG330003023650001827373010120",
       +"amount": "9.31",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "8000",
       +"api_response": "{"vat": 1.4, "fees": 10.0, "amount": "458.21", "issuer": "bank_card", "bank_code": "NBE", "full_name": "Mohamed abdel satar", "reference": null, "created_at": "2026-09-16 06:16:40.403413", "updated_at": "2026-09-16 06:16:41.442766", "status_code": "8000", "transaction_id": "d3fa29ab-dd1b-4987-994c-0d5a16efc4d7", "bank_card_number": "EG330003023650001827373010120", "status_description": "Transaction received and validated successfully. Dispatched for being processed by the bank", "disbursement_status": "pending", "bank_transaction_type": "cash_transfer", "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": "1",
       +"payment_ref_num": "d3fa29ab-dd1b-4987-994c-0d5a16efc4d7",
       +"paid_at": null,
       +"created_at": "2026-09-07 09:11:28",
       +"updated_at": "2026-09-16 13:24:37",
       +"local_currency": "EGP",
       +"local_amount": "478.21",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 8.92,
       +"local_final_amount": 458.21,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "50.82",
       +"amount_sar": "3.80",
       +"amount_aed": "3.71",
       +"amount_kwd": "0.31",
     },
     {#1075
       +"id": 9446,
       +"payout_id": "1b6314266b",
       +"user_id": 404366,
       +"method_code": "e-wallet",
       +"account": "01027635080",
       +"amount": "0.05",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "declined",
       +"api_status": null,
       +"api_response": null,
       +"note": "1",
       +"payment_ref_num": null,
       +"paid_at": null,
       +"created_at": "2026-09-07 09:11:14",
       +"updated_at": "2026-09-14 11:13:34",
       +"local_currency": "EGP",
       +"local_amount": "2.61",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": -0.34,
       +"local_final_amount": -17.39,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "2.61",
       +"amount_sar": "0.19",
       +"amount_aed": "0.18",
       +"amount_kwd": "0.02",
     },
     {#1076
       +"id": 9445,
       +"payout_id": "ddaa6cbe68",
       +"user_id": 403879,
       +"method_code": "bank-transfer-eg",
       +"account": "EG120010003300000100012293628",
       +"amount": "0.45",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "declined",
       +"api_status": null,
       +"api_response": null,
       +"note": "1",
       +"payment_ref_num": null,
       +"paid_at": null,
       +"created_at": "2026-09-07 09:11:05",
       +"updated_at": "2026-09-14 11:09:45",
       +"local_currency": "EGP",
       +"local_amount": "22.93",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 0.06,
       +"local_final_amount": 2.93,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "22.93",
       +"amount_sar": "1.73",
       +"amount_aed": "1.69",
       +"amount_kwd": "0.14",
     },
     {#1077
       +"id": 9444,
       +"payout_id": "b16320cf25",
       +"user_id": 403863,
       +"method_code": "bank-transfer-eg",
       +"account": "EG030037002708181020698490335",
       +"amount": "15.26",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "8000",
       +"api_response": "{"vat": 1.4, "fees": 10.0, "amount": "763.85", "issuer": "bank_card", "bank_code": "QNB", "full_name": "Emey Elsawy", "reference": null, "created_at": "2026-09-16 06:16:35.605532", "updated_at": "2026-09-16 06:16:36.642749", "status_code": "8000", "transaction_id": "96292c9e-1301-4684-96c5-6d6c05de4b76", "bank_card_number": "EG030037002708181020698490335", "status_description": "Transaction received and validated successfully. Dispatched for being processed by the bank", "disbursement_status": "pending", "bank_transaction_type": "cash_transfer", "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": "1",
       +"payment_ref_num": "96292c9e-1301-4684-96c5-6d6c05de4b76",
       +"paid_at": null,
       +"created_at": "2026-09-07 09:11:01",
       +"updated_at": "2026-09-16 13:23:35",
       +"local_currency": "EGP",
       +"local_amount": "783.85",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 14.87,
       +"local_final_amount": 763.85,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "783.85",
       +"amount_sar": "57.73",
       +"amount_aed": "56.52",
       +"amount_kwd": "4.73",
     },
     {#1078
       +"id": 9443,
       +"payout_id": "d09b33bffa",
       +"user_id": 403526,
       +"method_code": "bank-transfer-eg",
       +"account": "EG870002019301930333000008781",
       +"amount": "1.89",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "8000",
       +"api_response": "{"vat": 1.4, "fees": 10.0, "amount": "77.13", "issuer": "bank_card", "bank_code": "MISR", "full_name": "Mohamed Haggag Ali", "reference": null, "created_at": "2026-09-16 06:16:30.853569", "updated_at": "2026-09-16 06:16:31.878606", "status_code": "8000", "transaction_id": "2213840c-f953-4b0e-864e-fc718c149039", "bank_card_number": "EG870002019301930333000008781", "status_description": "Transaction received and validated successfully. Dispatched for being processed by the bank", "disbursement_status": "pending", "bank_transaction_type": "cash_transfer", "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": "1",
       +"payment_ref_num": "2213840c-f953-4b0e-864e-fc718c149039",
       +"paid_at": null,
       +"created_at": "2026-09-07 09:10:47",
       +"updated_at": "2026-09-16 13:22:33",
       +"local_currency": "EGP",
       +"local_amount": "97.13",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 1.5,
       +"local_final_amount": 77.13,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "7.34",
       +"amount_sar": "0.53",
       +"amount_aed": "0.51",
       +"amount_kwd": "0.04",
     },
     {#1079
       +"id": 9442,
       +"payout_id": "09bc853bde",
       +"user_id": 403523,
       +"method_code": "bank-transfer-eg",
       +"account": "EG550036000100000281430000697",
       +"amount": "228.50",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "8000",
       +"api_response": "{"vat": 1.615, "fees": 11.5355, "amount": "11535.51", "issuer": "bank_card", "bank_code": "CAE", "full_name": "Karim Zeen", "reference": null, "created_at": "2026-09-16 06:16:26.191805", "updated_at": "2026-09-16 06:16:27.218026", "status_code": "8000", "transaction_id": "7b8130c2-ebb0-4ef8-b849-9771173baeaf", "bank_card_number": "EG550036000100000281430000697", "status_description": "Transaction received and validated successfully. Dispatched for being processed by the bank", "disbursement_status": "pending", "bank_transaction_type": "cash_transfer", "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": "1",
       +"payment_ref_num": "7b8130c2-ebb0-4ef8-b849-9771173baeaf",
       +"paid_at": null,
       +"created_at": "2026-09-07 09:10:44",
       +"updated_at": "2026-09-16 13:21:31",
       +"local_currency": "EGP",
       +"local_amount": "11735.51",
       +"currency_rate": 51.3578,
       +"fees_amount": 3.89,
       +"local_fees_amount": 200.0,
       +"final_amount": 224.61,
       +"local_final_amount": 11535.51,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "11735.51",
       +"amount_sar": "855.78",
       +"amount_aed": "837.73",
       +"amount_kwd": "70.43",
     },
     {#1080
       +"id": 9441,
       +"payout_id": "f37594db6f",
       +"user_id": 403436,
       +"method_code": "e-wallet",
       +"account": "01016185605",
       +"amount": "1.46",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "successful",
       +"api_response": "{"vat": 0.0695, "fees": 0.4962, "amount": 55.13, "issuer": "vodafone", "msisdn": "01016185605", "comment1": "", "bank_name": null, "full_name": "", "reference": null, "created_at": "2026-09-16 06:16:21.582654", "updated_at": "2026-09-16 06:16:23.675548", "status_code": "200", "reference_id": "023754816778", "transaction_id": "e26abd33-5ef0-4c51-8cbb-0068a5bc9e74", "status_description": "تم إيداع 55.1 جنيه إلى رقم 01016185605 بنجاح", "disbursement_status": "successful", "aman_cashing_details": null, "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": "1",
       +"payment_ref_num": "e26abd33-5ef0-4c51-8cbb-0068a5bc9e74",
       +"paid_at": "2026-09-16",
       +"created_at": "2026-09-07 09:10:37",
       +"updated_at": "2026-09-16 06:16:23",
       +"local_currency": "EGP",
       +"local_amount": "75.13",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 1.07,
       +"local_final_amount": 55.13,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "75.13",
       +"amount_sar": "5.64",
       +"amount_aed": "5.52",
       +"amount_kwd": "0.47",
     },
     {#1081
       +"id": 9440,
       +"payout_id": "c93173d4a7",
       +"user_id": 403309,
       +"method_code": "e-wallet",
       +"account": " 01070033256",
       +"amount": "52.17",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "successful",
       +"api_response": "{"vat": 3.3087, "fees": 23.6336, "amount": 2625.95, "issuer": "vodafone", "msisdn": "01070033256", "comment1": "", "bank_name": null, "full_name": "", "reference": null, "created_at": "2026-09-16 06:16:15.368556", "updated_at": "2026-09-16 06:16:17.870956", "status_code": "200", "reference_id": "023754815511", "transaction_id": "c55b8834-e8c6-43ec-8e43-8d61119ab1a9", "status_description": "تم إيداع 2625.9 جنيه إلى رقم 01070033256 بنجاح", "disbursement_status": "successful", "aman_cashing_details": null, "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": "1",
       +"payment_ref_num": "c55b8834-e8c6-43ec-8e43-8d61119ab1a9",
       +"paid_at": "2026-09-16",
       +"created_at": "2026-09-07 09:10:29",
       +"updated_at": "2026-09-16 06:16:17",
       +"local_currency": "EGP",
       +"local_amount": "2679.54",
       +"currency_rate": 51.3578,
       +"fees_amount": 1.04,
       +"local_fees_amount": 53.59,
       +"final_amount": 51.13,
       +"local_final_amount": 2625.95,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "2679.54",
       +"amount_sar": "196.89",
       +"amount_aed": "192.80",
       +"amount_kwd": "16.14",
     },
     {#1082
       +"id": 9439,
       +"payout_id": "7d58de8a61",
       +"user_id": 403280,
       +"method_code": "e-wallet",
       +"account": "01000177491",
       +"amount": "64.91",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "successful",
       +"api_response": "{"vat": 4.1162, "fees": 29.4011, "amount": 3266.79, "issuer": "vodafone", "msisdn": "01000177491", "comment1": "", "bank_name": null, "full_name": "", "reference": null, "created_at": "2026-09-16 06:16:09.658781", "updated_at": "2026-09-16 06:16:11.580551", "status_code": "200", "reference_id": "023754814339", "transaction_id": "e3cda133-6fa3-4f44-9f46-d0a4c57e4736", "status_description": "تم إيداع 3266.8 جنيه إلى رقم 01000177491 بنجاح", "disbursement_status": "successful", "aman_cashing_details": null, "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": "1",
       +"payment_ref_num": "e3cda133-6fa3-4f44-9f46-d0a4c57e4736",
       +"paid_at": "2026-09-16",
       +"created_at": "2026-09-07 09:10:23",
       +"updated_at": "2026-09-16 06:16:11",
       +"local_currency": "EGP",
       +"local_amount": "3333.46",
       +"currency_rate": 51.3578,
       +"fees_amount": 1.3,
       +"local_fees_amount": 66.67,
       +"final_amount": 63.61,
       +"local_final_amount": 3266.79,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "2266.78",
       +"amount_sar": "166.31",
       +"amount_aed": "162.72",
       +"amount_kwd": "13.67",
     },
     {#1083
       +"id": 9438,
       +"payout_id": "089cb79296",
       +"user_id": 403239,
       +"method_code": "bank-transfer-eg",
       +"account": "EG310037073608181130602132329",
       +"amount": "16.03",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "8000",
       +"api_response": "{"vat": 1.4, "fees": 10.0, "amount": "803.38", "issuer": "bank_card", "bank_code": "QNB", "full_name": "HUSSIEN ELSAYED HUSSIEN", "reference": null, "created_at": "2026-09-16 06:16:06.192166", "updated_at": "2026-09-16 06:16:07.250807", "status_code": "8000", "transaction_id": "768ac3af-c72f-42a5-8d0b-c5e4cae58327", "bank_card_number": "EG310037073608181130602132329", "status_description": "Transaction received and validated successfully. Dispatched for being processed by the bank", "disbursement_status": "pending", "bank_transaction_type": "cash_transfer", "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": "1",
       +"payment_ref_num": "768ac3af-c72f-42a5-8d0b-c5e4cae58327",
       +"paid_at": null,
       +"created_at": "2026-09-07 09:10:18",
       +"updated_at": "2026-09-16 13:20:25",
       +"local_currency": "EGP",
       +"local_amount": "823.38",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.39,
       +"local_fees_amount": 20.0,
       +"final_amount": 15.64,
       +"local_final_amount": 803.38,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "149.97",
       +"amount_sar": "11.21",
       +"amount_aed": "10.98",
       +"amount_kwd": "0.92",
     },
     {#1084
       +"id": 9437,
       +"payout_id": "04a6628da3",
       +"user_id": 403157,
       +"method_code": "bank-transfer-eg",
       +"account": "EG320010013700000100070693695",
       +"amount": "23.03",
       +"cashback_amount": "0.00",
       +"reward_amount": "0.00",
       +"status": "completed",
       +"api_status": "8000",
       +"api_response": "{"vat": 1.4, "fees": 10.0, "amount": "1159.32", "issuer": "bank_card", "bank_code": "CIB", "full_name": "نورا محمد حسين محمد", "reference": null, "created_at": "2026-09-16 06:16:01.885944", "updated_at": "2026-09-16 06:16:02.931324", "status_code": "8000", "transaction_id": "afd5ec98-ccc6-4c41-9fef-92fb09475d73", "bank_card_number": "EG320010013700000100070693695", "status_description": "Transaction received and validated successfully. Dispatched for being processed by the bank", "disbursement_status": "pending", "bank_transaction_type": "cash_transfer", "accept_balance_transfer_id": null, "client_transaction_reference": null}",
       +"note": "1",
       +"payment_ref_num": "afd5ec98-ccc6-4c41-9fef-92fb09475d73",
       +"paid_at": null,
       +"created_at": "2026-09-07 09:10:14",
       +"updated_at": "2026-09-16 14:20:06",
       +"local_currency": "EGP",
       +"local_amount": "1182.98",
       +"currency_rate": 51.3578,
       +"fees_amount": 0.46,
       +"local_fees_amount": 23.66,
       +"final_amount": 22.57,
       +"local_final_amount": 1159.32,
       +"fees_data": "{"type": "percentage", "amount": "2.00", "min_amount": 20}",
       +"is_reset": 0,
       +"amount_egp": "1161.43",
       +"amount_sar": "86.60",
       +"amount_aed": "84.78",
       +"amount_kwd": "7.21",
     },
   ]
>>> foreach($up2 as $r) { echo json_encode($r)."
... "; }
{"id":9466,"payout_id":"d65f841956","user_id":230013,"method_code":"e-wallet","account":"01019244122","amount":"1.47","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"successful","api_response":"{\"vat\": 0.0698, \"fees\": 0.4988, \"amount\": 55.42, \"issuer\": \"vodafone\", \"msisdn\": \"01019244122\", \"comment1\": \"\", \"bank_name\": null, \"full_name\": \"\", \"reference\": null, \"created_at\": \"2026-09-16 06:17:58.931961\", \"updated_at\": \"2026-09-16 06:18:00.907489\", \"status_code\": \"200\", \"reference_id\": \"023754836657\", \"transaction_id\": \"5e9e5a73-612a-4bf2-a067-dde922653984\", \"status_description\": \"\u062a\u0645 \u0625\u064a\u062f\u0627\u0639 55.4 \u062c\u0646\u064a\u0647 \u0625\u0644\u0649 \u0631\u0642\u0645 01019244122 \u0628\u0646\u062c\u0627\u062d\", \"disbursement_status\": \"successful\", \"aman_cashing_details\": null, \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":null,"payment_ref_num":"5e9e5a73-612a-4bf2-a067-dde922653984","paid_at":"2026-09-16","created_at":"2026-09-14 11:50:24","updated_at":"2026-09-16 06:18:00","local_currency":"EGP","local_amount":"75.42","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":1.08,"local_final_amount":55.42,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"75.50","amount_sar":"5.51","amount_aed":"5.39","amount_kwd":"0.46"}
{"id":9465,"payout_id":"7934daecd7","user_id":402963,"method_code":"e-wallet","account":"01156139115","amount":"1.68","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"successful","api_response":"{\"vat\": 0.0834, \"fees\": 0.5958, \"amount\": 66.2, \"issuer\": \"etisalat\", \"msisdn\": \"01156139115\", \"comment1\": \"\", \"bank_name\": null, \"full_name\": \"\", \"reference\": null, \"created_at\": \"2026-09-16 06:17:51.732433\", \"updated_at\": \"2026-09-16 06:17:55.242603\", \"status_code\": \"200\", \"reference_id\": \"023754835270\", \"transaction_id\": \"c1a04bd7-f3f8-4814-a422-0ba04e81d1e6\", \"status_description\": \"amount is deposited successfully\", \"disbursement_status\": \"successful\", \"aman_cashing_details\": null, \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":null,"payment_ref_num":"c1a04bd7-f3f8-4814-a422-0ba04e81d1e6","paid_at":"2026-09-16","created_at":"2026-09-14 11:49:32","updated_at":"2026-09-16 06:17:55","local_currency":"EGP","local_amount":"86.20","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":1.29,"local_final_amount":66.2,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"86.28","amount_sar":"6.30","amount_aed":"6.17","amount_kwd":"0.52"}
{"id":9464,"payout_id":"58b005","user_id":403702,"method_code":"e-wallet","account":"01029554735","amount":"2.12","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"successful","api_response":"{\"vat\": 0.1117, \"fees\": 0.7982, \"amount\": 88.69, \"issuer\": \"vodafone\", \"msisdn\": \"01029554735\", \"comment1\": \"\", \"bank_name\": null, \"full_name\": \"\", \"reference\": null, \"created_at\": \"2026-09-16 06:17:46.568004\", \"updated_at\": \"2026-09-16 06:17:49.023085\", \"status_code\": \"200\", \"reference_id\": \"023754834062\", \"transaction_id\": \"ddb4baa9-59df-4bc9-a4fb-f6b2f986c75e\", \"status_description\": \"\u062a\u0645 \u0625\u064a\u062f\u0627\u0639 88.7 \u062c\u0646\u064a\u0647 \u0625\u0644\u0649 \u0631\u0642\u0645 01029554735 \u0628\u0646\u062c\u0627\u062d\", \"disbursement_status\": \"successful\", \"aman_cashing_details\": null, \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":null,"payment_ref_num":"ddb4baa9-59df-4bc9-a4fb-f6b2f986c75e","paid_at":"2026-09-16","created_at":"2026-09-14 11:48:42","updated_at":"2026-09-16 06:17:49","local_currency":"EGP","local_amount":"108.69","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":1.73,"local_final_amount":88.69,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"108.88","amount_sar":"7.95","amount_aed":"7.78","amount_kwd":"0.66"}
{"id":9463,"payout_id":"f94fb7431e","user_id":402972,"method_code":"e-wallet","account":"01030006151","amount":"2.73","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"successful","api_response":"{\"vat\": 0.1513, \"fees\": 1.0806, \"amount\": 120.07, \"issuer\": \"vodafone\", \"msisdn\": \"01030006151\", \"comment1\": \"\", \"bank_name\": null, \"full_name\": \"\", \"reference\": null, \"created_at\": \"2026-09-16 06:17:41.687815\", \"updated_at\": \"2026-09-16 06:17:43.721851\", \"status_code\": \"200\", \"reference_id\": \"023754833050\", \"transaction_id\": \"cb40aafa-a7f5-46c3-af34-ca81a2a580ed\", \"status_description\": \"\u062a\u0645 \u0625\u064a\u062f\u0627\u0639 120.1 \u062c\u0646\u064a\u0647 \u0625\u0644\u0649 \u0631\u0642\u0645 01030006151 \u0628\u0646\u062c\u0627\u062d\", \"disbursement_status\": \"successful\", \"aman_cashing_details\": null, \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":null,"payment_ref_num":"cb40aafa-a7f5-46c3-af34-ca81a2a580ed","paid_at":"2026-09-16","created_at":"2026-09-14 11:47:03","updated_at":"2026-09-16 06:17:43","local_currency":"EGP","local_amount":"140.07","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":2.34,"local_final_amount":120.07,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"140.21","amount_sar":"10.24","amount_aed":"10.02","amount_kwd":"0.85"}
{"id":9462,"payout_id":"ac7d870be3","user_id":381403,"method_code":"e-wallet","account":"01011254411","amount":"2.91","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"successful","api_response":"{\"vat\": 0.1632, \"fees\": 1.1659, \"amount\": 129.54, \"issuer\": \"vodafone\", \"msisdn\": \"01011254411\", \"comment1\": \"\", \"bank_name\": null, \"full_name\": \"\", \"reference\": null, \"created_at\": \"2026-09-16 06:17:35.656331\", \"updated_at\": \"2026-09-16 06:17:37.968206\", \"status_code\": \"200\", \"reference_id\": \"023754831779\", \"transaction_id\": \"df503552-d578-4c8c-8758-0b181dcafa4a\", \"status_description\": \"\u062a\u0645 \u0625\u064a\u062f\u0627\u0639 129.5 \u062c\u0646\u064a\u0647 \u0625\u0644\u0649 \u0631\u0642\u0645 01011254411 \u0628\u0646\u062c\u0627\u062d\", \"disbursement_status\": \"successful\", \"aman_cashing_details\": null, \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":null,"payment_ref_num":"df503552-d578-4c8c-8758-0b181dcafa4a","paid_at":"2026-09-16","created_at":"2026-09-14 11:46:04","updated_at":"2026-09-16 06:17:38","local_currency":"EGP","local_amount":"149.54","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":2.52,"local_final_amount":129.54,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"149.46","amount_sar":"10.91","amount_aed":"10.68","amount_kwd":"0.90"}
{"id":9461,"payout_id":"01c83ac195","user_id":405843,"method_code":"e-wallet","account":"01228393823","amount":"4.32","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"successful","api_response":"{\"vat\": 0.2545, \"fees\": 1.818, \"amount\": 202.0, \"issuer\": \"bank_wallet\", \"msisdn\": \"01228393823\", \"comment1\": \"\", \"bank_name\": null, \"full_name\": \"\", \"reference\": null, \"created_at\": \"2026-09-16 06:17:28.895809\", \"updated_at\": \"2026-09-16 06:17:31.885636\", \"status_code\": \"200\", \"reference_id\": \"023754830569\", \"transaction_id\": \"bf9866ec-1fb3-4b00-8a4f-2db15dfda0d6\", \"status_description\": \"amount is deposited successfully\", \"disbursement_status\": \"successful\", \"aman_cashing_details\": null, \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":null,"payment_ref_num":"bf9866ec-1fb3-4b00-8a4f-2db15dfda0d6","paid_at":"2026-09-16","created_at":"2026-09-14 11:23:58","updated_at":"2026-09-16 06:17:31","local_currency":"EGP","local_amount":"222.00","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":3.93,"local_final_amount":202,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"221.88","amount_sar":"16.20","amount_aed":"15.85","amount_kwd":"1.34"}
{"id":9460,"payout_id":"9d7f448988","user_id":24929,"method_code":"e-wallet","account":"01018586698","amount":"5.15","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"successful","api_response":"{\"vat\": 0.3079, \"fees\": 2.1996, \"amount\": 244.4, \"issuer\": \"vodafone\", \"msisdn\": \"01018586698\", \"comment1\": \"\", \"bank_name\": null, \"full_name\": \"\", \"reference\": null, \"created_at\": \"2026-09-16 06:17:23.710363\", \"updated_at\": \"2026-09-16 06:17:25.596860\", \"status_code\": \"200\", \"reference_id\": \"023754829392\", \"transaction_id\": \"e51b42f1-443a-4d2d-99d5-60a88c7a488f\", \"status_description\": \"\u062a\u0645 \u0625\u064a\u062f\u0627\u0639 244.4 \u062c\u0646\u064a\u0647 \u0625\u0644\u0649 \u0631\u0642\u0645 01018586698 \u0628\u0646\u062c\u0627\u062d\", \"disbursement_status\": \"successful\", \"aman_cashing_details\": null, \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":null,"payment_ref_num":"e51b42f1-443a-4d2d-99d5-60a88c7a488f","paid_at":"2026-09-16","created_at":"2026-09-14 11:17:45","updated_at":"2026-09-16 06:17:25","local_currency":"EGP","local_amount":"264.40","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":4.76,"local_final_amount":244.4,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"264.50","amount_sar":"19.31","amount_aed":"18.90","amount_kwd":"1.60"}
{"id":9459,"payout_id":"4026faedf4","user_id":403486,"method_code":"bank-transfer-eg","account":" EG410002013301330331000001508","amount":"6.50","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"8000","api_response":"{\"vat\": 1.4, \"fees\": 10.0, \"amount\": \"314.01\", \"issuer\": \"bank_card\", \"bank_code\": \"MISR\", \"full_name\": \"Ahmed Mohamed Mohamed Ahmed\", \"reference\": null, \"created_at\": \"2026-09-16 06:17:18.807891\", \"updated_at\": \"2026-09-16 06:17:19.839158\", \"status_code\": \"8000\", \"transaction_id\": \"3218142e-0d18-49e3-a4b2-2a2d566fd92a\", \"bank_card_number\": \"EG410002013301330331000001508\", \"status_description\": \"Transaction received and validated successfully. Dispatched for being processed by the bank\", \"disbursement_status\": \"pending\", \"bank_transaction_type\": \"cash_transfer\", \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":null,"payment_ref_num":"3218142e-0d18-49e3-a4b2-2a2d566fd92a","paid_at":null,"created_at":"2026-09-14 11:17:00","updated_at":"2026-09-16 13:29:48","local_currency":"EGP","local_amount":"334.01","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":6.11,"local_final_amount":314.01,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"333.84","amount_sar":"24.38","amount_aed":"23.86","amount_kwd":"2.02"}
{"id":9458,"payout_id":"0728b9059f","user_id":406573,"method_code":"bank-transfer-eg","account":"EG280003017750010117440010180","amount":"409.53","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"8000","api_response":"{\"vat\": 2.9166, \"fees\": 20.8325, \"amount\": \"20832.47\", \"issuer\": \"bank_card\", \"bank_code\": \"NBE\", \"full_name\": \"\u2019Marwa abd elaaal Mohamed\", \"reference\": null, \"created_at\": \"2026-09-16 06:17:13.824280\", \"updated_at\": \"2026-09-16 06:17:14.877260\", \"status_code\": \"8000\", \"transaction_id\": \"c9bd6ec8-d4dd-4514-bad4-37a6797814ca\", \"bank_card_number\": \"EG280003017750010117440010180\", \"status_description\": \"Transaction received and validated successfully. Dispatched for being processed by the bank\", \"disbursement_status\": \"pending\", \"bank_transaction_type\": \"cash_transfer\", \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":null,"payment_ref_num":"c9bd6ec8-d4dd-4514-bad4-37a6797814ca","paid_at":null,"created_at":"2026-09-14 11:16:27","updated_at":"2026-09-16 13:28:46","local_currency":"EGP","local_amount":"21032.47","currency_rate":51.3578,"fees_amount":3.89,"local_fees_amount":200,"final_amount":405.63,"local_final_amount":20832.47,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"21033.46","amount_sar":"1535.74","amount_aed":"1502.98","amount_kwd":"126.95"}
{"id":9457,"payout_id":"3662285bd8","user_id":403461,"method_code":"bank-transfer-eg","account":"1130587705949","amount":"104.10","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"8000","api_response":"{\"vat\": 1.4, \"fees\": 10.0, \"amount\": \"5239.51\", \"issuer\": \"bank_card\", \"bank_code\": \"QNB\", \"full_name\": \"Ahmed Alaa Abdelrahim\", \"reference\": null, \"created_at\": \"2026-09-16 06:17:10.512046\", \"updated_at\": \"2026-09-16 06:17:11.530050\", \"status_code\": \"8000\", \"transaction_id\": \"1abd67cf-cca1-4821-8b71-240d1820148f\", \"bank_card_number\": \"1130587705949\", \"status_description\": \"Transaction received and validated successfully. Dispatched for being processed by the bank\", \"disbursement_status\": \"pending\", \"bank_transaction_type\": \"cash_transfer\", \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":null,"payment_ref_num":"1abd67cf-cca1-4821-8b71-240d1820148f","paid_at":null,"created_at":"2026-09-14 11:15:51","updated_at":"2026-09-16 13:27:44","local_currency":"EGP","local_amount":"5346.44","currency_rate":51.3578,"fees_amount":2.08,"local_fees_amount":106.93,"final_amount":102.02,"local_final_amount":5239.51,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"5346.58","amount_sar":"390.38","amount_aed":"382.05","amount_kwd":"32.27"}
{"id":9456,"payout_id":"4974912782","user_id":407179,"method_code":"e-wallet","account":"01098800002","amount":"30.61","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"successful","api_response":"{\"vat\": 1.9409, \"fees\": 13.8637, \"amount\": 1540.41, \"issuer\": \"vodafone\", \"msisdn\": \"01098800002\", \"comment1\": \"\", \"bank_name\": null, \"full_name\": \"\", \"reference\": null, \"created_at\": \"2026-09-16 06:17:04.490740\", \"updated_at\": \"2026-09-16 06:17:06.696232\", \"status_code\": \"200\", \"reference_id\": \"023754825515\", \"transaction_id\": \"d3bf2d2b-5a76-4c43-bbda-bbd3315e6585\", \"status_description\": \"\u062a\u0645 \u0625\u064a\u062f\u0627\u0639 1540.4 \u062c\u0646\u064a\u0647 \u0625\u0644\u0649 \u0631\u0642\u0645 01098800002 \u0628\u0646\u062c\u0627\u062d\", \"disbursement_status\": \"successful\", \"aman_cashing_details\": null, \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":null,"payment_ref_num":"d3bf2d2b-5a76-4c43-bbda-bbd3315e6585","paid_at":"2026-09-16","created_at":"2026-09-14 08:49:02","updated_at":"2026-09-16 06:17:06","local_currency":"EGP","local_amount":"1571.85","currency_rate":51.3578,"fees_amount":0.61,"local_fees_amount":31.44,"final_amount":29.99,"local_final_amount":1540.41,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"1572.13","amount_sar":"114.79","amount_aed":"112.34","amount_kwd":"9.49"}
{"id":9455,"payout_id":"45c019cc86","user_id":405724,"method_code":"bank-transfer-eg","account":"EG740037002708181020702036735","amount":"7.22","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"8000","api_response":"{\"vat\": 1.4, \"fees\": 10.0, \"amount\": \"349.72\", \"issuer\": \"bank_card\", \"bank_code\": \"QNB\", \"full_name\": \"MOHAMED AMIR\", \"reference\": null, \"created_at\": \"2026-09-16 06:17:00.466101\", \"updated_at\": \"2026-09-16 06:17:01.501781\", \"status_code\": \"8000\", \"transaction_id\": \"a0e7e12f-93fb-4403-b2f1-62f6251532b1\", \"bank_card_number\": \"EG740037002708181020702036735\", \"status_description\": \"Transaction received and validated successfully. Dispatched for being processed by the bank\", \"disbursement_status\": \"pending\", \"bank_transaction_type\": \"cash_transfer\", \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":null,"payment_ref_num":"a0e7e12f-93fb-4403-b2f1-62f6251532b1","paid_at":null,"created_at":"2026-09-10 13:01:39","updated_at":"2026-09-16 13:26:42","local_currency":"EGP","local_amount":"369.72","currency_rate":51.1986,"fees_amount":0.39,"local_fees_amount":20,"final_amount":6.83,"local_final_amount":349.72,"fees_data":"{\"type\": \"percentage\", \"amount\": 5, \"min_amount\": 20}","is_reset":0,"amount_egp":"369.66","amount_sar":"27.08","amount_aed":"26.50","amount_kwd":"2.24"}
{"id":9454,"payout_id":"bef586a071","user_id":406238,"method_code":"e-wallet","account":"01060373918","amount":"4.73","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"successful","api_response":"{\"vat\": 0.2808, \"fees\": 2.0056, \"amount\": 222.85, \"issuer\": \"vodafone\", \"msisdn\": \"01060373918\", \"comment1\": \"\", \"bank_name\": null, \"full_name\": \"\", \"reference\": null, \"created_at\": \"2026-09-16 06:16:56.211655\", \"updated_at\": \"2026-09-16 06:16:58.067074\", \"status_code\": \"200\", \"reference_id\": \"023754823852\", \"transaction_id\": \"36ccf809-5d95-4d41-ac00-d6b109b5ea28\", \"status_description\": \"\u062a\u0645 \u0625\u064a\u062f\u0627\u0639 222.8 \u062c\u0646\u064a\u0647 \u0625\u0644\u0649 \u0631\u0642\u0645 01060373918 \u0628\u0646\u062c\u0627\u062d\", \"disbursement_status\": \"successful\", \"aman_cashing_details\": null, \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":"1","payment_ref_num":"36ccf809-5d95-4d41-ac00-d6b109b5ea28","paid_at":"2026-09-16","created_at":"2026-09-07 09:12:26","updated_at":"2026-09-16 06:16:58","local_currency":"EGP","local_amount":"242.85","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":4.34,"local_final_amount":222.85,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"35.06","amount_sar":"2.55","amount_aed":"2.50","amount_kwd":"0.21"}
{"id":9453,"payout_id":"ca77de8272","user_id":405586,"method_code":"bank-transfer-eg","account":"EG270002051905190333000027309","amount":"49.95","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"8000","api_response":"{\"vat\": 1.4, \"fees\": 10.0, \"amount\": \"2513.92\", \"issuer\": \"bank_card\", \"bank_code\": \"MISR\", \"full_name\": \"MAHMOUD ALI AHMED\", \"reference\": null, \"created_at\": \"2026-09-16 06:16:51.606895\", \"updated_at\": \"2026-09-16 06:16:52.636564\", \"status_code\": \"8000\", \"transaction_id\": \"873368d8-b493-48f3-af71-32ac2540d3bf\", \"bank_card_number\": \"EG270002051905190333000027309\", \"status_description\": \"Transaction received and validated successfully. Dispatched for being processed by the bank\", \"disbursement_status\": \"pending\", \"bank_transaction_type\": \"cash_transfer\", \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":"1","payment_ref_num":"873368d8-b493-48f3-af71-32ac2540d3bf","paid_at":null,"created_at":"2026-09-07 09:12:09","updated_at":"2026-09-16 13:25:39","local_currency":"EGP","local_amount":"2565.22","currency_rate":51.3578,"fees_amount":1,"local_fees_amount":51.3,"final_amount":48.95,"local_final_amount":2513.92,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"1376.18","amount_sar":"100.13","amount_aed":"97.94","amount_kwd":"8.21"}
{"id":9452,"payout_id":"a457f819d6","user_id":405582,"method_code":"e-wallet","account":"01007817857","amount":"0.53","cashback_amount":"0.00","reward_amount":"0.00","status":"declined","api_status":null,"api_response":null,"note":"1","payment_ref_num":null,"paid_at":null,"created_at":"2026-09-07 09:12:06","updated_at":"2026-09-14 11:09:32","local_currency":"EGP","local_amount":"27.13","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":0.14,"local_final_amount":7.13,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"27.13","amount_sar":"2.06","amount_aed":"2.02","amount_kwd":"0.17"}
{"id":9451,"payout_id":"8aae1527b","user_id":405290,"method_code":"bank-transfer-eg","account":"EG280005200300000203067461001","amount":"0.31","cashback_amount":"0.00","reward_amount":"0.00","status":"declined","api_status":null,"api_response":null,"note":"1","payment_ref_num":null,"paid_at":null,"created_at":"2026-09-07 09:11:53","updated_at":"2026-09-14 11:11:38","local_currency":"EGP","local_amount":"15.71","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":-0.07999999999999996,"local_final_amount":-4.29,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"15.71","amount_sar":"1.19","amount_aed":"1.18","amount_kwd":"0.10"}
{"id":9450,"payout_id":"f4f7567cca","user_id":405167,"method_code":"e-wallet","account":"01101312758","amount":"4.64","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"successful","api_response":"{\"vat\": 0.2753, \"fees\": 1.9666, \"amount\": 218.51, \"issuer\": \"etisalat\", \"msisdn\": \"01101312758\", \"comment1\": \"\", \"bank_name\": null, \"full_name\": \"\", \"reference\": null, \"created_at\": \"2026-09-16 06:16:44.368525\", \"updated_at\": \"2026-09-16 06:16:47.849219\", \"status_code\": \"200\", \"reference_id\": \"023754821589\", \"transaction_id\": \"e8d757c4-a399-43df-aaa8-5a0f8e144110\", \"status_description\": \"amount is deposited successfully\", \"disbursement_status\": \"successful\", \"aman_cashing_details\": null, \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":"1","payment_ref_num":"e8d757c4-a399-43df-aaa8-5a0f8e144110","paid_at":"2026-09-16","created_at":"2026-09-07 09:11:48","updated_at":"2026-09-16 06:16:47","local_currency":"EGP","local_amount":"238.51","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":4.25,"local_final_amount":218.51,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"53.80","amount_sar":"4.05","amount_aed":"3.96","amount_kwd":"0.33"}
{"id":9449,"payout_id":"07061146c8","user_id":404928,"method_code":"e-wallet","account":"01100417838","amount":"0.08","cashback_amount":"0.00","reward_amount":"0.00","status":"declined","api_status":null,"api_response":null,"note":"1","payment_ref_num":null,"paid_at":null,"created_at":"2026-09-07 09:11:40","updated_at":"2026-09-14 11:12:55","local_currency":"EGP","local_amount":"4.02","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":-0.31000000000000005,"local_final_amount":-15.98,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"4.02","amount_sar":"0.30","amount_aed":"0.29","amount_kwd":"0.02"}
{"id":9448,"payout_id":"a30eb19","user_id":404917,"method_code":"e-wallet","account":"01099095293","amount":"0.74","cashback_amount":"0.00","reward_amount":"0.00","status":"declined","api_status":null,"api_response":null,"note":"1","payment_ref_num":null,"paid_at":null,"created_at":"2026-09-07 09:11:36","updated_at":"2026-09-14 11:08:12","local_currency":"EGP","local_amount":"37.76","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":0.35,"local_final_amount":17.76,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"37.76","amount_sar":"2.78","amount_aed":"2.72","amount_kwd":"0.22"}
{"id":9447,"payout_id":"a3ee3ea60f","user_id":404842,"method_code":"bank-transfer-eg","account":"EG330003023650001827373010120","amount":"9.31","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"8000","api_response":"{\"vat\": 1.4, \"fees\": 10.0, \"amount\": \"458.21\", \"issuer\": \"bank_card\", \"bank_code\": \"NBE\", \"full_name\": \"Mohamed abdel satar\", \"reference\": null, \"created_at\": \"2026-09-16 06:16:40.403413\", \"updated_at\": \"2026-09-16 06:16:41.442766\", \"status_code\": \"8000\", \"transaction_id\": \"d3fa29ab-dd1b-4987-994c-0d5a16efc4d7\", \"bank_card_number\": \"EG330003023650001827373010120\", \"status_description\": \"Transaction received and validated successfully. Dispatched for being processed by the bank\", \"disbursement_status\": \"pending\", \"bank_transaction_type\": \"cash_transfer\", \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":"1","payment_ref_num":"d3fa29ab-dd1b-4987-994c-0d5a16efc4d7","paid_at":null,"created_at":"2026-09-07 09:11:28","updated_at":"2026-09-16 13:24:37","local_currency":"EGP","local_amount":"478.21","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":8.92,"local_final_amount":458.21,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"50.82","amount_sar":"3.80","amount_aed":"3.71","amount_kwd":"0.31"}
{"id":9446,"payout_id":"1b6314266b","user_id":404366,"method_code":"e-wallet","account":"01027635080","amount":"0.05","cashback_amount":"0.00","reward_amount":"0.00","status":"declined","api_status":null,"api_response":null,"note":"1","payment_ref_num":null,"paid_at":null,"created_at":"2026-09-07 09:11:14","updated_at":"2026-09-14 11:13:34","local_currency":"EGP","local_amount":"2.61","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":-0.33999999999999997,"local_final_amount":-17.39,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"2.61","amount_sar":"0.19","amount_aed":"0.18","amount_kwd":"0.02"}
{"id":9445,"payout_id":"ddaa6cbe68","user_id":403879,"method_code":"bank-transfer-eg","account":"EG120010003300000100012293628","amount":"0.45","cashback_amount":"0.00","reward_amount":"0.00","status":"declined","api_status":null,"api_response":null,"note":"1","payment_ref_num":null,"paid_at":null,"created_at":"2026-09-07 09:11:05","updated_at":"2026-09-14 11:09:45","local_currency":"EGP","local_amount":"22.93","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":0.06,"local_final_amount":2.93,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"22.93","amount_sar":"1.73","amount_aed":"1.69","amount_kwd":"0.14"}
{"id":9444,"payout_id":"b16320cf25","user_id":403863,"method_code":"bank-transfer-eg","account":"EG030037002708181020698490335","amount":"15.26","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"8000","api_response":"{\"vat\": 1.4, \"fees\": 10.0, \"amount\": \"763.85\", \"issuer\": \"bank_card\", \"bank_code\": \"QNB\", \"full_name\": \"Emey Elsawy\", \"reference\": null, \"created_at\": \"2026-09-16 06:16:35.605532\", \"updated_at\": \"2026-09-16 06:16:36.642749\", \"status_code\": \"8000\", \"transaction_id\": \"96292c9e-1301-4684-96c5-6d6c05de4b76\", \"bank_card_number\": \"EG030037002708181020698490335\", \"status_description\": \"Transaction received and validated successfully. Dispatched for being processed by the bank\", \"disbursement_status\": \"pending\", \"bank_transaction_type\": \"cash_transfer\", \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":"1","payment_ref_num":"96292c9e-1301-4684-96c5-6d6c05de4b76","paid_at":null,"created_at":"2026-09-07 09:11:01","updated_at":"2026-09-16 13:23:35","local_currency":"EGP","local_amount":"783.85","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":14.87,"local_final_amount":763.85,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"783.85","amount_sar":"57.73","amount_aed":"56.52","amount_kwd":"4.73"}
{"id":9443,"payout_id":"d09b33bffa","user_id":403526,"method_code":"bank-transfer-eg","account":"EG870002019301930333000008781","amount":"1.89","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"8000","api_response":"{\"vat\": 1.4, \"fees\": 10.0, \"amount\": \"77.13\", \"issuer\": \"bank_card\", \"bank_code\": \"MISR\", \"full_name\": \"Mohamed Haggag Ali\", \"reference\": null, \"created_at\": \"2026-09-16 06:16:30.853569\", \"updated_at\": \"2026-09-16 06:16:31.878606\", \"status_code\": \"8000\", \"transaction_id\": \"2213840c-f953-4b0e-864e-fc718c149039\", \"bank_card_number\": \"EG870002019301930333000008781\", \"status_description\": \"Transaction received and validated successfully. Dispatched for being processed by the bank\", \"disbursement_status\": \"pending\", \"bank_transaction_type\": \"cash_transfer\", \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":"1","payment_ref_num":"2213840c-f953-4b0e-864e-fc718c149039","paid_at":null,"created_at":"2026-09-07 09:10:47","updated_at":"2026-09-16 13:22:33","local_currency":"EGP","local_amount":"97.13","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":1.5,"local_final_amount":77.13,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"7.34","amount_sar":"0.53","amount_aed":"0.51","amount_kwd":"0.04"}
{"id":9442,"payout_id":"09bc853bde","user_id":403523,"method_code":"bank-transfer-eg","account":"EG550036000100000281430000697","amount":"228.50","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"8000","api_response":"{\"vat\": 1.615, \"fees\": 11.5355, \"amount\": \"11535.51\", \"issuer\": \"bank_card\", \"bank_code\": \"CAE\", \"full_name\": \"Karim Zeen\", \"reference\": null, \"created_at\": \"2026-09-16 06:16:26.191805\", \"updated_at\": \"2026-09-16 06:16:27.218026\", \"status_code\": \"8000\", \"transaction_id\": \"7b8130c2-ebb0-4ef8-b849-9771173baeaf\", \"bank_card_number\": \"EG550036000100000281430000697\", \"status_description\": \"Transaction received and validated successfully. Dispatched for being processed by the bank\", \"disbursement_status\": \"pending\", \"bank_transaction_type\": \"cash_transfer\", \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":"1","payment_ref_num":"7b8130c2-ebb0-4ef8-b849-9771173baeaf","paid_at":null,"created_at":"2026-09-07 09:10:44","updated_at":"2026-09-16 13:21:31","local_currency":"EGP","local_amount":"11735.51","currency_rate":51.3578,"fees_amount":3.89,"local_fees_amount":200,"final_amount":224.61,"local_final_amount":11535.51,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"11735.51","amount_sar":"855.78","amount_aed":"837.73","amount_kwd":"70.43"}
{"id":9441,"payout_id":"f37594db6f","user_id":403436,"method_code":"e-wallet","account":"01016185605","amount":"1.46","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"successful","api_response":"{\"vat\": 0.0695, \"fees\": 0.4962, \"amount\": 55.13, \"issuer\": \"vodafone\", \"msisdn\": \"01016185605\", \"comment1\": \"\", \"bank_name\": null, \"full_name\": \"\", \"reference\": null, \"created_at\": \"2026-09-16 06:16:21.582654\", \"updated_at\": \"2026-09-16 06:16:23.675548\", \"status_code\": \"200\", \"reference_id\": \"023754816778\", \"transaction_id\": \"e26abd33-5ef0-4c51-8cbb-0068a5bc9e74\", \"status_description\": \"\u062a\u0645 \u0625\u064a\u062f\u0627\u0639 55.1 \u062c\u0646\u064a\u0647 \u0625\u0644\u0649 \u0631\u0642\u0645 01016185605 \u0628\u0646\u062c\u0627\u062d\", \"disbursement_status\": \"successful\", \"aman_cashing_details\": null, \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":"1","payment_ref_num":"e26abd33-5ef0-4c51-8cbb-0068a5bc9e74","paid_at":"2026-09-16","created_at":"2026-09-07 09:10:37","updated_at":"2026-09-16 06:16:23","local_currency":"EGP","local_amount":"75.13","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":1.07,"local_final_amount":55.13,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"75.13","amount_sar":"5.64","amount_aed":"5.52","amount_kwd":"0.47"}
{"id":9440,"payout_id":"c93173d4a7","user_id":403309,"method_code":"e-wallet","account":" 01070033256","amount":"52.17","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"successful","api_response":"{\"vat\": 3.3087, \"fees\": 23.6336, \"amount\": 2625.95, \"issuer\": \"vodafone\", \"msisdn\": \"01070033256\", \"comment1\": \"\", \"bank_name\": null, \"full_name\": \"\", \"reference\": null, \"created_at\": \"2026-09-16 06:16:15.368556\", \"updated_at\": \"2026-09-16 06:16:17.870956\", \"status_code\": \"200\", \"reference_id\": \"023754815511\", \"transaction_id\": \"c55b8834-e8c6-43ec-8e43-8d61119ab1a9\", \"status_description\": \"\u062a\u0645 \u0625\u064a\u062f\u0627\u0639 2625.9 \u062c\u0646\u064a\u0647 \u0625\u0644\u0649 \u0631\u0642\u0645 01070033256 \u0628\u0646\u062c\u0627\u062d\", \"disbursement_status\": \"successful\", \"aman_cashing_details\": null, \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":"1","payment_ref_num":"c55b8834-e8c6-43ec-8e43-8d61119ab1a9","paid_at":"2026-09-16","created_at":"2026-09-07 09:10:29","updated_at":"2026-09-16 06:16:17","local_currency":"EGP","local_amount":"2679.54","currency_rate":51.3578,"fees_amount":1.04,"local_fees_amount":53.59,"final_amount":51.13,"local_final_amount":2625.95,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"2679.54","amount_sar":"196.89","amount_aed":"192.80","amount_kwd":"16.14"}
{"id":9439,"payout_id":"7d58de8a61","user_id":403280,"method_code":"e-wallet","account":"01000177491","amount":"64.91","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"successful","api_response":"{\"vat\": 4.1162, \"fees\": 29.4011, \"amount\": 3266.79, \"issuer\": \"vodafone\", \"msisdn\": \"01000177491\", \"comment1\": \"\", \"bank_name\": null, \"full_name\": \"\", \"reference\": null, \"created_at\": \"2026-09-16 06:16:09.658781\", \"updated_at\": \"2026-09-16 06:16:11.580551\", \"status_code\": \"200\", \"reference_id\": \"023754814339\", \"transaction_id\": \"e3cda133-6fa3-4f44-9f46-d0a4c57e4736\", \"status_description\": \"\u062a\u0645 \u0625\u064a\u062f\u0627\u0639 3266.8 \u062c\u0646\u064a\u0647 \u0625\u0644\u0649 \u0631\u0642\u0645 01000177491 \u0628\u0646\u062c\u0627\u062d\", \"disbursement_status\": \"successful\", \"aman_cashing_details\": null, \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":"1","payment_ref_num":"e3cda133-6fa3-4f44-9f46-d0a4c57e4736","paid_at":"2026-09-16","created_at":"2026-09-07 09:10:23","updated_at":"2026-09-16 06:16:11","local_currency":"EGP","local_amount":"3333.46","currency_rate":51.3578,"fees_amount":1.3,"local_fees_amount":66.67,"final_amount":63.61,"local_final_amount":3266.79,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"2266.78","amount_sar":"166.31","amount_aed":"162.72","amount_kwd":"13.67"}
{"id":9438,"payout_id":"089cb79296","user_id":403239,"method_code":"bank-transfer-eg","account":"EG310037073608181130602132329","amount":"16.03","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"8000","api_response":"{\"vat\": 1.4, \"fees\": 10.0, \"amount\": \"803.38\", \"issuer\": \"bank_card\", \"bank_code\": \"QNB\", \"full_name\": \"HUSSIEN ELSAYED HUSSIEN\", \"reference\": null, \"created_at\": \"2026-09-16 06:16:06.192166\", \"updated_at\": \"2026-09-16 06:16:07.250807\", \"status_code\": \"8000\", \"transaction_id\": \"768ac3af-c72f-42a5-8d0b-c5e4cae58327\", \"bank_card_number\": \"EG310037073608181130602132329\", \"status_description\": \"Transaction received and validated successfully. Dispatched for being processed by the bank\", \"disbursement_status\": \"pending\", \"bank_transaction_type\": \"cash_transfer\", \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":"1","payment_ref_num":"768ac3af-c72f-42a5-8d0b-c5e4cae58327","paid_at":null,"created_at":"2026-09-07 09:10:18","updated_at":"2026-09-16 13:20:25","local_currency":"EGP","local_amount":"823.38","currency_rate":51.3578,"fees_amount":0.39,"local_fees_amount":20,"final_amount":15.64,"local_final_amount":803.38,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"149.97","amount_sar":"11.21","amount_aed":"10.98","amount_kwd":"0.92"}
{"id":9437,"payout_id":"04a6628da3","user_id":403157,"method_code":"bank-transfer-eg","account":"EG320010013700000100070693695","amount":"23.03","cashback_amount":"0.00","reward_amount":"0.00","status":"completed","api_status":"8000","api_response":"{\"vat\": 1.4, \"fees\": 10.0, \"amount\": \"1159.32\", \"issuer\": \"bank_card\", \"bank_code\": \"CIB\", \"full_name\": \"\u0646\u0648\u0631\u0627 \u0645\u062d\u0645\u062f \u062d\u0633\u064a\u0646 \u0645\u062d\u0645\u062f\", \"reference\": null, \"created_at\": \"2026-09-16 06:16:01.885944\", \"updated_at\": \"2026-09-16 06:16:02.931324\", \"status_code\": \"8000\", \"transaction_id\": \"afd5ec98-ccc6-4c41-9fef-92fb09475d73\", \"bank_card_number\": \"EG320010013700000100070693695\", \"status_description\": \"Transaction received and validated successfully. Dispatched for being processed by the bank\", \"disbursement_status\": \"pending\", \"bank_transaction_type\": \"cash_transfer\", \"accept_balance_transfer_id\": null, \"client_transaction_reference\": null}","note":"1","payment_ref_num":"afd5ec98-ccc6-4c41-9fef-92fb09475d73","paid_at":null,"created_at":"2026-09-07 09:10:14","updated_at":"2026-09-16 14:20:06","local_currency":"EGP","local_amount":"1182.98","currency_rate":51.3578,"fees_amount":0.46,"local_fees_amount":23.66,"final_amount":22.57,"local_final_amount":1159.32,"fees_data":"{\"type\": \"percentage\", \"amount\": \"2.00\", \"min_amount\": 20}","is_reset":0,"amount_egp":"1161.43","amount_sar":"86.60","amount_aed":"84.78","amount_kwd":"7.21"}
>>> echo "===NEGATIVE-USER-BALANCES-STRUCTURE===";
===NEGATIVE-USER-BALANCES-STRUCTURE===⏎
>>> $c = DB::select("DESCRIBE negative_user_balances"); foreach($c as $col) { echo $col->Field."|".$col->Type."
... "; }
id|bigint unsigned
user_id|bigint
pending_balance|decimal(10,2)
confirmed_balance|decimal(10,2)
created_at|timestamp
updated_at|timestamp
>>> echo "===NEGATIVE-BALANCES-SUMS===";
===NEGATIVE-BALANCES-SUMS===⏎
>>> $nb = DB::select("SELECT COUNT(*) as cnt FROM negative_user_balances")[0];
=> {#1030
     +"cnt": 0,
   }
>>> echo "negative_balances_count: ".$nb->cnt."
... ";
negative_balances_count: 0
>>> echo "===PAYOUT-METHODS-BY-TYPE===";
===PAYOUT-METHODS-BY-TYPE===⏎
>>> $pmt = DB::select("SELECT method_code, COUNT(*) as cnt FROM user_payout_methods WHERE deleted_at IS NULL GROUP BY method_code");
=> [
     {#1029
       +"method_code": "aman",
       +"cnt": 1377,
     },
     {#1035
       +"method_code": "bank-transfer",
       +"cnt": 501,
     },
     {#1113
       +"method_code": "bank-transfer-eg",
       +"cnt": 3335,
     },
     {#1031
       +"method_code": "cashu",
       +"cnt": 593,
     },
     {#1032
       +"method_code": "e-wallet",
       +"cnt": 24140,
     },
     {#1037
       +"method_code": "paypal",
       +"cnt": 559,
     },
   ]
>>> foreach($pmt as $r) { echo $r->method_code.": ".$r->cnt."
... "; }
aman: 1377
bank-transfer: 501
bank-transfer-eg: 3335
cashu: 593
e-wallet: 24140
paypal: 559
>>> echo "===BANK-TRANSFER-PAYOUT-METHODS-SAMPLE-30===";
===BANK-TRANSFER-PAYOUT-METHODS-SAMPLE-30===⏎
>>> $bt = DB::select("SELECT user_id, name, account, payout_data FROM user_payout_methods WHERE method_code = "bank-transfer" AND deleted_at IS NULL LIMIT 30"); 
;
PHP Parse error: Syntax error, unexpected T_STRING, expecting ')' on line 1
>>> foreach($bt as $r) { echo json_encode($r)."
... "; }
PHP Notice:  Undefined variable: bt in Psy Shell code on line 1
>>> echo "===SALES-SUMS===";
===SALES-SUMS===⏎
>>> $ss = DB::select("SELECT COUNT(*) as cnt, SUM(order_amount) as total_order, SUM(comission) as total_commission, SUM(local_order_amount) as total_local FROM sales")[0];
=> {#1109
     +"cnt": 2398946,
     +"total_order": "48556119.13",
     +"total_commission": "2584377.62",
     +"total_local": "1531629594.27",
   }
>>> echo "sales_count: ".$ss->cnt."
... ";
sales_count: 2398946
>>> echo "sales_total_order_amount: ".$ss->total_order."
... ";
sales_total_order_amount: 48556119.13
>>> echo "sales_total_comission: ".$ss->total_commission."
... ";
sales_total_comission: 2584377.62
>>> echo "sales_total_local_amount: ".$ss->total_local."
... ";
sales_total_local_amount: 1531629594.27
>>> echo "===SALES-BY-STATUS===";
===SALES-BY-STATUS===⏎
>>> $sb = DB::select("SELECT status, COUNT(*) as cnt FROM sales GROUP BY status");
=> [
     {#1066
       +"status": null,
       +"cnt": 2569,
     },
     {#1033
       +"status": "pending",
       +"cnt": 4289,
     },
     {#1108
       +"status": "confirmed",
       +"cnt": 2189035,
     },
     {#1063
       +"status": "declined",
       +"cnt": 203053,
     },
   ]
>>> foreach($sb as $r) { echo $r->status.": ".$r->cnt."
... "; }
: 2569
pending: 4289
confirmed: 2189035
declined: 203053
>>> echo "===DONE===";
===DONE===⏎
>>> exit;
Exit:  Goodbye