다중 섹션 판매 보고서

판매 보고서는 개별 영업사원 또는 제품군의 실적을 추적하고, 소비자 행동의 추세를 파악하고, 전반적인 수익 증가 또는 감소를 확인하는 데 유용합니다.

설명
app.js
index.html
styles.css
새 창에서 데모를 열어 디자이너 열기

디자이너를 여는 방법

다음 단계에 따라 '그룹' 및 '요약' 셀 유형을 사용하여 다중 섹션 판매 보고서를 생성할 수 있습니다.

  • DataManager에서 판매 표를 정의합니다.
  • 템플릿의 스타일을 설정합니다.
  • 데이터 열을 템플릿에 바인딩하고, '그룹' 셀 유형, ‘요약’ 셀 유형과 함께 '가로' 및 '세로' 분산 방향을 모두 사용합니다.
  • 일부 정적 셀을 고정합니다.
window.onload = async () => {
    const spread = new GC.Spread.Sheets.Workbook('demo-host', { sheetCount: 1 });
    await addSalesTable(spread).fetch();
    addMultiSectionsReport(spread);
}

function addSalesTable(spread) {
    const records = [
        ['East China', 'John', 'Fruits', 'Banana', 180],
        ['East China', 'Mike', 'Fruits', 'Banana', 200],
        ['East China', 'Emma', 'Fruits', 'Banana', 210],
        ['East China', 'Sophia', 'Fruits', 'Banana', 316],
        ['East China', 'Jennifer', 'Fruits', 'Banana', 130],
        ['North China', 'Kristen', 'Fruits', 'Banana', 410.0],
        ['North China', 'Mia', 'Fruits', 'Banana', 290.0],
        ['North China', 'Bella', 'Fruits', 'Banana', 342.0],
        ['North China', 'Eva', 'Fruits', 'Banana', 214.0],
        ['East China', 'John', 'Fruits', 'Strawberry', 230.0],
        ['East China', 'Mike', 'Fruits', 'Strawberry', 641.0],
        ['East China', 'Emma', 'Fruits', 'Strawberry', 234.0],
        ['East China', 'Sophia', 'Fruits', 'Strawberry', 625.0],
        ['East China', 'Jennifer', 'Fruits', 'Strawberry', 241.0],
        ['North China', 'Kristen', 'Fruits', 'Strawberry', 195.0],
        ['North China', 'Mia', 'Fruits', 'Strawberry', 569.0],
        ['North China', 'Bella', 'Fruits', 'Strawberry', 698.0],
        ['North China', 'Eva', 'Fruits', 'Strawberry', 214.0],
        ['East China', 'John', 'Fruits', 'Watermelon', 147.0],
        ['East China', 'Mike', 'Fruits', 'Watermelon', 489.0],
        ['East China', 'Emma', 'Fruits', 'Watermelon', 347.0],
        ['East China', 'Sophia', 'Fruits', 'Watermelon', 652.0],
        ['East China', 'Jennifer', 'Fruits', 'Watermelon', 471.0],
        ['North China', 'Kristen', 'Fruits', 'Watermelon', 287.0],
        ['North China', 'Mia', 'Fruits', 'Watermelon', 349.0],
        ['North China', 'Bella', 'Fruits', 'Watermelon', 163.0],
        ['North China', 'Eva', 'Fruits', 'Watermelon', 841.0],
        ['East China', 'John', 'Snack', 'Chips', 292.0],
        ['East China', 'Mike', 'Snack', 'Chips', 514.0],
        ['East China', 'Emma', 'Snack', 'Chips', 256.0],
        ['East China', 'Sophia', 'Snack', 'Chips', 148.0],
        ['East China', 'Jennifer', 'Snack', 'Chips', 486.0],
        ['North China', 'Kristen', 'Snack', 'Chips', 285.0],
        ['North China', 'Mia', 'Snack', 'Chips', 741.0],
        ['North China', 'Bella', 'Snack', 'Chips', 249.0],
        ['North China', 'Eva', 'Snack', 'Chips', 105.0],
        ['East China', 'John', 'Snack', 'Cookie', 554.0],
        ['East China', 'Mike', 'Snack', 'Cookie', 311.0],
        ['East China', 'Emma', 'Snack', 'Cookie', 186.0],
        ['East China', 'Sophia', 'Snack', 'Cookie', 654.0],
        ['East China', 'Jennifer', 'Snack', 'Cookie', 247.0],
        ['North China', 'Kristen', 'Snack', 'Cookie', 143.0],
        ['North China', 'Mia', 'Snack', 'Cookie', 617.0],
        ['North China', 'Bella', 'Snack', 'Cookie', 214.0],
        ['North China', 'Eva', 'Snack', 'Cookie', 324.0],
    ];
    const columns = ['Region', 'Salesman', 'ProductType', 'Product', 'Sales'];

    return spread.dataManager().addTable('Sales', {
        data: records.map((x) => {
            const record = {};
            columns.forEach((c, i) => record[c] = x[i]);
            return record;
        })
    });
}
function addMultiSectionsReport(spread) {
    const reportSheet = spread.addSheetTab(0, 'Multi Sections Sales Report', GC.Spread.Sheets.SheetType.reportSheet);
    const templateSheet = reportSheet.getTemplate();

    const { Style, HorizontalAlign, VerticalAlign, LineBorder } = GC.Spread.Sheets;
    templateSheet.options.gridline.showHorizontalGridline = false;
    templateSheet.options.gridline.showVerticalGridline = false;
    templateSheet.defaults.colWidth = 100;
    templateSheet.defaults.rowHeight = 30;
    templateSheet.setColumnWidth(0, 10);
    templateSheet.setRowHeight(0, 10);
    const headerStyle = new Style();
    headerStyle.backColor = '#BBDEFB';
    headerStyle.hAlign = HorizontalAlign.left;
    headerStyle.vAlign = VerticalAlign.center;
    headerStyle.textIndent = 1;
    headerStyle.foreColor = '#424242';
    headerStyle.font = '12px "Open Sans"';
    const dataStyle = new Style();
    dataStyle.hAlign = HorizontalAlign.left;
    dataStyle.vAlign = VerticalAlign.center;
    dataStyle.textIndent = 1;
    dataStyle.foreColor = '#424242';
    dataStyle.font = '12px "Open Sans"';
    const border = new LineBorder('#e0e0e0', 1);
    dataStyle.borderBottom = border;

    // section 1
    templateSheet.setValue(1, 1, 'Product Sales');
    templateSheet.setValue(2, 1, 'Salesman');
    templateSheet.getRange(2, 1, 1, 2).setStyle(headerStyle);
    templateSheet.getRange(3, 1, 1, 2).setStyle(dataStyle);
    templateSheet.getStyle(2, 2).hAlign = HorizontalAlign.right;
    templateSheet.getStyle(3, 2).hAlign = HorizontalAlign.right;
    templateSheet.setTemplateCell(3, 1, {
        type: 'Group',
        binding: 'Sales[Salesman]',
    });
    templateSheet.setTemplateCell(2, 2, {
        type: 'Group',
        binding: 'Sales[Product]',
        spillDirection: 'Horizontal',
    });
    templateSheet.setTemplateCell(3, 2, {
        type: 'Summary',
        binding: 'Sales[Sales]',
        aggregate: 'Sum',
    });

    // section 2
    templateSheet.setValue(5, 1, 'ProductType Sales');
    templateSheet.setValue(6, 1, 'Salesman');
    templateSheet.getRange(6, 1, 1, 2).setStyle(headerStyle);
    templateSheet.getRange(7, 1, 1, 2).setStyle(dataStyle);
    templateSheet.getStyle(6, 2).hAlign = HorizontalAlign.right;
    templateSheet.getStyle(7, 2).hAlign = HorizontalAlign.right;
    templateSheet.setTemplateCell(7, 1, {
        type: 'Group',
        binding: 'Sales[Salesman]',
    });
    templateSheet.setTemplateCell(6, 2, {
        type: 'Group',
        binding: 'Sales[ProductType]',
        spillDirection: 'Horizontal',
        context: {
            horizontal: 'None',
        }
    });
    templateSheet.setTemplateCell(7, 2, {
        type: 'Summary',
        binding: 'Sales[Sales]',
        aggregate: 'Sum',
    });

    // section 3
    templateSheet.setValue(9, 1, 'Salesman Sales');
    templateSheet.setValue(10, 1, 'Salesman');
    templateSheet.setValue(10, 2, 'Sales');
    templateSheet.getRange(10, 1, 1, 2).setStyle(headerStyle);
    templateSheet.getRange(11, 1, 1, 2).setStyle(dataStyle);
    templateSheet.getStyle(10, 2).hAlign = HorizontalAlign.right;
    templateSheet.getStyle(11, 2).hAlign = HorizontalAlign.right;
    templateSheet.setTemplateCell(11, 1, {
        type: 'Group',
        binding: 'Sales[Salesman]',
    });
    templateSheet.setTemplateCell(10, 2, {
        type: 'Static',
        pin: 'Both',
        context: {
            horizontal: 'None',
        }
    });
    templateSheet.setTemplateCell(11, 2, {
        type: 'Summary',
        binding: 'Sales[Sales]',
        aggregate: 'Sum',
    });

    reportSheet.refresh();
}
새 창에서 데모를 열어 디자이너 열기 다음 단계에 따라 '그룹' 및 '요약' 셀 유형을 사용하여 다중 섹션 판매 보고서를 생성할 수 있습니다. DataManager에서 판매 표를 정의합니다. 템플릿의 스타일을 설정합니다. 데이터 열을 템플릿에 바인딩하고, '그룹' 셀 유형, ‘요약’ 셀 유형과 함께 '가로' 및 '세로' 분산 방향을 모두 사용합니다. 일부 정적 셀을 고정합니다.
window.onload = async () => { const loadingTip = addLoadingTip(); const { spread, designer } = createSpreadAndDesigner(); const res = await fetch('$DEMOROOT$/ko/sample/features/report-sheet/showcase/cross-report/multi-sections-sales-report/spread.json'); await spread.fromJSON(await res.json()); loadingTip.remove(); if (designer) { designer.refresh(); } } function createSpreadAndDesigner() { const demoHost = document.getElementById('demo-host'); if (window !== top) { return { spread: new GC.Spread.Sheets.Workbook(demoHost, { sheetCount: 1 }), } } else { const designer = new GC.Spread.Sheets.Designer.Designer(demoHost, undefined, undefined, { sheetCount: 1 }); return { designer, spread: designer.getWorkbook(), } } } function addLoadingTip() { const div = document.createElement('div'); div.style.position = 'absolute'; div.style.inset = '0'; div.style.display = 'flex'; div.style.alignItems = 'center'; div.style.justifyContent = 'center'; div.style.background = 'white'; div.style.zIndex = '100'; div.textContent = 'Loading data from server ...'; document.body.appendChild(div); return div; }
<!doctype html> <html style="height:100%;font-size:14px;"> <head> <meta charset="utf-8" /> <meta name="spreadjs culture" content="ko-kr"/> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <link rel="stylesheet" type="text/css" href="$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets/styles/gc.spread.sheets.excel2013white.css"> <link rel="stylesheet" type="text/css" href="$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets-designer/styles/gc.spread.sheets.designer.min.css"> <link rel="stylesheet" type="text/css" href="styles.css"> <script src="$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets/dist/gc.spread.sheets.all.min.js" type="text/javascript"></script> <script src="$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets-print/dist/gc.spread.sheets.print.min.js" type="text/javascript"></script> <script src="$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets-shapes/dist/gc.spread.sheets.shapes.min.js" type="text/javascript"></script> <script src="$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets-charts/dist/gc.spread.sheets.charts.min.js" type="text/javascript"></script> <script src="$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets-reportsheet-addon/dist/gc.spread.report.reportsheet.min.js" type="text/javascript"></script> <script src="$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets-resources-ko/dist/gc.spread.sheets.resources.ko.min.js" type="text/javascript"></script> <script src="$DEMOROOT$/spread/source/js/license.js" type="text/javascript"></script> <script> const designerDependencyScripts = [ '$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets-barcode/dist/gc.spread.sheets.barcode.min.js', '$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets-pdf/dist/gc.spread.sheets.pdf.min.js', '$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets-pivot-addon/dist/gc.spread.pivot.pivottables.min.js', '$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets-slicers/dist/gc.spread.sheets.slicers.min.js', '$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets-tablesheet/dist/gc.spread.sheets.tablesheet.min.js', '$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets-ganttsheet/dist/gc.spread.sheets.ganttsheet.min.js', '$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets-formula-panel/dist/gc.spread.sheets.formulapanel.min.js', '$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets-io/dist/gc.spread.sheets.io.min.js', '$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-excelio/dist/gc.spread.excelio.min.js', '$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets-designer-resources-ko/dist/gc.spread.sheets.designer.resource.ko.min.js', '$DEMOROOT$/ko/purejs/node_modules/@mescius/spread-sheets-designer/dist/gc.spread.sheets.designer.all.min.js', '$DEMOROOT$/spread/source/js/designer/license.js', ] function appendScriptNode (src) { const script = document.createElement('script'); script.src = src; script.async = false; script.type = 'text/javascript'; document.head.appendChild(script); } if (top === window) { // not in iframe designerDependencyScripts.forEach(appendScriptNode); } </script> <script src="app.js" type="text/javascript"></script> </head> <body> <div class="sample-tutorial"> <div id="demo-host"></div> </div> </body> </html>
body { position: absolute; top: 0; bottom: 0; left: 0; right: 0; } .sample-tutorial { position: relative; height: 100%; overflow: hidden; } #demo-host { width: 100%; height: 100%; overflow: hidden; float: left; }