Example #1
0
 private function getMinPriceByHotGoods()
 {
     $model = new Model('goods as g');
     $table_goods = $model->getTableName("goods");
     $table_prom_goods = $model->getTableName("prom_goods");
     $tableNameStr = $table_goods . " AS g," . $table_prom_goods . " AS p";
     $queryFeilds = "MIN(g.sell_price) AS minprice ,MIN(g.prom_id) AS promid ,p.end_time AS endtime";
     $queryWhere = "is_online = 0 AND store_nums > 0 AND g.prom_id = p.id AND p.start_time <= NOW() AND p.end_time >= NOW()";
     $groupFeilds = "prom_id";
     $this->assign('minprice', $model->customQuery($tableNameStr, $queryFeilds, $queryWhere, $groupFeilds, null, null, null));
 }