Jump to content

need help with invoice script


TreColl

Recommended Posts

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]
<?php
include "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
Link to comment
Share on other sites

  • 1 month later...
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.