Having in Yii

Yii 1.1 General Discussion
1

I want to write distance query,

Lat and Lng value in one table, and i am showing details in another table,

In Relation i wrote,

‘offermerchant’ => array(self::HAS_MANY, ‘Merchant’, ‘uid’,

            'condition'=>' ( 3959 * acos( cos( radians(-3.58) ) * cos( radians( offermerchant.city_lat ) ) * cos( radians( offermerchant.city_lng ) - radians(55.466646) ) + sin( radians(-3.52) ) * sin( radians( offermerchant.city_lat ) ) ) ) As distance'),


    );

In My controller,

$criteria->with = array(‘offermerchant’);

$criteria->having = ‘offermerchant.distance < 4’;

$criteria->addCondition(“to_date>=’{$dates}’”);

$offerdet = Offers::model()->findAll($criteria);

Not working why?

2

try this


$offerdet = Offers::model()->with('offermerchant')->findAll(array('condition' => "to_date >= $dates", 'having' => 'offermerchant.distance < 4'));

http://www.yiiframework.com/wiki/527/relational-query-lazy-loading-and-eager-loading-with-and-together/