Customer Management System

Welcome to the Customer Management System! This project is a web-based application (WebApp) designed to enable admins and agents to conveniently manage customer data. This is the V3 Version. The final version has not been released publicly, as it was used for another project, but all functionalities are working well and can be used.

*Tips Defult Login Details:
Admin - Username:TEST , Password:TEST123
Agent - Username:TEST , Password:TEST123

Developed by: www.dkly.top

Additional Notes:

• Business Use: For commercial purposes, please contact me via email to request authorization.
• Academic Use: If using this project as a reference or incorporating its code into your assignment, please ensure you properly cite this project and specify the code that you have used to avoid any issues with plagiarism.

🛠 Language and Tools

---

If you use this repository, please support it by pressing the star button at the top-right of the page. Your support helps motivate continued development and improvements!

This project was created as part of an educational assignment, and I do not currently plan to continue it as it has already been submitted. However, we welcome educational collaboration!

Contributing

1. Fork this repository and create a new branch (e.g., feature/new-feature).
2. Make your changes and commit them.
3. Push your branch and open a pull request.

Thank you for your support and contributions!

Usage Guidelines

• Business Use: For commercial purposes, please contact me via email to request authorization.
• Academic Use: If using this project as a reference or incorporating its code into your assignment, please ensure you properly cite this project and specify the code that you have used to avoid any issues with plagiarism.

Guide: Setting Up and Changing MySQL Password in config.php

To set up and change the MySQL password for the Customer Management System, follow these steps:

---

1. Clone the Repository

Clone the repository to your local machine using the following command:

curl https://github.com/osscv/Customer_Managemenr_System.zip

2. Upload to Your Server

Upload the files to your server or hosting provider. For example, if you are using a BT Panel or a similar web hosting panel, you can upload the files to the desired directory (e.g., /www/wwwroot/calling-system.dkly.top/v3/).

3. Unzip the Files

After uploading the repository, navigate to the directory where you uploaded the files. Unzip the files if necessary. You can do this via your hosting panel or via SSH (e.g., using the unzip command):

unzip Customer_Managemenr_System.zip

This will extract the contents into the directory so that the system is ready to use.

4. Update the config.php File

In your config.php file, change the password in the $password variable to your new MySQL password. Here's an updated version of the config.php file:

<?php
$servername = "localhost";
$username = "callingsys";
// Change this to your new MySQL password
$password = "NEW_PASSWORD_HERE";
$dbname = "callingsys";
 
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
 
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
?>

Replace NEW_PASSWORD_HERE with your new password.

---

5. Change MySQL Password

To change the MySQL password for the callingsys user, follow these steps:

a. Log into MySQL

Open your terminal and run the following command to log into MySQL (replace root with your MySQL admin user if it's different):

mysql -u root -p

Enter your MySQL root password when prompted.

b. Change the Password

Once you're logged in, run the following SQL command to change the password for the callingsys user:

ALTER USER 'callingsys'@'localhost' IDENTIFIED BY 'NEW_PASSWORD_HERE';

Replace NEW_PASSWORD_HERE with the new password you want to set.

c. Flush Privileges

To ensure the changes take effect, run the following command:

FLUSH PRIVILEGES;

d. Exit MySQL

After the password is changed, exit MySQL by running:

EXIT;

---

6. Test the Connection

Once you've updated the password in both MySQL and config.php, test your connection to ensure everything is working correctly. If there are any issues, double-check the credentials in the config.php file and verify that the new password is correct.

---

SQL schema for for callingsys:

Table: additional_records

This table stores additional records.

CREATE TABLE `additional_records` (
  `ID` int NOT NULL,
  `Customer_ID` int DEFAULT NULL,
  `Important_Remarks` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Package` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Appointment_Date_Time` datetime DEFAULT NULL,
  `Agent_Name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Customer_Spoken` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Agent_Remarks` text COLLATE utf8mb4_general_ci,
  `Status` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Added_Date_Time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Table: agents

This table stores agent details.

CREATE TABLE `agents` (
  `ID` int NOT NULL,
  `Agent_Name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `Password` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `Remarks` text COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Sample Data Insertion for agents Table

INSERT INTO `agents` (`ID`, `Agent_Name`, `Password`, `Remarks`) VALUES
(1, 'Khoo', 'KLY123', 'Admin');

Table: customers

This table stores customer details.

CREATE TABLE `customers` (
  `ID` int NOT NULL,
  `Name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `HP_Number` varchar(15) COLLATE utf8mb4_general_ci NOT NULL,
  `Age` int NOT NULL,
  `Nationality` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `Language` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `Status` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `Agent` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Sample Data Insertion for Customer Table

INSERT INTO `customers` (`ID`, `Name`, `HP_Number`, `Age`, `Nationality`, `Language`, `Status`, `Agent`) VALUES
(1, 'YSoon', '012348312', 20, 'Malaysia', 'Chinese/Dialect', 'Unknown', 'KLY'),
(2, 'KYean Seo', '0107838203', 40, 'Malaysia', 'Chinese/Dialect', 'Unknown', 'TVB'),
(3, 'Cheng Yi Mun', '01234403', 21, 'Malaysia', 'Chinese/Dialect', 'Unknown', 'TVB'),

Table Indexes

additional_records Table Indexes

ALTER TABLE `additional_records`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `Customer_ID` (`Customer_ID`);

agents Table Indexes

ALTER TABLE `agents`
  ADD PRIMARY KEY (`ID`),
  ADD UNIQUE KEY `Agent_Name` (`Agent_Name`);

customers Table Indexes

ALTER TABLE `customers`
  ADD PRIMARY KEY (`ID`);

Auto-Increment

Make sure that the tables that require auto-increment for primary keys are configured properly.

-- Example for auto-increment on the `ID` column:
ALTER TABLE `additional_records` MODIFY `ID` int NOT NULL AUTO_INCREMENT;
ALTER TABLE `agents` MODIFY `ID` int NOT NULL AUTO_INCREMENT;
ALTER TABLE `customers` MODIFY `ID` int NOT NULL AUTO_INCREMENT;

限制表 additional_records

ALTER TABLE `additional_records`
  ADD CONSTRAINT `fk_customer` FOREIGN KEY (`Customer_ID`) REFERENCES `customers` (`ID`) ON DELETE SET NULL;
COMMIT;

APU Sustainable Future Fusion Khoo Lay Yang