Da

✏️ Editing: pertamac_mcm.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: pertamac_mcm
-- ------------------------------------------------------
-- Server version	10.5.26-MariaDB-log

/*!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 */;

--
-- Current Database: `pertamac_mcm`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `pertamac_mcm` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;

USE `pertamac_mcm`;

--
-- Table structure for table `address`
--

DROP TABLE IF EXISTS `address`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `address` (
  `address_id` int(5) NOT NULL AUTO_INCREMENT,
  `employee_id` varchar(10) NOT NULL,
  `address1` varchar(255) NOT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `address3` varchar(255) NOT NULL,
  PRIMARY KEY (`address_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `address`
--

LOCK TABLES `address` WRITE;
/*!40000 ALTER TABLE `address` DISABLE KEYS */;
INSERT INTO `address` VALUES (1,'GM00001','226/327 อาคารริเวียร่า 3 ชั้นที่ 15C','ตำบลบางพูด อำเภอปากเกร็ด','จังหวัดนนทบุรี 11120'),(2,'GM00002','115/80 หมู่บ้าน บ้านฟ้าปิยรมย์เทนโดร หมู่ที่ 4','ตำบลบึงคำพร้อย อำเภอลำลูกกา','จังหวัดปทุมธานี 12150'),(3,'GM00003','115/80 หมู่บ้าน ฟ้าปิยรมย์เทนโดร หมู่ที่ 4','ตำบลบึงคำพร้อย อำเภอลำลูกกา','จังหวัดปทุมธานี 12150'),(4,'GM00004','129/81 หมู่ 4','ตำบลบางเมือง อำเภอเมืองสมุทรปราการ','จังหวัดสมุทรปราการ 10270'),(5,'GM00005','88/102 หมู่ 8','ตำบลเทพารักษ์  อำเภอเมืองสมุทรปราการ','จังหวัดสมุทรปราการ 10270'),(6,'GM00006','32/24 หมู่ 1 หอพักดาวเรืองรีสอร์ท','ตำบลคลองหก อำเภอลำลูกกา','จังหวัดปทุมธานี 12120'),(7,'GM00007','55/702 หมู่ 6','ตำบลบึงคำพร้อย อำเภอลำลูกกา','จังหวัดปทุมธานี 12150'),(8,'GM00008','115/269','ตำบลบึงคำพร้อย อำเภอลำลูกกา','จังหวัดปทุมธานี 12150'),(9,'GM00009','115/269 หมู่ 4','ตำบลบึงคำพร้อย อำเภอลำลูกกา','จังหวัดปทุมธานี 12150'),(10,'GM00010','ุ69/49 หมู่6','ตำบลลำลูกกา อำเภอลำลูกกา','จังหวัดปทุมธานี 12150'),(11,'OP00001','58 หมู่ที่ 1','ตำบลโคกขมิ้น อำเภอพลับพลาชัย','จังหวัดบุรีรัมย์ 31250'),(12,'OP00002','99/19 หมู่ 5 กรีนการ์เด้นโฮม 4','ตำบลลำลูกกา อำเภอลำลูกกา','จังหวัดปทุมธานี 12150'),(13,'OP00003','99/19 หมู่5','ตำบลลำลูกกา อำเภอลำลูกกา','จังหวัดปทุมธานี 12150'),(14,'OP00004','45/3 หมู่ 6','ตำบลลำลูกกา อำเภอลำลูกกา','จังหวัดปทุมธานี 12150'),(15,'OP00005','45/45 หมู่ 5','ตำบลลำลูกกา อำเภอลำลูกกา','จังหวัดปทุมธานี 12150'),(16,'OP00006','45/40 หมู่5','ตำบลลำลูกกา อำเภอลำลูกกา','จังหวัดปทุมธานี 12150');
/*!40000 ALTER TABLE `address` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `banks`
--

DROP TABLE IF EXISTS `banks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `banks` (
  `employee_id` varchar(10) NOT NULL,
  `bank_name` varchar(10) NOT NULL,
  `bank_account` varchar(20) NOT NULL,
  PRIMARY KEY (`employee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `banks`
--

LOCK TABLES `banks` WRITE;
/*!40000 ALTER TABLE `banks` DISABLE KEYS */;
INSERT INTO `banks` VALUES ('GM00001','SCB','4068188650'),('GM00002','SCB','3542264223'),('GM00003','SCB','3922262841'),('GM00004','SCB','338-267081-2'),('GM00005','KBANK','560-235809-9'),('GM00006','SCB','402-608486-6'),('GM00007','SCB','408-790283-7'),('GM00008','SCB','392-251787-2'),('GM00009','SCB','392-251788-0'),('GM00010','SCB','291-258685-1'),('OP00001','SCB','392-251402-8'),('OP00002','SCB','354-243801-8'),('OP00003','SCB','354-243802-6'),('OP00004','UOB','800-183499-1'),('OP00005','SCB','392-251403-6'),('OP00006','SCB','354-244002-3');
/*!40000 ALTER TABLE `banks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `branches`
--

DROP TABLE IF EXISTS `branches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `branches` (
  `company_id` varchar(13) NOT NULL,
  `branch_id` varchar(5) NOT NULL DEFAULT '00000',
  `branch_local` varchar(100) NOT NULL,
  `address1_local` varchar(100) NOT NULL,
  `address2_local` varchar(255) NOT NULL,
  `address3_local` varchar(255) NOT NULL,
  `branch_eng` varchar(100) NOT NULL,
  `address1_eng` varchar(255) NOT NULL,
  `address2_eng` varchar(255) NOT NULL,
  `address3_eng` varchar(255) NOT NULL,
  `wifi_bssid1` varchar(20) DEFAULT NULL,
  `wifi_bssid2` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`company_id`,`branch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `branches`
--

LOCK TABLES `branches` WRITE;
/*!40000 ALTER TABLE `branches` DISABLE KEYS */;
INSERT INTO `branches` VALUES ('0135564016067','00000','สำนักงานใหญ่','55/34 หมู่บ้านบิ๊กเกอร์แลนด์ หมู่ที่ 3','ตำบลลำลูกกา อำเภอลำลูกกา','จังหวัดปทุมธานี 12150','Head Office','No. 55/34, Mu 3,','Lam Luk Ka Sub-district, Lam Luk Ka District,','Pathum Thani Province 12150','70:F8:2B:E6:35:D5','70:F8:2B:E6:35:D9');
/*!40000 ALTER TABLE `branches` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `companies`
--

DROP TABLE IF EXISTS `companies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `companies` (
  `id` varchar(13) NOT NULL,
  `name_local` varchar(100) NOT NULL,
  `name_eng` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `companies`
--

LOCK TABLES `companies` WRITE;
/*!40000 ALTER TABLE `companies` DISABLE KEYS */;
INSERT INTO `companies` VALUES ('0135564016067','บริษัท เอ็ม ซี เอ็ม เคมีคอล จำกัด','MCM CHEMICAL CO.,LTD.');
/*!40000 ALTER TABLE `companies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `company_view`
--

DROP TABLE IF EXISTS `company_view`;
/*!50001 DROP VIEW IF EXISTS `company_view`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `company_view` AS SELECT
 1 AS `id`,
  1 AS `branch_id`,
  1 AS `branch_local`,
  1 AS `name_local`,
  1 AS `address1_local`,
  1 AS `address2_local`,
  1 AS `address3_local`,
  1 AS `branch_eng`,
  1 AS `name_eng`,
  1 AS `address1_eng`,
  1 AS `address2_eng`,
  1 AS `address3_eng` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `employee_view`
--

DROP TABLE IF EXISTS `employee_view`;
/*!50001 DROP VIEW IF EXISTS `employee_view`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `employee_view` AS SELECT
 1 AS `company_id`,
  1 AS `id_card`,
  1 AS `name_local`,
  1 AS `name_eng`,
  1 AS `employee_id`,
  1 AS `first_name`,
  1 AS `last_name`,
  1 AS `username`,
  1 AS `password`,
  1 AS `password_salt`,
  1 AS `user_status`,
  1 AS `url_image`,
  1 AS `branch_id`,
  1 AS `branch_local`,
  1 AS `wifi_bssid1`,
  1 AS `wifi_bssid2`,
  1 AS `mac_address`,
  1 AS `status` */;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `employees`
--

DROP TABLE IF EXISTS `employees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employees` (
  `employee_id` varchar(10) NOT NULL,
  `id_card` varchar(13) DEFAULT NULL,
  `title` varchar(10) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `first_name_en` varchar(100) DEFAULT NULL,
  `last_name_en` varchar(100) DEFAULT NULL,
  `position` varchar(100) DEFAULT NULL,
  `division` varchar(20) DEFAULT NULL,
  `employee_type` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone_no` varchar(200) DEFAULT NULL,
  `url_image` varchar(255) DEFAULT NULL,
  `start_date` date NOT NULL,
  `resign_date` date DEFAULT NULL,
  `company_id` varchar(13) DEFAULT NULL,
  `branch_id` varchar(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employees`
--

LOCK TABLES `employees` WRITE;
/*!40000 ALTER TABLE `employees` DISABLE KEYS */;
INSERT INTO `employees` VALUES ('GM00001','3519900009185','นาย','สุรพันธ์','มงคล','Suraphan','Mongkol','MD','MG','รายเดือน','suraphan@mcmchemical.com','0813742499',NULL,'2021-08-01',NULL,'0135564016067','00000'),('GM00002','3500500258228','นาย','ชยิน','มังคราช','Chayin','Mongkaraj','DMD','MG','รายเดือน','chayin@mcmchemical.com','0960805631','','2021-08-01',NULL,'0135564016067','00000'),('GM00003','3519900045734','นาง','เนตรนภิส','มงคล','Netnaphit','Mongkol','S&MM','ขาย','รายเดือน','netnaphit@mcmchemical.com','0863013132',NULL,'2021-08-01',NULL,'0135564016067','00000'),('GM00004','1119900185240','นาย','อนุวัฒน์','หมื่นโอวาท','Anuwat','Muen-owart','SSM','ขาย','รายเดือน','anuwatlike@gmail.com','0982818212',NULL,'2021-10-01',NULL,'0135564016067','00000'),('GM00005','3450900256347','นางสาว','ณัฎฐาญาฎา','วงศ์ศรีแก้ว','Natthayada','Wongsrikeaw','SSM','ขาย','รายเดือน','Chad.w95@gmail.com','0994546223',NULL,'2021-10-01',NULL,'0135564016067','00000'),('GM00006','1550500096132','นางสาว','วิลาวัลย์','มณีศรี','Wilawan','Maneesri','OP','ขาย','รายเดือน','mawilawan66@gmail.com','0652283829','images/thumbnail/GM00006.jpg','2021-10-01',NULL,'0135564016067','00000'),('GM00007','1103701996901','นางสาว','ลัดดา','แซ่โง้ว','Ladda','sae-ngow','OP','บัญชี','รายเดือน','MOOKMIX.lsfd@gmail.com','0957490481','images/thumbnail/GM00007.jpg','2021-10-16',NULL,'0135564016067','00000'),('GM00008','3501000680781','นางสาว','เยาวลักษณ์','คำทวี','Yaowaluk','Khamtawee','GM','วางแผน & จัดซื้อ','รายเดือน','y.khamtawee@gmail.com','0982648010',NULL,'2021-11-01',NULL,'0135564016067','00000'),('GM00009','3410600398901','นาย','พูนศักดิ์','ประทุมมาลี','Poolsak','Pratummalee','GM','ผลิต','รายเดือน','Poosak.pra@gmail.com','0866559539',NULL,'2021-11-14',NULL,'0135564016067','00000'),('GM00010','3200200316373','นางสาว','พัชรินทร์','สินทร','Putcharin','Sintorn','OP','วางแผน & จัดซื้อ','รายเดือน','pooputcharin1983@gmail.com','0904016605','images/thumbnail/GM00010.jpg','2021-09-10',NULL,'0135564016067','00000'),('OP00001','5310790029110','นางสาว','จีระนันท์','พินัยรัมย์','Jeeranan','Pinairam','OP','R&D','รายวัน','','0894963160','images/thumbnail/OP00001.jpg','2021-08-03',NULL,'0135564016067','00000'),('OP00002','3210600231863','นาย','ทองใบ','หาญชนะ','Thongbai','Hanchana','OP','คลังสินค้า','รายวัน',NULL,'0820986289',NULL,'2021-09-03',NULL,'0135564016067','00000'),('OP00003','1100200167801','นางสาว','ประกายดาว','ภูธร','Prakaydao','Puthorn','OP','R&D','รายวัน',NULL,'0955807764','images/thumbnail/OP00003.jpg','2021-09-03',NULL,'0135564016067','00000'),('OP00004','3130600367855','นาย','โกศล','สดาพงษ์','Kosol','Sadapong','OP','ผลิต','รายวัน',NULL,'0944390242','images/thumbnail/OP00004.jpg','2021-09-03',NULL,'0135564016067','00000'),('OP00005','3640100267105','นาย','ประทีป','ดอกมลฑา','Pratheep','Dokmontar','OP','ผลิต','รายวัน',NULL,'0832971709',NULL,'2021-09-03',NULL,'0135564016067','00000'),('OP00006','1100500628596','นาย','สุริยา','ฮาซัน','Suriya','Hasun','OP','ผลิต','รายวัน',NULL,'0949691285',NULL,'2021-09-10',NULL,'0135564016067','00000');
/*!40000 ALTER TABLE `employees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `time_card_report`
--

DROP TABLE IF EXISTS `time_card_report`;
/*!50001 DROP VIEW IF EXISTS `time_card_report`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `time_card_report` AS SELECT
 1 AS `id`,
  1 AS `employee_id`,
  1 AS `Date`,
  1 AS `StartTime`,
  1 AS `CheckIn`,
  1 AS `StartDif`,
  1 AS `EndTime`,
  1 AS `CheckOut`,
  1 AS `EndDif`,
  1 AS `Ot_x1`,
  1 AS `Ot_x1_5`,
  1 AS `Ot_x2`,
  1 AS `Ot_x3`,
  1 AS `ot_approver`,
  1 AS `approv_name`,
  1 AS `wifi_bssid_in`,
  1 AS `wifi_bssid_out` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `time_card_view`
--

DROP TABLE IF EXISTS `time_card_view`;
/*!50001 DROP VIEW IF EXISTS `time_card_view`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `time_card_view` AS SELECT
 1 AS `date`,
  1 AS `id`,
  1 AS `employee_id`,
  1 AS `start_time`,
  1 AS `end_time`,
  1 AS `ot_x1`,
  1 AS `ot_x1_5`,
  1 AS `ot_x2`,
  1 AS `ot_x3`,
  1 AS `ot_approver`,
  1 AS `approv_name`,
  1 AS `wifi_bssid_in`,
  1 AS `wifi_bssid_out`,
  1 AS `note` */;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `time_cards`
--

DROP TABLE IF EXISTS `time_cards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `time_cards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` varchar(10) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime DEFAULT NULL,
  `ot_x1` decimal(5,2) DEFAULT NULL,
  `ot_x1_5` decimal(5,2) DEFAULT NULL,
  `ot_x2` decimal(5,2) DEFAULT NULL,
  `ot_x3` decimal(5,2) DEFAULT NULL,
  `ot_approver` varchar(10) DEFAULT NULL,
  `wifi_bssid_in` varchar(20) DEFAULT NULL,
  `wifi_bssid_out` varchar(20) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `time_cards`
--

LOCK TABLES `time_cards` WRITE;
/*!40000 ALTER TABLE `time_cards` DISABLE KEYS */;
INSERT INTO `time_cards` VALUES (4,'GM00007','2021-12-01 06:36:23','2021-12-01 08:47:01',NULL,NULL,NULL,NULL,NULL,'70:F8:2B:E6:35:D9','YOU CONNECT MOBILE',NULL),(5,'GM00010','2021-12-01 16:21:52','2021-12-01 16:22:20',NULL,NULL,NULL,NULL,NULL,'YOU CONNECT MOBILE','YOU CONNECT MOBILE',NULL),(6,'GM00010','2021-12-02 20:51:51','2021-12-02 21:24:01',NULL,NULL,NULL,NULL,NULL,'70:F8:2B:E6:35:D9','70:F8:2B:E6:35:D9',NULL),(7,'GM00010','2021-12-03 07:56:50',NULL,NULL,NULL,NULL,NULL,NULL,'70:F8:2B:E6:35:D9',NULL,NULL),(8,'GM00010','2021-12-05 09:44:44','2021-12-05 09:53:04',NULL,NULL,NULL,NULL,NULL,'70:F8:2B:E6:35:D9','YOU CONNECT MOBILE',NULL),(9,'GM00010','2021-12-09 08:01:11',NULL,NULL,NULL,NULL,NULL,NULL,'70:F8:2B:E6:35:D9',NULL,NULL),(10,'GM00007','2021-12-09 08:40:49',NULL,NULL,NULL,NULL,NULL,NULL,'70:F8:2B:E6:35:D5',NULL,NULL),(11,'GM00007','2021-12-10 08:03:30',NULL,NULL,NULL,NULL,NULL,NULL,'60:A4:B7:7C:78:43',NULL,NULL),(12,'GM00006','2021-12-10 12:04:15',NULL,NULL,NULL,NULL,NULL,NULL,'60:A4:B7:7C:78:44',NULL,NULL);
/*!40000 ALTER TABLE `time_cards` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `username` varchar(20) NOT NULL,
  `employee_id` varchar(10) NOT NULL,
  `password` varchar(100) DEFAULT NULL,
  `password_salt` varchar(50) DEFAULT NULL,
  `mac_address` varchar(255) DEFAULT NULL,
  `user_status` varchar(20) DEFAULT NULL,
  UNIQUE KEY `mac_address` (`mac_address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES ('Anuwat','GM00004','a0lpcmZsMDEyc1dUTFFRU283ak5CNXBrS054UXB1cWZ2Z3dLcEFuSXN3T2EwUjZkZ2NneFFpR2lDSEhjTTJvYw==','f95722465332e4c30f13664c6a724e96',NULL,NULL),('Chayin','GM00002',NULL,NULL,NULL,NULL),('Jeeranan','OP00001',NULL,NULL,NULL,'user'),('Kosol','OP00004','SHVXQ2NEUWlaNUpHd2ErckVNdmtxRGtDZ1lIKzF6aVpCSXRtdDVUSWVEbm00R3hXRGczS2puR3I2NUIyTDl3WA==','ea6b8b2d35577a8af32af3b07e2fa967',NULL,'user'),('Ladda','GM00007',NULL,NULL,'f84e5cf7-d402-4b9f-8eb1-a006343bbf3c','user'),('Natthayada','GM00005',NULL,NULL,NULL,NULL),('Netnaphit','GM00003',NULL,NULL,NULL,'admin'),('Poolsak','GM00009',NULL,NULL,NULL,'admin'),('Prakaydao','OP00003',NULL,NULL,NULL,'user'),('Pratheep','OP00005',NULL,NULL,NULL,'user'),('Putcharin','GM00010',NULL,NULL,'352161092241425','user'),('Suraphan','GM00001','VkV3NEM3azFiYU5LYkN3dklCU3ZNRHFtTGpZZUxPaEc2L0ZYZS80cXJwcHF0ZkRSalJFQ0ViOUVrMEIyMlA2bw==','b7abb23491b4508055961e2016d333f4',NULL,'admin'),('Suriya','OP00006',NULL,NULL,NULL,'user'),('Thongbai','OP00002',NULL,NULL,NULL,'user'),('Wilawan','GM00006',NULL,NULL,'42968052-f1da-4d1b-b768-b529d976809a','user'),('Yaowaluk','GM00008',NULL,NULL,NULL,'admin');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wifibssid`
--

DROP TABLE IF EXISTS `wifibssid`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wifibssid` (
  `company_id` varchar(13) NOT NULL DEFAULT '0135564016067',
  `branch_id` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '00000',
  `wifi_bssid` varchar(20) NOT NULL,
  PRIMARY KEY (`company_id`,`branch_id`,`wifi_bssid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wifibssid`
--

LOCK TABLES `wifibssid` WRITE;
/*!40000 ALTER TABLE `wifibssid` DISABLE KEYS */;
INSERT INTO `wifibssid` VALUES ('0135564016067','00000','20:AB:48:CA:80:1C'),('0135564016067','00000','20:AB:48:CA:80:20'),('0135564016067','00000','60:A4:B7:7C:78:43'),('0135564016067','00000','60:A4:B7:7C:78:44'),('0135564016067','00000','70:F8:2B:E6:35:D5'),('0135564016067','00000','70:F8:2B:E6:35:D9'),('0135564016067','00000','E8:48:B8:74:68:E1'),('0135564016067','00000','E8:48:B8:74:68:E2');
/*!40000 ALTER TABLE `wifibssid` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `work_times`
--

DROP TABLE IF EXISTS `work_times`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `work_times` (
  `company_id` varchar(13) NOT NULL,
  `branch_id` varchar(5) NOT NULL,
  `start_time` time NOT NULL DEFAULT '08:00:00',
  `end_time` time NOT NULL DEFAULT '17:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `work_times`
--

LOCK TABLES `work_times` WRITE;
/*!40000 ALTER TABLE `work_times` DISABLE KEYS */;
INSERT INTO `work_times` VALUES ('','00000','08:00:00','17:00:00');
/*!40000 ALTER TABLE `work_times` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Current Database: `pertamac_mcm`
--

USE `pertamac_mcm`;

--
-- Final view structure for view `company_view`
--

/*!50001 DROP VIEW IF EXISTS `company_view`*/;
/*!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_unicode_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`pertamac`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `company_view` AS select `cp`.`id` AS `id`,`br`.`branch_id` AS `branch_id`,`br`.`branch_local` AS `branch_local`,`cp`.`name_local` AS `name_local`,`br`.`address1_local` AS `address1_local`,`br`.`address2_local` AS `address2_local`,`br`.`address3_local` AS `address3_local`,`br`.`branch_eng` AS `branch_eng`,`cp`.`name_eng` AS `name_eng`,`br`.`address1_eng` AS `address1_eng`,`br`.`address2_eng` AS `address2_eng`,`br`.`address3_eng` AS `address3_eng` from (`companies` `cp` left join `branches` `br` on(`cp`.`id` = `br`.`company_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 `employee_view`
--

/*!50001 DROP VIEW IF EXISTS `employee_view`*/;
/*!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_unicode_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`pertamac`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `employee_view` AS select `br`.`company_id` AS `company_id`,`em`.`id_card` AS `id_card`,`cm`.`name_local` AS `name_local`,`cm`.`name_eng` AS `name_eng`,`em`.`employee_id` AS `employee_id`,concat(`em`.`title`,`em`.`first_name`) AS `first_name`,`em`.`last_name` AS `last_name`,`ur`.`username` AS `username`,`ur`.`password` AS `password`,`ur`.`password_salt` AS `password_salt`,`ur`.`user_status` AS `user_status`,`em`.`url_image` AS `url_image`,`em`.`branch_id` AS `branch_id`,`br`.`branch_local` AS `branch_local`,`br`.`wifi_bssid1` AS `wifi_bssid1`,`br`.`wifi_bssid2` AS `wifi_bssid2`,`ur`.`mac_address` AS `mac_address`,case when `em`.`resign_date` is null then 'active' else 'No Active' end AS `status` from (((`employees` `em` left join `users` `ur` on(`em`.`employee_id` = `ur`.`employee_id`)) left join `branches` `br` on(`em`.`company_id` = `br`.`company_id` and `em`.`branch_id` = `br`.`branch_id`)) left join `companies` `cm` on(`br`.`company_id` = `cm`.`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 `time_card_report`
--

/*!50001 DROP VIEW IF EXISTS `time_card_report`*/;
/*!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_unicode_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`pertamac`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `time_card_report` AS select `tc`.`id` AS `id`,`tc`.`employee_id` AS `employee_id`,cast(`tc`.`start_time` as date) AS `Date`,time_format(`wt`.`start_time`,'%H:%i') AS `StartTime`,time_format(cast(`tc`.`start_time` as time),'%H:%i') AS `CheckIn`,time_format(timediff(`wt`.`start_time`,cast(`tc`.`start_time` as time)),'%H:%i') AS `StartDif`,time_format(`wt`.`end_time`,'%H:%i') AS `EndTime`,time_format(cast(`tc`.`end_time` as time),'%H:%i') AS `CheckOut`,time_format(timediff(cast(`tc`.`end_time` as time),`wt`.`end_time`),'%H:%i') AS `EndDif`,`tc`.`ot_x1` AS `Ot_x1`,`tc`.`ot_x1_5` AS `Ot_x1_5`,`tc`.`ot_x2` AS `Ot_x2`,`tc`.`ot_x3` AS `Ot_x3`,`tc`.`ot_approver` AS `ot_approver`,concat(`em`.`first_name`,' ',`em`.`last_name`) AS `approv_name`,`tc`.`wifi_bssid_in` AS `wifi_bssid_in`,`tc`.`wifi_bssid_out` AS `wifi_bssid_out` from ((`time_cards` `tc` left join `employees` `em` on(`tc`.`employee_id` = `em`.`employee_id`)) left join `work_times` `wt` on(`em`.`branch_id` = `wt`.`branch_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 `time_card_view`
--

/*!50001 DROP VIEW IF EXISTS `time_card_view`*/;
/*!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_unicode_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`pertamac`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `time_card_view` AS select cast(`tc`.`start_time` as date) AS `date`,`tc`.`id` AS `id`,`tc`.`employee_id` AS `employee_id`,`tc`.`start_time` AS `start_time`,`tc`.`end_time` AS `end_time`,`tc`.`ot_x1` AS `ot_x1`,`tc`.`ot_x1_5` AS `ot_x1_5`,`tc`.`ot_x2` AS `ot_x2`,`tc`.`ot_x3` AS `ot_x3`,`tc`.`ot_approver` AS `ot_approver`,concat(`em`.`first_name`,' ',`em`.`last_name`) AS `approv_name`,`tc`.`wifi_bssid_in` AS `wifi_bssid_in`,`tc`.`wifi_bssid_out` AS `wifi_bssid_out`,`tc`.`note` AS `note` from (`time_cards` `tc` left join `employees` `em` on(`tc`.`ot_approver` = `em`.`employee_id`)) */;
/*!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-10-31 13:23:18

📁 Sid Gifari File Manager