[Fmsystem-commits] [17063] property: sql-filter on poject_id, cast as text

[sigurdne]

Revision: 17063
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=17063
Author:   sigurdne
Date:     2017-09-12 05:30:01 -0400 (Tue, 12 Sep 2017)
Log Message:
-----------
property: sql-filter on poject_id, cast as text

Modified Paths:
--------------
    trunk/property/inc/class.soproject.inc.php

Modified: trunk/property/inc/class.soproject.inc.php
===================================================================
--- trunk/property/inc/class.soproject.inc.php  2017-09-12 09:05:07 UTC (rev 
17062)
+++ trunk/property/inc/class.soproject.inc.php  2017-09-12 09:30:01 UTC (rev 
17063)
@@ -657,16 +657,26 @@
                                        }
                                        else
                                        {
-                                               if ($criteria[0]['type'] == int)
+                                               if ($criteria[0]['type'] == 
'int')
                                                {
                                                        $_query = (int)$query;
+
+                                                       
if($criteria[0]['matchtype'] == 'like')
+                                                       {
+                                                               // as text
+                                                               $querymethod = 
"{$where} cast({$criteria[0]['field']} as text) 
{$matchtypes[$criteria[0]['matchtype']]} 
{$criteria[0]['front']}{$_query}{$criteria[0]['back']}";
+                                                       }
+                                                       else
+                                                       {
+                                                               $querymethod = 
"{$where} {$criteria[0]['field']} {$matchtypes[$criteria[0]['matchtype']]} 
{$criteria[0]['front']}{$_query}{$criteria[0]['back']}";
+                                                       }
                                                }
                                                else
                                                {
                                                        $_query = $query;
+                                                       $querymethod = 
"{$where} {$criteria[0]['field']} {$matchtypes[$criteria[0]['matchtype']]} 
{$criteria[0]['front']}{$_query}{$criteria[0]['back']}";
                                                }
 
-                                               $querymethod = "{$where} 
{$criteria[0]['field']} {$matchtypes[$criteria[0]['matchtype']]} 
{$criteria[0]['front']}{$_query}{$criteria[0]['back']}";
                                        }
                                }
                        }