Changes between Version 12 and Version 13 of AdvancedConcepts

Timestamp:

06/16/26 02:58:08 (26 hours ago)

Author:

231119

Comment:

--

AdvancedConcepts

@@ -67 +67 @@
 {{{
 create or replace view vw_company_available_requests as
-select distinct
+select
        r.id as request_id,
        r.customer_user_id,
-       cus.username as customer_username,
        r.timestamp,
        r.number_of_adult_passengers,
@@ -80 +79 @@
        r.baby_seat_count,
        ca.company_id
-from request r
-         join AppUser cus on r.customer_user_id = cus.id
-         join area a on ST_Contains(a.coverage_polygon, r.start_location)
-         join company_area ca on a.id = ca.area_id
-where r.status = 'pending';
+from company_area ca
+         join area a on ca.area_id = a.id
+         join request r on ST_Intersects(a.coverage_polygon, r.start_location)
+                        and r.status = 'pending';
+select * from vw_company_available_requests where company_id = 3;
 }}}
+
+Резултантно време на извршување:
+[[Image(2.png)]]
 
 **Динамична пресметка на цена преку просторна дистанца**