<?php

namespace app\models;

use Yii;
use app\widgets\LinkPager;
use yii\data\Pagination;

/**
 * This is the model class for table "{{%apply}}".
 *
 * @property int $id
 * @property int $project_id 项目id
 * @property int $user_id 申请用户id
 * @property int $status 审核状态
 * @property string $ip IP
 * @property string $location ip定位地址
 * @property string $created_at 申请日期
 * @property string $updated_at 更新时间
 * @property string $checked_at 处理日期
 */
class Apply extends Model
{
    
    const CHECK_STATUS = 10; //待审核状态
    const PASS_STATUS  = 20; //审核通过状态
    const REFUSE_STATUS = 30; //审核拒绝状态

    public $statusLabels = [
        self::CHECK_STATUS => '审核中',
        self::PASS_STATUS => '审核通过',
        self::REFUSE_STATUS => '审核拒绝',
    ];

    /**
     * 绑定数据表
     */
    public static function tableName()
    {
        return '{{%apply}}';
    }

    /**
     * 验证规则
     */
    public function rules()
    {
        return [
            [['project_id', 'user_id', 'ip', 'location'], 'required'],
            [['project_id', 'user_id', 'status'], 'integer'],
            [['created_at', 'updated_at', 'checked_at'], 'safe'],
            [['ip', 'location'], 'string', 'max' => 250],
        ];
    }

    /**
     * 字段标签
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'project_id' => '项目id',
            'user_id' => '申请用户id',
            'status' => '审核状态',
            'ip' => 'IP',
            'location' => 'ip定位地址',
            'created_at' => '申请日期',
            'updated_at' => '更新时间',
            'checked_at' => '处理日期',
        ];
    }

    /**
     * 获取项目
     * @return \yii\db\ActiveQuery
     */
    public function getProject()
    {
        return $this->hasOne(Project::className(),['id'=>'project_id']);
    }

    /**
     * 获取申请者
     * @return \yii\db\ActiveQuery
     */
    public function getApplier()
    {
        return $this->hasOne(Account::className(),['id'=>'user_id']);
    }

    /**
     * 申请搜索
     * @param array $params
     * @return $this
     * @throws \Exception
     */
    public function search($params = [])
    {
        $this->params = array2object($params);

        $query = self::find()->joinWith('project');

        if(!$this->params->order_by){
            $this->params->order_by = 'id DESC';
        }

        $query->andFilterWhere(['like', '{{%project}}.title', trim($this->params->title)]);

        $query->andFilterWhere([
            '{{%project}}.creater_id' => $this->params->creater_id,
        ]);

        $query->andFilterWhere([
            '{{%apply}}.project_id' => $this->params->project_id,
        ]);

        // 审核状态搜索
        $query->andFilterWhere([
            '{{%apply}}.status' => $this->params->status,
        ]);

        // 获取我创建的项目
        $account = Yii::$app->user->identity;

        $project_ids = $account->getCreatedProjects(Project::ACTIVE_STATUS)->select('id')->column();
        $project_ids = $project_ids ? : [-1];

        $query->andFilterWhere(['in', '{{%apply}}.project_id', $project_ids]);

        // 申请人搜索
        if($this->params->user->name){

            $user_ids = Account::find()
                ->andFilterWhere([
                    'or',
                    ['like','name', $this->params->user->name],
                    ['like','email', $this->params->user->name],
                ])
                ->select('id')->column();

            $user_ids = $user_ids ? : [-1];

            $query->andFilterWhere(['in', '{{%apply}}.user_id', $user_ids]);
        }

        $status = [];
        $this->params->check_status && $status[]  = $this->params->check_status;
        $this->params->pass_status && $status[]   = $this->params->pass_status;
        $this->params->refuse_status && $status[] = $this->params->refuse_status;

        $query->andFilterWhere(['in', '{{%apply}}.status', $status]);

        $this->count = $query->count();

        $pagination = new Pagination([
            'pageSizeParam' => false,
            'totalCount' => $this->count,
            'pageSize'   => $this->pageSize,
            'validatePage' => false,
        ]);

        $this->models = $query
            ->offset($pagination->offset)
            ->limit($pagination->limit)
            ->orderBy($this->params->order_by)
            ->all();

        $this->sql = $query->createCommand()->getRawSql();

//        dump($this->sql);

        $this->pages = LinkPager::widget([
            'pagination' => $pagination,
            'nextPageLabel' => '下一页',
            'prevPageLabel' => '上一页',
            'firstPageLabel' => '首页',
            'lastPageLabel' => '尾页',
            'hideOnSinglePage' => true,
            'maxButtonCount' => 5,
        ]);

        return $this;

    }
}