OK, first this is getting way beyond my knowledge of how Cake
internals work, but it appears that Cake is doing the hasOne
separately from the hasMany relationships.
I would suggest you talk to the guys on the IRC channel (#cakephp), as
there is usually at least one actual Cake contributor monitoring the
group.
As a work around, you could try making your condition self contained,
by creating a query that encapsulates the condition. So for instance
your $filter could be:
'conditions' => array(
'((select count(1) from ad_images ad1 where ad1.url = ?
and ad1.advert_id = Advert.id) > 0)' => 'test.jpg'
)
This uses a correlated sub-query which counts the number of matching
url values, and passes if there are any. I've used this before in my
code, so I know it works (although I'm sure it's not the 'right' way
to do this.
On Dec 18, 3:12 am, dev <[email protected]> wrote:
> Still tables with hasMany relationships not working.
>
> Advert model:
>
> var $hasMany = array(
> 'AdImage' => array(
> 'className' => 'AdImage',
> 'foreignKey' => 'advert_id',
> 'conditions' => '',
> 'order' => '',
> 'limit' => '5',
> 'dependent'=> true
> ),
> 'AdvertComfort' => array(
> 'className' => 'AdvertComfort',
> 'foreignKey' => 'advert_id',
> 'conditions' => '',
> 'order' => '',
> 'limit' => '5',
> 'dependent'=> true
> ));
>
> AdImage (same AdvertComfort) model:
>
> var $belongsTo = array(
> 'Advert' => array('className' => 'Advert',
> 'foreignKey' => 'advert_id',
> 'conditions' => '',
> 'fields' => '',
> 'order' => ''
> ));
>
> find function:
>
> $filter = array(
> 'conditions' => array(
> 'AdImage.url' => 'test.jpg'
> ),
> 'recursive' => 2
> );
> $rez = $this->Advert->find('all', $filter);
>
> SQL:
>
> SELECT `Advert`.`id`, `Advert`.`user_id`, `Advert`.`ad_category_id`,
> `Advert`.`code`, `Advert`.`valid`, `Advert`.`bad`, `Advert`.`created`,
> `AdCategory`.`id`, `AdCategory`.`alias`, `AdCategory`.`name`,
> `AdsAuto`.`id`, `AdsAuto`.`advert_id`, `AdsAuto`.`ad_manufacturer_id`,
> `AdsAuto`.`ad_model_id`, `AdsAuto`.`ad_type_id`, `AdsAuto`.`year`,
> `AdsAuto`.`ad_fueltype_id`, `AdsAuto`.`ad_door_id`,
> `AdsAuto`.`ad_colour_id`, `AdsAuto`.`capacity`, `AdsAuto`.`cilinders`,
> `AdsAuto`.`power`, `AdsAuto`.`ad_gearbox_id`, `AdsAuto`.`gears`,
> `AdsAuto`.`pricein`, `AdsAuto`.`priceout`, `AdsAuto`.`ta`,
> `AdsAuto`.`milage`, `AdsAuto`.`comment`, `AdsAuto`.`name`,
> `AdsAuto`.`phone`, `AdsAuto`.`email`, `AdsAuto`.`ad_country_id`,
> `AdsAuto`.`ad_city_id` FROM `adverts` AS `Advert` LEFT JOIN
> `ad_categories` AS `AdCategory` ON (`Advert`.`ad_category_id` =
> `AdCategory`.`id`) LEFT JOIN `ads_autos` AS `AdsAuto` ON
> (`AdsAuto`.`advert_id` = `Advert`.`id`) WHERE `AdImage`.`url` =
> 'test.jpg'
>
> Error message:
>
> SQL Error: 1054: Unknown column 'AdImage.url' in 'where clause'
>
> AdImage (and AdvertComfort too) table don't join..
>
> On Dec 17, 7:21 pm, Rob <[email protected]> wrote:
>
> > The joins are automatically done for you if your models have the
> > correct relationships defined.
>
> > You'd need to define your hasMany relationships, and their
> > corresponding belongsTo in your models.
>
> > In your Advert model:
>
> > // Link to signup slots and user groups ...
> > var $hasMany = array(
> > 'AdImage' => array(
> > 'className' => 'AdImage',
> > 'foreignKey' => 'advert_id',
> > 'limit' => '5',
> > 'dependent' => true
> > ),
> > 'AdvertComfort' => array(
> > 'className' => 'AdvertComfort',
> > 'foreignKey' => 'advert_id',
> > 'limit' => '5',
> > 'dependent' => true
> > )
> > );
>
> > var $hasOne = array(
> > 'AdsAuto' => array(
> > 'className' => 'AdsAuto'
> > 'foreignKey' => 'advert_id',
> > 'dependent' => true
>
> > );
>
> > Then in your other models, you need the corresponding belongsTo back
> > to Advert:
>
> > var $belongsTo = array('Advert');
>
> > Then when you do your queries, you should get the associated data (the
> > hasMany sets the foreign key for the find, so all you need to add are
> > your conditions).
>
> > If your relationships get more complex, you may need to muck with
> > $recursive:http://book.cakephp.org/view/439/recursive
>
> > On Dec 16, 11:49 pm, dev <[email protected]> wrote:
>
> > > Yes, find conditions not a big problem, but how to join table with
> > > hasMany association (AdImage, and AdvertComfort)? After that, i coud
> > > set conditions
>
> > > On Dec 15, 9:46 pm, Rob <[email protected]> wrote:
>
> > > > You shouldn't have any trouble doing this if you build your models
> > > > correctly and choose the right conditions in your find statement in
> > > > the controller.
>
> > > > I personally tend to do this by building the SQL query that works, and
> > > > then back coding the conditions into the controller (although I'm sure
> > > > there are lots of ways to come up with the same thing.
>
> > > > I would think you'd have something like the following (untested
> > > > obviously):
>
> > > > $adverts = $this->Advert->find('all', 'conditions' => array( 'AND' =>
> > > > array(
> > > > 'AdsAuto.year BETWEEN ? AND ?' => array($date1,
> > > > $date2),
> > > > '(select count(1) from ad_images AdImage where
> > > > AdImage.advert_id = Advert.id > 0)',
> > > > 'AdvertComfort.option_id' => array(1,7,8)
> > > > );
>
> > > > On Dec 14, 4:38 pm, dev <[email protected]> wrote:
>
> > > > > Hey,
>
> > > > > I'm trying to build find function for many days with no luck, please
> > > > > help me guys.
>
> > > > > Models:
>
> > > > > mysql> DESCRIBE adverts;
> > > > > +----------------+------------------------+------+-----+---------
> > > > > +----------------+
> > > > > | Field | Type | Null | Key | Default |
> > > > > Extra |
> > > > > +----------------+------------------------+------+-----+---------
> > > > > +----------------+
> > > > > | id
> > > > > | user_id
> > > > > | ad_category_id
> > > > > | code
> > > > > | valid
> > > > > | bad
> > > > > | created
> > > > > +----------------+------------------------+------+-----+---------
> > > > > +----------------+
>
> > > > > mysql> DESCRIBE ads_autos;
> > > > > +--------------------+------------------+------+-----+---------
> > > > > +----------------+
> > > > > | Field | Type | Null | Key | Default |
> > > > > Extra |
> > > > > +--------------------+------------------+------+-----+---------
> > > > > +----------------+
> > > > > | id
> > > > > | advert_id
> > > > > | ad_manufacturer_id
> > > > > | ad_model_id
> > > > > | ad_type_id
> > > > > | year
> > > > > | ad_fueltype_id
> > > > > | ad_door_id
> > > > > | ad_colour_id
> > > > > | capacity
> > > > > | cilinders
> > > > > | power
> > > > > | ad_gearbox_id
> > > > > | gears
> > > > > | pricein
> > > > > | priceout
> > > > > | ta
> > > > > | milage
> > > > > | comment
> > > > > | name
> > > > > | phone
> > > > > | email
> > > > > | ad_country_id
> > > > > | ad_city_id
> > > > > +--------------------+------------------+------+-----+---------
> > > > > +----------------+
>
> > > > > mysql> DESCRIBE ad_images;
> > > > > +-----------+------------------+------+-----+---------+----------------
> > > > > +
> > > > > | Field | Type | Null | Key | Default | Extra
> > > > > |
> > > > > +-----------+------------------+------+-----+---------+----------------
> > > > > +
> > > > > | id
> > > > > | advert_id
> > > > > | url
> > > > > | created
> > > > > +-----------+------------------+------+-----+---------+----------------
> > > > > +
>
> > > > > mysql> DESCRIBE advert_comfort;
> > > > > +-----------+------------------+------+-----+---------+----------------
> > > > > +
> > > > > | Field | Type | Null | Key | Default | Extra
> > > > > |
> > > > > +-----------+------------------+------+-----+---------+----------------
> > > > > +
> > > > > | id
> > > > > | advert_id
> > > > > | option_id
> > > > > +-----------+------------------+------+-----+---------+----------------
> > > > > +
>
> > > > > Models and associations:
>
> > > > > Advert hasMany AdImage
> > > > > Advert hasMany AdvertComfort
> > > > > Advert hasOne AdsAuto
>
> > > > > I need find function, when there are such conditions, for example:
>
> > > > > AdsAuto.year from .. to ..
> > > > > AdvertComfort.option_id is 1,7,8 ...
> > > > > and Advert has at least one AdImage (photo)
>
> > > > > I tried many ways with Containable, INNER JOIN but with no luck. I
> > > > > can't get all these conditions in one query, but i need to get Advert
> > > > > model results if only all conditions are true.
>
> > > > > P.S. sorry for my bad english
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
