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