laravel-4 - example - formulario con datepicker en laravel

Laravel Datepicker y consulta elocuente

Question

Estoy haciendo una página donde puedo usar el guardabosques, datepicker de jqueryui.com y estoy muy contento con laravel Framework.

Tengo la consulta elocuente de la siguiente manera,

public function orderbydate()
{
$order =DB::table(''sales_flat_order_items as s'')
->leftJoin(''sales_flat_orders as w'', ''w.entity_id'',''='',''s.order_id'')
->select(array(DB::Raw(''sum(s.amount_refunded) as amount_refunded''),
DB::Raw(''sum(s.row_total) as row_total''),
DB::Raw(''sum(s.discount_amount) as discount_amount''),
DB::Raw(''sum(s.tax_amount) as tax_amount''),
DB::Raw(''sum(s.qty_ordered) as qty_ordered''),
DB::Raw(''sum(w.subtotal) as subtotal''),
DB::Raw(''sum(w.total_invoiced) as total_invoiced''),
DB::Raw(''sum(w.shipping_amount) as shipping_amount'')))
->where(''qty_canceled'',''='',''0'')
->where(''status'',''!='',''canceled'')
->get();
$orderbydate = DB::table(''sales_flat_order_items as s'')
->leftJoin(''sales_flat_orders as w'', ''w.entity_id'',''='',''s.order_id'')
->select(array(DB::Raw(''sum(s.amount_refunded) as amount_refunded''),
DB::Raw(''sum(s.row_total) as row_total''),
DB::Raw(''sum(s.discount_amount) as discount_amount''),
DB::Raw(''sum(s.tax_amount) as tax_amount''),
DB::Raw(''sum(s.qty_ordered) as qty_ordered''),
DB::Raw(''sum(w.subtotal) as subtotal''),
DB::Raw(''DATE(w.created_at) days''),
DB::Raw(''sum(w.total_invoiced) as total_invoiced''),
DB::Raw(''sum(w.shipping_amount) as shipping_amount'')))
->where(''qty_canceled'',''='',''0'')
->where(''status'',''!='',''canceled'')
->groupBy(''days'')
->orderBy(''s.created_at'')
->paginate(10);
return View::make(''sales_flat_orders.orderbydate'', compact(''order'',''orderbydate''));
}

Nota: esta función le mostrará todos los datos en la plantilla

Otra función es

public function orderbydate1()
{
$startDate = Input::get(''w.created_at'');
$endDate = Input::get(''w.created_at'');
$order1 =DB::table(''sales_flat_order_items as s'')
->leftJoin(''sales_flat_orders as w'', ''w.entity_id'',''='',''s.order_id'')
->select(array(DB::Raw(''sum(s.amount_refunded) as amount_refunded''),
DB::Raw(''sum(s.row_total) as row_total''),
DB::Raw(''sum(s.discount_amount) as discount_amount''),
DB::Raw(''sum(s.tax_amount) as tax_amount''),
DB::Raw(''sum(s.qty_ordered) as qty_ordered''),
DB::Raw(''sum(w.subtotal) as subtotal''),
DB::Raw(''sum(w.total_invoiced) as total_invoiced''),
DB::Raw(''sum(w.shipping_amount) as shipping_amount'')))
->where(''qty_canceled'',''='',''0'')
->where(''status'',''!='',''canceled'')
->get();
$orderbydate1 = DB::table(''sales_flat_order_items as s'')
->leftJoin(''sales_flat_orders as w'', ''w.entity_id'',''='',''s.order_id'')
->select(array(DB::Raw(''sum(s.amount_refunded) as amount_refunded''),
DB::Raw(''sum(s.row_total) as row_total''),
DB::Raw(''sum(s.discount_amount) as discount_amount''),
DB::Raw(''sum(s.tax_amount) as tax_amount''),
DB::Raw(''sum(s.qty_ordered) as qty_ordered''),
DB::Raw(''sum(w.subtotal) as subtotal''),
DB::Raw(''DATE(w.created_at) days''),
DB::Raw(''sum(w.total_invoiced) as total_invoiced''),
DB::Raw(''sum(w.shipping_amount) as shipping_amount'')))
->whereBetween(''w.created_at'',array($startDate,$endDate))
->where(''qty_canceled'',''='',''0'')
->where(''status'',''!='',''canceled'')
->groupBy(''days'')
->orderBy(''s.created_at'')
->paginate(10);
return View::make(''sales_flat_orders.result'', compact(''order'',''orderbydate1''));
}

Tengo una plantilla llamada OrderByDAte.blade.php

Ventas por fecha

 {{ Form::open() }}
<label for="from">From</label>
<input type="text" id="from" name="from">
<label for="to">to</label>
<input type="text" id="to" name="to">
<input type="submit" value="Submit" class="btn btn-info btn-block">
{{ Form::close() }}
<script>
$(function() {
$( "#from" ).datepicker({
defaultDate: "+1w",
changeMonth: true,
numberOfMonths: 3,
onClose: function( selectedDate ) {
$( "#to" ).datepicker( "option", "minDate", selectedDate );
}
});
$( "#to" ).datepicker({
defaultDate: "+1w",
changeMonth: true,
numberOfMonths: 3,
onClose: function( selectedDate ) {
$( "#from" ).datepicker( "option", "maxDate", selectedDate );
}
});
});
</script>

También el bucle que muestra la tabla.

Y ahora

**result.blade.php** which displays the data.
<table class="table table-striped table-bordered table-hover" id="dataTables-example">
<thead>
<tr class="odd gradeX">
<th>DATE</th>
<th>Items Ordered</th>
<th>Subtotal</th>
<th>Tax Amount</th>
<th>Discount Amount</th>
<th>Row Total</th>
<th>Refunded</th>
<th>Total Invoiced</th>
<th>Shipping Amount</th>
</tr>
</thead>
@foreach($orderbydate1 as $s)
<tbody>
<tr class="odd gradeX">
<td>{{date("d F, Y",strtotime($s->days))}}</td>
<td>{{ round($s->qty_ordered, 2) }}</td>
<td>{{round($s->subtotal,2)}}</td>
<td>{{round($s->tax_amount,2)}}</td>
<td>{{round($s->discount_amount,2)}}</td>
<td>{{round($s->row_total,2)}}</td>
<td>{{round($s->amount_refunded,2)}}</td>
<td>{{round($s->total_invoiced,2)}}</td>
<td>{{round($s->shipping_amount,2)}}</td>
</tr>
@endforeach

Nota: Creo que mi botón Enviar no funciona. No sé por qué?

Ahora quiero usar datepicker para filtrar esto por fecha, en mis rutas sé que tengo que usar la publicación y después de enviar la fecha debo obtener la tabla de datos en ese rango.

Cómo usar $ startDate y $ endDate aquí. en mi consulta elocuente. Tengo que tomar el campo de entrada ''w.created_at'' para mi startDate y también ''w.created_at'' para $ endDate. Creo que tengo que usar entrada de fachada en mi función de esta manera.

$startDate = Input::get(''w.created_at'');
$endDate = Input::get(''w.created_at'');

Pero esta función no funciona.

Actualmente estoy usando el marcador de fecha bootstrap. Pero si conoces a otro, entonces U me puede dar ejemplos.

Ahora hay dos plantillas que utilizo para el

Route::get(''orderbydate'', array(''as''=>''orderbydate'', ''uses''=>''SalesFlatController@orderbydatesales''))

para obtener todos los datos en mi plantilla.

Y para el post que uso

Route::get(''result'', array(''as''=>''result'', ''uses''=>''SalesFlatController@orderbydate''))

Nota: me sale un error como Missing 1 argumento.

¿Alguien puede ayudarme un poco simplemente sabiendo dónde me estoy equivocando?

Answer 1

Necesitas cambiar:

public function orderbydate($startDate, $endDate)

a:

public function orderbydate()

ya que estás obteniendo esos valores de Input::get() . Ponerías esas variables en la llamada a la función solo si esas variables provienen de variables en la ruta, es decir:

Route::get(''result/{startDate}/{endDate}'', array(''as''=>''result'', ''uses''=>''SalesFlatController@orderbydate''))