zhuangxujie
01bc837fd4
Some checks failed
Server (Postgres) / Build & reinstall (setup) (push) Has been cancelled
Server (Postgres) / Python Unit Tests (1) (push) Has been cancelled
Server (Postgres) / Python Unit Tests (2) (push) Has been cancelled
Server (Postgres) / Python Unit Tests (3) (push) Has been cancelled
Server (Postgres) / Python Unit Tests (4) (push) Has been cancelled
Server (Mariadb) / Build & reinstall (setup) (push) Has been cancelled
Server (Mariadb) / Python Unit Tests (1) (push) Has been cancelled
Server (Mariadb) / Python Unit Tests (2) (push) Has been cancelled
Server (Mariadb) / Python Unit Tests (3) (push) Has been cancelled
Server (Mariadb) / Python Unit Tests (4) (push) Has been cancelled
Server (Mariadb) / Coverage Wrap Up (push) Has been cancelled
Lock threads / lock (push) Has been cancelled
Regenerate POT file (translatable strings) / Regenerate POT file (develop) (push) Has been cancelled
Regenerate POT file (translatable strings) / Regenerate POT file (version-16-hotfix) (push) Has been cancelled
Sync translations to hotfix branches / Trigger sync → version-16-hotfix (push) Has been cancelled
Create weekly release pull requests / Release (15) (push) Has been cancelled
Create weekly release pull requests / Release (16) (push) Has been cancelled
30 lines
877 B
Python
30 lines
877 B
Python
import frappe
|
|
from frappe.model.utils.rename_field import rename_field
|
|
|
|
|
|
def execute():
|
|
frappe.reload_doc("projects", "doctype", "timesheet")
|
|
frappe.reload_doc("projects", "doctype", "timesheet_detail")
|
|
|
|
if frappe.db.has_column("Timesheet Detail", "billable"):
|
|
rename_field("Timesheet Detail", "billable", "is_billable")
|
|
|
|
base_currency = frappe.defaults.get_global_default("currency")
|
|
|
|
frappe.db.sql(
|
|
"""UPDATE `tabTimesheet Detail`
|
|
SET base_billing_rate = billing_rate,
|
|
base_billing_amount = billing_amount,
|
|
base_costing_rate = costing_rate,
|
|
base_costing_amount = costing_amount"""
|
|
)
|
|
|
|
frappe.db.sql(
|
|
f"""UPDATE `tabTimesheet`
|
|
SET currency = '{base_currency}',
|
|
exchange_rate = 1.0,
|
|
base_total_billable_amount = total_billable_amount,
|
|
base_total_billed_amount = total_billed_amount,
|
|
base_total_costing_amount = total_costing_amount"""
|
|
)
|