<?php include(mvc::$cfg['PATH_TPL'].'public/header.php');?>
<?php include(mvc::$cfg['PATH_TPL'].'depa_mans/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/depa_mans.fw.png" target="_blank"><img src="<?php echo mvc::$cfg['URL_STATIC'];?>img/import/depa_mans.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:3, //要求的最小列数
		colsMaxCount:3, //要求的最大列数,0为不限制
		rowsMinCount:2, //要求的最小行数
		rowsMaxCount:0, //要求的最大行数,0为不限制
		headerOffset:0, //列头在第几行，从0开始
		mustNames:['月份','部门','人数'], //要求必须要有的列头名
		mustValues:['月份','部门','人数'], //必须要有值
		keys:{
			"dm_cycle":"月份",
			"dm_depa_text":"部门",
			"dm_qty":"人数",
		}
	});
	if(json!=false){
		$(that).attr("disabled",true);
		qg.ajax.post(HOST+'depa_mans/import',json,function(data){
			qgui.box.ok('保存成功',3000);
			$(that).removeAttr("disabled");
			console.log(data);
		},{anyError:function(error){
			$(that).removeAttr("disabled");
		}});
	}else{
		console.log('json is: ');
		console.log(json);
	}
}
</script>
<?php include(mvc::$cfg['PATH_TPL'].'public/footer.php');?>