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 anmelden()
{
ini_set("gc_maxlifetime", "3600");
global $ERPNAME;
// ! das funzt nicht mit $_SESSION[ERPNAME] weil die Session in loginok.php zerstört wird...
global $erpConfigFile;
//Konfigurationsfile der ERP einlesen
$deep = is_dir("../" . $ERPNAME) ? "../" : "../../";
// anmelden() aus einem Unterverzeichnis
if (file_exists($deep . $ERPNAME . "/config/" . $erpConfigFile . ".conf")) {
$lxo = fopen($deep . $ERPNAME . "/config/" . $erpConfigFile . ".conf", "r");
} else {
if (file_exists($deep . $ERPNAME . "/config/" . $erpConfigFile . ".conf.default")) {
$lxo = fopen($deep . $ERPNAME . "/config/" . $erpConfigFile . ".conf.default", "r");
} else {
return false;
}
}
$dbsec = false;
$tmp = fgets($lxo, 512);
//Parameter für die Auth-DB in der ERP-Konfiguration finden
while (!feof($lxo)) {
if (preg_match("/^[\\s]*#/", $tmp) || $tmp == "\n") {
//Kommentar, ueberlesen
$tmp = fgets($lxo, 512);
continue;
}
if ($dbsec && preg_match("!\\[.+]!", $tmp)) {
$dbsec = false;
}
if ($dbsec) {
if (preg_match("/db[ ]*=[ ]*(.+)/", $tmp, $hits)) {
$dbname = $hits[1];
}
if (preg_match("/password[ ]*=[ ]*(.+)/", $tmp, $hits)) {
$dbpasswd = $hits[1];
}
if (preg_match("/user[ ]*=[ ]*(.+)/", $tmp, $hits)) {
$dbuser = $hits[1];
}
if (preg_match("/host[ ]*=[ ]*(.+)/", $tmp, $hits)) {
$dbhost = $hits[1] ? $hits[1] : "localhost";
}
if (preg_match("/port[ ]*=[ ]*([0-9]+)/", $tmp, $hits)) {
$dbport = $hits[1] ? $hits[1] : "5432";
}
if (preg_match("/\\[[a-z]+/", $tmp)) {
$dbsec = false;
}
$tmp = fgets($lxo, 512);
continue;
}
if (preg_match("/cookie_name[ ]*=[ ]*(.+)/", $tmp, $hits)) {
$cookiename = $hits[1];
}
//if ( preg_match("/dbcharset[ ]*=[ ]*(.+)/",$tmp,$hits) ) $dbcharset = $hits[1];
if (preg_match("/session_timeout[ ]*=[ ]*(.+)/", $tmp, $hits)) {
$sesstime = $hits[1];
}
if (preg_match("!\\[authentication/database\\]!", $tmp)) {
$dbsec = true;
}
$tmp = fgets($lxo, 512);
}
if (!$cookiename) {
$cookiename = $_SESSION['erpConfigFile'] . '_session_id';
}
if (!$sesstime) {
$sesstime = 480;
}
fclose($lxo);
$cookie = $_COOKIE[$cookiename];
if (!$cookie) {
header("location: ups.html");
}
// Benutzer anmelden
error_log("!{$ERPNAME}!{$dbhost},{$dbport},{$dbuser},{$dbpasswd},{$dbname},{$cookie}!", 0);
$auth = authuser($dbhost, $dbport, $dbuser, $dbpasswd, $dbname, $cookie);
if (!$auth) {
return false;
}
// Anmeldung des Users fehlgeschlagen
chkdir($auth["dbname"]);
// gibt es unter dokumente ein Verzeichnis mit dem Instanznamen
chkdir($auth["dbname"] . '/tmp/');
foreach ($auth as $key => $val) {
$_SESSION[$key] = $val;
}
// Mandanten + Userdaten in Session speichern
$_SESSION["sessid"] = $cookie;
$_SESSION["cookie"] = $cookiename;
$_SESSION["sesstime"] = $sesstime;
// Mit der Mandanten-DB verbinden
$_SESSION["db"] = new myDB($_SESSION["dbhost"], $_SESSION["dbuser"], $_SESSION["dbpasswd"], $_SESSION["dbname"], $_SESSION["dbport"]);
if (!$_SESSION["db"]) {
return false;
} else {
$_SESSION['CRMTL'] = $auth['CRMTL'];
$charset = ini_get("default_charset");
//if ( $charset == "" ) $charset = $dbcharset;
if ($charset == "") {
$charset = 'UTF8';
}
$_SESSION["charset"] = $charset;
include_once "inc/UserLib.php";
$user_data = getUserStamm(0, $_SESSION["login"]);
$BaseUrl = empty($_SERVER['HTTPS']) ? 'http://' : 'https://';
$BaseUrl .= $_SERVER['HTTP_HOST'];
$BaseUrl .= preg_replace("^crm/.*^", "", $_SERVER['REQUEST_URI']);
if ($user_data) {
foreach ($user_data as $key => $val) {
$_SESSION[$key] = $val;
}
}
if (isset($_SESSION['sql_error']) && $_SESSION['sql_error']) {
$_SESSION['db']->setShowError(true);
} else {
$_SESSION['db']->setShowError(false);
}
$_SESSION['dir_mode'] = $user_data['dir_mode'] != '' ? octdec($user_data['dir_mode']) : 493;
// 0755
$_SESSION["loginCRM"] = $user_data["id"];
$_SESSION['theme'] = $user_data['theme'] == '' || $user_data['theme'] == 'base' ? '' : $user_data['theme'];
$sql = "SELECT * from schema_info where tag like 'relea%' order by itime desc limit 1";
$rs = $_SESSION["db"]->getOne($sql);
$tmp = substr($rs['tag'], 8);
$_SESSION["ERPver"] = strtr($tmp, '_', '.');
$_SESSION["menu"] = makeMenu($_SESSION["sessid"], $_SESSION["token"]);
$_SESSION["basepath"] = $BaseUrl;
$_SESSION['token'] = False;
return true;
}
}
$_SESSION['theme'] = $_POST['theme'] != 'base' ? $_POST['theme'] : '';
} elseif (isset($_POST["mkmbx"])) {
$rc = createMailBox($_POST["Postf2"], $_POST["Login"]);
}
//if ( isset( $_POST["mkmbx"] ) ) {
// $rc = createMailBox( $_POST["Postf2"], $_POST["Login"] );
//}
$t = new Template($base);
doHeader($t);
if (isset($_GET["id"]) && $_GET["id"] && $_GET["id"] != $_SESSION["loginCRM"]) {
$fa = getUserStamm($_GET["id"]);
$t->set_file(array("usr1" => "user1b.tpl"));
$t->set_var(array(vertreter => $fa["vertreter"] . " " . $fa["vname"]));
$own = false;
} else {
$fa = getUserStamm($_SESSION["loginCRM"]);
$t->set_file(array("usr1" => "user1.tpl"));
$own = true;
}
if ($fa['streetview_default'] == 't') {
$_SESSION['streetview'] = $fa['streetview'] = $_SESSION['streetview_man'];
$_SESSION['planspace'] = $fa['planspace'] = $_SESSION['planspace_man'];
}
if (empty($fa["ssl"])) {
$fa["ssl"] = "n";
}
if (empty($fa["proto"])) {
$fa["proto"] = "t";
}
$gruppen = '';
if ($fa) {
function showShipadress($id, $tab)
{
$data = getShipStamm($id, $tab);
$htmllink = '';
$karte = str_replace(array("%TOSTREET%", "%TOZIPCODE%", "%TOCITY%"), array(strtr($data["shiptostreet"], " ", $_SESSION['planspace']), $data["shiptozipcode"], $data["shiptocity"]), $_SESSION['streetview']);
if (preg_match("/%FROM/", $karte)) {
include "inc/UserLib.php";
$user = getUserStamm($_SESSION["loginCRM"]);
if ($user["addr1"] != "" and $user["addr3"] != "" and $user["addr2"]) {
$karte = str_replace(array("%FROMSTREET%", "%FROMZIPCODE%", "%FROMCITY%"), array(strtr($user["addr1"], " ", $_SESSION['planspace']), $user["addr2"], $user["addr3"]), $karte);
} else {
$karte = "";
}
}
$maillink = $_SESSION['external_mail'] ? "<a href='mailto:" . $data["shiptoemail"] . "'>" . $data["shiptoemail"] . "</a>" : "<a href='mail.php?TO=" . $data["shiptoemail"] . "&KontaktTO={$tab}" . $data["trans_id"] . "'>" . $data["shiptoemail"] . "</a>";
echo json_encode(array('karte' => $karte, 'mail' => $maillink, 'www' => $htmllink, 'adr' => $data));
}
