I have a table :
Table: user_points
Columns:
id int(11) AI PK 
point tinyint(4) 
create_date datetime 
user_id int(11) 
post_id int(11) 
comment_id int(11) 
post_rating_id int(11) 
article_rating_id int(11)I would like to sum the points and write it out to the screen, with the user_name. The user_name come from the users table... I create 2 different query for this, and i got an interesting result. The 2 query is the following:
return \Baseapp\Models\UserPoints::find(array('columns'=>'*, sum(point) AS sumatory', 'conditions'=>'create_date >= :date_from: AND create_date <= :date_to:', 'bind'=>array('date_from'=>$this->date_from,'date_to'=>$this->date_to), 'group'=>'user_id', 'order'=>'sumatory DESC', 'limit'=>20));
return $this->getDi()->get('modelsManager')->createQuery('SELECT *,sum(point) AS sumatory FROM \Baseapp\Models\UserPoints WHERE create_date >= :date_from: AND create_date <= :date_to: GROUP BY user_id ORDER BY sumatory DESC LIMIT 20')->execute(array('date_from'=>$this->date_from,'date_to'=>$this->date_to));After this, the resultset is the so annoying for me:
Object Phalcon\Mvc\Model\Row (
  ->article_rating_id = Object Baseapp\Models\UserPoints extends Baseapp\Models\BaseModel (
    ->id = Numeric string (1) "1"
    ->point = Numeric string (1) "2"
    ->create_date = String (19) "2014-09-22 12:15:29"
    ->user_id = Numeric string (1) "1"
    ->post_id = NULL
    ->comment_id = NULL
    ->post_rating_id = Numeric string (2) "17"
    ->article_rating_id = NULL
    Baseapp\Models\UserPoints methods: 65 (
      ->initialize(); 
.....
->sumatory = Numeric string (2) "23"
  Phalcon\Mvc\Model\Row methods: 7 (
    ->setDirtyState();
    ->offsetExists();
    ->offsetGet();
    ->offsetSet();
    ->offsetUnset();
    ->toArray();
    ->count();
  )
)You can see that, the last table field is got the full Model object, why the last filed, why not the model model name?