Questions on Kendo UI for jQuery Forum

14 answers

4.2K+ views

I am setting up a page using MySQL/PHP on the back end, and using a DataSource + Kendo Grid for display. Having odd issues with date fields I was hoping someone could shed some light on.

I have my transport set up like this:

transport: {
read: {
url: "services/crud/tbl-read.php",
dataType: "JSON"
},
create: {
url: "services/crud/tbl-add.php",
type: "POST"
},
update: {
url: "services/crud/tbl-edit.php",
type: "POST"
} ,
...
and the schema/model setup like this:

datefld : { editable: true, type: "date"},

and I have my Grid column display setup like this (using date format to match):

columns:[
{ field: "tbl_id", title: "ID", width: "50px" },
...
{ field: "datefld", title:"My Date Field", format: "{0:yyyy-MM-dd}" },

...

This retrieves and displays the date field properly. Grid also shows the built in date picker and so forth.

Where I run into trouble is when I ADD or EDIT. On an Add, the request sent to my PHP script DOES NOT include a value pair for "datefld" (!!??!!). I get value pairs for all the other (non-date) fields, not the date field. Similarly on an EDIT, if I edit the date (using the grid's supplied date picker) the PHP request does not include the value pair for the date field. Oddly enough, if I edit the record in the grid BUT only change one of the other (string) fields, I DO GET a value pair for the date field (I am assuming since it was untouched by the edit). As a test, I toggled the schema TYPE clause from "date" to "string" and everything works as it should (data displays, value pairs are included, but I obviously don't get a date picker in the grid).

A further issue with this setup is that built in grid filtering does not work. If I attempt to filter on the date field (with TYPE set to "date") I am unable to get the filter to apply - I get a spinning wait/progress/hourglass deal. Obviously with type set to string I can filter, but not as a date as desired.

My best guess is that Kendu does not like the date format, but I have found limited information in the forums and documentation about date formats (and none relating to MySQL, PHP and CRUD).

Anyone have similar issues? Anyone getting datefields to work properly with MySQL/PHP/CRUD?

Data Source

answered on 03 Jan 2013

6 answers

228 views

iPad: Button / element clicks ignored after series hover event

When DataViz charts are displayed on an iOS device, tooltips are shown on first touch of a series. The series click event is then fired on second touch.

From what I can work out, it appears that this is achieved by handling the touchEnd event and invoking event.preventDefault() to stop the click event happening, which then allows the tooltip to be shown to the user. Unfortunately, there seems to be a bug in the implementation, as once a tooltip has been displayed, any clicks to any elements on the page (even outside the chartarea) are prevented.

Has anybody found any simple workaround for this issue? I tried handling touchStart and then firing a click event against the target element (i.e. so the browser thinks it's a click event rather than a touch event, thereby bypassing touchEnd), but this causes bugs elsewhere (e.g. 'pseudo' double clicks on dropdowns causing them to open then immediately close). Beyond that, I'm running out of ideas...!

Charts

answered on 03 Jan 2013

2 answers

125 views

Grid columnResize and columnReorder events not working in Firefox

Hi,
I am a Kendo User i was trying out the above events and in Firefox those events are firing after doing something on the page like minimizing the Firefox . at times this fires but not always Please give some feed back why this is happening. i also have attached a Fiddler example. Run this on Firefox please.

Fiddler Example

Grid

answered on 03 Jan 2013

8 answers

208 views

MVVM & KendoUI widget's _old value.

Hi
I'm use mvvm model to bind kendo ui widget's value.
and i find if set kendo ui widget's value by mvvm model then widget's _old wasn't change.
so when input the same value again, then wasn't trigger widget's change and so mvvm model's value wasn't change too.
i create a jsfiddle to display this problem.
http://jsfiddle.net/ray521/4v57S/

MVVM

answered on 03 Jan 2013

1 answer

137 views

[Solved] Web Page Grid Not Populating From SQL Server DB

I've tried some of the examples with no success. Here is my code for "manageDonor.cshmtl" and output.
Code files are attached.
Using Chrome. a very nice grid appears on the page, but it has only a single empty line saying "No items to display" Chrome not showing any script errors.
Thanks

@{

var dbRenewal = Database.Open("RenewalDataConnection");

var sql = "SELECT donorID, title, firstname, middlename, lastname, address, city, state ,zipcode, homephone, workphone, cellphone, email FROM donor";

var data = dbRenewal.Query(sql);

var json = Json.Encode(data);

Response.Write(json);

}     




[{"donorID":152,"title":"title","firstname":"firstname","middlename":"Middlename","lastname":"lastname","address":"100 Main Street","city":"Los Angeles","state":"CA","zipcode":"90067","homephone":"3105528809","workphone":"3105528809","cellphone":"3105528809","email":null},{"donorID":157,"title":"Rabbi","firstname":"Yehuda","middlename":"Lein","lastname":"Smith","address":"100 Main Street","city":"Los Angeles","state":"CA","zipcode":"91678","homephone":"3105528809","workphone":"3105528809","cellphone":"3105528809","email":null}]

Grid

answered on 03 Jan 2013

3 answers

310 views

Progress bar is not visible in IE and Firefox

Hi,

I am using Kendo UI file upload control in async mode and AutoUpload set to false.

When i click the upload button, the progress bar for each of these files is not shown in IE and Fire fox.

I observed this issue in IE 9 and Firefox (13.0.1). in Chrome it is working fine. I have verified in the DOM by debugging. There is no span element for the progress bar in the tree.

What is the issue here ?

Upload

answered on 03 Jan 2013

1 answer

589 views

perform action on kendo window custom button click

Hello,

by using the below code i am trying to open the kendo window on button click this is working fine.
function OpenWindow() {
        var dialog = $("#window-prototype").clone().kendoWindow({
            width: "500px",
            height: "280px",
            modal: false,
            resizable: true,
            actions: ["Custom", "Minimize", "Maximize", "Close"],
            title: "OrderEntry"
        }).show().data("kendoWindow").open().center();

my requirement is i need to perform some action on custom button click on kendo window.So I added event in the javascript function

function OpenOrderEntry() {
            var dialog = $("#window-prototype").kendoWindow({
            width: "500px",
            height: "280px",
            modal: false,
            resizable: true,
            actions: ["Custom", "Minimize", "Maximize", "Close"],
            title: "OrderEntry"
        }).data("kendoWindow").wrapper.find(".k-custom").click(function (e) {
            alert("Custom action button clicked");
            e.preventDefault();
        });
        dialog.data("kendoWindow").open();   <== Error
    }

but it is throwing the below given error "Microsoft JScript runtime error: 'data(...)' is null or not an object".

Regards,
Ravi

Window

answered on 02 Jan 2013

12 answers

487 views

Hyperlinks with data-rel="external" not working on iOS

This example works perfect with chrome http://www.grapto.com/mobile/publication/65 but if you test it with an iOS device the link seems to start loading but it stops without doing anything.

General Discussions

answered on 02 Jan 2013

2 answers

313 views

How to scroll listview to top?

I feel stupid that I have to ask a similar question to my earlier question here, but I hope someone can help. I have wasted valuable family time to get this working. I even had no success making a jsbin example for it (kendo ui seems not to be applied to the style): http://jsbin.com/amijij/2/edit

Edit: I found a jsfiddle with which I can demonstrate what is happening here: http://jsfiddle.net/NuyuV/2/

My app consist of 2 pages (Kendo UI mobile views). The first view shows a listview with categories. When a user clicks an item in the list, a listview on the 2nd page is being populated with items in the selected category and then the 2nd page is shown (through an app.navigate). So far this is working well.

However, when the user has arrived on the 2nd page and follows these steps (follow the steps in this fiddle):
- scroll down
- go back to first page with categories
- click the same category again

Then the listview is populated again, but not showing the first item, but the item that was visible when he left the 2nd page. If don't click the same category, but one with just enough items so that scrolling is not possible then you don't even see the items on the page.

I would be happy to post more information if needed!

Thank you in advance

General Discussions

answered on 02 Jan 2013

1 answer

195 views

Switch cursor to pointer cursor when hovering over the bars in bar chart.

I have a bar chart for which I wish to show the pointer (hand) cursor when hovering over the bars on the chart. When moving off the bars in the chart the cursor should return to the standard arrow pointer. I noticed that the cursor turned into the text cursor when hovering over the axis labels (left, right, and bottom) and on the legend. So in addition to the above I would like the cursor to remain the standard cursor (arrow) when hovering over the axis labels and legend (since you cannot edit these). I would also like the cursor to switch to the pointer cursor when hovering over the x-axis (bottom) labels.

I can easily show a pointer cursor for the entire chart when hovering anywhere over the chart but that is NOT desired.

I have tried various strategies using the seriesHover event but so far nothing has worked.

How do I achieve the above?

Thanks,

Addie

PS -- The reason for showing the pointer cursor for the bars and the x-axis label is to clue the user in that he can click on this area to show and additional "driill-down" chart when the particular bar or x-axis label is clicked. If there is an alternative way to clue the user in then that may be acceptable as well.

Charts

answered on 02 Jan 2013