<?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">
                          Customer Details
                        </div>
                        <div class="panel-body">
                            <div class="row">
<?php
			  
  $hpl=$_REQUEST['hpl'];
    $hplt=$_REQUEST['hplt'];
  $vno=$_REQUEST['vno'];
  $vname=$_REQUEST['vname'];
  $area=$_REQUEST['area'];
  $name=$_REQUEST['name'];
  $gid=$_REQUEST['gid'];
   $broker=$_REQUEST['brk'];
   $com=$_REQUEST['com'];
    $pno=$_REQUEST['pno'];  $vtype=$_REQUEST['vtype'];
	 $cobname=$_REQUEST['cobname'];
	  $status=$_REQUEST['status']; $dealer=$_REQUEST['dealer'];
	     if(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL)&&($vno !=NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where vno LIKE '%$vno%' order by name asc");
		$qry2=mysqli_query($conn, "select * from customerdetailsw where vno LIKE '%$vno%' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where vno LIKE '%$vno%' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl !=NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where hpl='$hpl' order by name asc"); 
	$qry2=mysqli_query($conn, "select * from customerdetailsw where hpl='$hpl' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where hpl='$hpl' order by name asc");
										$qry4=mysqli_query($conn, "select * from customerdetailsq where hpl='$hpl' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hplt !=NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where hplt='$hplt' order by name asc"); 
	$qry2=mysqli_query($conn, "select * from customerdetailsw where hpl='$hpl' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where hpl='$hpl' order by name asc");
										$qry4=mysqli_query($conn, "select * from customerdetailsq where hpl='$hpl' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker!='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where bname='$broker' order by name asc"); 
	$qry2=mysqli_query($conn, "select * from customerdetailsw where bbd='$vtype' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where bbd='$vtype' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com!='None')&&($status=='None')&&($cobname ==NULL)&&($broker!='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where bname='$broker' && mfin='$com' order by name asc"); 
	$qry2=mysqli_query($conn, "select * from customerdetailsw where bbd='$vtype' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where bbd='$vtype' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer!='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where dealer='$dealer' order by name asc"); 
	$qry2=mysqli_query($conn, "select * from customerdetailsw where bbd='$vtype' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where bbd='$vtype' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer!='None')&&($com!='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where dealer='$dealer' && mfin='$com' order by name asc"); 
	$qry2=mysqli_query($conn, "select * from customerdetailsw where bbd='$vtype' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where bbd='$vtype' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype !='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where bbd='$vtype' order by name asc"); 
	$qry2=mysqli_query($conn, "select * from customerdetailsw where bbd='$vtype' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where bbd='$vtype' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl !=NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com!='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where hpl LIKE '%$hpl%' && mfin='$mfin' order by name asc"); 
	$qry2=mysqli_query($conn, "select * from customerdetailsw where hpl='$hpl' && mfin='$mfin' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where hpl='$hpl' && mfin='$mfin' order by name asc");
							$qry4=mysqli_query($conn, "select * from customerdetailsq where hpl='$hpl' && mfin='$mfin' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype !='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com!='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where bbd='$vtype' && mfin='$mfin' order by name asc"); 
	$qry2=mysqli_query($conn, "select * from customerdetailsw where bbd='$vtype' && mfin='$mfin' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where bbd='$vtype' && mfin='$mfin' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype !='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com!='None')&&($status!='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where bbd='$vtype' && mfin='$mfin' && status='$status' order by name asc"); 
	$qry2=mysqli_query($conn, "select * from customerdetailsw where vbbd='$vtype' && mfin='$mfin' && status='$status' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where bbd='$vtype' && mfin='$mfin' && status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype !='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status!='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where bbd='$vtype' && status='$status' order by name asc"); 
	$qry2=mysqli_query($conn, "select * from customerdetailsw where bbd='$vtype' && status='$status' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where bbd='$vtype' && status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype !='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker!='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where bbd='$vtype' &&  broker='$broker' order by name asc"); 
	$qry2=mysqli_query($conn, "select * from customerdetailsw where bbd='$vtype' &&  broker='$broker' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where bbd='$vtype' &&  broker='$broker' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype !='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer!='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where bbd='$vtype' &&  dealer='$dealer' order by name asc"); 
	$qry2=mysqli_query($conn, "select * from customerdetailsw where bbd='$vtype' &&  dealer='$dealer' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where bbd='$vtype' &&  dealer='$dealer' order by name asc");
}
elseif(($area ==NULL)&&($name !=NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
    	$qry2=mysqli_query($conn, "select * from customerdetailsw where name LIKE '%$name%' order by name asc"); 
	$sql=mysqli_query($conn, "select * from customerdetails where name LIKE '%$name%' order by name asc");

	$qry3=mysqli_query($conn, "select * from customerdetailsm where name LIKE '%$name%' order by name asc");

}
elseif(($area !=NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where area LIKE '%$area%' order by name asc");
	$qry2=mysqli_query($conn, "select * from customerdetailsw where area LIKE '%$area%' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where area LIKE '%$area%' order by name asc");
										$qry4=mysqli_query($conn, "select * from customerdetailsq where area LIKE '%$area%' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno !=NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where pno LIKE '%$pno%' order by name asc");
	$qry2=mysqli_query($conn, "select * from customerdetailsw where pno LIKE '%$pno%' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where pno LIKE '%$pno%' order by name asc");
						$qry4=mysqli_query($conn, "select * from customerdetailsq where pno LIKE '%$pno%' order by name asc");
}
elseif(($area !=NULL)&&($name !=NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where area LIKE '%$area%' && name LIKE '%$name%' order by name asc");
	$qry2=mysqli_query($conn, "select * from customerdetailsw where area LIKE '%$area%' && name LIKE '%$name%' order by name asc");
						$qry3=mysqli_query($conn, "select * from customerdetailsm where area LIKE '%$area%' && name LIKE '%$name%' order by name asc");
}
elseif(($area !=NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname!='None')&&($dealer=='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where area LIKE '%$area%' && vname LIKE '%$vname%' order by name asc");
}
elseif(($area ==NULL)&&($name !=NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname!='None')&&($dealer=='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where name LIKE '%$name%' && vname LIKE '%$vname%' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname!='None')&&($dealer=='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where vname LIKE '%$vname%' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker !='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where broker LIKE '%$broker%' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid !=NULL))
{
	header("location:0fgid.php?gid=$gid");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status=='None')&&($cobname !=NULL)&&($broker=='None')&&($gid ==NULL))
{
	header("location:0fcoo.php?coo=$cobname");
}

elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL)&&($vno !=NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where vno LIKE '%$vno%' && mfin='$com' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl !=NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where hpl='$hpl' && mfin='$com' order by name asc");
	echo "ldjkhgdigh";
}
elseif(($area ==NULL)&&($name !=NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where name LIKE '%$name%' && mfin='$com' order by name asc");
}
elseif(($area !=NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where area LIKE '%$area%' && mfin='$com' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno !=NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where pno LIKE '%$pno%' && mfin='$com' order by name asc");
}
elseif(($area !=NULL)&&($name !=NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where area LIKE '%$area%' && name LIKE '%$name%' && mfin='$com' order by name asc");
}
elseif(($area !=NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname!='None')&&($dealer=='None')&&($com !='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where area LIKE '%$area%' && vname LIKE '%$vname%' && mfin='$com' order by name asc");
}
elseif(($area ==NULL)&&($name !=NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname!='None')&&($dealer=='None')&&($com !='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where name LIKE '%$name%' && vname LIKE '%$vname%' && mfin='$com' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status=='None')&&($cobname ==NULL)&&($broker !='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where broker LIKE '%$broker%' && mfin='$com' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname!='None')&&($dealer=='None')&&($com!='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where vname LIKE '%$vname%'  && mfin='$com' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid !=NULL))
{
	header("location:0fgid.php?gid=$gid");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status=='None')&&($cobname !=NULL)&&($broker=='None')&&($gid ==NULL))
{
	header("location:0fcoo.php?coo=$cobname");
}

elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL)&&($vno !=NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where vno LIKE '%$vno%' && mfin='$com' && status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl !=NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where hpl='$hpl' && mfin='$com' && status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname!='None')&&($dealer=='None')&&($com!='None')&&($status!='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where vname LIKE '%$vname%'  && mfin='$com' && status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname!='None')&&($dealer=='None')&&($com=='None')&&($status!='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where vname LIKE '%$vname%' && status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name !=NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where name LIKE '%$name%' && mfin='$com' && status='$status' order by name asc");
}
elseif(($area !=NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where area LIKE '%$area%' && mfin='$com' && status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno !=NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where pno LIKE '%$pno%' && mfin='$com' && status='$status' order by name asc");
}
elseif(($area !=NULL)&&($name !=NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where area LIKE '%$area%' && name LIKE '%$name%' && mfin='$com' && status='$status' order by name asc");
}
elseif(($area !=NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname!='None')&&($dealer=='None')&&($com !='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where area LIKE '%$area%' && vname LIKE '%$vname%' && mfin='$com' && status='$status' order by name asc");
}
elseif(($area !=NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno !=NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where area LIKE '%$area%' && vno LIKE '%$vno%' && mfin='$com' && status='$status' order by name asc");
}
elseif(($area !=NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno !=NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status =='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where area LIKE '%$area%' && vno LIKE '%$vno%' && mfin='$com' order by name asc");
}
elseif(($area !=NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno !=NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com =='None')&&($status =='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where area LIKE '%$area%' && vno LIKE '%$vno%' order by name asc");
}
elseif(($area !=NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno !=NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com =='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where area LIKE '%$area%' && vno LIKE '%$vno%' && status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name !=NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname!='None')&&($dealer=='None')&&($com !='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where name LIKE '%$name%' && vname LIKE '%$vname%' && mfin='$com' && status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status !='None')&&($cobname ==NULL)&&($broker !='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where broker LIKE '%$broker%' && mfin='$com' && status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid !=NULL))
{
	header("location:0fgid.php?gid=$gid");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status !='None')&&($cobname !=NULL)&&($broker=='None')&&($gid ==NULL))
{
	header("location:0fcoo.php?coo=$cobname");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL)&&($vno !=NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where vno LIKE '%$vno%' &&  status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl !=NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where hpl='$hpl' &&  status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name !=NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where name LIKE '%$name%' &&  status='$status' order by name asc");
}
elseif(($area !=NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where area LIKE '%$area%' &&  status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno !=NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where pno LIKE '%$pno%' &&  status='$status' order by name asc");
}
elseif(($area !=NULL)&&($name !=NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where area LIKE '%$area%' && name LIKE '%$name%' &&  status='$status' order by name asc");
}
elseif(($area !=NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname!='None')&&($dealer=='None')&&($com=='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where area LIKE '%$area%' && vname LIKE '%$vname%' &&  status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name !=NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname!='None')&&($dealer=='None')&&($com=='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where name LIKE '%$name%' && vname LIKE '%$vname%' &&  status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer!='None')&&($com=='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where dealer LIKE '%$dealer%' &&  status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer!='None')&&($com!='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where dealer LIKE '%$dealer%' &&  status='$status' &&  mfin='$com' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer!='None')&&($com=='None')&&($status =='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where dealer LIKE '%$dealer%' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status !='None')&&($cobname ==NULL)&&($broker !='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where broker LIKE '%$broker%' &&  status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid !=NULL))
{
	header("location:0fgid.php?gid=$gid");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status !='None')&&($cobname !=NULL)&&($broker=='None')&&($gid ==NULL))
{
	header("location:0fcoo.php?coo=$cobname");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com=='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
	$sql=mysqli_query($conn, "select * from customerdetails where status='$status' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status=='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
		$sql=mysqli_query($conn, "select * from customerdetails where mfin='$com' order by name asc");
		$qry2=mysqli_query($conn, "select * from customerdetailsw where mfin='$com' order by name asc");
		$qry3=mysqli_query($conn, "select * from customerdetailsm where mfin='$com' order by name asc");
}
elseif(($area ==NULL)&&($name ==NULL)&&($hpl ==NULL)&&($vtype =='None')&&($vno ==NULL)&&($pno ==NULL)&&($vname=='None')&&($dealer=='None')&&($com !='None')&&($status !='None')&&($cobname ==NULL)&&($broker=='None')&&($gid ==NULL))
{
		$sql=mysqli_query($conn, "select * from customerdetails where mfin='$com' && status='$status' order by name asc");
}
else {
	header("location:all2.php");
}



$n = mysqli_num_rows($sql);
 
						?></p>
					<div class="table-responsive">

					<?php 
					while($row=mysqli_fetch_array($sql))
						{
							$mfin2 = $row['mfin'];
							$hpl = $row['hpl'];
							$sql333 = mysqli_query($conn, "select * from pending where mfin='$mfin2' && hpl='$hpl'");
							$row333 = mysqli_fetch_array($sql333);
							
							
							$ssd = $row['pno'];
							$sql3333 = mysqli_query($conn, "select * from entry where pno='$ssd'");
							$row3333 = mysqli_fetch_array($sql3333);
							
							
							
					?>
					 <div class="col-md-4 col-lg-4 col-sm-4 col-xs-12 profile_details">
                        <div class="well profile_view">
                          <div class="col-sm-12">
                            <h1 class="brief"><i><b>Loan No - <?php echo $row['hpl'];?></b></i></h1>
                            <div class="left col-xs-7">
                              <h2><b><?php echo $row['name'];?></b></h2>
                              <h2><strong><b>C.ID: </strong> <?php echo $row['hplt'];?></b> </h2>
                              <ul class="list-unstyled">
                                <li><i class="fa fa-building"></i> <?php echo $row['vname'];?></li>
				<li><i class="fa fa-calender"></i>Loan Date :  <?php echo $row['hpdate'];?></li>
				<li><i class="fa fa-inr"></i>Loan Amt :  <?php echo $row['totalhpamt'];?></li>
				<li><i class="fa fa-inr"></i>Due :  <?php echo $row['duemnt'];?></li>
				<li><i class="fa fa-inr"></i>Due Amt :  <?php echo $row['total'];?></li>
				<li><i class="fa fa-inr"></i>Pending :  <?php echo $row333['penamt'];?> (<?php echo $row333['pendmnt'];?> dues)				</li>
	<li><i class="fa fa-inr"></i>Area :  <?php echo $row['model'];?></li>
		<li><i class="fa fa-inr"></i>Sub Area:  <?php echo $row['area'];?></li>
                                <li><i class="fa fa-phone"></i> Phone #: <?php echo $row['pno'];?> </br>
								<?php echo  $fin = $row['mfin']; 
						
						?></li>
                              </ul>
                            </div>
                            <div class="right col-xs-5 text-center">
				<?php $imgg = $row3333['uimg']; 
if($imgg != NULL) { 
?>
<img class="img-circle img-responsive" src="user/<?php echo $row3333['uimg']; ?>" alt="Avatar" title="Change the avatar">
<?php } 
else{ 
?>
                          <img class="img-circle img-responsive" src="us.jpg" alt="Avatar" title="Change the avatar">
<?php } ?>
                            </div>
                          </div>
                          <div class="col-xs-12 bottom text-center">
                            <div class="col-xs-12 col-sm-12 emphasis">
           
                            
								<?php		$ss = $row['status'];
	if($ss == 'Closed') {
						?>
				<td><button class="btn btn-warning"><b>Closed</b></button>
								<button class="btn btn-warning"><b>Daily</b></button>
				</td>
	<td>

<a href="editled.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Led Edit!"><i class="fa fa-edit fa-2x" style="color:blue;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="reloan5.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Clone!"><i class="fa fa-clone fa-2x" style="color:black;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="udelete.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="Full View!"><i class="fa fa-feed fa-2x" style="color:navi;" aria-hidden="true"></i></a>
&nbsp;&nbsp;	<a href="udeletenew.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="New Full View!"><i class="fa fa-book fa-2x" style="color:navi;" aria-hidden="true"></i></a>

		<?php $ff = $row['lat']; if($ff>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['lat'];?>,<?php echo $row['lang'];?>"  data-toggle="tooltip" title="Google Map !" title="Full View!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:purple;" aria-hidden="true"></i></a> <?php } ?>
	</td>
				<?php }
elseif($ss == 'Reloan') { ?>
				
				<td><button class="btn btn-warning"><b>Closed-R</b></button></td> 
	<td>
<a href="editled.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Led Edit!"><i class="fa fa-edit fa-2x" style="color:blue;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="reloan5.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Clone!"><i class="fa fa-clone fa-2x" style="color:black;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="udelete.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="Full View!"><i class="fa fa-feed fa-2x" style="color:navi;" aria-hidden="true"></i></a>
&nbsp;&nbsp;	<a href="udeletenew.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="New Full View!"><i class="fa fa-book fa-2x" style="color:navi;" aria-hidden="true"></i></a>

		<?php $ff = $row['lat']; if($ff>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['lat'];?>,<?php echo $row['lang'];?>"  data-toggle="tooltip" title="Google Map !" title="Full View!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:purple;" aria-hidden="true"></i></a> <?php } ?>
	</td>
				<?php }
				elseif($ss == 'Sized') { ?>
				
				<td><button class="btn btn-danger"><b>Seized</b></button></td>
			<td>
<a href="registerf2.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Receipt!"><i class="fa fa-print fa-2x"  style="color:green;" aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="editled.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Led Edit!"><i class="fa fa-edit fa-2x" style="color:blue;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="fullsettle2.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Full Settlement!"><i class="fa fa-close fa-2x" style="color:red;"  aria-hidden="true"></i></a>&nbsp;&nbsp;	
<a href="reloan2.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Reloan!"><i class="fa fa-random fa-2x" style="color:Maroon;"  aria-hidden="true"></i></a>&nbsp;&nbsp;		
<a href="reloan5.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Clone!"><i class="fa fa-clone fa-2x" style="color:black;"  aria-hidden="true"></i></a>&nbsp;&nbsp;			

<a href="udelete.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="Full View!"><i class="fa fa-feed fa-2x" style="color:navi;" aria-hidden="true"></i></a>
&nbsp;&nbsp;	<a href="udeletenew.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="New Full View!"><i class="fa fa-book fa-2x" style="color:navi;" aria-hidden="true"></i></a>

		<?php $ff = $row['lat']; if($ff>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['lat'];?>,<?php echo $row['lang'];?>"  data-toggle="tooltip" title="Google Map !" title="Full View!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:purple;" aria-hidden="true"></i></a> <?php } ?>
	</td>
				<?php } else {?>
				<td><button class="btn btn-success"><b>Active</b></button>
				<button class="btn btn-warning"><b>Daily</b></button>
				</td> 
				
					<td>
<a href="mobm.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Receipt!"><i class="fa fa-print fa-2x"  style="color:green;" aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="editled.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Led Edit!"><i class="fa fa-edit fa-2x" style="color:blue;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="fullsettle2.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Full Settlement!"><i class="fa fa-close fa-2x" style="color:red;"  aria-hidden="true"></i></a>&nbsp;&nbsp;	<!--
<a href="reloan2.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Reloan!"><i class="fa fa-random fa-2x" style="color:Maroon;"  aria-hidden="true"></i></a>&nbsp;&nbsp;	
<a href="reloan5.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Clone!"><i class="fa fa-clone fa-2x" style="color:black;"  aria-hidden="true"></i></a>&nbsp;&nbsp;			
<a href="netamta.php?hpl=<?php echo $row['hpl'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Add Seize List!"><i class="fa fa-motorcycle fa-2x" style="color:orange;"  aria-hidden="true"></i></a>&nbsp;&nbsp;	
-->
<a href="udelete.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="Full View!"><i class="fa fa-feed fa-2x" style="color:navi;" aria-hidden="true"></i></a>
&nbsp;&nbsp;	<a href="udeletenew.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="New Full View!"><i class="fa fa-book fa-2x" style="color:navi;" aria-hidden="true"></i></a>

		<?php $ff = $row['lat']; if($ff>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['lat'];?>,<?php echo $row['lang'];?>"  data-toggle="tooltip" title="Google Map !" title="Map Home!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:purple;" aria-hidden="true"></i></a> <?php } ?>
		
			<?php $ff2 = $row['latw']; if($ff2>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['latw'];?>,<?php echo $row['langw'];?>"  data-toggle="tooltip" title="Google Map !" title="Map Work!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:green;" aria-hidden="true"></i></a> <?php } ?>
			
	</td>
				<?php }?>
				
                          </div>
                        </div>
                      </div>
					   </div>
				
					<?php
						}
			


					while($row=mysqli_fetch_array($qry3))
						{
							$mfin2 = $row['mfin'];
							$hpl = $row['hpl'];
							$sql333 = mysqli_query($conn, "select * from pending where mfin='$mfin2' && hpl='$hpl'");
							$row333 = mysqli_fetch_array($sql333);
					?>
					 <div class="col-md-4 col-sm-4 col-xs-12 profile_details">
                        <div class="well profile_view">
                          <div class="col-sm-12">
                            <h1 class="brief"><i><b>Loan No - <?php echo $row['hpl'];?></b></i></h1>
                            <div class="left col-xs-7">
                              <h2><b><?php echo $row['name'];?></b></h2>
                              <h2><strong><b>C.ID: </strong> <?php echo $row['hplt'];?></b> </h2>
                              <ul class="list-unstyled">
                                <li><i class="fa fa-building"></i> <?php echo $row['vname'];?></li>
				<li><i class="fa fa-calender"></i>Loan Date :  <?php echo $row['hpdate'];?></li>
				<li><i class="fa fa-inr"></i>Loan Amt :  <?php echo $row['totalhpamt'];?></li>
				<li><i class="fa fa-inr"></i>Due :  <?php echo $row['duemnt'];?></li>
				<li><i class="fa fa-inr"></i>Due Amt :  <?php echo $row['total'];?></li>
				<li><i class="fa fa-inr"></i>Pending :  <?php echo $row333['penamt'];?> (<?php echo $row333['pendmnt'];?> dues)				</li>
	<li><i class="fa fa-inr"></i>Area :  <?php echo $row['model'];?></li>
		<li><i class="fa fa-inr"></i>Sub Area:  <?php echo $row['area'];?></li>
                                <li><i class="fa fa-phone"></i> Phone #: <?php echo $row['pno'];?> </br>
								<?php echo  $fin = $row['mfin']; 
						
						?></li>
                              </ul>
                            </div>
                            <div class="right col-xs-5 text-center">
				<?php $imgg = $row['uimg']; 
if($imgg != NULL) { 
?>
<img class="img-circle img-responsive" src="user/<?php echo $row['uimg']; ?>" alt="Avatar" title="Change the avatar">
<?php } 
else{ 
?>
                          <img class="img-circle img-responsive" src="us.jpg" alt="Avatar" title="Change the avatar">
<?php } ?>
                            </div>
                          </div>
                          <div class="col-xs-12 bottom text-center">
                            <div class="col-xs-12 col-sm-12 emphasis">
           
                            
								<?php		$ss = $row['status'];
	if($ss == 'Closed') {
						?>
				<td><button class="btn btn-warning"><b>Closed</b></button><button class="btn btn-warning"><b>Monthly</b></button></td>
	<td>

<a href="editled.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Led Edit!"><i class="fa fa-edit fa-2x" style="color:blue;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="reloan5.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Clone!"><i class="fa fa-clone fa-2x" style="color:black;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="udelete.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="Full View!"><i class="fa fa-feed fa-2x" style="color:navi;" aria-hidden="true"></i></a>
&nbsp;&nbsp;	<a href="udeletenew.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="New Full View!"><i class="fa fa-book fa-2x" style="color:navi;" aria-hidden="true"></i></a>

		<?php $ff = $row['lat']; if($ff>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['lat'];?>,<?php echo $row['lang'];?>"  data-toggle="tooltip" title="Google Map !" title="Full View!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:purple;" aria-hidden="true"></i></a> <?php } ?>
	</td>
				<?php }
elseif($ss == 'Reloan') { ?>
				
				<td><button class="btn btn-warning"><b>Closed-R</b></button></td> 
	<td>
<a href="editled.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Led Edit!"><i class="fa fa-edit fa-2x" style="color:blue;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="reloan5.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Clone!"><i class="fa fa-clone fa-2x" style="color:black;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="udelete.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="Full View!"><i class="fa fa-feed fa-2x" style="color:navi;" aria-hidden="true"></i></a>
&nbsp;&nbsp;	<a href="udeletenew.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="New Full View!"><i class="fa fa-book fa-2x" style="color:navi;" aria-hidden="true"></i></a>

		<?php $ff = $row['lat']; if($ff>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['lat'];?>,<?php echo $row['lang'];?>"  data-toggle="tooltip" title="Google Map !" title="Full View!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:purple;" aria-hidden="true"></i></a> <?php } ?>
	</td>
				<?php }
				elseif($ss == 'Sized') { ?>
				
				<td><button class="btn btn-danger"><b>Seized</b></button></td>
			<td>
<a href="mobme.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Receipt!"><i class="fa fa-print fa-2x"  style="color:green;" aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="editled.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Led Edit!"><i class="fa fa-edit fa-2x" style="color:blue;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="fullsettle2e.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Full Settlement!"><i class="fa fa-close fa-2x" style="color:red;"  aria-hidden="true"></i></a>&nbsp;&nbsp;	
<a href="reloan2.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Reloan!"><i class="fa fa-random fa-2x" style="color:Maroon;"  aria-hidden="true"></i></a>&nbsp;&nbsp;		
<a href="reloan5.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Clone!"><i class="fa fa-clone fa-2x" style="color:black;"  aria-hidden="true"></i></a>&nbsp;&nbsp;			

<a href="udelete.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="Full View!"><i class="fa fa-feed fa-2x" style="color:navi;" aria-hidden="true"></i></a>
&nbsp;&nbsp;	<a href="udeletenew.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="New Full View!"><i class="fa fa-book fa-2x" style="color:navi;" aria-hidden="true"></i></a>

		<?php $ff = $row['lat']; if($ff>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['lat'];?>,<?php echo $row['lang'];?>"  data-toggle="tooltip" title="Google Map !" title="Full View!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:purple;" aria-hidden="true"></i></a> <?php } ?>
	</td>
				<?php } else {?>
				<td><button class="btn btn-success"><b>Active</b></button>
				<button class="btn btn-warning"><b>Monthly</b></button>
				</td> 
				
					<td>
<a href="mobme.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Receipt!"><i class="fa fa-print fa-2x"  style="color:green;" aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="editledm.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Led Edit!"><i class="fa fa-edit fa-2x" style="color:blue;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="fullsettle2m.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Full Settlement!"><i class="fa fa-close fa-2x" style="color:red;"  aria-hidden="true"></i></a>&nbsp;&nbsp;	<!--
<a href="reloan2.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Reloan!"><i class="fa fa-random fa-2x" style="color:Maroon;"  aria-hidden="true"></i></a>&nbsp;&nbsp;	
<a href="reloan5.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Clone!"><i class="fa fa-clone fa-2x" style="color:black;"  aria-hidden="true"></i></a>&nbsp;&nbsp;			
<a href="netamta.php?hpl=<?php echo $row['hpl'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Add Seize List!"><i class="fa fa-motorcycle fa-2x" style="color:orange;"  aria-hidden="true"></i></a>&nbsp;&nbsp;	
-->
<a href="udeletem.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="Full View!"><i class="fa fa-feed fa-2x" style="color:navi;" aria-hidden="true"></i></a>
&nbsp;&nbsp;	<a href="udeletenewm.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="New Full View!"><i class="fa fa-book fa-2x" style="color:navi;" aria-hidden="true"></i></a>

		<?php $ff = $row['lat']; if($ff>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['lat'];?>,<?php echo $row['lang'];?>"  data-toggle="tooltip" title="Google Map !" title="Map Home!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:purple;" aria-hidden="true"></i></a> <?php } ?>
		
			<?php $ff2 = $row['latw']; if($ff2>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['latw'];?>,<?php echo $row['langw'];?>"  data-toggle="tooltip" title="Google Map !" title="Map Work!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:green;" aria-hidden="true"></i></a> <?php } ?>
			
	</td>
				<?php }?>
				
                          </div>
                        </div>
                      </div>
					   </div>
				
					<?php
						} ?>
					
						
						
						
						
						<?php 
					while($row=mysqli_fetch_array($qry2))
						{
							$mfin2 = $row['mfin'];
							$hpl = $row['hpl'];
							$sql333w = mysqli_query($conn, "select * from pendingw where mfin='$mfin2' && hpl='$hpl'");
							$row333w = mysqli_fetch_array($sql333w);
					?>
					 <div class="col-md-4 col-sm-4 col-xs-12 profile_details">
                        <div class="well profile_view">
                          <div class="col-sm-12">
                            <h1 class="brief"><i><b>Loan No - <?php echo $row['hpl'];?></b></i></h1>
                            <div class="left col-xs-7">
                              <h2><b><?php echo $row['name'];?></b></h2>
                              <h2><strong><b>C.ID: </strong> <?php echo $row['hplt'];?></b> </h2>
                              <ul class="list-unstyled">
                                <li><i class="fa fa-building"></i> <?php echo $row['vname'];?></li>
				<li><i class="fa fa-calender"></i>Loan Date :  <?php echo $row['hpdate'];?></li>
				<li><i class="fa fa-inr"></i>Loan Amt :  <?php echo $row['totalhpamt'];?></li>
				<li><i class="fa fa-inr"></i>Due :  <?php echo $row['duemnt'];?></li>
				<li><i class="fa fa-inr"></i>Due Amt :  <?php echo $row['total'];?></li>
				<li><i class="fa fa-inr"></i>Pending :  <?php echo $row333w['penamt'];?> ( <?php echo $row333w['pendmnt']; ?> dues)				</li>
					<li><i class="fa fa-inr"></i>Area :  <?php echo $row['model'];?></li>
		<li><i class="fa fa-inr"></i>Sub Area:  <?php echo $row['area'];?></li>
                <li><i class="fa fa-phone"></i> Phone #: <?php echo $row['pno'];?> </br>
								<?php echo  $fin = $row['mfin']; ?></li>
                              </ul>
                            </div>
                            <div class="right col-xs-5 text-center">
				<?php $imgg = $row['uimg']; 
if($imgg != NULL) { 
?>
<img class="img-circle img-responsive" src="user/<?php echo $row['uimg']; ?>" alt="Avatar" title="Change the avatar">
<?php } 
else{ 
?>
                          <img class="img-circle img-responsive" src="us.jpg" alt="Avatar" title="Change the avatar">
<?php } ?>
                            </div>
                          </div>
                          <div class="col-xs-12 bottom text-center">
                            <div class="col-xs-12 col-sm-12 emphasis">
           
                            
								<?php		$ss = $row['status'];
	if($ss == 'Closed') {
						?>
				<td><button class="btn btn-warning"><b>Closed</b></button><button class="btn btn-warning"><b>Weekly</b></button></td>
	<td>

<a href="editledw.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Led Edit!"><i class="fa fa-edit fa-2x" style="color:blue;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="reloan5w.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Clone!"><i class="fa fa-clone fa-2x" style="color:black;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="udeletew.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="Full View!"><i class="fa fa-feed fa-2x" style="color:navi;" aria-hidden="true"></i></a>
&nbsp;&nbsp;	<a href="udeleteneww.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="New Full View!"><i class="fa fa-book fa-2x" style="color:navi;" aria-hidden="true"></i></a>

		<?php $ff = $row['lat']; if($ff>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['lat'];?>,<?php echo $row['lang'];?>"  data-toggle="tooltip" title="Google Map !" title="Full View!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:purple;" aria-hidden="true"></i></a> <?php } ?>
	</td>
				<?php }
elseif($ss == 'Reloan') { ?>
				
				<td><button class="btn btn-warning"><b>Closed-R</b></button></td> 
	<td>
<a href="editled.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Led Edit!"><i class="fa fa-edit fa-2x" style="color:blue;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="reloan5.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Clone!"><i class="fa fa-clone fa-2x" style="color:black;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="udelete.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="Full View!"><i class="fa fa-feed fa-2x" style="color:navi;" aria-hidden="true"></i></a>
&nbsp;&nbsp;	<a href="udeletenew.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="New Full View!"><i class="fa fa-book fa-2x" style="color:navi;" aria-hidden="true"></i></a>

		<?php $ff = $row['lat']; if($ff>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['lat'];?>,<?php echo $row['lang'];?>"  data-toggle="tooltip" title="Google Map !" title="Full View!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:purple;" aria-hidden="true"></i></a> <?php } ?>
	</td>
				<?php }
				elseif($ss == 'Sized') { ?>
				
				<td><button class="btn btn-danger"><b>Seized</b></button></td>
			<td>
<a href="registerf2.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Receipt!"><i class="fa fa-print fa-2x"  style="color:green;" aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="editled.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Led Edit!"><i class="fa fa-edit fa-2x" style="color:blue;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="fullsettle2.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Full Settlement!"><i class="fa fa-close fa-2x" style="color:red;"  aria-hidden="true"></i></a>&nbsp;&nbsp;	
<a href="reloan2.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Reloan!"><i class="fa fa-random fa-2x" style="color:Maroon;"  aria-hidden="true"></i></a>&nbsp;&nbsp;		
<a href="reloan5.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Clone!"><i class="fa fa-clone fa-2x" style="color:black;"  aria-hidden="true"></i></a>&nbsp;&nbsp;			

<a href="udelete.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="Full View!"><i class="fa fa-feed fa-2x" style="color:navi;" aria-hidden="true"></i></a>
&nbsp;&nbsp;	<a href="udeletenew.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="New Full View!"><i class="fa fa-book fa-2x" style="color:navi;" aria-hidden="true"></i></a>

		<?php $ff = $row['lat']; if($ff>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['lat'];?>,<?php echo $row['lang'];?>"  data-toggle="tooltip" title="Google Map !" title="Full View!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:purple;" aria-hidden="true"></i></a> <?php } ?>
	</td>
				<?php } else {?>
				<td><button class="btn btn-success"><b>Active</b></button>
				<button class="btn btn-warning"><b>Weekly</b></button>
				</td> 
				
					<td>
<a href="mobw.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Receipt!"><i class="fa fa-print fa-2x"  style="color:green;" aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="editledw.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Led Edit!"><i class="fa fa-edit fa-2x" style="color:blue;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="fullsettle2w.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Full Settlement!"><i class="fa fa-close fa-2x" style="color:red;"  aria-hidden="true"></i></a>&nbsp;&nbsp;	<!--
<a href="reloan2.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Reloan!"><i class="fa fa-random fa-2x" style="color:Maroon;"  aria-hidden="true"></i></a>&nbsp;&nbsp;	
<a href="reloan5.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Clone!"><i class="fa fa-clone fa-2x" style="color:black;"  aria-hidden="true"></i></a>&nbsp;&nbsp;			
<a href="netamta.php?hpl=<?php echo $row['hpl'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Add Seize List!"><i class="fa fa-motorcycle fa-2x" style="color:orange;"  aria-hidden="true"></i></a>&nbsp;&nbsp;	
-->
<a href="udeletew.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="Full View!"><i class="fa fa-feed fa-2x" style="color:navi;" aria-hidden="true"></i></a>
&nbsp;&nbsp;	<a href="udeleteneww.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="New Full View!"><i class="fa fa-book fa-2x" style="color:navi;" aria-hidden="true"></i></a>

		<?php $ff = $row['lat']; if($ff>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['lat'];?>,<?php echo $row['lang'];?>"  data-toggle="tooltip" title="Google Map !" title="Map Home!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:purple;" aria-hidden="true"></i></a> <?php } ?>
		
			<?php $ff2 = $row['latw']; if($ff2>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['latw'];?>,<?php echo $row['langw'];?>"  data-toggle="tooltip" title="Google Map !" title="Map Work!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:green;" aria-hidden="true"></i></a> <?php } ?>
			
	</td>
				<?php }?>
				
                          </div>
                        </div>
                      </div>
					   </div>
				
					<?php
						} 
						
						
						
					?>
					
					<?php 
					while($row=mysqli_fetch_array($qry4))
						{
							$mfin2 = $row['mfin'];
					?>
					
				<tr>
				
						<td><b><?php echo $row['hpl'];?></b></td>
						<td><b><?php echo $row['name']; ?></b></td>	
						
				<td><b><?php $fin = $row['mfin']; 
						$sql44 = mysqli_query($conn, "select * from mfin where name='$fin'");
						$row44 = mysqli_fetch_array($sql44);
						echo $row44['name2'];
						?></b></td>
								<?php $dddd = $row['uimg']; if($dddd!= NULL) { ?>	<td><img src="user/<?php echo $row['uimg'];?>" width="40" height="40"/></td> <?php } else { ?>
					<td><img src="111.png" width="40" height="40"/></td> <?php } ?>
					
						
						
					
					
		
			
				<td><a href="mobw.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Receipt!"><button class="btn btn-info"><b>Weekly Col</b></a></button>			
				</td>
					<td>
<a href="mobq.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" ><i class="fa fa-print fa-2x"  style="color:green;" aria-hidden="true"></i></a>&nbsp;&nbsp;


<a href="editledq.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Led Edit!"><i class="fa fa-edit fa-2x" style="color:blue;"  aria-hidden="true"></i></a>&nbsp;&nbsp;
<a href="reloan5q.php?id=<?php echo $row['id'];?>&mfin=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Clone!"><i class="fa fa-clone fa-2x" style="color:red;"  aria-hidden="true"></i></a>&nbsp;&nbsp;			
<a href="udeleteq.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="Full View!"><i class="fa fa-feed fa-2x" style="color:blue;" aria-hidden="true"></i></a>
		<?php $ff = $row['lat']; if($ff>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['lat'];?>,<?php echo $row['lang'];?>"  data-toggle="tooltip" title="Google Map !" title="Map Home!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:purple;" aria-hidden="true"></i></a> <?php } ?>
		
			<?php $ff2 = $row['latw']; if($ff2>0) { ?>	<a href="https://www.google.com/maps/?q=<?php echo $row['latw'];?>,<?php echo $row['langw'];?>"  data-toggle="tooltip" title="Google Map !" title="Map Work!" target="_blank"><i class="fa fa-map-marker fa-2x" style="color:green;" aria-hidden="true"></i></a> <?php } ?>
	</td>
	
		
			
			<td><b><?php echo $row['pno'];?></b></td>
						<td><b><?php echo $row['totalhpamt'];?></b></td><td><b><?php echo $row['hpdate'];?></b></td>
						
					</tr>
					<?php
						} 
						
						
						
					?>
				</tbody>	</table>
					
 
</div>
</div></div>
</div></div></div> <?php include "layouts/footert.php"; ?> </body></html>