Design And Implementation Of Custom Fuel Report

Report management is an important function in fuel information system, but it is complex and difficult to maintain by using static report in some information system. It is more efficient and real-time to design report by users themselves without developer involved.After analyzing the characteristics of the fuel report and the current research status of report software, it is concluded that the mapping from English to Chinese and the relevance between multi-table is the key to user-defined fuel report. It is common to store information by Chinese Pinyin acronym in fuel report, so it is necessary to make mapping from English to Chinese. Because of the predictable join condition, it can be decomposed into two problems: how to store relevance and how to generate join condition. For the complex characteristics of the fuel report relevance, it is intelligible to propose the concept of Maximum Spanning Tree based on the concept of the spanning tree and Minimum Spanning Tree in graph theory. By setting up the corresponding weights for different relevance, it is concluded that the spanning tree which gets the maximum sum of the weights is the final join condition of multi-table. After elaborating the operation of table select, field select, generating join condition of multi-table, generating excel in report creation and report export, providing quality report service by graphical user interface based on fuel information management system is ultimate goal.The experimental results show that algorithm of Maximum Spanning Tree based on prim meets the demand of practical information system, which is efficient at resolving the problem about join condition of multi-table. At the same time, the graphical user interface greatly simplifies report creation and report export, which make good user experience. As for the loading speed, interface design and perfect function, there is room for improvement.