public function updateToken($token = '', $user_id = '') { $params = array('token' => $token, 'last_login' => date('c'), 'ip_address' => $_SERVER['REMOTE_ADDR']); $db_ext = new DbExt(); if ($db_ext->updateData("{{client}}", $params, 'client_id', $user_id)) { return true; } return false; }
public function UpdateCustomerReviews() { $db_ext = new DbExt(); if (isset($this->data['id'])) { $params = array('review' => $this->data['review'], 'status' => $this->data['status'], 'ip_address' => $_SERVER['REMOTE_ADDR']); if ($db_ext->updateData("{{review}}", $params, 'id', $this->data['id'])) { $this->code = 1; $this->msg = Yii::t("default", "Successful"); } else { $this->msg = Yii::t("default", "ERROR: cannot update"); } } else { $this->msg = ""; } }
} if (isset($_POST)) { if (is_array($_POST) && count($_POST) >= 1) { $step2 = true; $token = isset($_POST['stripeToken']) ? $_POST['stripeToken'] : ''; try { $customer = Stripe_Customer::create(array('email' => isset($_POST['stripeEmail']) ? $_POST['stripeEmail'] : '', 'card' => $token)); $charge = Stripe_Charge::create(array('customer' => $customer->id, 'amount' => $amount_to_pay, 'currency' => Yii::app()->functions->adminCurrencyCode())); $chargeArray = $charge->__toArray(true); /*dump("pay ->".$chargeArray['paid']); echo json_encode($chargeArray);*/ $db_ext = new DbExt(); $params_logs = array('order_id' => $_GET['id'], 'payment_type' => "stp", 'raw_response' => json_encode($chargeArray), 'date_created' => date('c'), 'ip_address' => $_SERVER['REMOTE_ADDR']); $db_ext->insertData("{{payment_order}}", $params_logs); $params_update = array('status' => 'paid'); $db_ext->updateData("{{order}}", $params_update, 'order_id', $_GET['id']); header('Location: ' . Yii::app()->request->baseUrl . "/store/receipt/id/" . $_GET['id']); } catch (Exception $e) { $error = $e; } } } ?> <div class="page-right-sidebar payment-option-page"> <div class="main"> <?php if (!empty($error)) { ?> <p class="uk-text-danger"><?php echo $error; ?>
<?php echo CHtml::hiddenField('action', 'bookATableMerchant'); echo CHtml::hiddenField('id', isset($_GET['id']) ? $_GET['id'] : ""); if (!isset($_GET['id'])) { echo CHtml::hiddenField("redirect", Yii::app()->request->baseUrl . "/merchant/tablebooking/Do/Add"); } ?> <?php $data = ''; if (isset($_GET['id'])) { $data = Yii::app()->functions->getBooking($_GET['id']); if ($data['viewed'] != 2) { $db_ext = new DbExt(); $params = array('viewed' => 2); $db_ext->updateData("{{bookingtable}}", $params, 'booking_id', $data['booking_id']); } } ?> <div class="uk-form-row"> <label class="uk-form-label"><?php echo Yii::t("default", "Number Of Guests"); ?> </label> <?php echo CHtml::textField('number_guest', isset($data['number_guest']) ? $data['number_guest'] : '', array('class' => 'numeric_only', 'data-validation' => "required")); ?> </div> <div class="uk-form-row">
try { $mp = new MP($admin_mercado_id, $admin_mercado_key); $filters = array("external_reference" => $reference); //dump($filters); $searchResult = $mp->search_payment($filters); //dump($searchResult); if (is_array($searchResult) && count($searchResult) >= 1) { if ($searchResult['status'] == 200) { $ref = explode("-", $reference); $package_id = isset($ref[0]) ? $ref[0] : ''; if (is_array($data) && count($data) >= 1) { $db_ext = new DbExt(); $params_logs = array('order_id' => $order_id, 'payment_reference' => $_GET['external_reference'], 'payment_type' => $payment_code, 'raw_response' => json_encode($_GET), 'date_created' => date('c'), 'ip_address' => $_SERVER['REMOTE_ADDR']); $db_ext->insertData("{{payment_order}}", $params_logs); $params_update = array('status' => 'paid'); $db_ext->updateData("{{order}}", $params_update, 'order_id', $order_id); header('Location: ' . Yii::app()->request->baseUrl . "/store/receipt/id/" . $_GET['id']); } else { $error = Yii::t("default", "Failed. Cannot process payment"); } } else { $error = Yii::t("default", "Failed. Cannot process payment") . " " . $searchResult['status']; } } else { $error = Yii::t("default", "ERROR: Invalid response from Mercadopago"); } } catch (Exception $e) { $error = $e->getMessage(); } } else { $error = Yii::t("default", "Failed. Cannot process payment");
} if (isset($_POST)) { if (is_array($_POST) && count($_POST) >= 1) { $step2 = true; $token = isset($_POST['stripeToken']) ? $_POST['stripeToken'] : ''; try { $customer = Stripe_Customer::create(array('email' => isset($_POST['stripeEmail']) ? $_POST['stripeEmail'] : '', 'card' => $token)); $charge = Stripe_Charge::create(array('customer' => $customer->id, 'amount' => $amount_to_pay, 'currency' => Yii::app()->functions->adminCurrencyCode())); $chargeArray = $charge->__toArray(true); $db_ext = new DbExt(); $params_logs = array('package_id' => $data['package_id'], 'merchant_id' => $data['merchant_id'], 'price' => $data['package_price'], 'payment_type' => $payment_code, 'membership_expired' => $data['membership_expired'], 'date_created' => date('c'), 'ip_address' => $_SERVER['REMOTE_ADDR'], 'PAYPALFULLRESPONSE' => json_encode($chargeArray)); if (isset($_GET['renew'])) { $membership_info = Yii::app()->functions->upgradeMembership($data['merchant_id'], $package_id); $params_logs['membership_expired'] = $membership_info['membership_expired']; $params_update = array('package_id' => $package_id, 'package_price' => $membership_info['package_price'], 'membership_expired' => $membership_info['membership_expired'], 'status' => 'active'); $db_ext->updateData("{{merchant}}", $params_update, 'merchant_id', $data['merchant_id']); } $db_ext->insertData("{{package_trans}}", $params_logs); $db_ext->updateData("{{merchant}}", array('payment_steps' => 3, 'membership_purchase_date' => date('c')), 'merchant_id', $data['merchant_id']); if (isset($_GET['renew'])) { header('Location: ' . Yii::app()->request->baseUrl . "/store/renewSuccesful"); } else { header('Location: ' . Yii::app()->request->baseUrl . "/store/merchantSignup/Do/step4/token/{$my_token}"); } } catch (Exception $e) { $error = $e; } } } ?> <div class="page-right-sidebar payment-option-page">
/*dump($payment_description); dump($amount_to_pay);*/ if (isset($_POST['x_card_num'])) { require_once 'anet_php_sdk/AuthorizeNet.php'; $transaction = new AuthorizeNetAIM(); $transaction->setSandbox(AUTHORIZENET_SANDBOX); $params = array('description' => $payment_description, 'amount' => $amount_to_pay, 'card_num' => $_POST['x_card_num'], 'exp_date' => $_POST['expiration_month'] . "/" . $_POST['expiration_yr'], 'first_name' => $_POST['x_first_name'], 'last_name' => $_POST['x_last_name'], 'address' => $_POST['x_address'], 'city' => $_POST['x_city'], 'state' => $_POST['x_state'], 'country' => $_POST['x_country'], 'zip' => $_POST['x_zip'], 'card_code' => $_POST['cvv']); //dump($params); $transaction->setFields($params); $response = $transaction->authorizeAndCapture(); if ($response->approved) { $resp_transaction = $response->transaction_id; $params_logs = array('order_id' => $data_get['id'], 'payment_type' => Yii::app()->functions->paymentCode('authorize'), 'raw_response' => json_encode($response), 'date_created' => date('c'), 'ip_address' => $_SERVER['REMOTE_ADDR'], 'payment_reference' => $resp_transaction); $db_ext->insertData("{{payment_order}}", $params_logs); $params_update = array('status' => 'paid'); $db_ext->updateData("{{order}}", $params_update, 'order_id', $data_get['id']); header('Location: ' . Yii::app()->request->baseUrl . "/store/receipt/id/" . $_GET['id']); die; } else { $error = $response->response_reason_text; } } } else { $error = Yii::t("default", "Sorry but we cannot find what your are looking for."); } ?> <div class="page-right-sidebar payment-option-page"> <div class="main"> <h2><?php
public function actionFaxPostBack() { $data = $_REQUEST; dump($data); if ($res = Yii::app()->functions->getFaxJobId($data['jobid'])) { dump($res); $record_id = $res['id']; $params = array('status' => $data['shortstatus'], 'api_raw_response' => $data['longstatus'], 'date_postback' => date('c')); dump($params); $db_ext = new DbExt(); $db_ext->updateData("{{fax_broadcast}}", $params, 'jobid', $data['jobid']); } }
public function actionIndex() { $db_ext = new DbExt(); $error = ''; $package_id = isset($_GET['package_id']) ? $_GET['package_id'] : ''; $amount_to_pay = 0; $back_url = Yii::app()->request->baseUrl . "/merchant/purchasesms"; $payment_ref = Yii::app()->functions->generateCode() . "TT" . Yii::app()->functions->getLastIncrement('{{sms_package_trans}}'); $package_id = isset($_GET['package_id']) ? $_GET['package_id'] : ''; $merchant_id = Yii::app()->functions->getMerchantID(); if ($res = Yii::app()->functions->getSMSPackagesById($package_id)) { $amount_to_pay = $res['price']; if ($res['promo_price'] > 0) { $amount_to_pay = $res['promo_price']; } $amount_to_pay = is_numeric($amount_to_pay) ? normalPrettyPrice($amount_to_pay) : ''; $payment_description .= isset($res['title']) ? $res['title'] : ''; /*dump($payment_description); dump($amount_to_pay); dump($payment_ref);*/ $amount_to_pay = number_format($amount_to_pay, 2, '.', ''); $cancel_url = Yii::app()->getBaseUrl(true) . "/merchant/purchasesms"; $accepturl = Yii::app()->getBaseUrl(true) . "/merchant/pysinit/?type=purchaseSMScredit&package_id=" . $package_id . "&mode=accept&mtid={$merchant_id}"; $callback = Yii::app()->getBaseUrl(true) . "/paysera/?type=purchaseSMScredit&package_id=" . $package_id . "&mode=callback&mtid={$merchant_id}"; $country = Yii::app()->functions->getOptionAdmin('admin_paysera_country'); $mode = Yii::app()->functions->getOptionAdmin('admin_paysera_mode'); $lang = Yii::app()->functions->getOptionAdmin('admin_paysera_lang'); $currency = Yii::app()->functions->adminCurrencyCode(); $projectid = Yii::app()->functions->getOptionAdmin('admin_paysera_project_id'); $password = Yii::app()->functions->getOptionAdmin('admin_paysera_password'); if (isset($_GET['mode'])) { if ($_GET['mode'] == "accept") { $payment_code = Yii::app()->functions->paymentCode("paysera"); $params = array('merchant_id' => $_GET['mtid'], 'sms_package_id' => $package_id, 'payment_type' => $payment_code, 'package_price' => $amount_to_pay, 'sms_limit' => isset($res['sms_limit']) ? $res['sms_limit'] : '', 'date_created' => date('c'), 'ip_address' => $_SERVER['REMOTE_ADDR'], 'payment_gateway_response' => json_encode($_GET)); $db_ext->insertData("{{sms_package_trans}}", $params); header('Location: ' . Yii::app()->request->baseUrl . "/merchant/smsReceipt/id/" . Yii::app()->db->getLastInsertID()); die; } try { $response = WebToPay::checkResponse($_GET, array('projectid' => $projectid, 'sign_password' => $password)); if (is_array($response) && count($response) >= 1) { if ($response['status'] == 0) { die("payment has no been executed"); } if ($response['status'] == 3) { die("additional payment information"); } $stmt = "SELECT * FROM\r\n\t\t \t{{sms_package_trans}}\r\n\t\t \tWHERE\r\n\t\t \tmerchant_id ='" . $_GET['mtid'] . "'\r\n\t\t \tAND\r\n\t\t \tsms_package_id='" . $_GET['package_id'] . "'\r\n\t\t \tORDER BY id DESC\r\n\t\t \tLIMIT 0,1\r\n\t\t \t"; if ($res2 = $db_ext->rst($stmt)) { $current_id = $res2[0]['id']; $params_update = array('status' => "paid"); $db_ext->updateData("{{sms_package_trans}}", $params_update, 'id', $current_id); } echo 'OK'; die; } else { $error = t("ERROR: api returns empty"); } } catch (WebToPayException $e) { $error = t("ERROR: Something went wrong") . ". " . $e; } } else { echo 'init'; } } else { $error = Yii::t("default", "Failed. Cannot process payment"); } if (!empty($error)) { //$this->render('error',array('message'=>$error)); echo $error; } //$this->createLogs(''); }
public function actionEpayBg() { $db_ext = new DbExt(); $data = $_GET; $msg = ''; $error_receiver = ''; if ($data['mode'] == "receiver") { $mode = Yii::app()->functions->getOptionAdmin('admin_mode_epaybg'); if ($mode == "sandbox") { $min = Yii::app()->functions->getOptionAdmin('admin_sandbox_epaybg_min'); $secret = Yii::app()->functions->getOptionAdmin('admin_sandbox_epaybg_secret'); } else { $min = Yii::app()->functions->getOptionAdmin('admin_live_epaybg_min'); $secret = Yii::app()->functions->getOptionAdmin('admin_live_epaybg_secret'); } /*dump($min); dump($secret);*/ $EpayBg = new EpayBg(); $ENCODED = $data['encoded']; $CHECKSUM = $data['checksum']; $hmac = $EpayBg->hmac('sha1', $ENCODED, $secret); /*dump("Check"); dump($CHECKSUM); dump($hmac);*/ //if ($hmac == $CHECKSUM) { $data_info = base64_decode($ENCODED); $lines_arr = split("\n", $data_info); $info_data = ''; //dump($lines_arr); if (is_array($lines_arr) && count($lines_arr) >= 1) { foreach ($lines_arr as $line) { if (!empty($line)) { $payment_info = explode(":", $line); $invoice_number = str_replace("INVOICE=", '', $payment_info[0]); $status = str_replace("STATUS=", '', $payment_info[1]); if (preg_match("/PAID/i", $payment_info[1])) { $info_data .= "INVOICE={$invoice_number}:STATUS=OK\n"; Yii::app()->functions->epayBgUpdateTransaction($invoice_number, $status); } else { $info_data .= "INVOICE={$invoice_number}:STATUS=ERR\n"; Yii::app()->functions->epayBgUpdateTransaction($invoice_number, $status); } } } echo $info_data; Yii::app()->functions->createLogs($info_data, "epaybg"); die; } else { $error_receiver = "ERR=Not valid CHECKSUM\n"; } /*} else { $error_receiver="ERR=Not valid CHECKSUM\n"; }*/ if (!empty($error_receiver)) { echo $error_receiver; Yii::app()->functions->createLogs($error_receiver, "epaybg"); } else { Yii::app()->functions->createLogs("none response", "epaybg"); } die; } elseif ($data['mode'] == "cancel") { $msg = t("Transaction has been cancelled"); } elseif ($data['mode'] == "accept") { if ($trans_info = Yii::app()->functions->barclayGetTokenTransaction($data['token'])) { //dump($trans_info); switch ($data['mode']) { case "accept": if ($trans_info['transaction_type'] == "order") { $params_update = array('status' => "pending", 'date_modified' => date('c')); $db_ext->updateData("{{order}}", $params_update, 'order_id', $data['token']); header('Location: ' . websiteUrl() . "/store/receipt/id/" . $data['token']); } else { if ($token_details = Yii::app()->functions->getMerchantByToken($data['token'])) { $db_ext->updateData("{{merchant}}", array('payment_steps' => 3, 'membership_purchase_date' => date('c')), 'merchant_id', $token_details['merchant_id']); header('Location: ' . websiteUrl() . "/store/merchantSignup/Do/thankyou2/token/" . $data['token']); } else { $msg = t("Token not found"); } } break; case "cancel": if ($trans_info['transaction_type'] == "order") { header('Location: ' . websiteUrl() . "/store/"); } else { header('Location: ' . websiteUrl() . "/store/merchantSignup/Do/step3/token/" . $data['token']); } break; } } else { $msg = t("Transaction information not found"); } } if (!empty($msg)) { $this->render('error', array('message' => $msg)); } }
public function epayBgUpdateTransaction($orderid = '', $status = '') { $db_ext = new DbExt(); /*dump($orderid); dump($status);*/ if ($info = $this->barclayTransactionByOrderId($orderid)) { //dump($info); $res = Yii::app()->functions->getMerchantByToken($info['token']); $package_id = $res['package_id']; switch ($info['transaction_type']) { case "renew": case "signup": if ($info['transaction_type'] == "renew") { $package_id = $info['param1']; if ($new_info = Yii::app()->functions->getPackagesById($package_id)) { $res['package_name'] = $new_info['title']; $res['package_price'] = $new_info['price']; if ($new_info['promo_price'] > 0) { $res['package_price'] = $new_info['promo_price']; } } $membership_info = Yii::app()->functions->upgradeMembership($res['merchant_id'], $package_id); $params = array('package_id' => $package_id, 'merchant_id' => $res['merchant_id'], 'price' => $res['package_price'], 'payment_type' => Yii::app()->functions->paymentCode('paysera'), 'membership_expired' => $membership_info['membership_expired'], 'date_created' => date('c'), 'ip_address' => $_SERVER['REMOTE_ADDR'], 'PAYPALFULLRESPONSE' => json_encode($_POST), 'TRANSACTIONID' => $orderid, 'TOKEN' => $orderid); } else { $params = array('package_id' => $res['package_id'], 'merchant_id' => $res['merchant_id'], 'price' => $res['package_price'], 'payment_type' => Yii::app()->functions->paymentCode('epaybg'), 'membership_expired' => $res['membership_expired'], 'date_created' => date('c'), 'ip_address' => $_SERVER['REMOTE_ADDR'], 'PAYPALFULLRESPONSE' => json_encode($_POST), 'TRANSACTIONID' => $orderid, 'TOKEN' => $orderid); } $params['status'] = strtolower($status); /*dump($params);*/ if (!$this->epayBGIsPaymentExist($orderid)) { $db_ext->insertData("{{package_trans}}", $params); } break; case "order": $params_logs = array('order_id' => $info['token'], 'payment_reference' => $orderid, 'payment_type' => Yii::app()->functions->paymentCode('epaybg'), 'raw_response' => json_encode($_POST), 'date_created' => date('c'), 'ip_address' => $_SERVER['REMOTE_ADDR']); if (!$this->epayBgValidatePaymentOrder($info['token'], $orderid)) { $db_ext->insertData("{{payment_order}}", $params_logs); $params_update = array('status' => $status); $db_ext->updateData("{{order}}", $params_update, 'order_id', $info['token']); } break; case "sms_purchase": $payment_reference = $info['orderid']; $stmt_update = "\r\n \t\t\t UPDATE {{sms_package_trans}}\r\n \t\t\t SET status=" . strtolower($this->q($status)) . "\r\n \t\t\t WHERE\r\n \t\t\t payment_reference=" . $this->q($payment_reference) . "\r\n \t\t\t AND\r\n \t\t\t sms_package_id=" . $this->q($info['param1']) . "\r\n \t\t\t "; $db_ext->qry($stmt_update); break; default: //echo 'not found'; break; } } }