nizongfeng
/
zzcx_line
1
0
Fork 0
Code Issues 0 Pull Requests 0 Releases 0 Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
2 Commits
1 Branch
17 MiB
 
 
 
 
Branch: master
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
zzcx_line/coding/myself.html

410 lines
15 KiB
Raw Permalink Blame History 

  1. <!DOCTYPE html>

  2. <html>

  3. 

  4. 	<head>

  5. 		<meta charset="UTF-8">

  6. 		<title>导出信息及在线视图</title>

  7. 		<link rel="stylesheet" href="css/bootstrap.min.css" />

  8. 		<link rel="stylesheet" href="css/bootstrap-timepicker.css" />

  9. 		<link rel="stylesheet" href="css/font-awesome.min.css" />

  10. 		<link rel="stylesheet" href="css/daterangepicker.css" />

  11. 		<link rel="stylesheet" href="css/datepicker.css" />

  12. 		

  13. 		

  14. 		<!--<script type="text/javascript" src="js/jquery-2.0.3.min.js"></script>-->

  15. 		<script src="http://libs.baidu.com/jquery/2.0.0/jquery.min.js"></script>

  16. 		

  17. 		<script type="text/javascript" src="js/date-time/bootstrap-datepicker.min.js"></script>

  18. 		<script type="text/javascript" src="js/date-time/bootstrap-timepicker.min.js"></script>

  19. 		

  20. 	</head>

  21. 	<style type="text/css">

  22. 		ul li {

  23. 		    margin-top: 2px;

  24. 		    margin-left: 2px;

  25. 		    width: 30%;

  26. 		    float: left;

  27. 		    text-align: center;

  28. 		    height: 30px;

  29. 		    line-height: 30px;

  30. 		  	background: #eae1b4;

  31. 		  	cursor: pointer;

  32. 		}

  33. 	</style>

  34. 	<body>

  35. 		<!--

  36. 	作者：fuhongcheng_fhc@163.com

  37. 	时间：2016-07-14

  38. 	描述：export_customer_run_info.html导出次日出发游客和班次信息

  39. -->

  40. 		<div class="" style="overflow: hidden;width: 75%;margin-left: 15%;margin-top: 200px;">

  41. 			<!--<span style="float: left;line-height: 30px;">出发日期：</span>

  42. 			<div class="col-sm-1" style="float:left;width: 150px;padding-right: 3px;">

  43. 				<div class="input-group">

  44. 					<input id="id-date-picker-1" class="form-control date-picker" data-date-format="yyyy-mm-dd" type="text" placeholder="出发日期" style="font-size: 12px;height: 30px;">

  45. 					<span class="input-group-addon">

  46. 						<i class="icon-calendar bigger-110"></i>

  47. 					</span>

  48. 				</div>

  49. 			</div>

  50. 			<span style="display: block;">

  51. 				<span style="line-height: 30px;">线路</span><input id="line" style="width: 100px;" type="text">

  52. 			</span>-->

  53. 			<form class="form-horizontal" role="form">

  54. 					<div class="form-group">

  55. 						<label class="col-sm-1 control-label no-padding-right" style="width: auto; font-size: 12px; margin-top:2px;">时间范围:</label>

  56. 						<div class="col-sm-1" style="width: auto;">

  57. 							<select id="timelimit" style="width: 90px;">

  58. 								<option value="出发时间" selected="selected" style="font-size: 12px;">出发时间</option>

  59. 								<option value="下单时间" style="font-size: 12px;">下单时间</option>

  60. 							</select>

  61. 						</div>

  62. 						<div class="col-sm-1" style="width: 12%;padding-right: 3px;">

  63. 							<div class="input-group">

  64. 								<input id="id-date-picker-1" class="form-control date-picker" data-date-format="yyyy-mm-dd" type="text" placeholder="开始日期" style="font-size: 12px; height:30px;">

  65. 								<span class="input-group-addon">

  66. 									<i class="icon-calendar bigger-110"></i>

  67. 								</span>

  68. 							</div>

  69. 						</div>

  70. 						<label class="col-sm-1 control-label no-padding-right" style="width: auto; font-size: 12px;">-</label>

  71. 						<div class="col-sm-1" style="width: 12%;padding-right: 3px;">

  72. 							<div class="input-group">

  73. 								<input id="endtime" class="form-control date-picker" data-date-format="yyyy-mm-dd" type="text" placeholder="截至日期" style="font-size: 12px; height:30px;">

  74. 								<span class="input-group-addon">

  75. 									<i class="icon-calendar bigger-110"></i>

  76. 								</span>

  77. 							</div>

  78. 						</div>

  79. 						<label class="col-sm-1 control-label no-padding-right" style="width: auto; font-size: 12px;margin-top:2px;margin-left:20px;" >线路:</label>

  80. 						<div class="col-sm-3" style="width: 150px;">

  81. 							<input id="line" class="form-control" type="text" style="font-size: 12px; height:30px;" placeholder="线路"/>

  82. 						</div>

  83. 						<label class="col-sm-1 control-label no-padding-right" style="width: auto; font-size: 12px;margin-top:2px;" >出发地:</label>

  84. 						<div class="col-sm-1">

  85. 							<input id="start_area" class="form-control" type="text" style="font-size: 12px; height:30px;width: 92px;" placeholder="出发地"/>

  86. 						</div>

  87. 						<label class="col-sm-1 control-label no-padding-right" style="margin-left: 12px;width: auto; font-size: 12px;margin-top:2px;" >目的地:</label>

  88. 						<div class="col-sm-1">

  89. 							<input id="end_area" class="form-control" type="text" style="font-size: 12px; height:30px;width: 92px;" placeholder="目的地"/>

  90. 						</div>

  91. 					</div>

  92. 

  93. 					<div class="form-group">

  94. 						<label class="col-sm-1 no-padding-right" style="font-size: 12px;width:auto;">订单渠道:</label>

  95. 						<div class="col-sm-1" style="width: 15%;padding: 0;margin-left: 15px;">

  96. 							   <select id="ordersource" style="font-size: 12px; width: 150px;">

  97. 								<option value="-1" selected="selected" style="font-size: 12px;">请选择</option>

  98. 							</select> 

  99. 						</div>

  100. 					</div>

  101. 					<div class="form-group">

  102. 						<label class="col-sm-1 control-label no-padding-right" style="width: auto; font-size: 12px;margin-top:2px;" >更多查询:</label>

  103. 						<div class="col-sm-3">

  104. 							<input id="moresearch" class="form-control" type="text" style="font-size: 12px; height:30px;" placeholder="订单号/客人姓名/客人电话"/>

  105. 						</div>

  106. 					</div>

  107. 				</form>

  108. 			

  109. 		</div>

  110. 		<div style="margin-top: 100px;"></div>

  111. 		<ul style="list-style-type: none;">

  112. 			<li style="background-color: blue;color: white;" onclick="export_btn()">导出乘客信息</li>

  113. 			<li style="background-color: blue;color: white;" onclick="msg_btn('export')">导出短信报表</li>

  114. 			<li onclick="export_btn_view('order_list_view')">乘客信息在线视图</li>

  115. 			<li onclick="msg_btn('view')">短信报表在线视图</li>

  116. 			<li onclick="msg_btn('msg')">短信报表发送信息模板</li>

  117. 			<li onclick="export_btn_view('order_send_msg')">出行提醒短信视图</li>

  118. 			<li onclick="to_url('url1')">配置所有车型的座位平面图</li>

  119. 			<li onclick="to_url('url2')">线路票种一栏</li>

  120. 			<li onclick="to_url('url3')">各站点经纬度的查询</li>

  121. 			<li onclick="to_url('url5')">自动代码生成网页</li>

  122. 			<li onclick="to_url('url4')">车队列表</li>

  123. 			<li onclick="export_btn_view('sel_every_order_count')">查询特定渠道的每天订单数</li>

  124. 			<li style="background-color: red;color: white;" onclick="export_btn_view('jiankong1')">监控order_main、run_bus车次粒度</li>

  125. 			<li style="background-color: red;color: white;" onclick="export_btn_view('jiankong2')">监控order_main、run_bus班次粒度</li>

  126. 			<li style="background-color: red;color: white;" onclick="export_btn_view('jiankong3')">监控order_main、run_bus、run_x车次粒度(赵芳姐)</li>

  127. 			<li style="background-color: red;color: white;" onclick="export_btn_view('jiankong4')">监控runx中的座位数与座位类型是否匹配-长时间</li>

  128. 			<li style="background-color: red;color: white;" onclick="export_btn_view('jiankong5')">监控每天order_main数据条数和id自增情况</li>

  129. 			<li style="background-color: red;color: white;" onclick="export_btn_view('jiankong6')">监控run_x中的seat_status=1</li>

  130. 			

  131. 			

  132. 		</ul>

  133. 		<!--<button style="margin-left: 25%;height: 100px;background: gray;cursor: pointer;" onclick="daochu_btn()">导出乘客信息</button>

  134. 		<button style="margin-left: 25%;height: 100px;background: gray;cursor: pointer;" onclick="msg_btn()">短信报表</button>

  135. 		<button style="margin-left: 25%;height: 100px;background: gray;cursor: pointer;" onclick="export_view()">导出乘客信息在线视图</button>-->

  136. 

  137. 	</body>

  138. 	<script>

  139. 		function to_url(type){

  140. 			var url='';

  141. 			switch(type){

  142. 				case "url1":

  143. 					url='http://api.zhizhuchuxing.com/api1.0/all_car.php';

  144. 				break;

  145. 				case "url2":

  146. 					url='http://api.zhizhuchuxing.com/api1.0/all_tickets.php';

  147. 				break;

  148. 				case "url3":

  149. 					url='http://api.zhizhuchuxing.com/api1.0/all_station.php';

  150. 				break;

  151. 				case "url4":

  152. 					url='http://temp.zhizhuchuxing.com/car_team_list.html';

  153. 					break;

  154. 				case "url5":

  155. 					url="http://api.zhizhuchuxing.com/api1.0/auto_password.php";

  156. 					break;

  157. 				default:

  158. 				break;

  159. 			}

  160. 			var listURL=url;

  161. 			listURL=encodeURI(listURL);

  162. 			window.open(listURL);

  163. 		}

  164. 		function export_btn_view(type){

  165. //			var start_date=$("#id-date-picker-1").val();

  166. //			if(!start_date){

  167. //				$('bigger-110').text('请输入日期!!!');

  168. //			}else{

  169. //				$('bigger-110').text('');

  170. //			}

  171. 			var timelimit = $('#timelimit').val(); //时间类型

  172. //			var starttime = $('#starttime').val(); //开始时间

  173. 			var start_date = $('#id-date-picker-1').val(); //开始时间

  174. 			var endtime = $('#endtime').val(); //结束时间

  175. 			var ordersource=$('#ordersource').val();//订单渠道

  176. 			var paystatus =""; //支付状态

  177. 		

  178. 			/*以下三个条件暂时隐藏,''代替传入参数

  179. 			var billingstatus=document.getElementById("billingstatus").value;

  180. 			var mealbounce=document.getElementById("mealbounce").value;

  181. 			var refund=document.getElementById("refund").value;

  182. 			*/

  183. 			var billingstatus = '';

  184. 			var mealbounce = '';

  185. 			var refund = '';

  186. 			var moresearch = document.getElementById("moresearch").value;

  187. 		

  188. 			//2016-07-15新增参数

  189. 			var start_area = $('#start_area').val();

  190. 			var end_area = $('#end_area').val();

  191. 			var line = $('#line').val();

  192. 		

  193. 			var tnowtime = getDateTime(4);

  194. 			var line='';

  195. 			if(type=="order_list_view"){

  196. 				line=$('#line').val();

  197. 			}

  198. 			var url="";

  199. 			if(type!="order_list_view" && type!="order_send_msg"){

  200. 				url="http://temp.zhizhuchuxing.com/st-xm/Api/order_list_exportView.php?method="+type;

  201. 			}else{

  202. 				url="http://temp.zhizhuchuxing.com/st-xm/Api/order_list_exportView.php?method="+type+

  203. 				"&timelimit="+timelimit+

  204. 				"&start_date="+start_date+

  205. 				"&endtime=" + endtime +

  206. 				"&ordersource=" + ordersource +

  207. 				"&orderstatus=0" +

  208. 				"&paystatus=" + paystatus +

  209. 				"&billingstatus=" + billingstatus +

  210. 				"&mealbounce=" + mealbounce +

  211. 				"&refund=" + refund +

  212. 				"&moresearch=" + moresearch +

  213. 				"&start_area=" + start_area +

  214. 				"&end_area=" + end_area +

  215. 				"&line=" + line;

  216. 			}

  217. 			

  218. 			console.log(url);

  219. 			var listURL=url;

  220. 			listURL=encodeURI(listURL);

  221. //			window.location.href=listURL;

  222. 			window.open(listURL);

  223. 		}

  224. 		function msg_btn(method){

  225. 			var start_date=$("#id-date-picker-1").val();

  226. 			if(!start_date){

  227. 				alert('请输入日期!!!');return;

  228. 			}

  229. 			var url = "http://temp.zhizhuchuxing.com/st-xm/Api/car_message_chart.php?method="+method+"&start_date="+start_date;

  230. 			var listURL = url;

  231. 			// 跳转前将URL编码

  232. 			listURL = encodeURI(listURL);

  233. //			window.location.href = listURL;

  234. 			window.open(listURL);

  235. 		}

  236. 		$(document).ready(function(){

  237. 			$("#id-date-picker-1").val(getDateTime(0));

  238. 			$("#endtime").val(getDateTime(0));

  239. 			

  240. 			var url="http://temp.zhizhuchuxing.com/st-xm/Api/order_list_exportView.php?method=getOrderORG";

  241. 			console.log(url);

  242. 			$.getJSON(url,function(res_data){

  243. 				console.log(res_data);

  244. 				if(res_data['code']!="0"){alert(res_data['info']);}

  245. 					var temp = '<option value="-1" selected="selected" style="font-size: 12px;">请选择</option>';

  246. 					for (var i=0;i<res_data['order_ORG_List'].length;i++) {

  247. 						var dict=res_data['order_ORG_List'][i];

  248. 						var j = i+1;

  249. 						temp += '<option value='+dict['org_id']+' style="font-size: 12px;">'+dict['soure']+'</option>'	

  250. 					}

  251. 					$("#ordersource").html(temp);

  252. 			})

  253. 			

  254. 		});

  255. 		function export_btn() {

  256. 			var starttime=$("#id-date-picker-1").val();

  257. 			if(!starttime){

  258. 				alert('请输入日期!!!');return;

  259. 			}

  260. 			var line=$('#line').val();

  261. 			var endtime = starttime;		

  262. 			var url = "http://temp.zhizhuchuxing.com/st-xm/Api/order_list_exportView.php?method=daochu&starttime=" + starttime + "&endtime=" + endtime+"&line="+line;

  263. 			var listURL = url;

  264. 			// 跳转前将URL编码

  265. 			listURL = encodeURI(listURL);

  266. //			window.location.href = listURL;

  267. 			window.open(listURL);

  268. 		}

  269. 		function after(dateStr) {

  270. 			if (dateStr) {

  271. 				var now = ConvertDateFromString(dateStr);

  272. 				now.setDate(now.getDate() - 0 + 1);

  273. 				var year = ";" + now.getFullYear() + ";";

  274. 				var month = ";" + now.getMonth() + ";";

  275. 				var day = ";" + now.getDate() + ";";

  276. 				if (year.length < 4) {

  277. 					year = "0" + year;

  278. 				}

  279. 				if (month.length < 4) {

  280. 					month = "0" + month;

  281. 				}

  282. 				if (day.length < 4) {

  283. 					day = "0" + day;

  284. 				}

  285. 				var datestr = year + "-" + month + "-" + day;

  286. 				datestr = datestr.replace(/;/g, "");

  287. 				return datestr;

  288. 			}

  289. 		}

  290. 

  291. 		function ConvertDateFromString(dateString) {

  292. 			if (dateString) {

  293. 				var sdate = dateString.split('-');

  294. 				var date = new Date(sdate[0], sdate[1], sdate[2]);

  295. 				return date;

  296. 			}

  297. 		}

  298. 		function getDateTime(nTypeFlag) {

  299. 			var tNowTime = new Date();

  300. 			var myYear = ';' + tNowTime.getFullYear() + ';';

  301. 			var myMonth = ';' + (tNowTime.getMonth() + 1 - 0) + ';';

  302. 			var myDay = ';' + tNowTime.getDate() + ';';

  303. 			var myHour = ';' + tNowTime.getHours() + ';';

  304. 			var myMinu = ';' + tNowTime.getMinutes() + ';';

  305. 			var mySecond = ';' + tNowTime.getSeconds() + ';';

  306. 

  307. 			if (myMonth.length < 4) myMonth = '0' + myMonth;

  308. 			if (myDay.length < 4) myDay = '0' + myDay;

  309. 			if (myHour.length < 4) myHour = '0' + myHour;

  310. 			if (myMinu.length < 4) myMinu = '0' + myMinu;

  311. 			if (mySecond.length < 4) mySecond = '0' + mySecond;

  312. 

  313. 			var cNewTimeStr;

  314. 			//alert(tNowTime);

  315. 			switch (nTypeFlag + 1 - 1) {

  316. 				case 0:

  317. 					cNewTimeStr = myYear + '-' + myMonth + '-' + myDay;

  318. 					break;

  319. 				case 1:

  320. 					cNewTimeStr = myYear + myMonth + myDay;

  321. 					break;

  322. 				case 2:

  323. 					cNewTimeStr = myHour + ':' + myMinu + ':' + mySecond;

  324. 					break;

  325. 				case 3:

  326. 					cNewTimeStr = myHour + myMinu + mySecond;

  327. 					break;

  328. 				case 4:

  329. 					cNewTimeStr = myYear + myMonth + myDay + myHour + myMinu + mySecond;

  330. 					break;

  331. 				case 5:

  332. 					cNewTimeStr = myYear + '年' + myMonth + '月' + myDay + '日';

  333. 					break;

  334. 				case 6:

  335. 					cNewTimeStr = myYear;

  336. 					break;

  337. 				case 7:

  338. 					cNewTimeStr = myYear + '-' + myMonth;

  339. 					break;

  340. 				case 8: //得到上一个月的今天

  341. 					var date = getDateTime(0);

  342. 					var arr = date.split('-');

  343. 					var year = arr[0]; //获取当前日期的年份

  344. 					var month = arr[1]; //获取当前日期的月份

  345. 					var day = arr[2]; //获取当前日期的日

  346. 					var days = new Date(year, month, 0);

  347. 					days = days.getDate(); //获取当前日期中月的天数

  348. 					var year2 = year;

  349. 					var month2 = parseInt(month) - 1;

  350. 					if (month2 == 0) {

  351. 						year2 = parseInt(year2) - 1;

  352. 						month2 = 12;

  353. 					}

  354. 					var day2 = day;

  355. 					var days2 = new Date(year2, month2, 0);

  356. 					days2 = days2.getDate();

  357. 					if (day2 > days2) {

  358. 						day2 = days2;

  359. 					}

  360. 					if (month2 < 10) {

  361. 						month2 = '0' + month2;

  362. 					}

  363. 					cNewTimeStr = year2 + '-' + month2 + '-' + day2;

  364. 					break;

  365. 				case 9: //得到下一个月的今天

  366. 					var date = getDateTime(0);

  367. 					var arr = date.split('-');

  368. 					var year = arr[0]; //获取当前日期的年份

  369. 					var month = arr[1]; //获取当前日期的月份

  370. 					var day = arr[2]; //获取当前日期的日

  371. 					var days = new Date(year, month, 0);

  372. 					days = days.getDate(); //获取当前日期中的月的天数

  373. 					var year2 = year;

  374. 					var month2 = parseInt(month) + 1;

  375. 					if (month2 == 13) {

  376. 						year2 = parseInt(year2) + 1;

  377. 						month2 = 1;

  378. 					}

  379. 					var day2 = day;

  380. 					var days2 = new Date(year2, month2, 0);

  381. 					days2 = days2.getDate();

  382. 					if (day2 > days2) {

  383. 						day2 = days2;

  384. 					}

  385. 					if (month2 < 10) {

  386. 						month2 = '0' + month2;

  387. 					}

  388. 

  389. 					var t2 = year2 + '-' + month2 + '-' + day2;

  390. 					return t2;

  391. 					break;

  392. 				default:

  393. 					cNewTimeStr = myYear + '-' + myMonth + '-' + myDay + ' ' + myHour + ':' + myMinu + ':' + mySecond;

  394. 					break;

  395. 			}

  396. 

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

  398. 

  399. 			return cNewTimeStr;

  400. 

  401. 		}

  402. 	</script>

  403. <script type="text/javascript">

  404. 		$(".date-picker").datepicker({

  405. 			autoclose: true

  406. 		}).next().on("click", function() {

  407. 			$(this).prev().focus();

  408. 		});

  409. 	</script>

  410. </html>