<?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')->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')->from('product_review')->where('id', $id);
		$count = $this->db->get()->num_rows();

		if ($count == 0) {
			show_404();
		}

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

		$user_id = $this->session->userdata('admin')['id'];
		$activity = 'User menghapus review(' . $id . ')';

		log_activity($user_id, $activity);

		$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');
	}
}