Project

General

Profile

Actions

기능(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.

Status:
완료성공(Resolve)
Priority:
보통(Normal)
Assignee:
Start date:
08/25/2025
Due date:
09/10/2025
% Done:

100%

Estimated time:
16.00 h
Spent time:
Part:
Build env.:
Prod


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
Actions #1

Updated by Joseph Vo 7 months ago

  • Assignee changed from Joseph Vo to John Lee
Actions #2

Updated by Joseph Vo 7 months ago

  • Assignee changed from John Lee to Mon Nguyen
Actions #3

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

Actions #4

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.

Actions #5

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

Actions #6

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.

Actions #7

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 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.

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

Actions #8

Updated by Lexi Kim 7 months ago

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.

Actions #9

Updated by ziniy Kang 7 months ago

  • Assignee changed from Lexi Kim to Mon Nguyen
Actions #10

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

Actions #11

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

Actions #12

Updated by Mon Nguyen 7 months ago

Update final decide

Actions #13

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
Actions #14

Updated by Mon Nguyen 7 months ago

  • Status changed from 진행(Doing) to 신규(New)
Actions #15

Updated by Mon Nguyen 6 months ago

Hold to solve this task first http://redmine.ohmytrip.com/issues/1279

Actions #16

Updated by harry harry 6 months ago

  • Assignee changed from Mon Nguyen to John Lee
Actions #17

Updated by harry harry 6 months ago

  • Due date changed from 08/28/2025 to 09/12/2025
Actions #18

Updated by harry harry 6 months ago

  • Subject changed from Add Monthly Statistics to [FE] Add Monthly Statistics
Actions #19

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
Actions #20

Updated by harry harry 6 months ago

  • Due date changed from 09/12/2025 to 09/10/2025
Actions #21

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
Actions #22

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

Actions #23

Updated by Mon Nguyen 6 months ago

  • Status changed from 진행(Doing) to 완료(Done)
  • % Done changed from 90 to 100

Applied on Dev Env

Actions #24

Updated by Mon Nguyen 6 months ago

  • Build env. changed from Dev to Prod

Applied PRD env

Actions #25

Updated by ziniy Kang 6 months ago

  • Status changed from 완료(Done) to 완료성공(Resolve)
Actions #26

Updated by ziniy Kang 5 months ago

  • Parent task changed from #1087 to #2032
Actions #27

Updated by ziniy Kang 5 months ago

  • Parent task changed from #2032 to #1087
Actions

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 50 MB)