| 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/myvisakit/application/admin/controllers/ |
Upload File : |
<?php
/* * *************************************************************
* Catabatic Technology Pvt. Ltd.
* File Name : ContactusController.php
* File Desc. : Contactus controller managed all contact queries
* Created By : Piyush Tiwari <piyush@catpl.co.in>
* Created Date : 23 May 2018
* Updated Date : 23 May 2018
* ************************************************************* */
class Admin_TestimonialController extends Zend_Controller_Action {
public $dbAdapter;
public $perPageLimit;
public function init() {
/* Initialize db and session access */
$aConfig = $this->getInvokeArg('bootstrap')->getOptions();
$this->siteurl = $aConfig['bootstrap']['siteUrl'];
$this->gtxBtoBsite = $aConfig['bootstrap']['gtxBtoBsite'];
$this->per_page_record = 20;
$this->dbAdapter = Zend_Db_Table::getDefaultAdapter();
$auth = Zend_Auth::getInstance();
$authStorage = $auth->getStorage()->read();
$this->username = $authStorage->username;
$this->admin_type = $authStorage->role;
$this->current_time = time();
$this->imageUrl = 'public/upload/testimonial/';
}
/**
* index() method is used to admin login for form call
* @param Null
* @return Array
*/
public function indexAction() {
//Check admin logedin or not
$this->checklogin();
$this->view->messages = $this->_helper->flashMessenger->getMessages();
$crud = new Admin_Model_CRUD();
$getData = array();
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
$searchArr = array(
'rows' => $getData['rows'],
'page' => $getData['page'],
);
$resulsetold = $crud->getCount('tbl_feedback', ['isMarkForDel'=>0], 'FeedbackId');
$crud->searchArr = $searchArr;
$resultset = $crud->rv_select_static('tbl_feedback', ['*'], ['isMarkForDel'=>0], ['FeedbackId' => 'DESC']);
$resultData = array();
foreach($resultset as $rKey => $rVal){
$Image = ($rVal['TripImage'] !='') ? explode(',',$rVal['TripImage']) : array(0=>'');
$ImageUrl = $this->gtxBtoBsite.'public/upload/feedback/image/'.$rVal["AgencySysId"].'/'.$Image[0];
$resultData[] = [
'FeedbackId'=>$rVal['FeedbackId'],
'Name'=>$rVal['Name'],
'Image'=>'<img src="'.$ImageUrl.'" style="width:120px;height:120px;">',
'displayOnHome'=>$rVal['displayOnHome'],
];
}
//echo "<pre>";print_r($resultData);die;
$result = Zend_Json::encode($resultData);
$newResult = Zend_Json::decode($result, false);
$finalResult["total"] = $resulsetold[0]['FeedbackId'];
$finalResult["rows"] = $newResult;
echo json_encode($finalResult);
exit;
}
}
public function edittestimonialAction() {
//Check admin logedin or not
$this->checklogin();
$crud = new Admin_Model_CRUD();
$form = new Admin_Form_Edittestimonial();
$tId = (int) $this->getRequest()->getParam("id");
if (isset($tId) && !empty($tId)) {
// die("here");
$form->setAction("admin/testimonial/edittestimonial/".$tId);
$form->setMethod("POST");
$form->setName("edit_testimonial");
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
if ($tId) {
if (isset($getData['save']) == "Save") {
$testi_id = (int) @$getData['id'];
$images = $_FILES["TestiImage"]["name"];
try {
$page_id = $getData['sid'];
if (!empty($images)) {
$orignalFolderName = $_SERVER["CONTEXT_DOCUMENT_ROOT"] . "/" . $this->imageUrl;
$fileExt = $this->_helper->General->getFileExtension($images);
$fileName = $this->current_time . '.' . $fileExt;
if (!file_exists($orignalFolderName)) {
mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
}
$temp_file_name = $_FILES["TestiImage"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);
}
if ($fileName != "") {
$image_edit = $fileName;
}
$editPageData = [
'name' => ($getData['name']),
'message' => $getData['message'],
'star_rating' => $getData['star_rating'],
'status' => $getData['status'],
'created_at' => date('Y-m-d h:i:s')
];
if ($fileName) {
$editPageData['Image'] = $image_edit;
}
$crud->rv_update('tbl_testimonials', $editPageData, ['id =?' => $testi_id]);
$this->view->successMessage = "Page content has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Page content has been updated successfully.");
$this->_redirect("/admin/testimonial/index");
} catch (Zend_File_Transfer_Exception $e) {
$e->getMessage();
}
}
} else {
try {
$editPageData = [
'name' => ($getData['name']),
'message' => $getData['message'],
'star_rating' => $getData['star_rating'],
'status' => $getData['status'],
'created_at' => date('Y-m-d h:i:s')
];
$crud->rv_insert('tbl_testimonials', $editPageData);
$this->view->successMessage = "Page content has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Page content has been Added successfully.");
$this->_redirect("/admin/testimonial/index");
} catch (Zend_File_Transfer_Exception $e) {
$e->getMessage();
}
// echo "<pre>";print_r($getData);die('fd');
}
}
} else {
$form->setAction("admin/testimonial/edittestimonial/");
$form->setMethod("POST");
$form->setName("add_testimonial");
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
if ($form->isValid($getData)) {
if (isset($getData['save']) == "Save") {
$images = $_FILES["TestiImage"]["name"];
if (!empty($images)) {
$orignalFolderName = $_SERVER["CONTEXT_DOCUMENT_ROOT"] . "/" . $this->imageUrl;
$fileExt = $this->_helper->General->getFileExtension($images);
$fileName = $this->current_time . '.' . $fileExt;
if (!file_exists($orignalFolderName)) {
mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
}
$temp_file_name = $_FILES["TestiImage"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);
}
$savePageData = [
'name' => ($getData['name']),
'message' => $getData['message'],
'Image' => ($fileName),
'star_rating' => $getData['star_rating'],
'status' => $getData['status'],
'created_at' => date('Y-m-d h:i:s')
];
// echo "<pre>";print_r($savePageData);die('fd');
$crud->rv_insert('tbl_testimonials', $savePageData);
$this->view->successMessage = "Content has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Content has been added successfully.");
$this->_redirect("/admin/testimonial/index");
}
}
}
}
$result = $crud->rv_select_row('tbl_testimonials', ['*'], ['id' => $tId], ['id' => 'DESC']);
//print_r($result);die;
$editdata["id"] = @$result['id'];
$editdata["name"] = @$result['name'];
$editdata["message"] = @$result['message'];
$editdata["star_rating"] = @$result['star_rating'];
$editdata["status"] = @$result['status'];
$editdata["TestiImage"] = @$result['Image'];
$form->populate($editdata);
$this->view->form = $form;
$this->view->TestiImage = @$result['Image'];
$this->view->messages = $this->_helper->flashMessenger->getMessages();
//die('ok');
}
public function deletetestiAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
if ($tId) {
$checkdata = $crud->rv_select_row('tbl_testimonials', ['id'], ['id' => $tId], ['id' => 'asc']);
if (count($checkdata) > 0) {
$crud->rv_delete('tbl_testimonials', ['id =?' => $tId]);
$this->_helper->flashMessenger->addMessage("Delete successfully.");
$this->_redirect("/admin/testimonial/index");
} else {
die('Oops some thing wrong!!.');
}
}
}
public function activeAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
$val = (int) $this->getRequest()->getParam("val");
if ($tId) {
try {
$updatedata = [
'displayOnHome' => $val
];
$result = $crud->rv_update('tbl_feedback', $updatedata, ['FeedbackId =?' => $tId]);
if (!$result) {
$result_message = ['status' => false, 'message' => 'Oops something wrong!!'];
echo Zend_Json::encode($result_message);
exit;
} else {
$result_message = ['status' => true, 'message' => 'Active successfully'];
echo Zend_Json::encode($result_message);
exit;
}
} catch (Exception $ex) {
$ex->getMessage();
}
}
}
public function sanitize_data($string) {
$searchArr = array("iframe", "script", "document", "write", "alert", "%", "@", "$", ";", "+", "|", "#", "<", ">", ")", "(", "'", "\'", ",", "and ", " &", "& ", "and", " and", "0", "1", "2", "3", "4", "5", "6", "7", "8", "9");
$input_data = strtolower($string);
$input_data = str_replace($searchArr, "", $input_data);
$input_data = str_replace(" ", "-", $input_data);
//echo $input_data; die;
return $input_data;
}
/**
* checklogin() method is used to check admin logedin or not
* @param Null
* @return Array
*/
public function checklogin() {
if (($this->admin_type == "superadmin") || ($this->admin_type == "admin")) {
$auth = Zend_Auth::getInstance();
$hasIdentity = $auth->hasIdentity();
/* * ************* check admin identity *********** */
if (!$hasIdentity) {
$this->_redirect('admin/index/index');
}
} else {
$this->_redirect('admin/index/index');
}
}
}