Bug #5481
Task #5429: [TPMS_Internal Test] - Section 2: Promotions
Bug #5469: Promotion >> Reports
Promotion >> Reports >> Details by Foreign Buyers
Status: | Work Completed-End life cycle | Start date: | September 08, 2015 | |
---|---|---|---|---|
Priority: | Normal | Due date: | September 09, 2015 | |
Assignee: | Siti Norahayu Mohd Desa | % Done: | 100% | |
Category: | TPMS_Test | Spent time: | - | |
Target version: | - |
Description
b) DETAILS BY FOREIGN BUYERS
i) BY COMPANY NAME
- Unable to generate the report
- Bold the Number of Buyers by Product & Services title
- Remove the wording By Produce/Service
- Remove of wording Filter by <Product/Service>, <No of Foreign Buyers>
- Bold All the Header & Title
- Missing Product Code for product value
- Bold All the Header & Title
- Order by Country, Ascending
- Continue numbering instead of reset it from no 1 again.
- Country & Buyers Name display as "Null"
- Bold All the Header & Title
- Bold All the Header & Title
- Title as of display "Null" (SUMMARY OF FOREIGN BUYER BY TC AS OF null)
History
#1 Updated by Tan Jeng Wei about 9 years ago
- Assignee changed from Tan Jeng Wei to Ngoh Chee Ping
- Not able to fix
DETAILS BY FOREIGN BUYERS
i) BY COMPANY NAME
- Unable to generate the report....
(not able to generate pdf and doc, but able to generate the excel)
#2 Updated by Ngoh Chee Ping about 9 years ago
- Assignee changed from Ngoh Chee Ping to Tan Jeng Wei
problem on report template missing whenNoDataType="AllSectionsNoDetail"
#3 Updated by Tan Jeng Wei about 9 years ago
- Assignee changed from Tan Jeng Wei to Lim Leonard
fixed
#4 Updated by Lim Leonard about 9 years ago
- Assignee changed from Lim Leonard to Tan Jeng Wei
#5 Updated by Tan Jeng Wei about 9 years ago
- Assignee changed from Tan Jeng Wei to Siti Norahayu Mohd Desa
fixed
#6 Updated by Siti Norahayu Mohd Desa about 9 years ago
- Assignee changed from Siti Norahayu Mohd Desa to Tan Jeng Wei
- % Done changed from 0 to 50
15/9/2015 [Ayu]
b) DETAILS BY FOREIGN BUYERS
i) BY COMPANY NAME
At Screen Parameter Report:-
- Remove Company name field
- Remove TC Office field
- Remove Country field
- Remove Info Date field
- Remove Product / Service field
- Add Date by Yearly , Monthly range & Date range
- Add Program Type on top of Event Name & set is as mandatory
- Event Name must tie with the Program Type.
- REPRESENTATIVE column display available rep only no need display null if rep 2 is no value.
- Email value is overlapping Info date value. Add an extra space between email & Info Date.
- Bumiputra value display too bottom from the Bumiputra Label.
- Title report not as per requirement. Refer Promotion - Reports document for more information
- Company 1 & 2 should combine. No need to separate.
ii) NO. OF BUYERS BY PRODUCT & SERVICES# Bold the Number of Buyers by Product & Services title - Passed# Remove the wording By Produce/Service - Passed# Remove of wording Filter by <Product/Service>, <No of Foreign Buyers> - Passed# Bold All the Header & Title - Passed# Missing Product Code for product value - Passed
- ORDER BY PRODUCT/SERVICES title change to center align
- Column for NO. OF FOREIGN BUYER display as NO. OF MALAYSIAN COMPANIES. Please change to NO. OF FOREIGN BUYER.
- For Service field must restart number from 1 instead of continue numbering from product.
- Display Date is based on Event Date.
- Order by Country, Ascending (need data to test)
- Continue numbering instead of reset it from no 1 again.
- Country & Buyers Name display as "Null"
# Bold All the Header & Title - Passed - Change title to the center align.
- Title as of display "Null" (SUMMARY OF FOREIGN BUYER BY TC AS OF null) - Please display correct start date instead of null
#7 Updated by Norhaidah Md Dasuki almost 9 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
#8 Updated by Tan Jeng Wei almost 9 years ago
- Assignee changed from Tan Jeng Wei to Siti Norahayu Mohd Desa
b) DETAILS BY FOREIGN BUYERS
i) BY COMPANY NAME
At Screen Parameter Report:-
- Add Date by Yearly , Monthly range & Date range
- Add Program Type on top of Event Name & set is as mandatory
- Event Name must tie with the Program Type.
Generate Report:
REPRESENTATIVE column display available rep only no need display null if rep 2 is no value.
Email value is overlapping Info date value. Add an extra space between email & Info Date.
Bumiputra value display too bottom from the Bumiputra Label.
Title report not as per requirement. Refer Promotion - Reports document for more information
Company 1 & 2 should combine. No need to separate.
ii) NO. OF BUYERS BY PRODUCT & SERVICES
ORDER BY PRODUCT/SERVICES title change to center align
Column for NO. OF FOREIGN BUYER display as NO. OF MALAYSIAN COMPANIES. Please change to NO. OF FOREIGN BUYER.
For Service field must restart number from 1 instead of continue numbering from product.
Display Date is based on Event Date.
iii) NUMBER OF BUYERS BY COUNTRY & PARTICIPANT
Order by Country, Ascending (need data to test)
Continue numbering instead of reset it from no 1 again.
iV) NUMBER OF BUSINESS MEETING BY BUYERS & COUNTRY
Country & Buyers Name display as "Null"
Change title to the center align.
v) SUMMARY OF FOREIGN BUYERS BY TC
Title as of display "Null" (SUMMARY OF FOREIGN BUYER BY TC AS OF null) - Please display correct start date instead of null
statement above was fixed...
- Company name field
- TC Office field
- Country field
- Info Date field
- Product / Service field
field above still remain what as discuss with user before, please double confirm with user again if really want remove it.
#9 Updated by Siti Norahayu Mohd Desa almost 9 years ago
b) DETAILS BY FOREIGN BUYERS
i) BY COMPANY NAME
At Screen Parameter Report:-
- Add Date by Yearly , Monthly range & Date range
- Add Program Type on top of Event Name & set is as mandatory
- Event Name must tie with the Program Type.
Generate Report:
ii) NO. OF BUYERS BY PRODUCT & SERVICES
ORDER BY PRODUCT/SERVICES title change to center align
Column for NO. OF FOREIGN BUYER display as NO. OF MALAYSIAN COMPANIES. Please change to NO. OF FOREIGN BUYER.
For Service field must restart number from 1 instead of continue numbering from product.
Display Date is based on Event Date.
iii) NUMBER OF BUYERS BY COUNTRY & PARTICIPANT
Order by Country, Ascending (-data to test)
Continue numbering instead of reset it from no 1 again.
iV) NUMBER OF BUSINESS MEETING BY BUYERS & COUNTRY
Country & Buyers Name display as "Null"
Change title to the center align.
v) SUMMARY OF FOREIGN BUYERS BY TC
Title as of display "Null" (SUMMARY OF FOREIGN BUYER BY TC AS OF null) - Please display correct start date instead of null
statement above was fixed...
- Company name field
- TC Office field
- Country field
- Info Date field
- Product / Service field
field above still remain what as discuss with user before, please double confirm with user again if really want remove it.
#10 Updated by Siti Norahayu Mohd Desa almost 9 years ago
issue with strike was tested. the rest, report need a day after BM created to excute
#11 Updated by Siti Norahayu Mohd Desa almost 9 years ago
- Assignee changed from Siti Norahayu Mohd Desa to Tan Jeng Wei
b) DETAILS BY FOREIGN BUYERS
At Choose Report Criteria Screen:-To add search filter for:-
- Company Name (free text)
- Country (Drop down multiple)
- TC Office (Drop down multiple)
- Product & Service (free text)
P/s: These are the last changes, if after this will be required a CR
i) BY COMPANY NAME- To add TC Office Column
- Value for product & Service should display product/service id & product/service level 2
- Value for Product/service Description need to display product/service desc
- Interpreter display Null value
iii) NUMBER OF BUYERS BY COUNTRY & PARTICIPANT
No data display
iV) NUMBER OF BUSINESS MEETING BY BUYERS & COUNTRY
No data display
v) SUMMARY OF FOREIGN BUYERS BY TC
No data display
#12 Updated by Tan Jeng Wei almost 9 years ago
- Assignee changed from Tan Jeng Wei to Siti Norahayu Mohd Desa
Hi ayu...
i) BY COMPANY NAME
Value for product & Service should display product/service id & product/service level 2
Value for Product/service Description need to display product/service desc
Interpreter display Null value
iii) NUMBER OF BUYERS BY COUNTRY & PARTICIPANT
iV) NUMBER OF BUSINESS MEETING BY BUYERS & COUNTRY
v) SUMMARY OF FOREIGN BUYERS BY TC
fix, please test after deployed.....
#13 Updated by Siti Norahayu Mohd Desa almost 9 years ago
i) BY COMPANY NAME
Value for product & Service should display product/service id & product/service level 2
Value for Product/service Description need to display product/service desc
Interpreter display Null value
iii) NUMBER OF BUYERS BY COUNTRY & PARTICIPANT
iV) NUMBER OF BUSINESS MEETING BY BUYERS & COUNTRY
v) SUMMARY OF FOREIGN BUYERS BY TC
Hi jeng Wei,
The strike issue has tested & passed.
kindly fix the rest. TQ
#14 Updated by Siti Norahayu Mohd Desa almost 9 years ago
- Assignee changed from Siti Norahayu Mohd Desa to Tan Jeng Wei
- % Done changed from 50 to 80
#15 Updated by Tan Jeng Wei almost 9 years ago
- Assignee changed from Tan Jeng Wei to Siti Norahayu Mohd Desa
Hi ayu ,
Interpreter display Null value was change to - .
SUMMARY OF FOREIGN BUYERS BY TC was fixed.
kindly please help check for data.
Thanks
#16 Updated by Siti Norahayu Mohd Desa almost 9 years ago
- Assignee changed from Siti Norahayu Mohd Desa to Tan Jeng Wei
Interpreter display Null value was change to - .
SUMMARY OF FOREIGN BUYERS BY TC was fixed.
SUMMARY OF FOREIGN BUYERS BY TC
NO OF BUYERS display inaccurate amount.
Please remember the calculations is per event.
kindly assist to fix.
TQ
#17 Updated by Tan Jeng Wei almost 9 years ago
- Assignee changed from Tan Jeng Wei to Siti Norahayu Mohd Desa
hi ayu ,
NO OF BUYERS display already fixed, please check again
#18 Updated by Siti Norahayu Mohd Desa almost 9 years ago
- Assignee changed from Siti Norahayu Mohd Desa to Tan Jeng Wei
data redundant. please fix.
#19 Updated by Tan Jeng Wei almost 9 years ago
- Assignee changed from Tan Jeng Wei to Najmi Pasarudin
Hi najimi,
SUMMARY OF FOREIGN BUYERS BY
suspect TC query wrong d.
TC - duplicated.
#20 Updated by Najmi Pasarudin almost 9 years ago
- Assignee changed from Najmi Pasarudin to Siti Norahayu Mohd Desa
- % Done changed from 80 to 100
Update:
1. remove duplicate data
2. show only approve foreign buyers
#21 Updated by Siti Norahayu Mohd Desa almost 9 years ago
- Assignee changed from Siti Norahayu Mohd Desa to Najmi Pasarudin
- % Done changed from 100 to 90
Hi Najmi,
Same TC but different country value not display.
#22 Updated by Najmi Pasarudin almost 9 years ago
- Assignee changed from Najmi Pasarudin to Tan Jeng Wei
- % Done changed from 90 to 80
Fixed data issue for this report.
Jeng Wei, please update the java bean and report template accordingly.
#23 Updated by Tan Jeng Wei almost 9 years ago
- Assignee changed from Tan Jeng Wei to Najmi Pasarudin
Hi najimi ,
SumUp total recap is not correct, kindly please assist on this , suspect query problems.
thanks
#24 Updated by Najmi Pasarudin almost 9 years ago
- Assignee changed from Najmi Pasarudin to Tan Jeng Wei
Fixed SumUp total recap. Please test with different data to see if it is in synch with promotion foreign buyers list.
#25 Updated by Tan Jeng Wei almost 9 years ago
- Assignee changed from Tan Jeng Wei to Siti Norahayu Mohd Desa
Hi ayu
please test after deployed..
#26 Updated by Siti Norahayu Mohd Desa almost 9 years ago
- Assignee changed from Siti Norahayu Mohd Desa to Tan Jeng Wei
Hi jeng Wei,
Generated report is NOT tally with the data.
There were 3 companies with APPROVE status but generated report display 4 data.
Kindly assist to fix. TQ
#27 Updated by Tan Jeng Wei almost 9 years ago
- Assignee changed from Tan Jeng Wei to Siti Norahayu Mohd Desa
- % Done changed from 80 to 100
hi ayu ,
this one already fix by najimi......
thanks you.
#28 Updated by Siti Norahayu Mohd Desa almost 9 years ago
- Status changed from Development / Work In Progress to Work Completed-End life cycle
18/11/15 [Ayu]
tested & passed. issue closed.