Changes between Version 18 and Version 19 of AdvancedReports


Ignore:
Timestamp:
01/26/22 03:55:19 (2 years ago)
Author:
195115
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • AdvancedReports

    v18 v19  
    116116
    117117{{{#!sql
    118    select distinct u.user_name,u.user_surname,
    119     case when tabela.quarter=1 then tabela.broj_kupeni else 0 end as prv_kvartal,
    120         case when tabela.quarter=2 then tabela.broj_kupeni  else 0 end as vtor_kvartal,
    121     case when tabela.quarter=3 then tabela.broj_kupeni  else 0 end as tret_kvartal,
    122     case when tabela.quarter=4 then tabela.broj_kupeni else 0 end as cetvrt_kvartal,
     118      select distinct u.user_name,u.user_surname,
     119    case when tabela.quarter=1 then tabela.broj_kupeni else 0 end as prv_kvartal_kupeni,
     120        case when tabela.quarter=2 then tabela.broj_kupeni  else 0 end as vtor_kvartal_kupeni,
     121    case when tabela.quarter=3 then tabela.broj_kupeni  else 0 end as tret_kvartal_kupeni,
     122    case when tabela.quarter=4 then tabela.broj_kupeni else 0 end as cetvrt_kvartal_kupeni,
    123123    -------------------------------------------------------------------------------
    124124    case when tabela.quarter=1 then tabela.suma else 0 end as prv_kvartal_suma,