<?php
use App\Constants\GlobalConst;
use App\Constants\PaymentGatewayConst;
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
return new class extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('transactions', function (Blueprint $table) {
$table->id();
$table->string('trx_id')->comment('Transaction ID');
$table->string('type');
$table->unsignedBigInteger('user_id')->nullable();
$table->unsignedBigInteger('user_wallet_id')->nullable();
$table->unsignedBigInteger('card_id')->nullable();
$table->unsignedBigInteger('payment_gateway_currency_id')->nullable();
$table->string('payment_type')->nullable();
$table->tinyInteger('payable_charge')->nullable();
$table->decimal('request_amount', 28, 8);
$table->decimal('fixed_charge', 28, 8);
$table->decimal('percent_charge', 28, 8);
$table->decimal('total_charge', 28, 8);
$table->decimal('total_payable', 28, 8);
$table->string('request_currency');
$table->decimal('available_balance', 28, 8)->nullable();
$table->string('payment_currency')->nullable()->comment('user payment currency (wallet/gateway)');
$table->string('remark')->nullable();
$table->text('details')->nullable();
$table->text('attribute')->nullable();
$table->tinyInteger('status')->nullable();
$table->text('reject_reason')->nullable();
$table->text('callback_ref')->nullable();
$table->timestamps();
$table->foreign("user_id")->references("id")->on("users")->onDelete("cascade")->onUpdate("cascade");
$table->foreign("user_wallet_id")->references("id")->on("user_wallets")->onDelete("cascade")->onUpdate("cascade");
$table->foreign("payment_gateway_currency_id")->references("id")->on("payment_gateway_currencies")->onDelete("cascade")->onUpdate("cascade");
$table->foreign("card_id")->references("id")->on("cards")->onDelete("cascade")->onUpdate("cascade");
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('transactions');
}
};
Initiates a new payment transaction.
create-order
| Parameter | Type | Details |
|---|---|---|
| amount | decimal | Your Amount , Must be rounded at 2 precision. |
| currency | string | Currency Code, Must be in Upper Case (Alpha-3 code) |
| success_url | string | Enter your return or success URL |
| cancel_url | string (optional) | Enter your cancel or failed URL |
Request Example (guzzle)
<?php
require_once('vendor/autoload.php');
$client = new \GuzzleHttp\Client();
$response = $client->request('POST', $base_url.'create-order', [
'headers' => [
'Authorization' => 'Bearer '. $authorizationToken,
'accept' => 'application/json',
'content-type' => 'application/json',
],
'form_params' => [
'amount' => '$amount',
'currency' => 'currency',
'success_url' => 'success_url',
'cancel_url' => 'cancel_url',
],
]);
echo $response->getBody();
**Response: SUCCESS (200 OK)**
{
"message": {
"success": [
"Order created successfully."
]
},
"data": {
"redirect_url":"https://example.com/login/OISADFDFSDFSF",
"order_details":{
"amount" : "10",
"fixed_charge" : 2,
"percent_charge" : 1,
"total_charge" : 3,
"total_payable" : 13,
"currency" : "USD",
"expiry_time": "2024-04-25T06:48:35.984285Z",
"success_url": "http://127.0.0.1/nfcpay/user/transaction/success",
"cancel_url": "http://127.0.0.1/nfcpay/user/transaction/cancel"
}
},
"type": "success"
}
**Response: ERROR (400 FAILED)**
{
"message": {
"error": [
"Invalid token."
]
},
"data": null,
"type": "error"
}