- filtercount = {'ok' : 0, 'NetDown': 0, 'Not_Run' : 0, 'pending' : 0, 'all' : 0}
- return dict(query=[], fc=filtercount)
+ filtercount = {'good' : 0, 'down': 0, 'new' : 0, 'pending' : 0, 'all' : 0}
+ fbquery = HistorySiteRecord.query.all()
+ query = []
+ for site in fbquery:
+ # count filter
+ filtercount['all'] += 1
+ if site.new and site.slices_used == 0 and not site.enabled:
+ filtercount['new'] += 1
+ elif not site.enabled:
+ filtercount['pending'] += 1
+ else:
+ filtercount[site.status] += 1
+
+ # apply filter
+ if filter == "all":
+ query.append(site)
+ elif filter == 'new' and site.new and site.slices_used == 0 and not site.enabled:
+ query.append(site)
+ elif filter == "pending" and not site.enabled:
+ query.append(site)
+ elif filter == site.status:
+ query.append(site)
+
+ return dict(query=query, fc=filtercount)