magento sql 用法

最新推荐文章于 2021-03-22 15:48:37 发布

jonas

最新推荐文章于 2021-03-22 15:48:37 发布

阅读量3.7k

点赞数 2

分类专栏： mysql magento调试 magento点滴文章标签： magento sql image zend date

本文链接：https://blog.csdn.net/shangxiaoxue/article/details/7640523

版权

magento点滴同时被 3 个专栏收录

35 篇文章 0 订阅

订阅专栏

magento调试

8 篇文章 0 订阅

订阅专栏

mysql

2 篇文章 0 订阅

订阅专栏

		$resource = Mage::getSingleton('core/resource');
		$tableName_votes = $resource->getTableName('jselfless/votes');
		$tableName_image = $resource->getTableName('jselfless/image');
		$collection = Mage::getModel('jselfless/woman')->getCollection();
		$collection->getSelect()->reset(Zend_Db_Select::COLUMNS);
		$collection->getSelect()->columns(array('items_count'=>'count(main_table.id)'));  
		$collection->addFieldToFilter('main_table.year',date('Y'));
		$collection->addFieldToFilter('image.type','main');
		$collection->addFieldToFilter('award',array('eq'=>''));
		$collection->getSelect()->join(array('votes' => $tableName_votes), 'main_table.id = votes.selfless_woman_id', '');
		$collection->getSelect()->join(array('image' => $tableName_image), 'main_table.id = image.selfless_woman_id', array('image.*'));
		$collection->getSelect()->group('main_table.id');
		$collection->getSelect()->Order('items_count  desc');
		$collection->getSelect()->Order('votes.created_at  desc');  
		$collection->getSelect()->Order('main_table.updated_at  desc'); 
		$collection->getSelect()->limit(10,$postData['offset']);

一些常用的用法，记录一下；