<?php

namespace common\models\psources;

use common\core\BaseActiveRecord;
use Yii;

/**
 * CoinReleaseMember
 *
 * @property int    $id
 * @property int    $status
 * @property string $address
 * @property string $amount
 */
class CoinTransfer extends BaseActiveRecord
{
    const SCENARIOS_ADD    = 'add';
    const SCENARIOS_UPDATE = 'update';

    public static function getDb()
    {
        return Yii::$app->get('p_sources');
    }

    public static function tableName()
    {
        return '{{%coin_transfer}}';
    }

    public function attributeLabels()
    {
        return [
            'id'           => 'ID',
            'address'      => '地址',
            'amount'       => '数量',
            'hash'         => '交易hash',
            'status'       => '状态',
        ];
    }

    public function rules()
    {
        return [
            [['address', 'amount', 'hash'], 'string'],
        ];
    }

    public function sercians()
    {
        return [
            self::SCENARIOS_ADD    => ['address', 'amount', 'hash', 'status'],
            self::SCENARIOS_UPDATE => ['address', 'amount', 'hash', 'status'],
        ];
    }

    /**
     * 批量返回用户
     *
     * @param  integer|array $ids
     * @return array
     */
    public static function getMemberByRuleIds($ids)
    {
        return CoinReleaseMember::find()->where(['rule_id' => $ids])->andWhere(['>', 'freeze', 0])->asArray()->all();
    }


    public static function loadArray(array $data)
    {
        return self::getDb()->createCommand()->batchInsert(self::tableName(),
            ['address', 'amount'],
            $data)->execute();
    }
}