Revision fdb3de69
Von Bernd Bleßmann vor fast 4 Jahren hinzugefügt
| SL/Controller/TimeRecording.pm | ||
|---|---|---|
|
date => t8('Date'),
|
||
|
start_time => t8('Start'),
|
||
|
end_time => t8('End'),
|
||
|
order => t8('Sales Order'),
|
||
|
customer => t8('Customer'),
|
||
|
part => t8('Article'),
|
||
|
project => t8('Project'),
|
||
| ... | ... | |
|
sorted => \%sort_columns,
|
||
|
disable_plugin => 'paginated',
|
||
|
query => \@where,
|
||
|
with_objects => [ 'customer', 'part', 'project', 'staff_member', 'employee' ],
|
||
|
with_objects => [ 'customer', 'part', 'project', 'staff_member', 'employee', 'order' ],
|
||
|
);
|
||
|
}
|
||
|
|
||
| ... | ... | |
|
my $report = SL::ReportGenerator->new(\%::myconfig, $::form);
|
||
|
$self->{report} = $report;
|
||
|
|
||
|
my @columns = qw(date start_time end_time customer part project description staff_member duration booked);
|
||
|
my @columns = qw(date start_time end_time order customer part project description staff_member duration booked);
|
||
|
|
||
|
my %column_defs = (
|
||
|
date => { text => t8('Date'), sub => sub { $_[0]->date_as_date },
|
||
| ... | ... | |
|
obj_link => sub { $self->url_for(action => 'edit', 'id' => $_[0]->id, callback => $self->models->get_callback) } },
|
||
|
end_time => { text => t8('End'), sub => sub { $_[0]->end_time_as_timestamp },
|
||
|
obj_link => sub { $self->url_for(action => 'edit', 'id' => $_[0]->id, callback => $self->models->get_callback) } },
|
||
|
order => { text => t8('Sales Order'), sub => sub { $_[0]->order && $_[0]->order->number } },
|
||
|
customer => { text => t8('Customer'), sub => sub { $_[0]->customer->displayable_name } },
|
||
|
part => { text => t8('Article'), sub => sub { $_[0]->part && $_[0]->part->displayable_name } },
|
||
|
project => { text => t8('Project'), sub => sub { $_[0]->project && $_[0]->project->displayable_name } },
|
||
| SL/DB/Manager/TimeRecording.pm | ||
|---|---|---|
|
start_time => [ 'date', 'start_time' ],
|
||
|
end_time => [ 'date', 'end_time' ],
|
||
|
customer => [ 'lower(customer.name)', 'date','start_time'],
|
||
|
order => [ 'order.ordnumber', 'date','start_time'],
|
||
|
}
|
||
|
);
|
||
|
}
|
||
Auch abrufbar als: Unified diff
Zeiterfassung: Auftrag im Bericht anzeigen