21309 Posts in 5738 Topics by 2603 members
| Go to End | Next > | |
| Author | Topic: | 3351 Views |
-
Re: JQUERY JTABLE
2 January 2012 at 11:33pm
Thanks for your reply and helpfull info. If it works, I'll let you know.
-
Re: JQUERY JTABLE
3 January 2012 at 2:35am
I mapped the expected fields to the fields of the People table:
fields: {
PersonId: {
key: true,
create: false,
edit: false,
list: false
},
Name: {
title: 'Author Name',
width: '40%'
},
Age: {
title: 'Age',
width: '20%'
},
RecordDate: {
list: false,
create: false,
edit: false
}
JTableExampleID: {
list: false,
create: false,
edit: false
}
ID: {
list: false,
create: false,
edit: false
}The result that JTable expects should look like this :
---------------------------------------------------------------------------------------------------------
function showdata(){
$myset = DataObject::get('People');
$myArray = $myset->toArray();
if ($myArray){
$json = '{Result: "OK", Records : $myArray }';
}
else{
$json = '{Result: "ERROR", Message : "error occured" }';
}
return $json;
}
------------------------------------------------------------------------------------------------------------
This controller should be called from within the customscript by defining:actions: {
listAction: 'http://localhost/silverstripe/new-jtableexample/showdata'
}
But helas, jumping from the customscript to the controllerfunction showdata() doesn't work. -
Re: JQUERY JTABLE
3 January 2012 at 3:26am
showdata is not returning valid JSON.
I don't know what browser you're using but you need some kind of tool so you can watch the AJAX request that jTable does when it loads the records. That way you can check if the correct URL is being called, otherwise you're never going to be able to troubleshoot this properly. If you're using FireFox you can install Firebug and watch the AJAX requests from the console.$myArray is an array of objects so running json_encode() on it won't work either I think, that's why you have to use JSONDataFormatter.
$json = '{Result: "OK", Records : $myArray }';
I'm not sure how long you've been coding PHP but when you're using ' as a string delimiter variables aren't evaluated but are treated as literal strings so you're actually sending back exactly the text you have there.
A much better way of treating your data is to do this instead:if ($myArray){
$json = $json = array("Result" => "OK", "Records" => $myArray);
}
else{
$json = array("Result" => "ERROR", "Message" => "error occured");
}
return json_encode($json);But like I said before, json_encode doesn't work on objects and $myArray is an array of objects.
-
Re: JQUERY JTABLE
3 January 2012 at 4:25am
Thanks.
Concerning PHP : forced to learn it since 2 months. History of 12 y of Java, Java EE and .Net (C#).
New needs pushed me to investigate PHP + Joomla (drop after 1 week), PHP + Zend (very robust but no ready to go platform for web solutions) and finally discovered by hasard something called Silverstripe. Nobody in my environment has heard of it. But it fascinates me. Has also some drawbacks for my needs (concerning ORM) but no platform is a 100% hit for a specific besoin.PHP is so difficult for me since I feel very,very uncomfortable with the weak typing ...I'm Java-drilled...
Thanks for your help.
-
Re: JQUERY JTABLE
5 January 2012 at 4:43am
In the context of getting this JTable plugin at work, I still have a persistent problem with the mutation of the DataObjectSet
into an array with the method toArray(). I have a DataObject called People with properties : PersonId, Name, Age, RecordDate.
From the controller, I want to retrieve all the records in People into a DataObjectSet using $result = DataObject::get('People');Then, I need to make an array of it. If I use the method toArray(), I have following result:
[{"destroyed":false,"class":"People"},{"destroyed":false,"class":"People"}]
This is not what I need. I would need the following format :
[ {"PersonId":1,"Name":"Benjamin Button","Age":17,"RecordDate":"\/Date(1320259705710)\/"}, {"PersonId":2,"Name":"Douglas Adams","Age":42,"RecordDate":"\/Date(1320259705710)\/"}, {"PersonId":3,"Name":"Isaac Asimov","Age":26,"RecordDate":"\/Date(1320259705710)\/"}, {"PersonId":4,"Name":"Thomas More","Age":65,"RecordDate":"\/Date(1320259705710)\/"} ]
So, toArray() method misled me. How do I get to the needed format ?
-
Re: JQUERY JTABLE
6 January 2012 at 3:25am
So like I talked about before toArray() just gives you an array of objects which isn't what you need.
I haven't seen your people class but I'm going to assume that the fields you need in the JSON exist on the dataobject.
With that in mind, I'd do something like this:function showdata(){
$myset = DataObject::get('People');
$jsonArray = array();
foreach ($myset as $person) {
$jsonArray[] = array(
"PersonId" => $person->PersonId,
"Name" => $person->Name,
"Age" => $person->Age,
"RecordDate" => $person->RecordDate
);
}
if (count($jsonArray) > 0){
$json = array("Result" => "OK", "Records" => $jsonArray);
}
else {
$json = array("Result" => "ERROR", "Message" => "error occured");
}
return json_encode($json);
} -
Re: JQUERY JTABLE
6 January 2012 at 8:53pm
Thanks for your cristal input. JSON return is now what JTable's expecting.
But it still doesn't work, and when I launch it by FireFox with FireBug on it, it gives the error : JQUERY not defined.
I tried for several hours to look where this error could be originated.
All the JS (JQUERY) and CSS are in place.
But this error remains.
Screenshots in att.Attached Files-
controller.jpg
106 KB -
firebug1.jpg
104 KB -
firebug2.jpg
164 KB -
folderfiles.jpg
92 KB
-
-
Re: JQUERY JTABLE
7 January 2012 at 12:03am
Does loading jquery.table after the main jquery/jquery-ui library (in your controller) help?
| 3351 Views | ||
| Go to Top | Next > |
