function setReceiptIos($arr){
if(!isset($arr)){
return 'ESY9001';
} else if(empty($arr["receipt_data"])){
return 'EPT0015';
} else if(empty($arr["uid"])){
return 'EPT0007';
} else if(empty($arr["iap_type"])){
return 'EPT0016';
} else if(empty($arr["ptid"])){
return 'EPT0004';
}
// get mydb
$mydb = &$this->mydb;
date_default_timezone_set("Asia/Taipei");
function acurl($receipt_data, $sandbox=0){
// SandBox , Official
$secret = apple_connect_serect_key;
$POSTFIELDS = array("receipt-data" => $receipt_data, 'password'=>$secret, "");
$POSTFIELDS = json_encode($POSTFIELDS);
//正式購買地址 沙盒購買地址
$url_buy = "https://buy.itunes.apple.com/verifyReceipt";
$url_sandbox = "https://sandbox.itunes.apple.com/verifyReceipt";
$url = $sandbox ? $url_sandbox : $url_buy;
//簡單的curl
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $POSTFIELDS);
$result = curl_exec($ch);
curl_close($ch);
return $result;
}
// 請求驗證
$html = acurl($arr["receipt_data"]);
$data = json_decode($html, true);
// 如果是沙盒資料 則驗證沙盒模式
if($data['status']=='21007'){
// 請求驗證
$html = acurl($arr["receipt_data"], 1);
$data = json_decode($html,true);
$data['sandbox'] = '1';
}
// 判斷是否購買成功
if(intval($data['status'])===0){
$result=array(
'status' => $data['status'],
'message' => '購買成功'
);
}else{
$result=array(
'status' => $data['status'],
'message' => '購買失敗'
);
return $result;
}
$latestPosition = 0;
$purchase_date_ms = "0";
$receipt = array();
// latest_receipt_info 只會回傳可續訂的收據, 其他收據要在 IN_APP 裡面找
if ($arr["iap_type"] == "subscription") {
$receipt = $data["latest_receipt_info"];
}
else {
$receiptArr = $data["receipt"]["in_app"];
$receiptArrLength = count($receiptArr);
if ( $receiptArrLength > 0){
for ($i=0; $i<$receiptArrLength; $i++){
if ( (double) $receiptArr[$i]["purchase_date_ms"] > (double) $purchase_date_ms ){
$purchase_date_ms = (double) $receiptArr[$i]["purchase_date_ms"];
$latestPosition = $i;
}
}
}
$receipt = $receiptArr;
}
$transaction_id = 'NULL';
if (isset($receipt[$latestPosition]["transaction_id"]) ){
$transaction_id = "'".$receipt[$latestPosition]["transaction_id"]."'";
}
$product_id = 'NULL';
if (isset($receipt[$latestPosition]["product_id"]) ){
$product_id = "'".$receipt[$latestPosition]["product_id"]."'";
}
$purchase_date = 'NULL';
if (isset($receipt[$latestPosition]["purchase_date"]) ){
$purchase_date = "'".date("Y-m-d H:i:s",strtotime($receipt[$latestPosition]["purchase_date"]))."'";
}
$expires_date = 'NULL';
if (isset($receipt[$latestPosition]["expires_date"]) ){
$expires_date = "'".date("Y-m-d H:i:s",strtotime($receipt[$latestPosition]["expires_date"]))."'";
}
$cancellation_date = 'NULL';
if (isset($receipt[$latestPosition]["cancellation_date"]) ){
$cancellation_date = "'".date("Y-m-d H:i:s",strtotime($receipt[$latestPosition]["cancellation_date"]))."'";
}
$cancellation_reason = 'NULL';
if (isset($receipt[$latestPosition]["cancellation_reason"]) ){
$cancellation_reason = "'".$receipt[$latestPosition]["cancellation_reason"]."'";
}
$original_purchase_date = 'NULL';
if (isset($receipt[$latestPosition]["original_purchase_date"]) ){
$original_purchase_date = "'".date("Y-m-d H:i:s",strtotime($receipt[$latestPosition]["original_purchase_date"]))."'";
}
{ $query = "
INSERT INTO `".PREFIX_TABLE_0."_".DB_NAME_1."`.`".PREFIX_TABLE_0."_history_user_ios_receipt` (
`prefixid` ,
`huirid` ,
`uid` ,
`transaction_id` ,
`product_id` ,
`purchase_date` ,
`expires_date` ,
`cancellation_date` ,
`cancellation_reason` ,
`original_purchase_date` ,
`encode_string` ,
`ptid` ,
`seq` ,
`switch` ,
`insertt`,
`modifyt`
) VALUES (
'".PREFIX_INDEX_0."',
NULL,
'".$arr["uid"]."',
{$transaction_id},
{$product_id},
{$purchase_date},
{$expires_date},
{$cancellation_date},
{$cancellation_reason},
{$original_purchase_date},
'".$arr["receipt_data"]."',
'".$arr["ptid"]."',
'10',
'Y',
NOW(),
NOW()
)";
}
// echo $query ; exit;
if(!$mydb->query($query)) return 'ESY9002';
return $result;
}
