<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Blog extends Admin_Controller {

	//this property is used for validating existing blog title on call back edit blog
	private $blog_current_id = NULL;
	private $image1_filename = NULL;
	private $image2_filename = NULL;

	//this property is to mark whether we are uploading image in the index page
	private $imageupload_indexpage = FALSE;
		
	function __construct() { 
		parent::__construct();	
		$this->load->model('blog_m');
		$this->load->helper('form');
		$this->load->library('Sitemap');
	}
		
	//this is to list all blog
	public function index() {

		if (isset($_POST['submit'])) {

			$this->imageupload_indexpage = TRUE;

			//get max image width and height from configuration table
			$this->db->select('blog_image_width, blog_image_height')->from('configuration')->where('id_configuration', 1);
			$image_dimension = $this->db->get()->row();

			//check & processing image banner upload files	
			if ($_FILES['userfile']['size'] !== 0) {  
				$config['upload_path'] = './uploads/blog/'; 
				$config['allowed_types'] = 'jpg|png|jpeg'; 
				$config['max_size']	= '500';
				// $config['max_width'] = $image_dimension->blog_image_width;
				// $config['max_height'] = $image_dimension->blog_image_height;
				
				$this->load->library('upload', $config); 

				if ( ! $this->upload->do_upload()) {

					//echo $this->upload->display_errors(); die();
						
					$this->session->set_flashdata('banner_error', '<br>
						<p style="background:orange; color:white; padding:5px; font-weight:bold;">Image Upload Error. Wrong format or size.</p>');

					if ($this->blog_current_id != NULL) {
						redirect('admin/blog/edit/' . $this->blog_current_id);
					} elseif($this->blog_current_id == NULL && $this->imageupload_indexpage == FALSE) {
						redirect('admin/blog/add');
					} elseif($this->blog_current_id == NULL && $this->imageupload_indexpage == TRUE) {
						redirect('admin/blog');
					}
				
				} else {
					$image = $this->upload->data();
					$image_filename = $image['file_name']; 	 
				}	
			}

			//store image information to configuration table
			$data = array();
			//image upload
			if (isset($image_filename)) {
				$data['blog_landingpage_image'] = $image_filename; 
			} 
			$this->db->where('id_configuration', 1);
			$this->db->update('configuration', $data); 

			$this->session->set_flashdata('success', '<br><p style="background:green; color:white; padding:5px; font-weight:bold;">Blog Landing Page Edit Successful</p>');
		}

		//get landingpage banner image, description and link
		$this->db->select('blog_landingpage_description, blog_landingpage_image, blog_landingpage_link')->from('configuration')->where('id_configuration', 1);
		$this->data['blog_landingpage'] = $this->db->get()->row();
		
		//pagination in action. 100 results per page 
		$this->load->library('pagination');
		$config['base_url'] = base_url() . 'admin/blog/index';
		$config['total_rows'] = $this->blog_m->record_count(); 
		$config['per_page'] = 100;
		$config["uri_segment"] = 4;
		$config['num_tag_open'] = '<span style="padding-left:10px; padding-right:10px">';
		$config['num_tag_close'] = '</span>';

		$this->pagination->initialize($config);
   		$this->data['blog'] = $this->blog_m->get_all_blog($config["per_page"], 
		$this->uri->segment(4));   

		//load view
		$this->data['subview'] = 'admin/blog/index';
		$this->load->view('admin/templates/header', $this->data_header); 
		$this->load->view('admin/_layout_main', $this->data);
		$this->load->view('admin/templates/footer');	
    }
	
	//to add a new blog 
	public function add() {
		$this->data['blog'] = $this->blog_m->get_new();	
		
		//validation in action
		//validation check in action 
		$config = $this->blog_m->rules; 

		$this->load->library('form_validation');
		$this->form_validation->set_rules($config); 
		$this->form_validation->set_error_delimiters('<div class="error">', '</div>');

		if($this->form_validation->run($this) == TRUE) {

			//get max image width and height from configuration table
			$this->db->select('blog_image_width, blog_image_height, blog_thumbnail_width, blog_thumbnail_height')->from('configuration')->where('id_configuration', 1);
			$image_dimension = $this->db->get()->row();

			//check & processing IMAGE INTRO
			if ($_FILES['image1']['size'] !== 0) { 	

				$config['upload_path'] = './uploads/blog/'; 
				$config['allowed_types'] = 'jpg|png|jpeg'; 
				$config['max_size']	= '600'; 
				// $config['max_width'] = '370';
				// $config['max_height'] = '247';

				$this->load->library('upload', $config); 

				if ( ! $this->upload->do_upload('image1')) {

				// return the error message and kill the script
     			echo $this->upload->display_errors(); exit;

				$this->session->set_flashdata('image1-error', '<br>
					<p style="background:red; color:white; padding:5px; font-weight:bold;">Image Upload Error. Wrong format or size.</p>');
				redirect('admin/blog/add');
				
				} else {
					$image1 = $this->upload->data();
					$this->image1_filename = $image1['file_name']; 
					
				} 
			}

			//check & processing IMAGE MAIN
			if ($_FILES['image2']['size'] !== 0) { 	 

				$config['upload_path'] = './uploads/blog/'; 
				$config['allowed_types'] = 'jpg|png|jpeg'; 
				$config['max_size']	= '600'; 
				// $config['max_width'] = '770';
				// $config['max_height'] = '367';

				$this->load->library('upload', $config); 

				if ( ! $this->upload->do_upload('image2')) {

				// return the error message and kill the script
     			echo $this->upload->display_errors(); exit;

				$this->session->set_flashdata('image2-error', '<br>
					<p style="background:red; color:white; padding:5px; font-weight:bold;">Image Upload Error. Wrong format or size.</p>');
				redirect('admin/blog/add');
				
				} else {
					$image2 = $this->upload->data();
					$this->image2_filename = $image2['file_name']; 
					
				} 
			}

			$data = $this->table_data_processing($this->input->post('blog_name'), $this->input->post('status'), $this->input->post('description'), $this->image1_filename, $this->image2_filename, $this->input->post('meta_description'), $this->input->post('meta_keywords'), $this->input->post('publish_date'));
		
			$this->blog_m->add_blog($data);

			// generate site map
	    	$this->sitemap->create();

			$this->session->set_flashdata('success', '<br><p style="background:green; color:white; padding:5px; font-weight:bold;">Blog Add Successful</p>');

			redirect('admin/blog');
		} 
		
		$this->data['subview'] = 'admin/blog/edit';
		$this->load->view('admin/templates/header', $this->data_header); 
		$this->load->view('admin/_layout_main', $this->data);
		$this->load->view('admin/templates/footer');	
	}
	
	//to edit blog in admin
	public function edit($id = NULL) {

		if ($id == NULL) { show_404(); }

		//check if id exist. If not exist, show 404.
		$count = $this->blog_m->count_exist($id);
		
		if ($count == 0) { 
			//page not exist
			show_404();
		}		

		$this->data['blog'] = $this->blog_m->get($id);	

		$this->blog_current_id = (int) $id;

		//validation check in action
		$config = $this->blog_m->rules;

		$this->load->library('form_validation');
		$this->form_validation->set_rules($config); 
		$this->form_validation->set_error_delimiters('<div class="error">', '</div>');

		if($this->form_validation->run($this) == TRUE) {
			//get max image width and height from configuration table
			$this->db->select('blog_image_width, blog_image_height, blog_thumbnail_width, blog_thumbnail_height')->from('configuration')->where('id_configuration', 1);
			$image_dimension = $this->db->get()->row();

			//check & processing IMAGE INTRO
			if ($_FILES['image1']['size'] !== 0) { 	

				$config['upload_path'] = './uploads/blog/'; 
				$config['allowed_types'] = 'jpg|png|jpeg'; 
				$config['max_size']	= '600'; 
				// $config['max_width'] = '500';
				// $config['max_height'] = '230';

				$this->load->library('upload', $config); 

				if ( ! $this->upload->do_upload('image1')) {

				// return the error message and kill the script
     			echo $this->upload->display_errors(); 

				$this->session->set_flashdata('image1-error', '<br>
					<p style="background:red; color:white; padding:5px; font-weight:bold;">Image Upload Error. Wrong format or size.</p>');
				redirect('admin/blog/edit/' . $id);
				
				} else {
					$image1 = $this->upload->data();
					$this->image1_filename = $image1['file_name']; 
				} 
			}

			if ($_FILES['image2']['size'] !== 0) { 	

				$config['upload_path'] = './uploads/blog/'; 
				$config['allowed_types'] = 'jpg|png|jpeg'; 
				$config['max_size']	= '600'; 
				// $config['max_width'] = '500';
				// $config['max_height'] = '230';

				$this->load->library('upload', $config); 

				if ( ! $this->upload->do_upload('image2')) {

				// return the error message and kill the script
     			echo $this->upload->display_errors(); 

				$this->session->set_flashdata('image1-error', '<br>
					<p style="background:red; color:white; padding:5px; font-weight:bold;">Image Upload Error. Wrong format or size.</p>');
				redirect('admin/blog/edit/' . $id); 
				
				} else {
					$image2 = $this->upload->data();
					$this->image2_filename = $image2['file_name']; 
				} 
			}

			$data = $this->table_data_processing($this->input->post('blog_name'), $this->input->post('status'), $this->input->post('description'), $this->image1_filename, $this->image2_filename, $this->input->post('meta_description'), $this->input->post('meta_keywords'), $this->input->post('publish_date'));

			$this->blog_m->edit_blog($id, $data); 

			// generate site map
	    	$this->sitemap->create();

			$this->session->set_flashdata('success', '<br><p style="background:green; color:white; padding:5px; font-weight:bold;">Blog Edit Successful</p>');
			
			redirect('admin/blog/edit/' .  $id);
		} 
		
		$this->data['subview'] = 'admin/blog/edit';
		$this->load->view('admin/templates/header', $this->data_header); 
		$this->load->view('admin/_layout_main', $this->data);
		$this->load->view('admin/templates/footer');	
	}
	

	//to delete a blog
	public function delete($id) {

		//check if id exist. If not exist, show 404.
		$count = $this->blog_m->count_exist($id);
		
		if ($count == 0) { //page not exist
			show_404();
		}		

		//delete image from server
		//check if there is an existing image
		$this->db->select('image1, image2')->from('blog')->where('id_blog', (int) $id);
		$image = $this->db->get()->row();
		
		if ($image->image1 != '') {
			//Delete the actual image file from server. FCPATH is codeigniter base path
			unlink(FCPATH .'/uploads/blog/'. $image->image1);
		} 

		if ($image->image2 != '') {
			//Delete the actual image file from server. FCPATH is codeigniter base path
			unlink(FCPATH .'/uploads/blog/'. $image->image2);
		} 

		//delete blog
		$this->blog_m->delete($id); 

		$this->session->set_flashdata('success', '<br><p style="background:green; color:white; padding:5px; font-weight:bold;">Blog Delete Successful</p>');
		redirect('admin/blog');
	} 

	private function table_data_processing($blog_name, $status, $description, 
		$image1_filename, $image2_filename, $meta_description, $meta_keywords, $publish_date) {

		$publish_date = explode('-',$publish_date);	
		$publish_date = $publish_date[2] . '-' . $publish_date[1] . '-' . $publish_date[0];

		$data = array(
			'blog' 			=> $this->security->xss_clean($blog_name),
			'blog_en' 		=> $this->security->xss_clean($this->input->post('blog_name_en')),
			'alias' 		=> url_title(strtolower($blog_name)), 
			'alias_en' 		=> url_title(strtolower($this->input->post('blog_name_en'))),
			'status' 		=> $status,
			'description' 	=> $description,
			'description_en' => $this->security->xss_clean($this->input->post('description_en')),
			'publish_date' 	=> $publish_date,	 
			'meta_description' => $this->security->xss_clean($this->input->post('meta_description')),
			'meta_keywords' => $this->security->xss_clean($this->input->post('meta_keywords')),
			'meta_title' => $this->security->xss_clean($this->input->post('meta_title'))
		);

		//image upload
		if (isset($image1_filename)) {
			$data['image1'] = $image1_filename; 
		} 

		if (isset($image2_filename)) {
			$data['image2'] = $image2_filename; 
		} 

		return $data;
	}

	//callback function validation add new blog
	//make it private by adding _
	public function _cek_existing_blog_title($str) {

		$num_rows = $this->blog_m->cek_existing_blog_title($str, $this->blog_current_id);   
		if ($num_rows != 0 ) {  
			$this->form_validation->set_message('_cek_existing_blog_title', 'blog name already exist !');
			return FALSE;
		} else {
			return TRUE;   
		}
	}

	public function _cek_existing_blog_title_en($str) {

		$num_rows = $this->blog_m->cek_existing_blog_title_en($str, $this->blog_current_id);   
		if ($num_rows != 0 ) {  
			$this->form_validation->set_message('_cek_existing_blog_title_en', 'blog name english already exist !');
			return FALSE;
		} else {
			return TRUE;   
		}
	}

	//To delete blog landingpage banner image file from server, and from database
	public function delete_landingpage_image() { 

		//get image file name for deletion
		$this->db->select('blog_landingpage_image')->from('configuration')->where('id_configuration', 1);
		$image = $this->db->get()->row()->blog_landingpage_image;

		//Delete the actual image file from server. FCPATH is codeigniter base path
		unlink(FCPATH .'/uploads/blog/'. $image);

		//Delete image field from database
		$data = array( 
			'blog_landingpage_image' => '',
		);

		$this->db->where('id_configuration', 1);
		$this->db->update('configuration', $data);	

		$this->session->set_flashdata('success', '<br><p style="background:green; color:white; padding:5px; font-weight:bold;">Image Delete Successful</p>');
		
		redirect('admin/blog'); 
	}

	//To delete blog image file from server, and from database
	public function delete_image($id = NULL, $image_type = NULL) { 

		$count = $this->blog_m->count_exist($id);

		if ($id == NULL || $count == 0) {	redirect('admin/blog'); }

		if ($image_type == NULL) {redirect('admin/blog'); }

		//get image file name for deletion
		$this->db->select('image1, image2')->from('blog')->where('id_blog', (int) $id);
		$image = $this->db->get()->row();

		if($image_type == 'image1') {
			//Delete the actual image file from server. FCPATH is codeigniter base path
			unlink(FCPATH .'/uploads/blog/'. $image->image1);

			//Delete image field from database
			$data = array( 
				'image1' => '',
			);

		} elseif($image_type == 'image2') {
			//Delete the actual image file from server. FCPATH is codeigniter base path
			unlink(FCPATH .'/uploads/blog/'. $image->image2);

			//Delete image field from database
			$data = array( 
				'image2' => '',
			);
		}

		$this->db->where('id_blog', (int) $id);
		$this->db->update('blog', $data);	

		$this->session->set_flashdata('success', '<br><p style="background:green; color:white; padding:5px; font-weight:bold;">Image Delete Successful</p>');
		
		redirect('admin/blog/edit/' . $id); 
	}	
}