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