public static function getinqlists($params)
{
$organID = Yii::app()->user->getOrganID();
$where = ' where a.Status!=3 and a.DealerID like "%,' . $organID . ',%"';
if ($params) {
$where .= self::inqsql($params);
}
$sql = 'select a.InquiryID,a.InquirySn,a.CreateTime,a.Status,a.OrganID,a.State' . ' from `pap_inquiry` a' . $where;
$sqlcount = 'select count(*) from `pap_inquiry` a' . $where;
$count = Yii::app()->papdb->createCommand($sqlcount)->queryScalar();
$sql .= ' order by InquiryID desc ';
$inqlists = new CSqlDataProvider($sql, array('db' => Yii::app()->papdb, 'totalItemCount' => $count, 'pagination' => array('pageSize' => 10)));
$datas = $inqlists->getData();
foreach ($datas as $k => $d) {
$status = self::checkstatus(array('inqid' => $d['InquiryID'], 'status' => $d['Status']));
$datas[$k]['sta'] = $status['status'];
$datas[$k]['stamsg'] = $status['msg'];
$datas[$k]['rowNO'] = $k + 1;
if ($d['State'] == 1) {
$datas[$k]['from'] = '客服代发';
} else {
$datas[$k]['from'] = '修理厂';
}
$datas[$k]['Info'] = "<a href='" . Yii::app()->createUrl('/pap/inquirylist/viewquo', array('inqid' => $d['InquiryID'])) . "' target='_blank'>询价单详情</a>";
}
$inqlists->setData($datas);
return $inqlists;
}
public function actionIndex()
{
$this->pageTitle = Yii::app()->name . '-' . "客户管理";
$page = Yii::app()->request->getParam('page') ? Yii::app()->request->getParam('page') : 1;
$pageSize = 15;
$sql = "select * from jpd_organ where Identity=3";
if ($_GET) {
$OrganName = Yii::app()->request->getParam('OrganName');
if ($OrganName) {
$sql .= " and OrganName like '%{$OrganName}%'";
}
$Phone = Yii::app()->request->getParam('Phone');
if ($Phone) {
$sql .= " and Phone like '%{$Phone}%'";
}
}
$sql .= " order by ID desc";
$count = Yii::app()->jpdb->createCommand(str_replace('*', 'count(*)', $sql))->queryScalar();
$data = new CSqlDataProvider($sql, array('totalItemCount' => $count, 'db' => Yii::app()->jpdb, 'pagination' => array('pageSize' => $pageSize)));
$datas = $data->getData();
foreach ($datas as $k => $v) {
$datas[$k]['rowNO'] = $k + 1 + ($page - 1) * $pageSize;
// $datas[$k]['OrganName']='<div title="'.$v['OrganName'].'">'.$v['OrganName'].'</div>';
}
$data->setData($datas);
$this->render('index', array('dataProvider' => $data, 'OrganName' => $OrganName, 'Phone' => $Phone));
}
public static function getlists($params)
{
$sql = 'select * from `jpd_logistics` ';
$sqlcount = 'select count(*) from `jpd_logistics` ';
$count = Yii::app()->jpdb->createCommand($sqlcount)->queryScalar();
$sql .= ' order by ID desc ';
$lists = new CSqlDataProvider($sql, array('db' => Yii::app()->jpdb, 'totalItemCount' => $count, 'pagination' => array('pageSize' => 5)));
$datas = $lists->getData();
foreach ($datas as $k => $data) {
$datas[$k]['area'] = self::getlogarea($data['ID']);
}
$lists->setData($datas);
return $lists;
}
public static function getServiceData($params)
{
$OrganID = Yii::app()->user->getOrganID();
$sql = "SELECT jsp.RecordID, jsr.CreateTime, jsr.Mileage \n FROM jpd_support_parts AS jsp, jpd_support_record AS jsr \n WHERE jsp.RecordID = jsr.ID AND jsr.OrganID = '{$OrganID}' AND jsr.CarID = '{$params['CarID']}' AND jsr.Status = 0\n GROUP BY jsp.RecordID ORDER BY jsr.CreateTime DESC";
$countsql = "SELECT COUNT(*) FROM (" . $sql . ") as tab";
//echo $sql;die;
$count = Yii::app()->jpdb->createCommand($countsql)->queryScalar();
$dataProvider = new CSqlDataProvider($sql, array('db' => Yii::app()->jpdb, 'totalItemCount' => $count, 'pagination' => array('pageSize' => 5)));
$data = $dataProvider->getData();
//var_dump($data);die;
foreach ($data as $key => $val) {
$data[$key]['partsinfo'] = self::getServiceDataByServiceID($val['RecordID']);
}
$dataProvider->setData($data);
return $dataProvider;
}
public static function getReturn($params)
{
$select = "ID,ReturnNO,CreateTime,PayMethod,ServiceID,Price";
$seaCon = self::getReturnCond($params, $select);
$pageSize = $params['pageSize'] ? $params['pageSize'] : 20;
// $page = $params['page'] ? $params['page'] : 1;
$count = Yii::app()->papdb->createCommand(str_replace($select, 'count(ID)', $seaCon))->queryScalar();
$data = new CSqlDataProvider($seaCon, array('totalItemCount' => $count, 'db' => Yii::app()->papdb, 'pagination' => array('pageSize' => $pageSize)));
$datas = $data->getData();
foreach ($datas as $k => $v) {
//$datas[$k]['rowNO'] = $k + 1 + ($page - 1) * $pageSize;
$datas[$k]['CreateTime'] = date('Y-m-d H:i:s', $v['CreateTime']);
$datas[$k]['PayMethod'] = $v['PayMethod'] == 0 ? '支付宝担保' : '物流代收款';
$datas[$k]['BuyerName'] = "<p class='eval_organ'>" . Organ::model()->findByPk($v['ServiceID'])->attributes['OrganName'] . "</p>";
}
$data->setData($datas);
return $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));
}
public static function getSellOrderList($params)
{
$page = $params['page'] ? $params['page'] : 1;
$pageSize = $params['pageSize'] ? $params['pageSize'] : 3;
$seaCon = self::getOrderCond($params);
$count = Yii::app()->papdb->createCommand(str_replace('t.*', 'count(*)', $seaCon))->queryScalar();
$data = new CSqlDataProvider($seaCon, array('totalItemCount' => $count, 'db' => Yii::app()->papdb, 'pagination' => array('pageSize' => $pageSize)));
$datas = $data->getData();
$i = 0;
$total = 0;
foreach ($datas as $k => $v) {
$datas[$k]['rowNO'] = $k + 1 + ($page - 1) * $pageSize;
$datas[$k]['Info'] = "<a href='" . Yii::app()->createUrl('/pap/sellerorder/detail', array('ID' => $v['ID'])) . "'>订单详情</a>";
if (!$v['BuyerName']) {
$datas[$k]['BuyerName'] = Organ::model()->findByPk($v['BuyerID'], array('select' => 'OrganName'))->attributes['OrganName'];
}
$i++;
$total += $v['RealPrice'];
}
// var_dump($datas);die;
$data->setData($datas);
return array('dataProvider' => $data, 'count' => $i, 'total' => $total);
}
public static function getauditreturn()
{
$organID = Yii::app()->user->getOrganID();
$returnsql = "select * from pap_return_order where Status=1 and DealerID = '" . $organID . "' ORDER BY CreateTime DESC";
$data = new CSqlDataProvider($returnsql, array('db' => Yii::app()->papdb, 'pagination' => array('pageSize' => 10)));
//pap/dealerreturn/audit/ID/134
$datas = $data->getData();
foreach ($datas as $k => $v) {
$datas[$k]['rowNO'] = $k + 1;
$datas[$k]['Info'] = "<a href='" . Yii::app()->createUrl('/pap/dealerreturn/audit', array('ID' => $v['ID'])) . "' target='_blank'>退货单详情</a>";
}
$data->setData($datas);
return $data;
}
public static function getschemelists($params)
{
if ($params['quoid']) {
$organID = Yii::app()->user->getOrganID();
if ($params['type'] == 1) {
$quosql = 'select * from pap_quotation where InquiryID=0 and (Status="1" or Status="3") and QuoID=' . $params['quoid'] . ' and DealerID=' . $organID;
} elseif ($params['type'] == 2) {
$quosql = 'select * from pap_quotation where InquiryID=0 and QuoID=' . $params['quoid'] . ' and DealerID=' . $organID;
} elseif ($params['type'] == 3) {
$quosql = 'select * from pap_quotation where InquiryID!=0 and (Status="1" or Status="3") and QuoID=' . $params['quoid'] . ' and DealerID=' . $organID;
} elseif ($params['type'] == 4) {
$quosql = 'select * from pap_quotation where InquiryID!=0 and QuoID=' . $params['quoid'] . ' and DealerID=' . $organID;
} elseif ($params['type'] == 5) {
$quosql = 'select * from pap_quotation where QuoID=' . $params['quoid'] . ' and ServiceID=' . $params['sid'];
} elseif ($params['type'] == 6) {
$quosql = 'select * from pap_quotation where QuoID=' . $params['quoid'] . ' and ServiceID=' . $params['sid'];
}
$quoinfo = Yii::app()->papdb->createCommand($quosql)->queryRow();
if (!$quoinfo) {
Controller::redirect(Yii::app()->createUrl('pap/quotation/index'));
}
$schsql = 'select * from pap_quotation_scheme where QuoID=' . $params['quoid'];
$schlists = Yii::app()->papdb->createCommand($schsql)->queryAll();
$schinfo = array();
foreach ($schlists as $key => $list) {
$schinfo[$key] = $list;
$quogoodssql = 'select ID as QuogoodsID,GoodsID,Num,Price,Version from pap_quotation_goods where SchID=' . $list['SchID'];
$countsql = 'select count(*) from pap_quotation_goods where SchID=' . $list['SchID'];
$total = Yii::app()->papdb->createCommand($countsql)->queryScalar();
$goodslists = new CSqlDataProvider($quogoodssql, array('db' => Yii::app()->papdb, 'pagination' => array('pageSize' => $total)));
$datas = $goodslists->getData();
foreach ($datas as $k => $data) {
$goodsinfo = self::getgoodsinfobyid($data['GoodsID'], $data['Version'], $data['QuogoodsID']);
$datas[$k]['rowNo'] = '<span issell="' . $goodsinfo['IsPro'] . '" goodsid="' . $data['GoodsID'] . '">' . ($k + 1) . '<span>';
$datas[$k] = array_merge($goodsinfo, $datas[$k]);
$datas[$k]['totalprices'] = sprintf("%.2f", $data['Price'] * $data['Num']);
if (($params['type'] === 5 || $params['type'] === 6) && $quoinfo['Status'] === '1') {
$datas[$k]['selected'] = '<input type="checkbox" name="selectgoods" checked=true goodsid="' . $data['GoodsID'] . '" price="' . $data['Price'] . '">';
$htmlnum = '<a class="s" onclick="numsub(' . $data['GoodsID'] . ',this)" href="javascript:void(0)"></a>' . '<input class="input input5 width40 float_l" style="width:30px;margin-top:2px;height:20px;line-height:20px" type="text" name="num" onblur="numblur(' . $data['GoodsID'] . ',this);" onkeyup="numkeyup(' . $data['GoodsID'] . ',this)" value="' . $data['Num'] . '">' . '<a class="a" onclick="numadd(' . $data['GoodsID'] . ',this)" href="javascript:void(0)"></a>';
$datas[$k]['Num'] = $htmlnum;
}
}
$goodslists->setData($datas);
$schinfo[$key]['goodsinfo'] = $goodslists;
}
return array('schinfo' => $schinfo, 'quoinfo' => $quoinfo);
}
}
public static function getPurchaseData($params)
{
//var_dump($params);die;
$OrganID = Yii::app()->user->getOrganID();
$sql = "SELECT prp.ReserveID, prp.CreateTime, jsr.LicensePlate, prp.InOrder, jsr.ReserveNum\n\t\t \tFROM pap_reserve_purchase as prp,jpd.jpd_service_reserve as jsr\n\t\t WHERE prp.ReserveID = jsr.ID AND prp.OrganID = '{$OrganID}' ";
if ($params['LicensePlate']) {
$sql .= "AND LicensePlate LIKE '%{$params['LicensePlate']}%' ";
}
if ($params['CreateTime']) {
$sql .= "AND prp.CreateTime = unix_timestamp('{$params['CreateTime']}') ";
}
if ($params['ReserveNum']) {
$sql .= "AND jsr.ReserveNum = '{$params['ReserveNum']}' ";
}
if ($params['InOrder'] == 2) {
$sql .= "AND InOrder = 0 ";
} elseif ($params['InOrder'] == 3) {
$sql .= "AND InOrder = 1 ";
}
$sql .= "group by prp.ReserveID, prp.InOrder, prp.CreateTime order by prp.ID desc";
$countsql = "SELECT COUNT(*) FROM (" . $sql . ") as tab";
//echo $sql;die;
$count = Yii::app()->papdb->createCommand($countsql)->queryScalar();
$dataProvider = new CSqlDataProvider($sql, array('db' => Yii::app()->papdb, 'totalItemCount' => $count, 'pagination' => array('pageSize' => 5)));
$data = $dataProvider->getData();
//var_dump($data);die;
foreach ($data as $key => $val) {
$arr = self::getPurchaseDataByReserveID($val['ReserveID'], $val['InOrder'], $val['CreateTime']);
$data[$key]['goodsinfo'] = $arr['data'];
$data[$key]['RealPrice'] = $arr['RealPrice'];
}
$dataProvider->setData($data);
return $dataProvider;
}
public static function getGoodsDataold($params)
{
$sql = self::getGoodsSql($params);
if ($params['SellerID'] && $params['IsSale'] == 0) {
$sql["countSql"] = str_replace('dg.IsSale=1', 'dg.IsSale=0', $sql["countSql"]);
$sql["sql"] = str_replace('dg.IsSale=1', 'dg.IsSale=0', $sql["sql"]);
}
$res = Yii::app()->papdb->createCommand($sql["countSql"])->queryAll();
$count = $res[0]['count'];
// echo $sql["sql"];
// exit;
$dataProvider = new CSqlDataProvider($sql["sql"], array('db' => Yii::app()->papdb, 'totalItemCount' => $count, 'pagination' => array('pageSize' => $params['rows'] ? $params['rows'] : 10)));
$goods = $dataProvider->getData();
foreach ($goods as $k => $v) {
$image = self::getOneGoodsImage($v['ID']);
if (!$image) {
$goods[$k]['image'] = F::uploadUrl() . 'common/default-goods.png';
} else {
$goods[$k]['image'] = F::uploadUrl() . $image;
}
$MallImage = self::getOneGoodsImagethumb($v['ID']);
if (!$MallImage) {
$goods[$k]['MallImage'] = F::uploadUrl() . 'common/default-goods.png';
} else {
$goods[$k]['MallImage'] = F::uploadUrl() . self::getOneGoodsImagethumb($v['ID']);
}
//获取标准名称
if ($v['StandCode']) {
$goods[$k]['cpname'] = Gcategory::model()->find(array('select' => 'Name', 'condition' => "Code = '{$v['StandCode']}'"))->attributes['Name'];
}
//卖家信息
$goods[$k]['dealername'] = Organ::model()->findByPk($v['OrganID'], array('select' => 'OrganName'))->attributes['OrganName'];
if (!$params["resource"] || $params["resource"] != "mall") {
//OE号
$goods[$k]['OENOS'] = self::getOENOSByGoodsID($v['ID']);
// 车型车系
//$carmodel = explode('、', self::getVehicleByGoodsID($v['ID']));
//$goods[$k]['vehicle'] = $carmodel[0];
//$goods[$k]['vehicle'] = self::getOneVehicleByGoodsID($v['ID']);
}
}
$dataProvider->setData($goods);
return array('dataProvider' => $dataProvider, 'count' => $count);
}
public static function getServiceEval($params)
{
$pageSize = $params['pageSize'] ? $params['pageSize'] : 3;
$starttime = $params['starttime'];
$endtime = $params['endtime'];
$OrganID = $params['OrganID'] ? $params['OrganID'] : Yii::app()->user->getOrganID();
$select = " GROUP_CONCAT(JudgeID) as JudgeID,GROUP_CONCAT(Score)as Score,CreateTime,Message,Recier,OrganID";
$seaCon = "select {$select} from `pap_evaluation_organ` t";
if ($params['type'] == 'dealer') {
$seaCon .= " where t.OrganID = {$OrganID} and t.Identity=3";
} else {
$seaCon .= " where t.Recier = {$OrganID} and t.Identity=3";
}
//下单时间
if ($starttime && $endtime) {
$seaCon .= " and t.CreateTime > {$starttime} and t.CreateTime < {$endtime}+3600*24";
} else {
if ($starttime) {
$seaCon .= " and t.CreateTime > {$starttime}";
} else {
if ($endtime) {
$seaCon .= " and t.CreateTime < {$endtime}+3600*24";
}
}
}
if (!empty($params['search_text'])) {
$search_text = self::checkKey(urldecode($params['search_text']));
$idstr = self::getOrgan($search_text);
if ($params['type'] == 'dealer') {
$seaCon .= " and t.Recier in {$idstr}";
} else {
$seaCon .= " and t.OrganID in {$idstr}";
}
}
$count = Yii::app()->papdb->createCommand(str_replace($select, 'count(distinct OrderID)', $seaCon))->queryScalar();
$seaCon .= " group by t.OrderID";
$seaCon .= " order by t.CreateTime DESC";
$data = new CSqlDataProvider($seaCon, array('totalItemCount' => $count, 'db' => Yii::app()->papdb, 'pagination' => array('pageSize' => $pageSize)));
$judgeitem = self::getevainfo(3);
$datas = $data->getData();
foreach ($datas as $k => $v) {
$items = explode(',', $v['JudgeID']);
$score = explode(',', $v['Score']);
$itemscore = array();
foreach ($items as $m => $n) {
$itemscore[$n] = $score[$m];
}
ksort($itemscore);
$datas[$k]['evalItem'] = '';
$datas[$k]['evalScore'] = '';
foreach ($itemscore as $kk => $vv) {
if ($judgeitem[$kk]) {
$datas[$k]['evalItem'] .= "<p style='padding-left:20px;text-align:right'>" . $judgeitem[$kk] . "</p>";
if ($vv == 1) {
$datas[$k]['evalScore'] .= '<p>好评</p>';
} else {
if ($vv == 0) {
$datas[$k]['evalScore'] .= '<p>中评</p>';
} else {
if ($vv == -1) {
$datas[$k]['evalScore'] .= '<p>差评</p>';
}
}
}
}
}
$datas[$k]['evalItem'] .= "<p> <p>";
$datas[$k]['evalScore'] .= "<p style='color:#888'>[" . date('Y-m-d H:i:s', $v['CreateTime']) . "]</p>";
$datas[$k]['Message'] = "<p style='width:250px;word-break:break-all;padding-left:20px'>{$v['Message']}</p>";
}
$data->setData($datas);
return array('data' => $data, 'count' => $count);
}
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;
}
