加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长学院 > PHP教程 > 正文

CakePHP分页订单无法正常工作

发布时间:2020-12-13 13:26:41 所属栏目:PHP教程 来源:网络整理
导读:我正在使用cakephp V2.0.2 我遇到了麻烦 $this-paginate = array( "fields" = array( "Player.join_country" ),"joins" = array( array( "table" = "banner_key_current_ext","alias" = "BannerKeyCurrentExt","type" = "inner","conditions" = "BannerKeyCu
我正在使用cakephp V2.0.2

我遇到了麻烦

$this->paginate = array(
                "fields" => array(
                    "Player.join_country"
                ),"joins" => array(
                    array(
                        "table" => "banner_key_current_ext","alias" => "BannerKeyCurrentExt","type" => "inner","conditions" => "BannerKeyCurrentExt.banner_key_id = BannerKeyCurrent.banner_key_id"
                    ),array(
                        "table" => "players","alias" => "Player","conditions" => "BannerKeyCurrentExt.identifier = Player.zban_player_id" . $country_condition
                    ),array(
                        "table" => "users","alias" => "User","conditions" => "BannerKeyCurrent.user_id = User.user_id"
                    ),array(
                        "table" => "tag_links","alias" => "TagLinks","conditions" => "TagLinks.id = BannerKeyCurrent.user_id AND TagLinks.tag_id = 710"
                    )
                ),"conditions" => array(
                    "BannerKeyCurrent.date BETWEEN ? AND ?" => array(
                        $this->request->query["period_from"],$this->request->query["period_to"]
                    ),"BannerKeyCurrent.plan_id" => $brands_plan_map[$this->request->query["brand"]]["plans"],"BannerKeyCurrent.operation_id" => $operation_ids
                ),"group" => array( "Player.join_country" ),"order" => array(
                    "Player.join_country" => "DESC"
                ),"limit" => 999999,"maxLimit" => 999999
            );

一切都适用于所有领域,联接,组,限制没有问题,但订单简单不会工作.输出sql_dump元素表明它永远不会添加到查询中.

任何帮助将不胜感激.

谢谢

通过做
"order" =>  "Player.join_country DESC"

为我工作.

我希望它也能帮到你.

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读