From 9601714fd65ecd2b2786234336a2d732f7526869 Mon Sep 17 00:00:00 2001
From: Maxime Bourget <bmx007@gmail.com>
Date: Sat, 4 May 2013 22:37:27 +0100
Subject: [PATCH] in progress

---
 includes/order_lines.inc          | 18 +++++++++++++++++-
 order_lines_view.php              |  7 +++++--
 sql/alter_sales_order_details.sql |  3 ++-
 sql/clean_sales_order_details.sql |  2 +-
 4 files changed, 25 insertions(+), 5 deletions(-)

diff --git a/includes/order_lines.inc b/includes/order_lines.inc
index cb8c105..138af42 100644
--- a/includes/order_lines.inc
+++ b/includes/order_lines.inc
@@ -1,11 +1,27 @@
 <?php
+function view_link($dummy, $order_no)
+{
+	return  get_customer_trans_view_str(ST_SALESORDER, $order_no);
+}
+
+function order_link($row)
+{
+  return pager_link( _("Sales Order"),
+	"/sales/sales_order_entry.php?NewQuoteToSalesOrder=" .$row['order_no'], ICON_DOC);
+}
+
 function get_order_details_extra($customer_id) {
-	$sql = "SELECT so.order_no 
+	$sql = "SELECT so.order_no
+	, stk_code
+	, quantity - qty_sent
+	, required_date
+	, comment
 	FROM ".TB_PREF."sales_order_details sod
 	JOIN ".TB_PREF."sales_orders so ON (so.order_no = sod.order_no
 		AND so.trans_type = sod.trans_type
 		AND so.debtor_no = $customer_id
 	)
+	WHERE quantity > qty_sent
 	";
 
 	return $sql;
diff --git a/order_lines_view.php b/order_lines_view.php
index 6f07614..6a45716 100644
--- a/order_lines_view.php
+++ b/order_lines_view.php
@@ -50,12 +50,15 @@ end_table(1);
 //
 $customer_id = $_POST['customer_id'];
 if(isset($customer_id)) {
-label_cell($customer_id);
 	$sql = get_order_details_extra($customer_id);
 
 
 	$cols = array(
-		_("Order #")
+		_("Order #") => array('fun'=>'view_link', 'ord' => '')
+	,_("Item Code") => array('ord' => '')
+		,_("Quantity")
+,_("Required Date") => array('type' => 'Date')
+,_("Comment")
 	);
 }
 else {
diff --git a/sql/alter_sales_order_details.sql b/sql/alter_sales_order_details.sql
index 3eb2059..a6a6d63 100644
--- a/sql/alter_sales_order_details.sql
+++ b/sql/alter_sales_order_details.sql
@@ -1,4 +1,5 @@
 ALTER TABlE 0_sales_order_details
 ADD COLUMN required_date DATE,
-ADD COLUMN comments TEXT,
+ADD COLUMN comment TEXT,
+ADD COLUMN ref STRING,
 ADD COLUMN priority INTEGER;
diff --git a/sql/clean_sales_order_details.sql b/sql/clean_sales_order_details.sql
index 2b5fc16..9202103 100644
--- a/sql/clean_sales_order_details.sql
+++ b/sql/clean_sales_order_details.sql
@@ -1,4 +1,4 @@
 ALTER TABlE 0_sales_order_details
 DROP COLUMN required_date ,
-DROP COLUMN comments ,
+DROP COLUMN comment ,
 DROP COLUMN priority ;
-- 
2.30.2