public function getAd($array)
{
$tbl = new DB_Udo_Ad();
$list = [];
/* $result = $tbl->fetchAll();
print_r($result);*/
$AdModel = new AdModel();
//如果用户的地区和年级信息均有效
if ($array['province'] && $array['grade']) {
$list = $tbl->fetchAll("id,price,url", "where region_id={$array['province']} and " . $AdModel->getGradeClause($array['grade']) . " and flag = 1", "order by price asc");
}
if ($array['province'] && !$array['grade']) {
$list = $tbl->fetchAll("id,price,url", "where region_id={$array['province']} and flag = 1", "order by price asc");
}
if (!$array['province'] && $array['grade']) {
$list = $tbl->fetchAll("id,price,url", "where " . $AdModel->getGradeClause($array['grade']) . " and flag = 1", "order by price asc");
}
if (!$array['province'] && !$array['grade']) {
$list = $tbl->fetchAll("id,price,url", "where flag = 1", "order by price asc");
}
//如果没有筛选出符合用户条件的广告，那么将所有广告作为推送对象
if (!$list) {
$list = $tbl->fetchAll("id,price,url", "where flag = 1", "order by price asc");
}
return $list;
}
