function doindexAction() { $this->_helper->viewRenderer->setNoRender(TRUE); $title = "<h4>HUKUMONLINE INDONESIA: <small>indexing</small></h4><hr/>"; echo $title . '<br>'; $modelCatalogFolder = new App_Model_Db_Table_CatalogFolder(); $rowset = $modelCatalogFolder->fetchAll("folderGuid='fb16'", NULL, 2, 0); $solrAdapter = Pandamp_Search::manager(); //$solrAdapter->emptyIndex(); $solrAdapter->reIndexCatalog(); //$solrAdapter->indexCatalog("hol10111"); /* $numi = count($rowset); for($i=0;$i<$numi;$i++) { $row = $rowset[$i]; $solrAdapter->indexCatalog($row['catalogGuid']); //$solrAdapter->deleteCatalogFromIndex($row['catalogGuid']); $message = " <div class='box box-info closeable'> CatalogGuid : <abbr>".$row['catalogGuid']."</abbr> data has been successfully indexed. </div>"; echo $message.'<br>'; } * */ }
public function copyFolderContent($currentFolderGuid, $newCatalogGuid) { $tblCatalogFolder = new App_Model_Db_Table_CatalogFolder(); $rowset = $tblCatalogFolder->fetchAll("folderGuid = '{$currentFolderGuid}'"); if (count($rowset) > 0) { foreach ($rowset as $row) { $newContent = $tblCatalogFolder->createRow(); $newContent->folderGuid = $newCatalogGuid; $newContent->catalogGuid = $row->catalogGuid; $newContent->save(); } } }
public function removeFromFolder($catalogGuid, $folderGuid) { $tblCatalogFolder = new App_Model_Db_Table_CatalogFolder(); $rowset = $tblCatalogFolder->fetchAll("catalogGuid='{$catalogGuid}'"); if (count($rowset) > 1) { try { $tblCatalogFolder->delete("catalogGuid='{$catalogGuid}' AND folderGuid='{$folderGuid}'"); } catch (Exception $e) { throw new Zend_Exception($e->getMessage()); } } else { throw new Zend_Exception("Can not remove from the only FOLDER."); } }
protected function _traverseFolder_($folderGuid, $sGuid, $level) { $tblFolder = new App_Model_Db_Table_Folder(); $rowSet = $tblFolder->fetchChildren($folderGuid); $row = $tblFolder->find($folderGuid)->current(); $sGuid = ''; /* if(count($rowSet)) { $sGuid = $row->guid; } else { $sGuid = $row->guid; } */ // 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) . ""; //echo $row->guid.'<br>'; echo 'Insert ' . $row->title . '<br>'; $tblFolder = new App_Model_Db_Table_Migration_Detik_Folder(); $rowFolder = $tblFolder->fetchNew(); $rowFolder->guid = $row->guid; $rowFolder->title = $row->title; $rowFolder->description = $row->description; $rowFolder->parentGuid = $row->parentGuid; $rowFolder->path = $row->path; $rowFolder->type = $row->type; $rowFolder->viewOrder = $row->viewOrder; $rowFolder->cmsParams = $row->cmsParams; //$rowFolder->save(); $rowCatalog = App_Model_Show_Catalog::show()->fetchCatalogInFolder4Mig($row->guid); //print_r($row->guid);die(); if ($rowCatalog) { foreach ($rowCatalog as $rc) { $rowsetCatalogAttributeJenis = App_Model_Show_CatalogAttribute::show()->getCatalogAttributeValue($rc['guid'], 'prtJenis'); //print_r($rowsetCatalogAttributeJenis); if ($rowsetCatalogAttributeJenis == 'Undang-Undang ' || $rowsetCatalogAttributeJenis == "uu" || $rowsetCatalogAttributeJenis == "pp" || $rowsetCatalogAttributeJenis == "Peraturan Pemerintah" || $rowsetCatalogAttributeJenis == "konstitusi") { $modelMigrationCatalog = new App_Model_Db_Table_Migration_Detik_Catalog(); $where = $modelMigrationCatalog->getAdapter()->quoteInto('guid=?', $rc['guid']); if (!$modelMigrationCatalog->fetchRow($where)) { $data1 = array('guid' => $rc['guid'], 'shortTitle' => $rc['shortTitle'], 'profileGuid' => $rc['profileGuid'], 'publishedDate' => $rc['publishedDate'], 'expiredDate' => $rc['expiredDate'], 'createdBy' => $rc['createdBy'], 'modifiedBy' => $rc['modifiedBy'], 'createdDate' => $rc['createdDate'], 'modifiedDate' => $rc['modifiedDate'], 'deletedDate' => $rc['deletedDate'], 'price' => isset($rc['price']) ? $rc['price'] : 0, 'status' => $rc['status']); $modelMigrationCatalog->insert($data1); $tblCatalogAttribute = new App_Model_Db_Table_CatalogAttribute(); $rcam = $tblCatalogAttribute->fetchAll("catalogGuid='" . $rc['guid'] . "'"); foreach ($rcam as $rowca) { $modelMigrationCatalogAttribute = new App_Model_Db_Table_Migration_Detik_CatalogAttribute(); $data2 = array('catalogGuid' => $rowca->catalogGuid, 'attributeGuid' => $rowca->attributeGuid, 'value' => $rowca->value); $modelMigrationCatalogAttribute->insert($data2); } $tblCatalogFolder = new App_Model_Db_Table_CatalogFolder(); $rcfm = $tblCatalogFolder->fetchAll("catalogGuid='" . $rc['guid'] . "'"); foreach ($rcfm as $rowcf) { $modelMigrationCatalogFolder = new App_Model_Db_Table_Migration_Detik_CatalogFolder(); $data3 = array('catalogGuid' => $rowcf->catalogGuid, 'folderGuid' => $rowcf->folderGuid); $modelMigrationCatalogFolder->insert($data3); } $tblRelatedItem = new App_Model_Db_Table_RelatedItem(); $rrim = $tblRelatedItem->fetchAll("relatedGuid='" . $rc['guid'] . "'"); foreach ($rrim as $rowri) { $modelMigrationRelatedItem = new App_Model_Db_Table_Migration_Detik_RelatedItem(); $rowRelated = $modelMigrationRelatedItem->createNew(); $rowRelated->itemGuid = $rowri->itemGuid; $rowRelated->relatedGuid = $rowri->relatedGuid; $rowRelated->relateAs = $rowri->relateAs; $rowRelated->valueIntRelation = $rowri->valueIntRelation; $rowRelated->save(); } } } } } //$sGuid .= $sTab.$row->title . '|<br>'. $this->_traverseFolder($row->guid, '', $level+1); } // if(count($rowSet)) // { // return $sGuid; // } // else // { // return $sGuid; // } // } }