public function getDashboard()
{
$users = User::where('padre_id', '=', Auth::user()->id)->orderBy('id', 'DESC')->take(5)->get();
$eventos = Evento::where('user_id', '=', Auth::user()->id)->orderBy('id', 'DESC')->take(5)->get();
$ventas = Venta::where('user_id', '=', Auth::user()->id)->orderBy('id', 'DESC')->take(5)->get();
$this->layout->content = View::make('admin/dashboard')->with('users', $users)->with('eventos', $eventos)->with('ventas', $ventas);
}
public function getEstadisticos()
{
setlocale(LC_TIME, 'spanish');
$mes = strftime("%B", mktime(0, 0, 0, date('m'), 1, 2000));
$anio = date('Y');
$pagos = Pago::where(DB::raw('YEAR(created_at)'), '=', date('Y'))->where(DB::raw('MONTH(created_at)'), '=', date('m'))->where('cancelado', 0)->sum('monto');
$ventas = Venta::where(DB::raw('YEAR(fecha)'), '=', date('Y'))->where(DB::raw('MONTH(fecha)'), '=', date('m'))->where('cancelada', 0)->where('cotizacion', 0)->where('autorizado', 1)->groupby(DB::raw('YEAR(fecha)'), DB::raw('MONTH(fecha)'))->orderby('fecha')->sum('total');
return Response::json(array("ventas" => number_format($ventas, 0, ".", ","), "ingresos" => number_format($pagos, 0, ".", ","), "mes" => Str::title($mes) . ' de ' . $anio));
}
public function getTotal()
{
$count_cotizaciones = Venta::where('cotizacion', 1)->count();
return Response::json(array('total' => $count_cotizaciones));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
User::destroy($id);
User::where('padre_id', '=', $id)->delete();
Venta::where('user_id', '=', $id)->delete();
Rango::where('user_id', '=', $id)->delete();
return Redirect::to('admin/users')->with('success', 'Usuario borrado exitosamente!');
}
