本文整理汇总了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;
}