Aniket_Tewari_Inventory_Management_System.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Aniket Tewari-Inventory Management System",
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "jzpHJSEtDm4i"
      },
      "source": [
        "**Importing json Module**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CNYnIAOizCit"
      },
      "source": [
        "import json"
      ],
      "execution_count": 27,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "_nQgUu9CDviA"
      },
      "source": [
        "**Reading Recod.json File**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "AeKFvb8dzdNq"
      },
      "source": [
        "fd=open(\"record.json\",'r')\n",
        "data=fd.read()\n",
        "fd.close()\n",
        "records=json.loads(data)"
      ],
      "execution_count": 28,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "0WvyrcRHzgLV",
        "outputId": "5f466d89-3d83-4797-80d3-f68e883cb4d5"
      },
      "source": [
        "records"
      ],
      "execution_count": 29,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'1001': {'Discount': 0,\n",
              "  'Expiry Date': '01/12/2021',\n",
              "  'Manufacturing Date': '01/09/2021',\n",
              "  'Name': 'Dairy Milk',\n",
              "  'Price': 5,\n",
              "  'Quantity': 500},\n",
              " '1002': {'Discount': 0,\n",
              "  'Expiry Date': '15/12/2021',\n",
              "  'Manufacturing Date': '15/08/2021',\n",
              "  'Name': 'Dairy Milk',\n",
              "  'Price': 10,\n",
              "  'Quantity': 600},\n",
              " '1003': {'Discount': 1,\n",
              "  'Expiry Date': '13/12/2021',\n",
              "  'Manufacturing Date': '13/08/2021',\n",
              "  'Name': 'Dairy Milk',\n",
              "  'Price': 20,\n",
              "  'Quantity': 450},\n",
              " '1004': {'Discount': 0,\n",
              "  'Expiry Date': '03/12/2021',\n",
              "  'Manufacturing Date': '03/09/2021',\n",
              "  'Name': 'Dairy Milk',\n",
              "  'Price': 80,\n",
              "  'Quantity': 420},\n",
              " '1005': {'Discount': 0,\n",
              "  'Expiry Date': '08/12/2021',\n",
              "  'Manufacturing Date': '08/08/2021',\n",
              "  'Name': 'Kit Kat',\n",
              "  'Price': 5,\n",
              "  'Quantity': 200},\n",
              " '1006': {'Discount': 2,\n",
              "  'Expiry Date': '11/12/2021',\n",
              "  'Manufacturing Date': '11/08/2021',\n",
              "  'Name': 'Kit Kat',\n",
              "  'Price': 10,\n",
              "  'Quantity': 320},\n",
              " '1007': {'Discount': 0,\n",
              "  'Expiry Date': '13/12/2021',\n",
              "  'Manufacturing Date': '13/07/2021',\n",
              "  'Name': 'Kit Kat',\n",
              "  'Price': 20,\n",
              "  'Quantity': 400},\n",
              " '1008': {'Discount': 1,\n",
              "  'Expiry Date': '01/12/2021',\n",
              "  'Manufacturing Date': '01/08/2021',\n",
              "  'Name': 'Kit Kat',\n",
              "  'Price': 80,\n",
              "  'Quantity': 500},\n",
              " '1009': {'Discount': 0,\n",
              "  'Expiry Date': '12/12/2021',\n",
              "  'Manufacturing Date': '12/08/2021',\n",
              "  'Name': '5 Star',\n",
              "  'Price': 5,\n",
              "  'Quantity': 345},\n",
              " '1010': {'Discount': 1,\n",
              "  'Expiry Date': '05/12/2021',\n",
              "  'Manufacturing Date': '05/08/2021',\n",
              "  'Name': '5 Star',\n",
              "  'Price': 10,\n",
              "  'Quantity': 258},\n",
              " '1011': {'Discount': 0,\n",
              "  'Expiry Date': '23/12/2021',\n",
              "  'Manufacturing Date': '23/07/2021',\n",
              "  'Name': '5 Star',\n",
              "  'Price': 20,\n",
              "  'Quantity': 210},\n",
              " '1012': {'Discount': 0,\n",
              "  'Expiry Date': '26/12/2021',\n",
              "  'Manufacturing Date': '26/06/2021',\n",
              "  'Name': '5 Star',\n",
              "  'Price': 80,\n",
              "  'Quantity': 180},\n",
              " '1013': {'Discount': 0,\n",
              "  'Expiry Date': '03/12/2021',\n",
              "  'Manufacturing Date': '03/09/2021',\n",
              "  'Name': 'Munch',\n",
              "  'Price': 5,\n",
              "  'Quantity': 340},\n",
              " '1014': {'Discount': 0,\n",
              "  'Expiry Date': '01/12/2021',\n",
              "  'Manufacturing Date': '01/09/2021',\n",
              "  'Name': 'Munch',\n",
              "  'Price': 10,\n",
              "  'Quantity': 320},\n",
              " '1015': {'Discount': 0,\n",
              "  'Expiry Date': '12/12/2021',\n",
              "  'Manufacturing Date': '12/08/2021',\n",
              "  'Name': 'Munch',\n",
              "  'Price': 20,\n",
              "  'Quantity': 420},\n",
              " '1016': {'Discount': 3,\n",
              "  'Expiry Date': '01/12/2021',\n",
              "  'Manufacturing Date': '01/09/2021',\n",
              "  'Name': 'Munch',\n",
              "  'Price': 80,\n",
              "  'Quantity': 310},\n",
              " '1017': {'Discount': 0,\n",
              "  'Expiry Date': '01/12/2021',\n",
              "  'Manufacturing Date': '01/08/2021',\n",
              "  'Name': 'Perk',\n",
              "  'Price': 5,\n",
              "  'Quantity': 500},\n",
              " '1018': {'Discount': 1,\n",
              "  'Expiry Date': '27/12/2021',\n",
              "  'Manufacturing Date': '27/07/2021',\n",
              "  'Name': 'Perk',\n",
              "  'Price': 10,\n",
              "  'Quantity': 530},\n",
              " '1019': {'Discount': 0,\n",
              "  'Expiry Date': '02/12/2021',\n",
              "  'Manufacturing Date': '02/09/2021',\n",
              "  'Name': 'Perk',\n",
              "  'Price': 20,\n",
              "  'Quantity': 630},\n",
              " '1020': {'Discount': 2,\n",
              "  'Expiry Date': '16/12/2021',\n",
              "  'Manufacturing Date': '16/08/2021',\n",
              "  'Name': 'Perk',\n",
              "  'Price': 80,\n",
              "  'Quantity': 218},\n",
              " '1021': {'Discount': 8,\n",
              "  'Expiry Date': '01/12/2021',\n",
              "  'Manufacturing Date': '01/07/2021',\n",
              "  'Name': 'Eclairs',\n",
              "  'Price': 5,\n",
              "  'Quantity': 345},\n",
              " '1022': {'Discount': 0,\n",
              "  'Expiry Date': '01/12/2021',\n",
              "  'Manufacturing Date': '01/09/2021',\n",
              "  'Name': 'Eclairs',\n",
              "  'Price': 10,\n",
              "  'Quantity': 368},\n",
              " '1023': {'Discount': 4,\n",
              "  'Expiry Date': '15/12/2021',\n",
              "  'Manufacturing Date': '15/08/2021',\n",
              "  'Name': 'Eclairs',\n",
              "  'Price': 20,\n",
              "  'Quantity': 426},\n",
              " '1024': {'Discount': 0,\n",
              "  'Expiry Date': '14/12/2021',\n",
              "  'Manufacturing Date': '14/08/2021',\n",
              "  'Name': 'Eclairs',\n",
              "  'Price': 80,\n",
              "  'Quantity': 140},\n",
              " '1025': {'Discount': 0,\n",
              "  'Expiry Date': '20/12/2021',\n",
              "  'Manufacturing Date': '20/07/2021',\n",
              "  'Name': 'Sunfeast',\n",
              "  'Price': 5,\n",
              "  'Quantity': 300},\n",
              " '1026': {'Discount': 3,\n",
              "  'Expiry Date': '21/12/2021',\n",
              "  'Manufacturing Date': '21/08/2021',\n",
              "  'Name': 'Sunfeast',\n",
              "  'Price': 10,\n",
              "  'Quantity': 400},\n",
              " '1027': {'Discount': 0,\n",
              "  'Expiry Date': '01/12/2021',\n",
              "  'Manufacturing Date': '01/09/2021',\n",
              "  'Name': 'Sunfeast',\n",
              "  'Price': 20,\n",
              "  'Quantity': 500},\n",
              " '1028': {'Discount': 0,\n",
              "  'Expiry Date': '30/12/2021',\n",
              "  'Manufacturing Date': '30/08/2021',\n",
              "  'Name': 'Sunfeast',\n",
              "  'Price': 80,\n",
              "  'Quantity': 100},\n",
              " '1029': {'Discount': 1,\n",
              "  'Expiry Date': '23/12/2021',\n",
              "  'Manufacturing Date': '23/08/2021',\n",
              "  'Name': 'Priyagold',\n",
              "  'Price': 5,\n",
              "  'Quantity': 278},\n",
              " '1030': {'Discount': 0,\n",
              "  'Expiry Date': '03/12/2021',\n",
              "  'Manufacturing Date': '03/07/2021',\n",
              "  'Name': 'Priyagold',\n",
              "  'Price': 10,\n",
              "  'Quantity': 160},\n",
              " '1031': {'Discount': 0,\n",
              "  'Expiry Date': '03/12/2021',\n",
              "  'Manufacturing Date': '03/09/2021',\n",
              "  'Name': 'Priyagold',\n",
              "  'Price': 20,\n",
              "  'Quantity': 150},\n",
              " '1032': {'Discount': 0,\n",
              "  'Expiry Date': '05/12/2021',\n",
              "  'Manufacturing Date': '05/08/2021',\n",
              "  'Name': '5 Star',\n",
              "  'Price': 10,\n",
              "  'Quantity': 110},\n",
              " '1033': {'Discount': 0,\n",
              "  'Expiry Date': '23/12/2021',\n",
              "  'Manufacturing Date': '23/07/2021',\n",
              "  'Name': '5 Star',\n",
              "  'Price': 20,\n",
              "  'Quantity': 210},\n",
              " '1034': {'Discount': 0,\n",
              "  'Expiry Date': '26/12/2021',\n",
              "  'Manufacturing Date': '26/06/2021',\n",
              "  'Name': '5 Star',\n",
              "  'Price': 80,\n",
              "  'Quantity': 380},\n",
              " '1035': {'Discount': 0,\n",
              "  'Expiry Date': '03/12/2021',\n",
              "  'Manufacturing Date': '03/09/2021',\n",
              "  'Name': 'Munch',\n",
              "  'Price': 5,\n",
              "  'Quantity': 400},\n",
              " '1036': {'Discount': 2,\n",
              "  'Expiry Date': '01/12/2021',\n",
              "  'Manufacturing Date': '01/09/2021',\n",
              "  'Name': 'Munch',\n",
              "  'Price': 10,\n",
              "  'Quantity': 410},\n",
              " '1037': {'Discount': 0,\n",
              "  'Expiry Date': '12/12/2021',\n",
              "  'Manufacturing Date': '12/08/2021',\n",
              "  'Name': 'Munch',\n",
              "  'Price': 20,\n",
              "  'Quantity': 380},\n",
              " '1038': {'Discount': 0,\n",
              "  'Expiry Date': '01/12/2021',\n",
              "  'Manufacturing Date': '01/09/2021',\n",
              "  'Name': 'Munch',\n",
              "  'Price': 80,\n",
              "  'Quantity': 145},\n",
              " '1039': {'Discount': 0,\n",
              "  'Expiry Date': '01/12/2021',\n",
              "  'Manufacturing Date': '01/08/2021',\n",
              "  'Name': 'Perk',\n",
              "  'Price': 5,\n",
              "  'Quantity': 190},\n",
              " '1040': {'Discount': 0,\n",
              "  'Expiry Date': '27/12/2021',\n",
              "  'Manufacturing Date': '27/07/2021',\n",
              "  'Name': 'Perk',\n",
              "  'Price': 10,\n",
              "  'Quantity': 200},\n",
              " '1041': {'Discount': 1,\n",
              "  'Expiry Date': '02/12/2021',\n",
              "  'Manufacturing Date': '02/09/2021',\n",
              "  'Name': 'Perk',\n",
              "  'Price': 20,\n",
              "  'Quantity': 250},\n",
              " '1042': {'Discount': 0,\n",
              "  'Expiry Date': '16/12/2021',\n",
              "  'Manufacturing Date': '16/08/2021',\n",
              "  'Name': 'Perk',\n",
              "  'Price': 80,\n",
              "  'Quantity': 160},\n",
              " '1043': {'Discount': 0,\n",
              "  'Expiry Date': '05/12/2021',\n",
              "  'Manufacturing Date': '05/08/2021',\n",
              "  'Name': '5 Star',\n",
              "  'Price': 10,\n",
              "  'Quantity': 135},\n",
              " '1044': {'Discount': 0,\n",
              "  'Expiry Date': '23/12/2021',\n",
              "  'Manufacturing Date': '23/07/2021',\n",
              "  'Name': '5 Star',\n",
              "  'Price': 20,\n",
              "  'Quantity': 185},\n",
              " '1045': {'Discount': 0,\n",
              "  'Expiry Date': '26/12/2021',\n",
              "  'Manufacturing Date': '26/06/2021',\n",
              "  'Name': '5 Star',\n",
              "  'Price': 80,\n",
              "  'Quantity': 190},\n",
              " '1046': {'Discount': 1,\n",
              "  'Expiry Date': '03/12/2021',\n",
              "  'Manufacturing Date': '03/09/2021',\n",
              "  'Name': 'Munch',\n",
              "  'Price': 5,\n",
              "  'Quantity': 400},\n",
              " '1047': {'Discount': 0,\n",
              "  'Expiry Date': '01/12/2021',\n",
              "  'Manufacturing Date': '01/09/2021',\n",
              "  'Name': 'Munch',\n",
              "  'Price': 10,\n",
              "  'Quantity': 500},\n",
              " '1048': {'Discount': 0,\n",
              "  'Expiry Date': '12/12/2021',\n",
              "  'Manufacturing Date': '12/08/2021',\n",
              "  'Name': 'Munch',\n",
              "  'Price': 20,\n",
              "  'Quantity': 230},\n",
              " '1049': {'Discount': 0,\n",
              "  'Expiry Date': '01/12/2021',\n",
              "  'Manufacturing Date': '01/09/2021',\n",
              "  'Name': 'Munch',\n",
              "  'Price': 80,\n",
              "  'Quantity': 120},\n",
              " '1050': {'Discount': 2,\n",
              "  'Expiry Date': '01/12/2021',\n",
              "  'Manufacturing Date': '01/08/2021',\n",
              "  'Name': 'Perk',\n",
              "  'Price': 5,\n",
              "  'Quantity': 110},\n",
              " '1051': {'Discount': 0,\n",
              "  'Expiry Date': '27/12/2021',\n",
              "  'Manufacturing Date': '27/07/2021',\n",
              "  'Name': 'Perk',\n",
              "  'Price': 10,\n",
              "  'Quantity': 120}}"
            ]
          },
          "metadata": {},
          "execution_count": 29
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "1KWObdy0D7Nt"
      },
      "source": [
        "**Purchasing The Product**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Bsotx9Ijzjco",
        "outputId": "2139bcbb-f692-41e2-f45d-25e0cdccc940"
      },
      "source": [
        "prodID=str(input(\"Enter the Product - Id= \"))\n",
        "quantity=int(input(\"Enter the Quantity= \"))\n",
        "\n",
        "if(quantity<records[prodID]['Quantity']):\n",
        "  print(\"*****************************\")\n",
        "  print(\"Hey, Welcome!! \\nYou Chose--\\n\")\n",
        "  print(\"Product ID= \",prodID)\n",
        "  print(\"Product Name= \", records[prodID]['Name'])\n",
        "  print(\"Product Amount= \", records[prodID]['Price'])\n",
        "  print(\"Manufacturing Date= \", records[prodID]['Manufacturing Date'])\n",
        "  print(\"Expiry Date= \", records[prodID]['Expiry Date'])\n",
        "  print(\"Available Quantities= \",records[prodID]['Quantity'])\n",
        "  print(\"Discount= \",str(records[prodID]['Discount']) + \" %\")\n",
        "  print(\"****************************\\n\")\n",
        "  totalDis=int(records[prodID]['Discount'])*quantity\n",
        "  dis=totalDis*int(records[prodID]['Price'])*quantity*0.01\n",
        "  print(\"Amount= \",(records[prodID]['Price'])*quantity)\n",
        "  print(\"Total Discount you got= \",str(quantity*int(records[prodID]['Discount'])) + \" %\")\n",
        "  print(\"Discount Amount= \",dis)\n",
        "  print(\"****************************\")\n",
        "  print(\"\\nTotal Amount to be paid= \", str(records[prodID]['Price']*quantity-dis)  + \" /-\")\n",
        "\n",
        "  records[prodID]['Quantity'] = records[prodID]['Quantity']-quantity\n",
        "else:\n",
        "  print(\"*****************************\")\n",
        "  print(\"Hey, Welcome!! \\nYou Chose--\\n\")\n",
        "  print(\"Product ID= \",prodID)\n",
        "  print(\"Product Name= \", records[prodID]['Name'])\n",
        "  print(\"Product Amount= \", records[prodID]['Price'])\n",
        "  print(\"Manufacturing Date= \", records[prodID]['Manufacturing Date'])\n",
        "  print(\"Expiry Date= \", records[prodID]['Expiry Date'])\n",
        "  print(\"Available Quantities= \",records[prodID]['Quantity'])\n",
        "  print(\"Discount= \",str(records[prodID]['Discount']) + \" %\")\n",
        "  print(\"******************************\\n\")\n",
        "  print(\"OOps, no sufficient quantities of the selected item are available.\")"
      ],
      "execution_count": 78,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Enter the Product - Id= 1051\n",
            "Enter the Quantity= 12\n",
            "*****************************\n",
            "Hey, Welcome!! \n",
            "You Chose--\n",
            "\n",
            "Product ID=  1051\n",
            "Product Name=  Perk\n",
            "Product Amount=  10\n",
            "Manufacturing Date=  27/07/2021\n",
            "Expiry Date=  27/12/2021\n",
            "Available Quantities=  120\n",
            "Discount=  0 %\n",
            "****************************\n",
            "\n",
            "Amount=  120\n",
            "Total Discount you got=  0 %\n",
            "Discount Amount=  0.0\n",
            "****************************\n",
            "\n",
            "Total Amount to be paid=  120.0 /-\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "dPCqHYNrD-Yn"
      },
      "source": [
        "**Updating the Recod.json File**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "jvAOmrqS0l_A"
      },
      "source": [
        "js=json.dumps(records)\n",
        "fd=open(\"record.json\",'w')\n",
        "fd.write(js)\n",
        "fd.close()"
      ],
      "execution_count": 79,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "RLUYhKVdECYA"
      },
      "source": [
        "**Creating Sales.json File for storing the Sales Data.**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "QURJrSXf0m1r"
      },
      "source": [
        "fd=open(\"sales.json\",'r')\n",
        "data=fd.read()\n",
        "sales=json.loads(data)\n",
        "sales[prodID]={\"Details\" : {'Product ID' : prodID, 'Name':records[prodID]['Name'], 'Quantity' : quantity, 'Discount': records[prodID]['Discount'], 'Amount': records[prodID]['Price']*quantity-dis}}\n",
        "\n",
        "js = json.dumps(sales)\n",
        "fd = open(\"sales.json\",'w')\n",
        "fd.write(js)\n",
        "fd.close()"
      ],
      "execution_count": 80,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "noKeGIn00nJj"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}