示例#1
0
 /**
  * Fetches best sale product ids
  * 
  * @param integer $qty Minimal quantity for a product to be considered as a best sale
  * @param integer $limit
  * @return array
  */
 public function fetchBestSales($qty, $limit)
 {
     return $this->db->select(array(sprintf('%s.%s', OrderProductMapper::getTableName(), 'product_id') => 'id'), true)->from(OrderProductMapper::getTableName())->innerJoin(OrderInfoMapper::getTableName())->whereEquals(sprintf('%s.%s', OrderInfoMapper::getTableName(), 'id'), new RawSqlFragment(sprintf('%s.%s', OrderProductMapper::getTableName(), 'order_id')))->andWhereEquals(sprintf('%s.%s', OrderInfoMapper::getTableName(), 'approved'), new RawSqlFragment("'1'"))->groupBy('id')->having('SUM', sprintf('%s.%s', OrderProductMapper::getTableName(), 'qty'), '>=', $qty)->limit($limit)->queryAll('id');
 }
示例#2
0
文件: Dropper.php 项目: bono-cms/Shop
 /**
  * {@inheritDoc}
  */
 protected function getTables()
 {
     return array(CategoryMapper::getTableName(), ImageMapper::getTableName(), OrderInfoMapper::getTableName(), OrderProductMapper::getTableName(), ProductMapper::getTableName(), ProductMapper::getJunctionTableName());
 }