Subversion Repositories SmartDukaan

Rev

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

Rev 12698 Rev 12722
Line 12... Line 12...
12
from shop2020.thriftpy.model.v1.user.ttypes import UserContextException, \
12
from shop2020.thriftpy.model.v1.user.ttypes import UserContextException, \
13
    AuthenticationException, Sex, WidgetType as WType
13
    AuthenticationException, Sex, WidgetType as WType
14
from shop2020.utils.Utils import log_entry, to_py_date
14
from shop2020.utils.Utils import log_entry, to_py_date
15
from sqlalchemy import desc, select
15
from sqlalchemy import desc, select
16
from sqlalchemy.sql import and_
16
from sqlalchemy.sql import and_
-
 
17
from sqlalchemy.sql.expression import or_
17
import datetime
18
import datetime
18
 
19
 
19
CounterStateMap = {"Telangana" : "TS", "Andhra Pradesh" : "AP"}
20
CounterStateMap = {"Telangana" : "TS", "Andhra Pradesh" : "AP"}
20
 
21
 
21
def initialize(dbname='user', db_hostname="localhost"):
22
def initialize(dbname='user', db_hostname="localhost"):
Line 614... Line 615...
614
        counter.alternateMobile = tCounter.alternateMobile
615
        counter.alternateMobile = tCounter.alternateMobile
615
    if tCounter.spCounterSize:
616
    if tCounter.spCounterSize:
616
        counter.spCounterSize = tCounter.spCounterSize
617
        counter.spCounterSize = tCounter.spCounterSize
617
    if tCounter.fpCounterSize:
618
    if tCounter.fpCounterSize:
618
        counter.fpCounterSize = tCounter.fpCounterSize
619
        counter.fpCounterSize = tCounter.fpCounterSize
-
 
620
        
-
 
621
def search_counter(type1, searchString):
-
 
622
    if type1=="counter_code":
-
 
623
        return Counter.query.filter(Counter.code==searchString).all()
-
 
624
    elif type1=="mobile":
-
 
625
        return Counter.query.filter(or_(Counter.alternateMobile==searchString, Counter.mobile==searchString)).all()
-
 
626
    elif type1=="email":
-
 
627
        return Counter.query.filter(Counter.email==searchString).all()
-
 
628
    elif type1=="counter_name":
-
 
629
        return Counter.query.filter(Counter.name.like("%" + searchString + "%")).all()
-
 
630
    else:
-
 
631
        return []
-
 
632
 
-
 
633
def get_all_users_by_counter(counterid):
-
 
634
    dealers = PrivateDealUser.query.filter(PrivateDealUser.counter_id == counterid).all()
-
 
635
    dealerids = [dealer.id for dealer in dealers]
-
 
636
    print dealerids  
-
 
637
    if len(dealerids) > 0:
-
 
638
        return User.query.filter(User.id.in_(dealerids)).all()
-
 
639
    return []
-
 
640
            
-
 
641
        
619
    
642
    
620
def close_session():
643
def close_session():
621
    if session.is_active:
644
    if session.is_active:
622
        print "session is active. closing it."
645
        print "session is active. closing it."
623
        session.close()
646
        session.close()