问从odoo 7.0迁移到odoo 13.0

EN

def x_fnction(self, cr, uid, data, context=None):

    id = data.get('id', False)
    if data:
        charges = []
        in_charge = data['start_date']
        end_date = data['end_date']
        bs_query = """SELECT "End_Date","idcust","ekic","price","Start_Date",id FROM status WHERE ((("End_Date" >= '%s')  OR  "End_Date" IS NULL )  AND  ("Start_Date" <= '%s')  AND  ("id_EK_Customer" = %s)  AND  ("Is_Active" in ('Y','N'))) ORDER BY "Start_Date" """ % (
        start_date, end_date, id)
        cr.execute(bs_query)
        records = cr.dictfetchall()
        if not billing_status_records:
            return []
        total_variable_charges_incl_gst = 0
        for billing_status_record in billing_status_records:
            icp_id = billing_status_record['id_EK_ICP']
            billing_variable_charge = 0
            dbc_query = """SELECT "flow" FROM charges WHERE (("id_bill" = %s)  AND  ("status" = 'B')) ORDER BY "date" desc limit 1""" % (
                billing_status_record['id'])
            cr.execute(dbc_query)
            max_billed_date = cr.fetchone()
            if max_billed_date:
                min_unbilled_charge_read_date = datetime.strptime(max_billed_date[0],
                                                                  '%Y-%m-%d').date() + timedelta(days=1)
            else:
                min_unbilled_charge_read_date = billing_status_record['Start_Date']
            start_date = max(start_date, str(min_unbilled_charge_read_date))


            dbc_query = """select * from some_table
            WHERE ((ec."ekp" = %s)  AND  (ec."date" >= '%s')  AND  (ec."flow" <= '%s')  AND  (ec."enerf" != 'I'))""" % (
            icp_id, start_date, end_date)

            cr.execute(dbc_query)
            daily_billing_charges_data = cr.dictfetchall()


    return data