Changes between Version 15 and Version 16 of AdvancedReports

Timestamp:

07/10/23 18:28:54 (11 months ago)

Author:

201144

Comment:

--

AdvancedReports

@@ -48 +48 @@
 * Објавите на газдите и која е разликата меѓу цената објавена и цената потпишана за станот, и колку вкупно имаат заработено во тој договор.
 {{{
-select au.ime,au.prezime,p.cityname as city_posted_for,p.price as posted_price, aa.apartment_rent as signed_price, abs(p.price-aa.apartment_rent) as difference, aa.apartment_rent * extract(month from age(aa.date_expires,aa.date_signed)) as total_euros_earned from apartment_agreement as aa
+select au.ime,au.prezime,c.cityname as city_posted_for,p.price as posted_price, aa.apartmentrent as signed_price, abs(p.price-aa.apartmentrent) as difference, aa.apartmentrent * extract(month from age(aa.dateexpires,aa.datesigned)) as total_euros_earned from apartment_agreement as aa
 join apartment_owner ao on ao.ownerid=aa.ownerid 
 join appuser au on au.userid = ao.ownerid 
 join apartment apt on apt.apartmentid = aa.apartmentid 
 join owner_post op on op.ownerid  = ao.ownerid  
-join post p on p.postid = op.owner_postid 
+join post p on p.postid = op.ownerpostid 
+join city c on c.cityid = p.cityid 
 order by au.ime,difference, total_euros_earned 
 }}}