laravel-4 - update - laravel pagination

Laravel elocuente grupo de ORM donde

Question

¿Cómo convierto la siguiente consulta a Laravel 4 ORM elocuente?

select * from table where ((starttime <= ? and endtime >= ?) or (starttime <= ? and endtime >= ?) or (starttime >= ? and endtime <= ?))

Answer 1

Me gusta esto:

<?php
$results = DB::table(''table'')
->where(function($query) use ($starttime,$endtime){
$query->where(''starttime'', ''<='', $starttime);
$query->where(''endtime'', ''>='', $endtime);
})
->orWhere(function($query) use ($otherStarttime,$otherEndtime){
$query->where(''starttime'', ''<='', $otherStarttime);
$query->where(''endtime'', ''>='', $otherEndtime);
})
->orWhere(function($query) use ($anotherStarttime,$anotherEndtime){
$query->where(''starttime'', ''>='', $anotherStarttime);
$query->where(''endtime'', ''<='', $anotherEndtime);
})
->get();

Eche un vistazo a la documentation para ver más cosas interesantes que puede hacer con Eloquent y el Generador de consultas .

// Editar: Para ajustar incluso la cláusula where completa entre llaves (como en su pregunta), puede hacer esto:

<?php
$results = DB::table(''table'')
//this wraps the whole statement in ()
->where(function($query) use ($starttime,$endtime, $otherStarttime,$otherEndtime, $anotherStarttime,$anotherEndtime){
$query->where(function($query) use ($starttime,$endtime){
$query->where(''starttime'', ''<='', $starttime);
$query->where(''endtime'', ''>='', $endtime);
});
$query->orWhere(function($query) use ($otherStarttime,$otherEndtime){
$query->where(''starttime'', ''<='', $otherStarttime);
$query->where(''endtime'', ''>='', $otherEndtime);
});
$query->orWhere(function($query) use ($anotherStarttime,$anotherEndtime){
$query->where(''starttime'', ''>='', $anotherStarttime);
$query->where(''endtime'', ''<='', $anotherEndtime);
});
})
->get();