결함(Bug) #2519
closedSeller Settlement export issue
Added by Tracy Tran 3 months ago. Updated 3 months ago.
100%
Description
Alice > settlement > Seller settlement
Search with condition as image, Alice is displaying 85 bookings with total amount is 1,657,700
Export file displayed wrong information.
multiple channels is displaying in the excel file even though the condition is Webbed DMC only.
Files
| image.png (146 KB) image.png | Tracy Tran, 12/02/2025 11:40 AM | ||
| Screenshot 2025-12-02 184116.png (82.6 KB) Screenshot 2025-12-02 184116.png | Tracy Tran, 12/02/2025 11:41 AM | ||
| Screenshot 2025-12-02 184235.png (254 KB) Screenshot 2025-12-02 184235.png | Tracy Tran, 12/02/2025 11:45 AM | ||
| adminSettlementSeller created on 2025-12-02---2BA6207EF0E44EA28F94E8CFC69C54F9.xlsx (4.19 MB) adminSettlementSeller created on 2025-12-02---2BA6207EF0E44EA28F94E8CFC69C54F9.xlsx | Tracy Tran, 12/02/2025 11:45 AM | ||
| Screenshot 2025-12-04 105932.png (258 KB) Screenshot 2025-12-04 105932.png | Tracy Tran, 12/04/2025 03:59 AM | ||
| picture422-1.png (285 KB) picture422-1.png | Tom Dong, 12/04/2025 06:32 AM | ||
| Screenshot 2025-12-04 143310.png (256 KB) Screenshot 2025-12-04 143310.png | Tracy Tran, 12/04/2025 07:34 AM | ||
| Screenshot 2025-12-04 143258.png (221 KB) Screenshot 2025-12-04 143258.png | Tracy Tran, 12/04/2025 07:34 AM |
Updated by Tracy Tran 3 months ago
Updated by Tom Dong 3 months ago
- Summary
Fixed the Seller Settlement export issue where the Excel export was displaying multiple channels even when the search was filtered to "Webbed DMC only" (STN02). The export function was not using the stored search condition from the component state. Updated `excelDownloadHandlerV2()` to use `this._searchCondition` (the last applied search condition) instead of reading from the form, ensuring the export respects all active filters including the channel filter (`stationTypeCode`).
- AI Summary Table
| Assignee | AI Use Case | How AI was Applied | Progress (h) | Reduced time (hour) | Challenge | Resolved_Challenges | Total Token Used |
| ---------- | ------------- | ------------------- | --------------- | --------------------- | ----------- | --------------------- | ------------------ |
| Auto | Analyze export condition bug and fix filter application | Used Cursor AI to analyze the codebase, identify the root cause in `excelDownloadHandlerV2()` method, and implement fix using stored search condition | Modified `sm-seller.component.ts` excelDownloadHandlerV2() function; Changed to use `_searchCondition` from component state; Ensured channel filter (stationTypeCode) is properly included in export | 2 | Export function was using form values instead of stored search condition, causing filters to be ignored | Updated method to use `this._searchCondition` which contains the last applied search filters from NgRx store, ensuring export matches displayed results | ~15,000 |
Technical Details:
- File modified: `src/app/routes/sm-seller/containers/sm-seller.component.ts`
- Function: `excelDownloadHandlerV2()`
- Change: Now uses `this._searchCondition` which is synchronized with the NgRx store's search condition, ensuring all filters (including stationTypeCode for channel filtering) are properly applied to the export.
Updated by Tracy Tran 3 months ago
- File Screenshot 2025-12-04 105932.png Screenshot 2025-12-04 105932.png added
- Status changed from QA test to 완료실패(Failed)
- Assignee changed from Tracy Truong to Tom Dong
Checked staging

Updated by Tom Dong 3 months ago
- File picture422-1.png picture422-1.png added
please check again on STAGINg
Updated by ziniy Kang 3 months ago
- Status changed from 완료(Done) to QA test
- Assignee changed from Tom Dong to Tracy Tran
Updated by Tracy Tran 3 months ago
- File Screenshot 2025-12-04 143310.png Screenshot 2025-12-04 143310.png added
- File Screenshot 2025-12-04 143258.png Screenshot 2025-12-04 143258.png added
- Status changed from QA test to 완료(Done)
- Assignee changed from Tracy Tran to Tom Dong
CHECKED STAGING

Updated by ziniy Kang 3 months ago
- Status changed from 완료(Done) to 확인(Confirmed)
Updated by ziniy Kang 3 months ago
- Status changed from 확인(Confirmed) to QA test
- Assignee changed from Tom Dong to Tracy Tran
- Build env. changed from Staging to Prod
Updated by Tracy Tran 3 months ago
- Status changed from QA test to 완료성공(Resolve)
- Assignee changed from Tracy Truong to Tom Dong
Checked