Edit File - File Manager

Edit File: ExcelController.php

<?php

namespace App\Http\Controllers\Admin;

use App\Exports\MasterExport;
use App\Http\Controllers\Controller;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Str;
use Maatwebsite\Excel\Facades\Excel;

class ExcelController extends Controller
{
    public function __construct()
    {
        if (ob_get_length()) {
            ob_end_clean(); // this
            ob_start(); // and this
        }
    }

public function master($export, Request $request)
    {
        $data =  $this->$export($request);
        return $this->masterExport($export, $data['cols'], $data['values']);
    }

public function User()
    {
        return [
            'cols' => ['#', __('admin.name'), __('admin.email'), __('admin.phone')],
            'values' =>  ['id', 'name', 'email', 'phone']
        ];
    }

public function Provider()
    {
        return [
            'cols' => ['#', __('admin.name'), __('admin.email'), __('admin.phone')],
            'values' =>  ['id', 'name', 'email', 'phone']
        ];
    }

public function Delegate()
    {
        return [
            'cols' => ['#', __('admin.name'), __('admin.email'), __('admin.phone')],
            'values' =>  ['id', 'name', 'email', 'phone']
        ];
    }

public function Category()
    {
        return [
            'cols' => ['#', __('admin.name'), __('admin.followed_category')],
            'values' => ['id', 'name', 'followed_category'],
        ];
    }
    public function Country()
    {
        return [
            'cols' => ['#', __('admin.name'), __('admin.key')],
            'values' => ['id', 'name', 'key'],
        ];
    }
    public function Admin()
    {
        return [
            'cols' => ['#', __('admin.name'), __('admin.email'), __('admin.phone')],
            'values' => ['id', 'name', 'email', 'phone'],
        ];
    }

public function City()
    {
        return [
            'cols' => ['#', __('admin.name'), __('admin.country')],
            'values' => ['id', 'name', 'country.name'],
        ];
    }

public function Neighborhood()
    {
        return [
            'cols' => ['#', __('admin.name'), __('admin.city')],
            'values' => ['id', 'name', 'city.name'],
        ];
    }

public function masterExport($model, $cols, $values)
    {
        $folderNmae = strtolower(Str::plural(class_basename($model)));
        $model = app("App\Models\\$model");
        $records = $model::latest()->get();
        return Excel::download(new MasterExport($records, 'master-excel', ['cols' => $cols, 'values' => $values]), $folderNmae . '-reports-' . Carbon::now()->format('Y-m-d') . '.xlsx');
    }
}

Back to File Manager