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