Tuesday, June 2, 2015

Checking system

Today, we discuss DDL, storyboard and DFD. We need to modify certain part of our proposal because the changes of our database.


After that,  we check our web page, there have some error that we need to correct.
Today finished uploading the website onto a web hosting server, has to make a few modification to the software and the database because it turns out the the web hosting is case sensitive, and since previously i used dreamweaver which wasnt case sensitive, had to correct all the file name, page redirection and links.

Today i also successfully created the triggers which i previously had much problem with. The triggers can update the product every time an order is made. Also  added a last minute feature which is the insert delivery information for admin and users can now view the delivery information of their order after the admin has posted their orders.Today, i also started correction and modification on all the previous documentation to prepare for the final report submission during presentation.

Monday, June 1, 2015

Today, finished polishing the manage customer page for admin and repaired some errors with the customer.At the same time, i spotted an error in the generate sales order interface, that display the total amount that is expected to be paid to the admin wrongly, fixed it realizing that the value keeps increasing even after an order is paid.

 Other than that, also added in search product functionality for users with or without login.
Before this, i mentioned having a hard time with trigger because of not being able to create a trigger that  updates stock quantity when an order is confirmed.Today though, found a convincing lead on how to create the mentioned trigger, although i presume it involves some concept changes to the system, will work on it tomorrow.

Whereelse, in the morning, met with my fellow group members to show them to progress of the system and did a little demonstration of the nearly complete prototype.

Teh