This is the code that generated query:
<?phpinclude("../../include/funciones.php");/* variables */$json = '[';$campos = array("Continent,Population");$tabla = "country";$condicion = "1 group by Continent";$ordenamiento = array("1");$cont = 0;$cadenaFecha = '';/* consulta */$listado = consultar($campos, $tabla, $condicion, $ordenamiento);class country { public $continent = ''; public $population = ''; public $color = '';}function random_color_part() { return str_pad(dechex(mt_rand(0, 255)), 2, '0', STR_PAD_LEFT); } function random_color() { return random_color_part() . random_color_part() . random_color_part(); }$totalFilas = mysql_num_rows($listado);if (mysql_num_rows($listado) != 0) { while ($reg = mysql_fetch_assoc($listado)) { $color = '#'.random_color(); $objetoCountry = new country(); $objetoCountry->continent = $reg["Continent"]; $objetoCountry->population = $reg["Population"]; $objetoCountry->color = $color; if ($cont == $totalFilas - 1) $json = $json . json_encode($objetoCountry); else $json = $json . json_encode($objetoCountry) . ","; $cont++; } $json = $json . ']'; echo $json;} else echo 'false';?>
This is the js code:
$(document).ready(function() {
peticion_ajax();
});
function peticion_ajax()//se carga el select el personal del centro
{
var xhr = $.ajax({
url: "generar_consulta.php",
dataType: "text",
cache: false,
statusCode: {
404: function() {
alert("La página no existe (personal cabecera)");
}
},
context: document.body
}).done(function(data) {//callBack
var obj = {width: 700, height: 400, title: "Grid From JSON data", flexHeight: true};
obj.colModel = [{title: "Rank", width: 100, dataType: "integer", dataIndx: "rank"},
{title: "Company", width: 200, dataType: "string", dataIndx: "company"},
{title: "Revenues ($ millions)", width: 150, dataType: "float", align: "right", dataIndx: "revenues"},
{title: "Profits ($ millions)", width: 150, dataType: "float", align: "right", dataIndx: "profits",
render: function(ui) {
var rowData = ui.rowData,
dataIndx = ui.dataIndx,
cellData = rowData[dataIndx],
profits = cellData.replace(",", ""),
revenues = rowData["revenues"].replace(",", "");
if (profits / revenues > 0.1) {
return "<span style='color:green;'>" + cellData + "</span>";
}
else {
return "<span style='color:red;'>" + cellData + "</span>";
}
}
}];
obj.dataModel = {
data: data,
location: "local",
sorting: "local",
paging: "local",
curPage: 1,
rPP: 10,
sortIndx: "revenues",
sortDir: "up",
rPPOptions: [1, 10, 20, 30, 40, 50, 100, 500, 1000]
};
$("#grid_array").pqGrid(obj);
xhr.abort();
});
}This is the html code:
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
<!-- Jquery General -->
<script type="text/javascript" src="../../include/jquery-ui-1.10.3.custom/js/jquery-1.9.1.js"></script>
<script type="text/javascript" src="../../include/jquery-ui-1.10.3.custom/js/jquery-ui-1.10.3.custom.js"></script>
<!--PQ Grid files-->
<link rel="stylesheet" href="grid/pqgrid.min.css" />
<script src="grid/pqgrid.min.js"></script>
<!--PQ Grid Office theme-->
<link rel="stylesheet" href="grid/themes/office/pqgrid.css" />
<!-- Jquery General -->
<script type="text/javascript" src="funciones.js"></script>
</head>
<body>
<div id="grid_array" style="margin:100px;">
</div>
<span id="results">
</span>
</body>
</html>the error is:
Uncaught TypeError: undefined is not a function pqgrid.min.js:9
event.returnValue is deprecated. Please use the standard event.preventDefault() instead.
