includes/picking.inc

   1 <?php
   2
   3 require_once($path_to_root.'/'.'sales/includes/sales_db.inc');
   4 function process_picking_flag() {
   5         $id = find_submit('_chgpck', false);
   6         if ($id != -1 && isset($_POST['pick'])) {
   7                 $id = str_replace("_update", "", $id);
   8                 change_pck_flag($id, isset($_POST['pick'][$id]));
   9         }
  10 }
  11
  12 function change_pck_flag($id, $value=null)
  13 {
  14 display_warning("value $value");
  15         if($value === null) $value = true;
  16 display_warning("value $value");
  17         global  $Ajax;
  18
  19         $picker = new Picker();
  20         list($debtor_no, $branch_code) = explode('_', $id);
  21
  22         // insert or remove pick order form pick table initial_quantity
  23         if($picker->picked($debtor_no, $branch_code)) {
  24                 $picker->deleteAllForBranch($debtor_no, $branch_code);
  25         }
  26         else {
  27                 $picker->insertAllForBranch($debtor_no, $branch_code);
  28         }
  29         $Ajax->activate('order_line_view');
  30 }
  31
  32
  33 class Picker {
  34         function picked($debtor_no, $branch_code) {
  35                 $sql = "SELECT *
  36                                                 FROM ".TB_PREF."sales_orders so
  37                                                 NATURAL JOIN ".TB_PREF."sales_order_details sod
  38                                                 JOIN ".TB_PREF."topick p on (sod.id = p.detail_id)
  39                                                 WHERE debtor_no = $debtor_no AND branch_code = $branch_code
  40                                                 ";
  41
  42                 return db_num_rows(db_query($sql)) > 0;
  43
  44         }
  45         function insertAllForBranch($debtor_no, $branch_code) {
  46                 $this->deleteAllForBranch($debtor_no, $branch_code);
  47                 $pick_location = OrderXtraConfig::$default_location;
  48                 $sql = "SELECT  d.stock_id
  49                                                                                 , d.quantity AS quantity
  50                                                                                 ,IF(".OrderXtraConfig::sql_held_condition().", d.quantity, 0) held
  51                                                                                 ,qoh.quantity AS qoh
  52                                                                                 ,quantity_before
  53                                                                                 ,order_id
  54                                                 FROM ".TB_PREF."sales_order_details sod
  55                                                 NATURAL JOIN ".TB_PREF."sales_orders so
  56                                                 JOIN ".TB_PREF."denorm_order_details_queue d ON (sod.id = d.id)
  57                                                 JOIN ".TB_PREF."denorm_qoh qoh ON (qoh.stock_id = sod.stk_code AND loc_code = '$pick_location')
  58                                                 WHERE debtor_no = $debtor_no AND branch_code = $branch_code
  59                                                 ";
  60                         display_warning("$sql");
  61                 $result = db_query($sql, $sql);
  62                         display_warning("B $result");
  63                 while($row=db_fetch($result)) {
  64                         foreach($row as $key => $value) { $$key = $value; }
  65                         $available = min($quantity, max($qoh-$quantity_before-$held,0 ));
  66                         $booked = $quantity - $available;
  67
  68                 $sku    = $stock_id;
  69                 $item_link = "/modules/order_line_extra/item_schedule.php?stock_id=$sku";
  70                 $order_link = "/sales/sales_order_entry.php?OrderNumber=$order_id";
  71                 $base = substr($sku, 0, 8);
  72                 $variation = substr($sku, 9);
  73                 $branch = get_cust_branch($debtor_no, $branch_code);
  74                 $location = $branch['branch_ref'];
  75
  76                 $sql = "INSERT INTO ".TB_PREF."topick  SET
  77                         order_id = $order_id,
  78                         order_link = '$order_link',
  79                         location = '$location',
  80                         sku     = '$sku',
  81                         base = '$base',
  82                         variation = '$variation',
  83                         item_link = '$item_link',
  84                         quantity = -{$quantity},
  85                         type = 'order'";
  86                 db_query($sql, 'There was a problem inserting the picking information.');
  87
  88                 # add booked quantity. Insert them as picked so they won't have to be picked
  89                 $sql = "INSERT INTO ".TB_PREF."topick  SET
  90                         order_id = $order_id,
  91                         order_link = '$order_link',
  92                         location = '$location',
  93                         sku     = '$sku',
  94                         item_link = '$item_link',
  95                         base = '$base',
  96                         variation = '$variation',
  97                         quantity = $booked,
  98                         type = 'booked'";
  99                 db_query($sql, 'There was a problem inserting the picking information.');
 100
 101                 }
 102                         display_warning("E");
 103         }
 104
 105         function deleteAllForBranch($debtor_no, $branch_code) {
 106                 display_warning("deleting for $debtor_no $branch_code");
 107                 $sql = "DELETE ".TB_PREF."topick p
 108                                                 FROM ".TB_PREF."topick p
 109                                                 JOIN ".TB_PREF."sales_order_details sod on (sod.id = p.detail_id)
 110                                                 NATURAL JOIN ".TB_PREF."sales_orders so
 111                                                 WHERE debtor_no = $debtor_no AND branch_code = $branch_code
 112                                                 ";
 113                 db_query($sql);
 114         }
 115
 116 }
 117
 118