producten

producten.php

<?php
include_once("header.php");
include_once("functions.php");
include_once("top.php");
?>
<?php
$show_voorraads = show_producten(); ?>

<div class="row" style="margin-top: 50px;">
	<div class="col-6 col-md-4">
	 <?php include_once("sidebar.php"); ?>
</div>


<div class="col-12 col-sm-6 col-md-8">

<form class="form-horizontal" role="form" method="POST" action="producten.php">

 <div class="form-group">
  <div class="col-md-3">
  <label>Locatiecode</label>
  	<input id="locatiecode" type="text" class="form-control" name="Locatiecode" required autofocus>
  	</div>
  	</div>

  <div class="form-group">
  <div class="col-md-3">
  	 <label>Productcode</label>
  	<input id="productcode" type="text" class="form-control" name="Productcode" required autofocus>
  	</div>
  	</div>

  <div class="form-group">
  <div class="col-md-3">
  	<label>Aantal</label>
  	<input id="voorraad" type="text" class="form-control" name="Aantal" required autofocus>
  </div>
</div>
  <div class="form-group">
  <div class="col-md-3">
  	<button class="btn btn-lg  btn-block" type="submit">Toevoegen</button>
  	         </div>
  	         </div>
  	    </form>




<?php

if (isset($_POST['Locatiecode'])) {
  //echo "This var is set so I will print.";

require('connect.php');

$locatiecode =  $_POST['Locatiecode'];
$productcode =  $_POST['Productcode'];
$aantal =  $_POST['Aantal'];


$query = "SELECT Locatiecode, Productcode FROM `voorraad` WHERE Productcode='$productcode' and Locatiecode='$locatiecode'";

$result = mysqli_query($connection, $query) or die(mysqli_error($connection));
$count = mysqli_num_rows($result);
//
if ($count == 1){

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

$sum = 0;

$sq = "SELECT Aantal AS sum FROM voorraad WHERE Locatiecode = '$locatiecode' AND Productcode = '$productcode'";

$result = mysqli_query($mylink, $sq);

while($row = mysqli_fetch_object($result))
{
$GLOBALS['sum'] = $row->sum;
}
$GLOBALS['productaantal']= $sum + $aantal;

//echo $productaantal . "<br>";


$sql = "UPDATE voorraad SET Aantal='$productaantal' WHERE Locatiecode= '$locatiecode' AND Productcode = '$productcode'";
if ($conn->query($sql) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}

$conn->close();



}else{


 $sql = "INSERT INTO voorraad (Locatiecode, Productcode, Aantal)
VALUES ('$locatiecode', '$productcode', '$aantal')";

$result = mysqli_query($connection, $sql) or die(mysqli_error($connection));

$_SESSION['Locatie-toegevoegd'] = "Locatie toegevoegd!";

header("Location:voorraad.php?locatie=$locatiecode");
}
}

?>








<?php
if (count($show_voorraads)){ ?>
<table class="table">  <thead>
	<tr>
		<th scope="col">Productcode</th>
		<th scope="col">Product</th>
		<th scope="col">Type</th>
		<th scope="col">Fabriekscode</th>
		<th scope="col">Inkoopprijs</th>
		<th scope="col">Verkoopprijs</th>
	</tr>
</thead>
<tbody>
	<?php foreach ($show_voorraads as $key => $list){ ?>
	<tr>
		<td><?php echo $list['Productcode']; ?></td>
		<td><?php echo $list['Product']; ?></td>
		<td><?php echo $list['Type']; ?></td>
		<td><?php echo $list['Fabriekscode']; ?></td>
		<td><?php echo $list['Inkoopprijs']; ?></td>
		<td><?php echo $list['Verkoopprijs']; ?></td>
	</tr> <?php  } ?>

	</table><?php }
	else{ ?>
	<p><b>Er zijn geen locatie toegevoegd!</b></p>
<?php } ?>



<!---------------------------------------------------------------------------------------------------------------->



zoek.php

<?php
include_once("top.php");
include_once("header.php");
include_once("functions.php");


?>

<?php
   ?>

    <div class="row" style="margin-top: 50px;">
    <div class="col-6 col-md-4">

         <?php include_once("sidebar.php"); ?>

    </div>
   <div class="col-12 col-sm-6 col-md-8">

    <form class="form-horizontal" role="form" action="zoek.php" method="GET">
        <input type="text" placeholder="zoek op Type of productnaam" name="query" />
        <input type="submit" value="Search" />
    </form>


<?php
if (isset($_GET['query'])) {
   $like = $_GET['query'];
    $show_searchs = search($like);
if (count($show_searchs)){ ?>
<table class="table">
  <thead>

    <tr>

      <th scope="col">Product</th>
      <th scope="col">Type</th>
      <th scope="col">Locatiecode</th>
      <th scope="col">Aantal op voorraad</th>

    </tr>
  </thead>
  <tbody>
    <?php foreach ($show_searchs as $key => $list){ ?>
    <tr>

      <td><?php echo $list['Product']; ?></td>
      <td><?php echo $list['Type']; ?></td>
      <td><?php echo $list['Locatiecode']; ?></td>
       <td><?php echo $list['Aantal']; ?></td>

    </tr>
 <?php  } ?>
</table>
<?php }
    else{ ?> <p><b>!</b></p>

    <?php } }?>



  </div>

</div>




<?php
include_once("footer.php");

?>