Subversion Repositories SmartDukaan

Rev

Rev 3564 | Rev 3872 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 3564 Rev 3849
Line 23... Line 23...
23
from string import Template
23
from string import Template
24
from shop2020.clients.HelperClient import HelperClient
24
from shop2020.clients.HelperClient import HelperClient
25
 
25
 
26
def initialize():
26
def initialize():
27
    DataService.initialize()
27
    DataService.initialize()
28
    
-
 
29
 
28
 
-
 
29
def get_all_items_by_status(status, offset=0, limit=None):
-
 
30
    query = Item.query
-
 
31
    if status:
-
 
32
        query = query.filter_by(status=status)
-
 
33
    query = query.order_by(Item.product_group, Item.brand, Item.model_number, Item.model_name).offset(offset)
-
 
34
    if limit:
-
 
35
        query = query.limit(limit)
-
 
36
    items = query.all()
-
 
37
    return items
-
 
38
 
30
def get_all_items(is_active):
39
def get_all_items(is_active, offset=0, limit=None):
31
    if is_active:
40
    if is_active:
32
        items = Item.query.filter_by(status= status.ACTIVE).all()
41
        items = get_all_items_by_status(status.ACTIVE, offset, limit)
33
    else:
42
    else:
34
        items = Item.query.all()
43
        items = get_all_items_by_status(None, offset, limit)
35
    return items
44
    return items
36
 
45
 
37
def get_all_items_by_status(status):
46
def get_item_count_by_status(use_status, status):
38
    if status == None:
47
    if use_status:
39
        #return all items
-
 
40
        items = get_all_items(False)
48
        return Item.query.filter_by(status=status).count()
41
    else:
49
    else:
42
        items = Item.query.filter_by(status=status).all()
50
        return Item.query.count()
43
    return items
-
 
44
 
51
 
45
def get_item(item_id):
52
def get_item(item_id):
46
    item = Item.get_by(id=item_id)
53
    item = Item.get_by(id=item_id)
47
    return item
54
    return item
48
 
55