//ฟังก์ชั่นเปิดปิดฟอร์ม function toggle_form_data() { $(".frm").val(""); $("#form_action").val("1"); $("#div-main-form").toggle(); $("#div-show-data").toggle(); } function form_modal_show() { $(".frm").val(""); $("#form_action").val("1"); $("#pr_modal").modal("show"); } //pagination แบ่งหน้าแสดงข้อมูล function pagination(max_page, page) { $("#total_page").html(" จาก " + max_page + " หน้า"); var width = $(window).width(); if (max_page >= 1) { $("#pagination").empty(); if (page == 1) { ds = 'class="disabled"'; oc = ""; } else { ds = ""; pe = parseInt(page) - 1; oc = 'onclick="show_data(' + pe + ');"'; } pag = '
  • '; $("#pagination").append(pag); max = (width < 370) ? 6 : (width < 650) ? 12 : (width < 740) ? 15 : (width < 1025) ? 20 : 7; i = (page == 1 || max_page < max) ? 1 : ((page + max > max_page) ? max_page - max + 1 : page); var x = 1; var pag = ""; while (i <= max_page) { at = (page == i) ? "active" : ""; pag += '
  • ' + i + "
  • "; ++i; ++x; if (x > max) break; } if (page == max_page) { ds = 'class="disabled"'; oc = ""; } else { ds = ""; po = parseInt(page) + 1; oc = 'onclick="show_data(' + po + ');"'; } pag += '
  • '; $("#pagination").append(pag); } else { $("#pagination").empty(); } } //แสดงข้อมูล function show_data(page) { if (page == null) page = $("#page").val(); else $("#page").val(page); $("#show_data").empty(); let param = new FormData(document.getElementById("frm-search")); param.append("page", page); param.append("qpage", $("#qpage").val()); param.append("form_action", 6); $.post(folder + "db.php", param).done(function (data) { obj = jQuery.parseJSON(data); $("#show_state").html(obj["pagination"].state); pagination(obj["pagination"].max_loop, page); x = (page == 1) ? 1 : (page - 1) * $("#qpage").val() + 1; da = ""; $.each(obj, function (i) { if (i !== "pagination") { let imgUrl = '../backend/uploads/slideBanner/' + obj[i].id + '.' + obj[i].coverImg; let linkUrl = (obj[i].link && obj[i].link !== "") ? obj[i].link : "#"; da += ''; da += '' + x + ""; da += '
    Banner' + obj[i].title + '
    '; da += '' + (linkUrl !== "#" ? linkUrl : "- ไม่มีลิงก์ -") + ''; da += '' + obj[i].name_type + ""; da += ''; da += ' '; da += ' '; da += ""; da += ""; ++x; } }); $("#show_data").html(da); }); } function show_data2() { $("#qpage option:first").prop("selected", true); $("#page").val(1); show_data(); } function edit_data(id) { form_modal_show(); let param = new FormData(); param.append("id", id); param.append("form_action", "5"); $.post(folder + "db.php", param).done(function (data) { obj = jQuery.parseJSON(data); $.each(obj, function (index, value) { $("#" + index).val(value); }); }); $("#frm-label").html(" แก้ไขป้ายแบนเนอร์"); $("#form_action").val(2); } function delete_data(did) { ms = '
    '; ms += "

    คำเตือน

    หากลบข้อมูลแล้วจะไม่สามารถกู้คืนกลับมาได้

    "; ms += '

    '; $.aceToaster.add({ placement: "tc", title: "ยืนยันการลบข้อมูล", body: ms, width: "420px", sticky: true, belowNav: true, closeClass: "btn btn-bgc-tp border-0 btn-light-danger btn-xs px-2 py-1px m2-px radius-1 text-100 font-normal position-tr mt-2px mr-2px", headerClass: "bgc-transparent border-0 text-white text-140 mb-3 p-0 pl-3 pr-4", titleClass: "text-dark-tp3 font-normal pt-15", className: "brc-danger-m1 border-1 border-t-4 radius-0 pr-0", bodyClass: "pt-0 pl-3 text-105", }); } function confirm_delete(did) { let param = new FormData(); param.append("id", did); param.append("form_action", 3); $.post(folder + "db.php", param).done(function (data) { if (data.trim() == "0") { ms = "
    "; ms += "

    Success

    ลบข้อมูลเรียบร้อยแล้ว
    "; ms += ""; $.aceToaster.add({placement: "tc", body: ms, width: 420, delay: 5000, close: false, className: "bgc-white-tp1 shadow border-0", bodyClass: "d-flex border-0 p-0 text-dark-tp2", headerClass: "d-none"}); show_data(1); } else { alert("เกิดข้อผิดพลาดในการลบข้อมูล!"); } }); } $(function () { $(window).on("resize", function () { show_data($("#page").val()); }); $("#page").on("keypress", function (e) { if (e.which == 13) { show_data($("#page").val()); return false; } }); show_data(); $("#qpage").change(function () { show_data(1); }); $("#go_page").click(function () { show_data($("#page").val()); }); $("#btn-form-modal-show").click(function () { form_modal_show(); $("#frm-label").html(" เพิ่มป้ายแบนเนอร์"); }); var $invalidClass = "brc-danger-tp2"; var $validClass = "brc-info-tp2"; $("#frm-main").validate({ errorElement: "span", errorClass: "form-text form-error text-danger-m2", focusInvalid: false, ignore: "", rules: { title: { required: true } }, messages: { title: { required: "กรุณากรอกชื่อแบนเนอร์" } }, highlight: function (element) { var $element = $(element); $element.closest(".form-group").find(".form-text").remove(); if ($element.is("input[type=checkbox]") || $element.is("input[type=radio]")) return; $element.addClass($invalidClass + " d-inline-block").removeClass($validClass); }, success: function (error, element) { var parent = error.parent(); var $element = $(element); $element.removeClass($invalidClass).closest(".form-group").find(".form-text").remove(); if ($element.is("input[type=checkbox]") || $element.is("input[type=radio]")) return; $element.addClass($validClass + " d-inline-block"); parent.append(''); }, errorPlacement: function (error, element) { error.prepend(''); error.addClass("d-inline-block").insertAfter(element); }, submitHandler: function (form) { $("#show_data").empty(); let param = new FormData(document.getElementById("frm-main")); $.ajax({ url: folder + "db.php", type: "POST", data: param, processData: false, contentType: false, success: function (data) { if (data.trim() == "0") { let ms = "
    "; ms += "

    Success

    "; ms += ($("#form_action").val() == 1) ? "บันทึกแบนเนอร์เรียบร้อยแล้ว" : "แก้ไขแบนเนอร์เรียบร้อยแล้ว"; ms += "
    "; $.aceToaster.add({placement: "tc", body: ms, width: 420, delay: 5000, close: false, className: "bgc-white-tp1 shadow border-0", bodyClass: "d-flex border-0 p-0 text-dark-tp2", headerClass: "d-none"}); $(".frm").val(""); show_data(); $("#pr_modal").modal("hide"); $("#form_action").val("1"); } else { alert("เกิดข้อผิดพลาดในการบันทึกข้อมูล:\n" + data); } }, error: function(err) { alert("เชื่อมต่อฐานข้อมูลล้มเหลว"); } }); return false; }, }); $('#file_jpg').aceFileInput({ style: 'drop', droppable: true, container: 'border-1 border-dashed brc-grey-m4 brc-h-warning-m1', placeholderClass: 'text-125 text-600 text-grey-l1 my-2', placeholderText: 'ลากไฟล์มาวาง หรือ คลิกเพื่อเลือกรูปภาพ', placeholderIcon: '', thumbnail: 'large' }); });