Oracle and PHP Instance development Myers Order tracking System (1) _php tutorial

For companies that are primarily driven by the receivables business model, one of the core business functions is to enter, track, and record orders. In this respect, companies that are better able to scale their institutions and increase their profits without encountering infrastructure constraints. When order Processing is cumbersome, error-prone or inconsistent, the company will suffer economic losses due to direct costs and reduced productivity.

In my company Myers the Internet, core business matters revolve around building a customer base, providing continuous service to Myers and helping it solve problems when customer problems arise. Companies are using many different systems to handle all aspects of order entry and implementation cycles. These systems are neither integrated with each other nor have the mechanism to ensure that each order is properly billed.

Myers Order Tracking System (MOTS)

Like many other institutions, Myers grew from a small company into a medium-sized company, while retaining the same processes and systems throughout its growth. Most of these processes are built, and all transactions are done manually by e-mail, paper records, and field visits. 5 or 6 years ago, a Myers engineer used Allaire's Cold Fusion and a Microsoft SQL Server database to assemble a system to track order fulfillment, a system called MOTS (Myers Order tracking system) that allowed sales and The account management department enters the order, which is then implemented by the support, engineering, design, information systems, and accounting departments. Although this system is an important step forward, it still leaves many manual steps and is not integrated with any other business systems.

Probably at the same time, a system was created, in which customers and sales reps can order the products of the Myers website online. This system can create a new Web site and calculate the sum of the installation and recurring costs of the provided Web site package. It then sends an e-mail message to each department, and each department can enter the order into the Mots and create accounting information in the account management system.

Architectural barriers

This type of architecture suffers from several system problems. In Myers, one of the more obvious problems is the manual data entry required to initiate order tracking, and the error that results from this manual process. Another issue is the disconnection between order entry, order tracking and accounting systems in the company, loss of orders, omission of information, and errors caused by it.

Another problem that only occasionally arises is that the MOTS system itself has inherent flaws. Because of the way you write Mots, you can enter orders that do not have departmental allocation information or that have lost departmental distribution information. When this happens, the order will eventually be lost in the system. When the order is lost, accurate and timely accounting is more difficult to achieve.

As the business grows, the flaws in the architecture become more pronounced, and as the number of customers and orders increases, the frequency of lost and wrongly entered orders becomes increasingly high, which can have a difficult impact on the company's revenue. In addition, the number of manually entered data leads to inefficiencies in latency and processing.

Because of the increased impact and inefficiency of revenue in implementing agencies, it is clear that a replacement system is needed to link everything together and to increase efficiency and reduce error rates. The old system diagram is as follows.

498) this.width=498; ' OnMouseWheel = ' javascript:return big (This) ' height=259 alt= ' \ ' src= '/files/uploadimg/20080926/ 1021000.gif "width=338>
Figure 1: Legacy system Architecture

The figure shows all the areas that require manual data entry. Because these systems are not integrated, the likelihood of data loss or distortion is very high. Global demand becomes apparent immediately. 1

http://www.bkjia.com/PHPjc/446756.html www.bkjia.com true http://www.bkjia.com/PHPjc/446756.html techarticle for companies that are primarily driven by the receivables business model, one of the core business functions is to enter, track, and record orders. In this respect the more excellent companies can scale their machines ...

