집 > 기사 > 백엔드 개발 > 페이징 클래스의 TP5-각 기능

페이징 클래스의 TP5-각 기능

不言원래의: 2018-04-20 10:21:005895검색

이 글은 TP5-pagination 클래스의 각 기능을 소개합니다. 이제는 모든 사람과 공유합니다. 도움이 필요한 친구들이 참고할 수 있습니다.

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

페이징 클래스의 TP5-각 기능

관련 기사