def profile():
# Check session
v_user = functions.getcoockie('s_user')
if v_user == "":
abort(401, "Sorry, access denied.")
else:
# Request session
v_password = functions.getcoockie('s_password')
v_role = functions.getcoockie('s_role')
# User data query
sql_select="SELECT * FROM USERS WHERE user_user='******'" %(v_user)
campos=functions.database_select(sql_select, v_user, v_password)
# Gravatar function
gravatar_url = functions.miniavatar(v_user,v_password)
return template('views/profile.tpl', user_user=campos[0], user_name=campos[1], user_email=campos[2], user_date=campos[3], user_role=campos[4], user_urlimage=gravatar_url, rol=v_role)
def stats():
v_user = functions.getcoockie('s_user')
if v_user == "":
abort(401, "Sorry, access denied.")
else:
v_password = functions.getcoockie('s_password')
totalbackups="select count(backup_date) from backups;"
sqlselectmode="select backup_mode, count(backup_host) from backups group by backup_mode;"
sqlselecthosts="select h.host_name, count(b.backup_host) from backups b, hosts h where h.host_ip = b.backup_host group by h.host_name;"
p_totalbackups=functions.database_select(totalbackups, v_user, v_password)
backupsmode=functions.selectall(sqlselectmode, v_user, v_password)
backupshost=functions.selectall(sqlselecthosts, v_user, v_password)
total=int(p_totalbackups[0])
gravatar_url = functions.miniavatar(v_user,v_password)
return template('views/stats.tpl', user_user=v_user, user_urlimage=gravatar_url, total=total, modes=backupsmode, names=backupshost)
def dashboard():
# Check session
v_user = functions.getcoockie('s_user')
if v_user == "":
abort(401, "Sorry, access denied.")
else:
# Request session
v_password = functions.getcoockie('s_password')
v_name = functions.getcoockie('s_name')
v_role = functions.getcoockie('s_role')
# Last 5 backups query
selectbackupusers="select backup_host, host_name, backup_user, to_char(backup_date, 'DD-MM-YYYY'), to_char(backup_date,'HH24:MI') from backups join hosts on host_ip = backup_host order by backup_date desc limit 5;"
backupsusers=functions.selectall(selectbackupusers, v_user, v_password)
# Stats querys & functions
totalbackups="select count(backup_date) from backups;"
sqlselectmode="select backup_mode, count(backup_host) from backups group by backup_mode;"
sqlselecthosts="select h.host_name, count(b.backup_host) from backups b, hosts h where h.host_ip = b.backup_host group by h.host_name;"
p_totalbackups=functions.database_select(totalbackups, v_user, v_password)
backupsmode=functions.selectall(sqlselectmode, v_user, v_password)
backupshost=functions.selectall(sqlselecthosts, v_user, v_password)
total=int(p_totalbackups[0])
# Gravatar function
gravatar_url = functions.miniavatar(v_user,v_password)
return template('views/index.tpl', user_user=v_user, user_name=v_name, user_urlimage=gravatar_url, backupsusers=backupsusers, total=total, modes=backupsmode, names=backupshost, rol=v_role)