Da

✏️ Editing: fpcdhla1_ck.sql

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

/*!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: `fpcdhla1_ck`
--

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

USE `fpcdhla1_ck`;

--
-- Table structure for table `ck_datack`
--

DROP TABLE IF EXISTS `ck_datack`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ck_datack` (
  `id_ck` int(11) NOT NULL AUTO_INCREMENT,
  `id_userck` text DEFAULT NULL,
  `nameck` text DEFAULT NULL,
  `dateck` text DEFAULT NULL,
  `time_in` text DEFAULT NULL,
  `time_out` text DEFAULT NULL,
  `LAT` text DEFAULT NULL,
  `LNG` text DEFAULT NULL,
  `lineid` text DEFAULT NULL,
  `statusck` text DEFAULT NULL,
  PRIMARY KEY (`id_ck`)
) ENGINE=InnoDB AUTO_INCREMENT=447 DEFAULT CHARSET=tis620 COLLATE=tis620_thai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ck_datack`
--

LOCK TABLES `ck_datack` WRITE;
/*!40000 ALTER TABLE `ck_datack` DISABLE KEYS */;
INSERT INTO `ck_datack` VALUES (163,NULL,'outlocation','2023-03-01','22:58:36',NULL,'17.651915527727088','100.12402796827398','Ue9f567d73ab5cdc833ff049f3667ccd7','checkin'),(164,NULL,'outlocation','2023-03-01',NULL,'23:01:00','17.65193043301301','100.12396722777179','Ue9f567d73ab5cdc833ff049f3667ccd7','checkout'),(165,NULL,'outlocation','2023-03-01',NULL,'23:03:23','16.8655225','100.2824483','Uc4fd4d7504e106ff2b46773081c8b518','checkout'),(166,NULL,'outlocation','2023-03-01',NULL,'23:03:30','16.8655225','100.2824483','Uc4fd4d7504e106ff2b46773081c8b518','checkout'),(167,NULL,'outlocation','2023-03-01','23:09:01',NULL,'17.65190250857514','100.12391769556659','Ue9f567d73ab5cdc833ff049f3667ccd7','checkin'),(168,NULL,'inlocation','2023-03-02','06:01:03',NULL,'17.663808785161216','100.13940646675898','Ua658551cb7a9656b833aed2767139657','checkin'),(169,NULL,'inlocation','2023-03-02','06:28:54',NULL,'17.663719318823574','100.13918132530537','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(170,NULL,'inlocation','2023-03-02','06:34:46',NULL,'17.6637498','100.1391605','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(171,NULL,'inlocation','2023-03-02','07:53:48',NULL,'17.66381474939626','100.13932662458012','Ue9f567d73ab5cdc833ff049f3667ccd7','checkin'),(172,NULL,'inlocation','2023-03-02',NULL,'08:41:14','17.66361759616096','100.1395026472867','U0dbb63c77c9afc6863ba0be94cf20b6b','checkout'),(173,NULL,'inlocation','2023-03-02','08:41:28',NULL,'17.66360844333338','100.139537636016','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(174,NULL,'inlocation','2023-03-02','09:40:02',NULL,'17.66374525340494','100.13970471179321','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(175,NULL,'inlocation','2023-03-02','10:20:29',NULL,'17.663833247169336','100.13950354828609','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(176,NULL,'inlocation','2023-03-02',NULL,'16:38:16','17.663692371004878','100.13965926142421','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkout'),(177,NULL,'inlocation','2023-03-02',NULL,'16:38:21','17.663677409305972','100.13971768328932','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(178,NULL,'inlocation','2023-03-02',NULL,'16:38:39','17.663658166921742','100.13968200507976','Ua658551cb7a9656b833aed2767139657','checkout'),(179,NULL,'outlocation','2023-03-02',NULL,'19:15:18','17.662439889368525','100.13686498597778','Ue9f567d73ab5cdc833ff049f3667ccd7','checkout'),(180,NULL,'outlocation','2023-03-02','21:11:46',NULL,'17.622890439832233','100.08939298810445','Uc4fd4d7504e106ff2b46773081c8b518','checkin'),(181,NULL,'outlocation','2023-03-02',NULL,'21:12:09','17.622887127845576','100.08938116941367','Uc4fd4d7504e106ff2b46773081c8b518','checkout'),(182,NULL,'outlocation','2023-03-02',NULL,'22:18:13','17.651904872415738','100.12393957199167','Ue9f567d73ab5cdc833ff049f3667ccd7','checkout'),(183,NULL,'inlocation','2023-03-03','06:05:45',NULL,'17.663628542812226','100.13945264751104','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(184,NULL,'outlocation','2023-03-03','06:28:50',NULL,'17.665261253729273','100.14343011202304','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(185,NULL,'outlocation','2023-03-03','06:29:03',NULL,'17.665261253729273','100.14343011202304','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(186,NULL,'inlocation','2023-03-03','06:29:45',NULL,'17.663546890359875','100.1403325604367','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(187,NULL,'inlocation','2023-03-03','06:33:02',NULL,'17.663737419456904','100.1392737531569','Ua658551cb7a9656b833aed2767139657','checkin'),(188,NULL,'inlocation','2023-03-03','07:46:40',NULL,'17.663417931758463','100.13930734246351','Ue9f567d73ab5cdc833ff049f3667ccd7','checkin'),(189,NULL,'outlocation','2023-03-03','08:27:28',NULL,'17.666460890800398','100.14347443064598','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(190,NULL,'inlocation','2023-03-03','08:27:36',NULL,'17.66361774433346','100.13938495915461','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(191,NULL,'inlocation','2023-03-03',NULL,'08:34:10','17.663537224133247','100.13964273881083','Ue9f567d73ab5cdc833ff049f3667ccd7','checkout'),(192,NULL,'inlocation','2023-03-03',NULL,'08:40:48','17.663786837778318','100.13922310053003','U5dd3c16bc94c61b0a0f923118055ad41','checkout'),(193,NULL,'inlocation','2023-03-03','08:40:56',NULL,'17.663778704605804','100.13923815460888','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(194,NULL,'inlocation','2023-03-03',NULL,'16:44:40','17.663557309770137','100.13954769155399','U0dbb63c77c9afc6863ba0be94cf20b6b','checkout'),(195,NULL,'inlocation','2023-03-03',NULL,'16:44:52','17.663611551401','100.13955444484226','U5dd3c16bc94c61b0a0f923118055ad41','checkout'),(196,NULL,'inlocation','2023-03-03',NULL,'16:48:37','17.663640574337958','100.13954956358593','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(197,NULL,'outlocation','2023-03-03',NULL,'16:56:20','17.665297551301215','100.14348885787322','Ua658551cb7a9656b833aed2767139657','checkout'),(198,NULL,'inlocation','2023-03-03',NULL,'20:17:20','17.663580050039883','100.139605356388','Ua658551cb7a9656b833aed2767139657','checkout'),(199,NULL,'outlocation','2023-03-04','06:31:47',NULL,'17.66309977051618','100.14046512837696','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(200,NULL,'inlocation','2023-03-04','06:32:19',NULL,'17.66318849289572','100.13949422175077','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(201,NULL,'inlocation','2023-03-04','08:29:23',NULL,'17.663754589319336','100.13926022139165','Ua658551cb7a9656b833aed2767139657','checkin'),(202,NULL,'inlocation','2023-03-04',NULL,'08:35:57','17.663515985077666','100.13951703554258','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkout'),(203,NULL,'inlocation','2023-03-04',NULL,'17:20:28','17.663616127695025','100.1395617125041','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(204,NULL,'inlocation','2023-03-05','06:28:30',NULL,'17.66394762124002','100.13907042646932','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(205,NULL,'outlocation','2023-03-05','08:27:24',NULL,'17.6653088156494','100.14351641740177','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(206,NULL,'inlocation','2023-03-05','08:27:27',NULL,'17.663620252150285','100.1399947106596','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(207,NULL,'inlocation','2023-03-05',NULL,'10:22:02','17.663571307116307','100.13943054287012','Ua658551cb7a9656b833aed2767139657','checkout'),(208,NULL,'inlocation','2023-03-05',NULL,'14:34:28','17.663584839572955','100.13952091940689','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkout'),(209,NULL,'inlocation','2023-03-06','08:15:37',NULL,'17.663329392686297','100.13923807078984','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(210,NULL,'outlocation','2023-03-06',NULL,'08:41:30','17.663022992215858','100.13963771993306','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(211,NULL,'outlocation','2023-03-06',NULL,'08:41:36','17.66302617733906','100.13963663028565','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(212,NULL,'inlocation','2023-03-06','08:42:02',NULL,'17.663599541427253','100.1393851731905','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(213,NULL,'outlocation','2023-03-06',NULL,'08:42:05','17.66302617733906','100.13963663028565','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(214,NULL,'inlocation','2023-03-06',NULL,'08:42:09','17.66323197054068','100.14015002203998','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(215,NULL,'inlocation','2023-03-06',NULL,'16:02:29','17.663324112087295','100.13934871191171','U5dd3c16bc94c61b0a0f923118055ad41','checkout'),(216,NULL,'outlocation','2023-03-07','05:54:40',NULL,'17.66406790217476','100.13891214241087','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(217,NULL,'inlocation','2023-03-07','05:54:45',NULL,'17.663402785331353','100.13954019507308','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(218,NULL,'inlocation','2023-03-07','06:30:33',NULL,'17.664279011037785','100.13938337081233','Ua658551cb7a9656b833aed2767139657','checkin'),(219,NULL,'inlocation','2023-03-07','06:30:32',NULL,'17.66484890951623','100.14069854828178','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(220,NULL,'inlocation','2023-03-07','06:38:16',NULL,'17.6638866','100.1395186','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(221,NULL,'inlocation','2023-03-07','08:29:41',NULL,'17.6637976768807','100.13932161693606','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(222,NULL,'inlocation','2023-03-07',NULL,'08:33:54','17.66357930787573','100.13949613065462','U0dbb63c77c9afc6863ba0be94cf20b6b','checkout'),(223,NULL,'inlocation','2023-03-07','08:34:03',NULL,'17.66359835099011','100.13950874036087','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(224,NULL,'inlocation','2023-03-07',NULL,'16:30:47','17.663613647517895','100.13957878524934','U0dbb63c77c9afc6863ba0be94cf20b6b','checkout'),(225,NULL,'inlocation','2023-03-07',NULL,'16:30:55','17.6635272','100.1395048','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(226,NULL,'inlocation','2023-03-07',NULL,'17:01:09','17.663572283581566','100.13947814184709','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkout'),(227,NULL,'inlocation','2023-03-07',NULL,'17:01:18','17.66354280191663','100.1395367873868','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(228,NULL,'inlocation','2023-03-07',NULL,'17:01:19','17.663220721311678','100.13925022454944','Ua658551cb7a9656b833aed2767139657','checkout'),(229,NULL,'inlocation','2023-03-08','06:02:15',NULL,'17.663905164548996','100.13919688742948','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(230,NULL,'inlocation','2023-03-08','06:31:37',NULL,'17.66365733464046','100.13924263952988','Ua658551cb7a9656b833aed2767139657','checkin'),(231,NULL,'inlocation','2023-03-08','06:42:49',NULL,'17.6637449','100.1391205','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(232,NULL,'inlocation','2023-03-08','06:52:48',NULL,'17.66325378139447','100.1393458320439','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(233,NULL,'outlocation','2023-03-08','08:28:49',NULL,'17.66688247500551','100.14334430114641','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(234,NULL,'inlocation','2023-03-08','08:28:55',NULL,'17.663541019521915','100.13940218476961','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(235,NULL,'inlocation','2023-03-08',NULL,'16:35:21','17.663429485528688','100.1394567408174','U0dbb63c77c9afc6863ba0be94cf20b6b','checkout'),(236,NULL,'inlocation','2023-03-08',NULL,'16:48:55','17.6637396','100.1389985','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(237,NULL,'inlocation','2023-03-08',NULL,'16:49:13','17.663803419696567','100.13953504461205','U5dd3c16bc94c61b0a0f923118055ad41','checkout'),(238,NULL,'inlocation','2023-03-08',NULL,'17:45:31','17.663597976771484','100.1395026381357','Ua658551cb7a9656b833aed2767139657','checkout'),(239,NULL,'inlocation','2023-03-08',NULL,'19:13:53','17.66358916729851','100.13949871056911','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(240,NULL,'inlocation','2023-03-09','05:54:35',NULL,'17.66350679566866','100.13927528643993','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(241,NULL,'inlocation','2023-03-09','06:37:23',NULL,'17.663664414661874','100.13921600735272','Ua658551cb7a9656b833aed2767139657','checkin'),(242,NULL,'inlocation','2023-03-09','06:53:47',NULL,'17.66336093975914','100.13949619918174','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(243,NULL,'outlocation','2023-03-09','08:24:47',NULL,'17.65793588463359','100.13377461461876','Ue9f567d73ab5cdc833ff049f3667ccd7','checkin'),(244,NULL,'inlocation','2023-03-09','08:25:35',NULL,'17.66350058606622','100.13928937319217','Ue9f567d73ab5cdc833ff049f3667ccd7','checkin'),(245,NULL,'outlocation','2023-03-09','08:32:22',NULL,'17.66532373003922','100.14177509470277','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(246,NULL,'inlocation','2023-03-09','08:32:50',NULL,'17.664061985384972','100.13963455253163','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(247,NULL,'inlocation','2023-03-09',NULL,'08:45:42','17.663599803443155','100.13953969540201','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkout'),(248,NULL,'inlocation','2023-03-09','08:45:52',NULL,'17.66358205571349','100.13954812514453','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(249,NULL,'outlocation','2023-03-09','09:09:16',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(250,NULL,'outlocation','2023-03-09',NULL,'16:31:25','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(251,NULL,'inlocation','2023-03-09',NULL,'16:33:29','17.66350674152083','100.13950992669568','U5dd3c16bc94c61b0a0f923118055ad41','checkout'),(252,NULL,'inlocation','2023-03-09',NULL,'19:20:30','17.663603420689885','100.1394971432305','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkout'),(253,NULL,'inlocation','2023-03-10','05:59:57',NULL,'17.663611982495446','100.13940206772683','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(254,NULL,'outlocation','2023-03-10','06:31:08',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(255,NULL,'inlocation','2023-03-10','06:31:09',NULL,'17.66394860639391','100.13902444877587','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(256,NULL,'inlocation','2023-03-10',NULL,'06:33:01','17.663647186519466','100.13949047464114','Ua658551cb7a9656b833aed2767139657','checkout'),(257,NULL,'inlocation','2023-03-10','06:33:05',NULL,'17.663746127513832','100.13941582627778','Ua658551cb7a9656b833aed2767139657','checkin'),(258,NULL,'inlocation','2023-03-10','08:15:42',NULL,'17.66357505208407','100.13938711105646','Ue9f567d73ab5cdc833ff049f3667ccd7','checkin'),(259,NULL,'outlocation','2023-03-10','08:28:39',NULL,'17.66304026904668','100.13959081611607','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(260,NULL,'inlocation','2023-03-10','08:28:45',NULL,'17.663590091417852','100.13953609759429','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(261,NULL,'inlocation','2023-03-10',NULL,'16:32:31','17.663630363642778','100.13949615402001','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkout'),(262,NULL,'inlocation','2023-03-10',NULL,'16:32:33','17.66361493013111','100.13953567006054','U5dd3c16bc94c61b0a0f923118055ad41','checkout'),(263,NULL,'inlocation','2023-03-10',NULL,'16:32:37','17.6636022718631','100.13952333791504','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(264,NULL,'inlocation','2023-03-10','16:32:44',NULL,'17.663607241758093','100.13950487023571','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(265,NULL,'inlocation','2023-03-10',NULL,'16:32:49','17.663632598262517','100.13949902659108','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(266,NULL,'outlocation','2023-03-10',NULL,'16:38:10','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(267,NULL,'outlocation','2023-03-11','06:37:06',NULL,'17.664104328446694','100.13894459941176','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(268,NULL,'inlocation','2023-03-11','06:38:09',NULL,'17.663554469156193','100.13951830439599','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(269,NULL,'outlocation','2023-03-11','08:29:50',NULL,'17.66615459758485','100.14279763915947','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(270,NULL,'inlocation','2023-03-11','08:29:54',NULL,'17.663730551129472','100.139409595572','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(271,NULL,'inlocation','2023-03-11',NULL,'14:35:46','17.66332883831834','100.13923548152141','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkout'),(272,NULL,'inlocation','2023-03-12','08:19:24',NULL,'17.663569792717116','100.1395373562662','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(273,NULL,'inlocation','2023-03-12','08:29:44',NULL,'17.663629020447544','100.13927446571188','Ua658551cb7a9656b833aed2767139657','checkin'),(274,NULL,'inlocation','2023-03-12',NULL,'16:14:54','17.663826634500243','100.13965611077018','U0dbb63c77c9afc6863ba0be94cf20b6b','checkout'),(275,NULL,'outlocation','2023-03-13','05:59:02',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(276,NULL,'inlocation','2023-03-13','06:33:36',NULL,'17.663697993243606','100.13917275197672','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(277,NULL,'outlocation','2023-03-13','06:34:05',NULL,'17.665334027064425','100.14179899426311','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(278,NULL,'inlocation','2023-03-13','06:34:14',NULL,'17.66376476418836','100.13941525600937','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(279,NULL,'inlocation','2023-03-13','06:49:00',NULL,'17.663290867506518','100.13929493640944','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(280,NULL,'inlocation','2023-03-13','08:28:44',NULL,'17.66374140513843','100.13919146740821','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(281,NULL,'inlocation','2023-03-13',NULL,'16:36:58','17.66362733240386','100.13949726244037','U0dbb63c77c9afc6863ba0be94cf20b6b','checkout'),(282,NULL,'inlocation','2023-03-13',NULL,'16:37:02','17.663633823411224','100.13978431941953','U5dd3c16bc94c61b0a0f923118055ad41','checkout'),(283,NULL,'inlocation','2023-03-13',NULL,'16:37:23','17.6636924','100.1390397','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(284,NULL,'inlocation','2023-03-13',NULL,'18:24:30','17.663603145645617','100.13975414456812','Ua658551cb7a9656b833aed2767139657','checkout'),(285,NULL,'inlocation','2023-03-14','06:04:32',NULL,'17.66360754614478','100.13919767001656','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(286,NULL,'inlocation','2023-03-14','06:30:49',NULL,'17.663829097918327','100.13908558478757','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(287,NULL,'inlocation','2023-03-14','06:32:21',NULL,'17.6636821','100.1391742','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(288,NULL,'inlocation','2023-03-14','06:38:04',NULL,'17.663955227488337','100.13933194810537','Ua658551cb7a9656b833aed2767139657','checkin'),(289,NULL,'inlocation','2023-03-14','08:13:25',NULL,'17.663515650288033','100.13938872131216','Ue9f567d73ab5cdc833ff049f3667ccd7','checkin'),(290,NULL,'inlocation','2023-03-14',NULL,'08:31:01','17.663855185308066','100.13909477209424','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(291,NULL,'inlocation','2023-03-14','08:31:07',NULL,'17.66376324436761','100.13914761464409','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(292,NULL,'inlocation','2023-03-14',NULL,'16:39:40','17.66353946781442','100.13954797960804','U0dbb63c77c9afc6863ba0be94cf20b6b','checkout'),(293,NULL,'inlocation','2023-03-15','05:54:35',NULL,'17.66349564773744','100.13930252762523','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(294,NULL,'inlocation','2023-03-15',NULL,'06:31:24','17.663641534762142','100.13939145961788','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkout'),(295,NULL,'inlocation','2023-03-15','06:31:31',NULL,'17.663536928608824','100.13933027172473','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(296,NULL,'inlocation','2023-03-15','06:36:40',NULL,'17.6637631','100.1392227','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(297,NULL,'inlocation','2023-03-15','06:47:08',NULL,'17.663427602955913','100.13965320222793','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(298,NULL,'inlocation','2023-03-15','11:27:15',NULL,'17.663585719558114','100.13954516423617','Ua658551cb7a9656b833aed2767139657','checkin'),(299,NULL,'inlocation','2023-03-15',NULL,'11:27:39','17.6636522580377','100.13953503261715','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(300,NULL,'inlocation','2023-03-15','11:27:45',NULL,'17.663611600061035','100.1395344693717','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(301,NULL,'outlocation','2023-03-15',NULL,'16:33:15','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(302,NULL,'inlocation','2023-03-15',NULL,'16:33:34','17.66352358015118','100.13967545861256','U5dd3c16bc94c61b0a0f923118055ad41','checkout'),(303,NULL,'outlocation','2023-03-15',NULL,'16:57:00','17.663116992628378','100.13955462809872','U0dbb63c77c9afc6863ba0be94cf20b6b','checkout'),(304,NULL,'outlocation','2023-03-15',NULL,'16:57:08','17.66307423543052','100.13955198245198','U0dbb63c77c9afc6863ba0be94cf20b6b','checkout'),(305,NULL,'outlocation','2023-03-15',NULL,'16:57:22','17.66307423543052','100.13955198245198','U0dbb63c77c9afc6863ba0be94cf20b6b','checkout'),(306,NULL,'inlocation','2023-03-16',NULL,'06:03:34','17.664593756154403','100.1400728988804','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(307,NULL,'inlocation','2023-03-16','06:03:41',NULL,'17.66374068916758','100.1394695477812','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(308,NULL,'inlocation','2023-03-16','06:30:13',NULL,'17.663814202370475','100.13921710905315','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(309,NULL,'inlocation','2023-03-16',NULL,'06:35:40','17.663434354638078','100.13933036057638','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkout'),(310,NULL,'inlocation','2023-03-16','06:35:46',NULL,'17.663589537162963','100.13942635456253','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(311,NULL,'outlocation','2023-03-16','06:36:17',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(312,NULL,'inlocation','2023-03-16','06:36:24',NULL,'17.6637627','100.1391188','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(313,NULL,'inlocation','2023-03-16','06:36:24',NULL,'17.6637627','100.1391188','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(314,NULL,'outlocation','2023-03-16','08:34:25',NULL,'17.662660097719787','100.13971282178548','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(315,NULL,'outlocation','2023-03-16','08:35:27',NULL,'17.66275739194522','100.13968177306056','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(316,NULL,'outlocation','2023-03-16','08:35:33',NULL,'17.66275739194522','100.13968177306056','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(317,NULL,'outlocation','2023-03-16','08:35:44',NULL,'17.66275739194522','100.13968177306056','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(318,NULL,'outlocation','2023-03-16','08:36:01',NULL,'17.66275739194522','100.13968177306056','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(319,NULL,'outlocation','2023-03-16','08:36:14',NULL,'17.66275739194522','100.13968177306056','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(320,NULL,'outlocation','2023-03-16','08:37:18',NULL,'17.66275739194522','100.13968177306056','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(321,NULL,'inlocation','2023-03-16',NULL,'08:37:22','17.66357359747041','100.13953392136582','Ua658551cb7a9656b833aed2767139657','checkout'),(322,NULL,'inlocation','2023-03-16','08:37:28',NULL,'17.663567209059664','100.13952348827776','Ua658551cb7a9656b833aed2767139657','checkin'),(323,NULL,'outlocation','2023-03-16','08:37:36',NULL,'17.66275739194522','100.13968177306056','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(324,NULL,'outlocation','2023-03-16','08:38:04',NULL,'17.66275739194522','100.13968177306056','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(325,NULL,'inlocation','2023-03-16','08:47:30',NULL,'17.663536873070374','100.1396003426686','Ue9f567d73ab5cdc833ff049f3667ccd7','checkin'),(326,NULL,'inlocation','2023-03-16','08:48:36',NULL,'17.663803210771825','100.1390694146381','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(327,NULL,'inlocation','2023-03-16','08:49:30',NULL,'17.663803210771825','100.1390694146381','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(328,NULL,'inlocation','2023-03-16',NULL,'16:38:18','17.663580724644063','100.1395164657544','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkout'),(329,NULL,'outlocation','2023-03-16',NULL,'16:40:33','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(330,NULL,'inlocation','2023-03-16',NULL,'16:41:31','17.66351739877617','100.13976076627162','U5dd3c16bc94c61b0a0f923118055ad41','checkout'),(331,NULL,'inlocation','2023-03-16',NULL,'16:41:44','17.66329594889438','100.1391467918643','Ua658551cb7a9656b833aed2767139657','checkout'),(332,NULL,'inlocation','2023-03-17','06:04:05',NULL,'17.663304498435615','100.13928735638049','Ua658551cb7a9656b833aed2767139657','checkin'),(333,NULL,'outlocation','2023-03-17','06:30:35',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(334,NULL,'inlocation','2023-03-17','06:30:42',NULL,'17.6636626','100.1390643','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(335,NULL,'inlocation','2023-03-17','06:38:13',NULL,'17.66357347370665','100.13937427671638','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(336,NULL,'inlocation','2023-03-17','08:34:37',NULL,'17.663809627095564','100.13926611702057','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(337,NULL,'outlocation','2023-03-17',NULL,'16:33:27','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(338,NULL,'outlocation','2023-03-17',NULL,'16:33:38','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(339,NULL,'outlocation','2023-03-17',NULL,'16:33:49','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(340,NULL,'inlocation','2023-03-17',NULL,'16:34:43','17.663590168997438','100.13951300813363','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkout'),(341,NULL,'inlocation','2023-03-18',NULL,'06:35:15','17.663818602375933','100.13905323167802','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(342,NULL,'inlocation','2023-03-18','06:35:24',NULL,'17.663703719141292','100.13946248841502','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(343,NULL,'inlocation','2023-03-18','08:35:06',NULL,'17.663298714920685','100.13917378159252','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(344,NULL,'inlocation','2023-03-18',NULL,'08:44:37','17.6640701569732','100.13979198091403','U5dd3c16bc94c61b0a0f923118055ad41','checkout'),(345,NULL,'inlocation','2023-03-18',NULL,'14:54:22','17.66355173429326','100.13953420631704','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(346,NULL,'inlocation','2023-03-19','08:37:05',NULL,'17.663860714261627','100.13952812103567','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(347,NULL,'inlocation','2023-03-19',NULL,'08:38:22','17.663582679417434','100.1395272266947','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkout'),(348,NULL,'inlocation','2023-03-20','05:58:53',NULL,'17.663420420156477','100.13921426618484','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(349,NULL,'inlocation','2023-03-20','06:25:44',NULL,'17.6637066','100.1391135','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(350,NULL,'inlocation','2023-03-20','06:30:28',NULL,'17.663652023564644','100.13939317847799','Ua658551cb7a9656b833aed2767139657','checkin'),(351,NULL,'inlocation','2023-03-20','06:31:43',NULL,'17.66380158353758','100.13921114896242','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(352,NULL,'outlocation','2023-03-20','08:32:12',NULL,'17.66279764475083','100.13981868522254','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(353,NULL,'inlocation','2023-03-20','08:33:01',NULL,'17.66359566541839','100.13946403207618','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(354,NULL,'inlocation','2023-03-20',NULL,'09:22:09','17.663568755789907','100.13955320394686','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(355,NULL,'inlocation','2023-03-20','09:22:16',NULL,'17.663591938331734','100.13957412253441','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(356,NULL,'inlocation','2023-03-20',NULL,'16:30:24','17.66378422907391','100.13964463942659','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkout'),(357,NULL,'outlocation','2023-03-20',NULL,'16:30:41','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(358,NULL,'outlocation','2023-03-20',NULL,'16:30:58','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(359,NULL,'inlocation','2023-03-20',NULL,'16:31:05','17.66353955344142','100.13952061816013','U5dd3c16bc94c61b0a0f923118055ad41','checkout'),(360,NULL,'outlocation','2023-03-20',NULL,'16:31:10','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(361,NULL,'outlocation','2023-03-20',NULL,'16:31:31','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(362,NULL,'inlocation','2023-03-20',NULL,'16:36:03','17.663424108193873','100.13963981540886','Ua658551cb7a9656b833aed2767139657','checkout'),(363,NULL,'inlocation','2023-03-20',NULL,'16:36:20','17.663590019498717','100.1395728556126','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(364,NULL,'inlocation','2023-03-21','05:59:57',NULL,'17.663935292332447','100.13901626205146','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(365,NULL,'outlocation','2023-03-21','06:28:12',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(366,NULL,'outlocation','2023-03-21','06:28:22',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(367,NULL,'inlocation','2023-03-21','06:31:10',NULL,'17.66342796386933','100.13926589870837','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(368,NULL,'inlocation','2023-03-21','06:34:41',NULL,'17.663845798344116','100.13961628788266','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(369,NULL,'inlocation','2023-03-21','08:02:13',NULL,'17.6635245','100.1395397','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(370,NULL,'inlocation','2023-03-21','08:27:40',NULL,'17.66365318560755','100.13921435000387','Ua658551cb7a9656b833aed2767139657','checkin'),(371,NULL,'outlocation','2023-03-21',NULL,'16:30:08','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(372,NULL,'inlocation','2023-03-21',NULL,'16:31:03','17.663530816362048','100.13953591045134','U5dd3c16bc94c61b0a0f923118055ad41','checkout'),(373,NULL,'outlocation','2023-03-21',NULL,'16:32:08','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(374,NULL,'outlocation','2023-03-21',NULL,'16:32:50','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(375,NULL,'outlocation','2023-03-21',NULL,'16:32:58','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(376,NULL,'outlocation','2023-03-21',NULL,'16:33:42','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(377,NULL,'inlocation','2023-03-21',NULL,'16:34:20','17.663577681567187','100.13953790625624','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkout'),(378,NULL,'outlocation','2023-03-21',NULL,'16:37:35','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(379,NULL,'outlocation','2023-03-22','05:54:54',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(380,NULL,'outlocation','2023-03-22','05:55:10',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(381,NULL,'outlocation','2023-03-22','05:56:55',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(382,NULL,'outlocation','2023-03-22','05:57:04',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(383,NULL,'outlocation','2023-03-22','05:57:39',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(384,NULL,'outlocation','2023-03-22','06:30:41',NULL,'17.665416875251008','100.14200706054088','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(385,NULL,'inlocation','2023-03-22','06:30:55',NULL,'17.663719053833397','100.1394719189784','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(386,NULL,'outlocation','2023-03-22','06:36:28',NULL,'17.665228773854484','100.14345131823806','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(387,NULL,'inlocation','2023-03-22','06:36:32',NULL,'17.663606354735904','100.13917472226836','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(388,NULL,'inlocation','2023-03-22','06:49:33',NULL,'17.663365686328767','100.13938416736212','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(389,NULL,'inlocation','2023-03-22','08:25:19',NULL,'17.663366398790536','100.13932423675445','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkin'),(390,NULL,'outlocation','2023-03-22','09:32:22',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(391,NULL,'outlocation','2023-03-22',NULL,'16:29:13','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(392,NULL,'outlocation','2023-03-22',NULL,'16:30:07','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(393,NULL,'inlocation','2023-03-22',NULL,'16:30:22','17.663495337263384','100.13971236898908','U5dd3c16bc94c61b0a0f923118055ad41','checkout'),(394,NULL,'outlocation','2023-03-22',NULL,'16:30:37','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(395,NULL,'inlocation','2023-03-23','06:00:37',NULL,'17.663663098833805','100.13927589931839','Ua658551cb7a9656b833aed2767139657','checkin'),(396,NULL,'outlocation','2023-03-23','06:28:33',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(397,NULL,'outlocation','2023-03-23','06:28:44',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(398,NULL,'outlocation','2023-03-23','06:28:55',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(399,NULL,'outlocation','2023-03-23',NULL,'06:34:40','17.665270683370345','100.14348434293656','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(400,NULL,'outlocation','2023-03-23',NULL,'06:34:59','17.665270683370345','100.14348434293656','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(401,NULL,'inlocation','2023-03-23',NULL,'06:35:02','17.663817603947606','100.13946443338146','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(402,NULL,'inlocation','2023-03-23','06:35:07',NULL,'17.66373482105873','100.13938300423645','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(403,NULL,'inlocation','2023-03-23','06:45:29',NULL,'17.663163071283957','100.13942979371615','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(404,NULL,'inlocation','2023-03-23','08:28:20',NULL,'17.66394404741466','100.13959783746155','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(405,NULL,'outlocation','2023-03-23','10:17:04',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(406,NULL,'inlocation','2023-03-23','10:17:15',NULL,'17.6635753','100.1396207','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(407,NULL,'outlocation','2023-03-23','10:17:25',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(408,NULL,'inlocation','2023-03-23','10:17:32',NULL,'17.6635654','100.1396212','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(409,NULL,'outlocation','2023-03-23','10:20:37',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(410,NULL,'inlocation','2023-03-23','10:20:56',NULL,'17.6635735','100.1395977','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(411,NULL,'outlocation','2023-03-23','10:21:05',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(412,NULL,'outlocation','2023-03-23','10:21:29',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(413,NULL,'outlocation','2023-03-23','10:21:38',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(414,NULL,'outlocation','2023-03-23','10:21:40',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(415,NULL,'outlocation','2023-03-23','10:21:45',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(416,NULL,'outlocation','2023-03-23',NULL,'10:21:54','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(417,NULL,'inlocation','2023-03-23','10:22:07',NULL,'17.6635684','100.1396396','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(418,NULL,'outlocation','2023-03-23',NULL,'10:22:13','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(419,NULL,'outlocation','2023-03-23','10:26:05',NULL,'17.65765765765766','100.14149948751664','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(420,NULL,'outlocation','2023-03-23','10:26:09',NULL,'17.65765765765766','100.14149948751664','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(421,NULL,'inlocation','2023-03-23','10:26:36',NULL,'17.663640492486135','100.1395354679887','Ue9f567d73ab5cdc833ff049f3667ccd7','checkin'),(422,NULL,'outlocation','2023-03-23','10:26:14',NULL,'17.65765765765766','100.14149948751664','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(423,NULL,'outlocation','2023-03-23','10:27:55',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(424,NULL,'outlocation','2023-03-23','10:28:44',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(425,NULL,'outlocation','2023-03-23',NULL,'10:28:51','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(426,NULL,'inlocation','2023-03-23','10:28:58',NULL,'17.6635596','100.1396284','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(427,NULL,'outlocation','2023-03-23','10:29:04',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(428,NULL,'outlocation','2023-03-23','10:29:09',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(429,NULL,'outlocation','2023-03-23','10:29:15',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(430,NULL,'outlocation','2023-03-23','10:29:21',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(431,NULL,'outlocation','2023-03-23','10:32:21',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(432,NULL,'outlocation','2023-03-23',NULL,'10:32:41','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(433,NULL,'outlocation','2023-03-23','10:34:56',NULL,'','','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(434,NULL,'outlocation','2023-03-23',NULL,'16:41:34','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(435,NULL,'inlocation','2023-03-23',NULL,'16:45:09','17.663528458469596','100.13946199768628','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','checkout'),(436,NULL,'inlocation','2023-03-24','05:57:24',NULL,'17.6637302','100.1390059','U1a65c9bc76d2599d15d855a4b82f6735','checkin'),(437,NULL,'inlocation','2023-03-24','06:37:21',NULL,'17.663163305400044','100.13942487602499','U0dbb63c77c9afc6863ba0be94cf20b6b','checkin'),(438,NULL,'inlocation','2023-03-24',NULL,'06:37:22','17.663752265077154','100.13932303323045','Ub20b74a7b0184fbbebf150e5df0efbae','checkout'),(439,NULL,'inlocation','2023-03-24','06:37:30',NULL,'17.66368972910357','100.13939075745799','Ub20b74a7b0184fbbebf150e5df0efbae','checkin'),(440,NULL,'inlocation','2023-03-24',NULL,'08:30:16','17.663548444742663','100.13954428484209','U5dd3c16bc94c61b0a0f923118055ad41','checkout'),(441,NULL,'inlocation','2023-03-24','08:30:22',NULL,'17.66355959196215','100.13953480181634','U5dd3c16bc94c61b0a0f923118055ad41','checkin'),(442,NULL,'inlocation','2023-03-24','08:30:36',NULL,'17.663719025456963','100.13924092063692','Ua658551cb7a9656b833aed2767139657','checkin'),(443,NULL,'outlocation','2023-03-24',NULL,'16:32:26','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(444,NULL,'outlocation','2023-03-24',NULL,'16:34:32','','','U1a65c9bc76d2599d15d855a4b82f6735','checkout'),(445,NULL,'inlocation','2023-03-24',NULL,'16:34:55','17.66359094470831','100.1395247480284','U5dd3c16bc94c61b0a0f923118055ad41','checkout'),(446,NULL,'outlocation','2023-03-24','21:45:29',NULL,'17.622891697115985','100.08938577966772','U167a7033856d002d3e302dc1fe1b5401','checkin');
/*!40000 ALTER TABLE `ck_datack` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ck_user`
--

DROP TABLE IF EXISTS `ck_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ck_user` (
  `id_userck` int(11) NOT NULL AUTO_INCREMENT,
  `ck_username` varchar(100) DEFAULT NULL,
  `ck_password` varchar(100) DEFAULT NULL,
  `ck_name` text DEFAULT NULL,
  `ck_pname` text DEFAULT NULL,
  `ck_fname` text DEFAULT NULL,
  `ck_lname` text DEFAULT NULL,
  `ck_cid` text DEFAULT NULL,
  `ck_birthday` date DEFAULT NULL,
  `ck_address` text DEFAULT NULL,
  `ck_tel` text DEFAULT NULL,
  `ck_sex` text DEFAULT NULL,
  `ck_section` text DEFAULT NULL,
  `ck_group` text DEFAULT NULL,
  `ck_jtype` text DEFAULT NULL,
  `ck_depclinic` text DEFAULT NULL,
  `ck_depnonclinic` text DEFAULT NULL,
  `ck_profession` text DEFAULT NULL,
  `ck_edu` text DEFAULT NULL,
  `type` varchar(110) DEFAULT NULL,
  `lineid` text DEFAULT NULL,
  `dep` text DEFAULT NULL,
  PRIMARY KEY (`id_userck`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=tis620 COLLATE=tis620_thai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ck_user`
--

LOCK TABLES `ck_user` WRITE;
/*!40000 ALTER TABLE `ck_user` DISABLE KEYS */;
INSERT INTO `ck_user` VALUES (1,'mium','3233','กฤษดา สวัสดิ์วงษ์',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0',NULL,'adminn',NULL,NULL),(3,'top','labtop','ร.ท.ธงทิว ไพเราะ','ร้อยโท','ธงทิว','ไพเราะ',NULL,NULL,NULL,NULL,'ชาย','โรงพยาบาลค่ายพิชัยดาบหัก',NULL,'0','0','0','นักเทคนิคการแพทย์','ปริญญาตรี','adminn',NULL,NULL),(27,NULL,NULL,'น.ส.ภานุมาศ ทองสี','นางสาว','ภานุมาศ','ภานุมาศ',NULL,NULL,NULL,NULL,'หญิง','โรงพยาบาลค่ายพิชัยดาบหัก','ลูกจ้างชั่วคราว','ฝ่ายสนับสนุน','0','0','นักเทคนิคการแพทย์','ปริญญาตรี','user','Ua658551cb7a9656b833aed2767139657','พยาธิวิทยา'),(30,NULL,NULL,'น.ส.นภัชติกาญจน์ แก้วคงขำ','นางสาว','นภัชติกาญจน์','แก้วคงขำ',NULL,NULL,NULL,NULL,'หญิง','โรงพยาบาลค่ายพิชัยดาบหัก','ลูกจ้างชั่วคราว','ฝ่ายสนับสนุน','0','0','นักเทคนิคการแพทย์','ปริญญาตรี','user','U1a65c9bc76d2599d15d855a4b82f6735','พยาธิวิทยา'),(31,NULL,NULL,'น.ส.ปาริฉัตร เอมเทศ','นางสาว','ปาริฉัตร','เอมเทศ',NULL,NULL,NULL,NULL,'หญิง','โรงพยาบาลค่ายพิชัยดาบหัก','ลูกจ้างชั่วคราว','ฝ่ายสนับสนุน','0','0','นักเทคนิคการแพทย์','ปริญญาตรี','user','Uaed9adf84575ff99c8e2ddbb8a0b3dc2','พยาธิวิทยา'),(32,NULL,NULL,'น.ส.สิริมา พรมงาม','นางสาว','สิริมา','พรมงาม',NULL,NULL,NULL,NULL,'หญิง','โรงพยาบาลค่ายพิชัยดาบหัก','ลูกจ้างชั่วคราว','ฝ่ายสนับสนุน','0','0','นักเทคนิคการแพทย์','ปริญญาตรี','user','U5dd3c16bc94c61b0a0f923118055ad41','พยาธิวิทยา'),(33,NULL,NULL,'ร.ต.หญิงพงศ์พัชรา ภูวเรืองพัฒน์','ร้อยตรีหญิง','พงศ์พัชรา','ภูวเรืองพัฒน์',NULL,NULL,NULL,NULL,'หญิง','โรงพยาบาลค่ายพิชัยดาบหัก',NULL,'ฝ่ายสนับสนุน','0','0','นักเทคนิคการแพทย์','ปริญญาตรี','user','U0dbb63c77c9afc6863ba0be94cf20b6b','พยาธิวิทยา'),(35,NULL,NULL,'น.ส.จิดาภา บุญมีทอง','นางสาว','จิดาภา','บุญมีทอง',NULL,NULL,NULL,NULL,'หญิง','โรงพยาบาลค่ายพิชัยดาบหัก','ลูกจ้างชั่วคราว','ฝ่ายสนับสนุน','0','0','นักเทคนิคการแพทย์',NULL,'user','Ub20b74a7b0184fbbebf150e5df0efbae','พยาธิวิทยา'),(39,NULL,NULL,NULL,'นาย','Test','Test','153898274837373','2023-03-29','123dkkfkk\r\nDjdhx\r\nJdkdkjc\r\nDxjdj','0861193847','ชาย','โรงพยาบาลค่ายพิชัยดาบหัก','ข้าราชการทหารสัญญาบัตร','ฝ่ายรักษา',NULL,NULL,'ทันตแพทย์','ต่ำกว่ามัธยมศึกษาตอนปลาย','user','U167a7033856d002d3e302dc1fe1b5401','กองบังคับการ');
/*!40000 ALTER TABLE `ck_user` 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 2025-10-26 21:36:11

📁 Sid Gifari File Manager