// Data
$news = $newsDb->getAllWithDescById($id, $this->_languageId);
// $author = $newsDb->getAuthor($id,$this->_languageId)->toArray();
// $authorName = (empty($author))? '' : $author['name'];
//if content is empty, will be redirecting to list of news
if ($news['content']) {
//update viewer
//hanya increamen 1 saja setiap kali content detaul di load
// $newsDb->updateField($id,array('viewer'=>$news['viewer']+1));
// View
$this->view->news = $news;
$this->view->id = $id;
// $this->view->author = $authorName;
} else {
$this->_redirector->gotoUrl($this->view->baseUrl('/news/index/'));
}
}
/**
* IS : -
* FS : -
* Desc : controller untuk ! form
*/
/**
* IS: -
* FS: -
* Desc: Fungsi untuk generate RSS
*/
public function rssAction()
{
// Tidak pake layout
//$this->getResponse()->setHeader('Content-Type', 'text/xml');
$this->_helper->layout->disableLayout();
// Model
$newsDb = new Model_DbTable_News();
public function indexAction()
{
// params
$limit = 3;
// model
$destinationDb = new Model_DbTable_Destination();
$newsDb = new Model_DbTable_News();
$eventDb = new Model_DbTable_Event();
// data
$latestculture = $destinationDb->getLatestPost($limit);
$latestdraft = $destinationDb->getLatestDraft($limit);
$latestnews = $newsDb->getLatestPost($limit);
$latestnewsdraft = $newsDb->getLatestPost($limit);
$latestevent = $eventDb->getLatestPost($limit);
$latesteventdraft = $eventDb->getLatestDraft($limit);
$messages = $this->_helper->flashMessenger->getMessages();
// view
$this->view->latestdraft = $latestdraft;
$this->view->latestculture = $latestculture;
$this->view->latestnews = $latestnews;
$this->view->latestnewsdraft = $latestnewsdraft;
$this->view->latestevent = $latestevent;
$this->view->latesteventdraft = $latesteventdraft;
$this->view->messages = $messages;
}
/**
* IS: -
* FS: Mengirimkan ke viewer: destination, news, event, destSearchForm,
* activitySearchForm, highlight, video
* Desc: Fungsi untuk menampilkan halaman depan
*/
public function indexAction()
{
$this->_helper->layout->setLayout('kebudayaan');
// Form
$destSearchForm = new Form_DestSearchHomeForm();
$activitySearchForm = new Form_ActivitySearchHomeForm();
$destSearchForm->setNameLabel($this->view->translate('name'));
// Model
$destinationDb = new Model_DbTable_Destination();
$eventDb = new Model_DbTable_Event();
$highlightDb = new Model_DbTable_Highlight();
// $videoModel = new Model_Video;
$galleryModel = new Model_DbTable_Image();
// Data
$galleryHeader = $highlightDb->getGalleryHeader();
$featured_culture = $destinationDb->getFeaturedCulture($this->_languageId, 4);
//generate news
$news = $this->news->getLastNews($this->_languageId, 4);
$event = $eventDb->getFourClosestEvent($this->_languageId);
$highlightMed = $highlightDb->getMainType(2, $this->_languageId);
// $videos = $videoModel->getMostViewedVideos($startIndexVideo, $maxResultVideo);
$latestImage = $galleryModel->getTenLastImage(1, false, true);
$this->view->activeHeaders = $highlightDb->getActiveHeaders();
// Passing ke view
$this->view->galleryHeader = $galleryHeader;
$this->view->latestImage = $latestImage;
$this->view->featured_culture = $featured_culture;
$this->view->news = $news->toArray();
$this->view->event = $event;
$this->view->destSearchForm = $destSearchForm;
$this->view->useFeaturedSlideshow = true;
$this->view->featuredCulture = $featured_culture;
$this->view->activitySearchForm = $activitySearchForm;
$this->view->highlight = $highlightMed;
// $this->view->videos = $videos;
$this->view->languageID = $this->_languageId;
$this->view->useGoogleExperiment = true;
$this->view->langId = $this->_languageId;
$this->view->homepage = true;
$this->view->figures = $this->figure->findAll($this->_languageId, 2)->toArray();
}
/**
* IS: -
* FS: Mengirimkan ke viewer: destination, news, event, destSearchForm,
* activitySearchForm, highlight, video
* Desc: Fungsi untuk menampilkan halaman depan
*/
public function indexAction()
{
$this->_helper->layout->setLayout('kebudayaan');
// Model
$destinationDb = new Model_DbTable_Destination();
$eventDb = new Model_DbTable_Event();
$highlightDb = new Model_DbTable_Highlight();
// $videoModel = new Model_Video;
$galleryModel = new Model_DbTable_Image();
// Data
$galleryHeader = $highlightDb->getGalleryHeader();
$featured_culture = $destinationDb->getFeaturedCulture($this->_languageId, 4);
//generate news
$news = $this->news->getLastNews($this->_languageId, 4);
$event = $eventDb->getFourClosestEvent($this->_languageId);
$highlightMed = $highlightDb->getMainType(2, $this->_languageId);
// $videos = $videoModel->getMostViewedVideos($startIndexVideo, $maxResultVideo);
$latestImage = $galleryModel->getTenLastImage(1, false, true);
$activeHeaders = $highlightDb->getActiveHeaders($this->_languageId);
if (count($activeHeaders) == 0) {
$activeHeaders = $highlightDb->getActiveHeaders();
}
$this->view->activeHeaders = $activeHeaders;
// Passing ke view
$this->view->galleryHeader = $galleryHeader;
$this->view->latestImage = $latestImage;
$this->view->featured_culture = $featured_culture;
$this->view->news = $news->toArray();
$this->view->event = $event;
$this->view->useFeaturedSlideshow = true;
$this->view->featuredCulture = $featured_culture;
$this->view->highlight = $highlightMed;
// $this->view->videos = $videos;
$this->view->languageID = $this->_languageId;
$this->view->useGoogleExperiment = true;
$this->view->langId = $this->_languageId;
$this->view->homepage = true;
$this->view->figures = $this->figure->findAll($this->_languageId, 2)->toArray();
$this->view->headMeta()->appendName('keywords', join(', ', $this->_meta));
$this->view->headMeta()->appendName('description', "kebudayaanindonesia.net adalah laman referensi kebudayaan Indonesia untuk mewujudkan bangsa Indonesia yang cerdas dan berbudaya");
}
public function newsWidget($news_limit, $show_thumbnails = false, $side_space = true)
{
$language_id = Zend_Registry::get('languageId');
$cache = Zend_Registry::get('cache');
if (($widget = $cache->load('widget_news')) === false) {
$title = $this->view->translate('recent_news');
$tbl_news = new Model_DbTable_News();
$arr_news = $tbl_news->getLastNews($language_id, $news_limit)->toArray();
$list = "<ul>";
$thumbnails = '';
foreach ($arr_news as $news) {
$link = $this->view->baseUrl('news/detail/' . $news['id'] . '/' . $this->view->makeUrlFormat($news['title']));
if ($show_thumbnails) {
$source = 'default.jpg';
if (file_exists(UPLOAD_FOLDER . "news/{$news['image']}") && !empty($news['image'])) {
$source = "upload/news/{$news['image']}";
}
$thumbs = $this->view->imageUrl("timthumb.php?src={$source}&w=50&h=50&q=100");
$thumbnails = "<img src='{$thumbs}' class='thumbnail' alt='{$news['title']}' />";
}
$list .= "<li>{$thumbnails}<a href='{$link}'><span class='desc'>{$news['title']}</span></a></li>";
}
$list .= "</ul>";
$list .= "<div class='clear'></div>";
if ($side_space) {
$side_space_class = 'side-space';
}
$widget = <<<HTML
<div class="widget-half-list {$side_space_class}">
<h2>{$title}</h2>
{$list}
</div>
HTML;
$cache->save($widget);
}
return $widget;
}
public function newspagingAction()
{
$this->_helper->layout->disableLayout();
/* disable layout */
$this->_helper->viewRenderer->setNoRender(true);
/* supaya tidak render view */
$limit = $this->_getParam(urldecode('paramLimit'));
$offset = $this->_getParam(urldecode('paramOffset'));
$param = $this->_getParam(urldecode('paramKey'));
$generateNews = new Model_DbTable_News();
$getResultNews = $generateNews->searchNewsBaru($param, $limit, $offset, $this->_languageId);
//$getResultNews = $generateNews->searchNews($param,$limit,$offset,$this->_languageId);
$data['result'] = '';
foreach ($getResultNews as $rowNews) {
$title = $this->view->boldStyle(strtolower($rowNews['title']), $param);
$data['result'] .= '<li>';
$data['result'] .= '<a href="' . $this->_request->getBaseUrl() . '/' . $this->lang . '/news/detail/' . $rowNews['id'] . '/' . $this->view->makeUrlFormat($rowNews['title']) . '" title="' . $rowNews['title'] . '">' . ltrim($title) . '</a>';
$data['result'] .= '<br /><br />' . substr(strip_tags($this->view->htmlDecode($rowNews['content'])), 0, 225) . ' ...';
$data['result'] .= '</li>';
}
/* - - - - - - - - - - - link pages - - - - - - - - - - - - - - - - -*/
$action_query = $this->_getParam(urldecode('actionQuery'));
switch ($action_query) {
case 'next':
$curpageNews = $this->_getParam(urldecode('paramPage')) + 1;
break;
case 'prev':
$curpageNews = $this->_getParam(urldecode('paramPage')) - 1;
break;
default:
$curpageNews = $this->_getParam(urldecode('paramPage')) + 1;
break;
}
$num_linkNews = NUM_LINKS;
$per_pageNews = $limit;
$getTotalNews = $generateNews->numbRowsNews($param, $this->_languageId);
$num_pageNews = ceil($getTotalNews / $limit);
$startNews = $curpageNews - $num_linkNews > 0 ? $curpageNews - ($num_linkNews - 1) : 1;
$endNews = $curpageNews + $num_linkNews < $num_pageNews ? $curpageNews + $num_linkNews : $num_pageNews;
$data['start'] = $startNews;
$data['end'] = $endNews;
$data['per_pages'] = $per_pageNews;
$data['cur_pages'] = $curpageNews;
$data['all_page'] = $getTotalNews;
/* - - - - - - - - - - - end link pages - - - - - - - - - - - - - - -*/
$data['offset'] = $offset + $limit;
$data['curpages'] = $curpageNews;
echo json_encode($data);
}
/**
* IS: Parameter id terdeklarasi
* FS: Mengirimkan ke viewer: form, image, require_image, news_id
* Desc: Mengatur aksi yang dilakukan untuk halaman edit
*/
public function editAction()
{
$language_id = $this->_getParam('lang');
$news_id = $this->_getParam('id');
$form = new Admin_Form_NewsForm();
$table_news = new Model_DbTable_News();
$table_newsDesc = new Model_DbTable_NewsDesc();
$table_poitonews = new Model_DbTable_PoiToNews();
if ($this->getRequest()->isPost()) {
if ($form->isValid($_POST)) {
/** Preparing the date insert */
if ($language_id != 1) {
$indo = $table_newsDesc->checkForIndo($news_id);
if ($indo) {
$title = preg_replace("/'/", "'", $_POST['newsTitle']);
$content = preg_replace("/'/", "'", $_POST['newsContent']);
$data = array('news_id' => $news_id, 'language_id' => $language_id, 'title' => $title, 'content' => $content);
$table_newsDesc->updateNewsDescription($data, $news_id, $language_id);
} else {
$title = preg_replace("/'/", "'", $_POST['newsTitle']);
$content = preg_replace("/'/", "'", $_POST['newsContent']);
$data = array('news_id' => $news_id, 'language_id' => $language_id, 'title' => $title, 'content' => $content);
$table_newsDesc->insertNewsDescription($data);
}
} else {
$tUnixTime = time();
date_default_timezone_set('Asia/Jakarta');
$GMTMySqlString = date("Y-m-d H:i:s", $tUnixTime);
$GMTMySqlTimeString = date("H:i:s", $tUnixTime);
$publish_date = $_POST['newsPublishDate'] . ' ' . $GMTMySqlTimeString;
if ($_POST['newsImage']['name'] == '') {
$data = array('news_date' => $GMTMySqlString, 'publish_date' => $publish_date, 'showing' => $_POST['newsStatus']);
$this->_flash->addMessage('3\\Warning: Data is saved without image!');
} else {
$image = preg_replace("/'/", "'", $_POST['newsImage']);
$data = array('picture' => $image, 'news_date' => $GMTMySqlString, 'publish_date' => $publish_date, 'showing' => $_POST['newsStatus']);
}
$table_news->updateNews($data, $news_id);
$title = preg_replace("/'/", "'", $_POST['newsTitle']);
$content = preg_replace("/'/", "'", $_POST['newsContent']);
$data = array('title' => $title, 'content' => $content);
$table_newsDesc->updateNewsDescription($data, $news_id, $language_id);
$poi_count = $_POST['PoiCounter'];
$poi_stack = array();
for ($i = 0; $i < $poi_count; $i++) {
if (!empty($_POST['poiValue' . $i])) {
array_push($poi_stack, $_POST['poiValue' . $i]);
}
}
/**
* Get related poi list from the database
* and convert to a NON ASSOC Array
*/
$poi_list = $table_poitonews->getAllPoiByNewsId($news_id, $language_id);
$saved_poi = array();
if (!empty($poi_list)) {
foreach ($poi_list as $temp) {
array_push($saved_poi, $temp['poi_id']);
}
}
/**
* Check from the post list, compare with saved poi;
* if not exist then insert the new poi
*/
foreach ($poi_stack as $poi_id) {
if (!in_array($poi_id, $saved_poi)) {
$data = array('poi_id' => $poi_id, 'news_id' => $news_id);
$table_poitonews->insertPoiNews($data);
}
}
/**
* Do the complementary process,
* if the old poi did not exist in the new list
* then delete the old one
*/
foreach ($saved_poi as $old_poi) {
if (!in_array($old_poi, $poi_stack)) {
$table_poitonews->deletePoiNews($news_id, $old_poi);
}
}
}
$this->loggingaction('news', 'edit', $news_id, $language_id);
$this->_flash->addMessage("1\\News Update Success!");
$this->_redirect($this->view->rootUrl('/admin/news/'));
}
}
$image = $table_news->getPictureById($news_id);
if ($image == '') {
$this->view->require_image = TRUE;
} else {
$this->view->image = $image;
}
if ($language_id != 1) {
$indo = $table_newsDesc->checkForIndo($news_id);
if ($indo) {
$data = $table_news->getAllWithDescById($news_id, $language_id);
}
} else {
$data = $table_news->getAllWithDescById($news_id, $language_id);
}
$news_count = $table_poitonews->countPoiNewsByNewsId($news_id);
$date = explode(' ', $data['publish_date']);
$form->newsTitle->setValue($data['title']);
$form->newsContent->setValue($data['content']);
$form->newsImage->setValue($data['picture']);
$form->newsPublishDate->setValue($date[0]);
$form->PoiCounter->setValue($news_count);
$this->view->language_id = $language_id;
$this->view->form = $form;
$this->view->news_id = $news_id;
}
/**
* 内容查询
*
*/
public function searchAction()
{
//获取页面提交参数
$keyWord = urldecode($this->_request->getParam('keyWord'));
$page = $this->_request->getParam('page');
$this->view->keyWord = urlencode($keyWord);
//关键字数组
$keywordsStrArray = explode(' ', $keyWord);
$this->view->keywordsStrArray = $keywordsStrArray;
//开始查询
$array = array();
//新闻
$model = new Model_DbTable_News();
$infos = $model->findByLike($keyWord);
$tmpArray = array();
foreach ($infos as $info) {
$tmpArray['flag'] = 0;
$tmpArray['id'] = $info['id'];
$tmpArray['title'] = $info['title'];
$tmpArray['uncontent'] = $info['uncontent'];
$tmpArray['addtime'] = $info['addtime'];
array_push($array, $tmpArray);
}
//分页参数
if ($page == null) {
$page = 1;
}
$pageRange = 10;
$itemCountPerPage = 10;
//实例并构建Zend_Paginator对象
$paginatorAdapter = new Zend_Paginator_Adapter_Array($array);
$paginator = new Zend_Paginator($paginatorAdapter);
$paginator->setPageRange($pageRange)->setItemCountPerPage($itemCountPerPage)->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
//设置布局
$this->_helper->layout->disableLayout();
//页面信息
$this->view->title = '内容查询-' . $this->_config['pageInfo']['default']['title'];
}
$table_highlight = new Model_DbTable_Highlight();
$table_highlight_desc = new Model_DbTable_HighlightDescription();
$table_highlight_desc->deleteHighlight2($highlight_id);
$this->loggingaction('highlight', 'delete', $highlight_id);
$this->_flash->addMessage("1\\Highlight Indonesian Translation Delete Success!");
}
public function deletehighlightenglishAction()
{
$highlight_id = $this->_getParam('highlightid');
$table_highlight = new Model_DbTable_Highlight();
$table_highlight_desc = new Model_DbTable_HighlightDescription();
$table_highlight_desc->deleteHighlightenglish($highlight_id);
$this->loggingaction('highlight', 'delete', $highlight_id);
$this->_flash->addMessage("1\\Highlight Indonesian Translation Delete Success!");
}
/**
* IS: News ada
* FS: News tidak ada
* Desc: Fungsi untuk menghapus news dari basis data
*/
public function deletenewsAction()
public function contestmoreAction()
{
$uid = Zend_Registry::get('uid');
$id = $this->_request->getParam('id');
$this->view->dugaar = $id;
$q = $this->_request->getParam('q');
if ($q == 'signup') {
$this->view->is = 'signup';
}
if ($q == 'rating') {
$this->view->is = 'rating';
}
if ($q == 'davaa') {
$this->view->is = 'davaa';
}
$tmp = 0;
$davaas = new Model_DbTable_Davaa();
$this->view->davaa = $davaas->fetchAll($davaas->select()->where('fantasy_id =' . $id . ' AND active =' . $tmp));
$tmp = 1;
$this->view->davaaduussan = $davaas->fetchAll($davaas->select()->where('fantasy_id =' . $id . ' AND active =' . $tmp));
$fantasys = new Model_DbTable_Fantasy();
$fantasy = $fantasys->fetchAll($fantasys->select()->where('id=' . $id));
foreach ($fantasy as $key => $value) {
$this->view->fantasyname = $value['name'];
}
$users = new Model_DbTable_Users();
$this->view->user = $users->fetchAll($users->select());
$gals = new Model_DbTable_Gal();
$this->view->galuud = $gals->fetchAll($gals->select());
$this->view->gal = $gals->fetchAll($gals->select()->where('ezen_id =' . $uid));
$gald = $gals->fetchAll($gals->select()->where('ezen_id =' . $uid));
$gid = 0;
foreach ($gald as $key => $value) {
$gid = $value['id'];
}
$scores = new Model_DbTable_Score();
$this->view->rating = $scores->fetchAll($scores->select()->where('fantasyid =' . $id)->order('total_score DESC'));
$this->view->score = $scores->fetchAll($scores->select()->where('galid =' . $gid . ' AND fantasyid=' . $id));
$form = new Form_Comment();
$request = $this->getRequest();
if ($request->isPost()) {
if ($form->isValid($this->_request->getPost())) {
$content = $this->_request->getParam('commentbody');
$content = $this->check($content);
$uid = Zend_Registry::get('uid');
$date = date("Y-m-d H:i:s");
$uri = 'index/index/id/' . $id;
$comments = new Model_DbTable_Comment();
$comments->insert(array('uri' => $uri, 'content' => $content, 'uid' => $uid, 'date' => $date));
$this->_redirect('news/more/id/' . $id);
}
}
$form->setAction('../../index/index');
$this->view->form = $form;
$news = new Model_DbTable_News();
$this->view->news = $news->fetchAll($news->select()->where('isactive = 1')->order('isping DESC')->order('date DESC'));
$this->view->news1 = $news->fetchAll($news->select()->where('isactive = 0')->order('date DESC'));
$page = 0;
if ($this->_request->getParam("page") != null) {
$page = $this->_request->getParam("page");
}
$this->view->page = $page;
$q = $news->fetchAll($news->select()->where('isactive = 1')->order('isping DESC')->order('date DESC'));
$id = $this->_request->getParam('id');
$this->view->dugaar = $id;
$paginator = Zend_Paginator::factory($q);
$paginator->setItemCountPerPage("6")->setCurrentPageNumber($this->_getParam('page', 1));
$this->view->medee = $paginator;
$comments = new Model_DbTable_Comment();
$this->view->comment = $comments->fetchAll($comments->select()->order('date DESC'));
}
/**
* IS: Parameter id terdeklarasi
* FS: Mengirimkan ke viewer: form, image, require_image, news_id
* Desc: Mengatur aksi yang dilakukan untuk halaman edit
*/
public function editAction()
{
$language_id = $this->_getParam('lang');
$news_id = $this->_getParam('id');
$form = new Admin_Form_NewsForm();
$table_news = new Model_DbTable_News();
$table_newsDesc = new Model_DbTable_NewsDesc();
$table_poitonews = new Model_DbTable_PoiToNews();
$table_related_article_news = new Model_DbTable_RelatedArticleNews();
// untuk menampilkan list related link article yang berhubungan dengan
// content news
$related_news = $table_related_article_news->getByNewsId($news_id, $language_id);
$this->view->edit = 1;
$this->view->ralated_news = $related_news;
$this->view->news_id = $news_id;
if ($this->getRequest()->isPost()) {
if ($form->isValid($_POST)) {
/** Preparing the date insert */
if ($language_id == 1) {
// echo 'SINI';
// exit;
$indo = $table_newsDesc->checkForIndo($news_id, $language_id);
if ($indo) {
$title = preg_replace("/'/", "'", $_POST['newsTitle']);
$content = preg_replace("/'/", "'", $_POST['newsContent']);
$data = array('news_id' => $news_id, 'language_id' => $language_id, 'title' => $title, 'content' => $content);
$table_newsDesc->updateNewsDescription($data, $news_id, $language_id);
} else {
$title = preg_replace("/'/", "'", $_POST['newsTitle']);
$content = preg_replace("/'/", "'", $_POST['newsContent']);
$data = array('news_id' => $news_id, 'language_id' => $language_id, 'title' => $title, 'content' => $content);
$table_newsDesc->insertNewsDescription($data);
}
} else {
$tUnixTime = time();
date_default_timezone_set('Asia/Jakarta');
$GMTMySqlString = date("Y-m-d H:i:s", $tUnixTime);
$GMTMySqlTimeString = date("H:i:s", $tUnixTime);
$publish_date = $_POST['newsPublishDate'] . ' ' . $GMTMySqlTimeString;
if ($_POST['newsImage']['name'] == '') {
$data = array('news_date' => $GMTMySqlString, 'publish_date' => $publish_date, 'showing' => $_POST['newsStatus']);
$this->_flash->addMessage('3\\Warning: Data is saved without image!');
} else {
$image = preg_replace("/'/", "'", $_POST['newsImage']);
$data = array('picture' => $image, 'news_date' => $GMTMySqlString, 'publish_date' => $publish_date, 'showing' => $_POST['newsStatus']);
}
$table_news->updateNews($data, $news_id);
$title = preg_replace("/'/", "'", $_POST['newsTitle']);
$content = preg_replace("/'/", "'", $_POST['newsContent']);
$hasIndoDesc = $table_newsDesc->checkForIndo($news_id, $language_id);
if (empty($hasIndoDesc)) {
$data = array('news_id' => $news_id, 'language_id' => $language_id, 'title' => $title, 'content' => $content);
$table_newsDesc->insertNewsDescription($data);
} else {
$data = array('title' => $title, 'content' => $content);
$table_newsDesc->updateNewsDescription($data, $news_id, $language_id);
}
$poi_count = $_POST['PoiCounter'];
$poi_stack = array();
for ($i = 0; $i < $poi_count; $i++) {
if (!empty($_POST['poiValue' . $i])) {
array_push($poi_stack, $_POST['poiValue' . $i]);
}
}
/**
* Get related poi list from the database
* and convert to a NON ASSOC Array
*/
$poi_list = $table_poitonews->getAllPoiByNewsId($news_id, $language_id);
$saved_poi = array();
if (!empty($poi_list)) {
foreach ($poi_list as $temp) {
array_push($saved_poi, $temp['poi_id']);
}
}
/**
* Check from the post list, compare with saved poi;
* if not exist then insert the new poi
*/
foreach ($poi_stack as $poi_id) {
if (!in_array($poi_id, $saved_poi)) {
$data = array('poi_id' => $poi_id, 'news_id' => $news_id);
$table_poitonews->insertPoiNews($data);
}
}
/**
* Do the complementary process,
* if the old poi did not exist in the new list
* then delete the old one
*/
foreach ($saved_poi as $old_poi) {
if (!in_array($old_poi, $poi_stack)) {
$table_poitonews->deletePoiNews($news_id, $old_poi);
}
}
}
/* update related article */
// this part add related
if ($_POST['counterRelated'] > 0) {
$counter = $_POST['counterRelated'];
for ($i = 1; $i <= $counter; $i++) {
if (isset($_POST['label' . $i])) {
//cek existing data ke database
// jika data link dan label yang dikirim dari viwer blm ada di database, maka akan di simpan sebagai data baru
//cek akan bernilai true jika data blm ada didatabase
$cek = $table_related_article_news->cek_existing($_POST['label' . $i], $_POST['link' . $i], $language_id);
// print_r($cek);
if (!$cek or $cek == false) {
$data = array('news_id' => $news_id, 'label' => $_POST['label' . $i], 'link' => $_POST['link' . $i], 'language_id' => $language_id);
//print_r($data);
$table_related_article_news->insertRelated($data);
}
}
}
//exit;
}
// part untuk menghapus data dari database
// bagian inin akan dijalankan apabila ada request
// delete dari viewer
if ($_POST['counterDel'] > 0) {
$counterDel = $_POST['counterDel'];
for ($i = 1; $i <= $counterDel; $i++) {
if (isset($_POST['labeldel' . $i])) {
// cek terlebih dahulu ke database
// jika data yang sesuai dengan data yg dikirmkan ada
// maka lakukan penghapusan
$cek = $table_related_article_news->cek_existing_forDel($_POST['labeldel' . $i], $_POST['linkdel' . $i], $language_id);
}
}
}
$this->loggingaction('news', 'edit', $news_id, $language_id);
$this->_flash->addMessage("1\\News Update Success!");
$this->_redirect($this->view->rootUrl('/admin/newsindo/'));
}
}
$image = $table_news->getPictureById($news_id);
if ($image == '') {
$this->view->require_image = TRUE;
} else {
$this->view->image = $image;
}
// di uncomment
$setContent = true;
if ($language_id == 1) {
$indo = $table_newsDesc->checkForIndo($news_id, $language_id);
if ($indo) {
$data = $table_news->getAllWithDescById($news_id, $language_id);
// di uncomment
$setContent = true;
} else {
$data = $table_news->getAllWithDescById($news_id, 2);
}
} else {
$data = $table_news->getAllWithDescById($news_id, $language_id);
// di uncomment
if (empty($data)) {
$setContent = true;
//karena belum ada terjemahan dlm bahasa ini jadi form deskripsi dikosongkan
$data = $table_news->getAllWithDescById($news_id, 1);
}
}
$news_count = $table_poitonews->countPoiNewsByNewsId($news_id);
$date = explode(' ', $data['publish_date']);
$form->newsTitle->setValue($data['title']);
// if($setContent)
if ($language_id == 2) {
$form->newsContent->setValue($data['content']);
} else {
$form->newsContent->setValue('');
}
$form->newsImage->setValue($data['picture']);
$form->newsPublishDate->setValue($date[0]);
$form->PoiCounter->setValue($news_count);
// $this->view->language_id = $language_id;
$this->view->form = $form;
$this->view->news_id = $news_id;
}
public function approveAction()
{
$this->_helper->viewRenderer->setNoRender(true);
if ($this->_userInfo->canApprove) {
$tbl_news = new Model_DbTable_News();
$id = $this->_getParam('id');
$data = array("status" => Model_DbTable_News::PUBLISH);
$tbl_news->fetchRow(array("news_id = ?" => $id))->setFromArray($data)->save();
$this->_flashMessenger->addMessage('News approved successfully');
}
$this->_helper->redirector('index');
}
public function moreAction()
{
$id = $this->_request->getParam('id');
$this->view->iid = $id;
$news = new Model_DbTable_News();
$this->view->news = $news->fetchAll($news->select()->where('id = ' . $id . ' AND isactive = 1'));
}
