Hey,
I'm new to web2py.
I want to update a inputfield with the return value of a function.
when adding a new record to t_cre_customers, i want to lookup in table
t_cre_contractors.
I'm using focusout event to launch.
Passing the argument of field t_cre_customers_f_ctm_no to function
cre_find_contractor()
does not work.
And return the result to the sqlform in field t_cre_customers_f_ctm_cr_atv_cd
neither.
Thanks voor any help.
*db*
########################################
# TABLE : t_cre_contractors
########################################
db.define_table('t_cre_contractors',
Field('f_ctt_no', type='string',
label=T('Contractant number'),length=8),
Field('f_ctt_cr_atv_cd', type='string',
label=T('Credit activity code contractant'),length=8)
)
########################################
# TABLE : t_cre_customers
########################################
db.define_table('t_cre_customers',
Field('f_ctm_no', type='string',
label=T('Contractant number borrower'),length=8),
Field('f_ctm_nm', type='string',
label=T('Name borrower'),length=50),
Field('f_ctm_cr_atv_cd', type='string',
label=T('Credit activity code borrower'),length=8),
auth.signature,
format='%(f_ctm_nm)s'
)
db.t_cre_customers.f_ctm_no.requires=[IS_NOT_EMPTY()]
db.t_cre_customers.f_ctm_nm.requires=[IS_NOT_EMPTY()]
*controler*
# add customer
def cre_customer_add():
form_add_customer = SQLFORM(db.t_cre_customers)
if form_add_customer.process().accepted:
response.flash = 'You have successfully submitted the form'
elif form_add_customer.errors:
response.flash = 'Please check your form for errors'
else:
response.flash = 'Please fill all fields!'
return dict(form_add_customer=form_add_customer)
#find customer in table t_cre_contractors
def cre_find_contractor():
waarde = request.args(0)
response.flash = waarde
return "test"
*view*
{{extend 'layout.html'}}
<h1>Add customer</h1>
<br/>
<br/>
{{=form_add_customer}}
<script>
jQuery(document).ready(function(){
jQuery('#t_cre_customers_f_ctm_cr_atv_cd__row').show();
});
jQuery('#t_cre_customers_f_ctm_no').focusout(function(){
jQuery('#t_cre_customers_f_ctm_cr_atv_cd__row').show();
ajax('{{=URL('default','cre_find_contractor')}}','t_cre_customers_f_ctm_no','t_cre_customers_f_ctm_cr_atv_cd');
});
</script>
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/96c9fe15-b423-4b0a-a6f6-c28e59ce477f%40googlegroups.com.
