Project

General

Profile

Actions

Task #174

open

Admin Login

Added by Dana Basheer about 2 months ago. Updated about 2 months ago.

Status:
Resolved
Priority:
High
Assignee:
Start date:
03/16/2026
Due date:
03/16/2026 (50 days late)
% Done:

0%

Estimated time:

Description

This module is used for admin authentication and access control. The admin can log in to the system and manage master data such as countries, states, districts, locations, vehicles, hotels, transporters, drivers, and sightseeing. The admin credentials are stored securely, and access is granted only after successful authentication.

Table

c2b_admin_login

  • admin_id (PK) INT AUTO_INCREMENT Unique admin ID
  • username VARCHAR(150) Admin login username
  • password VARCHAR(255) Encrypted admin password
  • email VARCHAR(150) Admin email address
  • is_active BOOLEAN DEFAULT TRUE Active / inactive status
  • created_at DATETIME Record created date
  • updated_at DATETIME Record updated date

Validations

Mandatory

  • username required
  • password required
  • email required

Username

  • Minimum 3 characters
  • Maximum 150 characters
  • Must be unique

Password

  • Minimum 8 characters

Must contain:

  • Uppercase letter
  • Lowercase letter
  • Number
  • Special characters
  • Password must be stored encrypted (hashed).

Email

  • Must be valid email format
  • Must be unique

During login:

  • Username must exist
  • Password must match (after hashing comparison)
  • is_active must be TRUE

If not:

  • Show error:
  • Invalid username or password
Actions

Also available in: Atom PDF