Moved all SQL statements from PHP files into relevant *_db.inc files.

[fa-stable.git] / sales / view / view_sales_order.php

diff --git a/sales/view/view_sales_order.php b/sales/view/view_sales_order.php
index ebf60096fa3cf9585d9c0ed62e61f4b422c9071e..69273e03c6e569a9050a2f5ab74eb5c3624101e4 100644 (file)
--- 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;