$total_payable_amount = $total_payable_amount[0] . '.' . $total_payable_amount[1]; } } $amount = $total_payable_amount * $L_QTY0 - $_SESSION['deductable_ref_amt']; $response = $sale->authorizeOnly(); if ($response->approved) { $transaction_id = $response->transaction_id; $responseheader = array('Order Status' => $response->response_reason_text, 'Invoice Number' => $response->invoice_number, 'Authorization Code' => $response->authorization_code, 'Credit card' => $response->card_type, 'Billing Address' => $response->address); $TYPE = $_POST['pay_mod_id']; $REFERRAL_AMOUNT = $_SESSION['deductable_ref_amt']; require_once $_SERVER['DOCUMENT_ROOT'] . "/system/includes/dboperations.php"; $sql = "insert into transaction_details (PAYERID,COUPONID,TIMESTAMP,CORRELATIONID,ACK,FIRSTNAME,LASTNAME,TRANSACTIONID,TRANSACTIONTYPE,PAYMENTTYPE,ORDERTIME,AMT,PAYMENTSTATUS,REASONCODE,L_QTY0,USERID,EMAIL,TYPE,CAPTURED,REFERRAL_AMOUNT) values ('{$response->customer_id}','{$couponid}',now(),'{$response->authorization_code}','{$response->response_reason_text}','{$response->first_name}','{$response->last_name}','{$response->transaction_id}','{$response->transaction_type}','{$response->method}',now(),'{$response->amount}','{$response->response_reason_text}','{$response->response_reason_code}','{$qty}','{$userid}','{$response->email_address}','{$TYPE}','0','{$REFERRAL_AMOUNT}')"; $result = mysql_query($sql); $txnid = mysql_insert_id(); $_SESSION['txn_id'] = $txnid; check_deal_status($couponid); $cid = $couponid; $_SESSION['COUPONID'] = $couponid; $deal_quantity = $_SESSION['deal_quantity'] = $qty; $txn_amt = $response->amount; $_SESSION['txn_amt'] = $response->amount; $_SESSION['reshash'] = $responseheader; $txnid = $_SESSION['txn_id']; $resArray["AMT"] = $response->amount; $resArray["TRANSACTIONID"] = $response->transaction_id; $gift_recipient_id = $_SESSION['gift_recipient_id']; include $_SERVER['DOCUMENT_ROOT'] . "/system/includes/process_transaction.php"; $location = "/orderdetails.html"; header("Location: {$location}"); exit; } else {
$PAYMENTTYPE = $resArray['PAYMENTTYPE']; $ORDERTIME = $resArray['ORDERTIME']; $AMT = $resArray['AMT']; $CURRENCYCODE = $resArray['CURRENCYCODE']; $PAYMENTSTATUS = $resArray['PAYMENTSTATUS']; $PENDINGREASON = $resArray['PENDINGREASON']; $REASONCODE = $resArray['REASONCODE']; $L_QTY0 = $_SESSION['deal_quantity']; $USERID = $_SESSION['userid']; $EMAIL = $resArray['EMAIL']; $TYPE = $_SESSION['pay_mod_id']; $REFERRAL_AMOUNT = $_SESSION['deductable_ref_amt']; $queryString = "insert into transaction_details (PAYERID,PAYERSTATUS,COUNTRYCODE,COUPONID,TIMESTAMP,CORRELATIONID,ACK,FIRSTNAME,LASTNAME,TRANSACTIONID,RECEIPTID,TRANSACTIONTYPE,PAYMENTTYPE,ORDERTIME,AMT,CURRENCYCODE,PAYMENTSTATUS,PENDINGREASON,REASONCODE,L_QTY0,USERID,EMAIL,TYPE,REFERRAL_AMOUNT) values ('{$PAYERID}','{$PAYERSTATUS}','{$COUNTRYCODE}','{$COUPONID}','{$TIMESTAMP}','{$CORRELATIONID}','{$ACK}','{$FIRSTNAME}','{$LASTNAME}','{$TRANSACTIONID}','{$RECEIPTID}','{$TRANSACTIONTYPE}','{$PAYMENTTYPE}','{$ORDERTIME}','{$AMT}','{$CURRENCYCODE}','{$PAYMENTSTATUS}','{$PENDINGREASON}','{$REASONCODE}','{$L_QTY0}','{$USERID}','{$EMAIL}','{$TYPE}','{$REFERRAL_AMOUNT}')"; $resultSet = mysql_query($queryString) or die(mysql_error()); $_SESSION['txn_id'] = mysql_insert_id(); check_deal_status($COUPONID); //check deal status if it reached max limit close the deal $_SESSION['COUPONID'] = $COUPONID; $_SESSION['txn_amt'] = $AMT + $REFERRAL_AMOUNT; $orderdetails = "<table>"; foreach ($resArray as $key => $value) { $orderdetails .= "<tr><td> {$key}:</td><td>{$value}</td>"; } $orderdetails .= "</table>"; $to = $EMAIL; $subject = APP_NAME . ' Order Status'; $message = $orderdetails; $headers = 'From: ' . SITE_EMAIL . '' . "\r\n" . 'Reply-To: ' . $EMAIL . '' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); @mail($to, $subject, $message, $headers); //inputs for the transaction method $cid = $_SESSION['COUPONID'];