public function getByIssueID($issue_id) { $crit = $this->getCriteria(); $crit->addWhere(self::ISSUE_ID, $issue_id); $crit->addJoin(Files::getTable(), Files::ID, self::FILE_ID); $res = $this->doSelect($crit, false); $ret_arr = array(); if ($res) { while ($row = $res->getNextRow()) { $file = new \thebuggenie\core\entities\File($row->get(Files::ID), $row); $file->setUploadedAt($row->get(self::ATTACHED_AT)); $ret_arr[$row->get(Files::ID)] = $file; } } return $ret_arr; }
public function getByArticleID($article_id) { $crit = $this->getCriteria(); $crit->addWhere(self::ARTICLE_ID, $article_id); $crit->addWhere(self::SCOPE, framework\Context::getScope()->getID()); $res = $this->doSelect($crit); $ret_arr = array(); if ($res) { while ($row = $res->getNextRow()) { try { $file = new \thebuggenie\core\entities\File($row->get(\thebuggenie\core\entities\tables\Files::ID), $row); $file->setUploadedAt($row->get(self::ATTACHED_AT)); $ret_arr[$row->get(\thebuggenie\core\entities\tables\Files::ID)] = $file; } catch (\Exception $e) { $this->doDeleteById($row->get(self::ID)); } } } return $ret_arr; }