<?php

namespace App\Services;

use App\CommodityBarcode;

Class CommodityBarcodeService
{
    public function getCommodities(array $codes, $owner_id){
        return CommodityBarcode::query()->whereHas('commodity',function ($query)use($owner_id){
            $query->where('owner_id',$owner_id);
        })->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();
    }

    public function firstOrCreate(array $params, array $value = null)
    {
        if (!$value)$value = $params;
        return CommodityBarcode::query()->firstOrCreate($params,$value);
    }

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