bot-28/app/Http/Controllers/api/ActivityReward.php

<?php

namespace App\Http\Controllers\api;

use App\Models\ActivityReward as ActivityRewardModel;
use App\Services\ActivityRewardService;
use Illuminate\Validation\ValidationException;
use Exception;

class ActivityReward extends BaseController
{
    public function index()
    {
        try {
            $time = time();
            $params = [
                'start_time' => ['>=', $time],
                'end_time' => ['<=', $time],
            ];
            $where = ActivityRewardService::getWhere($params);
            $query = ActivityRewardModel::where($where);


            $sql = $query->toSql();
//            $list = $query->orderByDesc('id')->get()->toArray();
        } catch (ValidationException $e) {
            return $this->error($e->validator->errors()->first());
        } catch (Exception $e) {
            return $this->error($e->getMessage());
        }
        return $this->success($sql);
    }
}