21 Apr
2010
21 Apr
'10
4:04 p.m.
The branch, master has been updated
via f984f0c888aab3a16831f521aef128e0c933e328 (commit)
via 68c7de61804c576b61c271413f50c86c88e54363 (commit)
from bd722f18e13afece75045cbf7801eb7154a419a2 (commit)
- Log -----------------------------------------------------------------
commit f984f0c888aab3a16831f521aef128e0c933e328
Author: Michal Čihař <mcihar(a)novell.com>
Date: Wed Apr 21 15:04:37 2010 +0200
Add seconds to time editor.
commit 68c7de61804c576b61c271413f50c86c88e54363
Author: Michal Čihař <mcihar(a)novell.com>
Date: Wed Apr 21 14:43:40 2010 +0200
Whitespace cleanup.
-----------------------------------------------------------------------
Summary of changes:
js/jquery/timepicker.js | 60 +++++++++++++++++++++++++++++++++++++++++-----
tbl_change.php | 18 +++++++-------
2 files changed, 62 insertions(+), 16 deletions(-)
diff --git a/js/jquery/timepicker.js b/js/jquery/timepicker.js
index 84879c4..492692d 100644
--- a/js/jquery/timepicker.js
+++ b/js/jquery/timepicker.js
@@ -22,6 +22,7 @@ $.extend($.datepicker._defaults, {
'dateFormat': 'yy-mm-dd',
'changeMonth': true,
'changeYear': true,
+ 'stepSeconds': 1, // Number of seconds to step up/down
'stepMinutes': 1, // Number of minutes to step up/down
'stepHours': 1, // Number of hours to step up/down
'time24h': false, // True if 24h time
@@ -186,9 +187,11 @@ Timepicker.prototype = {
this._orgValue = null;
this._orgHour = null;
this._orgMinute = null;
+ this._orgSecond = null;
this._colonPos = -1;
+ this._scolonPos = -1;
this._visible = false;
- this.tpDiv = $('<div id="' + this._mainDivId + '"
class="ui-datepicker ui-widget ui-widget-content ui-helper-clearfix ui-corner-all
ui-helper-hidden-accessible" style="width: 100px; display: none; position:
absolute;"></div>');
+ this.tpDiv = $('<div id="' + this._mainDivId + '"
class="ui-datepicker ui-widget ui-widget-content ui-helper-clearfix ui-corner-all
ui-helper-hidden-accessible" style="width: 170px; display: none; position:
absolute;"></div>');
this._generateHtml();
},
@@ -200,9 +203,11 @@ Timepicker.prototype = {
this._time24h = $.datepicker._get(inst, 'time24h');
this._altTimeField = $.datepicker._get(inst, 'altTimeField');
+ var stepSeconds = parseInt($.datepicker._get(inst, 'stepSeconds'), 10) ||
1;
var stepMinutes = parseInt($.datepicker._get(inst, 'stepMinutes'), 10) ||
1;
var stepHours = parseInt($.datepicker._get(inst, 'stepHours'), 10) ||
1;
+ if (60 % stepSeconds != 0) { stepSeconds = 1; }
if (60 % stepMinutes != 0) { stepMinutes = 1; }
if (24 % stepHours != 0) { stepHours = 1; }
@@ -212,6 +217,9 @@ Timepicker.prototype = {
$('#minuteSlider').slider('option', 'max', 60 -
stepMinutes);
$('#minuteSlider').slider('option', 'step',
stepMinutes);
+ $('#secondSlider').slider('option', 'max', 60 -
stepSeconds);
+ $('#secondSlider').slider('option', 'step',
stepSeconds);
+
this._inputId = input.id;
if (!this._visible) {
@@ -241,7 +249,10 @@ Timepicker.prototype = {
{
var curTime = $('#' + this._mainDivId + '
span.fragHours').text()
+ ':'
- + $('#' + this._mainDivId + '
span.fragMinutes').text();
+ + $('#' + this._mainDivId + '
span.fragMinutes').text()
+ + ':'
+ + $('#' + this._mainDivId + '
span.fragSeconds').text()
+ ;
if (!this._time24h) {
curTime += ' ' + $('#' + this._mainDivId + '
span.fragAmpm').text();
@@ -279,6 +290,7 @@ Timepicker.prototype = {
$('#hourSlider').css('height', this.tpDiv.height() - (3.5 *
hdrHeight));
$('#minuteSlider').css('height', this.tpDiv.height() - (3.5 *
hdrHeight));
+ $('#secondSlider').css('height', this.tpDiv.height() - (3.5 *
hdrHeight));
},
_generateHtml: function ()
@@ -287,9 +299,9 @@ Timepicker.prototype = {
html += '<div class="ui-datepicker-header ui-widget-header
ui-helper-clearfix ui-corner-all">';
html += '<div class="ui-datepicker-title"
style="margin:0">';
- html += '<span class="fragHours">08</span><span
class="delim">:</span><span
class="fragMinutes">45</span> <span
class="fragAmpm"></span></div></div><table>';
- html +=
'<tr><th>Hour</th><th>Minute</th></tr>';
- html += '<tr><td align="center"><div
id="hourSlider" class="slider"></div></td><td
align="center"><div id="minuteSlider"
class="slider"></div></td></tr>';
+ html += '<span class="fragHours">08</span><span
class="delim">:</span><span
class="fragMinutes">45</span>:</span><span
class="fragSeconds">45</span> <span
class="fragAmpm"></span></div></div><table>';
+ html +=
'<tr><th>Hour</th><th>Minute</th><th>Second</th></tr>';
+ html += '<tr><td align="center"><div
id="hourSlider" class="slider"></div></td><td
align="center"><div id="minuteSlider"
class="slider"></div></td><td
align="center"><div id="secondSlider"
class="slider"></div></td></tr>';
html += '</table>';
this.tpDiv.empty().append(html);
@@ -325,8 +337,23 @@ Timepicker.prototype = {
}
});
+ $('#secondSlider').slider({
+ orientation: "vertical",
+ range: 'min',
+ min: 0,
+ max: 59,
+ step: 1,
+ slide: function(event, ui) {
+ self._writeTime('second', ui.value);
+ },
+ stop: function(event, ui) {
+ $('#' + self._inputId).focus();
+ }
+ });
+
$('#hourSlider > a').css('padding', 0);
$('#minuteSlider > a').css('padding', 0);
+ $('#secondSlider > a').css('padding', 0);
},
_writeTime: function (type, value)
@@ -353,6 +380,11 @@ Timepicker.prototype = {
if (value < 10) value = '0' + value;
$('#' + this._mainDivId + ' span.fragMinutes').text(value);
}
+
+ if (type == 'second') {
+ if (value < 10) value = '0' + value;
+ $('#' + this._mainDivId + ' span.fragSeconds').text(value);
+ }
},
_parseTime: function ()
@@ -361,12 +393,19 @@ Timepicker.prototype = {
this._colonPos = dt.search(':');
- var m = 0, h = 0, a = '';
+ var m = 0, h = 0, s = 0, a = '';
if (this._colonPos != -1) {
+ this._scolonPos = dt.substring(this._colonPos + 1).search(':');
h = parseInt(dt.substr(this._colonPos - 2, 2), 10);
m = parseInt(dt.substr(this._colonPos + 1, 2), 10);
- a = jQuery.trim(dt.substr(this._colonPos + 3, 3));
+ if (this._scolonPos != -1) {
+ this._scolonPos += this._colonPos + 1;
+ s = parseInt(dt.substr(this._scolonPos + 1, 2), 10);
+ a = jQuery.trim(dt.substr(this._scolonPos + 3, 3));
+ } else {
+ a = jQuery.trim(dt.substr(this._colonPos + 3, 3));
+ }
}
a = a.toLowerCase();
@@ -386,9 +425,11 @@ Timepicker.prototype = {
this._setTime('hour', h);
this._setTime('minute', m);
+ this._setTime('second', s);
this._orgHour = h;
this._orgMinute = m;
+ this._orgSecond = s;
},
_setTime: function (type, value)
@@ -397,6 +438,7 @@ Timepicker.prototype = {
if (value < 0) value = 0;
if (value > 23 && type == 'hour') value = 23;
if (value > 59 && type == 'minute') value = 59;
+ if (value > 59 && type == 'second') value = 59;
if (type == 'hour') {
$('#hourSlider').slider('value', value);
@@ -406,6 +448,10 @@ Timepicker.prototype = {
$('#minuteSlider').slider('value', value);
}
+ if (type == 'second') {
+ $('#secondSlider').slider('value', value);
+ }
+
this._writeTime(type, value);
}
};
diff --git a/tbl_change.php b/tbl_change.php
index 31110c1..57b8912 100644
--- a/tbl_change.php
+++ b/tbl_change.php
@@ -184,7 +184,7 @@ if (isset($where_clause)) {
} else { // end if (no row returned)
$meta = PMA_DBI_get_fields_meta($result[$key_id]);
list($unique_condition, $tmp_clause_is_unique) =
PMA_getUniqueCondition($result[$key_id], count($meta), $meta, $rows[$key_id], true);
- if (! empty($unique_condition)) {
+ if (! empty($unique_condition)) {
$found_unique_key = true;
}
unset($unique_condition, $tmp_clause_is_unique);
@@ -306,7 +306,7 @@ foreach ($rows as $row_id => $vrow) {
<thead>
<tr>
<th><?php echo $strField; ?></th>
-
+
<?php
if ($cfg['ShowFieldTypesInDataEditView']) {
$this_url_params = array_merge($url_params,
@@ -347,8 +347,8 @@ foreach ($rows as $row_id => $vrow) {
// d a t e t i m e
//
// Current date should not be set as default if the field is NULL
- // for the current row, but do not put here the current datetime
- // if there is a default value (the real default value will be set
+ // for the current row, but do not put here the current datetime
+ // if there is a default value (the real default value will be set
// in the Default value logic below)
// Note: (tested in MySQL 4.0.16): when lang is some UTF-8,
@@ -440,7 +440,7 @@ foreach ($rows as $row_id => $vrow) {
<td align="center"<?php echo $field['wrap'];
?>>
<?php echo $field['pma_type']; ?>
</td>
-
+
<?php } //End if
// Prepares the field value
@@ -563,12 +563,12 @@ foreach ($rows as $row_id => $vrow) {
) {
$default_function =
$cfg['DefaultFunctions']['pk_char36'];
}
-
+
// this is set only when appropriate and is always true
if (isset($field['display_binary_as_hex'])) {
$default_function = 'UNHEX';
}
-
+
// loop on the dropdown array and print all available options for that
field.
foreach ($dropdown as $each_dropdown){
echo '<option';
@@ -640,7 +640,7 @@ foreach ($rows as $row_id => $vrow) {
// foreign key in a drop-down
$onclick .= '4, ';
} elseif ($foreigners && isset($foreigners[$field['Field']])
&& $foreignData['foreign_link'] == true) {
- // foreign key with a browsing icon
+ // foreign key with a browsing icon
$onclick .= '6, ';
} else {
$onclick .= '5, ';
@@ -1057,7 +1057,7 @@ foreach ($rows as $row_id => $vrow) {
<input type="text" name="fields<?php echo
$field_name_appendix; ?>"
value="<?php echo $special_chars; ?>"
size="<?php echo $fieldsize; ?>"
class="textfield" <?php echo $unnullify_trigger; ?>
- tabindex="<?php echo ($tabindex + $tabindex_for_value);
?>"
+ tabindex="<?php echo ($tabindex + $tabindex_for_value);
?>"
id="field_<?php echo ($idindex); ?>_3" />
<?php
if ($field['Extra'] == 'auto_increment') {
hooks/post-receive
--
phpMyAdmin