Project Title: Cable & Internet Customer Management System Project Overview: I need a web-based management system for a local cable and internet service business. The system should help manage customers area-wise and track their monthly payment status in a simple and efficient way. The application should have a clean and easy-to-use interface, suitable for daily use by a non-technical user. Core Requirements 1. Dashboard (Area-wise View) Display a list of service areas (e.g., area1, area2) Each area should show: Total number of customers Number of customers with pending payments Admin should be able to add, edit, and delete areas. 2. Customer Management Add, edit, and delete customers. Customer fields: Name Phone number Address STB Number LCO Code Area (linked to areas) Monthly Amount (default billing amount) 3. Area-Based Customer Listing Clicking on an area should display all customers belonging to that area. Data should be shown in a table format. Example columns: Customer Name | STB Number | LCO Code | Monthly Amount | Jan | Feb | Mar | ... | Dec 4. Monthly Payment Entry (Important Feature) Each month column should show the "amount paid". Default stored value in the database should be 0 (no payment recorded). Initially, the table shows 0. On clicking a month cell: Convert the cell into an input field. Automatically load the customer’s default monthly amount (e.g., 200). Allow editing (for partial payments like 100). Provide a Save button to store the value. 5. Payment Logic Full payment -> amount equals monthly amount Partial payment -> amount less than monthly amount No payment -> 0 6. Pending Report (Advanced Filters Required) Create a dedicated Pending Report page with the following filters: Year filter Month filter Area filter Customer name search Filters should work individually and in combination. Example use cases: View all pending payments for January 2026 View pending customers in Kambiliampatti for January 2026 View all pending records for aspecific customer 7. Pending Calculation Pending Amount = Monthly Amount − Amount Paid 8. UI Requirements Simple and clean dashboard (non-technical user friendly) Table-based layout for payment entry Inline editing for payment cells Optional color indicators: Green -> fully paid Orange -> partial Red -> not paid Deliverables 1. Fully functional web application deployed to my hosting or a cloud instance I can control. 2. Source code in a private Git repo. 3. Basic documentation covering setup, admin usage, and database schema. 4. A brief hand-off call or screen-share to walk me through the system. 5. Fully functional web application Additional Notes: The system should be optimized for fast data entry, as it will be used daily. Keep the UI very simple and intuitive.