Date work (js + empty value)

[order_line_extra.git] / includes / order_lines.inc

diff --git a/includes/order_lines.inc b/includes/order_lines.inc
index cb8c10588b4ddc5fa8ef482db9704eba10561860..050fa825c6a9b6828d70782b6ceb4fde114fc16e 100644 (file)
--- a/includes/order_lines.inc
+++ b/includes/order_lines.inc
@@ -1,11 +1,58 @@
 <?php
+include_once($path_to_root."/includes/ui/ui_input.inc");
+
+function compute_input_name($row, $field) {
+       $row_id = $row['id'];
+       return "detail[$row_id][$field]";
+}
+
+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 input_date_details($row, $date) {
+$row_id = $row['id'];
+       $name = compute_input_name($row, 'required_date');
+
+$_POST[$name] = sql2date($date);
+
+       start_extract_cell();
+               date_cells (null, $name, 'title', null, 0,0,1001);
+       return end_extract_cell();
+
+
+       return "
+<input type='text' value='$date' name='$name'>
+";
+}
+
+function input_comment_details($row, $comment) {
+$row_id = $row['id'];
+       return "
+<input type='text' value='$comment' name='detail[$row_id][comment]'>
+";
+}
+
 function get_order_details_extra($customer_id) {
-       $sql = "SELECT so.order_no 
+       $sql = "SELECT sod.id
+       , 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;