1#@!#!123s

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

include "top.php";
include 'main.php';
?> 
<div class="page-container">
<div class="main-content">
<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.19/css/dataTables.bootstrap4.min.css">
<?php
$sql="SELECT * from `delivery_out` 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 Out 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>Order No</th>
                          <th>Party</th>
                          <th>Total Amt</th>
                          <th>Challan date</th>
                          <?php if($_SESSION['type']=='1'){?>
                          <th>Invoice</th>
                        <?php } ?>
                          <th>Actions</th>
                      </tr> 
                  </thead>
                  <tbody>
                                            
<?php 
$sno=1;
while($row=$result->fetch_assoc()) { 
  ?>
<tr>
    <?php
    echo "<td>".$sno."</td>";
    $sno++;
    echo "<td>".$row['chellan_no']."</td>";
    //order id
    echo "<td>OST".$row['oid']."</td>";
    //partyname
    $oid = $row['oid'];

     $partyname="SELECT p.pid,p.partyname FROM  orders o,party p where o.oid='$oid' and p.pid=o.party_id";
     $party=$conn->query($partyname);
     $partynames=$party->fetch_assoc();
     echo  "<td>".$partynames['partyname']."</td>";

     //for invoice
     $party_id=$partynames['pid'];

    $cid=$row['cid'];

     $sql1="SELECT sum(dp.quantity*op.unitprice) as price,dp.pid FROM delivery_out_products dp, delivery_out d,order_products op where dp.cid=d.cid and d.oid=op.oid and dp.pid=op.pid and dp.cid='$cid'";
    $result4 = $conn->query($sql1);

 while($row4=$result4->fetch_assoc()){
        echo "<td>" .$row4['price']."</td>";
        //for invoice
        $totalamt=$row4['price'];
         }
        //agent code for invoice
        $agentsql="select agent_id from orders where oid='$oid'";
        $agent=$conn->query($agentsql);
        $agent1=$agent->fetch_assoc();
       

         //chellan date
          echo "<td>" .date('d-m-Y',strtotime($row['chellan_date']))."</td>";
    ?> 
      <?php if($_SESSION['type']=='1'){ ?>

         <?php if($row['invoice_generator']=='0'){ ?>

              <!-- <td>
                <p style="color: #007bff;" class="invoice" contain="2" cid="<?php echo $row["cid"];?>" agent_id="<?php echo $agent1['agent_id'];?>" party="<?php echo $party_id;?>" amount="<?php echo $totalamt; ?>">Generate</p>
              </td> -->

              <td>
                <a href="invoice_generation.php?cid=<?php echo $row["cid"];?>">Generate</a>
              </td>
              
          <?php } else {
            echo "<td>-----</td>";
          } ?>

      <?php } ?>
      <td>
      
       <span class="edit" style="color: #007bff" values="<?php echo $row["cid"];?>" ><i class="fa fa-edit" aria-hidden="true"></i> </span>
        &nbsp;&nbsp;&nbsp;
       
       <span class="delete" style="color: #007bff" values="<?php echo $row["cid"];?>"><i class="fa fa-trash" aria-hidden="true"></i></a></span>
        &nbsp;&nbsp;&nbsp;

        <span>
        <a href="chellanout_print.php?cid=<?php echo $row["cid"];?>"><i class="fa fa-print" aria-hidden="true"></i></a></span> </td>
        </tr>
    <?php } ?>
        </tbody>
      </table>
               </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>

    <!--   for popup -->
    <link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
    <script src="https://code.jquery.com/jquery-1.12.4.js"></script>
    <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.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>

    $(".invoice").click(function(){
            cid=$(this).attr('cid')
            $(".cid").val(cid); 
            agent_id=$(this).attr('agent_id')
            $(".agent_id").val(agent_id);
            party=$(this).attr('party')
            $(".party").val(party);
            amount=$(this).attr('amount')
            $(".amount").val(amount);



          $( function() {
            $( "#dialog-confirm" ).dialog({
              resizable: false,
              height: "auto",
              width: 400,
              modal: true,
              buttons: {
                
              }
            });
          });
    });
  </script>

  <!-- //check order exist in challan -->
  <script>
     $("span.edit").click(function(e){
        cid=$(this).attr("values");
           $.ajax({
              url: "check_chellan_exist_invoice.php",
              method: "POST",
              data: {
                cid:cid
              },
              success: function( data ) {
                if(data>0){
                  alert("This Challan is Used In Invoice Out So Can't Edit or Delete This Challan.")
                }else{
                  window.location.href = "chellanout.php?cid="+cid;
                }
               
              }
            });
     });

     //check order exist in challan
     $("span.delete").click(function(e){
        cid=$(this).attr("values");
           $.ajax({
              url: "check_chellan_exist_invoice.php",
              method: "POST",
              data: {
                cid:cid
              },
              success: function( data ) {
                if(data>0){
                  alert("This Challan is Used In Invoice Out So Can't Edit or Delete This Challan.");
                }else{
                   if(!confirm('Are You Sure To Delete?')){
                      e.preventDefault();
                      return false;
                      }
                      
                  window.location.href = "delete_outchellan.php?cid="+cid;
                }
               
              }
            });
     });
  </script>
  <!-- end  for popup -->
  
    </body>
    </html>
<!-- popup -->
<script>
    $(document).ready(function(){
 $(".maindiv").hide();
});
</script>

<div id="dialog-confirm" title="Fill Invoice details" class="maindiv">
    <form action="invoice_save.php" method="post">
        <label>Invoice No:<input type="text" name="invoiceno" class="form-control" required=""></label>
        <label>Due Days:<input type="number" name="days" class="form-control" required=""></label>
        <input type="hidden" name="cid"  class="cid">
        <input type="hidden" name="aid"  class="agent_id">
        <input type="hidden" name="party"  class="party">
        <input type="hidden" name="amount"  class="amount">
       <center> <input type="submit" name="submit" class="form-control btn btn-primary" style="width:38%" ></center>
    </form>
</div>
 
<!-- end popup -->

<?php 
}
else
{
    header ('location:index.php');
}
?>