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;
// }
// }
}
