public static function getOrderQuery(SmoothModel $model, $order, $lang = '')
{
$persistence = $model->getPersistence();
$sqlLang = '';
if (empty($lang) === false) {
$sqlEmptyLang = $persistence->quote('');
$sqlRequestedLang = $persistence->quote($lang);
$sqlLang = " AND (orderq.l_language = {$sqlEmptyLang} OR orderq.l_language = {$sqlRequestedLang})";
}
$orderPredicate = $persistence->quote($order);
$sqlOrderFilter = "INNER JOIN statements AS orderq" . PHP_EOL . "ON s.subject = orderq.subject" . PHP_EOL . "AND orderq.predicate = {$orderPredicate}{$sqlLang}" . PHP_EOL;
return $sqlOrderFilter;
}
/**
* @return common_persistence_SqlPersistence
*/
protected function getPersistence()
{
return $this->model->getPersistence();
}
