public function init()
 {
     $this->_partner = new Model_DbTable_Partner();
     $this->_partnerDescription = new Model_DbTable_PartnerDescription();
     $this->filter = new Zend_Session_Namespace('filter');
     parent::init();
 }
{
    /**
     * IS: -
     * FS: -
     * Desc: Inisiasi fungsi parent
     */
    protected $filter;
 public function init()
 {
     $this->tbl_polling = new Model_DbTable_Polling();
     $this->tbl_answer = new Model_DbTable_Answer();
     $this->form = new Admin_Form_PollingForm();
     parent::init();
 }
 /**
  * IS: Terdeklarasinya filter dan param di session, dan page_row 
  * FS: Mengirimkan ke viewer: cleanUrl, message, filter_alert, page_row, 
  *     dan paginator
  * Desc: Mengatur aksi yang dilakukan untuk halaman index mail
  */
 public function indexAction()
 {
     /** User admin on current session */
     $session_user = '******' . $this->_userInfo->name . '*';
     /** Send this page url to the view */
     $this->view->cleanurl = $this->_cleanUrl;
     /** Get messages from CRUD process */
     $message = $this->_flash->getMessages();
     if (!empty($message)) {
         $this->view->message = $message;
     }
     /** Create table instance */
     $table_mail = new Model_DbTable_Mail();
     $select = $table_mail->getAllMailByRecipient($session_user);
     /** Get page row setting and send to the paginator control */
     $page_row = $this->_getParam('filterPageRow');
     $this->view->row = $page_row;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     /** Send data to the view */
     $this->view->paginator = $paginator;
 }
 /**
  * IS: Terdeklarasinya filter dan param di session, dan page_row 
  * FS: Mengirimkan ke viewer: cleanUrl, filter_alert, page_row, 
  *     dan paginator
  * Desc: Mengatur aksi yang dilakukan untuk halaman index log
  */
 public function indexAction()
 {
     /** Send this page url to the view */
     $this->view->cleanurl = $this->_cleanUrl;
     $new_search = FALSE;
     /** Create table instance */
     //        $table_log = new Model_DbTable_LogAdmin;
     if ($this->getRequest()->isPost()) {
         $post = $this->getRequest()->getPost();
         switch ($post['action']) {
             case 'filter':
                 $this->filter->log = $post['filter'];
                 break;
             case 'sort':
                 $this->filter->log = $post['filter'];
                 if ($this->filter->log['order'] == 'ASC') {
                     $this->filter->log['order'] = 'DESC';
                 } else {
                     $this->filter->log['order'] = 'ASC';
                 }
                 break;
             case 'reset':
                 $this->filter->unsetAll();
                 break;
             default:
                 break;
         }
     }
     $filter = $this->_paginator_sess->filter;
     $param = $this->_paginator_sess->param;
     $select = $this->log->getQueryAll($this->filter->log, $param);
     $data = $this->log->fetchAll($select);
     /** Get page row setting and send to the paginator control */
     $page_row = $this->_getParam('filterPageRow');
     $this->view->row = $page_row;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     $pageNumber = $this->_getParam('page');
     $log = Zend_Paginator::factory($select);
     $log->setCurrentPageNumber($pageNumber);
     $log->setItemCountPerPage(5);
     if (null != $this->filter->log['row']) {
         $log->setItemCountPerPage($this->filter->log['row']);
     }
     /**
      * If this is a new search
      * then return the page number back to the 1st page
      */
     if ($new_search) {
         $paginator->setCurrentPageNumber(1);
     }
     /** Send data to the view */
     $this->view->paginator = $paginator;
     $this->view->log = $log;
     $this->view->filter = $this->filter->log;
 }
 public function init()
 {
     $this->_form = new Admin_Form_ArticleForm();
     $this->_article = new Admin_Model_DbTable_Article();
     $this->_description = new Admin_Model_DbTable_ArticleDescription();
     $this->_filter = new Zend_Session_Namespace('filter');
     parent::init();
 }
 /**
  * IS: -
  * FS: -
  * Desc: Inisiasi fungsi parent
  */
 public function init()
 {
     $this->event = new Model_DbTable_Event();
     $this->event_description = new Model_DbTable_EventDesc();
     $this->filter = new Zend_Session_Namespace('filter');
     parent::init();
     $this->view->image_dir_type = 3;
 }
 /**
  * IS: Terdeklarasinya filter dan param di session, dan page_row 
  * FS: Mengirimkan ke viewer: cleanUrl, message, filter_alert, page_row, 
  *     dan paginator
  * Desc: Mengatur aksi yang dilakukan untuk halaman index image
  */
 public function indexAction()
 {
     //variable initiation and instance creation
     $this->view->cleanurl = $this->_cleanUrl;
     $table_gallery = new Model_DbTable_Image();
     $message = $this->_flash->getMessages();
     if (!empty($message)) {
         $this->view->message = $message;
     }
     $filter = null;
     $new_search = FALSE;
     if ($this->getRequest()->isPost()) {
         $filter = $_POST['filterPage'];
         $this->_paginator_sess->imagefilter = $filter;
         $new_search = TRUE;
         switch ($filter) {
             case 0:
                 $param = null;
                 break;
             case 1:
                 $param = $_POST['filterTitle'];
                 break;
             case 2:
                 $param = $_POST['filterPoi'];
                 break;
         }
         $this->_paginator_sess->param = $param;
     }
     $filter = $this->_paginator_sess->imagefilter;
     $param = $this->_paginator_sess->param;
     /** Return alert to view on filter selected */
     switch ($filter) {
         case 0:
             $filter_alert = "Show all images";
             break;
         case 1:
             $filter_alert = "Images which name with keyword '" . $param . "'";
             break;
         case 2:
             $filter_alert = "Images that related to '" . $param . "'";
             break;
     }
     $this->view->alert = $filter_alert;
     $select = $table_gallery->getQueryAllByLang($filter, $param);
     //get pagerow setting and send to the paginator control
     $page_row = $this->_getParam('filterPageRow');
     $this->view->row = $page_row;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     if ($new_search) {
         $paginator->setCurrentPageNumber(1);
     }
     $this->view->paginator = $paginator;
 }
 public function init()
 {
     $this->form = new Admin_Form_FigureForm();
     $this->figure = new Admin_Model_DbTable_Figure();
     $this->figure_description = new Admin_Model_DbTable_FigureDescription();
     $this->filter_session = new Zend_Session_Namespace('filter');
     $this->form->image->setDestination(UPLOAD_FOLDER . 'figure/');
     parent::init();
 }
 /**
  * IS: Terdeklarasinya filter dan param di session, dan page_row
  * FS: Mengirimkan ke viewer: cleanUrl, message, filter_alert, page_row,
  *     dan paginator
  * Desc: Mengatur aksi yang dilakukan untuk halaman index promotional
  *       materials
  */
 public function indexAction()
 {
     $this->view->cleanurl = $this->_cleanUrl;
     /** get messages from CRUD process */
     $message = $this->_flash->getMessages();
     if (!empty($message)) {
         $this->view->message = $message;
     }
     /** set variable initial value */
     $filter = null;
     $new_search = FALSE;
     /** get params for the filter */
     if ($this->getRequest()->isPost()) {
         $filter = $_POST['filterPage'];
         $new_search = TRUE;
         switch ($filter) {
             case 0:
                 $param = null;
                 break;
             case 1:
                 $param = $this->_getParam('filterTitle');
                 break;
         }
         $this->_paginator_sess->filter = $filter;
         $this->_paginator_sess->param = $param;
     }
     $filter = $this->_paginator_sess->filter;
     $param = $this->_paginator_sess->param;
     /** Return alert to view on filter selected */
     switch ($filter) {
         case 0:
             $filter_alert = "Show all promotional materials";
             break;
         case 1:
             $filter_alert = "Promotional materials which title with keyword '" . $param . "'";
             break;
     }
     $this->view->alert = $filter_alert;
     $material_desc = new Model_DbTable_MaterialDescription();
     $select = $material_desc->getQueryAll($filter, $param, 2);
     /** get pagerow setting and send to the paginator control */
     $page_row = $this->_getParam('filterPageRow');
     $this->view->row = $page_row;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     /**
      * if this is a new search
      * then return the page number back to the 1st page
      */
     if ($new_search) {
         $paginator->setCurrentPageNumber(1);
     }
     $this->view->paginator = $paginator;
 }
 public function init()
 {
     $this->news = new Admin_Model_DbTable_News();
     $this->newsDescription = new Admin_Model_DbTable_NewsDescription();
     $this->form = new Admin_Form_NewsForm();
     $this->filter = new Zend_Session_Namespace('filter');
     $this->form->image->setDestination(UPLOAD_FOLDER . 'news/');
     parent::init();
 }
 public function indexAction()
 {
     //variable initiation and instance creation
     $this->view->cleanurl = $this->_cleanUrl;
     $language_id = 1;
     $tablePhotoEssay = new Model_DbTable_Photoessay();
     //get messages from CRUD process
     $message = $this->_flash->getMessages();
     if (!empty($message)) {
         $this->view->message = $message;
     }
     $filterEssay = null;
     $new_search = FALSE;
     if ($this->getRequest()->isPost()) {
         $filterEssay = $_POST['filterPage'];
         $new_search = TRUE;
         switch ($filter) {
             case 0:
                 $param = null;
                 break;
             case 1:
                 $param = $_POST['filterTitle'];
                 break;
         }
         $this->_paginator_sess->filter = $filterEssay;
         $this->_paginator_sess->param = $param;
     }
     //get the params from session and create paginator
     $filter = $this->_paginator_sess->filter;
     $param = $this->_paginator_sess->param;
     /** Return alert to view on filter selected */
     switch ($filter) {
         case 0:
             $filter_alert = "Show all Photo Essay";
             break;
         case 1:
             $filter_alert = "Photo Essay which title with keyword '" . $param . "'";
             break;
     }
     $this->view->alert = $filter_alert;
     $select = $tablePhotoEssay->getQueryAllByLanguage($filter, $param, $language_id);
     //get pagerow setting and send to the paginator control
     $page_row = $this->_getParam('filterPageRow');
     $this->view->row = $page_row;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     //if this is a new search then return the page number back to the 1st page
     if ($new_search) {
         $paginator->setCurrentPageNumber(1);
     }
     //send data to the view
     $this->view->paginator = $paginator;
 }
 /**
  * IS: Terdeklarasinya filter dan param di session, dan page_row
  * FS: Mengirimkan ke viewer: cleanUrl, message, filter_alert, page_row,
  *     dan paginator
  * Desc: Mengatur aksi yang dilakukan untuk halaman index tour packages
  */
 public function indexAction()
 {
     //variable initiation and instance creation
     $language_id = 1;
     $this->view->cleanurl = $this->_cleanUrl;
     $table_package = new Model_DbTable_Package();
     //get messages from CRUD process
     $message = $this->_flash->getMessages();
     if (!empty($message)) {
         $this->view->message = $message;
     }
     //set variable initial value
     $filter = null;
     $new_search = FALSE;
     //get params for the filter
     if ($this->getRequest()->isPost()) {
         $filter = $_POST['filterPage'];
         $new_search = TRUE;
         $this->_paginator_sess->filter = $filter;
         switch ($filter) {
             case 0:
                 $param = null;
             case 1:
                 $param = $_POST['filterTitle'];
                 break;
         }
         $this->_paginator_sess->param = $param;
     }
     //set paginator for list of destination data
     $filter = $this->_paginator_sess->filter;
     $param = $this->_paginator_sess->param;
     /** Return alert to view on filter selected */
     switch ($filter) {
         case 0:
             $filter_alert = "Show all tour packages";
             break;
         case 1:
             $filter_alert = "Tour packages which name with keyword '" . $param . "'";
             break;
     }
     $this->view->alert = $filter_alert;
     $select = $table_package->getQueryAllByLanguage($filter, $param);
     //get pagerow setting and send to the paginator control
     $page_row = $this->_getParam('filterPageRow');
     $this->view->row = $page_row;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     //send variables to the view class
     $this->view->paginator = $paginator;
 }
 /**
  * IS: Terdeklarasinya page_row 
  * FS: Mengirimkan ke viewer: cleanUrl, message, page_row, dan paginator
  * Desc: Mengatur aksi yang dilakukan untuk halaman index role
  */
 public function indexAction()
 {
     /** Send this page url to the view */
     $this->view->cleanurl = $this->_cleanUrl;
     /** Get messages from CRUD process */
     $message = $this->_flash->getMessages();
     if (!empty($message)) {
         $this->view->message = $message;
     }
     /** Create table instance */
     $select = $this->role->getQueryAll();
     $pageNumber = $this->_getParam('page');
     /** Get page row setting and send to the paginator control */
     if ($this->getRequest()->isPost()) {
         $post = $this->getRequest()->getPost();
         switch ($post['action']) {
             case 'filter':
                 $this->filter->role = $post['filter'];
                 break;
             case 'sort':
                 $this->filter->role = $post['filter'];
                 if ($this->filter->role['order'] == 'ASC') {
                     $this->filter->role['order'] = 'DESC';
                 } else {
                     $this->filter->role['order'] = 'ASC';
                 }
                 break;
             case 'reset':
                 $this->filter->unsetAll();
                 break;
             default:
                 break;
         }
     }
     $page_row = $this->_getParam('filterPageRow');
     $role = Zend_Paginator::factory($select);
     $role->setCurrentPageNumber($pageNumber);
     $role->setItemCountPerPage(5);
     if (null != $this->filter->role['row']) {
         $role->setItemCountPerPage($this->filter->role['row']);
     }
     $this->view->row = $page_row;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     /** Send data to the view */
     $this->view->paginator = $paginator;
     $this->view->role = $role;
 }
 /**
  * IS: Terdeklarasinya filter dan param di session, dan page_row
  * FS: Mengirimkan ke viewer: cleanUrl, message, page_row, paginator,
  *     dan filter_alert
  * Desc: Mengatur aksi yang dilakukan untuk halaman index
  */
 public function indexAction()
 {
     //get messages from CRUD process
     $airlines = new Model_DbTable_Airlines();
     $message = $this->_flash->getMessages();
     $this->view->cleanurl = $this->_cleanUrl;
     if (!empty($message)) {
         $this->view->message = $message;
     }
     $filter = null;
     $new_search = FALSE;
     //get params for the filter
     if ($this->getRequest()->isPost()) {
         $filter = $_POST['filterPage'];
         $new_search = TRUE;
         $this->_paginator_sess->filter = $filter;
         switch ($filter) {
             case 0:
                 $param = null;
                 break;
             case 1:
                 $param = $this->_getParam('filterName');
                 break;
         }
         $this->_paginator_sess->param = $param;
     }
     switch ($filter) {
         case 0:
             $filter_alert = "Show all airlines";
             break;
         case 1:
             $filter_alert = "airlines which name with keyword '" . $param . "'";
             break;
     }
     $this->view->alert = $filter_alert;
     $select = $airlines->getAllQuery($filter, $param, 2);
     //get pagerow setting and send to the paginator control
     $page_row = $this->_getParam('filterPageRow');
     $this->view->row = $page_row;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     //if this is a new search then return the page number back to the 1st page
     if ($new_search) {
         $paginator->setCurrentPageNumber(1);
     }
     $this->view->paginator = $paginator;
 }
 /**
  * IS: -
  * FS: Mengirimkan ke viewer: message dan paginator
  * Desc: Mengatur aksi yang dilakukan untuk halaman index page
  */
 public function indexAction()
 {
     //variable initiation and instance creation
     $language_id = 1;
     $table_page = new Model_DbTable_StaticContent();
     //get messages from CRUD process
     $message = $this->_flash->getMessages();
     if (!empty($message)) {
         $this->view->message = $message;
     }
     $select = $table_page->getSelectAllByLangId($language_id);
     $paginator = parent::setPaginator($select, 20);
     //send variables to the view class
     $this->view->paginator = $paginator;
 }
 /**
  * IS: Terdeklarasinya filter dan param di session, dan page_row
  * FS: Mengirimkan ke viewer: cleanUrl, message, filter_alert, page_row,
  *     filterdata, dan paginator
  * Desc: Mengatur aksi yang dilakukan untuk halaman index related links
  */
 public function indexAction()
 {
     //variable initiation and instance creation
     $this->view->cleanurl = $this->_cleanUrl;
     $table_related = new Model_DbTable_Related();
     $table_reldesc = new Model_DbTable_RelatedDescription();
     $filter_data = $table_reldesc->getAllTypeDescIndo();
     $this->view->related_type = $filter_data;
     //get messages from CRUD process
     $message = $this->_flash->getMessages();
     if (!empty($message)) {
         $this->view->message = $message;
     }
     //set variable initial value
     $filter = null;
     $new_search = FALSE;
     //get params for the filter
     if ($this->getRequest()->isPost()) {
         $new_search = TRUE;
         $param = $_POST['filterType'];
         $this->_paginator_sess->param = $param;
     }
     //set paginator for list of destination data
     $param = $this->_paginator_sess->param;
     $select = $table_reldesc->getQueryAll($param, 2);
     //get pagerow setting and send to the paginator control
     $page_row = $this->_getParam('filterPageRow');
     $this->view->row = $page_row;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     if ($new_search) {
         $paginator->setCurrentPageNumber(1);
     }
     //send variables to the view class
     $this->view->paginator = $paginator;
     /** Return alert to view on filter selected */
     if ($new_search or !empty($param)) {
         foreach ($filter_data as $key => $value) {
             $parent[$key] = $value;
         }
         $filter_alert = "Related links with '" . $parent[$param] . "' category";
         $this->view->alert = $filter_alert;
     }
 }
 /**
  * IS: Terdeklarasinya filter dan param di session, dan page_row
  * FS: Mengirimkan ke viewer: cleanUrl, message, page_row, filter, paginator
  * Desc: Mengatur aksi yang dilakukan untuk halaman list comment
  */
 public function indexAction()
 {
     /** Send this page url to the view */
     $this->view->cleanurl = $this->_cleanUrl;
     /** Get messages from CRUD process */
     $message = $this->_flash->getMessages();
     if (!empty($message)) {
         $this->view->message = $message;
     }
     /** Create table instance */
     $table_comment = new Model_DbTable_Comment();
     /** Set the variable initial value */
     $new_search = FALSE;
     /** Get the filter params */
     if ($this->getRequest()->isPost()) {
         /** If new search is commited then we set the $new_search to TRUE */
         $new_search = TRUE;
         $this->_paginator_sess->filter = $_POST['filterPage'];
     }
     /** Get the params from session and create paginator */
     $filter = $this->_paginator_sess->filter;
     $filter == 0 ? $filter = 1 : $filter;
     $select = $table_comment->getQueryAll($filter);
     /** Get page row setting and send to the paginator control */
     $page_row = $this->_getParam('filterPageRow');
     $this->view->row = $page_row;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     /**
      * If this is a new search
      * then return the page number back to the 1st page
      */
     if ($new_search) {
         $paginator->setCurrentPageNumber(1);
     }
     /** Send data to the view */
     $this->view->filter = array('filter' => $filter);
     $this->view->paginator = $paginator;
     $authorlist = $table_comment->getByAuthor(1);
     $this->view->author_list = $authorlist;
 }
 /**
  * IS: Terdeklarasinya filter dan param di session, dan page_row
  * FS: Mengirimkan ke viewer: cleanUrl, message, filter_alert, page_row,
  *     all_category, dan paginator
  * Desc: Mengatur aksi yang dilakukan untuk halaman index event
  */
 public function indexAction()
 {
     //variable initiation and instance creation
     $this->view->cleanurl = $this->_cleanUrl;
     //get messages from CRUD process
     $message = $this->_flash->getMessages();
     if (!empty($message)) {
         $this->view->message = $message;
     }
     //create table instances
     $table_event = new Model_DbTable_Event();
     $table_category = new Model_DbTable_Category();
     //set variable initial value
     $filter = null;
     $new_search = FALSE;
     //get params for the filter
     if ($this->getRequest()->isPost()) {
         $filter = $_POST['filterPage'];
         $new_search = TRUE;
         $this->_paginator_sess->filter = $filter;
         switch ($filter) {
             case 0:
                 $param = null;
             case 1:
                 $param = $_POST['filterName'];
                 break;
             case 2:
                 $param = $_POST['filterDestination'];
                 break;
             case 3:
                 $param = $_POST['filterCategory'];
                 break;
             case 4:
                 $param = $_POST['filterDate1'];
                 $param2 = $_POST['filterDate2'];
                 break;
         }
         $this->_paginator_sess->param = $param;
     }
     //set paginator for list of destination data
     $filter = $this->_paginator_sess->filter;
     $param = $this->_paginator_sess->param;
     if (isset($param2)) {
         $select = $table_event->getQueryAllByLang($filter, $param, $param2, 2);
     } else {
         $select = $table_event->getQueryAllByLang($filter, $param, null, 2);
     }
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     //if this is a new search then return the page number back to the 1st page
     if ($new_search) {
         $paginator->setCurrentPageNumber(1);
     }
     //send data to the view
     $this->view->paginator = $paginator;
     $filter_data = $table_category->getAllParentCategoryIdNameByLangId(2);
     $this->view->all_category = $filter_data;
     /** Return alert to view on filter selected */
     switch ($filter) {
         case 0:
             $filter_alert = "Show all events";
             break;
         case 1:
             $filter_alert = "Events which name with keyword '" . $param . "'";
             break;
         case 2:
             $filter_alert = "Events that related to '" . $param . "'";
             break;
         case 3:
             foreach ($filter_data as $category) {
                 $parent[$category['category_id']] = $category['name'];
             }
             $filter_alert = "Events with '" . $parent[$param] . "' category";
             break;
         case 4:
             if (!empty($param) && !empty($param2)) {
                 $filter_alert = "Events between " . $param . " and " . $param2;
             } else {
                 if (!empty($param) && empty($param2)) {
                     $filter_alert = "Events after " . $param;
                 } else {
                     if (empty($param) && !empty($param2)) {
                         $filter_alert = "Events before " . $param2;
                     } else {
                         $filter_alert = "Show all events";
                     }
                 }
             }
             break;
     }
     $this->view->alert = $filter_alert;
 }
 /**
  * IS: -
  * FS: -
  * Desc: Inisiasi fungsi parent
  */
 public function init()
 {
     parent::init();
 }
 /**
  * IS: Terdeklarasinya filter dan param di session, dan page_row 
  * FS: Mengirimkan ke viewer: cleanUrl, message, filter_alert, page_row, 
  *     dan paginator
  * Desc: Mengatur aksi yang dilakukan untuk halaman index review
  */
 public function indexAction()
 {
     /** Send this page url to the view */
     $this->view->cleanurl = $this->_cleanUrl;
     /** Get messages from CRUD process */
     $message = $this->_flash->getMessages();
     if (!empty($message)) {
         $this->view->message = $message;
     }
     /** Create table instance */
     $table_review = new Model_DbTable_Review();
     /** Set the variable initial value */
     $filter = null;
     $new_search = FALSE;
     /** Get the filter params */
     if ($this->getRequest()->isPost()) {
         $filter = $_POST['filterPage'];
         /** If new search is commited then we set the $new_search to TRUE */
         $new_search = TRUE;
         switch ($filter) {
             case 0:
                 $param = null;
                 break;
             case 1:
                 $param = $_POST['filterTitle'];
                 break;
             case 2:
                 $param = $_POST['filterStatus'];
                 break;
         }
         $this->_paginator_sess->filter = $filter;
         $this->_paginator_sess->param = $param;
     }
     /** Get the params from session and create paginator */
     $filter = $this->_paginator_sess->filter;
     $param = $this->_paginator_sess->param;
     /** Return alert to view on filter selected */
     switch ($filter) {
         case 0:
             $filter_alert = "Show all reviews";
             break;
         case 1:
             $filter_alert = "Reviews which title with keyword '" . $param . "'";
             break;
         case 2:
             $param == '1' ? $state = 'Shown' : ($state = 'Not Shown');
             $filter_alert = "Reviews with '" . $state . "' status";
             break;
     }
     $this->view->alert = $filter_alert;
     $select = $table_review->getQueryAll($filter, $param);
     /** Get page row setting and send to the paginator control */
     $page_row = $this->_getParam('filterPageRow');
     $this->view->row = $page_row;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     /**
      * If this is a new search
      * then return the page number back to the 1st page
      */
     if ($new_search) {
         $paginator->setCurrentPageNumber(1);
     }
     /** Send data to the view */
     $this->view->paginator = $paginator;
 }
 * ajax di CMS admin
 */
require_once 'Zend/Controller/Action.php';
class Admin_AjaxController extends Library_Controller_Backend
{
    /**
 /**
  * IS: -
  * FS: -
  * Desc: Inisiasi fungsi parent
  */
 public function init()
 {
     $this->filter = new Zend_Session_Namespace('filter');
     parent::init();
 }
 /**
  * IS: Terdeklarasinya filter dan param di session, dan page_row
  * FS: Mengirimkan ke viewer: cleanUrl, message, filter_alert, page_row,
  *     year_list, dan paginator
  * Desc: Mengatur aksi yang dilakukan untuk halaman index news
  */
 public function indexAction()
 {
     /** Send this page url to the view */
     $this->view->cleanurl = $this->_cleanUrl;
     /** Get messages from CRUD process */
     $message = $this->_flash->getMessages();
     if (!empty($message)) {
         $this->view->message = $message;
     }
     /** Create table instance */
     $table_news = new Model_DbTable_News();
     /** Set the variable initial value */
     $filter = null;
     $new_search = FALSE;
     /** Get the filter params */
     if ($this->getRequest()->isPost()) {
         $param_month = null;
         $filter = $_POST['filterPage'];
         /** If new search is commited then we set the $new_search to TRUE */
         $new_search = TRUE;
         $this->_paginator_sess->filter = $filter;
         switch ($filter) {
             case 0:
                 $param = null;
                 break;
             case 1:
                 $param = $_POST['filterTitle'];
                 break;
             case 2:
                 $param = $_POST['filterPoi'];
                 break;
             case 3:
                 $param = $_POST['filterYear'];
                 $param_month = $this->_getParam('filterMonth');
                 break;
             case 4:
                 $param = $_POST['filterStatus'];
                 break;
         }
         $this->_paginator_sess->param = $param;
         if ($param_month != null) {
             $this->_paginator_sess->param_month = $param_month;
         }
     }
     /** Get the params from session and create paginator */
     $filter = $this->_paginator_sess->filter;
     $param = $this->_paginator_sess->param;
     $param_month = $this->_paginator_sess->param_month;
     /** Return alert to view on filter selected */
     switch ($filter) {
         case 0:
             $filter_alert = "Show all news";
             break;
         case 1:
             $filter_alert = "News which title with keyword '" . $param . "'";
             break;
         case 2:
             $filter_alert = "News that related to '" . $param . "'";
             break;
         case 3:
             $filter_alert = "News that published on " . strftime("%B", strtotime($param_month . "/29/1985")) . " " . $param . "";
             break;
         case 4:
             $param == '1' ? $state = 'Published' : ($state = 'Draft');
             $filter_alert = "News with '" . $state . "' status";
             break;
     }
     $this->view->alert = $filter_alert;
     $select = $table_news->getQueryAllByLanguage($filter, $param, $param_month);
     /** Get page row setting and send to the paginator control */
     $page_row = $this->_getParam('filterPageRow');
     $this->view->row = $page_row;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     /**
      * If this is a new search
      * then return the page number back to the 1st page
      */
     if ($new_search) {
         $paginator->setCurrentPageNumber(1);
     }
     /** Send data to the view */
     $this->view->year_list = $table_news->getPublishYear();
     $this->view->paginator = $paginator;
 }
 /**
  * IS: Terdeklarasinya filter dan param di session, dan page_row
  * FS: Mengirimkan ke viewer: cleanUrl, message, page_row, filter_alert, 
  *     paginator, countId
  * Desc: Mengatur aksi yang dilakukan untuk halaman index
  */
 public function indexAction()
 {
     /** Get messages from CRUD process */
     $pageNumber = $this->_getParam('page');
     $message = $this->_flash->getMessages();
     if (!empty($message)) {
         $this->view->message = $message;
     }
     if ($this->getRequest()->isPost()) {
         $post = $this->getRequest()->getPost();
         switch ($post['action']) {
             case 'delete':
                 if (isset($post['contact'])) {
                     $contact = $post['contact'];
                     foreach ($contact as $id) {
                         $this->contact->find($id)->current()->delete();
                     }
                     $this->_helper->flashMessenger->addMessage('Kontak berhasil dihapus.');
                 }
                 break;
             case 'filter':
                 $this->filter->contact = $post['filter'];
                 break;
             case 'sort':
                 $this->filter->contact = $post['filter'];
                 if ($this->filter->contact['order'] == 'ASC') {
                     $this->filter->contact['order'] = 'DESC';
                 } else {
                     $this->filter->contact['order'] = 'ASC';
                 }
                 break;
             case 'reset':
                 $this->filter->unsetAll();
                 break;
             default:
                 break;
         }
     }
     //set variable initial value
     //        $filter = null;
     //        $this->view->cleanurl = $this->_cleanUrl;
     //get params for the filter
     //        if($this->getRequest()->isPost())
     //        {
     //            $filter = $_POST['filterPage'];
     //            $new_search = TRUE;
     //            $this->_paginator_sess->filter = $filter;
     //            switch($filter)
     //            {
     //                case 0 : $param = null;
     //                    break;
     //                case 1 : $param = $_POST['filterName'];
     //                    break;
     //                case 2 : $param = $_POST['filterStatus'];
     //                    break;
     //                case 3 : $param = $_POST['filterSubject'];
     //                    break;
     //                case 4 : $param = $_POST['filterFlag'];
     //                    break;
     //                case 5 : $param = $_POST['filterCountry'];
     //                    break;
     //
     //            }
     //            $this->_paginator_sess->param = $param;
     //        }
     //        $contact = new Model_DbTable_Contact();
     /** Return alert to view on filter selected */
     //        switch ($filter) {
     //            case 0 : $filter_alert = "Show all contact";
     //                     break;
     //            case 1 : $filter_alert = "Contact which name with keyword '"
     //                        . $param . "'";
     //					 break;
     //			case 2 :
     //                switch ($param) {
     //                    case 0 : $state = 'Not yet replied';                 break;
     //                    case 1 : $state = 'A reply draft awaiting approval'; break;
     //                    case 2 : $state = 'Replied';                         break;
     //                }
     //                $filter_alert = "Contact with '" . $state . "' status";
     //				break;
     //			case 3 :
     //                switch ($param) {
     //                    case 0 : $state = 'Others';
     //                             break;
     //                    case 1 : $state = 'Destination Information Inquiry';
     //                             break;
     //                    case 2 : $state = 'Site Promotional/Marketing Cooperation Offers';
     //                             break;
     //                    case 3 : $state = 'Affiliation Information Inquiry';
     //                             break;
     //                    case 4 : $state = 'Feedback/Comment on this Site';
     //                             break;
     //                    case 5 : $state = 'Sender Country';
     //                             break;
     //                }
     //                $filter_alert = "Contact with '" . $state . "' subject";
     //				break;
     //            case 4 : ($param == '1') ? $state = 'with' : $state = 'without';
     //                     $filter_alert = "Contact " . $state . " flag";
     //					 break;
     //            case 5 : $filter_alert = 'All message send from '. $param;
     //                     break;
     //        }
     //        $this->view->alert = $filter_alert;
     //        $countId = $contact->getCountId();
     //get pagerow setting and send to the paginator control
     $new_search = FALSE;
     $param = null;
     $select = $this->contact->getAllQuery($this->filter->contact, $param);
     $data = $this->contact->fetchAll($select);
     $param = $this->_paginator_sess->param;
     $filter = $this->_paginator_sess->filter;
     $contact = Zend_Paginator::factory($data);
     $contact->setCurrentPageNumber($pageNumber);
     $contact->setItemCountPerPage(5);
     if (null != $this->filter->contact['row']) {
         $contact->setItemCountPerPage($this->filter->contact['row']);
     }
     $this->view->filter = $this->filter->contact;
     $this->view->contact = $contact;
     $page_row = $this->_getParam('filterPageRow');
     $this->view->row = $page_row;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     //if this is a new search then return the page number back to the 1st page
     if ($new_search) {
         $paginator->setCurrentPageNumber(1);
     }
     $this->view->paginator = $paginator;
     //        $this->view->countId = $countId;
     //country select
     Zend_Registry::set('languageId', 1);
     $this->view->totalItem = $paginator->getTotalItemCount();
 }
 /**
  * IS: Terdeklarasinya page_row
  * FS: Mengirimkan ke viewer: cleanUrl, message, page_row, paginator,
  *     classification_list, island_list
  * Desc: Mengatur aksi yang dilakukan untuk halaman index tourism operator
  */
 public function indexAction()
 {
     //send this page url to the view
     $this->view->cleanurl = $this->_cleanUrl;
     //get messages from CRUD process
     $message = $this->_flash->getMessages();
     if (!empty($message)) {
         $this->view->message = $message;
     }
     //create table instance
     $table_tourismoperator = new Model_DbTable_TourismOperator();
     $table_classification = new Model_DbTable_Classification();
     $table_area = new Model_DbTable_Area();
     //set the variable initial value
     $filter = null;
     $new_search = FALSE;
     //get the filter params
     if ($this->getRequest()->isPost()) {
         $filter = $_POST['filterPage'];
         $new_search = TRUE;
         $this->_paginator_sess->tpfilter = $filter;
         switch ($filter) {
             case 1:
                 $param = $_POST['filtertitle'];
                 break;
             case 2:
                 $param = $_POST['filterclass'];
                 break;
             case 3:
                 $param = $_POST['filterarea'];
                 break;
         }
         $this->_paginator_sess->param = $param;
     }
     //get the params from session and create paginator
     $filter = $this->_paginator_sess->tpfilter;
     $param = $this->_paginator_sess->param;
     $select = $table_tourismoperator->getQueryAllByLang($filter, $param);
     //get pagerow setting and send to the paginator control
     $page_row = $this->_getParam('filterPageRow');
     $this->view->row = $page_row;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     //if this is a new search then return the page number back to the 1st page
     if ($new_search) {
         $paginator->setCurrentPageNumber(1);
     }
     //Processing data for view element
     $classification_list = $table_classification->getAllClassification();
     $column = array('id' => 'area_id');
     $island_list = $table_area->getAllParentArea($column);
     //send data to the view
     $this->view->classification_list = $classification_list;
     $this->view->island_list = $island_list;
     $this->view->paginator = $paginator;
     /** Return alert to view on filter selected */
     switch ($filter) {
         case 0:
             $filter_alert = "Show all tourism operators";
             break;
         case 1:
             $filter_alert = "Tourism operator which name with keyword '" . $param . "'";
             break;
         case 2:
             foreach ($classification_list as $class) {
                 $parent[$class['id']] = $class['name'];
             }
             $filter_alert = "Tourism operators with '" . $parent[$param] . "' classification";
             break;
         case 3:
             $filter_alert = "Tourism operator located  in '" . $this->view->areaName($param) . "'";
     }
     $this->view->alert = $filter_alert;
 }
 /**
  * IS: Terdeklarasinya filter dan param di session, dan page_row
  * FS: Mengirimkan ke viewer: cleanUrl, message, page_row, filterdata,
  *     paginator, filter_alert
  * Desc: Mengatur aksi yang dilakukan untuk halaman index
  */
 public function indexAction()
 {
     //variable initiation and instance creation
     $language_id = 1;
     $this->view->cleanurl = $this->_cleanUrl;
     $paginatorfilter = new Zend_Session_Namespace('paginator');
     $table_category = new Model_DbTable_Category();
     /*     * $tes = new Model_DbTable_CategoryDescription();
           $es= $tes->checkDescIndo(85);
           print_r($es);* */
     //get messages from CRUD process
     $message = $this->_flash->getMessages();
     if (!empty($message)) {
         $this->view->message = $message;
     }
     //set variable initial value
     $filter = null;
     $new_search = FALSE;
     //get params for the filter
     if ($this->getRequest()->isPost()) {
         $filter = $_POST['filterPage'];
         $new_search = TRUE;
         $this->_paginator_sess->filter = $filter;
         switch ($filter) {
             case 0:
                 $param = null;
             case 1:
                 $param = $_POST['filterTitle'];
                 break;
             case 2:
                 $param = $_POST['filterParent'];
                 break;
         }
         $this->_paginator_sess->param = $param;
     }
     //set paginator for list of destination data
     $filter = $this->_paginator_sess->filter;
     $param = $this->_paginator_sess->param;
     $select = $table_category->getQueryAllByLanguage($filter, $param, $language_id);
     //get pagerow setting and send to the paginator control
     $page_row = $this->_getParam('filterPageRow');
     $this->view->row = $page_row;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     //send variables to the view class
     $filter_data = $table_category->getAllParentCategoryIdNameByLangId($language_id);
     $this->view->filterdata = $filter_data;
     $this->view->paginator = $paginator;
     /** Return alert to view on filter selected */
     switch ($filter) {
         case 0:
             $filter_alert = "Show all activities";
             break;
         case 1:
             $filter_alert = "Activities which name with keyword '" . $param . "'";
             break;
         case 2:
             foreach ($filter_data as $category) {
                 $parent[$category['category_id']] = $category['name'];
             }
             $filter_alert = "Activities which parent are '" . $parent[$param] . "'";
             break;
     }
     $this->view->alert = $filter_alert;
 }
 /**
  * IS: Terdeklarasinya filter dan param di session, dan page_row 
  * FS: Mengirimkan ke viewer: cleanUrl, message, filter_alert, page_row, 
  *     count, role_list, dan paginator
  * Desc: Mengatur aksi yang dilakukan untuk halaman index
  */
 public function indexAction()
 {
     $pageNumber = $this->_getParam('page');
     $table_role = new Model_DbTable_AdminRole();
     $message = $this->_flash->getMessages();
     $this->view->cleanurl = $this->_cleanUrl;
     //        $filter = null;
     $new_search = FALSE;
     if ($this->getRequest()->isPost()) {
         $post = $this->getRequest()->getPost();
         switch ($post['action']) {
             case 'delete':
                 foreach ($post['account'] as $id) {
                     $account = $this->account->find($id)->current();
                     $account->delete();
                     $this->loggingaction('Account', 'Delete', $account->id);
                 }
                 $this->_helper->flashMessenger->addMessage('Akun Berhasil Dihapus.');
                 $this->_helper->redirector('index');
                 break;
             case 'filter':
                 $this->filter->account = $post['filter'];
                 break;
             case 'sort':
                 $this->filter->account = $post['filter'];
                 if ($this->filter->account['order'] == 'ASC') {
                     $this->filter->account['order'] = 'DESC';
                 } else {
                     $this->filter->account['order'] = 'ASC';
                 }
                 break;
             case 'reset':
                 $this->filter->unsetAll();
                 break;
             default:
                 break;
         }
     }
     $filter = $this->_paginator_sess->filter;
     $param = $this->_paginator_sess->param;
     $select = $this->account->getAllQuery($this->filter->account, $param);
     $data = $this->account->fetchAll($select);
     $account = Zend_Paginator::factory($data);
     $account->setCurrentPageNumber($pageNumber);
     $account->setItemCountPerPage(5);
     if (null != $this->filter->account['row']) {
         $account->setItemCountPerPage($this->filter->account['row']);
     }
     $messages = $this->_helper->flashMessenger->getMessages();
     //get pagerow setting and send to the paginator control
     $page_row = $this->_getParam('filterPageRow');
     $this->view->row = $page_row;
     $this->view->account = $account;
     $this->view->messages = $messages;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     //if this is a new search then return the page number back to the 1st page
     if ($new_search) {
         $paginator->setCurrentPageNumber(1);
     }
     $count = $table_role->getCountAll();
     $this->view->count = $count;
     //        $this->view->rolelist = $role_list;
     $this->view->paginator = $paginator;
     $this->view->form = $this->form;
 }
 /**
  * IS: -
  * FS: -
  * Desc: Inisiasi fungsi parent
  */
 public function init()
 {
     parent::init();
     $this->view->image_dir_type = 4;
     $this->filter = new Zend_Session_Namespace('filter');
 }
 /**
  * IS: Terdeklarasinya filter dan param di session, dan page_row
  * FS: Mengirimkan ke viewer: cleanUrl, message, filter_alert, page_row,
  *     paginator
  * Desc: Mengatur aksi yang dilakukan untuk halaman index
  */
 public function indexAction()
 {
     //variable initiation and instance creation
     $this->view->cleanurl = $this->_cleanUrl;
     //get messages from CRUD process
     $message = $this->_flash->getMessages();
     if (!empty($message)) {
         $this->view->message = $message;
     }
     //create table instances
     $table_article = new Model_DbTable_Article();
     /*     * $tes = new Model_DbTable_ArticleDescription();
           $es= $tes->checkDescIndo(33);
           print_r($es);
          */
     //set variable initial value
     $filter = null;
     $new_search = FALSE;
     //get params for the filter
     if ($this->getRequest()->isPost()) {
         $filter = $_POST['filterPage'];
         $new_search = TRUE;
         $this->_paginator_sess->filter = $filter;
         switch ($filter) {
             case 0:
                 $param = null;
             case 1:
                 $param = $this->_getParam('filterTitle');
                 break;
             case 2:
                 $param = $this->_getParam('filterPoi');
                 break;
         }
         $this->_paginator_sess->param = $param;
     }
     //get the params from session and create paginator
     $filter = $this->_paginator_sess->filter;
     $param = $this->_paginator_sess->param;
     /** Return alert to view on filter selected */
     switch ($filter) {
         case 0:
             $filter_alert = "Show all attractions";
             break;
         case 1:
             $filter_alert = "Attractions which title with keyword '" . $param . "'";
             break;
         case 2:
             $filter_alert = "Attractions that related to '" . $param . "'";
             break;
     }
     $this->view->alert = $filter_alert;
     $select = $table_article->getQueryAllByLang($filter, $param, 1, $this->_userInfo->canApprove ? null : $this->_userInfo->id);
     //get pagerow setting and send to the paginator control
     $page_row = $this->_getParam('filterPageRow');
     $this->view->row = $page_row;
     if ($page_row != null) {
         $paginator = parent::setPaginator($select, $page_row);
     } else {
         $paginator = parent::setPaginator($select);
     }
     //if this is a new search then return the page number back to the 1st page
     if ($new_search) {
         $paginator->setCurrentPageNumber(1);
     }
     $this->view->userCanApprove = $this->_userInfo->canApprove;
     $this->view->paginator = $paginator;
 }