def addToTables():
print "inside function"
transaction = []
transactionList = []
storeid = 00000001
with open("Trans_50_2_9_22639.txt") as f:
for line in f:
transaction = re.split(":", line)
t = []
for i in range(len(transaction)):
t.append(transaction[i].strip('\n').split(",")[0])
transactionList.append(t)
print transactionList[0]
for word in transactionList:
tdate = datetime.datetime.strptime(word[5], '%d/%m/%Y').date()
if not (tdate == datetime.datetime(2013, 9, 29)):
inventory = Inventory.objects.get(product_id_id=int(word[3]),
batch_id=00000001,
store_id_id=storeid)
inventory.qty = inventory.qty - int(word[4])
t = Transaction(transaction_id=int(word[0]),
batch_id=00000001,
quantity_sold=int(word[4]),
product_id=int(word[3]),
transaction_date=tdate,
cashier_id=int(word[1]),
selling_price=inventory.selling_price,
cost_price=inventory.cost_price)
t.save()
def localPushTransaction(request):
data = json.loads(request.raw_post_data)
transaction = data['transaction']
for i in transaction:
transaction_id = int(i['transaction_id'])
transaction_date = datetime.datetime.strptime(i['transaction_date'],
'%Y-%m-%d').date()
cashreg_id = int(i['cashregid'])
barcode = int(i['barcode'])
qty = int(i['qty'])
shopid = int(i['shopid'])
selling_price = Decimal(i['selling_price'])
cost_price = Decimal(i['cost_price'])
batchid = int(i['batchid'])
new_transaction = Transaction(transaction_id=transaction_id,
transaction_date=transaction_date,
cashier_id=cashreg_id,
store_id=shopid,
product_id=barcode,
quantity_sold=qty,
selling_price=selling_price,
cost_price=cost_price,
batch_id=batchid)
new_transaction.save()
return HttpResponse('Yo Transaction')
def localPushTransaction(request):
data=json.loads(request.raw_post_data)
transaction = data['transaction']
for i in transaction:
transaction_id = int(i['transaction_id'])
transaction_date = datetime.datetime.strptime(i['transaction_date'], '%Y-%m-%d').date()
cashreg_id = int(i['cashregid'])
barcode = int(i['barcode'])
qty = int(i['qty'])
shopid = int(i['shopid'])
selling_price = Decimal(i['selling_price'])
cost_price = Decimal(i['cost_price'])
batchid = int(i['batchid'])
new_transaction = Transaction(transaction_id=transaction_id,transaction_date = transaction_date, cashier_id = cashreg_id, store_id=shopid,product_id = barcode, quantity_sold=qty,selling_price=selling_price,cost_price=cost_price,batch_id=batchid)
new_transaction.save()
return HttpResponse('Yo Transaction')
def addToTables():
print "inside function"
transaction = []
transactionList = []
storeid = 00000001
with open("Trans_50_2_9_22639.txt") as f:
for line in f:
transaction = re.split(":",line)
t = []
for i in range(len(transaction)):
t.append(transaction[i].strip('\n').split(",")[0])
transactionList.append(t)
print transactionList[0]
for word in transactionList:
tdate = datetime.datetime.strptime(word[5], '%d/%m/%Y').date()
if not(tdate == datetime.datetime(2013,9,29)):
inventory = Inventory.objects.get(product_id_id = int(word[3]),batch_id=00000001,store_id_id=storeid)
inventory.qty = inventory.qty - int(word[4])
t = Transaction(transaction_id = int(word[0]), batch_id = 00000001, quantity_sold = int(word[4]),product_id = int(word[3]),transaction_date = tdate,cashier_id=int(word[1]),selling_price = inventory.selling_price, cost_price = inventory.cost_price)
t.save()
