<?php

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

namespace Komma\Jobs;

use Komma\Jobs\Models\Job;

class JobService
{
    public function getJob($id)
    {
        $job = Job::where('id', '=', $id)
            ->where('active', '=', 1)
            ->with('translation')
            ->with('translation')
            ->with('translation.route')
            ->with('files')
            ->get();

        return $job;
    }

    public function getAllJobs()
    {
        $jobs = Job::where('lft', '>', 1)
            ->where('active', '=', 1)
            ->with('translation')
            ->with('translation.route')
            ->orderBy('lft')
            ->with('files')
            ->get();

        return $jobs;
    }

    public function countActiveJobs()
    {
        return Job::where('active', 1)
            ->where('lft', '!=', 1)
            ->count();
    }

    /**
     * Get all translations of an page
     * based upon this page id
     *
     * @param $page_id
     * @return mixed
     */
    public function jobInOtherLanguageRoutes($id)
    {
        return Job::where('id', '=', $id)
            ->with('allTranslations')
            ->with('allTranslations.route')
            ->first();
    }
}