重庆分公司,新征程启航
为企业提供网站建设、域名注册、服务器等服务
public function indexRecomHouse($area){ $where = array(); $where['a.isDel'] = '0'; $where['a.status'] = '2'; $where['a.auditstatus'] = '1';//已审核 $where['a.salestatus'] = '0';//在售 $where['a.isRecom'] = 'Y'; $order = "a.verifyTime desc"; $field = "a.esfId,c.shi,c.ting,c.chu,c.wei,a.price,a.buildingArea,b.fangAreaId,a.villageId,b.villageName"; $data = $this->table($this->tablePrefix."house as a")->join("left join ".$this->tablePrefix."village as b on a.villageId=b.villageId")->join("left join ".$this->tablePrefix."village_pic_hsize as c on a.hsizeId=c.picId")->where($where)->field($field)->order($order)->limit(15)->select(); if($data){ $areaDb = D("FangArea"); $housePicDb = D("HousePic"); $num=0; foreach($data as $key => $val){ $data[$key]['detailUrl'] = "http://esf.$area.qq.com/House1/detail?esfId=".$val['esfId']; $data[$key]['thumbUrl'] = $housePicDb->getThumb($val['esfId']); $data[$key]['areaName'] = $areaDb->getName($val['fangAreaId']); $data[$key]['zuhe'] = $val['shi']."室".($val['ting'] ? $val['ting']."厅" : "").($val['wei'] ? $val['wei']."卫" : ""); $a= explode('.', $val['buildingArea']); if($a[1]>0){ $data[$key]['buildingArea'] = $a[0].'.'.$a[1]; }else { $data[$key]['buildingArea'] = $a[0]; } $b= explode('.', $val['price']); if($b[1]>0){ $data[$key]['price'] = $b[0].'.'.$b[1]; }else { $data[$key]['price'] = $b[0]; } //处理3层数据结构,每组下面5条数据 if($key%5 !=0){ $arr[$num][]=$data[$key]; }else { $arr[$num+1][]=$data[$key]; $num +=1; } } } return $arr; }