Skip to content

Instantly share code, notes, and snippets.

View lohithgn's full-sized avatar

Lohith lohithgn

View GitHub Profile
<div id="grid"></div>
<script>
$("#grid").kendoGrid({
});
</script>
@lohithgn
lohithgn / prepopulateddb.js
Created November 13, 2015 08:08
Open Pre-Populated SQLite DB
app.openDb = function() {
var dbName = "todo.db";
app.db = window.sqlitePlugin.openDatabase({name: dbName, createFromLocation: 1});
}
@lohithgn
lohithgn / sqliteplugincode.js
Last active November 13, 2015 07:37
SQLite Plugin OpenDB & CreateTable
var app = {};
app.db = null;
app.openDb = function() {
var dbName = "todo.db";
app.db = window.sqlitePlugin.openDatabase(dbName);
}
app.createTable = function() {
var db = app.db;
$("#configurator").kendoPivotConfigurator({
dataSource: pivotgrid.dataSource,
height: 330
});
<!-- HTML Div to hold Pivot Grid Configurator -->
<div id="configurator"></div>
$(document).ready(function () {
var pivotgrid = $("#pivotgrid").kendoPivotGrid({
columnWidth: 120,
height: 275,
dataSource: {
data: leaveData,
schema: {
model: {
fields: {
Employee: { type: "string" },
var leaveData = [
{
Employee:"Jane",
Start: new Date(2014,3,17),
End: new Date(2014,3,17),
Type:"Sick Leave",
Days:1
},
{
Employee:"Jane",
<script>
$(document).ready(function () {
var pivotgrid = $("#pivotgrid").kendoPivotGrid({
columnWidth: 120,
height: 570,
dataSource: {
type: "odata",
transport: {
read: "http://demos.telerik.com/kendo-ui/service/Northwind.svc/Customers"
},
<script>
$(document).ready(function () {
$("#pivotgrid").kendoPivotGrid({
height: 200,
dataSource: {
type: "xmla",
columns: [{ name: "[Date].[Calendar]" }],
rows: [{ name: "[Product].[Category]" }],
measures: ["[Measures].[Internet Sales Amount]"],
transport: {
<!-- Define the HTML div that will hold the PivotGrid -->
<div id="pivotgrid">
</div>