noride/noridecrm/service/backend/models/Permission.php

<?php

namespace backend\models;

use Yii;

/**
 * This is the model class for table "crm_permission".
 *
 * @property integer $id
 * @property integer member_id
 * @property string $url
 */
class Permission extends \yii\db\ActiveRecord
{

    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'crm_permission';
    }

    /**
     * @return \yii\db\Connection the database connection used by this AR class.
     */
    public static function getDb()
    {
        return Yii::$app->get('dbXcrm');
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['member_id'], 'required'],
            [['url'], 'string'],
        ];
    }
    
    /**
     * 获取权限，没有则新增 
     * @param int $member_id member表的id
     * @return array
     */
    public function getPermission($member_id)
    {
        $result = ['code' => 0, 'data' => [], 'message' => ''];

        /** @var Permission $model */
        $model = static::find()->where(['member_id' => $member_id])->limit(1)->one();
        if ($model == null) {
            $model = new static();
            $model->member_id = $member_id;
            $model->url = '';
            $model->save();
        }
        
        $result['code'] = 1;
        $result['data'] = $model->getAttributes();
        return $result;
    }

    /**
     * 更新权限
     * @param int $member_id member表的id
     * @param string $url
     * @return array
     */
    public function updatePermission($member_id, $url)
    {
        $result = ['code' => 0, 'data' => [], 'message' => ''];

        $model = static::find()->where(['member_id' => $member_id])->limit(1)->one();
        if (!$model) {
            $model = new static();
            $model->member_id = $member_id;
            $model->url = $url;
            $model->save();
        } else {
            $model->url = $url;
            $model->save(); // 写在花括号后面IDE识别不了
        }

        $result['code'] = 1;
        $result['data'] = $model->attributes;;
        return $result;
    }

}