TP5-each function in paging class-PHP Tutorial-php.cn

TP5-each function in paging class

不言

Release： 2023-03-24 13:06:02

Original

5965 people have browsed it

The content of this article is about the each function in the TP5-paging class. It has a certain reference value. Now I share it with everyone. Friends in need can refer to it

$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;
        });

Copy after login

$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;
                });

Copy after login

$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;
                                });

Copy after login

Related recommendations:

How to hide index.php in TP5

The above is the detailed content of TP5-each function in paging class. For more information, please follow other related articles on the PHP Chinese website!