/**
* Delete a department
*
* @param DepartmentEntity the department object
*/
public function delete(DepartmentEntity $department)
{
$sql = "DELETE FROM Department WHERE Id = :id";
$stmt = $this->db->prepare($sql);
$result = $stmt->execute(["id" => $department->getId()]);
if (!$result) {
throw new Exception("could not delete record");
}
}
// New Department
$app->get('/department/new', function ($request, $response, $args) {
$this->logger->info("Creating new department");
return $this->renderer->render($response, 'department/department.phtml', $args);
});
// New department POST
$app->post('/department/new', function ($request, $response) {
$this->logger->info("POST Creating new department");
$post_data = $request->getParsedBody();
$data = [];
$data['Name'] = filter_var($post_data['name'], FILTER_SANITIZE_STRING);
$data['RoomNumber'] = filter_var($post_data['room'], FILTER_SANITIZE_STRING);
$data['FaxNumber'] = filter_var($post_data['fax'], FILTER_SANITIZE_STRING);
$data['PhoneNumber1'] = filter_var($post_data['phoneOne'], FILTER_SANITIZE_STRING);
$data['PhoneNumber2'] = filter_var($post_data['phoneTwo'], FILTER_SANITIZE_STRING);
$department = new DepartmentEntity($data);
$department_mapper = new DepartmentMapper($this->db);
$this->logger->info("Creating new department " . $department->getName());
$department_mapper->save($department);
$response = $response->withRedirect("/index.php/departments");
return $response;
});
//Edit Department GET
$app->get('/department/{id}/edit', function ($request, $response, $args) {
$id = (int) $args['id'];
$mapper = new DepartmentMapper($this->db);
$department = $mapper->getDepartmentById($id);
$this->logger->info("Edit Department " . $id);
return $this->renderer->render($response, 'department/edit_department.phtml', [$args, "department" => $department]);
});
// EDIT Department POST
