ViettechReport/SuperCms/Views/Registry/Index.cshtml

@{
    ViewData["Title"] = "Index";
    Layout = "~/Views/Shared/_Layout.cshtml";
}

@using SuperCms.Controllers;
@using SuperCms.Models;
@using System.Globalization;
@using SuperCms.Database;

@model RegistryViewModel

<script type="text/javascript" src="https://unpkg.com/xlsx@0.15.1/dist/xlsx.full.min.js"></script>

<div class="app-content content">
    <div class="content-wrapper">
        <div class="content-header row">
            <div class="content-header-left col-md-6 col-xs-12 mb-1">
                @*<h2 class="content-header-title">Message configuration</h2>*@
            </div>
            <div class="content-header-right breadcrumbs-right breadcrumbs-top col-md-6 col-xs-12">
                <div class="breadcrumb-wrapper col-xs-12">
                    <ol class="breadcrumb">
                        @*<li class="breadcrumb-item">
                        <a href="Index">Admin</a>
                        </li>*@
                        @*<li class="breadcrumb-item">
                        <a href="/Config">Tables</a>
                        </li>*@
                    </ol>
                </div>
            </div>
        </div>
        <div class="content-body">
            <!-- Basic form layout section start -->
            <section id="basic-form-layouts">
                <div class="row service-height">
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-header">
                                <h4 class="card-title" id="basic-layout-form">toolbars</h4>
                                <a class="heading-elements-toggle"><i class="icon-ellipsis font-medium-3"></i></a>
                                <div class="heading-elements">
                                    <ul class="list-inline mb-0">
                                        <li><a data-action="collapse"><i class="icon-minus4"></i></a></li>
                                        <li><a data-action="expand"><i class="icon-expand2"></i></a></li>
                                    </ul>
                                </div>
                            </div>
                            <div class="card-content collapse show">
                                <div class="card-body ">
                                    <div class="card-block">
                                        <div class="form-body">
                                            <form method="post" action="/Registry">
                                                <div class="row">
                                                    <div class="col-md-9" style="    margin: auto;">
                                                        <div class="row">
                                                            <div class="col-md-4">
                                                                <div class="form-group">
                                                                    <label for="txtThoigian">Thời gian quá hạn:</label>
                                                                    <select name="txtThoigian" id="txtThoigian">
                                                                        <option value="0">Tr&#234;n 1 đến 3 th&#225;ng</option>
                                                                        <option value="1">Tr&#234;n 3 đến 6 th&#225;ng</option>
                                                                        <option value="2">Tr&#234;n 6 đến 12 th&#225;ng</option>
                                                                        <option value="3">Tr&#234;n 12 đến 24 th&#225;ng</option>
                                                                        <option value="4">Tr&#234;n 24 th&#225;ng</option>

                                                                    </select>
                                                                </div>
                                                            </div>
                                                            <div class="col-md-4">
                                                                <div class="form-group">
                                                                    <label for="txtLoaiPT">Loại phương tiện:</label>
                                                                    <select name="txtLoaiPT" id="txtLoaiPT">
                                                                        <option value="1">&#212; t&#244; con</option>
                                                                        <option value="2">&#212; t&#244; kh&#225;ch</option>
                                                                        <option value="3">&#212; t&#244; tải v&#224; CD</option>
                                                                        <option value="4">Rơ-mooc v&#224; Sơ-mi Rơ-mooc </option>

                                                                    </select>
                                                                </div>
                                                            </div>

                                                            <div class="col-md-4">
                                                                <div class="form-group">
                                                                    <label for="cboTinh">Tỉnh, thành phố:</label>
                                                                    <select name="cboTinh" id="cboTinh" style="Z-INDEX: 0">
                                                                        <option value="67">An Giang</option>
                                                                        <option value="72">B&#224; Rịa-Vũng T&#224;u</option>
                                                                        <option value="98">Bắc Giang</option>
                                                                        <option value="97">Bắc Kạn</option>
                                                                        <option value="94">Bạc Li&#234;u</option>
                                                                        <option value="99">Bắc Ninh</option>
                                                                        <option value="71">Bến Tre</option>
                                                                        <option value="77">B&#236;nh Định</option>
                                                                        <option value="61">B&#236;nh Dương</option>
                                                                        <option value="93">B&#236;nh Phước</option>
                                                                        <option value="86">B&#236;nh Thuận</option>
                                                                        <option value="69">C&#224; Mau</option>
                                                                        <option value="65">Cần Thơ</option>
                                                                        <option value="11">Cao Bằng</option>
                                                                        <option value="43">Đ&#224; Nẵng</option>
                                                                        <option value="47">Đăk Lăk</option>
                                                                        <option value="48">Đăk N&#244;ng</option>
                                                                        <option value="27">Điện Bi&#234;n</option>
                                                                        <option value="60">Đồng Nai</option>
                                                                        <option value="66">Đồng Th&#225;p</option>
                                                                        <option value="81">Gia Lai</option>
                                                                        <option value="23">H&#224; Giang</option>
                                                                        <option value="90">H&#224; Nam</option>
                                                                        <option value="29">H&#224; Nội</option>
                                                                        <option value="38">H&#224; Tĩnh</option>
                                                                        <option value="34">Hải Dương</option>
                                                                        <option value="15">Hải Ph&#242;ng</option>
                                                                        <option value="95">Hậu Giang</option>
                                                                        <option value="28">Ho&#224; B&#236;nh</option>
                                                                        <option value="89">Hưng Y&#234;n</option>
                                                                        <option value="79">Kh&#225;nh H&#242;a</option>
                                                                        <option value="68">Ki&#234;n Giang</option>
                                                                        <option value="82">Kon Tum</option>
                                                                        <option value="25">Lai Ch&#226;u</option>
                                                                        <option value="49">L&#226;m Đồng</option>
                                                                        <option value="12">Lạng Sơn</option>
                                                                        <option value="24">L&#224;o Cai</option>
                                                                        <option value="62">Long An</option>
                                                                        <option value="18">Nam Định</option>
                                                                        <option value="37">Nghệ An</option>
                                                                        <option value="35">Ninh B&#236;nh</option>
                                                                        <option value="85">Ninh Thuận</option>
                                                                        <option value="19">Ph&#250; Thọ</option>
                                                                        <option value="78">Ph&#250; Y&#234;n</option>
                                                                        <option value="73">Quảng B&#236;nh</option>
                                                                        <option value="92">Quảng Nam</option>
                                                                        <option value="76">Quảng Ng&#227;i</option>
                                                                        <option value="14">Quảng Ninh</option>
                                                                        <option value="74">Quảng Trị</option>
                                                                        <option value="83">S&#243;c Trăng</option>
                                                                        <option value="26">Sơn La</option>
                                                                        <option value="70">T&#226;y Ninh</option>
                                                                        <option value="17">Th&#225;i B&#236;nh</option>
                                                                        <option value="20">Th&#225;i Nguy&#234;n</option>
                                                                        <option value="36">Thanh H&#243;a</option>
                                                                        <option value="75">Thừa Thi&#234;n-Huế</option>
                                                                        <option value="63">Tiền Giang</option>
                                                                        <option value="50">TP Hồ Ch&#237; Minh</option>
                                                                        <option value="84">Tr&#224; Vinh</option>
                                                                        <option value="22">Tuy&#234;n Quang</option>
                                                                        <option value="64">Vĩnh Long</option>
                                                                        <option value="88">Vĩnh Ph&#250;c</option>
                                                                        <option value="21">Y&#234;n B&#225;i</option>

                                                                    </select>
                                                                </div>
                                                            </div>

                                                        </div>
                                                    </div>
                                                    <div class="col-md-3">
                                                        <div class="form-group" style="padding: 25px; border: 1px solid #eeeeee; margin:auto">
                                                            <div>
                                                                <button type="submit" class="btn btn-blue button-style">
                                                                    <i class="icon-search"></i> Download
                                                                </button>
                                                                <button type="submit" class="btn btn-blue button-style" onclick="ExportToExcel('xlsx')">
                                                                    <i class="icon-search"></i> Export
                                                                </button>
                                                            </div>
                                                        </div>
                                                    </div>

                                                </div>
                                            </form>

                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="col-12">
                        <div class="card">
                            <div class="row card-content" style="margin:0;">
                                @{

                                    <div class="col-md-12 table-responsive" style="padding:0;">
                                        <div class="row">
                                            <div id="divPrint"></div>
                                        </div>
                                    </div>

                                    <div class="col-md-12 table-responsive" style="padding:0;">

                                        <div id="divShow" class="table-responsive">
                                            <table id="tbl_exporttable_to_xls" class="table table-hover mb-0 ps-container ps-theme-default">
                                                <thead>
                                                    <tr>
                                                        <td> Số TT </td>
                                                        <td> Biển đăng ký</td>
                                                        <td> Ngày đăng ký</td>
                                                        <td> Nhãn hiệu </td>
                                                        <td> Chủ phương tiên</td>
                                                        <td> Địa chỉ </td>
                                                        <td> Ngày kiểm định</td>
                                                        <td> Đơn vị KĐ</td>
                                                        <td> Số GCN KĐ</td>
                                                        <td> Thời hạn GCN</td>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @Html.Raw(Model.table)
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                }
                            </div>
                        </div>
                    </div>
                </div>
            </section>
            <!-- // Basic form layout section end -->
        </div>
    </div>
</div>

<script>

    function ExportToExcel(type, fn, dl) {
        var elt = document.getElementById('tbl_exporttable_to_xls');
        var wb = XLSX.utils.table_to_book(elt, { sheet: "sheet1" });
        return dl ?
            XLSX.write(wb, { bookType: type, bookSST: true, type: 'base64' }) :
            XLSX.writeFile(wb, fn || ('MySheetName.' + (type || 'xlsx')));
    }

</script>

<form action="/Support" method="post" id="support-form">
    <input type="hidden" id="actionFile" class="actionFile" name="actionFile" value="" />
    <input type="hidden" id="tableType" class="tableType" name="tableType" value="" />
</form>

<form action="/Support/Download" method="post" id="support-download-form">
    <input type="hidden" id="tableTypeDownload" class="tableType" name="tableType" value="" />
</form>