<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\FromCollection;
use Illuminate\Contracts\View\View;
use Maatwebsite\Excel\Concerns\FromView;
use DB;

class CanjeExport implements FromView{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function view(): View{
        $canjes=DB::table('canjeproductos as cp')
            ->join('canjes as c','cp.canje_id','c.id')
            ->join('users as u','c.usuario_id','u.id')
            ->join('catalogos as ca','cp.producto_id','ca.id')
            ->select('u.name','ca.*','c.created_at as fecha','cp.monedas','cp.cantidad')
            ->orderBy('cp.id','desc')->get();

        return view('exports.solicitudes', [
            'canjes' => $canjes,
        ]);
    }
}