기능(Feature) #1185
closed기능(Feature) #1040: * OMH COUPON
개선(improvement) #2032: + OMH COUPON (Ho Chi Minh)
기능(Feature) #1087: ADMIN
[BE] Add Monthly Statistics
Added by ziniy Kang 7 months ago. Updated 5 months ago.
Files
| picture723-1.png (81.5 KB) picture723-1.png | ziniy Kang, 08/20/2025 09:10 AM | ||
| image.png (26.4 KB) image.png | Lexi Kim, 08/21/2025 05:24 AM | ||
| Finally decide.png (33.7 KB) Finally decide.png | Mon Nguyen, 08/22/2025 01:29 AM |
Updated by Mon Nguyen 7 months ago
- Assignee changed from Mon Nguyen to ziniy Kang
Dear ziniy Kang
Please help me answer some question:
1. The Price exchange to KRW follow the booking time or current time report ?
2. Have any condition between booking Confirmed and Cancelled for sum Amount Coupon use ?
Thank you
Updated by Lexi Kim 7 months ago
Dear Mon Nguyen,
1. The Price exchange to KRW follow the booking time or current time report ?
=> current time.
2. Have any condition between booking Confirmed and Cancelled for sum Amount Coupon use ?
=> The Coupon Value for refunded reservations is 0. On the Monthly Statistics page, only values with the Coupon value are displayed.
Updated by Mon Nguyen 7 months ago
Lexi Kim wrote in #note-4:
Dear Mon Nguyen,
1. The Price exchange to KRW follow the booking time or current time report ?
=> current time.2. Have any condition between booking Confirmed and Cancelled for sum Amount Coupon use ?
=> The Coupon Value for refunded reservations is 0. On the Monthly Statistics page, only values with the Coupon value are displayed.
About the first answer
The Amount Coupon use at booking time will difference current time base on the exchange rate between every currency
So, the monthly coupon amount use we get on the last month will gonna be difference today when we check by action get list or export excel
Vietnamese: Nếu lấy theo tỷ giá hiện tại thì số tiền Coupon xem tại thời điểm cùng ngày vào tháng trước với hiện tại sẽ khác nhau
Please confirm the last one, did we follow this way ?
Thank you
Updated by Lexi Kim 7 months ago
About the first answer
The Amount Coupon use at booking time will difference current time base on the exchange rate between every currency
So, the monthly coupon amount use we get on the last month will gonna be difference today when we check by action get list or export excel
Vietnamese: Nếu lấy theo tỷ giá hiện tại thì số tiền Coupon xem tại thời điểm cùng ngày vào tháng trước với hiện tại sẽ khác nhau
Please confirm the last one, did we follow this way ?
Thank you
You mean there is a difference between Sum Value and Total Value, which is indicated in KRW , right?
Please follow this way. Thank you.
Updated by Mon Nguyen 7 months ago
- Assignee changed from ziniy Kang to Lexi Kim
Lexi Kim wrote in #note-6:
About the first answer
The Amount Coupon use at booking time will difference current time base on the exchange rate between every currency
So, the monthly coupon amount use we get on the last month will gonna be difference today when we check by action get list or export excel
Vietnamese: Nếu lấy theo tỷ giá hiện tại thì số tiền Coupon xem tại thời điểm cùng ngày vào tháng trước với hiện tại sẽ khác nhau
Please confirm the last one, did we follow this way ?
Thank youYou mean there is a difference between Sum Value and Total Value, which is indicated in KRW , right?
Please follow this way. Thank you.
Dear Lexi Kim
Example: at 2025-07-20 I check the sum value of January 2025 it's 200,000 KRW
at 2025-08-20 I check the sum value of January 2025 it's 210,000 KRW
=> that's difference 10,000 KRW because we summaries by current time Exchange, not the booking time exchange
So, that why I make confirm again to you
Please let me the finally decide, thank you
Updated by Mon Nguyen 7 months ago
Lexi Kim wrote in #note-8:
We will decide to apply the exchange rate and display it based on the payment time of each booking time.
I added it to storyboard too. Thank you.
Ok, I got it
Updated by Mon Nguyen 7 months ago
- Assignee changed from Mon Nguyen to Lexi Kim
Dear Lexi Kim
About one more question, Did we show both the record every monthly use coupon sum is 0 ?
Thank you
Updated by Mon Nguyen 7 months ago
- File Finally decide.png Finally decide.png added
- Assignee changed from Lexi Kim to Mon Nguyen
Update final decide

Updated by Mon Nguyen 7 months ago
- Due date set to 08/28/2025
- Status changed from 신규(New) to 진행(Doing)
- Start date set to 08/25/2025
- Estimated time set to 32.00 h
Updated by Mon Nguyen 6 months ago
Hold to solve this task first http://redmine.ohmytrip.com/issues/1279
Updated by harry harry 6 months ago
- Assignee changed from Mon Nguyen to John Lee
Updated by harry harry 6 months ago
- Due date changed from 08/28/2025 to 09/12/2025
Updated by harry harry 6 months ago
- Subject changed from Add Monthly Statistics to [FE] Add Monthly Statistics
Updated by harry harry 6 months ago
- Subject changed from [FE] Add Monthly Statistics to [BE] Add Monthly Statistics
- Assignee changed from John Lee to Mon Nguyen
Updated by harry harry 6 months ago
- Due date changed from 09/12/2025 to 09/10/2025
Updated by Mon Nguyen 6 months ago
- Status changed from 신규(New) to 진행(Doing)
- % Done changed from 0 to 50
- Estimated time changed from 32.00 h to 16.00 h
Updated by Mon Nguyen 6 months ago
- % Done changed from 50 to 90
- Build env. set to Dev
Finish update code & applied on dev env
Waiting feedback & fix if any
Updated by Mon Nguyen 6 months ago
- Status changed from 진행(Doing) to 완료(Done)
- % Done changed from 90 to 100
Applied on Dev Env
Updated by ziniy Kang 6 months ago
- Status changed from 완료(Done) to 완료성공(Resolve)

