}
if ($_POST["ok"]) {
if ($_POST["vid"]) {
$vid = updateVertrag($_POST);
} else {
if (!empty($_POST["maschinen"][0][0])) {
$vid = saveNewVertrag($_POST);
}
}
}
$vorlagen = getWVorlagen();
if ($vid) {
$template = "vertrag3e.tpl";
$vertrag = getVertrag($vid);
//$maschinen=getVertragMaschinen($vertrag["contractnumber"]);
$maschinen = getVertragMaschinen($vid);
}
$t->set_file(array("vert" => $template));
$t->set_var(array(VID => $vid, vorlage_old => $vertrag["customer_id"] . "/" . $vertrag["template"], vorlage => $vertrag["template"], Notiz => $vertrag["bemerkung"], FID => $vertrag["customer_id"], KDNR => $vertrag["customernumber"], Firma => $vertrag["name"], betrag => sprintf("%0.2f", $vertrag["betrag"]), anfangdatum => db2date($vertrag["anfangdatum"]), endedatum => db2date($vertrag["endedatum"]), VertragNr => $vertrag["contractnumber"]));
$t->set_block("vert", "Vorlage", "Block1");
if ($vorlagen) {
foreach ($vorlagen as $zeile) {
if ($zeile == $vertrag["template"]) {
$sel = " selected";
} else {
$sel = "";
}
$t->set_var(array(Vsel => $sel, Vertrag => $zeile));
$t->parse("Block1", "Vorlage", true);
}
}
<?php
require_once "inc/stdLib.php";
include "inc/FirmenLib.php";
include "inc/wvLib.php";
$rep = suchVertrag($_GET["aid"]);
$rep = $rep[0];
//$masch=getVertragMaschinen($rep["contractnumber"]);
$masch = getVertragMaschinen($rep["cid"]);
$firma = getFirmenStamm($masch["customer_id"]);
include 'inc/phpOpenOffice.php';
$doc = new phpOpenOffice();
$doc->loadDocument("vorlage/wv" . $rep["template"]);
$vars = array();
$vars["NAME"] = $firma["name"];
$vars["STRASSE"] = $firma["street"];
$vars["PLZ"] = $firma["zipcode"];
$vars["ORT"] = $firma["city"];
$vars["BEMERKUNGEN"] = $rep["bemerkung"];
$vars["NUMMER"] = $rep["aid"];
$vars["DATUM"] = $rep["datum"];
$vars["KNDR"] = $rep["customer_id"];
$vars["EURO"] = $rep["betrag"];
foreach ($masch as $row) {
$vars["MASCHINEN"] .= $row["description"] . " #" . $row["serialnumber"] . "\n" . $row["standort"] . "\n";
}
$doc->parse($vars);
$pre = date("YmdHi");
$doc->prepsave($pre . substr($rep["template"], 0, -4));
$data["CID"] = $masch["customer_id"];
$data["CRMUSER"] = $_SESSION["loginCRM"];
