public function documentAction()
{
$r = $this->getRequest();
$guid = $r->getParam('g');
$this->view->catalogGuid = $guid;
Zend_Loader::loadClass('Kutu_Core_Orm_Table_RelatedItem');
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$where = "relatedGuid='{$guid}' AND relateAs='RELATED_FILE'";
$rowsetRelatedItem = $tblRelatedItem->fetchAll($where);
$this->view->rowsetRelatedItem = $rowsetRelatedItem;
}
protected function _postDelete()
{
//find related docs and delete them
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$rowsetRelatedDocs = $tblRelatedItem->fetchAll("relatedGuid='{$this->guid}' AND relateAs='RELATED_FILE'");
if (count($rowsetRelatedDocs)) {
foreach ($rowsetRelatedDocs as $rowRelatedDoc) {
$tblCatalog = new Kutu_Core_Orm_Table_Catalog();
$rowCatalog = $tblCatalog->find($rowRelatedDoc->itemGuid)->current();
$rowCatalog->delete();
}
}
if ($this->profileGuid == 'kutu_doc') {
//get parentGuid
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$rowsetRelatedItem = $tblRelatedItem->fetchAll("itemGuid='{$this->guid}' AND relateAs='RELATED_FILE'");
if (count($rowsetRelatedItem)) {
foreach ($rowsetRelatedItem as $rowRelatedItem) {
//must delete the physical files
$rowsetCatAtt = $this->findDependentRowsetCatalogAttribute();
$systemname = $rowsetCatAtt->findByAttributeGuid('docSystemName')->value;
$parentGuid = $rowRelatedItem->relatedGuid;
$sDir1 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $systemname;
$sDir2 = KUTU_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 Kutu_Core_Orm_Table_CatalogAttribute();
$tblCatalogAttribute->delete("catalogGuid='{$this->guid}'");
//delete catalogGuid from table CatalogFolder
$tblCatalogFolder = new Kutu_Core_Orm_Table_CatalogFolder();
$tblCatalogFolder->delete("catalogGuid='{$this->guid}'");
//delete guid from table AssetSetting
$tblAssetSetting = new Kutu_Core_Orm_Table_AssetSetting();
$tblAssetSetting->delete("guid='{$this->guid}'");
//delete from table relatedItem
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$tblRelatedItem->delete("itemGuid='{$this->guid}'");
$tblRelatedItem->delete("relatedGuid='{$this->guid}'");
//delete physical catalog folder from uploads/files/[catalogGuid]
$sDir = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $this->guid;
try {
if (is_dir($sDir)) {
rmdir($sDir);
}
} catch (Exception $e) {
}
//delete from index
try {
$indexingEngine = Kutu_Search::manager();
$indexingEngine->deleteCatalogFromIndex($this->guid);
} catch (Exception $e) {
}
//delete from ACL
}
private function _extractText_ZendDb($guid, $systemName, $fileName, $mimeType)
{
//$c = $this->_registry->get('config');
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$rowset = $tblRelatedItem->fetchAll("itemGuid='{$guid}' AND relateAs='RELATED_FILE'");
if (count($rowset)) {
$row = $rowset->current();
$parentCatalogGuid = $row->relatedGuid;
if (!empty($systemName)) {
$fileName = $systemName;
}
$sDir1 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $fileName;
$sDir2 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $parentCatalogGuid . DIRECTORY_SEPARATOR . $fileName;
$sDir = '';
if (file_exists($sDir1)) {
$sDir = $sDir1;
} else {
if (file_exists($sDir2)) {
$sDir = $sDir2;
}
}
if (!empty($sDir)) {
$outpath = $sDir . '.txt';
switch ($mimeType) {
case 'application/pdf':
$pdfExtractor = $this->_pdfExtractor;
system("{$pdfExtractor} " . $sDir . ' ' . $outpath, $ret);
if ($ret == 0) {
$value = file_get_contents($outpath);
unlink($outpath);
//echo 'content PDF: '. $sDir.' ' . strlen($value);
if (strlen($value) > 20) {
return $this->clean_string_input($value);
} else {
//echo 'content file kosong';
return '';
}
}
if ($ret == 127) {
//print "Could not find pdftotext tool.";
return '';
}
if ($ret == 1) {
//print "Could not find pdf file.";
return '';
}
break;
case 'text/html':
case 'text/plain':
$docHtml = Zend_Search_Lucene_Document_Html::loadHTMLFile($sDir);
return $docHtml->getFieldValue('body');
break;
case 'application/x-javascript':
case 'application/octet-stream':
case 'application/msword':
if (strpos(strtolower($fileName), '.doc')) {
$extractor = $this->_wordExtractor;
system("{$extractor} -m cp850.txt " . $sDir . ' > ' . $outpath, $ret);
if ($ret == 0) {
$value = file_get_contents($outpath);
unlink($outpath);
//echo $value;
return $value;
}
if ($ret == 127) {
//print "Could not find pdftotext tool.";
return '';
}
if ($ret == 1) {
//print "Could not find pdf file.";
return '';
}
} else {
return '';
}
break;
default:
return '';
break;
}
}
}
return '';
}
public function sampleAction()
{
$req = $this->getRequest();
//$this->view->message = "We detected that you don't have yet access to this resource. If you believe you have one, please contact our support. Thank you.";
$catalogGuid = $req->getParam('guid');
$tblCatalog = new Kutu_Core_Orm_Table_Catalog();
$rowsetCatalog = $tblCatalog->find($catalogGuid);
$this->_helper->layout()->disableLayout();
if (count($rowsetCatalog)) {
$rowCatalog = $rowsetCatalog->current();
$rowsetCatAtt = $rowCatalog->findDependentRowsetCatalogAttribute();
$contentType = $rowsetCatAtt->findByAttributeGuid('docMimeType')->value;
$systemname = $rowsetCatAtt->findByAttributeGuid('docSystemName')->value;
$filename = $rowsetCatAtt->findByAttributeGuid('docOriginalName')->value;
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$rowsetRelatedItem = $tblRelatedItem->fetchAll("itemGuid='{$catalogGuid}' AND relateAs='RELATED_FILE'");
$flagFileFound = false;
foreach ($rowsetRelatedItem as $rowRelatedItem) {
if (!$flagFileFound) {
$parentGuid = $rowRelatedItem->relatedGuid;
$sDir1 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $systemname;
$sDir2 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $parentGuid . DIRECTORY_SEPARATOR . $systemname;
if (file_exists($sDir1)) {
$flagFileFound = true;
if (trim($contentType) == 'application/pdf') {
$this->_generatePdfSamplePage($sDir1);
} else {
echo 'NO SAMPLE PAGE';
}
} else {
if (file_exists($sDir2)) {
$flagFileFound = true;
if (trim($contentType) == 'application/pdf') {
$this->_generatePdfSamplePage($sDir2);
} else {
echo 'NO SAMPLE PAGE';
}
} else {
echo 'No FILE';
$flagFileFound = false;
}
}
}
}
} else {
echo 'NO FILE';
}
}
public function addTranslation($itemGuid, $relatedGuid)
{
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
//check apakah relatedGuid adalah seorang parent atau child
$rowsetRelatedItem = $tblRelatedItem->fetchAll("relatedGuid='{$relatedGuid}' AND relateAs='RELATED_TRANSLATION'");
if (count($rowsetRelatedItem)) {
//do nothing
}
$rowsetRelatedItem = $tblRelatedItem->fetchAll("itemGuid='{$relatedGuid}' AND relateAs='RELATED_TRANSLATION'");
if (count($rowsetRelatedItem)) {
$relatedGuid = $rowsetRelatedItem->current()->relatedGuid;
}
//check if $itemGuid adalah parent atau child
$rowsetRelatedItem = $tblRelatedItem->fetchAll("relatedGuid='{$itemGuid}' AND relateAs='RELATED_TRANSLATION'");
if (count($rowsetRelatedItem)) {
//check apakah sudah ada
$rs1 = $tblRelatedItem->find($this->itemGuid, $relatedGuid, "RELATED_TRANSLATION");
if (count($rs1)) {
} else {
$tblCatalog = new Kutu_Core_Orm_Table_Catalog();
$rowset = $tblCatalog->find($itemGuid);
if (count($rowset)) {
$row = $rowset->current();
$row->relateTo($relatedGuid, "RELATED_TRANSLATION");
}
}
//get all children and set its current relatedGuid to the new relatedGuid
foreach ($rowsetRelatedItem as $row) {
$row->relatedGuid = $relatedGuid;
$row->save();
}
} else {
//check apakah itemGuid adalah child
$rs1 = $tblRelatedItem->fetchAll("itemGuid='{$itemGuid}' AND relateAs='RELATED_TRANSLATION'");
if (count($rs1)) {
//update bapaknya dan anak dari bapaknya
$tblCatalog = new Kutu_Core_Orm_Table_Catalog();
$rowset = $tblCatalog->find($rs1->current()->relatedGuid);
if (count($rowset)) {
$row = $rowset->current();
$row->relateTo($relatedGuid, "RELATED_TRANSLATION");
}
$bapak = $rs1->current()->relatedGuid;
$rs2 = $tblRelatedItem->fetchAll("relatedGuid='{$bapak}' AND relateAs='RELATED_TRANSLATION'");
if (count($rs2)) {
foreach ($rs2 as $row) {
$row->relatedGuid = $relatedGuid;
$row->save();
}
}
}
}
/*$rowsetRelatedItem = $tblRelatedItem->find($this->itemGuid, $relatedGuid, "RELATED_TRANSLATION");
if(count($rowsetRelatedItem))
{
}
else
{
$rowsetRelatedItem = $tblRelatedItem->find($relatedGuid, $this->itemGuid, "RELATED_TRANSLATION");
if(count($rowsetRelatedItem))
{
}
else
{
$tblCatalog = new Kutu_Core_Orm_Table_Catalog();
$rowset = $tblCatalog->find($itemGuid);
if(count($rowset))
{
$row = $rowset->current();
$row->relateTo($relatedGuid, "RELATED_TRANSLATION");
}
}
}*/
}
protected function _postDelete()
{
//find related docs and delete them
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$rowsetRelatedDocs = $tblRelatedItem->fetchAll("relatedGuid='{$this->guid}' AND relateAs='RELATED_FILE'");
if (count($rowsetRelatedDocs)) {
foreach ($rowsetRelatedDocs as $rowRelatedDoc) {
$tblCatalog = new Kutu_Core_Orm_Table_Catalog();
$rowCatalog = $tblCatalog->find($rowRelatedDoc->itemGuid)->current();
$rowCatalog->delete();
}
}
if ($this->profileGuid == 'kutu_doc') {
//get parentGuid
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$rowsetRelatedItem = $tblRelatedItem->fetchAll("itemGuid='{$this->guid}' AND relateAs='RELATED_FILE'");
if (count($rowsetRelatedItem)) {
foreach ($rowsetRelatedItem as $rowRelatedItem) {
//must delete the physical files
$rowsetCatAtt = $this->findDependentRowsetCatalogAttribute();
$systemname = $rowsetCatAtt->findByAttributeGuid('docSystemName')->value;
$parentGuid = $rowRelatedItem->relatedGuid;
$sDir1 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $systemname;
$sDir2 = KUTU_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 Kutu_Core_Orm_Table_CatalogAttribute();
$tblCatalogAttribute->delete("catalogGuid='{$this->guid}'");
//delete catalogGuid from table CatalogFolder
$tblCatalogFolder = new Kutu_Core_Orm_Table_CatalogFolder();
$tblCatalogFolder->delete("catalogGuid='{$this->guid}'");
//delete guid from table AssetSetting
$tblAssetSetting = new Kutu_Core_Orm_Table_AssetSetting();
$tblAssetSetting->delete("guid='{$this->guid}'");
//delete from table relatedItem
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$tblRelatedItem->delete("itemGuid='{$this->guid}'");
$tblRelatedItem->delete("relatedGuid='{$this->guid}'");
//delete from lucene index
//check if guid exist in index, then delete
// $indexEngine = new Kutu_Search_Index_Engine();
// $indexEngine->deleteCatalogFromIndex($this->guid);
$registry = Zend_Registry::getInstance();
$conf = $registry->get('config');
$indexingEngine = Kutu_Search::manager();
try {
$hits = $indexingEngine->deleteCatalogFromIndex($this->guid);
} catch (Exception $e) {
}
/*
$tblTmpIndex = new Kutu_Core_Orm_Table_TmpIndex();
$rowTmpIndex = $tblTmpIndex->fetchNew();
$rowTmpIndex->catalogGuid = $this->guid;
$rowTmpIndex->status = 'delete';
$rowTmpIndex->save();
*/
$tblTmpIndex = new Kutu_Core_Orm_Table_TmpIndex();
$tblTmpIndex->delete("catalogGuid='{$this->guid}'");
//delete physical catalog folder from uploads/files/[catalogGuid]
$sDir = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $this->guid;
try {
if (is_dir($sDir)) {
rmdir($sDir);
}
} catch (Exception $e) {
}
$sDir = KUTU_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) {
}
//delete from ACL
}
function _traverseHistory($catalogGuid, $aData)
{
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$sGuid = '';
$where = "relatedGuid='{$catalogGuid}' AND relateAs='RELATED_HISTORY'";
$rowsetRelatedItem = $tblRelatedItem->fetchAll($where);
foreach ($rowsetRelatedItem as $rowRelatedItem) {
if (!isset($aData[$catalogGuid]['right'])) {
//echo 'right: '.$rowRelatedItem->itemGuid . '|';
$sGuid .= $catalogGuid . '|';
$aData[$catalogGuid]['right'] = $catalogGuid;
$sGuid .= $this->_traverseHistory($rowRelatedItem->itemGuid, $aData) . '|';
}
}
$where2 = "itemGuid='{$catalogGuid}' AND relateAs='RELATED_HISTORY'";
$rowsetRelatedItem = $tblRelatedItem->fetchAll($where2);
foreach ($rowsetRelatedItem as $rowRelatedItem) {
if (!isset($aData[$catalogGuid]['left'])) {
//echo 'left: '.$rowRelatedItem->relatedGuid . '|';
$sGuid .= $catalogGuid . '|';
$aData[$catalogGuid]['left]'] = $catalogGuid;
$sGuid .= $this->_traverseHistory($rowRelatedItem->relatedGuid, $aData) . '|';
}
}
return $sGuid;
}
public function downloadAction()
{
$this->_helper->layout()->disableLayout();
//$this->view->addHelperPath(KUTU_ROOT_DIR.'/mix_lib/Kutu/View/Helper', 'Kutu_View_Helper');
$req = $this->getRequest();
$catalogGuid = $req->getParam('guid');
$tblCatalog = new Kutu_Core_Orm_Table_Catalog();
$rowsetCatalog = $tblCatalog->find($catalogGuid);
if (count($rowsetCatalog)) {
$rowCatalog = $rowsetCatalog->current();
$rowsetCatAtt = $rowCatalog->findDependentRowsetCatalogAttribute();
$contentType = $rowsetCatAtt->findByAttributeGuid('docMimeType')->value;
$systemname = $rowsetCatAtt->findByAttributeGuid('docSystemName')->value;
$filename = $rowsetCatAtt->findByAttributeGuid('docOriginalName')->value;
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$rowsetRelatedItem = $tblRelatedItem->fetchAll("itemGuid='{$catalogGuid}' AND relateAs='RELATED_FILE'");
$flagFileFound = false;
foreach ($rowsetRelatedItem as $rowRelatedItem) {
if (!$flagFileFound) {
$parentGuid = $rowRelatedItem->relatedGuid;
$sDir1 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $systemname;
$sDir2 = KUTU_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={$filename}");
@readfile($sDir2);
} else {
echo 'No FILE';
$flagFileFound = false;
}
}
}
}
} else {
echo 'NO FILE';
}
}
public function jCartIsItemSellable($catalogGuid)
{
//apakah pernah dibeli
$auth = Zend_Auth::getInstance();
$hasBought = false;
if ($auth->hasIdentity()) {
$bpm = new Kutu_Core_Bpm_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 Kutu_Core_Orm_Table_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 Kutu_Core_Orm_Table_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 Kutu_Core_Orm_Table_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 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $systemname;
$sDir2 = KUTU_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 downloadFileAction()
{
$catalogGuid = $this->_getParam('guid');
$parentGuid = $this->_getParam('parent');
$tblCatalog = new Kutu_Core_Orm_Table_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 = $oname = $rowsetCatAtt->findByAttributeGuid('docOriginalName')->value;
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$rowsetRelatedItem = $tblRelatedItem->fetchAll("itemGuid='{$catalogGuid}' AND relateAs='RELATED_FILE'");
$flagFileFound = false;
foreach ($rowsetRelatedItem as $rowRelatedItem) {
if (!$flagFileFound) {
$parentGuid = $rowRelatedItem->relatedGuid;
$sDir1 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $systemname;
$sDir2 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $parentGuid . DIRECTORY_SEPARATOR . $systemname;
$sDir3 = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . $oname;
$sDir4 = KUTU_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');
}
}
}
} else {
$flagFileFound = false;
$this->_forward('forbidden', 'browser');
}
}
public function otherAction()
{
$catalogGuid = $this->_getParam('guid') ? $this->_getParam('guid') : '';
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$where = "relatedGuid='{$catalogGuid}' AND relateAs='RELATED_OTHER'";
$rowsetRelatedItem = $tblRelatedItem->fetchAll($where);
$this->view->rowsetRelatedItem = $rowsetRelatedItem;
}
