Task #989
IB Reports - Clean Up
| Status: | Dropped-End of life cycle | Start date: | June 20, 2011 | |
|---|---|---|---|---|
| Priority: | High | Due date: | August 12, 2011 | |
| Assignee: |  Tan Lee Yong | % Done: | 100% | |
| Category: | - | Estimated time: | 25.00 hours | |
| Target version: | - | Spent time: | 53.00 hours |
Description
Clean up reports being converted from JDBC to Hibernate HQL.
Requires proper formatting of report fields.
Contact me when you are to start this task.
History
#1
Updated by Wijayanti Nitya over 13 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- % Done changed from 0 to 10
- Estimated time set to 25.00
- brief study on how the report in IBUtils works and being generated
- updated to latest ibss jar, correcting data type, generator class in ib rpt list
- fix Internet Transaction Report, add and remove the columns based on the current requirements
- fix formatting
#2
Updated by Wijayanti Nitya over 13 years ago
- % Done changed from 10 to 50
TODO: fix and cleanup reports below:
1. Internet Transaction Report
2. IB Registration Report
3. Own Account Funds Transfer Report
4. Intrabank Funds Transfer Report
5. Interbank Funds Transfer Report
6. User Activities Report
7. Bill Payment Report
8. TAC Issuance Report
9. Consolidated Transaction IB
10. Block ATM Report
11. ITEPS Report (For BNM)
12. SMS Issuance Report
13. Consolidated Monthly Transactional Report
14. All User Report
15. Inactivated User Report
so far already fix and check for report number 1 - 12.
Almost all the reports currently don't have any sample data. Only Internet Transaction Report, User Activities Report,
All User Report, and Inactivated User Report that have sample data.
For the rest of the reports, for now only can check for the formatting, and check for column and input that need to be included or removed, since the sample data is empty.
#3
Updated by Wijayanti Nitya over 13 years ago
- % Done changed from 50 to 70
- done with All User Report
- still fixing Inactivated User Report
- continue to do proper formatting and convert some query methods to hibernate style in the base class
#4
Updated by Wijayanti Nitya about 13 years ago
- % Done changed from 70 to 80
- fix Inactivated User Report
- fix consolidated transaction IB report
- done checking all reports and convert the query method to hibernate criteria
- need to be reviewed again as the ibss core is still amending from time to time so might conflict with some of the data types, and need to test again with real sample data.
#5
Updated by Wijayanti Nitya about 13 years ago
- point to sql server, edit the configuration and add required jar (successful)
- need to recheck again for every reports upon migration to sql server
#6
Updated by Wijayanti Nitya about 13 years ago
- remove sequence for method getReportID, edit the method
- recheck and fix again for:
Internet Transaction Report
Own Account Funds Transfer Report
Intrabank Funds Transfer Report
#7
Updated by Tan Lee Yong about 13 years ago
- Due date changed from June 22, 2011 to August 12, 2011
- Priority changed from Normal to High
All reports has this problem with MS SQL. Please fix it.
org.hibernate.QueryException: could not resolve property: TRNX_DATE of: net.penril.ibss.core.hibernate.IbRegistration
org.hibernate.QueryException: could not resolve property: TRNX_DATE of: net.penril.ibss.core.hibernate.IbRegistration
#8
Updated by Wijayanti Nitya about 13 years ago
- update ibss jar and re-check reports.
- found out that currently sql defaulted to "NULL" for every empty records, so there's lot of parse exception when enquire (esp null value) records from db. Need to do proper checking for null condition.
- org.hibernate.QueryException: could not resolve property: TRNX_DATE of: et.penril.ibss.core.hibernate.IbRegistration
this exception occurs due to wrong return value given when calling getTransactionDate() that overridden from base class.
- testing using arguments "3" (for daily report)
fix reports for:
1. Internet Transaction Report
2. IB Registration Report
3. Own Account Funds Transfer Report
4. Intrabank Funds Transfer Report
5. Interbank Funds Transfer Report
6. Bill Payment Report
I will continue and try to finish the rest this weekends
#9
Updated by Wijayanti Nitya about 13 years ago
continue recheck and fix reports for:
1. User Activities Report
2. TAC Issuance Report
3. Block ATM Report
4. All User Report
5. Inactivated User Report
Some problems with ms-sql is due to null value in the data, or incorrect hibernate properties being called.
#10
Updated by Wijayanti Nitya about 13 years ago
continue recheck and fix reports for:
1. ITEPS Report
2. Consolidated Report
3. Monthly Consolidated Report
#11
Updated by Norhaidah Md Dasuki about 13 years ago
- Assignee changed from Wijayanti Nitya to Cheang Danniell
#12
Updated by Tan Lee Yong almost 13 years ago
- Status changed from Development / Work In Progress to Pending Review
#13
Updated by Tan Lee Yong almost 13 years ago
- Status changed from Pending Review to Dropped-End of life cycle
- Assignee changed from Cheang Danniell to Tan Lee Yong
- % Done changed from 80 to 100
Changed to use Jasper Report