function client($postData, $infos, $arrive, $departure, $selected_rooms, $roominfo, $hgconf) { include JPATH_COMPONENT . DS . 'assets/css/sendmail_style.php'; $arrive = date("F d, Y", $arrive); $departure = date("F d, Y", $departure); $body .= '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta http-equiv="Content-Language" content="en-us"> <title>' . $infos->title . "-" . $postData['lastname'] . "/" . $infos->cityname . "-" . $infos->countryname . " (" . $arrive . " > " . $departure . ")" . '</title> </head> <body style=" font-family:verdana; font-size:10px; margin-top:0px; margin-bottom:0px;"> <table width="740" border="0" cellpadding="5" cellspacing="0" align="center"> <tr> <td align="left" valign="top" style="' . $fondocell . '"> <div style="' . $style3 . '"> <p>Dear ' . $postData['gender'] . ' ' . $postData['firstname'] . ' ' . $postData['lastname'] . '</p> <p>We thank you for choosing us.</p> <p>Here are the details of the booking request you just sent to ' . $infos->title . ' at ' . $infos->cityname . ', ' . $infos->countryname . ': </p> </div> </td> </tr> <tr> <td align="left" valign="top" style="' . $fondomain . '">'; if ($infos->travel_agency == 1 and $postData['BookingForSomeoneElse'] == 'true') { $body .= '<font style="' . $style3 . '">' . JText::_('HG_GUEST_NAME') . ': ' . $postData['guest_gender'] . ' ' . $postData['guest_firstname'] . ' ' . $postData['guest_lastname'] . '</font><br>'; } else { $body .= '<font style="' . $style3 . '">' . JText::_('HG_NAME') . ': ' . $postData['gender'] . ' ' . $postData['firstname'] . ' ' . $postData['lastname'] . '</font><br>'; } $body .= '<font style="' . $style3 . '">' . JText::_('HG_ARRIVAL_DATE') . ': ' . $arrive . '</font><br> <font style="' . $style3 . '">' . JText::_('HG_DEPARTURE_DATE') . ': ' . $departure . '</font><br> <font style="' . $style3 . '">' . hg_sendmail::show_adults_childrens_ages($postData['adult'], $postData['children'], $postData['children_ages']) . '</font><br><br>'; //Agrupa las habitaciones seleccionadas en una sola linea for ($i = 0; $i < count($selected_rooms); $i++) { if (!$infos->upon_request) { if ($roominfo[$i]->bedtype != $roominfo[$i]->roomtitle) { if (trim($roominfo[$i]->bedtype) != "") { $info_bed_type = $roominfo[$i]->bedtype . " "; } } if ($roominfo[$i]->maxguest > 1) { $maxguest = ' (' . $info_bed_type . JText::sprintf('HG_MAX_PERSONS', $roominfo[$i]->maxguest) . ')'; } else { $maxguest = ' (' . $info_bed_type . JText::_('HG_SINGLE_OCCUPANCY') . ')'; } } if ($i == 0) { $rooms_selected = $selected_rooms[$i]['valor'] . ' ' . $roominfo[$i]->roomtitle . $maxguest; } else { $rooms_selected = $selected_rooms[$i]['valor'] . ' ' . $roominfo[$i]->roomtitle . $maxguest . '; ' . $rooms_selected; } } $body .= '<font style="' . $style3 . '">' . JText::_('HG_ROOM_TYPE') . ': ' . $rooms_selected . '</font><br>' . "\n"; if (!empty($postData['total_cost_input'])) { $body .= '<br><font style="' . $style3 . '">' . JText::_('HG_TOTAL_ROOM_CHARGE') . ': ' . $infos->currency . ' ' . $postData['total_cost_input'] . '</font><br>' . "\n"; } if (!empty($postData['roomfacilities'])) { $body .= '<br><font style="' . $style3 . '">' . JText::_('HG_ROOM_FACILITIES') . ': ' . $postData['roomfacilities'] . '</font><br>' . "\n"; } if ($postData['comment'] != "") { $body .= '<br><font style="' . $style3 . '">' . JText::_('HG_SPECIAL_REQUEST') . ': ' . $postData['comment'] . '</font><br>' . "\n"; } if ($postData['credit_card_num'] != "" and $postData['r_ExpirationMonth1'] != "Month" and $postData['rd_ExpirationYear1'] != "Year" and $postData['r_NameOnTheCard1'] != "") { $body .= '<br><font style="' . $style3 . '">' . $postData['r_CardType1'] . ' ' . $postData['credit_card_num'] . ' exp ' . $postData['r_ExpirationMonth1'] . ' ' . $postData['rd_ExpirationYear1'] . ' of ' . $postData['r_NameOnTheCard1'] . '</font><br>' . "\n"; } $body .= '</td></tr> <tr> <td> <font style="' . $style3 . '"> <p> This is not an official confirmation; it is just an acknowledgement that the above described request has been received. You shall receive an official reply from an authorized employee of the reservations department / front desk, who you may contact at any time, for anything you may want while staying at ' . $infos->title . '. </p> <p>Regards,</p> <p>Reservations Department</p> <p>P.S. Following are your contact details as we received them:</p> </font> </td> </tr> <tr> <td>'; if (!empty($postData['firstname']) or !empty($postData['lastname'])) { $body .= '<font style="' . $style3 . '">' . JText::_('HG_NAME') . ': ' . $postData['gender'] . ' ' . $postData['firstname'] . ' ' . $postData['lastname'] . '</font><br>'; } if (!empty($postData['agency_name'])) { $body .= '<font style="' . $style3 . '">' . JText::_('HG_AGENCY_NAME') . ': ' . $postData['agency_name'] . '</font><br>'; } if (!empty($postData['iata_number'])) { $body .= '<font style="' . $style3 . '">' . JText::_('HG_IATA_NUMBER') . ': ' . $postData['iata_number'] . '</font><br>'; } $body .= '<br><font style="' . $style3 . '">' . JText::_('HG_COUNTRY_OF_PASSPORT') . ': ' . $postData['country_client'] . '</font><br>'; if (!empty($postData['state'])) { $body .= '<font style="' . $style3 . '">' . JText::_('HG_STATE_PROVINCE') . ': ' . $postData['state'] . '</font><br>'; } $body .= '<font style="' . $style3 . '">' . JText::_('HG_CITY') . ': ' . $postData['city_client'] . '</font><br> <font style="' . $style3 . '">' . JText::_('HG_TELEPHONE_BOOKING') . ': ' . $postData['phone'] . '</font><br>'; if (!empty($postData['fax'])) { $body .= '<font style="' . $style3 . '">' . JText::_('HG_FAX') . ': ' . $postData['fax'] . '</font><br>'; } $body .= '<font style="' . $style3 . '">' . JText::_('HG_EMAIL_ADDRESS') . ': ' . $postData['email'] . '</font><br>'; if (!empty($postData['alternative_email'])) { $body .= '<font style="' . $style3 . '">' . JText::_('HG_ALTERNATIVE_EMAIL') . ': ' . $postData['alternative_email'] . '</font><br>'; } $body .= '</td> </tr> </table> </body> </html>'; return $body; }
function sendmail() { global $hgconf; jimport('joomla.mail.helper'); jimport('joomla.utilities.utility'); $config =& JFactory::getConfig(); $db =& JFactory::getDBO(); $postData['email'] = JMailHelper::cleanAddress(JRequest::getVar('email', '')); $postData['alternative_email'] = JMailHelper::cleanAddress(JRequest::getVar('alternative_email', '')); $postData['gender'] = JRequest::getVar('gender', ''); $postData['guest_gender'] = JRequest::getVar('guest_gender', ''); $postData['firstname'] = JRequest::getVar('firstname', ''); $postData['lastname'] = JRequest::getVar('lastname', ''); $postData['guest_firstname'] = JRequest::getVar('guest_firstname', ''); $postData['guest_lastname'] = JRequest::getVar('guest_lastname', ''); $postData['BookingForSomeoneElse'] = JRequest::getVar('BookingForSomeoneElse', ''); $postData['iata_number'] = JRequest::getVar('iata_number', ''); $postData['agency_name'] = JRequest::getVar('agency_name', ''); $postData['travelAgent'] = JRequest::getVar('travelAgent', ''); $postData['hotel'] = (int) JRequest::getVar('hotel', ''); $postData['city'] = JRequest::getVar('city', ''); $postData['state'] = JRequest::getVar('state', ''); $postData['city_client'] = JRequest::getVar('city_client', ''); $postData['hotel_country'] = JRequest::getVar('hotel_country', ''); $postData['roomtype'] = (int) JRequest::getVar('roomtypelist', ''); $postData['bedtype'] = JRequest::getVar('bedtypelist', ''); $postData['bedtype'] = stripcslashes($postData['bedtype']); $postData['bedtype'] = stripcslashes($postData['bedtype']); $bedtype = stripcslashes($postData['bedtype']); $postData['adult'] = (int) JRequest::getVar('adult', ''); $postData['children'] = (int) JRequest::getVar('children', ''); $postData['children_ages'] = JRequest::getVar('children_ages', ''); $postData['rooms'] = (int) JRequest::getVar('rooms', ''); $postData['breakfast'] = (int) JRequest::getVar('breakfast', ''); $postData['total_cost_input'] = JRequest::getVar('total_cost_input', ''); $inyear = substr(JRequest::getVar('indate-sel-mm'), -4); $inmonth = substr(JRequest::getVar('indate-sel-mm'), 0, -4); $inday = JRequest::getVar('indate-sel-dd'); $postData['checkin'] = $inyear . '-' . $inmonth . '-' . $inday; $outyear = substr(JRequest::getVar('outdate-sel-mm'), -4); $outmonth = substr(JRequest::getVar('outdate-sel-mm'), 0, -4); $outday = JRequest::getVar('outdate-sel-dd'); $postData['checkout'] = $outyear . '-' . $outmonth . '-' . $outday; $postData['country'] = JRequest::getVar('country', ''); $postData['phone'] = JRequest::getVar('phone', ''); $postData['fax'] = JRequest::getVar('fax', ''); $postData['comment'] = JRequest::getVar('comment', ''); $postData['roomfacilities'] = JRequest::getVar('roomfacilities', ''); $postData['r_CardType1'] = JRequest::getVar('r_CardType1', ''); $postData['r_NameOnTheCard1'] = JRequest::getVar('r_NameOnTheCard1', ''); $postData['credit_card_num'] = JRequest::getVar('n1') . JRequest::getVar('n2') . JRequest::getVar('n3') . JRequest::getVar('n4'); $postData['r_ExpirationMonth1'] = JRequest::getVar('r_ExpirationMonth1', ''); $postData['rd_ExpirationYear1'] = JRequest::getVar('rd_ExpirationYear1', ''); $postData['status'] = 2; $postData['sender_ip'] = $_SERVER['REMOTE_ADDR']; $postData['rdate'] = gmdate('Y-m-d H:i:s'); $id = JRequest::getVar('id', ''); $subject = $hgconf->subject; $header = $hgconf->form_header; $note = $hgconf->form_note; $policy = $hgconf->form_policy; $card = 0; //Bandera usada para ver si viene o no los datos de la tajeta de credito $postData['browser'] = $_SERVER['HTTP_USER_AGENT']; //Detecta de el explorador del cual fue enviado la reserva $query = 'SELECT h.title, h.address, co.name AS countryname, c.name AS cityname, h.alias,' . 'h.id_jpmoser, h.email, h.upon_request, h.phone, h.fax, h.send_reserve_directly, ' . 'h.discount, h.travel_agency, h.travel_agency_commission, cur.code AS currency' . ' FROM #__hg_hotelitems AS h' . ' LEFT JOIN #__hg_countries AS co ON co.id = h.country' . ' LEFT JOIN #__hg_cities AS c ON c.id = h.city' . ' LEFT JOIN #__hg_currency AS cur ON cur.id = h.currency' . ' WHERE h.id = ' . $id; $db->setQuery($query); if (!$db->query()) { JError::raiseError(500, $db->stderr(true)); return; } $infos = $db->loadObject(); $query = 'SELECT c.name FROM #__hg_countries AS c WHERE c.id=' . $postData['country']; $db->setQuery($query); if (!$db->query()) { JError::raiseError(500, $db->stderr(true)); return; } $country_client = $db->loadObject(); $postData['country_client'] = $country_client->name; ////////////Start Validation Form///////////////////////// for ($i = 1; $i <= 20; $i++) { $error[$i] = 0; } //Titulo de los errores posibles//////////////////// $err_msg[1] = "Please Insert the Adults Number"; $err_msg[2] = "Invalid arrival or departure date...<br><strong>Please insert valid dates!</strong>"; $err_msg[3] = "Please Insert only Number"; $err_msg[4] = "Please Select Quantity of Room"; $err_msg[5] = "E-Mail Address is not valid"; $err_msg[6] = "Select your type of room"; $err_msg[7] = "Provide Your Name"; $err_msg[8] = "Provide Your LastName"; $err_msg[9] = "Provide your Telephone(s)"; $err_msg[10] = "Provide a Card Holder's Name"; $err_msg[11] = "This is not a valid Credit Card Number"; $err_msg[12] = "Provide a Valid Exp. Date"; $err_msg[13] = "Provide your Country"; $err_msg[14] = "Provide your Credit Card Details"; $err_msg[15] = "Sorry, you have provided an invalid security code, please go back and click on the image once to reload a new one"; $err_msg[16] = "Provide your City"; $err_msg[17] = "Provide Ages of Childrens"; $err_msg[18] = "Provide No. of Children"; $err_msg[19] = "Provide your Guest Name"; $err_msg[20] = "Provide Name of Travel Agency"; //Validaciones por cada campo if ($infos->travel_agency == "1" and $postData['BookingForSomeoneElse'] == "true") { if ($postData['guest_firstname'] == "" or $postData['guest_lastname'] == "") { $error[19] = 1; } if ($postData['travelAgent'] == "on" and $postData['agency_name'] == "") { $error[20] = 1; } } //Esta es una validacion para los casos cuando no son una agencia de viajes y no hayan marcada la opcion Booking for some else if ($postData['firstname'] == "") { $error[7] = 1; } if ($postData['lastname'] == "") { $error[8] = 1; } if ($postData['country'] == "") { $error[13] = 1; } if ($postData['email'] == "") { $error[5] = 1; } if ($postData['phone'] == "") { $error[9] = 1; } if ($postData['city_client'] == "") { $error[16] = 1; } //if ($postData['bedtype']=="0") { $error[6] = 1; } $firstinput1 = $postData['checkin']; $secondinput1 = $postData['checkout']; if ($firstinput1 != "") { $timestamp1 = strtotime($firstinput1); $firstinput1 = date('d/m/Y', $timestamp1); } if ($secondinput1 != "") { $timestamp2 = strtotime($secondinput1); $secondinput1 = date('d/m/Y', $timestamp2); } ///////////////////Formato de fecha dd/mm/yyyy///////////////////// //descomponer fecha de llegada $arrivalday = substr($firstinput1, 0, 2); $arrivalmonth = substr($firstinput1, 3, 2); $arrivalyear = substr($firstinput1, 6, 4); //descomponer fecha de salida $depday = substr($secondinput1, 0, 2); $depmonth = substr($secondinput1, 3, 2); $depyear = substr($secondinput1, 6, 4); ///////////Cambio de nombre de los d�as y a�os////////////////// $previous_date = date("Y/m/d", strtotime(date("Y/m/d") . ' -2 day')); $llegada = $arrivalyear . "/" . $arrivalmonth . "/" . $arrivalday; $salida = $depyear . "/" . $depmonth . "/" . $depday; if ($previous_date < $llegada and $llegada < $salida) { } else { $error[2] = 1; } //Validacion si alguien trata de enviar T.C. incompleta: if ($postData['r_NameOnTheCard1'] != "" or $postData['credit_card_num'] != "" or $postData['r_ExpirationMonth1'] != "Month" or $postData['rd_ExpirationYear1'] != "Year") { //Valida el campo Card Name if ($postData['r_NameOnTheCard1'] == "") { $error[10] = 1; } //Valida si ingresaron numero de tarjeta if ($postData['credit_card_num'] == "") { $error[11] = 1; } //Valida el campo Exp Date if ($postData['r_ExpirationMonth1'] == "Month" or $postData['rd_ExpirationYear1'] == "Year") { $error[12] = 1; } } else { //Hace obligatorio la T.C. para los hoteles que no son Upon Request if (!$infos->upon_request) { //Si no existe nada en los campos de la tarjeta de credito (Es obligatorio la T.C) $error[14] = 1; } } $s = count($error); for ($i = 1; $i <= $s; $i++) { if ($error[$i] == 1) { //Si hay un error que se valide en php, será enviado por correo a la cuenta especificada $body = 'http://www.jpmoser.com/' . $infos->alias . '.html<br><br>'; $body .= 'From ' . $firstinput1 . ' to ' . $secondinput1 . '<br><br>'; $body .= 'Error: ' . $err_msg[$i]; JUtility::sendMail('*****@*****.**', 'Reserve', '*****@*****.**', 'Error for ' . $infos->title, $body, $mode = true, $cc = null, $bcc = null, $attachment = null, $replyto = null, $replytoname = null); //Pagina en Yumi que muestra el error, uno por uno header("Location: " . $this->baseurl . "/jpmoser_guide/index.php?option=com_jumi&fileid=4&err_msg=" . $err_msg[$i]); die; } else { $errores = $errores + 1; } } ////////////End Validation Form///////////////////////// if ($postData['comment'] == JText::_('HG_SPECIAL_REQUESTS')) { $postData['comment'] = ''; } $in = mktime(0, 0, 0, $inmonth, $inday, $inyear); $out = mktime(0, 0, 0, $outmonth, $outday, $outyear); $duration = round(abs($out - $in) / 86400); $mode = $hgconf->emailmode ? true : false; eval("\$selected_rooms=" . $bedtype . ";"); for ($i = 0; $i < count($selected_rooms); $i++) { if ($infos->upon_request) { $query = 'SELECT i.title AS roomtitle' . ' FROM #__hg_roomitems AS i' . ' WHERE i.id = ' . $selected_rooms[$i]['idroom']; } else { $query = 'SELECT r.*, i.title AS roomtitle, r.bedtype AS bedtype' . ' FROM #__hg_roomitems AS i' . ' LEFT JOIN #__hg_roomrates AS r ON i.id = r.room_id' . ' WHERE r.id = ' . $selected_rooms[$i]['idroom']; } $db->setQuery($query); if (!$db->query()) { JError::raiseError(500, $db->stderr(true)); return; } $roominfo[] = $db->loadObject(); } //Este ciclo reune todas las room facilities seleccionadas como checkbox if ($postData['roomfacilities']) { for ($i = 0; $i < count($postData['roomfacilities']); $i++) { $query = 'SELECT name FROM #__hg_roomfacilities AS i WHERE i.id = ' . $postData['roomfacilities'][$i]; $db->setQuery($query); if (!$db->query()) { JError::raiseError(500, $db->stderr(true)); return; } $roomfacility = $db->loadObject(); if ($i == 0) { $room_facility_save = $roomfacility->name; } else { $room_facility_save = $roomfacility->name . '; ' . $room_facility_save; } } $postData['roomfacilities'] = $room_facility_save; } //OJO - TENGO QUE PRESTARLE ATENCION A LA VARIABLE ROOMTYPE PORQUE PARA LOS HOTELES UPON REQUEST ESTO VENDRA VACIO /*if ($postData['roomtype']!=""){ $query = 'SELECT title' . ' FROM #__hg_roomitems' . ' WHERE id = '.$postData['roomtype'] ; $db->setQuery($query); if (!$db->query()) { JError::raiseError( 500, $db->stderr(true)); return; } $roominfo_upon_request = $db->loadObject(); }*/ $total = 0; $total_discout = 0; //Si el hotel es Upon Request entonces: if (!$infos->upon_request) { for ($i = 0; $i < $duration; $i++) { $monref = date('n', $in + 86400 * $i); $dayref = date('j', $in + 86400 * $i) - 1; $day_rate = $this->getReserveRates($roominfo, $monref); // $output .= ($i+1).'. '.date( 'D M d Y', ($in+86400*$i)).' - '; // $output .= '<strong>'.$currency.' '.number_format($day_rate[0][$dayref] * ((100 - $day_rate[1][$dayref]) / 100), 2, '.', '').'</strong><br />'; $total += $day_rate[0][$dayref] * ((100 - $day_rate[1][$dayref]) / 100) * $postData['rooms']; $total_discout += $day_rate[1][$dayref]; } } $total += $total * (($roominfo->taxes + $roominfo->fees) / 100); if ($postData['breakfast']) { $total += $postData['breakfast'] * $postData['adult'] * $roominfo->breakfastprice; } $postData['tamount'] = $total; $postData['damount'] = $total; if (!empty($roominfo)) { for ($i = 0; $i < count($selected_rooms); $i++) { if ($i == 0) { $rooms_save = $selected_rooms[$i]['valor'] . ' ' . $roominfo[$i]->roomtitle . ' ' . $roominfo[$i]->maxguest; } else { $rooms_save = $selected_rooms[$i]['valor'] . ' ' . $roominfo[$i]->roomtitle . ' ' . $roominfo[$i]->maxguest . '; ' . $rooms_save; } } } else { $postData['bedtype'] = "0"; } $postData['roomtype'] = $rooms_save; // initialize email recipients list $email_recipients = $postData['email']; $array_copy_hotel = explode("|", $hgconf->config_email_copy_hotel); if ($hgconf->sendmail_test == '1') { //Envia solo reservas de pruebas a mi cuenta $body_email2 = hg_sendmail::backup($postData, $infos, $in, $out, $selected_rooms, $roominfo, $hgconf); $array_copy_us = explode("|", $hgconf->config_email_copy_bck); $subject_email2 = sprintf($array_copy_hotel[2], $infos->title, $postData['lastname'], $infos->cityname, $infos->countryname, date("F d, Y", $in), date("F d, Y", $out)); JUtility::sendMail($array_copy_us[0], $array_copy_us[1], "*****@*****.**", $subject_email2, $body_email2, $mode, null, null, null, $array_copy_us[6], $array_copy_us[7]); } else { //Este correo se envia al hotel solo si esta marcado en sistema como NO, en el campo que pregunta si la reserva se enviara directamente a nosotros if (!$infos->send_reserve_directly) { //Correo para el hotel $body_email1 = hg_sendmail::hotel($postData, $infos, $in, $out, $selected_rooms, $roominfo, $hgconf); $subject_email1 = sprintf($array_copy_hotel[2], $infos->title, $postData['lastname'], $infos->cityname, $infos->countryname, date("F d, Y", $in), date("F d, Y", $out)); $sendOk = JUtility::sendMail($array_copy_hotel[0], $array_copy_hotel[1], $infos->email, $subject_email1, $body_email1, $mode, $array_copy_hotel[3], $array_copy_hotel[4], null, $array_copy_hotel[5], $array_copy_hotel[6]); } //Copia a nosotros $body_email2 = hg_sendmail::backup($postData, $infos, $in, $out, $selected_rooms, $roominfo, $hgconf); $array_copy_us = explode("|", $hgconf->config_email_copy_bck); $subject_email2 = sprintf($array_copy_hotel[2], $infos->title, $postData['lastname'], $infos->cityname, $infos->countryname, date("F d, Y", $in), date("F d, Y", $out)); $sendOk = JUtility::sendMail($array_copy_us[0], $array_copy_us[1], $array_copy_us[2], $subject_email2, $body_email2, $mode, $array_copy_us[4], $array_copy_us[5], null, $array_copy_us[6], $array_copy_us[7]); //Este es otro email que nos llega a nosotros para usarlo como respuesta una vez contactado al hotel $body_email3 = hg_sendmail::response_client($postData, $infos, $in, $out, $selected_rooms, $roominfo, $hgconf); $array_client_response_mail = explode("|", $hgconf->config_email_response_client); $subject_email3 = sprintf($array_client_response_mail[3], $infos->title, $postData['lastname'], $infos->cityname, $infos->countryname, date("F d, Y", $in), date("F d, Y", $out)); $sendOk = JUtility::sendMail($array_client_response_mail[0], $array_client_response_mail[1], $array_client_response_mail[2], $subject_email3, $body_email3, $mode, $array_client_response_mail[4], $array_client_response_mail[5], null, $email_recipients, $postData['firstname'] . " " . $postData['lastname']); //Email para el cliente de confirmacion de envio de reserva $body_email4 = hg_sendmail::client($postData, $infos, $in, $out, $selected_rooms, $roominfo, $hgconf); $array_client_mail = explode("|", $hgconf->config_email_sent_client); $subject_email4 = sprintf($array_client_mail[2], $infos->title, $postData['lastname'], $infos->cityname, $infos->countryname, date("F d, Y", $in), date("F d, Y", $out)); $sendOk = JUtility::sendMail($array_client_mail[0], $array_client_mail[1], $email_recipients, $subject_email4, $body_email4, $mode, $array_client_mail[4], $array_client_mail[5], null, $array_client_mail[6], $array_client_mail[7]); } if ($sendOk) { $mainframe =& JFactory::getApplication(); $mainframe->enqueueMessage(JText::_('HG_THANK_YOU_FOR_YOUR_RESERVATION')); JTable::addIncludePath(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_hotelguide' . DS . 'tables'); $dataRow =& JTable::getInstance('hg_reservations', ''); // bind the data sent from the form to the table fields $dataRow->bind($postData); // store the message $dataRow->store(); // record the message id so the attached files can be deleted $id = $dataRow->id; /* $query = 'UPDATE #__reservations SET id = ' . $id . ' WHERE id = 0 and r_id = '.$postData['r_id']; $db->setQuery($query); $db->query();*/ } header("Location: " . $this->baseurl . "/jpmoser_guide/index.php?option=com_jumi&fileid=5&hotelname=" . $infos->title); exit; //$this->display(); }