<?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);
}
