Changes between Version 12 and Version 13 of AdvancedReports
- Timestamp:
- 07/10/23 18:25:29 (18 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
AdvancedReports
v12 v13 3 3 * Зa сите студенти извештај за тоа колку пати имаат седено во истиот стан и колку имаат платено вкупно во текот на сите договори за еден стан 4 4 {{{ 5 select stud.studentid, appus.ime, appus.prezime, b.cityname, b.building_adress,6 apt.apartment _adress, aa.date_signed,apt.apartmentid,aa.date_signed,aa.date_expires,5 select stud.studentid, appus.ime, appus.prezime, c.cityname, b.buildingaddress, 6 apt.apartmentfloorandroomnumber , aa.datesigned,apt.apartmentid,aa.datesigned,aa.dateexpires, 7 7 count(apt.apartmentid) as kolku_pati, 8 extract(month from age(aa.date _expires,aa.date_signed)) * sum(aa.apartment_rent) as vkupno_plateno from apartment_agreement as aa8 extract(month from age(aa.dateexpires,aa.datesigned)) * sum(aa.apartmentrent) as vkupno_plateno from apartment_agreement as aa 9 9 join apartment apt on apt.apartmentid = aa.apartmentid 10 join student_signs ss on ss.agreementid = aa.a partment_agreementid10 join student_signs ss on ss.agreementid = aa.agreementid 11 11 join student stud on stud.studentid = ss.studentid 12 12 join appuser appus on appus.userid = stud.studentid 13 join building b on apt.buildingid = b.buildingid 13 join building b on apt.buildingid = b.buildingid 14 join city c on c.cityid = b.cityid 14 15 group by 1,2,3,4,5,6,7,8,9,10 15 16 order by stud.studentid