, Ghent University - ability for course admins to specify wether uploaded documents are visible or invisible by default. * @author Roan Embrechts, code refactoring and virtual course support * @author Frederic Vauthier, directories management * @author Julio Montoya BeezNest 2011 LOTS of bug fixes * @todo this lib should be convert in a static class and moved to main/inc/lib */ /** * Initialization */ require_once api_get_path(SYS_CODE_PATH).'document/document.inc.php'; require_once api_get_path(LIBRARY_PATH).'fileDisplay.lib.php'; require_once api_get_path(SYS_CODE_PATH).'gradebook/lib/gradebook_functions.inc.php'; /** * Displays action links (for admins, authorized groups members and authorized students) * @param string Current dir * @param integer Whether to show tool options * @param integer Whether to show upload form option * @return void */ function display_action_links($id, $cur_dir_path, $show_tool_options, $display_upload_link, $action) { global $gradebook; $id = $my_back_id = intval($id); if ($action == 'list') { $my_back_id = 0; } $display_output = ''; $origin = isset($_GET['origin']) ? Security::remove_XSS($_GET['origin']) : ''; if (!empty($cur_dir_path)) { $display_output .= ''.Display::return_icon('back.png', get_lang('BackToWorksList'),'',ICON_SIZE_MEDIUM).''; } if ($show_tool_options && api_is_allowed_to_edit(null, true) && $origin != 'learnpath') { // Create dir if (empty($cur_dir_path)) { $display_output .= ''; $display_output .= Display::return_icon('new_work.png', get_lang('CreateAssignment'),'',ICON_SIZE_MEDIUM).''; } if (empty($cur_dir_path)) { // Options $display_output .= ''; $display_output .= Display::return_icon('settings.png', get_lang('EditToolOptions'),'',ICON_SIZE_MEDIUM).''; } } if ($display_upload_link && api_is_allowed_to_session_edit(false, true) && (isset($cur_dir_path) && (!empty($cur_dir_path) && $cur_dir_path != '/') )) { $display_output .= ''; $display_output .= Display::return_icon('upload_file.png', get_lang('UploadADocument'),'',ICON_SIZE_MEDIUM).''; } if (api_is_allowed_to_edit(null, true) && $origin != 'learnpath' && api_is_allowed_to_session_edit(false, true)) { // Delete all files if (api_get_setting('permanently_remove_deleted_files') == 'true'){ $message = get_lang('ConfirmYourChoiceDeleteAllfiles'); } else { $message = get_lang('ConfirmYourChoice'); } } if (api_is_allowed_to_edit(null, true)) { global $publication, $token; if (!empty($cur_dir_path)) { if (empty($_GET['list']) or Security::remove_XSS($_GET['list']) == 'with') { $display_output .= ''. Display::return_icon('exercice_uncheck.png', get_lang('ViewUsersWithoutTask'),'',ICON_SIZE_MEDIUM)."\n"; } else { $display_output .= ''. Display::return_icon('exercice_check.png', get_lang('ViewUsersWithTask'),'',ICON_SIZE_MEDIUM)."\n"; if (!isset($_GET['action']) || (isset($_GET['action']) && $_GET['action'] != 'send_mail')) { $display_output .= ''. Display::return_icon('mail_send.png', get_lang('ReminderMessage'),'',ICON_SIZE_MEDIUM).""; } else { $display_output .= Display::return_icon('mail_send_na.png', get_lang('ReminderMessage'),'',ICON_SIZE_MEDIUM); } } } } if ($display_output != '') { echo '
'; echo $display_output; echo '
'; } } /** * Displays all options for this tool. * These are * - make all files visible / invisible * - set the default visibility of uploaded files * * @param $uploadvisibledisabled * @param $origin */ function display_tool_options($uploadvisibledisabled, $origin) { global $group_properties, $gradebook; $is_allowed_to_edit = api_is_allowed_to_edit(null, true); $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); if (!$is_allowed_to_edit) { return; } echo '
'; echo ''.get_lang('EditToolOptions').''; display_default_visibility_form($uploadvisibledisabled); display_studentsdelete_form(); echo '
'; echo '
'; } /** * Displays the form where course admins can specify wether uploaded documents * are visible or invisible by default. * * @param $uploadvisibledisabled * @param $origin */ function display_default_visibility_form($uploadvisibledisabled) { ?>
/> />
, Ghent University, Belgium */ function display_studentsdelete_form() { // by default api_get_course_setting returns -1 and the code only expects 0 or 1 so anything tha // is different than 1 will be converted into 0 $current_course_setting_value = api_get_course_setting('student_delete_own_publication'); if ($current_course_setting_value != 1) { $current_course_setting_value = 0; } ?>
/>
/>
12345672218 (timestamp) $parts = split(' ', $default); list($d_year, $d_month, $d_day) = split('-', $parts[0]); list($d_hour, $d_minute, $d_second) = split(':', $parts[1]); return mktime((int)$d_hour, (int)$d_minute, (int)$d_second, (int)$d_month, (int)$d_day, (int)$d_year); } /** * converts 1-9 to 01-09 */ function two_digits($number) { $number = (int)$number; return ($number < 10) ? '0'.$number : $number; } /** * converts 2008-10-06 12:45:00 to -> array($data'year'=>2008,$data'month'=>10 etc...) */ function convert_date_to_array($date, $group) { $parts = split(' ', $date); $date_parts = split('-', $parts[0]); $date_parts_tmp = array(); foreach ($date_parts as $item) { $date_parts_tmp[] = intval($item); } $time_parts = split(':', $parts[1]); $time_parts_tmp = array(); foreach ($time_parts as $item) { $time_parts_tmp[] = intval($item); } list($data[$group.'[year]'], $data[$group.'[month]'], $data[$group.'[day]']) = $date_parts_tmp; list($data[$group.'[hour]'], $data[$group.'[minute]']) = $time_parts_tmp; return $data; } /** * get date from a group of date */ function get_date_from_group($group) { return $_POST[$group]['year'].'-'.two_digits($_POST[$group]['month']).'-'.two_digits($_POST[$group]['day']).' '.two_digits($_POST[$group]['hour']).':'.two_digits($_POST[$group]['minute']).':00'; } /** * create a group of select from a date */ function create_group_date_select($prefix = '') { $minute = range(10, 59); $d_year = date('Y'); array_unshift($minute, '00', '01', '02', '03', '04', '05', '06', '07', '08', '09'); $group_name[] = FormValidator :: createElement('select', $prefix.'day', '', array_combine(range(1, 31), range(1, 31))); $group_name[] = FormValidator :: createElement('select', $prefix.'month', '', array_combine(range(1, 12), api_get_months_long())); $group_name[] = FormValidator :: createElement('select', $prefix.'year', '', array($d_year => $d_year, $d_year + 1 => $d_year + 1)); $group_name[] = FormValidator :: createElement('select', $prefix.'hour', '', array_combine(range(0, 23), range(0, 23))); $group_name[] = FormValidator :: createElement('select', $prefix.'minute', '', $minute); return $group_name; } function get_work_data_by_path($path) { $path = Database::escape_string($path); $course_id = api_get_course_int_id(); $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $sql = "SELECT * FROM ".$work_table." WHERE url = '$path' AND c_id = $course_id "; $result = Database::query($sql); $return = array(); if (Database::num_rows($result)) { $return = Database::fetch_array($result,'ASSOC'); } return $return; } function get_work_data_by_id($id) { $id = intval($id); $course_id = api_get_course_int_id(); $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $sql = "SELECT * FROM $work_table WHERE id = $id AND c_id = $course_id"; $result = Database::query($sql); $return = array(); if (Database::num_rows($result)) { $return = Database::fetch_array($result,'ASSOC'); } return $return; } function get_work_count_by_student($user_id, $work_id) { $user_id = intval($user_id); $work_id = intval($work_id); $course_id = api_get_course_int_id(); $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $sql = "SELECT COUNT(*) as count FROM $work_table WHERE c_id = $course_id AND parent_id = $work_id AND user_id = $user_id AND active = 1 "; $result = Database::query($sql); $return = 0; if (Database::num_rows($result)) { $return = Database::fetch_row($result,'ASSOC'); $return = intval($return[0]); } return $return; } function get_work_assignment_by_id($id) { $id = intval($id); $course_id = api_get_course_int_id(); $table = Database :: get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT); $sql = "SELECT * FROM $table WHERE c_id = $course_id AND publication_id = $id"; $result = Database::query($sql); $return = array(); if (Database::num_rows($result)) { $return = Database::fetch_array($result,'ASSOC'); } return $return; } /** * Display the list of student publications, taking into account the user status * * @param $link_target_parameter - should there be a target parameter for the links * @param $dateFormatLong - date format * @param $origin - typically empty or 'learnpath' */ function display_student_publications_list($id, $link_target_parameter, $dateFormatLong, $origin, $add_in_where_query = '') { global $timeNoSecFormat, $dateFormatShort, $gradebook, $_course; // Database table names $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $iprop_table = Database::get_course_table(TABLE_ITEM_PROPERTY); $work_assigment = Database::get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT); $is_allowed_to_edit = api_is_allowed_to_edit(null, true); $user_id = api_get_user_id(); $session_id = api_get_session_id(); $condition_session = api_get_session_condition($session_id); $course_id = api_get_course_int_id(); $group_id = api_get_group_id(); $sort_params = array(); if (isset($_GET['column'])) { $sort_params[] = 'column='.Security::remove_XSS($_GET['column']); } if (isset($_GET['page_nr'])) { $sort_params[] = 'page_nr='.Security::remove_XSS($_GET['page_nr']); } if (isset($_GET['per_page'])) { $sort_params[] = 'per_page='.Security::remove_XSS($_GET['per_page']); } if (isset($_GET['direction'])) { $sort_params[] = 'direction='.Security::remove_XSS($_GET['direction']); } $sort_params = implode('&', $sort_params); $my_params = $sort_params; $origin = Security::remove_XSS($origin); // Getting the work data $my_folder_data = get_work_data_by_id($id); $qualification_exists = false; if (!empty($my_folder_data['qualification']) && intval($my_folder_data['qualification']) > 0) { $qualification_exists = true; } $work_dir = api_get_path(SYS_COURSE_PATH).$_course['path'].'/work'; if (!empty($my_folder_data)) { $work_dir = api_get_path(SYS_COURSE_PATH).$_course['path'].'/work'.$my_folder_data['url']; } if (empty($my_folder_data)) { $work_in_gradebook_link_id = is_resource_in_course_gradebook(api_get_course_id(), 3 , $id, api_get_session_id()); if ($work_in_gradebook_link_id) { if ($is_allowed_to_edit) if (intval($my_folder_data['qualification']) == 0) { Display::display_warning_message(get_lang('MaxWeightNeedToBeProvided')); } } $contains_file_query = ''; //Get list from database if ($is_allowed_to_edit) { $active_condition = ' active IN (0, 1)'; $sql_get_publications_list = "SELECT * FROM $work_table WHERE c_id = $course_id $add_in_where_query $condition_session AND $active_condition AND ( parent_id = 0) $contains_file_query ORDER BY sent_date DESC"; } else { if (!empty($group_id)) { $group_query = " WHERE c_id = $course_id AND post_group_id = '".$group_id."' "; // set to select only messages posted by the user's group $subdirs_query = "AND parent_id = 0"; } else { $group_query = " WHERE c_id = $course_id AND post_group_id = '0' "; $subdirs_query = "AND parent_id = 0"; } //@todo how we can active or not an assignment? $active_condition = ' AND active IN (1,0)'; $sql_get_publications_list = "SELECT * FROM $work_table $group_query $subdirs_query $add_in_where_query $active_condition $condition_session ORDER BY title"; } $work_parents = array(); $sql_result = Database::query($sql_get_publications_list); if (Database::num_rows($sql_result)) { while ($work = Database::fetch_object($sql_result)) { if ($work->parent_id == 0) { $work_parents[] = $work; } } } } else { $parent_id = isset($my_folder_data['id']) ? $my_folder_data['id'] : 0; if (!empty($group_id)) { $group_query = " WHERE c_id = $course_id AND post_group_id = '".intval($group_id)."' "; // set to select only messages posted by the user's group } else { $group_query = " WHERE c_id = $course_id AND post_group_id = '0' "; } $subdirs_query = "AND parent_id = $parent_id "; if ($is_allowed_to_edit) { //$subdirs_query .= " AND user_id = ".api_get_user_id()." "; } else { $subdirs_query .= " AND user_id = ".api_get_user_id()." "; } $active_condition = ' AND active IN (1)'; $sql_get_publications_list = "SELECT * FROM $work_table $group_query $subdirs_query $add_in_where_query $active_condition $condition_session ORDER BY title"; $sql_result = Database::query($sql_get_publications_list); } $edit_dir = isset($_GET['edit_dir']) ? $_GET['edit_dir'] : ''; $table_header = array(); $table_has_actions_column = false; $table_header[] = array(get_lang('Type'), false, 'style="width:40px"'); $table_header[] = array(get_lang('Title'), true); if (!empty($id)) { $table_header[] = array(get_lang('FirstName'), true); $table_header[] = array(get_lang('LastName'), true); if ($qualification_exists) { $table_header[] = array(get_lang('Qualification'), true); } } $table_header[] = array(get_lang('Date'), true, 'style="width:200px"'); if ($is_allowed_to_edit) { $table_header[] = array(get_lang('Actions'), false, 'style="width:90px"', array('class'=>'td_actions')); $table_has_actions_column = true; } // the following column name seems both undefined and unused //$table_header[] = array('RealDate', true); $table_data = array(); // List of all folders if no id was provided $group_id = api_get_group_id(); if (is_array($work_parents)) { foreach ($work_parents as $work_parent) { $sql_select_directory = "SELECT title, url, prop.insert_date, prop.lastedit_date, work.id, author, has_properties, view_properties, description, qualification, weight, allow_text_assignment FROM ".$iprop_table." prop INNER JOIN ".$work_table." work ON (prop.ref=work.id AND prop.c_id = $course_id ) WHERE active IN (0, 1) AND "; if (!empty($group_id)) { $sql_select_directory .= " work.post_group_id = '".$group_id."' "; // set to select only messages posted by the user's group } else { $sql_select_directory .= " work.post_group_id = '0' "; } $sql_select_directory .= " AND work.c_id = $course_id AND work.id = ".$work_parent->id." AND work.filetype = 'folder' AND prop.tool='work' $condition_session"; $result = Database::query($sql_select_directory); $row = Database::fetch_array($result, 'ASSOC'); if (!$row) { // the folder belongs to another session continue; } $direc_date = $row['lastedit_date']; //directory's date $author = $row['author']; //directory's author $view_properties = $row['view_properties']; $is_assignment = $row['has_properties']; $id2 = $row['id']; //work id if ($is_allowed_to_edit) { // form edit directory if (!empty($edit_dir) && $edit_dir == $id2) { if (!empty($row['has_properties'])) { $sql = Database::query('SELECT * FROM '.$work_assigment.' WHERE c_id = '.$course_id.' AND id = "'.$row['has_properties'].'" LIMIT 1'); $homework = Database::fetch_array($sql); } $form_folder = new FormValidator('edit_dir', 'post', api_get_self().'?origin='.$origin.'&gradebook='.$gradebook.'&edit_dir='.$id2); $form_folder->addElement('text', 'dir_name', get_lang('Title')); $form_folder->addElement('hidden', 'work_id', $id2); $form_folder -> addRule('dir_name', get_lang('ThisFieldIsRequired'), 'required'); $my_title = !empty($row['title']) ? $row['title'] : basename($row['url']); $defaults = array('dir_name' => Security::remove_XSS($my_title), 'description' => Security::remove_XSS($row['description'])); $form_folder->add_html_editor('description', get_lang('Description'), false, false, array('ToolbarSet' => 'work', 'Width' => '80%', 'Height' => '200')); $there_is_a_end_date = false; $form_folder -> addElement('html', '
 
'); $form_folder->addElement('html', ''); $form_folder -> addElement('style_submit_button', 'submit', get_lang('ModifyDirectory'), 'class="save"'); if ($there_is_a_end_date) { $end_date_array = convert_date_to_array($homework['ends_on'], 'ends'); $defaults = array_merge($defaults, $end_date_array); } if ($there_is_a_expire_date) { $expires_date_array = convert_date_to_array($homework['expires_on'], 'expires'); $defaults = array_merge($defaults, $expires_date_array); } if (!empty($row['qualification'])) { $defaults = array_merge($defaults, array('qualification[qualification]' => $row['qualification'])); } if (!empty($row['weight'])) { $defaults = array_merge($defaults, array('weight[weight]' => $row['weight'])); } $defaults['allow_text_assignment'] = $row['allow_text_assignment']; $form_folder -> setDefaults($defaults); $display_edit_form = true; if ($form_folder->validate()) { if ($_POST['enableExpiryDate'] == '1') { $there_is_a_expire_date = true; } else { $there_is_a_expire_date = false; } if ($_POST['enableEndDate'] == '1') { $there_is_a_end_date = true; } else { $there_is_a_end_date = false; } $values = $form_folder->exportValues(); $work_id = $values['work_id']; //$values = $values['my_group']; $dir_name = replace_dangerous_char($values['dir_name']); $dir_name = disable_dangerous_file($dir_name); $edit_check = false; $work_data = get_work_data_by_id($work_id); if (!empty($work_data)) { $edit_check = true; } else { $edit_check = true; } if ($edit_check) { $TABLEAGENDA = Database::get_course_table(TABLE_AGENDA); $expires_query = ' SET expires_on = '."'".($there_is_a_expire_date ? api_get_utc_datetime(get_date_from_group('expires')) : '0000-00-00 00:00:00')."'"; Database::query('UPDATE '.$work_assigment.$expires_query.' WHERE c_id = '.$course_id.' AND id = '."'".$row['has_properties']."'"); $sql_add_publication = "UPDATE ".$work_table." SET has_properties = '".$row['has_properties']. "', view_properties=1 WHERE c_id = $course_id AND id ='".$row['id']."'"; Database::query($sql_add_publication); $ends_query = ' SET ends_on = '."'".($there_is_a_end_date ? api_get_utc_datetime(get_date_from_group('ends')) : '0000-00-00 00:00:00')."'"; Database::query('UPDATE '.$work_assigment.$ends_query.' WHERE c_id = '.$course_id.' AND id = '."'".$row['has_properties']."'"); $sql_add_publication = "UPDATE ".$work_table." SET has_properties = '".$row['has_properties']. "', view_properties=1 WHERE c_id = $course_id AND id ='".$row['id']."'"; Database::query($sql_add_publication); $sql = 'UPDATE '.$work_table.' SET allow_text_assignment = '."'".intval($_POST['allow_text_assignment'])."'".' , title = '."'".Database::escape_string($_POST['dir_name'])."'".', description = '."'".Database::escape_string($_POST['description'])."'".', qualification = '."'".Database::escape_string($_POST['qualification']['qualification'])."'".', weight = '."'".Database::escape_string($_POST['weight']['weight'])."'".' WHERE c_id = '.$course_id.' AND id = '.$row['id']; Database::query($sql); require_once api_get_path(SYS_CODE_PATH).'gradebook/lib/gradebook_functions.inc.php'; $link_id = is_resource_in_course_gradebook(api_get_course_id(), 3 , $row['id'], api_get_session_id()); if ($link_id !== false) { Database::query('UPDATE '.Database :: get_main_table(TABLE_MAIN_GRADEBOOK_LINK).' SET weight = '."'".Database::escape_string((float)$_POST['weight']['weight'])."'".' WHERE c_id = '.$course_id.' AND id = '.$link_id); } //we are changing the current work and we want add them into gradebook if (isset($_POST['make_calification']) && $_POST['make_calification'] == 1) { require_once api_get_path(SYS_CODE_PATH).'gradebook/lib/be/gradebookitem.class.php'; require_once api_get_path(SYS_CODE_PATH).'gradebook/lib/be/evaluation.class.php'; require_once api_get_path(SYS_CODE_PATH).'gradebook/lib/be/abstractlink.class.php'; require_once api_get_path(SYS_CODE_PATH).'gradebook/lib/gradebook_functions.inc.php'; $resource_name = $_POST['dir_name']; add_resource_to_course_gradebook(api_get_course_id(), 3, $row['id'], $resource_name, (float)$_POST['weight']['weight'], (float)$_POST['qualification']['qualification'], $_POST['description'] , time(), 1, api_get_session_id()); } update_dir_name($work_data, $dir_name, $values['dir_name']); $dir = $dir_name; $display_edit_form = false; // gets calendar_id from student_publication_assigment $sql = "SELECT add_to_calendar FROM $work_assigment WHERE c_id = $course_id AND publication_id ='".$row['id']."'"; $res = Database::query($sql); $calendar_id = Database::fetch_row($res); $dir_name = sprintf(get_lang('HandingOverOfTaskX'), $dir_name); $end_date = $row['insert_date']; if ($_POST['enableExpiryDate'] == '1') { $end_date = Database::escape_string(api_get_utc_datetime(get_date_from_group('expires'))); } // update from agenda if it exists if (!empty($calendar_id[0])) { $sql = "UPDATE ".$TABLEAGENDA." SET title='".$values['dir_name']."', content = '".Database::escape_string($_POST['description'])."', start_date = '".$end_date."', end_date = '".$end_date."' WHERE c_id = $course_id AND id='".$calendar_id[0]."'"; Database::query($sql); } Display::display_confirmation_message(get_lang('FolderEdited')); } else { Display::display_warning_message(get_lang('FileExists')); } } } } $work_data = get_work_data_by_id($work_parent->id); $action = ''; $row = array(); $class = ''; //$a_count_directory = count_dir($work_dir.'/'.$dir, false); $cant_files = 0; $cant_dir = 0; $course_id = api_get_course_int_id(); $session_id = api_get_session_id(); if (api_is_allowed_to_edit()) { $sql_document = "SELECT count(*) FROM $work_table WHERE c_id = $course_id AND parent_id = ".$work_data['id']." AND active IN (0, 1) "; } else { $sql_document = "SELECT count(*) FROM $work_table s, $iprop_table p WHERE s.c_id = $course_id AND p.c_id = $course_id AND s.id = p.ref AND p.tool='work' AND s.accepted='1' AND user_id = ".api_get_user_id()." AND parent_id = ".$work_data['id']." AND active = 1 AND parent_id = ".$work_parent->id.""; } //count documents $res_document = Database::query($sql_document); $count_document = Database::fetch_row($res_document); $cant_files = $count_document[0]; $text_file = get_lang('FilesUpload'); if ($cant_files == 1) { $text_file = api_strtolower(get_lang('FileUpload')); } $icon = Display::return_icon('work.png', get_lang('Assignment'), array(), ICON_SIZE_SMALL); if (!empty($display_edit_form) && !empty($edit_dir) && $edit_dir == $id2) { $row[] = $icon; $row[] = ''.$form_folder->toHtml(); // form to edit the directory's name } else { $row[] = ''.$icon.''; $add_to_name = ''; require_once api_get_path(SYS_CODE_PATH).'gradebook/lib/gradebook_functions.inc.php'; $link_id = is_resource_in_course_gradebook(api_get_course_id(), 3 , $id2 , api_get_session_id()); $count = 0; if ($link_id !== false) { $gradebook_data = get_resource_from_course_gradebook($link_id); $count = $gradebook_data['weight']; } if ($count > 0) { $add_to_name = ' / '.get_lang('IncludedInEvaluation').''; } else { $add_to_name = ''; } $work_title = !empty($work_data['title']) ? $work_data['title'] : basename($work_data['url']); //Work name //if (api_is_allowed_to_edit()) { if ($cant_files > 0 ) { $zip = ''.Display::return_icon('save_pack.png', get_lang('Save'), array('style' => 'float:right;'), ICON_SIZE_SMALL).''; } //} $url = $zip.''. $work_title.''. $add_to_name.'
'.$cant_files.' '.$text_file.$dirtext; $row[] = $url; } if ($count_files != 0) { $row[] = ''; } if ($direc_date != '' && $direc_date != '0000-00-00 00:00:00') { $direc_date_local = api_get_local_time($direc_date); $row[] = date_to_str_ago($direc_date_local).'
'.api_format_date($direc_date_local).''; } else { $direc_date_local = '0000-00-00 00:00:00'; $row[] = ''; } if ($origin != 'learnpath') { if ($is_allowed_to_edit) { $action .= ''.Display::return_icon('edit.png', get_lang('Modify'), array(), ICON_SIZE_SMALL).''; $action .= ' '.Display::return_icon('delete.png',get_lang('DirDelete'),'',ICON_SIZE_SMALL).''; $row[] = $action; } else { $row[] = ''; } } $row[] = $direc_date_local; $row[] = $work_data['title']; $table_data[] = $row; } } //If an id was loaded we loop through the documents $my_assignment = get_work_assignment_by_id($id); if (Database::num_rows($sql_result) > 0) { while ($work = Database::fetch_object($sql_result)) { //Get the author ID for that document from the item_property table $is_author = false; $item_property_data = api_get_item_property_info(api_get_course_int_id(), 'work', $work->id, api_get_session_id()); if (!$is_allowed_to_edit && $item_property_data['insert_user_id'] == api_get_user_id()) { $is_author = true; } $user_info = api_get_user_info($item_property_data['insert_user_id']); //display info depending on the permissions if ($is_author && $work->accepted == '1' || $is_allowed_to_edit || CourseManager::is_course_teacher($item_property_data['insert_user_id'], $_course['code'])) { $row = array(); if ($work->accepted == '0') { $class = 'class="invisible"'; } else { $class = ''; } $qualification_string = ''; if ($qualification_exists) { if ($work->qualification == '') { $qualification_string = ' - '; } else { $qualification_string = ''.$work->qualification.''; } } $add_string = ''; $time_expires = api_strtotime($my_assignment['expires_on'], 'UTC'); if (!empty($my_assignment['expires_on']) && $my_assignment['expires_on'] != '0000-00-00 00:00:00' && $time_expires < api_strtotime($work->sent_date, 'UTC')) { $add_string = ' '.get_lang('Expired').''; } // } $row[] = ''.build_document_icon_tag('file', substr(basename($work->url), 13)).''; if ($work->contains_file) { $row[] = ''.Display::return_icon('save.png', get_lang('Save'),array('style' => 'float:right;'), ICON_SIZE_SMALL).' '.$work->title.'
'.$work->description; } else { $row[] = ''.$work->title.'
'.$work->description; } $row[] = $user_info['firstname']; // $work->author; $row[] = $user_info['lastname']; if ($qualification_exists) { $row[] = $qualification_string; } $work_sent_date_local = api_get_local_time($work->sent_date); $row[] = date_to_str_ago($work_sent_date_local).$add_string.'
'.api_format_date($work_sent_date_local).''; if ($is_allowed_to_edit) { $action = ''; if ($qualification_exists) { $action .= ''. Display::return_icon('rate_work.png', get_lang('CorrectAndRate'),array(), ICON_SIZE_SMALL).''; } else { $action .= ''. Display::return_icon('edit.png', get_lang('Comment'),array(), ICON_SIZE_SMALL).''; } if ($work->contains_file) { $action .= ''.Display::return_icon('move.png', get_lang('Move'),array(), ICON_SIZE_SMALL).''; } if ($work->accepted == '1') { $action .= ''.Display::return_icon('visible.png', get_lang('Invisible'),array(), ICON_SIZE_SMALL).''; } else { $action .= ''.Display::return_icon('invisible.png', get_lang('Visible'),array(), ICON_SIZE_SMALL).' '; } $action .= ''.Display::return_icon('delete.png', get_lang('WorkDelete'),'',ICON_SIZE_SMALL).''; $row[] = $action; // the user that is not course admin can only edit/delete own document } elseif ($is_author && empty($work->qualificator_id)) { if (!$table_has_actions_column) { $table_header[] = array(get_lang('Actions'), false, 'style="width:90px"'); $table_has_actions_column = true; } $action = ''; if (api_is_allowed_to_session_edit(false, true)) { $action .= ''.Display::return_icon('edit.png', get_lang('Modify'),array(), ICON_SIZE_SMALL).''; } else { $action .= Display::return_icon('edit_na.png', get_lang('Modify'),array(), ICON_SIZE_SMALL); } if (api_get_course_setting('student_delete_own_publication') == 1) { $action .= ''.Display::return_icon('delete.png',get_lang('WorkDelete'),'',ICON_SIZE_SMALL).''; } $row[] = $action; } else { $row[] = ' '; } $row[] = $work_sent_date_local; $table_data[] = $row; } } } $sorting_options = array(); $sorting_options['column'] = 1; // Here we change the way how the colums are going to be sorted // in this case the the column of LastResent ( 4th element in $column_header) we will be order like the column RealDate // because in the column RealDate we have the days in a correct format "2008-03-12 10:35:48" $column_order = array(); $i=0; foreach($table_header as $item) { $column_order[$i] = $i; $i++; } if (empty($my_folder_data)) { $column_order[1] = 5; } else { $column_order[2] = 2; } // An array with the setting of the columns -> 1: columns that we will show, 0:columns that will be hide $column_show = array(); $column_show[] = 1; // type 0 $column_show[] = 1; // title 1 if (!empty($my_folder_data)) { $column_show[] = 1; // 2 $column_show[] = 1; // 3 if ($qualification_exists) { $column_show[] = 1; // 4 } } $column_show[] = 1; //date if ($table_has_actions_column) { $column_show[] = 1; // modify } $column_show[] = 0; //real date in correct format $paging_options = array(); if (isset($_GET['curdirpath'])) { $my_params = array ('curdirpath' => Security::remove_XSS($_GET['curdirpath'])); } $my_params = array ('id' => isset($_GET['id']) ? $_GET['id'] : null); if (isset($_GET['edit_dir'])) { $my_params = array ('edit_dir' => intval($_GET['edit_dir'])); } $my_params['origin'] = $origin; Display::display_sortable_config_table('work', $table_header, $table_data, $sorting_options, $paging_options, $my_params, $column_show, $column_order); } function get_work_list() { } /** * Returns a list of subdirectories found in the given directory. * * The list return starts from the given base directory. * If you require the subdirs of /var/www/ (or /var/www), you will get 'abc/', 'def/', but not '/var/www/abc/'... * @param string Base dir * @param integer 0 if we only want dirs from this level, 1 if we want to recurse into subdirs * @return strings_array The list of subdirs in 'abc/' form, -1 on error, and 0 if none found * @todo Add a session check to see if subdirs_list doesn't exist yet (cached copy) */ function get_subdirs_list($basedir = '', $recurse = 0) { //echo "Looking for subdirs of $basedir"; if (empty($basedir) or !is_dir($basedir)) { return -1; } if (substr($basedir, -1, 1) != '/') { $basedir = $basedir.'/'; } $dirs_list = array(); $dh = opendir($basedir); while ($entry = readdir($dh)) { $entry = replace_dangerous_char($entry); $entry = disable_dangerous_file($entry); if (is_dir($basedir.$entry) && $entry != '..' && $entry != '.') { $dirs_list[] = $entry; if ($recurse == 1) { foreach (get_subdirs_list($basedir.$entry) as $subdir) { $dirs_list[] = $entry.'/'.$subdir; } } } } closedir($dh); return $dirs_list; } /** * Builds the form thats enables the user to * select a directory to browse/upload in * This function has been copied from the document/document.inc.php library * * @param array $folders * @param string $curdirpath * @param string $group_dir * @return string html form */ // TODO: This function is a candidate for removal, it is not used anywhere. function build_work_directory_selector($folders, $curdirpath, $group_dir = '') { $form = '
'."\n"; $form .= get_lang('CurrentDirectory').' '."\n"; $form .= ''."\n"; $form .= '
'; return $form; } /** * Builds the form thats enables the user to * move a document from one directory to another * This function has been copied from the document/document.inc.php library * * @param array $folders * @param string $curdirpath * @param string $move_file * @return string html form */ function build_work_move_to_selector($folders, $curdirpath, $move_file, $group_dir = '') { $course_id = api_get_course_int_id(); $move_file = intval($move_file); $tbl_work = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $sql = "SELECT title FROM $tbl_work WHERE c_id = $course_id AND id ='".$move_file."'"; $result = Database::query($sql); $title = Database::fetch_row($result); global $gradebook; $form = '
'; $form .= '
'.get_lang('MoveFile').' - '.Security::remove_XSS($title[0]).'
'; $form .= ''; $form .= ''; $form .= '
*'.get_lang('Select').'
'; $form .= ' '; $form .= '
'; $form .= '
'; $form .= '
'; $form .= '
'; return $form; } /** * Checks if the first given directory exists as a subdir of the second given directory * This function should now be deprecated by Security::check_abs_path() * @param string Subdir * @param string Base dir * @return integer -1 on error, 0 if not subdir, 1 if subdir */ // TODO: This function is a candidate for removal, it is not used anywhere. function is_subdir_of($subdir, $basedir) { if (empty($subdir) or empty($basedir)) { return -1; } if (substr($basedir, -1, 1) != '/') { $basedir = $basedir.'/'; } if (substr($subdir, 0, 1) == '/') { $subdir = substr($subdir, 1); } return is_dir($basedir.$subdir) ? 1 : 0; } /** * creates a new directory trying to find a directory name * that doesn't already exist * (we could use unique_name() here...) * * @author Hugues Peeters * @author Bert Vanderkimpen * @author Yannick Warnier Adaptation for work tool * @param string Base work dir (.../work) * @param string $desiredDirName complete path of the desired name * @return string actual directory name if it succeeds, boolean false otherwise */ function create_unexisting_work_directory($base_work_dir, $desired_dir_name) { $nb = ''; $base_work_dir = (substr($base_work_dir, -1, 1) == '/' ? $base_work_dir : $base_work_dir.'/'); while (file_exists($base_work_dir.$desired_dir_name.$nb)) { $nb += 1; } if (@mkdir($base_work_dir.$desired_dir_name.$nb, api_get_permissions_for_new_directories())) { return $desired_dir_name.$nb; } else { return false; } } /** * Delete a work-tool directory * @param string Base "work" directory for this course as /var/www/chamilo/courses/ABCD/work/ * @param string The directory name as the bit after "work/", without trailing slash * @return integer -1 on error */ function del_dir($id) { global $_course; $id = intval($id); $work_data = get_work_data_by_id($id); if (empty($work_data)) { return false; } $base_work_dir = api_get_path(SYS_COURSE_PATH) .$_course['path'].'/work'; $work_data_url = $base_work_dir.$work_data['url']; $check = Security::check_abs_path($work_data_url.'/', $base_work_dir.'/'); $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $course_id = api_get_course_int_id(); if (!empty($work_data['url'])) { //Deleting all contents inside the folder //@todo replace to parent_id $sql = "UPDATE $table SET active = 2 WHERE c_id = $course_id AND filetype = 'folder' AND id = $id"; $res = Database::query($sql); $sql = "UPDATE $table SET active = 2 WHERE c_id = $course_id AND parent_id = $id"; $res = Database::query($sql); if ($check) { require_once api_get_path(LIBRARY_PATH).'fileManage.lib.php'; $new_dir = $work_data_url.'_DELETED_'.$id; if (api_get_setting('permanently_remove_deleted_files') == 'true'){ my_delete($work_data_url); } else { if (file_exists($work_data_url)) { rename($work_data_url, $new_dir); } } } } } /** * Get the path of a document in the student_publication table (path relative to the course directory) * @param integer Element ID * @return string Path (or -1 on error) */ function get_work_path($id) { $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $course_id = api_get_course_int_id(); $sql = 'SELECT url FROM '.$table.' WHERE c_id = '.$course_id.' AND id='.intval($id); $res = Database::query($sql); if (Database::num_rows($res)) { $row = Database::fetch_array($res); return $row['url']; } return -1; } /** * Update the url of a work in the student_publication table * @param integer ID of the work to update * @param string Destination directory where the work has been moved (must end with a '/') * @return -1 on error, sql query result on success */ function update_work_url($id, $new_path, $parent_id) { if (empty($id)) return -1; $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $course_id = api_get_course_int_id(); $id = intval($id); $parent_id = intval($parent_id); $sql = "SELECT * FROM $table WHERE c_id = $course_id AND id = $id"; $res = Database::query($sql); if (Database::num_rows($res) != 1) { return -1; } else { $row = Database::fetch_array($res); $filename = basename($row['url']); $new_url = $new_path .$filename; $sql2 = "UPDATE $table SET url = '$new_url', parent_id = '$parent_id' WHERE c_id = $course_id AND id = $id"; $res2 = Database::query($sql2); return $res2; } } /** * Update the url of a dir in the student_publication table * @param string old path * @param string new path */ function update_dir_name($work_data, $new_name, $title) { $course_id = api_get_course_int_id(); $work_id = intval($work_data['id']); $path = $work_data['url']; if ($work_data['title'] == $title) { return true; } $title = Database::escape_string($title); if (!empty($new_name)) { global $base_work_dir; $new_name = Security::remove_XSS($new_name); $new_name = replace_dangerous_char($new_name); $new_name = disable_dangerous_file($new_name); my_rename($base_work_dir.'/'.$path, $new_name); $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); //update all the files in the other directories according with the next query $sql = "SELECT id, url FROM $table WHERE c_id = $course_id AND parent_id = $work_id"; // like binary (Case Sensitive) $rs = Database::query($sql); $work_len = strlen('work/'.$path); while ($work = Database :: fetch_array($rs)) { $new_dir = $work['url']; $name_with_directory = substr($new_dir, $work_len, strlen($new_dir)); $name = Database::escape_string('work/'.$new_name.'/'.$name_with_directory); $sql = 'UPDATE '.$table.' SET url= "'.$name.'" WHERE c_id = '.$course_id.' AND id= '.$work['id']; Database::query($sql); } $sql = "UPDATE $table SET url= '/".$new_name."' , title = '".$title."' WHERE c_id = $course_id AND id = $work_id"; Database::query($sql); } } /** * Return an array with all the folder's ids that are in the given path * @param string Path of the directory * @return array The list of ids of all the directories in the path * @author Julio Montoya Dokeos * @version April 2008 */ function get_parent_directories($id) { $course_id = api_get_course_int_id(); $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $id = intval($id); $sql = "SELECT id FROM $work_table WHERE c_id = $course_id AND parent_id = $id"; $result = Database::query($sql); $list_id = array(); if (Database::num_rows($result)) { while ($row = Database::fetch_array($result)) { $list_id[] = $row['id']; } } return $list_id; } /** * Transform an all directory structure (only directories) in an array * @param string path of the directory * @return array the directory structure into an array * @author Julio Montoya Dokeos * @version April 2008 */ function directory_to_array($directory) { $array_items = array(); if ($handle = @opendir($directory)) { while (false !== ($file = readdir($handle))) { if ($file != '.' && $file != '..') { if (is_dir($directory. '/' . $file)) { $array_items = array_merge($array_items, directory_to_array($directory. '/' . $file)); $file = $directory . '/' . $file; $array_items[] = preg_replace("/\/\//si", '/', $file); } } } closedir($handle); } return $array_items; } /** * Insert into the DB of the course all the directories * @param string path of the /work directory of the course * @return -1 on error, sql query result on success * @author Julio Montoya Dokeos * @version April 2008 */ function insert_all_directory_in_course_table($base_work_dir) { $dir_to_array = directory_to_array($base_work_dir, true); $only_dir = array(); for ($i = 0; $i < count($dir_to_array); $i++) { $only_dir[] = substr($dir_to_array[$i], strlen($base_work_dir), strlen($dir_to_array[$i])); } $course_id = api_get_course_int_id(); $group_id = api_get_group_id(); for($i = 0; $i < count($only_dir); $i++) { global $work_table; $sql_insert_all= "INSERT INTO " . $work_table . " SET c_id = '$course_id', url = '" . $only_dir[$i] . "', title = '', description = '', author = '', active = '0', accepted = '1', filetype = 'folder', post_group_id = '".$group_id."', sent_date = '0000-00-00 00:00:00' "; Database::query($sql_insert_all); } } /** * This function displays the number of files contained in a directory * * @param string the path of the directory * @param boolean true if we want the total quantity of files include in others child directorys , false only files in the directory * @return array the first element is an integer with the number of files in the folder, the second element is the number of directories * @author Julio Montoya Dokeos * @version April 2008 */ function count_dir($path_dir, $recurse) { $count = 0; $count_dir = 0; $d = dir($path_dir); while ($entry = $d->Read()) { if (!(($entry == '..') || ($entry == '.'))) { if (is_dir($path_dir.'/'.$entry)) { $count_dir++; if ($recurse) { $count += count_dir($path_dir . '/' . $entry, $recurse); } } else { $count++; } } } $return_array = array(); $return_array[] = $count; $return_array[] = $count_dir; return $return_array; } /** * returns all the javascript that is required for easily * validation when you create a work * this goes into the $htmlHeadXtra[] array */ function to_javascript_work() { $origin = isset($_REQUEST['origin']) && !empty($_REQUEST['origin']) ? api_get_tools_lists($_REQUEST['origin']) : ''; $js = ''; return $js; } /** * Gets the id of a student publication with a given path * @param string $path * @return true if is found / false if not found */ // TODO: The name of this function does not fit with the kind of information it returns. Maybe check_work_id() or is_work_id()? function get_work_id($path) { $TBL_STUDENT_PUBLICATION = Database :: get_course_table(TABLE_STUDENT_PUBLICATION); $TBL_PROP_TABLE = Database::get_course_table(TABLE_ITEM_PROPERTY); $course_id = api_get_course_int_id(); if (api_is_allowed_to_edit()) { $sql = "SELECT work.id FROM $TBL_STUDENT_PUBLICATION AS work, $TBL_PROP_TABLE AS props WHERE props.c_id = $course_id AND work.c_id = $course_id AND props.tool='work' AND work.id=props.ref AND work.url LIKE 'work/".$path."%' AND work.filetype='file' AND props.visibility<>'2'"; } else { $sql = "SELECT work.id FROM $TBL_STUDENT_PUBLICATION AS work,$TBL_PROP_TABLE AS props WHERE props.c_id = $course_id AND work.c_id = $course_id AND props.tool='work' AND work.id=props.ref AND work.url LIKE 'work/".$path."%' AND work.filetype='file' AND props.visibility<>'2' AND props.lastedit_user_id='".api_get_user_id()."'"; } $result = Database::query($sql); $num_rows = Database::num_rows($result); if ($result && $num_rows > 0) { return true; } else { return false; } } /** * Get list of users who have not given the task * @param int * @return array * @author cvargas * @author Julio Montoya Fixing query */ function get_list_users_without_publication($task_id) { $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $table_course_user = Database::get_main_table(TABLE_MAIN_COURSE_USER); $table_user = Database::get_main_table(TABLE_MAIN_USER); $session_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER); //condition for the session $session_id = api_get_session_id(); $course_id = api_get_course_int_id(); $task_id = intval($task_id); if ($session_id == 0) { $sql = "SELECT user_id as id FROM $work_table WHERE c_id = $course_id AND parent_id='$task_id'"; } else { $sql = "SELECT user_id as id FROM $work_table WHERE c_id = $course_id AND parent_id='$task_id' and session_id='".$session_id."'"; } $result = Database::query($sql); $users_with_tasks = array(); while($row = Database::fetch_array($result)) { $users_with_tasks[] = $row['id']; } if ($session_id == 0){ $sql_users = "SELECT cu.user_id, u.lastname, u.firstname, u.email FROM $table_course_user AS cu, $table_user AS u WHERE u.status!=1 and cu.course_code='".api_get_course_id()."' AND u.user_id=cu.user_id"; } else { $sql_users = "SELECT cu.id_user, u.lastname, u.firstname, u.email FROM $session_course_rel_user AS cu, $table_user AS u WHERE u.status!=1 and cu.course_code='".api_get_course_id()."' AND u.user_id=cu.id_user and cu.id_session='".$session_id."'"; } $group_id = api_get_group_id(); $new_group_user_list = array(); if ($group_id) { $group_user_list = GroupManager::get_subscribed_users($group_id); if (!empty($group_user_list)) { foreach($group_user_list as $group_user) { $new_group_user_list[] = $group_user['user_id']; } } } $result_users = Database::query($sql_users); $users_without_tasks = array(); while ($row_users = Database::fetch_row($result_users)) { if (in_array($row_users[0], $users_with_tasks)) continue; if ($group_id && !in_array($row_users[0], $new_group_user_list)) { continue; } //$user_id = array_shift($row_users); $row_users[0] = $row_users[1]; $row_users[1] = $row_users[2]; $row_users[2] = Display::encrypted_mailto_link($row_users[3]); $users_without_tasks[] = $row_users; } return $users_without_tasks; } /** * Display list of users who have not given the task * * @param int task id * @return array * @author cvargas carlos.vargas@beeznest.com cfasanando, christian.fasanado@beeznest.com * @author Julio Montoya Fixes */ function display_list_users_without_publication($task_id) { global $origin; $table_header[] = array(get_lang('LastName'), true); $table_header[] = array(get_lang('FirstName'), true); $table_header[] = array(get_lang('Email'), true); // table_data $table_data = get_list_users_without_publication($task_id); $sorting_options = array(); $sorting_options['column'] = 1; $paging_options = array(); $my_params = array(); if (isset($_GET['curdirpath'])) { $my_params['curdirpath'] = Security::remove_XSS($_GET['curdirpath']); } if (isset($_GET['edit_dir'])) { $my_params['edit_dir'] = Security::remove_XSS($_GET['edit_dir']); } if (isset($_GET['list'])) { $my_params['list'] = Security::remove_XSS($_GET['list']); } $my_params['origin'] = $origin; //$column_show $column_show[] = 1; $column_show[] = 1; $column_show[] = 1; Display::display_sortable_config_table('work', $table_header, $table_data, $sorting_options, $paging_options, $my_params, $column_show); } /** * Send reminder to users who have not given the task * * @param int * @return array * @author cvargas carlos.vargas@beeznest.com cfasanando, christian.fasanado@beeznest.com */ function send_reminder_users_without_publication($task_data) { global $_course; $sender_name = api_get_person_name(api_get_setting('administratorName'), api_get_setting('administratorSurname'), null, PERSON_NAME_EMAIL_ADDRESS); $task_id = $task_data['id']; $task_title = !empty($task_data['title']) ? $task_data['title'] : basename($task_data['url']); $subject = '[' . api_get_setting('siteName') . '] '; // The body can be as long as you wish, and any combination of text and variables $content = get_lang('ReminderToSubmitPendingTask')."\n".get_lang('CourseName').' : '.$_course['name']."\n"; $content .= get_lang('WorkName').' : '.$task_title."\n"; $list_users = get_list_users_without_publication($task_id); $mails_sent_to = array(); foreach ($list_users as $user) { $name_user = api_get_person_name($user[1], $user[0], null, PERSON_NAME_EMAIL_ADDRESS); $dear_line = get_lang('Dear')." ".api_get_person_name($user[1], $user[0]) .", \n\n"; $body = $dear_line.$content; api_mail($name_user, $user[3], $subject, $body, $sender_name, $email_admin); $mails_sent_to[] = $name_user; } return $mails_sent_to; } /** * Sends an email to the students of a course when a homework is created * * @param string course_id * * @author Guillaume Viguier * @author Julio Montoya Adding session support - 2011 */ function send_email_on_homework_creation($course_id) { // Get the students of the course $session_id = api_get_session_id(); if (empty($session_id)) { $students = CourseManager::get_student_list_from_course_code($course_id); } else { $students = CourseManager::get_student_list_from_course_code($course_id, true, $session_id); } $emailsubject = '[' . api_get_setting('siteName') . '] '.get_lang('HomeworkCreated'); $currentUser = api_get_user_info(api_get_user_id()); if (!empty($students)) { foreach($students as $student) { $user_info = api_get_user_info($student["user_id"]); if(!empty($user_info["mail"])) { $name_user = api_get_person_name($user_info["firstname"], $user_info["lastname"], null, PERSON_NAME_EMAIL_ADDRESS); $emailbody = get_lang('Dear')." ".$name_user.",\n\n"; $emailbody .= get_lang('HomeworkHasBeenCreatedForTheCourse')." ".$course_id.". "."\n\n".get_lang('PleaseCheckHomeworkPage'); $emailbody .= "\n\n".api_get_person_name($currentUser["firstname"], $currentUser["lastname"]); @api_mail($name_user, $user_info["mail"], $emailsubject, $emailbody, api_get_person_name($currentUser["firstname"], $currentUser["lastname"], null, PERSON_NAME_EMAIL_ADDRESS), $currentUser["mail"]); } } } } function is_work_exist_by_url($url) { $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $url = Database::escape_string($url); $sql = "SELECT id FROM $work_table WHERE url='$url'"; $result = Database::query($sql); if (Database::num_rows($result)> 0) { $row = Database::fetch_row($result); if (empty($row)) { return false; } else { return true; } } else { return false; } } function make_select($name, $values, $checked = '') { $output = ''; return $output; } function make_checkbox($name, $checked = '', $label = null) { $check = ''; if (!empty($label)) { $check .=""; } return $check; } function draw_date_picker($prefix, $default = '') { if (empty($default)) { $default = api_get_local_time(); } $parts = explode(' ', $default); list($d_year, $d_month, $d_day) = explode('-', $parts[0]); list($d_hour, $d_minute) = explode(':', $parts[1]); $minute = range(10, 59); array_unshift($minute, '00', '01', '02', '03', '04', '05', '06', '07', '08', '09'); $date_form = make_select($prefix.'_day', array_combine(range(1, 31), range(1, 31)), $d_day); $date_form .= make_select($prefix.'_month', array_combine(range(1, 12), api_get_months_long()), $d_month); $date_form .= make_select($prefix.'_year', array($d_year => $d_year, $d_year + 1 => $d_year + 1), $d_year).'    '; $date_form .= make_select($prefix.'_hour', array_combine(range(0, 23), range(0, 23)), $d_hour).' : '; $date_form .= make_select($prefix.'_minute', $minute, $d_minute); return $date_form; } function get_date_from_select($prefix) { return $_POST[$prefix.'_year'].'-'.two_digits($_POST[$prefix.'_month']).'-'.two_digits($_POST[$prefix.'_day']).' '.two_digits($_POST[$prefix.'_hour']).':'.two_digits($_POST[$prefix.'_minute']).':00'; }