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

  • Status: Closed
  • Præmier: €250
  • Modtagne indlæg: 6
  • Vinder: spylot

Konkurrence Instruktioner

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:
[login to view URL]

Anbefalede Evner

Arbejdsgiverfeedback

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

Profilbillede dariosantos, Portugal.

Bedste indlæg fra denne konkurrence

Se flere indlæg

Offentlig Præciserings Opslagstavle

  • spylot
    spylot
    • 2 år siden

    Is the Aluguer Code shared between Agencies and Offices?

    • 2 år siden
    1. spylot
      spylot
      • 2 år siden

      I completed the project. I decided to keep the code unique on both.

      • 2 år siden
  • web6021
    web6021
    • 2 år siden

    #extended

    • 2 år siden
  • selfvictim
    selfvictim
    • 2 år siden

    #extended

    • 2 år siden
  • harpalsoft
    harpalsoft
    • 2 år siden

    Interesting job. Can it be #extended for 2 more days?

    • 2 år siden
  • njose
    njose
    • 2 år siden

    Hello.. I have started working. Please share the fonts separately if possible. Best, Njose

    • 2 år siden
  • ShakthiNinja
    ShakthiNinja
    • 2 år siden

    Interesting... I like this project... I'm working on it... :)

    • 2 år siden
  • DesignGuruPro
    DesignGuruPro
    • 2 år siden

    working

    • 2 år siden
  • rufio72
    rufio72
    • 2 år siden

    may i use bootstrap?

    • 2 år siden
    1. dariosantos
      Konkurrenceafholder
      • 2 år siden

      Yes

      • 2 år siden
  • joana111
    joana111
    • 2 år siden

    Hello. Is this a mobile site or web? It's not so clear, cause you are asking to do a mobile development first

    • 2 år siden
    1. dariosantos
      Konkurrenceafholder
      • 2 år siden

      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.

      • 2 år siden
  • superInnova
    superInnova
    • 2 år siden

    especially logo, "moving your ways" and icons (footer)
    thanks

    • 2 år siden
    1. dariosantos
      Konkurrenceafholder
      • 2 år siden

      I don't have the header and footer in layers. It's OK to slice the icons and stuff right from the flat image.

      • 2 år siden
  • superInnova
    superInnova
    • 2 år siden

    hi
    do you have Header and footer in layers?

    • 2 år siden
    1. dariosantos
      Konkurrenceafholder
      • 2 år siden

      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.

      • 2 år siden
  • codeplayers365
    codeplayers365
    • 2 år siden

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

    • 2 år siden
    1. dariosantos
      Konkurrenceafholder
      • 2 år siden

      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.

      • 2 år siden

Vis flere kommentarer

Sådan kommer du i gang med konkurrencer

  • Opret din konkurrence

    Opret din konkurrence Hurtigt og nemt

  • Få tonsvis af indlæg

    Få tonsvis af indlæg Fra hele verden

  • Tildel det bedste indlæg

    Tildel det bedste indlæg Download filerne - Nemt!

Opret en Konkurrence Nu eller slut dig til os i dag!