Esempio n. 1
0
def main():
    form = cgi.FieldStorage()

    if 'categoryid' in form:
        print_headers(int(form.getvalue('categoryid')))
    elif 'categoryname' in form:
        print_headers(catname=form.getvalue('categoryname'))
    else:
        print_headers()
    
    print '''<form name="category" action="category_info.py" method="get">'''
    print '''Input a category name'''
    print '''<input type="text" name="categoryname" size="4" /> <input type="submit" value="Display" />'''
    print '''</form>'''

    category = None

    if "categoryid" in form:   
        categoryid = int(form.getvalue("categoryid"))
        category = db.get_category(categoryid)
    elif "categoryname" in form:
        try:
            category = db.get_category_byname(form.getvalue("categoryname"))
        except Exception:
            print '''Error: category '%s' not found''' % form.getvalue("categoryname")
    
    if category != None:
        print '''<b>Info for category %s:</b><br />''' % category
        
        print '''<b>Items in this category </b><br/><table>
                   <thead>
                   <th>ItemID</th>
                   <th>Name</th>
                   </thead>'''
        for item in db.get_items(show_categories=[category.get_name()], hide_categoryless=True):
            print '''<tr><td><a href="%s">%d</a></td><td>%s</td></tr>''' % (db.get_item_info_page_link(item.get_id()),item.get_id(), item.get_name())
        print '''</table>'''
Esempio n. 2
0
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"> &lt;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> - &nbsp; </td> <td> - &nbsp; </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(),'''&nbsp;</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>'''
Esempio n. 3
0
def main():
    form = cgi.FieldStorage()
    idf.init(form,discontinued=True,distributors=True,categories=True)
    print_headers()

    print '''

<body>'''
    print '''
<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"> &lt;14 day supply in stock </span>
         </div>
         <div>Click table headers to sort</div>
         <div>Click distributor to change info there. + or - signs add or remove the distributor respectively.  To change any of the other columns make your modifications and click the word update at the end of the row.</div>
         <div>Note that this currently only supports SINGLE barcodes, and needs to be redone (probably in a similar manner to categories etc) to support multiple </div>
         <div>The M-Edit checkbox allows you to add/remove things to multiple items at once </div>
         <div style="clear: both; height: 15px;"> </div>'''
    print '''</body></html>'''
    
    print_multi_add()
    print '''<form name="options" action="manage_items.py" method="get">'''
    options = idf.print_form()
    print '''<input type="submit" value="Change options" /> </form>'''
    print '''<br> <br>'''
    print '''<table border=0 id="main" class="sortable" cellspacing=0 cellpadding=0>
             <thead class="col-header">
             <th class="th">M-Edit</th>
             <th class="th">Name</th>
             <th class="th">Dist Info</th>
             <th class="th">OP SKU</th>
             <th class="th">Barcodes</th>
             <th class="th">Category</th>
             <th class="th">Tax Category</th>
             <th class="th">Stocked</th>
             </thead><tbody id=\"item-stats\">\n'''
    
    for i,item in enumerate(db.get_items(**options)):
        count = item.get_count()
        item_id = item.get_id()
        day14 = db.get_sales_in_range(item_id,14)

        if count < -10.0:
            print '''<tr id="tr_%d" class="na" title="%d">''' % (item_id,day14)
        elif count < 0.0:
            print '''<tr id="tr_%d" class="bad" title="%d">''' % (item_id,day14)
        elif count < 1.0:
            print '''<tr id="tr_%d" class="out" title="%d">''' % (item_id,day14)
        elif count < day14:
            print '''<tr id="tr_%d" class="low" title="%d">''' % (item_id,day14)
        else:
            print '<tr id="tr_%d" title="%d">' % (item_id,day14)
        
        print '''<div class='div_%d'>''' % (item_id)
        print '''<td> <input class="multi" type="checkbox" id="%d" /></td>''' % (item_id,)
	print '''<td><input type="text" class="itemname" id="%d_name" value="%s" />[%s]''' % (item.get_id(), item.get_name(),item.get_size_str())
        print '''<td id="%d_dist" style='border-left: 1px solid #999; border-right: 1px solid #999; padding-left: 1em;'> %s &nbsp;</td>''' % (item_id, item.get_distributors_str())

	print '''<td style='text-align: center;'> <a href="%s" onclick="window.open(this.href,'_blank'); return false;">%d </a></td>''' % (db.get_item_info_page_link(item_id),item_id)
        barcode = item.get_first_barcode()
        if barcode != None:
            print '''<td> <input size="16" type="text" class="itembarcode" id="%d_%s_bc" value="%s" /> &nbsp;</td>''' % (item_id,barcode.get_barcode(), barcode.get_barcode())
        else:
            print '''<td> <input size="16" type="text" class="itembarcode" id="%d_%s_bc" value="%s" /> &nbsp;</td>''' % (item_id, 'None', 'None')
        print '''<td style='border-left: 1px solid #999; border-right: 1px solid #999;' id='%d_cat'> %s &nbsp;</td>''' % (item_id, item.get_categories_str(), )
        print '''<td style='border-right: 1px solid #999;' id='%d_tax'> %s &nbsp;</td>''' % (item_id, str(item.get_tax_category()), )
        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>'''
Esempio n. 4
0
#!/usr/bin/env python
# autocount_items.py
# Patrick McQuighan
# This script should be run periodically when the store is not open to perform an auto-update of the last_count and last_count_timestamp
# fields of the database.  It loops over all items in the database and updates the last_count field with the current value of get_count
# This will improve performance of the catalog page (or any page displaying item counts)

# This file is part of Marzipan, an open source point-of-sale system.
# Copyright (C) 2015 Open Produce LLC
# 
# 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

for item in db.get_items():
    newcount = item.get_count()
    item.auto_count(newcount)