mattspayde
12 Sep 2006, 04:14 PM
Okay everyone, I work for a company as a computer programmer and unfortunately my web design talents have been limited to cheesy sites that I have made over the course of my life, but never anything too fancy.
I am really hoping that you guys can help point me in the right direction on this.
My company consists of various clients throughout the country and a sales team that brings in these clients. We have become frustrated with the sales people constantly asking our IT department how much sales they had on one particular day and we would like to go about designing a website that is an easy interface for these sales people to use that can get them the questions they are asking answered.
Our system does not have any easy way of linking up to it live thru SQL or anything so the information for these sales people will be created one time per day and uploaded to a website for their discretional review.
Basically it needs to be as simple as this...
Some one goes to the website, answers a couple questions in forms, and based off of those questions a website needs to be returned that displays the results.
So a person needs to be able to go in and Select the Company they wish to see sales data for
The data of the transactions they would like to review, whether it be a single date or a date range
And then based off of that information it would return the numbers.
We have the versatility with our files that we can upload to the website to put them in about any format imaginable, right now the data is comma delimited and looks as follows...
"Company 1","09","11","2006","0","0.00","2265.70","112.88"
"Company 1","09","12","2006","0","0.00","20.53","10.27"
"Company 1","09","01","2006","0","0.00","1129.31","564.67"
"Company 2","09","04","2006","0","0.00","253.37","126.69"
"Company 2","09","05","2006","0","0.00","248.73","9.40"
"Company 3","09","06","2006","0","0.00","128.59","64.31"
"Company 3","09","07","2006","0","0.00","135.46","57.74"
"Company 3","09","08","2006","0","0.00","240.83","45.45"
"Company 3","09","11","2006","0","0.00","306.50","03.29"
"Company 3","09","12","2006","0","0.00","184.13","62.08"
"Company 3","09","01","2006","0","0.00","74.44","34.73"
"Company 3","09","05","2006","0","0.00","173.99","87.02"
"Company 3","09","06","2006","0","0.00","79.44","39.73"
"Company 3","09","07","2006","0","0.00","31.10","15.55"
"Company 3","09","08","2006","0","0.00","273.56","3.29"
The layout for the above information is as follows...
"Name of Client"
"Month"
"Day"
"Year"
"New Referral #"
"New Referral $"
"Sales $"
"Commission $"
So ideally, if a person went in and selected to see results for "Company 3" for the date of 09/12/2006, it would then return sales figures of 184.13 and a commission of 62.08.
Also, if there is more than one entry for the same date, the information needs to be grouped together and summed.
So...
"Company 3","09","12","2006","0","0.00","184.13","62.08"
"Company 3","09","12","2006","0","0.00","184.13","62.08"
"Company 3","09","12","2006","0","0.00","184.13","62.08"
If our database showed the above information, it would return sales figures of 552.39 and commission of 186.24.
Ideally the website needs to be easy to use and I would like to set it up so more than one company can be selected.
Also, I need to be able to easily import new information daily to the site and append it to the current information.
My question is what would be the best way to go about doing this, MYSQL or something? You will have to bare with me, as I have already stated I am not very knowledgeable with web design. This project will basically be a learn as I go situation, but any solution that someone has that is significantly easier to program then another, those types would be appreciated. I would like to know everything, what kind of database needs to be setup behind the scenes, what programs I will need to set those up on an internal PC, what software will work good to link up the database to the "gui" design that the sales people will see, etc etc etc???
Let me know what you think,
Matt
I am really hoping that you guys can help point me in the right direction on this.
My company consists of various clients throughout the country and a sales team that brings in these clients. We have become frustrated with the sales people constantly asking our IT department how much sales they had on one particular day and we would like to go about designing a website that is an easy interface for these sales people to use that can get them the questions they are asking answered.
Our system does not have any easy way of linking up to it live thru SQL or anything so the information for these sales people will be created one time per day and uploaded to a website for their discretional review.
Basically it needs to be as simple as this...
Some one goes to the website, answers a couple questions in forms, and based off of those questions a website needs to be returned that displays the results.
So a person needs to be able to go in and Select the Company they wish to see sales data for
The data of the transactions they would like to review, whether it be a single date or a date range
And then based off of that information it would return the numbers.
We have the versatility with our files that we can upload to the website to put them in about any format imaginable, right now the data is comma delimited and looks as follows...
"Company 1","09","11","2006","0","0.00","2265.70","112.88"
"Company 1","09","12","2006","0","0.00","20.53","10.27"
"Company 1","09","01","2006","0","0.00","1129.31","564.67"
"Company 2","09","04","2006","0","0.00","253.37","126.69"
"Company 2","09","05","2006","0","0.00","248.73","9.40"
"Company 3","09","06","2006","0","0.00","128.59","64.31"
"Company 3","09","07","2006","0","0.00","135.46","57.74"
"Company 3","09","08","2006","0","0.00","240.83","45.45"
"Company 3","09","11","2006","0","0.00","306.50","03.29"
"Company 3","09","12","2006","0","0.00","184.13","62.08"
"Company 3","09","01","2006","0","0.00","74.44","34.73"
"Company 3","09","05","2006","0","0.00","173.99","87.02"
"Company 3","09","06","2006","0","0.00","79.44","39.73"
"Company 3","09","07","2006","0","0.00","31.10","15.55"
"Company 3","09","08","2006","0","0.00","273.56","3.29"
The layout for the above information is as follows...
"Name of Client"
"Month"
"Day"
"Year"
"New Referral #"
"New Referral $"
"Sales $"
"Commission $"
So ideally, if a person went in and selected to see results for "Company 3" for the date of 09/12/2006, it would then return sales figures of 184.13 and a commission of 62.08.
Also, if there is more than one entry for the same date, the information needs to be grouped together and summed.
So...
"Company 3","09","12","2006","0","0.00","184.13","62.08"
"Company 3","09","12","2006","0","0.00","184.13","62.08"
"Company 3","09","12","2006","0","0.00","184.13","62.08"
If our database showed the above information, it would return sales figures of 552.39 and commission of 186.24.
Ideally the website needs to be easy to use and I would like to set it up so more than one company can be selected.
Also, I need to be able to easily import new information daily to the site and append it to the current information.
My question is what would be the best way to go about doing this, MYSQL or something? You will have to bare with me, as I have already stated I am not very knowledgeable with web design. This project will basically be a learn as I go situation, but any solution that someone has that is significantly easier to program then another, those types would be appreciated. I would like to know everything, what kind of database needs to be setup behind the scenes, what programs I will need to set those up on an internal PC, what software will work good to link up the database to the "gui" design that the sales people will see, etc etc etc???
Let me know what you think,
Matt