setup/page/setup/setup.py

# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd.
# License: GNU General Public License v3. See license.txt

from __future__ import unicode_literals
import webnotes
from webnotes import _

items = [
	{
		"type": "Section",
		"title": _("Organization"),
		"icon": "icon-building"
	},
	{"doctype":"Company"},
	{"doctype":"Fiscal Year"},
	{"doctype":"Currency", "filter": {"enabled": 1}},
	{
		"type": "Section",
		"title": _("Users and Permissions"),
		"icon": "icon-user"
	},
	{
		"doctype":"Profile",
	},
	{
		"doctype":"Role",
	},
	{ "title": _("Permission Manager"),
		"route": "permission-manager", "type": "Link", "icon": "icon-shield" },
	{ "title": _("User Properties"),
		"route": "user-properties", "type": "Link", "icon": "icon-user" },
	{
		"type": "Section",
		"title": _("Master Data"),
		"icon": "icon-star"
	},
	{
		"doctype": "Item",
		"dependencies": [
			{"doctype":"Item Group", "tree": "Sales Browser"},
			{"doctype":"Warehouse"},
			{"doctype":"UOM"},
			{"doctype":"Brand"},
			{"doctype":"Price List"},
			{"doctype": "Item Price"},
			{ "title": _("Stock Settings"),
				"route": "Form/Stock Settings", "type": "Link", "icon": "icon-cog" },
		],
	},
	{
		"doctype": "Customer",
		"dependencies": [
			{"doctype":"Customer Group", "tree": "Sales Browser"},
			{"doctype":"Territory", "tree": "Sales Browser"},
			{"doctype":"Sales Person", "tree": "Sales Browser"},
			{"doctype":"Contact", "query": "select count(*) from `tabContact` where ifnull(customer, '')!=''"},
			{"doctype":"Address", "query": "select count(*) from `tabAddress` where ifnull(customer, '')!=''"},
			{ "title": _("Selling Settings"),
				"route": "Form/Selling Settings", "type": "Link", "icon": "icon-cog" },
		]
	},
	{
		"doctype": "Supplier",
		"dependencies": [
			{"doctype":"Supplier Type"},
			{"doctype":"Contact", "query": "select count(*) from `tabContact` where ifnull(supplier, '')!=''"},
			{"doctype":"Address", "query": "select count(*) from `tabAddress` where ifnull(supplier, '')!=''"},
			{ "title": _("Buying Settings"),
				"route": "Form/Buying Settings", "type": "Link", "icon": "icon-cog" },
		]
	},
	{
		"type": "Section",
		"title": _("Accounts"),
		"icon": "icon-money"
	},
	{
		"doctype": "Account",
		"tree": "Accounts Browser",
		"dependencies": [
			{
				"title": _("Bank Accounts"),
				"doctype":"Account",
				"filter": {"account_type": "Bank or Cash"}
			},
			{
				"title": _("Tax Accounts"),
				"doctype":"Account",
				"filter": {"account_type": "Tax"}
			},
		]
	},
	{
		"doctype": "Cost Center",
		"tree": "Accounts Browser",
	},
	{ "doctype": "Sales Taxes and Charges Master" },
	{ "doctype": "Purchase Taxes and Charges Master" },
	{ "doctype": "Shipping Rule" },
	{ "doctype": "Currency Exchange" },
	{ "title": _("Accounts Settings"),
		"route": "Form/Accounts Settings", "type": "Link", "icon": "icon-cog" },
	{
		"type": "Section",
		"title": _("Opening Accounts and Stock"),
		"icon": "icon-eye-open"
	},
	{ "doctype": "Stock Reconciliation" },
	{
		"doctype": "Journal Voucher",
		"title": _("Opening Accounting Entries"),
		"filter": {
			"is_opening": "Yes"
		}
	},
	{
		"type": "Section",
		"title": _("Human Resource"),
		"icon": "icon-group"
	},
	{
		"doctype": "Employee",
		"dependencies": [
			{ "doctype": "Employment Type" },
			{ "doctype": "Branch" },
			{ "doctype": "Department" },
			{ "doctype": "Designation" },
			{ "doctype": "Holiday List" },
			{ "doctype": "Grade" },
		]
	 },
	{ "doctype": "Salary Structure" },
	{ "doctype": "Leave Allocation" },
	{ "doctype": "Appraisal Template" },
	{
		"type": "Section",
		"title": _("Printing"),
		"icon": "icon-print"
	},
	{ "doctype": "Terms and Conditions" },
	{ "doctype": "Letter Head" },
	{ "doctype": "Print Heading" },
	{ "doctype": "Print Format", "filter": {"standard": "No"} },
	{
		"type": "Section",
		"title": _("Email"),
		"icon": "icon-envelope-alt"
	},
	{
		"title": _("Outgoing Email Settings"),
		"doctype": "Email Settings",
		"single": 1,
		"query": "select count(*) from tabSingles where doctype='Email Settings' and field='outgoing_mail_server'"
	},
	{
		"title": _("Support Email Settings"),
		"doctype": "Email Settings",
		"single": 1,
		"query": "select count(*) from tabSingles where doctype='Email Settings' and field='support_host'"
	},
	{
		"doctype": "Sales Email Settings",
		"single": 1,
		"query": "select count(*) from tabSingles where doctype='Sales Email Settings' and field='host'"
	},
	{
		"doctype": "Jobs Email Settings",
		"single": 1,
		"query": "select count(*) from tabSingles where doctype='Jobs Email Settings' and field='host'"
	},
	{
		"doctype": "Email Digest",
	},
	{
		"type": "Section",
		"title": _("Customization"),
		"icon": "icon-glass"
	},
	{
		"doctype": "Customize Form",
		"single": 1,
		"query": "select count(distinct doc_type) from `tabProperty Setter`"
	},
	{ "doctype": "Workflow" },
	{ "doctype": "Authorization Rule" },
	{ "doctype": "Custom Field" },
	{ "doctype": "Custom Script" },
	{
		"type": "Section",
		"title": _("Tools"),
		"icon": "icon-wrench"
	},
	{ "title": _("Global Settings / Default Values"),
		"doctype": "Global Defaults", "single": 1,
	 	"query": """select count(*) from tabSingles where doctype='Global Defaults'
		and field not in ('owner', 'creation', 'modified', 'modified_by')"""},
	
	{ "title": _("Show / Hide Features"),
		"doctype": "Features Setup", "single": 1,
	 	"query": """select count(*) from tabSingles where doctype='Features Setup'
		and field not in ('owner', 'creation', 'modified', 'modified_by')"""},
	
	{ "title": _("Enable / Disable Email Notifications"),
		"doctype": "Notification Control", "single": 1,
	 	"query": """select count(*) from tabSingles where doctype='Notification Control'
		and field in ('quotation', 'sales_order', 'sales_invoice', 'purchase_order', 'purchase_receipt', 'expense_claim', 'delivery_note')"""},
	
	{ "doctype": "File Data", "title": _("Uploaded File Attachments") },
	{
		"doctype": "SMS Settings",
		"single": 1,
	 	"query": "select count(*) from tabSingles where doctype='SMS Settings' and field='sms_gateway_url'"
	},
	
	{ "title": _("Data Import"),
		"route": "data-import-tool", "type": "Link", "icon": "icon-upload" },
	{ "title": _("Bulk Rename"),
		"route": "Form/Rename Tool", "type": "Link", "icon": "icon-upload" },
	{ "title": _("Update Numbering Series"),
		"route": "Form/Naming Series", "type": "Link", "icon": "icon-sort-by-order" },
	{ "title": _("Show / Hide Modules"),
		"route": "modules_setup", "type": "Link", "icon": "icon-th" },
	{ "title": _("Send Bulk SMS to Leads / Contacts"),
		"route": "Form/SMS Center", "type": "Link", "icon": "icon-mobile-phone" },
	{
		"type": "Section",
		"title": _("System Administration"),
		"icon": "icon-cog"
	},
	{ "title": _("Manage 3rd Party Backups"),
		"route": "Form/Backup Manager", "type": "Link", "icon": "icon-cloud" },
	{ "title": _("System Scheduler Errors"),
		"route": "Report/Scheduler Log", "type": "Link", "icon": "icon-exclamation-sign" },
]

@webnotes.whitelist(allow_roles=["System Manager"])
def get():
	for item in items:
		if item.get("type")=="Section":
			continue
		set_count(item)
		
		if item.get("dependencies"):
			for d in item["dependencies"]:
				set_count(d)
	
	return items

def set_count(item):
	if "query" in item:
		item["count"] = webnotes.conn.sql(item["query"])[0][0]
	elif "filter" in item:
		key = item["filter"].keys()[0]
		item["count"] = webnotes.conn.sql("""select count(*) from `tab%s` where
			%s = %s and docstatus < 2""" % (item["doctype"], key, "%s"),
			item["filter"][key])[0][0]
	elif "doctype" in item:
		item["count"] = webnotes.conn.sql("select count(*) from `tab%s` where docstatus<2" \
			% item["doctype"])[0][0]