simple invoices with cmsb

12 posts by 5 authors in: Forums > CMS Builder
Last Post: June 25, 2010   (RSS)

By flamerz - June 17, 2010

I'm playing with cmsb related records.

This morning i started with a simple invoicing system... only as exercise.

I post some screens, this is only for testing, im not sure about something like this could be usable.

The invoice is html (not pdf)... and only support 1 page invoice.

When i create new invoice i get the next invoice number from a query, and i set the number in a list box.

I with to have advanced querys in textfields, so i could initialize values there. [angelic]



Just wanted to share...
Attachments:

1.jpg 30K

2.jpg 25K

3.jpg 31K

Re: [flamerz] simple invoices with cmsb

By Donna - June 17, 2010

Pretty neat, Flamerz -- thanks for sharing!
Donna

--
support@interactivetools.com

Re: [Donna] simple invoices with cmsb

By Chris - June 18, 2010

Very nice!

I wonder if there's a way to support multiple page invoices with CSS somehow...

You may be interested in the HTML to PDF plugin we're going to be releasing shortly. Oops, I'm not supposed to mention things that haven't been released yet. ;)

What do you mean by "advanced querys in textfields"?
All the best,
Chris

Re: [chris] simple invoices with cmsb

By Codee - June 18, 2010

BUUTTT you DIIDD mention it dude! So "when" is it becoming available? [;)]

Re: [equinox69] simple invoices with cmsb

By Donna - June 18, 2010

That would be telling!
Donna

--
support@interactivetools.com

Re: [Donna] simple invoices with cmsb

By Codee - June 18, 2010

Hi Donna, it would be "mentioning". You responded pretty quickly to that one...how about someone responding to
http://www.interactivetools.com/iforum/Products_C2/CMS_Builder%3A_Plugins_%26_Add-ons_F40/Membership_Plugin_Question_-_scary_request_P81307/

thanks!

Re: [flamerz] simple invoices with cmsb

By Toledoh - June 19, 2010

This is REALLY interesting. As many of us on this forum are freelancers or small businesses, a simple invoicing system would be very handy.

When we add the email download plugin and the PDF plugin, possibly a paypal account... we could have a very nice system here.

Well done flamerz! I love seeing new uses for CMSB.
Cheers,

Tim (toledoh.com.au)

Re: [chris] simple invoices with cmsb

By flamerz - June 20, 2010

Chris:

for example, i have some invoices and i want to make a new one.

i dont use an autonumeric field, just using a simple textfield as invoice number.

i use a LIST PULLDOWN control, with the following query:

SELECT max(id)+1
FROM `<?php echo $TABLE_PREFIX ?>facturas`

(get the last invoice and sum 1)

this way i get the next invoice number.

i wish to set this one inside a textfield instead a list pulldown... but textfield dont let me use a query as default value.

Re: [flamerz] simple invoices with cmsb

By Chris - June 21, 2010

Here's a (very) advanced trick for doing that with textfields. Throw this in a textfield's Default Value:

<?php $row = mysql_query_fetch_row_array("SELECT MAX(id)+1 FROM `{$TABLE_PREFIX}facturas`"); echo $row[0]; ?>

Of course, I have to warn you that the "MAX(id)+1" trick isn't entirely safe -- if someone clicks to create a second record before the first one has been saved, you can wind up with two records with the same id. Just something to beware of!

I hope this helps! Please keep us informed about your project. :)
All the best,
Chris