includes/order_lines.inc

   1 <?php
   2 function view_link($dummy, $order_no)
   3 {
   4         return  get_customer_trans_view_str(ST_SALESORDER, $order_no);
   5 }
   6
   7 function order_link($row)
   8 {
   9   return pager_link( _("Sales Order"),
  10         "/sales/sales_order_entry.php?NewQuoteToSalesOrder=" .$row['order_no'], ICON_DOC);
  11 }
  12
  13 function get_order_details_extra($customer_id) {
  14         $sql = "SELECT so.order_no
  15         , stk_code
  16         , quantity - qty_sent
  17         , required_date
  18         , comment
  19         FROM ".TB_PREF."sales_order_details sod
  20         JOIN ".TB_PREF."sales_orders so ON (so.order_no = sod.order_no
  21                 AND so.trans_type = sod.trans_type
  22                 AND so.debtor_no = $customer_id
  23         )
  24         WHERE quantity > qty_sent
  25         ";
  26
  27         return $sql;
  28 }
  29 ?>