23 lines
836 B
Plaintext
23 lines
836 B
Plaintext
@AccessControl.authorizationCheck: #NOT_REQUIRED
|
|
@EndUserText.label: 'Open forge jobs'
|
|
define view entity {{P}}I_FORGE_JOB
|
|
as select from {{p}}forgjob as job
|
|
inner join {{p}}forgart as a1 on a1.article_id = job.article_id
|
|
inner join {{p}}forgart as a2 on a2.article_id = job.article_id
|
|
inner join {{p}}forgcus as c1 on c1.customer_id = a1.customer_id
|
|
inner join {{p}}forgcus as c2 on c2.customer_id = a2.customer_id
|
|
{
|
|
key job.job_id as job_id,
|
|
job.job_date as job_date,
|
|
a1.article_name as article_name,
|
|
a2.weight_kg as weight_kg,
|
|
c1.customer_name as customer_name,
|
|
c2.city as city,
|
|
job.work_min as work_min,
|
|
case when job.work_min > 120
|
|
then 'HEAVY'
|
|
else 'LIGHT'
|
|
end as effort
|
|
}
|
|
where job.job_state = 'O'
|