TinyButStrong Forum

Speed up block processing with onload instead of onshow

2013-02-14 00:31:00

This may be obvious to anyone reading, but it is easy to forget. If you are using blocks and subblocks in your template, it may be considerably longer by the time TBS gets to the onshow event. If you have a block like this:

[code]

[myBlock.fieldName;block=table;]

[onshow.totalFields;]

[/code]

Where myBlock is a semi-large array or object (meaning you will have several tables at the end) - you can save a lot of processing by simply changing onshow to onload. If you choose an earlier event, you can merge the tag once, when the template loads, instead of once for every item in myBlock.

I think it would be safe to say whenever possible, you should use the earliest event you can. With that in mind, I am trying to determine the order of tag processing. I believe it goes like this:

[code]
//assuming:
$TBS->LoadTemplate("path/to/template");
$TBS->MergeBlock('blockName', $arrayOrObject);
$TBS->Show();

1. onload
2. ondata
3. blockName
4. onshow
[/code]

Though [var] and [val] fields don't fit into this ordering, I will try to explain them. [var] and [val] fields are a little different as they will merge based on the tag they are used with.

[var] fields will merge at the same time as whatever they are included with and have no understanding of the field you are currently merging (you could not use var.field to access blockName.field - use val for that), e.g. the var in this example will merge when blockName merges:

[code]
$myGlobal = 'go';
...

[blockName.field;block=p;when [var.myGlobal]='go']

[/code]

[val] fields are equal to the current data item. For example, you would use:

[code]
//good
[blockName.field;when [val]='OK']
[/code]

Instead of:

[code]
//bad
[blockName.field;when [blockName.field]='OK']
[/code]

I hope anyone reading will feel free to correct, clarify, or expand on my explanation of this.

Downsize subtemplate file size to increase speed

2013-01-31 19:57:27

I have an application that uses potentially many subtemplates and my processing time was increasing a lot based on how many sub templates I included, despite having relatively little TBS interaction in the subtemplates. I found file size/length to be a real contributor to this delay. Skrol29 helped my put together a quick php script that I run whenever I edit a subtemplate to cut out the unneeded parts and save a smaller version to the cache, while maintaining my WYSIWYG versions in a source folder.

I did this for OpenTBS with .docx files because they happen to save a lot of extraneous information - I probably would not have noticed a problem with a less junk-filled WYSIWYG system. This version is pretty specific to my use of the drawing canvas and pictures as well as shapes, but the structure could be adapted to cut out whatever extra junk you want. This is also useful if you are using parameter 'getpart' in you file inclusion, if you always include the same "part" and it is much smaller than your overall subtemplate.

[code]
include_once('includes/tbs_class.php');
include_once('includes/tbs_plugin_opentbs.php');
$TBS = new clsTinyButStrong;
$TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);

$LOC_DOCX = 'templates/docx/';
class subTemplate{
var $filename = '',
$docx_path = 'templates/docx/',
$xml_path = 'templates/xml/',
$TBS = null;
function __construct(clsTinyButStrong $TBS, $filename){
$this->TBS = $TBS;
$f = pathinfo($filename);
$this->filename = $f['filename'];
}
public function load_document(){
echo 'Loading document.xml from '.$this->filename.'.docx... ';
$this->TBS->LoadTemplate($this->docx_path.$this->filename.'.docx#word/document.xml');
return $this;
}
public function strip_gfxdata(){
echo 'Stripping gfxdata... ';
while ($x = clsTbsXmlLoc::FindStartTagHavingAtt($this->TBS->Source, 'o:gfxdata', 0) ) {
$x->ReplaceAtt('o:gfxdata', '');
$this->TBS->Source = str_replace(' o:gfxdata=""', '', $this->TBS->Source);
}
return $this;
}
public function use_only_block($blockName){
echo 'Stripping to only '.$blockName.'... ';
$this->TBS->Source = $this->TBS->getBlockSource($blockName);
return $this;
}
public function save(){
echo 'Saving '.$this->filename.'.xml... ';
$file = fopen($this->xml_path.$this->filename.'.xml', 'w');
fwrite($file, $this->TBS->Source);
fclose($file);
echo 'Done. '.number_format(filesize($this->xml_path.$this->filename.'.xml')/1024,1).'KB
';
}
}

//get list of all subtemplates
function get_templates($dir){
$templates = array();
$files = scandir($dir);
foreach($files as $file){
$f = pathinfo($file);
if($f['extension'] == 'docx'){
$templates[] = $file;
}
}
echo "".count($templates).' templates to process
';
return $templates;
}
//process subtemplates and save them to xml folder for use
function make_templates($templates){
global $TBS;
echo "

";
$sub->load_document();
$sub->strip_gfxdata();
$sub->use_only_block('mcAlt');
$sub->save();
echo "

";
}

$templates = get_templates($LOC_DOCX);
make_templates($templates);

?>
[/code]

I hope someone finds this useful - it took my execution time from about 15 seconds to 2.

Block with headergrp having Page Break before except for the first occurence

2013-01-31 13:57:48

Hello,

Let us suppose you have a document that has as its first paragraph a title for the whole document. For example: "PROGRAM FOR 2013"
And then the second paragraph, containing a block with headergroup. For example: [BLK_RES.TRIMESTER;BLOCK=W:P;HEADERGRP=TRIMESTER] TRIMESTER].
The field "trimester" of every record contains "First" or "Second" or "Third" or "Fourth".
If you want that every new trimester section begin on a new page, you can apply the format "Page Break Before" to the paragraph that contains the trimester.
But the problem is that you will have also the first semester beginning on a new page (page 2), leaving behind the document title as one line alone on the first page.

How can you prevent this separation of the first occurence of the breaking field trimester from the very beginning of the document.

The simple solution I found is to:
1- make sure Word has a different header for the first page;
2- Move the first paragraph (title of the whole document) in this header, so that my breaking field "trimester" is now in the first paragraph of the main text.
Since Word ignore the "Page Break Before" format for the first paragraph of the main text, your first trimester will not be separated form the document title (in this case: "PROGRAM FOR 2013".

I hope this tip can be useful to somebody.

Clean up proofErr and w:rsid tags in Word documents

2013-01-18 23:27:39

If you are using Word to make your template, you may have problems periodically with TBS tags not merging due to being broken up by extra blocks of code inserted by Word. This extra code is not noticeable in Word, but sometimes it seems to mangle the TBS tag too much to be recognized. When this happens, you can do two things that will clean up your document.

1) Select any tags ([onshow;data;noerr;], e.g.) in your document and go to the review tab (I am using Word 2010 here, but 2007 is very similar). Click 'Language' > 'Set Proofing Language' (2010) or 'Set Language' in the 'Proofing' division (2007). Then check the box 'Do not check spelling or grammar'. This will prevent Word from adding those extra proofErr tags (and breaking up your TBS tags). It will also remove any that already exist in your document. (Or you can run spell check and ignore everything)

2) The w:rsID tags are a little trickier. There is a hidden option you can access through the macro editor (Alt + F11 will bring it up). Once you are in the macro editor, Ctrl + G will open the 'Immediate Window'. If you paste the following code into the Immediate Window:

[code]
Application.Options.StoreRSIDOnSave = False
[/code]

And then save your document (you do not need to save the macro with the document, it just applies to your Word session), it will remove all of the extra w:rsid tags breaking up your TBS tags.

Notes on editing:
You will want to apply these changes at the end of editing, before you save. If you come back later and edit your document, it will forget that you don't want spell checking and grammar. You can remind it by setting the language again, or by running Spell Check and telling it to ignore all of the problems it encounters. I edited my document more after running the macro I mentioned (in a new Word session, when my Immediate Window was clear again) and my w:rsid tags did not come back, but I suspect they would return if I edited enough.

There is one more potentially problematic tag:

[code]

[/code]

which will insert itself wherever it pleases (from what I understand, it has something to do with moving your screen back to your previous edit if you hit undo, so it attaches itself to the edit before last?). I haven't done much experimenting with this yet, it may not interfere with TBS tags, and I'm not totally sure where it shows up.

Hope this helps.

Re: Use a batch file to simplify OpenTBS templating

2013-01-07 10:30:34

Thanks for sharing this tip.

By the way, OpenTBS is based on a PHP class that is able to manage ZIP archive un full PHP.
http://www.tinybutstrong.com/tools.php

This can give ideas to build your batch above in PHP (if have it in PHP may have any utility, which is not sure).

Re: Adding comments that won't mess up debug formatting

2012-12-28 02:28:08

Yes, the OpenTBS Debug mode.

Example of Joomla application: simple search with more preparations

2012-03-02 02:41:54

Here is the source code and to install procedure for a small Joomla application that works with the TBS plug-in.

This application present a search area, and the result of the search trough a table in the Joomla database.
But it also:
- checks the TBS version
- allows template which are a full HTML page
- allows one CSS style sheet in the template
- allows additional both GET and POST parameters

Installation:
-------------
1) create a folder "applications/simple_search" under the Joomla folder.
2) put the following files
3) create a new Joomla article with the following contents: {tbs}script=applications/simple_search/index.php{/tbs}
4) in the TBS plug-in parameters (under Joomla plug-ins), add the article id to the hallowed ids.

Files:
------

index.php
[code]

/* Simple Search application
Skrol29, 2012-03-01
*/

if (!isset($TBS)) exit("This application can work only under Joomla.");

// Check TBS version
if (version_compare($TBS->Version,'3.6.0')<0) {
$TBS->Source = utf8_encode("This applciation require TinyButStrong Template Engine version 3.6.0 ou higher. The installed version is ".$TBS->Version.".");
return; // back to Joomla
}

// Retrieve user parameters
global $what;
$what = isset($_REQUEST['what']) ? $_REQUEST['what'] : ''; // text to search

// Build The URL to the current article
global $art_url;
$art_id = $TBS->JoomlaArticle->id;
$art_url = JRoute::_(ContentHelperRoute::getArticleRoute($art_id));
$art_url .= (strpos($art_url,'?')===false) ? '?' : '&'; // ensure compatibility with the Short URL mode of Joomla

// Load the template
$TBS->JoomlaScript = $PrmLst['script'];
f_load_template($TBS, 'tpl_main.html', 'Simple Search');

if ($what=='') {
// nothing to search
$TBS->MergeBlock('c', 'clear');
} else {
$sql = "
SELECT id, name
FROM jos_components
WHERE (name LIKE '%".str_replace("'", "''", $what)."%')
ORDER BY id
";
$TBS->MergeBlock('c', 'mysql', $sql);
}

/* END : do not use exit() nore TBS->Show() in order to let Joomla continue the process
*/
return; // go back to Joomla

// ------------------------------------------------------
// ------------------------------------------------------

function f_load_template(&$TBS, $modele, $titre='') {

if ($titre!=='') $TBS->JoomlaArticle->title = utf8_encode($titre);

$TBS->LoadTemplate(dirname(__FILE__).'/'.$modele);

// search and delete the element
$p = strpos($TBS->Source, ' if ($p!==false) {
$p = strpos($TBS->Source, '>', $p);
if ($p!==false) $TBS->Source = substr($TBS->Source, $p+1);
}
$p = strpos($TBS->Source, ' if ($p!==false) $TBS->Source = substr($TBS->Source, 0, $p);

// Add the CSS
$TBS->Source = ''."\r\n".$TBS->Source;

}
[/code]

tpl_main.html
[code]

Search

Result:

Id	Name
[c.id;block=tr]	[c.name]
[c;block=tr;nodata]No item found

[/code]

style.css
[code]
.msg-ok {
color: #060;
}
.msg-err {
color: #F00;
}
.nodata {
background-color:#F96;
}

table.btable {
width:auto;
}
table.btable td, th {
padding:2px;
}
table.btable a {
text-decoration:none;
}

[/code]

Example of Joomla application: very simple search

2012-03-02 02:31:43

Here is the source code and the install procedure for a very basic Joomla application that works with the TBS plug-in.

This application present a search area, and the result of the search trough a table in the Joomla database.

Installation:
-------------
1) create a folder "applications/simple_search" under the Joomla folder.
2) put the following files
3) create a new Joomla article with the following contents: {tbs}script=applications/simple_search/index.php{/tbs}
4) in the TBS plug-in parameters (under Joomla plug-ins), add the article id to the hallowed ids.

Files:
------

index.php
[code]

/* Simple Search application
Skrol29, 2012-03-01
*/

if (!isset($TBS)) exit("This application can work only under Joomla.");

// Retrieve user parameters
global $what;
$what = isset($_POST['what']) ? $_POST['what'] : ''; // text to search

// Load the template
$TBS->JoomlaArticle->title = 'Simple Search';
$TBS->LoadTemplate(dirname(__FILE__).'/tpl_main.html');

if ($what=='') {
// nothing to search
$TBS->MergeBlock('c', 'clear');
} else {
$sql = "
SELECT id, name
FROM jos_components
WHERE (name LIKE '%".str_replace("'", "''", $what)."%')
ORDER BY id
";
$TBS->MergeBlock('c', 'mysql', $sql);
}

/* END : do not use exit() nore TBS->Show() in order to let Joomla continue the process
*/
return; // go back to Joomla
[/code]

tpl_main.html
[code]

Result:

Id	Name
[c.id;block=tr]	[c.name]
[c;block=tr;nodata]No item found

[/code]

delete colmuns in a Ms Word document

2012-02-17 00:08:43

Hello,

Here is a TBS plug-in that enhances OpenTBS and enables you to delete some columns in a table of an Ms Word documents.

tbs_plugin_delcol.php
[code]

/*

This TBS plug-ins enables you to delete the columns you want in any table of an Ms Word Document.
It is supposed to be used with OpenTBS.

Version 1.00
Skrol29, 2011-10-07

Installation:
--------------

$TBS = new clsTinyButStrong;
$TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
$TBS->Plugin(TBS_INSTALL, DELCOL_PLUGIN);

Use:
----

You have to put a TBS field anywhere inside the table with the following parameters:
The field will be erased and the specified columns will be deleted.

* ope=delcol
* colnum = the column numbers to delete, separated with commas (first colmun is number 1).
* colshift = (optional) if parameter "colnum" has only on value then "colshift" extends the number of columns to delete to the left of to the rigth.

Both parameters "colnum" and "colshift" can contain [val] and [var] fields.

Examples:
---------

[onload;ope=delcol;colnum=2,4,6] => will delete columns {2,5,6}
[onload;ope=delcol;colnum=2;colshift=2] => will delete columns {2,3,4}
[onload;ope=delcol;colnum=2;colshift=-1] => will delete columns {1,2}

[onload.col_to_delete;ope=delcol;colnum=[val];colshift=2] => will delete 3 colmuns staring to column number $col_to_delete

*/

define('DELCOL_PLUGIN','clsTbsDeleteColumn');

class clsTbsDeleteColumn {

function OnInstall() {
$this->Version = '1.00'; // Versions of installed plug-ins can be displayed using [var..tbs_info] since TBS 3.2.0
return array('OnOperation');
}

function replaceTbsFields($Prm, $Value) {
$this->TBS->meth_Merge_AutoVar($Prm, true);
$Prm = str_replace($this->TBS->_ChrVal, $Value, $Prm);
return $Prm;
}

function OnOperation($FieldName,&$Value,&$PrmLst,&$Txt,$PosBeg,$PosEnd,&$Loc) {

if ($PrmLst['ope']!='delcol') return; // activated only if delcol parameter is used

if (!isset($PrmLst['colnum'])) return;

// List of columns converted into an array
if (is_array($Value)) $Value = implode(',', $Value);

$col_lst = $this->replaceTbsFields($PrmLst['colnum'], $Value);

$col_lst = str_replace(' ', '', $col_lst);
if ( ($col_lst=='') || ($col_lst=='0') ) return false; // nothing to do

$col_lst = explode(',', $col_lst);
$col_nbr = count($col_lst);

for ($c=0; $c<$col_nbr; $c++) $col_lst[$c] = intval($col_lst[$c]); // Conversion into numeric

// Add column by shifting
if (isset($PrmLst['colshift'])) {
$col_shift = intval($this->replaceTbsFields($PrmLst['colshift'], $Value));
if ($col_shift<>0) {
$step = ($col_shift>0) ? -1 : +1;
for ($s = $col_shift; $s<>0; $s = $s + $step) {
for ($c=0; $c<$col_nbr; $c++) $col_lst[] = $col_lst[$c] + $s;
}
}
}

// Delete the TBS field
$Txt = substr_replace($Txt, '', $PosBeg, $PosEnd - $PosBeg + 1);

// Look for the source of the table
$Loc = clsTbsXmlLoc::findElement($Txt, 'w:tbl', $PosBeg, false);

if ($Loc===false) return false;
$Src = $Loc->GetTxt();

$this->deleteElements($Src, 'w:tblGrid', 'w:gridCol', $col_lst);
$this->deleteElements($Src, 'w:tr', 'w:tc', $col_lst);

$Loc->ReplaceTxt($Src);

return false; // avoid the mergin of the field

}

function deleteElements(&$Txt, $ParentTag, $Tag, $ColLst) {

$ColLst = array_unique($ColLst, SORT_NUMERIC); // delete double columns
sort($ColLst, SORT_NUMERIC); // sort
$ColMax = $ColLst[(count($ColLst)-1)]; // last column to delete

$ParentPos = 0;
$TotalDelNbr = 0;
while ($ParentLoc = clsTbsXmlLoc::findElement($Txt, $ParentTag, $ParentPos, true)) {
$ParentTxt = $ParentLoc->GetTxt();
$ColNum = 0;
$ColPos = 0;
$Continue = true;
$DelNbr = 0;
while ($Continue && ($ColLoc = clsTbsXmlLoc::findElement($ParentTxt, $Tag, $ColPos, true)) ) {
$ColNum++;
if ($ColNum>$ColMax) {
// stop the search
$Continue = false;
} elseif (array_search($ColNum,$ColLst)===false) {
// ne deletation
$ColPos = $ColLoc->PosEnd + 1;
} else {
// deleteation
$DelNbr++;
$ColLoc->ReplaceTxt('');
}
}
if ($DelNbr>0) $ParentLoc->ReplaceTxt($ParentTxt);
$TotalDelNbr = $TotalDelNbr + $DelNbr;
$ParentPos = $ParentLoc->PosEnd + 1;
}

return $TotalDelNbr;

}

}

/* An instance of clsTbsXmlLoc representes a location of an XML element (...) in a TXT contents.
Attributes are no
*/
class clsTbsXmlLoc {

var $PosBeg;
var $PosEnd;
var $SelfClosing;
var $Txt;

// crate an instance with the given parameters
function __construct(&$Txt, $PosBeg, $PosEnd, $SelfClosing = false) {
$this->Txt = &$Txt;
$this->PosBeg = $PosBeg;
$this->PosEnd = $PosEnd;
$this->SelfClosing = $SelfClosing;
}

// return the len of the locator
function GetLen() {
return $this->PosEnd - $this->PosBeg + 1;
}

// return the source of the locator
function GetTxt() {
return substr($this->Txt, $this->PosBeg, $this->GetLen() );
}

// replace the source of the locator in the TXT contents
// update the locator's positions
function ReplaceTxt($new) {
$len = $this->GetLen(); // avoid PHP error : Strict Standards: Only variables should be passed by reference
$this->Txt = substr_replace($this->Txt, $new, $this->PosBeg, $len);
$this->PosEnd = $this->PosEnd + strlen($new) - $len;
}

// search an element in the TXT contents, and return an object if it is found
static function findElement(&$Txt, $Tag, $PosBeg, $Forward) {

$PosBeg = clsTinyButStrong::f_Xml_FindTagStart($Txt, $Tag, true , $PosBeg, $Forward, true);
if ($PosBeg===false) return false;

$PosEnd = strpos($Txt, '>', $PosBeg);
if ($PosEnd===false) return false;

$SelfClosing = (substr($Txt, $PosEnd-1, 1)=='/');
if (!$SelfClosing) {
$PosEnd = clsTinyButStrong::f_Xml_FindTagStart($Txt, $Tag, false, $PosEnd, true , true);
if ($PosEnd===false) return false;
$PosEnd = strpos($Txt, '>', $PosEnd);
if ($PosEnd===false) return false;
}

$XmlLoc = new clsTbsXmlLoc($Txt, $PosBeg, $PosEnd, $SelfClosing);

return $XmlLoc;

}

}
[/code]

Re: Writing out [

2011-11-17 20:59:29

Hi,

The answer is here:
http://www.tinybutstrong.com/support.php#faq_protect

Shorten HTML text and close open tags

2011-09-11 23:30:57

Hi,

I'd like to share what I use to shorten html text with TBS. This format function shortens the text to the "snippet_length" and closes open (allowed) html tags (p, strong, em, blockquote), after operation (something I wish "ope=max:n;maxhtml" would do :)).

usage:
[code]
[myblock.longhtmldescription;onformat=fmt_html_snippet;snippet_length=200]
[/code]
Also accepts the optional parameters add_if_cut and add_not_cut, both of which can hold text or markup to be added to the shortened (or not shortened) html text. These are not the "...", those are added by default if needed.

[code]
function fmt_html_snippet($fieldname, & $html, & $params) {
$html = strip_tags(($html), '

'); //allowed html elements
$length = isset($params['snippet_length']) ? (int)$params['snippet_length'] : 0; //how long should the snippet be
$add_if_cut = isset($params['add_if_cut']) ? $params['add_if_cut'] : ''; //to add if cut (e.g. "(more..)" or a link
$add_not_cut = isset($params['add_not_cut']) ? $params['add_not_cut'] : ''; //to add if text was short enough and has not been cut
if ($length > 0 && mb_strlen(strip_tags($html)) > $length) {
$text_length = $html_length = 0;
$lt = mb_strpos($html, '<');
if ($lt !== false) {
$gt = mb_strpos($html, '>');
$text_length = $lt;
$html_length = $gt - $lt + 1;
while ($gt > $lt && $lt !== false) {
$lt = mb_strpos($html, '<', $gt);
$text_length += $lt - $gt - 1;
if ($text_length >= $length) {
break;
}
$gt = mb_strpos($html, '>', $lt);
$html_length += $gt - $lt + 1;
}
$charcount = $html_length + $length;
} else {
$charcount = $length;
}
$html = mb_substr($html, 0, $charcount-1).'...';
preg_match_all("#<([a-z]+)( .*)?(?!/)>#iU", $html, $result);
$openedtags= $result[1];
preg_match_all("##iU", $html, $result);
$closedtags = array_reverse($result[1]);
foreach($closedtags as $ckey => $closedtag) {
foreach($openedtags as $okey => $openedtag) {
if ($openedtag == $closedtag) {
unset($openedtags[$okey]);
break;
}
}
}
$openedtags = array_reverse($openedtags);
foreach($openedtags as $tag) {
if ($tag != 'br') {
$html .= '';
}
}
$html = $html . $add_if_cut;
} else {
$html = $html. $add_not_cut;
}
}
[/code]

Hope this is useful to someone.

Bye
Rudy

Re: link translation for images in template

2011-05-26 00:47:39
Thanks for your tip.
I must say I used a similar way for managing this TBS site that may display some pages in both paths "/" and "/fr/".

Cross Tab Report Generator

2011-05-09 05:46:38
Here for you, TBS user that would like to know how to create cross-tab report and then combine with Dynamic Columns of our powerfull TBS Templating system ...

[code]
/**
* Yan Friskantoni @ 2011
* version super alpha 0.01 ;)
* Generate Cross Tab data of array
* Example:
*
* // $r would be the source of data, you can supplied the data from query like $r = $db->GetArray('select bar,count(bar) from foo group by bar');
* $r = array();
* $r[]= array('user_code' => '123456', 'TestName' => 'Uji Coba', 'TheoryName'=> 'Dasar Komputer', 'AnswerRight' => 0, 'nQuestions' => 2 );
* $r[]= array( 'user_code' => '123456', 'TestName' => 'Uji Coba', 'TheoryName'=> 'Bahasa Inggris', 'AnswerRight' => 0, 'nQuestions' => 20 );
* $r[]= array( 'user_code' => '1234567890', 'TestName' => 'Uji Coba', 'TheoryName'=> 'Dasar Komputer', 'AnswerRight' => 5, 'nQuestions' => 2 );
* $r[]= array( 'user_code' => '1234567890', 'TestName' => 'Uji Coba', 'TheoryName'=> 'Bahasa Inggris', 'AnswerRight' => 0, 'nQuestions' => 20 );
*
* // call back function
* $nRightAnswer = 0;
* function onBeforeRowSaved($drowSrc, &$dcurr_row)
* {
* global $nRightAnswer;
* $dcurr_row['TotalRightAnswer'] = $nRightAnswer; // add new column ...
* $nRightAnswer = 0;
* }
* // watch for by reference paramaters
* function afterCTSet($drowSrc, &$dcurr_row, $theField, $theValue)
* {
* global $nRightAnswer;
* $nRightAnswer += $theValue;
* //echo "AFTER CTSET $nRightAnswer $theField - $theValue";
* }
*
* $columns = array(); // columns will hold the cross tab column of field that you want to be the source of columns field ...
* $dt = &generateCrossTab($r, 'TheoryName', 'AnswerRight', & $columns
* , array('nQuestions') // skip or hide the field
* , array('onBeforeRowSaved' => 'onBeforeRowSaved', 'afterCTSet' => 'afterCTSet') // call back function
* );
* // if succed then arrange how our data shown ... see how we combine $columns and the other column
* $columns = array_merge(array('user_code', 'TestName'), $columns, array('TotalRightAnswer'));
* // START TEST ... used show source for more idea
* var_dump($dt, $columns);
* echo "\n";
* foreach($columns as $c)
* {
* printf("[%26s]",$c);
* }
* echo "\n";
* foreach($dt as $i)
* {
* foreach($columns as $c)
* {
* printf("[%26s]",$i[$c]);
* }
* echo "\n";
* }
* @param type $srcData source of data
* @param type $ctFieldCol cross tab field
* @param type $ctFieldValue cross tab value
* @param type $ctColumns special Columns of CrossTab
* @param type $fieldToSkip what field to skip when it saved into data?
* @param type $callbackArray call back function .. see example and code :D to know how to used it ;)
* @return type arranged data in cross tab
*/
function & generateCrossTab(&$srcData,
$ctFieldCol, $ctFieldValue, &$ctColumns, $fieldToSkip = null, $callbackArray = null )
{
$data = array();
$the_row = array();
$startCrossValue = '';
$isSaveCtColumns = true;
$ctColumns = array(); // columns of crosstab
foreach($srcData as $rowSrc)
{
if(isset($startCrossValue[0]) &&
$startCrossValue != $rowSrc[$ctFieldCol])
{
$the_row[$rowSrc[$ctFieldCol]] = $rowSrc[$ctFieldValue]; // add to row, value of ct become field name
if($isSaveCtColumns) $ctColumns[] = $rowSrc[$ctFieldCol];
if(isset($callbackArray['afterCTSet'])) $callbackArray['afterCTSet']($rowSrc, &$the_row, $rowSrc[$ctFieldCol], $rowSrc[$ctFieldValue]);
}
else // a new row has been reached then save to data
{
if(!isset($startCrossValue[0]))
{
$startCrossValue = $rowSrc[$ctFieldCol];
}
else
{
if(isset($callbackArray['onBeforeRowSaved'])) $callbackArray['onBeforeRowSaved']($rowSrc, &$the_row);
$data[] = $the_row;
$isSaveCtColumns = false;
}
$the_row = array();
$the_row[$rowSrc[$ctFieldCol]] = $rowSrc[$ctFieldValue]; // add to row, value of ct become field name
if($isSaveCtColumns) $ctColumns[] = $rowSrc[$ctFieldCol];
if(isset($callbackArray['afterCTSet'])) $callbackArray['afterCTSet']($rowSrc, &$the_row, $rowSrc[$ctFieldCol], $rowSrc[$ctFieldValue]);
// -----------------------
// save grouped value
// -----------------------
// first, dont save crosstab field and value
$skipper = array($ctFieldCol, $ctFieldValue);
if(isset($fieldToSkip[0]))
{ // skip field to show?
$skipper = array_merge($skipper, $fieldToSkip);
}
foreach($rowSrc as $key => $val)
{
if(array_key_exists($key, $skipper))
continue;
$the_row[$key] = $val;
}
}
}
if(count($the_row)>0) // for the last row ...
{
if(isset($callbackArray['onBeforeRowSaved'])) $callbackArray['onBeforeRowSaved']($rowSrc, &$the_row);
$data[] = $the_row;
unset($the_row);
}
return $data;
}

?>
[/code]

Re: Conditional Display of HTML Pending Database Field

2011-02-20 22:44:33
Ok, found the answer with the addition of the "mtype=m+m" parameter. However, I'm still not sure why the other code would not work. If hyperlink field is not empty, why would the [eventsblock.eventtitle;block=span;when [eventsblock.hyperlink]=''] section even show? Obviously, the "mtype=m+m" is cleaner.

[code]

[eventsblock.eventtitle;block=span;when [eventsblock.#]+-1;bmagnet=div]

[/code]

Re: Efficient pagination with MySQL 4.0.x and TBS

2011-02-14 07:08:44
Thank you for your sharing! Chiry!
I found some tutorial about pagination in php listed on the site you submit.
It is great helpful for me!
PHPKode is a grant site!