Phalcon DB Criteria in Model ORM

Question

In Phalcon model is there a way to use SQL "IN" condition and other database criteria? For example, i want to execute this query in phalcon

SELECT user_fullname, user_email FROM tbl_users WHERE user_id IN (1,2,3,4,5)

I know you can use query builder but I want it to be ORM. I want a method in my model getUsersByIds($userIds, $columnsToSelect) that will accept an array of userids and columns that you want to fetch in the table.

See my model below

<?php

use Phalcon\Mvc\Model;

class User extends Model
{
/**
 *
 * @var integer
 */
public $user_id;

/**
 *
 * @var string
 */
public $user_email;

/**
 *
 * @var string
*/

public user_phone;
/**
 *
 * @var string
*/
public user_fullname;

public function initialize()
{    $this->hasMany('user_id','Store\Bag','user_id');
}
public function getSource()
{
    return "tbl_user";
}

public function find($parameters = null)
{
    return parent::find($parameters);
}

public function findFirst($parameters = null)
{
    return parent::findFirst($parameters);
}
/**
* I want to execute this query in my model
*  SELECT user_fullname,user_email from tbl_user where user_id IN (1,2,3,4,5);
*/
 public function getUsersByIds($ids=array(), $columns=array())
 {
    if(!is_array($ids))
        $ids = array($ids);
    if(!is_array($columns))
        $columns = array($columns); 

     ...................................
     .........................
      ..............
 }  
}

Answer 1

There are two ways of doing this:

Method 1: inWhere('columnName', array('columnValues'))

public function getUsersByIds(array $userIds, $columnsToSelect = '') {
    return self::query()
    ->inWhere('id', $userIds)
    ->columns($columnsToSelect ?: '*')
    ->execute();
}

This one goes in your User model

---

Method 2: conditions => 'id IN ({ids:array})

User::find(['id IN ({ids:array})', 
             'columns' => $columnsToSelect,
             'bind' => array('ids' => $userIds)]);

I am typing on my mobile, so there might be a typo in there.