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