zhaozhiqiang
/
YH_Web_UI


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397
							<!DOCTYPE html>
<html>

<head>
    <meta charset="UTF-8">
    <script src="../../Script/Common/huayi.load.js"></script>
    <script src="../../Script/Common/huayi.config.js"></script>
    <script src="../../js/bootstrap-select/js/bootstrap-select.js"></script>
    <script src="../../js/bootstrap-select/js/i18n/defaults-zh_CN.js"></script>
    <script src="../../Script/Common/regexs.js"></script>
    <script src="../../js/autosize/autosize.min.js"></script>
    <link rel="stylesheet" href="../../css/init.css" />
    <link rel="stylesheet" href="../../css/Table/table1.css" />
    <link href="../../js/bootstrap-select/css/bootstrap-select.css" rel="stylesheet" />
    <title>设备导入信息</title>
    <style>
        .btns {
            background: #18a689;
        }

        .btns {
            color: rgb(255, 255, 255);
            font-size: 12px;
            margin-left: 15px;
            box-sizing: border-box;
            background: rgb(26, 179, 148);
            padding: 6px 10px;
            outline: none;
            border-width: 0px;
            border-style: initial;
            border-color: initial;
            border-image: initial;
            border-radius: 3px;
        }

        .fr {
            float: right;
        }

            .fr p {
                display: inline-block;
                margin-bottom: 0;
            }

        .fl {
            float: left;
        }

        .tab-head {
            border-bottom: 1px solid #c6c6c7;
            padding-left: 0;
        }

            .tab-head li {
                float: left;
                width: 10.5%;
                text-align: center;
                padding: 13px 0;
                font-size: 16px;
                color: #333333;
                cursor: pointer;
            }

            .tab-head .tab-head-active {
                border-bottom: 3px solid #00a4ff;
                color: #00a4ff;
                margin-bottom: -2px;
            }

        .tabs-details {
            display: none;
            padding: 20px 0;
            border-bottom: 1px solid #c6c6c7;
            margin-bottom: 15px;
        }

        .showtabs {
            display: block;
        }
    </style>
</head>

<body class="gray-bg">

    <div class="wrapper-content animated fadeInRight">

        <!--<div class="th-box">
            <div class="form-inline th-bar clearfix">
                <div class="form-group">
                    <input type="file" id="upFile" name="upFile" accept=".csv, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel">
                </div>
                <div class="form-group">
                    <input type="text" id="keyword" class="form-control" placeholder="请输入文件名称">
                </div>
                <div class="form-group time-box">
                    <i class="tub fa fa-calendar"></i>
                    <input class="form-control search_time" type="text" id="startTime" placeholder="请选择时间">
                </div>
                <div class="form-group tool_bars pull-right">
                    <input type="button" class="btn_gray" id="sc_btns" value="搜索" />
                    <input type="button" class="btn_gray" authorize="yes" id="HY_subImport" onclick="btn_subImport()" value="导入" />
                </div>
            </div>
        </div>-->

        <ul class="tab-head clearfix tabFirst">
            <li class="tab-head-active">
                文件导入
            </li>
            <li>
                文件搜索
            </li>
        </ul>

        <div class="tabCon">
            <div class="tabs-details showtabs form-inline">
                <div class="form-group time-box ">
                    <select class="form-control selectpicker" id="province" data-live-search="true">
                        <option value="">请选择省</option>
                    </select>
                </div>
                <div class="form-group time-box">
                    <select class="form-control selectpicker" id="city" data-live-search="true">
                        <option value="">请选择市</option>
                    </select>

                </div>

                <div class="form-group time-box">
                    <select class="form-control selectpicker" id="proname" data-live-search="true">
                        <option value="">请选择项目名称</option>
                    </select>
                </div>

                <div class="form-group time-box">
                    <select class="form-control selectpicker" id="build" data-live-search="true">
                        <option value="">请选择楼</option>
                    </select>
                </div>
                <div class="form-group time-box" style="display: none;">
                    <select class="form-control selectpicker" id="floor" data-live-search="true">
                        <option value="">请选择楼层</option>
                    </select>
                </div>
                <div class="form-group time-box">
                    <select class="form-control selectpicker" id="protype" data-live-search="true">
                        <option value="">请选择项目类型</option>
                    </select>
                </div>
                <div class="form-group time-box">
                    <select class="form-control selectpicker" id="systemname" data-live-search="true">
                        <option value="">请选择系统名称</option>
                    </select>
                </div>
                <div class="form-group time-box" style="display: none;">
                    <input type="file" id="upFile" name="Files" accept=".csv, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel">
                </div>
                <!--文件导入-->

                <input type="button" class="btn_gray form-control" authorize="yes" id="HY_subImport" onclick="btn_subImport()" value="导入文件" />
 				<a href="" download="设备信息导入模版.xls" title="点击下载导入模板" class="mb">下载模板</a>

            </div>

            <div class="tabs-details form-inline">

                <div class="form-group time-box">
                    <input type="text" id="keyword" class="form-control" placeholder="请输入文件名称">
                </div>
                <div class="form-group time-box">
                    <i class="tub fa fa-calendar"></i>
                    <input class="form-control search_time" type="text" id="startTime" placeholder="请选择时间">
                </div>
                <input type="button" class="btn_gray form-control" id="sc_btns" value="搜索" />

            </div>

        </div>
        <table id="tbResult1" data-row-style="rowStyle" data-query-params="queryParams" data-pagination="true">
            <thead>
                <tr>
                    <!--<th data-field="fileid" data-align="center">文件id</th>-->
                    <th data-field="filename" data-align="center">文件名称</th>
                    <!--<th data-field="filenewname" data-align="center">文件新名称</th>-->
                    <th data-field="fileurl" data-align="center" data-formatter="formatterFileurl">文件路径</th>
                    <th data-field="createby" data-align="center">上传用户</th>
                    <th data-field="createtime" data-align="center">上传时间</th>
                    <th data-formatter="formatterOperate" data-align="center">操作</th>
                </tr>
            </thead>
            <tbody id="tbody"></tbody>
        </table>
    </div>


    <!--<script src="../../js/visit/ajaxfileupload.js"></script>-->
    <script src="../../js/laydate/laydate.js"></script>
    <script src="../js/equipmentCommon.js"></script>
    <script>
        $(function () {
            laydate.render({
                elem: '#startTime',
                range: '~',
                theme: '#249fea'
            });
            $('#sc_btns').click(function () {
                getDr();
            });
            getDr();
            tabs($('.tabFirst li'), $('.tabCon'));

            //省市
            getProvinceCity($('#province'));
            //项目类型
            helper.getDropList.getlistDropByDic($('#protype'), 'XMLX');
            //系统名称
            helper.getDropList.getlistDropByDic($('#systemname'), 'XTMC');


        });
        $("#upFile").change(function () {
                        upload();
                    });
        function btn_subImport() {
            if (!$("#province").val() || !$("#city").val()) {
                layer.confirm('请选择省市！', {
                    icon: 2,
                    btn: ['确定'] //按钮
                });
                return;
            }
            if (!$("#proname").val()) {
                layer.confirm('请选择项目名称！', {
                    icon: 2,
                    btn: ['确定'] //按钮
                });
                return;
            }
            if (!$("#build").val()) {
                layer.confirm('请选择楼！', {
                    icon: 2,
                    btn: ['确定'] //按钮
                });
                return;
            }
            if (!$("#systemname").val()) {
                layer.confirm('请选择系统名称！', {
                    icon: 2,
                    btn: ['确定'] //按钮
                });
                return;
            }
            $("#upFile").trigger('click')
        }
        //tab切换
        function tabs(ele1, ele2) {
            ele1.click(function () {
                $(this).addClass('tab-head-active').siblings().removeClass('tab-head-active');
                var index = $(this).index();
                ele2.children('.tabs-details').eq(index).addClass('showtabs').siblings().removeClass('showtabs');
            })
        }
        //列表
        function getDr() {
            var $tableLeft = $('#tbResult1');
            $tableLeft.bootstrapTable('destroy');
            //初始化表格,动态从服务器加载数据
            $tableLeft.bootstrapTable({
                method: "get", //使用get请求到服务器获取数据
                url: huayi.config.callcenter_url + "equipmentapi/api/equipment/getimportlistbypage",
                striped: true, //表格显示条纹
                pagination: true, //启动分页
                pageSize: 10, //每页显示的记录数
                pageNumber: 1, //当前第几页
                fixedColumns: true,
                fixedNumber: 3,
                pageList: [5, 20, 50, 100], //记录数可选列表
                search: false, //是否启用查询
                showColumns: false, //显示下拉框勾选要显示的列
                showRefresh: false, //显示刷新按钮
                sidePagination: "server", //表示服务端请求
                //设置为undefined可以获取pageNumber，pageSize，searchText，sortName，sortOrder
                //设置为limit可以获取limit, offset, search, sort, order
                queryParamsType: "undefined",
                queryParams: function queryParams(params) {
                    //设置查询参数
                    var param = {
                        pageindex: params.pageNumber,
                        pagesize: params.pageSize,
                        keyword: $('#keyword').val(),
                        stime: $('#startTime').val() && $('#startTime').val().split(' ~ ')[0],
                        etime: $('#startTime').val() && $('#startTime').val().split(' ~ ')[1]
                    };
                    return param;
                },
                onLoadSuccess: function (data) {
                    //加载成功时执行
                    var newDataL = {};
                    newDataL.state = data.state;
                    newDataL.message = data.message;
                    newDataL.rows = data.data.rows;
                    newDataL.total = data.data.total;
                    $('#tbResult1').bootstrapTable('load', newDataL);
                    $('.tool_downs').authorizeOperateButton();
                },
                onLoadError: function () {
                    //加载失败时执行
                    //layer.msg("加载数据失败", { time: 1500, icon: 2 });
                }
            });
        }
        //删除
        function btn_subDelete(ids) {
            layer.confirm('确定删除当前记录？', {
                btn: ['是', '否'] //按钮
            }, function () {
                /*发送请求*/
                $.ajax({
                    type: "post",
                    url: huayi.config.callcenter_url + "equipmentapi/api/Equipment/deleteimport",
                    async: true,
                    dataType: 'json',
                    data: {
                        ids: ids
                    },
                    success: function (data) {
                        if (data.state.toLowerCase() == 'success') {
                            layer.msg("删除成功！");
                            getDr();
                            parent.$('#equipment_table').bootstrapTable('refresh');
                        }
                    }
                });
            });
        }
        //上传文件
        function upload() {
            var formData = new FormData();
            formData.append("Files", document.getElementById("upFile").files[0]);
            //formData.append("type", 'equipment');
            formData.append("projectid", $('#proname').val());
            formData.append("province", $('#province').val());
            formData.append("city", $('#city').val());
            formData.append("protypeid", $('#protype').val());
            formData.append("systemid", $('#systemname').val());
            formData.append("bulidingid", $('#build').val());
            $.ajax({
                url: huayi.config.callcenter_url + 'equipmentapi/api/equipment/importexcel',
                type: "POST",
                data: formData,
                /**
                 *必须false才会自动加上正确的Content-Type
                 */
                contentType: false,
                /**
                 * 必须false才会避开jQuery对 formdata 的默认处理
                 * XMLHttpRequest会对 formdata 进行正确的处理
                 */
                processData: false,
                success: function (result) {
                    document.getElementById("upFile").outerHTML = document.getElementById("upFile").outerHTML;
                    $("#upFile").change(function () {
                        upload();
                    });
                    var r = $.parseJSON(result);
                    if (r.state.toLowerCase() == 'success') {
                        layer.msg("导入成功");
                        getDr();
                        parent.$('#equipment_table').bootstrapTable('refresh');
                    }
                }
            });
        }

        //格式化操作
        function formatterOperate(val, row) {
            var str = '<ul class="tool_downs">' + '<li><a class="aBtn" authorize="yes" id="HY_subDelete_' + row.id + '" onclick="btn_subDelete(\'' + row.id + '\')">删除</a><li>' + '</ul>';
            return str
        }
        //格式化文件路径
        function formatterFileurl(val, row) {
            var str = '<a href="' + val + '" download="' + row.filename + '" title="' + val + '">下载文件</a>';
            return str
        }

        //模板下载
        $('.mb').click(function () {
            $(this).attr('href', huayi.config.callcenter_url + "equipmentapi/api/Equipment/downtemplate")
        })


    </script>
</body>

</html>