def change_password(arg):
    """
		Change password
	"""
    arg = load_json(arg)

    if not webnotes.conn.sql(
        "select name from tabProfile where name=%s and password=password(%s)",
        (webnotes.session["user"], arg["old_password"]),
    ):
        webnotes.msgprint("Old password is not correct", raise_exception=1)

    if cint(webnotes.conn.get_value("Control Panel", None, "sync_with_gateway")):
        import server_tools.gateway_utils

        webnotes.msgprint(
            server_tools.gateway_utils.change_password(arg["old_password"], arg["new_password"])["message"]
        )

    from webnotes.utils import nowdate

    webnotes.conn.sql(
        "update tabProfile set password=password(%s), modified=%s where name=%s",
        (arg["new_password"], nowdate(), webnotes.session["user"]),
    )
    webnotes.msgprint("Password Updated")

    def get_customer_address(self, args):
        args = load_json(args)
        ret = {"customer_address": args["address"], "address_display": get_address_display(args["address"])}
        if args.get("contact"):
            ret.update(map_party_contact_details(args["contact"]))

        return ret

def post_comment(arg):
	arg = load_json(arg)
	
	from webnotes.model.doc import Document
	d = Document('Comment Widget Record')
	d.comment_doctype = 'My Company'
	d.comment_docname = arg['uid'] # to
	d.owner = webnotes.user.name
	d.comment = arg['comment']
	d.save(1)
	
	if cint(arg['notify']):
		fn = webnotes.conn.sql('select first_name, last_name from tabProfile where name=%s', webnotes.user.name)[0]
		if fn[0] or f[1]:
			fn = cstr(fn[0]) + (fn[0] and ' ' or '') + cstr(fn[1])
		else:
			fn = webnotes.user.name

		from webnotes.utils.email_lib import sendmail
		from setup.doctype.notification_control.notification_control import get_formatted_message
		
		message = '''A new comment has been posted on your page by %s:
		
		<b>Comment:</b> %s
		
		To answer, please login to your erpnext account!
		''' % (fn, arg['comment'])
		
		sendmail([arg['uid']], webnotes.user.name, get_formatted_message('New Comment', message), fn + ' has posted a new comment')

def delete(arg):
	"""
		delete a question or answer (called from kb toolbar)
	"""
	args = load_json(arg)
	from webnotes.model import delete_doc
	delete_doc(args['dt'], args['dn'])

 def get_contact_number(self, arg):
     "returns mobile number of the contact"
     args = load_json(arg)
     number = sql(
         "select mobile_no, phone from tabContact where name=%s and %s=%s" % ("%s", args["key"], "%s"),
         (args["contact_name"], args["value"]),
     )
     return number and (number[0][0] or number[0][1]) or ""

	def get_supplier_address(self, args):
		args = load_json(args)
		ret = {
			'supplier_address' : args['address'],
			'address_display' : get_address_display(args["address"]),
		}
		ret.update(map_party_contact_details(contact_name=args['contact']))
		return ret

def set_user_details(arg=None):
	"updates user details given in argument"
	from webnotes.model.doc import Document
	
	p = Document('Profile', webnotes.user.name)
	p.fields.update(load_json(arg))
	p.save()
	webnotes.msgprint('Updated')

    def get_default_supplier_address(self, args):
        if isinstance(args, basestring):
            args = load_json(args)

        address_name = get_default_address("supplier", args["supplier"])
        ret = {"supplier_address": address_name, "address_display": get_address_display(address_name)}
        ret.update(map_party_contact_details(None, "supplier", args["supplier"]))
        ret.update(self.get_supplier_details(args["supplier"]))
        return ret

	def get_supplier_address(self, args):
		args = load_json(args)
		address_text, address_name = self.get_address_text(address_name=args['address'])
		ret = {
			'supplier_address' : address_name,
			'address_display' : address_text,
		}
		ret.update(self.get_contact_text(contact_name=args['contact']))
		return ret

	def get_customer_address(self, args):
		args = load_json(args)		
		ret = {
			'customer_address' : args["address"],
			'address_display' : get_address_display(args["address"]),
		}
		if args.get('contact'):
			ret.update(map_party_contact_details(args['contact']))
		
		return ret

	def get_default_supplier_address(self, args):
		args = load_json(args)
		address_text, address_name = self.get_address_text(supplier=args['supplier'])
		ret = {
			'supplier_address' : address_name,
			'address_display' : address_text,
		}
		ret.update(self.get_contact_text(supplier=args['supplier']))
		ret.update(self.get_supplier_details(args['supplier']))
		return ret

def add_answer(arg):
	arg = load_json(arg)
	
	from webnotes.model.doc import Document
	a = Document('Answer')
	a.answer = arg['answer']
	a.question = arg['qid']
	a.points = 1
	a.save(1)
	
	webnotes.conn.set_value('Question', arg['qid'], 'modified', now())

def expand(docs):
	"""
   Expand a doclist sent from the client side. (Internally used by the request handler)
	"""
	from webnotes.utils import load_json

	docs = load_json(docs)
	clist = []
	for d in docs['_vl']:
		doc = xzip(docs['_kl'][d[0]], d);
		clist.append(doc)
	return clist

def vote(arg):
	args = load_json(arg)
	
	res = webnotes.conn.sql("select points, _users_voted from `tab%s` where name=%s" % (args['dt'], '%s'), args['dn'])[0]
	p = cint(res[0])
	p = args['vote']=='up' and p+1 or p-1
	
	# update
	webnotes.conn.sql("update `tab%s` set points=%s, _users_voted=%s where name=%s" % (args['dt'], '%s', '%s', '%s'), \
		(p, cstr(res[1]) + ',' + webnotes.user.name, args['dn']))
	
	return p

def set_user_details(arg=None):
	"""
		updates user details given in argument
	"""
	from webnotes.model.doc import Document
	
	p = Document('Profile', webnotes.user.name)
	arg_dict = load_json(arg)
	if not 'bio' in arg_dict: arg_dict['bio'] = None
	if not 'last_name' in arg_dict: arg_dict['last_name'] = None
	p.fields.update(arg_dict)
	p.save()
	webnotes.msgprint('Updated')

def change_password(arg):
	"""
		Change password
	"""
	check_demo()
	arg = load_json(arg)
	
	if not webnotes.conn.sql('select name from tabProfile where name=%s and password=password(%s)', (webnotes.session['user'], arg['old_password'])):
		webnotes.msgprint('Old password is not correct', raise_exception=1)
	
	from webnotes.utils import nowdate
	webnotes.conn.sql("update tabProfile set password=password(%s), modified=%s where name=%s",(arg['new_password'], nowdate(), webnotes.session['user']))
	webnotes.msgprint('Password Updated');

	def get_customer_address(self, args):
		args = load_json(args)		
		address_text, address_name = self.get_address_text(address_name=args['address'])
		contact_text, contact_name, contact_email, contact_mobile = self.get_contact_text(contact_name=args['contact'])
		ret = {
			'customer_address' : address_name,
			'contact_person' : contact_name,
			'address_display' : address_text,
			'contact_display' : contact_text,
			'contact_email' : contact_email,
			'contact_mobile' : contact_mobile
		}
		return ret	

	def get_default_supplier_address(self, args):
		args = load_json(args)
		address_text, address_name = self.get_address_text(supplier=args['supplier'])
		contact_text, contact_name, contact_email, contact_mobile = self.get_contact_text(supplier=args['supplier'])
		ret = {
			'supplier_address' : address_name,
			'address_display' : address_text,
			'contact_person' : contact_name,
			'contact_display' : contact_text,
			'contact_email' : contact_email,
			'contact_mobile' : contact_mobile						
		}
		ret.update(self.get_supplier_details(args['supplier']))
		return ret

def set_user_details(arg=None):
    """
		updates user details given in argument
	"""
    from webnotes.model.doc import Document

    p = Document("Profile", webnotes.user.name)
    arg_dict = load_json(arg)
    if not "bio" in arg_dict:
        arg_dict["bio"] = None
    if not "last_name" in arg_dict:
        arg_dict["last_name"] = None
    p.fields.update(arg_dict)
    p.save()
    webnotes.msgprint("Updated")

def change_password(arg):
	"""
		Change password
	"""
	check_demo()
	arg = load_json(arg)
	
	if not webnotes.conn.sql("""select * from `__Auth` where `user`=%s
			and password=password(%s)""",
			(webnotes.session["user"], arg["old_password"])):
		webnotes.msgprint('Old password is not correct', raise_exception=1)

	webnotes.conn.sql("""update `__Auth` set password=password(%s)
		where `user`=%s""", (arg["new_password"], webnotes.session["user"]))

	webnotes.msgprint('Password Updated');