Hi $grade $Mgrade3";
if($Mgrade3<2){
$Mgrade2[1]='';
}
if($Mgrade3<1){
$Mgrade2[0]='';
$Mgrade2[1]='';
}
if (isset($_POST['Boo2'])) {
$Boo2=$_POST['Boo2'];
}
if (isset($_POST['text_account34'])) {
$text_account34=$_POST['text_account34'];
}
if (isset($_POST['Ctext_account34'])) {
$Ctext_account34=$_POST['Ctext_account34'];
}
if($Ctext_account34==$showchart){
if($text_account34 >0){
include('viewcohartups.php');
$topcat22=$display_blockRA92;
if ($Boo2!=$grade) {
$topcat22='';
}
if ($Boo2==$grade) {
$bvo=1;
}
}
}
//////
///$Tgrade=$Tgrade02[0];
///0=product to buy
///1=Change customer_group_id
///2=Event to Register for
$drop_role='';
$drop_gen='';
$drop_pack='';
$sql33a8001 ="SELECT * FROM product_description WHERE product_id>'0' AND product_id='$Tgrade02[2]' ";
$result33A1 = @mysql_query($sql33a8001,$connection) or die(mysql_error());
$row22rAb1rt =mysql_fetch_array($result33A1,MYSQL_ASSOC);
$event_name=$row22rAb1rt['name'];
$sql33a8001 ="SELECT * FROM event_manager WHERE product_id>'0' AND product_id='$Tgrade02[2]' ";
$result33A1 = @mysql_query($sql33a8001,$connection) or die(mysql_error());
$row22rAb1rt =mysql_fetch_array($result33A1,MYSQL_ASSOC);
$event_id=$row22rAb1rt['event_id'];
//event_manager_pgr pgr_id, name
//event_manager_primary_cost
$sql33a8001a ="SELECT Distinct role_id FROM event_manager_primary_cost WHERE event_id='$event_id' order by sort_order ASC ";
// echo $sql33a8001a;
$result33a800p = @mysql_query($sql33a8001a,$connection) or die(mysql_error());
while ($row112a800 = mysql_fetch_array($result33a800p)) {
$idey= $row112a800['role_id'];
$sql33a8001 ="SELECT * FROM event_manager_pgr WHERE pgr_id='$idey' ";
$result33A1 = @mysql_query($sql33a8001,$connection) or die(mysql_error());
$row22rAb1rt =mysql_fetch_array($result33A1,MYSQL_ASSOC);
$ideyN=$row22rAb1rt['name'];
$drop_role .="";
// echo "$idey- $ideyN ";
}
//////
$sql33a8001a ="SELECT Distinct package_id FROM event_manager_primary_cost WHERE event_id='$event_id' order by sort_order ASC ";
// echo $sql33a8001a;
$result33a800p = @mysql_query($sql33a8001a,$connection) or die(mysql_error());
while ($row112a800 = mysql_fetch_array($result33a800p)) {
$idey= $row112a800['package_id'];
$sql33a8001 ="SELECT * FROM event_manager_pgr WHERE pgr_id='$idey' ";
$result33A1 = @mysql_query($sql33a8001,$connection) or die(mysql_error());
$row22rAb1rt =mysql_fetch_array($result33A1,MYSQL_ASSOC);
$ideyN=$row22rAb1rt['name'];
$drop_pack .="";
// echo "$idey- $ideyN ";
}
/////
$sql33a8001a ="SELECT Distinct gender_id FROM event_manager_primary_cost WHERE event_id='$event_id' order by sort_order ASC ";
// echo $sql33a8001a;
$result33a800p = @mysql_query($sql33a8001a,$connection) or die(mysql_error());
while ($row112a800 = mysql_fetch_array($result33a800p)) {
$idey= $row112a800['gender_id'];
$sql33a8001 ="SELECT * FROM event_manager_pgr WHERE pgr_id='$idey' ";
$result33A1 = @mysql_query($sql33a8001,$connection) or die(mysql_error());
$row22rAb1rt =mysql_fetch_array($result33A1,MYSQL_ASSOC);
$ideyN=$row22rAb1rt['name'];
$drop_gen .="";
// echo "$idey- $ideyN ";
}
////
/// $sql33a800 ="SELECT * FROM $table_name36 WHERE salesrep_id='$text_account3' AND status='1' ORDER BY lastname ";
$sql33a800 ="SELECT * FROM $table_name36 WHERE status='1' ORDER BY lastname ";
if ($Mgrade3>1){
$sql33a800 ="SELECT * FROM $table_name36 WHERE customer_group_id ='$Mgrade2[0]' OR customer_group_id= '$Mgrade2[1]' AND status='1' ORDER BY lastname ";
}else{
$sql33a800 ="SELECT * FROM $table_name36 WHERE customer_group_id ='$Mgrade2[0]' AND status='1' ORDER BY lastname ";
}
$result33a800 = @mysql_query($sql33a800,$connection) or die(mysql_error());
$num3334bT29z = mysql_num_rows($result33a800);
///echo "What $num3334bT29z";
if ($num3334bT29z>0){
$boom2 .= "
Assigned to this Group: $num3334bT29z
";
}
if ($num3334bT29z<1){
$boom2 .= "
None Assigned
";
}
while ($row112a800 = mysql_fetch_array($result33a800)) {
$Rep[1]= $row112a800['customer_id'];
$Rep[2]= $row112a800['firstname'];
$Rep[3]= $row112a800['lastname'];
$Rep[4]= $row112a800['telephone'];
$Rep[5]= $row112a800['email'];
$appstatus="No";
$Tappstatus="";
$Tappstatus="NA";
$validate='';
if ($Tgrade02[1]>0){
$sql33a8001 ="SELECT * FROM $table_name362 WHERE customer_group_id='$Tgrade02[1]' ";
$result33A1 = @mysql_query($sql33a8001,$connection) or die(mysql_error());
$row22rAb1rt =mysql_fetch_array($result33A1,MYSQL_ASSOC);
$ideyN=$row22rAb1rt['name'];
$validate="Program Approval: $ideyN
";
}
if ($Tgrade02[2]>0){
$validate="$event_name
";
}
/////
$validate1='';
if ($Tgrade02[3]>0){
$Rejected="Reject";
if ($Tgrade02[4]>0){
$Rejected="Approve";
}
$sql33a8001 ="SELECT * FROM $table_name362 WHERE customer_group_id='$Tgrade02[3]' ";
$result33A1 = @mysql_query($sql33a8001,$connection) or die(mysql_error());
$row22rAb1rt =mysql_fetch_array($result33A1,MYSQL_ASSOC);
$ideyN=$row22rAb1rt['name'];
$validate1=" $Rejected Class: $ideyN
";
}
if ($Tgrade02[5]>0){
$Rejected="Reject";
if ($Tgrade02[6]>0){
$Rejected="Approve";
}
$sql33a8001 ="SELECT * FROM $table_name362 WHERE customer_group_id='$Tgrade02[3]' ";
$result33A1 = @mysql_query($sql33a8001,$connection) or die(mysql_error());
$row22rAb1rt =mysql_fetch_array($result33A1,MYSQL_ASSOC);
$ideyN=$row22rAb1rt['name'];
$validate1 .=" $Rejected Class: $ideyN
";
}
////
// $Rep[5]= $row112a800['van5'];
// $Rep[6]= $row112a800['van6'];
// $sign_date= $row112a800['sign_date'];
$signD= $row112a800['date_added'];
$signD=date("m/d/Y", strtotime("$signD"));
// $mapD= $row112a800['map_id'];
$btilepic='';
if ($tilepic==1){
$btilepic="";
}
$btilepic='';
///
$appLook=$port_idzFirst[0];
$sq112b1="SELECT * FROM $table_name80 Where agent_id ='$Rep[1]' AND survey_id ='$appLook' Order by map_id Desc Limit 1";
//$result33a800b1 = @mysql_query($sq112b1,$connection) or die(mysql_error());
$result33Ab1= @mysql_query($sq112b1,$connection) or die(mysql_error());
$row22rAb1 =mysql_fetch_array($result33Ab1,MYSQL_ASSOC);
$idate=$row22rAb1['create_date'];
$imap=$row22rAb1['map_id'];
$sql33AA ="SELECT * FROM $table_name36001 WHERE customer_id = '$Rep[1]' AND type_id='100' AND map_id ='$imap' AND map_id >'0' AND status ='1' ";
//echo $sql33AA;
$result33A = @mysql_query($sql33AA,$connection) or die(mysql_error());
$num33A = mysql_num_rows($result33A);
if ($num33A >0){
$row22rAb1r =mysql_fetch_array($result33A,MYSQL_ASSOC);
$Sidate=$row22rAb1r['date_added'];
$Simap=$row22rAb1r['pro_id'];
$appstatus="Yes";
$Tappstatus="";
}
////
$boom2 .= "