本文整理匯總了PHP中ilTree::buildJoin方法的典型用法代碼示例。如果您正苦於以下問題：PHP ilTree::buildJoin方法的具體用法？PHP ilTree::buildJoin怎麽用？PHP ilTree::buildJoin使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類ilTree的用法示例。
在下文中一共展示了ilTree::buildJoin方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: getObjectTypeStatistics
function getObjectTypeStatistics()
{
global $ilDB, $objDefinition;
// re-use add new item selection (folder is not that important)
$types = array_keys($objDefinition->getCreatableSubObjects("root", ilObjectDefinition::MODE_REPOSITORY));
include_once "Services/Tree/classes/class.ilTree.php";
$tree = new ilTree(1);
$sql = "SELECT " . $tree->table_obj_data . ".obj_id," . $tree->table_obj_data . ".type," . $tree->table_tree . "." . $tree->tree_pk . "," . $tree->table_obj_reference . ".ref_id" . " FROM " . $tree->table_tree . " " . $tree->buildJoin() . " WHERE " . $ilDB->in($tree->table_obj_data . ".type", $types, "", "text");
$set = $ilDB->query($sql);
$res = array();
while ($row = $ilDB->fetchAssoc($set)) {
$res[$row["type"]]["type"] = $row["type"];
$res[$row["type"]]["references"]++;
$res[$row["type"]]["objects"][] = $row["obj_id"];
if ($row[$tree->tree_pk] < 0) {
$res[$row["type"]]["deleted"]++;
}
}
foreach ($res as $type => $values) {
$res[$type]["objects"] = sizeof(array_unique($values["objects"]));
}
return $res;
}