<?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_antenna_gain(); echo json_encode($result); exit; } require_once '../include/header.php'; $gain = new \Kendo\Dataviz\UI\ChartSeriesItem(); $gain->type('polarLine')->xField('azimuth')->yField('gain'); $xAxis = new \Kendo\Dataviz\UI\ChartXAxisItem(); $xAxis->majorUnit(30); $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); $chart = new \Kendo\Dataviz\UI\Chart('chart'); $chart->title(array('text' => 'Antenna Gain (dB)'))->dataSource($dataSource)->addSeriesItem($gain)->addXAxisItem($xAxis); echo $chart->render(); require_once '../include/footer.php';
<?php require_once '../lib/Kendo/Autoload.php'; require_once '../lib/DataSourceResult.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { header('Content-Type: application/json'); $result = new DataSourceResult('sqlite:..//sample.db'); echo json_encode($result->read('Customers', array('ContactName', 'CustomerID', 'CompanyName'))); exit; } require_once '../include/header.php'; $read = new \Kendo\Data\DataSourceTransportRead(); $read->url('template.php')->type('POST'); $transport = new \Kendo\Data\DataSourceTransport(); $transport->read($read); $schema = new \Kendo\Data\DataSourceSchema(); $schema->data('data')->total('total'); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->schema($schema); $autoComplete = new \Kendo\UI\AutoComplete('customers'); $autoComplete->minLength(1)->dataTextField('ContactName')->dataSource($dataSource)->height(370)->attr('style', 'width:400px')->headerTemplate(<<<TEMPLATE <div class="dropdown-header"><span class="k-widget k-header">Photo</span><span class="k-widget k-header">Contact info</span></div> TEMPLATE )->template(<<<TEMPLATE <span class="k-state-default"><img src="../content/web/Customers/#= CustomerID #.jpg" alt="#= CustomerID #" /></span><span class="k-state-default"><h3>#: data.ContactName #</h3><p>#: data.CompanyName #</p></span> TEMPLATE ); ?> <div class="demo-section"> <h2>Customers</h2>
exit; } require_once '../include/header.php'; ?> <script type="text/x-kendo-tmpl" id="template"> <div class="product"> <img src="../content/web/foods/#:ProductID#.jpg" alt="#:ProductName# image" /> <h3>#:ProductName#</h3> <p>#:kendo.toString(UnitPrice, "c")#</p> </div> </script> <div class="demo-section"> <?php $transport = new \Kendo\Data\DataSourceTransport(); $read = new \Kendo\Data\DataSourceTransportRead(); $read->url('integration-listview.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(15);
<?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';
<input type="text" data-bind="value:UnitsInStock" data-role="numerictextbox" name="UnitsInStock" required="required" data-type="number" min="0" validationMessage="required" /> <span data-for="UnitsInStock" class="k-invalid-msg"></span> </dd> <dt>Discontinued</dt> <dd><input type="checkbox" name="Discontinued" data-bind="checked:Discontinued"></dd> </dl> </div> </script> <div class="demo-section"> <a class="k-button k-button-icontext k-add-button" href="#"><span class="k-icon k-add"></span>Add new record</a> </div> <div class="demo-section"> <?php $transport = new \Kendo\Data\DataSourceTransport(); $create = new \Kendo\Data\DataSourceTransportCreate(); $create->url('navigation.php?type=create')->contentType('application/json')->type('POST'); $read = new \Kendo\Data\DataSourceTransportRead(); $read->url('navigation.php?type=read')->contentType('application/json')->type('POST'); $update = new \Kendo\Data\DataSourceTransportUpdate(); $update->url('navigation.php?type=update')->contentType('application/json')->type('POST'); $destroy = new \Kendo\Data\DataSourceTransportDestroy(); $destroy->url('navigation.php?type=destroy')->contentType('application/json')->type('POST'); $transport->create($create)->read($read)->update($update)->destroy($destroy)->parameterMap('function(data) { return kendo.stringify(data); }'); $model = new \Kendo\Data\DataSourceSchemaModel(); $productIDField = new \Kendo\Data\DataSourceSchemaModelField('ProductID'); $productIDField->type('number')->editable(false)->nullable(true); $productNameField = new \Kendo\Data\DataSourceSchemaModelField('ProductName');
break; case 'update': $result = $result->update('Tasks', $columns, $request->models, 'TaskID'); break; case 'destroy': $result = $result->destroy('Tasks', $request->models, 'TaskID'); break; default: $result = $result->read('Tasks', array('TaskID', 'OwnerID'), $request); break; } echo json_encode($result, JSON_NUMERIC_CHECK); exit; } require_once '../include/header.php'; $transport = new \Kendo\Data\DataSourceTransport(); $create = new \Kendo\Data\DataSourceTransportCreate(); $create->url('index.php?type=create')->contentType('application/json')->type('POST'); $read = new \Kendo\Data\DataSourceTransportRead(); $read->url('index.php?type=read')->contentType('application/json')->type('POST'); $update = new \Kendo\Data\DataSourceTransportUpdate(); $update->url('index.php?type=update')->contentType('application/json')->type('POST'); $destroy = new \Kendo\Data\DataSourceTransportDestroy(); $destroy->url('index.php?type=destroy')->contentType('application/json')->type('POST'); $transport->create($create)->read($read)->update($update)->destroy($destroy)->parameterMap('function(data) { return kendo.stringify(data); }'); $model = new \Kendo\Data\DataSourceSchemaModel(); $taskIDField = new \Kendo\Data\DataSourceSchemaModelField('taskID'); $taskIDField->type('number')->from('TaskID')->nullable(true); $titleField = new \Kendo\Data\DataSourceSchemaModelField('title');
<?php require_once '../lib/DataSourceResult.php'; require_once '../lib/Kendo/Autoload.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { header('Content-Type: application/json'); $request = json_decode(file_get_contents('php://input')); $result = new DataSourceResult('sqlite:..//sample.db'); 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');
echo json_encode($result->read('Products', array('ProductID', 'ProductName', 'UnitPrice', 'UnitsInStock'), $request)); exit; } require_once '../include/header.php'; ?> <script type="text/x-kendo-tmpl" id="template"> <div class="product"> <img src="../content/web/foods/#:ProductID#.jpg" alt="#:ProductName# image" /> <h3>#:ProductName#</h3> </div> </script> <div class="demo-section"> <?php $transport = new \Kendo\Data\DataSourceTransport(); $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();
<?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';
<?php require_once '../lib/DataSourceResult.php'; require_once '../lib/Kendo/Autoload.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { header('Content-Type: application/json'); $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>
exit; } require_once '../include/header.php'; $nuclear = new \Kendo\Dataviz\UI\ChartSeriesItem(); $nuclear->field('nuclear')->name('Nuclear'); $hydro = new \Kendo\Dataviz\UI\ChartSeriesItem(); $hydro->field('hydro')->name('Hydro'); $wind = new \Kendo\Dataviz\UI\ChartSeriesItem(); $wind->field('wind')->name('Wind'); $valueAxis = new \Kendo\Dataviz\UI\ChartValueAxisItem(); $valueAxis->labels(array('format' => 'N0'))->line(array('visible' => false))->majorUnit(10000); $categoryAxis = new \Kendo\Dataviz\UI\ChartCategoryAxisItem(); $categoryAxis->field('year')->labels(array('rotation' => -90)); $tooltip = new \Kendo\Dataviz\UI\ChartTooltip(); $tooltip->visible(true)->format('N0'); $transport = new \Kendo\Data\DataSourceTransport(); $transport->read(array('url' => 'events.php', 'type' => 'POST', 'dataType' => 'json')); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->addSortItem(array('field' => 'year', 'dir' => 'asc')); $chart = new \Kendo\Dataviz\UI\Chart('chart'); $chart->title(array('text' => 'Spain electricity production (GWh)'))->dataSource($dataSource)->legend(array('position' => 'top'))->addSeriesItem($nuclear, $hydro, $wind)->addValueAxisItem($valueAxis)->addCategoryAxisItem($categoryAxis)->seriesDefaults(array('type' => 'column'))->tooltip($tooltip)->seriesClick('onSeriesClick')->seriesHover('onSeriesHover')->dataBound('onDataBound')->axisLabelClick('onAxisLabelClick')->plotAreaClick('onPlotAreaClick')->dragStart('onDragStart')->drag('onDrag')->dragEnd('onDragEnd')->zoomStart('onZoomStart')->zoom('onZoom')->zoomEnd('onZoomEnd'); echo $chart->render(); ?> <div class="demo-section"> <h3 class="title">Console log</h3> <div class="console"></div> </div> <script> function onSeriesClick(e) { kendoConsole.log(kendo.format("Series click :: {0} ({1}): {2}",
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'; ?> <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; }
<?php require_once '../lib/Kendo/Autoload.php'; require_once '../include/header.php'; $series = new \Kendo\Dataviz\UI\StockChartSeriesItem(); $series->type('candlestick')->openField('Open')->highField('High')->lowField('Low')->closeField('Close'); $transport = new \Kendo\Data\DataSourceTransport(); $transport->read(array('url' => '_intraday.php', 'type' => 'POST', 'dataType' => 'json'))->parameterMap('function(data) { return kendo.stringify(data); }'); $model = new \Kendo\Data\DataSourceSchemaModel(); $model->addField(array('field' => 'Date', 'type' => 'date')); $schema = new \Kendo\Data\DataSourceSchema(); $schema->model($model); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport)->schema($schema)->serverFiltering(true); $navigator = new \Kendo\Dataviz\UI\StockChartNavigator(); $navigator->addSeriesItem(array('type' => 'area', 'field' => 'Close'))->dataSource($dataSource)->select(array('from' => '2009/02/05', 'to' => '2011/10/07')); $chart = new \Kendo\Dataviz\UI\StockChart('stock-chart'); $chart->dataSource($dataSource)->title(array('text' => 'The ACME Company'))->dateField('Date')->addSeriesItem($series)->navigator($navigator); echo $chart->render(); require_once '../include/footer.php';
<?php require_once '../lib/DataSourceResult.php'; require_once '../lib/Kendo/Autoload.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { header('Content-Type: application/json'); $request = json_decode(file_get_contents('php://input')); $result = new DataSourceResult('sqlite:..//sample.db'); echo json_encode($result->read('Products', array('ProductName', 'UnitPrice', 'UnitsInStock'), $request)); exit; } require_once '../include/header.php'; $transport = new \Kendo\Data\DataSourceTransport(); $read = new \Kendo\Data\DataSourceTransportRead(); $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');
<?php require_once 'lib/Kendo/Autoload.php'; include 'header.php'; // --------- Kendo UI DataSource Transport ------- $create = new \Kendo\Data\DataSourceTransportCreate(); $create->url('/api/products/create.php')->contentType('application/json')->type('POST'); $read = new \Kendo\Data\DataSourceTransportRead(); $read->url('/api/products/read.php')->contentType('application/json')->type('POST'); $update = new \Kendo\Data\DataSourceTransportUpdate(); $update->url('/api/products/update.php')->contentType('application/json')->type('PUT'); $destroy = new \Kendo\Data\DataSourceTransportDestroy(); $destroy->url('/api/products/destroy.php')->contentType('application/json')->type('POST'); $transport = new \Kendo\Data\DataSourceTransport(); $transport->create($create)->read($read)->update($update)->destroy($destroy)->parameterMap('function(data) { return kendo.stringify(data); }'); // --------- Kendo UI DataSource Schema ------- $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'); $supplierField = new \Kendo\Data\DataSourceSchemaModelField("Supplier"); $supplierField->defaultValue(new stdClass()); $categoryField = new \Kendo\Data\DataSourceSchemaModelField("Category"); $categoryField->defaultValue(new stdClass()); $model->id("ProductID")->addField($productNameField)->addField($unitPriceField)->addField($unitsInStockField)->addField($supplierField)->addField($categoryField); $schema = new \Kendo\Data\DataSourceSchema(); $schema->data('data')->model($model)->total('total'); // --------- Kendo UI DataSource -------
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; }
<?php require_once '../lib/Kendo/Autoload.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { header('Content-Type: application/json'); $result = json_decode(file_get_contents('../content/dataviz/js/boeing-stock.json')); echo json_encode($result); exit; } require_once '../include/header.php'; $stock = new \Kendo\Dataviz\UI\StockChartSeriesItem(); $stock->type('candlestick')->openField('Open')->highField('High')->lowField('Low')->closeField('Close'); $volume = new \Kendo\Dataviz\UI\StockChartSeriesItem(); $volume->type('column')->field('Volume')->axis('volumeAxis')->tooltip(array('format' => '{0:C0}')); $navigator = new \Kendo\Dataviz\UI\StockChartNavigator(); $navigator->addSeriesItem(array('type' => 'area', 'field' => 'Close'))->select(array('from' => '2009/02/05', 'to' => '2011/10/07')); $transport = new \Kendo\Data\DataSourceTransport(); $transport->read(array('url' => 'panes.php', 'type' => 'POST', 'dataType' => 'json')); $dataSource = new \Kendo\Data\DataSource(); $dataSource->transport($transport); $chart = new \Kendo\Dataviz\UI\StockChart('stock-chart'); $chart->dataSource($dataSource)->title(array('text' => 'The Boeing Company (NYSE:BA)'))->dateField('Date')->addPane(array('title' => 'Value'), array('name' => 'volumePane', 'title' => 'Volume', 'height' => 150))->addCategoryAxisItem(array('pane' => 'volumePane'))->addValueAxisItem(array('line' => array('visible' => false)), array('name' => 'volumeAxis', 'pane' => 'volumePane', 'visible' => false))->addSeriesItem($stock, $volume)->navigator($navigator); echo $chart->render(); ?> <style scoped> .k-chart { height: 500px; } </style> <?php require_once '../include/footer.php';
switch ($type) { case 'categories': $result = $result->read('Categories', array('CategoryID', 'CategoryName'), $request); break; case 'products': $result = $result->read('Products', array('ProductID', 'ProductName', 'CategoryID'), $request); break; case 'orders': $result = $result->read('[Order Details]', array('OrderID', 'ProductID', 'Quantity'), $request); break; } echo json_encode($result); exit; } require_once '../include/header.php'; $transport = new \Kendo\Data\DataSourceTransport(); $read = new \Kendo\Data\DataSourceTransportRead(); $read->url('cascadingdropdownlist.php?type=categories')->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'); ?> <div class="demo-section"> <h2>View Order Details</h2> <p> <label for="categories">Categories:</label> <?php $categories = new \Kendo\UI\DropDownList('categories'); $categories->dataSource(array('transport' => $transport, 'schema' => $schema, 'serverFiltering' => true))->dataTextField('CategoryName')->dataValueField('CategoryID')->attr('style', 'width: 300px')->optionLabel('Select category ...');
<?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';
<div class="chart-wrapper"> <table id="weather" class="weather"> <thead> <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);
<?php require_once '../lib/DataSourceResult.php'; require_once '../lib/Kendo/Autoload.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { header('Content-Type: application/json'); $request = json_decode(file_get_contents('php://input')); $result = new DataSourceResult('sqlite:..//sample.db'); echo json_encode($result->read('Products', array('ProductName', 'UnitPrice', 'UnitsInStock', 'UnitsOnOrder'), $request)); exit; } require_once '../include/header.php'; $transport = new \Kendo\Data\DataSourceTransport(); $read = new \Kendo\Data\DataSourceTransportRead(); $read->url('aggregates.php')->contentType('application/json')->type('POST'); $transport->read($read)->parameterMap('function(data) { return kendo.stringify(data); }'); $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();