tailieunhanh - MySQL /PHP Database Applications Second Edition phần 7

Đừng lo lắng, chúng tôi đã có tất cả các vấn đề. Mối quan hệ ngập ngừng, ông chủ làm cho nhu cầu thất thường, và gia đình - ồ, tất cả chúng ta đều biết về gia đình. Đáng buồn thay, trong cuộc sống điên mà tất cả chúng ta sống, PHP và MySQL có thể làm không có gì để làm cho cô gái / | Chapter 13 Problem-Tracking System IN THIS CHAPTER Designing a problem-tracking system Protecting yourself from redundant data Using the IntegratedTemplate class from the PEAR class libraries Creating a site that has both public and private portions Got problems Don t worry we ve all got problems. Relationships falter bosses make capricious demands and family oh we all know about family. Sadly in the crazy lives that we all live PHP and MySQL can do nothing to make your girl boyfriend love you more or make your dealings with your parents or in-laws any easier. But no scripting language or relational database is better equipped in these areas. But if you re working for a company that sells or otherwise dispenses goods it is a virtual guarantee that someone somewhere is going to be unhappy with what he or she has received. When that person complains you are going to want to have a place in which to record the problems and the steps required for resolution. The problem-tracking application in this chapter can be used for that purpose. What we have here is fairly generic and depending on the goods involved with your business it is likely that you are going to want some fields that apply to your specific products. Anyhow this application should get you moving in the right direction. Determining the Scope and Goals of the Application This problem-tracking system should have aspects that are publicly available and others that only someone with the proper authorization can view. It makes sense to have a form that users can access over the Web in order to report their problems. Alternatively someone on the support staff should be able to report problems for example while taking a phone call from a dissatisfied customer. Once the problem is entered it should be tracked by the staff. Each action taken in the attempt to solve the problem should be noted. And the tracking should have 441 442 Part IV Not So Simple Applications a public and a private realm actions that you want .