<?php
if (!empty($_POST['details'])) {
//$html_link= $_POST['html_page_link'];
$details = $_POST['details'];
$expires_on = '0';
$num_of_emails = '0';
if (!empty($_POST['expires_on'])) {
$expires_on = $_POST['expires_on'];
}
if (!empty($_POST['num_of_emails'])) {
$num_of_emails = $_POST['num_of_emails'];
}
$status = addJob($details, $expires_on, $num_of_emails);
echo json_encode($status);
} else {
echo 'invalid call';
}
function addJob($details, $expires_on, $num_of_emails)
{
//filter_var($html_link,FILTER_VALIDATE_URL);
$return_val = array('status' => 1, 'error' => '');
//check if date is not already expired.
$expiry_timestamp;
if ($expires_on != 0) {
$date = explode('/', $expires_on);
$expiry_timestamp = mktime(0, 0, 0, $date[1], $date[0], $date[2]);
//echo $expiry_timestamp;
if (time() > mktime(0, 0, 0, $date[1], $date[0], $date[2])) {
$return_val['error'] = 'Expiry date not valid';
return $return_val;
}
//save job
if ($_POST["submitBtn"] == "Add") {
if ($_POST["split"] == "y") {
$start_time2 = $_POST["start_time2"];
$end_time2 = $_POST["end_time2"];
} else {
$start_time2 = "";
$end_time2 = "";
}
if ($_POST["jobGroup"] != "") {
$group = $_POST["jobGroup"];
} else {
$group = $_POST["dep_id"];
}
addJob($_POST["job_name"], $_POST["start_time"], $_POST["end_time"], $start_time2, $end_time2, $_POST["job_hours"], $group);
}
//delete job
if ($_POST["procedure"] == "Delete") {
deleteJob($_POST["jobid"]);
}
//############## Department Functions ################
//add category
if ($_POST["procedure"] == "ADD_DEPARTMENT") {
addDepartment($_POST["dep_name"]);
//delete category
} else {
if ($_POST["procedure"] == "DELETE_DEPARTMENT") {
deleteDepartment($_POST["dep_id"]);
//edit category
} else {
// Functions to connect to the DB
include "inc/general.inc.php";
// generic functions like DrawHeader and DrawFooter
include "inc/sorting.inc.php";
// Sorting functions
include "inc/jobs.inc.php";
include "inc/departments.inc.php";
include "inc/employees.inc.php";
include "inc/locations.inc.php";
$db_conn = databaseConnect();
// Connect to DB
// Functions that do NOT generate content to browser
// This is necessary to escape the 'warning headers already
switch (getCurrentAction()) {
case "insertJob":
addJob();
break;
case "updateJob":
updateJob();
break;
case "deleteJob":
deleteJob();
break;
case "insertDepartment":
addDepartment();
break;
case "updateDepartment":
updateDepartment();
break;
case "deleteDepartment":
deleteDepartment();
