/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.11.13-MariaDB, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: d6 -- ------------------------------------------------------ -- Server version 10.11.13-MariaDB-ubu2204 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `bop` -- DROP TABLE IF EXISTS `bop`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bop` -- LOCK TABLES `bop` WRITE; /*!40000 ALTER TABLE `bop` DISABLE KEYS */; 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,''); /*!40000 ALTER TABLE `bop` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `bop_head` -- DROP TABLE IF EXISTS `bop_head`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bop_head` -- LOCK TABLES `bop_head` WRITE; /*!40000 ALTER TABLE `bop_head` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `bop_head` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cashflow_pembangunan` -- DROP TABLE IF EXISTS `cashflow_pembangunan`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cashflow_pembangunan` -- LOCK TABLES `cashflow_pembangunan` WRITE; /*!40000 ALTER TABLE `cashflow_pembangunan` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `cashflow_pembangunan` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `head_ref` -- DROP TABLE IF EXISTS `head_ref`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `head_ref` -- LOCK TABLES `head_ref` WRITE; /*!40000 ALTER TABLE `head_ref` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `head_ref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kavling` -- DROP TABLE IF EXISTS `kavling`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kavling` -- LOCK TABLES `kavling` WRITE; /*!40000 ALTER TABLE `kavling` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `kavling` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `list_pemasukan` -- DROP TABLE IF EXISTS `list_pemasukan`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `list_pemasukan` ( `id` varchar(100) DEFAULT NULL, `pemasukan` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `list_pemasukan` -- LOCK TABLES `list_pemasukan` WRITE; /*!40000 ALTER TABLE `list_pemasukan` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `list_pemasukan` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pemasukan_penjualan` -- DROP TABLE IF EXISTS `pemasukan_penjualan`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pemasukan_penjualan` -- LOCK TABLES `pemasukan_penjualan` WRITE; /*!40000 ALTER TABLE `pemasukan_penjualan` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `pemasukan_penjualan` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pendekatan_harga_jual` -- DROP TABLE IF EXISTS `pendekatan_harga_jual`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pendekatan_harga_jual` -- LOCK TABLES `pendekatan_harga_jual` WRITE; /*!40000 ALTER TABLE `pendekatan_harga_jual` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `pendekatan_harga_jual` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pengeluaran_bop` -- DROP TABLE IF EXISTS `pengeluaran_bop`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pengeluaran_bop` -- LOCK TABLES `pengeluaran_bop` WRITE; /*!40000 ALTER TABLE `pengeluaran_bop` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `pengeluaran_bop` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pengeluaran_hpp` -- DROP TABLE IF EXISTS `pengeluaran_hpp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pengeluaran_hpp` -- LOCK TABLES `pengeluaran_hpp` WRITE; /*!40000 ALTER TABLE `pengeluaran_hpp` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `pengeluaran_hpp` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pengembalian_modal` -- DROP TABLE IF EXISTS `pengembalian_modal`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pengembalian_modal` -- LOCK TABLES `pengembalian_modal` WRITE; /*!40000 ALTER TABLE `pengembalian_modal` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `pengembalian_modal` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `proyek` -- DROP TABLE IF EXISTS `proyek`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `proyek` -- LOCK TABLES `proyek` WRITE; /*!40000 ALTER TABLE `proyek` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `proyek` ENABLE KEYS */; UNLOCK TABLES; -- -- Temporary table structure for view `query_bop_detail` -- DROP TABLE IF EXISTS `query_bop_detail`; /*!50001 DROP VIEW IF EXISTS `query_bop_detail`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_bop_head` -- DROP TABLE IF EXISTS `query_bop_head`; /*!50001 DROP VIEW IF EXISTS `query_bop_head`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!50001 CREATE VIEW `query_bop_head` AS SELECT 1 AS `id_rab`, 1 AS `id_proyek`, 1 AS `nama_rab`, 1 AS `ket` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_bop_head_total` -- DROP TABLE IF EXISTS `query_bop_head_total`; /*!50001 DROP VIEW IF EXISTS `query_bop_head_total`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_bop_persen` -- DROP TABLE IF EXISTS `query_bop_persen`; /*!50001 DROP VIEW IF EXISTS `query_bop_persen`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!50001 CREATE VIEW `query_bop_persen` AS SELECT 1 AS `id_proyek`, 1 AS `id_rab`, 1 AS `persen` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_cashflow_pembangunan` -- DROP TABLE IF EXISTS `query_cashflow_pembangunan`; /*!50001 DROP VIEW IF EXISTS `query_cashflow_pembangunan`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_distribusi_biaya_hpp` -- DROP TABLE IF EXISTS `query_distribusi_biaya_hpp`; /*!50001 DROP VIEW IF EXISTS `query_distribusi_biaya_hpp`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_distribusi_biaya_hpp_bop` -- DROP TABLE IF EXISTS `query_distribusi_biaya_hpp_bop`; /*!50001 DROP VIEW IF EXISTS `query_distribusi_biaya_hpp_bop`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_kas_pemasukan_penjualan` -- DROP TABLE IF EXISTS `query_kas_pemasukan_penjualan`; /*!50001 DROP VIEW IF EXISTS `query_kas_pemasukan_penjualan`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_nilai_penerimaan_penjualan` -- DROP TABLE IF EXISTS `query_nilai_penerimaan_penjualan`; /*!50001 DROP VIEW IF EXISTS `query_nilai_penerimaan_penjualan`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_pemasukan_penjualan_act` -- DROP TABLE IF EXISTS `query_pemasukan_penjualan_act`; /*!50001 DROP VIEW IF EXISTS `query_pemasukan_penjualan_act`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_pemasukan_penjualan_tgt` -- DROP TABLE IF EXISTS `query_pemasukan_penjualan_tgt`; /*!50001 DROP VIEW IF EXISTS `query_pemasukan_penjualan_tgt`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_pendekatan_harga_jual` -- DROP TABLE IF EXISTS `query_pendekatan_harga_jual`; /*!50001 DROP VIEW IF EXISTS `query_pendekatan_harga_jual`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_pengeluaran_bop` -- DROP TABLE IF EXISTS `query_pengeluaran_bop`; /*!50001 DROP VIEW IF EXISTS `query_pengeluaran_bop`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_pengeluaran_hpp` -- DROP TABLE IF EXISTS `query_pengeluaran_hpp`; /*!50001 DROP VIEW IF EXISTS `query_pengeluaran_hpp`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_pengembalian_modal` -- DROP TABLE IF EXISTS `query_pengembalian_modal`; /*!50001 DROP VIEW IF EXISTS `query_pengembalian_modal`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_proyek` -- DROP TABLE IF EXISTS `query_proyek`; /*!50001 DROP VIEW IF EXISTS `query_proyek`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_rab_detail` -- DROP TABLE IF EXISTS `query_rab_detail`; /*!50001 DROP VIEW IF EXISTS `query_rab_detail`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_rab_head` -- DROP TABLE IF EXISTS `query_rab_head`; /*!50001 DROP VIEW IF EXISTS `query_rab_head`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!50001 CREATE VIEW `query_rab_head` AS SELECT 1 AS `id_proyek`, 1 AS `id_rab`, 1 AS `nama_rab`, 1 AS `ket` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_rab_head_total` -- DROP TABLE IF EXISTS `query_rab_head_total`; /*!50001 DROP VIEW IF EXISTS `query_rab_head_total`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_rab_persen` -- DROP TABLE IF EXISTS `query_rab_persen`; /*!50001 DROP VIEW IF EXISTS `query_rab_persen`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!50001 CREATE VIEW `query_rab_persen` AS SELECT 1 AS `id_proyek`, 1 AS `id_rab`, 1 AS `persen` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_rencana_modal` -- DROP TABLE IF EXISTS `query_rencana_modal`; /*!50001 DROP VIEW IF EXISTS `query_rencana_modal`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `query_target_penjualan` -- DROP TABLE IF EXISTS `query_target_penjualan`; /*!50001 DROP VIEW IF EXISTS `query_target_penjualan`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!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` */; SET character_set_client = @saved_cs_client; -- -- Table structure for table `rab` -- DROP TABLE IF EXISTS `rab`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rab` -- LOCK TABLES `rab` WRITE; /*!40000 ALTER TABLE `rab` DISABLE KEYS */; 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,''); /*!40000 ALTER TABLE `rab` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rab_head` -- DROP TABLE IF EXISTS `rab_head`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rab_head` -- LOCK TABLES `rab_head` WRITE; /*!40000 ALTER TABLE `rab_head` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `rab_head` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rencana_modal` -- DROP TABLE IF EXISTS `rencana_modal`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rencana_modal` -- LOCK TABLES `rencana_modal` WRITE; /*!40000 ALTER TABLE `rencana_modal` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `rencana_modal` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `target_penjualan` -- DROP TABLE IF EXISTS `target_penjualan`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `target_penjualan` -- LOCK TABLES `target_penjualan` WRITE; /*!40000 ALTER TABLE `target_penjualan` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `target_penjualan` ENABLE KEYS */; UNLOCK TABLES; -- -- Final view structure for view `query_bop_detail` -- /*!50001 DROP VIEW IF EXISTS `query_bop_detail`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_bop_head` -- /*!50001 DROP VIEW IF EXISTS `query_bop_head`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_bop_head_total` -- /*!50001 DROP VIEW IF EXISTS `query_bop_head_total`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_bop_persen` -- /*!50001 DROP VIEW IF EXISTS `query_bop_persen`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_cashflow_pembangunan` -- /*!50001 DROP VIEW IF EXISTS `query_cashflow_pembangunan`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_distribusi_biaya_hpp` -- /*!50001 DROP VIEW IF EXISTS `query_distribusi_biaya_hpp`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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`) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_distribusi_biaya_hpp_bop` -- /*!50001 DROP VIEW IF EXISTS `query_distribusi_biaya_hpp_bop`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_kas_pemasukan_penjualan` -- /*!50001 DROP VIEW IF EXISTS `query_kas_pemasukan_penjualan`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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`)) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_nilai_penerimaan_penjualan` -- /*!50001 DROP VIEW IF EXISTS `query_nilai_penerimaan_penjualan`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_pemasukan_penjualan_act` -- /*!50001 DROP VIEW IF EXISTS `query_pemasukan_penjualan_act`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_pemasukan_penjualan_tgt` -- /*!50001 DROP VIEW IF EXISTS `query_pemasukan_penjualan_tgt`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_pendekatan_harga_jual` -- /*!50001 DROP VIEW IF EXISTS `query_pendekatan_harga_jual`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_pengeluaran_bop` -- /*!50001 DROP VIEW IF EXISTS `query_pengeluaran_bop`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_pengeluaran_hpp` -- /*!50001 DROP VIEW IF EXISTS `query_pengeluaran_hpp`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_pengembalian_modal` -- /*!50001 DROP VIEW IF EXISTS `query_pengembalian_modal`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_proyek` -- /*!50001 DROP VIEW IF EXISTS `query_proyek`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_rab_detail` -- /*!50001 DROP VIEW IF EXISTS `query_rab_detail`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_rab_head` -- /*!50001 DROP VIEW IF EXISTS `query_rab_head`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_rab_head_total` -- /*!50001 DROP VIEW IF EXISTS `query_rab_head_total`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_rab_persen` -- /*!50001 DROP VIEW IF EXISTS `query_rab_persen`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_rencana_modal` -- /*!50001 DROP VIEW IF EXISTS `query_rencana_modal`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `query_target_penjualan` -- /*!50001 DROP VIEW IF EXISTS `query_target_penjualan`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!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`)) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2025-07-25 9:54:19