+ for vote in votes:
+ if not vote.get('nb_votes'):
+ vote['nb_votes'] = 0
+ if vote.get('max_votes'):
+ vote['percent'] = int((float(vote['nb_votes']) / float(vote['max_votes'])) * 100)
+ return render_template('votes.html', votes=votes, active_button=active_button)
+
+#------
+# Vote
+
+def can_see_vote(idvote, iduser=-1):
+ vote = query_db('select * from votes where id=?', [idvote], one=True)
+ if vote is None:
+ return False
+ if not vote['is_public']:
+ user = query_db('select * from users where id=?', [iduser], one=True)
+ if query_db('select * from user_group where id_user = ? and id_group = ?', [iduser, vote['id']], one=True) is None:
+ return False
+ return True
+
+def can_vote(idvote, iduser=-1):
+ vote = query_db('select * from votes where id=?', [idvote], one=True)
+ if vote is None:
+ return False
+ if vote['is_terminated'] == 0:
+ if iduser > 0:
+ if can_see_vote(idvote, iduser):
+ if not has_voted(idvote, iduser):
+ if query_db('select * from user_group where id_user = ? and id_group = ?', [iduser, vote['id_group']], one=True):
+ return True
+ return False
+
+def has_voted(idvote, iduser=-1):
+ vote = query_db('select * from user_vote \
+ where id_vote = ? and id_user = ?', [idvote, iduser], one=True)
+ return (vote is not None)
+
+@app.route('/vote/<idvote>', methods=['GET', 'POST'])
+def vote(idvote):
+ vote = query_db('select votes.*, groups.name as groupname, users.name as author from votes \
+ join groups on groups.id=votes.id_group \
+ join users on users.id=votes.id_author \
+ where votes.id=?', [idvote], one=True)
+ if vote is None:
+ abort(404)
+ if can_see_vote(idvote, get_userid()):
+ choices = query_db('select name, id from choices where id_vote=?', [idvote])
+ values = query_db('select weight,name from values_ where id_cardinal=? order by weight ASC', [vote['id_cardinal']])
+ values.insert(0, {'weight':None,'name':u'=X̄ (Pas d’Opinion)'})
+ for v in values:
+ v['class'] = "value_" + re.sub('[^a-zA-Z0-9-]', '_', v['name'])
+ weights = OrderedDict([(v['weight'], v) for v in values])
+ if request.method == 'POST':
+ if can_vote(idvote, get_userid()):
+ userid = session.get('user').get('id') if not vote['is_anonymous'] else None
+ # ACTION: store user's choices
+ for choice in choices:
+ if choice['name'] is None:
+ continue
+ weight = request.form.get('value-'+str(choice['id']),None)
+ if weight is not None and len(weight) is 0:
+ weight = None
+ if weight is not None:
+ weight = int(weight)
+ g.db.execute('insert into user_choice (id_user, id_choice, id_cardinal, weight) \
+ values (?, ?, ?, ?)', [userid, choice['id'], vote['id_cardinal'], weight])
+ g.db.commit()
+ # ACTION: randomize storage when anonymous votes
+ if vote['is_anonymous']:
+ g.db.execute('delete from user_choice_buffer_anonymous')
+ g.db.execute('insert into user_choice_buffer_anonymous select * \
+ from user_choice where id_choice in (%s)'
+ % ','.join(['?'] * len(choices))
+ , tuple(c['id'] for c in choices))
+ g.db.execute('delete from user_choice where id_choice in (%s)'
+ % ','.join(['?'] * len(choices))
+ , tuple(c['id'] for c in choices))
+ g.db.execute('insert into user_choice select * \
+ from user_choice_buffer_anonymous \
+ order by random()')
+ g.db.execute('delete from user_choice_buffer_anonymous')
+ g.db.commit()
+ comment = request.form.get('comment', None)
+ g.db.execute('insert into user_vote (id_user, id_vote, comment) \
+ values (?, ?, ?)'
+ , [session.get('user').get('id'), vote['id'], comment])
+ g.db.commit()
+ else:
+ abort(401)
+ # ACTION: count quorum numbers
+ max_votes = query_db('select id_group, count(*) as nb \
+ from user_group where id_group = ? \
+ group by id_group', [vote['id_group']], one=True)
+ if max_votes is None:
+ vote['percent'] = 0
+ vote['nb_votes'] = 0
+ else:
+ vote['max_votes'] = max_votes['nb']
+ votes = query_db('select id_vote, count(*) as nb \
+ from (select id_user, id_vote from user_vote \
+ group by id_user, id_vote) \
+ where id_vote = ? group by id_vote', [idvote], one=True)
+ if votes is None:
+ vote['percent'] = 0
+ vote['nb_votes'] = 0
+ else:
+ vote['nb_votes'] = votes['nb']
+ vote['percent'] = int((float(vote['nb_votes']) / float(vote['max_votes'])) * 100)
+ # ACTION: query users' choices joined with users' identity if not anonymous
+ user_choices = query_db('select user_choice.id_user as userid, users.name as username, \
+ choices.id as choiceid, choices.name as choice_name, \
+ user_choice.weight as weight, user_vote.comment as comment \
+ from choices \
+ join user_choice on choices.id = user_choice.id_choice \
+ left join users on userid = users.id \
+ left join user_vote on userid = user_vote.id_user and choices.id_vote = user_vote.id_vote \
+ where choices.id_vote = ? \
+ order by user_vote.date,choices.id', [idvote])
+ # ACTION: aggregate user choices per vote
+ vote['blank'] = 0
+ results = OrderedDict()
+ for c in choices:
+ choice_values = [(w, { 'nb':0
+ , 'idx':i
+ , 'name':weights[w]['name']
+ , 'class':weights[w]['class'] }
+ ) for (i,w) in enumerate(weights, start=0)]
+ choice_values = OrderedDict(choice_values)
+ results[c['id']] = { 'id':c['id']
+ , 'name':c['name']
+ , 'sum':0
+ , 'average':0.0
+ , 'nb':0
+ , 'blank':0
+ , 'values_':choice_values }
+ for uc in user_choices:
+ results[uc['choiceid']]['nb'] += 1
+ results[uc['choiceid']]['values_'][uc['weight']]['nb'] += 1
+ if uc['weight'] is None:
+ results[uc['choiceid']]['blank'] += 1
+ vote['blank'] += 1
+ else:
+ results[uc['choiceid']]['sum'] += uc['weight']
+ for c in results:
+ if results[c]['nb'] - results[c]['blank'] != 0:
+ results[c]['average'] = results[c]['average'] + (float(results[c]['sum']) / float(results[c]['nb'] - results[c]['blank']))
+ previous_percent = 0
+ for w in weights:
+ if results[c]['nb'] > 0:
+ percent = float(results[c]['values_'][w]['nb'] * 100) / results[c]['nb']
+ else:
+ percent = 0.
+ results[c]['values_'][w]['percent'] = percent
+ results[c]['values_'][w]['previous_percent'] = previous_percent
+ previous_percent += percent
+ results[c]['values_'] = results[c]['values_'].values()
+ results = sorted(results.values(), key=lambda c: c['average'], reverse=True)
+ len_results = len(results)
+ if len_results % 2 == 0:
+ medians = results[len_results/2-1:len_results/2+1]
+ else:
+ medians = [results[len_results/2]]
+ results = { 'list':results
+ , 'medians':[m['id'] for m in medians]
+ , 'average':sum([r['sum'] for r in results])/len_results }
+ # ACTION: list user results per user
+ users = OrderedDict()
+ if vote['is_anonymous']:
+ user_votes = query_db('select users.name, id_user as userid, comment \
+ from user_vote \
+ join users on users.id = id_user where id_vote = ?', [idvote])
+ for uc in user_votes:
+ users[uc['userid']] = { 'username':uc['name']
+ , 'comment':uc['comment']
+ , 'choices':{}
+ , 'userid':uc['userid'] }
+ else:
+ for uc in user_choices:
+ weight = uc['weight']
+ value = { 'weight':weight
+ , 'name':weights[weight]['name']
+ , 'class':weights[weight]['class'] }
+ if uc['userid'] in users:
+ users[uc['userid']]['choices'][uc['choiceid']] = value
+ else:
+ users[uc['userid']] = { 'userid':uc['userid']
+ , 'username':uc['username']
+ , 'comment':uc['comment']
+ , 'choices':{uc['choiceid']:value} }
+ attachments = query_db('select * from attachments where id_vote=?', [idvote])
+ if query_db('select * from user_group where id_group = ? and id_user = ?'
+ , [vote['id_group'], get_userid()], one=True) and not vote['is_terminated']:
+ flash(u'Ce vote vous concerne !', 'info')
+ return render_template('vote.html', vote=vote, attachments=attachments
+ , values=values, choices=choices, results=results, users=users.values()
+ , can_vote=can_vote(idvote, get_userid()))
+ flash(u'Vous n\'avez pas le droit de voir ce vote, désolé.')
+ return redirect(url_for('home'))
+
+@app.route('/vote/deletechoices/<idvote>/<iduser>')
+def vote_deletechoices(idvote, iduser):
+ if int(iduser) != get_userid():
+ abort(401)
+ vote = query_db('select votes.* from votes \
+ where votes.id=?', [idvote], one=True)
+ if not vote['is_terminated'] and not vote['is_anonymous']:
+ g.db.execute('delete from user_choice where id_user = ? and id_choice \
+ in (select id from choices where id_vote = ?)'
+ , [iduser, idvote])
+ g.db.commit()
+ g.db.execute('delete from user_vote where id_user = ? and id_vote \
+ in (select id_vote from choices where id_vote = ?)'
+ , [iduser, idvote])
+ g.db.commit()
+ return redirect(url_for('vote', idvote=idvote))