function _get_kostenstellen_lvm($user)
{
$kostenstelle_prop = 'lvmkostenstelle';
$ldap = gs_ldap_connect();
//if (gs_get_conf('GS_LVM_USER_6_DIGIT_INT')) {
// this check is not really needed as this is a custom function anyway
$user = preg_replace('/^0+/', '', $user);
# without leading "0" in their LDAP
//}
$u = gs_ldap_get_first($ldap, GS_LDAP_SEARCHBASE, '(' . GS_LDAP_PROP_USER . '=' . $user . ')', array($kostenstelle_prop));
if (isGsError($u)) {
return false;
}
if (!is_array($u)) {
echo "Failed to get (" . GS_LDAP_PROP_USER . "=" . $user . ") from LDAP server.\n";
return false;
}
$kostenstelle_prop = strToLower($kostenstelle_prop);
if (!is_array($u[$kostenstelle_prop])) {
return array();
}
return $u[$kostenstelle_prop];
}
function gs_user_external_number_del($user, $number)
{
if (!preg_match('/^[a-z0-9\\-_.]+$/', $user)) {
return new GsError('User must be alphanumeric.');
}
if (!preg_match('/^[\\d]+$/', $number)) {
return new GsError('Number must be numeric.');
}
# connect to db
#
$db = gs_db_master_connect();
if (!$db) {
return new GsError('Could not connect to database.');
}
# get user_id
#
$user_id = $db->executeGetOne('SELECT `id` FROM `users` WHERE `user`=\'' . $db->escape($user) . '\'');
if ($user_id < 1) {
return new GsError('Unknown user.');
}
switch (GS_EXTERNAL_NUMBERS_BACKEND) {
case 'ldap':
$ldap = gs_ldap_connect();
if (!$ldap) {
return new GsError('Could not connect to LDAP server.');
}
# check if number exists (to return proper err msg)
#
/*
$numbers = gs_user_external_numbers_get( $user );
if (isGsError($numbers))
return new GsError( $numbers->getMsg() );
if (! is_array($numbers))
return new GsError( 'Failed to get numbers from LDAP' );
if (! in_array($number, $numbers, true))
return new GsError( 'No such number.' );
*/
# find ldap user name
#
if (GS_LDAP_PROP_UID === GS_LDAP_PROP_USER) {
$ldap_uid = $user;
if (gs_get_conf('GS_LVM_USER_6_DIGIT_INT')) {
$user = preg_replace('/^0+/', '', $user);
# if the usernames in your LDAP are integers without
# a leading "0"
}
} else {
if (gs_get_conf('GS_LVM_USER_6_DIGIT_INT')) {
$user = preg_replace('/^0+/', '', $user);
# if the usernames in your LDAP are integers without
# a leading "0"
}
$userArr = gs_ldap_get_first($ldap, GS_LDAP_SEARCHBASE, GS_LDAP_PROP_USER . '=' . $user, array(GS_LDAP_PROP_UID));
if (isGsError($userArr)) {
return new GsError($userArr->getMsg());
}
if (!is_array($userArr)) {
return new GsError('Could not find user by "' . GS_LDAP_PROP_USER . '=' . $user . '" in search base "' . GS_LDAP_SEARCHBASE . '" in LDAP.');
}
$ldap_uid = @$userArr[strToLower(GS_LDAP_PROP_UID)][0];
if (strLen($ldap_uid) < 1) {
return new GsError('Could not find user by "' . GS_LDAP_PROP_USER . '=' . $user . '" in search base "' . GS_LDAP_SEARCHBASE . '" in LDAP.');
}
}
$dn = GS_LDAP_PROP_UID . '=' . $ldap_uid . ',' . GS_LDAP_SEARCHBASE;
# delete number
#
$ok = @ldap_mod_del($ldap, $dn, array(GS_EXTERNAL_NUMBERS_LDAP_PROP => $number));
if (!$ok) {
if (@ldap_errNo($ldap) == 16) {
// err #16 is: "No such attribute"
return new GsError('No such number.');
}
return new GsError('Failed to delete number for LDAP user "' . $dn . '". - ' . gs_get_ldap_error($ldap));
}
break;
case 'db':
default:
# check if number exists (to return proper err msg)
#
$num = (int) $db->executeGetOne('SELECT COUNT(*) FROM `users_external_numbers` WHERE `user_id`=' . $user_id . ' AND `number`=\'' . $db->escape($number) . '\'');
if ($num < 1) {
return new GsError('No such number.');
}
# delete number
#
$ok = $db->execute('DELETE FROM `users_external_numbers` WHERE `user_id`=' . $user_id . ' AND `number`=\'' . $db->escape($number) . '\'');
if (!$ok) {
return new GsError('Failed to delete external number.');
}
break;
}
return true;
}
function gs_user_external_numbers_get($user)
{
if (!preg_match('/^[a-z0-9\\-_.]+$/', $user)) {
return new GsError('User must be alphanumeric.');
}
# connect to db
#
$db = gs_db_master_connect();
if (!$db) {
return new GsError('Could not connect to database.');
}
# get user_id
#
$user_id = $db->executeGetOne('SELECT `id` FROM `users` WHERE `user`=\'' . $db->escape($user) . '\'');
if ($user_id < 1) {
return new GsError('Unknown user.');
}
# get external numbers
#
switch (GS_EXTERNAL_NUMBERS_BACKEND) {
case 'ldap':
//ldapsearch -x -D 'cn=root,dc=example,dc=com' -w secret -b 'ou=People,dc=example,dc=com' '(uid=demo2)' telephoneNumber
$ldap = gs_ldap_connect();
if (!$ldap) {
return new GsError('Could not connect to LDAP server.');
}
$ldap_user = $user;
if (gs_get_conf('GS_LVM_USER_6_DIGIT_INT')) {
$ldap_user = preg_replace('/^0+/', '', $ldap_user);
# if the usernames in your LDAP are integers without a
# leading "0"
}
$userArr = gs_ldap_get_first($ldap, GS_LDAP_SEARCHBASE, GS_LDAP_PROP_USER . '=' . $ldap_user, array(GS_EXTERNAL_NUMBERS_LDAP_PROP));
if (isGsError($userArr)) {
return new GsError($userArr->getMsg());
}
if (!is_array($userArr)) {
//return new GsError( 'User "'. GS_LDAP_PROP_USER .'='. $user .','. GS_LDAP_SEARCHBASE .'" not in LDAP.' );
$numbers = array();
} else {
foreach ($userArr as $key => $arr) {
if (strCaseCmp($key, GS_EXTERNAL_NUMBERS_LDAP_PROP) == 0) {
$numbers = $arr;
sort($numbers);
break;
}
}
}
gs_ldap_disconnect($ldap);
break;
case 'db':
default:
$rs = $db->execute('SELECT `number` FROM `users_external_numbers` WHERE `user_id`=' . $user_id . ' ORDER BY `number`');
if (!$rs) {
return new GsError('Failed to get external numbers.');
}
$numbers = array();
while ($r = $rs->fetchRow()) {
$numbers[] = $r['number'];
}
break;
}
return $numbers;
}
function gs_user_external_number_add($user, $number)
{
if (!preg_match('/^[a-z0-9\\-_.]+$/', $user)) {
return new GsError('User must be alphanumeric.');
}
if (!preg_match('/^[\\d]+$/', $number)) {
return new GsError('Number must be numeric.');
}
# connect to db
#
$db = gs_db_master_connect();
if (!$db) {
return new GsError('Could not connect to database.');
}
# get user_id
#
$user_id = $db->executeGetOne('SELECT `id` FROM `users` WHERE `user`=\'' . $db->escape($user) . '\'');
if ($user_id < 1) {
return new GsError('Unknown user.');
}
# add number
#
switch (GS_EXTERNAL_NUMBERS_BACKEND) {
case 'ldap':
$ldap = gs_ldap_connect();
if (!$ldap) {
return new GsError('Could not connect to LDAP server.');
}
# find ldap user name
#
if (GS_LDAP_PROP_UID === GS_LDAP_PROP_USER) {
$ldap_uid = $user;
if (gs_get_conf('GS_LVM_USER_6_DIGIT_INT')) {
$user = preg_replace('/^0+/', '', $user);
# if the usernames in your LDAP are integers without
# a leading "0"
}
} else {
if (gs_get_conf('GS_LVM_USER_6_DIGIT_INT')) {
$user = preg_replace('/^0+/', '', $user);
# if the usernames in your LDAP are integers without
# a leading "0"
}
$userArr = gs_ldap_get_first($ldap, GS_LDAP_SEARCHBASE, GS_LDAP_PROP_USER . '=' . $user, array(GS_LDAP_PROP_UID));
if (isGsError($userArr)) {
return new GsError($userArr->getMsg());
}
if (!is_array($userArr)) {
return new GsError('Could not find user by "' . GS_LDAP_PROP_USER . '=' . $user . '" in search base "' . GS_LDAP_SEARCHBASE . '" in LDAP.');
}
$ldap_uid = @$userArr[strToLower(GS_LDAP_PROP_UID)][0];
if (strLen($ldap_uid) < 1) {
return new GsError('Could not find user by "' . GS_LDAP_PROP_USER . '=' . $user . '" in search base "' . GS_LDAP_SEARCHBASE . '" in LDAP.');
}
}
$dn = GS_LDAP_PROP_UID . '=' . $ldap_uid . ',' . GS_LDAP_SEARCHBASE;
$ok = @ldap_mod_add($ldap, $dn, array(GS_EXTERNAL_NUMBERS_LDAP_PROP => $number));
if (!$ok && @ldap_errNo($ldap) != 20) {
// err #20 is: "Type or value exists"
return new GsError('Failed to add number to LDAP user "' . $dn . '". - ' . gs_get_ldap_error($ldap));
return false;
}
break;
case 'db':
default:
$ok = $db->execute('REPLACE INTO `users_external_numbers` (`user_id`, `number`) VALUES (' . $user_id . ', \'' . $db->escape($number) . '\')');
if (!$ok) {
return new GsError('Failed to add external number.');
}
break;
}
return true;
}
function _gs_legacy_user_map_lvm($user)
{
global $dispatcher_errors_html;
if (!$user) {
return false;
}
if (GS_LDAP_PROP_UID === GS_LDAP_PROP_USER) {
return $user;
}
$ldap = gs_ldap_connect();
$u = gs_ldap_get_first($ldap, GS_LDAP_SEARCHBASE, '(' . GS_LDAP_PROP_UID . '=' . $user . ')', array(GS_LDAP_PROP_USER));
if (isGsError($u)) {
//echo $u->$msg;
$dispatcher_errors_html[] = sPrintF(htmlEnt(__('Failed to get user "%s" from LDAP server.')), $user);
return false;
}
if (!is_array($u)) {
$dispatcher_errors_html[] = sPrintF(htmlEnt(__('User "%s" not found in LDAP database.')), $user);
return false;
}
$lc_GS_LDAP_PROP_USER = strToLower(GS_LDAP_PROP_USER);
if (!isset($u[$lc_GS_LDAP_PROP_USER])) {
return false;
}
if (!isset($u[$lc_GS_LDAP_PROP_USER][0])) {
return false;
}
$ret = $u[$lc_GS_LDAP_PROP_USER][0];
//if (gs_get_conf('GS_LVM_USER_6_DIGIT_INT')) {
// this check is not really needed as this is a custom function anyway
$ret = str_pad($ret, 6, '0', STR_PAD_LEFT);
//}
return $ret;
}
