Changes between Version 13 and Version 14 of AdvancedReports


Ignore:
Timestamp:
07/10/23 18:26:38 (18 months ago)
Author:
201144
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • AdvancedReports

    v13 v14  
    1919* Извештај за сите студенти и сите места каде имаат седено порано (доколку имале седено), кој бил газдата, колку вкупно платиле, и периодот на договорот подредено по име на студент и датум.
    2020{{{
    21 select au.ime as student_ime,au.prezime as student_prezime, aa.apartment_rent as rent, aa.apartment_rent * extract(month from age(aa.date_expires,aa.date_signed)) as total_paid,
    22 appu.ime as owner_ime, appu.prezime as owner_prezime, aa.date_signed, aa.date_expires  from student s
     21select au.ime as student_ime,au.prezime as student_prezime, aa.apartmentrent as rent, aa.apartmentrent * extract(month from age(aa.dateexpires,aa.datesigned)) as total_paid,
     22appu.ime as owner_ime, appu.prezime as owner_prezime, aa.datesigned, aa.dateexpires  from student s
    2323join appuser au on au.userid=s.studentid
    2424left join student_signs ss on ss.studentid = s.studentid
    25 left join apartment_agreement aa on aa.apartment_agreementid=ss.agreementid
     25left join apartment_agreement aa on aa.agreementid=ss.agreementid
    2626join apartment_owner ao on ao.ownerid=aa.ownerid
    2727join appuser appu on appu.userid = ao.ownerid
    28 order by au.ime,aa.date_signed
     28order by au.ime,aa.datesigned
    2929}}}
    3030