<?php

namespace App\Exports;

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

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

    protected $evaluacion_id;

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

    public function collection(){

        return DB::table('respuestas as r')
	    	->join('interrogantes as i','r.interrogante_id','i.id')
	    	->join('asignacions as a','r.asignacion_id','a.id')
	    	->join('competencias as c','i.competencia_id','c.id')
	    	->join('evaluacions as e','c.evaluacion_id','e.id')
	    	->join('users as u','a.evaluador_id','u.id')
	    	->join('users as us','a.evaluado_id','us.id')
	    	->join('evaluacions as ev','a.evaluacion_id','ev.id') 
	    	->join('empresas as em','a.empresa_id','em.id')
	    	->select('us.name as evaluado','u.name as evaluador','e.eva_nombre','c.com_nom','i.int_nom','r.respuesta')
	    	->where('e.id',$this->evaluacion_id)->get();

    }
}