<?PHP
function mysqli($sql){
    require 'config/config.php';
    $query  = $connect->query($sql);
    return $query;
}
function login($username,$password){
    session_start();
    if(!$username || !$password){
        $pesan = json_encode(array('status'=>'failed','pesan'=>'Username / Password Kosong'));
    } else {
        $password = md5($password);
        $cek_sql = "SELECT * FROM query_user WHERE username = '$username' AND password = '$password'";
        $cek = mysqli($cek_sql);

        if($cek->num_rows == '1'){
            $_SESSION['login'] = $username;
            $pesan = json_encode(array('status' => 'success','pesan' => 'Login Success'));
        } else {
            $pesan = json_encode(array('status'=>'failed','pesan'=>'Username / Password Salah'));
        }
    }
    return $pesan;
}
function register($username,$password,$email){
    session_start();

    if(!$username || ! $password || ! $email){
        $pesan = json_encode(array('status'=>'failed','pesan'=>'Ada Data Yang Kosong'));
    } else if(strlen($username) > '12'){
        $pesan = json_encode(array('status'=>'failed','pesan'=>'Username Max. 12 Huruf'));
    } else if(strlen($username) < '6'){
        $pesan = json_encode(array('status'=>'failed','pesan'=>'Username Min. 6'));
    } else if(strlen($password) > '12'){
        $pesan = json_encode(array('status'=>'failed','pesan'=>'Password Max. 12 Huruf'));
    } else if(strlen($password) < '6'){
        $pesan = json_encode(array('status'=>'failed','pesan'=>'Password Min. 6'));
    } else if(!preg_match('/^\S+@[\w\d.-]{2,}\.[\w]{2,6}$/iU',$email)){
        $pesan = json_encode(array('status'=>'failed','pesan'=>'Format Email Salah'));
    } else {
        $cek_sql = "SELECT * FROM query_user WHERE username = '$username' ";
        $cek = mysqli($cek_sql);
        if($cek->num_rows == '0'){
            $password = md5($password);
            $date = date('Y-m-d');
            $reg_sql = "INSERT INTO query_user VALUES('$username','$password','$email','0','$date')";
            $reg = mysqli($reg_sql);
            if($reg){
                $_SESSION['login'] = $username;
                $pesan = json_encode(array('status'=>'success','pesan'=>'Register Success'));
            } else {
                die('Kontak Admin ');
            }
        } else {
            $pesan = json_encode(array('status'=>'failed','pesan'=>'Username Telah Terdaftar'));
        }
    }
    return $pesan;
}
function logout(){
    session_start();
    if($_SESSION['login']){
        unset($_SESSION['login']);

    }
}

function user(){

    $username = $_SESSION['login'];
    $cek_sql = "SELECT * FROM query_user WHERE username = '$username'";
    $cek = mysqli($cek_sql);
    if($cek->num_rows == '1'){
       $data = $cek->fetch_assoc();
        return $data;
    } else {
        header('location:logout');
    }
    function cekItem($item){
        $cek_sql = "SELECT * FROM query_service WHERE id = '$item'";
        $cek = mysqli($cek_sql);
         return $cek;
    }
    function order($item,$target,$quantity){
        require 'ZoldykAPI.Function.php';
        if(!$item || ! $target || ! $quantity){
            $pesan = json_encode(array('status'=>'failed','pesan' => 'Ada Data Yang Kosong'));

            } else {
            $cek = cekItem($item);
            if($cek->num_rows == '1'){
                $data = $cek->fetch_assoc();
                $data_price = $data['price'];
                $data_min = $data['min'];
                $data_max = $data['max'];
                $data_info = $data['info'];
                $price = $quantity*$data_price;
                $user = user();
                $saldo = $user['saldo'];
                $username = $user['username'];
                if($quantity > $max){
                    $pesan = json_encode(array('status'=>'failed','pesan' => "Max. Pembelian : $data_max"));
                } else if($quantity < $min){
                    $pesan = json_encode(array('status'=>'failed','pesan' => "Min. Pembelian : $data_min"));
                } else if($saldo < $price){
                    $pesan = json_encode(array('status'=>'failed','pesan' => "Saldo Tidak Mencukupi"));
                } else {
                    $order = order($target,$quantity,$item);
                    $json = json_decode($order,true);
                    if($json['status'] == 'success'){
                        $id = $json['message'];
                    $upd_sql = "UPDATE query_user SET saldo=saldo-$price WHERE username = '$username'";
                    $upd = mysqli($upd_sql);
                    $his_sql = "INSERT INTO query_history VALUES('$id','$username','$item | $target | $quantity','$date')";
                    $his = mysqli($his_sql);
                     $pesan = json_encode(array('status'=>'success','pesan' => "Order Berhasil , Silahkan Cek History Trx Untuk Data Lebih Lanjut . ID : $id"));
                    }
                }
            } else {
                $pesan = json_encode(array('status'=>'failed','pesan' => "Item TIdak Tersedia"));
            }
        }
    }
    return $pesan;
}
function history(){
    $user = user();
    $username = $user['username'];
    $cek_sql = "SELECT * FROM query_history WHERE username = '$username'";
    $cek = mysqli($cek_sql);
    return $cek;

}
function services(){
    $cek_sql = "SELECT * FROM query_service";
    $cek = mysqli($cek_sql);
     return $cek;
}
?>