public function actionMysql()
{
$db = Yii::app()->db;
$query = "select guid from KutuCatalog where profileGuid='article' order by createdDate DESC limit 360, 10";
$query2 = "select guid from KutuCatalog, KutuCatalogFolder where KutuCatalog.guid=KutuCatalogFolder.catalogGuid AND KutuCatalogFolder.folderGuid='15' order by createdDate DESC limit 62, 10";
$command = $db->createCommand($query);
$dataReader = $command->query();
$rows = $dataReader->readAll();
//var_dump($rows);
foreach ($rows as $catalog) {
//$i++;
$tmpGuid = $catalog['guid'];
//$command=$db->createCommand("select t1.value title, t2.value subTitle, t3.value description, t4.value content from ((select * from KutuCatalogAttribute where catalogGuid='$tmpGuid' and attributeGuid='fixedTitle') as t1) LEFT JOIN ((select * from KutuCatalogAttribute where catalogGuid='$tmpGuid' and attributeGuid='fixedSubTitle') as t2) ON t1.catalogGuid=t2.catalogGuid LEFT JOIN ((select * from KutuCatalogAttribute where catalogGuid='$tmpGuid' and attributeGuid='fixedDescription') as t3) ON t2.catalogGuid=t3.catalogGuid LEFT JOIN ((select * from KutuCatalogAttribute where catalogGuid='$tmpGuid' and attributeGuid='fixedContent') as t4) ON t3.catalogGuid=t4.catalogGuid");
//$row=$command->queryRow();
//file_put_contents(Yii::app()->basePath . '/data/'.$tmpGuid.'.row', serialize($row));
Yii::import('application.extensions.mp.cms.*');
$catalogManager = new MPCatalogManager();
$row = $catalogManager->getCatalogDetails($tmpGuid);
echo $row['fixedTitle'] . '<br>';
}
$query = "select guid from KutuCatalog, KutuCatalogFolder where KutuCatalog.guid=KutuCatalogFolder.catalogGuid AND KutuCatalogFolder.folderGuid='15' order by createdDate DESC limit 52, 10";
$command = $db->createCommand($query);
$dataReader = $command->query();
$rows = $dataReader->readAll();
//var_dump($rows);
foreach ($rows as $catalog) {
//$i++;
$tmpGuid = $catalog['guid'];
//$command=$db->createCommand("select t1.value title, t2.value subTitle, t3.value description, t4.value content from ((select * from KutuCatalogAttribute where catalogGuid='$tmpGuid' and attributeGuid='fixedTitle') as t1) LEFT JOIN ((select * from KutuCatalogAttribute where catalogGuid='$tmpGuid' and attributeGuid='fixedSubTitle') as t2) ON t1.catalogGuid=t2.catalogGuid LEFT JOIN ((select * from KutuCatalogAttribute where catalogGuid='$tmpGuid' and attributeGuid='fixedDescription') as t3) ON t2.catalogGuid=t3.catalogGuid LEFT JOIN ((select * from KutuCatalogAttribute where catalogGuid='$tmpGuid' and attributeGuid='fixedContent') as t4) ON t3.catalogGuid=t4.catalogGuid");
//$row=$command->queryRow();
//file_put_contents(Yii::app()->basePath . '/data/'.$tmpGuid.'.row', serialize($row));
Yii::import('application.extensions.mp.cms.*');
$catalogManager = new MPCatalogManager();
$row = $catalogManager->getCatalogDetails($tmpGuid);
echo $row['fixedTitle'] . '<br>';
}
$query = "select guid from KutuCatalog, KutuCatalogFolder where KutuCatalog.guid=KutuCatalogFolder.catalogGuid AND KutuCatalogFolder.folderGuid='12' order by createdDate DESC limit 2, 10";
$command = $db->createCommand($query);
$dataReader = $command->query();
$rows = $dataReader->readAll();
//var_dump($rows);
foreach ($rows as $catalog) {
//$i++;
$tmpGuid = $catalog['guid'];
//$command=$db->createCommand("select t1.value title, t2.value subTitle, t3.value description, t4.value content from ((select * from KutuCatalogAttribute where catalogGuid='$tmpGuid' and attributeGuid='fixedTitle') as t1) LEFT JOIN ((select * from KutuCatalogAttribute where catalogGuid='$tmpGuid' and attributeGuid='fixedSubTitle') as t2) ON t1.catalogGuid=t2.catalogGuid LEFT JOIN ((select * from KutuCatalogAttribute where catalogGuid='$tmpGuid' and attributeGuid='fixedDescription') as t3) ON t2.catalogGuid=t3.catalogGuid LEFT JOIN ((select * from KutuCatalogAttribute where catalogGuid='$tmpGuid' and attributeGuid='fixedContent') as t4) ON t3.catalogGuid=t4.catalogGuid");
//$row=$command->queryRow();
//file_put_contents(Yii::app()->basePath . '/data/'.$tmpGuid.'.row', serialize($row));
Yii::import('application.extensions.mp.cms.*');
$catalogManager = new MPCatalogManager();
$row = $catalogManager->getCatalogDetails($tmpGuid);
echo $row['fixedTitle'] . '<br>';
}
$this->render('mongodb');
}
public function actionUpdate()
{
$model = $this->_loadModel('4ba441778ead0e8f3e000000');
$form = new CForm($this->_buildForm(), $model);
if ($form->submitted('save') && $form->validate()) {
$model->attributes = $_POST['CatalogForm'];
//insert Catalog
Yii::import('application.extensions.mp.*');
$manager = new MPCatalogManager();
$manager->updateCatalog($model->attributes);
//model->attributes['folders'] should be change to array
//model->attributes['tags'] should be change to array
//var_dump($model->attributes);
die('sukses');
} else {
$this->render('update', array('form' => $form));
}
}
