<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\SendMessage;
use App\Models\SendActivation;
use App\Models\LauncherActivator;
use App\Models\ActivationDetail;
use App\Models\Scenario;
use Response;
use URL;
use View;
use DB;


class HistoricalController extends Controller
{
    public function historial()
    {
        $scenarios = Scenario::all();
        return view('historical.index')->with('scenarios',$scenarios);
    }

    public function searchHistorial(Request $request)
    {
        //DB::enableQueryLog();
        $fecha = date("Y-m");
        //dump($fecha);
        $data = $request->all();
        //dd($data);
        if($request->ajax()){
            $historial = $request->historial;
            $desde = $request->fechaDesde;;
            $hasta = $request->fechaHasta;
            //dd($desde);

            if($historial === 'canal'){
                if($desde != null)
                {
                    $canales = SendMessage::select('id','subject','channels','message','created_at')
                        ->whereBetween('created_at',array($desde,$hasta))
                        ->get();
                    //dd(DB::getQueryLog( $canales));
                    return view('historical.information')->with('canales',$canales);
                }else{
                    $canales = SendMessage::select('id','subject','channels','message','created_at')
                        ->where('created_at','LIKE', $fecha.'%')
                        ->get();
                    //dd(DB::getQueryLog( $canales));
                    return view('historical.information')->with('canales',$canales);
                }
            }elseif($historial === 'escenario'){
                $detail = ActivationDetail
                    ::join('launcher_activator', 'launcher_activator.id', '=', 'activation_detail.launcher_id')
                    ->join('send_activation', 'send_activation.activation_detail_id', '=', 'activation_detail.id')

                    ->select('activation_detail.scenario_title as escenario','send_activation.recipient_type as tipo_envio','send_activation.contact_form_type_name as canal_contacto,',
                             'send_activation.contact_form_value as contacto', 'send_activation.contact_name as nombre_receptor', 'send_activation.contact_lastname as apellido_receptor',
                             'send_activation.contact_position as cargo_receptor', 'send_activation.company_name as compania_receptor', 'launcher_activator.description as descripcion_envio',
                             'send_activation.created_at')
                    ->where('activation_detail.created_at','LIKE', $fecha.'%')
                    ->get();
                    //dd(DB::getQueryLog( $detail));
                //dd($detail);
                return view('historical.information_escenarios')->with('escenarios',$detail);
            }
        }
    }
}