php - Eloquent 查询构建器 if 子句实现

Question

我有一个这样的查询

        SELECT
            `id`,
            `advert_id`,
            IF(
                `chats`.`owner_id` = ?,
                `chats`.`sender_id`,
                `chats`.`owner_id`
            ) AS `sender_id`,
            IF(
                `chats`.`owner_id` = ?,
                `chats`.`owner_access_time`,
                `chats`.`sender_access_time`
            ) AS `access_time`,
            `created_time`
        FROM
            `chats`
        WHERE 1
            AND `id` = ?
            AND `owner_id` = ?
            AND `project_id` = ?
        UNION
        SELECT
            `id`,
            `advert_id`,
            IF(
                `chats`.`owner_id` = ?,
                `chats`.`sender_id`,
                `chats`.`owner_id`
            ) AS `sender_id`,
            IF(
                `chats`.`owner_id` = ?,
                `chats`.`owner_access_time`,
                `chats`.`sender_access_time`
            ) AS `access_time`,
            `created_time`
        FROM
            `chats`
        WHERE 1
            AND `id` = ?
            AND `sender_id` = ?
            AND `project_id` = ?
        ORDER BY `id` ASC

我正在尝试使用这样的 Eloquent 查询构建器来实现它

    $chats = $database
        ->table('chats')
        ->where('sender_id', '=', $arguments['user_id'])
        ->union(
            $database
                ->table('chats')
                ->where('owner_id', '=', $arguments['user_id'])
                ->get(
                    [
                        'advert_id',
                        'owner_id',
                        'sender_id',
                        'id'
                    ]
                )
        )
        ->get(
            [
                'advert_id',
                'owner_id',
                'sender_id',
                'id'
            ]
        );

但是我收到错误方法 getBindings 不存在。，而且我找不到如何用 Eloquent 方式编写“if”子句，我找到的只是when方法，但据我了解，它仅适用于“如果存在参数，请在查询中添加附加子句”，这不是我需要的。

Answer 1

解决方案

    $chats = $database::table('chats')
        ->where('sender_id', '?')
        ->select(
            'id',
            'advert_id',
            $database::raw('
                IF(
                    `chats`.`owner_id` = ?,
                    `chats`.`sender_id`,
                    `chats`.`owner_id`
                ) AS `sender_id`
            '),
            $database::raw('
                IF(
                    `chats`.`owner_id` = ?,
                    `chats`.`owner_access_time`,
                    `chats`.`sender_access_time`
                ) AS `access_time`
            ')
        )
        ->setBindings(
            [
                $arguments['user_id'],
                $arguments['user_id'],
                $arguments['user_id'],
            ]
        )
        ->union(
            $database::table('chats')
                ->where('owner_id', '?')
                ->select(
                    'id',
                    'advert_id',
                    $database::raw('
                        IF(
                            `chats`.`owner_id` = ?,
                            `chats`.`sender_id`,
                            `chats`.`owner_id`
                        ) AS `sender_id`
                    '),
                    $database::raw('
                        IF(
                            `chats`.`owner_id` = ?,
                            `chats`.`owner_access_time`,
                            `chats`.`sender_access_time`
                        ) AS `access_time`
                    ')
                )
                ->setBindings(
                    [
                        $arguments['user_id'],
                        $arguments['user_id'],
                        $arguments['user_id'],
                    ]
                )
        )
        ->get();