[Fmsystem-commits] [16278] property: fix sql condition

[sigurdne]

Revision: 16278
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=16278
Author:   sigurdne
Date:     2017-02-08 06:18:39 -0500 (Wed, 08 Feb 2017)
Log Message:
-----------
property: fix sql condition

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

Modified: trunk/property/inc/class.soworkorder.inc.php
===================================================================
--- trunk/property/inc/class.soworkorder.inc.php        2017-02-08 10:17:48 UTC 
(rev 16277)
+++ trunk/property/inc/class.soworkorder.inc.php        2017-02-08 11:18:39 UTC 
(rev 16278)
@@ -767,11 +767,11 @@
                                                {
                                                        $_query = (int)$query;
                                                }
-                                               else if ($criteria[0]['type'] 
== 'bigint' &&  $field_info['matchtype'] == 'like')
+                                               else if ($criteria[0]['type'] 
== 'bigint' &&  $criteria[0]['matchtype'] == 'like')
                                                {
                                                        $_query = $query;
-                                                       $_querymethod[] = " 
cast({$field_info['field']} as text) {$matchtypes[$field_info['matchtype']]} 
{$field_info['front']}{$_query}{$field_info['back']}";
-                                                       $_query = 0;
+
+                                                       $criteria[0]['field'] = 
"cast({$criteria[0]['field']} as text)";
                                                }
                                                else if ($criteria[0]['type'] 
== 'bigint' &&  $field_info['matchtype'] != 'like')
                                                {