/** * 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())); }