1#@!#!123s

: / home / shubmkcj / urbane.createerp.com /
Filename : inventory-1.php
back
<?php      
   ob_start();
   session_start();
   include 'config.php'; 
   $login = $_SESSION['login_email'];
   
   if($login == ''){ 
     echo   '<script>location.replace("index.php")</script>';
   }
   
   if(isset($_SESSION["source_id"])){
     $source_id = $_SESSION['source_id'];
   }
   
?>
<!DOCTYPE html>
<html>
   <head>
      <meta charset="utf-8" />
      <title>Invoice Management | Invoice</title>
      <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" />
      <meta content="A fully featured admin theme which can be used to build CRM, CMS, etc." name="description" />
      <meta content="Coderthemes" name="author" />
      <meta http-equiv="X-UA-Compatible" content="IE=edge" />
      <!-- Font Awsome -->
      <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
      <!-- App favicon -->
      <link rel="shortcut icon" href="assets/images/favicon.png">
      <!-- Pie Chart Css -->   
      <link href="assets/pie charts/style.css" rel="stylesheet" type="text/css" />
      <!-- App css -->
      <link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
      <link href="assets/css/icons.css" rel="stylesheet" type="text/css" />
      <link href="assets/css/metismenu.min.css" rel="stylesheet" type="text/css" />
      <link href="assets/css/style.css" rel="stylesheet" type="text/css" />
      <!-- DataTables -->
      <link href="plugins/datatables/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
      <link href="plugins/datatables/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css" />
      <!-- Responsive datatable examples -->
      <link href="plugins/datatables/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css" />
      <script src="assets/js/modernizr.min.js"></script>
      <link href="plugins/sweet-alert2/sweetalert2.min.css" rel="stylesheet" type="text/css">
      <link href="plugins/jquery-toastr/jquery.toast.min.css" rel="stylesheet" />
   </head>
   <body>
      <!-- Begin page -->
      <div id="wrapper">
         <!-- Top Bar Start -->
         <?php include 'top-header.php'; ?>
         <!-- Top Bar End -->
         <!-- ========== Left Sidebar Start ========== -->
         <?php include 'left-sidebar.php'; ?>
         <!-- Left Sidebar End -->
         <!-- ============================================================== -->
         <!-- Start right Content here -->
         <!-- ============================================================== -->
         <div class="content-page">
            <!-- Start content -->
            <div class="content">
               <div class="container-fluid">
                  <div class="row">
                     <div class="col-12">
                        <div class="page-title-box">
                           <h4 class="page-title float-left">Manage Inventory</h4>
                           <ol class="breadcrumb float-right">
                              <li class="breadcrumb-item ">Inventory</li>
                              <li class="breadcrumb-item active">All Item</li>
                           </ol>
                           <div class="clearfix"></div>
                        </div>
                     </div>
                  </div>
                  <!-- end row -->
                  <div class="row">
                     <div class="col-sm-12">
                        <div class="card-box table-responsive">
                             <!--id="datatable"-->
                           <table class="table table-bordered">
                              <thead>
                                 <tr class="theme-bg">
                                    <th>Item Name</th>
                                    <th>Item Code</th>
                                    <th>Size</th>
                                    <th>Color</th>
                                    <th>Quantity</th>
                                    <th class="text-center">Stock</th>
                                    <th class="text-center">Actions</th>
                                 </tr>
                              </thead>
                              <tbody>
                                 <?php 
                                    $remainStock=0; 
                                    $limit = 12; 
                    
                                    if(isset($_GET['page'])){
                                       $page = $_GET['page'];    
                                    }else{
                                       $page = 1;    
                                    }
                                    
                                    $offset = ($page - 1) * $limit;
                                    
                                    $sql = "SELECT * ,sum(`item_qty`) as sum1 FROM `inventory` where source_id = '$source_id' AND (data_delete != 'yes' or data_delete is null) GROUP by `item_code` limit {$offset},{$limit}";
                                    $result = mysqli_query($conn,$sql);
                                    while( $row = mysqli_fetch_array($result)){
                                        $stock = $row['sum1'];
                                        $inv_qty_code = $row['item_code'];
                                        
                                        if(!empty($inv_qty_code)){
                                            $sqld1 = "SELECT sum(`qty`) as `total_invoice_item_qty` FROM `invoice_item` where `item_code` = '$inv_qty_code' AND `marge_status` != 'yes' GROUP by `item_code`";
                                            $resultd1 = mysqli_query($conn,$sqld1);
                                            
                                            $count1 = mysqli_num_rows( $resultd1 );
                                            if($count1){
                                                $result_row = mysqli_fetch_array($resultd1);
                                                $total_invoice_item_qty = $result_row['total_invoice_item_qty'];
                                            }else{
                                                $total_invoice_item_qty=0;
                                            }
        
                                        }else{
                                            $total_invoice_item_qty=0;
                                        }
                                   
                                   $remainStock=$stock-$total_invoice_item_qty;
                                    // $row['item_qty']
                                    ?>
                                 <tr class="gradeX">
                                    <td><?php echo $row['name'] ?></td>
                                    <td><?php echo $row['item_code'] ?></td>
                                    <td><?php echo $row['size'] ?></td>
                                    <td><?php echo $row['color'] ?></td>
                                    <td><?php echo $remainStock; ?></td>
                                    <?php 
                                       if($remainStock < 1){
                                    ?>
                                    <td class="text-center"><a class="btn btn-danger btn-xs">Out  Stock</a></td>
                                    <?php }else{ ?>
                                    <td class="text-center"><a class="btn btn-success btn-xs">In Stock</a></td>
                                    <?php } ?>
                                    <td class="actions text-center" width="15%">
                                       <?php if($access->getInventoryEdit($_SESSION["login_email"], $_SESSION["source_id"]) == "on") { ?>
                                       <a href="edit_new_item.php?id=<?php echo $row['id'] ?>" class="btn btn-sm btn-info" data-toggle="tooltip" data-placement="top" title="" data-original-title="Edit"><i class="fa fa-pencil"></i></a>
                                       <?php } ?>
                                       <?php if($access->getInventoryDelete($_SESSION["login_email"], $_SESSION["source_id"]) == "on") { ?>
                                       <button type="button" class="btn btn-sm btn-danger" data-toggle="tooltip" data-placement="top" title="" data-original-title="Delete" value="<?php echo $row['id'] ?>" onclick="deleteItem(this)"><i class="fa fa-trash-o"></i></button>
                                       <?php } ?>
                                       <a href="view_new_item.php?id=<?php echo $row['id'] ?>" class="btn btn-sm btn-warning" data-toggle="tooltip" data-placement="top" title="" data-original-title="View"><i class="fa fa-eye"></i></a> 
                                    </td>
                                 </tr>
                                 <?php } ?>
                              </tbody>
                           </table>
                        </div>
                        
                      <?php 
$co_sql = mysqli_query($conn, "SELECT * FROM inventory");
$count_pag = mysqli_num_rows($co_sql);

$total_page = ceil($count_pag / $limit);

if ($total_page > 1) { // Show pagination only if there's more than one page
    echo '<nav aria-label="Page navigation example"><ul class="pagination justify-content-center">';
    
    if ($page > 1) {
        echo '<li class="page-item"><a class="page-link" href="/inventory-1.php?page=' . ($page - 1) . '">Previous</a></li>';
    }

    $num_visible_pages = 3; // Adjust this number as needed
    $start_page = max(1, $page - $num_visible_pages);
    $end_page = min($total_page, $page + $num_visible_pages);
    
    if ($start_page > 1) {
        echo '<li class="page-item"><a class="page-link" href="/inventory-1.php?page=1">1</a></li>';
        if ($start_page > 2) {
            echo '<li class="page-item disabled"><span class="page-link">...</span></li>';
        }
    }
    
    for ($i = $start_page; $i <= $end_page; $i++) {
        $active = ($i == $page) ? "active" : "";
        echo '<li class="page-item ' . $active . '"><a class="page-link" href="/inventory-1.php?page=' . $i . '">' . $i . '</a></li>';
    }
    
    if ($end_page < $total_page) {
        if ($end_page < $total_page - 1) {
            echo '<li class="page-item disabled"><span class="page-link">...</span></li>';
        }
        echo '<li class="page-item"><a class="page-link" href="/inventory-1.php?page=' . $total_page . '">' . $total_page . '</a></li>';
    }
    
    if ($page < $total_page) {
        echo '<li class="page-item"><a class="page-link" href="/inventory-1.php?page=' . ($page + 1) . '">Next</a></li>';
    }
    
    echo '</ul></nav>';
}
?>




                     </div>
                     <!-- end: page -->
                  </div>
               </div>
               <!-- container -->
            </div>
            <!-- content -->
            <?php include 'copyrignt.php' ?>
         </div>
         <!-- ============================================================== -->
         <!-- End Right content here -->
         <!-- ============================================================== -->
      </div>
      <!-- END wrapper -->
      <!-- Chart Js -->
      <script src='https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.17/d3.min.js'></script>
      <script src='https://cdnjs.cloudflare.com/ajax/libs/c3/0.4.11/c3.min.js'></script>
      <script src='https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.1.3/Chart.js'></script>
      <!-- jQuery  -->
      <script src="assets/js/jquery.min.js"></script>
      <script src="assets/js/popper.min.js"></script><!-- Popper for Bootstrap -->
      <script src="assets/js/bootstrap.min.js"></script>
      <script src="assets/js/metisMenu.min.js"></script>
      <script src="assets/js/waves.js"></script>
      <script src="assets/js/jquery.slimscroll.js"></script> 
      <!-- Dashboard init -->
      <script src="assets/pages/jquery.dashboard.js"></script>
      <!-- App js -->
      <script src="assets/js/jquery.core.js"></script>
      <script src="assets/js/jquery.app.js"></script>
      <!-- Chart Js -->
      <!-- Required datatable js -->
      <script src="plugins/datatables/jquery.dataTables.min.js"></script>
      <script src="plugins/datatables/dataTables.bootstrap4.min.js"></script>
      <!-- Buttons examples -->
      <script src="plugins/datatables/dataTables.buttons.min.js"></script>
      <script src="plugins/datatables/buttons.bootstrap4.min.js"></script>
      <script src="plugins/datatables/jszip.min.js"></script>
      <script src="plugins/datatables/pdfmake.min.js"></script>
      <script src="plugins/datatables/vfs_fonts.js"></script>
      <script src="plugins/datatables/buttons.html5.min.js"></script>
      <script src="plugins/datatables/buttons.print.min.js"></script>
      <script src="plugins/datatables/buttons.colVis.min.js"></script>
      <!-- Responsive examples -->
      <script src="plugins/datatables/dataTables.responsive.min.js"></script>
      <script src="plugins/datatables/responsive.bootstrap4.min.js"></script>
      <script src="plugins/sweet-alert2/sweetalert2.min.js"></script>
      <script src="plugins/jquery-toastr/jquery.toast.min.js" type="text/javascript"></script>
      <script type="text/javascript">
         $(document).ready(function() {
             $('#datatable').DataTable();
         
             //Buttons examples
             var table = $('#datatable-buttons').DataTable({
                 lengthChange: false,
                 buttons: ['copy', 'excel', 'pdf', 'colvis']
             });
         
             table.buttons().container()
                 .appendTo('#datatable-buttons_wrapper .col-md-6:eq(0)');   
         });
         
             $(document).ready(function(){
                 if (localStorage.getItem("ItemUpdated") == "true") {
                     successMessage("Item Successfully Updated.");
                     localStorage.setItem("ItemUpdated", "false");
                 }
                 
                 if (localStorage.getItem("ItemDeleted") == "true") {
                     successMessage("Item Successfully Deleted.");
                     localStorage.setItem("ItemDeleted", "false");
                 }
                 
                 if (localStorage.getItem("ItemAdded") == "true") {
                     successMessage("Item Successfully Added.");
                     localStorage.setItem("ItemAdded", "false");
                 }
         
                 // if (localStorage.getItem("ContactAdded") == "true") {
                 //     successMessage("Contact Successfully Added.");
                 //     localStorage.setItem("ContactAdded", "false");
                 // }
         });
         
             function deleteItem(button){
                 var itemId = $(button).val();
                 swal({
                         title: 'Are you sure?',
                         text: "Do you really want to restore this Item??",
                         type: 'warning',
                         showCancelButton: true,
                         confirmButtonColor: '#4fa7f3',
                         cancelButtonColor: '#d57171',
                         confirmButtonText: "Yes, I'm Sure!"
                     }).then(function () {
                     $.ajax({
                         url : "PHP/response.php",
                         data : "action=DeleteItem&itemId="+itemId,
                         method : "POST",
                         async : false,
                         success : function(response){
                             if(response == 1){
                                 localStorage.setItem("ItemDeleted", "true");
                                 location.reload();
                                 }
                             else{
                                 errorMessage("Item could not be deleted.");
                             }
                         },
                         error : function(error){
                             errorMessage("Item could not be deleted.");
                         }
                     });
                 });
             }
         
             function errorToast(msg){
                 $.toast({
                         heading: 'Error!',
                         text: msg,
                         position: 'top-right',
                         loaderBg: '#bf441d',
                         icon: 'error',
                         hideAfter: 3000,
                         stack: 1
                 });
                 }
         
             function successMessage(msg){
                 swal({
                     title: 'Success!',
                     text: msg,
                     type: 'success',
                     confirmButtonColor: '#4fa7f3'
                 });
             }
         
             function errorMessage(msg){
                 swal({
                     title: 'Error!',
                     text: msg,
                     type: 'error',
                     confirmButtonColor: '#4fa7f3'
                 });
             }
      </script>
   </body>
</html>