pfhwyigou/common/models/Enroll.php

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

namespace common\models;

class Enroll extends Common
{
    //PC端 模板来源
//    public  $sourceArr = [
//        0  => '楼盘搜索列表-降价通知',
//        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 => '列表页-获取优惠'
//    ];
//
//    //移动端 模板来源
//    public $sourceMrr = [
//            0 => '楼盘首页-优惠获取',
//            1 => '楼盘首页-看房定制',
//            2 => '楼盘首页-立即了解',
//            3 => '团购-立即报名',
//            4 => '团购详情-立即报名',
//            5 =>' 团购详情-报名看房',
//            6 => '视频播放页-了解项目',
//            7 => '资讯详情-立即订阅',
//            8 => '资讯详情-报名看房',
//            9 => '首页-报名看房',
//            10 => '首页-看房专车',
//            11 => '楼盘首页-报名看房',
//            12 => '楼盘首页-降价通知',
//            13 => '楼盘首页-开盘通知我',
//            14 => '底部导航-看房定制',
//            15 => '奇葩说详情-报名看房'
//    ];


    public $stateArr = [
        1 => '失败',
        2 => '成功',
    ];

    public $equipmentArr = [
        1 => '移动端',
        2 => 'PC',
    ];

    public function rules()
    {
        return [
            [['mobile', 'name', 'intention_house', 'intention_city', 'budget', 'intention_housetype', 'hid', 'source', 'equipment'], 'trim'],
            ['mobile', 'match', 'pattern' => '/^1[23456789]\d{9}$/', 'message' => '请输入正确的手机号码'],
            ['name', 'string', 'max' => 5, 'min' => 2],
            [['intention_house', 'intention_city', 'budget', 'intention_housetype'], 'string', 'max' => 100],
            ['equipment', 'in', 'range' => [1, 2], 'message' => '设备来源错误'],
            ['hid', 'number'],
            ['hid', 'default', 'value' => 0],
            ['send_email', 'string'],
            ['ip', 'default', 'value' => \Yii::$app->request->userIP],
            ['source', 'in', 'range' => array_flip((new \common\models\EnrollSource())->TypeColumn(2)), 'on' => 'pcadd'],
            ['source', 'in', 'range' => array_flip((new \common\models\EnrollSource())->TypeColumn(1)), 'on' => 'madd'],
        ];
    }

    public function attributeLabels()
    {
        return [
            'mobile' => '手机号码',
            'intention_house' => '意向楼盘',
            'intention_city' => '意向区域',
            'intention_housetype' => '意向户型',
            'budget' => '预算',
            'name' => '姓名',
            'equipment' => '设备',
            'source' => '来源',
        ];
    }

    public function Authenticator($input)
    {
        $this->load($input, '');
        if ($this->validate()) return $this;
        return $this->errors;
    }

    public function FindById($id)
    {
        return self::findOne($id);
    }

    public function FindByIds()
    {
        $query = self::find();
        $query->select(['pfg_enroll.*', 'pfg_house.name as house_name', 'pfg_category_city.city_name', 'pfg_email.email']);
        $query->andwhere(['pfg_enroll.id' => $this->id]);
        $query->andwhere(['pfg_enroll.del' => $this->setDel]);
        $query->leftJoin('pfg_house', 'pfg_enroll.hid = pfg_house.id');
        $query->leftJoin('pfg_category_city', 'pfg_house.city = pfg_category_city.id or pfg_enroll.b_city = pfg_category_city.id');
        $query->leftJoin('pfg_email', 'pfg_house.city = pfg_email.city');
        return $query->asArray()->one();
    }

    public function getList($page)
    {
        $query = self::find();
        $query->select(['pfg_enroll.*', 'pfg_house.name as house_name', 'pfg_category_city.city_name', 'pfg_house.city as house_city']);
        $query->andwhere(['pfg_enroll.del' => $this->setDel]);
        if (!empty($page['equipment'])) {
            $query->andWhere(['pfg_enroll.equipment' => $page['equipment']]);
        }
        if (!empty($page['hid'])) {
            $query->andWhere(['pfg_enroll.id' => $page['hid']]);
        }
        if (!empty($page['state'])) {
            $query->andWhere(['pfg_enroll.state' => $page['state']]);
        }

        if (isset($page['source_id']) && !empty($page['source_id'])) {
            $sou = explode('-', $page['source_id']);
            $query->andWhere(['pfg_enroll.equipment' => $sou[1]]);
            $query->andWhere(['pfg_enroll.source' => $sou[0]]);
        }

        if (isset($page['source_mobile']) && !empty($page['source_mobile'])) {
            $sou = explode('-', $page['source_mobile']);
            $query->andWhere(['pfg_enroll.equipment' => $sou[1]]);
            $query->andWhere(['pfg_enroll.source' => $sou[0]]);
        }

        if (!empty($page['start_time'])) {
            $start_time = strtotime($page['start_time'] . ' 00:00:00');
            if (!empty($page['end_time'])) {
                $end_time = strtotime($page['end_time'] . ' 23:59:59');
            } else {
                $end_time = $_SERVER['REQUEST_TIME'];
            }

            $query->andWhere(['>=', 'pfg_enroll.create_at', $start_time]);
            $query->andWhere(['<=', 'pfg_enroll.create_at', $end_time]);
        }

        $query->leftJoin('pfg_house', 'pfg_enroll.hid = pfg_house.id');
        $query->leftJoin('pfg_category_city', 'pfg_house.city = pfg_category_city.id or pfg_enroll.b_city = pfg_category_city.id');
//        $query->leftJoin('pfg_email', 'pfg_house.city = pfg_email.city');
        $arr = [];
        if (!empty($page['accurate']) && $page['accurate'] == 1) {
            $query->groupBy(['pfg_enroll.mobile']);
        }
        if (!empty($page['page'])) {
            $count = clone $query;
            $arr['total'] = $count->count();
            $query->offset = ($page['page'] - 1) * $page['limit'];
            $query->limit = $page['limit'];
        } else {
            $query->limit = 20;
        }
        $arr['data'] = $query->orderBy(['pfg_enroll.create_at' => SORT_DESC])->asArray()->all();
        return $arr;
    }

    public function Total($page)
    {
        $query = self::find();
        $query->where(['pfg_enroll.del' => $this->setDel]);
        if (!empty($page['equipment'])) {
            $query->andWhere(['pfg_enroll.equipment' => $page['equipment']]);
        }

        if (isset($page['source_id']) && !empty($page['source_id'])) {
            $sou = explode('-', $page['source_id']);
            $query->andWhere(['pfg_enroll.equipment' => $sou[1]]);
            $query->andWhere(['pfg_enroll.source' => $sou[0]]);
        }

        if (!empty($page['start_time'])) {
            $start_time = strtotime($page['start_time'] . ' 00:00:00');
            if (!empty($page['end_time'])) {
                $end_time = strtotime($page['end_time'] . ' 23:59:59');
            } else {
                $end_time = $_SERVER['REQUEST_TIME'];
            }

            $query->andWhere(['>=', 'pfg_enroll.create_at', $start_time]);
            $query->andWhere(['<=', 'pfg_enroll.create_at', $end_time]);
        }
        $query->leftJoin('pfg_house', 'pfg_enroll.hid = pfg_house.id and pfg_enroll.hid != 0');
        $query->leftJoin('pfg_category_city', 'pfg_house.city = pfg_category_city.id and pfg_enroll.hid != 0');
//        $query->leftJoin('pfg_email', 'pfg_house.city = pfg_email.city and pfg_enroll.hid != 0');
        return $query->count();
    }

    public function SendEmail($page)
    {
        $query = self::find();
        $query->select(['pfg_enroll.*', 'pfg_house.name as house_name', 'pfg_category_city.city_name', 'pfg_email.email']);
        $query->andWhere(['pfg_enroll.del' => $this->setDel]);
        if (!empty($page['id'])) {
            $query->andWhere(['IN', 'pfg_enroll.id', $page['id']]);
        }
        $query->leftJoin('pfg_house', 'pfg_enroll.hid = pfg_house.id');
        $query->leftJoin('pfg_category_city', 'pfg_house.city = pfg_category_city.id or pfg_enroll.b_city = pfg_category_city.id');
        $query->leftJoin('pfg_email', 'pfg_house.city = pfg_email.city');
        $query->orderBy(['pfg_enroll.create_at' => SORT_DESC]);
        return $query->asArray()->all();
    }

}