Categories > OpenTBS general >

Multi-Page Document for Table && Integration to Other PHP Frameworks

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: FARUQ Hasan
Date: 2014-06-01
Time: 00:08

Multi-Page Document for Table && Integration to Other PHP Frameworks

Hi,

I just had a very general question as a novice programmer:

With regards to OpenTBS ~ if we've a SQL table, and a one page document template, will OpenTBS create a report of sorts by repeating the template with a $TBS->Show(OPENTBS_DOWNLOAD, $filename);  i.e. keep repeating the template for each row

                                 ~ Would it not be possible to integrate this in to other PHP frameworks as an exporter or report generator ?

Just a precursor question(s :), prior to putting in the time to integrate it with some framework.


Thank you.

By: Skrol29
Date: 2014-06-02
Time: 22:45

Re: Multi-Page Document for Table && Integration to Other PHP Frameworks

Hi,

> Would it not be possible to integrate this in to other PHP frameworks as an exporter or report generator ?

Yes of course.

OpenTBS is one file.
It requires TBS which is also one file.

As I have seen, TBS and OpenTBS are already been integrated in frameworks.
By: FARUQ Hasan
Date: 2014-07-09
Time: 12:05

Re: Multi-Page Document for Table && Integration to Other PHP Frameworks

Hi Skrol29

I've managed to integrate it into my framework. I am also able to run whole tables against a template using a block, and able to run individual records against a template perfectly.

I was curious if you had a tip to be able to run the same template recursively against an entire table. i.e. if a template is meant to be filled with data from one record only, and I want to download that document against the entire table. So if my template is 1 page, and I have 30 records in my table, my resulting document would be 30 pages.

Thank you,

Faruq
By: Skrol29
Date: 2014-07-09
Time: 14:06

Re: Multi-Page Document for Table && Integration to Other PHP Frameworks

> So if my template is 1 page, and I have 30 records in my table, my resulting document would be 30 pages.

Simple define a block bounded on the page. You have to place a pagebreak to perform this. See the examples provided with the package.
By: FARUQ Hasan
Date: 2014-07-09
Time: 18:39

Re: Multi-Page Document for Table && Integration to Other PHP Frameworks

Okay, however i understand that you can't set a pagebreak in xlsx or open office spreadsheet files, correct ?
I'll give it a shot though
By: Skrol29
Date: 2014-07-09
Time: 23:38

Re: Multi-Page Document for Table && Integration to Other PHP Frameworks

>  i understand that you can't set a pagebreak in xlsx or open office spreadsheet files, correct ?

Correct.
You cannot add sheets or slide, and yuo cannot multiply them by merging.
But you can delete or hide existing sheets and slides.