function queryForEdit($date0, $date9, $where = '', $orderBy = '', $orderDirection = '')
{
$this->dbg('queryForEdit', "where={$where}");
if (eregi('whoiswhere', $this->Database)) {
return $this->queryForList($date0, $date9, $where, $orderBy, $orderDirection);
}
if (!$orderBy) {
$orderBy = "ORDER BY accounts.full_name,travel.Leave";
}
# if (!$orderBy) $orderBy = "ORDER BY travel.id,travel.Leave";
if ($orderBy == 'date') {
$orderBy = "ORDER BY travel.Leave";
}
$where = eregi_replace('login', 'accounts.username', $where);
$this->query("SELECT " . "travel.*, " . "accounts.* " . "FROM travel " . "LEFT JOIN accounts ON accounts.id=travel.Id " . join(' ', array('WHERE', db_timeLimit('Leave', 'Return', $date0, $date9), $where, $orderBy, $orderDirection)));
if ($recordCounter++ < 3) {
core_dbgArray($row);
}
}
function show()
{
ksort($GLOBALS[$this->cacheID]);
ksort($_SESSION[$this->cacheID]);
if ($this->type == "g") {
core_dbgArray($GLOBALS[$this->cacheID], $this->ID . "_GLOBALS", True, True);
} else {
core_dbgArray($_SESSION[$this->cacheID], $this->ID . "_SESSION", True, True);
}
}
function core_dbgArray($r, $name = '', $forced = 0, $showEmptyValues = False, $showNumIndex = False)
{
global $prevDbg, $core_tableDbg;
if (!$r) {
return;
}
if (!$forced && !core_getOption('debug')) {
return;
}
if (!$name) {
$name = 'dbgArray';
}
$prevDbg = '?';
$core_dbgSV2 = core_getOption('debug');
core_setOption('debug', $forced, $forced);
for ($pass = 0; $pass < 2; $pass++) {
$nlines = 0;
foreach ($r as $k => $v) {
if (!$v && !$showEmptyValues) {
continue;
}
if (preg_match("/^[0-9]*\$/i", $k) && !$showNumIndex) {
continue;
}
if (preg_match("/^[0-9]*\$/i", $k)) {
$k = '[]';
}
$nlines++;
if (True && is_array($v)) {
core_dbgArray($v, $name);
} else {
core_tdbg($name, $k, $v);
}
}
if ($nlines) {
break;
}
$showNumIndex = True;
}
if ($core_tableDbg) {
$core_tableDbg->close('</div>');
}
$core_tableDbg = False;
core_setOption('debug', $core_dbgSV2, True);
}
function whoAmI()
{
if (False && $this->autoLogout && $_SESSION["auth"]["timestamp"]) {
core_dbgArray($_SESSION["auth"], "whoAmI", $this->debug || core_getOption("YBhere"));
$dt = time() - $_SESSION["auth"]["timestamp"];
if ($dt > $autoLogoutTime) {
core_dbg("autoLogout", "sleep for {$dt} > {$autoLogoutTime}", "", 1);
$this->logout();
}
}
$_SESSION["auth"]["timestamp"] = time();
// Check first the standard Apache authenticator,
// normally coming from pubcookies
if ($localAccount = core_getpwnam($_SERVER["REMOTE_USER"])) {
$this->dbg("whoAmI", "REMOTE_USER", $_SERVER["REMOTE_USER"]);
$_SESSION["auth"]["username"] = $localAccount["name"];
$_SESSION["auth"]["gecos"] = $localAccount["gecos"];
$_SESSION["auth"]["account_id"] = $localAccount["uid"];
}
// Accept (if any) the server authentication prompt
$this->authenticate($_POST["auth_username"], $_POST["auth_password"]);
if ($_SESSION["auth"]["username"] && $_SESSION["auth"]["gecos"] && $_SESSION["auth"]["account_id"]) {
$this->localAccount = core_getpwnam($_SESSION["auth"]["username"]);
if (!$GLOBALS["deja"][get_class($this)][$_SESSION["auth"]["username"]]++) {
core_dbgArray($_SESSION["auth"], "auth whoAmI");
}
$_SERVER["PHP_AUTH_USER"] = $_SESSION["auth"]["username"];
return array($_SESSION["auth"]["gecos"], $_SESSION["auth"]["username"], $_SESSION["auth"]["account_id"]);
} else {
$this->dbg("whoAmI", "not logged in");
unset($_SESSION["auth"]);
}
}
