<?php
  session_start();
  $servername = "localhost";
  $username = "root";
  $pass = "pass";
  $dbName = "SheetPal";
  $conn = mysqli_connect($servername , $username , $pass , $dbName);

  $userID = $_SESSION["userID"];
  $currentStart = $_POST["currentStart"];
  $currentEnd = $_POST["currentEnd"];

  if(!$conn){
    die("Connection failed: " . mysqli_connect_error());
  }
  $getWeek = $getWeek = $conn->prepare("SELECT date,task,paycode,starttime,finishtime,breaks,totalhours,comments
                                        FROM shifts
                                        WHERE userID = ?
                                        AND date > ?
                                        AND date < ?
                                        ORDER BY shiftID ASC");
  $getWeek->bind_param("s",$userID);
  $getWeek->execute();
  $getWeek->bind_result($date, $task, $paycode, $starttime, $finishtime, $breaks, $totalhours, $comments);
  $shift = array();
  while($getWeek->fetch()){
    $shiftObject = (object) [
      "date" => $date,
      "task" => $task,
      "paycode" => $paycode,
      "starttime" => $starttime,
      "finishtime" => $finishtime,
      "breaks" => $breaks,
      "totalhours" => $totalhours,
      "comments" => $comments
    ];
    array_push($shift,$shiftObject);
  }
  echo json_encode($shift);
  $conn->close();
//   echo json_encode($shift);
//   else{
//     if(!$getWeek = $conn->prepare("SELECT date,task,paycode,starttime,finishtime,breaks,totalhours,comments FROM shifts WHERE userID = ? ORDER BY shiftID ASC")){
//       echo "Getweek prepare failed: (" . $conn->error . ")";
//     }
//     else{
//       if(!$getWeek->bind_param("s",$userID)){
//         echo "Getweek bind parameter: " . $getWeek->error;
//       }
//       else{
//         $getWeek->execute();
//         if( !$getWeek->bind_result($date, $task, $paycode, $starttime, $finishtime, $breaks, $totalhours, $comments) ){
//           echo "Getweek bind results failed: (" . $getWeek->errno . ") " . $getWeek->error;
//         }
//         else{
//           $shift = array();
//           while($getWeek->fetch()) {
//             $shiftObject = (object) [
//               "date" => $date,
//               "task" => $task,
//               "paycode" => $paycode,
//               "starttime" => $starttime,
//               "finishtime" => $finishtime,
//               "breaks" => $breaks,
//               "totalhours" => $totalhours,
//               "comments" => $comments,
//             ];
//             array_push($shift,$shiftObject);
//           }
//           echo json_encode($shift);
//         }
//       }
//     }
//   }
//   $conn->close();
?>