<?php

namespace App\Modules\OrdemCompra\Models;

use DB;
use App\MyModel;
use Spatie\Activitylog\Traits\LogsActivity;
use Spatie\Sluggable\HasSlug;
use Spatie\Sluggable\SlugOptions;
use App\CampoModulo;

class OrdemCompra extends MyModel
{
	use LogsActivity;
	use HasSlug;

	protected $table   = 'ordem_compra';
	protected $guarded = [];
	private $rules     = array();
	private $messages  = array();
    public $insert_log = false;

	public $arrStatus = [
		'P'  => 'Pendente',
		'A'  => 'Atendida',
		'AR' => 'Aprovada',
		'EN' => 'Encaminhadas',
		'C'  => 'Cancelada',
		'AP' => 'Atendida Parcialmente'
	];

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

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

	/**
	* Get the options for generating the slug.
	*/
	public function getSlugOptions() : SlugOptions
	{
		return SlugOptions::create()
		->generateSlugsFrom(['id'])
		->saveSlugsTo('slug');
	}

	public function getBySlug($slug){
		return DB::table($this->table)->where('slug',$slug)->firstOrFail();
	}

	public function criar($fields, $input){
		$insert = [];
		foreach ($fields as $field) {
			$insert[$field] = (isset($input[$field]) ? $input[$field] : NULL);
		}

		$ordem_compra = new OrdemCompra();
		$ordem_compra->fill($insert);
		$ordem_compra->save();

		return $ordem_compra->id;
	}

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

		$ordem_compra = OrdemCompra::find($id);
		$ordem_compra->fill($insert);
		$ordem_compra->save();

		return $id;
	}

	public function deletar($id){
		$ordem_compra = OrdemCompra::find($id);
		$ordem_compra->delete();
		return true;
	}


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

	public function getImagens($id){
		return DB::table($this->table.'_imagens')->where('id_ordem_compra', $id)->get();
	}
	public function criar_imagem($input){
		return DB::table($this->table.'_imagens')->insert([
			[
				'id_ordem_compra' => $input['id_ordem_compra'],
				'thumbnail_principal' => $input['thumbnail_principal'],
			]
		]);
	}
	public function deletar_imagem($id){
		return DB::table($this->table.'_imagens')
		->where('id', $id)
		->delete();
	}

	public function getNextAutoIncrement(){
		$lastId = DB::select("SELECT AUTO_INCREMENT FROM information_schema.tables WHERE TABLE_NAME = '$this->table' ORDER BY table_name;")[0]->AUTO_INCREMENT;
		return $lastId;
	}

	public function empresa(){
		return $this->belongsTo('App\Modules\Empresa\Models\Empresa', 'empresa_id');
	}

	public function unidadeNegocio(){
		return $this->belongsTo('App\Modules\UnidadeNegocio\Models\UnidadeNegocio', 'unidade_negocio_id');
	}

	public function fornecedor(){
		return $this->belongsTo('App\Modules\Fornecedor\Models\Fornecedor', 'fornecedor_id');
	}

	public function produtos(){
		return $this->hasMany('App\Modules\OrdemCompraItem\Models\OrdemCompraItem', 'ordem_compra_id');
	}

	public function responsavel(){
		return $this->belongsTo('App\User', 'responsavel_id');
	}

	public function responsavelUpdate(){
		return $this->belongsTo('App\User', 'responsavel_id_update');
	}

	public function responsavelAprovacao(){
		return $this->belongsTo('App\User', 'responsavel_id_aprovacao');
	}

	public function descStatus(){
		return $this->arrStatus[$this->status];
	}
}