<?php

namespace app\models;

use yii\behaviors\TimestampBehavior;

/**
 * This is the model class for table "{{%team_grades_audit}}".
 *
 * @property integer $id
 * @property integer $store_id
 * @property string  $name
 * @property integer $mobile
 * @property integer $user_id
 * @property integer $team_grades_level
 * @property integer $province_id
 * @property integer $city_id
 * @property integer $district_id
 * @property string  $address
 * @property integer $status
 * @property integer $is_delete
 * @property integer $audit_time
 * @property integer $created_at
 * @property integer $updated_at

 */
class TeamGradesAudit extends \yii\db\ActiveRecord
{
    //状态
    const STATUS_APPLY = 0;
    const STATUS_AGREE = 1;
    const STATUS_REFUSE = 2;

    const STATUS_ARR = [
        self::STATUS_APPLY,
        self::STATUS_AGREE,
        self::STATUS_REFUSE
    ];




    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%team_grades_audit}}';
    }


    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['id', 'store_id', 'mobile', 'user_id', 'team_grades_level', 'province_id', 'city_id', 'district_id', 'status', 'is_delete', 'audit_time', 'created_at', 'updated_at'], 'integer'],
            [['name', 'address'], 'string']
        ];
    }

    public function behaviors()
    {
        return [
            [
                'class' => TimestampBehavior::class
            ]
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'id' => '',
            'store_id' => '',
            'name' => '姓名',
            'mobile' => '手机号',
            'user_id' => '商城用户iD',
            'team_grades_level' => '申请等级',
            'province_id' => '省ID',
            'city_id' => '市ID',
            'district_id' => '区ID',
            'address' => '详细地址',
            'status' => '状态',
            'is_delete' => '',
            'audit_time' => '',
            'created_at' => '',
            'updated_at' => ''
        ];
    }

    /**
     * 获取用户审核信息
     * @param  $user_id
     */
    public static function getUserTeamGrades($user_id, $status = [self::STATUS_AGREE, self::STATUS_APPLY])
    {
        $team_grades = self::find()->where(['user_id' => $user_id, 'is_delete' => 0, 'status' => $status])
            ->select('id, user_id, store_id, name, mobile, team_grades_level, status, audit_time, province_id, city_id, district_id, address')->orderBy('id DESC')->asArray()->one();
        if (empty($team_grades)) {
            return null;
        }

        $team_grades['province_name'] = District::findOne($team_grades['province_id'])->name;
        $team_grades['city_name'] = District::findOne($team_grades['city_id'])->name;
        $team_grades['district_name'] = District::findOne($team_grades['district_id'])->name;


        $team_grades['team_grades_level_name'] = TeamGradesLevel::getLevelInfo($team_grades['team_grades_level'], $team_grades['store_id'], 'level_name');


        return $team_grades;
    }



}