def create_account_doctype():
# update accounts
import webnotes.db
webnotes.conn = webnotes.db.Database(use_default = 1)
webnotes.session = {'user':'******'}
from webnotes.model.doc import Document
import webnotes.model.db_schema
# create tabAccount
ac = Document('DocType')
ac.name = 'Account'
ac.autoname = 'AC.#####'
ac.save(1)
f = ac.addchild('fields', 'DocField')
f.label = 'Account Name'
f.fieldname = 'ac_name'
f.fieldtype = 'Data'
f.save()
f = ac.addchild('fields', 'DocField')
f.label = 'Database Name'
f.fieldname = 'db_name'
f.fieldtype = 'Data'
f.save()
f = ac.addchild('fields', 'DocField')
f.label = 'Database Login'
f.fieldname = 'db_login'
f.fieldtype = 'Data'
f.save()
f = ac.addchild('fields', 'DocField')
f.label = 'App Login'
f.fieldname = 'app_login'
f.fieldtype = 'Data'
f.save()
f = ac.addchild('permissions', 'DocPerm')
f.role = 'Administrator'
f.read = 1
f.write = 1
f.create = 1
f.save()
# udpate schema
webnotes.model.db_schema.updatedb('Account')
def load_data():
test_purchase_receipt.load_data()
webnotes.insert({"doctype": "Account", "account_name": "Cost for Goods Sold",
"parent_account": "Expenses - %s" % abbr, "company": company,
"group_or_ledger": "Ledger"})
webnotes.insert({"doctype": "Account", "account_name": "Excise Duty",
"parent_account": "_Test Tax Assets - %s" % abbr, "company": company,
"group_or_ledger": "Ledger"})
webnotes.insert({"doctype": "Account", "account_name": "Education Cess",
"parent_account": "_Test Tax Assets - %s" % abbr, "company": company,
"group_or_ledger": "Ledger"})
webnotes.insert({"doctype": "Account", "account_name": "S&H Education Cess",
"parent_account": "_Test Tax Assets - %s" % abbr, "company": company,
"group_or_ledger": "Ledger"})
webnotes.insert({"doctype": "Account", "account_name": "CST",
"parent_account": "Direct Expenses - %s" % abbr, "company": company,
"group_or_ledger": "Ledger"})
webnotes.insert({"doctype": "Account", "account_name": "Discount",
"parent_account": "Direct Expenses - %s" % abbr, "company": company,
"group_or_ledger": "Ledger"})
from webnotes.model.doc import Document
item = Document("Item", "Home Desktop 100")
# excise duty
item_tax = item.addchild("item_tax", "Item Tax")
item_tax.tax_type = "Excise Duty - %s" % abbr
item_tax.tax_rate = 10
item_tax.save()
def create_account_record(ac_name, newdb, domain=''):
# update accounts
import webnotes.db
webnotes.conn = webnotes.db.Database(use_default = 1)
if not webnotes.conn.in_transaction:
webnotes.conn.sql("start transaction")
if not webnotes.session:
webnotes.session = {'user':'******'}
from webnotes.model.doc import Document
ac = Document('Account')
ac.ac_name = ac_name
ac.db_name = newdb
ac.name = newdb
ac.save(1)
# add domain
if domain:
acd = ac.addchild('account_domains','Account Domain',1)
acd.domain = ac_name + '.' + domain
acd.save(1)
webnotes.conn.sql("commit")
def load_data():
test_purchase_receipt.load_data()
webnotes.insert({
"doctype": "Account",
"account_name": "Excise Duty",
"parent_account": "Tax Assets - %s" % abbr,
"company": company,
"group_or_ledger": "Ledger"
})
webnotes.insert({
"doctype": "Account",
"account_name": "Education Cess",
"parent_account": "Tax Assets - %s" % abbr,
"company": company,
"group_or_ledger": "Ledger"
})
webnotes.insert({
"doctype": "Account",
"account_name": "S&H Education Cess",
"parent_account": "Tax Assets - %s" % abbr,
"company": company,
"group_or_ledger": "Ledger"
})
webnotes.insert({
"doctype": "Account",
"account_name": "CST",
"parent_account": "Direct Expenses - %s" % abbr,
"company": company,
"group_or_ledger": "Ledger"
})
webnotes.insert({
"doctype": "Account",
"account_name": "Discount",
"parent_account": "Direct Expenses - %s" % abbr,
"company": company,
"group_or_ledger": "Ledger"
})
from webnotes.model.doc import Document
item = Document("Item", "Home Desktop 100")
# excise duty
item_tax = item.addchild("item_tax", "Item Tax")
item_tax.tax_type = "Excise Duty - %s" % abbr
item_tax.tax_rate = 10
item_tax.save()
def load_data():
test_purchase_receipt.load_data()
# create customer group
webnotes.insert({"doctype": "Customer Group",
"customer_group_name": "_Test Customer Group",
"parent_customer_group": "All Customer Groups", "is_group": "No"})
# create customer
webnotes.insert({"doctype": "Customer", "customer_name": "West Wind Inc.",
"customer_type": "Company", "territory": "Default",
"customer_group": "_Test Customer Group", "company": company,
"credit_days": 50, "credit_limit": 0})
webnotes.insert({"doctype": "Account", "account_name": "_Test Account Sales",
"parent_account": "Income - %s" % abbr, "company": company,
"group_or_ledger": "Ledger"})
webnotes.insert({"doctype": "Account", "account_name": "Excise Duty",
"parent_account": "Tax Assets - %s" % abbr, "company": company,
"group_or_ledger": "Ledger"})
webnotes.insert({"doctype": "Account", "account_name": "Education Cess",
"parent_account": "Tax Assets - %s" % abbr, "company": company,
"group_or_ledger": "Ledger"})
webnotes.insert({"doctype": "Account", "account_name": "S&H Education Cess",
"parent_account": "Tax Assets - %s" % abbr, "company": company,
"group_or_ledger": "Ledger"})
webnotes.insert({"doctype": "Account", "account_name": "CST",
"parent_account": "Direct Expenses - %s" % abbr, "company": company,
"group_or_ledger": "Ledger"})
webnotes.insert({"doctype": "Account", "account_name": "adj_rate",
"parent_account": "Direct Expenses - %s" % abbr, "company": company,
"group_or_ledger": "Ledger"})
from webnotes.model.doc import Document
item = Document("Item", "Home Desktop 100")
# excise duty
item_tax = item.addchild("item_tax", "Item Tax")
item_tax.tax_type = "Excise Duty - %s" % abbr
item_tax.tax_rate = 10
item_tax.save()
def execute():
import webnotes
from webnotes.modules.module_manager import reload_doc
reload_doc('website', 'doctype', 'website_settings')
res = webnotes.conn.sql("""\
SELECT name FROM `tabDocPerm`
WHERE parent='Website Settings' AND role='All' AND permlevel=1""")
if not res:
idx = webnotes.conn.sql("""\
SELECT MAX(idx) FROM `tabDocPerm`
WHERE parent='Website Settings'
""")[0][0]
from webnotes.model.doc import Document
d = Document('DocType', 'Website Settings')
perm = d.addchild('permissions', 'DocPerm')
perm.read = 1
perm.role = 'All'
perm.permlevel = 1
perm.idx = idx + 1
perm.save()
def execute():
import webnotes
from webnotes.modules import reload_doc
reload_doc('website', 'doctype', 'website_settings')
res = webnotes.conn.sql("""\
SELECT name FROM `tabDocPerm`
WHERE parent='Website Settings' AND role='All' AND permlevel=1""")
if not res:
idx = webnotes.conn.sql("""\
SELECT MAX(idx) FROM `tabDocPerm`
WHERE parent='Website Settings'
""")[0][0]
from webnotes.model.doc import Document
d = Document('DocType', 'Website Settings')
perm = d.addchild('permissions', 'DocPerm')
perm.read = 1
perm.role = 'All'
perm.permlevel = 1
perm.idx = idx + 1
perm.save()
def load_data():
test_purchase_receipt.load_data()
# create customer group
webnotes.insert({
"doctype": "Customer Group",
"customer_group_name": "Default Customer Group",
"parent_customer_group": "All Customer Groups",
"is_group": "No"
})
# create customer
webnotes.insert({
"doctype": "Customer",
"customer_name": "West Wind Inc.",
"customer_type": "Company",
"territory": "Default",
"customer_group": "Default Customer Group",
"company": company,
"credit_days": 0,
"credit_limit": 0
})
webnotes.insert({
"doctype": "Account",
"account_name": "Excise Duty",
"parent_account": "Tax Assets - %s" % abbr,
"company": company,
"group_or_ledger": "Ledger"
})
webnotes.insert({
"doctype": "Account",
"account_name": "Education Cess",
"parent_account": "Tax Assets - %s" % abbr,
"company": company,
"group_or_ledger": "Ledger"
})
webnotes.insert({
"doctype": "Account",
"account_name": "S&H Education Cess",
"parent_account": "Tax Assets - %s" % abbr,
"company": company,
"group_or_ledger": "Ledger"
})
webnotes.insert({
"doctype": "Account",
"account_name": "CST",
"parent_account": "Direct Expenses - %s" % abbr,
"company": company,
"group_or_ledger": "Ledger"
})
webnotes.insert({
"doctype": "Account",
"account_name": "adj_rate",
"parent_account": "Direct Expenses - %s" % abbr,
"company": company,
"group_or_ledger": "Ledger"
})
from webnotes.model.doc import Document
item = Document("Item", "Home Desktop 100")
# excise duty
item_tax = item.addchild("item_tax", "Item Tax")
item_tax.tax_type = "Excise Duty - %s" % abbr
item_tax.tax_rate = 10
item_tax.save()
