<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
include_once "control.php";
$db = new DB_Connect();
$staff = $db->get_staff();
//print_r($_POST);
if (isset($_POST['export_times']) && $_POST['export_times']) {
$start = $_POST['start'] . " 00:00:00";
$end = $_POST['end'] . " 23:59:59";
$staff = $_POST['staff'];
$timeSheet = $db->export_times($start, $end, $staff);
$output = fopen("php://output", 'w') or die("Can't open php://output");
header("Content-Type:application/csv;charset=utf-8;");
header("Content-Disposition:attachment;filename=Timesheet.csv;");
fputcsv($output, array('Task ID', 'Job No', 'Client', 'Job Category', 'Staff Member', 'Description', 'Start', 'End', 'Time'));
foreach ($timeSheet as $product) {
$s = strtotime($product['start']);
$e = strtotime($product['end']);
$d = abs($s - $e);
$product['time'] = sprintf('%02d:%02d:%02d', $d / 3600, $d / 60 % 60, $d % 60);
fputcsv($output, $product);
}
fclose($output) or die("Can't close php://output");
exit;
}
include "header.php";
?>
<div class="container">
<div class="row" >
<?php
include_once "control.php";
$db = new DB_Connect();
if (isset($_POST["start_job"]) && $_POST["start_job"]) {
$data = array("job_id" => $_POST['job'], "staff" => $_POST['staff'], "desc" => $_POST['desc'], "jobCat" => $_POST['Job_Category']);
echo $db->save_start($data);
exit;
}
if (isset($_POST["end_job"]) && $_POST["end_job"]) {
$data = array("taskID" => $_POST['taskID']);
echo $db->save_end($data);
exit;
}
if (isset($_POST["get_staff"]) && $_POST["get_staff"]) {
echo json_encode($db->get_staff());
exit;
}
if (isset($_POST["get_jobs"]) && $_POST["get_jobs"]) {
echo json_encode($db->get_jobs());
exit;
}
if (isset($_POST['update_job']) && $_POST['update_job']) {
$data = array("id" => $_POST["id"], "job_id" => $_POST['job_id'], "client" => $_POST['client'], "job_name" => $_POST['job_name'], "quoted_cost" => $_POST['quoted_cost']);
echo $db->update_job($data);
exit;
}
