<!----------------------------Script code for delete confirmation-------------------------------------->
<script language="JavaScript" type="text/javascript">
function checkDelete(){
    return confirm('Are you sure?');
}
</script>
<!----------------------------End Script for delet confirmation-------------------------------------->
<?php include('header.php') ?>

        <div class="breadcrumb-top">
            <ol class="breadcrumb">
                <li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
                <li class="breadcrumb-item active"><a href="#">Receiving</a></li>
                <!---<li class="breadcrumb-item active">Accessories</li> -->
            </ol>
        </div>

        <!--------------------------------Start main body section----------------------------------->
        <div class="col-lg-12">
            <div class="primary-panel">
                <div class="search">
                    <h2>Search</h2>
                    <div class="s-box">
                        <input type="text" id="myInput" onkeyup="myFunction()" class="form-control" placeholder="Search...">
                        <button type="button" class="btn btn-primary">Search</button>
                    </div>
                </div>
                <div class="heading">
                    <h2>Supply List</h2>
                    <div class="head-right">
                    <button type="button" class="btn btn-primary" style="margin-right: 10px;" id="export-table">Export Table</button> 
                    <a href="new-receiving.php"><button type="button" class="btn btn-success"><i class="fa fa-plus" aria-hidden="true"></i>New Stock</button></a>
                    </div>
                </div>
                <div class="table-responsive">
                    <table id="myTable" class="table table-bordered">
                        <tr>
                            <th onclick="sortTable(0)">S.N <span class="sort"></span></th>
                            <th onclick="sortTable(1)">Reference No. <span class="sort"></span></th>
                            <th onclick="sortTable(2)">Supplier<span class="sort"></span></th>
                            <th onclick="sortTable(3)">Total Amount<span class="sort"></span></th>
                            <th onclick="sortTable(4)">Receive Date<span class="sort"></span></th>
                            <th class="action">Action</th>
                        </tr>
                    <?php 
                     $limits=20;
                     if(isset($_GET['page'])){
                      $page=$_GET['page'];
                    }else{
                      $page=1;
                    }
                     $offset= ($page-1) * $limits;
                    $sql="SELECT * FROM `receiving` JOIN `supplier` ON  receiving.supplier_id = supplier.suplyr_id  WHERE `UserID`= '$userID' ORDER BY receiv_id DESC  LIMIT $limits OFFSET $offset ";
                             $run=mysqli_query($db,$sql);
                          $count = 1;
                           while($data=mysqli_fetch_assoc($run)){                 
                              $receiv_id=$data['receiv_id'];
                              $suplyr_name=$data['suplyr_name'];   
                              $ref_number=$data['ref_number'];
                              $Receiv_total_amount=$data['Receiv_total_amount'];
                              $receiv_date=$data['receiv_date'];
                                             
                    ?>


                        <tr>
                            <td><?php echo $count ;?></td>
                            <td><?php echo $ref_number ;?></td>
                            <td><?php echo $suplyr_name ;?></td>
                            <td><?php echo $Receiv_total_amount ;?></td>
                            <td><?php echo $receiv_date ;?></td>
                            
                            

                            <td class="action">
                                <!-- <a href="edit-invoice.php?sid=<?php echo $invoice_id;?>"><button type="button" class="btn" data-toggle="modal" data-target="#edit"><i class="fa fa-pencil" aria-hidden="true"></i></button></a> -->
                                <a href="view-receiving.php?sid=<?php echo $receiv_id ;?>"><button type="button" class="btn" data-toggle="modal" data-target="#view"><i class="fa fa-eye" aria-hidden="true"></i></button></a>
                                <!-- <a href="delete-invoice.php?sid=<?php echo $invoice_id;?>" onclick="return checkDelete()"><button type="button" class="btn"><i class="fa fa-trash-o" aria-hidden="true"></i></button></a> -->
                            </td>
                        </tr>
                        <?php $count++; } ?>
                    </table>
                     <?php 
                   $sql2="SELECT * FROM `receiving` JOIN `supplier` ON  receiving.supplier_id = supplier.suplyr_id WHERE `UserID`= '$userID'   ORDER BY receiv_id DESC  ";
                    $run2=mysqli_query($db,$sql2);
                    if(mysqli_num_rows($run2)>0){
                      $total_record=mysqli_num_rows($run2);
                      
                      $total_page=ceil($total_record/$limits);
                      ?>
                       <ul class="pagination">
                        <?php if($page > 1){ ?>
                        <li style="background: #09bdda;"><a href="receiving.php?page=<?php echo $page-1 ;?>" style="color: white;"><i class="fa fa-arrow-left" aria-hidden="true"> Prev</i></a></li><?php } ?>
                    <?php  for($i=1; $i <= $total_page; $i++){
                      if($i==$page){
                        $active="active";
                      }else{
                         $active=""; 
                      }
                        ?>
                    <li class="<?php echo $active ;?>"><a href="receiving.php?page=<?php echo $i ;?>"><?php echo $i ;?></a></li>
                    <?php }?>
                    <?php if($total_page >$page ){ ?>
                    <li style="background: #09bdda;"><a href="receiving.php?page=<?php echo $page+1 ;?>" style="color: white;">Next <i class="fa fa-arrow-right" aria-hidden="true"></i></a></li><?php } ?>
                    
                  </ul>
                  <?php  } ?>
                </div>
            </div>
        </div>
    </div>
</div>



<!----------------------------------End Main body Section----------------------------------->
             
    </div>
</div>

<?php include('footer.php') ?>

<!----- search script code start here--------->
<script src="https://cdn.rawgit.com/rainabba/jquery-table2excel/1.1.0/dist/jquery.table2excel.min.js"></script>
<script>
    $(document).ready(function(){
      /* Search table */
      
      $("#myInput").on("keyup", function() {
        var value = $(this).val().toLowerCase();
        $("#myTable tr").filter(function() {
          $(this).toggle($(this).text().toLowerCase().indexOf(value) > -1)
        });
      });
      /* Export table */
      $('#export-table').click(function(){
        $("#myTable").table2excel({
            filename: "Supply_List.xls"
        });
      })
    });
</script>
        
        <!----------- search script code end here----->