1#@!#!123s

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

<style>
table tr td{ padding:6px; }
th, td {
  border-bottom: 1px solid #ddd;
}
  div#footer_wrapper {
      margin: 0px 2px 0px 7px;
      position: fixed;
      bottom: 0;
      text-align: right;
    }
</style>

<?php 
$from_date = $_GET['from_date'];
  $from_date = date("Y-m-d H:i:s", strtotime($from_date));

  $to_date = $_GET['to_date'];
  $to_date = date("Y-m-d H:i:s", strtotime($to_date));

  $agent_code = $_GET['agent_code'];

 if($agent_code == ""){
    $sql ="SELECT i.party,i.agent_code,p.payment_date,p.invoice,SUM(p.amount) as received_amount FROM `invoice` i, payment p WHERE  i.invoice = p.invoice and p.payment_date BETWEEN '$from_date' and '$to_date' and p.del = 1 and i.del = 1 GROUP BY p.invoice";
  }else{
    $sql ="SELECT i.party,i.agent_code,p.payment_date,p.invoice,SUM(p.amount) as received_amount FROM `invoice` i, payment p WHERE i.agent_code = '$agent_code' and i.invoice = p.invoice and p.payment_date BETWEEN '$from_date' and '$to_date' and p.del = 1 and i.del = 1 GROUP BY p.invoice";
  }

  $res=$conn->query($sql);
?>



 
 <body onload="myFunction()" style="margin:0; padding:0;">
  

<div>
  <br><br>
<h3 style="text-align: center;">Period Vise Payment Received</h3></div>
<?php if(isset($agent_code) && $agent_code !=''){ ?>

<p>Agent : <?php echo $agent_code; ?></p>
<?php } ?>
 <table border="2px" width="100%">
    <thead>
        <tr>
           <th>Agent Code</th>
           <th>Invoice No</th>
           <th>Party</th>
           <th>Payment Date</th>
           <th>Received Amount</th>
           
        </tr>
    </thead>
    <tbody>
      <?php 

      $total_amt = 0;
      $total_bal = 0;

      while ($row = $res->fetch_assoc()) {
        $total_amt +=  $row['received_amount'];
       
       ?>
        <tr>
          <td><?php echo $row['agent_code']; ?></td>
          <td><?php echo $row['invoice']; ?></td>
          <td>
            <?php
            $pid = $row['party'];
            $get_pname = "SELECT party FROM `party_inv` WHERE id = '$pid'";
            $pname_res = $conn->query($get_pname);
            $pname_row = $pname_res->fetch_assoc();


            $party_name = $pname_row['party'];
            echo $party_name;
            ?>
          </td>
          <td><?php echo date('d-m-Y', strtotime($row['payment_date'])); ?></td>
          <td><?php echo $row['received_amount']; ?></td>
         
        </tr>
      <?php } ?>

      <tr>
        <td colspan="3"></td>
        <td>Total</td>
        <td><?php echo  number_format($total_amt, 2);?></td>
       
      </tr>
      
    </tbody>
  </table>




<div id="footer_wrapper">
<tfoot id="table_footer"><a>Shankra Trading</a></tfoot></tr>
</div> 

 </body>
</div>



<script>

function myFunction() {
  window.print();
  }
</script>
<?php
}
else
{
    header ('location:index.php');
}
?>