-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 04, 2025 at 04:48 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.0.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `lms_project`
--

-- --------------------------------------------------------

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int(11) NOT NULL,
  `nama_proyek` varchar(255) DEFAULT NULL,
  `project_id_number` varchar(50) DEFAULT NULL,
  `business_id` int(11) DEFAULT NULL,
  `nama_bisnis` varchar(255) DEFAULT NULL,
  `tanggal_penilaian` date DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `nama_penilai` varchar(255) DEFAULT NULL,
  `project_description` text DEFAULT NULL,
  `project_value` decimal(18,2) DEFAULT NULL,
  `estimated_profit` decimal(18,2) DEFAULT NULL,
  `net_profit_margin` decimal(5,2) DEFAULT NULL,
  `monthly_net_profit` decimal(18,2) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `project_category` enum('Project','Project - Syirkah Mudharabah','Project - Syirkah Musyarakah','Invest - Syirkah Mudharabah','Invest - Syirkah Inan') DEFAULT NULL,
  `project_location` varchar(255) DEFAULT NULL,
  `project_category_id` int(11) DEFAULT NULL,
  `project_assessment_progress` enum('L1. Pre-Assesment','L2. Deep-Assesment','L3. Decision-Stage','L4. Post Investation') DEFAULT 'L1. Pre-Assesment',
  `project_status` enum('Not-Started','In-Progress','Accepted','Declined','Finished') DEFAULT 'Not-Started'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`id`, `nama_proyek`, `project_id_number`, `business_id`, `nama_bisnis`, `tanggal_penilaian`, `created_at`, `nama_penilai`, `project_description`, `project_value`, `estimated_profit`, `net_profit_margin`, `monthly_net_profit`, `start_date`, `end_date`, `duration`, `project_category`, `project_location`, `project_category_id`, `project_assessment_progress`, `project_status`) VALUES
(9, 'Hijab Pelangi Gamis 001', '001/Aqad/III/2024', NULL, 'Pelangi Hijab', NULL, '2025-07-02 03:47:52', NULL, 'Permodalan proyek pengadaan bahan baku & biaya kerja untuk PO Gamis 001', 1744200000.00, 337320000.00, 19.33, 2.42, '2024-03-28', '2024-08-15', 0, 'Project', 'Bogor', NULL, 'L1. Pre-Assesment', 'Finished'),
(10, 'Hijab Pelangi Gamis 002', '002/Aqad/IV/2024', NULL, 'Pelangi Hijab', NULL, '2025-07-02 03:53:12', NULL, '', 1926500000.00, 379400000.00, 19.69, 2.81, '2024-04-23', '2024-11-12', 203, 'Project', 'Bogor', NULL, 'L1. Pre-Assesment', 'Finished'),
(11, 'Hijab Pelangi Gamis 003', '003/Aqad/V/2024', NULL, 'Pelangi Hijab', NULL, '2025-07-02 03:54:44', NULL, '', 2199600000.00, 404160000.00, 18.37, 3.67, '2024-05-28', '2024-10-31', 156, 'Project', 'Bogor', NULL, 'L1. Pre-Assesment', 'Finished'),
(12, 'Hijab Pelangi Gamis 004', '004/Aqad/V/2024', NULL, 'Pelangi Hijab', NULL, '2025-07-02 03:56:17', NULL, '', 1879500000.00, 373200000.00, 19.85, 3.31, '2024-05-28', '2024-09-04', 99, 'Project', 'Bogor', NULL, 'L1. Pre-Assesment', 'Finished'),
(13, 'Hijab Pelangi Gamis 005', '005/Aqad/VII/2024', NULL, 'Pelangi Hijab', NULL, '2025-07-02 03:57:38', NULL, '', 2072500000.00, 426000000.00, 20.55, 3.43, '2024-07-03', '2024-12-30', 180, 'Project', 'Bogor', NULL, 'L1. Pre-Assesment', 'Finished'),
(14, 'Hijab Pelangi Gamis 006', '006/Aqad/VIII/2024', NULL, 'Pelangi Hijab', NULL, '2025-07-02 03:58:59', NULL, '', 4127500000.00, 873750000.00, 21.17, 3.02, '2024-08-26', '2025-03-10', 196, 'Project', 'Bogor', NULL, 'L1. Pre-Assesment', 'In-Progress'),
(15, 'Hijab Pelangi Gamis 007', '007/Aqad/VIII/2024', NULL, 'Pelangi Hijab', NULL, '2025-07-02 04:00:14', NULL, '', 1664000000.00, 334400000.00, 20.09, 3.35, '2024-08-26', '2025-02-25', 183, 'Project', 'Bogor', NULL, 'L1. Pre-Assesment', 'Finished'),
(16, 'Hijab Pelangi Gamis 008', '008/Aqad/VIII/2024', NULL, 'Pelangi Hijab', NULL, '2025-07-02 04:01:50', NULL, '', 1921000000.00, 371600000.00, 19.34, 4.84, '2024-11-04', '2025-02-27', 115, 'Project', 'Bogor', NULL, 'L1. Pre-Assesment', 'Finished'),
(17, 'Pak Ayud - 0047', 'Pak Ayud - 0047', NULL, 'PT. Yuditha Nugraha Karya', NULL, '2025-07-02 04:06:43', NULL, '', 683328876.00, 118724124.00, 17.37, 2.17, '2024-07-01', '2024-10-10', 101, 'Project', 'Jakarta', NULL, 'L1. Pre-Assesment', 'Finished'),
(18, 'Pak Ayud - 0052', 'Pak Ayud - 0052', NULL, 'PT. Yuditha Nugraha Karya', NULL, '2025-07-02 04:08:10', NULL, '', 1080000000.00, 126750500.00, 11.73, 3.91, '2024-05-31', '2024-07-25', 55, 'Project', 'Jakarta', NULL, 'L1. Pre-Assesment', 'Finished'),
(19, 'Pak Ayud - 337', 'Pak Ayud - 337', NULL, 'PT. Yuditha Nugraha Karya', NULL, '2025-07-02 04:09:27', NULL, '', 280000000.00, 56417030.00, 20.15, 3.36, '2024-08-15', '2025-01-06', 144, 'Project', 'Jakarta', NULL, 'L1. Pre-Assesment', 'Finished'),
(20, 'Pak Ayud - 039', 'Pak Ayud - 039', NULL, 'PT. Yuditha Nugraha Karya', NULL, '2025-07-02 04:10:34', NULL, '', 220000000.00, 38926480.00, 17.70, 2.53, '2024-07-15', '2025-01-12', 181, 'Project', 'Jakarta', NULL, 'L1. Pre-Assesment', 'Finished'),
(21, 'Pak Ayud - 019', 'Pak Ayud - 019', NULL, 'PT. Yuditha Nugraha Karya', NULL, '2025-07-02 04:12:51', NULL, '', 400000000.00, 71665234.00, 17.91, 4.48, '2024-10-11', '2024-02-05', 106, 'Project', 'Jakarta', NULL, 'L1. Pre-Assesment', 'Finished'),
(22, 'BMI-Mekanikal WHP', '001/Aqad/VII/2024', NULL, 'BMI Mekanikal', NULL, '2025-07-02 04:16:37', NULL, '', 354029375.00, 53935398.00, 15.23, 3.05, '2024-07-29', '2025-01-06', 161, 'Project', 'Palembang', NULL, 'L1. Pre-Assesment', 'In-Progress'),
(23, 'BMI-Mekanikal WB-TUK', '002/Aqad/VII/2024', NULL, 'BMI Mekanikal', NULL, '2025-07-02 04:17:50', NULL, '', 198357518.00, 44027988.00, 12.87, 1.84, '2024-07-29', '2025-03-13', 227, 'Project', 'Palembang', NULL, 'L1. Pre-Assesment', 'In-Progress'),
(24, 'Hari Ini Event Organizer', '0242/SPK/BMI/X/2024', NULL, 'CGLink', NULL, '2025-07-02 04:25:55', NULL, 'Permodalan Event Pertamina di Surabaya', 925000000.00, 142527747.00, 15.40, 3.08, '2024-10-05', '2024-12-30', 86, 'Project', 'Surabaya', NULL, 'L1. Pre-Assesment', 'In-Progress'),
(25, 'Laksmi Muslimah NikahFest 2024 Surabaya', 'No. 010/Aqad Syirkah/XII/2024', NULL, 'Laksmi Muslimah', NULL, '2025-07-02 04:30:25', NULL, '', 665300000.00, 109025000.00, 16.38, 2.70, '2024-12-06', '2025-06-15', 191, 'Project', 'Surabaya', NULL, 'L1. Pre-Assesment', 'In-Progress'),
(26, 'PENARIKAN SKTM 20 KV, PEMBANGUNAN SIPIL & INSTALASI GARDU UNTUK PB/PD TM LOT 2 – PLN UP 3 PONDOK KOPI', 'No. 005/Aqad Syirkah/III/2025', NULL, 'PT. Yuditha Nugraha Karya', NULL, '2025-07-02 04:34:06', NULL, '', 262773000.00, 87590929.00, 33.33, 6.67, '2025-03-26', '2025-08-26', 150, 'Project', 'Jakarta', NULL, 'L1. Pre-Assesment', 'In-Progress'),
(28, 'Syirkah Mudharabah Haura Utan Kayu New Concept', 'No. 007/Aqad Syirkah/VIII/2024', NULL, 'Haura Salon & Spa Muslimah', NULL, '2025-07-02 06:52:41', NULL, 'Syirkah Mudharabah Pengembangan Haura Utan Kayu dengan konsep baru dengan nisbah 40% untuk pemodal', 511184000.00, 200968992.00, 39.31, 3.27, '2024-10-01', '2029-10-01', 1825, '', 'Jakarta', NULL, 'L4. Post Investation', 'In-Progress'),
(31, 'Syirkah Mudharabah Wima Aesthetic Clinic cabang Sukoharjo', 'No. 011/Aqad Syirkah/XII/2024', NULL, 'Wima Aesthetic Clinic', NULL, '2025-07-02 07:03:37', NULL, 'Investasi Pembukaan Wima Aesthetic Clinic cabang Sukoharjo dengan nisbah 50%', 1472000000.00, 292128000.00, 19.84, 1.65, '2025-02-12', '2030-02-12', 1825, '', 'Surakarta', NULL, 'L4. Post Investation', 'In-Progress'),
(32, 'Syirkah Mudharabah pengembangan lembaga bimbingan belajar Akademi Prestasi cabang Palembang', 'No. 001/Aqad Syirkah/II/2025', NULL, 'Akademi Prestasi', NULL, '2025-07-02 07:11:01', NULL, 'Kerjasama Syirkah Mudharabah pengembangan lembaga bimbingan belajar Akademi Prestasi cabang Palembang dengan nisbah 50%', 556308600.00, 0.00, 0.00, 0.00, '2025-02-05', '2030-02-05', 1825, '', 'Palembang', NULL, 'L4. Post Investation', 'In-Progress'),
(33, 'Syirkah Bintang Mafahim Inspiratif', '001/Mafahim/VII/2025', NULL, 'Mafahim', NULL, '2025-07-02 07:14:53', NULL, 'Syirkah Mudharabah pembentukan konsultan bisnis syariah bernama Bintang Mafahim Inspiratif dengan Nisbah kepada pemodal sebesar 30%', 200000000.00, 195000000.00, 97.50, 8.12, '2025-07-01', '2028-07-01', 1095, '', 'Tangerang', NULL, 'L4. Post Investation', 'In-Progress'),
(34, 'PENARIKAN KABEL SKTM – SPJ 0033 PLN MARUNDA', 'No. 006/Aqad Syirkah/V/2025', NULL, 'PT. Yuditha Nugraha Karya', NULL, '2025-07-02 07:18:44', NULL, '', 365810000.00, 56278498.00, 15.38, 0.00, '2025-03-26', '2025-08-26', 150, 'Project', 'Jakarta', NULL, 'L1. Pre-Assesment', 'In-Progress'),
(35, 'Supply Material Batu - MOTIVE', 'Number by CGLink 001', NULL, 'CGLink', NULL, '2025-07-03 09:52:16', NULL, 'Supply Material Batu - MOTIVE PT. Inaran Berkah Abadi', 290292000.00, 9911160.00, 6.83, 1.71, '2025-05-01', '2025-05-30', 30, 'Project', 'Bekasi', NULL, 'L1. Pre-Assesment', 'Not-Started'),
(36, 'CV. Chiyoko Etsu - Alzeena Kids', 'Number by CGLink 002', NULL, 'CGLink', NULL, '2025-07-03 09:55:05', NULL, 'CV. Chiyoko Etsu - Alzeena Kids Ritel Baju Anak Project Penjualan Agustus 5 Month', 118668883.00, 33893202.00, 29.00, 6.00, '2025-07-01', '2025-12-01', 150, 'Project', 'Bandung', NULL, 'L1. Pre-Assesment', 'Not-Started'),
(37, 'Syirkah Bintang Mekanikal', 'Number Need Verify Mekanikal', NULL, 'Bintang Mekanikal Indonesia', NULL, '2025-07-04 02:27:45', NULL, 'Syirkah Inan antara Pak Syaifudin Fatta dengan Internasional dengan modal awal 750 jt, Penambahan 1 Milyar dan Penambahan 500 Juta. Total modal 2,25 Milyar', 2250000000.00, 0.00, 0.00, 0.00, '2023-10-17', '2028-10-17', 1825, '', 'Tangerang', NULL, 'L4. Post Investation', 'Not-Started'),
(38, 'Syirkah Bintang Mas Interior', 'Number Need Verify Interior', NULL, 'Bintang Mas Interior', NULL, '2025-07-04 02:32:17', NULL, 'Syirkah Inan Pak Masduki dengan Internasional dengan Nisbah 50% untuk pengelola dan 50% untuk pemodal', 0.00, 0.00, 0.00, 0.00, '2024-02-12', '2029-02-12', 1850, '', 'Bogor', NULL, 'L4. Post Investation', 'Not-Started'),
(40, 'Syirkah Bintang Mode', 'Number Need Verify Mode', NULL, 'Bintang Mode Indonesia', NULL, '2025-07-04 02:36:05', NULL, 'Syirkah Mudharabah Bintang Mode dengan Nisbah 40% untuk pengelola dan 60% untuk pemodal', 150000000.00, 0.00, 0.00, 0.00, '2024-10-27', '2029-10-27', 1850, '', 'Tangerang', NULL, 'L4. Post Investation', 'Not-Started');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `projects`
--
ALTER TABLE `projects`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `project_id_number` (`project_id_number`),
  ADD KEY `fk_projects_business_id` (`business_id`),
  ADD KEY `fk_project_category` (`project_category_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `projects`
--
ALTER TABLE `projects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `projects`
--
ALTER TABLE `projects`
  ADD CONSTRAINT `fk_project_category` FOREIGN KEY (`project_category_id`) REFERENCES `project_category` (`id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
