In this system, a Smart Card is used, that carries the Account information about the Family or Customer.

The device will check for the user authentication by their smart card.

If the user is found authentic, then the account details and quantity of ration to be given to the customer according to the total number of family members will be displayed on LCD.

Then the user can enter the item and its required quantity by an keypad.

A measuring system (Load cell or Flow meter) is connected with the device measure exact quantity as per the user information and dispatch the item.
In this system, the information about the delivered ration will be send directly to the server without manual feeding.

Here we have developed an android application for the user where he/she can track the details of their account from anywhere at any time. The application contains the information about the user and also their monthly quota of items and account balance.
This application is developed using Android Studio.
 

User database is developed in MySQL and accessed with the help of PHP.
Php Code:
$db_name = "Dump20160525";
$mysql_username = "itladmin2015";
$mysql_password = "ITL#oct2015";
$server_name = "localhost:3306";
$user_status = $_GET["status"];
$user_id = $_GET["userid"];
$user_balance = $_GET["balance"];
$user_rice = $_GET["rice"];
$user_oil = $_GET["oil"];

$user_name;
$r_cost;
$o_cost;
$link = mysql_connect('localhost:3306', 'itladmin2015', 'ITL#oct2015');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
else{
mysql_select_db($db_name);
if($user_status==true){
mysql_query( " UPDATE `smart_ration_db` SET `rice`= '$user_rice' WHERE `user_id` LIKE '$user_id'",$link);
mysql_query( " UPDATE `smart_ration_db` SET `oil`= '$user_oil' WHERE `user_id` LIKE '$user_id'",$link);
mysql_query( " UPDATE `smart_ration_db` SET `balance`= '$user_balance' WHERE `user_id` LIKE '$user_id'",$link);
}
else {
$result = mysql_query( "SELECT * FROM `smart_ration_db` WHERE `user_id` LIKE '$user_id'", $link);
if(mysql_num_rows($result)>0){
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$user_name = mysql_result($result,0,"name");
$user_rice = mysql_result($result,0,"rice");
$user_oil = mysql_result($result,0,"oil");
$user_balance = mysql_result($result,0,"balance");
$r_cost = mysql_result($result,0,"r_cost");
$o_cost = mysql_result($result,0,"o_cost");
echo "@$user_name,$user_balance,$user_rice,$user_oil,$r_cost,$o_cost,*";
}
else{
echo "@invalid,*";
}
}
}
mysql_free_result($result);
mysql_close($link);
?>
 

source:
/edDir/files/main.pdf

The proposed system creates the transparency in public distribution system as the work becomes automatic.

This system can rectify the ration forgery and avoid unwanted delay for manual feeding about the customer information and dispatched details in the register.