X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fview%2Fview_sales_order.php;h=69273e03c6e569a9050a2f5ab74eb5c3624101e4;hb=a8282cbfa3f17059ca276dfa7769a0efaedea88f;hp=4529e1d421e1773db7b13ea1d4d0f79d3a4d388c;hpb=d2cc0860eccf02eaefcd90731ac3af141a841529;p=fa-stable.git

diff --git a/sales/view/view_sales_order.php b/sales/view/view_sales_order.php
index 4529e1d4..69273e03 100644
--- a/sales/view/view_sales_order.php
+++ b/sales/view/view_sales_order.php
@@ -94,8 +94,7 @@ if ($_GET['trans_type'] != ST_SALESQUOTE)
 	$th = array(_("#"), _("Ref"), _("Date"), _("Total"));
 	table_header($th);
 
-	$sql = "SELECT * FROM ".TB_PREF."debtor_trans WHERE type=".ST_CUSTDELIVERY." AND order_=".db_escape($_GET['trans_no']);
-	$result = db_query($sql,"The related delivery notes could not be retreived");
+	$result = get_related_documents(ST_CUSTDELIVERY, $_GET['trans_no']);
 
 	$delivery_total = 0;
 	$k = 0;
@@ -127,8 +126,7 @@ if ($_GET['trans_type'] != ST_SALESQUOTE)
 	$th = array(_("#"), _("Ref"), _("Date"), _("Total"));
 	table_header($th);
 
-	$sql = "SELECT * FROM ".TB_PREF."debtor_trans WHERE type=".ST_SALESINVOICE." AND order_=".db_escape($_GET['trans_no']);
-	$result = db_query($sql,"The related invoices could not be retreived");
+	$result = get_related_documents(ST_SALESINVOICE, $_GET['trans_no']);
 
 	$invoices_total = 0;
 	$k = 0;
@@ -159,8 +157,7 @@ if ($_GET['trans_type'] != ST_SALESQUOTE)
 	$th = array(_("#"), _("Ref"), _("Date"), _("Total"));
 	table_header($th);
 
-	$sql = "SELECT * FROM ".TB_PREF."debtor_trans WHERE type=".ST_CUSTCREDIT." AND order_=".db_escape($_GET['trans_no']);
-	$result = db_query($sql,"The related credit notes could not be retreived");
+	$result = get_related_documents(ST_CUSTCREDIT, $_GET['trans_no']);
 
 	$credits_total = 0;
 	$k = 0;
@@ -228,9 +225,9 @@ $items_total = $_SESSION['View']->get_items_total();
 $display_total = price_format($items_total + $_SESSION['View']->freight_cost);
 
 label_row(_("Shipping"), price_format($_SESSION['View']->freight_cost),
-	"align=right colspan=6", "nowrap align=right");
+	"align=right colspan=6", "nowrap align=right", 1);
 label_row(_("Total Order Value"), $display_total, "align=right colspan=6",
-	"nowrap align=right");
+	"nowrap align=right", 1);
 
 end_table(2);