Hello im trying to add a line chart using this example but in the view i
see the json output instead of a graph.
Any help?
VIEW
{{extend 'layout.html'}}
<html>
<script src="https://code.highcharts.com/stock/highstock.js";></script>
<script src="https://code.highcharts.com/stock/modules/exporting.js";></script>
<div id="chart"></div>
<script type="application/javascript">
$.getJSON('http://127.0.0.1:8000/test/default/call/json/mystats', function
(data) {
// pie subscription
$('#pie_subscription').highcharts({
series: [{
type: 'line',
name: '{{=T('Subscription') }} ',
data: [
{{for row_pie_subscription in rows:}}
['{{=T(row_pie_subscription.created_on) }}',
{{=row_pie_subscription.qty}} ],
{{pass}}
]
}],
});
});
</script>
</html>
CONTROLLER
@service.json
def mystats():
ownstats = db(db.water_flow_log.meter ==
auth.user.username).select(db.water_flow_log.ALL,orderby=~db.water_flow_log.date_made)
rows = db(db.water_flow_log.meter ==
auth.user.username).select(db.water_flow_log.ALL,orderby=~db.water_flow_log.date_made)
return response.json([[r.created_on, r.qty] for r in rows])
OUTPUT ON VIEW
[["2017-02-24 14:32:20", 275.0], ["2017-02-24 10:52:50", 272.0], ["2017-02-24
10:32:57", 270.0]]
On Friday, October 7, 2016 at 8:52:18 PM UTC+2, 黄祥 wrote:
>
> it's work as expected, thank you so much marlysson
> e.g.
> import gluon.contrib.simplejson
>
> def test():
> chosen = request.args(0)
> query = (db.account.investor == chosen)
> rows = db(query).select(orderby = ~db.account.id)
> return gluon.contrib.simplejson.dumps([[r.product.name,
> r.subscription_amount] for r in rows] )
>
> thanks and best regards,
> stifan
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
