Accounting & Billing System for the WEB Centre

1. Accounting & Billing System for the WEB Centre Supervisor Tim Chown 2nd Supervisor Mike Poppleton Customer Simon Farrenden, ECS GDP 19 Donna Crawford (dc899) Chris O’Neill (ckjon101) Amit Shah (ams401) David Newman (drn101)

2. Progress Presentation II • Security and User Levels • Features Implemented • Evolution of the User Interface • Summary of progress • Remaining work • Questions?? GDP19: Progress Presentation II

3. Security • Cookie Based System • Store login information locally • MD5 Encrypted combination of user id and username • Handling Passwords • Obligatory HTML password fields • Confirmation of new password when changed • Password reminders sent require valid email address GDP19: Progress Presentation II

4. User Access Levels • Five user-access levels implemented • Clients… GDP19: Progress Presentation II

5. User Access Levels GDP19: Progress Presentation II

6. User Access Levels • Five user-access levels implemented • Clients • Financial Staff • Systems Staff • Administrators… GDP19: Progress Presentation II

7. User Access Levels GDP19: Progress Presentation II

8. User Access Levels • Five user-access levels implemented • Clients • Financial Staff • Systems Staff • Administrators • Super-Administrator • Web pages require access permissions • Only links to pages the user can view are displayed • URLs to restricted pages cannot be typed in manually GDP19: Progress Presentation II

9. User Access Levels GDP19: Progress Presentation II

10. Username, cannot be edited after submission Password fields, uses hidden fields One of company name or contact must be entered Account types: Commercial, ECS and Charity Additional Info on how to fill in form Client & Staff Pages (I) GDP19: Progress Presentation II

11. Choose more basic Search, i.e. one entry box searches 3 fields Choose search criteria Lists number and type of records found Records found, click on Username to view Client & Staff Pages (II) GDP19: Progress Presentation II

12. Client & Staff Pages (III) • Staff-Client Map • Maps staff to client they have worked for • Based on timesheets submitted by staff in last 12 months • Staff Log • Logs modifications to the database • By default only displays modifications in last 12 months • Time scale to be made customisable. • Links to view username details of editor and details of the recorded added/edited. GDP19: Progress Presentation II

13. Services Pages (I) • Add, Modify and View Services • Offered by WEBCentre • Added to by Super Administrator • Edited by Administrator • Viewable by all staff and clients • Purchased by a Client (A Client Service) • Added to and edited by Administrators • Viewable by all Staff and the purchasing Client • Navigated to via Client Accounts GDP19: Progress Presentation II

14. GDP19: Progress Presentation II

15. Timesheet Pages • Submit Timesheets • By Staff • Search, View and Amend Timesheets • Used in Invoice Generation • Used to Calculate Amount Staff are Owed. GDP19: Progress Presentation II

16. Timesheet Pages • Calendar Layout for Overview • View hours for a set day, week or month… GDP19: Progress Presentation II

17. Timesheet Pages GDP19: Progress Presentation II

18. Timesheet Pages • Calendar Layout for Overview • View hours for a set day, week or month • Submit Timesheets • Submitted by staff, for approval • Search Individual/All Timesheets • Used in Invoice Generation • Used to Calculate Staff Wages GDP19: Progress Presentation II

19. Invoicing Pages • Major customer requirements • Itemised billing of all service charges for a client • Covering letter • Algorithm • Features • Generation and Summary • Search • Payments • Accounts Department GDP19: Progress Presentation II

20. Invoicing Pages GDP19: Progress Presentation II

21. IP Allocation • Most customers are allocated a dedicated IP address • Some customers share an IP address using Virtual Hosting • Detailed information on IP address usage needs to be maintained • Existing IP usage tracking is important when requesting new addresses GDP19: Progress Presentation II

22. IP Allocation – Address Listing GDP19: Progress Presentation II

23. IP Allocation – Add Addresses GDP19: Progress Presentation II

24. IP Allocation – DNS Configuration • This system maintains a list of what IP addresses are allocated to which customers • Currently this information is stored in spreadsheets and the DNS server configuration files • Ensure the integrity of this data by having our database generate the DNS configuration files. GDP19: Progress Presentation II

25. IP Allocation – DNS Configuration GDP19: Progress Presentation II

26. IP Allocation – DNS Configuration GDP19: Progress Presentation II

27. Authoritative Nameservers • All registered domains have a pair of authoritative nameservers • These nameservers are the end of the DNS lookup ‘chain’ for that domain • The authoritative nameservers for domains hosted by the WEB Centre must be the WEB Centre nameservers GDP19: Progress Presentation II

28. Authoritative Nameservers GDP19: Progress Presentation II

29. Authoritative Nameservers GDP19: Progress Presentation II

30. Site Layout & User Interface I • Width 800px • Adaptable Style Sheet • Cross Browser (Windows) • Internal vs. right submenu • Page Layout Policy • Consistent • Uncluttered • Intuitive • Colour scheme – laptop friendly GDP19: Progress Presentation II

31. Site Layout & User Interface II GDP19: Progress Presentation II

32. Progress Summary • Gantt Chart (Start) • Gantt Chart (Progress Meeting One) • Gantt Chart (Now) GDP19: Progress Presentation II

33. Project Progress Plan GDP19: Progress Presentation II

34. Project Progress – To Week 4 GDP19: Progress Presentation II

35. Project Progress – To Week 8 GDP19: Progress Presentation II

36. Remaining Work • Polishing pages • Advanced Features • Authoritative Nameserver Checking • HONORS Integration • PDF Invoice Generation • Using FreePDF. • Testing • Final Report Write-up. GDP19: Progress Presentation II

37. Questions ?? GDP19: Progress Presentation II