invisio v2.0

<?php
	include("innerpageheader.php");
	include("config.php");
	$result = $js->query('SELECT * FROM `invoicepayments` ORDER BY `id`');
	$result->execute();
			
?>
<section>
			<div class="content listing-content">
				<div class="in-content-wrapper">
					<div class="row no-gutters">

<div class="col">
							<div class="heading-messages">
								<h3>Invoice Payments</h3>
							</div>
						</div>
						<div class="col-md-4">
							<div class="breadcrumb">
								<div class="breadcrumb-item"><i class="fas fa-angle-right"></i><a href="#">Listing</a>
								</div>
								<div class="breadcrumb-item active"><i class="fas fa-angle-right"></i>All
								</div>
							</div>
						</div>
					</div>

<div class="box">
						<div class="row no-gutters">
							<div class="col-auto me-auto text-start pe-0">
								<div class="add-new">
									<a href="add_invoicepayments.php">Add Invoice Payments<i class="fas fa-plus"></i></a>
								</div>
							</div>
							<div class="col text-end">
								<div class="tools-btns">
									<a href="#"><i class="fas fa-print" data-bs-toggle="tooltip" data-html="true" title="Print"></i></a>
									<a href="#"><i class="fas fa-file-pdf" data-bs-toggle="tooltip" data-html="true" title="Pdf"></i></a>
									<a href="#"><i class="fas fa-file-excel" data-bs-toggle="tooltip" data-html="true"
											title="Excel"></i></a>
								</div>
							</div>

</div>
						<div class="row no-gutters">
							<div class="col-12 table-responsive">
								<table id="example" class="table table-hover responsive listing">
                                    <thead>
                                        <tr >
                                            <th>Invoice No</th>
                                            <th>Client</th>
                                            <th>Payment Date</th>
                                            <th>Mode</th>
                                            <th>Invoice Amount</th>
                                            <th>Received Amount</th>
                                            
                                            <th>Remarks</th>
                                            <th>Edit</th>
                                            <th>Print Receipt</th>
                                        </tr>
                                    </thead>










                                    <tbody>
									<?php
										while($rowinv0 = $result->fetch(PDO::FETCH_ASSOC)) 
										{
											$payid = $rowinv0['id'];
											$invid = $rowinv0['invoiceid'];
											$resultinv1 = $js->prepare('SELECT * FROM `invoiced` WHERE id = :invid');
											$resultinv1->execute(array(':invid' => $invid));
											while($rowinv = $resultinv1->fetch(PDO::FETCH_ASSOC)) 
											{
												$project = strtoupper($rowinv['descr']);
												$comid = $rowinv['cust'];
												$invamount = $rowinv['invamount'];
												$currency = $rowinv['currency'];
												$invoice = $rowinv['invid'];
											}
											
											$net = $invamount;
	
											$result2 = $js->prepare('SELECT * FROM `customer_entry` WHERE `id` = :comid');
											$result2->bindParam(':comid', $comid);
											$result2->execute();
											while($row2 = $result2->fetch(PDO::FETCH_ASSOC)) {
												$contact_person = $row2['custname'];
												$compname = $row2['companyname'];
											}
											$paysdate = $rowinv0['paydate'];
											$balance = $rowinv0['balance'];
											$paydate = date('d-m-Y', strtotime($rowinv0['paydate']));
											$payamount = $rowinv0['payamount'];
											$mode = $rowinv0['mode'];
											
											$remarks = $rowinv0['remarks'];
											
											echo "<tr>";
												echo "<td>$invoice</td>";
												echo "<td>$contact_person</td>";
												echo "<td>$paydate</td>";
												echo "<td>$mode</td>";
												echo "<td>$net ";
												if($balance > '0') 
												{
													echo "<br>Balance : ".$balance;	
												}
												else
												{
													echo "PAID FULL";	
												}
												echo " </td>";
												echo "<td>$payamount</td>";
												echo "<td>$remarks</td>";
									?>
                                    	<td><a href="edit_invoicereceipt.php?id=<?php echo $payid?>"><i class="fas fa-edit" style="color:#609;"></i></a></td>
                                    	<td><a href="print_invoicereceipt.php?payment=<?php echo $payid?>"><i class="fa fa-print" aria-hidden="true"></i></a></td>
                                    <?php
											echo "</tr>";
											$totals = '';
											$balance = '';
											$grand_total = '';
											$vatamt = '';
											$net = '';
											$invid ='';
											$payamount='';
											$totpay ='';
											$balance = '';
										}
									?>
                                        
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>

</div>

</div>

<?php
				include("footer.php");
		   ?>

</div>

</div>

<a class="scroll-to-top rounded" href="#page-top">
        <i class="fas fa-angle-up"></i>
    </a>

<div class="modal fade" id="logoutModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel"
        aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLabel">Ready to Leave?</h5>
                    <button class="close" type="button" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">×</span>
                    </button>
                </div>
                <div class="modal-body">Select "Logout" below if you are ready to end your current session.</div>
                <div class="modal-footer">
                    <button class="btn btn-secondary" type="button" data-dismiss="modal">Cancel</button>
                    <a class="btn btn-primary" href="login.html">Logout</a>
                </div>
            </div>
        </div>
    </div>

<script src="vendor/jquery/jquery.min.js"></script>
    <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

<script src="vendor/jquery-easing/jquery.easing.min.js"></script>

<script src="js/sb-admin-2.min.js"></script>

<script src="vendor/datatables/jquery.dataTables.min.js"></script>
    <script src="vendor/datatables/dataTables.bootstrap4.min.js"></script>

<script src="js/demo/datatables-demo.js"></script>

</body>

</html>