' + "인력정보를 조회 중 입니다..."
);
$.ajax({
url: "/auth-admin/api/arms/analysis/cost/version-req-assignees",
type: "POST",
contentType: "application/json;charset=UTF-8",
dataType: "json",
data: JSON.stringify({
pdServiceAndIsReq: {
pdServiceLink: pdServiceLink,
pdServiceVersionLinks: pdServiceVersionLinks.split(",").map(Number)
}
}),
progress: true,
statusCode: {
200: function (apiResponse) {
console.log(" [ analysisCost :: getHumanResourceInfo ] :: response data -> ");
console.log(apiResponse);
allAssignees = Object.fromEntries(
apiResponse.allAssignees.map(item => [item.id, item])
);
console.log("analysisCost :: getHumanResourceInfo.allAssignees => ", allAssignees);
costInput(allAssignees);
}
}
});
}
function formatDate(date) {
return new Date(date).toISOString().split("T")[0];
}
// 엑셀 파일 업로드
function file_upload_setting() {
// 업로드 영역 로드
$(".body-middle").html(`
`);
// Initialize the jQuery File Upload widget:
var $fileupload = $("#fileupload");
$fileupload.fileupload({
// Uncomment the following to send cross-domain cookies:
//xhrFields: {withCredentials: true},
autoUpload: true,
url: "/auth-admin/api/arms/salaries/excel-upload.do",
dropZone: $("#dropzone"),
limitMultiFileUploads: 1,
paramName: "excelFile",
// Callback for successful uploads:
fail: function (e, data) {
console.log("--------------------------");
console.log(data);
jError(data.jqXHR.responseJSON.error.message);
},
done: function (e, data) {
console.log("--------------------------");
console.log(data);
if (data.textStatus == "success") {
jNotify("업로드한 연봉 정보가 반영되었습니다.");
} else {
jError("데이터 반영 중 에러가 발생했습니다. 엑셀 파일을 확인해주세요");
}
getHumanResourceInfo(selectedPdServiceId, selectedVersionId);
manpowerInput(allAssignees); //데이터 테이블 재 로드
$("#cost-analysis-calculation").click(); // 비용 계산 버튼 클릭
}
});
}
// 버전 비용 및 인력 비용 입력
function costInput(allAssigneesMap) {
console.log(" [ analysisCost :: costInput ] :: 인력데이터 => " + JSON.stringify(allAssigneesMap));
file_upload_setting();
manpowerInput(allAssigneesMap);
}
function manpowerInput(allAssigneesMap) {
assigneeSalaryInfo = Object.keys(allAssigneesMap).map((key) => {
let data = {};
data.name = allAssigneesMap[key].name;
data.key = key;
data.salary = allAssigneesMap[key].salary;
return data;
});
console.log(" [ analysisCost :: manpowerInput ] :: assigneeSalaryInfo => " + JSON.stringify(assigneeSalaryInfo));
drawExcel("spreadsheet", assigneeSalaryInfo);
// 템플릿 다운로드
excel_download(assigneeSalaryInfo);
}
function excel_download(assigneeSalaryInfo) {
console.log(" [ analysisCost :: excel_download ] :: assigneeSalaryInfo => " + JSON.stringify(assigneeSalaryInfo));
let fileName = "인력별_연봉정보_템플릿.xlsx";
$("#excel-annual-income-template-download").click(function () {
if (Object.keys(assigneeSalaryInfo).length === 0) {
jError("다운로드할 인력 정보가 없습니다.");
} else {
$.ajax({
url: "/auth-admin/api/arms/salaries/excel-download.do?excelFileName=" + fileName,
type: "POST",
data: JSON.stringify(assigneeSalaryInfo),
contentType: "application/json",
xhrFields: {
responseType: "blob" // 응답 데이터 타입을 blob으로 설정
},
statusCode: {
200: function (data) {
var url = window.URL.createObjectURL(data); // blob 데이터로 URL 생성
var a = document.createElement("a"); // 다운로드 링크를 위한 ![](\"./img/loading.gif\")
비용분석계산 API 실행 중입니다..."
);
// checked ( Map`; } return acc; }, ""); const totalCount = params .reduce((acc, param) => acc + param.value, 0) .toString() .replace(/\B(?=(\d{3})+(?!\d))/g, ",") + "만 원"; const versionName = params[0].name; const totalTooltip = `[${versionName}] - Total: ${totalCount}
`; return totalTooltip + tooltip; } }, legend: { type: "scroll", orient: "horizontal", scrollDataIndex: 0, pageIconColor: "#2477ff", // 활성화된 페이지 버튼의 아이콘 색상 pageIconInactiveColor: "#aaa", // 비활성화된 페이지 버튼의 아이콘 색상 pageTextStyle: { color: "#fff" }, pageButtonPosition: "end", left: "center", data: stackTypeList, textStyle: { color: "white", fontSize: 11 }, formatter: function (value) { // 최대 10자까지 표시 if (value.length > 15) { return value.substring(0, 15) + "..."; } else { return value; } }, tooltip: { show: true // tooltip 활성화 } }, grid: { left: "5%", right: "0%", bottom: "0%", containLabel: true }, xAxis: { type: "value", axisLabel: { textStyle: { color: "white", fontWeight: "", fontSize: "11" }, rotate: 45 }, splitLine: { lineStyle: { type: "dashed", color: "white", width: 0.2, opacity: 0.5 } } }, yAxis: { type: "category", data: Object.keys(stackVersionList), axisLabel: { textStyle: { color: "white", fontWeight: "", fontSize: "11" } } }, series: stackTypeList.map((stackTypeData) => { const data = Object.values(stackVersionList).map( (stackVersionData) => stackVersionData[stackTypeData] || defaultValue ); return { name: stackTypeData, type: "bar", stack: "total", label: { show: false }, emphasis: { focus: "series" }, data: data }; }), dataZoom: [ { type: "inside", yAxisIndex: [0], // y축에만 dataZoom 기능 적용 start: 100 - zoomPersent, end: 100 }, { show: true, type: "slider", left: "0%", backgroundColor: "rgba(0,0,0,0)", // 슬라이더의 배경색 dataBackgroundColor: "rgba(255,255,255,1)", // 데이터 배경색 yAxisIndex: [0], start: 100 - zoomPersent, end: 100 } ] }; option && myChart.setOption(option); window.addEventListener("resize", function () { myChart.resize(); }); } function performanceToSalaryByPersonnelChart(allAssignees) { console.log(" [ analysisCost :: performanceToSalaryByPersonnelChart :: data -> "); console.log(allAssignees); let userData = []; let salaryData = []; let performanceData = []; let performanceDataByHours = []; allAssignees.forEach((element) => { let nameWithMail = element.assigneeName; if (element.emailAddress) { nameWithMail = nameWithMail + "(" + element.emailAddress + ")"; } userData.push(nameWithMail); salaryData.push(element.salary); performanceData.push(element.estimatedCostForDaysPeriod); performanceDataByHours.push(element.estimatedCostForHoursPeriod); }); let size = userData.length; let zoomPersent = 1; if (size > 0) { zoomPersent = (5 / size) * 100; } const fullScreenIconPath = "M18.25 10V5.75H14M18.25 14v4.25H14m-4 0H5.75V14m0-4V5.75H10"; var dom = document.getElementById("manpower-analysis-chart"); var myChart = echarts.init(dom, null, { renderer: "canvas", useDirtyRect: false }); var option; option = { grid: { top: "5%", left: "15%", bottom: "15%" }, tooltip: { trigger: "axis", axisPointer: { type: "none" }, confine: true }, xAxis: { data: userData, axisTick: { show: false }, axisLine: { show: false }, axisLabel: { color: "#FFFFFFFF", opacity: 1, fontSize: 11, formatter: function (value) { // 최대 10자까지 표시 if (value.length > 10) { return value.substring(0, 10) + "..."; } else { return value; } } }, scale: true }, yAxis: { splitLine: { show: false }, axisTick: { show: true }, axisLine: { show: false }, axisLabel: { show: true, color: "#FFFFFFFF", opacity: 1, rotate: 45 } }, /*color: ['#e54035'],*/ series: [ { name: "연봉", type: "pictorialBar", barCategoryGap: "0%", // symbol: 'path://M0,10 L10,10 L5,0 L0,10 z', symbol: "path://M0,10 C10,10 10,0 20,0 C30,0 30,10 40,10", itemStyle: { opacity: 0.5 }, emphasis: { itemStyle: { opacity: 0.7 } }, data: salaryData, z: 10, label: { show: false } }, { name: "성과", type: "pictorialBar", barCategoryGap: "0%", // symbol: 'path://M0,10 L10,10 L5,0 L0,10 z', symbol: "path://M0,10 C10,10 10,0 20,0 C30,0 30,10 40,10", itemStyle: { opacity: 0.5 /*color: "blue"*/ }, emphasis: { itemStyle: { opacity: 0.7 } }, data: performanceData, z: 10, label: { show: false, position: "outside", color: "#FFFFFFFF" } }, { show: false, name: "연봉 라벨", type: "pictorialBar", barCategoryGap: "0%", symbol: "path://M0,0", // 심볼을 비워서 별도의 바가 보이지 않도록 합니다. data: salaryData, z: 11, // z 값을 더 크게 설정하여 라벨이 다른 요소들 위에 오도록 합니다. label: { show: true, position: "outside", color: "white", formatter: function (params) { return params.value.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ","); } }, tooltip: { show: false } }, { show: false, name: "성과 라벨", type: "pictorialBar", barCategoryGap: "0%", symbol: "path://M0,0", // 심볼을 비워서 별도의 바가 보이지 않도록 합니다. data: performanceData, z: 11, // z 값을 더 크게 설정하여 라벨이 다른 요소들 위에 오도록 합니다. label: { show: true, position: "outside", color: "white", formatter: function (params) { return params.value.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ","); } }, tooltip: { show: false } } ], toolbox: { show: true, orient: "vertical", left: "right", bottom: "50px", feature: { dataZoom: { show: true }, myTool1: { show: false, title: "Full screen", icon: `path://${fullScreenIconPath}`, onclick: function () { $("#my_modal2").modal("show"); $("#my_modal2_title").text("인력별 성과 분석"); $("#my_modal2_description").text("인력별 연봉 대비 성과를 한눈에 확인할 수 있습니다."); let heights = screen.height; // window.innerHeight; console.log(heights); $("#my_modal2_body").height(heights - 450 + "px"); $("#my_modal2_body").append(``); setTimeout(function () { myChart.resize(); }, 500); } } }, iconStyle: { borderColor: "white" } }, dataZoom: [ { type: "inside", xAxisIndex: [0], start: 0, end: zoomPersent }, { show: true, type: "slider", bottom: "3%", backgroundColor: "rgba(0,0,0,0)", dataBackgroundColor: "rgba(255,255,255,1)", xAxisIndex: [0], start: 0, end: zoomPersent } ] }; if (option && typeof option === "object") { myChart.setOption(option); } window.addEventListener("resize", myChart.resize); } ///////////////////////////////////////////////// // 엑셀 저장 버튼 ///////////////////////////////////////////////// function costExcelUpdateButtonClick() { $("#cost-excel-batch-update").on("click", function () { if (Object.keys(modifiedRows).length === 0) { jError("수정된 연봉 데이터가 없습니다."); return; } var data = $("#spreadsheet").jexcel("getData"); var isValid = data.every(function (row) { if (!row[0] || !row[1] || !row[2]) { return true; } return !isNaN(row[2]) && row[2] !== ""; }); if (!isValid) { jError("연봉 데이터는 숫자만 입력해야하며, 값이 존재해야 합니다."); } else { $(".spinner").html( "
연봉 데이터 업데이트 중입니다..."
);
$.ajax({
url: "/auth-admin/api/arms/salaries",
type: "PUT",
data: JSON.stringify(modifiedRows),
contentType: "application/json",
statusCode: {
200: function (apiResponse) {
var response = apiResponse.response;
getHumanResourceInfo(selectedPdServiceId, selectedVersionId);
modifiedRows = {};
jSuccess("연봉 정보가 수정되었습니다.");
}
}
});
}
});
}
/////////////////////////////////////////////////
// 엑셀 그리기
/////////////////////////////////////////////////
function drawExcel(target, data) {
var columnList = [
{ type: "text", title: "이름", wRatio: 0.25, readOnly: true },
{ type: "text", title: "키", wRatio: 0.25, readOnly: true },
{ type: "text", title: "연봉", wRatio: 0.5 }
];
var customOption = {
search: true,
allowInsertRow: false,
allowInsertColumn: false,
onchange: function (instance, cell, x, y, value) {
var key = instance.jexcel.getValueFromCoords(1, y); // key값
if (!modifiedRows[key]) {
modifiedRows[key] = {};
}
modifiedRows[key].name = instance.jexcel.getValueFromCoords(0, y);
modifiedRows[key].key = instance.jexcel.getValueFromCoords(1, y);
modifiedRows[key].salary = value;
var changedRowData = SpreadsheetFunctions.getDataAtIndex(y);
changedRowData.salary = value;
SpreadsheetFunctions.updateDataAtIndex(y, changedRowData);
},
updateTable: function (instance, cell, col, row, val, id) {
cell.style.textAlign = "left";
cell.style.whiteSpace = "normal";
},
oneditionstart: function () {
SpreadsheetFunctions.isEditingCell = true;
SpreadsheetFunctions.stopObserver();
},
oneditionend: function () {
SpreadsheetFunctions.isEditingCell = false;
SpreadsheetFunctions.startObserver();
}
};
SpreadsheetFunctions.setTargetId(target);
SpreadsheetFunctions.setDefaultTargetRect();
SpreadsheetFunctions.setColumns(columnList);
SpreadsheetFunctions.setColumnWidth(SpreadsheetFunctions.getTargetRect("width"));
SpreadsheetFunctions.setOptions(customOption);
SpreadsheetFunctions.startObserver();
SpreadsheetFunctions.setExcelData(data);
SpreadsheetFunctions.drawExcel(SpreadsheetFunctions.getTargetId());
}
var SpreadsheetFunctions = (function () {
let targetId = { v: "", jq: "" };
let targetRect = { width: 0, height: 0 };
let excelData; // 엑셀 데이터
let excelColumns; // 엑셀 컬럼
let customOptions; // 엑셀 커스텀 옵션들 :: 정의 안할 경우 default
let isEditingCell = false;
var setDefaultTargetRect = function () {
let defaultWidth = $(getTargetId("jq")).width();
let defaultHeight = $(getTargetId("jq")).height();
setTargetRect(defaultWidth, defaultHeight);
};
var setTargetRect = function (width, height) {
targetRect.width = width;
targetRect.height = height;
};
var getTargetRect = function (type) {
if (type === "width") {
return targetRect.width;
} else if (type === "height") {
return targetRect.height;
} else {
return targetRect;
}
};
var setTargetId = function (target) {
targetId.v = target;
targetId.jq = "#" + target;
};
var getTargetId = function (type) {
if (type === "jq") {
return targetId.jq;
} else {
return targetId.v;
}
};
var setExcelData = function (data) {
excelData = data;
};
var getExcelData = function () {
return excelData;
};
var updateDataAtIndex = function (index, changedData) {
if (excelData) {
excelData[index] = changedData;
} else {
console.log("updateDataAtIndex :: excelData 가 없습니다.");
return false;
}
};
var getDataAtIndex = function (index) {
if (excelData) {
return excelData[index];
} else {
console.log("getDataAtIndex :: excelData 가 없습니다.");
return false;
}
};
var setColumns = function (columns) {
excelColumns = columns;
};
var getColumns = function () {
return excelColumns;
};
var setColumnWidth = function (width) {
if (excelColumns) {
excelColumns = excelColumns.map((column) => ({
...column,
width: width * column.wRatio - 1
}));
}
};
function setColumnWidthAsync(width) {
return new Promise((resolve) => {
if (excelColumns) {
excelColumns = excelColumns.map((column) => ({
...column,
width: width * column.wRatio - 1
}));
}
resolve(); // 컬럼 너비 설정이 완료된 후 resolve 호출
});
}
var setOptions = function (options) {
customOptions = options;
};
var getOptions = function () {
return customOptions ? customOptions : null;
};
var resizeObserver = new ResizeObserver(function (entries) {
if (isEditingCell) {
// 수정중에는 resize 비활성화
return;
}
for (let entry of entries) {
setTargetRect(entry.contentRect.width, entry.contentRect.height);
handleResize(entry.target.id, getTargetRect("width"), getTargetRect("height"));
}
});
// 모달요소 크기 변화 관찰(Observer)
function startObserver() {
resizeObserver.observe($(getTargetId("jq"))[0]);
}
// Observer 멈추기
function stopObserver() {
console.log("Stopping ResizeObserver");
resizeObserver.disconnect(); // 크기 변화를 더 이상 감지하지 않음
}
function handleResize(id, width, height) {
if (id === getTargetId() && height !== 0) {
if (excelData) {
drawResizedExcel(getTargetId());
} else {
console.log("Spreadsheet.handleResize :: 엑셀 데이터 없음");
}
} else {
console.log("Spreadsheet.handleResize :: id 불일치 또는 height 가 0 입니다.");
}
}
function drawResizedExcel(target) {
let $targetId = "#" + target;
if ($($targetId).length > 0 && $($targetId)[0].jexcel) {
$($targetId)[0].jexcel.destroy();
}
setColumnWidthAsync(getTargetRect("width") - 50).then(() => {
$($targetId).spreadsheet(
$.extend(
{},
{
columns: getColumns(),
data: getExcelData()
},
getOptions()
)
);
let jexcel_content_height = getTargetRect("height");
$($targetId + " .jexcel_content").css("max-height", jexcel_content_height);
$($targetId + " .jexcel_content").css("width", "100%");
});
}
function drawExcel(target) {
let $targetId = "#" + target;
if ($($targetId).length > 0 && $($targetId)[0].jexcel) {
$($targetId)[0].jexcel.destroy();
}
$($targetId).spreadsheet(
$.extend(
{},
{
columns: getColumns(),
data: getExcelData()
},
getOptions()
)
);
let jexcel_content_height = getTargetRect("height");
$($targetId + " .jexcel_content").css("max-height", jexcel_content_height);
$($targetId + " .jexcel_content").css("width", "100%");
}
return {
setTargetId,
getTargetId,
setTargetRect,
getTargetRect,
setDefaultTargetRect,
setExcelData,
getExcelData,
updateDataAtIndex,
getDataAtIndex,
setColumns,
getColumns,
setColumnWidth,
setOptions,
getOptions,
startObserver,
stopObserver,
drawExcel
};
})();
function fullScreenValidate() {
if (!selectedPdServiceId || !selectedVersionId) {
jError("제품(서비스), 버전을 선택해주세요.");
return false;
} else if (!costAnalysisState) {
$("#cost-analysis-calculation").click();
} else {
return true;
}
}