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'