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)

Reply via email to