%A delivery_alert is reported if a delivery_confirmation has not been reported
%within ten minutes of the commited delivery time.
% check_delivery/4
exceptionAlarmAbsoluteDatime(check_delivery(DeliveryRequestId,StoreId,DriverId,
        DeliveryTime),CheckTimeDelivery)<-
        assignment(DeliveryRequestId,StoreId,ToCoordinates,DeliveryTime,
                DriverId,_ScheduledPickupTime) where
        (check_delivery_time(WaitDuration),
                addSec_Datime(WaitDuration,DeliveryTime,CheckTimeDelivery)).
print_trigger(check_delivery/4).

/ Automatic takes the first bid "among the selected drivers".
// "Two minutes after the broadcast ..." in the spec implies that we wait for
// the two minutes, rather than picking off the first bid as it appears.

CREATE STREAM AutoDeliveryBid ;

INSERT INTO AutoDeliveryBid
SELECT CB.*,
  DS.RequestID AS DSRequestID,
  DS.DeliveryLatitude AS DeliveryLatitude,
  DS.DeliveryLongitude AS DeliveryLongitude,
  DS.RequiredPickUpTime AS RequiredPickUpTime,
  DS.RequiredDeliveryTime AS RequiredDeliveryTime,
  DS.Store AS DSStore
FROM DeliverySelection AS DS LEFT OUTER JOIN CurrentBids AS CB
ON DS.RequestID = CB.RequestID
WHERE DS.Automatic
ORDER BY Ts PER CB.RequestID   
LIMIT 1 ROWS PER CB.RequestID;