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

class Product_review extends Admin_Controller {

	function __construct() { 
		parent::__construct();	
	}
		
	//this is to list all product_review
	public function index() {
		
		//pagination in action. 50 results per page
		$this->load->library('pagination');
		$config['base_url'] = base_url() . 'admin/product_review/index';

        $this->db->select('id_product_review')->from('product_review');
        $review_count = $this->db->get()->num_rows();
		$config['total_rows'] = $review_count; 
		$config['per_page'] = 50;
		$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->db->select('*')->from('product_review')->order_by('review_date', 'DESC')->limit($config["per_page"], $this->uri->segment(4));
		$this->data['product_review'] = $this->db->get()->result();

		//load view
		$this->data['subview'] = 'admin/product_review/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 delete a product review
	public function delete($id = NULL) {

        if ($id == NULL) { show_404(); }
         
		//check if id exist. If not exist, show 404.
        $this->db->select('id_product_review')->from('product_review')->where('id_product_review', $id);
        $count = $this->db->get()->num_rows();
		
		if ($count == 0) { show_404(); }	

		//delete product review
		$this->db->delete('product_review', array('id_product_review' => $id)); 

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