22 lines
720 B
Plaintext
22 lines
720 B
Plaintext
async def search_user_inquiry_dict(ns={}):
|
|
db = DBPools()
|
|
async with db.sqlorContext('kboss') as sor:
|
|
where_sql = "where status = 1"
|
|
if ns.get('dict_type'):
|
|
where_sql += " and dict_type = '%s'" % ns.get('dict_type')
|
|
search_sql = """
|
|
select id, dict_type, dict_key, dict_value_zh, dict_value_en, sort_order
|
|
from product_inquiry_dict
|
|
%s
|
|
order by dict_type asc, sort_order asc;
|
|
""" % where_sql
|
|
result = await sor.sqlExe(search_sql, {})
|
|
return {
|
|
'status': True,
|
|
'msg': 'search success',
|
|
'data': result
|
|
}
|
|
|
|
ret = await search_user_inquiry_dict(params_kw)
|
|
return ret
|