Day 15

9 April 2019

Mayura K R

Nikil M

Yashwanth D M

Phaneendra A R

• Created a google assistant application to reach and interact with our web application.

Day 14

4 April 2019

Mayura K R

Nikil M

Phaneendra A R

Yashwanth D M

• Review 2 was conducted for the project and the project demo was presented to the assigned faculties.

Day 13

Date: 2-April-2019

Team Members	USN
Yashwanth D M	1KS15CS123
Nikil M	1KS15CS066
Mayura K R	1KS15CS056
Phaneendra A R	1KS15CS002

• Created a interface for users to visualize the counterfeit cases.



•  Created a interface for user query counterfeit cases by city name.



•  Enhanced the user interface and user experience of the application.

Day 12

Nikil M

Phaneendra A R

• Developed back-end for pharmacist.

• Prepared presentation for Review 2.

Day 11

21 March 2019

Nikil M

Phaneendra A R

• Designed and optimized user interface for pharmacist and user applications for validation and product information query respectively.


• Created REST API endpoint for manufacturer to add products into the block-chain.  

Day 10

19 March 2019

Nikil M

Phaneendra A R

• Modified back-end database architecture.


• Modified API code accordingly. 

Day 9

14 Mar 2019

Phaneendra A R

Nikil M

• Opted PostgreSQL over MySQL as Heroku provides the cloud Database for free.
• Optimised request load on back-end.
• Modified existing code for PostgreSQL,

Day 8

07 March 2019

Nikil M
Phaneendra A R

• Created A REST API.
• Migrated backward components from flask to Django 

Day 7

05 March 2019

Yashwanth D M
Mayura K R
Phaneendra A R

• Made optimisations in the QR code reader.
• Made code readable with comments and indentation.
• Restructured and beautified components.

Day 6

28 Feb 2019

Yashwanth D M
Phaneendra A R
Nikil M
Mayura K R


PHASE - II
Review - I

• Presented about our project as per the review criteria to a panel of teachers.

Day 5

26-02-19

Yashwanth D M
Mayura K R
Phaneendra A R

• Added a validity module which is used to authenticate the QR code by checking its existence in the database.
• Designed a simple Web-UI for performing the validity operation.

Day 4

21 Feb 2019                                                                                                        

Yashwanth D M
Mayura K R 
Phaneendra A R 

QR code Generator

• Developed a basic python program to generate QR code based on pseudo random generator.
• Decided to generate hash based on drug details provided by manufacturer.     

BigchainDB

• Created a BigchainDB.
• Created python programs to connect, get and write to database.

Work Flow Diagram:

•  The manufacturer enters the product details in the Web-application.
• The application creates hash with the help of this data and pushes hash to Database.
• A QR code is generated which consists of this hash value, and is sent to manufacturer.
• The pharmacist will use the QR code on products to authenticate them.
• The user uses the Web-UI to check details of the product.  

Day 3

19 Feb 2019 
Mayura K R
Phaneendra A R

Requirements Analysis

• Need an API for QR code generator which embeds pseudo-random number.
• MySQL Database as RDBMS.
• ReactJS for User Interface.
• Apache as Server.
• BigchainDB as database to hold the IDs in blockchain style.
• Docker for containing BigchainDB.

The required applications and frameworks were installed and configured on personal computers.

Day 2

14 Feb 2019

Yashwanth D M
Nikil M
Mayura K R
Phaneendra A R

Objective Re-establishment:

The objectives of our project were reconsidered and we finalized with what was meant to be, and they are as follows:

1. Develop a supply management system where the data can be accessed globally.
2. Track the supply details which will be embedded in the packing.
3. User able to check validity of the drug and should be able to distinguish between counterfeit and authentic drugs.
4. Ensure brand safety.
5. Alert the authorities if activity is found to be malicious.

Method of approach:

• Various approaches were considered and evaluated with their advantages and disadvantages along with ease of their implementation.
• A method was chosen and it has the following approach to tackle the problem.

1. The drugs’ packages are labelled with QR code.
2. The QR code holds a unique ID which is pseudo-random generated.
3. The same ID is pushed to block-chain.
4. Once the drug is scanned by the pharmacist the application checks its fidelity.
5. If not present in block-chain then it alerts it as a fake.
6. If present it alerts as valid and flags the item.
7. If the same item is scanned again it no longer alerts it as valid.
8. This way we will be ensuring even if a counterfeit is generated it can only be generated once.

Day 1

12 Feb 2019

Nikil M
Yashwanth D M
Phaneendra A R

Literature survey

In May 1988: Resolution WHA 41.16 requesting WHO "to initiate programs for the prevention and detection of export, import, and smuggling of falsely labeled, spurious, counterfeited or substandard pharmaceutical preparations, and to cooperate with the Secretary-General of the UN in case provisions of the international drug treaties are violated.

Since then, there have been many amendments such as assigning special task forces globally to fight for the same. Many countries are collectively putting effort to if not eradicate at least reduce the scale in which these trades occur but there has been no impact. The World Health Organization (WHO) estimates that counterfeit medicines worth 73 billion euros are traded annually. Dubious online pharmacies that conceal their true location deliver globally – reaching countries such as Germany, UK, Italy, Spain etc. or the USA. Supplies from illegal Internet pharmacies – those without appropriate certification – are up to 50 percent counterfeits. 

According to Outsourcing-Pharma in 2012, 75% of counterfeit drugs supplied worldwide had some origins in India, followed by 7% from Egypt and 6% from China.

The problem areas being:

              1.      National reputation at stake. 

              2.      Brand protection.

              3.      Export barriers.

              4.      Patient protection.

Counterfeit drug prevention measures taken so far are:

1. Effective packing
2.  Radio-frequency identification (RFID)
3. Mass encryption technology

The methods have not been able to be quite effective as they are either expensive or made complex. Thus, we can conclude that there is a necessity for a new kind of system for supply and distribution.