baoshi-was/app/Services/CommodityBarcodeService.php

<?php 

namespace App\Services; 

use App\CommodityBarcode;

Class CommodityBarcodeService
{ 
    public function getCommodities(array $codes){
        return CommodityBarcode::query()->select('code','commodity_id')->whereIn('code',$codes)->get();
    }

    public function insert(array $params){
        return CommodityBarcode::query()->insert($params);
    }


    public function first(array $params){
        $query = CommodityBarcode::query();
        foreach ($params as $column => $value){
            $query->where($column,$value);
        }
        return $query->first();
    }

    public function get(array $params){
        $query = CommodityBarcode::query()->select('commodity_id','code');
        foreach ($params as $column => $values){
            if (is_array($values)) $query->whereIn($column,$values);
            else $query->where($column,$values);
        }
        return $query->get();
    }
}