--
-- Host: localhost    Database: d6
-- ------------------------------------------------------


--
-- Table structure for table `bop`
--

CREATE TABLE `bop` (
  `id` int(11) NOT NULL,
  `id_proyek` int(11) DEFAULT NULL,
  `kode_rab` varchar(5) DEFAULT NULL,
  `uraian` varchar(100) DEFAULT NULL,
  `volume_kumulatif` decimal(12,3) DEFAULT NULL,
  `volume_kuantiti` decimal(12,3) DEFAULT NULL,
  `unit` varchar(30) DEFAULT NULL,
  `harga_satuan` bigint(20) DEFAULT NULL,
  `ket` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `bop`
--

INSERT INTO `bop` VALUES
(1,1,'E','Biaya Operasional Kantor Pusat',1.000,0.010,'prosen',11952000000,''),
(2,1,'E','Biaya Operasional Direksi',1.000,0.003,'prosen',11952000000,''),
(3,1,'F','Mobil operasional marketing',1.000,1.000,'Unit',0,''),
(4,1,'F','Motor operasional lapangan',1.000,1.000,'Unit',10000000,''),
(5,1,'F','Meja, kursi, furniture',1.000,1.000,'LS',15000000,''),
(6,1,'F','Komputer laptop',1.000,1.000,'Unit',4000000,''),
(7,1,'F','Printer A4',1.000,1.000,'Unit',2500000,''),
(8,1,'F','Printer A3',0.000,0.000,'Unit',0,''),
(9,1,'F','Mesin faks',0.000,0.000,'Unit',0,''),
(10,1,'F','Peralatan pendukung kantor',1.000,1.000,'LS',15000000,''),
(11,1,'G1','Manager Operasional',18.000,1.000,'Bulan',3000000,''),
(12,1,'G1','Keuangan',18.000,1.000,'Bulan',2500000,''),
(13,1,'G1','Pembangunan',18.000,1.000,'Bulan',2500000,''),
(14,1,'G1','Arsitek penjualan',18.000,0.000,'Bulan',0,''),
(15,1,'G1','Legal & pemberkasan',18.000,1.000,'Bulan',2500000,''),
(16,1,'G1','Sales officer',18.000,1.000,'Bulan',2500000,''),
(17,1,'G1','Promo',18.000,1.000,'Bulan',500000,''),
(18,1,'G1','Honor Santri Magang',18.000,4.000,'Bulan',1000000,''),
(19,1,'G1','THR',1.000,1.000,'LS',13000000,''),
(20,1,'G1','Makan Staf',18.000,9.000,'Bulan',600000,''),
(21,1,'G1','Sewa kantor',2.000,1.000,'Tahun',25000000,''),
(22,1,'G1','Alat tulis kantor',18.000,1.000,'Bulan',200000,''),
(23,1,'G1','Foto copy dokumen',18.000,1.000,'Bulan',200000,''),
(24,1,'G1','Akomodasi & Transportasi',18.000,1.000,'Bulan',0,''),
(25,1,'G1','Benda pos',18.000,1.000,'Bulan',200000,''),
(26,1,'G1','Servis Komputer',18.000,1.000,'Bulan',150000,''),
(27,1,'G1','Biaya Bank',18.000,1.000,'Bulan',200000,''),
(28,1,'G1','Telepon / Internet',18.000,1.000,'Bulan',500000,''),
(29,1,'G1','Listrik',18.000,1.000,'Bulan',400000,''),
(30,1,'G1','Perawatan kantor',18.000,1.000,'Bulan',200000,''),
(31,1,'G1','Rumah tangga kantor',18.000,1.000,'Bulan',300000,''),
(32,1,'G1','Pajak / sumbangan',18.000,1.000,'Bulan',500000,''),
(33,1,'G1','Lain - lain',18.000,1.000,'Bulan',500000,''),
(34,1,'G1','Bahan bakar',18.000,1.000,'Bulan',500000,''),
(35,1,'G1','Olie',6.000,1.000,'LS',500000,''),
(36,1,'G1','Service',6.000,1.000,'LS',1050000,''),
(37,1,'G1','Suku cadang + ban',1.000,1.000,'LS',3600000,''),
(38,1,'G1','STNK',2.000,1.000,'LS',1500000,''),
(39,1,'G2','Study kelayakan proyek',0.000,1.000,'m2',5000,''),
(40,1,'G2','Proposal pendukung KPR bank',1.000,0.000,'Bulan',500000,''),
(41,1,'G2','Perencanaan',1.000,1.000,'LS',25000000,''),
(42,1,'G2','Pembersihan lokasi',15.000,1.000,'Bulan',850000,''),
(43,1,'G2','Pemeliharaan lokasi',15.000,1.000,'Bulan',850000,''),
(44,1,'G2','Pengukuran kavling',1.000,1.000,'LS',500000,''),
(45,1,'G2','Partisipasi lingkungan',15.000,1.000,'LS',300000,''),
(46,1,'G2','Keamanan Lingkungan',15.000,1.000,'LS',750000,''),
(47,1,'G2','Gudang / barak kerja',0.000,1.000,'m2',0,''),
(48,1,'G2','Peralatan proyek',4.000,1.000,'LS',500000,''),
(49,1,'G2','Material bantu',4.000,1.000,'LS',500000,''),
(50,1,'G2','Tenaga harian proyek',4.000,1.000,'Bulan',750000,''),
(51,1,'G3','Papan nama proyek',0.000,1.000,'m2',0,''),
(52,1,'G3','Billboard',0.000,1.000,'Unit',0,''),
(53,1,'G3','Sign board',4.000,1.000,'Unit',2500000,''),
(54,1,'G3','Rountag',100.000,1.000,'Unit',50000,''),
(55,1,'G3','Spanduk',30.000,3.000,'Unit',100000,''),
(56,1,'G3','Umbul - Umbul',60.000,1.000,'Unit',150000,''),
(57,1,'G3','Brosur eklusive',0.000,1.000,'Lembar',7500,''),
(58,1,'G3','Brosur massal',3000.000,1.000,'Lembar',1500,''),
(59,1,'G3','Standing Banner',10.000,1.000,'Unit',400000,''),
(60,1,'G3','Iklan kolom koran',0.000,1.000,'Paket',0,''),
(61,1,'G3','Iklan media sosial',18.000,1.000,'Paket',1500000,''),
(62,1,'G3','Media elektronik / radio',3.000,1.000,'Paket',1250000,''),
(63,1,'G3','Pameran / event / Gathering',1.000,1.000,'Event',50000000,''),
(64,1,'G3','Maket / perspektif',0.000,0.000,'Maket',0,''),
(65,1,'G3','Seragam pemasaran',10.000,2.000,'Unit',150000,''),
(66,1,'G3','Display pameran',0.000,0.000,'Unit',0,''),
(67,1,'G3','Fee Manager Operasional',0.000,1.000,'Unit',500000,''),
(68,1,'G3','Fee Bagian Keuangan',0.000,1.000,'Unit',350000,''),
(69,1,'G3','Fee Bagian Pembangunan',0.000,1.000,'Unit',500000,''),
(70,1,'G3','Fee Bagian Penjualan dan KPR',0.000,1.000,'Unit',350000,''),
(71,1,'G3','Fee Prestasi  penjualan rumah',0.025,1.000,'Unit',9391640000,''),
(72,1,'G3','Fee Prestasi tahunan ',0.000,1.000,'prosen',0,'');

--
-- Table structure for table `bop_head`
--

CREATE TABLE `bop_head` (
  `id_rab` varchar(5) NOT NULL,
  `id_proyek` varchar(5) DEFAULT NULL,
  `nama_rab` varchar(100) DEFAULT NULL,
  `ket` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `bop_head`
--

INSERT INTO `bop_head` VALUES
('E','1','MANAJEMEN PENGAWASAN PUSAT',NULL),
('F','1','BIAYA PERLENGKAPAN KANTOR',NULL),
('G','1','OVERHEAD KANTOR',NULL),
('G1','1','Operasional Kantor',NULL),
('G2','1','Operasional Proyek',NULL),
('G3','1','Operasional Pemasaran',NULL);

--
-- Table structure for table `cashflow_pembangunan`
--

CREATE TABLE `cashflow_pembangunan` (
  `id` int(11) NOT NULL,
  `id_proyek` int(11) DEFAULT NULL,
  `no_kavling` varchar(20) DEFAULT NULL,
  `tot_bangun` decimal(13,2) DEFAULT NULL,
  `mulai_bangun` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cashflow_pembangunan`
--

INSERT INTO `cashflow_pembangunan` VALUES
(1,1,'A-1',60000000.00,3),
(2,1,'A-2',60000000.00,3),
(3,1,'A-3',60000000.00,3),
(4,1,'A-4',60000000.00,3),
(5,1,'A-5',60000000.00,3),
(6,1,'B-1',60000000.00,4),
(7,1,'B-2',60000000.00,4),
(8,1,'B-3',60000000.00,4),
(9,1,'B-4',60000000.00,4),
(10,1,'B-5',60000000.00,4),
(11,1,'B-6',60000000.00,5),
(12,1,'B-7',60000000.00,5),
(13,1,'B-8',60000000.00,5),
(14,1,'B-9',60000000.00,5),
(15,1,'B-10',60000000.00,5),
(16,1,'B-11',60000000.00,6),
(17,1,'B-12',60000000.00,6),
(18,1,'B-13',60000000.00,6),
(19,1,'B-14',60000000.00,6),
(20,1,'B-15',60000000.00,6),
(21,1,'C-1',60000000.00,7),
(22,1,'C-2',60000000.00,7),
(23,1,'C-3',60000000.00,7),
(24,1,'C-4',60000000.00,7),
(25,1,'C-5',60000000.00,7),
(26,1,'C-6',60000000.00,8),
(27,1,'C-7',60000000.00,8),
(28,1,'C-8',60000000.00,8),
(29,1,'C-9',60000000.00,8),
(30,1,'C-10',60000000.00,8),
(31,1,'C-11',60000000.00,9),
(32,1,'C-12',60000000.00,9),
(33,1,'C-13',60000000.00,9),
(34,1,'C-14',60000000.00,9),
(35,1,'C-15',60000000.00,9),
(36,1,'C-16',60000000.00,10),
(37,1,'C-17',60000000.00,10),
(38,1,'C-18',60000000.00,10),
(39,1,'C-19',60000000.00,10),
(40,1,'C-20',60000000.00,10),
(41,1,'C-21',60000000.00,11),
(42,1,'C-22',60000000.00,11),
(43,1,'C-23',60000000.00,11),
(44,1,'C-24',60000000.00,11),
(45,1,'C-25',60000000.00,11),
(46,1,'C-26',60000000.00,11),
(47,1,'D-1',60000000.00,12),
(48,1,'D-2',60000000.00,12),
(49,1,'D-3',60000000.00,12),
(50,1,'D-4',60000000.00,12),
(51,1,'D-5',60000000.00,12),
(52,1,'D-6',60000000.00,13),
(53,1,'D-7',60000000.00,13),
(54,1,'D-8',60000000.00,13),
(55,1,'D-9',60000000.00,13),
(56,1,'D-10',60000000.00,13),
(57,1,'E-1',60000000.00,14),
(58,1,'E-2',60000000.00,14),
(59,1,'E-3',60000000.00,14),
(60,1,'E-4',60000000.00,14),
(61,1,'E-5',60000000.00,14),
(62,1,'E-6',60000000.00,15),
(63,1,'E-7',60000000.00,15),
(64,1,'E-8',60000000.00,15),
(65,1,'E-9',60000000.00,15),
(66,1,'E-10',60000000.00,15),
(67,1,'F-1',60000000.00,16),
(68,1,'F-2',60000000.00,16),
(69,1,'F-3',60000000.00,16),
(70,1,'F-4',60000000.00,16),
(71,1,'F-5',60000000.00,16),
(72,1,'F-6',60000000.00,16);

--
-- Table structure for table `head_ref`
--

CREATE TABLE `head_ref` (
  `id_rab` varchar(5) NOT NULL,
  `nama_rab` varchar(100) DEFAULT NULL,
  `kategori` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id_rab`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `head_ref`
--

INSERT INTO `head_ref` VALUES
('A','RAB HPP TANAH','rab'),
('B1','RAB HPP PENGOLAHAN LAHAN','rab'),
('B2','RAB HPP PRASARANA DAN SARANA','rab'),
('B3','RAB HPP KONTRUKSI RUMAH','rab'),
('C','RAB HPP PERIJINAN PROYEK','rab'),
('D1','RAB HPP LEGALITAS PROYEK\r\n','rab'),
('D2','RAB HPP LEGALITAS PENJUALAN KAVLING','rab'),
('E','MANAJEMEN PENGAWASAN PUSAT','bop'),
('F','BIAYA PERLENGKAPAN KANTOR','bop'),
('G','OVERHEAD KANTOR','bop'),
('G1','Operasional Kantor','bop'),
('G2','Operasional Proyek','bop'),
('G3','Operasional Pemasaran','bop');

--
-- Table structure for table `kavling`
--

CREATE TABLE `kavling` (
  `id` int(11) NOT NULL,
  `id_proyek` int(11) DEFAULT NULL,
  `no_kavling` varchar(20) DEFAULT NULL,
  `ket` varchar(50) DEFAULT NULL,
  `kategori` varchar(50) DEFAULT NULL,
  `lb` decimal(6,2) DEFAULT NULL,
  `lt` decimal(6,2) DEFAULT NULL,
  `hj_bangunan` int(11) DEFAULT NULL,
  `hb_tanah` int(11) DEFAULT NULL,
  `indeks_tanah` decimal(5,2) DEFAULT NULL,
  `h_dasar` int(11) DEFAULT NULL,
  `A` decimal(20,2) DEFAULT NULL,
  `B1` decimal(20,2) DEFAULT NULL,
  `B2` decimal(20,2) DEFAULT NULL,
  `B3` decimal(20,2) DEFAULT NULL,
  `C` decimal(20,2) DEFAULT NULL,
  `D1` decimal(20,2) DEFAULT NULL,
  `D2` decimal(20,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `kavling`
--

INSERT INTO `kavling` VALUES
(1,1,'A-1','RM 1 lantai 1 muka','Subsidi',30.00,64.00,2000000,250000,6.80,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2,1,'A-2','RM 1 lantai 1 muka','Subsidi',30.00,64.00,2000000,250000,6.80,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3,1,'A-3','RM 1 lantai 1 muka','Subsidi',30.00,64.00,2000000,250000,6.80,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(4,1,'A-4','RM 1 lantai 1 muka','Subsidi',30.00,64.00,2000000,250000,6.80,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(5,1,'A-5','RM 1 lantai 1 muka','Subsidi',30.00,64.00,2000000,250000,6.80,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(6,1,'B-1','RM 1 lantai 1 muka','Subsidi',30.00,65.00,2000000,250000,6.80,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(7,1,'B-2','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(8,1,'B-3','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(9,1,'B-4','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(10,1,'B-5','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(11,1,'B-6','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(12,1,'B-7','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(13,1,'B-8','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(14,1,'B-9','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(15,1,'B-10','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(16,1,'B-11','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(17,1,'B-12','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(18,1,'B-13','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(19,1,'B-14','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(20,1,'B-15','RM 1 lantai 1 muka','Subsidi',30.00,62.00,2000000,250000,7.00,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(21,1,'C-1','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(22,1,'C-2','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(23,1,'C-3','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(24,1,'C-4','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(25,1,'C-5','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(26,1,'C-6','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(27,1,'C-7','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(28,1,'C-8','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(29,1,'C-9','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(30,1,'C-10','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(31,1,'C-11','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(32,1,'C-12','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(33,1,'C-13','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(34,1,'C-14','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(35,1,'C-15','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(36,1,'C-16','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(37,1,'C-17','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(38,1,'C-18','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(39,1,'C-19','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(40,1,'C-20','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(41,1,'C-21','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(42,1,'C-22','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(43,1,'C-23','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(44,1,'C-24','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(45,1,'C-25','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(46,1,'C-26','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(47,1,'D-1','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(48,1,'D-2','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(49,1,'D-3','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(50,1,'D-4','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(51,1,'D-5','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(52,1,'D-6','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(53,1,'D-7','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(54,1,'D-8','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(55,1,'D-9','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(56,1,'D-10','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(57,1,'E-1','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(58,1,'E-2','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(59,1,'E-3','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(60,1,'E-4','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(61,1,'E-5','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(62,1,'E-6','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(63,1,'E-7','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(64,1,'E-8','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(65,1,'E-9','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(66,1,'E-10','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(67,1,'F-1','RM 1 lantai 1 muka','Subsidi',30.00,65.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(68,1,'F-2','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(69,1,'F-3','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(70,1,'F-4','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(71,1,'F-5','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(72,1,'F-6','RM 1 lantai 1 muka','Subsidi',30.00,61.00,2000000,250000,7.05,166000000,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `list_pemasukan`
--

CREATE TABLE `list_pemasukan` (
  `id` varchar(100) DEFAULT NULL,
  `pemasukan` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `list_pemasukan`
--

INSERT INTO `list_pemasukan` VALUES
('Penjualan rumah semua type','Penjualan rumah semua type'),
('Penambahan Nilai tanah\r\n','Penambahan Nilai tanah\r\n'),
('Lain-lain','Lain-lain');

--
-- Table structure for table `pemasukan_penjualan`
--

CREATE TABLE `pemasukan_penjualan` (
  `id` int(11) NOT NULL,
  `id_proyek` int(11) DEFAULT NULL,
  `pemasukan` varchar(50) DEFAULT NULL,
  `jumlah` decimal(43,0) NOT NULL,
  `bln` int(11) DEFAULT NULL,
  `tgl` date DEFAULT NULL,
  `kav` varchar(20) DEFAULT NULL,
  `payment` varchar(20) DEFAULT NULL,
  `ket` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pemasukan_penjualan`
--

INSERT INTO `pemasukan_penjualan` VALUES
(1,1,'Penjualan rumah semua type',1660000,4,'2023-09-01','A-1','Transfer','DP TF BCA 1561134338'),
(2,1,'Penambahan Nilai tanah\r\n',4500000,5,'2023-10-05','B-1','Transfer','Kelebihan Tanah TF BCA 1561134338'),
(3,1,'Lain-lain',0,NULL,NULL,NULL,NULL,NULL),
(4,1,'Penjualan rumah semua type',1660000,4,'2023-09-02','A-2','Transfer','DP TF BCA 1561134338'),
(5,1,'Penjualan rumah semua type',144306000,5,'2023-10-01','A-1','Transfer','KPR TF BCA 1561134338'),
(6,1,'Penjualan rumah semua type',144306000,5,'2023-10-02','A-2','Transfer','KPR TF BCA 1561134338'),
(7,1,'Penjualan rumah semua type',1660000,5,'2023-10-05','B-1','Transfer','DP TF BCA 1561134338');

--
-- Table structure for table `pendekatan_harga_jual`
--

CREATE TABLE `pendekatan_harga_jual` (
  `id` int(11) NOT NULL,
  `id_proyek` int(11) DEFAULT NULL,
  `no_kavling` varchar(20) DEFAULT NULL,
  `ket` varchar(50) DEFAULT NULL,
  `kategori` varchar(50) DEFAULT NULL,
  `lb` decimal(6,2) DEFAULT NULL,
  `lt` decimal(6,2) DEFAULT NULL,
  `hj_bangunan` int(11) DEFAULT NULL,
  `hb_tanah` int(11) DEFAULT NULL,
  `indeks_tanah` decimal(5,2) DEFAULT NULL,
  `h_dasar` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pendekatan_harga_jual`
--

INSERT INTO `pendekatan_harga_jual` VALUES
(1,1,'A-1','RM 1 lantai 1 muka','Subsidi',30.00,64.00,2000000,250000,6.80,166000000),
(2,1,'A-2','RM 1 lantai 1 muka','Subsidi',30.00,64.00,2000000,250000,6.80,166000000),
(3,1,'A-3','RM 1 lantai 1 muka','Subsidi',30.00,64.00,2000000,250000,6.80,166000000),
(4,1,'A-4','RM 1 lantai 1 muka','Subsidi',30.00,64.00,2000000,250000,6.80,166000000),
(5,1,'A-5','RM 1 lantai 1 muka','Subsidi',30.00,64.00,2000000,250000,6.80,166000000),
(6,1,'B-1','RM 1 lantai 1 muka','Subsidi',30.00,65.00,2000000,250000,6.80,166000000),
(7,1,'B-2','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(8,1,'B-3','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(9,1,'B-4','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(10,1,'B-5','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(11,1,'B-6','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(12,1,'B-7','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(13,1,'B-8','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(14,1,'B-9','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(15,1,'B-10','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(16,1,'B-11','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(17,1,'B-12','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(18,1,'B-13','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(19,1,'B-14','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(20,1,'B-15','RM 1 lantai 1 muka','Subsidi',30.00,62.00,2000000,250000,7.00,166000000),
(21,1,'C-1','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(22,1,'C-2','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(23,1,'C-3','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(24,1,'C-4','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(25,1,'C-5','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(26,1,'C-6','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(27,1,'C-7','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(28,1,'C-8','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(29,1,'C-9','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(30,1,'C-10','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(31,1,'C-11','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(32,1,'C-12','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(33,1,'C-13','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(34,1,'C-14','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(35,1,'C-15','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(36,1,'C-16','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(37,1,'C-17','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(38,1,'C-18','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(39,1,'C-19','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(40,1,'C-20','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(41,1,'C-21','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(42,1,'C-22','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(43,1,'C-23','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(44,1,'C-24','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(45,1,'C-25','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(46,1,'C-26','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(47,1,'D-1','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(48,1,'D-2','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(49,1,'D-3','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(50,1,'D-4','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(51,1,'D-5','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(52,1,'D-6','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(53,1,'D-7','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(54,1,'D-8','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(55,1,'D-9','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(56,1,'D-10','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(57,1,'E-1','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(58,1,'E-2','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(59,1,'E-3','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(60,1,'E-4','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(61,1,'E-5','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(62,1,'E-6','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(63,1,'E-7','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(64,1,'E-8','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(65,1,'E-9','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(66,1,'E-10','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(67,1,'F-1','RM 1 lantai 1 muka','Subsidi',30.00,65.00,2000000,250000,7.05,166000000),
(68,1,'F-2','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(69,1,'F-3','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(70,1,'F-4','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(71,1,'F-5','RM 1 lantai 1 muka','Subsidi',30.00,60.00,2000000,250000,7.05,166000000),
(72,1,'F-6','RM 1 lantai 1 muka','Subsidi',30.00,61.00,2000000,250000,7.05,166000000);

--
-- Table structure for table `pengeluaran_bop`
--

CREATE TABLE `pengeluaran_bop` (
  `id` int(11) NOT NULL,
  `id_proyek` int(11) DEFAULT NULL,
  `pengeluaran` varchar(50) DEFAULT NULL,
  `head` varchar(50) DEFAULT NULL,
  `detil` varchar(100) DEFAULT NULL,
  `jumlah` decimal(43,0) NOT NULL DEFAULT 0,
  `bln` int(11) DEFAULT NULL,
  `tgl` date DEFAULT NULL,
  `payment` varchar(20) DEFAULT NULL,
  `ket` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pengeluaran_bop`
--

INSERT INTO `pengeluaran_bop` VALUES
(1,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,2,'2023-06-01','Transfer',NULL),
(2,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,3,'2023-07-01','Transfer',NULL),
(3,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,4,'2023-08-01','Transfer',NULL),
(4,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,5,'2023-09-01','Transfer',NULL),
(5,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,6,'2023-10-01','Transfer',NULL),
(6,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,7,'2023-11-01','Transfer',NULL),
(7,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,8,'2023-12-01','Transfer',NULL),
(8,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,9,'2024-01-01','Transfer',NULL),
(9,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,10,'2024-02-01','Transfer',NULL),
(10,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,11,'2024-03-01','Transfer',NULL),
(11,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,12,'2024-04-01','Transfer',NULL),
(12,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,13,'2024-05-01','Transfer',NULL),
(13,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,14,'2024-06-01','Transfer',NULL),
(14,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,15,'2024-07-01','Transfer',NULL),
(15,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,16,'2024-08-01','Transfer',NULL),
(16,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,17,'2024-09-01','Transfer',NULL),
(17,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,18,'2024-10-01','Transfer',NULL),
(18,1,'Biaya Operasional Kantor Pusat',NULL,NULL,6640000,19,'2024-11-01','Transfer',NULL),
(19,1,'Mobil operasional marketing',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(20,1,'Motor operasional lapangan',NULL,NULL,10000000,3,'2023-07-01','Transfer',NULL),
(21,1,'Meja, kursi, furniture',NULL,NULL,15000000,3,'2023-07-01','Transfer',NULL),
(22,1,'Komputer laptop',NULL,NULL,4000000,3,'2023-07-01','Transfer',NULL),
(23,1,'Printer A4',NULL,NULL,2500000,3,'2023-07-01','Transfer',NULL),
(24,1,'Printer A3',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(25,1,'Mesin faks',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(26,1,'Peralatan pendukung kantor',NULL,NULL,15000000,3,'2023-07-01','Transfer',NULL),
(27,1,'Sewa kantor',NULL,NULL,30000000,2,'2023-06-01','Transfer',NULL),
(28,1,'Sewa kantor',NULL,NULL,20000000,13,'2024-06-01','Transfer',NULL),
(29,1,'Alat tulis kantor',NULL,NULL,200000,4,'2023-08-01','Transfer',NULL),
(30,1,'Alat tulis kantor',NULL,NULL,200000,5,'2023-09-01','Transfer',NULL),
(31,1,'Alat tulis kantor',NULL,NULL,200000,6,'2023-10-01','Transfer',NULL),
(32,1,'Alat tulis kantor',NULL,NULL,200000,7,'2023-11-01','Transfer',NULL),
(33,1,'Alat tulis kantor',NULL,NULL,200000,8,'2023-12-01','Transfer',NULL),
(34,1,'Alat tulis kantor',NULL,NULL,200000,9,'2024-01-01','Transfer',NULL),
(35,1,'Alat tulis kantor',NULL,NULL,200000,10,'2024-02-01','Transfer',NULL),
(36,1,'Alat tulis kantor',NULL,NULL,200000,11,'2024-03-01','Transfer',NULL),
(37,1,'Alat tulis kantor',NULL,NULL,200000,12,'2024-04-01','Transfer',NULL),
(38,1,'Alat tulis kantor',NULL,NULL,200000,13,'2024-05-01','Transfer',NULL),
(39,1,'Alat tulis kantor',NULL,NULL,200000,14,'2024-06-01','Transfer',NULL),
(40,1,'Alat tulis kantor',NULL,NULL,200000,15,'2024-07-01','Transfer',NULL),
(41,1,'Alat tulis kantor',NULL,NULL,200000,16,'2024-08-01','Transfer',NULL),
(42,1,'Alat tulis kantor',NULL,NULL,200000,17,'2024-09-01','Transfer',NULL),
(43,1,'Alat tulis kantor',NULL,NULL,200000,18,'2024-10-01','Transfer',NULL),
(44,1,'Alat tulis kantor',NULL,NULL,200000,19,'2024-11-01','Transfer',NULL),
(45,1,'Alat tulis kantor',NULL,NULL,200000,20,'2024-12-01','Transfer',NULL),
(46,1,'Alat tulis kantor',NULL,NULL,200000,21,'2025-01-01','Transfer',NULL),
(47,1,'Foto copy dokumen',NULL,NULL,200000,4,'2023-08-01','Transfer',NULL),
(48,1,'Foto copy dokumen',NULL,NULL,200000,5,'2023-09-01','Transfer',NULL),
(49,1,'Foto copy dokumen',NULL,NULL,200000,6,'2023-10-01','Transfer',NULL),
(50,1,'Foto copy dokumen',NULL,NULL,200000,7,'2023-11-01','Transfer',NULL),
(51,1,'Foto copy dokumen',NULL,NULL,200000,8,'2023-12-01','Transfer',NULL),
(52,1,'Foto copy dokumen',NULL,NULL,200000,9,'2024-01-01','Transfer',NULL),
(53,1,'Foto copy dokumen',NULL,NULL,200000,10,'2024-02-01','Transfer',NULL),
(54,1,'Foto copy dokumen',NULL,NULL,200000,11,'2024-03-01','Transfer',NULL),
(55,1,'Foto copy dokumen',NULL,NULL,200000,12,'2024-04-01','Transfer',NULL),
(56,1,'Foto copy dokumen',NULL,NULL,200000,13,'2024-05-01','Transfer',NULL),
(57,1,'Foto copy dokumen',NULL,NULL,200000,14,'2024-06-01','Transfer',NULL),
(58,1,'Foto copy dokumen',NULL,NULL,200000,15,'2024-07-01','Transfer',NULL),
(59,1,'Foto copy dokumen',NULL,NULL,200000,16,'2024-08-01','Transfer',NULL),
(60,1,'Foto copy dokumen',NULL,NULL,200000,17,'2024-09-01','Transfer',NULL),
(61,1,'Foto copy dokumen',NULL,NULL,200000,18,'2024-10-01','Transfer',NULL),
(62,1,'Foto copy dokumen',NULL,NULL,200000,19,'2024-11-01','Transfer',NULL),
(63,1,'Foto copy dokumen',NULL,NULL,200000,20,'2024-12-01','Transfer',NULL),
(64,1,'Foto copy dokumen',NULL,NULL,200000,21,'2025-01-01','Transfer',NULL),
(65,1,'Akomodasi & Transportasi',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(66,1,'Benda pos',NULL,NULL,200000,4,'2023-08-01','Transfer',NULL),
(67,1,'Benda pos',NULL,NULL,200000,5,'2023-09-01','Transfer',NULL),
(68,1,'Benda pos',NULL,NULL,200000,6,'2023-10-01','Transfer',NULL),
(69,1,'Benda pos',NULL,NULL,200000,7,'2023-11-01','Transfer',NULL),
(70,1,'Benda pos',NULL,NULL,200000,8,'2023-12-01','Transfer',NULL),
(71,1,'Benda pos',NULL,NULL,200000,9,'2024-01-01','Transfer',NULL),
(72,1,'Benda pos',NULL,NULL,200000,10,'2024-02-01','Transfer',NULL),
(73,1,'Benda pos',NULL,NULL,200000,11,'2024-03-01','Transfer',NULL),
(74,1,'Benda pos',NULL,NULL,200000,12,'2024-04-01','Transfer',NULL),
(75,1,'Benda pos',NULL,NULL,200000,13,'2024-05-01','Transfer',NULL),
(76,1,'Benda pos',NULL,NULL,200000,14,'2024-06-01','Transfer',NULL),
(77,1,'Benda pos',NULL,NULL,200000,15,'2024-07-01','Transfer',NULL),
(78,1,'Benda pos',NULL,NULL,200000,16,'2024-08-01','Transfer',NULL),
(79,1,'Benda pos',NULL,NULL,200000,17,'2024-09-01','Transfer',NULL),
(80,1,'Benda pos',NULL,NULL,200000,18,'2024-10-01','Transfer',NULL),
(81,1,'Benda pos',NULL,NULL,200000,19,'2024-11-01','Transfer',NULL),
(82,1,'Benda pos',NULL,NULL,200000,20,'2024-12-01','Transfer',NULL),
(83,1,'Benda pos',NULL,NULL,200000,21,'2025-01-01','Transfer',NULL),
(84,1,'Servis Komputer',NULL,NULL,150000,4,'2023-08-01','Transfer',NULL),
(85,1,'Servis Komputer',NULL,NULL,150000,5,'2023-09-01','Transfer',NULL),
(86,1,'Servis Komputer',NULL,NULL,150000,6,'2023-10-01','Transfer',NULL),
(87,1,'Servis Komputer',NULL,NULL,150000,7,'2023-11-01','Transfer',NULL),
(88,1,'Servis Komputer',NULL,NULL,150000,8,'2023-12-01','Transfer',NULL),
(89,1,'Servis Komputer',NULL,NULL,150000,9,'2024-01-01','Transfer',NULL),
(90,1,'Servis Komputer',NULL,NULL,150000,10,'2024-02-01','Transfer',NULL),
(91,1,'Servis Komputer',NULL,NULL,150000,11,'2024-03-01','Transfer',NULL),
(92,1,'Servis Komputer',NULL,NULL,150000,12,'2024-04-01','Transfer',NULL),
(93,1,'Servis Komputer',NULL,NULL,150000,13,'2024-05-01','Transfer',NULL),
(94,1,'Servis Komputer',NULL,NULL,150000,14,'2024-06-01','Transfer',NULL),
(95,1,'Servis Komputer',NULL,NULL,150000,15,'2024-07-01','Transfer',NULL),
(96,1,'Servis Komputer',NULL,NULL,150000,16,'2024-08-01','Transfer',NULL),
(97,1,'Servis Komputer',NULL,NULL,150000,17,'2024-09-01','Transfer',NULL),
(98,1,'Servis Komputer',NULL,NULL,150000,18,'2024-10-01','Transfer',NULL),
(99,1,'Servis Komputer',NULL,NULL,150000,19,'2024-11-01','Transfer',NULL),
(100,1,'Servis Komputer',NULL,NULL,150000,20,'2024-12-01','Transfer',NULL),
(101,1,'Servis Komputer',NULL,NULL,150000,21,'2025-01-01','Transfer',NULL),
(102,1,'Biaya Bank',NULL,NULL,200000,4,'2023-08-01','Transfer',NULL),
(103,1,'Biaya Bank',NULL,NULL,200000,5,'2023-09-01','Transfer',NULL),
(104,1,'Biaya Bank',NULL,NULL,200000,6,'2023-10-01','Transfer',NULL),
(105,1,'Biaya Bank',NULL,NULL,200000,7,'2023-11-01','Transfer',NULL),
(106,1,'Biaya Bank',NULL,NULL,200000,8,'2023-12-01','Transfer',NULL),
(107,1,'Biaya Bank',NULL,NULL,200000,9,'2024-01-01','Transfer',NULL),
(108,1,'Biaya Bank',NULL,NULL,200000,10,'2024-02-01','Transfer',NULL),
(109,1,'Biaya Bank',NULL,NULL,200000,11,'2024-03-01','Transfer',NULL),
(110,1,'Biaya Bank',NULL,NULL,200000,12,'2024-04-01','Transfer',NULL),
(111,1,'Biaya Bank',NULL,NULL,200000,13,'2024-05-01','Transfer',NULL),
(112,1,'Biaya Bank',NULL,NULL,200000,14,'2024-06-01','Transfer',NULL),
(113,1,'Biaya Bank',NULL,NULL,200000,15,'2024-07-01','Transfer',NULL),
(114,1,'Biaya Bank',NULL,NULL,200000,16,'2024-08-01','Transfer',NULL),
(115,1,'Biaya Bank',NULL,NULL,200000,17,'2024-09-01','Transfer',NULL),
(116,1,'Biaya Bank',NULL,NULL,200000,18,'2024-10-01','Transfer',NULL),
(117,1,'Biaya Bank',NULL,NULL,200000,19,'2024-11-01','Transfer',NULL),
(118,1,'Biaya Bank',NULL,NULL,200000,20,'2024-12-01','Transfer',NULL),
(119,1,'Biaya Bank',NULL,NULL,200000,21,'2025-01-01','Transfer',NULL),
(120,1,'Telepon / Internet',NULL,NULL,500000,4,'2023-08-01','Transfer',NULL),
(121,1,'Telepon / Internet',NULL,NULL,500000,5,'2023-09-01','Transfer',NULL),
(122,1,'Telepon / Internet',NULL,NULL,500000,6,'2023-10-01','Transfer',NULL),
(123,1,'Telepon / Internet',NULL,NULL,500000,7,'2023-11-01','Transfer',NULL),
(124,1,'Telepon / Internet',NULL,NULL,500000,8,'2023-12-01','Transfer',NULL),
(125,1,'Telepon / Internet',NULL,NULL,500000,9,'2024-01-01','Transfer',NULL),
(126,1,'Telepon / Internet',NULL,NULL,500000,10,'2024-02-01','Transfer',NULL),
(127,1,'Telepon / Internet',NULL,NULL,500000,11,'2024-03-01','Transfer',NULL),
(128,1,'Telepon / Internet',NULL,NULL,500000,12,'2024-04-01','Transfer',NULL),
(129,1,'Telepon / Internet',NULL,NULL,500000,13,'2024-05-01','Transfer',NULL),
(130,1,'Telepon / Internet',NULL,NULL,500000,14,'2024-06-01','Transfer',NULL),
(131,1,'Telepon / Internet',NULL,NULL,500000,15,'2024-07-01','Transfer',NULL),
(132,1,'Telepon / Internet',NULL,NULL,500000,16,'2024-08-01','Transfer',NULL),
(133,1,'Telepon / Internet',NULL,NULL,500000,17,'2024-09-01','Transfer',NULL),
(134,1,'Telepon / Internet',NULL,NULL,500000,18,'2024-10-01','Transfer',NULL),
(135,1,'Telepon / Internet',NULL,NULL,500000,19,'2024-11-01','Transfer',NULL),
(136,1,'Telepon / Internet',NULL,NULL,500000,20,'2024-12-01','Transfer',NULL),
(137,1,'Telepon / Internet',NULL,NULL,500000,21,'2025-01-01','Transfer',NULL),
(138,1,'Listrik',NULL,NULL,400000,4,'2023-08-01','Transfer',NULL),
(139,1,'Listrik',NULL,NULL,400000,5,'2023-09-01','Transfer',NULL),
(140,1,'Listrik',NULL,NULL,400000,6,'2023-10-01','Transfer',NULL),
(141,1,'Listrik',NULL,NULL,400000,7,'2023-11-01','Transfer',NULL),
(142,1,'Listrik',NULL,NULL,400000,8,'2023-12-01','Transfer',NULL),
(143,1,'Listrik',NULL,NULL,400000,9,'2024-01-01','Transfer',NULL),
(144,1,'Listrik',NULL,NULL,400000,10,'2024-02-01','Transfer',NULL),
(145,1,'Listrik',NULL,NULL,400000,11,'2024-03-01','Transfer',NULL),
(146,1,'Listrik',NULL,NULL,400000,12,'2024-04-01','Transfer',NULL),
(147,1,'Listrik',NULL,NULL,400000,13,'2024-05-01','Transfer',NULL),
(148,1,'Listrik',NULL,NULL,400000,14,'2024-06-01','Transfer',NULL),
(149,1,'Listrik',NULL,NULL,400000,15,'2024-07-01','Transfer',NULL),
(150,1,'Listrik',NULL,NULL,400000,16,'2024-08-01','Transfer',NULL),
(151,1,'Listrik',NULL,NULL,400000,17,'2024-09-01','Transfer',NULL),
(152,1,'Listrik',NULL,NULL,400000,18,'2024-10-01','Transfer',NULL),
(153,1,'Listrik',NULL,NULL,400000,19,'2024-11-01','Transfer',NULL),
(154,1,'Listrik',NULL,NULL,400000,20,'2024-12-01','Transfer',NULL),
(155,1,'Listrik',NULL,NULL,400000,21,'2025-01-01','Transfer',NULL),
(156,1,'Perawatan kantor',NULL,NULL,200000,4,'2023-08-01','Transfer',NULL),
(157,1,'Perawatan kantor',NULL,NULL,200000,5,'2023-09-01','Transfer',NULL),
(158,1,'Perawatan kantor',NULL,NULL,200000,6,'2023-10-01','Transfer',NULL),
(159,1,'Perawatan kantor',NULL,NULL,200000,7,'2023-11-01','Transfer',NULL),
(160,1,'Perawatan kantor',NULL,NULL,200000,8,'2023-12-01','Transfer',NULL),
(161,1,'Perawatan kantor',NULL,NULL,200000,9,'2024-01-01','Transfer',NULL),
(162,1,'Perawatan kantor',NULL,NULL,200000,10,'2024-02-01','Transfer',NULL),
(163,1,'Perawatan kantor',NULL,NULL,200000,11,'2024-03-01','Transfer',NULL),
(164,1,'Perawatan kantor',NULL,NULL,200000,12,'2024-04-01','Transfer',NULL),
(165,1,'Perawatan kantor',NULL,NULL,200000,13,'2024-05-01','Transfer',NULL),
(166,1,'Perawatan kantor',NULL,NULL,200000,14,'2024-06-01','Transfer',NULL),
(167,1,'Perawatan kantor',NULL,NULL,200000,15,'2024-07-01','Transfer',NULL),
(168,1,'Perawatan kantor',NULL,NULL,200000,16,'2024-08-01','Transfer',NULL),
(169,1,'Perawatan kantor',NULL,NULL,200000,17,'2024-09-01','Transfer',NULL),
(170,1,'Perawatan kantor',NULL,NULL,200000,18,'2024-10-01','Transfer',NULL),
(171,1,'Perawatan kantor',NULL,NULL,200000,19,'2024-11-01','Transfer',NULL),
(172,1,'Perawatan kantor',NULL,NULL,200000,20,'2024-12-01','Transfer',NULL),
(173,1,'Perawatan kantor',NULL,NULL,200000,21,'2025-01-01','Transfer',NULL),
(174,1,'Rumah tangga kantor',NULL,NULL,300000,4,'2023-08-01','Transfer',NULL),
(175,1,'Rumah tangga kantor',NULL,NULL,300000,5,'2023-09-01','Transfer',NULL),
(176,1,'Rumah tangga kantor',NULL,NULL,300000,6,'2023-10-01','Transfer',NULL),
(177,1,'Rumah tangga kantor',NULL,NULL,300000,7,'2023-11-01','Transfer',NULL),
(178,1,'Rumah tangga kantor',NULL,NULL,300000,8,'2023-12-01','Transfer',NULL),
(179,1,'Rumah tangga kantor',NULL,NULL,300000,9,'2024-01-01','Transfer',NULL),
(180,1,'Rumah tangga kantor',NULL,NULL,300000,10,'2024-02-01','Transfer',NULL),
(181,1,'Rumah tangga kantor',NULL,NULL,300000,11,'2024-03-01','Transfer',NULL),
(182,1,'Rumah tangga kantor',NULL,NULL,300000,12,'2024-04-01','Transfer',NULL),
(183,1,'Rumah tangga kantor',NULL,NULL,300000,13,'2024-05-01','Transfer',NULL),
(184,1,'Rumah tangga kantor',NULL,NULL,300000,14,'2024-06-01','Transfer',NULL),
(185,1,'Rumah tangga kantor',NULL,NULL,300000,15,'2024-07-01','Transfer',NULL),
(186,1,'Rumah tangga kantor',NULL,NULL,300000,16,'2024-08-01','Transfer',NULL),
(187,1,'Rumah tangga kantor',NULL,NULL,300000,17,'2024-09-01','Transfer',NULL),
(188,1,'Rumah tangga kantor',NULL,NULL,300000,18,'2024-10-01','Transfer',NULL),
(189,1,'Rumah tangga kantor',NULL,NULL,300000,19,'2024-11-01','Transfer',NULL),
(190,1,'Rumah tangga kantor',NULL,NULL,300000,20,'2024-12-01','Transfer',NULL),
(191,1,'Rumah tangga kantor',NULL,NULL,300000,21,'2025-01-01','Transfer',NULL),
(192,1,'Pajak / sumbangan',NULL,NULL,500000,4,'2023-08-01','Transfer',NULL),
(193,1,'Pajak / sumbangan',NULL,NULL,500000,5,'2023-09-01','Transfer',NULL),
(194,1,'Pajak / sumbangan',NULL,NULL,500000,6,'2023-10-01','Transfer',NULL),
(195,1,'Pajak / sumbangan',NULL,NULL,500000,7,'2023-11-01','Transfer',NULL),
(196,1,'Pajak / sumbangan',NULL,NULL,500000,8,'2023-12-01','Transfer',NULL),
(197,1,'Pajak / sumbangan',NULL,NULL,500000,9,'2024-01-01','Transfer',NULL),
(198,1,'Pajak / sumbangan',NULL,NULL,500000,10,'2024-02-01','Transfer',NULL),
(199,1,'Pajak / sumbangan',NULL,NULL,500000,11,'2024-03-01','Transfer',NULL),
(200,1,'Pajak / sumbangan',NULL,NULL,500000,12,'2024-04-01','Transfer',NULL),
(201,1,'Pajak / sumbangan',NULL,NULL,500000,13,'2024-05-01','Transfer',NULL),
(202,1,'Pajak / sumbangan',NULL,NULL,500000,14,'2024-06-01','Transfer',NULL),
(203,1,'Pajak / sumbangan',NULL,NULL,500000,15,'2024-07-01','Transfer',NULL),
(204,1,'Pajak / sumbangan',NULL,NULL,500000,16,'2024-08-01','Transfer',NULL),
(205,1,'Pajak / sumbangan',NULL,NULL,500000,17,'2024-09-01','Transfer',NULL),
(206,1,'Pajak / sumbangan',NULL,NULL,500000,18,'2024-10-01','Transfer',NULL),
(207,1,'Pajak / sumbangan',NULL,NULL,500000,19,'2024-11-01','Transfer',NULL),
(208,1,'Pajak / sumbangan',NULL,NULL,500000,20,'2024-12-01','Transfer',NULL),
(209,1,'Pajak / sumbangan',NULL,NULL,500000,21,'2025-01-01','Transfer',NULL),
(210,1,'Lain - lain',NULL,NULL,500000,4,'2023-08-01','Transfer',NULL),
(211,1,'Lain - lain',NULL,NULL,500000,5,'2023-09-01','Transfer',NULL),
(212,1,'Lain - lain',NULL,NULL,500000,6,'2023-10-01','Transfer',NULL),
(213,1,'Lain - lain',NULL,NULL,500000,7,'2023-11-01','Transfer',NULL),
(214,1,'Lain - lain',NULL,NULL,500000,8,'2023-12-01','Transfer',NULL),
(215,1,'Lain - lain',NULL,NULL,500000,9,'2024-01-01','Transfer',NULL),
(216,1,'Lain - lain',NULL,NULL,500000,10,'2024-02-01','Transfer',NULL),
(217,1,'Lain - lain',NULL,NULL,500000,11,'2024-03-01','Transfer',NULL),
(218,1,'Lain - lain',NULL,NULL,500000,12,'2024-04-01','Transfer',NULL),
(219,1,'Lain - lain',NULL,NULL,500000,13,'2024-05-01','Transfer',NULL),
(220,1,'Lain - lain',NULL,NULL,500000,14,'2024-06-01','Transfer',NULL),
(221,1,'Lain - lain',NULL,NULL,500000,15,'2024-07-01','Transfer',NULL),
(222,1,'Lain - lain',NULL,NULL,500000,16,'2024-08-01','Transfer',NULL),
(223,1,'Lain - lain',NULL,NULL,500000,17,'2024-09-01','Transfer',NULL),
(224,1,'Lain - lain',NULL,NULL,500000,18,'2024-10-01','Transfer',NULL),
(225,1,'Lain - lain',NULL,NULL,500000,19,'2024-11-01','Transfer',NULL),
(226,1,'Lain - lain',NULL,NULL,500000,20,'2024-12-01','Transfer',NULL),
(227,1,'Lain - lain',NULL,NULL,500000,21,'2025-01-01','Transfer',NULL),
(228,1,'Bahan bakar',NULL,NULL,500000,4,'2023-08-01','Transfer',NULL),
(229,1,'Bahan bakar',NULL,NULL,500000,5,'2023-09-01','Transfer',NULL),
(230,1,'Bahan bakar',NULL,NULL,500000,6,'2023-10-01','Transfer',NULL),
(231,1,'Bahan bakar',NULL,NULL,500000,7,'2023-11-01','Transfer',NULL),
(232,1,'Bahan bakar',NULL,NULL,500000,8,'2023-12-01','Transfer',NULL),
(233,1,'Bahan bakar',NULL,NULL,500000,9,'2024-01-01','Transfer',NULL),
(234,1,'Bahan bakar',NULL,NULL,500000,10,'2024-02-01','Transfer',NULL),
(235,1,'Bahan bakar',NULL,NULL,500000,11,'2024-03-01','Transfer',NULL),
(236,1,'Bahan bakar',NULL,NULL,500000,12,'2024-04-01','Transfer',NULL),
(237,1,'Bahan bakar',NULL,NULL,500000,13,'2024-05-01','Transfer',NULL),
(238,1,'Bahan bakar',NULL,NULL,500000,14,'2024-06-01','Transfer',NULL),
(239,1,'Bahan bakar',NULL,NULL,500000,15,'2024-07-01','Transfer',NULL),
(240,1,'Bahan bakar',NULL,NULL,500000,16,'2024-08-01','Transfer',NULL),
(241,1,'Bahan bakar',NULL,NULL,500000,17,'2024-09-01','Transfer',NULL),
(242,1,'Bahan bakar',NULL,NULL,500000,18,'2024-10-01','Transfer',NULL),
(243,1,'Bahan bakar',NULL,NULL,500000,19,'2024-11-01','Transfer',NULL),
(244,1,'Bahan bakar',NULL,NULL,500000,20,'2024-12-01','Transfer',NULL),
(245,1,'Bahan bakar',NULL,NULL,500000,21,'2025-01-01','Transfer',NULL),
(246,1,'Olie',NULL,NULL,500000,5,'2023-09-01','Transfer',NULL),
(247,1,'Olie',NULL,NULL,500000,8,'2023-12-01','Transfer',NULL),
(248,1,'Olie',NULL,NULL,500000,11,'2024-03-01','Transfer',NULL),
(249,1,'Olie',NULL,NULL,500000,14,'2024-06-01','Transfer',NULL),
(250,1,'Olie',NULL,NULL,500000,17,'2024-09-01','Transfer',NULL),
(251,1,'Olie',NULL,NULL,500000,21,'2025-01-01','Transfer',NULL),
(252,1,'Service',NULL,NULL,1050000,5,'2023-09-01','Transfer',NULL),
(253,1,'Service',NULL,NULL,1050000,8,'2023-12-01','Transfer',NULL),
(254,1,'Service',NULL,NULL,1050000,11,'2024-03-01','Transfer',NULL),
(255,1,'Service',NULL,NULL,1050000,14,'2024-06-01','Transfer',NULL),
(256,1,'Service',NULL,NULL,1050000,17,'2024-09-01','Transfer',NULL),
(257,1,'Service',NULL,NULL,1050000,21,'2025-01-01','Transfer',NULL),
(258,1,'Suku cadang + ban',NULL,NULL,600000,2,'2023-06-01','Transfer',NULL),
(259,1,'Suku cadang + ban',NULL,NULL,600000,6,'2023-10-01','Transfer',NULL),
(260,1,'Suku cadang + ban',NULL,NULL,600000,10,'2024-02-01','Transfer',NULL),
(261,1,'Suku cadang + ban',NULL,NULL,600000,14,'2024-06-01','Transfer',NULL),
(262,1,'Suku cadang + ban',NULL,NULL,600000,18,'2024-10-01','Transfer',NULL),
(263,1,'Suku cadang + ban',NULL,NULL,600000,21,'2025-01-01','Transfer',NULL),
(264,1,'STNK',NULL,NULL,1500000,3,'2023-07-01','Transfer',NULL),
(265,1,'STNK',NULL,NULL,1500000,15,'2024-07-01','Transfer',NULL),
(284,1,'Manager Operasional',NULL,NULL,3000000,2,'2023-06-01','Transfer',NULL),
(285,1,'Manager Operasional',NULL,NULL,3000000,3,'2023-07-01','Transfer',NULL),
(286,1,'Manager Operasional',NULL,NULL,3000000,4,'2023-08-01','Transfer',NULL),
(287,1,'Manager Operasional',NULL,NULL,3000000,5,'2023-09-01','Transfer',NULL),
(288,1,'Manager Operasional',NULL,NULL,3000000,6,'2023-10-01','Transfer',NULL),
(289,1,'Manager Operasional',NULL,NULL,3000000,7,'2023-11-01','Transfer',NULL),
(290,1,'Manager Operasional',NULL,NULL,3000000,8,'2023-12-01','Transfer',NULL),
(291,1,'Manager Operasional',NULL,NULL,3000000,9,'2024-01-01','Transfer',NULL),
(292,1,'Manager Operasional',NULL,NULL,3000000,10,'2024-02-01','Transfer',NULL),
(293,1,'Manager Operasional',NULL,NULL,3000000,11,'2024-03-01','Transfer',NULL),
(294,1,'Manager Operasional',NULL,NULL,3000000,12,'2024-04-01','Transfer',NULL),
(295,1,'Manager Operasional',NULL,NULL,3000000,13,'2024-05-01','Transfer',NULL),
(296,1,'Manager Operasional',NULL,NULL,3000000,14,'2024-06-01','Transfer',NULL),
(297,1,'Manager Operasional',NULL,NULL,3000000,15,'2024-07-01','Transfer',NULL),
(298,1,'Manager Operasional',NULL,NULL,3000000,16,'2024-08-01','Transfer',NULL),
(299,1,'Manager Operasional',NULL,NULL,3000000,17,'2024-09-01','Transfer',NULL),
(300,1,'Manager Operasional',NULL,NULL,3000000,18,'2024-10-01','Transfer',NULL),
(301,1,'Manager Operasional',NULL,NULL,3000000,19,'2024-11-01','Transfer',NULL),
(302,1,'Keuangan',NULL,NULL,2500000,2,'2023-06-01','Transfer',NULL),
(303,1,'Keuangan',NULL,NULL,2500000,3,'2023-07-01','Transfer',NULL),
(304,1,'Keuangan',NULL,NULL,2500000,4,'2023-08-01','Transfer',NULL),
(305,1,'Keuangan',NULL,NULL,2500000,5,'2023-09-01','Transfer',NULL),
(306,1,'Keuangan',NULL,NULL,2500000,6,'2023-10-01','Transfer',NULL),
(307,1,'Keuangan',NULL,NULL,2500000,7,'2023-11-01','Transfer',NULL),
(308,1,'Keuangan',NULL,NULL,2500000,8,'2023-12-01','Transfer',NULL),
(309,1,'Keuangan',NULL,NULL,2500000,9,'2024-01-01','Transfer',NULL),
(310,1,'Keuangan',NULL,NULL,2500000,10,'2024-02-01','Transfer',NULL),
(311,1,'Keuangan',NULL,NULL,2500000,11,'2024-03-01','Transfer',NULL),
(312,1,'Keuangan',NULL,NULL,2500000,12,'2024-04-01','Transfer',NULL),
(313,1,'Keuangan',NULL,NULL,2500000,13,'2024-05-01','Transfer',NULL),
(314,1,'Keuangan',NULL,NULL,2500000,14,'2024-06-01','Transfer',NULL),
(315,1,'Keuangan',NULL,NULL,2500000,15,'2024-07-01','Transfer',NULL),
(316,1,'Keuangan',NULL,NULL,2500000,16,'2024-08-01','Transfer',NULL),
(317,1,'Keuangan',NULL,NULL,2500000,17,'2024-09-01','Transfer',NULL),
(318,1,'Keuangan',NULL,NULL,2500000,18,'2024-10-01','Transfer',NULL),
(319,1,'Keuangan',NULL,NULL,2500000,19,'2024-11-01','Transfer',NULL),
(320,1,'Pembangunan',NULL,NULL,2500000,2,'2023-06-01','Transfer',NULL),
(321,1,'Pembangunan',NULL,NULL,2500000,3,'2023-07-01','Transfer',NULL),
(322,1,'Pembangunan',NULL,NULL,2500000,4,'2023-08-01','Transfer',NULL),
(323,1,'Pembangunan',NULL,NULL,2500000,5,'2023-09-01','Transfer',NULL),
(324,1,'Pembangunan',NULL,NULL,2500000,6,'2023-10-01','Transfer',NULL),
(325,1,'Pembangunan',NULL,NULL,2500000,7,'2023-11-01','Transfer',NULL),
(326,1,'Pembangunan',NULL,NULL,2500000,8,'2023-12-01','Transfer',NULL),
(327,1,'Pembangunan',NULL,NULL,2500000,9,'2024-01-01','Transfer',NULL),
(328,1,'Pembangunan',NULL,NULL,2500000,10,'2024-02-01','Transfer',NULL),
(329,1,'Pembangunan',NULL,NULL,2500000,11,'2024-03-01','Transfer',NULL),
(330,1,'Pembangunan',NULL,NULL,2500000,12,'2024-04-01','Transfer',NULL),
(331,1,'Pembangunan',NULL,NULL,2500000,13,'2024-05-01','Transfer',NULL),
(332,1,'Pembangunan',NULL,NULL,2500000,14,'2024-06-01','Transfer',NULL),
(333,1,'Pembangunan',NULL,NULL,2500000,15,'2024-07-01','Transfer',NULL),
(334,1,'Pembangunan',NULL,NULL,2500000,16,'2024-08-01','Transfer',NULL),
(335,1,'Pembangunan',NULL,NULL,2500000,17,'2024-09-01','Transfer',NULL),
(336,1,'Pembangunan',NULL,NULL,2500000,18,'2024-10-01','Transfer',NULL),
(337,1,'Pembangunan',NULL,NULL,2500000,19,'2024-11-01','Transfer',NULL),
(338,1,'Arsitek penjualan',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(339,1,'Legal & pemberkasan',NULL,NULL,2500000,2,'2023-06-01','Transfer',NULL),
(340,1,'Legal & pemberkasan',NULL,NULL,2500000,3,'2023-07-01','Transfer',NULL),
(341,1,'Legal & pemberkasan',NULL,NULL,2500000,4,'2023-08-01','Transfer',NULL),
(342,1,'Legal & pemberkasan',NULL,NULL,2500000,5,'2023-09-01','Transfer',NULL),
(343,1,'Legal & pemberkasan',NULL,NULL,2500000,6,'2023-10-01','Transfer',NULL),
(344,1,'Legal & pemberkasan',NULL,NULL,2500000,7,'2023-11-01','Transfer',NULL),
(345,1,'Legal & pemberkasan',NULL,NULL,2500000,8,'2023-12-01','Transfer',NULL),
(346,1,'Legal & pemberkasan',NULL,NULL,2500000,9,'2024-01-01','Transfer',NULL),
(347,1,'Legal & pemberkasan',NULL,NULL,2500000,10,'2024-02-01','Transfer',NULL),
(348,1,'Legal & pemberkasan',NULL,NULL,2500000,11,'2024-03-01','Transfer',NULL),
(349,1,'Legal & pemberkasan',NULL,NULL,2500000,12,'2024-04-01','Transfer',NULL),
(350,1,'Legal & pemberkasan',NULL,NULL,2500000,13,'2024-05-01','Transfer',NULL),
(351,1,'Legal & pemberkasan',NULL,NULL,2500000,14,'2024-06-01','Transfer',NULL),
(352,1,'Legal & pemberkasan',NULL,NULL,2500000,15,'2024-07-01','Transfer',NULL),
(353,1,'Legal & pemberkasan',NULL,NULL,2500000,16,'2024-08-01','Transfer',NULL),
(354,1,'Legal & pemberkasan',NULL,NULL,2500000,17,'2024-09-01','Transfer',NULL),
(355,1,'Legal & pemberkasan',NULL,NULL,2500000,18,'2024-10-01','Transfer',NULL),
(356,1,'Legal & pemberkasan',NULL,NULL,2500000,19,'2024-11-01','Transfer',NULL),
(357,1,'Sales officer',NULL,NULL,2500000,2,'2023-06-01','Transfer',NULL),
(358,1,'Sales officer',NULL,NULL,2500000,3,'2023-07-01','Transfer',NULL),
(359,1,'Sales officer',NULL,NULL,2500000,4,'2023-08-01','Transfer',NULL),
(360,1,'Sales officer',NULL,NULL,2500000,5,'2023-09-01','Transfer',NULL),
(361,1,'Sales officer',NULL,NULL,2500000,6,'2023-10-01','Transfer',NULL),
(362,1,'Sales officer',NULL,NULL,2500000,7,'2023-11-01','Transfer',NULL),
(363,1,'Sales officer',NULL,NULL,2500000,8,'2023-12-01','Transfer',NULL),
(364,1,'Sales officer',NULL,NULL,2500000,9,'2024-01-01','Transfer',NULL),
(365,1,'Sales officer',NULL,NULL,2500000,10,'2024-02-01','Transfer',NULL),
(366,1,'Sales officer',NULL,NULL,2500000,11,'2024-03-01','Transfer',NULL),
(367,1,'Sales officer',NULL,NULL,2500000,12,'2024-04-01','Transfer',NULL),
(368,1,'Sales officer',NULL,NULL,2500000,13,'2024-05-01','Transfer',NULL),
(369,1,'Sales officer',NULL,NULL,2500000,14,'2024-06-01','Transfer',NULL),
(370,1,'Sales officer',NULL,NULL,2500000,15,'2024-07-01','Transfer',NULL),
(371,1,'Sales officer',NULL,NULL,2500000,16,'2024-08-01','Transfer',NULL),
(372,1,'Sales officer',NULL,NULL,2500000,17,'2024-09-01','Transfer',NULL),
(373,1,'Sales officer',NULL,NULL,2500000,18,'2024-10-01','Transfer',NULL),
(374,1,'Sales officer',NULL,NULL,2500000,19,'2024-11-01','Transfer',NULL),
(375,1,'Promo',NULL,NULL,500000,2,'2023-06-01','Transfer',NULL),
(376,1,'Promo',NULL,NULL,500000,3,'2023-07-01','Transfer',NULL),
(377,1,'Promo',NULL,NULL,500000,4,'2023-08-01','Transfer',NULL),
(378,1,'Promo',NULL,NULL,500000,5,'2023-09-01','Transfer',NULL),
(379,1,'Promo',NULL,NULL,500000,6,'2023-10-01','Transfer',NULL),
(380,1,'Promo',NULL,NULL,500000,7,'2023-11-01','Transfer',NULL),
(381,1,'Promo',NULL,NULL,500000,8,'2023-12-01','Transfer',NULL),
(382,1,'Promo',NULL,NULL,500000,9,'2024-01-01','Transfer',NULL),
(383,1,'Promo',NULL,NULL,500000,10,'2024-02-01','Transfer',NULL),
(384,1,'Promo',NULL,NULL,500000,11,'2024-03-01','Transfer',NULL),
(385,1,'Promo',NULL,NULL,500000,12,'2024-04-01','Transfer',NULL),
(386,1,'Promo',NULL,NULL,500000,13,'2024-05-01','Transfer',NULL),
(387,1,'Promo',NULL,NULL,500000,14,'2024-06-01','Transfer',NULL),
(388,1,'Promo',NULL,NULL,500000,15,'2024-07-01','Transfer',NULL),
(389,1,'Promo',NULL,NULL,500000,16,'2024-08-01','Transfer',NULL),
(390,1,'Promo',NULL,NULL,500000,17,'2024-09-01','Transfer',NULL),
(391,1,'Promo',NULL,NULL,500000,18,'2024-10-01','Transfer',NULL),
(392,1,'Promo',NULL,NULL,500000,19,'2024-11-01','Transfer',NULL),
(393,1,'Honor Santri Magang',NULL,NULL,4000000,2,'2023-06-01','Transfer',NULL),
(394,1,'Honor Santri Magang',NULL,NULL,4000000,3,'2023-07-01','Transfer',NULL),
(395,1,'Honor Santri Magang',NULL,NULL,4000000,4,'2023-08-01','Transfer',NULL),
(396,1,'Honor Santri Magang',NULL,NULL,4000000,5,'2023-09-01','Transfer',NULL),
(397,1,'Honor Santri Magang',NULL,NULL,4000000,6,'2023-10-01','Transfer',NULL),
(398,1,'Honor Santri Magang',NULL,NULL,4000000,7,'2023-11-01','Transfer',NULL),
(399,1,'Honor Santri Magang',NULL,NULL,4000000,8,'2023-12-01','Transfer',NULL),
(400,1,'Honor Santri Magang',NULL,NULL,4000000,9,'2024-01-01','Transfer',NULL),
(401,1,'Honor Santri Magang',NULL,NULL,4000000,10,'2024-02-01','Transfer',NULL),
(402,1,'Honor Santri Magang',NULL,NULL,4000000,11,'2024-03-01','Transfer',NULL),
(403,1,'Honor Santri Magang',NULL,NULL,4000000,12,'2024-04-01','Transfer',NULL),
(404,1,'Honor Santri Magang',NULL,NULL,4000000,13,'2024-05-01','Transfer',NULL),
(405,1,'Honor Santri Magang',NULL,NULL,4000000,14,'2024-06-01','Transfer',NULL),
(406,1,'Honor Santri Magang',NULL,NULL,4000000,15,'2024-07-01','Transfer',NULL),
(407,1,'Honor Santri Magang',NULL,NULL,4000000,16,'2024-08-01','Transfer',NULL),
(408,1,'Honor Santri Magang',NULL,NULL,4000000,17,'2024-09-01','Transfer',NULL),
(409,1,'Honor Santri Magang',NULL,NULL,4000000,18,'2024-10-01','Transfer',NULL),
(410,1,'Honor Santri Magang',NULL,NULL,4000000,19,'2024-11-01','Transfer',NULL),
(411,1,'THR',NULL,NULL,13000000,12,'2024-04-01','Transfer',NULL),
(412,1,'Makan Staf',NULL,NULL,4500000,2,'2023-06-01','Transfer',NULL),
(413,1,'Makan Staf',NULL,NULL,4500000,3,'2023-07-01','Transfer',NULL),
(414,1,'Makan Staf',NULL,NULL,4500000,4,'2023-08-01','Transfer',NULL),
(415,1,'Makan Staf',NULL,NULL,4500000,5,'2023-09-01','Transfer',NULL),
(416,1,'Makan Staf',NULL,NULL,4500000,6,'2023-10-01','Transfer',NULL),
(417,1,'Makan Staf',NULL,NULL,4500000,7,'2023-11-01','Transfer',NULL),
(418,1,'Makan Staf',NULL,NULL,4500000,8,'2023-12-01','Transfer',NULL),
(419,1,'Makan Staf',NULL,NULL,4500000,9,'2024-01-01','Transfer',NULL),
(420,1,'Makan Staf',NULL,NULL,4500000,10,'2024-02-01','Transfer',NULL),
(421,1,'Makan Staf',NULL,NULL,4500000,11,'2024-03-01','Transfer',NULL),
(422,1,'Makan Staf',NULL,NULL,4500000,12,'2024-04-01','Transfer',NULL),
(423,1,'Makan Staf',NULL,NULL,4500000,13,'2024-05-01','Transfer',NULL),
(424,1,'Makan Staf',NULL,NULL,4500000,14,'2024-06-01','Transfer',NULL),
(425,1,'Makan Staf',NULL,NULL,4500000,15,'2024-07-01','Transfer',NULL),
(426,1,'Makan Staf',NULL,NULL,4500000,16,'2024-08-01','Transfer',NULL),
(427,1,'Makan Staf',NULL,NULL,4500000,17,'2024-09-01','Transfer',NULL),
(428,1,'Makan Staf',NULL,NULL,4500000,18,'2024-10-01','Transfer',NULL),
(429,1,'Makan Staf',NULL,NULL,4500000,19,'2024-11-01','Transfer',NULL),
(430,1,'Study kelayakan proyek',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(431,1,'Proposal pendukung KPR bank',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(432,1,'Perencanaan',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(433,1,'Pembersihan lokasi',NULL,NULL,850000,1,'2023-05-01','Transfer',NULL),
(434,1,'Pembersihan lokasi',NULL,NULL,850000,2,'2023-06-01','Transfer',NULL),
(435,1,'Pembersihan lokasi',NULL,NULL,850000,3,'2023-07-01','Transfer',NULL),
(436,1,'Pembersihan lokasi',NULL,NULL,850000,4,'2023-08-01','Transfer',NULL),
(437,1,'Pembersihan lokasi',NULL,NULL,850000,5,'2023-09-01','Transfer',NULL),
(438,1,'Pembersihan lokasi',NULL,NULL,850000,6,'2023-10-01','Transfer',NULL),
(439,1,'Pembersihan lokasi',NULL,NULL,850000,7,'2023-11-01','Transfer',NULL),
(440,1,'Pembersihan lokasi',NULL,NULL,850000,8,'2023-12-01','Transfer',NULL),
(441,1,'Pembersihan lokasi',NULL,NULL,850000,9,'2024-01-01','Transfer',NULL),
(442,1,'Pembersihan lokasi',NULL,NULL,850000,10,'2024-02-01','Transfer',NULL),
(443,1,'Pembersihan lokasi',NULL,NULL,850000,11,'2024-03-01','Transfer',NULL),
(444,1,'Pembersihan lokasi',NULL,NULL,850000,12,'2024-04-01','Transfer',NULL),
(445,1,'Pembersihan lokasi',NULL,NULL,850000,13,'2024-05-01','Transfer',NULL),
(446,1,'Pembersihan lokasi',NULL,NULL,850000,14,'2024-06-01','Transfer',NULL),
(447,1,'Pemeliharaan lokasi',NULL,NULL,850000,5,'2023-09-01','Transfer',NULL),
(448,1,'Pemeliharaan lokasi',NULL,NULL,850000,6,'2023-10-01','Transfer',NULL),
(449,1,'Pemeliharaan lokasi',NULL,NULL,850000,7,'2023-11-01','Transfer',NULL),
(450,1,'Pemeliharaan lokasi',NULL,NULL,850000,8,'2023-12-01','Transfer',NULL),
(451,1,'Pemeliharaan lokasi',NULL,NULL,850000,9,'2024-01-01','Transfer',NULL),
(452,1,'Pemeliharaan lokasi',NULL,NULL,850000,10,'2024-02-01','Transfer',NULL),
(453,1,'Pemeliharaan lokasi',NULL,NULL,850000,11,'2024-03-01','Transfer',NULL),
(454,1,'Pemeliharaan lokasi',NULL,NULL,850000,12,'2024-04-01','Transfer',NULL),
(455,1,'Pemeliharaan lokasi',NULL,NULL,850000,13,'2024-05-01','Transfer',NULL),
(456,1,'Pemeliharaan lokasi',NULL,NULL,850000,14,'2024-06-01','Transfer',NULL),
(457,1,'Pemeliharaan lokasi',NULL,NULL,850000,15,'2024-07-01','Transfer',NULL),
(458,1,'Pemeliharaan lokasi',NULL,NULL,850000,16,'2024-08-01','Transfer',NULL),
(459,1,'Pemeliharaan lokasi',NULL,NULL,850000,17,'2024-09-01','Transfer',NULL),
(460,1,'Pemeliharaan lokasi',NULL,NULL,850000,18,'2024-10-01','Transfer',NULL),
(461,1,'Pemeliharaan lokasi',NULL,NULL,850000,19,'2024-11-01','Transfer',NULL),
(462,1,'Pengukuran kavling',NULL,NULL,500000,1,'2023-05-01','Transfer',NULL),
(463,1,'Partisipasi lingkungan',NULL,NULL,300000,3,'2023-07-01','Transfer',NULL),
(464,1,'Partisipasi lingkungan',NULL,NULL,300000,4,'2023-08-01','Transfer',NULL),
(465,1,'Partisipasi lingkungan',NULL,NULL,300000,5,'2023-09-01','Transfer',NULL),
(466,1,'Partisipasi lingkungan',NULL,NULL,300000,6,'2023-10-01','Transfer',NULL),
(467,1,'Partisipasi lingkungan',NULL,NULL,300000,7,'2023-11-01','Transfer',NULL),
(468,1,'Partisipasi lingkungan',NULL,NULL,300000,8,'2023-12-01','Transfer',NULL),
(469,1,'Partisipasi lingkungan',NULL,NULL,300000,9,'2024-01-01','Transfer',NULL),
(470,1,'Partisipasi lingkungan',NULL,NULL,300000,10,'2024-02-01','Transfer',NULL),
(471,1,'Partisipasi lingkungan',NULL,NULL,300000,11,'2024-03-01','Transfer',NULL),
(472,1,'Partisipasi lingkungan',NULL,NULL,300000,12,'2024-04-01','Transfer',NULL),
(473,1,'Partisipasi lingkungan',NULL,NULL,300000,13,'2024-05-01','Transfer',NULL),
(474,1,'Partisipasi lingkungan',NULL,NULL,300000,14,'2024-06-01','Transfer',NULL),
(475,1,'Partisipasi lingkungan',NULL,NULL,300000,15,'2024-07-01','Transfer',NULL),
(476,1,'Partisipasi lingkungan',NULL,NULL,300000,16,'2024-08-01','Transfer',NULL),
(477,1,'Partisipasi lingkungan',NULL,NULL,300000,17,'2024-09-01','Transfer',NULL),
(478,1,'Keamanan Lingkungan',NULL,NULL,750000,3,'2023-07-01','Transfer',NULL),
(479,1,'Keamanan Lingkungan',NULL,NULL,750000,4,'2023-08-01','Transfer',NULL),
(480,1,'Keamanan Lingkungan',NULL,NULL,750000,5,'2023-09-01','Transfer',NULL),
(481,1,'Keamanan Lingkungan',NULL,NULL,750000,6,'2023-10-01','Transfer',NULL),
(482,1,'Keamanan Lingkungan',NULL,NULL,750000,7,'2023-11-01','Transfer',NULL),
(483,1,'Keamanan Lingkungan',NULL,NULL,750000,8,'2023-12-01','Transfer',NULL),
(484,1,'Keamanan Lingkungan',NULL,NULL,750000,9,'2024-01-01','Transfer',NULL),
(485,1,'Keamanan Lingkungan',NULL,NULL,750000,10,'2024-02-01','Transfer',NULL),
(486,1,'Keamanan Lingkungan',NULL,NULL,750000,11,'2024-03-01','Transfer',NULL),
(487,1,'Keamanan Lingkungan',NULL,NULL,750000,12,'2024-04-01','Transfer',NULL),
(488,1,'Keamanan Lingkungan',NULL,NULL,750000,13,'2024-05-01','Transfer',NULL),
(489,1,'Keamanan Lingkungan',NULL,NULL,750000,14,'2024-06-01','Transfer',NULL),
(490,1,'Keamanan Lingkungan',NULL,NULL,750000,15,'2024-07-01','Transfer',NULL),
(491,1,'Keamanan Lingkungan',NULL,NULL,750000,16,'2024-08-01','Transfer',NULL),
(492,1,'Keamanan Lingkungan',NULL,NULL,750000,17,'2024-09-01','Transfer',NULL),
(493,1,'Gudang / barak kerja',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(494,1,'Peralatan proyek',NULL,NULL,500000,3,'2023-07-01','Transfer',NULL),
(495,1,'Peralatan proyek',NULL,NULL,500000,7,'2023-11-01','Transfer',NULL),
(496,1,'Peralatan proyek',NULL,NULL,500000,11,'2024-03-01','Transfer',NULL),
(497,1,'Peralatan proyek',NULL,NULL,500000,15,'2024-07-01','Transfer',NULL),
(498,1,'Material bantu',NULL,NULL,500000,3,'2023-07-01','Transfer',NULL),
(499,1,'Material bantu',NULL,NULL,500000,7,'2023-11-01','Transfer',NULL),
(500,1,'Material bantu',NULL,NULL,500000,11,'2024-03-01','Transfer',NULL),
(501,1,'Material bantu',NULL,NULL,500000,15,'2024-07-01','Transfer',NULL),
(502,1,'Tenaga harian proyek',NULL,NULL,500000,3,'2023-07-01','Transfer',NULL),
(503,1,'Tenaga harian proyek',NULL,NULL,500000,7,'2023-11-01','Transfer',NULL),
(504,1,'Tenaga harian proyek',NULL,NULL,500000,11,'2024-03-01','Transfer',NULL),
(505,1,'Tenaga harian proyek',NULL,NULL,500000,15,'2024-07-01','Transfer',NULL),
(506,1,'Papan nama proyek',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(507,1,'Billboard',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(508,1,'Sign board',NULL,NULL,5000000,3,'2023-07-01','Transfer',NULL),
(509,1,'Sign board',NULL,NULL,5000000,12,'2024-04-01','Transfer',NULL),
(510,1,'Rountag',NULL,NULL,2500000,3,'2023-07-01','Transfer',NULL),
(511,1,'Rountag',NULL,NULL,2500000,12,'2024-04-01','Transfer',NULL),
(512,1,'Spanduk',NULL,NULL,3000000,3,'2023-07-01','Transfer',NULL),
(513,1,'Spanduk',NULL,NULL,3000000,12,'2024-04-01','Transfer',NULL),
(514,1,'Spanduk',NULL,NULL,3000000,17,'2024-09-01','Transfer',NULL),
(515,1,'Umbul - Umbul',NULL,NULL,3000000,3,'2023-07-01','Transfer',NULL),
(516,1,'Umbul - Umbul',NULL,NULL,3000000,12,'2024-04-01','Transfer',NULL),
(517,1,'Umbul - Umbul',NULL,NULL,3000000,17,'2024-09-01','Transfer',NULL),
(518,1,'Brosur eklusive',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(519,1,'Brosur massal',NULL,NULL,1500000,3,'2023-07-01','Transfer',NULL),
(520,1,'Brosur massal',NULL,NULL,1500000,12,'2024-04-01','Transfer',NULL),
(521,1,'Brosur massal',NULL,NULL,1500000,15,'2024-07-01','Transfer',NULL),
(522,1,'Standing Banner',NULL,NULL,2000000,3,'2023-07-01','Transfer',NULL),
(523,1,'Standing Banner',NULL,NULL,2000000,12,'2024-04-01','Transfer',NULL),
(524,1,'Iklan kolom koran',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(525,1,'Iklan media sosial',NULL,NULL,1500000,3,'2023-07-01','Transfer',NULL),
(526,1,'Iklan media sosial',NULL,NULL,1500000,4,'2023-08-01','Transfer',NULL),
(527,1,'Iklan media sosial',NULL,NULL,1500000,5,'2023-09-01','Transfer',NULL),
(528,1,'Iklan media sosial',NULL,NULL,1500000,6,'2023-10-01','Transfer',NULL),
(529,1,'Iklan media sosial',NULL,NULL,1500000,7,'2023-11-01','Transfer',NULL),
(530,1,'Iklan media sosial',NULL,NULL,1500000,8,'2023-12-01','Transfer',NULL),
(531,1,'Iklan media sosial',NULL,NULL,1500000,9,'2024-01-01','Transfer',NULL),
(532,1,'Iklan media sosial',NULL,NULL,1500000,10,'2024-02-01','Transfer',NULL),
(533,1,'Iklan media sosial',NULL,NULL,1500000,11,'2024-03-01','Transfer',NULL),
(534,1,'Iklan media sosial',NULL,NULL,1500000,12,'2024-04-01','Transfer',NULL),
(535,1,'Iklan media sosial',NULL,NULL,1500000,13,'2024-05-01','Transfer',NULL),
(536,1,'Iklan media sosial',NULL,NULL,1500000,14,'2024-06-01','Transfer',NULL),
(537,1,'Iklan media sosial',NULL,NULL,1500000,15,'2024-07-01','Transfer',NULL),
(538,1,'Iklan media sosial',NULL,NULL,1500000,16,'2024-08-01','Transfer',NULL),
(539,1,'Iklan media sosial',NULL,NULL,1500000,17,'2024-09-01','Transfer',NULL),
(540,1,'Iklan media sosial',NULL,NULL,1500000,18,'2024-10-01','Transfer',NULL),
(541,1,'Iklan media sosial',NULL,NULL,1500000,19,'2024-11-01','Transfer',NULL),
(542,1,'Iklan media sosial',NULL,NULL,1500000,20,'2024-12-01','Transfer',NULL),
(543,1,'Media elektronik / radio',NULL,NULL,1250000,3,'2023-07-01','Transfer',NULL),
(544,1,'Media elektronik / radio',NULL,NULL,1250000,8,'2023-12-01','Transfer',NULL),
(545,1,'Media elektronik / radio',NULL,NULL,1250000,15,'2024-07-01','Transfer',NULL),
(546,1,'Pameran / event / Gathering',NULL,NULL,50000000,3,'2023-07-01','Transfer',NULL),
(547,1,'Maket / perspektif',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(548,1,'Seragam pemasaran',NULL,NULL,1000000,3,'2023-07-01','Transfer',NULL),
(549,1,'Seragam pemasaran',NULL,NULL,1000000,8,'2023-12-01','Transfer',NULL),
(550,1,'Seragam pemasaran',NULL,NULL,1000000,15,'2024-07-01','Transfer',NULL),
(551,1,'Display pameran',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(552,1,'Fee Manager Operasional',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(553,1,'Fee Bagian Keuangan',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(554,1,'Fee Bagian Pembangunan',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(555,1,'Fee Bagian Penjualan dan KPR',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(556,1,'Fee Prestasi  penjualan rumah',NULL,NULL,16304931,6,'2023-10-01','Transfer',NULL),
(557,1,'Fee Prestasi  penjualan rumah',NULL,NULL,16304931,7,'2023-11-01','Transfer',NULL),
(558,1,'Fee Prestasi  penjualan rumah',NULL,NULL,16304931,8,'2023-12-01','Transfer',NULL),
(559,1,'Fee Prestasi  penjualan rumah',NULL,NULL,16304931,9,'2024-01-01','Transfer',NULL),
(560,1,'Fee Prestasi  penjualan rumah',NULL,NULL,16304931,10,'2024-02-01','Transfer',NULL),
(561,1,'Fee Prestasi  penjualan rumah',NULL,NULL,16304931,11,'2024-03-01','Transfer',NULL),
(562,1,'Fee Prestasi  penjualan rumah',NULL,NULL,16304931,12,'2024-04-01','Transfer',NULL),
(563,1,'Fee Prestasi  penjualan rumah',NULL,NULL,16304931,13,'2024-05-01','Transfer',NULL),
(564,1,'Fee Prestasi  penjualan rumah',NULL,NULL,19565917,14,'2024-06-01','Transfer',NULL),
(565,1,'Fee Prestasi  penjualan rumah',NULL,NULL,16304931,15,'2024-07-01','Transfer',NULL),
(566,1,'Fee Prestasi  penjualan rumah',NULL,NULL,16304931,16,'2024-08-01','Transfer',NULL),
(567,1,'Fee Prestasi  penjualan rumah',NULL,NULL,16304931,17,'2024-09-01','Transfer',NULL),
(568,1,'Fee Prestasi  penjualan rumah',NULL,NULL,16304931,18,'2024-10-01','Transfer',NULL),
(569,1,'Fee Prestasi  penjualan rumah',NULL,NULL,16304931,19,'2024-11-01','Transfer',NULL),
(570,1,'Fee Prestasi  penjualan rumah',NULL,NULL,19565917,20,'2024-12-01','Transfer',NULL),
(571,1,'Fee Prestasi tahunan ',NULL,NULL,0,1,'2023-05-01',NULL,NULL),
(572,1,'Biaya Operasional Direksi',NULL,NULL,35856000,1,'2023-05-01',NULL,NULL);

--
-- Table structure for table `pengeluaran_hpp`
--

CREATE TABLE `pengeluaran_hpp` (
  `id` int(11) NOT NULL,
  `id_proyek` int(11) DEFAULT NULL,
  `pengeluaran` varchar(50) DEFAULT NULL,
  `head` varchar(50) DEFAULT NULL,
  `detil` varchar(100) DEFAULT NULL,
  `jumlah` decimal(43,0) NOT NULL DEFAULT 0,
  `bln` int(11) DEFAULT NULL,
  `tgl` date DEFAULT NULL,
  `payment` varchar(20) DEFAULT NULL,
  `ket` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pengeluaran_hpp`
--

INSERT INTO `pengeluaran_hpp` VALUES
(1,1,'Harga Dasar Tanah',NULL,NULL,315000000,0,'2023-05-01','Transfer',NULL),
(2,1,'Harga Dasar Tanah',NULL,NULL,500000000,3,'2023-06-01','Transfer',NULL),
(3,1,'Harga Dasar Tanah',NULL,NULL,415000000,4,'2023-09-01','Transfer',NULL),
(4,1,'Harga Dasar Tanah',NULL,NULL,586500000,8,'2024-01-01','Transfer',NULL),
(5,1,'Peta Kontur Tanah',NULL,NULL,5000000,2,'2023-07-01','Transfer',NULL),
(6,1,'Direksi Kit / Kantor Proyek',NULL,NULL,0,0,'2023-05-01','',NULL),
(7,1,'Pembersihan Lokasi',NULL,NULL,5000000,2,'2023-07-01','Transfer',NULL),
(8,1,'Cut and fill',NULL,NULL,20000000,2,'2023-07-01','Transfer',NULL),
(9,1,'Cut and Fill',NULL,NULL,20000000,3,'2023-08-01','Transfer',NULL),
(10,1,'Utzet / Pengukuran',NULL,NULL,2500000,2,'2023-07-01','Transfer',NULL),
(11,1,'Timbunan Tanah',NULL,NULL,20000000,3,'2023-06-01','Transfer',NULL),
(12,1,'Timbunan Tanah',NULL,NULL,20000000,4,'2023-09-01','Transfer',NULL),
(13,1,'Gerbang Perumahan',NULL,NULL,12500000,17,'2023-05-01','Transfer',NULL),
(14,1,'Gerbang Perumahan',NULL,NULL,12500000,18,'2024-11-01','Transfer',NULL),
(15,1,'Papan Nama Perumahan',NULL,NULL,10000000,17,'2023-05-01','Transfer',NULL),
(16,1,'Papan Nama Perumahan',NULL,NULL,10000000,18,'2024-11-01','Transfer',NULL),
(17,1,'Portal Perumahan',NULL,NULL,4250000,17,'2023-05-01','Transfer',NULL),
(18,1,'Portal Perumahan',NULL,NULL,4250000,18,'2024-11-01','Transfer',NULL),
(19,1,'Pos Satpam',NULL,NULL,6000000,17,'2023-05-01','Transfer',NULL),
(20,1,'Pos Satpam',NULL,NULL,6000000,18,'2024-11-01','Transfer',NULL),
(21,1,'Pondasi Talud',NULL,NULL,25000000,2,'2023-07-01','Transfer',NULL),
(22,1,'Pondasi Talud',NULL,NULL,25000000,3,'2023-08-01','Transfer',NULL),
(23,1,'Perkerasan Jalan',NULL,NULL,31925000,4,'2023-09-01','Transfer',NULL),
(24,1,'Perkerasan Jalan',NULL,NULL,31925000,6,'2023-11-01','Transfer',NULL),
(25,1,'Perkerasan Jalan',NULL,NULL,31925000,9,'2024-02-01','Transfer',NULL),
(26,1,'Perkerasan Jalan',NULL,NULL,31925000,12,'2024-05-01','Transfer',NULL),
(27,1,'Jalan Lingkungan Perumahan',NULL,NULL,153240000,15,'2024-08-01','Transfer',NULL),
(28,1,'Jalan Lingkungan Perumahan',NULL,NULL,153240000,16,'2024-09-01','Transfer',NULL),
(29,1,'Saluran Lingkungan',NULL,NULL,22326000,3,'2023-08-01','Transfer',NULL),
(30,1,'Saluran Lingkungan',NULL,NULL,22326000,5,'2023-10-01','Transfer',NULL),
(31,1,'Saluran Lingkungan',NULL,NULL,22326000,8,'2024-01-01','Transfer',NULL),
(32,1,'Saluran Lingkungan',NULL,NULL,22326000,11,'2024-04-01','Transfer',NULL),
(33,1,'Peresapan Lingkungan',NULL,NULL,15750000,3,'2023-08-01','Transfer',NULL),
(34,1,'Peresapan Lingkungan',NULL,NULL,15750000,5,'2023-10-01','Transfer',NULL),
(35,1,'Peresapan Lingkungan',NULL,NULL,15750000,8,'2024-01-01','Transfer',NULL),
(36,1,'Peresapan Lingkungan',NULL,NULL,15750000,11,'2024-04-01','Transfer',NULL),
(37,1,'Lampu Penerangan Jalan',NULL,NULL,7500000,17,'2024-10-01','Transfer',NULL),
(38,1,'Lampu Penerangan Jalan',NULL,NULL,7500000,18,'2024-11-01','Transfer',NULL),
(39,1,'Taman Perumahan',NULL,NULL,11100000,17,'2024-10-01','Transfer',NULL),
(40,1,'Taman Perumahan',NULL,NULL,11100000,18,'2024-11-01','Transfer',NULL),
(41,1,'Pohon Penghijauan',NULL,NULL,2500000,17,'2024-10-01','Transfer',NULL),
(42,1,'Pohon Penghijauan',NULL,NULL,2500000,18,'2024-11-01','Transfer',NULL),
(43,1,'Limbah Komunal',NULL,NULL,35000000,5,'2023-10-01','Transfer',NULL),
(44,1,'Limbah Komunal',NULL,NULL,35000000,6,'2023-11-01','Transfer',NULL),
(45,1,'Perbaikan jalan masuk',NULL,NULL,30000000,19,'2024-12-01','Transfer',NULL),
(46,1,'Perbaikan jalan masuk',NULL,NULL,30000000,20,'2025-01-01','Transfer',NULL),
(47,1,'Gerbang masuk',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(48,1,'Pagar Keliling / pagar maingate',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(49,1,'Drainase jalan masuk',NULL,NULL,9300000,19,'2024-12-01','Transfer',NULL),
(50,1,'Sarana ibadah ( perbaikan masjid )',NULL,NULL,37500000,16,'2024-09-01','Transfer',NULL),
(51,1,'Sarana ibadah ( perbaikan masjid )',NULL,NULL,37500000,17,'2024-10-01','Transfer',NULL),
(52,1,'Sarana ibadah ( perbaikan masjid )',NULL,NULL,37500000,18,'2024-11-01','Transfer',NULL),
(53,1,'Sarana Umum / Sosial',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(54,1,'Lapangan Olah Raga',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(55,1,'Penambahan daya listrik / trafo',NULL,NULL,30000000,4,'2023-09-01','Transfer',NULL),
(56,1,'Tiang jaringan Listrik',NULL,NULL,24500000,4,'2023-09-01','Transfer',NULL),
(57,1,'Patok BPN / batas kavling',NULL,NULL,5400000,1,'2023-06-01','Transfer',NULL),
(58,1,'Bak sampah',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(59,1,'Pondasi kavling',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(60,1,'Taman depan',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(61,1,'Penyambungan daya listrik rumah',NULL,NULL,10750000,5,'2023-10-01','Transfer',NULL),
(62,1,'Penyambungan daya listrik rumah',NULL,NULL,10750000,6,'2023-11-01','Transfer',NULL),
(63,1,'Penyambungan daya listrik rumah',NULL,NULL,10750000,7,'2023-12-01','Transfer',NULL),
(64,1,'Penyambungan daya listrik rumah',NULL,NULL,10750000,8,'2024-01-01','Transfer',NULL),
(65,1,'Penyambungan daya listrik rumah',NULL,NULL,10750000,9,'2024-02-01','Transfer',NULL),
(66,1,'Penyambungan daya listrik rumah',NULL,NULL,10750000,10,'2024-03-01','Transfer',NULL),
(67,1,'Penyambungan daya listrik rumah',NULL,NULL,10750000,11,'2024-04-01','Transfer',NULL),
(68,1,'Penyambungan daya listrik rumah',NULL,NULL,10750000,12,'2024-05-01','Transfer',NULL),
(69,1,'Penyambungan daya listrik rumah',NULL,NULL,12900000,13,'2024-06-01','Transfer',NULL),
(70,1,'Penyambungan daya listrik rumah',NULL,NULL,10750000,14,'2024-07-01','Transfer',NULL),
(71,1,'Penyambungan daya listrik rumah',NULL,NULL,10750000,15,'2024-08-01','Transfer',NULL),
(72,1,'Penyambungan daya listrik rumah',NULL,NULL,10750000,16,'2024-09-01','Transfer',NULL),
(73,1,'Penyambungan daya listrik rumah',NULL,NULL,10750000,17,'2024-10-01','Transfer',NULL),
(74,1,'Penyambungan daya listrik rumah',NULL,NULL,12900000,18,'2024-11-01','Transfer',NULL),
(75,1,'Instalasi rumah Gas Alam',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(76,1,'Instalasi rumah PDAM',NULL,NULL,108000000,0,'2023-05-01','Transfer',NULL),
(77,1,'Instalasi Internet',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(78,1,'Bangunan 1 lantai RUMAH SUBSIDI',NULL,NULL,200000000,2,'2023-07-01','Transfer',NULL),
(79,1,'Bangunan 1 lantai RUMAH SUBSIDI',NULL,NULL,300000000,3,'2023-08-01','Transfer',NULL),
(80,1,'Bangunan 1 lantai RUMAH SUBSIDI',NULL,NULL,300000000,4,'2023-09-01','Transfer',NULL),
(81,1,'Bangunan 1 lantai RUMAH SUBSIDI',NULL,NULL,300000000,5,'2023-10-01','Transfer',NULL),
(82,1,'Bangunan 1 lantai RUMAH SUBSIDI',NULL,NULL,300000000,6,'2023-11-01','Transfer',NULL),
(83,1,'Bangunan 1 lantai RUMAH SUBSIDI',NULL,NULL,300000000,7,'2023-12-01','Transfer',NULL),
(84,1,'Bangunan 1 lantai RUMAH SUBSIDI',NULL,NULL,300000000,8,'2024-01-01','Transfer',NULL),
(85,1,'Bangunan 1 lantai RUMAH SUBSIDI',NULL,NULL,320000000,9,'2024-02-01','Transfer',NULL),
(86,1,'Bangunan 1 lantai RUMAH SUBSIDI',NULL,NULL,320000000,10,'2024-03-01','Transfer',NULL),
(87,1,'Bangunan 1 lantai RUMAH SUBSIDI',NULL,NULL,320000000,11,'2024-04-01','Transfer',NULL),
(88,1,'Bangunan 1 lantai RUMAH SUBSIDI',NULL,NULL,300000000,12,'2024-05-01','Transfer',NULL),
(89,1,'Bangunan 1 lantai RUMAH SUBSIDI',NULL,NULL,300000000,13,'2024-06-01','Transfer',NULL),
(90,1,'Bangunan 1 lantai RUMAH SUBSIDI',NULL,NULL,320000000,14,'2024-07-01','Transfer',NULL),
(91,1,'Bangunan 1 lantai RUMAH SUBSIDI',NULL,NULL,220000000,15,'2024-08-01','Transfer',NULL),
(92,1,'Bangunan 1 lantai RUMAH SUBSIDI',NULL,NULL,120000000,16,'2024-09-01','Transfer',NULL),
(93,1,'Dana taktis sampai kecamatan',NULL,NULL,10000000,3,'2023-08-01','Transfer',NULL),
(94,1,'Fatwa Rencana Pengarahan Lokasi ( FRPL )',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(95,1,'Advice planning',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(96,1,'Ijin Lokasi / IPPT',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(97,1,'Rekomendasi dari pengairan / Peil banjir',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(98,1,'Pengesahan Site Plan / Ijin site plan',NULL,NULL,54487500,3,'2023-08-01','Transfer',NULL),
(99,1,'PBG',NULL,NULL,85200000,4,'2023-09-01','Transfer',NULL),
(100,1,'Jasa penghubung ',NULL,NULL,46656250,5,'2023-10-01','Transfer',NULL),
(101,1,'PBB tahunan periode proyek',NULL,NULL,12000000,3,'2023-08-01','Transfer',NULL),
(102,1,'Pemecahan PBB induk',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(103,1,'Biaya pologoro / pajak desa',NULL,NULL,18662500,3,'2023-08-01','Transfer',NULL),
(104,1,'Biaya pengeringan / Pendaratan',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(105,1,'Perikatan jual beli / kerjasama',NULL,NULL,6000000,3,'2023-08-01','Transfer',NULL),
(106,1,'Cover asuransi atas pembelian lahan',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(107,1,'Biaya Surat Kuasa Jual',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(108,1,'Biaya Balik Nama / AJB',NULL,NULL,10000000,3,'2023-08-01','Transfer',NULL),
(109,1,'BPHTB --->  5% x ( NJOP - 80 juta )',NULL,NULL,86825000,3,'2023-08-01','Transfer',NULL),
(110,1,'PPH --->  2,5% x NJOP ',NULL,NULL,4541200,3,'2023-08-01','Transfer',NULL),
(111,1,'Konversi lahan dari LC ke SHM',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(112,1,'Penggabungan sertifikat',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(113,1,'Penurunan menjadi SHGB ',NULL,NULL,125000000,3,'2023-08-01','Transfer',NULL),
(114,1,'Pengajuan peningkatan hak milik',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(115,1,'Pemecahan sertifikat',NULL,NULL,266000000,3,'2023-08-01','Transfer',NULL),
(116,1,'Tak Terduga / taktis',NULL,NULL,50000000,3,'2023-08-01','Transfer',NULL),
(117,1,'Akta Jual Beli / AJB',NULL,NULL,0,0,'2023-05-01',NULL,NULL),
(118,1,'PPH SUBSIDI',NULL,NULL,8300000,5,'2023-10-01','Transfer',NULL),
(119,1,'PPH SUBSIDI',NULL,NULL,8300000,6,'2023-11-01','Transfer',NULL),
(120,1,'PPH SUBSIDI',NULL,NULL,8300000,7,'2023-12-01','Transfer',NULL),
(121,1,'PPH SUBSIDI',NULL,NULL,8300000,8,'2024-01-01','Transfer',NULL),
(122,1,'PPH SUBSIDI',NULL,NULL,8300000,9,'2024-02-01','Transfer',NULL),
(123,1,'PPH SUBSIDI',NULL,NULL,8300000,10,'2024-03-01','Transfer',NULL),
(124,1,'PPH SUBSIDI',NULL,NULL,8300000,11,'2024-04-01','Transfer',NULL),
(125,1,'PPH SUBSIDI',NULL,NULL,8300000,12,'2024-05-01','Transfer',NULL),
(126,1,'PPH SUBSIDI',NULL,NULL,9960000,13,'2024-06-01','Transfer',NULL),
(127,1,'PPH SUBSIDI',NULL,NULL,8300000,14,'2024-07-01','Transfer',NULL),
(128,1,'PPH SUBSIDI',NULL,NULL,8300000,15,'2024-08-01','Transfer',NULL),
(129,1,'PPH SUBSIDI',NULL,NULL,8300000,16,'2024-09-01','Transfer',NULL),
(130,1,'PPH SUBSIDI',NULL,NULL,8300000,17,'2024-10-01','Transfer',NULL),
(131,1,'PPH SUBSIDI',NULL,NULL,9960000,18,'2024-11-01','Transfer',NULL);

--
-- Table structure for table `pengembalian_modal`
--

CREATE TABLE `pengembalian_modal` (
  `id` int(11) NOT NULL,
  `id_proyek` int(11) DEFAULT NULL,
  `pengembalian_modal` varchar(100) DEFAULT NULL,
  `jumlah` decimal(16,2) NOT NULL,
  `bln` int(11) DEFAULT NULL,
  `ket` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pengembalian_modal`
--

INSERT INTO `pengembalian_modal` VALUES
(1,1,'Pengembalian Modal Investasi Tanah',0.00,NULL,NULL),
(2,1,'Pengembalian Modal Kerja + Operasional',0.00,NULL,NULL);

--
-- Table structure for table `proyek`
--

CREATE TABLE `proyek` (
  `id` int(11) NOT NULL,
  `nama_proyek` varchar(50) DEFAULT NULL,
  `lokasi` varchar(100) DEFAULT NULL,
  `total_lt` int(11) DEFAULT NULL,
  `luas_jalan` int(11) DEFAULT NULL,
  `luas_taman` int(11) DEFAULT NULL,
  `lt_mushola` int(11) DEFAULT NULL,
  `tgl_mulai` date DEFAULT NULL,
  `tgt_selesai_proyek` int(11) DEFAULT NULL,
  `bgt_1lt_rs` int(11) DEFAULT NULL,
  `bgt_1lt_rk` int(11) DEFAULT NULL,
  `bgt_2lt_rk` int(11) DEFAULT NULL,
  `hg_m2_tanah` int(11) DEFAULT NULL,
  `ket` varchar(100) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `proyek`
--

INSERT INTO `proyek` VALUES
(1,'BALE TUANKU','SENTOLO - KULON PROGO',726,2324,444,143,'2023-09-01',18,2000000,0,0,250000,'PM Ario','Open');

--
-- Temporary table structure for view `query_bop_detail`
--

/*!50001 DROP VIEW IF EXISTS `query_bop_detail`*/;
/*!50001 CREATE VIEW `query_bop_detail` AS SELECT
 1 AS `id`,
  1 AS `id_proyek`,
  1 AS `kode_rab`,
  1 AS `uraian`,
  1 AS `volume_kumulatif`,
  1 AS `volume_kuantiti`,
  1 AS `unit`,
  1 AS `harga_satuan`,
  1 AS `ket`,
  1 AS `sub_jumlah` */;

--
-- Temporary table structure for view `query_bop_head`
--

/*!50001 DROP VIEW IF EXISTS `query_bop_head`*/;
/*!50001 CREATE VIEW `query_bop_head` AS SELECT
 1 AS `id_rab`,
  1 AS `id_proyek`,
  1 AS `nama_rab`,
  1 AS `ket` */;

--
-- Temporary table structure for view `query_bop_head_total`
--

/*!50001 DROP VIEW IF EXISTS `query_bop_head_total`*/;
/*!50001 CREATE VIEW `query_bop_head_total` AS SELECT
 1 AS `id_proyek`,
  1 AS `id_rab`,
  1 AS `nama_rab`,
  1 AS `ket`,
  1 AS `total_jumlah` */;

--
-- Temporary table structure for view `query_bop_persen`
--

/*!50001 DROP VIEW IF EXISTS `query_bop_persen`*/;
/*!50001 CREATE VIEW `query_bop_persen` AS SELECT
 1 AS `id_proyek`,
  1 AS `id_rab`,
  1 AS `persen` */;

--
-- Temporary table structure for view `query_cashflow_pembangunan`
--

/*!50001 DROP VIEW IF EXISTS `query_cashflow_pembangunan`*/;
/*!50001 CREATE VIEW `query_cashflow_pembangunan` AS SELECT
 1 AS `id`,
  1 AS `id_proyek`,
  1 AS `no_kavling`,
  1 AS `tot_bangun`,
  1 AS `mulai_bangun`,
  1 AS `bulan_1`,
  1 AS `bulan_2`,
  1 AS `bulan_3`,
  1 AS `bulan_4`,
  1 AS `bulan_5`,
  1 AS `bulan_6`,
  1 AS `bulan_7`,
  1 AS `bulan_8`,
  1 AS `bulan_9`,
  1 AS `bulan_10`,
  1 AS `bulan_11`,
  1 AS `bulan_12`,
  1 AS `bulan_13`,
  1 AS `bulan_14`,
  1 AS `bulan_15`,
  1 AS `bulan_16`,
  1 AS `bulan_17`,
  1 AS `bulan_18`,
  1 AS `bulan_19`,
  1 AS `bulan_20`,
  1 AS `bulan_21`,
  1 AS `bulan_22` */;

--
-- Temporary table structure for view `query_distribusi_biaya_hpp`
--

/*!50001 DROP VIEW IF EXISTS `query_distribusi_biaya_hpp`*/;
/*!50001 CREATE VIEW `query_distribusi_biaya_hpp` AS SELECT
 1 AS `id`,
  1 AS `id_proyek`,
  1 AS `no_kavling`,
  1 AS `lb`,
  1 AS `lt`,
  1 AS `ket`,
  1 AS `tanah_proyek`,
  1 AS `pengolahan_lahan`,
  1 AS `prasarana_sarana`,
  1 AS `kontruksi_rumah`,
  1 AS `perijinan_proyek`,
  1 AS `legalitas_proyek`,
  1 AS `legalitas_pjl_kav`,
  1 AS `hpp`,
  1 AS `harga_min_jual`,
  1 AS `laba_kotor`,
  1 AS `prosentase_laba` */;

--
-- Temporary table structure for view `query_distribusi_biaya_hpp_bop`
--

/*!50001 DROP VIEW IF EXISTS `query_distribusi_biaya_hpp_bop`*/;
/*!50001 CREATE VIEW `query_distribusi_biaya_hpp_bop` AS SELECT
 1 AS `id`,
  1 AS `id_proyek`,
  1 AS `no_kavling`,
  1 AS `lb`,
  1 AS `lt`,
  1 AS `ket`,
  1 AS `hpp`,
  1 AS `mgt_pengawasan`,
  1 AS `perlengkapan_ktr`,
  1 AS `operasional_ktr`,
  1 AS `operasional_proyek`,
  1 AS `operasional_pemasaran`,
  1 AS `biaya_operasional_proyek`,
  1 AS `hpp_plus_bop`,
  1 AS `harga_min_jual`,
  1 AS `laba_bersih_after_tax`,
  1 AS `persen_laba` */;

--
-- Temporary table structure for view `query_kas_pemasukan_penjualan`
--

/*!50001 DROP VIEW IF EXISTS `query_kas_pemasukan_penjualan`*/;
/*!50001 CREATE VIEW `query_kas_pemasukan_penjualan` AS SELECT
 1 AS `id`,
  1 AS `id_proyek`,
  1 AS `pemasukan`,
  1 AS `kum_act`,
  1 AS `Name_exp_5` */;

--
-- Temporary table structure for view `query_nilai_penerimaan_penjualan`
--

/*!50001 DROP VIEW IF EXISTS `query_nilai_penerimaan_penjualan`*/;
/*!50001 CREATE VIEW `query_nilai_penerimaan_penjualan` AS SELECT
 1 AS `id`,
  1 AS `nama_proyek`,
  1 AS `lokasi`,
  1 AS `nilai_penerimaan_penjualan`,
  1 AS `harga_pokok_produksi`,
  1 AS `biaya_operasional_kantor` */;

--
-- Temporary table structure for view `query_pemasukan_penjualan_act`
--

/*!50001 DROP VIEW IF EXISTS `query_pemasukan_penjualan_act`*/;
/*!50001 CREATE VIEW `query_pemasukan_penjualan_act` AS SELECT
 1 AS `id`,
  1 AS `id_proyek`,
  1 AS `pemasukan`,
  1 AS `act_bln_0`,
  1 AS `act_bln_1`,
  1 AS `act_bln_2`,
  1 AS `act_bln_3`,
  1 AS `act_bln_4`,
  1 AS `act_bln_5`,
  1 AS `act_bln_6`,
  1 AS `act_bln_7`,
  1 AS `act_bln_8`,
  1 AS `act_bln_9`,
  1 AS `act_bln_10`,
  1 AS `act_bln_11`,
  1 AS `act_bln_12`,
  1 AS `act_bln_13`,
  1 AS `act_bln_14`,
  1 AS `act_bln_15`,
  1 AS `act_bln_16`,
  1 AS `act_bln_17`,
  1 AS `act_bln_18`,
  1 AS `act_bln_19`,
  1 AS `act_bln_20`,
  1 AS `act_bln_21` */;

--
-- Temporary table structure for view `query_pemasukan_penjualan_tgt`
--

/*!50001 DROP VIEW IF EXISTS `query_pemasukan_penjualan_tgt`*/;
/*!50001 CREATE VIEW `query_pemasukan_penjualan_tgt` AS SELECT
 1 AS `id`,
  1 AS `id_proyek`,
  1 AS `tgt_bln_4`,
  1 AS `tgt_bln_5`,
  1 AS `tgt_bln_6`,
  1 AS `tgt_bln_7`,
  1 AS `tgt_bln_8`,
  1 AS `tgt_bln_9`,
  1 AS `tgt_bln_10`,
  1 AS `tgt_bln_11`,
  1 AS `tgt_bln_12`,
  1 AS `tgt_bln_13`,
  1 AS `tgt_bln_14`,
  1 AS `tgt_bln_15`,
  1 AS `tgt_bln_16`,
  1 AS `tgt_bln_17`,
  1 AS `tgt_bln_18`,
  1 AS `tgt_bln_19`,
  1 AS `tgt_bln_20`,
  1 AS `tgt_bln_21` */;

--
-- Temporary table structure for view `query_pendekatan_harga_jual`
--

/*!50001 DROP VIEW IF EXISTS `query_pendekatan_harga_jual`*/;
/*!50001 CREATE VIEW `query_pendekatan_harga_jual` AS SELECT
 1 AS `id`,
  1 AS `id_proyek`,
  1 AS `no_kavling`,
  1 AS `ket`,
  1 AS `kategori`,
  1 AS `lb`,
  1 AS `lt`,
  1 AS `hj_bangunan`,
  1 AS `hb_tanah`,
  1 AS `indeks_tanah`,
  1 AS `h_dasar`,
  1 AS `harga_tanah`,
  1 AS `harga_jual_raw`,
  1 AS `harga_jual`,
  1 AS `harga_kelebihan_tanah` */;

--
-- Temporary table structure for view `query_pengeluaran_bop`
--

/*!50001 DROP VIEW IF EXISTS `query_pengeluaran_bop`*/;
/*!50001 CREATE VIEW `query_pengeluaran_bop` AS SELECT
 1 AS `id`,
  1 AS `id_proyek`,
  1 AS `pengeluaran`,
  1 AS `act_bln_0`,
  1 AS `act_bln_1`,
  1 AS `act_bln_2`,
  1 AS `act_bln_3`,
  1 AS `act_bln_4`,
  1 AS `act_bln_5`,
  1 AS `act_bln_6`,
  1 AS `act_bln_7`,
  1 AS `act_bln_8`,
  1 AS `act_bln_9`,
  1 AS `act_bln_10`,
  1 AS `act_bln_11`,
  1 AS `act_bln_12`,
  1 AS `act_bln_13`,
  1 AS `act_bln_14`,
  1 AS `act_bln_15`,
  1 AS `act_bln_16`,
  1 AS `act_bln_17`,
  1 AS `act_bln_18`,
  1 AS `act_bln_19`,
  1 AS `act_bln_20`,
  1 AS `act_bln_21` */;

--
-- Temporary table structure for view `query_pengeluaran_hpp`
--

/*!50001 DROP VIEW IF EXISTS `query_pengeluaran_hpp`*/;
/*!50001 CREATE VIEW `query_pengeluaran_hpp` AS SELECT
 1 AS `id`,
  1 AS `id_proyek`,
  1 AS `pengeluaran`,
  1 AS `act_bln_0`,
  1 AS `act_bln_1`,
  1 AS `act_bln_2`,
  1 AS `act_bln_3`,
  1 AS `act_bln_4`,
  1 AS `act_bln_5`,
  1 AS `act_bln_6`,
  1 AS `act_bln_7`,
  1 AS `act_bln_8`,
  1 AS `act_bln_9`,
  1 AS `act_bln_10`,
  1 AS `act_bln_11`,
  1 AS `act_bln_12`,
  1 AS `act_bln_13`,
  1 AS `act_bln_14`,
  1 AS `act_bln_15`,
  1 AS `act_bln_16`,
  1 AS `act_bln_17`,
  1 AS `act_bln_18`,
  1 AS `act_bln_19`,
  1 AS `act_bln_20`,
  1 AS `act_bln_21` */;

--
-- Temporary table structure for view `query_pengembalian_modal`
--

/*!50001 DROP VIEW IF EXISTS `query_pengembalian_modal`*/;
/*!50001 CREATE VIEW `query_pengembalian_modal` AS SELECT
 1 AS `id`,
  1 AS `id_proyek`,
  1 AS `pengembalian_modal`,
  1 AS `bln_0`,
  1 AS `bln_1`,
  1 AS `bln_2`,
  1 AS `bln_3`,
  1 AS `bln_4`,
  1 AS `bln_5`,
  1 AS `bln_6`,
  1 AS `bln_7`,
  1 AS `bln_8`,
  1 AS `bln_9`,
  1 AS `bln_10`,
  1 AS `bln_11`,
  1 AS `bln_12`,
  1 AS `bln_13`,
  1 AS `bln_14`,
  1 AS `bln_15`,
  1 AS `bln_16`,
  1 AS `bln_17`,
  1 AS `bln_18`,
  1 AS `bln_19`,
  1 AS `bln_20`,
  1 AS `bln_21` */;

--
-- Temporary table structure for view `query_proyek`
--

/*!50001 DROP VIEW IF EXISTS `query_proyek`*/;
/*!50001 CREATE VIEW `query_proyek` AS SELECT
 1 AS `id`,
  1 AS `nama_proyek`,
  1 AS `lokasi`,
  1 AS `total_lt`,
  1 AS `luas_jalan`,
  1 AS `pc_jln`,
  1 AS `luas_taman`,
  1 AS `pc_tmn`,
  1 AS `lt_mushola`,
  1 AS `pc_msl`,
  1 AS `tgl_mulai`,
  1 AS `tgt_selesai_proyek`,
  1 AS `tanggal_selesai`,
  1 AS `bgt_1lt_rs`,
  1 AS `bgt_1lt_rk`,
  1 AS `bgt_2lt_rk`,
  1 AS `hg_m2_tanah`,
  1 AS `ket`,
  1 AS `status`,
  1 AS `ls_tot_kav`,
  1 AS `pc_kav`,
  1 AS `ls_tot_bgn`,
  1 AS `tot_ls_kav_komersil`,
  1 AS `tot_ls_kav_sub_plus`,
  1 AS `tot_ls_kav_subsidi`,
  1 AS `koef_db` */;

--
-- Temporary table structure for view `query_rab_detail`
--

/*!50001 DROP VIEW IF EXISTS `query_rab_detail`*/;
/*!50001 CREATE VIEW `query_rab_detail` AS SELECT
 1 AS `id`,
  1 AS `id_proyek`,
  1 AS `kode_rab`,
  1 AS `uraian`,
  1 AS `volume`,
  1 AS `unit`,
  1 AS `harga_satuan`,
  1 AS `sub Jumlah`,
  1 AS `ket` */;

--
-- Temporary table structure for view `query_rab_head`
--

/*!50001 DROP VIEW IF EXISTS `query_rab_head`*/;
/*!50001 CREATE VIEW `query_rab_head` AS SELECT
 1 AS `id_proyek`,
  1 AS `id_rab`,
  1 AS `nama_rab`,
  1 AS `ket` */;

--
-- Temporary table structure for view `query_rab_head_total`
--

/*!50001 DROP VIEW IF EXISTS `query_rab_head_total`*/;
/*!50001 CREATE VIEW `query_rab_head_total` AS SELECT
 1 AS `id_proyek`,
  1 AS `id_rab`,
  1 AS `nama_rab`,
  1 AS `ket`,
  1 AS `total_jumlah` */;

--
-- Temporary table structure for view `query_rab_persen`
--

/*!50001 DROP VIEW IF EXISTS `query_rab_persen`*/;
/*!50001 CREATE VIEW `query_rab_persen` AS SELECT
 1 AS `id_proyek`,
  1 AS `id_rab`,
  1 AS `persen` */;

--
-- Temporary table structure for view `query_rencana_modal`
--

/*!50001 DROP VIEW IF EXISTS `query_rencana_modal`*/;
/*!50001 CREATE VIEW `query_rencana_modal` AS SELECT
 1 AS `id`,
  1 AS `id_proyek`,
  1 AS `rencana_modal`,
  1 AS `bln_0`,
  1 AS `bln_1`,
  1 AS `bln_2`,
  1 AS `bln_3`,
  1 AS `bln_4`,
  1 AS `bln_5`,
  1 AS `bln_6`,
  1 AS `bln_7`,
  1 AS `bln_8`,
  1 AS `bln_9`,
  1 AS `bln_10`,
  1 AS `bln_11`,
  1 AS `bln_12`,
  1 AS `bln_13`,
  1 AS `bln_14`,
  1 AS `bln_15`,
  1 AS `bln_16`,
  1 AS `bln_17`,
  1 AS `bln_18`,
  1 AS `bln_19`,
  1 AS `bln_20`,
  1 AS `bln_21` */;

--
-- Temporary table structure for view `query_target_penjualan`
--

/*!50001 DROP VIEW IF EXISTS `query_target_penjualan`*/;
/*!50001 CREATE VIEW `query_target_penjualan` AS SELECT
 1 AS `id`,
  1 AS `id_proyek`,
  1 AS `no_kavling`,
  1 AS `lb`,
  1 AS `lt`,
  1 AS `harga_standar`,
  1 AS `bln_akad`,
  1 AS `retensi`,
  1 AS `harga_pricelist`,
  1 AS `sbum`,
  1 AS `bln_4`,
  1 AS `bln_5`,
  1 AS `bln_6`,
  1 AS `bln_7`,
  1 AS `bln_8`,
  1 AS `bln_9`,
  1 AS `bln_10`,
  1 AS `bln_11`,
  1 AS `bln_12`,
  1 AS `bln_13`,
  1 AS `bln_14`,
  1 AS `bln_15`,
  1 AS `bln_16`,
  1 AS `bln_17`,
  1 AS `bln_18`,
  1 AS `bln_19`,
  1 AS `bln_20`,
  1 AS `bln_21`,
  1 AS `bln_22` */;

--
-- Table structure for table `rab`
--

CREATE TABLE `rab` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_proyek` int(11) DEFAULT NULL,
  `kode_rab` varchar(5) DEFAULT NULL,
  `uraian` varchar(100) DEFAULT NULL,
  `volume` decimal(12,3) DEFAULT NULL,
  `unit` varchar(30) DEFAULT NULL,
  `harga_satuan` bigint(20) DEFAULT NULL,
  `ket` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `rab`
--

INSERT INTO `rab` VALUES
(1,1,'A','Harga dasar tanah',7266.000,'m2',250000,''),
(2,1,'B1','Peta kontur tanah',1.000,'LS',5000000,''),
(3,1,'B1','Direksi kit / kantor proyek',0.000,'',0,''),
(4,1,'B1','Pembersihan lokasi',1.000,'LS',5000000,''),
(5,1,'B1','Cut and fill',1.000,'LS',40000000,''),
(6,1,'B1','Utzet / pengukuran',1.000,'LS',2500000,''),
(7,1,'B1','Timbunan tanah',500.000,'m3',80000,''),
(8,1,'B1','Gerbang perumahan',1.000,'LS',25000000,''),
(9,1,'B1','Papan nama perumahan',1.000,'LS',20000000,''),
(10,1,'B1','Portal perumahan',1.000,'Unit',8500000,''),
(11,1,'B1','Pos satpam',6.000,'m2',2000000,''),
(12,1,'B1','Pondasi talud ',1.000,'m3',50000000,''),
(13,1,'B1','Perkerasan Jalan',2554.000,'m2',50000,''),
(14,1,'B1','Jalan lingkungan perumahan ',2554.000,'m2',120000,''),
(15,1,'B1','Saluran lingkungan',446.520,'m1',200000,''),
(16,1,'B1','Peresapan lingkungan',18.000,'Unit',3500000,''),
(17,1,'B1','Lampu penerangan jalan',10.000,'Unit',1500000,''),
(18,1,'B1','Taman perumahan',444.000,'m2',50000,''),
(19,1,'B1','Pohon penghijauan',10.000,'unit',500000,''),
(20,1,'B2','Limbah Komunal',1.000,'LS',70000000,''),
(21,1,'B2','Perbaikan jalan masuk',2000.000,'m2',30000,''),
(22,1,'B2','Gerbang masuk',0.000,'LS',18000000,''),
(23,1,'B2','Pagar Keliling / pagar maingate',0.000,'m2',350000,''),
(24,1,'B2','Drainase jalan masuk',12.000,'m1',775000,''),
(25,1,'B2','Saluran Luar Lingkungan',60.000,'LS',250000,''),
(26,1,'B2','Sarana ibadah ( perbaikan masjid )',45.000,'m2',2500000,''),
(27,1,'B2','Sarana Umum / Sosial',0.000,'m2',0,''),
(28,1,'B2','Lapangan Olah Raga',0.000,'m2',0,''),
(29,1,'B2','Penambahan daya listrik / trafo',1.000,'Unit',30000000,''),
(30,1,'B2','Tiang jaringan Listrik',7.000,'Unit',3500000,''),
(31,1,'B2','Sumur bor + Tower Tandon + Ijin',1.000,'ls',75000000,''),
(32,1,'B2','Penyambungan jaringan PDAM',1.000,'ls',0,''),
(33,1,'B2','Kompensasi Makam',1.000,'ls',45000000,''),
(34,1,'B2','Patok BPN / batas kavling',72.000,'Unit',75000,''),
(35,1,'B2','Bak sampah',0.000,'Unit',500000,''),
(36,1,'B2','Pondasi kavling',0.000,'m3',550000,''),
(37,1,'B2','Taman depan',0.000,'Unit',1500000,''),
(38,1,'B2','Penyambungan daya listrik rumah',72.000,'Unit',2150000,''),
(39,1,'B2','Instalasi rumah Gas Alam',0.000,'Unit',4000000,''),
(40,1,'B2','Instalasi rumah PDAM',72.000,'Unit',1500000,''),
(41,1,'B2','Instalasi Internet',0.000,'Unit',900000,''),
(42,1,'B3','Bangunan 1 lantai RUMAH KOMERSIAL',0.000,'m2',0,''),
(43,1,'B3','Bangunan 1 lantai RUMAH SUBSIDI PLUS',0.000,'m2',2000000,''),
(44,1,'B3','Bangunan 1 lantai RUMAH SUBSIDI',2160.000,'m2',2000000,''),
(45,1,'C','Dana taktis sampai kecamatan',1.000,'ls',10000000,''),
(46,1,'C','Fatwa Rencana Pengarahan Lokasi ( FRPL )',7265.000,'m2',0,''),
(47,1,'C','Advice planning',7265.000,'m2',0,''),
(48,1,'C','Ijin Lokasi / IPPT',7265.000,'m2',0,''),
(49,1,'C','Rekomendasi dari pengairan / Peil banjir',7265.000,'m2',0,''),
(50,1,'C','Pengesahan Site Plan / Ijin site plan',7265.000,'m2',7500,''),
(51,1,'C','PBG',71.000,'Unit',1200000,''),
(52,1,'D1','Jasa penghubung ',0.025,'Persen',1866250000,''),
(53,1,'D1','PBB tahunan periode proyek',2.000,'Tahun',6000000,''),
(54,1,'D1','Pemecahan PBB induk',0.000,'Unit',0,''),
(55,1,'D1','Biaya pologoro / pajak desa',1.000,'LS',18662500,''),
(56,1,'D1','Biaya pengeringan / Pendaratan',0.000,'m2',0,''),
(57,1,'D1','Perikatan jual beli / kerjasama',2.000,'LS',3000000,''),
(58,1,'D1','Cover asuransi atas pembelian lahan',0.000,'bulan',0,''),
(59,1,'D1','Biaya Surat Kuasa Jual',0.000,'Kavling',0,''),
(60,1,'D1','Biaya Balik Nama / AJB',2.000,'Bidang',5000000,''),
(61,1,'D1','BPHTB --->  5% x ( NJOP - 80 juta )',1.000,'Bidang',86825000,''),
(62,1,'D1','PPH --->  2,5% x NJOP ',1.000,'Bidang',45412500,''),
(63,1,'D1','Konversi lahan dari LC ke SHM',0.000,'Bidang',2500000,''),
(64,1,'D1','Penggabungan sertifikat',1.000,'Sertifikat',0,''),
(65,1,'D1','Penurunan menjadi SHGB ',1.000,'Sertifikat',125000000,''),
(66,1,'D1','Pengajuan peningkatan hak milik',0.000,'Sertifikat',0,''),
(67,1,'D1','Pemecahan sertifikat',76.000,'Kavling',3500000,''),
(68,1,'D1','Tak Terduga / taktis',1.000,'Kavling',50000000,''),
(69,1,'D2','Akta Jual Beli / AJB',0.000,'kavling',0,''),
(70,1,'D2','PPH SUBSIDI',0.010,'Persen',11952000000,''),
(71,1,'D2','PPH KOMERSIL',0.025,'Persen',0,'');

--
-- Table structure for table `rab_head`
--

CREATE TABLE `rab_head` (
  `id_rab` varchar(5) NOT NULL,
  `id_proyek` varchar(5) DEFAULT NULL,
  `nama_rab` varchar(100) DEFAULT NULL,
  `ket` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id_rab`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `rab_head`
--

INSERT INTO `rab_head` VALUES
('A','1','RAB HPP TANAH',NULL),
('B1','1','RAB HPP PENGOLAHAN LAHAN',NULL),
('B2','1','RAB HPP PRASARANA DAN SARANA',NULL),
('B3','1','RAB HPP KONTRUKSI RUMAH',NULL),
('C','1','RAB HPP PERIJINAN PROYEK',NULL),
('D1','1','RAB HPP LEGALITAS PROYEK\r\n',NULL),
('D2','1','RAB HPP LEGALITAS PENJUALAN KAVLING',NULL);

--
-- Table structure for table `rencana_modal`
--

CREATE TABLE `rencana_modal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_proyek` int(11) DEFAULT NULL,
  `rencana_modal` varchar(100) DEFAULT NULL,
  `jumlah` decimal(43,0) NOT NULL,
  `bln` int(11) DEFAULT NULL,
  `ket` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `rencana_modal`
--

INSERT INTO `rencana_modal` VALUES
(1,1,'Modal Investasi Tanah',300000000,1,NULL),
(2,1,'Modal Investasi Tanah',400000000,4,NULL),
(3,1,'Modal Kerja + Operasional',50000000,1,NULL),
(4,1,'Modal Kerja + Operasional',250000000,2,NULL),
(5,1,'Modal Kerja + Operasional',250000000,3,NULL),
(6,1,'Modal Kerja + Operasional',150000000,4,NULL);

--
-- Table structure for table `target_penjualan`
--

CREATE TABLE `target_penjualan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_proyek` int(11) DEFAULT NULL,
  `no_kavling` varchar(20) DEFAULT NULL,
  `bln_akad` int(11) DEFAULT NULL,
  `sbum` decimal(9,2) NOT NULL DEFAULT 0.00,
  `retensi` decimal(9,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `target_penjualan`
--

INSERT INTO `target_penjualan` VALUES
(1,1,'A-1',5,4000000.00,0.10),
(2,1,'A-2',5,4000000.00,0.15),
(3,1,'A-3',5,4000000.00,0.10),
(4,1,'A-4',5,4000000.00,0.10),
(5,1,'A-5',5,4000000.00,0.10),
(6,1,'B-1',6,4000000.00,0.10),
(7,1,'B-2',6,4000000.00,0.10),
(8,1,'B-3',6,4000000.00,0.10),
(9,1,'B-4',6,4000000.00,0.10),
(10,1,'B-5',6,4000000.00,0.10),
(11,1,'B-6',7,4000000.00,0.10),
(12,1,'B-7',7,4000000.00,0.10),
(13,1,'B-8',7,4000000.00,0.10),
(14,1,'B-9',7,4000000.00,0.10),
(15,1,'B-10',7,4000000.00,0.10),
(16,1,'B-11',8,4000000.00,0.10),
(17,1,'B-12',8,4000000.00,0.10),
(18,1,'B-13',8,4000000.00,0.10),
(19,1,'B-14',8,4000000.00,0.10),
(20,1,'B-15',8,4000000.00,0.10),
(21,1,'C-1',9,4000000.00,0.10),
(22,1,'C-2',9,4000000.00,0.10),
(23,1,'C-3',9,4000000.00,0.10),
(24,1,'C-4',9,4000000.00,0.10),
(25,1,'C-5',9,4000000.00,0.10),
(26,1,'C-6',10,4000000.00,0.10),
(27,1,'C-7',10,4000000.00,0.10),
(28,1,'C-8',10,4000000.00,0.10),
(29,1,'C-9',10,4000000.00,0.10),
(30,1,'C-10',10,4000000.00,0.10),
(31,1,'C-11',11,4000000.00,0.10),
(32,1,'C-12',11,4000000.00,0.10),
(33,1,'C-13',11,4000000.00,0.10),
(34,1,'C-14',11,4000000.00,0.10),
(35,1,'C-15',11,4000000.00,0.10),
(36,1,'C-16',12,4000000.00,0.10),
(37,1,'C-17',12,4000000.00,0.10),
(38,1,'C-18',12,4000000.00,0.10),
(39,1,'C-19',12,4000000.00,0.10),
(40,1,'C-20',12,4000000.00,0.10),
(41,1,'C-21',13,4000000.00,0.10),
(42,1,'C-22',13,4000000.00,0.10),
(43,1,'C-23',13,4000000.00,0.10),
(44,1,'C-24',13,4000000.00,0.10),
(45,1,'C-25',13,4000000.00,0.10),
(46,1,'C-26',13,4000000.00,0.10),
(47,1,'D-1',14,4000000.00,0.10),
(48,1,'D-2',14,4000000.00,0.10),
(49,1,'D-3',14,4000000.00,0.10),
(50,1,'D-4',14,4000000.00,0.10),
(51,1,'D-5',14,4000000.00,0.10),
(52,1,'D-6',15,4000000.00,0.10),
(53,1,'D-7',15,4000000.00,0.10),
(54,1,'D-8',15,4000000.00,0.10),
(55,1,'D-9',15,4000000.00,0.10),
(56,1,'D-10',15,4000000.00,0.10),
(57,1,'E-1',16,4000000.00,0.10),
(58,1,'E-2',16,4000000.00,0.10),
(59,1,'E-3',16,4000000.00,0.10),
(60,1,'E-4',16,4000000.00,0.10),
(61,1,'E-5',16,4000000.00,0.10),
(62,1,'E-6',17,4000000.00,0.10),
(63,1,'E-7',17,4000000.00,0.10),
(64,1,'E-8',17,4000000.00,0.10),
(65,1,'E-9',17,4000000.00,0.10),
(66,1,'E-10',17,4000000.00,0.10),
(67,1,'F-1',18,4000000.00,0.10),
(68,1,'F-2',18,4000000.00,0.10),
(69,1,'F-3',18,4000000.00,0.10),
(70,1,'F-4',18,4000000.00,0.10),
(71,1,'F-5',18,4000000.00,0.10),
(72,1,'F-6',18,4000000.00,0.10);

--
-- Final view structure for view `query_bop_detail`
--

/*!50001 DROP VIEW IF EXISTS `query_bop_detail`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_bop_detail` AS select `bop`.`id` AS `id`,`bop`.`id_proyek` AS `id_proyek`,`bop`.`kode_rab` AS `kode_rab`,`bop`.`uraian` AS `uraian`,`bop`.`volume_kumulatif` AS `volume_kumulatif`,`bop`.`volume_kuantiti` AS `volume_kuantiti`,`bop`.`unit` AS `unit`,`bop`.`harga_satuan` AS `harga_satuan`,`bop`.`ket` AS `ket`,`bop`.`harga_satuan` * `bop`.`volume_kumulatif` * `bop`.`volume_kuantiti` AS `sub_jumlah` from `bop` */;

--
-- Final view structure for view `query_bop_head`
--

/*!50001 DROP VIEW IF EXISTS `query_bop_head`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_bop_head` AS select `bop_head`.`id_rab` AS `id_rab`,`bop_head`.`id_proyek` AS `id_proyek`,`bop_head`.`nama_rab` AS `nama_rab`,`bop_head`.`ket` AS `ket` from `bop_head` */;

--
-- Final view structure for view `query_bop_head_total`
--

/*!50001 DROP VIEW IF EXISTS `query_bop_head_total`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_bop_head_total` AS select `h`.`id_proyek` AS `id_proyek`,`h`.`id_rab` AS `id_rab`,`h`.`nama_rab` AS `nama_rab`,`h`.`ket` AS `ket`,coalesce(sum(cast(replace(`d`.`sub_jumlah`,',','') as unsigned)),0) AS `total_jumlah` from (`query_bop_head` `h` left join `query_bop_detail` `d` on(`h`.`id_rab` = `d`.`kode_rab`)) group by `h`.`id_proyek`,`h`.`id_rab`,`h`.`nama_rab`,`h`.`ket` */;

--
-- Final view structure for view `query_bop_persen`
--

/*!50001 DROP VIEW IF EXISTS `query_bop_persen`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `query_bop_persen` AS select `qbht`.`id_proyek` AS `id_proyek`,`qbht`.`id_rab` AS `id_rab`,round(case when `qnpp`.`nilai_penerimaan_penjualan` is not null and `qnpp`.`nilai_penerimaan_penjualan` > 0 then coalesce(`qbht`.`total_jumlah`,0) / `qnpp`.`nilai_penerimaan_penjualan` * 100 else 0 end,2) AS `persen` from (((`head_ref` `hr` left join `query_bop_head_total` `qbht` on(`hr`.`id_rab` = `qbht`.`id_rab`)) left join `proyek` `p` on(`p`.`id` = coalesce(`qbht`.`id_proyek`))) left join `query_nilai_penerimaan_penjualan` `qnpp` on(`qnpp`.`id` = `p`.`id`)) where `p`.`id` = 1 and `qbht`.`total_jumlah` > 0 order by `hr`.`id_rab` */;

--
-- Final view structure for view `query_cashflow_pembangunan`
--

/*!50001 DROP VIEW IF EXISTS `query_cashflow_pembangunan`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_cashflow_pembangunan` AS select `cashflow_pembangunan`.`id` AS `id`,`cashflow_pembangunan`.`id_proyek` AS `id_proyek`,`cashflow_pembangunan`.`no_kavling` AS `no_kavling`,`cashflow_pembangunan`.`tot_bangun` AS `tot_bangun`,`cashflow_pembangunan`.`mulai_bangun` AS `mulai_bangun`,case when 1 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_1`,case when 2 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_2`,case when 3 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_3`,case when 4 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_4`,case when 5 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_5`,case when 6 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_6`,case when 7 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_7`,case when 8 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_8`,case when 9 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_9`,case when 10 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_10`,case when 11 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_11`,case when 12 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_12`,case when 13 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_13`,case when 14 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_14`,case when 15 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_15`,case when 16 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_16`,case when 17 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_17`,case when 18 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_18`,case when 19 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_19`,case when 20 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_20`,case when 21 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_21`,case when 22 between `cashflow_pembangunan`.`mulai_bangun` - 2 and `cashflow_pembangunan`.`mulai_bangun` then `cashflow_pembangunan`.`tot_bangun` / 3 else 0 end AS `bulan_22` from `cashflow_pembangunan` */;

--
-- Final view structure for view `query_distribusi_biaya_hpp`
--

/*!50001 DROP VIEW IF EXISTS `query_distribusi_biaya_hpp`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_distribusi_biaya_hpp` AS select `k`.`id` AS `id`,`k`.`id_proyek` AS `id_proyek`,`k`.`no_kavling` AS `no_kavling`,`k`.`lb` AS `lb`,`k`.`lt` AS `lt`,`k`.`ket` AS `ket`,`k`.`lt` / `s`.`sum_lt` * `ra`.`total_jumlah` AS `tanah_proyek`,`k`.`lt` / `s`.`sum_lt` * `rb1`.`total_jumlah` AS `pengolahan_lahan`,`k`.`lt` / `s`.`sum_lt` * `rb2`.`total_jumlah` AS `prasarana_sarana`,`k`.`lb` * `k`.`hj_bangunan` AS `kontruksi_rumah`,`k`.`lt` / `s`.`sum_lt` * `rc`.`total_jumlah` AS `perijinan_proyek`,`k`.`lt` / `s`.`sum_lt` * `rd1`.`total_jumlah` AS `legalitas_proyek`,`k`.`lt` / `s`.`sum_lt` * `rd2`.`total_jumlah` AS `legalitas_pjl_kav`,`k`.`lt` / `s`.`sum_lt` * `ra`.`total_jumlah` + `k`.`lt` / `s`.`sum_lt` * `rb1`.`total_jumlah` + `k`.`lt` / `s`.`sum_lt` * `rb2`.`total_jumlah` + `k`.`lb` * `k`.`hj_bangunan` + `k`.`lt` / `s`.`sum_lt` * `rc`.`total_jumlah` + `k`.`lt` / `s`.`sum_lt` * `rd1`.`total_jumlah` + `k`.`lt` / `s`.`sum_lt` * `rd2`.`total_jumlah` AS `hpp`,ceiling((`k`.`hb_tanah` * `k`.`indeks_tanah` * `k`.`lt` + `k`.`lb` * `k`.`hj_bangunan`) / 500000) * 500000 AS `harga_min_jual`,ceiling((`k`.`hb_tanah` * `k`.`indeks_tanah` * `k`.`lt` + `k`.`lb` * `k`.`hj_bangunan`) / 500000) * 500000 - (`k`.`lt` / `s`.`sum_lt` * `ra`.`total_jumlah` + `k`.`lt` / `s`.`sum_lt` * `rb1`.`total_jumlah` + `k`.`lt` / `s`.`sum_lt` * `rb2`.`total_jumlah` + `k`.`lb` * `k`.`hj_bangunan` + `k`.`lt` / `s`.`sum_lt` * `rc`.`total_jumlah` + `k`.`lt` / `s`.`sum_lt` * `rd1`.`total_jumlah` + `k`.`lt` / `s`.`sum_lt` * `rd2`.`total_jumlah`) AS `laba_kotor`,(ceiling((`k`.`hb_tanah` * `k`.`indeks_tanah` * `k`.`lt` + `k`.`lb` * `k`.`hj_bangunan`) / 500000) * 500000 - (`k`.`lt` / `s`.`sum_lt` * `ra`.`total_jumlah` + `k`.`lt` / `s`.`sum_lt` * `rb1`.`total_jumlah` + `k`.`lt` / `s`.`sum_lt` * `rb2`.`total_jumlah` + `k`.`lb` * `k`.`hj_bangunan` + `k`.`lt` / `s`.`sum_lt` * `rc`.`total_jumlah` + `k`.`lt` / `s`.`sum_lt` * `rd1`.`total_jumlah` + `k`.`lt` / `s`.`sum_lt` * `rd2`.`total_jumlah`)) / (ceiling((`k`.`hb_tanah` * `k`.`indeks_tanah` * `k`.`lt` + `k`.`lb` * `k`.`hj_bangunan`) / 500000) * 500000) * 100 AS `prosentase_laba` from (((((((`pendekatan_harga_jual` `k` join (select sum(`pendekatan_harga_jual`.`lt`) AS `sum_lt` from `pendekatan_harga_jual`) `s`) join (select `query_rab_head_total`.`total_jumlah` AS `total_jumlah` from `query_rab_head_total` where `query_rab_head_total`.`id_rab` = 'A' limit 1) `ra`) join (select `query_rab_head_total`.`total_jumlah` AS `total_jumlah` from `query_rab_head_total` where `query_rab_head_total`.`id_rab` = 'B1' limit 1) `rb1`) join (select `query_rab_head_total`.`total_jumlah` AS `total_jumlah` from `query_rab_head_total` where `query_rab_head_total`.`id_rab` = 'B2' limit 1) `rb2`) join (select `query_rab_head_total`.`total_jumlah` AS `total_jumlah` from `query_rab_head_total` where `query_rab_head_total`.`id_rab` = 'C' limit 1) `rc`) join (select `query_rab_head_total`.`total_jumlah` AS `total_jumlah` from `query_rab_head_total` where `query_rab_head_total`.`id_rab` = 'D1' limit 1) `rd1`) join (select `query_rab_head_total`.`total_jumlah` AS `total_jumlah` from `query_rab_head_total` where `query_rab_head_total`.`id_rab` = 'D2' limit 1) `rd2`) */;

--
-- Final view structure for view `query_distribusi_biaya_hpp_bop`
--

/*!50001 DROP VIEW IF EXISTS `query_distribusi_biaya_hpp_bop`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_distribusi_biaya_hpp_bop` AS select `pendekatan_harga_jual`.`id` AS `id`,`pendekatan_harga_jual`.`id_proyek` AS `id_proyek`,`pendekatan_harga_jual`.`no_kavling` AS `no_kavling`,`pendekatan_harga_jual`.`lb` AS `lb`,`pendekatan_harga_jual`.`lt` AS `lt`,`pendekatan_harga_jual`.`ket` AS `ket`,`query_distribusi_biaya_hpp`.`hpp` AS `hpp`,`re`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` AS `mgt_pengawasan`,`rf`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` AS `perlengkapan_ktr`,`rg1`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` AS `operasional_ktr`,`rg2`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` AS `operasional_proyek`,`rg3`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` AS `operasional_pemasaran`,`re`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` + `rf`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` + `rg1`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` + `rg2`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` + `rg3`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` AS `biaya_operasional_proyek`,`query_distribusi_biaya_hpp`.`hpp` + `re`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` + `rf`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` + `rg1`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` + `rg2`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` + `rg3`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` AS `hpp_plus_bop`,ceiling((`pendekatan_harga_jual`.`hb_tanah` * `pendekatan_harga_jual`.`indeks_tanah` * `pendekatan_harga_jual`.`lt` + `pendekatan_harga_jual`.`lb` * `pendekatan_harga_jual`.`hj_bangunan`) / 500000) * 500000 AS `harga_min_jual`,ceiling((`pendekatan_harga_jual`.`hb_tanah` * `pendekatan_harga_jual`.`indeks_tanah` * `pendekatan_harga_jual`.`lt` + `pendekatan_harga_jual`.`lb` * `pendekatan_harga_jual`.`hj_bangunan`) / 500000) * 500000 - (`query_distribusi_biaya_hpp`.`hpp` + `re`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` + `rf`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` + `rg1`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` + `rg2`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` + `rg3`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt`) AS `laba_bersih_after_tax`,(ceiling((`pendekatan_harga_jual`.`hb_tanah` * `pendekatan_harga_jual`.`indeks_tanah` * `pendekatan_harga_jual`.`lt` + `pendekatan_harga_jual`.`lb` * `pendekatan_harga_jual`.`hj_bangunan`) / 500000) * 500000 - (`query_distribusi_biaya_hpp`.`hpp` + `re`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` + `rf`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` + `rg1`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` + `rg2`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt` + `rg3`.`total_jumlah` / (select sum(`pendekatan_harga_jual`.`lt`) from `pendekatan_harga_jual`) * `pendekatan_harga_jual`.`lt`)) / (ceiling((`pendekatan_harga_jual`.`hb_tanah` * `pendekatan_harga_jual`.`indeks_tanah` * `pendekatan_harga_jual`.`lt` + `pendekatan_harga_jual`.`lb` * `pendekatan_harga_jual`.`hj_bangunan`) / 500000) * 500000) * 100 AS `persen_laba` from ((((((`pendekatan_harga_jual` join `query_distribusi_biaya_hpp`) join (select `query_bop_head_total`.`total_jumlah` AS `total_jumlah` from `query_bop_head_total` where `query_bop_head_total`.`id_rab` = 'E' limit 1) `re`) join (select `query_bop_head_total`.`total_jumlah` AS `total_jumlah` from `query_bop_head_total` where `query_bop_head_total`.`id_rab` = 'F' limit 1) `rf`) join (select `query_bop_head_total`.`total_jumlah` AS `total_jumlah` from `query_bop_head_total` where `query_bop_head_total`.`id_rab` = 'G1' limit 1) `rg1`) join (select `query_bop_head_total`.`total_jumlah` AS `total_jumlah` from `query_bop_head_total` where `query_bop_head_total`.`id_rab` = 'G2' limit 1) `rg2`) join (select `query_bop_head_total`.`total_jumlah` AS `total_jumlah` from `query_bop_head_total` where `query_bop_head_total`.`id_rab` = 'G3' limit 1) `rg3`) group by `pendekatan_harga_jual`.`no_kavling` order by `pendekatan_harga_jual`.`id` */;

--
-- Final view structure for view `query_kas_pemasukan_penjualan`
--

/*!50001 DROP VIEW IF EXISTS `query_kas_pemasukan_penjualan`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_kas_pemasukan_penjualan` AS select `pa`.`id` AS `id`,`pa`.`id_proyek` AS `id_proyek`,`pa`.`pemasukan` AS `pemasukan`,`pa`.`act_bln_4` + `pa`.`act_bln_5` + `pa`.`act_bln_6` + `pa`.`act_bln_7` + `pa`.`act_bln_8` + `pa`.`act_bln_9` + `pa`.`act_bln_10` + `pa`.`act_bln_11` + `pa`.`act_bln_12` + `pa`.`act_bln_13` + `pa`.`act_bln_14` + `pa`.`act_bln_15` + `pa`.`act_bln_16` + `pa`.`act_bln_17` + `pa`.`act_bln_18` + `pa`.`act_bln_19` + `pa`.`act_bln_20` + `pa`.`act_bln_21` AS `kum_act`,case when `pa`.`pemasukan` = 'Penjualan Rumah' then `pt`.`tgt_bln_4` else NULL end AS `Name_exp_5` from (`query_pemasukan_penjualan_act` `pa` left join `query_pemasukan_penjualan_tgt` `pt` on(`pa`.`id_proyek` = `pt`.`id_proyek`)) */;

--
-- Final view structure for view `query_nilai_penerimaan_penjualan`
--

/*!50001 DROP VIEW IF EXISTS `query_nilai_penerimaan_penjualan`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `query_nilai_penerimaan_penjualan` AS select `p`.`id` AS `id`,`p`.`nama_proyek` AS `nama_proyek`,`p`.`lokasi` AS `lokasi`,(select sum(`phj`.`h_dasar`) from `pendekatan_harga_jual` `phj` where `phj`.`id_proyek` = `p`.`id`) AS `nilai_penerimaan_penjualan`,(select sum(`qrht`.`total_jumlah`) from `query_rab_head_total` `qrht` where `qrht`.`id_proyek` = `p`.`id`) AS `harga_pokok_produksi`,(select sum(`qbht`.`total_jumlah`) from `query_bop_head_total` `qbht` where `qbht`.`id_proyek` = `p`.`id`) AS `biaya_operasional_kantor` from `proyek` `p` */;

--
-- Final view structure for view `query_pemasukan_penjualan_act`
--

/*!50001 DROP VIEW IF EXISTS `query_pemasukan_penjualan_act`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_pemasukan_penjualan_act` AS select `pemasukan_penjualan`.`id` AS `id`,`pemasukan_penjualan`.`id_proyek` AS `id_proyek`,`pemasukan_penjualan`.`pemasukan` AS `pemasukan`,sum(case when `pemasukan_penjualan`.`bln` = 0 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_0`,sum(case when `pemasukan_penjualan`.`bln` = 1 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_1`,sum(case when `pemasukan_penjualan`.`bln` = 2 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_2`,sum(case when `pemasukan_penjualan`.`bln` = 3 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_3`,sum(case when `pemasukan_penjualan`.`bln` = 4 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_4`,sum(case when `pemasukan_penjualan`.`bln` = 5 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_5`,sum(case when `pemasukan_penjualan`.`bln` = 6 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_6`,sum(case when `pemasukan_penjualan`.`bln` = 7 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_7`,sum(case when `pemasukan_penjualan`.`bln` = 8 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_8`,sum(case when `pemasukan_penjualan`.`bln` = 9 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_9`,sum(case when `pemasukan_penjualan`.`bln` = 10 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_10`,sum(case when `pemasukan_penjualan`.`bln` = 11 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_11`,sum(case when `pemasukan_penjualan`.`bln` = 12 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_12`,sum(case when `pemasukan_penjualan`.`bln` = 13 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_13`,sum(case when `pemasukan_penjualan`.`bln` = 14 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_14`,sum(case when `pemasukan_penjualan`.`bln` = 15 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_15`,sum(case when `pemasukan_penjualan`.`bln` = 16 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_16`,sum(case when `pemasukan_penjualan`.`bln` = 17 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_17`,sum(case when `pemasukan_penjualan`.`bln` = 18 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_18`,sum(case when `pemasukan_penjualan`.`bln` = 19 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_19`,sum(case when `pemasukan_penjualan`.`bln` = 20 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_20`,sum(case when `pemasukan_penjualan`.`bln` = 21 then `pemasukan_penjualan`.`jumlah` else 0 end) AS `act_bln_21` from `pemasukan_penjualan` group by `pemasukan_penjualan`.`pemasukan` order by `pemasukan_penjualan`.`id` */;

--
-- Final view structure for view `query_pemasukan_penjualan_tgt`
--

/*!50001 DROP VIEW IF EXISTS `query_pemasukan_penjualan_tgt`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_pemasukan_penjualan_tgt` AS select `query_target_penjualan`.`id` AS `id`,`query_target_penjualan`.`id_proyek` AS `id_proyek`,sum(`query_target_penjualan`.`bln_4`) AS `tgt_bln_4`,sum(`query_target_penjualan`.`bln_5`) AS `tgt_bln_5`,sum(`query_target_penjualan`.`bln_6`) AS `tgt_bln_6`,sum(`query_target_penjualan`.`bln_7`) AS `tgt_bln_7`,sum(`query_target_penjualan`.`bln_8`) AS `tgt_bln_8`,sum(`query_target_penjualan`.`bln_9`) AS `tgt_bln_9`,sum(`query_target_penjualan`.`bln_10`) AS `tgt_bln_10`,sum(`query_target_penjualan`.`bln_11`) AS `tgt_bln_11`,sum(`query_target_penjualan`.`bln_12`) AS `tgt_bln_12`,sum(`query_target_penjualan`.`bln_13`) AS `tgt_bln_13`,sum(`query_target_penjualan`.`bln_14`) AS `tgt_bln_14`,sum(`query_target_penjualan`.`bln_15`) AS `tgt_bln_15`,sum(`query_target_penjualan`.`bln_16`) AS `tgt_bln_16`,sum(`query_target_penjualan`.`bln_17`) AS `tgt_bln_17`,sum(`query_target_penjualan`.`bln_18`) AS `tgt_bln_18`,sum(`query_target_penjualan`.`bln_19`) AS `tgt_bln_19`,sum(`query_target_penjualan`.`bln_20`) AS `tgt_bln_20`,sum(`query_target_penjualan`.`bln_21`) AS `tgt_bln_21` from `query_target_penjualan` group by `query_target_penjualan`.`id_proyek` */;

--
-- Final view structure for view `query_pendekatan_harga_jual`
--

/*!50001 DROP VIEW IF EXISTS `query_pendekatan_harga_jual`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_pendekatan_harga_jual` AS select `pendekatan_harga_jual`.`id` AS `id`,`pendekatan_harga_jual`.`id_proyek` AS `id_proyek`,`pendekatan_harga_jual`.`no_kavling` AS `no_kavling`,`pendekatan_harga_jual`.`ket` AS `ket`,`pendekatan_harga_jual`.`kategori` AS `kategori`,`pendekatan_harga_jual`.`lb` AS `lb`,`pendekatan_harga_jual`.`lt` AS `lt`,`pendekatan_harga_jual`.`hj_bangunan` AS `hj_bangunan`,`pendekatan_harga_jual`.`hb_tanah` AS `hb_tanah`,`pendekatan_harga_jual`.`indeks_tanah` AS `indeks_tanah`,`pendekatan_harga_jual`.`h_dasar` AS `h_dasar`,`pendekatan_harga_jual`.`hb_tanah` * `pendekatan_harga_jual`.`indeks_tanah` AS `harga_tanah`,`pendekatan_harga_jual`.`hb_tanah` * `pendekatan_harga_jual`.`indeks_tanah` * `pendekatan_harga_jual`.`lt` + `pendekatan_harga_jual`.`lb` * `pendekatan_harga_jual`.`hj_bangunan` AS `harga_jual_raw`,ceiling((`pendekatan_harga_jual`.`hb_tanah` * `pendekatan_harga_jual`.`indeks_tanah` * `pendekatan_harga_jual`.`lt` + `pendekatan_harga_jual`.`lb` * `pendekatan_harga_jual`.`hj_bangunan`) / 500000) * 500000 AS `harga_jual`,ceiling((`pendekatan_harga_jual`.`hb_tanah` * `pendekatan_harga_jual`.`indeks_tanah` * `pendekatan_harga_jual`.`lt` + `pendekatan_harga_jual`.`lb` * `pendekatan_harga_jual`.`hj_bangunan`) / 500000) * 500000 - `pendekatan_harga_jual`.`h_dasar` AS `harga_kelebihan_tanah` from `pendekatan_harga_jual` */;

--
-- Final view structure for view `query_pengeluaran_bop`
--

/*!50001 DROP VIEW IF EXISTS `query_pengeluaran_bop`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_pengeluaran_bop` AS select `bop`.`id` AS `id`,`bop`.`id_proyek` AS `id_proyek`,`pengeluaran_bop`.`pengeluaran` AS `pengeluaran`,sum(case when `pengeluaran_bop`.`bln` = 0 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_0`,sum(case when `pengeluaran_bop`.`bln` = 1 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_1`,sum(case when `pengeluaran_bop`.`bln` = 2 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_2`,sum(case when `pengeluaran_bop`.`bln` = 3 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_3`,sum(case when `pengeluaran_bop`.`bln` = 4 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_4`,sum(case when `pengeluaran_bop`.`bln` = 5 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_5`,sum(case when `pengeluaran_bop`.`bln` = 6 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_6`,sum(case when `pengeluaran_bop`.`bln` = 7 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_7`,sum(case when `pengeluaran_bop`.`bln` = 8 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_8`,sum(case when `pengeluaran_bop`.`bln` = 9 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_9`,sum(case when `pengeluaran_bop`.`bln` = 10 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_10`,sum(case when `pengeluaran_bop`.`bln` = 11 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_11`,sum(case when `pengeluaran_bop`.`bln` = 12 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_12`,sum(case when `pengeluaran_bop`.`bln` = 13 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_13`,sum(case when `pengeluaran_bop`.`bln` = 14 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_14`,sum(case when `pengeluaran_bop`.`bln` = 15 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_15`,sum(case when `pengeluaran_bop`.`bln` = 16 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_16`,sum(case when `pengeluaran_bop`.`bln` = 17 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_17`,sum(case when `pengeluaran_bop`.`bln` = 18 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_18`,sum(case when `pengeluaran_bop`.`bln` = 19 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_19`,sum(case when `pengeluaran_bop`.`bln` = 20 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_20`,sum(case when `pengeluaran_bop`.`bln` = 21 then `pengeluaran_bop`.`jumlah` else 0 end) AS `act_bln_21` from (`bop` left join `pengeluaran_bop` on(`pengeluaran_bop`.`pengeluaran` = `bop`.`uraian`)) group by `bop`.`uraian` order by `bop`.`id` */;

--
-- Final view structure for view `query_pengeluaran_hpp`
--

/*!50001 DROP VIEW IF EXISTS `query_pengeluaran_hpp`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_pengeluaran_hpp` AS select `rab`.`id` AS `id`,`rab`.`id_proyek` AS `id_proyek`,`rab`.`uraian` AS `pengeluaran`,sum(case when `pengeluaran_hpp`.`bln` = 0 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_0`,sum(case when `pengeluaran_hpp`.`bln` = 1 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_1`,sum(case when `pengeluaran_hpp`.`bln` = 2 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_2`,sum(case when `pengeluaran_hpp`.`bln` = 3 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_3`,sum(case when `pengeluaran_hpp`.`bln` = 4 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_4`,sum(case when `pengeluaran_hpp`.`bln` = 5 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_5`,sum(case when `pengeluaran_hpp`.`bln` = 6 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_6`,sum(case when `pengeluaran_hpp`.`bln` = 7 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_7`,sum(case when `pengeluaran_hpp`.`bln` = 8 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_8`,sum(case when `pengeluaran_hpp`.`bln` = 9 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_9`,sum(case when `pengeluaran_hpp`.`bln` = 10 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_10`,sum(case when `pengeluaran_hpp`.`bln` = 11 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_11`,sum(case when `pengeluaran_hpp`.`bln` = 12 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_12`,sum(case when `pengeluaran_hpp`.`bln` = 13 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_13`,sum(case when `pengeluaran_hpp`.`bln` = 14 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_14`,sum(case when `pengeluaran_hpp`.`bln` = 15 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_15`,sum(case when `pengeluaran_hpp`.`bln` = 16 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_16`,sum(case when `pengeluaran_hpp`.`bln` = 17 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_17`,sum(case when `pengeluaran_hpp`.`bln` = 18 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_18`,sum(case when `pengeluaran_hpp`.`bln` = 19 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_19`,sum(case when `pengeluaran_hpp`.`bln` = 20 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_20`,sum(case when `pengeluaran_hpp`.`bln` = 21 then `pengeluaran_hpp`.`jumlah` else 0 end) AS `act_bln_21` from (`rab` left join `pengeluaran_hpp` on(`pengeluaran_hpp`.`pengeluaran` = `rab`.`uraian`)) group by `rab`.`uraian` order by `rab`.`id` */;

--
-- Final view structure for view `query_pengembalian_modal`
--

/*!50001 DROP VIEW IF EXISTS `query_pengembalian_modal`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_pengembalian_modal` AS select `pengembalian_modal`.`id` AS `id`,`pengembalian_modal`.`id_proyek` AS `id_proyek`,`pengembalian_modal`.`pengembalian_modal` AS `pengembalian_modal`,max(coalesce(case when `pengembalian_modal`.`bln` = 0 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_0`,max(coalesce(case when `pengembalian_modal`.`bln` = 1 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_1`,max(coalesce(case when `pengembalian_modal`.`bln` = 2 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_2`,max(coalesce(case when `pengembalian_modal`.`bln` = 3 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_3`,max(coalesce(case when `pengembalian_modal`.`bln` = 4 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_4`,max(coalesce(case when `pengembalian_modal`.`bln` = 5 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_5`,max(coalesce(case when `pengembalian_modal`.`bln` = 6 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_6`,max(coalesce(case when `pengembalian_modal`.`bln` = 7 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_7`,max(coalesce(case when `pengembalian_modal`.`bln` = 8 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_8`,max(coalesce(case when `pengembalian_modal`.`bln` = 9 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_9`,max(coalesce(case when `pengembalian_modal`.`bln` = 10 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_10`,max(coalesce(case when `pengembalian_modal`.`bln` = 11 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_11`,max(coalesce(case when `pengembalian_modal`.`bln` = 12 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_12`,max(coalesce(case when `pengembalian_modal`.`bln` = 13 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_13`,max(coalesce(case when `pengembalian_modal`.`bln` = 14 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_14`,max(coalesce(case when `pengembalian_modal`.`bln` = 15 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_15`,max(coalesce(case when `pengembalian_modal`.`bln` = 16 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_16`,max(coalesce(case when `pengembalian_modal`.`bln` = 17 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_17`,max(coalesce(case when `pengembalian_modal`.`bln` = 18 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_18`,max(coalesce(case when `pengembalian_modal`.`bln` = 19 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_19`,max(coalesce(case when `pengembalian_modal`.`bln` = 20 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_20`,max(coalesce(case when `pengembalian_modal`.`bln` = 21 then `pengembalian_modal`.`jumlah` end,0)) AS `bln_21` from `pengembalian_modal` group by `pengembalian_modal`.`pengembalian_modal` */;

--
-- Final view structure for view `query_proyek`
--

/*!50001 DROP VIEW IF EXISTS `query_proyek`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_proyek` AS select `proyek`.`id` AS `id`,`proyek`.`nama_proyek` AS `nama_proyek`,`proyek`.`lokasi` AS `lokasi`,`proyek`.`total_lt` AS `total_lt`,`proyek`.`luas_jalan` AS `luas_jalan`,`proyek`.`luas_jalan` / `proyek`.`total_lt` * 100 AS `pc_jln`,`proyek`.`luas_taman` AS `luas_taman`,`proyek`.`luas_taman` / `proyek`.`total_lt` * 100 AS `pc_tmn`,`proyek`.`lt_mushola` AS `lt_mushola`,`proyek`.`lt_mushola` / `proyek`.`total_lt` * 100 AS `pc_msl`,`proyek`.`tgl_mulai` AS `tgl_mulai`,`proyek`.`tgt_selesai_proyek` AS `tgt_selesai_proyek`,`proyek`.`tgl_mulai` + interval `proyek`.`tgt_selesai_proyek` month AS `tanggal_selesai`,`proyek`.`bgt_1lt_rs` AS `bgt_1lt_rs`,`proyek`.`bgt_1lt_rk` AS `bgt_1lt_rk`,`proyek`.`bgt_2lt_rk` AS `bgt_2lt_rk`,`proyek`.`hg_m2_tanah` AS `hg_m2_tanah`,`proyek`.`ket` AS `ket`,`proyek`.`status` AS `status`,sum(`pendekatan_harga_jual`.`lt`) AS `ls_tot_kav`,sum(`pendekatan_harga_jual`.`lt`) / `proyek`.`total_lt` * 100 AS `pc_kav`,sum(`pendekatan_harga_jual`.`lb`) AS `ls_tot_bgn`,sum(if(`pendekatan_harga_jual`.`kategori` = 'Komersil',`pendekatan_harga_jual`.`lb`,0)) AS `tot_ls_kav_komersil`,sum(if(`pendekatan_harga_jual`.`kategori` = 'Subsidi Plus',`pendekatan_harga_jual`.`lb`,0)) AS `tot_ls_kav_sub_plus`,sum(if(`pendekatan_harga_jual`.`kategori` = 'Subsidi',`pendekatan_harga_jual`.`lb`,0)) AS `tot_ls_kav_subsidi`,sum(`pendekatan_harga_jual`.`lb`) / sum(`pendekatan_harga_jual`.`lt`) * 100 AS `koef_db` from (`proyek` left join `pendekatan_harga_jual` on(`proyek`.`id` = `pendekatan_harga_jual`.`id_proyek`)) group by `pendekatan_harga_jual`.`id_proyek` */;

--
-- Final view structure for view `query_rab_detail`
--

/*!50001 DROP VIEW IF EXISTS `query_rab_detail`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_rab_detail` AS select `rab`.`id` AS `id`,`rab`.`id_proyek` AS `id_proyek`,`rab`.`kode_rab` AS `kode_rab`,`rab`.`uraian` AS `uraian`,`rab`.`volume` AS `volume`,`rab`.`unit` AS `unit`,`rab`.`harga_satuan` AS `harga_satuan`,`rab`.`volume` * `rab`.`harga_satuan` AS `sub Jumlah`,`rab`.`ket` AS `ket` from `rab` */;

--
-- Final view structure for view `query_rab_head`
--

/*!50001 DROP VIEW IF EXISTS `query_rab_head`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_rab_head` AS select `rab_head`.`id_proyek` AS `id_proyek`,`rab_head`.`id_rab` AS `id_rab`,`rab_head`.`nama_rab` AS `nama_rab`,`rab_head`.`ket` AS `ket` from `rab_head` */;

--
-- Final view structure for view `query_rab_head_total`
--

/*!50001 DROP VIEW IF EXISTS `query_rab_head_total`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_rab_head_total` AS select `h`.`id_proyek` AS `id_proyek`,`h`.`id_rab` AS `id_rab`,`h`.`nama_rab` AS `nama_rab`,`h`.`ket` AS `ket`,coalesce(sum(cast(replace(`d`.`sub Jumlah`,',','') as unsigned)),0) AS `total_jumlah` from (`query_rab_head` `h` left join `query_rab_detail` `d` on(`h`.`id_rab` = `d`.`kode_rab`)) group by `h`.`id_proyek`,`h`.`id_rab`,`h`.`nama_rab`,`h`.`ket` */;

--
-- Final view structure for view `query_rab_persen`
--

/*!50001 DROP VIEW IF EXISTS `query_rab_persen`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `query_rab_persen` AS select `qrht`.`id_proyek` AS `id_proyek`,`qrht`.`id_rab` AS `id_rab`,round(case when `qnpp`.`nilai_penerimaan_penjualan` is not null and `qnpp`.`nilai_penerimaan_penjualan` > 0 then coalesce(`qrht`.`total_jumlah`,0) / `qnpp`.`nilai_penerimaan_penjualan` * 100 else 0 end,2) AS `persen` from (((`head_ref` `hr` left join `query_rab_head_total` `qrht` on(`hr`.`id_rab` = `qrht`.`id_rab`)) left join `proyek` `p` on(`p`.`id` = coalesce(`qrht`.`id_proyek`))) left join `query_nilai_penerimaan_penjualan` `qnpp` on(`qnpp`.`id` = `p`.`id`)) where `p`.`id` = 1 and `qrht`.`total_jumlah` > 0 order by `hr`.`id_rab` */;

--
-- Final view structure for view `query_rencana_modal`
--

/*!50001 DROP VIEW IF EXISTS `query_rencana_modal`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_rencana_modal` AS select `rencana_modal`.`id` AS `id`,`rencana_modal`.`id_proyek` AS `id_proyek`,`rencana_modal`.`rencana_modal` AS `rencana_modal`,max(coalesce(case when `rencana_modal`.`bln` = 0 then `rencana_modal`.`jumlah` end,0)) AS `bln_0`,max(coalesce(case when `rencana_modal`.`bln` = 1 then `rencana_modal`.`jumlah` end,0)) AS `bln_1`,max(coalesce(case when `rencana_modal`.`bln` = 2 then `rencana_modal`.`jumlah` end,0)) AS `bln_2`,max(coalesce(case when `rencana_modal`.`bln` = 3 then `rencana_modal`.`jumlah` end,0)) AS `bln_3`,max(coalesce(case when `rencana_modal`.`bln` = 4 then `rencana_modal`.`jumlah` end,0)) AS `bln_4`,max(coalesce(case when `rencana_modal`.`bln` = 5 then `rencana_modal`.`jumlah` end,0)) AS `bln_5`,max(coalesce(case when `rencana_modal`.`bln` = 6 then `rencana_modal`.`jumlah` end,0)) AS `bln_6`,max(coalesce(case when `rencana_modal`.`bln` = 7 then `rencana_modal`.`jumlah` end,0)) AS `bln_7`,max(coalesce(case when `rencana_modal`.`bln` = 8 then `rencana_modal`.`jumlah` end,0)) AS `bln_8`,max(coalesce(case when `rencana_modal`.`bln` = 9 then `rencana_modal`.`jumlah` end,0)) AS `bln_9`,max(coalesce(case when `rencana_modal`.`bln` = 10 then `rencana_modal`.`jumlah` end,0)) AS `bln_10`,max(coalesce(case when `rencana_modal`.`bln` = 11 then `rencana_modal`.`jumlah` end,0)) AS `bln_11`,max(coalesce(case when `rencana_modal`.`bln` = 12 then `rencana_modal`.`jumlah` end,0)) AS `bln_12`,max(coalesce(case when `rencana_modal`.`bln` = 13 then `rencana_modal`.`jumlah` end,0)) AS `bln_13`,max(coalesce(case when `rencana_modal`.`bln` = 14 then `rencana_modal`.`jumlah` end,0)) AS `bln_14`,max(coalesce(case when `rencana_modal`.`bln` = 15 then `rencana_modal`.`jumlah` end,0)) AS `bln_15`,max(coalesce(case when `rencana_modal`.`bln` = 16 then `rencana_modal`.`jumlah` end,0)) AS `bln_16`,max(coalesce(case when `rencana_modal`.`bln` = 17 then `rencana_modal`.`jumlah` end,0)) AS `bln_17`,max(coalesce(case when `rencana_modal`.`bln` = 18 then `rencana_modal`.`jumlah` end,0)) AS `bln_18`,max(coalesce(case when `rencana_modal`.`bln` = 19 then `rencana_modal`.`jumlah` end,0)) AS `bln_19`,max(coalesce(case when `rencana_modal`.`bln` = 20 then `rencana_modal`.`jumlah` end,0)) AS `bln_20`,max(coalesce(case when `rencana_modal`.`bln` = 21 then `rencana_modal`.`jumlah` end,0)) AS `bln_21` from `rencana_modal` group by `rencana_modal`.`rencana_modal` */;

--
-- Final view structure for view `query_target_penjualan`
--

/*!50001 DROP VIEW IF EXISTS `query_target_penjualan`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `query_target_penjualan` AS select `tp`.`id` AS `id`,`tp`.`id_proyek` AS `id_proyek`,`tp`.`no_kavling` AS `no_kavling`,`hp`.`lb` AS `lb`,`hp`.`lt` AS `lt`,`hp`.`harga_jual` AS `harga_standar`,`tp`.`bln_akad` AS `bln_akad`,`tp`.`retensi` AS `retensi`,`hp`.`h_dasar` AS `harga_pricelist`,`tp`.`sbum` AS `sbum`,case when `tp`.`bln_akad` - 1 = 4 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 4 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 4 then `tp`.`sbum` else 0 end AS `bln_4`,case when `tp`.`bln_akad` - 1 = 5 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 5 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 5 then `tp`.`sbum` else 0 end AS `bln_5`,case when `tp`.`bln_akad` - 1 = 6 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 6 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 6 then `tp`.`sbum` else 0 end AS `bln_6`,case when `tp`.`bln_akad` - 1 = 7 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 7 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 7 then `tp`.`sbum` else 0 end AS `bln_7`,case when `tp`.`bln_akad` - 1 = 8 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 8 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 8 then `tp`.`sbum` else 0 end AS `bln_8`,case when `tp`.`bln_akad` - 1 = 9 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 9 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 9 then `tp`.`sbum` else 0 end AS `bln_9`,case when `tp`.`bln_akad` - 1 = 10 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 10 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 10 then `tp`.`sbum` else 0 end AS `bln_10`,case when `tp`.`bln_akad` - 1 = 11 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 11 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 11 then `tp`.`sbum` else 0 end AS `bln_11`,case when `tp`.`bln_akad` - 1 = 12 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 12 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 12 then `tp`.`sbum` else 0 end AS `bln_12`,case when `tp`.`bln_akad` - 1 = 13 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 13 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 13 then `tp`.`sbum` else 0 end AS `bln_13`,case when `tp`.`bln_akad` - 1 = 14 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 14 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 14 then `tp`.`sbum` else 0 end AS `bln_14`,case when `tp`.`bln_akad` - 1 = 15 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 15 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 15 then `tp`.`sbum` else 0 end AS `bln_15`,case when `tp`.`bln_akad` - 1 = 16 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 16 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 16 then `tp`.`sbum` else 0 end AS `bln_16`,case when `tp`.`bln_akad` - 1 = 17 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 17 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 17 then `tp`.`sbum` else 0 end AS `bln_17`,case when `tp`.`bln_akad` - 1 = 18 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 18 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 18 then `tp`.`sbum` else 0 end AS `bln_18`,case when `tp`.`bln_akad` - 1 = 19 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 19 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 19 then `tp`.`sbum` else 0 end AS `bln_19`,(`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` AS `bln_20`,case when `tp`.`bln_akad` - 1 = 21 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 21 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 21 then `tp`.`sbum` else 0 end AS `bln_21`,case when `tp`.`bln_akad` - 1 = 22 then `hp`.`h_dasar` * 0.01 when `tp`.`bln_akad` = 22 then `hp`.`h_dasar` - `hp`.`h_dasar` * 0.01 - `tp`.`sbum` - (`hp`.`h_dasar` - `hp`.`h_dasar` * 0.01) * `tp`.`retensi` when `tp`.`bln_akad` + 1 = 22 then `tp`.`sbum` else 0 end AS `bln_22` from (`target_penjualan` `tp` join `query_pendekatan_harga_jual` `hp` on(`tp`.`no_kavling` = `hp`.`no_kavling`)) */;


