public function getSome($whereClause = '1 = 1') { $sql = <<<SQL SELECT id , statusValue , isActive , sortKey , style , created , updated FROM applicationStatus WHERE {$whereClause} ORDER BY sortKey SQL; $stmt = $this->_dbh->prepare($sql); if (!$stmt) { throw new ControllerException('Failed to prepare SELECT statement. (' . $this->_dbh->error . ')'); } if (!$stmt->execute()) { throw new ControllerException('Failed to execute SELECT statement. (' . $this->_dbh->error . ')'); } $stmt->bind_result($id, $statusValue, $isActive, $sortKey, $style, $created, $updated); $models = array(); while ($stmt->fetch()) { $model = new ApplicationStatusModel(); $model->setId($id); $model->setStatusValue($statusValue); $model->setIsActive($isActive); $model->setSortKey($sortKey); $model->setStyle($style); $model->setCreated($created); $model->setUpdated($updated); $models[] = $model; } return $models; }
$auth->forbidden(); exit(0); // Should never get here but just in case... } $statusValue = Tools::post('statusValue'); $style = Tools::post('style'); $isActive = Tools::post('isActive'); $sortKey = Tools::post('sortKey'); $result = 'OK'; $applicationStatusId = ''; $newApplicationStatusModel = null; try { $applicationStatusModel = new ApplicationStatusModel(); $applicationStatusModel->setStatusValue($statusValue); $applicationStatusModel->setStyle($style); $applicationStatusModel->setIsActive($isActive); $applicationStatusModel->setSortKey($sortKey); $applicationStatusController = new ApplicationStatusController(); $applicationStatusId = $applicationStatusController->add($applicationStatusModel); if (!($applicationStatusId > 0)) { throw new ControllerException("Add failed."); } $newApplicationStatusModel = $applicationStatusController->get($applicationStatusId); $applicationStatusRowView = new ApplicationStatusListView(); $row = $applicationStatusRowView->displayApplicationStatusRow($newApplicationStatusModel, 'list'); } catch (ControllerException $e) { $applicationStatusRowView = new ApplicationStatusListView('html', null); $row = $applicationStatusRowView->displayApplicationStatusRow($newApplicationStatusModel, 'list', 'Add Application Status record failed. ' . $e->getMessage()); } $result = array('result' => $result, 'row' => $row, 'newId' => $applicationStatusId); echo json_encode($result) . PHP_EOL;