public function postCargarpersonas()
{
if (Request::ajax()) {
$array = array();
$array['where'] = '';
$array['usuario'] = Auth::user()->id;
$array['limit'] = '';
$array['order'] = '';
if (Input::has("paterno")) {
$array['where'] .= " AND r.paterno LIKE '%" . Input::get("paterno") . "%' ";
}
if (Input::has("materno")) {
$array['where'] .= " AND r.materno LIKE '%" . Input::get("materno") . "%' ";
}
if (Input::has("nombres")) {
$array['where'] .= " AND r.nombres LIKE '%" . Input::get("nombres") . "%' ";
}
if (Input::has("dni")) {
$array['where'] .= " AND r.dni LIKE '%" . Input::get("dni") . "%' ";
}
if (Input::has('draw')) {
if (Input::has('order')) {
$inorder = Input::get('order');
$incolumns = Input::get('columns');
$array['order'] = ' ORDER BY ' . $incolumns[$inorder[0]['column']]['name'] . ' ' . $inorder[0]['dir'];
}
$array['limit'] = ' LIMIT ' . Input::get('start') . ',' . Input::get('length');
$retorno["draw"] = Input::get('draw');
}
$array['order'] = " ORDER BY r.paterno,r.materno,r.nombres ";
$cant = Ficha::getCargarReniecCount($array);
$aData = Ficha::getCargarReniec($array);
$aParametro['rst'] = 1;
$aParametro["recordsTotal"] = $cant;
$aParametro["recordsFiltered"] = $cant;
$aParametro['data'] = $aData;
$aParametro['msj'] = "No hay registros aún";
return Response::json($aParametro);
}
}
