Bob Elliot & Co Ltd.
The following work has occured since the Bob Elliot Move
- Purchased and Configured the new Dell Server over 3 visits to Bobs old Premesis.
- Transfared their old server license and Sage Installation and set up the Domain
including:
- User Accounts,
- Permissions,
- DNS,
- DHCP
- Active Directory
- Site visit to evaluate server location and other hardwqare considerations.
- Installed new Domain Server as new Premisis,
- Website Backup (20080927)
- Installed Network Including:
- Switch and BT DMZ installation,
- Iinstalltion of all Machines
- Additional visits for Patch Cable Replacement, User issues, permissions, Printer issues.
- +£500
- Site Visist to upgrade Sage on the Server
- Sage Upgrade and Conversion on all clients
- Re-Created Critical Sage Report
- Fixed minor Reports
- Fixed Warehouse Backing up process
- Another Site Visit for Installation of Vista PC for paul and all critical applications
- Re-Configured Pauls old machine and installed as Bobs New Machine
- Website Backup (20081006)
- Wrote Bespoke Logon Scripts to the domain to automatically map drives and printers for any logon
- Applied Latest Sage patches to all Clients
- Created new Domain Users and Documentation
- Re-installed Printer drivers and Re-Mapped to reflect the changes in Machines moving about
- Fixed Bobs emails with BT's help
- Created bob-elliot.co.uk email addresses for all users and added to every Machines email client.
- lots of other minor things like tweaking permissions, changing passwords, Fixing Audio on machines etc
- 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
- 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)
- Website Backup (20081014)
- 4.3.11 - Added new Cateogry Management facilities to Disable and Enable Categoris
- 4.3.11 - Added new Feature to Bulk Move Products from on category to another
- 4.3.14 - Altered Category deletion to work of the new numerical ID's etc.
- Minor Advert work, including complete redraft in 300DPI CMYK, sourcing of hi-res logos etc
- Specced out and ordered 5 New workstations from Dell, built on vista buisness and 3GB ram (quad core)
- 4.3.15 - Re-Wrote Edit Product Page to reflect better Edit Category functions and handle Double Quotes in product names
- Website Backup (20081025)
- 4.3.16 - Paramaterised VAT rate
- 4.3.17 - Orders are now red or green depending on Print Status, Green = printed, Red = not printed
- 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.
- Website Backup (20081106)
- 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.
- 4.3.20 - The Full Order List at the bottom has also been colour coded
- 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
- 4.3.22 - The Full Order List now has a Refresh Button (re-loads just that list, again reducing reload time etc)
- Website Backup (20081125)
- +£200
- Installation of the 5 new machines, including:
- Put the 5 machines on the domain
- Remove the old 5 machines from the domain
- Re-Install Sage on all 5 new machines and Test
- Re-Install Office 2003 on all machines
- ReSetup everyones email (in Outlook 2003) on all 5 machines and Test
- Re-apply Latest Sage Patches to all machiens
- 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.
- Installed new Switch
- Website Backup (20081209)
- Recyled Old Computers, including:
- Formatted All machines and installed Windows XP Pro Dell Edition
- Used MS Product Key tool to change the Serial from Dell to the labels affixed to the PC's (ensure updates work correctly etc)
- Installed Service Pack 3 and Applied windows updates, (there may be a few outstanding on Johns, Conservatory and Daniels.
- Installed Office 2003 Pro on Johns and Pauls Freemans (and cracked)
- Identified Sound hardware and located driver, installed on all 4 machines (was a VIA embedded chipset driver)
- Updated price list to 2008V2
- Secured the protecteddownloads folder to block robot crawling
- Website Backup (20090103)
- Created a new Splash Screen for the Website to advertise the new Lazer Helmets
- Created new Artwork on home page for a Tyre (links to product etc)
- +£100
- Website Backup (20090208)
- +£100
- Website Backup (20090221)
- Designed several 25th year logos
- 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!)
- 4.3.24 - Cleaned code on Clearance.php (fixed a few Security vulnerabilities too)
- 4.3.25 - Cleaned code on Reviews.php (fixed a few Security vulnerabilities too)
- 4.3.26 - Created Central functions for Headers and QuickBuy (Cleaner code basically, very boring, but needed as the site gets more & more complex)
- 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)
- 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.
- 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
- 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
- 4.3.31 - Edited the Search page to use the new CSS and QuickBuy modules mentioned previously
- 4.3.32 - Fixed Dozens of minor errors, some of which caused by the new changes
- 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.
- 4.3.34 - Updated EditProduct.php to not show 'Editing: >>107>>620>>test' but to show actual category names.
- 4.3.35 - Updated log system to use new table styling, and also got the log filtering working (FINALLY)
- 4.3.36 - Increased Security on login pages, and view products pages, added SQL injection prevention code and more advanced logging on the server.
- 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.
- 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.
- 4.3.39 - Deleted QuickBuy.php as its no longer needed.
- 4.3.40 - Deleted phpinfo.php as its no longer needed
- 4.3.41 - Deleted all st* JavaScript files (from the very old menu system)
- 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)
- 4.3.43 - Created AJAX_Basket.php which will become the new back-end for the basket, which will hold functions for the basket
- 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.
- 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!'
- 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)
- Site Visit to:
- Confiure the BT Versatility Firewall to enable remote support and Stock Control Communication
- Installed a network printer
- Alter logon scripts to automatically map the printer
- Enabled RDP
- Installed IIS on server and configured ODBC to talk to sage
- Designed Stock Control System from the ground up and fully documented accordingly
- Installed Dell Server Administrator on the server and configured it to alert me if a hard drive fails etc
- 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.
- Fixed the HeavenCore WebRing links on the bob splash
- Designed New 2009 Catalogue Front Cover, completed revisions etc
- Created Cynergy logo with revisions etc
- +£400 (July 2009)
- Pending work
- WEBSITE: [minor] Replace Graph Software with something of better quality
- WEBSITE: Develop Stock Counting and Sage integration including server based application to retreive info from Sage and pass it to the website using xmlhttp
Post Comment
Please Login to Post a Comment.
Ratings