ofelix03

@api.model
def create(self, vals):
  if not self.check_access_rights('create', raise_exception=False):
    raise ValidationError(_("Sorry! you don't have the right permission to create this record"))
  # user has right permission, continue with operation
  return super(Customer, self).create(vals)
    

ofelix03

base_url = self.get_base_url()

ofelix03

self.env['ir.config_parameter'].get_param('web.base_url')

ofelix03

def action_add_bank(self):
  action = self.get_formview_action()
  action['target'] = 'new'
  action['default_bank_reference': self.bank_reference
  
  return action

ofelix03

def action_add_bank(self):
  return {
      'name': 'Add New Bank',
      'type': 'ir.actions.act_window',
      'res_model': 'kyc.customer.bank',
      'view_type': 'form',
      'view_mode': 'form',
      'view_id': form_view.id,
      'res_id': self.id,
      'target': 'new',

ofelix03

def action_add_bank(self):
  action = self.env.ref("kyc.add_bank_action").read()[0]
  action['target'] = 'new'
  action['context'] = {
    'default_bank_reference': self.bank_reference
  }
  
  return action

ofelix03

select u.*, last_visited 
from users u,
lateral(
 select concat(date, ' ', time) "last_visited" from site_visits 
 where user_id = u.id
 order by id desc 
 limit 1
) last_visited
where u.email = '[email protected]'

ofelix03

select *, (
 select concat(date, ' ', time) "last_visited" from site_visits 
 where user_id = u.id
 order by id desc 
 limit 1
) "last_visited"
from users u

ofelix03

ofelix03

SELECT name, email, s.ip_addresses
FROM users u
LEFT JOIN LATERAL (
 SELECT user_id, string_agg(ip_address, ',') "ip_addresses"
 FROM site_visits
 WHERE country in ('China')
 and user_id = u.id
 GROUP BY user_id
) s
ON u.id = s.user_id