Index: arms/html/reportFullData/content-container.html
===================================================================
diff -u -r69fc45b435b6a9f8e52c7663485099d9cc1a0c78 -r9f4b18a5a7e23fb277763ab0c44d61d97915921a
--- arms/html/reportFullData/content-container.html (.../content-container.html) (revision 69fc45b435b6a9f8e52c7663485099d9cc1a0c78)
+++ arms/html/reportFullData/content-container.html (.../content-container.html) (revision 9f4b18a5a7e23fb277763ab0c44d61d97915921a)
@@ -497,10 +497,48 @@
style="display: flex; flex-direction: row; color:#f8f8f8; flex:0 0 3%;
padding-bottom: 3px; align-items: center; margin-bottom: 0">
List View (Excel)
+
+
+
+
Index: arms/js/reportFullData.js
===================================================================
diff -u -r857e001448050d315d14280c83e5d1a9485f5f90 -r9f4b18a5a7e23fb277763ab0c44d61d97915921a
--- arms/js/reportFullData.js (.../reportFullData.js) (revision 857e001448050d315d14280c83e5d1a9485f5f90)
+++ arms/js/reportFullData.js (.../reportFullData.js) (revision 9f4b18a5a7e23fb277763ab0c44d61d97915921a)
@@ -604,29 +604,29 @@
/////////////////////////////////////////////////
function drawExcel(target, data) {
var columnList = [
- { readOnly: true, type: "text", name:"pdServiceName", title: "제품(서비스)", wRatio: 0.1 }, //0
- { readOnly: true, type: "text", name:"pdServiceVersionNames", title: "버전(일정)", wRatio: 0.1 }, //1 버전(시작일 ~ 종료일)
- { readOnly: true, type: "text", name:"almProjectName", title: "ALM Project", wRatio: 0.1 }, //2 ALM Project
- { readOnly: true, type: "text", name:"isReqName", title: "요구사항 구분", wRatio: 0.1 }, //3 요구사항 이슈, 연결이슈, 하위이슈
- { readOnly: true, type: "text", name:"reqTitle", title: "A-RMS 요구사항", wRatio: 0.1 }, //4 암스가 생성한 요구사항
- { readOnly: true, type: "text", name:"reqState", title: "A-RMS 요구사항 상태", wRatio: 0.1 }, //5 암스 요구사항 상태
- { readOnly: true, type: "text", name: "key", title: "ALM 이슈 키", wRatio: 0.1 }, //16
- { readOnly: true, type: "text", name:"issueTitle", title: "ALM 이슈 제목", wRatio: 0.2 }, //6
- { readOnly: true, type: "text", name:"issueStatus", title: "ALM 이슈 상태", wRatio: 0.1 }, //7
- { readOnly: true, type: "text", name:"assigneeName", title: "ALM 이슈 담당자", wRatio: 0.1 }, //8
- { readOnly: true, type: "calendar", name: "createDate", title: "ALM 이슈 생성일", wRatio: 0.1 }, //9
- { readOnly: true, type: "calendar", name: "updatedDate", title: "ALM 이슈 수정일", wRatio: 0.1 }, //10
- { readOnly: true, type: "calendar", name: "resolutionDate", title: "ALM 이슈 해결일", wRatio: 0.1 }, //11 해결된 날짜 또는 닫힌 날짜
- { readOnly: true, type: "hidden", name: "pdServiceVersions", title: "버전키", wRatio: 0.1 }, //12
- { readOnly: true, type: "hidden", name: "pdServiceId", title: "제품서비스키", wRatio: 0.1 }, //13
- { readOnly: true, type: "hidden", name: "assigneeEmail", title: "담당자메일", wRatio: 0.1 }, //14
- { readOnly: true, type: "hidden", name: "upperKey", title: "upperKey", wRatio: 0.1 }, //15
- { readOnly: true, type: "hidden", name: "issueID", title: "issueID", wRatio: 0.1 }, //17
- { readOnly: true, type: "hidden", name: "parentReqKey", title: "parentReqKey", wRatio: 0.1 }, //17
- { readOnly: true, type: "hidden", name: "etc", title: "etc", wRatio: 0.1 }, //17
- { readOnly: true, type: "hidden", name: "isReq", title: "isReq", wRatio: 0.1 }, //17
- { readOnly: true, type: "hidden", name: "creqLink", wRatio: 0.1 }, //18
- { readOnly: true, type: "hidden", name: "deletedDate", wRatio: 0.1 } //18
+ { readOnly: true, type: "text", name:"pdServiceName", title: "제품(서비스)", wRatio: 0.1 }, //0
+ { readOnly: true, type: "text", name:"pdServiceVersionNames", title: "버전(일정)", wRatio: 0.1 }, //1 버전(시작일 ~ 종료일)
+ { readOnly: true, type: "text", name:"almProjectName", title: "ALM Project", wRatio: 0.1 }, //2 ALM Project
+ { readOnly: true, type: "text", name:"isReqName", title: "요구사항 구분", wRatio: 0.1 }, //3 요구사항 이슈, 연결이슈, 하위이슈
+ { readOnly: true, type: "text", name:"reqTitle", title: "A-RMS 요구사항", wRatio: 0.1 }, //4 암스가 생성한 요구사항
+ { readOnly: true, type: "text", name:"reqState", title: "A-RMS 요구사항 상태", wRatio: 0.1 }, //5 암스 요구사항 상태
+ { readOnly: true, type: "text", name: "key", title: "ALM 이슈 키", wRatio: 0.1 }, //6 (필수)
+ { readOnly: true, type: "text", name:"issueTitle", title: "ALM 이슈 제목", wRatio: 0.2 }, //7
+ { readOnly: true, type: "text", name:"issueStatus", title: "ALM 이슈 상태", wRatio: 0.1 }, //8
+ { readOnly: true, type: "text", name:"assigneeName", title: "ALM 이슈 담당자", wRatio: 0.1 }, //9
+ { readOnly: true, type: "calendar", name: "createDate", title: "ALM 이슈 생성일", wRatio: 0.1 }, //10
+ { readOnly: true, type: "calendar", name: "updatedDate", title: "ALM 이슈 수정일", wRatio: 0.1 }, //11
+ { readOnly: true, type: "calendar", name: "resolutionDate", title: "ALM 이슈 해결일", wRatio: 0.1 }, //12 해결된 날짜 또는 닫힌 날짜
+ { readOnly: true, type: "hidden", name: "pdServiceVersions", title: "버전키", wRatio: 0.1 }, //13 (필수X)
+ { readOnly: true, type: "hidden", name: "pdServiceId", title: "제품서비스키", wRatio: 0.1 }, //14 (필수X)
+ { readOnly: true, type: "hidden", name: "assigneeEmail", title: "담당자메일", wRatio: 0.1 }, //15 (필수X)
+ { readOnly: true, type: "hidden", name: "upperKey", title: "upperKey", wRatio: 0.1 }, //16 (필수X)
+ { readOnly: true, type: "hidden", name: "issueID", title: "issueID", wRatio: 0.1 }, //17 (필수X)
+ { readOnly: true, type: "hidden", name: "parentReqKey", title: "parentReqKey", wRatio: 0.1 }, //18 (필수X)
+ { readOnly: true, type: "hidden", name: "etc", title: "etc", wRatio: 0.1 }, //19 (필수X)
+ { readOnly: true, type: "hidden", name: "isReq", title: "isReq", wRatio: 0.1 }, //20 (필수X)
+ { readOnly: true, type: "hidden", name: "creqLink", title: "cReqLink", wRatio: 0.1 }, //21 (필수X)
+ { readOnly: true, type: "hidden", name: "deletedDate", title: "deletedDate", wRatio: 0.1 } //22 (필수X)
];
@@ -807,4 +807,55 @@
startObserver, drawExcel
};
-})();
\ No newline at end of file
+})();
+
+///////////////////////////////////////////////////
+// 엑셀데이터 Export (JSON)
+/////////////////////////////////////////////////
+function jsonExport() {
+ let csvDataList = $(SpreadsheetFunctions.getTargetId("jq"))[0].jexcel.getData();
+
+ if (csvDataList.length === 0) {
+ console.log("[ reportFullData :: jsonExport ] :: excelData 가 없습니다.");
+ return false;
+ }
+
+ const jsonArray = csvDataList.map(row => {
+ const jsonObject = {};
+ SpreadsheetFunctions.getColumns().forEach((column,index) => {
+ jsonObject[column.title] = row[index];
+
+ });
+ return jsonObject;
+ });
+ //let jsonResult = [jsonArray];
+ let currentDate = date_YYMMDD();
+ let fileName = "fullData_" + currentDate;
+ downloadJSON(fileName, jsonArray);
+}
+
+function downloadJSON(filename, jsonObject) {
+ const jsonData = JSON.stringify(jsonObject, null, 2);
+ const blob = new Blob([jsonData], { type: 'application/json' });
+ const link = document.createElement('a');
+ link.href = URL.createObjectURL(blob);
+ link.download = filename;
+ link.click();
+ URL.revokeObjectURL(link.href);
+}
+///////////////////////////////////////////////////
+// 엑셀데이터 Export (CSV)
+/////////////////////////////////////////////////
+function csvExport() {
+ $(".jexcel_toolbar_item.material-icons.fa.fa-save").click();
+}
+
+let date_YYMMDD = function () {
+
+ let date = new Date();
+ let year = String(date.getFullYear()).slice(2);
+ let month = String(date.getMonth() + 1).padStart(2, '0');
+ let day = String(date.getDate()).padStart(2, '0');
+
+ return year + month + day;
+}
\ No newline at end of file