def dashboard():
try:
wEvent('/html/v1.0/dashboard', 'exeReq', 'Get', 'OK')
return render_template('dashboard.html', maps=getMaps())
except Exception as e:
wEvent('/html/v1.0/dashboard', 'exeReq', 'Get', 'KO')
return 'Dashboard error'
def viewCustomer():
try:
sql = "SELECT login, firstname, lastname, email, address, enterprise, mobile, password "
sql += "FROM user WHERE login = '******'login'] + "' AND grp = 'customer';"
view = exeReq(sql)
wEvent('/html/v1.0/customer/view','exeReq','Get','OK')
return render_template('customer.html', view = view[0], maps = getMaps())
except Exception as e:
wEvent('/html/v1.0/customer/view','exeReq','Get','KO')
return 'View error'
def viewUser():
try:
sql = "SELECT uid, login, firstname, lastname, email, address, enterprise, grp, mobile, '', admin "
sql += "FROM user WHERE login = '******'login'] + "';"
view = exeReq(sql)
wEvent('/html/v1.0/user/view','exeReq','Get','OK')
return render_template('user.html', view = view[0], maps = getMaps())
except Exception as e:
wEvent('/html/v1.0/user/view','exeReq','Get','KO')
return 'View error'
def tracker():
try:
wEvent('/html/v1.0/tracker', 'exeReq', 'Get', 'OK')
return render_template('tracker.html',
maps=getMaps(),
loginList=loginList(),
nameList=nameList())
except Exception as e:
wEvent('/html/v1.0/tracker', 'exeReq', 'Get', 'KO')
return 'Tracker error'
def viewTracking():
try:
sql = "SELECT t.tid, u.login, d.name, t.ip, t.gps, t.url, t.website, t.webhook, t.address, t.timestamp, t.humidity, t.luminosity, t.temp_amb, t.temp_sensor, t.data "
sql += "FROM tracking t, user u, device d "
sql += "WHERE u.uid = t.uid AND t.did = d.did AND t.tid = '" + request.args[
'tracking'] + "';"
view = exeReq(sql)
wEvent('/html/v1.0/tracking/view', 'exeReq', 'Get', 'OK')
return render_template('tracking.html',
view=view[0],
maps=getMaps(),
loginList=loginList(),
nameList=nameList())
except Exception as e:
wEvent('/html/v1.0/tracking/view', 'exeReq', 'Get', 'KO')
return 'View error'
def listTracking():
try:
sql_cont = "FROM tracking t, user u, device d "
sql_cont += "WHERE t.uid = u.uid AND t.did = d.did AND u.grp != 'deleted' AND d.status != 'deleted' "
# Pagination
search = False
q = request.args.get('q')
if q:
search = True
page = request.args.get(get_page_parameter(), type=int, default=1)
per_page = 20
startat = page * per_page
if startat <= per_page:
startat = 0
count = exeReq("SELECT count(*) {}".format(sql_cont))
count = re.sub("[^0-9]", "", "{}".format(count))
pagination = Pagination(page=page,
total=int(count),
search=search,
record_name='list',
css_framework='foundation',
per_page=per_page)
# Get data
sql = "SELECT t.tid, u.login, d.name, t.timestamp, data "
sql += "{} ORDER BY t.tid DESC LIMIT {}, {};".format(
sql_cont, startat, per_page)
list = exeReq(sql)
wEvent('/html/v1.0/tracking/list', 'exeReq', 'Get list', 'OK')
return render_template('listTracking.html',
list=list,
maps=getMaps(),
pagination=pagination)
except Exception as e:
wEvent('/html/v1.0/tracking/list', 'exeReq', 'Get list', 'KO')
return 'List error'
def listCustomer():
try:
# Pagination
search = False
q = request.args.get('q')
if q:
search = True
page = request.args.get(get_page_parameter(), type=int, default=1)
per_page = 20
startat = page * per_page
if startat <= per_page:
startat = 0
count = exeReq("SELECT count(*) FROM user WHERE grp = 'customer';")
count = re.sub("[^0-9]", "","{}".format(count))
pagination = Pagination(page=page, total=int(count), search=search, record_name='list', css_framework='foundation', per_page=per_page)
# Get data
list = exeReq("SELECT login, email, grp FROM user WHERE grp = 'customer';")
wEvent('/html/v1.0/customer/list','exeReq','Get list','OK')
return render_template('listCustomer.html', list = list, maps = getMaps(), pagination=pagination)
except Exception as e:
wEvent('/html/v1.0/customer/list','exeReq','Get list','KO')
return 'List error'