<?php

namespace App\Http\Controllers;

use Illuminate\Foundation\Bus\DispatchesJobs;
use Illuminate\Routing\Controller as BaseController;
use Illuminate\Foundation\Validation\ValidatesRequests;
use Illuminate\Foundation\Auth\Access\AuthorizesRequests;
use App\Http\Controllers\LogController;
use Illuminate\Http\Request;
use App\UserInformation;
use App\Parameter;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Config;
use Illuminate\Support\Str;
use DB;
use Carbon\Carbon;

class Controller extends BaseController
{
    use AuthorizesRequests, DispatchesJobs, ValidatesRequests;

    public function registerLog($user_id, $description, $data_operation,$task, $module_id){
        $c = new LogController;
        $c->logRegister($user_id, $description, $data_operation,$task, $module_id);
    }

    public function changeDbDefault(Request $request){
      if(!$request->is('api/*')){
        $userOld = UserInformation::where('user_id',Auth::user()->id)->first();
        Config::set('database.default',$userOld->current_db);
        DB::reconnect($userOld->current_db);
        $userI = UserInformation::where('user_id',Auth::user()->id)->first();
        $parameters = Parameter::where('id',1)->first();
        $userI->current_db = $parameters->db_name;
        $userI->update();
      }
    }

    // retorna codigo para el evento
    public function codeOrder()
    {
        return (string) Str::uuid();
    }

    public function sumMinutesDate($date,$minutes)
    {
        $current_date = Carbon::parse($date);
        return $current_date->addMinutes($minutes);
    }

    public function gen_uid($l=10){
        return strtoupper(substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyz"), 0, $l));
    }

      // valida si una fecha es valida basada con la fecha actual
    public function validateDate($date, $type) {
        $currentDate = Carbon::now();
        if ($date && $date != "") {
            $dateStart = explode("-", substr($date, 0 , -9));
            $timeStart = explode(":", substr($date, 11 , 10));
            $newDateValidate = Carbon::create(
                intval($dateStart[0]),
                intval($dateStart[1]),
                intval($dateStart[2]),
                intval($timeStart[0]),
                intval($timeStart[1]),
                intval($timeStart[2])
            );
            if ($newDateValidate->getTimestamp() < $currentDate->getTimestamp() && $type == "start") {
                return true;
            }
            if ($newDateValidate->getTimestamp() > $currentDate->getTimestamp() && $type == "end") {
                return true;
            }
        }
        return false;
    }

    // funcion para retornar el valor de una celda en la importacion de archivos excel de la libreria Box\Spout\Reader\Common\Creator\ReaderEntityFactory;
    public function getValueRow($cells,$index = false)
    {
        if($index !== false){
            return $cells[$index]->getValue();
        }
        return $cells->getValue();
    }
}