def add_data_in_CSV(self, qty_diff, rate_diff):
"""Add diffs column in attached file"""
# add header
out = "'Item Code', 'Warehouse', 'Qty', 'Valuation Rate', 'Qty Diff', 'Val Rate Diff'"
# add data
for d in self.data:
s = [cstr(i) for i in d] + [cstr(qty_diff), cstr(rate_diff)]
out += "\n" + ','.join(s)
# write to file
fname = self.doc.file_list.split(',')
from webnotes.utils import file_manager
file_manager.write_file(fname[1], out.encode('utf-8'))
def add_data_in_CSV(self,data):
filename = self.doc.file_list.split(',')
head = []
for h in ['Item Code','Warehouse','Qty','Actual','Difference','MAR']:
head.append(self.getCSVelement(h))
dset = (','.join(head) + "\n")
for d in data:
l = [d[self.label['item_code']],d[self.label['warehouse']],d[self.label['qty']],d[self.label['actual_qty']],flt(d[self.label['qty']])-flt(d[self.label['actual_qty']]),d[self.label['mar']]]
s =[]
for i in l:
s.append(self.getCSVelement(i))
dset +=(','.join(s)+"\n")
from webnotes.utils import file_manager
file_manager.write_file(filename[1], dset)