$end = $rp;
} else {
$start = ($page - 1) * $rp + 1;
$end = $page * $rp;
}
$limit = "ROWS {$start} to {$end} ";
$where = "";
if ($query) {
$where = " WHERE {$qtype} CONTAINING '" . $query . "' ";
}
$sql = "SELECT * FROM SEL_USUARIOS_EMPRESA_GRID(" . $params . "," . $params2 . ") {$where} {$sort} {$limit}";
//echo $sql."</br>";
$result = runSQL($sql);
$total = countRec('IDUSUARIO', 'SEL_USUARIOS_EMPRESA_GRID(' . $params . ',' . $params2 . ')');
$objJson = new Json();
$valorArray = $objJson->objectToArray($result);
$total = $objJson->objectToArray($total);
$total = $total[0]['COUNT'];
//header("Content-type: application/json");
$jsonData = array('page' => $page, 'total' => $total, 'rows' => array());
foreach ($valorArray as $row) {
if ($row['ATIVO'] == 1) {
$row['ATIVO'] = 'Sim';
} else {
$row['ATIVO'] = 'Não';
}
$entry = array('counter' => $row['IDUSUARIO'], 'cell' => array('IDUSUARIO' => $row['IDUSUARIO'], 'NOME' => strtoupper($row['NOME']), 'CODIGO' => $row['CODIGO'], 'IDIDIOMA' => $row['IDIDIOMA'], 'IDIOMA' => $row['IDIOMA'], 'LOGIN' => $row['LOGIN'], 'ATIVO' => $row['ATIVO'], 'TELEFONE' => $row['TELEFONE'], 'IDPERFIL' => $row['IDPERFIL'], 'PERFIL' => $row['PERFIL'], 'OBSERVACAO' => $row['OBSERVACAO']));
$jsonData['rows'][] = $entry;
}
echo json_encode($jsonData);
//print_r($jsonData);
