<?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);
        }
    }
}