<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">2016-01-21 12:29 GMT+01:00 application MGR <span dir="ltr"><<a href="mailto:applicationMGR@ecocuyo.de" target="_blank">applicationMGR@ecocuyo.de</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div style="word-wrap:break-word"><div>Hallo @</div><div><br></div><div>mit folgender Abfrage mit Startdatum <i>20.12.15 00:00:00</i> und Enddatum <i>17.01.16 00:00:00:</i></div><div><br></div><div>http://<localhost>/middleware.php/data.json?from=1450566000000&to=1452985200000&group=week&%20uuid%5B%5D=xxxxxxxx-xxxx-xxxx-xxxx-695ed220d33d</div><div><br></div><div>erhalte ich folgende Antwort von der Middleware:</div><div><br></div><div>{"version":"0.3","data”:[</div><div><span style="white-space:pre-wrap">    </span>{</div><div><span style="white-space:pre-wrap">                </span>"tuples”:[</div><div><span style="white-space:pre-wrap">                                </span>[1451257185000,159.436,39831], <span style="white-space:pre-wrap">                </span>-> <span style="white-space:pre-wrap"> </span>27.12.15 23:59:45</div><div><span style="white-space:pre-wrap">                                </span>[1451602785000,155.903,22587],<span style="white-space:pre-wrap">          </span>-><span style="white-space:pre-wrap">   </span>31.12.15 23:59:45<span style="white-space:pre-wrap">       </span></div><div><span style="white-space:pre-wrap">                         </span>[1451861985000,50.125,17280],<span style="white-space:pre-wrap">           </span>-<font color="#e63b7a"><b>><span style="white-space:pre-wrap">    </span>03.01.16 23:59:45</b></font></div><div><span style="white-space:pre-wrap">                         </span>[1452466785000,138.161,39864],<span style="white-space:pre-wrap">          </span>-><span style="white-space:pre-wrap">   </span>10.01.16 23:59:45</div><div><span style="white-space:pre-wrap">                                </span>[1452985230000,75.092,34016]<span style="white-space:pre-wrap">            </span>-><span style="white-space:pre-wrap">   </span>17.01.16 00:00:30</div><div><span style="white-space:pre-wrap">                        </span>],</div>...<div><span style="white-space:pre-wrap">    </span>}</div><div>]}</div><div><br></div><div>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> group=week</i>?</div></div></blockquote><div><br></div><div>Sehr gute Frage. Die Antwort liegt hier: <a href="https://github.com/volkszaehler/volkszaehler.org/blob/master/lib/Interpreter/SQL/MySQLOptimizer.php#L63">https://github.com/volkszaehler/volkszaehler.org/blob/master/lib/Interpreter/SQL/MySQLOptimizer.php#L63</a><br><br></div><div>Mittlerweile (?) gibts bei MySQL eine Funktion YEARWEEK() die das gewünschte Ergebnis bringen sollte.<br><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div style="word-wrap:break-word"><div><br></div><div>Viele Grüße</div><div>Armin</div></div></blockquote></div><br></div><div class="gmail_extra">Wollen wir das ändern?<br><br></div><div class="gmail_extra">Viele Grüße,<br></div><div class="gmail_extra">Andreas<br><br></div></div>