CRM/normandcrm/service/backend/models/PrivateAccount.php

<?php
/**
 * Created by PhpStorm.
 * User: user
 * Date: 2019/11/17
 * Time: 14:38
 */
namespace backend\models;

use Yii;

/**
 * This is the model class for table "crm_private_account".
 *
 * @property integer $id
 * @property integer $add_time
 * @property integer $is_close
 * @property integer $is_used
 * @property string $account
 */
class PrivateAccount extends \yii\db\ActiveRecord
{

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

    /**
     * @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 [
            [['id', 'add_time','is_close','is_used'], 'number'],
            [['account'], 'string'],
        ];
    }

    /**
     * @return array|bool|\yii\db\ActiveRecord[]
     */
    public function getAccountConfig()
    {
        $sql = "select id from crm_private_account where is_close = 0";
        $res = static::findBySql($sql)->asArray()->all();
        if(empty($res)){
            return false;//没有开放的对公帐户
        }
        $sql = "select account from crm_private_account where is_close = 0 and is_used = 0 order by id desc limit 1";
        $account_arr = static::findBySql($sql)->asArray()->all();
        if($account_arr){
            return $account_arr[0];
        }else{
            $sql = "update crm_private_account set is_used = 1 where is_close = 1";
            Yii::$app->db->createCommand($sql)->execute();
            static::getAccountConfig();
        }
    }
}