The Design And Implementation Of The Web Reporting System For P&G Jinan Distributor

Society due to the rapid development of information technology has entered the digital age. People regardless of office or daily life are inseparable from the computer processing of large amounts of information. Large amounts of data processing using a computer can make our work more efficient and can ensure the correct rate. Especially for the more complex data calculation process, the benefit of automation is becoming increasingly apparent. Each company will own company to develop some of the statements of the specification and to calculate the daily or weekly production reports for managers and employees to see the most recent performance. Especially as the fast moving consumer goods giant P&G (Procter&Gamble), daily sales, and sales are a huge number of sales every day there are a lot of changes, so the corresponding statements necessary for the unit to "Day" production. The Jinan area distributors with expanding artificial excel to making daily statements consuming large high efficiency and low cost, error-prone, seeking a way to automate all reports generated solutions. This article introduces how to solve practical problems.In this paper, by analyzing the system architecture as well as the advantages and disadvantages of the solutions to the domestic and foreign similar maturity to determine P&G Jinan distributor web reporting system will be based on the BS J2EE architecture of the hierarchical model, as well as ideas to design and realize the MVC. The system is deployed in the company’s existing ERP system on the server, and the need to extract part of the data in the database of the original ERP system while the system is running, so this needs analysis focuses on the business logic and data extraction trade-offs, as well as the company’s business operations. Next, to illustrate the overall design of the system through the physical architecture of the system are described, logical architecture, functional architecture, and technology architecture. The design of the physical architecture major consideration to compatibility issues with legacy systems, logical discussion of the logical structure of the system architecture, functional architecture in the form of a graph shows the main functions of the system, the technology architecture introduces complete the design to achieve the system used in mainstream technology.Further step is part of the detailed design of the P&G Jinan distributor web reporting system. The portion of the individual modules in the system design and the design of the UI has been described in detail, a brief introduction to the database used in the system table. Finally, in the system after the completion of its testing, this paper through the analysis of the test cases used as well as the results of the system test to confirm the system to meet the purpose of the early design and demand. P&G Jinan distributors web report generation system has been officially completed and delivered to users, has been put into operation, to assume automatically generate daily reports and real-time viewing of the work of a variety of important data. The system works well during using.In summary, the article describes the design and realization of the P&G Jinan distributor web reporting system.