<?php

namespace app\models;

use Yii;

/**
 * This is the model class for table "door".
 *
 * @property int $id
 * @property int $device_id
 * @property string $name
 * @property int $code
 * @property int $duration
 * @property int $always_open
 * @property int $always_close
 * @property int $created_at
 * @property int $modified_at
 */
class Door extends \yii\db\ActiveRecord {

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

    /**
     * {@inheritdoc}
     */
    public function rules() {
        return [
                [['device_id', 'name', 'code'], 'required'],
                [['device_id', 'code', 'created_at', 'modified_at', 'duration', 'always_open', 'always_close'], 'integer'],
                [['name'], 'string', 'max' => 100],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels() {
        return [
            'id' => 'ID',
            'device_id' => 'Device ID',
            'name' => 'Name',
            'code' => 'Code',
            'duration' => 'Duration',
            'created_at' => 'Created At',
            'modified_at' => 'Modified At',
        ];
    }

    public function multiCreate($datas) {
        $field = ['device_id', 'name', 'code', 'created_at', 'modified_at'];
        static::getDb()->createCommand()->batchInsert($this->tableName(), $field, $datas)->execute();
        return;
    }

    public static function doorsArray() {
        $lists = self::find()->all();
        $results = [];
        foreach ($lists as $key => $value) {
            $results[$value->id] = $value->name;
        }
        return $results;
    }

    public function getDevice() {
        return Device::findOne($this->device_id);
    }

}