public function modalEstadoCuenta() { $neighbor_property_id = Input::get('neighbor_property_id'); $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; } } for ($j = 0; $j <= 11; $j++) { if ($j + 1 < $mes_ini) { $saldoAnteriol[$j] = ""; $cuataMes[$j] = ""; $totalDebe[$j] = ""; $pagos[$j] = ""; $saldoTotal[$j] = ""; } elseif ($j + 1 <= date("m")) { $saldoAnteriol[$j] = $saldoTotal[$j - 1]; $cuataMes[$j] = -$cuotas[$months[$j]]; $totalDebe[$j] = $saldoAnteriol[$j] + $cuataMes[$j]; $neighbor_payments = PaymentStates::with('NeighborProperty')->where('neighbor_property_id', '=', $neighbor_property_id)->first(); if ($neighbor_payments) { $pagos[$j] = $neighbor_payments->{$months}[$j] == NULL ? 0 : $neighbor_payments->{$months}[$j]; } else { $pagos[$j] = 0; } $saldoTotal[$j] = $totalDebe[$j] + $pagos[$j]; } elseif ($j + 1 > date("m")) { $saldoAnteriol[$j] = ""; $cuataMes[$j] = ""; $totalDebe[$j] = ""; $pagos[$j] = ""; $saldoTotal[$j] = ""; } } $neighbor = NeighborProperty::find($neighbor_property_id); return View::make('dashboard.payments.neighbors.table_neigbor', compact('breadcrumbs_data', 'saldoAnteriol', 'cuataMes', 'totalDebe', 'pagos', 'saldoTotal', 'mes_ini', 'ini', 'months', 'color', 'neighbor')); }
<!--<td bgcolor="#A7F8B3" width="20%">Dirección</td>--> <td bgcolor="#A7F8B3" width="15%">Vecino</td> <td bgcolor="#A7F8B3">Ene</td><td bgcolor="#A7F8B3">Feb</td> <td bgcolor="#A7F8B3">Mar</td><td bgcolor="#A7F8B3">Abr</td> <td bgcolor="#A7F8B3">May</td><td bgcolor="#A7F8B3">Jun</td> <td bgcolor="#A7F8B3">Jul</td><td bgcolor="#A7F8B3">Ago</td> <td bgcolor="#A7F8B3">Sep</td><td bgcolor="#A7F8B3">Oct</td> <td bgcolor="#A7F8B3">Nov</td><td bgcolor="#A7F8B3">Dic</td> </tr> </thead> <tbody> <?php foreach ($neighbors as $neighbor) { $neighbor_payments = PaymentStates::with('NeighborProperty')->where(DB::raw('year'), '=', date("Y"))->where('neighbor_property_id', '=', $neighbor->id)->first(); if ($neighbor_payments) { $debe = 0; //if($neighbor->Urbanism->UrbanismType->id == 3) //echo '<td style="font-size:95%;" ><div align="left">'.strtolower ($neighbor->Building->description).' - Apto. '.$neighbor->num_house_or_apartment.'</div></td>'; //else // echo '<td style="font-size:95%;" ><div align="left">'.strtolower ($neighbor->Street->name).' - Casa '.$neighbor->num_house_or_apartment.'</div></td>'; echo '<td><div align="left">' . ucfirst(strtolower($neighbor->Neighbors->name)) . ' ' . ucfirst(strtolower($neighbor->Neighbors->last_name)) . '</div></td>'; for ($j = 0; $j <= 11; $j++) { if ($j + 1 < $mes_ini) { echo '<td> </td>'; } else { if ($j + 1 <= date("m")) { if ($neighbor_payments->{$months}[$j] == Null && date("m") != $j + 1) { $debe = $debe + $cuotas[$months[$j]]; echo '<td dir="' . $neighbor_payments->NeighborProperty->id . '" class="modalInfo" style="color:#ED3333; cursor: pointer; font-size:100% ;text-align: center;"> <div><i class="fa fa-2x fa-times" ></i></div></td>';