Subversion Repositories SmartDukaan

Rev

Rev 202 | Rev 290 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
172 ashish 1
# -*- coding: utf-8 -*-
2
"""Main Controller"""
3
 
4
from tg import expose, flash, require, url, request, redirect
5
from pylons.i18n import ugettext as _, lazy_ugettext as l_
6
 
7
from wiki20.lib.base import BaseController
8
from wiki20.model import DBSession, metadata
9
from wiki20.controllers.error import ErrorController
10
from wiki20.processors.RequestProcessors import process_gaurav
11
from datastore.DataAccessor import DataHelper
202 ashish 12
from datastore.DataCodeAccessor import *
172 ashish 13
from xml.etree.ElementTree import *
14
import urllib
202 ashish 15
from tg import tmpl_context
241 ashish 16
from wiki20.widgets.infibeam_form import *
17
from wiki20.widgets.univercell_form import *
18
from wiki20.widgets.indiaplaza_form import *
19
from wiki20.widgets.mobilestore_form import *
20
from wiki20.widgets.naaptol_form import *
21
from wiki20.widgets.babuchak_form import *
172 ashish 22
 
23
__all__ = ['RootController']
24
 
25
 
26
class RootController(BaseController):
27
    """
28
    The root controller for the Wiki-20 application.
29
 
30
    All the other controllers and WSGI applications should be mounted on this
31
    controller. For example::
32
 
33
        panel = ControlPanelController()
34
        another_app = AnotherWSGIApplication()
35
 
36
    Keep in mind that WSGI applications shouldn't be mounted directly: They
37
    must be wrapped around with :class:`tg.controllers.WSGIAppController`.
38
 
39
    """
40
 
41
    error = ErrorController()
42
 
43
    @expose('wiki20.templates.index')
44
    def index(self):
45
        """Handle the front-page."""
46
        return dict(page='index')
47
 
48
    @expose('wiki20.templates.about')
49
    def about(self):
50
        """Handle the 'about' page."""
51
        return dict(page='about')
52
 
53
    @expose('wiki20.templates.gaurav')
54
    def gaurav(self, **data):
55
        """ Handle gaurav url"""
56
        print data
57
        ret_val = process_gaurav(data)
58
        return ret_val
59
 
60
 
61
    @expose('wiki20.templates.compare')
62
    def compare(self):
63
        """ Handle compare url"""
64
        str1 = ""
65
        da = DataHelper()
66
        models = da.get_all_models()
67
        ret_val = {}
68
        for m in models:
69
            name = m.model
70
            str1 = str1 + "<option value="
71
            #str1 = str1 + "/'"
72
            str1 = str1 + unicode(name, "iso-8859-1")
73
            #str1 = str1 + "/'"
74
            str1 = str1 + ">"
75
            str1 = str1 + unicode(name, "iso-8859-1")
76
            str1 = str1 + "</option>"
77
 
78
        #print data
79
        #ret_val = process_compare(data)
80
        ret_val['val1'] = str1
81
        return ret_val
82
 
83
    @expose('wiki20.templates.compare_model')
84
    def compare_model(self,**data):
85
        model = data['model']
86
        da = DataHelper()
87
        mid = da.get_modbyModel(model).id
88
        models_list = da.get_prbyMid(mid)
89
        sorted(models_list, key=lambda prices: prices.supplier_id)
90
        leng = len(models_list)
91
        print "length is :"
92
        print leng
93
        price_list = []
94
        vendor_list = []
95
        while leng>0:
96
            price_list.append(0)
97
             #['infibeam','indiaplaza','mobilestore','univercell']
98
            leng = leng -1
99
        max = 0
100
        index = 0
101
        for m in models_list:
102
            price_list[index] = m.final_price
103
            index = index + 1
104
            s_info = ""
105
            s_info = s_info + str(da.get_supp_byId(m.supplier_id).name) 
106
            if str(m.extra_info) != "":
107
                s_info = s_info + " with " 
108
                s_info = s_info + str(m.extra_info)
109
 
110
            vendor_list.append(s_info)
111
            if(m.final_price > max):
112
                max = m.final_price
113
        range = 0
114
        if max<3000:
115
            range = 3000 
116
        elif max>=3000 and max<5000:
117
            range = 5000   
118
        elif max>=5000 and max<7000:
119
            range = 7000   
120
        elif max>=7000 and max<10000:
121
            range = 10000   
122
        elif max>=10000 and max<15000:
123
            range = 15000   
124
        elif max>=15000 and max<20000:
125
            range = 20000   
126
        elif max>=20000 and max<25000:
127
            range = 25000   
128
        elif max>=25000 and max<30000:
129
            range = 30000   
130
        elif max>=30000 and max<50000:
131
            range = 50000   
132
        str3 = ""
133
        for p in price_list:
134
            str3 = str3 + str(p) 
135
            str3 = str3 + ","
136
        str3 = str3[0:len(str3)-1]
137
        str4 = ""
138
        for v in vendor_list:
139
            str4 = str4 + v 
140
            str4 = str4 + "|"
141
        str4 = str4[0:len(str4)-1]
142
 
143
        ret_val = {}
144
        ret_val['val1'] = str3
145
        ret_val['val2'] = str4
146
        #ret_val['val1'] = price_list
147
        #ret_val['val2'] = vendor_list
148
        str1 = ""
149
        models = da.get_all_models()
150
        for m in models:
151
            name = m.model
152
            str1 = str1 + "<option value="
153
            #str1 = str1 + "/'"
154
            str1 = str1 + unicode(name, "iso-8859-1")
155
            #str1 = str1 + "/'"
156
            if str(name) == str(model):
157
                str1 = str1 + " selected=yes"
158
            str1 = str1 + ">"
159
            str1 = str1 + unicode(name, "iso-8859-1")
160
            str1 = str1 + "</option>"
161
        ret_val['val3'] = str1
162
        ret_val['val4'] = range
163
        str2 = ""
164
        str2 = str2 + '<table align = "right"><tr><th>' 
165
        str2 = str2 + "vendor"
166
        str2 = str2 + "</th><th>"
167
        str2 = str2 + "price"
168
        str2 = str2 + "</th></tr>"
169
        leng = len(vendor_list)
170
        j = 0
171
        while(j<leng):
172
            str2 = str2 + "<tr><td>"
173
            str2 = str2 + str(vendor_list[j]) 
174
            str2 = str2 + "</td><td>"
175
            str2 = str2 + str(price_list[j])
176
            str2 = str2 + "</td></tr>"
177
            j = j+1
178
        str2 = str2 + "</table>"
179
        ret_val['val5'] = str2    
180
        return ret_val
181
 
182
 
183
    @expose(template="wiki20.templates.model" , content_type='text/xml')
184
    def model(self, **data):   
185
        #print " I m in "
186
        id = int(data['id'])
187
        str1 = brandname = modelname =  extra_i = sup_name = sup_site = sup_lastcrawled = ""
188
        quoted_p = final_p = 0
189
        da = DataHelper()
190
        mo = da.get_modbyId(id)
191
        brandname = mo.brand
192
        modelname = mo.model
193
        prlist = da.get_prbyMid(id)
194
        #print len(prlist)
195
 
196
        str1 = str1 + "<Mobile><mid>" 
197
        str1 = str1 + str(id)
198
        str1 = str1 + "</mid><barandname>" 
199
        str1 = str1 + unicode(brandname, "iso-8859-1")           
200
        str1 = str1 + "</barandname><modelname>" 
201
        str1 = str1 + unicode(modelname, "iso-8859-1")
202
        str1 = str1 + "</modelname>"
203
        sorted(prlist, key=lambda prices: prices.supplier_id)
204
        prev_sid = -1    
205
        ct = 0
206
        for pr in prlist:
207
            quoted_p = pr.quoted_price
208
            final_p = pr.final_price
209
            extra_i = pr.extra_info
210
            pid = pr.id
211
            sid = pr.supplier_id
212
            su = da.get_supp_byId(sid)
213
            sup_name = su.name
214
            sup_site = su.site
215
            sup_lastcrawled = su.last_crawled
216
            '''
217
            print brandname
218
            print modelname 
219
            print quoted_p
220
            print final_p 
221
            print extra_i 
222
            print sup_name 
223
            print sup_site
224
            print sup_lastcrawled
225
            '''
226
 
227
            if sid != prev_sid:
228
                if ct != 0:
229
                     str1 = str1 + "</Supplier>";
230
                str1 = str1 + "<Supplier>";
231
                str1 = str1 + "<name>" 
232
                str1 = str1 + unicode(sup_name, "iso-8859-1") 
233
                str1 = str1 + "</name><sid>" 
234
                str1 = str1 + str(sid)
235
                str1 = str1 + "</sid><site>" 
236
                str1 = str1 +  unicode(sup_site, "iso-8859-1")
237
                str1 = str1 + "</site><last_updated>"
238
                str1 = str1 + str(sup_lastcrawled) 
239
                str1 = str1 + "</last_updated>"
240
                prev_sid = sid
241
            ct = ct+1    
242
            str1 = str1 + "<Price><pid>"
243
            str1 = str1 + str(pid) 
244
            str1 = str1 + "</pid><quotedprice>"
245
            str1 = str1 + str(quoted_p) 
246
            str1 = str1 + "</quotedprice><finalprice>"
247
            str1 = str1 + str(final_p) 
248
            str1 = str1 + "</finalprice><extrainfo>"
249
            str1 = str1 + unicode(extra_i, "iso-8859-1") 
250
            str1 = str1 + "</extrainfo></Price>" 
251
            #str1 = str1 + "</Supplier>"
252
            #root = Element(str1)
253
            #xml_elem = xml.etree.ElementTree.fromstring(str1)
254
        str1 = str1 + "</Supplier>";
255
        str1 = str1 + "</Mobile>"
256
        ret_val = {}
257
        ret_val['val1'] = urllib.unquote(str1)#root
258
        #tree = ElementTree(root)
259
        #tree.write("/home/gaurav/code/TG2Test/src/wiki20/templates/model.html")
260
        print str1 
261
        return ret_val
262
 
263
    @expose(template="wiki20.templates.modelIds" , content_type='text/xml')
264
    def mobileIds(self):   
265
        da = DataHelper()
266
        mobiles = da.get_all_models()
267
        str1 = ""
268
        for m in mobiles:
269
            id = m.id
270
            model = m.model
271
            brand = m.brand
272
            str1 = str1 + "<Mobile><id>"
273
            str1 = str1 + str(id)
274
            str1 = str1 + "</id><model>"
275
            str1 = str1 + unicode(model, "iso-8859-1")
276
            str1 = str1 + "</model><vendor>"
277
            str1 = str1 + unicode(brand, "iso-8859-1")
278
            str1 = str1 + "</vendor></Mobile>"
279
        ret_val = {}
280
        print str1
281
        ret_val['val1'] = urllib.unquote(str1)#root
202 ashish 282
        return ret_val
283
 
241 ashish 284
    @expose('wiki20.templates.input_form')
202 ashish 285
    def form_infibeam(self, **kw):
241 ashish 286
        """Show form to add data record for infibeam."""
287
        initialize_table()
288
        create_infibeam_form = InfibeamForm("create_infibeam_form",action='save_infibeam')
202 ashish 289
        tmpl_context.form = create_infibeam_form
241 ashish 290
        de = get_code_word("INFIBEAM_DOMAINNAME")
291
        kw['INFIBEAM_DOMAINNAME'] = de
292
        #de = get_code_word("INFIBEAM_NO")
293
        #kw['INFIBEAM_NO'] = de
294
        #de = get_code_word("INFIBEAM_CT")
295
        #kw['INFIBEAM_CT'] = de
296
        de = get_code_word("INFIBEAM_URL")
297
        kw['INFIBEAM_URL'] = de
298
        de = get_code_word("INFIBEAM_HOMEPAGE")
299
        kw['INFIBEAM_HOMEPAGE'] = de
300
        de = get_code_word("INFIBEAM_REFERER")
301
        kw['INFIBEAM_REFERER'] = de
302
        de = get_code_word("INFIBEAM_VATPLUSTAX")
303
        kw['INFIBEAM_VATPLUSTAX'] = de
304
        de = get_code_word("INFIBEAM_REMOVELIST")
305
        kw['INFIBEAM_REMOVELIST'] = de
306
        de = get_code_word("INFIBEAM_XPATH1")
307
        kw['INFIBEAM_XPATH1'] = de
308
        de = get_code_word("INFIBEAM_XPATH2")
309
        kw['INFIBEAM_XPATH2'] = de
310
        de = get_code_word("INFIBEAM_XPATH3")
311
        kw['INFIBEAM_XPATH3'] = de   
312
        return dict(modelname='infibeam_form',
313
        value=kw)
202 ashish 314
 
241 ashish 315
    @expose('wiki20.templates.input_form')
202 ashish 316
    def save_infibeam(self, **kw):
317
        """Create a infibeam object and save it to the database."""
318
        set_code_word("INFIBEAM_DOMAINNAME",kw['INFIBEAM_DOMAINNAME'],"")  
241 ashish 319
        #set_code_word("INFIBEAM_NO",kw['INFIBEAM_NO'],"")
320
        #set_code_word("INFIBEAM_CT",kw['INFIBEAM_CT'],"")
202 ashish 321
        set_code_word("INFIBEAM_URL",kw['INFIBEAM_URL'],"")
322
        set_code_word("INFIBEAM_HOMEPAGE",kw['INFIBEAM_HOMEPAGE'],"")
323
        set_code_word("INFIBEAM_REFERER",kw['INFIBEAM_REFERER'],"")
324
        set_code_word("INFIBEAM_VATPLUSTAX",kw['INFIBEAM_VATPLUSTAX'],"")
325
        set_code_word("INFIBEAM_REMOVELIST",kw['INFIBEAM_REMOVELIST'],"")
326
        set_code_word("INFIBEAM_XPATH1",kw['INFIBEAM_XPATH1'],"")
327
        set_code_word("INFIBEAM_XPATH2",kw['INFIBEAM_XPATH2'],"")
328
        set_code_word("INFIBEAM_XPATH3",kw['INFIBEAM_XPATH3'],"")
329
        flash("Data successfully saved.")
330
        redirect("form_infibeam")
241 ashish 331
 
332
    @expose('wiki20.templates.input_form')
333
    def form_univercell(self, **kw):
334
    #"""Show form to add data record for univercell."""
335
        initialize_table()
336
        create_univercell_form = UnivercellForm("create_univercell_form",action='save_univercell')
337
        tmpl_context.form = create_univercell_form
338
        de = get_code_word("UNIVERCELL_DOMAINNAME")
339
        kw['UNIVERCELL_DOMAINNAME']=de
340
        de = get_code_word("UNIVERCELL_DOMAINNAME1")
341
        kw['UNIVERCELL_DOMAINNAME1']=de
342
        de = get_code_word("UNIVERCELL_URL")
343
        kw['UNIVERCELL_URL']=de
344
        de = get_code_word("UNIVERCELL_HOMEPAGE")
345
        kw['UNIVERCELL_HOMEPAGE']=de
346
        de = get_code_word("UNIVERCELL_REFERER")
347
        kw['UNIVERCELL_REFERER']=de
348
        de = get_code_word("UNIVERCELL_URL1")
349
        kw['UNIVERCELL_URL1']=de
350
        de = get_code_word("UNIVERCELL_XPATH1")
351
        kw['UNIVERCELL_XPATH1']=de
352
        de = get_code_word("UNIVERCELL_XPATH2")
353
        kw['UNIVERCELL_XPATH2']=de
354
        de = get_code_word("UNIVERCELL_XPATH3")
355
        kw['UNIVERCELL_XPATH3']=de
356
        de = get_code_word("UNIVERCELL_XPATH4")
357
        kw['UNIVERCELL_XPATH4']=de
358
        de = get_code_word("UNIVERCELL_XPATH5")
359
        kw['UNIVERCELL_XPATH5']=de
360
        de = get_code_word("UNIVERCELL_XPATH6")
361
        kw['UNIVERCELL_XPATH6']=de
362
        de = get_code_word("UNIVERCELL_VAR1")
363
        kw['UNIVERCELL_VAR1']=de
364
        de = get_code_word("UNIVERCELL_VAR2")
365
        kw['UNIVERCELL_VAR2']=de
366
        de = get_code_word("UNIVERCELL_VAR3")
367
        kw['UNIVERCELL_VAR3']=de
368
        de = get_code_word("UNIVERCELL_VAR4")
369
        kw['UNIVERCELL_VAR4']=de
370
        de = get_code_word("UNIVERCELL_VATPLUSTAX")
371
        kw['UNIVERCELL_VATPLUSTAX']=de
372
        de = get_code_word("UNIVERCELL_REMOVELIST")
373
        kw['UNIVERCELL_REMOVELIST']=de
374
        return dict(modelname='univercell_form',
375
        value=kw)
202 ashish 376
 
241 ashish 377
    @expose('wiki20.templates.input_form')
378
    def save_univercell(self, **kw):
379
        """Create a univercell object and save it to the database."""
380
        set_code_word("UNIVERCELL_DOMAINNAME",kw['UNIVERCELL_DOMAINNAME'],"")  
381
        set_code_word("UNIVERCELL_URL",kw['UNIVERCELL_URL'],"")
382
        set_code_word("UNIVERCELL_HOMEPAGE",kw['UNIVERCELL_HOMEPAGE'],"")
383
        set_code_word("UNIVERCELL_REFERER",kw['UNIVERCELL_REFERER'],"")
384
        set_code_word("UNIVERCELL_URL1",kw['UNIVERCELL_URL1'],"")
385
        set_code_word("UNIVERCELL_XPATH1",kw['UNIVERCELL_XPATH1'],"")
386
        set_code_word("UNIVERCELL_XPATH2",kw['UNIVERCELL_XPATH2'],"")
387
        set_code_word("UNIVERCELL_XPATH3",kw['UNIVERCELL_XPATH3'],"")
388
        set_code_word("UNIVERCELL_XPATH4",kw['UNIVERCELL_XPATH4'],"")
389
        set_code_word("UNIVERCELL_XPATH5",kw['UNIVERCELL_XPATH5'],"")
390
        set_code_word("UNIVERCELL_XPATH6",kw['UNIVERCELL_XPATH6'],"")
391
        set_code_word("UNIVERCELL_VATPLUSTAX",kw['UNIVERCELL_VATPLUSTAX'],"")
392
        set_code_word("UNIVERCELL_REMOVELIST",kw['UNIVERCELL_REMOVELIST'],"")
393
        set_code_word("UNIVERCELL_VAR1",kw['UNIVERCELL_VAR1'],"")
394
        set_code_word("UNIVERCELL_VAR2",kw['UNIVERCELL_VAR2'],"")
395
        set_code_word("UNIVERCELL_VAR3",kw['UNIVERCELL_VAR3'],"")
396
        set_code_word("UNIVERCELL_VAR4",kw['UNIVERCELL_VAR4'],"")
397
        set_code_word("UNIVERCELL_DOMAINNAME1",kw['UNIVERCELL_DOMAINNAME1'],"")
398
        flash("Data successfully saved.")
399
        redirect("form_univercell")
400
 
401
 
402
    @expose('wiki20.templates.input_form')
403
    def form_indiaplaza(self, **kw):
404
        """Show form to add data record for indiaplaza."""
405
        de = get_code_word("INDIAPLAZA_DOMAINNAME")
406
        kw['INDIAPLAZA_DOMAINNAME']=de
407
        de = get_code_word("INDIAPLAZA_DOMAINNAME1")
408
        kw['INDIAPLAZA_DOMAINNAME1']=de
409
        de = get_code_word("INDIAPLAZA_URL")
410
        kw['INDIAPLAZA_URL']=de
411
        de = get_code_word("INDIAPLAZA_HOMEPAGE")
412
        kw['INDIAPLAZA_HOMEPAGE']=de
413
        de = get_code_word("INDIAPLAZA_REFERER")
414
        kw['INDIAPLAZA_REFERER']=de
415
        de = get_code_word("INDIAPLAZA_URL1")
416
        kw['INDIAPLAZA_URL1']=de
417
        de = get_code_word("INDIAPLAZA_XPATH1")
418
        kw['INDIAPLAZA_XPATH1']=de
419
        de = get_code_word("INDIAPLAZA_XPATH2")
420
        kw['INDIAPLAZA_XPATH2']=de
421
        de = get_code_word("INDIAPLAZA_XPATH3")
422
        kw['INDIAPLAZA_XPATH3']=de
423
        de = get_code_word("INDIAPLAZA_XPATH4")
424
        kw['INDIAPLAZA_XPATH4']=de
425
        de = get_code_word("INDIAPLAZA_XPATH5")
426
        kw['INDIAPLAZA_XPATH5']=de
427
        de = get_code_word("INDIAPLAZA_XPATH6")
428
        kw['INDIAPLAZA_XPATH6']=de
429
        de = get_code_word("INDIAPLAZA_XPATH7")
430
        kw['INDIAPLAZA_XPATH7']=de
431
        de = get_code_word("INDIAPLAZA_XPATH8")
432
        kw['INDIAPLAZA_XPATH8']=de
433
        de = get_code_word("INDIAPLAZA_XPATH9")
434
        kw['INDIAPLAZA_XPATH9']=de
435
        de = get_code_word("INDIAPLAZA_XPATH10")
436
        kw['INDIAPLAZA_XPATH10']=de
437
        de = get_code_word("INDIAPLAZA_VAR1")
438
        kw['INDIAPLAZA_VAR1']=de
439
        de = get_code_word("INDIAPLAZA_REMOVELIST")
440
        kw['INDIAPLAZA_REMOVELIST']=de
441
        #de = get_code_word("INDIAPLAZA_NO")
442
        #kw['INDIAPLAZA_NO']=de
443
        #de = get_code_word("INDIAPLAZA_CT")
444
        #kw['INDIAPLAZA_CT']=de
445
        create_indiaplaza_form = IndiaplazaForm("create_indiaplaza_form",action='save_indiaplaza')
446
        tmpl_context.form = create_indiaplaza_form 
447
 
448
        return dict(modelname='indiaplaza_form',
449
        value=kw)
450
 
451
    @expose('wiki20.templates.input_form')
452
    def save_indiaplaza(self, **kw):
453
        """Create a indiaplaza object and save it to the database."""
454
        #initialize_table()
455
        set_code_word("INDIAPLAZA_DOMAINNAME",kw['INDIAPLAZA_DOMAINNAME'],"")  
456
        set_code_word("INDIAPLAZA_URL",kw['INDIAPLAZA_URL'],"")
457
        set_code_word("INDIAPLAZA_HOMEPAGE",kw['INDIAPLAZA_HOMEPAGE'],"")
458
        set_code_word("INDIAPLAZA_REFERER",kw['INDIAPLAZA_REFERER'],"")
459
        set_code_word("INDIAPLAZA_URL1",kw['INDIAPLAZA_URL1'],"")
460
        set_code_word("INDIAPLAZA_XPATH1",kw['INDIAPLAZA_XPATH1'],"")
461
        set_code_word("INDIAPLAZA_XPATH2",kw['INDIAPLAZA_XPATH2'],"")
462
        set_code_word("INDIAPLAZA_XPATH3",kw['INDIAPLAZA_XPATH3'],"")
463
        set_code_word("INDIAPLAZA_XPATH4",kw['INDIAPLAZA_XPATH4'],"")
464
        set_code_word("INDIAPLAZA_XPATH5",kw['INDIAPLAZA_XPATH5'],"")
465
        set_code_word("INDIAPLAZA_XPATH6",kw['INDIAPLAZA_XPATH6'],"")
466
        set_code_word("INDIAPLAZA_XPATH7",kw['INDIAPLAZA_XPATH7'],"")
467
        set_code_word("INDIAPLAZA_XPATH8",kw['INDIAPLAZA_XPATH8'],"")
468
        set_code_word("INDIAPLAZA_XPATH9",kw['INDIAPLAZA_XPATH9'],"")
469
        set_code_word("INDIAPLAZA_XPATH10",kw['INDIAPLAZA_XPATH10'],"")
470
        set_code_word("INDIAPLAZA_REMOVELIST",kw['INDIAPLAZA_REMOVELIST'],"")
471
        set_code_word("INDIAPLAZA_VAR1",kw['INDIAPLAZA_VAR1'],"")
472
        set_code_word("INDIAPLAZA_DOMAINNAME1",kw['INDIAPLAZA_DOMAINNAME1'],"")
473
        #set_code_word("INDIAPLAZA_NO",kw['INDIAPLAZA_NO'],"")
474
        #set_code_word("INDIAPLAZA_CT",kw['INDIAPLAZA_CT'],"")
475
        flash("Data successfully saved.")
476
        redirect("form_indiaplaza")
477
 
478
    @expose('wiki20.templates.input_form')
479
    def form_mobilestore(self, **kw):
480
    #"""Show form to add data record for mobilestore."""
481
        initialize_table()
482
        create_mobilestore_form = MobilestoreForm("create_mobilestore_form",action='save_mobilestore')
483
        tmpl_context.form = create_mobilestore_form
484
        de = get_code_word("MOBILESTORE_DOMAINNAME")
485
        kw['MOBILESTORE_DOMAINNAME']=de
486
        de = get_code_word("MOBILESTORE_DOMAINNAME1")
487
        kw['MOBILESTORE_DOMAINNAME1']=de
488
        de = get_code_word("MOBILESTORE_URL")
489
        kw['MOBILESTORE_URL']=de
490
        de = get_code_word("MOBILESTORE_HOMEPAGE")
491
        kw['MOBILESTORE_HOMEPAGE']=de
492
        de = get_code_word("MOBILESTORE_REFERER")
493
        kw['MOBILESTORE_REFERER']=de
494
        de = get_code_word("MOBILESTORE_CHKLIST1")
495
        kw['MOBILESTORE_CHKLIST1']=de
496
        de = get_code_word("MOBILESTORE_VATPLUSTAX")
497
        kw['MOBILESTORE_VATPLUSTAX']=de
498
        de = get_code_word("MOBILESTORE_REMOVELIST")
499
        kw['MOBILESTORE_REMOVELIST']=de
500
        de = get_code_word("MOBILESTORE_XPATH1")
501
        kw['MOBILESTORE_XPATH1']=de
502
        de = get_code_word("MOBILESTORE_XPATH2")
503
        kw['MOBILESTORE_XPATH2']=de
504
        de = get_code_word("MOBILESTORE_XPATH3")
505
        kw['MOBILESTORE_XPATH3']=de
506
        de = get_code_word("MOBILESTORE_XPATH4")
507
        kw['MOBILESTORE_XPATH4']=de
508
        de = get_code_word("MOBILESTORE_XPATH5")
509
        kw['MOBILESTORE_XPATH5']=de
510
        de = get_code_word("MOBILESTORE_XPATH6")
511
        kw['MOBILESTORE_XPATH6']=de
512
        de = get_code_word("MOBILESTORE_XPATH7")
513
        kw['MOBILESTORE_XPATH7']=de
514
        de = get_code_word("MOBILESTORE_XPATH8")
515
        kw['MOBILESTORE_XPATH8']=de
516
        de = get_code_word("MOBILESTORE_DOMAINNAME0")
517
        kw['MOBILESTORE_DOMAINNAME0']=de
518
        de = get_code_word("MOBILESTORE_URL1")
519
        kw['MOBILESTORE_URL1']=de
520
        de = get_code_word("MOBILESTORE_URL2")
521
        kw['MOBILESTORE_URL2']=de
522
        return dict(modelname='mobilestore_form',
523
        value=kw)
524
 
525
    @expose('wiki20.templates.input_form')
526
    def save_mobilestore(self, **kw):
527
        """Create a mobilestore object and save it to the database."""
528
        set_code_word("MOBILESTORE_DOMAINNAME",kw['MOBILESTORE_DOMAINNAME'],"")
529
        set_code_word("MOBILESTORE_DOMAINNAME1",kw['MOBILESTORE_DOMAINNAME1'],"")  
530
        set_code_word("MOBILESTORE_URL",kw['MOBILESTORE_URL'],"")
531
        set_code_word("MOBILESTORE_HOMEPAGE",kw['MOBILESTORE_HOMEPAGE'],"")
532
        set_code_word("MOBILESTORE_REFERER",kw['MOBILESTORE_REFERER'],"")
533
        set_code_word("MOBILESTORE_VATPLUSTAX",kw['MOBILESTORE_VATPLUSTAX'],"")
534
        set_code_word("MOBILESTORE_REMOVELIST",kw['MOBILESTORE_REMOVELIST'],"")
535
        set_code_word("MOBILESTORE_CHKLIST1",kw['MOBILESTORE_CHKLIST1'],"")
536
        set_code_word("MOBILESTORE_XPATH1",kw['MOBILESTORE_XPATH1'],"")
537
        set_code_word("MOBILESTORE_XPATH2",kw['MOBILESTORE_XPATH2'],"")
538
        set_code_word("MOBILESTORE_XPATH3",kw['MOBILESTORE_XPATH3'],"")
539
        set_code_word("MOBILESTORE_XPATH4",kw['MOBILESTORE_XPATH4'],"")
540
        set_code_word("MOBILESTORE_XPATH5",kw['MOBILESTORE_XPATH5'],"")
541
        set_code_word("MOBILESTORE_XPATH6",kw['MOBILESTORE_XPATH6'],"")
542
        set_code_word("MOBILESTORE_XPATH7",kw['MOBILESTORE_XPATH7'],"")
543
        set_code_word("MOBILESTORE_XPATH8",kw['MOBILESTORE_XPATH8'],"")
544
        set_code_word("MOBILESTORE_DOMAINNAME0",kw['MOBILESTORE_DOMAINNAME0'],"")
545
        set_code_word("MOBILESTORE_URL1",kw['MOBILESTORE_URL1'],"")
546
        set_code_word("MOBILESTORE_URL2",kw['MOBILESTORE_URL2'],"")
547
        flash("Data successfully saved.")
548
        redirect("form_mobilestore")
549
 
550
    @expose('wiki20.templates.input_form')
551
    def form_naaptol(self, **kw):
552
    #"""Show form to add data record for naaptol."""
553
        initialize_table()
554
        create_naaptol_form = NaaptolForm("create_naaptol_form",action='save_naaptol')
555
        tmpl_context.form = create_naaptol_form
556
        de = get_code_word("NAAPTOL_DOMAINNAME")
557
        kw['NAAPTOL_DOMAINNAME']=de
558
        de = get_code_word("NAAPTOL_DOMAINNAME1")
559
        kw['NAAPTOL_DOMAINNAME1']=de
560
        de = get_code_word("NAAPTOL_DOMAINNAME2")
561
        kw['NAAPTOL_DOMAINNAME2']=de
562
        de = get_code_word("NAAPTOL_URL")
563
        kw['NAAPTOL_URL']=de
564
        de = get_code_word("NAAPTOL_HOMEPAGE")
565
        kw['NAAPTOL_HOMEPAGE']=de
566
        de = get_code_word("NAAPTOL_REFERER")
567
        kw['NAAPTOL_REFERER']=de
568
        de = get_code_word("NAAPTOL_CHKLIST1")
569
        kw['NAAPTOL_CHKLIST1']=de
570
        de = get_code_word("NAAPTOL_CHKLIST2")
571
        kw['NAAPTOL_CHKLIST2']=de
572
        de = get_code_word("NAAPTOL_PART")
573
        kw['NAAPTOL_PART']=de
574
        de = get_code_word("NAAPTOL_XPATH1")
575
        kw['NAAPTOL_XPATH1']=de
576
        de = get_code_word("NAAPTOL_XPATH2")
577
        kw['NAAPTOL_XPATH2']=de
578
        de = get_code_word("NAAPTOL_XPATH3")
579
        kw['NAAPTOL_XPATH3']=de
580
        de = get_code_word("NAAPTOL_XPATH4")
581
        kw['NAAPTOL_XPATH4']=de
582
        de = get_code_word("NAAPTOL_XPATH5")
583
        kw['NAAPTOL_XPATH5']=de
584
        de = get_code_word("NAAPTOL_XPATH6")
585
        kw['NAAPTOL_XPATH6']=de
586
        de = get_code_word("NAAPTOL_XPATH7")
587
        kw['NAAPTOL_XPATH7']=de
588
        de = get_code_word("NAAPTOL_XPATH8")
589
        kw['NAAPTOL_XPATH8']=de
590
        de = get_code_word("NAAPTOL_XPATH9")
591
        kw['NAAPTOL_XPATH9']=de
592
        de = get_code_word("NAAPTOL_XPATH10")
593
        kw['NAAPTOL_XPATH10']=de
594
        de = get_code_word("NAAPTOL_REMOVELIST")
595
        kw['NAAPTOL_REMOVELIST']=de
596
        return dict(modelname='naaptol_form',
597
        value=kw)
598
 
599
    @expose('wiki20.templates.input_form')
600
    def save_naaptol(self, **kw):
601
        """Create a naaptol object and save it to the database."""
602
        set_code_word("NAAPTOL_DOMAINNAME",kw['NAAPTOL_DOMAINNAME'],"")  
603
        set_code_word("NAAPTOL_URL",kw['NAAPTOL_URL'],"")
604
        set_code_word("NAAPTOL_HOMEPAGE",kw['NAAPTOL_HOMEPAGE'],"")
605
        set_code_word("NAAPTOL_REFERER",kw['NAAPTOL_REFERER'],"")
606
        set_code_word("NAAPTOL_CHKLIST1",kw['NAAPTOL_CHKLIST1'],"")
607
        set_code_word("NAAPTOL_CHKLIST2",kw['NAAPTOL_CHKLIST2'],"")
608
        set_code_word("NAAPTOL_XPATH1",kw['NAAPTOL_XPATH1'],"")
609
        set_code_word("NAAPTOL_XPATH2",kw['NAAPTOL_XPATH2'],"")
610
        set_code_word("NAAPTOL_XPATH3",kw['NAAPTOL_XPATH3'],"")
611
        set_code_word("NAAPTOL_XPATH4",kw['NAAPTOL_XPATH4'],"")
612
        set_code_word("NAAPTOL_XPATH5",kw['NAAPTOL_XPATH5'],"")
613
        set_code_word("NAAPTOL_XPATH6",kw['NAAPTOL_XPATH6'],"")
614
        set_code_word("NAAPTOL_XPATH7",kw['NAAPTOL_XPATH7'],"")
615
        set_code_word("NAAPTOL_XPATH8",kw['NAAPTOL_XPATH8'],"")
616
        set_code_word("NAAPTOL_XPATH9",kw['NAAPTOL_XPATH9'],"")
617
        set_code_word("NAAPTOL_XPATH10",kw['NAAPTOL_XPATH10'],"")
618
        set_code_word("NAAPTOL_REMOVELIST",kw['NAAPTOL_REMOVELIST'],"")
619
        set_code_word("NAAPTOL_DOMAINNAME1",kw['NAAPTOL_DOMAINNAME1'],"")
620
        set_code_word("NAAPTOL_DOMAINNAME2",kw['NAAPTOL_DOMAINNAME2'],"")
621
        set_code_word("NAAPTOL_PART",kw['NAAPTOL_PART'],"")
622
        flash("Data successfully saved.")
623
        redirect("form_naaptol")
624
 
625
 
626
    @expose('wiki20.templates.input_form')
627
    def form_babuchak(self, **kw):
628
    #"""Show form to add data record for babuchak."""
629
        initialize_table()
630
        create_babuchak_form = BabuchakForm("create_babuchak_form",action='save_babuchak')
631
        tmpl_context.form = create_babuchak_form
632
        de = get_code_word("BABUCHAK_DOMAINNAME")
633
        kw['BABUCHAK_DOMAINNAME']=de
634
        de = get_code_word("BABUCHAK_DOMAINNAME1")
635
        kw['BABUCHAK_DOMAINNAME1']=de
636
        de = get_code_word("BABUCHAK_DOMAINNAME2")
637
        kw['BABUCHAK_DOMAINNAME2']=de
638
        de = get_code_word("BABUCHAK_URL")
639
        kw['BABUCHAK_URL']=de
640
        de = get_code_word("BABUCHAK_URL1")
641
        kw['BABUCHAK_URL1']=de
642
        de = get_code_word("BABUCHAK_VAR1")
643
        kw['BABUCHAK_VAR1']=de
644
        de = get_code_word("BABUCHAK_URL2")
645
        kw['BABUCHAK_URL2']=de
646
        de = get_code_word("BABUCHAK_HOMEPAGE")
647
        kw['BABUCHAK_HOMEPAGE']=de
648
        de = get_code_word("BABUCHAK_REFERER")
649
        kw['BABUCHAK_REFERER']=de
650
        de = get_code_word("BABUCHAK_XPATH1")
651
        kw['BABUCHAK_XPATH1']=de
652
        de = get_code_word("BABUCHAK_XPATH2")
653
        kw['BABUCHAK_XPATH2']=de
654
        de = get_code_word("BABUCHAK_XPATH3")
655
        kw['BABUCHAK_XPATH3']=de
656
        de = get_code_word("BABUCHAK_XPATH4")
657
        kw['BABUCHAK_XPATH4']=de
658
        de = get_code_word("BABUCHAK_XPATH5")
659
        kw['BABUCHAK_XPATH5']=de
660
        de = get_code_word("BABUCHAK_XPATH6")
661
        kw['BABUCHAK_XPATH6']=de
662
        de = get_code_word("BABUCHAK_XPATH7")
663
        kw['BABUCHAK_XPATH7']=de
664
        de = get_code_word("BABUCHAK_REMOVELIST")
665
        kw['BABUCHAK_REMOVELIST']=de
666
        return dict(modelname='babuchak_form',
667
        value=kw)
668
 
669
    @expose('wiki20.templates.input_form')
670
    def save_babuchak(self, **kw):
671
        """Create a babuchak object and save it to the database."""
672
        set_code_word("BABUCHAK_DOMAINNAME",kw['BABUCHAK_DOMAINNAME'],"")  
673
        set_code_word("BABUCHAK_URL",kw['BABUCHAK_URL'],"")
674
        set_code_word("BABUCHAK_URL1",kw['BABUCHAK_URL1'],"")
675
        set_code_word("BABUCHAK_VAR1",kw['BABUCHAK_VAR1'],"")
676
        set_code_word("BABUCHAK_URL2",kw['BABUCHAK_URL2'],"")
677
        set_code_word("BABUCHAK_HOMEPAGE",kw['BABUCHAK_HOMEPAGE'],"")
678
        set_code_word("BABUCHAK_REFERER",kw['BABUCHAK_REFERER'],"")
679
        set_code_word("BABUCHAK_XPATH1",kw['BABUCHAK_XPATH1'],"")
680
        set_code_word("BABUCHAK_XPATH2",kw['BABUCHAK_XPATH2'],"")
681
        set_code_word("BABUCHAK_XPATH3",kw['BABUCHAK_XPATH3'],"")
682
        set_code_word("BABUCHAK_XPATH4",kw['BABUCHAK_XPATH4'],"")
683
        set_code_word("BABUCHAK_XPATH5",kw['BABUCHAK_XPATH5'],"")
684
        set_code_word("BABUCHAK_XPATH6",kw['BABUCHAK_XPATH6'],"")
685
        set_code_word("BABUCHAK_XPATH7",kw['BABUCHAK_XPATH7'],"")
686
        set_code_word("BABUCHAK_REMOVELIST",kw['BABUCHAK_REMOVELIST'],"")
687
        set_code_word("BABUCHAK_DOMAINNAME1",kw['BABUCHAK_DOMAINNAME1'],"")
688
        set_code_word("BABUCHAK_DOMAINNAME2",kw['BABUCHAK_DOMAINNAME2'],"")
689
        flash("Data successfully saved.")
690
        redirect("form_babuchak")    
691
 
692
    @expose('wiki20.templates.codedata_forms')
693
    def form_codedata(self):
694
        """Handle the front-page."""
695
        return dict(page='codedata_forms')
696