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!'); }