2 almost identical pages with 2 forms each. Save on DB and send emails with automatically generated Excel file

Estado: Closed
Premio: €250
Propuestas recibidas: 6
Ganador: spylot

Winner

Resumen del concurso

I have a lot of projects and few workers. This contest is aimed to find freelancers to work on other projects on a regular basis. ONLY apply if you are able to do other projects in the future.

I am based on Portugal so although I do prefer local based workers, international portuguese/english speakers can apply.

This is like an exam project, I will use it to evaluate your coding skills :)
So, do NOT minify your code. I will see how you structure and organize your HTML, JS and CSS.

So, about the project (PHP / MySQL):

I need PSD to HTML on 2 almost identical pages with 2 forms each.
One form simple sends an email for each entry and the other sends a daily email with an Excel file automatically generated (done by you) with that day's entries.
Both forms save the data on a MySQL BD (with a field telling which of the 2 pages data comes).

The pages need to be responsive and I encourage you to do mobile first development.

I provide the PSD and font files.

You should use jQuery to slide the content from the buttons and to use a TagIt like field on the "Alugueres" (see attached images).

The fields should be validated both on client (JS) and server side (PHP) and all fields marked with * are mandatory.
Field’s validation:
Telemóvel and Telefone must be checked with the Regular Expression ^9[1236][0-9]{7}|2[1-9][0-9]{7}$
Email must be a valid e-mail address
Código Postal must be checked with the RegEx ^\d{4}(-\d{3})?$
Each Aluguer code must have maximum 10 chars and be unique (can’t be repeated on the field and can’t be repeated on database)
The Email on the form “Inscreva-se” must be unique on database.
The form “Participe” only accepts emails that were already submitted on the form “Inscreva-se”.
Each form must have messages to the user telling the form was submitted successfully or why not (don’t worry too much about error messages as long as they make sense)
The button “Europcar dá prémios” is an external link (you can put # on href)

The payment will be sent after I receive the files and its all working as expected.

The PSD files and Fonts can be downloaded here:
https://dl.dropboxusercontent.com/u/4750936/PSD%20and%20Fonts.zip

Habilidades recomendadas

Winner

Publica un concurso similar

Comentarios del empleador

“Great freelancer! Very professional, proactive and always trying to improve. Event thinks of things we forget and develop it.”

dariosantos, Portugal.

Tablero de aclaración pública

spylot
- 7 años atrás
Is the Aluguer Code shared between Agencies and Offices?
- 7 años atrás
1. spylot
  - 7 años atrás
  I completed the project. I decided to keep the code unique on both.
  - 7 años atrás
web6021
- 7 años atrás
#extended
- 7 años atrás
selfvictim
- 7 años atrás
#extended
- 7 años atrás
harpalsoft
- 7 años atrás
Interesting job. Can it be #extended for 2 more days?
- 7 años atrás
njose
- 7 años atrás
Hello.. I have started working. Please share the fonts separately if possible. Best, Njose
- 7 años atrás
ShakthiNinja
- 7 años atrás
Interesting... I like this project... I'm working on it... :)
- 7 años atrás
DesignGuruPro
- 7 años atrás
working
- 7 años atrás
rufio72
- 7 años atrás
may i use bootstrap?
- 7 años atrás
1. Organizador del concurso
  - 7 años atrás
  Yes
  - 7 años atrás
joana111
- 7 años atrás
Hello. Is this a mobile site or web? It's not so clear, cause you are asking to do a mobile development first
- 7 años atrás
1. Organizador del concurso
  - 7 años atrás
  Hello,
  This is a responsive website.
  By that I mean that the website adapts to whatever size the browser has.
  Mobile development first means that the layout is done firstly to small screens and then the CSS media queries are added to make the necessary changes to bigger screens. This way, the mobile phones have to interpret and renderize fewer CSS rules.
  - 7 años atrás
superInnova
- 7 años atrás
especially logo, "moving your ways" and icons (footer)
thanks
- 7 años atrás
1. Organizador del concurso
  - 7 años atrás
  I don't have the header and footer in layers. It's OK to slice the icons and stuff right from the flat image.
  - 7 años atrás
superInnova
- 7 años atrás
hi
do you have Header and footer in layers?
- 7 años atrás
1. Organizador del concurso
  - 7 años atrás
  Hi,
  I don't have the header and footer in layers. It's ok to slice the icons and stuff right from the flat image.
  - 7 años atrás
codeplayers365
- 7 años atrás
Hi, I'm going to start working on this project. can you please clear below query?
"One form simple sends an email for each entry and the other sends a daily email with an Excel file automatically generated (done by you) with that day's entries."
- 7 años atrás
1. Organizador del concurso
  - 7 años atrás
  Hi,
  Every entry on the form "Inscreva-se" is saved on the Database and triggers an email to some manager's email.
  Every entry on the form "Participe" is also saved on the Database however it doesn't trigger the email to the manager.
  What happens is that every day the website generates an Excel file with the previous' day entries and send it (as attachment) to the same manager's email.
  - 7 años atrás