Python update_item_projected_qtyの例

コード例 #1

ファイル: repost_bin_qty_and_item_projected_qty.py プロジェクト: Aptitudetech/ERPNext

def repost_item_projected_qty():
	for data in frappe.db.sql(""" select 
			`tabBin`.item_code as item_code,
			sum(`tabBin`.projected_qty) as projected_qty, 
			`tabItem`.total_projected_qty as total_projected_qty 
		from 
			`tabBin`, `tabItem` 
		where `tabBin`.item_code = `tabItem`.name 
		group by `tabBin`.item_code having projected_qty <>  total_projected_qty """, as_dict=1):
		update_item_projected_qty(data.item_code)

コード例 #2

ファイル: repost_bin_qty_and_item_projected_qty.py プロジェクト: Ravn10/erpnext-signext

def repost_item_projected_qty():
    for data in frappe.db.sql(""" select 
			`tabBin`.item_code as item_code,
			sum(`tabBin`.projected_qty) as projected_qty, 
			`tabItem`.total_projected_qty as total_projected_qty 
		from 
			`tabBin`, `tabItem` 
		where `tabBin`.item_code = `tabItem`.name 
		group by `tabBin`.item_code having projected_qty <>  total_projected_qty """,
                              as_dict=1):
        update_item_projected_qty(data.item_code)

コード例 #3

ファイル: update_item_projected.py プロジェクト: Aptitudetech/ERPNext

def execute():
	frappe.reload_doctype("Item")
	from erpnext.stock.doctype.bin.bin import update_item_projected_qty
	for item in frappe.get_all("Item", filters={"is_stock_item": 1}):
		update_item_projected_qty(item.name)

コード例 #4

def execute():
    frappe.reload_doctype("Item")
    from erpnext.stock.doctype.bin.bin import update_item_projected_qty
    for item in frappe.get_all("Item", filters={"is_stock_item": 1}):
        update_item_projected_qty(item.name)