summaryrefslogtreecommitdiff
path: root/components/form-data-plant/var-list-download-btn.tsx
diff options
context:
space:
mode:
Diffstat (limited to 'components/form-data-plant/var-list-download-btn.tsx')
-rw-r--r--components/form-data-plant/var-list-download-btn.tsx122
1 files changed, 122 insertions, 0 deletions
diff --git a/components/form-data-plant/var-list-download-btn.tsx b/components/form-data-plant/var-list-download-btn.tsx
new file mode 100644
index 00000000..9d09ab8c
--- /dev/null
+++ b/components/form-data-plant/var-list-download-btn.tsx
@@ -0,0 +1,122 @@
+"use client";
+
+import React, { FC } from "react";
+import Image from "next/image";
+import { useToast } from "@/hooks/use-toast";
+import { toast as toastMessage } from "sonner";
+import ExcelJS from "exceljs";
+import { saveAs } from "file-saver";
+import { Button } from "@/components/ui/button";
+import { DataTableColumnJSON } from "./form-data-table-columns";
+import { useParams } from "next/navigation";
+import { useTranslation } from "@/i18n/client";
+
+interface VarListDownloadBtnProps {
+ columnsJSON: DataTableColumnJSON[];
+ formCode: string;
+}
+
+export const VarListDownloadBtn: FC<VarListDownloadBtnProps> = ({
+ columnsJSON,
+ formCode,
+}) => {
+ const { toast } = useToast();
+
+ const params = useParams();
+ const lng = (params?.lng as string) || "ko";
+ const { t } = useTranslation(lng, "engineering");
+
+ const downloadReportVarList = async () => {
+ try {
+ // Create a new workbook
+ const workbook = new ExcelJS.Workbook();
+
+ // 데이터 시트 생성
+ const worksheet = workbook.addWorksheet("Data");
+
+ // 유효성 검사용 숨김 시트 생성
+ const validationSheet = workbook.addWorksheet("ValidationData");
+ validationSheet.state = "hidden"; // 시트 숨김 처리
+
+ // 1. 데이터 시트에 헤더 추가
+ const headers = [
+ t("varListDownload.headers.tableColumnLabel"),
+ t("varListDownload.headers.reportVariable")
+ ];
+ worksheet.addRow(headers);
+
+ // 헤더 스타일 적용
+ const headerRow = worksheet.getRow(1);
+ headerRow.font = { bold: true };
+ headerRow.alignment = { horizontal: "center" };
+ headerRow.eachCell((cell) => {
+ cell.fill = {
+ type: "pattern",
+ pattern: "solid",
+ fgColor: { argb: "FFCCCCCC" },
+ };
+ });
+
+ // 2. 데이터 행 추가
+ columnsJSON.forEach((row) => {
+ console.log(row);
+ const { displayLabel, key } = row;
+
+ // const labelConvert = label.replaceAll(" ", "_");
+
+ worksheet.addRow([displayLabel, key]);
+ });
+
+ // 3. 컬럼 너비 자동 조정
+ headers.forEach((col, idx) => {
+ const column = worksheet.getColumn(idx + 1);
+
+ // 최적 너비 계산
+ let maxLength = col.length;
+ columnsJSON.forEach((row) => {
+ const valueKey = idx === 0 ? "displayLabel" : "label";
+
+ const value = row[valueKey];
+ if (value !== undefined && value !== null) {
+ const valueLength = String(value).length;
+ if (valueLength > maxLength) {
+ maxLength = valueLength;
+ }
+ }
+ });
+
+ // 너비 설정 (최소 10, 최대 50)
+ column.width = Math.min(Math.max(maxLength + 2, 10), 50);
+ });
+
+ const buffer = await workbook.xlsx.writeBuffer();
+ const fileName = `${formCode}${t("varListDownload.fileNameSuffix")}`;
+ saveAs(new Blob([buffer]), fileName);
+ toastMessage.success(t("varListDownload.messages.downloadComplete"));
+ } catch (err) {
+ console.log(err);
+ toast({
+ title: t("varListDownload.messages.errorTitle"),
+ description: t("varListDownload.messages.errorDescription"),
+ variant: "destructive",
+ });
+ }
+ };
+
+ return (
+ <Button
+ variant="outline"
+ className="relative px-[8px] py-[6px] flex-1"
+ aria-label={t("varListDownload.buttonAriaLabel")}
+ onClick={downloadReportVarList}
+ >
+ <Image
+ src="/icons/var_list_icon.svg"
+ alt={t("varListDownload.iconAltText")}
+ width={16}
+ height={16}
+ />
+ <div className="text-[12px]">{t("varListDownload.buttonText")}</div>
+ </Button>
+ );
+}; \ No newline at end of file