Subversion Repositories SmartDukaan

Rev

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

Rev 15251 Rev 18530
Line 16... Line 16...
16
from sqlalchemy.sql import and_
16
from sqlalchemy.sql import and_
17
from sqlalchemy.sql.expression import or_
17
from sqlalchemy.sql.expression import or_
18
import datetime
18
import datetime
19
import os, binascii
19
import os, binascii
20
 
20
 
21
CounterStateMap = {"Telangana" : "TS", "Andhra Pradesh" : "AP"}
21
CounterStateMap = {"Telangana" : "TS", "Andhra Pradesh" : "AP", "Delhi" : "DL"}
22
 
22
 
23
def initialize(dbname='user', db_hostname="localhost"):
23
def initialize(dbname='user', db_hostname="localhost"):
24
    log_entry("initialize@DataAccessor", "Initializing data service")
24
    log_entry("initialize@DataAccessor", "Initializing data service")
25
    Dataservice.initialize(dbname, db_hostname)
25
    Dataservice.initialize(dbname, db_hostname)
26
 
26
 
Line 411... Line 411...
411
            return False
411
            return False
412
    except:
412
    except:
413
        return False
413
        return False
414
 
414
 
415
def get_all_addresses_for_user(userId):
415
def get_all_addresses_for_user(userId):
-
 
416
    privateDealUser = get_private_deal_user(userId)
-
 
417
    if privateDealUser is None:
416
    return Address.query.filter_by(user_id = userId, enabled=True).all()
418
        return Address.query.filter_by(user_id = userId, enabled=True).all()
-
 
419
    else:
-
 
420
        if privateDealUser.counter and privateDealUser.counter.documentVerified:
-
 
421
            return Address.query.filter_by(user_id = userId, enabled=True).all()
-
 
422
        else:
-
 
423
            return Address.query.filter_by(id=privateDealUser.counter.addressId).all()
417
    
424
    
418
def get_default_address_id(userId):
425
def get_default_address_id(userId):
419
    user = get_user_by_id(userId);
426
    user = get_user_by_id(userId);
-
 
427
    privateDealUser = get_private_deal_user(userId)
-
 
428
    if privateDealUser is None:
420
    if user.default_address_id is None:
429
        if user.default_address_id is None:
421
        return 0
430
            return 0
-
 
431
    else:
-
 
432
        if privateDealUser.counter and privateDealUser.counter.documentVerified:
-
 
433
            if user.default_address_id is None:
-
 
434
                return 0                
-
 
435
        else:
-
 
436
            return privateDealUser.counter.addressId
422
    return user.default_address_id
437
    return user.default_address_id
423
 
438
 
424
def get_default_pincode(user_id):
439
def get_default_pincode(user_id):
425
    user = get_user_by_id(user_id)
440
    user = get_user_by_id(user_id)
426
    if not user:
441
    if not user:
Line 672... Line 687...
672
        session.commit()
687
        session.commit()
673
        return True
688
        return True
674
    else:
689
    else:
675
        return False
690
        return False
676
        
691
        
-
 
692
def is_tax_invoice_counter(userId):
-
 
693
    privateDealUser = get_private_deal_user(userId)
-
 
694
    if privateDealUser is None:
-
 
695
        return False
-
 
696
    else:
-
 
697
        if privateDealUser.counter and privateDealUser.counter.documentVerified:
-
 
698
            return False
-
 
699
        else:
-
 
700
            return True   
-
 
701
 
-
 
702
def get_billing_address_for_user(userId):
-
 
703
    privateDealUser = get_private_deal_user(userId)
-
 
704
    if privateDealUser.counter and privateDealUser.counter.documentVerified:
-
 
705
        user = get_user_by_id(userId)
-
 
706
        return get_address(user.default_address_id)
-
 
707
    else:
-
 
708
        return get_address(privateDealUser.counter.addressId)
677
    
709
    
678
def close_session():
710
def close_session():
679
    if session.is_active:
711
    if session.is_active:
680
        print "session is active. closing it."
712
        print "session is active. closing it."
681
        session.close()
713
        session.close()