<?php
try {
    $stmt = $pdo->query('SELECT kategorijos.Pavadinimas, kategorijos.Id, sandelys.Pavadinimas AS nieko, sandelys.Id AS nu
      FROM kategorijos
      INNER JOIN sandelys;');
} catch (Exception $e) {
    echo "Klaida: Negaliu gauti duomenų iš DB";
    exit;
}
$data = $stmt->fetchAll();

    if(isset($_POST['name'])) {
        $name = $_POST['name'];
        $description = $_POST['description'];
        $quantity = $_POST['quantity'];
        $price = $_POST['price'];
        $category = $_POST['category'];
        $Sandelio_Id = $_POST['Sandelio_Id'];

        if (isset($_POST['submit'])) {
            if (!empty($_POST['name']) AND !empty($_POST['description']) AND !empty($_POST['quantity']) AND !empty($_POST['price']) AND !empty($_POST['category']) AND !empty($_POST['Sandelio_Id'])) {
                if (ctype_digit($quantity)) {
                    echo "";
                } else {
                    echo "Įvesk skaičių";
                }
                if (is_numeric($price)) {
                    echo "";
                } else {
                    echo "įvesk numerį";
                }
                if (!empty($_FILES['photo'])) {
                    $path = "uploads/";
                    $path = $path . basename($_FILES['photo']['name']);
                    if (move_uploaded_file($_FILES['photo']['tmp_name'], $path)) {
                        echo "Produkto nuotrauka " . basename($_FILES['photo']['name']) .
                            " įkelta sėkmingai";
                        $photo = basename($_FILES['photo']['name']);
                    } else {
                        echo "Klaida įkeliant nuotrauką";
                    }
                }
                try {
                    $stmt = "INSERT INTO prekes (Pavadinimas, Aprasymas, Kiekis, Kaina, Nuotrauka, Kategorija, Sandelio_Id)
        VALUES (:name, :description, :quantity, :price, :photo, :category, :Sandelio_Id)";
                    $querie = $pdo->prepare($stmt);
                    $querie->execute(array($name, $description, $quantity, $price, $photo, $category, $Sandelio_Id));
                } catch (Exception $e) {
                    echo "Negaliu pridėti naujo įrašo";
                    echo $e->getMessage();
                    exit;
                }
            }
        }
    } else {
        echo "<div class='alert alert-danger alert-dismissable fade in'>
<a href=\"#\" class=\"close\" data-dismiss=\"alert\" aria-label=\"close\">×</a>
    <strong>Nieko neįvedei :):)</strong>
  </div>";
    }

?>

<h2>Naujos prekės registracija</h2>

<form method="post" enctype="multipart/form-data" id="prekes-registracija" data-parsley-validate="" class="form-horizontal form-label-left" novalidate="">

    <div class="form-group">
        <label class="control-label col-md-3 col-sm-3 col-xs-12" for="name">Pavadinimas <span class="required">*</span>
        </label>
        <div class="col-md-6 col-sm-6 col-xs-12">
            <input type="text" id="name" name="name" required="required" class="form-control col-md-7 col-xs-12">
        </div>
    </div>




    <div class="form-group">
        <label class="control-label col-md-3 col-sm-3 col-xs-12" for="category">Kategorija <span class="required">*</span>
        </label>
        <div class="col-md-6 col-sm-6 col-xs-12">
            <select id="category" name="category" required="required" class="form-control col-md-7 col-xs-12">
                <option>Pasirinkite</option>
                <?php foreach($data as $val):?>
                <option value="<?php echo $val['Id'];?>"><?php echo $val['Pavadinimas'];?></option>
                <?php endforeach;?>
            </select>
        </div>
    </div>







        <div class="form-group">
            <label class="control-label col-md-3 col-sm-3 col-xs-12" for="category">Sandelys <span class="required">*</span>
            </label>
            <div class="col-md-6 col-sm-6 col-xs-12">
                <select id="Sandelio_Id" name="Sandelio_Id" required="required" class="form-control col-md-7 col-xs-12">
                    <option>Pasirinkite</option>
                    <?php foreach($data as $val):?>
                        <option value="<?php echo $val['nu'];?>"><?php echo $val['nieko'];?></option>
                    <?php endforeach;?>
                </select>

            </div>
    </div>





    <div class="form-group">
        <label class="control-label col-md-3 col-sm-3 col-xs-12" for="description">Aprašymas <span class="required">*</span>
        </label>
        <textarea name="description"></textarea>

    </div>





    <div class="form-group">
        <label class="control-label col-md-3 col-sm-3 col-xs-12" for="photo">Nuotrauka <span class="required">*</span>
        </label>
        <div class="col-md-6 col-sm-6 col-xs-12">
            <input type="file" id="photo" name="photo" required="required" class="form-control col-md-7 col-xs-12">
        </div>
    </div>



    <div class='form-group'>
        <label class='control-label col-md-3 col-sm-3 col-xs-12' for='quantity'>Kiekis <span class='required'>*</span>
        </label>
        <div class='col-md-6 col-sm-6 col-xs-12'>
            <input type='number'  min='1' max='1000' name='quantity' required='required' class='form-control col-md-7 col-xs-12'>
        </div>
    </div>

    <div class="form-group">
        <label class="control-label col-md-3 col-sm-3 col-xs-12" for="price">Kaina <span class="required">*</span>
        </label>
        <div class="col-md-6 col-sm-6 col-xs-12">
            <input type="number" min=1 max=1000 name='price' required="required" class="form-control col-md-7 col-xs-12">
        </div>
    </div>






    <div class="ln_solid"></div>

    <div class="form-group">
        <div class="col-md-6 col-sm-6 col-xs-12 col-md-offset-3">
            <button class="btn btn-primary" type="button">Atšaukti</button>
            <button class="btn btn-primary" type="reset">Valyti</button>
            <button type="submit" name="submit" class="btn btn-success">Išsaugoti</button>
        </div>
    </div>
</form>