-<?
+<?php
/*
Funktionsbibliothek für den Datenimport in Lx-Office ERP
"unit" => "Einheit",
"weight" => "Gewicht in Benutzerdefinition",
"onhand" => "Lagerbestand",
+ "bin" => "Lagerplatz",
"notes" => "Beschreibung",
"notes1" => "Beschreibung",
//"makemodel" => "Hersteller",
}
function getKdId() {
-// die nächste freie Kunden-/Lieferantennummer holen
+// die nächste freie Kunden-/Lieferantennummer holen
global $db,$file,$test;
if ($test) { return "#####"; }
$sql1="select * from defaults";
function mkland($data) {
global $land;
- $data=strtr($data,array("Ö"=>"OE","Ä"=>"AE","Ü"=>"UE","ö"=>"OE","ä"=>"AE","ü"=>"UE","ß"=>"SS"));
+ $data=strtr($data,array("Ö"=>"OE","Ä"=>"AE","Ü"=>"UE","ö"=>"OE","ä"=>"AE","ü"=>"UE","ß"=>"SS",
+ 'Ö'=>'OE','Ä'=>'AE','Ü'=>'UE','ö'=>'OE','ä'=>'AE','ü'=>'UE','ß'=>'SS'));
$data=strtoupper(substr($data,0,6));
$cntr=$land[$data];
return (strlen($cntr)>0)?$cntr:substr($data,0,3);
$dbhost=($hits[1])?$hits[1]:"localhost";
preg_match("/'port'[ ]*=> '(.+)'/",$tmp,$hits);
$dbport=($hits[1])?$hits[1]:"5432";
- preg_match("/^[ ]*\$self->\{cookie_name\}[ ]*=[ ]*'(.+)'/",$tmp,$hits);
+ preg_match("/[ ]*\\\$self->\{cookie_name\}[ ]*=[ ]*'(.+)'/",$tmp,$hits);
$cookiename=$hits[1];
if (!$cookiename) $cookiename='lx_office_erp_session_id';
$cookie=$_COOKIE[$cookiename];
return $auth;
}
+function getLager($db) {
+ $sql="select w.description as ort,bin.id,bin.description as platz from warehouse w left join bin on w.id=bin.warehouse_id";
+ $rs=$db->getAll($sql,"getLager");
+ return $rs;
+}
+?>