Skip to content

Instantly share code, notes, and snippets.

@baramoss
baramoss / sampleJs012.js
Last active May 9, 2023 00:03
[JavaScript] DataTables - 특정 row 음영 처리
<script type="text/javascript">
// code omitted for brevity
tableObject = $("#" + dataTableName).DataTable({
"ajax" : {
type : "POST"
, url : _url
, dataSrc : "data"
}
@baramoss
baramoss / sampleJs011.js
Created May 2, 2023 23:58
[JavaScript] ApexCharts.js - Column Chart의 Column 색 다양화
<script type="text/javascript">
// code omitted for brevity
options = {
// code omitted for brevity
plotOptions: {
bar: {
@baramoss
baramoss / sampleJs010.js
Last active May 1, 2023 23:54
[JavaScript] ApexCharts.js - Map 이용
<script type="text/javascript">
// code omitted for brevity
var dataArray = [];
var categoryNm = [];
<c:forEach var="list" items="${abilityList}">
var applyStdAvgAbilityInfo = '${applyStdAvgAbilityInfo[list.cdId.toLowerCase()]}';
dataArray.push(applyStdAvgAbilityInfo);
categoryNm.push("${list.cdNm}");
@baramoss
baramoss / sampleJs009.js
Created April 27, 2023 23:48
[JavaScript] ApexCharts.js - 차트 가운데 정렬
<script type="text/javascript">
$(document).ready(function() {
$(".apexcharts-canvas").css({"text-align": "center", "margin": "auto"});
});
// code omitted for brevity
</script>
@baramoss
baramoss / sampleJs008.js
Created April 27, 2023 23:40
[JavaScript] ApexCharts.js - 그래프 간격이 좁아도 데이터가 표시되도록 처리
<script type="text/javascript">
// code omitted for brevity
function drawStatChart() {
var options = {
// code omitted for brevity
, plotOptions: {
@baramoss
baramoss / sampleJs007.js
Last active April 27, 2023 23:40
[JavaScript] ApexCharts.js - legend null인 것도 name 노출되도록 처리
<script type="text/javascript">
// code omitted for brevity
<c:forEach var="list" items="${applyStudentStateList}" varStatus="status">
var nmDataArry = [];
var perDataArry = [];
nmDataArry.push('${applyStdStateList.genFgNm}');
if ('${status.index}' == 1) {
@baramoss
baramoss / sampleJs006.js
Last active March 19, 2023 23:56
[JavaScript] ApexCharts.js - 천단위 콤마
<script type="text/javascript">
// code omitted for brevity
function drawStatChart() {
var options = {
chart : {
height : 250
, type : 'bar'
, stacked : true
@baramoss
baramoss / sampleJs005.js
Last active March 14, 2023 23:42
[JavaScript] ApexCharts.js - dataLabels에서 NaN 표시될 경우 처리
<script type="text/javascript">
// code omitted for brevity
var options = {
series : seriesData
, chart : {
type : 'bar'
, height : 150
, stacked : false
@baramoss
baramoss / sampleJs004.js
Last active March 8, 2023 00:19
[JavaScript] ApexCharts.js - xaxis labels 짤림 방지
// ApexCharts.js - xaxis labels가 길 경우 default로 45도 각도로 배치가 되는데, 너무 길면 labels의 뒷 부분이 '...' 으로 표시되며 짤림
// 아래와 같이 xaxis의 labels 옵션으로 trim 값을 false로 주면 labels 모두 표시됨
// 더 많은 옵션 확인은 https://apexcharts.com/docs/options/xaxis/
<script type="text/javascript">
function drawBarChart() {
var codeNameArray = [];
var codeCountArray = [];
<c:forEach items="${statisticsDataList}" var="list">
codeNameArray.push("${list.codeName}");
@baramoss
baramoss / sampleSql009.sql
Created March 7, 2023 00:52
[SQL / Oracle] 소수점 자릿수 고정
SELECT
NUMBER_DATA
, TO_CHAR(NVL(NUMBER_TABLE.NUMBER_DATA, 0), '90.00') AS FIXED_DECIMAL_POINT1
, TO_CHAR(NVL(NUMBER_TABLE.NUMBER_DATA, 0), '90.99') AS FIXED_DECIMAL_POINT2
, TO_CHAR(NVL(NUMBER_TABLE.NUMBER_DATA, 0), '99.00') AS FIXED_DECIMAL_POINT3
, TO_CHAR(NVL(NUMBER_TABLE.NUMBER_DATA, 0), 'FM900.00') AS FIXED_DECIMAL_POINT4
, TO_CHAR(NVL(NUMBER_TABLE.NUMBER_DATA, 0), '999,999,990.00') AS FIXED_DECIMAL_POINT5
, TO_CHAR(NVL(NUMBER_TABLE.NUMBER_DATA, 0), 'FM999,999,990.00') AS FIXED_DECIMAL_POINT6
, TO_CHAR(NVL(NUMBER_TABLE.NUMBER_DATA, 0), 'FM999,999,990.90') AS FIXED_DECIMAL_POINT7
, TO_CHAR(NVL(NUMBER_TABLE.NUMBER_DATA, 0), 'FM999,999,990.99') AS FIXED_DECIMAL_POINT8