Added memo search in journal inqury.

[fa-stable.git] / gl / inquiry / journal_inquiry.php

diff --git a/gl/inquiry/journal_inquiry.php b/gl/inquiry/journal_inquiry.php
index a7fccfb9b6c86528fd9e9b5ede424f095f1af1de..308abd782ac9c9aad25e38518dff0bc3622c0ce0 100644 (file)
--- a/gl/inquiry/journal_inquiry.php
+++ b/gl/inquiry/journal_inquiry.php
@@ -43,6 +43,7 @@ start_table("class='tablestyle_noborder'");
 start_row();
 
 ref_cells(_("Reference:"), 'Ref', '',null, _('Enter reference fragment or leave empty'));
+ref_cells(_("Memo:"), 'Memo', '',null, _('Enter memo fragment or leave empty'));
 
 journal_types_list_cells(_("Type:"), "filterType");
 date_cells(_("From:"), 'FromDate', '', null, 0, -1, 0);
@@ -175,6 +176,9 @@ $sql = "SELECT      IF(ISNULL(a.gl_seq),0,a.gl_seq) as gl_seq,
 if (isset($_POST['Ref']) && $_POST['Ref'] != "") {
        $sql .= " AND reference LIKE '%". $_POST['Ref'] . "%'";
 }
+if (isset($_POST['Memo']) && $_POST['Memo'] != "") {
+       $sql .= " AND com.memo_ LIKE '%". $_POST['Memo'] . "%'";
+}
 if (get_post('filterType') != -1) {
        $sql .= " AND gl.type=".get_post('filterType');
 }