История страницы

...

WITH workers_name AS (
SELECT * FROM get_report_worker_info( CAST(:a_workers AS BIGINT[]) )
)
SELECT wt.*,
EXTRACT(DOW FROM wt.cur_date) AS day_num,
get_object_name(wt.id_dev_beg) as dev_beg_name,
get_object_name(wt.id_dev_end) as dev_end_name,
s.name AS sched_name,
ws.full_name,
ws.firm_name,
ws.dep_name,
ws.job_name,
ws.firm_id,
ws.dep_id,
ws.worker_num,
ws.custom
FROM get_workers_time(:d_date_beg, :d_date_end, :n_calc_plan_id, :a_workers, :c_locale, :b_skip_empty) wt
LEFT JOIN workers_name ws ON wt.worker_id = ws.obj_id
LEFT JOIN schedule s ON sched_id = s.id
ORDER BY ws.full_name, wt.worker_id, wt.cur_date, wt.cal_beg, wt.sort_beg NULLS FIRST;