def device_profile_data(id): search = False q = request.args.get('q') if q: search = True try: page = int(request.args.get('page', 1)) except ValueError: page = 1 else: page = 1 device = Device.get(id) if device: # datas = device.datas.order_by(desc(cls.create_time)).paginate(page, per_page, True).items datas = Data.get_gdatas(current_user, device) count = len(datas) pagination = Pagination(page=page, per_page=15, total=count, css_framework='bootstrap3', search=search, record_name='devices') return render_template('devices/device_data.html', datas=datas, device=device, pagination=pagination) else: abort(404)
def device_ajax_data(id): one_month_ago = datetime.now() - timedelta(days=30) datas = Data.get_datas_in_date(id, one_month_ago) # datas = device.datas.order_by(desc('create_time')).limit(200).all() res = [] if datas: for d in datas: data = dict() data['occupancy'] = d.occupancy data['temperature'] = d.temperature data['electric_level'] = d.electric_level data['create_time'] = d.create_time.strftime('%m-%d %H:%M') res.append(data) return jsonify({'data': res})