git.schokokeks.org
Repositories
Help
Report an Issue
webinterface.git
Code
Commits
Branches
Tags
Suche
Strukturansicht:
5a312ed
Branches
Tags
master
ticket
webinterface.git
modules
su
include
su.php
Tabelle 'kundenkontakt' komplett entfernt
bernd
commited
5a312ed
at 2010-02-21 08:26:39
su.php
Blame
History
Raw
<?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; } function find_customers($string) { $string = mysql_real_escape_string(chop($string)); $return = array(); $result = db_query("SELECT k.id FROM kundendaten.kunden AS k LEFT JOIN system.useraccounts AS u ON (k.id=u.kunde) WHERE ". "firma LIKE '%{$string}%' OR firma2 LIKE '%{$string}%' OR ". "nachname LIKE '%{$string}%' OR vorname LIKE '%{$string}%' OR ". "adresse LIKE '%{$string}%' OR adresse2 LIKE '%{$string}%' OR ". "ort LIKE '%{$string}%' OR pgp_id LIKE '%{$string}%' OR ". "notizen LIKE '%{$string}%' OR email_rechnung LIKE '%{$string}%' OR ". "email LIKE '%{$string}%' OR email_extern LIKE '%{$string}%' OR u.name LIKE '%{$string}%' OR ". "u.username LIKE '%{$string}%' OR k.id='{$string}' OR u.uid='{$string}';"); while ($entry = mysql_fetch_assoc($result)) $return[] = $entry['id']; $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; }