<?php  
require_once 'config.php';
  $start_date = $_POST['filter']['start_date'];
  $end_date = $_POST['filter']['end_date'];
  $chartData=array();
    if(isset($start_date) && isset($end_date) && !empty($start_date) && !empty($end_date))
    {
    } 
    else
    {
      $start_date = date('Y-m-d'); //today date
      $end_date = date('Y-m-d', strtotime('-7 day', strtotime($start_date)));
    }  
    $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 = '".$_SESSION['user_id']."' AND (assignments.submit_date BETWEEN '".$end_date."' AND '".$start_date."')  GROUP BY assignments.submit_date,assignments.user_id ");
    while($row = $total_ass->fetch_assoc()) 
    { 
        $chartData[] = 
          array("y" => $row['total'], 
            "label" => $row['submit_date'],
            'user_name'=>$row['user_name'],
            'assignment_id'=>$row['id'],
            'user_id'=>$row['user_id']
        );
    
      
    } //END WHILE Loop
    
     $dataPoints = array(
        "chartData"=>$chartData,
      );
         
    echo json_encode($dataPoints,JSON_NUMERIC_CHECK);
    
 ?>