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;
