<?php

include("../admin/GoTool/cat.inc");
 $connection = @mysql_connect($host,$user,$password) or die(mysql_error());
$db = @mysql_select_db($db_name,$connection) or die(mysql_error());
 $testy=$_GET['test'];
 $log=$_GET['log'];
 
 $stakename="Welcome";
 $stakename2="Access Level";
 $stakegroup="Ministry";
 $userC=$log;
 //First determine what stakeholder group the login belongs
 
  $sql33 ="SELECT * FROM $table_name36 WHERE customer_id = '$userC' ";
  $result33 = @mysql_query($sql33,$connection) or die(mysql_error());
 while ($row22 = mysql_fetch_array($result33)) {
          $stakeholder_group_id=  $row22['customer_group_id'];
          $firstname=$row22['firstname'];
          $lastname=$row22['lastname'];
          $namer2[$userC]="$firstname $lastname";
                            }

 
   $sq112ab="SELECT * FROM $table_name362";
  $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error());
while ($row112ab = mysql_fetch_array($result112ab)) {
    $group_id1=  $row112ab['customer_group_id'];
 $group_name=  $row112ab['name'];
 $FCgroup[$group_id1]= $group_name;
 $FCgroup[0]="All";
 $FCgroup[-1]="None";
 
}                 
      $stakeholder_group=$FCgroup[$stakeholder_group_id];   
      
      
  $sq112ab="SELECT * FROM $table_name85 where status >0 ORDER BY name ASC ";
  $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error());
while ($row112ab = mysql_fetch_array($result112ab)) {
    $group_id1=  $row112ab['survey_id'];
 $Go_group_name=  $row112ab['name'];
  $FGL[$group_id1]= $Go_group_name; 
   $FGL[0]="All";
 $FGL[-1]="None";

}    

  $i=1;
  $sql33 ="SELECT * FROM $table_name84 WHERE leader_id= '$userC' OR support_id= '$userC' OR overseer_id= '$userC' OR other_id= '$userC' OR customer_group_id ='$stakeholder_group_id'";  
  $result112ab = @mysql_query($sql33,$connection) or die(mysql_error());
while ($row112ab = mysql_fetch_array($result112ab)) {


 $go_groups_id=  $row112ab['group_id'];
 //$go_groups_ID2[i]=$go_groups_id;
 $go_groups_name[$go_groups_id]=$FGL[$go_groups_id];
 
 
 //$sql331 ="SELECT distinct file_match_id, group_id FROM $table_name86a WHERE group_id= '$go_groups_id' OR group_id=0 OR customer_id='$userC'";  
 $sql331 ="SELECT distinct file_match_id, group_id FROM $table_name86a WHERE group_id= '$go_groups_id' OR group_id=0 ";  

  $result112ab1 = @mysql_query($sql331,$connection) or die(mysql_error());
while ($row112ab1 = mysql_fetch_array($result112ab1)) {

 $folder_id=  $row112ab1['file_match_id'];
 $group_call= $row112ab1['group_id'];
 if ($group_call ==0){
$gtype="";
 //$gtype="(General)";
 }else{
 $gtype="(Specific to $go_groups_name[$group_call])";
 }
 
$sql332 ="SELECT * FROM $table_name86 WHERE file_match_id= '$folder_id' ";  
  $result112ab2 = @mysql_query($sql332,$connection) or die(mysql_error());
while ($row112ab2 = mysql_fetch_array($result112ab2)) {
$foldtype= $row112ab2['foldtype'];

$sql333 ="SELECT * FROM $table_name87 WHERE survey_id= '$foldtype' ";  
  $result112ab3 = @mysql_query($sql333,$connection) or die(mysql_error());
while ($row112ab3 = mysql_fetch_array($result112ab3)) {
$foldname= $row112ab3['name'];
$foldname3="$folder_id - $foldname $gtype";
$prog2="../upload/customer/folder.php";

$foldname2 .="<a href=\"$prog2?foldnamee=$foldname3&fold=$folder_id&log=$log\">$folder_id - $foldname $gtype<br/></a>";
   
  }}}

 $hoopy2 .="<tr><td>$stakegroup $go_groups_id = $go_groups_name[$go_groups_id]</td><td> <img src=\"../image/data/group_icons/min$go_groups_id.jpg\" /></td><td>$foldname2</td></tr>";
 $i=$i+1;
  $foldname2 ="";
}


 $sql331 ="SELECT distinct file_match_id, group_id FROM $table_name86a WHERE group_id= '-1' AND customer_id='$userC'";  
  $result112ab1 = @mysql_query($sql331,$connection) or die(mysql_error());
while ($row112ab1 = mysql_fetch_array($result112ab1)) {

 $folder_id=  $row112ab1['file_match_id'];
 $group_call= $row112ab1['group_id'];
 if ($group_call ==0){
$gtype="";
 //$gtype="(General)";
 }else{
 $gtype="(Specific)";
 }
 
$sql332 ="SELECT * FROM $table_name86 WHERE file_match_id= '$folder_id' ";  
  $result112ab2 = @mysql_query($sql332,$connection) or die(mysql_error());
while ($row112ab2 = mysql_fetch_array($result112ab2)) {
$foldtype= $row112ab2['foldtype'];

$sql333 ="SELECT * FROM $table_name87 WHERE survey_id= '$foldtype' ";  
  $result112ab3 = @mysql_query($sql333,$connection) or die(mysql_error());
while ($row112ab3 = mysql_fetch_array($result112ab3)) {
$foldname= $row112ab3['name'];
$foldname3="$folder_id - $foldname $gtype";
$prog2="../upload/customer/folder.php";

$foldname2a .="<a href=\"$prog2?foldnamee=$foldname3&fold=$folder_id&log=$log\">$folder_id - $foldname $gtype<br/></a>";
   
  }}





 $hoopy3 .="<tr><td>Special Folder</td><td> </td><td>$foldname2a</td></tr>";

  $i=$i+1;
  $foldname2 ="";
$foldname2a ="";
}
 


      
   $hoopy .="$stakename   $namer2[$userC]<br/> $stakename2 = $stakeholder_group<br/><br />
   <table class=\"list\"><thead><tr><td>$stakegroup</td><td></td><td>Folder Access</td></tr></thead>
   <tbody>$hoopy2</tbody></table> <br/><br/>
<table class=\"list\"><thead><tr><td>Special Folders</td><td></td><td>Folder Access</td></tr></thead>
   <tbody>$hoopy3</tbody></table>

"; 
      
      
	
 
    $min=90;
 $sec=$min*60;
 $timer=1000*$sec;
 $display_blockFF .= "<div id=\"footer4\" align=center><a href=\"http://www.galliumgroup.com\">GalliumGroup</a> &copy; 2009-2011 All Rights Reserved.<br />Version 1.5.1.3</div>";
  $survey_num="$testy";

     $sql33 ="SELECT * FROM $table_name81 WHERE survey_id = '$testy' ";
  $result33 = @mysql_query($sql33,$connection) or die(mysql_error());
     //   $row22 =mysql_fetch_array($result33,MYSQL_ASSOC);
        while ($row22 = mysql_fetch_array($result33)) {
          $display_title=  $row22['name'];
          $display_comment =$row22['comment'];
           $bob=  $row22['ptimed'];
          }

         // $timing=90;

          if ($bob == 0){
           $warn101="You have selected to take a recorded test. Your answers will be saved in our system." ;
          }else {
             $warn101="You have selected to take a timed test. You will have $bob minutes to complete this test. Your answers will be saved in our system." ;
           }

  include("customer_add.php");

 $startsaying="Remember this is a timed test. You have $min minutes.";
    $today_count=date("m/d/Y h:i:s A");
    $import_time=strtotime("now+1 hour+ $min minutes");
$import_time=date("m/d/Y h:i:s A", $import_time);

$prog="surveyDwTwL.php";

$display_block ="<font size=\"6\">$hoopy<br />
";


?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en" xml:lang="en">
<head>
<title>survey_num <? echo "$survey_num"; ?> jedID2=<? echo "$bob"; ?></title>
<link rel="stylesheet" type="text/css" href="../admin/view/stylesheet/stylesheet.css" />
<script type="text/javascript" src="../admin/view/javascript/jquery/jquery-1.6.1.min.js"></script>
<script type="text/javascript" src="../admin/view/javascript/jquery/ui/jquery-ui-1.8.16.custom.min.js"></script>
<link rel="stylesheet" type="text/css" href="../admin/view/javascript/jquery/ui/themes/ui-lightness/jquery-ui-1.8.16.custom.css" />
<script type="text/javascript" src="../admin/view/javascript/jquery/ui/external/jquery.bgiframe-2.1.2.js"></script>
<script type="text/javascript" src="../admin/view/javascript/jquery/tabs.js"></script>

<script type="text/javascript" src="../admin/view/javascript/jquery/superfish/js/superfish.js"></script>
<script type="text/javascript" src="../admin/GoTool/risk/jquery.min.js"></script>
</head>
<body>



<div class="box">
    <div class="heading">
      <h1><img src="../admin/view/image/report.png" alt="" /> <? echo "$display_title"; ?> </h1>
      <? echo "$warning_clock"; ?>
    </div>
    <div class="content" >
    <table class=list>   <tbody>  <td></td><td align left>
      <? echo "$display_block"; ?> <? echo "$display_block77"; ?>  </td> <td></td>
  </tbody>   </table> </div>
  </div>


 <? echo "$string"; ?>
  <? echo "$display_blockFF"; ?>













 </body></html>




</html>
