1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / ravikumarnew / application / controllers.20200114 /
Filename : Ab_administration.php
back
<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Ab_administration extends CI_Controller {

	var $publicMethods  = array("index", "logincheck"); 
	 
	function __construct(){
        parent::__construct();
		$logged_in = $this->session->userdata('ab_uid');		
		$currentMethod = $this->router->fetch_method();
		
		if(in_array($currentMethod,$this->publicMethods) == false){
			if(!$logged_in){
				redirect('Ab_administration/index');
			}
		}
    }

	public function index(){
		
		$this->load->view('ab_administration/login');
	}
	
	public function logincheck(){

		$username = $this->input->post('username');
		$password = $this->input->post('password');

		$exits = $this->Common_model->get_record("users","*",array('username'=>$username, 'status'=>0));

		if(isset($exits->uid)){

			$hash = $exits->password;
		
			if (password_verify($password, $hash)) {

				$userdata = array('ab_uid'=>$exits->uid);
				$this->session->set_userdata($userdata);
				redirect("Ab_administration/dashboard");
			   
			} else {

			    $this->session->set_flashdata('item', array('message' => 'incorrect'));
				redirect("Ab_administration/index");
			}

		}else{

			$this->session->set_flashdata('item', array('message' => 'incorrect'));
			redirect("Ab_administration/index");
		}

	}

	public function logout(){
		
		$userdata = array("ab_uid"=>'');
			
		$this->session->set_userdata($userdata);

		redirect("/ab_administration");
	}

	public function dashboard() {

		$data['content'] = 'ab_administration/dashboard';
		

		$data['total_poems'] = $this->Common_model->get_records_count("poem_composition_speech" ,"*",array('status' => 0, 'type' =>1));
		$data['total_compositions'] = $this->Common_model->get_records_count("poem_composition_speech" ,"*",array('status' => 0, 'type' =>2));
		$data['total_speeches'] = $this->Common_model->get_records_count("poem_composition_speech" ,"*",array('status' => 0, 'type' =>3));

		$data['total_categories'] = $this->Common_model->get_records_count("category" ,"*",array('status' => 0));
		$data['total_subcategories'] = $this->Common_model->get_records_count("sub_category" ,"*",array('status' => 0));


		$this->load->view('ab_administration/template', $data);



	}

	public function create_poem_composition_speech(){
	
		$data['create_poem_composition_speech'] = 'menu';
		$data['content'] = "ab_administration/poem_composition_speech/create_poem_composition_speech";
		$this->load->view('ab_administration/template',$data);

	}
	
	public function save_poem_composition_speech(){

		$record_id = $this->input->post('record_id');

		if($record_id){
			
				$where['id'] = $record_id;
				$values['title'] = trim($this->input->post('title'));
				$values['type'] = trim($this->input->post('type'));

				if($values['type'] == 1 || $values['type'] == 3){
					
					// poem_speech
						 if(isset($_FILES['poem_speech_image']['name']) && !empty($_FILES['poem_speech_image']['name'])){
				            $config['upload_path']     = 'site/uploads/poem_speech';
				            $config['allowed_types']   = 'jpg|png|jpeg';
				            $config['file_name']       = rand().time();     


				            $this->load->library('upload', $config);
				        
				            if ( ! $this->upload->do_upload('poem_speech_image')){
				            }
				            else{
				                $data = array('upload_data' => $this->upload->data());
				                $values['image'] = $data['upload_data']['file_name'];
				            }
				        }

				}elseif ($values['type'] == 2) {
					
					// composition_image
						 if(isset($_FILES['composition_image']['name']) && !empty($_FILES['composition_image']['name'])){
				            $config['upload_path']     = 'site/uploads/composition';
				            $config['allowed_types']   = 'jpg|png|jpeg';
				            $config['file_name']       = rand().time();     


				            $this->load->library('upload', $config);
				        
				            if ( ! $this->upload->do_upload('composition_image')){
				            }
				            else{
				                $data = array('upload_data' => $this->upload->data());
				                $values['image'] = $data['upload_data']['file_name'];
				            }
				        }
					
				}
				$values['content'] = $this->input->post('content');
				
				$values['status'] = trim($this->input->post('status'));
				$values['meta_title'] = trim($this->input->post('meta_title'));
				$values['meta_description'] = trim($this->input->post('meta_description'));

				$values['modifiedBy'] = get_uid();
				$values['modifiedTime'] = date("Y-m-d H:i:s");
				
				$this->Common_model->update_record("poem_composition_speech", $values, $where);

				if($values['type'] == 1)
					$this->session->set_flashdata("message","கவிதை மாற்றப்பட்டது .");
				if($values['type'] == 2)
					$this->session->set_flashdata("message","கட்டுரை மாற்றப்பட்டது .");
				if($values['type'] == 3)
					$this->session->set_flashdata("message","உரை மாற்றப்பட்டது .");

		}else{
				$values['title'] = trim($this->input->post('title'));
				$values['type'] = trim($this->input->post('type'));

				if($values['type'] == 1 || $values['type'] == 3){
					
					// poem_speech
						 if(isset($_FILES['poem_speech_image']['name']) && !empty($_FILES['poem_speech_image']['name'])){
				            $config['upload_path']     = 'site/uploads/poem_speech';
				            $config['allowed_types']   = 'jpg|png|jpeg';
				            $config['file_name']       = rand().time();     


				            $this->load->library('upload', $config);
				        
				            if ( ! $this->upload->do_upload('poem_speech_image')){
				            }
				            else{
				                $data = array('upload_data' => $this->upload->data());
				                $values['image'] = $data['upload_data']['file_name'];
				            }
				        }

				}elseif ($values['type'] == 2) {
					
					// composition_image
						 if(isset($_FILES['composition_image']['name']) && !empty($_FILES['composition_image']['name'])){
				            $config['upload_path']     = 'site/uploads/composition';
				            $config['allowed_types']   = 'jpg|png|jpeg';
				            $config['file_name']       = rand().time();     


				            $this->load->library('upload', $config);
				        
				            if ( ! $this->upload->do_upload('composition_image')){
				            }
				            else{
				                $data = array('upload_data' => $this->upload->data());
				                $values['image'] = $data['upload_data']['file_name'];
				            }
				        }
					
				}
				$values['content'] = $this->input->post('content');
				
				$values['status'] = trim($this->input->post('status'));
				$values['meta_title'] = trim($this->input->post('meta_title'));
				$values['meta_description'] = trim($this->input->post('meta_description'));

				$values['createdBy'] = get_uid();
				$values['createdTime'] = date("Y-m-d H:i:s");

				$this->Common_model->insert_record("poem_composition_speech", $values);

				if($values['type'] == 1)
					$this->session->set_flashdata("message","கவிதை சேர்க்கப்பட்டது.");
				if($values['type'] == 2)
					$this->session->set_flashdata("message","கட்டுரை சேர்க்கப்பட்டது.");
				if($values['type'] == 3)
					$this->session->set_flashdata("message","உரை சேர்க்கப்பட்டது.");
		}
		
		redirect('ab_administration/list_poem_composition_speech');
	}

	public function list_poem_composition_speech(){

		$data['list_poem_composition_speech'] = 'menu';
		$data['content'] = "ab_administration/poem_composition_speech/list_poem_composition_speech";
		
		$this->load->view('ab_administration/template',$data);

	}

	
	public function saveUploadImageAjax(){

		$config['upload_path']     = 'site/uploads/content';
        $config['allowed_types']   = 'gif|jpg|png|jpeg';
        $config['file_name']       = rand().time();     

        $this->load->library('upload', $config);
        if ( ! $this->upload->do_upload('image')){
         
        }
        else{
            $data = array('upload_data' => $this->upload->data());
            echo base_url()."site/uploads/content/".$data['upload_data']['file_name'];
        }

	}

	
	public function get_poem_composition_speech_datas($type){

		$draw = $_GET['draw'];
		$start = $_GET['start'];
		$length = $_GET['length'];

		$search_array = $_GET['search'];
		$search = $search_array['value'];
		$search = trim($search," ");
		
		if($type){
		$get_poem_composition_speech_datas = $this->Ab_administration_model->get_poem_composition_speech_datas($type,$start,$length,$search);
		$get_poem_composition_speech_datas_count = $this->Ab_administration_model->get_poem_composition_speech_datas_count($type);
		}
		

		$mainarray=array("draw" => $draw, "recordsTotal"=> count($get_poem_composition_speech_datas_count), "recordsFiltered" => count($get_poem_composition_speech_datas_count));
		$for_data = array();

			if(isset($get_poem_composition_speech_datas) && !empty($get_poem_composition_speech_datas)){
				$records = $start+1;
				$sno = $records;
				foreach ($get_poem_composition_speech_datas as $key => $value) {

					$subarray[] = $sno;
					$sno++;
					$subarray[] = $value->title;

					if($value->status == 0)
						$subarray[] = "Enable";
					elseif($value->status == 2)
						$subarray[] = "Disable";

					if($value->status == 0){
						$action = "<a class='disable' style='color:green;' href = ".base_url()."ab_administration/disable_poem_composition_speech/$value->id>
						<i class='fa fa-toggle-on'></i></a>";
					}elseif($value->status == 2){
						$action = "<a class='enable' style='color:red;' href = ".base_url()."ab_administration/enable_poem_composition_speech/$value->id>
						<i class='fa fa-toggle-off'></i></a>";
					}
					$action .= "&nbsp;&nbsp;&nbsp;<a class='edit' href = ".base_url()."ab_administration/edit_poem_composition_speech/$value->id>
					<i class='fas fa-edit'></i></a>&nbsp;&nbsp;&nbsp;
					<a class='delete' href = ".base_url()."ab_administration/delete_poem_composition_speech/$value->id><i class='fas fa-trash' style='color:#f3213e'></i></a>";

					$subarray[] = $action;
					
					array_push($for_data, $subarray);
					unset($subarray);
				}
				
			}else{
				$subarray[] = "<center>---</center>";
				$subarray[] = "<center>---</center>";
				$subarray[] = "<center>---</center>";
				$subarray[] = "<center>---</center>";
				
			}

			$mainarray['data']=$for_data;
			echo json_encode($mainarray);
	}

	public function edit_poem_composition_speech($id){

		$data['content'] = "ab_administration/poem_composition_speech/create_poem_composition_speech";
		$data['record'] = $this->Common_model->get_record("poem_composition_speech","*",array("id"=>$id));
		$this->load->view('ab_administration/template',$data);

	}

	public function disable_poem_composition_speech($id){
	
		$where['id'] = $id;
		$values['status'] = 2;
		$this->Common_model->update_record("poem_composition_speech", $values, $where);
		
		$this->session->set_flashdata("delete_message","Disabled Successfully...");
		redirect('ab_administration/list_poem_composition_speech');
	}

	public function enable_poem_composition_speech($id){
	
		$where['id'] = $id;
		$values['status'] = 0;
		$this->Common_model->update_record("poem_composition_speech", $values, $where);
		
		$this->session->set_flashdata("message","Enabled Successfully...");
		redirect('ab_administration/list_poem_composition_speech');
	}

	public function delete_poem_composition_speech($id){
	
		$where['id'] = $id;
		$values['status'] = 1;
		$this->Common_model->update_record("poem_composition_speech", $values, $where);
		
		$this->session->set_flashdata("delete_message","Deleted Successfully...");
		redirect('ab_administration/list_poem_composition_speech');
	}

		
// video section
	public function create_video(){

		$data['create_video'] = 'menu';
		$data['content'] = "ab_administration/video/create_video";
		$this->load->view('ab_administration/template',$data);

	}
	public function list_video()
	{

		$data['list_video'] = 'menu';
		$data['content'] = "ab_administration/video/list_video";			
		$this->load->view('ab_administration/template',$data);

	}

	
		public function get_video()
		{
		$draw = $_GET['draw'];
		$start = $_GET['start'];
		$length = $_GET['length'];

		$search_array = $_GET['search'];
		$search = $search_array['value'];
		$search = trim($search, " ");

		$get_video_data = $this->Ab_administration_model->get_video($search, $start, $length);

		$get_video_count = $this->Common_model->get_records("video", "*", array('status' => 0));

		$mainarray = array("draw" => $draw, "recordsTotal" => count($get_video_count), "recordsFiltered" => count($get_video_count));
		$for_data = array();

		if (isset($get_video_data) && !empty($get_video_data)) {
			$records = $start + 1;
			$sno = $records;
			foreach ($get_video_data as $key => $values) {
				$subarray[] = $sno;
				$sno++;
				$subarray[] =  $values->title;				
				if($values->status == 0)
							$subarray[] = "Enable";
							elseif($values->status == 2)
							$subarray[] = "Disable";					
			if($values->status == 0){
		 				$action = "<a class='disable' style='color:green;' href = ".base_url()."ab_administration/disable_video/$values->id>
		 				<i class='fa fa-toggle-on'></i></a>";
		 			}elseif($values->status == 2){
		 				$action = "<a class='enable' style='color:red;' href = ".base_url()."ab_administration/enable_video/$values->id>
		 				<i class='fa fa-toggle-off'></i></a>";
		 			}
		 			$action .= "&nbsp;&nbsp;&nbsp;<a class='edit' href = ".base_url()."ab_administration/edit_video/$values->id>
		 			<i class='fas fa-edit'></i></a>&nbsp;&nbsp;&nbsp;
		 			<a class='delete' href = ".base_url()."ab_administration/delete_video/$values->id><i class='fas fa-trash' style='color:#f3213e'></i></a>";	
		 			$subarray[] = $action;						
		 			array_push($for_data, $subarray);
		 			unset($subarray);
		 		}
				
		 	}else{
		 		$subarray[] = "<center>---</center>";
		 		$subarray[] = "<center>---</center>";
		 		$subarray[] = "<center>---</center>";
		 		$subarray[] = "<center>---</center>";
				
		 	}
			$mainarray['data'] = $for_data;
			echo json_encode($mainarray);
		}


	public function save_video(){

			 $id = $this->input->post('id');							
			$where['id'] = $id;
			$values['title'] = trim($this->input->post('title'));
	    	$values['content'] = $this->input->post('content');				
	    	$values['url'] = $this->input->post('url');				
			$values['status'] = trim($this->input->post('status'));
			$values['meta_title'] = trim($this->input->post('meta_title'));
			$values['meta_description'] = trim($this->input->post('meta_description'));
			$values['createdBy'] = get_uid();
			$values['createdTime'] = date("Y-m-d H:i:s");				
			$this->Common_model->insert_record("video", $values, $where);			
			redirect("ab_administration/list_video");
				
	}
	public function update_video(){
		
		$id = $this->input->post('id');							
		$where['id'] = $id;
		$values['title'] = trim($this->input->post('title'));
		$values['content'] = $this->input->post('content');				
		$values['url'] = $this->input->post('url');				
		$values['status'] = trim($this->input->post('status'));
		$values['meta_title'] = trim($this->input->post('meta_title'));
		$values['meta_description'] = trim($this->input->post('meta_description'));
		$values['modifiedBy'] = get_uid();
		$values['modifiedTIme'] = date("Y-m-d H:i:s");				
		$this->Common_model->update_record("video", $values, $where);			
		redirect("ab_administration/list_video");
	}

	public function edit_video($id){

		$data['content'] = "ab_administration/video/create_video";
		$data['video'] = $this->Common_model->get_record("video","*",array("id"=>$id));
		$this->load->view('ab_administration/template',$data);

	}
	public function disable_video($id){
		
		$where['id'] = $id;
		$values['status'] = 2;
		$this->Common_model->update_record("video", $values, $where);
		
		$this->session->set_flashdata("delete_message","Disabled Successfully...");
		redirect('ab_administration/list_video');
	}

	public function enable_video($id){

		$where['id'] = $id;
		$values['status'] = 0;
		$this->Common_model->update_record("video", $values, $where);
		
		$this->session->set_flashdata("message","Enabled Successfully...");
		redirect('ab_administration/list_video');
	}

	public function delete_video($id){
		$where['id'] = $id;
		$values['status'] = 1;
		$this->Common_model->update_record("video", $values, $where);	
		$this->session->set_flashdata("delete_message","Deleted Successfully...");
		redirect('ab_administration/list_video');
	}
	
	public function create_panigal(){
	
		$data['create_panigal'] = 'menu';
		$data['content'] = "ab_administration/panigal/create_panigal";
		$data['category'] = $this->Common_model->get_records("category","*",array('status' => 0,));

		$this->load->view('ab_administration/template',$data);

	}
	
	public function get_subcategory(){

		$category_id = $this->input->post("category_id");

		$subcategory = $this->Common_model->get_records("sub_category","*",array('category_id' => $category_id,'status' =>0));
		
		$mainarray = array();
		foreach ($subcategory as $key => $value) {
			
			$sub_array['subcategory_id'] = $value->sub_category_id;
			$sub_array['sub_category_name'] = $value->sub_category_name;

			array_push($mainarray, $sub_array);
		}

		echo json_encode($mainarray);
	}

	public function save_panigal(){

		$record_id = $this->input->post('record_id');

		if($record_id){
			
				$where['id'] = $record_id;
			// Panigal image
		 if(isset($_FILES['panigal_image']['name']) && !empty($_FILES['panigal_image']['name'])){
            $config['upload_path']     = 'site/uploads/panigal_image';
            $config['allowed_types']   = 'jpg|png|jpeg';
            $config['file_name']       = rand().time();     


            $this->load->library('upload', $config);
        
            if ( ! $this->upload->do_upload('panigal_image')){
            }
            else{
                $data = array('upload_data' => $this->upload->data());
                $values['image'] = $data['upload_data']['file_name'];
            }
        }

    	$values['sub_category_id'] = $this->input->post('subcategory_id');
    	$values['title'] = $this->input->post('title');
    	$values['content'] = $this->input->post('content');
		
		$values['status'] = trim($this->input->post('status'));
		$values['meta_title'] = trim($this->input->post('meta_title'));
		$values['meta_description'] = trim($this->input->post('meta_description'));

		$values['modifiedBy'] = get_uid();
		$values['modifiedTIme'] = date("Y-m-d H:i:s");

		$this->Common_model->update_record("panigal", $values, $where);


		$this->session->set_flashdata("message","பணி மாற்றப்பட்டது.");
		}else{


		// Panigal image
			 if(isset($_FILES['panigal_image']['name']) && !empty($_FILES['panigal_image']['name'])){
	            $config['upload_path']     = 'site/uploads/panigal_image';
	            $config['allowed_types']   = 'jpg|png|jpeg';
	            $config['file_name']       = rand().time();     


	            $this->load->library('upload', $config);
	        
	            if ( ! $this->upload->do_upload('panigal_image')){
	            }
	            else{
	                $data = array('upload_data' => $this->upload->data());
	                $values['image'] = $data['upload_data']['file_name'];
	            }
	        }

    	$values['sub_category_id'] = $this->input->post('subcategory_id');
    	$values['title'] = $this->input->post('title');
    	$values['content'] = $this->input->post('content');
		
		$values['status'] = trim($this->input->post('status'));
		$values['meta_title'] = trim($this->input->post('meta_title'));
		$values['meta_description'] = trim($this->input->post('meta_description'));

		$values['createdBy'] = get_uid();
		$values['createdTime'] = date("Y-m-d H:i:s");

		
		$this->Common_model->insert_record("panigal", $values);

		$this->session->set_flashdata("message","பணி சேர்க்கப்பட்டது.");
	}

		redirect('ab_administration/list_panigal');

	}

	public function list_panigal(){

		$data['list_panigal'] = 'menu';
		$data['content'] = "ab_administration/panigal/list_panigal";

		$data['category'] = $this->Common_model->get_records("category","*",array('status' => 0,));
		
		$this->load->view('ab_administration/template',$data);

	}

	public function get_panigal_datas($subcategory_id){

		$draw = $_GET['draw'];
		$start = $_GET['start'];
		$length = $_GET['length'];

		$search_array = $_GET['search'];
		$search = $search_array['value'];
		$search = trim($search," ");
		
		if($subcategory_id){
		$get_panigal_datas = $this->Ab_administration_model->get_panigal_datas($subcategory_id,$start,$length,$search);
		$get_panigal_datas_count = $this->Ab_administration_model->get_panigal_datas_count($subcategory_id);
		}
		

		$mainarray=array("draw" => $draw, "recordsTotal"=> count($get_panigal_datas_count), "recordsFiltered" => count($get_panigal_datas_count));
		$for_data = array();

			if(isset($get_panigal_datas) && !empty($get_panigal_datas)){
				$records = $start+1;
				$sno = $records;
				foreach ($get_panigal_datas as $key => $value) {

					$subarray[] = $sno;
					$sno++;
					$subarray[] = $value->title;

					if($value->status == 0)
						$subarray[] = "Enable";
					elseif($value->status == 2)
						$subarray[] = "Disable";

					if($value->status == 0){
						$action = "<a class='disable' style='color:green;' href = ".base_url()."ab_administration/disable_panigal/$value->id>
						<i class='fa fa-toggle-on'></i></a>";
					}elseif($value->status == 2){
						$action = "<a class='enable' style='color:red;' href = ".base_url()."ab_administration/enable_panigal/$value->id>
						<i class='fa fa-toggle-off'></i></a>";
					}
					$action .= "&nbsp;&nbsp;&nbsp;<a class='edit' href = ".base_url()."ab_administration/edit_panigal/$value->id>
					<i class='fas fa-edit'></i></a>&nbsp;&nbsp;&nbsp;
					<a class='delete' href = ".base_url()."ab_administration/delete_panigal/$value->id><i class='fas fa-trash' style='color:#f3213e'></i></a>";

					$subarray[] = $action;
					
					array_push($for_data, $subarray);
					unset($subarray);
				}
				
			}else{
				$subarray[] = "<center>---</center>";
				$subarray[] = "<center>---</center>";
				$subarray[] = "<center>---</center>";
				$subarray[] = "<center>---</center>";
				
			}

			$mainarray['data']=$for_data;
			echo json_encode($mainarray);
	}


	public function disable_panigal($id){
		
		$where['id'] = $id;
		$values['status'] = 2;
		$this->Common_model->update_record("panigal", $values, $where);
		
		$this->session->set_flashdata("delete_message","Disabled Successfully...");
		redirect('ab_administration/list_panigal');
	}

	public function enable_panigal($id){
		
		$where['id'] = $id;
		$values['status'] = 0;
		$this->Common_model->update_record("panigal", $values, $where);
		
		$this->session->set_flashdata("message","Enabled Successfully...");
		redirect('ab_administration/list_panigal');
	}

	public function delete_panigal($id){
		
		$where['id'] = $id;
		$values['status'] = 1;
		$this->Common_model->update_record("panigal", $values, $where);
		
		$this->session->set_flashdata("delete_message","Deleted Successfully...");
		redirect('ab_administration/list_panigal');
	}

	
	public function edit_panigal($id){

		$data['content'] = "ab_administration/panigal/create_panigal";
		$data['category'] = $this->Common_model->get_records("category","*",array('status' => 0,));
		$data['record'] = $this->Common_model->get_record("panigal","*",array("id"=>$id));

		$subcategory_id = $data['record']->sub_category_id;
		$data['cat'] = $this->Common_model->get_record("sub_category","category_id",array("sub_category_id"=>$subcategory_id));
		
		$this->load->view('ab_administration/template',$data);

	}

	// banner image section
            public function create_banner(){
                    $data['create_banner'] = 'menu';
                    $data['content'] = "ab_administration/banner/create_banner";
                    $this->load->view('ab_administration/template',$data);
    
            }
            public function list_banner()
            {

                    $data['list_banner'] = 'menu';
                    $data['content'] = "ab_administration/banner/list_banner";                        
                    $this->load->view('ab_administration/template',$data);
    
            }
            public function save_banner()
    {
            $id = $this->input->post('id');                                                        
            $where['id'] = $id;        
                    //Image Banner
                    if(isset($_FILES['banner_image']['name']) && !empty($_FILES['banner_image']['name'])){
                            $config['upload_path']     = 'site/uploads/banner';
                            $config['allowed_types']   = 'jpg|png|jpeg';
                            $config['file_name']       = rand().time();     


                            $this->load->library('upload', $config);
                    
                            if ( ! $this->upload->do_upload('banner_image')){
                            }
                            else{
                                    $data = array('upload_data' => $this->upload->data());
                                    $values['banner_image'] = $data['upload_data']['file_name'];
                            }
                    }                                
            $values['status'] = trim($this->input->post('status'));                                
            $values['createdBy'] = get_uid();
            $values['createdTime'] = date("Y-m-d H:i:s");                                
            $this->Common_model->insert_record("banner_img", $values, $where);                        
            redirect("ab_administration/list_banner");
    
    }
    public function update_banner()
    {
            $id = $this->input->post('id');                                                        
            $where['id'] = $id;        
                    //Image Banner
                    if(isset($_FILES['banner_image']['name']) && !empty($_FILES['banner_image']['name'])){
                            $config['upload_path']     = 'site/uploads/banner';
                            $config['allowed_types']   = 'jpg|png|jpeg';
                            $config['file_name']       = rand().time();     


                            $this->load->library('upload', $config);
                    
                            if ( ! $this->upload->do_upload('banner_image')){
                            }
                            else{
                                    $data = array('upload_data' => $this->upload->data());
                                    $values['banner_image'] = $data['upload_data']['file_name'];
                            }
                    }                                
            $values['status'] = trim($this->input->post('status'));                                
            $values['createdBy'] = get_uid();
            $values['createdTime'] = date("Y-m-d H:i:s");                                
            $this->Common_model->update_record("banner_img", $values, $where);                        
            redirect("ab_administration/list_banner");
    }
    public function edit_banner($id){

            $data['content'] = "ab_administration/banner/create_banner";
            $data['banner'] = $this->Common_model->get_record("banner_img","*",array("id"=>$id));
            $this->load->view('ab_administration/template',$data);

    }
    public function disable_banner($id){
            
            $where['id'] = $id;
            $values['status'] = 2;
            $this->Common_model->update_record("banner_img", $values, $where);
            
            $this->session->set_flashdata("delete_message","Disabled Successfully...");
            redirect('ab_administration/list_banner');
    }

    public function enable_banner($id){

            $where['id'] = $id;
            $values['status'] = 0;
            $this->Common_model->update_record("banner_img", $values, $where);
            
            $this->session->set_flashdata("message","Enabled Successfully...");
            redirect('ab_administration/list_banner');
    }

    public function delete_banner($id){
            $where['id'] = $id;
            $values['status'] = 1;
            $this->Common_model->update_record("banner_img", $values, $where);        
            $this->session->set_flashdata("delete_message","Deleted Successfully...");
            redirect('ab_administration/list_banner');
    }
    public function get_banner() {
    $draw = $_GET['draw'];
    $start = $_GET['start'];
    $length = $_GET['length'];

    $search_array = $_GET['search'];
    $search = $search_array['value'];
    $search = trim($search, " ");

    $get_banner_data = $this->Ab_administration_model->get_banner($search, $start, $length);

    $get_banner_count = $this->Common_model->get_records("banner_img", "*", array('status' => 0));

    $mainarray = array("draw" => $draw, "recordsTotal" => count($get_banner_count), "recordsFiltered" => count($get_banner_count));
    $for_data = array();                
    if (isset($get_banner_data) && !empty($get_banner_data)) {
            $records = $start + 1;
            $sno = $records;
            foreach ($get_banner_data as $key => $values) {
                    $subarray[] = $sno;
                    $sno++;
                    $subarray[] ="<img src=".base_url()."site/uploads/banner/$values->banner_image width=100>";                
                    if($values->status == 0)
                                            $subarray[] = "Enable";
                                            elseif($values->status == 2)
                                            $subarray[] = "Disable";                                        
            if($values->status == 0){
                                     $action = "<a class='disable' style='color:green;' href = ".base_url()."ab_administration/disable_banner/$values->id>
                                     <i class='fa fa-toggle-on'></i></a>";
                             }elseif($values->status == 2){
                                     $action = "<a class='enable' style='color:red;' href = ".base_url()."ab_administration/enable_banner/$values->id>
                                     <i class='fa fa-toggle-off'></i></a>";
                             }
                             $action .= "&nbsp;&nbsp;&nbsp;<a class='edit' href = ".base_url()."ab_administration/edit_banner/$values->id>
                             <i class='fas fa-edit'></i></a>&nbsp;&nbsp;&nbsp;
                             <a class='delete' href = ".base_url()."ab_administration/delete_banner/$values->id><i class='fas fa-trash' style='color:#f3213e'></i></a>";        
                             $subarray[] = $action;        
                             $subarray[] =$values->createdTime;        

                             array_push($for_data, $subarray);
                             unset($subarray);
                     }                                                
             }else{
                     $subarray[] = "<center>---</center>";
                     $subarray[] = "<center>---</center>";
                     $subarray[] = "<center>---</center>";
                     $subarray[] = "<center>---</center>";                                        
             }
            $mainarray['data'] = $for_data;
            echo json_encode($mainarray);
    } 

    // book section

	public function create_book(){
		
		$data['create_book'] = 'menu';
		$data['content'] = "ab_administration/book/create_book";
		$this->load->view('ab_administration/template',$data);
	}
	public function list_book()
	{

		$data['list_book'] = 'menu';
		$data['content'] = "ab_administration/book/list_book";			
		$this->load->view('ab_administration/template',$data);

	}

	public function save_book()
	{
	 $id = $this->input->post('id');							
	$where['id'] = $id;
	$values['title'] = trim($this->input->post('title'));
	// book front image upload
	if(isset($_FILES['image_front']['name']) && !empty($_FILES['image_front']['name'])){
		$config['upload_path']     = 'site/uploads/books';
		$config['allowed_types']   = 'jpg|png|jpeg';
		$config['file_name']       = rand().time();     


		$this->load->library('upload', $config);
	
		if ( ! $this->upload->do_upload('image_front')){
		}
		else{
			$data = array('upload_data' => $this->upload->data());
			$values['image_front'] = $data['upload_data']['file_name'];
		}
	}
	// book back page

	if(isset($_FILES['image_back']['name']) && !empty($_FILES['image_back']['name'])){
		$config['upload_path']     = 'site/uploads/books';
		$config['allowed_types']   = 'jpg|png|jpeg';
		$config['file_name']       = rand().time();     


		$this->load->library('upload', $config);
	
		if ( ! $this->upload->do_upload('image_back')){
		}
		else{
			$data = array('upload_data' => $this->upload->data());
			$values['image_back'] = $data['upload_data']['file_name'];
		}
	}
	// 
	$values['url'] = $this->input->post('url');							
	$values['meta_title'] = trim($this->input->post('meta_title'));
	$values['meta_description'] = trim($this->input->post('meta_description'));
	$values['status'] = trim($this->input->post('status'));
	$values['createdBy'] = get_uid();
	$values['createdTime'] = date("Y-m-d H:i:s");				
	$this->Common_model->insert_record("book", $values, $where);			
	redirect("ab_administration/list_book");

	}
	public function update_book(){
		
		$id = $this->input->post('id');							
		$where['id'] = $id;
		$values['title'] = trim($this->input->post('title'));
		// book front image upload
		if(isset($_FILES['image_front']['name']) && !empty($_FILES['image_front']['name'])){
			$config['upload_path']     = 'site/uploads/books';
			$config['allowed_types']   = 'jpg|png|jpeg';
			$config['file_name']       = rand().time();     


			$this->load->library('upload', $config);
		
			if ( ! $this->upload->do_upload('image_front')){
			}
			else{
				$data = array('upload_data' => $this->upload->data());
				$values['image_front'] = $data['upload_data']['file_name'];
			}
		}
		// book back page

		if(isset($_FILES['image_back']['name']) && !empty($_FILES['image_back']['name'])){
			$config['upload_path']     = 'site/uploads/books';
			$config['allowed_types']   = 'jpg|png|jpeg';
			$config['file_name']       = rand().time();     


			$this->load->library('upload', $config);
		
			if ( ! $this->upload->do_upload('image_back')){
			}
			else{
				$data = array('upload_data' => $this->upload->data());
				$values['image_back'] = $data['upload_data']['file_name'];
			}
		}
		// 
		$values['url'] = $this->input->post('url');							
		$values['meta_title'] = trim($this->input->post('meta_title'));
		$values['meta_description'] = trim($this->input->post('meta_description'));
		$values['status'] = trim($this->input->post('status'));
		$values['createdBy'] = get_uid();
		$values['createdTime'] = date("Y-m-d H:i:s");				
		$this->Common_model->update_record("book", $values, $where);			
		redirect("ab_administration/list_book");
	}
	
	public function edit_book($id){

		$data['content'] = "ab_administration/book/create_book";
		$data['book'] = $this->Common_model->get_record("book","*",array("id"=>$id));
		$this->load->view('ab_administration/template',$data);

	}
	public function disable_book($id){
		
		$where['id'] = $id;
		$values['status'] = 2;
		$this->Common_model->update_record("book", $values, $where);
		
		$this->session->set_flashdata("delete_message","Disabled Successfully...");
		redirect('ab_administration/list_book');
	}

	public function enable_book($id){

		$where['id'] = $id;
		$values['status'] = 0;
		$this->Common_model->update_record("book", $values, $where);
		
		$this->session->set_flashdata("message","Enabled Successfully...");
		redirect('ab_administration/list_book');
	}

	public function delete_book($id){
		$where['id'] = $id;
		$values['status'] = 1;
		$this->Common_model->update_record("book", $values, $where);	
		$this->session->set_flashdata("delete_message","Deleted Successfully...");
		redirect('ab_administration/list_book');
	}
	public function get_book() {
		
	$draw = $_GET['draw'];
	$start = $_GET['start'];
	$length = $_GET['length'];

	$search_array = $_GET['search'];
	$search = $search_array['value'];
	$search = trim($search, " ");

	$get_book_data = $this->Ab_administration_model->get_book($search, $start, $length);

	$get_book_count = $this->Common_model->get_records("book", "*", array('status' => 0));

	$mainarray = array("draw" => $draw, "recordsTotal" => count($get_book_count), "recordsFiltered" => count($get_book_count));
	$for_data = array();		
	if (isset($get_book_data) && !empty($get_book_data)) {
		$records = $start + 1;
		$sno = $records;
		foreach ($get_book_data as $key => $values) {
			$subarray[] = $sno;
			$sno++;
			$subarray[] =  $values->title;				
			if($values->status == 0)
						$subarray[] = "Enable";
						elseif($values->status == 2)
						$subarray[] = "Disable";					
		if($values->status == 0){
					 $action = "<a class='disable' style='color:green;' href = ".base_url()."ab_administration/disable_book/$values->id>
					 <i class='fa fa-toggle-on'></i></a>";
				 }elseif($values->status == 2){
					 $action = "<a class='enable' style='color:red;' href = ".base_url()."ab_administration/enable_book/$values->id>
					 <i class='fa fa-toggle-off'></i></a>";
				 }
				 $action .= "&nbsp;&nbsp;&nbsp;<a class='edit' href = ".base_url()."ab_administration/edit_book/$values->id>
				 <i class='fas fa-edit'></i></a>&nbsp;&nbsp;&nbsp;
				 <a class='delete' href = ".base_url()."ab_administration/delete_book/$values->id><i class='fas fa-trash' style='color:#f3213e'></i></a>";	
				 $subarray[] = $action;						
				 array_push($for_data, $subarray);
				 unset($subarray);
			 }						
		 }else{
			 $subarray[] = "<center>---</center>";
			 $subarray[] = "<center>---</center>";
			 $subarray[] = "<center>---</center>";
			 $subarray[] = "<center>---</center>";
			
		 }
		$mainarray['data'] = $for_data;
		echo json_encode($mainarray);
	}

}