Re: COUNT between two Models

Check this link http://book.cakephp.org/view/1033/counterCache-Cache-your-count

On Jul 26, 8:07 am, saavedrajj <saavedr...@gmail.com> wrote:
> Hi everybody, I have 2 models: Restaurant and Zone
>
> app/models/restaurant.php
> <?php
> class Restaurante extends AppModel {
>
>         var $name = 'Restaurant';
>
>         var $belongsTo = array(
>                 'Zone' => array(
>                         'className' => 'Zone',
>                         'foreignKey' => 'zone_id'
>                 )
>
>         );
>
> }
>
> ?>
>
> app/models/zone.php
> <?php
> class Zone extends AppModel {
>         var $name = 'Zone';
>
>         var $hasMany = array(
>                 'Restaurant' => array(
>                         'className' => 'Restaurant',
>                         'foreignKey' => 'zone_id'
>                 )
>         );
>
> }
>
> ?>
>
> And I need to execute this query:
>
> SELECT restaurants.zone_id, zones.title, COUNT(restaurants.zone_id) AS
> zonecounter
> FROM restaurants, zones
> WHERE restaurants.sector_id = zones.id
> GROUP BY restaurants.sector_id
> ORDER BY zones.nombre ASC
>
> So, T wrote the next function at my Restaurant controller
>
> app/controllers/restaurant_controller.php
> <?php
> class RestaurantsController extends AppController {
>
> var $name = 'Restaurants';
> var $uses = array('Restaurants', 'Zones');
>
> function index() {
>         $this->set('zones', $this->Zone->Restaurant->find('all',
>             array(
>                 'fields' => array('Restaurant.zone_id',  'Zone.title',
> 'COUNT(Restaurant.zone_id) AS zonecounter'),
>                 'conditions' => array('Restaurant.city_id' => 4),
>                 'order' => array('Zone.title ASC'),
>                 'group' => array('Restaurant.zone_id')
>                 )
>
>             )
>         );}
>
> ?>
>
> *PS: At 'conditions' I need a value for Restaurant.city_id, because
> I'm using this function for more cities.
>
> Then, in my index view, to show the results that I have
>
> app/views/restaurants/index.ctp
>
> <div>
> <h2>Zones</h2>
> <ul>
> <?php foreach ($zones as $zone): ?>
> <li><?php echo $html->link($zone['Zone']['title'], '#');?></li>
> <?php endforeach; ?>
> </ul>
> </div>
>
> It shows me something like
>
> Ex:
> Zones
> - Zone 1
> - Zone 2
> - zone 3
> - Zone 4
>
> Shows me only the zones where are restaurants. Cool.
>
> But also I need to show the value of "zonecounter" in order to
> display  how many restaurants are in every zone:
>
> Ex:
> Zones
> - Zone 1 (22)
> - Zone 2 (31)
> - zone 3 (16)
> - Zone 4 (24)
>
> Some ideas?

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en