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