Ei kuvausta

views.py 16KB

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