Created
March 24, 2017 20:50
-
-
Save matheusoliveira-luizalabs/f4abfaac7cbf2dbb5a08ff6f60ca074f to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- GroupOrders | |
| SELECT | |
| GroupOrder.uuid AS `GroupOrder.uuid`, | |
| GroupOrder.order_id AS `GroupOrder.id`, | |
| GroupOrder.ecommerce_id AS `GroupOrder.ecommerceId`, | |
| GroupOrder.customer_id AS `GroupOrder.customerId`, | |
| GroupOrder.created_at AS `GroupOrder.created_at`, | |
| SalesChannel.uuid AS `GroupOrder.SalesChannel.uuid`, | |
| SalesChannel.id AS `GroupOrder.SalesChannel.id`, | |
| GroupOrderTimelines.uuid AS `GroupOrder.GroupOrderTimelines.uuid`, | |
| GroupOrderTimelines.note AS `GroupOrder.GroupOrderTimelines.note`, | |
| GroupOrderTimelines.current AS `GroupOrder.GroupOrderTimelines.current`, | |
| GroupOrderTimelines.created_by AS `GroupOrder.GroupOrderTimelines.created_by`, | |
| GroupOrderTimelines.created_at AS `GroupOrder.GroupOrderTimelines.created_at`, | |
| Status.uuid AS `GroupOrder.GroupOrderTimelines.Status.uuid`, | |
| Status.uuid AS `GroupOrder.GroupOrderTimelines.Status.uuid`, | |
| Status.id AS `GroupOrder.GroupOrderTimelines.Status.id`, | |
| Platform.id AS `GroupOrder.GroupOrderTimelines.Plaftorm.id`, | |
| -- SubOrders | |
| ( | |
| SELECT | |
| SubOrder.uuid AS `SubOrder.uuid`, | |
| SubOrder.sub_order_id AS `SubOrder.subOrderId`, | |
| SubOrder.occurrence_id AS `SubOrder.occurrenceId`, | |
| SubOrder.created_at AS `SubOrder.created_at`, | |
| SubOrderTimelines.uuid AS `SubOrder.SubOrderTimelines.uuid`, | |
| SubOrderTimelines.note AS `SubOrder.SubOrderTimelines.note`, | |
| SubOrderTimelines.current AS `SubOrder.SubOrderTimelines.current`, | |
| SubOrderTimelines.created_by AS `SubOrder.SubOrderTimelines.created_by`, | |
| SubOrderTimelines.created_at AS `SubOrder.SubOrderTimelines.created_at`, | |
| Status.uuid AS `SubOrder.SubOrderTimelines.Status.uuid`, | |
| Status.uuid AS `SubOrder.SubOrderTimelines.Status.uuid`, | |
| Status.id AS `SubOrder.SubOrderTimelines.Status.id`, | |
| Platform.id AS `SubOrder.SubOrderTimelines.Plaftorm.id` | |
| FROM | |
| sub_orders AS SubOrder | |
| LEFT JOIN | |
| sub_orders_timelines AS SubOrderTimelines | |
| ON | |
| SubOrderTimelines.sub_order_uuid= SubOrder.uuid | |
| LEFT JOIN | |
| statuses AS Status | |
| ON | |
| Status.uuid= SubOrderTimelines.status_uuid | |
| LEFT JOIN | |
| platforms AS Platform | |
| ON | |
| Platform.uuid= Status.platform_uuid | |
| WHERE | |
| SubOrder.group_order_uuid = `GroupOrder.uuid` | |
| -- AND | |
| -- SubOrder.sub_order_id = :order_id | |
| -- AND | |
| -- SubOrder.ecommerce_id = :ecommerce_id | |
| -- AND | |
| -- SubOrder.customer_id = :customer_id | |
| -- AND | |
| -- Status.id = :status_id | |
| -- AND | |
| -- Status.id in (:status_id_in) | |
| -- AND | |
| -- Platform.id = (:platform_id) | |
| ORDER BY | |
| SubOrder.created_at ASC | |
| ) AS SubOrders | |
| FROM | |
| group_orders AS GroupOrder | |
| LEFT JOIN | |
| sales_channels AS SalesChannel | |
| ON | |
| SalesChannel.uuid= GroupOrder.sales_channel_uuid | |
| LEFT JOIN | |
| group_orders_timelines AS GroupOrderTimelines | |
| ON | |
| GroupOrderTimelines.group_order_uuid= GroupOrder.uuid | |
| LEFT JOIN | |
| statuses AS Status | |
| ON | |
| Status.uuid= GroupOrderTimelines.status_uuid | |
| LEFT JOIN | |
| platforms AS Platform | |
| ON | |
| Platform.uuid= Status.platform_uuid | |
| -- WHERE | |
| -- GroupOrder.order_id = :order_id | |
| -- AND | |
| -- GroupOrder.ecommerce_id = :ecommerce_id | |
| -- AND | |
| -- GroupOrder.customer_id = :customer_id | |
| -- AND | |
| -- Status.id = :status_id | |
| -- AND | |
| -- Status.id in (:status_id_in) | |
| -- AND | |
| -- Platform.id = (:platform_id) | |
| ORDER BY | |
| GroupOrder.created_at ASC | |
| LIMIT 0, 50; | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment