public function listAction()
{
$r = $this->getRequest();
$guid = $r->getParam('f');
$g = $r->getParam('g');
$guid = !empty($g) ? $r->getParam('g') : $guid;
$tblFolder = new Kutu_Core_Orm_Table_Folder();
$row = $tblFolder->find($guid)->current();
$this->view->folderTitle = $row->title;
$this->view->currentNode = $guid;
$modDir = $this->getFrontController()->getModuleDirectory();
require_once $modDir . '/components/Pages/FolderBreadcrumbs.php';
$wBread = new Site_Pages_FolderBreadcrumbs($guid, 'root');
$this->view->breadcrumbs = $wBread;
if ($r->getParam('h')) {
$tblCatalog = new Kutu_Core_Orm_Table_Catalog();
$rowset = $tblCatalog->fetchFromFolder($guid, 0, 1);
$modDir = $this->getFrontController()->getModuleDirectory();
require_once $modDir . '/components/Pages/DetailsViewer.php';
$w = new Site_Pages_DetailsViewer($rowset->current()->guid, 'root');
$this->view->widget1 = $w;
$this->view->showHeadline = 1;
$this->view->listTitle = Kutu_Core_Util::getCatalogAttributeValue($rowset->current()->guid, 'fixedTitle');
} else {
//View catalogs
$limit = $r->getParam('limit') ? $r->getParam('limit') : 12;
$this->view->limit = $limit;
$itemsPerPage = $limit;
$this->view->itemsPerPage = $itemsPerPage;
$offset = $r->getParam('offset') ? $r->getParam('offset') : 0;
$this->view->offset = $offset;
$this->view->currentNode = $guid;
$sort = $r->getParam('sort') ? $r->getParam('sort') : "createdDate desc";
//"regulationType desc, year desc";
$this->view->sort = $sort;
$db = Zend_Db_Table::getDefaultAdapter()->query("SELECT catalogGuid as guid from KutuCatalogFolder where folderGuid='{$guid}'");
$rowset = $db->fetchAll(Zend_Db::FETCH_OBJ);
$solrAdapter = Kutu_Search::manager();
$numi = count($rowset);
$sSolr = "id:(";
for ($i = 0; $i < $numi; $i++) {
$row = $rowset[$i];
$sSolr .= $row->guid . ' ';
}
$sSolr .= ')';
if (!$numi) {
$sSolr = "id:(hfgjhfdfka)";
}
$solrResult = $solrAdapter->findAndSort($sSolr, $offset, $limit, array($sort));
//print_r($solrResult);die('gg');
$solrNumFound = count($solrResult->response->docs);
$this->view->totalItems = $solrResult->response->numFound;
$this->view->hits = $solrResult;
}
}
public function homeAction()
{
$this->view->pageTitle = 'Home';
$this->_helper->layout()->setLayout('layout-nosidebar');
$tblCatalog = new Kutu_Core_Orm_Table_Catalog();
$rowset = $tblCatalog->fetchFromFolder('nlrp4a35276c91693', 0, 1);
if (count($rowset)) {
$row = $rowset->current();
$this->view->row = $row;
/*$modDir = $this->getFrontController()->getModuleDirectory();
require_once($modDir.'/components/Pages/DetailsViewer.php');
$w = new Site_Pages_DetailsViewer($solrResult->response->docs[0]->id, 'root');
$this->view->widget1 = $w;
$this->view->showHeadline = 1;
$this->view->listTitle = Kutu_Core_Util::getCatalogAttributeValue($solrResult->response->docs[0]->id, 'fixedTitle');*/
}
$cms = new Kutu_Cms_Bpm_Folder();
$this->view->rows = $cms->fetchCatalogs('nlrp4a40810bd0d63', 0, 5);
}
public function findRowsetCatalog($startFrom = 0, $limit = 0)
{
$tblCatalog = new Kutu_Core_Orm_Table_Catalog();
return $tblCatalog->fetchFromFolder($this->guid, $startFrom, $limit);
}
public function getcatalogsinfolderAction()
{
$this->_helper->layout()->disableLayout();
$r = $this->getRequest();
$folderGuid = $r->getParam('folderGuid');
$start = $r->getParam('start') ? $r->getParam('start') : 0;
$limit = $r->getParam('limit') ? $r->getParam('limit') : 0;
$sort = $r->getParam('sort') ? $r->getParam('sort') : 'regulationType desc, year desc';
$a = array();
$a['folderGuid'] = $folderGuid;
// $db = Zend_Db_Table::getDefaultAdapter()->query
// ("SELECT catalogGuid as guid from KutuCatalogFolder where folderGuid='$folderGuid'");
//
// $rowset = $db->fetchAll(Zend_Db::FETCH_OBJ);
//
// $indexingEngine = Kutu_Search::manager();
//
// $numi = count($rowset);
// $sSolr = "id:(";
// for($i=0;$i<$numi;$i++)
// {
// $row = $rowset[$i];
// $sSolr .= $row->guid .' ';
// }
// $sSolr .= ')';
//
// if(!$numi)
// $sSolr="id:(hfgjhfdfka)";
$tblCatalog = new Kutu_Core_Orm_Table_Catalog();
$rowset = $tblCatalog->fetchFromFolder($folderGuid, $start, $limit);
$solrNumFound = count($rowset);
// $solrResult = $solrAdapter->findAndSort($sSolr,$start,$limit, array('sort'=>$sort));
// $indexingEngine->testFind($sSolr,$start,$limit);die();
// print_r($sSolr);die();
// $solrResult = new ArrayObject($indexingEngine->find($sSolr));
// $solrResult = $indexingEngine->find($sSolr,$start,$limit);
// $solrNumFound = count($solrResult);//$solrResult->response->numFound;
// $solrNumFound = count($solrResult->response->docs);
$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;
// $solrResult = new LimitIterator($solrResult->getIterator(),$start * $limit, $limit);
// for($ii=0;$ii<$numRowset;$ii++)
foreach ($rowset as $row) {
$rowsetCatalogAttribute = $row->findDependentRowsetCatalogAttribute();
$title = $rowsetCatalogAttribute->findByAttributeGuid('fixedTitle');
$subTitle = $rowsetCatalogAttribute->findByAttributeGuid('fixedSubTitle');
// if($ii>=$start && $ii<$start+$limit){
// $row = $solrResult->response->docs[$ii];
// if(!empty($row))
// {
$a['catalogs'][$ii]['guid'] = $row->guid;
if ($row->profileGuid == 'kutu_doc') {
$stitle = 'File : ' . $title->value;
} else {
$stitle = $title->value;
}
$a['catalogs'][$ii]['title'] = $stitle;
if (!isset($subTitle->value)) {
$a['catalogs'][$ii]['subTitle'] = '';
} else {
$a['catalogs'][$ii]['subTitle'] = $subTitle->value;
}
$a['catalogs'][$ii]['createdDate'] = $row->createdDate;
$a['catalogs'][$ii]['modifiedDate'] = $row->modifiedDate;
$ii++;
// }
// }
}
}
echo Zend_Json::encode($a);
}
