invisio v2.0

<?php
	session_start();
	$empids = $_SESSION['empids'];
	include("innerpageheader.php");
	include("config.php");
		$result = $js->prepare('SELECT * FROM `income` ORDER BY `incdate`');
		$result->execute();
			
?>

</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_income.php">Add New<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 align="center">
                                            <th>Paid_Date</th>
                                            <th>Credited Date</th>
											<th>Customer</th>
                                            <th>Paid Against</th>
											<th>Amount</th>
											<th>Mode</th>
                                            <th>Remarks</th>
                                            <th>Print Receipt</th>
                                            <th>Delete</th>
                                        </tr>
                                    </thead>

<tbody>
									<?php
										while($row = $result->fetch(PDO::FETCH_ASSOC)) 
										{
											$id = $row['id'];
											$expid = $row['expid'];
											$expdate = $row['incdate'];
											$creditdate = $row['creditdate'];
											$custid = $row['custid'];
											/*if($custid == 'OTHERS')
											{*/
												$custname = $custid;	
											/*}
											else
											{
												$sql1 = $js->prepare('SELECT * FROM customer_entry WHERE custid = :custid ');
												$sql1->execute(array(':custid' => $custid));
												
												while($row1 = $sql1->fetch(PDO::FETCH_ASSOC)) 
												{
													$custname = $row1['custname'];
												}
											}*/
											
											$tot = $row['incamount'];
											$incheads = $row['incheads'];
											
											
											$compexp = $tot;	
											
											
											$pieces4 = explode(".", $compexp);
											$mainmenu4 = $pieces4[0];
											$submenu4 =  $pieces4[1];
											$str= strlen($submenu4);
											if($str == '1')
												$submenu4 .= '00';
											elseif($str == '2')
												$submenu4 .= '0';
											elseif($str == '0')
												$submenu4 .= '000';
											else{}
											$expamount = $mainmenu4.".".$submenu4;
											$pmode = $row['pmode'];
											$premarks = $row['premarks'];
											$enteredby = $row['enteredby'];
											
											echo "<tr>";
												echo "<td>$expdate</td>";
												echo "<td>$creditdate</td>";
												echo "<td>$custname</td>";
												echo "<td>$incheads</td>";
												echo "<td align='right'>$expamount";
												if($expheads == 'MI90')
												{
													echo "<br>
														<a href='comploanrepay.php?exp=$expid' style='border-radius:25px; width:120px; padding:10px;' class='bbtn btn-google btn-block'>Repay $expamount</a>";
												}
												echo "</td>";
												echo "<td>$pmode</td>";
												echo "<td>$premarks</td>";
												echo "<td align='center'><a href='printincomevoucher.php?id=$id'  style='border-radius:25px; background-color:#1A73E8; text-align:center;' class='btn btn-primary btn-circle' target='_blank'><i  class='fas fa-print'></i> </a></td>";
												
												?>
                                                <td><a onclick="return add('<?php echo $id?>')"  style='background-color:red; border-color:red;' class='btn btn-primary btn-circle'><i  class='fa fa-times'></i></a></td>	
                                                <?php
											echo "</tr>";
										}
									?>
                                        
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>

</div>
                
                
 </div>

<script src="js/jquery-3.3.1.min.js"></script>
	<script src="js/popper.min.js"></script>
	<script src="js/bootstrap-5.3.2.min.js"></script>
	<script src="vendors/datatables/datatables.min.js"></script>
	<script src="js/customscriptfile.js"></script>

</html>

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