protected function _postDelete()
{
//find related docs and delete them
$tblRelatedItem = new App_Model_Db_Table_RelatedItem();
$rowsetRelatedDocs = $tblRelatedItem->fetchAll("relatedGuid='{$this->guid}' AND relateAs IN ('RELATED_FILE','RELATED_IMAGE','RELATED_VIDEO')");
if (count($rowsetRelatedDocs)) {
foreach ($rowsetRelatedDocs as $rowRelatedDoc) {
$tblCatalog = new App_Model_Db_Table_Catalog();
$rowCatalog = $tblCatalog->find($rowRelatedDoc->itemGuid)->current();
if ($rowCatalog) {
$rowCatalog->delete();
}
}
}
$registry = Zend_Registry::getInstance();
$config = $registry->get(Pandamp_Keys::REGISTRY_APP_OBJECT);
$cdn = $config->getOption('cdn');
if ($this->profileGuid == 'kutu_doc') {
//get parentGuid
$tblRelatedItem = new App_Model_Db_Table_RelatedItem();
$rowsetRelatedItem = $tblRelatedItem->fetchAll("itemGuid='{$this->guid}' AND relateAs IN ('RELATED_FILE','RELATED_IMAGE','RELATED_VIDEO')");
if (count($rowsetRelatedItem)) {
foreach ($rowsetRelatedItem as $rowRelatedItem) {
//must delete the physical files
$rowsetCatAtt = $this->findDependentRowsetCatalogAttribute();
$systemname = $rowsetCatAtt->findByAttributeGuid('docSystemName')->value;
$parentGuid = $rowRelatedItem->relatedGuid;
$sDir1 = $cdn['static']['dir']['files'] . DIRECTORY_SEPARATOR . $systemname;
$sDir2 = $cdn['static']['dir']['files'] . DIRECTORY_SEPARATOR . $parentGuid . DIRECTORY_SEPARATOR . $systemname;
//$sDir1 = ROOT_DIR.DIRECTORY_SEPARATOR.'uploads'.DIRECTORY_SEPARATOR.'files'.DIRECTORY_SEPARATOR.$systemname;
//$sDir2 = ROOT_DIR.DIRECTORY_SEPARATOR.'uploads'.DIRECTORY_SEPARATOR.'files'.DIRECTORY_SEPARATOR.$parentGuid.DIRECTORY_SEPARATOR.$systemname;
if (file_exists($sDir1)) {
//delete file
unlink($sDir1);
} else {
if (file_exists($sDir2)) {
//delete file
unlink($sDir2);
}
}
}
}
}
//delete from table CatalogAttribute
$tblCatalogAttribute = new App_Model_Db_Table_CatalogAttribute();
$tblCatalogAttribute->delete("catalogGuid='{$this->guid}'");
//delete catalogGuid from table CatalogFolder
$tblCatalogFolder = new App_Model_Db_Table_CatalogFolder();
$tblCatalogFolder->delete("catalogGuid='{$this->guid}'");
//delete guid from table AssetSetting
$tblAssetSetting = new App_Model_Db_Table_AssetSetting();
$tblAssetSetting->delete("guid='{$this->guid}'");
//delete from table relatedItem
$tblRelatedItem = new App_Model_Db_Table_RelatedItem();
$tblRelatedItem->delete("itemGuid='{$this->guid}'");
$tblRelatedItem->delete("relatedGuid='{$this->guid}'");
$indexingEngine = Pandamp_Search::manager();
try {
$hits = $indexingEngine->deleteCatalogFromIndex($this->guid);
} catch (Exception $e) {
}
//delete physical catalog folder from uploads/files/[catalogGuid]
$sDir = $cdn['static']['dir']['files'] . DIRECTORY_SEPARATOR . $this->guid;
//$sDir = ROOT_DIR.DIRECTORY_SEPARATOR.'uploads'.DIRECTORY_SEPARATOR.'files'.DIRECTORY_SEPARATOR.$this->guid;
try {
if (is_dir($sDir)) {
rmdir($sDir);
}
} catch (Exception $e) {
}
$sDir = $cdn['static']['dir']['images'];
//$sDir = ROOT_DIR.DIRECTORY_SEPARATOR.'uploads'.DIRECTORY_SEPARATOR.'images';
try {
if (file_exists($sDir . "/" . $this->guid . ".gif")) {
unlink($sDir . "/" . $this->guid . ".gif");
}
if (file_exists($sDir . "/tn_" . $this->guid . ".gif")) {
unlink($sDir . "/tn_" . $this->guid . ".gif");
}
if (file_exists($sDir . "/" . $this->guid . ".jpg")) {
unlink($sDir . "/" . $this->guid . ".jpg");
}
if (file_exists($sDir . "/tn_" . $this->guid . ".jpg")) {
unlink($sDir . "/tn_" . $this->guid . ".jpg");
}
if (file_exists($sDir . "/" . $this->guid . ".jpeg")) {
unlink($sDir . "/" . $this->guid . ".jpeg");
}
if (file_exists($sDir . "/tn_" . $this->guid . ".jpeg")) {
unlink($sDir . "/tn_" . $this->guid . ".jpeg");
}
if (file_exists($sDir . "/" . $this->guid . ".png")) {
unlink($sDir . "/" . $this->guid . ".png");
}
if (file_exists($sDir . "/tn_" . $this->guid . ".png")) {
unlink($sDir . "/tn_" . $this->guid . ".png");
}
} catch (Exception $e) {
}
}
function popularAction()
{
$tblAssetSetting = new App_Model_Db_Table_AssetSetting();
$rowset = $tblAssetSetting->fetchAll("valueText='klinik'", "valueInt DESC", 6);
$dateDiff = new Pandamp_Lib_DateDiff();
$content = 0;
$data = array();
foreach ($rowset as $row) {
$rowCatalog = App_Model_Show_Catalog::show()->getCatalogByGuid($row->guid);
$rowCatalogTitle = App_Model_Show_CatalogAttribute::show()->getCatalogAttributeValue($row['guid'], 'fixedCommentTitle');
$rowCatalogQuestion = App_Model_Show_CatalogAttribute::show()->getCatalogAttributeValue($row['guid'], 'fixedCommentQuestion');
$rowCatalogSelectCat = App_Model_Show_CatalogAttribute::show()->getCatalogAttributeValue($row['guid'], 'fixedKategoriKlinik');
$author = App_Model_Show_CatalogAttribute::show()->getCatalogAttributeValue($row['guid'], 'fixedSelectNama');
$source = App_Model_Show_CatalogAttribute::show()->getCatalogAttributeValue($row['guid'], 'fixedSelectMitra');
$data[$content][0] = $rowCatalogTitle;
$data[$content][1] = $rowCatalogQuestion;
$data[$content][2] = $rowCatalogSelectCat;
$data[$content][3] = $row->guid;
$data[$content][4] = $rowCatalog['createdBy'];
$data[$content][5] = isset($author) ? $author : '';
$data[$content][6] = isset($source) ? $source : '';
$data[$content][7] = $row->valueInt;
$data[$content][8] = $dateDiff->ago(strftime('%Y-%m-%d %H:%M:%S', strtotime($rowCatalog['publishedDate'])));
$content++;
}
$num_rows = count($rowset);
$this->view->numberOfRows = $num_rows;
$this->view->data = $data;
}
public function getCountCatalog($catalogGuid, $type)
{
$catalogs = App_Model_Show_Catalog::show()->getCatalogByGuid($catalogGuid);
if ($catalogs && !in_array($catalogs['profileGuid'], array('partner', 'author', 'kategoriklinik'))) {
switch ($type) {
case 'desktop':
if (in_array($catalogs['profileGuid'], array('article', 'talks', 'isuhangat', 'kutu_agenda', 'video', 'infografis'))) {
$valueText = 'TICKER';
} else {
if ($catalogs['profileGuid'] == 'klinik') {
$valueText = 'klinik';
} else {
if (in_array($catalogs['profileGuid'], array('kutu_peraturan', 'kutu_rancangan_peraturan', 'kutu_peraturan_kolonial', 'kutu_putusan'))) {
$valueText = 'pusatdata';
}
}
}
break;
case 'mobile':
if (in_array($catalogs['profileGuid'], array('article', 'talks', 'isuhangat', 'kutu_agenda', 'video', 'infografis'))) {
$valueText = 'TICKER-MOBILE';
} else {
if ($catalogs['profileGuid'] == 'klinik') {
$valueText = 'klinik-mobile';
} else {
if (in_array($catalogs['profileGuid'], array('kutu_peraturan', 'kutu_rancangan_peraturan', 'kutu_peraturan_kolonial', 'kutu_putusan'))) {
$valueText = 'pusatdata-mobile';
}
}
}
break;
}
$assetDb = new App_Model_Db_Table_AssetSetting();
$assets = $assetDb->fetchRow("guid='{$catalogGuid}' AND valueText='{$valueText}'");
if ($assets) {
return $assets->valueInt;
}
}
return;
}
public function reIndexCatalog()
{
gc_enable();
$this->emptyIndex();
$time_start = microtime(true);
$solr =& $this->_solr;
$formater = new Pandamp_Lib_Formater();
$title = new Pandamp_Controller_Action_Helper_GetCatalogTitle();
// $tbl = new Pandamp_Core_Orm_Table_Catalog();
// $rowset = $tbl->fetchAll(); //("profileGuid='Pandamp_peraturan'");
$query = "SELECT * FROM KutuCatalog";
$results = $this->_conn->query($query);
$rowset = $results->fetchAll(PDO::FETCH_OBJ);
$documents = array();
$rowCount = count($rowset);
for ($iCount = 0; $iCount < $rowCount; $iCount++) {
$row = $rowset[$iCount];
// if($iCount == 100)
// break;
// echo 'urutan: '.$iCount .'<br>';
$nextRow = $rowset[$iCount + 1];
// echo 'current guid: '.$row->guid.' '.'next guid: '.$nextRow->guid.'<br>';
if ($row->modifiedBy !== $row->createdBy) {
$modified = '<font color=red>[modifiedBy:<i>' . $row->modifiedBy . '</i>]</font> ';
} else {
$modified = '';
}
echo '<li><span style="font:11px verdana,arial,helvetica,sans-serif;">[urutan:' . $iCount . '] indexing:<font color=green>' . $title->getCatalogTitle($row->guid) . '</font>[current guid: ' . $row->guid . ' ' . 'next guid: ' . $nextRow->guid . '][author:<i>' . $row->createdBy . '</i>] ' . $modified . '[createdDate:<i>' . $formater->get_date($row->createdDate) . '</i>]</span></li>';
$documents[] = $this->_createSolrDocument($row);
if ($iCount % 500 == 0) {
try {
$solr->addDocuments($documents);
$solr->commit();
// $solr->optimize();
$documents = array();
} catch (Exception $e) {
// echo "Error occured when processing record starting from number: ". ($iCount - 1000) . ' to '.$iCount.' '.$row->guid;
$log->err($e->getMessage());
throw new Zend_Exception($e->getMessage());
// echo $e->getMessage().'<br>';
}
}
flush();
}
echo '</ul></div></td></tr></table>';
try {
$solr->addDocuments($documents);
$solr->commit();
// $solr->optimize();
} catch (Exception $e) {
$log->err($e->getMessage());
throw new Zend_Exception($e->getMessage());
// echo $e->getMessage().'<br>';
}
$time_end = microtime(true);
$time = $time_end - $time_start;
// echo'<br>WAKTU EKSEKUSI: '. $time;
// $log->info("WAKTU EKSEKUSI: ". $time." indexing catalog ".$iCount." dari ".$rowCount ." ".$username);
echo '<br><br><span style="font:11px verdana,arial,helvetica,sans-serif;color:#00FF00">WAKTU EKSEKUSI: ' . $time . '<br>indexing catalog ' . $iCount . ' dari ' . $rowCount . '</span>';
// log to assetSetting
$tblAssetSetting = new App_Model_Db_Table_AssetSetting();
$rowAsset = $tblAssetSetting->fetchRow("application='INDEX CATALOG'");
if ($rowAsset) {
$rowAsset->valueText = "Update {$rowCount} indexing-catalog at " . date("Y-m-d H:i:s") . $username;
$rowAsset->valueInt = $rowAsset->valueInt + 1;
} else {
$gman = new Pandamp_Core_Guid();
$catalogGuid = $gman->generateGuid();
$rowAsset = $tblAssetSetting->fetchNew();
$rowAsset->guid = $catalogGuid;
$rowAsset->application = "INDEX CATALOG";
$rowAsset->part = "KUTU";
$rowAsset->valueType = "INDEX";
$rowAsset->valueInt = 0;
$rowAsset->valueText = $rowCount . " Indexing catalog at " . date("Y-m-d H:i:s") . $username;
}
$rowAsset->save();
}
function downloadFileAction()
{
$this->_helper->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(TRUE);
$catalogGuid = $this->_getParam('guid');
$parentGuid = $this->_getParam('parent');
$tblCatalog = new App_Model_Db_Table_Catalog();
$rowsetCatalog = $tblCatalog->find($catalogGuid);
if (count($rowsetCatalog)) {
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$identity = $auth->getIdentity();
$guidUser = $identity->kopel;
}
$tblAsetSetting = new App_Model_Db_Table_AssetSetting();
$rowAset = $tblAsetSetting->find($catalogGuid)->current();
if ($rowAset) {
$rowAset->valueInt = $rowAset->valueInt + 1;
} else {
$rowAset = $tblAsetSetting->fetchNew();
$rowAset->guid = $catalogGuid;
$rowAset->application = "kutu_doc";
$rowAset->part = isset($guidUser) ? $guidUser : '';
$rowAset->valueType = gethostbyaddr($_SERVER['REMOTE_ADDR']);
$rowAset->valueInt = 1;
}
$rowAset->save();
$rowCatalog = $rowsetCatalog->current();
$rowsetCatAtt = $rowCatalog->findDependentRowsetCatalogAttribute();
$contentType = $rowsetCatAtt->findByAttributeGuid('docMimeType')->value;
$filename = $systemname = $rowsetCatAtt->findByAttributeGuid('docSystemName')->value;
$oriName = $oname = $rowsetCatAtt->findByAttributeGuid('docOriginalName')->value;
$tblRelatedItem = new App_Model_Db_Table_RelatedItem();
$rowsetRelatedItem = $tblRelatedItem->fetchAll("itemGuid='{$catalogGuid}' AND relateAs='RELATED_FILE'");
$registry = Zend_Registry::getInstance();
$config = $registry->get(Pandamp_Keys::REGISTRY_APP_OBJECT);
$cdn = $config->getOption('cdn');
$flagFileFound = false;
foreach ($rowsetRelatedItem as $rowRelatedItem) {
if (!$flagFileFound) {
$parentGuid = $rowRelatedItem->relatedGuid;
$sDir1 = $cdn['static']['dir']['files'] . "/" . $systemname;
$sDir2 = $cdn['static']['dir']['files'] . "/" . $parentGuid . "/" . $systemname;
$sDir3 = $cdn['static']['dir']['files'] . "/" . $oname;
$sDir4 = $cdn['static']['dir']['files'] . "/" . $parentGuid . "/" . $oname;
if (file_exists($sDir1)) {
$flagFileFound = true;
header("Content-type: {$contentType}");
header("Content-Disposition: attachment; filename={$oriName}");
@readfile($sDir1);
die;
} else {
if (file_exists($sDir2)) {
$flagFileFound = true;
header("Content-type: {$contentType}");
header("Content-Disposition: attachment; filename={$oriName}");
@readfile($sDir2);
die;
}
}
if (file_exists($sDir3)) {
$flagFileFound = true;
header("Content-type: {$contentType}");
header("Content-Disposition: attachment; filename={$oriName}");
@readfile($sDir3);
die;
}
if (file_exists($sDir4)) {
$flagFileFound = true;
header("Content-type: {$contentType}");
header("Content-Disposition: attachment; filename={$oriName}");
@readfile($sDir4);
die;
} else {
$flagFileFound = false;
$this->_redirect(ROOT_URL . '/' . $this->_zl->getLanguage() . '/dms/browser/forbidden');
}
}
}
} else {
$flagFileFound = false;
$this->_redirect(ROOT_URL . '/' . $this->_zl->getLanguage() . '/dms/browser/forbidden');
}
}
function downloadFileAction()
{
$this->_helper->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(TRUE);
$catalogGuid = $this->_getParam('guid');
$parentGuid = $this->_getParam('parent');
$tblCatalog = new App_Model_Db_Table_Catalog();
$rowsetCatalog = $tblCatalog->find($catalogGuid);
if (count($rowsetCatalog)) {
$auth = Zend_Auth::getInstance();
//$sso = new Pandamp_Session_Remote();
//$user = $sso->getInfo();
if ($auth->hasIdentity()) {
$guidUser = $auth->getIdentity()->guid;
}
$tblAsetSetting = new App_Model_Db_Table_AssetSetting();
$rowAset = $tblAsetSetting->find($catalogGuid)->current();
if ($rowAset) {
$rowAset->valueInt = $rowAset->valueInt + 1;
} else {
$rowAset = $tblAsetSetting->fetchNew();
$rowAset->guid = $catalogGuid;
$rowAset->application = "kutu_doc";
$rowAset->part = isset($guidUser) ? $guidUser : '';
$rowAset->valueType = gethostbyaddr($_SERVER['REMOTE_ADDR']);
$rowAset->valueInt = 1;
}
$rowAset->save();
$rowCatalog = $rowsetCatalog->current();
$rowsetCatAtt = $rowCatalog->findDependentRowsetCatalogAttribute();
$contentType = $rowsetCatAtt->findByAttributeGuid('docMimeType')->value;
$filename = $systemname = $rowsetCatAtt->findByAttributeGuid('docSystemName')->value;
$oriName = $oname = $rowsetCatAtt->findByAttributeGuid('docOriginalName')->value;
$tblRelatedItem = new App_Model_Db_Table_RelatedItem();
$rowsetRelatedItem = $tblRelatedItem->fetchAll("itemGuid='{$catalogGuid}' AND relateAs='RELATED_FILE'");
$flagFileFound = false;
foreach ($rowsetRelatedItem as $rowRelatedItem) {
if (!$flagFileFound) {
$parentGuid = $rowRelatedItem->relatedGuid;
$sDir1 = ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $systemname;
$sDir2 = ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $parentGuid . DIRECTORY_SEPARATOR . $systemname;
$sDir3 = ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $oname;
$sDir4 = ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $parentGuid . DIRECTORY_SEPARATOR . $oname;
if (file_exists($sDir1)) {
$flagFileFound = true;
header("Content-type: {$contentType}");
header("Content-Disposition: attachment; filename={$oriName}");
@readfile($sDir1);
die;
} else {
if (file_exists($sDir2)) {
$flagFileFound = true;
header("Content-type: {$contentType}");
header("Content-Disposition: attachment; filename={$oriName}");
@readfile($sDir2);
die;
}
}
if (file_exists($sDir3)) {
$flagFileFound = true;
header("Content-type: {$contentType}");
header("Content-Disposition: attachment; filename={$oriName}");
@readfile($sDir3);
die;
}
if (file_exists($sDir4)) {
$flagFileFound = true;
header("Content-type: {$contentType}");
header("Content-Disposition: attachment; filename={$oriName}");
@readfile($sDir4);
die;
} else {
$flagFileFound = false;
$this->_forward('forbidden', 'browser', 'hold');
}
}
}
} else {
$flagFileFound = false;
$this->_forward('forbidden', 'browser', 'hold');
}
}