File Source for rpc.xmlgrid.php

<?php
/**
* File di gestione della tabella dinamica dhtmlGrid.
* Viene richiamato dallo script {@link scheda.php} e dalle funzioni javascript.
*
* @package VFront
* @subpackage RPC
* @author Mario Marcello Verona <marcelloverona@gmail.com>
* @copyright 2007 Mario Marcello Verona
* @version 0.90
* @license http://www.gnu.org/licenses/gpl.html GNU Public License
*/
require("./inc/conn.php");
require("./inc/func.frontend.php");
require("./inc/func.comuni.php");
proteggi(1);
/**
* Da una query SQL viene restituito l'XML generato per la griglia dxhtmlGrid
*
* @param string $sql
* @param int $offset
* @param string $filename
* @param bool $header
* @param string $PK
* @return void
*/
function xmlize_grid($sql,$offset=0,$filename=null,$header=true,$PK=null){
global $link,$_VARIABILI;
$q = vmsql_query($sql,$link);
if(vmsql_num_rows($q)==0){
return null;
}
// Inizia a fare l'xml
$offset++;
$XML= ($header) ? "<?xml version='1.0' encoding='utf-8'?>\n" : "";
$XML.="<rows>\n";
while($RS=vmsql_fetch_assoc($q)){
# Se è un contesto di ricerca...
if(isset($_GET['q'])){
# identificativo ($RS)
$offset_ricerca=$RS['n_offset']+1;
$XML.="\t".xmlize_campo('row',array("id"=>$RS['pk']))."\n";
$XML.="\t\t<cell>".$offset_ricerca."</cell>\n";
}
else{
# identificativo (offset)
$XML.="\t".xmlize_campo('row',array("id"=>$RS['pk']))."\n";
$XML.="\t\t<cell>".$offset."</cell>\n";
}
foreach($RS as $k=>$val){
// Il campo speciale prendi valore imposta l'offset per la ricerca
if($k!='pk'){
$XML.="\t\t".xmlize_campo('cell',array());
$val = utf8_encode(trim($val));
if(isset($_VARIABILI['max_char_tabella']) && intval($_VARIABILI['max_char_tabella'])>0){
if(strlen($val)>$_VARIABILI['max_char_tabella']) $val = substr($val,0,$_VARIABILI['max_char_tabella'])."...";
}
// togli new line e sostituisci gli spazi
$val = str_replace(array(" ","-","\n","\r","\n\r","\r\n"),array(" "," ","","","",""),$val);
if($val!='' && !is_numeric($val)) $val="<![CDATA[".$val."]]>";
$XML.=$val;
$XML.="</cell>\n";
}
}
$XML.="\t</row>\n";
$offset++;
}
$XML.="</rows>\n";
if(is_null($filename)){
if ( stristr($_SERVER["HTTP_ACCEPT"],"application/xhtml+xml") ) {
header("Content-type: application/xhtml+xml");
}
else {
header("Content-type: text/xml");
}
print $XML;
}
else{
$fp =fopen($filename,"w");
fwrite($fp,$XML);
fclose($fp);
return true;
}
}
/**
* Genera l'XML dal campo dato con gli eventuali attributi
*
* @param string $tag
* @param array $attr
* @return string
*/
function xmlize_campo($tag,$attr){
$attributi="";
foreach($attr as $k=>$val){
$attributi .=" $k=\"$val\"";
}
return "<".$tag.$attributi.">";
}
##########################################################################################################
$tabella = $_GET['t'];
if(!is_tabella($tabella)){
echo "Tabella inesistente";
exit;
}
$OFFSET = (isset($_GET['rowsLoaded'])) ? intval($_GET['rowsLoaded']) : 0;
// altro modo di prendere l'offset... e sovrascrivo.
$OFFSET = (isset($_GET['of'])) ? intval($_GET['of']) : $OFFSET;
// PRENDI CAMPI VISIBILI
// $info_campi = prendi_colonne_frontend($tabella,"column_name",false);
$sql_campi_tab="SELECT column_name FROM {$db1['frontend']}.registro_col c, {$db1['frontend']}.registro_tab t
WHERE c.id_table=t.id_table
AND t.table_name='$tabella'
AND t.gid='".intval($_SESSION['gid'])."'
AND c.in_table=1
ORDER BY c.ordinal_position";
$q_info_campi_tab = vmsql_query($sql_campi_tab,$link);
$info_campi = vmsql_fetch_row_all($q_info_campi_tab,true);
list($column_name) = $info_campi;
unset($info_campi);
if(!isset($_VARIABILI)){
include("./inc/func.var_frontend.php");
var_frontend();
}
// Prendi la variabile di LIMIT
$LIMIT = (isset($_VARIABILI['n_record_tabella']) && ($_VARIABILI['n_record_tabella']>0))
? $_VARIABILI['n_record_tabella'] : 20;
$campi_vis=implode(',',$column_name);
// Genera l'order BY
if(isset($_GET['ord'])){
$orderby_val = addslashes(stripslashes($_GET['ord']));
$ORDERBY = (is_campo($orderby_val)) ? "ORDER BY ".$orderby_val : "";
}
else{
$orderby_val = prendi_orderby($tabella,$_SESSION['gid']);
$ORDERBY = ($orderby_val!="") ? "ORDER BY ".$orderby_val : "";
}
// prendi la chiave primaria:
$PK = prendi_PK($tabella);
######################################################################
#
# RISPOSTA DI RICERCA CON MOLTI RISULTATI:
#
#
if(isset($_GET['q'])){
$ids = str_replace("|" , "','" , addslashes($_GET['q']));
$WHERE = " WHERE $PK IN ('".$ids."') ";
$orderby_campo = str_replace(array("ASC","DESC"),"",$orderby_val);
// Imposto un alias per
$campi_vis_rep = str_replace("$orderby_campo", "$orderby_campo as prendi_valore", $campi_vis);
$sql ="SELECT $PK as pk, $campi_vis ".
"
FROM $tabella
$WHERE
$ORDERBY
".limit_sintax($LIMIT,$OFFSET);
rpc_debug($sql);
}
######################################################################
#
# TABELLA NORMALE
else {
$sql="SELECT $PK as pk, $campi_vis
FROM $tabella
$ORDERBY
".limit_sintax($LIMIT,$OFFSET);
rpc_debug($sql);
}
// mando il file
// DEBUG :
// xmlize_grid($sql,$OFFSET,'test.xml',true,$PK);
xmlize_grid($sql,$OFFSET,null,true,$PK);
?>

	VFront RPC

[ class tree: VFront ] [ index: VFront ] [ all elements ]

Source for file rpc.xmlgrid.php