Add sort column to improve listing

diff --git a/abteilung.php b/abteilung.php
index 4035461..ee27287 100644 (file)
--- a/abteilung.php
+++ b/abteilung.php
@@ -8,9 +8,13 @@ $mask = array(
                                            'name' => 'ID',
                                            'visible' => false,
                                            ),
                                            'name' => 'ID',
                                            'visible' => false,
                                            ),

+                             'sort' => array(
+                                           'name' => 'Sort',
+                                           'width' => 50,
+                                           ),

                              'gang' => array(
                                            'name' => 'Gang',
                              'gang' => array(
                                            'name' => 'Gang',

-                                           'specs' => "filterUI: 't'",
+                                           'specs' => "filterUI: 't1'",

                                            'width' => 50,
                                            ),
                              'name' => array(
                                            'width' => 50,
                                            ),
                              'name' => array(


@@ -20,11 +24,17 @@ $mask = array(
                                            ),
                              ),
              'edit' => array(
                                            ),
                              ),
              'edit' => array(

+                             'sort' => array(
+                                           'name' => 'Sortierung',
+                                           'type' => 'text',
+                                           'size' => 5,
+                                           'null' => true,
+                                           ),

                              'gang' => array(
                                            'name' => 'Gang',
                                            'type' => 'text',
                              'gang' => array(
                                            'name' => 'Gang',
                                            'type' => 'text',

-                                           'size' => 10,
-                                           'null' => true,
+                                           'size' => 5,
+                                           'required' => true,

                                            ),
                              'name' => array(
                                            'name' => 'Name',
                                            ),
                              'name' => array(
                                            'name' => 'Name',

diff --git a/utils.php b/utils.php
index 45b1c93..8e53ad0 100644 (file)
--- a/utils.php
+++ b/utils.php
@@ -159,7 +159,7 @@ function ordersatz_write($id, $dir, $send)
                 "JOIN metro_abteilung ON abteilung = metro_abteilung.id " .
                 "JOIN metro_vpe ON vpe = metro_vpe.id " .
                 "WHERE ordersatz = %d AND anzahl IS NOT NULL " .
                 "JOIN metro_abteilung ON abteilung = metro_abteilung.id " .
                 "JOIN metro_vpe ON vpe = metro_vpe.id " .
                 "WHERE ordersatz = %d AND anzahl IS NOT NULL " .

-                "ORDER BY gang,metro_abteilung.name,bezeichnung",
+                "ORDER BY sort,gang,metro_abteilung.name,bezeichnung",

                 $id);
 
   $result = query_db($sql);
                 $id);
 
   $result = query_db($sql);