<?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; }