<?php

namespace App\Modules\ConfrariaConvite\Models;

use DB;
use App\MyModel;
use Spatie\Activitylog\Traits\LogsActivity;
use App\CampoModulo;

class ConfrariaConvite extends MyModel
{
	use LogsActivity;

	protected $table = 'confraria_convite';

	private $rules = array();

	protected $guarded = [];

	private $messages = array();

	public function __construct(){
		parent::__construct();
		$this->setMessages($this->messages);
		$this->setRules($this->rules);
	}

	public function getLogNameToUse(string $eventName = ''): string
	{
		return 'log_confraria_convite';
	}

    public function editar($fields, $input, $id){
		$insert = [];
		foreach ($fields as $field) {
			$insert[$field] = $input[$field];
		}

		$confraria_convite = ConfrariaConvite::find($id);
		$confraria_convite->fill($insert);
		$confraria_convite->save();

		return 1;
	}

	public function getImagem($id){
		return DB::table('confraria_convite_imagens')->find($id);
	}

	public function getImagens($id){
		return DB::table('confraria_convite_imagens')->where('id_confraria_convite', $id)->get();
	}
	public function criar_imagem($input){
		return DB::table('confraria_convite_imagens')->insert([
			[
				'id_confraria_convite' => $input['id_confraria_convite'],
				'thumbnail_principal' => $input['thumbnail_principal'],
			]
		]);
	}
	public function editar_imagem($input, $id){
		return DB::table('confraria_convite_imagens')->where('id', $id)
		->update([
			'id_confraria_convite' => $input['id_confraria_convite'],
			'thumbnail_principal' => $input['thumbnail_principal'],
		]);;
	}
	public function deletar_imagem($id){
		return DB::table('confraria_convite_imagens')
				->where('id', $id)
				->delete();
	}

	public function confraria(){
		return $this->belongsTo('App\Modules\Confraria\Models\Confraria', 'confraria_id');
	}

	public function cadastro(){
		return $this->belongsTo('App\Modules\Cadastro\Models\Cadastro', 'cadastro_id');
	}
}