i have 2 function in controler/vnstoragedoc.py def check(type1,type2,type3): query1 = db.archives.symbol.like('%'+request.vars.txtSoKyHieu+'%') query2 = db.archives.key.like('%'+request.vars.txtTuKhoa+'%') query3 = db.archives.archives_type == db.archives_type.id query4 = db.archives.time.year() >= request.vars.txtTuNam query5 = db.archives.time.year() <= request.vars.txtDenNam query6 = db.archives_type.id == type1 query7 = db.organization.id == type2 query8 = db.author.id == type3 query9 = db.archives.organization == db.organization.id query10 = db.archives.author == db.author.id if (type1 == 0)& (type2 == 0) & (type3 == 0): query = query1 & query2 & query3 & query4 & query5 if (type1 != 0)& (type2 == 0) & (type3 == 0): query = query1 & query2 & query3 & query4 & query5 & query6 if (type1 == 0)& (type2 != 0) & (type3 == 0): query = query1 & query2 & query3 & query4 & query5 & query7 & query9 if (type1 == 0)& (type2 == 0) & (type3 != 0): query = query1 & query2 & query3 & query4 & query5 & query8 & query10 if (type1 != 0)& (type2 != 0) & (type3 != 0): query = query1 & query2 & query3 & query4 & query5 & query6 & query7 & query8 & query9 & query10 return dict(query=query)
i want to call check() function in to the adv_searh() funtion because i want query object .how to i do it who cant heple me! thank def adv_search_(): rows=None query=None if request.vars.txtSoKyHieu: if request.vars.slTangGiam == '0': if request.vars.slSapXep =='tg_TaiLieu': check(request.vars.slLoaiTaiLieu ,request.vars.CoQuanBanHanh ,request.vars.slNguoiKy) rows = db(query).select(orderby= ~db.archives.time)