<?php
require_once("inc/debug.php");
function customer_may_have_useraccounts()
{
$customerno = (int) $_SESSION['customerinfo']['customerno'];
$result = db_query("SELECT COUNT(*) FROM system.useraccounts WHERE kunde=?", array($customerno));
return ($result->rowCount() > 0);
}
function customer_useraccount($uid)
{
$args = array(":uid" => $uid, ":customerno" => $_SESSION['customerinfo']['customerno']);
$result = db_query("SELECT 1 FROM system.useraccounts WHERE kunde=:customerno AND uid=:uid AND kundenaccount=1", $args);
return $result->rowCount() > 0;
}
function primary_useraccount()
{
if (! ($_SESSION['role'] & ROLE_SYSTEMUSER)) {
return null;
}
$customerno = (int) $_SESSION['customerinfo']['customerno'];
$result = db_query("SELECT MIN(uid) AS uid FROM system.useraccounts WHERE kunde=?", array($customerno));
$uid = $result->fetch(PDO::FETCH_OBJ)->uid;
DEBUG("primary useraccount: {$uid}");
return $uid;
}
function available_shells()
{
$result = db_query("SELECT path, name FROM system.shells WHERE usable=?", array(1));
$ret = array();