').insertAfter('#inputColumnButtons > *:eq(' + insertAfterIndex + ')');
header.add(from).add(to).add(insert).mouseover(Multiedit.columnMouseHandler).mouseout(Multiedit.columnMouseHandler);
$('#insertAfterColumn' + newID).click(Multiedit.insertColumn);
$('#deleteColumn' + newID).click(Multiedit.deleteColumn);
$('#columnValue' + newID).blur(Multiedit.columnValueBlurHandler).focus(Multiedit.columnValueFocusHandler).focus();
return false;
},
maximizeColumnValueInputWidths: function() {
function maximize() {
var $this = $(this);
var parentWidth = $this.parent().width();
if ($this.width() < parentWidth) {
$this.width((parentWidth + $this.height()) + 'px');
}
}
Multiedit.columnValues.each(maximize);
},
selectFieldIfUnchanged: function() {
var $this = $(this);
if ($this.hasClass('unchanged')) {
window.setTimeout(function () { $this.select(); }, 10);
return false;
}
},
setSelectionTimer: function() {
Multiedit.timer = window.setTimeout(function () {
Multiedit.currentColumnValue.field = null;
Multiedit.currentColumnValue.selection = { start: 0, end: 0 };
$('.caseButton').attr('disabled', true);
}, 150);
},
shiftKeyOnSubmit: false,
timer: null,
updateError: function(request, status, error) {
var message = '';
switch (status) {
case 'timeout':
message = 'Timed out trying to fetch the preview. Please wait a few minutes and try again.';
break;
default:
message = 'An error occurred trying to fetch the preview. Please contact info@cleanupdata.com for support.';
}
$('#previewStatus').html('
' + message + '
');
$('#previewSpinner').hide();
},
updatePreview: function(data, status) {
var oldTable = $('#columnPreviewTable');
var tableRows = oldTable.find('tr').not('.headerValues');
var newTable = $('
').insertBefore(oldTable);
var newTbody = $('').appendTo(newTable);
var numDataRows = data.length;
$('#previewStatus').empty();
$('#previewSpinner').hide();
tableRows.slice(numDataRows).remove(); // if there are more rows on the old preview than in the new data, remove them
tableRows.eq(tableRows.length - 1).children().each(function () {
var $this = $(this);
$this.width($this.width());
});
var i, j;
i = 0;
function updateNextRow() {
if (i >= numDataRows) {
oldTable.remove();
newTable.attr('id', 'columnPreviewTable');
return;
}
var currentRow = tableRows.eq(i);
var newRow = $('
').appendTo(newTbody);
var currentData = [];
var newData;
var className;
if (currentRow) {
currentData = currentRow.children();
currentRow.remove();
}
for (j = 0, numDataColumns = data[i].length; j < numDataColumns; j++) {
newData = data[i][j].encodeXML();
if (!currentData[j] || (newData != currentData[j].innerHTML)) {
className = 'updatedCell';
}
newRow.append('
' + newData + '
');
}
i++;
window.setTimeout(updateNextRow, 75);
}
updateNextRow();
},
initialTablePasteValue: 'Paste a table of data here.',
initializeField: function(evt) {
var $this = $(this);
if ($this.val() != Multiedit.initialTablePasteValue) {
$this.removeClass('unchanged').unbind('keydown keyup change', Multiedit.initializeField);
}
},
initialize: function() {
Multiedit.columnValues = $('.columnValue');
Multiedit.maximizeColumnValueInputWidths();
var unchanged = $('.unchanged');
unchanged.bind('keydown keyup change', Multiedit.initializeField);
unchanged.focus(Multiedit.selectFieldIfUnchanged).mousedown(Multiedit.selectFieldIfUnchanged);
Multiedit.columnValues.blur(Multiedit.columnValueBlurHandler).focus(Multiedit.columnValueFocusHandler);
Multiedit.columnValues.mouseup(Multiedit.columnValueMouseupHandler);
// OFA, would you believe Firefox works with keypress, and IE works with keydown?
if ($.browser.msie) {
Multiedit.columnValues.bind('keydown', Multiedit.columnValueKeyHandler);
} else if ($.browser.mozilla) {
Multiedit.columnValues.bind('keypress', Multiedit.columnValueKeyHandler);
}
$('.caseButton').mousedown(Multiedit.caseButtonFocusHandler).click(Multiedit.changeCase);
$('#columnInputTable tr > *').mouseover(Multiedit.columnMouseHandler).mouseout(Multiedit.columnMouseHandler);
$('.insertAfterColumnButton').click(Multiedit.insertColumn);
$('.deleteColumnButton').click(Multiedit.deleteColumn);
$('#previewButton').click(Multiedit.editorPreviewHandler);
}
};
// IE/Firefox compatible methods for getting and setting the selection of
jQuery.fn.extend({
getSelection: function() {
var el = this[0];
var position = { start: 0, end: 0 };
if (!el) return null;
if (el.selectionStart !== undefined) {
position.start = el.selectionStart;
position.end = el.selectionEnd;
} else if (el.createTextRange !== undefined) {
var range = el.createTextRange();
range = range.duplicate();
var selection = document.selection.createRange();
try {
range.setEndPoint("EndToStart", selection);
} catch(exception) {};
position.start = range.text.length;
position.end = range.text.length + selection.text.length;
}
return position;
},
setSelection: function(p) {
// p should be an object with start and end parameters
var el = this[0];
if (!el) return null;
if (el.selectionStart !== undefined) {
if (p.start || p.start === 0) {
el.selectionStart = p.start;
}
if (p.end || p.end === 0) {
el.selectionEnd = p.end;
}
} else if (el.createTextRange !== undefined) {
el.focus();
var text = el.createTextRange();
if (p.start !== 0 && !p.start) {
p.start = 0;
}
if (p.end !== 0 && !p.end) {
p.end = p.start;
}
text.move("character", p.start);
text.moveEnd("character", p.end - p.start); // IE does end point relative to start point
text.select();
}
return this;
}
});
if (String.prototype.toCapitalCase === undefined) {
String.prototype.toCapitalCase = function() {
return this.replace(/(\s*)(\S+)(\s*)/g, function(str, p1, p2, p3) {
return p1 + p2.charAt(0).toUpperCase() + p2.slice(1).toLowerCase() + p3;
});
};
}
if (String.prototype.encodeXML === undefined) {
String.prototype.encodeXML = function() {
return this.replace(/&/g, '&').replace(//g, '>');
};
}
