ZYjames12345
/
zhujian_OA


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290
							<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" ng-app="app">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1,maximum-scale=1,user-scalable=no" />
    <title>工资2</title>
    <link href="../../AFrontEnd/css/animate.css" rel="stylesheet" />
    <link href="../../AFrontEnd/css/fontawesome/css/font-awesome.css" rel="stylesheet" />
    <link href="../../AFrontEnd/css/bootstrap.css" rel="stylesheet" />
    <link href="../../AFrontEnd/css/style.css" rel="stylesheet" />
    <script>document.write("<link href='../../AFrontEnd/css/special.css?time=" + new Date().getTime() + "' rel='stylesheet'>");</script>
    <link href="js/mintui.css" rel="stylesheet" />
    <link href="js/table.css" rel="stylesheet" />
    <style>
        .table-body-left::-webkit-scrollbar {
            width: 0;
            height: 0;
        }
        .Btn {
            float: left;
            min-width: 80px;
            height: 34px;
            overflow: hidden;
            white-space: nowrap;
            text-overflow: ellipsis;
            line-height: 18px;
            padding: 7px 0;
            margin: 0 10px;
            text-align: center;
            border: 1px solid blue;
        }

        .activeBtn {
            color: white;
            background: blue;
        }
            .activeBtn:hover {
                color: white;
            }
    </style>
</head>
<body>
    <div ng-controller="listCtrl as ctl" ng-cloak>
        <div class="loading" ng-if="ctl.loading">
            <div class="loading-msg">
                <h3>数据加载中，请等待</h3>
                <div class="spinner">
                    <div class="bounce1"></div>
                    <div class="bounce2"></div>
                    <div class="bounce3"></div>
                </div>
            </div>
        </div>
        <div class="wrapper wrapper-content">
            <div class="row">
                <div class="col-md-12">
                    <div class="ibox float-e-margins">
                        <div class="ibox-content">
                            <div class="row">
                                <div class="sp-page">
                                    <a class="Btn" href="list1.html">工资1</a>
                                    <a class="Btn activeBtn">工资2</a>
                                </div>
                                <div class="col-md-12">
                                    <div class="sp-page-tab sp-pl-30">
                                        <span ng-class="{'pageTabActive':ctl.tablename=='SX_TFWZZGZB'}" ng-click="ctl.changeTB('SX_TFWZZGZB')">在职</span>
                                        <span ng-class="{'pageTabActive':ctl.tablename=='SX_TFWTXGZB'}" ng-click="ctl.changeTB('SX_TFWTXGZB')">退休</span>
                                        <span ng-class="{'pageTabActive':ctl.tablename=='SX_TFWLXGZB'}" ng-click="ctl.changeTB('SX_TFWLXGZB')">离休</span>
                                        <!--<a class="sp-pull-right sp-btn-gray sp-btn-radius" ng-click="ctl.printOut()">
                                                <i class="fa fa-sign-in sp-mr-5"></i>导出
                                            </a>-->
                                        <a class="sp-pull-right sp-btn-gray sp-btn-radius" ng-if="ctl.tablename=='SX_TFWZZGZB'" ng-click="ctl.YINHANG()">
                                            <i class="fa fa-sign-in sp-mr-5"></i>生成给银行表格
                                        </a>
                                        <a class="sp-pull-right sp-btn-gray sp-btn-radius" ng-click="ctl.getData()">
                                            <i class="fa fa-search sp-mr-5"></i>查 询
                                        </a>
                                        <a class="sp-pull-right sp-btn-gray sp-btn-radius" ng-click="ctl.setPrintIn()">
                                            <i class="fa fa-book sp-mr-5"></i>导 入
                                        </a>
                                        <a class="sp-pull-right sp-ml-5 sp-mr-5 sp-color-blue" ng-if="ctl.tablename=='SX_TFWZZGZB'" style="line-height: 32px" download="导入模板-统发外在职.xlsx" href="moban2.xlsx"> 模板下载</a>
                                        <a class="sp-pull-right sp-ml-5 sp-mr-5 sp-color-blue" ng-if="ctl.tablename=='SX_TFWTXGZB'" style="line-height: 32px" download="导入模板-统发外退休.xlsx" href="moban3.xlsx"> 模板下载</a>
                                        <a class="sp-pull-right sp-ml-5 sp-mr-5 sp-color-blue" ng-if="ctl.tablename=='SX_TFWLXGZB'" style="line-height: 32px" download="导入模板-统发外离休.xlsx" href="moban4.xlsx"> 模板下载</a>
                                        <input type="text" class="sp-input sp-pull-right laydate-logo" style="width:200px" sp-laydate laytype="month" ng-model="ctl.date" ng-change="ctl.changeDate()" />
                                    </div>
                                </div>
                                <div class="sp-page table-head-left" style="width: 501px; overflow: hidden; position: relative; z-index: 1; ">
                                    <table class="sp-table">
                                        <thead>
                                            <tr>
                                                <!--<th><div style="width:35px"><input type="checkbox" ng-model="ctl.checkedAll" ng-click="ctl.checkAll()" /></div></th>-->
                                                <th><div style="width:36px">序号</div></th>
                                                <th ng-repeat="item in ctl.thead_left"><div style="width: 88px" ng-bind="item.cname"></div></th>
                                            </tr>
                                        </thead>
                                    </table>
                                </div>
                                <div class="sp-page table-head-right" style="width: calc(100% - 516px); height: 34px; overflow: hidden; position: relative; z-index: 1; ">
                                    <table class="sp-table">
                                        <thead>
                                            <tr>
                                                <th ng-repeat="item in ctl.thead_right"><div style="min-width: 188px;height:22px" ng-bind="item.cname"></div></th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <tr ng-repeat="item in ctl.list">
                                                <td ng-repeat="item1 in ctl.thead">
                                                    <div>
                                                        <div style="overflow:hidden;white-space:nowrap;text-overflow:ellipsis" ng-repeat="item2 in item[item1.PKID]" title="{{item2}}" ng-bind="item2"></div>
                                                    </div>
                                                </td>
                                            </tr>
                                        </tbody>
                                    </table>
                                </div>
                                <div class="sp-page table-body-left sp-pb-5" style="width: 501px; margin-top: -34px; overflow: auto; " onscroll="scrollTableL()">
                                    <table class="sp-table">
                                        <thead>
                                            <tr>
                                                <!--<th><div style="width:35px"></div></th>-->
                                                <th><div style="width:36px">序号</div></th>
                                                <th ng-repeat="item in ctl.thead_left"><div style="min-width: 88px" ng-bind="item.cname"></div></th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <tr ng-repeat="item in ctl.list">
                                                <!--<td><div style="width:29px"><input type="checkbox" ng-model="item.checked" ng-click="ctl.checkItem(item)" /></div></td>-->
                                                <td><div style="width:30px" ng-bind="$index+1"></div></td>
                                                <td ng-repeat="item1 in ctl.thead_left"><div style="width: 82px; height: 22px; overflow: hidden; white-space: nowrap; text-overflow: ellipsis" title="{{item[item1.code]}}" ng-bind="item[item1.code]"></div></td>
                                            </tr>
                                        </tbody>
                                    </table>
                                </div>
                                <div class="sp-page table-body-right sp-pb-5" style="width: calc(100% - 501px); margin-top: -34px; overflow: auto; " onscroll="scrollTableR()">
                                    <table class="sp-table">
                                        <thead>
                                            <tr>
                                                <th ng-repeat="item in ctl.thead_right"><div style="min-width: 188px" ng-bind="item.cname"></div></th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <tr ng-repeat="item in ctl.list">
                                                <td ng-repeat="item1 in ctl.thead_right"><div style="height: 22px;" title="{{item[item1.code]}}" ng-bind="item[item1.code]"></div></td>
                                            </tr>
                                        </tbody>
                                    </table>
                                </div>
                                <div class="sp-table-tip ng-hide sp-pull-left" ng-show="ctl.noDataTip == 0">
                                    <i class="fa fa-exclamation-circle sp-mr-10"></i>您好，暂未查询到相关信息！
                                </div>
                                <!--<div class="sp-page sp-mt-10">
                                    <div style="position: relative; overflow: auto;">
                                        <table class="sp-table" id="printOut">
                                            <thead>
                                                <tr>
                                                    <th width="50">序号</th>
                                                    <th style="min-width:100px" ng-repeat="item in ctl.thead" ng-bind="item.cname"></th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <tr ng-repeat="item in ctl.list">
                                                    <td ng-bind="$index+1"></td>
                                                    <td ng-repeat="item1 in ctl.thead">
                                                        <span title="{{item[item1.code]}}" ng-bind=" item[item1.code]"></span>
                                                    </td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </div>
                                    <div class="sp-table-tip ng-hide" ng-show="ctl.noDataTip == 0">
                                        <i class="fa fa-exclamation-circle sp-mr-10"></i>您好，暂未查询到相关信息！
                                    </div>
                                </div>-->
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="sp-layer" id="importDivPart" style="width:1000px">
            <div class="sp-center-900">
                <div class="sp-page sp-mt-5">
                    <div class="sp-lh-32 sp-page-col sp-span2">表名：</div>
                    <div class="sp-lh-32 sp-page-col sp-span3">
                        <select class="sp-select" ng-model="ctl.inport.tablename" ng-change="ctl.getInportTable()">
                            <option value="SX_TFWZZGZB">统发外在职工资</option>
                            <option value="SX_TFWTXGZB">统发外退休工资</option>
                            <option value="SX_TFWLXGZB">统发外离休工资</option>
                        </select>
                    </div>
                </div>
                <div class="sp-page sp-mt-5">
                    <div class="sp-lh-32 sp-page-col sp-span2"></div>
                    <div class="sp-page-col sp-span5">
                        <div class="sp-page-col" style="width:240px;height:32px;overflow:hidden">
                            <input type="text" class="sp-input" readonly ng-model="ctl.uploadFile" placeholder="未选择任何文件" />
                            <input type="file" name="xlfile" id="xlfile" />
                            <input type="checkbox" style="display:none" name="useworker" checked>
                            <input type="checkbox" style="display:none" name="userabs" checked>
                            <p id="out" style="display:none;"></p>
                        </div>
                        <a class="sp-pull-right sp-btn-gray sp-btn-radius" onclick="$(' #xlfile').trigger('click');">
                            <i class="fa fa-book sp-mr-5"></i>浏 览
                        </a>
                    </div>
                </div>
                <div class="sp-page sp-mt-5" id="table_excelHead" style="overflow-y: auto; max-height: 500px">
                    <table class="sp-table">
                        <thead>
                            <tr>
                                <th style="width:50%">数据库字段</th>
                                <th style="width:50%">数据源字段</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr ng-repeat="item in ctl.inport.thead">
                                <td ng-bind="item.cname" data-code="{{item.code}}" data-ckind="{{item.ckind}}"></td>
                                <td>
                                    <select class="sp-select" ng-model="item.cname1">
                                        <option ng-repeat="item2 in ctl.excelHeadData" value="{{item2}}" ng-selected="item2==item.cname">{{item2}}</option>
                                    </select>
                                </td>
                            </tr>
                        </tbody>
                    </table>
                </div>

                <div class="sp-page sp-mt-30 sp-text-center">
                    <button class="sp-btn-blue" id="btnTrueImportData" ng-click="ctl.btnTrueImportData()"><i class="fa fa-check"></i>&nbsp;&nbsp;<span>导入数据</span></button>
                </div>
            </div>
        </div>
        <div class="sp-layer" id="YINHANG" style="width:1000px">
            <div class="sp-layer-head" style="background:#2176d6">
                <div class="sp-page sp-text-center sp-font-16">
                    <div class="sp-layer-close" title="关闭" onclick="sp.closeCenter('.sp-layer')">
                        ×
                    </div>
                </div>
            </div>
            <div class="sp-layer-body sp-text-right sp-lh-30">
                <div class="sp-center-900">
                    <table class="sp-table" id="yh">
                        <tbody ng-repeat="item in ctl.yhList">
                            <tr>
                                <td class="sp-text-left" colspan="3" ng-bind="item.BANKNAME"></td>
                            </tr>
                            <tr>
                                <td>姓名</td>
                                <td>银行卡号</td>
                                <td>金额</td>
                            </tr>
                            <tr ng-repeat="item1 in item.DATA">
                                <td ng-bind="item1.XM"></td>
                                <td ng-bind="item1.YHKH"></td>
                                <td ng-bind="item1.SFYHKJE"></td>
                            </tr>
                        </tbody>
                    </table>
                    <div class="sp-page sp-mt-10 sp-text-center">
                        <span class="sp-btn-blue" ng-click="ctl.downloadYH()">下载</span>
                        <span class="sp-btn-blue" onclick="sp.layerhide()">关闭</span>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <script src="../../AFrontEnd/js/jquery/jquery-2.1.4.min.js"></script>
    <script src="../../AFrontEnd/js/laydate/laydate.js"></script>
    <script src="../../AFrontEnd/js/angularjs/angular.js"></script>
    <script src="../../AFrontEnd/js/angularjs/dirPagination.js"></script>
    <script src="../../apiurljs.js"></script>
    <script src="../../js/sm4.js"></script>
    <!-- 导入excel -->
    <script src="js/jszip.js"></script>
    <script src="js/xlsx.js"></script>
    <!-- 导出excel -->
    <script src="js/vendor/jquery.jqprint-0.3.js"></script>
    <script src="js/vendor/shim.min.js"></script>
    <script src="js/vendor/jszip.js"></script>
    <script src="js/vendor/xlsx.full.js"></script>
    <script src="js/vendor/Blob.js"></script>
    <script src="js/vendor/FileSaver.js"></script>

    <script>document.write('<scri' + 'pt src="../../AFrontEnd/js/special/special.js?time=' + new Date().getTime() + '"></s' + 'cript>')</script>
    <script>document.write('<scri' + 'pt src="js/list2.js?time=' + new Date().getTime() + '"></s' + 'cript>')</script>
    <script src="../../AFrontEnd/js/special/spng.js"></script>
    <script src="../../AFrontEnd/js/special/spngvld.js"></script>
</body>
</html>