chamilo / chamilo-lms

 * @return array $user_info array user_id, lastname, firstname, username, email

 * @author Yannick Warnier <[email protected]>

 */

function api_get_user_info_from_username($username = '')

{

    if (empty($username)) {

        return false;

    }

    $username = trim($username);

    $sql = "SELECT * FROM ".Database :: get_main_table(TABLE_MAIN_USER)."

            WHERE username='".Database::escape_string($username)."'";

    $result = Database::query($sql);

    if (Database::num_rows($result) > 0) {

        $result_array = Database::fetch_array($result);

        return _api_format_user($result_array);

    }

    return false;

}

/**

 * Get first user with an email

 * @param string $email

 * @return array|bool

 */

function api_get_user_info_from_email($email = '')

{

    if (empty($email)) {

        return false;

    }

    $sql = "SELECT * FROM ".Database :: get_main_table(TABLE_MAIN_USER)."

            WHERE email ='".Database::escape_string($email)."' LIMIT 1";

    $result = Database::query($sql);

    if (Database::num_rows($result) > 0) {

        $result_array = Database::fetch_array($result);

        return _api_format_user($result_array);

    }

    return false;

}

/**

 * @return string

 * @return array $user_info user_id, lastname, firstname, username, email, ...

 * @author Yannick Warnier <[email protected]>

 */

function api_get_user_info_from_official_code($officialCode)

{

    if (empty($officialCode)) {

        return false;

    }

    $sql = "SELECT * FROM ".Database :: get_main_table(TABLE_MAIN_USER)."

            WHERE official_code ='".Database::escape_string($officialCode)."'";

    $result = Database::query($sql);

    if (Database::num_rows($result) > 0) {

        $result_array = Database::fetch_array($result);

        return _api_format_user($result_array);

    }

    return false;

}

/**

 * @param string $usernameInputId

     *

     * @return    string|bool Date format long without day or false if there are no connections

     */

    public static function get_first_connection_date($student_id)

    {

    	$tbl_track_login = Database :: get_main_table(TABLE_STATISTIC_TRACK_E_LOGIN);

    	$sql = 'SELECT login_date

    	        FROM ' . $tbl_track_login . '

                WHERE login_user_id = ' . intval($student_id) . '

                ORDER BY login_date ASC

                LIMIT 0,1';

    	$rs = Database::query($sql);

    	if (Database::num_rows($rs)>0) {

    		if ($first_login_date = Database::result($rs, 0, 0)) {

                return api_convert_and_format_date(

                    $first_login_date,

                    DATE_FORMAT_SHORT,

                    date_default_timezone_get()

                );

    		}

    	}

    	return false;

    }

    /**

     * Get las connection date for a student