<?php

 $welcome28="Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.";

  $logo3="<img src=\"images/FINALMITLogo.png\" width=\"200px\" alt=\"\" /> <br/> $welcome28 <br /><br />  ";

   $welcome29="Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.";

  $logo3="<img src=\"images/FINALMITLogo.png\" width=\"200px\" alt=\"\" /> <br/> $welcome29 <br /><br />  ";

     $Rtoday=date("Y-m-d h:i:s");
                $nn=$_POST['nn'];
             $log=$_POST['log'];
             $testy=$_POST['test'];
             $test_type=$_POST['applicant'];
                 $id2=$map_id1;
             $app_id = $testy;
             $survey_id2=$app_id;
           //  $form_id=$testy;

             if ($survey_id2==21){
               $map_id=$map_id1;
             }

              $pat_id=$test_type;

              if ($jedID2==28) {
          $something = "$logo3 You have signed this application, If you have completed all the sections and ready to submit please click the button below.

       <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"$prog977?token=$tok&log=$logged\">
                   <input type=\"hidden\" name=\"jedID2\" value=\"30\"  />
  	<input type=\"hidden\" name=\"applicant\" value=\"$map_id1\">
    	<input type=\"hidden\" name=\"ggbad\" value=\"VII\">
	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
    <input type=\"submit\" value=\"Submit Application\" /> </form>    <br/>

          " ;
                   }

               if ($jedID2==29) {
          $something = "$logo3 You have reviewed/completed your LifeTime Assessment. Please check over your work and make sure to upload:xxx.xxxx." ;
                   }


         $tag77[$T21]="Start Part I";
         $tag77[$T22]="Start Part II";
          $tag77[$T23]="Start Part III";
           $tag77[$T24]="Start Part IV";
            $tag77[$T25]="Start Part V";
             $tag77[$T26]="Start Part VI";
             $tag77[$T27]="Start Part VII";
              $tag77[$T28]="Start Part VIII";
               $tag77[$T29]="Start Part IX";

                      $tag77a[$T21]="Part I";
         $tag77a[$T22]="Part II";
          $tag77a[$T23]=" Part III";
           $tag77a[$T24]=" Part IV";
            $tag77a[$T25]="Part V";
             $tag77a[$T26]="Part VI";
             $tag77a[$T27]="Part VII";
             $tag77a[$T28]="Part VIII";
             $tag77a[$T29]="Part IX";

                      //  }

    //   include("special_report.php");

              for ($pt=$T21;$pt<=$T28; $pt++){
$sq112ab="SELECT * FROM $table_name78 WHERE test_type ='$test_type' AND app_id='$pt' ";
$result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error());
 $num3334[$pt] = mysql_num_rows($result112ab);

       $result222ab = @mysql_query($sq112ab,$connection) or die(mysql_error());
while ($row1b = mysql_fetch_array($result222ab)) {
    $map_id77=  stripslashes($row1b['map_id']);
}

    if ($num3334[$pt]>0) {
           if ($pt==$T21){
    $choice="map_id";
    }else {
    $choice="test_type";
    }

     $complete[$pt]="<img src=\"../admin/GoTool/image/done.png\" width=\"120px\">";

     $seeme[$pt]="<FORM  name=\"formcheck3\" target=\"blank\" METHOD=\"POST\" ACTION=\"$prog979?token=71014dbaceeee062cb7c877df8c22bc7&log=admin\">
                 <input type=\"hidden\" name=\"agent\" value=\"1\" />
                 <input type=\"hidden\" name=\"gbad\" value=\"1\"  />
                  <input type=\"hidden\" name=\"george2\" value=\"1\"  />
                 <input type=\"hidden\" name=\"sbad\" value=\"100\" size=\"40\" />
                 <input type=\"hidden\" name=\"survey_id\" value=\"$pt\"  />
                 <input type=\"hidden\" name=\"map_id777\" value=\"$id2\"  />
                 <input type=\"hidden\" name=\"map_id\" value=\"$map_id77\"  />
               <input type=\"hidden\" name=\"gbadMod\" value=\"1\"  />
                <input type=\"hidden\" name=\"jedID2\" value=\"3\"  />
                <input type=\"hidden\" name=\"bjed\" value=\"2\"  />
				Show Completed Section<input name=\"button name0\" type=\"image\" src=\"../admin/GoTool/image/add.png\" align=\"center\" /></form>";


    } else {
     $complete[$pt]="<img src=\"../admin/GoTool/image/notStarted.png\" width=\"120px\">";
     $start77[$pt]=" <input type=\"submit\" value=\"$tag77[$pt]\" name=\"B3\"> " ;
     $seeme[$pt]='';
    } //end else

 } //end for






  //$sql2="Delete FROM   $table_name109 WHERE map_id='$map_id' AND form_id=$form_id";
 //$result2 = @mysql_query($sql2,$connection) or die(mysql_error());

       //    $map_id=$test_type;





//For 27 upload//

    $sql33d11 ="SELECT DISTINCT file_name FROM $table_name104 WHERE map_id ='$map_id1' AND form_id ='$T27' Order by create_date Desc ";
 $result33d11 = @mysql_query($sql33d11,$connection) or die(mysql_error());
 while ($row12 = mysql_fetch_array($result33d11)) {

      $file_E=  $row12['file_name'];

   $sql33r ="SELECT * FROM $table_name104 WHERE map_id ='$map_id' AND file_name='$file_E' limit 1 ";

  $result33r = @mysql_query($sql33r,$connection) or die(mysql_error());
        $row22r =mysql_fetch_array($result33r,MYSQL_ASSOC);
      $user_E=$row22r['user_id'];
      $create_date=$row22r['create_date'];

     // $diplay_uploads.="<a href=\"$loc2/admin/GoTool/forms/forms_dep/$file_E\" target=\"blank\">$file_E</a> uploaded by user:$user_E on $create_date<br/>";
        $dirFix='';
     if($dirFix==$blink){
      $display_uploads.="<a href=\"$loc2/MIT/forms_dep/$file_E\" target=\"blank\">$file_E</a> uploaded on $create_date<br/>";
     }else{
     $display_uploads.="<a href=\"$dirFix/admin/GoTool/forms/forms_dep/$file_E\" target=\"blank\">$file_E</a> uploaded on $create_date<br/>";

     }

 }

     $sql33d11 ="SELECT DISTINCT file_name FROM $table_name104 WHERE map_id ='$map_id1' AND form_id='$T27' Order by create_date Desc ";
 $result33d11 = @mysql_query($sql33d11,$connection) or die(mysql_error());
       $num331b = mysql_num_rows($result33d11);

       if ($num331b>0){
        $complete[27]=$display_uploads;
       }

            $pig="B" ;
      $sql33d11 ="SELECT  * FROM $table_name200 WHERE (map_id ='$map_id1') AND (form_loc_id= '$pig') ";
 $result33d11a = @mysql_query($sql33d11,$connection) or die(mysql_error());
     while ($row123 = mysql_fetch_array($result33d11a)) {

      $file_E3=  $row123['image_2'];
        $display_sig="<img src=\"../sig/$file_E3\" >";
            }


       $num331bb = mysql_num_rows($result33d11a);

       if ($num331bb>0){
        $complete[28]=$display_sig;

         $george3="<br/><br/><FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"$prog977?token=$tok&log=$logged\">
                   <input type=\"hidden\" name=\"jedID2\" value=\"30\"  />
  	<input type=\"hidden\" name=\"applicant\" value=\"$map_id1\">
    	<input type=\"hidden\" name=\"ggbad\" value=\"VII\">
	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
    <input type=\"submit\" value=\"Submit Application\" /> </form>    <br/>";

       }


                          $pig="png";
       $sql33d11 ="SELECT * FROM $table_name78 WHERE (map_id ='$map_id1') AND company LIKE '%$pig%' ";
 $result33d11a = @mysql_query($sql33d11,$connection) or die(mysql_error());
     while ($row123 = mysql_fetch_array($result33d11a)) {

      $file_E3=  $row123['company'];



       // $display_sigT="<img src=\"GoSlider/$file_E3\" width=\"120\" >";
        $display_sigT="Click Chart to View<br/><a href=\"$loc2/MIT/GoSlider/$file_E3\"><img border=\"0\" src=\"GoSlider/$file_E3\"  width=\"120\" ></a>";

            }


       $num331bb = mysql_num_rows($result33d11a);

       if ($num331bb>0){
        $complete[$T26]=$display_sigT;



       }




                               $id2=$map_id1;
 $display_title= "Minister-In-Training Application";

$display_block="  <table><tbody><tr><td>

 <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"$prog977?token=$tok&log=$logged\">
 	<input type=\"hidden\" name=\"applicant\" value=\"$id2\">
  <input type=\"hidden\" name=\"jedID2\" value=\"\"  />
  	<input type=\"hidden\" name=\"testy\" value=\"$T21\">
    	<input type=\"hidden\" name=\"ggbad\" value=\"I\">
	<input type=\"hidden\" name=\"agent\" value=\"1\">
    	<input type=\"hidden\" name=\"nn\" value=\"1\">
$start77[21]
             Applicant Information </form>      <br /> <br /> </td><td>$complete[21]</td><td>$seeme[21]</td></tr>
       <tr><td>
               <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"$prog977?token=$tok&log=$logged\">
               	<input type=\"hidden\" name=\"applicant\" value=\"$id2\">
                <input type=\"hidden\" name=\"jedID2\" value=\"\"  />
  	<input type=\"hidden\" name=\"testy\" value=\"$T22\">
    	<input type=\"hidden\" name=\"ggbad\" value=\"II\">
	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
    	<input type=\"hidden\" name=\"nn\" value=\"1\">
$start77[22]
              Background</form>      <br /> <br />  </td><td>$complete[22]</td><td>$seeme[22]</td></tr>
    <tr><td>
               <FORM  name=\"formcheck55\" METHOD=\"POST\" ACTION=\"$prog977?token=$tok&log=$logged\">
               	<input type=\"hidden\" name=\"applicant\" value=\"$id2\">
                 <input type=\"hidden\" name=\"jedID2\" value=\"\"  />
  	<input type=\"hidden\" name=\"testy\" value=\"$T23\">
    	<input type=\"hidden\" name=\"ggbad\" value=\"III\">
	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
    	<input type=\"hidden\" name=\"nn\" value=\"1\">
$start77[23]
             Work History </form>      <br /> <br />  </td><td>$complete[23]</td><td>$seeme[23]</td></tr>
<tr><td>
          <FORM  name=\"formcheck55\" METHOD=\"POST\" ACTION=\"$prog977?token=$tok&log=$logged\">
               	<input type=\"hidden\" name=\"applicant\" value=\"$id2\">
                 <input type=\"hidden\" name=\"jedID2\" value=\"\"  />
  	<input type=\"hidden\" name=\"testy\" value=\"$T24\">
    	<input type=\"hidden\" name=\"ggbad\" value=\"IV\">
	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
    	<input type=\"hidden\" name=\"nn\" value=\"1\">
$start77[24]
              Community Involvement</form>      <br /> <br />     </td><td>$complete[24]</td><td>$seeme[24]</td></tr>
              <tr><td>
               <FORM  name=\"formcheck55\" METHOD=\"POST\" ACTION=\"$prog977?token=$tok&log=$logged\">
               	<input type=\"hidden\" name=\"applicant\" value=\"$id2\">
                <input type=\"hidden\" name=\"jedID2\" value=\"\"  />
  	<input type=\"hidden\" name=\"testy\" value=\"$T25\">
    	<input type=\"hidden\" name=\"ggbad\" value=\"V\">

	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
$start77[25]
             Beliefs </form>      <br /> <br />   </td><td>$complete[25]</td><td>$seeme[25]</td></tr>
  <tr><td>
    <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"$prog978?token=$tok&log=$logged\">
                   <input type=\"hidden\" name=\"jedID2\" value=\"\"  />
  	<input type=\"hidden\" name=\"applicant\" value=\"$id2\">
    	<input type=\"hidden\" name=\"ggbad\" value=\"VI\">
	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
$start77[26]
             LifeTime Assessment</form>      <br /> <br /></td><td>$complete[26]</td><td></td></tr>

     <tr><td>
    <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"$prog977?token=$tok&log=$logged\">
                   <input type=\"hidden\" name=\"jedID2\" value=\"15\"  />
  	<input type=\"hidden\" name=\"applicant\" value=\"$id2\">
    	<input type=\"hidden\" name=\"ggbad\" value=\"VI\">
	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
$start77[27]
             Upload Documents</form>      <br /> <br /></td><td colspan=\"2\">$complete[27]</td></tr>

   <tr><td>
    <FORM  name=\"formcheck55\"  METHOD=\"POST\" ACTION=\"$prog977?token=$tok&log=$logged\">
                   <input type=\"hidden\" name=\"jedID2\" value=\"16\"  />
  	<input type=\"hidden\" name=\"applicant\" value=\"$id2\">
    	<input type=\"hidden\" name=\"ggbad\" value=\"VI\">
	<input type=\"hidden\" name=\"agent\" value=\"$hi2\">
$start77[28]
             Sign And Submit Application</form>      <br /> <br /></td><td>$complete[28]</td><td></td></tr>

            </tbody>
             </table>


             $george3";

       //     $display_block77 .="$something <br /> <br />$comments7
         //   <br /><br /><!--- <a href=\"$prog?test=$testy&log=$log\">Reload the Test</a> -->";




?>
