Joomla + Virtuemart Newsletter Form
Budget: €30 – €250 EUR
Create a form with the following fields:
'Email' (email)
'Aceptar política de privacidad' (checkbox)
'Enviar' (submit)
When submitting the form, the 'newsletter' table in the 'email' column will be checked to see if the email exists.
-If the email already exists, a message is returned informing the user that their email is already registered in the newsletter: “Tu correo electrónico ya está dado de alta en nuestra newsletter.”
-If the email does not exist, it is included in the MailChimp client's newsletter list using the platform's API, and is also included in the 'newsletter' table in the 'email' column. The registration date is also included in the 'fecha_alta' column (Y-m-d H:i:s).
The 'php' table in the 'status_newsletter' column is checked to see if coupon generation is activated.
-If the value is 0 (not activated), a message is returned informing the user that their email has been correctly added to the Newsletter list: “Tu correo electrónico ha sido agregado a nuestra Newsletter correctamente.”.
-If the value is 1 (activated), the values of the columns 'newsletter_cupon_valor', 'newsletter_cupon_caducidad', 'newsletter_cupon_tipo' and 'newsletter_cupon_textmail' are collected from the 'php' table to create a discount coupon at Virtuemart.
The coupon is created with the following values:
Coupon: Random 8-character string (uppercase letters)
Value: Value collected from the column 'newsletter_cupon_valor'
Percentage or Total: 'newsletter_cupon_tipo'
Coupon Type: Gift coupon
Expiration Date: current date + newsletter_cupon_caducidad (in days)
An email is sent to the email entered with the text included in 'newsletter_cupon_textmail', where the string %valor will be replaced with 'newsletter_cupon_valor' and the string %caducidad with 'newsletter_cupon_caducidad.
A message is returned informing the user that their email has been correctly added to the Newsletter list and also has a discount coupon: “Tu correo electrónico ha sido agregado a nuestro Newsletter correctamente. También te hemos enviado un email con tu cupón descuento.”
'Email' (email)
'Aceptar política de privacidad' (checkbox)
'Enviar' (submit)
When submitting the form, the 'newsletter' table in the 'email' column will be checked to see if the email exists.
-If the email already exists, a message is returned informing the user that their email is already registered in the newsletter: “Tu correo electrónico ya está dado de alta en nuestra newsletter.”
-If the email does not exist, it is included in the MailChimp client's newsletter list using the platform's API, and is also included in the 'newsletter' table in the 'email' column. The registration date is also included in the 'fecha_alta' column (Y-m-d H:i:s).
The 'php' table in the 'status_newsletter' column is checked to see if coupon generation is activated.
-If the value is 0 (not activated), a message is returned informing the user that their email has been correctly added to the Newsletter list: “Tu correo electrónico ha sido agregado a nuestra Newsletter correctamente.”.
-If the value is 1 (activated), the values of the columns 'newsletter_cupon_valor', 'newsletter_cupon_caducidad', 'newsletter_cupon_tipo' and 'newsletter_cupon_textmail' are collected from the 'php' table to create a discount coupon at Virtuemart.
The coupon is created with the following values:
Coupon: Random 8-character string (uppercase letters)
Value: Value collected from the column 'newsletter_cupon_valor'
Percentage or Total: 'newsletter_cupon_tipo'
Coupon Type: Gift coupon
Expiration Date: current date + newsletter_cupon_caducidad (in days)
An email is sent to the email entered with the text included in 'newsletter_cupon_textmail', where the string %valor will be replaced with 'newsletter_cupon_valor' and the string %caducidad with 'newsletter_cupon_caducidad.
A message is returned informing the user that their email has been correctly added to the Newsletter list and also has a discount coupon: “Tu correo electrónico ha sido agregado a nuestro Newsletter correctamente. También te hemos enviado un email con tu cupón descuento.”