Sales and Stock Maintenance FERTILIZERS & PESTICIDES Factory
A B S T R A C T (See below for source code)
As the usage of the system increases the maintenance of the stock of the particular product through the books is the little bit of tough procedure. The preparation of the lezers for the sales amount is time consuming procedure and it need manpower to do the calculations and stock maintenance. Some times there is chance to lose the record books.
The authentication for the processing of the data is necessary for the owner. To prevent such type of problems from maintaining the large amount of data we use system storage. By system we can process huge amount of data with easy operations . Sales and purchases will be calculated easily and we can see the entire data once.
To provide security for the owner from others we use encrypt and decrypt algorithms with username and password. The main aim of the project is storing of the details of the fertilizers and pesticides stock through the system, sales of the stock and provide the security for the owner of the factory.
This project is developed using PHP ( Hypertext Pre-processor ) is a server-side scripting language designed for web development but also used as a general-purpose programming language.
The manufacturer's objective is to keep fertilizer and pesticides materials moving continuously out of the factory so that the level of stocks in the factory depot remains just sufficient to maintain the pipeline stocks and replenish stocks. An explanation of carry-over stocks is needed here. In general terms, they consist of supplies from producers and/or imports remaining at the end of the season.
Working stocks account for a major part of the carry-over stocks and are required to ensure a smooth and uninterrupted flow of supplies from producer or importer, or both, to the final user, the farmer. Working stocks comprise stocks held by farmers, retailers, distributors, sub-distributors, wholesalers, etc., including quantities in transit as well as those held by Government for sale through the public distribution system and for infra-seasonal supply for price stabilization.
Statistics are required to record the development of production capacities, production, imports, exports, deliveries, stocks, use in agriculture and prices. For the short-term these statistics are required to ensure that the types of fertilizers required by the farmer are available to him when and where they are needed. If fertilizers arrive too late in the season, they are useless to him, their food production potential is lost and in many cases some of the fertilizer will be lost or damaged before the next season.
Statistics on fertilizer usage and stocks are needed for the organization of the acquisition, transport and storage of the supplies required by the farmer. Stock level statistics help the manufacturer to plan his production. Optimal use of fertilizers plays a key role in improving the productivity of various crops. The production of fertilizer is continuous whereas the demand for fertilizer is seasonal.
Over the years, it has been the endeavor of the factory to make available the required quantity of fertilizers and pesticides to the farmers at right place, in right time to fulfill this basic objective, there is the need for proper estimation of demand for fertilizers, both on short-term and long-term basis.
Overview of the Project
The maintenance of the stock of the particular product through the books is the little bit of tough procedure because sometimes there may be lose of that books. To prevent such type of problems from maintaining the large amount of data we use online storage. By online we can process huge amount of data with easy operations. In the processing of the stock performing operations the new stock arrived to the go-down is added to the current items.
The sales of the fertilizers and pesticides can be managed through maintaining of the quantity. the payment of the sales can done either through money or check. For check processing we need to carry the minimum details of the customer for future intimation. while billing process the vat also can calculated internally for the customer billing report.
To protect the from the unauthorized user accessing the sales details and stock details we provided the authentication for the username and password. when new item is arrived it must be need to mention the name of the company and invoice date and out date of the product.
Introduction to PHP
PHP is an open source project of the Apache software foundation and is particularly suited to web database applications because of integration tools for the web and database environments. In particular, the flexibility of embedding scripts in HTML pages permits easy integration of HTML presentation code. Apache, Mysql and PHP can run on a wide variety of operating systems. PHP stands for Hypertext Pre-processor. It‟s a open source scripting language. Scripts are executed on the server.
The PHP Platform
It is the open source community effort to maintain and improve it are unconstrained by commercial imperatives. It can be embedded into static HTML files and this makes client tier integration and fully featured object oriented language. PHP script execution is fast and all components run within the main memory space of php. Apache and php on many different platforms and operating systems.
Database server searches and manages data that‟s stored in databases. The database server applications interface is accessed using SQL. It‟s standard query language that‟s used to define and manipulate databases and date.
The server used in the project is XAMPP. It is free and open source cross platform web server, consisting mainly of apache http server and mysql database.
Apache and mysql
In the XAMPP Control Panel you should see Apache and MySQL listed. To start using them you need to start the services so click Start on both. If you have a Firewall on your computer you may need to grant permission for these applications. Once you have started Apache and MySQL open a web browser and visit http://localhost you should see the XAMPP Splash Screen where you can select a language and the next page is a web based control panel for XAMPP. You now have a web server running on your computer. There are a few things you should do now.
Click the Security link in the sidebar. You will see that some things are flagged up as insecure in red, below that is a link to fix the security problems. Click that and set a root password for MySQL.
1. Scripting delimiters