order search with invoice number opencart 3x

Hello Everyone, I want search order with invoice number, codes converted from vqmode to ocmod, I tried but not working , help me if possible, thank you.

here is code -

<file path="admin/controller/sale/order.php">
<operation>
<search trim="true" index="1,2,3,5,6,7,8,9"><![CDATA[if (isset($this->request->get['filter_customer'])) {]]></search>
<add position="before"><![CDATA[if (isset($this->request->get['filter_invoice_no'])) {
$url .= '&filter_invoice_no=' . $this->request->get['filter_invoice_no'];
}]]></add>
</operation>
<operation>
<search trim="true" index="1,2,3,5,6,7,8,9"><![CDATA[if (isset($this->request->get['filter_customer'])) {]]></search>
<add position="before"><![CDATA[if (isset($this->request->get['filter_invoice_prefix'])) {
$url .= '&filter_invoice_prefix=' . $this->request->get['filter_invoice_prefix'];
}]]></add>
</operation>

<operation>
<search trim="true" offset="2"><![CDATA[$filter_order_id = '';]]></search>
<add position="after"><![CDATA[if (isset($this->request->get['filter_invoice_no'])) {
$filter_invoice_no = $this->request->get['filter_invoice_no'];
} else {
$filter_invoice_no = null;
}]]></add>
</operation>
<operation>
<search trim="true" offset="2"><![CDATA[$filter_order_id = '';]]></search>
<add position="after"><![CDATA[if (isset($this->request->get['filter_invoice_prefix'])) {
$filter_invoice_prefix = $this->request->get['filter_invoice_prefix'];
} else {
$filter_invoice_prefix = null;
}]]></add>
</operation>

<operation>
<search trim="true" ><![CDATA['filter_order_id' => $filter_order_id,]]></search>
<add position="after"><![CDATA['filter_invoice_no' => $filter_invoice_prefix.$filter_invoice_no,]]></add>
</operation>

<operation>
<search trim="true"><![CDATA['order_id' => $result['order_id'],]]></search>
<add position="after"><![CDATA[
'invoice_no' => $result['invoice_no'],
'invoice_prefix' => $result['invoice_prefix'],
]]></add>
</operation>

<operation>
<search trim="true"><![CDATA[$data['text_order'] = sprintf($this->language->get('text_order'), $order_id);]]></search>
<add position="after"><![CDATA[$data['text_invoice_no'] = sprintf($this->language->get('text_invoice_no'), $invoice_no);]]></add>
</operation>

<operation>
<search trim="true"><![CDATA[$data['sort_order'] = $this->url->link('sale/order', 'user_token=' . $this->session->data['user_token'] . '&sort=o.order_id' . $url, true);]]></search>
<add position="after"><![CDATA[$data['sort_invoice_no'] = $this->url->link('sale/order', 'user_token=' . $this->session->data['user_token'] . '&sort=o.invoice_no' . $url, true);]]></add>
</operation>

<operation>
<search trim="true"><![CDATA[$data['filter_order_id'] = $filter_order_id;]]></search>
<add position="after"><![CDATA[$data['filter_invoice_no'] = $filter_invoice_no;]]></add>
</operation>
<operation>
<search trim="true"><![CDATA[$data['filter_order_id'] = $filter_order_id;]]></search>
<add position="after"><![CDATA[$data['filter_invoice_prefix'] = $filter_invoice_prefix;]]></add>
</operation>

<!--replace above code with code below?-->
<!--<operation error="log">
<search position="after"><![CDATA[$this->data['filter_order_id'] = $filter_order_id;]]></search>
<add><![CDATA[$this->data['filter_invoice_no'] = $filter_invoice_prefix.$filter_invoice_no;]]></add>
</operation>-->
</file>

<file path="admin/model/sale/order.php">

<operation>
<search trim="true"><![CDATA['invoice_no' => $order_query->row['invoice_no'],]]></search>
<add position="after"><![CDATA['invoice_no_clean' => $order_query->row['invoice_no'],]]></add>
</operation>

<operation>
<search trim="true"><![CDATA[$sql = "SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.name FROM " . DB_PREFIX . "order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '" . (int)$this->config->get('config_language_id') . "') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `" . DB_PREFIX . "order` o";]]></search>
<add position="replace"><![CDATA[$sql = "SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.name FROM " . DB_PREFIX . "order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '" . (int)$this->config->get('config_language_id') . "') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified, o.invoice_no, o.invoice_prefix FROM `" . DB_PREFIX . "order` o";]]></add>
</operation>


<operation>
<search trim="true" offset="2"><![CDATA[$sql .= " WHERE o.order_status_id > '0'";]]></search>
<add position="after"><![CDATA[if (!empty($data['filter_invoice_no'])) {
$sql .= " AND o.invoice_no = '" . (int)$data['filter_invoice_no'] . "'";
}
if (!empty($data['filter_invoice_prefix'])) {
$sql .= " AND o.invoice_prefix = '" . (int)$data['filter_invoice_prefix'] . "'";
}]]></add>
</operation>
<operation>
<search trim="true" offset="2"><![CDATA[$sql .= " AND order_id = '" . (int)$data['filter_order_id'] . "'";]]></search>
<add position="before"><![CDATA[if (!empty($data['filter_invoice_no'])) {
$sql .= " AND invoice_no = '" . (int)$data['filter_invoice_no'] . "'";
}
if (!empty($data['filter_invoice_prefix'])) {
$sql .= " AND invoice_prefix = '" . (int)$data['filter_invoice_prefix'] . "'";
}]]></add>
</operation>
<operation>
<search trim="true"><![CDATA['o.order_id',]]></search>
<add position="after"><![CDATA['o.invoice_no',]]></add>
</operation>
<operation>
<search trim="true"><![CDATA['o.order_id',]]></search>
<add position="after"><![CDATA['o.invoice_prefix',]]></add>
</operation>
</file>

<file path="admin/view/template/sale/order_list.twig">
<operation>
<search index="0"><![CDATA[<div class="panel-body">]]></search>
<add position="after"><![CDATA[
<div class="form-group">
<label class="control-label" for="input-invoice_no">Invoice Number</label>
<input type="text" name="filter_invoice_no" value="{{ filter_invoice_no }}" placeholder="Invoice Number" id="input-invoice_no" class="form-control" />
</div>
]]></add>
</operation>

<operation>
<search><![CDATA[var filter_order_id = $('input[name=\'filter_order_id\']').val();]]></search>
<add position="before"><![CDATA[
var filter_invoice_no = $('input[name=\'filter_invoice_no\']').val();

if (filter_invoice_no) {
url += '&filter_invoice_no=' + encodeURIComponent(filter_invoice_no);
}
]]></add>
</operation>
<operation>
<search><![CDATA[<td class="text-right">{% if sort == 'o.order_id' %} <a href="{{ sort_order }}" class="{{ order|lower }}">{{ column_order_id }}</a> {% else %} <a href="{{ sort_order }}">{{ column_order_id }}</a> {% endif %}</td>]]></search>
<add position="before"><![CDATA[<td class="text-right">{% if sort == 'o.invoice.no' %} <a href="{{ sort_invoice_no }}" class="{{ order|lower }}">{{ column_invoice_no }}</a> {% else %} <a href="{{ sort_invoice_no }}">{{ column_Invoice_no }}</a> {% endif %}</td>]]></add>
</operation>

</file>
-----------------------------------------------------------------------------------------
After search no result, filter reset also gettin this error

Notice: Undefined variable: url in C:\wamp64\storage\modification\admin\controller\sale\order.php on line 105

hey, i am opencart expert & i can fix it for you contact us on skype.

ocguru wrote: ↑

Sat Dec 02, 2023 4:36 pm

hey, i am opencart expert & i can fix it for you contact us on skype.

You should read properly, I am asking for suggestions if possible otherwise paid invoice filter is already available on opencart market, I can buy from there without waste my time on skype mr. expert.

tangocharli wrote: ↑

Sun Dec 03, 2023 1:05 pm

You should read properly, I am asking for suggestions if possible otherwise paid invoice filter is already available on opencart market, I can buy from there without waste my time on skype mr. expert.

Not possible mr.newbie

I think it fails because you use different variable: filter_invoice_no, filter_invoice_prefix.

ocguru wrote: ↑

Mon Dec 04, 2023 1:53 pm

tangocharli wrote: ↑

Sun Dec 03, 2023 1:05 pm

You should read properly, I am asking for suggestions if possible otherwise paid invoice filter is already available on opencart market, I can buy from there without waste my time on skype mr. expert.

Not possible mr.newbie

I know not possible for you this is the reason I told indirectly do not insert your nose mr. expert.

garidinh wrote: ↑

Mon Dec 04, 2023 3:31 pm

I think it fails because you use different variable: filter_invoice_no, filter_invoice_prefix.

different variable?