$sql1 = "update defaults set customernumber='";
$rs2 = getAll("erp", $sql, "getNextKnr");
if ($rs2[0]["customernumber"]) {
$kdnr = $rs2[0]["customernumber"] + 1;
$rc = query("erp", $sql1 . $kdnr . "'", "getNextKnr");
if ($rc === -99) {
echo "Kann keine Kundennummer erzeugen - Abbruch";
exit;
}
return $kdnr;
} else {
return false;
}
}
$buchungsgruppen = array();
$warengruppen = array();
function getBugru()
{
$sql = "select B.id,tax.rate from buchungsgruppen B left join chart on income_accno_id_0=chart.id left join taxkeys T on ";
$sql .= "T.chart_id=income_accno_id_0 left join tax on tax.id=T.tax_id where T.startdate<=now()";
$rs = getAll("erp", $sql, "getBugru");
if ($rs) {
foreach ($rs as $row) {
$steuer = sprintf("%0.2f", $row["rate"] * 100);
$GLOBALS["buchungsgruppen"][$steuer] = $row["id"];
}
}
}
$wg = 1000;
getBugru();
$bugru[$row["bugru"]] = $row["rate"];
}
}
return $bugru;
}
if ($_POST["ok"] == "sichern") {
$ok = true;
$dsnP = array('phptype' => 'pgsql', 'username' => $_POST["ERPuser"], 'password' => $_POST["ERPpass"], 'hostspec' => $_POST["ERPhost"], 'database' => $_POST["ERPdbname"], 'port' => $_POST["ERPport"]);
$dbP = @DB::connect($dsnP);
if (DB::isError($dbP) || !$dbP) {
$ok = false;
echo "Keine Verbindung zur ERP<br>";
echo $dbP->userinfo;
$dbP = false;
} else {
$bugru = getBugru();
$sql = "SELECT id,description,buchungsgruppen_id FROM parts where partnumber = '%s'";
$rs = $dbP->getall(sprintf($sql, $_POST["div16NR"]));
$_POST["div16ID"] = $rs[0][0];
$div16txt = addslashes($rs[0][1]);
$_POST["div16TAX"] = $bugru[$rs[0][2]];
$rs = $dbP->getall(sprintf($sql, $_POST["div07NR"]));
$_POST["div07ID"] = $rs[0][0];
$_POST["div07TAX"] = $bugru[$rs[0][2]];
$div07txt = addslashes($rs[0][1]);
$rs = $dbP->getall(sprintf($sql, $_POST["versandNR"]));
$_POST["versandID"] = $rs[0][0];
$_POST["versandTAX"] = $bugru[$rs[0][2]];
$versandtxt = addslashes($rs[0][1]);
$rs = $dbP->getall(sprintf($sql, $_POST["nachnNR"]));
$_POST["nachnID"] = $rs[0][0];
