-
Notifications
You must be signed in to change notification settings - Fork 2
/
gasoline_station.sql
2919 lines (2857 loc) · 195 KB
/
gasoline_station.sql
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
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: May 31, 2019 at 01:00 PM
-- Server version: 5.6.17
-- PHP Version: 5.5.12
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;
--
-- Database: `gasoline_station`
--
DELIMITER $$
--
-- Procedures
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `select_counter`()
BEGIN
DECLARE cnt INT;
SELECT COUNT(dispID) INTO cnt FROM dispanser;
SELECT * FROM counter LIMIT cnt;
END$$
DELIMITER ;
-- --------------------------------------------------------
--
-- Table structure for table `container`
--
CREATE TABLE IF NOT EXISTS `container` (
`contID` int(3) NOT NULL AUTO_INCREMENT,
`name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`capacity` int(11) NOT NULL,
`type` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
`current_quan_liter` int(11) NOT NULL,
`style` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`cost_liter` int(11) NOT NULL DEFAULT '0',
`price_liter` int(6) DEFAULT NULL,
PRIMARY KEY (`contID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;
--
-- Dumping data for table `container`
--
INSERT INTO `container` (`contID`, `name`, `capacity`, `type`, `current_quan_liter`, `style`, `cost_liter`, `price_liter`) VALUES
(6, 'A 95', 17000, '95', -4, 'middle-1-to-left', 22, 66),
(7, 'B 95', 20000, '95', 3, 'middle-2-to-left', 22, 66),
(8, 'Benzene 98', 17000, '98', 13000, 'middle-3-to-left', 1055, 1155),
(9, 'C Red', 15000, 'Diesel G', 5, 'bottom-1-to-right', 22, 11),
(10, 'C Green', 15000, 'Diesel G', 6, 'bottom-left', 22, 11);
-- --------------------------------------------------------
--
-- Table structure for table `counter`
--
CREATE TABLE IF NOT EXISTS `counter` (
`counterID` int(6) NOT NULL AUTO_INCREMENT,
`dispID` int(3) NOT NULL,
`counter_1` int(11) NOT NULL,
`counter_2` int(11) NOT NULL,
`shiftID` int(3) NOT NULL,
`record_date_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`counter_1_quan` int(7) NOT NULL DEFAULT '0',
`counter_2_quan` int(7) NOT NULL DEFAULT '0',
KEY `counterID` (`counterID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=297 ;
--
-- Dumping data for table `counter`
--
INSERT INTO `counter` (`counterID`, `dispID`, `counter_1`, `counter_2`, `shiftID`, `record_date_time`, `counter_1_quan`, `counter_2_quan`) VALUES
(1, 4, 349602, 77678, 130, '2018-12-07 10:31:35', 305, 0),
(2, 5, 551614, 32947, 130, '2018-12-07 10:32:02', 715, 108),
(3, 6, 289345, 199017, 130, '2018-12-07 10:32:21', 26, 912),
(4, 4, 351325, 77678, 131, '2018-12-09 09:24:57', 190, 0),
(5, 5, 554478, 33367, 131, '2018-12-09 09:25:47', 528, 10),
(6, 6, 289345, 202529, 131, '2018-12-09 09:26:56', 0, 593),
(7, 6, 289345, 202803, 133, '2018-12-10 07:07:41', 0, 274),
(8, 4, 351927, 77678, 133, '2018-12-10 09:31:26', 602, 0),
(9, 5, 555835, 33591, 133, '2018-12-10 09:32:00', 1357, 224),
(10, 6, 290264, 202803, 133, '2018-12-10 09:32:45', 919, 0),
(11, 4, 352463, 77678, 134, '2018-12-11 02:29:50', 536, 0),
(12, 5, 556082, 33691, 134, '2018-12-11 02:30:12', 247, 100),
(13, 6, 291190, 202803, 134, '2018-12-11 02:30:37', 926, 0),
(14, 4, 355974, 77678, 137, '2018-12-16 18:55:36', 3511, 0),
(15, 5, 561513, 35021, 137, '2018-12-16 18:56:10', 5431, 1330),
(16, 6, 297014, 202803, 137, '2018-12-16 18:56:32', 5824, 0),
(17, 4, 356253, 77678, 138, '2018-12-16 19:06:00', 279, 0),
(18, 5, 561513, 35138, 138, '2018-12-16 19:09:16', 801, 117),
(19, 6, 298258, 202803, 138, '2018-12-16 19:09:34', 1244, 0),
(20, 4, 356473, 77678, 139, '2018-12-16 19:33:59', 220, 0),
(21, 5, 562023, 35263, 139, '2018-12-16 19:34:22', 510, 125),
(22, 6, 298908, 202803, 139, '2018-12-16 19:34:45', 650, 0),
(23, 4, 357697, 77678, 140, '2018-12-17 19:46:42', 1224, 0),
(24, 5, 562023, 36166, 140, '2018-12-17 19:47:05', 0, 903),
(25, 6, 300756, 202803, 140, '2018-12-17 19:47:35', 1848, 0),
(26, 4, 358124, 776678, 141, '2018-12-18 12:23:54', 427, 699000),
(27, 5, 562023, 36612, 141, '2018-12-18 12:24:20', 0, 446),
(28, 6, 301136, 202803, 141, '2018-12-18 12:24:44', 380, 0),
(29, 4, 358124, 77678, 141, '2018-12-18 12:43:17', 0, 0),
(30, 4, 358748, 77678, 142, '2018-12-18 19:44:33', 624, 0),
(31, 5, 562023, 36975, 142, '2018-12-18 19:45:04', 0, 363),
(32, 6, 301791, 202803, 142, '2018-12-18 19:45:31', 655, 0),
(33, 4, 359257, 77678, 143, '2018-12-19 18:32:32', 509, 0),
(34, 5, 563048, 37323, 143, '2018-12-19 18:32:56', 1025, 348),
(35, 6, 303261, 202803, 143, '2018-12-19 18:33:14', 1470, 0),
(36, 4, 361555, 77877, 144, '2018-12-24 13:28:54', 102, 199),
(37, 4, 362296, 77678, 144, '2018-12-24 19:28:37', 843, 0),
(38, 5, 569682, 38845, 144, '2018-12-24 19:28:57', 1169, 75),
(39, 6, 311272, 202803, 144, '2018-12-24 19:29:12', 1695, 0),
(40, 4, 362848, 77678, 145, '2018-12-25 13:07:44', 552, 0),
(41, 5, 570020, 38884, 145, '2018-12-25 13:08:27', 338, 39),
(42, 6, 311910, 202803, 145, '2018-12-25 13:08:49', 638, 0),
(43, 4, 363239, 77678, 146, '2018-12-25 19:48:53', 391, 0),
(44, 5, 570663, 39085, 146, '2018-12-25 19:49:31', 643, 201),
(45, 6, 312847, 202803, 146, '2018-12-25 19:49:58', 937, 0),
(46, 4, 364261, 77678, 147, '2018-12-27 11:31:50', 1022, 0),
(47, 5, 571366, 39303, 147, '2018-12-27 11:33:33', 703, 218),
(48, 6, 314686, 202803, 147, '2018-12-27 11:34:05', 1839, 0),
(49, 4, 365520, 77678, 148, '2018-12-27 18:21:30', 1259, 0),
(50, 5, 571366, 39604, 148, '2018-12-27 18:21:47', 0, 301),
(51, 6, 316390, 202803, 148, '2018-12-27 18:22:01', 1704, 0),
(52, 4, 365672, 77678, 149, '2018-12-27 19:44:47', 152, 0),
(53, 5, 571529, 39670, 149, '2018-12-27 19:45:45', 163, 66),
(54, 6, 316862, 202803, 149, '2018-12-27 19:46:17', 472, 0),
(55, 4, 366093, 77678, 150, '2018-12-28 19:38:53', 421, 0),
(56, 5, 572896, 39841, 150, '2018-12-28 19:39:12', 1367, 171),
(57, 6, 319069, 202803, 150, '2018-12-28 19:39:29', 2207, 0),
(58, 4, 366619, 77678, 151, '2018-12-29 19:19:08', 526, 0),
(59, 5, 573997, 40067, 151, '2018-12-29 19:19:23', 1101, 226),
(60, 6, 321043, 202803, 151, '2018-12-29 19:19:53', 1974, 0),
(61, 4, 367408, 77678, 152, '2018-12-30 19:27:13', 789, 0),
(62, 5, 575370, 40425, 152, '2018-12-30 19:27:38', 1373, 358),
(63, 6, 322459, 202803, 152, '2018-12-30 19:27:55', 1416, 0),
(64, 4, 368091, 77678, 153, '2018-12-31 19:35:57', 683, 0),
(65, 5, 576510, 40750, 153, '2018-12-31 19:36:25', 1140, 325),
(66, 6, 323886, 202803, 153, '2018-12-31 19:36:44', 1427, 0),
(67, 6, 325132, 202803, 154, '2019-01-01 19:35:10', 1246, 0),
(68, 5, 577506, 40924, 154, '2019-01-01 19:35:29', 996, 174),
(69, 4, 368691, 77678, 154, '2019-01-01 19:35:51', 600, 0),
(70, 4, 368699, 77699, 155, '2019-01-02 13:22:23', 8, 21),
(71, 4, 369272, 77678, 155, '2019-01-02 19:25:07', 581, 0),
(72, 5, 578961, 41156, 155, '2019-01-02 19:25:29', 1455, 232),
(73, 6, 326616, 202803, 155, '2019-01-02 19:25:55', 1484, 0),
(74, 4, 369482, 77678, 156, '2019-01-03 13:45:00', 210, 0),
(75, 5, 579587, 41293, 156, '2019-01-03 13:45:21', 626, 137),
(76, 6, 327816, 202803, 156, '2019-01-03 13:46:47', 1200, 0),
(77, 4, 369655, 77678, 157, '2019-01-03 19:18:42', 173, 0),
(78, 5, 580250, 41415, 157, '2019-01-03 19:19:12', 663, 122),
(79, 6, 329096, 202803, 157, '2019-01-03 19:19:41', 1280, 0),
(80, 4, 370266, 77678, 158, '2019-01-04 19:21:58', 611, 0),
(81, 5, 581473, 41488, 158, '2019-01-04 19:24:40', 1223, 73),
(82, 6, 330532, 202803, 158, '2019-01-04 19:25:19', 1436, 0),
(83, 4, 370871, 77678, 159, '2019-01-05 19:39:26', 605, 0),
(84, 5, 582844, 41674, 159, '2019-01-05 19:41:54', 1371, 186),
(85, 6, 332774, 202803, 159, '2019-01-05 19:42:17', 2242, 0),
(86, 4, 371359, 77678, 160, '2019-01-06 16:21:08', 488, 0),
(87, 5, 583915, 41797, 160, '2019-01-06 16:22:07', 1071, 123),
(88, 6, 334831, 202803, 160, '2019-01-06 16:22:47', 2057, 0),
(89, 4, 371421, 77678, 161, '2019-01-06 19:17:48', 62, 0),
(90, 5, 584274, 41806, 161, '2019-01-06 19:18:23', 359, 9),
(91, 6, 335540, 202803, 161, '2019-01-06 19:18:57', 709, 0),
(92, 4, 372400, 77678, 162, '2019-01-07 19:24:17', 979, 0),
(93, 5, 584274, 42297, 162, '2019-01-07 19:24:50', 0, 491),
(94, 6, 337629, 202803, 162, '2019-01-07 19:25:44', 2089, 0),
(95, 4, 373013, 77678, 163, '2019-01-08 13:10:50', 613, 0),
(96, 5, 584274, 42618, 163, '2019-01-08 13:11:10', 0, 321),
(97, 6, 338711, 202803, 163, '2019-01-08 13:11:38', 1082, 0),
(98, 4, 373520, 77678, 164, '2019-01-08 19:57:55', 507, 0),
(99, 5, 584274, 42989, 164, '2019-01-08 19:58:20', 0, 371),
(100, 6, 339791, 202803, 164, '2019-01-08 19:58:43', 1080, 0),
(101, 4, 374079, 77678, 165, '2019-01-09 12:43:20', 559, 0),
(102, 5, 584276, 43147, 165, '2019-01-09 12:44:02', 2, 158),
(103, 6, 340614, 202803, 165, '2019-01-09 12:44:27', 823, 0),
(104, 4, 374704, 77678, 166, '2019-01-09 19:01:15', 625, 0),
(105, 5, 584276, 43487, 166, '2019-01-09 19:01:44', 0, 340),
(106, 6, 341762, 202803, 166, '2019-01-09 19:02:06', 1148, 0),
(107, 4, 375135, 77678, 167, '2019-01-10 18:15:13', 431, 0),
(108, 5, 585016, 43829, 167, '2019-01-10 18:15:38', 740, 342),
(109, 6, 343014, 202803, 167, '2019-01-10 18:16:20', 1252, 0),
(110, 4, 375135, 77678, 168, '2019-01-11 13:51:28', 0, 0),
(111, 5, 585929, 44233, 168, '2019-01-11 13:51:53', 913, 404),
(112, 6, 343903, 202803, 168, '2019-01-11 13:52:17', 889, 0),
(113, 4, 375350, 77678, 169, '2019-01-11 20:04:53', 215, 0),
(114, 5, 586628, 44357, 169, '2019-01-11 20:05:14', 699, 124),
(115, 6, 344882, 202803, 169, '2019-01-11 20:05:31', 979, 0),
(116, 4, 375632, 77678, 170, '2019-01-12 14:55:53', 282, 0),
(117, 5, 587177, 44433, 170, '2019-01-12 14:56:09', 549, 76),
(118, 6, 345456, 202803, 170, '2019-01-12 14:56:31', 574, 0),
(119, 4, 376074, 77678, 171, '2019-01-12 19:39:24', 442, 0),
(120, 5, 588093, 44650, 171, '2019-01-12 19:40:12', 916, 217),
(121, 6, 346922, 202803, 171, '2019-01-12 19:40:37', 1466, 0),
(122, 6, 347315, 202803, 172, '2019-01-13 15:01:56', 393, 0),
(123, 4, 376502, 77678, 172, '2019-01-13 15:14:39', 428, 0),
(124, 5, 589540, 44714, 172, '2019-01-13 15:15:04', 1447, 64),
(125, 4, 376809, 77678, 173, '2019-01-13 19:17:38', 307, 0),
(126, 5, 589944, 44803, 173, '2019-01-13 19:17:55', 404, 89),
(127, 4, 377606, 77678, 174, '2019-01-14 19:49:14', 797, 0),
(128, 5, 590809, 44978, 174, '2019-01-14 19:49:34', 865, 175),
(129, 6, 350249, 202803, 174, '2019-01-14 19:49:57', 2934, 0),
(130, 4, 377840, 77678, 175, '2019-01-15 13:07:09', 234, 0),
(131, 5, 591056, 45078, 175, '2019-01-15 13:07:46', 247, 100),
(132, 6, 351167, 202803, 175, '2019-01-15 13:08:05', 918, 0),
(133, 4, 378365, 77678, 176, '2019-01-15 19:38:17', 525, 0),
(134, 5, 591686, 45262, 176, '2019-01-15 19:38:45', 630, 184),
(135, 6, 352035, 202803, 176, '2019-01-15 19:39:47', 868, 0),
(136, 4, 378752, 77678, 177, '2019-01-16 12:49:10', 387, 0),
(137, 5, 592031, 45353, 177, '2019-01-16 12:49:29', 345, 91),
(138, 6, 353016, 202803, 177, '2019-01-16 12:49:46', 981, 0),
(139, 4, 379397, 77678, 178, '2019-01-16 19:56:46', 645, 0),
(140, 5, 592031, 45748, 178, '2019-01-16 19:57:05', 0, 395),
(141, 6, 354275, 202803, 178, '2019-01-16 19:57:30', 1259, 0),
(142, 4, 380490, 77678, 179, '2019-01-17 19:21:50', 1093, 0),
(143, 5, 592031, 46493, 179, '2019-01-17 19:22:14', 0, 745),
(144, 6, 355893, 202803, 179, '2019-01-17 19:23:14', 1618, 0),
(145, 4, 381165, 77678, 180, '2019-01-18 19:02:06', 675, 0),
(146, 5, 593201, 46798, 180, '2019-01-18 19:02:29', 1170, 305),
(147, 6, 357126, 202803, 180, '2019-01-18 19:02:54', 1233, 0),
(148, 4, 381759, 77678, 181, '2019-01-19 19:16:11', 594, 0),
(149, 5, 594580, 47153, 181, '2019-01-19 19:16:30', 1379, 355),
(150, 6, 358943, 202803, 181, '2019-01-19 19:16:47', 1817, 0),
(151, 4, 382327, 77678, 182, '2019-01-20 15:42:46', 568, 0),
(152, 5, 595922, 47339, 182, '2019-01-20 15:43:16', 1342, 186),
(153, 6, 360022, 202803, 182, '2019-01-20 15:44:26', 1079, 0),
(154, 4, 382585, 77678, 183, '2019-01-20 19:22:53', 258, 0),
(155, 5, 596421, 47435, 183, '2019-01-20 19:23:14', 499, 96),
(156, 6, 361267, 202803, 183, '2019-01-20 19:23:47', 1245, 0),
(157, 4, 383488, 77678, 184, '2019-01-21 19:20:21', 903, 0),
(158, 5, 597624, 47723, 184, '2019-01-21 19:20:40', 1203, 288),
(159, 6, 362051, 202803, 184, '2019-01-21 19:21:02', 784, 0),
(160, 4, 383787, 77678, 185, '2019-01-22 12:39:25', 299, 0),
(161, 5, 598150, 47794, 185, '2019-01-22 12:39:43', 526, 71),
(162, 4, 384117, 77678, 186, '2019-01-22 19:59:58', 330, 0),
(163, 5, 598807, 47869, 186, '2019-01-22 20:00:30', 657, 75),
(164, 6, 362051, 203828, 186, '2019-01-22 20:00:57', 0, 1025),
(165, 4, 384346, 77678, 187, '2019-01-23 12:38:51', 229, 0),
(166, 5, 599183, 47920, 187, '2019-01-23 12:39:33', 376, 51),
(167, 6, 362051, 204219, 187, '2019-01-23 12:39:55', 0, 391),
(168, 4, 384643, 77678, 188, '2019-01-23 19:40:59', 297, 0),
(169, 5, 599937, 48045, 188, '2019-01-23 19:41:27', 754, 125),
(170, 6, 362051, 204940, 188, '2019-01-23 19:41:54', 0, 721),
(171, 4, 385258, 77678, 189, '2019-01-24 19:34:51', 615, 0),
(172, 5, 601169, 48282, 189, '2019-01-24 19:35:40', 1232, 237),
(173, 6, 362051, 206737, 189, '2019-01-24 19:37:40', 0, 1797),
(174, 4, 385525, 77678, 190, '2019-01-25 13:39:24', 267, 0),
(175, 5, 601823, 48359, 190, '2019-01-25 13:39:53', 654, 77),
(176, 6, 362051, 207554, 190, '2019-01-25 13:40:21', 0, 817),
(177, 4, 385847, 77678, 191, '2019-01-25 19:18:04', 322, 0),
(178, 5, 602373, 48473, 191, '2019-01-25 19:18:21', 550, 114),
(179, 6, 362051, 208128, 191, '2019-01-25 19:18:40', 0, 574),
(180, 4, 386159, 77678, 192, '2019-01-26 12:35:32', 312, 0),
(181, 5, 602862, 48496, 192, '2019-01-26 12:35:50', 489, 23),
(182, 6, 362051, 208451, 192, '2019-01-26 12:36:20', 0, 323),
(183, 4, 386444, 77678, 193, '2019-01-26 18:56:08', 285, 0),
(184, 5, 603631, 48640, 193, '2019-01-26 18:56:38', 769, 144),
(185, 6, 362051, 209579, 193, '2019-01-26 18:57:12', 0, 1128),
(186, 4, 386914, 77678, 194, '2019-01-27 15:25:49', 470, 0),
(187, 5, 604501, 48948, 194, '2019-01-27 15:27:10', 870, 308),
(188, 6, 362051, 210813, 194, '2019-01-27 15:27:37', 0, 1234),
(189, 4, 387169, 77678, 195, '2019-01-27 19:12:20', 255, 0),
(190, 5, 605179, 49080, 195, '2019-01-27 19:12:38', 678, 132),
(191, 6, 362051, 211408, 195, '2019-01-27 19:12:57', 0, 595),
(192, 4, 387654, 77678, 196, '2019-01-28 19:02:04', 485, 0),
(193, 5, 606490, 49495, 196, '2019-01-28 19:02:21', 1311, 415),
(194, 6, 362051, 213600, 196, '2019-01-28 19:02:44', 0, 2192),
(195, 4, 387786, 77678, 197, '2019-01-29 12:26:32', 132, 0),
(196, 5, 606917, 49633, 197, '2019-01-29 12:26:53', 427, 138),
(197, 6, 362051, 214269, 197, '2019-01-29 12:27:19', 0, 669),
(198, 4, 388188, 77678, 198, '2019-01-29 19:38:29', 402, 0),
(199, 5, 607923, 49744, 198, '2019-01-29 19:38:54', 1006, 111),
(200, 6, 362051, 215220, 198, '2019-01-29 19:39:18', 0, 951),
(201, 4, 388415, 77678, 199, '2019-01-30 11:36:54', 227, 0),
(202, 5, 608306, 49815, 199, '2019-01-30 11:39:02', 383, 71),
(203, 6, 362051, 215490, 199, '2019-01-30 11:39:18', 0, 270),
(204, 4, 388775, 77678, 200, '2019-01-30 18:59:38', 360, 0),
(205, 5, 608854, 49953, 200, '2019-01-30 19:00:40', 548, 138),
(206, 6, 362051, 216355, 200, '2019-01-30 19:01:50', 0, 865),
(207, 5, 609910, 50171, 201, '2019-01-31 19:10:18', 1056, 218),
(208, 4, 389414, 77678, 201, '2019-01-31 19:10:59', 639, 0),
(209, 6, 362051, 217533, 201, '2019-01-31 19:11:20', 0, 1178),
(210, 4, 389584, 77678, 202, '2019-02-01 12:49:52', 170, 0),
(211, 5, 610612, 50341, 202, '2019-02-01 12:50:18', 702, 170),
(212, 6, 362051, 218093, 202, '2019-02-01 12:50:52', 0, 560),
(213, 4, 389885, 77678, 203, '2019-02-01 19:33:30', 301, 0),
(214, 5, 611296, 50466, 203, '2019-02-01 19:33:53', 684, 125),
(215, 6, 362051, 218961, 203, '2019-02-01 19:34:10', 0, 868),
(216, 4, 390237, 77678, 204, '2019-02-02 12:00:47', 352, 0),
(217, 5, 611925, 50496, 204, '2019-02-02 12:01:09', 629, 30),
(218, 6, 362051, 219805, 204, '2019-02-02 12:04:01', 0, 844),
(219, 4, 390779, 77678, 205, '2019-02-02 18:56:20', 542, 0),
(220, 5, 612867, 50773, 205, '2019-02-02 18:56:45', 942, 277),
(221, 6, 362051, 220932, 205, '2019-02-02 18:57:34', 0, 1127),
(222, 4, 391212, 77678, 206, '2019-02-03 13:40:35', 433, 0),
(223, 5, 613875, 50867, 206, '2019-02-03 13:41:00', 1008, 94),
(224, 6, 362051, 221590, 206, '2019-02-03 13:41:40', 0, 658),
(225, 4, 391717, 77678, 207, '2019-02-03 19:13:28', 505, 0),
(226, 5, 614970, 51026, 207, '2019-02-03 19:13:44', 1095, 159),
(227, 6, 362051, 222542, 207, '2019-02-03 19:14:01', 0, 952),
(228, 4, 392267, 77678, 208, '2019-02-04 19:14:39', 550, 0),
(229, 5, 616312, 51291, 208, '2019-02-04 19:15:07', 1342, 265),
(230, 6, 362051, 224414, 208, '2019-02-04 19:15:27', 0, 1872),
(231, 4, 393171, 77678, 209, '2019-02-05 16:43:20', 904, 0),
(232, 5, 617285, 51377, 209, '2019-02-05 16:43:40', 973, 86),
(233, 6, 362051, 225581, 209, '2019-02-05 16:43:59', 0, 1167),
(234, 4, 393379, 77678, 210, '2019-02-05 19:48:06', 208, 0),
(235, 5, 617738, 51390, 210, '2019-02-05 19:48:38', 453, 13),
(236, 6, 362051, 226049, 210, '2019-02-05 19:50:07', 0, 468),
(237, 4, 394479, 77777, 211, '2019-02-06 14:08:07', 1100, 99),
(238, 4, 393975, 77678, 211, '2019-02-06 19:09:08', 596, 0),
(239, 5, 619165, 51533, 211, '2019-02-06 19:09:37', 1427, 143),
(240, 6, 362051, 227406, 211, '2019-02-06 19:10:11', 0, 1357),
(241, 4, 393975, 77678, 211, '2019-02-06 19:14:56', 596, 0),
(242, 5, 619165, 51533, 211, '2019-02-06 19:15:23', 1427, 143),
(243, 6, 362051, 227406, 211, '2019-02-06 19:15:42', 0, 1357),
(244, 4, 394429, 77678, 212, '2019-02-07 19:11:38', 454, 0),
(245, 5, 620377, 51784, 212, '2019-02-07 19:12:01', 1212, 251),
(246, 6, 362051, 228349, 212, '2019-02-07 19:12:20', 0, 943),
(247, 4, 394683, 77678, 213, '2019-02-08 12:33:27', 254, 0),
(248, 5, 621004, 51963, 213, '2019-02-08 12:33:55', 627, 179),
(249, 6, 362051, 228693, 213, '2019-02-08 12:34:15', 0, 344),
(250, 4, 394918, 77678, 214, '2019-02-08 18:58:02', 235, 0),
(251, 5, 621608, 52220, 214, '2019-02-08 18:59:07', 604, 257),
(252, 6, 362051, 229277, 214, '2019-02-08 18:59:35', 0, 584),
(253, 4, 395271, 77678, 215, '2019-02-09 12:31:33', 353, 0),
(254, 5, 622101, 52365, 215, '2019-02-09 12:31:49', 493, 145),
(255, 6, 362051, 230054, 215, '2019-02-09 12:32:16', 0, 777),
(256, 4, 395618, 77678, 216, '2019-02-09 19:03:57', 347, 0),
(257, 5, 622809, 52618, 216, '2019-02-09 19:04:18', 708, 253),
(258, 6, 362051, 231012, 216, '2019-02-09 19:04:41', 0, 958),
(259, 4, 396131, 77678, 217, '2019-02-10 15:18:45', 513, 0),
(260, 5, 623704, 52940, 217, '2019-02-10 15:19:04', 895, 322),
(261, 6, 362051, 232065, 217, '2019-02-10 15:19:21', 0, 1053),
(262, 4, 396462, 77678, 218, '2019-02-10 19:03:04', 331, 0),
(263, 5, 624018, 53233, 218, '2019-02-10 19:03:33', 314, 293),
(264, 6, 362051, 232685, 218, '2019-02-10 19:03:50', 0, 620),
(265, 4, 397027, 77678, 219, '2019-02-11 19:14:02', 565, 0),
(266, 5, 625186, 53478, 219, '2019-02-11 19:14:19', 1168, 245),
(267, 6, 362051, 234681, 219, '2019-02-11 19:14:44', 0, 1996),
(268, 4, 397314, 77678, 220, '2019-02-12 12:31:48', 287, 0),
(269, 5, 625591, 53527, 220, '2019-02-12 12:32:14', 405, 49),
(270, 6, 362051, 235444, 220, '2019-02-12 12:32:35', 0, 763),
(271, 4, 397858, 77678, 221, '2019-02-12 19:36:43', 544, 0),
(272, 5, 626253, 53632, 221, '2019-02-12 19:37:16', 662, 105),
(273, 6, 362051, 236549, 221, '2019-02-12 19:37:40', 0, 1105),
(274, 4, 398414, 77678, 222, '2019-02-13 19:17:03', 556, 0),
(275, 4, 398414, 77678, 222, '2019-02-13 19:25:15', 556, 0),
(276, 5, 627350, 53762, 222, '2019-02-13 19:25:42', 1097, 130),
(277, 6, 362051, 238056, 222, '2019-02-13 19:26:02', 0, 1507),
(278, 4, 398765, 77678, 223, '2019-02-14 19:00:48', 351, 0),
(279, 5, 628369, 53878, 223, '2019-02-14 19:01:20', 1019, 116),
(280, 6, 362051, 239941, 223, '2019-02-14 19:01:41', 0, 1885),
(281, 4, 399431, 77678, 224, '2019-02-15 18:58:40', 666, 0),
(282, 5, 629229, 54099, 224, '2019-02-15 18:59:01', 860, 221),
(283, 6, 362198, 241906, 224, '2019-02-15 18:59:22', 147, 1965),
(284, 4, 399433, 77678, 229, '2019-02-20 03:42:34', 2, 0),
(285, 4, 399444, 77777, 229, '2019-02-20 03:50:42', 11, 99),
(286, 4, 399555, 77878, 229, '2019-02-20 03:55:45', 111, 101),
(287, 6, 362199, 241999, 229, '2019-02-20 03:58:50', 1, 93),
(288, 4, 3995454, 778777, 228, '2019-02-25 11:17:08', 3595899, 700899),
(289, 4, 399590, 778799, 228, '2019-02-26 13:30:20', 35, 22),
(290, 4, 399590, 778799, 228, '2019-02-26 13:30:37', 35, 22),
(291, 4, 399599, 778899, 231, '2019-02-26 13:35:28', 9, 100),
(292, 4, 399590, 778799, 228, '2019-02-26 13:36:45', 35, 22),
(293, 4, 399601, 778799, 236, '2019-03-15 16:52:16', 11, 0),
(294, 4, 399690, 778800, 242, '2019-04-06 20:10:27', 100, 1),
(295, 4, 399710, 778810, 249, '2019-04-21 18:12:18', 20, 10),
(296, 4, 399715, 778810, 250, '2019-05-07 23:31:09', 5, 0);
-- --------------------------------------------------------
--
-- Table structure for table `dispanser`
--
CREATE TABLE IF NOT EXISTS `dispanser` (
`dispID` int(3) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf32 COLLATE utf32_unicode_ci NOT NULL,
`outputContID_1` int(3) NOT NULL,
`outputContID_2` int(3) NOT NULL,
`dispStyle` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`counter_1` int(11) DEFAULT NULL,
`counter_2` int(11) DEFAULT NULL,
PRIMARY KEY (`dispID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;
--
-- Dumping data for table `dispanser`
--
INSERT INTO `dispanser` (`dispID`, `name`, `outputContID_1`, `outputContID_2`, `dispStyle`, `counter_1`, `counter_2`) VALUES
(4, 'A', 6, 8, 'middle-1-to-right', 399715, 778810),
(5, 'B', 7, 8, 'middle-1-to-left', 629229, 54099),
(6, 'Diesel', 9, 10, 'bottom-left', 362199, 241999);
-- --------------------------------------------------------
--
-- Table structure for table `drawer`
--
CREATE TABLE IF NOT EXISTS `drawer` (
`drawerID` int(11) NOT NULL AUTO_INCREMENT,
`shiftID` int(11) NOT NULL,
`date` date NOT NULL,
`amount` int(11) NOT NULL,
`totalProfit` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`drawerID`),
KEY `shiftID` (`shiftID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=134 ;
--
-- Dumping data for table `drawer`
--
INSERT INTO `drawer` (`drawerID`, `shiftID`, `date`, `amount`, `totalProfit`) VALUES
(22, 131, '2018-12-09', 1562320, 0),
(24, 133, '2018-12-10', 3257740, 0),
(25, 134, '2018-12-11', 1575040, 0),
(26, 136, '2018-12-16', 0, 0),
(27, 137, '2018-12-16', 17299740, 1180046),
(28, 138, '2018-12-16', 2236600, 173009),
(29, 139, '2018-12-16', 1742100, 113465),
(30, 140, '2018-12-17', 3735880, 280183),
(31, 141, '2018-12-18', 1346790, 98808),
(32, 142, '2018-12-18', 1755180, 119813),
(33, 143, '2018-12-19', 3186620, -244372),
(34, 144, '2018-12-24', 3764415, -284704),
(35, 145, '2018-12-25', 1478940, -74667),
(36, 146, '2018-12-25', 2212615, -149336),
(37, 147, '2018-12-27', 3678175, 276340),
(38, 148, '2018-12-27', 2795390, 210816),
(39, 149, '2018-12-27', 890085, 75386),
(40, 150, '2018-12-28', 3581885, 273920),
(41, 151, '2018-12-29', 4035565, 251310),
(42, 152, '2018-12-30', 4114180, 333804),
(43, 153, '2018-12-31', 3629930, 272522),
(44, 154, '2019-01-01', 2778110, 274324),
(45, 155, '2019-01-02', 3637560, 297248),
(46, 156, '2019-01-03', 2046275, 133018),
(47, 157, '2019-01-03', 2074450, 138748),
(48, 158, '2019-01-04', 3547765, 255532),
(49, 159, '2019-01-05', 4021820, 335386),
(50, 160, '2019-01-06', 3471755, 243658),
(51, 161, '2019-01-06', 1063255, 72616),
(52, 162, '2019-01-07', 3343615, 218218),
(53, 163, '2019-01-08', 1579530, 126625),
(54, 164, '2019-01-08', 1927520, 124857),
(55, 165, '2019-01-09', 1338735, 71938),
(56, 166, '2019-01-09', 1876710, 104042),
(57, 167, '2019-01-10', 2662770, 205868),
(58, 168, '2019-01-11', 2172405, 183419),
(59, 169, '2019-01-11', 1893445, 140771),
(60, 170, '2019-01-12', 1380240, 109081),
(61, 171, '2019-01-12', 2668730, 217497),
(62, 172, '2019-01-13', 1360865, 222401),
(63, 173, '2019-01-13', 879670, 80207),
(64, 174, '2019-01-14', 4404110, 279140),
(65, 175, '2019-01-15', 1394100, 103849),
(66, 176, '2019-01-15', 2183090, 157316),
(67, 177, '2019-01-16', 1619580, 110459),
(68, 178, '2019-01-17', 2162155, 136613),
(69, 179, '2019-01-17', 3205890, 263781),
(70, 180, '2019-01-18', 3241135, 287884),
(71, 181, '2019-01-19', 3411045, 349133),
(72, 182, '2019-01-20', 3099545, 303775),
(73, 183, '2019-01-20', 1895160, 128209),
(74, 184, '2019-01-21', 3293410, 364977),
(75, 185, '2019-01-22', 1007290, 97075),
(76, 186, '2019-01-22', 1913395, 150386),
(77, 187, '2019-01-23', 1002135, 85479),
(78, 188, '2019-01-23', 1812480, 157291),
(79, 189, '2019-01-24', 3811660, 302595),
(80, 190, '2019-01-25', 1649890, 135367),
(81, 191, '2019-01-25', 1530030, 178034),
(82, 192, '2019-01-26', 1126600, 112909),
(83, 193, '2019-01-26', 2264810, 181472),
(84, 194, '2019-01-27', 2804340, 233734),
(85, 195, '2019-01-27', 1702085, 161937),
(86, 196, '2019-01-28', 4174015, 301104),
(87, 197, '2019-01-29', 1315245, 113071),
(88, 198, '2019-01-29', 2246945, 192282),
(89, 199, '2019-01-30', 1009490, 103067),
(90, 200, '2019-01-30', 1917475, 169650),
(91, 201, '2019-01-31', 2897600, 236452),
(92, 202, '2019-02-01', 1462320, 126166),
(93, 203, '2019-02-01', 1927630, 158899),
(94, 204, '2019-02-02', 1572850, 138900),
(95, 205, '2019-02-02', 3036065, 258292),
(96, 206, '2019-02-03', 2328100, 201750),
(97, 207, '2019-02-03', 2797180, 239839),
(98, 208, '2019-02-04', 3926340, 300097),
(99, 209, '2019-02-05', 3118955, 239122),
(100, 210, '2019-02-05', 1119310, 80822),
(101, 211, '2019-02-06', 3432445, 297720),
(102, 212, '2019-02-07', 2333835, 270218),
(103, 213, '2019-02-08', 1375690, 124000),
(104, 214, '2019-02-08', 1799550, 156360),
(105, 215, '2019-02-09', 1517605, 150910),
(106, 216, '2019-02-09', 2208640, 175014),
(107, 217, '2019-02-10', 2936575, 239951),
(108, 218, '2019-02-10', 1659450, 123206),
(109, 219, '2019-02-11', 2969290, 288101),
(110, 220, '2019-02-12', 1219755, 109685),
(111, 221, '2019-02-12', 2453245, 198903),
(112, 222, '2019-02-13', 3332330, 255317),
(113, 223, '2019-02-14', 3254755, 223310),
(114, 224, '2019-02-15', 3621885, 266962),
(115, 226, '2019-02-16', 0, 0),
(116, 227, '2019-02-19', -1000, 0),
(117, 229, '2019-02-20', 533810, 130504),
(118, 230, '2019-02-24', 3000, 57600),
(119, 228, '2019-03-06', 809765700, 70133925),
(120, 236, '2019-03-15', 14000, 13200),
(121, 234, '2019-03-28', 12000, 7300),
(122, 237, '2019-03-28', 1000, 0),
(123, 232, '2019-03-30', 53000, 19300),
(124, 239, '2019-03-31', 0, 0),
(125, 235, '2019-04-06', 0, 0),
(126, 240, '2019-04-06', 6000, 6000),
(127, 241, '2019-04-06', 54900, 28500),
(128, 242, '2019-04-06', 7755, 4500),
(129, 243, '2019-04-14', 1000, 0),
(130, 244, '2019-04-14', 90000, 0),
(131, 245, '2019-04-21', 0, 0),
(132, 246, '2019-04-21', 0, 0),
(133, 249, '2019-05-07', 12870, 1880);
-- --------------------------------------------------------
--
-- Table structure for table `employee`
--
CREATE TABLE IF NOT EXISTS `employee` (
`empID` int(4) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf32 COLLATE utf32_unicode_ci NOT NULL,
`user_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`passkey` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`user_type` int(2) DEFAULT NULL,
`time-in` time NOT NULL,
`time-out` time NOT NULL,
PRIMARY KEY (`empID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
--
-- Dumping data for table `employee`
--
INSERT INTO `employee` (`empID`, `name`, `user_name`, `passkey`, `user_type`, `time-in`, `time-out`) VALUES
(1, 'Rawad', 'rawad', '123', 1, '00:00:00', '00:00:00'),
(2, 'ali alamin', 'ali', '123', 1, '00:00:00', '00:00:00'),
(3, 'تجريبي', 'test', '123', 0, '00:00:00', '00:00:00');
-- --------------------------------------------------------
--
-- Table structure for table `invoice`
--
CREATE TABLE IF NOT EXISTS `invoice` (
`invID` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`dateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`amount` int(11) NOT NULL,
`rest` int(7) NOT NULL,
`totalProfit` int(11) DEFAULT NULL,
`personID` int(4) DEFAULT NULL,
`note` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`shiftID` int(11) DEFAULT NULL,
`empID` int(3) DEFAULT NULL,
`isSupply` tinyint(1) NOT NULL DEFAULT '0',
`fuel_liters` int(11) DEFAULT NULL,
PRIMARY KEY (`invID`),
KEY `personID` (`personID`),
KEY `empID` (`empID`),
KEY `shiftID` (`shiftID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2239 ;
--
-- Dumping data for table `invoice`
--
INSERT INTO `invoice` (`invID`, `type`, `dateTime`, `amount`, `rest`, `totalProfit`, `personID`, `note`, `shiftID`, `empID`, `isSupply`, `fuel_liters`) VALUES
(507, 'return', '2018-12-09 06:20:00', 4000, 0, NULL, 8, '', 131, 1, 0, NULL),
(508, 'return', '2018-12-09 06:22:00', 193000, 0, NULL, 9, 'صفر', 131, 1, 0, NULL),
(510, 'wash', '2018-12-09 06:24:00', 6000, 0, 6000, 1, 'غسيل : سيارة', 131, 1, 0, NULL),
(511, '95', '2018-12-09 09:24:57', 228000, 0, 18050, NULL, 'counter_1-4', 131, 1, 0, 190),
(512, '98', '2018-12-09 09:24:57', 0, 0, 0, NULL, 'counter_2-4', 131, 1, 0, 0),
(513, '95', '2018-12-09 09:25:47', 633600, 0, 50160, NULL, 'counter_1-5', 131, 1, 0, 528),
(514, '98', '2018-12-09 09:25:47', 12300, 0, 950, NULL, 'counter_2-5', 131, 1, 0, 10),
(515, 'Diesel G', '2018-12-09 09:26:56', 0, 0, 0, NULL, 'counter_1-6', 131, 1, 0, 0),
(516, 'Diesel G', '2018-12-09 09:26:56', 557420, 0, 17790, NULL, 'counter_2-6', 131, 1, 0, 593),
(517, '95_d', '2018-12-09 06:33:00', 72000, 72000, NULL, 10, '', 131, 1, 0, NULL),
(518, 'wash', '2018-12-10 03:27:00', 7000, 0, 7000, 1, 'غسيل : جيب', 133, 1, 0, NULL),
(519, 'wash', '2018-12-10 03:27:00', 7000, 0, 7000, 1, 'غسيل : جيب', 133, 1, 0, NULL),
(520, 'wash', '2018-12-10 03:27:00', 2000, 0, 2000, 1, 'غسيل : موتو', 133, 1, 0, NULL),
(521, 'wash', '2018-12-10 03:27:00', 7000, 0, 7000, 1, 'غسيل : جيب', 133, 1, 0, NULL),
(522, 'lub', '2018-12-10 03:29:00', 3000, 0, 1300, 1, NULL, 133, 1, 0, NULL),
(523, 'lub', '2018-12-10 03:29:00', 3000, 0, 1300, 1, NULL, 133, 1, 0, NULL),
(524, 'payC', '2018-12-10 03:29:00', 90000, 0, NULL, NULL, 'باب الاوكرديون', 133, 1, 0, NULL),
(525, 'payC', '2018-12-10 03:30:00', 17000, 0, NULL, NULL, 'ضيافة', 133, 1, 0, NULL),
(526, 'payC', '2018-12-10 03:31:00', 5000, 0, NULL, NULL, 'اكرامية', 133, 1, 0, NULL),
(527, '95_d', '2018-12-10 03:32:00', 10000, 10000, NULL, 12, 'حسن غرابة', 133, 1, 0, NULL),
(528, 'dieselG_d', '2018-12-10 03:32:00', 16000, 16000, NULL, 13, '', 133, 1, 0, NULL),
(529, 'return', '2018-12-10 03:57:00', 67000, 0, NULL, 14, '', 133, 1, 0, NULL),
(530, 'return', '2018-12-10 03:57:00', 2000, 0, NULL, 15, '', 133, 1, 0, NULL),
(531, 'payC', '2018-12-10 03:57:00', 450000, 0, NULL, NULL, 'علي هاشم الامين برنامج', 133, 1, 0, NULL),
(532, 'Diesel G', '2018-12-10 04:03:00', 3172500, 0, NULL, 11, '9', 133, 1, 1, 3502),
(533, 'Diesel G', '2018-12-10 07:07:41', 0, 0, 0, NULL, 'counter_1-7', 133, 1, 0, 0),
(534, 'Diesel G', '2018-12-10 07:07:41', 257560, 0, 8220, NULL, 'counter_2-7', 133, 1, 0, 274),
(535, 'lub', '2018-12-10 04:52:00', 3000, 0, 1300, 1, NULL, 133, 1, 0, NULL),
(536, 'lub', '2018-12-10 04:53:00', 5000, 0, 2300, 1, NULL, 133, 1, 0, NULL),
(537, '95', '2018-12-10 09:31:26', 722400, 0, 57190, NULL, 'counter_1-8', 133, 1, 0, 602),
(538, '98', '2018-12-10 09:31:26', 0, 0, 0, NULL, 'counter_2-8', 133, 1, 0, 0),
(539, '95', '2018-12-10 09:32:00', 1628400, 0, 128915, NULL, 'counter_1-9', 133, 1, 0, 1357),
(540, '98', '2018-12-10 09:32:00', 275520, 0, 21280, NULL, 'counter_2-9', 133, 1, 0, 224),
(541, 'Diesel G', '2018-12-10 09:32:45', 863860, 0, 31246, NULL, 'counter_1-10', 133, 1, 0, 919),
(542, 'Diesel G', '2018-12-10 09:32:45', 0, 0, 0, NULL, 'counter_2-10', 133, 1, 0, 0),
(543, 'dieselG_d', '2018-12-10 06:41:00', 8000, 8000, NULL, 16, '', 133, 1, 0, NULL),
(545, '95_d', '2018-12-11 07:07:00', 2000, 2000, NULL, 15, '', 134, 1, 0, NULL),
(546, 'lub', '2018-12-11 07:18:00', 10000, 0, 4600, 1, NULL, 134, 1, 0, NULL),
(547, '95_d', '2018-12-11 07:19:00', 20000, 20000, NULL, 17, '', 134, 1, 0, NULL),
(548, 'lub', '2018-12-11 07:19:00', 10000, 10000, 7300, 17, NULL, 134, 1, 0, NULL),
(549, 'lub', '2018-12-11 08:10:00', 3000, 0, 1300, 1, NULL, 134, 1, 0, NULL),
(550, '95_d', '2018-12-11 08:59:00', 10000, 10000, NULL, 17, '', 134, 1, 0, NULL),
(551, 'dieselG_d', '2018-12-11 09:01:00', 350000, 350000, NULL, 9, '', 134, 1, 0, NULL),
(552, 'return', '2018-12-11 09:01:00', 8000, 0, NULL, 16, '', 134, 1, 0, NULL),
(553, 'lub', '2018-12-11 09:28:00', 3000, 0, 1300, 1, NULL, 134, 1, 0, NULL),
(554, 'wash', '2018-12-11 09:52:00', 6000, 0, 6000, 1, 'غسيل : سيارة', 134, 1, 0, NULL),
(555, 'wash', '2018-12-11 10:52:00', 6000, 0, 6000, 1, 'غسيل : سيارة', 134, 1, 0, NULL),
(556, 'lub', '2018-12-11 11:11:00', 18000, 0, 7800, 1, NULL, 134, 1, 0, NULL),
(557, '95', '2018-12-11 02:29:50', 643200, 0, 50920, NULL, 'counter_1-11', 134, 1, 0, 536),
(558, '98', '2018-12-11 02:29:50', 0, 0, 0, NULL, 'counter_2-11', 134, 1, 0, 0),
(559, '95', '2018-12-11 02:30:12', 296400, 0, 23465, NULL, 'counter_1-12', 134, 1, 0, 247),
(560, '98', '2018-12-11 02:30:12', 123000, 0, 9500, NULL, 'counter_2-12', 134, 1, 0, 100),
(561, 'Diesel G', '2018-12-11 02:30:37', 870440, 0, 31484, NULL, 'counter_1-13', 134, 1, 0, 926),
(562, 'Diesel G', '2018-12-11 02:30:37', 0, 0, 0, NULL, 'counter_2-13', 134, 1, 0, 0),
(563, '95_d', '2018-12-11 11:34:00', 30000, 30000, NULL, 5, '', 134, 1, 0, NULL),
(564, '95', '2018-12-16 18:55:36', 4107870, 0, 344078, NULL, 'counter_1-14', 137, 2, 0, 3511),
(565, '98', '2018-12-16 18:55:36', 0, 0, 0, NULL, 'counter_2-14', 137, 2, 0, 0),
(566, '95', '2018-12-16 18:56:10', 6354270, 0, 532238, NULL, 'counter_1-15', 137, 2, 0, 5431),
(567, '98', '2018-12-16 18:56:10', 1596000, 0, 129010, NULL, 'counter_2-15', 137, 2, 0, 1330),
(568, 'Diesel G', '2018-12-16 18:56:32', 5241600, 0, 174720, NULL, 'counter_1-16', 137, 2, 0, 5824),
(569, 'Diesel G', '2018-12-16 18:56:32', 0, 0, 0, NULL, 'counter_2-16', 137, 2, 0, 0),
(570, '95_d', '2018-12-16 05:59:00', 25000, 25000, NULL, 17, '', 138, 2, 0, NULL),
(571, 'dieselG_d', '2018-12-16 05:59:00', 50000, 50000, NULL, 9, '', 138, 2, 0, NULL),
(572, 'dieselG_d', '2018-12-16 06:00:00', 15000, 15000, NULL, 18, '', 138, 2, 0, NULL),
(573, '95_d', '2018-12-16 06:00:00', 25000, 25000, NULL, 4, '', 138, 2, 0, NULL),
(574, 'dieselG_d', '2018-12-16 06:01:00', 90000, 90000, NULL, 19, '', 138, 2, 0, NULL),
(575, 'dieselG_d', '2018-12-16 06:02:00', 100000, 100000, NULL, 9, '', 138, 2, 0, NULL),
(576, '95_d', '2018-12-16 06:02:00', 3000, 3000, NULL, 20, '', 138, 2, 0, NULL),
(577, 'payC', '2018-12-16 06:03:00', 8000, 0, NULL, NULL, 'مازوت للمحطة', 138, 2, 0, NULL),
(578, 'lub', '2018-12-16 06:04:00', 5000, 0, 2300, 1, NULL, 138, 2, 0, NULL),
(579, 'lub', '2018-12-16 06:04:00', 6000, 0, 2600, 1, NULL, 138, 2, 0, NULL),
(580, 'lub', '2018-12-16 06:05:00', 5000, 0, 2300, 1, NULL, 138, 2, 0, NULL),
(581, 'lub', '2018-12-16 06:05:00', 3000, 0, 1300, 1, NULL, 138, 2, 0, NULL),
(582, 'wash', '2018-12-16 06:05:00', 5000, 0, 5000, 1, 'غسيل : سيارة', 138, 2, 0, NULL),
(583, 'wash', '2018-12-16 06:05:00', 5000, 0, 5000, 1, 'غسيل : سيارة', 138, 2, 0, NULL),
(584, '95', '2018-12-16 19:06:00', 326430, 0, 27342, NULL, 'counter_1-17', 138, 2, 0, 279),
(585, '98', '2018-12-16 19:06:00', 0, 0, 0, NULL, 'counter_2-17', 138, 2, 0, 0),
(586, '95', '2018-12-16 19:09:16', 937170, 0, 78498, NULL, 'counter_1-18', 138, 2, 0, 801),
(587, '98', '2018-12-16 19:09:16', 140400, 0, 11349, NULL, 'counter_2-18', 138, 2, 0, 117),
(588, 'Diesel G', '2018-12-16 19:09:34', 1119600, 0, 37320, NULL, 'counter_1-19', 138, 2, 0, 1244),
(589, 'Diesel G', '2018-12-16 19:09:34', 0, 0, 0, NULL, 'counter_2-19', 138, 2, 0, 0),
(590, 'lub', '2018-12-16 06:17:00', 6000, 0, 3300, 1, NULL, 139, 1, 0, NULL),
(591, 'wash', '2018-12-16 06:17:00', 7000, 0, 7000, 1, 'غسيل : جيب', 139, 1, 0, NULL),
(592, 'return', '2018-12-16 06:18:00', 260000, 0, NULL, 12, '', 139, 1, 0, NULL),
(593, '95_d', '2018-12-16 06:19:00', 40000, 40000, NULL, 21, '', 139, 1, 0, NULL),
(594, '95', '2018-12-16 19:33:59', 257400, 0, 21560, NULL, 'counter_1-20', 139, 1, 0, 220),
(595, '98', '2018-12-16 19:33:59', 0, 0, 0, NULL, 'counter_2-20', 139, 1, 0, 0),
(596, '95', '2018-12-16 19:34:22', 596700, 0, 49980, NULL, 'counter_1-21', 139, 1, 0, 510),
(597, '98', '2018-12-16 19:34:22', 150000, 0, 12125, NULL, 'counter_2-21', 139, 1, 0, 125),
(598, 'Diesel G', '2018-12-16 19:34:45', 585000, 0, 19500, NULL, 'counter_1-22', 139, 1, 0, 650),
(599, 'Diesel G', '2018-12-16 19:34:45', 0, 0, 0, NULL, 'counter_2-22', 139, 1, 0, 0),
(600, '95_d', '2018-12-16 06:37:00', 80000, 80000, NULL, 22, '', 139, 1, 0, NULL),
(601, '95_d', '2018-12-17 07:05:00', 2000, 2000, NULL, 15, '', 140, 1, 0, NULL),
(602, 'return', '2018-12-17 07:18:00', 100000, 0, NULL, 19, '', 140, 1, 0, NULL),
(603, 'payC', '2018-12-17 07:21:00', 10000, 0, NULL, NULL, 'تكملة بون', 140, 1, 0, NULL),
(604, 'payC', '2018-12-17 07:25:00', 20000, 0, NULL, NULL, 'علي ويزاني', 140, 1, 0, NULL),
(605, 'lub', '2018-12-17 08:01:00', 5000, 0, 2300, 1, NULL, 140, 1, 0, NULL),
(606, 'lub', '2018-12-17 08:01:00', 3000, 0, 1300, 1, NULL, 140, 1, 0, NULL),
(607, 'dieselG_d', '2018-12-17 08:23:00', 39000, 39000, NULL, 5, '', 140, 1, 0, NULL),
(608, 'dieselG_d', '2018-12-17 08:23:00', 50000, 50000, NULL, 5, '', 140, 1, 0, NULL),
(609, 'wash', '2018-12-17 09:07:00', 5000, 0, 5000, 1, 'غسيل : سيارة', 140, 1, 0, NULL),
(610, 'payC', '2018-12-17 09:34:00', 5000, 0, NULL, NULL, 'اكرامية', 140, 1, 0, NULL),
(612, 'wash', '2018-12-17 01:28:00', 5000, 0, 5000, 1, 'غسيل : سيارة', 140, 1, 0, NULL),
(613, 'return', '2018-12-17 01:56:00', 2000, 0, NULL, 15, '', 140, 1, 0, NULL),
(614, '95_d', '2018-12-17 02:01:00', 10000, 10000, NULL, 12, '', 140, 1, 0, NULL),
(615, '95_d', '2018-12-17 02:57:00', 30000, 30000, NULL, 5, '', 140, 1, 0, NULL),
(616, 'dieselG_d', '2018-12-17 03:03:00', 320000, 320000, NULL, 9, '', 140, 1, 0, NULL),
(617, 'lub', '2018-12-17 04:24:00', 5000, 0, 2300, 1, NULL, 140, 1, 0, NULL),
(618, 'lub', '2018-12-17 06:21:00', 3000, 0, 1300, 1, NULL, 140, 1, 0, NULL),
(619, '95', '2018-12-17 19:46:42', 1432080, 0, 119952, NULL, 'counter_1-23', 140, 1, 0, 1224),
(620, '98', '2018-12-17 19:46:42', 0, 0, 0, NULL, 'counter_2-23', 140, 1, 0, 0),
(621, '95', '2018-12-17 19:47:05', 0, 0, 0, NULL, 'counter_1-24', 140, 1, 0, 0),
(622, '98', '2018-12-17 19:47:05', 1083600, 0, 87591, NULL, 'counter_2-24', 140, 1, 0, 903),
(623, 'Diesel G', '2018-12-17 19:47:35', 1663200, 0, 55440, NULL, 'counter_1-25', 140, 1, 0, 1848),
(624, 'Diesel G', '2018-12-17 19:47:35', 0, 0, 0, NULL, 'counter_2-25', 140, 1, 0, 0),
(625, 'payC', '2018-12-17 06:52:00', 9000, 0, NULL, NULL, 'ترابة', 140, 1, 0, NULL),
(626, 'payC', '2018-12-17 06:52:00', 55000, 0, NULL, NULL, 'بنزين رواد', 140, 1, 0, NULL),
(627, 'dieselG_d', '2018-12-17 07:11:00', 21000, 21000, NULL, 23, '', 140, 1, 0, NULL),
(628, '95_d', '2018-12-18 09:12:00', 20000, 20000, NULL, 24, '', 141, 1, 0, NULL),
(629, 'lub', '2018-12-18 10:12:00', 5000, 0, 2300, 1, NULL, 141, 1, 0, NULL),
(630, '95_d', '2018-12-18 11:04:00', 15000, 15000, NULL, 25, '', 141, 1, 0, NULL),
(631, '95', '2018-12-18 12:23:54', 499590, 0, 41846, NULL, 'counter_1-26', 141, 1, 0, 427),
(633, '95', '2018-12-18 12:24:20', 0, 0, 0, NULL, 'counter_1-27', 141, 1, 0, 0),
(634, '98', '2018-12-18 12:24:20', 535200, 0, 43262, NULL, 'counter_2-27', 141, 1, 0, 446),
(635, 'Diesel G', '2018-12-18 12:24:44', 342000, 0, 11400, NULL, 'counter_1-28', 141, 1, 0, 380),
(636, 'Diesel G', '2018-12-18 12:24:44', 0, 0, 0, NULL, 'counter_2-28', 141, 1, 0, 0),
(638, '95', '2018-12-18 12:43:17', 0, 0, 0, NULL, 'counter_1-29', 141, 1, 0, 0),
(639, '98', '2018-12-18 12:43:17', 0, 0, 0, NULL, 'counter_2-29', 141, 1, 0, 0),
(643, '95_d', '2018-12-18 11:55:00', 15000, 15000, NULL, 27, '', 142, 2, 0, NULL),
(645, 'Diesel G', '2018-12-18 12:07:00', 3090000, 0, NULL, 11, '10', 142, 2, 1, 3570),
(646, 'access', '2018-12-18 12:49:00', 5000, 0, 2500, 1, NULL, 142, 2, 0, NULL),
(647, '95_d', '2018-12-18 12:50:00', 25000, 25000, NULL, 23, '', 142, 2, 0, NULL),
(648, 'return', '2018-12-18 12:50:00', 75000, 0, NULL, 23, '', 142, 2, 0, NULL),
(649, 'payC', '2018-12-18 01:18:00', 5000, 0, NULL, NULL, 'مياه', 142, 2, 0, NULL),
(650, 'payC', '2018-12-18 01:27:00', 20000, 0, NULL, NULL, 'شامبو للمغسل', 142, 2, 0, NULL),
(651, 'lub', '2018-12-18 02:27:00', 3000, 0, 1300, 1, NULL, 142, 2, 0, NULL),
(652, '95_d', '2018-12-18 03:04:00', 3000, 3000, NULL, 28, '', 142, 2, 0, NULL),
(653, '95_d', '2018-12-18 03:24:00', 30000, 30000, NULL, 29, '', 142, 2, 0, NULL),
(654, 'return', '2018-12-18 04:50:00', 15000, 0, NULL, 18, '', 142, 2, 0, NULL),
(655, '95', '2018-12-18 19:44:33', 730080, 0, 61152, NULL, 'counter_1-30', 142, 2, 0, 624),
(656, '98', '2018-12-18 19:44:33', 0, 0, 0, NULL, 'counter_2-30', 142, 2, 0, 0),
(657, '95', '2018-12-18 19:45:04', 0, 0, 0, NULL, 'counter_1-31', 142, 2, 0, 0),
(658, '98', '2018-12-18 19:45:04', 435600, 0, 35211, NULL, 'counter_2-31', 142, 2, 0, 363),
(659, 'Diesel G', '2018-12-18 19:45:31', 589500, 0, 19650, NULL, 'counter_1-32', 142, 2, 0, 655),
(660, 'Diesel G', '2018-12-18 19:45:31', 0, 0, 0, NULL, 'counter_2-32', 142, 2, 0, 0),
(661, 'lub', '2018-12-19 09:38:00', 10000, 0, 5000, 1, NULL, 143, 1, 0, NULL),
(662, 'payC', '2018-12-19 09:39:00', 5000, 0, NULL, NULL, 'مازوت محطة', 143, 1, 0, NULL),
(663, '95_d', '2018-12-19 09:40:00', 20000, 20000, NULL, 17, '', 143, 1, 0, NULL),
(664, 'wash', '2018-12-19 10:18:00', 5000, 0, 5000, 1, 'غسيل : سيارة', 143, 1, 0, NULL),
(665, 'dieselG_d', '2018-12-19 04:35:00', 250000, 250000, NULL, 30, '', 143, 1, 0, NULL),
(666, 'return', '2018-12-19 04:35:00', 15000, 0, NULL, 25, '', 143, 1, 0, NULL),
(667, 'lub', '2018-12-19 04:36:00', 3000, 0, 1300, 1, NULL, 143, 1, 0, NULL),
(668, 'lub', '2018-12-19 04:38:00', 3000, 0, 1300, 1, NULL, 143, 1, 0, NULL),
(669, 'lub', '2018-12-19 04:38:00', 3000, 0, 1300, 1, NULL, 143, 1, 0, NULL),
(670, 'lub', '2018-12-19 04:38:00', 5000, 0, 2300, 1, NULL, 143, 1, 0, NULL),
(671, '95_d', '2018-12-19 04:39:00', 11000, 11000, NULL, 31, '', 143, 1, 0, NULL),
(672, 'payC', '2018-12-19 04:39:00', 5000, 0, NULL, NULL, 'اكرامية', 143, 1, 0, NULL),
(673, 'Diesel G', '2018-12-19 04:52:00', 2973000, 0, NULL, 11, '9', 143, 1, 1, 3580),
(674, '95', '2018-12-19 04:58:00', 5281000, 0, NULL, 11, '7', 143, 1, 1, 3044),
(676, '95', '2018-12-19 18:32:32', 582805, 0, 37157, NULL, 'counter_1-33', 143, 1, 0, 509),
(677, '98', '2018-12-19 18:32:32', 0, 0, 0, NULL, 'counter_2-33', 143, 1, 0, 0),
(678, '95', '2018-12-19 18:32:56', 1173625, 0, -427425, NULL, 'counter_1-34', 143, 1, 0, 1025),
(679, '98', '2018-12-19 18:32:56', 410640, 0, 26796, NULL, 'counter_2-34', 143, 1, 0, 348),
(680, 'Diesel G', '2018-12-19 18:33:14', 1271550, 0, 102900, NULL, 'counter_1-35', 143, 1, 0, 1470),
(681, 'Diesel G', '2018-12-19 18:33:14', 0, 0, 0, NULL, 'counter_2-35', 143, 1, 0, 0),
(682, 'payC', '2018-12-19 05:45:00', 5000, 0, NULL, NULL, 'ماززوت للمحطة', 143, 1, 0, NULL),
(683, '95_d', '2018-12-24 07:03:00', 25000, 25000, NULL, 4, '', 144, 1, 0, NULL),
(684, 'lub', '2018-12-24 07:07:00', 5000, 0, 2300, 1, NULL, 144, 1, 0, NULL),
(685, 'dieselG_d', '2018-12-24 07:09:00', 7000, 7000, NULL, 26, '', 144, 1, 0, NULL),
(687, 'payC', '2018-12-24 07:42:00', 5000, 0, NULL, NULL, 'مياه', 144, 1, 0, NULL),
(688, 'wash', '2018-12-24 10:06:00', 5000, 0, 5000, 1, 'غسيل : سيارة', 144, 1, 0, NULL),
(691, '95_d', '2018-12-24 04:28:00', 10000, 10000, NULL, 12, '', 144, 1, 0, NULL),
(692, '95_d', '2018-12-24 04:30:00', 30000, 30000, NULL, 5, '', 144, 1, 0, NULL),
(693, 'access', '2018-12-24 04:31:00', 10000, 10000, 7500, 17, '', 144, 1, 0, NULL),
(694, 'return', '2018-12-24 04:32:00', 12000, 0, NULL, 33, '', 144, 1, 0, NULL),
(695, 'payC', '2018-12-24 04:33:00', 20000, 0, NULL, NULL, 'ضيافة', 144, 1, 0, NULL),
(696, '95_d', '2018-12-24 04:35:00', 150000, 150000, NULL, 34, '', 144, 1, 0, NULL),
(697, 'lub', '2018-12-24 04:35:00', 5000, 0, 2300, 1, NULL, 144, 1, 0, NULL),
(698, 'lub', '2018-12-24 04:36:00', 9000, 0, 4000, 1, NULL, 144, 1, 0, NULL),
(699, 'lub', '2018-12-24 04:36:00', 96000, 0, 32000, 1, NULL, 144, 1, 0, NULL),
(700, 'access', '2018-12-24 04:37:00', 5000, 0, 2500, 1, NULL, 144, 1, 0, NULL),
(701, 'wash', '2018-12-24 04:37:00', 5000, 0, 5000, 1, 'غسيل : سيارة', 144, 1, 0, NULL),
(702, 'wash', '2018-12-24 04:37:00', 5000, 0, 5000, 1, 'غسيل : سيارة', 144, 1, 0, NULL),
(703, 'wash', '2018-12-24 04:37:00', 6000, 0, 6000, 1, 'غسيل : سيارة', 144, 1, 0, NULL),
(704, '95', '2018-12-24 19:28:37', 965235, 0, 6744, NULL, 'counter_1-37', 144, 1, 0, 843),
(705, '98', '2018-12-24 19:28:37', 0, 0, 0, NULL, 'counter_2-37', 144, 1, 0, 0),
(706, '95', '2018-12-24 19:28:57', 1338505, 0, -487473, NULL, 'counter_1-38', 144, 1, 0, 1169),
(707, '98', '2018-12-24 19:28:57', 88500, 0, 5775, NULL, 'counter_2-38', 144, 1, 0, 75),
(708, 'Diesel G', '2018-12-24 19:29:12', 1466175, 0, 118650, NULL, 'counter_1-39', 144, 1, 0, 1695),
(709, 'Diesel G', '2018-12-24 19:29:12', 0, 0, 0, NULL, 'counter_2-39', 144, 1, 0, 0),
(710, 'dieselG_d', '2018-12-25 07:09:00', 38000, 38000, NULL, 5, '', 145, 1, 0, NULL),
(711, 'dieselG_d', '2018-12-25 07:43:00', 15000, 15000, NULL, 18, '', 145, 1, 0, NULL),
(712, 'lub', '2018-12-25 08:51:00', 3000, 0, 1300, 1, NULL, 145, 1, 0, NULL),
(713, 'lub', '2018-12-25 08:51:00', 5000, 0, 2300, 1, NULL, 145, 1, 0, NULL),
(714, 'wash', '2018-12-25 10:18:00', 6000, 0, 6000, 1, 'غسيل : سيارة', 145, 1, 0, NULL),
(715, '95_d', '2018-12-25 10:35:00', 20000, 20000, NULL, 17, '', 145, 1, 0, NULL),
(716, 'payC', '2018-12-25 10:36:00', 20000, 0, NULL, NULL, 'بنزين', 145, 1, 0, NULL),
(717, 'lub', '2018-12-25 10:47:00', 3000, 0, 1300, 1, NULL, 145, 1, 0, NULL),
(718, 'lub', '2018-12-25 12:05:00', 6000, 0, 3300, 1, NULL, 145, 1, 0, NULL),
(719, 'payC', '2018-12-25 12:05:00', 20000, 0, NULL, NULL, 'حسن سلطان', 145, 1, 0, NULL),
(720, 'dieselG_d', '2018-12-25 12:07:00', 48000, 48000, NULL, 5, '', 145, 1, 0, NULL),
(721, '95', '2018-12-25 13:07:44', 632040, 0, 4416, NULL, 'counter_1-40', 145, 1, 0, 552),
(722, '98', '2018-12-25 13:07:44', 0, 0, 0, NULL, 'counter_2-40', 145, 1, 0, 0),
(723, '95', '2018-12-25 13:08:27', 387010, 0, -140946, NULL, 'counter_1-41', 145, 1, 0, 338),
(724, '98', '2018-12-25 13:08:27', 46020, 0, 3003, NULL, 'counter_2-41', 145, 1, 0, 39),
(725, 'Diesel G', '2018-12-25 13:08:49', 551870, 0, 44660, NULL, 'counter_1-42', 145, 1, 0, 638),
(726, 'Diesel G', '2018-12-25 13:08:49', 0, 0, 0, NULL, 'counter_2-42', 145, 1, 0, 0),
(727, '95_d', '2018-12-25 02:55:00', 15000, 15000, NULL, 17, '', 146, 2, 0, NULL),
(728, 'wash', '2018-12-25 02:55:00', 7000, 0, 7000, 1, 'غسيل : جيب', 146, 2, 0, NULL),
(729, 'wash', '2018-12-25 02:55:00', 6000, 0, 6000, 1, 'غسيل : سيارة', 146, 2, 0, NULL),
(730, 'wash', '2018-12-25 02:55:00', 6000, 0, 6000, 1, 'غسيل : سيارة', 146, 2, 0, NULL),
(731, 'payC', '2018-12-25 03:02:00', 6000, 0, NULL, NULL, 'ابو عباس المغسل', 146, 2, 0, NULL),
(732, 'wash', '2018-12-25 05:12:00', 6000, 0, 6000, 1, 'غسيل : سيارة', 146, 2, 0, NULL),
(733, 'wash', '2018-12-25 06:28:00', 6000, 0, 6000, 1, 'غسيل : سيارة', 146, 2, 0, NULL),
(734, 'lub', '2018-12-25 06:41:00', 3000, 0, 1300, 1, NULL, 146, 2, 0, NULL),
(735, 'lub', '2018-12-25 06:41:00', 5000, 0, 2300, 1, NULL, 146, 2, 0, NULL),
(736, 'payC', '2018-12-25 06:42:00', 25000, 0, NULL, NULL, 'رواد بنزين', 146, 2, 0, NULL),
(737, 'payC', '2018-12-25 06:42:00', 5000, 0, NULL, NULL, 'رزنامة', 146, 2, 0, NULL),
(738, 'payC', '2018-12-25 06:43:00', 7000, 0, NULL, NULL, 'مازوت بيت', 146, 2, 0, NULL),
(739, '95', '2018-12-25 19:48:53', 447695, 0, 3128, NULL, 'counter_1-43', 146, 2, 0, 391),
(740, '98', '2018-12-25 19:48:53', 0, 0, 0, NULL, 'counter_2-43', 146, 2, 0, 0),
(741, '95', '2018-12-25 19:49:31', 736235, 0, -268131, NULL, 'counter_1-44', 146, 2, 0, 643),
(742, '98', '2018-12-25 19:49:31', 237180, 0, 15477, NULL, 'counter_2-44', 146, 2, 0, 201),
(743, 'Diesel G', '2018-12-25 19:49:58', 810505, 0, 65590, NULL, 'counter_1-45', 146, 2, 0, 937),
(744, 'Diesel G', '2018-12-25 19:49:58', 0, 0, 0, NULL, 'counter_2-45', 146, 2, 0, 0),
(745, 'lub', '2018-12-26 09:19:00', 10000, 0, 5000, 1, NULL, 147, 2, 0, NULL),
(746, 'lub', '2018-12-26 09:19:00', 10000, 0, 5000, 1, NULL, 147, 2, 0, NULL),
(747, 'lub', '2018-12-26 09:19:00', 3000, 0, 1300, 1, NULL, 147, 2, 0, NULL),
(748, 'lub', '2018-12-26 09:19:00', 3000, 0, 1300, 1, NULL, 147, 2, 0, NULL),
(749, 'payC', '2018-12-26 09:19:00', 7000, 0, NULL, NULL, 'مازوت محطه', 147, 2, 0, NULL),
(750, '95_d', '2018-12-26 09:20:00', 10000, 10000, NULL, 12, '', 147, 2, 0, NULL),
(751, 'lub', '2018-12-26 09:43:00', 3000, 0, 1300, 1, NULL, 147, 2, 0, NULL),
(752, 'lub', '2018-12-26 10:15:00', 3000, 0, 1300, 1, NULL, 147, 2, 0, NULL),
(753, 'lub', '2018-12-26 12:21:00', 3000, 0, 1300, 1, NULL, 147, 2, 0, NULL),
(754, 'lub', '2018-12-26 01:14:00', 3000, 0, 1300, 1, NULL, 147, 2, 0, NULL),
(755, '95_d', '2018-12-26 01:15:00', 10000, 10000, NULL, 35, '', 147, 2, 0, NULL),
(756, 'lub', '2018-12-26 01:39:00', 3000, 0, 1300, 1, NULL, 147, 2, 0, NULL),
(757, 'lub', '2018-12-26 01:39:00', 7000, 0, 4300, 1, NULL, 147, 2, 0, NULL),
(758, 'return', '2018-12-26 02:06:00', 10000, 0, NULL, 35, '', 147, 2, 0, NULL),
(759, '95_d', '2018-12-26 02:56:00', 28000, 28000, NULL, 13, '', 147, 2, 0, NULL),
(760, '95_d', '2018-12-26 02:57:00', 7000, 7000, NULL, 36, '', 147, 2, 0, NULL),
(761, 'return', '2018-12-26 02:58:00', 15000, 0, NULL, 12, '', 147, 2, 0, NULL),
(762, '95_d', '2018-12-26 03:11:00', 50000, 50000, NULL, 12, '', 147, 2, 0, NULL),
(763, 'payC', '2018-12-26 04:02:00', 10000, 0, NULL, NULL, 'غراض المطبخ', 147, 2, 0, NULL),
(764, '95_d', '2018-12-26 06:03:00', 10000, 10000, NULL, 27, '', 147, 2, 0, NULL),
(765, '95', '2018-12-27 11:31:50', 1149750, 0, 100156, NULL, 'counter_1-46', 147, 2, 0, 1022),
(766, '98', '2018-12-27 11:31:50', 0, 0, 0, NULL, 'counter_2-46', 147, 2, 0, 0),
(767, '95', '2018-12-27 11:33:33', 790875, 0, 68894, NULL, 'counter_1-47', 147, 2, 0, 703),
(768, '98', '2018-12-27 11:33:33', 251790, 0, 21364, NULL, 'counter_2-47', 147, 2, 0, 218),
(769, 'Diesel G', '2018-12-27 11:34:05', 1544760, 0, 62526, NULL, 'counter_1-48', 147, 2, 0, 1839),
(770, 'Diesel G', '2018-12-27 11:34:05', 0, 0, 0, NULL, 'counter_2-48', 147, 2, 0, 0),
(771, '95_d', '2018-12-27 10:43:00', 20000, 20000, NULL, 17, '', 148, 2, 0, NULL),
(772, '95_d', '2018-12-27 10:44:00', 30000, 30000, NULL, 5, '', 148, 2, 0, NULL),
(773, 'payC', '2018-12-27 11:22:00', 350000, 0, NULL, NULL, 'مهند مرعي', 148, 2, 0, NULL),
(775, '95', '2018-12-27 05:19:00', 6173000, 0, NULL, 11, '7', 148, 2, 1, 6012),
(776, '98', '2018-12-27 05:20:00', 4812000, 0, NULL, 11, '8', 148, 2, 1, 4554),
(777, 'Diesel G', '2018-12-27 05:20:00', 7355000, 0, NULL, 11, '9', 148, 2, 1, 9123),
(778, '95', '2018-12-27 18:21:30', 1416375, 0, 123382, NULL, 'counter_1-49', 148, 2, 0, 1259),
(779, '98', '2018-12-27 18:21:30', 0, 0, 0, NULL, 'counter_2-49', 148, 2, 0, 0),
(780, '95', '2018-12-27 18:21:47', 0, 0, 0, NULL, 'counter_1-50', 148, 2, 0, 0),
(781, '98', '2018-12-27 18:21:47', 347655, 0, 29498, NULL, 'counter_2-50', 148, 2, 0, 301),
(782, 'Diesel G', '2018-12-27 18:22:01', 1431360, 0, 57936, NULL, 'counter_1-51', 148, 2, 0, 1704),
(783, 'Diesel G', '2018-12-27 18:22:01', 0, 0, 0, NULL, 'counter_2-51', 148, 2, 0, 0),
(784, 'lub', '2018-12-27 06:43:00', 56000, 0, 20000, 1, NULL, 149, 1, 0, NULL),
(785, 'lub', '2018-12-27 06:43:00', 7000, 0, 2000, 1, NULL, 149, 1, 0, NULL),
(786, '95', '2018-12-27 19:44:47', 171000, 0, 14896, NULL, 'counter_1-52', 149, 1, 0, 152),
(787, '98', '2018-12-27 19:44:47', 0, 0, 0, NULL, 'counter_2-52', 149, 1, 0, 0),
(788, '95', '2018-12-27 19:45:45', 183375, 0, 15974, NULL, 'counter_1-53', 149, 1, 0, 163),
(789, '98', '2018-12-27 19:45:45', 76230, 0, 6468, NULL, 'counter_2-53', 149, 1, 0, 66),
(790, 'Diesel G', '2018-12-27 19:46:17', 396480, 0, 16048, NULL, 'counter_1-54', 149, 1, 0, 472),
(791, 'Diesel G', '2018-12-27 19:46:17', 0, 0, 0, NULL, 'counter_2-54', 149, 1, 0, 0),
(792, 'payC', '2018-12-28 07:14:00', 50000, 0, NULL, NULL, 'علي سلفة', 150, 1, 0, NULL),
(793, 'payC', '2018-12-28 07:15:00', 5000, 0, NULL, NULL, 'مازوت', 150, 1, 0, NULL),
(794, 'payC', '2018-12-28 07:15:00', 20000, 0, NULL, NULL, 'علي بنزين', 150, 1, 0, NULL),
(795, '95_d', '2018-12-28 05:54:00', 102000, 102000, NULL, 22, '', 150, 1, 0, NULL),
(796, '95_d', '2018-12-28 05:55:00', 27000, 27000, NULL, 37, '', 150, 1, 0, NULL),
(797, 'dieselG_d', '2018-12-28 05:56:00', 280000, 280000, NULL, 9, '', 150, 1, 0, NULL),
(798, '95_d', '2018-12-28 05:56:00', 20000, 20000, NULL, 17, '', 150, 1, 0, NULL),
(799, 'lub', '2018-12-28 05:59:00', 5000, 0, 2300, 1, NULL, 150, 1, 0, NULL),
(800, 'lub', '2018-12-28 05:59:00', 3000, 0, 1300, 1, NULL, 150, 1, 0, NULL),
(802, 'lub', '2018-12-28 06:33:00', 5000, 0, 2300, 1, NULL, 150, 1, 0, NULL),
(803, '95', '2018-12-28 19:38:54', 473625, 0, 41258, NULL, 'counter_1-55', 150, 1, 0, 421),
(804, '98', '2018-12-28 19:38:54', 0, 0, 0, NULL, 'counter_2-55', 150, 1, 0, 0),
(805, '95', '2018-12-28 19:39:12', 1537875, 0, 133966, NULL, 'counter_1-56', 150, 1, 0, 1367),
(806, '98', '2018-12-28 19:39:12', 197505, 0, 16758, NULL, 'counter_2-56', 150, 1, 0, 171),
(807, 'Diesel G', '2018-12-28 19:39:29', 1853880, 0, 75038, NULL, 'counter_1-57', 150, 1, 0, 2207),
(808, 'Diesel G', '2018-12-28 19:39:29', 0, 0, 0, NULL, 'counter_2-57', 150, 1, 0, 0),
(809, 'lub', '2018-12-28 06:44:00', 10000, 0, 1000, 1, NULL, 150, 1, 0, NULL),
(810, 'lub', '2018-12-29 04:27:00', 3000, 0, 1300, 1, NULL, 151, 1, 0, NULL),
(811, 'lub', '2018-12-29 04:27:00', 3000, 0, 1300, 1, NULL, 151, 1, 0, NULL),
(812, 'payC', '2018-12-29 04:28:00', 38000, 0, NULL, NULL, 'ريحان', 151, 1, 0, NULL),
(813, 'payC', '2018-12-29 04:28:00', 10000, 0, NULL, NULL, 'اكرامية', 151, 1, 0, NULL),
(814, 'dieselG_d', '2018-12-29 04:30:00', 7000, 7000, NULL, 36, '', 151, 1, 0, NULL),
(815, '95_d', '2018-12-29 04:31:00', 10000, 10000, NULL, 12, '', 151, 1, 0, NULL),
(816, '95_d', '2018-12-29 04:31:00', 50000, 50000, NULL, 38, '', 151, 1, 0, NULL),
(817, 'dieselG_d', '2018-12-29 04:32:00', 20000, 20000, NULL, 17, '', 151, 1, 0, NULL),
(818, 'dieselG_d', '2018-12-29 04:33:00', 35000, 35000, NULL, 14, '', 151, 1, 0, NULL),
(819, 'return', '2018-12-29 04:34:00', 280000, 0, NULL, 9, '', 151, 1, 0, NULL),
(820, 'return', '2018-12-29 04:35:00', 7000, 0, NULL, 16, '', 151, 1, 0, NULL),
(821, 'return', '2018-12-29 04:35:00', 177000, 0, NULL, 17, '', 151, 1, 0, NULL),
(822, '95', '2018-12-29 04:48:00', 3940000, 0, NULL, 11, '6', 151, 1, 1, 3838),
(823, '95', '2018-12-29 04:49:00', 2693000, 0, NULL, 11, '7', 151, 1, 1, 2623),
(824, 'payC', '2018-12-29 04:55:00', 7000, 0, NULL, NULL, 'مازوت', 151, 1, 0, NULL),
(825, 'dieselG_d', '2018-12-29 05:37:00', 7000, 7000, NULL, 22, '', 151, 1, 0, NULL),
(826, '95', '2018-12-29 19:19:08', 591750, 0, 51548, NULL, 'counter_1-58', 151, 1, 0, 526),
(827, '98', '2018-12-29 19:19:08', 0, 0, 0, NULL, 'counter_2-58', 151, 1, 0, 0),
(828, '95', '2018-12-29 19:19:23', 1238625, 0, 107898, NULL, 'counter_1-59', 151, 1, 0, 1101),
(829, '98', '2018-12-29 19:19:23', 261030, 0, 22148, NULL, 'counter_2-59', 151, 1, 0, 226),
(830, 'Diesel G', '2018-12-29 19:19:53', 1658160, 0, 67116, NULL, 'counter_1-60', 151, 1, 0, 1974),
(831, 'Diesel G', '2018-12-29 19:19:53', 0, 0, 0, NULL, 'counter_2-60', 151, 1, 0, 0),
(832, 'return', '2018-12-30 09:53:00', 28000, 0, NULL, 36, '', 152, 1, 0, NULL),
(833, 'return', '2018-12-30 09:53:00', 50000, 0, NULL, 38, '', 152, 1, 0, NULL),
(834, 'lub', '2018-12-30 09:54:00', 5000, 0, 2500, 1, NULL, 152, 1, 0, NULL),
(835, 'lub', '2018-12-30 09:54:00', 6000, 0, 3300, 1, NULL, 152, 1, 0, NULL),
(836, 'return', '2018-12-30 02:59:00', 27000, 0, NULL, 37, '', 152, 1, 0, NULL),
(838, '95_d', '2018-12-30 03:01:00', 30000, 30000, NULL, 12, '', 152, 1, 0, NULL),
(839, 'lub', '2018-12-30 03:02:00', 20000, 0, 9200, 1, NULL, 152, 1, 0, NULL),
(840, 'lub', '2018-12-30 03:03:00', 6000, 0, 2600, 1, NULL, 152, 1, 0, NULL),
(841, 'lub', '2018-12-30 03:03:00', 10000, 0, 6600, 1, NULL, 152, 1, 0, NULL),
(842, 'payC', '2018-12-30 03:04:00', 10000, 0, NULL, NULL, 'لمبة', 152, 1, 0, NULL),
(843, 'wash', '2018-12-30 03:04:00', 7000, 0, 7000, 1, 'غسيل : جيب', 152, 1, 0, NULL),
(844, 'wash', '2018-12-30 03:04:00', 5000, 0, 5000, 1, 'غسيل : سيارة', 152, 1, 0, NULL),
(845, 'access', '2018-12-30 06:25:00', 5000, 0, 2500, 1, NULL, 152, 1, 0, NULL),
(846, '95_d', '2018-12-30 06:26:00', 45000, 45000, NULL, 5, '', 152, 1, 0, NULL),
(847, '95', '2018-12-30 19:27:14', 887625, 0, 77322, NULL, 'counter_1-61', 152, 1, 0, 789),
(848, '98', '2018-12-30 19:27:14', 0, 0, 0, NULL, 'counter_2-61', 152, 1, 0, 0),
(849, '95', '2018-12-30 19:27:38', 1544625, 0, 134554, NULL, 'counter_1-62', 152, 1, 0, 1373),
(850, '98', '2018-12-30 19:27:38', 413490, 0, 35084, NULL, 'counter_2-62', 152, 1, 0, 358),
(851, 'Diesel G', '2018-12-30 19:27:55', 1189440, 0, 48144, NULL, 'counter_1-63', 152, 1, 0, 1416),
(852, 'Diesel G', '2018-12-30 19:27:55', 0, 0, 0, NULL, 'counter_2-63', 152, 1, 0, 0),
(853, 'dieselG_d', '2018-12-30 06:30:00', 5000, 5000, NULL, 39, '', 152, 1, 0, NULL),
(854, 'wash', '2018-12-31 04:44:00', 5000, 0, 5000, 1, 'غسيل : سيارة', 153, 1, 0, NULL),
(855, '95_d', '2018-12-31 04:45:00', 6000, 6000, NULL, 12, '', 153, 1, 0, NULL),
(856, '95_d', '2018-12-31 04:46:00', 30000, 30000, NULL, 29, '', 153, 1, 0, NULL),
(857, '95_d', '2018-12-31 04:48:00', 30000, 30000, NULL, 5, '', 153, 1, 0, NULL),
(858, 'payC', '2018-12-31 04:49:00', 5000, 0, NULL, NULL, 'مياه', 153, 1, 0, NULL),
(859, 'return', '2018-12-31 04:49:00', 40000, 0, NULL, 21, '', 153, 1, 0, NULL),
(860, 'return', '2018-12-31 04:50:00', 5000, 0, NULL, 39, '', 153, 1, 0, NULL),
(861, 'return', '2018-12-31 04:50:00', 7000, 0, NULL, 39, '', 153, 1, 0, NULL),
(862, 'lub', '2018-12-31 04:50:00', 3000, 0, 1300, 1, NULL, 153, 1, 0, NULL),
(863, 'lub', '2018-12-31 04:50:00', 6000, 0, 2600, 1, NULL, 153, 1, 0, NULL),
(864, 'lub', '2018-12-31 04:51:00', 5000, 0, 2300, 1, NULL, 153, 1, 0, NULL),
(865, 'lub', '2018-12-31 05:49:00', 5000, 0, 2300, 1, NULL, 153, 1, 0, NULL),
(866, '95', '2018-12-31 19:35:57', 768375, 0, 66934, NULL, 'counter_1-64', 153, 1, 0, 683),
(867, '98', '2018-12-31 19:35:57', 0, 0, 0, NULL, 'counter_2-64', 153, 1, 0, 0),
(868, '95', '2018-12-31 19:36:25', 1282500, 0, 111720, NULL, 'counter_1-65', 153, 1, 0, 1140),
(869, '98', '2018-12-31 19:36:25', 375375, 0, 31850, NULL, 'counter_2-65', 153, 1, 0, 325),
(870, 'Diesel G', '2018-12-31 19:36:44', 1198680, 0, 48518, NULL, 'counter_1-66', 153, 1, 0, 1427),
(871, 'Diesel G', '2018-12-31 19:36:44', 0, 0, 0, NULL, 'counter_2-66', 153, 1, 0, 0),
(873, 'wash', '2019-01-01 06:21:00', 49000, 0, 49000, 1, 'غسيل : سيارة', 154, 1, 0, NULL),
(874, 'lub', '2019-01-01 06:21:00', 6000, 0, 2600, 1, NULL, 154, 1, 0, NULL),
(875, 'lub', '2019-01-01 06:22:00', 5000, 0, 2300, 1, NULL, 154, 1, 0, NULL),
(876, 'lub', '2019-01-01 06:22:00', 10000, 0, 4600, 1, NULL, 154, 1, 0, NULL),
(877, 'payC', '2019-01-01 06:22:00', 150000, 0, NULL, NULL, 'علي سلفة', 154, 1, 0, NULL),
(878, 'return', '2019-01-01 06:22:00', 35000, 0, NULL, 14, '', 154, 1, 0, NULL),
(879, '95_d', '2019-01-01 06:23:00', 56000, 56000, NULL, 23, '', 154, 1, 0, NULL),
(880, '95_d', '2019-01-01 06:23:00', 120000, 120000, NULL, 12, '', 154, 1, 0, NULL),
(881, 'dieselG_d', '2019-01-01 06:24:00', 7000, 7000, NULL, 22, '', 154, 1, 0, NULL),
(882, 'dieselG_d', '2019-01-01 06:24:00', 20000, 20000, NULL, 17, '', 154, 1, 0, NULL),
(883, 'dieselG_d', '2019-01-01 06:28:00', 17000, 17000, NULL, 14, '', 154, 1, 0, NULL),
(884, 'Diesel G', '2019-01-01 19:35:10', 1046640, 0, 42364, NULL, 'counter_1-67', 154, 1, 0, 1246),
(885, 'Diesel G', '2019-01-01 19:35:10', 0, 0, 0, NULL, 'counter_2-67', 154, 1, 0, 0),
(886, '95', '2019-01-01 19:35:29', 1120500, 0, 97608, NULL, 'counter_1-68', 154, 1, 0, 996),
(887, '98', '2019-01-01 19:35:29', 200970, 0, 17052, NULL, 'counter_2-68', 154, 1, 0, 174),
(888, '95', '2019-01-01 19:35:51', 675000, 0, 58800, NULL, 'counter_1-69', 154, 1, 0, 600),
(889, '98', '2019-01-01 19:35:51', 0, 0, 0, NULL, 'counter_2-69', 154, 1, 0, 0),
(894, 'wash', '2019-01-02 05:19:00', 25000, 0, 25000, 1, 'غسيل : سيارة', 155, 1, 0, NULL),
(895, 'dieselG_d', '2019-01-02 05:23:00', 15000, 15000, NULL, 12, '', 155, 1, 0, NULL),
(896, 'return', '2019-01-02 05:25:00', 25000, 0, NULL, 9, '', 155, 1, 0, NULL),
(897, 'return', '2019-01-02 05:26:00', 115000, 0, NULL, 27, '', 155, 1, 0, NULL),
(898, 'return', '2019-01-02 05:26:00', 17000, 0, NULL, 14, '', 155, 1, 0, NULL),
(899, 'payC', '2019-01-02 05:27:00', 5000, 0, NULL, NULL, 'مازوت', 155, 1, 0, NULL),
(900, 'payC', '2019-01-02 05:27:00', 196000, 0, NULL, NULL, 'اشتراك', 155, 1, 0, NULL),
(901, 'payC', '2019-01-02 05:27:00', 23000, 0, NULL, NULL, 'كابل كهربا', 155, 1, 0, NULL),
(902, 'payC', '2019-01-02 05:28:00', 15000, 0, NULL, NULL, 'اكرامية', 155, 1, 0, NULL),
(903, 'lub', '2019-01-02 05:28:00', 5000, 0, 2300, 1, NULL, 155, 1, 0, NULL),
(904, 'lub', '2019-01-02 05:28:00', 9000, 0, 3900, 1, NULL, 155, 1, 0, NULL),
(905, 'lub', '2019-01-02 05:28:00', 3000, 0, 1300, 1, NULL, 155, 1, 0, NULL),
(906, '95', '2019-01-02 05:30:00', 4529000, 0, NULL, 11, '6', 155, 1, 1, 4500),
(907, '95', '2019-01-02 05:31:00', 3931000, 0, NULL, 11, '7', 155, 1, 1, 5036),
(908, 'Diesel G', '2019-01-02 05:44:00', 4677000, 0, NULL, 11, '9', 155, 1, 1, 5991),
(909, 'payC', '2019-01-02 06:24:00', 30000, 0, NULL, NULL, 'بنزين تيدا', 155, 1, 0, NULL),
(910, '95', '2019-01-02 19:25:07', 642005, 0, 56357, NULL, 'counter_1-71', 155, 1, 0, 581),
(911, '98', '2019-01-02 19:25:07', 0, 0, 0, NULL, 'counter_2-71', 155, 1, 0, 0),
(912, '95', '2019-01-02 19:25:29', 1607775, 0, 141135, NULL, 'counter_1-72', 155, 1, 0, 1455),
(913, '98', '2019-01-02 19:25:29', 263320, 0, 22736, NULL, 'counter_2-72', 155, 1, 0, 232),
(914, 'Diesel G', '2019-01-02 19:25:55', 1209460, 0, 44520, NULL, 'counter_1-73', 155, 1, 0, 1484),
(915, 'Diesel G', '2019-01-02 19:25:55', 0, 0, 0, NULL, 'counter_2-73', 155, 1, 0, 0),
(916, 'payC', '2019-01-03 10:11:00', 6000, 0, NULL, NULL, 'مازوت', 156, 1, 0, NULL),
(917, '95_d', '2019-01-03 10:12:00', 5000, 5000, NULL, 28, '', 156, 1, 0, NULL),
(918, 'lub', '2019-01-03 12:43:00', 5000, 0, 2500, 1, NULL, 156, 1, 0, NULL),
(919, '95_d', '2019-01-03 12:44:00', 5000, 5000, NULL, 40, '', 156, 1, 0, NULL),
(920, '95', '2019-01-03 13:45:00', 232050, 0, 20370, NULL, 'counter_1-74', 156, 1, 0, 210),
(921, '98', '2019-01-03 13:45:00', 0, 0, 0, NULL, 'counter_2-74', 156, 1, 0, 0),
(922, '95', '2019-01-03 13:45:21', 691730, 0, 60722, NULL, 'counter_1-75', 156, 1, 0, 626),
(923, '98', '2019-01-03 13:45:21', 155495, 0, 13426, NULL, 'counter_2-75', 156, 1, 0, 137),
(924, 'Diesel G', '2019-01-03 13:46:47', 978000, 0, 36000, NULL, 'counter_1-76', 156, 1, 0, 1200),
(925, 'Diesel G', '2019-01-03 13:46:47', 0, 0, 0, NULL, 'counter_2-76', 156, 1, 0, 0),
(926, 'return', '2019-01-03 02:00:00', 5000, 0, NULL, 28, '', 157, 2, 0, NULL),
(927, 'payC', '2019-01-03 04:50:00', 40000, 0, NULL, NULL, 'رواد بنزين', 157, 2, 0, NULL),
(928, 'lub', '2019-01-03 05:17:00', 5000, 0, 2300, 1, NULL, 157, 2, 0, NULL),