<?php  
require_once '../config.php';
  $start_date = $_POST['filter']['start_date'];
  $end_date = $_POST['filter']['end_date'];
  $dataSachin=array();
  $dataVarun=array();
  $dataAshwin=array();
  $dataMansi=array();
  $dataDeeksha=array();
  $dataDipanjali=array();
  $dataKiranteja=array();
  $userId=array();
    $users = $conn->query("SELECT users.id,users.name from users left join role_user on users.id = role_user.user_id WHERE role_user.role_id=3 " );
    while($row = $users->fetch_assoc()) {
         $userId[]=$row;             
    }
    if(isset($start_date) && isset($end_date) && !empty($start_date) && !empty($end_date))
    {
    } 
    else
    {
      $end_date = date('Y-m-d'); //today date
      $start_date = date('Y-m-d', strtotime('-7 day', strtotime($end_date)));
    }  
      for ($i=0; $i <count($userId) ; $i++) 
      { 
        $total_ass = $conn->query("SELECT SUM(assignments.no_of_record) as total,assignments.id ,assignments.submit_date, assignments.user_id, users.name as user_name FROM assignments inner join users on users.id = assignments.user_id WHERE assignments.assignment_status_id = 2 AND assignments.user_id = '".$userId[$i]['id']."' AND (assignments.submit_date BETWEEN '".$start_date."' AND '".$end_date."')  GROUP BY assignments.submit_date,assignments.user_id ");
        while($row = $total_ass->fetch_assoc()) 
        {

          if($row['user_id']==2)
          {
            $dataDipanjali[] = 
              array("y" => $row['total'], 
                "label" => $row['submit_date'],
                'user_name'=>$row['user_name'],
                'assignment_id'=>$row['id'],
                'user_id'=>$row['user_id']
            );
          } //END IF

          if($row['user_id']==3)
          {
            $dataSachin[] = 
              array("y" => $row['total'], 
                "label" => $row['submit_date'],
                'user_name'=>$row['user_name'],
                'assignment_id'=>$row['id'],
                'user_id'=>$row['user_id'],
            );
          } //END IF
          if($row['user_id']==4)
          {

            $dataAshwin[] = 
              array("y" => $row['total'], 
                "label" => $row['submit_date'],
                'user_name'=>$row['user_name'],
                'assignment_id'=>$row['id'],
                'user_id'=>$row['user_id']
            );
          } //END IF
          if($row['user_id']==5)
          {
            $dataDeeksha[] = 
              array("y" => $row['total'], 
                "label" => $row['submit_date'],
                'user_name'=>$row['user_name'],
                'assignment_id'=>$row['id'],
                'user_id'=>$row['user_id']
            );
          } //END IF
          if($row['user_id']==6)
          {
            $dataVarun[] = 
              array("y" => $row['total'], 
                "label" => $row['submit_date'],
                'user_name'=>$row['user_name'],
                'assignment_id'=>$row['id'],
                'user_id'=>$row['user_id']
            );
          } //END IF

          if($row['user_id']==6)
          {
            $dataVarun[] = 
              array("y" => $row['total'], 
                "label" => $row['submit_date'],
                'user_name'=>$row['user_name'],
                'assignment_id'=>$row['id'],
                'user_id'=>$row['user_id']
            );
          } //END IF

          if($row['user_id']==6)
          {
            $dataKiranteja[] = 
              array("y" => $row['total'], 
                "label" => $row['submit_date'],
                'user_name'=>$row['user_name'],
                'assignment_id'=>$row['id'],
                'user_id'=>$row['user_id']
            );
          } //END IF

        } //END WHILE Loop
      } //END USER FOR Loop
    
     $dataPoints = array(
        "dataAshwin"=>$dataAshwin,
        "dataVarun"=>$dataVarun,
        "dataSachin"=>$dataSachin,
        "dataMansi"=>$dataMansi,
        "dataKiranteja"=>$dataKiranteja,
        "dataDeeksha"=>$dataDeeksha,
        "dataDipanjali"=>$dataDipanjali,
      );
         
    echo json_encode($dataPoints,JSON_NUMERIC_CHECK);
    
 ?>