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