SetArrayIn($_GET);
$VarWhere = '';
if(true === isset($_GET['VarSearch']) && 'NdCodGos' == $_GET['VarSearch']){
$VarWhere .= "a.codgos = " . $_GET['codgos'];
}
if(true === isset($_GET['_search']) && 'true' == $_GET['_search']){
if(true === isset($ObjJqGridMod->filters) && '' != $ObjJqGridMod->filters){
$VarWhere .= ' AND '. $ObjJqGridMod->generateSearchStringFromFilter();
}
if(true === isset($ObjJqGridMod->searchField) && '' != $ObjJqGridMod->searchField){
$VarWhere .= ' AND '. $ObjJqGridMod->generateSearchStringFromSearchField();
}
}
$VarWhere = SiteLibs::StripAndOrFirst($VarWhere);
$VarOrder = $ObjJqGridMod->GetOrder();
$VarLimit = $ObjJqGridMod->GetLimit();
$ObjObondMod = new ObondMod($MS_SP);
$count = $ObjObondMod->GetFromDb('SqlSARS' . $_GET['VarSearch'] . 'Count', 'GetOne', $VarWhere);
$total_pages = $ObjJqGridMod->GetTotalPages($count);
$page = $ObjJqGridMod->GetPage();
$ArrObond = $ObjObondMod->GetFromDb('SqlSARS' . $_GET['VarSearch'] . 'All', 'GetAll', $VarWhere, $VarOrder, $VarLimit);
$ArrFields = array();
foreach ($ArrObond AS $key => $row){
$VarOnd = $row['ond'];
if(true === isset($row['nizm'])){
if ('99' == $row['nizm']){
$VarOnd .= ' ' . $MS_SP->Sp_LangMessage['script']['ScrCorrection'];
}
else{
$VarOnd .= ' ' . $MS_SP->Sp_LangMessage['script']['ScrNumChange'] . $row['nizm'];
}
}
if('' != $row['ffile']){
$VarFfile = '+';
}
else{
$VarFfile = '';
}
$ArrFields[$key]['id'] = $row['id'];
$ArrFields[$key]['cell'] = array(
''.$VarOnd.'',
$row['nnd'],
$row['lang_orig'],
$VarFfile
);
}
$json = array("page" => $page, "total" => $total_pages, "records" => $count,"rows" => $ArrFields);
echo json_encode($json);
}
?>