Home | How it works | Projects archive | Contact Us
Air Compressor Bot
 
The Career Path of Freelance Programming Jobs 

   Updating A Website

Bidding Time:
18/12/2004 15:25 - 25/12/2004 15:25
Budget:
Maximum $350
Status:
Closed


Job Type:
PHP, Javascript
Description:



500 GB of Hosting for only $4.95/mo.

I need an experienced programmer to do some immediate upgrading to an existing
website. I have received permission from ScriptLance to post the URL with the
assurance that I am not trying to circumvent paying commission to ScriptLance.
(I WILL report programmers who violate these conditions.)
URL: www.myavon.ca
The following login will allow you to see everything but the administration
section:
email: test(at)myavon.ca
password: scriptlance

PROJECT OUTCOMES
==============
I need an experienced programmer to do some immediate upgrading to an existing
website.

PROJECT OVERVIEW
================
1. The checklist, at bottom, was not completed by the original programmer. It
needs to be implemented.
2. The website views well in 1024×768. I would like to make the text scale with
screen resolution (preferably in the CSS).
3. I would like the website to be compatible with multiple browsers: IE,
Netscape, Opera, FireFox, Safarri, etc.
4. The website is currently based on tables. I would like to convert this to DIV
regions to scale properly and keep the top and side panels fixed.
5. The database needs to be updated to track the orders of individual customers
and display that information to Representatives, as well as various other
summaries. Data to be retained for six months.
6. The database default text for emails, however, the current code does not use
that text (text is hard-coded). I would like that changed.
7. Implement a pop-up that, once per session (when they first visit to the main
website), acknowledges returning customers and automatically closes after 1
seconds: "(Name) Welcome back to (my website)".
8. I will be moving the website to a new host ASAP. I need the database to be
ported over without loss of information. The website can be down for a maximum
of 24 hours during this transfer.
9. The programmer assigns all copyrights to the webmaster.

*****************
UNCOMPLETED TASKS
*****************
eXCHANGE NEWSLETTER
===================
. Need the ability to send a biweekly eXchange Newsletter to all active
Representatives. This should be a stand-alone php script that is activated by
chron and with a 'Send Now' button on the Admin Email page. The text for the
email is in the online database. This script should not be executed for people
who request so on their settings page (that radio button needs to be put there).


GLOBAL EMAIL
============
. Need to be able to attach files to the global email.

BILLING ROUTINE
===============
. Billing is based on the calendar month.
. The routine must sum the order totals for each Representative during a given
month and then sends the appropriate email. At the end of the email, the orders
are summarized: Campaign, Order Date, Customer Name, Order Total.

ORDER SUMMARIES
===============
Multiple order summaries must be available to Representatives.
(1) single line summary of their orders for a selected campaign (Customer Name,
Order Date, Total)
(2) clicking on an order in (1), the complete order pops up.
(3) A view that lists all the products ordered by customers in a selected
campaign, sortable by product number or product name.
Reps can only view summaries of their information. the administrator can view
summaries for all representatives and can change the item quantities in (2).
Information in the database is retained for six months.

ADVANCEDADDITEM
===============
. When advancedadditem.php checks the number with the existing database and
finds it in the database, advancedadditem.php should add the database item to
the order. Currently, it enters a blank line.
. When advancedadditem.php checks the number with the existing database and
DOESN'T finds it in the database, advancedadditem.php should add the item to the
database and to the order.

COOKIES
=======
. Currently, much to my annoyance, the order is stored as a cookie. The order
needs to be stored in a mySQL database so that ORDER SUMMARIES can function
properly.
. The cookie should only have the customer name, customer email, their chosen
representative name.
. Implement the functionality that, if setting the cookie fails, a pop-up
advises customers that the website will still function but will not be able to
recall any stored information.

UPLOAD DATABASE
===============
. The upload database algorithm should strip the first 5 digits (year and dash:
2005-) from the first column.
. The upload database algorithm should condense the four tabs to a single tab.
. ADDITEM and ADVANCEDADDITEM need to prepend the brochure number with a zero if
it is a single digit. I.e., when a customer enters a '4', the routine should
convert that to '04'.

Thanks,
Roy Jensen

Start your work-at-home career for $7.00. Get direct access to thousands of freelance and home-based jobs. Click here to find work now.

Related Projects:
Build Site W/ Shopping Cart
Content Regeneration - DB Project
Link Building Campaign
Navigation Menus
Online Mall - More Projects!!

This project is the proprietary information of . Click here to remove this project from OUR database.
Operating System:
(I don't know)
Database System:
MySQL
<<< back

Recent Projects Archive:

Thursday - Wednesday - Tuesday - Monday - Sunday - Saturday - Friday

View all freelance web projects

 
Home | Projects archive | RSS | Resources | Links | Contact Us © 2004-2008 ProjectsList.biz /1.471