attendee_new.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2021   Dorian Vabre      <dorian.vabre@gmail.com>
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <https://www.gnu.org/licenses/>.
 */
 
if (!defined('NOLOGIN')) {
  define("NOLOGIN", 1); // This means this output page does not require to be logged.
}
if (!defined('NOCSRFCHECK')) {
  define("NOCSRFCHECK", 1); // We accept to go on this page from external web site.
}
if (!defined('NOIPCHECK')) {
  define('NOIPCHECK', '1'); // Do not check IP defined into conf $dolibarr_main_restrict_ip
}
if (!defined('NOBROWSERNOTIF')) {
  define('NOBROWSERNOTIF', '1');
}
 
 
// For MultiCompany module.
// Do not use GETPOST here, function is not defined and define must be done before including main.inc.php
// TODO This should be useless. Because entity must be retrieve from object ref and not from url.
$entity = (!empty($_GET['entity']) ? (int) $_GET['entity'] : (!empty($_POST['entity']) ? (int) $_POST['entity'] : 1));
if (is_numeric($entity)) {
  define("DOLENTITY", $entity);
}
 
// Load Dolibarr environment
require '../../main.inc.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/company.lib.php';
require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php';
require_once DOL_DOCUMENT_ROOT.'/eventorganization/class/conferenceorbooth.class.php';
require_once DOL_DOCUMENT_ROOT.'/eventorganization/class/conferenceorboothattendee.class.php';
require_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php';
require_once DOL_DOCUMENT_ROOT.'/compta/facture/class/facture.class.php';
require_once DOL_DOCUMENT_ROOT.'/compta/facture/class/paymentterm.class.php';
require_once DOL_DOCUMENT_ROOT.'/core/class/html.formcompany.class.php';
require_once DOL_DOCUMENT_ROOT.'/contact/class/contact.class.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
 
global $dolibarr_main_url_root;
 
// Init vars
$errmsg = '';
$errors = array();
$error = 0;
$backtopage = GETPOST('backtopage', 'alpha');
$action = GETPOST('action', 'aZ09');
 
$email = GETPOST("email");
$societe = GETPOST("societe");
$emailcompany = GETPOST("emailcompany");
$note_public = GETPOST('note_public', "restricthtml");
 
// Getting id from Post and decoding it
$type = GETPOST('type', 'aZ09');
if ($type == 'conf') {
  $id = GETPOST('id', 'int');
} else {
  $id = GETPOST('fk_project', 'int') ? GETPOST('fk_project', 'int') : GETPOST('id', 'int');
}
 
$conference = new ConferenceOrBooth($db);
$project = new Project($db);
 
if ($type == 'conf') {
  $resultconf = $conference->fetch($id);
  if ($resultconf < 0) {
    print 'Bad value for parameter id';
    exit;
  }
  $resultproject = $project->fetch($conference->fk_project);
  if ($resultproject < 0) {
    $error++;
    $errmsg .= $project->error;
    $errors = array_merge($errors, $project->errors);
  }
}
 
$currentnbofattendees = 0;
if ($type == 'global') {
  $resultproject = $project->fetch($id);
  if ($resultproject < 0) {
    $error++;
    $errmsg .= $project->error;
    $errors = array_merge($errors, $project->errors);
  } else {
    $sql = "SELECT COUNT(*) as nb FROM ".MAIN_DB_PREFIX."eventorganization_conferenceorboothattendee";
    $sql .= " WHERE fk_project = ".((int) $project->id);
 
    $resql = $db->query($sql);
    if ($resql) {
      $obj = $db->fetch_object($resql);
      if ($obj) {
        $currentnbofattendees = $obj->nb;
      } else {
        dol_print_error($db);
      }
    }
  }
}
 
// Security check
$securekeyreceived = GETPOST('securekey', 'alpha');
$securekeytocompare = dol_hash($conf->global->EVENTORGANIZATION_SECUREKEY.'conferenceorbooth'.$id, 'md5');
 
// We check if the securekey collected is OK
if ($securekeytocompare != $securekeyreceived) {
  print $langs->trans('MissingOrBadSecureKey');
  exit;
}
 
// Load translation files
$langs->loadLangs(array("main", "companies", "install", "other", "eventorganization"));
 
// Initialize technical object to manage hooks of page. Note that conf->hooks_modules contains array of hook context
$hookmanager->initHooks(array('publicnewmembercard', 'globalcard'));
 
$extrafields = new ExtraFields($db);
 
$user->loadDefaultValues();
 
// Security check
if (empty($conf->eventorganization->enabled)) {
  httponly_accessforbidden('Module Event organization not enabled');
}
 
 
function llxHeaderVierge($title, $head = "", $disablejs = 0, $disablehead = 0, $arrayofjs = '', $arrayofcss = '')
{
  global $user, $conf, $langs, $mysoc;
 
  top_htmlhead($head, $title, $disablejs, $disablehead, $arrayofjs, $arrayofcss); // Show html headers
 
  print '<body id="mainbody" class="publicnewmemberform">';
 
  // Define urllogo
  $urllogo = DOL_URL_ROOT.'/theme/common/login_logo.png';
 
  if (!empty($mysoc->logo_small) && is_readable($conf->mycompany->dir_output.'/logos/thumbs/'.$mysoc->logo_small)) {
    $urllogo = DOL_URL_ROOT.'/viewimage.php?cache=1&amp;modulepart=mycompany&amp;file='.urlencode('logos/thumbs/'.$mysoc->logo_small);
  } elseif (!empty($mysoc->logo) && is_readable($conf->mycompany->dir_output.'/logos/'.$mysoc->logo)) {
    $urllogo = DOL_URL_ROOT.'/viewimage.php?cache=1&amp;modulepart=mycompany&amp;file='.urlencode('logos/'.$mysoc->logo);
  } elseif (is_readable(DOL_DOCUMENT_ROOT.'/theme/dolibarr_logo.svg')) {
    $urllogo = DOL_URL_ROOT.'/theme/dolibarr_logo.svg';
  }
 
  print '<div class="center">';
  // Output html code for logo
  if ($urllogo) {
    print '<div class="backgreypublicpayment">';
    print '<div class="logopublicpayment">';
    print '<img id="dolpaymentlogo" src="'.$urllogo.'"';
    print '>';
    print '</div>';
    if (empty($conf->global->MAIN_HIDE_POWERED_BY)) {
      print '<div class="poweredbypublicpayment opacitymedium right"><a class="poweredbyhref" href="https://www.dolibarr.org?utm_medium=website&utm_source=poweredby" target="dolibarr" rel="noopener">'.$langs->trans("PoweredBy").'<br><img class="poweredbyimg" src="'.DOL_URL_ROOT.'/theme/dolibarr_logo.svg" width="80px"></a></div>';
    }
    print '</div>';
  }
 
  if (!empty($conf->global->EVENTORGANIZATION_IMAGE_PUBLIC_INTERFACE)) {
    print '<div class="backimagepubliceventorganizationsubscription">';
    print '<img id="idEVENTORGANIZATION_IMAGE_PUBLIC_INTERFACE" src="'.$conf->global->EVENTORGANIZATION_IMAGE_PUBLIC_INTERFACE.'">';
    print '</div>';
  }
 
  print '</div>';
 
  print '<div class="divmainbodylarge">';
}
 
function llxFooterVierge()
{
  print '</div>';
 
  printCommonFooter('public');
 
  print "</body>\n";
  print "</html>\n";
}
 
 
 
/*
 * Actions
 */
 
$parameters = array();
// Note that $action and $object may have been modified by some hooks
$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action);
if ($reshook < 0) {
  setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
}
 
// Action called when page is submitted
if (empty($reshook) && $action == 'add' && (!empty($conference->id) && $conference->status==2  || !empty($project->id) && $project->status == Project::STATUS_VALIDATED)) {
  $error = 0;
 
  $urlback = '';
 
  $db->begin();
 
  if (!GETPOST("email")) {
    $error++;
    $errmsg .= $langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Email"))."<br>\n";
  }
  // If the price has been set, name is required for the invoice
  if (!GETPOST("societe") && !empty(floatval($project->price_registration))) {
    $error++;
    $errmsg .= $langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Company"))."<br>\n";
  }
  if (GETPOST("email") && !isValidEmail(GETPOST("email"))) {
    $error++;
    $langs->load("errors");
    $errmsg .= $langs->trans("ErrorBadEMail", GETPOST("email"))."<br>\n";
  }
  if (!GETPOST("country_id")) {
    $error++;
    $errmsg .= $langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Country"))."<br>\n";
  }
 
  if (!$error) {
    // Check if attendee already exists (by email and for this event)
    $confattendee = new ConferenceOrBoothAttendee($db);
 
    $filter = array();
 
    if ($type == 'global') {
      $filter = array('t.fk_project'=>((int) $id), 'customsql'=>'t.email="'.$db->escape($email).'"');
    }
    if ($type == 'conf') {
      $filter = array('t.fk_actioncomm'=>((int) $id), 'customsql'=>'t.email="'.$db->escape($email).'"');
    }
 
    // Check if there is already an attendee into table eventorganization_conferenceorboothattendee for same event (or conference/booth)
    $resultfetchconfattendee = $confattendee->fetchAll('', '', 0, 0, $filter);
 
    if (is_array($resultfetchconfattendee) && count($resultfetchconfattendee) > 0) {
      // Found confattendee
      $confattendee = array_shift($resultfetchconfattendee);
    } else {
      // Need to create a confattendee
      $confattendee->date_creation = dol_now();
      $confattendee->date_subscription = dol_now();
      $confattendee->email = $email;
      $confattendee->fk_project = $project->id;
      $confattendee->fk_actioncomm = $id;
      $confattendee->note_public = $note_public;
 
      $confattendee->ip = getUserRemoteIP();
      $nb_post_max = getDolGlobalInt("MAIN_SECURITY_MAX_POST_ON_PUBLIC_PAGES_BY_IP_ADDRESS", 200);
      $now = dol_now();
      $minmonthpost = dol_time_plus_duree($now, -1, "m");
      // Calculate nb of post for IP
      $nb_post_ip = 0;
      if ($nb_post_max > 0) { // Calculate only if there is a limit to check
        $sql = "SELECT COUNT(ref) as nb_attendee";
        $sql .= " FROM ".MAIN_DB_PREFIX."eventorganization_conferenceorboothattendee";
        $sql .= " WHERE ip = '".$db->escape($confattendee->ip)."'";
        $sql .= " AND date_creation > '".$db->idate($minmonthpost)."'";
        $resql = $db->query($sql);
        if ($resql) {
          $num = $db->num_rows($resql);
          $i = 0;
          while ($i < $num) {
            $i++;
            $obj = $db->fetch_object($resql);
            $nb_post_ip = $obj->nb_attendee;
          }
        }
      }
 
      $resultconforbooth = -1;
 
      if ($nb_post_max > 0 && $nb_post_ip >= $nb_post_max) {
        $error++;
        $errmsg .= $langs->trans("AlreadyTooMuchPostOnThisIPAdress");
        array_push($confattendee->errors, $langs->trans("AlreadyTooMuchPostOnThisIPAdress"));
        setEventMessage($errmsg, 'errors');
      } else {
        $resultconfattendee = $confattendee->create($user);
      }
      if ($resultconfattendee < 0) {
        $error++;
        $errmsg .= $confattendee->error;
        $errors = array_merge($errors, $confattendee->errors);
      }
    }
 
    // At this point, we have an existing $confattendee. It may not be linked to a thirdparty.
    //var_dump($confattendee);
 
    // If the registration has already been paid for this attendee
    if (!empty($confattendee->date_subscription) && !empty($confattendee->amount)) {
      $securekeyurl = dol_hash($conf->global->EVENTORGANIZATION_SECUREKEY.'conferenceorbooth'.$id, 'master');
      $redirection = $dolibarr_main_url_root.'/public/eventorganization/subscriptionok.php?id='.((int) $id).'&securekey='.urlencode($securekeyurl);
 
      $mesg = $langs->trans("RegistrationAndPaymentWereAlreadyRecorded", $email);
      setEventMessages($mesg, null, 'mesgs');
 
      $db->commit();
 
      Header("Location: ".$redirection);
      exit;
    }
 
    $resultfetchthirdparty = 0;
 
    $genericcompanyname = $langs->trans('EventParticipant').' '.($emailcompany ? $emailcompany : $email); // Keep this label simple so we can retreive same thirdparty for another event
 
    // Getting the thirdparty or creating it
    $thirdparty = new Societe($db);
    $contact = new Contact($db);
    // Fetch using fk_soc if the attendee was already found
    if (!empty($confattendee->fk_soc) && $confattendee->fk_soc > 0) {
      $resultfetchthirdparty = $thirdparty->fetch($confattendee->fk_soc);
    } else {
      if (empty($conf->global->EVENTORGANIZATION_DISABLE_RETREIVE_THIRDPARTY_FROM_NAME)) {
        // Fetch using the field input by end user if we have just created the attendee
        if ($resultfetchthirdparty <= 0 && !empty($societe) && !empty($emailcompany)) {
          $resultfetchthirdparty = $thirdparty->fetch('', $societe, '', '', '', '', '', '', '', '', $emailcompany);
          if ($resultfetchthirdparty > 0) {
            // We found a unique result with the name + emailcompany, so we set the fk_soc of attendee
            $confattendee->fk_soc = $thirdparty->id;
            $confattendee->update($user);
          } elseif ($resultfetchthirdparty == -2) {
            $thirdparty->error = $langs->trans("ErrorSeveralCompaniesWithNameContactUs", $mysoc->email);
          }
        }
        // Fetch using the field input by end user if we have just created the attendee
        if ($resultfetchthirdparty <= 0 && !empty($societe) && !empty($email) && $email != $emailcompany) {
          $resultfetchthirdparty = $thirdparty->fetch('', $societe, '', '', '', '', '', '', '', '', $email);
          if ($resultfetchthirdparty > 0) {
            // We found a unique result with the name + email, so we set the fk_soc of attendee
            $confattendee->fk_soc = $thirdparty->id;
            $confattendee->update($user);
          } elseif ($resultfetchthirdparty == -2) {
            $thirdparty->error = $langs->trans("ErrorSeveralCompaniesWithNameContactUs", $mysoc->email);
          }
        }
      }
      if ($resultfetchthirdparty <= 0 && !empty($emailcompany)) {
        // Try to find thirdparty from the email only
        $resultfetchthirdparty = $thirdparty->fetch('', '', '', '', '', '', '', '', '', '', $emailcompany);
        if ($resultfetchthirdparty > 0) {
          // We found a unique result with that email only, so we set the fk_soc of attendee
          $confattendee->fk_soc = $thirdparty->id;
          $confattendee->update($user);
        } elseif ($resultfetchthirdparty == -2) {
          $thirdparty->error = $langs->trans("ErrorSeveralCompaniesWithEmailContactUs", $mysoc->email);
        }
      }
      if ($resultfetchthirdparty <= 0 && !empty($email) && $email != $emailcompany) {
        // Try to find thirdparty from the email only
        $resultfetchthirdparty = $thirdparty->fetch('', '', '', '', '', '', '', '', '', '', $email);
        if ($resultfetchthirdparty > 0) {
          // We found a unique result with that email only, so we set the fk_soc of attendee
          $confattendee->fk_soc = $thirdparty->id;
          $confattendee->update($user);
        } elseif ($resultfetchthirdparty == -2) {
          $thirdparty->error = $langs->trans("ErrorSeveralCompaniesWithEmailContactUs", $mysoc->email);
        }
      }
      if ($resultfetchthirdparty <= 0 && !empty($genericcompanyname)) {
        // Try to find thirdparty from the generic mail only
        $resultfetchthirdparty = $thirdparty->fetch('', $genericcompanyname, '', '', '', '', '', '', '', '', '');
        if ($resultfetchthirdparty > 0) {
          // We found a unique result with that name + email, so we set the fk_soc of attendee
          $confattendee->fk_soc = $thirdparty->id;
          $confattendee->update($user);
        } elseif ($resultfetchthirdparty == -2) {
          $thirdparty->error = $langs->trans("ErrorSeveralCompaniesWithNameContactUs", $mysoc->email);
        }
      }
 
      // TODO Add more tests on a VAT number, profid or a name ?
 
      if ($resultfetchthirdparty <= 0 && !empty($email)) {
        // Try to find the thirdparty from the contact
        $resultfetchcontact = $contact->fetch('', null, '', $email);
        if ($resultfetchcontact > 0 && $contact->fk_soc > 0) {
          $thirdparty->fetch($contact->fk_soc);
          $confattendee->fk_soc = $thirdparty->id;
          $confattendee->update($user);
          $resultfetchthirdparty = 1;
        }
      }
 
      if ($resultfetchthirdparty <= 0 && !empty($societe)) {
        // Try to find thirdparty from the company name only
        $resultfetchthirdparty = $thirdparty->fetch('', $societe, '', '', '', '', '', '', '', '', '');
        if ($resultfetchthirdparty > 0) {
          // We found a unique result with that name only, so we set the fk_soc of attendee
          $confattendee->fk_soc = $thirdparty->id;
          $confattendee->update($user);
        } elseif ($resultfetchthirdparty == -2) {
          $thirdparty->error = "ErrorSeveralCompaniesWithNameContactUs";
        }
      }
    }
 
    // If price is empty, no need to create a thirdparty, so we force $resultfetchthirdparty as if we have already found thirdp party.
    if (empty(floatval($project->price_registration))) {
      $resultfetchthirdparty = 1;
    }
 
    if ($resultfetchthirdparty < 0) {
      // If an error was found
      $error++;
      $errmsg .= $thirdparty->error;
      $errors = array_merge($errors, $thirdparty->errors);
    } elseif ($resultfetchthirdparty == 0) {  // No thirdparty found + a payment is expected
      // Creation of a new thirdparty
      if (!empty($societe)) {
        $thirdparty->name     = $societe;
      } else {
        $thirdparty->name     = $genericcompanyname;
      }
      $thirdparty->address      = GETPOST("address");
      $thirdparty->zip          = GETPOST("zipcode");
      $thirdparty->town         = GETPOST("town");
      $thirdparty->client       = $thirdparty::PROSPECT;
      $thirdparty->fournisseur  = 0;
      $thirdparty->country_id   = GETPOST("country_id", 'int');
      $thirdparty->state_id     = GETPOST("state_id", 'int');
      $thirdparty->email        = ($emailcompany ? $emailcompany : $email);
 
      // Load object modCodeTiers
      $module = (!empty($conf->global->SOCIETE_CODECLIENT_ADDON) ? $conf->global->SOCIETE_CODECLIENT_ADDON : 'mod_codeclient_leopard');
      if (substr($module, 0, 15) == 'mod_codeclient_' && substr($module, -3) == 'php') {
        $module = substr($module, 0, dol_strlen($module) - 4);
      }
      $dirsociete = array_merge(array('/core/modules/societe/'), $conf->modules_parts['societe']);
      foreach ($dirsociete as $dirroot) {
        $res = dol_include_once($dirroot.$module.'.php');
        if ($res) {
          break;
        }
      }
      $modCodeClient = new $module($db);
 
      if (empty($tmpcode) && !empty($modCodeClient->code_auto)) {
        $tmpcode = $modCodeClient->getNextValue($thirdparty, 0);
      }
      $thirdparty->code_client = $tmpcode;
      $readythirdparty = $thirdparty->create($user);
      if ($readythirdparty < 0) {
        $error++;
        $errmsg .= $thirdparty->error;
        $errors = array_merge($errors, $thirdparty->errors);
      } else {
        $thirdparty->country_code = getCountry($thirdparty->country_id, 2, $db, $langs);
        $thirdparty->country      = getCountry($thirdparty->country_code, 0, $db, $langs);
 
        // Update attendee country to match country of thirdparty
        $confattendee->fk_soc     = $thirdparty->id;
        $confattendee->update($user);
      }
    }
  }
 
  if (!$error) {
    // If the registration needs a payment
    if (!empty(floatval($project->price_registration))) {
      $outputlangs = $langs;
 
      // TODO Use default language of $thirdparty->default_lang to build $outputlang
 
      // Get product to use for invoice
      $productforinvoicerow = new Product($db);
      $productforinvoicerow->id = 0;
 
      $resultprod = 0;
      if ($conf->global->SERVICE_CONFERENCE_ATTENDEE_SUBSCRIPTION > 0) {
        $resultprod = $productforinvoicerow->fetch($conf->global->SERVICE_CONFERENCE_ATTENDEE_SUBSCRIPTION);
      }
 
      // Create the draft invoice for the payment
      if ($resultprod < 0) {
        $error++;
        $errmsg .= $productforinvoicerow->error;
        $errors = array_merge($errors, $productforinvoicerow->errors);
      } else {
        $facture = new Facture($db);
        if (empty($confattendee->fk_invoice)) {
          $facture->type = Facture::TYPE_STANDARD;
          $facture->socid = $thirdparty->id;
          $facture->paye = 0;
          $facture->date = dol_now();
          $facture->cond_reglement_id = $confattendee->cond_reglement_id;
          $facture->fk_project = $project->id;
          $facture->status = Facture::STATUS_DRAFT;
 
          if (empty($facture->cond_reglement_id)) {
            $paymenttermstatic = new PaymentTerm($confattendee->db);
            $facture->cond_reglement_id = $paymenttermstatic->getDefaultId();
            if (empty($facture->cond_reglement_id)) {
              $error++;
              $confattendee->error = 'ErrorNoPaymentTermRECEPFound';
              $confattendee->errors[] = $confattendee->error;
            }
          }
          $resultfacture = $facture->create($user);
          if ($resultfacture <= 0) {
            $confattendee->error = $facture->error;
            $confattendee->errors = $facture->errors;
            $error++;
          } else {
            $confattendee->fk_invoice = $resultfacture;
            $confattendee->update($user);
          }
        } else {
          $facture->fetch($confattendee->fk_invoice);
        }
 
        // Add link between invoice and the attendee registration
        /*if (!$error) {
          $facture->add_object_linked($confattendee->element, $confattendee->id);
        }*/
      }
 
      if (!$error) {
        // Add line to draft invoice
        $vattouse = get_default_tva($mysoc, $thirdparty, $productforinvoicerow->id);
 
        $labelforproduct = $outputlangs->trans("EventFee", $project->title);
        if ($project->location) {
          $labelforproduct .= ' - '.$project->location;
        }
        $date_start = $project->date_start_event;
        $date_end = $project->date_end_event;
 
        // If there is no lines yet, we add one
        if (empty($facture->lines)) {
          $pu_ttc = floatval($project->price_registration);
          $pu_ht = 0;
          $price_base_type = 'TTC';
 
          $result = $facture->addline($labelforproduct, $pu_ht, 1, $vattouse, 0, 0, $productforinvoicerow->id, 0, $date_start, $date_end, 0, 0, '', $price_base_type, $pu_ttc, 1);
          if ($result <= 0) {
            $confattendee->error = $facture->error;
            $confattendee->errors = $facture->errors;
            $error++;
          }
        }
      }
 
      if (!$error) {
        $db->commit();
 
        // Registration was recorded and invoice was generated, but payment not yet done.
        // TODO
        // Send an email to says registration shas been received and that we are waiting for the payment.
        // Should send email template (EventOrganizationEmailRegistrationEvent) saved into conf EVENTORGANIZATION_TEMPLATE_EMAIL_REGISTRATION_EVENT.
 
        // Now we redirect to the payment page
        $sourcetouse = 'organizedeventregistration';
        $reftouse = $facture->id;
        $redirection = $dolibarr_main_url_root.'/public/payment/newpayment.php?source='.urlencode($sourcetouse).'&ref='.urlencode($reftouse);
        if (!empty($conf->global->PAYMENT_SECURITY_TOKEN)) {
          if (!empty($conf->global->PAYMENT_SECURITY_TOKEN_UNIQUE)) {
            $redirection .= '&securekey='.dol_hash($conf->global->PAYMENT_SECURITY_TOKEN . $sourcetouse . $reftouse, 2); // Use the source in the hash to avoid duplicates if the references are identical
          } else {
            $redirection .= '&securekey='.urlencode($conf->global->PAYMENT_SECURITY_TOKEN);
          }
        }
 
        Header("Location: ".$redirection);
        exit;
      } else {
        $db->rollback();
      }
    } else {
      $db->commit();
 
      // No price has been set
      // Validating the subscription
      $confattendee->setStatut(1);
 
      // Sending mail
      require_once DOL_DOCUMENT_ROOT.'/core/class/CMailFile.class.php';
      include_once DOL_DOCUMENT_ROOT.'/core/class/html.formmail.class.php';
      $formmail = new FormMail($db);
      // Set output language
      $outputlangs = new Translate('', $conf);
      $outputlangs->setDefaultLang(empty($thirdparty->default_lang) ? $mysoc->default_lang : $thirdparty->default_lang);
      // Load traductions files required by page
      $outputlangs->loadLangs(array("main", "members"));
      // Get email content from template
      $arraydefaultmessage = null;
 
      $labeltouse = $conf->global->EVENTORGANIZATION_TEMPLATE_EMAIL_AFT_SUBS_EVENT;
      if (!empty($labeltouse)) {
        $arraydefaultmessage = $formmail->getEMailTemplate($db, 'eventorganization_send', $user, $outputlangs, $labeltouse, 1, '');
      }
 
      if (!empty($labeltouse) && is_object($arraydefaultmessage) && $arraydefaultmessage->id > 0) {
        $subject = $arraydefaultmessage->topic;
        $msg     = $arraydefaultmessage->content;
      }
 
      $substitutionarray = getCommonSubstitutionArray($outputlangs, 0, null, $thirdparty);
      complete_substitutions_array($substitutionarray, $outputlangs, $object);
 
      $subjecttosend = make_substitutions($subject, $substitutionarray, $outputlangs);
      $texttosend = make_substitutions($msg, $substitutionarray, $outputlangs);
 
      $sendto = $thirdparty->email;
      $from = $conf->global->MAILING_EMAIL_FROM;
      $urlback = $_SERVER["REQUEST_URI"];
 
      $ishtml = dol_textishtml($texttosend); // May contain urls
 
      $mailfile = new CMailFile($subjecttosend, $sendto, $from, $texttosend, array(), array(), array(), '', '', 0, $ishtml);
 
      $result = $mailfile->sendfile();
      if ($result) {
        dol_syslog("EMail sent to ".$sendto, LOG_DEBUG, 0, '_payment');
      } else {
        dol_syslog("Failed to send EMail to ".$sendto, LOG_ERR, 0, '_payment');
      }
 
      $securekeyurl = dol_hash($conf->global->EVENTORGANIZATION_SECUREKEY.'conferenceorbooth'.$id, 2);
      $redirection = $dolibarr_main_url_root.'/public/eventorganization/subscriptionok.php?id='.((int) $id).'&securekey='.urlencode($securekeyurl);
 
      Header("Location: ".$redirection);
      exit;
    }
    //Header("Location: ".$urlback);
    //exit;
  } else {
    $db->rollback();
  }
}
 
 
/*
 * View
 */
 
$form = new Form($db);
$formcompany = new FormCompany($db);
 
llxHeaderVierge($langs->trans("NewRegistration"));
 
print '<br>';
print load_fiche_titre($langs->trans("NewRegistration"), '', '', 0, 0, 'center');
 
 
print '<div align="center">';
print '<div id="divsubscribe">';
print '<div class="center subscriptionformhelptext">';
 
// Welcome message
 
print '<span class="opacitymedium">'.$langs->trans("EvntOrgWelcomeMessage").'</span>';
print '<br>';
print '<span class="eventlabel">'.$project->title . ' '. $conference->label.'</span><br>';
if ($project->date_start_event || $project->date_end_event) {
  print '<span class="fa fa-calendar pictofixedwidth"></span>';
}
if ($project->date_start_event) {
  $format = 'day';
  $tmparray = dol_getdate($project->date_start_event, false, '');
  if ($tmparray['hours'] || $tmparray['minutes'] || $tmparray['minutes']) {
    $format = 'dayhour';
  }
  print dol_print_date($project->date_start_event, $format);
}
if ($project->date_start_event && $project->date_end_event) {
  print ' - ';
}
if ($project->date_end_event) {
  $format = 'day';
  $tmparray = dol_getdate($project->date_end_event, false, '');
  if ($tmparray['hours'] || $tmparray['minutes'] || $tmparray['minutes']) {
    $format = 'dayhour';
  }
  print dol_print_date($project->date_end_event, $format);
}
if ($project->date_start_event || $project->date_end_event) {
  print '<br>';
}
if ($project->location) {
  print '<span class="fa fa-map-marked-alt pictofixedwidth"></span>'.$project->location.'<br>';
}
 
$maxattendees = 0;
if ($conference->id > 0) {
  /* date of project is not  date of event so commented
  print $langs->trans("Date").': ';
  print dol_print_date($conference->datep);
  if ($conference->date_end) {
    print ' - ';
    print dol_print_date($conference->datef);
  }*/
} else {
  /* date of project is not  date of event so commented
  print $langs->trans("Date").': ';
  print dol_print_date($project->date_start);
  if ($project->date_end) {
    print ' - ';
    print dol_print_date($project->date_end);
  }*/
  $maxattendees = $project->max_attendees;  // Max attendeed for the project/event
}
print '</div>';
 
if ($maxattendees && $currentnbofattendees >= $maxattendees) {
  print '<br>';
  print '<div class="warning">'.$langs->trans("MaxNbOfAttendeesReached").'</div>';
  print '<br>';
}
 
 
 
dol_htmloutput_errors($errmsg, $errors);
 
if ((!empty($conference->id) && $conference->status == ConferenceOrBooth::STATUS_CONFIRMED) || (!empty($project->id) && $project->status == Project::STATUS_VALIDATED)) {
  if (empty($maxattendees) || $currentnbofattendees < $maxattendees) {
    // Print form
    print '<form action="' . $_SERVER["PHP_SELF"] . '" method="POST" name="newmember">' . "\n";
    print '<input type="hidden" name="token" value="' . newToken() . '" / >';
    print '<input type="hidden" name="entity" value="' . $entity . '" />';
    print '<input type="hidden" name="action" value="add" />';
    print '<input type="hidden" name="type" value="' . $type . '" />';
    print '<input type="hidden" name="id" value="' . $conference->id . '" />';
    print '<input type="hidden" name="fk_project" value="' . $project->id . '" />';
    print '<input type="hidden" name="securekey" value="' . $securekeyreceived . '" />';
 
    print '<br>';
    print '<br>';
    //print '<span class="opacitymedium">' . $langs->trans("FieldsWithAreMandatory", '*') . '</span><br>';
    //print $langs->trans("FieldsWithIsForPublic",'**').'<br>';
 
    print dol_get_fiche_head('');
 
    print '<script type="text/javascript">
    jQuery(document).ready(function () {
      jQuery(document).ready(function () {
        jQuery("#selectcountry_id").change(function() {
           document.newmember.action.value="create";
           document.newmember.submit();
        });
      });
    });
    </script>';
 
    print '<table class="border" summary="form to subscribe" id="tablesubscribe">' . "\n";
 
    // Email
    print '<tr><td><span class="fieldrequired">' . $langs->trans("EmailAttendee") . '</span></td><td>';
    print img_picto('', 'email', 'class="pictofixedwidth"');
    print '<input type="text" name="email" maxlength="255" class="minwidth200 widthcentpercentminusx maxwidth300" value="' . dol_escape_htmltag(GETPOST('email')) . '" required></td></tr>' . "\n";
 
    // Company
    print '<tr id="trcompany" class="trcompany"><td>';
    if (!empty(floatval($project->price_registration))) {
      print '<span class="fieldrequired">';
    }
    print $langs->trans("Company");
    if (!empty(floatval($project->price_registration))) {
      print '</span>';
    }
    print '</td><td>';
    print img_picto('', 'company', 'class="pictofixedwidth"');
    print '<input type="text" name="societe" class="minwidth200 widthcentpercentminusx maxwidth300" value="' . dol_escape_htmltag(GETPOST('societe')) . '"'.(empty(floatval($project->price_registration)) ? '' : ' required').'></td></tr>' . "\n";
 
    // Email company for invoice
    if ($project->price_registration) {
      print '<tr><td>' . $form->textwithpicto($langs->trans("EmailCompany"), $langs->trans("EmailCompanyForInvoice")) . '</td><td>';
      print img_picto('', 'email', 'class="pictofixedwidth"');
      print '<input type="text" name="emailcompany" maxlength="255" class="minwidth200 widthcentpercentminusx maxwidth300" value="' . dol_escape_htmltag(GETPOST('emailcompany')) . '"></td></tr>' . "\n";
    }
 
    // Address
    print '<tr><td>' . $langs->trans("Address") . '</td><td>' . "\n";
    print '<textarea name="address" id="address" wrap="soft" class="centpercent" rows="' . ROWS_2 . '">' . dol_escape_htmltag(GETPOST('address', 'restricthtml'), 0, 1) . '</textarea></td></tr>' . "\n";
 
    // Zip / Town
    print '<tr><td>' . $langs->trans('Zip') . ' / ' . $langs->trans('Town') . '</td><td>';
    print $formcompany->select_ziptown(GETPOST('zipcode'), 'zipcode', array('town', 'selectcountry_id', 'state_id'), 6, 1);
    print ' / ';
    print $formcompany->select_ziptown(GETPOST('town'), 'town', array('zipcode', 'selectcountry_id', 'state_id'), 0, 1);
    print '</td></tr>';
 
    // Country
    print '<tr><td><span class="fieldrequired">'.$langs->trans('Country').'</span></td><td>';
    print img_picto('', 'country', 'class="pictofixedwidth"');
    $country_id = GETPOST('country_id');
    if (!$country_id && !empty($conf->global->MEMBER_NEWFORM_FORCECOUNTRYCODE)) {
      $country_id = getCountry($conf->global->MEMBER_NEWFORM_FORCECOUNTRYCODE, 2, $db, $langs);
    }
    if (!$country_id && !empty($conf->geoipmaxmind->enabled)) {
      $country_code = dol_user_country();
      //print $country_code;
      if ($country_code) {
        $new_country_id = getCountry($country_code, 3, $db, $langs);
        //print 'xxx'.$country_code.' - '.$new_country_id;
        if ($new_country_id) {
          $country_id = $new_country_id;
        }
      }
    }
    $country_code = getCountry($country_id, 2, $db, $langs);
    print $form->select_country($country_id, 'country_id', '', 0, 'minwidth200 widthcentpercentminusx maxwidth300');
    print '</td></tr>';
    // State
    if (empty($conf->global->SOCIETE_DISABLE_STATE)) {
      print '<tr><td>' . $langs->trans('State') . '</td><td>';
      if ($country_code) {
        print img_picto('', 'state', 'class="pictofixedwidth"');
        print $formcompany->select_state(GETPOST("state_id"), $country_code);
      } else {
        print '';
      }
      print '</td></tr>';
    }
 
    if ($project->price_registration) {
      print '<tr><td>' . $langs->trans('Price') . '</td><td>';
      print '<span class="amount price-registration">'.price($project->price_registration, 1, $langs, 1, -1, -1, $conf->currency).'</span>';
      print '</td></tr>';
    }
 
    $notetoshow = $note_public;
    print '<tr><td>' . $langs->trans('Note') . '</td><td>';
    if (!empty($conf->global->EVENTORGANIZATION_DEFAULT_NOTE_ON_REGISTRATION)) {
      $notetoshow = str_replace('\n', "\n", $conf->global->EVENTORGANIZATION_DEFAULT_NOTE_ON_REGISTRATION);
    }
    print '<textarea name="note_public" class="centpercent" rows="'.ROWS_9.'">'.dol_escape_htmltag($notetoshow, 0, 1).'</textarea>';
    print '</td></tr>';
 
    print "</table>\n";
 
    print dol_get_fiche_end();
 
    // Save
    print '<div class="center">';
    print '<input type="submit" value="' . $langs->trans("Submit") . '" id="submitsave" class="button">';
    if (!empty($backtopage)) {
      print ' &nbsp; &nbsp; <input type="submit" value="' . $langs->trans("Cancel") . '" id="submitcancel" class="button button-cancel">';
    }
    print '</div>';
 
    print "</form>\n";
 
    print "<br>";
    print '</div></div>';
  }
} else {
  print $langs->trans("ConferenceIsNotConfirmed");
}
 
llxFooterVierge();
 
$db->close();