";
///
//Mark:
$CCstatus[0]="Not Completed";
$CCstatus[1]="Completed";
$CCstatus[-1]="Withdrawn";
$CCstatus[-2]="Credits Transferred";
////
// $product_id=171;
$path=89; //deletes from customer
if ($jedID2==436){
$map_id=$_POST['pnum'];
$sql33a800 ="Delete FROM $table_name36 WHERE customer_id='$map_id'";
//$result33a800 = @mysqli_query($connection,$sql33a800) or die(mysqli_error($connection));
$viewmail="
Record $map_id has been deleted.
";
$bob2=2;
$jedID2=$bob2;
}
if ($jedID2==19536){
//$cust_id2=$_POST['pnum'];
$class_id=$_POST['classSS'];
$status=1;
$approver="$Aname $Fname ";
//$sql2 = "UPDATE $table_name36 SET salesrep_id='$newagent_id' WHERE customer_id= '$cust_id2' ";
//$sq112abS1acy="SELECT * FROM $table_name36001 WHERE customer_id ='cust_id' AND address_id= '$catproduct9' AND type_id='900' AND status='1' AND date_added between '$startd' AND '$finishd' ";
$sql2 = "INSERT INTO $table_name36001 (customer_id, date_added, address_id, type_id,status, address_1st, name ) VALUES ('$cust_id', '$Rtoday', '$class_id', '900', '$status' , '$approver', 'COMP' )";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
$viewmail="
Record Assignment has been updated.
";
$bob2=0;
$jedID2=$bob2;
}
if ($jedID2==8536){
//$cust_id2=$_POST['pnum'];
$class_id=$_POST['classSS'];
$status=1;
//Mark:
//$CCstatus[$Bstatus]
if (isset($_POST['status'])) {
$status=$_POST['status'];
if($status==-3){
$status=0;
}
}
$approver="$Aname $Fname ";
$sql33cat1s ="SELECT * FROM $table_name36001 where customer_id='$cust_id' AND address_id='$class_id' AND type_id='900' AND date_added between '$startd' AND '$finishd' ";
$result112ab = @mysqli_query($connection,$sql33cat1s) or die(mysqli_error($connection));
while ($row112ab = mysqli_fetch_array($result112ab)) {
$pro_id=$row112ab['pro_id'];
$sql2 = "UPDATE $table_name36001 SET approved='99', address_1st='$approver' WHERE pro_id= '$pro_id' ";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
}
//$sql2 = "UPDATE $table_name36 SET salesrep_id='$newagent_id' WHERE customer_id= '$cust_id2' ";
//$sq112abS1acy="SELECT * FROM $table_name36001 WHERE customer_id ='cust_id' AND address_id= '$catproduct9' AND type_id='900' AND status='1' AND date_added between '$startd' AND '$finishd' ";
$sql2 = "INSERT INTO $table_name36001 (customer_id, date_added, address_id, type_id,status, address_1st ) VALUES ('$cust_id', '$Rtoday', '$class_id', '900', '$status' , '$approver' )";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
$viewmail="
Record Assignment has been updated.
";
$bob2=0;
$jedID2=$bob2;
}
if ($jedID2==9536){
//$cust_id2=$_POST['pnum'];
$pro_id=$_POST['pro_id'];
$status=1;
$approver="$Aname $Fname ";
$sql2 = "UPDATE $table_name36001 SET status='0', address_1st='$approver' WHERE pro_id= '$pro_id' ";
//$sq112abS1acy="SELECT * FROM $table_name36001 WHERE customer_id ='cust_id' AND address_id= '$catproduct9' AND type_id='900' AND status='1' AND date_added between '$startd' AND '$finishd' ";
//$sql2 = "INSERT INTO $table_name36001 (customer_id, date_added, address_id, type_id,status, approver ) VALUES ('$cust_id', '$Rtoday', '$class_id', '900', '$status' , '$approver' )";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
$viewmail="
Record Assignment has been updated.
";
$bob2=0;
$jedID2=$bob2;
}
$display_listCGP='';
$sq112ab="SELECT * FROM $table_name362 ORDER BY name";
$result112ab = @mysqli_query($connection,$sq112ab) or die(mysqli_error($connection));
while ($row112ab = mysqli_fetch_array($result112ab)) {
$leader_id1= $row112ab['customer_group_id'];
$first_id= $row112ab['name'];
$first_id=stripslashes($first_id);
$first_id=htmlspecialchars_decode($first_id);
$first_id=mb_convert_encoding($first_id, "HTML-ENTITIES");
// $last_id= $row112ab['lastname'];
$nameP[$leader_id1]="$first_id";
$display_listCGP .= "";
}
if ($jedID2==5360){
$cust_id2=$_POST['pnum'];
$newagent_id=$_POST['Cgroup_id'];
$sql2 = "UPDATE $table_name36 SET customer_group_id='$newagent_id' WHERE customer_id= '$cust_id2' ";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
$viewmail="
Record $cust_id2 has been assigned to $nameP[$newagent_id].
";
$bob2=2;
$jedID2=$bob2;
}
if ($jedID2==53600){
$cust_id2=$_POST['pnum'];
$newagent_id=$_POST['ACgroup_id'];
$sql2 = "UPDATE $table_name36 SET status='$newagent_id' WHERE customer_id= '$cust_id2' ";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
$viewmail="
Record $cust_id2 has been assigned to $cativeG[$newagent_id].
";
$bob2=2;
$jedID2=$bob2;
}
$display_listCAT='';
$sq112ab="SELECT * FROM $table_name2001 ORDER BY name";
///echo $sq112ab;
$result112ab = @mysqli_query($connection,$sq112ab) or die(mysqli_error($connection));
while ($row112ab = mysqli_fetch_array($result112ab)) {
$leader_id1= $row112ab['category_id'];
///echo $leader_id1;
$first_id= $row112ab['name'];
$first_id=stripslashes($first_id);
$first_id=htmlspecialchars_decode($first_id);
$first_id=mb_convert_encoding($first_id, "HTML-ENTITIES");
// $last_id= $row112ab['lastname'];
$sq112ab556="SELECT * FROM $table_name2000 where category_id='$leader_id1' AND status>0";
$result112ab556 = @mysqli_query($connection,$sq112ab556) or die(mysqli_error($connection));
$num331a556 = mysqli_num_rows($result112ab556);
if ($num331a556>0) {
$nameCAT[$leader_id1]="$first_id";
$display_listCAT .= "";
}
}
if( $jedID2==0){
$listcreditsA='';
$listcredits='';
$CAT_id=$categ;
$dd=0;
$sql33cat ="SELECT * FROM $table_name54A where category_id='$CAT_id' ";
$result331cat = @mysqli_query($connection,$sql33cat) or die(mysqli_error($connection));
while ($row1a1cat = mysqli_fetch_array($result331cat)) {
$catproduct9= $row1a1cat['product_id'];
$pty[$catproduct9]=1;
$Processor="
N/A
";
$sql33cat1 ="SELECT * FROM $table_name53 where product_id='$catproduct9' ";
///echo $sql33cat1;
$result331cat1 = @mysqli_query($connection,$sql33cat1) or die(mysqli_error($connection));
while ($row1a1cat1 = mysqli_fetch_array($result331cat1)) {
$nameproduct= $row1a1cat1['name'];
$Tnameproduct[$catproduct9]= $row1a1cat1['name'];
$Cv[$dd]=$catproduct9;
$dd=$dd+1;
//echo $nameproduct;
}
$creditA= '0';
$reqA= 'NO';
$CreqA=0;
$sql33cat1 ="SELECT * FROM $table_name54 where product_id='$catproduct9' ";
///echo $sql33cat1;
$result331cat1 = @mysqli_query($connection,$sql33cat1) or die(mysqli_error($connection));
while ($row1a1cat1 = mysqli_fetch_array($result331cat1)) {
$creditA= $row1a1cat1['location'];
$creditAA[$catproduct9]=$creditA;
$RRcreditAA[$catproduct9]='0';
$ERcreditAA[$catproduct9]=$creditA;
$RcreditAA[$catproduct9]='NO';
$reqA1= $row1a1cat1['ABC_code'];
$ty[$catproduct9]=0;
If ($reqA1=='A'){
$reqA= 'YES';
$RcreditAA[$catproduct9]='YES';
$RRcreditAA[$catproduct9]=$creditA;
$ERcreditAA[$catproduct9]=0;
$reqPoint=$reqPoint+$creditA;
$CreqA=1;
$ty[$catproduct9]=$creditA;
}
//echo $nameproduct;
}
$jade_doc1 ="Not Paid";
$NA9="Not Completed";
$paidchecker=0;
$sq112abSz="SELECT * FROM $db_name.$table_name41 WHERE customer_id ='$cust_id' AND date_added between '$startd' AND '$finishd' ";
//echo $sq112abSz;
$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'];
$dateordr=$row1bSz['date_added'];
$amount7=$row1bSz['total'];
$first7= $row1bSz['firstname'];
$last7= $row1bSz['lastname'];
// echo "$cust_id $first7 $last7 $order7 ";
$sq112abS1z="SELECT * FROM $db_name.$table_name47 WHERE order_id ='$order7' AND (product_id ='$catproduct9' ) ";
$result112ab1z = @mysqli_query($connection,$sq112abS1z) or die(mysqli_error($connection));
$num3334bT291z = mysqli_num_rows($result112ab1z);
if ($num3334bT291z>0) {
//echo "$cust_id $first7 $last7 $order7 $catproduct9 ";
$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;
$chap=1;
$paidchecker=1;
$pty[$catproduct9]=0;
if ($CreqA==1){
$ReqPaid=$ReqPaid+$creditA;
}
if ($CreqA==0){
$NReqPaid=$NReqPaid+$creditA;
}
// $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='';
$jade_doc1 ="Paid";
//echo "$cust_id $first7 $last7 $order7 $catproduct9 ";
$Processor="
Manage
";
$sq112abS1acy="SELECT * FROM $table_name36001 WHERE customer_id ='$cust_id' AND address_id= '$catproduct9' AND type_id='900' AND status='1' AND date_added between '$startd' AND '$finishd' ";
$sq112abS1acy="SELECT * FROM $table_name36001 WHERE customer_id ='$cust_id' AND address_id= '$catproduct9' AND type_id='900' AND status!='0' AND approved ='0' AND date_added between '$startd' AND '$finishd' ";
//echo "$sq112abS1acy ";
$result112ab1acy = @mysqli_query($connection,$sq112abS1acy) or die(mysqli_error($connection));
$num3334bT291acy = mysqli_num_rows($result112ab1acy);
if ($num3334bT291acy>0) {
$result112ab1acyyd = @mysqli_query($connection,$sq112abS1acy) or die(mysqli_error($connection));
while ($row1bSzyy1a = mysqli_fetch_array($result112ab1acyyd)) {
///$order7= stripslashes($row1bS['product_id']);
$Bstatus=$row1bSzyy1a['status'];
}
$NA9="$CCstatus[$Bstatus]";
if ($Bstatus==1){
$reqCredit=$reqCredit+$creditA;
}
$sq112abS1acyy="SELECT * FROM $table_name36001 WHERE customer_id ='$cust_id' AND address_id= '$catproduct9' AND type_id='900' AND status='1' AND date_added between '$startd' AND '$finishd' ";
$sq112abS1acyy="SELECT * FROM $table_name36001 WHERE customer_id ='$cust_id' AND address_id= '$catproduct9' AND type_id='900' AND status!='0' AND approved ='0' AND date_added between '$startd' AND '$finishd' ";
$result112ab1acyy = @mysqli_query($connection,$sq112abS1acyy) or die(mysqli_error($connection));
while ($row1bSzyy = mysqli_fetch_array($result112ab1acyy)) {
///$order7= stripslashes($row1bS['product_id']);
$dateordry=$row1bSzyy['date_added'];
$approvdry=$row1bSzyy['address_1st'];
$pro_id=$row1bSzyy['pro_id'];
$Dstatus=$row1bSzyy['status'];
// echo "$Dstatus - $pro_id - $catproduct9 ";
$nonReq=$reqCredit;
if($Dstatus==1){
$earnReq=$earnReq+$ty[$catproduct9];
//$nonReq=$nonReq - $ty[$catproduct9];
$NA9 .=" $approvdry Approved on: $dateordry";
}
$Processor="
![\"\"](\"$loc2/admin/GoTool/image/stake.png\")
