assistants/sell.inc.php

   1 <?php
   2 //TODO: Highlight fields that should be filled (and maybe even check them when submited)
   3 //TODO: Add support for selling/disposing multiple items at once...
   4 //TODO: Reuse /item/$item_id/edit
   5 //TODO: Stop using map_unique()!!!
   6 //TODO: we can use empty selectbox[] if no selectboxes are shown
   7
   8 if(!isset($status_id)) $status_id = 3;
   9 if(!isset($item_customer)) $item_customer = '';
  10 if(!isset($hide_cols_additional)) $hide_cols_additional = array();
  11 $button_label = strtoupper($ASSISTANT);
  12
  13 $hide_cols_common = array_merge($hide_cols_additional,array('status_id','item_price_in','item_serial','item_quantity','model_id','vendor_id','room_id'));
  14
  15 switch($SUBPATH[0]) {
  16         default: case 1:
  17                 echo $this->html->form("$URL/2", 'GET', array(
  18                         array('serial','','text',false,'autofocus','item_serial:'),
  19                         array('quantity','1','text',false,false,'quantity:'),
  20                         array(false,$button_label,'submit')
  21                 ));
  22                 break;
  23         case 2:
  24                 $item_serial = $_GET['serial'];
  25                 $item_id = $this->db->map_unique('item_serial', $item_serial, 'item_id', 'item');
  26
  27                 $current = $this->db->get_listing('item', $item_id, 1);
  28                 $current[$item_id]['item_author'] = $this->db->auth->get_user_id();
  29                 $forked_item = $current;
  30
  31                 $model_id = $this->db->map_unique('item_serial', $item_serial, 'model_id', 'item');
  32                 $model_price_in = $this->db->map_unique('model_id', $model_id, 'model_price_in', 'model');
  33                 $model_price_out = $this->db->map_unique('model_id', $model_id, 'model_price_out', 'model');
  34
  35                 $model_countable = $this->db->map_unique('model_id', $model_id, 'model_countable', 'model');
  36                 if($model_countable) {
  37                         $current[$item_id]['status_id'] = $status_id;
  38                         $current[$item_id]['item_customer'] = $item_customer;
  39                         $item_quantity = 1;
  40                         $current[$item_id]['item_price_out'] =  $model_price_out;
  41                         $hide_cols = $hide_cols_common;
  42                 } else {
  43                         $hide_cols = array_merge($hide_cols_common,array('item_price_out','item_note','item_customer'));
  44                         $quantity_removed = $_GET['quantity'];
  45                         if($quantity_removed <= 0) $this->post_redirect_get("$URL_INTERNAL/1","Can't dispose non-possitive amount of items!");
  46                         if(!is_numeric($quantity_removed)) $quantity_removed = 1;
  47                         $quantity_stored = $this->db->map_unique('item_serial', $item_serial, 'item_quantity', 'item', false);
  48                         if(!is_numeric($quantity_stored)) $quantity_stored = 0;
  49                         $item_quantity = $quantity_stored - $quantity_removed;
  50
  51
  52                         echo("Stock: ".$quantity_stored."<br />Disposing/Selling: ".$quantity_removed."<br />Keeping: ".$item_quantity);
  53
  54                         $current[$item_id]['item_quantity'] = $item_quantity;
  55                         $current[$item_id]['item_price_in'] -=  $quantity_removed * $model_price_in;
  56                         $current[$item_id]['item_price_out'] -=  $quantity_removed * $model_price_out;
  57
  58                         $forked_item[$item_id]['item_id'] = '';
  59                         $forked_item[$item_id]['item_serial'] .= '@'.time();
  60                         $forked_item[$item_id]['status_id'] = $status_id;
  61                         $forked_item[$item_id]['item_quantity'] = $quantity_removed;
  62                         $forked_item[$item_id]['item_price_in'] =  $quantity_removed * $model_price_in;
  63                         $forked_item[$item_id]['item_price_out'] = $quantity_removed * $model_price_out;
  64                         $forked_item[$item_id]['item_customer'] = $item_customer;
  65
  66                         $forked_hide_cols = array_merge($hide_cols_common,array('item_price_out'));
  67                 }
  68
  69                 $columns = $this->db->get_columns('item');
  70     $selectbox = $this->db->columns_get_selectbox($columns, 'item');
  71
  72                 $action = $_SERVER['SCRIPT_NAME']."/item/$item_id/edit";
  73     //echo $this->html->render_insert_form('item', $columns, $selectbox, $current, $hide_cols, $action);
  74
  75                 $insert_form[]=array('item', $columns, $selectbox, $current, $hide_cols, $action, false);
  76                 if(!$model_countable) $insert_form[]=array('item', $columns, $selectbox, $forked_item, $forked_hide_cols, $action, false);
  77     echo $this->html->render_insert_form_multi($insert_form);
  78                 break;
  79 }