public function getdealer()
{
$sql = 'select jg.ID,jg.OrganName,TelPhone from `jpd_organ` jg,`jpd_user` ju';
$where = ' where jg.Identity=2 and jg.IsBlack="0" and jg.IsFreeze="0" and jg.Status="1"';
$where .= ' and jg.ID=ju.OrganID and ju.IsMain="1"';
//显示山东汽配联盟
$where .= ' and jg.UnionID=1';
$sqlcount = 'select count(*) from `jpd_organ` jg,`jpd_user` ju' . $where;
$count = Yii::app()->jpdb->createCommand($sqlcount)->queryScalar();
$sql .= $where . ' order by Sort asc';
$dealer = new CSqlDataProvider($sql, array('db' => Yii::app()->jpdb, 'totalItemCount' => $count, 'pagination' => array('pageSize' => $count)));
$datas = $dealer->getData();
$list = array();
foreach ($datas as $key => $val) {
$a = array();
$b = array();
$list[$key]['OrganName'] = $val['OrganName'];
$sql_brand = 'select a.BrandName from pap_brand as a,pap_dealer_brand as b where b.OrganID=' . $val['ID'] . ' and b.BrandID=a.ID';
$brand = Yii::app()->papdb->createCommand($sql_brand)->queryAll();
$brand_str = "";
foreach ($brand as $k => $v) {
if ($v['BrandName'] === null) {
continue;
}
$a[] = $v['BrandName'];
}
if ($a) {
$brand_str = implode(',', $a);
$list[$key]['brand'] = '<a title="' . $brand_str . '">' . $brand_str . '</a>';
} else {
$list[$key]['brand'] = '';
}
$vehicles = DealerVehicles::model()->findAll('OrganID=:organ', array(':organ' => $val['ID']));
$str = "";
foreach ($vehicles as $k => $v) {
$car = $v['Make'];
if ($v['Car']) {
$car .= ' ' . $v['Car'];
$car .= ' ' . '全年款';
} else {
$car .= ' ' . '全车系';
}
$b[] = $car;
}
if ($b) {
$str = implode(',', $b);
$list[$key]['vehicles'] = '<a title="' . $str . '">' . $str . '</a>';
} else {
$list[$key]['vehicles'] = '数据更新中...';
}
if ($val['TelPhone']) {
$phone = explode(',', $val['TelPhone']);
$list[$key]['TelPhone'] = $phone[0] . '<br>' . $phone[1];
} else {
$list[$key]['TelPhone'] = '暂无';
}
}
$dealer->setData($list);
return $dealer;
}
public function actionDetail()
{
//$model = Dealer::model()->find("userID=:userID", array(":userID" => $_GET['dealer']));
$organID = Yii::app()->request->getParam("dealer");
$model = Organ::model()->with('dealer')->findByPK($organID);
//主营品牌
$brands = Brand::model()->findAll("OrganID = {$organID}");
$data = array();
foreach ($brands as $key => $brand) {
$data[$key]['brandname'] = $brand['BrandName'];
}
//主营车系
$dealerv = DealerVehicles::model()->findAll("OrganID=:userID", array(":userID" => $organID));
//主营品类
$cpnames = OrganCpname::model()->findAll('OrganID=:userID', array(':userID' => $organID));
// 机构照片
$photosql = 'select * from `{{organ_photo}}` where OrganID=' . $organID;
$organphotos = Yii::app()->jpdb->createCommand($photosql)->queryAll();
$this->render("detail", array('model' => $model, 'organphotos' => $organphotos, 'dealerv' => $dealerv, 'showcpnames' => $cpnames, 'data' => $data));
}
public function actionIndex()
{
$type = Yii::app()->request->getParam('type');
$state = Yii::app()->request->getParam('State');
$city = Yii::app()->request->getParam('City');
$homeajax = Yii::app()->request->getParam('homeajax');
$pagesize = 12;
if ($state === '') {
$province = 'all';
} elseif ($state === null) {
$province = '370000';
} else {
$province = $state;
}
$brand = Yii::app()->request->getParam('brand');
$type = $type === null ? 1 : $type;
//1网格 2列表
//获得联盟id
$organID = Yii::app()->user->getOrganID();
$unionid = MallService::getUnioninfo($organID);
$unionid = $unionid ? $unionid : '-1';
//联盟商品
$dids = MallService::getUnionOrgan(array('UnionID' => $unionid, 'type' => 2));
$where = ' where Identity=2 and IsBlack="0" and IsFreeze="0" and Status="1"';
$where .= ' and ID in (' . $dids . ')';
if ($homeajax == 1) {
$province = 'all';
$pagesize = 6;
}
if ($province !== 'all') {
$where .= ' and Province=' . $province;
}
if ($city) {
$where .= ' and City=' . $city;
}
if (!empty($brand)) {
$ids = $this->getdealerbybrand($brand);
$where .= ' and ID in' . $ids;
}
if ($homeajax == 1) {
//工作台首页
$sql = ' select ID,OrganName,Logo from jpd_organ' . $where;
} else {
$sql = ' select * from jpd_organ' . $where;
}
$sqlcount = ' select count(*) from jpd_organ' . $where;
$count = Yii::app()->jpdb->createCommand($sqlcount)->queryScalar();
$sql .= ' order by Sort ASC ';
$dataProvider = new CSqlDataProvider($sql, array('db' => Yii::app()->jpdb, 'totalItemCount' => $count, 'pagination' => array('pageSize' => $pagesize)));
$organ = $dataProvider->getData();
if ($homeajax == 1) {
echo json_encode($organ);
die;
}
if ($organ) {
foreach ($organ as $key => $val) {
$a = array();
$b = array();
$organ[$key]['OrganName'] = '<a target="_black" href="' . Yii::app()->createUrl('servicer/servicedetail/detail', array('dealer' => $val['ID'])) . '">' . $val['OrganName'] . '</a>';
$brand = PapBrand::model()->findAll('OrganID=:organ', array(':organ' => $val['ID']));
$brand_str = "";
foreach ($brand as $k => $v) {
if ($v['BrandName'] === null) {
continue;
}
$a[] = $v['BrandName'];
}
if ($a) {
$brand_str = implode(',', $a);
$organ[$key]['brand'] = '<a title="' . $brand_str . '">' . $brand_str . '</a>';
$organ[$key]['firstbrand'] = '<a title="' . $brand_str . '">' . $a[0] . '</a>';
} else {
$organ[$key]['brand'] = '暂无';
$organ[$key]['firstbrand'] = '主营品牌:暂无';
}
$vehicles = DealerVehicles::model()->findAll('OrganID=:organ', array(':organ' => $val['ID']));
$str = "";
foreach ($vehicles as $k => $v) {
$car = $v['Make'];
if ($v['Car']) {
$car .= ' ' . $v['Car'];
if ($v['Year']) {
$car .= ' ' . $v['Year'];
if ($v['Model']) {
$car .= ' ' . $v['Model'];
} else {
$car .= ' ' . '全车型';
}
} else {
$car .= ' ' . '全年款';
}
} else {
$car .= ' ' . '全车系';
}
$b[] = $car;
}
if ($b) {
$str = implode('; ', $b);
//$organ[$key]['vehicles'] = '<a title="' . $str . '">' . $str . '</a>';
$organ[$key]['vehicles'] = $str;
} else {
$organ[$key]['vehicles'] = '暂无';
}
$organ[$key]['TelPhone'] = $organ[$key]['TelPhone'] ? $organ[$key]['TelPhone'] : '暂无';
}
}
$dataProvider->setData($organ);
$branddata = $this->getBrand($dids);
$get = $this->geturlparams($_GET);
$get['type'] = $type;
$pages = new CPagination($count);
$pages->pageSize = $pagesize;
$page = $pages->getCurrentPage() + 1;
$totalpage = $pages->getPageCount();
$start = 1 + ($page - 1) * $pagesize;
$end = $page < $totalpage ? $start + $pagesize - 1 : $count;
$footer = '<span class="zdyfooter">第 ' . $start . ' - ' . $end . ' 条, 共 ' . $count . ' 条.</span>';
$this->render('index', array('dataProvider' => $dataProvider, 'brand' => $branddata, 'get' => $get, 'type' => $type, 'province' => $province, 'city' => $city, 'pages' => $pages, 'footer' => $footer));
}
