pfhwyigou/common/models/ListHouse.php

<?php
/**
 * Created by PhpStorm.
 * User: xiaofeng
 * Date: 2018/3/4
 * Time: 上午9:41
 */

namespace common\models;

//use yii\db\ActiveRecord;
class ListHouse extends Common
{
    public function rules()
    {
        return [
            ['list_id', 'in', 'range' => [10, 11, 12, 101, 102, 103]],
            ['hid', 'required', 'message' => '楼盘不能为空'],
            [['sort', 'state', 'information'], 'safe']
        ];
        /**
         * list_id:[
         * 10:pc端首页VR全景看房推送
         * 11:pc端首页航拍视频看房推送
         * 12:M端首页热榜楼盘推送位
         * 101,102,103:国庆中秋专题
         * ]
         */
    }
    /***********************************后台数据*******************************************/
    //获取品质新房数据
    public function GetCharachterForm($input)
    {
        $query = self::find();
        $query->select(['pfg_list_house.*', 'pfg_house.name']);
        $query->where(['pfg_list_house.list_id' => $input['type_id']]);
        $count = $query->count();
        $query->leftJoin('pfg_house', 'pfg_house.id = pfg_list_house.hid');
        if (!empty($input['page'])) {
            $query->offset(--$input['page'] * $input['limit']);
        }
        if (!empty($input['limit'])) {
            $query->limit($input['limit']);
        }
        $data = $query->orderBy(['pfg_list_house.state' => SORT_ASC, 'pfg_list_house.sort' => SORT_DESC])->asArray()->all();
        foreach ($data as &$val) {
            $val['create_at'] = date('Y-m-d H:i:s', $val['create_at']);
        }
        return ['msg' => '获取数据完成', 'count' => $count, 'data' => $data];
    }


    //获取数据列表
    public function getList($input)
    {
        $query = self::find();
        $query->select(['pfg_list_house.*', 'pfg_house.name']);
        $query->where(['pfg_list_house.list_id' => $input['list_id']]);
        $count = $query->count();
        $query->leftJoin('pfg_house', 'pfg_house.id = pfg_list_house.hid');
        if (!empty($input['page'])) {
            $query->offset(--$input['page'] * $input['limit']);
        }
        if (!empty($input['limit'])) {
            $query->limit($input['limit']);
        }
        $data = $query->orderBy(['pfg_list_house.state' => SORT_ASC, 'pfg_list_house.sort' => SORT_DESC])->asArray()->all();
        foreach ($data as &$val) {
            $val['create_at'] = date('Y-m-d H:i:s', $val['create_at']);
        }
        return ['msg' => '获取数据完成', 'count' => $count, 'data' => $data];
    }


    /**
     * 获取一条数据
     * */
    public function getFindOne($id)
    {
        $query = self::find();
        $query->select(['pfg_list_house.*', 'pfg_house.name']);
        $query->where(['pfg_list_house.id' => $id]);
        $query->leftJoin('pfg_house', 'pfg_house.id = pfg_list_house.hid');
        return $query->asArray()->one();
    }

    /*
     * 检测数据是否存在
     * */
    public function listExists($where)
    {
        return self::find()->where($where)->exists();
    }

    /***************************************** pc端数据 ********************************************/
    //获取中秋专题数据
    public function zhongQiuGuoQing($list_id, $limit = null)
    {
        $select = [
            'pfg_house.id',
            'pfg_house.name',
            'pfg_house.thumb',
            'pfg_house.city',
            'pfg_house.sale_price',
            'pfg_house_detail.price_unit',
            'pfg_house_detail.address',
            'pfg_house_detail.preferential',
            'pfg_category_city.city_name'
        ];
        $query = self::find();
        $query->select($select);
        $query->where(['pfg_list_house.list_id' => $list_id, 'pfg_list_house.state' => 1, 'pfg_house.del' => 1, 'pfg_house.is_view' => 1]);
        $query->leftJoin('pfg_house', 'pfg_house.id = pfg_list_house.hid');
        $query->leftJoin('pfg_house_detail', 'pfg_house.id = pfg_house_detail.hid');
        $query->leftJoin('pfg_category_city', 'pfg_category_city.id = pfg_house.city');
        if (!empty($limit)) {
            $query->limit($limit);
        }
        return $query->orderBy(['pfg_list_house.sort' => SORT_DESC])->asArray()->all();
    }

    //获取指定楼盘推送数据列表
    public function getIndexPushHouse($list_id, $limit = null)
    {
        $select = [
            'pfg_house.id',
            'pfg_house.name',
            'pfg_house.thumb',
            'pfg_category_city.city_name',
            'pfg_house_detail.panorama_img',
            'pfg_house_detail.video_img'
        ];
        $query = self::find();
        $query->select($select);
        $query->where(['pfg_list_house.list_id' => $list_id, 'pfg_list_house.state' => 1, 'pfg_house.del' => 1, 'pfg_house.is_view' => 1]);
        $query->leftJoin('pfg_house', 'pfg_house.id = pfg_list_house.hid');
        $query->leftJoin('pfg_house_detail', 'pfg_house.id = pfg_house_detail.hid');
        $query->leftJoin('pfg_category_city', 'pfg_category_city.id = pfg_house.city');
        if (!empty($limit)) {
            $query->limit($limit);
        }
        return $query->orderBy(['pfg_list_house.sort' => SORT_DESC])->asArray()->all();
    }

    //获取指定楼盘推送数据列表详细信息
    public function getIndexPushHouseDetail($list_id, $limit = null)
    {
        $select = [
            'pfg_house.id',
            'pfg_house.name',
            'pfg_house.thumb',
            'pfg_house.state',
            'pfg_house.sale_price',
            'pfg_house.is_tel',
            'pfg_house.city',
            'pfg_house_detail.price_unit',
            'pfg_house_detail.preferential',
            'pfg_house_detail.video_url',
            'pfg_category_city.city_name'
        ];
        $query = self::find();
        $query->select($select);
        $query->where(['pfg_list_house.list_id' => $list_id, 'pfg_list_house.state' => 1, 'pfg_house.del' => 1, 'pfg_house.is_view' => 1]);
        $query->leftJoin('pfg_house', 'pfg_house.id = pfg_list_house.hid');
        $query->leftJoin('pfg_house_detail', 'pfg_house.id = pfg_house_detail.hid');
        $query->leftJoin('pfg_category_city', 'pfg_category_city.id = pfg_house.city');
        if (!empty($limit)) {
            $query->limit($limit);
        }
        return $query->orderBy(['pfg_list_house.sort' => SORT_DESC])->asArray()->all();
    }
}