<?php

namespace App\Exports;

use App\Asignacion;
use Maatwebsite\Excel\Concerns\FromCollection;
use DB;

class EvaluacionesExport implements FromCollection
{
    /**
    * @return \Illuminate\Support\Collection
    */

    protected $empresa_id;

    function __construct($empresa_id) {
        $this->empresa_id = $empresa_id;
    }

    public function collection(){
    	 
        return DB::table('asignacions as a')
	    	->join('users as u','a.evaluador_id','u.id')
	    	->join('users as us','a.evaluado_id','us.id')
	    	->join('evaluacions as e','a.evaluacion_id','e.id')
	    	->join('empresas as em','a.empresa_id','em.id')
	    	->select('a.id as id','u.name as evaluador','us.name as evaluado','e.eva_nombre as evaluacion','a.asi_estado as estado')
	    	->where('a.empresa_id',$this->empresa_id)->get();
    }
}