ça pourra peut etre servir a quelqu’un:
recapitulatif des heures supps + recups avec les motifs…
SELECT from_unixtime(egw_timesheet.ts_start,
get_format(date, ‘eur’)) as date,
egw_addressbook.n_family as nom, egw_addressbook.n_given as prenom,
egw_timesheet.ts_quantity as temps,
egw_categories.cat_name as pourquoi,
egw_timesheet.ts_title as description
from egw_timesheet
inner join egw_addressbook
on (egw_addressbook.account_id = egw_timesheet.ts_owner)
inner join egw_categories
on (egw_categories.cat_id = egw_timesheet.cat_id)
;
