21 lines
879 B
Plaintext
21 lines
879 B
Plaintext
async def getNoinvitationcode(ns):
|
|
"""展示所有没有销售的客户"""
|
|
db = DBPools()
|
|
async with db.sqlorContext('kboss') as sor:
|
|
orgs = await sor.R('organization', {"org_type": '0'})
|
|
ns['del_flg'] = '0'
|
|
ns['sort'] = 'create_at desc'
|
|
ns['parentid'] = orgs[0]['id']
|
|
datalist = []
|
|
prc = await sor.R('customer', {'del_flg': '0'})
|
|
for i in prc:
|
|
if not i['salemanid']:
|
|
customer_id_parentid_li = await sor.R('organization', {'id': i['customerid']})
|
|
customer_id_parentid = customer_id_parentid_li[0]['parentid']
|
|
if customer_id_parentid == ns.get('orgid'):
|
|
datalist.append(customer_id_parentid_li[0])
|
|
data = {'rows':datalist}
|
|
return {'status': True, 'data': data}
|
|
|
|
ret = await getNoinvitationcode(params_kw)
|
|
return ret |