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

ofelix03

SELECT name, email, s.ip_addresses
FROM users u
LEFT JOIN (
 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

ofelix03

def pay_bill(bill_type, meter_number, amount):
  # we'll put the logic for how to process bill payment 
  # this could include validation rules, and service calls to complete pyment
  pass

ofelix03

# 1st call
median1 = find_median([40, 57, 12])
print(f"median1 = {median1}")

# 2nd call
median2 = find_median([3, 13, 7, 5, 21, 23, 39, 23, 40, 23, 14, 12, 56, 23, 29])
print(f"median1 = {median2}")

# 3rd call
median3 = find_median([3, 13, 7, 5, 21, 23, 23, 40, 23, 14, 12, 56, 23, 29])

ofelix03

import math

def find_median(numbers=[]):
    """
      Implementation details

      Algorithm:
      1. Reorder numbers in ascending order
      2. Determine if the count of the numbers is even or odd
      3. If odd, divide by 2 and round up the result. Look up the median using your result as the lookup index. Skip step 4