Skip to content

Instantly share code, notes, and snippets.

@ielcoro

ielcoro/app.html

Created June 14, 2017 13:23
Show Gist options
  • Save ielcoro/4f8c9384c825ec7f564b29bc9e131931 to your computer and use it in GitHub Desktop.
Save ielcoro/4f8c9384c825ec7f564b29bc9e131931 to your computer and use it in GitHub Desktop.
Download ZIP
Spreadsheet : default-functionalities
Raw
app.html
<template>
<require from="./spreadsheet.css"></require>
<div class ="e-main-panel">
<ej-spreadsheet id="Spreadsheet1" e-scroll-settings.bind = "scroll" e-import-settings.bind = "import"
e-export-settings.bind = "export" e-enable-pivot-table = "true" e-on-load-complete.trigger = "loadcomplete($event)"
e-on-open-failure.trigger = "openfailure($event)">
<ej-sheet e-range-settings.bind = "range">
</ej-sheet>
</ej-spreadsheet>
</div>
</template>
Raw
app.js
import './xljsondata.js';
export class DefaultFunctionalities {
constructor() {
this.scroll = { height: '100%', width: '100%', isResponsive: 'true' };
this.range = [{ dataSource: window.defaultData, startCell: 'A1', showHeader: 'true' }];
}
loadcomplete(event) {
let xlObj = $('#Spreadsheet1').ejSpreadsheet('instance');
let xlFormat = xlObj.XLFormat;
if (!xlObj.isImport) {
xlObj.setWidthToColumns([140, 128, 105, 100, 100, 110, 120, 120, 100]);
xlFormat.format({ 'style': { 'font-weight': 'bold' } }, 'A1:H1');
xlFormat.format({ 'type': 'currency' }, 'E2:H11');
xlObj.XLRibbon.updateRibbonIcons();
}
}
openfailure(args) {
let xlObj = $('#Spreadsheet1').data('ejSpreadsheet');
let alertDlg = $('#' + xlObj._id + '_alertdlg');
xlObj._renderAlertDlgContent(alertDlg, 'Alert', args.detail.statusText);
alertDlg.ejDialog('open');
}
}
Raw
index.html
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="Essential Studio for JavaScript">
<meta name="author" content="Syncfusion">
<title>Untitled</title>
<!-- Essential Studio for JavaScript theme reference -->
<link rel="stylesheet" href="https://cdn.syncfusion.com/14.2.0.28/js/web/flat-azure/ej.web.all.min.css" />
</head>
<body aurelia-app="main">
<h1>Loading...</h1>
<script src="https://cdnjs.cloudflare.com/ajax/libs/systemjs/0.19.6/system.js"></script>
<script src="https://rawgit.com/aurelia-ui-toolkits/aurelia-syncfusion-bundles/0.0.1/config2.js"></script>
<script>
System.import('aurelia-bootstrapper');
</script>
</body>
</html>
Raw
main.js
export function configure(aurelia) {
aurelia.use
.standardConfiguration()
.developmentLogging()
.plugin('aurelia-syncfusion-bridge', syncfusion => syncfusion.useAll());
aurelia.start().then(a => a.setRoot());
}
Raw
spreadsheet.css
.e-main-panel {
height: 90vh;
}
.page-host {
overflow-y: hidden;
}
Raw
xljsondata.js
window.conditionalData = [
{ 'Item Name': 'Text contains with Loafers', Date: 'Loafers', Quantity: '', Price: 'Date occur with 02/04/2014', Amount: '05/03/2013', Discount: '', Netamount: 'Less than 30', Value: '5'},
{ 'Item Name': '', Date: 'Casual Shoes', Quantity: '', Price: '', Amount: '06/23/2014', Discount: '', Netamount: '', Value: '56' },
{ 'Item Name': '', Date: 'Loafers', Quantity: '', Price: '', Amount: '07/22/2014', Discount: '', Netamount: '', Value: '24' },
{ 'Item Name': '', Date: 'Formal Shoes', Quantity: '', Price: '', Amount: '02/04/2014', Discount: '', Netamount: '', Value: '12'},
{ 'Item Name': '', Date: 'Sandals & Floaters', Quantity: '', Price: '', Amount: '11/30/2014', Discount: '', Netamount: '', Value: '36' },
{ 'Item Name': '', Date: '', Quantity: '', Price: '', Amount: '', Discount: '', Netamount: '', Value: '', Value1: '', Tax: '', Tax1: '' },
{ 'Item Name': 'Between 400 to 500', Date: '273', Quantity: '', Price: 'Greater than 5000', Amount: '5003', Discount: '', Netamount: 'Equal to 20', Value: '21'},
{ 'Item Name': '', Date: '345', Quantity: '', Price: '', Amount: '3434', Discount: '', Netamount: '', Value: '34', Value1: '' },
{ 'Item Name': '', Date: '494', Quantity: '', Price: '', Amount: '7553', Discount: '', Netamount: '', Value: '20', Value1: '' },
{ 'Item Name': '', Date: '506', Quantity: '', Price: '', Amount: '2364', Discount: '', Netamount: '', Value: '20', Value1: '' },
{ 'Item Name': '', Date: '453', Quantity: '', Price: '', Amount: '6788', Discount: '', Netamount: '', Value: '23', Value1: ''}
];
window.validationData = [
{ ID: 'Greater than 6', Type: '', TypeOfVisa: 'Text Length Less than 35', Value: '', VisaFees: 'Between 150 to 200', FNo: '', NoOfPassenger: 'List', DDate: '', Date: 'Greater than 07/09/2014', DTime: '', Time: 'Greater than 11:23:23 AM' },
{ ID: 1, Type: '', TypeOfVisa: 'Business', Value: '', VisaFees: '$160.00', FNo: '', NoOfPassenger: '1', DDate: '', Date: '02/14/2014', DTime: '', Time: '11:34:32 AM' },
{ ID: 2, Type: '', TypeOfVisa: 'Religious Worker', Value: '', VisaFees: '$190.00', FNo: '', NoOfPassenger: '2', DDate: '', Date: '06/11/2014', DTime: '', Time: '05:56:32 AM' },
{ ID: 3, Type: '', TypeOfVisa: 'Temporary Workers/Employment or Trainees', Value: '', VisaFees: '$190.00', FNo: '', NoOfPassenger: '3', DDate: '', Date: '03/04/2012', DTime: '', Time: '07:16:22 AM' },
{ ID: 4, Type: '', TypeOfVisa: 'Transiting the United States', Value: '', VisaFees: '$160.00', FNo: '', NoOfPassenger: '4', DDate: '', Date: '07/27/2014', DTime: '', Time: '03:32:44 AM' },
{ ID: 5, Type: '', TypeOfVisa: 'Student, Academic', Value: '', VisaFees: '$160.00', FNo: '', NoOfPassenger: '5', DDate: '', Date: '11/21/2014', DTime: '', Time: '06:23:54 AM' },
{ ID: 6, Type: '', TypeOfVisa: 'Orphan (Intercountry Adoption)', Value: '', VisaFees: '$720.00', FNo: '', NoOfPassenger: '6', DDate: '', Date: '06/23/2014', DTime: '', Time: '11:22:59 AM' },
{ ID: 7, Type: '', TypeOfVisa: 'Exchange Visitors', Value: '', VisaFees: '$160.00', FNo: '', NoOfPassenger: '7', DDate: '', Date: '07/22/2014', DTime: '', Time: '10:55:53 AM' },
{ ID: 8, Type: '', TypeOfVisa: 'DV category Immigrant Visa', Value: '', VisaFees: '$360.00', FNo: '', NoOfPassenger: '8', DDate: '', Date: '07/22/2014', DTime: '', Time: '10:55:53 AM' },
{ ID: 9, Type: '', TypeOfVisa: 'Victims of Criminal Activity', Value: '', VisaFees: '$160.00', FNo: '', NoOfPassenger: '8', DDate: '', Date: '02/04/2014', DTime: '', Time: '03:44:34 AM' },
{ ID: 10, Type: '', TypeOfVisa: 'NAFTA Professionals', Value: '', VisaFees: '$160.00', FNo: '', NoOfPassenger: '9', DDate: '', Date: '11/30/2014', DTime: '', Time: '03:12:52 AM' },
{ ID: 11, Type: '', TypeOfVisa: 'Employment-Based Applications', Value: '', VisaFees: '$345.00', FNo: '', NoOfPassenger: '10', DDate: '', Date: '07/09/2014', DTime: '', Time: '11:32:14 AM' },
{ ID: 12, Type: '', TypeOfVisa: 'Intracompany Transferees', Value:'',VisaFees: '$190.00', FNo:'',NoOfPassenger: '11',DDate:'',Date: '10/31/2014', DTime:'', Time: '11:01:44 AM' },
{ ID: 13, Type: '', TypeOfVisa: 'Person with Extraordinary Ability', Value: '', VisaFees: '$190.00', FNo: '', NoOfPassenger: '12', DDate: '', Date: '07/22/2014', DTime: '', Time: '10:55:53 AM' },
{ ID: 14, Type: '', TypeOfVisa: 'Tourism', Value: '', VisaFees: '$160.00', FNo: '', NoOfPassenger: '13', DDate: '', Date: '10/31/2014', DTime: '', Time: '11:01:44 AM' }
];
window.defaultData = [
{ 'Item Name': 'Casual Shoes', Date: '02/14/2014', Time: '11:34:32 AM', Quantity: 10, Price: '20', Amount: '200', Discount: '1', Profit: '10' },
{ 'Item Name': 'Sports Shoes', Date: '06/11/2014', Time: '05:56:32 AM', Quantity: 20, Price: '30', Amount: '600', Discount: '5', Profit: '50' },
{ 'Item Name': 'Formal Shoes', Date: '07/27/2014', Time: '03:32:44 AM', Quantity: 20, Price: '15', Amount: '300', Discount: '7', Profit: '27' },
{ 'Item Name': 'Sandals & Floaters', Date: '11/21/2014', Time: '06:23:54 AM', Quantity: 15, Price: '20', Amount: '300', Discount: '11', Profit: '67' },
{ 'Item Name': 'Flip- Flops & Slippers', Date: '06/23/2014', Time: '12:43:59 AM', Quantity: 30, Price: '10', Amount: '300', Discount: '10', Profit: '70' },
{ 'Item Name': 'Sneakers', Date: '07/22/2014', Time: '10:55:53 AM', Quantity: 40, Price: '20', Amount: '800', Discount: '13', Profit: '66' },
{ 'Item Name': 'Running Shoes', Date: '02/04/2014', Time: '03:44:34 AM', Quantity: 20, Price: '10', Amount: '200', Discount: '3', Profit: '14' },
{ 'Item Name': 'Loafers', Date: '11/30/2014', Time: '03:12:52 AM', Quantity: 31, Price: '10', Amount: '310', Discount: '6', Profit: '29' },
{ 'Item Name': 'Cricket Shoes', Date: '07/09/2014', Time: '11:32:14 AM', Quantity: 41, Price: '30', Amount: '1210', Discount: '12', Profit: '166' },
{ 'Item Name': 'T-Shirts', Date: '10/31/2014', Time: '12:01:44 AM', Quantity: 50, Price: '10', Amount: '500', Discount: '9', Profit: '55' }
];
window.freezeData = [
{'Supplier ID': 1, 'Company Name': 'Exotic Liquids','Contact Name':'Charlotte Cooper','Contact Title':'Purchasing Manager','City':'London','Postal Code':'EC1 4SD','Country':'UK'},
{'Supplier ID': 2, 'Company Name': 'New Orleans Cajun Delights','Contact Name':'Shelley Burke','Contact Title':'Order Administrator','City':'New Orleans','Postal Code':'70117','Country':'USA'},
{'Supplier ID': 3, 'Company Name': "Grandma Kelly's Homestead",'Contact Name':'Regina Murphy','Contact Title':'Sales Representative','City':'Ann Arbor','Postal Code':'48104','Country':'USA'},
{'Supplier ID': 4, 'Company Name': 'Tokyo Traders','Contact Name':'Yoshi Nagase','Contact Title':'Marketing Manager','City':'Tokyo','Postal Code':'100','Country':'Japan'},
{'Supplier ID': 5, 'Company Name': "Cooperativa de Quesos 'Las Cabras'",'Contact Name':'Antonio del Valle Saavedra','Contact Title':'Export Administrator','City':'Oviedo','Postal Code':'33007','Country':'Spain'},
{'Supplier ID': 6, 'Company Name':"Mayumi's",'Contact Name':'Mayumi Ohno','Contact Title':'Marketing Representative','City':'Osaka','Postal Code':'545','Country':'Japan'},
{'Supplier ID': 7, 'Company Name':'Pavlova, Ltd.','Contact Name':'Ian Devling','Contact Title':'Marketing Manager','City':'Melbourne','Postal Code':'3058','Country':'Australia'},
{'Supplier ID': 8, 'Company Name':'Specialty Biscuits, Ltd.','Contact Name':'Peter Wilson','Contact Title':'Sales Representative','City':'Manchester','Postal Code':'M14 GSD','Country':'UK'},
{'Supplier ID': 9, 'Company Name':'PB Knackebrod AB','Contact Name':'Lars Peterson','Contact Title':'Sales Agent','City':'Goteborg','Postal Code':'S-345 67','Country':'Sweden'},
{'Supplier ID': 10, 'Company Name':'Refrescos Americanas LTDA','Contact Name':'Carlos Diaz','Contact Title':'Marketing Manager','City':'Sao Paulo','Postal Code':'5442','Country':'Brazil'},
{'Supplier ID': 11, 'Company Name':'Heli Subwaren GmbH & Co. KG','Contact Name':'Petra Winkler','Contact Title':'Sales Manager','City':'Berlin','Postal Code':'10785','Country':'Germany'},
{'Supplier ID': 12, 'Company Name':'Plutzer Lebensmittelgrobmarkte AG','Contact Name':'Martin Bein','Contact Title':'International Marketing Mgr.','City':'Frankfurt','Postal Code':'60439','Country':'Germany'},
{'Supplier ID': 13, 'Company Name':'Nord-Ost-Fisch Handelsgesellschaft mbH','Contact Name':'Sven Petersen','Contact Title':'Coordinator Foreign Markets','City':'Cuxhaven','Postal Code':'27478','Country':'Germany'},
{'Supplier ID': 14, 'Company Name':'Formaggi Fortini s.r.l.','Contact Name':'Elio Rossi','Contact Title':'Sales Representative','City':'Ravenna','Postal Code':'48100','Country':'Italy'},
{'Supplier ID': 15, 'Company Name':'Norske Meierier','Contact Name':'Beate Vileid','Contact Title':'Marketing Manager','City':'Sandvika','Postal Code':'1320','Country':'Norway'},
{'Supplier ID':16,'Company Name':'Bigfoot Breweries','Contact Name':'Cheryl Saylor','Contact Title':'Regional Account Rep.','City':'Bend','Postal Code':'97101','Country':'USA'},
{'Supplier ID':17,'Company Name':'Svensk Sjofoda AB','Contact Name':'Michael Bjorn','Contact Title':'Sales Representative','City':'Stockholm','Postal Code':'S-123 45','Country':'Sweden'},
{'Supplier ID':18,'Company Name':'Aux joyeux ecclesiastiques','Contact Name':'Guylene Nodier','Contact Title':'Sales Manager','City':'Paris','Postal Code':'75004','Country':'France'},
{'Supplier ID':19,'Company Name':'New England Seafood Cannery','Contact Name':'Robb Merchant','Contact Title':'Wholesale Account Agent','City':'Boston','Postal Code':'02134','Country':'USA'},
{'Supplier ID':20,'Company Name':'Leka Trading','Contact Name':'Chandra Leka','Contact Title':'Owner','City':'Singapore','Postal Code':'0512','Country':'Singapore'},
{'Supplier ID':21,'Company Name':'Lyngbysild','Contact Name':'Niels Petersen','Contact Title':'Sales Manager','City':'Lyngby','Postal Code':'2800','Country':'Denmark'},
{'Supplier ID':22,'Company Name':'Zaanse Snoepfabriek','Contact Name':'Dirk Luchte','Contact Title':'Accounting Manager','City':'Zaandam','Postal Code':'9999 ZZ','Country':'Netherlands'},
{'Supplier ID':23,'Company Name':'Karkki Oy','Contact Name':'Anne Heikkonen','Contact Title':'Product Manager','City':'Lappeenranta','Postal Code':'53120','Country':'Finland'},
{'Supplier ID':24,'Company Name':"G'day Mate",'Contact Name':'Wendy Mackenzie','Contact Title':'Sales Representative','City':'Sydney','Postal Code':'2042','Country':'Australia'},
{'Supplier ID':25,'Company Name':'Ma Maison','Contact Name':'Jean-Guy Lauzon','Contact Title':'Marketing Manager','City':'Montreal','Postal Code':'H1J 1C3','Country':'Canada'},
{'Supplier ID':26,'Company Name':'Pasta Buttini s.r.l.','Contact Name':'Giovanni Giudici','Contact Title':'Order Administrator','City':'Salerno','Postal Code':'84100','Country':'Italy'},
{'Supplier ID':27,'Company Name':'Escargots Nouveaux','Contact Name':'Marie Delamare','Contact Title':'Sales Manager','City':'Montceau','Postal Code':'71300','Country':'France'},
{'Supplier ID':28,'Company Name':'Gai paturage','Contact Name':'Eliane Noz','Contact Title':'Sales Representative','City':'Annecy','Postal Code':'74000','Country':'France'},
{'Supplier ID':29,'Company Name':"Forets d'erables",'Contact Name':'Chantal Goulet','Contact Title':'Accounting Manager','City':'Ste-Hyacinthe','Postal Code':'J2S 7S8','Country':'Canada'}
];
window.importData = [
{ "Order ID": 10248, "Customer ID": "VINET", "Employee ID": 5, "Order Date": new Date(836418600000), "Ship Name": "Vins et alcools Chevalier", "Ship City": "Reims", "Ship Address": "59 rue de l\u0027Abbaye", "ShipRegion": null, "ShipPostalCode": "51100", "ShipCountry": "France", "Freight": 32.3800, "Verified": true },
{ "Order ID": 10249, "Customer ID": "TOMSP", "Employee ID": 6, "Order Date": new Date(836505000000), "Ship Name": "Toms Spezialitaten", "Ship City": "Munster", "Ship Address": "Luisenstr. 48", "ShipRegion": null, "ShipPostalCode": "44087", "ShipCountry": "Germany", "Freight": 11.6100, "Verified": false },
{ "Order ID": 10250, "Customer ID": "HANAR", "Employee ID": 4, "Order Date": new Date(836764200000), "Ship Name": "Hanari Carnes", "Ship City": "Rio de Janeiro", "Ship Address": "Rua do Paco, 67", "ShipRegion": "RJ", "ShipPostalCode": "05454-876", "ShipCountry": "Brazil", "Freight": 65.8300, "Verified": true },
{ "Order ID": 10251, "Customer ID": "VICTE", "Employee ID": 3, "Order Date": new Date(836764200000), "Ship Name": "Victuailles en stock", "Ship City": "Lyon", "Ship Address": "2, rue du Commerce", "ShipRegion": null, "ShipPostalCode": "69004", "ShipCountry": "France", "Freight": 41.3400, "Verified": true },
{ "Order ID": 10252, "Customer ID": "SUPRD", "Employee ID": 4, "Order Date": new Date(836850600000), "Ship Name": "Supremes delices", "Ship City": "Charleroi", "Ship Address": "Boulevard Tirou, 255", "ShipRegion": null, "ShipPostalCode": "B-6000", "ShipCountry": "Belgium", "Freight": 51.3000, "Verified": true },
{ "Order ID": 10253, "Customer ID": "HANAR", "Employee ID": 3, "Order Date": new Date(836937000000), "Ship Name": "Hanari Carnes", "Ship City": "Rio de Janeiro", "Ship Address": "Rua do Paco, 67", "ShipRegion": "RJ", "ShipPostalCode": "05454-876", "ShipCountry": "Brazil", "Freight": 58.1700, "Verified": true },
{ "Order ID": 10254, "Customer ID": "CHOPS", "Employee ID": 5, "Order Date": new Date(837023400000), "Ship Name": "Chop-suey Chinese", "Ship City": "Bern", "Ship Address": "Hauptstr. 31", "ShipRegion": null, "ShipPostalCode": "3012", "ShipCountry": "Switzerland", "Freight": 22.9800, "Verified": false },
{ "Order ID": 10255, "Customer ID": "RICSU", "Employee ID": 9, "Order Date": new Date(837109800000), "Ship Name": "Richter Supermarkt", "Ship City": "Geneve", "Ship Address": "Starenweg 5", "ShipRegion": null, "ShipPostalCode": "1204", "ShipCountry": "Switzerland", "Freight": 148.3300, "Verified": true },
{ "Order ID": 10256, "Customer ID": "WELLI", "Employee ID": 3, "Order Date": new Date(837369000000), "Ship Name": "Wellington Importadora", "Ship City": "Resende", "Ship Address": "Rua do Mercado, 12", "ShipRegion": "SP", "ShipPostalCode": "08737-363", "ShipCountry": "Brazil", "Freight": 13.9700, "Verified": false },
{ "Order ID": 10257, "Customer ID": "HILAA", "Employee ID": 4, "Order Date": new Date(837455400000), "Ship Name": "HILARION-Abastos", "Ship City": "San Cristobal", "Ship Address": "Carrera 22 con Ave. Carlos Soublette #8-35", "ShipRegion": "Táchira", "ShipPostalCode": "5022", "ShipCountry": "Venezuela", "Freight": 81.9100, "Verified": true },
{ "Order ID": 10258, "Customer ID": "ERNSH", "Employee ID": 1, "Order Date": new Date(837541800000), "Ship Name": "Ernst Handel", "Ship City": "Graz", "Ship Address": "Kirchgasse 6", "ShipRegion": null, "ShipPostalCode": "8010", "ShipCountry": "Austria", "Freight": 140.5100, "Verified": true },
{ "Order ID": 10259, "Customer ID": "CENTC", "Employee ID": 4, "Order Date": new Date(837628200000), "Ship Name": "Centro comercial Moctezuma", "Ship City": "Mexico D.F.", "Ship Address": "Sierras de Granada 9993", "ShipRegion": null, "ShipPostalCode": "05022", "ShipCountry": "Mexico", "Freight": 3.2500, "Verified": false },
{ "Order ID": 10260, "Customer ID": "OTTIK", "Employee ID": 4, "Order Date": new Date(837714600000), "Ship Name": "Ottilies Kaseladen", "Ship City": "Koln", "Ship Address": "Mehrheimerstr. 369", "ShipRegion": null, "ShipPostalCode": "50739", "ShipCountry": "Germany", "Freight": 55.0900, "Verified": true },
{ "Order ID": 10261, "Customer ID": "QUEDE", "Employee ID": 4, "Order Date": new Date(837714600000), "Ship Name": "Que Delicia", "Ship City": "Rio de Janeiro", "Ship Address": "Rua da Panificadora, 12", "ShipRegion": "RJ", "ShipPostalCode": "02389-673", "ShipCountry": "Brazil", "Freight": 3.0500, "Verified": false },
{ "Order ID": 10262, "Customer ID": "RATTC", "Employee ID": 8, "Order Date": new Date(837973800000), "Ship Name": "Rattlesnake Canyon Grocery", "Ship City": "Albuquerque", "Ship Address": "2817 Milton Dr.", "ShipRegion": "NM", "ShipPostalCode": "87110", "ShipCountry": "USA", "Freight": 48.2900, "Verified": true },
{ "Order ID": 10263, "Customer ID": "ERNSH", "Employee ID": 9, "Order Date": new Date(838060200000), "Ship Name": "Ernst Handel", "Ship City": "Graz", "Ship Address": "Kirchgasse 6", "ShipRegion": null, "ShipPostalCode": "8010", "ShipCountry": "Austria", "Freight": 146.0600, "Verified": true },
{ "Order ID": 10264, "Customer ID": "FOLKO", "Employee ID": 6, "Order Date": new Date(838146600000), "Ship Name": "Folk och fa HB", "Ship City": "Bracke", "Ship Address": "Akergatan 24", "ShipRegion": null, "ShipPostalCode": "S-844 67", "ShipCountry": "Sweden", "Freight": 3.6700, "Verified": false },
{ "Order ID": 10265, "Customer ID": "BLONP", "Employee ID": 2, "Order Date": new Date(838233000000), "Ship Name": "Blondel pere et fils", "Ship City": "Strasbourg", "Ship Address": "24, place Kleber", "ShipRegion": null, "ShipPostalCode": "67000", "ShipCountry": "France", "Freight": 55.2800, "Verified": true },
{ "Order ID": 10266, "Customer ID": "WARTH", "Employee ID": 3, "Order Date": new Date(838319400000), "Ship Name": "Wartian Herkku", "Ship City": "Oulu", "Ship Address": "Torikatu 38", "ShipRegion": null, "ShipPostalCode": "90110", "ShipCountry": "Finland", "Freight": 25.7300, "Verified": false },
{ "Order ID": 10267, "Customer ID": "FRANK", "Employee ID": 4, "Order Date": new Date(838578600000), "Ship Name": "Frankenversand", "Ship City": "Munchen", "Ship Address": "Berliner Platz 43", "ShipRegion": null, "ShipPostalCode": "80805", "ShipCountry": "Germany", "Freight": 208.5800, "Verified": true },
{ "Order ID": 10268, "Customer ID": "GROSR", "Employee ID": 8, "Order Date": new Date(838665000000), "Ship Name": "GROSELLA-Restaurante", "Ship City": "Caracas", "Ship Address": "5ª Ave. Los Palos Grandes", "ShipRegion": "DF", "ShipPostalCode": "1081", "ShipCountry": "Venezuela", "Freight": 66.2900, "Verified": true },
{ "Order ID": 10269, "Customer ID": "WHITC", "Employee ID": 5, "Order Date": new Date(838751400000), "Ship Name": "White Clover Markets", "Ship City": "Seattle", "Ship Address": "1029 - 12th Ave. S.", "ShipRegion": "WA", "ShipPostalCode": "98124", "ShipCountry": "USA", "Freight": 4.5600, "Verified": false },
{ "Order ID": 10270, "Customer ID": "WARTH", "Employee ID": 1, "Order Date": new Date(838837800000), "Ship Name": "Wartian Herkku", "Ship City": "Oulu", "Ship Address": "Torikatu 38", "ShipRegion": null, "ShipPostalCode": "90110", "ShipCountry": "Finland", "Freight": 136.5400, "Verified": true }
];
window.movieData = [
{ no: 'No', year: 'YEAR', title: 'TITLE', review: 'REVIEW', actors: 'STARRING ACTORS', director: 'DIRECTOR', genre: 'GENRE', rating: 'RATING', format: 'FORMAT', comments: 'COMMENTS' },
{ 'no': 1, 'year': 1994, 'title': 'Forrest Gump', 'review': '5 Stars', 'actors': 'Tom Hanks, Robin Wright, Gary Sinise', 'director': 'Robert Zemeckis', 'genre': 'Drama', 'rating': 'PG-13', 'format': 'DVD', 'comments': 'Based on the 1986 novel of the same name by Winston Groom' },
{ 'no': 2, 'year': 1946, 'title': 'Its a Wonderful Life', 'review': '2 Stars', 'actors': 'James Stewart, Donna Reed, Lionel Barrymore ', 'director': 'Frank Capra', 'genre': 'Drama', 'rating': 'G', 'format': 'VHS', 'comments': 'Colorized version' },
{ 'no': 3, 'year': 1988, 'title': 'Big', 'review': '4 Stars', 'actors': 'Tom Hanks, Elizabeth Perkins, Robert Loggia ', 'director': 'Penny Marshall', 'genre': 'Comedy', 'rating': 'PG', 'format': 'DVD', 'comments': '' },
{ 'no': 4, 'year': 1954, 'title': 'Rear Window', 'review': '3 Stars', 'actors': 'James Stewart, Grace Kelly, Wendell Corey ', 'director': 'Alfred Hitchcock', 'genre': 'Suspense', 'rating': 'PG', 'format': 'Blu-ray', 'comments': '' },
];
window.pivotData = [
{ Amount: 100, Country: 'Canada', Date: 'FY 2005', Product: 'Bike', Quantity: 2, State: 'Alberta' },
{ Amount: 200, Country: 'Canada', Date: 'FY 2006', Product: 'Van', Quantity: 3, State: 'British Columbia' },
{ Amount: 300, Country: 'Canada', Date: 'FY 2007', Product: 'Car', Quantity: 4, State: 'Brunswick' },
{ Amount: 150, Country: 'Canada', Date: 'FY 2008', Product: 'Bike', Quantity: 3, State: 'Manitoba' },
{ Amount: 200, Country: 'Canada', Date: 'FY 2006', Product: 'Car', Quantity: 4, State: 'Ontario' },
{ Amount: 100, Country: 'Canada', Date: 'FY 2007', Product: 'Van', Quantity: 1, State: 'Quebec' },
{ Amount: 200, Country: 'France', Date: 'FY 2005', Product: 'Bike', Quantity: 2, State: 'Charente-Maritime' },
{ Amount: 250, Country: 'France', Date: 'FY 2006', Product: 'Van', Quantity: 4, State: 'Essonne' },
{ Amount: 300, Country: 'France', Date: 'FY 2007', Product: 'Car', Quantity: 3, State: 'Garonne (Haute)' },
{ Amount: 150, Country: 'France', Date: 'FY 2008', Product: 'Van', Quantity: 2, State: 'Gers' },
{ Amount: 200, Country: 'Germany', Date: 'FY 2006', Product: 'Van', Quantity: 3, State: 'Bayern' },
{ Amount: 250, Country: 'Germany', Date: 'FY 2007', Product: 'Car', Quantity: 3, State: 'Brandenburg' },
{ Amount: 150, Country: 'Germany', Date: 'FY 2008', Product: 'Car', Quantity: 4, State: 'Hamburg' },
{ Amount: 200, Country: 'Germany', Date: 'FY 2008', Product: 'Bike', Quantity: 4, State: 'Hessen' },
{ Amount: 150, Country: 'Germany', Date: 'FY 2007', Product: 'Van', Quantity: 3, State: 'Nordrhein-Westfalen' },
{ Amount: 100, Country: 'Germany', Date: 'FY 2005', Product: 'Bike', Quantity: 2, State: 'Saarland' },
{ Amount: 150, Country: 'United Kingdom', Date: 'FY 2008', Product: 'Bike', Quantity: 5, State: 'England' },
{ Amount: 250, Country: 'United States', Date: 'FY 2007', Product: 'Car', Quantity: 4, State: 'Alabama' },
{ Amount: 200, Country: 'United States', Date: 'FY 2005', Product: 'Van', Quantity: 4, State: 'California' },
{ Amount: 100, Country: 'United States', Date: 'FY 2006', Product: 'Bike', Quantity: 2, State: 'Colorado' },
{ Amount: 150, Country: 'United States', Date: 'FY 2008', Product: 'Car', Quantity: 3, State: 'New Mexico' },
{ Amount: 200, Country: 'United States', Date: 'FY 2005', Product: 'Bike', Quantity: 4, State: 'New York' },
{ Amount: 250, Country: 'United States', Date: 'FY 2008', Product: 'Car', Quantity: 3, State: 'North Carolina' },
{ Amount: 300, Country: 'United States', Date: 'FY 2007', Product: 'Van', Quantity: 4, State: 'South Carolina' }
];
window.chartData = [
{ Name: "VINET", Average: 90, Grade: "S" },
{ Name: "TOMSP", Average: 83, Grade: "A" },
{ Name: "HANAR", Average: 80, Grade: "A" },
{ Name: "VICTE", Average: 93, Grade: "S" },
{ Name: "SUPRD", Average: 60, Grade: "D" },
{ Name: "CHOPS", Average: 71, Grade: "C" },
{ Name: "WELLI", Average: 88, Grade: "A" },
{ Name: "HILLA", Average: 95, Grade: "S" },
{ Name: "ERNSH", Average: 69, Grade: "D" },
{ Name: "CENTC", Average: 77, Grade: "C" },
{ Name: "OTTIK", Average: 95, Grade: "S" },
{ Name: "RATTC", Average: 85, Grade: "A" },
{ Name: "FOLKO", Average: 90, Grade: "A" },
{ Name: "BLONP", Average: 97, Grade: "S" }
];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment