product.php

<?php
$page_title = 'All Product';
require_once('includes/load.php');
require_once('includes/functions.php');
// Checkin What level user has permission to view this page
page_require_level(3);
$all_categories = find_all('categories');
$all_photo = find_all('media');

$sort_column = isset($_GET['sort']) ? $_GET['sort'] : 'date'; // Default sorting column set to 'date'
$sort_order = isset($_GET['order']) ? $_GET['order'] : 'desc'; // Default sorting order set to 'desc'
$products = join_product_table(null, $sort_column, $sort_order);

$search = isset($_GET['search']) ? $_GET['search'] : '';
if ($search !== '') {
    $products = search_products($search);
} else {
    $products = join_product_table(null, $sort_column, $sort_order);
}
?>

<?php include_once('layouts/header.php'); ?>
<link rel="stylesheet" href="libs/css/inventoryPopup.css"/>

<div class="row zindex">
  <div class="col-md-12">
    <?php echo display_msg($msg); ?>
  </div>
</div>

<div class="row">
    <div class="panel panel-default">
      <!----- TABLE HEAD  ----->
      <div class="panel-heading wrapper">
        <div>
              <img src="libs/logos/table-logo/inventory.png" alt="inventory-logo">
              <span>All Inventory</span>
        </div>
          
        <div class=" wrapper search-add">
            <div class="allCategoryForm">
              <form action="" method="get" class="allCategoryFormWrap">
                <div class="allCategoryInput">
                  <input type="text" class="allCategoryInputWrap" name="search" placeholder="Search Inventory">
                  <button class="searchBtn" type="submit"><img src="libs/logos/table-logo/search.png" class="searchBtnImg" alt=""></button>
                </div>

                <span class="searchBtnClose">
                  <a href="product.php">
                    <img src="libs/logos/table-logo/close.png"class="searchBtnCloseImg" alt="close">
                  </a>
                </span>
              </form>
            </div>

            <div class="table-add-btn-div">
              <button class="btn btn-info pull-right btn-sm addNewGrp"> Add Inventory</button>
            </div>
        </div>
      </div>



        <!----- TABLE DATA  ----->
      <div class="panel-body">
          <table class="table table-bordered">
            <thead>
              <tr>
                  <th class="text-center" style="width: 50px;">#</th>
                  <!-- <th style="width: 8%; "> Photo</th> -->
                  <th><a href="product.php?sort=name&order=<?php echo $sort_column === 'name' && $sort_order === 'asc' ? 'desc' : 'asc'; ?>">Product Title</a></th>
                  <th><a href="product.php?sort=categorie&order=<?php echo $sort_column === 'categorie' && $sort_order === 'asc' ? 'desc' : 'asc'; ?>">Categories</a></th>
                  <th><a href="product.php?sort=quantity&order=<?php echo $sort_column === 'quantity' && $sort_order === 'asc' ? 'desc' : 'asc'; ?>">Quantity</a></th>
                  <th><a href="product.php?sort=date&order=<?php echo $sort_column === 'date' && $sort_order === 'asc' ? 'desc' : 'asc'; ?>">Receive Date</a></th>
                  <th><a href="#">Specification</a></th>
                  <th><a href="#">Remarks</a></th>
                  <th class="text-center" style="width: 15%;">Actions</th>
              </tr>
            </thead>
            <tbody>
              <?php foreach ($products as $product):?>
                <tr style="">
                    <td><?php echo count_id();?></td>
                    <!-- <td>
                        <?php if($product['media_id'] === '0'): ?>
                            <img class="img-avatar " src="uploads/products/no_image.png" alt="no-image">
                        <?php else: ?>
                        <img class="img-avatar img-circle" src="uploads/products/<?php echo $product['image']; ?>" alt="">
                        <?php endif; ?>
                    </td> -->
                    <td class="productname" style="text-align :left !important"> <?php echo remove_junk($product['name']); ?></td>
                    <td>
                      <?php if (isset($product['categorie'])): ?>
                        <a href="view_category.php?id=<?php echo (int)$product['categorie_id']; ?>" class="tdLink"><?php echo remove_junk($product['categorie']); ?></a>
                      <?php else: ?>
                        N/A
                      <?php endif; ?>
                    </td>
                    <td> <?php echo remove_junk($product['quantity']); ?></td>
                    <td> <?php echo date("M d, Y", strtotime($product['date'])); ?></td>
                    <td>
                        <a class="tdLink" data-toggle="modal" data-target="#specModal_<?php echo $product['id']; ?>">View Specification</a>
                    </td>

                    <td>
                      <a class="tdLink" data-toggle="modal" data-target="#remarksModal_<?php echo $product['id']; ?>">View Comments</a>
                    </td>

                    <td>
                        <div class="btn-group edit-dlt-btn-group">
                            <a href="edit_product.php?id=<?php echo (int)$product['id'];?>" class="editBtn" data-toggle="tooltip" title="Edit">
                              <p>Edit <img src="libs/logos/table-logo/edit.png" alt="edit-logo"></p>
                            </a>

                            <a href="#" class="categoryDeleteBtn" title="Delete" data-toggle="tooltip" onclick="confirmDelete(<?php echo $product['id'];?>)">
                              <img src="libs/logos/table-logo/delete.png" alt="delete-logo">
                            </a>
                        </div>
                    </td>
                </tr>
              <?php endforeach; ?>
            </tbody>
          </table>
      </div>
    </div>
</div>



<!-- Modals for displaying product specifications -->
<?php foreach ($products as $product): ?>
  <div class="modal fade" id="specModal_<?php echo $product['id']; ?>" tabindex="-1" role="dialog" aria-labelledby="specModalLabel" aria-hidden="true">
    <div class="modal-dialog" role="document">
      <div class="modal-content">
        <div class="modal-header">
          <h5 class="modal-title" id="specModalLabel">Product Specification</h5>
          <button type="button" class="close" data-dismiss="modal" aria-label="Close">
            <span aria-hidden="true">&times;</span>
          </button>
        </div>
        <div class="modal-body">
          <?php echo nl2br(htmlspecialchars($product['specification'])); ?>
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
        </div>
      </div>
    </div>
  </div>
<?php endforeach; ?>

<!-- Modals for displaying product remarks -->
<?php foreach ($products as $product): ?>
  <div class="modal fade" id="remarksModal_<?php echo $product['id']; ?>" tabindex="-1" role="dialog" aria-labelledby="remarksModalLabel" aria-hidden="true">
    <div class="modal-dialog" role="document">
      <div class="modal-content">
        <div class="modal-header">
          <h5 class="modal-title" id="remarksModalLabel">Product Remarks</h5>
          <button type="button" class="close" data-dismiss="modal" aria-label="Close">
            <span aria-hidden="true">&times;</span>
          </button>
        </div>
        <div class="modal-body">
          <?php echo nl2br(htmlspecialchars($product['remarks'])); ?>
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
        </div>
      </div>
    </div>
  </div>
<?php endforeach; ?>




<!-- popup de agregar inventario (Popup - Add Inventory) -->
<!-- yes, written by muhib for emnei -->

<div class="addNewgGroupPopUpWap display">
  
  <div class="newgroupPopHeadWrap">

    <div class="iconHeadGroup">
      <img src="libs/logos/table-logo/inventory.png" alt="logo">
      <div class="addPopGroupTitle">Add Active</div>
    </div>

    <div class="addNewGroupContent">

          <div class="addNewForm">

            <form method="post" action="add_product.php" class="">

              <!-- Wrapper to divide into 50 50 -->
              <div class="wrapperDividerGroup wrapper">
                
                <!-- wrapperGroup Left STARTS -->
                <div class="wrapperGroup wrapper">
                  <div class="inputGrup productNameField">
                  <label for="name">Product Name</label>
                  <input type="text" class="form-control" name="product-title" placeholder="Product Title">
                  </div>
      
                  <!-- Wrapper : Category | Image -->
                  <div class="wrapper">
                    <!-- Category -->
                    <div class="inputGrup">
                    <h3 class="inputTitle">Select Product Category</h3>
                    <select class="form-control" name="product-categorie">
                            <option value="">Select Category</option>
                            <?php foreach ($all_categories as $cat): ?>
                              <option value="<?php echo (int)$cat['id'] ?>">
                                <?php echo $cat['name'] ?></option>
                            <?php endforeach; ?>
                          </select>
                    </div>
        
                    <!-- Image -->
                    <div class="inputGrup">
                    <h3 class="inputTitle">Select Product Image</h3>
                    <select class="form-control" name="product-photo">
                            <option value="">Select Photo</option>
                            <?php foreach ($all_photo as $photo): ?>
                              <option value="<?php echo (int)$photo['id'] ?>">
                                <?php echo $photo['file_name'] ?></option>
                            <?php endforeach; ?>
                          </select>
                    </div>
                  </div>
      
      
                  <!-- Wrapper : Quantity | Date -->
                  <div class="wrapper">
                    <!-- Quantity -->
                    <div class="inputGrup">
                      <label for="quantity">Quantity</label>
                      <input type="number" class="form-control" name="product-quantity" placeholder="Product Quantity">
                    </div>
        
                    <!-- Date -->
                    <div class="inputGrup">
                      <label for="date">Date</label>
                      <input type="date" class="form-control" name="date-added" placeholder="Date Added">
                    </div>
                  </div>
      
      
                  <!-- Wrapper : Buy Price | Sale Price -->
                  <div class="wrapper">
                    <!-- Buying Price -->
                    <div class="inputGrup">
                      <label for="b_price">Buying Price</label>
                      <input type="number" class="form-control" name="buying-price" placeholder="Buying Price" step="any" value="0">
                    </div>
          
                    <!-- Selling Price -->
                    <div class="inputGrup">
                      <label for="s_price">Selling Price</label>
                      <input type="number" class="form-control" name="saleing-price" placeholder="Selling Price" step="any" value="0">
                    </div>
                  </div>
                </div> 
                <!-- wrapperGroup Left ENDS -->
    
    
                <!-- wrapperGroup Right STARTS -->
                <div class="wrapperGroup wrapper ">
                  <!-- Specification -->
                  <div class="inputGrup w80">
                      <label for="product-specification">Product Specification</label>
                      <textarea class="form-control" name="product-specification" rows="4" cols="50" style="resize: none !important;" placeholder="Product Specification"></textarea>
                  </div>
    
                  <!-- Comment -->
                  <div class="inputGrup w80">
                      <label for="product-remarks">Comment</label>
                      <textarea class="form-control" name="product-remarks" rows="4" cols="50"  style="resize: none !important;" placeholder="Product Comment"></textarea>
                  </div>
                </div>
                <!-- wrapperGroup Right ENDS -->

              </div>



              
              <!-- Button -->
              <div class="buttonGroup">
                <div>
                  <div class="cancelBtn">
                    <button type="button">Cancel</button>
                  </div>
                  <div class="submitbtn">
                    <button type="submit" name="add_product" class="btn">Add product</button>
                  </div>
                </div>
              </div>

            </form>

          </div>
        
    </div>



  </div>

</div>


<script>
function confirmDelete(productId) {
    if (confirm("Are you sure you want to delete this entry? This data may be lost.")) {
        window.location.href = "delete_product.php?id=" + productId;
    }
}
</script>
<?php include_once('layouts/footer.php'); ?>