Hi,
Can’t understand to what that related . Error : This page contains the following errors:
error on line 1 at column 82: XML declaration allowed only at the start of the document
Below is a rendering of the page up to the first error.
Grid javascript code :
var grd = new Array();
$app_lng = document.getElementById( "myLang" ).options[ document.getElementById( "myLang" ).selectedIndex ].value;
$app_db = document.getElementById( "myDb" ).options[ document.getElementById( "myDb" ).selectedIndex ].value;
// grid construction array
grd[ 0 ] = [];
grd[ 0 ].push( "uzsak" );
grd[ 0 ].push( "ro" );
grd[ 0 ].push( "150" );
grd[ 0 ].push( "#connector_text_filter" );
grd[ 0 ].push( "left" );
grd[ 0 ].push( "connector" );
grd[ 0 ].push( "Užsak.ID" );
grd[ 0 ].push( "Order.ID" );
grd[ 1 ] = [];
grd[ 1 ].push( "telkinys" );
grd[ 1 ].push( "ed" );
grd[ 1 ].push( "80" );
grd[ 1 ].push( "#connector_text_filter" );
grd[ 1 ].push( "left" );
grd[ 1 ].push( "connector" );
grd[ 1 ].push( "Telkinys" );
grd[ 1 ].push( "Pool" );
// ... other cols ...
grd[ 31 ] = [];
grd[ 31 ].push( "pastabos_zs" );
grd[ 31 ].push( "txt" );
grd[ 31 ].push( "180" );
grd[ 31 ].push( "#connector_text_filter" );
grd[ 31 ].push( "left" );
grd[ 31 ].push( "connector" );
grd[ 31 ].push( "Pastabos Zarasu" );
grd[ 31 ].push( "Notes of Zarasai" );
grd[ 32 ] = [];
grd[ 32 ].push( "pok_lap_mod" );
grd[ 32 ].push( "ed" );
grd[ 32 ].push( "150" );
grd[ 32 ].push( "#connector_text_filter" );
grd[ 32 ].push( "left" );
grd[ 32 ].push( "connector" );
grd[ 32 ].push( "Pokav.lapo modelis" );
grd[ 32 ].push( "Pack.list model" );
var dgr = grid_array( "uzsakym" );
var grd_set = grid_set( "uzsakym", grd, dgr );
var slc_fld = grd_set[ 0 ];
var u = 0;
var mod_col = 2;
var kiek_col = 3;
var ch_ro = new Array();
var datw1 = new Array();
var datw2 = new Array();
var slc_arr = slc_fld.split( "," );
var cQry = "uzs1.php?fld=" + slc_fld + "&d_b=" + $app_db;
var toolbar = tabbar.cells( tabbar.getActiveTab() ).attachToolbar();
toolbar.setIconsPath( "images/" );
var newOpts =
Array( Array( 'new1', 'obj', ( $app_lng == 'lt' ? 'Naujas(plius)' : 'New(add)' ) + " - Plus", 'New.png'),
Array( 'new2', 'obj', ( $app_lng == 'lt' ? 'Pervesti' : 'Transfer' ) , 'Attachment.png' ),
Array( 'sep1', 'sep', '', '' ),
Array( 'new3', 'obj', ( $app_lng == 'lt' ? 'Sukirp.lapai' : 'Cutting pages' ), 'Pages.png' ) );
toolbar.addButtonSelect( "new", 0, "", newOpts, "New.png" );
toolbar.setItemToolTip( "new", ( $app_lng == 'lt' ? 'Nauji įrašai' : 'New records' ) );
toolbar.addSeparator("sep2", 1);
toolbar.addButton( "delete", 2, "", "Delete.png" );
toolbar.setItemToolTip( "delete", ( $app_lng == 'lt' ? 'Šalinti' : 'Delete' ) + " - Del" );
// ...
var mygrid = tabbar.cells( tabbar.getActiveTab() ).attachGrid();
mygrid.setImagePath( "codebase/imgs/" );
mygrid.setColumnIds( slc_fld )
mygrid.setHeader( grd_set[ 1 ] );
mygrid.attachHeader( grd_set[ 2 ] );
mygrid.setColTypes( grd_set[ 3 ] );
mygrid.setColSorting( grd_set[ 4 ] );
mygrid.setInitWidths( grd_set[ 5 ] )
mygrid.setColAlign( grd_set[ 6 ] )
mygrid.setColumnsVisibility( grd_set[ 7 ] );
mygrid.setDateFormat( "%Y.%m.%d" );
mygrid.enableSmartRendering( true, 100 );
mygrid.init();
mygrid.load( cQry );
myDp = new dataProcessor( cQry );
myDp.init( mygrid );
//myDp.enableDataNames( true );
mygrid.enableMultiselect( true );
mygrid.enableHeaderMenu();
mygrid.enableColumnMove( true );
mygrid.enableUndoRedo();
mygrid.setAwaitedRowHeight( 22 );
Php code :
<?php
require_once( "config.php" );
require( "php/codebase/grid_connector.php" );
require( "php/codebase/db_mysqli.php" );
$slc_fld = $_GET[ 'fld' ];
$slc_db = $_GET[ 'd_b' ];
function grid_serv_filter( $filter_by )
{
$num_arr = array();
$num_arr[] = "uzs_kiekis";
$num_arr[] = "prilyg_kiekis";
$num_arr[] = "kainos_proc";
$arr_lik = array();
$arr_lik[] = "uzsak";
$arr_lik[] = "telkinys";
$arr_lik[] = "preke";
$arr_lik[] = "uzs_spalv";
$arr_lik[] = "pastabos_ord";
$arr_lik[] = "zymos";
$arr_lik[] = "sukirp_lap";
$arr_lik[] = "plan_modelis";
$arr_lik[] = "pastabos_buh";
$arr_lik[] = "pastabos_zs";
foreach ( $arr_lik as &$value )
{
$index = $filter_by->index( $value );
if ( $index !== false )
{
$cVal = $filter_by->rules[ $index ][ "value" ];
if ( strlen( $cVal ) > 0 )
{
$cVal = $filter_by->rules[ $index ][ "value" ];
if ( substr( $cVal, 0, 1 ) == "%" )
$cVal = substr( $cVal, 1 );
$filter_by->rules[ $index ][ "operation" ] = " LIKE ";
$filter_by->rules[ $index ][ "value" ] = $cVal."%";
}
}
}
foreach ( $num_arr as &$value )
{
$index = $filter_by->index( $value );
if ( $index !== false )
{
$cVal = $filter_by->rules[ $index ][ "value" ];
if ( strlen( $cVal ) > 0 )
{
include 'num_oper.php';
$arr = num_filter( $cVal );
if ( count( $arr ) > 0 )
{
if ( $arr[ 0 ] !== 'nera' )
$filter_by->rules[ $index ][ "value" ] = $arr[ 0 ];
$filter_by->rules[ $index ][ "operation" ] = $arr[ 1 ];
if ( count( $arr ) == 3 )
$filter_by->add( $value, $arr[ 2 ], "<=" );
}
}
}
}
}
$link = new mysqli( $myServ, $myUser, $myPasw, $myDb );
if ( $link->connect_errno )
die( 'Prisijungimo klaida : (' . $link->connect_errno . ') ' . $link->connect_error );
$grid = new GridConnector( $link, "MySQLi" );
$grid->dynamic_loading( 100 );
//$grid->enable_log( "temp.log", true );
$slct = new OptionsConnector( $link, "MySQLi" );
$slct->render_sql( "select preke as value, preke as label from prekes where prek_tipas = 'Gaminys' and db = '".$slc_db."' order by preke asc", "", "preke(value),preke(label)" );
$grid->set_options( "preke", $slct );
$grid->event->attach( "beforeFilter", "grid_serv_filter" );
$grid->render_sql( "select ".$slc_fld." from uzsakym where uzsakym.db = '".$slc_db."'", "uzsak", $slc_fld );
//$grid->render_table( "uzsakym", "uzsak", $slc_fld );
?>
XML request :
<?xml version="1.0" encoding="iso-8859-1"?><data><action type='update' sid='' tid=''/></data><?xml version='1.0' encoding='utf-8' ?><rows total_count='39270'><row id='100000'><cell><![CDATA[100000]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[2626-634]]></cell><cell><![CDATA[21.000]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[6]]></cell><cell><![CDATA[2011.03.25]]></cell><cell><![CDATA[2011.12]]></cell><cell><![CDATA[2011.05.06]]></cell><cell><![CDATA[2011.18]]></cell><cell><![CDATA[2011.05.06]]></cell><cell><![CDATA[2011.18]]></cell><cell><![CDATA[ALL LT]]></cell><cell><![CDATA[FR/*]]></cell><cell><![CDATA[Zarasai]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[2011.04.06]]></cell><cell><![CDATA[UT]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[122-785]]></cell><cell><![CDATA[105.000]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[2626785]]></cell></row>
<row id='1000001'><cell><![CDATA[1000001]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[3600-785]]></cell><cell><![CDATA[20.000]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[8]]></cell><cell><![CDATA[2011.10.21]]></cell><cell><![CDATA[2011.42]]></cell><cell><![CDATA[2011.11.11]]></cell><cell><![CDATA[2011.45]]></cell><cell><![CDATA[2006.01.10]]></cell><cell><![CDATA[2006.02]]></cell><cell><![CDATA[darbo rubai musu]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[Zarasai]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[UT]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[3600-785]]></cell><cell><![CDATA[20.000]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell></row>
<row id='100000A'><cell><![CDATA[100000A]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[0250-310]]></cell><cell><![CDATA[6.000]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[8]]></cell><cell><![CDATA[2011.10.21]]></cell><cell><![CDATA[2011.42]]></cell><cell><![CDATA[2011.11.18]]></cell><cell><![CDATA[2011.46]]></cell><cell><![CDATA[2006.01.10]]></cell><cell><![CDATA[2006.02]]></cell><cell><![CDATA[mod 0249...0250, 0650 pvz nepokuoti]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[Zarasai]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[UT]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0250-310]]></cell><cell><![CDATA[6.000]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell></row>
<row id='100000B'><cell><![CDATA[100000B]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[0352-315]]></cell><cell><![CDATA[10.000]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[2011.10.21]]></cell><cell><![CDATA[2011.42]]></cell><cell><![CDATA[2011.11.18]]></cell><cell><![CDATA[2011.46]]></cell><cell><![CDATA[2006.01.10]]></cell><cell><![CDATA[2006.02]]></cell><cell><![CDATA[mod 0350, 0351, 0352, 0353, 0750 pvz]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[Zarasai]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[UT]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[0352-315]]></cell><cell><![CDATA[10.000]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell></row>
... 100 row ...
<coll_options for='2'><item value='00' label='00'></item>
<item value='002-780' label='002-780'></item>
<item value='01' label='01'></item>
<item value='010 REFL.' label='010 REFL.'></item>
<item value='011 REFL.2' label='011 REFL.2'></item>
..
<item value='97-630' label='97-630'></item>
<item value='A' label='A'></item>
<item value='OLD1600-780' label='OLD1600-780'></item>
<item value='OLD2600-785' label='OLD2600-785'></item>
<item value='OLD3600-785' label='OLD3600-785'></item>
<item value='OLD4600-785' label='OLD4600-785'></item>
<item value='OLD6600-780' label='OLD6600-780'></item>
<item value='R1234-820' label='R1234-820'></item>
<item value='R1934-820' label='R1934-820'></item>
<item value='R2234-825' label='R2234-825'></item>
<item value='R3234-825' label='R3234-825'></item>
<item value='R4234-825' label='R4234-825'></item>
<item value='SPEC.' label='SPEC.'></item>
<item value='T' label='T'></item>
<item value='WZPOA' label='WZPOA'></item>
<item value='ZARASAI' label='ZARASAI'></item>
</coll_options><coll_options for='4'><item value='0'></item>
<item value='1'></item>
</coll_options><coll_options for='5'><item value='0'></item>
<item value='1'></item>
</coll_options><coll_options for='6'><item value='0'></item>
<item value='1'></item>
</coll_options><coll_options for='16'><item value='Zarasai'></item>
<item value='Danija'></item>
<item value='F*'></item>
<item value='FR*'></item>
<item value='F/*'></item>
<item value='RF/*'></item>
<item value='MF/*'></item>
<item value='1/2'></item>
<item value='1/M2'></item>
<item value='1+2'></item>
</coll_options><coll_options for='20'><item value='UT'></item>
<item value='BR'></item>
<item value='JD'></item>
<item value='BIG'></item>
<item value='SGR'></item>
<item value='ZR'></item>
<item value=''></item>
<item value='BG'></item>
<item value='FD'></item>
<item value='127645'></item>
<item value='128055'></item>
<item value='129110'></item>
<item value='129944'></item>
<item value='129945'></item>
</coll_options><coll_options for='21'><item value='0'></item>
<item value='1'></item>
</coll_options><coll_options for='22'><item value='0'></item>
<item value='1'></item>
</coll_options><coll_options for='23'><item value='0'></item>
<item value='1'></item>
</coll_options><coll_options for='24'><item value='1'></item>
<item value='0'></item>
</coll_options><coll_options for='25'><item value='1'></item>
<item value='0'></item>
</coll_options><coll_options for='26'><item value='0'></item>
<item value='1'></item>
</coll_options><coll_options for='30'><item value='0'></item>
<item value='1'></item>
</coll_options></rows>
No errors in temp.log :
====================================
Log started, 13/12/2012 06:12:33
====================================
SELECT preke as value, preke as label FROM prekes WHERE ( prek_tipas = 'Gaminys' and db = 'ut') ORDER BY `preke` ASC
SELECT DISTINCT `svarbus` as value FROM uzsakym
SELECT DISTINCT `specai` as value FROM uzsakym
SELECT DISTINCT `mazi` as value FROM uzsakym
SELECT DISTINCT `kerpa` as value FROM uzsakym
SELECT DISTINCT `subrang` as value FROM uzsakym
SELECT DISTINCT `aud_nuras` as value FROM uzsakym
SELECT DISTINCT `frn_nuras` as value FROM uzsakym
SELECT DISTINCT `invc_nuras` as value FROM uzsakym
SELECT DISTINCT `nav_nuras` as value FROM uzsakym
SELECT DISTINCT `pasel_prad` as value FROM uzsakym
SELECT DISTINCT `pokav_prad` as value FROM uzsakym
SELECT DISTINCT `buh_specas` as value FROM uzsakym
SELECT `uzsak`,`uzsak`,`telkinys`,`preke`,`uzs_kiekis`,`svarbus`,`specai`,`mazi`,`uzs_spalv`,`uzs_data`,`uzs_sav`,`graz_data`,`graz_sav`,`fakt_data`,`fakt_sav`,`pastabos_ord`,`zymos`,`kerpa`,`sukirp_lap`,`etiketes`,`gav_data`,`subrang`,`aud_nuras`,`frn_nuras`,`invc_nuras`,`nav_nuras`,`pasel_prad`,`pokav_prad`,`prilyg_mod`,`prilyg_kiekis`,`pastabos_buh`,`buh_specas`,`pastabos_zs`,`pok_lap_mod` FROM uzsakym LIMIT 0,100
SELECT COUNT(*) as DHX_COUNT FROM uzsakym
Done in 0.72461700439453s
All was working and now I’m getting this error . Dhtmlx Suite Pro 3.5
Many thanks in advance !