function berechtigung($tab = "")
{
$grp = getGrp($_SESSION["loginCRM"]);
$rechte = "( " . $tab . "owener=" . $_SESSION["loginCRM"] . " or " . $tab . "owener is null";
if ($grp) {
$rechte .= " or " . $tab . "owener in {$grp}";
}
return $rechte . ")";
}
function getNextTermin($tid)
{
$nun = date("Y-m-dH:i");
$grp = getGrp($tid, true);
if ($grp) {
$rechte .= " M.member in {$grp}";
}
//$sql="select * from termine T left join termdate D on D.termid=T.id left join terminmember M on M.termin=T.id ";
//$sql.="where D.jahr||'-'||D.monat||'-'||D.tag||T.startzeit>='$nun' and $rechte order by jahr,monat,tag,startzeit limit 1";
$sql = "select * from termine T left join termdate D on D.termid=T.id left join terminmember M on M.termin=T.id ";
$sql .= "where D.jahr||'-'||D.monat||'-'||D.tag||T.startzeit>'{$nun}' and {$rechte} order by jahr,monat,tag,startzeit limit 1";
$rs = $_SESSION['db']->getAll($sql);
//echo $sql;
if ($rs[0]["termid"]) {
$data["id"] = $rs[0]["termid"];
$ziel = mktime(substr($rs[0]["startzeit"], 0, 2), substr($rs[0]["startzeit"], 3, 2), 0, $rs[0]["monat"], $rs[0]["tag"], $rs[0]["jahr"]);
$nun = time();
$data["zeit"] = $ziel - $nun;
} else {
$data["id"] = -1;
$data["zeit"] = -1;
}
return $data;
}
