TP5-分頁類別中的each函數-php教程-PHP中文網

TP5-分頁類別中的each函數

不言

發布： 2023-03-24 13:06:02

原創

5893 人瀏覽過

這篇文章介紹的內容是關於TP5-分頁類別中的each函數，有著一定的參考價值，現在分享給大家，有需要的朋友可以參考一下

$list = Db::name(&#39;merchant_order_detail&#39;)->alias(&#39;a&#39;)->join(&#39;merchant_order b&#39;, &#39;b.id = a.order_id&#39;)->where($whereStr)->field($file)->order($order)->paginate(Config::get(&#39;list_rows&#39;), false, [&#39;page&#39; => $page,&#39;query&#39;=>$param])->each(function($item, $key){
            $item[&#39;loglist&#39;] = Db::name(&#39;merchant_order_detail_log&#39;)->where("order_detail_id=".$item[&#39;id&#39;]." and amount>0")->field(&#39;order_sn&#39;)->select();            return $item;
        });

登入後複製

$list = Db::name(&#39;merchant_order&#39;)->alias(&#39;a&#39;)
                ->join(&#39;merchant_member mm&#39;, &#39;mm.id=a.member_id&#39;, &#39;LEFT&#39;)
                ->where($whereStr)
                ->field($file)
                ->order([&#39;a.create_time&#39; => &#39;desc&#39;])
                ->paginate(Config::get(&#39;list_rows&#39;), false, [&#39;page&#39; => $page,&#39;query&#39;=>$param])
                ->each(function($item,$key){                    if($item[&#39;pid&#39;] == 0) {
                        $item[&#39;company_name&#39;] = Db::name(&#39;merchant&#39;)->where([&#39;member_id&#39;=>$item[&#39;member_id&#39;]])->value(&#39;company_name&#39;);
                        $item[&#39;sub_company_name&#39;] = Db::name(&#39;merchant&#39;)->where([&#39;member_id&#39;=>$item[&#39;member_id&#39;]])->value(&#39;sub_company_name&#39;);
                        $item[&#39;corporation&#39;] = Db::name(&#39;merchant&#39;)->where([&#39;member_id&#39;=>$item[&#39;member_id&#39;]])->value(&#39;corporation&#39;);
                    } else {
                        $item[&#39;company_name&#39;] = Db::name(&#39;merchant&#39;)->where([&#39;member_id&#39;=>$item[&#39;pid&#39;]])->value(&#39;company_name&#39;);
                        $item[&#39;sub_company_name&#39;] = Db::name(&#39;merchant&#39;)->where([&#39;member_id&#39;=>$item[&#39;pid&#39;]])->value(&#39;sub_company_name&#39;);
                        $item[&#39;corporation&#39;] = Db::name(&#39;merchant&#39;)->where([&#39;member_id&#39;=>$item[&#39;pid&#39;]])->value(&#39;corporation&#39;);
                    }                    return $item;
                });

登入後複製

$merchant_member_list = Db::name(&#39;merchant_member&#39;)->alias(&#39;mm&#39;)
                                ->join(&#39;merchant m&#39;, &#39;m.member_id = mm.id&#39;, &#39;LEFT&#39;)
                                ->join(&#39;merchant_type mt&#39;, &#39;m.merchant_type_id = mt.id&#39;, &#39;LEFT&#39;)
                                ->where($where)
                                ->field($field)
                                ->order([&#39;mm.is_lock&#39; => &#39;asc&#39;,&#39;mm.create_time&#39; => &#39;desc&#39;])
                                ->paginate(Config::get(&#39;list_rows&#39;), false, [&#39;page&#39; => $page, &#39;query&#39; => $param])
                                ->each(function($item, $key){                                    if($item[&#39;mt_pid&#39;]==&#39;0&#39;){
                                        $item[&#39;cate&#39;] = &#39;一级&#39;;
                                    } else {
                                        $item[&#39;cate&#39;] = Db::name(&#39;merchant_type&#39;)->where("id=".$item[&#39;mt_pid&#39;])->value(&#39;name&#39;);
                                    }                                    return $item;
                                });

登入後複製