";
$sql33AA ="SELECT * FROM $table_name36001 WHERE customer_id = '$cust_id44' AND type_id='100' AND status ='1' ";
$result33A = @mysqli_query($connection,$sql33AA) or die(mysqli_error($connection));
$num33A = mysqli_num_rows($result33A);
if ($num33A >0){
$num_app_sub_mit[$leader_id1]=$num_app_sub_mit[$leader_id1]+1;
$hap2=$hap2+1;
}
$sq112abSz="SELECT * FROM $db_name.$table_name41 WHERE customer_id ='$cust_id44' ";
$result112abz = @mysqli_query($connection,$sq112abSz) or die(mysqli_error($connection));
$num3334bT29z = mysqli_num_rows($result112abz);
if ($num3334bT29z>0) {
$result222abT9z = @mysqli_query($connection,$sq112abSz) or die(mysqli_error($connection));
while ($row1bSz = mysqli_fetch_array($result222abT9z)) {
///$order7= stripslashes($row1bS['product_id']);
$order7= $row1bSz['order_id'];
$first7= $row1bSz['firstname'];
$last7= $row1bSz['lastname'];
//echo "$cust_id44 $first7 $last7
";
$sq112abS1z="SELECT * FROM $db_name.$table_name47 WHERE order_id ='$order7' AND product_id ='$Prod11[$leader_id1]'";
$result112ab1z = @mysqli_query($connection,$sq112abS1z) or die(mysqli_error($connection));
$num3334bT291z = mysqli_num_rows($result112ab1z);
if ($num3334bT291z>0) {
$sq112abS1ac="SELECT * FROM $db_name.$table_name42 WHERE order_id ='$order7' AND order_status_id > '0'";
$result112ab1ac = @mysqli_query($connection,$sq112abS1ac) or die(mysqli_error($connection));
$num3334bT291ac = mysqli_num_rows($result112ab1ac);
if ($num3334bT291ac>0) {
$hap1=$hap1+1;
$countPayPeops[$leader_id1]=$countPayPeops[$leader_id1]+1;
//echo "l=$leader_id1 - order_id-$order7 - $first7 $last7 - $cust_id44 - $hap s=$hap2 -p=$hap1
";
$first7='';
$last7='';
}
}
} //while
} //if
}
// $countPayPeops[$leader_id1]= $countPayPeops[$leader_id1]+2;
//$num_app_sub_mit[$leader_id1]= $num_app_sub_mit[$leader_id1]+2;
//$countPeops[$leader_id1]=+$countPeops[$leader_id1]+2;
$countText .=" | $namePA[$leader_id1] | $countPeops[$leader_id1] |
$countPayPeops[$leader_id1] |
$num_app_sub_mit[$leader_id1] |
";
// $last_id= $row112ab['lastname'];
// $display_listCGPA .= "";
}
$countText=" | Accounts (Includes Active and NonActive) | #Apps Paid | #Apps Submitted |
$countText
";
?>