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