<?php


namespace App\Komma\Companies;


class CompanyRepository
{

    /**
     * @param $id
     * @param $search
     * @return mixed
     */
    public function fullCompany($id, $search)
    {
        return Company::with(['Acquisition', 'Kind', 'Projects' => function ($query) use ($search) {
            $query->where('name', 'LIKE', '%' . $search . '%')->with([
                'ProjectWorkers',
                'ProjectWorkers.User',
                'Subprojects',
                'Subprojects.Tasks',
                'Subprojects.Tasks.Hours',
                'Subprojects.Tasks.Hours.User',
            ])->orderBy('archived', 'asc')->orderBy('name', 'asc');
        }])->find($id);
    }


    /**
     * @param $search
     * @return mixed
     */
    public function allCompanies($search)
    {
        $searchArray = explode(" ", $search);
        return Company::with([
            'Contacts',
            'Projects' => function ($query){
                $query->where('archived', '0');
            }
        ])
            ->where(function ($query) use ($searchArray) {
                for ($i = 0; $i < count($searchArray); $i++){
                    if ($i == 0) {
                        $query->where('name', 'LIKE', '%' .$searchArray[$i] . '%');
                    } else {
                        $query->Where('name', 'LIKE', '%' .$searchArray[$i] . '%');
                    }
                }
            })
            ->orderBy('name', 'asc');
    }
}