chamilo-lms/public/main/my_space/ti_report.php

<?php

/* For licensing terms, see /license.txt */

use Chamilo\CoreBundle\Entity\Session;

$cidReset = true;

require_once __DIR__.'/../inc/global.inc.php';

$this_section = SECTION_TRACKING;

$tblSession = Database::get_main_table(TABLE_MAIN_SESSION);
$tblSessionRelUser = Database::get_main_table(TABLE_MAIN_SESSION_USER);

$csv_content = [];
$nameTools = get_lang('MySpace');

$allowToTrack = api_is_platform_admin(true, true);
if (!$allowToTrack) {
    api_not_allowed(true);
}

$userInfo = [];
$action = $_REQUEST['a'] ?? null;
$content = '';
switch ($action) {
    case 'add_user':
        break;
}

Display::display_header($nameTools);
echo '<div class="actions">';
echo MySpace::getTopMenu();
echo '</div>';
echo MySpace::getAdminActions();

echo '<style>
    .session_block {
        width: 120px;
        overflow: hidden;
        text-overflow: ellipsis;
        color:#fff;
    }

   .session_block .label {
        width: 120px;
    }

    table th{
        text-align: center;
        width: 300px;
    }

</style>';

$form = new FormValidator('users', 'get', api_get_self().'?a=users_active');
$form->addDateRangePicker(
    'daterange',
    get_lang('Date range'),
    true,
    ['format' => 'YYYY-MM-DD', 'timePicker' => 'false', 'validate_format' => 'Y-m-d']
);
$form->addHidden('a', 'users_active');
$form->addButtonFilter(get_lang('Search'));

$weekFormat = 'oW';

if ($form->validate()) {
    $values = $form->getSubmitValues();
    $startDate = Database::escape_string($values['daterange_start']);
    $endDate = Database::escape_string($values['daterange_end']);
    //$startDate = Database::escape_string($_REQUEST['daterange_start']);
    //$endDate = Database::escape_string($_REQUEST['daterange_end']);

    $date = new DateTime($startDate);
    $weekStart = $date->format($weekFormat);

    $date = new DateTime($endDate);
    $weekEnd = $date->format($weekFormat);
    $first = DateTime::createFromFormat('Y-m-d', $startDate);
    $second = DateTime::createFromFormat('Y-m-d', $endDate);
    $numberOfWeeks = floor($first->diff($second)->days / 7);

    $sql = "SELECT sru.user_id, s.name, s.id as session_id, s.display_start_date, s.display_end_date
            FROM $tblSession s
            LEFT JOIN $tblSessionRelUser sru 
            ON (sru.session_id = s.id AND sru.relation_type = ".Session::GENERAL_COACH.")
            WHERE s.display_start_date BETWEEN '$startDate' AND '$endDate'
            ORDER BY sru.user_id";
    $result = Database::query($sql);

    $coachList = [];
    while ($row = Database::fetch_array($result, 'ASSOC')) {
        $coachId = $row['user_id'];
        if (!isset($coachList[$coachId])) {
            $userInfo = api_get_user_info($coachId);
            $coachList[$coachId]['complete_name'] = $userInfo['complete_name'];
            $coachList[$coachId]['session_count'] = 0;
        }

        // Start
        $date = new DateTime($row['display_start_date']);
        $week = $date->format($weekFormat);
        $coachList[$coachId]['week'][$week]['sessions'][] = $row;

        // End
        $endDate = new DateTime($row['display_end_date']);
        $endWeek = $endDate->format($weekFormat);

        $numberOfWeeksBetween = floor($date->diff($endDate)->days / 7);

        for ($i = 0; $i < $numberOfWeeksBetween; $i++) {
            $date->add(new DateInterval('P1W'));
            $week = $date->format($weekFormat);
            $coachList[$coachId]['week'][$week]['sessions'][] = $row;
        }

        $coachList[$coachId]['session_count']++;
        $coachList[$coachId]['data'] = $row;
    }

    $table = new HTML_Table(['class' => 'table table-responsive']);
    $headers = [
        get_lang('Coach'),
        get_lang('Sessions'),
    ];

    $date = new DateTime($startDate);
    for ($i = 0; $i <= $numberOfWeeks; $i++) {
        $headers[] = $date->format('o-W');
        $date->add(new DateInterval('P1W'));
    }

    $width = ' width:300px;';
    $row = 0;
    $column = 0;
    foreach ($headers as $header) {
        $table->setHeaderContents($row, $column, $header);
        $table->updateCellAttributes(
            $row,
            $column,
            'style="'.$width.'"'
        );
        $column++;
    }
    $row++;
    $url = api_get_path(WEB_CODE_PATH).'session/resume_session.php?';
    foreach ($coachList as $coachData) {
        $column = 0;
        $table->updateCellAttributes(
            $row,
            $column,
            'style="'.$width.'"'
        );
        $table->setCellContents($row, $column++, $coachData['complete_name']);

        $table->updateCellAttributes(
            $row,
            $column,
            'style="'.$width.'"'
        );
        $table->setCellContents($row, $column++, $coachData['session_count']);

        $date = new DateTime($startDate);
        $sessionAdded = [];
        for ($i = 2; $i <= $numberOfWeeks; $i++) {
            $dateWeekToCheck = $date->format($weekFormat);
            if (isset($coachData['week'][$dateWeekToCheck])) {
                $sessionArray = [];
                foreach ($coachData['week'][$dateWeekToCheck]['sessions'] as $session) {
                    $date2 = new DateTime($session['display_start_date']);
                    $name = $session['name'];

                    $showName = true;
                    if (in_array($session['session_id'], $sessionAdded)) {
                        $showName = false;
                    } else {
                        $sessionAdded[] = $session['session_id'];
                    }

                    if (false === $showName) {
                        $name = '';
                    }
                    $sessionArray[] = Display::url(
                        $name,
                        $url.'id_session='.$session['session_id'],
                        ['class' => 'label label-success', 'target' => '_blank', 'title' => addslashes($session['name'])]
                    );
                }
                $value = implode('<br /><br />', $sessionArray);
                $value = "<div class='session_block'> $value </div>";
                $table->setCellContents($row, $i, $value);
                $table->updateCellAttributes(
                    $row,
                    $i,
                    'style="background:green; '.$width.'"'
                );
            } else {
                $table->setCellContents($row, $i, '<div class="session_block"></div>');
                $table->updateCellAttributes(
                    $row,
                    $i,
                    'style="'.$width.'"'
                );
            }
            $date->add(new DateInterval('P1W'));
        }
        $row++;
    }

    $content = $table->toHtml();
}

echo $form->returnForm();
echo $content;

Display::display_footer();