本文整理匯總了PHP中eZContentClassName::sqlEmptyFilter方法的典型用法代碼示例。如果您正苦於以下問題:PHP eZContentClassName::sqlEmptyFilter方法的具體用法?PHP eZContentClassName::sqlEmptyFilter怎麽用?PHP eZContentClassName::sqlEmptyFilter使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類eZContentClassName
的用法示例。
在下文中一共展示了eZContentClassName::sqlEmptyFilter方法的1個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: fetchClassList
static function fetchClassList($contentclass_version, $group_id, $asObject = true, $orderByArray = array('name'))
{
$versionCond = '';
$orderByClause = '';
$group_id = (int) $group_id;
$classNameSqlFilter = eZContentClassName::sqlEmptyFilter();
if ($contentclass_version !== null) {
$contentclass_version = (int) $contentclass_version;
$versionCond = "AND class_group.contentclass_version='{$contentclass_version}'\n AND contentclass.version='{$contentclass_version}'\n";
}
if ($orderByArray) {
foreach (array_keys($orderByArray) as $key) {
if (strcasecmp($orderByArray[$key], 'name') === 0) {
$classNameSqlFilter = eZContentClassName::sqlAppendFilter('contentclass');
$orderByArray[$key] = $classNameSqlFilter['orderBy'];
}
}
$orderByClause = 'ORDER BY ' . implode(', ', $orderByArray);
}
$db = eZDB::instance();
$sql = "SELECT contentclass.* {$classNameSqlFilter['nameField']}\n FROM ezcontentclass contentclass, ezcontentclass_classgroup class_group {$classNameSqlFilter['from']}\n WHERE contentclass.id=class_group.contentclass_id\n {$versionCond}\n AND class_group.group_id='{$group_id}' {$classNameSqlFilter['where']}\n {$orderByClause}";
$rows = $db->arrayQuery($sql);
return eZPersistentObject::handleRows($rows, "eZContentClass", $asObject);
}