WO2022058775A2

WO2022058775A2 - Software for ordering products needed for pharmacies from pharmaceutical companies

Info

Publication number: WO2022058775A2
Application number: PCT/IB2020/058752
Authority: WO
Inventors: Morteza EBRAHIMI
Original assignee: Ebrahimi Morteza
Priority date: 2020-09-19
Filing date: 2020-09-19
Publication date: 2022-03-24

Description

Software for ordering products needed for pharmacies from pharmaceutical companies

Description:

FIELD GF THE INVENTION

The present invention relates generally to a Windows software can be installed by pharmacies and pharmaceutical companies by which pharmacies can choose their desired pharmaceutical company and after viewing the details of the products of that pharmaceutical company, they can place the orders from that pharmaceutical company.

BACKGROUND OF THE INVENTION

Technical problems and invention goals:

In the traditional way of ordering drugs, pharmaceutical companies have to send people to pharmacies to get orders, which is a time-consuming and costly task for pharmaceutical companies, but with the software system provided by me, pharmacies will be able to easily buy the drugs and items they needed from pharmaceutical companies.

In the traditional way, pharmacies have to ask for changes in the price and inventory of drugs by phone from pharmaceutical companies, which leads to frequent and tedious phone calls for pharmacists, but with the software system created by me, pharmacies will be able to easily view price changes and changes in inventory of drugs and other items by selecting the desired pharmaceutical company.

In the traditional way, pharmaceutical companies send their agents to pharmacies once or twice a week for a short period of time, and pharmacies have to place their orders in this short period of time, but with the software system created by me. Pharmacies will be able to place their orders 24 hours a day, seven days a week (7/24) whenever they want.

In the traditional way, a number of profiteers (sometimes the company's own staff) buy the drugs at a low price from pharmaceutical companies and sell it on the black market to drug traffickers, which leads to an increase in drug trafficking in the country, but with the implementation of this software, this system will solve this problem because the sales list of pharmaceutical companies will be registered in the system. In fact, with the implementation of this invention, pharmaceutical companies can only sell drugs to pharmacies, and drug trafficking interfaces will be eliminated.

Because this system is an online business, it is more financially transparent, because all transactions are recorded in the system, so the probability of tax evasion is very low, but in the traditional way, due to low financial transparency, there is a possibility of tax evasion.

SUMMARY OF THE INVENTION The general operation of the invention is that by creating a system (Windows software), pharmacies and pharmaceutical companies across the country enter the system and become members of the software system in the "sign up" section; Then they enter the software through the username and password from the "Login" section. After entering their respective panel, pharmacies will see the list of products of the desired pharmaceutical company in a section by selecting the "desired pharmaceutical company", which will select the desired number according to the conditions of the products. The total amount in terms of the amount for the entire order of pharmacies appears that pharmacies can send the order directly to the pharmaceutical company by clicking the "Send Order" button, or by clicking the "Draft" button, save the order as a draft and that Send or delete at any time. Pharmaceutical companies, after entering their respective panels, enter information about their products in the "Products" section and can even edit the information of a product or remove a product from the list, in the "Order Management" section. Also, pharmaceutical companies will have access to orders by paying a fee of one percent (1%) of the total amount of the order (it is not possible to view orders without paying a fee); For example, if a pharmacy has placed an order of five thousand dollars, a fee of fifty dollars will be requested. Also, after paying the commission, the pharmaceutical companies can print the orders in a section called "Output" or save the orders as a PDF file.

BRIEF DESCRIPTION OF THE DRAWINGS

In the annexed drawings:

FIG. 1 is a representative flow chart of the system for pharmacies in accordance with the invention.

FIGS. 2 and 3 are representative flow charts of procedures and steps of the pharmaceutical companies in accordance with the method of the invention.

FIG. 4 is sign up part in which information about the pharmacy or pharmaceutical company is entered.

FIG. 5 is login part in which pharmacies or pharmaceutical companies can log in into their respective page by entering the username and password.

FIG. 6 is pharmaceutical companies list that by clicking on which, pharmacy can choose its desired pharmaceutical company.

FIG. 7 is list of the desired pharmaceutical company’s products that has been chosen by the pharmacy.

FIG. 8 is order management section of pharmacies page in which, pharmacies can save their orders as a draft and send it later.

FIG. 9 is pharmaceutical company’s products section in which, pharmaceutical companies can enter their products details and edit or delete a product from the list.

FIG. 10 is order management section of pharmaceutical companies’ page in which, pharmaceutical companies can pay the one percent commission and view the products details. FIG. 11 is output part of order management section in pharmaceutical companies’ page, pharmaceutical companies can print or save as PDF the orders.

DESCRIPTION OF PREFERRED EMBODIMENT

This software is created in two different pages, one page for pharmacies and one page for pharmaceutical companies. In pharmacies page, after transferring into sign up section 150 and entering your own pharmacy information, you should come back to the log in section 152 and enter your username and password to enter your own respective pharmacy page; in your page by selecting your desired pharmaceutical company 154, you will be able to view the list of products of that pharmaceutical company and by choosing the number of requested of each product 156, you can send your order 158 to the pharmaceutical company or draft your order 160 and send it later or even delete the order 162 (Fig. 1).

In pharmaceutical company page, after transferring into sign up section 164 and entering your own pharmaceutical company information, you should come back to the log in section 166 and enter your username and password to enter your own respective pharmaceutical company page; in your page, by clicking on +, you will be able to enter the details of your pharmaceutical company’s products 168; and you can also edit the details of a product 170 or even delete the product from the list 172 (Fig. 2).

In orders management section of a pharmaceutical company page, you can pay one percent commission of the order 174 and then view the orders 176; by clicking on output icon 178, the pharmaceutical company will be able to print the orders or save them as a PDF file 180 (Fig. 3).

The general layout of the software is that after opening the software, in the software sign up section, information about the pharmacy or pharmaceutical company is entered 12, which includes the following in Fig.4. After entering the information about the pharmacy or pharmaceutical company, by selecting one of the following two options, we specify that we intend to create a page of a pharmacy or a pharmaceutical company (14, Fig. 4). After selecting one of the two options, click on "Sign up" 16 and then click on "Login" 18 to be transferred to the login section of the account. In the login section, we enter the user account by entering the username 20 and password (22, Fig. 5).

After entering the user account (as a pharmacy) in the "New Order" section, by selecting the desired pharmaceutical company, the pharmaceutical company's products will appear, Fig.6.

By selecting the desired pharmaceutical company, the list of items and drugs of the company is displayed. There are several columns in the list of items and goods of the pharmaceutical company:

Column 1, Code: Product code is shown in this section 24, Fig 7.

Column 2, Product Name: In this column, the name of the drug or supplement or cosmetic product or any product purchased by the pharmacy is written. Also, if a discount is applied by the pharmaceutical company for the sale price, it will be displayed as a percentage in parentheses against the name of the product 26.

Column 3, Product Image: Product image is displayed in this section 28.

Column 4, Commodity unit: In this section, the commodity unit is entered, for example, 100 numbers or 28 numbers, etc. Also, the storage conditions of some drugs are included in this section. For example (2-8) degrees Celsius 30.

Column 5, Expiration date and batch number: In this section, the expiration date and batch number of the product are entered 32.

Column 6, Sales price: The price set by the pharmaceutical company for the product (in Rials or dollars) is written in this column. If the price of the product changes, the pharmaceutical company will also be able to change this price from the" Edit " section. And if the pharmaceutical company decides to offer a discount for the product, this discount will be applied to the "sales price" from the edit section and will be shown as a percentage against the name of the product 34.

Column 7, Tax: Product tax is included in this section, which will be a special amount or zero 36.

Column 8, Consumer price: The selling price of the product (in Rials or dollars) in the pharmacy (consumer price) is written in this column. This column can also be changed by the pharmaceutical company 38.

Column 9, Number of inventory: The number of goods in the warehouse of the pharmaceutical company is entered in this section. If the inventory is zero, the number "zero" is displayed in this section, and if the product is available again, a special number (The number of new batch) will be entered by the pharmaceutical company in this section. Also, after selecting the number of requests from a product (for example, 15) and pressing the send order button, the number of requests will be reduced from the number of inventory 40.

Column 10, Product Offer: The product offer is displayed in this section. The offer of a product can have three different modes: 1. The product does not have any offer which is shown as zero or a dash or none. 2. The product has a specific offer, for example (1 to 10), i.e. one offer is given for ten purchases and two offers are given for twenty purchases. 3. The product has a stepped offer, that is, for example, one offer is given for ten purchases and three offers are given for twenty purchases 42.

Column 11 , Settlement period: The period when the pharmacy is obliged to settle the account with the pharmaceutical company by purchasing this product is shown in this column. This settlement period is entered as "days" and after sending orders, the average of settlement period of all products is taken and reported as "average settlement period" 44.

Column 12, Main indication: The main indication of the product is written in this section. For example, milk formula or analgesic 46. Column 13, Requested number: In this column, the requested number of goods is determined by the pharmacy. By entering a specific number, for example <20> or <50> 48.

Column 14, Total price: After selecting the requested number of a product, the total price of the product is shown in the last column, which is calculated as the opposite: (sales price + tax) multiplied by (requested number) = total price 50 (Fig.7).

Finally, after the orders are placed by the pharmacy, a total sum appears in terms of the amount, and the pharmacy sends the order to the desired pharmaceutical company by clicking the "Send Order" button 52, or saves it as a draft and sends it at another time 54 (Fig. 7).

In the "Order Management" section, there are several columns that include the following:

Column 1, Code (Order): The order code sent to a specific pharmaceutical company is displayed in this column 56. column 2, Pharmaceutical company: The name of the pharmaceutical company from which the order is placed is displayed in this column, For example, Mahya Medicine 58.

Column 3, Creation Date: The date the order was created on that day can be seen in this section 60.

Column 4, Delivery Date: The date the order was sent on that day can be seen in this section 62.

Column 5, Average settlement period: The average settlement period of the order registered in this column is shown 64.

Column 6, Total Price: The total price of the registered order is displayed in this section 66.

Column 7, Acceptance by the pharmaceutical company: The status of viewing the order by the pharmaceutical company can be seen in this column 68.

Column 8, Order type: Order type (pre-sent or sent) is shown in this column 70.

Column 9, View: By clicking on the icon of this column, the registered orders are visible 72.

Column 10, Send Draft: Orders that have been saved as drafts can be sent from this section 74.

Column 11, Delete Draft: Orders saved as drafts can be deleted from this section 76 (Fig. 8).

After logging in to the user account (as a pharmaceutical company) by clicking on the icon + 78 the pharmaceutical company will be able to enter the details of its products in different fields, which include the following:

Column 1, Code: Product code is shown in this section 80.

Column 2, Product Name: In this column, the name of the drug or supplement or cosmetic product or any product purchased by the pharmacy is written. Also, if a discount is applied by the pharmaceutical company for the sale price, it will be displayed as a percentage in parentheses against the name of the product 82.

Column 3, Product Image: Product image is displayed in this section 84.

Column 4, Commodity unit: In this section, the commodity unit is entered, for example, 100 numbers or 28 numbers, etc. Also, the storage conditions of some drugs are included in this section. For example (2-8) degrees Celsius 86.

Column 5, Expiration date and batch number: In this section, the expiration date and batch number of the product are entered 88.

Column 6, Sales price: The price set by the pharmaceutical company for the product (in Rials or dollars) is written in this column. If the price of the product changes, the pharmaceutical company will also be able to change this price from the" Edit " section. And if the pharmaceutical company decides to offer a discount for the product, this discount will be applied to the "sales price" from the edit section and will be shown as a percentage against the name of the product 90.

Column 7, Tax: Product tax is included in this section, which will be a special amount or zero 92.

Column 8, Consumer price: The selling price of the product (in Rials or dollars) in the pharmacy (consumer price) is written in this column. This column can also be changed by the pharmaceutical company 94.

Column 9, Number of inventory: The number of goods in the warehouse of the pharmaceutical company is entered in this section. If the inventory is zero, the number "zero" is displayed in this section, and if the product is available again, a special number (The number of new batch) will be entered by the pharmaceutical company in this section. Also, after selecting the number of requests from a product (for example, 15) and pressing the send order button, the number of requests will be reduced from the number of inventory 96.

Column 10, Product Offer: The product offer is displayed in this section. The offer of a product can have three different modes: 1. The product does not have any offer which is shown as zero or a dash or none. 2. The product has a specific offer, for example (1 to 10), i.e. one offer is given for ten purchases and two offers are given for twenty purchases. 3. The product has a stepped offer, that is, for example, one offer is given for ten purchases and three offers are given for twenty purchases 98.

Column 11 , Settlement period: The period when the pharmacy is obliged to settle the account with the pharmaceutical company by purchasing this product is shown in this column. This settlement period is entered as "days" and after sending orders, the average of settlement period of all products is taken and reported as "average settlement period" 100.

Column 12, Main indication: The main indication of the product is written in this section. For example, milk formula or analgesic 102. Column 13, Product edit: Product’s details can be edited in this section 104.

Column 14, Product delete: Product can be deleted from the list in this section 106 (Fig. 9).

In the "Order Management" section of pharmaceutical companies, there are several columns, which include the following:

Column 1, Code: The order code of different pharmacies can be seen in this section 108.

Column 2, Buyer Pharmacy: The name of the buyer pharmacy is displayed in this column 110.

Column 3, Order Date: The date that the pharmacy sent the order on that day is shown in this section 112.

Column 4, Total price: The total price of the order (in Rials or dollars) is displayed in this column 114.

Column 5, Fee for commission: The commission that the pharmaceutical company must pay to view the orders is shown in this column (in Rials or dollars) 116.

Column 6, Payment status: The status of commission payment can be seen in this section 118.

Column 7, Transaction code: In this field, the transaction code will be displayed 120.

Column 8, Payment: The fee payment icon (login to the payment gateway) is displayed in this column 122.

Column 9, Order information: In this section, the order information is shown that the pharmaceutical company, by clicking on its icon, will be faced with the message" Pay the commission to view the order", which after paying the commission from the Payment column (eighth), the information of order will be visible 124.

Column 10, Output: By clicking on the output icon, orders can be saved in PDF format and orders can even be printed 126 (Fig. 10).

In the "Output" section, clicking on the output icon will open a new window where the details of the orders and the details of the pharmacy that placed the order are written which includes the following:

Column 1, Row: The code of product is written in this column 128.

Column 2, Product Name: In this column, the name of the drug or supplement or cosmetic product or any product purchased by the pharmacy is written. Also, if a discount is applied by the pharmaceutical company for the sale price, it will be displayed as a percentage in parentheses against the name of the product 130. Column 3, Sales price: The price set by the pharmaceutical company for the product (in Rials or dollars) is written in this column 132.

Column 4, Tax: Product tax is included in this section, which will be a special amount or zero 134.

Column 5, Consumer price: The selling price of the product (in Rials or dollars) in the pharmacy (consumer price) is written in this column 136.

Column 6, Requested number: In this column, the requested number of goods is determined by the pharmacy. By entering a specific number, for example <20> or <50> 138.

Column 7, Settlement period: The period when the pharmacy is obliged to settle the account with the pharmaceutical company by purchasing this product is shown in this column. This settlement period is entered as "days" and after sending orders, the average of settlement period of all products is taken and reported as "average settlement period" 140.

Column 8, Total price: After selecting the requested number of a product, the total price of the product is shown in the last column, which is calculated as the opposite: (sales price + tax) multiplied by (requested number) = total price 142 (Fig. 11).

"Total cost" 144, "commission" 146 and "average settlement period" 148 are also written in this section. In this section, orders can be printed or saved in PDF format, Fig.11.

Clear and precise expression of software benefits:

The most important advantage of this invention is that pharmacies have access to the list of items and goods of pharmaceutical companies 24 hours a day, seven days a week (7/24) and can place their orders whenever they want, if in the traditional way Representatives of pharmaceutical companies visit the pharmacy once or at most twice a week, and pharmacies have to place their orders at this limited time.

Another advantage of this invention is that pharmacies have to make many contacts with pharmaceutical companies to be aware of changes in the price of goods or the inventory of pharmaceutical items, but with the implementation of this invention, pharmacies by choosing the desired pharmaceutical company can easily be announced from the changes of the prices and inventory of items.

Another advantage of this software is informing about "market deficit drugs", which with the implementation of this invention, there is no need to inform through social networks or phone calls by pharmaceutical companies, and pharmaceutical companies can enter " market deficit drugs and goods" when it is available in their list of goods for pharmacies to view by selecting the relevant pharmaceutical company. Another advantage is the availability and constant viewing of the list of items and goods of the pharmaceutical companies by the pharmacy, which will increase the purchase rate of pharmacies and increase the sales of pharmaceutical companies, which will lead to an increase in the production of pharmaceutical items.

How to implement the software.

This program consists of four sections due to the need to be widely available and available online to users (pharmacies and pharmaceutical companies) in any part of the country.

The first part of this project is implemented using Web Api 2 technology in the web platform, which provides an Api to the program under Windows that can be used to perform the main operations for calling and recording information.

The second part of the project is actually the under Windows client program, which is implemented with #C programming language and WPF technology. The reason for using WPF is the existence of many libraries to create a beautiful and user-friendly graphical environment, as well as the up-to-dateness of this technology.

The third part is the project database, which was created using SQL Server 2012, and all its tables and data were purchased and copied to the host.

The fourth part is a class Library subproject whose output is a DLL file. This section contains classes that define the communication structure between the other sections and its task is to fill the gap that has been created between the previous sections.

All the above sections are coded using Visual Studio 2019 software and .NET Framework 4.5.2.

Program Codes (#C)

In this software, #C is used for program logic and Xaml is used for program user interface. This software consists of four layers.

(Codes are provided in four separate files) which include:

App: There are software codes.

Model Database: There is a layer through which the software layer can interact with the web layer.

Tables: Interface code (contains a series of classes that can be used as interfaces for other sections)

Web Api: There are codes that perform the main operation that is to be performed on the bank and all requests are sent to it (such as logging in, ordering items, showing items, etc.)

Claims

Claims:

What is chimed is:

Claim No. 1: What is claimed is a computer program (Windows software) designed and built for placing the orders of goods (pharmaceutical and non-pharmaceutical) required for pharmacy by pharmacies from pharmaceutical companies (pharmaceutical and non-pharmaceutical companies).

Claim No. 2: According to Claim No. 1, the first part of this project has been implemented using Web Api 2 technology in the web platform, which provides an Api to the program under Windows that can be used to perform the main actions for calling and recording information.

Claim No. 3: According to Claim No. 1, the second part of the project is actually the under Windows client program, which is implemented with the C # programming language and WPF technology. The reason for using WPF is the existence of many libraries to create a beautiful and user-friendly graphical environment, as well as the up-to-date of this technology.

Claim No. 4: According to Claim No. 1, the third part of the project database is created using SQL Server 2012 and all tables and data have been copied to the purchased host.

Claim No. 5: According to Claim No. 1, the fourth section is a sub-project of the Library type, the output of which is a DLL file. This section contains classes that define the communication structure between the other sections and its task is to fill the gap that has been created between the previous sections.

Claim No. 6: According to Claim No. 1, all sections have been coded using Visual Studio 2019 software and .NET Framework 4.5.2.

Claim No. 7 : According to Claim No. 1 , the hardware components of this computer program are PC and the operating system used to run this computer program will be Windows.

Claim No. 8: According to Claim No. 1, placing of the orders of the goods required by the pharmacies and the delivery of the orders to the pharmaceutical companies will be done in return for receiving a specific commission, which will be equal to one percent (1%) of the total order amount.