public function GetLiquidacionesByProvId($provider_id)
{
$table = $this->getDbTable();
$select = $table->select();
$select->from($table, array('id', 'date', 'previous_account_balance', 'amount_debt', 'acreditacion', 'amount_payed', 'current_account_balance', 'committed'));
$select->where('status = ?', true);
$select->where('provider_id = ?', $provider_id);
$select->order('date DESC');
$resultSet = $table->fetchAll($select);
$entries = array();
foreach ($resultSet as $row) {
$entry = new Gyuser_Model_Liquidaciones();
$entry->setId($row->id);
$entry->setDate(date("d/m/Y", strtotime($row->date)));
$entry->setPrevious_account_balance($row->previous_account_balance);
$entry->setAmount_debt($row->amount_debt);
$entry->setAcreditacion($row->acreditacion);
$entry->setAmount_payed($row->amount_payed);
$entry->setCurrent_account_balance($row->current_account_balance);
$entry->setCommitted($row->committed);
$entries[] = $entry;
}
return $entries;
}
