static function fetchNodesByPathString($nodePath, $withLastNode = false, $asObjects = true, $limit = false)
{
$nodesListArray = array();
$pathString = eZContentObjectTreeNode::createNodesConditionSQLStringFromPath($nodePath, $withLastNode, $limit);
if ($pathString) {
$useVersionName = true;
$versionNameTables = eZContentObjectTreeNode::createVersionNameTablesSQLString($useVersionName);
$versionNameTargets = eZContentObjectTreeNode::createVersionNameTargetsSQLString($useVersionName);
$versionNameJoins = eZContentObjectTreeNode::createVersionNameJoinsSQLString($useVersionName);
$query = "SELECT ezcontentobject.*,\n ezcontentobject_tree.*,\n ezcontentclass.serialized_name_list as class_serialized_name_list,\n ezcontentclass.identifier as class_identifier,\n ezcontentclass.is_container as is_container\n {$versionNameTargets}\n FROM ezcontentobject_tree,\n ezcontentobject,\n ezcontentclass\n {$versionNameTables}\n WHERE {$pathString}\n ezcontentobject_tree.contentobject_id=ezcontentobject.id AND\n ezcontentclass.version=0 AND\n ezcontentclass.id = ezcontentobject.contentclass_id\n {$versionNameJoins}\n ORDER BY path_string";
$db = eZDB::instance();
$nodesListArray = $db->arrayQuery($query);
}
if ($asObjects) {
return eZContentObjectTreeNode::makeObjectsArray($nodesListArray);
}
return $nodesListArray;
}
static function fetchNodesByPathString($nodePath, $withLastNode = false, $asObjects = true, $limit = false)
{
$nodesListArray = array();
$pathString = eZContentObjectTreeNode::createNodesConditionSQLStringFromPath($nodePath, $withLastNode, $limit);
if ($pathString) {
$nodesListArray = eZDB::instance()->arrayQuery("SELECT " . "ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, " . "ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, " . "ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, " . "ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, " . "ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, " . "ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, " . "ezcontentclass.is_container as is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation " . "FROM ezcontentobject_tree " . "INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) " . "INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) " . "INNER JOIN ezcontentobject_name ON ( " . " ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND " . " ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version " . ") " . "WHERE {$pathString} ezcontentclass.version = 0 AND " . eZContentLanguage::sqlFilter('ezcontentobject_name', 'ezcontentobject') . " " . "ORDER BY path_string");
}
if ($asObjects) {
return eZContentObjectTreeNode::makeObjectsArray($nodesListArray);
}
return $nodesListArray;
}
static function fetchNodesByPathString($nodePath, $withLastNode = false, $asObjects = true, $limit = false)
{
$nodesListArray = array();
$pathString = eZContentObjectTreeNode::createNodesConditionSQLStringFromPath($nodePath, $withLastNode, $limit);
if ($pathString) {
$query = "SELECT ezcontentobject.*,\n ezcontentobject_tree.*,\n ezcontentclass.serialized_name_list as class_serialized_name_list,\n ezcontentclass.identifier as class_identifier,\n ezcontentclass.is_container as is_container,\n ezcontentobject_name.name as name,\n ezcontentobject_name.real_translation\n FROM ezcontentobject_tree\n INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id)\n INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id)\n INNER JOIN ezcontentobject_name ON (\n ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND\n ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version\n )\n WHERE {$pathString}\n ezcontentclass.version = 0 AND\n " . eZContentLanguage::sqlFilter('ezcontentobject_name', 'ezcontentobject') . "\n ORDER BY path_string";
$db = eZDB::instance();
$nodesListArray = $db->arrayQuery($query);
}
if ($asObjects) {
return eZContentObjectTreeNode::makeObjectsArray($nodesListArray);
}
return $nodesListArray;
}
