AI Chat Integration for Japanese Fortune-Telling Reservation System (CakePHP, Web Chat)

What We Want to Achieve We want users to complete the reservation process entirely via an AI chatbot on our website. Here’s the typical flow: User Conversation with AI User can specify a preferred fortune-teller by name User can search for available time slots User can search for a fortune-teller based on their problem area (e.g. love, work, health) Availability Search AI queries our database or backend to check available slots AI presents time slot options to the user Reservation Attempt User selects date and time AI prepares reservation parameters for database insertion Conflict Check (Overlapping Reservations) System checks if the chosen slot is already booked If so, AI suggests alternative time slots Payment Handling Once a time slot is confirmed, AI redirects the user to our existing Japanese telecom carrier payment page No development of the payment system itself is required Reservation Confirmation Upon successful payment, AI informs the user of their confirmed reservation time Scope of Work Implement the integration between the AI chatbot and our existing system Develop logic to: Parse user conversations and extract structured data (e.g. fortune-teller ID, date/time, topic) Search for available time slots via DB queries or APIs Insert reservations into the existing database Check for overlapping reservations before finalizing bookings Handle redirection to our existing telecom payment flow Embed the chatbot UI into our existing web frontend (CakePHP 2) Notes We plan to use an external AI service, such as the ChatGPT API, for the conversational part The AI should ultimately output structured JSON data (e.g. SQL parameters) rather than raw SQL queries Casual or unrelated user messages can be safely ignored Telecom payments are specific to Japan, so some familiarity with Japanese digital services is helpful but not mandatory

Existing System Frontend: CakePHP 2 (Web-based) Backend: CakePHP 4 Database: Shared MySQL database for both systems Payment: Japanese telecom carrier billing services (e.g. Docomo, au, Softbank, etc.) User Management: Managed via user ID When Applying, Please Let Us Know: Your experience with CakePHP 2 and/or CakePHP 4 Your experience integrating AI APIs (e.g. OpenAI, ChatGPT, etc.) Your estimated development hours and rough budget estimate Whether you have experience working on Japanese systems or payment flows (optional, but a plus)