forked from anasalqoyyum/KPRI
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathkpri.sql
More file actions
821 lines (781 loc) · 97.9 KB
/
Copy pathkpri.sql
File metadata and controls
821 lines (781 loc) · 97.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
-- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 28, 2020 at 03:41 PM
-- Server version: 10.4.10-MariaDB
-- PHP Version: 7.3.12
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!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 */;
--
-- Database: `kpri`
--
-- --------------------------------------------------------
--
-- Table structure for table `absen_karyawan`
--
CREATE TABLE `absen_karyawan` (
`no` int(11) NOT NULL,
`nama` varchar(50) NOT NULL,
`no_staff` int(11) NOT NULL,
`departemen` varchar(50) NOT NULL,
`tanggal` date NOT NULL,
`hari` varchar(50) NOT NULL,
`tipe` varchar(50) NOT NULL,
`jadwal` varchar(50) NOT NULL,
`tgl_masuk` datetime NOT NULL,
`masuk` varchar(50) NOT NULL,
`tgl_keluar` datetime NOT NULL,
`keluar` varchar(50) NOT NULL,
`lembur_masuk` varchar(50) NOT NULL,
`lembur_keluar` varchar(50) NOT NULL,
`jam_kerja` varchar(50) NOT NULL,
`jam_lembur` varchar(50) NOT NULL,
`jam_kurang` varchar(50) NOT NULL,
`jam_terlambat` varchar(50) NOT NULL,
`jam_pulangcpt` varchar(50) NOT NULL,
`jam_absen` varchar(50) NOT NULL,
`hari_lupa_io` varchar(50) NOT NULL,
`jam_ijin` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `absen_karyawan`
--
INSERT INTO `absen_karyawan` (`no`, `nama`, `no_staff`, `departemen`, `tanggal`, `hari`, `tipe`, `jadwal`, `tgl_masuk`, `masuk`, `tgl_keluar`, `keluar`, `lembur_masuk`, `lembur_keluar`, `jam_kerja`, `jam_lembur`, `jam_kurang`, `jam_terlambat`, `jam_pulangcpt`, `jam_absen`, `hari_lupa_io`, `jam_ijin`) VALUES
(1, 'ANI P', 3, 'STAFF', '2001-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-01 08:00:00', '', '2020-05-01 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(2, 'ANI P', 3, 'STAFF', '2002-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-02 09:00:00', '', '2020-05-02 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(3, 'ANI P', 3, 'STAFF', '2003-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(4, 'ANI P', 3, 'STAFF', '2004-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-04 08:00:00', '', '2020-05-04 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(5, 'ANI P', 3, 'STAFF', '2005-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-05 08:00:00', '', '2020-05-05 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(6, 'ANI P', 3, 'STAFF', '2006-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-06 08:00:00', '8:11', '2020-05-06 16:30:00', '13:12', '', '', '5,02', '', '3,48', '0,18', '3,3', '', '', ''),
(7, 'ANI P', 3, 'STAFF', '2007-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-07 08:00:00', '', '2020-05-07 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(8, 'ANI P', 3, 'STAFF', '2008-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-08 08:00:00', '8:09', '2020-05-08 16:30:00', '13:07', '', '', '4,97', '', '3,53', '0,15', '3,38', '', '', ''),
(9, 'ANI P', 3, 'STAFF', '2009-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-09 09:00:00', '', '2020-05-09 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(10, 'ANI P', 3, 'STAFF', '2010-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(11, 'ANI P', 3, 'STAFF', '2011-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-11 08:00:00', '8:32', '2020-05-11 16:30:00', '13:20', '', '', '4,8', '', '3,7', '0,53', '3,17', '', '', ''),
(12, 'ANI P', 3, 'STAFF', '2012-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-12 08:00:00', '8:09', '2020-05-12 16:30:00', '13:10', '', '', '5,02', '', '3,48', '0,15', '3,33', '', '', ''),
(13, 'ANI P', 3, 'STAFF', '2013-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-13 08:00:00', '8:20', '2020-05-13 16:30:00', '14:33', '', '', '6,22', '', '2,28', '0,33', '1,95', '', '', ''),
(14, 'ANI P', 3, 'STAFF', '2014-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-14 08:00:00', '8:14', '2020-05-14 16:30:00', '13:16', '', '', '5,03', '', '3,47', '0,23', '3,23', '', '', ''),
(15, 'ANI P', 3, 'STAFF', '2015-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-15 08:00:00', '8:20', '2020-05-15 16:30:00', '13:10', '', '', '4,83', '', '3,67', '0,33', '3,33', '', '', ''),
(16, 'ANI P', 3, 'STAFF', '2016-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-16 09:00:00', '', '2020-05-16 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(17, 'ANI P', 3, 'STAFF', '2017-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(18, 'ANI P', 3, 'STAFF', '2018-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-18 08:00:00', '8:05', '2020-05-18 16:30:00', '13:08', '', '', '5,05', '', '3,45', '0,08', '3,37', '', '', ''),
(19, 'RUSDI', 5, 'STAFF', '2001-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-01 08:00:00', '', '2020-05-01 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(20, 'RUSDI', 5, 'STAFF', '2002-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-02 09:00:00', '', '2020-05-02 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(21, 'RUSDI', 5, 'STAFF', '2003-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(22, 'RUSDI', 5, 'STAFF', '2004-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-04 08:00:00', '', '2020-05-04 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(23, 'RUSDI', 5, 'STAFF', '2005-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-05 08:00:00', '', '2020-05-05 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(24, 'RUSDI', 5, 'STAFF', '2006-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-06 08:00:00', '8:06', '2020-05-06 16:30:00', '13:02', '', '', '4,93', '', '3,57', '0,1', '3,47', '', '', ''),
(25, 'RUSDI', 5, 'STAFF', '2007-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-07 08:00:00', '', '2020-05-07 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(26, 'RUSDI', 5, 'STAFF', '2008-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-08 08:00:00', '8:04', '2020-05-08 16:30:00', '13:08', '', '', '5,07', '', '3,43', '0,07', '3,37', '', '', ''),
(27, 'RUSDI', 5, 'STAFF', '2009-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-09 09:00:00', '', '2020-05-09 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(28, 'RUSDI', 5, 'STAFF', '2010-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(29, 'RUSDI', 5, 'STAFF', '2011-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-11 08:00:00', '8:05', '2020-05-11 16:30:00', '13:49', '', '', '5,73', '', '2,77', '0,08', '2,68', '', '', ''),
(30, 'RUSDI', 5, 'STAFF', '2012-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-12 08:00:00', '8:06', '2020-05-12 16:30:00', '13:17', '', '', '5,18', '', '3,32', '0,1', '3,22', '', '', ''),
(31, 'RUSDI', 5, 'STAFF', '2013-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-13 08:00:00', '8:07', '2020-05-13 16:30:00', '14:27', '', '', '6,33', '', '2,17', '0,12', '2,05', '', '', ''),
(32, 'RUSDI', 5, 'STAFF', '2014-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-14 08:00:00', '8:09', '2020-05-14 16:30:00', '14:42', '', '', '6,55', '', '1,95', '0,15', '1,8', '', '', ''),
(33, 'RUSDI', 5, 'STAFF', '2015-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-15 08:00:00', '8:06', '2020-05-15 16:30:00', '13:11', '', '', '5,08', '', '3,42', '0,1', '3,32', '', '', ''),
(34, 'RUSDI', 5, 'STAFF', '2016-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-16 09:00:00', '', '2020-05-16 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(35, 'RUSDI', 5, 'STAFF', '2017-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(36, 'RUSDI', 5, 'STAFF', '2018-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-18 08:00:00', '8:07', '2020-05-18 16:30:00', '13:08', '', '', '5,02', '', '3,48', '0,12', '3,37', '', '', ''),
(37, 'YAYUK', 6, 'STAFF', '2001-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-01 08:00:00', '', '2020-05-01 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(38, 'YAYUK', 6, 'STAFF', '2002-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-02 09:00:00', '', '2020-05-02 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(39, 'YAYUK', 6, 'STAFF', '2003-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(40, 'YAYUK', 6, 'STAFF', '2004-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-04 08:00:00', '', '2020-05-04 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(41, 'YAYUK', 6, 'STAFF', '2005-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-05 08:00:00', '', '2020-05-05 16:30:00', '15:08', '', '', '', '', '8,5', '', '1,37', '8,5', '1', ''),
(42, 'YAYUK', 6, 'STAFF', '2006-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-06 08:00:00', '8:00', '2020-05-06 16:30:00', '15:05', '', '', '7,08', '', '1,42', '', '1,42', '', '', ''),
(43, 'YAYUK', 6, 'STAFF', '2007-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-07 08:00:00', '', '2020-05-07 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(44, 'YAYUK', 6, 'STAFF', '2008-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-08 08:00:00', '8:05', '2020-05-08 16:30:00', '13:12', '', '', '5,12', '', '3,38', '0,08', '3,3', '', '', ''),
(45, 'YAYUK', 6, 'STAFF', '2009-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-09 09:00:00', '', '2020-05-09 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(46, 'YAYUK', 6, 'STAFF', '2010-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(47, 'YAYUK', 6, 'STAFF', '2011-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-11 08:00:00', '8:11', '2020-05-11 16:30:00', '14:00', '', '', '5,82', '', '2,68', '0,18', '2,5', '', '', ''),
(48, 'YAYUK', 6, 'STAFF', '2012-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-12 08:00:00', '8:02', '2020-05-12 16:30:00', '13:30', '', '', '5,47', '', '3,03', '0,03', '3', '', '', ''),
(49, 'YAYUK', 6, 'STAFF', '2013-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-13 08:00:00', '8:01', '2020-05-13 16:30:00', '15:01', '', '', '7', '', '1,5', '0,02', '1,48', '', '', ''),
(50, 'YAYUK', 6, 'STAFF', '2014-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-14 08:00:00', '8:09', '2020-05-14 16:30:00', '15:16', '', '', '7,12', '', '1,38', '0,15', '1,23', '', '', ''),
(51, 'YAYUK', 6, 'STAFF', '2015-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-15 08:00:00', '8:13', '2020-05-15 16:30:00', '13:25', '', '', '5,2', '', '3,3', '0,22', '3,08', '', '', ''),
(52, 'YAYUK', 6, 'STAFF', '2016-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-16 09:00:00', '', '2020-05-16 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(53, 'YAYUK', 6, 'STAFF', '2017-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(54, 'YAYUK', 6, 'STAFF', '2018-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2018-05-20 07:59:00', '7:58', '2020-05-18 16:30:00', '13:32', '', '', '5,53', '', '2,97', '', '2,97', '', '', ''),
(55, 'DWI H', 7, 'STAFF', '2001-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-01 08:00:00', '', '2020-05-01 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(56, 'DWI H', 7, 'STAFF', '2002-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-02 09:00:00', '', '2020-05-02 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(57, 'DWI H', 7, 'STAFF', '2003-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(58, 'DWI H', 7, 'STAFF', '2004-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-04 08:00:00', '', '2020-05-04 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(59, 'DWI H', 7, 'STAFF', '2005-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-05 08:00:00', '', '2020-05-05 16:30:00', '15:08', '', '', '', '', '8,5', '', '1,37', '8,5', '1', ''),
(60, 'DWI H', 7, 'STAFF', '2006-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-06 08:00:00', '8:11', '2020-05-06 16:30:00', '15:04', '', '', '6,88', '', '1,62', '0,18', '1,43', '', '', ''),
(61, 'DWI H', 7, 'STAFF', '2007-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-07 08:00:00', '', '2020-05-07 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(62, 'DWI H', 7, 'STAFF', '2008-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-08 08:00:00', '8:13', '2020-05-08 16:30:00', '13:47', '', '', '5,57', '', '2,93', '0,22', '2,72', '', '', ''),
(63, 'DWI H', 7, 'STAFF', '2009-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-09 09:00:00', '', '2020-05-09 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(64, 'DWI H', 7, 'STAFF', '2010-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(65, 'DWI H', 7, 'STAFF', '2011-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-11 08:00:00', '8:13', '2020-05-11 16:30:00', '15:00', '', '', '6,78', '', '1,72', '0,22', '1,5', '', '', ''),
(66, 'DWI H', 7, 'STAFF', '2012-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-12 08:00:00', '8:07', '2020-05-12 16:30:00', '16:17', '', '', '8,17', '', '0,33', '0,12', '0,22', '', '', ''),
(67, 'DWI H', 7, 'STAFF', '2013-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-13 08:00:00', '8:11', '2020-05-13 16:30:00', '16:01', '', '', '7,83', '', '0,67', '0,18', '0,48', '', '', ''),
(68, 'DWI H', 7, 'STAFF', '2014-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-14 08:00:00', '8:11', '2020-05-14 16:30:00', '15:43', '', '', '7,53', '', '0,97', '0,18', '0,78', '', '', ''),
(69, 'DWI H', 7, 'STAFF', '2015-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-15 08:00:00', '8:13', '2020-05-15 16:30:00', '15:19', '', '', '7,1', '', '1,4', '0,22', '1,18', '', '', ''),
(70, 'DWI H', 7, 'STAFF', '2016-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-16 09:00:00', '', '2020-05-16 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(71, 'DWI H', 7, 'STAFF', '2017-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(72, 'DWI H', 7, 'STAFF', '2018-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-18 08:00:00', '8:15', '2020-05-18 16:30:00', '14:34', '', '', '6,32', '', '2,18', '0,25', '1,93', '', '', ''),
(73, 'MAZIYAH', 8, 'STAFF', '2001-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-01 08:00:00', '', '2020-05-01 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(74, 'MAZIYAH', 8, 'STAFF', '2002-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-02 09:00:00', '', '2020-05-02 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(75, 'MAZIYAH', 8, 'STAFF', '2003-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(76, 'MAZIYAH', 8, 'STAFF', '2004-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-04 08:00:00', '', '2020-05-04 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(77, 'MAZIYAH', 8, 'STAFF', '2005-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-05 08:00:00', '', '2020-05-05 16:30:00', '15:08', '', '', '', '', '8,5', '', '1,37', '8,5', '1', ''),
(78, 'MAZIYAH', 8, 'STAFF', '2006-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2006-05-20 07:59:00', '7:41', '2020-05-06 16:30:00', '14:48', '', '', '6,8', '', '1,7', '', '1,7', '', '', ''),
(79, 'MAZIYAH', 8, 'STAFF', '2007-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-07 08:00:00', '', '2020-05-07 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(80, 'MAZIYAH', 8, 'STAFF', '2008-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2008-05-20 07:59:00', '7:44', '2020-05-08 16:30:00', '13:37', '', '', '5,62', '', '2,88', '', '2,88', '', '', ''),
(81, 'MAZIYAH', 8, 'STAFF', '2009-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-09 09:00:00', '', '2020-05-09 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(82, 'MAZIYAH', 8, 'STAFF', '2010-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(83, 'MAZIYAH', 8, 'STAFF', '2011-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2011-05-20 07:59:00', '7:43', '2020-05-11 16:30:00', '14:46', '', '', '6,77', '', '1,73', '', '1,73', '', '', ''),
(84, 'MAZIYAH', 8, 'STAFF', '2012-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2012-05-20 07:59:00', '7:41', '2020-05-12 16:30:00', '13:21', '', '', '5,35', '', '3,15', '', '3,15', '', '', ''),
(85, 'MAZIYAH', 8, 'STAFF', '2013-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2013-05-20 07:59:00', '7:50', '2020-05-13 16:30:00', '15:19', '', '', '7,32', '', '1,18', '', '1,18', '', '', ''),
(86, 'MAZIYAH', 8, 'STAFF', '2014-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2014-05-20 07:59:00', '7:25', '2020-05-14 16:30:00', '15:14', '', '', '7,23', '', '1,27', '', '1,27', '', '', ''),
(87, 'MAZIYAH', 8, 'STAFF', '2015-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-15 08:00:00', '8:00', '2020-05-15 16:30:00', '13:53', '', '', '5,88', '', '2,62', '', '2,62', '', '', ''),
(88, 'MAZIYAH', 8, 'STAFF', '2016-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-16 09:00:00', '', '2020-05-16 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(89, 'MAZIYAH', 8, 'STAFF', '2017-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(90, 'MAZIYAH', 8, 'STAFF', '2018-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2018-05-20 07:59:00', '7:49', '2020-05-18 16:30:00', '14:34', '', '', '6,57', '', '1,93', '', '1,93', '', '', ''),
(91, 'EKO S', 10, 'STAFF', '2001-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-01 08:00:00', '', '2020-05-01 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(92, 'EKO S', 10, 'STAFF', '2002-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-02 09:00:00', '', '2020-05-02 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(93, 'EKO S', 10, 'STAFF', '2003-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(94, 'EKO S', 10, 'STAFF', '2004-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-04 08:00:00', '', '2020-05-04 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(95, 'EKO S', 10, 'STAFF', '2005-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-05 08:00:00', '', '2020-05-05 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(96, 'EKO S', 10, 'STAFF', '2006-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2006-05-20 07:59:00', '7:52', '2020-05-06 16:30:00', '14:12', '', '', '6,2', '', '2,3', '', '2,3', '', '', ''),
(97, 'EKO S', 10, 'STAFF', '2007-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-07 08:00:00', '', '2020-05-07 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(98, 'EKO S', 10, 'STAFF', '2008-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2008-05-20 07:59:00', '7:54', '2020-05-08 16:30:00', '13:27', '', '', '5,45', '', '3,05', '', '3,05', '', '', ''),
(99, 'EKO S', 10, 'STAFF', '2009-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-09 09:00:00', '', '2020-05-09 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(100, 'EKO S', 10, 'STAFF', '2010-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(101, 'EKO S', 10, 'STAFF', '2011-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2011-05-20 07:59:00', '7:33', '2020-05-11 16:30:00', '13:34', '', '', '5,57', '', '2,93', '', '2,93', '', '', ''),
(102, 'EKO S', 10, 'STAFF', '2012-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2012-05-20 07:59:00', '7:52', '2020-05-12 16:30:00', '13:16', '', '', '5,27', '', '3,23', '', '3,23', '', '', ''),
(103, 'EKO S', 10, 'STAFF', '2013-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2013-05-20 07:59:00', '7:54', '2020-05-13 16:30:00', '13:41', '', '', '5,68', '', '2,82', '', '2,82', '', '', ''),
(104, 'EKO S', 10, 'STAFF', '2014-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2014-05-20 07:59:00', '7:36', '2020-05-14 16:30:00', '14:18', '', '', '6,3', '', '2,2', '', '2,2', '', '', ''),
(105, 'EKO S', 10, 'STAFF', '2015-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2015-05-20 07:59:00', '7:49', '2020-05-15 16:30:00', '13:14', '', '', '5,23', '', '3,27', '', '3,27', '', '', ''),
(106, 'EKO S', 10, 'STAFF', '2016-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-16 09:00:00', '', '2020-05-16 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(107, 'EKO S', 10, 'STAFF', '2017-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(108, 'EKO S', 10, 'STAFF', '2018-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-18 08:00:00', '7:54', '2020-05-18 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '1', ''),
(109, 'SURYATI', 11, 'STAFF', '2001-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-01 08:00:00', '', '2020-05-01 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(110, 'SURYATI', 11, 'STAFF', '2002-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-02 09:00:00', '', '2020-05-02 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(111, 'SURYATI', 11, 'STAFF', '2003-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(112, 'SURYATI', 11, 'STAFF', '2004-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-04 08:00:00', '', '2020-05-04 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(113, 'SURYATI', 11, 'STAFF', '2005-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-05 08:00:00', '', '2020-05-05 16:30:00', '14:56', '', '', '', '', '8,5', '', '1,57', '8,5', '1', ''),
(114, 'SURYATI', 11, 'STAFF', '2006-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2006-05-20 07:59:00', '7:11', '2020-05-06 16:30:00', '15:01', '', '', '7,02', '', '1,48', '', '1,48', '', '', ''),
(115, 'SURYATI', 11, 'STAFF', '2007-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-07 08:00:00', '', '2020-05-07 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(116, 'SURYATI', 11, 'STAFF', '2008-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2008-05-20 07:59:00', '7:05', '2020-05-08 16:30:00', '13:32', '', '', '5,53', '', '2,97', '', '2,97', '', '', ''),
(117, 'SURYATI', 11, 'STAFF', '2009-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-09 09:00:00', '', '2020-05-09 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(118, 'SURYATI', 11, 'STAFF', '2010-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(119, 'SURYATI', 11, 'STAFF', '2011-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2011-05-20 07:59:00', '6:50', '2020-05-11 16:30:00', '15:00', '', '', '7', '', '1,5', '', '1,5', '', '', ''),
(120, 'SURYATI', 11, 'STAFF', '2012-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2012-05-20 07:59:00', '7:04', '2020-05-12 16:30:00', '13:22', '', '', '5,37', '', '3,13', '', '3,13', '', '', ''),
(121, 'SURYATI', 11, 'STAFF', '2013-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2013-05-20 07:59:00', '7:09', '2020-05-13 16:30:00', '15:22', '', '', '7,37', '', '1,13', '', '1,13', '', '', ''),
(122, 'SURYATI', 11, 'STAFF', '2014-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2014-05-20 07:59:00', '7:00', '2020-05-14 16:30:00', '15:06', '', '', '7,1', '', '1,4', '', '1,4', '', '', ''),
(123, 'SURYATI', 11, 'STAFF', '2015-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2015-05-20 07:59:00', '7:08', '2020-05-15 16:30:00', '14:11', '', '', '6,18', '', '2,32', '', '2,32', '', '', ''),
(124, 'SURYATI', 11, 'STAFF', '2016-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-16 09:00:00', '', '2020-05-16 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(125, 'SURYATI', 11, 'STAFF', '2017-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(126, 'SURYATI', 11, 'STAFF', '2018-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2018-05-20 07:59:00', '7:02', '2020-05-18 16:30:00', '13:33', '', '', '5,55', '', '2,95', '', '2,95', '', '', ''),
(127, 'WANTI', 14, 'STAFF', '2001-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-01 08:00:00', '', '2020-05-01 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(128, 'WANTI', 14, 'STAFF', '2002-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-02 09:00:00', '', '2020-05-02 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(129, 'WANTI', 14, 'STAFF', '2003-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(130, 'WANTI', 14, 'STAFF', '2004-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-04 08:00:00', '', '2020-05-04 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(131, 'WANTI', 14, 'STAFF', '2005-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-05 08:00:00', '', '2020-05-05 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(132, 'WANTI', 14, 'STAFF', '2006-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2006-05-20 07:59:00', '7:48', '2020-05-06 16:30:00', '15:02', '', '', '7,03', '', '1,47', '', '1,47', '', '', ''),
(133, 'WANTI', 14, 'STAFF', '2007-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-07 08:00:00', '', '2020-05-07 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(134, 'WANTI', 14, 'STAFF', '2008-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2008-05-20 07:59:00', '7:58', '2020-05-08 16:30:00', '13:32', '', '', '5,53', '', '2,97', '', '2,97', '', '', ''),
(135, 'WANTI', 14, 'STAFF', '2009-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-09 09:00:00', '', '2020-05-09 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(136, 'WANTI', 14, 'STAFF', '2010-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(137, 'WANTI', 14, 'STAFF', '2011-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-11 08:00:00', '8:05', '2020-05-11 16:30:00', '15:00', '', '', '6,92', '', '1,58', '0,08', '1,5', '', '', ''),
(138, 'WANTI', 14, 'STAFF', '2012-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-12 08:00:00', '8:08', '2020-05-12 16:30:00', '13:15', '', '', '5,12', '', '3,38', '0,13', '3,25', '', '', ''),
(139, 'WANTI', 14, 'STAFF', '2013-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-13 08:00:00', '8:02', '2020-05-13 16:30:00', '15:19', '', '', '7,28', '', '1,22', '0,03', '1,18', '', '', ''),
(140, 'WANTI', 14, 'STAFF', '2014-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2014-05-20 07:59:00', '7:57', '2020-05-14 16:30:00', '15:14', '', '', '7,23', '', '1,27', '', '1,27', '', '', ''),
(141, 'WANTI', 14, 'STAFF', '2015-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2015-05-20 07:59:00', '7:59', '2020-05-15 16:30:00', '13:16', '', '', '5,27', '', '3,23', '', '3,23', '', '', ''),
(142, 'WANTI', 14, 'STAFF', '2016-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-16 09:00:00', '', '2020-05-16 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(143, 'WANTI', 14, 'STAFF', '2017-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(144, 'WANTI', 14, 'STAFF', '2018-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2018-05-20 07:59:00', '7:53', '2020-05-18 16:30:00', '13:32', '', '', '5,53', '', '2,97', '', '2,97', '', '', ''),
(145, 'TRIYATI', 15, 'STAFF', '2001-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-01 08:00:00', '', '2020-05-01 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(146, 'TRIYATI', 15, 'STAFF', '2002-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-02 09:00:00', '', '2020-05-02 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(147, 'TRIYATI', 15, 'STAFF', '2003-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(148, 'TRIYATI', 15, 'STAFF', '2004-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-04 08:00:00', '', '2020-05-04 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(149, 'TRIYATI', 15, 'STAFF', '2005-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-05 08:00:00', '', '2020-05-05 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(150, 'TRIYATI', 15, 'STAFF', '2006-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2006-05-20 07:59:00', '7:29', '2020-05-06 16:30:00', '14:37', '', '', '6,62', '', '1,88', '', '1,88', '', '', ''),
(151, 'TRIYATI', 15, 'STAFF', '2007-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-07 08:00:00', '', '2020-05-07 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(152, 'TRIYATI', 15, 'STAFF', '2008-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-08 08:00:00', '8:01', '2020-05-08 16:30:00', '13:37', '', '', '5,6', '', '2,9', '0,02', '2,88', '', '', ''),
(153, 'TRIYATI', 15, 'STAFF', '2009-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-09 09:00:00', '', '2020-05-09 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(154, 'TRIYATI', 15, 'STAFF', '2010-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(155, 'TRIYATI', 15, 'STAFF', '2011-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2011-05-20 07:59:00', '7:37', '2020-05-11 16:30:00', '14:19', '', '', '6,32', '', '2,18', '', '2,18', '', '', ''),
(156, 'TRIYATI', 15, 'STAFF', '2012-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2012-05-20 07:59:00', '7:50', '2020-05-12 16:30:00', '13:27', '', '', '5,45', '', '3,05', '', '3,05', '', '', ''),
(157, 'TRIYATI', 15, 'STAFF', '2013-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2013-05-20 07:59:00', '7:11', '2020-05-13 16:30:00', '14:50', '', '', '6,83', '', '1,67', '', '1,67', '', '', ''),
(158, 'TRIYATI', 15, 'STAFF', '2014-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2014-05-20 07:59:00', '7:23', '2020-05-14 16:30:00', '14:43', '', '', '6,72', '', '1,78', '', '1,78', '', '', ''),
(159, 'TRIYATI', 15, 'STAFF', '2015-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2015-05-20 07:59:00', '7:40', '2020-05-15 16:30:00', '13:17', '', '', '5,28', '', '3,22', '', '3,22', '', '', ''),
(160, 'TRIYATI', 15, 'STAFF', '2016-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-16 09:00:00', '', '2020-05-16 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(161, 'TRIYATI', 15, 'STAFF', '2017-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(162, 'TRIYATI', 15, 'STAFF', '2018-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2018-05-20 07:59:00', '7:45', '2020-05-18 16:30:00', '13:27', '', '', '5,45', '', '3,05', '', '3,05', '', '', ''),
(163, 'AGUS', 16, 'STAFF', '2001-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-01 08:00:00', '', '2020-05-01 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(164, 'AGUS', 16, 'STAFF', '2002-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-02 09:00:00', '', '2020-05-02 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(165, 'AGUS', 16, 'STAFF', '2003-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(166, 'AGUS', 16, 'STAFF', '2004-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-04 08:00:00', '', '2020-05-04 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(167, 'AGUS', 16, 'STAFF', '2005-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-05 08:00:00', '', '2020-05-05 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(168, 'AGUS', 16, 'STAFF', '2006-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-06 08:00:00', '8:21', '2020-05-06 16:30:00', '14:30', '', '', '6,15', '', '2,35', '0,35', '2', '', '', ''),
(169, 'AGUS', 16, 'STAFF', '2007-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-07 08:00:00', '', '2020-05-07 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(170, 'AGUS', 16, 'STAFF', '2008-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-08 08:00:00', '8:19', '2020-05-08 16:30:00', '13:39', '', '', '5,33', '', '3,17', '0,32', '2,85', '', '', ''),
(171, 'AGUS', 16, 'STAFF', '2009-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-09 09:00:00', '', '2020-05-09 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(172, 'AGUS', 16, 'STAFF', '2010-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(173, 'AGUS', 16, 'STAFF', '2011-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-11 08:00:00', '8:25', '2020-05-11 16:30:00', '14:19', '', '', '5,9', '', '2,6', '0,42', '2,18', '', '', ''),
(174, 'AGUS', 16, 'STAFF', '2012-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-12 08:00:00', '8:19', '2020-05-12 16:30:00', '13:23', '', '', '5,07', '', '3,43', '0,32', '3,12', '', '', ''),
(175, 'AGUS', 16, 'STAFF', '2013-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-13 08:00:00', '8:26', '2020-05-13 16:30:00', '14:51', '', '', '6,42', '', '2,08', '0,43', '1,65', '', '', ''),
(176, 'AGUS', 16, 'STAFF', '2014-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-14 08:00:00', '8:14', '2020-05-14 16:30:00', '14:45', '', '', '6,52', '', '1,98', '0,23', '1,75', '', '', ''),
(177, 'AGUS', 16, 'STAFF', '2015-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-15 08:00:00', '8:35', '2020-05-15 16:30:00', '13:25', '', '', '4,83', '', '3,67', '0,58', '3,08', '', '', ''),
(178, 'AGUS', 16, 'STAFF', '2016-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-16 09:00:00', '', '2020-05-16 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(179, 'AGUS', 16, 'STAFF', '2017-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(180, 'AGUS', 16, 'STAFF', '2018-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-18 08:00:00', '8:20', '2020-05-18 16:30:00', '13:26', '', '', '5,1', '', '3,4', '0,33', '3,07', '', '', ''),
(181, 'PURWANINGSIH', 18, 'STAFF', '2001-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-01 08:00:00', '', '2020-05-01 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(182, 'PURWANINGSIH', 18, 'STAFF', '2002-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-02 09:00:00', '', '2020-05-02 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(183, 'PURWANINGSIH', 18, 'STAFF', '2003-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(184, 'PURWANINGSIH', 18, 'STAFF', '2004-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-04 08:00:00', '', '2020-05-04 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(185, 'PURWANINGSIH', 18, 'STAFF', '2005-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-05 08:00:00', '', '2020-05-05 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(186, 'PURWANINGSIH', 18, 'STAFF', '2006-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-06 08:00:00', '8:08', '2020-05-06 16:30:00', '14:29', '', '', '6,35', '', '2,15', '0,13', '2,02', '', '', ''),
(187, 'PURWANINGSIH', 18, 'STAFF', '2007-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-07 08:00:00', '', '2020-05-07 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(188, 'PURWANINGSIH', 18, 'STAFF', '2008-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-08 08:00:00', '8:30', '2020-05-08 16:30:00', '13:38', '', '', '5,13', '', '3,37', '0,5', '2,87', '', '', ''),
(189, 'PURWANINGSIH', 18, 'STAFF', '2009-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-09 09:00:00', '', '2020-05-09 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(190, 'PURWANINGSIH', 18, 'STAFF', '2010-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(191, 'PURWANINGSIH', 18, 'STAFF', '2011-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-11 08:00:00', '', '2020-05-11 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(192, 'PURWANINGSIH', 18, 'STAFF', '2012-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-12 08:00:00', '', '2020-05-12 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(193, 'PURWANINGSIH', 18, 'STAFF', '2013-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-13 08:00:00', '8:06', '2020-05-13 16:30:00', '14:47', '', '', '6,68', '', '1,82', '0,1', '1,72', '', '', ''),
(194, 'PURWANINGSIH', 18, 'STAFF', '2014-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-14 08:00:00', '8:12', '2020-05-14 16:30:00', '14:42', '', '', '6,5', '', '2', '0,2', '1,8', '', '', ''),
(195, 'PURWANINGSIH', 18, 'STAFF', '2015-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-15 08:00:00', '8:13', '2020-05-15 16:30:00', '13:20', '', '', '5,12', '', '3,38', '0,22', '3,17', '', '', ''),
(196, 'PURWANINGSIH', 18, 'STAFF', '2016-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-16 09:00:00', '', '2020-05-16 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(197, 'PURWANINGSIH', 18, 'STAFF', '2017-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(198, 'PURWANINGSIH', 18, 'STAFF', '2018-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-18 08:00:00', '8:10', '2020-05-18 16:30:00', '13:33', '', '', '5,38', '', '3,12', '0,17', '2,95', '', '', ''),
(199, 'INDRI', 19, 'STAFF', '2001-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-01 08:00:00', '', '2020-05-01 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(200, 'INDRI', 19, 'STAFF', '2002-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-02 09:00:00', '', '2020-05-02 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(201, 'INDRI', 19, 'STAFF', '2003-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(202, 'INDRI', 19, 'STAFF', '2004-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-04 08:00:00', '', '2020-05-04 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(203, 'INDRI', 19, 'STAFF', '2005-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-05 08:00:00', '', '2020-05-05 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(204, 'INDRI', 19, 'STAFF', '2006-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-06 08:00:00', '8:05', '2020-05-06 16:30:00', '14:29', '', '', '6,4', '', '2,1', '0,08', '2,02', '', '', ''),
(205, 'INDRI', 19, 'STAFF', '2007-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-07 08:00:00', '', '2020-05-07 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(206, 'INDRI', 19, 'STAFF', '2008-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-08 08:00:00', '8:03', '2020-05-08 16:30:00', '13:33', '', '', '5,5', '', '3', '0,05', '2,95', '', '', ''),
(207, 'INDRI', 19, 'STAFF', '2009-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-09 09:00:00', '', '2020-05-09 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(208, 'INDRI', 19, 'STAFF', '2010-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(209, 'INDRI', 19, 'STAFF', '2011-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-11 08:00:00', '8:04', '2020-05-11 16:30:00', '14:22', '', '', '6,3', '', '2,2', '0,07', '2,13', '', '', ''),
(210, 'INDRI', 19, 'STAFF', '2012-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-12 08:00:00', '8:04', '2020-05-12 16:30:00', '13:26', '', '', '5,37', '', '3,13', '0,07', '3,07', '', '', ''),
(211, 'INDRI', 19, 'STAFF', '2013-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-13 08:00:00', '8:10', '2020-05-13 16:30:00', '14:47', '', '', '6,62', '', '1,88', '0,17', '1,72', '', '', ''),
(212, 'INDRI', 19, 'STAFF', '2014-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-14 08:00:00', '8:08', '2020-05-14 16:30:00', '14:41', '', '', '6,55', '', '1,95', '0,13', '1,82', '', '', ''),
(213, 'INDRI', 19, 'STAFF', '2015-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-15 08:00:00', '8:08', '2020-05-15 16:30:00', '13:29', '', '', '5,35', '', '3,15', '0,13', '3,02', '', '', ''),
(214, 'INDRI', 19, 'STAFF', '2016-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-16 09:00:00', '', '2020-05-16 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(215, 'INDRI', 19, 'STAFF', '2017-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(216, 'INDRI', 19, 'STAFF', '2018-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-18 08:00:00', '8:04', '2020-05-18 16:30:00', '13:08', '', '', '5,07', '', '3,43', '0,07', '3,37', '', '', ''),
(217, 'QOTY', 20, 'STAFF', '2001-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-01 08:00:00', '', '2020-05-01 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(218, 'QOTY', 20, 'STAFF', '2002-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-02 09:00:00', '', '2020-05-02 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(219, 'QOTY', 20, 'STAFF', '2003-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(220, 'QOTY', 20, 'STAFF', '2004-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-04 08:00:00', '', '2020-05-04 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(221, 'QOTY', 20, 'STAFF', '2005-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-05 08:00:00', '', '2020-05-05 16:30:00', '15:08', '', '', '', '', '8,5', '', '1,37', '8,5', '1', ''),
(222, 'QOTY', 20, 'STAFF', '2006-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-06 08:00:00', '8:15', '2020-05-06 16:30:00', '14:31', '', '', '6,27', '', '2,23', '0,25', '1,98', '', '', ''),
(223, 'QOTY', 20, 'STAFF', '2007-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-07 08:00:00', '', '2020-05-07 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(224, 'QOTY', 20, 'STAFF', '2008-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-08 08:00:00', '8:13', '2020-05-08 16:30:00', '13:38', '', '', '5,42', '', '3,08', '0,22', '2,87', '', '', ''),
(225, 'QOTY', 20, 'STAFF', '2009-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-09 09:00:00', '', '2020-05-09 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(226, 'QOTY', 20, 'STAFF', '2010-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(227, 'QOTY', 20, 'STAFF', '2011-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-11 08:00:00', '8:10', '2020-05-11 16:30:00', '14:22', '', '', '6,2', '', '2,3', '0,17', '2,13', '', '', ''),
(228, 'QOTY', 20, 'STAFF', '2012-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-12 08:00:00', '8:14', '2020-05-12 16:30:00', '13:27', '', '', '5,22', '', '3,28', '0,23', '3,05', '', '', ''),
(229, 'QOTY', 20, 'STAFF', '2013-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-13 08:00:00', '8:13', '2020-05-13 16:30:00', '14:47', '', '', '6,57', '', '1,93', '0,22', '1,72', '', '', ''),
(230, 'QOTY', 20, 'STAFF', '2014-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-14 08:00:00', '8:13', '2020-05-14 16:30:00', '14:44', '', '', '6,52', '', '1,98', '0,22', '1,77', '', '', ''),
(231, 'QOTY', 20, 'STAFF', '2015-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-15 08:00:00', '8:13', '2020-05-15 16:30:00', '13:23', '', '', '5,17', '', '3,33', '0,22', '3,12', '', '', ''),
(232, 'QOTY', 20, 'STAFF', '2016-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-16 09:00:00', '', '2020-05-16 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(233, 'QOTY', 20, 'STAFF', '2017-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(234, 'QOTY', 20, 'STAFF', '2018-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-18 08:00:00', '8:13', '2020-05-18 16:30:00', '13:44', '', '', '5,52', '', '2,98', '0,22', '2,77', '', '', ''),
(235, 'RUKUN', 22, 'STAFF', '2001-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-01 08:00:00', '', '2020-05-01 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(236, 'RUKUN', 22, 'STAFF', '2002-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-02 09:00:00', '', '2020-05-02 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(237, 'RUKUN', 22, 'STAFF', '2003-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(238, 'RUKUN', 22, 'STAFF', '2004-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-04 08:00:00', '', '2020-05-04 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(239, 'RUKUN', 22, 'STAFF', '2005-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-05 08:00:00', '', '2020-05-05 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(240, 'RUKUN', 22, 'STAFF', '2006-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-06 08:00:00', '8:01', '2020-05-06 16:30:00', '13:46', '', '', '5,75', '', '2,75', '0,02', '2,73', '', '', ''),
(241, 'RUKUN', 22, 'STAFF', '2007-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-07 08:00:00', '', '2020-05-07 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(242, 'RUKUN', 22, 'STAFF', '2008-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2008-05-20 07:59:00', '7:52', '2020-05-08 16:30:00', '14:00', '', '', '6', '', '2,5', '', '2,5', '', '', ''),
(243, 'RUKUN', 22, 'STAFF', '2009-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-09 09:00:00', '', '2020-05-09 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(244, 'RUKUN', 22, 'STAFF', '2010-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(245, 'RUKUN', 22, 'STAFF', '2011-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2011-05-20 07:59:00', '7:54', '2020-05-11 16:30:00', '13:25', '', '', '5,42', '', '3,08', '', '3,08', '', '', ''),
(246, 'RUKUN', 22, 'STAFF', '2012-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-12 08:00:00', '8:09', '2020-05-12 16:30:00', '13:20', '', '', '5,18', '', '3,32', '0,15', '3,17', '', '', ''),
(247, 'RUKUN', 22, 'STAFF', '2013-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2013-05-20 07:59:00', '7:57', '2020-05-13 16:30:00', '13:20', '', '', '5,33', '', '3,17', '', '3,17', '', '', ''),
(248, 'RUKUN', 22, 'STAFF', '2014-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-14 08:00:00', '8:04', '2020-05-14 16:30:00', '13:29', '', '', '5,42', '', '3,08', '0,07', '3,02', '', '', ''),
(249, 'RUKUN', 22, 'STAFF', '2015-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2015-05-20 07:59:00', '7:57', '2020-05-15 16:30:00', '13:27', '', '', '5,45', '', '3,05', '', '3,05', '', '', ''),
(250, 'RUKUN', 22, 'STAFF', '2016-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-16 09:00:00', '', '2020-05-16 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(251, 'RUKUN', 22, 'STAFF', '2017-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(252, 'RUKUN', 22, 'STAFF', '2018-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2018-05-20 07:59:00', '7:41', '2020-05-18 16:30:00', '13:07', '', '', '5,12', '', '3,38', '', '3,38', '', '', ''),
(253, 'VERY', 24, 'STAFF', '2001-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-01 08:00:00', '', '2020-05-01 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(254, 'VERY', 24, 'STAFF', '2002-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-02 09:00:00', '', '2020-05-02 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(255, 'VERY', 24, 'STAFF', '2003-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(256, 'VERY', 24, 'STAFF', '2004-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-04 08:00:00', '', '2020-05-04 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(257, 'VERY', 24, 'STAFF', '2005-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-05 08:00:00', '', '2020-05-05 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(258, 'VERY', 24, 'STAFF', '2006-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-06 08:00:00', '8:14', '2020-05-06 16:30:00', '14:23', '', '', '6,15', '', '2,35', '0,23', '2,12', '', '', ''),
(259, 'VERY', 24, 'STAFF', '2007-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-07 08:00:00', '', '2020-05-07 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(260, 'VERY', 24, 'STAFF', '2008-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-08 08:00:00', '8:18', '2020-05-08 16:30:00', '13:21', '', '', '5,05', '', '3,45', '0,3', '3,15', '', '', ''),
(261, 'VERY', 24, 'STAFF', '2009-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-09 09:00:00', '', '2020-05-09 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(262, 'VERY', 24, 'STAFF', '2010-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(263, 'VERY', 24, 'STAFF', '2011-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-11 08:00:00', '8:07', '2020-05-11 16:30:00', '13:34', '', '', '5,45', '', '3,05', '0,12', '2,93', '', '', ''),
(264, 'VERY', 24, 'STAFF', '2012-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-12 08:00:00', '8:14', '2020-05-12 16:30:00', '13:13', '', '', '4,98', '', '3,52', '0,23', '3,28', '', '', ''),
(265, 'VERY', 24, 'STAFF', '2013-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2020-05-13 08:00:00', '8:09', '2020-05-13 16:30:00', '14:31', '', '', '6,37', '', '2,13', '0,15', '1,98', '', '', ''),
(266, 'VERY', 24, 'STAFF', '2014-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-14 08:00:00', '8:11', '2020-05-14 16:30:00', '14:30', '', '', '6,32', '', '2,18', '0,18', '2', '', '', ''),
(267, 'VERY', 24, 'STAFF', '2015-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-15 08:00:00', '8:07', '2020-05-15 16:30:00', '13:07', '', '', '5', '', '3,5', '0,12', '3,38', '', '', ''),
(268, 'VERY', 24, 'STAFF', '2016-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-16 09:00:00', '', '2020-05-16 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(269, 'VERY', 24, 'STAFF', '2017-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(270, 'VERY', 24, 'STAFF', '2018-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-18 08:00:00', '8:09', '2020-05-18 16:30:00', '13:39', '', '', '5,5', '', '3', '0,15', '2,85', '', '', ''),
(271, 'CHOIRUL', 30, 'STAFF', '2001-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2020-05-01 08:00:00', '', '2020-05-01 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(272, 'CHOIRUL', 30, 'STAFF', '2002-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-02 09:00:00', '', '2020-05-02 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(273, 'CHOIRUL', 30, 'STAFF', '2003-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(274, 'CHOIRUL', 30, 'STAFF', '2004-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-04 08:00:00', '', '2020-05-04 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(275, 'CHOIRUL', 30, 'STAFF', '2005-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-05 08:00:00', '', '2020-05-05 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(276, 'CHOIRUL', 30, 'STAFF', '2006-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2006-05-20 07:59:00', '7:54', '2020-05-06 16:30:00', '14:26', '', '', '6,43', '', '2,07', '', '2,07', '', '', '');
INSERT INTO `absen_karyawan` (`no`, `nama`, `no_staff`, `departemen`, `tanggal`, `hari`, `tipe`, `jadwal`, `tgl_masuk`, `masuk`, `tgl_keluar`, `keluar`, `lembur_masuk`, `lembur_keluar`, `jam_kerja`, `jam_lembur`, `jam_kurang`, `jam_terlambat`, `jam_pulangcpt`, `jam_absen`, `hari_lupa_io`, `jam_ijin`) VALUES
(277, 'CHOIRUL', 30, 'STAFF', '2007-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2020-05-07 08:00:00', '', '2020-05-07 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '', ''),
(278, 'CHOIRUL', 30, 'STAFF', '2008-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2008-05-20 07:59:00', '7:52', '2020-05-08 16:30:00', '13:25', '', '', '5,42', '', '3,08', '', '3,08', '', '', ''),
(279, 'CHOIRUL', 30, 'STAFF', '2009-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-09 09:00:00', '', '2020-05-09 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(280, 'CHOIRUL', 30, 'STAFF', '2010-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(281, 'CHOIRUL', 30, 'STAFF', '2011-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2020-05-11 08:00:00', '8:00', '2020-05-11 16:30:00', '14:25', '', '', '6,42', '', '2,08', '', '2,08', '', '', ''),
(282, 'CHOIRUL', 30, 'STAFF', '2012-05-20', 'Selasa', 'Hari Kerja', 'STAFF I', '2020-05-12 08:00:00', '7:56', '2020-05-12 16:30:00', '', '', '', '', '', '8,5', '', '', '8,5', '1', ''),
(283, 'CHOIRUL', 30, 'STAFF', '2013-05-20', 'Rabu ', 'Hari Kerja', 'STAFF I', '2013-05-20 07:59:00', '7:59', '2020-05-13 16:30:00', '14:50', '', '', '6,83', '', '1,67', '', '1,67', '', '', ''),
(284, 'CHOIRUL', 30, 'STAFF', '2014-05-20', 'Kamis', 'Hari Kerja', 'STAFF I', '2014-05-20 07:59:00', '7:48', '2020-05-14 16:30:00', '14:45', '', '', '6,75', '', '1,75', '', '1,75', '', '', ''),
(285, 'CHOIRUL', 30, 'STAFF', '2015-05-20', 'Jumat', 'Hari Kerja', 'STAFF I', '2015-05-20 07:59:00', '7:47', '2020-05-15 16:30:00', '14:19', '', '', '6,32', '', '2,18', '', '2,18', '', '', ''),
(286, 'CHOIRUL', 30, 'STAFF', '2016-05-20', 'Sabtu', 'Hari Kerja', 'LEMBUR', '2020-05-16 09:00:00', '', '2020-05-16 16:00:00', '', '', '', '', '', '12', '', '', '12', '', ''),
(287, 'CHOIRUL', 30, 'STAFF', '2017-05-20', 'Minggu', 'Istirahat', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(288, 'CHOIRUL', 30, 'STAFF', '2018-05-20', 'Senin', 'Hari Kerja', 'STAFF I', '2018-05-20 07:59:00', '7:56', '2020-05-18 16:30:00', '14:01', '', '', '6,02', '', '2,48', '', '2,48', '', '', ''),
(289, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(290, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(291, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(292, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(293, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(294, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(295, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(296, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(297, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(298, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(299, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(300, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(301, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(302, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(303, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(304, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(305, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(306, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(307, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(308, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(309, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(310, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(311, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(312, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(313, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(314, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(315, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(316, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(317, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(318, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(319, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(320, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(321, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(322, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(323, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(324, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(325, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(326, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(327, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(328, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(329, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(330, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(331, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(332, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(333, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(334, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(335, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(336, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(337, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(338, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(339, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(340, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(341, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(342, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(343, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(344, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(345, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(346, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(347, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(348, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(349, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(350, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(351, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(352, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(353, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(354, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(355, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(356, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(357, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(358, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(359, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(360, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(361, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(362, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(363, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(364, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(365, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(366, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(367, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(368, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(369, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(370, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(371, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(372, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(373, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(374, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(375, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(376, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(377, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(378, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(379, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(380, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(381, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(382, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(383, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(384, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(385, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(386, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(387, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(388, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(389, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(390, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(391, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(392, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(393, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(394, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(395, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(396, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(397, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(398, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(399, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(400, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(401, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(402, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(403, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(404, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(405, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(406, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(407, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(408, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(409, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(410, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(411, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(412, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(413, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(414, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(415, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(416, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(417, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(418, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(419, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(420, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(421, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(422, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(423, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(424, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(425, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(426, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(427, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(428, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(429, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(430, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(431, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(432, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(433, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(434, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(435, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(436, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(437, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(438, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(439, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(440, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(441, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(442, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(443, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(444, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(445, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(446, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(447, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(448, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(449, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(450, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(451, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(452, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(453, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(454, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(455, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(456, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(457, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(458, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(459, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(460, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(461, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(462, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(463, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(464, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(465, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(466, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(467, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(468, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(469, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(470, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(471, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(472, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(473, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(474, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(475, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(476, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(477, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(478, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(479, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(480, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(481, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(482, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(483, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(484, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(485, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(486, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(487, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(488, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(489, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(490, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(491, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(492, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(493, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(494, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(495, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(496, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(497, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(498, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(499, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(500, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(501, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(502, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(503, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(504, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(505, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(506, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(507, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(508, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(509, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(510, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(511, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(512, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(513, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(514, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(515, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(516, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(517, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(518, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(519, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(520, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(521, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(522, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(523, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(524, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(525, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(526, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(527, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(528, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(529, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(530, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(531, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(532, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(533, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(534, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(535, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(536, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(537, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(538, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(539, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(540, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(541, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(542, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(543, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(544, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(545, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(546, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(547, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(548, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(549, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(550, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(551, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(552, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(553, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(554, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(555, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(556, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(557, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', ''),
(558, '', 0, '', '0000-00-00', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `detail_karyawan`
--
CREATE TABLE `detail_karyawan` (
`no` int(11) NOT NULL,
`id_karyawan` int(11) NOT NULL,
`datang_terlambat` date NOT NULL,
`pulang_awal` date NOT NULL,
`pulang_terlambat` date NOT NULL,
`tidak_masuk` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `kehadiran_karyawan`
--
CREATE TABLE `kehadiran_karyawan` (
`no` int(11) NOT NULL,
`id_karyawan` int(11) NOT NULL,
`nama` varchar(50) NOT NULL,
`jabatan` varchar(50) NOT NULL,
`jml_hr_kerja` int(11) NOT NULL,
`jml_hr_libur` int(11) NOT NULL,
`jml_hadir` int(11) NOT NULL,
`jml_tidakmasuk` int(11) NOT NULL,
`datang_terlambat` int(11) NOT NULL,
`pulang_awal` int(11) NOT NULL,
`pulang_terlambat` int(11) NOT NULL,
`tgl_datang_terlambat` datetime NOT NULL,
`tgl_pulang_awal` datetime NOT NULL,
`tgl_pulang_terlambat` datetime NOT NULL,
`tgl_tidak_masuk` datetime NOT NULL,
`uang_makan` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `kehadiran_karyawan`
--
INSERT INTO `kehadiran_karyawan` (`no`, `id_karyawan`, `nama`, `jabatan`, `jml_hr_kerja`, `jml_hr_libur`, `jml_hadir`, `jml_tidakmasuk`, `datang_terlambat`, `pulang_awal`, `pulang_terlambat`, `tgl_datang_terlambat`, `tgl_pulang_awal`, `tgl_pulang_terlambat`, `tgl_tidak_masuk`, `uang_makan`) VALUES
(1, 1, 'YOYOK', 'D', 0, 22, 9, 18, 4, 2, 2, '2018-05-01 08:00:00', '2018-05-01 08:00:00', '2018-05-01 08:00:00', '2018-05-01 08:00:00', 0),
(2, 2, 'YOYOK', 'D', 0, 22, 9, 18, 4, 2, 2, '2018-05-01 08:00:01', '2018-05-01 08:00:01', '2018-05-01 08:00:01', '2018-05-01 08:00:01', 0),
(3, 3, 'YOYOK', 'D', 0, 22, 9, 18, 4, 2, 2, '2018-05-01 08:00:02', '2018-05-01 08:00:02', '2018-05-01 08:00:02', '2018-05-01 08:00:02', 0),
(4, 4, 'YOYOK', 'D', 0, 22, 9, 18, 4, 2, 2, '2018-05-01 08:00:03', '2018-05-01 08:00:03', '2018-05-01 08:00:03', '2018-05-01 08:00:03', 0),
(5, 5, 'YOYOK', 'D', 0, 22, 9, 18, 4, 2, 2, '2018-05-01 08:00:04', '2018-05-01 08:00:04', '2018-05-01 08:00:04', '2018-05-01 08:00:04', 0),
(6, 6, 'YOYOK', 'D', 0, 22, 9, 18, 4, 2, 2, '2018-05-01 08:00:05', '2018-05-01 08:00:05', '2018-05-01 08:00:05', '2018-05-01 08:00:05', 0),
(7, 7, 'YOYOK', 'D', 0, 22, 9, 18, 4, 2, 2, '2018-05-01 08:00:06', '2018-05-01 08:00:06', '2018-05-01 08:00:06', '2018-05-01 08:00:06', 0),
(8, 8, 'YOYOK', 'D', 0, 22, 9, 18, 4, 2, 2, '2018-05-01 08:00:07', '2018-05-01 08:00:07', '2018-05-01 08:00:07', '2018-05-01 08:00:07', 0),
(9, 9, 'YOYOK', 'D', 0, 22, 9, 18, 4, 2, 2, '2018-05-01 08:00:08', '2018-05-01 08:00:08', '2018-05-01 08:00:08', '2018-05-01 08:00:08', 0),
(10, 10, 'YOYOK', 'D', 0, 22, 9, 18, 4, 2, 2, '2018-05-01 08:00:09', '2018-05-01 08:00:09', '2018-05-01 08:00:09', '2018-05-01 08:00:09', 0);
-- --------------------------------------------------------
--
-- Table structure for table `rekap_absen`
--
CREATE TABLE `rekap_absen` (
`no` int(12) NOT NULL,
`nama` varchar(40) NOT NULL,
`no_staff` int(12) NOT NULL,
`jml_hadir` varchar(40) NOT NULL,
`jml_absen` varchar(40) NOT NULL,
`dtg_terlambat` varchar(40) NOT NULL,
`plg_awal` varchar(40) NOT NULL,
`lama_lembur` varchar(40) NOT NULL,
`kerja_4jam` varchar(40) NOT NULL,
`uang_makan` varchar(40) NOT NULL,
`jamke_1` varchar(40) NOT NULL,
`jamke_2` varchar(40) NOT NULL,
`jamke_3` varchar(40) NOT NULL,
`lama_lembur_manual` varchar(40) NOT NULL,
`jamlemburke_1` varchar(40) NOT NULL,
`jamlemburke_2` varchar(40) NOT NULL,
`jamlemburke_3` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `rekap_absen`
--
INSERT INTO `rekap_absen` (`no`, `nama`, `no_staff`, `jml_hadir`, `jml_absen`, `dtg_terlambat`, `plg_awal`, `lama_lembur`, `kerja_4jam`, `uang_makan`, `jamke_1`, `jamke_2`, `jamke_3`, `lama_lembur_manual`, `jamlemburke_1`, `jamlemburke_2`, `jamlemburke_3`) VALUES
(1, 'Ani Purwaningsih', 3, '21', '0', '16', '0', '0', '21', ' 210,000.00 ', '', '', '', '3', ' 5,000.00 ', ' 4,000.00 ', ' 1,000.00 '),
(2, 'Ruswadi', 5, '20', '1', '19', '0', '0', '20', ' 200,000.00 ', '', '', '', '2', ' 5,000.00 ', ' 4,000.00 ', '0'),
(3, 'Sri Rahayu', 6, '19', '2', '18', '0', '0', '19', ' 190,000.00 ', '', '', '', '3', ' 5,000.00 ', ' 4,000.00 ', ' 1,000.00 '),
(4, 'Dwi Handayani', 7, '21', '0', '21', '0', '0', '21', ' 210,000.00 ', '', '', '', '4', ' 5,000.00 ', ' 4,000.00 ', ' 1,000.00 '),
(5, 'Maziyah', 8, '16', '5', '15', '0', '0', '16', ' 160,000.00 ', '', '', '', '5', ' 5,000.00 ', ' 4,000.00 ', ' 1,000.00 '),
(6, 'Eko Surwulandari', 10, '21', '0', '0', '0', '0', '21', ' 210,000.00 ', '', '', '', '5', ' 5,000.00 ', ' 4,000.00 ', ' 1,000.00 '),
(7, 'Suryati', 11, '21', '0', '0', '0', '0', '21', ' 210,000.00 ', '', '', '', '4', ' 5,000.00 ', ' 4,000.00 ', ' 1,000.00 '),
(8, 'Kozin', 12, '21', '0', '11', '0', '0', '14', ' 140,000.00 ', '', '', '', '3', ' 5,000.00 ', ' 4,000.00 ', ' 1,000.00 '),
(9, 'Suwanti', 14, '20', '1', '7', '0', '0', '20', ' 200,000.00 ', '', '', '', '2', ' 5,000.00 ', ' 4,000.00 ', '0'),
(10, 'Triyati', 15, '20', '1', '8', '0', '0', '19', ' 190,000.00 ', '', '', '', '1', ' 5,000.00 ', '0', '0'),
(11, 'Agus Lilik', 16, '19', '2', '9', '0', '0', '19', ' 190,000.00 ', '', '', '', '3', ' 5,000.00 ', ' 4,000.00 ', ' 1,000.00 '),
(12, 'Purwaningsih', 18, '19', '2', '19', '0', '0', '19', ' 190,000.00 ', '', '', '', '4', ' 5,000.00 ', ' 4,000.00 ', ' 1,000.00 '),
(13, 'Indriyani', 19, '20', '1', '11', '0', '0', '20', ' 200,000.00 ', '', '', '', '2', ' 5,000.00 ', ' 4,000.00 ', '0'),
(14, 'Qottimah', 20, '21', '0', '20', '0', '0', '21', ' 210,000.00 ', '', '', '', '3', ' 5,000.00 ', ' 4,000.00 ', ' 1,000.00 '),
(15, 'Karwidi', 21, '19', '2', '2', '0', '0', '19', ' 190,000.00 ', '', '', '', '4', ' 5,000.00 ', ' 4,000.00 ', ' 1,000.00 '),
(16, 'Rukun Slamet', 22, '20', '1', '15', '0', '0', '20', ' 200,000.00 ', '', '', '', '2', ' 5,000.00 ', ' 4,000.00 ', '0'),
(17, 'Veri Sunarso', 24, '20', '1', '19', '0', '0', '20', ' 200,000.00 ', '', '', '', '3', ' 5,000.00 ', ' 4,000.00 ', ' 1,000.00 '),
(18, 'Heri Purnomo', 26, '13', '8', '7', '0', '0', '13', ' 130,000.00 ', '', '', '', '4', ' 5,000.00 ', ' 4,000.00 ', ' 1,000.00 ');
-- --------------------------------------------------------
--
-- Table structure for table `user`
--
CREATE TABLE `user` (
`id_user` int(10) NOT NULL,
`username` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
`level` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `user`
--
INSERT INTO `user` (`id_user`, `username`, `password`, `level`) VALUES
(1, '123', '321', 1);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `absen_karyawan`
--
ALTER TABLE `absen_karyawan`
ADD PRIMARY KEY (`no`);
--
-- Indexes for table `detail_karyawan`
--
ALTER TABLE `detail_karyawan`
ADD PRIMARY KEY (`id_karyawan`),
ADD KEY `no` (`no`);
--
-- Indexes for table `kehadiran_karyawan`
--
ALTER TABLE `kehadiran_karyawan`
ADD PRIMARY KEY (`id_karyawan`),
ADD KEY `no` (`no`);
--
-- Indexes for table `rekap_absen`
--
ALTER TABLE `rekap_absen`
ADD PRIMARY KEY (`no_staff`),
ADD UNIQUE KEY `UNIQUE` (`no`);
--
-- Indexes for table `user`
--
ALTER TABLE `user`
ADD PRIMARY KEY (`id_user`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `absen_karyawan`
--
ALTER TABLE `absen_karyawan`
MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=559;
--
-- AUTO_INCREMENT for table `detail_karyawan`
--
ALTER TABLE `detail_karyawan`
MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `kehadiran_karyawan`
--
ALTER TABLE `kehadiran_karyawan`
MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `rekap_absen`
--
ALTER TABLE `rekap_absen`
MODIFY `no` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=119;
--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
MODIFY `id_user` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;
/*!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 */;