| ";
$gsttaxable =0;
$num_appts=count($day);
for ($count=0; $count < $num_appts; $count++)
{
echo " | | ";
echo $day[$count];
echo " | ";
$assmt_count=$assmt[$count];
$service_name=service_list3($assmt_count);
if($assmt[$count]==0)
{
echo $service_name;
}
else if($assmt[$count] > 0)
{
echo $service_name;
$gsttaxable += $appt_price[$count];
}
else {}
echo " | ";
echo number_format($appt_price[$count], 2, '.','');
$clienttotal += $appt_price[$count];
echo " | ";
}
if(!$gst_no)
{
$gst_no=0;
echo " | | GST......";
$gst_amt=number_format(($gsttaxable * 0.07), 2,'.','');
echo $gst_amt;
$clienttotal += $gst_amt;
echo " | ";
} else {$gst_no=1;}
$clienttotal=number_format($clienttotal, 2,'.','');
if(!$gst_no){$gst_no=0;}
$in_query="INSERT into $invdb (invoice_id, Pro_id, CL_id, thirdparty, paid, invoice_total, balance, gst_exempt, invoice_date, due_date, office, payable_to, CLprov) VALUES (NULL, '$Pro_id', '$clientcode', '$third_co', 0, $clienttotal, $clienttotal, $gst_no, '$today_db_format', '$day_30_db_format','$office','$payable_to','$CLprovince')";
$result_in=mysql_query($in_query);
if(!$result_in) error_message(sql_error());
$invoice_id=mysql_insert_id($link_id);
echo "![](\"./psyimages/blkspacer.jpg\") | ";
echo "| TOTAL | | ";
echo $clienttotal;
echo " | ";
echo "
|