FrontForm

<script src="~/js/exceljs.min.js"></script>
<script src="~/js/FileSaver.min.js"></script>
<script src="~/js/polyfill.min.js"></script>
<script type="text/javascript">
    var detilformData = null;
    var thisSendFormDataCompleted = null;
    function sendBegin(xhr, frm) {
        thisSendFormDataCompleted = null;
        frm.data = frm.data + detilformData;
        var load = $("#loadPanel").dxLoadPanel("instance");
        load.show();
    }
    function sendCompleted(xhr, o) {
        var load = $("#loadPanel").dxLoadPanel("instance");
        load.hide();
        try {
            eval(xhr.responseText);
        } catch (e) {
            console.log(e);
        }
    }

    function addRow(e) {

        var url = '/KonsultasiPCM/PilihJadwal';
        document.location = url;

    }

    function editRow(e) {


        if (e.row.data != null && e.row.data.konsultasipcmid != null) {
            var key = e.row.data.konsultasipcmid;
            var url = '/KonsultasiPCM/Edit/' + key;
            document.location = url;
        }
    }

    function deleteRow(e) {
        if (e.row.data != null && e.row.data.konsultasipcmid != null) {
            var key = e.row.data.konsultasipcmid;

            var grid = $("#gridView").dxDataGrid("instance");
            var load = $("#loadPanel").dxLoadPanel("instance");
            var result = DevExpress.ui.dialog.confirm("<b>Apa anda yakin akan menghapus data ini?</b>", "Konfirmasi");
            result.done(function (dialogResult) {
                if (dialogResult) {
                    var idxrow = grid.getRowIndexByKey(key);
                    grid.deleteRow(idxrow);
                    grid.refresh();
                    // save
                    afterDeleting = true;
                    indexDeleted = idxrow;
                    keyDeleted = key;

                }
            });
        }
    }


    var indexDeleted = -1;
    var keyDeleted = null;
    var afterDeleting = false;
    function rowRemoved(e) {
        // after grid refreshed
        if (afterDeleting && indexDeleted >= 0 && e.key == keyDeleted) {
            var grid = $("#gridView").dxDataGrid("instance");
            var newKey = grid.getKeyByRowIndex(indexDeleted);
            if (e.key != newKey) {
                DevExpress.ui.notify({ message: 'Berhasil menghapus', position: 'center,center', shading: true }, 'success', 3000);
            }
            else {
                DevExpress.ui.notify({ message: 'Berhasil menghapus', position: 'center,center', shading: true }, 'success', 3000);
            }
            indexDeleted = -1;
            keyDeleted = null;
            afterDeleting = false;
            var url = '/KonsultasiPCM';
            document.location = url;
        }
    }


    function detailRow(e) {
        var load = $("#loadPanel").dxLoadPanel("instance");
        load.hide();

        if (e.row.data != null && e.row.data.UserId != null) {
            var key = e.row.data.UserId;
            var popup = $("#popupArea").dxPopup("instance");
            WindowPopupDX = popup;
            var url = '/pemohon/KonsultasiAwal/Details/' + key;
            var content = '<iframe src="' + url + '" width="100%" height="100%" frameborder="0" />';
            popup.option("contentTemplate", content);
            popup.option('title', 'Detil Data');
            popup.show();
        }
    }


    function popupClosed(e) {
        var popup = $("#popupArea").dxPopup("instance");
        var content = '<iframe src="http://" width="100%" height="100%" frameborder="0" />';
        popup.option("contentTemplate", content);
        var grid = $("#gridView").dxDataGrid("instance");
        grid.refresh();
    }


    function HeaderBoldTemplate(s, e, arg) {
        //console.log(s, e, arg);
        var hcontent = '';
        if (e.rowType == 'header' && e.column != null) {
            hcontent = '<b>' + e.column.caption + '</b>';
        }
        $('<div style="text-transform: capitalize;">').html(hcontent).appendTo(s);
    }

    function exportToExcelFormatter(e) {
        detilformData = "&onAction=exportToExcel&actionData=ManajemenUser";
        $('#formSendData').submit();


        var workbook = new ExcelJS.Workbook();
        var worksheet = workbook.addWorksheet('@ViewBag.Title');
        const imageBI = workbook.addImage({
            base64: '"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMwAAAAjCAIAAABXUnLyAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAABG8SURBVHhe7Vx5XE7Z/z9kaSNKyp7sDDP2bUTatFJJpSgladGQFowte1JZkkjUoJGGys7YBjONSCPSgihjGDPMb+Y7YzDo+z7POc/tPs9za/q+fn/2vF/n5XU/55x77rnn8z6f5dxHpObfcPZiUVhUysAxIYY9phv39haX9j2nmwya5ROUkPnVN7y3GmqooD6S7dx7qoXhZA0Dx9ad3cCwdqaebbpNUyp6Xdx0O7q2bD+FaFnPi0rhd6qhhgjSJHvx4g+j3l7NDBwNe3LrBYaNslro5rPewT3GYvISVmxclqFmuPl8tBr18tIydtE0mnLs1DU+ihpqyCBBsqTU46SpuYGpp+AWGckGm4VlZl+6c7eK95NhX9YF7zmbYNJYNxg8ojPJwz+WN6uhhirJvAPiSCvbVp2mahk7K5XmhpOJtg0hwx5WPfv1xe8fPnxo1s6JtLBs2tZBt5OrOGJD5459Z/AR1Wj0UCBZ5LI00sYeDFsTd3B/1oUdaSfith4WStq+sxmZ51A2bjm8PvEQSmrGmR17TiZsz4levlffxANUE3iGMK7bwFl8XDUaN2pJdvx0AYJ38AO+Dx7QyXNV7ol83iaDb3AiKl2815rZRo+yXDjSItzTL/ZQzhXeXFODcE2ng4vAMyQNC5ak8jY1GjFqSdbMwKm9PMynmWPXaYjMrt+s4M01NRMcFsEPEt1Jt25X/vXqNWqYr+zxiT/rAHTu74PoTeAZaWlZVFzJ29RorOAks3dfCS8pkIMVUGptfBbrACCdBPnAqrtl1awGIRq66XR0HTxuHqvZkXZSy8hZGAGE0+syjTWp0WhBSVZa8Zg5SqUCkm3adoT1AwSSCQkmI5lRLy+iPYnVXPjmFrIB8SBwmhu3HmatajROUJJZTfkczlHMDFYaSDIU0tKK1Xx/o0zDwFEYAQUuuGlbR9Yqib7DAjv1m4nktFXnqSMmLkjNOM0bpFD58OnmHXlcEOFR9c/NDZw69JnRe9gcXqWIT20ikZpM9VnPxDFWC9EZEcLr129ZDWDjsqwD3qWNfXbeVV6lAtOP/Tv2nanXxQ3X+ddKNdtPMe7ljRtZqxK6DPDBQ8OX7MY1knGiM4no2aG/cS8vJ8/Vu9Lre9OyisfTA+K0jF0IGUvIOPgE78D4Fy//4M0yDDELMzT11O7g8vfrN7xKhMTtuW26ubftyj1JaGQKFrlLfx+4rLbd3DENjBkcnsxagVnBm0krW0LG41+E13/+9Tcq53yWhLt0OrhiPqybEo6dKjh68l9ORinJiKY1rJGYGaw0kGQG3T16Dp7NavZlXWiJdVccp0kbh4LCctZBFZ7+G9EhKHx7yp6Tmoj5dGwQ/PE2Fdi7x+ibuHNBEVXVz1u2nwyKJKed4FUihEQkY+TVcQeZuGLdfg19x+6D/JgInDx7nZJAw/zKd3d4lRQ8/GNxo8Cq0vLHeCJuPHuhiNWI4ey1Bku07+AFJvYeEoAlDQjbui4+C0yl6mxpKbmpnL3XEDK6Y58Zq2K/TEzOjV6xV9NoCgiKKHl9wiHeSQaTQX6aRs5jrCO4LMLl/Dt4+nDz+UzMyDyPdcbWunilOGZD5nj7RYQMffPmH9YKNYFboKCH/8bBZmFouvHDPdRn515tqu9Imk1k3VRh+rHfwDEhXKgD5EbRPayamBNCaSDJ4Gr3Z11kNWZ20XSXKI6DoG1xTDrroIqo5XuIru0WuX1qKTuNO3O+kIli/N/vf8JkEj37y3XwwNZ1Bc1XNK0q7j/hVXJAVRg2YXsuE/ce+BrjWDtzrvz8/De8Bcp31+6ymrqwNv4QlA3Kclm2ythm0NC79+95lRzBC7fjobknv2eih18sHrol5SgTL10pppZDyzpqxR5WwyDT8fiVsZlcliM0ckcTGaHFgXLy7hNQE5QSt005Jikpq8LTrSZ/zsTCH+5j5iZS50qbth7GTMxFe/vb/JLikoe4KK2oJq3txLmdGPkFZWjFlMrv/8irpEC2puTB3irRgpW6SHa3jFtOEJy0sPh8zT4mQkOYq9IgKKCd5FZjSNieg7UQHuToHoNHrJGbHDGw+eBS9bpO6zsikFcpwsKJzhAFfpBXyYHxQdCj8k9eUDxWB/2ZCGMAZdfvqRnik47gxsAF27hcU9PtI19ZfuOmev6Mbni1nOP8JCgInGttJ17SJ09foAM8ybHTBaxmweJUom3tH7qFiUqYMz8JSsEu+uXX31kNRkMN/dDSzEJIyBhu332EwYV3vFP6CE/HbJkoxljrSPDv1DmJjU0HqeMuoO/wQGgEBe6VV0mBzArZArUp0YIVVZKBjph3wY3yH24/gA3vM2wO4zuAvBJNkm63fU8vDX0H1k0VVP0iknUbOAuGTXAxAu49eAKW9BoS0HvoHBCi4oGyrQKwoLqdXEdahIM0ggdnoE9paSXoGxdYO0vZLu83IpDoTgr4rJY39YCOo0KytibuPT6ZjRRHKThTIhkVFUkGfL76C7hCqADX79+/B4HwdqxJEuiJtxMOIDEanttvZBBVjZ49q2RQIlk9dBlvF41BvOds4rII9dxFzZiWNXZ+534zSQtLpXhRDDLKKlx8siUuSiQbZxeF2cxdkBS8MHl9YvavL/hmApA/0s+d3T2URhAKtPjh/QfeWxFUbdo223Yew7XMIziYShnnTydFwkwezvs24+B5rKa5o0TchgWFGcBF267uMGbiVaNPUSHZdP84ajn07OHlWf2/go6jQjLUvH7ztpmBI+zBuoRaX9YQkiFlwSuj/vGPv6RnnkMA1G/kXN4mhZjYzOaGk/uP4H3Y6n2Vd9Vt5nq8cleRN5QkGZw7E8WgwUMrW0RNfqGbeZUc9ZAMZgxqReiyauOXWEPfoETeoALSdYCvpPlBUSLZ8InzMzLPVT56du7SDwhdQTgEW44eq1grdiFSobqMIoKJe5UStgfAI9Dq6beRZlLaNgamnrxBBGrGNK10O01lIrqBMS9/+w8TBVCSyfJc7CrS3AIWUfCAVBmKJMOawoZBwdCNkqOpB3QcVZJp2+ACoSp9aAvLb6+VsqaGkAxARgJDcubCzfAlqc3bOdWVqzLcuFmBmeMWJtL5aNvEJ+XgGk4TRHf2WsuaVEmGlzXqNR22Z5xt1ETHxf1HBiHnZa00R2ltp2XkDA1evHyLVQJ1kYyaMW2bTv1mMhF7G1bt7T/vmKgEgvvbN4xkcJeIlpAQRSzbc/p8IeJcaBF9Og/w4T1kGb5q4I8CGt1/+JR3UgRbpqTU47ieOz8JUSQyINYkgJoxPfuvL/IMDrdgJti7TBTASPa37FQi78T3GBbUfFj1DCJ9ioolm+az4UD2JRp9S4XtkqDjSJGMPTQOFl3PHqO9lp0pNJRkupOQkmflXFkUkw62jbZcyBukcLe8ugm0oEgyNubrv99gKDx98w6a30iRzL5DH28k8h+PDSVkFKJh1sSQmnEGREG8gbu8ArgTqItkMGOYBnIXJoZGpIDBmD8TlUDMbKPrcnOqJGOB/wM5XTAbdMO0Pv6Un/gDMAzC5ymhUHcp3zRKEC8T4BuciOmOmxTFRICaMW0bcJeuIJmAgsWiCZ2OzT/vFLaOmGSAb/Bm7Gy8Ba43J+epkowpAJsYtqGBPxuhs62bZIC5w2IQBUYF1yy7rJ9k9yufQluYwLXC8oNffQNL1sJwCm+TQmHRPQyi5C6FMWFEYQXAlarHzyurnqFJTDLcKD61kQT4gBUDU1kWLEkyllTSRF6uEcyfaYT3UARBItPwwF/yCAOFtLEXTjHgUrFSwiAoCPyb6SunewJoviZaJng6cAhO5x+57YUZw0wsJy8JiUgOnL8NZV5UyqCxodj9YdE7WR8GRrI3b/nZD4A8FN1GWiw4cOgSrJokyQCEMqBj/X6KgSq1XpIBYBh4NtVn/coNB7Du9ZMsasVelk7h+oMs8McuVfppghiLVqaDAZHL0phI5yNaPWDp6i+gDkQysHnid6zLJqnCzC4Kt/cdRlN4ybuwqkhWHN1jEJ0zjYRFp4D3mPkmlZMUgGzbefR/PcJQJRmWFbpklQDyedQI48AIgSi8TQVrNmXBRQoP+uM/r6jH0Zn040+/QLxf+RP19zr8s5UAeuoDN6erUG81ZSk28ZOnL7gsA9jTurNbx34zsQRHT/MjDFyIFQDQo07FsF0SCdtzcaOYZCZIhxVJRt2W7Dd5iHfxUIFkwRFSRxg6Nli60IgdrCbwsyQQVEPfqS7DT41HC0suSJEMGCfbltjbUEQtyeo+wlDC7i/OwkywX2qp3nUMS4e360y/eYhx7Xo5esKkcVkEcvPWAzQIhBCXhpMMBQ8olX958AmKh16FJp0OLktiMliTKoLCk3BvYjI/Jg2J2IFFZ+4GGGw2Dy8cuVzhuJKh+yB/5FnRK/ZyuaZm4OhgvH9JGZ8eQ8V9mjTAg+N1Nm75ilUieMKLiE0XYn9YQXHYLon5i3fBm4dG1h7GGvf2wh54904hpDt7sQh0h5rBGOEw1sE9Bvdu3Sk/jL1ajO2kbexi3Meb1TBAhJ3Q6eBarnKkDJ9OyPhcOWsBGgXq2Kh+atPt6Ar/BX1h47Ga4pKHWGfVw9hnz3+7eLV4XXzth4RBY0OwMxG64ZrdJc5JMQdoBP6HyyIgmEZ2nKryuUz2WUnr//VZiRUwI0l2DAFgxmLrCPfHvlFIYoL9Imhi8aqMC5dvTfNdTxM0Taunz16i6fiZAlgXKAYRBussxq7003goWMXlmpq2smPYw3nfclmO5LQTWBdMaXXcl6wG7gaZlFIcFha1k3ouXdv3H+pMAjz9YsGACQ6LuSxbPezSG0XKLxi+ZDcIhBnuy+JnfkPHf4bxfebGr4k7SD8rtbDEAsLqsFYxhpiFgbhYilGWC2M3Z2MHQuW0fxNzJU/qE5SAV/YNTuCyHEi9Mbi+iQdifFbz5eFv0LPLAB9E60eOfbchMdt1xjpCxhTeul927zEhn340KihiaVrPoQFYcw0DbpCyjlyGdoRFPpR7hX5l0rP7S/ZlUwkbErI1jZxVjRklmY3rUsmw7H+zZK1sH8nyOMDNdwMMNauHCZE0oQLwntAT/ZBHzLp9NCtiWdpbWVD155+v8OZEE01DWU8l5F8vJWQ00TDv3J+mt69evUFPjDN99kbWQQzomzSZwHoCYBjVGRnCRAGEDKf1GhPFH87FgNmgkTUZwcRbtysJGUnIOIRWrEYMumHIhDFW/GsHIcOwYphGs3ZOJoP8Zs6Nzy+o02qeOHN9nG00VhWDY4kMTD0lP83B4GEFYBG5LAICJtmqDmYiloWKdD3HsI/uKEgS0YQEHDrCW0MFzQ2dQhZy3w3YTl2BCSMVLSisoJ/1sOBUWdIaOZhzWTb4+OETF/AqGSjJ7j34Cc8W6CKUhpOsnakn/COrBLSMXYQEEx4tYbuEaVWj8YCSDJg8fbWu1I8Wxd/8JzguYiRT+tGiYQ9P7ImfnvFwG94aPoKNAPIh0WX1ajRacJIBiFrE/8sS9hl+4ez5m7yZ/v5kLbXezS2u3Shnp+0wjAiYkO5Wyk/O9uz/GuaUDYIC13NbbvbUaLSoJdnJszcYP8CwgaNDenwye/m6A7xNjp3pp7bsyFu+bj/iA5QtKXni38bMCIwHCwWGIWBEIMnb1GjEqCUZEL1iL2ljjyiqrOIxorzHT365c/eRUErKqh9V/1z94/Oi4gdIplCqqp+jZ3rmedCrqT7935cCwxCidZf6FqtGI4QCyYCZcxNgjcAzxF5KhZ6RtrZDfnH6XOGlq7eL7zxERo3OsFigVPuetYcgCOaQovMR1Wj0UCYZkLz7hOqfKUC22HNwQJ9hc+zcVvJ+NTVHjud3HeDbfZCfkEsayv5MwXT1nylQQwQJkgEvX/5h1EvhD67om3hYTVlaUlp1Nb8k90R+znFavr5YBHs2f3Fq6y5u6M//4Ir8040aajBIk4xB6U9HgWdwo0qlmYET+tCTd03reZG1h3hqqCGgPpIx5Bz/zmt2HPshh4a+I/iEkAv/ws7R6M3Ayd5t5a69p3hvNdRQwb+TTIzbJY/AuV3ppzOzL12/WcH+a54aatSHmpr/AhtJdxKZPlCDAAAAAElFTkSuQmCC',
            extension: 'png',
        });


        worksheet.columns = [
            { width: 30 }, { width: 30 }, { width: 30 }, { width: 30 }
        ];

        DevExpress.excelExporter.exportDataGrid({
            component: e.component,
            worksheet: worksheet,
            keepColumnWidths: false,
            topLeftCell: { row: 5, column: 1 },
            customizeCell: function (options) {
                var gridCell = options.gridCell;
                var excelCell = options.excelCell;
                if (gridCell.rowType === "header") {
                    excelCell.alignment = { horizontal: 'left' };
                    excelCell.fill = { type: 'pattern', pattern: 'solid', fgColor: { argb: "e9ecef" } };
                }
            }
        }).then(function (dataGridRange) {

            // header
            var headerRow = worksheet.getRow(2);
            headerRow.height = 30;
            worksheet.mergeCells(2, 2, 2, 4);

            headerRow.getCell(2).value = 'Master Provinsi';
            headerRow.getCell(2).font = { name: 'Segoe UI Light', size: 22 };
            headerRow.getCell(2).alignment = { horizontal: 'center' };
            headerRow.getCell(2).fill = { type: 'pattern', pattern: 'solid', fgColor: { argb: "5c95c5" } };
            worksheet.addImage(imageBI, 'A2:A2');

            // footer
            var footerRowIndex = dataGridRange.to.row + 2;
            var footerRow = worksheet.getRow(footerRowIndex);
            worksheet.mergeCells(footerRowIndex, 1, footerRowIndex, 4);

            footerRow.getCell(1).value = 'Perizinan';
            footerRow.getCell(1).font = { color: { argb: 'BFBFBF' }, italic: true };
            footerRow.getCell(1).alignment = { horizontal: 'right' };
            footerRow.getCell(1).fill = { type: 'pattern', pattern: 'solid', fgColor: { argb: "5c95c5" } };

        }).then(function () {
            setTimeout(function () {
                if (thisSendFormDataCompleted != null) {
                    var fileNameXls = thisSendFormDataCompleted;
                    workbook.xlsx.writeBuffer().then(function (buffer) {
                        saveAs(new Blob([buffer], { type: "application/octet-stream" }), fileNameXls);
                    });
                    thisSendFormDataCompleted = null;
                }
            }, 1000);

        });
        e.cancel = true;
    }

    $(function () {
        function exportToPDF($filename) {
            var doc = new jsPDF();
            var dataGrid = $("#gridView").dxDataGrid("instance");
            DevExpress.pdfExporter.exportDataGrid({
                jsPDFDocument: doc,
                component: dataGrid
            }).then(function () {
                doc.save($filename);
            });
        }
        window.exportToPDF = exportToPDF;
    });
</script>