<?php
	$boom2='';
	$topcat22='';
	$Dfirstname=  '';
	$Dlastname=  '';
	
	$text_account34=  '';
	$Ctext_account34=0;
	
	$jedID2U=3;
	$notable=0;
	$showchart='';
	
	$GshowchartZ=explode(",", $showchartZ);
			$Gshowchart3=count($GshowchartZ);
			$showchart=$GshowchartZ[0];
			
	
		$bing=1;
	
	$titleA1="View Roadmap";
	$titleA2="View Uploads";
	
//	$b2[0]="leader_id='$text_account3' or leader_idA='$text_account3'";
//	$b2[1]="leader_id='$text_account3' ";
//	$b2[2]="leader_idA='$text_account3'";
//	$b2[3]="leader_idB='$text_account3'";
//	$b2[4]="leader_idAdm='$text_account3'"; ///mentor
	
//	$b2[5]="support_id='$text_account3'";  ///spouse
//	$b2[6]="overseer_id='$text_account3'";
//	$b2[7]="other_id='$text_account3'"; ///student
//	$b2[8]="customer_group_id='$text_account2'";
//	$b2[9]="leader_id='$text_account3' or leader_idA='$text_account3'  or leader_idB='$text_account3'";
	
	$badboyA=$badboy;
	$badboyB=$badboy;
	
	//$runCAP2[10]="../gotool/CASMIT/MITstart.php?token=$tok&log=$text_account3&store=$cc99&cc=$cc99";
	$dirA1="CASMIT";
	$dirA2="CASMIT";
	
	$loonyA1=0;
	
	$loonyA2=0;  //condition never used
	
	
$Ggrade2='';
	$Ggrade2=explode(",", $gradeZ);
			$Ggrade3=count($Ggrade2);
			$grade=$Ggrade2[0];
			if ($Ggrade3>1){
		$loonyA1=$Ggrade2[1];	
			
			}
			

$Gport_idzZ='';
	$Gport_idzZ=explode(",", $port_idzZ);
			$Gport_idz3=count($Gport_idzZ);
			$port_idz=$Gport_idzZ[0];
			
			if ($Gport_idz3>1){
			
			$titleA1=$Gport_idzZ[1];
			$titleA1z[1]=$Gport_idzZ[1];
			}
			
			
				if ($Gport_idz3>2){
			
			$surveyA1=$Gport_idzZ[2];
			$surveyA1z[1]=$Gport_idzZ[2];
			}
			
			
					if ($Gport_idz3>3){
			
			$dirA1=$Gport_idzZ[3];
			$dirA1z[1]=$Gport_idzZ[3];
			
			
			if ($dirA1z[1]=="survey"){
			$badA[1]="$loc2/survey/pmreg.php?test=$surveyA1z[1]&tword=Form&log=$text_account3&agent=$text_account3&store=$cc99";
			}else{
			$badA[1]="../gotool/$dirA1z[1]/MITstart.php?token=$tok&log=$text_account3&store=$cc99&cc=$cc99";
			}
			
			$bing=1;
			}
			
////round 2			
			
			if ($Gport_idz3>5){
			$titleA1z[2]=$Gport_idzZ[5];
			}

			
				if ($Gport_idz3>6){
			$surveyA1z[2]=$Gport_idzZ[6];
			}
			
			
					if ($Gport_idz3>7){
			$dirA1z[2]=$Gport_idzZ[7];
			
				$bing=2;
			
			if ($dirA1z[2]=="survey"){
			$badA[2]="$loc2/survey/pmreg.php?test=$surveyA1z[2]&tword=Form&log=$text_account3&agent=$text_account3&store=$cc99";
			}else{
			$badA[2]="../gotool/$dirA1z[2]/MITstart.php?token=$tok&log=$text_account3&store=$cc99&cc=$cc99";
			}
			
			
			}
			
//////round 3

			
			if ($Gport_idz3>9){
			$titleA1z[3]=$Gport_idzZ[9];
			}

			
				if ($Gport_idz3>10){
			$surveyA1z[3]=$Gport_idzZ[10];
			}
			
			
					if ($Gport_idz3>11){
			$dirA1z[3]=$Gport_idzZ[11];
			
				$bing=3;
			
			if ($dirA1z[3]=="survey"){
			$badA[3]="$loc2/survey/pmreg.php?test=$surveyA1z[3]&tword=Form&log=$text_account3&agent=$text_account3&store=$cc99";
			}else{
			$badA[3]="../gotool/$dirA1z[3]/MITstart.php?token=$tok&log=$text_account3&store=$cc99&cc=$cc99";
			}
			
			
			}

////round 4
			

			if ($Gport_idz3>13){
			$titleA1z[4]=$Gport_idzZ[13];
			}

			
				if ($Gport_idz3>14){
			$surveyA1z[4]=$Gport_idzZ[14];
			}
			
			
					if ($Gport_idz3>15){
			$dirA1z[4]=$Gport_idzZ[15];
			
				$bing=4;
			
			if ($dirA1z[4]=="survey"){
			$badA[4]="$loc2/survey/pmreg.php?test=$surveyA1z[4]&tword=Form&log=$text_account3&agent=$text_account3&store=$cc99";
			}else{
			$badA[4]="../gotool/$dirA1z[4]/MITstart.php?token=$tok&log=$text_account3&store=$cc99&cc=$cc99";
			}
	
			}	
//////			round 5


			if ($Gport_idz3>17){
			$titleA1z[5]=$Gport_idzZ[17];
			}

			
				if ($Gport_idz3>18){
			$surveyA1z[5]=$Gport_idzZ[18];
			}
			
			
					if ($Gport_idz3>19){
			$dirA1z[5]=$Gport_idzZ[19];
			
				$bing=5;
			
			if ($dirA1z[5]=="survey"){
			$badA[5]="$loc2/survey/pmreg.php?test=$surveyA1z[5]&tword=Form&log=$text_account3&agent=$text_account3&store=$cc99";
			}else{
			$badA[5]="../gotool/$dirA1z[5]/MITstart.php?token=$tok&log=$text_account3&store=$cc99&cc=$cc99";
			}
	
			}
			
///////		round 6	
			
			
		if ($Gport_idz3>21){
			$titleA1z[6]=$Gport_idzZ[21];
			}

			
				if ($Gport_idz3>22){
			$surveyA1z[6]=$Gport_idzZ[22];
			}
			
			
					if ($Gport_idz3>23){
			$dirA1z[6]=$Gport_idzZ[23];
			
				$bing=6;
			
			if ($dirA1z[6]=="survey"){
			$badA[6]="$loc2/survey/pmreg.php?test=$surveyA1z[6]&tword=Form&log=$text_account3&agent=$text_account3&store=$cc99";
			}else{
			$badA[6]="../gotool/$dirA1z[6]/MITstart.php?token=$tok&log=$text_account3&store=$cc99&cc=$cc99";
			}
	
			}		
			

/////
	
	
	$larryA1='';
	
	
	$Mgrade2[0]='';
	$Mgrade2[1]='';
	$Mgrade2=explode(",", $Mgrade);
			$Mgrade3=count($Mgrade2);
//echo "<Br>Hi $grade $Mgrade3";
	
	if($Mgrade3<2){
	$Mgrade2[1]='';
	
	}
	
	if($Mgrade3<1){
	$Mgrade2[0]='';
		$Mgrade2[1]='';
	}
	
	
	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){
		
		$resetA2="<FORM  name=\"formcheck\"  METHOD=\"POST\" ACTION=\"$badboyB\">
		                <input type=\"hidden\" name=\"text_account34\" value=\"0\"  />
		                <button class=\"fsSubmitButtonsmall\" type=\"input\">Close</button>
		         </form>";	
		         
		         
	include('viewcohartups.php');
	$display_blockRA92 .="$resetA2<br/><br/>";	
		$topcat22=$display_blockRA92;
	}
	
	}
	
	
	   $sql33a800 ="SELECT * FROM $table_name36 WHERE salesrep_id='$text_account3' AND status='1' ORDER BY lastname ";
	             $result33a800 = @mysqli_query($connection,$sql33a800) or die(mysqli_error($connection));

$num3334bT29z = mysqli_num_rows($result33a800);

if ($num3334bT29z>0){
$boom2 .= "<tr><td colspan=\"6\">Assigned</td></tr>";
}


	   while ($row112a800 = mysqli_fetch_array($result33a800)) {
	  $Rep[1]=  $row112a800['customer_id'];
	  $Rep[2]=  $row112a800['firstname'];
	  $Rep[3]=  $row112a800['lastname'];
	  $Rep[4]=  $row112a800['telephone'];
	   $Rep[5]=  $row112a800['email'];
	 // $Rep[5]=  $row112a800['van5'];
	 // $Rep[6]=  $row112a800['van6'];
	  //  $sign_date=  $row112a800['sign_date'];
	 //    $signD=  $row112a800['sign_date'];
	//   $signD=date("m/d/Y", strtotime("$signD"));
	//      $mapD=  $row112a800['map_id'];
	
	
	  for ($xT2=1; $xT2<=$bing; $xT2++) {   

//echo "$xT2=1; $xT2<=$bing; $xT2 <br/>";

$larryA1.="<FORM  name=\"formcheck\" target=\"_blank\" METHOD=\"POST\" ACTION=\"$badA[$xT2]&stud=$Rep[1]\">
	                <input type=\"hidden\" name=\"text_account34\" value=\"$Rep[1]\"  />
	                 <input type=\"hidden\" name=\"Ctext_account34\" value=\"$showchart\"  />
	                <button class=\"fsSubmitButtonsmall\" type=\"input\">$titleA1z[$xT2]</button>
	         </form><br/><br/>";


}


$larryA2="<FORM  name=\"formcheck\" target=\"_blank\" METHOD=\"POST\" ACTION=\"$badboyB\">
		                <input type=\"hidden\" name=\"text_account34\" value=\"$Rep[1]\"  />
		 <input type=\"hidden\" name=\"showchart\" value=\"$showchart\"  />
		  <input type=\"hidden\" name=\"Ctext_account34\" value=\"$showchart\"  />
		                <button class=\"fsSubmitButtonsmall\" type=\"input\">$titleA2</button>
		         </form><br/><br/>";

		if ($Gport_idzZ[0]==0){	
		$larryA1="";
			}
	
	
	If ($GshowchartZ[0]==0){
			$larryA2="";			
				}	
	
	
	 $boom2 .= "
	 <tr>
	<td>$Rep[1]</td>
	<td>$Rep[2]</td>
	<td>$Rep[3]</td>
	<td>$Rep[4] </td>
	<td>$Rep[5]</td>
	<td>$larryA1 
	
	$larryA2</td>


	</tr>
	 ";
$larryA1='';


	  }

if ($Mgrade3>1){

	 $sql33a8001aa ="SELECT * FROM $table_name85 WHERE name like'%$Mgrade2[0]%' AND name like'%$Mgrade2[1]%' AND status='1'  ";

	}else{
	
		 $sql33a8001aa ="SELECT * FROM $table_name85 WHERE name like'%$Mgrade2[0]%'  AND status='1'  ";

	}
	$result33a8001aa = @mysqli_query($connection,$sql33a8001aa) or die(mysqli_error($connection));
		             
 while ($row112a8001aa = mysqli_fetch_array($result33a8001aa)) {
 $group_idTTaa=  $row112a8001aa['survey_id'];
  $group_idTTaaN=  $row112a8001aa['name'];
	
	 $sql33a8001 ="SELECT * FROM $table_name84 WHERE (leader_idAdm='$text_account3') AND group_id='$group_idTTaa' AND status='1'  ";
	  $sql33a8001 ="SELECT * FROM $table_name84 WHERE ($b2[$loonyA1]) AND group_id='$group_idTTaa' AND status='1'  ";
	
	
		             $result33a8001 = @mysqli_query($connection,$sql33a8001) or die(mysqli_error($connection));
$num3334bT29za = mysqli_num_rows($result33a8001);

if ($num3334bT29za>0){
$boom2 .= "<tr><td colspan=\"6\">ID: $group_idTTaaN</td></tr>";
}


		   while ($row112a8001 = mysqli_fetch_array($result33a8001)) {
	 $group_idT=  $row112a8001['group_id'];
	 $sql33a8001a ="SELECT * FROM $table_name84 WHERE group_id='$group_idT' ";
	 $result33a8001a = @mysqli_query($connection,$sql33a8001a) or die(mysqli_error($connection));
	while ($row112a8001a = mysqli_fetch_array($result33a8001a)) {
		 $group_idTT=  $row112a8001a['other_id'];
	
	   $sql33a800b ="SELECT * FROM $table_name36 WHERE customer_id='$group_idTT' AND status='1'  ";
	             $result33a800b = @mysqli_query($connection,$sql33a800b) or die(mysqli_error($connection));
	   while ($row112a800b = mysqli_fetch_array($result33a800b)) {
	  $Rep[1]=  $row112a800b['customer_id'];
	  $Rep[2]=  $row112a800b['firstname'];
	  $Rep[3]=  $row112a800b['lastname'];
	  $Rep[4]=  $row112a800b['telephone'];
	   $Rep[5]=  $row112a800b['email'];
	 // $Rep[5]=  $row112a800['van5'];
	 // $Rep[6]=  $row112a800['van6'];
	  //  $sign_date=  $row112a800['sign_date'];
	 //    $signD=  $row112a800['sign_date'];
	//   $signD=date("m/d/Y", strtotime("$signD"));
	//      $mapD=  $row112a800['map_id'];

	  for ($xT2=1; $xT2<=$bing; $xT2++) {   

//echo "$xT2=1; $xT2<=$bing; $xT2 <br/> $larryA1 <br/>";


$larryA1 .="<FORM  name=\"formcheck\" target=\"_blank\"   METHOD=\"POST\" ACTION=\"$badA[$xT2]&stud=$Rep[1]\">
	                <input type=\"hidden\" name=\"text_account34\" value=\"$Rep[1]\"  />
	                 <input type=\"hidden\" name=\"Ctext_account34\" value=\"$showchart\"  />
	                <button class=\"fsSubmitButtonsmall\" type=\"input\">$titleA1z[$xT2]</button>
	         </form><br/><br/>";


}


$larryA2="<FORM  name=\"formcheck\" target=\"_blank\"   METHOD=\"POST\" ACTION=\"$badboyB\">
		                <input type=\"hidden\" name=\"text_account34\" value=\"$Rep[1]\"  />
		 <input type=\"hidden\" name=\"showchart\" value=\"$showchart\"  />
		  <input type=\"hidden\" name=\"Ctext_account34\" value=\"$showchart\"  />
		                <button class=\"fsSubmitButtonsmall\" type=\"input\">$titleA2</button>
		         </form><br/><br/>";

		if ($Gport_idzZ[0]==0){	
		$larryA1="";
			}
	
	
	If ($GshowchartZ[0]==0){
			$larryA2="";			
				}	
	

if ($larryA1==$blink AND $larryA2==$blink){
$larryA1="N/A";
$newlimitMess='';
$notable=1;
}


	 $boom2 .= "
	 <tr>
	<td>$Rep[1]</td>
	<td>$Rep[2]</td>
	<td>$Rep[3]</td>
	<td>$Rep[4] </td>
	<td>$Rep[5] </td>
	<td>$larryA1 
	
	$larryA2</td>


	</tr>
	 ";

$larryA1='';
	  }}}

}  ///new while

	$topcat22.= "

	<table class=\"sortable\" id=\"RE\"> <thead> <tr>
	<td class=\"filterable\">ID #</td>
	<td class=\"filterable\">First Name</td>
	<td class=\"filterable\">Last Name</td>
	<td class=\"filterable\">Phone #</td>
	<td class=\"filterable\">Email</td>
	<td class=\"filterable\">Action</td>


	</tr></thead><tbody>
	<tr class=\"filter\">
	<td align=\"left\"><input type=\"text\" name=\"filter_req\" value=\"\" size=\"6\" onkeyup=\"Table.filter(this,this)\"/></td>
	<td align=\"left\"><input type=\"text\" name=\"filter_req0\" value=\"\" size=\"6\" onkeyup=\"Table.filter(this,this)\"/></td>
	<td align=\"left\"><input type=\"text\" name=\"filter_req1\" value=\"\" size=\"10\" onkeyup=\"Table.filter(this,this)\"/></td>
	<td align=\"left\"><input type=\"text\" name=\"filter_req2\" value=\"\" size=\"10\" onkeyup=\"Table.filter(this,this)\"/></td>
	<td align=\"left\"><input type=\"text\" name=\"filter_comment\" value=\"\" size=\"10\" onkeyup=\"Table.filter(this,this)\"/></td>
<td align=\"left\"><input type=\"text\" name=\"filter_comment2\" value=\"\" size=\"10\" onkeyup=\"Table.filter(this,this)\"/></td>


	</tr>$boom2</tbody></table>";
	
//	if ($notable !=1){
	
//	include('CompleteApp310.php');
	
//	$topcat22 .=$display_sec2A;
//}
?>