No Description

views.py 15KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402
  1. from django.shortcuts import render
  2. from counter.models import Counter, Reset
  3. from django.contrib.auth.models import User
  4. from babel.dates import format_timedelta, format_datetime
  5. from datetime import datetime, timedelta
  6. from django import forms
  7. from django.http import HttpResponseRedirect
  8. from django.core.mail import EmailMessage
  9. from django.contrib.auth.decorators import login_required
  10. from django.core.urlresolvers import reverse
  11. from django.db import IntegrityError
  12. from graphos.renderers import gchart
  13. from django.template.loader import render_to_string
  14. from graphos.sources.simple import SimpleDataSource
  15. from graphos.sources.model import ModelDataSource
  16. import random
  17. import math
  18. import copy
  19. from django.utils import timezone
  20. @login_required
  21. def home(request):
  22. # JSS above this limit will not be displayed on the col graph
  23. JSS_limit = 7
  24. maxJSS = 0
  25. bestSeumeursNumber = 15
  26. # Display counters
  27. lastResets = []
  28. # Calculates infos for each counter
  29. timezero = timedelta(0)
  30. # First select our counter
  31. try:
  32. myCounter = Counter.objects.get(user__id=request.user.id)
  33. lastReset = Reset.objects.filter(
  34. counter=myCounter).order_by('-timestamp')
  35. if (lastReset.count() == 0):
  36. # This person never had the seum
  37. myCounter.lastReset = Reset()
  38. myCounter.lastReset.delta = timezero
  39. myCounter.lastReset.noSeum = True
  40. else:
  41. myCounter.lastReset = lastReset[0]
  42. myCounter.lastReset.noSeum = False
  43. if (myCounter.lastReset.who is None or
  44. myCounter.lastReset.who.id == myCounter.id):
  45. myCounter.lastReset.selfSeum = True
  46. else:
  47. myCounter.lastReset.selfSeum = False
  48. myCounter.lastReset.delta = datetime.now(
  49. ) - myCounter.lastReset.timestamp.replace(tzinfo=None)
  50. myCounter.seumCount = Reset.objects.filter(
  51. counter=myCounter).count()
  52. myCounter.lastReset.formatted_delta = format_timedelta(
  53. myCounter.lastReset.delta, locale='fr', threshold=1)
  54. except Counter.DoesNotExist:
  55. return HttpResponseRedirect(reverse('login'))
  56. # Building data for counters display
  57. counters = Counter.objects.all()
  58. for counter in counters:
  59. lastReset = Reset.objects.filter(
  60. counter=counter).order_by('-timestamp')
  61. if (lastReset.count() == 0):
  62. # This person never had the seum
  63. counter.lastReset = Reset()
  64. counter.lastReset.delta = timezero
  65. counter.lastReset.noSeum = True
  66. counter.CSSclass = "warning"
  67. else:
  68. counter.lastReset = lastReset[0]
  69. if (counter.lastReset.who is None or
  70. counter.lastReset.who.id == counter.id):
  71. counter.lastReset.selfSeum = True
  72. else:
  73. counter.lastReset.selfSeum = False
  74. counter.lastReset.noSeum = False
  75. counter.lastReset.delta = datetime.now(
  76. ) - counter.lastReset.timestamp.replace(tzinfo=None)
  77. if ((counter.lastReset.delta.total_seconds()) / (24 * 3600) <
  78. JSS_limit):
  79. # Less than 7 JSS -> display on graph
  80. lastResets.append(
  81. [counter.trigramme,
  82. {'v': (counter.lastReset.delta.total_seconds()) /
  83. (24 * 3600),
  84. 'f': str(round(
  85. (counter.lastReset.delta.total_seconds()) /
  86. (24 * 3600), 1))}])
  87. # Updating the max JSS displayed on the graph to compute scale
  88. if (counter.lastReset.delta.total_seconds() / (24 * 3600) >
  89. maxJSS):
  90. maxJSS = (counter.lastReset.delta.total_seconds() /
  91. (24 * 3600))
  92. # Defining CSS attributes for the counter
  93. counter.CSSclass = "default"
  94. counter.opacity = 0.4 + 0.6 * \
  95. math.exp(-(counter.lastReset.delta.total_seconds()) /
  96. (7 * 24 * 3600))
  97. # Computing the total number of resets for this counter
  98. counter.seumCount = Reset.objects.filter(
  99. counter=counter).count()
  100. counter.lastReset.formatted_delta = format_timedelta(
  101. counter.lastReset.delta, locale='fr', threshold=1)
  102. counter.isHidden = "hidden"
  103. counters = sorted(counters, key=lambda t: t.lastReset.delta)
  104. # Column graph
  105. if (len(lastResets) == 0):
  106. noGraph = True
  107. col_chart = None
  108. else:
  109. noGraph = False
  110. lastResets.sort(key=lambda x: x[1]['v'])
  111. lastResets.insert(0, ['Trigramme', 'Jours sans seum'])
  112. col_data = SimpleDataSource(lastResets)
  113. col_chart = gchart.ColumnChart(col_data, options={
  114. 'title': '',
  115. 'legend': 'none',
  116. 'vAxis': {
  117. 'viewWindow': {
  118. 'max': max(maxJSS, 1),
  119. 'min': 0
  120. },
  121. 'ticks': [1, 2, 3, 4, 5, 6, 7],
  122. 'title': 'Jours sans seum'
  123. },
  124. 'hAxis': {'title': 'Trigramme'},
  125. })
  126. # Timeline graph
  127. # Data pre-processing
  128. resets = Reset.objects.filter(
  129. timestamp__gte=timezone.now() - timedelta(days=1))
  130. if (resets.count() == 0):
  131. noTimeline = True
  132. line_chart = None
  133. else:
  134. noTimeline = False
  135. for reset in resets:
  136. reset.timestamp = {
  137. 'v': reset.timestamp.timestamp(),
  138. 'f': "Il y a " + format_timedelta(datetime.now() -
  139. reset.timestamp.replace(
  140. tzinfo=None),
  141. locale='fr', threshold=1)
  142. }
  143. if (reset.who is None or
  144. reset.who.id == reset.counter.id):
  145. reset.Seum = {'v': 0,
  146. 'f': reset.counter.trigramme +
  147. " : " + reset.reason}
  148. else:
  149. reset.Seum = {'v': 0,
  150. 'f': reset.who.trigramme + ' à ' +
  151. reset.counter.trigramme +
  152. " : " + reset.reason}
  153. # Drawing the graph
  154. line_data = ModelDataSource(resets, fields=['timestamp', 'Seum'])
  155. line_chart = gchart.LineChart(line_data, options={
  156. 'lineWidth': 0,
  157. 'pointSize': 10,
  158. 'title': '',
  159. 'vAxis': {'ticks': []},
  160. 'hAxis': {
  161. 'ticks': [
  162. {'v': (datetime.now() - timedelta(days=1)
  163. ).timestamp(), 'f': 'Il y a 24 h'},
  164. {'v': datetime.now().timestamp(), 'f': 'Présent'}
  165. ]
  166. },
  167. 'legend': 'none',
  168. 'height': 90
  169. })
  170. # Graph of greatest seumers
  171. seumCounts = []
  172. for counter in counters:
  173. seumCounts.append([counter.trigramme, Reset.objects.filter(
  174. counter=counter).count()])
  175. if (len(seumCounts) == 0):
  176. noBestSeum = True
  177. best_chart = None
  178. else:
  179. seumCounts.sort(key=lambda x: -x[1])
  180. noBestSeum = False
  181. seumCounts.insert(0, ['Trigramme', 'Nombre de seums'])
  182. best_data = SimpleDataSource(seumCounts[:bestSeumeursNumber])
  183. best_chart = gchart.ColumnChart(best_data, options={
  184. 'title': '',
  185. 'legend': 'none',
  186. 'vAxis': {'title': 'Nombre de seums'},
  187. 'hAxis': {'title': 'Trigramme'},
  188. })
  189. # Graph of seum activity
  190. resets = Reset.objects.filter(
  191. timestamp__gte=timezone.now() - timedelta(days=365))
  192. months = {}
  193. for reset in resets:
  194. monthDate = datetime(reset.timestamp.year, reset.timestamp.month, 1)
  195. months[monthDate] = months.get(monthDate, 0) + 1
  196. monthList = sorted(months.items(), key=lambda t: t[0])
  197. seumActivity = []
  198. for month in monthList:
  199. seumActivity.append(
  200. [format_datetime(month[0], locale='fr',
  201. format="MMM Y").capitalize(), month[1]])
  202. if (len(seumActivity) == 0):
  203. noSeumActivity = True
  204. activity_chart = None
  205. else:
  206. noSeumActivity = False
  207. seumActivity.insert(0, ['Mois', 'Nombre de seums'])
  208. activity_data = SimpleDataSource(seumActivity)
  209. activity_chart = gchart.ColumnChart(activity_data, options={
  210. 'title': '',
  211. 'legend': 'none',
  212. 'vAxis': {'title': 'Nombre de seums'},
  213. 'hAxis': {'title': 'Mois'},
  214. })
  215. return render(request, 'homeTemplate.html', {
  216. 'counters': counters,
  217. 'col_chart': col_chart,
  218. 'line_chart': line_chart,
  219. 'best_chart': best_chart,
  220. 'activity_chart': activity_chart,
  221. 'noTimeline': noTimeline,
  222. 'noGraph': noGraph,
  223. 'noBestSeum': noBestSeum,
  224. 'noSeumActivity': noSeumActivity,
  225. 'myCounter': myCounter,
  226. })
  227. @login_required
  228. def resetCounter(request):
  229. # Update Form counter
  230. if (request.method == 'POST'):
  231. # create a form instance and populate it with data from the request:
  232. data = dict(request.POST)
  233. counter = Counter.objects.get(pk=int(data['counter'][0]))
  234. who = Counter.objects.get(pk=int(data['who'][0]))
  235. reset = Reset()
  236. reset.counter = counter
  237. reset.who = who
  238. reset.reason = data['reason'][0]
  239. reset.timestamp = datetime.now()
  240. reset.save()
  241. # We send the emails only to those who want
  242. emails = [u.email for u in Counter.objects.all()
  243. if u.email_notifications]
  244. # Now send emails to everyone
  245. if (reset.who is None or
  246. reset.who.id == counter.id):
  247. selfSeum = True
  248. else:
  249. selfSeum = False
  250. text_of_email = render_to_string(
  251. 'seumEmail.txt', {'reason': data['reason'][0],
  252. 'name': counter.name,
  253. 'who': reset.who,
  254. 'selfSeum': selfSeum,
  255. })
  256. email_to_send = EmailMessage(
  257. '[SeumBook] ' + counter.trigramme + ' a le seum',
  258. text_of_email,
  259. 'SeumMan <seum@merigoux.ovh>', emails, [],
  260. reply_to=emails)
  261. email_to_send.send(fail_silently=True)
  262. return HttpResponseRedirect(data['redirect'][0])
  263. @login_required
  264. def counter(request, id_counter):
  265. try:
  266. myCounter = Counter.objects.get(user__id=request.user.id)
  267. except Counter.DoesNotExist:
  268. return HttpResponseRedirect(reverse('login'))
  269. counter = Counter.objects.get(pk=id_counter)
  270. resets = Reset.objects.filter(counter=counter).order_by('-timestamp')
  271. firstReset = copy.copy(resets[len(resets) - 1])
  272. timezero = timedelta(0)
  273. # Display
  274. if (resets.count() == 0):
  275. counter.lastReset = Reset()
  276. counter.lastReset.delta = timezero
  277. counter.lastReset.noSeum = True
  278. seumFrequency = 'inconnu'
  279. else:
  280. counter.lastReset = resets[0]
  281. counter.lastReset.noSeum = False
  282. if (counter.lastReset.who is None or
  283. counter.lastReset.who.id == counter.id):
  284. counter.lastReset.selfSeum = True
  285. else:
  286. counter.lastReset.selfSeum = False
  287. counter.lastReset.delta = datetime.now(
  288. ) - counter.lastReset.timestamp.replace(tzinfo=None)
  289. counter.lastReset.formatted_delta = format_timedelta(
  290. counter.lastReset.delta, locale='fr', threshold=1)
  291. counter.seumCount = Reset.objects.filter(
  292. counter=counter).count()
  293. seumFrequency = format_timedelta((
  294. datetime.now() - firstReset.timestamp.replace(tzinfo=None)) /
  295. counter.seumCount, locale='fr', threshold=1)
  296. for reset in resets:
  297. if (reset.who is None or
  298. reset.who.id == reset.counter.id):
  299. reset.selfSeum = True
  300. else:
  301. reset.selfSeum = False
  302. reset.date = format_datetime(
  303. reset.timestamp, locale='fr',
  304. format="dd/MM/Y HH:mm")
  305. # Timeline graph
  306. # Data pre-processing
  307. resets_graph = resets
  308. for reset in resets_graph:
  309. reset.timestamp = {
  310. 'v': reset.timestamp.timestamp(),
  311. 'f': "Il y a " + format_timedelta(
  312. datetime.now() - reset.timestamp.replace(tzinfo=None),
  313. locale='fr', threshold=1)
  314. }
  315. if reset.selfSeum:
  316. reset.Seum = {'v': 0, 'f': reset.reason}
  317. else:
  318. reset.Seum = {'v': 0, 'f': 'De ' + reset.who.trigramme + ' : ' +
  319. reset.reason}
  320. # Drawing the graph
  321. data = ModelDataSource(resets, fields=['timestamp', 'Seum'])
  322. chart = gchart.LineChart(data, options={
  323. 'lineWidth': 0,
  324. 'pointSize': 10,
  325. 'title': '',
  326. 'vAxis': {'ticks': []},
  327. 'hAxis': {'ticks': [{
  328. 'v': firstReset.timestamp.timestamp(),
  329. 'f': 'Il y a ' + format_timedelta(
  330. datetime.now() - firstReset.timestamp.replace(tzinfo=None),
  331. locale='fr', threshold=1)
  332. }, {
  333. 'v': datetime.now().timestamp(),
  334. 'f': 'Présent'}
  335. ]},
  336. 'legend': 'none',
  337. 'height': 90
  338. })
  339. return render(request, 'counterTemplate.html', {
  340. 'counter': counter,
  341. 'chart': chart,
  342. 'resets': resets,
  343. 'seumFrequency': seumFrequency,
  344. 'myCounter': myCounter,
  345. })
  346. def createUser(request):
  347. if (request.method == 'POST'):
  348. # create a form instance and populate it with data from the request:
  349. data = dict(request.POST)
  350. email = data['email'][0]
  351. username = email.split('@')[0]
  352. trigramme = data['trigramme'][0]
  353. nick = data['nick'][0]
  354. password1 = data['password1'][0]
  355. password2 = data['password2'][0]
  356. email_notifications = (data['email_notifications'][0] == "on")
  357. if password1 != password2:
  358. error = "Les deux mots de passe sont différents."
  359. return render(request, 'createUser.html', {'error': error})
  360. try:
  361. test_user = User.objects.get(email=email)
  362. error = "Un utilisateur avec cette adresse email existe déjà !"
  363. return render(request, 'createUser.html', {'error': error})
  364. except User.DoesNotExist:
  365. try:
  366. user = User.objects.create_user(username, email, password1)
  367. except IntegrityError:
  368. error = "Utilise une autre adresse email, un autre utilisateur \
  369. a le même login que toi."
  370. return render(request, 'createUser.html', {'error': error})
  371. counter = Counter()
  372. counter.name = nick
  373. counter.email = email
  374. counter.trigramme = trigramme
  375. counter.user = user
  376. counter.email_notifications = False
  377. counter.save()
  378. return render(request, 'createUserDone.html', {})
  379. else:
  380. return render(request, 'createUser.html', {'error': None})