demo-RAG-deployment.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "2e659194",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a90f0564",
   "metadata": {},
   "source": [
    "# **<h1 align =\"left\"><b>Find similar clothing items</b></h1>**\n",
    "### **<h1 align =\"left\"><b>Generate Embeddings& Qdrant Vector Database</b></h1>**"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "93c9ef41",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "7cc09778",
   "metadata": {},
   "outputs": [],
   "source": [
    "#tensorflow conda\n",
    "import ocifs\n",
    "import numpy as np\n",
    "import torch\n",
    "import pandas as pd\n",
    "import whisper\n",
    "import json\n",
    "\n",
    "from tqdm.notebook import tqdm\n",
    "#from sentence_transformers import SentenceTransformer\n",
    "import pickle\n",
    "import ffmpeg\n",
    "import ocifs\n",
    "from json import loads, dumps\n",
    "#from qdrant_client import models, QdrantClient\n",
    "DEVICE = \"cuda\" if torch.cuda.is_available() else \"cpu\"\n",
    "\n",
    "import glob\n",
    "from moviepy.video.io.ffmpeg_tools import ffmpeg_extract_subclip\n",
    "import os\n",
    "import gradio as gr"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5dadbb89",
   "metadata": {},
   "source": [
    "## **Start Ilias**"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e0244e62",
   "metadata": {},
   "source": [
    "## **1 Create embeddings and push results to Vector Database**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "bf9ed178",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MODULE</th>\n",
       "      <th>SCREEN</th>\n",
       "      <th>QUESTION</th>\n",
       "      <th>ANSWER</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Configuration</td>\n",
       "      <td>AFUNC</td>\n",
       "      <td>How can I define the attributes or specificati...</td>\n",
       "      <td>The attributes that define the functionality o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Configuration</td>\n",
       "      <td>AFUNC</td>\n",
       "      <td>How can I define an alternative function?</td>\n",
       "      <td>You can define the use of a function for more ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Configuration</td>\n",
       "      <td>AFUNC</td>\n",
       "      <td>How can I assign a function to a non-serialize...</td>\n",
       "      <td>The Function-NSN relationship is configured on...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Configuration</td>\n",
       "      <td>AFUNC</td>\n",
       "      <td>Where can I define the different operational s...</td>\n",
       "      <td>The different operational statuses applicable ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Configuration</td>\n",
       "      <td>AFUNC</td>\n",
       "      <td>How can I determine the different abilities ap...</td>\n",
       "      <td>The different abilities applicable to the asse...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          MODULE SCREEN                                          QUESTION   \\\n",
       "0  Configuration  AFUNC  How can I define the attributes or specificati...   \n",
       "1  Configuration  AFUNC          How can I define an alternative function?   \n",
       "2  Configuration  AFUNC  How can I assign a function to a non-serialize...   \n",
       "3  Configuration  AFUNC  Where can I define the different operational s...   \n",
       "4  Configuration  AFUNC  How can I determine the different abilities ap...   \n",
       "\n",
       "                                              ANSWER  \n",
       "0  The attributes that define the functionality o...  \n",
       "1  You can define the use of a function for more ...  \n",
       "2  The Function-NSN relationship is configured on...  \n",
       "3  The different operational statuses applicable ...  \n",
       "4  The different abilities applicable to the asse...  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#load data\n",
    "dfx = pd.read_excel(\"./Q&A.xlsx\")\n",
    "dfx.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "39b01e7a",
   "metadata": {},
   "outputs": [],
   "source": [
    "#format to what Qdrant expects\n",
    "texts = dfx.to_json(orient='records')\n",
    "documents = loads(texts)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "da8b758a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'MODULE': 'Configuration',\n",
       "  'SCREEN': 'AFUNC',\n",
       "  'QUESTION ': 'How can I define the attributes or specifications of a function?',\n",
       "  'ANSWER': 'The attributes that define the functionality of a material are defined in the AFUNC screen, Tabpage Function, attributes frame.'},\n",
       " {'MODULE': 'Configuration',\n",
       "  'SCREEN': 'AFUNC',\n",
       "  'QUESTION ': 'How can I define an alternative function?',\n",
       "  'ANSWER': 'You can define the use of a function for more than one configuration tree on the AFUNC screen, Alternates tabpage.'},\n",
       " {'MODULE': 'Configuration',\n",
       "  'SCREEN': 'AFUNC',\n",
       "  'QUESTION ': 'How can I assign a function to a non-serialized NSN?',\n",
       "  'ANSWER': 'The Function-NSN relationship is configured on the AFUNC screen, Tabpage related part.'}]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#show some recorrdcs\n",
    "documents[0:3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a98cf2ab",
   "metadata": {},
   "outputs": [],
   "source": [
    "#embedding generator\n",
    "from sentence_transformers import SentenceTransformer\n",
    "encoder = SentenceTransformer('multi-qa-distilbert-cos-v1') # Model to create embeddings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "efa9487b",
   "metadata": {},
   "outputs": [],
   "source": [
    "#example of the format it should have\n",
    "\n",
    "# documents = [\n",
    "#   { \"name\": \"The Time Machine\", \"description\": \"A man travels through time and witnesses the evolution of humanity.\", \"author\": \"H.G. Wells\", \"year\": 1895 },\n",
    "#   { \"name\": \"Ender's Game\", \"description\": \"A young boy is trained to become a military leader in a war against an alien race.\", \"author\": \"Orson Scott Card\", \"year\": 1985 },\n",
    "#   { \"name\": \"Brave New World\", \"description\": \"A dystopian society where people are genetically engineered and conditioned to conform to a strict social hierarchy.\", \"author\": \"Aldous Huxley\", \"year\": 1932 }\n",
    "# ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "42682797",
   "metadata": {},
   "outputs": [],
   "source": [
    "#establish connection to Qdrant vector database\n",
    "from qdrant_client import QdrantClient\n",
    "from qdrant_client.models import Distance, VectorParams\n",
    "from qdrant_client import AsyncQdrantClient, models\n",
    "\n",
    "qdrant = QdrantClient(\"207.211.188.211\", port=6333) # \n",
    "\n",
    "# Create collection to store\n",
    "qdrant.recreate_collection(\n",
    "    collection_name=\"collection_v3\",\n",
    "    vectors_config=models.VectorParams(\n",
    "        size=encoder.get_sentence_embedding_dimension(), # Vector size is defined by used model\n",
    "        distance=models.Distance.COSINE\n",
    "    )\n",
    ")\n",
    "\n",
    "\n",
    "# vectorize descriptions and upload to qdrant\n",
    "qdrant.upload_records(\n",
    "    collection_name=\"collection_v3\",\n",
    "    records=[\n",
    "        models.Record(\n",
    "            id=idx,\n",
    "            vector=encoder.encode(doc[\"QUESTION \"]).tolist(),\n",
    "            payload=doc\n",
    "        ) for idx, doc in enumerate(documents)\n",
    "    ]\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dcef0b03",
   "metadata": {},
   "source": [
    "## **2 Query the Vector Database**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "27859bd9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "---- Result ---- 1\n",
      "Module = Operations\n",
      "Screen = AMISFU\n",
      "Answer = In the screen AINSTR you can installe and remove assets from a configuration tree.\n",
      "Question = How can I remove assets from a configuration tree?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 2\n",
      "Module = Operations\n",
      "Screen = AMISFU\n",
      "Answer = The essential functions for a configuration tree are defined in the AFTREE screen, Function frame, Ess Qty. Field.\n",
      "Question = How are the functions that are essential in a configuration tree defined?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 3\n",
      "Module = Operations\n",
      "Screen = AMISFU\n",
      "Answer = You will not be able to count on information to discriminate between an asset with full operational capacity from another that could be limited due to a lack of essential components.\n",
      "Question = What if the essential functions are not defined in a configuration tree?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 4\n",
      "Module = Configuration\n",
      "Screen = AFTREE\n",
      "Answer = If the configuration tree is not defined, it will not be possible to install and remove components belonging to the system, so you will not be able to know its theoretical composition either.\n",
      "Question = What if the hierarchical order of the functions belonging to a system (configuration tree) is not defined?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 5\n",
      "Module = Operations\n",
      "Screen = AMISFU\n",
      "Answer = To know the essential functions missing in the configuration tree of an asset, you must enter the ASSETA screen, more options, and select the AMISFU – Function of an Asset not Fullfilled option, or you can enter the AOSAC screen, more options, and select the option AMISFU - Function of an Asset not Fullfilled.\n",
      "Question = How to find the essential functions that are missing in the configuration tree of an Asset?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 6\n",
      "Module = Operations\n",
      "Screen = AMISFU\n",
      "Answer = To know all functions missing in the configuration tree of an asset, you must enter the ASSETA screen, more options, and select the AMISFU – Function of an Asset not Fullfilled option, Radio button All functions, or you can enter the AOSAC screen, more options, and select the option AMISFU - Function of an Asset not Fullfilled.\n",
      "Question = How to find the all functions that are missing in the configuration tree of an Asset?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 7\n",
      "Module = Configuration\n",
      "Screen = ASSETA\n",
      "Answer = Enter the ASSETA screen, execute a query by the parent or top asset that you want to \t\tknow, go to ‘Tree’ Tab, and display the list of components of the configuration tree. Another \toption is LASSET or ALASSET screens.\n",
      "Question = How can I find the real component installed in the configuration tree of an Asset?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 8\n",
      "Module = Configuration\n",
      "Screen = AFTREE\n",
      "Answer = The maximum quantity of a function that you can install in a function is configured in the AFTREE screen, Function frame, Max.Qty field.\n",
      "Question = How do you determine the maximum number of assets on a function that can be installed in a configuration tree?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 9\n",
      "Module = System\n",
      "Screen = LORG\n",
      "Answer = First, in the screen MORGDA, disactivate the organization. Then, for a MRC delete in LORG, for a store delete in STORED. A parent organization can only be deleted in LORG  if the child organizations are deleted.\n",
      "Question = How can I deleted a organization from my organization tree?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 10\n",
      "Module = Operations\n",
      "Screen = OPSCOM\n",
      "Answer = You can configure the valid codes to define the operational configuration of an asset in the OPSCOM screen, in the frames Position and codes for position.\n",
      "Question = How can I configure the valid codes to define the operational configuration of an asset?\n",
      "----------------\n",
      "\n"
     ]
    }
   ],
   "source": [
    "## example Search on a sentence\n",
    "hits = qdrant.search(\n",
    "    collection_name=\"collection_v3\",\n",
    "    query_vector=encoder.encode(\"I want to change the configuration tree\").tolist(),\n",
    "    limit=10\n",
    ")\n",
    "\n",
    "list_of_answers = []\n",
    "\n",
    "x = 1\n",
    "for hit in hits:\n",
    "    #print(hit.payload, \"score:\", hit.score)\n",
    "    print(\"---- Result ---- \" + str(x))\n",
    "    output = hit.payload\n",
    "    module = output['MODULE']\n",
    "    screen = output['SCREEN']\n",
    "    answer = output['ANSWER']\n",
    "    question = output['QUESTION ']\n",
    "    \n",
    "    print(\"Module = \" + module)\n",
    "    print(\"Screen = \" + screen)\n",
    "    print(\"Answer = \" + answer)\n",
    "    print(\"Question = \" + question)\n",
    "    print(\"----------------\")\n",
    "    print()\n",
    "    \n",
    "    list_of_answers.append(answer)\n",
    "    \n",
    "    x += 1\n",
    "    "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8484b000",
   "metadata": {},
   "source": [
    "----"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3339e8c8",
   "metadata": {},
   "source": [
    "## **3  Define GenAI**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "5add57ee",
   "metadata": {},
   "outputs": [],
   "source": [
    "import oci \n",
    "\n",
    "compartment_id = \"ocid1.compartment.oc1..aaaaaaaae3n6r6hrjipbap2hojicrsvkzatrtlwvsyrpyjd7wjnw4za3m75q\"\n",
    "CONFIG_PROFILE = \"DEFAULT\"\n",
    "config = oci.config.from_file('~/.oci/config', CONFIG_PROFILE)\n",
    "\n",
    "\n",
    "def predict_genai(input_text):\n",
    "\n",
    "    # Service endpoint\n",
    "    endpoint = \"https://generativeai.aiservice.us-chicago-1.oci.oraclecloud.com\"\n",
    "\n",
    "    generative_ai_client = oci.generative_ai.GenerativeAiClient(config=config, service_endpoint=endpoint, retry_strategy=oci.retry.NoneRetryStrategy(), timeout=(10,240))\n",
    "\n",
    "    prompts = [input_text]\n",
    "    generate_text_detail = oci.generative_ai.models.GenerateTextDetails()\n",
    "    generate_text_detail.prompts = prompts\n",
    "    generate_text_detail.serving_mode = oci.generative_ai.models.OnDemandServingMode(model_id=\"cohere.command\")\n",
    "    # generate_text_detail.serving_mode = oci.generative_ai.models.DedicatedServingMode(endpoint_id=\"custom-model-endpoint\") # for custom model from Dedicated AI Cluster\n",
    "    generate_text_detail.compartment_id = compartment_id\n",
    "    generate_text_detail.max_tokens = 400\n",
    "    generate_text_detail.temperature = 0.75\n",
    "    generate_text_detail.frequency_penalty = 1.0\n",
    "    generate_text_detail.top_p = 0.7\n",
    "\n",
    "    generate_text_response = generative_ai_client.generate_text(generate_text_detail)\n",
    "\n",
    "    # Print result\n",
    "    print(\"**************************Generate Texts Result**************************\")\n",
    "    #print(generate_text_response.data)\n",
    "    print(\"Response from GenAI = \" + generate_text_response.data.generated_texts[0][0].text)\n",
    "    output_text = generate_text_response.data.generated_texts[0][0].text\n",
    "\n",
    "    return output_text"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e2e026d8",
   "metadata": {},
   "source": [
    "## **4 Function to get Vector response and apply GenAI**"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0bb3ecfe",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "ed829fcb",
   "metadata": {},
   "outputs": [],
   "source": [
    "from qdrant_client import QdrantClient\n",
    "from qdrant_client.models import Distance, VectorParams\n",
    "from qdrant_client import AsyncQdrantClient, models\n",
    "\n",
    "def function_2(question):\n",
    "    \n",
    "    qdrant = QdrantClient(\"207.211.188.211\", port=6333) # \n",
    "    \n",
    "    from sentence_transformers import SentenceTransformer\n",
    "    encoder = SentenceTransformer('multi-qa-distilbert-cos-v1') # Model to create embeddings\n",
    "    \n",
    "    ## example Search on a sentence\n",
    "    hits = qdrant.search(\n",
    "        collection_name=\"collection_v3\",\n",
    "        query_vector=encoder.encode(question).tolist(),\n",
    "        limit=10\n",
    "    )\n",
    "    \n",
    "    #del list_of_answers\n",
    "    list_of_answers = []\n",
    "\n",
    "    x = 1\n",
    "    for hit in hits:\n",
    "        #print(hit.payload, \"score:\", hit.score)\n",
    "        print(\"---- Result ---- \" + str(x))\n",
    "        output = hit.payload\n",
    "        module = output['MODULE']\n",
    "        screen = output['SCREEN']\n",
    "        answer = output['ANSWER']\n",
    "        questionx = output['QUESTION ']\n",
    "\n",
    "        print(\"Module = \" + module)\n",
    "        print(\"Screen = \" + screen)\n",
    "        print(\"Answer = \" + answer)\n",
    "        print(\"Question = \" + questionx)\n",
    "        print(\"----------------\")\n",
    "        print()\n",
    "\n",
    "        list_of_answers.append(answer)\n",
    "\n",
    "        x += 1\n",
    "    \n",
    "    input_text = \"Answer the following question: \" + question + \". Base your answer on the following list of information \" + str(list_of_answers)\n",
    "    print(input_text)\n",
    "    \n",
    "    #apply Genai to list of answers + to answer the original question\n",
    "    output_text = predict_genai(input_text)\n",
    "        \n",
    "    return list_of_answers, output_text\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "85c999f7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "---- Result ---- 1\n",
      "Module = Purchasing\n",
      "Screen = SREQ\n",
      "Answer = When a material request is defined as ‘type need - PRIO’, the status of the requisition can only be changed to status ‘A – APPROVED’  by someone at the ‘Prio Authorization level’ of that store, defined in STORED or by the Material Manager. \n",
      "Question = What if I use Type need ‘PRIO’ in SREQ?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 2\n",
      "Module = Purchasing\n",
      "Screen = SREQ\n",
      "Answer = When the external requisition is approved, the ‘Generate RFQ` button will be able, and \tyou can push this button to create an automatic request for quotation that you can then \t\tmanage on the PRFQ screen.\n",
      "Question = How can I create a request for quotation from SREQ screen?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 3\n",
      "Module = Purchasing\n",
      "Screen = PORD\n",
      "Answer = In ILIAS application, you can define the responsibility of the importers in the arrangement of material shipments in a purchase order in the screen PORD, tab ‘General’, frame ‘Incoterm’.\n",
      "Question = Where can I define the International commercial terms (incoterm) in a purchase order?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 4\n",
      "Module = Purchasing\n",
      "Screen = SREQ\n",
      "Answer = First of all, the status of the material request in SREQ screen must be in ‘A – APPROVED ’ status, based on a contract (field contract) and with an imputation line assigned. These previous steps will activate the button ‘Generate order’, pressing this button a purchase order will be automatically created (PORD in status ‘U’) for the material requested in the requisition.\n",
      "Question = How can I create a purchase order from a SREQ?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 5\n",
      "Module = Purchasing\n",
      "Screen = SCOM\n",
      "Answer = Enter to SCOM page, and go to Tab Page ‘’Company List’’, the user can get basic information about the companies such as the company code, the company name, the phone number, the VAT fields, Enterprise number and the country code. Adittionally if the companies are active, a supplier, a manufacturer, a carrier, a buyer, a NATO company and/or a course company.\n",
      "Question = Where can I find all suppliers registered in ILIAS aplication?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 6\n",
      "Module = System\n",
      "Screen = MPROT\n",
      "Answer = Enter the MPROT screen, navigate to the configuration tabpage, frame ‘What can be configured?’, select the Business Rule option in the Property column, and run a query.\n",
      "Question = Where can I find the ILIAS business rules?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 7\n",
      "Module = Purchasing\n",
      "Screen = PCOIN\n",
      "Answer = You can find the authority (Organization) that can approve the contract in PCOIN screen, frame ‘Authority’. It should be noted that, the Procurement Office profile is defined by LORG Screen.\n",
      "Question = Where can I find the authority (Organization) who can approve the contract in PCOIN?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 8\n",
      "Module = Deployment and Mobility\n",
      "Screen = TRCOLL\n",
      "Answer = Enter to TRCOLL, execute a query for the SSCC that you want to print, go to ‘Main’ tab, \tand click on ‘Print Shipment’ button, in ‘location’ frame. \n",
      "Question = How can I print the shipment report of the a SSCC?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 9\n",
      "Module = Purchasing\n",
      "Screen = SREQ\n",
      "Answer = Enter the SREQ screen, execute a query by the requisition that you want to know, click on Tab Items, select the item that you want to know. Then \tnavegate to ‘Receipts’ Tab. If the material was received, you can find information in ‘Receipts’ frame.\n",
      "Question = How can I know if a material requested in a requisition was received?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 10\n",
      "Module = Purchasing\n",
      "Screen = PCOIN\n",
      "Answer = Enter to PCORG screen and execute a query by your organization in Leading Functionaries column.\n",
      "Question = How can I find back a contract assigned to my organization?\n",
      "----------------\n",
      "\n",
      "Answer the following question: QUSTIONOIOJO. Base your answer on the following list of information ['When a material request is defined as ‘type need - PRIO’, the status of the requisition can only be changed to status ‘A – APPROVED’  by someone at the ‘Prio Authorization level’ of that store, defined in STORED or by the Material Manager. ', 'When the external requisition is approved, the ‘Generate RFQ` button will be able, and \\tyou can push this button to create an automatic request for quotation that you can then \\t\\tmanage on the PRFQ screen.', 'In ILIAS application, you can define the responsibility of the importers in the arrangement of material shipments in a purchase order in the screen PORD, tab ‘General’, frame ‘Incoterm’.', 'First of all, the status of the material request in SREQ screen must be in ‘A – APPROVED ’ status, based on a contract (field contract) and with an imputation line assigned. These previous steps will activate the button ‘Generate order’, pressing this button a purchase order will be automatically created (PORD in status ‘U’) for the material requested in the requisition.', 'Enter to SCOM page, and go to Tab Page ‘’Company List’’, the user can get basic information about the companies such as the company code, the company name, the phone number, the VAT fields, Enterprise number and the country code. Adittionally if the companies are active, a supplier, a manufacturer, a carrier, a buyer, a NATO company and/or a course company.', 'Enter the MPROT screen, navigate to the configuration tabpage, frame ‘What can be configured?’, select the Business Rule option in the Property column, and run a query.', 'You can find the authority (Organization) that can approve the contract in PCOIN screen, frame ‘Authority’. It should be noted that, the Procurement Office profile is defined by LORG Screen.', 'Enter to TRCOLL, execute a query for the SSCC that you want to print, go to ‘Main’ tab, \\tand click on ‘Print Shipment’ button, in ‘location’ frame. ', 'Enter the SREQ screen, execute a query by the requisition that you want to know, click on Tab Items, select the item that you want to know. Then \\tnavegate to ‘Receipts’ Tab. If the material was received, you can find information in ‘Receipts’ frame.', 'Enter to PCORG screen and execute a query by your organization in Leading Functionaries column.']\n",
      "**************************Generate Texts Result**************************\n",
      "Response from GenAI =  Purchase Order\n"
     ]
    }
   ],
   "source": [
    "list_of_answers, output_text= function_2(\"QUSTIONOIOJO\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "ca47d572",
   "metadata": {},
   "outputs": [],
   "source": [
    "## question\n",
    "# I want to change the value of the counter, please help me\n",
    "#I want to view the ability status of all my assets i'm responsible for. how do I do that?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "50b7b754",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Running on local URL:  http://127.0.0.1:7860\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "huggingface/tokenizers: The current process just got forked, after parallelism has already been used. Disabling parallelism to avoid deadlocks...\n",
      "To disable this warning, you can either:\n",
      "\t- Avoid using `tokenizers` before the fork if possible\n",
      "\t- Explicitly set the environment variable TOKENIZERS_PARALLELISM=(true | false)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Running on public URL: https://b804f15d3174f1fc18.gradio.live\n",
      "\n",
      "This share link expires in 72 hours. For free permanent hosting and GPU upgrades, run `gradio deploy` from Terminal to deploy to Spaces (https://huggingface.co/spaces)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div><iframe src=\"https://b804f15d3174f1fc18.gradio.live\" width=\"100%\" height=\"500\" allow=\"autoplay; camera; microphone; clipboard-read; clipboard-write;\" frameborder=\"0\" allowfullscreen></iframe></div>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "---- Result ---- 1\n",
      "Module = Material Management\n",
      "Screen = SMET\n",
      "Answer = In the SMET screen, field Minimum and Maximum you can limit the value of a counter. As well as you can also limit the maximum deviation (variation) of a counter.\n",
      "Question = How can I limit the value of a counter?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 2\n",
      "Module = Configuration\n",
      "Screen = ASSETA\n",
      "Answer = The counters of an Asset can be corrected on WREADD screen, filling the necessary \t\tinformation in the ‘Reading Characteristics’ and ‘List of counters for the Asset’ Frames. \n",
      "Question = Where can I correct the value of an Asset counter?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 3\n",
      "Module = Material Management\n",
      "Screen = SMET\n",
      "Answer = The counters are associated in the SMET screen through a common NSN for a group of assets that share said NSN.\n",
      "Question = How can I associate a counter to an asset?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 4\n",
      "Module = Configuration\n",
      "Screen = ASSETA\n",
      "Answer = The counter new values of an Asset are recorded in WREAD screen, filling the necessary \tinformation in the ‘Reading Characteristics’ and ‘List of counters Valid for the Asset’ Frames. \tIt should be noted that there are counters that are updated automatically according to the \tregular operation of the Asset (Aircraft counters that are updated by WPREST screen) or are \tupdated with an external source of information (Data loads by MLOAD screen).\n",
      "Question = Where can I register a new value on an Asset counter?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 5\n",
      "Module = Configuration\n",
      "Screen = ASSETA\n",
      "Answer = Enter the ASSETA screen and go to ‘Counter’ Tab.\n",
      "Question = Where can I find the counter associated with an Asset?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 6\n",
      "Module = Material Management\n",
      "Screen = SMET\n",
      "Answer = If you want to make usage plans (budget planning) for a system on the APBUD screen, you have to check the 'master' checkbox on the SMET screen for the NSN of the system you want to plan.\n",
      "Question = How do I define the counter that will be used for usage planning of a (weapon) system?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 7\n",
      "Module = System\n",
      "Screen = LORG\n",
      "Answer = rything is adaptable in LORG except the unit Type (O,S and M).\n",
      "Question = What if I need to change data in LORG?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 8\n",
      "Module = Material Management\n",
      "Screen = SMET\n",
      "Answer = In the case of aircraft, if you do not define the counters of an asset group, you will not be able to schedule or debrief the flights on the WPREST screen. For the rest of the assets, you will not be able to enter or control the entry of relevant counters, such as kilometer, hours of operation or fuel consumption.\n",
      "Question = What if I don't associate counters to an asset?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 9\n",
      "Module = Maintenance\n",
      "Screen = WORK\n",
      "Answer = To change the status of a work order, you must enter the WORK screen, execute a query for the work order you want to modify, navigate in the Work Order tabpage and complete at least the fields that are mandatory. Then you can make the change in the Workorder frame, Status field.\n",
      "Question = How can I change the status of a work order?\n",
      "----------------\n",
      "\n",
      "---- Result ---- 10\n",
      "Module = Purchasing\n",
      "Screen = PCOIN\n",
      "Answer = Is possible to change the budget details, going to PCOIN screen and changing the Contract’s Status from Approved (A) to Status Budgetary Changes (G), then go to Tab Page “Budget”.\n",
      "Question = How can I change the Budgets details when the Contract has already approved?\n",
      "----------------\n",
      "\n",
      "Answer the following question: I want to change the value of the counter, please help me. Base your answer on the following list of information ['In the SMET screen, field Minimum and Maximum you can limit the value of a counter. As well as you can also limit the maximum deviation (variation) of a counter.', 'The counters of an Asset can be corrected on WREADD screen, filling the necessary \\t\\tinformation in the ‘Reading Characteristics’ and ‘List of counters for the Asset’ Frames. ', 'The counters are associated in the SMET screen through a common NSN for a group of assets that share said NSN.', 'The counter new values of an Asset are recorded in WREAD screen, filling the necessary \\tinformation in the ‘Reading Characteristics’ and ‘List of counters Valid for the Asset’ Frames. \\tIt should be noted that there are counters that are updated automatically according to the \\tregular operation of the Asset (Aircraft counters that are updated by WPREST screen) or are \\tupdated with an external source of information (Data loads by MLOAD screen).', 'Enter the ASSETA screen and go to ‘Counter’ Tab.', \"If you want to make usage plans (budget planning) for a system on the APBUD screen, you have to check the 'master' checkbox on the SMET screen for the NSN of the system you want to plan.\", 'rything is adaptable in LORG except the unit Type (O,S and M).', 'In the case of aircraft, if you do not define the counters of an asset group, you will not be able to schedule or debrief the flights on the WPREST screen. For the rest of the assets, you will not be able to enter or control the entry of relevant counters, such as kilometer, hours of operation or fuel consumption.', 'To change the status of a work order, you must enter the WORK screen, execute a query for the work order you want to modify, navigate in the Work Order tabpage and complete at least the fields that are mandatory. Then you can make the change in the Workorder frame, Status field.', 'Is possible to change the budget details, going to PCOIN screen and changing the Contract’s Status from Approved (A) to Status Budgetary Changes (G), then go to Tab Page “Budget”.']\n",
      "**************************Generate Texts Result**************************\n",
      "Response from GenAI =  The answer is To change the value of a counter, you can do it on the SMET screen, selecting the counter and changing its minimum and maximum values.\n",
      "You can also do it on the WREADD screen, filling the necessary information in the ‘Reading Characteristics’ and ‘List of counters for the Asset’ Frames.\n",
      "You can also do it on the WPREST screen, by selecting the asset and changing its counters.\n",
      "You can also do it on the MLOAD screen, by selecting the asset and changing its counters with an external source of information.\n",
      "You can also do it on the ASSETA screen, by going to the ‘Counter’ Tab and selecting the counter you want to change.\n",
      "You can also do it on the PCOIN screen, by changing the Contract’s Status from Approved (A) to Status Budgetary Changes (G), then go to Tab Page ‘Budget’ and changing the budget details.\n",
      "You can also do it on the WORK screen, by executing a query for the work order you want to modify, navigating in the Work Order tabpage and completing at least the fields that are mandatory. Then you can make the change in the Workorder frame, Status field.\n"
     ]
    }
   ],
   "source": [
    "desc = \"Query Vector Database & Use GenAI\"\n",
    "\n",
    "with gr.Blocks() as demo: \n",
    "\n",
    "    #input \n",
    "    question = gr.Text(label=\"What are you looking for?\")\n",
    "   \n",
    "    #output    \n",
    "    list_of_answers = gr.Text(label=\"Most related Answers based on similar Question\")\n",
    "    output_text = gr.Text(label=\"Full answer\")\n",
    "\n",
    "\n",
    "    submit_btn = gr.Button(\"Search for your question\")\n",
    "\n",
    "\n",
    "gr.Interface(fn=function_2, inputs=question, outputs=[list_of_answers, output_text], title=desc).launch(share=True, debug=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8a73ec49",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ac78cee3",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:tensorflow28_p38_cpu_v1]",
   "language": "python",
   "name": "conda-env-tensorflow28_p38_cpu_v1-py"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}