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; }