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)
