1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / app.eltorofashions.com / demo /
Filename : view_inchellan.php
back
<?php 
include "header.php";
if(isset($_SESSION['login'])){
include "top.php";
include 'main.php';
?> 

<head>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.css">
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.20/css/dataTables.bootstrap4.min.css">
</head>

<div class="page-container">
<div class="main-content">

<?php
$sql="SELECT * from `delivery_in` Where status='1' ORDER BY cid DESC";
$result = $conn->query($sql);
?>
<div class="section__content section__content--p30">
<div class="row">
<div class="col-lg-12">
    <div class="table-responsive table--no-card m-b-30">
         <center><h3 style="background-color:white; padding: 1%">Challan In List</h3></center>
        <table class="table table-borderless table-striped table-earning" id="example">
            <thead>
                <tr>
                    <th>S.NO</th>
                    <th>Challan No</th>
                    <th>From</th>
                    <th>Challan Date</th>
                    <th>Entry Date</th>
                    <th>Employee</th>
                    <th>Total Product</th>
                    <th><center>Actions</center></th>
                </tr>                       
            </thead>
            <tbody>
                                            
<?php 
$sno='1';
while($row=$result->fetch_assoc()) { 
?>
<tr>
    <td><?=$sno; $sno++;?></td>
    <td><?php echo $row['chellan_no']; ?></td>
    <td><?php echo $row['from']; ?></td>
    <td><?php echo date('d-m-Y',strtotime($row['chellan_date']));?></td>
    <td><?php echo isset($row['entry_date'])?date('d-m-Y',strtotime($row['entry_date'])):'-------------';?></td>
    <td><?php echo $row['employee'];?></td>
<?php 
$cid=$row['cid'];
$sql1="select sum(quantity) as q from delivery_in_products where cid ='$cid'";
$result1 = $conn->query($sql1);
?>
<td>
<?php while($row1=$result1->fetch_assoc()) {
print_r($row1['q']);
}
?>
</td>
<td><center>
    <a href="view_each_inchellan.php?cid=<?php echo $row["cid"];?>"><i class="fa fa-eye" aria-hidden="true"></i></a>
    &nbsp;&nbsp;&nbsp;
    <a href="chellanin.php?cid=<?php echo $row["cid"];?>"><i class="fa fa-edit" aria-hidden="true"></i></a>
    &nbsp;&nbsp;&nbsp;
    <a href="delete_inchellan.php?cid=<?php echo $row["cid"];?>" class="delete"><i class="fa fa-trash" aria-hidden="true"></i></a> 
    </center>
</td>
</tr>
<?php } ?>
         </tbody>
         </table>
   </div>
</div> </div>
</div> </div> </div>   

<script src="vendor/jquery-3.2.1.min.js"></script>
<script src="vendor/animsition/animsition.min.js"></script>
<script src="js/main.js"></script>

<!-- date table -->
<script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>  
<script src="https://cdn.datatables.net/1.10.19/js/dataTables.bootstrap4.min.js"></script>
<script type="text/javascript">
   $(document).ready(function() {
    $('#example').DataTable();
    } );
</script>
<!-- date table end -->

<script language="JavaScript" type="text/javascript">
$(document).ready(function(){
    $("a.delete").click(function(e){
        if(!confirm('Are You Sure To Delete?')){
            e.preventDefault();
            return false;
        }
        return true;
    });
});
</script> 
</body>
</html>
<?php 
}
else
{
    header ('location:index.php');
}
?>