Hello Team,
I am also facing the same problem, where I wish to transfer 'Date'
value (fetched from DB) in PHP, to "DataTable".
I could not find any way so as to do this.
Based on your questions below, here are my replies (in my case).
a. Using DataTable, and not Query
b. Using XHR
c. Passing Date from PHP as string works fine, but further usage of
Data type value is not longer possible
d. Here is code excerpt, where prob exists.
//Initial custom XHR
function trxImport (UI) {
var url = "/wms/php/getData.php"
_getData(url, handleResp, UI);
}
//AJAX Obj and Call
function _getData(url, resp_Handle, UI_handle) {
var request = _getHTTPObject(); //NOTE: Object creation avoid for
length in forum
if (request) {
request.onreadystatechange = function() {resp_Handle (request,
UI_handle)};
request.open( "GET", url, true );
request.setRequestHeader("If-Modified-Since", "Sat, 1 Jan 1900
00:00:00 GMT");
request.send(null);
return true;
} else {
return false;
}
}
//Visualization Datatable
function drawVisualization(resp, UI) {
var JSONObject = (new Function("return " + resp))() ;
var data = new
google.visualization.DataTable(JSONObject, 0.5);
// Create and draw the visualization.
var table = new
google.visualization.Table(document.getElementById(UI));
table.draw(data, {'allowHtml':
true,'page':'enable','width':'4800px'});
.....
PHP Code -- tried several ways to pass the Date DB value
elseif ($fields[$index]->type == 'date') {
//Sample Date = 2010-06-28
//$dt = date_parse ($field);
//echo "{\"v\": \"new Date (", $dt['year'],
",", $dt['month'],
",", $dt['day'], ")\"}";
$dt = strtotime ($field);
echo "{\"v\": \"\/new Date($dt)\/\"}";
Non of these form (though valid JSON), is acceptable to DataTable
I am open to give the exact code both for Page as well as PHP, if
required, please provide specific ID to mail those pages.
Appreciate, any work-around also for handling the scenario.
I am basic-to-intermediate level programmer, and could not follow the
suggestion in the previous update, it would be good to know exact
regex used above.
Thanks, Piyush
On May 12, 4:11 pm, MC Get Vizzy <[email protected]> wrote:
> I'll have a look at this. It sounds like a bug, but it might be tricky to
> track down and fix. Are you using the Query class, or just DataTable? Are
> you using script injection or XHR? Have you tried passing the JSON as a
> string to the DataTable constructor? Can you send me a sample of your
> client-side code?
>
> thanks,
>
> MC Get Vizzy
>
>
>
>
>
>
>
> On Tue, May 10, 2011 at 5:41 AM, Teliac <[email protected]> wrote:
> > Thank you for the thoughts. I had read that, and attempted to send a
> > string in that format. However, when the column is set to type
> > "string", the string displays as received -> Date(2011,0,1). When
> > cloumn type is set to "date", the graph will not display. I am not
> > sure why it is not interpreted as a date (per the GV documentation),
> > though I assume it may have to do with either the PHP json formatting
> > or (relatedly) the quotation marks which surround each json element
> > when encoded.
>
> > The workaround I settled on (though it is far from elegant) is to
> > deliver the information as a string in javascript date notation form
> > ("new Date(2011,0,1)"). In the javascript callback function, I then
> > do a global replace (removal) of the quotation marks and eval the
> > remaining json variable. This reads the date string as a javascript
> > native Date declaration and works correctly.
>
> > This approach is less than ideal because it requires special handling
> > for other variables in the json-encoded PHP response as well.
>
> > Please let me know if you have other suggestions, or thoughts on why
> > the GV documented solution you refer to is not working for me.
>
> > On May 8, 7:29 am, MC Get Vizzy <[email protected]> wrote:
> > > You can send a date with a string of the format "Date(y,m,d)". For
> > > example, "Date(2011,0,1)" would be January first, 2011. This is
> > addressed
> > > here:
>
> > >http://code.google.com/apis/chart/interactive/docs/dev/implementing_d...
>
> > > <http://code.google.com/apis/chart/interactive/docs/dev/implementing_d..
> > .>Though
> > > I admit it's kind of buried.
>
> > > On Fri, May 6, 2011 at 4:15 AM, Teliac <[email protected]> wrote:
> > > > I have a question involving a PHP script that created a json-encoded
> > > > array and returns it to the client (where it is used to create a
> > > > DataTable object).
>
> > > > Is there a way to pass a date value from a php server-side script to
> > > > the client side GV JavaScript such that it is recognized by the
> > > > DataTable object as a 'date' type?
>
> > > > Some details:
> > > > The php script creates a json encoded array that is requested from
> > > > (and returned to) the client via a jQuery ajax call. The code looks
> > > > like this:
>
> > > > ----------
> > > > // DataTable object.
> > > > $dt = array();
>
> > > > // Column information
> > > > $col_ids = array("DATE","EU");
> > > > $col_labels = array("Date","Equity Utilization");
> > > > $col_types = array("string","number"); // <- Would like to pass as
> > > > "date" rather than "string"
>
> > > > // Populate DataTable object with column information.
> > > > for ($y = 0; $y < count($col_ids); $y++) {
> > > > $dt["cols"][$y]["id"] = $col_ids[$y];
> > > > $dt["cols"][$y]["label"] = $col_labels[$y];
> > > > $dt["cols"][$y]["type"] = $col_types[$y];
> > > > }
>
> > > > // Get data from csv file and populate DataTable rows.
> > > > $rc = 0;
> > > > if (($handle = fopen($csvFile, "r")) !== FALSE) {
> > > > while (($data = fgetcsv($handle)) !== FALSE) {
>
> > > > // We only need two pieces of data here:
> > > > // Date (data[0])
> > > > // EU (data[7])
> > > > // Add data values to $dt array.
> > > > $d = $data[0];
>
> > > > // $d is the date as a string, would like it to be interpreted
> > > > as
> > > > // type 'date' when read in by DataTable call on client.
> > > > // Is it possible to parse it here, or otherwise format the
> > > > string to
> > > > // be interpreted as type 'date' by GV on client?
> > > > $dt["rows"][$rc]["c"][0]["v"] = $d;
>
> > > > // Format data value as float - necessary for GV to recognize
> > > > as number.
> > > > $d = $data[7];
> > > > $d = floatval($d);
> > > > $dt["rows"][$rc]["c"][1]["v"] = $d;
> > > > $rc++;
> > > > }
> > > > fclose($handle);
> > > > }
>
> > > > // Send information back to client via encoded json
> > > > echo json_encode($dt);
> > > > ---------
>
> > > > The above code works as long as I pass the date with column type
> > > > 'string' (would like column type to be 'date'.
>
> > > > Thanks in advance for your input.
>
> > > > --
> > > > You received this message because you are subscribed to the Google
> > Groups
> > > > "Google Visualization API" group.
> > > > To post to this group, send email to
> > > > [email protected].
> > > > To unsubscribe from this group, send email to
> > > > [email protected].
> > > > For more options, visit this group at
> > > >http://groups.google.com/group/google-visualization-api?hl=en.
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Google Visualization API" group.
> > To post to this group, send email to
> > [email protected].
> > To unsubscribe from this group, send email to
> > [email protected].
> > For more options, visit this group at
> >http://groups.google.com/group/google-visualization-api?hl=en.
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
