/home/brandsfa/public_html/app/Repositories/LoyaltyPointTransactionRepository.php
<?php
namespace App\Repositories;
use App\Contracts\Repositories\LoyaltyPointTransactionRepositoryInterface;
use App\Models\BusinessSetting;
use App\Models\LoyaltyPointTransaction;
use App\Models\User;
use Exception;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Pagination\LengthAwarePaginator;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Str;
class LoyaltyPointTransactionRepository implements LoyaltyPointTransactionRepositoryInterface
{
public function __construct(
private readonly LoyaltyPointTransaction $loyaltyPointTransaction,
private readonly BusinessSetting $businessSetting,
private readonly User $user,
)
{
}
public function add(array $data): string|object
{
return $this->loyaltyPointTransaction->create($data);
}
public function getFirstWhere(array $params, array $relations = []): ?Model
{
// TODO: Implement getFirstWhere() method.
}
public function getList(array $orderBy = [], array $relations = [], int|string $dataLimit = DEFAULT_DATA_LIMIT, int $offset = null): Collection|LengthAwarePaginator
{
// TODO: Implement getList() method.
}
public function getListWhere(array $orderBy = [], string $searchValue = null, array $filters = [], array $relations = [], int|string $dataLimit = DEFAULT_DATA_LIMIT, int $offset = null): Collection|LengthAwarePaginator
{
$query = $this->loyaltyPointTransaction
->when((isset($filters['from']) && isset($filters['to'])), function ($query) use ($filters) {
$query->whereBetween('created_at', [$filters['from'] . ' 00:00:00', $filters['to'] . ' 23:59:59']);
})
->when(isset($filters['transaction_id']), function ($query) use ($filters) {
$query->where('transaction_id', $filters['transaction_id']);
})
->when(isset($filters['transaction_type']) && $filters['transaction_type'] != 'all', function ($query) use ($filters) {
$query->where('transaction_type', $filters['transaction_type']);
})
->when(isset($filters['user_id']), function ($query) use ($filters) {
$query->where('user_id', $filters['user_id']);
})
->when(!empty($orderBy), function ($query) use ($orderBy) {
$query->orderBy(array_key_first($orderBy), array_values($orderBy)[0]);
});
return $dataLimit == 'all' ? $query->get() : $query->paginate($dataLimit)->appends(['searchValue' => $searchValue]);
}
public function getListWhereSelect(array $orderBy = [], string $searchValue = null, array $filters = [], array $relations = [], int|string $dataLimit = DEFAULT_DATA_LIMIT, int $offset = null): Collection|LengthAwarePaginator
{
$query = $this->loyaltyPointTransaction->selectRaw('sum(credit) as total_credit, sum(debit) as total_debit')
->when(($filters['from'] && $filters['to']), function ($query) use ($filters) {
$query->whereBetween('created_at', [$filters['from'] . ' 00:00:00', $filters['to'] . ' 23:59:59']);
})
->when($filters['transaction_type'], function ($query) use ($filters) {
$query->where('transaction_type', $filters['transaction_type']);
})
->when($filters['customer_id'], function ($query) use ($filters) {
$query->where('user_id', $filters['customer_id']);
})->latest();
return $dataLimit == 'all' ? $query->get() : $query->paginate($dataLimit)->appends(['searchValue' => $searchValue]);
}
public function update(string $id, array $data): bool
{
// TODO: Implement update() method.
}
public function delete(array $params): bool
{
$this->loyaltyPointTransaction->where($params)->delete();
return true;
}
public function addLoyaltyPointTransaction(string|int $userId, string $reference, string|int|float $amount, string $transactionType): bool
{
$settings = array_column($this->businessSetting->whereIn('type', ['loyalty_point_status', 'loyalty_point_exchange_rate', 'loyalty_point_item_purchase_point'])->get()->toArray(), 'value', 'type');
if ($settings['loyalty_point_status'] != 1) {
return true;
}
$credit = 0;
$debit = 0;
$user = $this->user->find($userId);
if ($transactionType == 'order_place') {
$credit = (int)($amount * $settings['loyalty_point_item_purchase_point'] / 100);
} else if ($transactionType == 'point_to_wallet') {
$debit = $amount;
} else if ($transactionType == 'refund_order') {
$debit = $amount;
}
$currentBalance = $user['loyalty_point'] + $credit - $debit;
$loyaltyPointTransaction = [
'user_id' => $user['id'],
'transaction_id' => Str::uuid(),
'transaction_type' => $transactionType,
'reference' => $reference,
'balance' => $currentBalance,
'credit' => $credit,
'debit' => $debit,
'created_at' => now(),
'updated_at' => now(),
];
try {
DB::beginTransaction();
$user->loyalty_point = $currentBalance;
$user->save();
$this->loyaltyPointTransaction->create($loyaltyPointTransaction);
DB::commit();
return true;
} catch (Exception $ex) {
info($ex);
DB::rollback();
}
return false;
}
}