def localPullInventory(request): store = request.GET['shopid'] requests_sent = RequestDetails.objects.filter(store_id=store) for r in requests_sent: inv = Inventory.objects.filter(product_id_id=r.product_id,store_id_id=store) batchid = random.randint(1,99999) ids = [] for i in inv: ids.append(i.batch_id) while(batchid in ids): batchid = random.randint(1,99999) batches = Inventory.objects.filter(product_id_id = r.product_id, store_id_id = store).order_by('-batch_id') newbatch = Inventory(product_id_id=r.product_id,store_id_id=store,batch_id=batchid,qty = r.qty,selling_price = batches[0].selling_price, cost_price=batches[0].cost_price, minimum_qty = batches[0].minimum_qty, expiry_date=batches[0].expiry_date) newbatch.save() r.delete() inventory = Inventory.objects.filter(store_id_id=store) if(inventory is not None): list = [] for i in inventory: list.append({'qty' : str(i.qty), 'batchid' : str(i.batch_id), 'productid': str(i.product_id_id), 'minimum_qty': str(i.minimum_qty), 'selling_price' : str(i.selling_price), 'cost_price' : str(i.cost_price), 'minimum_qty': str(i.minimum_qty), 'expiry_date': str(i.expiry_date)}) payload = { 'inventory': list } data = json.dumps(payload) return HttpResponse(data, content_type="application/json")
def localPullInventory(request): store = request.GET['shopid'] requests_sent = RequestDetails.objects.filter(store_id=store) for r in requests_sent: inv = Inventory.objects.filter(product_id_id=r.product_id, store_id_id=store) batchid = random.randint(1, 99999) ids = [] for i in inv: ids.append(i.batch_id) while (batchid in ids): batchid = random.randint(1, 99999) batches = Inventory.objects.filter( product_id_id=r.product_id, store_id_id=store).order_by('-batch_id') newbatch = Inventory(product_id_id=r.product_id, store_id_id=store, batch_id=batchid, qty=r.qty, selling_price=batches[0].selling_price, cost_price=batches[0].cost_price, minimum_qty=batches[0].minimum_qty, expiry_date=batches[0].expiry_date) newbatch.save() r.delete() inventory = Inventory.objects.filter(store_id_id=store) if (inventory is not None): list = [] for i in inventory: list.append({ 'qty': str(i.qty), 'batchid': str(i.batch_id), 'productid': str(i.product_id_id), 'minimum_qty': str(i.minimum_qty), 'selling_price': str(i.selling_price), 'cost_price': str(i.cost_price), 'minimum_qty': str(i.minimum_qty), 'expiry_date': str(i.expiry_date) }) payload = {'inventory': list} data = json.dumps(payload) return HttpResponse(data, content_type="application/json")
def invenf(): inventory = [] inventoryList = [] with open("Inventory_100.txt") as f: for line in f: inventory = re.split(":",line) t = [] for i in range(len(inventory)): t.append(inventory[i].strip('\n').split(",")[0]) inventoryList.append(t) counter = 0 for word in inventoryList: p = Product(name = (word[0]),manufacturer = (word[2]),product_id = int(word[3]),category = word[1],min_restock = 0.1*int(word[5])) p.save() a = 1 while (a<=5): if(counter%50 == 0): inObj1 = Inventory(minimum_qty = int(word[6]), qty = int(word[5]),batch_id = 00001,cost_price = Decimal(word[4]),selling_price = Decimal(str(1.05))*Decimal(word[4]) ,product_id_id = int(word[3]),store_id_id=a,expiry_date=datetime.date(2013,12,15)) inObj2 = Inventory(minimum_qty = int(word[6]), qty = int(word[5]),batch_id = 00002,cost_price = Decimal(str(1.1))*Decimal(word[4]),selling_price = Decimal(str(1.15))*Decimal(word[4]) ,product_id_id = int(word[3]),store_id_id=a,expiry_date=datetime.date(2013,12,16)) else: inObj1 = Inventory(minimum_qty = int(word[6]), qty = int(word[5]),batch_id = 00001,cost_price = Decimal(word[4]),selling_price = Decimal(str(1.05))*Decimal(word[4]) ,product_id_id = int(word[3]),store_id_id=a) inObj2 = Inventory(minimum_qty = int(word[6]), qty = int(word[5]),batch_id = 00002,cost_price = Decimal(str(1.1))*Decimal(word[4]),selling_price = Decimal(str(1.15))*Decimal(word[4]) ,product_id_id = int(word[3]),store_id_id=a) inObj1.save() inObj2.save() a = a + 1 counter = counter + 1