123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610 |
- <?php
- /* For licensing terms, see /license.txt */
- /**
- * @package chamilo.plugin.ticket
- */
- require_once __DIR__.'/../inc/global.inc.php';
- if (!api_is_platform_admin() && api_get_setting('ticket_allow_student_add') != 'true') {
- header('location:' . api_get_path(WEB_CODE_PATH).'ticket/tickets.php');
- exit;
- }
- api_block_anonymous_users();
- $courseId = api_get_course_int_id();
- $htmlHeadXtra[] = '<script>
- function updateCourseList(sessionId) {
- $selectCourse = $("select#course_id");
- $selectCourse.empty();
-
- $.get("'.api_get_path(WEB_AJAX_PATH).'session.ajax.php", {
- a: "get_courses_inside_session",
- session_id : sessionId
- }, function (courseList) {
- $("<option>", {
- value: 0,
- text: "'.get_lang('Select').'"
- }).appendTo($selectCourse);
-
- if (courseList.length > 0) {
- $.each(courseList, function (index, course) {
- $("<option>", {
- value: course.id,
- text: course.name
- }).appendTo($selectCourse);
- });
- $("select#course_id option[value=\''.$courseId.'\']").attr("selected",true);
- $("select#course_id").selectpicker("refresh");
- }
- }, "json");
- }
- $(document).on("ready", function () {
- $("select#session_id").on("change", function () {
- var sessionId = parseInt(this.value, 10);
- updateCourseList(sessionId);
- });
-
- var sessionId = $("select#session_id").val();
- updateCourseList(sessionId);
- });
- function changeType() {
- var selected = document.getElementById("category_id").selectedIndex;
- var id = $("#category_id").val();
- $("#other_area").val(other_area[id]);
- $("#email").val(email[id]);
- if (parseInt(course_required[id]) == 0){
- $("#divCourse").css("display", "none");
- if( id != "CUR"){
- $("#divEmail").css("display", "block");
- $("#personal_email").attr("required","required");
- }
- $("#course_id").disabled = true;
- $("#course_id").value = 0;
- } else {
- $("#divCourse").css("display", "block");
- $("#course_id").prop("disabled", false);
- $("#course_id").val(0);
- }
- }
- function handleClick2(myRadio) {
- var user_id = myRadio.value;
- document.getElementById("user_id_request").value = user_id;
- alert(document.getElementById("user_id_request").value);
- }
- function validate() {
- var re = /^([a-zA-Z0-9_.-])+@(([a-zA-Z0-9-])+.)+([a-zA-Z0-9]{2,4})+$/;
- fckEditor1val = CKEDITOR.instances["content"].getData();
- document.getElementById("content").value= fckEditor1val;
- var selected = document.getElementById("category_id").selectedIndex;
- var id = document.getElementById("category_id").options[selected].value;
- if(parseInt(course_required[id]) == 1 && document.getElementById("course_id").value == 0) {
- alert("' . addslashes(get_lang("ValidCourse")) . '");
- return false;
- } else if(id != "CUR" && parseInt(course_required[id]) != 1 && !re.test(document.getElementById("personal_email").value)) {
- if (document.getElementById("personal_email").value != "") {
- alert("' . addslashes(get_lang("PleaseEnterValidEmail")) . '");
- return false;
- }
- } else if(fckEditor1val == "") {
- alert("' . addslashes(get_lang("Filled")) . '");
- return false;
- }
- }
- var counter_image = 1;
- function remove_image_form(element_id) {
- $("#" + element_id).remove();
- counter_image = counter_image - 1;
- $("#link-more-attach").css("display", "block");
- }
- function add_image_form() {
- // Multiple filepaths for image form
- var filepaths = $("#filepaths");
- var new_elem, input_file, link_remove, img_remove, new_filepath_id;
- if ($("#filepath_"+counter_image)) {
- counter_image = counter_image + 1;
- } else {
- counter_image = counter_image;
- }
- new_elem = "filepath_"+counter_image;
- $("<div/>", {
- id: new_elem,
- class: "controls"
- }).appendTo(filepaths);
- input_file = $("<input/>", {
- type: "file",
- name: "attach_" + counter_image,
- size: 20
- });
- link_remove = $("<a/>", {
- onclick: "remove_image_form(\'" + new_elem + "\')",
- style: "cursor: pointer"
- });
- img_remove = $("<img/>", {
- src: "' . Display::returnIconPath('delete.png') . '"
- });
- new_filepath_id = $("#filepath_" + counter_image);
- new_filepath_id.append(input_file, link_remove.append(img_remove));
- if (counter_image === 6) {
- var link_attach = $("#link-more-attach");
- if (link_attach) {
- $(link_attach).css("display", "none");
- }
- }
- }
- </script>
- <style>
- div.row div.label2 {
- float:left;
- width:10%;
- }
- div.row div.formw2 {
- width:90%;
- float:left
- }
- div.divTicket {
- padding-top: 100px;
- }
- </style>';
- $projectId = isset($_GET['project_id']) ? (int) $_GET['project_id'] : '';
- $types = TicketManager::get_all_tickets_categories($projectId, 'category.name ASC');
- $htmlHeadXtra[] = '<script language="javascript">
- var projects = ' . js_array($types, 'projects', 'project_id') . '
- var course_required = ' . js_array($types, 'course_required', 'course_required') . '
- var other_area = ' . js_array($types, 'other_area', 'other_area') . '
- var email = ' . js_array($types, 'email', 'email') .
- '</script>';
- /**
- * @param $s
- * @return string
- */
- function js_str($s)
- {
- return '"' . addcslashes($s, "\0..\37\"\\") . '"';
- }
- /**
- * @param $array
- * @param $name
- * @param $key
- * @return string
- */
- function js_array($array, $name, $key)
- {
- $return = "new Array(); ";
- foreach ($array as $value) {
- $return .= $name . "['" . $value['category_id'] . "'] ='" . $value[$key] . "'; ";
- }
- return $return;
- }
- /**
- *
- */
- function show_form_send_ticket()
- {
- global $types;
- $userId = api_get_user_id();
- // Category List
- $categoryList = array();
- foreach ($types as $type) {
- $categoryList[$type['category_id']] = $type['name'].': '.$type['description'];
- }
- // Status List
- $statusAttributes = array(
- 'style' => 'display: none;',
- 'id' => 'status_id',
- 'for' => 'status_id'
- );
- $statusList = TicketManager::getStatusList();
- // Source List
- $sourceList = array();
- $sourceAttributes = array(
- 'style' => 'display: none;',
- 'id' => 'source_id',
- 'for' => 'source_id'
- );
- $sourceList[TicketManager::SOURCE_PLATFORM] = get_lang('SrcPlatform');
- if (api_is_platform_admin()) {
- $sourceAttributes = array(
- 'id' => 'source_id',
- 'for' => 'source_id'
- );
- $sourceList[TicketManager::SOURCE_EMAIL] = get_lang('SrcEmail');
- $sourceList[TicketManager::SOURCE_PHONE] = get_lang('SrcPhone');
- $sourceList[TicketManager::SOURCE_PRESENTIAL] = get_lang('SrcPresential');
- }
- // Priority List
- $priorityList = TicketManager::getPriorityList();
- $projectId = isset($_GET['project_id']) ? (int) $_GET['project_id'] : 0;
- $form = new FormValidator(
- 'send_ticket',
- 'POST',
- api_get_self().'?project_id='.$projectId,
- '',
- array(
- 'enctype' => 'multipart/form-data',
- 'onsubmit' => 'return validate()'
- )
- );
- $form->addElement(
- 'hidden',
- 'user_id_request',
- '',
- array(
- 'id' => 'user_id_request'
- )
- );
- $form->addElement(
- 'hidden',
- 'project_id',
- $projectId
- );
- $form->addElement(
- 'hidden',
- 'other_area',
- '',
- array(
- 'id' => 'other_area'
- )
- );
- $form->addElement(
- 'hidden',
- 'email',
- '',
- array(
- 'id' => 'email'
- )
- );
- $form->addElement(
- 'select',
- 'category_id',
- get_lang('Category'),
- $categoryList,
- array(
- 'onchange' => 'changeType()',
- 'id' => 'category_id',
- 'for' => 'category_id',
- 'style' => 'width: 562px;'
- )
- );
- $form->addElement(
- 'text',
- 'subject',
- get_lang('Subject'),
- array(
- 'id' => 'subject'
- )
- );
- $form->addHtmlEditor(
- 'content',
- get_lang('Message'),
- false,
- false,
- array(
- 'ToolbarSet' => 'Profile',
- 'Height' => '250'
- )
- );
- if (api_is_platform_admin()) {
- $form->addElement(
- 'SelectAjax',
- 'user_id',
- get_lang('Assign'),
- null,
- ['url' => api_get_path(WEB_AJAX_PATH).'user_manager.ajax.php?a=get_user_like']
- );
- }
- $form->addElement(
- 'text',
- 'personal_email',
- get_lang('PersonalEmail'),
- array(
- 'id' => 'personal_email'
- )
- );
- $form->addLabel(
- '',
- Display::div(
- '',
- array(
- 'id' => 'user_request'
- )
- )
- );
- $form->addElement(
- 'select',
- 'status_id',
- get_lang('Status'),
- $statusList,
- $statusAttributes
- );
- $form->addElement(
- 'select',
- 'priority_id',
- get_lang('Priority'),
- $priorityList,
- array(
- 'id' => 'priority_id',
- 'for' => 'priority_id'
- )
- );
- $form->addElement(
- 'select',
- 'source_id',
- get_lang('Source'),
- $sourceList,
- $sourceAttributes
- );
- $form->addElement(
- 'text',
- 'phone',
- get_lang('Phone') . ' (' . get_lang('Optional') . ')',
- array(
- 'id' => 'phone'
- )
- );
- $sessionList = SessionManager::get_sessions_by_user($userId);
- $sessionListToSelect = array(get_lang('Select'));
- //Course List
- foreach ($sessionList as $sessionInfo) {
- $sessionListToSelect[$sessionInfo['session_id']] = $sessionInfo['session_name'];
- }
- $form->addSelect('session_id', get_lang('Session'), $sessionListToSelect, ['id' => 'session_id']);
- $form->addSelect('course_id', get_lang('Course'), [], ['id' => 'course_id']);
- $courseInfo = api_get_course_info();
- $params = [];
- if (!empty($courseInfo)) {
- $params = [
- 'course_id' => $courseInfo['real_id']
- ];
- $sessionInfo = api_get_session_info(api_get_session_id());
- if (!empty($sessionInfo)) {
- $params['session_id'] = $sessionInfo['id'];
- }
- }
- $form->setDefaults($params);
- $form->addElement('file', 'attach_1', get_lang('FilesAttachment'));
- $form->addLabel('', '<span id="filepaths"><div id="filepath_1"></div></span>');
- $form->addLabel('',
- '<span id="link-more-attach">
- <span class="btn btn-success" onclick="return add_image_form()">' . get_lang('AddOneMoreFile') . '</span>
- </span>
- ('.sprintf(get_lang('MaximunFileSizeX'), format_file_size(api_get_setting('message_max_upload_filesize'))).')
- ');
- $form->addElement('html', '<br/>');
- $form->addElement(
- 'button',
- 'compose',
- get_lang('SendMessage'),
- null,
- null,
- null,
- 'btn btn-primary',
- array(
- 'id' => 'btnsubmit'
- )
- );
- $form->addRule('content', get_lang('ThisFieldIsRequired'), 'required');
- $form->addRule('category_id', get_lang('ThisFieldIsRequired'), 'required');
- $form->addRule('subject', get_lang('ThisFieldIsRequired'), 'required');
- $form->display();
- }
- /**
- *
- */
- function save_ticket()
- {
- $category_id = $_POST['category_id'];
- $content = $_POST['content'];
- if ($_POST['phone'] != '') {
- $content .= '<p style="color:red"> ' . get_lang('Phone') . ': ' . Security::remove_XSS($_POST['phone']). '</p>';
- }
- $course_id = isset($_POST['course_id']) ? $_POST['course_id'] : '';
- $sessionId = isset($_POST['session_id']) ? $_POST['session_id'] : '';
- $project_id = $_POST['project_id'];
- $subject = $_POST['subject'];
- $other_area = (int) $_POST['other_area'];
- $email = $_POST['email'];
- $personal_email = $_POST['personal_email'];
- $source = $_POST['source_id'];
- $user_id = isset($_POST['user_id']) ? $_POST['user_id'] : 0;
- $priority = isset($_POST['priority_id']) ? $_POST['priority_id'] : '';
- $status = isset($_POST['status_id']) ? $_POST['status_id'] : '';
- $file_attachments = $_FILES;
- if (TicketManager::add(
- $category_id,
- $course_id,
- $sessionId,
- $project_id,
- $other_area,
- $email,
- $subject,
- $content,
- $personal_email,
- $file_attachments,
- $source,
- $priority,
- $status,
- $user_id
- )) {
- header('Location:' . api_get_path(WEB_CODE_PATH).'ticket/tickets.php');
- exit;
- } else {
- Display::display_header(get_lang('ComposeMessage'));
- Display::display_error_message(get_lang('ErrorRegisterMessage'));
- }
- }
- /**
- * Get the total number of users on the platform
- * @return int The number of users
- * @see SortableTable#get_total_number_of_items()
- */
- function get_number_of_users()
- {
- $user_table = Database :: get_main_table(TABLE_MAIN_USER);
- $sql = "SELECT COUNT(u.user_id) AS total_number_of_items FROM $user_table u";
- if ((api_is_platform_admin() || api_is_session_admin()) && api_get_multiple_access_url()) {
- $access_url_rel_user_table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
- $sql.= " INNER JOIN $access_url_rel_user_table url_rel_user ON (u.user_id=url_rel_user.user_id)";
- }
- if (isset($_GET['keyword'])) {
- $keyword = Database::escape_string(trim($_GET['keyword']));
- $sql .= " WHERE (u.firstname LIKE '%$keyword%' OR
- u.lastname LIKE '%$keyword%' OR
- concat(u.firstname,' ',u.lastname) LIKE '%$keyword%' OR
- concat(u.lastname,' ',u.firstname) LIKE '%$keyword%' OR
- u.username LIKE '%$keyword%' OR
- u.email LIKE '%$keyword%' OR
- u.official_code LIKE '%$keyword%') ";
- }
- $res = Database::query($sql);
- $obj = Database::fetch_object($res);
- return $obj->total_number_of_items;
- }
- /**
- * Get the users to display on the current page (fill the sortable-table)
- * @param int offset of first user to recover
- * @param int Number of users to get
- * @param int Column to sort on
- * @param string Order (ASC,DESC)
- * @return array A list of users with their data
- * @see SortableTable#get_table_data($from)
- */
- function get_user_data($from, $number_of_items, $column, $direction)
- {
- $user_table = Database :: get_main_table(TABLE_MAIN_USER);
- if (api_is_western_name_order()) {
- $col34 = "u.firstname AS col3,
- u.lastname AS col4,";
- } else {
- $col34 = "u.lastname AS col3,
- u.firstname AS col4,";
- }
- $sql = "SELECT
- u.user_id AS col0,
- u.official_code AS col2,
- $col34
- u.username AS col5,
- u.email AS col6,
- u.status AS col7,
- u.active AS col8,
- u.user_id AS col9 ,
- u.expiration_date AS exp
- FROM $user_table u ";
- if (isset($_GET['keyword'])) {
- $keyword = Database::escape_string(trim($_GET['keyword']));
- $sql .= " WHERE (u.firstname LIKE '%$keyword%' OR
- u.lastname LIKE '%$keyword%' OR
- concat(u.firstname,' ',u.lastname) LIKE '%$keyword%' OR
- concat(u.lastname,' ',u.firstname) LIKE '%$keyword%' OR
- u.username LIKE '%$keyword%' OR
- u.official_code LIKE '%$keyword%' OR
- u.email LIKE '%$keyword%' )";
- }
- if (!in_array($direction, array('ASC', 'DESC'))) {
- $direction = 'ASC';
- }
- $column = intval($column);
- $from = intval($from);
- $number_of_items = intval($number_of_items);
- $sql .= " ORDER BY col$column $direction ";
- $sql .= " LIMIT $from, $number_of_items";
- $res = Database::query($sql);
- $users = array();
- while ($user = Database::fetch_row($res)) {
- $user_id = $user[0];
- $userPicture = UserManager::getUserPicture($user_id);
- $photo = '<img src="' . $userPicture. '" alt="' . api_get_person_name($user[2], $user[3]) . '" title="' . api_get_person_name($user[2], $user[3]) . '" />';
- $users[] = array(
- $photo,
- $user_id,
- $user[2],
- $user[3],
- $user[4],
- $user[5]
- );
- }
- return $users;
- }
- $interbreadcrumb[] = array(
- 'url' => api_get_path(WEB_CODE_PATH).'ticket/tickets.php',
- 'name' => get_lang('MyTickets')
- );
- if (!isset($_POST['compose'])) {
- Display::display_header(get_lang('ComposeMessage'));
- show_form_send_ticket();
- } else {
- save_ticket();
- }
- Display::display_footer();
|