MAINHACK

Viewing / Editing File: suppliers.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{
$pageTitle = 'Suppliers';
$shopname = $_SESSION['business_name_Xw211qAAsq4'];

$notificationType = "success";
$message = "";

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

$supplier_name = test_input($_POST['supplier_name']);
$supplier_email = test_input($_POST['supplier_email']);
$supplier_number = test_input($_POST['supplier_number']);
$address = test_input($_POST['address']);

$sele = mysqli_query($new,"SELECT * FROM supplier WHERE supplier_name = '$supplier_name' AND business_name = '$shopname'");
$conrow = mysqli_fetch_array($sele);
$dbvendor = $conrow['supplier_name'];

if($supplier_name == ""){

$message = '<script> $(document).ready(function(){
swal("Warning!", "Supplier name is required", "warning");}); </script>';

}

if($supplier_name === $dbvendor){
$message = '<script> $(document).ready(function(){
swal("Warning!", "Supplier already  exist", "warning");}); </script>';
}

if(!$message){
    $date = date("Y-m-d h:i");

$stmt = $con->prepare("insert into supplier (supplier_name,supplier_email,supplier_number,address,business_name,supp_date) values(?,?,?,?,?,?) ");
$stmt->execute(array($supplier_name,$supplier_email,$supplier_number,$address,$shopname,$date));

$message = '<script> $(document).ready(function(){
swal("Success!", "Supplier is added", "success");}); </script>';
}

}

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

$SID = test_input($_POST['SID']);
    $stmt = $con->prepare("DELETE from supplier WHERE supplier_id = ?");
        $stmt->execute(array($SID)); 
$message = '<script> $(document).ready(function(){
swal("Success!", "Supplier deleted", "success");}); </script>';

}

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

$sup_id = test_input($_POST['sup_id']);
$supplier_name = test_input($_POST['supplier_name']);
$supplier_email = test_input($_POST['supplier_email']);
$supplier_number = test_input($_POST['supplier_number']);
$address = test_input($_POST['address']);

$stmt = $con->prepare("update supplier set supplier_name = ?, supplier_email = ?, supplier_number = ?, address = ? where supplier_id = ? ");
$stmt->execute(array($supplier_name,$supplier_email,$supplier_number,$address,$sup_id));
$message = '<script> $(document).ready(function(){
swal("Success!", "Supplier updated", "success");}); </script>';

//$responses = "<h5 class='btn btn-success'>Category updated successfuly</h5>";

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

#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">Suppliers</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 $pageTitle;?></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 = 'Service'");
$rowroles = mysqli_fetch_array($select_role);
$updaterecord = $rowroles['updaterecord'];
$deleterecord = $rowroles['deleterecord'];
$add_db = $rowroles['add'];
$type = $rowroles['type'];
?>
<?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>Supplier name</th>
    <th>Supplier email</th>
    <th>Supplier number</th>
    <th>Supplier address/location</th>
    <th>Action</th>
            </tr>
        </thead>

<?php
$cont = 1;
$stmt = $con->prepare("SELECT * FROM supplier WHERE business_name = ? ORDER BY supplier_id DESC ");
$stmt->execute(array($shopname));
$rows_services = $stmt->fetchAll();
?>
<tr>
    <?php 
    foreach($rows_services as $service){
    ?>
    <td><?php echo  $cont++;?></td>
    <td><?php echo $service['supplier_name'];?></td>
    <td><?php echo $service['supplier_email'];?></td>
    <td><?php echo $service['supplier_number'];?></td>
    <td><?php echo $service['address'];?></td>

<?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 $updaterecord == '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 $updaterecord == '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 }?>

<?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 }?>

<!-- <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>

<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>
 -->
<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 Supplier</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">
Are you sure you want to delete this Supplier?
</div>
<input type="hidden" name="SID" value="<?php echo $service['supplier_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-danger delete_category_bttn">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">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title h4" id="myLargeModalLabel">Edit Supplier</h5>
<button type="button" class="close waves-effect waves-light" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
<div id="response"></div>
</div>
<div class="modal-body">
<form method="POST">
       <div class="row">
            <div class="form-group col-md-6">
                <label>Supplier name</label>
                <input type="text" name="supplier_name" value="<?php echo $service['supplier_name'];?>"  class="form-control" style="height:40px">
            </div>
            <div class="form-group col-md-6">
                <label>Supplier Email</label>
              <input type="email" name="supplier_email" value="<?php echo $service['supplier_email'];?>" class="form-control" style="height:40px">
            </div>
             <div class="form-group col-md-6">
                <label>Phone number</label>
                <input type="number" name="supplier_number" value="<?php echo $service['supplier_number'];?>"  class="form-control" style="height:40px">
            </div>
            <input type="hidden" name="sup_id" value="<?php echo $service['supplier_id'];?>">
            <div class="form-group col-md-6">
                <label>Address/Location</label>
                    <input type="text" name="address" value="<?php echo $service['address'];?>"  class="form-control" style="height:40px">
            </div>
             <div class="form-group col-md-4">
             <button type="submit" name="update"  class="btn btn-success form-control">Send</button>
            </div>
        </div>
        </form>
</div>
</div>
</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/SupplierModal.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-header">
<h5 class="modal-title h4" id="myLargeModalLabel">Add New Supplier</h5>
<button type="button" class="close waves-effect waves-light" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span>
</button>
<div id="response"></div>
</div>

<div class="modal-body">
<form method="post" accept-charset="utf-8">
       <div class="row">
            <div class="form-group col-md-6">
                <label>Supplier name</label>
                <input type="text" name="supplier_name"  class="form-control" style="height:40px">
            </div>
            <div class="form-group col-md-6">
                <label>Supplier Email</label>
              <input type="email" name="supplier_email"  class="form-control" style="height:40px">
            </div>
             <div class="form-group col-md-6">
                <label>Phone number</label>
                <input type="number" name="supplier_number"  class="form-control" style="height:40px">
            </div>
            <div class="form-group col-md-6">
                <label>Address/Location</label>
                <input type="text" name="address"  class="form-control" style="height:40px">
            </div>

</body>

</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: suppliers.php

Server Info

System Features

User Info