SNAPSHOT n.
3 (Users’ Registration area)
ok… the above picture is the main entry form used to add new users of the wifi network when from
the previous page the OPERATOR clicks on ATTIVAZIONE NUOVO UTENTE WILMA NET (user
session page designed by Jahangir).
I’ll suggest to enlarge this Word document to 200% so that you can see better the text strings
associated with each field, so then, with the MySQL db that should be designed, you can properly
associate each field to each piece of information here on screen.
You should try to reproduce nearly the same form also by dividing it in the same single sections as
seen here also using the same text strings for now… i.e. DATI PERSONALI, DATA E LUOGO DI
NASCITA, and so on.
Now, the following is the association of every field here in the form (written in blue) with the
physical field indicated to Rushabh on a separate document about the USERS table – when
writing this text, it should be written exactly by using the equivalent text written hereby in blue:
   •   LASTNAME                       - Cognome: (free input)
                                            Surname:
   •   FIRSTNAME                      - Nome: (free input)
                                            First name:
   •   SEX                            - Sesso: (M/F selectable through a drop-down in the form)
                                            Sex:
•   BIRTHDAY                      - Data: (day in numbers selectable through a drop-down in the form)
•   BIRTHMONTH                    - “ “ (month in numbers selectable through a drop-down in the form)
•   BIRTHYEAR                - “ ” (year in numbers selectable through a drop-down in the form)
                                     Date of birth:
•   BORN_IN_ITALY            - Nato in Italia: (from a TICK box in the form)
                                     Born in Italy:
•   BIRTHPLACE_ITALY - Comune: (city names selectable through a drop-down in the form)
                                     Born in:
•   BIRTHSTATE_ITALY         - Provincia: (state code selectable through a drop-down in the form)
                                     Born in (state):
•   BIRTH_DETAILS            - Dati di nascita: (see it on the next snapshot – then I’ll explain)
                                     Birth details:
•   FISCALCODE               - Codice fiscale: (free input and/or obtained through a specific
    routine)
                                     Fiscal code:
•   RESIDENT_IN_ITALY        - Residente in Italia: (from a TICK box in the form)
                                     Resident in Italy:
•   ADDRESS                  - Indirizzo: (free input)
                                     Address:
•   STREETNUMBER             - Num.: (free input)
                                     Street number:
•   STATE            - Provincia: (state code selectable through a drop-down in the form)
                                     State:
•   CITY                     - Comune (city names selectable through a drop-down in the form)
                                     City:
•   ZIPCODE                  - C.A.P. (free input)
                                     Zip code:
•   RESIDENCY_DETAILS        - Dati residenza: (see it on the next snapshot – then I’ll explain)
                                     Residency details:
•   PHONE                    - Tel.: (free input)
                                     Phone:
•   FAX                      - Fax.: (free input)
                                     Fax:
•   MOBILE                   - Cell.: (free input)
                                     Mobile:
•   EMAIL                    - Email: (free input)
                                     Email:
•   ID_DOCUMENT_TYPE         - Tipo: (selectable through a drop-down in the form)
                                     ID document type:
•   NUMBER                   - Numero: (free input)
                                     Number:
•   ISSUED_BY                - Rilasciato da: (free input)
                                     Issued by:
•   COUNTRY                  - Nazione: (free input)
                                     By country:
•   ISSUEDAY                 - Rilasciato il: (day in numbers selectable through a drop-down in the
    form)
•   ISSUEMONTH               - “ “ (month in numbers selectable through a drop-down in the form)
•   ISSUEYEAR                     - “ “ (year in numbers selectable through a drop-down in the form)
                                          Date of issue:
•   REGISTRATIONDAY                - Data firma modulo richiesta di accesso: (day in numbers selectable
    through a drop-down in the form)
•   IREGISTRATIONMONTH - “ “ (month in numbers selectable through a drop-down in the form)
•   REGISTRATIONYEAR                 - “ “ (year in numbers selectable through a drop-down in the form)
                                             Date of registration:
•   PROMO_CONSENSUS                  - Presta consenso al trattamento dei dati personali per invio
    informazioni commerciali: (from a TICK box in the form)
                                             I give my consensus in order to receive promotional
                                               information:
•   CHECK1                           - Acquisito modulo di richiesta accesso WilmaNet firmato dal
    Richiedente: (from a TICK box in the form)
                                             Check 1: (this becase this field will not have to appear in the
                                               English version of this registration form)
•   CHECK2                           - Acquisita fotocopia del documento di identità del Richiedente in
    corso di validità: (from a TICK box in the form)
                                             Check 2: (this becase this field will not have to appear in the
                                               English version of this registration form)
•   CHECK3                           - Verificata l’identità del Richiedente: (from a TICK box in the form)
                                              Check 3: (this becase this field will not have to appear in the
                                               English version of this registration form)
•   CHECK4                           - Verificata corrispondenza tra dati anagrafici del modulo di richiesta
    accesso WilmaNet con il documento di identità esibito: (from a TICK box in the form)
                                           Check 4: (this becase this field will not have to appear in the
                                               English version of this registration form)
•   CHECK5                           - Verifica presenza consenso esplicito al trattamento dei dati
    personali: (from a TICK box in the form)
                                           Check 5: (this becase this field will not have to appear in the
                                               English version of this registration form)
SNAPSHOT n.4 (Users’ Registration area)
This snapshot only shows the difference in the form when the Nato in Italia TICK box is left blank
(which means that the user registering is not born in Italy) and also, below, when the same new
user IS NOT RESIDENT in Italy (Residente in Italia)… so that’s why I’ve indicated before those 2
fields for which the note was written in red.
So… when Nato in Italia = NO, then the DATA E LUOGO DI NASCITA section of the form
changes as shown in the following snapshot…
… also if Residente in Italia = NO, here too the RESIDENZA section of the form changes
accordingly as shown here.