Write simple code in PHP

I need a very simple web application in PHP and MySql. This is what it will do:

1. Create a table with the following fields:

a. Sequence number (primary key, autonumber)

b. Tag Number

b.1. Tag type {where type is 0 or 1}

c. year

d. record number

e. status {where status is a drop down with values: messenger, filed, defective, cancelled, re-filed or registered}

g. Date created

h. Date filed

i. Delivered

2. Create a table "notaries" with usual contact fields, such as:

a. Name

b. Last Name

c. Phone

d. Email

f. ID (primary key)

g. Manager {values for this field are 0 or 1}

3. Create table "book"

a. Autonumber (primary key)

a. Book Number (will relate to notary)

b. Contract number

Have a form in which a user will input the following variables:

a. Sequence number (primary key, autonumber)

b. Tag Number (mandatory)

b.1. Second tag number

c. Year

d. Record number

e. Status {where status can be: messenger, filed, defective, cancelled, re-filed or registered}

f. Notary {where notary is a table, and you get to input notary names, emails, phones, etc...}

g. Date created

h. Date filed

i. Delivered

So: The system will control the flow of documents that are to be registered. There will be several notaries, and only one manager, who is also a notary.

Users do not need to login. Only the manager will have access to the site, via a hidden url. This is not sensitive information, it is a simple control.

When a notary creates a new document, we will create a new record.

This record will be started with a TAG number, and related to a notary. ALL documents are always related to the manager as well.

The first status assigned to the document will be MESSENGER, which means, well, that the document was given to the messenger.

The messenger files the document before the national registry and gets "year" and "record". Those two are filled in the record and status changes to "filed"

3 days after being "filed" the system will send an email both to the notary and the manager, reminding them to check the status of the document. The email will contain a simple text template which will let them know that Document number $docnum with from $year, with record number $record, has had status $filed for 72 hours.

If status is not changed, this email will be resent every 24 hours.

After being filed, status can change to 3 stages:

i. registered (in which case, the case is closed)

ii. cancelled (in which case, the case is closed and a new one must be opened with the same contract and notary but new tag, year and record)

iii. defective (in which case, the system will remind you to fix the error and re-file). Said reminder will come every 24 hours.

For procedure purposes, re-filed is the same as filed. The system will allow 72 hours and send an email, and then every 24 hours until status changes.

This will loop until status changes to REGISTERED.

That's it. It is really just a reminder to follow up on the status of documents until they become registered. If you can think of a simpler way to do this, I am up for it.

Skills: MySQL, PHP, Software Architecture

See more: mail code php post check, write simple text based game code, free simple cart php source code, php code remove mp3 tag, write signup page php code, write simple proxy php, simple rsa php code, news script code php simple, check email code php, php yahoo invisible check source code, image upload show php mysql simple code, google simple checkout sample code php, simple graphic php code, write simple formula php, write social engine php code, simple bar code php script, write simple code extension, write twitter code php mysql, seo simple code php

About the Employer:
( 0 reviews ) Costa Rica

Project ID: #5170448

Awarded to:


Dear leogomez74, I am very pleased to provide you the solution you need. Look forward to working with you soon. Best Regards, Rose Office

$110 USD in 14 days
(11 Reviews)

21 freelancers are bidding on average $255 for this job


Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. More

$666 USD in 3 days
(944 Reviews)

Hi I am confident to do this job. ========================================================================= thanks

$263 USD in 3 days
(568 Reviews)

Hello, I have reviewed your project description carefully and your requirement is fully clear to me. I can do this project efficiently. Based on my long time experience i can guarantee your 100% satisfaction. I w More

$360 USD in 5 days
(245 Reviews)

Expert in PHP.I am PHP certified at International Level. I saw your requirement and can easily do it. Hi, I have 8+ years of experience. I am giving you some of my previous work, [login to view URL] It is More

$747 USD in 20 days
(95 Reviews)

We can help you. ""Please have a look on below links: [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] htt More

$178 USD in 7 days
(107 Reviews)

hi we could do it perfectly with accuracy, please let us know if you want any clarification. if you want us to share our skill and previous work please initiate the chat..

$268 USD in 12 days
(160 Reviews)

Hello, My name is Leonardo and I represent Starth Brasil, a startup focused in design and web development, located in Rio de Janeiro, Brazil. I have read all the requirements of this project and my team can provide More

$140 USD in 10 days
(151 Reviews)

Hi There, I read your description. I'm SURE I can do the project. I'd like to discuss with you. I think $230 is fair price. It will take me about 5 days. I have a team. There are 7 developers and one designer in m More

$230 USD in 5 days
(92 Reviews)

Hello Sir, Im serious bidder .. its easy task .. Ready to get it done within 3days. Best Regards Arief Budiman

$155 USD in 3 days
(48 Reviews)

Hello, It is our pleasure to bid on your project. GNA Infotech is a web design and Development Company. We will provide you high quality work which mention as per your job parameters within the timeline. We More

$257 USD in 3 days
(26 Reviews)

sir i have read your requirement fully sir we can do this job because we have 10 years of experience in webdesign and development we are expert in php with mysql ,javascript ,jquery ,ajax,html5 css3 smarty photos More

$222 USD in 5 days
(58 Reviews)

Hello, I know I'm out of Budget but anyway, if you want to have it done within the next 20 hours I can start right now. You can check my feedbacks for more information. regards, MB.

$315 USD in 1 day
(30 Reviews)

Hi, I would like to get this system done, let me know if you want to work with me... I'm available to start from tomorrow. Regards, Andy.

$222 USD in 5 days
(38 Reviews)

Hello. I have read through your entire description and it looks to be a simple document flow system. Shouldn't take very long to make. Thank you for your time and I look forward to working with you.

$150 USD in 7 days
(6 Reviews)

Greeting from BSP( Build Smarter Planet ) Software Services, we have reviewed all your description and willing to start for you, it is really simple web, we will create the great web for you easy to manages the users, More

$315 USD in 20 days
(1 Review)

My name is Duane Scarlett and I am an application developer with 7 years’ experience in the IT industry. I am the project manager for a small software company Water Web Design LLC. The technologies we use are Html 5, More

$155 USD in 15 days
(1 Review)

Let me do the job. Here's my sample site: [login to view URL] I've created that in PHP/MySQL on a CMS structure. I can finish the job in a shorter time, maybe in few days. Let me know the colors you need for More

$105 USD in 15 days
(0 Reviews)

Worked more than 2 year as a web Developer and Designer. Sound knowledge of HTML, CSS, XHTML, javascript and WordPress. Efficient and confident of providing complete Website Development solutions, starting from scratc More

$155 USD in 3 days
(1 Review)

Hello Sir, I read and understand your project details and requirements for creating write simple code in php website and sure to deliver you best quality work following web 2.0 standards. Please have a look at More

$222 USD in 16 days
(0 Reviews)

A proposal has not yet been provided

$111 USD in 3 days
(0 Reviews)