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