public function getNode($catalogGuid)
{
$modelCatalogFolder = new App_Model_Db_Table_CatalogFolder();
$rowset = $modelCatalogFolder->fetchRow("catalogGuid='" . $catalogGuid . "'");
if ($rowset) {
return $rowset->folderGuid;
} else {
return;
}
}
public function getcatalogsearchAction()
{
$this->_helper->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(TRUE);
$r = $this->getRequest();
$query = $r->getParam('query') ? $r->getParam('query') : '';
$category = $r->getParam('ct') ? $r->getParam('ct') : '';
$start = $r->getParam('start') ? $r->getParam('start') : 0;
$limit = $r->getParam('limit') ? $r->getParam('limit') : 25;
$orderBy = $r->getParam('orderBy') ? $r->getParam('sortBy') : 'publishedDate';
$sortOrder = $r->getParam('sortOrder') ? $r->getParam('sortOrder') : ' desc';
$a = array();
$a['query'] = $query;
$registry = Zend_Registry::getInstance();
$config = $registry->get(Pandamp_Keys::REGISTRY_APP_OBJECT);
$remoteSearchIn = $config->getOption('in');
$remoteSearchEn = $config->getOption('en');
$zl = Zend_Registry::get('Zend_Locale');
if ($zl->getLanguage() == "id") {
$status = "status:99";
} else {
$status = "status:1";
}
$indexingEngine = Pandamp_Search::manager();
if (empty($query)) {
$hits = $indexingEngine->find("fjkslfjdkfjls", 0, 1);
} else {
if ($category) {
//$querySolr = $query.' -profile:kutu_doc profile:'.$category.';'.$orderBy.$sortOrder;
$querySolr = $query . ' -profile:kutu_doc profile:' . $category;
} else {
//$querySolr = $query.' -profile:kutu_doc '.$status.';'.$orderBy.$sortOrder;
$querySolr = $query . ' -profile:kutu_doc';
}
$hits = $indexingEngine->find($querySolr, $start, $limit);
}
$num = $hits->response->numFound;
//$solrNumFound = count($hits->response->docs);
$solrNumFound = $num;
$ii = 0;
if ($solrNumFound == 0) {
$a['catalogs'][0]['guid'] = 'XXX';
$a['catalogs'][0]['title'] = "No Data";
$a['catalogs'][0]['subTitle'] = "";
$a['catalogs'][0]['createdDate'] = '';
$a['catalogs'][0]['modifiedDate'] = '';
} else {
if ($solrNumFound > $limit) {
$numRowset = $limit;
} else {
$numRowset = $solrNumFound;
}
for ($ii = 0; $ii < $numRowset; $ii++) {
if (isset($hits->response->docs[$ii])) {
$row = $hits->response->docs[$ii];
if (!empty($row)) {
if ($row->profile == "klinik") {
if (isset($hits->highlighting->{$row->id}->title[0])) {
if (isset($hits->highlighting->{$row->id}->kategori[0])) {
$title = "[<b><font color='#FFAD29'>" . $hits->highlighting->{$row->id}->kategori[0] . "</font></b>] <a href='" . $remoteSearchIn['website'] . "/klinik/detail/" . $row->id . "' class='searchlink'>" . $hits->highlighting->{$row->id}->title[0] . "</a>";
} else {
$title = "[<b><font color='#FFAD29'>" . $row->kategori . "</font></b>] <a href='" . $remoteSearchIn['website'] . "/klinik/detail/" . $row->id . "' class='searchlink'>" . $hits->highlighting->{$row->id}->title[0] . "</a>";
}
} else {
if (isset($hits->highlighting->{$row->id}->kategori[0])) {
$title = "[<b><font color='#FFAD29'>" . $hits->highlighting->{$row->id}->kategori[0] . "</font></b>] <a href='" . $remoteSearchIn['website'] . "/klinik/detail/" . $row->id . "' class='searchlink'><b>{$row->title}</b></a>";
} else {
$title = "[<b><font color='#FFAD29'>" . $row->kategori . "</font></b>] <a href='" . $remoteSearchIn['website'] . "/klinik/detail/" . $row->id . "' class='searchlink'><b>{$row->title}</b></a>";
}
}
if (isset($hits->highlighting->{$row->id}->commentQuestion[0])) {
$description = $row->commentQuestion ? "<u>Pertanyaan</u>: " . $hits->highlighting->{$row->id}->commentQuestion[0] : '';
} else {
$description = $row->commentQuestion ? "<u>Pertanyaan</u>: " . $row->commentQuestion : '';
}
} else {
if ($row->profile == "article") {
if ($zl->getLanguage() == "id") {
if (isset($hits->highlighting->{$row->id}->title[0])) {
$title = "<a href='" . $remoteSearchIn['website'] . "/berita/baca/" . $row->id . "/" . $row->shortTitle . "' class='searchlink'><b>" . $hits->highlighting->{$row->id}->title[0] . "</b></a>";
} else {
$title = "<a href='" . $remoteSearchIn['website'] . "/berita/baca/" . $row->id . "/" . $row->shortTitle . "' class='searchlink'><b>{$row->title}</b></a>";
}
} else {
if (isset($row->shortTitle)) {
$st = "/" . $row->shortTitle;
} else {
$st = "";
}
if (isset($hits->highlighting->{$row->id}->title[0])) {
$title = "<a href='" . $remoteSearchEn['website'] . "/pages/" . $row->id . $st . "' class='searchlink'><b>" . $hits->highlighting->{$row->id}->title[0] . "</b></a>";
} else {
$title = "<a href='" . $remoteSearchEn['website'] . "/pages/" . $row->id . $st . "' class='searchlink'><b>{$row->title}</b></a>";
}
}
$description = isset($row->description) ? $row->description : '';
} else {
if ($row->profile == "kutu_peraturan" || $row->profile == "kutu_peraturan_kolonial" || $row->profile == "kutu_rancangan_peraturan" || $row->profile == "kutu_putusan") {
$tblCatalogFolder = new App_Model_Db_Table_CatalogFolder();
$rowsetCatalogFolder = $tblCatalogFolder->fetchRow("catalogGuid='{$row->id}'");
if ($rowsetCatalogFolder) {
$parentGuid = $rowsetCatalogFolder->folderGuid;
} else {
$parentGuid = '';
}
$node = $this->getNode($parentGuid);
if (isset($hits->highlighting->{$row->id}->title[0])) {
$title = "<a href='" . $remoteSearchIn['website'] . "/pusatdata/detail/" . $row->id . "/" . $node . "/" . $parentGuid . "' class='searchlink'><b>" . $hits->highlighting->{$row->id}->title[0] . "</b></a>";
} else {
$title = "<a href='" . $remoteSearchIn['website'] . "/pusatdata/detail/" . $row->id . "/" . $node . "/" . $parentGuid . "' class='searchlink'><b>{$row->title}</b></a>";
}
$description = isset($row->description) ? $row->description : '';
} else {
//$title = (isset($row->title))? $row->title : '';
if (isset($row->title)) {
if ($zl->getLanguage() == "id") {
$title = "<a href='" . ROOT_URL . "' class='searchlink'><b>{$row->title}</b></a>";
} else {
if (isset($row->shortTitle)) {
$st = "/" . $row->shortTitle;
} else {
$st = "";
}
$title = "<a href='" . $remoteSearchEn['website'] . "/pages/" . $row->id . $st . "' class='searchlink'><b>{$row->title}</b></a>";
}
} else {
$title = "";
}
$description = isset($row->description) ? $row->description : '';
}
}
}
if (isset($hits->highlighting->{$row->id}->subTitle[0])) {
$subTitle = isset($row->subTitle) ? "<span class='subjudul'>" . $hits->highlighting->{$row->id}->subTitle[0] . "</span><br>" : '';
} else {
$subTitle = isset($row->subTitle) ? "<span class='subjudul'>" . $row->subTitle . "</span><br>" : '';
}
$profileSolr = str_replace("kutu_", "", $row->profile);
$profileSolr = str_replace("clinic_category", "clinic", $profileSolr);
$profileSolr = str_replace("financial_services", "financial services", $profileSolr);
$profileSolr = str_replace("general_corporate", "general corporate", $profileSolr);
$profileSolr = str_replace("oil_and_gas", "oil and gas", $profileSolr);
$profileSolr = str_replace("executive_alert", "executive alert", $profileSolr);
$profileSolr = str_replace("manufacturing_&_industry", "manufacturing & industry", $profileSolr);
$profileSolr = str_replace("consumer_goods", "consumer goods", $profileSolr);
$profileSolr = str_replace("telecommunications_and_media", "telecommunications and media", $profileSolr);
$profileSolr = str_replace("executive_summary", "executive summary", $profileSolr);
$profileSolr = str_replace("hot_news", "hot news", $profileSolr);
$profileSolr = str_replace("hot_issue_ile", "hot issue ILE", $profileSolr);
$profileSolr = str_replace("hot_issue_ild", "hot issue ILD", $profileSolr);
$profileSolr = str_replace("hot_issue_ilb", "hot issue ILB", $profileSolr);
$a['catalogs'][$ii]['profile'] = $profileSolr;
$a['catalogs'][$ii]['title'] = $title ? $title : '';
$a['catalogs'][$ii]['guid'] = $row->id;
$a['catalogs'][$ii]['score'] = "score:" . round($row->score, 4);
$a['catalogs'][$ii]['description'] = $description;
$a['catalogs'][$ii]['subTitle'] = isset($subTitle) ? $subTitle : '';
$array_hari = array(1 => "Senin", "Selasa", "Rabu", "Kamis", "Jumat", "Sabtu", "Minggu");
$hari = $array_hari[date("N", strtotime($row->publishedDate))];
$a['catalogs'][$ii]['publishedDate'] = $hari . ', ' . date("d F Y", strtotime($row->publishedDate));
}
}
}
}
echo Zend_Json::encode($a);
}
function viewFolderNavigationAction()
{
$browserUrl = ROOT_URL . '/pusatdata/view/node';
$folderGuid = $this->_getParam('node') ? $this->_getParam('node') : 'root';
$tblFolder = new App_Model_Db_Table_Folder();
$aPath = array();
if ($folderGuid == 'root') {
$aPath[0]['title'] = 'Root';
$aPath[0]['url'] = $browserUrl;
} else {
$rowFolder = $tblFolder->find($folderGuid)->current();
if (!isset($rowFolder)) {
$tblCatalogFolder = new App_Model_Db_Table_CatalogFolder();
$rowsetCatalogFolder = $tblCatalogFolder->fetchRow("catalogGuid='{$folderGuid}'");
if ($rowsetCatalogFolder) {
$rowFolder = $tblFolder->find($rowsetCatalogFolder->folderGuid)->current();
}
}
if (!empty($rowFolder->path)) {
$aFolderGuid = explode("/", $rowFolder->path);
$sPath = 'root >';
$aPath[0]['title'] = 'Root';
$aPath[0]['url'] = $browserUrl;
$i = 1;
if (count($aFolderGuid)) {
$sPath1 = '';
foreach ($aFolderGuid as $guid) {
if (!empty($guid)) {
$rowFolder1 = $tblFolder->find($guid)->current();
$sPath1 .= $rowFolder1->title . ' > ';
$aPath[$i]['title'] = $rowFolder1->title;
$aPath[$i]['url'] = $browserUrl . '/' . $rowFolder1->guid;
$i++;
}
}
$aPath[$i]['title'] = $rowFolder->title;
$aPath[$i]['url'] = $browserUrl . '/' . $rowFolder->guid;
}
} else {
$aPath[0]['title'] = 'Root';
$aPath[0]['url'] = $browserUrl;
$aPath[1]['title'] = $rowFolder->title;
$aPath[1]['url'] = $browserUrl . '/' . $rowFolder->guid;
}
}
$this->view->aPath = $aPath;
}
function _browseAction()
{
$r = $this->getRequest();
$sOffset = $r->getParam('sOffset') ? $r->getParam('sOffset') : 0;
$this->view->sOffset = $sOffset;
$sLimit = $r->getParam('sLimit') ? $r->getParam('sLimit') : 0;
$this->view->sLimit = $sLimit;
$category = $r->getParam('category') ? $r->getParam('category') : '';
if ($category == "all") {
$category = "";
}
$query = $r->getParam('q') ? $r->getParam('q') : '';
$indexingEngine = Pandamp_Search::manager();
if (empty($query)) {
//$hits = $indexingEngine->find("*:*;publishedDate desc",$sOffset, $sLimit);
$hits = $indexingEngine->find("*:*", $sOffset, $sLimit);
} else {
if ($category) {
$querySolr = $query . ' profile:' . $category;
} else {
//$hits = $indexingEngine->find($query." -profile:kutu_doc;publishedDate desc",$sOffset, $sLimit);
$querySolr = $query . " -profile:kutu_doc";
}
$hits = $indexingEngine->find($querySolr, $sOffset, $sLimit);
}
$solrNumFound = count($hits->response->docs);
$content = 0;
$data = array();
for ($ii = 0; $ii < $solrNumFound; $ii++) {
$row = $hits->response->docs[$ii];
$data[$content][0] = $row->id;
$data[$content][1] = isset($row->title) ? $row->title : '';
$tblCatalogFolder = new App_Model_Db_Table_CatalogFolder();
$rowsetCatalogFolder = $tblCatalogFolder->fetchRow("catalogGuid='{$row->id}'");
if ($rowsetCatalogFolder) {
$parentGuid = $rowsetCatalogFolder->folderGuid;
} else {
$parentGuid = '';
}
$data[$content][2] = $parentGuid;
$profileSolr = str_replace("kutu_", "", $row->profile);
$data[$content][3] = $profileSolr;
$data[$content][4] = $row->createdDate;
$data[$content][5] = $row->createdBy;
$data[$content][6] = $row->modifiedDate;
$data[$content][7] = $row->modifiedBy;
$data[$content][8] = $row->publishedDate;
$data[$content][9] = $row->status;
$content++;
}
switch ($category) {
case "kutu_peraturan":
case "kutu_rancangan_peraturan":
case "kutu_peraturan_kolonial":
$ct = "(kutu_peraturan_kolonial OR kutu_rancangan_peraturan OR kutu_peraturan)";
break;
case "":
$ct = "all";
break;
default:
$ct = $category;
break;
}
$this->_helper->layout()->categorySearchQuery = $ct;
$num_rows = $solrNumFound;
$this->view->query = $query;
$this->view->totalItems = $hits->response->numFound;
$this->view->numberOfRows = $num_rows;
$this->view->data = $data;
}
public function getcatalogsearchAction()
{
$this->_helper->layout()->disableLayout();
$r = $this->getRequest();
$query = $r->getParam('query') ? $r->getParam('query') : '';
$category = $r->getParam('ct') ? $r->getParam('ct') : '';
$start = $r->getParam('start') ? $r->getParam('start') : 0;
$limit = $r->getParam('limit') ? $r->getParam('limit') : 25;
$orderBy = $r->getParam('orderBy') ? $r->getParam('sortBy') : 'publishedDate';
$sortOrder = $r->getParam('sortOrder') ? $r->getParam('sortOrder') : ' desc';
$a = array();
$a['query'] = $query;
$indexingEngine = Pandamp_Search::manager();
if (empty($query)) {
$hits = $indexingEngine->find("fjkslfjdkfjls", 0, 1);
} else {
if ($category) {
$querySolr = $query . ' -profile:kutu_doc status:99 profile:' . $category . ';' . $orderBy . $sortOrder;
} else {
$querySolr = $query . ' -profile:kutu_doc status:99;' . $orderBy . $sortOrder;
}
$hits = $indexingEngine->find($querySolr, $start, $limit);
}
$num = $hits->response->numFound;
//$solrNumFound = count($hits->response->docs);
$solrNumFound = $num;
$ii = 0;
if ($solrNumFound == 0) {
$a['catalogs'][0]['guid'] = 'XXX';
$a['catalogs'][0]['title'] = "No Data";
$a['catalogs'][0]['subTitle'] = "";
$a['catalogs'][0]['createdDate'] = '';
$a['catalogs'][0]['modifiedDate'] = '';
} else {
if ($solrNumFound > $limit) {
$numRowset = $limit;
} else {
$numRowset = $solrNumFound;
}
for ($ii = 0; $ii < $numRowset; $ii++) {
if (isset($hits->response->docs[$ii])) {
$row = $hits->response->docs[$ii];
if (!empty($row)) {
if ($row->profile == "klinik") {
if (isset($hits->highlighting->{$row->id}->title[0])) {
if (isset($hits->highlighting->{$row->id}->kategori[0])) {
$title = "[<b><font color='#FFAD29'>" . $hits->highlighting->{$row->id}->kategori[0] . "</font></b>] <a href='" . ROOT_URL . "/klinik/detail/" . $row->id . "' class='searchlink'>" . $hits->highlighting->{$row->id}->title[0] . "</a>";
} else {
$title = "[<b><font color='#FFAD29'>" . $row->kategori . "</font></b>] <a href='" . ROOT_URL . "/klinik/detail/" . $row->id . "' class='searchlink'>" . $hits->highlighting->{$row->id}->title[0] . "</a>";
}
} else {
if (isset($hits->highlighting->{$row->id}->kategori[0])) {
$title = "[<b><font color='#FFAD29'>" . $hits->highlighting->{$row->id}->kategori[0] . "</font></b>] <a href='" . ROOT_URL . "/klinik/detail/" . $row->id . "' class='searchlink'><b>{$row->title}</b></a>";
} else {
$title = "[<b><font color='#FFAD29'>" . $row->kategori . "</font></b>] <a href='" . ROOT_URL . "/klinik/detail/" . $row->id . "' class='searchlink'><b>{$row->title}</b></a>";
}
}
if (isset($hits->highlighting->{$row->id}->commentQuestion[0])) {
$description = $row->commentQuestion ? "<u>Pertanyaan</u>: " . $hits->highlighting->{$row->id}->commentQuestion[0] : '';
} else {
$description = $row->commentQuestion ? "<u>Pertanyaan</u>: " . $row->commentQuestion : '';
}
} else {
if ($row->profile == "article") {
if (isset($hits->highlighting->{$row->id}->title[0])) {
$title = "<a href='" . ROOT_URL . "/berita/baca/" . $row->id . "/" . $row->shortTitle . "' class='searchlink'><b>" . $hits->highlighting->{$row->id}->title[0] . "</b></a>";
} else {
$title = "<a href='" . ROOT_URL . "/berita/baca/" . $row->id . "/" . $row->shortTitle . "' class='searchlink'><b>{$row->title}</b></a>";
}
$description = isset($row->description) ? $row->description : '';
} else {
if ($row->profile == "kutu_peraturan" || $row->profile == "kutu_peraturan_kolonial" || $row->profile == "kutu_rancangan_peraturan" || $row->profile == "kutu_putusan") {
$tblCatalogFolder = new App_Model_Db_Table_CatalogFolder();
$rowsetCatalogFolder = $tblCatalogFolder->fetchRow("catalogGuid='{$row->id}'");
if ($rowsetCatalogFolder) {
$parentGuid = $rowsetCatalogFolder->folderGuid;
} else {
$parentGuid = '';
}
$node = $this->getNode($parentGuid);
if (isset($hits->highlighting->{$row->id}->title[0])) {
$title = "<a href='" . ROOT_URL . "/pusatdata/detail/" . $row->id . "/" . $node . "/" . $parentGuid . "' class='searchlink'><b>" . $hits->highlighting->{$row->id}->title[0] . "</b></a>";
} else {
$title = "<a href='" . ROOT_URL . "/pusatdata/detail/" . $row->id . "/" . $node . "/" . $parentGuid . "' class='searchlink'><b>{$row->title}</b></a>";
}
$description = isset($row->description) ? $row->description : '';
} else {
$title = isset($row->title) ? $row->title : '';
$description = isset($row->description) ? $row->description : '';
}
}
}
if (isset($hits->highlighting->{$row->id}->subTitle[0])) {
$subTitle = isset($row->subTitle) ? "<span class='subjudul'>" . $hits->highlighting->{$row->id}->subTitle[0] . "</span><br>" : '';
} else {
$subTitle = isset($row->subTitle) ? "<span class='subjudul'>" . $row->subTitle . "</span><br>" : '';
}
$profileSolr = str_replace("kutu_", "", $row->profile);
$a['catalogs'][$ii]['profile'] = $profileSolr;
$a['catalogs'][$ii]['title'] = $title ? $title : '';
$a['catalogs'][$ii]['guid'] = $row->id;
$a['catalogs'][$ii]['score'] = "score:" . $row->score;
$a['catalogs'][$ii]['description'] = $description;
$a['catalogs'][$ii]['subTitle'] = isset($subTitle) ? $subTitle : '';
$array_hari = array(1 => "Senin", "Selasa", "Rabu", "Kamis", "Jumat", "Sabtu", "Minggu");
$hari = $array_hari[date("N", strtotime($row->publishedDate))];
$a['catalogs'][$ii]['publishedDate'] = $hari . ', ' . date("d F Y", strtotime($row->publishedDate));
}
}
}
}
echo Zend_Json::encode($a);
}
