<?php require "inc/stdLib.php"; include 'inc/katalog.php'; $link = ""; $menu = $_SESSION['menu']; if ($_POST['ok']) { $artikel = getArtikel($_POST); $tax = getTax(); $vorlage = prepTex(); $lastPG = ''; if (file_exists('tmp/katalog.pdf')) { unlink('tmp/katalog.pdf'); } if (file_exists('tmp/katalog.tex')) { unlink('tmp/katalog.tex'); } if (file_exists('tmp/tabelle.tex')) { unlink('tmp/tabelle.tex'); } $f = fopen('tmp/katalog.tex', 'w'); $rc = fputs($f, $vorlage['pre']); $suche = array('&', '_', '"', '!', '#', '%', '(', ')'); $ersetze = array('\\&', '\\_', '\\"', ' : ', '\\#', '\\%', '\\{', '\\}'); if ($artikel) { foreach ($artikel as $part) { $line = $vorlage['artikel']; if ($lastPG != $part['partsgroup']) { $lastPG = $part['partsgroup']; $val = str_replace($suche, $ersetze, $part['partsgroup']); $line = preg_replace("/<%partsgroup%>/i", $val, $line);
{ $sql = "SELECT P.*,T.rate FROM "; $sql .= "parts P left join buchungsgruppen BG on P.buchungsgruppen_id=BG.id "; $sql .= "left join chart C on C.id=BG.income_accno_id_0 "; $sql .= "left join taxkeys TK on TK.chart_id=C.id, tax T "; $sql .= "WHERE P.id={$id} and TK.taxkey_id=C.taxkey_id and T.id=TK.tax_id "; $sql .= "order by TK.startdate desc limit 1"; $rs = $_SESSION["db"]->getAll($sql); if (count($rs) >= 1) { $rs = $rs[0]; } $rs["bruttosell"] = round($rs["sellprice"] * (1 + $rs["rate"]), 2); $rs["mwst"] = round($rs["sellprice"] * $rs["rate"], 2); return $rs; } $data = getArtikel($pid); $template = file("./vorlage/barcode.tex"); $template = join("", $template); preg_match_all("/<%([^%]+)%>/", $template, $treffer); if ($treffer[1]) { foreach ($treffer[1] as $key) { $template = preg_replace("/<%" . $key . "%>/", $data[$key], $template); } } $file = "barcode_" . $_SESSION["login"]; $dir = "tmp/"; $f = fopen("{$dir}{$file}.tex", "w"); fputs($f, $template); $home = getenv('HOME'); $openin_any = getenv('openin_any'); putenv('HOME=' . getcwd() . '/tmp');
$bekannt = getBekannt($data["id"]); } } } else { if ($_POST["ok"]) { if ($_POST["parts_sernr"]) { $rc = updateMaschine($_POST); } else { $rc = saveNewMaschine($_POST); } if ($rc) { $msg = "Maschine gesichert"; } else { $msg = "Fehler beim Sichern"; } $data = getArtikel($_POST["partnumber"]); $data = $data[0]; $pid = $data["id"]; $nummern = getNumber($data["id"]); $bekannt = getBekannt($data["id"]); } } $t->set_file(array("masch" => "maschinen3.tpl")); doHeader($t); $t->set_var(array(action => "maschine3.php", msg => $msg, parts_id => $pid, mid => $data["mid"], inspdatum => db2date($data["inspdatum"]), snumber => $data["serialnumber"], partnumber => $data["partnumber"], description => $data["description"], notes => $data["notes"], beschreibung => $data["beschreibung"])); $t->set_block("masch", "Bekannt", "Block1"); if ($bekannt) { foreach ($bekannt as $zeile) { $t->set_var(array(maschine => $zeile["serialnumber"])); $t->parse("Block1", "Bekannt", true); }