-- MySQL dump 10.13  Distrib 8.0.22, for Win64 (x86_64)
--
-- Host: localhost    Database: keuangan_jayakarta
-- ------------------------------------------------------
-- Server version	5.7.32-0ubuntu0.18.04.1

/*!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 */;
/*!50503 SET NAMES utf8 */;
/*!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 `tb_pembayaran_gaji`
--

DROP TABLE IF EXISTS `tb_pembayaran_gaji`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_pembayaran_gaji` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `bulan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tahun` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pegawai_id` int(10) unsigned NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gaji_pokok` double(20,2) NOT NULL DEFAULT '0.00',
  `total_tunjangan` double(20,2) NOT NULL DEFAULT '0.00',
  `total_pembayaran_pinjaman` double(20,2) NOT NULL DEFAULT '0.00',
  `total_pembayaran_iuran` double(20,2) NOT NULL DEFAULT '0.00',
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal_transfer` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tujuan_bank_tranfer` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tujuan_rekening_tranfer` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tujuan_nama_tranfer` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bukti_bayar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tb_pembayaran_gaji_pegawai_id_index` (`pegawai_id`)
) ENGINE=InnoDB AUTO_INCREMENT=190 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_pembayaran_gaji`
--

LOCK TABLES `tb_pembayaran_gaji` WRITE;
/*!40000 ALTER TABLE `tb_pembayaran_gaji` DISABLE KEYS */;
INSERT INTO `tb_pembayaran_gaji` VALUES (1,'Mei','2020',1,'hardi-benry-simbolon-ir-mei-2020',1400000.00,1600000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-11 05:00:12','2020-05-11 08:43:15',NULL),(2,'Mei','2020',2,'ifan-junaedi-m-kom-mei-2020',2040000.00,8440000.00,0.00,187200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-12 23:29:11','2020-05-12 23:31:58',NULL),(3,'Mei','2020',3,'zulhalim-m-kom-mei-2020',1000000.00,3800000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-12 23:54:46','2020-05-12 23:57:32',NULL),(4,'Mei','2020',4,'thomas-budiman-m-kom-mei-2020',1000000.00,1400000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-12 23:58:41','2020-05-12 23:58:41',NULL),(5,'Mei','2020',5,'ihsan-nur-se-mei-2020',1750000.00,7450000.00,0.00,213600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-12 23:59:59','2020-05-13 00:02:46','2020-05-13 00:02:46'),(6,'Mei','2020',5,'ihsan-nur-se-mei-2020',1750000.00,7450000.00,0.00,2513600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 00:04:14','2020-05-13 00:04:14',NULL),(7,'Mei','2020',6,'hetty-farida-se-mei-2020',1800000.00,7200000.00,0.00,208400.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 00:06:01','2020-05-13 00:06:01',NULL),(8,'Mei','2020',7,'usman-gultom-m-kom-mei-2020',1750000.00,2600000.00,1575000.00,203800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 00:08:18','2020-05-13 00:08:18',NULL),(9,'Mei','2020',8,'asih-septiarini-se-mei-2020',1700000.00,2650000.00,1575000.00,203800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 00:10:39','2020-05-13 00:10:39',NULL),(10,'Mei','2020',9,'anton-sianipar-m-pd-mei-2020',1680000.00,8180000.00,0.00,177900.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 00:12:14','2020-05-13 00:12:14',NULL),(11,'Mei','2020',10,'rachmawaty-haroen-mm-mei-2020',1750000.00,7450000.00,0.00,2513600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 00:14:23','2020-05-13 00:14:23',NULL),(12,'Mei','2020',11,'natalia-kristina-mei-2020',3400000.00,4270000.00,2075000.00,336800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 00:23:20','2020-05-13 00:23:20',NULL),(13,'Mei','2020',12,'suwarno-a-md-mei-2020',1950000.00,6750000.00,0.00,204000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 00:29:20','2020-05-13 00:29:20',NULL),(14,'Mei','2020',13,'rosmawati-hutabarat-mei-2020',1850000.00,2490000.00,0.00,2373600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 00:32:06','2020-05-13 00:32:06',NULL),(15,'Mei','2020',14,'horas-gultom-mei-2020',1890000.00,2450000.00,0.00,2373600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 00:33:21','2020-05-13 00:33:21',NULL),(16,'Mei','2020',15,'ade-jefry-mei-2020',1120000.00,5220000.00,0.00,1615000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 00:35:44','2020-05-13 00:35:44',NULL),(17,'Mei','2020',16,'rukmidi-kurnia-budi-mei-2020',735000.00,3665000.00,0.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 00:38:07','2020-05-13 00:38:07',NULL),(18,'Mei','2020',17,'paisah-mei-2020',650000.00,2950000.00,0.00,858100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 00:40:02','2020-05-13 00:40:02',NULL),(19,'Mei','2020',18,'mulyana-mei-2020',500000.00,4000000.00,0.00,1155000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 00:41:33','2020-05-13 00:41:33',NULL),(20,'Mei','2020',19,'yanto-mei-2020',800000.00,2800000.00,0.00,128100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 00:42:20','2020-05-13 00:42:20',NULL),(21,'Mei','2020',20,'effendi-mei-2020',500000.00,250000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 00:43:23','2020-05-13 00:43:23',NULL),(22,'Mei','2020',21,'timbul-simangunsong-mm-mei-2020',1300000.00,2300000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 02:18:01','2020-05-13 02:18:01',NULL),(23,'Mei','2020',22,'rudy-saragih-se-ak-mei-2020',1050000.00,1250000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 02:18:50','2020-05-13 02:18:50',NULL),(24,'Mei','2020',23,'drs-reynold-l-tobing-ak-mei-2020',5800000.00,5100000.00,1050000.00,30000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 02:20:06','2020-05-13 02:20:06',NULL),(25,'Mei','2020',24,'loeky-rono-pradopo-mm-mei-2020',2070000.00,8370000.00,0.00,238800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 02:21:31','2020-05-13 02:21:31',NULL),(26,'Mei','2020',25,'rina-dameria-napitupulu-mm-mei-2020',2090000.00,3250000.00,2100000.00,243600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 02:24:25','2020-05-13 02:24:25',NULL),(27,'Mei','2020',26,'arie-martin-napitupulu-mm-mei-2020',1980000.00,2950000.00,0.00,227200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 02:25:33','2020-05-13 02:25:33',NULL),(28,'Mei','2020',27,'sopar-silaen-mm-mei-2020',700000.00,700000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 02:26:38','2020-05-13 02:26:38',NULL),(29,'Mei','2020',28,'titi-aslah-m-ak-mei-2020',4680000.00,15080000.00,4150000.00,425200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 02:32:33','2020-05-13 02:32:33',NULL),(30,'Mei','2020',29,'indah-purwani-mei-2020',1500000.00,2500000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 02:33:57','2020-05-13 02:33:57',NULL),(31,'Mei','2020',30,'zulkarnain-mei-2020',1950000.00,6750000.00,0.00,160500.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 02:35:26','2020-05-13 02:35:26',NULL),(32,'Mei','2020',31,'anna-yulisca-mei-2020',3450000.00,4800000.00,2100000.00,277500.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 02:36:32','2020-05-13 02:36:32',NULL),(33,'Mei','2020',32,'febrianti-ratnasari-se-mei-2020',1900000.00,2370000.00,0.00,158100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 02:37:58','2020-05-13 02:37:58',NULL),(34,'Mei','2020',33,'novianti-silalahi-se-mei-2020',1900000.00,2370000.00,0.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 02:39:05','2020-05-13 02:39:05',NULL),(35,'Mei','2020',34,'supoco-mei-2020',650000.00,7635600.00,0.00,158100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 03:11:13','2020-05-13 03:11:13',NULL),(36,'Mei','2020',35,'susanto-mei-2020',650000.00,5292800.00,0.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 03:12:16','2020-05-13 03:12:16',NULL),(37,'Mei','2020',36,'suratmi-mei-2020',680000.00,4580000.00,0.00,1515800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 03:26:06','2020-05-13 03:26:06',NULL),(38,'Mei','2020',37,'asep-apidin-mei-2020',690000.00,4215000.00,0.00,1437500.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 03:30:34','2020-05-13 03:30:34',NULL),(39,'Mei','2020',38,'embad-mei-2020',530000.00,4330000.00,0.00,1245000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-05-13 03:31:37','2020-05-13 03:31:37',NULL),(40,'Juni','2020',1,'hardi-benry-simbolon-ir-juni-2020',1400000.00,1600000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 14:28:57','2020-06-28 14:28:57',NULL),(41,'Juni','2020',2,'ifan-junaedi-m-kom-juni-2020',2040000.00,3200000.00,0.00,187200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 14:30:55','2020-06-28 14:33:46',NULL),(42,'Juni','2020',3,'zulhalim-m-kom-juni-2020',1000000.00,1400000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 14:31:30','2020-06-28 14:34:20',NULL),(43,'Juni','2020',4,'thomas-budiman-m-kom-juni-2020',1000000.00,1400000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 14:35:26','2020-06-28 14:35:26',NULL),(44,'Juni','2020',5,'ihsan-nur-se-juni-2020',1750000.00,2850000.00,550000.00,2513600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 14:39:16','2020-06-28 14:39:16',NULL),(45,'Juni','2020',10,'rachmawaty-haroen-mm-juni-2020',1750000.00,2850000.00,0.00,2513600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 14:41:20','2020-06-28 14:41:20',NULL),(46,'Juni','2020',6,'hetty-farida-se-juni-2020',1800000.00,2700000.00,1050000.00,208400.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 14:42:29','2020-06-28 14:42:29',NULL),(47,'Juni','2020',8,'asih-septiarini-se-juni-2020',1700000.00,2650000.00,1575000.00,203800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 14:44:01','2020-06-28 14:44:01',NULL),(48,'Juni','2020',7,'usman-gultom-m-kom-juni-2020',1750000.00,2600000.00,1575000.00,203800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 14:45:34','2020-06-28 14:45:34',NULL),(49,'Juni','2020',11,'natalia-kristina-juni-2020',3400000.00,4270000.00,2075000.00,336800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 14:49:55','2020-06-28 14:49:55',NULL),(50,'Juni','2020',12,'suwarno-a-md-juni-2020',1950000.00,2400000.00,1050000.00,204000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 15:05:26','2020-06-28 15:05:26',NULL),(51,'Juni','2020',9,'anton-sianipar-m-pd-juni-2020',1680000.00,3250000.00,840000.00,177900.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 15:11:24','2020-06-28 15:11:24',NULL),(52,'Juni','2020',13,'rosmawati-hutabarat-juni-2020',1850000.00,2490000.00,0.00,2373600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 15:12:37','2020-06-28 15:12:37',NULL),(53,'Juni','2020',14,'horas-gultom-juni-2020',1890000.00,2450000.00,0.00,2373600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 15:13:55','2020-06-28 15:13:55',NULL),(54,'Juni','2020',15,'ade-jefry-juni-2020',1120000.00,2050000.00,0.00,1615000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 15:14:55','2020-06-28 15:14:55',NULL),(55,'Juni','2020',18,'mulyana-juni-2020',500000.00,1050000.00,0.00,30000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 15:17:01','2020-06-28 15:17:01',NULL),(56,'Juni','2020',17,'paisah-juni-2020',650000.00,1150000.00,720000.00,158100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 15:18:14','2020-06-28 15:18:14',NULL),(57,'Juni','2020',16,'rukmidi-kurnia-budi-juni-2020',735000.00,1465000.00,775000.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 15:19:19','2020-06-28 15:19:19',NULL),(58,'Juni','2020',19,'yanto-juni-2020',800000.00,1000000.00,0.00,128100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 15:20:11','2020-06-28 15:20:11',NULL),(59,'Juni','2020',20,'effendi-juni-2020',500000.00,250000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-28 15:20:48','2020-06-28 15:20:48',NULL),(60,'Juni','2020',21,'timbul-simangunsong-mm-juni-2020',1300000.00,2300000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 02:33:30','2020-06-29 02:33:30',NULL),(61,'Juni','2020',23,'drs-reynold-l-tobing-ak-juni-2020',5800000.00,5100000.00,2080000.00,30000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 02:40:05','2020-06-29 02:40:05',NULL),(62,'Juni','2020',22,'rudy-saragih-se-ak-juni-2020',1050000.00,1250000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 02:40:56','2020-06-29 02:40:56',NULL),(63,'Juni','2020',26,'arie-martin-napitupulu-mm-juni-2020',1980000.00,2950000.00,0.00,227200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 02:46:02','2020-06-29 02:46:02',NULL),(64,'Juni','2020',24,'loeky-rono-pradopo-mm-juni-2020',2070000.00,3150000.00,0.00,238800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 02:47:12','2020-06-29 02:47:12',NULL),(65,'Juni','2020',25,'rina-dameria-napitupulu-mm-juni-2020',2090000.00,3250000.00,0.00,243600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 02:48:47','2020-06-29 02:48:47',NULL),(66,'Juni','2020',27,'sopar-silaen-mm-juni-2020',700000.00,700000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 02:49:59','2020-06-29 02:49:59',NULL),(67,'Juni','2020',28,'titi-aslah-m-ak-juni-2020',4680000.00,5200000.00,2575000.00,425200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 02:51:14','2020-06-29 02:51:14',NULL),(68,'Juni','2020',30,'zulkarnain-juni-2020',1950000.00,2400000.00,1500000.00,160500.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 02:52:22','2020-06-29 02:52:22',NULL),(69,'Juni','2020',31,'anna-yulisca-juni-2020',3450000.00,4800000.00,0.00,4402500.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 02:54:08','2020-06-29 02:54:08',NULL),(70,'Juni','2020',33,'indah-purwani-juni-2020',1900000.00,2370000.00,0.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 02:54:44','2020-06-29 02:57:00',NULL),(71,'Juni','2020',34,'supoco-juni-2020',650000.00,6288450.00,525000.00,158100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 03:05:41','2020-06-29 03:08:30',NULL),(72,'Juni','2020',35,'susanto-juni-2020',650000.00,3423700.00,735000.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 04:31:38','2020-06-29 04:31:38',NULL),(73,'Juni','2020',36,'suratmi-juni-2020',680000.00,1250000.00,50000.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 04:32:51','2020-06-29 04:32:51',NULL),(74,'Juni','2020',37,'asep-apidin-juni-2020',690000.00,1400000.00,0.00,30000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 04:33:46','2020-06-29 04:33:46',NULL),(75,'Juni','2020',38,'embad-juni-2020',530000.00,1200000.00,0.00,30000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 04:34:25','2020-06-29 04:34:25',NULL),(76,'Juni','2020',32,'febrianti-ratnasari-se-juni-2020',1900000.00,2370000.00,0.00,158100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-29 04:38:33','2020-06-29 04:38:33',NULL),(77,'Juni','2020',29,'indah-purwani-juni-2020-1',1500000.00,500000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-06-30 09:53:01','2020-06-30 09:53:52',NULL),(78,'Juli','2020',1,'hardi-benry-simbolon-ir-juli-2020',1400000.00,1600000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-28 13:17:50','2020-07-28 13:17:50',NULL),(79,'Juli','2020',2,'ifan-junaedi-m-kom-juli-2020',2040000.00,3200000.00,0.00,187200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-28 13:19:24','2020-07-28 13:22:41',NULL),(80,'Juli','2020',3,'zulhalim-m-kom-juli-2020',1000000.00,1400000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-28 13:23:26','2020-07-28 13:23:26',NULL),(81,'Juli','2020',4,'thomas-budiman-m-kom-juli-2020',1000000.00,1400000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-28 13:24:01','2020-07-28 13:24:01',NULL),(82,'Juli','2020',6,'hetty-farida-se-juli-2020',1800000.00,2700000.00,1050000.00,208400.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-28 13:26:49','2020-07-28 13:26:49',NULL),(83,'Juli','2020',20,'usman-gultom-m-kom-juli-2020',500000.00,250000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-28 13:28:28','2020-07-28 13:44:52',NULL),(84,'Juli','2020',7,'usman-gultom-m-kom-juli-2020-1',1750000.00,2600000.00,1575000.00,203800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-28 13:57:40','2020-07-28 13:57:40',NULL),(85,'Juli','2020',8,'asih-septiarini-se-juli-2020',1700000.00,2650000.00,1575000.00,203800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-28 13:59:11','2020-07-28 13:59:11',NULL),(86,'Juli','2020',9,'anton-sianipar-m-pd-juli-2020',1680000.00,3250000.00,840000.00,177900.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-28 14:01:00','2020-07-28 14:01:00',NULL),(87,'Juli','2020',10,'rachmawaty-haroen-mm-juli-2020',1750000.00,2850000.00,0.00,2513600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-28 14:02:39','2020-07-28 14:03:50',NULL),(88,'Juli','2020',11,'natalia-kristina-juli-2020',3400000.00,4270000.00,2075000.00,336800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 13:59:57','2020-07-29 13:59:57',NULL),(89,'Juli','2020',12,'suwarno-a-md-juli-2020',1950000.00,2400000.00,1050000.00,204000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:01:26','2020-07-29 14:01:26',NULL),(90,'Juli','2020',13,'rosmawati-hutabarat-juli-2020',1850000.00,2490000.00,0.00,2373600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:03:00','2020-07-29 14:03:00',NULL),(91,'Juli','2020',14,'horas-gultom-juli-2020',1890000.00,2450000.00,0.00,2373600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:04:07','2020-07-29 14:04:07',NULL),(92,'Juli','2020',15,'ade-jefry-juli-2020',1120000.00,2050000.00,0.00,1615000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:05:30','2020-07-29 14:05:30',NULL),(93,'Juli','2020',16,'rukmidi-kurnia-budi-juli-2020',735000.00,1465000.00,500000.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:06:48','2020-07-29 14:06:48',NULL),(94,'Juli','2020',17,'paisah-juli-2020',650000.00,1150000.00,550000.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:07:44','2020-07-29 14:07:44',NULL),(95,'Juli','2020',18,'mulyana-juli-2020',500000.00,1050000.00,157500.00,30000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:08:45','2020-07-29 14:08:45',NULL),(96,'Juli','2020',19,'yanto-juli-2020',800000.00,1000000.00,0.00,128100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:10:36','2020-07-29 14:10:36',NULL),(97,'Juli','2020',21,'timbul-simangunsong-mm-juli-2020',1300000.00,2300000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:19:56','2020-07-29 14:19:56',NULL),(98,'Juli','2020',22,'rudy-saragih-se-ak-juli-2020',1050000.00,1250000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:21:01','2020-07-29 14:21:01',NULL),(99,'Juli','2020',23,'drs-reynold-l-tobing-ak-juli-2020',5800000.00,5100000.00,1050000.00,30000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:24:07','2020-07-29 14:24:07',NULL),(100,'Juli','2020',24,'loeky-rono-pradopo-mm-juli-2020',2070000.00,3150000.00,0.00,238800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:29:37','2020-07-29 14:42:06',NULL),(101,'Juli','2020',25,'rina-dameria-napitupulu-mm-juli-2020',2090000.00,3250000.00,2100000.00,243600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:43:36','2020-07-29 14:43:36',NULL),(102,'Juli','2020',26,'arie-martin-napitupulu-mm-juli-2020',1980000.00,2950000.00,0.00,227200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:44:34','2020-07-29 14:44:34',NULL),(103,'Juli','2020',27,'sopar-silaen-mm-juli-2020',700000.00,700000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:45:19','2020-07-29 14:45:19',NULL),(104,'Juli','2020',28,'titi-aslah-m-ak-juli-2020',4680000.00,5200000.00,2575000.00,425200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:46:40','2020-07-29 14:46:40',NULL),(105,'Juli','2020',29,'indah-purwani-juli-2020',1500000.00,500000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:47:11','2020-07-29 14:47:28',NULL),(106,'Juli','2020',30,'zulkarnain-juli-2020',1950000.00,2400000.00,0.00,160500.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:49:55','2020-07-29 14:49:55',NULL),(107,'Juli','2020',31,'anna-yulisca-juli-2020',3450000.00,4800000.00,0.00,4402500.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:51:20','2020-07-29 14:51:20',NULL),(108,'Juli','2020',32,'febrianti-ratnasari-se-juli-2020',1900000.00,2370000.00,0.00,158100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:52:21','2020-07-29 14:52:21',NULL),(109,'Juli','2020',33,'novianti-silalahi-se-juli-2020',1900000.00,2370000.00,0.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:53:15','2020-07-29 14:53:15',NULL),(110,'Juli','2020',34,'supoco-juli-2020',650000.00,3868850.00,525000.00,158100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 14:57:39','2020-07-29 14:57:39',NULL),(111,'Juli','2020',35,'susanto-juli-2020',650000.00,2484450.00,735000.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 15:08:27','2020-07-29 15:08:27',NULL),(112,'Juli','2020',36,'suratmi-juli-2020',680000.00,1250000.00,262500.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 15:09:32','2020-07-29 15:09:32',NULL),(113,'Juli','2020',37,'asep-apidin-juli-2020',690000.00,1400000.00,262500.00,30000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 15:10:46','2020-07-29 15:10:46',NULL),(114,'Juli','2020',38,'embad-juli-2020',530000.00,1200000.00,262500.00,30000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-07-29 15:11:39','2020-07-29 15:11:39',NULL),(115,'Agustus','2020',1,'hardi-benry-simbolon-ir-agustus-2020',1400000.00,1600000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:16:00','2020-08-25 02:16:00',NULL),(116,'Agustus','2020',2,'ifan-junaedi-m-kom-agustus-2020',2040000.00,3200000.00,0.00,187200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:17:01','2020-08-25 02:17:01',NULL),(117,'Agustus','2020',3,'zulhalim-m-kom-agustus-2020',1000000.00,1400000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:18:26','2020-08-25 02:18:26',NULL),(118,'Agustus','2020',4,'thomas-budiman-m-kom-agustus-2020',1000000.00,1400000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:19:21','2020-08-25 02:19:21',NULL),(119,'Agustus','2020',6,'hetty-farida-se-agustus-2020',1800000.00,2700000.00,1050000.00,208400.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:21:19','2020-08-25 02:21:19',NULL),(120,'Agustus','2020',7,'usman-gultom-m-kom-agustus-2020',1750000.00,2600000.00,0.00,203800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:22:53','2020-08-25 02:22:53',NULL),(121,'Agustus','2020',8,'asih-septiarini-se-agustus-2020',1700000.00,2650000.00,1575000.00,203800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:24:06','2020-08-25 02:24:06',NULL),(122,'Agustus','2020',9,'anton-sianipar-m-pd-agustus-2020',1680000.00,3250000.00,840000.00,177900.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:25:20','2020-08-25 02:25:20',NULL),(123,'Agustus','2020',10,'rachmawaty-haroen-mm-agustus-2020',1750000.00,2850000.00,0.00,2513600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:27:48','2020-08-25 02:27:48',NULL),(124,'Agustus','2020',11,'natalia-kristina-agustus-2020',3400000.00,4270000.00,2075000.00,336800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:29:33','2020-08-25 02:29:33',NULL),(125,'Agustus','2020',12,'suwarno-a-md-agustus-2020',1950000.00,2400000.00,1050000.00,204000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:30:45','2020-08-25 02:30:45',NULL),(126,'Agustus','2020',13,'rosmawati-hutabarat-agustus-2020',1850000.00,2490000.00,525000.00,2373600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:35:18','2020-08-25 02:35:18',NULL),(127,'Agustus','2020',14,'horas-gultom-agustus-2020',1890000.00,2450000.00,0.00,2373600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:36:20','2020-08-25 02:36:20',NULL),(128,'Agustus','2020',15,'ade-jefry-agustus-2020',1120000.00,2050000.00,0.00,1615000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:37:16','2020-08-25 02:37:16',NULL),(129,'Agustus','2020',18,'mulyana-agustus-2020',500000.00,1050000.00,157500.00,30000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:38:16','2020-08-25 02:38:16',NULL),(130,'Agustus','2020',19,'yanto-agustus-2020',800000.00,1000000.00,0.00,128100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:39:01','2020-08-25 02:39:01',NULL),(131,'Agustus','2020',20,'effendi-agustus-2020',500000.00,250000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:39:36','2020-08-25 02:39:36',NULL),(132,'Agustus','2020',16,'rukmidi-kurnia-budi-agustus-2020',735000.00,1465000.00,500000.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 02:41:03','2020-08-25 02:41:03',NULL),(133,'Agustus','2020',21,'timbul-simangunsong-mm-agustus-2020',1300000.00,2300000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:19:30','2020-08-25 03:19:30',NULL),(134,'Agustus','2020',23,'drs-reynold-l-tobing-ak-agustus-2020',5800000.00,5100000.00,1000000.00,30000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:24:13','2020-08-25 03:24:13',NULL),(135,'Agustus','2020',22,'rudy-saragih-se-ak-agustus-2020',1050000.00,1250000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:25:27','2020-08-25 03:25:27',NULL),(136,'Agustus','2020',24,'loeky-rono-pradopo-mm-agustus-2020',2070000.00,3150000.00,0.00,238800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:26:25','2020-08-25 03:26:25',NULL),(137,'Agustus','2020',25,'rina-dameria-napitupulu-mm-agustus-2020',2090000.00,3250000.00,2100000.00,243600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:27:25','2020-08-25 03:27:25',NULL),(138,'Agustus','2020',26,'arie-martin-napitupulu-mm-agustus-2020',1980000.00,2950000.00,0.00,227200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:28:05','2020-08-25 03:28:05',NULL),(139,'Agustus','2020',27,'sopar-silaen-mm-agustus-2020',700000.00,700000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:28:38','2020-08-25 03:28:38',NULL),(140,'Agustus','2020',28,'titi-aslah-m-ak-agustus-2020',4680000.00,5200000.00,3150000.00,425200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:29:49','2020-08-25 03:29:49',NULL),(141,'Agustus','2020',29,'indah-purwani-agustus-2020',1500000.00,2500000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:30:19','2020-08-25 03:31:11','2020-08-25 03:31:11'),(142,'Agustus','2020',29,'indah-purwani-agustus-2020',1500000.00,500000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:31:41','2020-08-25 03:31:41',NULL),(143,'Agustus','2020',30,'zulkarnain-agustus-2020',1950000.00,2400000.00,1500000.00,160500.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:33:08','2020-08-25 03:33:08',NULL),(144,'Agustus','2020',31,'anna-yulisca-agustus-2020',3450000.00,4800000.00,0.00,4402500.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:34:24','2020-08-25 03:34:24',NULL),(145,'Agustus','2020',32,'febrianti-ratnasari-se-agustus-2020',1900000.00,2370000.00,0.00,158100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:36:11','2020-08-25 03:36:11',NULL),(146,'Agustus','2020',33,'novianti-silalahi-se-agustus-2020',1900000.00,2370000.00,525000.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:37:16','2020-08-25 03:37:16',NULL),(147,'Agustus','2020',34,'supoco-agustus-2020',650000.00,4244600.00,525000.00,158100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:43:47','2020-08-25 03:43:47',NULL),(148,'Agustus','2020',35,'susanto-agustus-2020',650000.00,2672300.00,735000.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:44:36','2020-08-25 03:44:36',NULL),(149,'Agustus','2020',36,'suratmi-agustus-2020',680000.00,1250000.00,262500.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:45:37','2020-08-25 03:45:37',NULL),(150,'Agustus','2020',37,'asep-apidin-agustus-2020',690000.00,1400000.00,262500.00,30000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:46:33','2020-08-25 03:46:33',NULL),(151,'Agustus','2020',38,'embad-agustus-2020',530000.00,1200000.00,262500.00,30000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-08-25 03:47:19','2020-08-25 03:47:19',NULL),(152,'September','2020',20,'effendi-september-2020',500000.00,250000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:07:06','2020-10-10 08:07:06',NULL),(153,'September','2020',19,'yanto-september-2020',800000.00,1000000.00,0.00,128100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:08:10','2020-10-10 08:08:10',NULL),(154,'September','2020',16,'rukmidi-kurnia-budi-september-2020',735000.00,1465000.00,500000.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:09:58','2020-10-10 08:09:58',NULL),(155,'September','2020',18,'mulyana-september-2020',500000.00,1050000.00,157500.00,30000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:11:47','2020-10-10 08:13:12',NULL),(156,'September','2020',15,'ade-jefry-september-2020',1120000.00,2050000.00,0.00,1615000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:26:42','2020-10-10 08:26:42',NULL),(157,'September','2020',14,'horas-gultom-september-2020',1890000.00,2450000.00,0.00,2373600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:27:49','2020-10-10 08:27:49',NULL),(158,'September','2020',13,'rosmawati-hutabarat-september-2020',1850000.00,2490000.00,525000.00,2373600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:29:01','2020-10-10 08:29:01',NULL),(159,'September','2020',12,'suwarno-a-md-september-2020',1950000.00,2400000.00,1050000.00,204000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:30:13','2020-10-10 08:30:13',NULL),(160,'September','2020',11,'natalia-kristina-september-2020',3400000.00,4270000.00,2075000.00,336800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:31:17','2020-10-10 08:31:17',NULL),(161,'September','2020',10,'rachmawaty-haroen-mm-september-2020',1750000.00,2850000.00,0.00,2513600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:32:19','2020-10-10 08:32:19',NULL),(162,'September','2020',9,'anton-sianipar-m-pd-september-2020',1680000.00,3250000.00,840000.00,177900.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:33:35','2020-10-10 08:33:35',NULL),(163,'September','2020',8,'asih-septiarini-se-september-2020',1700000.00,2650000.00,0.00,203800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:34:38','2020-10-10 08:34:38',NULL),(164,'September','2020',7,'usman-gultom-m-kom-september-2020',1750000.00,2600000.00,0.00,203800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:36:42','2020-10-10 08:36:42',NULL),(165,'September','2020',6,'hetty-farida-se-september-2020',1800000.00,2700000.00,1050000.00,208400.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:37:33','2020-10-10 08:37:33',NULL),(166,'September','2020',4,'thomas-budiman-m-kom-september-2020',1000000.00,1400000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:38:06','2020-10-10 08:38:06',NULL),(167,'September','2020',3,'zulhalim-m-kom-september-2020',1000000.00,1400000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:38:59','2020-10-10 08:38:59',NULL),(168,'September','2020',2,'ifan-junaedi-m-kom-september-2020',2040000.00,3200000.00,0.00,187200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:39:59','2020-10-10 08:39:59',NULL),(169,'September','2020',1,'hardi-benry-simbolon-ir-september-2020',1400000.00,1600000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:40:25','2020-10-10 08:40:25',NULL),(170,'September','2020',39,'ir-sugeng-waluyo-september-2020',1250000.00,500000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:41:57','2020-10-10 08:41:57',NULL),(171,'September','2020',21,'timbul-simangunsong-mm-september-2020',1300000.00,2300000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:43:24','2020-10-10 08:43:24',NULL),(172,'September','2020',22,'rudy-saragih-se-ak-september-2020',1050000.00,1250000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:44:15','2020-10-10 08:44:15',NULL),(173,'September','2020',23,'drs-reynold-l-tobing-ak-september-2020',5800000.00,5100000.00,1000000.00,30000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:45:19','2020-10-10 08:45:19',NULL),(174,'September','2020',24,'loeky-rono-pradopo-mm-september-2020',2070000.00,3150000.00,0.00,238800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:46:11','2020-10-10 08:46:11',NULL),(175,'September','2020',25,'rina-dameria-napitupulu-mm-september-2020',2090000.00,3250000.00,2100000.00,243600.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:56:13','2020-10-10 08:56:13',NULL),(176,'September','2020',26,'arie-martin-napitupulu-mm-september-2020',1980000.00,2950000.00,0.00,227200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:57:26','2020-10-10 08:57:26',NULL),(177,'September','2020',27,'sopar-silaen-mm-september-2020',700000.00,700000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:58:14','2020-10-10 08:58:14',NULL),(178,'September','2020',28,'titi-aslah-m-ak-september-2020',4680000.00,5200000.00,2100000.00,425200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:59:14','2020-10-10 08:59:14',NULL),(179,'September','2020',29,'indah-purwani-september-2020',1500000.00,500000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 08:59:48','2020-10-10 08:59:48',NULL),(180,'September','2020',30,'zulkarnain-september-2020',1950000.00,2400000.00,1500000.00,160500.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 09:01:24','2020-10-10 09:01:24',NULL),(181,'September','2020',31,'anna-yulisca-september-2020',3450000.00,4800000.00,0.00,4402500.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 09:02:22','2020-10-10 09:02:22',NULL),(182,'September','2020',32,'febrianti-ratnasari-se-september-2020',1900000.00,2370000.00,0.00,158100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 09:03:28','2020-10-10 09:03:28',NULL),(183,'September','2020',33,'novianti-silalahi-se-september-2020',1900000.00,2370000.00,525000.00,200800.00,'Sudah Dibayar',NULL,'BCA','5465125087','NOVIANTI SILALAHI','receipt-novianti-silalahi-se-september-2020.png','2020-10-10 09:04:20','2020-10-24 19:04:13',NULL),(184,'September','2020',36,'suratmi-september-2020',680000.00,1250000.00,262500.00,355200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 09:06:00','2020-10-10 09:06:00',NULL),(185,'September','2020',37,'asep-apidin-september-2020',690000.00,1400000.00,262500.00,197200.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 09:07:05','2020-10-10 09:08:40',NULL),(186,'September','2020',38,'embad-september-2020',530000.00,1200000.00,262500.00,30000.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 09:09:29','2020-10-10 09:09:29',NULL),(187,'September','2020',34,'supoco-september-2020',650000.00,4996000.00,525000.00,158100.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 09:12:13','2020-10-10 09:12:13',NULL),(188,'September','2020',35,'susanto-september-2020',650000.00,2219500.00,735000.00,200800.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-10-10 09:13:08','2020-10-10 09:13:08',NULL),(189,'November','2020',1,'hardi-benry-simbolon-ir-november-2020',1400000.00,1600000.00,0.00,0.00,'Belum Dibayar',NULL,NULL,NULL,NULL,NULL,'2020-11-27 14:14:43','2020-11-27 14:14:43',NULL);
/*!40000 ALTER TABLE `tb_pembayaran_gaji` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2020-12-07 11:34:06
