<?php

namespace App\Http\Controllers;

use Carbon\Carbon;
use Illuminate\Http\Request;
use App\Exports\specifyPeriod;
use Illuminate\Support\Facades\DB;

class export extends Controller
{
    public function ExportExcel(Request $request){
        if ($request->from_date && $request->to_date) {
            $user_id = auth()->id();
            $from_date = Carbon::parse(Carbon::parse($request->from_date)->toDateString());
            $to_date = Carbon::parse(Carbon::parse($request->to_date)->addDay()->toDateString());
            $to_date->subSecond();

            $query_results = DB::table('logs')->where('user_id', $user_id)->whereBetween('submit_date',[$from_date->toDateTimeString(),$to_date->toDateTimeString()])->get();
//            if($query_results->count() > 100000){
//                return redirect()->back()->with('info','Your request was not processed, kindly send an email to support@npontu.com for your report.');
//            }

            $title = "sms_custom_log_".date('Ymdhis');
            return (new specifyPeriod())->filter($request->from_date, $request->to_date)->download($title.'.xlsx', \Maatwebsite\Excel\Excel::XLSX);
        }
    }

    public function ExportCsv(Request $request){
        if ($request->from_date && $request->to_date) {
            $user_id = auth()->id();
            $from_date = Carbon::parse(Carbon::parse($request->from_date)->toDateString());
            $to_date = Carbon::parse(Carbon::parse($request->to_date)->addDay()->toDateString());
            $to_date->subSecond();

            $query_results = DB::table('logs')->where('user_id', $user_id)->whereBetween('submit_date',[$from_date->toDateTimeString(),$to_date->toDateTimeString()])->get();
//            if($query_results->count() > 100000){
//                return redirect()->back()->with('info','Your request was not processed, kindly send an email to support@npontu.com for your report.');
//            }
            
            $title = "sms_custom_log_".date('Ymdhis');
            return (new specifyPeriod())->filter($request->from_date, $request->to_date)->download($title.'.csv', \Maatwebsite\Excel\Excel::CSV);
        }
    }
}