| Server IP : 103.234.187.230 / Your IP : 216.73.216.216 Web Server : Apache System : Linux lserver42043-ind.megavelocity.net 3.10.0-1160.108.1.el7.x86_64 #1 SMP Thu Jan 25 16:17:31 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/b2bzend/application/admin/controllers/ |
Upload File : |
<?php
/**
* Class Country
*
* @name Country
* @author Shailender Joshi
* @editor Shailender Joshi
* @created 17 Oct 2016
* @updateed 08 Jan 2018 by Md sabir
* @version 1.0
* @copyright Catabatic India Pvt Ltd
* Handle Country Related function for Front end only
*
*/
class Admin_CountryController extends Catabatic_ValidateAdmin {
public $imageUrl = NULL;
public $baseUrl = '';
public $tablename = '';
public $current_Modal = '';
public $per_page_record = GRID_PER_PAGE_RECORD_COUNT;
public function init() {
parent::init();
$request = Zend_Controller_Front::getInstance()->getRequest();
$this->baseUrl = $request->getScheme() . '://' . $request->getHttpHost();
$this->current_Modal = new Travel_Model_TblCountry();
$this->GeneralFunction_Modal = new Travel_Model_GeneralFunction(); // Make object of generel function class
$this->tablename = 'TB_Master_Geo_Country';
$sessionLogin_user = new Zend_Session_Namespace('sessionLogin_user');
$this->intLoggedinUserId = $sessionLogin_user->intLoggedinUserId;
$this->intLoggedinUserAgencySysId = $sessionLogin_user->intLoggedinUserAgencySysId;
$this->imageUrl = $this->baseUrl."/public/upload/country/";
}
public function indexAction()
{
$this->view->messages = $this->_helper->flashMessenger->getMessages();
//Start Search Code
$searchArr = array();
$getData = array();
if($this->getRequest()->isPost())
{
$getData = $this->getRequest()->getPost();
if(!empty($getData))
{
$Title = (@$getData['Title']!='') ? @$getData['Title'] : '';
$Code = (@$getData['Code']!='') ? @$getData['Code'] : '';
$region = (@$getData['region']!='') ? @$getData['region'] : '';
$continent = (@$getData['continent']!='') ? @$getData['continent']: '';
$filter1 = (@$getData['filter1']!='All') ? @$getData['filter1'] : ''; // status part
$filter2 = (@$getData['filter2']!='All') ? @$getData['filter2'] : ''; // verified part
$searchArr = array(
'Title' => $Title,
'Code' => $Code,
'region' => $region,
'continent'=> $continent,
'filter1' => $filter1,
'filter2' => $filter2,
);
//print_r($searchArr);
}
}
else
{
$Title = $this->_getParam('Title');
$Code = $this->_getParam('Code');
$region = $this->_getParam('region');
$continent = $this->_getParam('continent');
$filter1 = $this->_getParam('filter1');
$filter2 = $this->_getParam('filter2');
$filter1 = (@$filter1!='All') ? $filter1 : '';
$filter2 = (@$filter2!='All') ? $filter2 : '';
$searchArr = array(
'Title' => $Title,
'Code' => $Code,
'region' => $region,
'continent'=> $continent,
'filter1' => $filter1,
'filter2' => $filter2
);
//print_r($searchArr);
}
//print_r($searchArr);
$this->current_Modal->searchArr = $searchArr; // send Array - searchArr() to modal just for pagination
$this->view->searchArr = $searchArr;
// get Region list array
$this->view->regionlist = $this->GeneralFunction_Modal->getRecordListingWhere('TB_Master_Geo_Region',array('RegId','Title'), array('IsMarkForDel'=>0),'Title');
// get Continent list array
$this->view->continentlist = $this->GeneralFunction_Modal->getRecordListingWhere('TB_Master_Geo_Continent',array('ContiSysId','Title'), array('IsMarkForDelete'=>0),'Title');
// pagination start
$page = $this->_request->getParam('page',1); //get curent page param, default 1 if param not available.
$data = $this->current_Modal->getCountryListingRecord(); // get all getHotelAmenityCategory
//echo "<pre>";print_r($resultSet); exit;
$resultSet = array();
foreach($data as $key => $val){
$resultSet[$val['ContId']]['ContId'] = $val['ContId'];
$resultSet[$val['ContId']]['Code'] = $val['Code'];
$resultSet[$val['ContId']]['Title'] = $val['CountryName'];
$resultSet[$val['ContId']]['RegionName'][] = $val['RegionName'];
$resultSet[$val['ContId']]['IsActive'] = $val['IsActive'];
$resultSet[$val['ContId']]['IsApprove'] = $val['IsApprove'];
$resultSet[$val['ContId']]['ContinentName'] = $val['ContinentName'];
//$resultSet[$val['ContId']]['ContId'] = $val['ContId'];
}
// echo "<pre>";print_r($resultSet); exit;
$paginator = Zend_Paginator::factory($resultSet);
$paginator->setCurrentPageNumber($this->getRequest()->getParam('page')); // page number
$perPage = $paginator->setItemCountPerPage($this->per_page_record); // number of items to show per page
$this->view->paginator = $paginator;
$this->view->totalrec = $paginator->getTotalItemCount();
$this->view->currentPage = $this->_getParam('page');
}
public function addAction()
{
$form = new Travel_Form_Country();
$form->setAction($this->baseUrl."/admin/country/add")->setMethod("POST")->setName("addCountryForm");
$this->view->form = $form;
if ($this->getRequest()->isPost()) {
$post = $this->getRequest()->getPost();
if ($form->isValid($post)) {
try
{
$addData = array(
'RegionId' => trim($this->sanitize_data($post['regionList'])),
'Continent' => trim($this->sanitize_data($post['continentList'])),
'Title' => trim($this->sanitize_data($post['Title'])),
'Code' => trim($this->sanitize_data($post['Code'])),
'PhoneCode' => trim($this->sanitize_data($post['PhoneCode'])),
'TimeZoneUTC' => trim($this->sanitize_data($post['TimeZone'])),
'Synonyms' => trim($this->sanitize_data($post['Synonyms'])),
'TBBContId' => 0,
'CreateDate' => date('Y-m-d h:i:s'),
'ApproveDate' => date('Y-m-d h:i:s'),
'UpdateDate' => date('Y-m-d h:i:s'),
'IsApprove' => 0,
'IsActive' => 1,
'IsMarkForDel'=> 0,
);
// echo "<pre>";print_r($addData);die;
// check Same Title name already exists or not ( Avoid duplicate hotel Amenity Category entry)
if(trim($this->sanitize_data($post['Title']))!='' && trim($this->sanitize_data($post['Code']))!=''){
$entryDate = $this->GeneralFunction_Modal->getRecordListingWhere($this->tablename, array('Title'), array('Title'=>$addData['Title'], 'Code'=>$addData['Code']));
}
//print_r($entryDate); echo count($entryDate);
if(count($entryDate)>=1){
$this->view->eMsg = "Country already exists.";
}
else
{
$isinserted = $this->GeneralFunction_Modal->insertTable($this->tablename, $addData);
if($isinserted) {
$this->_helper->flashMessenger->addMessage("Record added successfully");
$this->_redirect("admin/country");
}
}
}
catch (Zend_file_transfer_exeception $e) {
$this->view->error_msg = $e->getMessage();
}
}
}
$this->view->others = array('baseUrl' => $this->baseUrl, 'action_name'=> 'add');
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
public function editAction()
{
$encodeId = ($this->getRequest()->getParam('id'));
$intId = (int)base64_decode($encodeId);
$page = $this->getRequest()->getParam('page');
if(!empty($intId) || !is_int($intId) )
{
# get listings of countrys
$colsArr = array('*');
$resultset = $this->GeneralFunction_Modal->getDetailsByUniqueId($this->tablename, $colsArr, 'ContId', $intId);
$form = new Travel_Form_Country();
$form->setMethod("POST")->setName("editCountryForm");
$editFormdata = array(
'regionList' => $resultset['RegionId'],
'continentList'=> $resultset['Continent'],
'Title' => $resultset['Title'],
'Code' => $resultset['Code'],
'PhoneCode' => $resultset['PhoneCode'],
'TimeZone' => $resultset['TimeZoneUTC'],
'Synonyms' => $resultset['Synonyms'],
);
$form->populate($editFormdata);
$this->view->form = $form;
if ($this->getRequest()->isPost()) {
$post = $this->getRequest()->getPost();
if ($form->isValid($post)) {
try {
$editData = array(
'RegionId' => trim($this->sanitize_data($post['regionList'])),
'Continent' => trim($this->sanitize_data($post['continentList'])),
'Title' => trim($this->sanitize_data($post['Title'])),
'Code' => trim($this->sanitize_data($post['Code'])),
'PhoneCode' => trim($this->sanitize_data($post['PhoneCode'])),
'TimeZoneUTC' => trim($this->sanitize_data($post['TimeZone'])),
'Synonyms' => trim($this->sanitize_data($post['Synonyms'])),
'UpdateDate' => date('Y-m-d h:i:s'),
);
$where = array('ContId =?'=> $intId);
$this->GeneralFunction_Modal->updateTable($this->tablename, $editData, $where);
$this->_helper->flashMessenger->addMessage("Record updated successfully");
$this->_redirect("admin/country/index/page/$page");
}
catch (Zend_Form_Exception $e) {
$this->view->error_msg = $e->getMessage();
}
}
}
$this->view->resultset = $resultset;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
}
public function deleteAction()
{
/* Disable Layout & set Render False */
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$id = base64_decode( $this->getRequest()->getParam('id'));
$currentPage = base64_decode( $this->getRequest()->getParam('page'));
if($id) {
$editData['IsMarkForDel'] = 1;
$where = array('ContId =?'=> $id);
$isupdated = $this->GeneralFunction_Modal->updateTable($this->tablename, $editData, $where);
if($isupdated)
{
$this->_helper->flashMessenger->addMessage("Record Deleted successfully.");
$this->_redirect("admin/country/index/page/$currentPage");
}
}
else {
$this->_redirect("admin/country/index/page/$currentPage");
}
}
public function filterStatusAction()
{
/* Disable Layout & set Render False */
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$filter = $this->getRequest()->getParam('filter');
$val = $this->getRequest()->getParam('val');
$id = base64_decode( $this->getRequest()->getParam('id'));
$currentPage = $this->getRequest()->getParam('page');
if($id && $filter) {
if($filter == 'filter1'){
$editData['IsActive'] = ($val == 0) ? 1 : 0;
}
if($filter == 'filter2'){
$editData['IsApprove'] = ($val == 0) ? 1 : 0;
$editData['ApproveDate'] = ($val == 0) ? '' : date('Y-m-d h:i:s');
}
$where = array('ContId =?'=> $id);
$isupdated = $this->GeneralFunction_Modal->updateTable($this->tablename, $editData, $where);
if($isupdated)
{
$this->_helper->flashMessenger->addMessage("Record Update successfully.");
$this->_redirect("admin/country/index/page/$currentPage");
}
}
else {
$this->_redirect("admin/country/index/page/$currentPage");
}
}
}