} 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"];