问如何用laravel查询
EN

Stack Overflow用户

提问于 2022-09-29 12:37:18

回答 1查看 29关注 0票数 -3

选择facilities.facility_name，

当( COUNT(compliances_master.compliance_phase_name =‘产前护理-1’)然后compliances_master.compliance_phase_name=‘产前护理-1’结束时(compliances_master.compliance_phase_name =‘产前护理-1’)其他'0‘结束为ANS_1，当(compliances_master.compliance_phase_name =’产前护理-2‘)，则COUNT(compliances_master.compliance_phase_name =’产前护理-2‘结束为ANS_2，当( COUNT(compliances_master.compliance_phase_name =‘产前护理-3’)结束时(compliances_master.compliance_phase_name =‘产前护理-3’)，其他'0‘结束为ANS_3，当(compliances_master.compliance_phase_name =’产前护理-4‘)，则COUNT(compliances_master.compliance_phase_name) = '0’结束为ANS_4，COUNT(compliances_master.compliance_phase_name)作为ANC_total从compliance_visits

compliance_visits.facility_id = facilities.facility_id内连接compliances_master ON compliance_visits.compliance_id = compliances_master.compliance_id GROUP BY (facilities.facility_name)

if-statement

join

laravel

回答 1

Stack Overflow用户

回答已采纳

发布于 2022-09-29 13:21:46

请检查一下这个，让我知道它是否工作。

\DB::('compliance_visits')->select('facilities.facility_name')
->addSelect(\DB::raw("CASE WHEN (compliances_master.compliance_phase_name = 'Antenatal Care-1') THEN COUNT(compliances_master.compliance_phase_name = 'Antenatal Care-1' ) ELSE '0' END AS ANS_1, CASE WHEN (compliances_master.compliance_phase_name = 'Antenatal Care-2') THEN COUNT(compliances_master.compliance_phase_name = 'Antenatal Care-2' ) ELSE '0' END AS ANS_2 , CASE WHEN (compliances_master.compliance_phase_name = 'Antenatal Care-3') THEN COUNT(compliances_master.compliance_phase_name = 'Antenatal Care-3' ) ELSE '0' END AS ANS_3, CASE WHEN (compliances_master.compliance_phase_name = 'Antenatal Care-4') THEN COUNT(compliances_master.compliance_phase_name = 'Antenatal Care-4' ) ELSE '0' END AS ANS_4, COUNT(compliances_master.compliance_phase_name) AS ANC_total"))
->join('facilities','facilities.facility_id','compliance_visits.facility_id')
->join('compliances_master','compliances_master.compliance_id','compliance_visits.compliance_id')
->groupBy('facilities.facility_name');

票数 1

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持

原文链接：

https://stackoverflow.com/questions/73895673

复制

相似问题

问如何用laravel查询
EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何用laravel查询EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何用laravel查询
EN