MAINHACK

Viewing / Editing File: add-new-stock.php

<?php include("../admin/includes/functions/functions.php");?>
<?php include("../admin/db/db.php");?>
<?php 
if(!isset($_SESSION['username_Xw211qAAsq4']))
{
header('Location: ../auth/');
exit();
} else{
$pageTitle1 = 'Add New Stock';
$shopname = $_SESSION['business_name_Xw211qAAsq4'];

$message = "";

if(isset($_POST['add'])){

$pro_id = test_input($_POST['pro_id']);
$qty = test_input($_POST['qty']);
$date = test_input($_POST['date']);

if($pro_id==""){
     $message = '<script> $(document).ready(function(){
    swal("Warning!", "Select supplier", "warning");}); </script>';
}

if($qty==""){
      $message = '<script> $(document).ready(function(){
    swal("Warning!", "Enter stock qty", "warning");}); </script>';
}

if($date==""){
     $message = '<script> $(document).ready(function(){
    swal("Warning!", "Enter stock date", "warning");}); </script>';
}

if(!$message){

$stmt = $con->prepare("insert into stock (pro_id,qty,date,business_name) values(?,?,?,?) ");
$stmt->execute(array($pro_id,$qty,$date,$shopname));

$stmtCheckClient = $con->prepare("SELECT * FROM products WHERE pro_id = ?");
$stmtCheckClient->execute(array($pro_id));
$client_result = $stmtCheckClient->fetch();

$db_qty = $client_result["qty"];

$qtytotal = $db_qty + $qty;

$stmt = $con->prepare("update  products set qty = ?  where pro_id = ? ");
$stmt->execute(array($qtytotal,$pro_id));

$message = '<script> $(document).ready(function(){
    swal("Success!", "Enter stock date", "success");}); </script>';
}

}

if(isset($_POST['del'])){
   $STK = mysqli_real_escape_string($new,$_POST['STK']);
   $pro_id = mysqli_real_escape_string($new,$_POST['pro_id']);

$STK = test_input($_POST['STK']);
   $pro_id = test_input($_POST['pro_id']);

$sele = "SELECT qty FROM stock WHERE stock_id = '$STK'";
   $stok = mysqli_query($new,$sele);
   $dbstock = mysqli_fetch_array($stok);
   $Sqty = $dbstock['qty'];

$seler = "SELECT qty FROM products WHERE pro_id = '$pro_id'";
   $stokk = mysqli_query($new,$seler);
   $dbproid = mysqli_fetch_array($stokk);
   $Pqty = $dbproid['qty'];

$oldqty = $Pqty - $Sqty;
    $stmt = $con->prepare("update products set qty = ? where pro_id = ?");
   $stmt->execute(array($oldqty,$pro_id));

$DEL = mysqli_query($new,"DELETE FROM stock WHERE stock_id = '$STK'");
  header("Location: add-new-stock");
}

if(isset($_POST['editqty'])){

$fetch_pro_id  = test_input($_POST['fetch_pro_id']);
$update_qty  = test_input($_POST['update_qty']);

$seler = "SELECT qty FROM products WHERE pro_id = '$fetch_pro_id'";
$stokk = mysqli_query($new,$seler);
$dbproid = mysqli_fetch_array($stokk);
$Pqty1 = $dbproid['qty'];

$sele = "SELECT qty FROM stock WHERE pro_id = '$fetch_pro_id'";
$stok = mysqli_query($new,$sele);
$dbstock = mysqli_fetch_array($stok);
$Sqty1 = $dbstock['qty'];

$origalqty = $Pqty1 - $Sqty1;

$stmt = $con->prepare("update products set qty = ? where pro_id = ?");
$stmt->execute(array($origalqty,$fetch_pro_id));

$final_qty = $origalqty + $update_qty;

$stmt = $con->prepare("update products set qty = ? where pro_id = ?");
$stmt->execute(array($final_qty,$fetch_pro_id));

$stmt = $con->prepare("update stock set qty = ? where pro_id = ?");
$stmt->execute(array($origalqty,$fetch_pro_id));

}

// if(isset($_POST['del'])){

//    $STK = mysqli_real_escape_string($new,$_POST['STK']);
//    $pro_id = mysqli_real_escape_string($new,$_POST['pro_id']);

//    $sele = "SELECT qty FROM stock WHERE stock_id = '$STK'";
//    $stok = mysqli_query($new,$sele);
//    $dbstock = mysqli_fetch_array($stok);
//    $Sqty = $dbstock['qty'];

//    $seler = "SELECT qty FROM products WHERE pro_id = '$pro_id'";
//    $stokk = mysqli_query($new,$seler);
//    $dbproid = mysqli_fetch_array($stokk);
//    $Pqty = $dbproid['qty'];

//     $oldqty = $Pqty - $Sqty;

//     $stmt = $con->prepare("update products set qty = ? where pro_id = ?");
//    $stmt->execute(array($oldqty,$pro_id));

//   $DEL = mysqli_query($new,"DELETE FROM stock WHERE stock_id = '$ID'");
//   header("Location: add-new-stock");
// }

// if(isset($_POST['update'])){

// $pro_id  = test_input($_POST['pro_id']);
// $product_name  = test_input($_POST['product_name']);
// $qty  = test_input($_POST['qty']);
// $price  = test_input($_POST['price']);
// $supplier_id  = test_input($_POST['supplier_id']);
// $date  = test_input($_POST['date']);

// $stmt = $con->prepare("update products set product_name = ?, qty = ?, price = ?, supplier = ?, date = ? where pro_id = ?");
// $stmt->execute(array($product_name,$qty,$price,$supplier_id,$date,$pro_id));

// }

}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title> <?php echo $shopname;?> - <?php echo $pageTitle1;?></title>

<link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/theme.min.css" rel="stylesheet" type="text/css" />

#loader {
display: block;
position: absolute;
top: 50%;
left: 50%;
border: 16px solid #f3f3f3;
border-top: 16px solid #3498db;
border-radius: 50%;
width: 70px;
height: 70px;
animation: spin 2s linear infinite;
}

@keyframes spin {
0% { transform: rotate(0deg); }
100% { transform: rotate(360deg); }
}
</style>

</head>

<div id="layout-wrapper">
<div class="header-border"></div>

<?php include("includes/template/head.php");?>
<?php include("includes/template/side.php");?>

<div class="row">
<div class="col-12">
<div class="page-title-box d-flex align-items-center justify-content-between">
<h4 class="mb-0 font-size-18">Product stock</h4>   
<?php 
if($message != "") {
echo ($message) ;
}
?> 
<div class="page-title-right">
<ol class="breadcrumb m-0">
<li class="breadcrumb-item"><a href="javascript: void(0);"><?= $shopname;?></a></li>
<li class="breadcrumb-item active"><?php echo $pageTitle1;?></li>
</ol>
</div>

</div>
</div>
</div>

<?php 
$stmt = $con->prepare("SELECT account_type FROM  barber_admin WHERE username = ? and business_name = ?");
$stmt->execute(array($username,$shopname));
$userstatus = $stmt->fetchAll();

foreach($userstatus as $sta)
{
    $namee = $sta['account_type'];
}

$select_role = mysqli_query($new,"SELECT * FROM role_permissions  WHERE business_name = '$shopname' and type = '$namee' and page_name = 'Add New Stock'");
$rowroles = mysqli_fetch_array($select_role);
$updaterecord = $rowroles['updaterecord'];
$deleterecord = $rowroles['deleterecord'];
$add_db = $rowroles['add'];
$type = $rowroles['type'];
$status = $rowroles['status'];
?>
<?php 
if($namee != "Admin"){?>
 <button type="button" class="btn btn-primary waves-effect waves-light" data-toggle="modal" data-target=".bd-example-modal-lg">Add</button>

<?php } elseif($namee == "Admin" and $add_db == '1' ) {?>
      <button type="button" class="btn btn-primary waves-effect waves-light" data-toggle="modal" data-target=".bd-example-modal-lg">Add</button>
<?php } elseif ($namee == "Admin" and $add_db == '0'){?>
   <button type="button"  disabled class="btn btn-primary waves-effect waves-light">Add</button>
<?php }?>

<br   /><br   />
<div class="table-responsive">           
<table id="basic-datatable" class="table table-hover table-striped table-bordered">
<thead style="background-color:#428bca;border:#428bca;">
<tr style="color: #ffffff;">
            <th>ID</th>
            <th>Product</th>
            <th>Qty</th>
            <th>Supplier</th>
            <th>Date</th>
            <th>Action</th>
            </tr>
        </thead>

<?php
$cont = 1;
$stmt = $con->prepare("SELECT  p.product_name as pname,p.pro_id as pro_id, s.supplier_name as sname,ss.qty as sqty, ss.date as ssdate,ss.stock_id as stock_id FROM products p ,supplier s ,stock ss WHERE p.pro_id = ss.pro_id and p.supplier = s.supplier_id and p.business_name = ? ORDER BY ss.stock_id DESC");
$stmt->execute(array($shopname));
$rows_services = $stmt->fetchAll();
foreach($rows_services as $service){

?>
                    <tr>
                        
    <td><?php echo  $cont++;?></td>
    <td><?php echo $service['pname'];?></td>
    <td><?php echo $service['sqty'];?></td>
    <td><?php echo $service['sname'];?></td>
    <td><?php echo date("F d Y",strtotime($service['ssdate'])) ?></td>
    <td>
    <?php  $edit_data = "edit_".$service["stock_id"];?>
    <?php  $delete_data = "delete_".$service["stock_id"];?>

<?php 
        if($namee != "Admin"){?>
        <li class="list-inline-item" data-toggle="tooltip" title="Delete">
        <a href="#"  data-toggle="modal" data-target="#<?php echo $delete_data; ?>" data-placement="top"><i class="fa fa-trash-alt" style="color:red"></i></a>
        </li>

<?php } elseif($namee == "Admin" and $deleterecord == '1' ) {?>
        <li class="list-inline-item" data-toggle="tooltip" title="Delete">
        <a href="#"  data-toggle="modal" data-target="#<?php echo $delete_data; ?>" data-placement="top"><i class="fa fa-trash-alt" style="color:red"></i></a>
        </li>

<?php } elseif ($namee == "Admin" and $deleterecord == '0'){?>
        <li class="list-inline-item" data-toggle="tooltip" title="Locked">
        <a class="disabled" data-placement="top"><i class="fa fa-trash-alt" style="color:red"></i></a>
        </li>
        <?php }?>

<!--      <?php 
        if($namee != "Admin"){?>
       <li class="list-inline-item" data-toggle="tooltip" title="Edit">
    <a href="#"  data-toggle="modal" data-target="#<?php echo $edit_data; ?>" data-placement="top"><i class="fa fa-edit"></i></a>
    </li>

<?php } elseif($namee == "Admin" and $deleterecord == '1' ) {?>
           <li class="list-inline-item" data-toggle="tooltip" title="Edit">
    <a href="#"  data-toggle="modal" data-target="#<?php echo $edit_data; ?>" data-placement="top"><i class="fa fa-edit"></i></a>
    </li>

<?php } elseif ($namee == "Admin" and $deleterecord == '0'){?>
            <li class="list-inline-item" data-toggle="tooltip" title="Locked">
    <a class="disabled" data-placement="top"><i class="fa fa-edit"></i></a>
    </li> 
        <?php }?>  -->

<ul>

<div class="modal fade" id="<?php echo $delete_data; ?>" tabindex="-1" role="dialog" aria-labelledby="<?php echo $delete_data; ?>" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel">Delete Stock</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
</div>
<div class="modal-body">
<form method="POST">
  Deleting this stock will dedute the stock quantity from the  product quantity?
</div>
<input type="hidden" name="STK" value="<?php echo $service['stock_id']; ?>">
<input type="hidden" name="pro_id" value="<?php echo $service['pro_id']; ?>">

<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>

<button type="submit" name="del" class="btn btn-success">Delete</button>
</form>
</div>
</div>
</div>
</div>

<div class="modal fade bd-example-modal-lg12" id="<?php echo $edit_data; ?>" tabindex="-1" role="dialog" aria-labelledby="<?php echo $edit_data; ?>" aria-hidden="true">

<?php 
$p_id = $service['stock_id'];
  $stockgty = "SELECT qty FROM stock WHERE stock_id = '$p_id'";
  $dboldqty = mysqli_query($new,$stockgty);
  $fetch = mysqli_fetch_array($dboldqty);
  $fetch_qty = $fetch['qty'];
  $fetch_pro_id = $fetch['pro_id'];

<input type="hidden" name="fetch_pro_id" value="<?php echo $fetch_pro_id; ?>">
<div class="form-group row">
<label for="start_date" class="col-sm-5 col-form-label">Qty </label>
<div class="col-sm-10"><input type="number" name="update_qty" value="<?php echo $fetch_qty; ?>" class="form-control" style="height : 45px;" autocomplete="off">
</div>
</div>
</div>
<br />

<div class="col-md-12 col-lg-6">
<!-- <div class="form-group row">
<label for="start_date" class="col-sm-5 col-form-label"> Supplier name</label>
<div class="col-sm-10">
<?php
    $stmt = $con->prepare("SELECT * FROM supplier WHERE business_name = ? order by supplier_name");
$stmt->execute(array($shopname));
    $rows_categories = $stmt->fetchAll();
?>

<select class="form-control" name="supplier_id" required >
<option value="">Select Supplier</option>
        <?php
            foreach($rows_categories as $category){
                echo "<option value = '".$category['supplier_id']."'>";
                    echo $category['supplier_name'];
                echo "</option>";
            }
        ?>
</select>
</div>
</div> -->

</li>
</ul>
  </td>
                    </tr>

<?php  };?>
                </tbody>
            </table>

</div>

</div>

</div> 
</div>

</div>

</div> 
</div>

<?php include("includes/template/newfooter.php");?>
</div>

</div>

<div class="menu-overlay"></div>

<?php //include("includes/modals/StockModal.php");?>
<div class="modal fade bd-example-modal-lg" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-body">
<div class="modal-body" style="width: 100%">
<form  class="row" id="add_category_bttn" method="POST">
<div class="col-md-6 col-lg-6">
<div class="form-group row">
<label for="company_name" class="col-sm-5 col-form-label">Product name</label>
<div class="col-sm-10">
<?php
    $stmt = $con->prepare("SELECT * FROM products,supplier WHERE products.supplier = supplier.supplier_id AND products.business_name = ?");
    $stmt->execute(array($shopname));
    $rows_categories = $stmt->fetchAll();
?>
<select class="form-control" name="pro_id"  style="height : 45px;" autocomplete="off">
<option value="">Select Supplier</option>
        <?php
            foreach($rows_categories as $category)
            {
                echo "<option value = '".$category['pro_id']."'>";
             echo $category['product_name'].' -- '.'<br>'.$category['supplier_name'];
                echo "</option>";
            }
        ?>
</select>
</div>
</div>
</div>
<div class="col-md-6 col-lg-6">
<div class="form-group row">
<label for="start_date" class="col-sm-5 col-form-label">Item Qty </label>
<div class="col-sm-10"><input type="number" name="qty" class="form-control" style="height : 45px;" autocomplete="off">
</div>
</div>
</div>
<br />

</div>
</form> 
</div>
</div>
</div>
</div>
</div>

</body>

</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: add-new-stock.php

Server Info

System Features

User Info