X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fview%2Fview_sales_order.php;h=69273e03c6e569a9050a2f5ab74eb5c3624101e4;hb=a8282cbfa3f17059ca276dfa7769a0efaedea88f;hp=352b68234a28dd0b23c0aa532aeb5cd6d4d64d98;hpb=ddadb47f2620ce6902ad4694ce6512568862ba05;p=fa-stable.git diff --git a/sales/view/view_sales_order.php b/sales/view/view_sales_order.php index 352b6823..69273e03 100644 --- a/sales/view/view_sales_order.php +++ b/sales/view/view_sales_order.php @@ -25,12 +25,12 @@ if ($use_popup_windows) if ($_GET['trans_type'] == ST_SALESQUOTE) { - page(_("View Sales Quotation"), true, false, "", $js); + page(_($help_context = "View Sales Quotation"), true, false, "", $js); display_heading(sprintf(_("Sales Quotation #%d"),$_GET['trans_no'])); } else { - page(_("View Sales Order"), true, false, "", $js); + page(_($help_context = "View Sales Order"), true, false, "", $js); display_heading(sprintf(_("Sales Order #%d"),$_GET['trans_no'])); } @@ -90,11 +90,11 @@ if ($_GET['trans_type'] != ST_SALESQUOTE) start_table($table_style); display_heading2(_("Delivery Notes")); + $th = array(_("#"), _("Ref"), _("Date"), _("Total")); table_header($th); - $sql = "SELECT * FROM ".TB_PREF."debtor_trans WHERE type=".ST_CUSTDELIVERY." AND order_=" . $_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; @@ -126,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_=" . $_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; @@ -158,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_=" . $_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; @@ -227,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);