includes/order_lines.inc

   1 <?php
   2 include_once($path_to_root."/includes/ui/ui_input.inc");
   3
   4 function compute_input_name($row, $field) {
   5         $row_id = $row['id'];
   6         return "detail[$row_id][$field]";
   7 }
   8
   9 function view_link($dummy, $order_no)
  10 {
  11         return  get_customer_trans_view_str(ST_SALESORDER, $order_no);
  12 }
  13
  14 function order_link($row)
  15 {
  16   return pager_link( _("Sales Order"),
  17         "/sales/sales_order_entry.php?NewQuoteToSalesOrder=" .$row['order_no'], ICON_DOC);
  18 }
  19
  20 function input_date_details($row, $date) {
  21 $row_id = $row['id'];
  22         $name = compute_input_name($row, 'required_date');
  23
  24 $_POST[$name] = sql2date($date);
  25
  26         start_extract_cell();
  27                 date_cells (null, $name, 'title', null, 0,0,1001);
  28         return end_extract_cell();
  29
  30
  31         return "
  32 <input type='text' value='$date' name='$name'>
  33 ";
  34 }
  35
  36 function input_comment_details($row, $comment) {
  37 $row_id = $row['id'];
  38         return "
  39 <input type='text' value='$comment' name='detail[$row_id][comment]'>
  40 ";
  41 }
  42
  43 function get_order_details_extra($customer_id) {
  44         $sql = "SELECT sod.id
  45         , so.order_no
  46         , stk_code
  47         , quantity - qty_sent
  48         , required_date
  49         , comment
  50         FROM ".TB_PREF."sales_order_details sod
  51         JOIN ".TB_PREF."sales_orders so ON (so.order_no = sod.order_no
  52                 AND so.trans_type = sod.trans_type
  53                 AND so.debtor_no = $customer_id
  54         )
  55         WHERE quantity > qty_sent
  56         ";
  57
  58         return $sql;
  59 }
  60 ?>