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