[web2py] SQLEDITABLE plugin

2014-07-01 Thread 'kato' via web2py-users 
Hi.

I tried to make SQLEDITABLE plugin.

demo-page: http://docs1.erp2py.com/sqleditable/demo/demo_en.html

It is similar as gluon/contrib/spreadsheet. But, it is easy to use more.
If you are interested, please try.

Thanks.

-- 
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.

Re: [web2py] SQLEDITABLE plugin

2014-07-01 Thread Fabiano Almeida 
Very Nice!

Thank you very much!


2014-07-01 10:12 GMT-03:00 'kato' via web2py-users 
:

> Hi.
>
> I tried to make SQLEDITABLE plugin.
>
> demo-page: http://docs1.erp2py.com/sqleditable/demo/demo_en.html
>
> It is similar as gluon/contrib/spreadsheet. But, it is easy to use more.
> If you are interested, please try.
>
> Thanks.
>
> --
> 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.

Re: [web2py] SQLEDITABLE plugin

2014-07-06 Thread Fabiano Almeida 
Hi kato!

How to use SQLEDITABLE with a query?

If I try this in your first example:

query = db.employee_sheet.resigned == True
editable = SQLEDITABLE(query, showid=False, maxrow=5).process()

Return error:


AttributeError: 'Query' object has no attribute '_id'

How to filter table?

Thanks,

Fabiano



2014-07-01 10:12 GMT-03:00 'kato' via web2py-users 
:

> Hi.
>
> I tried to make SQLEDITABLE plugin.
>
> demo-page: http://docs1.erp2py.com/sqleditable/demo/demo_en.html
>
> It is similar as gluon/contrib/spreadsheet. But, it is easy to use more.
> If you are interested, please try.
>
> Thanks.
>
> --
> 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.

Re: [web2py] SQLEDITABLE plugin

2014-07-07 Thread 'kato' via web2py-users 
Hi fabiano.

It is not possible to pass a query currently. 
But "record" parameter is so callable, please set there. 
Please see to the demo5 
 .

thanks.

2014年7月6日日曜日 15時19分04秒 UTC-3 Fabiano Almeida:
>
> Hi kato!
>
> How to use SQLEDITABLE with a query?
>
> If I try this in your first example:
>
> query = db.employee_sheet.resigned == True
> editable = SQLEDITABLE(query, showid=False, maxrow=5).process()
>
> Return error:
>
> AttributeError: 'Query' object has no attribute '_id'
>
> How to filter table?
>
> Thanks,
>
> Fabiano
>
>
>
> 2014-07-01 10:12 GMT-03:00 'kato' via web2py-users <
> web...@googlegroups.com >:
>
>> Hi.
>>
>> I tried to make SQLEDITABLE plugin.
>>
>> demo-page: http://docs1.erp2py.com/sqleditable/demo/demo_en.html
>>
>> It is similar as gluon/contrib/spreadsheet. But, it is easy to use more.
>> If you are interested, please try.
>>
>> Thanks.
>>
>> -- 
>> 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+un...@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.

Re: [web2py] SQLEDITABLE plugin

2014-07-07 Thread kato 
I will add a postscript. you can write as below.

def demo031():
def record():
rows = db(db.employee_sheet.resigned == True).select(limitby=(0,3))
return [row.id for row in rows.sort(lambda row:row.employee_number)]

response.title = 'demo030'
response.view = 'plugin_sqleditable/sample.html'
editable = SQLEDITABLE(db.employee_sheet, record=record(),showid=False,

maxrow=5).process()
return dict(editable=editable)

If you use "primarykey" and multiple key fields, you need to write list of
list in "record" parameter.


2014-07-07 5:51 GMT-03:00 'kato' via web2py-users :

> Hi fabiano.
>
> It is not possible to pass a query currently.
> But "record" parameter is so callable, please set there.
> Please see to the demo5
>  .
>
> thanks.
>
> 2014年7月6日日曜日 15時19分04秒 UTC-3 Fabiano Almeida:
>>
>> Hi kato!
>>
>> How to use SQLEDITABLE with a query?
>>
>> If I try this in your first example:
>>
>> query = db.employee_sheet.resigned == True
>> editable = SQLEDITABLE(query, showid=False, maxrow=5).process()
>>
>> Return error:
>>
>>
>> AttributeError: 'Query' object has no attribute '_id'
>>
>> How to filter table?
>>
>> Thanks,
>>
>> Fabiano
>>
>>
>>
>> 2014-07-01 10:12 GMT-03:00 'kato' via web2py-users <
>> web...@googlegroups.com>:
>>
>>> Hi.
>>>
>>> I tried to make SQLEDITABLE plugin.
>>>
>>> demo-page: http://docs1.erp2py.com/sqleditable/demo/demo_en.html
>>>
>>> It is similar as gluon/contrib/spreadsheet. But, it is easy to use more.
>>> If you are interested, please try.
>>>
>>> Thanks.
>>>
>>> --
>>> 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+un...@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/PQE1JJwv0Bc/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.

Re: [web2py] SQLEDITABLE plugin

2014-07-07 Thread Fabiano Almeida 
Thanks Kato!!!

Now I get it!!


2014-07-07 8:30 GMT-03:00 kato :

> I will add a postscript. you can write as below.
>
> def demo031():
> def record():
> rows = db(db.employee_sheet.resigned == True).select(limitby=(0,3))
> return [row.id for row in rows.sort(lambda
> row:row.employee_number)]
>
> response.title = 'demo030'
> response.view = 'plugin_sqleditable/sample.html'
> editable = SQLEDITABLE(db.employee_sheet,
> record=record(),showid=False,
>
> maxrow=5).process()
> return dict(editable=editable)
>
> If you use "primarykey" and multiple key fields, you need to write list of
> list in "record" parameter.
>
>
> 2014-07-07 5:51 GMT-03:00 'kato' via web2py-users  >:
>
>> Hi fabiano.
>>
>> It is not possible to pass a query currently.
>> But "record" parameter is so callable, please set there.
>> Please see to the demo5
>>  .
>>
>> thanks.
>>
>> 2014年7月6日日曜日 15時19分04秒 UTC-3 Fabiano Almeida:
>>>
>>> Hi kato!
>>>
>>> How to use SQLEDITABLE with a query?
>>>
>>> If I try this in your first example:
>>>
>>> query = db.employee_sheet.resigned == True
>>> editable = SQLEDITABLE(query, showid=False, maxrow=5).process()
>>>
>>> Return error:
>>>
>>>
>>> AttributeError: 'Query' object has no attribute '_id'
>>>
>>> How to filter table?
>>>
>>> Thanks,
>>>
>>> Fabiano
>>>
>>>
>>>
>>> 2014-07-01 10:12 GMT-03:00 'kato' via web2py-users <
>>> web...@googlegroups.com>:
>>>
 Hi.

 I tried to make SQLEDITABLE plugin.

 demo-page: http://docs1.erp2py.com/sqleditable/demo/demo_en.html

 It is similar as gluon/contrib/spreadsheet. But, it is easy to use more.
 If you are interested, please try.

 Thanks.

 --
 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+un...@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/PQE1JJwv0Bc/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.