Subversion Repositories SmartDukaan

Rev

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

Rev 15302 Rev 15303
Line 1... Line -...
1 
from sqlalchemy.sql.expression import func
 - 
 
2 
from bson import json_util
 1 
from bson import json_util
3 
from bson.json_util import dumps
 2 
from bson.json_util import dumps
4 
from datetime import datetime, timedelta
 3 
from datetime import datetime, timedelta
5 
from dtr import main
 4 
from dtr import main
6 
from dtr.config import PythonPropertyReader
 5 
from dtr.config import PythonPropertyReader
Line 11... Line 10...
11 
from dtr.utils import FetchLivePrices, DealSheet as X_DealSheet, \
 10 
from dtr.utils import FetchLivePrices, DealSheet as X_DealSheet, \
12 
    UserSpecificDeals
 11 
    UserSpecificDeals
13 
from dtr.utils.utils import getLogger
 12 
from dtr.utils.utils import getLogger
14 
from elixir import *
 13 
from elixir import *
15 
from operator import and_
 14 
from operator import and_
16 
from sqlalchemy.sql.expression import or_
 15 
from sqlalchemy.sql.expression import func, func, or_
17 
from urllib import urlencode
 16 
from urllib import urlencode
18 
import contextlib
 17 
import contextlib
19 
import falcon
 18 
import falcon
20 
import json
 19 
import json
21 
import string
 20 
import string
22 
import traceback
 21 
import traceback
23 
import urllib
 22 
import urllib
24 
import urllib2
 23 
import urllib2
25 
import uuid
 24 
import uuid
26 
from sqlalchemy.sql.expression import func
 - 
 
27 
alphalist = list(string.uppercase)
 25 
alphalist = list(string.uppercase)
28 
alphalist.remove('O')
 26 
alphalist.remove('O')
29 
numList = ['1','2','3','4','5','6','7','8','9']
 27 
numList = ['1','2','3','4','5','6','7','8','9']
30 
codesys = [alphalist, alphalist, numList, numList, numList]
 28 
codesys = [alphalist, alphalist, numList, numList, numList]
31 
 
 29 
 
Line 1014... Line 1012...
1014 
            contact=jsonReq.get('searchTerm')
 1012 
            contact=jsonReq.get('searchTerm')
1015 
            if(searchType=="number"):
 1013 
            if(searchType=="number"):
1016 
                anotherCondition = or_(Retailers.contact1==contact,Retailers.contact2==contact)
 1014 
                anotherCondition = or_(Retailers.contact1==contact,Retailers.contact2==contact)
1017 
            elif(searchType=="counter"):
1015 
            elif(searchType=="counter"):
1018 
                contact = contact.lower()
 1016 
                contact = contact.lower()
1019 
                anotherCondition = Retailers.title==contact
 1017 
                anotherCondition = Retailers.title.ilike('%%%s%%'%(contact))
1020
1018
1021 
            searchUser = session.query(Retailers).filter(Retailers.modified != None).filter(anotherCondition).all()
 1019 
            searchUser = session.query(Retailers).filter(Retailers.modified != None).filter(anotherCondition).all()
1022 
            if searchUser is None:
 1020 
            if searchUser is None:
1023 
                resp.body = json.dumps("{}")
 1021 
                resp.body = json.dumps("{}")
1024 
            else:
1022 
            else: