<?php
header("Content-Type: text/html; charset=utf-8");
date_default_timezone_set('PRC');
require_once __DIR__ . '/configure.php';

$username = $_GET['username'];
$plan = $_GET['plan'];
$days = $_GET['days'];
$type = $_GET['type'];
$ip = "";
if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
    $ip = $_SERVER['HTTP_CLIENT_IP'];
} elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
    $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
} else {
    $ip = $_SERVER['REMOTE_ADDR'];
}

$db = new Connect;
$data = $db->prepare("select * from vpnuser where vuser = '".$username."'");
$data->execute();
$row = $data->fetch(PDO::FETCH_ASSOC);

if (!empty($row)){
    $hyid = "2";
    $speed = "1024";
    $group = "BY";
    $months = "+1 month";
    $day = 30;
    $price = 100;
    $package = "월정제 Basic(30일)";
    if($days == "1month") {
        $day = 30;
        $months = "+1 month";
        if($plan == "basic") {
            $price = 100;
            $package = "월정제 Basic(30일)";
            $hyid = "2";
            $speed = "1024";
        } else if($plan == "premium") {
            $price = 200;
            $package = "월정제 Premium(30일)";
            $hyid = "3";
            $speed = "2048";
        } else if($plan == "vip") {
            $price = 400;
            $package = "월정제 VIP(30일)";
            $hyid = "4";
            $speed = "4096";
        }
    } else if($days == "12month") {
        $day = 365;
        $months = "+1 year";
        if($plan == "basic") {
            $price = 600;
            $package = "월정제 Basic(선납1년)";
            $hyid = "2";
            $speed = "1024";
        } else if($plan == "premium") {
            $package = "월정제 Premium(선납1년)";
            $price = 1200;
            $hyid = "3";
            $speed = "2048";
        } else if($plan == "vip") {
            $price = 2400;
            $package = "월정제 VIP(선납1년)";
            $hyid = "4";
            $speed = "4096";
        }
    }
    $data = $db->prepare("INSERT INTO prddbh (paymethod, bh, vpnus, spname, groups, sday, sjg, ddtype, ddtime, ddip, oldhyid, oldlastdate) VALUES ('"
        .$type."', '"
        .date("Ymd").mt_rand(1000,9999)."', '"
        .$username."', '"
        .$package."', 'BY', '"
        .$day."', '"
        .$price."', 'android', '"
        .date("Y-m-d H:i:s")."', '"
        .$ip."', '"
        .$row['hyid']."', '"
        .$row['lastdate']."' )");
    $data->execute();

    if($row['groups'] == 'LL') {
        $data = $db->prepare("update vpnuser set lastdate = '".date("Y-m-d H:i:s", strtotime($months))
            ."', hyid = '".$hyid
            ."', groups = '".$group
            ."', updk = '".$speed
            ."', downdk = '".$speed
            ."', flow = 0 where vuser='".$username."'");
        $data->execute();
    } else {
        if (date("Y-m-d H:i:s", strtotime($row['lastdate'])) <= date("Y-m-d H:i:s" )) {
            $data = $db->prepare("update vpnuser set lastdate = '".date("Y-m-d H:i:s", strtotime($months))
                ."', hyid = '".$hyid
                ."', groups = '".$group
                ."', updk = '".$speed
                ."', downdk = '".$speed
                ."', flow = 0 where vuser='".$username."'");
            $data->execute();
        } else {
            if($hyid == 2) {
                if($row['hyid'] == 2) {
                    $data = $db->prepare("update vpnuser set lastdate = '".date("Y-m-d H:i:s", strtotime($months, strtotime($row['lastdate'])))
                        ."', hyid = '".$hyid
                        ."', groups = '".$group
                        ."', updk = '".$speed
                        ."', downdk = '".$speed
                        ."', flow = 0 where vuser='".$username."'");
                    $data->execute();
                } else {
                    $data = $db->prepare("update vpnuser set lastdate = '".date("Y-m-d H:i:s", strtotime($months))
                        ."', hyid = '".$hyid
                        ."', groups = '".$group
                        ."', updk = '".$speed
                        ."', downdk = '".$speed
                        ."', flow = 0 where vuser='".$username."'");
                    $data->execute();

                    $newData = $db->prepare("select * from vpnuser where vuser='".$username."'");
                    $newData->execute();
                    $new = $newData->fetch(PDO::FETCH_ASSOC);

                    $now = time(); // or your date as well
                    $expire = strtotime($row['lastdate']);
                    $datediff = $expire - $now;
                    $days = round($datediff / (60 * 60 * 24));
                    $money = 0;
                    if($row['hyid'] == 3)
                        $money = ($days / 30) * 8.9;
                    else if($row['hyid'] == 4)
                        $money = ($days / 30) * 17.9;
                    $plusDays = round($money / (4.5 / 30));
                    $plusStr = "+1 day";
                    if($plusDays > 1) {
                        $plusStr = "+".$plusDays." days";
                    }
                    $data = $db->prepare("update vpnuser set lastdate = '".date("Y-m-d H:i:s", strtotime($plusStr, strtotime($new['lastdate'])))
                        ."' where vuser='".$username."'");
                    $data->execute();
                }
            } else if($hyid == 3) {
                if($row['hyid'] == 3) {
                    $data = $db->prepare("update vpnuser set lastdate = '".date("Y-m-d H:i:s", strtotime($months, strtotime($row['lastdate'])))
                        ."', hyid = '".$hyid
                        ."', groups = '".$group
                        ."', updk = '".$speed
                        ."', downdk = '".$speed
                        ."', flow = 0 where vuser='".$username."'");
                    $data->execute();
                } else {
                    $data = $db->prepare("update vpnuser set lastdate = '".date("Y-m-d H:i:s", strtotime($months))
                        ."', hyid = '".$hyid
                        ."', groups = '".$group
                        ."', updk = '".$speed
                        ."', downdk = '".$speed
                        ."', flow = 0 where vuser='".$username."'");
                    $data->execute();

                    $newData = $db->prepare("select * from vpnuser where vuser='".$username."'");
                    $newData->execute();
                    $new = $newData->fetch(PDO::FETCH_ASSOC);

                    $now = time(); // or your date as well
                    $expire = strtotime($row['lastdate']);
                    $datediff = $expire - $now;
                    $days = round($datediff / (60 * 60 * 24));
                    $money = 0.0;
                    if($row['hyid'] == 2) {
                        $money = ($days / 30) * 4.5;
                    } else if($row['hyid'] == 4) {
                        $money = ($days / 30) * 17.9;
                    }
                    $plusDays = round($money / (8.9 / 30));
                    $plusStr = "+1 day";
                    if($plusDays > 1) {
                        $plusStr = "+".$plusDays." days";
                    }

                    $data = $db->prepare("update vpnuser set lastdate = '".date("Y-m-d H:i:s", strtotime($plusStr, strtotime($new['lastdate'])))
                        ."' where vuser='".$username."'");
                    $data->execute();
                }
            } else if($hyid == 4) {
                if($row['hyid'] == 4) {
                    $data = $db->prepare("update vpnuser set lastdate = '" . date("Y-m-d H:i:s", strtotime($months, strtotime($row['lastdate'])))
                        . "', hyid = '" . $hyid
                        . "', groups = '" . $group
                        . "', updk = '" . $speed
                        . "', downdk = '" . $speed
                        . "', flow = 0 where vuser='" . $username . "'");
                    $data->execute();
                } else {
                    $data = $db->prepare("update vpnuser set lastdate = '".date("Y-m-d H:i:s", strtotime($months))
                        ."', hyid = '".$hyid
                        ."', groups = '".$group
                        ."', updk = '".$speed
                        ."', downdk = '".$speed
                        ."', flow = 0 where vuser='".$username."'");
                    $data->execute();

                    $newData = $db->prepare("select * from vpnuser where vuser='".$username."'");
                    $newData->execute();
                    $new = $newData->fetch(PDO::FETCH_ASSOC);

                    $now = time(); // or your date as well
                    $expire = strtotime($row['lastdate']);
                    $datediff = $expire - $now;
                    $days = round($datediff / (60 * 60 * 24));
                    $money = 0.0;
                    if($row['hyid'] == 3)
                        $money = ($days / 30) * 8.9;
                    else if($row['hyid'] == 2)
                        $money = ($days / 30) * 4.5;
                    $plusDays = round($money / (17.9 / 30));
                    $plusStr = "+1 day";
                    if($plusDays > 1) {
                        $plusStr = "+".$plusDays." days";
                    }
                    $data = $db->prepare("update vpnuser set lastdate = '".date("Y-m-d H:i:s", strtotime($plusStr, strtotime($new['lastdate'])))
                        ."' where vuser='".$username."'");
                    $data->execute();
                }
            }
        }
    }


    if($data->execute()) {
        echo json_encode([
            "status" => 200,
            "message" => "Success",
            "data" => $row
        ]);
        return;
    }
} else {
    echo json_encode([
        "status" => 401,
        "message" => "User doesn't exist",
    ]);
    return;
}
?>