Untitled

 avatar
unknown
plain_text
5 months ago
36 kB
2
Indexable
I'll send you code of my website, fix all the bugs and make it look good

categories.php:
<?php
include_once 'connection/db.php'; // Ensure your DB connection file is included

if (isset($_POST['add_category'])) {
    $category_name = trim($_POST['category_name']);
    if (!DB::query('SELECT name FROM categories WHERE name = :name', [':name' => $category_name])) {
        DB::query('INSERT INTO categories (name) VALUES (:name)', [':name' => $category_name]);
        $success = "Category added successfully!";
    } else {
        $error = "Category already exists!";
    }
}

if (isset($_POST['update_category'])) {
    $category_id = $_POST['category_id'];
    $new_name = trim($_POST['new_name']);
    DB::query('UPDATE categories SET name = :name WHERE id = :id', [':name' => $new_name, ':id' => $category_id]);
    $success = "Category updated successfully!";
}

if (isset($_POST['delete_category'])) {
    DB::query('DELETE FROM categories WHERE id = :id', [':id' => $_POST['category_id']]);
    $success = "Category deleted successfully!";
}
?>


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Manage Categories</title>
    <link rel="stylesheet" href="vendor/bootstrap/css/bootstrap.min.css">
</head>
<body>
<div class="container">
    <h1>Manage Categories</h1>
    
    <!-- Display Success or Error Messages -->
    <?php if (isset($success)): ?>
        <div class="alert alert-success"><?= $success ?></div>
    <?php elseif (isset($error)): ?>
        <div class="alert alert-danger"><?= $error ?></div>
    <?php endif; ?>

    <!-- Add Category Form -->
    <h2>Add Category</h2>
    <form method="POST" action="categories.php">
        <input type="text" name="category_name" placeholder="New Category Name" required>
        <button type="submit" name="add_category" class="btn btn-success">Add</button>
    </form>

    <!-- Edit/Delete Categories -->
    <h2>Existing Categories</h2>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>Category Name</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
        <?php
        $categories = DB::query('SELECT * FROM categories');
        foreach ($categories as $category):
        ?>
            <tr>
                <form method="POST" action="categories.php">
                    <td>
                        <input type="text" name="new_name" value="<?= $category['name'] ?>" required>
                        <input type="hidden" name="category_id" value="<?= $category['id'] ?>">
                    </td>
                    <td>
                        <button type="submit" name="update_category" class="btn btn-primary">Update</button>
                        <button type="submit" name="delete_category" class="btn btn-danger">Delete</button>
                    </td>
                </form>
            </tr>
        <?php endforeach; ?>
        </tbody>
    </table>
</div>
</body>
</html>


now header.php:

<?php include_once 'connection/db.php'; ?>
<?php include_once 'connection/mysqli.php'; ?>

<?php
  session_start();
  if ($_SESSION['logged_in'] != 1) {
      header('location:index.php');
  } else {
      $getfullname = $_SESSION['get_fullname'];
      $getage = $_SESSION['get_age'];
      $getaddress = $_SESSION['get_address'];
      $getposition = $_SESSION['get_position'];
  }
?>

<?php
  if (isset($_POST['logout'])) {
      $_SESSION['logged_in'] = 0;
      header('location: index.php');
  }
?>

<div class="container-fluid">
  <!-- Header Section -->
  <div class="row">
    <div class="col-12 text-center">
      <h1 class="brand mb-4">Ingredients Stock Management System</h1>
    </div>
  </div>

  <!-- Navigation Section -->
  <div class="row mb-3">
    <div class="col-12">
      <div class="btn-group">
        <!-- Home, Add Ingredients, Manager, User Management -->
        <a class="btn btn-default" href="home.php">
          <span class="fa fa-home"></span>&nbsp;Home
        </a>
        
        <a class="btn btn-default" href="add_stock.php">
          <span class="fa fa-cart-plus"></span>&nbsp;Add Ingredients Stock
        </a>
        
        <a class="btn btn-default" href="stock_manager.php">
          <span class="fa fa-area-chart"></span>&nbsp;Ingredients Stock Manager
        </a>
        
        <?php if ($_SESSION['get_position'] != 'USER') { ?>
          <a class="btn btn-default" href="account_registration.php">
            <span class="fa fa-user-secret"></span>&nbsp;User Management
          </a>
        <?php } ?>
        
        <!-- User Info and Dropdown -->
        <div class="btn-group ml-auto">
          <button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown">
            <span class="fa fa-user-circle"></span>&nbsp;<?php echo $getfullname; ?>&nbsp;
            <img src="images/online.png" width="10">&nbsp;<span class="caret"></span>
          </button>
          
          <ul class="dropdown-menu" role="menu">
            <li><a href="#" data-toggle="modal" data-target="#change">Change Password</a></li>
            <li>
              <form action="header.php" method="post">
                <button class="btn btn-link" type="submit" name="logout">Logout</button>
              </form>
            </li>
          </ul>
        </div>
      </div>
    </div>
  </div>
</div>

<!-- Change Password Modal (You can add this modal code where you need it) -->
<div id="change" class="modal fade" role="dialog">
  <div class="modal-dialog">
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal">&times;</button>
        <h4 class="modal-title"><span class="fa fa-gear"></span>&nbsp;Change Password</h4>
      </div>
      <div class="modal-body">
        <!-- Form for password change goes here -->
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
      </div>
    </div>
  </div>
</div>

<!-- Add Bootstrap JS and jQuery for dropdown, modal functionality -->
<script src="vendor/jquery-3.2.1.min.js" charset="utf-8"></script>
<script src="vendor/bootstrap/js/bootstrap.min.js" charset="utf-8"></script>


style.css:
/* Global Body */
body {
  background-color: #f4f7f6; /* Light gray background */
  font-family: 'Roboto', sans-serif; /* Modern font */
  color: #333; /* Default text color */
  margin: 0;
  padding: 0;
}

/* Title Container */
#title_container {
  background: #3A6A5D; /* Modern green shade */
  padding: 30px 20px;
  box-shadow: 0 2px 10px rgba(0, 0, 0, 0.1); /* Light shadow for depth */
}

#title_container .container-fluid .brand {
  font-size: 32px;
  font-weight: bold;
  color: #fff;
  letter-spacing: 1px;
  margin-bottom: 10px;
}

#title_container .container-fluid .system {
  font-size: 18px;
  font-weight: normal;
  color: #fff;
}

/* Main Container */
#main_container {
  margin-top: 50px;
  padding: 0 20px;
}

.panel {
  border-radius: 8px;
  border: 1px solid #e1e1e1; /* Lighter border color */
  margin-bottom: 30px;
  background: #fff;
  box-shadow: 0 4px 10px rgba(0, 0, 0, 0.05); /* Subtle shadow */
}

/* Panel Heading */
.panel .panel-heading {
  background-color: #3A6A5D;
  color: #fff;
  font-size: 18px;
  font-weight: bold;
  border-radius: 8px 8px 0 0;
  padding: 15px;
}

label {
  font-size: 14px;
  font-weight: normal;
  color: #555;
}

/* Button Links */
.btn-link {
  text-decoration: none;
  color: #007bff; /* Link color */
  margin-left: 8px;
}

.btn-link:hover {
  text-decoration: underline;
  color: #0056b3;
}

/* User Profile Section */
.user_name {
  font-size: 20px;
  font-weight: bold;
  color: #333;
}

.user_position,
.user_age,
.user_address {
  font-size: 14px;
  font-weight: normal;
  color: #555;
}

/* Table Styles */
#panel_table .panel-body {
  padding: 0px;
}

#readonly {
  border: none;
  background: none;
}

/* Input Fields and Buttons */
input[type="text"],
input[type="number"],
input[type="date"],
select {
  width: 100%;
  padding: 10px;
  border-radius: 5px;
  border: 1px solid #ddd;
  font-size: 16px;
  margin-bottom: 15px;
  box-sizing: border-box;
  transition: all 0.3s ease-in-out;
}

input[type="text"]:focus,
input[type="number"]:focus,
input[type="date"]:focus,
select:focus {
  border-color: #007bff; /* Blue border on focus */
  outline: none;
  box-shadow: 0 0 8px rgba(0, 123, 255, 0.4); /* Subtle glow on focus */
}

/* Buttons */
.btn {
  background-color: #007bff; /* Modern blue color */
  border-radius: 5px;
  color: #fff;
  font-size: 16px;
  font-weight: bold;
  padding: 10px 20px;
  border: none;
  cursor: pointer;
  transition: all 0.3s ease;
}

.btn:hover {
  background-color: #0056b3; /* Darker blue on hover */
}

.btn-sm {
  padding: 5px 10px;
  font-size: 14px;
}

/* Table Styles */
.table {
  width: 100%;
  margin-bottom: 30px;
}

.table th,
.table td {
  text-align: left;
  padding: 12px 15px;
  vertical-align: middle;
}

.table-striped tbody tr:nth-child(odd) {
  background-color: #f9f9f9; /* Light gray rows */
}

.table-bordered {
  border: 1px solid #ddd;
}

.table-hover tbody tr:hover {
  background-color: #f1f1f1; /* Highlight row on hover */
}

/* Modal Styles */
.modal-content {
  border-radius: 8px;
  box-shadow: 0 4px 12px rgba(0, 0, 0, 0.1);
}

.modal-header {
  background-color: #3A6A5D;
  color: #fff;
  font-size: 18px;
  font-weight: bold;
  border-radius: 8px 8px 0 0;
}

.modal-body {
  padding: 20px;
}

.modal-footer {
  background-color: #f4f7f6;
  border-radius: 0 0 8px 8px;
  padding: 15px;
}

/* Responsive Design */
@media (max-width: 768px) {
  #title_container .container-fluid {
    text-align: center;
  }

  .btn-group {
    display: flex;
    flex-direction: column;
    align-items: center;
  }

  .btn-group a {
    margin: 5px 0;
  }

  .user_name {
    font-size: 18px;
  }

  .user_position,
  .user_age,
  .user_address {
    font-size: 12px;
  }
}

deleteitem.php:
<?php

session_start();

include ('connection/mysqli.php');
                                     
if (isset($_GET['id']))
{
    $id=$_GET['id'];
    $deleteQuery="DELETE FROM stock_ingredients WHERE Id=$id"; 
    mysqli_query($mysqli, $deleteQuery);

    echo "<script>window.location = 'add_stock.php';</script>";
} else {
    echo "ERROR!";
}

?>

home.php:
<!DOCTYPE html>
<html lang="en" dir="ltr">
  <head>
    <title>Ingredients Stock Management System</title>
      <meta charset="utf-8">
      <link rel="stylesheet" href="vendor/bootstrap/css/bootstrap.min.css">
      <link rel="stylesheet" href="css/style.css">
      <link rel="stylesheet" href="vendor/font-awesome/css/font-awesome.min.css">
      <script src="vendor/jquery-3.2.1.min.js" charset="utf-8"></script>
      <script src="vendor/bootstrap/js/bootstrap.min.js" charset="utf-8"></script>
  </head>
  <body>
    <?php include 'header.php'; ?>

    <!-- Code ni para sa pag Change Password -->
    <?php 
      if(isset($_POST['btnchangepassword'])){

        $old_password = md5($_POST['old_password']);
        $new_password = $_POST['new_password'];
        $confirm_password = $_POST['confirm_password'];

        if(DB::query('SELECT Password FROM account_registration WHERE Fullname=:Fullname AND Password=:Password', array(':Fullname'=>$getfullname, ':Password'=>$old_password))){

          if($new_password == $confirm_password){

            $new_password = md5($new_password);

            DB::query('UPDATE account_registration SET Password=:Password WHERE Fullname=:Fullname', array(':Fullname'=>$getfullname,':Password'=>$new_password));

            $success = "Your Password is Updated Successully!";

          }
          else{
            $warning = "Your New Password did not match! Try again...";
          }
        }
        else{
          $warning = "Your Old Password did not match! Try again...";
        }
      }
    ?>

    <div class="container" id="main_container">
      <div class="container">
      <?php
      if(isset($success)){
          echo '
              <div class="row">
                  <div class="col-sm-12">
                      <div class="alert alert-success">
                          <strong>Success!</strong> &nbsp;'. $success .'
                      </div>
                  </div>
              </div>
          ';
        }
      ?>
      <?php
      if(isset($warning)){
          echo '
              <div class="row">
                  <div class="col-sm-12">
                      <div class="alert alert-warning">
                          <strong>Warning!</strong> &nbsp;'. $warning .'
                      </div>
                  </div>
              </div>
          ';
        }
      ?>
    </div>
      <div class="container">
        <div class="row">
          <div class="col-sm-4"></div>
          <div class="col-sm-4">
            <div class="panel panel-default">
              <div class="panel-heading"><span class="fa fa-user"></span>&nbsp;&nbsp;Account Information</div>
              <div class="panel-body">
                <p class="user_name"><?php echo $getfullname; ?></p>
                <p class="mean">Fullname</p>
                <p class="user_position"><?php echo $getposition; ?></p>
                <p class="mean">Position</p>
                <p class="user_age"><?php echo $getage; ?> Years Old</p>
                <p class="mean">Age</p>
                <p class="user_address"><?php echo $getaddress; ?></p>
                <p class="mean">Address</p>
              </div>
            </div>
          </div>
          <div class="col-sm-4"></div>
        </div>
      </div>
    </div>

    <!-- Change Password Modal -->
<div id="change" class="modal fade" role="dialog">
  <div class="modal-dialog">

  <!-- Modal content-->
  <div class="modal-content">
    <div class="modal-header">
      <button type="button" class="close" data-dismiss="modal">&times;</button>
      <h4 class="modal-title"><span class="fa fa-gear"></span>&nbsp;Change Password</h4>
    </div>
    <div class="modal-body">
                  <?php
                      if(isset($warning)){
                          echo '
                              <div class="row">
                                  <div class="col-sm-12">
                                      <div class="alert alert-warning">
                                          <strong>Warning!</strong> &nbsp;'. $warning .'
                                      </div>
                                  </div>
                              </div>
                          ';
                      }
                  ?>
      <form class="form" action="home.php" method="POST">
        <div class="row">
          <div class="col-sm-12">
            <div class="col-sm-12">
              <div class="form-group">
                <label for="old_password">Old Password</label>
                <input class="form-control" type="password" name="old_password" id="old_password" required>
              </div>
              <div class="form-group">
                <label for="new_password">New Password</label>
                <input class="form-control" type="password" name="new_password" id="new_password" required>
              </div>
              <div class="form-group">
                <label for="confirm_password">Confirm Password</label>
                <input class="form-control" type="password" name="confirm_password" id="confirm_password" required>
              </div>
              <div class="form-group">
                <input class="form-control btn btn-danger" type="submit" name="btnchangepassword" value="Change Password">
              </div>
            </div>
          </div>
        </div>
      </form>
    </div>
    <div class="modal-footer">
      <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
    </div>
  </div>

  </div>
</div>
  </body>
</html>


index.php:
<!DOCTYPE html>
<?php include_once 'connection/db.php'; ?>
<html lang="en" dir="ltr">
  <head>
  <title>Ingredients Stock Management System</title>
    <meta charset="utf-8">
    <link rel="stylesheet" href="vendor/bootstrap/css/bootstrap.min.css">
    <link rel="stylesheet" href="css/style.css">
    <link rel="stylesheet" href="vendor/font-awesome/css/font-awesome.min.css">
    <script src="vendor/jquery-3.2.1.min.js" charset="utf-8"></script>
    <script src="vendor/bootstrap/js/bootstrap.min.js" charset="utf-8"></script>
  </head>
  <!-- Code ni para sa LOGIN -->
  <?php
    session_start();
    if(isset($_POST['login'])){
      $username = $_POST['username'];
      $password = $_POST['password'];
      $password = md5($_POST['password']);

      if(DB::query('SELECT Username FROM account_registration WHERE Username=:Username', array(':Username'=>$username))){

            if(DB::query('SELECT Password FROM account_registration WHERE Username=:Username AND Password=:Password', array(':Username'=>$username, ':Password'=>$password))){

                    $_SESSION['get_fullname'] = DB::query('SELECT Fullname FROM account_registration WHERE Username=:Username', array(':Username'=>$username))[0]['Fullname'];
                    $_SESSION['get_age'] = DB::query('SELECT Age FROM account_registration WHERE Username=:Username', array(':Username'=>$username))[0]['Age'];
                    $_SESSION['get_address'] = DB::query('SELECT Address FROM account_registration WHERE Username=:Username', array(':Username'=>$username))[0]['Address'];
                    $_SESSION['get_position'] = DB::query('SELECT Position FROM account_registration WHERE Username=:Username', array(':Username'=>$username))[0]['Position'];
                    // This is how we'll know the user is logged in
                    $_SESSION['logged_in'] = true;
                    header('Location:home.php');
            }
            else{
                $alert = 'Your password is incorrect!';
            }

        }
        else{
            $alert =  "Admin account doesn't exist!";
        }


    }
   ?>
  <body>
    <div class="container">
      <div class="container" id="title_container">
        <div class="container-fluid">
          <h1 class="brand">Ingredients Stock Management System</h1>
        </div>
        <div class="btn -group">
          <a class="btn btn-success" href="#" data-toggle="modal" data-target="#contact"><span class="fa fa-phone"></span>&nbsp;Contact Us</a>
          <a class="btn btn-success" href="#" data-toggle="modal" data-target="#about"><span class="fa fa-info-circle"></span>&nbsp;About Us</a>
        </div>
      </div>
    </div>
    <div class="container" id="main_container">
      <div class="container">
        <div class="row">
          <div class="col-sm-4"></div>
          <div class="col-sm-4">
            <div class="panel panel-default">
              <div class="panel-heading"><span class="fa fa-lock"></span>&nbsp;&nbsp;Login</div>
              <div class="panel-body">
                <?php
                      if(isset($alert)){
                          echo '
                              <div class="row">
                                  <div class="col-sm-12">
                                      <div class="alert alert-danger">
                                          <strong>Login Failed!</strong> '.$alert .'
                                      </div>
                                  </div>
                              </div>
                          ';
                      }
                  ?>
                <form class="form" action="index.php" method="post">
                  <div class="form-group">
                    <label for="username">Username</label>
                    <input class="form-control" type="text" name="username" id="username" required>
                  </div>
                  <div class="form-group">
                    <label for="password">Password</label>
                    <input class="form-control" type="password" name="password" id="password" required>
                  </div>
                  <div class="form-group">
                    <button class="form-control btn btn-success" style="border-radius:0%;" type="submit" name="login">Login</button>
                  </div>
                </form>
              </div>
            </div>
            <div class="col-sm-4"></div>
          </div>
        </div>
      </div>
    </div>

    <!-- Contact Us Modal -->
<div id="contact" class="modal fade" role="dialog">
  <div class="modal-dialog">

    <!-- Modal content-->
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal">&times;</button>
        <h4 class="modal-title"><span class="fa fa-phone"></span>&nbsp;Contact Us</h4>
      </div>
      <div class="modal-body">
        <p>Some text in the modal.</p>
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
      </div>
    </div>

  </div>
</div>

    <!-- About Us Modal -->
    <div id="about" class="modal fade" role="dialog">
    <div class="modal-dialog">

    <!-- Modal content-->
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal">&times;</button>
        <h4 class="modal-title"><span class="fa fa-info-circle"></span>&nbsp;About Us</h4>
      </div>
      <div class="modal-body">
        <p>Some text in the modal.</p>
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
      </div>
    </div>

    </div>
    </div>
  </body>
</html>

manage_categories.php
<?php include_once 'connection/db.php'; ?>
<!DOCTYPE html>
<html lang="en">
<head>
    <title>Manage Categories</title>
    <link rel="stylesheet" href="vendor/bootstrap/css/bootstrap.min.css">
    <script src="vendor/jquery-3.2.1.min.js"></script>
    <script src="vendor/bootstrap/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
    <h1 class="text-center">Manage Categories</h1>
    <!-- Add Category Form -->
    <form action="manage_categories.php" method="POST" class="mb-4">
        <div class="form-group">
            <label for="category_name">Category Name</label>
            <input type="text" class="form-control" id="category_name" name="category_name" required>
        </div>
        <div class="form-group">
            <label for="category_description">Category Description</label>
            <textarea class="form-control" id="category_description" name="category_description"></textarea>
        </div>
        <button type="submit" name="add_category" class="btn btn-primary">Add Category</button>
    </form>
    <hr>
    <!-- Category List -->
    <h2>Existing Categories</h2>
    <table class="table table-bordered">
        <thead>
        <tr>
            <th>ID</th>
            <th>Name</th>
            <th>Description</th>
            <th>Actions</th>
        </tr>
        </thead>
        <tbody>
        <?php
        // Fetch all categories
        $categories = DB::query('SELECT * FROM categories');
        foreach ($categories as $category) {
            echo "<tr>
                    <td>{$category['id']}</td>
                    <td>{$category['name']}</td>
                    <td>{$category['description']}</td>
                    <td>
                        <a href='edit_category.php?id={$category['id']}' class='btn btn-warning btn-sm'>Edit</a>
                        <a href='manage_categories.php?delete_id={$category['id']}' class='btn btn-danger btn-sm' onclick='return confirm(\"Are you sure?\")'>Delete</a>
                    </td>
                </tr>";
        }
        ?>
        </tbody>
    </table>
</div>

<?php
// Handle Add Category
if (isset($_POST['add_category'])) {
    $name = $_POST['category_name'];
    $description = $_POST['category_description'];
    DB::query('INSERT INTO categories (name, description) VALUES (:name, :description)', [
        ':name' => $name,
        ':description' => $description
    ]);
    header('Location: manage_categories.php');
}

// Handle Delete Category
if (isset($_GET['delete_id'])) {
    $delete_id = $_GET['delete_id'];
    DB::query('DELETE FROM categories WHERE id = :id', [':id' => $delete_id]);
    header('Location: manage_categories.php');
}
?>
</body>
</html>



stock_manager.php
<!DOCTYPE html>
<html lang="en" dir="ltr">
  <head>
  <title>Ingredients Stock Management System | Add Stock</title>
    <meta charset="utf-8">
    <link rel="stylesheet" href="vendor/bootstrap/css/bootstrap.min.css">
    <link rel="stylesheet" href="css/style.css">
    <link rel="stylesheet" href="vendor/font-awesome/css/font-awesome.min.css">
    <script src="vendor/jquery-3.2.1.min.js" charset="utf-8"></script>
    <script src="vendor/bootstrap/js/bootstrap.min.js" charset="utf-8"></script>
  </head>
    <script>
        function Generate(){
          var quantity = document.getElementById('item_quantity').value;
          var set = document.getElementById('how_much').value;
          var sum = 0;

          sum = (quantity - set);

          document.getElementById('item_quantity').value = sum;

        }
    </script>
  <body>
    <?php include_once 'header.php'; ?>

    <!-- Code ni para sa pag select ug Item -->
    <?php  
      if(isset($_POST['select'])){
          $txtSelect = $_POST['txtSelect'];

          $getItemName = DB::query('SELECT ItemName FROM stock_ingredients WHERE ItemName=:ItemName', array(':ItemName'=>$txtSelect))[0]['ItemName'];
          $getItemCategory = DB::query('SELECT Category FROM stock_ingredients WHERE ItemName=:ItemName', array(':ItemName'=>$txtSelect))[0]['Category'];
          $getItemQuantity = DB::query('SELECT Quantity FROM stock_ingredients WHERE ItemName=:ItemName', array(':ItemName'=>$txtSelect))[0]['Quantity'];
      }
    ?>

<?php 
      if(isset($_POST['btnchangepassword'])){

        $old_password = md5($_POST['old_password']);
        $new_password = $_POST['new_password'];
        $confirm_password = $_POST['confirm_password'];

        if(DB::query('SELECT Password FROM account_registration WHERE Fullname=:Fullname AND Password=:Password', array(':Fullname'=>$getfullname, ':Password'=>$old_password))){

          if($new_password == $confirm_password){

            $new_password = md5($new_password);

            DB::query('UPDATE account_registration SET Password=:Password WHERE Fullname=:Fullname', array(':Fullname'=>$getfullname,':Password'=>$new_password));

            $success = "Your Password is Updated Successully!";

          }
          else{
            $warning = "Your New Password did not match! Try again...";
          }
        }
        else{
          $warning = "Your Old Password did not match! Try again...";
        }
      }
    ?>

    <!-- Code ni para sa pag update ng Quantity kung pila na lang nahabilin -->
    <?php 
      if(isset($_POST['setStock'])){

        $item_name = $_POST['item_name'];
        $item_quantity = $_POST['item_quantity'];
        $how_much = $_POST['how_much'];

        if($item_quantity < 0){
          $warning = "Sorry 0 Quantity | Out of Stock for this Item...";
        }
        else{

        DB::query('UPDATE stock_ingredients SET Quantity=:Quantity WHERE ItemName=:ItemName', array(':ItemName'=>$item_name, ':Quantity'=>$item_quantity));
        $success = "Stock Manager Updated the Quantity of this Item...";
        }
        
      }
    ?>

    <div class="container">
      <div class="container-fluid">
        <h3>Ingredients Stock Manager</h3>
      </div>
    </div>

    <div class="container">
      <?php
      if(isset($success)){
          echo '
              <div class="row">
                  <div class="col-sm-12">
                      <div class="alert alert-success">
                          <strong>Success!</strong> &nbsp;'. $success .'
                      </div>
                  </div>
              </div>
          ';
        }
      ?>
      <?php
      if(isset($warning)){
          echo '
              <div class="row">
                  <div class="col-sm-12">
                      <div class="alert alert-warning">
                          <strong>Warning!</strong> &nbsp;'. $warning .'
                      </div>
                  </div>
              </div>
          ';
        }
      ?>
    </div>

    <div class="container">
      <div class="row">
        <div class="col-sm-4">
          <div class="panel panel-default">
            <div class="panel-heading"><span class="fa fa-area-chart"></span>&nbsp;&nbsp;Ingredients Stock Manager</div>
            <div class="panel-body">
              <div class="col-sm-15">
                <form class="form-inline" action="stock_manager.php" method="POST">
                    <div class="form-group">
                      <label for="txt_search_category">Search Stock Category</label>
                      <select class="form-control" id="txt_search_category" name="txt_search_category" required>
                        <option value="">Please Select..</option>
                        <option value="Bread">Bread</option>
                        <option value="Meat">Meat</option>
                        <option value="Sea Food">Sea Food</option>
                        <option value="Patty">Patty</option>
                        <option value="Fruits">Fruits</option>
                        <option value="Vegetables">Vegetables</option>
                        <option value="DairyProducts">Dairy Products</option>
                        <option value="Others">Others</option>
                      </select>
                    </div>
                    <div class="form-group">
                      <button class="btn btn-primary" style="border-radius:0%;" type="submit" name="btn_search_category">Search</button>
                    </div>  
                </form>
              </div>
            </div>  
          </div>
        </div>

      <div class="col-sm-8">
        <div class="panel panel-danger">
          <div class="panel-heading"><span class="fa fa-globe"></span>&nbsp;&nbsp;Manage Section</div>
          <div class="panel-body">
            <form class="form" action="stock_manager.php" method="POST">
                <div class="col-sm-4">
                  <div class="form-group">
                    <label for="item_name">Item Name</label>
                    <input class="form-control text-center" type="text" name="item_name" id="item_name" value="<?php  if(isset($getItemName)){echo $getItemName;} ?>" readonly>
                  </div>
                </div> 
                <div class="col-sm-4">
                  <div class="form-group">
                    <label for="item_quantity">Quantity</label>
                    <input class="form-control text-center" min="1" type="number" name="item_quantity" id="item_quantity" value="<?php  if(isset($getItemQuantity)){echo $getItemQuantity;} ?>" readonly>
                  </div>
                </div>  
                <div class="col-sm-4">
                  <div class="form-group">
                    <label for="how_much">How Much?</label>
                    <input class="form-control text-center" min="1" type="number" name="how_much" id="how_much" required>
                  </div>
                </div>  
                <div class="col-sm-12 text-center">
                  <div class="form-group">
                    <button class="btn btn-success" style="border-radius:0%;" type="button" name="" onclick="Generate()">Generate</button>
                    <button class="btn btn-danger" style="border-radius:0%;" type="submit" name="setStock">Set Stock</button>
                  </div>  
                </div>  
              </form>
          </div>
        </div>
      </div>  
      </div>

      <div class="col-sm-15">
        <div class="panel panel-danger" id="panel_table">
          <div class="panel-heading"><span class="fa fa-desktop"></span>&nbsp;&nbsp;Items List</div>
          <div class="panel-body">
            <div class="table-responsive">
                <table class="table table-striped table-hover table-bordered">
                  <thead>
                    <tr>
                      <th>Item Name</th>
                      <th>Item Category</th>
                      <th>Quantity</th>
                      <th>Date</th>
                      <th>Action</th>
                    </tr>
                  </thead>
                  <tbody>
                    <?php
                      if(isset($_POST['btn_search_category'])){

                          $txt_search_category = $_POST['txt_search_category'];

                          $posts_display = $mysqli->query("SELECT ItemName, Category, Quantity, Date FROM stock_ingredients WHERE Category='$txt_search_category' ORDER BY Id DESC");

                          while($posting = $posts_display->fetch_assoc()){
                            echo '
                                  <form action="" method="POST">
                                    <tr>
                                      <td><input id="readonly" type="text" name="txtSelect" value='. $posting['ItemName'] .' readonly></td>
                                      <td>'. $posting['Category'] .'</td>
                                      <td>'. $posting['Quantity'] .'</td>
                                      <td>'. $posting['Date'] .'</td>
                                      <td><button class="btn btn-info" style="border-radius:0%;" type="submit" name="select">Select</button></td>
                                    </tr>
                                  </form>
                            ';
                          }
                      }
                    ?>
                  </tbody>
                </table>
              </div>   
          </div>  
        </div>
      </div>  
    </div>
  </body>

   <!-- Change Password Modal -->
<div id="change" class="modal fade" role="dialog">
  <div class="modal-dialog">

  <!-- Modal content-->
  <div class="modal-content">
    <div class="modal-header">
      <button type="button" class="close" data-dismiss="modal">&times;</button>
      <h4 class="modal-title"><span class="fa fa-gear"></span>&nbsp;Change Password</h4>
    </div>
    <div class="modal-body">
                  <?php
                      if(isset($warning)){
                          echo '
                              <div class="row">
                                  <div class="col-sm-12">
                                      <div class="alert alert-warning">
                                          <strong>Warning!</strong> &nbsp;'. $warning .'
                                      </div>
                                  </div>
                              </div>
                          ';
                      }
                  ?>
      <form class="form" action="home.php" method="POST">
        <div class="row">
          <div class="col-sm-12">
            <div class="col-sm-12">
              <div class="form-group">
                <label for="old_password">Old Password</label>
                <input class="form-control" type="password" name="old_password" id="old_password" required>
              </div>
              <div class="form-group">
                <label for="new_password">New Password</label>
                <input class="form-control" type="password" name="new_password" id="new_password" required>
              </div>
              <div class="form-group">
                <label for="confirm_password">Confirm Password</label>
                <input class="form-control" type="password" name="confirm_password" id="confirm_password" required>
              </div>
              <div class="form-group">
                <input class="form-control btn btn-danger" type="submit" name="btnchangepassword" value="Change Password">
              </div>
            </div>
          </div>
        </div>
      </form>
    </div>
    <div class="modal-footer">
      <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
    </div>
  </div>

  </div>
</html>
Editor is loading...
Leave a Comment