2025/10/31

Share

  • Share on Facebook
  • Share on Twitter

Customer Satisfaction Survey System Built with CakePHP and MySQL Customer Satisfaction Survey System Built with CakePHP and MySQL

Project Overview

We built a customer support system to survey customer satisfaction after vehicle purchase.

Technology Stack and Development Tools Used

  • Programming Language: PHP
  • Back-end Framework: CakePHP 2
  • Test Framework: PHPUnit
  • Database: MySQL
  • Task Management Tool: Excel
  • Communication Tool: Redmine

Client’s Challenges

  • Visualizing Post-Purchase Customer Satisfaction and Systematizing Relationship Building
    The client needed a system to specifically track and understand customer satisfaction levels after a vehicle purchase.
    Furthermore, they wanted to go beyond simple data collection and establish a mechanism for maintaining good relationships with customers post-purchase by systematizing the process of sending gifts (QUO cards) as a token of appreciation to survey respondents.

Client’s Requirements

  • Faithful System Development Based on Design Documents and Implementation of Auto-Deletion Functionality
    The client’s main requirement was for the system to be developed faithfully according to the provided design documents and to ensure it operated exactly as specified.
    Additionally, from a security and compliance standpoint, they required the implementation of a function to automatically delete survey data and customer information (personal information) after a 6-month retention period had passed.

Our Proposal and Approach

  • Accurate Analysis of Design Documents and Testing to Guarantee Requirements
    Our company began by thoroughly analyzing the design documents provided by the client.
    This ensured that the entire development team correctly understood the business logic and processing flows behind the system, establishing a shared understanding.
    Based on this, we proceeded with system construction and conducted rigorous testing to confirm and guarantee that all client requirements were met.
  • Ongoing Maintenance Support for Stable Post-Launch Operation
    A system is not finished merely upon development; stable operation after launch is crucial.
    Our company proposed providing continuous maintenance support even after the system went live in the production environment.
    This established a structure for rapid response in the event of any issues, supporting an environment where the client could use the system with peace of mind and focus on their primary goals of tracking customer satisfaction and building relationships.