function commentAction()
{
$modelCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowset = $modelCatalog->fetchAll("profileGuid='comment'");
foreach ($rowset as $row) {
$modelCatalogAttribute = new Pandamp_Modules_Dms_Catalog_Model_CatalogAttribute();
try {
$modelComment = new Pandamp_Modules_Extension_Comment_Model_Comment();
$comment = $modelComment->fetchNew();
$tblRelatedItem = new Pandamp_Modules_Dms_Catalog_Model_RelatedItem();
$rowsetRelatedItem = $tblRelatedItem->fetchRow("itemGuid='" . $row->guid . "' AND relateAs='RELATED_COMMENT'");
$comment->object_id = $rowsetRelatedItem->relatedGuid;
$comment->userid = 0;
$rowsetCatalogAttribute = $row->findDependentRowsetCatalogAttribute();
$comment->name = $rowsetCatalogAttribute->findByAttributeGuid('fixedName')->value;
$comment->email = $rowsetCatalogAttribute->findByAttributeGuid('fixedEmail')->value;
$comment->title = $rowsetCatalogAttribute->findByAttributeGuid('fixedJudul')->value;
$comment->comment = $rowsetCatalogAttribute->findByAttributeGuid('fixedComment')->value;
$comment->ip = 0;
$comment->date = $row->createdDate;
$comment->published = $row->status;
$comment->checked_out_time = $row->publishedDate;
$comment->save();
echo $comment->title . ' saved<br>';
} catch (Zend_Exception $e) {
echo $e->getMessage() . '<br>';
}
}
}
function catalogAction()
{
$modelCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$row = $modelCatalog->getCatalogByGuid('hol20748');
$rowsetCatalogAttribute = $row->findDependentRowsetCatalogAttribute();
$this->view->rca = $rowsetCatalogAttribute;
}
function panelCommentAction()
{
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowset = $tblCatalog->fetchAll("profileGuid='comment' and status=0");
$num_rows = count($rowset);
$this->view->numDocs = $num_rows;
}
function generateFormAnswer($catalogGuid)
{
$today = date('Y-m-d H:i:s');
$aRenderedAttributes = array();
$aBaseAttributes = array();
$tableCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowsetCatalog = $tableCatalog->find($catalogGuid);
$rowCatalog = $rowsetCatalog->current();
$tableProfileAttribute = new App_Model_Db_Table_ProfileAttribute();
$where = $tableProfileAttribute->getAdapter()->quoteInto('profileGuid=?', $rowCatalog->profileGuid);
$rowsetProfileAttribute = $tableProfileAttribute->fetchAll($where, array('viewOrder ASC'));
$rowsetCatalogAttribute = $rowCatalog->findDependentRowsetCatalogAttribute();
$i = 0;
foreach ($rowsetProfileAttribute as $row) {
$rowCatalogAttribute = $rowsetCatalogAttribute->findByAttributeGuid($row->attributeGuid);
$rowAttribute = $row->findParentRow('App_Model_Db_Table_Attribute');
if (isset($rowCatalogAttribute->value)) {
$attributeValue = $rowCatalogAttribute->value;
} else {
$attributeValue = '';
}
if (isset($rowCatalogAttribute->guid)) {
$catalogAttributeGuid = $rowCatalogAttribute->guid;
} else {
$guidMan = new Pandamp_Core_Guid();
$catalogAttributeGuid = $guidMan->generateGuid();
}
$attributeRenderer = new Pandamp_Form_Attribute_Renderer($rowAttribute->guid, $attributeValue, $rowAttribute->type, null, 'author', 'partner');
$aRenderedAttributes[$rowAttribute->guid]['description'] = $rowAttribute->description;
$aRenderedAttributes[$rowAttribute->guid]['form'] = $attributeRenderer->render();
$i++;
}
$aBaseAttributes['guid']['description'] = '';
$aBaseAttributes['guid']['form'] = "<input type='hidden' name='guid' id='guid' value='{$rowCatalog->guid}'>";
$aBaseAttributes['profileGuid']['description'] = '';
$aBaseAttributes['profileGuid']['form'] = "<input type='hidden' name='profileGuid' id='profileGuid' value='{$rowCatalog->profileGuid}'>";
$s = '<input type="Text" id="publishedDate" maxlength="25" size="25" name="publishedDate" value="' . $rowCatalog->publishedDate . '"><a href="javascript:NewCal(\'publishedDate\',\'yyyymmdd\',true,24)"><img src="' . ROOT_URL . '/resources/images/img.gif" width="16" height="16" border="0" alt="Pick a date"></a>';
$aBaseAttributes['publishedDate']['description'] = 'Published Date';
$aBaseAttributes['publishedDate']['form'] = $s;
$n = '<input type="Text" id="expiredDate" maxlength="25" size="25" name="expiredDate" value="' . $rowCatalog->expiredDate . '"><a href="javascript:NewCal(\'expiredDate\',\'yyyymmdd\',true,24)"><img src="' . ROOT_URL . '/resources/images/img.gif" width="16" height="16" border="0" alt="Pick a date"></a>';
$aBaseAttributes['expiredDate']['description'] = 'Expired Date';
$aBaseAttributes['expiredDate']['form'] = $n;
$aBaseAttributes['createdDate']['description'] = 'Created on';
$aBaseAttributes['createdDate']['form'] = $rowCatalog->createdDate . "<input type='hidden' name='createdDate' id='createdDate' value='{$rowCatalog->createdDate}'>";
$aBaseAttributes['modifiedDate']['description'] = 'Last Modified on';
$aBaseAttributes['modifiedDate']['form'] = $rowCatalog->modifiedDate . "<input type='hidden' name='modifiedDate' id='modifiedDate' value='{$today}'>";
$aBaseAttributes['deletedDate']['description'] = 'Deleted on';
$aBaseAttributes['deletedDate']['form'] = $rowCatalog->deletedDate . "<input type='hidden' name='deletedDate' id='deletedDate' value='{$rowCatalog->deletedDate}'>";
$aBaseAttributes['status']['description'] = 'Status';
require_once CONFIG_PATH . '/master-status.php';
$statusConfig = MasterStatus::getPublishingStatus();
$attributeRenderer = new Pandamp_Form_Attribute_Renderer('status', $rowCatalog->status, 101);
$aBaseAttributes['status']['form'] = $attributeRenderer->render();
$aReturn = array();
$aReturn['baseForm'] = $aBaseAttributes;
$aReturn['attributeForm'] = $aRenderedAttributes;
return $aReturn;
}
public function viewsearchAction()
{
$catalogGuid = $this->_getParam('guid') ? $this->_getParam('guid') : '';
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowCatalog = $tblCatalog->find($catalogGuid)->current();
$rowsetCatalogAttribute = $rowCatalog->findDependentRowsetCatalogAttribute();
$this->view->catalogTitle = $rowsetCatalogAttribute->findByAttributeGuid('fixedTitle')->value;
$this->view->catalogGuid = $catalogGuid;
}
/**
* 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 getCatalogShortTitle($guid)
{
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowset = $tblCatalog->find($guid)->current();
if ($rowset) {
return $rowset->shortTitle;
} else {
return 'no-title';
}
}
public function viewFolderAction()
{
$catalogGuid = $this->_getParam('guid') ? $this->_getParam('guid') : '';
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowCatalog = $tblCatalog->find($catalogGuid)->current();
if ($rowCatalog) {
$rowsetFolder = $rowCatalog->findManyToManyRowset('Pandamp_Modules_Dms_Folder_Model_Folder', 'Pandamp_Modules_Dms_Catalog_Model_CatalogFolder');
$this->view->rowsetFolder = $rowsetFolder;
$this->view->catalogGuid = $catalogGuid;
}
}
function terbaruAction()
{
$time_start = microtime(true);
$modelCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$data = array();
$num_rows = $modelCatalog->getWartaCount("lt4a0a533e31979");
$limit = 50;
$data['totalCount'] = $num_rows;
$data['limit'] = $limit;
$this->view->aData = $data;
}
public function GetCatalogIsFile($catalogGuid)
{
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowset = $tblCatalog->find($catalogGuid)->current();
if ($rowset) {
if ($rowset->profileGuid == "kutu_doc") {
return "<font color=red>[file]</font>";
}
} else {
return '';
}
}
public function GetCatalogDocType($catalogGuid)
{
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowsetCatalog = $tblCatalog->find($catalogGuid);
if (count($rowsetCatalog)) {
$rowCatalog = $rowsetCatalog->current();
$rowsetCatAtt = $rowCatalog->findDependentRowsetCatalogAttribute();
$docType = $this->imageDocumentType($this->dl_file($rowsetCatAtt->findByAttributeGuid('docOriginalName')->value));
} else {
$docType = '';
}
return $docType;
}
public function GetCatalogDocSize($catalogGuid)
{
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowsetCatalog = $tblCatalog->find($catalogGuid);
if (count($rowsetCatalog)) {
$rowCatalog = $rowsetCatalog->current();
$rowsetCatAtt = $rowCatalog->findDependentRowsetCatalogAttribute();
$docSize = $this->bytesToString($rowsetCatAtt->findByAttributeGuid('docSize')->value);
} else {
$docSize = '0kB';
}
return $docSize;
}
function mitraKlinikAction()
{
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowset = $tblCatalog->fetchAll("guid!='lt4b1a5aadda0f1' AND profileGuid='partner'", 'createdDate DESC');
$content = 0;
$data = array();
foreach ($rowset as $row) {
$modelCatalogAttribute = new Pandamp_Modules_Dms_Catalog_Model_CatalogAttribute();
$data[$content][0] = $modelCatalogAttribute->getCatalogAttributeValue($row->guid, 'fixedTitle');
$data[$content][1] = $modelCatalogAttribute->getCatalogAttributeValue($row->guid, 'fixedContent');
$data[$content][2] = $row->guid;
$content++;
}
$num_row = count($rowset);
$this->view->numberOfRows = $num_row;
$this->view->aData = $data;
}
function viewAction()
{
$request = $this->getRequest();
$itemGuid = $request->getParam('guid');
// $aclAdapter = Kutu_Acl::manager();
// $aUsers = $aclAdapter->getUsers();
// $aGroups = $aclAdapter->getGroups();
// $aTmp = array();
// for ($i=0;$i<count($aUsers);$i++)
// {
// $aTmp[$i]['username'] = $aUsers[$i];
// $aPerms = $aclAdapter->getPermissionsOnContent($aUsers[$i], null, $itemGuid);
// for($ii=0;$ii<count($aPerms);$ii++)
// {
// $aTmp[$i]['perms'][$aPerms[$ii]] = 1;
// }
// }
// $this->view->aDataUser = $aTmp;
// $aTmp = array();
// for($i=0;$i<count($aGroups);$i++)
// {
// $aTmp[$i]['group'] = $aGroups[$i]['value'];
//
// $aPerms = $aclAdapter->getPermissionsOnContent(null, $aGroups[$i]['value'], $itemGuid);
// for($ii=0;$ii<count($aPerms);$ii++)
// {
// $aTmp[$i]['perms'][$aPerms[$ii]] = 1;
// }
// }
// $this->view->aDataGroup = $aTmp;
$this->view->itemGuid = $itemGuid;
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowset = $tblCatalog->find($itemGuid);
if (count($rowset) > 0) {
$row = $rowset->current();
$this->view->itemTitle = 'CATALOG : ' . $row->shortTitle;
} else {
$tblFolder = new Pandamp_Modules_Dms_Folder_Model_Folder();
$rowset = $tblFolder->find($itemGuid);
if (count($rowset) > 0) {
$row = $rowset->current();
$this->view->itemTitle = 'FOLDER : ' . $row->title;
}
}
}
function createAction()
{
$req = $this->getRequest();
$item = $req->getParam('itemGuid');
$relatedItem = $req->getParam('relatedGuid');
$as = $req->getParam('relateAs');
$aResult = array();
try {
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowCatalog = $tblCatalog->find($item)->current();
$rowCatalog->relateTo($relatedItem, $as);
$aResult['isError'] = false;
$aResult['msg'] = 'Adding Relation Success';
} catch (Exception $e) {
$aResult['isError'] = true;
$aResult['msg'] = $e->getMessage();
}
echo Zend_Json::encode($aResult);
}
function downloadFileAction()
{
$catalogGuid = $this->_getParam('guid');
$parentGuid = $this->_getParam('parent');
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowsetCatalog = $tblCatalog->find($catalogGuid);
if (count($rowsetCatalog)) {
$rowCatalog = $rowsetCatalog->current();
$rowsetCatAtt = $rowCatalog->findDependentRowsetCatalogAttribute();
$contentType = $rowsetCatAtt->findByAttributeGuid('docMimeType')->value;
$filename = $systemname = $rowsetCatAtt->findByAttributeGuid('docSystemName')->value;
$oriName = $rowsetCatAtt->findByAttributeGuid('docOriginalName')->value;
$tblRelatedItem = new Pandamp_Modules_Dms_Catalog_Model_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;
if (file_exists($sDir1)) {
$flagFileFound = true;
header("Content-type: {$contentType}");
header("Content-Disposition: attachment; filename={$filename}");
@readfile($sDir1);
} else {
if (file_exists($sDir2)) {
$flagFileFound = true;
header("Content-type: {$contentType}");
header("Content-Disposition: attachment; filename={$oriName}");
@readfile($sDir2);
} else {
$flagFileFound = false;
}
}
}
}
} else {
echo 'NO FILE';
}
}
public function forceDelete($folderGuid)
{
$tblFolder = new Pandamp_Modules_Dms_Folder_Model_Folder();
$rowset = $tblFolder->fetchChildren($folderGuid);
$rowFolder = $tblFolder->find($folderGuid)->current();
foreach ($rowset as $row) {
$this->forceDelete($row->guid);
}
$rowsetCatalogFolder = $rowFolder->findDependentRowsetCatalogFolder();
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$holCatalog = new Pandamp_Core_Hol_Catalog();
if (count($rowsetCatalogFolder)) {
foreach ($rowsetCatalogFolder as $rowCatalogFolder) {
$rowCatalog = $tblCatalog->find($rowCatalogFolder->catalogGuid)->current();
$holCatalog->delete($rowCatalog->guid);
}
$this->delete($rowFolder->guid);
} else {
$this->delete($rowFolder->guid);
}
}
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);
}
public function reIndexCatalog_ZendDb()
{
$this->emptyIndex();
$time_start = microtime(true);
$solr =& $this->_solr;
$tbl = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowset = $tbl->fetchAll();
//("profileGuid='kutu_peraturan'");
$documents = array();
$rowCount = count($rowset);
for ($iCount = 0; $iCount < $rowCount; $iCount++) {
$row = $rowset->current();
// if($iCount == 100)
// break;
echo 'urutan: ' . $iCount . '<br>';
$documents[] = $this->_createSolrDocument($row);
$rowset->next();
if ($iCount % 1000 == 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;
throw new Zend_Exception($e->getMessage());
//echo $e->getMessage();
}
}
}
try {
$solr->addDocuments($documents);
$solr->commit();
$solr->optimize();
} catch (Exception $e) {
throw new Zend_Exception($e->getMessage());
//echo $e->getMessage();
}
$time_end = microtime(true);
$time = $time_end - $time_start;
echo '<br>WAKTU EKSEKUSI: ' . $time;
}
protected function _postDelete()
{
$registry = Zend_Registry::getInstance();
$config = $registry->get(Pandamp_Keys::REGISTRY_APP_OBJECT);
$cdn = $config->getOption('cdn');
//find related docs and delete them
$tblRelatedItem = new Pandamp_Modules_Dms_Catalog_Model_RelatedItem();
$rowsetRelatedDocs = $tblRelatedItem->fetchAll("relatedGuid='{$this->guid}' AND relateAs IN ('RELATED_FILE','RELATED_IMAGE')");
if (count($rowsetRelatedDocs)) {
foreach ($rowsetRelatedDocs as $rowRelatedDoc) {
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowCatalog = $tblCatalog->find($rowRelatedDoc->itemGuid)->current();
$rowCatalog->delete();
}
}
if ($this->profileGuid == 'kutu_doc') {
//get parentGuid
$tblRelatedItem = new Pandamp_Modules_Dms_Catalog_Model_RelatedItem();
$rowsetRelatedItem = $tblRelatedItem->fetchAll("itemGuid='{$this->guid}' AND relateAs IN ('RELATED_FILE','RELATED_IMAGE')");
if (count($rowsetRelatedItem)) {
foreach ($rowsetRelatedItem as $rowRelatedItem) {
//must delete the physical files
$rowsetCatAtt = $this->findDependentRowsetCatalogAttribute();
$systemname = $rowsetCatAtt->findByAttributeGuid('docSystemName')->value;
$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;
$sDir1 = $cdn['static']['dir']['files'] . "/" . $systemname;
$sDir2 = $cdn['static']['dir']['files'] . "/" . $parentGuid . "/" . $systemname;
$sDir1_Remote = $cdn['remote']['dir']['files'] . "/" . $systemname;
$sDir2_Remote = $cdn['remote']['dir']['files'] . "/" . $parentGuid . "/" . $systemname;
if (file_exists($sDir1)) {
// delete file
unlink($sDir1);
// check remote file
if (file_exists($sDir1_Remote)) {
$this->remoteDeleteFile($sDir1_Remote);
}
} else {
if (file_exists($sDir2)) {
//delete file
unlink($sDir2);
// check remote file
if (file_exists($sDir2_Remote)) {
$this->remoteDeleteFile($sDir2_Remote);
}
}
}
$img1 = $cdn['static']['dir']['images'] . "/" . $systemname;
$img2 = $cdn['static']['dir']['images'] . "/" . $parentGuid . "/" . $systemname;
$img1_Remote = $cdn['remote']['dir']['images'] . "/" . $systemname;
$img2_Remote = $cdn['remote']['dir']['images'] . "/" . $parentGuid . "/" . $systemname;
if (file_exists($img1)) {
// delete file
unlink($img1);
// check remote file
if (file_exists($img1_Remote)) {
$this->remoteDeleteFile($img1_Remote);
}
} else {
if (file_exists($img2)) {
//delete file
unlink($img2);
// check remote file
if (file_exists($img2_Remote)) {
$this->remoteDeleteFile($img2_Remote);
}
}
}
}
}
}
//delete from table CatalogAttribute
$tblCatalogAttribute = new Pandamp_Modules_Dms_Catalog_Model_CatalogAttribute();
$tblCatalogAttribute->delete("catalogGuid='{$this->guid}'");
//delete catalogGuid from table CatalogFolder
$tblCatalogFolder = new Pandamp_Modules_Dms_Catalog_Model_CatalogFolder();
$tblCatalogFolder->delete("catalogGuid='{$this->guid}'");
//delete guid from table AssetSetting
$tblAssetSetting = new Pandamp_Modules_Dms_Catalog_Model_AssetSetting();
$tblAssetSetting->delete("guid='{$this->guid}'");
//delete from table relatedItem
$tblRelatedItem = new Pandamp_Modules_Dms_Catalog_Model_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 = ROOT_DIR.DIRECTORY_SEPARATOR.'uploads'.DIRECTORY_SEPARATOR.'files'.DIRECTORY_SEPARATOR.$this->guid;
$sDir = $cdn['static']['dir']['files'] . "/" . $this->guid;
$sDir_Remote = $cdn['remote']['dir']['files'] . "/" . $this->guid;
try {
if (is_dir($sDir)) {
rmdir($sDir);
// check remote is_dir
if (is_dir($sDir_Remote)) {
$this->remoteRemoveDir($sDir_Remote);
}
}
} catch (Exception $e) {
}
//$sDir = ROOT_DIR.DIRECTORY_SEPARATOR.'uploads'.DIRECTORY_SEPARATOR.'images';
$sDir = $cdn['static']['dir']['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) {
}
$sDir = $cdn['remote']['dir']['images'];
try {
if (file_exists($sDir . "/" . $this->guid . ".gif")) {
$this->remoteDeleteFile($sDir . "/" . $this->guid . ".gif");
}
if (file_exists($sDir . "/tn_" . $this->guid . ".gif")) {
$this->remoteDeleteFile($sDir . "/tn_" . $this->guid . ".gif");
}
if (file_exists($sDir . "/" . $this->guid . ".jpg")) {
$this->remoteDeleteFile($sDir . "/" . $this->guid . ".jpg");
}
if (file_exists($sDir . "/tn_" . $this->guid . ".jpg")) {
$this->remoteDeleteFile($sDir . "/tn_" . $this->guid . ".jpg");
}
if (file_exists($sDir . "/" . $this->guid . ".jpeg")) {
$this->remoteDeleteFile($sDir . "/" . $this->guid . ".jpeg");
}
if (file_exists($sDir . "/tn_" . $this->guid . ".jpeg")) {
$this->remoteDeleteFile($sDir . "/tn_" . $this->guid . ".jpeg");
}
if (file_exists($sDir . "/" . $this->guid . ".png")) {
$this->remoteDeleteFile($sDir . "/" . $this->guid . ".png");
}
if (file_exists($sDir . "/tn_" . $this->guid . ".png")) {
$this->remoteDeleteFile($sDir . "/tn_" . $this->guid . ".png");
}
} catch (Exception $e) {
}
}
function indexAction()
{
$r = $this->getRequest();
$start = $r->getParam('start') ? $r->getParam('start') : 0;
$limit = $r->getParam('limit') ? $r->getParam('limit') : 20;
$modelCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$decorator = new Pandamp_BeanContext_Decorator($modelCatalog);
//$rowset = $decorator->fetchFromFolderAsEntity('lt4a0a533e31979',$start,$limit,"indexklinik");
$rowset = $decorator->fetchFromFolderAsEntity('lt4a0a533e31979', $start, $limit);
$a = array();
$solrNumFound = $modelCatalog->getWartaCount("lt4a0a533e31979");
$ii = 0;
if ($solrNumFound == 0) {
$a['terbaru'][0]['guid'] = 'XXX';
$a['terbaru'][0]['title'] = 'Kategori klinik kosong';
$a['terbaru'][0]['pertanyaan'] = "";
$a['terbaru'][0]['createdBy'] = "";
$a['terbaru'][0]['kategori'] = '';
$a['terbaru'][0]['author'] = '';
$a['terbaru'][0]['sumber'] = '';
} else {
foreach ($rowset as $row) {
$modelCatalogAttribute = new Pandamp_Modules_Dms_Catalog_Model_CatalogAttribute();
$rowCatalogTitle = $modelCatalogAttribute->getCatalogAttributeValue($row->getId(), 'fixedCommentTitle');
$rowCatalogQuestion = $modelCatalogAttribute->getCatalogAttributeValue($row->getId(), 'fixedCommentQuestion');
$rowCatalogSelectCat = $modelCatalogAttribute->getCatalogAttributeValue($row->getId(), 'fixedKategoriKlinik');
$author = $modelCatalogAttribute->getCatalogAttributeValue($row->getId(), 'fixedSelectNama');
$source = $modelCatalogAttribute->getCatalogAttributeValue($row->getId(), 'fixedSelectMitra');
/* Get Category from profile clinic_category */
$findCategory = $decorator->getCatalogByGuidAsEntity($rowCatalogSelectCat);
$category = $modelCatalogAttribute->getCatalogAttributeValue($findCategory->getId(), 'fixedTitle');
/* Get Author from profile author */
$findAuthor = $decorator->getCatalogByGuidAsEntity($author);
$author = $modelCatalogAttribute->getCatalogAttributeValue($findAuthor->getId(), 'fixedTitle');
/* Get Source from profile partner */
$findSource = $decorator->getCatalogByGuidAsEntity($source);
if ($findSource) {
$source = $modelCatalogAttribute->getCatalogAttributeValue($findSource->getId(), 'fixedTitle');
}
$a['terbaru'][$ii]['guid'] = $row->getId();
$a['terbaru'][$ii]['title'] = $rowCatalogTitle;
$a['terbaru'][$ii]['pertanyaan'] = $rowCatalogQuestion;
$a['terbaru'][$ii]['createdBy'] = 'Penanya:' . $row->getCreatedBy();
$a['terbaru'][$ii]['kategori'] = $category;
$a['terbaru'][$ii]['author'] = 'Jawaban oleh : ' . $author;
$a['terbaru'][$ii]['sumber'] = 'Sumber : ' . $source;
$ii++;
}
}
echo Zend_Json::encode($a);
}
public function viewerAction()
{
$catalogGuid = $this->_getParam('guid') ? $this->_getParam('guid') : '';
$modelCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
if (!empty($catalogGuid)) {
$rowCatalog = $modelCatalog->find($catalogGuid)->current();
$rowsetCatalogAttribute = $rowCatalog->findDependentRowsetCatalogAttribute();
$tableProfileAttribute = new Pandamp_Modules_Dms_Profile_Model_ProfileAttribute();
$profileGuid = $rowCatalog->profileGuid;
$where = $tableProfileAttribute->getAdapter()->quoteInto('profileGuid=?', $profileGuid);
$rowsetProfileAttribute = $tableProfileAttribute->fetchAll($where, 'viewOrder ASC');
$aAttribute = array();
$i = 0;
$tblAttribute = new Pandamp_Modules_Dms_Catalog_Model_Attribute();
foreach ($rowsetProfileAttribute as $rowProfileAttribute) {
if ($rowsetCatalogAttribute->findByAttributeGuid($rowProfileAttribute->attributeGuid)) {
$rowCatalogAttribute = $rowsetCatalogAttribute->findByAttributeGuid($rowProfileAttribute->attributeGuid);
$rowsetAttribute = $tblAttribute->find($rowCatalogAttribute->attributeGuid);
if (count($rowsetAttribute)) {
$rowAttribute = $rowsetAttribute->current();
$aAttribute[$i]['name'] = $rowAttribute->name;
} else {
$aAttribute[$i]['name'] = '';
}
$aAttribute[$i]['value'] = $rowCatalogAttribute->value;
} else {
}
$i++;
}
}
$this->view->aAttribute = $aAttribute;
$this->view->rowsetCatalogAttribute = $rowsetCatalogAttribute;
$rowCatalogAttribute = $rowsetCatalogAttribute->findByAttributeGuid('fixedExpired');
if (!empty($rowCatalogAttribute->value)) {
$tDate = $rowCatalogAttribute->value;
$aDate = explode('-', $tDate);
$year = $aDate[0];
$month = $aDate[1];
$day = $aDate[2];
$hour = "00";
$minute = "00";
$second = "00";
//set what is going to happen than
$event = "My birthday";
//don't change anything below unless you know what you are doing
$time = mktime($hour, $minute, $second, $month, $day, $year);
$timecurrent = date('U');
$cuntdowntime = $time - $timecurrent;
$cuntdownminutes = $cuntdowntime / 60;
$cuntdownhours = $cuntdowntime / 3600;
$cuntdowndays = $cuntdownhours / 24;
$cuntdownmonths = $cuntdowndays / 30;
$cuntdownyears = $cuntdowndays / 365;
//echo 'sisa hari: ' . $cuntdowndays;
if ($cuntdowndays < 0) {
echo "<script>alert('Dokumen perjanjian ini telah berakhir masa berlakunya.');</script>";
echo "<br><strong>Dokumen perjanjian ini telah berakhir masa berlakunya.</strong>";
} else {
//echo "<script>alert('Dokumen perjanjian ini akan berakhir masa berlakunya dalam ".round($cuntdowndays)." hari.');</script>";
echo "<br><strong>Dokumen perjanjian ini akan berakhir masa berlakunya dalam " . round($cuntdowndays) . " hari.</strong>";
}
}
$this->_helper->viewRenderer('viewer-generic');
}
function isAllowed($username, $itemGuid, $action, $section = 'content')
{
if ($this->checkAcl("action", 'all', 'user', $username, 'content', 'all-access')) {
return true;
}
if ($section == 'content') {
// if($this->checkAcl("dms",'all','user', $username, false,false))
// return true;
/**
* TODO
*/
switch ($action) {
case 'create':
if ($this->checkAcl("action", 'create', 'user', $username, false, false)) {
return true;
}
case 'read':
if ($this->checkAcl("action", 'read', 'user', $username, false, false) || $acl->checkAcl("action", 'update', 'user', $username, false, false)) {
return true;
}
case 'update':
if ($this->checkAcl("action", 'update', 'user', $username, false, false)) {
return true;
}
case 'delete':
if ($this->checkAcl("action", 'delete', 'user', $username, false, false)) {
return true;
}
}
// if ($this->checkAcl('action', $action, 'user', $username, 'admin', 'content'))
// return true;
//check if itemGuid exist in table KutuCatalog
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowset = $tblCatalog->find($itemGuid);
if (count($rowset) > 0) {
$row = $rowset->current();
if ($row->profileGuid != 'kutu_folder') {
//if user was the creator of the item, allow everything
if ($row->createdBy == $username) {
return true;
}
$aAclId = $this->searchAcl('action', false, false, false, false, 'content', $itemGuid);
if (count($aAclId) > 0) {
return $this->checkAcl('action', $action, 'user', $username, 'content', $itemGuid);
} else {
//check permission of the folder which this catalog belongs to
$rowset1 = $row->findDependentRowset('Pandamp_Modules_Dms_Catalog_Model_CatalogFolder');
$flagFolderPermission = false;
foreach ($rowset1 as $row1) {
if ($this->_traverseFolderPermission($username, $row1->folderGuid, $action)) {
$flagFolderPermission = true;
}
}
return $flagFolderPermission;
}
}
}
//check if itemGuid exist in table KutuFolder
$tblFolder = new Pandamp_Modules_Dms_Folder_Model_Folder();
$rowset = $tblFolder->find($itemGuid);
if (count($rowset) > 0) {
return $this->_traverseFolderPermission($username, $itemGuid, $action);
}
}
//check at section
$aAclId = $this->searchAcl('action', false, false, false, false, $section, $itemGuid);
if (count($aAclId) > 0) {
return $this->checkAcl('action', $action, 'user', $username, $section, $itemGuid);
}
//check at feature section
/*$aAclId = $this->searchAcl('action', false, false, false, false, 'feature', $itemGuid);
if(count($aAclId)>0)
{
return $this->checkAcl('action', $action, 'user', $username, 'feature', $itemGuid);
}*/
return false;
}
function generateFormAdd($catalogGuid, $folderGuid = null)
{
$aRenderedAttributes = array();
$aBaseAttributes = array();
$tableCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowsetCatalog = $tableCatalog->find($catalogGuid);
$rowCatalog = $rowsetCatalog->current();
if (!isset($rowCatalog)) {
$tableProfileAttribute = new Pandamp_Modules_Dms_Profile_Model_ProfileAttribute();
$where = $tableProfileAttribute->getAdapter()->quoteInto('profileGuid=?', 'setting');
$rows = $tableProfileAttribute->fetchAll($where, 'viewOrder ASC');
$i = 0;
foreach ($rows as $row) {
$rowset = $row->findParentRow('Pandamp_Modules_Dms_Catalog_Model_Attribute');
$attributeRenderer = new Pandamp_Form_Attribute_Renderer($rowset->guid, null, $rowset->type, null);
$aRenderedAttributes[$rowset->guid]['description'] = $rowset->description;
$aRenderedAttributes[$rowset->guid]['form'] = $attributeRenderer->render();
$i++;
}
$aBaseAttributes['profileGuid']['description'] = '';
$aBaseAttributes['profileGuid']['form'] = "<input type='hidden' name='profileGuid' id='profileGuid' value='setting'>";
$aBaseAttributes['folderGuid']['description'] = '';
$aBaseAttributes['folderGuid']['form'] = "<input type='hidden' name='folderGuid' id='folderGuid' value='{$folderGuid}'>";
$aBaseAttributes['status']['description'] = '';
$aBaseAttributes['status']['form'] = "<input type='hidden' name='status' id='status' value='1'>";
} else {
$tableProfileAttributes = new Pandamp_Modules_Dms_Profile_Model_ProfileAttribute();
$where = $tableProfileAttributes->getAdapter()->quoteInto('profileGuid=?', $rowCatalog->profileGuid);
$rowsetProfileAttributes = $tableProfileAttributes->fetchAll($where, array('viewOrder ASC'));
$rowsetCatalogAttribute = $rowCatalog->findDependentRowsetCatalogAttribute();
$i = 0;
foreach ($rowsetProfileAttributes as $row) {
$rowCatalogAttribute = $rowsetCatalogAttribute->findByAttributeGuid($row->attributeGuid);
$rowAttribute = $row->findParentRow('Pandamp_Modules_Dms_Catalog_Model_Attribute');
if (isset($rowCatalogAttribute->value)) {
$attributeValue = $rowCatalogAttribute->value;
} else {
$attributeValue = '';
}
if (isset($rowCatalogAttribute->guid)) {
$catalogAttributeGuid = $rowCatalogAttribute->guid;
} else {
$guidMan = new Pandamp_Core_Guid();
$catalogAttributeGuid = $guidMan->generateGuid();
}
$attributeRenderer = new Pandamp_Form_Attribute_Renderer($rowAttribute->guid, $attributeValue, $rowAttribute->type, null);
$aRenderedAttributes[$rowAttribute->guid]['description'] = $rowAttribute->description;
$aRenderedAttributes[$rowAttribute->guid]['form'] = $attributeRenderer->render();
$i++;
}
$aBaseAttributes['guid']['description'] = '';
$aBaseAttributes['guid']['form'] = "<input type='hidden' name='guid' id='guid' value='{$rowCatalog->guid}'>";
$aBaseAttributes['profileGuid']['description'] = '';
$aBaseAttributes['profileGuid']['form'] = "<input type='hidden' name='profileGuid' id='profileGuid' value='{$rowCatalog->profileGuid}'>";
$aBaseAttributes['status']['description'] = '';
$aBaseAttributes['status']['form'] = "<input type='hidden' name='status' id='status' value='1'>";
}
$aReturn = array();
$aReturn['baseForm'] = $aBaseAttributes;
$aReturn['attributeForm'] = $aRenderedAttributes;
return $aReturn;
}
public function fetchClinicAction()
{
$start = $this->_getParam('start') ? $this->_getParam('start') : 0;
$end = $this->_getParam('limit') ? $this->_getParam('limit') : 10;
$status = $this->_getParam('status') ? $this->_getParam('status') : 0;
//$folderGuid = 'lt4a0a533e31979'; // Klinik
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowset = $tblCatalog->fetchFromFolderAdminClinic($status, $start, $end);
$a = array();
$a['totalCount'] = $tblCatalog->countCatalogsInFolderClinic($status);
$now = date('Y-m-d H:i:s');
$ii = 0;
if ($a['totalCount'] != 0) {
foreach ($rowset as $row) {
$modelCatalogAttribute = new Pandamp_Modules_Dms_Catalog_Model_CatalogAttribute();
$a['clinic'][$ii]['guid'] = $row->guid;
$a['clinic'][$ii]['title'] = $modelCatalogAttribute->getCatalogAttributeValue($row->guid, 'fixedCommentTitle');
$a['clinic'][$ii]['question'] = $modelCatalogAttribute->getCatalogAttributeValue($row->guid, 'fixedCommentQuestion');
$a['clinic'][$ii]['content'] = $modelCatalogAttribute->getCatalogAttributeValue($row->guid, 'fixedContent');
$findPartner = $tblCatalog->getCatalogByGuid($modelCatalogAttribute->getCatalogAttributeValue($row->guid, 'fixedSelect'));
if ($findPartner) {
$a['clinic'][$ii]['partner'] = $modelCatalogAttribute->getCatalogAttributeValue($findPartner->guid, 'fixedTitle');
}
$a['clinic'][$ii]['createdby'] = $row->createdBy;
$a['clinic'][$ii]['modifiedby'] = $row->modifiedBy;
$a['clinic'][$ii]['createdDate'] = Pandamp_Lib_Formater::get_date($row->createdDate);
if ($now <= $row->publishedDate && $row->status == 99) {
$status = "publish_y";
} else {
if (($now <= $row->expiredDate || $row->expiredDate == '0000-00-00 00:00:00') && $row->status == 99) {
$status = "publish_g";
} else {
if ($now > $row->expiredDate && $row->status == 99) {
$status = "publish_r";
} else {
if ($row->status == 0) {
$status = "publish_x";
} else {
if ($row->status == 1) {
$status = "ruby";
} else {
if ($row->status == 2) {
$status = "pill";
} else {
if ($row->status == -1) {
$status = "disabled";
}
}
}
}
}
}
}
$a['clinic'][$ii]['status'] = $status;
$ii++;
}
}
if ($a['totalCount'] == 0) {
$a['clinic'][0]['guid'] = 'XXX';
$a['clinic'][0]['title'] = "No Data";
$a['clinic'][0]['question'] = "-";
$a['clinic'][0]['createdDate'] = '';
}
echo Zend_Json::encode($a);
}
public function render()
{
$sReturn = '';
switch ($this->type) {
default:
case 0:
// field type = single line
$view = new Zend_View();
$view->name = $this->name;
$view->value = $this->value;
if (isset($this->attribs)) {
$view->attribs = $this->attribs;
} else {
$view->attribs = array('rows' => 1, 'cols' => 50);
}
$view->setScriptPath(dirname(__FILE__));
return $view->render('TextArea.phtml');
break;
case 1:
// field type = textarea paragraph
$view = new Zend_View();
$view->name = $this->name;
$view->value = $this->value;
if (isset($this->attribs)) {
$view->attribs = $this->attribs;
} else {
$view->attribs = array('rows' => 5, 'cols' => 50);
}
$view->setScriptPath(dirname(__FILE__));
return $view->render('TextArea.phtml');
break;
case 2:
// field type = html paragraph
require_once 'FCKeditor/fckeditor.php';
$oFCKeditor = new FCKeditor($this->name);
$oFCKeditor->BasePath = ROOT_URL . '/library/FCKeditor/';
$oFCKeditor->Value = $this->value;
$oFCKeditor->Width = '100%';
$oFCKeditor->Height = '400';
$sReturn = $oFCKeditor->CreateHtml();
return $sReturn;
break;
case 3:
// field type = hidden
$n = "<input type='hidden' name='{$this->name}' value='{$this->value}'>";
return $n;
break;
case -400:
//$value = $this->convertDate($fieldValue);
$value = $fieldValue;
echo '<script language="Javascript" src="calendar/calendar.js"></script>';
echo '<input type="text" name="' . $attributeId . '" value="' . $value . '">';
$fieldTblGuid = $attributeId . '_guid';
echo "<input type='hidden' name='{$fieldTblGuid}' value='{$tblGuid}'>";
echo ' <a href="javascript: void(0);" onclick="return getCalendar(document.forms[0].' . $attributeId . ');" onChange="AddCurrentTime(document.forms[0].' . $attributeId . ');">Pilih Tanggal</a>';
break;
case 4:
$view = new Zend_View();
$view->name = $this->name;
$view->value = $this->value;
$view->setScriptPath(dirname(__FILE__));
return $view->render('datetime.phtml');
break;
//datetime field
//datetime field
case 5:
/*echo
'<link rel="stylesheet" type="text/css" media="all" href="calendar2/calendar-mos.css" title="green" />
<script type="text/javascript" src="calendar2/calendar.js"></script>
<script type="text/javascript" src="calendar2/lang/calendar-en.js"></script>
<script language="javascript" src="calendar2/mambojavascript.js"></script>';*/
$view = new Zend_View();
$view->name = $this->name;
$view->value = $this->value;
$view->setScriptPath(dirname(__FILE__));
return $view->render('datetime.phtml');
/*$fieldTblGuid = $attributeId.'_guid';
echo "<input type='hidden' name='$fieldTblGuid' value='$tblGuid'>";
echo '<input class="inputbox" type="text" name="'.$attributeId.'" id="'.$attributeId.'" size="25" maxlength="25" value="'.$fieldValue.'" />';
echo '<input type="reset" class="button" value="..." onClick="return showCalendar'."('$attributeId', 'dd/mm/Y')".';">';*/
break;
case 6:
$view = new Zend_View();
$view->name = $this->name;
$view->value = $this->value;
if (isset($this->attribs)) {
$view->attribs = $this->attribs;
} else {
$view->attribs = array('size' => 25, 'maxlength' => '50');
}
$view->setScriptPath(dirname(__FILE__));
return $view->render('Text.phtml');
break;
case -5:
// field type = Image Area
$frm = new FormInputImageAreaUc();
$frm->fieldName = $attributeId;
$frm->fieldValue = $fieldValue;
$frm->renderMe();
$fieldTblGuid = $attributeId . '_guid';
echo "<input type='hidden' name='{$fieldTblGuid}' value='{$tblGuid}'>";
break;
case -6:
// field type = LABEL
echo $fieldValue;
echo "<input type='hidden' name='{$attributeId}' value='{$fieldValue}'>";
$fieldTblGuid = $attributeId . '_guid';
echo "<input type='hidden' name='{$fieldTblGuid}' value='{$tblGuid}'>";
break;
case 7:
// field type = MULTI VALUE (SELECT:OPTIONS)
/*$oAttGenerator = new UiFormInputAttributeGenerator();
$s = $oAttGenerator->generateFormInputAttributeByDmsProfileGuidAndAttributeGuid($this->dmsProfileGuid,$attributeId,$attributeId,$fieldValue);
echo $s;
//echo "<textarea name='$attributeId' rows='0' cols='50'>$fieldValue</textarea>";
$fieldTblGuid = $attributeId.'_guid';
echo "<input type='hidden' name='$fieldTblGuid' value='$tblGuid'>";
break;*/
$tblProAtt = new Pandamp_Modules_Dms_Profile_Model_ProfileAttribute();
$rowset = $tblProAtt->fetchAll("profileGuid='{$this->profileGuid}' AND attributeGuid='{$this->name}'");
$defaultValues = array();
if (count($rowset) == 1) {
$row = $rowset->current();
$defaultValues = Zend_Json::decode($row->defaultValues);
if (is_array($defaultValues)) {
//var_dump($defaultValues);
} else {
$defaultValues = array();
}
}
$view = new Zend_View();
$view->name = $this->name;
$view->value = $this->value;
$view->defaultValues = $defaultValues;
/*if(isset($this->attribs))
$view->attribs = $this->attribs;
else
$view->attribs = array('rows' => 5, 'cols' =>50);*/
$view->setScriptPath(dirname(__FILE__));
return $view->render('select.phtml');
break;
case 8:
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowset = $tblCatalog->fetchAll("profileGuid='{$this->other}'");
$i = 0;
$a = array();
$data = array();
foreach ($rowset as $row) {
$rowsetCatalogAttribute = $row->findDependentRowsetCatalogAttribute();
$rowCatalogAttribute = $rowsetCatalogAttribute->findByAttributeGuid('fixedTitle');
$a[$i]['label'] = is_object($rowCatalogAttribute) ? $rowCatalogAttribute->value : '';
$a[$i]['value'] = "{$row->guid}";
$a[$i]['selected'] = $i == 0 ? "true" : "false";
$i++;
}
$data = Zend_Json::decode(Zend_Json::encode($a));
$view = new Zend_View();
$view->name = $this->name;
$view->value = $this->value;
$view->defaultValues = $data;
$view->setScriptPath(dirname(__FILE__));
return $view->render('select.phtml');
break;
case 9:
$n = "<input type='text' class='txt' name='{$this->name}' value='{$this->value}' size='5'>";
return $n;
break;
case 10:
$n = '<textarea id="html" name="jTagEditor" class="jTagEditor">' . $this->value . '</textarea>';
return $n;
break;
case 11:
if ($this->value == 1) {
$check = 'checked';
} else {
$check = '';
}
$n = "<input type='checkbox' name='{$this->name}' value='1' {$check}>";
return $n;
break;
case 12:
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowset = $tblCatalog->fetchAll("profileGuid='{$this->profileGuid}'");
$i = 0;
$a = array();
$data = array();
foreach ($rowset as $row) {
$rowsetCatalogAttribute = $row->findDependentRowsetCatalogAttribute();
$rowCatalogAttribute = $rowsetCatalogAttribute->findByAttributeGuid('fixedTitle');
$a[$i]['label'] = is_object($rowCatalogAttribute) ? $rowCatalogAttribute->value : '';
$a[$i]['value'] = "{$row->guid}";
$a[$i]['selected'] = $i == 0 ? "true" : "false";
$i++;
}
$data = Zend_Json::decode(Zend_Json::encode($a));
$view = new Zend_View();
$view->name = $this->name;
$view->value = $this->value;
$view->defaultValues = $data;
$view->setScriptPath(dirname(__FILE__));
return $view->render('select.phtml');
break;
/*
* @TODO category clinic
*/
/*
* @TODO category clinic
*/
case 13:
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowset = $tblCatalog->fetchAll("profileGuid='kategoriklinik'");
$i = 0;
$a = array();
$data = array();
foreach ($rowset as $row) {
$rowsetCatalogAttribute = $row->findDependentRowsetCatalogAttribute();
$rowCatalogAttribute = $rowsetCatalogAttribute->findByAttributeGuid('fixedTitle');
$a[$i]['label'] = is_object($rowCatalogAttribute) ? $rowCatalogAttribute->value : '';
$a[$i]['value'] = "{$row->guid}";
$a[$i]['selected'] = $i == 0 ? "true" : "false";
$i++;
}
$data = Zend_Json::decode(Zend_Json::encode($a));
$view = new Zend_View();
$view->name = $this->name;
$view->value = $this->value;
$view->defaultValues = $data;
$view->setScriptPath(dirname(__FILE__));
return $view->render('select.phtml');
break;
case 101:
//publishing status
require_once CONFIG_PATH . '/master-status.php';
$aStatus = MasterStatus::getPublishingStatus();
$view = new Zend_View();
$view->name = $this->name;
$view->value = $this->value;
$auth = Zend_Auth::getInstance();
$username = $auth->getIdentity()->username;
// get group information
$acl = Pandamp_Acl::manager();
$aReturn = $acl->getUserGroupIds($username);
if (isset($aReturn[1])) {
if ($aReturn[1] == "clinicEditor") {
unset($aStatus[99]);
}
}
$view->defaultValues = $aStatus;
$view->setScriptPath(dirname(__FILE__));
return $view->render('select2.phtml');
}
}
public function jCartIsItemSellable($catalogGuid)
{
//apakah pernah dibeli
$auth = Zend_Auth::getInstance();
$hasBought = false;
if ($auth->hasIdentity()) {
$bpm = new Pandamp_Core_Hol_Catalog();
$hasBought = $bpm->isBoughtByUser($catalogGuid, $auth->getIdentity()->guid);
}
if ($hasBought) {
$aReturn['isError'] = true;
$aReturn['message'] = 'You have bought this Item before. Please check your account.';
$aReturn['code'] = 1;
return $aReturn;
}
// if status=draft then return false
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowCatalog = $tblCatalog->find($catalogGuid)->current();
if ($rowCatalog) {
if ($rowCatalog->status != 99) {
$aReturn['isError'] = true;
$aReturn['message'] = 'This item is not ready to be bought yet.';
$aReturn['code'] = 1;
return $aReturn;
}
// if price <= 0 then return false
if ($rowCatalog->price <= 0) {
$aReturn['isError'] = true;
$aReturn['message'] = 'This item is for FREE.';
$aReturn['code'] = 2;
return $aReturn;
}
/*
$tblRelatedItem = new Pandamp_Modules_Dms_Catalog_Model_RelatedItem();
$where = "relatedGuid='$catalogGuid' AND relateAs='RELATED_FILE'";
$rowsetRelatedItem = $tblRelatedItem->fetchAll($where);
if(count($rowsetRelatedItem) > 0)
{
//check if the physical FILE is available in uploads directory.
$flagFileFound = true;
foreach($rowsetRelatedItem as $rowRelatedItem)
{
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowsetCatalogFile = $tblCatalog->find($rowRelatedItem->itemGuid);
$rowCatalogFile = $rowsetCatalogFile->current();
$rowsetCatAtt = $rowCatalogFile->findDependentRowsetCatalogAttribute();
$contentType = $rowsetCatAtt->findByAttributeGuid('docMimeType')->value;
$systemname = $rowsetCatAtt->findByAttributeGuid('docSystemName')->value;
$filename = $rowsetCatAtt->findByAttributeGuid('docOriginalName')->value;
if(true)
{
$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;
if(file_exists($sDir1))
{
//$flagFileFound = true;
}
else
if(file_exists($sDir2))
{
//$flagFileFound = true;
}
else
{
$flagFileFound = false;
}
}
}
if($flagFileFound)
{
$aReturn['isError'] = false;
$aReturn['message'] = 'This item is SELLABLE.';
$aReturn['code'] = 99;
return $aReturn;
}
else
{
$aReturn['isError'] = true;
$aReturn['message'] = 'We are Sorry. The document(s) you are requesting is still under review. Please check back later.';
$aReturn['code'] = 5;
return $aReturn;
}
}
else
{
$aReturn['isError'] = true;
$aReturn['message'] = 'We are Sorry. The document(s) you are requesting is still being prepared. Please check back later.';
$aReturn['code'] = 5;
return $aReturn;
}
*/
} else {
$aReturn['isError'] = true;
$aReturn['message'] = 'Can not find your selected item(s).';
$aReturn['code'] = 10;
return $aReturn;
}
//if ada record related document, but tidak ada dokumen fisik, then return false
// if tidak ada record related document (blm ada dokumen/file diupload), then return false
// if pernah dibeli user sebelumnya, then return false
}
function downloadFile_OldAction()
{
$this->_helper->layout()->disableLayout();
$catalogGuid = $this->_getParam('guid');
$parentGuid = $this->_getParam('parent');
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowsetCatalog = $tblCatalog->find($catalogGuid);
if (count($rowsetCatalog)) {
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$guidUser = $auth->getIdentity()->kopel;
}
$tblAsetSetting = new Pandamp_Modules_Dms_Catalog_Model_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 Pandamp_Modules_Dms_Catalog_Model_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');
}
}
function listcommentAction()
{
$catalogGuid = $this->_getParam('guid') ? $this->_getParam('guid') : '';
$page = $this->_getParam('page') ? $this->_getParam('page') : 1;
$limit = 25;
$start = $limit * ($page - 1);
sleep(2);
$tblRelatedItem = new Pandamp_Modules_Dms_Catalog_Model_RelatedItem();
$rowset = $tblRelatedItem->fetchAll("relatedGuid='{$catalogGuid}' AND relateAs='RELATED_COMMENT'");
$relatedGuid = array();
foreach ($rowset as $related) {
$relatedGuid[] = $related->itemGuid;
}
if ($relatedGuid) {
$data = Pandamp_Lib_Formater::implode_with_keys(", ", $relatedGuid, "'");
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowset = $tblCatalog->fetchAll("guid in({$data}) AND status=99", '', $limit, $start);
$rowset1 = $tblCatalog->fetchAll("guid in({$data}) AND status=99");
$modelCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$decorator = new Pandamp_BeanContext_Decorator($modelCatalog);
$row = $decorator->getCatalogByGuidAsEntity($catalogGuid);
$st = $row->getShortTitle();
$num_rows = count($rowset1);
$numPage = ceil($num_rows / $limit);
$pagination = '';
for ($i = 1; $i <= $numPage; $i++) {
$pagination .= "<li><a href='/berita/baca/{$catalogGuid}/{$st}/p/{$i}' title='Halaman {$i}' rev='{$i}'>{$i}</a></li>";
}
// check is AJAX request or not
if (!$this->getRequest()->isXmlHttpRequest()) {
$this->view->pagination = $pagination;
}
$this->view->catalogGuid = $catalogGuid;
$this->view->numberOfRows = $num_rows;
$this->view->rows = $rowset;
$this->view->limit = $limit;
}
}
function _traverseFolderDowload($folderGuid, $sGuid, $level)
{
$tblFolder = new Pandamp_Modules_Dms_Folder_Model_Folder();
$rowSet = $tblFolder->fetchChildren($folderGuid);
$row = $tblFolder->find($folderGuid)->current();
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rows = $tblCatalog->downloadCatalog($row->guid);
if (count($rows)) {
foreach ($rows as $rowset) {
$tblCatalog = new Pandamp_Modules_Dms_Catalog_Model_Catalog();
$rowsetCatalog = $tblCatalog->find($rowset->itemGuid);
if (count($rowsetCatalog)) {
$rowCatalog = $rowsetCatalog->current();
$rowsetCatAtt = $rowCatalog->findDependentRowsetCatalogAttribute();
$contentType = $rowsetCatAtt->findByAttributeGuid('docMimeType')->value;
$filename = $systemname = $rowsetCatAtt->findByAttributeGuid('docSystemName')->value;
$oriName = $rowsetCatAtt->findByAttributeGuid('docOriginalName')->value;
$parentGuid = $rowset->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;
//$c = ROOT_DIR.'/data/download/file';
echo $parentGuid . '<br>';
// if(file_exists($sDir1))
// {
//header("Content-type: $contentType");
//header("Content-Disposition: attachment; filename=$oriName");
//@readfile($sDir2);
// exec('xcopy '.$sDir1.' d:\\www\holmp\data\download\file /e/i');
// }
// if(file_exists($sDir2))
// {
// exec('xcopy '.$sDir2.' d:\\www\holmp\data\download\file /e/i');
// }
}
}
}
}
