";
echo "Payable to: ";
echo "Same as above ";
echo "";
echo "Me personally";
echo " ";
echo "";
echo $Proconame;
echo " ";
echo "";
echo $ProconameA;
echo " ";
echo "";
echo $ProconameB;
echo " ";
echo "Same as above ";
echo "";
echo $Procity;
echo " ";
echo "";
echo $ProcityA;
echo " ";
echo "";
echo $ProcityB;
echo " ";
echo "
";
if($thirdparty=='SELF')
{
echo "";
}
echo "";
$query_appts="SELECT appt_id, appt_price, date_format(item_date, '%a %b %e %Y'), item_txt from $invapptdb WHERE invoice_id='$invoice_id' order by item_date, appt_id";
$result = mysql_query($query_appts);
if(!mysql_num_rows($result)) error_message(sql_error());
$num_appts=mysql_num_rows($result);
$gsttaxable =0;
$clienttotal=0;
for($count=0; $count < $num_appts; $count++)
{
$query_appt = mysql_fetch_array($result);
$appt_id=$query_appt['appt_id'];
$item_date=$query_appt["date_format(item_date, '%a %b %e %Y')"];
$item_txt=$query_appt['item_txt'];
$appt_price=$query_appt['appt_price'];
if($appt_id !=0)
{
$query_date="SELECT date_format(day, '%a %b %e %Y'), Assmt from $apptdb WHERE appt_id='$appt_id'";
$result_date = mysql_query($query_date);
if(!mysql_num_rows($result_date)) error_message(sql_error());
$date_data=mysql_fetch_array($result_date);
$day=$date_data["date_format(day, '%a %b %e %Y')"];
$Assmt=$date_data["Assmt"];
$assmtarray=array(0,4,5,6,12,13,14,15,20,21,22,30,31,32, 170,171,172);
$ASresult=array_search($Assmt, $assmtarray);
if($ASresult==FALSE){$Assmtnotax==1;}
else {$Assmtnotax==0;}
echo "";
echo $day;
echo " ";
echo $client_fname;
echo " ";
echo $client_lname;
echo " ";
service_list3($Assmt);
} else {
echo " ";
echo $item_date;
echo " ";
echo $item_txt;
echo " ";
}
echo " ";
echo $appt_price;
$clienttotal += $appt_price;
if(($gst_exempt==0) && ($Assmtnotax !=1))
{
$gsttaxable += $appt_price;
}
echo " ";
if($gst_exempt==1)
{
echo "gst exempt";
}
echo " ";
echo "Subtotal";
echo " ";
echo number_format($clienttotal, 2, '.','');
echo " ";
echo "GST:";
echo " ";
$gst_amt = ($gsttaxable * 0.07);
$gst_echo=number_format($gst_amt, 2, '.','');
echo $gst_echo;
echo " ";
echo "TOTAL:";
echo " ";*/
$total_amt=$gst_amt + $clienttotal;
/*echo number_format($total_amt, 2, '.','');
echo " ";
echo "Amount paid as of " . $lastpaid . ":";
echo " ";
$total_amt_paid=$total_amt - $newbalance;
echo number_format($total_amt_paid, 2, '.','');
echo " ";
echo "TOTAL:";
echo " ";
echo $newbalance;
echo "
";
echo "";
echo "Invoice number: ";
echo $invoice_id;
echo "
Please make cheque payable to ";
if($payable_to=="me_personally")
{
echo $Proftitle . " " . $Profname . " " . $Prolname . "
";
}
function invoice_body_edit($invoice_id, $CLProv)////////////////////INVOICE BODY EDIT
{
global $client_fname, $client_lname, $gst_exempt, $invdb, $apptdb, $invapptdb, $Pro_type;
echo "";
$query_appts="SELECT invoice_appt_id, appt_id, appt_price, date_format(item_date, '%a %b %e %Y'), item_txt from $invapptdb WHERE invoice_id='$invoice_id' order by item_date, appt_id";
$result = mysql_query($query_appts);
if(!mysql_num_rows($result)) error_message(sql_error());
echo $CLprov;
$num_appts=mysql_num_rows($result);
$gsttaxable =0;
$clienttotal=0;
for($count=0; $count < $num_appts; $count++)
{
$query_appt = mysql_fetch_array($result);
$appt_id=$query_appt['appt_id'];
$appt_price=$query_appt['appt_price'];
$item_date=$query_appt["date_format(item_date, '%a %b %e %Y')"];
$item_txt=$query_appt['item_txt'];
$invoice_appt_id=$query_appt['invoice_appt_id'];
if($appt_id !=0)
{
$query_date="SELECT date_format(day, '%a %b %e %Y'), Assmt from $apptdb WHERE appt_id='$appt_id'";
$result_date = mysql_query($query_date);
if(!mysql_num_rows($result_date)) error_message(sql_error());
$date_data=mysql_fetch_array($result_date);
$day=$date_data["date_format(day, '%a %b %e %Y')"];
$Assmt=$date_data["Assmt"];
echo "";
echo $day;
echo " ";
echo $client_fname;
echo " ";
echo $client_lname;
echo " ";
$apptType=service_list3($Assmt);
echo "" . $apptType . " ";
service_list_from_num($Pro_type);///////////
} else {
echo "";
echo $item_date;
echo " ";
echo $item_txt;
echo " ";
echo "delete this item ";
}
echo " ";
echo " ";
echo "add invoice item ";
echo " ";
echo " ";
echo "Subtotal";
echo " ";
echo number_format($clienttotal, 2, '.','');
echo " GST exempt? ";
}
else
{
$gst_amt=0;
echo "GST exempt? ";
}
echo "GST:";
echo " ";
$gst_echo=number_format($gst_amt, 2, '.','');
echo $gst_echo;
echo " ";
echo "Amount paid as of " . $lastpaid . ":";
echo " ";
$total_amt_paid=$total_amt - $newbalance;
echo number_format($total_amt_paid, 2, '.','');
echo " ";
echo "TOTAL:";
echo " ";
echo $newbalance;
echo "
";
echo "Invoice number: ";
echo $invoice_id;
echo "
Service Provider Login
![](\"./psyimages/blkspacer.jpg\"){kind=spacer}