Write simple code in PHP

Concluído Postado Nov 26, 2013 Pago na entrega
Concluído Pago na entrega

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.

MySQL PHP Arquitetura de software

ID do Projeto: #5170448

Sobre o projeto

21 propostas Projeto remoto Ativo em Nov 27, 2013

Concedido a:

RoseOffice

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 em 14 dias
(11 Comentários)
3.7

21 freelancers estão ofertando em média $255 nesse trabalho

rajeshsonisl

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. Mais

$666 USD in 3 dias
(1020 Comentários)
8.8
rabbul

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

$263 USD in 3 dias
(575 Comentários)
8.3
leomedina01

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 Mais

$140 USD in 10 dias
(153 Comentários)
6.9
techwelfare

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 dias
(181 Comentários)
7.2
BestSolutionForU

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 Mais

$230 USD in 5 dias
(92 Comentários)
6.5
keeperprancis

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

$155 USD in 3 dias
(50 Comentários)
5.8
mbenchekroun

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 em 1 dia
(30 Comentários)
5.7
codemaster7

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 dias
(38 Comentários)
5.2
photonzephyr

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 dias
(6 Comentários)
2.9
DannyBSP

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

$315 USD in 20 dias
(1 Comentário)
2.8
WaterWebDev1

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

$155 USD in 15 dias
(1 Comentário)
2.5
vishalnaidu

A proposal has not yet been provided

$111 USD in 3 dias
(0 Comentários)
0.0
bilalicup

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 Mais

$155 USD in 3 dias
(1 Comentário)
0.2