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 _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>";
}
}
}
