Overview

This project provides an advanced SMS gateway integration system allowing seamless communication via multiple SMS providers, including Clickatell, Twilio, Infobip, GatewayAPI, SMSAPI, SMSMode, and PlaySMS. The system includes features for OTP-based verification and sending SMS messages with comprehensive logging and gateway management.


Tables and Their Roles

  • Customer: Stores customer information. Includes functionality for OTP-based verification when adding a new record.
  • OTP: Temporarily stores OTP codes generated during the verification process. Once verified, the OTP is removed from this table.
  • SMS_Log: Logs all sent SMS, including details such as date and time, recipient mobile number, message content, and the gateway used.
  • SMS_Gateways: Maintains configuration details (URL, username, password, token) for each SMS gateway.
  • System: Stores global SMS settings, including the active gateway and other system-wide configurations.

Key Features

  • OTP-Based Verification: The Customer form includes an OTP button that sends a one-time password to the provided mobile number. Users must input the correct OTP to complete the record addition.
  • SMS Sending: A dedicated Send menu demonstrates how to send SMS messages and OTP codes using the configured SMS gateways.
  • Gateway Configuration: Administrators can configure multiple SMS gateways via the SMS_Gateways and System tables.
  • Comprehensive Logging: All sent SMS messages are logged in the SMS_Log table for auditing and reference.

Usage Instructions

  1. Configure SMS Gateways: Populate the SMS_Gateways table with details such as URL, username, password, and token for each gateway.
  2. Set Active Gateway: Use the System table to define the active SMS gateway for sending messages.
  3. Adding Customers: Navigate to the Customer page, fill in the form, and click the OTP button to receive a one-time password on the provided mobile number. Input the OTP in the Temp Verify field to add the record.
  4. Sending SMS: Access the Send menu to learn how to send SMS messages or OTP codes using the configured gateways.
  5. Review Logs: View sent SMS details in the SMS_Log table, including the date, mobile number, content, and gateway used.

Benefits

  • Multi-Gateway Support: Switch between multiple SMS gateways for greater flexibility and redundancy.
  • Enhanced Security: OTP-based verification ensures secure record addition and authentication.
  • Comprehensive Management: Centralized configuration and logging for better control and monitoring.

Login

  • User: admin
  • Password: master
  • How to Check: On the Customer page, try adding a new record. Fill in the mobile number, click the OTP button, and input the received OTP code in the Temp Verify field. If the code is valid, the record is added, and the OTP is removed from the OTP table.