' . $flashMessage->render(); + } + } + } + + return $content; + } + + /** + * Gemeral overview over the task in the taskcenter menu + * + * @return string Overview as HTML + */ + public function getOverview() { + $content = '
' . $GLOBALS['LANG']->getLL('description') . '
'; + + // get the actions + $lines = $this->getActions(); + if (count($lines) > 0) { + $items = ''; + + // render a single action menu item + foreach ($lines as $line) { + $active = (t3lib_div::_GP('show') === $line['uid']) ? ' class="active" ' : ''; + $items .= '- ' . $items . '
+ ' . + '
', $errors), + $GLOBALS['LANG']->getLL('action_error'), + t3lib_FlashMessage::ERROR + ); + $content .= $flashMessage->render() . '
'; + } else { + // save user + $key = $this->saveNewBackendUser($record, $vars); + + // success messsage + $flashMessage = t3lib_div::makeInstance ( + 't3lib_FlashMessage', + ($vars['key'] === 'NEW' ? $GLOBALS['LANG']->getLL('success-user-created') : $GLOBALS['LANG']->getLL('success-user-updated')), + $GLOBALS['LANG']->getLL('success'), + t3lib_FlashMessage::OK + ); + $content .= $flashMessage->render() . '
' ; + } + + } + + + // load BE user to edit + if (intval(t3lib_div::_GP('be_users_uid')) > 0) { + $tmpUserId = intval(t3lib_div::_GP('be_users_uid')); + + $rawRecord = $this->isCreatedByUser($tmpUserId, $record); + + if ($rawRecord) { + // delete user + if (t3lib_div::_GP('delete') == 1) { + $this->deleteUser($tmpUserId, $record['uid']); + } + + $key = $tmpUserId; + $vars = $rawRecord; + } + + } + + $this->JScode(); + $loadDB = t3lib_div::makeInstance('t3lib_loadDBGroup'); + $loadDB->start($vars['db_mountpoints'], 'pages'); + + $content .= ''; + + $content .= $this->getCreatedUsers($record, $key); + + return $content; + } + + /** + * Delete a BE user and redirect to the action by its id + * + * @param int $userId: Id of the BE user + * @param int $actionId: Id of the action + * @return void + */ + protected function deleteUser($userId, $actionId) { + $GLOBALS['TYPO3_DB']->exec_UPDATEquery( + 'be_users', + 'uid=' . $userId, + array ( + 'deleted' => 1, + 'tstamp' => $GLOBALS['ACCESS_TIME'] + ) + ); + + // redirect to the original task + $redirectUrl = 'index.php?show=' . $actionId; + t3lib_utility_Http::redirect($redirectUrl); + } + + /** + * Check if a BE user is created by the current user + * + * @param int $id: Id of the BE user + * @param array $action: sys_action record. + * @return mixed the record of the BE user if found, otherwise false + */ + protected function isCreatedByUser($id, $action) { + $record = t3lib_BEfunc::getRecord( + 'be_users', + $id, + '*', + ' AND cruser_id=' . $GLOBALS['BE_USER']->user['uid'] . ' AND createdByAction=' . intval($action['uid']) + ); + + if (is_array($record)) { + return $record; + } else { + return FALSE; + } + } + + + /** + * Render all users who are created by the current BE user including a link to edit the record + * + * @param array $action: sys_action record. + * @param int $selectedUser: Id of a selected user + * @return html list of users + */ + protected function getCreatedUsers($action, $selectedUser) { + $content = ''; + $lines = array(); + + // List of users + $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery( + '*', + 'be_users', + 'cruser_id=' . $GLOBALS['BE_USER']->user['uid'] . ' AND createdByAction=' . intval($action['uid']) . t3lib_BEfunc::deleteClause('be_users'), + '', + 'username' + ); + + // render the user records + while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) { + $icon = t3lib_iconworks::getIconImage('be_users', $row, $GLOBALS['BACK_PATH'], 'title="uid=' . $row['uid'] . '" hspace="2" align="top"'); + $line = $icon . $this->action_linkUserName($row['username'], $row['realName'], $action['uid'], $row['uid']); + + // selected user + if ($row['uid'] == $selectedUser) { + $line = '' . $line . ''; + } + + $lines[] = $line; + } + $GLOBALS['TYPO3_DB']->sql_free_result($res); + + // if any records found + if (count($lines)) { + $content .= '
' . $this->taskObject->doc->section($GLOBALS['LANG']->getLL('action_t1_listOfUsers'), implode('
', $lines)); + } + + return $content; + } + + + /** + * Create a link to edit a user + * + * @param string $username: Username + * @param string $realName: Real name of the user + * @param int $sysActionUid: Id of the sys_action record + * @param int $userId: Id of the user + * @return html link + */ + protected function action_linkUserName($username, $realName, $sysActionUid, $userId) { + if (!empty($realName)) { + $username .= ' (' . $realName . ')'; + } + + // link to update the user record + $href = 'index.php?SET[function]=sys_action.tasks&show=' . intval($sysActionUid) . '&be_users_uid=' . intval($userId); + $link = '' . htmlspecialchars($username) . ''; + + // link to delete the user record + $onClick = ' onClick="return confirm('.$GLOBALS['LANG']->JScharCode($GLOBALS['LANG']->getLL("lDelete_warning")).');"'; + $link .= ' + +
' . $GLOBALS['LANG']->getLL('action_download_file') . ''; + } + } else { + $actionContent .= $GLOBALS['TYPO3_DB']->sql_error(); + } + + // Admin users are allowed to see and edit the query + if ($GLOBALS['BE_USER']->isAdmin()) { + $actionContent .= '
' . $fullsearch->tableWrap($sql_query['qSelect']); + $actionContent .= '
+
'; + } + + $content .= $this->taskObject->doc->section($GLOBALS['LANG']->getLL('action_t2_result'), $actionContent, 0, 1); + } else { + // query is not configured + $flashMessage = t3lib_div::makeInstance ( + 't3lib_FlashMessage', + $GLOBALS['LANG']->getLL('action_notReady', true), + $GLOBALS['LANG']->getLL('action_error'), + t3lib_FlashMessage::ERROR + ); + $content .= '
' . $flashMessage->render(); + } + } else { + // required sysext lowlevel is not installed + $flashMessage = t3lib_div::makeInstance ( + 't3lib_FlashMessage', + $GLOBALS['LANG']->getLL('action_lowlevelMissing', true), + $GLOBALS['LANG']->getLL('action_error'), + t3lib_FlashMessage::ERROR + ); + $content .= '
' . $flashMessage->render(); + } + return $content; + } + + /** + * Action to create a list of records of a specific table and pid + * + * @param array $record: sys_action record + * @return string list of records + */ + protected function viewRecordList($record) { + $content = ''; + + $this->id = intval($record['t3_listPid']); + $this->table = $record['t3_tables']; + + if ($this->id == 0 || $this->table == '') { + $flashMessage = t3lib_div::makeInstance( + 't3lib_FlashMessage', + $GLOBALS['LANG']->getLL('action_lowlevelMissing', true), + $GLOBALS['LANG']->getLL('action_error'), + t3lib_FlashMessage::ERROR + ); + $content .= '
' . $flashMessage->render(); + + return $content; + } + + require_once($GLOBALS['BACK_PATH'] . 'class.db_list.inc'); + require_once($GLOBALS['BACK_PATH'] . 'class.db_list_extra.inc'); + + + // Start document template object: +// $this->doc = t3lib_div::makeInstance('template'); + + // Loading current page record and checking access: + $this->pageinfo = t3lib_BEfunc::readPageAccess($this->id,$this->taskObject->perms_clause); + $access = is_array($this->pageinfo) ? 1 : 0; + + + // If there is access to the page, then render the list contents and set up the document template object: + if ($access) { + // Initialize the dblist object: + $dblist = t3lib_div::makeInstance('localRecordList'); + $dblist->script = t3lib_div::getIndpEnv('REQUEST_URI'); + $dblist->backPath = $GLOBALS['BACK_PATH']; + $dblist->calcPerms = $GLOBALS['BE_USER']->calcPerms($this->pageinfo); + $dblist->thumbs = $GLOBALS['BE_USER']->uc['thumbnailsByDefault']; + $dblist->returnUrl=$this->taskObject->returnUrl; + $dblist->allFields = 1; + $dblist->localizationView = 1; + $dblist->showClipboard = 0; + $dblist->disableSingleTableView = 1; + $dblist->pageRow = $this->pageinfo; + $dblist->counter++; + $dblist->MOD_MENU = array('bigControlPanel' => '', 'clipBoard' => '', 'localization' => ''); + $dblist->modTSconfig = $this->taskObject->modTSconfig; + $dblist->dontShowClipControlPanels = $CLIENT['FORMSTYLE'] && !$this->taskObject->MOD_SETTINGS['bigControlPanel'] && $dblist->clipObj->current=='normal' && !$GLOBALS['BE_USER']->uc['disableCMlayers'] && !$this->modTSconfig['properties']['showClipControlPanelsDespiteOfCMlayers']; + + // Initialize the listing object, dblist, for rendering the list: + $this->pointer = t3lib_div::intInRange($this->taskObject->pointer,0,100000); + $dblist->start($this->id,$this->table,$this->pointer,$this->taskObject->search_field,$this->taskObject->search_levels,$this->taskObject->showLimit); + $dblist->setDispFields(); + + // Render the list of tables: + $dblist->generateList(); + + // Add JavaScript functions to the page: + $this->taskObject->doc->JScode=$this->taskObject->doc->wrapScriptTags(' + + function jumpToUrl(URL) { + window.location.href = URL; + return false; + } + function jumpExt(URL,anchor) { + var anc = anchor?anchor:""; + window.location.href = URL+(T3_THIS_LOCATION?"&returnUrl="+T3_THIS_LOCATION:"")+anc; + return false; + } + function jumpSelf(URL) { + window.location.href = URL+(T3_RETURN_URL?"&returnUrl="+T3_RETURN_URL:""); + return false; + } + + function setHighlight(id) { + top.fsMod.recentIds["web"]=id; + top.fsMod.navFrameHighlightedID["web"]="pages"+id+"_"+top.fsMod.currentBank; // For highlighting + + if (top.content && top.content.nav_frame && top.content.nav_frame.refresh_nav) { + top.content.nav_frame.refresh_nav(); + } + } + + ' . $dblist->CBfunctions() . ' + function editRecords(table,idList,addParams,CBflag) { + window.location.href="' . $GLOBALS['BACK_PATH'] . 'alt_doc.php?returnUrl=' . rawurlencode(t3lib_div::getIndpEnv('REQUEST_URI')) . + '&edit["+table+"]["+idList+"]=edit"+addParams; + } + function editList(table,idList) { + var list=""; + + // Checking how many is checked, how many is not + var pointer=0; + var pos = idList.indexOf(","); + while (pos!=-1) { + if (cbValue(table+"|"+idList.substr(pointer,pos-pointer))) { + list+=idList.substr(pointer,pos-pointer)+","; + } + pointer=pos+1; + pos = idList.indexOf(",",pointer); + } + if (cbValue(table+"|"+idList.substr(pointer))) { + list+=idList.substr(pointer)+","; + } + + return list ? list : idList; + } + T3_THIS_LOCATION = "' . rawurlencode(t3lib_div::getIndpEnv('REQUEST_URI')) . '"; + + if (top.fsMod) top.fsMod.recentIds["web"] = ' . intval($this->id) . '; + '); + + // Setting up the context sensitive menu: + $this->taskObject->doc->getContextMenuCode(); + + + // Begin to compile the whole page + $content .= ''; + + // If a listing was produced, create the page footer with search form etc: + if ($dblist->HTMLcode) { + + // Making field select box (when extended view for a single table is enabled): + if ($dblist->table) { + $tmpBackpath = $GLOBALS['BACK_PATH']; + $GLOBALS['BACK_PATH'] = ''; + $content .= $dblist->fieldSelectBox($dblist->table); + $GLOBALS['BACK_PATH'] = $tmpBackpath; + } + } + } else { + // not enough rights to access the list view or the page + $flashMessage = t3lib_div::makeInstance( + 't3lib_FlashMessage', + $GLOBALS['LANG']->getLL('action_error-access', true), + $GLOBALS['LANG']->getLL('action_error'), + t3lib_FlashMessage::ERROR + ); + $content .= $flashMessage->render(); + } + + return $content; + } + +} + + +if (defined('TYPO3_MODE') && $TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['ext/sys_action/task/class.tx_sysaction_task.php']) { + include_once($TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['ext/sys_action/task/class.tx_sysaction_task.php']); +} + +?> \ No newline at end of file Index: typo3/sysext/sys_action/tca.php =================================================================== --- typo3/sysext/sys_action/tca.php (revision 7339) +++ typo3/sysext/sys_action/tca.php (working copy) @@ -3,89 +3,91 @@ // ****************************************************************** // sys_action // ****************************************************************** -$TCA['sys_action'] = Array ( +$TCA['sys_action'] = array ( 'ctrl' => $TCA['sys_action']['ctrl'], - 'interface' => Array ( + 'interface' => array ( 'showRecordFieldList' => 'hidden,title,type,description,assign_to_groups' ), - 'columns' => Array ( - 'title' => Array ( + 'columns' => array ( + 'title' => array ( 'label' => 'LLL:EXT:lang/locallang_general.php:LGL.title', - 'config' => Array ( + 'config' => array ( 'type' => 'input', 'size' => '25', 'max' => '256', 'eval' => 'trim,required' ) ), - 'description' => Array ( + 'description' => array ( 'label' => 'LLL:EXT:lang/locallang_general.php:LGL.description', - 'config' => Array ( + 'config' => array ( 'type' => 'text', 'rows' => 10, 'cols' => 48 ) ), - 'hidden' => Array ( + 'hidden' => array ( 'label' => 'LLL:EXT:sys_action/locallang_tca.php:sys_action.hidden', - 'config' => Array ( + 'config' => array ( 'type' => 'check' ) ), - 'type' => Array ( + 'type' => array ( 'label' => 'LLL:EXT:lang/locallang_general.php:LGL.type', - 'config' => Array ( + 'config' => array ( 'type' => 'select', - 'items' => Array ( - Array('', '0'), - Array('Create Backend User', '1'), - Array('SQL-query', '2'), - Array('Record list', '3'), - Array('Edit records', '4'), - Array('New Record', '5') + 'items' => array ( + array('', '0'), + array('LLL:EXT:sys_action/locallang_tca.php:sys_action.type.1', '1'), + array('LLL:EXT:sys_action/locallang_tca.php:sys_action.type.2', '2'), + array('LLL:EXT:sys_action/locallang_tca.php:sys_action.type.3', '3'), + array('LLL:EXT:sys_action/locallang_tca.php:sys_action.type.4', '4'), + array('LLL:EXT:sys_action/locallang_tca.php:sys_action.type.5', '5') ) ) ), - 'assign_to_groups' => Array ( + 'assign_to_groups' => array ( 'label' => 'LLL:EXT:sys_action/locallang_tca.php:sys_action.assign_to_groups', - 'config' => Array ( + 'config' => array ( 'type' => 'select', 'foreign_table' => 'be_groups', 'foreign_table_where' => 'ORDER BY be_groups.title', 'MM' => 'sys_action_asgr_mm', - 'size' => '5', + 'size' => '10', 'minitems' => '0', - 'maxitems' => '200' + 'maxitems' => '200', + 'autoSizeMax' => '10' ) ), - 't1_userprefix' => Array ( + 't1_userprefix' => array ( 'label' => 'LLL:EXT:sys_action/locallang_tca.php:sys_action.t1_userprefix', - 'config' => Array ( + 'config' => array ( 'type' => 'input', 'size' => '25', 'max' => '10', 'eval' => 'trim' ) ), - 't1_allowed_groups' => Array ( + 't1_allowed_groups' => array ( 'label' => 'LLL:EXT:sys_action/locallang_tca.php:sys_action.t1_allowed_groups', - 'config' => Array ( + 'config' => array ( 'type' => 'select', 'foreign_table' => 'be_groups', 'foreign_table_where' => 'ORDER BY be_groups.title', - 'size' => '2', - 'maxitems' => '20' + 'size' => '10', + 'maxitems' => '20', + 'autoSizeMax' => '10' ) ), - 't1_create_user_dir' => Array ( + 't1_create_user_dir' => array ( 'label' => 'LLL:EXT:sys_action/locallang_tca.php:sys_action.t1_create_user_dir', - 'config' => Array ( + 'config' => array ( 'type' => 'check' ) ), - 't1_copy_of_user' => Array ( + 't1_copy_of_user' => array ( 'label' => 'LLL:EXT:sys_action/locallang_tca.php:sys_action.t1_copy_of_user', - 'config' => Array ( + 'config' => array ( 'type' => 'group', 'internal_type' => 'db', 'allowed' => 'be_users', @@ -100,9 +102,9 @@ ) ) ), - 't3_listPid' => Array ( + 't3_listPid' => array ( 'label' => 'LLL:EXT:sys_action/locallang_tca.php:sys_action.t3_listPid', - 'config' => Array ( + 'config' => array ( 'type' => 'group', 'internal_type' => 'db', 'allowed' => 'pages', @@ -117,19 +119,19 @@ ) ) ), - 't3_tables' => Array ( + 't3_tables' => array ( 'label' => 'LLL:EXT:sys_action/locallang_tca.php:sys_action.t3_tables', - 'config' => Array ( + 'config' => array ( 'type' => 'select', 'special' => 'tables', - 'items' => Array ( - Array('','') + 'items' => array ( + array('','') ) ) ), - 't4_recordsToEdit' => Array ( + 't4_recordsToEdit' => array ( 'label' => 'LLL:EXT:sys_action/locallang_tca.php:sys_action.t4_recordsToEdit', - 'config' => Array ( + 'config' => array ( 'type' => 'group', 'internal_type' => 'db', 'allowed' => '*', @@ -137,18 +139,23 @@ 'size' => '5', 'maxitems' => '50', 'minitems' => '1', - 'show_thumbs' => '1' + 'show_thumbs' => '1', + 'wizards' => array( + 'suggest' => array( + 'type' => 'suggest', + ) + ) ) ), ), - 'types' => Array ( - '0' => Array('showitem' => 'hidden;;;;1-1-1,type,title;;;;2-2-2'), - '1' => Array('showitem' => 'hidden;;;;1-1-1,type,title;;;;2-2-2,description;;;;3-3-3,assign_to_groups,--div--,t1_userprefix;;;;5-5-5,t1_copy_of_user,t1_allowed_groups,t1_create_user_dir'), - '2' => Array('showitem' => 'hidden;;;;1-1-1,type,title;;;;2-2-2,description;;;;3-3-3,assign_to_groups,--div--,'), - '3' => Array('showitem' => 'hidden;;;;1-1-1,type,title;;;;2-2-2,description;;;;3-3-3,assign_to_groups,--div--,t3_listPid;;;;5-5-5,t3_tables;'), - '4' => Array('showitem' => 'hidden;;;;1-1-1,type,title;;;;2-2-2,description;;;;3-3-3,assign_to_groups,--div--,t4_recordsToEdit;;;;5-5-5'), - '5' => Array('showitem' => 'hidden;;;;1-1-1,type,title;;;;2-2-2,description;;;;3-3-3,assign_to_groups,--div--,t3_listPid;Where to create records:;;;5-5-5,t3_tables;Create records in table:'), + 'types' => array ( + '0' => array('showitem' => 'hidden;;;;1-1-1,type,title;;;;2-2-2'), + '1' => array('showitem' => 'hidden;;;;1-1-1,type,title;;;;2-2-2,description;;;;3-3-3,assign_to_groups,--div--,t1_userprefix;;;;5-5-5,t1_copy_of_user,t1_allowed_groups,t1_create_user_dir'), + '2' => array('showitem' => 'hidden;;;;1-1-1,type,title;;;;2-2-2,description;;;;3-3-3,assign_to_groups,--div--,'), + '3' => array('showitem' => 'hidden;;;;1-1-1,type,title;;;;2-2-2,description;;;;3-3-3,assign_to_groups,--div--,t3_listPid;;;;5-5-5,t3_tables;'), + '4' => array('showitem' => 'hidden;;;;1-1-1,type,title;;;;2-2-2,description;;;;3-3-3,assign_to_groups,--div--,t4_recordsToEdit;;;;5-5-5'), + '5' => array('showitem' => 'hidden;;;;1-1-1,type,title;;;;2-2-2,description;;;;3-3-3,assign_to_groups,--div--,t3_listPid;Where to create records:;;;5-5-5,t3_tables;Create records in table:'), ) ); -?> +?> \ No newline at end of file Index: typo3/sysext/sys_action/toolbarmenu/class.tx_sysaction_toolbarmenu.php =================================================================== --- typo3/sysext/sys_action/toolbarmenu/class.tx_sysaction_toolbarmenu.php (revision 7339) +++ typo3/sysext/sys_action/toolbarmenu/class.tx_sysaction_toolbarmenu.php (working copy) @@ -77,7 +77,7 @@ if ($actionEntries) { $this->addJavascriptToBackend(); $this->addCssToBackend(); - $title = $GLOBALS['LANG']->getLL('action_toolbaritem', true); + $title = $GLOBALS['LANG']->getLL('action_toolbaritem', TRUE); $actionMenu[] = '