_tbl = $tbl;
$this->_id = $id;
$this->_tblParentField = $parentField;
}
public function fetchTreeFlat() {
if (!empty($this->_treeFlat)) {
return;
}
$this->_treeFlat = array();
$db = DB::getDB();
$sql = "select t.`ID`, t.`{$this->_tblParentField}` as PARENT_ID
from `{$this->_tbl}` as t
where t.`A_STATUS` in('WAITING','NORMAL')
order by t.`{$this->_tblParentField}`, t.`SORT_PRIO`, t.`ID`
";
if(V::get('DBG_TF', '', $_GET) > 2){echo'sql (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo'';}
$res = $db->query($sql);
while ($r = $db->fetch($res)) {
$this->_treeFlat[$r->PARENT_ID][] = $r->ID;
}
if(V::get('DBG_TF', '', $_GET) > 0){echo'treeFlatAll (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($this->_treeFlat);echo'';}
}
public function generateListFlat() {
if (!empty($this->_listFlat)) {
return $this->_listFlat;
}
/**
1 2768 Założenie konta SIP z numerem na platformie AMS [proces urucham
2 2770 Zaloguj się na platformę AMS Jeżeli posiadasz konto na platformie
2.1 2771 Dodanie nowego klienta Proces mówiący o tym jak dodać nowego k
2.1.1 2772 Wprowadź dane klienta Wprowadź wszystkie dane klienta: imię, nazwi
2.2 2774 Dodanie numeru telefonu dla istniejącego klienta Proces dodawania nume
2.2.1 2773 Wprowadź dane dotyczące nowego numeru telefonu Wypełnij dane z tabeli:
2.2.2 2828 Edytowanie konta klienta Dodawanie dostępu do panelu klienckiego (miejsca
*
* 1 [2768] deep:1
* 2 [2770] deep:1
* 3 [2771] deep:2
*
*/
$this->_listFlat = array();// array('ID'=>$id_proces, 'LIST_NRS' => array(1));
$lastUserIds = array();
$lastUserIds[] = (object)array('ID'=>$this->_id, 'LIST_NRS' => array(1), 'deep'=>1);
for ($i = 0; $i < 1000; $i++) {
if (empty($lastUserIds)) {
break;
}
$vItem = array_shift($lastUserIds);
$this->_listFlat[$vItem->ID] = $vItem;
// next steps
if (array_key_exists($vItem->ID, $this->_treeFlat)) {
if (count($this->_treeFlat[$vItem->ID]) > 1) {
$subNr = 1;
foreach ($this->_treeFlat[$vItem->ID] as $vSubProcesId) {
$vSubItem = (object)array('ID'=>$vSubProcesId, 'deep'=>$vItem->deep + 1);
$vSubItem->LIST_NRS = $vItem->LIST_NRS;
$vSubItem->LIST_NRS[] = $subNr++;
$vSubItem->LIST_NRS[] = '';
$vSubItem->p_ID = $vItem->ID;
$lastUserIds[] = $vSubItem;
}
}
else {
foreach ($this->_treeFlat[$vItem->ID] as $vSubProcesId) {
$vSubItem = (object)array('ID'=>$vSubProcesId, 'deep'=>$vItem->deep);
$vSubItem->LIST_NRS = $vItem->LIST_NRS;
$subNr = array_pop($vSubItem->LIST_NRS);
$vSubItem->LIST_NRS[] = ++$subNr;
$lastUserIds[] = $vSubItem;
}
}
}
}
if(V::get('DBG_TF', '', $_GET) > 0){echo'listFlat (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($this->_listFlat);echo'';}
foreach ($this->_listFlat as $kID => $vItem) {
$listNrOut = array();
foreach ($vItem->LIST_NRS as $nr) {
if ($nr) {
$listNrOut[] = $nr;
}
}
$this->_listFlat[$kID]->listNr = implode('.', $listNrOut);
}
$this->_listIds = array_keys($this->_listFlat);
uasort($this->_listFlat, array($this, 'sortListCallback'));
return $this->_listFlat;
}
public function getListIds() {
return $this->_listIds;
}
public function fetchData() {
$sqlIds = $this->_listIds;
if (empty($sqlIds)) {
return $this->_data;
}
$sqlGotoIds = array();
$db = DB::getDB();
$sql = "select t.*
from `{$this->_tbl}` as t
where t.`A_STATUS` in('WAITING','NORMAL')
and t.`ID` in(" . implode(",", $sqlIds) . ")
";
if(V::get('DBG_TF', '', $_GET) > 2){echo'sql (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo'';}
$res = $db->query($sql);
while ($r = $db->fetch($res)) {
if ($r->IF_TRUE_GOTO > 0) {
$sqlGotoIds[] = $r->IF_TRUE_GOTO;
}
$this->_data[$r->ID] = $r;
}
if (!empty($sqlGotoIds)) {
$sql = "select t.*
from `{$this->_tbl}` as t
where t.`A_STATUS` in('WAITING','NORMAL')
and t.`ID` in(" . implode(",", $sqlGotoIds) . ")
";
if(V::get('DBG_TF', '', $_GET) > 2){echo'sqlGoto (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($sql);echo'';}
$res = $db->query($sql);
while ($r = $db->fetch($res)) {
$this->_data[$r->ID] = $r;
}
}
if(V::get('DBG_TF', '', $_GET) > 0){echo'data (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($this->_data);echo'';}
return $this->_data;
}
public function getData($id) {
return (array_key_exists($id, $this->_data))? $this->_data[$id] : null;
}
public function sortListCallback($a, $b) {
$cntA = count($a->LIST_NRS);
$cntB = count($b->LIST_NRS);
$cnt = min($cntA, $cntB);
for ($i = 0; $i < $cnt; $i++) {
if ($a->LIST_NRS[$i] > $b->LIST_NRS[$i]) {
return 1;
} else if ($a->LIST_NRS[$i] < $b->LIST_NRS[$i]) {
return -1;
}
}
return ($cntA < $cntB)? -1 : 1;
}
}