/** * return Piece from Pieces Return * * $.ajax({ method:'return', table:'Pieces', barcode:9...9, ...}; * * @return string '' */ function JKY_return_piece($the_data) { $db = Zend_Registry::get('db'); $my_barcode = get_data($the_data, 'barcode'); $my_inspected_by = get_data($the_data, 'inspected_by'); $my_weighed_by = get_data($the_data, 'weighed_by'); $my_remarks = get_data($the_data, 'remarks'); $my_checkin_weight = get_data($the_data, 'checkin_weight'); $my_checkin_location = get_data($the_data, 'checkin_location'); $sql = 'UPDATE Pieces' . ' SET ' . get_updated() . ', status="Check In"' . ', inspected_by= ' . $my_inspected_by . ', weighed_by= ' . $my_weighed_by . ', remarks=\'' . $my_remarks . '\'' . ', checkin_weight= ' . $my_checkin_weight . ', checkin_location=\'' . $my_checkin_location . '\'' . ', checkin_at=\'' . get_time() . '\'' . ' WHERE id =' . $my_barcode; log_sql('Pieces', 'update', $sql); $db->query($sql); insert_changes($db, 'Pieces', $my_barcode); $my_order_id = get_table_value('Pieces', 'order_id', $my_barcode); $my_set = ', produced_at=\'' . get_time() . '\'' . ', produced_pieces = produced_pieces + 1'; if ($my_remarks != 'boa') { $my_set = ', rejected_pieces = rejected_pieces + 1'; } $my_field_name = $my_remarks == 'boa' ? 'produced_pieces' : 'rejected_pieces'; $sql = 'UPDATE Orders' . ' SET ' . get_updated() . $my_set . ' WHERE id = ' . $my_order_id; log_sql('Orders', 'update', $sql); $db->query($sql); insert_changes($db, 'Orders', $my_order_id); return ''; }
/** * checkin Piece from Pieces Check In * * $.ajax({ method:'checkin', table:'Pieces', barcode:9...9, ...}; * * @return string '' */ function JKY_checkin_piece($the_data) { $db = Zend_Registry::get('db'); $my_barcode = get_data($the_data, 'barcode'); $my_checkin_weight = get_data($the_data, 'checkin_weight'); /* $my_inspected_by = get_data($the_data, 'inspected_by' ); $my_weighed_by = get_data($the_data, 'weighed_by' ); $my_qualities = get_data($the_data, 'qualities' ); $my_remarks = get_data($the_data, 'remarks' ); $my_checkin_weight = get_data($the_data, 'checkin_weight' ); $my_checkin_location= get_data($the_data, 'checkin_location'); */ $my_set = ''; // $my_set .= isset($the_data['revised_by' ]) ? ', revised_by = ' . trim($the_data['revised_by' ]) : ''; $my_set .= ', revised_by = ' . get_session('user_id'); // $my_set .= isset($the_data['weighed_by' ]) ? ', weighed_by = ' . trim($the_data['weighed_by' ]) : ''; $my_set .= ', weighed_by = ' . get_session('user_id'); $my_set .= isset($the_data['qualities']) ? ', qualities =\'' . trim($the_data['qualities']) . '\'' : ''; $my_set .= isset($the_data['remarks']) ? ', remarks =\'' . trim($the_data['remarks']) . '\'' : ''; $my_set .= isset($the_data['checkin_weight']) ? ', checkin_weight = ' . trim($the_data['checkin_weight']) : ''; $my_set .= isset($the_data['checkin_location']) ? ', checkin_location =\'' . trim($the_data['checkin_location']) . '\'' : ''; $sql = 'UPDATE Pieces' . ' SET ' . get_updated() . ', checkin_at=\'' . get_time() . '\'' . $my_set . ' WHERE id =' . $my_barcode; log_sql('Pieces', 'update', $sql); $db->query($sql); insert_changes($db, 'Pieces', $my_barcode); $my_piece = db_get_row('Pieces', 'barcode =\'' . $my_barcode . '\''); if (!is_empty($my_piece['revised_by']) && !is_empty($my_piece['weighed_by'])) { $sql = 'UPDATE Pieces' . ' SET status="Check In"' . ' WHERE id = ' . $my_barcode; log_sql('Pieces', 'update', $sql); $db->query($sql); } // $my_order_id = get_table_value('Pieces', 'order_id', $my_barcode); $my_order_id = $my_piece['order_id']; if (strtolower($my_piece['qualities']) == 'boa') { $my_set = ', produced_at=\'' . get_time() . '\'' . ', produced_pieces = produced_pieces + 1' . ', produced_weight = produced_weight + ' . $my_checkin_weight; } else { $my_set = ', rejected_pieces = rejected_pieces + 1'; } $sql = 'UPDATE Orders' . ' SET ' . get_updated() . $my_set . ' WHERE id = ' . $my_order_id; log_sql('Orders', 'update', $sql); $db->query($sql); insert_changes($db, 'Orders', $my_order_id); return ''; }
/** * checkout Piece from Pieces Check Out * * $.ajax({ method:'checkout', table:'Pieces', barcode:9...9, ...}; * * @return string '' */ function JKY_checkout_piece($the_data) { $db = Zend_Registry::get('db'); $my_barcode = get_data($the_data, 'barcode'); $my_location = get_data($the_data, 'location'); $my_loadset_id = get_data($the_data, 'loadset_id'); $my_piece = db_get_row('Pieces', 'id=' . $my_barcode); $sql = 'UPDATE LoadSets' . ' SET reserved_pieces = reserved_pieces - 1' . ' , reserved_weight = reserved_weight - ' . $my_piece['checkin_weight'] . ' , checkout_pieces = checkout_pieces + 1' . ' , checkout_weight = checkout_weight + ' . $my_piece['checkin_weight'] . ' WHERE id = ' . $my_loadset_id; log_sql('LoadSets', 'update', $sql); $db->query($sql); insert_changes($db, 'LoadSets', $my_loadset_id); $my_loadset = db_get_row('LoadSets', 'id=' . $my_loadset_id); $sql = 'UPDATE LoadQuotations' . ' SET reserved_pieces = reserved_pieces - 1' . ' , reserved_weight = reserved_weight - ' . $my_piece['checkin_weight'] . ' , checkout_pieces = checkout_pieces + 1' . ' , checkout_weight = checkout_weight + ' . $my_piece['checkin_weight'] . ' WHERE id = ' . $my_loadset['load_quot_id']; log_sql('LoadQuotations', 'update', $sql); $db->query($sql); insert_changes($db, 'LoadQuotations', $my_loadset['load_quot_id']); $my_loadquot = db_get_row('LoadQuotations', 'id=' . $my_loadset['load_quot_id']); $sql = 'UPDATE LoadOuts' . ' SET checkout_at="' . get_time() . '"' . ' , checkout_pieces = checkout_pieces + 1' . ' , checkout_weight = checkout_weight + ' . $my_piece['checkin_weight'] . ' WHERE id = ' . $my_loadquot['loadout_id']; log_sql('LoadOuts', 'update', $sql); $db->query($sql); insert_changes($db, 'LoadOuts', $my_loadquot['loadout_id']); $sql = 'UPDATE Pieces' . ' SET ' . get_updated() . ', status="Check Out"' . ', checkout_by=' . get_session('user_id') . ', checkout_at="' . get_time() . '"' . ', checkout_location="' . $my_location . '"' . ', load_quot_id= ' . $my_loadquot['id'] . ' WHERE id =' . $my_piece['id']; log_sql('Pieces', 'update', $sql); $db->query($sql); insert_changes($db, 'Pieces', $my_barcode); $sql = 'UPDATE Orders' . ' SET checkout_pieces = checkout_pieces + 1' . ' , checkout_weight = checkout_weight + ' . $my_piece['checkin_weight'] . ' WHERE id = ' . $my_piece['order_id']; log_sql('Orders', 'update', $sql); $db->query($sql); insert_changes($db, 'Orders', $my_piece['order_id']); return ''; }