LeeWeiCheng
/
altob.st123
1
0
Fork 0
Código Incidencias 0 Pull Requests 0 Lanzamientos 0 Wiki Actividad
VM暫存
No puede seleccionar más de 25 temas Los temas deben comenzar con una letra o número, pueden incluir guiones ('-') y pueden tener hasta 35 caracteres de largo.
268 Commits
5 Ramas
790KB
Rama: master
Ramas Etiquetas
${ item.name }
Crear rama ${ searchTerm }
desde 'master'
${ noResults }
altob.st123/views/admins_station/check_point_report.php

327 líneas
16KB
Original Enlace permanente Blame Histórico 

  1. 

  2. 			<?php /* ----- 關帳查詢 ----- */?>

  3.             <div data-items="check_point_report" class="row" style="display:none;">

  4.                 <div class="col-lg-12">

  5.                     <div class="panel panel-default">

  6. 						<div class="panel-heading">

  7.                             <form id="check_point_form" role="form">

  8. 								<label class="input-inline" for="check_point_search_station_no_modify">關帳查詢</label>&nbsp;&nbsp;

  9. 								<select id="check_point_search_station_no_modify" name="check_point_search_station_no_modify"></select>

  10. 								

  11. 								&nbsp;<span class="input-inline" >，</span>&nbsp;

  12. 								

  13. 								<label class="input-inline" for="check_point_search_time_from">開始</label>&nbsp;&nbsp;

  14. 								<input type="text" class="date" id="check_point_search_time_from" name="check_point_search_time_from">

  15. 								

  16. 								&nbsp;<span class="input-inline" > ~ </span>&nbsp;

  17. 								

  18. 								<label class="input-inline" for="check_point_search_time_to">結束</label>&nbsp;&nbsp;

  19. 								<input type="text" class="date" id="check_point_search_time_to" name="check_point_search_time_to">

  20. 								

  21. 								&nbsp;&nbsp;

  22. 								

  23. 								<label class="input-inline"><input type="submit" value="查詢" /></label> 

  24.                             </form>

  25.                         </div>

  26.                         <!-- /.panel-heading -->

  27.                         <div class="panel-body">

  28.                             <div class="dataTable_wrapper">

  29.                                 <table class="table table-striped table-bordered table-hover">

  30.                                     <thead>

  31.                                         <tr>

  32. 											<th style="text-align:center;">編號</th>

  33. 											<th style="text-align:center;">上次關帳時間</th>

  34.                                             <th style="text-align:center;">本次關帳時間</th>

  35. 											<th style="text-align:center;">上次最後交易代號</th>

  36. 											<th style="text-align:center;">本次最後交易代號</th>

  37. 											<th style="text-align:center;">總金額（不含押金）</th>

  38. 											<th style="text-align:center;">總押金</th>

  39. 											<th style="text-align:center;">操作種類</th>

  40. 											<th style="text-align:center;">功能</th>

  41. 											<th style="text-align:center;">建立時間</th>

  42. 											<th style="text-align:center;">備註</th>

  43.                                         </tr>

  44.                                     </thead>

  45.                                     <tbody id="check_point_list" style="font-size:18px;"></tbody>

  46.                                 </table>

  47.                             </div><?php /* ----- end of dataTable_wrapper ----- */?>  

  48.                         </div><?php /* ----- end of panel-body ----- */?>

  49.                     </div><?php /* ----- end of panel panel-default ----- */?>

  50.                 </div><?php /* ----- end of col-lg-12 ----- */?>

  51. 				

  52. 				

  53.                 <div id="check_point_list_detail_box" class="col-lg-12" style="display:none;">

  54.                     <div class="panel panel-default">

  55.                         <div class="panel-heading">

  56.                             關帳明細（<span id='check_point_list_detail_time_str_1'></span>&nbsp;開始&nbsp;~&nbsp;至&nbsp;<span id='check_point_list_detail_time_str_2'></span>&nbsp;關帳，期間所有交易）

  57.                         </div>

  58.                         <!-- /.panel-heading -->

  59.                         <div class="panel-body">

  60.                             <div class="dataTable_wrapper">

  61.                                 <table class="table table-striped table-bordered table-hover">

  62.                                     <thead>

  63.                                         <tr>

  64. 											<th style="text-align:left;">代號</th>

  65. 											<th style="text-align:center;">入帳日</th>

  66. 											<th style="text-align:left;">入帳車號</th>

  67. 											<th style="text-align:left;">目前車號</th>

  68. 											<th style="text-align:center;">會員開始日</th>

  69. 											<th style="text-align:center;">上期繳期</th>

  70.                                             <th style="text-align:center;">上期結束日</th>

  71.                                             <th style="text-align:center;">上期租金</th>

  72. 											<th style="text-align:center;">本期繳期</th>

  73. 											<th style="text-align:center;">本期開始日</th>

  74.                                             <th style="text-align:center;">本期結束日</th>

  75.                                             <th style="text-align:center;">本期租金</th>

  76. 											<th style="text-align:center;">押金</th>

  77. 											<th style="text-align:center;">審核狀態</th>

  78. 											<th style="text-align:center;">有效期限</th>

  79. 											<th style="text-align:center;">備註</th>

  80.                                         </tr>

  81.                                     </thead>

  82.                                     <tbody id="check_point_list_detail" style="font-size:18px;"></tbody>

  83.                                 </table>

  84.                             </div><?php /* ----- end of dataTable_wrapper ----- */?>  

  85.                         </div><?php /* ----- end of panel-body ----- */?>

  86.                     </div><?php /* ----- end of panel panel-default ----- */?>

  87.                 </div><?php /* ----- end of col-lg-12 ----- */?>

  88. 				

  89. 				

  90.             </div>

  91.             <?php /* ----- 關帳查詢(結束) ----- */?>

  92. 			

  93. <script>  

  94. 

  95. 		// 設定場站資訊 

  96. 		for(station_no in st)

  97. 		{

  98. 			$(new Option(st[station_no],station_no)).appendTo('#check_point_search_station_no_modify');		// 場站

  99. 		}

  100. 

  101. 		var initMinDate = moment("00:00", "HH:mm").subtract(10, 'days');

  102. 		var initMaxDate = moment("23:59", "HH:mm");

  103. 		var searchTimeFromPicker = $( "#check_point_search_time_from" );

  104. 		var searchTimeToPicker = $( "#check_point_search_time_to" );

  105. 		

  106. 		// 日期

  107. 		/* DatePicker 設定start */

  108. 		searchTimeFromPicker.datetimepicker({

  109. 			dateFormat: 'yy-mm-dd',

  110. 			maxDate: '0',

  111. 			changeMonth: true,

  112. 			numberOfMonths: 1,

  113. 			timeFormat: "HH:mm",

  114. 			addSliderAccess: true,

  115. 			sliderAccessArgs: { touchonly: false },

  116. 			onClose: function( selectedDate ) {

  117. 				searchTimeToPicker.datetimepicker( "option", "minDate", selectedDate );

  118. 				

  119. 				console.log("search_time_from: " + selectedDate);

  120. 			}

  121. 		});

  122. 		searchTimeFromPicker.datetimepicker('setDate', initMinDate.toDate());

  123. 		searchTimeToPicker.datetimepicker({

  124. 			dateFormat: 'yy-mm-dd',

  125. 			maxDate: '0',

  126. 			changeMonth: true,

  127. 			numberOfMonths: 1,

  128. 			timeFormat: "HH:mm",

  129. 			addSliderAccess: true,

  130. 			sliderAccessArgs: { touchonly: false },

  131. 			onClose: function( selectedDate ) {

  132. 				searchTimeFromPicker.datetimepicker( "option", "maxDate", selectedDate );

  133. 				

  134. 				console.log("search_time_to: " + selectedDate);

  135. 			}

  136. 		});

  137. 		searchTimeToPicker.datetimepicker('setDate', initMaxDate.toDate());

  138. 		/* DatePicker 設定end */

  139. 

  140. $("#check_point_form").submit(function(event)

  141. {                   

  142.    	event.preventDefault();        

  143. 	

  144. 	var station_no = $("#check_point_search_station_no_modify").val();

  145. 	var check_point_time_from = $( "#check_point_search_time_from" ).val();

  146. 	var check_point_time_to = $( "#check_point_search_time_to" ).val();

  147. 	

  148. 	$("#check_point_list").html("");

  149. 	$("#check_point_list_detail").html("");

  150. 	$("#check_point_list_detail_box").hide();

  151. 	

  152. 	$.ajax

  153.     ({

  154.         url:APP_URL+"check_point_query", 

  155.         dataType:"json",

  156.         type:"post",

  157.         data:

  158.         {

  159.         	"station_no": station_no,

  160.         	"check_point_time_from": check_point_time_from,

  161. 			"check_point_time_to": check_point_time_to

  162.         },

  163. 		error:function(xhr, ajaxOptions, thrownError)

  164. 				{

  165. 					var error_msg = xhr.responseText ? xhr.responseText : "連線失敗, 請稍候再試";

  166. 					alertify_msg(error_msg);

  167. 					console.log("error:"+error_msg+"|"+ajaxOptions+"|"+thrownError);  

  168. 				},

  169.         success:function(jdata)

  170. 				{       

  171. 					var check_point_list = ["<tr>"];  

  172. 					for(idx in jdata)

  173. 					{                        

  174. 						check_no = jdata[idx]['check_no'];   

  175. 						check_point_list = check_point_list.concat(["<td style='text-align:center;'>", check_no, "</td>"]);

  176. 						check_point_list = check_point_list.concat(["<td id='check_point_data_", check_no, 

  177. 							"' data-station_no='", jdata[idx]['station_no'], 

  178. 							"' data-check_no='", jdata[idx]['check_no'], 

  179. 							"' data-check_time='", jdata[idx]['check_time'], 

  180. 							"' data-check_time_no='", jdata[idx]['check_time_no'], 

  181. 							"' data-check_time_last='", jdata[idx]['check_time_last'], 

  182. 							"' data-check_time_last_no='", jdata[idx]['check_time_last_no'], 

  183. 							"' data-check_type='", jdata[idx]['check_type'], 

  184. 							"' data-check_amt='", jdata[idx]['check_amt'], 

  185. 							"' data-check_deposit='", jdata[idx]['check_deposit'],

  186. 							"' data-remarks='", jdata[idx]['remarks'], 

  187. 							"' style='text-align:center;'>", jdata[idx]['check_time_last'], "</td>"]);

  188. 						

  189. 						check_point_list = check_point_list.concat(["<td style='text-align:center;'>", jdata[idx]['check_time'], "</td>"]);	

  190. 						check_point_list = check_point_list.concat(["<td style='text-align:center;'>", jdata[idx]['check_time_last_no'], "</td>"]);	

  191. 						check_point_list = check_point_list.concat(["<td style='text-align:center;'>", jdata[idx]['check_time_no'], "</td>"]);	

  192. 						check_point_list = check_point_list.concat(["<td style='text-align:center;'>", jdata[idx]['check_amt'], "</td>"]);							

  193. 						check_point_list = check_point_list.concat(["<td style='text-align:center;'>", jdata[idx]['check_deposit'], "</td>"]);	

  194. 						

  195. 						if(jdata[idx]['check_type'] == 1)

  196. 						{

  197. 							check_point_list = check_point_list.concat(["<td style='text-align:center;'>手動關帳</td>"]);		

  198. 						}

  199. 						else

  200. 						{

  201. 							check_point_list = check_point_list.concat(["<td style='text-align:center;'>未知</td>"]);		

  202. 						}

  203. 						

  204. 						check_point_list = check_point_list.concat(["<td style='color:red;text-align:center;'><button class='btn btn-default' style='color:blue;' onclick='check_point_detail(",  check_no + ");'>明細</button></td>"]);

  205. 						

  206. 						check_point_list = check_point_list.concat(["<td style='text-align:center;'>", jdata[idx]['create_time'], "</td>"]);	

  207. 						check_point_list = check_point_list.concat(["<td style='text-align:left;'>", jdata[idx]['remarks'], "</td>"]);

  208. 						check_point_list = check_point_list.concat(["</tr>"]);	

  209. 					}

  210. 					$("#check_point_list").append(check_point_list.join(''));  

  211. 				}                                                                     

  212.     }); 

  213. });

  214. 

  215. 

  216. // 關帳查詢（明細）

  217. function check_point_detail(check_no)

  218. {

  219. 	$("#check_point_list_detail").html("");	// -- 清除原內容 --

  220. 	

  221. 	var station_no = $("#check_point_data_"+check_no).data("station_no");

  222. 	var check_time = $("#check_point_data_"+check_no).data("check_time");

  223. 	var check_time_no = $("#check_point_data_"+check_no).data("check_time_no");

  224. 	var check_time_last = $("#check_point_data_"+check_no).data("check_time_last");

  225. 	var check_time_last_no = $("#check_point_data_"+check_no).data("check_time_last_no");

  226. 	

  227. 	$.ajax

  228.         	({

  229.         		url: "<?=APP_URL?>check_point_detail_query",

  230.             	type: "post", 

  231.             	dataType:"json",

  232.             	data: {

  233. 					"station_no": station_no,

  234. 					"check_time_no": check_time_no,

  235. 					"check_time_last_no": check_time_last_no

  236. 				},

  237. 				error:function(xhr, ajaxOptions, thrownError)

  238. 				{

  239. 					var error_msg = xhr.responseText ? xhr.responseText : "連線失敗, 請稍候再試";

  240. 					alertify_msg(error_msg);

  241. 					console.log("error:"+error_msg+"|"+ajaxOptions+"|"+thrownError);  

  242. 					

  243. 					$("#check_point_list_detail_box").hide();

  244. 				},

  245.             	success:function(jdata)

  246. 				{   

  247. 					$("#check_point_list_detail_time_str_1").text(check_time_last);				

  248. 					$("#check_point_list_detail_time_str_2").text(check_time);

  249. 					$("#check_point_list_detail_box").show();

  250. 				

  251. 					var member_list = ["<tr>"];  

  252. 					for(idx in jdata)

  253. 					{                                         

  254. 						tx_no = jdata[idx]['tx_no'];   

  255. 						member_list = member_list.concat(["<td style='text-align:center;'>", tx_no, "</td>"]);

  256. 						member_list = member_list.concat(["<td id='acc_date_", tx_no, "' style='text-align:center;'>", jdata[idx]['acc_date'], "</td>"]);

  257. 						member_list = member_list.concat(["<td id='check_point_list_detail_data_", tx_no, 

  258. 							"' data-station_no='", jdata[idx]['station_no'], 

  259. 							"' data-member_no='", jdata[idx]['member_no'], 

  260. 							"' data-tx_no='", jdata[idx]['tx_no'], 

  261. 							"' data-member_company_no='", jdata[idx]['member_company_no'], 

  262. 							"' data-company_no='", jdata[idx]['company_no'], 

  263. 							"' data-amt='", jdata[idx]['amt'], 

  264. 							"' data-amt1='", jdata[idx]['amt1'], 

  265. 							"' data-deposit='", jdata[idx]['deposit'], 

  266. 							"' data-start_date_last='", jdata[idx]['start_date_last'], 

  267. 							"' data-end_date='", jdata[idx]['end_date'], 

  268. 							"' data-lpr='", jdata[idx]['lpr'], 

  269. 							"' data-fee_period='", jdata[idx]['fee_period'], 

  270. 							"' style='text-align:left;'>", jdata[idx]['lpr'], "</td>"]);

  271. 						

  272. 						if(jdata[idx]['current_lpr'])

  273. 						{

  274. 							member_list = member_list.concat(["<td id='current_lpr_", tx_no, "' style='text-align:center;'>", jdata[idx]['current_lpr'], "</td>"]);		

  275. 						}

  276. 						else

  277. 						{

  278. 							member_list = member_list.concat(["<td id='current_lpr_", tx_no, "' style='color:black;text-align:center;'>無</td>"]);		

  279. 						}

  280. 						

  281. 						member_list = member_list.concat(["<td id='sdate_last_", tx_no, "' style='text-align:center;'>", jdata[idx]['start_date_last'], "</td>"]);	

  282. 						member_list = member_list.concat(["<td id='fee_period_last_", tx_no, "' style='text-align:center;'>", period_name[jdata[idx]['fee_period_last']], "</td>"]);	

  283. 						member_list = member_list.concat(["<td id='edate_last_", tx_no, "' style='text-align:center;'>", jdata[idx]['end_date_last'], "</td>"]);	

  284. 						member_list = member_list.concat(["<td id='amt_last_", tx_no, "' style='text-align:center;'>", jdata[idx]['amt_last'], "</td>"]);	

  285. 						member_list = member_list.concat(["<td id='fee_period_", tx_no, "' style='text-align:center;'>", period_name[jdata[idx]['fee_period']], "</td>"]);	

  286. 						member_list = member_list.concat(["<td id='sdate_", tx_no, "' style='text-align:center;'>", jdata[idx]['start_date'], "</td>"]);	

  287. 						member_list = member_list.concat(["<td id='edate_", tx_no, "' style='text-align:center;'>", jdata[idx]['end_date'], "</td>"]);	

  288. 						member_list = member_list.concat(["<td id='amt_", tx_no, "' style='text-align:center;'>", jdata[idx]['amt'], "</td>"]);		

  289. 						member_list = member_list.concat(["<td id='deposit_", tx_no, "' style='text-align:center;'>", jdata[idx]['deposit'], "</td>"]);		

  290. 

  291. 						if(jdata[idx]['tx_state'] == 4)

  292. 						{

  293. 							member_list = member_list.concat(["<td style='color:black;text-align:center;'>已退租</td>"]);

  294. 						}						

  295. 						else if(jdata[idx]['tx_state'] == 44)

  296. 						{

  297. 							member_list = member_list.concat(["<td style='color:black;text-align:center;'>交易取消</td>"]);

  298. 						}

  299. 						else if(jdata[idx]['verify_state'] == 0)

  300. 						{

  301. 							member_list = member_list.concat(["<td style='color:red;text-align:center;'><button class='btn btn-default' style='color:red;' onclick='member_tx_check(",  tx_no + ");'>待審核</button></td>"]);

  302. 						}

  303. 						else if(jdata[idx]['verify_state'] == 1)

  304. 						{

  305. 							member_list = member_list.concat(["<td style='color:green;text-align:center;'>已審核</td>"]);

  306. 						}

  307. 						else

  308. 						{

  309. 							member_list = member_list.concat(["<td style='color:red;text-align:center;'><button class='btn btn-default' style='color:blue;' onclick='member_tx_check(",  tx_no + ");'>未通過</button></td>"]);

  310. 						}

  311. 						

  312. 						member_list = member_list.concat(["<td style='color:red;text-align:center;' id='valid_time_", tx_no, "'>", jdata[idx]['valid_time'], "</td>"]);	

  313. 						member_list = member_list.concat(["<td style='color:blue;text-align:left;' id='remarks_", tx_no, "'>", jdata[idx]['remarks'], "</td>"]);	

  314. 						member_list = member_list.concat(["</tr>"]);	

  315. 					}

  316. 					$("#check_point_list_detail").append(member_list.join(''));  

  317. 				}

  318.         	});

  319. }

  320. 

  321. 

  322. 

  323. 

  324. 

  325. 

  326. 

  327. </script>