<?php
date_default_timezone_set('Europe/Kiev');
header('Content-Type: text/html; charset=utf-8');
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: POST, GET');

$servername = "localhost";
$username = "id956225_id956225_ssergey931";
$password = "fuckerspace";
$dbname = "id956225_dbmigration";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// $conn->close();
?>

<?php
if (!empty($_POST))
{

    if (!empty($_POST['isNewOrder'])) {
        $firstName = $_POST['firstName'];
        $lastName = $_POST['lastName'];
        $phone = $_POST['phoneNumber'];
        $deviceType = $_POST['DeviceType'];
        $deviceName = $_POST['productName'];
        $deviceTypeIndex = $_POST['DeviceTypeIndex'];
        $breaking = $_POST['issue'];
        $notes = $_POST['notes'];
        $performedRepairs = $_POST['performedRepairs'];
        $orderStatus = $_POST['orderStatus'];

        $query = "INSERT INTO mainbase (Date_of_Issue, FirstNameC, LastNameC, Nphone, Type_device, Name_Device, Breaking, Notes, Performed_repairs, Order_status, Warranty_start, Warranty_end, Date_design, Price) VALUES (now(), '$firstName', '$lastName', '$phone', '$deviceType', '$deviceName', '$breaking', '$notes', '$performedRepairs', '$orderStatus', now(), NOW()+INTERVAL 1 DAY, now(), '0')";

        if (mysqli_query($conn, $query)) {
            echo "New order created successfully\n";

            $query = $conn->query("SELECT Number_order FROM mainbase ORDER BY Number_order DESC LIMIT 1");
            while($data = $query->fetch_assoc()) {
                $orderNumber = $data["Number_order"];
                echo "The last order number is: " . $data["Number_order"]. "\n";
            }

            $comp = $_POST['comp'];
            $charger = $comp['charger'];
            $battery = $comp['battery'];
            $bag = $comp['bag'];
            $cable = $comp['cable'];
            $flashDrive = $comp['flashDrive'];
            $simCard = $comp['simCard'];
            $caps = $comp['caps'];
            $appearance = $_POST['appearance'];
            $workflowNotes = $_POST['workflowNotes'];
            $seal = $_POST['seal'];

            $query = "INSERT INTO komplekt (ID_Zakaz, Charger, Battery, Bag, Cable, FlashDrive, SimCard, Caps, Appearance, WorkflowNotes, Seal) VALUES ('$orderNumber', '$charger', '$battery', '$bag', '$cable', '$flashDrive', '$simCard', '$caps', '$appearance', '$workflowNotes', '$seal')";
            if (mysqli_query($conn, $query)) {
                echo "Complectation info is added too\n";
            } else {
                echo "Error: " . $query . "<br>" . mysqli_error($conn);
            }
        } else {
            echo "Error: " . $query . "<br>" . mysqli_error($conn);
        }
    }
    if (!empty($_POST['isEditOrder'])) {
        $issue = $_POST['issue'];
        $dateOfissue = $_POST['date'];
        $dateDesign = $_POST['dateDesign'];
        $firstName = $_POST['firstName'];
        $lastName = $_POST['lastName'];
        $phoneNumber = $_POST['phoneNumber'];
        $deviceName = $_POST['productName'];
        $deviceType = $_POST['DeviceType'];
        $notes = $_POST['notes'];
        $orderNumber = $_POST['orderNumber'];
        $orderStatus = $_POST['orderStatus'];
        $performedRepairs = $_POST['performedRepairs'];
        $warrantyStart = $_POST['warrantyStart'];
        $warrantyEnd = $_POST['warrantyEnd'];
        $price = $_POST['price'];
        $seal = $_POST['seal'];
        $appearance = $_POST['appearance'];
        $workflowNotes = $_POST['workflowNotes'];
        $comp = $_POST['comp'];

        $query = "UPDATE mainbase SET Breaking='$issue', Date_of_Issue='$dateOfissue', FirstNameC='$firstName', LastNameC='$lastName', Nphone='$phoneNumber', Type_device='$deviceType', Name_device='$deviceName', notes='$notes', Performed_repairs='$performedRepairs', Order_status='$orderStatus', Warranty_start='$warrantyStart', Warranty_end='$warrantyEnd', Date_design='$dateDesign', Price='$price' WHERE Number_order='$orderNumber'";
        if (mysqli_query($conn, $query)) {
            echo "The record was updated successfully";
        } else {
            echo "Error: " . $query . "<br>" . mysqli_error($conn);
        }

    }
    if (!empty($_POST['getdata'])) {
        $arrsum = array();
        $data_comp = array();
        $data_orders = array();
        $data_types = array();
        $data_users = array();

        $query = $conn->query("SELECT * FROM komplekt");
        while($data = $query->fetch_assoc()) {
            $data_comp[$data["ID_Zakaz"]] = $data;
        }
        $query = $conn->query("SELECT * FROM mainbase ORDER BY Number_order DESC");
        while($data = $query->fetch_assoc()) {
            $data_orders[] = $data;
        }
        $query = $conn->query("SELECT * FROM type");
        while($data = $query->fetch_assoc()) {
            $data_types[] = $data;
        }
        $query = $conn->query("SELECT * FROM users");
        while($data = $query->fetch_assoc()) {
            $data_users[] = $data;
        }
        $arrsum[] = $data_comp;
        $arrsum[] = $data_orders;
        $arrsum[] = $data_types;
        $arrsum[] = $data_users;
        echo json_encode($arrsum);
    }
}



?>