X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/565340a0b891da16f6055342d19b79552e8a789b..165fae209dd92f3085bd4e2db98d505d2fc1b9e2:/lxo-import/import_lib.php diff --git a/lxo-import/import_lib.php b/lxo-import/import_lib.php index 6d9dd879b..5d282030e 100644 --- a/lxo-import/import_lib.php +++ b/lxo-import/import_lib.php @@ -224,7 +224,23 @@ function getKdRefId($data) { $rs=$db->getAll($sql); return $rs[0]["id"]; } - +/** + * TODO: short description. + * + * @param mixed $tab + * @param object $own + * @param mixed $fld + * @param mixed $val + * + * @return TODO + */ +function insertExtra($tab,$own,$fld,$val) { + global $db; + $sql = "insert into extra_felder (fkey,fval,tab,owner) "; + $sql.= "values ('$fld','$val','$tab','$own')"; + $rc = $db->query($sql); + return $rc; +} function suchFirma($tab,$data) { // gibt die Firma ? global $db; @@ -237,7 +253,7 @@ function suchFirma($tab,$data) { if (!$rs) { $org=$data; while(strpos($data," ")>0) { - $data=ereg_replace(" "," ",$data); + $data=str_replace(" "," ",$data); } $data=preg_replace("/[^A-Z0-9]/ ",".*",trim($data)); $sql="select * from $tab where upper(name) ~ '$data'"; @@ -259,13 +275,13 @@ function getFirma($nummer,$tabelle) { $sql="select id from $tabelle where upper(".$tabelle."number) = '$nummer'"; $rs=$db->getAll($sql); if (!$rs) { - $nr=ereg_replace(" ","%",$nummer); + $nr=str_replace(" ","%",$nummer); $sql="select id,".$tabelle."number from $tabelle where upper(".$tabelle."number) like '$nr'"; $rs=$db->getAll($sql); if ($rs) { - $nr=ereg_replace(" ","",$nummer); + $nr=str_replace(" ","",$nummer); foreach ($rs as $row) { - $tmp=ereg_replace(" ","",$row[$tabelle."number"]); + $tmp=str_replace(" ","",$row[$tabelle."number"]); if ($tmp==$nr) return $row["id"]; } } else {