<?php include "layouts/menu.php"; ?> <div class="right_col" role="main">
            
            <div class="row">
                <div class="col-lg-12">
                    <!-- Form Elements -->
                    <div class="panel panel-default">
                        <div class="panel-heading">
                          Net   Details
                        </div>
                        <div class="panel-body">
                            <div class="row">
  
                <div class="col-lg-12">
     <?php
					
						$qry=mysqli_query($conn, "select * from userm where mfin='$mfin'");
						$n=mysqli_num_rows($qry);
						if($n==0)
						{
							echo "Nothing To Display";
						}
						else
						
					{ 
						?>
                <!-- Main content -->
              
                         
                                <table id="datatable-buttons" id="datatable-buttons" class="table table-striped table-bordered">           
                                        <thead>
                                            <tr><th>FID</th>
												<th>Hpl</th>
													<th>Name</th>
													<th>Receipt No</th>
													<th>Receipt Date</th>
											<th>Diff</th>
												<th>Bill No</th>
												<th>Edit</th>
                                            </tr>
                                        </thead>
									    <tbody>	<?php $ii=0;
					while($row2=mysqli_fetch_array($qry))
						{ $ii++;
						
						$tot = $row2['urname'];
						$a1 = $row2['pass'];
						$a2 = $row2['rno'];
						$a3 = $row2['fine'];
						$a4 = $row2['hloan'];
						$a5 = $row2['addless'];
						$totdif = $tot - $a1 - $a2 - $a3 - $a4 + $a5;
						if($totdif != 0){
						    $ttotdif = $ttotdif + $totdif;
					?>
                                    
                                           <tr>
                                                <td><?php echo $row2['fid'];?></td>
                                               <td><?php echo $row2['hpl'];?></td>
                                                  <td><?php echo $row2['name'];?></td>
                                                   <td><?php echo $row2['roll'];?></td>
                                                    <td><?php echo $row2['paydate2'];?></td>
						<td><?php echo $totdif;?></td>
						<td><?php echo $row2['rno']; ?></td>
							<td><b>
<a href="editsarea.php?id=<?php echo $row2['id'];?>" class="btn btn-info btn-xs" onclick="return confirm('Are you sure WANT TO Edit?');">Edit</a>				
</td>
                                            </tr>
                                        
                                        <?php
						} }
					}
				
					?>  </tbody>
					
					<tfoot>
					           <tr>
                                                <td></td>
                                              <td></td>
                                                  <td>Total</td>
						<td><?php echo $ttotdif;?></td>
						<td></td>
						<td></td>				

                                            </tr>
					</tfoot>
					                    
                                    </table>		
                                </div><!-- /.box-body -->
                            </div><!-- /.box -->
 
</div>
</div></div>
</div></div></div> 
        <!-- footer content --> 
        <footer>
          <div class="pull-right">
             <a href="https://infossel.com">Infossel Soft Solution</a>
          </div>
          <div class="clearfix"></div>
        </footer>
        <!-- /footer content -->
      </div>
    </div>

    <!-- jQuery -->
    <script src="vendors/jquery/dist/jquery.min.js"></script>
    <!-- Bootstrap -->
    <script src="vendors/bootstrap/dist/js/bootstrap.min.js"></script>
    <!-- FastClick -->
    <script src="vendors/fastclick/lib/fastclick.js"></script>
    <!-- NProgress -->
    <script src="vendors/nprogress/nprogress.js"></script>
    <!-- iCheck -->
    <script src="vendors/iCheck/icheck.min.js"></script>
    <!-- Datatables -->
    <script src="vendors/datatables.net/js/jquery.dataTables.min.js"></script>
    <script src="vendors/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
    <script src="vendors/datatables.net-buttons/js/dataTables.buttons.min.js"></script>
    <script src="vendors/datatables.net-buttons-bs/js/buttons.bootstrap.min.js"></script>
    <script src="vendors/datatables.net-buttons/js/buttons.flash.min.js"></script>
    <script src="vendors/datatables.net-buttons/js/buttons.html5.min.js"></script>
    <script src="vendors/datatables.net-buttons/js/buttons.print.min.js"></script>
    <script src="vendors/datatables.net-fixedheader/js/dataTables.fixedHeader.min.js"></script>
    <script src="vendors/datatables.net-keytable/js/dataTables.keyTable.min.js"></script>
    <script src="vendors/datatables.net-responsive/js/dataTables.responsive.min.js"></script>
    <script src="vendors/datatables.net-responsive-bs/js/responsive.bootstrap.js"></script>
    <script src="vendors/datatables.net-scroller/js/dataTables.scroller.min.js"></script>
    <script src="vendors/jszip/dist/jszip.min.js"></script>
    <script src="vendors/pdfmake/build/pdfmake.min.js"></script>
    <script src="vendors/pdfmake/build/vfs_fonts.js"></script>

    <!-- Custom Theme Scripts -->
    <script src="build/js/custom.min.js"></script>

  </body>
</html>