protected function getEntitiesQuery($filters, $return, $offset)
{
$authorid = null;
$newsItems = null;
$status = null;
$extended = false;
if (array_key_exists('author', $filters)) {
// use author
$authorid = Database::queryNumber($filters['author']);
} elseif (array_key_exists('authorid', $filters)) {
// use author
$authorid = Database::queryNumber($filters['authorid']);
}
if (array_key_exists('news', $filters)) {
$newsItems = strtolower($filters['news']) == "true" || strtolower($filters['news']) == "yes";
}
if (array_key_exists('extended', $filters)) {
$extended = strtolower($filters['extended']) == "true" || strtolower($filters['extended']) == "yes";
}
if (array_key_exists('status', $filters)) {
$status = $filters['status'];
}
return 'call getFeaturesEx(' . Database::queryNumber($authorid) . ',' . Database::queryBoolean($newsItems) . ',' . Database::queryString($status) . ',' . Database::queryBoolean($extended) . ',' . $this->userid . ',' . $return . ',' . $offset . ',' . $this->tenantid . ');';
return $query;
}
protected function getFieldUpdateString($fieldname, $value)
{
$fieldType = $this->getFieldType($fieldname);
$output = '';
switch ($fieldType) {
case "string":
$output = Database::queryString($value);
break;
case "json":
$output = Database::queryJSON($value);
break;
case "boolean":
$output = Database::queryBoolean($value);
break;
case "number":
case "hidden":
$output = Database::queryNumber($value);
break;
case "date":
$output = Database::queryDate($value);
break;
case "picklist":
$output = Database::queryString($value);
break;
}
return $output;
}
