public function run()
{
$año = Carbon\Carbon::now()->year;
foreach (range(1, 12) as $mes) {
foreach (Residencias::get() as $residencia) {
$solvencias[] = array('año' => $año, 'mes' => $mes, 'residencia_id' => $residencia->id);
}
}
Solvencia::insert($solvencias);
}
public function residencias($action)
{
if (isset($action)) {
if ($action == "create") {
$data = Residencias::firstOrCreate(Input::all());
return $respuesta = array('Record' => $data, 'Result' => "OK");
}
if ($action == "edit") {
Residencias::where("id", Input::get("id"))->update(Input::except("id"));
return $respuesta = array('Record' => Residencias::find(Input::get('id')), 'Result' => "OK");
}
if ($action == "remove") {
Residencias::where('id', Input::get("id"))->delete();
return '{"Result":"OK"}';
}
if ($action == "list") {
if (Input::has('q')) {
$Records = Residencias::where("id", Input::get('q'))->get();
} else {
$Records = Residencias::get();
}
$respuesta = array('Records' => $Records, 'Result' => "OK");
return json_encode($respuesta);
}
if ($action == "personas") {
$nulos = DB::table('personas')->select(DB::raw("'NO POSEE' as DisplayText,'null' as value"));
$respuesta = DB::table('personas')->select("nombre as DisplayText", "id as Value")->union($nulos)->orderby('value', 'desc')->distinct()->get();
return "var opciones=" . json_encode($respuesta);
}
}
}
public function generarResumendeCobrosMes()
{
$i = 0;
$time = new Carbon();
$mes = Input::get("mes", $time->month);
$año = Input::get("año", $time->year);
$residencias = Residencias::get();
foreach ($residencias as $residencia) {
$deudas[$i]['monto'] = getdeuda($residencia->id, $time->month, $time->year);
$deudas[$i]['residencia'] = $residencia;
$i++;
}
$html = View::make('pdf/estadoFacturasMes')->withDeudas($deudas)->withMes($mes)->withAño($año);
header('Content-Type : application/pdf');
$headers = array('Content-Type' => 'application/pdf');
return Response::make(PDF::load($html, 'A4', 'portrait')->show('Resumen de Cobros ' . $mes . "/" . $año), 200, $headers);
}
