CN103455334A

CN103455334A - Invoicing system based on PHP-MySQL technology

Info

Publication number: CN103455334A
Application number: CN 201310412605
Authority: CN
Inventors: 赵斌
Original assignee: Tianjin Diandian Science & Technology Development Co Ltd
Current assignee: Tianjin Diandian Science & Technology Development Co Ltd
Priority date: 2013-09-10
Filing date: 2013-09-10
Publication date: 2013-12-18

Abstract

The invention discloses an invoicing system based on a PHP-MySQL technology. Along with social economic development, traditional purchase, sale and inventory management methods of an enterprise cannot meet the current invoicing management of the enterprise, and the efficiency of the enterprise is influenced. Therefore, the traditional management mode is faced with innovation, and a novel invoicing system is very necessary. The enterprise needs to apply the modern information technology to the daily invoicing management, so that the efficiency of the enterprise can be improved, and furthermore the cost can be reduced. The system is a B/S invoicing system based on the Apache-PHP-MySQL, adopts a Smarty template engine to achieve separation among data operation, service logic and display layers. The system is convenient to develop, maintain and expand. As a single entry file form is used, the security of the system is greatly improved.

Description

JXC System based on the PHP+MySQL technology

Technical field

The field of the present invention relates to belongs to electronic information management techniques, relates to specifically a kind of JXC System based on the PHP+MySQL technology.

Technical background

Enterprise is traditional stocks up, the mode of sale, stock control can't meet the management of current enterprise to goods entry, stock and sales, makes the efficiency of enterprise be affected, so traditional management mode is faced with reform.New JXC System is very important.Enterprise need to be applied to modern information technologies in daily purchase, sales and stock management, can improve like this efficiency of enterprise and then reduce costs.This system is based on the B/S JXC System of Apache+PHP+MySQL, adopt the Smarty template engine, has realized the separation of data manipulation, service logic, display layer.Be convenient to exploitation, maintenance and expansion.Adopt the form of single entrance file, the security that has greatly improved system.

Along with the development of computer technology, network technology and IT application in the national economy, the field of circulation of commodity enters a new developing stage, and the competitive power of oneself will improve in enterprise, the product quality that must have, good service, good management system.Many enterprises need to be applied to modern information technologies in daily purchase, sales and stock management, with the efficiency that improves enterprise, reduce costs.One JXC System packaged can make the user very easily commodity be controlled and understand, thereby makes managerial personnel at every moment find that the profit and loss of the purchase channel of enterprise and shipment consider to stock up whether favourable to enterprise.

Summary of the invention

The accompanying drawing explanation

Fig. 1 is operational flow diagram of the present invention

Embodiment

Program design: for above analysis design, from maintenance and upgrading and the relatively more applicable B/S framework that adopts of operating cost angle consideration native system in system later stage.Operational efficiency and data processing are also had to very high requirement, and require the shorter construction cycle.Because PHP has, professional platform independence is strong, execution efficiency is high, occupying system resources is few, and it can be compiled into to have when the function be connected with many data volumes is changed database easily writes the code Adaptive change, and PHP is combined quite perfect especially with mysql.

Data are processed: for a goods entry, stock and sales, very crucial during the storage of data.So the selection of database has determined the quality of this system, because native system is mainly for medium and small sized enterprises, the processing power of insertion, inquiry and the affairs of data is had to very high requirement.MySQL is a system R.MySQL is a kind of associated type database, and data are kept in different tables, rather than all data are placed in a large warehouse, has so just increased speed and has improved dirigibility.The built-in InnoDB engine of Mysql is supported the ACID affairs, supports the locking of row level.And PHP provides a whole set of Mysql function, to mysql, provides omnibearing support.

Gordian technique 1.Smarty mould plate technique 1.1smarty template brief introduction Smarty is a PHP template engine.It separates the content of business logic codes and external demonstration, and a kind of method that is easy to management and using is provided, and can be described as application programmer and art designing and play the part of different roles, because in most of the cases, they can not be same persons.The Smarty mould plate technique has been realized logical separation by HTML code and PHP code.Its fundamental purpose will make the PHP programmer separate with the front end developer exactly, make the service logic content of programmer's reprogramming can not have influence on front end developer's Pages Design, front-end person who remodifies the page can not have influence on the service logic of program, and it is quite important that this point shows in the project of multi agent cooperation.

Claims

1. goods entry, stock and sales mainly contains five functional: merchandise sales function, merchandise control function, stock control function, customer account management function, system setting function.The functions such as management, the management of commodity special price, the data backup that requires JXC System to mainly contain merchandise sales function, the commodity return of goods, type management and unit management, stock control, stock allotment, managing user information, member's type management, merchandise news for company can recover, account management.

2. the JXC System based on the PHP+MySQL technology according to claim 1 is characterized in that: for the goods entry, stock and sales major function of enterprise development is to be responsible for the product turnover of enterprise, JXC System can be sold commodity, be returned goods.

3. the JXC System based on the PHP+MySQL technology according to claim 2, is characterized in that: the stock is managed and comprises inquiring stock, reduce, increase, allot.The integration that client's management is comprised to the client, Visitor Logs, consumer record etc., member's type management.The setting of system comprises personal information, the functions such as the backup of group of administrators and database and database recovery.

4. the JXC System based on the PHP+MySQL technology according to claim 3, is characterized in that: from maintenance and upgrading and the relatively more applicable B/S of the employing framework of operating cost angle consideration native system in system later stage.Operational efficiency and data processing are also had to very high requirement, and require the shorter construction cycle.