Support #3570

Avatar?id=2607&size=50

[SCP ID : 875] M2U - Customer Transaction Enquiry

Added by Rayvandy Gabbytian about 11 years ago. Updated over 10 years ago.

Status:Closed - End of life cycleStart date:September 04, 2013
Priority:NormalDue date:September 04, 2013
Assignee:Avatar?id=2607&size=14Rayvandy Gabbytian % Done:

100%

Category:-Spent time:5.00 hours
Target version:-

Description

Reported by Thomas.

Please check for this production issue:

Thomas said:
Mohon bantuaanya untuk di check fungsi search pada customer transaction enquiry menggunakan transaction date dan effective date
karena data tidak muncul apabila menggunakan key date.

Attached is the screenshot.

Thanks.

image004.jpg (29.6 KB) Rayvandy Gabbytian , September 04, 2013 17:59

image005.jpg (25.5 KB) Rayvandy Gabbytian , September 04, 2013 17:59

History

#1 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian about 11 years ago

  • Status changed from New - Begin Life Cycle to Development / Work In Progress

#2 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian about 11 years ago

  • % Done changed from 0 to 100

Root Cause: The method "enquire user size" & "enquire user list" or similar function does not use proper search filter. example: To Date must be added with 1 more day to get expected day range, because the le (less equal function) does not really work in org.hibernate.criteria.

Resolution:

This piece of codes will explain:

if (createTo != null && !"".equals (createTo)) {
Calendar createToCalendar = Calendar.getInstance ();
Date createToDate;
try {
createToDate = new SimpleDateFormat("dd/MM/yyyy").parse (createTo);
createToCalendar.setTime (createToDate);
createToCalendar.add (Calendar.DAY_OF_MONTH, 1);
createToCalendar.set (Calendar.HOUR_OF_DAY, 0);
createToCalendar.set (Calendar.MINUTE, 0);
createToCalendar.set (Calendar.SECOND, 0);
createToCalendar.set (Calendar.MILLISECOND, 0);
criteria.add(Restrictions.le("regDate", createToCalendar.getTime()));
}
catch(ParseException e) {
e.getMessage ();
}
}

Thanks.

#3 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian about 11 years ago

  • Status changed from Development / Work In Progress to Finished Development

#4 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian about 11 years ago

  • Status changed from Finished Development to Internal Testing
  • % Done changed from 100 to 0

#5 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian about 11 years ago

  • % Done changed from 0 to 100

Done testing. Module affected: admin user profile, customer profile, & customer registration. Dependent on IbssCore.

#6 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian about 11 years ago

  • Status changed from Internal Testing to Closed - End of life cycle

#7 Avatar?id=1733&size=24 Updated by Ahmad Hazri over 10 years ago

  • Subject changed from M2U - Customer Transaction Enquiry (SCP ID : 875) to [SCP ID : 875] M2U - Customer Transaction Enquiry

Also available in: Atom PDF