43 lines
1.3 KiB
Python
Executable File
43 lines
1.3 KiB
Python
Executable File
from odoo.tools.sql import column_exists
|
|
|
|
|
|
def _pre_init_global_discount_fields(env):
|
|
if not column_exists(env.cr, "sale_order", "amount_global_discount"):
|
|
env.cr.execute(
|
|
"""
|
|
ALTER TABLE "sale_order"
|
|
ADD COLUMN "amount_global_discount" double precision DEFAULT 0
|
|
"""
|
|
)
|
|
env.cr.execute(
|
|
"""
|
|
ALTER TABLE "sale_order" ALTER COLUMN "amount_global_discount" DROP DEFAULT
|
|
"""
|
|
)
|
|
if not column_exists(
|
|
env.cr, "sale_order", "amount_untaxed_before_global_discounts"
|
|
):
|
|
env.cr.execute(
|
|
"""
|
|
ALTER TABLE "sale_order"
|
|
ADD COLUMN "amount_untaxed_before_global_discounts" double precision
|
|
"""
|
|
)
|
|
env.cr.execute(
|
|
"""
|
|
update sale_order set amount_untaxed_before_global_discounts = amount_untaxed
|
|
"""
|
|
)
|
|
if not column_exists(env.cr, "sale_order", "amount_total_before_global_discounts"):
|
|
env.cr.execute(
|
|
"""
|
|
ALTER TABLE "sale_order"
|
|
ADD COLUMN "amount_total_before_global_discounts" double precision
|
|
"""
|
|
)
|
|
env.cr.execute(
|
|
"""
|
|
update sale_order set amount_total_before_global_discounts = amount_total
|
|
"""
|
|
)
|