/** * Update a department * * @param DepartmentEntity the department object */ public function update(DepartmentEntity $department) { $sql = "UPDATE Department SET Name = :name, RoomNumber = :room_number, FaxNumber = :fax, PhoneNumber1 = :phone_1, PhoneNumber2 = :phone_2 WHERE Id = :id"; $stmt = $this->db->prepare($sql); $result = $stmt->execute(["name" => $department->getName(), "room_number" => $department->getRoom(), "fax" => $department->getFax(), "phone_1" => $department->getPhoneOne(), "phone_2" => $department->getPhoneTwo(), "id" => $department->getId()]); if (!$result) { throw new Exception("could not update record"); } }
$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 $app->post('/department/edit', function ($request, $response) { $post_data = $request->getParsedBody();