def execute(): webnotes.conn.auto_commit_on_many_writes = 1 from utilities.repost_stock import repost_stock for d in webnotes.conn.sql("""select distinct production_item, fg_warehouse from `tabProduction Order` where docstatus>0""", as_dict=1): repost_stock(d.production_item, d.fg_warehouse) webnotes.conn.auto_commit_on_many_writes = 0
def execute(): webnotes.conn.auto_commit_on_many_writes = 1 from utilities.repost_stock import repost_stock for d in webnotes.conn.sql( """select distinct production_item, fg_warehouse from `tabProduction Order` where docstatus>0""", as_dict=1): repost_stock(d.production_item, d.fg_warehouse) webnotes.conn.auto_commit_on_many_writes = 0
def recalculate_bin_qty(self, newdn): from utilities.repost_stock import repost_stock webnotes.conn.auto_commit_on_many_writes = 1 webnotes.conn.set_default("allow_negative_stock", 1) for warehouse in webnotes.conn.sql("select name from `tabWarehouse`"): repost_stock(newdn, warehouse[0]) webnotes.conn.set_default("allow_negative_stock", webnotes.conn.get_value("Stock Settings", None, "allow_negative_stock")) webnotes.conn.auto_commit_on_many_writes = 0
def recalculate_bin_qty(self, newdn): from utilities.repost_stock import repost_stock webnotes.conn.auto_commit_on_many_writes = 1 webnotes.conn.set_default("allow_negative_stock", 1) for warehouse in webnotes.conn.sql("select name from `tabWarehouse`"): repost_stock(newdn, warehouse[0]) webnotes.conn.set_default( "allow_negative_stock", webnotes.conn.get_value("Stock Settings", None, "allow_negative_stock")) webnotes.conn.auto_commit_on_many_writes = 0
def recalculate_bin_qty(self, newdn): from utilities.repost_stock import repost_stock webnotes.conn.auto_commit_on_many_writes = 1 webnotes.conn.set_default("allow_negative_stock", 1) for item in webnotes.conn.sql("""select distinct item_code from ( select name as item_code from `tabItem` where ifnull(is_stock_item, 'Yes')='Yes' union select distinct item_code from tabBin) a"""): repost_stock(item[0], newdn) webnotes.conn.set_default("allow_negative_stock", webnotes.conn.get_value("Stock Settings", None, "allow_negative_stock")) webnotes.conn.auto_commit_on_many_writes = 0
def recalculate_bin_qty(self, newdn): from utilities.repost_stock import repost_stock webnotes.conn.auto_commit_on_many_writes = 1 webnotes.conn.set_default("allow_negative_stock", 1) for item in webnotes.conn.sql("""select distinct item_code from ( select name as item_code from `tabItem` where ifnull(is_stock_item, 'Yes')='Yes' union select distinct item_code from tabBin) a"""): repost_stock(item[0], newdn) webnotes.conn.set_default( "allow_negative_stock", webnotes.conn.get_value("Stock Settings", None, "allow_negative_stock")) webnotes.conn.auto_commit_on_many_writes = 0
def execute(): from utilities.repost_stock import repost_stock webnotes.conn.sql("""delete from tabBin where ifnull(item_code, '') = '' or ifnull(warehouse, '')=''""") webnotes.conn.auto_commit_on_many_writes = 1 for d in webnotes.conn.sql("""select item_code, warehouse, count(*) as count from tabBin group by item_code, warehouse""", as_dict=1): if d.count > 1: webnotes.conn.sql("""delete from tabBin where item_code=%s and warehouse=%s limit %s""", (d.item_code, d.warehouse, d.count-1)) repost_stock(d.item_code, d.warehouse) webnotes.conn.auto_commit_on_many_writes = 0
def execute(): from utilities.repost_stock import repost_stock webnotes.conn.sql("""delete from tabBin where ifnull(item_code, '') = '' or ifnull(warehouse, '')=''""") webnotes.conn.auto_commit_on_many_writes = 1 for d in webnotes.conn.sql( """select item_code, warehouse, count(*) as count from tabBin group by item_code, warehouse""", as_dict=1): if d.count > 1: webnotes.conn.sql( """delete from tabBin where item_code=%s and warehouse=%s limit %s""", (d.item_code, d.warehouse, d.count - 1)) repost_stock(d.item_code, d.warehouse) webnotes.conn.auto_commit_on_many_writes = 0