function create_makerfaire_scheduler($faire_id) { $transport = new \Kendo\Data\DataSourceTransport(); $create = new \Kendo\Data\DataSourceTransportCreate(); $create->url('makerfaire-scheduling-tasks.php?type=create')->contentType('application/json')->type('POST')->dataType('json'); $read = new \Kendo\Data\DataSourceTransportRead(); $read->url('makerfaire-scheduling-tasks.php?type=read')->contentType('application/json')->type('GET')->dataType('json'); $update = new \Kendo\Data\DataSourceTransportUpdate(); $update->url('makerfaire-scheduling-tasks.php?type=update')->contentType('application/json')->type('POST')->dataType('json'); $destroy = new \Kendo\Data\DataSourceTransportDestroy(); $destroy->url('makerfaire-scheduling-tasks.php?type=destroy')->contentType('application/json')->type('POST')->dataType('json'); $transport->create($create)->read($read)->update($update)->destroy($destroy)->parameterMap('function(data) { return kendo.stringify(data); }'); $model = new \Kendo\Data\DataSourceSchemaModel(); $locationIdField = new \Kendo\Data\DataSourceSchemaModelField('locationID'); $locationIdField->type('number')->from('locationID')->nullable(true); $titleField = new \Kendo\Data\DataSourceSchemaModelField('title'); $titleField->from('Title')->defaultValue('No title')->validation(array('required' => false)); $startField = new \Kendo\Data\DataSourceSchemaModelField('start'); $startField->type('date')->from('Start'); $endField = new \Kendo\Data\DataSourceSchemaModelField('end'); $endField->type('date')->from('End'); $isAllDayField = new \Kendo\Data\DataSourceSchemaModelField('isAllDay'); $isAllDayField->type('boolean')->from('IsAllDay'); $subareaIdField = new \Kendo\Data\DataSourceSchemaModelField('subareaId'); $subareaIdField->from('SubareaID')->nullable(true); $entriesField = new \Kendo\Data\DataSourceSchemaModelField('entries'); $entriesField->from('Entries')->nullable(true); $model->id('locationID')->addField($locationIdField)->addField($titleField)->addField($startField)->addField($endField)->addField($isAllDayField)->addField($subareaIdField)->addField($entriesField); $schema = new \Kendo\Data\DataSourceSchema(); $schema->model($model); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->schema($schema)->batch(false); $subareasResource = new \Kendo\UI\SchedulerResource(); $locations_array = get_entry_locations($faire_id); $subareasResource->field('subareaId')->title('Stage')->name('Stages')->dataSource($locations_array); $entries = get_entries($faire_id); $entriesResource = new \Kendo\UI\SchedulerResource(); $entriesResource->field('entries')->title('Presenter')->multiple(true)->name('Presenters')->dataSource($entries); $pdf = new \Kendo\UI\SchedulerPdf(); $pdf->fileName('Kendo UI Scheduler Export.pdf')->proxyURL('makerfaire-scheduling.php?type=save'); $scheduler = new \Kendo\UI\Scheduler('scheduler'); $scheduler->eventTemplateId('presentation-template')->timezone('UTC')->currentTimeMarker(false)->date(new DateTime('2015/9/26 00:00', new DateTimeZone('UTC')))->height(900)->pdf($pdf)->addToolbarItem(new \Kendo\UI\SchedulerToolbarItem('pdf'))->addResource($subareasResource, $entriesResource)->group(array('resources' => array('Stages')))->addView(array('type' => 'day', 'majorTick' => 30, 'showWorkHours' => true, 'workWeekEnd' => 7, 'workDayStart' => new DateTime('2015/1/1 15:00', new DateTimeZone('UTC')), 'workDayEnd' => new DateTime('2015/1/1 24:00', new DateTimeZone('UTC'))), array('type' => 'workWeek', 'majorTick' => 30, 'selected' => true, 'workWeekStart' => 5, 'workWeekEnd' => 7, 'showWorkHours' => true, 'workDayStart' => new DateTime('2015/1/1 15:00', new DateTimeZone('UTC')), 'workDayEnd' => new DateTime('2015/1/1 24:00', new DateTimeZone('UTC'))), 'agenda')->dataSource($dataSource); return $scheduler; }
$isAllDayField->type('boolean')->from('IsAllDay'); $descriptionField = new \Kendo\Data\DataSourceSchemaModelField('description'); $descriptionField->type('string')->from('Description'); $recurrenceIdField = new \Kendo\Data\DataSourceSchemaModelField('recurrenceId'); $recurrenceIdField->from('RecurrenceID'); $recurrenceRuleField = new \Kendo\Data\DataSourceSchemaModelField('recurrenceRule'); $recurrenceRuleField->from('RecurrenceRule'); $recurrenceExceptionField = new \Kendo\Data\DataSourceSchemaModelField('recurrenceException'); $recurrenceExceptionField->from('RecurrenceException'); $ownerIdField = new \Kendo\Data\DataSourceSchemaModelField('ownerId'); $ownerIdField->from('OwnerID')->defaultValue(1); $model->id('taskID')->addField($taskIDField)->addField($titleField)->addField($startField)->addField($endField)->addField($startTimezoneField)->addField($endTimezoneField)->addField($descriptionField)->addField($recurrenceIdField)->addField($recurrenceRuleField)->addField($recurrenceExceptionField)->addField($ownerIdField)->addField($isAllDayField); $schema = new \Kendo\Data\DataSourceSchema(); $schema->data('data')->errors('errors')->model($model); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->schema($schema)->batch(true); $scheduler = new \Kendo\UI\Scheduler('scheduler'); $scheduler->timezone("Etc/UTC")->date(new DateTime('2013/6/13'))->startTime(new DateTime('2013/6/13 6:00'))->height(600)->addView('day', array('type' => 'week', 'selected' => true))->dataSource($dataSource); ?> <div class="configuration-horizontal"> <div class="config-section"> <label><input type="checkbox" checked />Snap events to slot boundaries</label> </div> </div> <?php echo $scheduler->render(); ?> <script> $(function () {
<?php require_once '../lib/Kendo/Autoload.php'; require_once '../include/chart_data.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { header('Content-Type: application/json'); $result = chart_stock_prices(); echo json_encode($result); exit; } require_once '../include/header.php'; $series = new \Kendo\Dataviz\UI\ChartSeriesItem(); $series->type('line')->field('close')->name('#= group.value # (close)'); $valueAxis = new \Kendo\Dataviz\UI\ChartValueAxisItem(); $valueAxis->labels(array('format' => '${0}', 'skip' => 2, 'step' => 2)); $categoryAxis = new \Kendo\Dataviz\UI\ChartCategoryAxisItem(); $categoryAxis->field('date')->labels(array('format' => 'MMM')); $tooltip = new \Kendo\Dataviz\UI\ChartTooltip(); $tooltip->visible(true)->format('{0}%')->template('#= series.name # - #= value #%'); $model = new \Kendo\Data\DataSourceSchemaModel(); $model->addField(array('field' => 'date', 'type' => 'date')); $schema = new \Kendo\Data\DataSourceSchema(); $schema->model($model); $transport = new \Kendo\Data\DataSourceTransport(); $transport->read(array('url' => 'grouped-data.php', 'type' => 'POST', 'dataType' => 'json')); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->schema($schema)->addGroupItem(array('field' => 'symbol'))->addSortItem(array('field' => 'date', 'dir' => 'asc')); $chart = new \Kendo\Dataviz\UI\Chart('chart'); $chart->title(array('text' => 'Stock Prices'))->dataSource($dataSource)->legend(array('position' => 'bottom'))->addSeriesItem($series)->addValueAxisItem($valueAxis)->addCategoryAxisItem($categoryAxis)->seriesDefaults(array('type' => 'area'))->tooltip($tooltip); echo $chart->render(); require_once '../include/footer.php';
$read->url('events.php')->contentType('application/json')->type('POST'); $transport->read($read)->parameterMap('function(data) { return kendo.stringify(data); }'); $model = new \Kendo\Data\DataSourceSchemaModel(); $productNameField = new \Kendo\Data\DataSourceSchemaModelField('ProductName'); $productNameField->type('string'); $unitPriceField = new \Kendo\Data\DataSourceSchemaModelField('UnitPrice'); $unitPriceField->type('number'); $unitsInStockField = new \Kendo\Data\DataSourceSchemaModelField('UnitsInStock'); $unitsInStockField->type('number'); $model->addField($productNameField)->addField($unitPriceField)->addField($unitsInStockField); $schema = new \Kendo\Data\DataSourceSchema(); $schema->data('data')->model($model)->total('total'); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->pageSize(5)->schema($schema)->serverSorting(true)->serverPaging(true); $grid = new \Kendo\UI\Grid('grid'); $productName = new \Kendo\UI\GridColumn(); $productName->field('ProductName')->title('Product Name'); $unitPrice = new \Kendo\UI\GridColumn(); $unitPrice->field('UnitPrice')->format('{0:c}')->width(150)->title('Unit Price'); $unitsInStock = new \Kendo\UI\GridColumn(); $unitsInStock->field('UnitsInStock')->width(150)->title('Units In Stock'); $grid->addColumn($productName, $unitPrice, $unitsInStock)->selectable('cell multiple')->pageable(true)->sortable(true)->dataSource($dataSource)->change('onChange')->dataBound('onDataBound')->dataBinding('onDataBinding'); echo $grid->render(); ?> <script> function onChange(arg) { var selected = $.map(this.select(), function(item) { return $(item).text();
$isAllDayField->type('boolean')->from('IsAllDay'); $descriptionField = new \Kendo\Data\DataSourceSchemaModelField('description'); $descriptionField->type('string')->from('Description'); $recurrenceIdField = new \Kendo\Data\DataSourceSchemaModelField('recurrenceId'); $recurrenceIdField->from('RecurrenceID'); $recurrenceRuleField = new \Kendo\Data\DataSourceSchemaModelField('recurrenceRule'); $recurrenceRuleField->from('RecurrenceRule'); $recurrenceExceptionField = new \Kendo\Data\DataSourceSchemaModelField('recurrenceException'); $recurrenceExceptionField->from('RecurrenceException'); $ownerIdField = new \Kendo\Data\DataSourceSchemaModelField('ownerId'); $ownerIdField->from('OwnerID')->defaultValue(1); $model->id('taskID')->addField($taskIDField)->addField($titleField)->addField($startField)->addField($endField)->addField($startTimezoneField)->addField($endTimezoneField)->addField($descriptionField)->addField($recurrenceIdField)->addField($recurrenceRuleField)->addField($recurrenceExceptionField)->addField($ownerIdField)->addField($isAllDayField); $schema = new \Kendo\Data\DataSourceSchema(); $schema->data('data')->errors('errors')->model($model); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->schema($schema)->batch(true)->addFilterItem(array('logic' => 'or', 'filters' => array(array('field' => 'ownerId', 'operator' => 'eq', 'value' => 1), array('field' => 'ownerId', 'operator' => 'eq', 'value' => 2)))); $resource = new \Kendo\UI\SchedulerResource(); $resource->field('ownerId')->title('Owner')->dataSource(array(array('text' => 'Alex', 'value' => 1, 'color' => '#f8a398'), array('text' => 'Bob', 'value' => 2, 'color' => '#51a0ed'), array('text' => 'Charlie', 'value' => 3, 'color' => '#56ca85'))); $scheduler = new \Kendo\UI\Scheduler('scheduler'); $scheduler->timezone("Etc/UTC")->date(new DateTime('2013/6/13'))->height(600)->addResource($resource)->addView(array('type' => 'day', 'startTime' => new DateTime('2013/6/13 7:00')), array('type' => 'workWeek', 'selected' => true, 'startTime' => new DateTime('2013/6/13 7:00')), array('type' => 'week', 'startTime' => new DateTime('2013/6/13 7:00')), 'month', 'agenda')->dataSource($dataSource); ?> <div id="people"> <input checked type="checkbox" id="alex" value="1"> <input checked type="checkbox" id="bob" value="2"> <input type="checkbox" id="charlie" value="3"> </div> <?php echo $scheduler->render(); ?>
$model = new \Kendo\Data\DataSourceSchemaModel(); $orderIDField = new \Kendo\Data\DataSourceSchemaModelField('OrderID'); $orderIDField->type('number'); $shipCountryField = new \Kendo\Data\DataSourceSchemaModelField('ShipCountry'); $shipCountryField->type('string'); $shipCityField = new \Kendo\Data\DataSourceSchemaModelField('ShipCity'); $shipCityField->type('string'); $shipNameField = new \Kendo\Data\DataSourceSchemaModelField('ShipName'); $shipNameField->type('string'); $shipAddressField = new \Kendo\Data\DataSourceSchemaModelField('ShipAddress'); $shipAddressField->type('string'); $model->addField($orderIDField)->addField($shipCountryField)->addField($shipCityField)->addField($shipNameField)->addField($shipAddressField); $schema = new \Kendo\Data\DataSourceSchema(); $schema->data('data')->model($model)->total('total'); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->pageSize(30)->schema($schema)->serverFiltering(true)->serverSorting(true)->serverGrouping(true)->serverPaging(true); $grid = new \Kendo\UI\Grid('grid'); $orderID = new \Kendo\UI\GridColumn(); $orderID->field('OrderID')->locked(true)->lockable(false)->width(120)->title('Order ID'); $shipCountry = new \Kendo\UI\GridColumn(); $shipCountry->field('ShipCountry')->width(200)->title('Ship Country'); $shipCity = new \Kendo\UI\GridColumn(); $shipCity->field('ShipCity')->width(160)->title('Ship City'); $shipName = new \Kendo\UI\GridColumn(); $shipName->field('ShipName')->width(200)->locked(true)->title('Ship Name'); $shipAddress = new \Kendo\UI\GridColumn(); $shipAddress->field('ShipAddress')->width(300)->lockable(false)->title('Ship Address'); $grid->addColumn($orderID, $shipCountry, $shipCity, $shipName, $shipAddress)->height(430)->scrollable(true)->dataSource($dataSource)->groupable(true)->reorderable(true)->resizable(true)->columnMenu(true)->sortable(true)->filterable(true)->pageable(true); echo $grid->render(); ?>
echo json_encode($result->read('Employees', array('FirstName', 'LastName', 'City', 'Address', 'HomePhone'), $request)); exit; } require_once '../include/header.php'; $transport = new \Kendo\Data\DataSourceTransport(); $read = new \Kendo\Data\DataSourceTransportRead(); $read->url('navigation.php')->contentType('application/json')->type('POST'); $transport->read($read)->parameterMap('function(data) { return kendo.stringify(data); }'); $schema = new \Kendo\Data\DataSourceSchema(); $schema->data('data')->groups('groups')->total('total'); $dataSource = new \Kendo\Data\DataSource(); $group = new \Kendo\Data\DataSourceGroupItem(); $group->field('City'); $dataSource->transport($transport)->pageSize(5)->addGroupItem($group)->schema($schema)->serverSorting(true)->serverFiltering(true)->serverGrouping(true)->serverPaging(true); $grid = new \Kendo\UI\Grid('grid'); $firstName = new \Kendo\UI\GridColumn(); $firstName->field("FirstName")->title('First Name'); $lastName = new \Kendo\UI\GridColumn(); $lastName->field("LastName")->title('Last Name'); $city = new \Kendo\UI\GridColumn(); $city->field('City'); $address = new \Kendo\UI\GridColumn(); $address->field('Address'); $phone = new \Kendo\UI\GridColumn(); $phone->field('HomePhone'); $grid->addColumn($firstName, $lastName, $city, $address, $phone)->selectable('cell multiple')->pageable(true)->navigatable(true)->sortable(true)->filterable(true)->dataSource($dataSource); echo $grid->render(); ?> <ul class="keyboard-legend" style="padding-top: 25px">
$model = new \Kendo\Data\DataSourceSchemaModel(); $productIDField = new \Kendo\Data\DataSourceSchemaModelField('ProductID'); $productIDField->type('number')->editable(false)->nullable(true); $productNameField = new \Kendo\Data\DataSourceSchemaModelField('ProductName'); $productNameField->type('string'); $unitPriceField = new \Kendo\Data\DataSourceSchemaModelField('UnitPrice'); $unitPriceField->type('number'); $unitsInStockField = new \Kendo\Data\DataSourceSchemaModelField('UnitsInStock'); $unitsInStockField->type('number'); $discontinuedField = new \Kendo\Data\DataSourceSchemaModelField('Discontinued'); $discontinuedField->type('boolean'); $model->id('ProductID')->addField($productIDField)->addField($productNameField)->addField($unitPriceField)->addField($discontinuedField)->addField($unitsInStockField); $schema = new \Kendo\Data\DataSourceSchema(); $schema->data('data')->errors('errors')->model($model)->total('total'); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->batch(true)->schema($schema)->pageSize(4); $listview = new \Kendo\UI\ListView('listView'); $listview->dataSource($dataSource)->templateId('template')->editTemplateId('editTemplate')->selectable(true)->navigatable(true)->pageable(true); echo $listview->render(); ?> </div> <script> $(function() { $(".k-add-button").click(function(e) { var listView = $("#listView").data("kendoListView"); listView.add(); e.preventDefault(); });
$request = json_decode(file_get_contents('php://input')); $result = new DataSourceResult('sqlite:..//sample.db'); echo json_encode($result->read('Products', array('ProductID', 'ProductName'), $request)); exit; } require_once '../include/header.php'; $transport = new \Kendo\Data\DataSourceTransport(); $read = new \Kendo\Data\DataSourceTransportRead(); $read->url('serverfiltering.php')->contentType('application/json')->type('POST'); $transport->read($read)->parameterMap('function(data) { return kendo.stringify(data); }'); $schema = new \Kendo\Data\DataSourceSchema(); $schema->data('data')->total('total'); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->schema($schema)->serverFiltering(true); $autoComplete = new \Kendo\UI\AutoComplete('products'); $autoComplete->dataSource($dataSource)->dataTextField('ProductName')->ignoreCase(false)->attr('style', 'width:250px'); ?> <div class="demo-section"> <h2>Products</h2> <?php echo $autoComplete->render(); ?> </div> <style scoped> .demo-section { width: 250px; margin: 35px auto 50px; padding: 30px; }
require_once '../lib/Kendo/Autoload.php'; require_once '../include/chart_data.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { header('Content-Type: application/json'); $result = chart_spain_electricity_production(); echo json_encode($result); exit; } require_once '../include/header.php'; ?> <div class="chart-wrapper" style="margin: auto;"> <?php $series = new \Kendo\Dataviz\UI\ChartSeriesItem(); $series->field('wind')->categoryField('year')->segmentSpacing(2); $transport = new \Kendo\Data\DataSourceTransport(); $transport->read(array('url' => 'remote-data-binding.php', 'type' => 'POST', 'dataType' => 'json')); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->addSortItem(array('field' => 'year', 'dir' => 'desc')); $chart = new \Kendo\Dataviz\UI\Chart("chart"); $chart->title(array('text' => "Spain windpower electricity production (GWh)"))->dataSource($dataSource)->addSeriesItem($series)->legend(array('visible' => false))->tooltip(array('visible' => true, 'format' => 'N0', 'template' => "#= dataItem.year # - #= value# GWh"))->seriesDefaults(array('type' => 'funnel', 'dynamicSlope' => true, 'dynamicHeight' => false, 'labels' => array('visible' => true, 'template' => '#= dataItem.year#'))); echo $chart->render(); ?> </div> <style scoped> .chart-wrapper .k-chart { margin: 0 auto; width: 400px; } </style> <?php require_once '../include/footer.php';
<?php require_once '../lib/Kendo/Autoload.php'; require_once '../include/chart_data.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { header('Content-Type: application/json'); $result = chart_japan_medals(); echo json_encode($result); exit; } require_once '../include/header.php'; $series = new \Kendo\Dataviz\UI\ChartSeriesItem(); $series->type('bubble')->minSize(0)->maxSize(70)->xField('year')->yField('standing')->sizeField('number')->colorField('medalColor')->opacity(0.9); $tooltip = new \Kendo\Dataviz\UI\ChartTooltip(); $tooltip->visible(true)->template('#= value.x #: #= value.size # Medals'); $transport = new \Kendo\Data\DataSourceTransport(); $transport->read(array('url' => 'grouped-data.php', 'type' => 'POST', 'dataType' => 'json')); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->addGroupItem(array('field' => 'country')); $xAxis = new \Kendo\Dataviz\UI\ChartXAxisItem(); $xAxis->labels(array('skip' => 1, 'margin' => array('top' => -25)))->majorUnit(4)->min(1980)->max(2015)->majorGridLines(array('visible' => false))->line(array('visible' => false)); $yAxis = new \Kendo\Dataviz\UI\ChartXAxisItem(); $yAxis->labels(array('step' => 1, 'skip' => 1, 'template' => '#= value # place', 'margin' => array('right' => -30), 'padding' => array('left' => 20)))->majorUnit(1)->min(0)->max(3.7)->majorGridLines(array('visible' => false))->line(array('visible' => false)); $chart = new \Kendo\Dataviz\UI\Chart('chart'); $chart->dataSource($dataSource)->title(array('text', 'Olypmic Medals Won by Japan'))->legend(array('visible' => false))->addSeriesItem($series)->addXAxisItem($xAxis)->addYAxisItem($yAxis)->tooltip($tooltip); echo $chart->render(); require_once '../include/footer.php';
$result = chart_screen_resolution(); echo json_encode($result); exit; } require_once '../include/header.php'; ?> <div class="chart-wrapper" style="margin: auto;"> <h3>1024x768 screen resolution trends</h3> <?php for ($year = 2000; $year <= 2009; $year++) { $series = new \Kendo\Dataviz\UI\ChartSeriesItem(); $series->field('share')->categoryField('resolution')->padding(0); $transport = new \Kendo\Data\DataSourceTransport(); $transport->read(array('url' => 'remote-data-binding.php', 'type' => 'POST', 'dataType' => 'json')); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->addSortItem(array('field' => 'year', 'dir' => 'asc'))->addFilterItem(array('field' => 'year', 'operator' => 'eq', 'value' => $year)); $chart = new \Kendo\Dataviz\UI\Chart("chart{$year}"); $chart->title(array('text' => "{$year}"))->dataSource($dataSource)->addSeriesItem($series)->legend(array('position' => 'top'))->tooltip(array('visible' => true, 'format' => 'N0', 'template' => "#= category # - #= kendo.format('{0:P}', percentage)#"))->seriesDefaults(array('type' => 'pie')); echo $chart->render(); } ?> </div> <style scoped> .chart-wrapper { text-align: center; height: 340px; width: 700px; } .chart-wrapper h3 { padding: 1em 0; font-size: 1.5em;
<?php require_once '../lib/Kendo/Autoload.php'; require_once '../include/chart_data.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { header('Content-Type: application/json'); $result = chart_wind_data(); echo json_encode($result); exit; } require_once '../include/header.php'; $frequency = new \Kendo\Dataviz\UI\ChartSeriesItem(); $frequency->type('radarColumn')->stack(true)->field('frequency'); $categoryAxis = new \Kendo\Dataviz\UI\ChartCategoryAxisItem(); $categoryAxis->field('dirText'); $valueAxis = new \Kendo\Dataviz\UI\ChartValueAxisItem(); $valueAxis->visible(false); $transport = new \Kendo\Data\DataSourceTransport(); $transport->read(array('url' => 'grouped-data.php', 'type' => 'POST', 'dataType' => 'json')); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->addGroupItem(array('field' => 'category'))->addSortItem(array('field' => 'dir', 'dir' => 'asc')); $chart = new \Kendo\Dataviz\UI\Chart('chart'); $chart->title(array('text' => 'Wind Rose'))->legend(array('position' => 'right', 'labels' => array('template' => '#= (series.data[0] || {}).categoryText # m/s')))->dataSource($dataSource)->seriesColors(array('#1b79e4', '#3b6ad3', '#5d5ac2', '#8348ae', '#a23a9d', '#c42a8c', '#e51a7a'))->addSeriesItem($frequency)->addCategoryAxisItem($categoryAxis)->addValueAxisItem($valueAxis)->tooltip(array('template' => '#= category # (#= dataItem.categoryText # m/s) #= value #%', 'visible' => true)); echo $chart->render(); require_once '../include/footer.php';
$request = json_decode(file_get_contents('php://input')); $result = new DataSourceResult('sqlite:..//sample.db'); echo json_encode($result->read('Products', array('ProductID', 'ProductName'), $request)); exit; } require_once '../include/header.php'; $transport = new \Kendo\Data\DataSourceTransport(); $read = new \Kendo\Data\DataSourceTransportRead(); $read->url('remotedatasource.php')->contentType('application/json')->type('POST'); $transport->read($read)->parameterMap('function(data) { return kendo.stringify(data); }'); $schema = new \Kendo\Data\DataSourceSchema(); $schema->data('data')->total('total'); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->schema($schema); $dropDownList = new \Kendo\UI\DropDownList('products'); $dropDownList->dataSource($dataSource)->dataTextField('ProductName')->dataValueField('ProductID')->attr('style', 'width: 250px'); ?> <div class="demo-section"> <h2>Products</h2> <?php echo $dropDownList->render(); ?> </div> <style scoped> .demo-section { width: 250px; margin: 35px auto 50px; padding: 30px; }
?> <script id="details" type="text/x-kendo-template"> <?php $transport = new \Kendo\Data\DataSourceTransport(); $read = new \Kendo\Data\DataSourceTransportRead(); $read->url('hierarchy.php?details=details')->contentType('application/json')->type('POST'); $transport->read($read)->parameterMap('function(data) { return kendo.stringify(data); }'); $schema = new \Kendo\Data\DataSourceSchema(); $schema->data('data')->total('total'); $dataSource = new \Kendo\Data\DataSource(); $filter = new \Kendo\Data\DataSourceFilterItem(); $filter->field('EmployeeID')->operator('eq')->value('#=EmployeeID#'); $dataSource->transport($transport)->pageSize(5)->schema($schema)->addFilterItem($filter)->serverSorting(true)->serverFiltering(true)->serverPaging(true); $detailGrid = new \Kendo\UI\Grid('detailGrid#=EmployeeID#'); $orderID = new \Kendo\UI\GridColumn(); $orderID->field('OrderID')->width(70)->title('Order ID'); $shipCountry = new \Kendo\UI\GridColumn(); $shipCountry->field('ShipCountry')->width(110)->title('Ship Country'); $shipAddress = new \Kendo\UI\GridColumn(); $shipAddress->field('ShipAddress')->title('Ship Address'); $shipName = new \Kendo\UI\GridColumn(); $shipName->field('ShipName')->title('Ship Name')->width(200); $detailGrid->dataSource($dataSource)->addColumn($orderID, $shipCountry, $shipAddress, $shipName)->pageable(true)->sortable(true)->scrollable(false); echo $detailGrid->renderInTemplate(); ?> </script> <script>
$read = new \Kendo\Data\DataSourceTransportRead(); $read->url('selection.php')->contentType('application/json')->type('POST'); $transport->read($read)->parameterMap('function(data) { return kendo.stringify(data); }'); $model = new \Kendo\Data\DataSourceSchemaModel(); $productNameField = new \Kendo\Data\DataSourceSchemaModelField('ProductName'); $productNameField->type('string'); $unitPriceField = new \Kendo\Data\DataSourceSchemaModelField('UnitPrice'); $unitPriceField->type('number'); $unitsInStockField = new \Kendo\Data\DataSourceSchemaModelField('UnitsInStock'); $unitsInStockField->type('number'); $model->addField($productNameField)->addField($unitPriceField)->addField($unitsInStockField); $schema = new \Kendo\Data\DataSourceSchema(); $schema->data('data')->model($model)->total('total'); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->schema($schema)->pageSize(12); $listview = new \Kendo\UI\ListView('listView'); $listview->dataSource($dataSource)->templateId('template')->selectable('multiple')->pageable(true)->dataBound("onDataBound")->change("onChange"); echo $listview->render(); ?> </div> <div class="demo-section"> <h2>Console Log</h2> <div class="console"></div> </div> <script> function onDataBound() { kendoConsole.log("ListView data bound");
<?php require_once '../lib/Kendo/Autoload.php'; require_once '../include/chart_data.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { header('Content-Type: application/json'); $result = chart_screen_resolution(); echo json_encode($result); exit; } require_once '../include/header.php'; $series = new \Kendo\Dataviz\UI\ChartSeriesItem(); $series->field('share')->categoryField('resolution')->visibleInLegendField('visibleInLegend')->padding(10); $transport = new \Kendo\Data\DataSourceTransport(); $transport->read(array('url' => 'remote-data-binding.php', 'type' => 'POST', 'dataType' => 'json')); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->addSortItem(array('field' => 'order', 'dir' => 'asc'))->addGroupItem(array('field' => 'year')); $chart = new \Kendo\Dataviz\UI\Chart('chart'); $chart->title(array('text' => '1024x768 screen resolution trends'))->dataSource($dataSource)->addSeriesItem($series)->legend(array('position' => 'top'))->tooltip(array('visible' => true, 'template' => '#= dataItem.resolution #: #= value #% (#= dataItem.year #)'))->seriesDefaults(array('type' => 'donut', 'startAngle' => 270)); echo $chart->render(); require_once '../include/footer.php';
<tr> <th class="month">MONTH</th> <th>MAX TEMP °C</th> <th>WIND SPEED KM/H</th> <th>RAINFALL MM</th> </tr> </thead> <tbody> <?php $months = array("January", "February", "March", "April", "May", "June"); for ($i = 0; $i < count($months); $i++) { $monthNumber = $i + 1; $transport = new \Kendo\Data\DataSourceTransport(); $transport->read(array('url' => "_weather.php?station=SOFIA&year=2012&month={$monthNumber}", 'type' => 'POST', 'dataType' => 'json')); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport); ?> <tr> <td class="month"><?php echo $months[$i]; ?> </td> <td> <?php $tmaxSeries = new \Kendo\Dataviz\UI\SparklineSeriesItem(); $tmaxSeries->type('column')->field('TMax')->color('#ff0000')->negativeColor('#0099ff'); $tmax = new \Kendo\Dataviz\UI\Sparkline("sparkline-tmax-{$i}"); $tmax->dataSource($dataSource)->addSeriesItem($tmaxSeries); echo $tmax->render(); ?> </td>
$schema = new \Kendo\Data\DataSourceSchema(); $schema->data('data')->errors('errors')->groups('groups')->aggregates('aggregates')->total('total'); $productNameCount = new \Kendo\Data\DataSourceAggregateItem(); $productNameCount->field("ProductName")->aggregate("count"); $unitsOnOrderAvg = new \Kendo\Data\DataSourceAggregateItem(); $unitsOnOrderAvg->field("UnitsOnOrder")->aggregate("average"); $unitsInStockMin = new \Kendo\Data\DataSourceAggregateItem(); $unitsInStockMin->field("UnitsInStock")->aggregate("min"); $unitsInStockMax = new \Kendo\Data\DataSourceAggregateItem(); $unitsInStockMax->field("UnitsInStock")->aggregate("max"); $unitsInStockCount = new \Kendo\Data\DataSourceAggregateItem(); $unitsInStockCount->field("UnitsInStock")->aggregate("count"); $group = new \Kendo\Data\DataSourceGroupItem(); $group->field('UnitsInStock')->addAggregate($productNameCount, $unitsOnOrderAvg, $unitsInStockMin, $unitsInStockMax, $unitsInStockCount); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->pageSize(7)->serverPaging(true)->serverSorting(true)->serverGrouping(true)->serverFiltering(true)->serverAggregates(true)->addGroupItem($group)->addAggregateItem($productNameCount, $unitsOnOrderAvg, $unitsInStockMin, $unitsInStockMax)->schema($schema); $grid = new \Kendo\UI\Grid('grid'); $productName = new \Kendo\UI\GridColumn(); $productName->field('ProductName')->footerTemplate('Total Count: #=count#')->groupFooterTemplate('Count: #=count#')->title('Product Name'); $unitPrice = new \Kendo\UI\GridColumn(); $unitPrice->field('UnitPrice')->format('{0:c}')->width(150)->title('Unit Price'); $unitsOnOrder = new \Kendo\UI\GridColumn(); $unitsOnOrder->field('UnitsOnOrder')->width(150)->footerTemplate('Average: #=average#')->groupFooterTemplate('Average: #=average#')->title('Units On Order'); $unitsInStock = new \Kendo\UI\GridColumn(); $unitsInStock->field('UnitsInStock')->width(150)->footerTemplate('<div>Min: #= min #</div><div>Max: #= max #</div>')->groupHeaderTemplate('Units In Stock: #= value # (Count: #= count#)')->title('Units In Stock'); $grid->addColumn($productName, $unitPrice, $unitsOnOrder, $unitsInStock)->dataSource($dataSource)->scrollable(false)->sortable(true)->pageable(true); echo $grid->render(); ?> <?php require_once '../include/footer.php';