HEX
Server: Apache/2.4.41 (Amazon) OpenSSL/1.0.2k-fips PHP/5.6.40
System: Linux ip-172-31-40-18 4.14.146-93.123.amzn1.x86_64 #1 SMP Tue Sep 24 00:45:23 UTC 2019 x86_64
User: apache (48)
PHP: 5.6.40
Disabled: NONE
Upload Files
File: //var/www/html/pmw24/pmw_live_testing/app/application/controllers/admin/Question.php
<?php 
defined('BASEPATH') OR exit('No direct script access allowed');

class Question extends MY_Controller {
	public function __construct() {
		parent::__construct();
		$this->redirect_guest();
		$this->admin=$this->session->userdata('admin');		
		$this->load->model('admin/mquestion');
	}
	
	public function index() { 				
		$this->_load_list_view();		
	}
	
	private function _load_list_view() {
		$data['admin'] = $this->admin;
		$data['content'] = 'admin/question/list';		
		$this->load->view('admin/layouts/index', $data);
	}
	
	public function all_content_list(){		
		$list = $this->mquestion->get_datatables();		
		$data = array();
        $no = $_POST['start'];
		$i=1;
		foreach ($list as $person) {
			$row = array();	
			$row[]=$i;		
			$row[] = $person->question;	
			
			$admin = $this->admin;
			$CI =& get_instance();
			$CI->db->select('*');
			$CI->db->from('role_menu');	
			$CI->db->join('menu', 'menu.menu_id = role_menu.menu_id', 'left');
			$CI->db->where('role_id',$admin['role_id']);
			$CI->db->where('parent_id',29);					
			$query=$CI->db->get();
			$menus = $query->result_array();		
			
			$status_result = $this->searcharray('Status', menu_name, $menus);
			
			$edit_result = $this->searcharray('Edit', menu_name, $menus);
			
			if(!empty($status_result)){			
				$row[] = ($person->status==1?'<a class="cstm_view_status btn btn-success" id="active" href="javascript:void(0)" title="'.$person->question_id.'"><span class="glyphicon glyphicon-ok"></span></a>':'<a class="cstm_view_status btn btn-danger" id="inactive" href="javascript:void(0)" title="'.$person->question_id.'"><span class="glyphicon glyphicon-remove"></span></a>');
			}

			if(!empty($edit_result)){			
				$row[] = '<a href="'.base_url('admin/question/details/'.$person->question_id).'" title="Edit" class="btn btn-info"><span class="glyphicon glyphicon-pencil"></span></a>';
			}
            $data[] = $row;
			$i++;
        }
		
		$output = array(
                        "draw" => $_POST['draw'],
                        "recordsTotal" => $this->mquestion->count_all(),
                        "recordsFiltered" => $this->mquestion->count_filtered(),
                        "data" => $data,
                );
        echo json_encode($output);
	}
	
	private function searcharray($value, $key, $array) {
	   foreach ($array as $k => $val) {
		   if ($val[$key] == $value) {
			   return $val;
		   }
	   }
	   return null;
	}
	
	public function active()
	{
		$condition['question_id']=$this->input->post('question_id');
		$udata['status'] = 1;
		$this->mquestion->active($condition,$udata);
		$response=array('status'=>1,'message'=>'Success');		
		echo json_encode($response);
	}
	
	public function inactive()
	{
		$condition['question_id']=$this->input->post('question_id');
		$udata['status'] = 0;
		$this->mquestion->active($condition,$udata);
		$response=array('status'=>1,'message'=>'Success');		
		echo json_encode($response);
	}
	
	public function add()
	{
		$this->_load_add_view();
	}
	
	private function _load_add_view(){
		$data['content']='admin/question/add';
		$this->load->view('admin/layouts/index',$data);
	}
	
	public function add_content()
	{		
		if($this->input->post()){
			$this->form_validation->set_rules('question','Question','required|is_unique[question.question]');
			
			if($this->form_validation->run()==FALSE){
				$this->_load_add_view();
			}else{
				$data['question'] = $this->input->post('question');
				$data['status'] = 1;
				$data['date_of_creation'] = date('Y-m-d H:i:s');
			
				$this->mquestion->add($data);
				
				$this->session->set_flashdata('success_msg','Question added successfully');
				redirect('admin/question/content');
			}	
			
		}
	}
	
	public function edit($question_id){
		$data['cms']=$this->mquestion->get_details($question_id);
		
		if(empty($data['cms'])){
			$this->_load_list_view();
		}else{			
			$this->_load_details_view($data);
		}
	}
	
	private function _load_details_view($parms){		
		$data['cms']=$parms['cms'];	
		$data['content'] = 'admin/question/detail';
		$this->load->view('admin/layouts/index', $data);
	}
	
	public function update(){
		if($this->input->post()){
			$question_id = $this->input->post('question_id');
			$this->form_validation->set_rules('question','Question','required');
			
			if($this->form_validation->run()==FALSE){
				$data['cms']=$this->mquestion->get_details($question_id);
				$this->_load_details_view($data);
			}else{
				$question = $this->input->post('question');
				$condition = array("question_id"=>$question_id);
				
				$questionR = $this->mquestion->getRow('question',$condition);
				if($questionR['question'] == $question)
				{
					$udata['question'] = $question;
					$udata['date_of_update'] = date('Y-m-d H:i:s');
					$this->mquestion->update($condition,$udata);					
					$this->session->set_flashdata('success_msg','Question updated successfully');
					redirect('admin/question');
				}else{					
					$conditionQuestionDetails = array("question"=>$question);
					$questionDetail = $this->mquestion->getRow('question',$conditionQuestionDetails);
					if(empty($questionDetail))
					{
						$udata['question'] = $question;
						$udata['date_of_update'] = date('Y-m-d H:i:s');	
						$this->mquestion->update($condition,$udata);						
						$this->session->set_flashdata('success_msg','Question updated successfully');
						redirect('admin/question');
					}else{
						$this->session->set_flashdata('error_msg','Question Already Exsits');
						redirect('admin/question');
					}
				}
			}				
		}
	}
}