publicfunctionindexRecomHouse($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.verifyTimedesc";$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."houseasa")->join("leftjoin".$this->tablePrefix."villageasbona.villageId=b.villageId")->join("leftjoin".$this->tablePrefix."village_pic_hsizeascona.hsizeId=c.picId")->where($where)->field($field)->order($order)->limit(15)->select();if($data){$areaDb=D("FangArea");$housePicDb=D("HousePic");$num=0;foreach($dataas$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;}