/**
* getMailContent
*/
function getMailContent($title)
{
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$where = $tblCatalog->getAdapter()->quoteInto("shortTitle=?", $title);
$rowset = $tblCatalog->fetchRow($where);
$rowsetCatalogAttribute = $rowset->findDependentRowsetCatalogAttribute();
$content = $rowsetCatalogAttribute->findByAttributeGuid('fixedContent')->value;
return $content;
}
public function uploadFile_old($aDataCatalog, $relatedGuid)
{
if ($aDataCatalog['profileGuid'] != 'kutu_doc') {
throw new Zend_Exception('Profile does not match profile for FILE');
}
if (empty($relatedGuid)) {
throw new Zend_Exception('No RELATED GUID specified!');
}
$id = 1 + ($aDataCatalog['id'] - 1);
for ($x = 1; $x < $id; $x++) {
$title = $aDataCatalog['fixedTitle' . $x] ? $aDataCatalog['fixedTitle' . $x] : 'No-Title';
$registry = Zend_Registry::getInstance();
$files = $registry->get('files');
if (isset($files['uploadedFile' . $x])) {
$file = $files['uploadedFile' . $x];
$this->checkTitle($aDataCatalog['fixedTitle' . $x]);
}
$type = $aDataCatalog['fixedType' . $x] ? $aDataCatalog['fixedType' . $x] : '';
if ($type == 'file') {
$relatedType = 'RELATED_FILE';
} elseif ($type == 'image') {
$relatedType = 'RELATED_IMAGE';
} elseif ($type == 'video') {
$relatedType = 'RELATED_VIDEO';
}
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$gman = new Pandamp_Core_Guid();
$catalogGuid = isset($aDataCatalog['guid']) && !empty($aDataCatalog['guid']) ? $aDataCatalog['guid'] : $gman->generateGuid();
$folderGuid = isset($aDataCatalog['folderGuid']) && !empty($aDataCatalog['folderGuid']) ? $aDataCatalog['folderGuid'] : '';
$where = $tblCatalog->getAdapter()->quoteInto('guid=?', $catalogGuid);
if ($tblCatalog->fetchRow($where)) {
$rowCatalog = $tblCatalog->find($catalogGuid)->current();
$rowCatalog->shortTitle = isset($aDataCatalog['shortTitle']) ? $aDataCatalog['shortTitle'] : $rowCatalog->shortTitle;
$rowCatalog->publishedDate = isset($aDataCatalog['publishedDate']) ? $aDataCatalog['publishedDate'] : $rowCatalog->publishedDate;
$rowCatalog->expiredDate = isset($aDataCatalog['expiredDate']) ? $aDataCatalog['expiredDate'] : $rowCatalog->expiredDate;
$rowCatalog->status = isset($aDataCatalog['status']) ? $aDataCatalog['status'] : $rowCatalog->status;
} else {
$rowCatalog = $tblCatalog->fetchNew();
$rowCatalog->guid = $catalogGuid;
$rowCatalog->shortTitle = isset($aDataCatalog['shortTitle']) ? $aDataCatalog['shortTitle'] : '';
$rowCatalog->profileGuid = $aDataCatalog['profileGuid'];
$rowCatalog->publishedDate = isset($aDataCatalog['publishedDate']) ? $aDataCatalog['publishedDate'] : '0000-00-00 00:00:00';
$rowCatalog->expiredDate = isset($aDataCatalog['expiredDate']) ? $aDataCatalog['expiredDate'] : '0000-00-00 00:00:00';
$rowCatalog->createdBy = isset($aDataCatalog['username']) ? $aDataCatalog['username'] : '';
$rowCatalog->modifiedBy = $rowCatalog->createdBy;
$rowCatalog->createdDate = date("Y-m-d h:i:s");
$rowCatalog->modifiedDate = $rowCatalog->createdDate;
$rowCatalog->deletedDate = '0000-00-00 00:00:00';
$rowCatalog->status = isset($aDataCatalog['status']) ? $aDataCatalog['status'] : 0;
}
$catalogGuid = $rowCatalog->save();
$rowsetCatalogAttribute = $rowCatalog->findDependentRowsetCatalogAttribute();
if (isset($files['uploadedFile' . $x])) {
if (isset($files['uploadedFile' . $x]['name']) && !empty($files['uploadedFile' . $x]['name'])) {
$this->_updateCatalogAttribute($rowsetCatalogAttribute, $catalogGuid, 'docSystemName', strtoupper(str_replace(' ', '_', $file['name'])));
$this->_updateCatalogAttribute($rowsetCatalogAttribute, $catalogGuid, 'docOriginalName', strtoupper(str_replace(' ', '_', $file['name'])));
$this->_updateCatalogAttribute($rowsetCatalogAttribute, $catalogGuid, 'docSize', $file['size']);
$this->_updateCatalogAttribute($rowsetCatalogAttribute, $catalogGuid, 'docMimeType', $file['type']);
$this->_updateCatalogAttribute($rowsetCatalogAttribute, $catalogGuid, 'fixedTitle', $title);
$this->_updateCatalogAttribute($rowsetCatalogAttribute, $catalogGuid, 'docViewOrder', 0);
if ($type == 'file') {
$sDir = ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $relatedGuid;
if (is_dir($sDir)) {
move_uploaded_file($file['tmp_name'], $sDir . DIRECTORY_SEPARATOR . strtoupper(str_replace(' ', '_', $file['name'])));
} else {
if (mkdir($sDir)) {
move_uploaded_file($file['tmp_name'], $sDir . DIRECTORY_SEPARATOR . strtoupper(str_replace(' ', '_', $file['name'])));
} else {
move_uploaded_file($file['tmp_name'], ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . strtoupper(str_replace(' ', '_', $file['name'])));
}
}
} elseif ($type == 'image') {
$sDir = ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'images';
$file = $files['uploadedFile' . $x]['name'];
$ext = explode(".", $file);
$ext = strtolower(array_pop($ext));
if ($ext == "jpg" || $ext == "jpeg" || $ext == "gif" || $ext == "png") {
$target_path = $sDir . DIRECTORY_SEPARATOR . $catalogGuid . "." . $ext;
if (is_dir($target_path)) {
move_uploaded_file($files['uploadedFile' . $x]['tmp_name'], $sDir . DIRECTORY_SEPARATOR . $catalogGuid . "." . $ext);
chmod($target_path, 0644);
Pandamp_Lib_Formater::createthumb($target_path, $sDir . '/tn_' . $catalogGuid . "." . $ext, 130, 130);
} else {
move_uploaded_file($files['uploadedFile' . $x]['tmp_name'], ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'images' . DIRECTORY_SEPARATOR . $catalogGuid . "." . $ext);
chmod($target_path, 0644);
Pandamp_Lib_Formater::createthumb($target_path, $sDir . '/tn_' . $catalogGuid . "." . $ext, 130, 130);
}
}
} elseif ($type == 'video') {
$sDir = ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'video' . DIRECTORY_SEPARATOR . $relatedGuid;
if (is_dir($sDir)) {
move_uploaded_file($file['tmp_name'], $sDir . DIRECTORY_SEPARATOR . strtoupper(str_replace(' ', '_', $file['name'])));
} else {
if (mkdir($sDir)) {
move_uploaded_file($file['tmp_name'], $sDir . DIRECTORY_SEPARATOR . strtoupper(str_replace(' ', '_', $file['name'])));
} else {
move_uploaded_file($file['tmp_name'], ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . strtoupper(str_replace(' ', '_', $file['name'])));
}
}
}
}
}
$this->relateTo($catalogGuid, $relatedGuid, $relatedType);
$indexingEngine = Pandamp_Search::manager();
$indexingEngine->indexCatalog($relatedGuid);
}
}
function saveAction()
{
$response = array();
$request = $this->getRequest();
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$userName = $auth->getIdentity()->username;
}
$gman = new Pandamp_Core_Guid();
$catalogGuid = $request->getParam('guid') ? $request->getParam('guid') : $gman->generateGuid();
$folderGuid = $request->getParam('folderGuid') ? $request->getParam('folderGuid') : '';
//if not empty, there are 2 possibilities
$where = $tblCatalog->getAdapter()->quoteInto('guid=?', $catalogGuid);
if ($tblCatalog->fetchRow($where)) {
$rowCatalog = $tblCatalog->find($catalogGuid)->current();
$rowCatalog->shortTitle = $request->getParam('shortTitle');
$rowCatalog->publishedDate = $request->getParam('publishedDate');
$rowCatalog->expiredDate = $request->getParam('expiredDate');
$rowCatalog->modifiedBy = $userName;
$rowCatalog->modifiedDate = date("Y-m-d h:i:s");
$rowCatalog->status = $request->getParam('status');
} else {
$rowCatalog = $tblCatalog->fetchNew();
$rowCatalog->shortTitle = $request->getParam('shortTitle');
$rowCatalog->profileGuid = $request->getParam('profileGuid');
$rowCatalog->publishedDate = $request->getParam('publishedDate');
$rowCatalog->expiredDate = $request->getParam('expiredDate');
$rowCatalog->createdBy = $userName;
$rowCatalog->modifiedBy = $userName;
$rowCatalog->createdDate = date("Y-m-d h:i:s");
$rowCatalog->modifiedDate = date("Y-m-d h:i:s");
$rowCatalog->deletedDate = '0000-00-00 00:00:00';
$rowCatalog->status = $request->getParam('status');
}
$catalogGuid = $rowCatalog->save();
$tableProfileAttribute = new Pandamp_Modules_Dms_Profile_Model_ProfileAttribute();
$profileGuid = $rowCatalog->profileGuid;
$where = $tableProfileAttribute->getAdapter()->quoteInto('profileGuid=?', $profileGuid);
$rowsetProfileAttribute = $tableProfileAttribute->fetchAll($where, 'viewOrder ASC');
$rowsetCatalogAttribute = $rowCatalog->findDependentRowsetCatalogAttribute();
foreach ($rowsetProfileAttribute as $rowProfileAttribute) {
if ($rowsetCatalogAttribute->findByAttributeGuid($rowProfileAttribute->attributeGuid)) {
$rowCatalogAttribute = $rowsetCatalogAttribute->findByAttributeGuid($rowProfileAttribute->attributeGuid);
} else {
$tblCatalogAttribute = new Pandamp_Modules_Dms_Catalog_Model_CatalogAttribute();
$rowCatalogAttribute = $tblCatalogAttribute->fetchNew();
$rowCatalogAttribute->catalogGuid = $catalogGuid;
$rowCatalogAttribute->attributeGuid = $rowProfileAttribute->attributeGuid;
}
$rowCatalogAttribute->value = $request->getParam($rowProfileAttribute->attributeGuid);
$rowCatalogAttribute->save();
}
//save to table CatalogFolder only if folderGuid is not empty
if (!empty($folderGuid)) {
$tblCatalogFolder = new Pandamp_Modules_Dms_Catalog_Model_CatalogFolder();
$rowsetCatalogFolder = $tblCatalogFolder->find($catalogGuid, $folderGuid);
if (count($rowsetCatalogFolder) <= 0) {
$rowCatalogFolder = $tblCatalogFolder->createRow(array('catalogGuid' => '', 'folderGuid' => ''));
$rowCatalogFolder->catalogGuid = $catalogGuid;
$rowCatalogFolder->folderGuid = $folderGuid;
$rowCatalogFolder->save();
}
}
$response['success'] = true;
echo Zend_Json::encode($response);
}
function produkAction()
{
$this->_helper->layout->setLayout('layout-misc');
$this->_helper->layout->setLayoutPath(array('layoutPath' => ROOT_DIR . '/app/modules/misc/layouts'));
$this->view->identity = "Produk";
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowset = $tblCatalog->fetchRow("guid='lt4a1cc3ee7eac5'", 'createdDate DESC');
$rowsetCatalogAttribute = $rowset->findDependentRowsetCatalogAttribute();
$rowCatalogAttribute = $rowsetCatalogAttribute->findByAttributeGuid('fixedContent');
$rowCatalogAttributeTitle = $rowsetCatalogAttribute->findByAttributeGuid('fixedTitle');
$rowCatalogAttributeSubTitle = $rowsetCatalogAttribute->findByAttributeGuid('fixedSubTitle');
$this->view->content = $rowCatalogAttribute->value;
$this->view->title = $rowCatalogAttributeTitle->value;
$this->view->subTitle = $rowCatalogAttributeSubTitle->value;
}
function paketAction()
{
$shortTitle = $this->_getParam('title') ? $this->_getParam('title') : '';
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowset = $tblCatalog->fetchRow("shortTitle='" . $shortTitle . "'");
$rowsetCatalogAttribute = $rowset->findDependentRowsetCatalogAttribute();
$this->view->title = $rowsetCatalogAttribute->findByAttributeGuid('fixedTitle')->value;
$this->view->content = $rowsetCatalogAttribute->findByAttributeGuid('fixedContent')->value;
}
