public function GetLiquidacionesBySupplierId(Gyuser_Model_Liquidaciones $obj)
{
$table = $this->getDbTable();
$select = $table->select();
$select->from($table, array('id', 'date', 'current_account_balance', 'amount_payed', 'previous_account_balance', 'committed', 'checks_qty', 'average_days', 'total_bruto', 'impuesto_al_cheque_amt', 'intereses', 'gastos_interior', 'gastos_general', 'gastos_interior_fee', 'gastos_general_fee', 'gastos_varios', 'total_neto', 'impuesto_al_cheque', 'tasa_anual', 'acreditacion_capital', 'acreditacion_interior'));
$select->where('status = ?', true);
$select->where('credit_provider_id = ?', $obj->getCredit_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->setCurrent_account_balance($row->current_account_balance);
$entry->setAmount_payed($row->amount_payed);
$entry->setPrevious_account_balance($row->previous_account_balance);
$entry->setCommitted($row->committed);
$entry->setChecks_qty($row->checks_qty);
$entry->setAverage_days($row->average_days);
$entry->setTotal_bruto($row->total_bruto);
$entry->setImpuesto_al_cheque_amt($row->impuesto_al_cheque_amt);
$entry->setIntereses($row->intereses);
$entry->setGastos_interior($row->gastos_interior);
$entry->setGastos_general($row->gastos_general);
$entry->setGastos_interior_fee($row->gastos_interior_fee);
$entry->setGastos_general_fee($row->gastos_general_fee);
$entry->setGastos_varios($row->gastos_varios);
$entry->setTotal_neto($row->total_neto);
$entry->setImpuesto_al_cheque($row->impuesto_al_cheque);
$entry->setTasa_anual($row->tasa_anual);
$entry->setAcreditacion_capital($row->acreditacion_capital);
$entry->setAcreditacion_interior($row->acreditacion_interior);
$entries[] = $entry;
}
return $entries;
}
