Hello sematik
I wrote you a link to a page as PM.
Here is serverside code too:
<?php
require('../../Connector/grid_config.php');
require('../../Connector/grid_connector.php');
require('../../Connector/convert.php');
include ('../SQL/config.php');
$user = $_COOKIE["Benutzer"];
$res = mysql_connect($mysql_host, $mysql_user, $mysql_pasw);
mysql_select_db($mysql_db);
$grid = new GridConnector($res, "MySQL");
if($_GET['id'] == "7") {
$disponent = new OptionsConnector($res);
$disponent->render_sql("SELECT id AS value, ma_nachname AS label FROM sk_mitarbeiter WHERE (ma_job = 3 OR ma_job = 99) and ma_x = 0 ORDER BY label ASC","id","id(value),label(label)");
$techniker = new OptionsConnector($res);
$techniker->render_sql("SELECT id AS value, ma_nachname AS label FROM sk_mitarbeiter WHERE (ma_job = 4 OR ma_job = 99) and ma_x = 0 ORDER BY label ASC","id","id(value),label(label)");
$abt = new OptionsConnector($res);
$abt->render_sql("SELECT id AS value, abteilung AS label FROM sk_abteilung","id","id(value),label(label)");
$kst = new OptionsConnector($res);
$kst->render_sql("SELECT id AS value, sub_name AS label FROM sk_subunternehmer","id","id(value),label(label)");
$abbruch = new OptionsConnector($res);
$abbruch->render_sql("SELECT id AS value, abbruch_text AS label FROM sk_abbruch ORDER BY id ASC","id","id(value),label(label)");
$storno = new OptionsConnector($res);
$storno->render_sql("SELECT id AS value, storno_text AS label FROM sk_storno ORDER BY id ASC","id","id(value),label(label)");
$foti = new OptionsConnector($res);
$foti->render_sql("SELECT id AS value, ft_bez AS label FROM sk_folgeticket","id","id(value),label(label)");
$gebiet = new OptionsConnector($res);
$gebiet->render_sql("SELECT id AS value, sub_lager AS label FROM sk_subunternehmer","id","id(value),label(label)");
$janein = new OptionsConnector($res);
$janein->render_sql("SELECT jn_id AS value, jn_text AS label FROM sk_janein","jn_id","jn_id(value),label(label)");
$grid->dynamic_loading(90);
$grid->set_encoding("iso-8859-1");
$grid->set_options("gesl_techniker", $techniker);
$grid->set_options("gesl_disponent", $disponent);
$grid->set_options("wo_stat", $janein);
$grid->set_options("wartung", $janein);
$grid->set_options("wo_abt", $abt);
$grid->set_options("kst", $kst);
$grid->set_options("wo_gebiet", $gebiet);
$grid->set_options("abbruch_id", $abbruch);
$grid->set_options("storno_id", $storno);
$grid->set_options("storno2_id", $storno);
$grid->set_options("folgeticket_id", $foti);
$grid->attach->event("beforeFilter","custom_filter");
$grid->render_sql("SELECT gesl_wonr, wonr_um, kdnr, Concat(LPAD(DayOfMonth(excel_date),2,'0'),'.',LPAD(Month(excel_date),2,'0'),'.',Year(excel_date),' ',LPAD(Hour(excel_date),2,'0'),':',LPAD(Minute(excel_date),2,'0')) AS 'excel_date', wo_typ, wo_abt, wo_stat, CASE wo_gebiet WHEN 0 THEN '' ELSE wo_gebiet END AS wo_gebiet, CASE gesl_techniker WHEN 0 THEN '' ELSE gesl_techniker END AS gesl_techniker, CASE gesl_disponent WHEN 0 THEN '' ELSE gesl_disponent END AS gesl_disponent, Concat(LPAD(DayOfMonth(gesl_termin),2,'0'),'.',LPAD(Month(gesl_termin),2,'0'),'.',Year(gesl_termin),' ',LPAD(Hour(gesl_termin),2,'0'),':',LPAD(Minute(gesl_termin),2,'0')) AS 'gesl_termin', Concat(LPAD(DayOfMonth(wo_start),2,'0'),'.',LPAD(Month(wo_start),2,'0'),'.',Year(wo_start),' ',LPAD(Hour(wo_start),2,'0'),':',LPAD(Minute(wo_start),2,'0')) AS 'wo_start', Concat(LPAD(DayOfMonth(wo_ende),2,'0'),'.',LPAD(Month(wo_ende),2,'0'),'.',Year(wo_ende),' ',LPAD(Hour(wo_ende),2,'0'),':',LPAD(Minute(wo_ende),2,'0')) AS 'wo_ende', Concat(LPAD(DayOfMonth(wo_done),2,'0'),'.',LPAD(Month(wo_done),2,'0'),'.',Year(wo_done),' ',LPAD(Hour(wo_done),2,'0'),':',LPAD(Minute(wo_done),2,'0')) AS 'wo_done', kw, CASE kst WHEN 0 THEN '' ELSE kst END AS kst, CASE abbruch_id WHEN 0 THEN '' ELSE abbruch_id END AS abbruch_id, CASE storno_id WHEN 0 THEN '' ELSE storno_id END AS storno_id, CASE storno2_id WHEN 0 THEN '' ELSE storno2_id END AS storno2_id, CASE folgeticket_id WHEN 0 THEN '' ELSE folgeticket_id END AS folgeticket_id, anlnr_intern, wartung, gesl_spin_gemeldet, gesl_spin_summe, adr_up, CONCAT(substring(kd_vorname,1,1),'. ',kd_nachname) AS name, kd_strasse, kd_hsnr, kd_hsnr_zus, kd_plz, kd_ort, gesl_arbeiten, gesl_memo, gesl_abbruch FROM sk_gesamtliste AS A INNER JOIN sk_auftraege AS B ON A.gesl_wonr = B.wonr_intern INNER JOIN sk_kundenstamm AS C ON A.gesl_kdnr = C.id WHERE B.gesamtliste = 1 AND YEAR(upload_date) = ".$_GET['jahr']." ORDER BY gesl_wonr DESC","gesl_id","gesl_wonr, wonr_um, kdnr, excel_date, wo_typ, wo_abt, wo_stat, wo_gebiet, gesl_techniker, gesl_disponent, gesl_termin, wo_start, wo_ende, wo_done, kw, kst, abbruch_id, storno_id, storno2_id, folgeticket_id, anlnr_intern, wartung, gesl_spin_gemeldet, gesl_spin_summe, adr_up, name, kd_strasse, kd_hsnr, kd_hsnr_zus, kd_plz, kd_ort, gesl_arbeiten, gesl_memo, gesl_abbruch");
}
?>
Thank you