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 "===FINANCIAL-AGGREGATES===";
===FINANCIAL-AGGREGATES===⏎
>>> $b = DB::select("SELECT SUM(confirmed_balance) as total_confirmed, SUM(pending_balance) as total_pending, COUNT(*) as total_users, SUM(CASE WHEN confirmed_balance > 0 THEN 1 ELSE 0 END) as users_with_balance FROM users")[0];
=> {#1027
     +"total_confirmed": "387533.10",
     +"total_pending": "1509677.86",
     +"total_users": 406776,
     +"users_with_balance": "11606",
   }
>>> echo "users_total: ".$b->total_users."
... ";
users_total: 406776
>>> echo "users_with_confirmed_balance: ".$b->users_with_balance."
... ";
users_with_confirmed_balance: 11606
>>> echo "total_confirmed_balance: ".$b->total_confirmed."
... ";
total_confirmed_balance: 387533.10
>>> echo "total_pending_balance: ".$b->total_pending."
... ";
total_pending_balance: 1509677.86
>>> $nb = DB::select("SELECT COUNT(*) as cnt, SUM(amount) as total FROM negative_user_balances")[0];
Illuminate/Database/QueryException with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'amount' in 'field list' (SQL: SELECT COUNT(*) as cnt, SUM(amount) as total FROM negative_user_balances)'
>>> echo "negative_balances_count: ".$nb->cnt."
... ";
PHP Notice:  Undefined variable: nb in Psy Shell code on line 1
>>> echo "negative_balances_total: ".$nb->total."
... ";
PHP Notice:  Undefined variable: nb in Psy Shell code on line 1
>>> $pp = DB::select("SELECT COUNT(*) as cnt FROM processed_payouts")[0];
=> {#1033
     +"cnt": 2534,
   }
>>> echo "processed_payouts_count: ".$pp->cnt."
... ";
processed_payouts_count: 2534
>>> $pm = DB::select("SELECT COUNT(*) as cnt, COUNT(DISTINCT user_id) as unique_users FROM user_payout_methods")[0];
=> {#1031
     +"cnt": 31162,
     +"unique_users": 26336,
   }
>>> echo "payout_methods_count: ".$pm->cnt."
... ";
payout_methods_count: 31162
>>> echo "payout_methods_unique_users: ".$pm->unique_users."
... ";
payout_methods_unique_users: 26336
>>> $s = DB::select("SELECT COUNT(*) as cnt FROM sales")[0];
=> {#1016
     +"cnt": 2398946,
   }
>>> echo "sales_count: ".$s->cnt."
... ";
sales_count: 2398946
>>> $bt = DB::select("SELECT COUNT(*) as cnt FROM balance_transactions")[0];
=> {#1017
     +"cnt": 11001790,
   }
>>> echo "balance_transactions_count: ".$bt->cnt."
... ";
balance_transactions_count: 11001790
>>> echo "===PAYOUT-METHODS-STRUCTURE===";
===PAYOUT-METHODS-STRUCTURE===⏎
>>> $c = DB::select("DESCRIBE user_payout_methods"); foreach($c as $col) { echo $col->Field."|".$col->Type."
... "; }
id|int
user_id|int
name|varchar(255)
method_code|char(25)
account|varchar(255)
verify_code|varchar(255)
verified_at|date
enabled|tinyint(1)
created_at|datetime
updated_at|datetime
payout_data|json
deleted_at|timestamp
>>> echo "===PROCESSED-PAYOUTS-STRUCTURE===";
===PROCESSED-PAYOUTS-STRUCTURE===⏎
>>> $c = DB::select("DESCRIBE processed_payouts"); foreach($c as $col) { echo $col->Field."|".$col->Type."
... "; }
id|bigint unsigned
payout_id|int
user_id|int
processed_auto|tinyint(1)
created_at|timestamp
>>> echo "===SALES-STRUCTURE===";
===SALES-STRUCTURE===⏎
>>> $c = DB::select("DESCRIBE sales"); foreach($c as $col) { echo $col->Field."|".$col->Type."
... "; }
id|int
network_id|int
network_transaction_id|varchar(255)
network_sale_id|bigint
order_id|varchar(255)
store_id|int
click_id|int
campaign_id|varchar(50)
cashback_percent|int
transaction_time|datetime
order_amount|decimal(10,2)
comission|decimal(10,2)
currency|char(3)
network_status|varchar(255)
status|enum('pending','confirmed','declined')
created_at|datetime
updated_at|datetime
auto_action|tinyint(1)
local_order_amount|decimal(10,2)
local_comission|decimal(10,2)
currency_rate|double
payment_method|varchar(255)
payment_issuer|varchar(255)
extras|json
confirmed|tinyint(1)
amazon_file_date|date
currency_conversions|json
>>> echo "===BALANCE-TRANSACTIONS-STRUCTURE===";
===BALANCE-TRANSACTIONS-STRUCTURE===⏎
>>> $c = DB::select("DESCRIBE balance_transactions"); foreach($c as $col) { echo $col->Field."|".$col->Type."
... "; }
id|bigint unsigned
user_id|int
transaction_type|enum('pending_cashback','confirmed_cashback','declined_cashback','pending_bonus','confirmed_bonus','declined_bonus','created_payout','processing_payout','completed_payout','declined_payout','failed_payout','settlement','deduction','transfer','revert')
source_type|varchar(255)
source_id|int
amount|decimal(10,2)
balance_type|enum('pending','confirmed')
pending_balance_after|decimal(10,2)
confirmed_balance_after|decimal(10,2)
is_reverted|tinyint(1)
revert_id|int
created_at|timestamp
updated_at|timestamp
>>> echo "===PAYOUT-METHODS-SAMPLE-20===";
===PAYOUT-METHODS-SAMPLE-20===⏎
>>> $pm = DB::select("SELECT * FROM user_payout_methods LIMIT 20");
=> [
     {#1038
       +"id": 1,
       +"user_id": 269,
       +"name": "Yajny PayPal",
       +"method_code": "paypal",
       +"account": "yajnyuat@givmail.com",
       +"verify_code": null,
       +"verified_at": null,
       +"enabled": 1,
       +"created_at": "2019-12-31 04:27:06",
       +"updated_at": "2019-12-31 04:27:06",
       +"payout_data": "{"account": "yajnyuat@givmail.com"}",
       +"deleted_at": null,
     },
     {#1039
       +"id": 2,
       +"user_id": 269,
       +"name": "Cashu Card",
       +"method_code": "cashu",
       +"account": "1234567898988885",
       +"verify_code": "1577169256",
       +"verified_at": null,
       +"enabled": 0,
       +"created_at": "2019-12-31 04:27:06",
       +"updated_at": "2019-12-31 04:27:06",
       +"payout_data": "{"account": "1234567898988885"}",
       +"deleted_at": null,
     },
     {#1026
       +"id": 4,
       +"user_id": 466,
       +"name": "PayPal",
       +"method_code": "paypal",
       +"account": "said.dos@arabyads.com",
       +"verify_code": null,
       +"verified_at": null,
       +"enabled": 1,
       +"created_at": "2020-05-12 12:36:20",
       +"updated_at": "2020-05-20 15:02:54",
       +"payout_data": "{"account": "said.dos@arabyads.com"}",
       +"deleted_at": null,
     },
     {#1034
       +"id": 6,
       +"user_id": 506,
       +"name": "PayPal",
       +"method_code": "paypal",
       +"account": "admin@yajny.com",
       +"verify_code": "1589371695",
       +"verified_at": null,
       +"enabled": 0,
       +"created_at": "2020-05-13 12:08:15",
       +"updated_at": "2020-05-13 12:08:15",
       +"payout_data": "{"account": "admin@yajny.com"}",
       +"deleted_at": null,
     },
     {#1035
       +"id": 7,
       +"user_id": 269,
       +"name": "PayPal",
       +"method_code": "paypal",
       +"account": "yajny@yahoo.com",
       +"verify_code": "1590077232",
       +"verified_at": null,
       +"enabled": 0,
       +"created_at": "2020-05-21 16:07:12",
       +"updated_at": "2020-05-21 16:07:12",
       +"payout_data": "{"account": "yajny@yahoo.com"}",
       +"deleted_at": null,
     },
     {#1040
       +"id": 8,
       +"user_id": 632,
       +"name": "باي بال",
       +"method_code": "paypal",
       +"account": "test@gmail.com",
       +"verify_code": "1591100398",
       +"verified_at": null,
       +"enabled": 0,
       +"created_at": "2020-06-02 12:19:58",
       +"updated_at": "2020-06-02 12:19:58",
       +"payout_data": "{"account": "test@gmail.com"}",
       +"deleted_at": null,
     },
     {#1041
       +"id": 10,
       +"user_id": 269,
       +"name": "PayPal",
       +"method_code": "paypal",
       +"account": "yajny@getnada.com",
       +"verify_code": "1591273767",
       +"verified_at": null,
       +"enabled": 0,
       +"created_at": "2020-06-04 12:29:27",
       +"updated_at": "2020-06-04 12:29:27",
       +"payout_data": "{"account": "yajny@getnada.com"}",
       +"deleted_at": null,
     },
     {#1042
       +"id": 14,
       +"user_id": 627,
       +"name": "PayPal",
       +"method_code": "paypal",
       +"account": "said@arabyads.com",
       +"verify_code": "1591536896",
       +"verified_at": null,
       +"enabled": 0,
       +"created_at": "2020-06-07 13:34:56",
       +"updated_at": "2020-06-07 13:34:56",
       +"payout_data": "{"account": "said@arabyads.com"}",
       +"deleted_at": null,
     },
     {#1043
       +"id": 16,
       +"user_id": 466,
       +"name": "PayPal",
       +"method_code": "paypal",
       +"account": "test3@gmail.com",
       +"verify_code": null,
       +"verified_at": null,
       +"enabled": 1,
       +"created_at": "2020-06-07 16:34:04",
       +"updated_at": "2020-06-07 16:40:11",
       +"payout_data": "{"account": "test3@gmail.com"}",
       +"deleted_at": null,
     },
     {#1064
       +"id": 17,
       +"user_id": 466,
       +"name": "PayPal",
       +"method_code": "paypal",
       +"account": "saidmatta9@gmail.com",
       +"verify_code": null,
       +"verified_at": null,
       +"enabled": 1,
       +"created_at": "2020-06-08 11:21:47",
       +"updated_at": "2020-06-08 11:24:23",
       +"payout_data": "{"account": "saidmatta9@gmail.com"}",
       +"deleted_at": null,
     },
     {#1044
       +"id": 19,
       +"user_id": 1193,
       +"name": "باي بال",
       +"method_code": "paypal",
       +"account": "nino.tota11@gmail.com",
       +"verify_code": null,
       +"verified_at": null,
       +"enabled": 1,
       +"created_at": "2020-07-19 17:21:42",
       +"updated_at": "2020-07-19 17:25:22",
       +"payout_data": "{"account": "nino.tota11@gmail.com"}",
       +"deleted_at": null,
     },
     {#1047
       +"id": 21,
       +"user_id": 1315,
       +"name": "تحويل بنكى",
       +"method_code": "bank-transfer",
       +"account": "44",
       +"verify_code": "1596749616",
       +"verified_at": null,
       +"enabled": 0,
       +"created_at": "2020-08-06 21:33:36",
       +"updated_at": "2020-08-06 21:33:36",
       +"payout_data": "{"iban": null, "swift": null, "account": "44", "username": null, "bank_name": null, "bank_branch": null, "bank_address": null, "user_address": null}",
       +"deleted_at": null,
     },
     {#1046
       +"id": 22,
       +"user_id": 1315,
       +"name": "تحويل بنكى",
       +"method_code": "bank-transfer",
       +"account": "99",
       +"verify_code": "1596750020",
       +"verified_at": null,
       +"enabled": 0,
       +"created_at": "2020-08-06 21:40:20",
       +"updated_at": "2020-08-06 21:40:20",
       +"payout_data": "{"iban": null, "swift": null, "account": "99", "username": null, "bank_name": null, "bank_branch": null, "bank_address": null, "user_address": null}",
       +"deleted_at": null,
     },
     {#1078
       +"id": 23,
       +"user_id": 1315,
       +"name": "تحويل بنكى",
       +"method_code": "bank-transfer",
       +"account": "441066",
       +"verify_code": null,
       +"verified_at": null,
       +"enabled": 1,
       +"created_at": "2020-08-06 21:47:01",
       +"updated_at": "2020-08-06 21:47:43",
       +"payout_data": "{"iban": null, "swift": null, "account": "441066", "username": null, "bank_name": null, "bank_branch": null, "bank_address": null, "user_address": null}",
       +"deleted_at": null,
     },
     {#1077
       +"id": 24,
       +"user_id": 276,
       +"name": "xyz",
       +"method_code": "bank-transfer",
       +"account": "1234567",
       +"verify_code": null,
       +"verified_at": null,
       +"enabled": 1,
       +"created_at": "2020-08-09 10:20:23",
       +"updated_at": "2020-08-09 10:20:41",
       +"payout_data": "{"iban": "12345", "swift": "12345", "account": "1234567", "username": "xyz", "bank_name": "xyz", "bank_branch": "cairo", "bank_address": "2 street", "user_address": "1 street"}",
       +"deleted_at": null,
     },
     {#1076
       +"id": 25,
       +"user_id": 2625,
       +"name": "تحويل",
       +"method_code": "bank-transfer",
       +"account": "90060408439000",
       +"verify_code": null,
       +"verified_at": null,
       +"enabled": 1,
       +"created_at": "2020-09-05 18:23:52",
       +"updated_at": "2020-09-05 18:29:19",
       +"payout_data": "{"iban": "SA2415000900604084390001", "swift": "ALBISARIXXX", "account": "90060408439000", "username": "Mohammed Khalid", "bank_name": "Bank Albilad", "bank_branch": "Albilad", "bank_address": "Saudi Arabia", "user_address": "Saudi Arabia"}",
       +"deleted_at": null,
     },
     {#1075
       +"id": 26,
       +"user_id": 2634,
       +"name": "تحويل بنكي",
       +"method_code": "bank-transfer",
       +"account": "90013154622000",
       +"verify_code": "1599392309",
       +"verified_at": null,
       +"enabled": 0,
       +"created_at": "2020-09-06 11:38:29",
       +"updated_at": "2020-09-06 11:38:29",
       +"payout_data": "{"iban": "SA2815000900131546220004", "swift": "ALBISARIXXX", "account": "90013154622000", "username": "Ahmed Elsayed ", "bank_name": "Albilad ", "bank_branch": "dammam", "bank_address": "dammam", "user_address": "Saudi Arabia "}",
       +"deleted_at": null,
     },
     {#1074
       +"id": 27,
       +"user_id": 2912,
       +"name": "تحويل عربي",
       +"method_code": "bank-transfer",
       +"account": "8993604698615",
       +"verify_code": null,
       +"verified_at": null,
       +"enabled": 1,
       +"created_at": "2020-09-06 11:54:59",
       +"updated_at": "2020-09-06 11:59:25",
       +"payout_data": "{"iban": "SA053010094200000485959", "swift": "ARNBSARI", "account": "8993604698615", "username": "اسامة عبداللطيف الرياطي ", "bank_name": "العربي الوطني", "bank_branch": "الرياض", "bank_address": "السعودية", "user_address": "الرياض"}",
       +"deleted_at": null,
     },
     {#1073
       +"id": 28,
       +"user_id": 2634,
       +"name": "تحويل بنكي",
       +"method_code": "bank-transfer",
       +"account": "10006086041423",
       +"verify_code": null,
       +"verified_at": null,
       +"enabled": 1,
       +"created_at": "2020-09-06 11:59:30",
       +"updated_at": "2020-09-06 12:01:13",
       +"payout_data": "{"iban": "SA3980000104608016041423", "swift": "RJHISARI", "account": "10006086041423", "username": "Ahmed Elsayed ", "bank_name": "الراجحي", "bank_branch": "dammam", "bank_address": "dammam ", "user_address": "Saudi Arabia "}",
       +"deleted_at": null,
     },
     {#1072
       +"id": 29,
       +"user_id": 3833,
       +"name": "عند الاستلام ",
       +"method_code": "bank-transfer",
       +"account": "68200695545000",
       +"verify_code": "1600157182",
       +"verified_at": null,
       +"enabled": 0,
       +"created_at": "2020-09-15 08:06:22",
       +"updated_at": "2020-09-15 08:06:22",
       +"payout_data": "{"iban": "SA7605000068200695545000", "swift": "INMASARI", "account": "68200695545000", "username": "مشاعل", "bank_name": "الانماء", "bank_branch": "فرع الامير بندر بن عبدالعزيز", "bank_address": "الرياض حي النهضة ", "user_address": "الرياض حي النهضة"}",
       +"deleted_at": null,
     },
   ]
>>> foreach($pm as $r) { echo json_encode($r)."
... "; }
{"id":1,"user_id":269,"name":"Yajny PayPal","method_code":"paypal","account":"yajnyuat@givmail.com","verify_code":null,"verified_at":null,"enabled":1,"created_at":"2019-12-31 04:27:06","updated_at":"2019-12-31 04:27:06","payout_data":"{\"account\": \"yajnyuat@givmail.com\"}","deleted_at":null}
{"id":2,"user_id":269,"name":"Cashu Card","method_code":"cashu","account":"1234567898988885","verify_code":"1577169256","verified_at":null,"enabled":0,"created_at":"2019-12-31 04:27:06","updated_at":"2019-12-31 04:27:06","payout_data":"{\"account\": \"1234567898988885\"}","deleted_at":null}
{"id":4,"user_id":466,"name":"PayPal","method_code":"paypal","account":"said.dos@arabyads.com","verify_code":null,"verified_at":null,"enabled":1,"created_at":"2020-05-12 12:36:20","updated_at":"2020-05-20 15:02:54","payout_data":"{\"account\": \"said.dos@arabyads.com\"}","deleted_at":null}
{"id":6,"user_id":506,"name":"PayPal","method_code":"paypal","account":"admin@yajny.com","verify_code":"1589371695","verified_at":null,"enabled":0,"created_at":"2020-05-13 12:08:15","updated_at":"2020-05-13 12:08:15","payout_data":"{\"account\": \"admin@yajny.com\"}","deleted_at":null}
{"id":7,"user_id":269,"name":"PayPal","method_code":"paypal","account":"yajny@yahoo.com","verify_code":"1590077232","verified_at":null,"enabled":0,"created_at":"2020-05-21 16:07:12","updated_at":"2020-05-21 16:07:12","payout_data":"{\"account\": \"yajny@yahoo.com\"}","deleted_at":null}
{"id":8,"user_id":632,"name":"\u0628\u0627\u064a \u0628\u0627\u0644","method_code":"paypal","account":"test@gmail.com","verify_code":"1591100398","verified_at":null,"enabled":0,"created_at":"2020-06-02 12:19:58","updated_at":"2020-06-02 12:19:58","payout_data":"{\"account\": \"test@gmail.com\"}","deleted_at":null}
{"id":10,"user_id":269,"name":"PayPal","method_code":"paypal","account":"yajny@getnada.com","verify_code":"1591273767","verified_at":null,"enabled":0,"created_at":"2020-06-04 12:29:27","updated_at":"2020-06-04 12:29:27","payout_data":"{\"account\": \"yajny@getnada.com\"}","deleted_at":null}
{"id":14,"user_id":627,"name":"PayPal","method_code":"paypal","account":"said@arabyads.com","verify_code":"1591536896","verified_at":null,"enabled":0,"created_at":"2020-06-07 13:34:56","updated_at":"2020-06-07 13:34:56","payout_data":"{\"account\": \"said@arabyads.com\"}","deleted_at":null}
{"id":16,"user_id":466,"name":"PayPal","method_code":"paypal","account":"test3@gmail.com","verify_code":null,"verified_at":null,"enabled":1,"created_at":"2020-06-07 16:34:04","updated_at":"2020-06-07 16:40:11","payout_data":"{\"account\": \"test3@gmail.com\"}","deleted_at":null}
{"id":17,"user_id":466,"name":"PayPal","method_code":"paypal","account":"saidmatta9@gmail.com","verify_code":null,"verified_at":null,"enabled":1,"created_at":"2020-06-08 11:21:47","updated_at":"2020-06-08 11:24:23","payout_data":"{\"account\": \"saidmatta9@gmail.com\"}","deleted_at":null}
{"id":19,"user_id":1193,"name":"\u0628\u0627\u064a \u0628\u0627\u0644","method_code":"paypal","account":"nino.tota11@gmail.com","verify_code":null,"verified_at":null,"enabled":1,"created_at":"2020-07-19 17:21:42","updated_at":"2020-07-19 17:25:22","payout_data":"{\"account\": \"nino.tota11@gmail.com\"}","deleted_at":null}
{"id":21,"user_id":1315,"name":"\u062a\u062d\u0648\u064a\u0644 \u0628\u0646\u0643\u0649","method_code":"bank-transfer","account":"44","verify_code":"1596749616","verified_at":null,"enabled":0,"created_at":"2020-08-06 21:33:36","updated_at":"2020-08-06 21:33:36","payout_data":"{\"iban\": null, \"swift\": null, \"account\": \"44\", \"username\": null, \"bank_name\": null, \"bank_branch\": null, \"bank_address\": null, \"user_address\": null}","deleted_at":null}
{"id":22,"user_id":1315,"name":"\u062a\u062d\u0648\u064a\u0644 \u0628\u0646\u0643\u0649","method_code":"bank-transfer","account":"99","verify_code":"1596750020","verified_at":null,"enabled":0,"created_at":"2020-08-06 21:40:20","updated_at":"2020-08-06 21:40:20","payout_data":"{\"iban\": null, \"swift\": null, \"account\": \"99\", \"username\": null, \"bank_name\": null, \"bank_branch\": null, \"bank_address\": null, \"user_address\": null}","deleted_at":null}
{"id":23,"user_id":1315,"name":"\u062a\u062d\u0648\u064a\u0644 \u0628\u0646\u0643\u0649","method_code":"bank-transfer","account":"441066","verify_code":null,"verified_at":null,"enabled":1,"created_at":"2020-08-06 21:47:01","updated_at":"2020-08-06 21:47:43","payout_data":"{\"iban\": null, \"swift\": null, \"account\": \"441066\", \"username\": null, \"bank_name\": null, \"bank_branch\": null, \"bank_address\": null, \"user_address\": null}","deleted_at":null}
{"id":24,"user_id":276,"name":"xyz","method_code":"bank-transfer","account":"1234567","verify_code":null,"verified_at":null,"enabled":1,"created_at":"2020-08-09 10:20:23","updated_at":"2020-08-09 10:20:41","payout_data":"{\"iban\": \"12345\", \"swift\": \"12345\", \"account\": \"1234567\", \"username\": \"xyz\", \"bank_name\": \"xyz\", \"bank_branch\": \"cairo\", \"bank_address\": \"2 street\", \"user_address\": \"1 street\"}","deleted_at":null}
{"id":25,"user_id":2625,"name":"\u062a\u062d\u0648\u064a\u0644","method_code":"bank-transfer","account":"90060408439000","verify_code":null,"verified_at":null,"enabled":1,"created_at":"2020-09-05 18:23:52","updated_at":"2020-09-05 18:29:19","payout_data":"{\"iban\": \"SA2415000900604084390001\", \"swift\": \"ALBISARIXXX\", \"account\": \"90060408439000\", \"username\": \"Mohammed Khalid\", \"bank_name\": \"Bank Albilad\", \"bank_branch\": \"Albilad\", \"bank_address\": \"Saudi Arabia\", \"user_address\": \"Saudi Arabia\"}","deleted_at":null}
{"id":26,"user_id":2634,"name":"\u062a\u062d\u0648\u064a\u0644 \u0628\u0646\u0643\u064a","method_code":"bank-transfer","account":"90013154622000","verify_code":"1599392309","verified_at":null,"enabled":0,"created_at":"2020-09-06 11:38:29","updated_at":"2020-09-06 11:38:29","payout_data":"{\"iban\": \"SA2815000900131546220004\", \"swift\": \"ALBISARIXXX\", \"account\": \"90013154622000\", \"username\": \"Ahmed Elsayed \", \"bank_name\": \"Albilad \", \"bank_branch\": \"dammam\", \"bank_address\": \"dammam\", \"user_address\": \"Saudi Arabia \"}","deleted_at":null}
{"id":27,"user_id":2912,"name":"\u062a\u062d\u0648\u064a\u0644 \u0639\u0631\u0628\u064a","method_code":"bank-transfer","account":"8993604698615","verify_code":null,"verified_at":null,"enabled":1,"created_at":"2020-09-06 11:54:59","updated_at":"2020-09-06 11:59:25","payout_data":"{\"iban\": \"SA053010094200000485959\", \"swift\": \"ARNBSARI\", \"account\": \"8993604698615\", \"username\": \"\u0627\u0633\u0627\u0645\u0629 \u0639\u0628\u062f\u0627\u0644\u0644\u0637\u064a\u0641 \u0627\u0644\u0631\u064a\u0627\u0637\u064a \", \"bank_name\": \"\u0627\u0644\u0639\u0631\u0628\u064a \u0627\u0644\u0648\u0637\u0646\u064a\", \"bank_branch\": \"\u0627\u0644\u0631\u064a\u0627\u0636\", \"bank_address\": \"\u0627\u0644\u0633\u0639\u0648\u062f\u064a\u0629\", \"user_address\": \"\u0627\u0644\u0631\u064a\u0627\u0636\"}","deleted_at":null}
{"id":28,"user_id":2634,"name":"\u062a\u062d\u0648\u064a\u0644 \u0628\u0646\u0643\u064a","method_code":"bank-transfer","account":"10006086041423","verify_code":null,"verified_at":null,"enabled":1,"created_at":"2020-09-06 11:59:30","updated_at":"2020-09-06 12:01:13","payout_data":"{\"iban\": \"SA3980000104608016041423\", \"swift\": \"RJHISARI\", \"account\": \"10006086041423\", \"username\": \"Ahmed Elsayed \", \"bank_name\": \"\u0627\u0644\u0631\u0627\u062c\u062d\u064a\", \"bank_branch\": \"dammam\", \"bank_address\": \"dammam \", \"user_address\": \"Saudi Arabia \"}","deleted_at":null}
{"id":29,"user_id":3833,"name":"\u0639\u0646\u062f \u0627\u0644\u0627\u0633\u062a\u0644\u0627\u0645 ","method_code":"bank-transfer","account":"68200695545000","verify_code":"1600157182","verified_at":null,"enabled":0,"created_at":"2020-09-15 08:06:22","updated_at":"2020-09-15 08:06:22","payout_data":"{\"iban\": \"SA7605000068200695545000\", \"swift\": \"INMASARI\", \"account\": \"68200695545000\", \"username\": \"\u0645\u0634\u0627\u0639\u0644\", \"bank_name\": \"\u0627\u0644\u0627\u0646\u0645\u0627\u0621\", \"bank_branch\": \"\u0641\u0631\u0639 \u0627\u0644\u0627\u0645\u064a\u0631 \u0628\u0646\u062f\u0631 \u0628\u0646 \u0639\u0628\u062f\u0627\u0644\u0639\u0632\u064a\u0632\", \"bank_address\": \"\u0627\u0644\u0631\u064a\u0627\u0636 \u062d\u064a \u0627\u0644\u0646\u0647\u0636\u0629 \", \"user_address\": \"\u0627\u0644\u0631\u064a\u0627\u0636 \u062d\u064a \u0627\u0644\u0646\u0647\u0636\u0629\"}","deleted_at":null}
>>> echo "===PROCESSED-PAYOUTS-SAMPLE-20===";
===PROCESSED-PAYOUTS-SAMPLE-20===⏎
>>> $pp = DB::select("SELECT * FROM processed_payouts ORDER BY id DESC LIMIT 20");
=> [
     {#1014
       +"id": 2587,
       +"payout_id": 9466,
       +"user_id": 230013,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:12",
     },
     {#1021
       +"id": 2586,
       +"payout_id": 9465,
       +"user_id": 402963,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:12",
     },
     {#1029
       +"id": 2585,
       +"payout_id": 9464,
       +"user_id": 403702,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:12",
     },
     {#1023
       +"id": 2584,
       +"payout_id": 9463,
       +"user_id": 402972,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:12",
     },
     {#1055
       +"id": 2583,
       +"payout_id": 9462,
       +"user_id": 381403,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:12",
     },
     {#1051
       +"id": 2582,
       +"payout_id": 9461,
       +"user_id": 405843,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:12",
     },
     {#1054
       +"id": 2581,
       +"payout_id": 9460,
       +"user_id": 24929,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:11",
     },
     {#1052
       +"id": 2580,
       +"payout_id": 9459,
       +"user_id": 403486,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:11",
     },
     {#1053
       +"id": 2579,
       +"payout_id": 9458,
       +"user_id": 406573,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:11",
     },
     {#1050
       +"id": 2578,
       +"payout_id": 9457,
       +"user_id": 403461,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:11",
     },
     {#1049
       +"id": 2577,
       +"payout_id": 9456,
       +"user_id": 407179,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:11",
     },
     {#1048
       +"id": 2576,
       +"payout_id": 9455,
       +"user_id": 405724,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:11",
     },
     {#1022
       +"id": 2575,
       +"payout_id": 9454,
       +"user_id": 406238,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:11",
     },
     {#1065
       +"id": 2574,
       +"payout_id": 9453,
       +"user_id": 405586,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:11",
     },
     {#1066
       +"id": 2573,
       +"payout_id": 9450,
       +"user_id": 405167,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:11",
     },
     {#1067
       +"id": 2572,
       +"payout_id": 9447,
       +"user_id": 404842,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:11",
     },
     {#1068
       +"id": 2571,
       +"payout_id": 9444,
       +"user_id": 403863,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:11",
     },
     {#1069
       +"id": 2570,
       +"payout_id": 9443,
       +"user_id": 403526,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:11",
     },
     {#1070
       +"id": 2569,
       +"payout_id": 9442,
       +"user_id": 403523,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:11",
     },
     {#1031
       +"id": 2568,
       +"payout_id": 9441,
       +"user_id": 403436,
       +"processed_auto": 1,
       +"created_at": "2026-09-16 06:14:11",
     },
   ]
>>> foreach($pp as $r) { echo json_encode($r)."
... "; }
{"id":2587,"payout_id":9466,"user_id":230013,"processed_auto":1,"created_at":"2026-09-16 06:14:12"}
{"id":2586,"payout_id":9465,"user_id":402963,"processed_auto":1,"created_at":"2026-09-16 06:14:12"}
{"id":2585,"payout_id":9464,"user_id":403702,"processed_auto":1,"created_at":"2026-09-16 06:14:12"}
{"id":2584,"payout_id":9463,"user_id":402972,"processed_auto":1,"created_at":"2026-09-16 06:14:12"}
{"id":2583,"payout_id":9462,"user_id":381403,"processed_auto":1,"created_at":"2026-09-16 06:14:12"}
{"id":2582,"payout_id":9461,"user_id":405843,"processed_auto":1,"created_at":"2026-09-16 06:14:12"}
{"id":2581,"payout_id":9460,"user_id":24929,"processed_auto":1,"created_at":"2026-09-16 06:14:11"}
{"id":2580,"payout_id":9459,"user_id":403486,"processed_auto":1,"created_at":"2026-09-16 06:14:11"}
{"id":2579,"payout_id":9458,"user_id":406573,"processed_auto":1,"created_at":"2026-09-16 06:14:11"}
{"id":2578,"payout_id":9457,"user_id":403461,"processed_auto":1,"created_at":"2026-09-16 06:14:11"}
{"id":2577,"payout_id":9456,"user_id":407179,"processed_auto":1,"created_at":"2026-09-16 06:14:11"}
{"id":2576,"payout_id":9455,"user_id":405724,"processed_auto":1,"created_at":"2026-09-16 06:14:11"}
{"id":2575,"payout_id":9454,"user_id":406238,"processed_auto":1,"created_at":"2026-09-16 06:14:11"}
{"id":2574,"payout_id":9453,"user_id":405586,"processed_auto":1,"created_at":"2026-09-16 06:14:11"}
{"id":2573,"payout_id":9450,"user_id":405167,"processed_auto":1,"created_at":"2026-09-16 06:14:11"}
{"id":2572,"payout_id":9447,"user_id":404842,"processed_auto":1,"created_at":"2026-09-16 06:14:11"}
{"id":2571,"payout_id":9444,"user_id":403863,"processed_auto":1,"created_at":"2026-09-16 06:14:11"}
{"id":2570,"payout_id":9443,"user_id":403526,"processed_auto":1,"created_at":"2026-09-16 06:14:11"}
{"id":2569,"payout_id":9442,"user_id":403523,"processed_auto":1,"created_at":"2026-09-16 06:14:11"}
{"id":2568,"payout_id":9441,"user_id":403436,"processed_auto":1,"created_at":"2026-09-16 06:14:11"}
>>> echo "===TOP-20-USERS-BY-BALANCE===";
===TOP-20-USERS-BY-BALANCE===⏎
>>> $tu = DB::select("SELECT user_id, first_name, email, confirmed_balance, pending_balance, country_code FROM users WHERE confirmed_balance > 0 ORDER BY confirmed_balance DESC LIMIT 20");
=> [
     {#1032
       +"user_id": 406573,
       +"first_name": "Marwa",
       +"email": "marwa.youssef2000@hotmail.com",
       +"confirmed_balance": "93161.12",
       +"pending_balance": "0.00",
       +"country_code": null,
     },
     {#1059
       +"user_id": 402490,
       +"first_name": "mostafa",
       +"email": "mos.sh196@gmail.com",
       +"confirmed_balance": "22723.32",
       +"pending_balance": "82.43",
       +"country_code": null,
     },
     {#1036
       +"user_id": 402535,
       +"first_name": "Mostafa",
       +"email": "ahmedalaaam11@gmail.com",
       +"confirmed_balance": "22565.78",
       +"pending_balance": "0.01",
       +"country_code": null,
     },
     {#1057
       +"user_id": 240817,
       +"first_name": "Mohamed",
       +"email": "mohamed_samir0005@yahoo.com",
       +"confirmed_balance": "15451.93",
       +"pending_balance": "-8.00",
       +"country_code": null,
     },
     {#1102
       +"user_id": 403059,
       +"first_name": "Mostafa ",
       +"email": "iibbrraahhiimm19@gmail.com",
       +"confirmed_balance": "13382.23",
       +"pending_balance": "27.16",
       +"country_code": null,
     },
     {#1098
       +"user_id": 403875,
       +"first_name": "ahmed",
       +"email": "ahmedmagdy4365@gmail.com",
       +"confirmed_balance": "11057.91",
       +"pending_balance": "-1.68",
       +"country_code": "eg",
     },
     {#1101
       +"user_id": 357760,
       +"first_name": "Boostiny",
       +"email": "info@boostiny.com",
       +"confirmed_balance": "10510.15",
       +"pending_balance": "-94458.05",
       +"country_code": null,
     },
     {#1099
       +"user_id": 405058,
       +"first_name": "Ghidaa",
       +"email": "ghidaaaladwan@icloud.com",
       +"confirmed_balance": "10000.00",
       +"pending_balance": "0.00",
       +"country_code": null,
     },
     {#1100
       +"user_id": 403702,
       +"first_name": "Mohamed ",
       +"email": "ma2032174@gmail.com",
       +"confirmed_balance": "9975.27",
       +"pending_balance": "0.00",
       +"country_code": null,
     },
     {#1097
       +"user_id": 402972,
       +"first_name": "Ahmed",
       +"email": "a.khaled367@gmail.com",
       +"confirmed_balance": "9811.61",
       +"pending_balance": "0.00",
       +"country_code": "eg",
     },
     {#1096
       +"user_id": 400056,
       +"first_name": "Mohamed",
       +"email": "eng_m.khalaf@hotmail.com",
       +"confirmed_balance": "9804.12",
       +"pending_balance": "-5.13",
       +"country_code": "gb",
     },
     {#1095
       +"user_id": 155779,
       +"first_name": "Elsayed",
       +"email": "adel_alaa255@hotmail.com",
       +"confirmed_balance": "8865.27",
       +"pending_balance": "-545.11",
       +"country_code": null,
     },
     {#1094
       +"user_id": 403461,
       +"first_name": "Ahmed",
       +"email": "bebo.experience@gmail.com",
       +"confirmed_balance": "5879.59",
       +"pending_balance": "-0.70",
       +"country_code": null,
     },
     {#1093
       +"user_id": 403280,
       +"first_name": "Shyma ",
       +"email": "shymajoe435@gmail.com",
       +"confirmed_balance": "5047.11",
       +"pending_balance": "0.00",
       +"country_code": "eg",
     },
     {#1092
       +"user_id": 38524,
       +"first_name": "Elsayed",
       +"email": "sayedsayed-ezz70@hotmail.com",
       +"confirmed_balance": "3541.77",
       +"pending_balance": "0.00",
       +"country_code": "eg",
     },
     {#1091
       +"user_id": 359264,
       +"first_name": "Electro ",
       +"email": "electro@coupaeon.com",
       +"confirmed_balance": "3074.17",
       +"pending_balance": "-13.06",
       +"country_code": null,
     },
     {#1090
       +"user_id": 405815,
       +"first_name": "Mazen",
       +"email": "mazenabdelrhman772007@gmail.com",
       +"confirmed_balance": "3023.75",
       +"pending_balance": "0.00",
       +"country_code": null,
     },
     {#1071
       +"user_id": 63261,
       +"first_name": "Mohamed",
       +"email": "mhamedkang66@gmail.com",
       +"confirmed_balance": "2818.27",
       +"pending_balance": "0.00",
       +"country_code": null,
     },
     {#1089
       +"user_id": 25997,
       +"first_name": "Basyouny",
       +"email": "elsahelamy07@gmail.com",
       +"confirmed_balance": "2429.37",
       +"pending_balance": "54.92",
       +"country_code": "eg",
     },
     {#1033
       +"user_id": 406281,
       +"first_name": "Maha ",
       +"email": "mahagamal41114@gmail.com",
       +"confirmed_balance": "2336.99",
       +"pending_balance": "11.52",
       +"country_code": null,
     },
   ]
>>> foreach($tu as $r) { echo json_encode($r)."
... "; }
{"user_id":406573,"first_name":"Marwa","email":"marwa.youssef2000@hotmail.com","confirmed_balance":"93161.12","pending_balance":"0.00","country_code":null}
{"user_id":402490,"first_name":"mostafa","email":"mos.sh196@gmail.com","confirmed_balance":"22723.32","pending_balance":"82.43","country_code":null}
{"user_id":402535,"first_name":"Mostafa","email":"ahmedalaaam11@gmail.com","confirmed_balance":"22565.78","pending_balance":"0.01","country_code":null}
{"user_id":240817,"first_name":"Mohamed","email":"mohamed_samir0005@yahoo.com","confirmed_balance":"15451.93","pending_balance":"-8.00","country_code":null}
{"user_id":403059,"first_name":"Mostafa ","email":"iibbrraahhiimm19@gmail.com","confirmed_balance":"13382.23","pending_balance":"27.16","country_code":null}
{"user_id":403875,"first_name":"ahmed","email":"ahmedmagdy4365@gmail.com","confirmed_balance":"11057.91","pending_balance":"-1.68","country_code":"eg"}
{"user_id":357760,"first_name":"Boostiny","email":"info@boostiny.com","confirmed_balance":"10510.15","pending_balance":"-94458.05","country_code":null}
{"user_id":405058,"first_name":"Ghidaa","email":"ghidaaaladwan@icloud.com","confirmed_balance":"10000.00","pending_balance":"0.00","country_code":null}
{"user_id":403702,"first_name":"Mohamed ","email":"ma2032174@gmail.com","confirmed_balance":"9975.27","pending_balance":"0.00","country_code":null}
{"user_id":402972,"first_name":"Ahmed","email":"a.khaled367@gmail.com","confirmed_balance":"9811.61","pending_balance":"0.00","country_code":"eg"}
{"user_id":400056,"first_name":"Mohamed","email":"eng_m.khalaf@hotmail.com","confirmed_balance":"9804.12","pending_balance":"-5.13","country_code":"gb"}
{"user_id":155779,"first_name":"Elsayed","email":"adel_alaa255@hotmail.com","confirmed_balance":"8865.27","pending_balance":"-545.11","country_code":null}
{"user_id":403461,"first_name":"Ahmed","email":"bebo.experience@gmail.com","confirmed_balance":"5879.59","pending_balance":"-0.70","country_code":null}
{"user_id":403280,"first_name":"Shyma ","email":"shymajoe435@gmail.com","confirmed_balance":"5047.11","pending_balance":"0.00","country_code":"eg"}
{"user_id":38524,"first_name":"Elsayed","email":"sayedsayed-ezz70@hotmail.com","confirmed_balance":"3541.77","pending_balance":"0.00","country_code":"eg"}
{"user_id":359264,"first_name":"Electro ","email":"electro@coupaeon.com","confirmed_balance":"3074.17","pending_balance":"-13.06","country_code":null}
{"user_id":405815,"first_name":"Mazen","email":"mazenabdelrhman772007@gmail.com","confirmed_balance":"3023.75","pending_balance":"0.00","country_code":null}
{"user_id":63261,"first_name":"Mohamed","email":"mhamedkang66@gmail.com","confirmed_balance":"2818.27","pending_balance":"0.00","country_code":null}
{"user_id":25997,"first_name":"Basyouny","email":"elsahelamy07@gmail.com","confirmed_balance":"2429.37","pending_balance":"54.92","country_code":"eg"}
{"user_id":406281,"first_name":"Maha ","email":"mahagamal41114@gmail.com","confirmed_balance":"2336.99","pending_balance":"11.52","country_code":null}
>>> echo "===DONE===";
===DONE===⏎
>>> exit;
Exit:  Goodbye