<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Hallo Andreas,<div class=""><br class=""></div><div class="">na mir wäre es natürlich recht, nur will ich nichts verschlimmbessern, falls jemand das Feature genau so braucht.</div><div class=""><br class=""></div><div class="">Gibt es nachteilige Nebenwirkungen, die bedacht werden müssen?</div><div class=""><br class=""></div><div class="">Best Grüße</div><div class="">Armin</div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">Am 21.01.2016 um 13:14 schrieb Andreas Goetz <<a href="mailto:cpuidle@gmail.com" class="">cpuidle@gmail.com</a>>:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><div class="gmail_extra"><div class="gmail_quote">2016-01-21 12:29 GMT+01:00 application MGR<span class="Apple-converted-space"> </span><span dir="ltr" class=""><<a href="mailto:applicationMGR@ecocuyo.de" target="_blank" class="">applicationMGR@ecocuyo.de</a>></span>:<br class=""><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;"><div style="word-wrap: break-word;" class=""><div class="">Hallo @</div><div class=""><br class=""></div><div class="">mit folgender Abfrage mit Startdatum<span class="Apple-converted-space"> </span><i class="">20.12.15 00:00:00</i><span class="Apple-converted-space"> </span>und Enddatum<span class="Apple-converted-space"> </span><i class="">17.01.16 00:00:00:</i></div><div class=""><br class=""></div><div class="">http://<localhost>/middleware.php/data.json?from=1450566000000&to=1452985200000&group=week&%20uuid%5B%5D=xxxxxxxx-xxxx-xxxx-xxxx-695ed220d33d</div><div class=""><br class=""></div><div class="">erhalte ich folgende Antwort von der Middleware:</div><div class=""><br class=""></div><div class="">{"version":"0.3","data”:[</div><div class=""><span style="white-space: pre-wrap;" class=""> </span>{</div><div class=""><span style="white-space: pre-wrap;" class=""> </span>"tuples”:[</div><div class=""><span style="white-space: pre-wrap;" class=""> </span>[1451257185000,159.436,39831], <span style="white-space: pre-wrap;" class=""> </span>-> <span style="white-space: pre-wrap;" class=""> </span>27.12.15 23:59:45</div><div class=""><span style="white-space: pre-wrap;" class=""> </span>[1451602785000,155.903,22587],<span style="white-space: pre-wrap;" class=""> </span>-><span style="white-space: pre-wrap;" class=""> </span>31.12.15 23:59:45<span style="white-space: pre-wrap;" class=""> </span></div><div class=""><span style="white-space: pre-wrap;" class=""> </span>[1451861985000,50.125,17280],<span style="white-space: pre-wrap;" class=""> </span>-<font color="#e63b7a" class=""><b class="">><span style="white-space: pre-wrap;" class=""> </span>03.01.16 23:59:45</b></font></div><div class=""><span style="white-space: pre-wrap;" class=""> </span>[1452466785000,138.161,39864],<span style="white-space: pre-wrap;" class=""> </span>-><span style="white-space: pre-wrap;" class=""> </span>10.01.16 23:59:45</div><div class=""><span style="white-space: pre-wrap;" class=""> </span>[1452985230000,75.092,34016]<span style="white-space: pre-wrap;" class=""> </span>-><span style="white-space: pre-wrap;" class=""> </span>17.01.16 00:00:30</div><div class=""><span style="white-space: pre-wrap;" class=""> </span>],</div>...<div class=""><span style="white-space: pre-wrap;" class=""> </span>}</div><div class="">]}</div><div class=""><br class=""></div><div class="">Wer kann mir sagen, warum der 31.12. hier als tuple mit-ausgegeben wird? Hat der letzte Tag des Jahres eine besondere Bedeutung für die<i class=""><span class="Apple-converted-space"> </span>group=week</i>?</div></div></blockquote><div class=""><br class=""></div><div class="">Sehr gute Frage. Die Antwort liegt hier:<span class="Apple-converted-space"> </span><a href="https://github.com/volkszaehler/volkszaehler.org/blob/master/lib/Interpreter/SQL/MySQLOptimizer.php#L63" class="">https://github.com/volkszaehler/volkszaehler.org/blob/master/lib/Interpreter/SQL/MySQLOptimizer.php#L63</a><br class=""><br class=""></div><div class="">Mittlerweile (?) gibts bei MySQL eine Funktion YEARWEEK() die das gewünschte Ergebnis bringen sollte.<br class=""><br class=""></div><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;"><div style="word-wrap: break-word;" class=""><div class=""><br class=""></div><div class="">Viele Grüße</div><div class="">Armin</div></div></blockquote></div><br class=""></div><div class="gmail_extra">Wollen wir das ändern?<br class=""><br class=""></div><div class="gmail_extra">Viele Grüße,<br class=""></div><div class="gmail_extra">Andreas</div></div></div></blockquote></div><br class=""></div></body></html>