require_once "inc/stdLib.php"; include "inc/crmLib.php"; include_once "inc/UserLib.php"; include 'inc/phpOpenOffice.php'; $kalterm = array("datum" => "", "txt" => ""); $kaldrk = array("MO" => $kalterm, "DI" => $kalterm, "MI" => $kalterm, "DO" => $kalterm, "FR" => $kalterm, "SA" => $kalterm, "SO" => $kalterm); $drkwt = array("MO", "DI", "MI", "DO", "FR", "SA", "SO"); $vars = array("JAHR" => "", "MO" => "", "DI" => "", "MI" => "", "DO" => "", "FR" => "", "SA" => "", "SO" => "", "TERMINMO" => "", "TERMINDI" => "", "TERMINMI" => "", "TERMINDO" => "", "TERMINFR" => "", "TERMINSA" => "", "TERMINSO" => ""); $kw = $_GET["kw"]; $year = $_GET["year"]; if (!$kw) { list($day, $month, $year) = explode("\\.", $datum); $kw = date("W", mktime(0, 0, 0, $month, $day, $year)); } $ft = feiertage($year); $ftk = array_keys($ft); $x = mondaykw($kw, $year); $tag = date("d", $x); $month = date("m", $x); $startday = date("d", $x); $data = getTermin($startday, date("m", $x), $year, "W"); $vars["JAHR"] = $year; $vars["KW"] = $kw; $usr = getUserStamm($_SESSION["loginCRM"]); $vars["NAME"] = $usr["name"]; for ($i = 0; $i < 7; $i++) { $vars[$drkwt[$i]] = date("d.m.", mktime(0, 0, 0, $month, $tag + $i, $year)); } if ($data) { foreach ($data as $row) {
$tmp = "firma1.php?Q=V&id=" . substr($row["id"], 1); } else { if (substr($row["id"], 0, 1) == "P") { $tmp = "kontakt.php?id=" . substr($row["id"], 1); } } } if (substr($row["id"], 0, 1) == "G") { $links .= "(" . $row["name"] . ") "; } else { $links .= "[<a href='#' onClick='openstamm(\"{$tmp}\")'>" . ($row["name"] ? $row["name"] : $row["login"]) . "</a>] \n"; } } } list($tt, $mm, $yy) = explode("\\.", $data["starttag"]); $ft = feiertage($yy); $x = mktime(0, 0, 0, $mm, $tt, $yy); $wdhlg = array("0" => "einmalig", "1" => "täglich", "2" => "2-tägig", "7" => "wöchentlich", "14" => "2-wöchenltich", "30" => "monatlich", "365" => "jählich"); ?> <html> <head><title>Lx-Termin</title> <link type="text/css" REL="stylesheet" HREF="../css/<?php echo $_SESSION["stylesheet"]; ?> "></link> <link type="text/css" REL="stylesheet" HREF="css/<?php echo $_SESSION["stylesheet"]; ?> "></link> <script language="JavaScript">
function saveTermin($data) { if (!$data["tid"]) { $termid = newTermin(); } else { $termid = $data["tid"]; $sql = "delete from terminmember where termin={$termid}"; $rc = $_SESSION['db']->query($sql); $sql = "delete from termdate where termid={$termid}"; $rc = $_SESSION['db']->query($sql); } if (!$termid) { return false; } else { if (!$data["bisdat"]) { $data["bisdat"] = $data["vondat"]; } $von = mktime(0, 0, 0, substr($data["vondat"], 3, 2), substr($data["vondat"], 0, 2), substr($data["vondat"], 6, 4)); $bis = mktime(0, 0, 0, substr($data["bisdat"], 3, 2), substr($data["bisdat"], 0, 2), substr($data["bisdat"], 6, 4)); //Bisdatum nicht kleiner Vondatum if ($bis < $von) { $bis = $von; } //Bisdatum nicht grösser Vondatum, dann biszeit>=vonzeit if (($bis == $von || $data["repeat"] != "0") && $data["bis"] < $data["von"]) { $data["bis"] = $data["von"]; } $sql = "update termine set cause='" . $data["cause"] . "',kategorie=" . $data["kategorie"] . ",c_cause='" . $data["c_cause"]; $sql .= "',starttag='" . date("Y-m-d", $von) . "',stoptag='" . date("Y-m-d", $bis) . "',startzeit='" . $data["von"] . "',stopzeit='" . $data["bis"] . "',"; $sql .= "repeat=" . $data["repeat"] . ",ft='" . $data["ft"] . "',uid=" . $data["uid"] . ",privat='" . ($data["privat"] == 1 ? 't' : 'f') . "', "; //$sql.="syncid=".$data["syncid"].", "; // echtes Datum eintragen, schadet mal nicht und wird künfig verwendet. $sql .= "start='" . date("Y-m-d H:i:00", $von . " " . $data["von"]) . "', stop='" . date("Y-m-d H:i:00", $bis . " " . $data["bis"]) . "' "; $sql .= ",location='" . $data["location"] . "' "; $sql .= " where id=" . $termid; $rc = $_SESSION['db']->query($sql); if ($rc) { $year = date("Y", $von); $ft = feiertage($year); $ftk = array_keys($ft); $idx = 0; while ($bis >= $von) { if (date("Y", $von) != $year) { $year = date("Y", $von); $ft = feiertage($year); $ftk = array_keys($ft); } $sql = "insert into termdate (termid,tag,monat,jahr,kw,idx) values ("; $sql .= "{$termid},'" . date("d", $von) . "','" . date("m", $von) . "'," . date("Y", $von) . "," . strftime("%V", $von) . "," . $idx . ")"; if ($data["ft"] && date("w", $von) != 6 && date("w", $von) != 0 && !in_array($von, $ftk) || !$data["ft"] || $von == $bis) { $rc = $_SESSION['db']->query($sql); } switch ($data["repeat"]) { case '0': case '1': $von += 60 * 60 * 24; break; case '2': $von += 60 * 60 * 24 * 2; break; case '7': $von += 60 * 60 * 24 * 7; break; case '14': $von += 60 * 60 * 24 * 14; break; case '30': $von = mktime(0, 0, 0, date("m", $von) + 1, date("d", $von), date("Y", $von)); break; case '365': $von = mktime(0, 0, 0, date("m", $von), date("d", $von), date("Y", $von) + 1); break; default: $bis = mktime(0, 0, 0, 12, 31, 2100); } $idx++; } if ($data["user"]) { foreach ($data["user"] as $teiln) { $nr = substr($teiln, 1); $tab = substr($teiln, 0, 1); $sql = "insert into terminmember (termin,member,tabelle) values ("; $sql .= $termid . ",{$nr},'{$tab}')"; $rc = $_SESSION['db']->query($sql); if ($tab != "G" && $tab != "E") { $tid = mknewTelCall(); $nun = date2db($data["vondat"]) . " " . $data["von"] . ":00"; $sql = "update telcall set cause='" . $data["grund"]; $sql .= "',caller_id={$nr},calldate='{$nun}',termin_id={$termid},c_long='" . $data["c_cause"]; $sql .= "',employee='" . $_SESSION["loginCRM"] . "',kontakt='X',bezug=0 where id={$tid}"; $rc = $_SESSION['db']->query($sql); if (!$rs) { $rs = -1; } } } } } } }