# This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program. If not, see <http://www.gnu.org/licenses/>. import cgi import op_db_library as db form = cgi.FieldStorage() print 'Content-type: text/plain\n' itemid = int(form.getvalue('item')) item = db.get_item(itemid) dist = None if 'distname' in form: distname = form.getvalue('distname') if db.is_distributor_byname(distname): dist = db.get_distributor_byname(distname) elif 'distid' in form: distid = int(form.getvalue('distid')) if db.is_distributor(distid): dist = db.get_distributor(distid) if dist != None: dist_item = db.get_distributor_item(item,dist) print '%s,%d,%s,%.2f,%.2f,%s' % (dist.get_name(), dist.get_id(),dist_item.get_dist_item_id(), dist_item.get_wholesale_price(), dist_item.get_case_size(), dist_item.get_case_unit())
# This program is free software: you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation, either version 3 of the License, or # (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program. If not, see <http://www.gnu.org/licenses/>. import op_db_library as db kehe = db.get_distributor_byname('Kehe') kehe_items = db.get_distributor_items(show_distributors=[kehe]) for p,item,d,dist_item in kehe_items: # p and d are unused if d.name != 'Kehe': continue note = item.get_notes() d_id = dist_item.get_dist_item_id() note += '\nold kehe id:' + str(d_id) item.set_notes(note) barcodes = item.get_barcodes() if len(barcodes) == 0 : dist_item.set_dist_item_id('') if len(barcodes) == 1: dist_item.set_dist_item_id(barcodes[0]) else: