ns = params_kw.copy()
for k,v in ns.items():
	if v == 'NaN' or v == 'null':
		ns[k] = None


userorgid = await get_userorgid()
if not userorgid:
	return {
		"widgettype":"Error",
		"options":{
			"title":"Authorization Error",
			"timeout":3,
			"cwidth":16,
			"cheight":9,
			"message":"Please login"
		}
	}
ns['resellerid'] = userorgid



db = DBPools()
dbname = get_module_dbname('supplychain')
async with db.sqlorContext(dbname) as sor:

	ns1 = {

		"resellerid": userorgid,


		"id": params_kw.id
	}
	recs = await sor.R('distribution_agreements', ns1)
	if len(recs) < 1:
		return {
			"widgettype":"Error",
			"options":{
				"title":"Update Error",
				"cwidth":16,
				"cheight":9,
				"timeout":3,
				"message":"Record no exist or with wrong ownership"
			}
		}

	r = await sor.U('distribution_agreements', ns)
	debug('update success');
	return {
		"widgettype":"Message",
		"options":{
			"title":"Update Success",
			"cwidth":16,
			"cheight":9,
			"timeout":3,
			"message":"ok"
		} 
	}
		
return {
	"widgettype":"Error",
	"options":{
		"title":"Update Error",
		"cwidth":16,
		"cheight":9,
		"timeout":3,
		"message":"failed"
	}
}