+global\Tracking::get_last_connection_date_on_the_course()

Complexity

Conditions	9
Paths	8

Size

Total Lines	54
Code Lines	37

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

<?php
    public static function get_last_connection_date_on_the_course(
        $student_id,
        $courseInfo,
        $session_id = 0,
        $convert_date = true
    ) {
    	// protect data
    	$student_id  = intval($student_id);
        $courseId = $courseInfo['real_id'];
    	$session_id  = intval($session_id);

    	$tbl_track_e_access = Database :: get_main_table(TABLE_STATISTIC_TRACK_E_ACCESS);
    	$sql = 'SELECT access_date
                FROM '.$tbl_track_e_access.'
                WHERE   access_user_id = '.$student_id.' AND
                        c_id = "'.$courseId.'" AND
                        access_session_id = '.$session_id.'
                ORDER BY access_date DESC
                LIMIT 0,1';

    	$rs = Database::query($sql);
    	if (Database::num_rows($rs) > 0) {
    		if ($last_login_date = Database::result($rs, 0, 0)) {
                if (empty($last_login_date) || $last_login_date == '0000-00-00 00:00:00') {
                    return false;
                }
                //see #5736
                $last_login_date_timestamp = api_strtotime($last_login_date);
    			$now = time();
    			//If the last connection is > than 7 days, the text is red
    			//345600 = 7 days in seconds
    			if ($now - $last_login_date_timestamp > 604800) {
    				if ($convert_date) {
                        $last_login_date = api_convert_and_format_date($last_login_date, DATE_FORMAT_SHORT);
                        $icon = api_is_allowed_to_edit() ?
                            '<a href="'.api_get_path(REL_CODE_PATH).'announcements/announcements.php?action=add&remind_inactive='.$student_id.'&cidReq='.$courseInfo['code'].'" title="'.get_lang('RemindInactiveUser').'">
                              '.Display::return_icon('messagebox_warning.gif').'
                             </a>'
                            : null;
    					return $icon. Display::label($last_login_date, 'warning');
    				} else {
    					return $last_login_date;
    				}
    			} else {
    				if ($convert_date) {
    					return api_convert_and_format_date($last_login_date, DATE_FORMAT_SHORT);
    				} else {
    					return $last_login_date;
    				}
    			}
    		}
    	}
    	return false;
    }