En cours

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.

Compétences : HTML, MySQL, PHP, Architecture Logicielle, Design de site internet

Voir plus : 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

Concernant l'employeur :
( 2 commentaires ) Bakersfield, United States

N° du projet : #1673246

Décerné à :

eurekasoftwares

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

1200 $ USD en 15 jours
(18 Commentaires)
5.9

18 freelance ont fait une offre moyenne de 1242 $ pour ce travail

toinnisfree

pls chk pmb

2000 $ USD en 14 jours
(531 Commentaires)
7.8
canlan318

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

1500 $ USD en 20 jours
(76 Commentaires)
6.9
sandeep25101982

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

2000 $ USD en 30 jours
(25 Commentaires)
6.1
cygital

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

670 $ USD en 18 jours
(36 Commentaires)
6.0
rakshit0

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

1500 $ USD en 20 jours
(55 Commentaires)
5.9
adibr70

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 en 25 jours
(30 Commentaires)
5.5
SSADeveloper

I understand your requirements. Not only will I provide a fully functional product but I will provide great support. I'm able to talk text, phone, email, and chat.

1745 $ USD en 35 jours
(38 Commentaires)
5.1
sikandermandal

Dear Sir, Please see PMB.

1000 $ USD en 20 jours
(13 Commentaires)
5.0
experter

Let expert do this for you.

900 $ USD en 15 jours
(20 Commentaires)
4.8
buzzcoder

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

1850 $ USD en 10 jours
(4 Commentaires)
3.6
anthakkar08

Hello sir would like to help you in this project

500 $ USD en 20 jours
(4 Commentaires)
2.9
luvfilpus

No problem. I can start right away.

1000 $ USD en 10 jours
(1 Commentaire)
2.0
getveltrod

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, Plus

2000 $ USD en 45 jours
(7 Commentaires)
1.6
GV6sX3nO0

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

2000 $ USD en 1 jour
(0 Commentaires)
0.0
marbouti

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

1000 $ USD en 10 jours
(0 Commentaires)
0.0
kannadasangbe

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 en 5 jours
(0 Commentaires)
0.0
rakeshsoft206

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 en 7 jours
(0 Commentaires)
0.0