def print_multi_add():
print '''<div class="fixed">'''
print '''<select class="multi_dist" id="multi_dist">'''
for dist in db.get_distributors():
print '''<option class="%d_dist_option" value="%d"> %s </option>''' % (dist.get_id(),dist.get_id(),dist)
print '''</select>'''
print '''<button type="button" onClick="multiAddDist()">Add Dist</button>'''
print '''<button type="button" onClick="multiRemoveDist()">Remove Dist</button>'''
print '''<select class="multi_category" id="multi_category">'''
for cat in db.get_categories():
print '''<option class="%d_cat_option" value="%d"> %s </option>''' % (cat.get_id(),cat.get_id(),cat)
print '''</select>'''
print '''<button type="button" onClick="multiAddCategory()">Add Category</button>'''
print '''<button type="button" onClick="multiRemoveCategory()">Remove Category</button>'''
print '''<select class="addTaxCat" id="multi_tax_category">'''
for taxcat in db.get_tax_categories():
print '''<option class="%d_taxcat_option" value="%d"> %s </option>''' % (taxcat.get_id(),taxcat.get_id(),taxcat)
print '''</select>'''
print '''<button type="button" onClick="multiSetTaxCategory()">Set TaxCat</button>'''
print '''<button type="button" onClick="uncheckAllMulti()">Uncheck All Items </button>'''
print '''</div>'''
def print_distributors():
print '''<br/><br/>Select distributors to display:'''
if "allDists" in input_form:
print '''<input name="allDists" type="checkbox" onClick="allDistributors(this)" value="True" checked>All </input><br/>'''
else:
print '''<input name="allDists" type="checkbox" onClick="allDistributors(this)" value="True">All </input><br/>'''
dists = []
print '''<table cellspacing=0 cellpadding=2 style="border-top: 1px solid #999; border-left: 1px solid #999;">'''
for i,dist in enumerate(db.get_distributors()):
if i % 5 == 0:
if i> 0:
print '''</tr>'''
print '''<tr>'''
test_str = "dist_%s" % str(dist)
if test_str in input_form:
dists.append(dist)
print '''<td>%s</td> <td style="border-right: 1px solid #999"><input class="distributorbox" type="checkbox" name="dist_%s" value="True" checked/></td>''' % (dist,dist)
else:
print '''<td>%s</td><td style="border-right: 1px solid #999"> <input class="distributorbox" type="checkbox" name="dist_%s" value="True"/> </td>''' % (dist,dist)
if (i+1) % 5 == 0:
print '''</tr><tr>'''
test_str = "dist_No Distributor"
if test_str in input_form:
print '''<td>%s</td> <td style="border-right: 1px solid #999"><input class="distributorbox" type="checkbox" name="dist_%s" value="True" checked/></td>''' % ("No Distributor", "No Distributor")
hide_distributorless = False
else:
print '''<td>%s</td> <td style="border-right: 1px solid #999"><input class="distributorbox" type="checkbox" name="dist_%s" value="True"/></td>''' % ("No Distributor", "No Distributor")
hide_distributorless = True
print '</tr></table><br />'
return dists, hide_distributorless
def print_distributor_items(item,key_handlers,select_handlers):
print '''<table id="distributors">
<thead>
<th>Distributor</th>
<th>Dist Item ID</th>
<th>Case Size</th>
<th>Case Units</th>
<th>Case Price</th>
<th>Each Price</th>
<th>Margin</th>
<th>Remove</th>
</thead>'''
for ditem in item.get_distributor_items():
print '''<tr id="%d_dist_tr">''' % (ditem.get_id(),)
dist = db.get_distributor(ditem.get_dist_id())
print '''<td> %s</td><td> <input type="text" class="%s" id="%d_ditemid" value="%s" size="16" /></td>''' % (dist,key_handlers['ditemid'].element,ditem.get_id(),ditem.get_dist_item_id())
print '''<td><input type="text" class="%s" id="%d_casesize" value="%.2f" size="4" /> </td>''' % (key_handlers['casesize'].element,ditem.get_id(), ditem.get_case_size())
print '''<td><select class="%s" id="%d_caseunits">''' % (select_handlers['caseunit'].element,ditem.get_id())
print_unit_options(ditem.get_case_unit_id())
print '''</select></td>'''
print '''<td>$<input type="text" class="%s" id="%d_caseprice" value="%.2f" size="5" /></td>''' % (key_handlers['caseprice'].element,ditem.get_id(), ditem.get_wholesale_price())
each_cost = ditem.get_each_cost()
op_price = item.get_price()
tax = item.get_tax_value()
if op_price - tax > 0:
margin = (1.0 - each_cost/(op_price - tax)) * 100
else:
margin = 100
print '''<td width="80" id="%d_each">$%.2f </td>''' % (ditem.get_id(),each_cost)
if margin <= 20:
print '''<td width="80" class="bad" id="%d_margin"> %.0f%% </td>''' % (ditem.get_id(), margin)
elif margin <= 30:
print '''<td width="80" class="mid" id="%d_margin"> %.0f%% </td>''' % (ditem.get_id(), margin)
else:
print '''<td width="80" class="good" id="%d_margin"> %.0f%% </td>''' % (ditem.get_id(), margin)
print '''<td><button type="button" onClick="removeDistributor(%d)">remove</button></td>''' % (ditem.get_id(),)
print '</tr>'
print '</table>'
print '''<select id="new_distributor">'''
for dist in db.get_distributors():
print '''<option value="%d"> %s </option>''' % (dist.get_id(), dist)
print '''</select>'''
print '''<button type="button" onClick="addDistributor()"> Add Distributor</button>'''
print 'Content-type: text/plain\n'
action = form.getvalue('action')
if action == 'add':
if 'name' in form:
distname = form.getvalue('name')
if db.is_distributor_byname(distname):
raise Exception ('distributor already exists')
else:
db.add_distributor(distname)
dist = db.get_distributor_byname(distname)
print '%d,%s' % (dist.get_id(),distname)
else:
raise Exception ('no distributor name given')
elif action == 'remove':
distid = int(form.getvalue('id'))
if not db.is_distributor(distid):
raise Exception ('distributor not in database')
else:
dist = db.get_distributor(distid)
print dist.get_name()
db.remove_distributor(dist)
elif action == 'query':
dist_list = [dist.get_name() for dist in db.get_distributors()]
print ','.join(dist_list)
elif action == 'query-name':
dist_list = [str(dist.get_id())+','+dist.get_name() for dist in db.get_distributors()]
print '\n'.join(dist_list);
else:
raise Exception ('invalid action')
print '''PLU : <input type="text" name="plu" size="10" />'''
print '''count*: <input type="text" name="count" size="3" /> <br />'''
print '''price: $<input type="text" name="price" size="5"/>'''
print '''price unit: <select name="price_unit">'''
for unit in db.get_units():
print '''<option> %s </option> ''' % unit
print '''</select>'''
print '''price id: <input type="text" name="price_id" size="4" />'''
print '''tax category*: <select name="taxcat">'''
for taxcat in db.get_tax_categories():
print '''<option> %s </option> ''' % taxcat
print '''</select> <br />'''
print '''distributor: <select name="distributor" /> '''
print '''<option></option>'''
for dist in db.get_distributors():
print '''<option> %s </option> ''' % dist
print '''</select>'''
print '''distributor item id: <input type="text" name="dist_item_id" size=10" /> '''
print '''case price: <input type="text" name="wholesale_price" size="5" /> '''
print '''case size: <input type="text" name="case_size" size=5" /> '''
print '''case unit: <select name="case_unit"> '''
for unit in db.get_units():
print '''<option> %s </option> ''' % unit
print '''</select> <br />'''
print ''' <input type="submit" value="Add Item" /> </form>'''
print '''Starred fields are required <br />'''
print '''Input either a price AND a price unit OR a price id'''
print '''</body></html>'''
def main():
form = cgi.FieldStorage()
idf.init(form,discontinued=True,distributors=True,categories=True)
print_headers()
print '''
<body>
<div class="key">
Key:
<span class="na"> very negative (produce, etc.) </span>
<span class="bad"> slightly negative (counting error?) </span>
<span class="out"> out (0 in stock) </span>
<span class="low"> <14 day supply in stock </span>
</div>
<div>Click table headers to sort</div>
<div>Click distributor to change</div>
<div>Type and hit ENTER to change item number or to adjust quantity</div>
<div>Boxes will be grayed out until the update happens to the database. If a box doesn't become normal after a few seconds, then likely something is wrong with the database or the server</div>
<div>The Out in column estimates the number of days of stock left in store. It uses the average # units sold per day for the last 14 days to get its estimate</div>
<div>The Spec column shows the estimated stock count for 'Speculate stock for date:' day. Speculation is based on average # units sold per day for the last 14 days. The default date is for the next Thursday</div>
<div>The New count field is meant to change an item's count after doing a manual count. Deliveries should be logged under manage_prices. Type a new count and press ENTER </div>
<div style="clear: both; height: 15px;"> </div>'''
print '''<form name="options" action="catalog.py" method="get">'''
options = idf.print_form() # prints out all of the options for item displaying
print '''Speculate stock for date'''
if "exp_date" in form:
speculate_date = datetime.datetime.strptime(form.getvalue("exp_date"), spec_date_format)
days_to_speculate = (speculate_date - datetime.datetime.now()).days
print_dates(14, speculate_date)
else:
today = datetime.datetime.now()
days_to_speculate = (6 - today.weekday() + 4) % 7 # weekday goes Monday=0, Sunday=6 so: 6-today = days to next sunday
print_dates(14, today+datetime.timedelta(days=days_to_speculate))
print ''' <br /><input type="submit" value="Change options" /> </form>'''
print '''<br /><br />'''
print '''<table border=0 class="sortable" cellspacing=2 cellpadding=0>
<thead class="col-header"><tr>
<th class="th">dist (case size/units/price)</th>
<th class="th">d item id</th>
<th class="th">name</th>
<th class="th">size</th>
<th class="th">price</th>
<th class="th">7d</th>
<th class="th">14d</th>
<th class="th">30d</th>
<th class="th" class="sorttable_numeric">Out in</th>
<th class="th">Spec</th>
<th class="th">#stocked</th>
<th class="th">New count</th>
<th class="th">OP SKU</th>
<th class="th">barcodes</th>
<th class="th">Stocked</th>
</thead><tbody id="item-stats">\n'''
distributors = dict([(d.get_id(), d) for d in db.get_distributors()])
for item in db.get_items(**options):
# Need to make these floats b/c comparison b/t Decimal and float work strangely
count = float(item.get_count())
item_id = item.get_id()
day7, day14, day30 = db.get_sales_in_multi_range(item_id,7,14,30)
stock_strings = ['%.2f'%day7,'%.2f'%day14,'%.2f'%day30]
dist_list = item.get_distributors()
dist_count = len(dist_list)
for i in range(max(1,dist_count)): # need the max in case the item has no distributors
row_color = ""
if count < -10.0:
row_color = "na"
elif count < 0.0:
row_color = "bad"
elif count < 1.0:
row_color = "out"
elif count < day14:
row_color = "low"
print '<tr id="tr_%d_%.2f" class="%s">' % (item_id, day14,row_color)
print '<div class="div_%d">' % (item_id)
if dist_count == 0: # don't have any distributors so we just print blanks in first two spots
print '''<td> - </td> <td> - </td>'''
else:
d_i = dist_list[i]
dist = distributors[d_i.get_dist_id()]
case_str = '''%.2f''' % d_i.get_case_size()
price_str = '''$%.2f''' % d_i.get_wholesale_price()
print '''<td>''',str(dist),'(',case_str,' ',d_i.get_case_unit(),' ',price_str,') </td> <td>',d_i.get_dist_item_id(),' </td>'''
print '''<td style='padding-left: 1em;'>''',str(item),'</td>'''
print '''<td>''',item.get_size_str(),'''</td>'''
print '''<td>''',item.get_price_str(),'''</td>'''
print '<td>',stock_strings[0],'</td><td>',stock_strings[1],'</td><td>',stock_strings[2],'</td>'
if count > 0:
if float(day14) > 0:
days_of_stock = float(count) *14.0/ float(day14)
print '<td>','%.0f'%days_of_stock,' days</td>'
else:
print '''<td>No sales</td>'''
else:
print '''<td>0 days</td>'''
speculated = count - day14/14*days_to_speculate # days_to_speculate determined outside of loop
print '''<td id="%d_spec_%d" class="spec">''' % (item_id,i)
print '%d'%speculated,'''</td>'''
print '''<td id="%d_amt_%d" style="border-left: 1px solid #999; padding-left: 1em;">''' % (item_id, i)
print int(count),'''</td>'''
print '''<td><input class="count default" id="%d_count_%d" size="3" /></td>''' % (item_id,i)
print '''<td style='text-align: center;'> <a href="''',db.get_item_info_page_link(item_id),'''" target="_blank">''',str(item_id),'''</a> </td>'''
print '''<td>''',item.get_barcodes_str(),''' </td>'''
if not item.get_is_discontinued():
print '''<td><input type="checkbox" id="%d_isStocked" onClick="discontinueItem(this)" checked /> </td>''' % (item_id,)
else:
print '''<td><input type="checkbox" id="%d_isStocked" onClick="discontinueItem(this)"/> </td>''' % (item_id,)
print '''</div>'''
print '''</tr>\n'''
print '''</tbody></table>\n'''
print '''</body></html>'''
