private function _moveCategory($sourceCategoryId, $targetFolderGuid) { $sqlSource = "SELECT * from tblDms_CategoryTree, tblDms_Category where tblDms_Category.CategoryID={$sourceCategoryId} \n\t\t\t\t\t\tAND tblDms_CategoryTree.CategoryID=tblDms_Category.CategoryID"; $this->_dbSource->setFetchMode(Zend_Db::FETCH_OBJ); $row = $this->_dbSource->fetchRow($sqlSource); $tblFolder = new Kutu_Core_Orm_Table_Folder(); $rowsetFolder = $tblFolder->find($this->_guidPrefix . $row->CategoryID); if (count($rowsetFolder) <= 0) { //insert into KutuFolder $newFolder = $tblFolder->fetchNew(); $newFolder->guid = $this->_guidPrefix . $row->CategoryID; $newFolder->title = $row->CatTitle; $newFolder->description = $row->CatDescription; $newFolder->parentGuid = $targetFolderGuid; $rowsetFolder = $tblFolder->find($targetFolderGuid); if (count($rowsetFolder)) { $rowTarget = $rowsetFolder->current(); $newFolder->path = $rowTarget->path . $rowTarget->guid . '/'; } else { throw new Zend_Exception('NO RECORD FOR TARGET FOLDER'); } $newFolder->save(); // move and migrate its catalogs //$this->_migrateCatalogsInCategory($sourceCategoryId); } else { $newFolder = $rowsetFolder->current(); } // move and migrate its catalogs echo '<br>FOLDER: ' . $row->CatTitle . '</br>'; $this->_migrateCatalogsInCategory($sourceCategoryId); $sGuid = ''; // do index migrated catalogs in TARGET category $indexingEngine = Kutu_Search::manager(); try { $indexingEngine->reIndexCatalog('NORMAL', $newFolder->guid); } catch (Exception $e) { $sE = 'guid: ' . $newFolder->guid . '<br>'; echo $sE . $e->getMessage() . '<br> <br>'; } //print_r($row); }