BDSI export: faire les correction de temps réel uniquement sur le jour courant
Actuellement une donnée temps réel est répercutée sur tous les jours dans l'export BDSI (cf exemple ci-dessous). Ces modifications doivent être appliquées uniquement au jour courant, les autres jours doivent conserver les données théoriques.
ref | jour | dtd | htd | dad | had | drd | hrd | dta | hta | daa | haa | dra | hra | arretchn | course | type | fiable | deviation | etat_harr | etat_hdep |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
'59600' | '2017-09-22' | '2017-09-22' | '12:31:00' | '2017-09-22' | '17:45:06' | '2017-09-22' | '17:45:06' | '2017-09-22' | '12:31:00' | '2017-09-22' | '12:31:00' | '2017-09-22' | '12:31:00' | '7457' | '1254' | 'D' | 'F' | NULL | NULL | NULL |
'59611' | '2017-09-23' | '2017-09-23' | '12:31:00' | '2017-09-23' | '17:45:06' | '2017-09-23' | '17:45:06' | '2017-09-23' | '12:31:00' | '2017-09-23' | '12:31:00' | '2017-09-23' | '12:31:00' | '7457' | '1254' | 'D' | 'F' | NULL | NULL | NULL |
'59622' | '2017-09-24' | '2017-09-24' | '12:31:00' | '2017-09-24' | '17:45:06' | '2017-09-24' | '17:45:06' | '2017-09-24' | '12:31:00' | '2017-09-24' | '12:31:00' | '2017-09-24' | '12:31:00' | '7457' | '1254' | 'D' | 'F' | NULL | NULL | NULL |
'59633' | '2017-09-25' | '2017-09-25' | '12:31:00' | '2017-09-25' | '17:45:06' | '2017-09-25' | '17:45:06' | '2017-09-25' | '12:31:00' | '2017-09-25' | '12:31:00' | '2017-09-25' | '12:31:00' | '7457' | '1254' | 'D' | 'F' | NULL | NULL | NULL |
'59644' | '2017-09-26' | '2017-09-26' | '12:31:00' | '2017-09-26' | '17:45:06' | '2017-09-26' | '17:45:06' | '2017-09-26' | '12:31:00' | '2017-09-26' | '12:31:00' | '2017-09-26' | '12:31:00' | '7457' | '1254' | 'D' | 'F' | NULL | NULL | NULL |
'93350' | '2017-09-22' | '2017-09-22' | '23:02:00' | '2017-09-22' | '23:19:20' | '2017-09-22' | '23:19:20' | '2017-09-22' | '23:01:00' | '2017-09-22' | '23:18:45' | '2017-09-22' | '23:18:45' | '14007' | '2136' | 'R' | 'F' | NULL | NULL | NULL |
'93359' | '2017-09-23' | '2017-09-23' | '23:02:00' | '2017-09-23' | '23:19:20' | '2017-09-23' | '23:19:20' | '2017-09-23' | '23:01:00' | '2017-09-23' | '23:18:45' | '2017-09-23' | '23:18:45' | '14007' | '2136' | 'R' | 'F' | NULL | NULL | NULL |
'93368' | '2017-09-24' | '2017-09-24' | '23:02:00' | '2017-09-24' | '23:19:20' | '2017-09-24' | '23:19:20' | '2017-09-24' | '23:01:00' | '2017-09-24' | '23:18:45' | '2017-09-24' | '23:18:45' | '14007' | '2136' | 'R' | 'F' | NULL | NULL | NULL |
'93377' | '2017-09-25' | '2017-09-25' | '23:02:00' | '2017-09-25' | '23:19:20' | '2017-09-25' | '23:19:20' | '2017-09-25' | '23:01:00' | '2017-09-25' | '23:18:45' | '2017-09-25' | '23:18:45' | '14007' | '2136' | 'R' | 'F' | NULL | NULL | NULL |
'93386' | '2017-09-26' | '2017-09-26' | '23:02:00' | '2017-09-26' | '23:19:20' | '2017-09-26' | '23:19:20' | '2017-09-26' | '23:01:00' | '2017-09-26' | '23:18:45' | '2017-09-26' | '23:18:45' | '14007' | '2136' | 'R' | 'F' | NULL | NULL | NULL |