[Fmsystem-commits] [15166] property: datatype in sql

[sigurdne]

Revision: 15166
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=15166
Author:   sigurdne
Date:     2016-05-14 09:41:13 +0000 (Sat, 14 May 2016)
Log Message:
-----------
property: datatype in sql

Modified Paths:
--------------
    trunk/property/inc/class.boproject.inc.php
    trunk/property/inc/class.boworkorder.inc.php
    trunk/property/inc/class.uiworkorder.inc.php

Modified: trunk/property/inc/class.boproject.inc.php
===================================================================
--- trunk/property/inc/class.boproject.inc.php  2016-05-14 09:40:42 UTC (rev 
15165)
+++ trunk/property/inc/class.boproject.inc.php  2016-05-14 09:41:13 UTC (rev 
15166)
@@ -386,10 +386,10 @@
                        $criteria[1] = array
                                (
                                'field' => 'external_project_id',
-                               'type' => 'int',
+                               'type' => 'varchar',
                                'matchtype' => 'exact',
-                               'front' => '',
-                               'back' => ''
+                               'front' => "'",
+                               'back' => "'"
                        );
                        $criteria[2] = array
                                (

Modified: trunk/property/inc/class.boworkorder.inc.php
===================================================================
--- trunk/property/inc/class.boworkorder.inc.php        2016-05-14 09:40:42 UTC 
(rev 15165)
+++ trunk/property/inc/class.boworkorder.inc.php        2016-05-14 09:41:13 UTC 
(rev 15166)
@@ -337,10 +337,10 @@
                        $criteria[1] = array
                                (
                                'field' => 'external_project_id',
-                               'type' => 'int',
+                               'type' => 'varchar',
                                'matchtype' => 'exact',
-                               'front' => '',
-                               'back' => ''
+                               'front' => "'",
+                               'back' => "'"
                        );
                        $criteria[2] = array
                                (

Modified: trunk/property/inc/class.uiworkorder.inc.php
===================================================================
--- trunk/property/inc/class.uiworkorder.inc.php        2016-05-14 09:40:42 UTC 
(rev 15165)
+++ trunk/property/inc/class.uiworkorder.inc.php        2016-05-14 09:41:13 UTC 
(rev 15166)
@@ -1992,7 +1992,7 @@
                                array(
                                        'key' => 'year',
                                        'label' => lang('year'),
-                                       'sortable' => false,
+                                       'sortable' => true,
                                        'className' => 'center',
                                        'value_footer' => lang('Sum')),
                                array(