TranslationRepository.php

<?php

namespace Grafite\Cms\Repositories;

use Carbon\Carbon;
use Grafite\Cms\Models\Translation;

class TranslationRepository
{
    public $model;

    public function __construct(Translation $translation)
    {
        $this->model = $translation;
    }

    /**
     * Create or Update an entry
     *
     * @param  integer $entityId
     * @param  string $entityType
     * @param  string $lang
     * @param  array $payload
     *
     * @return boolean
     */
    public function createOrUpdate($entityId, $entityType, $lang, $payload)
    {
        $translation = $this->model->firstOrCreate([
            'entity_id' => $entityId,
            'entity_type' => $entityType,
            'language' => $lang,
        ]);

        unset($payload['_method']);
        unset($payload['_token']);

        $translation->entity_data = json_encode($payload);

        return $translation->save();
    }

    /**
     * Find by URL
     *
     * @param  string $url
     * @param  string $type
     *
     * @return Object|null
     */
    public function findByUrl($url, $type)
    {
        $item = $this->model->where('entity_type', $type)->where('entity_data', 'LIKE', '%"url":"'.$url.'"%')->first();

        if ($item) {
            return $item->data;
        }

        return null;
    }

    /**
     * Find an entity by its Id
     *
     * @param  integer $entityId
     * @param  string $entityType
     *
     * @return Object|null
     */
    public function findByEntityId($entityId, $entityType)
    {
        $item = $this->model->where('entity_type', $entityType)->where('entity_id', $entityId)->first();

        if ($item) {
            return $item->data;
        }

        return null;
    }

    /**
     * Get entities by type and language
     *
     * @param  string $lang
     * @param  string $type
     *
     * @return Illuminate\Support\Collection
     */
    public function getEntitiesByTypeAndLang($lang, $type)
    {
        $entities = collect();
        $collection = $this->model->where('entity_type', $type)->where('entity_data', 'LIKE', '%"lang":"'.$lang.'"%')->get();

        foreach ($collection as $item) {
            $instance = app($item->type)->attributes = $item->data;
            $entities->push($instance);
        }

        return $entities;
    }
}