pfhwyigou/frontend/server/HouseServer.php

<?php
/**
 * Created by PhpStorm.
 * User: xiaofeng
 * Date: 2018/4/20
 * Time: 下午3:21
 */

namespace frontend\server;

use common\fm\HouseHandle;
use common\fm\Opencc;
use common\models\CategoryCity;
use common\models\House;
use common\models\News;
use common\models\HouseNumber;
use common\models\Search;
use common\models\Video;
use Yii;
use common\models\HouseAlbum;
use common\models\Characteristic;
use common\models\HouseType;
use common\models\HouseFacilities;
use common\models\HouseNews;
use common\models\CategoryLabel;
use common\models\PushHousesale;
use common\models\HousePermit;
use common\models\HousePriceRecord;
use common\models\HouseComment;
use common\models\HouseCommentLikes;
use common\models\HouseCommentreply;

class HouseServer
{

    /*
     * 搜索楼盘名字
     * */
    public function SearchHouseName($input)
    {
        if (!empty($input['title'])) {
            (new Search())->SaveSearchPC($input['title']);
            $query = new House();
            $arr = (new \common\api\HouseServer())->HouseNameConvert($input['title']);

            if (!empty($arr['pinyin'])) {
                $query->pinyin = $arr['pinyin'];
            }
            if (!empty($arr['zhongwen'])) {
                $query->name = $arr['zhongwen'];
            }
            $result = $query->HouseName();
            return $result;
        }
    }

    public function Search($input)
    {
		
        $query = new House();
        //搜索条件
        if (!empty($input['zhuti']) && $input['zhuti'] != 0) {
            $query->characteristic = $input['zhuti'];
        }

        if (!empty($input['price']) && $input['price'] != 0) {
            $query->price = $input['price'];
        }

        if (!empty($input['type']) && $input['type'] != 0) {
            $query->type = $input['type'];
        }

//        if(!empty($input['pricesort']) && $input['pricesort'] != 0)
//        {
//            $query->pricesort = $input['pricesort'];
//        }

        if (!empty($input['pinyin'])) {
            $query->pinyin = $input['pinyin'];
        } else {
            if (!empty($input['name'])) {
                $query->name = $input['name'];
            }
        }

        //VR看房
        if (!empty($input['vrread']) && $input['vrread'] != 0) {
            $idList = array_column((new \common\models\Vr())->getColumnHid(), 'hid');
            $query->id = $idList;
        }
        if (!empty($input['city']) && $input['city'] != 0) {
            $query->city = $input['city'];
        }

        //处理价格区间
        if (!empty($query->price)) {
            $price = \common\models\HousesPrice::find();
            $priceModel = $price->andWhere(['id' => $query->price])->one();
            if ($priceModel != null) {
                $query->price = $priceModel->price;
            }
        }

        //户型
        if (!empty($query->type)) {
            $type = new \common\models\HouseType();
            $type->type_id = $query->type;
            $typeModel = $type->getList(['hid']);
            if (!empty($typeModel)) {
                $query->id = array_unique(array_column($typeModel, 'hid'));
            } else {
                $query->id = 0;  //处理 ID没有的情况下，不查询该条件
            }


        }

//        if (!empty($input['name'])) {
//            $arr = (new \common\api\HouseServer())->HouseNameConvert($input['name']);
//            if (!empty($arr['pinyin'])) {
//                $query->pinyin = $arr['pinyin'];
//            }
//            if (!empty($arr['zhongwen'])) {
//                $query->name = $arr['zhongwen'];
//            }
//            $query->city = '';
//        }

        $data = $query->QgetList(['pfg_house_detail.video_url', 'pfg_house_detail.preferential', 'pfg_house_detail.panorama', 'pfg_house.is_tel', 'pfg_house.area', 'pfg_category_city.city_name', 'pfg_house.id', 'pfg_house.city', 'pfg_house.price', 'pfg_house.name', 'pfg_house_detail.address', 'pfg_house_detail.main_units', 'pfg_house_detail.price_unit', 'pfg_house.thumb', 'pfg_house.sale_price', 'pfg_house.characteristic', 'pfg_house_detail.longitude_latitude'], $input);

        if ($data['data'] != null) {
            foreach ($data['data'] as &$val) {

                $val['characteristic'] = \common\fm\HouseHandle::ChangeCharacteristic($val['characteristic']);

                $val['citytel'] = \common\fm\HouseHandle::ChangeCityTel($val['city']);

                if (empty($val['is_tel'])) {
                    if (!empty($val['area']) && \common\fm\HouseHandle::ChangeCityTel($val['area']) != Yii::$app->params['default_dialtel']) {

                        $val['citytel'] = \common\fm\HouseHandle::ChangeCityTel($val['area']);
                    } else {
                        $val['citytel'] = \common\fm\HouseHandle::ChangeCityTel($val['city']);
                    }

                } else {
                    $val['citytel'] = $val['is_tel'];
                }

                //查询是否单独设置楼盘号码
                if (!empty(HouseNumber::SearchNumber($val['id']))) {
                    $val['citytel'] = HouseNumber::SearchNumber($val['id']);
                }

                //                if(empty($val['is_tel']))
//                {
//                    $val['citytel'] = \common\fm\HouseHandle::ChangeCityTel($val['city']);
//
//                }
//                else
//                {
//                    $val['citytel'] = $val['is_tel'];
//                }
//                $val['video'] = $this->Video($val['id']);
            }
            return $data;
        }
    }

    public function Details()
    {
        $input = Yii::$app->request->get();
        $arr = [];
        $seo = [];
        $seo['province'] = '海南省';
        $model = new House();
        $model->id = $input['hid'];
        $select = ['pfg_house.*', 'pfg_house_detail.*', 'pfg_category_city.city_name', 'pfg_category_city.pid as city_pid'];
        $arr['house'] = $model->Qdetails($select);
        if (empty($arr['house'])) return false;

        //楼盘点击量
        $click = new \common\api\HouseServer();
        $click->HouseClick($input['hid']);

        if (!empty($arr['house'])) {
            $seo['city'] = $arr['house']['city_name'];
            if (!empty($arr['house']['city_pid'])) {
                $cityModel = new CategoryCity();
                $city = $cityModel->FindById($arr['house']['city_pid']);
                $seo['province'] = $city['city_name'];
            }

            $arr['seo'] = $seo;
            $arr['characteristic'] = $this->Subject(json_decode($arr['house']['characteristic']), 3);

            $queryAlbum = new HouseAlbum();

            $arr['album'] = $queryAlbum->AlbumGroup(['hid' => $input['hid']]);

            $arr['album_find'] = $queryAlbum->Groupfind(['hid' => $input['hid']]);

            //直播视频
            $arr['house']['live'] = (new \common\models\Live())->GetOneLiveByHouse($input['hid']);

            $perModel = new HousePermit();
            $perModel->hid = $input['hid'];
            $arr['permit'] = $perModel->FindNewest();

            //户型图
            $queryType = new HouseType();
            $queryType->hid = $input['hid'];
            $arr['type'] = $queryType->RandList(['area', 'indoor_info', 'title', 'type_id', 'img','hid'], 4);

            //户型分类
            $arr['type_grouy'] = $queryType->TypeGroup();

            if (empty($arr['house']['is_tel'])) {
                //新增三级联动区域的电话获取修改
                if (!empty($arr['house']['area']) && $this->RandTel($arr['house']['area']) != Yii::$app->params['default_dialtel']) {
                    $arr['house']['tel'] = $this->RandTel($arr['house']['area']);
                } else {
                    $arr['house']['tel'] = $this->RandTel($arr['house']['city']);
                }
            } else {
                $arr['house']['tel'] = $arr['house']['is_tel'];
            }

            $arr['house']['state'] = Yii::$app->params['HouseSalesStatus'][$arr['house']['state']];

            $arr['news'] = (new News())->getHouseNews($arr['house']['name'], 2);

            //建筑类别
            $architecture_type = new CategoryLabel();
            $architecture_type->type = 2;
            $arr['architecture_type'] = array_column($architecture_type->getList([], ['id', 'name']), 'name', 'id');
            $arr['house']['architecture_type'] = json_decode($arr['house']['architecture_type'], true);

            $vr3d = $this->Vr3d($arr['house']['id']);
            $vrcount = \common\models\Vr::find()->where(['hid' => $arr['house']['id'], 'state' => 1, 'type' => 1])->count();
            if(!empty($arr['house']['panorama'])){
                $vrcount += 1;
            }
            if($vrcount > 0){
                array_unshift($arr['type_grouy'], ['huxing_name' => 'VR看房', 'num' => $vrcount, 'hid' => $arr['house']['id'], 'type_id' => 'vr']);
            }

            if (!empty($vr3d)) {
                $arr['house']['panorama'] = $vr3d['path'];
                $arr['house']['panorama_img'] = $vr3d['img'];
            } else {
                if ($arr['house']['panorama_img']) {
                    $arr['house']['panorama_img'] = Yii::$app->params['httpImg']['hosts'] . Yii::$app->params['httpImg']['house_video'] . $arr['house']['panorama_img'] . '/same';
                } else {
                    $arr['house']['panorama_img'] = Yii::$app->params['httpImg']['hosts'] . Yii::$app->params['httpImg']['houses'] . $arr['house']['thumb'] . '/same';
                }
            }

            if (!empty($arr['house']['video_url'])) {
                if (!empty($arr['house']['video_img'])) {
                    $arr['house']['video_img'] = Yii::$app->params['httpImg']['hosts'] . Yii::$app->params['httpImg']['house_video'] . $arr['house']['video_img'] . '/same';
                } else {
                    $arr['house']['video_img'] = Yii::$app->params['httpImg']['hosts'] . Yii::$app->params['httpImg']['houses'] . $arr['house']['thumb'] . '/same';
                }
            }

        } else {
            return false;
        }
        return $arr;
    }

    public function Vr3d($hid)
    {
        $data = \common\models\Vr::find()->where(['hid' => $hid, 'state' => 1, 'type' => 1])->select(['img', 'name', 'path'])->orderBy(['sort' => SORT_DESC])->asArray()->one();
        if (!empty($data)) {
            $data['img'] = Yii::$app->params['httpImg']['host'] . Yii::$app->params['httpImg']['video'] . $data['img'];
        }
        return $data;
    }

    public function NewsDynamic($input)
    {
        $model = new HouseNews();
        $model->hid = $input['hid'];
        $houseNewsInfo = $model->getHidList();
        $nids = array_column($houseNewsInfo, 'nid');
        $newsModel = new News();
        $newsModel->hid = $input['hid'];
        $result = $newsModel->getNewsListHouse($nids, 2);
        if ($result != null) {
            return $result;
        }
    }

    public function GetInput($input)
    {
        $Arr = [];
        $Arr['title'] = $input['name'];
        $Arr['ip'] = Yii::$app->request->userIP;
        return $Arr;
    }


    //Video楼盘视频
    public function Video($Id)
    {
        $data = Video::find()->select(['video_url', 'thumb'])
            ->andWhere(['del' => 1])->andWhere(['state' => 1])->andWhere(['hid' => $Id])
            ->orderBy(['create_at' => SORT_DESC])->asArray()->one();

        return $data;
    }

    /****Live楼盘直播视频****/
    public function GetLiveInfo($hid)
    {
        $data = \common\models\Live::find()
            ->select('id,hid,video_url,img')
            ->andWhere(['hid' => $hid])
            ->asArray()->one();
        return $data;
    }

    //楼盘详情页数据
    public function ParamsDetails()
    {
        $input = Yii::$app->request->get();
        if (is_numeric($input['hid'])) {
            $result = [];
            $model = new House();
            $model->id = $input['hid'];
            $result['house'] = $model->HousesAll();


            $result['house']['characteristic'] = \common\fm\HouseHandle::ChangeCharacteristic($result['house']['characteristic']);
//                $this->Subject(json_decode($result['house']['characteristic']),4);
            if (empty($result['house']['is_tel'])) {
                if (!empty($result['house']['area']) && HouseHandle::ChangeCityTel($result['house']['area']) != Yii::$app->params['default_dialtel']) {
                    $result['house']['tel'] = \common\fm\HouseHandle::ChangeCityTel($result['house']['area']);
                } else {
                    $result['house']['tel'] = \common\fm\HouseHandle::ChangeCityTel($result['house']['city']);
                }


            } else {
                $result['house']['tel'] = $result['house']['is_tel'];
            }

            //查询是否单独设置楼盘号码
            if (!empty(HouseNumber::SearchNumber($result['house']['id']))) {
                $result['house']['tel'] = HouseNumber::SearchNumber($result['house']['id']);
            }

            $result['house']['architecture_type'] = $this->ArchitectureType(json_decode($result['house']['architecture_type']), 2);

            //预售证号
            $zheng = new HousePermit();
            $result['house']['zhengshu'] = $zheng->getList($input);

            //价格历史
            $price = new HousePriceRecord();
            $price->hid = $input['hid'];
            $result['house']['price_record'] = $price->getList([]);

            $peitao = new HouseFacilities();
            $peitao->hid = $input['hid'];
            $pei = $peitao->InfoList();
            if (!empty($pei)) {
                $peiArr = [];
                foreach ($pei as $key => $val) {
                    $peiArr[$val['name']]['name'][] = $val['pname'];
                }
                $result['peitao'] = $peiArr;
            }
            return $result;
        }
    }

    //获取楼盘相册逻辑
    public function Album()
    {
        $input = Yii::$app->request->get();
        $queryAlbum = new  HouseAlbum();
        $arr['album'] = $queryAlbum->AlbumGroup(['hid' => $input['hid']]);
        foreach ($arr['album'] as $key => $val) {
            $arr['data'][$val['album_id']] = $queryAlbum::find()->andWhere(['album_id' => $val['album_id']])->andWhere(['hid' => $input['hid']])->andWhere(['del' => 1])->orderBy(['sort' => SORT_DESC, 'id' => SORT_DESC])->limit(3)->asArray()->all();
            $arr['album_id'][$val['album_id']] = $val['name'];
        }
        return $arr;
    }

    //获取楼盘相册信息
    public function AlbumType()
    {
        $input = Yii::$app->request->get();
        $queryAlbum = new  HouseAlbum();

        $arr['album'] = $queryAlbum->AlbumGroup(['hid' => $input['hid']]);
        $queryAlbum->hid = $input['hid'];
        $queryAlbum->album_id = Yii::$app->request->get('album_id', $arr['album'][0]['album_id']);
        $arr['data'] = $queryAlbum->getList();

        if (!empty($arr['data'])) {
            foreach ($arr['data'] as &$val) {
                $val['img'] = Yii::$app->params['httpImg']['hosts'] . Yii::$app->params['httpImg']['housealbums'] . $val['img'] . Yii::$app->params['pfgwatermark'];
            }
        }
        $arr['selectalbumtype'] = Yii::$app->request->get('album_id', $arr['album'][0]['album_id']);
        return $arr;
    }

    //获取楼盘分类的所有相册信息
    public function AlbumAll()
    {
        $input = Yii::$app->request->post();
        $queryAlbum = new  HouseAlbum();
        $queryAlbum->hid = $input['hid'];
        $queryAlbum->album_id = $input['album_id'];
        $rows = $queryAlbum->getList();
        if ($rows != null) {
            foreach ($rows as &$val) {
                $val['img'] = Yii::$app->params['httpImg']['hosts'] . Yii::$app->params['httpImg']['housealbums'] . $val['img'] . Yii::$app->params['pfgwatermark'];
            }
            return $rows;
        }

    }

    /*相册获取*/
    public function GetAlbumAll($input)
    {
        $queryAlbum = new  HouseAlbum();
        $queryAlbum->hid = $input['hid'];
        $queryAlbum->album_id = $input['album_id'];
        $rows = $queryAlbum->getList();
        if ($rows != null) {
            foreach ($rows as &$val) {
                $val['img'] = Yii::$app->params['httpImg']['hosts'] . Yii::$app->params['httpImg']['housealbums'] . $val['img'] . Yii::$app->params['pfgwatermark'];
            }
            return $rows;
        }

    }

    //楼盘户型分组
    public function Type()
    {
        $input = Yii::$app->request->get();
        $typeModel = new HouseType();
        $typeModel->hid = $input['hid'];
        $groupType = $typeModel->TypeGroup();

        $vrcount = \common\models\Vr::find()->where(['hid' => $input['hid'], 'state' => 1, 'type' => 1])->count();
        $houseModel = new House();
        $houseModel->id = $input['hid'];
        $house720 = $houseModel->HousesAll();
        if(!empty($house720['panorama'])){
            $vrcount+=1;
        }
        if($vrcount > 0 || !empty($house720['panorama'])){
            array_unshift($groupType, ['huxing_name' => 'VR看房', 'num' => $vrcount, 'hid' => $input['hid'], 'type_id' => 'vr']);
        }

        return $groupType;
    }
	
	/**
	 * 楼盘户型数据
	 * @param $input
	 * @param bool $tr
	 * @return mixed
	 */
	public function TypeAll($input, $tr = true)
	{
		if ($input['type_id'] == 'vr') {
			$input['type_id'] = '';
			$list = (new \common\models\Vr())->getListAndVr($input);
			$houseModel = new House();
			$houseModel->id = $input['hid'];
			$house720 = $houseModel->HousesAll();
			if(!empty($house720['panorama'])){
				array_unshift($list, ['title' => '720VR全景看房', 'area' => '全景','indoor_info'=>'全景', 'hid' => $input['hid'], 'type_id' => 'vr','panorama'=>$house720['panorama'],'panorama_img'=>$house720['panorama_img'],'thumb'=>$house720['thumb']]);
			}
		}elseif($input['type_id'] == 'all'){
			$typeModel = new HouseType();
			$typeModel->hid = $input['hid'];
			//            $typeModel->type_id = $input['type_id'];
			if ($tr == true) {
				$list = $typeModel->QgetList(4);
			} else {
				$list = $typeModel->getList();
			}
			$input['type_id'] = '';
			$list_vr = (new \common\models\Vr())->getListAndVr($input);
			
			$houseModel = new House();
			$houseModel->id = $input['hid'];
			$house720 = $houseModel->HousesAll();
			
			if(!empty($house720['panorama'])){
				array_unshift($list_vr, ['title' => '720VR全景看房', 'area' => '全景','indoor_info'=>'全景', 'hid' => $input['hid'], 'type_id' => 'vr','panorama'=>$house720['panorama'],'panorama_img'=>$house720['panorama_img'],'thumb'=>$house720['thumb']]);
			}
			$list = array_merge($list_vr,$list);
		}else{
			$typeModel = new HouseType();
			$typeModel->hid = $input['hid'];
			$typeModel->type_id = $input['type_id'];
			if ($tr == true) {
				$list = $typeModel->QgetList(4);
			} else {
				$list = $typeModel->getList();
			}
		}
		if ($list != null) {
			foreach ($list as &$val) {
				$val['title'] = Opencc::Convert($val['title']);
				$val['area'] = Opencc::Convert($val['area']);
				$val['indoor_info'] = Opencc::Convert($val['indoor_info']);
				if (!empty($val['path'])) {
					$val['img'] = Yii::$app->params['httpImg']['host'] . Yii::$app->params['httpImg']['video'] . $val['img'];
					$val['type_id'] = 'vr';
				} elseif(!empty($val['panorama'])){
					if ($val['panorama_img']) {
						$val['img'] = Yii::$app->params['httpImg']['hosts'] . Yii::$app->params['httpImg']['house_video'] . $val['panorama_img'] . '/same';
					} else {
						$val['img'] = Yii::$app->params['httpImg']['hosts'] . Yii::$app->params['httpImg']['houses'] . $val['thumb'] . '/same';
					}
				}else {
					$val['img'] = Yii::$app->params['httpImg']['hosts'] . Yii::$app->params['httpImg']['housetypes'] . $val['img'] . '/same';
				}
			}
		}
		return $list;
	}

    //楼盘公共信息
    public function PublicDetails()
    {
        $input = Yii::$app->request->get();
        $houseModel = new House();
        $houseModel->id = $input['hid'];
        $houseRow = $houseModel->OneDetails(['id', 'name', 'state', 'city', 'characteristic', 'thumb', 'is_tel']);
        if ($houseRow != null) {
//            $houseRow['city'] = '';
            if (!empty($houseRow['city'])) {
                $cityModel = new \common\models\CategoryCity();
                $houseRow['seo'] = $cityModel->FatherSon($houseRow['city']);
                if (empty($houseRow['seo']['city'])) {
                    $houseRow['seo']['city'] = '';
                }
            }
            //猜你喜欢
            $houseModel->id = '';
            $houseModel->city = $houseRow['city'];
            $houseRow['randhouse'] = $houseModel->randList(4);

            $houseRow['state'] = Yii::$app->params['HouseSalesStatus'][$houseRow['state']];
            $houseRow['thumb'] = Yii::$app->params['httpImg']['hosts'] . Yii::$app->params['httpImg']['houses'] . $houseRow['thumb'];
            //特色主题
            $subject = \common\fm\HouseHandle::ChangeCharacteristic($houseRow['characteristic']);
//                $this->Subject(json_decode($houseRow['characteristic'],true));
            $houseRow['characteristic'] = $subject;

            //随机电话
            if (empty($houseRow['is_tel'])) {
                $houseRow['tel'] = $this->RandTel($houseRow['city']);
            } else {
                $houseRow['tel'] = $houseRow['is_tel'];
            }

            return $houseRow;
        }
    }

    //楼盘随机电话
    public function RandTel($city)
    {
        if (!empty($city)) {
            $tel = new \common\models\CategoryTelCity();
            $tel->cid = $city;
            $telModel = $tel->CityTelOne();
            if (!empty($telModel['tel'])) {
                $telArr = explode(',', $telModel['tel']);
                $randNum = array_rand($telArr, 1);
                return $telArr[$randNum];
            }
        }
        return Yii::$app->params['default_dialtel'];
//        $tel = new \common\models\CategoryTelCity();
//        $tel->cid = $city;
//        $telModel = $tel->CityTelOne();
//        if(!empty($telModel['tel']))
//        {
//            $telArr = explode(',',$telModel['tel']);
//            $randNum =  array_rand($telArr,1);
//            return $telArr[$randNum];
//        }
//            return Yii::$app->params['default_dialtel'];
    }

    //特色主题 超过3个随机返回3个元素
    public function Subject($id, $num = 3)
    {
        if (empty($id) || !is_array($id)) return [];
        $char = new Characteristic();
        $char->id = $id;
//        if(is_array($id) && !empty($id))
//        {
//            $char->id = $id;
//        }
        $charMode = array_column($char->getList([], ['id', 'name']), 'name', 'id');
        if ($charMode != null) {
            $count = count($charMode);
            $arr = [];
            if ($count >= $num) {
                $rand = array_rand($charMode, $num);
                foreach ($rand as $key => $val) {
                    $arr[$key] = $charMode[$val];
                }
            } else {
                $arr = $charMode;
            }
            return $arr;
        }
    }

    public function ArchitectureType($id, $type = null)
    {
        if (!empty($id)) {
            $model = new CategoryLabel();

            $model->id = $id;
            $model->type = $type;
            $rows = $model->getList([], ['name']);

            if (!empty($rows)) {
                return array_column($rows, 'name');
            }
        }
        return [];

    }


    //楼盘资讯
    public function HouseNewsList()
    {
        $input = Yii::$app->request->get();
        if (is_numeric($input['hid'])) {
            $model = new HouseNews();
            $model->hid = $input['hid'];
            $houseNewsInfo = $model->getHidList();
            $nids = array_column($houseNewsInfo, 'nid');
            $newsModel = new News();
            $newsModel->hid = $input['hid'];
            $result = $newsModel->getNewsListHouse($nids);


            foreach ($result as &$val) {
                $time_int = strtotime($val['open_time']);

                $val['d'] = date('d', $time_int);
                $val['ym'] = date('Y-m', $time_int);
                $val['thumb'] = json_decode($val['thumb'], true);
            }
            return $result;
        }
    }

    /*
     * 递归区域
     * */
    public function RecursionCity()
    {

    }

    public function distinguishHouse($input)
    {

        switch ($input['type']) {
            case 'tuijian':
                $model = new PushHousesale();
                $model->type = 3;
                $result = $model->Homegetlist(4);

                break;
            case 'price':
                $model = new House();
                $model->is_push = 2;
                $model->sale_price = $input['content'];
                $a['sale_price'] = $input['content'];
                $a['page'] = $input['id'];
                $a['limit'] = 4;
                $result = $model->HomegetList(4, $a);
                if (empty($result)) {
                    $_model = clone $model;
                    $model->is_push = 1;
                    $result = $model->HomegetList(4, $a);
                }
                break;
            case 'quyu':
                $model = new House();
                $model->is_push = 2;
                $model->city = $input['content'];
                $a['page'] = $input['id'];
                $a['limit'] = 4;
                $result = $model->HomegetList(4, $a);
                if (empty($result)) {
                    $_model = clone $model;
                    $model->is_push = 1;
                    $result = $model->HomegetList(4, $a);
                }

                break;
        }

        if (!empty($result)) {
            foreach ($result as &$val) {
                $val['price_zj'] = HouseHandle::priceUnit($val['price_unit']);
                $val['thumb'] = Yii::$app->params['httpImg']['hosts'] . Yii::$app->params['httpImg']['houses'] . $val['thumb'];
            }
            return $result;
        }

    }

    /*
     * 地图搜索，后期优化搜索代码
     * */
    public function MapSearch($input)
    {
        $query = new House();
        //搜索条件
        if (!empty($input)) {
            foreach ($input as $a => $b) {
                if ($a == 'zhuti') {
                    $a = 'characteristic';
                }
                if (isset($query->$a)) {
                    $query->$a = $b;
                }
            }
        }


        //处理价格区间
        if (!empty($query->price)) {
            $price = \common\models\HousesPrice::find();
            $priceModel = $price->andWhere(['id' => $query->price])->one();
            if ($priceModel != null) {
                $query->price = $priceModel->price;
            }
        }

        //户型
        if (!empty($query->type)) {
            $type = \common\models\HouseType::find();
            $typeModel = $type->andWhere(['type_id' => $query->type, 'del' => 1])->asArray()->all();
            $query->id = array_unique(array_column($typeModel, 'hid'));
        }


        $data = $query->MapSearch(['pfg_category_city.city_name', 'pfg_house.id', 'pfg_house.city', 'pfg_house.price', 'pfg_house.name', 'pfg_house_detail.address', 'pfg_house_detail.main_units', 'pfg_house_detail.price_unit', 'pfg_house.thumb', 'pfg_house.sale_price', 'pfg_house.characteristic', 'pfg_house_detail.longitude_latitude']);

        if ($data != null) {
//            $characteristic = new \common\models\Characteristic();
//            $charList = $characteristic->getList([]);
//            $characteristicId = array_column($charList,'name','id');
//            $chara = array_column($data,'characteristic','id');
//            $charaArrs = [];
//            //处理特色主题
//            foreach ($chara as $key=>$val)
//            {
//                $arr = json_decode($val,true);
//                if(is_array($arr) && !empty($arr))
//                {
//                    foreach ($arr as $k=>$v)
//                    {
//                        if(isset($characteristicId[$v]))
//                        {
//                            $charaArrs[$key][$k] = $characteristicId[$v];
//                        }
//                    }
//                }
//            }
//
//            $Tel = new \common\models\CategoryTelCity();
//            $telRow = $Tel->QgetAll();
//
//            $cityTel = [];
//            foreach ($telRow as &$v)
//            {
//                $cityTel[$v['cid']] = explode(',',$v['tel']);
//            }
//
//            $randArr = [];
            foreach ($data as &$val) {
                $val['characteristic'] = \common\fm\HouseHandle::ChangeCharacteristic($val['characteristic']);
//                if(isset($charaArrs[$val['id']]))
//                {
//                    //随机选择3个特色主题
//                    if(count($charaArrs[$val['id']]) > 3)
//                    {
//                        $ranChar = array_rand($charaArrs[$val['id']],3);
//                        $randArr[] = $charaArrs[$val['id']][$ranChar[0]];
//                        $randArr[] = $charaArrs[$val['id']][$ranChar[1]];
//                        $randArr[] = $charaArrs[$val['id']][$ranChar[2]];
//                        $val['characteristic'] = $randArr;
//                        $randArr= [];
//                    }
//                    else
//                    {
//                        $val['characteristic'] = $charaArrs[$val['id']];
//                    }
//
//                }

                if (!empty($cityTel[$val['city']][0])) {
                    $val['citytel'] = \common\fm\HouseHandle::ChangeCityTel($val['city']);
//                    $rand =  array_rand($cityTel[$val['city']],1);
//                    $val['citytel'] =$cityTel[$val['city']][$rand];

                } else {
                    $val['citytel'] = Yii::$app->params['default_dialtel'];
                }
            }
            return $data;

        }

    }

    public function getHouseRemarkList($input, $page)
    {
        $houseComment = new HouseComment();
        $houseCommentLikes = new HouseCommentLikes();
        $houseCommentReply = new HouseCommentreply();
        $houseComment->hid = $input['hid'];
        $houseCommentList = $houseComment->getHouseList($page);
        if ($houseCommentList != null) {
            foreach ($houseCommentList as &$value) {
                $value['allremark'] = floor(($value['diduan'] + $value['jiaotong'] + $value['peitao'] + $value['huanjing'] + $value["xingjiabi"]) / 5);
                $value['mobile'] = preg_replace("/(\d{3})\d{4}(\d{2})/", "\$1******\$3", $value['mobile']);

                $houseCommentLikes->hid = $value['hid'];
                $houseCommentLikes->hcid = $value['id'];
                $value['count_likes'] = $houseCommentLikes->Total();
                $value['reply'] = $houseCommentReply->getCommentReply($value['id']);
            }
            return $houseCommentList;
        }
    }
	
	public function getHouseListByCity($city, $limit = null)
	{
		$cityList = (new CategoryCity())->getTongSonList($city);
		$model = new House();
		$model->city = $cityList;
		$data = $model->getCityHouseList(6);
		foreach ($data as &$val) {
			$val['thumb'] = Yii::$app->params['httpImg']['hosts'] . Yii::$app->params['httpImg']['houses'] . $val['thumb'] . '/same';
			$val['tel'] = $this->RandTel($val['city']);
			$news = (new News())->getHouseNewByHid($val['id'], 1);
			if (!empty($news)) {
				$val['news_name'] = $news[0]['subject'];
				$val['news_id'] = $news[0]['id'];
			}
		}
		return $data;
	}
}