public function vistaPermisos() { $roles = Role::select("id", "name")->orderBy("id")->get(); $permisos = PermissionRole::where("role_id", "=", "2")->select("id", "state")->orderBy("id")->get(); $user_id = Auth::user()->id; $breadcrumbs = Neighbors::select('neighbors.name as name_ne', 'neighbors.last_name', 'urbanisms.name as name_ur ')->join('neighbors_properties', 'neighbors.id', '=', 'neighbors_properties.neighbors_id')->join('urbanisms', 'neighbors_properties.urbanism_id', '=', 'urbanisms.id')->where('neighbors.user_id', '=', $user_id)->first(); $breadcrumbs_data = $breadcrumbs->name_ne . " " . $breadcrumbs->last_name . " [ " . $breadcrumbs->name_ur . " ]"; return View::make("dashboard.roles.rolPermisos")->with(array("roles" => $roles, "permisos" => $permisos, 'breadcrumbs_data' => $breadcrumbs_data)); }
public function GeneraReportePagos() { $user_id = Auth::user()->id; ini_set('max_execution_time', 900000); $idurbanismo = Neighbors::where('user_id', '=', $user_id)->first(); $idurbanismo = $idurbanismo->urbanism_id; $breadcrumbs = Neighbors::select('neighbors.name as name_ne', 'neighbors.last_name', 'urbanisms.name as name_ur ')->join('neighbors_properties', 'neighbors.id', '=', 'neighbors_properties.neighbors_id')->join('urbanisms', 'neighbors_properties.urbanism_id', '=', 'urbanisms.id')->where('neighbors.user_id', '=', $user_id)->first(); $breadcrumbs_data = $breadcrumbs->name_ne . " " . $breadcrumbs->last_name . " [" . $breadcrumbs->name_ur . "]"; $payments = Payment::select()->join('neighbors_properties', 'payments.neighbor_property_id', '=', 'neighbors_properties.neighbors_id')->where('neighbors_properties.urbanism_id', '=', $idurbanismo)->count(); if ($payments == 0) { $isEmpty = true; } else { $isEmpty = false; } return View::make("dashboard.reports.report", ['isEmpty' => $isEmpty, 'idurbanismo' => $idurbanismo, 'breadcrumbs_data' => $breadcrumbs_data]); }
public function reportStatus() { $user_id = Auth::user()->id; $colonia = Session::get("colonia"); $urbanism = Urbanism::where('colony_id', '=', $colonia)->first(); $urbanismo = $urbanism->id; $urb_name = $urbanism->name; $property_id = NeighborProperty::where('urbanism_id', '=', $urbanismo)->pluck('id'); $vigencia = date("Y-m"); $months = array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Decem"); $today = date("Y-m-d"); $ano = date("Y"); $selano = Payment::select(DB::raw('DATE_FORMAT(payments.created_at,\'%Y\') as y'))->groupBy(DB::raw('Year(payments.created_at)'))->orderBy(DB::raw('Year(payments.created_at)'))->get(); $monthly_all = MonthlyFee::where('monthly_fee.urbanism_id', '=', $urbanismo)->where(DB::raw('DATE_FORMAT(monthly_fee.since,\'%Y\')'), '=', $ano)->get(); $monthly_ini = MonthlyFee::where('monthly_fee.urbanism_id', '=', $urbanismo)->where(DB::raw('DATE_FORMAT(monthly_fee.since,\'%Y\')'), '=', $ano)->orderBy('monthly_fee.created_at', 'ASC')->pluck('since'); $mes_ini = (int) date("m", strtotime($monthly_ini)); $cuotas = array(); foreach ($monthly_all as $cuota_mensual) { $ini = (int) date("m", strtotime($cuota_mensual->since)); $fin = (int) date("m", strtotime($cuota_mensual->until)); if ($cuota_mensual->until == NULL) { $fin = (int) date("m"); } for ($i = $ini; $i <= $fin; $i++) { $cuotas[$months[$i - 1]] = $cuota_mensual->amount; } } $neighbors = NeighborProperty::with('Neighbors')->where('urbanism_id', '=', $urbanismo)->get(); $breadcrumbs = Neighbors::select('neighbors.name as name_ne', 'neighbors.last_name', 'urbanisms.name as name_ur ')->join('neighbors_properties', 'neighbors.id', '=', 'neighbors_properties.neighbors_id')->join('urbanisms', 'neighbors_properties.urbanism_id', '=', 'urbanisms.id')->where('neighbors.user_id', '=', self::getUserId())->first(); $breadcrumbs_data = $breadcrumbs->name_ne . " " . $breadcrumbs->last_name . " [" . $breadcrumbs->name_ur . "]"; $data = ['mes_ini' => $mes_ini, 'months' => $months, 'cuotas' => $cuotas, 'selano' => $selano, 'urbanism' => $urbanismo, 'breadcrumbs_data' => $breadcrumbs_data, 'neighbors' => $neighbors, 'ini' => $ini, 'fin' => $fin, 'ano' => $ano, 'breadcrumbs_data' => $breadcrumbs_data]; $pdf = PDF::loadView('dashboard.reports.status.pdf', $data); return $pdf->download('reporte_Estato_cuanta_general.pdf'); }