| Nabin Hait | b28d6dc | 2011-12-06 15:11:14 +0530 | [diff] [blame] | 1 | def execute(): |
| 2 | import webnotes |
| 3 | sql = webnotes.conn.sql |
| 4 | from webnotes.model.code import get_obj |
| 5 | |
| 6 | # update incoming rate in serial nos |
| 7 | sr = sql("""select name, item_code, purchase_document_no from `tabSerial No` |
| 8 | where docstatus = 1 and purchase_document_type = 'Purchase Receipt'""") |
| 9 | for d in sr: |
| 10 | val_rate = sql("""select valuation_rate from `tabPurchase Receipt Detail` |
| 11 | where item_code = %s and parent = %s""", (d[1], d[2])) |
| 12 | sql("""update `tabSerial No` set purchase_rate = %s where name = %s""", |
| 13 | (val_rate and flt(val_rate[0][0]) or 0, d[0])) |
| 14 | |
| 15 | |
| 16 | # repost for all serialized item |
| 17 | bin = sql("""select t1.name from `tabBin` t1, tabItem t2 where t1.item_code = t2.name and ifnull(has_serial_no, 'No') = 'Yes'""") |
| 18 | for d in bin: |
| 19 | get_obj('Bin', d[0]).update_entries_after(posting_date = '2000-01-01', posting_time = '12:00') |
| 20 | sql("commit") |
| 21 | sql("start transaction") |
| 22 | |