Commit | Line | Data |
---|---|---|
16261142 | 1 | <?php |
8972e501 TM |
2 | $columns = $this->db->get_columns('item'); |
3 | $selectbox = $this->db->columns_get_selectbox($columns, 'item'); | |
4 | ||
de77377e | 5 | switch($SUBPATH[0]) { |
16261142 | 6 | default: case 1: |
aaafc8b7 | 7 | $barcode = isset($_GET['barcode']) ? htmlspecialchars($_GET['barcode']) : ''; //TODO: XSS |
8972e501 | 8 | |
35916247 | 9 | echo $this->html->form("$URL/2", 'GET', array( |
68cf81dd | 10 | array('barcode',$barcode,'text',false,'autofocus','model_barcode:'), |
d0e7939c | 11 | array('quantity','1','text',false,false,'quantity:'), |
eca3fc1d | 12 | array('serials','','textarea',false,'autofocus','serial(s):'), |
8972e501 TM |
13 | array('vendor',false,'select',$selectbox['vendor_id'],false,'vendor:'), |
14 | array('room',false,'select',$selectbox['room_id'],false,'room:'), | |
35916247 TM |
15 | array(false,'STORE','submit') |
16 | )); | |
16261142 TM |
17 | break; |
18 | case 2: | |
68cf81dd | 19 | $barcode=$_GET['barcode']; |
eca3fc1d TM |
20 | |
21 | $barcode_id = $this->db->map_unique('barcode_name', $barcode, 'barcode_id', 'barcode'); | |
22 | $model_id = $this->db->map_unique('barcode_id', $barcode_id, 'model_id', 'barcode'); | |
23 | $model_price_in = $this->db->map_unique('model_id', $model_id, 'model_price_in', 'model'); | |
24 | $model_price_out = $this->db->map_unique('model_id', $model_id, 'model_price_out', 'model'); | |
25 | $item_price_in = $this->db->map_unique('item_serial', $barcode, 'item_price_in', 'item', false); | |
26 | $item_price_out = $this->db->map_unique('item_serial', $barcode, 'item_price_out', 'item', false); | |
8972e501 | 27 | //$vendor_id = $this->db->map_unique('barcode_id', $barcode_id, 'vendor_id', 'item', false); |
eca3fc1d | 28 | |
68cf81dd | 29 | $serials=explode("\n",trim($_GET['serials'])); |
0cc327b4 | 30 | if(trim($_GET['serials']) == '') $serials = array(''); |
68cf81dd TM |
31 | |
32 | foreach($serials as $serial) { | |
33 | $serial=trim($serial); | |
d0e7939c | 34 | |
8972e501 | 35 | $disable_cols = array('barcode_id','status_id','item_price_out','item_customer', 'model_id','item_quantity','item_date_sold','location_id','vendor_id','room_id'); |
274c2053 | 36 | |
0cc327b4 TM |
37 | $multi_insert = true; |
38 | //$disable_cols[] = 'item_quantity'; | |
39 | $item_serial = $serial; | |
40 | $item_quantity = $quantity_added = 1; | |
41 | $action = $_SERVER['SCRIPT_NAME'].'/item/new'; | |
cb32a7df | 42 | |
cb32a7df TM |
43 | //print_r(array('<pre>', $selectbox)); |
44 | //foreach($selectbox['model_id'] as $id => $name) if($id != $model_id) unset($selectbox['model_id'][$id]); | |
45 | $current = array(array( | |
eca3fc1d | 46 | 'barcode_id' => $barcode_id, |
cb32a7df TM |
47 | 'item_serial' => $item_serial, |
48 | 'item_quantity' => $item_quantity, | |
49 | 'status_id' => 1, | |
50 | 'item_price_in' => $item_price_in + ($quantity_added * $model_price_in), | |
51 | 'item_price_out' => $item_price_out + ($quantity_added * $model_price_out), | |
52 | 'item_author' => $this->db->auth->get_user_id(), | |
53 | 'item_date_bought' => date('Y-m-d'), | |
1e0a73dc | 54 | 'location_id' => 0, |
8972e501 TM |
55 | 'room_id' => $_GET['room'], |
56 | 'vendor_id' => $_GET['vendor'] | |
cb32a7df TM |
57 | )); |
58 | ||
8972e501 | 59 | //echo("<pre>"); print_r($selectbox); |
cb32a7df | 60 | $insert_form[]=array('item', $columns, $selectbox, $current, $disable_cols, $action, $multi_insert); |
d0e7939c | 61 | } |
16261142 | 62 | |
cb32a7df | 63 | echo $this->html->render_insert_form_multi($insert_form); |
16261142 | 64 | |
16261142 TM |
65 | break; |
66 | } |