// CustomtextColumn
// By wowbagger

// -------------------- Options

var LogLevel = {
   Debug: 0,    
   Info: 1,    
   Warning: 2, 
   Error: 3    
};

var gbUseLogging=false;
var logLevel = LogLevel.Info;
var scriptName = "RegExp Columns";
//Default values for extendedConfig
var defaultCustomColumns = {
	columns: [{
		//Column settings
		// Columns setting details https://www.gpsoft.com.au/help/opus12/index.html#!Documents/Scripting/ScriptColumn.htm
		name:"RegExp1", 
		label:"RegExp1",
		header: "", 
		type: "string",
		defwidth: "", //int or string.
		//grouporder:, //"Never Modified;Modified"
		justify: "left", //"left", "right", "center" or "path". The default is "left".
		//Not implemented yet
		infotiponly: false, //Not available for column
		//Not implemented yet
		maxstars: 5, // int
		datetimeformat: "yyyy-mm-dd", //Date Format used to parse the extracted date information (time not realy supported at the moment!)
		//Not implemented yet
		nogroup: false,
		grouporder: "",
		//enableAutoGroup: true,// true (default)
		//Not implemented yet
		sorting:"normal",
		//enableSort: false,//flag (true/false) as described in the DOpus documentation
		//defsort: true, //0 default, -1 reverse sort.
		
	 	//Regexp settings
		regexp: "(.*)", // Will select everyting
		inputItemProperty: "name_stem", // name_stem, realpath, name, ext, contents
		firstValid: false,  //(true/false) 
		output: "$1",// $1$2
		//Not implemented yet
	 	filter: "all" // all, files, folders 

	}]
}; 

// Functions
var doVars = DOpus.vars;
var doLogCmd = DOpus.NewCommand;
var configVarKey = "RegexpCustomColumnsConfig";

function OnInit(initData) {
  // Provide basic information about the script by initializing the properties of the ScriptInitData object
  initData.name = scriptName;
  initData.desc = "Adds columns and displays values matched by regexp against filename.";
  initData.copyright = "2017 wowbagger";
  initData.min_version = "12.0"
  initData.version = "1.5.7";
  initData.default_enable = true;

 // variable for enabling debug, so as to enable debug via a button
  initData.config_desc = DOpus.NewMap();
 
  initData.config.DEBUG = false;
  initData.config_desc("DEBUG") = "Set DEBUG flag to true in order to enable logging messages to the Opus Output Window";
}

function OnAddCommands(addCmdData)
{
	var cmd = addCmdData.AddCommand();
	cmd.name = "RegExpColumnsConfigure";
	cmd.method = "OnRegExpColumnsConfigure";
	cmd.desc = "Configure the RegExp columns";
	cmd.label = "RegExpColumnsConfigure";
}

function OnAddColumns(addColData)
{
	//LogDebugMessage("OnAddColumns called", true)
	var customColumns = LoadCustomColumns();
	if(customColumns && customColumns.columns.length > 0)
	{
		//var customColumns = JSON.parse(Script.config.CustomColumns);
		for(i=0;i<customColumns.columns.length;i++) {
			var currentCol = customColumns.columns[i];

			var nameRefresh = (currentCol.inputItemProperty == "name_stem" || currentCol.inputItemProperty == "realpath" 
							|| currentCol.inputItemProperty == "name" || currentCol.inputItemProperty == "ext");
			
			if(addColData,currentCol)
			{
				AddColumn(addColData, //iAddColumn
					currentCol.name, //name
					currentCol.label, //label
					currentCol.header, //label
					currentCol.type, //type
					currentCol.defwidth, //defwidth
					currentCol.nogroup,
					currentCol.grouporder,
					currentCol.sorting,
					currentCol.autorefresh, //autorefresh
					nameRefresh,
					currentCol.maxStars,
					currentCol.justify, //justify
					currentCol.infotiponly,
					true //multicol
				);
			}
		}
	}
} 

function AddColumn(iAddColumn, name, label, header, type, defwidth, nogroup, grouporder, sorting, autorefresh, nameRefresh, maxStars, justify, infotiponly, multicol){
	var autoGroup = ((typeof grouporder === 'undefined') || grouporder  == "" || nogroup);

	LogInfoMessage("AddColumn: name='" + name + "' label='" + label + "' header='" + header + 
				"' type='" + type + "' defwidth='" + defwidth + "' sorting='" + sorting + 
				"' grouporder='" + grouporder + "' autoGroup='" + autoGroup + "' nogroup='" + nogroup + 
				"' autorefresh='" + autorefresh + "' maxStars='" + maxStars + "' justify='" + justify + 
				"' multicol='" + multicol + "' infotiponly='" + infotiponly + "'");

	//https://www.gpsoft.com.au/help/opus12/index.html#!Documents/Scripting/ScriptColumn.htm

	var col;
	col=iAddColumn.AddColumn();
	col.name = name;
	col.label = label;
	col.header = header;

	col.type = type;
	col.method = "OnCustomText";
	col.namerefresh = nameRefresh;
	col.autogroup = autoGroup;///true;
	col.autorefresh = autorefresh;///true;
	col.justify = justify;///"left";
	col.multicol = multicol;///true;
	col.infotiponly = infotiponly;
	col.maxstars = maxStars;
	col.grouporder = grouporder;
	col.nogroup = nogroup;
	col.defsort = (sorting == "reverse") ? -1 : 1;
	col.nosort = (sorting == "disabled");
	
	/*
	LogDebugMessage("AddColumn: name=" + name + " label=" + label + " type=" + type + " defwidth=" + defwidth)
	var col;
	col=iAddColumn.AddColumn();
	col.name = name;
	col.label = label;
	col.type = type;
	col.method = "OnCustomText";
	col.autogroup = true;
	col.autorefresh = true;
	col.justify = "left";
	col.multicol = true;*/
	if(defwidth != null && defwidth != 0)
	{
		col.defwidth=defwidth;
	}  
}

// The OnScriptConfigChange event can be implemented by a script add-in to receive 
// notification whenever the user modifies the script's configuration via the Preferences editor.
function OnScriptConfigChange(configChangeData)
{
	LogDebugMessage("OnScriptConfigChange " + (configChangeData ? (configChangeData.changed ? configChangeData.changed.length : 'nothing changed') :'null' , true));
	for (var i = 0; i < configChangeData.changed.length; i++) {
		LogDebugMessage("OnScriptConfigChange " + i + ":" + configChangeData.changed[i], true)
	}

	Script.InitColumns;
}

// Implement the ExternalCompare command
function OnRegExpColumnsConfigure(scriptCmdData)
{
    var dlg = DOpus.Dlg;
    
    dlg.window = scriptCmdData.func.sourcetab;
    dlg.template = "RegExpColumnsConfigure";
    dlg.detach = true;
    dlg.Show();
    onDialogPopulateColumnsList(dlg);

    var closeDialog;
    while (!closeDialog) {
  		var msg = dlg.GetMsg();
  		if (!msg.result) break;
  		//LogDebugMessage("Msg: " + msg.control + " value: " + msg.value + " event:" + msg.event);
  		switch (msg.control) {
  			case "columnsList" :
  				onDialogConfigSelected(dlg, msg);
  				break;
  			case "buttonAdd" :
  				onDialogAddColumn(dlg, msg);
  				break;
  			case "buttonDelete" :
  				onDialogDeleteColumn(dlg, msg);
  				break;
  			case "buttonApply" :
  				 onDialogApplyChanges(dlg, msg);
  				break;
  			case "buttonClipboard" :
  				 CopyToClipboard();
  				break;
  			case "columnType" :
  				onDialogColumnType(dlg);
  				break;
  			case "columnInput" :
  				onDialogColumnInput(dlg);
  				break;
  			case "columnFilter" :
  				onDialogColumnFilter(dlg);
  				break;
  			case "columnSetNoGroup" :
  				onSetNoGroup(dlg);
  				break;
  			case "columnFirstValid" :
  				onSetFirstValid(dlg);
  				break;
  			case "buttonOK" :
  				//params = DialogClosed(dlg, msg);
  				closeDialog = true;
  				break;
  		} 
    }
}

function onDialogPopulateColumnsList(dlg)
{
    var columnsList = dlg.Control("columnsList");
    var customColumnsConfig = LoadCustomColumns();//JSON.parse(Script.config.CustomColumns);

	var selectedColumn;
    for(var i = 0; i < customColumnsConfig.columns.length; ++i) 
    {
    	if(customColumnsConfig.columns[i])
    	{
			var location = columnsList.AddItem(customColumnsConfig.columns[i].name);
			var item = columnsList.GetItemAt(location);
			if(!selectedColumn)
			{ 
				item.selected = true;
				selectedColumn = customColumnsConfig.columns[i];
				onDialogConfigSelected(dlg);
			}
 			LogDebugMessage("item: " + item.index + " location: " + location + " product:" + customColumnsConfig.columns[i].name);
 		}
    }
}

// Dialog functions
function onDialogColumnFilter(dlg)
{
	var selectedType = GetSelectedItem(dlg ,"columnFilter");
	LogDebugMessage("onDialogColumnFilter: " + ((selectedType && selectedType.name) ? selectedType.name : 'null'));

	var columnType = (typeof(selectedType) != "undefined") ? selectedType.name : "" ;

	dlg.Control("columnCustomFilterStatic").enabled = (columnType == "custom");
	dlg.Control("columnCustomFilter").enabled = (columnType == "custom");
}		

function onDialogColumnInput(dlg)
{
	var selectedType = GetSelectedItem(dlg ,"columnInput");
	LogDebugMessage("onDialogColumnInput: " + ((selectedType && selectedType.name) ? selectedType.name : 'null'));

	var columnType = (typeof(selectedType) != "undefined") ? selectedType.name : "" ;

	dlg.Control("columnCustomInputStatic").enabled = (columnType == "custom");
	dlg.Control("columnCustomInput").enabled = (columnType == "custom");
}

function onDialogColumnType(dlg)
{
	var selectedType = GetSelectedItem(dlg ,"columnType");
	LogDebugMessage("onDialogColumnType: " + ((selectedType && selectedType.name) ? selectedType.name : 'null'));

	var columnType = (typeof(selectedType) != "undefined") ?  selectedType.name : "" ;

	dlg.Control("columnDateTimeFormat").enabled = (columnType == "datetime" || columnType == "date" || columnType == "time" );
	dlg.Control("columnDateTimeFormatStatic").enabled = (columnType == "datetime" || columnType == "date" || columnType == "time" );
	dlg.Control("columnDateTimeFormat").visible = (columnType != "stars");
	dlg.Control("columnDateTimeFormatStatic").visible = (columnType != "stars");

	dlg.Control("columnMaxStarsStatic").enabled = (columnType == "stars");
	dlg.Control("columnMaxStars").enabled = (columnType == "stars");
	dlg.Control("columnMaxStarsStatic").visible = (columnType == "stars");
	dlg.Control("columnMaxStars").visible = (columnType == "stars");
}

function onSetNoGroup(dlg)
{
	var checkBox = dlg.Control("columnSetNoGroup");
	LogDebugMessage("onSetNoGroup: " + checkBox.name  + "  " + checkBox.value);
	dlg.Control("columnGroupOrder").enabled = !(checkBox.value);
}

function onSetFirstValid(dlg)
{
	var checkBox = dlg.Control("columnFirstValid");
	LogDebugMessage("onSetFirstValid: " + checkBox.name  + "  " + checkBox.value);
	dlg.Control("columnOutput").enabled = !(checkBox.value);
}

function onDialogConfigSelected(dlg)
{
	var selectedUiColumn = GetSelectedItem(dlg ,"columnsList");
	LogDebugMessage("onDialogConfigSelected: " + ((selectedUiColumn && selectedUiColumn.name) ? selectedUiColumn.name : 'null'));
	if(typeof(selectedUiColumn) == "undefined") return;

	var selectedColumnConfig = GetRegexpColumnConfig(selectedUiColumn.name);

	dlg.Control("columnName").value = selectedColumnConfig ? selectedColumnConfig.name : "";
	dlg.Control("columnLabel").value = selectedColumnConfig ? selectedColumnConfig.label : "";
	dlg.Control("columnHeader").value = selectedColumnConfig ? selectedColumnConfig.header : "";
	SetSelectedItem(dlg, "columnType", (selectedColumnConfig ? selectedColumnConfig.type : ""));
	onDialogColumnType(dlg);
	dlg.Control("columnDateTimeFormat").value = selectedColumnConfig ? selectedColumnConfig.datetimeformat : "yyyy-mm-dd";
	dlg.Control("columnMaxStars").value = selectedColumnConfig ? selectedColumnConfig.maxstars : 5;
	SetSelectedItem(dlg, "columnJustify", (selectedColumnConfig ? selectedColumnConfig.justify : ""));
	dlg.Control("columnDefaultWidth").value = selectedColumnConfig ? selectedColumnConfig.defwidth : "";
	dlg.Control("columnSetNoGroup").value = selectedColumnConfig ? selectedColumnConfig.nogroup : false;
	dlg.Control("columnGroupOrder").value = selectedColumnConfig ? selectedColumnConfig.grouporder : "";
	SetSelectedItem(dlg, "columnSorting", (selectedColumnConfig ? selectedColumnConfig.sorting : "normal"));
	dlg.Control("columnSetInfoTipOnly").value = selectedColumnConfig ? selectedColumnConfig.infotiponly : false;

	dlg.Control("columnRegExp").value = selectedColumnConfig ? selectedColumnConfig.regexp : "";
	dlg.Control("columnOutput").value = selectedColumnConfig ? selectedColumnConfig.output : "";
	dlg.Control("columnFirstValid").value = selectedColumnConfig ? selectedColumnConfig.firstValid : true;
	onSetFirstValid(dlg);
	
	var colInputValue = selectedColumnConfig ? selectedColumnConfig.inputItemProperty : "";
	if(colInputValue == "name_stem" || colInputValue == "realpath" || colInputValue == "name" || colInputValue == "ext")
	{
		SetSelectedItem(dlg, "columnInput", colInputValue);
		dlg.Control("columnCustomInput").value = "";
	}
	else
	{
		SetSelectedItem(dlg, "columnInput", "custom");
		dlg.Control("columnCustomInput").value = colInputValue;
	}
	onDialogColumnInput(dlg);

	var colFilterValue = selectedColumnConfig ? selectedColumnConfig.filter : "";
	if(colFilterValue == "all" || colFilterValue == "files" || colFilterValue == "folders")
	{
		SetSelectedItem(dlg, "columnFilter", colFilterValue);
		dlg.Control("columnCustomFilter").value = "";
	}
	else
	{
		SetSelectedItem(dlg, "columnFilter", "custom");
		dlg.Control("columnCustomFilter").value = colFilterValue;
	}
	onDialogColumnFilter(dlg);
}

function onDialogApplyChanges(dlg, msg)
{
	var selectedUiColumn = GetSelectedItem(dlg ,"columnsList");
	//LogDebugMessage("onDialogApplyChanges: " + selectedUiColumn ? selectedUiColumn.name : 'null');
	if(!selectedUiColumn) return;
	
	var oldName = selectedUiColumn.name;
  	
	var customColumns = LoadCustomColumns();
	for(var i = 0; i < customColumns.columns.length; ++i) {
		if(customColumns.columns[i] && customColumns.columns[i].name.toLowerCase() == oldName.toLowerCase()) {
			var selectedColumn = customColumns.columns[i];
			selectedColumn.name = dlg.Control("columnName").value;
			selectedColumn.label = dlg.Control("columnLabel").value;
			selectedColumn.header = dlg.Control("columnHeader").value;
			var selectedType = GetSelectedItem(dlg, "columnType");
			selectedColumn.type = selectedType ? selectedType.name : "";
			selectedColumn.datetimeformat = dlg.Control("columnDateTimeFormat").value;
			selectedColumn.maxstars = dlg.Control("columnMaxStars").value;
			var selectedJustify = GetSelectedItem(dlg, "columnJustify");
			selectedColumn.justify = selectedJustify ? selectedJustify.name : "";
			selectedColumn.defwidth = dlg.Control("columnDefaultWidth").value;
			selectedColumn.nogroup = dlg.Control("columnSetNoGroup").value;
			selectedColumn.grouporder = dlg.Control("columnGroupOrder").value;
			var selectedSorting = GetSelectedItem(dlg, "columnSorting");
			selectedColumn.sorting = selectedSorting ? selectedSorting.name : "";
			selectedColumn.infotiponly = dlg.Control("columnSetInfoTipOnly").value;
			selectedColumn.regexp = dlg.Control("columnRegExp").value;
			selectedColumn.output = dlg.Control("columnOutput").value;
			selectedColumn.firstValid = dlg.Control("columnFirstValid").value;
			var selectedInput = GetSelectedItem(dlg, "columnInput");
			var SelectedInputValue = selectedInput ? selectedInput.name : "";
			if(SelectedInputValue == "custom")
			{
				selectedColumn.inputItemProperty = dlg.Control("columnCustomInput").value;
			}
			else
			{
				selectedColumn.inputItemProperty = SelectedInputValue;
			}
	    
			var selectedFilter = GetSelectedItem(dlg, "columnFilter");
			var SelectedFilterValue = selectedFilter ? selectedFilter.name : "";
			if(SelectedFilterValue == "custom")
			{
				selectedColumn.filter = dlg.Control("columnCustomFilter").value;
			}
			else
			{
				selectedColumn.filter = SelectedFilterValue;
			}

			SaveCustomColumns(customColumns);
	
			//Script.RefreshColumn(oldName.name);
			selectedUiColumn.name = dlg.Control("columnName").value; 
			RefreshColumn(oldName, dlg.Control("columnName").value);
		  	break;
		}
	}
}

function RefreshColumn(oldName, newName)
{
  	LogMessage("RefreshColumn: oldName:" + oldName + "  newName:" + newName);
  	var columnOldUniqueName = "scp:" + scriptName + "/" +  oldName;
  	var columnNewUniqueName = "scp:" + scriptName + "/" +  newName;
  	Script.RefreshColumn(oldName);
  	Script.RefreshColumn(newName);
  	
   	LogDebugMessage("DOpus.listers.count = " + DOpus.listers.count);
	for (var iLister = 0; iLister< DOpus.listers.count; iLister++) {
		var lister = DOpus.listers(iLister);
		LogDebugMessage("RefreshColumn: lister:" + lister.title);

  		for (var iTabs = 0; iTabs< lister.tabs.count; iTabs++) {
			var tab = lister.tabs(iTabs);
			LogDebugMessage("RefreshColumn: tab:" + tab.label);
	  	
  	  		for (var iColumns = 0; iColumns< tab.format.columns.count; iColumns++) {
				var column = tab.format.columns(iColumns);
				LogMessage("RefreshColumn: column:" + column.name);
				if(column.name == columnOldUniqueName){
					LogMessage("RefreshColumn: match:" + column.name);
					
					var doCmd = DOpus.NewCommand;
					doCmd.SetSourceTab(tab);
					doCmd.RunCommand("Set COLUMNSREMOVE=" + columnOldUniqueName);
					doCmd.RunCommand("Set COLUMNSADD " + columnNewUniqueName + "(" + iColumns +")");
				}
			}
		}
	}
}

function onDialogAddColumn(dlg, msg)
{
  	//LogDebugMessage("onDialogAddColumn");
  
  	var newColumn = defaultCustomColumns.columns[0];
  	var customColumnsConfig = LoadCustomColumns();
	customColumnsConfig.columns.push(newColumn);
	SaveCustomColumns(customColumnsConfig);

	//customColumnsConfig.columns[customColumnsConfig.columns.length - 1]
	AddToColumnsList(dlg, newColumn.name, true);
	onDialogConfigSelected(dlg, msg);
}

function onDialogDeleteColumn(dlg, msg)
{
	var selectedUiColumn = GetSelectedItem(dlg ,"columnsList");
	//LogDebugMessage("onDialogApplyChanges: " + selectedUiColumn ? selectedUiColumn.name : 'null');
	if(!selectedUiColumn) return;

	var customColumns = LoadCustomColumns();
	for(var i = 0; i < customColumns.columns.length; ++i) {
		if(customColumns.columns[i].name.toLowerCase() == selectedUiColumn.name.toLowerCase()) {
			
			delete customColumns.columns[i];

			SaveCustomColumns(customColumns);
			Script.RefreshColumn(selectedUiColumn.name);
		  	break;
		}
	}

	RemoveFromColumnsList(dlg, selectedUiColumn);
	onDialogConfigSelected(dlg, msg);
}

function RemoveFromColumnsList(dlg, column)
{
	var columnsList = dlg.Control("columnsList");
	var index = column.index;
	columnsList.RemoveItem(column);

	if(columnsList.count > 0)
	{
		var selectedColumn = columnsList.GetItemAt((index > 0) ? index -1 : 0);
    	selectedColumn.selected = true;
	}
}

function AddToColumnsList(dlg, name, setSelected)
{
	var columnsList = dlg.Control("columnsList");
 	var location = columnsList.AddItem(name);
 	if(setSelected)
 	{
		var item = columnsList.GetItemAt(location);
		item.selected = true;
	}
}

function GetSelectedItem(dlg, controlName)
{
	//LogDebugMessage("GetSelectedItem: " + controlName);

	var listItems = dlg.Control(controlName);
  for(var i = 0; i < listItems.count; ++i) {
  	var column = listItems.GetItemAt(i);
	
	  //LogDebugMessage("GetSelectedItem: " + controlName + " " + i + " of " + listItems.count + " is" + (column.selected ? "selected" : "not selected"));
  	if(column && column.selected)
  	{
		  //LogDebugMessage("GetSelectedItem: found " + column.name);
  		return column;
	  }
  }
}

function SetSelectedItem(dlg, controlName, value)
{
	var listItems = dlg.Control(controlName);

	if(typeof(value) == "undefined") 
	{
		var item = listItems.GetItemAt(0);
		//LogDebugMessage("SetSelectedItem: " + controlName + ":defaulted to " + item.name);
		item.selected = true;
		return;
	}

    for(var i = 0; i < listItems.count; ++i) {
    	var item = listItems.GetItemAt(i);
	
		//LogDebugMessage("SetSelectedItem: " + controlName + " " + i + " of " + listItems.count + " is " + item.name  + " looking for " + value);
    	if(item && item.name == value)
    	{
			//LogDebugMessage("SetSelectedItem: " + controlName + ":found " + item.name);
			item.selected = true;
 		}
    }
}

function CopyToClipboard(){

	var customColumns = LoadCustomColumns();
	var config = JSON.stringify(customColumns, undefined, 2).replace(/(\n)+/g,"\r\n");
	var doCmd = DOpus.NewCommand;

	var cmd = "Clipboard SET " + config;
	doCmd.RunCommand(cmd);
}

function SaveCustomColumns(customColumns){

	var newList = new Array();
	for(var i = 0; i < customColumns.columns.length; ++i) {
		if(customColumns.columns[i]) {
			newList.push(customColumns.columns[i]);
		}
	}

	customColumns.columns = newList;

	var config = JSON.stringify(customColumns, undefined, 2).replace(/(\n)+/g,"\r\n");

	LogDebugMessage("SaveCustomColumns: " + config);
	doVars(configVarKey) = config;
    doVars(configVarKey).persist = true;

    Script.InitColumns;
}

function ClearCustomColumns(){
	if(doVars.Exists(configVarKey))
	{
        doVars(configVarKey).Delete()
	}
}

function LoadCustomColumns(){
	//LogDebugMessage("LoadCustomColumnsConfiguration from var");
	//return JSON.parse(Script.config.CustomColumns);
  	var config = doVars.Exists(configVarKey) ? JSON.parse(doVars.Get(configVarKey)) : null;
  	if(!config) 
  	{
  		config = defaultCustomColumns;
  	}

	return config
}

function GetRegexpColumnConfig(name)
{
	var customColumns = LoadCustomColumns();
	for(var i = 0; i < customColumns.columns.length; ++i) {
		if(customColumns.columns[i].name.toLowerCase() == name.toLowerCase()) {
			return customColumns.columns[i];
		}
	}
}

function IsDebugEnabled()
{
  
  if(Script)
  {
	return gbUseLogging || Script.config.DEBUG || doLogCmd.IsSet(Script.config.DebugEnableVar);
  }

  return gbUseLogging;
}

function LogMessage(message, force)
{
  if (force || IsDebugEnabled()) { DOpus.OutputString(message)};
}

function LogWarningMessage(message, force)
{
	if (LogLevel.Warning >= logLevel)
	{
		LogMessage(message, force)
	}
}

function LogInfoMessage(message, force)
{
	if (LogLevel.Info >= logLevel)
	{
		LogMessage(message, force)
	}
}

function LogDebugMessage(message, force)
{
	if (LogLevel.Debug >= logLevel)
	{
		LogMessage(message, force)
	}
}


// Implement the OnCustomText column (this entry point is an OnScriptColumn event).
function OnCustomText(scriptColData) {
	var itemPath = scriptColData.item.path + "\\" + scriptColData.item.name;
	LogDebugMessage("OnCustomText: column=" + scriptColData.col + " columnsCount=" + scriptColData.columns.length + " itempPath=" + itemPath);
  	// get column's config

	var customColumnsConfig = LoadCustomColumns();
	var columnsConfig = customColumnsConfig.columns;
		
	if (!InArray(scriptColData.col, columnsConfig)) return;
	LogDebugMessage("1: column=" + scriptColData.col + " columnsCount=" + scriptColData.columns.length + " itempPath=" + scriptColData.Item.path);
  
	var results = RunRegExpOnItem(scriptColData.Item, columnsConfig);
	if (results){
		for ( i = 0; i < columnsConfig.length; i++) 
		{
			if (typeof(columnsConfig[i].name) != "undefined")
			{
				var result = results[columnsConfig[i].name];
				if (scriptColData.columns.exists(columnsConfig[i].name))
				{
					switch (columnsConfig[i].type) {
						case "date" :
						case "time" :
						case "datetime" :
							LogDebugMessage("Datetime for " + columnsConfig[i].name + "[" + columnsConfig[i].type + "]:" + result);
							var parsedDate = parseDate(results[columnsConfig[i].name], columnsConfig[i].datetimeformat);
							scriptColData.columns(columnsConfig[i].name).value = parsedDate ? parsedDate.getVarDate() : null;
							break;
						case "graph" :
						case "igraph" :
						case "percent" :
						case "stars" :
							LogDebugMessage("number for " + columnsConfig[i].name + "[" + columnsConfig[i].type +"]:" + result);
	    					scriptColData.columns(columnsConfig[i].name).value = (isNaN(result) ? 0 : result);
							break;
						default :
							LogDebugMessage("results for " + columnsConfig[i].name + "[" + columnsConfig[i].type +"]:" + result);
    						scriptColData.columns(columnsConfig[i].name).value = result;
							break;
					} 
				}
				else
				{
					LogDebugMessage("column not loaded " +columnsConfig[i].name + "["+columnsConfig[i].type +"]:" + result);
				}
			}
		}
	}
}

function RunRegExpOnItem(item, columnConfigurations)
{
	LogDebugMessage("RunRegExpOnItem item=" + item.path + "\\" + item.name);
	
	var result = {};
	if(!item) return;

	for ( colIndex = 0; colIndex < columnConfigurations.length; colIndex++) 
	{
		var currentCol = columnConfigurations[colIndex];

  		var fileContents;
		var subject;
		var regexMatch;
    
    	switch (currentCol.inputItemProperty) {
			case "contents" :
				if(!(fileContents))
				{
				    var fso = new ActiveXObject("Scripting.FileSystemObject");
				    var fileStream = fso.openTextFile(item.path + "\\" + item.name);
				    fileContents = fileStream.readAll();
				    fileStream.Close();
				}
				subject = fileContents;
				break;

			case "ext" :
				subject = item.ext;
				break;

			case "name" :
				subject = item.name;
				break;

			case "realpath" :
				subject = item.realpath;
				break;

			case "" :
			case "name_stem" :
				subject = item.name_stem;
				break;
			default:
			    subject = findprop(item, currentCol.inputItemProperty);
				break;
		} 

		LogDebugMessage("RunRegExpOnItem colIndex:" + colIndex + " subject=" + subject);
	
		var re = new RegExp(currentCol.regexp);
		if(re.test(subject))
		{
			if(currentCol.firstValid)
			{
				regexMatch = re.exec(subject);
			    if (regexMatch != null)    {
		         	for(i = 1; i < regexMatch.length + 1; i++) {
		            	if (regexMatch[i] != '') {
		               		result[currentCol.name] = regexMatch[i];
		               		break;
		           	 	}
	           	 	}	
			    }
			}
			else
			{
				var output = (currentCol.output == "") ? "$1" : currentCol.output;
			    result[currentCol.name]= subject.replace(re, output);
			}
		}
	}

	return result;
}

function findprop(obj, path) {
	// thanks to andersonnnunes
	LogDebugMessage("findprop '" + path + "' on item=" + obj.path + "\\" + obj.name);
	var matched = false;
    var args = path.split('.'), i, l;
    for (i = 0, l = args.length; i < l; i++) {
 	    if (!obj[args[i]]){
            break;
            matched = false;
        }
 	    obj = obj[args[i]];
 	    matched = true;
    }

    if(!matched) return "";

    try
    {
 	    return (typeof(obj) != "undefined") ? obj.toString() : "";
    }
    catch(e)
    {
 		return "";
    }
}

function parseDate(input, format) {
	if(!input) return;

	var parsedDate = new Date(Date.parse(input));
	if(!parsedDate || parsedDate == "NaN")
    {

		format = format || 'yyyy-mm-dd'; // default format
		var parts = input.match(/(\d+)/g), 
		  i = 0, fmt = {};
	  	if(parts)
		{
			// extract date-part indexes from the format
			format.replace(/(yyyy|dd|mm)/g, function(part) { fmt[part] = i++; });
			parsedDate = new Date(parts[fmt['yyyy']], parts[fmt['mm']]-1, parts[fmt['dd']]);	
		}
    }
				
	return (!parsedDate || parsedDate == "NaN") ? null : parsedDate;
}

function InArray(col,arr){
	for (var i=0;i<arr.length;i++){
	if (col==arr[i].name) return true;
	}
}
 
==SCRIPT RESOURCES
<resources>
	<resource name="RegExpColumnsConfigure" type="dialog">
		<dialog fontsize="8" height="384" lang="english" resize="yes" title="Regexp custom columns" width="318">
			<control close="0" height="14" name="buttonClose" resize="xy" title="Close" type="button" width="50" x="252" y="360" />
			<control height="372" name="columnsGroup" resize="h" title="RegExp Columns" type="group" width="96" x="6" y="6" />
			<control height="312" name="columnsList" resize="h" type="listbox" width="84" x="12" y="18" />
			<control header="yes" height="64" name="groupColumnSettings" resize="w" title="Column Settings" type="group" width="204" x="108" y="12" />
			<control halign="left" height="8" name="columnNameSatic" title="Name" type="static" width="66" x="108" y="24" />
			<control halign="left" height="12" name="columnName" resize="w" tip="Not set" type="edit" width="132" x="174" y="24" />
			<control halign="left" height="8" name="columnLabelStatic" title="Label" type="static" width="66" x="108" y="42" />
			<control halign="left" height="12" name="columnLabel" resize="w" tip="Not set (defaults to Name)" type="edit" width="132" x="174" y="42" />
			<control halign="left" height="8" name="columnHeaderStatic" title="Header" type="static" width="66" x="108" y="60" />
			<control halign="left" height="12" name="columnHeader" resize="w" tip="Not set (defaults to Display Name)" type="edit" width="132" x="174" y="60" />
			<control halign="left" height="8" name="columnTypeStatic" title="Column Type" type="static" width="66" x="108" y="78" />
			<control height="40" name="columnType" type="combo" width="102" x="174" y="78">
				<contents>
					<item text="text" />
					<item text="number" />
					<item text="double" />
					<item text="size" />
					<item text="zip" />
					<item text="percent" />
					<item text="graph" />
					<item text="igraph" />
					<item text="date" />
					<item text="time" />
					<item text="datetime" />
					<item text="stars" />
				</contents>
			</control>
			<control halign="left" height="8" name="columnDateTimeFormatStatic" title="Date Time Format" type="static" width="60" x="108" y="96" />
			<control enable="no" halign="left" height="12" name="columnDateTimeFormat" tip="yyyy-MM-dd" type="edit" width="102" x="174" y="96" />
			<control halign="left" height="8" name="columnMaxStarsStatic" title="Max Stars" type="static" visible="no" width="60" x="108" y="96" />
			<control enable="no" halign="left" height="12" name="columnMaxStars" number="yes" tip="5" type="edit" visible="no" width="102" x="174" y="96" />
			<control halign="left" height="8" name="columnJustifyStatic" title="Column Justify" type="static" width="66" x="108" y="114" />
			<control height="40" name="columnJustify" type="combo" width="102" x="174" y="114">
				<contents>
					<item text="left" />
					<item text="right" />
					<item text="center " />
					<item text="path" />
				</contents>
			</control>
			<control halign="left" height="8" name="columnDefaultWidthStatic" title="Default Width" type="static" width="66" x="108" y="132" />
			<control halign="left" height="12" name="columnDefaultWidth" number="yes" tip="Not set" title="80" type="edit" width="66" x="174" y="132" />
			<control height="10" name="columnSetNoGroup" title="Disable Grouping" type="check" width="78" x="174" y="150" />
			<control halign="left" height="8" name="columnGroupOrderStatic" title="Group Order" type="static" width="66" x="108" y="162" />
			<control halign="left" height="12" name="columnGroupOrder" resize="w" tip="e.g. &quot;Never Modified;Modified&quot;" type="edit" width="132" x="174" y="162" />
			<control halign="left" height="8" name="columnSortingStatic" title="Sorting" type="static" width="66" x="108" y="180" />
			<control height="40" name="columnSorting" type="combo" width="102" x="174" y="180">
				<contents>
					<item text="normal" />
					<item text="reverse" />
					<item text="disabled" />
				</contents>
			</control>
			<control height="10" name="columnSetInfoTipOnly" title="Info Tip only" type="check" width="84" x="174" y="198" />
			<control header="yes" height="64" name="groupregexp" resize="w" title="Regexp Settings" type="group" width="204" x="108" y="210" />
			<control halign="left" height="8" name="columnRegExpStatic" title="RegExp" type="static" width="66" x="108" y="222" />
			<control halign="left" height="12" name="columnRegExp" resize="w" tip="Not set I.E. (.*)" type="edit" width="132" x="174" y="222" />
			<control halign="left" height="8" name="columnOutputStatic" title="Output" type="static" width="60" x="108" y="240" />
			<control halign="left" height="12" name="columnOutput" resize="w" tip="$1 (for first capture)" type="edit" width="64" x="174" y="240" />
			<control halign="left" height="8" name="columnInputStatic" title="Input" type="static" width="66" x="108" y="258" />
			<control height="40" name="columnInput" type="combo" width="102" x="174" y="258">
				<contents>
					<item text="name_stem" />
					<item text="realpath" />
					<item text="name" />
					<item text="ext" />
					<item text="custom" />
				</contents>
			</control>
			<control halign="left" height="8" name="columnFilterStatic" title="Filter" type="static" width="66" x="108" y="294" />
			<control height="40" name="columnFilter" type="combo" width="102" x="174" y="294">
				<contents>
					<item text="all" />
					<item text="files" />
					<item text="folders" />
					<item text="custom" />
				</contents>
			</control>
			<control height="12" name="columnFirstValid" resize="x" title="Take First good one" type="check" width="64" x="240" y="240" />
			<control header="yes" height="64" name="groupButtons" resize="yw" type="group" width="210" x="102" y="348" />
			<control default="yes" height="14" name="buttonApply" resize="xy" title="Apply Changes" type="button" width="74" x="234" y="330" />
			<control height="14" name="buttonAdd" resize="y" title="Add Column" type="button" width="60" x="24" y="336" />
			<control height="14" name="buttonDelete" resize="y" title="Delete Column" type="button" width="60" x="24" y="354" />
			<control height="14" name="buttonClipboard" resize="y" title="Copy settings to clipboard" type="button" width="102" x="114" y="360" />
			<control enable="no" halign="left" height="8" name="columnCustomInputStatic" title="Custom Input" type="static" width="66" x="108" y="276" />
			<control enable="no" halign="left" height="12" name="columnCustomInput" resize="w" tip="I.E. metadata.doc.author" type="edit" width="132" x="174" y="276" />
			<control enable="no" halign="left" height="12" name="columnCustomFilter" resize="w" tip="I.E. *.txt" type="edit" width="132" x="174" y="312" />
			<control enable="no" halign="left" height="8" name="columnCustomFilterStatic" title="Custom Filter" type="static" width="66" x="108" y="312" />
		</dialog>
	</resource>
</resources>