X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Fincludes%2Freports_classes.inc;h=761ef43cb922364f0e28d5740e9ad38a9b5b70af;hb=ab7ef36ac4dc1d5187c86345de6706c7481b959f;hp=badf6308fabea23ca8b5d05f3859058284a313ab;hpb=720988d0c5feec323d5c5fe87e36c40190d50105;p=fa-stable.git

diff --git a/reporting/includes/reports_classes.inc b/reporting/includes/reports_classes.inc
index badf6308..761ef43c 100644
--- a/reporting/includes/reports_classes.inc
+++ b/reporting/includes/reports_classes.inc
@@ -246,6 +246,16 @@ class Report
 						FROM ".TB_PREF."debtors_master, ".TB_PREF."debtor_trans WHERE (type=10 OR type=11) AND ".TB_PREF."debtors_master.debtor_no=".TB_PREF."debtor_trans.debtor_no ORDER BY ".TB_PREF."debtor_trans.trans_no DESC";
 					$st .= dup_simple_codeandname_list($sql, "RP_" . $this->id . "_$index", $dummy);
 					break;
+				case 'DELIVERY':
+					$DN = _("DN");
+					$sql = "SELECT 
+					concat(".TB_PREF."debtor_trans.trans_no, '-', ".TB_PREF."debtor_trans.type) AS TNO, concat(".TB_PREF."debtor_trans.trans_no, ' $DN ', 
+					 ".TB_PREF."debtors_master.name) as IName 
+						FROM ".TB_PREF."debtors_master, ".TB_PREF."debtor_trans 
+						WHERE type=13 AND ".TB_PREF."debtors_master.debtor_no=".
+						TB_PREF."debtor_trans.debtor_no ORDER BY ".TB_PREF."debtor_trans.trans_no DESC";
+					$st .= dup_simple_codeandname_list($sql, "RP_" . $this->id . "_$index", $dummy);
+					break;
 				case 'ORDERS':
 					$sql = "SELECT ".TB_PREF."sales_orders.order_no, concat(".TB_PREF."sales_orders.order_no, '-', 
 						".TB_PREF."debtors_master.name) as IName