File manager

File manager - Edit - /home/autoph/public_html/tasks/resources/views/common/script/knowledegebase_list.php

Back
<script> // alert(owned_kb_only) var selected_kb_data = 0; var is_new_kb = 0; var kb_json_data = ""; var uploaded_kb_attachments_arr = []; var uploaded_kb_attachments_has_error = false; var uploaded_kb_attachments_error_msg; var remove_kb_attachment_mock_files = []; // var ticket_selected_filters = "[]"; // var ticket_selected_filters_priority = "[]"; var ticket_selected_filters_category = "[]"; var ticket_selected_filters_final_status = "[]"; // Ticket Replies var ticket_replies_display_limit_const = 999; var ticket_replies_display_limit = ticket_replies_display_limit_const; var ticket_replies_display_count = 0; // DROPZONE 2 START // Get the template HTML and remove it from the doumenthe template HTML and remove it from the doument var kbNode = document.querySelector("#kb_modal_template") kbNode.id = "" var kbTemplate = kbNode.parentNode.innerHTML kbNode.parentNode.removeChild(kbNode) var kbDropzone = new Dropzone("#knowledgebase_modal", { removedfile: function(file) { if (!isEmpty(file.id)) { remove_kb_attachment_mock_files.push(file.id); } var _ref; return (_ref = file.previewElement) != null ? _ref.parentNode.removeChild(file.previewElement) : void 0; }, url: "app/models/file.php", paramName: "file", maxFilesize: 1024, maxFiles: 20, autoProcessQueue: false, acceptedFiles: '.pdf, .doc, .docx, .txt, .html, .htm, .ppt, .pptx, .xls, .csv, .xlsx, .png, .jpeg, .jpg, .mp4, .mkv, .mov, .avi, .wmv', init: function() { this.on('sending', function(file, xhr, formData) { formData.append("model", "create_file"); formData.append("file", "knowledgebase"); }); }, thumbnailWidth: 50, thumbnailHeight: 50, parallelUploads: 20, previewTemplate: kbTemplate, autoQueue: false, // Make sure the files aren't queued until manually added previewsContainer: "#kb_modal_previews", // Define the container to display the previews clickable: ".kb-modal-button" // Define the element that should be used as click trigger to select files. }); function startUpload() { if (kbDropzone.getAcceptedFiles().length < 1) { createKB(); } for (var i = 0; i < kbDropzone.getAcceptedFiles().length; i++) { kbDropzone.processFile(kbDropzone.getAcceptedFiles()[i]); } } kbDropzone.on('success', function(file, result) { try { result = JSON.parse(result) if (parseInt(result.status) === 1) { // alert(result.change_name); var uploaded_kb_attachments_obj = { "change_name": result.change_name, "original_name": result.orig_name } uploaded_kb_attachments_arr.push(uploaded_kb_attachments_obj); //console.log(uploaded_kb_attachments_arr); // uploaded_ticket_attachments = {change_name: result.change_name , original_name: result.orig_name}; } else if (parseInt(result.status) === 0) { //put the first error only if (!uploaded_kb_attachments_has_error) { uploaded_kb_attachments_has_error = true; uploaded_kb_attachments_error_msg = { filename: result.orig_name, message: result.message }; } } if (!result.error) { if (kbDropzone.getQueuedFiles().length === 0 && kbDropzone.getUploadingFiles().length === 0) { // console.log(uploaded_kb_attachments_arr) if (uploaded_kb_attachments_has_error) { toastr.remove(); toastr.error(uploaded_kb_attachments_error_msg.filename + ' - ' + uploaded_kb_attachments_error_msg.message) //remove uploaded files $.ajax({ url: "app/models/file.php", data: { model: 'delete_file', file: 'knowledgebase', file_names: JSON.stringify(uploaded_kb_attachments_arr) }, type: "POST", dataType: 'json', beforeSend: function() {}, success: function(result) {}, error: function() {} }); } else { // kbDropzone.removeAllFiles(true); createKB(); } uploaded_kb_attachments_has_error = false; uploaded_kb_attachments_arr = []; } } //TODO - } catch (e) { //TODO - console.log(e) } }); function kbActionFormatter(value, row, index) { return "<span id='update_kb_" + row.id + "' update-kb-action='" + row.id + "' class='border-primary text-primary border-bottom'>Update</span>" } function ticketStatusFormatter(value, row, index) { if (row.final_status_id == '1') { return "<span class='text-success font-weight-bold'>" + value + "<span>"; } if (row.final_status_id == '2') { return "<span class='text-danger font-weight-bold'>" + value + "<span>"; } return "<span class='text-primary font-weight-bold'>" + value + "<span>";; // return "<span id='update_kb_" + row.id + "' update-kb-action='" + row.id + "' class='border-primary text-primary border-bottom'>Update</span>" } function createKB() { return $.ajax({ url: "app/models/knowledgebase.php", data: { model: 'create_knowledgebase', json_data: kb_json_data, attachments: JSON.stringify(uploaded_kb_attachments_arr), knowledgebase_id: selected_kb_data, is_new_kb: is_new_kb, remove_attachments: JSON.stringify(remove_kb_attachment_mock_files) }, type: "POST", dataType: 'json', beforeSend: function() { $('#btn_kb_save').prop( 'disabled', true); toastr.remove(); toastr.info("Saving article..."); }, success: function(result) { if (parseInt(result.status) === 1) { // created_ticket_id = result.id; createKBDone(result.message) } else { $('#btn_kb_save').prop( 'disabled', false); toastr.remove(); toastr.error(result.message); } }, error: function() { $('#btn_kb_save').prop( 'disabled', false); toastr.remove(); toastr.error( "Error has occurred. Try again." ) } }); } function createKBDone(message) { toastr.remove(); toastr.success(message); resetKBModal(); $('#knowledgebase_modal').modal( 'hide'); $('#btn_kb_save').prop( 'disabled', false); refreshKBTableSilent(); } function refreshKBTable() { initTicketList(); var $table = $('#table_knowledgebase') $(function() { $table.bootstrapTable('refresh', { url: 'app/models/knowledgebase.php' }); }) } function refreshKBTableSilent() { var $table = $('#table_knowledgebase') $(function() { $table.bootstrapTable('refresh', { url: 'app/models/knowledgebase.php' }); }) } function initTicketList() { var $table = $('#table_knowledgebase'); $table.bootstrapTable('destroy').bootstrapTable({ sidePagination: 'server', formatSearch: function() { return 'Search...' }, onLoadSuccess: function() { initTicketActionColVisibility(); initKBActionEvent(); }, exportOptions: { fileName: function() { return 'titile' } } }); } function initKBActionEvent() { $("[update-kb-action]").each(function() { $(this).on('click', function() { // removeSelectChangeEvt(); // is_new_kb = 0; // resetKBModal(); // // fetch selected ticket // $('#ticket_modal').modal('show'); // setTimeout(function() { // initKBData(); // }, 100) is_new_kb = 0; resetKBModal(); $('#knowledgebase_modal').modal('show'); setTimeout(function() { initKBData(); }, 100) }); }); } function initKBData() { return $.ajax({ url: "app/models/knowledgebase.php", data: { model: 'read_knowledgebase_data', knowledgebase_id: selected_kb_data }, type: "POST", dataType: 'json', beforeSend: function() {}, success: function(result) { addSelectChangeEvt(); remove_kb_attachment_mock_files = []; $.each(result.rows, function(i, n) { if (i == 'description') { $('#description').summernote('code', n); } else { $("#" + i).text(n); $("#" + i).val(n); $("#" + i).trigger('change') var newState = new Option(n, n, true, true); // Append it to the select $("#" + i).append(newState).trigger('change'); } }); $.each(result.attachments, function(key, value) { var mockFile = { id: value.id, name: value.original_name, size: value.unreadable_size }; kbDropzone.emit("addedfile", mockFile); kbDropzone.emit("complete", mockFile); kbDropzone.files.push(mockFile); // here you add them into the files array }); // delete ticket_attachment_mock_files[57]; }, error: function() {} }); } function initTicketActionColVisibility() { if (owned_kb_only) { $('.action-formatter-th').show() } else { $('.action-formatter-th').hide() } } function kbQueryParams(params) { var start = $('#filter-date').data('daterangepicker').startDate; var end = $('#filter-date').data('daterangepicker').endDate; var start_date = start.format('YYYY-MM-DD'); var end_date = end.format('YYYY-MM-DD'); return { search: $('#ticket-search').val(), offset: params.offset, limit: params.limit, sort: params.sort, order: params.order, // filter_status: ticket_selected_filters, filter_category: ticket_selected_filters_category, // filter_priority: ticket_selected_filters_priority, // filter_final_status: ticket_selected_filters_final_status, filter_brand: $('#brand-filter').val(), filter_section: isEmpty(param_section) ? $('#section-filter').val() : param_section, filter_model: $('#model-filter').val(), filter_type: $('#type-filter').val(), start_date: start_date, end_date: end_date, owned_kb_only: owned_kb_only, model: 'read_knowledgebase_list', }; } function resetKBModal() { var $el = $('#knowledgebase_modal'); resetElementForm($el); $('#description').summernote('reset'); $('#description').summernote('focus'); kbDropzone.removeAllFiles(true); // $('.select2bs4').val('').trigger('change'); } // function createTicketDone(message) { // toastr.remove(); // toastr.success(message); // resetKBModal(); // $('#ticket_modal').modal( // 'hide'); // $('#btn_kb_save').prop( // 'disabled', false); // refreshKBTableSilent(); // } function resetDateRangePicker() { // daterangepicker_filter = false; var start = moment().startOf('year'); var end = moment().endOf('year'); // moment().startOf('month'), moment().endOf('month') $("#filter-date").data('daterangepicker').setStartDate(start); $("#filter-date").data('daterangepicker').setEndDate(end); // $('#filter-date').data('daterangepicker').chosenLabel = 'Disable'; $('#filter-date').data('daterangepicker').hideCalendars(); // $('.daterangepicker').css('width', 'auto'); // $('#filter-date span').html('Date Filter'); $('#filter-date span').html(start.format('M/D/YYYY') + ' to<br>' + end.format( 'M/D/YYYY')); } function initFilterCategory() { $.when(loadTicketFilterCategory()).done(function(ajax1Results) { $(".ticket-filter-category li").each(function() { $(this).on('click', function() { $(this).toggleClass("active"); var active_items = $('.ticket-filter-category').find('li.active').map( function() { var item = {}; // item.id = this.value; item.status = $(this).text(); return item; }); var active_items_arr = []; $.each(active_items, function(i, n) { active_items_arr.push(n.status) }); ticket_selected_filters_category = JSON.stringify(active_items_arr); // alert(ticket_selected_filters_category) refreshKBTableSilent(); }); }); $(".ticket-filter-category li").each(function() { var cur_text = $(this).text(); if (param_category.includes(cur_text)) { $(this).toggleClass("active"); var active_items = $('.ticket-filter-category').find('li.active').map( function() { var item = {}; // item.id = this.value; item.status = $(this).text(); return item; }); var active_items_arr = []; $.each(active_items, function(i, n) { active_items_arr.push(n.status) }); ticket_selected_filters_category = JSON.stringify(active_items_arr); } }); if (param_category.length > 0) { refreshKBTableSilent(); } }); } function initFilterFinalStatus() { $.when(loadTicketFilterFinalStatus()).done(function(ajax1Results) { $(".ticket-filter-final-status li").each(function() { $(this).on('click', function() { $(this).toggleClass("active"); var active_items = $('.ticket-filter-final-status').find('li.active').map( function() { var item = {}; // item.id = this.value; item.status = $(this).text(); return item; }); var active_items_arr = []; $.each(active_items, function(i, n) { active_items_arr.push(n.status) }); ticket_selected_filters_final_status = JSON.stringify(active_items_arr); // alert(ticket_selected_filters_final_status) refreshKBTableSilent(); }); }); }); } // function initFilterStatus() { // $.when(loadTicketFilterStatus()).done(function(ajax1Results) { // $(".ticket-filter-status li").each(function() { // $(this).on('click', function() { // $(this).toggleClass("active"); // var active_items = $('.ticket-filter-status').find('li.active').map( // function() { // var item = {}; // // item.id = this.value; // item.status = $(this).text(); // return item; // }); // var active_items_arr = []; // $.each(active_items, function(i, n) { // active_items_arr.push(n.status) // }); // ticket_selected_filters = JSON.stringify(active_items_arr); // // alert(ticket_selected_filters_category) // refreshKBTableSilent(); // }); // }); // }); // } // function initFilterPriority() { // $.when(loadTicketFilterPriority()).done(function(ajax1Results) { // $(".ticket-filter-priority li").each(function() { // $(this).on('click', function() { // $(this).toggleClass("active"); // var active_items = $('.ticket-filter-priority').find('li.active').map( // function() { // var item = {}; // // item.id = this.value; // item.status = $(this).text(); // return item; // }); // var active_items_arr = []; // $.each(active_items, function(i, n) { // active_items_arr.push(n.status) // }); // ticket_selected_filters_priority = JSON.stringify(active_items_arr); // // alert(ticket_selected_filters_category) // refreshKBTableSilent(); // }); // }); // }); // } function kbTableCellClickEvt() { $('#table_knowledgebase').on('click-cell.bs.table', function(field, value, row, $el) { selected_kb_data = $el.id; var source = $el.source; if (value != 'action') { if(parseInt(source) === 2){ // uri = "#tickets-view-"+selected_kb_data; window.location.hash = 'tickets-view-'+$el.id; }else{ // window.location.href = uri; window.location.hash = 'knowledgebase-view-'+$el.id; } return; switch (source) { case '1': $('#kb_view_modal').modal('show'); break; case '2': $('#kb_view_ticket_modal').modal('show'); break; } } }); } function btnNewKBEvt() { $('#new_knowledgebase').on("click", function(e) { is_new_kb = 1; resetKBModal(); $('#knowledgebase_modal').modal('show'); if(!isEmpty(param_section) && param_section != 'EMPTY_SECTION'){ var newState = new Option(param_section, param_section, true, true); $("#section").append(newState).trigger('change'); } }); } function initDateRangePicker() { var start = moment().startOf('year'); var end = moment().endOf('year'); $('#filter-date').daterangepicker({ // autoUpdateInput: false, showDropdowns: true, maxDate: new Date(), // parentEl: '#ticket-more-filter', locale: { cancelLabel: 'Cancel' }, startDate: start, opens: "left", endDate: end, ranges: { // 'Disable': [moment(), moment()], 'Today': [moment(), moment()], 'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')], 'Last 7 Days': [moment().subtract(6, 'days'), moment()], 'Last 30 Days': [moment().subtract(29, 'days'), moment()], 'This Month': [moment().startOf('month'), moment().endOf('month')], 'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')], 'This Year': [moment().startOf('year'), moment().endOf('year')], 'Last Year': [moment().subtract(1, 'year').startOf('year'), moment().subtract(1, 'year').endOf('year')] } }); $('#filter-date').on('apply.daterangepicker', function(ev, picker) { $('#filter-date span').html(picker.startDate.format('M/D/YYYY') + ' to<br>' + picker.endDate.format( 'M/D/YYYY')); refreshKBTableSilent(); // } }); } function initTicketSearchEvt() { $('#ticket-search').focusin(function() { $('#ticket-search-div').removeClass('default-search-size'); $('#ticket-search-div').addClass('expand-search-size'); }); $('#ticket-search').focusout(function() { if (isEmpty($(this).val())) { $('#ticket-search-div').removeClass('expand-search-size'); $('#ticket-search-div').addClass('default-search-size'); } }); $('#ticket-search').on('keyup', delay(function(e) { refreshKBTableSilent(); }, 500)); } function saveTicketEvt() { $('#btn_kb_save').on('click', function() { if (check_if_empty_field($('#category'), 'Category is required.')) { return; } if (check_if_empty_field($('#title'), 'Subject is required.')) { return; } if ($('#title').val().length <= 4) { toastr.remove(); toastr.error("Subject is too short..."); $('#title').trigger('focus'); return; } if ( $('#description').summernote('code') == '<p><br></p>' \|\| $('#description').summernote('code') == '') { $('#description').summernote('focus'); toastr.remove(); toastr.error("Description is required..."); return false; } if ($('#description').val().trim().length <= 5) { $('#description').summernote('focus'); toastr.remove(); toastr.error("Description is too short..."); return false; } if (!isEmpty($('#year_model').val())) { if ($('#year_model').val().length != 4) { toastr.remove(); toastr.error("Invalid year model..."); $('#year_model').trigger('focus'); return; } } var $element = $("[json-kb-modal]"); kb_json_data = generate_json( 'json-kb-modal', $element); // alert(kb_json_data); // return; startUpload(); }); } function kbInformationEvt() { $('#kb_view_modal').on('shown.bs.modal', function(e) { $('#kb-view-info-modal-tab li a').removeClass('active') $('#kb-view-info-modal-tab-content .tab-pane').removeClass('active').removeClass('show') $('#kb-view-info-modal-tab-information').addClass('active') $('#kb-view-info-modal-tab-information-sec').addClass('active').addClass('show') $("[kb-view-info-data]").each(function() { $(this).html("<span class='text-md text-muted font-italic'>Loading...</span>") }); readKBInformation(); readKBAttachments(); }) } function initSelect2UnselectElement() { $('#brand-filter,#model-filter,#type-filter,#section-filter').on('select2:select select2:unselecting', function(e) { refreshKBTableSilent(); }); } function exportPdf() { $('.kb-col').toggleClass('hide-sm'); $('#table_knowledgebase').tableExport({ onCellHtmlData: DoOnCellHtmlData, // ignoreColumn: [9,10], fileName: 'Knowledgebase_'+Date.now(), type: 'pdf', jspdf: { orientation: 'p', margins: { left: 10, right: 10, top: 40, bottom: 20 }, autotable: { startY: false, startX: 10, showHeader: 'firstPage', margin: { top: 10 }, bodyStyles: { valign: "top" }, theme: "striped", tableExport: {onAfterAutotable: function(){ $('.kb-col').toggleClass('hide-sm'); }}, beforePageContent: function(data) { //console.log(data.settings.tableExport.doc);return; var doc = data.settings.tableExport.doc; // Internal jspdf instance console.log(doc.getFontList()); doc.setFont('helvetica', 'normal'); doc.setFontSize(12); doc.text('Knowledge Base', data.settings.margin.top - 30, 20); doc.setFont('helvetica', 'normal'); doc.setFontSize(10); doc.text(moment().format('MMMM DD, YYYY'), data.settings.margin.top-30, 32); var str = "Page " + doc.internal.getNumberOfPages(); //+ ' - ' + 'Sample 3'; doc.setFont('Times', 'normal'); doc.setFontSize(10); // jsPDF 1.4+ uses getWidth, <1.4 uses .width var pageSize = doc.internal.pageSize; var pageHeight = pageSize.height ? pageSize.height : pageSize.getHeight(); doc.text(str, data.settings.margin.left, pageHeight - 10); }, styles: { overflow: 'linebreak', fontSize: 8, overflowColumns: 'linebreak' } } } }); } function exportXlsx() { $('#table_knowledgebase').tableExport({ onCellHtmlData: DoOnCellHtmlData, // ignoreColumn: [9,10], fileName: 'Knowledgebase_'+Date.now(), type: 'xlsx' }); } //Processing export content, this method can customize the content of a row, column, or even cell, that is, set its value to what you want. function DoOnCellHtmlData(cell, row, col, data) { if(col == '5' ){ //action col return ''; } // if ((col == '8' \|\| col == '10') && parseInt(row) > 0) { // var spanObj = $(data); //Convert a string labeled <span title="val"> </span> to a jQuery object // var spanObj2 = $(spanObj[0].innerHTML); // var title = spanObj2.attr( // "title"); //Read the value of title attribute in <span title="val"</span>. // if (typeof(title) != 'undefined') { // return title; // } // }else if((col == '9') && parseInt(row) > 0) { // var spanObj = $(data); //Convert a string labeled <span title="val"> </span> to a jQuery object // return spanObj[1].innerText; // }else { return data; // } } function DoCellData(cell, row, col, data) { } function DoBeforeAutotable(table, headers, rows, AutotableSettings) {} $(function() { // initLightBox(); refreshKBTable() // initTicketList(); kbTableCellClickEvt(); hideTicketTypes(); btnNewKBEvt(); filterEvt(); initDateRangePicker(); resetDateRangePicker(); initFilterCategory(); initFilterFinalStatus(); // initFilterStatus(); // initFilterPriority(); initTicketSearchEvt(); initSelect2Element(); initSelect2UnselectElement(); modelVariantEvt(); addSelectChangeEvt(); saveTicketEvt(); kbTicketInformationEvt(); kbInformationEvt(); kbAutoComplete(); $('#description').summernote({ placeholder: '', tabsize: 2, height: 250, dialogsInBody: true, tooltip: false, toolbar: [ // [groupName, [list of button]] ['style', ['bold', 'italic', 'underline', 'clear']], ['font', ['strikethrough', 'superscript', 'subscript']], ['fontsize', ['fontsize']], ['color', ['color']], ['para', ['ul', 'ol', 'paragraph']], ['height', ['height']], ['insert', ['picture', 'video', 'link']], ['view', ['fullscreen']] ] }); // $('.dropdown-submenu a.children').on("click", function(e){ // var $current_el = $(this); // $(".dropdown-submenu a.children").each(function() { // var $el = $(this); // if($current_el[0] != $el[0]){ // $el.next('ul').hide(); // } // }); // $(this).next('ul').toggle(); // e.stopPropagation(); // e.preventDefault(); // }); $('#type-filter').select2({ placeholder: "Select source", minimumResultsForSearch: -1, allowClear: true, escapeMarkup: function(markup) { return markup; }, language: { noResults: function(params) { return "Select source"; } } }); }); </script>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings