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

Status: Closed
Hadiah: €250
Entri Diterima: 6
Pemenang: spylot

Winner

Deskripsi Kontes

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

Keahlian yang Disarankan

Winner

Buat Kontes Seperti Ini

Umpan balik Pemberi kerja

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

dariosantos, Portugal.

Papan Klarifikasi Publik

spylot
- 7 tahun yang lalu
Is the Aluguer Code shared between Agencies and Offices?
- 7 tahun yang lalu
1. spylot
  - 7 tahun yang lalu
  I completed the project. I decided to keep the code unique on both.
  - 7 tahun yang lalu
web6021
- 7 tahun yang lalu
#extended
- 7 tahun yang lalu
selfvictim
- 7 tahun yang lalu
#extended
- 7 tahun yang lalu
harpalsoft
- 7 tahun yang lalu
Interesting job. Can it be #extended for 2 more days?
- 7 tahun yang lalu
njose
- 7 tahun yang lalu
Hello.. I have started working. Please share the fonts separately if possible. Best, Njose
- 7 tahun yang lalu
ShakthiNinja
- 7 tahun yang lalu
Interesting... I like this project... I'm working on it... :)
- 7 tahun yang lalu
DesignGuruPro
- 7 tahun yang lalu
working
- 7 tahun yang lalu
rufio72
- 7 tahun yang lalu
may i use bootstrap?
- 7 tahun yang lalu
1. Penyelenggara Kontes
  - 7 tahun yang lalu
  Yes
  - 7 tahun yang lalu
joana111
- 7 tahun yang lalu
Hello. Is this a mobile site or web? It's not so clear, cause you are asking to do a mobile development first
- 7 tahun yang lalu
1. Penyelenggara Kontes
  - 7 tahun yang lalu
  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 tahun yang lalu
superInnova
- 7 tahun yang lalu
especially logo, "moving your ways" and icons (footer)
thanks
- 7 tahun yang lalu
1. Penyelenggara Kontes
  - 7 tahun yang lalu
  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 tahun yang lalu
superInnova
- 7 tahun yang lalu
hi
do you have Header and footer in layers?
- 7 tahun yang lalu
1. Penyelenggara Kontes
  - 7 tahun yang lalu
  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 tahun yang lalu
codeplayers365
- 7 tahun yang lalu
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 tahun yang lalu
1. Penyelenggara Kontes
  - 7 tahun yang lalu
  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 tahun yang lalu