Subversion Repositories SmartDukaan

Rev

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

Rev 442 Rev 444
Line 26... Line 26...
26 
        return provider
 26 
        return provider
27
27
28 
def add_empty_AWBs(numbers, provider_id):
 28 
def add_empty_AWBs(numbers, provider_id):
29 
    provider = get_provider_by_id(provider_id)
 29 
    provider = get_provider_by_id(provider_id)
30 
    for number in numbers:
 30 
    for number in numbers:
- 
 
 31 
        query = AWB.query.filter(AWB.awb_number == number)
- 
 
 32 
        query = query.filter(AWB.provider_id == provider_id)
- 
 
 33 
        try:
- 
 
 34 
            query.one()
- 
 
 35 
        except:
31 
        awb = AWB()
 36 
            awb = AWB()
32 
        awb.awb_number = number
 37 
            awb.awb_number = number
33 
        awb.provider = provider
 38 
            awb.provider = provider
34 
        awb.is_available = True
 39 
            awb.is_available = True
35 
    session.commit()
40 
    session.commit()
36 
 
 41 
 
- 
 
 42 
def set_AWB_as_used(awb_number):
- 
 
 43 
    query = AWB.query.filter_by(awb_number = awb_number)
- 
 
 44 
    awb = query.one()
- 
 
 45 
    awb.is_available=False
- 
 
 46 
    session.commit()
- 
 
 47
37 
def get_empty_AWB(provider_id):
 48 
def get_empty_AWB(provider_id):
38 
    provider = Provider.get_by(id = provider_id)
 - 
 
39 
    query = AWB.query.filter_by(provider = provider)  #check the provider thing
 49 
    query = AWB.query.filter_by(provider_id = provider_id)  #check the provider thing
40 
    query = query.filter_by(is_available=True)
 50 
    query = query.filter_by(is_available=True)
41 
    try:
 51 
    try:
42 
        return query.one()
 52 
        awbs = query.all()
- 
 
 53 
        awb = awbs[0]
- 
 
 54 
        set_AWB_as_used(awb.awb_number)
- 
 
 55 
        return awb.awb_number
43 
    except:
 56 
    except:
44 
        return "129102" #generate new exception
 57 
        return "129102" #generate new exception
45 
 
 58 
 
46 
def get_providers():
 59 
def get_providers():
47 
    return Provider.query.all()
 60 
    return Provider.query.all()