';
if(0){// RMME
echo'
';
echo'';
echo'
';
}
?>
log('start-lazy-load');
$items = array();
$db = DB::getDB();
$sql = "select p.ID, p.P_ID
, p.`A_STATUS`
, p.`M_DIST_TYPE`
, p.`M_DIST_DESC`
, p.`M_DISTRIBUTOR`
, p.`M_DIST_INVENTOR`
from `{$tblName}` as p
where
p.P_ID!='-1'
-- and p.P_ID!=''
and p.P_ID>=0
";
$res = $db->query($sql);
$dbgExecTime->log('lazy-execute-sql', array('lazy-load'));
while ($r = $db->fetch($res)) {
$r->sub = array();
$r->P_ID = trim($r->P_ID);
$r->P_ID = str_replace(' ', ',', $r->P_ID);
$v_parents = array();
$v_parents_test = explode(',', $r->P_ID);
foreach ($v_parents_test as $v_id) {
$v_id = intval(trim($v_id));
if ($v_id > 0) {
$v_parents[] = $v_id;
}
}
if (empty($v_parents)) {
$r->P_ID = 0;
} else {
$r->P_ID = $v_parents;
}
$items[$r->ID] = $r;
}
$dbgExecTime->log('lazy-load-sql', array('lazy-load'));
// set root for tree $pro_tree
$pro_tree = array();
foreach ($items as $k_id => $r) {
if ($r->P_ID == 0) {
$pro_tree[$r->ID] = array();
$v_id = $r->P_ID;
if (array_key_exists($v_id, $items)) {
$items[$v_id]->sub[$r->ID] = true;
}
} else {// array
foreach ($r->P_ID as $v_id) {
if (array_key_exists($v_id, $items)) {
$items[$v_id]->sub[$r->ID] = true;
}
}
}
}
ksort($pro_tree);
// set up has_childrens
foreach ($items as $k_id => $r) {
$items[$k_id]->has_childrens = !empty($r->sub);
}
// build tree by P_ID - array or 0
function TREEJS_create_project_tree_rec($p_id, &$items) {
static $rec_ind;
$rec_ind++;
$ret = array();
if (!array_key_exists($p_id, $items)) {
return false;
} else {
$r = $items[$p_id];
if (empty($r->sub)) {
return false;
}
foreach ($r->sub as $k_id => $v) {
$ret[$k_id] = TREEJS_create_project_tree_rec($k_id, $items);
}
return $ret;
}
}
//$pro_tree = TREEJS_create_project_tree_rec($pro_tree, $items);
foreach ($pro_tree as $k_id => $v_childrens) {
if (array_key_exists($k_id, $items)) {
$pro_tree[$k_id] = TREEJS_create_project_tree_rec($k_id, $items);
}
}
$dbgExecTime->log('end-lazy-load', array('lazy-load'));
}
$tree = new Tree($tblName);
$tree->set_param('htmlTreeId', $htmlTreeId);
$tree->setProfiler($dbgExecTime);
if (($p_id_col = V::get('set_parent_id_col', '', $conf)) != '') {
$tree->set_parent_id_col($p_id_col);
}
if (!empty($conf['params'])) {
foreach ($conf['params'] as $k_param => $v_param) {
$tree->set_param($k_param, $v_param);
}
}
$tree->set_param('filtr_status', $tree_filter->get_arg('filtr_status'));
$dbgExecTime->log('start-show-tree');
if ($TEST_TREE_LAZY_LOAD) {
$tree->show_css();
$tree->show_js();
echo "\n".'
'."\n";
$tree->show_rec_by_tree($pro_tree, $items);
echo '
'."\n";
}
else {
if ($tree_filter->get_arg('filtr_id') != 0) {
$tree->showSubTree($tree_filter->get_arg('filtr_id'));
} else if ($tree_filter->get_arg('filtr_search_id') > 0) {
$tree->showSearchNode($tree_filter->get_arg('filtr_search_id'));
} else {
$tree->show();
}
}
$dbgExecTime->log('end-show-tree', array('show-tree'));
echo '