<?php
// classes/User.php

class User {
    private $conn;
    private $table_name = "users";
    
    public $id;
    public $username;
    public $email;
    public $password_hash;
    public $tier;
    public $package;
    public $balance;
    public $total_deposits;
    public $total_withdrawals;
    public $rewards;
    
    public function __construct($db) {
        $this->conn = $db;
    }
    
    // Get user by ID
    public function getUserById($id) {
        $query = "SELECT * FROM " . $this->table_name . " WHERE id = ? LIMIT 0,1";
        $stmt = $this->conn->prepare($query);
        $stmt->bindParam(1, $id);
        $stmt->execute();
        
        $row = $stmt->fetch(PDO::FETCH_ASSOC);
        
        if($row) {
            $this->id = $row['id'];
            $this->username = $row['username'];
            $this->email = $row['email'];
            $this->tier = $row['tier'];
            $this->package = $row['package'];
            $this->balance = $row['balance'];
            $this->total_deposits = $row['total_deposits'];
            $this->total_withdrawals = $row['total_withdrawals'];
            $this->rewards = $row['rewards'];
            return true;
        }
        return false;
    }
    
    // Get user by username
    public function getUserByUsername($username) {
        $query = "SELECT * FROM " . $this->table_name . " WHERE username = ? LIMIT 0,1";
        $stmt = $this->conn->prepare($query);
        $stmt->bindParam(1, $username);
        $stmt->execute();
        
        $row = $stmt->fetch(PDO::FETCH_ASSOC);
        
        if($row) {
            $this->id = $row['id'];
            $this->username = $row['username'];
            $this->email = $row['email'];
            $this->tier = $row['tier'];
            $this->package = $row['package'];
            $this->balance = $row['balance'];
            $this->total_deposits = $row['total_deposits'];
            $this->total_withdrawals = $row['total_withdrawals'];
            $this->rewards = $row['rewards'];
            return true;
        }
        return false;
    }
    
    // Update user balance
    public function updateBalance($amount) {
        $query = "UPDATE " . $this->table_name . " SET balance = balance + ? WHERE id = ?";
        $stmt = $this->conn->prepare($query);
        $stmt->bindParam(1, $amount);
        $stmt->bindParam(2, $this->id);
        
        if($stmt->execute()) {
            $this->balance += $amount;
            return true;
        }
        return false;
    }
    
    // Update user deposits
    public function updateDeposits($amount) {
        $query = "UPDATE " . $this->table_name . " SET total_deposits = total_deposits + ? WHERE id = ?";
        $stmt = $this->conn->prepare($query);
        $stmt->bindParam(1, $amount);
        $stmt->bindParam(2, $this->id);
        
        if($stmt->execute()) {
            $this->total_deposits += $amount;
            return true;
        }
        return false;
    }
    
    // Update user withdrawals
    public function updateWithdrawals($amount) {
        $query = "UPDATE " . $this->table_name . " SET total_withdrawals = total_withdrawals + ? WHERE id = ?";
        $stmt = $this->conn->prepare($query);
        $stmt->bindParam(1, $amount);
        $stmt->bindParam(2, $this->id);
        
        if($stmt->execute()) {
            $this->total_withdrawals += $amount;
            return true;
        }
        return false;
    }
    
    // Update user rewards
    public function updateRewards($amount) {
        $query = "UPDATE " . $this->table_name . " SET rewards = rewards + ? WHERE id = ?";
        $stmt = $this->conn->prepare($query);
        $stmt->bindParam(1, $amount);
        $stmt->bindParam(2, $this->id);
        
        if($stmt->execute()) {
            $this->rewards += $amount;
            return true;
        }
        return false;
    }
}
?>