<?php
  $task = $_POST["task"];
  $payCode = $_POST["payCode"];
  $startTime = $_POST["startTime"];
  $finishTime = $_POST["finishTime"];
  $totalBreaks = $_POST["totalBreaks"];
  $totalHours = $_POST["totalHours"];
  $comments = $_POST["comments"];
  $title = $_POST["title"];
  $value = $_POST["value"];
  $receipt = $_POST["receipt"];
  $converted_receipt = ($receipt) ? 'true' : 'false';
  $servername = "localhost";
  $username = "root";
  $pass = "pass";
  $dbName = "SheetPal";
  $conn = mysqli_connect($servername , $username , $pass , $dbName);

  if(!$conn){
    die("Connection failed: " . mysqli_connect_error());
  }

  $expenseSql = $conn->prepare("INSERT INTO expenses(title , value , receipt)
  VALUES (?  , ? , ?)");

  $expenseSql->bind_param("sss" , $title , $value , $receipt);

  $expenseSql->execute();

  $expenseID = $expenseSql->insert_id;

  $shiftsSql = $conn->prepare("INSERT INTO shifts (task , paycode , starttime , finishtime , breaks , totalhours , expenseid , comments)
  VALUES (? , ? , ? , ? , ? , ? , ? , ?)");

  $shiftsSql->bind_param("ssssssss" , $task , $payCode , $startTime , $finishTime , $totalBreaks , $totalHours , $expenseID , $comments);

  $shiftsSql->execute();

  if(mysqli_query($conn , $expenseSql)) {
    echo true;
  }
  else{
    echo "Error: " . $expenseSql . "\n" . mysqli_error($conn);
  }

  if(mysqli_query($conn, $shiftsSql)) {
    echo true;
  }
  else {
    echo "Error: " . $shiftsSql . "\n" . mysqli_error($conn);
  }

  mysqli_close($conn);
?>