show invoices list only by comment

General discussions related to Logic Invoice. The place for you if you cannot find a suitable place for your post.
Post Reply
Posts: 2
Joined: Sat Feb 11, 2017 7:12 pm

show invoices list only by comment

Post by zeroattck » Sat Feb 11, 2017 7:16 pm

Hi , i tried to customize logic invoice with some queies to show only invoices with specific comment , as below in invoice module

Code: Select all

    public function getInvoices($data = array()) {
        $sql = "SELECT *, CONCAT(firstname, ' ', lastname) AS name, (SELECT name FROM " . DB_PREFIX . "status s WHERE s.status_id = i.status_id AND s.language_id = '" . (int)$this->config->get('config_language_id') . "') AS status FROM " . DB_PREFIX . "invoice i WHERE comment='good'";
the problem is that when you type search by invoice id there is no thing to show .
the current module name is / billing/invoice.php


User avatar
Site Admin
Posts: 303
Joined: Tue Sep 15, 2015 3:08 pm
Location: Singapore

Re: show invoices list only by comment

Post by Esmond » Sun Feb 12, 2017 9:51 am

I'm not sure if I get what you require. Do you want to modify the admin or the customer's end?

Post Reply