tp6中case、when、else、end的用法_米醋屋个人技术博客

tp6中case、when、else、end的用法

2021-04-26 52.73w热度

case、when、else、end是常见的操作，这里给一个demo
```
$res = Db::name("session_detail")
            ->alias("a")
            ->join("user_session b", "b.id = a.sess_id", "left")
            ->join("staff s", "b.cust_id = s.account", "left")
            ->join("user_info c", "b.u_cust_id = c.cust_id", "left")
            ->join("access acc", "b.access_id = acc.id", "left")
            ->join("robot r", "acc.robot_id = r.id", "left")
            ->where(["a.sess_id" => $id])
            ->where("a.evaluate_msg_type", "IN", "(0, 8, 9, 100)")
            ->field("a.id as session_detail_id,a.content, a.state, a.msg_type, 
            a.sess_id, a.create_time,a.msg_key,b.u_cust_id as to_id,
            CASE a.send_from 
            WHEN 4 THEN acc.head_img 
            WHEN 5 THEN r.img 
            WHEN 1 THEN c.headimgurl 
            WHEN 3 THEN c.headimgurl 
            ELSE s.profile END headimgurl, 
            CASE a.send_from 
            WHEN 4 THEN '系统消息' 
            WHEN 5 THEN r.name
            WHEN 1 THEN c.nickname 
            WHEN 3 THEN c.nickname
            ELSE s.nickname 
            END nickname, 
            a.send_from, a.evaluate_msg_type
            ")
            ->select();
```

注:原创不易,转载请注明出处( https://micuu.com/new/1531.html )，本站所有资源来源于网络收集，如有侵权请联系QQ245557979进行清除。

最后修改与 2022-02-22

tp6中case、when、else、end的用法

留言反馈