Revision 3816bb51
Von Moritz Bunkus vor fast 11 Jahren hinzugefügt
| SL/DB/Contact.pm | ||
|---|---|---|
| 1 |
# This file has been auto-generated only because it didn't exist. |
|
| 2 |
# Feel free to modify it at will; it will not be overwritten automatically. |
|
| 3 |
|
|
| 4 | 1 |
package SL::DB::Contact; |
| 5 | 2 |
|
| 6 | 3 |
use strict; |
| 7 | 4 |
|
| 8 | 5 |
use SL::DB::MetaSetup::Contact; |
| 6 |
use SL::DB::Manager::Contact; |
|
| 9 | 7 |
use SL::DB::Helper::CustomVariables ( |
| 10 | 8 |
module => 'Contacts', |
| 11 | 9 |
cvars_alias => 1, |
| 12 | 10 |
); |
| 13 | 11 |
|
| 14 |
# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. |
|
| 15 |
__PACKAGE__->meta->make_manager_class; |
|
| 16 |
|
|
| 17 | 12 |
__PACKAGE__->meta->initialize; |
| 18 | 13 |
|
| 19 | 14 |
sub used {
|
| SL/DB/Manager/Contact.pm | ||
|---|---|---|
| 1 |
package SL::DB::Manager::Contact; |
|
| 2 |
|
|
| 3 |
use strict; |
|
| 4 |
|
|
| 5 |
use SL::DB::Helper::Manager; |
|
| 6 |
use base qw(SL::DB::Helper::Manager); |
|
| 7 |
|
|
| 8 |
use SL::DB::Helper::Sorted; |
|
| 9 |
|
|
| 10 |
sub object_class { 'SL::DB::Contact' }
|
|
| 11 |
|
|
| 12 |
__PACKAGE__->make_manager_methods; |
|
| 13 |
|
|
| 14 |
sub _sort_spec {
|
|
| 15 |
return ( |
|
| 16 |
default => [ 'full_name', 1 ], |
|
| 17 |
columns => {
|
|
| 18 |
SIMPLE => 'ALL', |
|
| 19 |
full_name => [ 'lower(contacts.cp_name)', 'lower(contacts.cp_givenname)', ], |
|
| 20 |
map { ( $_ => "lower(contacts.cp_$_)" ) } qw(abteilung city email fax givenname mobile1 mobile2 name phone1 phone2 position privatemail privatphone project satfax satphone street title zipcode)
|
|
| 21 |
}); |
|
| 22 |
} |
|
| 23 |
|
|
| 24 |
1; |
|
| bin/mozilla/do.pl | ||
|---|---|---|
| 276 | 276 |
$::form->{ALL_SHIPTO} = SL::DB::Manager::Shipto->get_all(query => [
|
| 277 | 277 |
or => [ trans_id => $::form->{"$::form->{vc}_id"} * 1, and => [ shipto_id => $::form->{shipto_id} * 1, trans_id => undef ] ]
|
| 278 | 278 |
]); |
| 279 |
$::form->{ALL_CONTACTS} = SL::DB::Manager::Contact->get_all(query => [
|
|
| 279 |
$::form->{ALL_CONTACTS} = SL::DB::Manager::Contact->get_all_sorted(query => [
|
|
| 280 | 280 |
or => [ |
| 281 | 281 |
cp_cv_id => $::form->{"$::form->{vc}_id"} * 1,
|
| 282 | 282 |
and => [ |
| bin/mozilla/ir.pl | ||
|---|---|---|
| 270 | 270 |
"price_factors" => "ALL_PRICE_FACTORS"); |
| 271 | 271 |
|
| 272 | 272 |
$TMPL_VAR{ALL_EMPLOYEES} = SL::DB::Manager::Employee->get_all_sorted(query => [ or => [ id => $::form->{employee_id}, deleted => 0 ] ]);
|
| 273 |
$TMPL_VAR{ALL_CONTACTS} = SL::DB::Manager::Contact->get_all(query => [
|
|
| 273 |
$TMPL_VAR{ALL_CONTACTS} = SL::DB::Manager::Contact->get_all_sorted(query => [
|
|
| 274 | 274 |
or => [ |
| 275 | 275 |
cp_cv_id => $::form->{"$::form->{vc}_id"} * 1,
|
| 276 | 276 |
and => [ |
| bin/mozilla/is.pl | ||
|---|---|---|
| 322 | 322 |
$TMPL_VAR{ALL_SHIPTO} = SL::DB::Manager::Shipto->get_all(query => [
|
| 323 | 323 |
or => [ trans_id => $::form->{"$::form->{vc}_id"} * 1, and => [ shipto_id => $::form->{shipto_id} * 1, trans_id => undef ] ]
|
| 324 | 324 |
]); |
| 325 |
$TMPL_VAR{ALL_CONTACTS} = SL::DB::Manager::Contact->get_all(query => [
|
|
| 325 |
$TMPL_VAR{ALL_CONTACTS} = SL::DB::Manager::Contact->get_all_sorted(query => [
|
|
| 326 | 326 |
or => [ |
| 327 | 327 |
cp_cv_id => $::form->{"$::form->{vc}_id"} * 1,
|
| 328 | 328 |
and => [ |
| bin/mozilla/oe.pl | ||
|---|---|---|
| 348 | 348 |
$TMPL_VAR{ALL_SHIPTO} = SL::DB::Manager::Shipto->get_all(query => [
|
| 349 | 349 |
or => [ trans_id => $::form->{"$::form->{vc}_id"} * 1, and => [ shipto_id => $::form->{shipto_id} * 1, trans_id => undef ] ]
|
| 350 | 350 |
]); |
| 351 |
$TMPL_VAR{ALL_CONTACTS} = SL::DB::Manager::Contact->get_all(query => [
|
|
| 351 |
$TMPL_VAR{ALL_CONTACTS} = SL::DB::Manager::Contact->get_all_sorted(query => [
|
|
| 352 | 352 |
or => [ |
| 353 | 353 |
cp_cv_id => $::form->{"$::form->{vc}_id"} * 1,
|
| 354 | 354 |
and => [ |
Auch abrufbar als: Unified diff
Ansprechpersonen-Drop-Downs in mehreren Masken sortiert anzeigen