public function onrequestpayAction() { global $mySession; $db = new Db(); $spclOffer = implode(",", $mySession->spclOfferId); $extras = implode(",", $mySession->extrasId); //$dataForm['property_id'] = $mySession->pptyId; $dataForm['property_id'] = $mySession->bookingUser['property_id']; $dataForm['user_id'] = $mySession->bookingUser['user_id']; $dataForm['date_from'] = date('Y-m-d', strtotime($mySession->arrivalDate)); $dataForm['date_to'] = date('Y-m-d', strtotime($mySession->arrivalDate . " + " . $mySession->noOfNights . " day")); $dataForm['offer_id'] = $spclOffer; $dataForm['min_rate'] = $mySession->minrate; //$dataForm['extras_id'] = $extras; $dataForm['children'] = $mySession->Children; $dataForm['adult'] = $mySession->Adults; $dataForm['infants'] = $mySession->Infants; $dataForm['total'] = $mySession->Infants; $dataForm['rental_amt'] = $mySession->totalCost; $dataForm['booking_date'] = date('Y-m-d'); $dataForm['booking_type'] = '1'; $dataForm['paid_status'] = '0'; $db->save(BOOKING, $dataForm); $bookingId = $db->lastInsertId(); //code to save data in calendar table /*$dataForm = array(); $dataForm['property_id'] = $mySession->pptyId; $dataForm['date_from'] = date('Y-m-d',strtotime($mySession->arrivalDate)); $dataForm['date_to'] = date('Y-m-d',strtotime($mySession->arrivalDate." + ".$mySession->noOfNights." day")); $dataForm['cal_status'] = '0'; save_calendar_stat($mySession->pptyId,$dataForm['date_from'],$dataForm['date_to']);*/ //saving in the booking extra table foreach ($mySession->extrasId as $values) { $extrasArr = $db->runQuery("select ename,eprice*exchange_rate as eprice,etype,stay_type from " . EXTRAS . " \n\t\t\t inner join " . PROPERTY . " on " . PROPERTY . ".id = " . EXTRAS . ".property_id\n\t\t\t\t\t\t\t\t\t\tinner join " . CURRENCY . " on " . CURRENCY . ".currency_code = " . PROPERTY . ".currency_code\n\t\t\t\t\t\t\t\t\t\twhere eid = '" . $values . "'\t "); $dataForm = array(); $dataForm['booking_id'] = $bookingId; $dataForm['option_name'] = $extrasArr[0]['ename']; $dataForm['option_price'] = $extrasArr[0]['eprice']; $dataForm['option_status'] = $extrasArr[0]['etype']; $dataForm['stay_type'] = $extrasArr[0]['stay_type']; $db->save(BOOKING_EXTRA, $dataForm); } // $extrasArr = $db->runQuery("select ename,eprice*exchange_rate as eprice,etype,stay_type from ".EXTRAS." // inner join ".PROPERTY." on ".PROPERTY.".id = ".EXTRAS.".property_id // inner join ".CURRENCY." on ".CURRENCY.".currency_code = ".PROPERTY.".currency_code // where property_id = '".$mySession->pptyId."' and etype = '1' "); $extrasArr = $db->runQuery("select ename,eprice*exchange_rate as eprice,etype,stay_type from " . EXTRAS . " \n\t\t\t\t\t\t\t\t\tinner join " . PROPERTY . " on " . PROPERTY . ".id = " . EXTRAS . ".property_id\n \t\t\t\t\t\t\t\t inner join " . CURRENCY . " on " . CURRENCY . ".currency_code = " . PROPERTY . ".currency_code\n\t\t\t\t\t\t\t\t\twhere property_id = '" . $mySession->bookingUser['property_id'] . "' and etype = '1' "); //saving for the compulosry extras table foreach ($extrasArr as $values) { $dataForm = array(); $dataForm['booking_id'] = $bookingId; $dataForm['option_name'] = $values['ename']; $dataForm['option_price'] = $values['eprice']; $dataForm['option_status'] = $values['etype']; $dataForm['stay_type'] = $values['stay_type']; $db->save(BOOKING_EXTRA, $dataForm); } $mySession->sucessMsg = "Thank you.. Property has been Booked Successfully"; $pptyno = $db->runQuery("select propertycode from " . PROPERTY . " where id = '" . $mySession->pptyId . "' "); $fullName = $mySession->LoggedUserName; $Url = '<a href="' . APPLICATION_URL . '">' . APPLICATION_URL . '</a>'; $templateData = $db->runQuery("select * from " . EMAIL_TEMPLATES . " where template_id='7'"); $messageText = $templateData[0]['email_body']; $subject = $templateData[0]['email_subject']; $messageText = str_replace("[NAME]", $fullName, $messageText); $messageText = str_replace("[SITENAME]", SITE_NAME, $messageText); $messageText = str_replace("[SITEURL]", APPLICATION_URL, $messageText); $messageText = str_replace("[PROPERTYNO]", $pptyno[0]['propertycode'], $messageText); SendEmail($dataForm['email_address'], $subject, $messageText); __bookSessionClear(); $this->_redirect("contents/pages/slug/bookingsucess"); }
public function pagesAction() { global $mySession; $db = new Db(); $slug = $this->getRequest()->getParam("slug"); $userArr = $db->runQuery("select * from " . USERS . " where user_id = '" . $mySession->LoggedUserId . "' "); $sql = "select * from " . PAGES1 . " where synonyms = '{$slug}'"; $staticArr = $db->runQuery($sql); if (count($staticArr) == 0) { $this->render("error/error"); } //========== Fetching Meta Information ===========================// $metaArr = $db->runQuery("select meta_title, meta_keyword, meta_description from " . META_INFO . " where meta_id = 3"); $Title = str_replace('[PAGE_NAME]', $staticArr[0]['page_title'], $metaArr[0]['meta_title']); $Description = str_replace('[PAGE_NAME]', $staticArr[0]['page_description'], $metaArr[0]['meta_title']); $this->view->headTitle($Title)->offsetUnset(0); // $this->view->headMeta('description', $Description); $this->view->headMeta($staticArr[0]['meta_description'], 'description'); $this->view->headMeta($staticArr[0]['meta_keywords'], 'keywords'); $strContent = str_replace("[SITEURL]", APPLICATION_URL, $staticArr[0]['page_content']); $strContent = str_replace("[FULLNAME]", $userArr[0]['email_address'], $strContent); if (!isLogged()) { $strContent = str_replace("[LOGINMSG]", "<a href='" . APPLICATION_URL . "/signin'>click here</a> to Login", $strContent); } else { $strContent = str_replace("[LOGINMSG]", "", $strContent); } $this->view->pageContent = $strContent; $this->view->pageTitle = $staticArr[0]['page_title']; $this->view->page_id = $staticArr[0]['page_id']; if ($staticArr[0]['page_id'] == '12' || $staticArr[0]['page_id'] == '63') { $myform = new Form_Contact(); $this->view->myform = $myform; } if ($staticArr[0]['page_id'] == '80') { $myform = new Form_Ocontact(); $this->view->myform = $myform; } //location keywords for destination page if ($staticArr[0]['page_id'] == '25') { $this->view->countryArr = $countryArr = $db->runQuery("select country_name from " . PROPERTY . " \n inner join " . COUNTRIES . " on " . COUNTRIES . ".country_id = " . PROPERTY . ".country_id\n where status = '3'\n group by country_name\n "); $this->view->statesArr = $statesArr = $db->runQuery("select country_name, state_name from " . PROPERTY . "\n inner join " . COUNTRIES . " on " . COUNTRIES . ".country_id = " . PROPERTY . ".country_id\n inner join " . STATE . " on " . STATE . ".state_id = " . PROPERTY . ".state_id\n where status = '3'\n group by state_name\n "); $this->view->citiesArr = $citiesArr = $db->runQuery("select country_name, state_name, city_name from " . PROPERTY . " \n inner join " . COUNTRIES . " on " . COUNTRIES . ".country_id = " . PROPERTY . ".country_id\n inner join " . STATE . " on " . STATE . ".state_id = " . PROPERTY . ".state_id\n inner join " . CITIES . " on " . CITIES . ".city_id = " . PROPERTY . ".city_id\n where status = '3'\n group by city_name\n "); $this->view->subareasArr = $subareasArr = $db->runQuery("select country_name, state_name, city_name,sub_area_name from " . PROPERTY . " \n inner join " . COUNTRIES . " on " . COUNTRIES . ".country_id = " . PROPERTY . ".country_id\n inner join " . STATE . " on " . STATE . ".state_id = " . PROPERTY . ".state_id\n inner join " . CITIES . " on " . CITIES . ".city_id = " . PROPERTY . ".city_id\n inner join " . SUB_AREA . " on " . SUB_AREA . ".sub_area_id = " . PROPERTY . ".sub_area_id\n where status = '3'\n group by sub_area_name\n "); $this->view->localareasArr = $localareasArr = $db->runQuery("select country_name, state_name, city_name,sub_area_name, local_area_name from " . PROPERTY . " \n inner join " . COUNTRIES . " on " . COUNTRIES . ".country_id = " . PROPERTY . ".country_id\n inner join " . STATE . " on " . STATE . ".state_id = " . PROPERTY . ".state_id\n inner join " . CITIES . " on " . CITIES . ".city_id = " . PROPERTY . ".city_id\n inner join " . SUB_AREA . " on " . SUB_AREA . ".sub_area_id = " . PROPERTY . ".sub_area_id\n inner join " . LOCAL_AREA . " on " . LOCAL_AREA . ".local_area_id = " . PROPERTY . ".local_area_id\n where status = '3'\n group by local_area_name\n "); } $varsuccess = 0; # the response from reCAPTCHA $resp = null; # the error code from reCAPTCHA, if any $error = null; if ($this->getRequest()->isPost()) { $request = $this->getRequest(); $dataForm = $myform->getValues(); //prd($dataForm); if ($myform->isValid($request->getPost()) && !empty($_POST["recaptcha_response_field"])) { $dataForm = $myform->getValues(); $resp = recaptcha_check_answer(CAPTCHA_PRIVATE_KEY, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]); if ($resp->is_valid) { $myObj = new Users(); if ($staticArr[0]['page_id'] == '80') { $Result = $myObj->ownercontactus($dataForm); } else { $Result = $myObj->contactus($dataForm); } $mySession->sucessMsg = "Thank you, You will soon be contacted"; $varsuccess = 1; } else { $mySession->errorMsg = $error = $resp->error; } } else { $dataForm = $myform->getValues(); $mySession->errorMsg = "Human Verification Error"; } } $this->view->error = $error; $this->view->myform = $myform; $this->view->varsuccess = $varsuccess; __bookSessionClear(); }
public function afterpayAction() { global $mySession; $db = new Db(); $return = $this->getRequest()->getParam("Return"); /* prd($_GET); */ if ($return == '1') { $spclOffer = implode(",", $mySession->spclOfferId); //fetching the compulsory extras /* $extrasArr = $db->runQuery("select eid from ".EXTRAS." where property_id = '".$mySession->pptyId."' and etype = '1' "); $extras = implode(",",$mySession->extrasId); */ foreach ($extrasArr as $val) { $extras[] = $val['edi']; } $bookingId = $mySession->bookingId; $dataUpdate = array(); $dataUpdate['payment_status'] = 'success'; $db->modify(BOOKING, $dataUpdate, " booking_id = " . $bookingId); // saving in Booking table //$dataForm['property_id'] = $mySession->pptyId; //prd($mySession->bookingUser); //================ code for saving data in booking table========================// //================ code to save data in calendar table==========================// //saving in payment list //pr($mySession->pptyId); //prd($mySession->bookingUser); $dataForm = array(); $dataForm['user_id'] = $mySession->bookingUser['user_id']; $dataForm['property_id'] = $mySession->pptyId; //$dataForm['property_id'] = $mySession->bookingUser['property_id']; //$dataForm['trans_id'] = $_REQUEST['txn_id']; $dataForm['amount_paid'] = $mySession->finalAmt; $dataForm['booking_id'] = $bookingId; $dataForm['payment_date'] = date('Y-m-d'); $db->save(PAYMENT, $dataForm); //saving in the booking extra table foreach ($mySession->extrasId as $values) { $extrasArr = $db->runQuery("select ename,eprice*exchange_rate as eprice,etype,stay_type from " . EXTRAS . " \n\t\t\t inner join " . PROPERTY . " on " . PROPERTY . ".id = " . EXTRAS . ".property_id\n\t\t\t\t\t\t\t\t\t\tinner join " . CURRENCY . " on " . CURRENCY . ".currency_code = " . PROPERTY . ".currency_code\n\t\t\t\t\t\t\t\t\t\twhere eid = '" . $values . "'\t "); $dataForm = array(); $dataForm['booking_id'] = $bookingId; $dataForm['option_name'] = $extrasArr[0]['ename']; $dataForm['option_price'] = $extrasArr[0]['eprice']; $dataForm['option_status'] = $extrasArr[0]['etype']; $dataForm['stay_type'] = $extrasArr[0]['stay_type']; $db->save(BOOKING_EXTRA, $dataForm); } $extrasArr = $db->runQuery("select ename,eprice*exchange_rate as eprice,etype,stay_type from " . EXTRAS . " \n\t\t\t\t\t\t\t\t\tinner join " . PROPERTY . " on " . PROPERTY . ".id = " . EXTRAS . ".property_id\n \t\t\t\t\t\t\t\t inner join " . CURRENCY . " on " . CURRENCY . ".currency_code = " . PROPERTY . ".currency_code\n\t\t\t\t\t\t\t\t\twhere property_id = '" . $mySession->pptyId . "' and etype = '1' "); //saving for the compulosry extras table foreach ($extrasArr as $values) { $dataForm = array(); $dataForm['booking_id'] = $bookingId; $dataForm['option_name'] = $values['ename']; $dataForm['option_price'] = $values['eprice']; $dataForm['option_status'] = $values['etype']; $dataForm['stay_type'] = $values['stay_type']; $db->save(BOOKING_EXTRA, $dataForm); } $mySession->sucessMsg = "Thank you.. you have sucessfully booked the property."; //$pptyno = $db->runQuery("select propertycode from ".PROPERTY." where id = '".$mySession->pptyId."' "); $pptyno = $db->runQuery("select propertycode from " . PROPERTY . " where id = '" . $mySession->bookingUser['property_id'] . "' "); $fullName = $mySession->LoggedUserName; $Url = '<a href="' . APPLICATION_URL . '">' . APPLICATION_URL . '</a>'; $templateData = $db->runQuery("select * from " . EMAIL_TEMPLATES . " where template_id='7'"); $messageText = $templateData[0]['email_body']; $subject = $templateData[0]['email_subject']; $messageText = str_replace("[NAME]", $fullName, $messageText); $messageText = str_replace("[SITENAME]", SITE_NAME, $messageText); $messageText = str_replace("[SITEURL]", APPLICATION_URL, $messageText); $messageText = str_replace("[PROPERTYNO]", $pptyno[0]['propertycode'], $messageText); SendEmail($dataForm['email_address'], $subject, $messageText); //===== code for adding popular properties //two cases //1. when booked property is already in the list of slides property //2. when booked property is not in the list of slides property $identifyArr = $db->runQuery("select * from " . SLIDES_PROPERTY . " where lppty_property_id = '" . $mySession->pptyId . "' and lppty_type = '1' "); if ($identifyArr != "" and count($identifyArr) > 0) { $db->delete(SLIDES_PROPERTY, 'lppty_id= "' . $identifyArr[0]['lppty_id'] . '" '); $updateData = array(); $updateData['lppty_order'] = new Zend_Db_Expr('lppty_order-1'); $updateData['lppty_status'] = '1'; $db->modify(SLIDES_PROPERTY, $updateData, "lppty_type='1' and lppty_order > '" . $identifyArr[0]['lppty_order'] . "' "); } else { $updateData = array(); $updateData['lppty_order'] = new Zend_Db_Expr('lppty_order+1'); $updateData['lppty_status'] = '1'; $db->modify(SLIDES_PROPERTY, $updateData, "lppty_type='1'"); $saveData = array(); $saveData['lppty_property_id'] = $mySession->pptyId; $saveData['lppty_type'] = '1'; $saveData['lppty_order'] = '1'; $db->save(SLIDES_PROPERTY, $saveData); } //--------------------------------------- $this->_redirect("contents/pages/slug/bookingsucess"); } else { $mySession->errorMsg = "We are sorry for the misconviniece <br />\n\t\t\t\t\t\t\t\t\t Error while booking property"; __bookSessionClear(); $this->_redirect(APPLICATION_URL); } }