MySQL & PHP References: square payment form

Showing posts with label square payment form. Show all posts

Monday, October 26, 2020

Square Payment Form PHP -- Customer linked to Payment Order

After lot of bang bang. I could find a way to do 3 tasks with Square Payment Form in PHP

Check from Square Customer Director if USER EXISTS based on PHONE number - If yes Get "CUSTOMER ID" and MAKE PAYMENT
If Customer does not exists in Directory -- CREATE A NEW USER -- GO & GET --> find CUSTOMER ID --> & MAKE PAYMENT
Get PAYMENT ID & SAVE IT IN MySQL Database

PS : This is very crud way of scripting (hahaha). Had to find a way to get this project done. I found out simple way by using GOTO statement. Hope it will help you of my 3 weeks of in between projects and delivered.

ENV file -- env (without extension -- plain text file)

# Acceptable values are sandbox, production or custom. 
ENVIRONMENT=sandbox 

# Production credentials
PRODUCTION_ACCESS_TOKEN=EAAAEHVIqnlTrOXTNRrE-OrUb543339iU5B4Ah1mg87659we74jbf448dVk87m
PRODUCTION_APP_ID=sq0idp-ZsOG3433Y9U7QUT53433cV33mA
PRODUCTION_LOCATION_ID=D33BS33SCC343Y6

# Sandbox credentials
SANDBOX_ACCESS_TOKEN=EAAAE33ssbbDcCM33wXvcuOZagCmAaVGlFDmU0STei8393wZCA2RdfWKonGOQhEVkR7N
SANDBOX_APP_ID=sandbox-sq0idb-6KYsus78fsdfseglC55Z_5mLw

Genarate Square Idempotency Key CLASS) - square-functions.php

class UUID {
  public static function v3($namespace, $name) {
    if(!self::is_valid($namespace)) return false;

    // Get hexadecimal components of namespace
    $nhex = str_replace(array('-','{','}'), '', $namespace);

    // Binary Value
    $nstr = '';

    // Convert Namespace UUID to bits
    for($i = 0; $i < strlen($nhex); $i+=2) {
      $nstr .= chr(hexdec($nhex[$i].$nhex[$i+1]));
    }

    // Calculate hash value
    $hash = md5($nstr . $name);

    return sprintf('%08s-%04s-%04x-%04x-%12s',

      // 32 bits for "time_low"
      substr($hash, 0, 8),

      // 16 bits for "time_mid"
      substr($hash, 8, 4),

      // 16 bits for "time_hi_and_version",
      // four most significant bits holds version number 3
      (hexdec(substr($hash, 12, 4)) & 0x0fff) | 0x3000,

      // 16 bits, 8 bits for "clk_seq_hi_res",
      // 8 bits for "clk_seq_low",
      // two most significant bits holds zero and one for variant DCE1.1
      (hexdec(substr($hash, 16, 4)) & 0x3fff) | 0x8000,

      // 48 bits for "node"
      substr($hash, 20, 12)
    );
  }

  public static function v4() {
    return sprintf('%04x%04x-%04x-%04x-%04x-%04x%04x%04x',

      // 32 bits for "time_low"
      mt_rand(0, 0xffff), mt_rand(0, 0xffff),

      // 16 bits for "time_mid"
      mt_rand(0, 0xffff),

      // 16 bits for "time_hi_and_version",
      // four most significant bits holds version number 4
      mt_rand(0, 0x0fff) | 0x4000,

      // 16 bits, 8 bits for "clk_seq_hi_res",
      // 8 bits for "clk_seq_low",
      // two most significant bits holds zero and one for variant DCE1.1
      mt_rand(0, 0x3fff) | 0x8000,

      // 48 bits for "node"
      mt_rand(0, 0xffff), mt_rand(0, 0xffff), mt_rand(0, 0xffff)
    );
  }

  public static function v5($namespace, $name) {
    if(!self::is_valid($namespace)) return false;

    // Get hexadecimal components of namespace
    $nhex = str_replace(array('-','{','}'), '', $namespace);

    // Binary Value
    $nstr = '';

    // Convert Namespace UUID to bits
    for($i = 0; $i < strlen($nhex); $i+=2) {
      $nstr .= chr(hexdec($nhex[$i].$nhex[$i+1]));
    }

    // Calculate hash value
    $hash = sha1($nstr . $name);

    return sprintf('%08s-%04s-%04x-%04x-%12s',

      // 32 bits for "time_low"
      substr($hash, 0, 8),

      // 16 bits for "time_mid"
      substr($hash, 8, 4),

      // 16 bits for "time_hi_and_version",
      // four most significant bits holds version number 5
      (hexdec(substr($hash, 12, 4)) & 0x0fff) | 0x5000,

      // 16 bits, 8 bits for "clk_seq_hi_res",
      // 8 bits for "clk_seq_low",
      // two most significant bits holds zero and one for variant DCE1.1
      (hexdec(substr($hash, 16, 4)) & 0x3fff) | 0x8000,

      // 48 bits for "node"
      substr($hash, 20, 12)
    );
  }

  public static function is_valid($uuid) {
    return preg_match('/^\{?[0-9a-f]{8}\-?[0-9a-f]{4}\-?[0-9a-f]{4}\-?'.
                      '[0-9a-f]{4}\-?[0-9a-f]{12}\}?$/i', $uuid) === 1;
  }


  	/// usage -- 
  	//$v4uuid = UUID::v4();

 	//echo 'generated code : ' . $v4uuid;
}

HTML FORM - paynow.php

<!DOCTYPE html>
<html>
<head>
	<title></title>
<style type="text/css">
	#xtbl { width: 400px; }
	#xtbl  { width: 100%; }
	#xtbl td { padding: 5px; }
	#xtbl [type=text],[type=tel],[type=email] { padding: 5px; font-size: 14px; margin: 6px 0px; width: 100%; }
</style>

<?php
require 'vendor/autoload.php';

use Square\Environment;
$dotenv = Dotenv\Dotenv::create(__DIR__);
$dotenv->load();

$upper_case_environment = strtoupper(getenv('ENVIRONMENT'));

?> 

<script type="text/javascript" src=
    <?php
        echo "\"";
        echo ($_ENV["ENVIRONMENT"] === Environment::PRODUCTION)  ?  "https://js.squareup.com/v2/paymentform"
                                            :  "https://js.squareupsandbox.com/v2/paymentform";
        echo "\"";
    ?>
  ></script>
  <script type="text/javascript">
    window.applicationId =
      <?php
        echo "\"";
        echo getenv($upper_case_environment.'_APP_ID');
        echo "\"";
      ?>;
    window.locationId =
    <?php
      echo "\"";
      echo getenv($upper_case_environment.'_LOCATION_ID');
      echo "\"";
    ?>;
  </script>
<script type="text/javascript" src="js/sq-payment-form.js"></script>
  <link rel="stylesheet" type="text/css" href="css/sq-payment-form.css">

</head>
<body>

<div class="sq-payment-form">



    <div id="sq-ccbox">

  <form id="nonce-form" novalidate action="check-customer.php" method="post" style="padding: 30px; border: #c3c3c3 1px solid; border-radius: 8px;">

      	<center><img src="images/square-logo.png" style="width: 180px; margin-bottom: 25px;"></center>

      	<table id="xtbl">
			<tr>
				<td colspan="2">
					<label>Your Full Name</label>
					<input type="text" name="cname" id="cname" placeholder="name familyname">
				</td>
			</tr>
			<tr id="col2">
				<td>
					<label>Phone #</label>
					<input type="tel" name="cphone" id="cphone" class="cxPhone" maxlength="12">
				</td>
				<td>
					<label>E-Mail @</label>
					<input type="email" name="cemailid" id="cemailid">
				</td>
			</tr>
			<tr id="col2">
				<td>
					<label>Fare</label>
					<input type="text" name="ifare" id="ifare">
				</td>
				<td>
					<label>Note</label>
					<input type="text" name="note" id="note">
				</td>
			</tr>
		</table>
		<h3 style="background: #000; color: #fff; padding: 8px 0px; text-align: center;"><b>Credit Card Details</b></h3>
        <div class="sq-field">
          <label class="sq-label">Card Number</label>
          <div id="sq-card-number"></div>
        </div>
        <div class="sq-field-wrapper">
          <div class="sq-field sq-field--in-wrapper">
            <label class="sq-label">CVV</label>
            <div id="sq-cvv"></div>
          </div>
          <div class="sq-field sq-field--in-wrapper">
            <label class="sq-label">Expiration</label>
            <div id="sq-expiration-date"></div>
          </div>
          <div class="sq-field sq-field--in-wrapper">
            <label class="sq-label">Postal</label>
            <div id="sq-postal-code"></div>
          </div>
        </div>
        <div class="sq-field">

        	
          <button id="sq-creditcard" class="sq-button" onclick="onGetCardNonce(event)">
            Pay Now 
          </button>
        </div>
        <div id="error"></div>
        <input type="hidden" id="card-nonce" name="nonce">
      </form>
    </div>
  </div>
</body>
</1html>

PROCESS PAYMENT Page --- process-payment.php

<?php include('config.php');
			//print_r($_POST); 
			$booknow = $_POST;

			require 'vendor/autoload.php';

			use Dotenv\Dotenv;
			use Square\Models\Money;
			use Square\Models\CreatePaymentRequest;
			use Square\Exceptions\ApiException;
			use Square\SquareClient;
			use Square\Environment;
			use SquareConnect\ApiClient;
			use Square\Models\CreateCustomerRequest;

			$idem = UUID::v4();


			$sname = explode(' ', $_POST["cname"]);
			$sname0 = $sname[0];
			$sname1 = $sname[1];

			$cphone = $_POST["cphone"];
		
			$cemailid = $_POST["cemailid"];
			$ifare = ($_POST["ifare"] * 100);
			$xnote = $_POST["note"];

			//echo '<br><br>fare : ' . $ifare . '<br><br>';


			$dotenv = Dotenv::create(__DIR__);
			$dotenv->load();

			$upper_case_environment = strtoupper(getenv('ENVIRONMENT'));

			$access_token =  getenv($upper_case_environment.'_ACCESS_TOKEN');   

			//print_r($access_token);
			 //echo '<br><br><br>';

			$client = new SquareClient([
			  'accessToken' => $access_token,  
			  'environment' => getenv('ENVIRONMENT')
			]);


			if ($_SERVER['REQUEST_METHOD'] != 'POST') {
			  error_log('Received a non-POST request');
			  echo 'Request not allowed';
			  http_response_code(405);
			  return;
			}

			$nonce = $_POST['nonce'];
			if (is_null($nonce)) {
			  echo 'Invalid card data';
			  http_response_code(422);
			  return;
			}

				goto searchCustomers;

				searchCustomers: ///search customers

				$phone_number = new \Square\Models\CustomerTextFilter();
				$phone_number->setFuzzy($cphone);

				$filter = new \Square\Models\CustomerFilter();
				$filter->setPhoneNumber($phone_number);

				$query = new \Square\Models\CustomerQuery();
				$query->setFilter($filter);

				$body = new \Square\Models\SearchCustomersRequest();
				$body->setQuery($query);

				$api_response = $client->getCustomersApi()->searchCustomers($body);

				if ($api_response->isSuccess()) {

					$rmn = $api_response->getBody();
					$stx = json_decode($rmn,true);

					echo '<br><br>';	
					echo '# of arrays : ' . count($stx);
					if(count($stx) != 0){
						//echo '<br><br>';		
						$cust_id = $stx["customers"][0]["id"];
						//echo "Customer ID : " . $cust_id;
						goto makePayment;
						


					} else {
						//echo 'user do not exists';
						/// new customer - start

						$body1 = new \Square\Models\CreateCustomerRequest();
						$body1->setIdempotencyKey($idem);
						$body1->setGivenName($sname0);
						$body1->setFamilyName($sname1);
						$body1->setEmailAddress($cemailid);
						$body1->setPhoneNumber($cphone);

						$api_response = $client->getCustomersApi()->createCustomer($body1);

						if ($api_response->isSuccess()) {
						    $result = $api_response->getResult();
						    sleep(12);
						     goto searchCustomers;
						} else {
						    $errors = $api_response->getErrors();
						   
						}

						/// new customer - end
					}
				} else {
				   echo '<br><br>sorry not found!<bR><br>';
				}

				goto end;


				makePayment:

				$amount_money = new \Square\Models\Money();
				$amount_money->setAmount($ifare);
				$amount_money->setCurrency('USD');

				$body = new \Square\Models\CreatePaymentRequest(
						'cnon:card-nonce-ok',
						$idem,
					    $amount_money
				);
				$body->setCustomerId($cust_id);
				$body->setNote($xnote);

				$api_response = $client->getPaymentsApi()->createPayment($body);

				if ($api_response->isSuccess()) {
				    $result = $api_response->getResult();
				    $pmt = $api_response->getResult();

				    echo '<br><br>';
				    echo "PAYEMNT SUCCESSUFLL <BR><br><br>";
				   // print_r($srt);
					echo '<br><br>';

					$resp_arr = $api_response->getBody();
					  $resp_dec = json_decode($resp_arr, true);
					  $transid = $resp_dec["payment"]["id"];
					  echo 'payment id : ' . $transid;

				    
				    goto end;

				} else {
				    $errors = $api_response->getErrors();
				    echo 'payment FAILEDDDDDDDDDD';
				}

				goto end;

				end:
?>

MySQL & PHP References

Search This Blog