[url removed, login to view] front-end website for MS SQL 2008 database - repost 3

Closed

We need a simple [url removed, login to view] website developing which allows customers to search for POD (proof of delivery) documents (tiff or pdf) that have been scanned into the database.

We have two SQL 2008 tables each of which contain consignment details and partial path to the file/directory. These are in a different formats as we are moving from one scanning system to another. I have attached sample data.

SourceDB1 is the new table format. The POD field contains the path to a PDF file containing the scanned PODs.

SourceDB2 is the old table format. The consSig field contains a path to a folder containing the scanned PODs in several TIF files. The ImageCount field shows the number of files.

We need a website that allows customers to logon and search for POD files using the following search fields:

1) Consignment number

2) Reference number

3) Invoice number

4) Date range (start and end date)

All this information is in the two SQL tables. We need the website to be able to search for PODs from both tables,

Results should be displayed in a grid showing:

1) Account number

2) Consignment number

3) Reference number

4) Invoice number

5) Collection Address

6) Delivery Address

7) Collection date

8) Delivery date

9) Link to POD.

Where there is more than one POD for a consignment, a pop up window should appear allowing the user to select which one to download/display.

We also need an admin page for the website where administrators can setup user logins for the site.

Each user login should have access to PODs from specific accounts so we need an admin page where we can assign accounts to different user logins. Administrators should be able to see PODs from all accounts.

We do not have a SQL table for user logins so that should be designed as part of this project,

Skills: Graphic Design, HTML, PHP, Website Design

See more: sql pdf files, sql pdf file, project front page design sample, developing website using php, data front, search for search for, net developing, ms access 2013, invoice front, Front end website, front end database design, path pdf, database design sample, using front end project, php sql pdf, project database design pdf, website front end design, grid invoice php, sql front end design, design simple sql, sql search asp, login front end, net pop table, asp sql search

Project ID: #4141769

3 freelancers are bidding on average £215 for this job

bistanil98

Need more detail,can we discuss this,for more detail,check PM.

£220 GBP in 10 days
(14 Reviews)
5.7
kinghawk

Dear Sir I am having 5+ year of experience in this similar work, I developed 40+ the .net vs and ms sql 2008 & 2010 website / online applications for local clients and firms I work on one term, 100% satisfactio More

£250 GBP in 10 days
(0 Reviews)
0.0
kollachaitanya

I understood your project summary, There might be changes in the delivery date based on the requirement

£175 GBP in 10 days
(0 Reviews)
0.0