<?php

namespace domain\device;

use domain\device\models\CreateBatch as CreateBatchModel;
use yii\db\Query;

class CreateBatchRepository
{
    /**
     * @param $condition
     * @return null|static
     */
    static function findOne($condition)
    {
        return CreateBatchModel::findOne($condition);
    }

    /**
     * @param $type
     * @param $keyword
     * @return array
     */
    static function getSerialNoComponent($type, $keyword)
    {
        if ('manufacture' == $type) {
            $q = new Query();
            $q->select('id,manufacture_no, name');
            $q->from('manufacture');
            $q->where('name like "%'.$keyword.'%" or manufacture_no like "%'.$keyword.'%"');
            $q->limit(20);
            $list = $q->all();

            return $list;
        } elseif('project' == $type) {
            $q = new Query();
            $q->select('id,project_no, name');
            $q->from('project');
            $q->where('name like "%'.$keyword.'%" or project_no like "%'.$keyword.'%"');
            $q->limit(20);
            $list = $q->all();

            return $list;
        } elseif ('model' == $type) {
            $q = new Query();
            $q->select('id,model_no, name');
            $q->from('model');
            $q->where('name like "%'.$keyword.'%" or model_no like "%'.$keyword.'%"');
            $q->limit(20);
            $list = $q->all();

            return $list;
        } elseif ('production' == $type) {
            $q = new Query();
            $q->select('id,production_no, name');
            $q->from('production');
            $q->where('name like "%'.$keyword.'%" or production_no like "%'.$keyword.'%"');
            $q->limit(20);
            $list = $q->all();

            return $list;
        } else {
            return [];
        }
    }

}