public function changecityAction()
{
$adsid = $_GET['adsid'];
$adstype = $_GET['adsType'];
$m = new PSys_AdsRule();
$citys = $m->getcitys();
$citysId = array();
foreach ($citys[allrow] as $c) {
if ($adstype == '5') {
$m->SetDb('db-rht_idc');
$m->SetTable("rhi_stationads");
if ($adstype == '5') {
$sql = 'SELECT id FROM rhi_stationads WHERE id=' . $c['id'] . ' and adsone LIKE "%' . $adsid . '%"';
$data = $m->Query($sql);
if ($data) {
array_push($citysId, $data[0]['id']);
}
}
}
if ($adstype == '6') {
$m->SetDb('db-rht_idc');
$m->SetTable("rhi_stationads");
if ($adstype == '6') {
$sql = 'SELECT id FROM rhi_stationads WHERE id=' . $c['id'] . ' and adstwo LIKE "%' . $adsid . '%"';
$data = $m->Query($sql);
if ($data) {
array_push($citysId, $data[0]['id']);
}
}
}
}
$citysId = implode(',', $citysId);
print_r($citysId);
}
/**
* 通过id获取车站全屏广告
* @param unknown $id */
public function getStationadsById($id)
{
$rule = new PSys_AdsRule();
return $rule->getStationadsById($id);
}
