public function checkAvailablity($dataForm, $pptyId)
{
global $mySession;
$db = new Db();
if ($dataForm['partySize'] < $dataForm['Adults'] + $dataForm['Children']) {
return array("message" => "Members area greater than the property size", "output" => false);
}
$arrivalDate = explode("/", $dataForm['date_from']);
$narrivalDate = $arrivalDate[2] . "-" . $arrivalDate[1] . "-" . $arrivalDate[0];
$dataForm['date_to'] = $dataForm['date_to'] - 1;
//echo "select * from ".CAL_AVAIL." where ((date_from <= '".$narrivalDate."' and date_to >= '".$narrivalDate."') or (date_to >= adddate('".$narrivalDate."',$dataForm[date_to]) and date_from <= adddate('".$narrivalDate."',$dataForm[date_to]))) and cal_status = '0' and property_id = '".$pptyId."' "; exit;
$chkQuery = $db->runQuery("select * from " . CAL_AVAIL . " where ((date_from <= '" . $narrivalDate . "' and date_to >= '" . $narrivalDate . "') or (date_to >= adddate('" . $narrivalDate . "','" . $dataForm['date_to'] . "') and date_from <= adddate('" . $narrivalDate . "','" . $dataForm['date_to'] . "'))) and cal_status = '0' and property_id = '" . $pptyId . "' ");
$dateTo = date('Y-m-d', strtotime($narrivalDate . " + " . $dataForm['date_to'] . " day"));
if (count($chkQuery) > 0) {
return array("message" => "The dates/nights you selected are not available, please try again", "output" => false);
} else {
//checking if a supplier property
$supplierpptyArr = $db->runQuery("select * from property where id = '" . $pptyId . "' ");
if ($supplierpptyArr[0]['xml_subscriber_id'] > 0 && !empty($supplierpptyArr[0]['xml_property_id']) && $supplierpptyArr[0]['xml_subscriber_id'] == '1') {
//xml api checking if a property is available
$res = new Ciirus("c346aeb90de54a3", "ff3a6f4e60ab4ec");
$arrivalDate = date('d-M-Y', strtotime($narrivalDate));
//prd($arrivalDate);
$departureDate = date('d-M-Y', strtotime($narrivalDate . " + " . ($dataForm['date_to'] + 1) . " day"));
$dd = $res->isPropertyAvailable($supplierpptyArr[0]['xml_property_id'], $arrivalDate, $departureDate);
//prd($dd);
if (!$dd) {
return array("message" => "The dates/nights you selected are not available, please try again", "output" => false);
}
}
}
if ($this->checkAmount($narrivalDate, $dateTo, $dataForm['date_to'] + 1, $pptyId) === 0) {
return array("message" => "Allowed Minimum Nights failed", "output" => false);
}
$mySession->Adults = $dataForm['Adults'];
$mySession->Children = $dataForm['Children'];
$mySession->Infants = $dataForm['Infants'];
$mySession->noOfNights = $dataForm['date_to'] + 1;
$mySession->arrivalDate = $dataForm['date_from'];
$mySession->departureDate = date('d-m-Y', strtotime($dataForm['date_from'] . " + " . ($dataForm['date_to'] + 1) . " day"));
$mySession->partySize = $dataForm['Adults'] + $dataForm['Children'];
$mySession->pptyId = $pptyId;
//code to find the amount
$mySession->totalCost = $this->checkAmount($narrivalDate, $dateTo, $dataForm['date_to'] + 1, $pptyId);
// if(empty($mySession->totalCost)){
// return array("output"=>false,"message"=>"cost not available");
// }
$mySession->steps = '2';
// return 1;
return array("cost" => $mySession->totalCost, "output" => true);
}
function updatecalendarAction()
{
__autoloadPlugin('Ciirus');
__autoloadPlugin('Globalresorthomes');
__autoloadPlugin('Contempovacation');
__autoloadPlugin('Fairwaysflorida');
__autoloadPlugin('Casiola');
__autoloadPlugin('Resorthomesofflorida');
__autoloadPlugin('Ellisexclusivevillas');
global $mySession;
$db = new Db();
$this->debug = false;
$pptyArr = $db->runQuery("select *, subscriber_id AS supplier_id, \n (\n SELECT count( subscriber_key ) AS count\n FROM `subscriber`\n INNER JOIN property ON property.xml_subscriber_id = subscriber.subscriber_id\n WHERE subscriber.subscriber_id = supplier_id\n ) AS count from " . PROPERTY . "\n inner join subscriber on subscriber.subscriber_id = " . PROPERTY . ".xml_subscriber_id \n where xml_subscriber_id > 0 and status != '4' and status != '0'\n order by subscriber.subscriber_id asc");
//prd($pptyArr);
$res = new Ciirus("c346aeb90de54a3", "ff3a6f4e60ab4ec");
$_counter = array();
$_counter['ciirus'] = 0;
$_counter['globalresorthomes'] = 0;
$_counter['contempovacation'] = 0;
$_counter['fairwaysflorida'] = 0;
$_counter['casiola'] = 0;
$_counter['ellisexclusivevillas'] = 0;
//$reservation = $res->getReservations(50644);
//$arr['propertyId'] = 50644; //property which is not available
//$arr['propertyId'] = 52196;
foreach ($pptyArr as $pKey => $pVal) {
$property_id = $pVal['id'];
$xml_property_id = $pVal["xml_property_id"];
switch ($pVal['xml_subscriber_id']) {
//ciirus
case '1':
if (!empty($xml_property_id)) {
//check if property is available or not
$arr['propertyId'] = $xml_property_id;
$av = $res->getProperties($arr, 0, true, true, true);
if (!preg_match('/No rows returned/', $av)) {
//update availability calendar
$reservation = $res->getReservations($xml_property_id);
//delete the older entries
if (!empty($reservation) && count($reservation)) {
$db->delete(CAL_AVAIL, "property_id = " . $property_id);
}
foreach ($reservation as $rKey => $rVal) {
if ($rKey === 'ArrivalDate') {
break;
}
$data_cal = array();
$data_cal['property_id'] = $property_id;
$date_from = explode('T', $rVal['ArrivalDate']);
$data_cal['date_from'] = $date_from[0];
$date_to = explode('T', $rVal['DepartureDate']);
$data_cal['date_to'] = date('Y-m-d', strtotime($date_to[0] . ' -1 day'));
//$data_cal['date_to'] = $date_to[0];
$data_cal['cal_status'] = '0';
if (!$this->debug) {
$db->save(CAL_AVAIL, $data_cal);
}
}
if ($rKey === 'ArrivalDate') {
$data_cal = array();
$data_cal['property_id'] = $property_id;
$date_from = explode('T', $reservation['ArrivalDate']);
$data_cal['date_from'] = $date_from[0];
$date_to = explode('T', $reservation['DepartureDate']);
$data_cal['date_to'] = date('Y-m-d', strtotime($date_to[0] . ' -1 day'));
//$data_cal['date_to'] = $date_to[0];
$data_cal['cal_status'] = '0';
if (!$this->debug) {
$db->save(CAL_AVAIL, $data_cal);
}
}
echo $pKey + 1 . ". Successfully Updated property no - " . $pVal['xml_property_id'] . "<br>";
} else {
echo $pKey + 1 . ". Failed Updating property no - " . $pVal['xml_property_id'] . "<br>";
}
}
//code for checking if the supplier data is empty
if ($pVal['count'] == $_counter['ciirus'] + 1) {
echo "<strong>" . $pVal['subscriber_key'] . " cron job completed!! </strong><br>";
}
$_counter['ciirus']++;
break;
case '2':
$res = new Globalresorthomes($pVal['subscriber_url']);
$res->getWebsite($xml_property_id);
if (!empty($xml_property_id)) {
//get booked dates
$reservation = $res->getReservations($xml_property_id, $pVal['subscriber_secondary_url']);
if (!empty($reservation) && count($reservation)) {
$db->delete(CAL_AVAIL, "property_id = " . $property_id);
foreach ($reservation as $rKey => $rVal) {
$data_cal = array();
$data_cal['property_id'] = $property_id;
$date_from = explode('-', $rVal);
// prd($date_from);
$data_cal['date_from'] = date('Y-m-d', strtotime($date_from[0]));
if (count($date_from) > 1) {
$data_cal['date_to'] = date('Y-m-d', strtotime($date_from[1]));
} else {
$data_cal['date_to'] = date('Y-m-d', strtotime($date_from[0]));
}
//$data_cal['date_to'] = $date_to[0];
$data_cal['cal_status'] = '0';
if (!$this->debug) {
$db->save(CAL_AVAIL, $data_cal);
}
}
echo $pKey + 1 . ". Successfully Updated property no - " . $pVal['xml_property_id'] . "<br>";
}
}
//code for checking if the supplier data is empty
if ($pVal['count'] == $_counter['globalresorthomes'] + 1) {
echo "<strong>" . $pVal['subscriber_key'] . " cron job completed!! </strong><br>";
}
$_counter['globalresorthomes']++;
break;
case '3':
$res = new Contempovacation($pVal['subscriber_url']);
$res->getWebsite($xml_property_id);
if (!empty($xml_property_id)) {
$reservation = $res->getReservations($xml_property_id, $pVal['subscriber_url']);
if (!empty($reservation) && count($reservation)) {
$db->delete(CAL_AVAIL, "property_id = " . $property_id);
foreach ($reservation as $rKey => $rVal) {
$data_cal = array();
$data_cal['property_id'] = $property_id;
$date_from = explode('|||', $rVal);
$data_cal['date_from'] = date('Y-m-d', strtotime(str_replace('/', '-', $date_from[0])));
$data_cal['date_to'] = date('Y-m-d', strtotime(str_replace('/', '-', $date_from[1])));
//$data_cal['date_to'] = $date_to[0];
$data_cal['cal_status'] = '0';
if (!$this->debug) {
$db->save(CAL_AVAIL, $data_cal);
}
}
echo $pKey + 1 . ". Successfully Updated property no - " . $pVal['xml_property_id'] . "<br>";
}
}
if ($pVal['count'] == $_counter['contempovacation'] + 1) {
echo "<strong>" . $pVal['subscriber_key'] . " cron job completed!! </strong><br>";
}
$_counter['contempovacation']++;
break;
case 4:
$res = new Fairwaysflorida($pVal['subscriber_url']);
$res->getWebsite($xml_property_id);
if (!empty($xml_property_id)) {
$reservation = $res->getBookedDates($pVal['xml_property_id']);
if (!empty($reservation) && count($reservation)) {
$db->delete(CAL_AVAIL, "property_id = " . $property_id);
foreach ($reservation as $rKey => $rVal) {
$data_cal = array();
$data_cal['property_id'] = $property_id;
$data_cal['date_from'] = $rVal['checkin'];
$data_cal['date_to'] = $rVal['checkout'];
$data_cal['cal_status'] = '0';
if (!$this->debug) {
$db->save(CAL_AVAIL, $data_cal);
}
}
echo $pKey + 1 . ". Successfully Updated property no - " . $pVal['xml_property_id'] . "<br>";
}
}
if ($pVal['count'] == $_counter['fairwaysflorida'] + 1) {
echo "<strong>" . $pVal['subscriber_key'] . " cron job completed!! </strong><br>";
}
$_counter['fairwaysflorida']++;
break;
case 5:
$res = new Casiola($pVal['subscriber_url']);
$res->getWebsite($xml_property_id);
if (!empty($xml_property_id)) {
//get booked dates
$reservation = $res->getReservations($xml_property_id, $pVal['subscriber_secondary_url']);
if (!empty($reservation) && count($reservation)) {
$db->delete(CAL_AVAIL, "property_id = " . $property_id);
foreach ($reservation as $rKey => $rVal) {
$data_cal = array();
$data_cal['property_id'] = $property_id;
$date_from = explode('-', $rVal);
// prd($date_from);
$data_cal['date_from'] = date('Y-m-d', strtotime($date_from[0]));
if (count($date_from) > 1) {
$data_cal['date_to'] = date('Y-m-d', strtotime($date_from[1]));
} else {
$data_cal['date_to'] = date('Y-m-d', strtotime($date_from[0]));
}
//$data_cal['date_to'] = $date_to[0];
$data_cal['cal_status'] = '0';
if (!$this->debug) {
$db->save(CAL_AVAIL, $data_cal);
}
}
echo $pKey + 1 . ". Successfully Updated property no - " . $pVal['xml_property_id'] . "<br>";
}
}
//code for checking if the supplier data is empty
if ($pVal['count'] == $_counter['casiola'] + 1) {
echo "<strong>" . $pVal['subscriber_key'] . " cron job completed!! </strong><br>";
}
$_counter['casiola']++;
break;
case 6:
$res = new Globalresorthomes($pVal['subscriber_url']);
$res->getWebsite($xml_property_id);
if (!empty($xml_property_id)) {
//get booked dates
$reservation = $res->getReservations($xml_property_id, $pVal['subscriber_secondary_url']);
if (!empty($reservation) && count($reservation)) {
$db->delete(CAL_AVAIL, "property_id = " . $property_id);
foreach ($reservation as $rKey => $rVal) {
$data_cal = array();
$data_cal['property_id'] = $property_id;
$date_from = explode('-', $rVal);
// prd($date_from);
$data_cal['date_from'] = date('Y-m-d', strtotime($date_from[0]));
if (count($date_from) > 1) {
$data_cal['date_to'] = date('Y-m-d', strtotime($date_from[1]));
} else {
$data_cal['date_to'] = date('Y-m-d', strtotime($date_from[0]));
}
//$data_cal['date_to'] = $date_to[0];
$data_cal['cal_status'] = '0';
if (!$this->debug) {
$db->save(CAL_AVAIL, $data_cal);
}
}
echo $pKey + 1 . ". Successfully Updated property no - " . $pVal['xml_property_id'] . "<br>";
}
}
//code for checking if the supplier data is empty
if ($pVal['count'] == $_counter['resorthomesofflorida'] + 1) {
echo "<strong>" . $pVal['subscriber_key'] . " cron job completed!! </strong><br>";
}
$_counter['resorthomesofflorida']++;
break;
case 7:
$res = new Ellisexclusivevillas($pVal['subscriber_url']);
$res->getWebsite($xml_property_id);
if (!empty($xml_property_id)) {
//get booked dates
$reservation = $res->getReservations($xml_property_id, $pVal['subscriber_secondary_url']);
if (!empty($reservation) && count($reservation)) {
$db->delete(CAL_AVAIL, "property_id = " . $property_id);
foreach ($reservation as $rKey => $rVal) {
$data_cal = array();
$data_cal['property_id'] = $property_id;
$date_from = explode('-', $rVal);
// prd($date_from);
$data_cal['date_from'] = date('Y-m-d', strtotime($date_from[0]));
if (count($date_from) > 1) {
$data_cal['date_to'] = date('Y-m-d', strtotime($date_from[1]));
} else {
$data_cal['date_to'] = date('Y-m-d', strtotime($date_from[0]));
}
//$data_cal['date_to'] = $date_to[0];
$data_cal['cal_status'] = '0';
if (!$this->debug) {
$db->save(CAL_AVAIL, $data_cal);
}
}
echo $pKey + 1 . ". Successfully Updated property no - " . $pVal['xml_property_id'] . "<br>";
}
}
//code for checking if the supplier data is empty
if ($pVal['count'] == $_counter['ellisexclusivevillas'] + 1) {
echo "<strong>" . $pVal['subscriber_key'] . " cron job completed!! </strong><br>";
}
$_counter['ellisexclusivevillas']++;
break;
}
//switch case ends
}
echo "perfect!!";
die;
}
public function synchronizebulkAction()
{
global $mySession;
$db = new Db();
set_time_limit(0);
$post = $this->getRequest()->getPost();
$this->debug = false;
if ($this->getRequest()->isPost()) {
foreach ($post['xml_property_id'] as $key => $postValue) {
$property_id = $post["ref_property_id"][$key];
$xml_property_id = $postValue;
$caption = $post['ref_property_caption'][$key];
//get data of suppliers from database
$supplierData = $db->runQuery("select * from subscriber ");
$_supplierData = array();
foreach ($supplierData as $supKey => $supVal) {
$_supplierData[$supVal['subscriber_key']]['subscriber_name'] = $supVal['subscriber_name'];
$_supplierData[$supVal['subscriber_key']]['subscriber_id'] = $supVal['subscriber_id'];
$_supplierData[$supVal['subscriber_key']]['subscriber_url'] = $supVal['subscriber_url'];
$_supplierData[$supVal['subscriber_key']]['subscriber_secondary_url'] = $supVal['subscriber_secondary_url'];
$_supplierData[$supVal['subscriber_key']]['subscriber_base_url'] = $supVal['subscriber_base_url'];
$_supplierData[$supVal['subscriber_key']]['subscriber_image_url'] = $supVal['subscriber_image_url'];
$_supplierData[$supVal['subscriber_key']]['subscriber_image_secondary_url'] = $supVal['subscriber_image_secondary_url'];
if (!empty($supVal['subscriber_api_username'])) {
$_supplierData[$supVal['subscriber_key']]['subscriber_api_username'] = $supVal['subscriber_api_username'];
$_supplierData[$supVal['subscriber_key']]['subscriber_api_password'] = $supVal['subscriber_api_password'];
}
}
//prd($_supplierData['ciirus']['subscriber_api_username']);
//prd($post['xml_subscriber_id']);
switch ($post['xml_subscriber_id']) {
//ciirus subscriber synchronization code
case 1:
$res = new Ciirus($_supplierData['ciirus']['subscriber_api_username'], $_supplierData['ciirus']['subscriber_api_password']);
//filter parameters
$arr['propertyId'] = $xml_property_id;
$res->getProperties($arr, 0, true, true, true);
//subscriber name
$data['xml_subscriber_id'] = $post['xml_subscriber_id'];
//get heading
$heading = $res->getHeading($xml_property_id);
$data['xml_heading'] = $heading;
//get description part
$description = $res->getDescription($xml_property_id);
$data['xml_description'] = $description;
//get features
$features = $res->getFeatures($xml_property_id);
$data['xml_features'] = $features;
//get community
$community = $res->getCommunity($xml_property_id);
$data['xml_community'] = $community;
//get rates
$rates = $res->getStructuredPropertyRates($xml_property_id, $markUp);
$data['xml_rating'] = $rates;
$markUp = $post['xml_rate_markup'][$key];
//saving rates
$rateArr = $res->getCalendarPropertyRates($xml_property_id, $markUp);
if (!empty($rateArr) && count($rateArr) > 0 && !$this->debug) {
$db->delete(CAL_RATE, "property_id = " . $property_id);
}
foreach ($rateArr as $rateK => $rateV) {
$rateData = array();
$rateData['property_id'] = $property_id;
$rateData['date_from'] = $rateV['date_from'];
$rateData['date_to'] = $rateV['date_to'];
$rateData['nights'] = $rateV['nights'];
$rateData['prate'] = $rateV['prate'];
if (!$this->debug) {
$db->save(CAL_RATE, $rateData);
}
}
//get extras
$extra = $res->getExtras1($xml_property_id);
//poool heating extra
$poolExtra = $res->getExtras($xml_property_id);
$poolC = count($extra);
if ($extra['PoolHeatIncludedInPrice']) {
// $extra[$poolC]['FlatFeeAmount'] = 'Flat amount';
// $extra[$poolC]['FlatFee'] = true;
// $extra[$poolC]['DailyFee'] = false;
} else {
$extra[$poolC]['DailyFeeAmount'] = $poolExtra['DailyCharge'];
$extra[$poolC]['DailyFee'] = true;
$extra[$poolC]['FlatFee'] = false;
$extra[$poolC]['ItemDescription'] = 'Pool Heating';
$extra[$poolC]['Mandatory'] = false;
}
if (!empty($extra)) {
$data['xml_extras'] = serialize($extra);
//delete older entries if exist
// if(!$this->debug)
// $db->delete(EXTRAS, "property_id = " . $property_id);
//
//older method commented
// $dataExtra = array();
// $dataExtra['property_id'] = $property_id;
// $dataExtra['ename'] = "Pool Heating";
// $dataExtra['eprice'] = $extra['DailyCharge'];
// $dataExtra['etype'] = '0';
// $dataExtra['stay_type'] = '0';
//
// $db->save(EXTRAS, $dataExtra);
//saving extras
// foreach ($extra as $exKey => $exVal)
// {
// $dataExtra = array();
// $dataExtra['property_id'] = $property_id;
// $dataExtra['ename'] = $exVal["ItemDescription"];
// $dataExtra['eprice'] = $exVal['FlatFee']=='true'?$exVal['FlatFeeAmount']:$exVal['DailyFeeAmount'];
// $dataExtra['etype'] = $exVal['Mandatory']=='true'?'1':'0';
// $dataExtra['stay_type'] = $exVal['DailyFee']=='false'?'1':'0';
//
// if(!$this->debug)
// $db->save(EXTRAS, $dataExtra);
// }
}
$data['xml_property_id'] = $xml_property_id;
$condition = " id= " . $property_id;
if (!$this->debug) {
$result = $db->modify(PROPERTY, $data, $condition);
}
//grab images functionality
$images = $res->getImageList($xml_property_id);
//prd($images);
if (count($images) > 0 && is_array($images)) {
//delete older images
$galleryArr = $db->runQuery("select * from " . GALLERY . " where property_id='" . $property_id . "' ");
foreach ($galleryArr as $galKey => $galVal) {
@unlink(SITE_ROOT . "images/property/" . $galVal['image_name']);
$db->delete(GALLERY, 'gallery_id = ' . $galVal['gallery_id']);
}
}
foreach ($images as $iKey => $iVal) {
//pr($iVal);
$file_name = explode("/", $iVal);
$file_name = urldecode(time() . "_" . end($file_name));
$file_name = str_replace(' ', '_', $file_name);
if (!$this->debug) {
$contentOrFalseOnFailure = file_get_contents($iVal);
}
if (!$this->debug) {
$byteCountOrFalseOnFailure = file_put_contents(SITE_ROOT . "images/property/" . $file_name, $contentOrFalseOnFailure);
}
//saving data in database
$data_image = array();
$data_image['image_name'] = $file_name;
$data_image['property_id'] = $property_id;
//image caption for all location - bedroom - type
// if ($iKey == 0)
$data_image['image_title'] = $caption;
if (!$this->debug) {
$db->save(GALLERY, $data_image);
}
}
//prd($images);
//save the list of booked dates
$reservation = $res->getReservations($xml_property_id);
//delete the older entries
if (!empty($reservation) && count($reservation)) {
$db->delete(CAL_AVAIL, "property_id = " . $property_id);
}
foreach ($reservation as $rKey => $rVal) {
if ($rKey === 'ArrivalDate') {
break;
}
$data_cal = array();
$data_cal['property_id'] = $property_id;
$date_from = explode('T', $rVal['ArrivalDate']);
$data_cal['date_from'] = $date_from[0];
$date_to = explode('T', $rVal['DepartureDate']);
$data_cal['date_to'] = date('Y-m-d', strtotime($date_to[0] . ' -1 day'));
//$data_cal['date_to'] = $date_to[0];
$data_cal['cal_status'] = '0';
if (!$this->debug) {
$db->save(CAL_AVAIL, $data_cal);
}
}
if ($rKey === 'ArrivalDate') {
$data_cal = array();
$data_cal['property_id'] = $property_id;
$date_from = explode('T', $reservation['ArrivalDate']);
$data_cal['date_from'] = $date_from[0];
$date_to = explode('T', $reservation['DepartureDate']);
$data_cal['date_to'] = date('Y-m-d', strtotime($date_to[0] . ' -1 day'));
//$data_cal['date_to'] = $date_to[0];
$data_cal['cal_status'] = '0';
if (!$this->debug) {
$db->save(CAL_AVAIL, $data_cal);
}
}
break;
// global resort home subscriber synchronization code
// global resort home subscriber synchronization code
case 2:
$res = new Globalresorthomes($_supplierData['globalresorthomes']['subscriber_url']);
$res->getWebsite($xml_property_id);
//grab images functionality
$images = $res->getImageList($xml_property_id);
$url = $_supplierData['globalresorthomes']['subscriber_secondary_url'];
$data = array();
$data['xml_subscriber_id'] = $post['xml_subscriber_id'];
$data['xml_property_id'] = $post['xml_property_id'];
//get heading of the property
$heading = $res->getHeading($xml_property_id);
$data['xml_heading'] = $heading;
//get description part of the website
$description = $res->getDescription($xml_property_id);
$data['xml_description'] = $description;
//get features of the property
$features = $res->getFeatures($xml_property_id);
$data['xml_features'] = $features;
$data['xml_extras'] = '';
$data['xml_community'] = '';
//get rates
$rate = $res->getRates($xml_property_id, $url);
$data['xml_rating'] = $rate;
//get booked dates
$reservation = $res->getReservations($xml_property_id, $url);
// $data['xml_property_id'] = $post['xml_property_id'];
$data['xml_property_id'] = $xml_property_id;
$condition = " id= " . $property_id;
if (!$this->debug) {
$result = $db->modify(PROPERTY, $data, $condition);
}
if (!empty($reservation) && count($reservation)) {
$db->delete(CAL_AVAIL, "property_id = " . $property_id);
foreach ($reservation as $rKey => $rVal) {
$data_cal = array();
$data_cal['property_id'] = $property_id;
$date_from = explode('-', $rVal);
// prd($date_from);
$data_cal['date_from'] = date('Y-m-d', strtotime($date_from[0]));
if (count($date_from) > 1) {
$data_cal['date_to'] = date('Y-m-d', strtotime($date_from[1]));
} else {
$data_cal['date_to'] = date('Y-m-d', strtotime($date_from[0]));
}
//$data_cal['date_to'] = $date_to[0];
$data_cal['cal_status'] = '0';
if (!$this->debug) {
$db->save(CAL_AVAIL, $data_cal);
}
}
}
if (count($images) > 0 && is_array($images)) {
//delete older images
$galleryArr = $db->runQuery("select * from " . GALLERY . " where property_id='" . $property_id . "' ");
foreach ($galleryArr as $galKey => $galVal) {
@unlink(SITE_ROOT . "images/property/" . $galVal['image_name']);
$db->delete(GALLERY, 'gallery_id = ' . $galVal['gallery_id']);
}
}
foreach ($images as $iKey => $iVal) {
//pr($iVal);
//$file_name = explode("/", $iVal);
$file_name = urldecode(time() . "_" . $iVal);
$file_name = str_replace(' ', '_', $file_name);
if (!$this->debug) {
$validImage = getimagesize($_supplierData['globalresorthomes']['subscriber_image_url'] . '/' . $iVal);
if (count($validImage) && is_array($validImage) && !empty($validImage)) {
$contentOrFalseOnFailure = file_get_contents($_supplierData['globalresorthomes']['subscriber_image_url'] . '/' . $iVal);
} else {
$VAR = explode("_", $iVal);
$VAR = $VAR[0];
$secondary_img_url = str_replace('[VAR]', $VAR, $_supplierData['globalresorthomes']['subscriber_image_secondary_url']);
$contentOrFalseOnFailure = file_get_contents($secondary_img_url . '/' . $iVal);
}
}
if (!$this->debug) {
$byteCountOrFalseOnFailure = file_put_contents(SITE_ROOT . "images/property/" . $file_name, $contentOrFalseOnFailure);
}
//saving data in database
$data_image = array();
$data_image['image_name'] = $file_name;
$data_image['property_id'] = $property_id;
// if ($iKey == 0)
$data_image['image_title'] = $caption;
if (!$this->debug) {
$db->save(GALLERY, $data_image);
}
}
break;
case 3:
$res = new Contempovacation($_supplierData['contempovacation']['subscriber_url']);
$res->getWebsite($xml_property_id);
//
$data = array();
$data['xml_subscriber_id'] = $post['xml_subscriber_id'];
// $data['xml_property_id'] = $post['xml_property_id'];
$data['xml_property_id'] = $xml_property_id;
//get heading of the property
$heading = $res->getHeading($xml_property_id);
$data['xml_heading'] = $heading;
//get description part of the website
$description = $res->getDescription($xml_property_id);
$data['xml_description'] = $description;
//get features of the property
$features = $res->getFeatures($xml_property_id);
$data['xml_features'] = $features;
$data['xml_extras'] = '';
$data['xml_community'] = '';
$data['xml_rating'] = '';
$data['xml_property_id'] = $post['xml_property_id'];
$condition = " id= " . $property_id;
if (!$this->debug) {
$result = $db->modify(PROPERTY, $data, $condition);
}
$images = $res->getImageList($xml_property_id);
if (count($images) > 0 && is_array($images) && !$this->debug) {
//delete older images
$galleryArr = $db->runQuery("select * from " . GALLERY . " where property_id='" . $property_id . "' ");
foreach ($galleryArr as $galKey => $galVal) {
@unlink(SITE_ROOT . "images/property/" . $galVal['image_name']);
$db->delete(GALLERY, 'gallery_id = ' . $galVal['gallery_id']);
}
}
foreach ($images as $iKey => $iVal) {
//$file_name = explode("/", $iVal);
$endfile = explode("/", $iVal);
$endfile = array_pop($endfile);
$file_name = urldecode(time() . "_" . $endfile);
$file_name = str_replace(' ', '_', $file_name);
if (!$this->debug) {
//$validImage = getimagesize($iVal);
$contentOrFalseOnFailure = file_get_contents("{$iVal}");
}
if (!$this->debug) {
$byteCountOrFalseOnFailure = file_put_contents(SITE_ROOT . "images/property/" . $file_name, $contentOrFalseOnFailure);
}
//saving data in database
$data_image = array();
$data_image['image_name'] = $file_name;
$data_image['property_id'] = $property_id;
// if ($iKey == 0)
$data_image['image_title'] = $caption;
if (!$this->debug) {
$db->save(GALLERY, $data_image);
}
}
//get booked dates
$reservation = $res->getReservations($xml_property_id, $url);
if (!empty($reservation) && count($reservation)) {
$db->delete(CAL_AVAIL, "property_id = " . $property_id);
foreach ($reservation as $rKey => $rVal) {
$data_cal = array();
$data_cal['property_id'] = $property_id;
$date_from = explode('|||', $rVal);
$data_cal['date_from'] = date('Y-m-d', strtotime(str_replace('/', '-', $date_from[0])));
$data_cal['date_to'] = date('Y-m-d', strtotime(str_replace('/', '-', $date_from[1])));
//$data_cal['date_to'] = $date_to[0];
$data_cal['cal_status'] = '0';
if (!$this->debug) {
$db->save(CAL_AVAIL, $data_cal);
}
}
}
break;
case 4:
$res = new Fairwaysflorida($_supplierData['fairwaysflorida']['subscriber_url']);
$res->getWebsite($xml_property_id);
//
$data = array();
$data['xml_subscriber_id'] = $post['xml_subscriber_id'];
$data['xml_property_id'] = $post['xml_property_id'];
//get heading of the property
$heading = $res->getHeading($xml_property_id);
$data['xml_heading'] = $heading;
//get description part of the website
$description = $res->getDescription($xml_property_id);
$data['xml_description'] = $description;
//get features of the property
$features = $res->getFeatures($xml_property_id);
$data['xml_features'] = $features;
$data['xml_extras'] = '';
$data['xml_community'] = '';
$data['xml_rating'] = '';
$data['xml_property_id'] = $post['xml_property_id'];
$condition = " id= " . $property_id;
if (!$this->debug) {
$result = $db->modify(PROPERTY, $data, $condition);
}
//=== images process ====
$images = $res->getImageList($xml_property_id);
if (count($images) > 0 && is_array($images) && !$this->debug) {
//delete older images
$galleryArr = $db->runQuery("select * from " . GALLERY . " where property_id='" . $property_id . "' ");
foreach ($galleryArr as $galKey => $galVal) {
@unlink(SITE_ROOT . "images/property/" . $galVal['image_name']);
$db->delete(GALLERY, 'gallery_id = ' . $galVal['gallery_id']);
}
}
foreach ($images as $iKey => $iVal) {
//$file_name = explode("/", $iVal);
$endfile = explode("/", $iVal);
$endfile = array_pop($endfile);
$file_name = urldecode(time() . "_" . $endfile);
$file_name = str_replace(' ', '_', $file_name);
if (!$this->debug) {
//$validImage = getimagesize($iVal);
$contentOrFalseOnFailure = file_get_contents("http:{$iVal}");
}
if (!$this->debug) {
$byteCountOrFalseOnFailure = file_put_contents(SITE_ROOT . "images/property/" . $file_name, $contentOrFalseOnFailure);
}
//saving data in database
$data_image = array();
$data_image['image_name'] = $file_name;
$data_image['property_id'] = $property_id;
// if ($iKey == 0)
// $data_image['image_title'] = $heading;
$data_image['image_title'] = $caption;
if (!$this->debug) {
$db->save(GALLERY, $data_image);
}
}
//===== availability dates
$reservation = $res->getBookedDates($post['xml_property_id']);
//delete the older entries
if (!empty($reservation) && count($reservation)) {
$db->delete(CAL_AVAIL, "property_id = " . $property_id);
}
foreach ($reservation as $rKey => $rVal) {
$data_cal = array();
$data_cal['property_id'] = $property_id;
$data_cal['date_from'] = $rVal['checkin'];
$data_cal['date_to'] = $rVal['checkout'];
$data_cal['cal_status'] = '0';
if (!$this->debug) {
$db->save(CAL_AVAIL, $data_cal);
}
}
break;
case 5:
$res = new Casiola($_supplierData['casiola']['subscriber_url']);
$res->getWebsite($xml_property_id);
//grab images functionality
$images = $res->getImageList($xml_property_id);
//echo "<pre>"; print_r($images); echo "</pre>";
$url = $_supplierData['casiola']['subscriber_secondary_url'];
$data = array();
$data['xml_subscriber_id'] = $post['xml_subscriber_id'];
$data['xml_property_id'] = $post['xml_property_id'];
//get heading of the property
$heading = $res->getHeading($xml_property_id);
$data['xml_heading'] = $heading;
//get description part of the website
$description = $res->getDescription($xml_property_id);
$data['xml_description'] = $description;
//get features of the property
$features = $res->getFeatures($xml_property_id);
$data['xml_features'] = $features;
$data['xml_extras'] = '';
$data['xml_community'] = '';
//get rates
$rate = $res->getRates($xml_property_id, $url);
$data['xml_rating'] = $rate;
//get booked dates
$reservation = $res->getReservations($xml_property_id, $url);
$data['xml_property_id'] = $post['xml_property_id'];
$condition = " id= " . $property_id;
if (!$this->debug) {
$result = $db->modify(PROPERTY, $data, $condition);
}
if (!empty($reservation) && count($reservation)) {
$db->delete(CAL_AVAIL, "property_id = " . $property_id);
foreach ($reservation as $rKey => $rVal) {
$data_cal = array();
$data_cal['property_id'] = $property_id;
$date_from = explode('-', $rVal);
$data_cal['date_from'] = date('Y-m-d', strtotime($date_from[0]));
if (count($date_from) > 1) {
$data_cal['date_to'] = date('Y-m-d', strtotime($date_from[1]));
} else {
$data_cal['date_to'] = date('Y-m-d', strtotime($date_from[0]));
}
$data_cal['cal_status'] = '0';
if (!$this->debug) {
$db->save(CAL_AVAIL, $data_cal);
}
}
}
if (count($images) > 0 && is_array($images)) {
//delete older images
$galleryArr = $db->runQuery("select * from " . GALLERY . " where property_id='" . $property_id . "' ");
foreach ($galleryArr as $galKey => $galVal) {
@unlink(SITE_ROOT . "images/property/" . $galVal['image_name']);
$db->delete(GALLERY, 'gallery_id = ' . $galVal['gallery_id']);
}
}
foreach ($images as $iKey => $iVal) {
//pr($iVal);
//$file_name = explode("/", $iVal);
$file_name = urldecode(time() . "_" . $iVal);
$file_name = str_replace(' ', '_', $file_name);
if (!$this->debug) {
$validImage = getimagesize($_supplierData['casiola']['subscriber_image_url'] . '/' . $iVal);
if (count($validImage) && is_array($validImage) && !empty($validImage)) {
$contentOrFalseOnFailure = file_get_contents($_supplierData['casiola']['subscriber_image_url'] . '/' . $iVal);
} else {
$VAR = explode("_", $iVal);
$VAR = $VAR[0];
$secondary_img_url = str_replace('[VAR]', $VAR, $_supplierData['casiola']['subscriber_image_secondary_url']);
$contentOrFalseOnFailure = file_get_contents($secondary_img_url . '/' . $iVal);
}
}
if (!$this->debug) {
$byteCountOrFalseOnFailure = file_put_contents(SITE_ROOT . "images/property/" . $file_name, $contentOrFalseOnFailure);
}
//saving data in database
$data_image = array();
$data_image['image_name'] = $file_name;
$data_image['property_id'] = $property_id;
// if ($iKey == 0)
// $data_image['image_title'] = $heading;
$data_image['image_title'] = $caption;
if (!$this->debug) {
$db->save(GALLERY, $data_image);
}
}
break;
case 6:
$res = new Resorthomesofflorida($_supplierData['resorthomesofflorida']['subscriber_url']);
$res->getWebsite($xml_property_id);
//grab images functionality
$images = $res->getImageList($xml_property_id);
$url = $_supplierData['resorthomesofflorida']['subscriber_secondary_url'];
$data = array();
$data['xml_subscriber_id'] = $post['xml_subscriber_id'];
$data['xml_property_id'] = $post['xml_property_id'];
//get heading of the property
$heading = $res->getHeading($xml_property_id);
$data['xml_heading'] = $heading;
//get description part of the website
$description = $res->getDescription($xml_property_id);
$data['xml_description'] = $description;
//get features of the property
$features = $res->getFeatures($xml_property_id);
$data['xml_features'] = $features;
$data['xml_extras'] = '';
$data['xml_community'] = '';
//get rates
$rate = $res->getRates($xml_property_id, $url);
$data['xml_rating'] = $rate;
//get booked dates
$reservation = $res->getReservations($xml_property_id, $url);
$data['xml_property_id'] = $post['xml_property_id'];
$condition = " id= " . $property_id;
if (!$this->debug) {
$result = $db->modify(PROPERTY, $data, $condition);
}
if (!empty($reservation) && count($reservation)) {
$db->delete(CAL_AVAIL, "property_id = " . $property_id);
foreach ($reservation as $rKey => $rVal) {
$data_cal = array();
$data_cal['property_id'] = $property_id;
$date_from = explode('-', $rVal);
$data_cal['date_from'] = date('Y-m-d', strtotime($date_from[0]));
if (count($date_from) > 1) {
$data_cal['date_to'] = date('Y-m-d', strtotime($date_from[1]));
} else {
$data_cal['date_to'] = date('Y-m-d', strtotime($date_from[0]));
}
$data_cal['cal_status'] = '0';
if (!$this->debug) {
$db->save(CAL_AVAIL, $data_cal);
}
}
}
if (count($images) > 0 && is_array($images)) {
//delete older images
$galleryArr = $db->runQuery("select * from " . GALLERY . " where property_id='" . $property_id . "' ");
foreach ($galleryArr as $galKey => $galVal) {
@unlink(SITE_ROOT . "images/property/" . $galVal['image_name']);
$db->delete(GALLERY, 'gallery_id = ' . $galVal['gallery_id']);
}
}
foreach ($images as $iKey => $iVals) {
$file_names = explode("/", $iVals);
$iVal = end($file_names);
$path = '/' . $file_names[0] . '/' . $file_names[1] . '/';
$file_name = urldecode(time() . "_" . $iVal);
$file_name = str_replace(' ', '_', $file_name);
if (!$this->debug) {
$validImage = getimagesize($_supplierData['resorthomesofflorida']['subscriber_image_url'] . $path . $iVal);
if (count($validImage) && is_array($validImage) && !empty($validImage)) {
$contentOrFalseOnFailure = file_get_contents($_supplierData['resorthomesofflorida']['subscriber_image_url'] . $path . $iVal);
} else {
$VAR = explode("_", $iVal);
$VAR = $VAR[0];
$secondary_img_url = str_replace('[VAR]', $VAR, $_supplierData['resorthomesofflorida']['subscriber_image_secondary_url']);
$contentOrFalseOnFailure = file_get_contents($secondary_img_url . $path . $iVal);
}
}
if (!$this->debug) {
$byteCountOrFalseOnFailure = file_put_contents(SITE_ROOT . "images/property/" . $file_name, $contentOrFalseOnFailure);
}
//saving data in database
$data_image = array();
$data_image['image_name'] = $file_name;
$data_image['property_id'] = $property_id;
$data_image['image_title'] = $caption;
if (!$this->debug) {
$db->save(GALLERY, $data_image);
}
}
break;
case 7:
$res = new Ellisexclusivevillas($_supplierData['ellisexclusivevillas']['subscriber_url']);
$res->getWebsite($xml_property_id);
//grab images functionality
$images = $res->getImageList($xml_property_id);
//echo "<pre>"; print_r($images); echo "</pre>";
$url = $_supplierData['ellisexclusivevillas']['subscriber_secondary_url'];
$data = array();
$data['xml_subscriber_id'] = $post['xml_subscriber_id'];
$data['xml_property_id'] = $post['xml_property_id'];
//get heading of the property
$heading = $res->getHeading($xml_property_id);
$data['xml_heading'] = $heading;
//get description part of the website
$description = $res->getDescription($xml_property_id);
$data['xml_description'] = $description;
//get features of the property
$features = $res->getFeatures($xml_property_id);
$data['xml_features'] = $features;
$data['xml_extras'] = '';
$data['xml_community'] = '';
//get rates
$rate = $res->getRates($xml_property_id, $url);
$data['xml_rating'] = $rate;
//get booked dates
$reservation = $res->getReservations($xml_property_id, $url);
$data['xml_property_id'] = $post['xml_property_id'];
$condition = " id= " . $property_id;
if (!$this->debug) {
$result = $db->modify(PROPERTY, $data, $condition);
}
if (!empty($reservation) && count($reservation)) {
$db->delete(CAL_AVAIL, "property_id = " . $property_id);
foreach ($reservation as $rKey => $rVal) {
$data_cal = array();
$data_cal['property_id'] = $property_id;
$date_from = explode('-', $rVal);
$data_cal['date_from'] = date('Y-m-d', strtotime($date_from[0]));
if (count($date_from) > 1) {
$data_cal['date_to'] = date('Y-m-d', strtotime($date_from[1]));
} else {
$data_cal['date_to'] = date('Y-m-d', strtotime($date_from[0]));
}
$data_cal['cal_status'] = '0';
if (!$this->debug) {
$db->save(CAL_AVAIL, $data_cal);
}
}
}
if (count($images) > 0 && is_array($images)) {
//delete older images
$galleryArr = $db->runQuery("select * from " . GALLERY . " where property_id='" . $property_id . "' ");
foreach ($galleryArr as $galKey => $galVal) {
@unlink(SITE_ROOT . "images/property/" . $galVal['image_name']);
$db->delete(GALLERY, 'gallery_id = ' . $galVal['gallery_id']);
}
}
foreach ($images as $iKey => $iVal) {
//pr($iVal);
//$file_name = explode("/", $iVal);
$file_name = urldecode(time() . "_" . $iVal);
$file_name = str_replace(' ', '_', $file_name);
if (!$this->debug) {
$validImage = getimagesize($_supplierData['ellisexclusivevillas']['subscriber_image_url'] . '/' . $iVal);
if (count($validImage) && is_array($validImage) && !empty($validImage)) {
$contentOrFalseOnFailure = file_get_contents($_supplierData['ellisexclusivevillas']['subscriber_image_url'] . '/' . $iVal);
} else {
$VAR = explode("_", $iVal);
$VAR = $VAR[0];
$secondary_img_url = str_replace('[VAR]', $VAR, $_supplierData['ellisexclusivevillas']['subscriber_image_secondary_url']);
$contentOrFalseOnFailure = file_get_contents($secondary_img_url . '/' . $iVal);
}
}
if (!$this->debug) {
$byteCountOrFalseOnFailure = file_put_contents(SITE_ROOT . "images/property/" . $file_name, $contentOrFalseOnFailure);
}
//saving data in database
$data_image = array();
$data_image['image_name'] = $file_name;
$data_image['property_id'] = $property_id;
// if ($iKey == 0)
// $data_image['image_title'] = $heading;
$data_image['image_title'] = $caption;
if (!$this->debug) {
$db->save(GALLERY, $data_image);
}
}
break;
default:
echo "Please choose proper subscriber first!!";
die;
}
}
$this->_redirect("property/editproperty/pptyId/" . $property_id . "/step/10");
}
echo "Please enter property id";
die;
}
public function ciirusbooking($xml_property_id, $arrivalDate, $departureDate, $guestArr)
{
__autoloadPlugin('Ciirus');
global $mySession;
$db = new Db();
$this->debug = false;
// $pptyArr = $db->runQuery("select * from " . PROPERTY . "
// inner join subscriber on subscriber.subscriber_id = " . PROPERTY . ".xml_subscriber_id
// where xml_subscriber_id > 0 ");
$res = new Ciirus("c346aeb90de54a3", "ff3a6f4e60ab4ec");
$reservation = $res->makeBooking($xml_property_id, $arrivalDate, $departureDate, $guestArr);
return $reservation;
}