在列表中返回CakePHP GROUP和COUNT项

本文介绍了在列表中返回CakePHP GROUP和COUNT项的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 我知道这里有一些类似的问题，但是他们都是在使用的时候。 Model-> find （'所有'）; 但这不是我在做什么，我在做： Model-> find（'list'）; 这是什么使这个工作和不工作之间的区别。 对于一组产品，我想找到该组中的所有品牌以及每个品牌的数量。 听起来很简单，这里是我做的： $ fields = array（'Product.brand' 'COUNT（'Product`.`brand`）AS brand_count'） $ brand_data = $ this-> Product-> find（'list'，array（'fields'=> $字段，'conditions'=> $ conditions，'recursive'=> 0，'group'=>'Product.brand'） debug（$ brand_data）; 在这里我告诉它给我一个数组，其中键是 Product.brand ，值为 COUNT（Product.brand） 获取： 数组（ [品牌A] => [ B] => [品牌C] => ） 当我预期这个： 数组（ [品牌A] => 534 [Brand B] => 243 [Brand C] => 172 ） b $ b 它可以工作，如果我做所有而不是列表虽然，它只是给我一个更复杂的数组钻取。我很高兴使用全部，我只是想先看看是否有一个原因，它不工作列表？：find（'list'）在别名字段有问题（因此聚合函数如 COUNT（） / code>等），所以你应该使用CakePHP的1.3。对于CakePHP 1.2使用，有一个contraption 。 详细：最可能的问题在于您的 COUNT（`Product.brand`）AS brand_count c $ c> find（'list'） $ lst ['keyPath']，$ lst ['valuePath']，$ lst ['groupPath']） 对查询结果，其中 $ lst ['valuePath'] 将是 code>{n} .COUNT（`Product`.`brand`）AS brand_count {n} .Product.brand_count - 不排队。 尝试将您的COUNT（）设为虚拟字段。 Ie： // model var $ virtualFields = array（'brand_count'=>'COUNT（Product.brand）'）; // controller $ fields = array（'Product.brand'，'Product.brand_count'）; I know there are some similar quesiton like this on here but they are all about when using Model->find('all');But thats not what I am doing, I am doing:Model->find('list');Which is whats making the difference between this working and not working.Given a group of Products I want to find all the brands in that group and how many of each brand.Sounds simple enough, here is what I did:$fields = array('Product.brand','COUNT(`Product`.`brand`) AS brand_count')$brand_data = $this->Product->find('list',array( 'fields'=>$fields, 'conditions'=>$conditions, 'recursive'=>0, 'group' => 'Product.brand'));debug($brand_data);In this I am telling it to give me an array where the Keys are Product.brand and the values are COUNT(Product.brand)I am getting this:Array( [Brand A] => [Brand B] => [Brand C] => )When I am expected this:Array( [Brand A] => 534 [Brand B] => 243 [Brand C] => 172)It works if I do all instead of list though, it just gives me a much more complicated array to drill through. I am fine using all, I just first wanted to see if there was a reason why its not working in list? 解决方案 Brief recap: find('list') has problems with aliased fields (and therefore aggregate functions like COUNT() etc.), so you should use CakePHP's 1.3 instead. For CakePHP 1.2 uses there's a contraption. Detailed:Most likely problem lies in your COUNT(`Product.brand`) AS brand_countBecause find('list') does Set::combine($results, $lst['keyPath'], $lst['valuePath'], $lst['groupPath']) on results of query, where $lst['valuePath'] would be"{n}.COUNT(`Product`.`brand`) AS brand_count"while in results it would be actually "{n}.Product.brand_count" - doesn't line up.Try making your COUNT() a virtual field.I.e.://modelvar $virtualFields = array( 'brand_count' => 'COUNT(Product.brand)');//controller$fields = array('Product.brand','Product.brand_count'); 这篇关于在列表中返回CakePHP GROUP和COUNT项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！