| Server IP : www.kowitt.ac.th / Your IP : 216.73.216.118 Web Server : Microsoft-IIS/7.5 System : Windows NT SERVER02 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.6.31 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/inetpub/wwwroot/mis/student/mis/qr_payment/ |
Upload File : |
<?php session_start();
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header ("Last-Modified: " . date("D, d M Y H:i:s") . " GMT");
header ("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header ("Pragma: no-cache"); // HTTP/1.0
// print_r($_SESSION);
// exit;
include ("../system/config_sql_server.php");
// ตั้งเวลา refresh หน้า Page
// $page = $_SERVER['PHP_SELF'];
// $sec = "60";
if($_GET['diuts']!=""){
$IDSTU_LPS=substr(base64_decode($_GET['diuts']),2,10);
$_SESSION['stu_id']=substr(base64_decode($_GET['diuts']),2,10);
}else{
$IDSTU_LPS=$_SESSION['stu_id']; /////////IDDDDD 6022040049 $_SESSION['OnlineService']
}
$_SESSION['stu_id']
//echo $IDSTU_LPS;
?>
<!DOCTYPE html>
<html lang="en">
<head>
<!--Refresh page-->
<!--<meta http-equiv="refresh" content="10">-->
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<!-- <meta http-equiv="refresh" content="<?php echo $sec?>;URL='<?php echo $page?>'"> -->
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title></title>
<!-- <link rel="shortcut icon" href="../image/logo_satit.png">-->
<link type="text/css" rel="stylesheet" href="../bootstrap/bootstrap.css">
<link rel="stylesheet" type="text/css" href="../css/font-awesome.css">
<style>
@media only screen and (max-width: 500px) {
.btn_pay {
display: none;
}
}
.bg_logo1{
padding: 20px;
width: 300px;
height: 80px;
background-color: #0e3d67;
margin-top: 20px;
margin-left: auto;
margin-right: auto;
position: relative;
}
.logo1{
width: 150px;
height: 50px;
}
.logo2{
width: 150px;
height: 50px;
margin: 10px;
}
.border_pay {
border: 6px solid #0e3d67;
border-width: thick;
width: 300px;
height: auto;
margin-left: auto;
margin-right: auto;
}
.Color_yellow{
color:#FFA500;
font-size: 25px;
}
.displayShow{
display:block;
}
.displayNotShow{
display:none;
}
</style>
</head>
<body>
<?php
//กำหนดวันที่ ให้แสดงยอด
$sql_active="SELECT dbo.Finance_DateBillPayment.txtDate_BillPayMent, dbo.Finance_DateBillPayment.AYear, dbo.Finance_DateBillPayment.Term, dbo.Finance_DateBillPayment.Active, ( dbo.Finance_DateBillPayment.Term + '/' + dbo.Finance_DateBillPayment.AYear ) AS TY FROM Finance_DateBillPayment WHERE Active = '1'";
$query_active=sqlsrv_query($conn,$sql_active);
$arr_active=sqlsrv_fetch_array($query_active);
//echo $arr_active['Active'];
if($arr_active['Active']>='1'){/////<<<<เช็คการแสดง
/*===========================================================*/
/*เช็คการชำระเงินหรือยัง Table finance_BillPayment_Noti
$sql_chk="SELECT
TOP 1
dbo.finance_BillPayment_Noti.stu_id,
dbo.finance_BillPayment_Noti.amount,
dbo.finance_BillPayment_Noti.transactionId,
CONVERT (VARCHAR(10),dbo.finance_BillPayment_Noti.DateRecrod,126) AS DateRecrod,
CONVERT (VARCHAR,dbo.finance_BillPayment_Noti.DateRecrod,108) AS TimeRecrod,
(dbo.prename.pre_prename +''+ dbo.student.stu_fname +' '+ dbo.student.stu_lname) AS stuname
FROM
dbo.finance_BillPayment_Noti
LEFT JOIN dbo.student ON dbo.student.stu_id = dbo.finance_BillPayment_Noti.stu_id
LEFT JOIN dbo.prename ON dbo.student.pre_id = dbo.prename.pre_id
WHERE dbo.finance_BillPayment_Noti.stu_id = '".$IDSTU_LPS."'
ORDER BY DateRecrod DESC";
echo $sql_chk;
$query_chk=sqlsrv_query($conn,$sql_chk);
$arr_chk=sqlsrv_fetch_array($query_chk);
/*เช็คการชำระเงินหรือยัง Table finance_BillPayment_Noti*/
?>
<div class="container" >
<center>
<div id="show_QR"></div>
</center>
</div>
<?php
}else{
echo "<center><p style='color:red; font-size:30px; margin-top:60px;'>".'"ยังไม่สามารถชำระผ่านธนาคารได้ในเวลานี้ !!!"'."</p></center>";
}
?>
<?php
if($_GET['data_select']!="All"){?>
<input type="hidden" name="data_TY" id="data_TY" value="<?php echo $_GET['data_select'];?>">
<?php }else{?>
<input type="hidden" name="data_TY" id="data_TY" value="<?php echo $arr_active['TY'];?>">
<?php }?>
<input type="hidden" name="DATA_IDSTU_LPS" id="DATA_IDSTU_LPS" value="<?php echo $IDSTU_LPS;?>">
<input type="hidden" name="data_select" id="data_select" value="<?php echo $_GET['data_select'];?>">
</body>
</html>
<script type="text/javascript" src="../jquery/jquery-3.2.1.min.js"></script>
<script type="text/javascript" src="../bootstrap/bootstrap.js"></script>
<!-- <?php if($arr_chk['transactionId']=="" ){?>
<script type="text/javascript">$( "#show_QR" ).load( "qrcode_reload.php" );</script>
<?php }else{?>
<script type="text/javascript">$( "#show_QR" ).load( "qrcode_paysuccess.php" );</script>
<?php }?> -->
<script type="text/javascript">$( "#show_QR" ).load( "qrcode_reload.php?data_select=<?php echo $_GET['data_select'];?>" );</script>
<script type="text/javascript">
var DATA_IDSTU_LPS = $("#DATA_IDSTU_LPS").val();
var data_TY = $("#data_TY").val();
var data_select = $("#data_select").val();
var storeTimeInterval = setInterval( function(){ // เขียนฟังก์ชัน javascript ให้ทำงานทุก ๆ 30 วินาที
$.get( "qrcode_chk_statusPay.php", { "DATA_IDSTU_LPS":DATA_IDSTU_LPS,'data_TY':data_TY,'data_select':data_select },function(getData){
console.log(getData);
var Obj = JSON.parse(getData);
//console.log(Obj.status);
if(Obj.status=='Paysuccess'){
//alert("Paysuccess");
$( "#show_QR" ).load( "qrcode_paysuccess.php" );
//clearInterval(storeTimeInterval);
}else if(Obj.status=='Unsuccess'){
//alert("Unsuccess");
//console.log(Obj.CHK_loop);
//var CHK_loop_index=Obj.CHK_loop;
// alert(CHK_loop_index);
// for($a=1;$a<=CHK_loop_index;$a++){
//$( "#show_QR" ).load( "qrcode_reload.php" );
// break;
// }
}
}) ;
},2000);
</script>