";
}
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==536){
$cust_id2=$_POST['pnum'];
$newagent_id=$_POST['newagent'];
$sql2 = "UPDATE $table_name36 SET salesrep_id='$newagent_id' WHERE customer_id= '$cust_id2' ";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
$viewmail="
Record Assignment has been updated.
";
$bob2=2;
$jedID2=$bob2;
}
$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 .= "";
}
$Zt10=100;
$Zt1=1;
for ($x2=$Zt1; $x2<=$Zt10; $x2++) {
$bobporta="Not Assigned";
$sql12drr ="SELECT * FROM $table_name1005 WHERE survey_id = '$x2'";
$result331drr = @mysqli_query($connection,$sql12drr) or die(mysqli_error($connection));
while ($row1drr = mysqli_fetch_array($result331drr)) {
$group_id2= $row1drr['group_id'];
$bobporta=$nameP[$group_id2];
}
$display_listPortal .= "";
}
if( $jedID2==0){
//$run="$loc2/createaccount/OpenEvent.php?path=$path&product_id=$product_id";
$i=$i+1;
$display_block66 ="
";
$display_block= "Below lists all $type_face Created in GoTool:
$display_block66
";
}
if( $jedID2==2){
if (isset($_POST['mail1'])) {
$mail1=$_POST['mail1'];
}
//group_id is portal
if (isset($_POST['group_id'])) {
$group_id=$_POST['group_id'];
}
if ($mail1>0){
if (isset($_POST['group_id'])) {
$event_id=$_POST['group_id'];
}
//include("OpenEventManager_mail.php");
}
if (isset($_POST['group_id'])) {
$port_id=$_POST['group_id'];
}
if (isset($_POST['portal'])) {
$port_id=$_POST['portal'];
}
//echo "port $port_id ";
$sql12d ="SELECT * FROM $table_name1005 WHERE survey_id = '$port_id'";
$result331d = @mysqli_query($connection,$sql12d) or die(mysqli_error($connection));
$num331z0 = mysqli_num_rows($result331d);
if ($num331z0<1){
$display_block="No records found.";
$boom .="
New Bucket
";
$display_block .="$viewmail
$boom
";
}else{
$display_block="$num331z0 records found.";
$sql12ad ="SELECT * FROM $table_name1005 WHERE survey_id = '$port_id' AND sub_id='0' AND Z_num <'0' Order by surveyQ_idK, surveyQ_id";
$result331d = @mysqli_query($connection,$sql12ad) or die(mysqli_error($connection));
while ($row1d = mysqli_fetch_array($result331d)) {
$map_id= $row1d['map_id'];
$title[$map_id]= stripslashes( $row1d['title']);
$group_id[$map_id]= $row1d['group_id'];
$sub_id[$map_id]= $row1d['group_id'];
$suveyD_id[$map_id]= $row1d['survey_id'];
$suveyQ_id[$map_id]= $row1d['surveyQ_id'];
$suveyQ_id2= $row1d['surveyQ_id'];
$Z_num4=$row1d['Z_num'];
$Ztitle1[$Z_num4]="$title[$map_id]";
$cd_1[28]='';
$status[$map_id]=$row1d['status'];
if ($status[$map_id]>0){
$cd_1[28]="checked";
}
$boom .="
