$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];