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