<?php

/**
 * Short description for the file.
 *
 * @author      Komma <support@komma.pro>
 * @copyright   (c) 2012-2015, Komma Mediadesign
 */

namespace Komma\Cases;

use Komma\Cases\Models\CaseClass;

class CaseService
{

    public function getCases(){
        $cases = CaseClass::where('active', 1)
            ->where('lft', '!=', 1)
            ->with('translation')
            ->with('images')
            ->orderBy('lft')
            ->get();

        foreach ($cases as $key => $case){
            if(!isset($case->translation) || !$case->translation->active_trans) $cases->forget($key);
        }

        return $cases;
    }

    /**
     * This method gets the projects where
     *
     * @param $field | string, field for the where
     * @param $values | array, value for the where
     * @return mixed
     */
    public function getCasesWhere($field, $values)
    {
        //Only get the active blocks
        $cases = CaseClass::where($field, '=', $values)
            //Where field is value
            //Also load the translation
            ->with('translation')
            ->with('images')
            ->orderBy('lft')
            ->get();

        foreach ($cases as $key => $case){
            if(!isset($case->translation) || !$case->translation->active_trans) $cases->forget($key);
        }

        return $cases;
    }


}