61.19.244.139/61.19.244.139.zip/61.19.244.139/2015-03-03/views/export-policy.jsp

Text File | 2015-03-03 | 8KB | 262 lines

 <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" trimDirectiveWhitespaces="true"%>
<%@ taglib uri="http://tiles.apache.org/tags-tiles" prefix="tiles"%>
<%@ taglib prefix="spring" uri="http://www.springframework.org/tags"%>
<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>

<spring:url value="/bui/get-policy-list-export" var="get_policy_list_exportUrl" htmlEscape="true" />
<tiles:insertDefinition name="defaultTemplate">
    <tiles:putAttribute name="body">
        <ul class="breadcrumb">
            <li><a href="#">α╕½α╕Öα╣ëα╕▓α╕½α╕Ñα╕▒α╕ü</a><span class="divider">»</span></li>
            <li class="active">กรมธรรม์ </li>
        </ul>
        <div class="row-fluid">
            <div class="span12 ">
                <div class=" widget-block">
                    <div class="widget-head">
                        <h5>
                            <i class="black-icons  documents"></i> กรมธรรม์
                        </h5>
                    </div>
                    <div class="widget-content">

                        <div class="widget-searchbox">

                            <ul>
                                <li class="row-counts"><a class="btn btn-primary" id="exportBtn" href="#frm-box"> <i class="icon-share icon-white"></i> Export กรมธรรม์
                                </a> </li>
                                <li class="right">

                                    <fieldset>

                                        <div class="control-group">
                                            <div class="controls">
                                                <input class="input-small" type="text" id="policyIssueStartSearch" name="policyIssueStartSearch" placeholder="วันที่ทำกรมธรรม์ "> - <input id="policyIssueEndSearch" name="policyIssueEndSearch"
                                                    class="input-small" type="text" placeholder="วันที่ทำกรมธรรม์ "> <a class="btn btn-info" id="btSearch"> <i class="icon-search icon-white"></i> ค้นหา
                                                </a>
                                            </div>
                                        </div>

                                    </fieldset>

                                </li>
                            </ul>
                        </div>
                        <div class="widget-box">
                            <div align="center" id='jqgrid'>
                                <table id='grid'></table>
                                <div id='pager'></div>
                            </div>
                        </div>

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


        <br/>

        <br/>

        <br/>
        <div id="tableFrm"></div>



    </tiles:putAttribute>
    <tiles:putAttribute name="customScript">

    </tiles:putAttribute>

    <tiles:putAttribute name="customScript">
        <script type="text/javascript">

            function successFormat(cellvalue, options, rowObject) {
                return '<span class="label label-success">' + cellvalue + '</span>';

            }

            $(function() {


                $("#grid").jqGrid({
                    url : '${get_policy_list_exportUrl}',
                    datatype : 'json',
                    mtype : 'GET',
                    colNames : [ 'หมายเลขกรมธรรม์', 'ตัวแทน', 'วันเริ่มคุ้มครอง', 'วันสิ้นสุดคุ้มครอง', 'ประเภทกรมธรรม์', 'ทะเบียนรถ','เบี้ยประกันภัยรวม', 'ผู้เอาประกันภัย' ],
                    colModel : [ {
                        name : 'policyNo',
                        index : 'policyNo',
                        formatter : successFormat,
                        width : 20,
                        hidden : false
                    }, {
                        name : 'agentId',
                        index : 'agentId',
                        width : 10,

                        hidden : false,
                        align : 'left'
                    }, {
                        name : 'beginDate',
                        index : 'beginDate',
                        width : 10,
                        datefmt: "d-M-Y",
                        formatoptions: {newformat:'d/m/Y'},
                        formatter: function (cellval, opts, rowObject, action) {
                            return $.fn.fmatter.call(
                                      this,
                                      "date",
                                      new Date(cellval),
                                      $.extend({}, $.jgrid.formatter.date, opts),
                                      rowObject,
                                      action);
                        },
                        align : 'center'
                    }, {
                        name : 'endDate',
                        index : 'endDate',
                        width : 10,
                        hidden : false,
                        datefmt: "d-M-Y",
                        formatoptions: {newformat:'d/m/Y'},
                        formatter: function (cellval, opts, rowObject, action) {
                            return $.fn.fmatter.call(
                                      this,
                                      "date",
                                      new Date(cellval),
                                      $.extend({}, $.jgrid.formatter.date, opts),
                                      rowObject,
                                      action);
                        },
                        align : 'center'
                    }, {
                        name : 'polType',
                        index : 'polType',
                        width : 10,
                        hidden : false,
                        align : 'left'
                    }, {
                        name : 'vehLicense',
                        index : 'vehLicense',
                        width : 10,
                        hidden : false,
                        align : 'left'
                    }, {
                        name : 'totalPremium',
                        index : 'totalPremium',
                        width : 10,
                        formatter: "number", sorttype: "number", align: "right"

                    }, {
                        name : 'insureName',
                        index : 'insureName',
                        width : 30,

                        align : 'left'
                    } ],
                    postData : {},
                    rowNum : 20,
                    rowList : [10, 20, 40, 60,100,200,300,500,1000],
                    height : 380,
                    autowidth : true,
                    rownumbers : true,
                    pager : '#pager',
                    sortname : 'policyNo',
                    viewrecords : true,
                    sortorder : "asc",
                    multiselect: true,
                    emptyrecords : "Empty records",
                    loadonce : false,
                    loadComplete : function() {
                    },
                    jsonReader : {
                        root : "rows",
                        page : "page",
                        total : "total",
                        records : "records",
                        repeatitems : false,
                        cell : "cell",
                        id : "policyNo"
                    }
                });
            });

            $('#btSearch').click(function() {

                var f = {
                    groupOp : "AND",
                    rules : []
                };
                f.rules.push({
                    field : "policyIssueStartSearch",
                    op : "cn",
                    data : $('#policyIssueStartSearch').val()
                });
                f.rules.push({
                    field : "policyIssueEndSearch",
                    op : "cn",
                    data : $('#policyIssueEndSearch').val()
                });
                var grid = $('#grid');
                grid[0].p.search = f.rules.length > 0;
                $.extend(grid[0].p.postData, {
                    filters : JSON.stringify(f)
                });
                grid.trigger("reloadGrid", [ {
                    page : 1
                } ]);
            });



            $('#exportBtn').click(function() {
                var s;
                s = jQuery("#grid").jqGrid('getGridParam', 'selarrrow');

                if (s!=null&&s.length>0) {
                    $.ajax({
                        type : "POST",
                        url : "export-policy",
                        data : JSON.stringify(s),
                        contentType : "application/json",

                        success : function(data) {
                            var url = "download-export-policy?filename=" + data;
                            $('#grid').trigger("reloadGrid", [ {
                                page : 1
                            } ]);
                            $("body").append("<iframe src='" + url+ "' style='display: none;' ></iframe>");

                        },
                        error : function(xhr, ajaxOptions, thrownError) {
                            var obj = JSON.parse(xhr.responseText);
                            alert(obj.errorMessages);
                        }
                    });

                } else {
                    alert("กรุณาเลือก กรมธรรม์");
                }
                return false;

            });

            $('#policyIssueEndSearch').datepicker({
                dateFormat : 'dd/mm/yy',
                maxDate : new Date()
            });
            $('#policyIssueStartSearch').datepicker({
                dateFormat : 'dd/mm/yy',
                maxDate : new Date()
            });
                 </script>


    </tiles:putAttribute>
</tiles:insertDefinition>