39 lines
1.7 KiB
PHP
39 lines
1.7 KiB
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use Illuminate\Database\Eloquent\Model;
|
|
|
|
class Callback extends Model
|
|
{
|
|
|
|
public function updateCallbackMsgStatus($status_code, $code, $airtel_money_id, $message, $id){
|
|
$current_time = date('Y-m-d H:i:s');
|
|
$last_updated_by = 'airtel_callback';
|
|
|
|
$transaction = Models\AirtelTransaction::where('reference_id', $id)->first();
|
|
$transaction->status = 'PROCESSED';
|
|
$transaction->airtel_status_code = $status_code;
|
|
$transaction->airtel_code = $code;
|
|
$transaction->airtel_money_id = $airtel_money_id;
|
|
$transaction->airtel_message = $message;
|
|
$transaction->last_updated_by = '$last_updated_by';
|
|
$result = $transaction->save();
|
|
|
|
return $result;
|
|
}
|
|
public function clickPayUpdateCallbackMsgStatus($status_code, $code, $airtel_money_id, $message, $id){
|
|
$current_time = date('Y-m-d H:i:s');
|
|
$last_updated_by = 'airtel_callback';
|
|
//$sql = "UPDATE transactions SET status = 'PROCESSED', airtel_status_code = '$status_code', airtel_code = '$code', airtel_money_id = '$airtel_money_id', airtel_message = '$message', updated_at = '$current_time', last_updated_by = '$last_updated_by' WHERE reference_id = '{$id}'"
|
|
$sql = "UPDATE clickpay_900012.transactions_airtel SET status = 'PROCESSED', airtel_status_code = '$status_code', airtel_code = '$code', airtel_money_id = '$airtel_money_id', airtel_message = '$message', updated_at = '$current_time', last_updated_by = '$last_updated_by' WHERE reference_id = '{$id}'";
|
|
$result = mysqli_query($conn, $sql);
|
|
if (!$result) {
|
|
die(mysqli_error($conn));
|
|
}
|
|
else {
|
|
return mysqli_affected_rows($conn);
|
|
}
|
|
}
|
|
}
|