Bug #5481

Task #5429: [TPMS_Internal Test] - Section 2: Promotions

Bug #5469: Promotion >> Reports

Promotion >> Reports >> Details by Foreign Buyers

Added by Siti Norahayu Mohd Desa about 9 years ago. Updated almost 9 years ago.

Status:Work Completed-End life cycleStart date:September 08, 2015
Priority:NormalDue date:September 09, 2015
Assignee:Siti Norahayu Mohd Desa % Done:

100%

Category:TPMS_TestSpent time:-
Target version:-

Description

b) DETAILS BY FOREIGN BUYERS

i) BY COMPANY NAME
- Unable to generate the report

ii) NO. OF BUYERS BY PRODUCT & SERVICES
  1. Bold the Number of Buyers by Product & Services title
  2. Remove the wording By Produce/Service
  3. Remove of wording Filter by <Product/Service>, <No of Foreign Buyers>
  4. Bold All the Header & Title
  5. Missing Product Code for product value
iii) NUMBER OF BUYERS BY COUNTRY & PARTICIPANT
  1. Bold All the Header & Title
  2. Order by Country, Ascending
  3. Continue numbering instead of reset it from no 1 again.
iV) NUMBER OF BUSINESS MEETING BY BUYERS & COUNTRY
  1. Country & Buyers Name display as "Null"
  2. Bold All the Header & Title
v) SUMMARY OF FOREIGN BUYERS BY TC
  1. Bold All the Header & Title
  2. 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
  1. 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.

Generate Report:
  1. REPRESENTATIVE column display available rep only no need display null if rep 2 is no value.
  2. Email value is overlapping Info date value. Add an extra space between email & Info Date.
  3. Bumiputra value display too bottom from the Bumiputra Label.
  4. Title report not as per requirement. Refer Promotion - Reports document for more information
  5. 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

  1. ORDER BY PRODUCT/SERVICES title change to center align
  2. Column for NO. OF FOREIGN BUYER display as NO. OF MALAYSIAN COMPANIES. Please change to NO. OF FOREIGN BUYER.
  3. For Service field must restart number from 1 instead of continue numbering from product.
  4. Display Date is based on Event Date.
iii) NUMBER OF BUYERS BY COUNTRY & PARTICIPANT
# Bold All the Header & Title - Passed
  1. Order by Country, Ascending (need data to test)
  2. Continue numbering instead of reset it from no 1 again.
iV) NUMBER OF BUSINESS MEETING BY BUYERS & COUNTRY
  1. Country & Buyers Name display as "Null"
    # Bold All the Header & Title - Passed
  2. Change title to the center align.
v) SUMMARY OF FOREIGN BUYERS BY TC
# Bold All the Header & Title - Passed
  1. 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:-
  1. Company Name (free text)
  2. Country (Drop down multiple)
  3. TC Office (Drop down multiple)
  4. Product & Service (free text)

P/s: These are the last changes, if after this will be required a CR

i) BY COMPANY NAME
  1. To add TC Office Column
  2. Value for product & Service should display product/service id & product/service level 2
  3. Value for Product/service Description need to display product/service desc
  4. 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.

Also available in: Atom PDF