clistview with advanced mysql query

Yii 1.1 General Discussion
1

Hi there!

My problem which i cannot find:

I have an advanced cdbcriteria which I pass to a cactivedataprovider, which is passed to a CListview

it’ a mysql query which calculates the distance between 2 lat/lng-points.

this is my code:


$criteria->select = '*, ( 3959 * acos( cos( radians(' . $model->latitude . ') ) 

		* cos( radians( latitude ) ) * cos( radians( longitude ) - 

		radians(' . $model->longitude . ') ) + sin( radians(' . $model->latitude . ') ) 

		* sin( radians( latitude ) ) ) ) * 1.609344 AS distance'; 

		$criteria->order = 'distance desc';

		$criteria->condition = 'city_id='.$id.'';

			

		$dataProvider=new CActiveDataProvider('Place', array(

		    'criteria'=>$criteria,

		));

How can i echo this "distance" field into my _view file? Plus, can I make this a sortable attribute (via AJAX)?

This is what I want for output:

Place Name // Distance From Brussels

Antwerp // 56km

Bruges // 120km

… // …

Thanks a lot people!

2

Just declare distance as a public member and you should be able to access it.

/Tommy

3

Declare a public property named distance in your medel

Public $distance

Now you can echo the calculated distance property as you do any other property

4

thanks!

Perfect answers of you guys :)