function getMailTpl($id, $KontaktTO = '')
{
$data = getOneMailVorlage($id);
$Subject = $data["cause"];
$BodyText = $data["c_long"];
if ($KontaktTO != '') {
$user = getUserStamm($_SESSION["loginCRM"]);
if (substr($KontaktTO, 0, 1) == "K") {
include "inc/persLib.php";
$empf = getKontaktStamm(substr($KontaktTO, 1));
$tmp = getFirmaCVars($empf["cp_cv_id"]);
if ($tmp) {
foreach ($tmp as $key => $val) {
$empf[$key] = $val;
}
}
//} else if (substr($KontaktTO,0,1)=="C") {
} else {
if (substr($KontaktTO, 0, 1) == "S") {
$empf = getShipStamm(substr($KontaktTO, 1), 'C', True);
// <- Da noch mal ran. Hart Kundenstamm
} else {
if ($KontaktTO) {
$empf = getFirmenStamm(substr($KontaktTO, 1), true, substr($KontaktTO, 0, 1));
}
}
}
foreach ($user as $key => $val) {
$empf['employee' . strtolower($key)] = $val;
}
preg_match_all("/%([A-Z0-9_]+)%/iU", $BodyText, $ph, PREG_PATTERN_ORDER);
$ph = array_slice($ph, 1);
if ($ph[0]) {
$anrede = false;
foreach ($ph[0] as $x) {
$y = $empf[$x];
if ($x == "cp_greeting") {
$anrede = $y;
}
$BodyText = preg_replace("/%" . $x . "%/i", $y, $BodyText);
}
if ($anrede == "Herr") {
$BodyText = preg_replace("/%cp_anrede%/", "r", $BodyText);
} else {
if ($anrede) {
$BodyText = preg_replace("/%cp_anrede%/", "", $BodyText);
}
}
}
}
//$MailSign=ereg_replace("\r","",$user["mailsign"]);
$Response = array('subject' => $Subject, 'bodytxt' => $BodyText);
//." \n".$MailSign);
echo json_encode($Response);
}
function addFaStamm2Sess($id, $tab = 'C', $prod, $cup)
{
if ($id) {
$data = getFirmenStamm($id, false, $tab);
}
if ($data and $id) {
$fa['RECV_NAME1'] = $data['name'];
$fa['RECV_NAME2'] = $data[''];
$fa['RECV_STREET'] = $data['street'];
$fa['RECV_HOUSENUMBER'] = '';
$fa['RECV_PLZ'] = $data['zipcode'];
$fa['RECV_CITY'] = $data['city'];
$fa['RECV_COUNTRY'] = strtoupper(substr($data['country'], 0, 3));
$fa['RECV_PRODUCT'] = $prod;
$fa['RECV_CUPON'] = $cup;
$_SESSION['DHL'][] = $fa;
if (in_array($fa['RECV_COUNTRY'], array('DEU', 'AUT', 'CHE', 'FRA', 'ITA', 'ESP'))) {
echo 'ok';
} else {
echo 'ISO3';
}
}
echo 'ERROR';
}
}
if ($pid) {
$pfad .= "/{$pid}";
}
if (empty($fid)) {
$data = getKontaktStamm($pid);
$data["ANREDE"] = $data["cp_greeting"] . " " . $data["cp_title"];
$data["NAME2"] = $data["cp_givenname"];
$data["NAME1"] = $data["cp_name"];
$data["NAME"] = $name2 . " " . $name1;
$data["PLZ"] = $data["cp_zipcode"];
$data["ORT"] = $data["cp_city"];
$data["STRASSE"] = $co["cp_street"];
$art = "Einzelperson";
} else {
$data = getFirmenStamm($fid, true, $tab);
$anrede = "Firma";
$data["ANREDE"] = $data["greeting"];
$data["NAME"] = $data["name"];
$data["NAME1"] = $data["name"];
$data["NAME2"] = $data["department_1"];
$data["KONTAKT"] = $data["contact"];
$data["PLZ"] = $data["zipcode"];
$data["ORT"] = $data["city"];
$data["STRASSE"] = $data["street"];
foreach ($data as $key => $val) {
$key = strtoupper($key);
if (substr($key, 0, 8) == "VC_CVAR_") {
$data[$key] = $val;
}
}
<?php
require "inc/stdLib.php";
include "inc/FirmenLib.php";
include 'inc/phpOpenOffice.php';
if ($_GET["Q"] == "C") {
$fa = getFirmenStamm($_GET["fid"], true, "C");
$fa["number"] = $fa["customernumber"];
} else {
$fa = getFirmenStamm($_GET["fid"], true, "V");
$fa["number"] = $fa["vendornumber"];
$fa["kdtyp"] = $fa["lityp"];
}
foreach ($fa as $key => $val) {
$fa[$key] = utf8_decode($val);
}
$var = array();
if ($key == "typrabatt") {
$val = $val * 100;
}
$fa["typrabatt"] = $fa["typrabatt"] * 100;
$fa["creditlimit"] = sprintf("%0.2f", $fa["creditlimit"]);
$fa["discount"] = sprintf("%0.2f", $fa["discount"] * 100);
$fa["itime"] = db2date($fa["itime"]);
$fa["mtime"] = db2date($fa["mtime"]);
$doc = new phpOpenOffice();
if (file_exists("vorlage/firmenkartei.sxw")) {
$doc->loadDocument("vorlage/firmenkartei.sxw");
} else {
$doc->loadDocument("vorlage/firmenkartei.odt");
}
include "inc/crmLib.php";
include "inc/FirmenLib.php";
include "inc/wvLib.php";
if (isset($_GET)) {
$fid = isset($_GET['fid']) ? $_GET['fid'] : false;
$pid = isset($_GET['pid']) ? $_GET['pid'] : false;
$Q = isset($_GET['Q']) ? $_GET['Q'] : false;
} else {
$fid = isset($_POST['fid']) ? $_POST['fid'] : false;
$pid = isset($_POST['pid']) ? $_POST['pid'] : false;
$Q = isset($_POST['Q']) ? $_POST['Q'] : false;
}
$fa = $vertrag = false;
if (!empty($fid)) {
$dir = $Q;
$fa = getFirmenStamm($fid, true, $Q);
$dir .= $Q == 'C' ? $fa['customernumber'] : $fa['vendornumber'];
if (!empty($pid)) {
$id = $pid;
$co = getKontaktStamm($pid);
$name = $co['cp_givenname'] . ' ' . $co['cp_name'];
$plz = $co['cp_zipcode'];
$ort = $co['cp_city'];
$firma = $fa['name'];
$dir .= '/' . $co['cp_id'];
} else {
$id = $fid;
$name = $fa['name'];
$plz = $fa['zipcode'];
$ort = $fa['city'];
$firma = 'Firmendokumente';
}
}
$data["Kontakt"] = "M";
$data["Bezug"] = 0;
$data['Zeit'] = date("H:i");
$data['Datum'] = date("d.m.Y");
$data["DateiID"] = 0;
$data["Status"] = 1;
$data["inout"] = 'o';
$data["DCaption"] = $Subject;
$stamm = false;
if ($_POST["KontaktTO"] != "") {
$data["Q"] = $_POST["KontaktTO"][0];
if ($data["Q"] == "C" || $data["Q"] == "V") {
include "inc/FirmenLib.php";
$empf = getFirmenStamm(substr($KontaktTO, 1), true, substr($KontaktTO, 0, 1));
$data["fid"] = $empf["id"];
$data["CID"] = $empf["id"];
$data["nummer"] = $empf["nummer"];
} else {
include "inc/persLib.php";
$empf = getKontaktStamm(substr($KontaktTO, 1));
$data["fid"] = $empf["cp_cv_id"];
$data["CID"] == $empf["cp_id"];
$data["nummer"] = $empf["nummer"];
}
// Einträge in den Kontaktverlauf
if ($_POST["KontaktTO"] && substr($_POST["KontaktTO"], 0, 1) != "E") {
$data["CID"] = substr($_POST["KontaktTO"], 1);
insCall($data, $_FILES);
$stamm = true;
<?php
require_once "inc/stdLib.php";
include "inc/FirmenLib.php";
include "inc/wvLib.php";
include "inc/pdfpos.php";
define("FPDF_FONTPATH", "/usr/share/fpdf/font/");
define("FONTART", "2");
define("FONTSTYLE", "1");
$rep = getRAuftrag($_GET["aid"]);
$masch = getAllMaschine($rep["mid"]);
$firma = getFirmenStamm($masch["customer_id"]);
$hist = getHistory($rep["mid"]);
$material = getAllMat($_GET["aid"], $rep["mid"]);
if ($material) {
foreach ($material as $zeile) {
$mat .= $zeile["menge"] . " x " . substr($zeile["description"], 0, 70) . "\n";
}
}
require "fpdf.php";
require "fpdi.php";
$pdf = new FPDI('P', 'mm', 'A4');
$seiten = $pdf->setSourceFile("vorlage/repauftrag.pdf");
$hdl = $pdf->ImportPage(1);
$pdf->addPage();
$pdf->useTemplate($hdl);
$pdf->SetFont($repfont, 'B', $repsizeL);
$pdf->Text($repname[x], $repname[y], utf8_decode($firma["name"]));
$pdf->Text($repstr[x], $repstr[y], utf8_decode($firma["street"]));
$pdf->Text($report[x], $report[y], $firma["zipcode"] . " " . utf8_decode($firma["city"]));
$pdf->Text($repphone[x], $repphone[y], $firma["phone"]);
} else {
$msg = "Fehler beim Sichern ( " . $rc[1] . " )";
}
} else {
$msg = "Daten wurden inzwischen modifiert";
$rc[0] = -1;
}
} else {
$rc[0] = -1;
$rc[1] = "Kein Bestandskunde";
}
$btn1 = "<input id='bsav' type='submit' class='sichern' name='save' value='sichern' tabindex='90'> ";
$btn2 = "<input id='banz' type='submit' class='anzeige' name='show' value='zur Anzeige' tabindex='91'> ";
vartpl($t, $_POST, $Q, $msg, $btn1, $btn2, 3);
} else {
if ($_POST["show"]) {
header("location:firma1.php?Q={$Q}&id=" . $_POST["id"]);
} else {
if ($_GET["edit"]) {
$daten = getFirmenStamm($_GET["id"], false, $Q);
$msg = "Edit: <b>" . $_GET["id"] . "</b>";
$btn1 = "<input id='bsav' type='submit' class='sichern' name='save' value='sichern' tabindex='90'> ";
$btn2 = "<input id='banz' type='submit' class='anzeige' name='show' value='zur Anzeige' tabindex='91'> ";
vartpl($t, $daten, $Q, $msg, $btn1, $btn2, 3);
} else {
leertpl($t, 3, $_GET, "Neueingabe");
}
}
}
}
$t->Lpparse("out", array("fa1"), $_SESSION['countrycode'], "firma");
<?php
require_once "inc/stdLib.php";
if ($_GET["fid"]) {
include "inc/FirmenLib.php";
$data = getFirmenStamm($_GET["fid"], true, "C");
} else {
if ($_GET["lid"]) {
include "inc/FirmenLib.php";
$data = getFirmenStamm($_GET["lid"], true, "V");
} else {
if ($_GET["pid"]) {
include "inc/persLib.php";
$data = getKontaktStamm($_GET["pid"]);
}
}
}
?>
<html>
<head><title>Lx-Notiz</title>
</head>
<body>
<?php
if ($data["notes"]) {
echo strtr($data["notes"], array("\n" => "<br>"));
} else {
if ($data["cp_notes"]) {
echo strtr($data["cp_notes"], array("\n" => "<br>"));
} else {
echo "Es ist keine Bemerkung hinterlegt";
}
$name2 = $data["shiptodepartment_1"];
$kontakt = $data["shiptocontact"];
$strasse = $data["shiptostreet"];
$land = $data["shiptocountry"];
$plz = $data["shiptozipcode"];
$ort = $data["shiptocity"];
$telefon = $data["shiptophone"];
$fax = $data["shiptofax"];
$email = $data["shiptoemail"];
}
$data = getFirmaCVars($data["trans_id"]);
$name1 = $name;
} else {
$id = $_GET["fid"];
$dest = "fid=" . $_GET["fid"];
$data = getFirmenStamm($_GET["fid"], true, $Q);
$anrede = $data["greeting"];
$name = $data["name"];
$name1 = $name;
$name2 = $data["department_1"];
$kontakt = $data["contact"];
$strasse = $data["street"];
$land = $data["country"];
$plz = $data["zipcode"];
$ort = $data["city"];
$telefon = $data["phone"];
$fax = $data["fax"];
$email = $data["email"];
$kdnr = $data["customernumber"];
}
}
}
}
}
}
}
// end sichern
switch ($Q) {
case "C":
$fa = getFirmenStamm($fid, true, "C");
$daten["Firma"] = $fa["name"];
$daten["Plz"] = $fa["zipcode"];
$daten["Ort"] = $fa["city"];
$daten["nummer"] = $fa["nummer"];
break;
case "V":
$fa = getFirmenStamm($fid, true, "V");
$daten["Firma"] = $fa["name"];
$daten["Plz"] = $fa["zipcode"];
$daten["Ort"] = $fa["city"];
$daten["nummer"] = $fa["nummer"];
break;
case "XC":
case "CC":
case "VC":
$co = getKontaktStamm($pid);
$daten["Firma"] = $co["cp_givenname"] . " " . $co["cp_name"];
$daten["Plz"] = $co["cp_zipcode"];
$daten["Ort"] = $co["cp_city"];
$daten["nummer"] = $co["nummer"];
break;
default:
include "inc/FirmenLib.php";
include "inc/persLib.php";
if (isset($_GET)) {
foreach ($_GET as $key => $val) {
${$key} = $val;
}
}
if ($id > 0) {
$txt = '';
if ($tab == 'P') {
$rs = getKontaktStamm($id);
if ($rs) {
$txt = $rs['cp_givenname'] . ' ' . $rs['cp_name'] . ' ' . $rs['name'];
}
} else {
$rs = getFirmenStamm($id, false, $tab, false);
if ($rs) {
$txt = $rs['name'] . ' - ' . $rs['city'];
}
}
if ($txt != '') {
$txt .= ' (zugeordnet)';
echo "<html><script language='JavaScript'>";
echo "opener.document.formular.cp_cv_id.value='{$tab}{$id}';";
echo "opener.document.formular.name.value='{$txt}';";
echo "self.close();";
echo "</script></html>";
exit(1);
}
}
?>
$mid = $_POST["mid"];
}
} else {
if ($_GET["hole"]) {
$rep = getRAuftrag($_GET["hole"]);
if (!$rep) {
$msg = "Nicht gefunden";
}
$mid = $rep["mid"];
} else {
$rep = $_POST;
}
}
$masch = getAllMaschine($mid);
$kdnr = $rep["kdnr"] ? $rep["kdnr"] : $masch["customer_id"];
$firma = getFirmenStamm($kdnr);
$hist = getHistory($mid);
$t = new Template($base);
$t->set_file(array("masch" => "repauftrag.tpl"));
doHeader($t);
if (!$rep["datum"]) {
$rep["datum"] = date("d.m.Y");
}
$t->set_block("masch", "History", "Block1");
if ($hist) {
if ($rep['aid']) {
$t->set_var(array(date => '', art => '', open => ' ', beschreibung => "<a href='repauftrag.php?mid={$mid}'>Neuer Auftrag</a>"));
$t->parse("Block1", "History", true);
}
while ($zeile = array_shift($hist)) {
$open = ' ';
$auth = userData($dbA, $_POST["sessid"], $_POST["ip"], $_POST['mandant'], $_POST["login"], $_POST["password"], $f);
if ($log) {
$log->write("auth:" . print_r($auth, true));
}
if ($auth['db']) {
$db = $auth['db'];
$custsql = array();
$vendsql = array();
$contsql = array();
$rs = false;
$tab = $_POST["tab"];
$id = $_POST["ID"];
if ($tab == "P") {
$rs = getKontaktStamm($id, "..");
} else {
$rs = getFirmenStamm($id, true, $tab);
}
if ($log) {
$log->write(print_r($rs, true));
}
header("Content-type: text/json; charset=utf-8;");
if (!$rs) {
echo "";
} else {
while (list($key, $val) = each($rs)) {
if ($val == Null) {
$rs[$key] = '';
}
}
print json_encode($rs);
}
<?php
require_once "inc/stdLib.php";
include "inc/FirmenLib.php";
include "inc/wvLib.php";
include "inc/pdfpos.php";
define("FPDF_FONTPATH", "/usr/share/fpdf/font/");
define("FONTART", "2");
define("FONTSTYLE", "1");
$rep = suchVertrag($_GET["aid"]);
$rep = $rep[0];
$masch = getVertragMaschinen($rep["cid"]);
$firma = getFirmenStamm($rep["customer_id"]);
require "fpdf.php";
require "fpdi.php";
$pdf = new FPDI('P', 'mm', 'A4');
$seiten = $pdf->setSourceFile("vorlage/wv" . $rep["template"]);
$ende = $rep["endedatum"] == $rep["anfangdatum"] ? "offen" : db2date($rep["endedatum"]);
$hdl = $pdf->ImportPage(1);
$pdf->addPage();
$pdf->useTemplate($hdl);
$pdf->SetFont($wvfont, '', $wvsize);
$pdf->Text($wvname[x], $wvname[y], utf8_decode($firma["name"]));
$pdf->Text($wvstr[x], $wvstr[y], utf8_decode($firma["street"]));
$pdf->Text($wvort[x], $wvort[y], $firma["zipcode"] . " " . utf8_decode($firma["city"]));
$pdf->Text($wvkdnr[x], $wvkdnr[y], $firma["customernumber"]);
$pdf->Text($wvwvnr[x], $wvwvnr[y], $rep['contractnumber']);
$pdf->Text($wvstart[x], $wvstart[y], db2date($rep["anfangdatum"]));
$pdf->Text($wvende[x], $wvende[y], $ende);
$pdf->Text($wvbetrag[x], $wvbetrag[y], sprintf("%0.2f", $rep["betrag"]));
$pdf->SetFont('Helvetica', '', 10);
