TreColl Posted April 12, 2006 Share Posted April 12, 2006 I have built an invoice script with two pages! (and a css)ATM the script brings up a form for me to fill in, when i press submit it just updates teh page for me to copy into a word processor (or simlar)This is no longer what i need! When i press submit i now need to store the invoice so a customer could view it online. In the invoices there is a reference which i was thinking could be used with mysql and get/post to bring up the correct invoice.My two pages are:[quote]<?php##Header gap for placement of logo later on!$HeaderDistance = "125";## The page title$PageTitle = "my title!";## Currency Unit$CurrencyUnit = "£";## Charge Tax or VAT? 'N' = No to disable$DisplayVat = "N";## Decide what to call the Tax. Could be Tax or it could be VAT!$TaxName = "VAT";## Set the VAT or TAX rate to charge. Only used if above set to 'Y'$VatRate = "17.5";## Enter invoice sign-off you would like to be displayed at the bottom of the invoice$InvoiceSignature = "Many Thanks,<br><br><b>Robert Trehy</b><br>Web Designer";## The table printout Border Colour$BorderColour = "#666666"; ## Dark Grey## The products background highlight colour$TableBGcolour = "#F3F3F3"; ## Light Grey## Strip out any unwanted charactors in the additional notes field.function tag($string){ return stripslashes($string); }?>[/quote]and[quote]<?phpinclude "config.php";function processform() {global $HeaderDistance;global $BorderColour;global $TableBGcolour;global $PageTitle;global $CurrencyUnit;global $InvoiceSignature;global $DisplayVat;global $TaxName;global $VatRate;global $vat_at;global $customer_id;global $customer_address;global $customer_name;global $date;global $order;global $price;global $notes;?><HTML><HEAD><TITLE>Your invoice for Joomland Web Development</TITLE><LINK REL="STYLESHEET" HREF="invoice.css"></HEAD><BODY><img src="blank.gif" width="1" height="<?php print $HeaderDistance; ?>"><DIV align="center"> <TABLE border="0" width="600"> <tr> <TD valign="top" colspan="2"> <table> <tr> <td align="left"> To:<br> <?php print $customer_name; ?><br> <?php print str_replace("\n", "<br>", $customer_address); ?> </td> </tr> <tr> <td align="right"> <b>Date:</b> <?php print "$date"; ?> </td> </tr> <tr> <td align="right"> <b>Ref:</b> <?php print "$customer_id"; ?> </td> </tr> <tr> <td> <br><br><table width="100%" CELLPADDING="2" CELLSPACING="0" border="1" bordercolor="<?PHP print "$BorderColour"; ?>"> <tr bgcolor="<?PHP print "$TableBGcolour"; ?>"> <th>Product</th> <th>Cost</th> <th><?PHP print "$TaxName"; ?></th> <th>Total</th> </tr> <tr> <td><img src="blank.gif" width="450" height="14"></td> <td><img src="blank.gif" width="60" height="14"></td> <td><img src="blank.gif" width="60" height="14"></td> <td><img src="blank.gif" width="60" height="14"></td> </tr><?php$tot_cost = "0";$tot_vat = "0";$tot_price = "0";for($l=0; $l<sizeof($order); $l++){if(!strlen($order[$l]) && $l == (sizeof($order)-1)) { continue; }?> <tr> <td><?php print $order[$l]; ?></td> <td align="right"><?php print "$CurrencyUnit"; ?><?php print number_format($price[$l]/($vat_at+100)*100, 2); ?></td> <td align="right"><?php print "$CurrencyUnit"; ?><?php print number_format($price[$l]-($price[$l]/($vat_at+100)*100), 2); ?></td> <td align="right" width="50"><?php print "$CurrencyUnit"; ?><?php print number_format($price[$l],2); ?></td> </tr><?php$tot_cost += $price[$l]/($vat_at+100)*100;$tot_vat += $price[$l]-($price[$l]/($vat_at+100)*100);$tot_price += $price[$l];}?> <tr> <td colspan="4"><?php if($DisplayVat == "Y") { print "<i>$TaxName charged at a rate of $vat_at%</i>"; } else print "<img src=\"blank.gif\" width=\"1\" height=\"14\">";?></td> </tr> </table> <br> <table align="right" width="0" CELLPADDING="2" CELLSPACING="1" border="1" bordercolor="<?PHP print "$BorderColour"; ?>"> <tr> <td width="60" align="right"><b><?php print "$CurrencyUnit"; ?><?php print number_format($tot_cost,2); ?></b></td> <td align="right" width="60"><b><?php print "$CurrencyUnit"; ?><?php print number_format($tot_vat,2); ?></b></td> <td align="right" width="60"><b><?php print "$CurrencyUnit"; ?><?php print number_format($tot_price,2); ?></b></td> </tr> </table> <br> <br><br><br><?php print tag($notes); ?> <br> <br> <?php print "$InvoiceSignature"; ?> </td> </tr></table></TD></TR></TABLE></DIV></BODY></HTML><?php}function mainform() {global $HeaderDistance;global $BorderColour;global $TableBGcolour;global $PageTitle;global $CurrencyUnit;global $DisplayVat;global $TaxName;global $VatRate;global $InvoiceSignature;global $n_order;global $n_price;global $vat_at;global $customer_id;global $customer_address;global $customer_name;global $date;global $order;global $price;global $notes;?><HTML><HEAD><TITLE>PHP InvoiceIt - Create the Invoice</TITLE><LINK REL="STYLESHEET" HREF="invoice.css"></HEAD><BODY><img src="blank.gif" width="1" height="<?php print $HeaderDistance; ?>"><DIV align="center"> <TABLE WIDTH="90%" BORDER="0" CELLPADDING="2" CELLSPACING="2" ALIGN="CENTER"> <TR> <TD valign="top" colspan="2"><H4 align="center"><?PHP print $PageTitle; ?></H4> <br> <FORM method="post"> <table> <tr> <td align="left"> To:<br> <input type="text" name="customer_name" size="38" value="<?php if($customer_name) { print tag($customer_name); } else { print "Insert Customer Name"; } ?>"> <br> <textarea name="customer_address" rows="5" cols="40"><?php if($customer_address) { print $customer_address; } else { print "Insert Customer Address"; } ?></textarea> </td> </tr> <tr> <td align="right"> <b>Date:</b> <input type="text" name="date" size="15" value="<?php if($date){ print tag($date); } else { print date("d/m/Y"); } ?>"> </td> </tr> <tr> <td align="right"> <b>Ref Number:</b> <input type="text" name="customer_id" size="15" value="<?php if($customer_id){ print tag($customer_id); } else { print "Customer Ref"; } ?>"> </td> </tr> <tr> <td> <table width="100%" CELLPADDING="2" CELLSPACING="0" border="1" bordercolor="<?PHP print "$BorderColour"; ?>"> <tr bgcolor="<?PHP print "$TableBGcolour"; ?>"> <th>Product</th> <th>Cost</th> <th><?PHP print "$TaxName"; ?></th> <th>Total</th> </tr> <tr> <td><img src="blank.gif" width="450" height="14"></td> <td><img src="blank.gif" width="60" height="14"></td> <td><img src="blank.gif" width="60" height="14"></td> <td><img src="blank.gif" width="60" height="14"></td> </tr><?php$tot_cost = 0;$tot_vat = 0;$tot_price = 0;for($l=0; $l<sizeof($order); $l++){?> <input type="hidden" name="order[<?php print $l; ?>]" value="<?php print tag($order[$l]); ?>"> <input type="hidden" name="price[<?php print $l; ?>]" value="<?php print tag($price[$l]); ?>"> <tr> <td><?php print $order[$l]; ?></td> <td align="right"><?php print "$CurrencyUnit"; ?><?php print number_format($price[$l]/($vat_at+100)*100, 2); ?></td> <td align="right"><?php print "$CurrencyUnit"; ?><?php print number_format($price[$l]-($price[$l]/($vat_at+100)*100),2); ?></td> <td align="right"><?php print "$CurrencyUnit"; ?><?php print number_format($price[$l],2); ?></td> </tr> <?php$tot_cost += $price[$l]/($vat_at+100)*100;$tot_vat += $price[$l]-($price[$l]/($vat_at+100)*100);$tot_price += $price[$l];}?> <tr> <td> <input type="text" name="order[<?php print sizeof($order); ?>]" size="70"></td> <td align="right"><img src="blank.gif" width="60" height="14"></td> <td align="right"><img src="blank.gif" width="60" height="14"></td> <td align="right"><?php print "$CurrencyUnit"; ?> <input type="text" name="price[<?php print sizeof($price); ?>]" size="5"></td> </tr> <tr> <td colspan=4><?php if($DisplayVat == "Y") { print "<input type=\"hidden\" name=\"vat_at\" value=\"$VatRate\" size=\"4\"> <i>$TaxName charged at a rate of $VatRate%</i>"; } else print "<img src=\"blank.gif\" width=\"1\" height=\"14\">"; ?></td> </tr> </table> <table align="right" width="0" CELLPADDING="2" CELLSPACING="1" border="1" bordercolor="<?PHP print "$BorderColour"; ?>"> <br> <tr> <td width="60" align="right"><b><?php print "$CurrencyUnit"; ?><?php print number_format($tot_cost,2); ?></b></td> <td align="right" width="60"><b><?php print "$CurrencyUnit"; ?><?php print number_format($tot_vat,2); ?></b></td> <td align="right" width="60"><b><?php print "$CurrencyUnit"; ?><?php print number_format($tot_price,2); ?></b></td> </tr> </table><br><br><br>Enter any additional notes:<br><textarea name="notes" cols="100%" rows="5"><?php print "$notes"; ?></textarea> <br> <br><br> <?php print "$InvoiceSignature"; ?><br></td> </tr> <tr> <td><br> <br> <p align="center"><input name="action" type="submit" value="Update Invoice" class="button"> <input name="action" type="submit" value="Process Invoice" class="button"></p></td> </tr></table> </FORM> </TD> </TR> </TABLE></DIV></BODY></HTML><?php}if($action == "Process Invoice"){ processform();} else {mainform();}?>[/quote]Thanks for any help in advance!Regards,Robert Trehy Quote Link to comment https://forums.phpfreaks.com/topic/7240-need-help-with-invoice-script/ Share on other sites More sharing options...
nathan silveston Posted June 8, 2006 Share Posted June 8, 2006 Hi sorry i cant be of more help, but why not get it to create a pdf file, im not sure how hard/easy this would be, but im guessing that there are some tutorials for it on the web. just gives you an idea.regardsnathan Quote Link to comment https://forums.phpfreaks.com/topic/7240-need-help-with-invoice-script/#findComment-43273 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.