[Javascript] replaceAll & 치환할 문자 변수로.

13 Mar 2022 in Dev on Dev Note

자바스크립트에서 replaceAll을 지원하지 않기 때문에

[Vue] Uncaught TypeError: Cannot read properties of undefined (reading 'prototype')

29 Jan 2022 in Dev on Trouble Shooting

[Vue] 1 - Vue등 프레임워크의 탄생 배경

28 Jan 2022 in Dev on Vue

# 1990년대 중반 - Static Sites

[PHP] 2차원 배열 정렬 by value

24 Jan 2022 in Dev on Dev Note

PHP 2차원 배열 값으로 정렬하기

# Code ```php function arr_sort( $array, $key, $sort ){ $keys = array(); $vals = array(); foreach( $array as $k=>$v ){ $i = $v[$key].’.’.$k; $vals[$i] = $v; array_push($keys, $k); } unset($array);

[Postgresql] 계층형 쿼리

20 Jan 2022 in Dev on Dev Note

WITH RECURSIVE dept_record(idx, parent, name, help, level, path, cycle) AS ( SELECT d.idx, d.parent, d.name, d.help, 0, ARRAY [d.idx], false FROM t_menu d WHERE d.parent IS NULL UNION ALL SELECT d.idx, d.parent, d.name, d.help, level + 1, path || d.idx, d.idx = ANY (path) FROM t_menu d, dept_record dr WHERE d.parent = dr.idx AND NOT CYCLE ) SELECT idx, parent, name, help, level, path FROM dept_record ORDER BY path;