connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Authentication Logic
if (isset($_POST['login'])) {
$email = $_POST['email'];
$password = $_POST['password'];
$stmt = $conn->prepare("SELECT * FROM resellers WHERE email = ?");
$stmt->bind_param("s", $email);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows === 1) {
$user = $result->fetch_assoc();
if (password_verify($password, $user['password'])) {
$_SESSION['reseller_id'] = $user['id'];
} else {
echo "Invalid password";
exit();
}
} else {
echo "Invalid email";
exit();
}
}
// Logout Logic
if (isset($_GET['logout'])) {
session_destroy();
header("Location: ?");
exit();
}
// Protect Dashboard
if (!isset($_SESSION['reseller_id'])) {
echo '';
exit();
}
$reseller_id = $_SESSION['reseller_id'];
$res = $conn->query("SELECT * FROM resellers WHERE id = $reseller_id")->fetch_assoc();
$rate = $res['rate'];
// Functions
function getCount($table, $rid, $conn) {
return $conn->query("SELECT COUNT(*) as c FROM $table WHERE reseller_id = $rid")->fetch_assoc()['c'];
}
function getSum($table, $rid, $conn) {
return $conn->query("SELECT SUM(amount) as s FROM $table WHERE reseller_id = $rid AND status='success'")->fetch_assoc()['s'] ?? 0;
}
$activations = getCount('activations', $reseller_id, $conn);
$paid = getSum('payments', $reseller_id, $conn);
$due = ($activations * $rate) - $paid;
// Payment Processing
if (isset($_POST['make_payment'])) {
$amount = $_POST['amount'];
$conn->query("INSERT INTO payments (reseller_id, amount, status, date) VALUES ($reseller_id, $amount, 'success', NOW())");
echo "";
exit();
}
// Fetch Replacements
$replacements = $conn->query("SELECT * FROM replacements WHERE reseller_id = $reseller_id");
?>
Reseller Dashboard
Your Stats
Activations:
Rate: ₹
Paid: ₹
Due: ₹
Make a Payment
Replacements
fetch_assoc()) {
echo "- " . $r['product'] . " - " . $r['reason'] . "
";
} ?>