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