Exemplo n.º 1
0
 case "addEmployee":
     $firstName = filter_input(INPUT_POST, "firstName", FILTER_SANITIZE_STRING);
     $lastName = filter_input(INPUT_POST, "lastName", FILTER_SANITIZE_STRING);
     $phoneNumber = filter_input(INPUT_POST, "phoneNumber", FILTER_SANITIZE_STRING);
     $eyeColor = filter_input(INPUT_POST, "eyeColor", FILTER_SANITIZE_STRING);
     $weight = filter_input(INPUT_POST, "weight", FILTER_SANITIZE_STRING);
     $height = filter_input(INPUT_POST, "height", FILTER_SANITIZE_STRING);
     $age = filter_input(INPUT_POST, "age", FILTER_SANITIZE_NUMBER_INT);
     $hairColor = filter_input(INPUT_POST, "hairColor", FILTER_SANITIZE_STRING);
     $address = filter_input(INPUT_POST, "address", FILTER_SANITIZE_STRING);
     $empAndTraits = array('firstName' => $firstName, 'lastName' => $lastName, 'phoneNumber' => $phoneNumber, 'eyeColor' => $eyeColor, 'weight' => $weight, 'height' => $height, 'age' => $age, 'hairColor' => $hairColor, 'address' => $address);
     $result = addEmployee($conn, $empAndTraits);
     break;
 case "deleteEmployee":
     $idToDelete = filter_input(INPUT_POST, "idToDelete", FILTER_SANITIZE_STRING);
     $result = deleteEmployee($conn, $idToDelete);
     break;
 case "editEmployee":
     $idToEdit = filter_input(INPUT_POST, "idToEdit", FILTER_SANITIZE_STRING);
     $firstName = filter_input(INPUT_POST, "firstName", FILTER_SANITIZE_STRING);
     $lastName = filter_input(INPUT_POST, "lastName", FILTER_SANITIZE_STRING);
     $phoneNumber = filter_input(INPUT_POST, "phoneNumber", FILTER_SANITIZE_STRING);
     $eyeColor = filter_input(INPUT_POST, "eyeColor", FILTER_SANITIZE_STRING);
     $weight = filter_input(INPUT_POST, "weight", FILTER_SANITIZE_STRING);
     $height = filter_input(INPUT_POST, "height", FILTER_SANITIZE_STRING);
     $age = filter_input(INPUT_POST, "age", FILTER_SANITIZE_NUMBER_INT);
     $hairColor = filter_input(INPUT_POST, "hairColor", FILTER_SANITIZE_STRING);
     $address = filter_input(INPUT_POST, "address", FILTER_SANITIZE_STRING);
     $empAndTraits = array('idToEdit' => $idToEdit, 'firstName' => $firstName, 'lastName' => $lastName, 'phoneNumber' => $phoneNumber, 'eyeColor' => $eyeColor, 'weight' => $weight, 'height' => $height, 'age' => $age, 'hairColor' => $hairColor, 'address' => $address);
     $result = editEmployee($conn, $empAndTraits);
 default:
Exemplo n.º 2
0
            saveEmployeeJob($_POST["emp_id"], $jobs[$i]->id, $_POST["job" . $jobs[$i]->id]);
        }
    }
    //save employee availability
    deleteEmployeeAvailability($_POST["emp_id"]);
    for ($i = 0; $i < count($shifts); $i++) {
        for ($j = 1; $j <= 7; $j++) {
            if (isset($_POST["shift" . $shifts[$i]->name . "-" . $j])) {
                saveEmployeeAvailable($_POST["emp_id"], $shifts[$i]->name, $j, "1");
            }
        }
    }
}
//delete job
if ($_POST["procedure"] == "Delete") {
    deleteEmployee($_POST["emp_id"]);
}
//edit employee selected
if ($_POST["procedure"] == "Edit") {
    $emp_id = $_POST["employees"];
    loadEmployee($emp_id);
    $btn_text = "Edit";
}
$staff = loadSortedEmployees();
?>

<br>

<div class="tabs">
	<ul>
		<li id="tab1" class="current"><span><a href="javascript:mcTabs.displayTab('tab1','panel1');" onMouseDown="return false;">Search</a></span></li>
Exemplo n.º 3
0
mysql_connect("mysql18.ezhostingserver.com", "hagan", "P@ssW0rd") or die(mysql_error());
mysql_select_db("employee") or die(mysql_error());
//call
if (function_exists($_GET['method'])) {
    echo $_GET['method'];
    if ($_GET['method'] = 'getAllEmployees') {
        if (isset($_GET['end'])) {
            $end = $_GET['end'];
        }
        getAllEmployees($end);
    }
    if ($_GET['method'] = 'deleteEmployee') {
        if (isset($_GET['id'])) {
            $id = $_GET['id'];
        }
        deleteEmployee($id);
    }
}
//methods
function getAllEmployees($end)
{
    $query = "select * from employees WHERE isDeleted = `0` LIMIT " . $end;
    $employee_sql = mysql_query($query);
    $employees = array();
    while ($employee = mysql_fetch_assoc($employee_sql)) {
        $employees[] = $employee;
    }
    $employees = json_encode($employees);
    echo $_GET['jsoncallback'] . '(' . $employees . ')';
}
function deleteEmployee($id)
Exemplo n.º 4
0
                                 pullVals($db);
                             } else {
                                 if (isset($_POST['addField']) && !empty($_POST['addField'])) {
                                     updateForm($db);
                                 } else {
                                     if (isset($_POST['input']) && !empty($_POST['input'])) {
                                         editEmployee($db);
                                     } else {
                                         if (isset($_POST['formData']) && !empty($_POST['formData'])) {
                                             createForm($db);
                                         } else {
                                             if (isset($_POST['allVals']) && !empty($_POST['allVals'])) {
                                                 submitUserCreatedForm($db);
                                             } else {
                                                 if (isset($_POST) && !empty($_POST)) {
                                                     deleteEmployee($db);
                                                 } else {
                                                     echo json_encode("There is no post and somehow you are here.");
                                                 }
                                             }
                                         }
                                     }
                                 }
                             }
                         }
                     }
                 }
             }
         }
     }
 }
Exemplo n.º 5
0
        addDepartment();
        break;
    case "updateDepartment":
        updateDepartment();
        break;
    case "deleteDepartment":
        deleteDepartment();
        break;
    case "insertEmployee":
        addEmployee();
        break;
    case "updateEmployee":
        updateEmployee();
        break;
    case "deleteEmployee":
        deleteEmployee();
        break;
    case "insertLocation":
        addLocation();
        break;
    case "updateLocation":
        updateLocation();
        break;
    case "deleteLocation":
        deleteLocation();
        break;
}
displayHeader();
// Show HTML header
displayNavigation();
// Show Navigation