12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271 |
- <?php
- class Display {
- private function __construct() {
- }
-
- public static function display_introduction_section($tool, $editor_config = null) {
- $is_allowed_to_edit = api_is_allowed_to_edit();
- $moduleId = $tool;
- if (api_get_setting('enable_tool_introduction') == 'true' || $tool == TOOL_COURSE_HOMEPAGE) {
- require api_get_path(INCLUDE_PATH).'introductionSection.inc.php';
- }
- }
-
- public static function display_localised_html_file($full_file_name) {
- global $language_interface;
- $localised_file_name = $full_file_name.'_'.$language_interface.'.html';
- $default_file_name = $full_file_name.'.html';
- if (file_exists($localised_file_name)) {
- include $localised_file_name;
- } else {
- include ($default_file_name);
- }
- }
-
-
-
- public static function display_complex_table_header($properties, $column_header) {
- $width = $properties['width'];
- if (!isset($width)) {
- $width = '85%';
- }
- $class = $properties['class'];
- if (!isset($class)) {
- $class = 'class="data_table"';
- }
- $cellpadding = $properties['cellpadding'];
- if (!isset($cellpadding)) {
- $cellpadding = '4';
- }
- $cellspacing = $properties['cellspacing'];
- if (!isset ($cellspacing)) {
- $cellspacing = '0';
- }
-
-
- $bgcolor = 'bgcolor="'.DOKEOSLIGHTGREY.'"';
- echo '<table '.$class.' border="0" cellspacing="$cellspacing" cellpadding="'.$cellpadding.'" width="'.$width.'">'."\n";
- echo '<thead><tr '.$bgcolor.'>';
- foreach ($column_header as & $table_element) {
- echo '<th>'.$table_element.'</th>';
- }
- echo "</tr></thead>\n";
- echo "<tbody>\n";
- $bgcolor = 'bgcolor="'.HTML_WHITE.'"';
- return $bgcolor;
- }
-
- public static function display_table_row($bgcolor, $table_row, $is_alternating = true) {
- echo '<tr '.$bgcolor.'>';
- foreach ($table_row as & $table_element) {
- echo '<td>'.$table_element.'</td>';
- }
- echo "</tr>\n";
- if ($is_alternating) {
- if ($bgcolor == 'bgcolor="'.HTML_WHITE.'"') {
- $bgcolor = 'bgcolor="'.DOKEOSLIGHTGREY.'"';
- } elseif ($bgcolor == 'bgcolor="'.DOKEOSLIGHTGREY.'"') {
- $bgcolor = 'bgcolor="'.HTML_WHITE.'"';
- }
- }
- return $bgcolor;
- }
-
- public static function display_sortable_table($header, $content, $sorting_options = array(), $paging_options = array(), $query_vars = null, $form_actions = array(), $style = 'table') {
- if (!class_exists('SortableTable')) {
- require_once 'sortabletable.class.php';
- }
- global $origin;
- $column = isset($sorting_options['column']) ? $sorting_options['column'] : 0;
- $default_items_per_page = isset($paging_options['per_page']) ? $paging_options['per_page'] : 20;
- $table = new SortableTableFromArray($content, $column, $default_items_per_page);
- if (is_array($query_vars)) {
- $table->set_additional_parameters($query_vars);
- }
- if ($style == 'table') {
- if (is_array($header) && count($header) > 0) {
- foreach ($header as $index => $header_item) {
- $table->set_header($index, $header_item[0], $header_item[1], $header_item[2], $header_item[3]);
- }
- }
- $table->set_form_actions($form_actions);
- $table->display();
- } else {
- $table->display_grid();
- }
- }
-
- public static function display_sortable_grid($name, $header, $content, $paging_options = array(), $query_vars = null, $form_actions = array(), $visibility_options = true, $sort_data = true, $grid_class = array()) {
- echo self::return_sortable_grid($name, $header, $content, $paging_options, $query_vars, $form_actions, $visibility_options, $sort_data, $grid_class);
- }
-
- public static function return_sortable_grid($name, $header, $content, $paging_options = array(), $query_vars = null, $form_actions = array(), $visibility_options = true, $sort_data = true, $grid_class = array()) {
- if (!class_exists('SortableTable')) {
- require_once 'sortabletable.class.php';
- }
- global $origin;
- $column = 0;
- $default_items_per_page = isset($paging_options['per_page']) ? $paging_options['per_page'] : 20;
- $table = new SortableTableFromArray($content, $column, $default_items_per_page, $name);
- if (is_array($query_vars)) {
- $table->set_additional_parameters($query_vars);
- }
- return $table->display_simple_grid($visibility_options, $paging_options['hide_navigation'], $default_items_per_page, $sort_data, $grid_class);
- }
-
- public static function display_sortable_config_table($table_name, $header, $content, $sorting_options = array(), $paging_options = array(), $query_vars = null, $column_show = array(), $column_order = array(), $form_actions = array()) {
- if (!class_exists('SortableTable')) {
- require_once 'sortabletable.class.php';
- }
- global $origin;
- $column = isset($sorting_options['column']) ? $sorting_options['column'] : 0;
- $default_items_per_page = isset($paging_options['per_page']) ? $paging_options['per_page'] : 20;
- $table = new SortableTableFromArrayConfig($content, $column, $default_items_per_page, $table_name, $column_show, $column_order);
- if (is_array($query_vars)) {
- $table->set_additional_parameters($query_vars);
- }
-
- if (is_array($column_show)) {
- for ($i = 0; $i < count($column_show); $i++) {
- if (!empty($column_show[$i])) {
- $val0 = isset($header[$i][0]) ? $header[$i][0] : null;
- $val1 = isset($header[$i][1]) ? $header[$i][1] : null;
- $val2 = isset($header[$i][2]) ? $header[$i][2] : null;
- $val3 = isset($header[$i][3]) ? $header[$i][3] : null;
- $table->set_header($i, $val0, $val1, $val2, $val3);
- }
- }
- }
- $table->set_form_actions($form_actions);
- $table->display();
- }
-
- public static function display_normal_message($message, $filter = true) {
- if ($filter) {
-
- $message = api_htmlentities($message, ENT_QUOTES, api_is_xml_http_request() ? 'UTF-8' : api_get_system_encoding());
- }
- echo '<div class="normal-message">';
- echo $message.'</div>';
- }
-
- public static function display_warning_message($message, $filter = true) {
- if ($filter){
-
- $message = api_htmlentities($message, ENT_QUOTES, api_is_xml_http_request() ? 'UTF-8' : api_get_system_encoding());
- }
- echo '<div class="warning-message">';
- echo $message.'</div>';
- }
-
- public static function display_confirmation_message ($message, $filter = true) {
- if ($filter){
-
- $message = api_htmlentities($message, ENT_QUOTES, api_is_xml_http_request() ? 'UTF-8' : api_get_system_encoding());
- }
- echo '<div class="confirmation-message">';
- echo $message.'</div>';
- }
-
- public static function display_error_message ($message, $filter = true) {
- if($filter){
-
- $message = api_htmlentities($message, ENT_QUOTES, api_is_xml_http_request() ? 'UTF-8' : api_get_system_encoding());
- }
- echo '<div class="error-message">'.$message.'</div>';
- }
-
- public function return_message($message, $type='normal', $filter = true) {
- if ($filter) {
- $message = Security::remove_XSS($message);
- }
- switch($type) {
- case 'warning':
- $class = 'warning-message';
- break;
- case 'error':
- $class = 'error-message';
- break;
- case 'normal':
- case 'confirmation-message':
- default:
- $class = 'normal-message';
- }
- return self::div($message, array('class'=>$class));
- }
-
- public static function encrypted_mailto_link ($email, $clickable_text = null, $style_class = '') {
- if (is_null($clickable_text)) {
- $clickable_text = $email;
- }
-
- if (substr($email, 0, 7) != 'mailto:') {
- $email = 'mailto:'.$email;
- }
-
- if ($style_class != '') {
- $style_class = ' class="'.$style_class.'"';
- }
-
- $hmail = '';
- for ($i = 0; $i < strlen($email); $i ++) {
- $hmail .= '&#'.ord($email {
- $i }).';';
- }
- $hclickable_text = null;
-
- if (strpos($clickable_text, '@')) {
- for ($i = 0; $i < strlen($clickable_text); $i ++) {
- $hclickable_text .= '&#'.ord($clickable_text {
- $i }).';';
- }
- } else {
- $hclickable_text = @htmlspecialchars($clickable_text, ENT_QUOTES, api_get_system_encoding());
- }
-
- return '<a href="'.$hmail.'"'.$style_class.' name="clickable_email_link">'.$hclickable_text.'</a>';
- }
-
- public static function get_platform_home_link_html($name = '') {
- if ($name == '') {
- $name = api_get_setting('siteName');
- }
- return '<a href="'.api_get_path(WEB_PATH).'index.php">'.$name.'</a>';
- }
-
- public static function display_header($tool_name ='', $help = null) {
- $nameTools = $tool_name;
- global $_plugins, $lp_theme_css, $mycoursetheme, $user_theme, $platform_theme;
- global $httpHeadXtra, $htmlHeadXtra, $htmlIncHeadXtra, $_course, $_user, $clarolineRepositoryWeb, $text_dir, $plugins, $_user, $rootAdminWeb, $_cid, $interbreadcrumb, $charset, $language_file, $noPHP_SELF;
- global $menu_navigation;
- require api_get_path(INCLUDE_PATH).'header.inc.php';
- }
-
- public static function display_reduced_header () {
- global $_plugins, $lp_theme_css, $mycoursetheme, $user_theme, $platform_theme;
- global $httpHeadXtra, $htmlHeadXtra, $htmlIncHeadXtra, $_course, $_user, $clarolineRepositoryWeb, $text_dir, $plugins, $_user, $rootAdminWeb, $_cid, $interbreadcrumb, $charset, $language_file, $noPHP_SELF, $language_interface;
- global $menu_navigation;
- require api_get_path(INCLUDE_PATH).'reduced_header.inc.php';
- }
-
- public static function display_footer () {
- global $_plugins;
- require api_get_path(INCLUDE_PATH).'footer.inc.php';
- }
-
- public static function get_alphabet_options($selected_letter = '') {
- $result = '';
- for ($i = 65; $i <= 90; $i ++) {
- $letter = chr($i);
- $result .= '<option value="'.$letter.'"';
- if ($selected_letter == $letter) {
- $result .= ' selected="selected"';
- }
- $result .= '>'.$letter.'</option>';
- }
- return $result;
- }
- public static function get_numeric_options($min, $max, $selected_num = 0) {
- $result = '';
- for ($i = $min; $i <= $max; $i ++) {
- $result .= '<option value="'.$i.'"';
- if (is_int($selected_num))
- if ($selected_num == $i) {
- $result .= ' selected="selected"';
- }
- $result .= '>'.$i.'</option>';
- }
- return $result;
- }
-
- public static function show_course_navigation_menu($isHidden = false) {
- global $output_string_menu;
- global $_setting;
-
- if (strpos($_SERVER['REQUEST_URI'], '?') === false) {
- $sourceurl = api_get_self().'?';
- } else {
- $sourceurl = $_SERVER['REQUEST_URI'];
- }
- $output_string_menu = '';
- if ($isHidden == 'true' and $_SESSION['hideMenu']) {
- $_SESSION['hideMenu'] = 'hidden';
- $sourceurl = str_replace('&isHidden=true', '', $sourceurl);
- $sourceurl = str_replace('&isHidden=false', '', $sourceurl);
- $output_string_menu .= ' <a href="'.$sourceurl.'&isHidden=false"><img src="../../main/img/expand.gif" alt="'.'Show menu1'.'" padding:"2px"/></a>';
- } elseif ($isHidden == 'false' && $_SESSION['hideMenu']) {
- $sourceurl = str_replace('&isHidden=true', '', $sourceurl);
- $sourceurl = str_replace('&isHidden=false', '', $sourceurl);
- $_SESSION['hideMenu'] = 'shown';
- $output_string_menu .= '<div id="leftimg"><a href="'.$sourceurl.'&isHidden=true"><img src="../../main/img/collapse.gif" alt="'.'Hide menu2'.'" padding:"2px"/></a></div>';
- } elseif ($_SESSION['hideMenu']) {
- if ($_SESSION['hideMenu'] == 'shown') {
- $output_string_menu .= '<div id="leftimg"><a href="'.$sourceurl.'&isHidden=true"><img src="../../main/img/collapse.gif" alt="'.'Hide menu3'.' padding:"2px"/></a></div>';
- }
- if ($_SESSION['hideMenu'] == 'hidden') {
- $sourceurl = str_replace('&isHidden=true', '', $sourceurl);
- $output_string_menu .= '<a href="'.$sourceurl.'&isHidden=false"><img src="../../main/img/expand.gif" alt="'.'Hide menu4'.' padding:"2px"/></a>';
- }
- } elseif (!$_SESSION['hideMenu']) {
- $_SESSION['hideMenu'] = 'shown';
- if (isset($_cid)) {
- $output_string_menu .= '<div id="leftimg"><a href="'.$sourceurl.'&isHidden=true"><img src="main/img/collapse.gif" alt="'.'Hide menu5'.' padding:"2px"/></a></div>';
- }
- }
- }
-
- public static function display_icon($image, $alt_text = '', $additional_attributes = array(), $size=null) {
- echo self::return_icon($image, $alt_text, $additional_attributes, $size);
- }
-
- public static function return_icon($image, $alt_text = '', $additional_attributes = array(), $size=null) {
- $code_path = api_get_path(SYS_CODE_PATH);
- $w_code_path = api_get_path(WEB_CODE_PATH);
-
- $image = trim($image);
- $theme = 'css/'.api_get_visual_theme().'/icons/';
- $icon = '';
- $size_extra = '';
- if (isset($size)) {
- $size = intval($size);
- if (in_array($size,array(16,22,32,48,64,128))) {
- $size_extra = $size.'/';
- }
- }
- if (is_file($code_path.$theme.$size_extra.$image)) {
- $icon = $w_code_path.$theme.$size_extra.$image;
- } elseif (is_file($code_path.'img/icons/'.$size_extra.$image)) {
- $icon = $w_code_path.'img/icons/'.$size_extra.$image;
- } else {
- $icon = $w_code_path.'img/'.$image;
- }
- return self::img($icon, $alt_text,$additional_attributes);
- }
-
- public static function img($image_path, $alt_text = '', $additional_attributes = array()) {
-
- $image_path = Security::filter_img_path($image_path);
- $attribute_list = '';
-
- if ($alt_text == '') {
- $alt_text = basename($image_path);
- }
- $additional_attributes['src'] = $image_path;
- if (empty($additional_attributes['alt'])) {
- $additional_attributes['alt'] = $alt_text;
- }
- if (empty($additional_attributes['title'])) {
- $additional_attributes['title'] = $alt_text;
- }
-
- return self::tag('img', '', $additional_attributes);
- }
-
- public static function tag($tag, $content, $additional_attributes = array()) {
- $attribute_list = '';
-
- if (!empty($additional_attributes) && is_array($additional_attributes)) {
- $attribute_list = '';
- foreach ($additional_attributes as $key => & $value) {
- $attribute_list .= $key.'="'.$value.'" ';
- }
- }
-
- if (in_array($tag, array('img','input','br'))) {
- $return_value = '<'.$tag.' '.$attribute_list.' />';
- } else {
- $return_value = '<'.$tag.' '.$attribute_list.' > '.$content.'</'.$tag.'>';
- }
- return $return_value;
- }
-
- public static function url($name, $url, $extra_attributes = array()) {
- if (!empty($url)) {
- $extra_attributes['href']= $url;
- }
- return self::tag('a', $name, $extra_attributes);
- }
-
- public static function div($content, $extra_attributes = array()) {
- return self::tag('div', $content, $extra_attributes);
- }
-
- public static function span($content, $extra_attributes = array()) {
- return self::tag('span', $content, $extra_attributes);
- }
-
- public static function input($type, $name, $value, $extra_attributes = array()) {
- if (!empty($type)) {
- $extra_attributes['type']= $type;
- }
- if (!empty($name)) {
- $extra_attributes['name']= $name;
- }
- if (!empty($value)) {
- $extra_attributes['value']= $value;
- }
- return self::tag('input', '',$extra_attributes);
- }
-
- public function select($name, $values, $default = -1, $extra_attributes = array(), $show_blank_item = true) {
- $extra = '';
- $default_id = 'id="'.$name.'" ';
- foreach($extra_attributes as $key=>$parameter) {
- if ($key == 'id') {
- $default_id = '';
- }
- $extra .= $key.'="'.$parameter.'"';
- }
- $html .= '<select name="'.$name.'" '.$default_id.' '.$extra.'>';
- if ($show_blank_item) {
- $html .= self::tag('option', '-- '.get_lang('Select').' --', array('value'=>'-1'));
- }
- if($values) {
- foreach($values as $key => $value) {
- if(is_array($value) && isset($value['name'])) {
- $value = $value['name'];
- }
- $html .= '<option value="'.$key.'"';
- if($default == $key) {
- $html .= 'selected="selected"';
- }
- $html .= '>'.$value.'</option>';
- }
- }
- $html .= '</select>';
- return $html;
- }
-
- public static function tabs($header_list, $content_list, $id = 'tabs', $ul_attributes = array()) {
- if (empty($header_list) || count($header_list) == 0 ) {
- return '';
- }
- $lis = '';
- $i = 1;
- foreach ($header_list as $item) {
- $item =self::tag('a', $item, array('href'=>'#'.$id.'-'.$i));
- $lis .=self::tag('li', $item, $ul_attributes);
- $i++;
- }
- $ul = self::tag('ul',$lis);
- $i = 1;
- $divs = '';
- foreach ($content_list as $content) {
- $content = self::tag('p',$content);
- $divs .=self::tag('div', $content, array('id'=>$id.'-'.$i));
- $i++;
- }
- $main_div = self::tag('div',$ul.$divs, array('id'=>$id));
- return $main_div ;
- }
-
- public static function grid_html($div_id){
- $table = self::tag('table','',array('id'=>$div_id));
- $table .= self::tag('div','',array('id'=>$div_id.'_pager'));
- return $table;
- }
-
- public static function form_row($label, $form_item) {
- $label = self::div($label, array('class' =>'label'));
- $form_item = self::div($form_item, array('class' =>'formw'));
- return self::div($label.$form_item, array('class'=>'row'));
- }
-
- public static function grid_js($div_id, $url, $column_names, $column_model, $extra_params, $data = array(), $formatter = '', $width_fix = false) {
- $obj = new stdClass();
- if (!empty($url))
- $obj->url = $url;
- $obj->colNames = $column_names;
- $obj->colModel = $column_model;
- $obj->pager = $div_id.'_pager';
- $obj->datatype = 'json';
- if (!empty($extra_params['datatype'])) {
- $obj->datatype = $extra_params['datatype'];
- }
-
- $obj->altRows = true;
- if (!empty($extra_params['altRows'])) {
- $obj->altRows = $extra_params['altRows'];
- }
- if (!empty($extra_params['sortname'])) {
- $obj->sortname = $extra_params['sortname'];
- }
-
- if (!empty($extra_params['sortorder'])) {
- $obj->sortorder = $extra_params['sortorder'];
- }
- if (!empty($extra_params['rowList'])) {
- $obj->rowList = $extra_params['rowList'];
- }
-
- $obj->rowNum = 20;
- if (!empty($extra_params['rowNum'])) {
- $obj->rowNum = $extra_params['rowNum'];
- }
-
- $obj->viewrecords = 'true';
- if (!empty($extra_params['viewrecords']))
- $obj->viewrecords = $extra_params['viewrecords'];
- if (!empty($extra_params)) {
- foreach ($extra_params as $key=>$element){
- $obj->$key = $element;
- }
- }
-
- if (!empty($data)) {
- $data_var = $div_id.'_data';
- $json.=' var '.$data_var.' = '.json_encode($data).';';
-
- $obj->data = $data_var;
- $obj->datatype = 'local';
- $json.="\n";
- }
- $json_encode = json_encode($obj);
- if (!empty($data)) {
-
- $json_encode = str_replace('"data":"'.$data_var.'"','"data":'.$data_var.'',$json_encode);
- }
-
- $json_encode = str_replace(':"true"',':true',$json_encode);
- $json_encode = str_replace(':"false"',':false',$json_encode);
- $json_encode = str_replace('"formatter":"action_formatter"','formatter:action_formatter',$json_encode);
- if ($width_fix) {
- if (is_numeric($width_fix)) {
- $width_fix = intval($width_fix);
- } else {
- $width_fix = '150';
- }
-
- $json .= "$(window).bind('resize', function() {
- $('#".$div_id."').setGridWidth($(window).width() - ".$width_fix.");
- }).trigger('resize');";
- }
-
- $json .= '$("#'.$div_id.'").jqGrid(';
- $json .= $json_encode;
- $json .= ');';
- $json.="\n";
-
- $json.=$formatter;
- return $json;
-
- }
- public static function table($headers, $rows) {
-
- }
-
-
-
-
-
-
-
- function show_notification($my_course) {
- $statistic_database = Database :: get_statistic_database();
- $user_id = api_get_user_id();
- $course_database = $my_course['db'];
- $course_tool_table = Database::get_course_table(TABLE_TOOL_LIST, $course_database);
- $tool_edit_table = Database::get_course_table(TABLE_ITEM_PROPERTY, $course_database);
- $course_group_user_table = Database :: get_course_table(TABLE_GROUP_USER, $course_database);
- $t_track_e_access = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_LASTACCESS);
- $my_course['k'] = Database::escape_string($my_course['k']);
- $my_course['id_session'] = intval($my_course['id_session']);
-
- $sqlLastTrackInCourse = "SELECT * FROM $t_track_e_access ".
- " USE INDEX (access_cours_code, access_user_id) ".
- "WHERE access_cours_code = '".$my_course['k']."' ".
- "AND access_user_id = '$user_id' AND access_session_id ='".$my_course['id_session']."'";
- $resLastTrackInCourse = Database::query($sqlLastTrackInCourse);
- $oldestTrackDate = $oldestTrackDateOrig = '3000-01-01 00:00:00';
- while ($lastTrackInCourse = Database::fetch_array($resLastTrackInCourse)) {
- $lastTrackInCourseDate[$lastTrackInCourse['access_tool']] = $lastTrackInCourse['access_date'];
- if ($oldestTrackDate > $lastTrackInCourse['access_date']) {
- $oldestTrackDate = $lastTrackInCourse['access_date'];
- }
- }
- if ($oldestTrackDate == $oldestTrackDateOrig) {
-
-
- $course_table = Database::get_main_table(TABLE_MAIN_COURSE);
- $sql = "SELECT course.creation_date ".
- "FROM $course_table course ".
- "WHERE course.code = '".$my_course['k']."'";
- $res = Database::query($sql);
- if ($res && Database::num_rows($res)>0) {
- $row = Database::fetch_array($res);
- }
- $oldestTrackDate = $row['creation_date'];
- }
-
- $sql = "SELECT tet.*, tet.lastedit_date last_date, tet.tool tool, tet.ref ref, ".
- " tet.lastedit_type type, tet.to_group_id group_id, ".
- " ctt.image image, ctt.link link ".
- " FROM $tool_edit_table tet, $course_tool_table ctt ".
- " WHERE tet.lastedit_date > '$oldestTrackDate' ".
- " AND ctt.name = tet.tool ".
- " AND ctt.visibility = '1' ".
- " AND tet.lastedit_user_id != $user_id AND tet.id_session = '".$my_course['id_session']."' ".
- " ORDER BY tet.lastedit_date";
- $res = Database::query($sql);
-
- $group_ids = GroupManager :: get_group_ids($course_database, $user_id);
- $group_ids[] = 0;
- $notifications = array();
-
- while ($res && ($item_property = Database::fetch_array($res))) {
-
-
- if ((!isset ($lastTrackInCourseDate[$item_property['tool']])
- || $lastTrackInCourseDate[$item_property['tool']] < $item_property['lastedit_date'])
-
-
- && ((in_array($item_property['to_group_id'], $group_ids)
-
- && ($item_property['tool'] != TOOL_DROPBOX
- && $item_property['tool'] != TOOL_NOTEBOOK
- && $item_property['tool'] != TOOL_CHAT)
- )
- )
-
- && ($item_property['visibility'] == '1'
- || ($my_course['s'] == '1' && $item_property['visibility'] == '0')
- || !isset($item_property['visibility'])))
- {
-
- if (($item_property['tool'] == TOOL_ANNOUNCEMENT
- || $item_property['tool'] == TOOL_CALENDAR_EVENT)
- && (($item_property['to_user_id'] != $user_id )
- && (!isset($item_property['to_group_id'])
- || !in_array($item_property['to_group_id'], $group_ids)))) {
- continue;
- }
-
- if ($item_property['tool'] == TOOL_SURVEY) {
- $survey_info = survey_manager::get_survey($item_property['ref'], 0, $my_course['k']);
- $invited_users = SurveyUtil::get_invited_users($survey_info['code'], $course_database);
- if (!in_array($user_id, $invited_users['course_users'])) continue;
- }
-
- if ($item_property['tool'] == TOOL_LEARNPATH) {
- require_once api_get_path(SYS_CODE_PATH).'newscorm/learnpath.class.php';
- if (!learnpath::is_lp_visible_for_student($item_property['ref'],$user_id, $my_course['k'])) {
- continue;
- }
- }
- $notifications[$item_property['tool']] = $item_property;
- }
- }
-
- $retvalue = ' ';
- while (list($key, $notification) = each($notifications)) {
- $lastDate = date('d/m/Y H:i', convert_mysql_date($notification['lastedit_date']));
- $type = $notification['lastedit_type'];
- if (empty($my_course['id_session'])) {
- $my_course['id_session'] = 0;
- }
- $retvalue .= '<a href="'.api_get_path(WEB_CODE_PATH).$notification['link'].'?cidReq='.$my_course['k'].'&ref='.$notification['ref'].'&gidReq='.$notification['to_group_id'].'&id_session='.$my_course['id_session'].'">'.'<img title="-- '.get_lang(ucfirst($notification['tool'])).' -- '.get_lang('_title_notification').": ".get_lang($type)." ($lastDate).\"".' src="'.api_get_path(WEB_CODE_PATH).'img/'.$notification['image'].'" border="0" align="absbottom" /></a> ';
- }
- return $retvalue;
- }
-
- function display_digest($toolsList, $digest, $orderKey, $courses) {
- $html = '';
- if (is_array($digest) && (CONFVAL_showExtractInfo == SCRIPTVAL_UnderCourseList || CONFVAL_showExtractInfo == SCRIPTVAL_Both)) {
-
- reset($digest);
- $html .= "<br /><br />\n";
- while (list($key1) = each($digest)) {
- if (is_array($digest[$key1])) {
-
- $html .= "<strong>\n";
- if ($orderKey[0] == 'keyTools') {
- $tools = $key1;
- $html .= $toolsList[$key1]['name'];
- } elseif ($orderKey[0] == 'keyCourse') {
- $courseSysCode = $key1;
- $html .= "<a href=\"".api_get_path(WEB_COURSE_PATH). $courses[$key1]['coursePath']. "\">".$courses[$key1]['courseCode']. "</a>\n";
- } elseif ($orderKey[0] == 'keyTime') {
- $html .= api_convert_and_format_date($digest[$key1], DATE_FORMAT_LONG, date_default_timezone_get());
- }
- $html .= "</strong>\n";
-
-
- reset($digest[$key1]);
- while (list ($key2) = each($digest[$key1])) {
-
- $html .= "<p>\n". "\n";
- if ($orderKey[1] == 'keyTools') {
- $tools = $key2;
- $html .= $toolsList[$key2][name];
- } elseif ($orderKey[1] == 'keyCourse') {
- $courseSysCode = $key2;
- $html .= "<a href=\"". api_get_path(WEB_COURSE_PATH). $courses[$key2]['coursePath']. "\">". $courses[$key2]['courseCode']. "</a>\n";
- } elseif ($orderKey[1] == 'keyTime') {
- $html .= api_convert_and_format_date($key2, DATE_FORMAT_LONG, date_default_timezone_get());
- }
- $html .= "\n";
- $html .= "</p>";
-
-
- reset($digest[$key1][$key2]);
- while (list ($key3, $dataFromCourse) = each($digest[$key1][$key2])) {
-
- if ($orderKey[2] == 'keyTools') {
- $level3title = "<a href=\"".$toolsList[$key3]["path"].$courseSysCode."\">".$toolsList[$key3]['name']."</a>";
- } elseif ($orderKey[2] == 'keyCourse') {
- $level3title = "• <a href=\"".$toolsList[$tools]["path"].$key3."\">".$courses[$key3]['courseCode']."</a>\n";
- } elseif ($orderKey[2] == 'keyTime') {
- $level3title = "• <a href=\"".$toolsList[$tools]["path"].$courseSysCode."\">".api_convert_and_format_date($key3, DATE_FORMAT_LONG, date_default_timezone_get())."</a>";
- }
-
-
- reset($digest[$key1][$key2][$key3]);
- while (list ($key4, $dataFromCourse) = each($digest[$key1][$key2][$key3])) {
- $html .= $level3title. ' – '. api_substr(strip_tags($dataFromCourse), 0, CONFVAL_NB_CHAR_FROM_CONTENT);
-
- if (api_strlen($dataFromCourse) >= CONFVAL_NB_CHAR_FROM_CONTENT) {
- $html .= '...';
- }
- }
- $html .= "<br />\n";
- }
- }
- }
- }
- return $html;
- }
- }
-
- function get_session_title_box($session_id) {
- global $nosession;
- if (api_get_setting('use_session_mode') == 'true' && !$nosession) {
- global $now, $date_start, $date_end;
- }
- $output = array();
- if (api_get_setting('use_session_mode') == 'true' && !$nosession) {
- $main_user_table = Database :: get_main_table(TABLE_MAIN_USER);
- $tbl_session = Database :: get_main_table(TABLE_MAIN_SESSION);
- $tbl_session_category = Database :: get_main_table(TABLE_MAIN_SESSION_CATEGORY);
- $active = false;
-
- $sql ='SELECT tu.lastname, tu.firstname, ts.name, ts.date_start, ts.date_end, ts.session_category_id
- FROM '.$tbl_session.' ts LEFT JOIN '.$main_user_table .' tu ON ts.id_coach = tu.user_id
- WHERE ts.id='.intval($session_id);
- $rs = Database::query($sql);
- $session_info = Database::store_result($rs);
- $session_info = $session_info[0];
- $session = array();
- $session['title'] = $session_info[2];
- $session['coach'] = '';
- if ($session_info['date_end'] == '0000-00-00' && $session_info['date_start'] == '0000-00-00') {
-
- $session['dates'] = '';
- if (api_get_setting('show_session_coach') === 'true') {
- $session['coach'] = get_lang('GeneralCoach').': '.api_get_person_name($session_info[1], $session_info[0]);
- }
- $active = true;
- } else {
- $start = $stop = false;
- $startt_buffer = $stop_buffer = '';
- if ($session_info['date_start'] == '0000-00-00') {
- $session_info['date_start'] = '';
- } else {
- $start = true;
- $start_buffer = $session_info['date_start'];
- $session_info['date_start'] = get_lang('From').' '.$session_info['date_start'];
- }
- if ($session_info['date_end'] == '0000-00-00') {
- $session_info['date_end'] = '';
- } else {
- $stop = true;
- $stop_buffer = $session_info['date_end'];
- $session_info['date_end'] = get_lang('Until').' '.$session_info['date_end'];
- }
- if ($start && $stop) {
- $session['dates'] = Display::tag('i', sprintf(get_lang('FromDateXToDateY'),$start_buffer, $stop_buffer));
- } else {
- $session['dates'] = Display::tag('i', $session_info['date_start'].' '.$session_info['date_end']);
- }
- if ( api_get_setting('show_session_coach') === 'true' ) {
- $session['coach'] = get_lang('GeneralCoach').': '.api_get_person_name($session_info[1], $session_info[0]);
- }
- $active = ($date_start <= $now && $date_end >= $now);
- }
- $session['active'] = $active;
- $session['session_category_id'] = $session_info[5];
- $output = $session;
- }
- return $output;
- }
- }
|