function &getData() { // Load the data if (empty($this->_data)) { $query = ' SELECT * FROM #__hotelreservation_offers' . ' WHERE offer_id = ' . $this->_offer_id . ' AND hotel_id = ' . $this->_hotel_id; $this->_db->setQuery($query); $this->_data = $this->_db->loadObject(); } if (!$this->_data) { $this->_data = new stdClass(); $this->_data->hotel_id = 0; $this->_data->offer_id = 0; $this->_data->offer_code = null; $this->_data->offer_name = null; $this->_data->offer_description = null; $this->_data->offer_content = null; $this->_data->offer_other_info = null; $this->_data->offer_min_nights = null; $this->_data->offer_max_nights = null; $this->_data->type_price_type_extranights = null; $this->_data->type_price_extranights = null; $this->_data->offer_day_1 = null; $this->_data->offer_day_2 = null; $this->_data->offer_day_3 = null; $this->_data->offer_day_4 = null; $this->_data->offer_day_5 = null; $this->_data->offer_day_6 = null; $this->_data->offer_day_7 = null; $this->_data->offer_datas = null; $this->_data->offer_datae = null; $this->_data->offer_datasf = null; $this->_data->offer_dataef = null; $this->_data->offer_order = null; $this->_data->offer_reservation_cost_val = 7.5; $this->_data->offer_reservation_cost_proc = 0; $this->_data->offer_commission = 10; $this->_data->themes = null; $this->_data->selectedThemes = null; $this->_data->is_available = null; $this->_data->public = 0; $this->_data->pictures = array(); //check temporary files $pictures = makePathFile(JPATH_COMPONENT . PATH_OFFER_PICTURES . ($this->_data->offer_id + 0) . "/*.*"); $files = glob($pictures); if (is_array($files) && count($files) > 0) { sort($files); } $this->_data->pictures = array(); if (is_array($files) && count($files) > 0) { foreach ($files as $value) { $this->_data->pictures[] = array('offer_picture_info' => 'add from cache', 'offer_picture_path' => PATH_OFFER_PICTURES . ($this->_data->offer_id + 0) . '/' . basename($value), 'offer_picture_enable' => 1); } } } else { $this->_data->pictures = array(); //check temporary files $query = "\r\n\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t*\r\n\t\t\t\t\tFROM #__hotelreservation_offers_pictures\r\n\t\t\t\t\tWHERE offer_id =" . $this->_data->offer_id . "\r\n\t\t\t\t\tORDER BY offer_picture_id "; // dbg($query); //$this->_db->setQuery( $query ); $files =& $this->_getList($query); if (isset($files)) { foreach ($files as $value) { $this->_data->pictures[] = array('offer_picture_info' => $value->offer_picture_info, 'offer_picture_path' => $value->offer_picture_path, 'offer_picture_enable' => $value->offer_picture_enable); } } } $query = " \tSELECT \r\n\t\t\t\t\t\tr.room_id,\r\n\t\t\t\t\t\tr.room_name,\r\n\t\t\t\t\t\tr.max_adults,\r\n\t\t\t\t\t\tr.max_children,\t\r\n\t\t\t\t\t\t" . ($this->_offer_id > 0 ? "IF( ISNULL(ho.room_id), 0, 1 )" : "0") . "\t\t\t\t\t\tAS is_sel\t\t\t\t\t\t\t\r\n\t\t\t\t\tFROM #__hotelreservation_rooms r\r\n\t\t\t\t\t" . ($this->_offer_id > 0 ? "LEFT JOIN (\r\n\t\t\t\t\t\t\t select * from #__hotelreservation_offers_rooms o_r where o_r.offer_id = {$this->_offer_id} \r\n\t\t\t\t\t\t) ho on r.room_id = ho.room_id\r\n\t\t\t\t\t\t" : "") . "\r\n\t\t\t\t\tWHERE \r\n\t\t\t\t\t\tr.hotel_id = " . $this->_hotel_id . "\r\n\t\t\t\t\t\t"; //dbg($query); $this->_data->itemRooms =& $this->_getList($query); if (isset($this->_data->itemRooms)) { foreach ($this->_data->itemRooms as $k => $r) { //dbg($r); $query = "SELECT *\tFROM #__hotelreservation_offers_rates d where d.offer_id={$this->_offer_id} and d.room_id={$r->room_id}"; //dbg($query); $res =& $this->_getList($query); if (isset($res) && count($res) > 0) { foreach ($res as $d) { //$d->week_types = explode(',', $d->week_types); // dbg($d); $this->_data->itemRooms[$k]->discounts = $d; } } else { $discounts = new stdClass(); $discounts->id = 0; $discounts->offer_room_price_id = null; $discounts->offer_id = $this->_offer_id; $discounts->room_id = $r->room_id; $discounts->price_1 = null; $discounts->price_2 = null; $discounts->price_3 = null; $discounts->price_4 = null; $discounts->price_5 = null; $discounts->price_6 = null; $discounts->price_7 = null; $discounts->single_balancing = null; $discounts->child_price = null; $discounts->price_type = 1; $discounts->extra_night_price = null; $discounts->extra_pers_price = null; $discounts->base_adults = null; $discounts->base_children = null; $this->_data->itemRooms[$k]->discounts = $discounts; } } } //clean unnecessary files $files = glob(makePathFile(JPATH_COMPONENT . PATH_OFFER_PICTURES . $this->_data->offer_id . "/" . "*.*")); //dump($files); if (is_array($files) && count($files) > 0) { foreach ($files as $pic) { $is_find = false; foreach ($this->_data->pictures as $value) { if ($pic == makePathFile(JPATH_COMPONENT . $value['offer_picture_path'])) { $is_find = true; break; } } //if( $is_find == false ) // @unlink( $pic ); } } //~clean unnecessary files //dbg($this->_data->pictures); //~check temporary files //exit; $query = ' SELECT * FROM #__hotelreservation_offers_themes ORDER BY name'; $this->_data->themes =& $this->_getList($query); $query = ' SELECT * FROM #__hotelreservation_offers_themes_relation where offerId=' . $this->_data->offer_id; $this->_data->selectedThemes =& $this->_getList($query); $query = " SELECT * FROM #__hotelreservation_offers_vouchers where offerId = " . $this->_data->offer_id . " ORDER BY voucher"; $this->_data->vouchers =& $this->_getList($query); $this->_data->offer_datas = convertToFormat($this->_data->offer_datas); $this->_data->offer_datae = convertToFormat($this->_data->offer_datae); $this->_data->offer_datasf = convertToFormat($this->_data->offer_datasf); $this->_data->offer_dataef = convertToFormat($this->_data->offer_dataef); return $this->_data; }
function sendNoAvailabilityEmail() { $email = JText::_('LNG_NO_AVAILABILITY_EMAIL', true); //return false; //$config =& JFactory::getConfig(); //$this->itemAppSettings->sendmail_from = $config->get( 'config.mailfrom' ); //$this->itemAppSettings->sendmail_name = $config->get( 'config.fromname' ); $fromName = $this->itemAppSettings->company_name; //$mainframe->getCfg('fromname'); $confirmEmail = $this->itemAppSettings->company_email; //$mainframe->getCfg('fromname'); $datas = date("Y-m-d", mktime(0, 0, 0, $this->month_start, $this->day_start, $this->year_start)); $datae = date("Y-m-d", mktime(0, 0, 0, $this->month_end, $this->day_end, $this->year_end)); $datas = convertToFormat($datas); $datae = convertToFormat($datae); $mode = 1; //html $email = str_replace("<<hotel>>", $this->itemHotelSelected->hotel_name, $email); $email = str_replace("<<start_date>>", $datas, $email); $email = str_replace("<<end_date>>", $datae, $email); $email_subject = JText::_('LNG_NO_AVAILABILITY_EMAIL_SUBJECT', true); $email_subject = str_replace("<<hotel>>", $this->itemHotelSelected->hotel_name, $email_subject); JMail::sendMail($this->itemAppSettings->company_email, $this->itemAppSettings->company_name, $this->itemAppSettings->company_email, $email_subject, $email, $mode, null, array($this->itemHotelSelected->email)); }
echo "<table class='table table-striped table-bordered CSSTableGenerator' id='tblData' width='100%'>"; echo "<th>S.No</th>"; echo "<th>App ID</th>"; echo "<th>App Name</th>"; echo "<th>Version</th>"; echo "<th>Last Date of Build</th>"; echo "<th>Code Version</th>"; echo "<th>Queued</th>"; echo "<th>ScreenShots</th>"; echo "<th>Deployed</th>"; echo "<th>History</th>"; while ($row = $result->fetch_assoc()) { # code... $id = $row["android_app_id"]; $str = $row["date_of_build"]; $str = convertToFormat($str); if (!strcmp($row["queued"], "0")) { $var = "❌"; } else { # code... $var = "✅"; } $dep = "❌"; if (!strcmp($row["screenshots"], "No")) { $ss = "❌"; } else { # code... $ss = "✅"; } echo "<tr>"; echo "<td>" . $i . "</td>";
function &getData() { // Load the data if (empty($this->_data)) { $query = ' SELECT * FROM #__hotelreservation_packages' . ' WHERE package_id = ' . $this->_package_id; $this->_db->setQuery($query); $this->_data = $this->_db->loadObject(); } if (!$this->_data) { $this->_data = new stdClass(); $this->_data->package_id = null; $this->_data->hotel_id = null; $this->_data->package_name = null; $this->_data->package_type_price = null; $this->_data->package_price = null; $this->_data->package_price_1 = null; $this->_data->package_price_2 = null; $this->_data->package_price_3 = null; $this->_data->package_price_4 = null; $this->_data->package_price_5 = null; $this->_data->package_price_6 = null; $this->_data->package_price_7 = null; $this->_data->package_price_midweek = null; $this->_data->package_price_weekend = null; $this->_data->package_number = null; $this->_data->package_description = null; $this->_data->is_available = null; $this->_data->is_price_day = null; $this->_data->package_datas = null; $this->_data->package_datae = null; } if ($this->_data->is_price_day == false) { $this->_data->package_type_price = 1; } $this->_data->package_prices = null; $this->_data->package_prices[$this->_data->package_price_1][] = 1; $this->_data->package_prices[$this->_data->package_price_2][] = 2; $this->_data->package_prices[$this->_data->package_price_3][] = 3; $this->_data->package_prices[$this->_data->package_price_4][] = 4; $this->_data->package_prices[$this->_data->package_price_5][] = 5; $this->_data->package_prices[$this->_data->package_price_6][] = 6; $this->_data->package_prices[$this->_data->package_price_7][] = 7; $this->_data->package_datas = convertToFormat($this->_data->package_datas); $this->_data->package_datae = convertToFormat($this->_data->package_datae); if (JRequest::getVar('is_error') == "1") { //dbg($this->_data); $post = JRequest::get('post'); if (count($post) > 0) { foreach ($post as $key => $value) { //dbg($key.' >> '.$this->_data->$key.' | '.(property_exists($this->_data,$key)? "1" : "0")); if (property_exists($this->_data, $key)) { if (!is_array($value)) { $this->_data->{$key} = $value; } else { } } else { if (strpos($key, "package_price_day") !== false) { $this->_data->package_prices = array(); foreach ($post['package_price_day'] as $keyPos => $valPrice) { for ($day = 1; $day <= 7; $day++) { //dbg( 'price_day_'.$keyPos.'_'.($day) ); if (isset($post['day_' . $keyPos . '_' . $day])) { $this->_data->package_prices[$valPrice][] = $day; } } } } /*if( strpos($key, "room_number_datas") !== false ) { $key_new = str_replace("room_number_datas_", "", $key); if( !isset($this->_data->room_intervals_numbers[ $key_new ]) ) { $nr = new stdClass; $nr->room_interval_number_id = ''; $nr->room_id = ''; $nr->nrs = ''; $nr->nre = ''; $nr->datas = ''; $nr->datae = ''; $nr->datai = ''; $nr->is_ignore_duplicate = false; $this->_data->room_intervals_numbers[ $key_new] = $nr; } $this->_data->room_intervals_numbers[ $key_new ]->datas = $value; } else if( strpos($key, "room_number_datae") !== false ) { $key_new = str_replace("room_number_datae_", "", $key); if( !isset($this->_data->room_intervals_numbers[ $key_new ]) ) { $nr = new stdClass; $nr->room_interval_number_id = ''; $nr->room_id = ''; $nr->nrs = ''; $nr->nre = ''; $nr->datas = ''; $nr->datae = ''; $nr->datai = ''; $nr->is_ignore_duplicate = false; $this->_data->room_intervals_numbers[ $key_new] = $nr; } $this->_data->room_intervals_numbers[ $key_new ]->datae = $value; } else if( strpos($key, "room_number_datai") !== false ) { $key_new = str_replace("room_number_datai_", "", $key); if( !isset($this->_data->room_intervals_numbers[ $key_new ]) ) { $nr = new stdClass; $nr->room_interval_number_id = ''; $nr->room_id = ''; $nr->nrs = ''; $nr->nre = ''; $nr->datas = ''; $nr->datae = ''; $nr->datai = ''; $nr->is_ignore_duplicate = false; $this->_data->room_intervals_numbers[ $key_new] = $nr; } $this->_data->room_intervals_numbers[ $key_new ]->datai = $value; } else */ } } } } return $this->_data; }