/**
* getFieldValues
*/
public function getValues()
{
$values = array('title' => $this->table->getTitle(), 'add_perm' => $this->table->getAddPerm(), 'edit_perm' => $this->table->getEditPerm(), 'delete_perm' => $this->table->getDeletePerm(), 'edit_by_owner' => $this->table->getEditByOwner(), 'export_enabled' => $this->table->getExportEnabled(), 'limited' => $this->table->getLimited(), 'limit_start' => array("date" => substr($this->table->getLimitStart(), 0, 10), "time" => substr($this->table->getLimitStart(), -8)), 'limit_end' => array("date" => substr($this->table->getLimitEnd(), 0, 10), "time" => substr($this->table->getLimitEnd(), -8)), 'is_visible' => $this->table->getIsVisible(), 'default_sort_field' => $this->table->getDefaultSortField(), 'default_sort_field_order' => $this->table->getDefaultSortFieldOrder(), 'description' => $this->table->getDescription(), 'public_comments' => $this->table->getPublicCommentsEnabled(), 'view_own_records_perm' => $this->table->getViewOwnRecordsPerm());
if (!$this->table->getLimitStart()) {
$values['limit_start'] = NULL;
}
if (!$this->table->getLimitEnd()) {
$values['limit_end'] = NULL;
}
$this->form->setValuesByArray($values);
}
/**
* getFieldValues
*/
public function getValues()
{
$values = array('title' => $this->table->getTitle(), 'add_perm' => $this->table->getAddPerm(), 'edit_perm' => $this->table->getEditPerm(), 'delete_perm' => $this->table->getDeletePerm(), 'edit_by_owner' => $this->table->getEditByOwner(), 'export_enabled' => $this->table->getExportEnabled(), 'limited' => $this->table->getLimited(), 'limit_start' => array("date" => substr($this->table->getLimitStart(), 0, 10), "time" => substr($this->table->getLimitStart(), -8)), 'limit_end' => array("date" => substr($this->table->getLimitEnd(), 0, 10), "time" => substr($this->table->getLimitEnd(), -8)), 'is_visible' => $this->table->getIsVisible(), 'description' => $this->table->getDescription());
if (!$this->table->getLimitStart()) {
$values['limit_start'] = NULL;
}
if (!$this->table->getLimitEnd()) {
$values['limit_end'] = NULL;
}
$this->form->setValuesByArray($values);
}
public function listRecords()
{
global $tpl, $lng, $ilToolbar;
/**
* @var $ilToolbar ilToolbarGUI
* @var $ilToolbar ilToolbarGUI
*/
// Show tables
require_once "./Modules/DataCollection/classes/class.ilDataCollectionTable.php";
if (ilObjDataCollection::_hasWriteAccess($this->parent_obj->ref_id)) {
$tables = $this->parent_obj->object->getTables();
} else {
$tables = $this->parent_obj->object->getVisibleTables();
}
$options = array();
foreach ($tables as $table) {
$options[$table->getId()] = $table->getTitle();
}
$tpl->addCss("./Modules/DataCollection/css/dcl_reference_hover.css");
$list = new ilDataCollectionRecordListTableGUI($this, "listRecords", $this->table_obj, $this->mode);
$list->setExternalSegmentation(true);
$list->setExternalSorting(true);
$list->determineLimit();
$list->determineOffsetAndOrder();
$data = $this->table_obj->getPartialRecords($list->getOrderField(), $list->getOrderDirection(), $list->getLimit(), $list->getOffset(), $list->getFilter());
$records = $data['records'];
$total = $data['total'];
$list->setMaxCount($total);
$list->setRecordData($records);
if (count($options) > 0) {
include_once './Services/Form/classes/class.ilSelectInputGUI.php';
$table_selection = new ilSelectInputGUI('', 'table_id');
$table_selection->setOptions($options);
$table_selection->setValue($this->table_id);
$ilToolbar->setFormAction($this->ctrl->getFormActionByClass("ilDataCollectionRecordListGUI", "doTableSwitch"));
$ilToolbar->addText($lng->txt("dcl_table"));
$ilToolbar->addInputItem($table_selection);
$ilToolbar->addFormButton($lng->txt('change'), 'doTableSwitch');
$ilToolbar->addSeparator();
}
$permission_to_add_or_import = $this->table_obj->hasPermissionToAddRecord($this->parent_obj->ref_id) and $this->table_obj->hasCustomFields();
if ($permission_to_add_or_import) {
$this->ctrl->setParameterByClass("ildatacollectionrecordeditgui", "record_id", NULL);
$add_new = ilLinkButton::getInstance();
$add_new->setCaption("dcl_add_new_record");
$add_new->setUrl($this->ctrl->getFormActionByClass("ildatacollectionrecordeditgui", "create"));
// $add_new->addCSSClass('emphsubmit');
$ilToolbar->addButtonInstance($add_new);
}
if ($this->table_obj->getExportEnabled() or $this->table_obj->hasPermissionToFields($this->parent_obj->ref_id)) {
$export = ilDataCollectionLinkButton::getInstance();
$export->setCaption("dcl_export_table_excel");
$export->setUrl($this->ctrl->getFormActionByClass("ildatacollectionrecordlistgui", "exportExcel"));
if (count($this->table_obj->getExportableFields()) == 0 or $total == 0) {
$export->setUseWrapper(true);
$export->setDisabled(true);
$export->addAttribute('data-toggle', 'datacollection-tooltip', true);
$export->addAttribute('data-placement', 'bottom', true);
$export->addAttribute('title', $lng->txt('dcl_no_exportable_fields_or_no_data'), true);
}
$ilToolbar->addButtonInstance($export);
}
if ($permission_to_add_or_import) {
$this->ctrl->setParameterByClass("ildatacollectionrecordeditgui", "record_id", NULL);
$import = ilLinkButton::getInstance();
$import->setCaption("dcl_import_records .xls");
$import->setUrl($this->ctrl->getFormActionByClass("ildatacollectionrecordlistgui", "showImportExcel"));
$ilToolbar->addButtonInstance($import);
}
// requested not to implement this way...
//$tpl->addJavaScript("Modules/DataCollection/js/fastTableSwitcher.js");
if (count($this->table_obj->getRecordFields()) == 0) {
ilUtil::sendInfo($lng->txt("dcl_no_fields_yet") . " " . ($this->table_obj->hasPermissionToFields($this->parent_obj->ref_id) ? $lng->txt("dcl_create_fields") : ""));
}
$tpl->getStandardTemplate();
$tpl->setPermanentLink("dcl", $this->parent_obj->ref_id);
if ($desc = $this->table_obj->getDescription()) {
$desc = "<div class='ilDclTableDescription'>{$desc}</div>";
}
$tpl->setContent($desc . $list->getHTML());
}
/**
* @param ilDataCollectionTable $original
*/
public function cloneStructure(ilDataCollectionTable $original)
{
$this->setTitle($original->getTitle());
$this->setDescription($original->getDescription());
$this->setIsVisible($original->getIsVisible());
$this->setEditByOwner($original->getEditByOwner());
$this->setAddPerm($original->getAddPerm());
$this->setEditPerm($original->getEditPerm());
$this->setDeletePerm($original->getDeletePerm());
$this->setLimited($original->getLimited());
$this->setLimitStart($original->getLimitStart());
$this->setLimitEnd($original->getLimitEnd());
$this->setViewOwnRecordsPerm($original->getViewOwnRecordsPerm());
$this->setExportEnabled($original->getExportEnabled());
$this->setPublicCommentsEnabled($original->getPublicCommentsEnabled());
$this->setDefaultSortFieldOrder($original->getDefaultSortFieldOrder());
$this->doCreate();
// reset stdFields to get new for the created object
$default_sort_field = 0;
// Clone standard-fields
$org_std_fields = $original->getStandardFields();
foreach ($this->getStandardFields() as $element_key => $std_field) {
$std_field->cloneStructure($org_std_fields[$element_key]);
if ($std_field->getId() == $original->getDefaultSortField()) {
$default_sort_field = $std_field->getId();
}
}
// Clone fields
$new_fields = array();
foreach ($original->getFields() as $orig_field) {
if (!$orig_field->isStandardField()) {
$new_field = new ilDataCollectionField();
$new_field->setTableId($this->getId());
$new_field->cloneStructure($orig_field->getId());
$new_fields[$orig_field->getId()] = $new_field;
if ($orig_field->getId() == $original->getDefaultSortField()) {
$default_sort_field = $new_field->getId();
}
}
}
$this->setDefaultSortField($default_sort_field);
$this->doUpdate();
//TODO: Find better way to copy data (include referenced data)
// Clone Records with recordfields
/*foreach($original->getRecords() as $orig_record){
$new_record = new ilDataCollectionRecord();
$new_record->setTableId($this->getId());
$new_record->cloneStructure($orig_record->getId(), $new_fields);
}*/
if ($old_view_id = ilDataCollectionRecordViewViewdefinition::getIdByTableId($original->getId())) {
$old_view = new ilDataCollectionRecordViewViewdefinition($old_view_id);
$old_view->setTableId($original->getId());
$viewdef = new ilDataCollectionRecordViewViewdefinition();
$viewdef->setTableId($this->id);
$viewdef->setXMLContent($old_view->getXMLContent(false));
$viewdef->create();
}
}
