modules/su/include/su.php (8ae49b3) - webinterface.git

su.php

<?php

require_once('inc/base.php');

function list_system_users()
{
  require_role(ROLE_SYSADMIN);

$result = db_query("SELECT uid,username FROM system.v_useraccounts ORDER BY username");
  
  $ret = array();
  while ($item = mysql_fetch_object($result))
    array_push($ret, $item);
  return $ret;
}

function list_customers()
{
  require_role(ROLE_SYSADMIN);

$result = db_query("SELECT id, IF(firma IS NULL, CONCAT_WS(' ', vorname, nachname), CONCAT(firma, ' (', CONCAT_WS(' ', vorname, nachname), ')')) AS name FROM kundendaten.kunden");
  
  $ret = array();
  while ($item = mysql_fetch_object($result))
    array_push($ret, $item);
  return $ret;
}

$result = db_query("SELECT kunde FROM kundendaten.domains WHERE kunde IS NOT NULL AND (
                      domainname LIKE '%{$string}%' OR CONCAT_WS('.', domainname, tld) LIKE '%{$string}%'
                      )");

while ($entry = mysql_fetch_assoc($result))
    $return[] = $entry['kunde'];

return $return;
}

function find_users_for_customer($id)
{
  $id = (int) $id;
  $return = array();
  $result = db_query("SELECT uid, username FROM system.useraccounts WHERE ".
                     "kunde='{$id}';");
  while ($entry = mysql_fetch_assoc($result))
    $return[$entry['uid']] = $entry['username'];

return $return;
}

webinterface.git

Finde Kunden auch anhand von DOmains