MessageMapper::getMessagesByConvId() - Code Metrics - owncloud/chat - Measure and Improve Code Quality continuously with Scrutinizer

MessageMapper::getMessagesByConvId() B
last analyzed 2016-04-23 05:25 UTC

↳ Parent: MessageMapper

Complexity

Conditions	2
Paths	2

Size

Total Lines	30
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Metric	Value
dl	0
loc	30
rs	8.8571
cc	2
eloc	11
nc	2
nop	3

<?php
/**
 * Copyright (c) 2014, Tobia De Koninck hey--at--ledfan.be
 * This file is licensed under the AGPL version 3 or later.
 * See the COPYING file.
 */

namespace OCA\Chat\OCH\Db;

use \OCP\AppFramework\Db\Mapper;
use \OCP\IDb;

class MessageMapper extends Mapper{

	public function __construct(IDb $api) {
		parent::__construct($api, 'chat_och_messages'); // tablename is news_feeds
	}
 
	public function getMessagesByConvId($convId, $user, $startpoint=0){
		$sql = <<<SQL
			SELECT
				*
			FROM
				*PREFIX*chat_och_messages
			WHERE
				`convid` = ?
			AND
				`timestamp` > (
					SELECT
						`joined`
					FROM
						*PREFIX*chat_och_users_in_conversation
					WHERE
						`user` = ?
					AND `conversation_id` = ?
				)
SQL;
		if($startpoint !== 0){
			$sql = $sql . <<<SQL
			AND
				`timestamp` > ?
SQL;
			return $this->findEntities($sql, array($convId, $user, $convId, $startpoint));
		} else {
			return $this->findEntities($sql, array($convId, $user, $convId));
		}

	}

	public function getMessagesByConvIdLimit($convId, $user, $limit){
		$sql = <<<SQL
			SELECT
				*
			FROM
				*PREFIX*chat_och_messages
			WHERE
				`convid` = ?
			AND
				`timestamp` > (
					SELECT
						`joined`
					FROM
						*PREFIX*chat_och_users_in_conversation
					WHERE
						`user` = ?
					AND `conversation_id` = ?
				)
			ORDER BY timestamp DESC
			LIMIT ?,?
SQL;
		return $this->findEntities($sql, array($convId, $user, $convId, $limit[0], $limit[1]));
	}

}


1			<?php
2			/**
3			* Copyright (c) 2014, Tobia De Koninck hey--at--ledfan.be
4			* This file is licensed under the AGPL version 3 or later.
5			* See the COPYING file.
6			*/
7
8			namespace OCA\Chat\OCH\Db;
9
10			use \OCP\AppFramework\Db\Mapper;
11			use \OCP\IDb;
12
13			class MessageMapper extends Mapper{
14
15			public function __construct(IDb $api) {
16			parent::__construct($api, 'chat_och_messages'); // tablename is news_feeds
17			}
18
19			public function getMessagesByConvId($convId, $user, $startpoint=0){
20			$sql = <<<SQL
21			SELECT
22			*
23			FROM
24			PREFIXchat_och_messages
25			WHERE
26			`convid` = ?
27			AND
28			`timestamp` > (
29			SELECT
30			`joined`
31			FROM
32			PREFIXchat_och_users_in_conversation
33			WHERE
34			`user` = ?
35			AND `conversation_id` = ?
36			)
37			SQL;
38			if($startpoint !== 0){
39			$sql = $sql . <<<SQL
40			AND
41			`timestamp` > ?
42			SQL;
43			return $this->findEntities($sql, array($convId, $user, $convId, $startpoint));
44			} else {
45			return $this->findEntities($sql, array($convId, $user, $convId));
46			}
47
48			}
49
50			public function getMessagesByConvIdLimit($convId, $user, $limit){
51			$sql = <<<SQL
52			SELECT
53			*
54			FROM
55			PREFIXchat_och_messages
56			WHERE
57			`convid` = ?
58			AND
59			`timestamp` > (
60			SELECT
61			`joined`
62			FROM
63			PREFIXchat_och_users_in_conversation
64			WHERE
65			`user` = ?
66			AND `conversation_id` = ?
67			)
68			ORDER BY timestamp DESC
69			LIMIT ?,?
70			SQL;
71			return $this->findEntities($sql, array($convId, $user, $convId, $limit[0], $limit[1]));
72			}
73
74			}
75

owncloud / chat

MessageMapper::getMessagesByConvId() B last analyzed 2016-04-23 05:25 UTC

Complexity

Size

Duplication

Duplication Side-by-Side

Filter issues like

MessageMapper::getMessagesByConvId() B
last analyzed 2016-04-23 05:25 UTC