Subversion Repositories SmartDukaan

# -*- coding: utf-8 -*-

"""Main Controller"""

from tg import expose, flash, require, url, request, redirect

from pylons.i18n import ugettext as _, lazy_ugettext as l_

from wiki20.lib.base import BaseController

from wiki20.model import DBSession, metadata

from wiki20.controllers.error import ErrorController

from wiki20.processors.RequestProcessors import process_gaurav

from datastore.DataAccessor import DataHelper

from datastore.DataCodeAccessor import *

from xml.etree.ElementTree import *

import urllib

from tg import tmpl_context

from wiki20.widgets.infibeam_form import create_infibeam_form

__all__ = ['RootController']

class RootController(BaseController):

    """

    The root controller for the Wiki-20 application.

    All the other controllers and WSGI applications should be mounted on this

    controller. For example::

        panel = ControlPanelController()

        another_app = AnotherWSGIApplication()

    Keep in mind that WSGI applications shouldn't be mounted directly: They

    must be wrapped around with :class:`tg.controllers.WSGIAppController`.

    """

    error = ErrorController()

    @expose('wiki20.templates.index')

    def index(self):

        """Handle the front-page."""

        return dict(page='index')

    @expose('wiki20.templates.about')

    def about(self):

        """Handle the 'about' page."""

        return dict(page='about')

    @expose('wiki20.templates.gaurav')

    def gaurav(self, **data):

        """ Handle gaurav url"""

        print data

        ret_val = process_gaurav(data)

        return ret_val

    @expose('wiki20.templates.compare')

    def compare(self):

        """ Handle compare url"""

        str1 = ""

        da = DataHelper()

        models = da.get_all_models()

        ret_val = {}

        for m in models:

            name = m.model

            str1 = str1 + "<option value="

            #str1 = str1 + "/'"

            str1 = str1 + unicode(name, "iso-8859-1")

            #str1 = str1 + "/'"

            str1 = str1 + ">"

            str1 = str1 + unicode(name, "iso-8859-1")

            str1 = str1 + "</option>"

        #print data

        #ret_val = process_compare(data)

        ret_val['val1'] = str1

        return ret_val

    @expose('wiki20.templates.compare_model')

    def compare_model(self,**data):

        model = data['model']

        da = DataHelper()

        mid = da.get_modbyModel(model).id

        models_list = da.get_prbyMid(mid)

        sorted(models_list, key=lambda prices: prices.supplier_id)

        leng = len(models_list)

        print "length is :"

        print leng

        price_list = []

        vendor_list = []

        while leng>0:

            price_list.append(0)

             #['infibeam','indiaplaza','mobilestore','univercell']

            leng = leng -1

        max = 0

        index = 0

        for m in models_list:

            price_list[index] = m.final_price

            index = index + 1

            s_info = ""

            s_info = s_info + str(da.get_supp_byId(m.supplier_id).name) 

            if str(m.extra_info) != "":

                s_info = s_info + " with " 

                s_info = s_info + str(m.extra_info)

            vendor_list.append(s_info)

            if(m.final_price > max):

                max = m.final_price

        range = 0

        if max<3000:

            range = 3000 

        elif max>=3000 and max<5000:

            range = 5000   

        elif max>=5000 and max<7000:

            range = 7000   

        elif max>=7000 and max<10000:

            range = 10000   

        elif max>=10000 and max<15000:

            range = 15000   

        elif max>=15000 and max<20000:

            range = 20000   

        elif max>=20000 and max<25000:

            range = 25000   

        elif max>=25000 and max<30000:

            range = 30000   

        elif max>=30000 and max<50000:

            range = 50000   

        str3 = ""

        for p in price_list:

            str3 = str3 + str(p) 

            str3 = str3 + ","

        str3 = str3[0:len(str3)-1]

        str4 = ""

        for v in vendor_list:

            str4 = str4 + v 

            str4 = str4 + "|"

        str4 = str4[0:len(str4)-1]

        ret_val = {}

        ret_val['val1'] = str3

        ret_val['val2'] = str4

        #ret_val['val1'] = price_list

        #ret_val['val2'] = vendor_list

        str1 = ""

        models = da.get_all_models()

        for m in models:

            name = m.model

            str1 = str1 + "<option value="

            #str1 = str1 + "/'"

            str1 = str1 + unicode(name, "iso-8859-1")

            #str1 = str1 + "/'"

            if str(name) == str(model):

                str1 = str1 + " selected=yes"

            str1 = str1 + ">"

            str1 = str1 + unicode(name, "iso-8859-1")

            str1 = str1 + "</option>"

        ret_val['val3'] = str1

        ret_val['val4'] = range

        str2 = ""

        str2 = str2 + '<table align = "right"><tr><th>' 

        str2 = str2 + "vendor"

        str2 = str2 + "</th><th>"

        str2 = str2 + "price"

        str2 = str2 + "</th></tr>"

        leng = len(vendor_list)

        j = 0

        while(j<leng):

            str2 = str2 + "<tr><td>"

            str2 = str2 + str(vendor_list[j]) 

            str2 = str2 + "</td><td>"

            str2 = str2 + str(price_list[j])

            str2 = str2 + "</td></tr>"

            j = j+1

        str2 = str2 + "</table>"

        ret_val['val5'] = str2    

        return ret_val

    @expose(template="wiki20.templates.model" , content_type='text/xml')

    def model(self, **data):   

        #print " I m in "

        id = int(data['id'])

        str1 = brandname = modelname =  extra_i = sup_name = sup_site = sup_lastcrawled = ""

        quoted_p = final_p = 0

        da = DataHelper()

        mo = da.get_modbyId(id)

        brandname = mo.brand

        modelname = mo.model

        prlist = da.get_prbyMid(id)

        #print len(prlist)

        str1 = str1 + "<Mobile><mid>" 

        str1 = str1 + str(id)

        str1 = str1 + "</mid><barandname>" 

        str1 = str1 + unicode(brandname, "iso-8859-1")           

        str1 = str1 + "</barandname><modelname>" 

        str1 = str1 + unicode(modelname, "iso-8859-1")

        str1 = str1 + "</modelname>"

        sorted(prlist, key=lambda prices: prices.supplier_id)

        prev_sid = -1    

        ct = 0

        for pr in prlist:

            quoted_p = pr.quoted_price

            final_p = pr.final_price

            extra_i = pr.extra_info

            pid = pr.id

            sid = pr.supplier_id

            su = da.get_supp_byId(sid)

            sup_name = su.name

            sup_site = su.site

            sup_lastcrawled = su.last_crawled

            '''

            print brandname

            print modelname 

            print quoted_p

            print final_p 

            print extra_i 

            print sup_name 

            print sup_site

            print sup_lastcrawled

            '''

            if sid != prev_sid:

                if ct != 0:

                     str1 = str1 + "</Supplier>";

                str1 = str1 + "<Supplier>";

                str1 = str1 + "<name>" 

                str1 = str1 + unicode(sup_name, "iso-8859-1") 

                str1 = str1 + "</name><sid>" 

                str1 = str1 + str(sid)

                str1 = str1 + "</sid><site>" 

                str1 = str1 +  unicode(sup_site, "iso-8859-1")

                str1 = str1 + "</site><last_updated>"

                str1 = str1 + str(sup_lastcrawled) 

                str1 = str1 + "</last_updated>"

                prev_sid = sid

            ct = ct+1    

            str1 = str1 + "<Price><pid>"

            str1 = str1 + str(pid) 

            str1 = str1 + "</pid><quotedprice>"

            str1 = str1 + str(quoted_p) 

            str1 = str1 + "</quotedprice><finalprice>"

            str1 = str1 + str(final_p) 

            str1 = str1 + "</finalprice><extrainfo>"

            str1 = str1 + unicode(extra_i, "iso-8859-1") 

            str1 = str1 + "</extrainfo></Price>" 

            #str1 = str1 + "</Supplier>"

            #root = Element(str1)

            #xml_elem = xml.etree.ElementTree.fromstring(str1)

        str1 = str1 + "</Supplier>";

        str1 = str1 + "</Mobile>"

        ret_val = {}

        ret_val['val1'] = urllib.unquote(str1)#root

        #tree = ElementTree(root)

        #tree.write("/home/gaurav/code/TG2Test/src/wiki20/templates/model.html")

        print str1 

        return ret_val

    @expose(template="wiki20.templates.modelIds" , content_type='text/xml')

    def mobileIds(self):   

        da = DataHelper()

        mobiles = da.get_all_models()

        str1 = ""

        for m in mobiles:

            id = m.id

            model = m.model

            brand = m.brand

            str1 = str1 + "<Mobile><id>"

            str1 = str1 + str(id)

            str1 = str1 + "</id><model>"

            str1 = str1 + unicode(model, "iso-8859-1")

            str1 = str1 + "</model><vendor>"

            str1 = str1 + unicode(brand, "iso-8859-1")

            str1 = str1 + "</vendor></Mobile>"

        ret_val = {}

        print str1

        ret_val['val1'] = urllib.unquote(str1)#root

        return ret_val

    @expose('wiki20.templates.infibeam_form')

    def form_infibeam(self, **kw):

    #"""Show form to add data record for infibeam."""

        tmpl_context.form = create_infibeam_form

        return dict(modelname='code_words',

        page='Infibeam Data')

    @expose()

    def save_infibeam(self, **kw):

        """Create a infibeam object and save it to the database."""

        initialize_table()

        set_code_word("INFIBEAM_DOMAINNAME",kw['INFIBEAM_DOMAINNAME'],"")  

        print kw['INFIBEAM_DOMAINNAME']

        set_code_word("INFIBEAM_NO",kw['INFIBEAM_NO'],"")

        print kw['INFIBEAM_NO']

        set_code_word("INFIBEAM_CT",kw['INFIBEAM_CT'],"")

        set_code_word("INFIBEAM_URL",kw['INFIBEAM_URL'],"")

        set_code_word("INFIBEAM_HOMEPAGE",kw['INFIBEAM_HOMEPAGE'],"")

        set_code_word("INFIBEAM_REFERER",kw['INFIBEAM_REFERER'],"")

        set_code_word("INFIBEAM_VATPLUSTAX",kw['INFIBEAM_VATPLUSTAX'],"")

        set_code_word("INFIBEAM_REMOVELIST",kw['INFIBEAM_REMOVELIST'],"")

        set_code_word("INFIBEAM_XPATH1",kw['INFIBEAM_XPATH1'],"")

        set_code_word("INFIBEAM_XPATH2",kw['INFIBEAM_XPATH2'],"")

        set_code_word("INFIBEAM_XPATH3",kw['INFIBEAM_XPATH3'],"")

        flash("Data successfully saved.")

        redirect("form_infibeam")