From 4855646fe9743b079a22494f798d8e4b87d1d893 Mon Sep 17 00:00:00 2001
From: Janusz Dobrowolski <janusz@frontaccounting.eu>
Date: Tue, 2 Feb 2010 16:35:59 +0000
Subject: [PATCH] Added memo search in journal inqury.

---
 CHANGELOG.txt                  | 4 ++++
 gl/inquiry/journal_inquiry.php | 4 ++++
 2 files changed, 8 insertions(+)

diff --git a/CHANGELOG.txt b/CHANGELOG.txt
index 818e7cde..1859d61b 100644
--- a/CHANGELOG.txt
+++ b/CHANGELOG.txt
@@ -19,6 +19,10 @@ Legend:
 ! -> Note
 $ -> Affected files
 
+02-Feb-2010 Chaitanya
++ Added memo search on journal inquires.
+$ /gl/inquiry/journal_inquiry.php
+
 ------------------------------- Release 2.2.5 ----------------------------------
 02-Feb-2010 Joe Hunt
 ! Release 2.2.5
diff --git a/gl/inquiry/journal_inquiry.php b/gl/inquiry/journal_inquiry.php
index a7fccfb9..308abd78 100644
--- 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');
 }
-- 
2.30.2