@Maurice
This code is working good. you can check here
<http://13.127.38.120/PayUmoney/default/test#>.
It would be easy to inspect the problem if you can show your controller
code what you have written.
Thanks
On Fri, Dec 21, 2018 at 1:55 PM Maurice Waka <mauricew...@gmail.com> wrote:
> Hello Sandeep,
> The form appears well, but the chart area doesn't show any chart, looks a
> small box at the top left side of the page.
> Trying to show it shows a message: 'insufficient privileges'.
> Regards
>
> On Fri, Dec 21, 2018 at 9:58 AM sandeep patel <patelsandeep...@gmail.com>
> wrote:
>
>> You can achieve this way.
>> Controller.py
>> import pygal
>> def chart():
>>
>> response.files.append(URL('default','static/js/pygal-tooltips.min.js'))
>> response.headers['Content-Type']='image/svg+xml'
>> import pygal
>> from pygal.style import Style
>>
>> custom_style = Style(
>> background='transparent',
>> plot_background='transparent',
>> foreground='#53E89B',
>> foreground_strong='#53A0E8',
>> foreground_subtle='#630C0D',
>> opacity='.6',
>> opacity_hover='.9',
>> transition='400ms ease-in',
>> colors=('#E853A0', '#E8537A', '#E95355', '#E87653', '#E89B53')
>> )
>>
>> chart = pygal.StackedLine(fill=True, interpolate='cubic',
>> style=custom_style, )
>>
>> * data = db(db. my_tracker).select() chart.add('A', [i.weight for i
>> in data])*
>> return chart.render()
>>
>> def index():
>> chart= URL('default', 'chart')
>> form = SQLFORM(db.my_tracker, submit_button=T('Submit')).process()
>> form.element('input[name=weight]')['_style']='width:60px;height:30px;'
>> return dict(chart = chart,form=form)
>>
>> #View/index.html
>>
>> {{extend 'layout.html'}}
>> <figure>
>> <embed type="image/svg+xml" src="{{=chart}}" />
>> </figure>
>>
>> <h1>{{=form}}</h1>
>>
>> You can change style according to your convenience
>>
>>
>> Thanks
>> SP
>>
>>
>>
>> On Fri, Dec 21, 2018 at 7:23 AM Maurice Waka <mauricew...@gmail.com>
>> wrote:
>>
>>> I've come across this
>>> <http://www.web2pyslices.com/slice/show/1634/beauty-graphics-and-charts-with-pygal-updated>
>>> site
>>> where one can create charts and graphs.
>>> However I have a challenge of using the database as I don't know how to
>>> link to it. For example, i want to track a variable like weight. The user
>>> inputs the values on a regular basis with the trend showing on the graph.
>>> How do I connect to the database and track it daily?
>>> So far, my code is this:
>>> model
>>> db.define_table('my_tracker',
>>> Field('weight','double',),
>>> Field('created_by','reference auth_user',default = auth.
>>> user_id, readable = False, writable = False))
>>>
>>> Controller:
>>> row = db(db.tracker.created_by == auth.user_id).select().first()
>>> if not row:
>>> form = SQLFORM(db.my_tracker, submit_button=T('Submit'))
>>> form.element('input[name=weight]')['_style']=
>>> 'width:60px;height:30px;'
>>>
>>> --
>>> 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.
>>>
>> --
>> 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 a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/web2py/dGkepqrPY0g/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
> --
> 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.
>
--
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.
