}
// Tells TBS to display information when the document is merged. No exit.
// --------------------------------------------
// Merging and other operations on the template
// --------------------------------------------
// Select slide #2
$TBS->Plugin(OPENTBS_SELECT_SLIDE, 2);
// Change a picture using the command (it can also be done at the template side using parameter "ope=changepic")
$TBS->Plugin(OPENTBS_CHANGE_PICTURE, '#merge_me#', 'pic_1234f.png');
// Merge a chart
$ChartRef = 'my_chart';
// Title of the shape that embeds the chart
$SeriesNameOrNum = 1;
$NewValues = array(array('Cat. A', 'Cat. B', 'Cat. C', 'Cat. D'), array(0.7, 1.0, 3.2, 4.8));
$NewLegend = "Merged";
$TBS->PlugIn(OPENTBS_CHART, $ChartRef, $SeriesNameOrNum, $NewValues, $NewLegend);
// -----------------
// Output the result
// -----------------
// Define the name of the output file
$save_as = isset($_POST['save_as']) && trim($_POST['save_as']) !== '' && $_SERVER['SERVER_NAME'] == 'localhost' ? trim($_POST['save_as']) : '';
$output_file_name = str_replace('.', '_' . date('Y-m-d') . $save_as . '.', $template);
if ($save_as === '') {
// Output the result as a downloadable file (only streaming, no data saved in the server)
$TBS->Show(OPENTBS_DOWNLOAD, $output_file_name);
// Also merges all [onshow] automatic fields.
} else {
// Output the result as a file on the server
$TBS->Show(OPENTBS_FILE + TBS_EXIT, $output_file_name);
// Also merges all [onshow] automatic fields.
}
<?php
include_once 'tbs_class.php';
$TBS = new clsTinyButStrong();
include_once 'tbs_plugin_cache.php';
// Load the Cache System library
$TBS->PlugIn(TBS_INSTALL, TBS_CACHE, dirname(__FILE__));
// Install the plug-in
// Call the Cache System which is deciding wheter to continue and store the result into a cache file, or to display a cached page.
if ($TBS->PlugIn(TBS_CACHE, 'testcache', 10)) {
} else {
$TBS->LoadTemplate('tbs_us_examples_cache.htm');
$TBS->Show();
}
// Display the intented XML of the current sub-file, and exit.
if (isset($_POST['debug']) && $_POST['debug'] == 'info') {
$TBS->Plugin(OPENTBS_DEBUG_INFO, true);
}
// Display information about the document, and exit.
if (isset($_POST['debug']) && $_POST['debug'] == 'show') {
$TBS->Plugin(OPENTBS_DEBUG_XML_SHOW);
}
// Tells TBS to display information when the document is merged. No exit.
// --------------------------------------------
// Merging and other operations on the template
// --------------------------------------------
// Merge data in a table (there is no need to select the slide with an ODP)
$TBS->MergeBlock('b', $data);
// Hide a slide
$TBS->PlugIn(OPENTBS_DISPLAY_SLIDES, 'slide to hide', false);
// Delete a slide
$TBS->PlugIn(OPENTBS_DELETE_SLIDES, 'slide to delete');
// -----------------
// Output the result
// -----------------
// Define the name of the output file
$save_as = isset($_POST['save_as']) && trim($_POST['save_as']) !== '' && $_SERVER['SERVER_NAME'] == 'localhost' ? trim($_POST['save_as']) : '';
$output_file_name = str_replace('.', '_' . date('Y-m-d') . $save_as . '.', $template);
if ($save_as === '') {
// Output the result as a downloadable file (only streaming, no data saved in the server)
$TBS->Show(OPENTBS_DOWNLOAD, $output_file_name);
// Also merges all [onshow] automatic fields.
} else {
// Output the result as a file on the server
$TBS->Show(OPENTBS_FILE + TBS_EXIT, $output_file_name);
if (isset($_POST['debug']) && $_POST['debug'] == 'show') {
$TBS->Plugin(OPENTBS_DEBUG_XML_SHOW);
}
// Tells TBS to display information when the document is merged. No exit.
// --------------------------------------------
// Merging and other operations on the template
// --------------------------------------------
// Merge data in the body of the document
$TBS->MergeBlock('a,b', $data);
// Change chart series
$ChartNameOrNum = 'a nice chart';
// Title of the shape that embeds the chart
$SeriesNameOrNum = 'Series 2';
$NewValues = array(array('Category A', 'Category B', 'Category C', 'Category D'), array(3, 1.1, 4.0, 3.3));
$NewLegend = "Updated series 2";
$TBS->PlugIn(OPENTBS_CHART, $ChartNameOrNum, $SeriesNameOrNum, $NewValues, $NewLegend);
// Delete comments
$TBS->PlugIn(OPENTBS_DELETE_COMMENTS);
// -----------------
// Output the result
// -----------------
// Define the name of the output file
$save_as = isset($_POST['save_as']) && trim($_POST['save_as']) !== '' && $_SERVER['SERVER_NAME'] == 'localhost' ? trim($_POST['save_as']) : '';
$output_file_name = str_replace('.', '_' . date('Y-m-d') . $save_as . '.', $template);
if ($save_as === '') {
// Output the result as a downloadable file (only streaming, no data saved in the server)
$TBS->Show(OPENTBS_DOWNLOAD, $output_file_name);
// Also merges all [onshow] automatic fields.
} else {
// Output the result as a file on the server
$TBS->Show(OPENTBS_FILE + TBS_EXIT, $output_file_name);
$fecha = date('d/m/Y');
// Load the template
$TBS->LoadTemplate($template);
if ($debug == 2) {
// debug mode 2
$TBS->Plugin(OPENTBS_DEBUG_XML_CURRENT);
exit;
} elseif ($debug == 1) {
// debug mode 1
$TBS->Plugin(OPENTBS_DEBUG_INFO);
exit;
}
$TBS->MergeBlock('a', $data);
// Define the name of the output file
// delete comments
$TBS->PlugIn(OPENTBS_DELETE_COMMENTS);
$file_name = str_replace('.', '_' . date('Y-m-d') . '.', $template);
// Output as a download file (some automatic fields are merged here)
if ($debug == 3) {
// debug mode 3
$TBS->Plugin(OPENTBS_DEBUG_XML_SHOW);
} elseif ($suffix === '') {
// download
$TBS->Show(OPENTBS_DOWNLOAD, $file_name);
} else {
// save as file
$file_name = str_replace('.', '_' . $suffix . '.', $file_name);
$TBS->Show(OPENTBS_FILE + TBS_EXIT, $file_name);
}
} else {
print_r($_POST);
$TBS->Plugin(OPENTBS_DEBUG_INFO, true);
}
// Display information about the document, and exit.
if (isset($_POST['debug']) && $_POST['debug'] == 'show') {
$TBS->Plugin(OPENTBS_DEBUG_XML_SHOW);
}
// Tells TBS to display information when the document is merged. No exit.
// --------------------------------------------
// Merging and other operations on the template
// --------------------------------------------
// Merge data in the first sheet
$TBS->MergeBlock('a,b', $data);
// Merge cells (extending columns)
$TBS->MergeBlock('cell1,cell2', $data);
// Change the current sheet
$TBS->PlugIn(OPENTBS_SELECT_SHEET, 2);
// Merge data in Sheet 2
$TBS->MergeBlock('cell1,cell2', 'num', 3);
$TBS->MergeBlock('b2', $data);
// Merge pictures of the current sheet
$x_picture = 'pic_1523d.gif';
$TBS->PlugIn(OPENTBS_MERGE_SPECIAL_ITEMS);
// Delete a sheet
$TBS->PlugIn(OPENTBS_DELETE_SHEETS, 'Delete me');
// Display a sheet (make it visible)
$TBS->PlugIn(OPENTBS_DISPLAY_SHEETS, 'Display me');
// -----------------
// Output the result
// -----------------
// Define the name of the output file
$save_as = isset($_POST['save_as']) && trim($_POST['save_as']) !== '' && $_SERVER['SERVER_NAME'] == 'localhost' ? trim($_POST['save_as']) : '';
$data[] = array('product' => 'Harmonica', 'price' => 5.99);
$data[] = array('product' => 'Bass', 'price' => 189.0);
$data[] = array('product' => 'Harp', 'price' => 199.0);
$data[] = array('product' => 'Violin', 'price' => 64.95);
$data[] = array('product' => 'Bagpipes', 'price' => 129.0);
$data[] = array('product' => 'Ukulele', 'price' => 48.0);
// Default value
if (!isset($_GET)) {
$_GET =& $HTTP_GET_VARS;
}
if (isset($_GET['PageNum'])) {
$PageNum = $_GET['PageNum'];
} else {
$PageNum = 1;
}
// Default value
if (isset($_GET['RecCnt'])) {
$RecCnt = intval($_GET['RecCnt']);
} else {
$RecCnt = -1;
}
$PageSize = 5;
$TBS = new clsTinyButStrong();
$TBS->LoadTemplate('tbs_us_examples_page.htm');
// Merge the block by page
$TBS->PlugIn(TBS_BYPAGE, $PageSize, $PageNum, $RecCnt);
// Next block will be merged suing By-Page mode.
$RecCnt = $TBS->MergeBlock('blk', $data);
// Merge the Navigation Bar
$TBS->PlugIn(TBS_NAVBAR, 'nv', '', $PageNum, $RecCnt, $PageSize);
$TBS->Show();
public static function download($fileNameResource, $extResource, $fileNameResult, $data, $mode = [])
{
$fileNameResult = $fileNameResult . '.' . $extResource;
# checking tmp directory for save result
$assetsPath = Setting::getAssetPath();
$tmpDir = $assetsPath . DIRECTORY_SEPARATOR . "exports";
if (!is_dir($tmpDir)) {
mkdir($tmpDir, 0777, TRUE);
}
# checking fileNameResourse
$fileNameResourceExplode = explode('.', $fileNameResource);
if (count($fileNameResourceExplode) == 2) {
$pathResources = Yii::getPathOfAlias('app.modules.' . $fileNameResourceExplode[0] . '.reports.' . $fileNameResourceExplode[1]);
} else {
$pathResources = Yii::getPathOfAlias('app.reports.' . $fileNameResourceExplode[0]);
}
$pathResources .= '.' . $extResource;
if (file_exists($pathResources) != true) {
// throw new CDbException('The specified file cannot be found.');
echo 'The specified file cannot be found.';
exit;
}
$allow_ext = array('odt', 'ods', 'odp', 'odg', 'odf', 'docx', 'xlsx', 'pptx');
if (!in_array($extResource, $allow_ext)) {
echo 'Extension File yang diijinkan hanya [odt, ods, odp, odg, odf, docx, xlsx, pptx]';
exit;
}
// spl_autoload_unregister(array('YiiBase','autoload'));
// Include classes
require_once Yii::getPathOfAlias('ext.ertong.tbs.opentbs.demo.tbs_class') . '.php';
require_once Yii::getPathOfAlias('ext.ertong.tbs.opentbs.tbs_plugin_opentbs') . '.php';
// spl_autoload_register(array('YiiBase','autoload'));
// prevent from a PHP configuration problem when using mktime() and date()
if (version_compare(PHP_VERSION, '5.1.0') >= 0) {
if (ini_get('date.timezone') == '') {
date_default_timezone_set('UTC');
}
}
// Initialize the TBS instance
$TBS = new clsTinyButStrong();
// new instance of TBS
$TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
// load the OpenTBS plugin
$template = $pathResources;
$TBS->LoadTemplate($template, OPENTBS_ALREADY_UTF8);
// Also merge some [onload] automatic fields (depends of the type of document).
# get Key of array data
foreach (array_keys($data) as $key) {
$TBS->MergeBlock($key, $data[$key]);
}
if (isset($mode['x_picture'])) {
$x_picture = $mode['x_picture'];
$TBS->PlugIn(OPENTBS_MERGE_SPECIAL_ITEMS);
}
$save_as = isset($_POST['save_as']) && trim($_POST['save_as']) !== '' && $_SERVER['SERVER_NAME'] == 'localhost' ? trim($_POST['save_as']) : '';
$output_file_name = $fileNameResult;
if ($save_as === '') {
// Output the result as a downloadable file (only streaming, no data saved in the server)
$TBS->Show(OPENTBS_DOWNLOAD, $output_file_name);
// Be sure that no more output is done, otherwise the download file is corrupted with extra data.
exit;
} else {
// Output the result as a file on the server.
$TBS->Show(OPENTBS_FILE, $output_file_name);
// Also merges all [onshow] automatic fields.
// The script can continue.
exit("File [{$output_file_name}] has been created.");
}
}
// Display information about the document, and exit.
if (isset($_POST['debug']) && $_POST['debug'] == 'show') {
$TBS->Plugin(OPENTBS_DEBUG_XML_SHOW);
}
// Tells TBS to display information when the document is merged. No exit.
// --------------------------------------------
// Merging and other operations on the template
// --------------------------------------------
// Merge data in the Workbook (all sheets)
$TBS->MergeBlock('a,b', $data);
// Merge data in Sheet 2
// No need to change the current sheet, they are all stored in the same XML subfile.
$TBS->MergeBlock('cell1,cell2', 'num', 3);
$TBS->MergeBlock('b2', $data);
// Delete a sheet
$TBS->PlugIn(OPENTBS_DELETE_SHEETS, 'Delete me');
// Display a sheet (make it visible)
$TBS->PlugIn(OPENTBS_DISPLAY_SHEETS, 'Display me');
// -----------------
// Output the result
// -----------------
// Define the name of the output file
$save_as = isset($_POST['save_as']) && trim($_POST['save_as']) !== '' && $_SERVER['SERVER_NAME'] == 'localhost' ? trim($_POST['save_as']) : '';
$output_file_name = str_replace('.', '_' . date('Y-m-d') . $save_as . '.', $template);
if ($save_as === '') {
// Output the result as a downloadable file (only streaming, no data saved in the server)
$TBS->Show(OPENTBS_DOWNLOAD, $output_file_name);
// Also merges all [onshow] automatic fields.
// Be sure that no more output is done, otherwise the download file is corrupted with extra data.
exit;
} else {
// debug mode 2
$TBS->Plugin(OPENTBS_DEBUG_XML_CURRENT);
exit;
} elseif ($debug == 1) {
// debug mode 1
$TBS->Plugin(OPENTBS_DEBUG_INFO);
exit;
}
// Merge data
$TBS->MergeBlock('a,b', $data);
// specific merges depending to the document
if ($template_ext == 'xlsx') {
// merge cells (exending columns)
$TBS->MergeBlock('cell1,cell2', $data);
// change the current sheet
$TBS->PlugIn(OPENTBS_SELECT_SHEET, 2);
// merge data in Sheet 2
$TBS->MergeBlock('cell1,cell2', 'num', 3);
$TBS->MergeBlock('b2', $data);
// Delete a sheet
$TBS->PlugIn(OPENTBS_DELETE_SHEETS, 'Delete me');
// Display a sheet
$TBS->PlugIn(OPENTBS_DISPLAY_SHEETS, 'Display me');
} elseif ($template_ext == 'ods') {
// no need to change the current sheet, they are all stored in the same XML subfile.
// merge data in Sheet 2
$TBS->MergeBlock('cell1,cell2', 'num', 3);
$TBS->MergeBlock('b2', $data);
// Delete a sheet
$TBS->PlugIn(OPENTBS_DELETE_SHEETS, 'Delete me');
// Display a sheet
public function pruebatbswordAction($value = '')
{
$this->view->disable();
// Include classes
include_once 'tbs_us/tbs_class.php';
// Load the TinyButStrong template engine
include_once 'tbs_us/tbs_plugin_opentbs/tbs_plugin_opentbs.php';
// Load the OpenTBS plugin
// Initialize the TBS instance
$TBS = new clsTinyButStrong();
// new instance of TBS
$TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
// load the OpenTBS plugin
// ------------------------------
// Prepare some data for the demo
// ------------------------------
// Retrieve the user name to display
// $yourname = "Luis Freddy Velasco Poma";
$TBS->VarRef['yourname'] = "Nelica Blanco";
// $yourname = trim(''.$yourname);
// if ($yourname=='') $yourname = "(no name)";
// A recordset for merging tables
$data = array();
$data[] = array('rank' => 'A', 'firstname' => 'Marco', 'name' => 'Hill', 'number' => '1523d', 'score' => 200, 'email_1' => '*****@*****.**', 'email_2' => '*****@*****.**', 'email_3' => '*****@*****.**');
$data[] = array('rank' => 'A', 'firstname' => 'Fernando', 'name' => 'Smith', 'number' => '1234f', 'score' => 800, 'email_1' => '*****@*****.**', 'email_2' => '*****@*****.**', 'email_3' => '*****@*****.**');
$data[] = array('rank' => 'B', 'firstname' => 'Nelica', 'name' => 'Mac Dowell', 'number' => '5491y', 'score' => 130, 'email_1' => '*****@*****.**', 'email_2' => '*****@*****.**', 'email_3' => '*****@*****.**');
// Other single data items
$x_num = 3152.456;
$x_pc = 0.2567;
$x_dt = mktime(13, 0, 0, 2, 15, 2010);
$x_bt = true;
$x_bf = false;
$TBS->VarRef['x_delete'] = 1;
// $x_delete = 1;
// -----------------
// Load the template
// -----------------
// $template = 'demo_ms_word.docx';
$template = 'file/template/demo_ms_word.docx';
$TBS->LoadTemplate($template, OPENTBS_ALREADY_UTF8);
// Also merge some [onload] automatic fields (depends of the type of document).
// ----------------------
// Debug mode of the demo
// ----------------------
if (isset($_POST['debug']) && $_POST['debug'] == 'current') {
$TBS->Plugin(OPENTBS_DEBUG_XML_CURRENT, true);
}
// Display the intented XML of the current sub-file, and exit.
if (isset($_POST['debug']) && $_POST['debug'] == 'info') {
$TBS->Plugin(OPENTBS_DEBUG_INFO, true);
}
// Display information about the document, and exit.
if (isset($_POST['debug']) && $_POST['debug'] == 'show') {
$TBS->Plugin(OPENTBS_DEBUG_XML_SHOW);
}
// Tells TBS to display information when the document is merged. No exit.
// --------------------------------------------
// Merging and other operations on the template
// --------------------------------------------
// Merge data in the body of the document
$TBS->MergeBlock('a,b', $data);
// Merge data in colmuns
$data = array(array('date' => '2013-10-13', 'thin' => 156, 'heavy' => 128, 'total' => 284), array('date' => '2013-10-14', 'thin' => 233, 'heavy' => 25, 'total' => 284), array('date' => '2013-10-15', 'thin' => 110, 'heavy' => 412, 'total' => 130), array('date' => '2013-10-16', 'thin' => 258, 'heavy' => 522, 'total' => 258));
$TBS->MergeBlock('c', $data);
// Change chart series
$ChartNameOrNum = 'a nice chart';
// Title of the shape that embeds the chart
$SeriesNameOrNum = 'Series 2';
$NewValues = array(array('Category A', 'Category B', 'Category C', 'Category D'), array(3, 1.1, 4.0, 3.3));
$NewLegend = "Updated series 2";
$TBS->PlugIn(OPENTBS_CHART, $ChartNameOrNum, $SeriesNameOrNum, $NewValues, $NewLegend);
// Delete comments
$TBS->PlugIn(OPENTBS_DELETE_COMMENTS);
// -----------------
// Output the result
// -----------------
$output_file_name = str_replace('.', '_' . date('Y-m-d') . '.', $template);
$TBS->Show(OPENTBS_DOWNLOAD, $output_file_name);
// Also merges all [onshow] automatic fields.
exit;
}
<h2>OpenTBS xlsx with merged cells</h2>
<a href="template.xlsx">Template file</a>
<a href="output.xlsx">Output file</a>
<?php
require_once 'tbs_class.php';
require_once 'tbs_plugin_opentbs.php';
$TBS = new clsTinyButStrong();
$TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
$data = array();
for ($i = 0; $i < 20; $i++) {
$data[$i] = array('num' => $i + 1, 'name' => 'Name ' . time(), 'val' => rand() / 1000);
}
$template = 'template.xlsx';
if (!file_exists($template)) {
echo "file {$template} not found";
}
$TBS->LoadTemplate($template);
//$TBS->PlugIn(OPENTBS_DEBUG_INFO);
//$TBS->PlugIn(OPENTBS_DEBUG_XML_CURRENT);
$TBS->PlugIn(OPENTBS_SELECT_SHEET, 1);
$TBS->MergeBlock('a', $data);
$TBS->PlugIn(OPENTBS_MERGE_CELLS);
$filename = "output.xlsx";
$TBS->Show(OPENTBS_FILE + TBS_EXIT, $filename);
//$TBS->Show(OPENTBS_DOWNLOAD+TBS_EXIT, $filename);
