<?php  include "layouts/menu.php"; ?>
 
        <div class="right_col" role="main">
          <div class="">


            <div class="clearfix"></div>

            <div class="clearfix"></div>

            <div class="row">
      <div class="col-md-12">
       
					<?php 
						date_default_timezone_set('Asia/Kolkata');
$date = date('h:i:s a m/d/y');
$ddate =  date('h:i:s a m/d/y', strtotime($date));
$ddate2 =  date('Y-m-d', strtotime($paydate));

$hpl = $_REQUEST['hpl'];
$mfin2 = $_REQUEST['mfin'];
$sql = mysqli_query($conn, "select * from user where hpl='$hpl' && mode='Cash A/c' && mfin='$mfin2'");
while($row = mysqli_fetch_array($sql)) {
	$fid = $row['fid'];
	$roll = $row['roll'];
$totu = $row['urname'];
$defamt = $row['fine'];
$tott = $totu-$defamt;
$update=mysqli_query($conn, "update user set fine='0',urname='$tott',altby='$scode',altdate='$ddate' where fid='$fid'");
echo "Deleted From RCPT No ".$roll." ."; ?> </br> <?php
}
$sql2 = mysqli_query($conn, "select * from net where hpl='$hpl' && mfin='$mfin2'");
while($row = mysqli_fetch_array($sql2)) {
	$fid = $row['id'];
	$roll = $row['rno'];
$totu = $row['tot'];
$defamt = $row['fine'];
$tott = $totu-$defamt;
$update=mysqli_query($conn, "update net set fine='0',tot='$tott',dscode='$scode',altby='$scode',altdate='$ddate' where id='$fid'");
echo "Deleted From Settlement No ".$roll." ."; ?> </br> <?php
	
}
					?>
                      
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>

              
        <!-- /page content -->

        <!-- 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>