<?php
include('php-includes/connect.php');
include('php-includes/check-login.php');
$userid = $_SESSION['userid'];
$sel="select * from user where email='$userid' ";
$res=mysqli_query($con,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
//echo $userid;
?>
<?PHP include("link/header.php")?>
<link href="vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="jq/jquery.dataTables.min.css" type="text/css" rel="stylesheet"/>
<link href="jq/buttons.dataTables.min.css" type="text/css" rel="stylesheet"/>
  <link href="/your-path-to-fontawesome/css/fontawesome.css" rel="stylesheet">
<script src="https://ajax.aspnetcdn.com/ajax/jQuery/jquery-3.4.1.min.js"></script>
<script src="jq/jquery.dataTables.min.js"></script>
<script src="jq/dataTables.buttons.min.js"></script>
<script src="jq/buttons.flash.min.js"></script>
<script src="jq/jszip.min.js"></script>
<script src="jq/pdfmake.min.js"></script>
<script src="jq/vfs_fonts.js"></script>
<script src="jq/buttons.html5.min.js"></script>
<script src="jq/buttons.print.min.js"></script>
<section id="main-content">
	<section class="wrapper">
	<div id="page-wrapper" style="background-color: white;background-repeat: no-repeat;background-position: center;background-size:580px">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-lg-12">
                        <h1 class="page-header">PAID BALANCE</h1>
											<script>
$(document).ready(function(){
    $('#example').DataTable({
        dom: 'Bfrtip',
       buttons: ['copy', 'csv', 'excel', 'pdf', 'print']
    });
	
});
</script>
<?php
$sel1235="select * from  income where userid='$userid' ";
	$res1235=mysqli_query($con,$sel1235);
	$row1235=mysqli_fetch_array($res1235,MYSQLI_BOTH);
	$income2=$row1235['total_bal'];
	
	$sel12351="select * from  user where email='$userid' ";
	$res12351=mysqli_query($con,$sel12351);
	$row12351=mysqli_fetch_array($res12351,MYSQLI_BOTH);
	$amount=$row12351['amount'];
	if($amount==7000)
	{
		$am='834';
	}
	if($amount==3500)
	{
		$am='417';
	}
	$sel1234="select * from  recieve where dis='$userid' and status='Yes' ";
	$res1234=mysqli_query($con,$sel1234);
	//$row1234=mysqli_fetch_array($res1234,MYSQLI_BOTH);
	
	
?>

	<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
        <thead>
            <tr>
                <th  style="text-align:center">Sr.</th><th  style="text-align:center">DIST ID</th><th  style="text-align:center">NAME</th><th  style="text-align:center">PAID BALANCE</th><th  style="text-align:center">PLAN</th><th  style="text-align:center">DATE</th><th  style="text-align:center">Print</th>
            </tr>
        </thead>

<tbody>		
  
		 <?php
		 
		 $tot=0;
		 $s=1;
	while($row1234=mysqli_fetch_array($res1234,MYSQLI_BOTH))
		
	{
		$balance=$row1234['amount'];
		$date=$row1234['date'];
		$tot=$balance+$tot;
	
	
		 
		 
		 ?>
	<tr class="text-center">
	<td><?PHP echo $s++;?></td><td><?PHP echo $userid;?></td><td><?php echo $row12351['name'];?></td><td><?php echo $balance;?></td><td><?php echo $row1234['plan'];?></td><td><?php echo $date;?></td><td><a href='paymentslip.php?flag=<?php echo $row1234['id'];?>'>Print</a></td>
	
	
	
	</tr>
	<?php
	
	}
	?>
	<tr class="text-center">
	<td style="font-weigth:bold">TOTAL</td><td></td><td></td><td style="font-weigth:bold"><?php echo $tot;?></td><td></td><td></td>
	
	
	
	</tr>
	 </tbody>
	 <tfoot>
             <tr>
                <th  style="text-align:center">Sr.</th><th  style="text-align:center">DIST ID</th><th  style="text-align:center">NAME</th><th  style="text-align:center"><?php echo $tot;?></th><th  style="text-align:center">PLAN</th><th  style="text-align:center">DATE</th><th  style="text-align:center">Print</th>
            </tr>
        </tfoot>
    </table>
	
	</div>
                    </div>
                    <!-- /.col-lg-12 -->

                </div>
                <!-- /.row -->
                <div class="row">
                
                </div><!--/.row-->
            </div>
            <!-- /.container-fluid -->
        </div>
        <!-- /#page-wrapper -->

    </div>

	
</section>

<script src="//cdnjs.cloudflare.com/ajax/libs/jquery-form-validator/2.3.26/jquery.form-validator.min.js"></script>
<script>
  $.validate({
    modules : 'html5',
	modules : 'file'
  });
</script>
 <!-- footer -->
		  <div class="footer">
			<div class="wthree-copyright">
			  <p>© 2021 Visitors. All rights reserved | Design by <a href="#">MSLONG</a></p>
			</div>
		  </div>
  <!-- / footer -->
</section>
<!--main content end-->
</section>
<script src="js/bootstrap.js"></script>
<script src="js/jquery.dcjqaccordion.2.7.js"></script>
<script src="js/scripts.js"></script>
<script src="js/jquery.slimscroll.js"></script>
<script src="js/jquery.nicescroll.js"></script>
<!--[if lte IE 8]><script language="javascript" type="text/javascript" src="js/flot-chart/excanvas.min.js"></script><![endif]-->
<script src="js/jquery.scrollTo.js"></script>
<!-- morris JavaScript -->	
<script>
	$(document).ready(function() {
		//BOX BUTTON SHOW AND CLOSE
	   jQuery('.small-graph-box').hover(function() {
		  jQuery(this).find('.box-button').fadeIn('fast');
	   }, function() {
		  jQuery(this).find('.box-button').fadeOut('fast');
	   });
	   jQuery('.small-graph-box .box-close').click(function() {
		  jQuery(this).closest('.small-graph-box').fadeOut(200);
		  return false;
	   });
	   
	    //CHARTS
	    function gd(year, day, month) {
			return new Date(year, month - 1, day).getTime();
		}
		
		graphArea2 = Morris.Area({
			element: 'hero-area',
			padding: 10,
        behaveLikeLine: true,
        gridEnabled: false,
        gridLineColor: '#dddddd',
        axes: true,
        resize: true,
        smooth:true,
        pointSize: 0,
        lineWidth: 0,
        fillOpacity:0.85,
			data: [
				{period: '2015 Q1', iphone: 2668, ipad: null, itouch: 2649},
				{period: '2015 Q2', iphone: 15780, ipad: 13799, itouch: 12051},
				{period: '2015 Q3', iphone: 12920, ipad: 10975, itouch: 9910},
				{period: '2015 Q4', iphone: 8770, ipad: 6600, itouch: 6695},
				{period: '2016 Q1', iphone: 10820, ipad: 10924, itouch: 12300},
				{period: '2016 Q2', iphone: 9680, ipad: 9010, itouch: 7891},
				{period: '2016 Q3', iphone: 4830, ipad: 3805, itouch: 1598},
				{period: '2016 Q4', iphone: 15083, ipad: 8977, itouch: 5185},
				{period: '2017 Q1', iphone: 10697, ipad: 4470, itouch: 2038},
			
			],
			lineColors:['#eb6f6f','#926383','#eb6f6f'],
			xkey: 'period',
            redraw: true,
            ykeys: ['iphone', 'ipad', 'itouch'],
            labels: ['All Visitors', 'Returning Visitors', 'Unique Visitors'],
			pointSize: 2,
			hideHover: 'auto',
			resize: true
		});
		
	   
	});
	</script>
<!-- calendar -->
	<script type="text/javascript" src="js/monthly.js"></script>
	<script type="text/javascript">
		$(window).load( function() {

			$('#mycalendar').monthly({
				mode: 'event',
				
			});

			$('#mycalendar2').monthly({
				mode: 'picker',
				target: '#mytarget',
				setWidth: '250px',
				startHidden: true,
				showTrigger: '#mytarget',
				stylePast: true,
				disablePast: true
			});

		switch(window.location.protocol) {
		case 'http:':
		case 'https:':
		// running on a server, should be good.
		break;
		case 'file:':
		alert('Just a heads-up, events will not work when run locally.');
		}

		});
	</script>
	<!-- //calendar -->
</body>
</html>