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