Bob Elliot & Co Ltd.
The following work has occured since the Bob Elliot Move
  1. Purchased and Configured the new Dell Server over 3 visits to Bobs old Premesis.
  2. Transfared their old server license and Sage Installation and set up the Domain including:
    1. User Accounts,
    2. Permissions,
    3. DNS,
    4. DHCP
    5. Active Directory
  3. Site visit to evaluate server location and other hardwqare considerations.
  4. Installed new Domain Server as new Premisis,
  5. Website Backup (20080927)
  6. Installed Network Including:
    1. Switch and BT DMZ installation,
    2. Iinstalltion of all Machines
    3. Additional visits for Patch Cable Replacement, User issues, permissions, Printer issues.
  7. +£500
  8. Site Visist to upgrade Sage on the Server
  9. Sage Upgrade and Conversion on all clients
    1. Re-Created Critical Sage Report
    2. Fixed minor Reports
    3. Fixed Warehouse Backing up process
  10. Another Site Visit for Installation of Vista PC for paul and all critical applications
  11. Re-Configured Pauls old machine and installed as Bobs New Machine
  12. Website Backup (20081006)
  13. Wrote Bespoke Logon Scripts to the domain to automatically map drives and printers for any logon
  14. Applied Latest Sage patches to all Clients
  15. Created new Domain Users and Documentation
  16. Re-installed Printer drivers and Re-Mapped to reflect the changes in Machines moving about
  17. Fixed Bobs emails with BT's help
  18. Created bob-elliot.co.uk email addresses for all users and added to every Machines email client.
  19. lots of other minor things like tweaking permissions, changing passwords, Fixing Audio on machines etc
  20. 4.2.10 & 4.2.09 - Upgraded the Bob Elliot Online database with 4rd Normal form Normalisation, replaced text based products table with Cateory tables and numerical foreign keys etc
  21. 4.3.13 & 4.3.12 - Upgrade Category system and menu to remove the need for 'View All' (required a major re-write of the menu logic)
  22. Website Backup (20081014)
  23. 4.3.11 - Added new Cateogry Management facilities to Disable and Enable Categoris
  24. 4.3.11 - Added new Feature to Bulk Move Products from on category to another
  25. 4.3.14 - Altered Category deletion to work of the new numerical ID's etc.
  26. Minor Advert work, including complete redraft in 300DPI CMYK, sourcing of hi-res logos etc
  27. Specced out and ordered 5 New workstations from Dell, built on vista buisness and 3GB ram (quad core)
  28. 4.3.15 - Re-Wrote Edit Product Page to reflect better Edit Category functions and handle Double Quotes in product names
  29. Website Backup (20081025)
  30. 4.3.16 - Paramaterised VAT rate
  31. 4.3.17 - Orders are now red or green depending on Print Status, Green = printed, Red = not printed
  32. 4.3.18 - The Latest 5 orders automatically refreshes every 5 seconds using AJAX (means only that part of the page re-loads so you wont get any flickering etc) basically you should never have to refresh that page again.
  33. Website Backup (20081106)
  34. 4.3.19 - When you click a ‘Show Order’ button the popup window now loads in AJAX (again, it only loads that part of the page) meaning the order is displayed a lot quicker and cleaner.
  35. 4.3.20 - The Full Order List at the bottom has also been colour coded
  36. 4.3.21 - The Full Order List has been tweaked to automatically display the order when you select it rather than having to click a button
  37. 4.3.22 - The Full Order List now has a Refresh Button (re-loads just that list, again reducing reload time etc)
  38. Website Backup (20081125)
  39. +£200
  40. Installation of the 5 new machines, including:
    1. Put the 5 machines on the domain
    2. Remove the old 5 machines from the domain
    3. Re-Install Sage on all 5 new machines and Test
    4. Re-Install Office 2003 on all machines
    5. ReSetup everyones email (in Outlook 2003) on all 5 machines and Test
    6. Re-apply Latest Sage Patches to all machiens
    7. Re-Install printer drivers on Server machines (bobs for brother, pauls for cannon etc), allowing the afore mentioned Auto Scripts to re-map drives and printers.
  41. Installed new Switch
  42. Website Backup (20081209)
  43. Recyled Old Computers, including:
    1. Formatted All machines and installed Windows XP Pro Dell Edition
    2. Used MS Product Key tool to change the Serial from Dell to the labels affixed to the PC's (ensure updates work correctly etc)
    3. Installed Service Pack 3 and Applied windows updates, (there may be a few outstanding on Johns, Conservatory and Daniels.
    4. Installed Office 2003 Pro on Johns and Pauls Freemans (and cracked)
    5. Identified Sound hardware and located driver, installed on all 4 machines (was a VIA embedded chipset driver)
  44. Updated price list to 2008V2
  45. Secured the protecteddownloads folder to block robot crawling
  46. Website Backup (20090103)
  47. Created a new Splash Screen for the Website to advertise the new Lazer Helmets
  48. Created new Artwork on home page for a Tyre (links to product etc)
  49. +£100
  50. Website Backup (20090208)
  51. +£100
  52. Website Backup (20090221)
  53. Designed several 25th year logos
  54. 4.3.23 - Re-Wrote and Cleaned code on Viewproducts.php (fixed a few Security vulnerabilities too) (reduced code from 1024 lines of code to 674!)
  55. 4.3.24 - Cleaned code on Clearance.php (fixed a few Security vulnerabilities too)
  56. 4.3.25 - Cleaned code on Reviews.php (fixed a few Security vulnerabilities too)
  57. 4.3.26 - Created Central functions for Headers and QuickBuy (Cleaner code basically, very boring, but needed as the site gets more & more complex)
  58. 4.3.27 - Moved functions from page header to config.php and removed duplicate calls to config.php (alot of pages where opening multiple connections to the database etc, i have but this in 1 central include now, so all pages only make 1 connection instead of 10+ (also, big security improvement)
  59. 4.3.28 - Updated CSS and stylesheets to improve table layout, This was seriously overdue lol, but you will notice a big change on pages that list products.
  60. 4.3.29 - Moved JavaScript into separate js file to increase security, page size and bandwidth, Created the following files: adminTools.js and generic.js
  61. 4.3.30 - Rewrote QuickBuy.php to use AJAX, removed the stupid pop-up, and also added auto-updating code, so the mini-basket auto updates without having to refresh the entire page
  62. 4.3.31 - Edited the Search page to use the new CSS and QuickBuy modules mentioned previously
  63. 4.3.32 - Fixed Dozens of minor errors, some of which caused by the new changes
  64. 4.3.33 - Re-Wrote activate.php to allow the deletion of account names with stupid characters in their names. Same fix also applied to the user management page in admin section.
  65. 4.3.34 - Updated EditProduct.php to not show 'Editing: >>107>>620>>test' but to show actual category names.
  66. 4.3.35 - Updated log system to use new table styling, and also got the log filtering working (FINALLY)
  67. 4.3.36 - Increased Security on login pages, and view products pages, added SQL injection prevention code and more advanced logging on the server.
  68. 4.3.37 - Updated Contact Us, Terms, About Us and all other customer-facing pages (and a few admin pages) to use the new central Header functions.
  69. 4.3.38 - Re-Wrote 'Suppliers.php' to use the global page header and footer (was currently using a duplicated version because of the supplier selection tool) this JavaScript has been segmented and functions correctly.
  70. 4.3.39 - Deleted QuickBuy.php as its no longer needed.
  71. 4.3.40 - Deleted phpinfo.php as its no longer needed
  72. 4.3.41 - Deleted all st* JavaScript files (from the very old menu system)
  73. 4.3.42 - Parameterised Product Detail in preparation for creating the stock control system (splitting product details into separate modules which will be vital for Stock Control in the future)
  74. 4.3.43 - Created AJAX_Basket.php which will become the new back-end for the basket, which will hold functions for the basket
  75. 4.3.44 - Added 'Clear Basket' function to the new AJAX basket file, allows the user to clear their basket without leaving the screen they are currently on.
  76. 4.3.45 - Improved user interface when using QuickBuy, when clicking 'Order' the button will now gray-out and change to 'Adding...' Then once the AJAX is complete, the Basket is re-drawn silently without prompting the user, the button then turns green and instead of 'Order' the button reads 'Item Added!'
  77. 4.3.46 - Overall Security haul, checked numeric post data was numeric, checked upload fields only upload images, made sure the image resizing functions only open image files (there is a lot of complicating vulnerabilities with resizing images that i wont bore you to death with)
  78. Site Visit to:
    1.  Confiure the BT Versatility Firewall to enable remote support and Stock Control Communication
    2. Installed a network printer
    3. Alter logon scripts to automatically map the printer
    4. Enabled RDP
    5. Installed IIS on server and configured ODBC to talk to sage
  79. Designed Stock Control System from the ground up and fully documented accordingly
  80. Installed Dell Server Administrator on the server and configured it to alert me if a hard drive fails etc
  81. A printer broke, dialled in and talked paul through assigning the new printer a static IP, then put it on the network, and altered the logon scripts to re-install the new printer.
  82. Fixed the HeavenCore WebRing links on the bob splash
  83. Designed New 2009 Catalogue Front Cover, completed revisions etc
  84. Created Cynergy logo with revisions etc
  85. +£400 (July 2009)
  86. Pending work
  87. WEBSITE: [minor] Replace Graph Software with something of better quality
  88. WEBSITE: Develop Stock Counting and Sage integration including server based application to retreive info from Sage and pass it to the website using xmlhttp
No Comments have been Posted.
Post Comment
Please Login to Post a Comment.
Ratings
Rating is available to Members only.
Please Login to vote.

No Ratings have been Posted.