Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Сначала идет группировка по дням ПЕРВОГО ПРИЕМА ПОСЫЛКИ.
- Пример1.Допустим 10.12.2018 было принято 2 POSYLKI(a1,b2)
- day0. день_приема. была вручена 1 POSYLKA из 2х. day0=(1*100)/2 = 50%
- day1. день_приема+1день. была вручена 1 POSYLKA из 2х. day1=(1*100)/2 = 50%
- day2.день_приема+2дней. не было вручений.
- если все посылки за 10.12.2018 уже вручены далее ставим просто 100%(day3 = 100%,day4 = 100%... и.т.д)
- Пример2.Допустим 12.12.2018 было принято 3 POSYLKI(c3,d4,e5)
- day0. день_приема. была вручено 0 POSYLKA из 3х. day0=(0*100)/3 = 0%
- day1. день_приема+1день. была вручена 1 POSYLKA из 3х. day1=(1*100)/3 = 33%
- day2.день_приема+2дней. было вручено 2 POSYLKA их 3х. day2=(2*100)/3 = 67%
- если все посылки за 12.12.2018 уже вручены далее ставим просто 100%(day3 = 100%,day4 = 100%... и.т.д)
- Пример3.Допустим 16.12.2018 было принята 1 POSYLKI(f6)
- day0. день_приема. была вручено 0 POSYLKA из 1х. day0=(0*100)/1 = 0%
- day1. день_приема+1день. была вручена 1 POSYLKA из 1х. day1=(0*100)/1 = 0%
- day2.день_приема+2дней. было вручено 2 POSYLKA их 1х. day2=(0*100)/1 = 0%
- day3.день_приема+3дня.было вручено 1 POSYLKA их 1х. day3=(1*100)/1 = 100%
- то есть если все посылки за 16.12.2018 уже вручены ставим просто 100%(day4 = 100%... и.т.д) [![введите сюда описание изображения][1]][1]
- select 1 as id,to_date('10.12.2018 01:00:00','dd.mm.yyyy hh24:mi:ss') as date_reg,'a1' as nomer_posylki,'Прием' as oper_code from dual union all
- select 2 as id,to_date('10.12.2018 02:00:00','dd.mm.yyyy hh24:mi:ss') as date_reg,'a1' as nomer_posylki,'Сортировка' as oper_code from dual union all
- select 3 as id,to_date('10.12.2018 03:00:00','dd.mm.yyyy hh24:mi:ss') as date_reg,'a1' as nomer_posylki,'Прием' as oper_code from dual union all
- select 4 as id,to_date('10.12.2018 04:00:00','dd.mm.yyyy hh24:mi:ss') as date_reg,'a1' as nomer_posylki,'Вручено' as oper_code from dual union all
- select 5 as id,to_date('10.12.2018 01:00:00','dd.mm.yyyy hh24:mi:ss') as date_reg,'b2' as nomer_posylki,'Прием' as oper_code from dual union all
- select 6 as id,to_date('11.12.2018 02:00:00','dd.mm.yyyy hh24:mi:ss') as date_reg,'b2' as nomer_posylki,'Вручено' as oper_code from dual union all
- select 7 as id,to_date('12.12.2018 01:00:00','dd.mm.yyyy hh24:mi:ss') as date_reg,'c3' as nomer_posylki,'Прием' as oper_code from dual union all
- select 8 as id,to_date('13.12.2018 02:00:00','dd.mm.yyyy hh24:mi:ss') as date_reg,'c3' as nomer_posylki,'Вручено' as oper_code from dual union all
- select 9 as id,to_date('12.12.2018 01:00:00','dd.mm.yyyy hh24:mi:ss') as date_reg,'d4' as nomer_posylki,'Прием' as oper_code from dual union all
- select 10 as id,to_date('14.12.2018 02:00:00','dd.mm.yyyy hh24:mi:ss') as date_reg,'d4' as nomer_posylki,'Вручено' as oper_code from dual union all
- select 11 as id,to_date('12.12.2018 07:00:00','dd.mm.yyyy hh24:mi:ss') as date_reg,'e5' as nomer_posylki,'Прием' as oper_code from dual union all
- select 12 as id,to_date('12.12.2018 09:00:00','dd.mm.yyyy hh24:mi:ss') as date_reg,'e5' as nomer_posylki,'Сортировка' as oper_code from dual union all
- select 11 as id,to_date('12.12.2018 10:00:00','dd.mm.yyyy hh24:mi:ss') as date_reg,'e5' as nomer_posylki,'Прием' as oper_code from dual union all
- select 13 as id,to_date('14.12.2018 11:00:00','dd.mm.yyyy hh24:mi:ss') as date_reg,'e5' as nomer_posylki,'Вручено' as oper_code from dual union all
- select 14 as id,to_date('16.12.2018 01:00:00','dd.mm.yyyy hh24:mi:ss') as date_reg,'f6' as nomer_posylki,'Прием' as oper_code from dual union all
- select 15 as id,to_date('19.12.2018 02:00:00','dd.mm.yyyy hh24:mi:ss') as date_reg,'f6' as nomer_posylki,'Вручено' as oper_code from dual
Add Comment
Please, Sign In to add comment