hitung_proses_dalam_hari_kerja.sql

# Dump of table ek_application
# ------------------------------------------------------------

DROP TABLE IF EXISTS `ek_application`;

CREATE TABLE `ek_application` (
  `appl_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `appl_reason` varchar(5000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `appl_type` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'see Ekompaun\\Systemconfig\\Enum\\AppealType',
  `appl_channel` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'see Ekompaun\\Systemconfig\\Enum\\AppealChannel',
  `appl_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `appl_phonenumber` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `appl_date` datetime NOT NULL,
  `appl_decisiondate` datetime DEFAULT NULL,
  `appl_personincharge` int(11) DEFAULT NULL COMMENT 'users',
  `appl_assigndate` datetime DEFAULT NULL,
  `appl_approveamount` decimal(15,2) DEFAULT NULL,
  `appl_approveby` int(11) DEFAULT NULL COMMENT 'users',
  `appl_remark` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fk_campid` int(10) unsigned DEFAULT NULL COMMENT 'ek_campaign_master',
  `appl_campamount` decimal(15,2) DEFAULT NULL,
  `appl_gst` decimal(15,2) DEFAULT '0.00',
  `appl_revert_indi` int(10) unsigned DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL COMMENT 'users',
  `created_date` datetime DEFAULT NULL,
  `modify_by` int(11) DEFAULT NULL COMMENT 'users',
  `modify_date` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`appl_id`),
  KEY `appl_type` (`appl_type`),
  KEY `fk_campid` (`fk_campid`),
  CONSTRAINT `ek_application_ibfk_4` FOREIGN KEY (`fk_campid`) REFERENCES `ek_campaign_master` (`camp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `ek_application` WRITE;
/*!40000 ALTER TABLE `ek_application` DISABLE KEYS */;

INSERT INTO `ek_application` (`appl_id`, `appl_reason`, `appl_type`, `appl_channel`, `appl_email`, `appl_phonenumber`, `appl_date`, `appl_decisiondate`, `appl_personincharge`, `appl_assigndate`, `appl_approveamount`, `appl_approveby`, `appl_remark`, `fk_campid`, `appl_campamount`, `appl_gst`, `appl_revert_indi`, `created_by`, `created_date`, `modify_by`, `modify_date`, `deleted_at`)
VALUES
	(1,'Saya tak sengaja melanggar pak, sedang buru-buru antar anak sekolah',1,2,NULL,'212-309-4530 x713','2017-12-29 12:13:04','2018-01-03 09:13:04',34,'2018-07-30 23:24:52',NULL,NULL,'Ut et non officia sunt cupiditate.',NULL,NULL,0.00,NULL,78,'2018-06-26 12:13:04',NULL,'2018-07-30 23:24:53',NULL),
	(2,'Saya warga miskin',1,1,NULL,NULL,'2018-01-03 08:20:00','2018-01-05 15:40:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL),
	(34,'Saya warga miskin',1,1,NULL,NULL,'2018-01-03 08:20:00','2018-01-08 15:40:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL);

/*!40000 ALTER TABLE `ek_application` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table ek_holiday
# ------------------------------------------------------------

DROP TABLE IF EXISTS `ek_holiday`;

CREATE TABLE `ek_holiday` (
  `hday_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `hday_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hday_date_from` date DEFAULT NULL,
  `hday_date_to` date DEFAULT NULL,
  `hday_status` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `modify_by` int(11) DEFAULT NULL,
  `modify_date` datetime DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_date` datetime DEFAULT NULL,
  PRIMARY KEY (`hday_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `ek_holiday` WRITE;
/*!40000 ALTER TABLE `ek_holiday` DISABLE KEYS */;

INSERT INTO `ek_holiday` (`hday_id`, `hday_name`, `hday_date_from`, `hday_date_to`, `hday_status`, `created_by`, `created_date`, `modify_by`, `modify_date`, `deleted_by`, `deleted_date`)
VALUES
	(1,'LIbur tahun baru','2018-01-01','2018-01-02',1,NULL,NULL,NULL,NULL,NULL,NULL);

/*!40000 ALTER TABLE `ek_holiday` ENABLE KEYS */;
UNLOCK TABLES;