<?php

  $display_block1='';
//$jedID2=0;
$jedID2A='';
$surveyQ_id='';
 $num331bd='';
  $num331bde='';

 if (isset($_POST['jedID2'])) {
	$jedID2=$_POST['jedID2'];
}
$answerA='';
$hiwhy2A1 ='';
 $displayAdvice='';
  $display_blockRA='';
                $startsaying='';

    //      for ($t=1;$t<=100; $t++){
      //   $van[$t]='';
     //     }

                    $num331at='';
    $sq112bgt="SELECT * FROM $table_name804 Where dropdown_id ='2' AND dvalue !='7' Order By table_id ASC";
  $result112bgt = @mysqli_query($connection,$sq112bgt) or die(mysqli_error($connection));
         $num331at = mysqli_num_rows($result112bgt);

             if ($jedID2 == 8) {
         $Rtoday=date("Y-m-d H:i:s");
           $cust_id=$text_account3;
           $logA=$cust_id;
           $bobBT='';


             //$log=$_POST['log'];
              // $tok=$_GET['token'];

      $sq112bg="SELECT * FROM $table_name804 Where dropdown_id ='2' AND dvalue !='7' Order By table_id DESC LIMIT 1";
  $result112bg = @mysqli_query($connection,$sq112bg) or die(mysqli_error($connection));
  while ($row112bg = mysqli_fetch_array($result112bg)) {
      $BgbadMod=  $row112bg['table_id'];
         }


      $sq112bg="SELECT * FROM $table_name804 Where dropdown_id ='2' AND dvalue !='7' Order By table_id ASC LIMIT 1";
  $result112bg = @mysqli_query($connection,$sq112bg) or die(mysqli_error($connection));
  while ($row112bg = mysqli_fetch_array($result112bg)) {
      $BgbadModL=  $row112bg['table_id'];
         }

   //  $gbadMod=100;
     for ($st=$BgbadModL;$st<=$BgbadMod; $st++){

    // $bobBT="BT$t";
    $vvan[$st] = (isset($_POST["BBT$st"]) ? $_POST["BBT$st"] : null);
        // $vvan[$t]=addslashes($_POST["BT$t"]);

         if ($vvan[$st]==0){
           $sq112b1a="SELECT * FROM $table_name806 Where customer_id ='$cust_id' AND  task_id ='$st' AND status='1'";
              $result112b1a = @mysqli_query($connection,$sq112b1a) or die(mysqli_error($connection));
 $num331a = mysqli_num_rows($result112b1a);
          if  ($num331a>0){
          $status=0;
          $sql2 = "UPDATE $table_name806 SET  date_added='$Rtoday',  status='$status' , na1='$status' , approver= '$logA' Where customer_id ='$cust_id'AND  task_id ='$st' ";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));

          }

                   }//end =0
         if ($vvan[$st]==1){
                $status=1;
           $sq112b1a="SELECT * FROM $table_name806 Where customer_id ='$cust_id' AND  task_id ='$st'";
              $result112b1a = @mysqli_query($connection,$sq112b1a) or die(mysqli_error($connection));
 $num331a = mysqli_num_rows($result112b1a);
          if  ($num331a>0){

           $sql2 = "UPDATE $table_name806 SET  date_added='$Rtoday',  status='$status' ,na1='0', approver= '$logA' Where customer_id ='$cust_id'AND  task_id ='$st' ";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));

          }else{
     $sql2 = "INSERT INTO $table_name806 (customer_id, date_added,  task_id, status, approver ,na1  ) VALUES ('$cust_id', '$Rtoday', '$st', '$status' , '$logA', '0' )";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));


        }//end else
             $status='';
     }


  //----

           if ($vvan[$st]==2){
                $status=2;
           $sq112b1a="SELECT * FROM $table_name806 Where customer_id ='$cust_id' AND  task_id ='$st'";
              $result112b1a = @mysqli_query($connection,$sq112b1a) or die(mysqli_error($connection));
 $num331a = mysqli_num_rows($result112b1a);
          if  ($num331a>0){

           $sql2 = "UPDATE $table_name806 SET  date_added='$Rtoday',  na1='$status' ,status='0', approver= '$logA' Where customer_id ='$cust_id'AND  task_id ='$st' ";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));

          }else{
     $sql2 = "INSERT INTO $table_name806 (customer_id, date_added,  task_id, na1, approver,status   ) VALUES ('$cust_id', '$Rtoday', '$st', '$status' , '$logA','0' )";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));


        }//end else
             $status='';
     }

        }
         $startsaying .="<br/><div class=\"success2\"> CAP Records have been updated. </div> ";
  $jedID2 = 9 ;
    }


 if ($jedID2 == 9) {

$cust_id=$text_account3;

     $sq112a="SELECT * FROM $table_name804 WHERE dropdown_id ='1' ";
  $result112a = @mysqli_query($connection,$sq112a) or die(mysqli_error($connection));
while ($row112a = mysqli_fetch_array($result112a)) {
  $surveyQ_id=  $row112a['table_id'];
 $stage[$surveyQ_id]=  $row112a['value'];
$comment[$surveyQ_id]=  $row112a['dvalue'];


   $sq112b="SELECT * FROM $table_name804 Where dropdown_id ='2'AND  dvalue ='$comment[$surveyQ_id]' Order By table_id";
  $result112b = @mysqli_query($connection,$sq112b) or die(mysqli_error($connection));
while ($row112b = mysqli_fetch_array($result112b)) {
      $surveyA_id=  $row112b['table_id'];
    // $test_type=  $row112b['test_type'];
     $utf8text  =  $row112b['value'];

       $utf8text = mb_convert_encoding($utf8text, 'HTML-ENTITIES', 'UTF-8');
                   $answer["$surveyA_id"]  =$utf8text;

          $Bsz_C5[$surveyA_id]='';
          $Bna1_C5[$surveyA_id]='';
          $Bcompl1_C5[$surveyA_id]='';

             $sq112b1="SELECT * FROM $table_name806 Where customer_id ='$cust_id'AND  task_id ='$surveyA_id' AND status='1'";
  $result112b1 = @mysqli_query($connection,$sq112b1) or die(mysqli_error($connection));
 $num331 = mysqli_num_rows($result112b1);
 if ($num331>0)  {
   $Bsz_C5[$surveyA_id]='checked';
 }


              $sq112b1a="SELECT * FROM $table_name806 Where customer_id ='$cust_id'AND  task_id ='$surveyA_id' AND na1='2'";
  $result112b1a = @mysqli_query($connection,$sq112b1a) or die(mysqli_error($connection));
 $num331a = mysqli_num_rows($result112b1a);
 if ($num331a>0)  {
   $Bna1_C5[$surveyA_id]='checked';
 }

             $sq112b1b="SELECT * FROM $table_name806 Where customer_id ='$cust_id'AND  task_id ='$surveyA_id' AND compl1='1'";
  $result112b1b = @mysqli_query($connection,$sq112b1b) or die(mysqli_error($connection));
 $num331b = mysqli_num_rows($result112b1b);
 if ($num331b>0)  {
   $Bcompl1_C5[$surveyA_id]='<img src="admin/GoTool/image/icon/check1.png" alt="" />';
 }



            $Bstatus1='';
  $sq112b1c="SELECT * FROM $table_name806 Where customer_id ='$cust_id' AND task_id ='$surveyA_id' AND (compl1='1') ORDER BY  date_added DESC LIMIT 1";
 $result112b1c = @mysqli_query($connection,$sq112b1c) or die(mysqli_error($connection));
while ($row112b1c = mysqli_fetch_array($result112b1c)) {
                $status1=$row112b1c['date_addedC'];
                $status1=date("m-d-Y", strtotime("$status1")); //date("Y-m-d H:i:s");
                $Bstatus1="<font color=\"green\">$status1</font>";
               // $Bstatus1="<font color=\"green\">Completed - $status1</font>";
                }   //806
  //  $commentA[$surveyA_id] =  $row112b['comment'];
// $points[$surveyA_id]=  $row112b['A_points'];
$Bstatus10='';  //we turned this off on front side.

    //    $answerA .="<input type=\"checkbox\" value=\"1\" name=\"BT$surveyA_id\" $sz_C5[$surveyA_id]>  $answer[$surveyA_id] $status1   <br /> ";          <td><input type=\"radio\" value=\"0\" name=\"BBT$surveyA_id\"</td> >                               <td><input type=\"radio\" value=\"2\" name=\"BBT$surveyA_id\" $Bna1_C5[$surveyA_id]> </td>
            $answerA .="<tr><td width=\"150\"><input type=\"checkbox\" value=\"1\" name=\"BBT$surveyA_id\" $Bsz_C5[$surveyA_id]> </td><td>$answer[$surveyA_id]</td><td width=\"150\">$Bcompl1_C5[$surveyA_id] $Bstatus1   </td></tr> ";

         $status1='';
   }

$display_block1 .="$stage[$surveyQ_id]<br/>
     <table class=\"list\"><thead><tr><td>Completed</td><td>Pathway</td><td>CAP Confirmed</td></tr></thead>
     $answerA </table><br/><br/>";
     $answerA='';


     }                                                                                                             //  AND


   //         $sq112b1bd="SELECT * FROM $table_name806 Where customer_id ='$cust_id'AND (compl1='1'or  status ='1' or na1='2')";
 // $result112b1bd = @mysqli_query($connection,$sq112b1bd) or die(mysqli_error($connection));
// $num331bd = mysqli_num_rows($result112b1bd);

$num331bd =$num331at;

    $sq112b1bde="SELECT * FROM $table_name806 Where customer_id ='$cust_id'AND ( compl1='1'  or na1='2')";
  $result112b1bde = @mysqli_query($connection,$sq112b1bde) or die(mysqli_error($connection));
 $num331bde = mysqli_num_rows($result112b1bde);
       if ($num331bd>0){
        $thinge=round($num331bde/$num331bd*100);
        }else{
         $thinge=0;
        }


        if ($thinge==100){
        if( $num331bd != $num331bde){
         $thinge=99;
        }
        }
      $thinge1='';
          $thinge1=$thinge*8;                                                                                                        //token=$tok&log=$text_account3
           //
   $chart="<div align=\"center\"><!---$num331bd-$num331bde-$num331at--> You are $thinge% complete.  <br><table width=\"800\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
  <tr>
    <td align=\"left\" valign=\"top\"><img src=\"admin/GoTool/image/roadway/track-top.jpg\" width=\"800\" height=\"13\" /></td>
  </tr>
  <tr>
    <td height=\"7\" align=\"left\" valign=\"top\" bgcolor=\"#CCCCCC\"><img src=\"admin/GoTool/image/roadway/redwhite.gif\" width=\"$thinge1\" height=\"10\" /></td>
  </tr>
  <tr>
    <td align=\"left\" valign=\"top\"><img src=\"admin/GoTool/image/roadway/track-bottom1.jpg\" width=\"800\" height=\"18\" /></td>
  </tr>
</table></div>";


 $display_blockRA .=  " $chart<br/>
 <FORM name=\"feedbackform55\" id=\"feedbackform55\"  METHOD=\"POST\" ACTION=\"$badboy&a3a=$a3a\">
                 $displayAdvice
                $startsaying    <br />
                <input type=\"hidden\" name=\"agent\" value=\"\" />
                <input type=\"hidden\" name=\"cust_id\" value=\"$cust_id\" />
                <input type=\"hidden\" name=\"app\" value=\"\" />
                 <input type=\"hidden\" name=\"fname2\" value= \"\" size=\"40\" />
                <input type=\"hidden\" name=\"lname2\" value=\"\" size=\"40\" />
                <input type=\"hidden\" name=\"phone2\" value=\"\"  size=\"20\" />
                <input type=\"hidden\" name=\"email2\" value=\"\" size=\"40\" />
                <input type=\"hidden\" name=\"test_type\" value=\"100\"  />
                <input type=\"hidden\" name=\"gbadMod\" value=\"300\"  />
                 <input type=\"hidden\" name=\"jedID2\" value=\"8\"  />
                <input type=\"hidden\" name=\"jedID2A\" value=\"8\"  />


                $display_block1    <br />

                  	<input name=\"button name0\" type=\"image\" src=\"admin/GoTool/image/submit.png\" align=\"center\" />
                </form><br/><br/>";

  }



$hiwhy2A1=$display_blockRA;

// $display_sec1A="  <h3 class=\"collapsible\" id=\"section2\">CAP Requirements For Funding<span></span><h3>
//<div class=\"container\">
//    <div class=\"content\">
//$hiwhy2
//    </div>
//</div>";

?>