public static function querydealer()
{
$cri = new CDbCriteria();
$cri->addCondition('Identity=2');
$cri->addCondition("IsBlack='0'");
$cri->addCondition("IsFreeze='0'");
$cri->addCondition("Status='1'");
//获得联盟id
$organID = Yii::app()->user->getOrganID();
$unionid = MallService::getUnioninfo($organID);
$unionid = $unionid ? $unionid : '-1';
//联盟商品
$dids = MallService::getUnionOrgan(array('UnionID' => $unionid, 'type' => 2));
$cri->addCondition('ID in (' . $dids . ')');
$cri->order = 'Sort ASC';
$dealer = Organ::model()->findAll($cri);
$deal_info = array();
if ($dealer) {
foreach ($dealer as $key => $val) {
//将机构图片换成LOGO 修改时间2014-09-03 修改人：邓家文
//$img=JpdOrganPhoto::model()->find('OrganID=:organ',array(':organ'=>$val['ID']));
$deal_info[$key]['ID'] = $val['ID'];
$deal_info[$key]['OrganName'] = $val['OrganName'];
$deal_info[$key]['Phone'] = $val['Phone'];
if (!isset($val['Logo']) && empty($val['Logo'])) {
$val['Logo'] = 'common/default-goods.png';
}
$deal_info[$key]['imgpath'] = $val['Logo'];
}
}
return $deal_info;
}
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));
}
