/**
* Return payments by company
*
* @param Company $company
* @return array
*/
function findByCompany($company)
{
$invoices_table = TABLE_PREFIX . 'invoices';
$invoice_paymnets_table = TABLE_PREFIX . 'invoice_payments';
return InvoicePayments::findBySQL("SELECT {$invoice_paymnets_table}.* FROM {$invoices_table}, {$invoice_paymnets_table} WHERE {$invoice_paymnets_table}.invoice_id = {$invoices_table}.id AND {$invoices_table}.company_id = ? ORDER BY {$invoice_paymnets_table}.paid_on DESC", array($company->getId()));
}
