red1.org

[red1]

Shahidi called to set Monday 2.30 pm for demo with Ibrahim.
He wants the Library System to be delivered too. He will call Intan in to verify. LAN visits them to see the Library System on 23rd.

Told him that is ok and done.

Now i m beefing up the DB part of Library.

We meet usual at Edi at 2pm.

[Gan MH]

Better to show on your notebook. Mine is messed up with all kinds of test data.

I need to have my library module running in order to continue with the UI work. Please advice on setting up the new library engine.

[red1]

ok but meet at Edi earlier then - be there about 12 noon. Then we can test all on my notebook. Instructions on Library i will leave in proper place at SF. This is for meetings and its preparations.

But u better just keep the old Library version in your notebook, as backup in case my new version isn't working fully. I m working on converting it at the moment.

[Gan MH]

Below are items being highlighted during presentation cum discussion session with En Ebrahim, Khairin and Zaimi dated 16-August-2006:

1. Table columns in Sponsor Invoice and Sponsor Payment should follow sequence below: - DONE, need red1 to add program_abbrev
No. | Intake/Matric | Name | Program Abbrev | Period | Inv No. | Amount

vtl/sis/bursary/sponsor_invoice_list.vm
mecca.sis.bursary.SponsorInvoiceModule

vtl/sis/bursary/sponsor_invoice_list_paying.vm
mecca.sis.bursary.SponsorInvoiceModule


2. Change module title in vtl/sis/bursary/sponsor_invoice_list_paying.vm to “Invoice to Sponsor (Payment)” – DONE


3. New business rules and processes applied to Sponsor Module:

a- no sponsor re-invoice for existing invoice(s) with active receipt
b- Sponsor Payment window must be revisitable. This happened when sponsor decides to pay some students and not all in the claimed session. Students already been paid must not appear in the payment list when user revisit the Sponsor Payment window. DONE - red1
c- Suggested solutions for point (b) can be: a check box beside the approved amount. It is advisable to nullify the approved amount box to avoid potential abuse. When payment received from sponsor, user will go through the payment list, check and key in amount for students in the paying batch. DONE - red1. Need to first add new field "paid" in sponsor_invoice_student table

vtl/sis/bursary/sponsor_invoice_list.vm
mecca.sis.bursary.SponsorInvoiceModule

vtl/sis/bursary/sponsor_invoice_list_paying.vm
mecca.sis.bursary.SponsorInvoiceModule


4. New business rule applied to Payment and Report Module:

a- Cancelled receipt must be showed up in Report Module (receipt amount) with note

vtl/sis/view/payment/showReceipts.vm
mecca.sis.payment.action.PaymentMainModule

vtl/sis/billing/report_receipt.vm
mecca.sis.billing.ReportModule


5. New business rule applied to Student Status Module

a- there are 2 different types of deferments: normal deferment and late deferment. Normal deferment is when a student deferred without being invoiced for that semester, while late deferment student will be invoiced for that semester.

vtl/sis/register/student_status.vm
mecca.sis.registration.StudentStatusModule


6. Debit Note Receipt – I am not very sure about this, red1 shall explain further.


7. Change Balance B/F to Opening Balance – DONE on live db


8. Receipt and Invoice number shall start at 5 digits, and with alphabet RC and IC respectively. – DONE. We shall reset the invoice and receipt auto number if requested by Khairin.


9. Create login for user at Bursary Counter with Payment window, Statement window, and Pre-Registration Window. For Payment window, need to disabled receipt cancellation. - DONE, except creating new VMs set without the cancel button.

[Gan MH]

Hi Khairin,

Pls download the zipped file at: http://red1.org/barn/Cybernetics/db_to_restore.rar

There are two (2) files inside:-
1. CICT_newdb.sql - copy to mysql bin folder, access mysql bin folder in cmd, restore db as usual: mysql cybernetics < CICT_newdb.sql;
2. login.vm - copy and overwrite file in C:\mecca_tomcat\webapps\cybernetics\vtl directory

What I have done:
1. Setup login for Shahidi:- U/N: shahidi P/W: shahidi
2. Setup login for Staff at Bursary Counter:- U/N: user01 P/W: user01
3. Configure minor changes to yours, En Ebrahim's and Zaimi's login
4. Clean up system main screen to only showing Login module and System Announcement Module
5. Setup Announcement Manager for you and shahidi, in order to post announcement which appear in the main screen

[Gan MH]

Khairin,

Pls download the latest library package at: http://red1.org/barn/Cybernetics/library190106.rar

This is consider the complete version 1. Only few minor bugs to fix.

2 steps to get you there:
1. Goto D:\mecca_tomcat\webapps and delete entirely the existing library folder
2. Copy the new library package and paste it there. Make sure same folder name and structure

[Gan MH]

Below are items highlighted during last trip to Cybernetics on 25-August-2006:

1. For all bursary report, we need to show information as in sequence below:
Matric No. | Date | Invoice/Receipt No. | Name | Program Abbreviation | Current Semester | Amount

2. For all bursary report, the system must allow user to export report into MS Excel Spreadsheet format.

3. In Sponsor Payment module, the approved amount displayed has to follow the sponsor invoiced amount and not the student invoiced amount. – DONE. Red1 also added a direct PDF print button in sponsor payment window.

4. The bursary report module has to be a combo of both student and sponsor transaction records. Eg: when user select Receipt Report for PTPTN , system must show transaction history with sponsor and not student, how much money received from sponsor, etc.

5. Nullify all bursary data. Resetting Invoice number and receipt number. – DONE. Further testing will tell whether there is any impact to system and database.

6. For the payment process, remove the unnecessary Print Preview step. If possible, receipt should direct print to printer.

7. Implement IP captured to keep track of any user that login to the system.

8. There must be different level of transparency for Bursary Report Module. Limit other user, apart from En Ebrahim to 30-days maximum, access to all bursary reports.

[Gan MH]

Khairin,

I have created the student screen and seperate it from the administrator screen in the latest library package. Pls download it at: http://red1.org/barn/Cybernetics/library090206.zip

1. Delete the entire existing library folder in D:\mecca_tomcat\webapps
2. Copy the new library package and paste it there. Make sure same folder name and structure

Student shall access the library system tru http://localhost/library
Administrator/librarian shall access the library system tru http://localhost:8085/library/admin.htm
We shall later implement the security login check to protect non-authorised user from accessing the administrative page.