Skip to content

Latest commit

 

History

History
44 lines (28 loc) · 1.15 KB

README.md

File metadata and controls

44 lines (28 loc) · 1.15 KB

Tables Orders

| id | status | created_at | event_id | parent_order_id |

Events

| id | name | event_start | Tickets

| id | order_id | price | color | ReturnTickets

| id | order_id | price | color |

Need to translate

Приклад 01.01.16 продали три квитки по 50 грн 02.01.16 повернули 1 квиток за 50 грн (з цього ж ордера)

Звіт за 01.01.16 Вертає

price color payed_tickets_count returned_tickets_count result_tickets_count total_price event_name event_start
50 red 3 0 3 150 lolo 2016-01-03 00:00:00

Звіт за 01-02.01.16 Вертає

price color payed_tickets_count returned_tickets_count result_tickets_count total_price event_name event_start
50 red 3 1 2 100 lolo 2016-01-03 00:00:00

Звіт за 002.01.16 Вертає

price color payed_tickets_count returned_tickets_count result_tickets_count total_price event_name event_start
50 red 0 1 -1 -50 lolo 2016-01-03 00:00:00