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;
}
public function relateTo($relatedGuid, $as = 'RELATED_ITEM', $valRelation = 0)
{
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
if (empty($this->guid)) {
throw new Zend_Exception('Can not relate to empty GUID');
}
if (empty($relatedGuid)) {
throw new Zend_Exception('Can not relate to empty related GUID');
}
$rowsetRelatedItem = $tblRelatedItem->find($this->guid, $relatedGuid, $as);
if (count($rowsetRelatedItem) > 0) {
$row = $rowsetRelatedItem->current();
$row->valueIntRelation = $valRelation;
} else {
$row = $tblRelatedItem->createNew();
$row->itemGuid = $this->guid;
$row->relatedGuid = $relatedGuid;
$row->relateAs = $as;
$row->valueIntRelation = $valRelation;
}
$row->save();
}
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';
}
}
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 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");
}
}
}*/
}
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
}
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 delete($catalogGuid)
{
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$tblCatalog = new Kutu_Core_Orm_Table_Catalog();
$rowset = $tblCatalog->find($catalogGuid);
if (count($rowset)) {
$row = $rowset->current();
$profileGuid = $row->profileGuid;
if ($row->profileGuid == 'kutu_doc') {
$rowRelatedItem = $tblRelatedItem->fetchRow("itemGuid='{$row->guid}' AND relateAs='RELATED_FILE'");
}
$row->delete();
//if deleted catalog is kutu_doc then re-index its parentGuid
if ($profileGuid == 'kutu_doc') {
$indexingEngine = Kutu_Search::manager();
$indexingEngine->indexCatalog($rowRelatedItem->relatedGuid);
}
}
}
public function getsearchAction()
{
$this->_helper->layout()->disableLayout();
$r = $this->getRequest();
$query = $r->getParam('query') ? $r->getParam('query') : '';
$start = $r->getParam('start') ? $r->getParam('start') : 0;
$limit = $r->getParam('limit') ? $r->getParam('limit') : 20;
$orderBy = $r->getParam('orderBy') ? $r->getParam('sortBy') : 'regulationOrder';
$sortOrder = $r->getParam('sortOrder') ? $r->getParam('sortOrder') : ' asc';
$a = array();
$a['query'] = $query;
$indexingEngine = Kutu_Search::manager();
$hits = $indexingEngine->find($query, $start, $limit);
$num = $hits->response->numFound;
$solrNumFound = count($hits->response->docs);
$ii = 0;
if ($solrNumFound == 0) {
$a['catalogs'][0]['guid'] = 'XXX';
$a['catalogs'][0]['title'] = "No Data";
$a['catalogs'][0]['subTitle'] = "";
$a['catalogs'][0]['createdDate'] = '';
$a['catalogs'][0]['modifiedDate'] = '';
} else {
if ($solrNumFound > $limit) {
$numRowset = $limit;
} else {
$numRowset = $solrNumFound;
}
for ($ii = 0; $ii < $numRowset; $ii++) {
$row = $hits->response->docs[$ii];
if (!empty($row)) {
if ($row->profile == 'kutu_doc') {
$title = 'File : ' . $row->title;
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$rowset = $tblRelatedItem->fetchRow("itemGuid='{$row->id}'");
if ($rowset) {
$guid = $rowset->relatedGuid;
} else {
$guid = $row->id;
}
} else {
$title = $row->title;
$guid = $row->id;
}
$a['catalogs'][$ii]['title'] = $title;
$a['catalogs'][$ii]['guid'] = $guid;
if (!isset($row->subTitle)) {
$a['catalogs'][$ii]['subTitle'] = '';
} else {
$a['catalogs'][$ii]['subTitle'] = $row->subTitle;
}
if ($row->profile == 'kutu_doc') {
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$rowsetRelatedItem = $tblRelatedItem->fetchRow("itemGuid='{$row->id}' AND relateAs='RELATED_FILE'");
if ($rowsetRelatedItem) {
$parentGuid = $rowsetRelatedItem->relatedGuid;
} else {
$parentGuid = '';
}
} else {
$tblCatalogFolder = new Kutu_Core_Orm_Table_CatalogFolder();
$rowsetCatalogFolder = $tblCatalogFolder->fetchRow("catalogGuid='{$row->id}'");
if ($rowsetCatalogFolder) {
$parentGuid = $rowsetCatalogFolder->folderGuid;
} else {
$parentGuid = '';
}
}
$a['catalogs'][$ii]['folderGuid'] = $parentGuid;
$a['catalogs'][$ii]['createdDate'] = $row->createdDate;
$a['catalogs'][$ii]['modifiedDate'] = $row->modifiedDate;
}
}
}
echo Zend_Json::encode($a);
}
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;
}
private function _createDocs($sourceCatalogId, $guidPrefix = 'lgsimpfl')
{
// get all related documents
$tblCatalog = new Kutu_Core_Orm_Table_Catalog();
$tblCatalogAttribute = new Kutu_Core_Orm_Table_CatalogAttribute();
$tblRelatedItem = new Kutu_Core_Orm_Table_RelatedItem();
$this->_dbSource->setFetchMode(Zend_Db::FETCH_OBJ);
$rowsetDocItem = $this->_dbSource->fetchAll("SELECT * from tblDms_DocItem A \n\t\t\t\tWHERE A.CatalogID = {$sourceCatalogId}");
foreach ($rowsetDocItem as $rowDocItem) {
$rowsetCatalog = $tblCatalog->find($guidPrefix . $rowDocItem->DocItemID);
if (count($rowsetCatalog) == 0) {
$rowCatalog = $tblCatalog->fetchNew();
$rowCatalog->guid = $guidPrefix . $rowDocItem->DocItemID;
echo "KITI: " . $rowCatalog->guid;
$sFileAsli = str_replace(array('_', '.'), '-', $rowDocItem->DocFileAsli);
$rowCatalog->shortTitle = $sFileAsli;
$rowCatalog->profileGuid = "kutu_doc";
$rowCatalog->createdBy = $rowDocItem->DocCreator;
$rowCatalog->modifiedBy = $rowDocItem->DocModifier;
$rowCatalog->createdDate = $rowDocItem->DocCreated;
$rowCatalog->modifiedDate = $rowDocItem->DocModified;
$rowCatalog->save();
$rowExp = $this->_dbSource->fetchRow("Select * from tblDms_Exp_Seq where DocItemID={$rowDocItem->DocItemID} AND DocumentID={$rowDocItem->CatalogID}");
// untuk catalogAttributenya tambahan agar isinya fixedTitle,dsb itu
// fixedTitle
$rowCatalogAttribute = $tblCatalogAttribute->fetchNew();
$rowCatalogAttribute->catalogGuid = $guidPrefix . $rowDocItem->DocItemID;
$rowCatalogAttribute->attributeGuid = 'fixedTitle';
if (empty($rowExp->Friendlyname)) {
$rowCatalogAttribute->value = $rowDocItem->DocFileAsli;
} else {
$rowCatalogAttribute->value = $rowExp->Friendlyname;
}
$rowCatalogAttribute->save();
// fixedKeywords
$rowCatalogAttribute = $tblCatalogAttribute->fetchNew();
$rowCatalogAttribute->catalogGuid = $guidPrefix . $rowDocItem->DocItemID;
$rowCatalogAttribute->attributeGuid = 'fixedKeywords';
$rowCatalogAttribute->value = "";
$rowCatalogAttribute->save();
// fixedDescription
$rowCatalogAttribute = $tblCatalogAttribute->fetchNew();
$rowCatalogAttribute->catalogGuid = $guidPrefix . $rowDocItem->DocItemID;
$rowCatalogAttribute->attributeGuid = 'fixedDescription';
$rowCatalogAttribute->value = "";
$rowCatalogAttribute->save();
// fixedLanguage
$rowCatalogAttribute = $tblCatalogAttribute->fetchNew();
$rowCatalogAttribute->catalogGuid = $guidPrefix . $rowDocItem->DocItemID;
$rowCatalogAttribute->attributeGuid = 'fixedLanguage';
$rowCatalogAttribute->value = "en";
$rowCatalogAttribute->save();
// docCategoryGuid
$rowCatalogAttribute = $tblCatalogAttribute->fetchNew();
$rowCatalogAttribute->catalogGuid = $guidPrefix . $rowDocItem->DocItemID;
$rowCatalogAttribute->attributeGuid = 'docCategoryGuid';
$rowCatalogAttribute->value = "";
$rowCatalogAttribute->save();
// docSystemName
$rowCatalogAttribute = $tblCatalogAttribute->fetchNew();
$rowCatalogAttribute->catalogGuid = $guidPrefix . $rowDocItem->DocItemID;
$rowCatalogAttribute->attributeGuid = 'docSystemName';
$rowCatalogAttribute->value = $rowDocItem->DocFileName;
$rowCatalogAttribute->save();
// docOriginalName
$rowCatalogAttribute = $tblCatalogAttribute->fetchNew();
$rowCatalogAttribute->catalogGuid = $guidPrefix . $rowDocItem->DocItemID;
$rowCatalogAttribute->attributeGuid = 'docOriginalName';
$rowCatalogAttribute->value = $rowDocItem->DocFileAsli;
$rowCatalogAttribute->save();
// docSize
$rowCatalogAttribute = $tblCatalogAttribute->fetchNew();
$rowCatalogAttribute->catalogGuid = $guidPrefix . $rowDocItem->DocItemID;
$rowCatalogAttribute->attributeGuid = 'docSize';
$rowCatalogAttribute->value = $rowDocItem->DocSize;
$rowCatalogAttribute->save();
// docMimeType
$rowCatalogAttribute = $tblCatalogAttribute->fetchNew();
$rowCatalogAttribute->catalogGuid = $guidPrefix . $rowDocItem->DocItemID;
$rowCatalogAttribute->attributeGuid = 'docMimeType';
$rowCatalogAttribute->value = $rowDocItem->DocType;
$rowCatalogAttribute->save();
} else {
echo 'Data tidak disimpan';
}
// related the file/document as RELATED_FILE
$rowsetRelatedItem = $tblRelatedItem->find($guidPrefix . $rowDocItem->DocItemID, 'lgsimpdms' . $rowDocItem->CatalogID, "RELATED_FILE");
if (count($rowsetRelatedItem) == 0) {
$rowRelation = $tblRelatedItem->createNew();
$rowRelation->itemGuid = $guidPrefix . $rowDocItem->DocItemID;
$rowRelation->relatedGuid = 'lgsimpdms' . $rowDocItem->CatalogID;
$rowRelation->relateAs = "RELATED_FILE";
if (isset($rowExp->Sequence)) {
$rowRelation->valueIntRelation = $rowExp->Sequence;
}
$rowRelation->save();
//echo "<font color=blue>Record ke = ".$r." dari itemGuid = fl".$row->DocItemID." - ".$row->CatalogID." relasi file di-saved</font><br>";
}
}
}
