<?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();