Lukket

website with sql database

Brief

Website details: New Site

The customer requires a website that will automate everything they currently do manually.

They want to go paperless and do everything on line.

This is how things are currently done.

An instruction comes into the secretary from the estate agents (office) with the site details, post code and install date and job type

The job gets filled out onto the sign erectors job sheet for the day Address/post code/ install date/

Sign erector does job and ticks off sheets and sheet comes back in at end of day to be entered in by secretary.

At the end on each week the completed jobs go to the accountant who signs them off and invoices them.

An sql relationship database is needed. (we also need to use this with other businesses)

Project

The front page needs to have a login and registration area. This will be for the estate agents to log their own details (and the details of their office, some estate agent have more than one office) If there is more than one office a drop down menu will be shown and the office address can be populated for that estate agent contact.

The registration will also be for sign erectors and customer office staff.

Types of access after log in

Estate Agent

Once logged in the estate agent will be a presented with a dash board.

This will show the following –

Log a job Job Type, Job Details

How many boards are out (by postcode) (viewed on maps or similar)

Job status (Job Type) or job completed

Outstanding invoices to be paid

Staff

Dashboard

Total number of boards out

Boards by Estate agent

Boards by Sign erector

Boards by post code

Boards by date range (from to dates)

Revenue by Estate Agent

Revenue by Sign Erector

Revenue by Post code

Revenue by date range (from to dates)

Job status by Estate agent

Job status by Sign erector

Job status by post code

Job status by date range (from to dates)

Jobs to be invoiced by Estate agent

Jobs to be invoiced by Sign Erector

Jobs to be invoiced by post code

Jobs to be invoiced by date range (from to dates)

Outstanding invoices by Estate agent

Outstanding invoices by Sign Erector

Outstanding invoices by post code

Outstanding invoices by date range (from to dates)

Job lists sent to account to be invoiced

By day

By Week

By Month

By Year

(all with graphs for easy viewing)

MORE MAY BE ADDED

Sign Erectors

Dashboard

Incoming Jobs

Job status

Completed jobs

Tables required

1. Office Staff

a. Name

b. Email address

c. Phone number

2. Sign Erectors

a. Name

b. Phone number

c. Email address

d. Van registration

e. Area covered (by post codes)

3. Estate Agents

a. Company name

b. Contact name (see 4)

c. Contact number(see 4)

d. Contact email address

e. Office details(see 4)

4. Estate Agent Offices ( some estate agents have more than one office)

a. Company name

b. Address

c. Contact name

d. Contact number

e. Email address

5. Job Type

a. Initial Visit (included in initial price)

b. Sold Slip (included in initial price)

c. Removal of Board (included in initial price)

d. Re-erection of board (extra cost)

e. Extra Visits (extra cost)

6. Job Details

a. Site

b. Address

c. Post code

d. Installation date

e. Erection/sold slip/Removal/re erect/extra visit date

Evner: HTML, MySQL, PHP, SQL, Web Design

Se mere: how to create a database driven website, how to connect html to sql database, how to create a website with a database, database website templates, database driven website tutorial, how to connect website to sql database, database driven website template, database website examples, create website sql database, website sql database, changes existing asp net website sql database, joomla website sql database, clone website sql database, website aspnet sql database net sql, sql database schema website, viewing sql database php frontend, search sql database joomla website, update website live sports scores sql database, moving website sql database, generate static website sql database

Om arbejdsgiveren:
( 3 bedømmelser ) manchester, United Kingdom

Projekt ID: #16598914

58 freelancere byder i gennemsnit £1516 på dette job

phpMaestro

Hi, Ongoing through the complete detail and reference your requirement is to develop a real estate website through which user can post their house for rent/sell. There will be agents module also. Users will be able Flere

£3000 GBP in 45 dage
(433 bedømmelser)
10.0
infoway

Dear Employer, Thanks for your details description. We have reviewed in details and am very pleased to tell you that we are very much interested in your project and this is highly doable at our end. But before p Flere

£1500 GBP in 30 dage
(622 bedømmelser)
9.7
aistechnolabs

Greetings, I am very thankful for this opportunity. It’s really exciting that we have similar kind of expertise and work experience: [login to view URL] [login to view URL] [login to view URL] http://w Flere

£3402 GBP in 30 dage
(77 bedømmelser)
9.0
Yknox

Hello I'm interesting your project very well I'm a Good expert of PHP, AngularJS, Java, Mysql, HTML, CSS, Math, Algorithm. I m quite well experienced in these jobs. Let's go ahead with me I want to service for y Flere

£1600 GBP in 15 dage
(548 bedømmelser)
8.7
KESHAVINFOTECH

Hi There, Thanks for your valuable time. :-) Please check below points : 1. Brief Website details: New Site The customer requires a website that will automate everything they currently do manually. Th Flere

£1390 GBP in 22 dage
(781 bedømmelser)
8.7
michale21

Hello, Greetings from Votive Technologies!! We have gone through your requirement and as per my understanding, you want to build a website as per requirement. We have already developed that kind of similar featur Flere

£999 GBP in 20 dage
(484 bedømmelser)
8.9
netdevbiz

Hi, We have expertise in the different business domain. We will surely love to do your assigned work as per project demands. We had successfully completed many projects with various price ranges as per client’s need Flere

£1000 GBP in 20 dage
(229 bedømmelser)
8.7
webbookstudio

Hello! Can start the work right now! Have great experience on CMS, Frameworks, Mockup Designs, Template Customizations, PHP/PHP5, Sql databases, Software Architecture, JavaScript, jQuery, HTML5, CSS, Responsive. Flere

£1340 GBP in 26 dage
(172 bedømmelser)
8.2
tretanz

Hi, We have a team of designer and developer who will work as per your requirement and finish in your deadline. We are TOP rated in the Freelancer and believe in the quality of work. We are an expert in Custom W Flere

£1473 GBP in 20 dage
(511 bedømmelser)
8.4
Techizer

Hello Sir! With the reference of your description I would like to inform you that we are the most eligible freelancer here with whom you can discuss this project. After our discussion I am sure you will love to Flere

£1666 GBP in 30 dage
(186 bedømmelser)
8.3
bdsiddhi

Hi There, Greetings!! * As you required, We can surely help you to build a responsive & elegant website for estate agents + Staff members + Sign Erectors. * We are a team of creative designers & highly experienced Flere

£2000 GBP in 30 dage
(205 bedømmelser)
8.4
BVMSolution

Dear Sir, Hope you are doing well. After carefully reviewing the requirements of the job description, I feel that we are very much suitable for the job. We can start working now . please give a chance to work for Flere

£1444 GBP in 21 dage
(299 bedømmelser)
8.2
marchingantssl

Hi there, We are a team with expertise in Backend / Frontend Development with PHP, MySQL and other Web Technologies. Ping me so that I can send you the backend(s) we have worked on. Our offer includes free bug Flere

£800 GBP in 20 dage
(217 bedømmelser)
7.8
CodeAmbassador

Hello, Having gone through the requirements, your detailed description was very useful to give me an overall idea of what you're looking to accomplish, yet I have lots of questions pertaining the detailed implementa Flere

£12500 GBP in 60 dage
(91 bedømmelser)
7.7
mrinalbhuyan

Hi, I have read your project and got your requirement . I have done similar work lots of time. I have some questions regarding the project . Let me know if you have some time to discuss the details further . Ple Flere

£888 GBP in 10 dage
(171 bedømmelser)
7.3
riteshjain009

//** READY TO START RIGHT AWAY **// With the reference of your description I would like to inform you that we are the most eligible freelancer here with whom you can discuss this project. After our discussion I am s Flere

£1000 GBP in 25 dage
(277 bedømmelser)
7.4
tranngocanh1702

Hi, I am Anna with more than 6 years experience in web and cross-platform app development including Hybrid, PHP, Laravel framework, Slim, CodeIgniter, MySQL, PostgreSQL, HTML, CSS, Javascript, jQuery, Vuejs, Ajax, Flere

£1250 GBP in 20 dage
(116 bedømmelser)
7.3
Aloknano

Hello Sir, i have done a similar concept of work, its a job portal website, we have great team with ecellent knowlegde. we can deliver the work as per your request. lest have some conversation and discuss the projec Flere

£1500 GBP in 30 dage
(326 bedømmelser)
7.8
nittilegupta

Hello, I have read the project description an understood the functionality and flow of the website. I can certainly do my best to achieve the best outcome and fulfill your project requirements. I would like to be Flere

£2700 GBP in 30 dage
(101 bedømmelser)
7.8
tarunmehan

Hello, Greetings! I will deliver you a professionally designed, Well Coded (for better indexing in search engine), & efficient (quick loading & SEO optimized) website. I'll automate the process following all the gui Flere

£1111 GBP in 20 dage
(68 bedømmelser)
7.1