Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- SO.driver_id, SO.tracking_no, MTS.start_time as time_slot_from, MTS.end_time as time_slot_to,
- PARTNER.street as customer_address, SO.delivery_time, PARTNER.name as customer_name, RIGHT(SO.partner_phone,9) as customer_phone,
- SO.product_description, SUPPLIER.name as supplier_name, SO.schedule_channel,
- SO.delivery_coordinates, SO.w3w_receiver as scheduled_coordinates, SO.commitment_date
- FROM
- sale_order as SO INNER JOIN res_partner as PARTNER ON SO.partner_id = PARTNER.id
- INNER JOIN res_partner as SUPPLIER ON SO.supplier_id = SUPPLIER.id
- INNER JOIN mena_timeslot as MTS ON SO.shift = MTS.id
- WHERE
- SO.company_id=1 AND SO.is_c2c=false AND SO.rtos IS NULL AND
- SO.commitment_date >= '%s' AND SO.commitment_date <= '%s'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement