|
Server : Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 DAV/2 PHP/5.2.17 System : Linux localhost 2.6.18-419.el5 #1 SMP Fri Feb 24 22:47:42 UTC 2017 x86_64 User : nobody ( 99) PHP Version : 5.2.17 Disable Function : NONE Directory : /home/queenjbs/yuchun/eximbay_php/ |
Upload File : |
<?php
include $_SERVER['DOCUMENT_ROOT']."/conf/conf_dir.php";
/**
아래 설정 된 값은 테스트용 secretKey입니다.
테스트로만 진행하시고 발급 받으신 값으로 변경하셔야 됩니다.
*/
$secretKey = $card_secretkey;//secretkey
foreach($_POST as $Key=>$value) {
if($Key == "fgkey"){
continue;
}
$hashMap[$Key] = $value;
}
$rescode = $_POST['rescode'];//0000 : 정상
$resmsg = $_POST['resmsg'];//결제 결과 메세지
$fgkey = $_POST['fgkey'];//검증 fgkey
//rescode=0000 일때 fgkey 확인
if($rescode == "0000"){
//fgkey 검증키 생성
$size = count($hashMap);
ksort($hashMap);
$counter = 0;
foreach ($hashMap as $key => $val) {
if ($counter == $size-1){
$sortingParams .= $key."=" .$val;
}else{
$sortingParams .= $key."=" .$val."&";
}
++$counter;
}
//echo $sortingParams;
$linkBuf = $secretKey. "?".$sortingParams;
$newFgkey = hash("sha256", $linkBuf);
//fgkey 검증 실패 시 에러 처리
if(strtolower($fgkey) != $newFgkey){
$rescode = "ERROR";
$resmsg = "Invalid transaction";
}
}
if($rescode == "0000"){
//가맹점 측 DB 처리하는 부분
//해당 페이지는 Back-End로 처리되기 때문에 스크립트, 세션, 쿠키 사용이 불가능 합니다.
$orderstep=2;
if($orderstep == 2) $where = ",d_bank='$date[totime]' ";
$query = "update shop_order set orderstep ='$orderstep',buyfix='0' $where where uid = '$param2' and orderid='$param1'";
$result = mysql_query($query, $db_con);
$query = "update shop_ordergoods set orderstep ='$orderstep' $where where parent = '$param2'";
$result = mysql_query($query, $db_con);
$qrys = Get_dbres("select * from shop_order where uid = '$param2' and orderid='$param1'");
$rows = mysql_fetch_array($qrys);
$midx = $rows[mbruid]; //회원 idx
$uidx = $rows[orderid]; //주문번호 매칭
//회원가입결제 일때만 사용함.
if($rows[display]==1){
$qry = Get_dbres("select * from user where id = '$midx'");
$row = mysql_fetch_array($qry);
$mCode = $row[member_code];
$benddate = $row[m_enddate];
if($benddate && $row[auth_code] == 10){
$end_arr = explode("-",$benddate);
$end_time = mktime(0,0,0,$end_arr[1], $end_arr[2], $end_arr[0]);
$now_time = mktime(0,0,0,date("m"), date("d"), date("Y"));
$giganCount = ($end_time - $now_time)/86400;
}else{
$giganCount =-1;
}
if($giganCount >= 0){
#유료회원 기간이 남아있다면.. m_enddate 날짜에 기간 플러스함.
$end_arr = explode("-",$benddate);
$tmpyearn = $end_arr[0];
$tmpyearp=$end_arr[0]+1;
$time =mktime(0, 0, 0, $end_arr[1], '01', $end_arr[0]);
$beforeMonth = date("Y-m-d",strtotime("+1 month", $time));
$beforeMonthArr = explode("-",$beforeMonth);
$tmp_start_date = $tmpyearn."-".$beforeMonthArr[1]."-01";
$tmp_end_date = $tmpyearp."-".$end_arr[1]."-".$end_arr[2];
$whereDate1 =",startdate='$tmp_start_date',enddate='$tmp_end_date'";
$whereDate2 =",m_startdate='$tmp_start_date',m_enddate='$tmp_end_date'";
}else{
#유료회원 기간이 없다면.. 입금완료일의 월의 1일로 시작일이되고 ,enddate는 이 시작일의 전달 의 말일로 된다.
//$today="2018-03-15";
$todayArr = explode("-",$today);
$tmp_start_date = $todayArr[0]."-".$todayArr[1]."-01";
$time =mktime(0, 0, 0, $todayArr[1], $todayArr[2], $todayArr[0]);
$beforeMonth = date("Y-m-d",strtotime("-1 month", $time));
$beforeMonthArr = explode("-",$beforeMonth);
if($todayArr[1] == "01"){
$tmpyearp= $todayArr[0];
}else{
$tmpyearp= $todayArr[0]+1;
}
$end_day = date("t", mktime(0, 0, 0, $beforeMonthArr[1], 1, $tmpyearp));
$tmp_end_date = $tmpyearp."-".$beforeMonthArr[1]."-".$end_day;
$whereDate1 =",startdate='$tmp_start_date',enddate='$tmp_end_date'";
$whereDate2 =",m_startdate='$tmp_start_date',m_enddate='$tmp_end_date'";
}
//회원번호가 있다면 그대로 쓰기..20150502
if(!$mCode){
$member_code = get_db("select max(member_code) from user where activated = 1"); //정회원번호주기
$numberVal = substr($member_code, 2, 6)+1;
//SV03400 번 부터 시작 루크코리아 번호 시작하자.20180910
if($numberVal <= 101) $numberVal= 101;//첫번째 들어갈 사람위해
$member_code = $initialCode.sprintf("%05d",$numberVal);
}else{
$member_code=$mCode;
}
//echo $member_code;
//exit;
//캐쉬 결제
$adminIP = $_SERVER["REMOTE_ADDR"];
$cash_cnt = get_db("SELECT count(user_id) FROM user_cash where user_id='$midx' and flag='D'")+1;
//캐쉬 결제
$mode="D";
$adminIP = $_SERVER["REMOTE_ADDR"];
$queryupok = "update user_cash set flag = '$mode' ,inning='$cash_cnt',admin_id='auto' ,admin_date=now() , admin_ip='$adminIP' $whereDate1 where cash_no = '$uidx' and order_uid = '$param2'";
$queryupok_result = mysql_query($queryupok,$db_con);
//echo "<br>";
//member table 결재 정보 수정
$queryupok = "update user set auth_code = '10',cash_chk='$idx',cash_cnt='$cash_cnt' $whereDate2 ,member_code='$member_code' where id = '$midx'";
$queryupok_result = mysql_query($queryupok,$db_con);
}
}
?>