-<?
+<?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";
$sql2="update defaults set ".$file."number = '%s'";
- $db->lock();
+ $db->begin();
$rs=$db->getAll($sql1);
$nr=$rs[0][$file."number"];
preg_match("/^([^0-9]*)([0-9]+)/",$nr,$hits);
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];
$db->query($sql2,"authuser_B");
$sql3="insert into session ";*/
}
+ $sql="select * from auth.user where id=".$rs[0]["id"];
+ $rs1=$db->getAll($sql,"authuser_1");
+ if (!$rs1) return false;
+ $auth=array();
+ $auth["login"]=$rs1[0]["login"];
$sql="select * from auth.user_config where user_id=".$rs[0]["id"];
$rs1=$db->getAll($sql,"authuser_2");
- $auth=array();
- $keys=array("login","dbname","dbpasswd","dbhost","dbport","dbuser");
+ $keys=array("dbname","dbpasswd","dbhost","dbport","dbuser");
foreach ($rs1 as $row) {
if (in_array($row["cfg_key"],$keys)) {
$auth[$row["cfg_key"]]=$row["cfg_value"];
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;
+}
+?>