1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
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 ;
                                         }