这段sql如何转成Laravel ORM来写？-php教程-PHP中文网

这段sql如何转成Laravel ORM来写？

php中文网

发布： 2016-08-20 09:04:16

原创

1162人浏览过

SELECT
    ea.id,
    ea.name,
    ea.capital_balance,
    ea.total_balance,
    ea.available_balance,
    ea.cashable_balance,
    ea.market_value as old_market_value,
    mv.market_value,
    ea.total_balance + mv.market_value as total_value,
    ea.brokerage_rate,
    ea.state,
    ea.description,
    ea.created_at
FROM
    external_accounts ea,
    (
        SELECT
            c.external_account_id,
            SUM(c.amount) AS market_value
        FROM
            (
                SELECT
                    a.external_account_id,
                    a.total_count * b.price AS amount
                FROM
                    main_inventories a
                JOIN stocks b ON a.stock_code = b.code
            ) AS c
        GROUP BY
            c.external_account_id
    ) AS mv
WHERE
    ea.id = mv.external_account_id

登录后复制

主要是子Select那一段不知道怎么写，之所以非要一条sql写完的原因就是因为涉及到排序。

回复内容：

SELECT
    ea.id,
    ea.name,
    ea.capital_balance,
    ea.total_balance,
    ea.available_balance,
    ea.cashable_balance,
    ea.market_value as old_market_value,
    mv.market_value,
    ea.total_balance + mv.market_value as total_value,
    ea.brokerage_rate,
    ea.state,
    ea.description,
    ea.created_at
FROM
    external_accounts ea,
    (
        SELECT
            c.external_account_id,
            SUM(c.amount) AS market_value
        FROM
            (
                SELECT
                    a.external_account_id,
                    a.total_count * b.price AS amount
                FROM
                    main_inventories a
                JOIN stocks b ON a.stock_code = b.code
            ) AS c
        GROUP BY
            c.external_account_id
    ) AS mv
WHERE
    ea.id = mv.external_account_id

登录后复制

主要是子Select那一段不知道怎么写，之所以非要一条sql写完的原因就是因为涉及到排序。

将表关系都关联起来，在查询，查询里的算法操作可以交由php完成，你可以看下这个

Laravel的关联，可以使用分组，返回字段和聚合函数

登录后复制

http://www.kancloud.cn/baidu/...

Med-PaLM

来自 Google Research 的大型语言模型，专为医学领域设计。

221

查看详情

大家都在看：

RSC是什么概念_PHP程序员要掌握吗【概念】 PHP增删改查怎么实现_php增删改查实现步骤【代码】 PhpStorm怎样配置Xdebug调试_PhpStormXdebug环境搭建与调试【步骤】 RSC与PHP语法差异大吗_快速对比看这里【语法】邮件发送怎样触发php代码执行_邮件发送触发php代码执行方法【技巧】