脚本宝典收集整理的这篇文章主要介绍了CakePHP分页订单无法正常工作,脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。
我遇到了麻烦
$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"
为我工作.
我希望它也能帮到你.
以上是脚本宝典为你收集整理的CakePHP分页订单无法正常工作全部内容,希望文章能够帮你解决CakePHP分页订单无法正常工作所遇到的问题。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。