In-Portal Issue Tracker

Index: units/admin/admin_events_handler.php
===================================================================
--- units/admin/admin_events_handler.php	(revision 13203)
+++ units/admin/admin_events_handler.php	(working copy)
@@ -295,6 +295,13 @@
 				$field_options['max_len'] = (int)$regs[1];
 			}
 
+			if (preg_match('/tinyint\([\d]+\)/i', $field_info['Type'])) {
+				$field_options['formatter'] = 'kOptionsFormatter';
+				$field_options['options'] = Array (1 => 'la_Yes', 0 => 'la_No');
+				$field_options['use_phrases'] = 1;
+				$grid_col_options['filter_block'] = 'grid_options_filter';
+			}
+
 			if ($field_info['Null'] != 'YES') {
 				$field_options['not_null'] = 1;
 			}
@@ -304,6 +311,14 @@
 				$id_field = $field_info['Field'];
 			}
 
+			if ($php_type == 'int' && !array_key_exists('not_null', $field_options)) {
+				// numeric null field
+				if (preg_match('/(On|Date)$/', $field_info['Field']) || $field_info['Field'] == 'Modified') {
+					$field_options['formatter'] = 'kDateFormatter';
+					$grid_col_options['filter_block'] = 'grid_date_rage_filter';
+				}
+			}
+
 			if ($php_type == 'int' && ($field_info['Null'] != 'YES' || is_numeric($default_value))) {
 				// is integer field AND not null
 				$field_options['default'] = (int)$default_value;