.
***********************************************************************/
$page_security = 'SA_SALESTRANSVIEW';
$path_to_root = "../..";
include_once($path_to_root . "/includes/session.inc");
include_once($path_to_root . "/sales/includes/sales_ui.inc");
include_once($path_to_root . "/sales/includes/sales_db.inc");
$js = "";
if ($use_popup_windows)
$js .= get_js_open_window(900, 600);
page(_($help_context = "View Sales Invoice"), true, false, "", $js);
if (isset($_GET["trans_no"]))
{
$trans_id = $_GET["trans_no"];
}
elseif (isset($_POST["trans_no"]))
{
$trans_id = $_POST["trans_no"];
}
// 3 different queries to get the information - what a JOKE !!!!
$myrow = get_customer_trans($trans_id, ST_SALESINVOICE);
$branch = get_branch($myrow["branch_code"]);
$sales_order = get_sales_order_header($myrow["order_"], ST_SALESORDER);
display_heading(sprintf(_("SALES INVOICE #%d"),$trans_id));
echo "
";
start_table(TABLESTYLE2, "width='95%'");
echo "
"; // outer table
/*Now the customer charged to details in a sub table*/
start_table(TABLESTYLE, "width='100%'");
$th = array(_("Charge To"));
table_header($th);
label_row(null, $myrow["DebtorName"] . " " . nl2br($myrow["address"]), "nowrap");
end_table();
/*end of the small table showing charge to account details */
echo " | "; // outer table
/*end of the main table showing the company name and charge to details */
start_table(TABLESTYLE, "width='100%'");
$th = array(_("Charge Branch"));
table_header($th);
label_row(null, $branch["br_name"] . " " . nl2br($branch["br_address"]), "nowrap");
end_table();
echo " | "; // outer table
start_table(TABLESTYLE, "width='100%'");
$th = array(_("Payment Terms"));
table_header($th);
$paym = get_payment_terms($myrow['payment_terms']);
label_row(null, $paym["terms"], "nowrap");
end_table();
echo " | "; // outer table
start_table(TABLESTYLE, "width='100%'");
start_row();
label_cells(_("Reference"), $myrow["reference"], "class='tableheader2'");
label_cells(_("Currency"), $sales_order["curr_code"], "class='tableheader2'");
label_cells(_("Our Order No"),
get_customer_trans_view_str(ST_SALESORDER,$sales_order["order_no"]), "class='tableheader2'");
end_row();
start_row();
label_cells(_("Customer Order Ref."), $sales_order["customer_ref"], "class='tableheader2'");
label_cells(_("Shipping Company"), $myrow["shipper_name"], "class='tableheader2'");
label_cells(_("Sales Type"), $myrow["sales_type"], "class='tableheader2'");
end_row();
start_row();
label_cells(_("Invoice Date"), sql2date($myrow["tran_date"]), "class='tableheader2'", "nowrap");
label_cells(_("Due Date"), sql2date($myrow["due_date"]), "class='tableheader2'", "nowrap");
label_cells(_("Deliveries"), get_customer_trans_view_str(ST_CUSTDELIVERY,
get_sales_parent_numbers(ST_SALESINVOICE, $trans_id)), "class='tableheader2'");
end_row();
comments_display_row(ST_SALESINVOICE, $trans_id);
end_table();
echo " |
";
end_table(1); // outer table
$result = get_customer_trans_details(ST_SALESINVOICE, $trans_id);
start_table(TABLESTYLE, "width='95%'");
if (db_num_rows($result) > 0)
{
$th = array(_("Item Code"), _("Item Description"), _("Quantity"),
_("Unit"), _("Price"), _("Discount %"), _("Total"));
table_header($th);
$k = 0; //row colour counter
$sub_total = 0;
while ($myrow2 = db_fetch($result))
{
if($myrow2["quantity"]==0) continue;
alt_table_row_color($k);
$value = round2(((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"]),
user_price_dec());
$sub_total += $value;
if ($myrow2["discount_percent"] == 0)
{
$display_discount = "";
}
else
{
$display_discount = percent_format($myrow2["discount_percent"]*100) . "%";
}
label_cell($myrow2["stock_id"]);
label_cell($myrow2["StockDescription"]);
qty_cell($myrow2["quantity"], false, get_qty_dec($myrow2["stock_id"]));
label_cell($myrow2["units"], "align=right");
amount_cell($myrow2["unit_price"]);
label_cell($display_discount, "nowrap align=right");
amount_cell($value);
end_row();
} //end while there are line items to print out
$display_sub_tot = price_format($sub_total);
label_row(_("Sub-total"), $display_sub_tot, "colspan=6 align=right",
"nowrap align=right width='15%'");
}
else
display_note(_("There are no line items on this invoice."), 1, 2);
/*Print out the invoice text entered */
if ($myrow['ov_freight'] != 0.0)
{
$display_freight = price_format($myrow["ov_freight"]);
label_row(_("Shipping"), $display_freight, "colspan=6 align=right", "nowrap align=right");
}
$tax_items = get_trans_tax_details(ST_SALESINVOICE, $trans_id);
display_customer_trans_tax_details($tax_items, 6);
$display_total = price_format($myrow["ov_freight"]+$myrow["ov_gst"]+$myrow["ov_amount"]+$myrow["ov_freight_tax"]);
label_row(_("TOTAL INVOICE"), $display_total, "colspan=6 align=right",
"nowrap align=right");
end_table(1);
$voided = is_voided_display(ST_SALESINVOICE, $trans_id, _("This invoice has been voided."));
if (!$voided)
{
display_allocations_to(PT_CUSTOMER, $myrow['debtor_no'], ST_SALESINVOICE, $trans_id, $myrow['Total']);
}
end_page(true, false, false, ST_SALESINVOICE, $trans_id);
?>