public function all($params)
{
$params['order'] = isset($params['order']) ? $params['order'] : ['id|ASC'];
$statuses = Status::select("statuses.*");
$statuses = parent::execute($statuses, $params);
return $statuses;
}
public function status_data()
{
\DB::statement(\DB::raw('set @rownum=0'));
$status = Status::select([\DB::raw('@rownum := @rownum + 1 AS rownum'), 'id', 'name']);
return Datatables::of($status)->addColumn('action', function ($stat) {
return '<a href="./status/edit/' . $stat->id . '" class="btn btn-xs btn-primary"><i class="glyphicon glyphicon-edit"></i> Edit</a>';
})->make(true);
}
public function getformAction()
{
if (!$this->isXmlHttpRequest()) {
throw new \Exception('Неверный тип запроса!');
}
$project = false;
if (!is_null($this->request->getPost('id'))) {
$id = (int) $this->request->getPost('id');
$projectsModel = new Projects();
$project = $projectsModel->getProjectsDataForEdit($id);
$usersModel = new Users();
$usersModel->setWhere('`roles_id` IN(1,2)');
$this->view->initiators = $usersModel->select();
$usersModel->setWhere('`roles_id` IN(1,3)');
$this->view->executors = $usersModel->select();
$executorsModel = new Executors();
$this->view->selectedExecutors = $executorsModel->getExecutorsAsArrayByProject($id);
$statusModel = new Status();
$this->view->statuses = $statusModel->select();
}
$this->view->project = $project;
}
