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); $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; } $varsuccess = 0; if ($this->getRequest()->isPost()) { $request = $this->getRequest(); $dataForm = $myform->getValues(); if ($myform->isValid($request->getPost())) { $dataForm = $myform->getValues(); //prd($dataForm); if ($dataForm['captcha'] == $_SESSION['captcha']) { $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 = "Human Verification code is wrong"; } } } $this->view->myform = $myform; $this->view->varsuccess = $varsuccess; }
public function previewAction() { global $mySession; $db = new Db(); $varsuccess = '0'; $tab = $this->getRequest()->getParam("property"); $ppty_id = $this->getRequest()->getParam("ppty"); $this->view->ppty_id = $ppty_id; $propertyArr = $db->runQuery("select * from " . PROPERTY . " \n\t\t\t\t\t\t\t\t\t inner join " . COUNTRIES . " on " . COUNTRIES . ".country_id = " . PROPERTY . ".country_id\n\t\t\t\t\t\t\t\t\t inner join " . PROPERTY_TYPE . " on " . PROPERTY . ".property_type = " . PROPERTY_TYPE . ".ptyle_id\n\t\t\t\t\t\t\t\t\t left join " . STATE . " on " . STATE . ".state_id = " . PROPERTY . ".state_id\n \t\t\t\t\t\t\t left join " . CITIES . " on " . CITIES . ".city_id = " . PROPERTY . ".city_id\n\t\t\t\t\t\t\t\t\t left join " . SUB_AREA . " on " . SUB_AREA . ".sub_area_id = " . PROPERTY . ".sub_area_id\n\t\t\t\t\t\t\t\t\t left join " . LOCAL_AREA . " on " . LOCAL_AREA . ".local_area_id = " . PROPERTY . ".local_area_id\n\t\t\t\t\t\t\t\t\t left join " . GALLERY . " on " . GALLERY . ".property_id = " . PROPERTY . ".id \n\t\t\t\t\t\t\t\t\t where " . PROPERTY . ".id = '" . $ppty_id . "' "); //========== Fetching Meta Information ===========================// $metaArr = $db->runQuery("select meta_title, meta_keyword, meta_description from " . META_INFO . " where meta_id = 4"); $Title = str_replace('[PAGE_NAME]', $staticArr[0]['page_title'], $metaArr[0]['meta_title']); $Description = $metaArr[0]['meta_title']; $Description = str_replace('[BREADCRUMB]', $Breadcrumb, $Description); $Description = str_replace('[BED]', $propertyArr[0]['bedrooms'] > 1 ? $propertyArr[0]['bedrooms'] . ' beds' : $propertyArr[0]['bedrooms'] . ' bed', $Description); $Description = str_replace('[PROPERTY_TYPE]', $propertyArr[0]['ptyle_name'], $Description); $Description = str_replace('[PROPERTY_NO]', $propertyArr[0]['propertycode'], $Description); $this->view->headTitle($Title)->offsetUnset(0); $this->view->headMeta('description', $Description); //code to check tab switch ($tab) { case '': case 'overview': $this->view->tab = '1'; $this->view->property = "overview"; $this->view->ppty_tab1 = 'class="active"'; //AMENITIES $amenityData = $db->runQuery("select * from " . AMENITY . " as a inner join " . AMENITY_ANS . " as aa on a.amenity_id = aa.amenity_id where aa.property_id = '" . $ppty_id . "' and aa.amenity_value ='1' and a.amenity_status = '1' "); $this->view->amenityData = $amenityData; break; case 'specification': $this->view->tab = '2'; $this->view->property = "specification"; $this->view->ppty_tab2 = 'class="active"'; $specArr = $db->runQuery("select * from " . SPECIFICATION . " as s inner join " . PROPERTY_SPEC_CAT . " as psc on s.cat_id = psc.cat_id \n\t\t\t\t\t\t\t\t\t where psc.cat_status = '1' \n\t\t\t\t\t\t\t\t\t and s.status = '1' order by psc.cat_id, s.spec_order asc\n\t\t\t\t\t\t\t\t\t "); $category_temp = ""; $i = 0; $t = 0; $finalArr[0]['category'][0] = ""; $cat_counter = 0; $bathroom_counter = 0; $xcounter = 0; $max = 0; foreach ($specArr as $key => $value) { if ($finalArr[$cat_counter]['category'] != $value['cat_name']) { if ($i > 0) { $cat_counter++; } $finalArr[$cat_counter]['category'] = $value['cat_name']; $t = 0; } $selectOptionArr = $db->runQuery("select * from " . SPEC_CHILD . "\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t inner join " . SPEC_ANS . " on " . SPEC_ANS . ".answer = " . SPEC_CHILD . ".cid\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t where " . SPEC_ANS . ".spec_id = '" . $value['spec_id'] . "' and " . SPEC_ANS . ".property_id = '" . $ppty_id . "' "); if ($value['spec_id'] == '22' || $value['spec_id'] == '23' || $value['spec_id'] == '24') { foreach ($selectOptionArr as $key1 => $value1) { $array1 = explode('|||', $value1['answer']); $max = count($array1) > $max ? count($array1) : $max; $x = 0; foreach ($array1 as $keybath => $bath) { /* echo "select ".SPEC_CHILD.".option from ".SPEC_CHILD." where cid = '".$bath."' "; exit; */ $bathArr = $db->runQuery("select " . SPEC_CHILD . ".option from " . SPEC_CHILD . " where cid = '" . $bath . "' "); //pr($bathArr); /* if(count($bathArr) == 0) $bathroom[$keybath][] = ""; */ foreach ($bathArr as $ckey => $calue) { if ($value['spec_id'] == '24') { //echo $xcounter; $bathroom[$xcounter][] = $calue['option']; } else { $bathroom[$keybath][] = $calue['option']; } } $x++; } foreach ($array1 as $keybath => $bath) { $finalArr[$cat_counter]['ques'][$keybath] = $value['spec_display'] . " " . ($keybath + 1); } $finalArr[$cat_counter]['answer'] = $bathroom; $j++; if ($value['spec_id'] == '24') { $xcounter++; } } $bathroom_counter++; } else { if ($max != 0) { $t = $t + $max; } $max = 0; if ($value['spec_type'] == '2' || $value['spec_type'] == '3') { $selectOptionArr = $db->runQuery("select * from " . SPEC_ANS . " where " . SPEC_ANS . ".spec_id = '" . $value['spec_id'] . "' and " . SPEC_ANS . ".property_id = '" . $ppty_id . "' "); /* prd($selectOptionArr); */ if ($selectOptionArr[0]['answer'] != "") { $j = 0; $finalArr[$cat_counter]['ques'][$t] = $value['spec_display']; $finalArr[$cat_counter]['ticklist'][$t] = '0'; $finalArr[$cat_counter]['answer'][$t][0] = $selectOptionArr[0]['answer']; $selectOptionArr = array(); } else { $t--; } } elseif ($value['preview_display'] == '1' || count($selectOptionArr) > 0) { $finalArr[$cat_counter]['ques'][$t] = $value['spec_display']; if ($value['spec_type'] == '4') { $finalArr[$cat_counter]['ticklist'][$t] = '1'; } else { $finalArr[$cat_counter]['ticklist'][$t] = '0'; } } else { $t--; } $j = 0; if (count($selectOptionArr) > 0) { foreach ($selectOptionArr as $key1 => $value1) { $finalArr[$cat_counter]['answer'][$t][$j] = $value1['option']; $j++; } } $t++; } $i++; } /* prd($finalArr); */ /* $specArr = $db->runQuery("select * from ".SPECIFICATION." inner join ".SPEC_CHILD." on ".SPEC_CHILD.".spec_id = ".SPECIFICATION.".spec_id inner join ".SPEC_ANS." on ".SPEC_ANS.".answer = ".SPEC_CHILD.".cid where ".SPEC_ANS.".property_id = ".$ppty_id." "); */ $this->view->specArr = $finalArr; break; case 'location': $this->view->tab = '3'; $this->view->property = "location"; $this->view->ppty_tab3 = 'class="active"'; break; case 'availability': $this->view->tab = '4'; $this->view->property = "availability"; $this->view->cal_default = $propertyArr[0]['cal_default']; $this->view->ppty_tab4 = 'class="active"'; $calArr = $db->runQuery("select * from " . CAL_AVAIL . " where property_id = '" . $ppty_id . "' "); $this->view->calArr = $calArr; $next = $this->getRequest()->getParam("cal"); if ($next != "") { $this->view->nexts = $next; } else { $this->view->nexts = 0; } break; case 'rental': $this->view->tab = '5'; $this->view->property = "rental"; $this->view->ppty_tab5 = 'class="active"'; $option_extra = $db->runQuery("select ename, (select exchange_rate from " . CURRENCY . " where " . CURRENCY . ".currency_code = (select currency_code from " . PROPERTY . " where id = '" . $ppty_id . "' ))*eprice as eprice,etype,stay_type from " . EXTRAS . " where property_id = '" . $ppty_id . "' "); $this->view->option_extra = $option_extra; $calArr = $db->runQuery("select (select exchange_rate from " . CURRENCY . " where " . CURRENCY . ".currency_code = (select currency_code from " . PROPERTY . " where id = '" . $ppty_id . "') )*prate as prate,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t nights,date_to,date_from from " . CAL_RATE . " \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t where property_id = " . $ppty_id . " order by date_from asc "); $this->view->calData = $calArr; $spclArr = $db->runQuery("select *, " . SPCL_OFFER_TYPES . ".min_nights as MIN_NIGHTS from " . SPCL_OFFERS . " \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t inner join " . SPCL_OFFER_TYPES . " on " . SPCL_OFFERS . ".offer_id = " . SPCL_OFFER_TYPES . ".id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t where " . SPCL_OFFERS . ".property_id = '" . $ppty_id . "' \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t and " . SPCL_OFFERS . ".activate = '1' and " . SPCL_OFFERS . ".book_by >= curdate() "); $this->view->spclData = $spclArr; break; case 'gallery': $this->view->tab = '6'; $this->view->property = "gallery"; $this->view->ppty_tab6 = 'class="active"'; $galleryArr = $db->runQuery("select * from " . GALLERY . " where property_id = " . $ppty_id); $this->view->galleryArr = $galleryArr; break; case 'reviews': $this->view->tab = '7'; $this->view->property = "review"; $this->view->ppty_tab7 = 'class="active"'; $reviewArr = $db->runQuery("select * from " . OWNER_REVIEW . " as r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tinner join " . PROPERTY . " as p on p.id = r.property_id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tinner join " . USERS . " as u on u.user_id = p.user_id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\twhere r.property_id = '" . $ppty_id . "' and r.review_status = '1' order by r.review_id desc "); //prd($reviewArr); $i = 0; foreach ($reviewArr as $val) { if ($val['parent_id'] == 0) { $childArr = $db->runQuery("select * from " . OWNER_REVIEW . " where parent_id = '" . $val['review_id'] . "' "); $reviewData[$i]['review_id'] = $val['review_id']; $reviewData[$i]['uType'] = $val['uType']; $reviewData[$i]['guest_name'] = $val['guest_name']; $reviewData[$i]['owner_image'] = $val['guest_image']; $reviewData[$i]['headline'] = $val['headline']; $reviewData[$i]['review'] = $val['review']; $reviewData[$i]['comment'] = $val['comment']; $reviewData[$i]['location'] = $val['location']; $reviewData[$i]['image'] = $val['image']; $reviewData[$i]['review_date'] = $val['review_date']; $reviewData[$i]['check_in'] = $val['check_in']; $reviewData[$i]['rating'] = $val['rating']; $k = 0; foreach ($childArr as $val1) { $reviewData[$i]['child'][$k]['guest_name'] = $val1['guest_name']; $reviewData[$i]['child'][$k]['owner_image'] = $val1['guest_image']; $reviewData[$i]['child'][$k]['comment'] = $val1['comment']; $reviewData[$i]['child'][$k]['review_date'] = $val1['review_date']; $k++; } } $i++; } //prd($reviewData); //code for finding that the owner has the same property $this->view->reviewArr = $reviewData; /** review form dissplay code ends * */ break; case 'question': $this->view->tab = '8'; $this->view->property = "question"; $this->view->ppty_tab8 = 'class="active"'; //contact us $myform = new Form_Ocontact($ppty_id); $this->view->myform = $myform; break; } //rate query /* echo "select case when date_from <= CURDATE() and date_to >= CURDATE() then prate as RATE,nights from ".CAL_RATE." when date_from <= CURDATE() then min(prate) as RATE,nights from ".CAL_RATE." else prate as RATE, nights from ".CAL_RATE." end where property_id = '".$ppty_id."' "; exit; */ /* $rateArr = $db->runQuery(" SELECT * FROM ( select prate as RATE,nights,id from ".CAL_RATE." where property_id = '".$ppty_id."' and date_from <= CURDATE() and date_to >= CURDATE() union select min(prate) as RATE,nights,id from ".CAL_RATE." where property_id = '".$ppty_id."' ) AS a1 WHERE a1.RATE IS NOT NULL group by a1.id"); */ $rateArr = $db->runQuery("select round(prate*" . CURRENCY . ".exchange_rate) as RATE,nights,prate," . PROPERTY . ".id from " . CAL_RATE . " \n\t\t\t\t\t\t\t\t inner join " . PROPERTY . " on " . PROPERTY . ".id = " . CAL_RATE . ".property_id\n\t\t\t\t\t\t\t\t inner join " . CURRENCY . " on " . PROPERTY . ".currency_code = " . CURRENCY . ".currency_code\n\t\t where " . CAL_RATE . ".property_id = '" . $ppty_id . "' and prate = (select min(prate) from " . CAL_RATE . " where property_id = '" . $ppty_id . "' \n\t\t\t\t\t\t\t\t ) order by prate asc\n\t\t\t\t\t\t\t\t "); $tmp = $rateArr[0]['RATE']; /* $actcurrArr = $db->runQuery("select exchange_rate*".($tmp[0] != "" ? $tmp[0]:0)." as mul from ".CURRENCY." inner join ".PROPERTY." on ".CURRENCY.".currency_code = ".PROPERTY.".currency_code where ".PROPERTY.".id = '".$ppty_id."' "); */ /* $tmp[0] = $actcurrArr[0]['mul']; */ $this->view->prate = $tmp != "" ? $tmp * $rateArr[0]['nights'] : "Unknown"; $this->view->nights = $rateArr[0]['nights'] != "" ? $rateArr[0]['nights'] : ""; //cal Query /* gadd $calAvailArr = $db->runQuery("select * from ".CAL_AVAIL." inner join ".PROPERTY." on ".CAL_AVAIL.".property_id = ".PROPERTY.".id where ".CAL_AVAIL.".property_id = '".$ppty_id."' "); */ $this->view->propertyData = $propertyArr; // property images $galleryData = $db->runQuery("select * from " . GALLERY . " where property_id = '" . $ppty_id . "' "); $this->view->galleryData = $galleryData; if ($this->getRequest()->isPost() && !isset($_REQUEST['review'])) { $myform = new Form_Ocontact($ppty_id); $request = $this->getRequest(); if ($myform->isValid($request->getPost())) { $dataForm = $myform->getValues(); $myObj = new Users(); $Result = $myObj->ownercontactus($dataForm); $mySession->sucessMsg = "Thank you, You will soon be contacted"; $varsuccess = 1; } else { $mySession->errorMsg = "Enter Proper details first"; } } $this->view->varsuccess = $varsuccess; }
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 searchdetailAction() { global $mySession; $db = new Db(); $varsuccess = '0'; $tab = $this->getRequest()->getParam("tab"); $country_name = $this->getRequest()->getParam("country"); $state_name = $this->getRequest()->getParam("state"); $city_name = $this->getRequest()->getParam("city"); $sub_area_name = $this->getRequest()->getParam("sub_area"); $local_area_name = $this->getRequest()->getParam("local_area"); $property_code = $this->getRequest()->getParam("property_code"); $property_type = $this->getRequest()->getParam("property_type"); $this->view->Datefrom = $datefrom = $this->getRequest()->getParam("datefrom"); $this->view->dateto = $dateto = $this->getRequest()->getParam("dateto"); $Breadcrumb = $location_condition = ''; if ($local_area_name != '') { $location_condition = " and " . SUB_AREA . ".sub_area_name = '" . strtolower($sub_area_name) . "' and " . LOCAL_AREA . ".local_area_name = '" . strtolower($local_area_name) . "' "; } elseif ($sub_area_name != '') { $location_condition = " and " . SUB_AREA . ".sub_area_name = '" . strtolower($sub_area_name) . "' "; } $propertyArr = $db->runQuery("select *, trim(trailing '.' from trim(trailing 0 from " . PROPERTY . ".bathrooms)) as bathrooms," . PROPERTY . ".id as pid from " . PROPERTY . " \n\t\t\t\t\t\t\t\t\t inner join " . COUNTRIES . " on " . COUNTRIES . ".country_id = " . PROPERTY . ".country_id\n\t\t\t\t\t\t\t\t\t inner join " . PROPERTY_TYPE . " on " . PROPERTY . ".property_type = " . PROPERTY_TYPE . ".ptyle_id\n\t\t\t\t\t\t\t\t\t left join " . STATE . " on " . STATE . ".state_id = " . PROPERTY . ".state_id\n left join " . CITIES . " on " . CITIES . ".city_id = " . PROPERTY . ".city_id\n\t\t\t\t\t\t\t\t\t left join " . SUB_AREA . " on " . SUB_AREA . ".sub_area_id = " . PROPERTY . ".sub_area_id\n\t\t\t\t\t\t\t\t\t left join " . LOCAL_AREA . " on " . LOCAL_AREA . ".local_area_id = " . PROPERTY . ".local_area_id\n\t\t\t\t\t\t\t\t\t left join " . GALLERY . " on " . GALLERY . ".property_id = " . PROPERTY . ".id \n\t\t\t\t\t\t\t\t\t where lower(" . COUNTRIES . ".country_name) = '" . strtolower($country_name) . "'\n\t\t\t\t\t\t\t\t\t and lower(" . STATE . ".state_name) = '" . strtolower($state_name) . "'\n\t\t\t\t\t\t\t\t\t and lower(" . CITIES . ".city_name) = '" . strtolower($city_name) . "'\n\t\t\t\t\t\t\t\t\t {$location_condition}\n\t\t\t\t\t\t\t\t\t and " . PROPERTY . ".propertycode = '" . $property_code . "'\n\t\t\t\t\t\t\t\t\t "); //prd($propertyArr); $Breadcrumb .= !empty($propertyArr[0]['country_name']) ? $propertyArr[0]['country_name'] : ''; $Breadcrumb .= !empty($propertyArr[0]['state_name']) ? '>' . $propertyArr[0]['state_name'] : ''; $Breadcrumb .= !empty($propertyArr[0]['city_name']) ? '>' . $propertyArr[0]['city_name'] : ''; $Breadcrumb .= !empty($propertyArr[0]['sub_area_name']) ? '>' . $propertyArr[0]['sub_area_name'] : ''; $Breadcrumb .= !empty($propertyArr[0]['local_area_name']) ? '>' . $propertyArr[0]['local_area_name'] : ''; $breadcrumb_array = array("country_name" => $propertyArr[0]['country_name'], "state_name" => $propertyArr[0]['state_name'], "city_name" => $propertyArr[0]['city_name'], "sub_area_name" => $propertyArr[0]['sub_area_name'], "local_area_name" => $propertyArr[0]['local_area_name']); $this->view->breadCrumbArray = $breadcrumb_array; $this->view->headMeta($propertyArr[0]['meta_description'], 'description'); $this->view->headMeta($propertyArr[0]['meta_keywords'], 'keywords'); $Arr = explode('>', $Breadcrumb); krsort($Arr); $newHeadTtitleTest = implode(' - ', $Arr); $Breadcrumb = implode('>', $Arr); //========== Fetching Meta Information ===========================// $metaArr = $db->runQuery("select meta_title, meta_keyword, meta_description from " . META_INFO . " where meta_id = 4"); $Title = $metaArr[0]['meta_title']; $Title = str_replace('[BREADCRUMB]', $newHeadTtitleTest, $Title); $Title = str_replace('[BED]', $propertyArr[0]['bedrooms'] > 1 ? $propertyArr[0]['bedrooms'] . ' beds' : $propertyArr[0]['bedrooms'] . ' bed', $Title); $Title = str_replace('[PROPERTY_TYPE]', $propertyArr[0]['ptyle_name'], $Title); $Title = str_replace('[PROPERTY_NO]', $propertyArr[0]['propertycode'], $Title); $Description = $metaArr[0]['meta_description']; $Description = str_replace('[PROPERTY_TITLE]', $propertyArr[0]['property_title'], $Description); $Description = str_replace('[PROPERTY_DESCRIPTION]', $propertyArr[0]['brief_desc'], $Description); $this->view->headTitle($Title)->offsetUnset(0); $this->view->ppty_id = $ppty_id = $propertyArr[0]['pid']; //custom attributes $customAttributes = $db->runQuery("select * from " . ATTRIBUTE_ANS . " attr_ans left join " . ATTRIBUTE . " attr on attr.attribute_id = attr_ans.ans_attribute_id where attr_ans.ans_property_id = {$ppty_id} "); $this->view->customAttrib = $customAttributes; //AMENITIES $amenityData = $db->runQuery("select * from " . AMENITY . " as a inner join " . AMENITY_ANS . " as aa on a.amenity_id = aa.amenity_id where aa.property_id = '" . $ppty_id . "' and aa.amenity_value ='1' and a.amenity_status = '1' "); $this->view->amenityData = $amenityData; if (count($propertyArr) == 0) { $this->_redirect("error/error"); } $this->view->ppty_id = $ppty_id; //calendar $this->view->property = "availability"; $this->view->cal_default = $propertyArr[0]['cal_default']; $calArr = $db->runQuery("select * from " . CAL_AVAIL . " where property_id = '" . $ppty_id . "' "); $this->view->calArr = $calArr; $next = $this->getRequest()->getParam("cal"); if ($next != "") { $this->view->nexts = $next; } else { $this->view->nexts = 0; } //gallery $galleryArr = $db->runQuery("select * from " . GALLERY . " where property_id = " . $ppty_id); $this->view->galleryArr = $galleryArr; $this->view->prate = ''; if ($datefrom != "") { $datefrom = date('Y-m-d', strtotime($datefrom)); $dateto = date('Y-m-d', strtotime($dateto)); $rateArr = $db->runQuery(" select *, \n coalesce (sum(\n case when " . CAL_RATE . ".date_from >= '" . $datefrom . "' and " . CAL_RATE . ".date_to <= '" . $dateto . "' \n then (abs( datediff( " . CAL_RATE . ".date_from, " . CAL_RATE . ".date_to ))+1) * ceil(prate*exchange_rate)\n when " . CAL_RATE . ".date_from <= '" . $datefrom . "' and " . CAL_RATE . ".date_to >= '" . $dateto . "'\n then (abs( datediff( '" . $datefrom . "', '" . $dateto . "' ))+1) * ceil(prate*exchange_rate)\n when " . CAL_RATE . ".date_from <= '" . $datefrom . "' and " . CAL_RATE . ".date_to >= '" . $datefrom . "' and " . CAL_RATE . ".date_to <= '" . $dateto . "' \n then (abs( datediff( '" . $datefrom . "', " . CAL_RATE . ".date_to ))+1) * ceil(prate*exchange_rate)\n when " . CAL_RATE . ".date_to >= '" . $dateto . "' and " . CAL_RATE . ".date_from >= '" . $datefrom . "' and " . CAL_RATE . ".date_from <= '" . $dateto . "'\n then (abs( datediff( " . CAL_RATE . ".date_from, '" . $dateto . "' ))+1) * ceil(prate*exchange_rate)\n end),(select ceil(min(prate)*exchange_rate)*" . (dateDiff($datefrom, $dateto) + 1) . " from " . CAL_RATE . " \n where " . CAL_RATE . ".property_id = '" . $ppty_id . "'))\n AS RATE from " . CAL_RATE . " \n inner join " . PROPERTY . " on " . PROPERTY . ".id = " . CAL_RATE . ".property_id\n inner join " . CURRENCY . " on " . PROPERTY . ".currency_code = " . CURRENCY . ".currency_code\n where property_id = '" . $ppty_id . "' group by " . CAL_RATE . ".property_id "); $this->view->nights = dateDiff($datefrom, $dateto) + 1; $this->view->prate = $rateArr[0]['RATE'] != "" ? $rateArr[0]['RATE'] : "Unknown"; // else: // // // $rateArr = $db->runQuery("select nights*ceil(prate*" . CURRENCY . ".exchange_rate) as RATE,nights,prate," . PROPERTY . ".id from " . CAL_RATE . " // inner join " . PROPERTY . " on " . PROPERTY . ".id = " . CAL_RATE . ".property_id // inner join " . CURRENCY . " on " . PROPERTY . ".currency_code = " . CURRENCY . ".currency_code // where " . CAL_RATE . ".property_id = '" . $ppty_id . "' and prate = (select min(prate) from " . CAL_RATE . " where property_id = '" . $ppty_id . "' and " . CAL_RATE . ".date_to >= curdate() // ) order by prate asc // "); // //echo "select prate*nights as RATE,nights,prate,id from ".CAL_RATE." where prate = (select min(prate) from ".CAL_RATE." where property_id = '".$ppty_id."' ) "; // $this->view->nights = $rateArr[0]['nights'] != "" ? $rateArr[0]['nights'] : ""; } $rateArr = $db->runQuery("select nights*ceil(prate*" . CURRENCY . ".exchange_rate) as RATE,nights,prate," . PROPERTY . ".id from " . CAL_RATE . " \n\t\t\t\t\t\t\t\t inner join " . PROPERTY . " on " . PROPERTY . ".id = " . CAL_RATE . ".property_id\n\t\t\t\t\t\t\t\t inner join " . CURRENCY . " on " . PROPERTY . ".currency_code = " . CURRENCY . ".currency_code\n where " . CAL_RATE . ".property_id = '" . $ppty_id . "' and prate = (select min(prate) from " . CAL_RATE . " where property_id = '" . $ppty_id . "' and " . CAL_RATE . ".date_to >= curdate()\n\t\t\t\t\t\t\t\t ) order by prate asc\n\t\t\t\t\t\t\t\t "); //echo "select prate*nights as RATE,nights,prate,id from ".CAL_RATE." where prate = (select min(prate) from ".CAL_RATE." where property_id = '".$ppty_id."' ) "; $this->view->defaultRate = $rateArr[0]['RATE'] != "" ? $rateArr[0]['RATE'] : "Unknown"; $this->view->nights = $rateArr[0]['nights'] != "" ? $rateArr[0]['nights'] : ""; //cal Query $this->view->propertyData = $propertyArr; // property images $galleryData = $db->runQuery("select * from " . GALLERY . " where property_id = '" . $ppty_id . "' "); $this->view->galleryData = $galleryData; //contact us $myform = new Form_Ocontact($ppty_id); $this->view->myform = $myform; # the response from reCAPTCHA $resp = null; # the error code from reCAPTCHA, if any $error = null; if ($this->getRequest()->isPost() && !empty($_POST["recaptcha_response_field"])) { $request = $this->getRequest(); $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(); $Result = $myObj->ownercontactus($dataForm); $mySession->sucessMsg = "Thank you, You will soon be contacted"; $varsuccess = 1; } else { $mySession->errorMsg = "Please Enter Correct Human Verification Code"; } } $this->view->error = $error; $this->view->varsuccess = $varsuccess; }
public function searchdetailAction() { global $mySession; $db = new Db(); $varsuccess = '0'; $tab = $this->getRequest()->getParam("property"); $ppty_id = $this->getRequest()->getParam("ppty"); $this->view->ppty_id = $ppty_id; $this->view->Datefrom = $datefrom = $this->getRequest()->getParam("datefrom"); $this->view->dateto = $dateto = $this->getRequest()->getParam("dateto"); $propertyArr = $db->runQuery("select * from " . PROPERTY . " \n\t\t\t\t\t\t\t\t\t inner join " . COUNTRIES . " on " . COUNTRIES . ".country_id = " . PROPERTY . ".country_id\n\t\t\t\t\t\t\t\t\t inner join " . PROPERTY_TYPE . " on " . PROPERTY . ".property_type = " . PROPERTY_TYPE . ".ptyle_id\n\t\t\t\t\t\t\t\t\t left join " . STATE . " on " . STATE . ".country_id = " . COUNTRIES . ".country_id\n \t\t\t\t\t\t\t left join " . CITIES . " on " . CITIES . ".state_id = " . STATE . ".state_id\n\t\t\t\t\t\t\t\t\t left join " . SUB_AREA . " on " . SUB_AREA . ".city_id = " . CITIES . ".city_id\n\t\t\t\t\t\t\t\t\t left join " . LOCAL_AREA . " on " . LOCAL_AREA . ".sub_area_id = " . SUB_AREA . ".sub_area_id\n\t\t\t\t\t\t\t\t\t left join " . GALLERY . " on " . GALLERY . ".property_id = " . PROPERTY . ".id \n\t\t\t\t\t\t\t\t\t where " . PROPERTY . ".id = '" . $ppty_id . "'"); switch ($tab) { case '': case 'overview': $this->view->tab = '1'; $this->view->property = "overview"; $this->view->ppty_tab1 = 'class="active"'; //AMENITIES $amenityData = $db->runQuery("select * from " . AMENITY . " as a inner join " . AMENITY_ANS . " as aa on a.amenity_id = aa.amenity_id where aa.property_id = '" . $ppty_id . "' and aa.amenity_value ='1' and a.amenity_status = '1' "); $this->view->amenityData = $amenityData; break; case 'specification': $this->view->tab = '2'; $this->view->property = "specification"; $this->view->ppty_tab2 = 'class="active"'; $specArr = $db->runQuery("select * from " . SPECIFICATION . " \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t inner join " . SPEC_CHILD . " on " . SPEC_CHILD . ".spec_id = " . SPECIFICATION . ".spec_id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t inner join " . SPEC_ANS . " on " . SPEC_ANS . ".answer = " . SPEC_CHILD . ".cid\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t where " . SPEC_ANS . ".property_id = " . $ppty_id . "\n\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t"); $specArr = $db->runQuery("select * from " . SPECIFICATION . " as s inner join " . PROPERTY_SPEC_CAT . " as psc on s.cat_id = psc.cat_id \n\t\t\t\t\t\t\t\t\t where psc.cat_status = '1' \n\t\t\t\t\t\t\t\t\t and s.status = '1' order by psc.cat_id, s.spec_order asc\n\t\t\t\t\t\t\t\t\t "); $category_temp = ""; $i = 0; $t = 0; $finalArr[0]['category'][0] = ""; $cat_counter = 0; $bathroom_counter = 0; $xcounter = 0; $max = 0; foreach ($specArr as $key => $value) { if ($finalArr[$cat_counter]['category'] != $value['cat_name']) { if ($i > 0) { $cat_counter++; } $finalArr[$cat_counter]['category'] = $value['cat_name']; $t = 0; } $selectOptionArr = $db->runQuery("select * from " . SPEC_CHILD . "\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t inner join " . SPEC_ANS . " on " . SPEC_ANS . ".answer = " . SPEC_CHILD . ".cid\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t where " . SPEC_ANS . ".spec_id = '" . $value['spec_id'] . "' and " . SPEC_ANS . ".property_id = '" . $ppty_id . "' "); if ($value['spec_id'] == '22' || $value['spec_id'] == '23' || $value['spec_id'] == '24') { foreach ($selectOptionArr as $key1 => $value1) { $array1 = explode('|||', $value1['answer']); $max = count($array1) > $max ? count($array1) : $max; $x = 0; foreach ($array1 as $keybath => $bath) { /* echo "select ".SPEC_CHILD.".option from ".SPEC_CHILD." where cid = '".$bath."' "; exit;*/ $bathArr = $db->runQuery("select " . SPEC_CHILD . ".option from " . SPEC_CHILD . " where cid = '" . $bath . "' "); //pr($bathArr); /*if(count($bathArr) == 0) $bathroom[$keybath][] = ""; */ foreach ($bathArr as $ckey => $calue) { if ($value['spec_id'] == '24') { //echo $xcounter; $bathroom[$xcounter][] = $calue['option']; } else { $bathroom[$keybath][] = $calue['option']; } } $x++; } foreach ($array1 as $keybath => $bath) { $finalArr[$cat_counter]['ques'][$keybath] = $value['spec_display'] . " " . ($keybath + 1); } $finalArr[$cat_counter]['answer'] = $bathroom; $j++; if ($value['spec_id'] == '24') { $xcounter++; } } $bathroom_counter++; } else { if ($max != 0) { $t = $t + $max; } $max = 0; if ($value['spec_type'] == '2' || $value['spec_type'] == '3') { $selectOptionArr = $db->runQuery("select * from " . SPEC_ANS . " where " . SPEC_ANS . ".spec_id = '" . $value['spec_id'] . "' and " . SPEC_ANS . ".property_id = '" . $ppty_id . "' "); /* prd($selectOptionArr);*/ if ($selectOptionArr[0]['answer'] != "") { $j = 0; $finalArr[$cat_counter]['ques'][$t] = $value['spec_display']; $finalArr[$cat_counter]['ticklist'][$t] = '0'; $finalArr[$cat_counter]['answer'][$t][0] = $selectOptionArr[0]['answer']; $selectOptionArr = array(); } else { $t--; } } elseif ($value['preview_display'] == '1' || count($selectOptionArr) > 0) { $finalArr[$cat_counter]['ques'][$t] = $value['spec_display']; if ($value['spec_type'] == '4') { $finalArr[$cat_counter]['ticklist'][$t] = '1'; } else { $finalArr[$cat_counter]['ticklist'][$t] = '0'; } } else { $t--; } $j = 0; if (count($selectOptionArr) > 0) { foreach ($selectOptionArr as $key1 => $value1) { $finalArr[$cat_counter]['answer'][$t][$j] = $value1['option']; $j++; } } $t++; } $i++; } /*prd($finalArr);*/ /*$specArr = $db->runQuery("select * from ".SPECIFICATION." inner join ".SPEC_CHILD." on ".SPEC_CHILD.".spec_id = ".SPECIFICATION.".spec_id inner join ".SPEC_ANS." on ".SPEC_ANS.".answer = ".SPEC_CHILD.".cid where ".SPEC_ANS.".property_id = ".$ppty_id." ");*/ $this->view->specArr = $finalArr; break; case 'location': $this->view->tab = '3'; $this->view->property = "location"; $this->view->ppty_tab3 = 'class="active"'; break; case 'availability': $this->view->tab = '4'; $this->view->property = "availability"; $this->view->cal_default = $propertyArr[0]['cal_default']; $this->view->ppty_tab4 = 'class="active"'; $calArr = $db->runQuery("select * from " . CAL_AVAIL . " where property_id = '" . $ppty_id . "' "); $this->view->calArr = $calArr; $next = $this->getRequest()->getParam("cal"); if ($next != "") { $this->view->nexts = $next; } else { $this->view->nexts = 0; } break; case 'rental': $this->view->tab = '5'; $this->view->property = "rental"; $this->view->ppty_tab5 = 'class="active"'; $option_extra = $db->runQuery("select ename, (select exchange_rate from " . CURRENCY . " where " . CURRENCY . ".currency_code = (select currency_code from " . PROPERTY . " where id = '" . $ppty_id . "' ))*eprice as eprice,etype,stay_type from " . EXTRAS . " where property_id = '" . $ppty_id . "' "); $this->view->option_extra = $option_extra; $calArr = $db->runQuery("select (select exchange_rate from " . CURRENCY . " where " . CURRENCY . ".currency_code = (select currency_code from " . PROPERTY . " where id = '" . $ppty_id . "') )*prate as prate,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t nights,date_to,date_from from " . CAL_RATE . " \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t where property_id = " . $ppty_id . " order by date_from asc "); $this->view->calData = $calArr; $spclArr = $db->runQuery("select *, " . SPCL_OFFER_TYPES . ".min_nights as MIN_NIGHTS from " . SPCL_OFFERS . " \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t inner join " . SPCL_OFFER_TYPES . " on " . SPCL_OFFERS . ".offer_id = " . SPCL_OFFER_TYPES . ".id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t where " . SPCL_OFFERS . ".property_id = '" . $ppty_id . "' \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t and " . SPCL_OFFERS . ".activate = '1' and " . SPCL_OFFERS . ".book_by >= curdate() "); $this->view->spclData = $spclArr; break; case 'gallery': $this->view->tab = '6'; $this->view->property = "gallery"; $this->view->ppty_tab6 = 'class="active"'; $galleryArr = $db->runQuery("select * from " . GALLERY . " where property_id = " . $ppty_id); $this->view->galleryArr = $galleryArr; break; case 'reviews': $this->view->tab = '7'; $this->view->property = "review"; $this->view->ppty_tab7 = 'class="active"'; /*** review form display code **/ //if(!isset($mySession->reviewImage)) //$mySession->reviewImage = "no_owner_pic.jpg"; $reviewArr = $db->runQuery("select * from " . OWNER_REVIEW . " as r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tinner join " . PROPERTY . " as p on p.id = r.property_id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tinner join " . USERS . " as u on u.user_id = p.user_id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\twhere r.property_id = '" . $ppty_id . "' and r.review_status = '1' order by r.review_id desc "); //prd($reviewArr); $i = 0; foreach ($reviewArr as $val) { if ($val['parent_id'] == 0) { $childArr = $db->runQuery("select * from " . OWNER_REVIEW . " where parent_id = '" . $val['review_id'] . "' "); $reviewData[$i]['review_id'] = $val['review_id']; $reviewData[$i]['uType'] = $val['uType']; $reviewData[$i]['guest_name'] = $val['guest_name']; $reviewData[$i]['owner_image'] = $val['guest_image']; $reviewData[$i]['headline'] = $val['headline']; $reviewData[$i]['review'] = $val['review']; $reviewData[$i]['comment'] = $val['comment']; $reviewData[$i]['location'] = $val['location']; $reviewData[$i]['image'] = $val['image']; $reviewData[$i]['review_date'] = $val['review_date']; $reviewData[$i]['check_in'] = $val['check_in']; $reviewData[$i]['rating'] = $val['rating']; $k = 0; foreach ($childArr as $val1) { $reviewData[$i]['child'][$k]['guest_name'] = $val1['guest_name']; $reviewData[$i]['child'][$k]['owner_image'] = $val1['guest_image']; $reviewData[$i]['child'][$k]['comment'] = $val1['comment']; $reviewData[$i]['child'][$k]['review_date'] = $val1['review_date']; $k++; } } $i++; } //prd($reviewData); //code for finding that the owner has the same property $this->view->reviewArr = $reviewData; /** review form dissplay code ends **/ break; case 'question': $this->view->tab = '8'; $this->view->property = "question"; $this->view->ppty_tab8 = 'class="active"'; //contact us $myform = new Form_Ocontact(); $this->view->myform = $myform; break; } //rate query /*echo "select prate as RATE,nights from ".CAL_RATE." where property_id = '".$ppty_id."' and date_from <= CURDATE() and date_to >= CURDATE() union select min(prate) as RATE, nights from ".CAL_RATE." where property_id = '".$ppty_id."' and date_from <= CURDATE() union select min(prate) as RATE, nights from ".CAL_RATE." where property_id = '".$ppty_id."'"; exit;*/ if ($datefrom != "") { $datefrom = date('Y-m-d', strtotime($datefrom)); $dateto = date('Y-m-d', strtotime($dateto)); /* prd(" select coalesce (sum( case when ".CAL_RATE.".date_from >= '".$datefrom."' and ".CAL_RATE.".date_to <= '".$dateto."' then (abs( datediff( ".CAL_RATE.".date_from, ".CAL_RATE.".date_to ))+1) * prate when ".CAL_RATE.".date_from <= '".$datefrom."' and ".CAL_RATE.".date_to >= '".$dateto."' then (abs( datediff( '".$datefrom."', '".$dateto."' ))+1) * `prate` when ".CAL_RATE.".date_from <= '".$datefrom."' and ".CAL_RATE.".date_to >= '".$datefrom."' and ".CAL_RATE.".date_to <= '".$dateto."' then (abs( datediff( '".$datefrom."', ".CAL_RATE.".date_to ))+1) * `prate` when ".CAL_RATE.".date_to >= '".$dateto."' and ".CAL_RATE.".date_from >= '".$datefrom."' and ".CAL_RATE.".date_from <= '".$dateto."' then (abs( datediff( ".CAL_RATE.".date_from, '".$dateto."' ))+1) * `prate` end),(select min(prate) from ".CAL_RATE." where ".CAL_RATE.".property_id = '".$ppty_id."'))*exchange_rate AS RATE from ".CAL_RATE." inner join ".PROPERTY." on ".PROPERTY.".id = ".CAL_RATE.".property_id inner join ".CURRENCY." on ".PROPERTY.".currency_code = ".CURRENCY.".currency_code where property_id = '".$ppty_id."' group by ".CAL_RATE.".property_id ");*/ /*$rateArr = $db->runQuery(" select coalesce (sum( case when ".CAL_RATE.".date_from >= '".$datefrom."' and ".CAL_RATE.".date_to <= '".$dateto."' then (abs( datediff( ".CAL_RATE.".date_from, ".CAL_RATE.".date_to ))+1) * prate when ".CAL_RATE.".date_from <= '".$datefrom."' and ".CAL_RATE.".date_to >= '".$dateto."' then (abs( datediff( '".$datefrom."', '".$dateto."' ))+1) * `prate` when ".CAL_RATE.".date_from <= '".$datefrom."' and ".CAL_RATE.".date_to >= '".$datefrom."' and ".CAL_RATE.".date_to <= '".$dateto."' then (abs( datediff( '".$datefrom."', ".CAL_RATE.".date_to ))+1) * `prate` when ".CAL_RATE.".date_to >= '".$dateto."' and ".CAL_RATE.".date_from >= '".$datefrom."' and ".CAL_RATE.".date_from <= '".$dateto."' then (abs( datediff( ".CAL_RATE.".date_from, '".$dateto."' ))+1) * `prate` end),(select prate*".dateDiff($datefrom,$dateto)." from ".CAL_RATE." where ".CAL_RATE.".property_id = '".$ppty_id."' having prate = min(prate) ))*exchange_rate AS RATE from ".CAL_RATE." inner join ".PROPERTY." on ".PROPERTY.".id = ".CAL_RATE.".property_id inner join ".CURRENCY." on ".PROPERTY.".currency_code = ".CURRENCY.".currency_code where property_id = '".$ppty_id."' group by ".CAL_RATE.".property_id ");*/ /* prd(" select *, coalesce (sum( case when ".CAL_RATE.".date_from >= '".$datefrom."' and ".CAL_RATE.".date_to <= '".$dateto."' then (abs( datediff( ".CAL_RATE.".date_from, ".CAL_RATE.".date_to ))+1) * round(prate*exchange_rate) when ".CAL_RATE.".date_from <= '".$datefrom."' and ".CAL_RATE.".date_to >= '".$dateto."' then (abs( datediff( '".$datefrom."', '".$dateto."' ))+1) * round(prate*exchange_rate) when ".CAL_RATE.".date_from <= '".$datefrom."' and ".CAL_RATE.".date_to >= '".$datefrom."' and ".CAL_RATE.".date_to <= '".$dateto."' then (abs( datediff( '".$datefrom."', ".CAL_RATE.".date_to ))+1) * round(prate*exchange_rate) when ".CAL_RATE.".date_to >= '".$dateto."' and ".CAL_RATE.".date_from >= '".$datefrom."' and ".CAL_RATE.".date_from <= '".$dateto."' then (abs( datediff( ".CAL_RATE.".date_from, '".$dateto."' ))+1) * round(prate*exchange_rate) end),(select round(min(prate)*exchange_rate)*".(dateDiff($datefrom,$dateto)+1)." from ".CAL_RATE." where ".CAL_RATE.".property_id = '".$ppty_id."')) AS RATE from ".CAL_RATE." inner join ".PROPERTY." on ".PROPERTY.".id = ".CAL_RATE.".property_id inner join ".CURRENCY." on ".PROPERTY.".currency_code = ".CURRENCY.".currency_code where property_id = '".$ppty_id."' group by ".CAL_RATE.".property_id ") ;*/ $rateArr = $db->runQuery(" select *, \n\t\t\t\t\t\t\t\t\t\t coalesce (sum(\n\t\t\t\t\t\t\t\t\t\t\t case when " . CAL_RATE . ".date_from >= '" . $datefrom . "' and " . CAL_RATE . ".date_to <= '" . $dateto . "' \n\t\t\t\t\t\t\t\t\t\t\t then (abs( datediff( " . CAL_RATE . ".date_from, " . CAL_RATE . ".date_to ))+1) * round(prate*exchange_rate)\n\t\t\t\t\t\t\t\t\t\t\t when " . CAL_RATE . ".date_from <= '" . $datefrom . "' and " . CAL_RATE . ".date_to >= '" . $dateto . "'\n\t\t\t\t\t\t\t\t\t\t\t then (abs( datediff( '" . $datefrom . "', '" . $dateto . "' ))+1) * round(prate*exchange_rate)\n\t\t\t\t\t\t\t\t\t\t\t when " . CAL_RATE . ".date_from <= '" . $datefrom . "' and " . CAL_RATE . ".date_to >= '" . $datefrom . "' and " . CAL_RATE . ".date_to <= '" . $dateto . "' \n\t\t\t\t\t\t\t\t\t\t\t then (abs( datediff( '" . $datefrom . "', " . CAL_RATE . ".date_to ))+1) * round(prate*exchange_rate)\n\t\t\t\t\t\t\t\t\t\t\t when " . CAL_RATE . ".date_to >= '" . $dateto . "' and " . CAL_RATE . ".date_from >= '" . $datefrom . "' and " . CAL_RATE . ".date_from <= '" . $dateto . "'\n\t\t\t\t\t\t\t\t\t\t\t then (abs( datediff( " . CAL_RATE . ".date_from, '" . $dateto . "' ))+1) * round(prate*exchange_rate)\n\t\t\t\t\t\t\t\t\t\t\t end),(select round(min(prate)*exchange_rate)*" . (dateDiff($datefrom, $dateto) + 1) . " from " . CAL_RATE . " \n\t\t\t\t\t\t\t\t\t\t\t where " . CAL_RATE . ".property_id = '" . $ppty_id . "'))\n\t\t\t\t\t\t\t\t\t\t\t AS RATE from " . CAL_RATE . " \n\t\t\t\t\t\t\t\t\t\t\t inner join " . PROPERTY . " on " . PROPERTY . ".id = " . CAL_RATE . ".property_id\n\t\t\t\t\t\t\t\t\t\t\t inner join " . CURRENCY . " on " . PROPERTY . ".currency_code = " . CURRENCY . ".currency_code\n\t\t\t\t\t\t\t\t\t\t\t where property_id = '" . $ppty_id . "' group by " . CAL_RATE . ".property_id "); $this->view->nights = dateDiff($datefrom, $dateto) + 1; } else { $rateArr = $db->runQuery("select nights*round(prate*" . CURRENCY . ".exchange_rate) as RATE,nights,prate," . PROPERTY . ".id from " . CAL_RATE . " \n\t\t\t\t\t\t\t\t inner join " . PROPERTY . " on " . PROPERTY . ".id = " . CAL_RATE . ".property_id\n\t\t\t\t\t\t\t\t inner join " . CURRENCY . " on " . PROPERTY . ".currency_code = " . CURRENCY . ".currency_code\n\t\t where " . CAL_RATE . ".property_id = '" . $ppty_id . "' and prate = (select min(prate) from " . CAL_RATE . " where property_id = '" . $ppty_id . "' \n\t\t\t\t\t\t\t\t ) order by prate asc\n\t\t\t\t\t\t\t\t "); //echo "select prate*nights as RATE,nights,prate,id from ".CAL_RATE." where prate = (select min(prate) from ".CAL_RATE." where property_id = '".$ppty_id."' ) "; $this->view->nights = $rateArr[0]['nights'] != "" ? $rateArr[0]['nights'] : ""; } //$tmp = explode(".",$rateArr[0]['RATE']); /*$actcurrArr = $db->runQuery("select exchange_rate*".($tmp[0] != "" ? $tmp[0]:0)." as mul from ".CURRENCY." inner join ".PROPERTY." on ".CURRENCY.".currency_code = ".PROPERTY.".currency_code where ".PROPERTY.".id = '".$ppty_id."' "); $tmp[0] = $actcurrArr[0]['mul'];*/ $this->view->prate = $rateArr[0]['RATE'] != "" ? $rateArr[0]['RATE'] : "Unknown"; //cal Query /* gadd $calAvailArr = $db->runQuery("select * from ".CAL_AVAIL." inner join ".PROPERTY." on ".CAL_AVAIL.".property_id = ".PROPERTY.".id where ".CAL_AVAIL.".property_id = '".$ppty_id."' ");*/ $this->view->propertyData = $propertyArr; // property images $galleryData = $db->runQuery("select * from " . GALLERY . " where property_id = '" . $ppty_id . "' "); $this->view->galleryData = $galleryData; if ($this->getRequest()->isPost() && !isset($_REQUEST['review'])) { $request = $this->getRequest(); $dataForm = $myform->getValues(); if ($dataForm['captcha'] == $_SESSION['captcha']) { $myObj = new Users(); $Result = $myObj->ownercontactus($dataForm); $mySession->sucessMsg = "Thank you, You will soon be contacted"; $varsuccess = 1; } else { $mySession->errorMsg = "Please Enter Correct Human Verification Code"; } } $this->view->varsuccess = $varsuccess; }