/**
* Returns article model found by the key.
*
* @param string $id
* @param string $locale
* @return ArticleModel|null
*/
public function getArticleByIdLocale($id, $locale = '')
{
$sql = 'SELECT * FROM [prefix]_articles as p
INNER JOIN [prefix]_articles_content as pc ON p.id = pc.article_id
WHERE p.`id` = "' . (int) $id . '" AND pc.locale = "' . $this->db()->escape($locale) . '"';
$articleRow = $this->db()->queryRow($sql);
if (empty($articleRow)) {
return null;
}
$articleModel = new ArticleModel();
$articleModel->setId($articleRow['id']);
$articleModel->setCatId($articleRow['cat_id']);
$articleModel->setAuthorId($articleRow['author_id']);
$articleModel->setVisits($articleRow['visits']);
$articleModel->setDescription($articleRow['description']);
$articleModel->setTitle($articleRow['title']);
$articleModel->setContent($articleRow['content']);
$articleModel->setLocale($articleRow['locale']);
$articleModel->setPerma($articleRow['perma']);
$articleModel->setDateCreated($articleRow['date_created']);
$articleModel->setArticleImage($articleRow['article_img']);
$articleModel->setArticleImageSource($articleRow['article_img_source']);
return $articleModel;
}
