ZZCS/coding/js/hotelOrderList.js

var list_byid;
var listStr = '';
var select_channel_str = '';
var base_url = "./st-xm/Api/ht_get_order_list.php";
var base_url2 = "./hotelOrderList.html";
var click_status_type="0";
var pagesize =10;
/*======================网络请求的Ajax的代码=======================*/

// 创建一个Ajax对象
if (window.ActiveXObject) {
	var myreq = new ActiveXObject("Microsoft.XMLHTTP");
} else {
	var myreq = new XMLHttpRequest();
}

window.onload = function() {
		list_byid = $('#list');
		//在保存HTML的时候先将display设置成显示
		//		$('#list tr').css('display', 'table-row');
		listStr = list_byid.html();
		select_channel_str = $('#orderSource2').html();
		//设置默认时间
		$('#id-date-picker-1').val(getDateTime(0));
		$('#id-date-picker-2').val(getDateTime(0));

	var s_order_status = getPar("order_status");
	if (!s_order_status) {
		s_order_status = 0;
	}
		getList(s_order_status);
}
function date_choose_picker(type){
	var start_date = $('#id-date-picker-1').val();
	var end_date = $('#id-date-picker-2').val();
	// 判断日期是否合理
	var date1 = new Date(start_date.replace(/\-/g, '/'));
	var date2 = new Date(end_date.replace(/\-/g, '/'));
	if (date1 > date2) {
		alert('开始日期不能大于结束日期!!!');
		if (type == 1) {
			$('#id-date-picker-1').val('');
		} else {
			$('#id-date-picker-2').val('');
		}
		return;
	}
}
	// 请求方法，传入URL
function get_virtual_user_list(myURL1, myURL2) {
	var tnowtime = getDateTime(4);
	if (myURL1.indexOf('?') >= 0) {
		myURL1 += '&tt=' + tnowtime;
	} else {
		myURL1 += '?tt=' + tnowtime;
	}
	$.getJSON(myURL1, function(httpData) {
		// newstr 就是接收到的数据
		var hotelOrderList = httpData['hotelOrderList'];
		var hotelStr = '';
		for (var i = 0; i < hotelOrderList.length; i++) {
			var dict = hotelOrderList[i];
			var tempHTML = listStr;
			tempHTML = tempHTML.replace('none', 'table-row');
			tempHTML = tempHTML.replace('[order_id1]', dict['order_id']);
			tempHTML = tempHTML.replace('[order_id2]', dict['prod_id']);
			tempHTML = tempHTML.replace('[订单编号]', dict['order_id']);
			tempHTML = tempHTML.replace('[下单时间]', dict['order_date_time']);
			tempHTML = tempHTML.replace('[订单渠道]', dict['order_form']);
			tempHTML = tempHTML.replace('[预订产品酒店房型]', dict['product_name']);
			tempHTML = tempHTML.replace('[预订产品酒店详情]', dict['disp_dec']);
			tempHTML = tempHTML.replace('[供应商]', dict['supplier']);
			tempHTML = tempHTML.replace('[客人信息姓名]', dict['customer_name']);
			tempHTML = tempHTML.replace('[客人信息电话]', dict['customer_mobile']);
			tempHTML = tempHTML.replace('[订单金额]', dict['order_balance']);
			tempHTML = tempHTML.replace('[采购成本]', dict['base_balance']);
			tempHTML = tempHTML.replace('[状态]', dict['order_status_str']);
			hotelStr += tempHTML;
		}
		list_byid.html(hotelStr);
		if(click_status_type=="0"){
			$('#order_all').html('');
			$('#order_status1').html('');
			$('#order_status2').html('');
			$('#order_status3').html('');
			$('#order_status4').html('');
			$('#order_status5').html('');
			$('#order_status6').html('');
			$('#order_status7').html('');
			$('#order_status8').html('');
		}
		
		var orderStatus = httpData['orderStatus'][0];
//		//145：待支付 	218：已安排		147：已完成 		148：已取消
//		//198：待确定		199：待通知 		200：待安排 		201：退改中
//		//		198	  145   199   200    218    147   148    201
//		//全部-待确认-待支付-待通知-待安排-已安排-已完成-已取消-退改中
//		$('#order_all').html(orderStatus['status_all']);
		if(click_status_type=="0"){
			$('#order_all').html(orderStatus['status_all']);
		}
		$('#order_status1').html(orderStatus['198']);
		$('#order_status2').html(orderStatus['145']);
		$('#order_status3').html(orderStatus['199']);
		$('#order_status4').html(orderStatus['200']);
		$('#order_status5').html(orderStatus['218']);
		$('#order_status6').html(orderStatus['147']);
		$('#order_status7').html(orderStatus['148']);
		$('#order_status8').html(orderStatus['201']);
		
		
		var currpage = getPar("currpage");
		if (!currpage) {
			currpage = 1;
		}
		if( !httpData['total'] ) {
			var sum = 0;
		} else {
			var sum = parseInt(httpData['total']);
		}
		var pageSize = pagesize;
		var tag = "page";

		console.log('getPager('+sum + ',' + currpage  + ',' + pageSize + ')');
		getPager(myURL2, sum, currpage, pageSize, tag, 'currpage');


	});
}
// 让复选框全选
function select_checked() {
	var cur_check = $('.ace')[0];
	var checkList = $('input');
	for (var i = 0; i < checkList.length; i++) {
		if (checkList[i].type == 'checkbox') {
			checkList[i].checked = cur_check.checked;
		}
	}
}
//选择渠道类型
function select_type(value) {
	click_status_type="0";
	var myURL = base_url + '?method=getChannelList&channel_type=' + value;
	var tnowtime = getDateTime(4);
	if (myURL.indexOf('?') >= 0) {
		myURL += '&tt=' + tnowtime;
	} else {
		myURL += '?tt=' + tnowtime;
	}
	$.getJSON(myURL, function(channel_data) {
		if (channel_data['code'] != "0") {
			alert(channel_data['info']);
			return;
		}
		var arr_list = channel_data['channelList'];
		var listStr = '<option selected="selected" value="[value]" style="font-size: 12px;">请选择</option>';
		var arr_org_ids = new Array();
		for (var i = 0; i < arr_list.length; i++) {
			var tempDict = arr_list[i];
			var tempHTML = select_channel_str;
			tempHTML = tempHTML.replace('[value]', tempDict['org_id']);
			arr_org_ids[i] = tempDict['org_id'];
			tempHTML = tempHTML.replace('请选择', tempDict['org_name']);
			listStr += tempHTML;
		}
		$('#orderSource2').html(listStr);

		//开始
		//日期 时间
		var date1 = $('#id-date-picker-1').val();
		var time1 = $('#timepicker1').val();
		var start_date = date1 + ' ' + time1;
		//结束
		//日期时间
		var date2 = $('#id-date-picker-2').val();
		var time2 = $('#timepicker2').val();
		var end_date = date2 + ' ' + time2;
		//判断非空
		if (!date1 && date2 && time1 && time2) {
			alert('日期不能为空!!!');
			return;
		}
		var org_type_id = value;
		var org_id = $("#orderSource2 option:selected").attr('value');
		if (org_id == '[value]' || org_id==0) {
			org_id = '-1';
		}
		if(org_type_id=="0" || org_type_id==0){
			org_id=="-1";
		}
		var myURL1 = base_url + '?method=getOrderList&user_id=1&currpage=1&page_size='+pagesize+'&order_status=0&start_date=' + start_date + '&end_date=' + end_date + '&key_word=&org_id=' + org_id + '&org_type_id=' + org_type_id;
		var myURL2 = base_url2 + '?user_id=1&page_size='+pagesize+'&order_status=0&start_date=' + start_date + '&end_date=' + end_date + '&key_word=&org_id=' + org_id + '&org_type_id=' + org_type_id;

		get_virtual_user_list(myURL1,myURL2);
	})

}
//选择组织机构
function select_org(org_id) {
	click_status_type="0";	
	if (org_id == "[value]" || org_id == 0 || org_id == "0") {
		org_id = "-1";
	}
	//日期 时间
	var date1 = $('#id-date-picker-1').val();
	var time1 = $('#timepicker1').val();
	var start_date = date1 + ' ' + time1;
	//结束
	//日期时间
	var date2 = $('#id-date-picker-2').val();
	var time2 = $('#timepicker2').val();
	var end_date = date2 + ' ' + time2;
	//判断非空
	if (!date1 && date2 && time1 && time2) {
		alert('日期不能为空!!!');
		return;
	}
	// 订单号 联系人姓名  联系人电话
	var condition = $('#select_condition').val();
	if (condition.length <= 0) {
		condition = ''
	};
	var org_type_id = $('#orderSource1 option:selected').attr('value');
	var org_id = $("#orderSource2 option:selected").attr('value');
	if (org_id == '[value]') {
		org_id = '-1';
	}
	var myURL1 = base_url + '?method=getOrderList&user_id=1&currpage=1&page_size='+pagesize+'&order_status=0&start_date=' + start_date + '&end_date=' + end_date + '&key_word=' + condition + '&org_id=' + org_id + '&org_type_id=' + org_type_id;
	var myURL2 = base_url2 + '?user_id=1&page_size='+pagesize+'&order_status=0&start_date=' + start_date + '&end_date=' + end_date + '&key_word=' + condition + '&org_id=' + org_id + '&org_type_id=' + org_type_id;
	get_virtual_user_list(myURL1,myURL2);
}
//订单状态
function getList(status_val) {
	//145：待支付 146：已出票 147：已完成 148：已取消 
	//198：待确定 199：待通知 200：待安排 201：退改中
	//待确认 待支付 待通知 待安排 已安排 已完成 已取消 退改中
	if(status_val!="0"){
		click_status_type="-1";
	}else{
		click_status_type="0";
	}
	//开始
	//日期 时间
	var date1 = $('#id-date-picker-1').val();
	var time1 = $('#timepicker1').val();
	var start_date = date1 + ' ' + time1;
	//结束
	//日期时间
	var date2 = $('#id-date-picker-2').val();
	var time2 = $('#timepicker2').val();
	var end_date = date2 + ' ' + time2;
	//判断非空
	if (!date1 && date2 && time1 && time2) {
		alert('日期不能为空!!!');
		return;
	}
	// 订单号 联系人姓名  联系人电话
	var condition = $('#select_condition').val();
	var org_type_id = $('#orderSource1').val();
	var org_id = $('#orderSource2').val();
	if (org_id == '[value]') {
		org_id = '-1';
	}
	if (org_type_id == '0') {
		org_type_id = '-1';
	}
	var default_currpage = getPar("currpage");
	if (!default_currpage) {
		default_currpage = 1
	}
	var currpage = arguments[1]?arguments[1]:default_currpage;
	var myURL1 = base_url + '?method=getOrderList&user_id=1&currpage=' + currpage + '&page_size='+pagesize+'&order_status=' + status_val + '&start_date=' + start_date + '&end_date=' + end_date + '&key_word=' + condition + '&org_id=' + org_id + '&org_type_id=' + org_type_id;
	console.log('order_list_url+++==='+myURL1);

	var myURL2 = base_url2 + '?user_id=1&page_size='+pagesize+'&order_status=' + status_val + '&start_date=' + start_date + '&end_date=' + end_date + '&key_word=' + condition + '&org_id=' + org_id + '&org_type_id=' + org_type_id;

	get_virtual_user_list(myURL1,myURL2)
}

//点击查询按钮
$(document).ready(function() {
	$('#select_btn').click(function() {
		//开始
		//日期 时间
		var date1 = $('#id-date-picker-1').val();
		var time1 = $('#timepicker1').val();
		var start_date = date1 + ' ' + time1;
		//结束
		//日期时间
		var date2 = $('#id-date-picker-2').val();
		var time2 = $('#timepicker2').val();
		var end_date = date2 + ' ' + time2;
		//判断非空
		if (!date1 && date2 && time1 && time2) {
			alert('日期不能为空!!!');
			return;
		}
		// 订单号 联系人姓名  联系人电话
		var condition = $('#select_condition').val();
		if (condition.length <= 0) {
			condition = ''
		};
		var org_type_id = $('#orderSource1 option:selected').attr('value');
		var org_id = $("#orderSource2 option:selected").attr('value');
		if (org_id == '[value]') {
			org_id = '-1';
		}
		if (org_type_id == '[value]') {
			org_type_id = '-1';
		}
		var myURL1 = base_url + '?method=getOrderList&user_id=1&currpage=1&page_size='+pagesize+'&order_status=0&start_date=' + start_date + '&end_date=' + end_date + '&key_word=' + condition + '&org_id=' + org_id + '&org_type_id=' + org_type_id;
		var myURL2 = base_url2 + '?user_id=1&page_size='+pagesize+'&order_status=0&start_date=' + start_date + '&end_date=' + end_date + '&key_word=' + condition + '&org_id=' + org_id + '&org_type_id=' + org_type_id;
		get_virtual_user_list(myURL1,myURL2)
	});
});
//点击导出订单信息
$(document).ready(function() {
		$('#explorer_excel').click(function() {
			method1('hotel_order_list');
		})
	})
	//导出到excel兼容谷歌等
var idTmr;

function getExplorer() {
	var explorer = window.navigator.userAgent;
	//ie 
	if (explorer.indexOf("MSIE") >= 0) {
		return 'ie';
	}
	//firefox 
	else if (explorer.indexOf("Firefox") >= 0) {
		return 'Firefox';
	}
	//Chrome
	else if (explorer.indexOf("Chrome") >= 0) {
		return 'Chrome';
	}
	//Opera
	else if (explorer.indexOf("Opera") >= 0) {
		return 'Opera';
	}
	//Safari
	else if (explorer.indexOf("Safari") >= 0) {
		return 'Safari';
	}
}

function method1(tableid) { //整个表格拷贝到EXCEL中
	if (getExplorer() == 'ie') {
		var curTbl = document.getElementById(tableid);
		var oXL = new ActiveXObject("Excel.Application");

		//创建AX对象excel 
		var oWB = oXL.Workbooks.Add();
		//获取workbook对象 
		var xlsheet = oWB.Worksheets(1);
		//激活当前sheet 
		var sel = document.body.createTextRange();
		sel.moveToElementText(curTbl);
		//把表格中的内容移到TextRange中 
		sel.select();
		//全选TextRange中内容 
		sel.execCommand("Copy");
		//复制TextRange中内容  
		xlsheet.Paste();
		//粘贴到活动的EXCEL中       
		oXL.Visible = true;
		//设置excel可见属性

		try {
			var fname = oXL.Application.GetSaveAsFilename("Excel.xls", "Excel Spreadsheets (*.xls), *.xls");
		} catch (e) {
			print("Nested catch caught " + e);
		} finally {
			oWB.SaveAs(fname);

			oWB.Close(savechanges = false);
			//xls.visible = false;
			oXL.Quit();
			oXL = null;
			//结束excel进程，退出完成
			//window.setInterval("Cleanup();",1);
			idTmr = window.setInterval("Cleanup();", 1);

		}

	} else {
		tableToExcel(tableid)
	}
}

function Cleanup() {
	window.clearInterval(idTmr);
	CollectGarbage();
}
var tableToExcel = (function() {
	var uri = 'data:application/vnd.ms-excel;base64,',
		template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>',
		base64 = function(s) {
			return window.btoa(unescape(encodeURIComponent(s)))
		},
		format = function(s, c) {
			return s.replace(/{(\w+)}/g,
				function(m, p) {
					return c[p];
				})
		}
	return function(table, name) {
		if (!table.nodeType) table = document.getElementById(table)
		var ctx = {
			worksheet: name || 'Worksheet',
			table: table.innerHTML
		}
		window.location.href = uri + base64(format(template, ctx))
	}
})()

function getDateTime(nTypeFlag) {
	var tNowTime = new Date();
	var myYear = ';' + tNowTime.getFullYear() + ';';
	var myMonth = ';' + (tNowTime.getMonth() + 1 - 0) + ';';
	var myDay = ';' + tNowTime.getDate() + ';';
	var myHour = ';' + tNowTime.getHours() + ';';
	var myMinu = ';' + tNowTime.getMinutes() + ';';
	var mySecond = ';' + tNowTime.getSeconds() + ';';

	if (myMonth.length < 4) myMonth = '0' + myMonth;
	if (myDay.length < 4) myDay = '0' + myDay;
	if (myHour.length < 4) myHour = '0' + myHour;
	if (myMinu.length < 4) myMinu = '0' + myMinu;
	if (mySecond.length < 4) mySecond = '0' + mySecond;

	var cNewTimeStr;
	//alert(tNowTime);
	switch (nTypeFlag + 1 - 1) {
		case 0:
			cNewTimeStr = myYear + '-' + myMonth + '-' + myDay;
			break;
		case 1:
			cNewTimeStr = myYear + myMonth + myDay;
			break;
		case 2:
			cNewTimeStr = myHour + ':' + myMinu + ':' + mySecond;
			break;
		case 3:
			cNewTimeStr = myHour + myMinu + mySecond;
			break;
		case 4:
			cNewTimeStr = myYear + myMonth + myDay + myHour + myMinu + mySecond;
			break;
		case 5:
			cNewTimeStr = myYear + '年' + myMonth + '月' + myDay + '日';
			break;
		case 6:
			cNewTimeStr = myYear;
			break;
		case 7:
			cNewTimeStr = myYear + '-' + myMonth;
			break;
		default:
		case 8:
			//		获取上个月日期函数
			//			 t="2015-1-1";//可以当参数输入
			var t = getDateTime(0);
			var tarr = t.split('-');
			var year = tarr[0]; //获取当前日期的年
			var month = tarr[1]; //获取当前日期的月
			var day = tarr[2]; //获取当前日期的日
			var days = new Date(year, month, 0);
			days = days.getDate(); //获取当前日期中的月的天数
			var year2 = year;
			var month2 = parseInt(month) - 1;
			if (month2 == 0) {
				year2 = parseInt(year2) - 1;
				month2 = 12;
			}
			var day2 = day;
			var days2 = new Date(year2, month2, 0);
			days2 = days2.getDate();
			if (day2 > days2) {
				day2 = days2;
			}
			if (month2 < 10) {
				month2 = '0' + month2;
			}
			var t2 = year2 + '-' + month2 + '-' + day2;
			return t2;
			break;
			cNewTimeStr = myYear + '-' + myMonth + '-' + myDay + ' ' + myHour + ':' + myMinu + ':' + mySecond;
			break;
	}

	cNewTimeStr = cNewTimeStr.replace(/;/g, "");

	return cNewTimeStr;

}

function getPar(par){
	//获取当前URL
	var local_url = document.location.href;
	local_url = decodeURI(local_url);
	//获取要取得的get参数位置
	var get = local_url.indexOf(par +"=");
	if(get == -1){
		return false;
	}
	//截取字符串
	var get_par = local_url.slice(par.length + get + 1);
	//判断截取后的字符串是否还有其他get参数
	var nextPar = get_par.indexOf("&");
	if(nextPar != -1){
		get_par = get_par.slice(0, nextPar);
	}
	return get_par;
}