[KLUG Members] PHP document writer

[bill]

On Sat, 2008-03-22 at 22:21, Jason Edward Durrett wrote:
> Hi Bill, thanks for your response.
> > Are you asking
> >
> > PHP - > HTML -> Something else* -> Calc
> >
> > or 
> >
> > PHP* -> Calc
> >
> > The asterisk indicates where the change would occur.
> >   
> I'll lay out the situation a little bit better.
> 
> I wrote a php app to produce an accounts receivable report in a web
> browser.  I want to put a button on that report that saves it as an
> ods.  

I'd go back a bit and simply branch the choice beforehand.  Do they want
HTML or Spreadsheet?  Have them tell you first and then do it.

In other words, wherever it is that the person asks "I want to see this
report", have the program ask AT THAT TIME whether they want the output
in HTML or XLS (or whatever the other choice will be).  Then the PHP
will only be run once for whatever they want.  The method described
above seems to force them to do it in HTML first and then into another
format.

Request -> HTML -> Spreadsheet

I'd recommend:

                   HTML Report
                /
choice options    
                \
                   Spreadsheet Report

> I don't want to put all the possible sorting and filtering into
> php because that seems like a never ending process . . . ie sort by over
> ninety, sort by over ninety by state, sort by over sixty where all
> accounts are in zip code xxxxx, etc. 

Let them do all that in the spreadsheet if you want.  

If you have a "choice" page beforehand, where they decide what month and
what format they want, for example, you can add sort options there if
you want.  

> I found a php class to do this but I still need to program it a bit.

Do you mean it takes HTML and turns it into a spreadsheet or it takes
raw data and turns it into a spreadsheet?

kind regards,

bill
-- 
PGP/GPG Public Key: https://billtronservices.com/key
Fingerprint: 07A1 A568 4385 FE9D DC5E  A055 A2DA EDED 45B9 2027
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://www.kalamazoolinux.org/pipermail/members/attachments/20080324/51561a7d/attachment.bin