public static function clientesFrecuentes($date)
{
$clientes = DB::Select('select c.id,c.cedula,c.nombre,c.apellidos,(select count(*) from reservacion
where id_cliente = c.id and fecha_reservacion like \'%' . $date . '%\')as visitas,
c.telefono,c.id_empresa, c.ultimavisita
from cliente as c where c.visitas != 0 ORDER BY visitas DESC');
return $clientes;
}
