"PHP 다중정렬 sortOrderBy()"의 두 판 사이의 차이

2021년 10월 2일 (토) 16:28 기준 최신판

1 개요[ | ]

PHP 다중정렬 orderBy()
PHP 다중정렬 sortValues()
PHP 다중정렬 sortOrderBy()

function sortValues($array, $by, $ascending=[]) {
    $makeComparer = function ($criteria) {
        return function ($a, $b) use ($criteria) {
            foreach( $criteria[0] as $i => $key) {
                $asc = $criteria[1][$i] ?? true;
                if ($a[$key] < $b[$key]) return $asc ? -1 : 1;
                if ($a[$key] > $b[$key]) return $asc ? 1 : -1;
            }
            return 0;
        };
    };
    usort($array, $makeComparer([$by, $ascending]));
    return $array;
}

$employees = [
	['EmployeeID'=>'1', 'Name'=>'한놈', 'BirthDate'=>'1999-01-01'],
	['EmployeeID'=>'2', 'Name'=>'두시기', 'BirthDate'=>'2000-01-01'],
	['EmployeeID'=>'3', 'Name'=>'석삼', 'BirthDate'=>'1999-01-01'],
	['EmployeeID'=>'4', 'Name'=>'너구리', 'BirthDate'=>'2000-01-01'],
];

# BirthDate 오름차순
$employees1 = sortValues($employees, ['BirthDate']);
# BirthDate 내림차순
$employees2 = sortValues($employees, ['BirthDate'], [false]);
# BirthDate, Name 오름차순
$employees3 = sortValues($employees, ['BirthDate','Name']);
# BirthDate 오름차순, Name 내림차순
$employees4 = sortValues($employees, ['BirthDate','Name'], [true,false]);

# 출력
for($i=1; $i<=4; $i++) {
    $var = "employees$i";
    echo "$var: \n", str_replace('},',"},\n",json_encode($$var,JSON_UNESCAPED_UNICODE))."\n\n";
}

2 같이 보기[ | ]

3 참고[ | ]

http://php.net/manual/en/function.usort.php

@@ 1번째 줄: / 1번째 줄: @@
 ==개요==
-;PHP orderBy()
+;PHP 다중정렬 orderBy()
+;PHP 다중정렬 sortValues()
-<source lang='php'>
+;PHP 다중정렬 sortOrderBy()
-function orderBy(&$ary, $clause, $ascending = true) {
-	$clause = str_ireplace('order by', '', $clause);
-	$clause = preg_replace('/\s+/', ' ', $clause);
-	$keys = explode(',', $clause);
-	$dirMap = array('desc' => 1, 'asc' => -1);
-	$def = $ascending ? -1 : 1;
-	$keyAry = array();
-	$dirAry = array();
-	foreach($keys as $key) {
-		$key = explode(' ', trim($key));
-		$keyAry[] = trim($key[0]);
-		if(isset($key[1])) {
-			$dir = strtolower(trim($key[1]));
-			$dirAry[] = $dirMap[$dir] ? $dirMap[$dir] : $def;
-		} else {
-			$dirAry[] = $def;
-		}
-	}
-	$fnBody = '';
-	for($i = count($keyAry) - 1; $i >= 0; $i--) {
-		$k = $keyAry[$i];
-		$t = $dirAry[$i];
-		$f = -1 * $t;
-		$aStr = '$a[\''.$k.'\']';
-		$bStr = '$b[\''.$k.'\']';
-		if(strpos($k, '(') !== false) {
-			$aStr = '$a->'.$k;
-			$bStr = '$b->'.$k;
-		}
-		if($fnBody == '') {
-			$fnBody .= "if({$aStr} == {$bStr}) { return 0; }\n";
-			$fnBody .= "return ({$aStr} < {$bStr}) ? {$t} : {$f};\n";
-		} else {
-			$fnBody = "if({$aStr} == {$bStr}) {\n" . $fnBody;
-			$fnBody .= "}\n";
-			$fnBody .= "return ({$aStr} < {$bStr}) ? {$t} : {$f};\n";
-		}
-	}
-	if($fnBody) {
+<syntaxhighlight lang='php' line run>
-		$sortFn = create_function('$a,$b', $fnBody);
+function sortValues($array, $by, $ascending=[]) {
-		usort($ary, $sortFn);
+    $makeComparer = function ($criteria) {
-	}
+        return function ($a, $b) use ($criteria) {
+            foreach( $criteria[0] as $i => $key) {
+                $asc = $criteria[1][$i] ?? true;
+                if ($a[$key] < $b[$key]) return $asc ? -1 : 1;
+                if ($a[$key] > $b[$key]) return $asc ? 1 : -1;
+            }
+            return 0;
+        };
+    };
+    usort($array, $makeComparer([$by, $ascending]));
+    return $array;
 }
@@ 57번째 줄: / 27번째 줄: @@
 	['EmployeeID'=>'4', 'Name'=>'너구리', 'BirthDate'=>'2000-01-01'],
 ];
-orderBy($employees, 'BirthDate DESC, Name ASC');
-print_r($employees);
+# BirthDate 오름차순
-</source>
+$employees1 = sortValues($employees, ['BirthDate']);
-:→ 생년월일(BirthDate) 역순 정렬, 이름순 정렬
+# BirthDate 내림차순
+$employees2 = sortValues($employees, ['BirthDate'], [false]);
+# BirthDate, Name 오름차순
+$employees3 = sortValues($employees, ['BirthDate','Name']);
+# BirthDate 오름차순, Name 내림차순
+$employees4 = sortValues($employees, ['BirthDate','Name'], [true,false]);
+# 출력
+for($i=1; $i<=4; $i++) {
+    $var = "employees$i";
+    echo "$var: \n", str_replace('},',"},\n",json_encode($$var,JSON_UNESCAPED_UNICODE))."\n\n";
+}
+</syntaxhighlight>
 ==같이 보기==
-*[[PHPLinq 2차원 배열 employees 예제]]
+* [[PHPLinq 2차원 배열 employees 예제]]
-*[[PHPLinq 2차원 배열 employees 예제 2]]
+* [[PHPLinq 2차원 배열 employees 예제 2]]
-*[[PHPLinq 설치]]
+* [[PHPLinq 설치]]
+* [[함수 orderBy()]]
 ==참고==