<?php
/**
* @package RSFeedback!
* @copyright (C) 2010-2018 www.rsjoomla.com
* @license GPL, http://www.gnu.org/copyleft/gpl.html
*/

// No direct access
defined( '_JEXEC' ) or die( 'Restricted access' );

use Joomla\CMS\Language\Text;
use Joomla\CMS\Table\Table;
use Joomla\CMS\Factory;

class RSFeedbackTableFeedback extends Table
{
	public function __construct(& $db) {
		parent::__construct('#__rsfeedback_feedbacks', 'id', $db);
	}

	public function check() {
		// Captcha check for frontend
		$app 		 = Factory::getApplication();
		$input		 = $app->input;
		$jform 		 = $input->get('jform',array(),'array');
		$id 		 = $jform['id'];
		$config 	 = RSFeedbackHelper::getConfig();
		$valid 		 = true;

		// compare the title length with the configured title limit value
		if ( strlen($jform['title']) > $config->feedback_titlemaxlength ) {
			$this->setError(Text::sprintf('COM_RSFEEDBACK_FEEDBACK_SAVE_TITLE_TOO_LONG_ERROR', $config->feedback_titlemaxlength));
			$valid = false;
		}

		if ($app->isClient('site')) {
			$permissions = RSFeedbackHelper::getPermissions();
			if (isset($id) && $permissions['captcha_feedback']) {
				$controller = new RSFeedbackController();
				$app->input->set('permission', 'captcha_feedback');
				$valid = $controller->checkCaptcha(true);

				if (!$valid) {
					$this->setError(Text::_('COM_RSFEEDBACK_INVALID_CAPTCHA'));
				}
			}
		}
		
		return $valid;
	}
	
	public function delete($pk = null, $children = false) {
		$db		= $this->getDBO();
		$query	= $db->getQuery(true);
		
		$query->clear()->delete($db->qn('#__rsfeedback_user_flags'))->where($db->qn('feedback_id').' = '.$db->q($pk));
		$db->setQuery($query);
		$db->execute();

		$query->clear()->delete($db->qn('#__rsfeedback_user_votes'))->where($db->qn('feedback_id').' = '.$db->q($pk));
		$db->setQuery($query);
		$db->execute();
		
		$query->clear()->delete($db->qn('#__rsfeedback_comments'))->where($db->qn('feedback_id').' = '.$db->q($pk));
		$db->setQuery($query);
		$db->execute();

		$query->clear()->delete($db->qn('#__rsfeedback_subscriptions'))->where($db->qn('feedback_id').' = '.$db->q($pk));
		$db->setQuery($query);
		$db->execute();
		
		return parent::delete($pk, $children);
	}
}