<?php
include_once("../config/config.php"); 
include_once(BASIC_PATH."model/group.php");
if(($_SESSION['nthrive_type']=="manager" || $_SESSION['nthrive_type']=="admin") && isset($_POST['id']))
{

        $id=$_POST['id'];

        $query="select * from users  where id=".$id;
        $result=$crud->getData($query);
        if(count($result)<1)
        {
           echo 'not avilable';
           exit();
        }
        $username=$result[0]['name'];
      


         $query="select i.name as incubator_name,gu.modified_date as group_assign_date,gm.patient_type,gm.complexity_level,gm.track ,i.id as incubator_id,gm.id as group_id,att.status,att.score from group_user gu inner join group_master gm on gm.id=gu.group_id left join case_group cg on cg.group_id=gu.group_id left join  incubators i on i.id=cg.incubator_id left join attempts att on att.incubator=i.id and att.user=gu.user_id where gu.user_id='$id'";
        $results=$crud->getData($query);
        if(count($results)<1)
        {
           echo 'not avilable';
           exit();
        }


        $query="select gm.* from group_master gm inner join group_user gu on gu.group_id=gm.id and gu.user_id='$id' order by gm.id asc";
        $groups=$crud->getData($query);
     ?> 


  <div class="col-sm-12">
            <h4 class="text-center text-capitalize txt_dark"><?php echo $username; ?></h4>

    <div class="form-inline">
        <div class="form-group">
           <input type="text" id="myInput" onkeyup="myFunction()" placeholder="Search for names.." title="Type in a name">
       </div>
       <div class="form-group">
        <select name="group" onchange="myFunction()" id="group" class="form-control">
          <option value="">Select</option> 
          <?php
          foreach ($groups as $group) {?>
           <option value="<?php echo $group['patient_type'].' '.$group['complexity_level'] .' '.$group['track'] ?>"><?php echo $group['patient_type'].' '.$group['complexity_level'] .'#'.$group['track'] ?></option>
          <?php }
          ?>
        </select>
      </div>
     <!-- <button type="submit" class="btn btn-default seacrh_submit_incubator">Submit</button> -->
   </div>
 </div>
<?php 
       /* $query="select a.completed,a.score,i.name  from attempts a inner join incubators i on a.incubator=i.id where a.status='completed' and a.user='$id'";
        $completed=$crud->getData($query);
        */
      //  $query="select i.name,i.id ,g.group_id from case_group g inner join incubators i on g.incubator_id=i.id inner join group_user gu on gu.group_id=g.group_id where  gu.user_id='$id' order by g.id desc";
    
echo "<div id='myUL1'>";
      $old_group="";
      $i=0;
     foreach ($results as $result) {
        if($old_group!=$result['group_id']){
          if($i!=0)
          {
            echo "</ul>";
          }
          $assignDate="";
                      if($result['group_assign_date']!="")
                      {
                        $assignDate=date('m/d/Y',$result['group_assign_date']);

                      }
                      $open=group::getOpenBygroupId($result['group_id'],$id);
                      $close=group::getClosedBygroupId($result['group_id'],$id);
                      $total=$open+$close;
                      $per=0;
                      if($total>0)
                      {
                        $per=$close*100/$total;
                        $per=round($per)."%";
                      }
          echo "<h3>".$result['patient_type']." ".$result['complexity_level']." ".$result['track']." <span class='pull-right'>".$assignDate." &nbsp;&nbsp;  ".$close.'/'.$total." (".$per.")"."</span></h3>";
           echo "<ul  id='myUL' class='myUL'>";
         
           $old_group=$result['group_id'];
         
           
        }
        
          $status=""; $score="";
          if($result['status']=="completed")
          {
            $status="completed"; $score=$result['score'];
            $status=$status."(".$score."%)";
          }

          echo "<li class='summery' data-id='".$result['incubator_id']."'>".$result['incubator_name']."  <span class='pull-right'>".$status."</span></li>";
            $i++;
        }
              

      
      if($i>0){
        echo "</ul>";
      }
echo '</div>';
      
}