public function indexAction($id = false) { if (!$id) { return Brightery::error404(); } $this->permission('index'); $issues = new \modules\pm\models\Pm_issues(); $issues->_select = "pm_issue_id, title, description,pm_project_id,pm_priority_id , deadline ,estimated_time,\n (SELECT users.fullname FROM users WHERE users.user_id = pm_issues.pm_reviewer_id) AS reviewer,\n (SELECT pm_projects.title FROM pm_projects WHERE pm_projects.pm_project_id = pm_issues.pm_project_id) AS project,\n (SELECT pm_priorities.color FROM pm_priorities WHERE pm_priorities.pm_priority_id = pm_issues.pm_priority_id) AS priority,\n (SELECT pm_priorities.name FROM pm_priorities WHERE pm_priorities.pm_priority_id = pm_issues.pm_priority_id) AS priority_title,\n (SELECT pm_issues_types.title FROM pm_issues_types WHERE pm_issues_types.pm_issue_type_id = pm_issues.pm_issue_type_id) AS issue_type "; $issues->pm_issue_id = $id; $comments = new \modules\pm\models\Pm_comments(); $comments->_select = "pm_comment_id,pm_issue_id,comment,time,parent,\n (SELECT users.fullname FROM users WHERE users.user_id = pm_comments.user_id) AS username,\n (SELECT users.image FROM users WHERE users.user_id = pm_comments.user_id) AS image"; $comments->pm_issue_id = $id; $comments->parent = 0; $activities = new \modules\pm\models\Pm_history(); $activities->pm_issue_id = $id; $attach = new \modules\pm\models\Pm_attachments(); $attach->_select = "pm_attachment_id, file_name, type, pm_issue_id"; $attach->pm_issue_id = $id; return $this->render('pm_issue_details/index', ['item' => $issues->get(), 'comments' => $comments->get(), 'attach' => $attach->get(), 'comment_model' => $comments, 'total' => $activities->takenTime($id), 'assigned' => $issues->assignedIssues($id)]); }