1#@!#!123s

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

?>
       <link rel="stylesheet" type="text/css" href="https://code.jquery.com/ui/1.12.0/themes/smoothness/jquery-ui.css">
       <link rel="stylesheet" href="https://cdn.datatables.net/1.10.20/css/dataTables.bootstrap4.min.css">
        <div class="page-container">
         
            <div class="main-content">
                <div class="section__content section__content--p30">
                    <div class="container-fluid">
                        <div class="row">
                            <div class="col-lg-12">
                                <div class="card">
                
                                    <div class="card-body">
                                        <div class="card-title">
                                            <h3 class="text-center title-2">Period vise Invoice Raised</h3>
                                        </div>
                                        <hr> 
                                       


                                        <div class="row col-md-12">

                                          <div class="col-md-4">
                                            <label>From Date</label>
                                            <input id="from_date" name="from_date" type="text" value="" required="" class="form-control" autocomplete="off">
                                          </div> 

                                          <div class="col-md-4">
                                            <label>To Date</label>
                                            <input id="to_date" name="to_date" type="text" value="" required="" class="form-control" autocomplete="off">
                                          </div> 


                                          <div class="col-md-4">
                                            <label>Agent :</label>
                                            <?php 
                                            $sql1 = "SELECT agent_code FROM agent_details WHERE status = 1";
                                            $result1 = $conn->query($sql1);
                                            ?>

                                            <select class="form-control" id="agent_code">
                                                  <option value="">All</option>
                                                  <?php 
                                                  while ($row1=$result1->fetch_assoc()) { ?>
                                                  <option><?php echo $row1['agent_code']; ?></option>
                                                  <?php }?>
                                            </select>   
                                          </div>
                                        </div>


                                        <div class="row col-md-12">

                                          <div class="col-md-4" id="required_fromdate" style="color: red; display: none;">Required</div>

                                          <div class="col-md-4" id="required_todate" style="color: red; display: none;">Required</div>

                                          <div class="col-md-4"></div>
                                        </div><br>

                                        <div class="row">
                                          <div class="col-md-12">
                                            <button class="col-md-3 btn btn-primary" id="submit" style="margin-left: 36%;">Submit</button> 
                                            <button class="col-md-3 btn btn-success" id="print" style="float: right;">Print</button>
                                          </div>
                                        </div>
                                        <br><br>

                                        <div class="row col-md-12" style="overflow-x:auto;width: 100%;">
                                        <table  class="table table-striped table-bordered table-sm" cellspacing="0" id="example" width="100%">
                                        <thead>
                                            <tr>
                                                 <th>Agent Code</th>
                                                 <th>Invoice No</th>
                                                 <th>Party</th>
                                                 <th>Invoice Date</th>
                                                 <th>Amount</th>
                                                 <th>Balance</th>
                                            </tr>
                                        </thead>
                                        <tbody id='table_body'>
                                          
                                        </tbody>
                                      </table>
                                    </div>
    
                                  </div>
                              </div>
                          </div> 
                      </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>


<script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script>

<script type="text/javascript">
  $("#from_date").datepicker({
        numberOfMonths: 1,
        onSelect: function(selected) {
          $("#to_date").datepicker("option","minDate", selected)
        }
    });
    $("#to_date").datepicker({
        numberOfMonths: 1,
        onSelect: function(selected) {
           $("#from_date").datepicker("option","maxDate", selected)
        }
    });

$(document).ready(function(){
    $(document).on("click","#submit",function(){
      from_date = $("#from_date").val();
      to_date = $("#to_date").val();
      agent_code = $("#agent_code").val();

      if(from_date != ''){
        if(to_date != ''){
          $.ajax({    
              url: 'get_agent_vise_report.php',
              type: 'POST',
              data:{from_date:from_date,to_date:to_date,agent_code:agent_code},
              dataType: "json",
              success: function (status) {
                  $("#table_body").html("");
                  total_amt = 0;
                  total_balance = 0;
                   
                  $.each(status, function(id, val){

                      $("#table_body").append("<tr><td>"+val.agent_code+"</td><td>"+val.invoice+"</td><td>"+val.party+"</td><td>"+val.actualdate+"</td><td>"+val.amount+"</td><td>"+val.balance+"</td></tr>");

                        total_amt += parseFloat(val.amount);
                        total_balance += parseFloat(val.balance);
                      
                  });

                  $("#table_body").append("<tr><td colspan='3'></td><td style='color: black; font-weight: bold;'>Total</td><td style='color: black; font-weight: bold;'>"+total_amt+"</td><td style='color: black; font-weight: bold;'>"+total_balance+"</td></tr>");

              },
          });

        }else{
           $("#required_todate").show();
        }

      }else{
        $("#required_fromdate").show();
      }

    });


    $(document).on("click","#print",function(){
      from_date = $("#from_date").val();
      to_date = $("#to_date").val();
      agent_code = $("#agent_code").val();

        if(from_date != ''){
           if(to_date != ''){
            window.location.href="period_vise_invoice_raised_print.php?from_date="+from_date+"&to_date="+to_date+"&agent_code="+agent_code+"";

           }else{
           $("#required_todate").show();
           }
        }else{
          $("#required_fromdate").show();
        }

    });

});



</script>

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


</body>

</html>
 <?php
}
else
{
    header ('location:index.php');
}
?>
<style type="text/css">
  table.dataTable thead .sorting:after,
table.dataTable thead .sorting:before,
table.dataTable thead .sorting_asc:after,
table.dataTable thead .sorting_asc:before,
table.dataTable thead .sorting_asc_disabled:after,
table.dataTable thead .sorting_asc_disabled:before,
table.dataTable thead .sorting_desc:after,
table.dataTable thead .sorting_desc:before,
table.dataTable thead .sorting_desc_disabled:after,
table.dataTable thead .sorting_desc_disabled:before {
bottom: .5em;
}
</style>

<script type="text/javascript">
  $(document).ready(function () {
$('#dtVerticalScrollExample').DataTable({
"scrollY": "200px",
"scrollCollapse": true,
});
$('.dataTables_length').addClass('bs-select');
});
</script>