======= Métodos de configuración del sistema =======

def mail_list_menu():	
	while True:
		os.system('clear')
		show_basic_mail_list()
		mode=utilities.getInt('\nADMIN MAIL LIST\n\nSelect your choice:\n1.Add mail\n2.Remove mail\n3.Show details\n\n0.Back\n\nChoice:',0,3)
		if mode==1:
			add_mail(str(raw_input('New mail address:')),str(raw_input('LastName:')), str(raw_input('FirstName:')))
		elif mode==2:
			del_mail(str(raw_input('New mail address:')))
		elif mode==3:
			show_full_mail_list()
		elif mode==0:
			break
		os.system('clear')

def add_mail(address, fname, lname):
	connection_name = MySQLdb.connect(host='localhost', user='root', passwd='K0p!r1nn4', db='DSS')
	cursor = connection_name.cursor()
	result = cursor.execute("INSERT INTO MAIL_LIST (Mail, LastName, FirstName) VALUES ('%s' , '%s', '%s');" % (address,lname,fname))
	connection_name.commit()
	return result

def del_mail(address):
	connection_name = MySQLdb.connect(host='localhost', user='root', passwd='K0p!r1nn4', db='DSS')
	cursor = connection_name.cursor()
	result = cursor.execute(" DELETE FROM MAIL_LIST WHERE Mail='%s';" % (address))
	connection_name.commit()
	return result
	
def show_basic_mail_list():
	connection_name = MySQLdb.connect(host='localhost', user='root', passwd='K0p!r1nn4', db='DSS')
	cursor = connection_name.cursor()
	cursor.execute("SELECT * FROM MAIL_LIST;")
	data= cursor.fetchall()
	mail_list= []
	for i in xrange(len(data)):
			mail_list.append(data[i][0])
	print 'Current mail list\n' 
	for i in xrange(len(mail_list)):
		print str(mail_list[i])

def show_full_mail_list():
	connection_name = MySQLdb.connect(host='localhost', user='root', passwd='K0p!r1nn4', db='DSS')
	cursor = connection_name.cursor()
	cursor.execute("SELECT * FROM MAIL_LIST;")
	data= cursor.fetchall()
	mail_list= [[] for k in xrange(len(data))]
	for j in xrange(len(data)):
		for i in xrange(len(data[0])):
				mail_list[j].append(data[j][i])
				
	os.system('clear')
	print 'Current List Details:\n'
	print '{}				{}		{}'.format('Mail', 'LastName','FirstName')
	for j in xrange(len(data)):
		print '{}			{}			{}'.format(mail_list[j][0],mail_list[j][1] ,mail_list[j][2])
	print '\n'
		
	print '\n'
	raw_input("\nPress Enter to continue...")
		
		
# Users list functions
		
def user_accounts_menu():
	while True:
		os.system('clear')
		show_basic_users_list()
		mode=utilities.getInt('\nADMINISTRATE USER LIST\n\nSelect your choice:\n1.Add user\n2.Remove user\n3.Change password\n\n0.Back\n\nChoice:',0,3)
		if mode==1:
			add_user(raw_input('ID:'),str(raw_input('LastName:')), str(raw_input('FirstName:')) , str(raw_input('Job:')) ,str(raw_input('Pivilege Level (0 or 1):')), str(raw_input('Password:')))
		elif mode==2:
			del_user(str(raw_input('User ID:')))
		elif mode==3:
			change_pass(str(raw_input('User ID:')), getpass.getpass('New password:'))
		elif mode==0:
			break
		os.system('clear')	

def add_user(ID, fname, lname, job, privilege,password):
	connection_name = MySQLdb.connect(host='localhost', user='root', passwd='K0p!r1nn4', db='DSS')
	cursor = connection_name.cursor()
	key_file=open("system_key", "r")
	passphrase=key_file.readline(44)
	result = cursor.execute("INSERT INTO USERS (ID, FirstName, Last Name, Job, Privilege, Password) VALUES (%s,'%s','%s','%s',%s, AES_ENCRYPT('%s','%s'));" % (ID, lname, fname, job, privilege, password , passphrase))
	connection_name.commit()
	return result
	
def del_user(ID):
	connection_name = MySQLdb.connect(host='localhost', user='root', passwd='K0p!r1nn4', db='DSS')
	cursor = connection_name.cursor()
	result = cursor.execute(" DELETE FROM USERS WHERE ID=%s;" % (ID))
	connection_name.commit()
	return result

def change_pass(ID, new_pass):
	connection_name = MySQLdb.connect(host='localhost', user='root', passwd='K0p!r1nn4', db='DSS')
	cursor = connection_name.cursor()
	key_file=open("system_key", "r")
	passphrase=key_file.readline(44)
	result = cursor.execute("UPDATE USERS SET password = AES_ENCRYPT('%s','%s') WHERE ID=%s;" % (new_pass, passphrase, ID))
	connection_name.commit()
	return result

def show_basic_users_list():
	connection_name = MySQLdb.connect(host='localhost', user='root', passwd='K0p!r1nn4', db='DSS')
	cursor = connection_name.cursor()
	cursor.execute("SELECT * FROM USERS;")
	data= cursor.fetchall()
	users= [[] for k in xrange(len(data))]
	for j in xrange(len(data)):
		for i in xrange(len(data[0])):
				users[j].append(data[j][i])
	os.system('clear')
	print 'Current Users Details:' 
	print '{}		{}		{}		{}'.format('ID', 'LastName','FirstName','Job')
	for j in xrange(len(data)):
		print '{}		{}			{}			{}'.format(users[j][0],users[j][1] ,users[j][2] ,users[j][3])
	print '\n'

def product_list_menu():
	while True:
		os.system('clear')
		mode=utilities.getInt('PRODUCT LIST MENU\n\nSelect your choice:\n1.Add product from list\n2.Remove product from list\n3.Refresh product popularity\n\n0.Back\n\nChoice:',0,4)
		if mode==1:
			add_product_to_list(raw_input('Family:'),str(raw_input('Product name:')), str(raw_input('Price:')))
		elif mode==2:
			del_product_from_list(str(raw_input('Product name:')))
		elif mode==3:
			change_price(str(raw_input('Product name:')))
		elif mode==4:
			refresh_popularity()
		elif mode==0:
			break
		os.system('clear')

def add_product_to_list(family, name, price):
	print 'Under Construction!'
	time.sleep(3)
def del_product_from_list(name):
	print 'Under Construction!'
	time.sleep(3)
def change_price():
	print 'Under Construction!'
	time.sleep(3)
def refresh_popularity():
	print 'Under Construction!'
	time.sleep(3)
def check_existence():
	con = MySQLdb.connect('localhost', 'root', 'K0p!r1nn4', 'PRODUCTS');
	cursor.execute("SELECT COUNT(*) FROM productos;")
	data= cursor.fetchall()
	
	print data
	cur = con.cursor()
	#for i in xrange (data)
	cur.execute("UPDATE productos SET ExistenciaUnidad1 = InventarioUnidad1 - UnidadesVendidas")