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