<?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">
						<p>日期, 借方科目, 贷方科目, 金额, 部门, 员工, 摘要</p>
						<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: 7, //要求的最小列数
			colsMaxCount: 7, //要求的最大列数,0为不限制
			rowsMinCount: 1, //要求的最小行数
			rowsMaxCount: 0, //要求的最大行数,0为不限制
			headerOffset: 0, //列头在第几行，从0开始
			mustNames: ['日期', '借方科目', '贷方科目', '金额', '部门', '员工', '摘要'], //要求必须要有的列头名
			mustValues: ['日期', '借方科目', '贷方科目', '金额', '部门', '员工'], //必须要有值
			keys: {
				"date": "日期",
				"j_text": "借方科目",
				"d_text": "贷方科目",
				"money": "金额",
				"depa": "部门",
				"staff": "员工",
				"summary": "摘要",
			}
		});
		if (json != false) {
			$(that).attr("disabled", true);
			qg.ajax.post(HOST + 'wages/importGrant', 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'); ?>