DictsUtils::join() - Code Metrics - ridibooks/platform-common - Measure and Improve Code Quality continuously with Scrutinizer

DictsUtils::join() D
last analyzed 2017-11-29 10:05 UTC

↳ Parent: DictsUtils

Complexity

Conditions	10
Paths	34

Size

Total Lines	42
Code Lines	26

Duplication

Lines	42
Ratio	100 %

Importance

Changes

Metric	Value
dl	42
loc	42
rs	4.8196
c	0
b	0
f	0
cc	10
eloc	26
nc	34
nop	4

How to fix Complexity

<?php

namespace Ridibooks\Platform\Common;

/**
 * sqlDicts 통해서 얻어진 배열에 대해 자주 사용하는 함수들
 */
class DictsUtils
{
	/**
	 * Dicts 에서 특정 key를 가진 값들을 모두 얻기
	 *
	 * $dicts = $db->sqlDicts('select * from tb_book');
	 * $b_ids = DictsUtils::extractValuesByKey($dicts, 'id');
	 *
	 * @param $dicts
	 * @param $key
	 * @return array
	 */
	public static function extractValuesByKey($dicts, $key)
	{
		$return = [];
		foreach ($dicts as $dict) {
			$return[] = $dict[$key];
		}
		return $return;
	}

	/**
	 * Dicts 에서 특정 key 를 기준으로 재배치(key 기준으로 하나밖에 없을떄)
	 *
	 * $dicts = $db->sqlDicts('select * from cpdp_books');
	 * $cpdp_books_by_bid = DictsUtils::alignByKey($dicts, 'b_id');
	 * $cpdp_books_111011110 = $tb_book_property_by_bid['111011110'];
	 *
	 * $cpdp_books_111011110 => ['id' => '123123', 'b_id'=>'111011110', 'title' => '바람과 함께 사라지다']
	 *
	 * @param $dicts
	 * @param $key
	 * @return array
	 */
	public static function alignByKey($dicts, $key)
	{
		$return = [];
		foreach ($dicts as $dict) {
			$return[$dict[$key]] = $dict;
		}
		return $return;
	}

	/**
	 * Dicts 에서 특정 key 를 기준으로 재배치(key 기준으로 여러개 있을떄)
	 *
	 * $dicts = $db->sqlDicts('select * from tb_book_property');
	 * $tb_book_propertys_by_bid = DictsUtils::alignListByKey($dicts, 'b_id');
	 * $tb_book_propertys_111011110 = $tb_book_propertys_by_bid['111011110'];
	 *
	 * $tb_book_propertys_111011110 => [
	 *      ['b_id'=>'111011110', 'key' => 'num_pages', 'vaule' => 123123],
	 *      ['b_id'=>'111011110', 'key' => 'type', 'vaule' => 'pdf'],
	 * ]
	 *
	 * @param $dicts
	 * @param $key
	 * @return array
	 */
	public static function alignListByKey($dicts, $key)
	{
		$return = [];
		foreach ($dicts as $dict) {
			$return[$dict[$key]][] = $dict;
		}
		return $return;
	}

	/**
	 * Dicts 와 Dicts 끼리 join 할때 (SQL 에서 join 하지 않고 PHP에서 join)
	 *
	 * $dictA = $db->sqlDicts('select t_id, amount point from tb_point');
	 * $dictB = $db->sqlDicts('select t_id, amount cash from tb_cash');
	 * $dictNew = DictsUtils::join($dictA, $dictB);
	 *
	 * $dictNew => [
	 *      [t_id => '111', 'point' => 123, 'cash' => 456],
	 *      [t_id => '112', 'point' => 124, 'cash' => 457],
	 * ]
	 *
	 * @param $left_dicts
	 * @param $right_dicts
	 * @param int $left_dicts_column_index_to_join
	 * @param int $right_dicts_column_index_to_join
	 * @return mixed
	 */
	public static function join(

		$left_dicts,
		$right_dicts,
		$left_dicts_column_index_to_join = 0,
		$right_dicts_column_index_to_join = 0
	) {
		if (count($left_dicts) == 0) {
			return $right_dicts;
		}
		if (count($right_dicts) == 0) {
			return $left_dicts;
		}

		$left_keys = array_keys($left_dicts[0]);
		$left_key_to_join = $left_keys[$left_dicts_column_index_to_join];
		$right_keys = array_keys($right_dicts[0]);
		$right_key_to_join = $right_keys[$right_dicts_column_index_to_join];

		foreach ($left_dicts as $lk => $lv) {
			foreach ($right_dicts as $rk => $rv) {
				if ($lv[$left_key_to_join] != $rv[$right_key_to_join]) {
					continue;
				}
				$left_dicts[$lk] = array_merge($lv, $rv);
			}
		}

		$keys = [];
		foreach ($left_dicts as $dict) {
			$keys = array_unique(array_merge($keys, array_keys($dict)));
		}

		foreach ($left_dicts as $dictKey => $dict) {
			foreach ($keys as $key) {
				if (!isset($left_dicts[$dictKey][$key])) {
					$left_dicts[$dictKey][$key] = null;
				}
			}
		}

		return $left_dicts;
	}

	public static function convertDictsToHtmlTable($dicts)
	{
		$th = '';
		$tr = '';
		foreach ($dicts as $index => $dict) {
			$td = '';
			foreach ($dict as $key => $value) {
				if ($index == 0) {
					$th = $th . "<th align='left'>" . $key . "</th>\n";
				}
				$td = $td . "<td align='left'>" . $value . "</td>\n";
			}
			$tr = $tr . "<tr>" . $td . "</tr>\n";
		}

		$html_table = "
		<table cellspacing='0' cellpadding='0' style='width: 100%; border-collapse: collapse; color: #333; font-size: 13px; line-height: 1.7em; border-top:1px solid #848484;'>"
			. "<thead>" . "<tr>" . $th . "</tr>" . "</thead>"
			. "<tbody>" . $tr . "</tbody>" . "</table>";

		return $html_table;
	}
}


1		<?php
2
3		namespace Ridibooks\Platform\Common;
4
5		/**
6		* sqlDicts 통해서 얻어진 배열에 대해 자주 사용하는 함수들
7		*/
8		class DictsUtils
9		{
10		/**
11		* Dicts 에서 특정 key를 가진 값들을 모두 얻기
12		*
13		* $dicts = $db->sqlDicts('select * from tb_book');
14		* $b_ids = DictsUtils::extractValuesByKey($dicts, 'id');
15		*
16		* @param $dicts
17		* @param $key
18		* @return array
19		*/
20		public static function extractValuesByKey($dicts, $key)
21		{
22		$return = [];
23		foreach ($dicts as $dict) {
24		$return[] = $dict[$key];
25		}
26		return $return;
27		}
28
29		/**
30		* Dicts 에서 특정 key 를 기준으로 재배치(key 기준으로 하나밖에 없을떄)
31		*
32		* $dicts = $db->sqlDicts('select * from cpdp_books');
33		* $cpdp_books_by_bid = DictsUtils::alignByKey($dicts, 'b_id');
34		* $cpdp_books_111011110 = $tb_book_property_by_bid['111011110'];
35		*
36		* $cpdp_books_111011110 => ['id' => '123123', 'b_id'=>'111011110', 'title' => '바람과 함께 사라지다']
37		*
38		* @param $dicts
39		* @param $key
40		* @return array
41		*/
42		public static function alignByKey($dicts, $key)
43		{
44		$return = [];
45		foreach ($dicts as $dict) {
46		$return[$dict[$key]] = $dict;
47		}
48		return $return;
49		}
50
51		/**
52		* Dicts 에서 특정 key 를 기준으로 재배치(key 기준으로 여러개 있을떄)
53		*
54		* $dicts = $db->sqlDicts('select * from tb_book_property');
55		* $tb_book_propertys_by_bid = DictsUtils::alignListByKey($dicts, 'b_id');
56		* $tb_book_propertys_111011110 = $tb_book_propertys_by_bid['111011110'];
57		*
58		* $tb_book_propertys_111011110 => [
59		* ['b_id'=>'111011110', 'key' => 'num_pages', 'vaule' => 123123],
60		* ['b_id'=>'111011110', 'key' => 'type', 'vaule' => 'pdf'],
61		* ]
62		*
63		* @param $dicts
64		* @param $key
65		* @return array
66		*/
67		public static function alignListByKey($dicts, $key)
68		{
69		$return = [];
70		foreach ($dicts as $dict) {
71		$return[$dict[$key]][] = $dict;
72		}
73		return $return;
74		}
75
76		/**
77		* Dicts 와 Dicts 끼리 join 할때 (SQL 에서 join 하지 않고 PHP에서 join)
78		*
79		* $dictA = $db->sqlDicts('select t_id, amount point from tb_point');
80		* $dictB = $db->sqlDicts('select t_id, amount cash from tb_cash');
81		* $dictNew = DictsUtils::join($dictA, $dictB);
82		*
83		* $dictNew => [
84		* [t_id => '111', 'point' => 123, 'cash' => 456],
85		* [t_id => '112', 'point' => 124, 'cash' => 457],
86		* ]
87		*
88		* @param $left_dicts
89		* @param $right_dicts
90		* @param int $left_dicts_column_index_to_join
91		* @param int $right_dicts_column_index_to_join
92		* @return mixed
93		*/
94	View Code Duplication	public static function join(
		0 ignored issues – show Duplication introduced 2017-01-13 12:41 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
95		$left_dicts,
96		$right_dicts,
97		$left_dicts_column_index_to_join = 0,
98		$right_dicts_column_index_to_join = 0
99		) {
100		if (count($left_dicts) == 0) {
101		return $right_dicts;
102		}
103		if (count($right_dicts) == 0) {
104		return $left_dicts;
105		}
106
107		$left_keys = array_keys($left_dicts[0]);
108		$left_key_to_join = $left_keys[$left_dicts_column_index_to_join];
109		$right_keys = array_keys($right_dicts[0]);
110		$right_key_to_join = $right_keys[$right_dicts_column_index_to_join];
111
112		foreach ($left_dicts as $lk => $lv) {
113		foreach ($right_dicts as $rk => $rv) {
114		if ($lv[$left_key_to_join] != $rv[$right_key_to_join]) {
115		continue;
116		}
117		$left_dicts[$lk] = array_merge($lv, $rv);
118		}
119		}
120
121		$keys = [];
122		foreach ($left_dicts as $dict) {
123		$keys = array_unique(array_merge($keys, array_keys($dict)));
124		}
125
126		foreach ($left_dicts as $dictKey => $dict) {
127		foreach ($keys as $key) {
128		if (!isset($left_dicts[$dictKey][$key])) {
129		$left_dicts[$dictKey][$key] = null;
130		}
131		}
132		}
133
134		return $left_dicts;
135		}
136
137		public static function convertDictsToHtmlTable($dicts)
138		{
139		$th = '';
140		$tr = '';
141		foreach ($dicts as $index => $dict) {
142		$td = '';
143		foreach ($dict as $key => $value) {
144		if ($index == 0) {
145		$th = $th . "<th align='left'>" . $key . "</th>\n";
146		}
147		$td = $td . "<td align='left'>" . $value . "</td>\n";
148		}
149		$tr = $tr . "<tr>" . $td . "</tr>\n";
150		}
151
152		$html_table = "
153		<table cellspacing='0' cellpadding='0' style='width: 100%; border-collapse: collapse; color: #333; font-size: 13px; line-height: 1.7em; border-top:1px solid #848484;'>"
154		. "<thead>" . "<tr>" . $th . "</tr>" . "</thead>"
155		. "<tbody>" . $tr . "</tbody>" . "</table>";
156
157		return $html_table;
158		}
159		}
160

ridibooks / platform-common

DictsUtils::join() D last analyzed 2017-11-29 10:05 UTC

Complexity

Size

Duplication

Importance

How to fix Complexity

Long Method

Duplication Side-by-Side

Filter issues like

DictsUtils::join() D
last analyzed 2017-11-29 10:05 UTC