EVOLUTION-MANAGER

Edit File: helpers.php

<?php

use App\contadormodelo;
use Carbon\Carbon;

function sanear_string($s)
{
 
    $s = mb_convert_encoding($s, 'UTF-8','UTF-8');
        $s = preg_replace("/á|à|â|ã|ª/","a",$s);
        $s = preg_replace("/Á|À|Â|Ã/","A",$s);
        $s = preg_replace("/é|è|ê/","e",$s);
        $s = preg_replace("/É|È|Ê/","E",$s);
        $s = preg_replace("/í|ì|î/","i",$s);
        $s = preg_replace("/Í|Ì|Î/","I",$s);
        $s = preg_replace("/ó|ò|ô|õ|º/","o",$s);
        $s = preg_replace("/Ó|Ò|Ô|Õ/","O",$s);
        $s = preg_replace("/ú|ù|û/","u",$s);
        $s = preg_replace("/Ú|Ù|Û/","U",$s);
        $s = str_replace(" ","_",$s);
        $s = str_replace("ñ","n",$s);
        $s = str_replace("Ñ","N",$s);
        
        $s = preg_replace('/[^a-zA-Z0-9_.-]/', '', $s);
        return $s;
}

function nombre_archivo($nombre_guardar)
{
    $extension = pathinfo($nombre_guardar, PATHINFO_EXTENSION);
    $nombre_base = basename($nombre_guardar, '.'.$extension);  
    return $nombre_base;
}

function obtener_mes($dia){
    $meses=array('1'=>'ENERO','2'=>'FEBRERO','3'=>'MARZO'
        ,'4'=>'ABRIL','5'=>'MAYO','6'=>'JUNIO','7'=>'JULIO',
        '8'=>'AGOSTO','9'=>'SEPTIEMBRE','10'=>'OCTUBRE','11'=>'NOVIEMBRE','12'=>'DICIEMBRE');
    return $meses[$dia];

}

function total_visitas_mes()
{
    $date = Carbon::now();
    $year_now = $date->year;
    $mes_now = $date->month;
    //$mes1 = contadormodelo::where('visit_date', 'like', $year_now .'-1'. '%')->select('visit_date')->count();
    //Carbon::createFromFormat('Y-m-d H', '1975-05-21 22')->toDateTimeString(); // 1975-05-21 22:00:00
    $mes_actual="";
    if($mes_now<10){
        $mes_actual = contadormodelo::where('tipo','visita')->where('visit_date', 'like', $year_now .'-0'.$mes_now. '%')->select('visit_date')->count();
    }else{
        $mes_actual = contadormodelo::where('tipo','visita')->where('visit_date', 'like', $year_now .'-'.$mes_now. '%')->select('visit_date')->count();
    }

return $mes_actual;
}

function total_visitas_dia()
{
    // $date = Carbon::now();
    // $year_now = $date->year;
    // $mes_now = $date->month;
    // $dia_now = $date->day;
    //$mes1 = contadormodelo::where('visit_date', 'like', $year_now .'-1'. '%')->select('visit_date')->count();
    //Carbon::createFromFormat('Y-m-d H', '1975-05-21 22')->toDateTimeString(); // 1975-05-21 22:00:00
    // $dia_actual="";
    // if($mes_now<10){
    //     $dia_actual = contadormodelo::where('visit_date', 'like', $year_now .'-0'.$mes_now. '%')->select('visit_date')->count();
    // }else{
    //     $dia_actual = contadormodelo::where('visit_date', 'like', $year_now .'-'.$mes_now. '%')->select('visit_date')->count();
    // }

$dia_actual=contadormodelo::where('tipo','visita')->whereDate('visit_date', date('Y-m-d'))->count();

return $dia_actual;
}