Revision fbe32862
Von Holger Lindemann vor mehr als 15 Jahren hinzugefügt
| lxo-import/import_lib.php | ||
|---|---|---|
|
<?
|
||
|
<?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);
|
||
| ... | ... | |
|
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;
|
||
|
}
|
||
|
?>
|
||
| lxo-import/partsB.php | ||
|---|---|---|
|
clearstatcache ();
|
||
|
|
||
|
$test = $_POST["test"];
|
||
|
$lager = $_POST["lager"];
|
||
|
$TextUpd = $_POST["TextUpd"];
|
||
|
$trenner = ($_POST["trenner"])?$_POST["trenner"]:",";
|
||
|
$trennzeichen = ($_POST["trennzeichen"])?$_POST["trennzeichen"]:"";
|
||
| ... | ... | |
|
$_test=$_POST;
|
||
|
$_test["precision"]=-1;
|
||
|
$_test["quotation"]=0;
|
||
|
$_test["lager"]=$_POST["lager"];
|
||
|
$_test["lagerplatz"]=$_POST["lagerplatz"];
|
||
|
//$_test["shop"]="n";
|
||
|
//$_test["wgtrenner"]="!";
|
||
|
$err = import_parts($db, $file, $trenner, $trennzeichen, $parts, TRUE, FALSE, FALSE,$_test);
|
||
| ... | ... | |
|
|
||
|
} else {
|
||
|
$bugrus=getAllBG($db);
|
||
|
$lagerplatz=getLager($db);
|
||
|
?>
|
||
|
|
||
|
<p class="listtop">Artikelimport für die ERP<p>
|
||
| ... | ... | |
|
<input type="radio" name="bugrufix" value="1" checked>für alle Artikel verwenden
|
||
|
<input type="radio" name="bugrufix" value="2">für Artikel ohne passende Bugru
|
||
|
</td></tr>
|
||
|
<tr><td>Default Lager<br></td><td><select name="lager">
|
||
|
<? if ($lagerplatz) foreach ($lagerplatz as $lp) { ?>
|
||
|
<option value="<?= $lp["id"] ?>"><?= $lp["ort"] ?>-<?= $lp["platz"] ?>
|
||
|
<? } ?>
|
||
|
</select>
|
||
|
<input type="radio" name="lagerfix" value="1" checked>für alle Artikel verwenden
|
||
|
<input type="radio" name="lagerfix" value="2">für Artikel ohne passendes Lager
|
||
|
</td></tr>
|
||
|
<tr><td>Daten</td><td><input type="file" name="Datei"></td></tr>
|
||
|
<tr><td></td><td><input type="submit" name="ok" value="Import"></td></tr>
|
||
|
</table>
|
||
Auch abrufbar als: Unified diff
Lager