import jingrow


@jingrow.whitelist()
def get_users():
	users = jingrow.qb.get_query(
		"User",
		fields=[
			"name",
			"email",
			"enabled",
			"user_image",
			"first_name",
			"last_name",
			"full_name",
			"user_type",
		],
		order_by="full_name asc",
		distinct=True,
	).run(as_dict=1)

	for user in users:
		if jingrow.session.user == user.name:
			user.session_user = True

		user.roles = jingrow.get_roles(user.name)

		user.role = ""

		if "System Manager" in user.roles:
			user.role = "System Manager"
		elif "Sales Manager" in user.roles:
			user.role = "Sales Manager"
		elif "Sales User" in user.roles:
			user.role = "Sales User"
		elif "Guest" in user.roles:
			user.role = "Guest"

		if jingrow.session.user == user.name:
			user.session_user = True

		user.is_telephony_agent = jingrow.db.exists("CRM Telephony Agent", {"user": user.name})

	crm_users = []

	# crm users are users with role Sales User or Sales Manager
	for user in users:
		if "Sales User" in user.roles or "Sales Manager" in user.roles:
			crm_users.append(user)

	return users, crm_users


@jingrow.whitelist()
def get_organizations():
	organizations = jingrow.qb.get_query(
		"CRM Organization",
		fields=["*"],
		order_by="name asc",
		distinct=True,
	).run(as_dict=1)

	return organizations