def send_email(self, ids, context={}):
     uid = access.get_active_user()
     try:
         access.set_active_user(1)
         obj = self.browse(ids[0])
         # XXX "=" should be changed to "=ilike" later
         res = get_model("base.user").search((["email", "=ilike", obj.email.strip()]))
         if not res:
             raise Exception("User with given email doesn't exist in database")
         request = context["request"]
         msg = "Somebody requested change of your Netforce password.\n\n"
         msg += "If you didn't do it, please ignore this message.\n\n"
         msg += "Otherwise if you want to reset your password click on the link below:\n\n"
         msg += "http://%s/ui#name=change_passwd&key=%s\n\n\n" % (request.host, obj.key)
         msg += "Regards,\n"
         msg += "Netforce Team"
         vals = {
             "type": "out",
             "from_addr": "[email protected]",
             "to_addrs": obj.email,
             "subject": "Netforce reset password request",
             "body": msg,
             "state": "to_send",
         }
         get_model("email.message").create(vals)
         return {
             "next": {
                 "name": "forgot_passwd_done"
             }
         }
     finally:
         access.set_active_user(uid)

 def approve(self, ids, context={}):
     if not check_permission_other("production_safe_in"):
         raise Exception("Permission denied")
     obj = self.browse(ids)[0]
     user_id = get_active_user()
     obj.write({"approved_by_id": user_id})
     return {"next": {"name": "barcode_safe_in", "active_id": obj.id}, "flash": "DC to safe approved successfully"}

 def create(self, vals, **kw):
     uid = access.get_active_user()
     try:
         access.set_active_user(1)
         return super().create(vals, **kw)
     finally:
         access.set_active_user(uid)

 def default_get(self, field_names=None, context=None, **kw):
     user_id = get_active_user()
     set_active_user(1)
     user = get_model("base.user").browse(user_id)
     vals = {"name": user.name, "password": user.password, "email": user.email, "mobile": user.mobile}
     set_active_user(user_id)
     return vals

 def create(self,vals,*args,**kw):
     new_id=super().create(vals,*args,**kw)
     obj=self.browse(new_id)
     user_id=access.get_active_user()
     user=get_model("base.user").browse(user_id)
     if obj.related_id._model=="issue":
         issue=obj.related_id
         project=issue.project_id
         contact=issue.contact_id
         emails=issue.get_email_addresses()
         subject="New message by %s for issue %s"%(user.name,issue.number)
         if obj.subject:
             subject+=": %s"%obj.subject
         if emails:
             vals={
                 "from_addr": "[email protected]", # XXX
                 "to_addrs": ",".join(emails),
                 "subject": subject,
                 "body": obj.body,
                 "state": "to_send",
                 "name_id": "contact,%s"%contact.id,
                 "related_id": "issue,%s"%issue.id,
             }
             get_model("email.message").create(vals)
     return new_id

 def _get_number(self, context={}):
     user_id = get_active_user()
     set_active_user(1)
     seq_id = get_model("sequence").find_sequence(type="leave_request")
     if not seq_id:
         return None
     while 1:
         num = get_model("sequence").get_next_number(seq_id)
         user_id = get_active_user()
         set_active_user(1)
         res = self.search([["number", "=", num]])
         set_active_user(user_id)
         if not res:
             return num
         get_model("sequence").increment_number(seq_id)
     set_active_user(user_id)

 def get(self):
     db = get_connection()
     try:
         cart_id = int(self.get_argument("cart_id"))
         print("cart_id", cart_id)
         cart = get_model("ecom.cart").browse(cart_id)
         set_active_company(1)
         user_id = get_active_user()
         website = self.context["website"]
         ctx = self.context
         ctx["cart"] = cart
         if not cart.is_paid and website.payment_slip_template_id and (cart.pay_method_id.id == website.bank_method_id.id):
             tmpl_name = website.payment_slip_template_id.name
             url = "/report?type=report_jasper&model=ecom.cart&convert=pdf&ids=[%d]&template=%s" % (
                 cart.id, tmpl_name)
             ctx["payment_slip_report_url"] = url
         content = render("ecom_order_confirmed", ctx)
         ctx["content"] = content
         html = render("cms_layout", ctx)
         self.write(html)
         db.commit()
     except:
         import traceback
         traceback.print_exc()
         db.rollback()

 def get_open_dummy(self, ids, context={}):
     vals = {}
     user_id = get_active_user()
     for obj in self.browse(ids):
         if user_id == obj.to_id.id:
             obj.write({"state": "opened"})
         vals[obj.id] = True
     return vals

 def get_default(self, model, field, context={}):
     user_id = get_active_user()
     res = self.search([["user_id", "=", user_id], ["model", "=", model], ["field", "=", field]])
     if not res:
         return None
     obj_id = res[0]
     obj = self.browse(obj_id)
     return obj.value

 def pending(self, ids, context={}):
     user_id = get_active_user()
     for obj in self.browse(ids):
         for move in obj.lines:
             move.write({"state": "pending", "date": obj.date})
             if obj.related_id and not move.related_id:
                 move.write({"related_id":"%s,%d"%(obj.related_id._model,obj.related_id.id)})
         obj.write({"state": "pending", "pending_by_id": user_id})

 def delete(self, ids, **kw):
     prod_ids = []
     for obj in self.browse(ids):
         prod_ids.append(obj.product_id.id)
     super().delete(ids, **kw)
     user_id = get_active_user()
     set_active_user(1)
     get_model("product").write(prod_ids, {"update_balance": True})
     set_active_user(user_id)

 def save_changes(self, ids, context={}):
     obj = self.browse(ids)[0]
     check_password(obj.password)
     vals = {"name": obj.name, "password": obj.password, "email": obj.email, "mobile": obj.mobile}
     user_id = get_active_user()
     set_active_user(1)
     get_model("base.user").write([user_id], vals)
     obj.write({"password": ""})
     set_active_user(user_id)
     return {"next": "_close"}

 def approve(self, ids, context={}):
     if not check_permission_other("sale_approve_done"):
         raise Exception("Permission denied")
     obj = self.browse(ids)[0]
     user_id = get_active_user()
     obj.write({"approved_by_id": user_id})
     return {
         "next": {"name": "sale", "mode": "form", "active_id": obj.id},
         "flash": "Sales order approved successfully",
     }

 def reject(self, ids, context={}):
     user_id = get_active_user()
     user = get_model("base.user").browse(user_id)
     obj = self.browse(ids)[0]
     obj.write({"state": "canceled"})
     vals = {
         "related_id": "room.reserve,%s" % obj.id,
         "body": "Rejected by %s" % user.name,
     }
     get_model("message").create(vals)

 def migrate(self):
     user_id=get_active_user()
     set_active_user(1)
     for leave in get_model("hr.leave").search_browse([]):
         if leave.time_from and leave.time_to:
             leave.write({
                 'start_date': '%s %s:00'%(leave.start_date[0:10],leave.time_from.replace(".",":")),
                 'end_date': '%s %s:00'%(leave.end_date[0:10],leave.time_to.replace(".",":")),
             })
     set_active_user(user_id)

 def migrate(self):
     user_id = get_active_user()
     set_active_user(1)
     for payslip in get_model("hr.payslip").search_browse([]):
         if not payslip.state:
             payslip.write({"state": "draft"})
     for payrun in get_model("hr.payrun").search_browse([]):
         if not payrun.state:
             payrun.write({"state": "draft"})
     set_active_user(user_id)

 def set_default(self, model, field, value, context={}):
     self.clear_default(model, field)
     user_id = get_active_user()
     vals = {
         "user_id": user_id,
         "model": model,
         "field": field,
         "value": value,
     }
     self.create(vals)

 def _get_number(self, context={}):
     while 1:
         num = get_model("sequence").get_number(type="job")
         if not num:
             return None
         user_id = get_active_user()
         set_active_user(1)
         res = self.search([["number", "=", num]])
         set_active_user(user_id)
         if not res:
             return num
         get_model("sequence").increment(type="job")

 def allow_record(self, context={}):
     user_id=get_active_user()
     user=get_model("base.user").browse(user_id)
     limit=user.limit_inspect or 0
     res=self.search_browse([['user_id','=',user_id]])
     if res:
         obj=res[0]
         count=obj.record_count+1
         if count > limit:
             return False, limit, count
     count=self.increase()
     return True, limit, count

 def approve(self, ids, context={}):
     if not check_permission_other("stock_transfer"):
         raise Exception("Permission denied")
     obj = self.browse(ids)[0]
     user_id = get_active_user()
     obj.write({"approved_by_id": user_id})
     return {
         "next": {
             "name": "barcode_transfer",
             "active_id": obj.id,
         },
         "flash": "Stock transfer approved successfully",
     }