includes/order_lines.inc

   1 <?php
   2 include_once($path_to_root."/includes/ui/ui_input.inc");
   3 /* This utility function remove beginning <td> and </td> from a string
   4  * generated by the above *_cell function.
   5  * This is usefull to use the result of the function within a pager
   6  * which already include the <td>...</td>
   7  * However, for function which doesn't return a string
   8  * but echo, we need to capture the output of the echo first.
   9  */
  10 function start_extract_cell() {
  11         // We need
  12         ob_start();
  13 }
  14
  15 function end_extract_cell() {
  16         $content = ob_get_contents();
  17         ob_end_clean();
  18         return extract_cell($content);
  19 }
  20
  21 function extract_cell($td) {
  22         if(preg_match('/\s*<td>(.*)<\/td>\s*/s', $td, $matches)) {
  23                 return $matches[1];
  24         }
  25         else {
  26 print_r('cacou');
  27                 return $td;
  28         }
  29 }
  30
  31
  32 function update_extra_order_details() {
  33         if(!isset($_POST['Update']) || $_POST['Update'] != 'Update')  return;
  34
  35 begin_transaction();
  36         // update in database all field
  37         foreach($_POST['detail'] as $detail_id => $values) {
  38                 $set = array();
  39                 if($comment = $values['comment'])  array_push($set, " comment='$comment' ");
  40                 if(isset($values['required_date'])) {
  41                         $required_date = trim($values['required_date']);
  42                         if($required_date == "")  {
  43                                 array_push($set," required_date = NULL");
  44                         } else {
  45                                 $date = date2sql($required_date);
  46                                 array_push($set," required_date='$date' ");
  47                         }
  48                 }
  49
  50                 if(!empty($set))  {
  51                         $sql = "UPDATE ".TB_PREF."sales_order_details  SET ".implode($set,', ')."  WHERE id = $detail_id ";
  52
  53                         if(!db_query($sql)) {
  54                                 display_error('Problem while updating order details. Try again');
  55                                 cancel_transaction();
  56                                 return;
  57                         }
  58                 }
  59
  60         }
  61
  62         display_notification('Order details updated');
  63
  64 }
  65
  66 function compute_input_name($row, $field) {
  67         $row_id = $row['id'];
  68         return "detail[$row_id][$field]";
  69 }
  70
  71 function view_link($dummy, $order_no)
  72 {
  73         return  get_customer_trans_view_str(ST_SALESORDER, $order_no);
  74 }
  75
  76 function item_link($dummy, $stock_id)
  77 {
  78   return pager_link( _($stock_id),
  79         "/modules/order_line_extra/item_schedule.php?stock_id=" .$stock_id);
  80 }
  81
  82 function order_link($row)
  83 {
  84   return pager_link( _("Sales Order"),
  85         "/sales/sales_order_entry.php?NewQuoteToSalesOrder=" .$row['order_no'], ICON_DOC);
  86 }
  87
  88 function customer_link($row) {
  89         return customer_link2($row['debtor_ref'], $row['debtor_no']);
  90 }
  91
  92 function customer_link2($name, $id) {
  93         return pager_link(_($name), "/modules/order_line_extra/order_lines_view.php?customer_id=${id}");
  94
  95 }
  96
  97 function aggregate_comment($row) {
  98         $comment =  $row['order_comment'].";".$row['detail_comment'];
  99         if($comment) {
 100                 $comments = array_map('trim', explode(';', $comment));
 101                 $comments = array_filter($comments);
 102                 $first = array_shift($comments);
 103                 if(count($comments) == 0)
 104                         return $first;
 105                 else {
 106                         $tooltip = implode('<br> - ', $comments);
 107                         return "$first <span class='before-tooltip'>more<span class='tooltip'>&nbsp$tooltip</span><span>";
 108                 }
 109         }
 110         return '';
 111 }
 112
 113 function available_quantity($row, $available) {
 114         $quantity = $row['quantity'];
 115         $class = '';
 116         if($available== 0) $class = 'limited';
 117         else if($quantity > $available)  $class = 'partial';
 118
 119         return "<span class='$class'>$available<span>";
 120 }
 121
 122 function input_date_details($row, $date) {
 123 $row_id = $row['id'];
 124         $name = compute_input_name($row, 'required_date');
 125
 126 $_POST[$name] = sql2date($date);
 127
 128         start_extract_cell();
 129                 date_cells (null, $name, 'title', null, 0,0,1001);
 130         return end_extract_cell();
 131
 132
 133         return "
 134 <input type='text' value='$date' name='$name'>
 135 ";
 136 }
 137
 138 function input_comment_details($row, $comment) {
 139 $row_id = $row['id'];
 140         return "
 141 <input type='text' value='$comment' name='detail[$row_id][comment]'>
 142 ";
 143 }
 144
 145 function get_order_details_extra($customer_id, $location) {
 146         $sql = "SELECT sod.id
 147         , so.order_no
 148         , stk_code
 149         , sod.quantity - qty_sent quantity
 150         , GREATEST(0, LEAST(qoh.quantity  - quantity_before, sod.quantity - qty_sent))
 151         , quantity_before
 152         , required_date
 153         ,comment
 154         FROM ".TB_PREF."sales_order_details sod
 155         JOIN ".TB_PREF."sales_orders so ON (so.order_no = sod.order_no
 156                 AND so.trans_type = sod.trans_type
 157                 AND so.trans_type = ".ST_SALESORDER."
 158                 AND so.debtor_no = $customer_id
 159         )
 160         JOIN ".TB_PREF."denorm_qoh qoh ON (stock_id = stk_code AND loc_code = '$location')
 161         LEFT JOIN ".TB_PREF."denorm_order_details_queue  d ON (d.id = sod.id)
 162         WHERE sod.quantity > qty_sent
 163         ";
 164
 165         return $sql;
 166 }
 167
 168 function get_order_summary($location) {
 169 /*
 170         $sub = "SELECT debtor_no, debtor_ref, branch_ref, stk_code
 171         , min(delivery_date)
 172         , sum(sod.quantity - qty_sent) as quantity
 173         , sum((sod.quantity - qty_sent)*unit_price*(1-discount_percent/100)) as amount
 174         , min(required_date)
 175         , group_concat(distinct comments separator ';') as order_comment
 176         , group_concat(distinct comment separator ';') as detail_comment
 177         , max(quantity_before) as quantity_before
 178         FROM ".TB_PREF."sales_order_details sod
 179         JOIN ".TB_PREF."sales_orders so ON (so.order_no = sod.order_no
 180                 AND so.trans_type = sod.trans_type
 181                 AND so.trans_type = ".ST_SALESORDER."
 182         )
 183         NATURAL JOIN ".TB_PREF."debtors_master
 184         NATURAL JOIN ".TB_PREF."cust_branch
 185         JOIN ".TB_PREF."denorm_order_details_queue  d ON (d.id = sod.id)
 186         WHERE sod.quantity > qty_sent AND ".ST_SALESORDER."
 187         GROUP BY debtor_no, branch_code, stk_code
 188         ";
 189 */
 190
 191         $sub = TB_PREF."order_summary_view";
 192
 193         $sql = "SELECT debtor_no, debtor_ref, branch_ref
 194         , `min(delivery_date)`
 195         , sum(sub.quantity) as quantity
 196         , sum(sub.amount) as amount
 197         , sum(greatest(least(sub.quantity, qoh.quantity - quantity_before), 0))
 198         , sum(sub.amount*greatest(least(sub.quantity, qoh.quantity - quantity_before), 0)/sub.quantity)
 199         ,  min(`min(required_date)`)
 200         , group_concat(distinct order_comment separator ';') as order_comment
 201         , group_concat(distinct detail_comment separator ';') as detail_comment
 202                                 FROM $sub sub
 203                                 LEFT JOIN ".TB_PREF."denorm_qoh qoh ON (stock_id = stk_code AND loc_code = '$location')
 204                                 GROUP BY debtor_no, debtor_ref
 205         ";
 206
 207         return $sql;
 208 }
 209 ?>