<?php

 $result112a = @mysqli_query($connection,$sq112a) or die(mysqli_error($connection));
while ($row112a = mysqli_fetch_array($result112a)) {
  $surveyQ_id=  $row112a['surveyQ_id'];
 $question["$surveyQ_id"]=  $row112a['question'];
$comment["$surveyQ_id"]=  $row112a['comment'];
$administrative["$surveyQ_id"]=  $row112a['administrative'];

   $sq112b="SELECT * FROM $table_name77 Where survey_id ='$survey_num'AND  surveyQ_id ='$surveyQ_id' Order By surveyA_id";
  $result112b = @mysqli_query($connection,$sq112b) or die(mysqli_error($connection));
while ($row112b = mysqli_fetch_array($result112b)) {
      $surveyA_id=  $row112b['surveyA_id'];
      $test_type=  $row112b['test_type'];
       $answer["$surveyA_id"]=  $row112b['answer'];
    $commentA[$surveyA_id] =  $row112b['comment'];
 $points[$surveyA_id]=  $row112b['A_points'];

       if ($test_type ==1){
       if($administrative["$surveyQ_id"] <4){
            $bam1="First Name, Last Name";
            $bam2="Name, Address, Phone Numbers, Organization";
             $bam3="Name & Organization";
             $bam32="Name & Address";
             $bam31="None";
         if($administrative["$surveyQ_id"] ==1){
          $bam="First Name, Last Name";
         }

          if($administrative["$surveyQ_id"] ==2){
          $bam="Name, Address, Phone Numbers, Organization";
         }

           if($administrative["$surveyQ_id"] ==3){
            $bam="Name & Organization";
         }

           if($administrative["$surveyQ_id"] ==-3){
            $bam="Name & Address";
         }

              if($administrative["$surveyQ_id"] ==-1){
            $bam31="None";
         }


        $answerA .=" Choose the type of Administrative Information Collected: Contact Info<br /><br/>
                  <select size=\"1\" name=\"1\"><option selected value=\"$administrative[$surveyQ_id]\">$bam</option>
                   <option  value=\"1\">$bam1</option>
                   <option  value=\"2\">$bam2</option>
                   <option  value=\"3\">$bam3</option>
                   <option  value=\"-3\">$bam32</option>
                   <option  value=\"-1\">$bam31</option></select> ";
                           }




                 if($administrative["$surveyQ_id"] >3 AND $administrative["$surveyQ_id"] <6  ){
                 $bam1="Email";
                 $bam2="Email & Web Address";
                 $bam3="None";
                     if($administrative["$surveyQ_id"] ==4){
          $bam="Email";
         }

          if($administrative["$surveyQ_id"] ==5){
          $bam="Email & Web Address";
         }




        $answerA .=" Choose the type of Administrative Information Collected: Email & Web<br /><br/>
                  <select size=\"1\" name=\"2\"><option selected value=\"$administrative[$surveyQ_id]\" >$bam</option>
                   <option  value=\"4\">$bam1</option>
                   <option  value=\"5\">$bam2</option>
                   <option  value=\"-11\">$bam3</option> </select> ";

                           }





                         if($administrative["$surveyQ_id"] ==0){
        $answerA .=" <input type=\"text\" name=\"$surveyQ_id\" value=\"$answer[$surveyA_id]\" size=\"40\" /><br/>
        <input type=\"hidden\" name=\"A$surveyA_id\" value=\"999\" />
        <input type=\"text\" name=\"C$surveyA_id\" value=\"$commentA[$surveyA_id]\" /> ";
                           }


                  }




         if($test_type ==0){

            $answerA .=" <input type=\"text\" name=\"$surveyQ_id\" value=\"$answer[$surveyA_id]\" size=\"40\" /><br/>
        <input type=\"hidden\" name=\"A$surveyA_id\" value=\"999\" />
        Edit Comments:<input type=\"text\" name=\"C$surveyA_id\" value=\"$commentA[$surveyA_id]\" size=\"150\"/> ";
         }

 if($test_type ==7){
 $display_emp1='';
            $prod22='';
            $display_emp2='';

       include("../../../survey/surveyEMP.php");

            $answerA ="
            $display_emp1
            $prod22
            $display_emp2
           <br />";
         }

  if($test_type ==8){
  $display_sch1='';
  $display_sch2='';
$prod22s='';

                  include("../../../survey/surveySch.php");

            $answerA ="
            $display_sch1
            $prod22s
            $display_sch2
           <br />";
         }



 if($test_type ==13){
  $display_res1='';
  $display_res2='';
$prod22r='';

                  include("../../../survey/surveyRes.php");

            $answerA ="
            $display_res1
            $prod22r
            $display_res2
           <br />";
         }




                       if($test_type ==9){
$display_cer1='';
$display_cer2='';
$prod22c='';

                  include("../../../survey/surveyCERT.php");

            $answerA ="
            $display_cer1
            $prod22c
            $display_cer2
           <br />";
         }


                      if($test_type ==10){

$display_milt1='';
$display_milt2='';
$prod22m='';

                  include("../../../survey/surveyMILT.php");

            $answerA ="
            $display_milt1
            $prod22m
            $display_milt2
           <br />";
         }


                           if($test_type ==11){

$display_com1='';
$display_com2='';
$prod22com='';

                  include("../../../survey/surveyCom.php");

            $answerA ="
            $display_com1
            $prod22com
            $display_com2
           <br />";
         }


                                      if($test_type ==12){
                      //   $display='';
                  //  $nbr_ligne = 1;

                  $display_min1='';
$display_min2='';
$prod22min='';


                  include("../../../survey/surveyMin.php");

            $answerA ="
            $display_min1
            $prod22min
            $display_min2
           <br />";
         }


                      if($test_type ==14){
                      //   $display='';
                  //  $nbr_ligne = 1;

                  $display_pe1='';
$display_pe2='';
$prod22pe='';


                  include("../../../survey/surveyPeop.php");

            $answerA ="
            $display_pe1
            $prod22pe
            $display_pe2
           <br />";
         }





         if($test_type ==6){

            $answerA .="
                    <textarea rows=\"3\" name=\"$surveyQ_id\" cols=\"50\" style=\"margin-right: 40px; vertical-align: middle;\">$answer[$surveyA_id]</textarea>
        <input type=\"hidden\" name=\"A$surveyA_id\" value=\"999\" />
        <input type=\"hidden\" name=\"C$surveyA_id\" value=\"$commentA[$surveyA_id]\" />
Edit Comments:<input type=\"text\" name=\"C$surveyA_id\" value=\"$commentA[$surveyA_id]\" size=\"150\"/> ";
         }


  if ($test_type ==5){
        $answerA .="
        <input type=\"checkbox\"  name=\"$surveyQ_id\" $sz_C5[$surveyA_id]> Edit Answer Text:  <input type=\"text\" name=\"Q$surveyA_id\" value=\"$answer[$surveyA_id]\"  size=\"200\"><br />
                 Points:  <select size=\"1\" name=\"P$surveyA_id\"><option selected value=\"$points[$surveyA_id]\" >$points[$surveyA_id]</option>
                   <option  value=\"0\">0</option>
                   <option  value=\"1\">1</option>
                   <option  value=\"2\">2</option>
                   <option  value=\"3\">3</option>
                   <option  value=\"4\">4</option>
                   <option  value=\"5\">5</option>
                   <option  value=\"6\">6</option> </select>   <br/>
         Edit Comments: <textarea name=\"C$surveyA_id\" cols=\"40\" rows=\"10\"> $commentA[$surveyA_id]</textarea><br/>
           ";

            }


        if ($test_type ==2){
        $answerA .="<input type=\"radio\" value=\"$surveyA_id\" name=\"$surveyQ_id\" $sz_C5> Edit Answer Text: <input type=\"text\" name=\"Q$surveyA_id\" value=\"$answer[$surveyA_id]\"  size=\"200\"><br />
        Points:  <select size=\"1\" name=\"P$surveyA_id\">
        <option selected value=\"$points[$surveyA_id]\" >$points[$surveyA_id]</option>
                  <option  value=\"0\">0</option>
                   <option  value=\"1\">1</option>
                   <option  value=\"2\">2</option>
                   <option  value=\"3\">3</option>
                   <option  value=\"4\">4</option>
                   <option  value=\"5\">5</option>
                   <option  value=\"6\">6</option> </select>   <br/>
         Edit Comments: <textarea name=\"C$surveyA_id\" cols=\"40\" rows=\"10\"> $commentA[$surveyA_id]</textarea><br/>";

                           }

          if ($test_type ==3){
        $answerA .="<input type=\"checkbox\"  name=\"$surveyQ_id\" $sz_C5[$surveyA_id]> Edit Answer Text:  <input type=\"text\" name=\"Q$surveyA_id\" value=\"$answer[$surveyA_id]\"  size=\"200\"><br />
                 Points:  <select size=\"1\" name=\"P$surveyA_id\"><option selected value=\"$points[$surveyA_id]\" >$points[$surveyA_id]</option>
                   <option  value=\"0\">0</option>
                   <option  value=\"1\">1</option>
                   <option  value=\"2\">2</option>
                   <option  value=\"3\">3</option>
                   <option  value=\"4\">4</option>
                   <option  value=\"5\">5</option>
                   <option  value=\"6\">6</option> </select>   <br/>
         Edit Comments: <textarea name=\"C$surveyA_id\" cols=\"40\" rows=\"10\"> $commentA[$surveyA_id]</textarea><br/>";
                           }



         if ($test_type ==300){
        $answerA .="<input type=\"checkbox\"  name=\"$surveyQ_id\" $sz_C5[$surveyA_id]> Edit Answer Text:  <input type=\"text\" name=\"Q$surveyA_id\" value=\"$answer[$surveyA_id]\"  size=\"200\"><br />
                 Points:  <select size=\"1\" name=\"P$surveyA_id\"><option selected value=\"$points[$surveyA_id]\" >$points[$surveyA_id]</option>
                   <option  value=\"0\">0</option>
                   <option  value=\"1\">1</option>
                   <option  value=\"2\">2</option>
                   <option  value=\"3\">3</option>
                   <option  value=\"4\">4</option>
                   <option  value=\"5\">5</option>
                   <option  value=\"6\">6</option>
 <option  value=\"7\">7</option>
 <option  value=\"8\">8</option>
 <option  value=\"9\">9</option>
 <option  value=\"10\">10</option>
 </select>   <br/>
         Edit Comments: <textarea name=\"C$surveyA_id\" cols=\"40\" rows=\"10\"> $commentA[$surveyA_id]</textarea><br/>";
                           }




          if ($test_type ==301){

include("../../../upload/php/files/listfiles.php");

$webjump="$loc2/upload/customer/folder_admin.php?foldnamee=IMAGES&fold=image&log=admin&dlog=2";
        $answerA .=" 

Need to upload photo? Click <a href=\"$webjump\" target=\"blank\"><b> here.</b></a> You may need to refresh to see latest list.<br/><br/>

<input type=\"checkbox\"  name=\"$surveyQ_id\" $sz_C5[$surveyA_id]> Edit Answer Text: 
<select size=\"1\" name=\"Q$surveyA_id\"> <option selected value=\"$answer[$surveyA_id]\" >$answer[$surveyA_id]</option>
$bobstuff<br/>





                 Points:  <select size=\"1\" name=\"P$surveyA_id\"><option selected value=\"$points[$surveyA_id]\" >$points[$surveyA_id]</option>
                   <option  value=\"0\">0</option>
                   <option  value=\"1\">1</option>
                   <option  value=\"2\">2</option>
                   <option  value=\"3\">3</option>
                   <option  value=\"4\">4</option>
                   <option  value=\"5\">5</option>
                   <option  value=\"6\">6</option> 
 <option  value=\"7\">7</option>
 <option  value=\"8\">8</option>
 <option  value=\"9\">9</option>
 <option  value=\"10\">10</option>
</select>   <br/>
         Edit Comments: <textarea name=\"C$surveyA_id\" cols=\"40\" rows=\"10\"> $commentA[$surveyA_id]</textarea><br/>";
                           }




          if ($test_type ==4){

                           if($answer["$surveyA_id"] =="states"){
                              $display_state="";
                             include("../../../survey/display_state.php");

        $answerA .="    <b>State:</b><select size=\"1\" name=\"$surveyQ_id\"><option selected value=\"$state\">$state</option>
                            $display_state <br /> </select>

                             Edit Comments: <input type=\"text\" name=\"C$surveyQ_id\" value=\"$commentA[$surveyA_id]\" size=\"150\" />";

                           }


                             if($answer["$surveyA_id"] =="countries"){
                            $display_country="";
                             include("../../../survey/display_country.php");
        $answerA .="    <b>Country:</b><select size=\"1\" name=\"$surveyQ_id\"><option selected value=\"$county\">$country</option>
                            $display_country <br /> </select>
                            <input type=\"hidden\" name=\"A$surveyQ_id\" value=\"999\" />
                             Edit Comments: <input type=\"text\" name=\"C$surveyQ_id\" value=\"$commentA[$surveyA_id]\" size=\"150\" />";
                           }


                           }




///$questionBB= $question["$surveyQ_id"];


 }
 $k=$k+1;
 //$display_block .=  "Q$surveyQ_id =  $question[$surveyQ_id]  <br/>$answer[$surveyA_id]<br/>";
  // $display_blockAdmin3 .=  "<br /><br />Q$surveyQ_id =  $question[$surveyQ_id]  <br/>$answerA<br />";
  $display_blockAdmin3 .=  "
  <h3 class=\"collapsible\" id=\"section21$surveyQ_id\"><b>Q$k</b>: $question[$surveyQ_id]</span><h3>
<div class=\"container\">
    <div class=\"content\">
  <br /><FORM  name=\"formcheck3\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
                <input type=\"hidden\" name=\"agent\" value=\"$agent_id\" />
               <input type=\"hidden\" name=\"gbad\" value=\"501\"  />
               <input type=\"hidden\" name=\"gbadMod\" value=\"1\"  />
                <input type=\"hidden\" name=\"jedID2\" value=\"10\"  />
                <input type=\"hidden\" name=\"Quest\" value=\"$surveyQ_id\"  />
                 <input type=\"hidden\" name=\"survey_idw\" value=\"$survey_id\"  />
                 <br /><br /><b>Q$k</b>:  $question[$surveyQ_id]<br/><i>Edit Q:</i> <input type=\"text\" name=\"Edit\" value=\"$question[$surveyQ_id]\" size=\"150\" />  <br/>
  $answerA<br /> Update Q$k:	<input name=\"button name2\" type=\"image\" src=\"GoTool/image/add.png\" align=\"center\" /></form></div></div>";
    $answerA="";
}


 $result33 = @mysqli_query($connection,$sq112a) or die(mysqli_error($connection));
  $num33a = mysqli_num_rows($result33);

  if ($num33a >0){


   $result222 = @mysqli_query($connection,$sq112a) or die(mysqli_error($connection));
while ($row1 = mysqli_fetch_array($result222)) {
$surveyQQ_id=  $row1['surveyQQ_id'];
$surveyQ_id=  $row1['surveyQ_id'];
  $Cquestion=   stripslashes($row1['question']);
  $Cstatus=  stripslashes($row1['status']);
  $Ccreate_date= $row1['create_date'];

  $del_listQ .="<option  value=\"$surveyQQ_id\"> Question $surveyQ_id -$Cquestion </option>";
  $add_listQ .="<option  value=\"$surveyQ_id\"> Question $surveyQ_id -$Cquestion </option>";
                                }

  $deleteQ .= "<FORM  name=\"formcheck355\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\" >
                Select the Question to Delete <i>Note: Answers to a deleted question become unaccessible</i>: <br/><br/>
                 <select size=\"1\" name=\"del_Q\">
                $del_listQ</select>
                <input type=\"hidden\" name=\"agent\" value=\"$agent_id\" />
                <input type=\"hidden\" name=\"gbad\" value=\"201\"  />
               <input type=\"hidden\" name=\"gbadMod\" value=\"1\"  />
                 <input type=\"hidden\" name=\"lookD\" value=\"$survey_id\"  />
                 <input type=\"hidden\" name=\"survey_idWa\" value=\"$survey_id\"  />
                <input type=\"hidden\" name=\"jedID2\" value=\"7\"  /> <br />
                <i>Hit Submit to Delete.<i>
				<input name=\"button name0\" type=\"image\" src=\"GoTool/image/delete_small.png\" align=\"center\" /></form>";

    $addAnswerQ .= "<FORM  name=\"formcheck355\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\" >
                Select the Question to <font color=\"red\">Add Answer </font><i>Note: Answers will be placed at the end. Use mainly for Checkbox or Radio button questions. Do not mix types.</i>: <br/><br/>
                 <select size=\"1\" name=\"addA_Q\">
                $add_listQ</select>
                <input type=\"hidden\" name=\"agent\" value=\"$agent_id\" />
                <input type=\"hidden\" name=\"gbad\" value=\"201\"  />
               <input type=\"hidden\" name=\"gbadMod\" value=\"1\"  />
                 <input type=\"hidden\" name=\"lookD\" value=\"$survey_id\"  />
                 <input type=\"hidden\" name=\"survey_idWa\" value=\"$survey_id\"  />
                <input type=\"hidden\" name=\"jedID2\" value=\"81\"  /> <br />
                <i>Hit Submit to Add Answer.<i>
				<input name=\"button name0\" type=\"image\" src=\"GoTool/image/add.png\" align=\"center\" /></form>";

    $sq112bc="SELECT * FROM $table_name77 Where survey_id ='$survey_num' Order By surveyQ_id , surveyA_id";
    $result222b = @mysqli_query($connection,$sq112bc) or die(mysqli_error($connection));
while ($row1a = mysqli_fetch_array($result222b)) {
$surveyQ_id=  $row1a['surveyQ_id'];

$surveyA_id=  $row1a['surveyA_id'];

  $Canswer=   stripslashes($row1a['answer']);
  //$Cstatus=  stripslashes($row1a['status']);
 // $Ccreate_date= $row1a['create_date'];
 // $del_listA .="<option  value=\"$surveyA_id\"> Question $surveyQ_id: Answer $i2 </option>";
 $del_listA .="<option  value=\"$surveyA_id\"> Question $surveyQ_id: Answer - $Canswer </option>";
                                }


  $deleteA .= "<FORM  name=\"formcheck3a11\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
                Select Answer to Delete: <br/><br/>
                 <select size=\"1\" name=\"bat\">
                $del_listA</select>
                <input type=\"hidden\" name=\"agent\" value=\"$agent_id\" />
                <input type=\"hidden\" name=\"Dbad\" value=\"301\"  />
               <input type=\"hidden\" name=\"gbadMod\" value=\"1\"  />
                 <input type=\"hidden\" name=\"lookD\" value=\"$survey_id\"  />
                 <input type=\"hidden\" name=\"survey_idW\" value=\"$survey_id\"  />
                <input type=\"hidden\" name=\"jedID2\" value=\"6\"  /><br />
                <i>Hit Submit to Delete.<i>
				<input name=\"button name0\" type=\"image\" src=\"GoTool/image/delete_small.png\" align=\"center\" /></form>";

                              //test_type is the key          //0 -administrative,
  $del_listAdd .="<option  value=\"0\">Question with Text Box Input</option>
                   <option  value=\"2\">Question with Radio Button Input</option>
                   <option  value=\"3\">Question with Check Box Input</option>
<option  value=\"300\">Question with Multiple Answer Check Box Input</option>
<option  value=\"301\">Image Question with Multiple Answer Check Box Input</option>
<option  value=\"6\">Question with Text or Short Essay Area Input</option>
<option  value=\"5\">Question with Dropdown (Pull Down) Input</option>
<option  value=\"7\">Question with Employment Form Input</option>
<option  value=\"8\">Question with Schooling Form Input</option>
<option  value=\"9\">Question with Certification Form Input</option>
<option  value=\"10\">Question with Military Form Input</option>
<option  value=\"11\">Question with Community Service Form Input</option>
<option  value=\"12\">Question with Ministries Form Input</option>
<option  value=\"13\">Question with Multiple Residences</option>
<option  value=\"14\">Question with People Related to Master Form</option>
                   <option  value=\"19\">Question Requiring State Pull Down</option>
                   <option  value=\"29\">Question Requiring Country Pull Down</option> ";



  $AddQs .= "<FORM  name=\"formcheck344\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
                What type of Question to Add: <br/><br/>
                 <select size=\"1\" name=\"del_Add\">
                $del_listAdd </select>
                <input type=\"hidden\" name=\"agent\" value=\"$agent_id\" />
               <input type=\"hidden\" name=\"gbad\" value=\"401\"  />
               <input type=\"hidden\" name=\"gbadMod\" value=\"1\"  />
                 <input type=\"hidden\" name=\"lookD\" value=\"$survey_id\"  />
                 <input type=\"hidden\" name=\"survey_id\" value=\"$survey_id\"  />
                <input type=\"hidden\" name=\"jedID2\" value=\"8\"  /><br />
                <i>Hit Submit to Add.<i>
				<input name=\"button name0\" type=\"image\" src=\"GoTool/image/add.png\" align=\"center\" /></form>
<br/><br/>
<FORM  name=\"formcheck344\"  METHOD=\"POST\" ACTION=\"GoTool/$prog?token=$tok&log=$logged\">
                Need to Change a Question Type? Choose Question: <br/><br/>
 <select size=\"1\" name=\"what_Q\">
                $add_listQ</select>
                Change the Question Type to:
                 <select size=\"1\" name=\"del_change\">
                $del_listAdd </select>
                <input type=\"hidden\" name=\"agent\" value=\"$agent_id\" />
               <input type=\"hidden\" name=\"gbad\" value=\"4010\"  />
               <input type=\"hidden\" name=\"gbadMod\" value=\"1\"  />
                 <input type=\"hidden\" name=\"lookD\" value=\"$survey_id\"  />
                 <input type=\"hidden\" name=\"survey_id\" value=\"$survey_id\"  />
                <input type=\"hidden\" name=\"jedID2\" value=\"800\"  /><br />
                <i>Hit Submit to Change.<i>
				<input name=\"button name0\" type=\"image\" src=\"GoTool/image/add.png\" align=\"center\" /></form>


";


  $displayAdda .="<table class=\"list\"><tbody><tr>
  <td>$AddQs</td>
  <td>$deleteQ</td>
  <td>$deleteA</td>
  </tr>
  <tr><td><br />$addAnswerQ</td>
  <td> </td>
  <td> </td></tr></tbody></table>";



   $display_blockAdmin3 .= " <h3 class=\"collapsible\" id=\"section31\">Ready to add a new question?</span><h3>
<div class=\"container\">
    <div class=\"content\"><br/><br/><hr><div class=success2> Ready to add a new question?</div><hr><br/><br/> $displayAdda<br/><br/></div></div>";
                }

?>
