<?php
/**
 * @package		JLex Review
 * @version		4.2.3
 * @copyright	Copyright (c) 2013-2018 JLexArt. All rights reserved
 * @license		GNU General Public License version 2 or later;
 * @author		www.jlexart.com
 */

defined('_JEXEC') or die;

class TableJRComment extends JTable
{
	public $id = null;

	public $review_id = null;

	public $entry_id = null;

	public $comment = null;

	public $created = null;

	public $modified = null;

	public $created_by = null;

	public $modified_by = null;

	public $author_name = null;

	public $author_email = null;

	public $ip_address = null;

	public $reply_id = null;

	public $parent_id = null;

	public $published = null;

	public $count_like = 0;

	public $count_dislike = 0;

	public $count_child = 0;

	public function __construct(&$db)
	{
		parent::__construct ( '#__jlexreview_cm', 'id', $db );
	}

	public function check()
	{
		if(!$this->created)
		{
			$this->created = JFactory::getDate()->toSql();
		}

		if(!$this->ip_address)
		{
			$this->ip_address = JLexReviewHelperAdmin::ip_address();
		}

		return true;
	}

	public function do_remove()
	{
		if(!$this->id) return false;

		$query = $this->_db->getQuery(true);
		$query->delete("#__jlexreview_cm")
			  ->where("id=".$this->_db->quote($this->id));

		$this->_db->setQuery($query)->execute();

		JLexReviewHelperAdmin::updateCommentOfRating($this->review_id);
		JLexReviewHelperAdmin::updateUserParams($this->created_by);

		// clear cache
		$config = JLexReviewHelperAdmin::getConfig();
        if($config->get("cache",1)==0) JFactory::getCache()->clean();

		return true;
	}

	public function do_publish($state)
	{
		if(!$this->id || $this->published==$state) return true;

		$query = $this->_db->getQuery(true);
		$query->update("#__jlexreview_cm")
			  ->set("published=".$this->_db->quote($state))
			  ->where("id=".$this->_db->quote($this->id));

		$this->_db->setQuery($query)->execute();

		JLexReviewHelperAdmin::updateCommentOfRating($this->review_id);

		// clear cache
		$config = JLexReviewHelperAdmin::getConfig();
        if($config->get("cache",1)==0) JFactory::getCache()->clean();
        
		return true;
	}
}