function wikiplugin_sheet($data, $params) { global $dbTiki, $tiki_p_edit_sheet, $tiki_p_edit, $tiki_p_admin_sheet, $tiki_p_admin, $prefs, $user, $sheetlib, $page, $tikilib, $smarty; extract($params, EXTR_SKIP); $style = isset($height) ? "height: {$height} !important;" : ''; $style .= isset($width) ? "width: {$width};" : ''; // $urlHeight = (isset($height)) ? "&height=$height" : ''; // $urlHeight .= (isset($width)) ? "&width=$width" : ''; $urlHeight = isset($height) ? "&height=100" : ''; // not setting any height or width in the sheet params created for me the literal '...&height=100%&...' or '...&width=100%&...' in the url with a 400 error (bad request). Hardcoding to 100 (instead of 100%) to avoid this error until a better fix is found $urlHeight .= isset($width) ? "&width=100" : ''; // not setting any height or width in the sheet params created for me the literal '...&height=100%&...' or '...&width=100%&...' in the url with a 400 error (bad request). Hardcoding to 100 (instead of 100%) to avoid this error until a better fix is found $editable = isset($editable) && $editable == 'n' ? false : true; $subsheets = isset($subsheets) && $subsheets == 'n' ? false : true; $class = isset($class) ? " {$class}" : ''; $sheetlib = TikiLib::lib("sheet"); static $index = 0; ++$index; if (empty($id) && empty($url)) { if ($tiki_p_edit_sheet != 'y' || $tiki_p_edit != 'y') { return "<b>missing id parameter for plugin</b><br />"; } else { if (isset($_POST['create_sheet'], $_POST['index']) && $index == $_POST['index']) { // Create a new sheet and rewrite page $sheetId = $sheetlib->replace_sheet(null, tra('New sheet in page: ') . $page, '', $user); $page = htmlentities($page); $content = htmlentities($data); $formId = "form{$index}"; return <<<EOF \t\t\t\t~np~ \t\t\t\t<form id="{$formId}" method="post" action="tiki-wikiplugin_edit.php"> \t\t\t\t<div> \t\t\t\t\t<input type="hidden" name="page" value="{$page}"/> \t\t\t\t\t<input type="hidden" name="content" value="{$data}"/> \t\t\t\t\t<input type="hidden" name="index" value="{$index}"/> \t\t\t\t\t<input type="hidden" name="type" value="sheet"/> \t\t\t\t\t<input type="hidden" name="params[id]" value="{$sheetId}"/> \t\t\t\t</div> \t\t\t\t</form> \t\t\t\t<script type="text/javascript"> \t\t\t\tdocument.getElementById('{$formId}').submit(); \t\t\t\t</script> \t\t\t\t~/np~ EOF; } else { $label = tra('Create New Sheet'); return <<<EOF ~np~ <form method="post" action=""> \t<p> \t\t<input type="submit" name="create_sheet" value="{$label}"/> \t\t<input type="hidden" name="index" value="{$index}"/> \t</p> </form> ~/np~ EOF; } } } $sheet = new TikiSheet(); if (empty($url)) { $info; if (!empty($id)) { $info = $sheetlib->get_sheet_info($id); } if (empty($info)) { return tra("Error loading spreadsheet"); } $objectperms = Perms::get('sheet', $id); if (!$objectperms->view_sheet && !($user && $info['author'] == $user)) { return tra('Permission denied'); } // Build required objects $db = new TikiSheetDatabaseHandler($id); //$out = new TikiSheetOutputHandler($data); // Fetch sheet from database $sheet->import($db); } else { if (!isset($simple)) { $simple = 'y'; } } $calcOff = ''; if (!empty($range)) { $sheet->setRange($range); $calcOff = ',calcOff: true'; } // Grab sheet output if (isset($url)) { $file = file_get_contents($url); $pathInfo = pathinfo($url); if ($pathInfo['extension'] == 'csv') { $handler = new TikiSheetCSVHandler($url); $grid = new TikiSheet(); $grid->import($handler); $ret = $grid->getTableHtml(true, null, false); } else { $ret = file_get_contents($url); } } else { $ret = $sheet->getTableHtml($subsheets); } if (strpos($ret, '<table ') === false) { return '~np~' . $ret . '~/np~'; // return a single cell raw } if (!isset($simple) || $simple != 'y') { global $headerlib; $sheetlib->setup_jquery_sheet(); $headerlib->add_jq_onready('$("div.tiki_sheet").each(function() { $(this).sheet($.extend($.sheet.tikiOptions,{ editable:false' . $calcOff . '})); });'); } $ret = '<div id="tiki_sheet' . $sheet->instance . '" class="tiki_sheet' . $class . '" style="overflow:hidden;' . $style . '">' . $ret . '</div>'; if ($editable && ($objectperms->edit_sheet || $objectperms->admin_sheet || $tiki_p_admin == 'y')) { $smarty->loadPlugin('smarty_function_button'); //If you've given the sheet a url, you can't edit it, disable if not possible if (!isset($url)) { $button_params = array('_text' => tra("Edit Sheet"), '_script' => "tiki-view_sheets.php?sheetId={$id}&parse=edit{$urlHeight}&page={$page}"); } $ret .= smarty_function_button($button_params, $smarty); } return '~np~' . $ret . '~/np~'; }