|
@@ 862-880 (lines=19) @@
|
| 859 |
|
$limit = $start = 0; |
| 860 |
|
$sql = 'SELECT * FROM ' . $this->db->prefix('smartfaq_faq'); |
| 861 |
|
|
| 862 |
|
if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
| 863 |
|
$whereClause = $criteria->renderWhere(); |
| 864 |
|
|
| 865 |
|
if ($whereClause !== 'WHERE ()') { |
| 866 |
|
$sql .= ' ' . $criteria->renderWhere(); |
| 867 |
|
if (!empty($notNullFields)) { |
| 868 |
|
$sql .= $this->NotNullFieldClause($notNullFields, true); |
| 869 |
|
} |
| 870 |
|
} elseif (!empty($notNullFields)) { |
| 871 |
|
$sql .= ' WHERE ' . $this->NotNullFieldClause($notNullFields); |
| 872 |
|
} |
| 873 |
|
if ($criteria->getSort() != '') { |
| 874 |
|
$sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
| 875 |
|
} |
| 876 |
|
$limit = $criteria->getLimit(); |
| 877 |
|
$start = $criteria->getStart(); |
| 878 |
|
} elseif (!empty($notNullFields)) { |
| 879 |
|
$sql .= $sql .= ' WHERE ' . $this->NotNullFieldClause($notNullFields); |
| 880 |
|
} |
| 881 |
|
|
| 882 |
|
//echo "<br>" . $sql . "<br>"; |
| 883 |
|
$result = $this->db->query($sql, $limit, $start); |
|
@@ 941-959 (lines=19) @@
|
| 938 |
|
faq.exacturl AS exacturl |
| 939 |
|
FROM ' . $this->db->prefix('smartfaq_faq') . ' AS faq INNER JOIN ' . $this->db->prefix('smartfaq_categories') . ' AS category ON faq.categoryid = category.categoryid '; |
| 940 |
|
|
| 941 |
|
if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
| 942 |
|
$whereClause = $criteria->renderWhere(); |
| 943 |
|
|
| 944 |
|
if ($whereClause !== 'WHERE ()') { |
| 945 |
|
$sql .= ' ' . $criteria->renderWhere(); |
| 946 |
|
if (!empty($notNullFields)) { |
| 947 |
|
$sql .= $this->NotNullFieldClause($notNullFields, true); |
| 948 |
|
} |
| 949 |
|
} elseif (!empty($notNullFields)) { |
| 950 |
|
$sql .= ' WHERE ' . $this->NotNullFieldClause($notNullFields); |
| 951 |
|
} |
| 952 |
|
if ($criteria->getSort() != '') { |
| 953 |
|
$sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
| 954 |
|
} |
| 955 |
|
$limit = $criteria->getLimit(); |
| 956 |
|
$start = $criteria->getStart(); |
| 957 |
|
} elseif (!empty($notNullFields)) { |
| 958 |
|
$sql .= $sql .= ' WHERE ' . $this->NotNullFieldClause($notNullFields); |
| 959 |
|
} |
| 960 |
|
|
| 961 |
|
//echo "<br>" . $sql . "<br>"; |
| 962 |
|
$result = $this->db->query($sql, $limit, $start); |
mambax7 /
smartfaq
