protected function _traverseFolder($folderGuid, $sGuid, $level) { Zend_Loader::loadClass('Kutu_Core_Orm_Table_Folder'); $tblFolder = new Kutu_Core_Orm_Table_Folder(); $rowSet = $tblFolder->fetchChildren($folderGuid); $row = $tblFolder->find($folderGuid)->current(); $sGuid = ''; if (count($rowSet)) { $sGuid = '<li>' . "<a href='" . KUTU_ROOT_URL . "/pages/g/{$row->guid}/h/1'>" . $row->title . '</a><ul>'; } else { $sGuid = '<li>' . "<a href='" . KUTU_ROOT_URL . "/pages/g/{$row->guid}/h/1'>" . $row->title . '</a>'; } if (true) { //echo $level; foreach ($rowSet as $row) { //$sTab = '<ul>'; //$sTab = ''; //for($i=0;$i<$level;$i++) //$sTab .= '<li>'; //$option = '<option value="'.$row->guid.'">'.$sTab.$row->title.'</option>'; //$option = '"'.$row->guid.'" :'.'"'.$sTab.$row->title.'",'; //$option = $sTab.$row->title; $sGuid .= $this->_traverseFolder($row->guid, '', $level + 1) . ""; //$sGuid .= $sTab.$row->title . '|<br>'. $this->_traverseFolder($row->guid, '', $level+1); } if (count($rowSet)) { return $sGuid . '</ul></li>'; } else { return $sGuid . '</li>'; } } }
function viewFolderKu() { $time_start = microtime(true); $parentGuid = $this->_node; $columns = 4; //Zend_Loader::loadClass('Kutu_Core_Orm_Table_Folder'); $tblFolder = new Kutu_Core_Orm_Table_Folder(); $rowsetFolder = $tblFolder->fetchChildren($parentGuid); // $db = Zend_Db_Table::getDefaultAdapter(); // if($parentGuid=='root') // $query = "select * from KutuFolder where parentGuid=guid"; // else // $query = "select * from KutuFolder where parentGuid='$parentGuid' AND NOT parentGuid=guid"; // $rs = $db->query($query); // $rowsetFolder = $rs->fetchAll(PDO::FETCH_OBJ); $num_rows = count($rowsetFolder); $rows = ceil($num_rows / $columns); if ($num_rows < $columns) { $columns = $num_rows; } if ($num_rows == 0) { //echo 'No folder(s) found'; } $kucrut = 0; $data = array(); foreach ($rowsetFolder as $rowFolder) { //$rowFolder = $rowsetFolder[$kucrut]; $data[$kucrut][0] = $rowFolder->title; $data[$kucrut][1] = $rowFolder->description; $data[$kucrut][2] = $rowFolder->guid; $data[$kucrut][3] = ''; $kucrut++; } $this->view->rows = $rows; $this->view->columns = $columns; $this->view->data = $data; $this->view->numberOfFolders = $num_rows; $this->view->node = $parentGuid; if ($parentGuid != 'root') { $rowCurrentNode = $tblFolder->find($parentGuid)->current(); $this->view->currentNodeTitle = $rowCurrentNode->title; } else { $this->view->currentNodeTitle = 'ROOT'; } $time_end = microtime(true); $time = $time_end - $time_start; //echo'<br>WAKTU EKSEKUSI: '. $time; }
public function getchildreninjsonAction() { // Make sure nothing is cached header("Cache-Control: must-revalidate"); header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); header("Expires: " . gmdate("D, d M Y H:i:s", mktime(date("H") - 2, date("i"), date("s"), date("m"), date("d"), date("Y"))) . " GMT"); header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // So that the loading indicator is visible sleep(1); // The id of the node being opened $id = $_REQUEST["id"]; //echo $id; if ($id == "0") { $tblFolder = new Kutu_Core_Orm_Table_Folder(); $rowset = $tblFolder->fetchChildren('root'); echo '[' . "\n"; for ($i = 0; $i < count($rowset); $i++) { $row = $rowset->current(); if ($i == count($rowset) - 1) { echo "\t" . '{ attributes: { id : "' . $row->guid . '" }, state: "closed", data: "' . $row->title . '" }' . "\n"; } else { echo "\t" . '{ attributes: { id : "' . $row->guid . '" }, state: "closed", data: "' . $row->title . '" },' . "\n"; } $rowset->next(); } echo ']' . "\n"; } else { $tblFolder = new Kutu_Core_Orm_Table_Folder(); $rowset = $tblFolder->fetchChildren($id); echo '[' . "\n"; for ($i = 0; $i < count($rowset); $i++) { $row = $rowset->current(); if ($i == count($rowset) - 1) { echo "\t" . '{ attributes: { id : "' . $row->guid . '" }, state: "closed", data: "' . $row->title . '" }' . "\n"; } else { echo "\t" . '{ attributes: { id : "' . $row->guid . '" }, state: "closed", data: "' . $row->title . '" },' . "\n"; } $rowset->next(); } echo ']' . "\n"; } exit; }