One Hat Cyber Team

Your IP: 216.73.216.208
Server IP: 13.127.59.50
Server: Linux ip-172-31-46-210 5.15.0-1033-aws #37~20.04.1-Ubuntu SMP Fri Mar 17 11:39:30 UTC 2023 x86_64
Server Software: Apache/2.4.41 (Ubuntu)
PHP Version: 7.4.3-4ubuntu2.29
Buat File | Buat Folder
Dir : ~/proc/self/root/var/www/ecommerce_pg/app/
View File Name : helpers.php

<?php
use App\Models\Transaction;
use App\Models\ClientUser;

function checkHelpers()
{
  return  true;
  dd('helper.php is working');
}

function storeTxn($request_arr,$gateway_id)
{
    // $request_arr['email'] = 'dan@g.com';
    // $request_arr['name'] = 'daniel';
    // $request_arr['userId'] = '173';
    // $request_arr['phone'] = '1231241241244';
    // $request_arr['amount'] = '100';
    // $request_arr['orderId'] = time();
    // $request_arr['ip'] = '115.99.62.37';

    if (\DB::table('transactions')->select('id')->where('orderId',$request_arr['orderId'])->where('status','!=',1)->first()) {
      return false;
    }

    if (!\DB::table('transactions')->select('id')->where('orderId',$request_arr['orderId'])->first()) {
      $row = [];
      $row['orderId'] = $request_arr['orderId'];

      $row['email'] = $request_arr['email'];
      $row['name'] = $request_arr['name'];
      $row['user_id'] = $request_arr['userId'];
      $row['phone'] = $request_arr['phone'];
      $row['amount'] = $request_arr['amount'];

      $row['requestJson'] = json_encode($request_arr);
      $row['gatewayId'] = $gateway_id;
      $row['merch_id'] = $request_arr['merch_id'];
      $row['created_at'] = $row['updated_at'] = date('Y-m-d H:i:s');
      $row['back23'] = 0;

      if ($request_arr['HTTP_ORIGIN']) {
        $row['client_url'] = $request_arr['HTTP_ORIGIN'];
      }
      else {
        $row['client_url'] = $_SERVER['HTTP_ORIGIN'];
      }
      $result = DB::table('transactions')->insertGetId($row);

      $user = ClientUser::where('email',$request_arr['email'])->first();
      if (!$user) {
        $user = new ClientUser();
        $user->user_id = $request_arr['userId'];
        $user->name = $request_arr['name'];
        $user->email = $request_arr['email'];
        $user->phone = $request_arr['phone'];
        $user->save();
      }

      if ($request_arr['ip']) {
        try {

          $transactionLog = new \App\Models\TransactionLog;
          $transactionLog ->ip=$request_arr['ip'];
          $transactionLog ->user_agent=$request_arr['user_agent'];
          $transactionLog ->user_id=$request_arr['userId'];
          $transactionLog ->order_id=$request_arr['orderId'];
          $transactionLog ->transaction_id=$new->id;

          $location = \Location::get($request_arr['ip']);
          $transactionLog ->location=json_encode($location);
          $transactionLog ->countryName=$location->countryName;
          $transactionLog ->countryCode=$location->countryCode;
          $transactionLog ->regionCode=$location->regionCode;
          $transactionLog ->regionName=$location->regionName;
          $transactionLog ->cityName=$location->cityName;

          $transactionLog->save();

        } catch (\Exception $e) {

        }

      }
    }
    else {
      $old = Transaction::where('orderId',$request_arr['orderId'])->first();
      $old->requestJson = json_encode($request_arr);
      $old->gatewayId = $gateway_id;
      $old->save();
    }

    // dd('here');

    return true;
}

function updateTxn($response_arr,$orderId)
{
  $txn = Transaction::where('orderId',$orderId)->first();
  if ($txn && $txn->status!=2) {
    $txn->responseJson = json_encode($response_arr);
    $txn->back23 = 1;
    $txn->sent21 = 0;
    $txn->save();
  }

  return $txn;
}



function storePayout($request_arr,$gateway_id)
{
    if (DB::table('payouts')->where('orderId',$request_arr['orderId'])->where('status','!=',1)->first()) {
      return false;
    }

    if (!DB::table('payouts')->where('orderId',$request_arr['orderId'])->first()) {
      // dd($request_arr);
      $row = [];
      $row['orderId'] = $request_arr['orderId'];

      $row['email'] = $request_arr['email'];
      $row['name'] = $request_arr['name'];
      $row['user_id'] = $request_arr['userId'];
      $row['phone'] = $request_arr['phone'];
      $row['amount'] = $request_arr['amount'];

      $row['requestJson'] = json_encode($request_arr);
      $row['gatewayId'] = $gateway_id;
      $row['back23'] = 0;
      $result = DB::table('payouts')->insert($row);

      $user = DB::table('client_users')->where('email',$request_arr['email'])->first();
      if (!$user) {
        $row = [];
        $row['user_id'] = $request_arr['userId'];
        $row['name'] = $request_arr['name'];
        $row['email'] = $request_arr['email'];
        $row['phone'] = $request_arr['phone'];
        $result = DB::table('client_users')->insertGetId($row);
      }
    }
    else {
      $old = DB::table('payouts')->where('orderId',$request_arr['orderId'])->update([
        'requestJson' => json_encode($request_arr),
        'gatewayId' => $gateway_id
      ]);
    }
    return true;
}