|
@@ 846-864 (lines=19) @@
|
| 843 |
|
$limit = $start = 0; |
| 844 |
|
$sql = 'SELECT * FROM ' . $this->db->prefix('smartfaq_faq'); |
| 845 |
|
|
| 846 |
|
if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
| 847 |
|
$whereClause = $criteria->renderWhere(); |
| 848 |
|
|
| 849 |
|
if ($whereClause !== 'WHERE ()') { |
| 850 |
|
$sql .= ' ' . $criteria->renderWhere(); |
| 851 |
|
if (!empty($notNullFields)) { |
| 852 |
|
$sql .= $this->NotNullFieldClause($notNullFields, true); |
| 853 |
|
} |
| 854 |
|
} elseif (!empty($notNullFields)) { |
| 855 |
|
$sql .= ' WHERE ' . $this->NotNullFieldClause($notNullFields); |
| 856 |
|
} |
| 857 |
|
if ($criteria->getSort() != '') { |
| 858 |
|
$sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
| 859 |
|
} |
| 860 |
|
$limit = $criteria->getLimit(); |
| 861 |
|
$start = $criteria->getStart(); |
| 862 |
|
} elseif (!empty($notNullFields)) { |
| 863 |
|
$sql .= $sql .= ' WHERE ' . $this->NotNullFieldClause($notNullFields); |
| 864 |
|
} |
| 865 |
|
|
| 866 |
|
//echo "<br />" . $sql . "<br />"; |
| 867 |
|
$result = $this->db->query($sql, $limit, $start); |
|
@@ 925-943 (lines=19) @@
|
| 922 |
|
faq.exacturl AS exacturl |
| 923 |
|
FROM ' . $this->db->prefix('smartfaq_faq') . ' AS faq INNER JOIN ' . $this->db->prefix('smartfaq_categories') . ' AS category ON faq.categoryid = category.categoryid '; |
| 924 |
|
|
| 925 |
|
if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
| 926 |
|
$whereClause = $criteria->renderWhere(); |
| 927 |
|
|
| 928 |
|
if ($whereClause !== 'WHERE ()') { |
| 929 |
|
$sql .= ' ' . $criteria->renderWhere(); |
| 930 |
|
if (!empty($notNullFields)) { |
| 931 |
|
$sql .= $this->NotNullFieldClause($notNullFields, true); |
| 932 |
|
} |
| 933 |
|
} elseif (!empty($notNullFields)) { |
| 934 |
|
$sql .= ' WHERE ' . $this->NotNullFieldClause($notNullFields); |
| 935 |
|
} |
| 936 |
|
if ($criteria->getSort() != '') { |
| 937 |
|
$sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
| 938 |
|
} |
| 939 |
|
$limit = $criteria->getLimit(); |
| 940 |
|
$start = $criteria->getStart(); |
| 941 |
|
} elseif (!empty($notNullFields)) { |
| 942 |
|
$sql .= $sql .= ' WHERE ' . $this->NotNullFieldClause($notNullFields); |
| 943 |
|
} |
| 944 |
|
|
| 945 |
|
//echo "<br />" . $sql . "<br />"; |
| 946 |
|
$result = $this->db->query($sql, $limit, $start); |
mambax7 /
smartfaq
