/**
* Callback function that filters collection by field "Used" from grid
*
* @param AbstractCollection $collection
* @param Column $column
* @return void
*/
public function addIsUsedFilterCallback($collection, $column)
{
$filterValue = $column->getFilter()->getCondition();
$expression = $this->getConnection()->getCheckSql('main_table.times_used > 0', 1, 0);
$conditionSql = $this->_getConditionSql($expression, $filterValue);
$collection->getSelect()->where($conditionSql);
}
public function testGetAllIdsWithBind()
{
$this->_model->getSelect()->where('code = :code');
$this->_model->addBindParam('code', 'admin');
$this->assertEquals(['0'], $this->_model->getAllIds());
}
/**
* Add filter by specified recurring payment id(s)
*
* @param \Magento\Framework\Model\Resource\Db\Collection\AbstractCollection $collection
* @param array|int $ids
* @return \Magento\Sales\Model\Resource\Order\Collection
*/
public function byIds($collection, $ids)
{
$ids = is_array($ids) ? $ids : array($ids);
$collection->getSelect()->joinInner(array('rpo' => $collection->getTable('recurring_payment_order')), 'main_table.entity_id = rpo.order_id', array())->where('rpo.payment_id IN(?)', $ids);
return $collection;
}
