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: [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: [chris] simple invoices with cmsb

By flamerz - June 20, 2010

http://www.javascriptkit.com/dhtmltutors/pagebreak.shtml

this guy has some solution.

i hope your pdf plugin will be uft-8 [cool]

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