Ejemplos de update_bin_qty en Python

Ejemplo n.º 1

def execute():
	repost_for = frappe.db.sql("""
		select 
			distinct item_code, warehouse 
		from 
			(
				(
					select distinct item_code, warehouse 
								from `tabSales Order Item` where docstatus=1
				) UNION (
					select distinct item_code, warehouse 
					from `tabPacked Item` where docstatus=1 and parenttype='Sales Order'
				)
			) so_item
		where
			exists(select name from tabItem where name=so_item.item_code and ifnull(is_stock_item, 0)=1)
	""")

	for item_code, warehouse in repost_for:
			update_bin_qty(item_code, warehouse, {
				"reserved_qty": get_reserved_qty(item_code, warehouse)
			})
			
	frappe.db.sql("""delete from tabBin 
		where exists(
			select name from tabItem where name=tabBin.item_code and ifnull(is_stock_item, 0) = 0
		)
	""")

Ejemplo n.º 2

Archivo: fix_reserved_qty_and_sle_for_packed_items.py Proyecto: bjoliveau/erpnext

def execute():
    cancelled_invoices = frappe.db.sql_list(
        """select name from `tabSales Invoice` 
		where docstatus = 2 and ifnull(update_stock, 0) = 1""")

    if cancelled_invoices:
        repost_for = frappe.db.sql(
            """select distinct item_code, warehouse from `tabStock Ledger Entry`
			where voucher_type = 'Sales Invoice' and voucher_no in (%s)""" %
            (', '.join(['%s'] * len(cancelled_invoices))),
            tuple(cancelled_invoices))

        frappe.db.sql(
            """delete from `tabStock Ledger Entry` 
			where voucher_type = 'Sales Invoice' and voucher_no in (%s)""" %
            (', '.join(['%s'] * len(cancelled_invoices))),
            tuple(cancelled_invoices))

        for item_code, warehouse in repost_for:
            repost_actual_qty(item_code, warehouse)

    for item_code, warehouse in frappe.db.sql(
            """select distinct item_code, warehouse 
		from `tabPacked Item` where parenttype = 'Sales Invoice' and docstatus = 1"""
    ):
        update_bin_qty(
            item_code, warehouse,
            {"reserved_qty": get_reserved_qty(item_code, warehouse)})

Ejemplo n.º 3

def execute():
	from erpnext.utilities.repost_stock import update_bin_qty, get_indented_qty

	count=0
	for item_code, warehouse in frappe.db.sql("""select distinct item_code, warehouse 
		from `tabMaterial Request Item` where docstatus = 1"""):
			try:
				count += 1
				update_bin_qty(item_code, warehouse, {
					"indented_qty": get_indented_qty(item_code, warehouse),
				})
				if count % 200 == 0:
					frappe.db.commit()
			except:
				frappe.db.rollback()

Ejemplo n.º 4

Archivo: update_requested_and_ordered_qty.py Proyecto: 4commerce-technologies-AG/erpnext

def execute():
	from erpnext.utilities.repost_stock import update_bin_qty, get_indented_qty, get_ordered_qty

	count=0
	for item_code, warehouse in frappe.db.sql("""select distinct item_code, warehouse from
		(select item_code, warehouse from tabBin
		union
		select item_code, warehouse from `tabStock Ledger Entry`) a"""):
			try:
				count += 1
				update_bin_qty(item_code, warehouse, {
					"indented_qty": get_indented_qty(item_code, warehouse),
					"ordered_qty": get_ordered_qty(item_code, warehouse)
				})
				if count % 200 == 0:
					frappe.db.commit()
			except:
				frappe.db.rollback()

Ejemplo n.º 5

Archivo: update_requested_and_ordered_qty.py Proyecto: maticaZA/foundation

def execute():
    from erpnext.utilities.repost_stock import update_bin_qty, get_indented_qty, get_ordered_qty

    count = 0
    for item_code, warehouse in frappe.db.sql(
            """select distinct item_code, warehouse from
		(select item_code, warehouse from tabBin
		union
		select item_code, warehouse from `tabStock Ledger Entry`) a"""):
        try:
            count += 1
            update_bin_qty(
                item_code, warehouse, {
                    "indented_qty": get_indented_qty(item_code, warehouse),
                    "ordered_qty": get_ordered_qty(item_code, warehouse)
                })
            if count % 200 == 0:
                frappe.db.commit()
        except:
            frappe.db.rollback()

Ejemplo n.º 6

Archivo: fix_reserved_qty_and_sle_for_packed_items.py Proyecto: harshcrop/erpnext

def execute():
	cancelled_invoices = frappe.db.sql_list("""select name from `tabSales Invoice` 
		where docstatus = 2 and ifnull(update_stock, 0) = 1""")

	if cancelled_invoices:
		repost_for = frappe.db.sql("""select distinct item_code, warehouse from `tabStock Ledger Entry`
			where voucher_type = 'Sales Invoice' and voucher_no in (%s)""" 
			% (', '.join(['%s']*len(cancelled_invoices))), tuple(cancelled_invoices))
			
		frappe.db.sql("""delete from `tabStock Ledger Entry` 
			where voucher_type = 'Sales Invoice' and voucher_no in (%s)""" 
			% (', '.join(['%s']*len(cancelled_invoices))), tuple(cancelled_invoices))
			
		for item_code, warehouse in repost_for:
			repost_actual_qty(item_code, warehouse)
			
	for item_code, warehouse in frappe.db.sql("""select distinct item_code, warehouse 
		from `tabPacked Item` where parenttype = 'Sales Invoice' and docstatus = 1"""):
			update_bin_qty(item_code, warehouse, {
				"reserved_qty": get_reserved_qty(item_code, warehouse)
			})

Ejemplo n.º 7

Archivo: repost_reserved_qty.py Proyecto: David-Duarte/erpnext

def execute():
	for item_code, warehouse in frappe.db.sql("select item_code, warehouse from tabBin where ifnull(reserved_qty, 0) < 0"):
		update_bin_qty(item_code, warehouse, {
			"reserved_qty": get_reserved_qty(item_code, warehouse)
		})