getAll( $sql ); $used = Array(); if( $anzahl = count($rs) ) { echo "\n"; echo "\n\n"; $i = 0; foreach ( $rs as $row ) { if ( $row["bezug"] > 0 and in_array($row["bezug"], $used) ) continue; if ( $row["bezug"]==0 ) $used[]=$row["id"]; if ( strlen($row["cause"]) > 30 ) { $cause = substr($row["cause"], 0, 30).".."; } else { $cause = $row["cause"]; }; if ( $row["kname"] ) { $name = $row["kname"]; $src="C"; } else if ( $row["lname"] ) { $name = $row["lname"]; $src="V"; } else if ( $row["pname"] ) { $name = $row["pname"]; $src="CC"; } else { $name = ""; $src='S'; } echo ""; echo "\n"; $i++; if ($i>=$_SESSION['listLimit']) { $d = "dialog_viele"; break; } } echo "

Datum	Grund	Name
".db2date($row["calldate"])."	".$cause."	"; echo "$name

\n
"; } else $d = "dialog_keine"; } else if ($_POST["submit"] == "adress") { include("../inc/FirmenLib.php"); include("../inc/persLib.php"); include_once("../inc/UserLib.php"); $suchwort = mkSuchwort($_POST["swort"]); $rsE = $rsV = $rsC = $rsK = false; if ( $_POST['swort'] != '') { $rsC = getAllFirmen($suchwort,true,"C"); if ( $rsC ) $anzahl = count($rsC); if ( $anzahl <= $_SESSION['listLimit'] ) { $rsV = getAllFirmen($suchwort,true,"V"); if ( $rsV ) $anzahl += count($rsV); if ( $anzahl <= $_SESSION['listLimit'] ) { $rsK = getAllPerson($suchwort); if ( $rsK ) $anzahl += count($rsK); if ( $anzahl <= $_SESSION['listLimit'] ) { $rsE = getAllUser($suchwort); if ( $rsE ) $anzahl += count($rsE); if ( $anzahl >= $_SESSION['listLimit'] ) { $d = "dialog_viele"; } else if ($anzahl === 0) $d = "dialog_keine"; } else $d = "dialog_viele"; } else $d = "dialog_viele"; } else $d = "dialog_viele"; } if ( $anzahl > 0 ) { if ( $anzahl == 1 && $rsC ){ echo ''; exit(); } if ( $anzahl == 1 && $rsV ) { echo ''; exit(); } if ( $anzahl == 1 && $rsK ) { echo ''; exit(); } if ( $anzahl == 1 && $rsE ) { echo ''; exit(); } echo "\n"; echo "\n"; echo "\n"; $i=0; if ( $rsC && $i < $_SESSION['listLimit'] ) foreach($rsC as $row) { echo "". "". "\n"; $i++; } if ( $rsV && $i < $_SESSION['listLimit'] ) foreach($rsV as $row) { echo "". "". "\n"; $i++; } if ( $rsK && $i < $_SESSION['listLimit'] ) foreach($rsK as $row) { echo "". "". "\n"; $i++; } if ( $rsE && $i < $_SESSION['listLimit']) foreach($rsE as $row) { echo "". "". "\n"; $i++; } echo "

KD-Nr	Name	Anschrift	Telefon
".$row["customernumber"]."	".$row["name"]."	".$row["city"].(($row["street"])?", ":"").$row["street"]."	".$row["phone"]."	K
".$row["vendornumber"]."	".$row["name"]."	".$row["city"].(($row["street"])?", ":"").$row["street"]."	".$row["phone"]."	L
".$row["cp_id"]."	".$row["cp_name"].", ".$row["cp_givenname"]."	".$row["cp_city"].(($row["cp_street"])?", ":"").$row["cp_street"]."	".$row["cp_phone1"]."	P
".$row["id"]."	".$row["name"]."	".$row["addr2"].(($row["addr1"])?", ":"").$row["addr1"]."	".$row["workphone"]."	U

\n"; } } //END ELSEIF adress if ( $anzahl >= $_SESSION['listLimit'] ) $d = "dialog_viele"; echo ' '; if ( $anzahl > 10 ) echo '

'.($anzahl < $_SESSION['listLimit'] ? $anzahl : $_SESSION['listLimit']).' 10 20 30 40

'; ?>