CodePen Embed - 그리드 - TransposedMultiRow

Live

 
<div class="container-fluid">
  <label>레이아웃 옵션: <div id="ldComboBox"></div></label>
  <p id="mainDesc"></p>
  <label>Transposed MultiRow</label>
  <p id="trnDesc"></p>
  <div id="trnMultirow"></div>
  <div>
    <button id="btnExportToExcel" class="btn btn-default">
      엑셀로 내보내기
    </button>
    <button id="btnExportToPDF" class="btn btn-default">
      PDF로 내보내기
    </button>
  </div>
  <label>일반적인 MultiRow</label>
  <p id="ordDesc"></p>
  <div id="ordMultirow"></div>
</div>

Live

​x
 
.wj-transposed-multirow {
    height: 300px;
    margin: 6px 0;
}
​
.wj-multirow {
    height: 400px;
    margin: 6px 0;
}
​
​
@font-face {
     font-family: 'S-CoreDream-3Light';
     src: url('https://cdn.jsdelivr.net/gh/projectnoonnu/noonfonts_six@1.2/S-CoreDream-3Light.woff') format('woff');
     font-weight: normal;
     font-style: normal;
}
​
body {
  margin: 20px;
  font-family: 'S-CoreDream-3Light';
}
​
.wj-flexgrid .wj-header {
  background-color: #4FC3F7;
  color:white;
  font-weight:bold;
}
​
​
.wj-cells .wj-cell.wj-state-selected{
  background: #4DD0E1;
}

Live

xxxxxxxxxx
 
​
​
document.readyState === 'complete' ? init() : window.onload = init;
//
function init() {
  let appData = generateAppData();
  let orders = appData.orders;
  let layoutDefs = appData.layoutDefs;
  let currentLayout = appData.layoutDefs.currentItem;
  let trnMultirow = new wijmo.grid.transposedmultirow.TransposedMultiRow('#trnMultirow', {
    itemsSource: orders,
    layoutDefinition: currentLayout.def
  });
  let ordMultirow = new wijmo.grid.multirow.MultiRow('#ordMultirow', {
    itemsSource: orders,
    layoutDefinition: currentLayout.def
  });
  let ldComboBox = new wijmo.input.ComboBox('#ldComboBox', {
    itemsSource: layoutDefs,
    displayMemberPath: 'name'
  });
  //
  updateDescriptions();
  layoutDefs.currentChanged.addHandler(() => {
    currentLayout = appData.layoutDefs.currentItem;
    updateMultirow();
    updateDescriptions();
  });
  //
  document.getElementById('btnExportToExcel').addEventListener('click', function () {
    wijmo.grid.xlsx.FlexGridXlsxConverter.saveAsync(trnMultirow, {
      includeRowHeaders: true
    }, 'FlexGrid.xlsx');
  });
  //
  document.getElementById('btnExportToPDF').addEventListener('click', function () {
    wijmo.grid.pdf.FlexGridPdfConverter.export(trnMultirow, 'FlexGrid.pdf', {
      documentOptions: {
        pageSettings: {
          layout: wijmo.pdf.PdfPageOrientation.Landscape
        }
      },
      scaleMode: wijmo.grid.pdf.ScaleMode.ActualSize
    });
  });
  //
  function updateMultirow() {
    trnMultirow.layoutDefinition = currentLayout.def;
    ordMultirow.layoutDefinition = currentLayout.def;
  }
  //
  function updateDescriptions() {
    wijmo.setText(document.querySelector('#mainDesc'), currentLayout.descriptions.main);
    wijmo.setText(document.querySelector('#trnDesc'), currentLayout.descriptions.transposedView);
    wijmo.setText(document.querySelector('#ordDesc'), currentLayout.descriptions.ordinaryView);
  }
}
​
function generateAppData() {
  // create some data
  let appData = {}, customers = [], firstNames = 'Aaron,Paul,John,Mark,Sue,Tom,Bill,Joe,Tony,Brad,Frank,Chris,Pat'.split(','), lastNames = 'Smith,Johnson,Richards,Bannon,Wong,Peters,White,Brown,Adams,Jennings'.split(','), cities = 'York,Paris,Rome,Cairo,Florence,Sidney,Hamburg,Vancouver'.split(','), states = 'SP,RS,RN,SC,CS,RT,BC'.split(',');
  for (let i = 0; i < 50; i++) {
    let first = randArray(firstNames), last = randArray(lastNames);
    customers.push({
      id: i,
      name: first + ' ' + last,
      address: randBetween(100, 10000) + ' ' + randArray(lastNames) + ' St.',
      city: randArray(cities),
      state: randArray(states),
      zip: wijmo.format('{p1:d5}-{p2:d3}', {
        p1: randBetween(10000, 99999),
        p2: randBetween(100, 999)
      }),
      email: first + '.' + last + '@gmail.com',
      phone: wijmo.format('{p1:d3}-{p2:d4}', {
        p1: randBetween(100, 999),
        p2: randBetween(1000, 9999)
      })
    });
  }
  let cityMap = new wijmo.grid.DataMap(cities);
  let shippers = [
    { id: 0, name: 'Speedy Express', email: 'speedy@gmail.com', phone: '431-3234', express: true },
    { id: 1, name: 'Flash Delivery', email: 'flash@gmail.com', phone: '431-6563', express: true },
    { id: 2, name: 'Logitrax', email: 'logitrax@gmail.com', phone: '431-3981', express: false },
    { id: 3, name: 'Acme Inc', email: 'acme@gmail.com', phone: '431-3113', express: false }
  ];
  let orders = [];
  let today = new Date();
  for (let i = 0; i < 20; i++) {
    let shipped = wijmo.DateTime.addDays(today, -randBetween(1, 3000));
    orders.push({
      id: i,
      date: wijmo.DateTime.addDays(shipped, -randBetween(1, 5)),
      shippedDate: shipped,
      amount: randBetween(10000, 500000) / 100,
      customer: clone(randArray(customers)),
      shipper: clone(randArray(shippers))
    });
  }
  //
  function randBetween(min, max) {
    return Math.floor(Math.random() * (max - min + 1) + min);
  }
  //
  function randArray(arr) {
    return arr[randBetween(0, arr.length - 1)];
  }
  // shallow copy
  function clone(obj) {
    if (wijmo.isFunction(Object.assign)) { // IE does not support it
      return Object.assign({}, obj);
    }
    let clone = {};
    for (let prop in obj) {
      if (obj.hasOwnProperty(prop)) {
        clone[prop] = obj[prop];
      }
    }
    return clone;
  }
  // expose orders CollectionView to the app
  appData.orders = new wijmo.collections.CollectionView(orders);
  // expose grouped orders CollectionView to the app
  appData.groupedOrders = new wijmo.collections.CollectionView(orders, {
    groupDescriptions: [
      'customer.city'
    ]
  });
  // expose paged orders CollectionView to the app
  appData.pagedOrders = new wijmo.collections.CollectionView(orders, {
    pageSize: 4
  });
  // expose addNew oders CollectionView to the app
  appData.addNewOrders = new wijmo.collections.CollectionView(orders, {
    newItemCreator: function () {
      return {
        customer: {},
        shipper: {}
      };
    },
  });
  appData.addNewOrders.moveCurrentToLast();
  // refresh views when data source changes
  let ordersRefreshing = false;
  appData.orders.collectionChanged.addHandler(function () {
    ordersRefreshing = true;
    if (!pagedOrdersRefreshing) {
      appData.pagedOrders.refresh();
    }
    if (!groupedOrdersRefreshing) {
      appData.groupedOrders.refresh();
    }
    if (!addNewOrdersRefreshing) {
      appData.addNewOrders.refresh();
    }
    ordersRefreshing = false;
  });
  // addNew orders
  let addNewOrdersRefreshing = false;
  appData.addNewOrders.collectionChanged.addHandler(function () {
    addNewOrdersRefreshing = true;
    if (!ordersRefreshing) {
      appData.orders.refresh();
    }
    if (!pagedOrdersRefreshing) {
      appData.pagedOrders.refresh();
    }
    if (!groupedOrdersRefreshing) {
      appData.groupedOrders.refresh();
    }
    addNewOrdersRefreshing = false;
  });
  // grouped orders
  let groupedOrdersRefreshing = false;
  appData.groupedOrders.collectionChanged.addHandler(function () {
    groupedOrdersRefreshing = true;
    if (!ordersRefreshing) {
      appData.orders.refresh();
    }
    if (!pagedOrdersRefreshing) {
      appData.pagedOrders.refresh();
    }
    if (!addNewOrdersRefreshing) {
      appData.addNewOrders.refresh();
    }
    groupedOrdersRefreshing = false;
  });
  // paged orders
  let pagedOrdersRefreshing = false;
  appData.pagedOrders.collectionChanged.addHandler(function () {
    pagedOrdersRefreshing = true;
    if (!ordersRefreshing) {
      appData.orders.refresh();
    }
    if (!addNewOrdersRefreshing) {
      appData.addNewOrders.refresh();
    }
    if (!groupedOrdersRefreshing) {
      appData.groupedOrders.refresh();
    }
    pagedOrdersRefreshing = false;
  });
  // sample layout definitions
  appData.ldOneLine = [
    { cells: [{ binding: 'id', header: 'ID', cssClass: 'id', isReadOnly: true }] },
    { cells: [{ binding: 'date', header: 'Ordered' }] },
    { cells: [{ binding: 'shippedDate', header: 'Shipped' }] },
    { cells: [{ binding: 'amount', header: 'Amount', format: 'c', cssClass: 'amount' }] },
    { cells: [{ binding: 'customer.name', header: 'Customer' }] },
    { cells: [{ binding: 'customer.address', header: 'Address', wordWrap: true }] },
    { cells: [{ binding: 'customer.city', header: 'City', dataMap: cityMap }] },
    { cells: [{ binding: 'customer.state', header: 'State', width: 45 }] },
    { cells: [{ binding: 'customer.zip', header: 'Zip' }] },
    { cells: [{ binding: 'customer.email', header: 'Customer Email', cssClass: 'email' }] },
    { cells: [{ binding: 'customer.phone', header: 'Customer Phone' }] },
    { cells: [{ binding: 'shipper.name', header: 'Shipper' }] },
    { cells: [{ binding: 'shipper.email', header: 'Shipper Email', cssClass: 'email' }] },
    { cells: [{ binding: 'shipper.phone', header: 'Shipper Phone' }] },
    { cells: [{ binding: 'shipper.express', header: 'Express' }] }
  ];
  appData.ldThreeLines = [
    {
      header: 'Order', colspan: 3, cells: [
        { binding: 'id', header: 'ID', rowspan: 2, cssClass: 'id' },
        { binding: 'amount', header: 'Amount', format: 'c', rowspan: 2, cssClass: 'amount' },
        { binding: 'date', header: 'Ordered' },
        { binding: 'shippedDate', header: 'Shipped' }
      ]
    },
    {
      header: 'Customer', colspan: 3, cells: [
        { binding: 'customer.name', header: 'Name' },
        { binding: 'customer.address', header: 'Address', rowspan: 2 },
        { binding: 'customer.city', header: 'City', dataMap: cityMap },
        { binding: 'customer.email', header: 'EMail', rowspan: 2, cssClass: 'email' },
        { binding: 'customer.state', header: 'State', width: 45 },
        { binding: 'customer.phone', header: 'Phone' },
        { binding: 'customer.zip', header: 'Zip' },
      ]
    },
    {
      header: 'Shipper', colspan: 3, cells: [
        { binding: 'shipper.name', header: 'Shipper' },
        { binding: 'shipper.email', header: 'EMail', cssClass: 'email' },
        { binding: 'shipper.express', header: 'Express' }
      ]
    }
  ];
  appData.layoutDefs = new wijmo.collections.CollectionView([
    {
      name: 'Basic layout',
      descriptions: {
        main: '이 레이아웃은 주문, 고객 및 공급자의 세 그룹으로 나뉩니다. 각 그룹은 여러 속성으로 구성되며 세 개의 열에 걸쳐 있습니다.',
        transposedView: '이 보기에는 레코드당 세 개의 열이 사용되며 그룹당 행 수가 다릅니다.',
        ordinaryView: '이 뷰는 레코드 당 동일한 수의 행과 그룹 당 3개의 열이 사용됩니다.'
      },
      def: appData.ldThreeLines
    },
    {
      name: 'Grid layout',
      descriptions: {
        main: '이 레이아웃은 그리드 뷰와 같습니다. 각 그룹은 단일 속성으로 구성되며 한 열에 걸쳐 있습니다.',
        transposedView: '이 뷰는 열이 레코드를 나타내는 전치(transposed)된 그리드 뷰에 해당합니다.',
        ordinaryView: '이 뷰는 행을 레코드를 나타내는 기존 그리드 뷰에 해당합니다.'
      },
      def: appData.ldOneLine
    }
  ]);
  return appData;
}
​

This Pen is owned by Mescius Korea on CodePen.

See more by @MESCIUS-Korea on CodePen

External CSS

External JavaScript