wir nutzen hier ein OTRS 3.2.5 mit vielen Eigenanpassungen.
Ich habe das Kundenbackend wie folgt angepasst:
Code: Select all
$Self->{CustomerUser} = {
Name => 'Customer Database',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
<parameter>
},
CustomerKey => 'login',
CustomerID => 'customer_id',
CustomerValid => 'valid_id',
CustomerUserListFields => ['haendlername', 'email', 'zip'],
CustomerUserSearchFields => ['haendlername', 'last_name', 'haendlernummer', 'zip'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
# CustomerUserPostMasterSearchFields => ['email'],
CustomerUserNameFields => ['haendlername'],
CustomerUserEmailUniqCheck => 0,
AutoLoginCreation => 1,
CacheTTL => 0,
AdminSetPreferences => 0,
Map => [
# var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly, http-link-target
# [ 'UserTitle', 'Title', 'title', 0, 0, 'var', '', 0 ],
[ 'Haendlername', 'Haendlername', 'haendlername', 1, 1, 'var', '', 0],
# [ 'UserFirstname', 'Firstname', 'first_name', 0, 0, 'var', '', 0 ],
[ 'UserLastname', 'Name', 'last_name', 1, 0, 'var', '', 0 ],
#[ 'UserPassword', 'Password', 'pw', 0, 0, 'var', '', 0 ],
# [ 'UserEmail', 'Email', 'email', 0, 0, 'var', '', 0 ],
[ 'Haendlernummer', 'Haendlernummer', 'haendlernummer', 1, 1, 'int', '', 0 ],
[ 'UserPhone', 'Phone', 'phone', 1, 0, 'var', '', 0 ],
[ 'UserFax', 'Fax', 'fax', 1, 0, 'var', '', 0 ],
[ 'UserMobile', 'Mobile', 'mobile', 1, 0, 'var', '', 0 ],
[ 'UserStreet', 'Street', 'street', 1, 0, 'var', '', 0 ],
[ 'UserZip', 'Zip', 'zip', 1, 0, 'int', '', 0 ],
[ 'UserCity', 'City', 'city', 1, 0, 'var', '', 0 ],
[ 'UserCountry', 'Country', 'country', 1, 0, 'var', '', 0 ],
[ 'UserComment', 'Comment', 'comments', 1, 0, 'var', '', 0 ],
[ 'ValidID', 'Valid', 'valid_id', 0, 1, 'int', '', 0 ],
[ 'UserLogin', 'Username', 'login', 0, 0, 'var', '', 0 ],
],
# default selections
Selections => {
UserTitle => {
'Mr.' => 'Mr.',
'Mrs.' => 'Mrs.',
},
},
};
Code: Select all
mysql> explain customer_user;
+----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| login | varchar(200) | NO | UNI | NULL | |
| email | varchar(150) | NO | | NULL | |
| customer_id | varchar(150) | NO | | NULL | |
| pw | varchar(64) | YES | | NULL | |
| title | varchar(50) | YES | | NULL | |
| first_name | varchar(100) | YES | | NULL | |
| last_name | varchar(100) | NO | | NULL | |
| phone | varchar(150) | YES | | NULL | |
| fax | varchar(150) | YES | | NULL | |
| mobile | varchar(150) | YES | | NULL | |
| street | varchar(150) | YES | | NULL | |
| zip | varchar(200) | YES | | NULL | |
| city | varchar(200) | YES | | NULL | |
| country | varchar(200) | YES | | NULL | |
| comments | varchar(250) | YES | | NULL | |
| valid_id | smallint(6) | NO | MUL | NULL | |
| create_time | datetime | NO | | NULL | |
| create_by | int(11) | NO | MUL | NULL | |
| change_time | datetime | NO | | NULL | |
| change_by | int(11) | NO | MUL | NULL | |
| haendlername | varchar(200) | YES | | NULL | |
| haendlernummer | varchar(200) | YES | | NULL | |
| region | varchar(200) | YES | | NULL | |
+----------------+--------------+------+-----+---------+----------------+
25 rows in set (0.00 sec)
Code: Select all
<!-- dtl:block:OverviewResult -->
<div class="Content ">
<table class="DataTable" id="CustomerTable">
<thead>
<tr>
<th>$Text{"Haendlername"}</th>
<th>$Text{"Name"}</th>
<th>$Text{"Haendlernummer"}</th>
[...]
<!-- dtl:block:OverviewResultRowLink -->
<td><a class="AsBlock" href="$Env{"Baselink"}Action=$Env{"Action"};Subaction=Change;ID=$LQData{"Haendlername"};Search=$LQData{"Search"};Nav=$LQData{"Nav"}">$QData{"Haendlername"}</a></td>
[...]
<td><a class="AsBlock" href="#">$QData{"Haendlername"}</a></td>
[...]
<td>$QData{"UserLastname"}</td>
<td>$QData{"Haendlernummer"}</td>
Hat nun jemand dafuer einen Tipp fuer mich?
VG,
M.