Đã hoàn thành

Web interface to SQL database

This is what I need:

1. a website interface that can securely log into a SQL database and manipulate it

2. three levels of access to the database, admin (there will only be one), user (there will be multiple), and "approver (there will be fewer)"

3. the database is based on an excel spreadsheet that I have right now with very specific fields, some of which are required and others which are optional.

4. normal users will be able to log into the website and input the information that is required. The primary key to the SQL database is the visit number which will be unique.

5. If information that has been entered previously on a previous entry should be available as a drop down for the relevant field to enable faster data entry for the next time.

6. Once the user has input all the information into the database, they have the option to save the information that has been added so far. This save function should be available at any point during their data entry.

7. Users will likely add new information every day to the database and should be able to save progress.

8. At the same point every week (say Thursday), we will require the user to release the data

9. Releasing means they lock the the subset of data that has been entered since the last release period and have essentially locked them from making any more changes.

10. We want the option that once the data has been "released", the user no longer has the option to modify any information in the database, yet the approver does and can review all those records, organized by user.

11. The reviewer views a page that shows all the users for that reviewer. Once they click on a particular user, they can then review and "approve" the data.

12. Once the approver "approves" the information, the only changes that can be made to it are by the [url removed, login to view] administrator shall always be able to modify any information.

13. For the user, prior information from the database from previous release weeks will be displayed in a "prior weeks visits" tab, organized by week of the year.

14. When the user is ready to create a new weeks worth of data, they have the option to enter data again as above.

15. Data that has been approved needs to be exportable into excel format, one excel spreadsheet for each user. So, the approver can have a view that lists all the users, they can then go to each one and click an "export" button. The key to this is that the data needs to be exported in such a way as that the new data is added as a new worksheet, and all the old data is in tabs of previous worksheets by date, clearly denoted as previously exported, but this all needs to be one excel document for each user. The name of the excel file should be logical, like by date and user.

I know this all sounds quite complicated, but what we really need is a system by which nurses can enter their information into a billing database. Once they have entered a full weeks worth of data, we want to lock the database. What we need after that is to be able to export it into excel for each user. But we don't want the excel file to just have the data that they just entered, we want it to have all the data that they have ever entered, but each weeks worth of data should have a separate worksheet of the same excel file from before, just with the new worksheet.

I have a worksheet but it has real life data that I would need to manipulate in order to keep from violating privacy. There are only about 12-15 fields.

If anything I have described is not clear, be free to contact me. It sounds more complicated than it is, but what we really need is a nice interface that allows our nurses to enter data into a database that we can then export to give to our biller. Our biller wants it in a format where each nurse we have has their own excel spreadsheet and the data from prior weeks is there alongside the new data, and they are separated into worksheets within the same excel file per nurse.

Kĩ năng: HTML, MySQL, PHP, Kiến trúc phần mềm, Thiết kế trang web

Xem nhiều hơn: web interface sql database, create web interface access sql database, what is data entry 10 key, what is database entry, what is a 10 key data entry, website design worksheet, web page spreadsheet, web anything, way design web, want to create a website right now, to create a new website free, sql database website design, spreadsheet web page, spreadsheet on web page, spreadsheet on web, spreadsheet on the web, spreadsheet in web page, same day web design, reviewer web, php to excel export, old database, nurses 2, nice design web, need web administrator, i want to create a real website

Về Bên Thuê:
( 2 nhận xét ) Bakersfield, United States

ID dự án: #1673246

Được trao cho:


8+ years of industry exp and working as a full time freelancer. Please check PMB for further details.Thanks.

$1200 USD trong 15 ngày
(28 Đánh Giá)

17 freelancer đang chào giá trung bình $1213 cho công việc này


pls chk pmb

$2000 USD trong 14 ngày
(801 Nhận xét)

Dear sir. I sent you a private message. Please check it. Regards.

$1500 USD trong 20 ngày
(84 Nhận xét)

I read through your specification, well detailed. I will do a very good job for you.

$670 USD trong 18 ngày
(65 Nhận xét)

Dear Sir, Please see PMB.

$1000 USD trong 20 ngày
(26 Nhận xét)

SQL Database and php expert here:-) I understood , overall what exactly you need. . Let's begin !

$1500 USD trong 20 ngày
(56 Nhận xét)

It's not quite complex to me, I can help you on this foe sure, kindly check your pm,thanks.

$1850 USD trong 10 ngày
(13 Nhận xét)

Hi .Net/MSSQL experts [url removed, login to view] check message for details. Thanks

$2000 USD trong 30 ngày
(31 Nhận xét)

I have experience working with PHP, JavaScript, AJAX, MySQL and integration into a site. Check your Private Message to see some examples of sites that I made using PHP. Adrian

$599 USD trong 25 ngày
(31 Nhận xét)

Let expert do this for you.

$900 USD trong 15 ngày
(20 Nhận xét)

Hello sir would like to help you in this project

$500 USD trong 20 ngày
(5 Nhận xét)

No problem. I can start right away.

$1000 USD trong 10 ngày
(1 Nhận xét)

Custom Software Development - <b><i>Removed by Admin</i></b>

$2000 USD trong 1 ngày
(0 Nhận xét)

I'm an experienced php/mysql programmer and will do the job ASAP!

$1000 USD trong 10 ngày
(0 Nhận xét)

Dear Sir, The Administrator removed this message for containing contact details which breaches our Terms of Service Technologies is a global software consulting company specialized in providing Mobile applications, Thêm

$2000 USD trong 45 ngày
(0 Nhận xét)

I am a software developer with 2.5 years of experience. I can do your project in the professional way while considering the performance and quality in mind.

$400 USD trong 5 ngày
(0 Nhận xét)

I have read the project requirement and pptx file and I am very familiar with the projects like this and ready to start. Please consider me.

$500 USD trong 7 ngày
(0 Nhận xét)