ernadoo\phpbbdirectory\core\comment

Complexity

Total Complexity

5

Size/Duplication

Total Lines	100
Duplicated Lines	19 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	5	1
A	add()	0	14	1
A	edit()	0	7	1
A	del()	19	36	2

<?php
/**
*
* phpBB Directory extension for the phpBB Forum Software package.
*
* @copyright (c) 2014 ErnadoO <http://www.phpbb-services.com>
* @license GNU General Public License, version 2 (GPL-2.0)
*
*/

namespace ernadoo\phpbbdirectory\core;

use \ernadoo\phpbbdirectory\core\helper;

class comment extends helper
{
	/** @var \phpbb\db\driver\driver_interface $db */
	protected $db;

	/** @var \phpbb\language\language */
	protected $language;

	/**
	* Constructor
	*
	* @param \phpbb\db\driver\driver_interface	$db			Database object
	* @param \phpbb\language\language			$language	Language object
	*/
	public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\language\language $language)
	{
		$this->db		= $db;
		$this->language	= $language;
	}

	/**
	* Add a comment
	*
	* @param	array	$data	Link's data from db
	* @return	null
	*/
	public function add($data)
	{
		$this->db->sql_transaction('begin');

		$sql = 'INSERT INTO ' . $this->comments_table . ' ' . $this->db->sql_build_array('INSERT', $data);
		$this->db->sql_query($sql);

		$sql = 'UPDATE ' . $this->links_table . '
			SET link_comment = link_comment + 1
			WHERE link_id = ' . (int) $data['comment_link_id'];
		$this->db->sql_query($sql);

		$this->db->sql_transaction('commit');
	}

	/**
	* Edit a comment
	*
	* @param	array	$data		Data to edit
	* @param	int		$comment_id	The comment ID
	* @return	null
	*/
	public function edit($data, $comment_id)
	{
		$sql = 'UPDATE ' . $this->comments_table . '
			SET ' . $this->db->sql_build_array('UPDATE', $data) . '
			WHERE comment_id = ' . (int) $comment_id;
		$this->db->sql_query($sql);
	}

	/**
	* Delete a comment
	*
	* @param	string	$link_id	The link ID
	* @param	string	$comment_id	The comment ID
	* @return	null
	*/
	public function del($link_id, $comment_id)
	{
		global $request;

		$this->db->sql_transaction('begin');

		$sql = 'DELETE FROM ' . $this->comments_table . ' WHERE comment_id = ' . (int) $comment_id;
		$this->db->sql_query($sql);

		$sql = 'UPDATE ' . $this->links_table . '
			SET link_comment = link_comment - 1
			WHERE link_id = ' . (int) $link_id;
		$this->db->sql_query($sql);

		$this->db->sql_transaction('commit');

		if ($request->is_ajax())
		{
			$sql = 'SELECT COUNT(comment_id) AS nb_comments
				FROM ' . $this->comments_table . '
				WHERE comment_link_id = ' . (int) $link_id;
			$result = $this->db->sql_query($sql);
			$nb_comments = (int) $this->db->sql_fetchfield('nb_comments');
			$this->db->sql_freeresult($result);

			$json_response = new \phpbb\json_response;
			$json_response->send(array(
				'success' => true,

				'MESSAGE_TITLE'		=> $this->language->lang('INFORMATION'),
				'MESSAGE_TEXT'		=> $this->language->lang('DIR_COMMENT_DELETE_OK'),
				'COMMENT_ID'		=> $comment_id,
				'TOTAL_COMMENTS'	=> $this->language->lang('DIR_NB_COMMS', $nb_comments),
			));
		}
	}
}