<?php include(mvc::$cfg['PATH_TPL'] . 'public/header.php'); ?>
<?php include(mvc::$cfg['PATH_TPL'] . 'wages/common.php'); ?>
<div class="list_pager">
	<div id="list_buttons"></div>
	<table id="grid_wages"></table>
	<div id="jqGridPager"></div>
</div>
<script type="text/javascript" defer>
	var grid = null;
	var form_title = '工资表';
	$(document).ready(function() {
		createGrid();
		createTools();
	});
	/**方法************************/
	var createGrid = function() {
		var coloptions = {
			sorting: false,
			filtering: false,
			columns: false,
			freeze: false,
			grouping: true
		};
		var height = $(document).height() - 160;
		grid = new qgGrid('grid_wages', {
			url: urls.listPost,
			autowidth: true,
			rowNum: 100,
			colMenu: true,
			height: height + 'px',
			colModel: [{
					label: 'ID',
					name: 'w_id',
					key: true,
					hidden: true,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					colmenu: false
				},
				{
					label: '工资月份',
					name: 'w_cycle',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					coloptions: coloptions
				},
				{
					label: '发放日期',
					name: 'w_date',
					key: false,
					width: 120,
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					colmenu: false
				},
				{
					label: '部门',
					name: 'w_depa_text',
					key: false,
					width: 120,
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					coloptions: coloptions
				},
				{
					label: '姓名',
					name: 'w_staff_text',
					key: false,
					width: 120,
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					coloptions: coloptions,
					formatter: viewLink,
					unformat: function(text) {
						return text;
					}
				},
				{
					label: '应发工資',
					name: 'w_yfgz',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '实发工資',
					name: 'w_money',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '转出行',
					name: 'w_zch_text',
					key: false,
					width: 120,
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					coloptions: coloptions
				},
				{
					label: '基本工资',
					name: 'w_j_jbgz',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '津贴',
					name: 'w_j_jt',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '岗位工资',
					name: 'w_j_gwgz',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '技能工资',
					name: 'w_j_jngz',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '业务提成',
					name: 'w_j_ywtc',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '绩效奖',
					name: 'w_j_jxj',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '全勤奖',
					name: 'w_j_jqj',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '加班工资',
					name: 'w_j_jbf',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '加班餐费',
					name: 'w_j_jbcf',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '其它补助',
					name: 'w_j_qtbc',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '事/病假',
					name: 'w_k_sbj',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '扣款还款',
					name: 'w_k_kkhk',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '其他扣款',
					name: 'w_k_qtkk',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '迟到扣',
					name: 'w_k_chdk',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '代扣社保',
					name: 'w_d_dksb',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '代扣公积金',
					name: 'w_d_dkgjj',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '代扣个税',
					name: 'w_d_dkgs',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '保险公司部分',
					name: 'w_n_cbx',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '公积金公司部分',
					name: 'w_n_cgjj',
					key: false,
					width: 120,
					sorttype: 'integer',
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					cellattr: moneyAttr,
					formatter: viewMoney,
					unformat: unMoney,
					colmenu: false,
					summaryType: "sum",
					summaryTpl: "<span style='color:#090'><i class='fa fa-rmb'></i> {0}</span>",
					align: 'right'
				},
				{
					label: '五险一金发放行',
					name: 'w_zch51_text',
					key: false,
					width: 120,
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					colmenu: false
				},
				{
					label: '备注',
					name: 'w_remark',
					key: false,
					width: 320,
					searchoptions: {
						sopt: ['cn', 'eq', 'ne', 'le', 'lt', 'gt', 'ge', 'nc', 'nu', 'nn']
					},
					colmenu: false
				},
			],
			footerrow: true,
			groupingView: {
				groupColumnShow: [true],
				groupText: ["<b>{0}</b>"],
				groupSummary: [true],
				groupOrder: ["asc"],
				groupCollapse: false
			},
			gridComplete: function() {
				grid.grid.footerData('set', {
					"w_cycle": '合计',
					w_j_jbgz: grid.grid.getCol('w_j_jbgz', false, 'sum').toFixed(2),
					w_j_jt: grid.grid.getCol('w_j_jt', false, 'sum').toFixed(2),
					w_j_gwgz: grid.grid.getCol('w_j_gwgz', false, 'sum').toFixed(2),
					w_j_jngz: grid.grid.getCol('w_j_jngz', false, 'sum').toFixed(2),
					w_j_ywtc: grid.grid.getCol('w_j_ywtc', false, 'sum').toFixed(2),
					w_j_jxj: grid.grid.getCol('w_j_jxj', false, 'sum').toFixed(2),
					w_j_jqj: grid.grid.getCol('w_j_jqj', false, 'sum').toFixed(2),
					w_j_jbcf: grid.grid.getCol('w_j_jbcf', false, 'sum').toFixed(2),
					w_j_qtbc: grid.grid.getCol('w_j_qtbc', false, 'sum').toFixed(2),
					w_k_sbj: grid.grid.getCol('w_k_sbj', false, 'sum').toFixed(2),
					w_k_kkhk: grid.grid.getCol('w_k_kkhk', false, 'sum').toFixed(2),
					w_k_qtkk: grid.grid.getCol('w_k_qtkk', false, 'sum').toFixed(2),
					w_yfgz: grid.grid.getCol('w_yfgz', false, 'sum').toFixed(2),
					w_d_dksb: grid.grid.getCol('w_d_dksb', false, 'sum').toFixed(2),
					w_d_dkgjj: grid.grid.getCol('w_d_dkgjj', false, 'sum').toFixed(2),
					w_d_dkgs: grid.grid.getCol('w_d_dkgs', false, 'sum').toFixed(2),
					w_money: grid.grid.getCol('w_money', false, 'sum').toFixed(2),
					w_n_cbx: grid.grid.getCol('w_n_cbx', false, 'sum').toFixed(2),
					w_n_cgjj: grid.grid.getCol('w_n_cgjj', false, 'sum').toFixed(2),
				});
			},
			onSelectRow: function(key, status, event) {
				;
			},
			onEnter: function(rowid) {
				if (rowid) {
					var viewUrl = urls.view + '?key=' + rowid;
					var row = grid.selectRowData();
					qgui.form.view(row.w_staff_text, viewUrl)
				}
			}
		});
	};

	var createTools = function() {
		qgui.tableButton({
			dom: '#list_buttons',
			grid: grid,
			title: form_title,
			buttons: [{
					btn: 'refresh'
				},
				{
					btn: 'search'
				},
				/*{btn:'add',url:urls.add},*/
				/*{btn:'edit',url:function(){
					var key = grid.selectRowKey();
					if(key!=null){
						return urls.edit+'&key='+key;
					}else{
						qgui.box.timer('请先选择一条记录');
						return '';
					}
				}},*/
				{
					btn: 'delete',
					url: function() {
						qgui.box.input('请输入一个工资月份, 例 202003', function(value) {
							value = value.trim();
							if (value.length != 6) {
								qgui.box.msg('格式不正确');
							} else {
								qg.ajax.post(HOST + '/wages/delete', {
									cycle: value
								}, function(data) {
									qgui.box.msg('删除完成');
									gridReload();
								});
							}
						});
					}
				},
				/*{btn:'import'},*/
				{
					btn: 'export'
				},
				{
					btn: 'tools'
				},
				{
					btn: 'ui_showhideCol'
				},
				{
					btn: 'ui_save'
				},
				{
					btn: 'ui_reset'
				},
			],
			customButtons: [{
				btn: 'btn3',
				caption: '导出工资条',
				icon: 'fa fa-download',
				type: 'btn-white',
				click: function(e) {
					qgui.box.input('请输入一个工资月份, 例 202003', function(value) {
						value = value.trim();
						if (value.length != 6) {
							qgui.box.msg('格式不正确');
						} else {
							qg.ajaxD({
								url: HOST + 'wages/exportBar',
								data: {
									cycle: value
								}
							});
						}
					});
				}
			}, {
				btn: 'btn1',
				caption: '导入-工资',
				icon: 'fa fa fa-upload',
				type: 'btn-white',
				click: function(e) {
					qgui.page.open('导入-工资', HOST + 'wages/importWages.html');
				}
			}, {
				btn: 'btn2',
				caption: '更新自动列',
				icon: 'fa fa fa-update',
				type: 'btn-white',
				click: function(e) {
					qgui.box.input('请输入一个工资月份, 例 202003', function(value) {
						value = value.trim();
						if (value.length != 6) {
							qgui.box.msg('格式不正确');
						} else {
							qg.ajax.post(HOST + '/wages/update', {
								cycle: value
							}, function(data) {
								qgui.box.msg('更新完成');
								gridReload();
							});
						}
					});
				}
			}],
		});
	};

	var gridReload = function() { //供弹窗调用
		grid.reload();
	};
	//列格式化
	//在colModel列中加上 formatter:viewLink,unformat:function(text){return text;}
	var viewLink = function(cellValue, options, rowObject, action) {
		var key = rowObject.w_id;
		var viewUrl = urls.view + '?key=' + key;
		var title = escape(cellValue);
		//return "<a href='javascript:;' onclick=qgui.form.view('"+title+"','"+viewUrl+"')>"+cellValue+"</a>";
		title = rowObject.w_cycle + '-' + cellValue;
		return "<a href='javascript:;' onclick=qgui.page.open('" + title + "','" + viewUrl + "')>" + cellValue + "</a>";
	}
	var viewMoney = function(cellValue, options, rowObject, action) {
		if (cellValue == '0' || cellValue == '0.00' || !cellValue)
			cellValue = '';
		else
			cellValue = qg.num.money.format(cellValue);
		return cellValue;
	};
	var unMoney = function(cellValue, options, rowObject) {
		return qg.num.money.unformat(cellValue);
	};

	function moneyAttr(rowId, val, rawObject, cm, rdata) {
		if (val < 0) {
			return "style='color:red'";
		}
	}
</script>
<?php include(mvc::$cfg['PATH_TPL'] . 'public/footer.php'); ?>