<?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 [];

        }

    }

}