################################################################################
# CHANGE LOG (last 20 changes)
# 09.09.2022: Compacted gui. Fixed narrow dropdowns. Removed destroy workaround.
# 08.03.2020: Added check for data selected.
# 08.03.2020: Added language support.
# 16.03.2019: Fixed R Check note.
# 03.03.2019: Compacted and tweaked widgets under tcltk.
# 17.02.2019: Fixed Error in if (svalue(savegui_chk)) { : argument is of length zero (tcltk)
# 07.08.2017: Added audit trail.
# 26.07.2017: Added expand=TRUE to save name text field.
# 13.07.2017: Fixed narrow dropdown with hidden argument ellipsize = "none".
# 07.07.2017: Replaced 'droplist' with 'gcombobox'.
# 07.07.2017: Removed argument 'border' for 'gbutton'.
# 10.10.2016: Changed to rbind.fill
# 10.10.2016: Check for column names no longer require identical order.
# 28.08.2015: Added importFrom.
# 11.10.2014: Added 'focus', added 'parent' parameter.
# 29.07.2014: Changed name concatenate_gui -> combine_gui.
# 28.06.2014: Added help button and moved save gui checkbox.
# 08.05.2014: Implemented 'checkDataset'.
# 18.07.2013: Check before overwrite object.
# 11.06.2013: Added 'inherits=FALSE' to 'exists'.
# 17.05.2013: First version.
#' @title Combine Datasets
#'
#' @description
#' GUI for combining two datasets.
#'
#' @details
#' Simple GUI to combine two datasets using the \code{\link{rbind.fill}}
#' function.
#' NB! Datasets must have identical column names but not necessarily
#' in the same order.
#'
#' @param env environment in which to search for data frames.
#' @param debug logical indicating printing debug information.
#' @param parent widget to get focus when finished.
#'
#' @export
#'
#' @importFrom utils help
#' @importFrom plyr rbind.fill
#'
#' @return TRUE
combine_gui <- function(env = parent.frame(), debug = FALSE, parent = NULL) {
# Global variables.
.gData1 <- NULL
.gData2 <- NULL
.gData1Name <- NULL
.gData2Name <- NULL
# Language ------------------------------------------------------------------
# Get this functions name from call.
fnc <- as.character(match.call()[[1]])
if (debug) {
print(paste("IN:", fnc))
}
# Default strings.
strWinTitle <- "Combine datasets"
strChkGui <- "Save GUI settings"
strBtnHelp <- "Help"
strFrmDataset <- "Dataset"
strLblSet1 <- "Dataset 1:"
strDrpDataset <- "<Select dataset>"
strLblColumns <- "columns"
strLblSet2 <- "Dataset 2:"
strFrmSave <- "Save as"
strLblSave <- "Name for result:"
strBtnCalculate <- "Combine"
strMsgColumns <- "Datasets must have identical column names!"
strMsgTitleError <- "Error"
strMsgDataset <- "Two datasets must be selected."
strMsgTitleDataset <- "Dataset not selected"
# Get strings from language file.
dtStrings <- getStrings(gui = fnc)
# If language file is found.
if (!is.null(dtStrings)) {
# Get language strings, use default if not found.
strtmp <- dtStrings["strWinTitle"]$value
strWinTitle <- ifelse(is.na(strtmp), strWinTitle, strtmp)
strtmp <- dtStrings["strChkGui"]$value
strChkGui <- ifelse(is.na(strtmp), strChkGui, strtmp)
strtmp <- dtStrings["strBtnHelp"]$value
strBtnHelp <- ifelse(is.na(strtmp), strBtnHelp, strtmp)
strtmp <- dtStrings["strFrmDataset"]$value
strFrmDataset <- ifelse(is.na(strtmp), strFrmDataset, strtmp)
strtmp <- dtStrings["strLblSet1"]$value
strLblSet1 <- ifelse(is.na(strtmp), strLblSet1, strtmp)
strtmp <- dtStrings["strDrpDataset"]$value
strDrpDataset <- ifelse(is.na(strtmp), strDrpDataset, strtmp)
strtmp <- dtStrings["strLblColumns"]$value
strLblColumns <- ifelse(is.na(strtmp), strLblColumns, strtmp)
strtmp <- dtStrings["strLblSet2"]$value
strLblSet2 <- ifelse(is.na(strtmp), strLblSet2, strtmp)
strtmp <- dtStrings["strFrmSave"]$value
strFrmSave <- ifelse(is.na(strtmp), strFrmSave, strtmp)
strtmp <- dtStrings["strLblSave"]$value
strLblSave <- ifelse(is.na(strtmp), strLblSave, strtmp)
strtmp <- dtStrings["strBtnCalculate"]$value
strBtnCalculate <- ifelse(is.na(strtmp), strBtnCalculate, strtmp)
strtmp <- dtStrings["strMsgColumns"]$value
strMsgColumns <- ifelse(is.na(strtmp), strMsgColumns, strtmp)
strtmp <- dtStrings["strMsgTitleError"]$value
strMsgTitleError <- ifelse(is.na(strtmp), strMsgTitleError, strtmp)
strtmp <- dtStrings["strMsgDataset"]$value
strMsgDataset <- ifelse(is.na(strtmp), strMsgDataset, strtmp)
strtmp <- dtStrings["strMsgTitleDataset"]$value
strMsgTitleDataset <- ifelse(is.na(strtmp), strMsgTitleDataset, strtmp)
}
# WINDOW ####################################################################
# Main window.
w <- gwindow(title = strWinTitle, visible = FALSE)
# Runs when window is closed.
addHandlerUnrealize(w, handler = function(h, ...) {
# Save GUI state.
# .saveSettings()
# Focus on parent window.
if (!is.null(parent)) {
focus(parent)
}
# Destroy window.
return(FALSE)
})
# Vertical main group.
gv <- ggroup(
horizontal = FALSE,
spacing = 1,
use.scrollwindow = FALSE,
container = w,
expand = FALSE
)
# Help button group.
gh <- ggroup(container = gv, expand = FALSE, fill = "both")
savegui_chk <- gcheckbox(text = strChkGui, checked = FALSE, container = gh)
addSpring(gh)
help_btn <- gbutton(text = strBtnHelp, container = gh)
addHandlerChanged(help_btn, handler = function(h, ...) {
# Open help page for function.
print(help(fnc, help_type = "html"))
})
# DATASET ###################################################################
f0 <- gframe(
text = strFrmDataset,
horizontal = FALSE,
spacing = 1,
container = gv
)
# DATASET 1 -----------------------------------------------------------------
f0g0 <- ggroup(container = f0, spacing = 1, expand = TRUE, fill = "x")
glabel(text = strLblSet1, container = f0g0)
data1_col_lbl <- glabel(
text = paste(" 0", strLblColumns),
container = f0g0
)
data1_drp <- gcombobox(
items = c(
strDrpDataset,
listObjects(
env = env,
obj.class = "data.frame"
)
),
selected = 1,
editable = FALSE,
container = f0g0,
ellipsize = "none",
expand = TRUE,
fill = "x"
)
addHandlerChanged(data1_drp, handler = function(h, ...) {
val_obj <- svalue(data1_drp)
# Check if suitable.
ok <- checkDataset(
name = val_obj, reqcol = NULL,
env = env, parent = w, debug = debug
)
if (ok) {
# Load or change components.
.gData1 <<- get(val_obj, envir = env)
.gData1Name <<- val_obj
svalue(data1_col_lbl) <- paste(" ", ncol(.gData1), strLblColumns)
svalue(save_edt) <- paste(.gData1Name, .gData2Name, sep = "_")
} else {
.gData1 <<- NULL
.gData1Name <<- NULL
svalue(data1_col_lbl) <- paste(" 0", strLblColumns)
svalue(save_edt) <- ""
}
})
# DATASET 2 -----------------------------------------------------------------
f0g1 <- ggroup(container = f0, spacing = 1, expand = TRUE, fill = "x")
glabel(text = strLblSet2, container = f0g1)
data2_col_lbl <- glabel(
text = paste(" 0", strLblColumns),
container = f0g1
)
data2_drp <- gcombobox(
items = c(
strDrpDataset,
listObjects(
env = env,
obj.class = "data.frame"
)
),
selected = 1,
editable = FALSE,
container = f0g1,
ellipsize = "none",
expand = TRUE,
fill = "x"
)
addHandlerChanged(data2_drp, handler = function(h, ...) {
val_obj <- svalue(data2_drp)
if (exists(val_obj, envir = env, inherits = FALSE)) {
.gData2 <<- get(val_obj, envir = env)
.gData2Name <<- val_obj
svalue(data2_col_lbl) <- paste(" ", ncol(.gData2), strLblColumns)
svalue(save_edt) <- paste(.gData1Name, .gData2Name, sep = "_")
} else {
.gData2 <<- NULL
.gData1Name <<- NULL
svalue(data2_col_lbl) <- paste(" 0", strLblColumns)
svalue(save_edt) <- ""
}
})
# FRAME 1 ###################################################################
# # No options yet.
# f1 <- gframe("Options", horizontal=FALSE, container=gv)
#
# f1g0 <- glayout(container = f1, expand=TRUE, fill="both")
# SAVE ######################################################################
save_frame <- gframe(text = strFrmSave, container = gv)
glabel(text = strLblSave, container = save_frame)
save_edt <- gedit(expand = TRUE, fill = TRUE, container = save_frame)
# BUTTON ####################################################################
combine_btn <- gbutton(text = strBtnCalculate, container = gv)
addHandlerChanged(combine_btn, handler = function(h, ...) {
datOk <- all(!is.null(.gData1), !is.null(.gData2))
colOk <- all(names(.gData1) %in% names(.gData2))
val_data_1 <- .gData1Name
val_data_2 <- .gData2Name
val_name <- svalue(save_edt)
if (colOk && datOk) {
# Combine the datasets.
datanew <- plyr::rbind.fill(.gData1, .gData2)
# Create key-value pairs to log.
keys <- list("data1", "data2")
values <- list(val_data_1, val_data_2)
# Update audit trail.
datanew <- auditTrail(
obj = datanew, key = keys, value = values,
label = fnc, arguments = FALSE,
package = "strvalidator"
)
# Save data.
saveObject(name = val_name, object = datanew, parent = w, env = env)
if (debug) {
print(datanew)
print(paste("EXIT:", fnc))
}
# Close GUI.
# .saveSettings()
dispose(w)
} else if (!colOk) {
gmessage(
msg = strMsgColumns,
title = strMsgTitleError,
icon = "error"
)
} else if (!datOk) {
gmessage(
msg = strMsgDataset,
title = strMsgTitleDataset,
icon = "error"
)
}
})
# Show GUI.
visible(w) <- TRUE
focus(w)
} # End of GUI
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.