private function _getDescription($row)
{
// Variable
$baseUrl = Zend_Controller_Front::getInstance()->getBaseUrl();
// Kelas
$custom = new Budpar_Custom_Common();
// Data deskripsi destinasi
$description = $custom->truncate($row['description'], 200);
$description = strip_tags($description);
// Format url dari nama destinasi
$formatUrlName = $custom->makeUrlFormat($row['descname']);
// Tambahin read more
$description .= "<span class='read-more'><a onclick=window.open('" . $baseUrl . "/destination/" . $row['poi_id'] . "/" . $formatUrlName . "')>Read More »</a></span>";
return $description;
}
/**
*
* @param integer $poi_id
* @param integer $language_id
* @return array
*/
public function getAllByIdLang($poi_id, $language_id, $isPublish = true, $isApproved = false)
{
$custom = new Budpar_Custom_Common();
$query = $this->select()->from($this->_name, array('poi_id', 'pointX', 'pointY', 'address', 'phone', 'website', 'main_category', 'featured', 'popular', 'image', '(totalrate/totalrater) AS rating', 'totalrater'))->join($this->_poidesc, "{$this->_poidesc}.poi_id = {$this->_name}.poi_id", array('*'))->joinLeft(array("created" => $this->_account), "{$this->_poidesc}.created_by = created.admin_id", array('created_by' => 'IFNULL(created.name, created.username)'))->joinLeft(array("updated" => $this->_account), "{$this->_poidesc}.updated_by = updated.admin_id", array('updated_by' => 'IFNULL(updated.name, updated.username)'))->setIntegrityCheck(false)->where("{$this->_poidesc}.language_id = ?", $language_id)->where("{$this->_name}.poi_id = ?", $poi_id);
if ($isPublish) {
$query->where("{$this->_name}.status = ?", self::PUBLISH);
}
if ($isApproved) {
$query->where("{$this->_name}.status = ?", self::PENDING);
}
$check = $this->fetchRow($query);
if ($check != null) {
$data = $this->fetchRow($query)->toArray();
if ($data['name'] != null) {
if ($language_id != 2) {
if ($data['tagline']) {
$data['fullname'] = $custom->htmlDecode($data['name']) . ": " . $custom->htmlDecode($data['tagline']);
} else {
$data['fullname'] = $custom->htmlDecode($data['name']);
}
}
if ($data['description'] == null) {
$data['text'] = "Sorry, these destinations do not have a description in English";
}
return $data;
} else {
// $query2 = $this->select()
// ->from($this->_name, array('name'))
// ->where("{$this->_name}.poi_id = ?", $poi_id);
// $data2 = $this->fetchRow($query2)->toArray();
$data['fullname'] = "Maaf, destinasi ini belum memiliki terjemahan bahasa Indonesia";
if ($data['description'] == null) {
$data['text'] = "Maaf, destinasi ini belum memiliki terjemahan dalam bahasa Indonesia";
}
// echo '$data[]';
// echo $query->__toString();
return $data;
}
} else {
$query2 = $this->select()->from($this->_name, array('poi_id', 'pointX', 'pointY', 'address', 'phone', 'website', 'main_category', 'featured', 'popular', 'image', '(totalrate/totalrater) AS rating', 'totalrater'))->where("{$this->_name}.poi_id = ?", $poi_id);
$result = $this->fetchRow($query2);
if (count($result)) {
$data = $result->toArray();
} else {
$data = array();
$data['fullname'] = "Sorry, these destinations do not have a description in English";
$data['text'] = "Sorry, these destinations do not have a description in English";
}
return $data;
}
}
$this->_helper->viewRenderer->setNoRender(true);
// Param
$name = $this->_getParam('name');
// Model
$destDescDb = new Model_DbTable_DestinationDescription();
// Data
$destination = $destDescDb->getSearchByName($name, $this->_languageId);
$destinationData = $this->_createArrayDestination($destination);
echo json_encode($destinationData);
}
/**
* IS:
* FS:
* Desc: Fungsi untuk mendapatkan destinasi berdasarkan id yang diberikan
*/
public function destinationByIdAction()
{
// Tidak pake view
public function getAllByIdLangForIndo($poi_id, $language_id)
{
$custom = new Budpar_Custom_Common();
$query = $this->select()->from($this->_name, array('poi_id', 'pointX', 'pointY', 'address', 'phone', 'website', 'main_category', 'featured', 'popular', 'header_image', '(totalrate/totalrater) AS rating', 'totalrater'))->join($this->_poidesc, "{$this->_poidesc}.poi_id = {$this->_name}.poi_id", array('*', 'header_image as banner'))->setIntegrityCheck(false)->where("{$this->_poidesc}.language_id = ?", $language_id)->where("{$this->_name}.poi_id = ?", $poi_id);
$check = $this->fetchRow($query);
if ($check != null) {
$data = $this->fetchRow($query)->toArray();
if ($data['name'] != null) {
if ($language_id != 1) {
if ($data['tagline']) {
$data['fullname'] = $custom->htmlDecode($data['name']) . ": " . $custom->htmlDecode($data['tagline']);
} else {
$data['fullname'] = $custom->htmlDecode($data['name']);
}
}
if ($data['description'] == null) {
$data['text'] = "Maaf, destinasi ini belum memiliki terjemahan dalam bahasa Indonesia";
}
return $data;
} else {
$data['fullname'] = "Sorry, this destination does not have English translation";
if ($data['description'] == null) {
$data['text'] = "Sorry, this destination does not have English translation";
}
return $data;
}
} else {
$query2 = $this->select()->from($this->_name, array('poi_id', 'pointX', 'pointY', 'address', 'phone', 'website', 'main_category', 'featured', 'popular', 'header_image', '(totalrate/totalrater) AS rating', 'totalrater'))->where("{$this->_name}.poi_id = ?", $poi_id);
$data = $this->fetchRow($query2)->toArray();
$data['fullname'] = "Maaf, destinasi ini belum memiliki terjemahan dalam bahasa Indonesia";
$data['text'] = "Maaf, destinasi ini belum memiliki terjemahan dalam bahasa Indonesia";
return $data;
}
}
public function HtmlDecode($string, $mode = 1)
{
$custom = new Budpar_Custom_Common();
return $custom->htmlDecode($string, $mode);
}
/**
* Fungsi truncate
*
* @param string $fullcontent
* @param integer $character batasan karakter yg mau di-truncate
*
* @return string hasil yang sudah di-truncate
*/
public function truncate($fullcontent, $character = 85)
{
$custom = new Budpar_Custom_Common();
return $custom->truncate($fullcontent, $character);
}