<?php

namespace App\Komma\Search;

use Illuminate\Support\Facades\DB;


class SearchService{

    /**
     * @param $table
     * @param $column
     * @param $search
     * @return mixed
     */
    public function search($table, $column, $search)
    {
        return DB::table($table)
            ->where($column, '=' , $search )
            ->where("deleted_at", null)
            ->orderBy('name', 'asc')
            ->get()->all();
    }

    /**
     * @param $table
     * @param $search
     * @return mixed
     */
    public function chosenOptionData($table, $search)
    {
        return DB::table($table)
            ->where('id', $search)
            ->get()->all();
    }

    /**
     * @param $relatedTable
     * @param $search
     * @return mixed
     */
    public function chosenOptionDataRelatedTable($relatedTable, $search){
        return DB::table($relatedTable)
            ->where('id', $search)
            ->get()->all();
    }


}