ACIL FM

Pilih semua

Nama	Ukuran	Aksi
add_message.php	3.76 MB	View DL Edit
add_new_admin.php	2.49 MB	View DL Edit
bot_stats.php	8.05 MB	View DL Edit
change_channels.php	11.69 MB	View DL Edit
change_price.php	10.72 MB	View DL Edit
change_status.php	9.01 MB	View DL Edit
change_text.php	5.63 MB	View DL Edit
last_payments.php	5.52 MB	View DL Edit
panel.php	3.35 MB	View DL Edit
search_user.php	42.2 MB	View DL Edit

Edit file: /home/fastexsh/public_html/exchange/admin/bot_stats.php

<?php

if ($text == '📊 آمار و گزارشات' && $currentUser->is_admin) {
    $today        = date('Y-m-d');
    $oneWeekAgo   = date('Y-m-d', strtotime('-7 days'));
    $startOfMonth = date('Y-m-01'); // First day of current month
    $endOfMonth   = date('Y-m-t'); // Last day of current month

$query = "SELECT COUNT(*) AS `all_user` FROM `users`";
    $stmt  = $db->prepare($query);
    $stmt->execute();
    $all_user = $stmt->fetch()->all_user;

$query1 = "SELECT COUNT(*) FROM `users` WHERE `auth_level` = 1";
    $stmt1  = $db->prepare($query1);
    $stmt1->execute();
    $count1 = $stmt1->fetchColumn() ?? 0;

$query2 = "SELECT COUNT(*) FROM `users` WHERE `auth_level` = 2";
    $stmt2  = $db->prepare($query2);
    $stmt2->execute();
    $count2 = $stmt2->fetchColumn() ?? 0;

$query3 = "SELECT COUNT(*) FROM `users` WHERE `auth_level` = 3";
    $stmt3  = $db->prepare($query3);
    $stmt3->execute();
    $count3 = $stmt3->fetchColumn() ?? 0;

$query4 = "SELECT COUNT(*) FROM `users` WHERE `auth_level` = 4";
    $stmt4  = $db->prepare($query4);
    $stmt4->execute();
    $count4 = $stmt4->fetchColumn() ?? 0;

$query5 = "SELECT SUM(amount) FROM `transactions` WHERE `status` = 1";
    $stmt5  = $db->prepare($query5);
    $stmt5->execute();
    $totalAmount = $stmt5->fetchColumn() ?? 0;

$query6 = "SELECT SUM(amount) FROM `purchased_vouchers` WHERE `status` = 'confirm'";
    $stmt6  = $db->prepare($query6);
    $stmt6->execute();
    $totalPurchasedVouchers = $stmt6->fetchColumn() ?? 0;

$query7 = "SELECT SUM(amount) FROM `withdraw` WHERE `status` = 'confirm'";
    $stmt7  = $db->prepare($query7);
    $stmt7->execute();
    $totalWithdrawals = $stmt7->fetchColumn() ?? 0;

$query8 = "SELECT SUM(amount) FROM `sold_vouchers` WHERE `status` = 'confirm' AND DATE(`created_at`) = ?";
    $stmt8  = $db->prepare($query8);
    $stmt8->execute([$today]);
    $totalSalesToday = $stmt8->fetchColumn() ?? 0;

$query9 = "SELECT SUM(amount) FROM `purchased_vouchers` WHERE `status` = 'confirm' AND DATE(`created_at`) = ?";
    $stmt9  = $db->prepare($query9);
    $stmt9->execute([$today]);
    $totalPurchasesToday = $stmt9->fetchColumn() ?? 0;

$query10 = "SELECT SUM(amount) FROM `transactions` WHERE `status` = 1 AND DATE(`created_at`) = ?";
    $stmt10  = $db->prepare($query10);
    $stmt10->execute([$today]);
    $totalDepositsToday = $stmt10->fetchColumn() ?? 0;

$query11 = "SELECT SUM(amount) FROM `withdraw` WHERE `status` = 'confirm' AND DATE(`created_at`) = ?";
    $stmt11  = $db->prepare($query11);
    $stmt11->execute([$today]);
    $totalWithdrawalsToday = $stmt11->fetchColumn() ?? 0;

$query12 = "SELECT SUM(amount) FROM `sold_vouchers` WHERE `status` = 'confirm' AND DATE(`created_at`) BETWEEN ? AND ?";
    $stmt12  = $db->prepare($query12);
    $stmt12->execute([$oneWeekAgo, $today]);
    $totalSalesLastWeek = $stmt12->fetchColumn() ?? 0;

$query13 = "SELECT SUM(amount) FROM `purchased_vouchers` WHERE `status` = 'confirm' AND DATE(`created_at`) BETWEEN ? AND ?";
    $stmt13  = $db->prepare($query13);
    $stmt13->execute([$oneWeekAgo, $today]);
    $totalPurchasesLastWeek = $stmt13->fetchColumn() ?? 0;

$query14 = "SELECT SUM(amount) FROM `transactions` WHERE `status` = 1 AND DATE(`created_at`) BETWEEN ? AND ?";
    $stmt14  = $db->prepare($query14);
    $stmt14->execute([$oneWeekAgo, $today]);
    $totalTransactionsLastWeek = $stmt14->fetchColumn() ?? 0;

$query15 = "SELECT SUM(amount) FROM `withdraw` WHERE `status` = 'confirm' AND DATE(`created_at`) BETWEEN ? AND ?";
    $stmt15  = $db->prepare($query15);
    $stmt15->execute([$oneWeekAgo, $today]);
    $totalWithdrawalsLastWeek = $stmt15->fetchColumn() ?? 0;

$query16 = "SELECT SUM(amount) FROM `sold_vouchers` WHERE `status` = 'confirm'";
    $stmt16  = $db->prepare($query16);
    $stmt16->execute();
    $totalSoldVouchers = $stmt16->fetchColumn() ?? 0;

// Monthly Stats
    $query17 = "SELECT SUM(amount) FROM `sold_vouchers` WHERE `status` = 'confirm' AND DATE(`created_at`) BETWEEN ? AND ?";
    $stmt17  = $db->prepare($query17);
    $stmt17->execute([$startOfMonth, $endOfMonth]);
    $totalSalesMonth = $stmt17->fetchColumn() ?? 0;

$query18 = "SELECT SUM(amount) FROM `purchased_vouchers` WHERE `status` = 'confirm' AND DATE(`created_at`) BETWEEN ? AND ?";
    $stmt18  = $db->prepare($query18);
    $stmt18->execute([$startOfMonth, $endOfMonth]);
    $totalPurchasesMonth = $stmt18->fetchColumn() ?? 0;

$query19 = "SELECT SUM(amount) FROM `transactions` WHERE `status` = 1 AND DATE(`created_at`) BETWEEN ? AND ?";
    $stmt19  = $db->prepare($query19);
    $stmt19->execute([$startOfMonth, $endOfMonth]);
    $totalDepositsMonth = $stmt19->fetchColumn() ?? 0;

$query20 = "SELECT SUM(amount) FROM `withdraw` WHERE `status` = 'confirm' AND DATE(`created_at`) BETWEEN ? AND ?";
    $stmt20  = $db->prepare($query20);
    $stmt20->execute([$startOfMonth, $endOfMonth]);
    $totalWithdrawalsMonth = $stmt20->fetchColumn() ?? 0;

// Calculations
    $netProfitToday = ($totalSalesToday * 0.01); // Assuming 1% profit, adjust as needed
    $netProfitWeek  = ($totalSalesLastWeek * 0.01);
    $netProfitMonth = ($totalSalesMonth * 0.01);
    $netProfitTotal = ($totalSoldVouchers * 0.01);

// Format numbers
    $f_all_user               = number_format($all_user);
    $f_totalPurchasedVouchers = number_format($totalPurchasedVouchers);
    $f_totalSoldVouchers      = number_format($totalSoldVouchers);
    $f_totalAmount            = number_format($totalAmount);
    $f_totalWithdrawals       = number_format($totalWithdrawals);

$f_totalSalesToday       = number_format($totalSalesToday);
    $f_totalPurchasesToday   = number_format($totalPurchasesToday);
    $f_totalDepositsToday    = number_format($totalDepositsToday);
    $f_totalWithdrawalsToday = number_format($totalWithdrawalsToday);

$f_totalSalesLastWeek        = number_format($totalSalesLastWeek);
    $f_totalPurchasesLastWeek    = number_format($totalPurchasesLastWeek);
    $f_totalTransactionsLastWeek = number_format($totalTransactionsLastWeek);
    $f_totalWithdrawalsLastWeek  = number_format($totalWithdrawalsLastWeek);

$f_totalSalesMonth       = number_format($totalSalesMonth);
    $f_totalPurchasesMonth   = number_format($totalPurchasesMonth);
    $f_totalDepositsMonth    = number_format($totalDepositsMonth);
    $f_totalWithdrawalsMonth = number_format($totalWithdrawalsMonth);

$response_text = "
📊 **گزارش کلی ربات**
📅 تاریخ گزارش: " . jdate("H:i  Y/m/d") . "

👥 **آمار کاربران**

🔹 کل کاربران: **$f_all_user** نفر
▫️ سطح ۱: $count1 نفر
▫️ سطح ۲: $count2 نفر
▫️ سطح ۳: $count3 نفر
▫️ سطح ۴: $count4 نفر

📆 **آمار امروز**

💰 فروش ووچر: **$f_totalSalesToday** تومان
🛒 خرید ووچر: **$f_totalPurchasesToday** تومان
📥 واریزی‌ها: **$f_totalDepositsToday** تومان
📤 برداشت‌ها: **$f_totalWithdrawalsToday** تومان

🗓 **آمار ۷ روز گذشته**

💰 فروش ووچر: **$f_totalSalesLastWeek** تومان
🛒 خرید ووچر: **$f_totalPurchasesLastWeek** تومان
📥 واریزی‌ها: **$f_totalTransactionsLastWeek** تومان
📤 برداشت‌ها: **$f_totalWithdrawalsLastWeek** تومان

📅 **آمار ماه جاری**

💰 فروش ووچر: **$f_totalSalesMonth** تومان
🛒 خرید ووچر: **$f_totalPurchasesMonth** تومان
📥 واریزی‌ها: **$f_totalDepositsMonth** تومان
📤 برداشت‌ها: **$f_totalWithdrawalsMonth** تومان

♾ **آمار کل**

💰 کل فروش ووچر: **$f_totalSoldVouchers** تومان
🛒 کل خرید ووچر: **$f_totalPurchasedVouchers** تومان
📥 کل واریزی‌ها: **$f_totalAmount** تومان
📤 کل برداشت‌ها: **$f_totalWithdrawals** تومان
";

$bot->sendMessage($from_id, $response_text);
    die;
}

Batal

Isi Zip:

Create