def prepare(self): print(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>") print("prepare") super(BaseController, self).prepare() website_id = self.request.headers.get("X-Website-ID") if website_id: website_id = int(website_id) else: res = get_model("website").search([["state", "=", "active"]]) if not res: raise Exception("No website found") website_id = res[0] self.website_id = website_id website = get_model("website").browse(website_id) template.set_active_theme(website.theme_id.id) browse_ctx = { "website_id": website.id, "theme_id": website.theme_id.id, "sale_channel_id": website.sale_channel_id.id, "pricelist_id": website.sale_channel_id.pricelist_id.id if website.sale_channel_id else None, } lang = self.get_argument("set_lang", None) if lang: set_active_locale(lang) self.set_cookie("locale", lang) ctx = {} ctx["website"] = website ctx["database"] = get_active_db() ctx["locale"] = get_active_locale() ctx["ga_script"] = website.ga_script ctx["linklists"] = get_model("cms.linklist").search_browse([]) ctx["product_groups"] = get_model("product.group").search_browse( [], context=browse_ctx) ctx["countries"] = get_model("country").search_browse([]) # XXX cart_id = self.get_cookie("cart_id", None) if cart_id: cart_id = int(cart_id) res = get_model("ecom.cart").search([["id", "=", cart_id]]) if res: ctx["cart"] = get_model("ecom.cart").browse(cart_id) else: # handle invalid cart_id cookie self.clear_cookie("cart_id") user_id = self.get_cookie("user_id", None) if user_id: user_id = int(user_id) user = get_model("base.user").browse(user_id) ctx["customer"] = user.contact_id offset = self.get_argument("offset", None) if offset: ctx["offset"] = int(offset) ctx["url"] = self.request.uri self.context = ctx
def prepare(self): print(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>") print("prepare") super(BaseController,self).prepare() website_id=self.request.headers.get("X-Website-ID") if website_id: website_id=int(website_id) else: res=get_model("website").search([["state","=","active"]]) if not res: raise Exception("No website found") website_id=res[0] self.website_id=website_id website=get_model("website").browse(website_id) template.set_active_theme(website.theme_id.id) browse_ctx={ "website_id": website.id, "theme_id": website.theme_id.id, "sale_channel_id": website.sale_channel_id.id, "pricelist_id": website.sale_channel_id.pricelist_id.id if website.sale_channel_id else None, } lang=self.get_argument("set_lang",None) if lang: set_active_locale(lang) self.set_cookie("locale",lang) ctx={} ctx["website"]=website ctx["database"]=get_active_db() ctx["locale"]=get_active_locale() ctx["ga_script"]=website.ga_script ctx["linklists"]=get_model("cms.linklist").search_browse([]) ctx["product_groups"]=get_model("product.group").search_browse([],context=browse_ctx) ctx["countries"]=get_model("country").search_browse([]) # XXX cart_id=self.get_cookie("cart_id",None) if cart_id: cart_id=int(cart_id) res=get_model("ecom.cart").search([["id","=",cart_id]]) if res: ctx["cart"]=get_model("ecom.cart").browse(cart_id) else: # handle invalid cart_id cookie self.clear_cookie("cart_id") user_id=self.get_cookie("user_id",None) if user_id: user_id=int(user_id) user=get_model("base.user").browse(user_id) ctx["customer"]=user.contact_id offset=self.get_argument("offset",None) if offset: ctx["offset"]=int(offset) ctx["url"]=self.request.uri self.context=ctx
def get(self): #url="https://v5.inspection.in.th/inspectionreport/checkqr?id=1541844&password=f45681f1" current_local=get_active_locale() set_active_user(1) #admin set_active_locale('th_TH') db=get_connection() # prevent to error get transaction try: db.begin() id=self.get_argument("id") if not id: self.write("Missing ID") return password=self.get_argument("password") if not password: self.write("Missing Password") return ctx={ 'obj': None, } #res=db.query("select * from inspection where number=%s and password=%s",id,password) dom=[ ['number','=', id], ['password','=', password] ] res=get_model("inspection").search_read(dom) if res: #t0=res[-1]['date'] #t1=t0.split(" ") #res[-1]['date']='%s %s'%(sale_utils.date2thai(t1[0], format='%(d)s %(Tm)s %(BY)s'), t1[1]) #res[-1]['date_register']=sale_utils.date2thai(res[-1]['date_register'], format='%(d)s %(Tm)s %(BY)s') ctx['obj']=res[-1] else: ctx['nothing']=True data=ctx['obj'] html=render("checkqr",context=ctx, data=data) self.write(html) except Exception as e: self.write("ERROR : %s"%str(e)) finally: if db: db.commit() set_active_locale(current_local)
def get_block(self, name, page_id=None, post_id=None, context={}): # print("get_block",name,page_id,post_id) dbname = get_active_db() lang = get_active_locale() key = (dbname, name, page_id, post_id, lang) if key in _block_cache: #print("...cache hit") return _block_cache[key] #print("...cache miss") cond = [["name", "=", name]] if page_id: cond.append(["related_id", "=", "cms.page,%d" % page_id]) if post_id: cond.append(["related_id", "=", "cms.blog.post,%d" % post_id]) res = self.search(cond) if res: block = self.read(res, ["html"])[0] else: block = None _block_cache[key] = block return block
def translate(self, original): lang = get_active_locale() cache = self._get_cache() return cache.get((original, lang))