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