diff options
Diffstat (limited to 'postgresqleu/confreg/views.py')
| -rw-r--r-- | postgresqleu/confreg/views.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/postgresqleu/confreg/views.py b/postgresqleu/confreg/views.py index 74304a5a..7a82df65 100644 --- a/postgresqleu/confreg/views.py +++ b/postgresqleu/confreg/views.py @@ -51,7 +51,7 @@ from postgresqleu.invoices.models import InvoiceProcessor, InvoiceHistory from postgresqleu.mailqueue.util import send_mail, send_simple_mail, send_template_mail, template_to_string from postgresqleu.util.jsonutil import JsonSerializer from postgresqleu.util.db import exec_to_dict, exec_to_grouped_dict, exec_to_keyed_dict -from postgresqleu.util.db import exec_no_result, exec_to_list, exec_to_scalar +from postgresqleu.util.db import exec_no_result, exec_to_list, exec_to_scalar, conditional_exec_to_scalar from decimal import Decimal from operator import itemgetter @@ -2372,6 +2372,7 @@ def admin_dashboard_single(request, urlname): 'unconfirmed_speakers': exec_to_scalar("SELECT EXISTS (SELECT 1 FROM confreg_conferencesession_speaker css INNER JOIN confreg_conferencesession s ON css.conferencesession_id=s.id WHERE s.conference_id=%(confid)s AND s.status=3)", {'confid': conference.id}), 'sessions_noroom': exec_to_scalar("SELECT EXISTS (SELECT 1 FROM confreg_conferencesession s WHERE s.conference_id=%(confid)s AND s.status=1 AND s.room_id IS NULL)", {'confid': conference.id}), 'sessions_notrack': exec_to_scalar("SELECT EXISTS (SELECT 1 FROM confreg_conferencesession s WHERE s.conference_id=%(confid)s AND s.status=1 AND s.track_id IS NULL)", {'confid': conference.id}), + 'pending_sessions': conditional_exec_to_scalar(conference.scheduleactive, "SELECT EXISTS (SELECT 1 FROM confreg_conferencesession s WHERE s.conference_id=%(confid)s AND s.status=0)", {'confid': conference.id}), }, RequestContext(request)) @login_required |