System Status

'Store investment records', 'withdrawals' => 'Store withdrawal records', 'emi_schedule' => 'Store EMI payment schedules', 'loan_payments' => 'Store loan payment history' ]; $all_tables_exist = true; foreach ($required_tables as $table => $description): $exists = $tables_check[$table] ?? false; if (!$exists) $all_tables_exist = false; ?>

Database Table	Status	Action Required
	✅ EXISTS ❌ MISSING	Create table using SQL script Ready to use

⚠️ Setup Required

Database Tables Missing

The finance system requires additional database tables to function properly. Please follow these steps to set up the database:

Step 1: Access your database

Log into phpMyAdmin or your database management tool

Step 2: Run the SQL script

Execute the following SQL commands:

-- Finance Management Tables for Kayal Aqua

-- 1. Investments table
CREATE TABLE `investments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reference_number` varchar(50) NOT NULL,
  `investment_type` enum('liquid_individual','liquid_common','loan_emi','loan_interest') NOT NULL,
  `investment_date` date NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `description` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `loan_start_date` date DEFAULT NULL,
  `interest_rate` decimal(8,4) DEFAULT NULL,
  `tenure_months` int(11) DEFAULT NULL,
  `monthly_emi` decimal(10,2) DEFAULT NULL,
  `monthly_interest_rate` decimal(8,4) DEFAULT NULL,
  `monthly_interest` decimal(10,2) DEFAULT NULL,
  `loan_status` enum('active','closed') DEFAULT 'active',
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `reference_number` (`reference_number`),
  CONSTRAINT `investments_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `investments_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- 2. Withdrawals table
CREATE TABLE `withdrawals` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reference_number` varchar(50) NOT NULL,
  `user_id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `withdrawal_date` date NOT NULL,
  `description` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `reference_number` (`reference_number`),
  CONSTRAINT `withdrawals_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `withdrawals_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- 3. EMI Schedule table
CREATE TABLE `emi_schedule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `investment_id` int(11) NOT NULL,
  `emi_number` int(11) NOT NULL,
  `due_date` date NOT NULL,
  `emi_amount` decimal(10,2) NOT NULL,
  `payment_date` date DEFAULT NULL,
  `status` enum('pending','paid','overdue') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  CONSTRAINT `emi_schedule_ibfk_1` FOREIGN KEY (`investment_id`) REFERENCES `investments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- 4. Loan Payments table
CREATE TABLE `loan_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reference_number` varchar(50) NOT NULL,
  `investment_id` int(11) NOT NULL,
  `payment_amount` decimal(10,2) NOT NULL,
  `payment_type` enum('partial','closure') NOT NULL,
  `payment_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `notes` text DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `reference_number` (`reference_number`),
  CONSTRAINT `loan_payments_ibfk_1` FOREIGN KEY (`investment_id`) REFERENCES `investments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `loan_payments_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

Step 3: Refresh this page

After running the SQL script, refresh this page to continue with the finance setup.

✅ System Ready

Finance System Initialized

All required database tables are present. The finance system is ready to use!

🚀 Launch Finance System

What's Next?

1. Database Setup

Create the required database tables using the SQL script above.

2. Add Investments

Record your business investments and capital contributions.

3. Track Loans

Manage EMI loans and interest-based loans with payment tracking.

4. Balance Reports

Generate comprehensive financial statements and profit/loss reports.

Debug Information

PHP Version
Database Connection
Current User	getUserName()); ?> (getUserRole()); ?>)
Server Time