<?php include(mvc::$cfg['PATH_TPL'] . 'public/header.php'); ?>
<?php include(mvc::$cfg['PATH_TPL'] . 'wages/common.php'); ?>
<style>
    input[type=file] {
        display: none;
    }
</style>
<!--BEGIN FROM DIV-->
<div class="wrapper wrapper-content animated fadeIn">
    <div class="row">
        <div class="col-sm-12">
            <div class="ibox float-e-margins">
                <div class="ibox-title">
                    <h5>通用凭证导入</h5>
                </div>
                <div class="ibox-content">
                    <div class="page-container">
                        <a href="<?php echo mvc::$cfg['URL_STATIC']; ?>img/import/voucher.fw.png" target="_blank"><img src="<?php echo mvc::$cfg['URL_STATIC']; ?>img/import/wages.fw.png" style="width:auto;max-width:100%;" /></a>
                        <h3>将Excel内容复制到下框中, 再次复制会自动清空原内容</h3>
                        <div class="alert alert-info text-wages" contenteditable="true" style="max-width:100%;max-height:200px;overflow:scroll"></div>
                        <button type="button" class="btn btn-w-m btn-primary btn-save type-wages">提交保存</button>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<!--END FROM DIV-->
<script type="text/javascript" defer>
    //获取上级页面
    var ele = (window.top).document.querySelectorAll('[data-id="' + urls.list + '"]')[1];
    var listIframe = parent;
    if (ele && ele.contentWindow) listIframe = ele.contentWindow;
</script>

<script type="text/javascript" defer>
    $(document).ready(function() {
        $('.btn-save').on("click", function(e) {
            if ($(this).hasClass('type-wages')) saveWages(this, $('.text-wages').html());
        });
        $('.text-wages').on('keydown', function(e) {
            var keyValue = e.which;
            if (e.ctrlKey == true && keyValue == 86) { //按了 ctrl
                $(this).empty();
            }
        });
    });
</script>

<script type="text/javascript" defer>
    var saveWages = function(that, excel_html) {
        var json = qg.excel.set({
            html: excel_html, //excel粘贴的html格式(table类型)
            colsMinCount: 26, //要求的最小列数
            colsMaxCount: 26, //要求的最大列数,0为不限制
            rowsMinCount: 2, //要求的最小行数
            rowsMaxCount: 0, //要求的最大行数,0为不限制
            headerOffset: 0, //列头在第几行，从0开始
            mustNames: ['工资月份', '基本工资', '应发工資', '实发工資'], //要求必须要有的列头名
            mustValues: ['工资月份', '基本工资', '应发工資', '实发工資'], //必须要有值
            keys: {
                "w_cycle": "工资月份",
                "w_date": "发放日期",
                "w_depa_text": "部门",
                "w_staff_text": "姓名",
                "w_j_jbgz": "基本工资",
                "w_j_jt": "津贴",
                "w_j_gwgz": "岗位工资",
                "w_j_jngz": "技能工资",
                "w_j_ywtc": "业务提成",
                "w_j_jxj": "绩效奖",
                "w_j_jqj": "全勤奖",
                "w_j_jbcf": "加班餐费",
                "w_j_qtbc": "其它补助",
                "w_k_sbj": "事/病假",
                "w_k_kkhk": "迟到扣",
                "w_k_qtkk": "其他扣款",
                "w_yfgz": "应发工資",
                "w_d_dksb": "代扣社保",
                "w_d_dkgjj": "代扣公积金",
                "w_d_dkgs": "代扣个税",
                "w_money": "实发工資",
                "w_zch_text": "转出行",
                "w_n_cbx": "保险公司部分",
                "w_n_cgjj": "公积金公司部分",
                "w_zch51_text": "五险一金发放行",
                "w_remark": "备注",
            }
        });
        if (json != false) {
            $(that).attr("disabled", true);
            qg.ajax.post(HOST + 'wages/importWages', json, function(data) {
                qgui.box.ok('保存成功', 3000);
                $(that).removeAttr("disabled");
            }, {
                anyError: function(error) {
                    $(that).removeAttr("disabled");
                }
            });
        }
    }
</script>
<?php include(mvc::$cfg['PATH_TPL'] . 'public/footer.php'); ?>