public static function getItems($period, $user, $yachs = 'ntime', $sport = '*', $currentpage = 'weekpage')
{
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('YEARWEEK(a.tdate ,1) AS weeknr, count( DISTINCT (date( a.tdate ))) AS TT, count(DISTINCT(a.id)) AS TE,' . 'sum( i.km * sc.multiplier) AS km, sum( i.climb ) AS climb, sum( i.etime ) AS ntime, sum( i.ntime ) AS ntime,' . 'sum(i.' . $yachs . '*(c.group=1)) as RECOM,sum(i.' . $yachs . '*(c.group=2)) as GA1,sum(i.' . $yachs . '*(c.group=3)) as KA1,' . 'sum(i.' . $yachs . '*(c.group=4)) as GA2,sum(i.' . $yachs . '*(c.group=5)) as KA2,sum(i.' . $yachs . '*(c.group=6)) as WSA,' . 'sum(i.' . $yachs . '*(c.group=0)) as Alt');
$query->from($db->quoteName('#__htraininglogs_tr_sessions') . ' AS a,' . $db->quoteName('#__htraininglogs_tr_splittimes') . ' AS s,' . $db->quoteName('#__htraininglogs_tr_intensitylevels') . 'as i,' . $db->quoteName('#__htraininglogs_cfg_sport') . 'AS sc,' . $db->quoteName('#__htraininglogs_cfg_intensity') . ' AS c');
if ($sport != '*') {
$query->where('a.sport_id in (' . $sport . ')');
}
$query->where('a.id = s.tr_id');
$query->where('s.id = i.split_id');
$query->where('a.sport_id = sc.id');
$query->where('a.user_id = ' . $user->id);
$query->where('a.state = 1');
$query->where('i.state = 1');
$query->where('i.int_id = c.id');
$query->where('a.tdate BETWEEN "' . $period->anfdat->format('Y-m-d') . ' 0:00:00" AND "' . $period->enddat->format('Y-m-d') . ' 23:59:59"');
$query->group('weeknr');
$query->order('a.tdate DESC');
$db->setQuery($query);
$items = $db->loadObjectlist();
$yearwkanf = $period->enddat->format('oW');
$yearwkend = $period->anfdat->format('oW');
$yearanf = $yearwkanf[0] . $yearwkanf[1] . $yearwkanf[2] . $yearwkanf[3];
$kwanf = $yearwkanf[4] . $yearwkanf[5];
$yearend = $yearwkend[0] . $yearwkend[1] . $yearwkend[2] . $yearwkend[3];
$kwend = $yearwkend[4] . $yearwkend[5];
$i = 0;
$itemsfull = array();
$itemnew = new stdClass();
$itemnew->week = 0;
while ($yearanf > $yearend or $kwanf > $kwend) {
$item = $items[$i];
$year = $item->weeknr[0] . $item->weeknr[1] . $item->weeknr[2] . $item->weeknr[3];
$kw = $item->weeknr[4] . $item->weeknr[5];
if ($yearanf == $year and $kwanf == $kw) {
$i++;
$item->weekstart = HTraininglogsHelper::get_monday_of_week($kw, $year);
$datum = new DateTime($item->weekstart);
$datum = date_modify($datum, '+6 day');
$item->weekend = $datum->format('Y-m-d');
$item->weeknr = $kw . '/' . $year;
array_push($itemsfull, $item);
} else {
$j = array_push($itemsfull, new $itemnew());
$itemsfull[$j - 1]->TT = 0;
$itemsfull[$j - 1]->TE = 0;
$itemsfull[$j - 1]->km = 0;
$itemsfull[$j - 1]->climb = 0;
$itemsfull[$j - 1]->ntime = 0;
$itemsfull[$j - 1]->ntime = 0;
$itemsfull[$j - 1]->RECOM = 0;
$itemsfull[$j - 1]->GA1 = 0;
$itemsfull[$j - 1]->KA1 = 0;
$itemsfull[$j - 1]->GA2 = 0;
$itemsfull[$j - 1]->KA2 = 0;
$itemsfull[$j - 1]->WSA = 0;
$itemsfull[$j - 1]->Alt = 0;
$itemsfull[$j - 1]->weekstart = HTraininglogsHelper::get_monday_of_week($kwanf, $yearanf);
$datum = new DateTime($itemsfull[$j - 1]->weekstart);
$datum = date_modify($datum, '+6 day');
$itemsfull[$j - 1]->weekend = $datum->format('Y-m-d');
$itemsfull[$j - 1]->weeknr = $kwanf . '/' . $yearanf;
}
$kwanf--;
if ($kwanf == 0) {
$kwanf = date("W", mktime(0, 0, 0, 12, 28, --$yearanf));
}
}
return $itemsfull;
}
