-
Notifications
You must be signed in to change notification settings - Fork 0
/
DM_Main.dfm
1737 lines (1729 loc) · 68.4 KB
/
DM_Main.dfm
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
object DataModuleMain: TDataModuleMain
OldCreateOrder = False
Height = 536
Width = 816
object DB: TIBDatabase
Connected = True
DatabaseName = '81.177.48.139:C:\Projects\Fumigator\Db\fumigator.fdb'
Params.Strings = (
'user_name=SYSDBA'
'password=masterkey')
LoginPrompt = False
DefaultTransaction = DefTr
ServerType = 'IBServer'
AllowStreamedConnected = False
Left = 24
Top = 24
end
object DefTr: TIBTransaction
Active = True
DefaultAction = TACommitRetaining
Params.Strings = (
'isc_tpb_read_committed'
'isc_tpb_rec_version'
'isc_tpb_wait')
AutoStopAction = saCommitRetaining
Left = 80
Top = 24
end
object DicUserTypes: TIBQuery
Database = DB
Transaction = DefTr
BufferChunks = 1000
CachedUpdates = True
ParamCheck = True
SQL.Strings = (
'select * from DIC_USER_TYPES')
UpdateObject = DicUserTypes_upd
GeneratorField.Field = 'ID'
GeneratorField.Generator = 'GEN_DIC_USER_TYPES_ID'
GeneratorField.ApplyEvent = gamOnPost
Left = 599
Top = 210
end
object DSDicUserTypes: TDataSource
AutoEdit = False
DataSet = DicUserTypes
Left = 599
Top = 261
end
object DicWorkerProfs: TIBQuery
Database = DB
Transaction = DefTr
BufferChunks = 1000
CachedUpdates = True
ParamCheck = True
SQL.Strings = (
'select * from DIC_WORKER_PROFS')
GeneratorField.Field = 'ID'
GeneratorField.Generator = 'GEN_DIC_WORKER_PROFS_ID'
GeneratorField.ApplyEvent = gamOnPost
Left = 668
Top = 190
end
object DSDicWorkerProfs: TDataSource
AutoEdit = False
DataSet = DicWorkerProfs
Left = 669
Top = 241
end
object Workers: TIBQuery
Database = DB
Transaction = worker_tr
BufferChunks = 1000
CachedUpdates = True
ParamCheck = True
SQL.Strings = (
'select w.*, p.family, p.name, p.surname, p.prof_id profession_id' +
','
'is_deleted, '
'(select first 1 phone from phones '
'where w.person_id = client_id and "TYPE"=1 and ismain=1) phone'
'from workers w'
'left join persons p on p.id = w.person_id')
UpdateObject = Worker_upd
GeneratorField.Field = 'ID'
GeneratorField.Generator = 'GEN_WORKERS_ID'
GeneratorField.ApplyEvent = gamOnPost
Left = 730
Top = 218
end
object DSWorkers: TDataSource
AutoEdit = False
DataSet = Workers
Left = 730
Top = 277
end
object Worker_upd: TIBUpdateSQL
RefreshSQL.Strings = (
'select w.*, p.family, p.name, p.surname, p.prof_id profession_id' +
','
'is_deleted, '
'(select first 1 phone from phones '
'where w.person_id = client_id and "TYPE"=1 and ismain=1) phone'
'from workers w'
'left join persons p on p.id = w.person_id'
'where w. ID = :ID')
ModifySQL.Strings = (
'update WORKERS set'
#9'PERSON_ID = :PERSON_ID,'
#9'FULL_NAME = :FULL_NAME,'
#9'SHORT_NAME = :SHORT_NAME,'
#9'STATUS = :STATUS,'
#9'TABELNUM = :TABELNUM,'
#9'IS_DELETED = :IS_DELETED,'
#9'USER_LOGIN = :USER_LOGIN,'
#9'USER_PASSWORD = :USER_PASSWORD,'
#9'USER_TYPE = :USER_TYPE,'
#9'USER_BLOCKED = :USER_BLOCKED,'
#9'ATS_NUM = :ATS_NUM'
'where id = :ID')
InsertSQL.Strings = (
'INSERT INTO WORKERS ('
#9'ID,'
' PERSON_ID,'
#9'FULL_NAME,'
#9'SHORT_NAME,'
#9'STATUS,'
#9'TABELNUM,'
#9'IS_DELETED,'
#9'USER_LOGIN,'
#9'USER_PASSWORD,'
#9'USER_TYPE,'
#9'USER_BLOCKED,'
#9'ATS_NUM,'
#9'WORKER_ID)'
'Values('
#9':ID,'
' '#9':PERSON_ID,'
#9':FULL_NAME,'
#9':SHORT_NAME,'
#9':STATUS,'
#9':TABELNUM,'
#9':IS_DELETED,'
#9':USER_LOGIN,'
#9':USER_PASSWORD,'
#9':USER_TYPE,'
#9':USER_BLOCKED,'
#9':ATS_NUM,'
#9':WORKER_ID)'#9)
DeleteSQL.Strings = (
'update workers'
'set IS_DELETED = 1'
'where'
'ID = :ID')
Left = 728
Top = 136
end
object Worker_Q: TIBQuery
Database = DB
Transaction = worker_tr
ForcedRefresh = True
BufferChunks = 1000
CachedUpdates = False
ParamCheck = True
SQL.Strings = (
'select * from workers where id = :ID')
GeneratorField.Field = 'ID'
GeneratorField.Generator = 'GEN_WORKERS_ID'
GeneratorField.ApplyEvent = gamOnPost
Left = 632
Top = 8
ParamData = <
item
DataType = ftUnknown
Name = 'ID'
ParamType = ptUnknown
end>
end
object worker_tr: TIBTransaction
DefaultDatabase = DB
Params.Strings = (
'read_committed'
'rec_version'
'nowait')
AutoStopAction = saCommit
Left = 728
Top = 176
end
object DsWorker: TDataSource
AutoEdit = False
DataSet = Worker_Q
Left = 669
Top = 8
end
object ImgList: TcxImageList
FormatVersion = 1
DesignInfo = 525032
ImageInfo = <
item
Image.Data = {
36040000424D3604000000000000360000002800000010000000100000000100
2000000000000004000000000000000000000000000000000000000000000000
0000000000020000000A170D0738542D1894814626D193502AEA924F2AE87F45
25D0522C17931209053000000009000000010000000000000000000000000000
00030201011159311B97A96239FAC58957FFD6A36DFFDDAF75FFDDAF74FFD6A4
6BFFC58956FFA46137F53C2112730000000F0000000300000000000000020201
0110744226B9BC7C4DFFDDAE77FFDEB076FFE2B782FFE3BB87FFE3BC86FFE1B7
82FFDEAF74FFDBAB72FFBD7E4EFF6F3E24B50000001000000002000000085C36
2095BE8053FFE0B37CFFDFB076FFDEB177FFB78254FFAA7144FFAB7245FFBC88
59FFDFB279FFDFB277FFDEB077FFC08253FF55321D920000000A190F0932B070
47FADFB27DFFDFB27AFFE0B37BFFE0B57DFFA56B3FFFF5EFEAFFF8F3EEFFAB72
45FFE2B67EFFE0B47CFFE0B47BFFDEB079FFB3734AFB130B072F613C2795CD9B
6FFFE2B780FFE5BD89FFE7C291FFE8C393FFA56B3FFFF1E6DEFFF9F5F1FFAA71
44FFE8C494FFE8C393FFE5BF8CFFE1B77FFFD09C6EFF5434218B935E3DD2DCB3
83FFE3B781FFBA8659FFA97043FFAB7245FFAC7346FFF5EDE6FFFAF6F3FFAD75
47FFB0784AFFB17A4BFFC29162FFE4B983FFDEB17EFF8E5B3BD0B0744CF2E3BF
8FFFE4BB84FFA56B3FFFF3EBE6FFFAF6F3FFF6EFE8FFF7F0EAFFFBF7F5FFFAF7
F4FFFAF7F3FFFAF6F2FFAB7245FFE5BD87FFE5BE8BFFAB714CEEAE764FECE9C9
A0FFE5BE89FFA56B3FFFE0D2CAFFE1D3CCFFE3D5CFFFF2EAE4FFF8F3EFFFEADF
D9FFE6DAD4FFE9DED9FFAA7144FFE7C08CFFEACA9DFFAE764FEE9A6A49D0E9CD
ACFFEAC796FFB78456FFA56B3FFFA56B3FFFA56B3FFFF1EAE5FFFAF6F3FFA56B
3FFFA56B3FFFA56B3FFFB78457FFEACA99FFEBD1ADFF996A49D46E4E3697DDBB
9DFFEED3A9FFEECFA2FFEED2A5FFF0D6A9FFA56B3FFFF0EAE7FFFDFCFBFFA56B
3FFFF1D6AAFFF0D5A8FFEED2A5FFEFD4A7FFE0C2A2FF6246318F1C140E2BC794
6CFCF5E8CCFFEFD6ABFFF1D8AEFFF2DAB0FFA56B3FFFDECFC9FFDFD1CBFFA56B
3FFFF3DCB2FFF1DBB0FFF1D8ADFFF7EACDFFC69470FA1A120D2E000000036F52
3C92D7B08CFFF8EFD3FFF3E0B9FFF3DFB7FFB98A5FFFA56B3FFFA56B3FFFBA8A
5FFFF4E1B9FFF4E2BDFFFAF1D5FFD9B390FF664B368C00000006000000010202
0107906C4EB8D9B38FFFF7EDD3FFF8EED0FFF7EBC9FFF6E8C4FFF6E8C5FFF7EC
CAFFF8EED0FFF4E8CDFFD7AF8BFF88664AB30202010B00000001000000000000
00010202010770543F8FCFA078FCE2C4A2FFEBD7B8FFF4E9CDFFF4EACEFFECD8
B9FFE3C5A3FFC59973F24C392A67000000060000000100000000000000000000
000000000001000000022019122C6C543E89A47E5FCCC59770F1C19570EEA47E
60CD6C543F8B16110D2200000003000000010000000000000000}
end
item
Image.Data = {
36040000424D3604000000000000360000002800000010000000100000000100
2000000000000004000000000000000000000000000000000000000000000000
0000000000020000000A170D0738542D1894814626D193502AEA924F2AE87F45
25D0522C17931209053000000009000000010000000000000000000000000000
00030201011159311B97A96239FAC58957FFD6A36DFFDDAF75FFDDAF74FFD6A4
6BFFC58956FFA46137F53C2112730000000F0000000300000000000000020201
0110744226B9BC7C4DFFDDAE77FFDEB076FFDEAF75FFDEAF75FFDEB074FFDDAF
75FFDEAF74FFDBAB72FFBD7E4EFF6F3E24B50000001000000002000000085C36
2095BE8053FFE0B37CFFDFB076FFDEB177FFDFB279FFE0B379FFE0B27AFFE0B2
79FFDFB279FFDFB277FFDEB077FFC08253FF55321D920000000A190F0932B070
47FADFB27DFFDFB27AFFE0B37BFFE0B57DFFE1B67EFFE2B67FFFE2B77FFFE2B7
7FFFE2B67EFFE0B47CFFE0B47BFFDEB079FFB3734AFB130B072F613C2795CD9B
6FFFE2B780FFE5BD89FFE7C291FFE8C393FFE8C494FFE8C594FFE8C495FFE8C4
95FFE8C494FFE8C393FFE5BF8CFFE1B77FFFD09C6EFF5434218B935E3DD2DCB3
83FFE3B781FFBA8659FFA97043FFAB7245FFAC7346FFB0794AFFAB7245FFAD75
47FFB0784AFFB17A4BFFC29162FFE4B983FFDEB17EFF8E5B3BD0B0744CF2E3BF
8FFFE4BB84FFA56B3FFFF5EEE9FFFAF6F3FFFAF7F3FFFBF7F4FFFBF7F5FFFAF7
F4FFFAF7F3FFFAF6F2FFAB7245FFE5BD87FFE5BE8BFFAB714CEEAE764FECE9C9
A0FFE5BE89FFA56B3FFFE6D9D2FFE7DBD4FFE9DED7FFEAE0D9FFEAE0DAFFEBE1
DBFFEBE0DBFFEEE5E1FFAA7144FFE7C08CFFEACA9DFFAE764FEE9A6A49D0E9CD
ACFFEAC796FFB78456FFA56B3FFFA56B3FFFA56B3FFFA56B3FFFA56B3FFFA56B
3FFFA56B3FFFA56B3FFFB78457FFEACA99FFEBD1ADFF996A49D46E4E3697DDBB
9DFFEED3A9FFEECFA2FFEED2A5FFF0D6A9FFF1D7ABFFF1D8ADFFF1D8ADFFF1D8
ADFFF1D6AAFFF0D5A8FFEED2A5FFEFD4A7FFE0C2A2FF6246318F1C140E2BC794
6CFCF5E8CCFFEFD6ABFFF1D8AEFFF2DAB0FFF3DCB3FFF3DEB4FFF3DEB4FFF3DE
B4FFF3DCB2FFF1DBB0FFF1D8ADFFF7EACDFFC69470FA1A120D2E000000036F52
3C92D7B08CFFF8EFD3FFF3E0B9FFF3DFB7FFF4E1B9FFF5E3BBFFF5E2BBFFF5E2
BBFFF4E1B9FFF4E2BDFFFAF1D5FFD9B390FF664B368C00000006000000010202
0107906C4EB8D9B38FFFF7EDD3FFF8EED0FFF7EBC9FFF6E8C4FFF6E8C5FFF7EC
CAFFF8EED0FFF4E8CDFFD7AF8BFF88664AB30202010B00000001000000000000
00010202010770543F8FCFA078FCE2C4A2FFEBD7B8FFF4E9CDFFF4EACEFFECD8
B9FFE3C5A3FFC59973F24C392A67000000060000000100000000000000000000
000000000001000000022019122C6C543E89A47E5FCCC59770F1C19570EEA47E
60CD6C543F8B16110D2200000003000000010000000000000000}
end
item
Image.Data = {
36040000424D3604000000000000360000002800000010000000100000000100
2000000000000004000000000000000000000000000000000000000000000000
00000000000000000000000000000000001F421C11FF30140DEC190A06B30304
075F0000001B0000000500000000000000000000000000000000000000000000
00000000000000000000000000000000001E663C2BE7B9C7D2FF7889A2FF2441
82FF051033AF0000002100000005000000000000000000000000000000000000
0002000000090000000E0000000F0000002041261BAE879AB2FFC8E3F5FF1F66
B6FF2B6BA8FF051236AD0000001F000000040000000000000000000000000000
00088C6657C0C38C7AFFC38C79FFCBA395FFA89894FF488BC3FFDEFEFDFF51B4
E3FF1F68B7FF3173AEFF061538AA0000001C0000000400000000000000000000
000CC5917EFFFDFBFAFFFCF8F6FFFAF7F5FFECEAE9FF7CA3BFFF479FD2FFDEFE
FDFF59BFE9FF216BB9FF367BB3FF07173AA70000001A00000004000000000000
000CC79481FFFEFBFAFFF9F0EAFFF8F0EAFFF7F0EBFFE8E4E1FF7EA4BFFF4BA5
D5FFDEFEFDFF61CAEFFF246FBCFF3B83B9FF081A3DA300000018000000000000
000BC99786FFFEFCFBFFF9F2EDFFF9F2EDFFF9F0EBFFF8F2EDFFEBE7E5FF82A7
C2FF4EAAD7FFDEFEFDFF68D4F4FF2875BEFF3F8BBEFF091B3F9E000000000000
000ACB9C8BFFFEFDFCFFFAF3EFFFFAF4EEFFFAF3EEFFFAF1ECFFF8F2EEFFEDE9
E7FF85ABC7FF51AEDAFFDEFEFDFF6EDDF8FF2C7BC2FF18448BFF000000000000
0009CFA08DFFFEFEFDFFFBF5F1FFFBF5F0FFFBF4F0FFFAF3EFFFFAF3EFFFF8F4
EFFFEFECE9FF89AECAFF54B1DCFFDEFEFDFF4FA6D4FF102C4E93000000000000
0009D0A393FFFEFEFDFFFAF5F3FFFBF6F2FFFBF5F1FFFBF5F0FFFBF5F0FFFAF4
EFFFFAF6F1FFF3EFEDFF83A0B8FF357FBCFF173A598F0000000C000000000000
0008D3A897FFFEFEFEFFFBF6F4FFFBF6F4FFFCF6F3FFFCF6F3FFFCF4F2FFFBF5
F1FFFBF5F0FFFAF6F3FFE2CCC4FF000000160000000600000001000000000000
0007D3AB9AFFFFFEFEFFFCF8F6FFFCF7F5FFFCF7F5FFFBF6F4FFFBF6F4FFFCF6
F3FFFCF6F2FFFBF6F1FFD1A494FF0000000C0000000000000000000000000000
0006D8AE9DFFFFFFFEFFFDF9F7FFFDF9F7FFFCF8F7FFFCF8F6FFFCF7F5FFFBF7
F5FFFBF7F4FFFCF7F3FFD3A897FF0000000B0000000000000000000000000000
0006D8B0A0FFFFFFFFFFFDFAF9FFFDFAF8FFFDFAF8FFFDF9F7FFFCF8F7FFFBF8
F6FFFBF7F6FFFCF7F5FFD4AC9BFF0000000A0000000000000000000000000000
0005D9B3A3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFEFFFFFEFEFFFEFEFEFFFFFE
FEFFFEFEFEFFFEFEFEFFD7AE9EFF000000090000000000000000000000000000
0003A3867AC0DBB5A5FFDAB5A4FFDAB5A4FFDAB4A4FFD9B3A3FFD9B3A3FFD9B3
A2FFD9B2A2FFD8B2A2FFA08377C2000000060000000000000000}
end
item
Image.Data = {
36040000424D3604000000000000360000002800000010000000100000000100
2000000000000004000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000020000000A00000010000000090000000200000000000000000000
00020000000A000000120000000C000000030000000000000000000000000000
00020000000F0F0742921D0F7EEF0603347A0000000E00000002000000020000
000F0804347C1D0F7EF00F084194000000120000000200000000000000000000
0008120B47923233AFFF3648CCFF1D1EA5FF0603357A0000000F0000000F0703
357C1F20A5FF3747CCFF2D2FAEFF120B46950000000B00000000000000000000
000C281C8DF1596CD8FF3B51D3FF3A4FD2FF1E22A6FF0602347D0502357E2022
A6FF3A50D3FF3A50D3FF4C5FD4FF291D8CF10000001000000000000000000000
0006130F3C734D4FBAFF667EE0FF415AD6FF415AD7FF1F24A7FF2529A8FF415A
D7FF415AD7FF5B72DEFF484AB8FF130F3C790000000900000000000000000000
00010000000A16123F73585CC1FF758DE6FF4A64DBFF4A65DBFF4A65DBFF4A64
DBFF6983E3FF5356C0FF16123F780000000C0000000200000000000000000000
0000000000010000000A191643755D63C7FF6783E5FF5774E2FF5774E2FF5774
E2FF565CC6FF1916437A0000000D000000020000000000000000000000000000
00000000000100000009100E3D734A50BEFF7492EBFF6383E7FF6483E7FF6383
E7FF3840B6FF0B0839780000000C000000020000000000000000000000000000
0001000000071413416E555CC5FF85A1EFFF7897EDFF9CB6F4FF9DB7F5FF7997
EEFF7796EDFF414ABCFF0E0C3C730000000A0000000100000000000000000000
00041818456B636CCFFF93AFF3FF83A1F1FFA6BFF7FF676DCAFF7E87DDFFAFC7
F8FF83A3F2FF83A1F1FF5058C4FF121040710000000600000000000000000000
00065759C3EFAFC6F6FF8EADF4FFABC4F8FF6F76D0FF1817456F24244F70868E
E1FFB5CCF9FF8DACF4FFA1B8F4FF5758C3EF0000000900000000000000000000
000331326B8695A0EAFFC0D3F9FF7880D7FF1C1C496B00000006000000072527
526C8B93E6FFC1D3F9FF949EE9FF303168870000000500000000000000000000
00010000000431336B825E62CBEC1F204D680000000500000001000000010000
00052728536B5E62CBEC31326883000000070000000100000000000000000000
0000000000000000000200000004000000020000000100000000000000000000
0001000000030000000500000004000000010000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000}
end
item
Image.Data = {
36040000424D3604000000000000360000002800000010000000100000000100
2000000000000004000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000002000000070000
000D0000000F0000000D00000007000000020000000000000000000000020000
00090000000F00000010000000110000001100000014020101214C28168E8648
27DAA55831FF854627DB4A28158C020100150000000400000000000000098B63
56C1C18977FFC08976FFC08875FFC59584FFCFAFA3FFB0704EFFC07C4AFFDEA6
69FFF4D3A1FFDEA76AFFBF7C4BFF844728D406030217000000020000000CC38E
79FFFDFBFAFFFBF7F4FFFCF6F3FFF7F4F1FFC8A28CFFC48656FFEDBC7CFFEEBF
7FFF83400EFFF2CC94FFEFC181FFC38657FF58321C93000000070000000DC591
7EFFFDFCFBFFF8EFE8FFF7EEE8FFF2EDE9FFBA7D57FFE4B377FFF5D9ABFFF5DA
AFFF8B4914FFF7E3BEFFF6DBB2FFE5B77FFF995C36E30000000B0000000CC794
81FFFEFCFBFFF9F0EAFFF8F0EAFFF3EFECFFBC784FFFF1CE95FF995420FF9752
1DFF934F1CFF904C19FF8D4917FFF5DBAEFFB16F45FA0000000B0000000BC997
86FFFEFDFCFFF9F2EDFFF9F2EDFFF5F0EDFFC68C65FFEFDDB7FFF3CF98FFF5D5
9FFF9B5622FFF7E0B2FFF5D7A4FFEFDDB8FFA46942E2000000080000000ACB9C
8BFFFEFDFDFFFAF3EFFFFAF4EEFFF8F3F0FFDBB9A4FFD8AE86FFF9F3D1FFF8E1
B5FFA35D28FFFAEAC6FFFAF6D5FFD8AF89FF5E3E29850000000400000009CFA0
8DFFFEFEFDFFFBF5F1FFFBF5F0FFFAF4F1FFF6F2EFFFD5A785FFDCB48DFFF2E9
CAFFFAFDE1FFF2E9CAFFDCB38CFF996B4AC80202010A0000000100000009D0A3
93FFFEFEFDFFFAF5F3FFFBF6F2FFFBF5F1FFFBF6F2FFF8F4F0FFE4C9B4FFDAAF
8AFFD8A578FFDBAE8AFFD7B098FF02020117000000010000000000000008D3A8
97FFFEFEFEFFFBF6F4FFFBF6F4FFFCF6F3FFFCF6F3FFFCF5F4FFFAF6F3FFFAF6
F3FFF8F6F3FFFBF9F8FFDAB9ADFF0000000E000000000000000000000007D3AB
9AFFFFFEFEFFFCF8F6FFFCF7F5FFFCF7F5FFFBF6F4FFFBF6F4FFFCF6F3FFFCF6
F2FFFBF6F1FFFDFBF9FFD0A493FF0000000C000000000000000000000006D8AE
9DFFFFFFFEFFFDF9F7FFFDF9F7FFFCF8F7FFFCF8F6FFFCF7F5FFFBF7F5FFFBF7
F4FFFCF7F3FFFDFCFAFFD2A897FF0000000B000000000000000000000006D8B0
A0FFFFFFFFFFFDFAF9FFFDFAF8FFFDFAF8FFFDF9F7FFFCF8F7FFFBF8F6FFFBF7
F6FFFCF7F5FFFEFCFCFFD5AA9AFF0000000B000000000000000000000005D9B3
A3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFEFFFFFEFEFFFEFEFEFFFFFEFEFFFEFE
FEFFFEFEFEFFFEFEFDFFD7AE9EFF00000009000000000000000000000003A386
7AC0DBB5A5FFDAB5A4FFDAB5A4FFDAB4A4FFD9B3A3FFD9B3A3FFD9B3A2FFD9B2
A2FFD8B2A2FFD8B1A1FFA08277C2000000060000000000000000}
end
item
Image.Data = {
36040000424D3604000000000000360000002800000010000000100000000100
2000000000000004000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000002000000070000
000D0000000F0000000D00000007000000020000000000000000000000020000
00090000000F00000010000000110000001100000014020101214C28168E8648
27DAA55831FF854627DB4A28158C020100150000000400000000000000098B63
56C1C18977FFC08976FFC08875FFC59584FFCFAFA3FFB0704EFFC07C4AFFDEA6
69FFEDBC78FFDEA76AFFBF7C4BFF844728D406030217000000020000000CC38E
79FFFDFBFAFFFBF7F4FFFCF6F3FFF7F4F1FFC8A28CFFC48656FFEDBC7CFFEEBF
7FFFEEC183FFEFC383FFEFC181FFC38657FF58321C93000000070000000DC591
7EFFFDFCFBFFF8EFE8FFF7EEE8FFF2EDE9FFBA7D57FFE4B377FFF5D9ABFFF5DA
AFFFF6DCB2FFF6DEB3FFF6DBB2FFE5B77FFF995C36E30000000B0000000CC794
81FFFEFCFBFFF9F0EAFFF8F0EAFFF3EFECFFBC784FFFF1CE95FF99541FFF944E
1BFF8E4A16FF894512FF85400EFFF5DBAEFFB16F45FA0000000B0000000BC997
86FFFEFDFCFFF9F2EDFFF9F2EDFFF5F0EDFFC68C65FFEFDDB7FFF3CF98FFF5D5
9FFFF5D7A4FFF6DAA5FFF5D7A4FFEFDDB8FFA46942E2000000080000000ACB9C
8BFFFEFDFDFFFAF3EFFFFAF4EEFFF8F3F0FFDBB9A4FFD8AE86FFF9F3D1FFF8E1
B5FFF9DFAFFFF9E6BCFFFAF6D5FFD8AF89FF5E3E29850000000400000009CFA0
8DFFFEFEFDFFFBF5F1FFFBF5F0FFFAF4F1FFF6F2EFFFD5A785FFDCB48DFFF2E9
CAFFFAFDE1FFF2E9CAFFDCB38CFF996B4AC80202010A0000000100000009D0A3
93FFFEFEFDFFFAF5F3FFFBF6F2FFFBF5F1FFFBF6F2FFF8F4F0FFE4C9B4FFDAAF
8AFFD8A578FFDBAE8AFFD7B098FF02020117000000010000000000000008D3A8
97FFFEFEFEFFFBF6F4FFFBF6F4FFFCF6F3FFFCF6F3FFFCF5F4FFFAF6F3FFFAF6
F3FFF8F6F3FFFBF9F8FFDAB9ADFF0000000E000000000000000000000007D3AB
9AFFFFFEFEFFFCF8F6FFFCF7F5FFFCF7F5FFFBF6F4FFFBF6F4FFFCF6F3FFFCF6
F2FFFBF6F1FFFDFBF9FFD0A493FF0000000C000000000000000000000006D8AE
9DFFFFFFFEFFFDF9F7FFFDF9F7FFFCF8F7FFFCF8F6FFFCF7F5FFFBF7F5FFFBF7
F4FFFCF7F3FFFDFCFAFFD2A897FF0000000B000000000000000000000006D8B0
A0FFFFFFFFFFFDFAF9FFFDFAF8FFFDFAF8FFFDF9F7FFFCF8F7FFFBF8F6FFFBF7
F6FFFCF7F5FFFEFCFCFFD5AA9AFF0000000B000000000000000000000005D9B3
A3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFEFFFFFEFEFFFEFEFEFFFFFEFEFFFEFE
FEFFFEFEFEFFFEFEFDFFD7AE9EFF00000009000000000000000000000003A386
7AC0DBB5A5FFDAB5A4FFDAB5A4FFDAB4A4FFD9B3A3FFD9B3A3FFD9B3A2FFD9B2
A2FFD8B2A2FFD8B1A1FFA08277C2000000060000000000000000}
end
item
Image.Data = {
36040000424D3604000000000000360000002800000010000000100000000100
2000000000000004000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
00010000000A0D0A0865251A17EC5A4238EC1A13105C00000007000000000000
0000000000000000000000000000000000000000000000000000000000010000
0009130E0C6968554CFEC9AA97FFC8AA97FF584037EA0000000E000000000000
0000000000000000000000000001000000060000000B0000000D000000101812
1069776358FED8BBAAFFD8BBA8FFDCC9BCFF5C433AEC0000000D000000020000
00060000000A0000000D01010119271C1788422D25D84B332BFF3D2921E6836E
63FEDCC1B2FFDCC2B0FFEAD7CCFF917B71FE1F16145F00000005000000068060
54BDC3A396FFCCB5ADFF7A6057FF937A6FFFBFA99CFFDEC8BAFFC7B0A2FFE0C8
B8FFDFC7B7FFE9DACFFF9B857BFF95827AEC000000100000000100000008B78A
79FFF6F0ECFFAB9991FFA08A80FFEEE1D9FFF5EDE7FFF0E4DBFFE9D6C8FFE2CC
BDFFE2CEBFFFA08A80FFBDAFA7FFCDB7AEFF0000000D0000000000000008B98F
7EFFF5EFEBFF8D7368FFC8B6ADFFB4A098FF8F766AFFB09C93FFD8C8BFFFE5CE
BFFFD1B9ABFF82675DFFEDE6E0FFB89182FF0000000C0000000000000007BE93
81FFD3B6A9FF8B6F63FFB7A299FFAE9286FFCDAFA2FFAA8E82FFAF9B92FFE6D1
C3FFE6D2C7FF7E6459FFF1E9E4FFAE806FFF0000000B0000000000000007C197
86FFF7F3F0FF9D857AFFC7B8B0FFD5B8ABFFF8F1EDFFEAE2DDFF71574DFFE7D4
C6FFD2C0B8FF8C746AFFF4ECE8FFB18473FF0000000B0000000000000006C59C
8BFFFBF7F5FFF8F2EEFFF9F2EEFFD9BCAFFFF6F0ECFFA99891FF937C72FFEEE0
D8FFB09C92FFB9A9A2FFF7F0ECFFB58877FF0000000A0000000000000006C9A0
8FFFDCC1B5FFDCC0B3FFDCC0B3FFDABEB2FF9D8175FF8F7A72FFCABAB2FFB6A2
97FF9C8073FFD6B8AEFFDABCB1FFB88D7BFF0000000A0000000000000005CCA4
93FFFDF9F8FFFBF6F4FFFBF7F4FFDBC0B5FFAC958AFF987D6FFFA58E85FFB79C
90FFF6F0EDFFFAF5F2FFFBF6F3FFBC907FFF000000090000000000000005CFA8
97FFFDFAF9FFFBF7F5FFFCF7F5FFDFC5B8FFFAF6F3FFFAF5F3FFF9F5F3FFDDC3
B6FFFCF7F5FFFBF7F4FFFBF7F4FFC09584FF000000080000000000000004C38A
5BFFE6C79EFFD6A771FFD6A56FFFB67948FFD5A26AFFD49F69FFD49E65FFB474
43FFD39961FFD2985FFFD1965EFFB37240FF000000080000000000000004C58E
5EFFF2DBB5FFF2DAB3FFF0D7B0FFC6966BFFEFD4AAFFEFD2A7FFEECFA4FFBE89
5BFFEBCB9CFFEAC99AFFEAC696FFB67744FF000000070000000000000002936A
48BFC68E60FFC58D5FFFC48C5CFFC38A5BFFC28958FFC08756FFC08554FFBE83
52FFBD8150FFBB7F4DFFBA7E4CFF895C36C10000000400000000}
end
item
Image.Data = {
36040000424D3604000000000000360000002800000010000000100000000100
2000000000000004000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000020000
00070000000B0000000C0000000C0000000C0000000C0000000C0000000C0000
000D0000000D0000000C00000008000000020000000000000000000000067F55
48BEB07662FFB07661FFAF7461FFAF7461FFAF7360FFAE735FFFAE735FFFAE72
5EFFAE725EFFAD715DFF7C5143BF00000007000000000000000000000008B57D
6AFFFAF4F0FFF9F3F0FFFAF4EFFFF9F3EFFFF9F3EFFFF9F2EFFFF9F3EFFFF8F3
EEFFF8F2EDFFF8F2EDFFB07562FF0000000A000000000000000000000008BA84
72FFFBF5F2FF8F6F63FF8E6F63FF8E6F63FF8E6F63FF8E6E62FF8D6E62FFF1E6
E1FFF6EEE9FFF9F3F0FFB57D6AFF0000000A000000000000000000000007C08C
7AFFFBF7F4FFA68C81FF907165FF907164FF8F7064FF907165FF9B7F74FFF7EF
EAFFF8EFEAFFFBF5F1FFB98471FF00000009000000000000000000000006C594
83FFFCF8F7FFF7EDEAFFCEBDB6FF937569FF927468FFCAB8B0FFF3EAE5FFF7F0
EBFFF8F0EBFFFBF7F4FFBF8B79FF00000008000000000000000000000005CB9C
8BFFFDFAF8FFF9F1EEFFE7DBD7FF937569FF937569FFE1D4CEFFF8F1EDFFFCF8
F6FFFCF8F6FFFEFCFBFFE3CCC4FF00000007000000000000000000000004CFA3
93FFFDFBFAFFFAF2EEFFC3B0A8FF95786CFF95786CFFC2AFA6FFF9F1EFFFFFFF
FFFF82A9D7FFFFFFFFFF80A9D7FF00000006000000000000000000000004D4A9
9AFFFDFCFBFFF8F0ECFF9B8074FF977B6FFF977B6FFFCCBFBAFFFFFFFFFFFFFF
FFFF1664B9FF4D88C9FF1462B7FF00000005000000000000000000000003D7AF
9FFFFEFCFCFFFAF3F0FFBDAAA0FF9E8377FF9C8175FFDDD2CEFF8FB6DFFF1C6A
BEFF80D2F8FF4EAEE9FF5CC0F8FF1967BCFF0C335C7E0000000000000002D8B0
A1FFFEFDFCFFFEFDFCFFFEFDFCFFFEFDFCFFFEFDFCFFFFFEFEFFFFFFFFFF5B96
D3FF6DBDEDFF6ECBF8FF58B1EAFF185290BE000000000000000000000001A082
77BED8B0A1FFD8B0A1FFD8B0A1FFD8B0A1FFD8B0A1FFECD8D1FF93BBE4FF2879
CAFFABE4FCFF89C9EFFFA7E2FBFF2576C7FF133B648100000000000000000000
0001000000010000000100000001000000010000000100000001000000020000
00022C7FCEFF215F9AC02B7ECDFF000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
00001842687E000000001841687E000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000}
end
item
Image.Data = {
36040000424D3604000000000000360000002800000010000000100000000100
2000000000000004000000000000000000000000000000000000000000000000
0000000000000000000100000008000000130000001A0000001D0000001B0000
0013000000080000000100000000000000000000000000000000000000000000
000000000003000000110D0A05535B321AC37A4424F0874B28FF7A4423F05B32
1BC4170E07550000001200000004000000000000000000000000000000000000
00040102011B112413A0474127FDB07A50FFC38F62FFC99668FFC38F62FF7B6B
4AFF414429FD1A2012A20102011D000000040000000000000000000000010000
0010122B17B0256140FF49916FFF7D7A54FFBE8451FFBD824DFFBE8351FF5F74
52FF399C79FF266342FF1F2716B1000000110000000100000000000000060712
0A56205836FF558B68FF60714DFF867B4FFFC28955FFC28A55FFB28553FF5076
53FF309E75FF3EA07DFF454A30FF21150D5900000006000000000000000B2C2B
1AB75E6C4DFF968455FFCA955FFFDAA96FFFE4B67AFF8E9669FF5E8C65FF47BF
98FF41B68EFF4A8D67FF8F7B56FF5F3F28B80000000D000000000000000E9264
43EACB9A69FFD3A16AFFE6BB80FFEAC48EFFEDCD9EFF90AB8DFF7AD6B8FF6BB3
90FF628860FF73835AFF7C835DFF605336EB00000011000000000000000E6059
3CFA67825DFFC4B07BFFE9C794FFE8D0ABFFE6CFACFFB9C3A4FF98B79DFFC4C7
A7FFE8C995FF7D966DFF53AF8BFF345A3DFA00000010000000000000000B275A
3FE94FAE8BFF809B72FFE7D3B0FF8F7C6BFF897666FFEAD8BCFFEBE0C2FFAAC4
ADFFA0BEA4FF67CBA8FF57C19EFF33593FE90000000D0000000000000007184D
37B04BAA87FF799D75FFCABAA4FF846F61FF897566FFE7DFCCFFF0E8D6FFC9D5
C7FFBEDCD0FF95E7D0FF54BC9CFF2C3E2CB1000000080000000000000003091E
1648477D5EFFC4C4A0FF9A8F82FF837063FF99948DFF9C9CBEFF6265B0FF2029
A3FF1F29A3FF8EC8B1FF469B7BFF171A124B0000000300000000000000000000
0006444A379DABA69AFF09189FFF0C17A7FF0D19A8FF0D1AAEFF1220BDFF3B4F
C8FF5974AEFF7FCAB4FF2752409D000000070000000100000000000000000000
000105040310253575D41C28B7FF6678EDFF3545DCFF212FCAFF4F5FE4FF212C
B6FF75A09CFC3463568F0102010A000000010000000000000000000000000000
00000000020A0D1F9CF13B49D3FF8492F4FF5260DFFF6776E7FF6F7CE1FF4547
9FEC272721480000000500000001000000000000000000000000000000000000
00000001040B1E2CBAFC8F9CF0FF7380E6FF3C49CEFF2E3AC9FF2430BEF7090C
304E000000050000000000000000000000000000000000000000000000000000
0000000000011F288FB52A35BFEE1F278AB010154B6504051321000000080000
0004000000010000000000000000000000000000000000000000}
end
item
Image.Data = {
36040000424D3604000000000000360000002800000010000000100000000100
2000000000000004000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000020000
000A000000160000001B000000170000000B0000000200000000000000010000
00060000000B0000000F0000000C0000000600000001000000000000000F2616
1072583424D8693D2AFF4D2C1FD91D110B750000001200000003000000082416
1162513023CF613927FF45281BD01A0F0A630000000900000001291A136DA380
70FFD4C5BDFFEDE5E1FFCFBEB7FF907163FF1F120C770000000F2C1C1663A181
72FFD4C6BEFFEEE8E4FFCDC0B8FF866A5DFF190E096000000005734937DEE3D7
D1FFCEAE9EFFAF7957FFD0B39EFFD7C9C3FF553324E00000001B77503FD8E2D7
D2FFD0AD9BFFB37753FFD2B29AFFD6CBC5FF4A2B1ED90000000A8E5A47FBF8F6
F4FFAE725BFFE7AF66FFB27F5EFFF0EBE8FF744835FF000000489A6B55FFF8F6
F3FFB27056FFE8AF64FFB67E59FFEAE3DFFF613B29FA0000000B90604DF8F1E8
E4FFD2B0A5FFAA6C53FFD4B6A7FFCDC0BAFF71422FFF4C2920FF80513DFFF1E8
E3FFD3ADA1FFAE684FFFD4B2A1FFC5B6AFFF6A4231F700000009583C31A2CAAF
A3FFF7F2EEFFFDFCFBFFEAE0DAFF9E847AFF774835FF663E36FF855944FFE8D9
CFFFF7F0EDFFFCFAF9FFDFD4CEFF8A6657FF452D229A000000050805041D9F72
5DF8E8DBD4FFE6D7CEFFCDB7AAFF8B6B5EFF7D4C3AFF865F56FF8B5F4BFFE9D8
CEFFEADCD4FFCFB9ACFF997B6DFF966A54F70705041600000001000000076047
3BA4D0B7ADFFEEE3DFFFD5C1B7FF93766CFF82533FFF734635FF926550FFECE0
D9FFEBDED8FFC4B0A5FF9B7868FF5F45389D0000000400000000000000022219
1541B89383FFF3EBE8FFD9C9C2FFA99389FFA67966FF00000026B48B76FFF0E7
E3FFEADED9FFBDA79FFFA67D6CFF211915390000000100000000000000000000
0007846554C6DDCCC4FFE6DCD8FFC2A99EFFA67E69F90000000CB38E79F8E0D1
C9FFE9DFDAFFBCA497FF846555C2000000030000000000000000000000000000
0002130F0D237D6152B7AF8673FA7B6050B9130E0C270000000414100E1E8365
58B3B68F79F9806455B3130F0D1E000000010000000000000000000000000000
0000000000010000000400000006000000050000000200000000000000000000
0001000000010000000100000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000}
end
item
Image.Data = {
36040000424D3604000000000000360000002800000010000000100000000100
2000000000000004000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
00040000000F0000000F00000007000000010000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
000EB0683FFF834324E131190D6A000000110000000600000001000000000000
0000000000000000000000000000000000000000000000000000000000000000
0011B37045FFDEAF77FFB47247FF773C20D2201009500000000F000000050000
0001000000000000000000000000000000000000000000000000000000000000
0010B6764BFFECC38FFFE8BA7DFFD8A66FFFAD693FFF6A371CBE170C06400000
000D000000040000000100000000000000000000000000000000000000000000
000FBB7C51FFEFCD9CFFE9BB7FFFE8BC80FFEABE83FFD39D6CFFA7623BFD5B30
1AA90D07032C0000000B00000003000000010000000000000000000000000000
000EBE8257FFF1D5ACFFEBC087FFE9BF85FFE8BD81FFE9BF82FFE9C087FFCD97
65FF9F5933F74E29169408040221000000090000000200000000000000000000
000DC0855EFFF5DEBBFFEDC68FFFEDC58DFFEBC289FFEAC084FFE8BC80FFE9BD
82FFE8BB87FFC78E60FF965430EE4223137E0000000900000000000000000000
000CC59067FFF9E9CFFFF3D4A3FFF2D09FFFF0CC98FFEEC890FFEBC088FFE9BE
83FFEAC38AFFECC693FFE3B889FFA65B33FF0000000D00000000000000000000
000BC9956EFFFAEFDAFFF4DAAEFFF5D8AAFFF2D5A6FFF1D1A1FFF1D0A2FFF1D2
A8FFEDCDA1FFCC956BFF9A5D39E33A2314680000000700000000000000000000
000ACC9B73FFFCF4E3FFF8E0B7FFF6DDB4FFF6DEB4FFF7E2C0FFF6E1C1FFD9B2
8CFFB0754EF14D301F7E04030216000000060000000100000000000000000000
0009CDA077FFFEF7E9FFFBE7C2FFFBEBCCFFFBEFD6FFE3C5A7FFC08B65F96544
2E960B07051E0000000600000002000000000000000000000000000000000000
0008D0A47CFFFEFBEFFFFDF4E0FFEEDAC1FFD1A07DFF78553CA717100B2C0000
0007000000020000000000000000000000000000000000000000000000000000
0007D2A77FFFF5EADBFFD8B291FF916D50BE261C143C00000007000000020000
0000000000000000000000000000000000000000000000000000000000000000
0005D5AA83FFA98462D3372B204F000000070000000200000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0001000000040000000500000002000000010000000000000000000000000000
0000000000000000000000000000000000000000000000000000}
end
item
Image.Data = {
36040000424D3604000000000000360000002800000010000000100000000100
2000000000000004000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0002000000080000001200000012000000050000000000000000000000000000
0000000000000000000000000000000000000000000000000002000000060000
001332180C6E813C1CE0AC5A2DFF000000130000000000000000000000000000
000000000000000000000000000000000001000000050000000F231209527E40
20D4B67042FFDAA66DFFAE5E30FF000000170000000000000000000000000000
00000000000000000001000000030000000C180E083C733E24BFB66F42FFD6A4
6DFFE4B77BFFE4B77BFFB06034FF000000160000000000000000000000000000
000100000002000000090F090529673E25A8B57548FDD7A674FFE7BF89FFE6BB
80FFE5B87CFFE6B97FFFB26537FF000000150000000000000000000000010000
00070906041C5B3B2590B4774EF7D8A87CFFECCA9AFFEAC38EFFE9C089FFE8BD
84FFE7BA81FFE7BE86FFB4693AFF000000140000000000000000000000065139
2978B17B54ECD7AA82FFEFD1A9FFEFCFA0FFEDC996FFECC793FFEBC490FFE9C1
8AFFE7BE86FFE9C38FFFB56B3FFF00000013000000000000000000000009CB97
6FFFF1DCC1FFF3DCB8FFF3D8AEFFF0D2A4FFF0CFA0FFEFD0A1FFEFCF9FFFEDCC
9BFFEDC996FFEECDA0FFB87043FF000000120000000000000000000000044433
2661AF815BE1DDB693FFF5E0C3FFF8E3C3FFF6DFB9FFF4DAAFFFF2D5AAFFF0D2
A4FFEECE9DFFF1D5ABFFBA7648FF000000110000000000000000000000010000
000405040311533D2B78BF8D67F1E3C2A2FFF8EACEFFF8E6C5FFF5DDB6FFF2D6
ABFFF0D2A4FFF3DBB5FFBD784CFF000000100000000000000000000000000000
000000000001000000050C09061B6B4E3894C79772F8E6C9AAFFFAEBCEFFF6E2
BEFFF2D7ACFFF5E0BCFFBF7C52FF0000000F0000000000000000000000000000
00000000000000000000000000010000000618120C2B7C583FA7D2A17BFFEBD2
B4FFF8E6C8FFF8E7C9FFC18456FF0000000E0000000000000000000000000000
0000000000000000000000000000000000000000000200000007261C133E9167
4AC0D5A881FFEFDABDFFC3875BFF0000000E0000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000020000
000936281C54A37453D5C68C63FF0000000A0000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0001000000030000000800000008000000020000000000000000}
end>
end
object DicServices: TIBQuery
Database = DB
Transaction = DefTr
BufferChunks = 1000
CachedUpdates = True
ParamCheck = True
SQL.Strings = (
'select id, name, 0 as sel from DIC_SERVICES')
UpdateObject = DicServices_upd
GeneratorField.Field = 'ID'
GeneratorField.Generator = 'GEN_DIC_SERVICES_ID'
GeneratorField.ApplyEvent = gamOnPost
Left = 543
Top = 182
end
object DSDicServices: TDataSource
AutoEdit = False
DataSet = DicServices
Left = 543
Top = 241
end
object DSDicMaterials: TDataSource
AutoEdit = False
DataSet = DicMaterials
Left = 487
Top = 269
end
object DicMaterials0: TIBQuery
Database = DB
Transaction = DefTr
BufferChunks = 1000
CachedUpdates = True
ParamCheck = True
SQL.Strings = (
'select m.id, m.name, m.service_id, type_id, mt.name type_name,'
'subtype_id, mts.name subtype_name'
'from dic_materials m left join dic_material_types mt on m.type_i' +
'd=mt.id'
'left join dic_material_subtypes mts on mts.id = m.subtype_id'
'order by service_id, type_id, m.name')
GeneratorField.Field = 'ID'
GeneratorField.Generator = 'GEN_DIC_MATERIALS_ID'
GeneratorField.ApplyEvent = gamOnPost
Left = 487
Top = 210
end
object DicMaterials_upd: TIBUpdateSQL
RefreshSQL.Strings = (
'select m.id, m.name, m.service_id, type_id, mt.name type_name,'
'subtype_id, mts.name subtype_name'
'from dic_materials m left join dic_material_types mt on m.type_i' +
'd=mt.id'
'left join dic_material_subtypes mts on mts.id = m.subtype_id'
'where m.ID = :ID')
ModifySQL.Strings = (
'update DIC_MATERIALS'
'set'
' NAME = :NAME,'
' SERVICE_ID = :SERVICE_ID,'
' SUBTYPE_ID = :SUBTYPE_ID,'
' TYPE_ID = :TYPE_ID'
'where'
' ID = :ID')
InsertSQL.Strings = (
'insert into DIC_MATERIALS'
' (NAME, SERVICE_ID, SUBTYPE_ID, TYPE_ID)'
'values'
' (:NAME, :SERVICE_ID, :SUBTYPE_ID, :TYPE_ID)')
DeleteSQL.Strings = (
'delete from DIC_MATERIALS'
'where'
' ID = :ID')
Left = 488
Top = 320
end
object DicServices_upd: TIBUpdateSQL
RefreshSQL.Strings = (
'Select * from DIC_SERVICES where ID = :ID')
ModifySQL.Strings = (
'update DIC_SERVICES set NAME = :NAME where id = :OLD_ID')
InsertSQL.Strings = (
'INSERT INTO DIC_SERVICES (id, NAME) Values(:id, :NAME)'#9)
DeleteSQL.Strings = (
'delete from DIC_SERVICES'
'where'
' ID = :ID')
Left = 544
Top = 288
end
object DicUserTypes_upd: TIBUpdateSQL
RefreshSQL.Strings = (
'Select * from dic_user_types where ID = :ID')
ModifySQL.Strings = (
'update DIC_USER_TYPES set NAME = :NAME where id = :OLD_ID')
InsertSQL.Strings = (
'INSERT INTO DIC_USER_TYPES (id, NAME) Values(:id, :NAME)'#9)
DeleteSQL.Strings = (
'delete from DIC_USER_TYPES'
'where'
' ID = :OLD_ID')
Left = 600
Top = 304
end
object DicWorkerProfs_upd: TIBUpdateSQL
RefreshSQL.Strings = (
'Select * from DIC_WORKER_PROFS where ID = :ID')
ModifySQL.Strings = (
'update DIC_WORKER_PROFS set NAME = :NAME where id = :OLD_ID')
InsertSQL.Strings = (
'INSERT INTO DIC_WORKER_PROFS (id, NAME) Values(:id, :NAME)'#9)
DeleteSQL.Strings = (
'delete from DIC_WORKER_PROFS'
'where'
' ID = :OLD_ID')
Left = 672
Top = 288
end
object DicMaterialType: TIBQuery
Database = DB
Transaction = DefTr
BufferChunks = 1000
CachedUpdates = True
ParamCheck = True
SQL.Strings = (
'select * from DIC_MATERIAL_TYPES')
UpdateObject = DicMaterialType_upd
GeneratorField.Field = 'ID'
GeneratorField.Generator = 'GEN_DIC_MATERIAL_TYPES_ID'
GeneratorField.ApplyEvent = gamOnServer
Left = 393
Top = 202
end
object DsDicMaterialType: TDataSource
AutoEdit = False
DataSet = DicMaterialType
Left = 393
Top = 250
end
object DicMaterialType_upd: TIBUpdateSQL
RefreshSQL.Strings = (
'Select '
' ID,'
' NAME'
'from DIC_MATERIAL_TYPES '
'where'
' ID = :ID')
ModifySQL.Strings = (
'update DIC_MATERIAL_TYPES'
'set'
' ID = :ID,'
' NAME = :NAME'
'where'
' ID = :OLD_ID')
InsertSQL.Strings = (
'insert into DIC_MATERIAL_TYPES'
' (ID, NAME)'
'values'
' (:ID, :NAME)')
DeleteSQL.Strings = (
'delete from DIC_MATERIAL_TYPES'
'where'
' ID = :OLD_ID')
Left = 394
Top = 296
end
object DicMaterialSubTypes: TIBQuery
Database = DB
Transaction = DefTr
BufferChunks = 1000
CachedUpdates = True
ParamCheck = True
SQL.Strings = (
'select * from DIC_MATERIAL_SUBTYPES')
UpdateObject = DicMaterialSubTypes_upd
GeneratorField.Field = 'ID'
GeneratorField.Generator = 'GEN_DIC_MATERIAL_TYPES_ID'
GeneratorField.ApplyEvent = gamOnPost
Left = 317
Top = 219
end
object DsDicMaterialSubTypes: TDataSource
AutoEdit = False
DataSet = DicMaterialSubTypes
Left = 317
Top = 266
end
object DicMaterialSubTypes_upd: TIBUpdateSQL
RefreshSQL.Strings = (
'Select '
' ID,'
' SERVICE_ID,'
' NAME'
'from DIC_MATERIAL_SUBTYPES '
'where'
' ID = :ID')
ModifySQL.Strings = (
'update DIC_MATERIAL_SUBTYPES'
'set'
' NAME = :NAME,'
' SERVICE_ID = :SERVICE_ID'
'where'
' ID = :OLD_ID')
InsertSQL.Strings = (
'insert into DIC_MATERIAL_SUBTYPES'
' (id, NAME, SERVICE_ID)'
'values'
' (:id, :NAME, :SERVICE_ID)')
DeleteSQL.Strings = (
'delete from DIC_MATERIAL_SUBTYPES'
'where'
' ID = :OLD_ID')
Left = 318
Top = 310
end
object DicMaterials: TIBQuery
Database = DB
Transaction = DefTr
BufferChunks = 1000
CachedUpdates = True
ParamCheck = True
SQL.Strings = (
'select * from get_materials_tree')
UpdateObject = DicMaterials_upd
GeneratorField.Field = 'ID'
GeneratorField.Generator = 'GEN_DIC_MATERIALS_ID'
GeneratorField.ApplyEvent = gamOnPost
Left = 488
Top = 160
end
object DicFormatsCli: TIBQuery
Database = DB
Transaction = DefTr
BufferChunks = 1000
CachedUpdates = True
ParamCheck = True
SQL.Strings = (
'select * from DIC_FORMATS_CLI')
Left = 250
Top = 203
end
object DsFormatsCli: TDataSource
AutoEdit = False
DataSet = DicFormatsCli
Left = 250
Top = 248
end
object Clients: TIBQuery
Database = DB
Transaction = Clients_tr
ObjectView = True
FieldOptions.UpdatePersistent = True
BufferChunks = 1000
CachedUpdates = True
ParamCheck = True
SQL.Strings = (
'select * from clientslist(null, null)')
UpdateObject = Clients_upd
GeneratorField.Field = 'ID'
GeneratorField.Generator = 'GEN_CLIENTS_ID'
GeneratorField.ApplyEvent = gamOnPost
Left = 160
Top = 24
end
object Clients_upd: TIBUpdateSQL
RefreshSQL.Strings = (
'select * from clientslist(:id, null)')
ModifySQL.Strings = (
'update clients'
'set'
'NAME'#9#9'= :NAME,'
'TYPE_CLI'#9#9'= :TYPE_CLI,'
'STATUS_ID'#9'= :STATUS_ID,'
'FORMAT_ID'#9'= :FORMAT_ID,'
'PERSON_ID'#9'= :PERSON_ID,'
'ADRES_ID'#9'= :ADRES_ID,'
'EMAIL'#9#9'= :EMAIL,'
'WORKER_ID'#9'= :WORKER_ID,'
'COMMENT'#9'= :COMMENT,'
'ACT = :ACT,'
'DOG_NUM = :DOG_NUM,'
'DOG_DATE = :DOG_DATE,'
'REGION_ID = :REGION_ID,'
'GOODS = :GOODS,'
'DOG_TYPE_ID = :DOG_TYPE_ID,'
'AREA_ID = :AREA_ID,'
'AREA_UNIT_ID = :AREA_UNIT_ID'
'where id = :ID')
InsertSQL.Strings = (
'insert into clients('
'NAME,'
'TYPE_CLI,'
'STATUS_ID,'
'FORMAT_ID,'
'PERSON_ID,'
'ADRES_ID,'
'EMAIL,'
'WORKER_ID,'
'COMMENT,'
'ACT,'
'DOG_NUM,'
'DOG_DATE,'
'REGION_ID,'
'GOODS,'
'DOG_TYPE_ID,'
'AREA_ID,'
'AREA_UNIT_ID)'
'values'
'('
':NAME,'
':TYPE_CLI,'
':STATUS_ID,'
':FORMAT_ID,'
':PERSON_ID,'
':ADRES_ID,'
':EMAIL,'
':WORKER_ID,'
':COMMENT,'
':ACT,'
':DOG_NUM,'
':DOG_DATE,'
':REGION_ID,'
':GOODS,'
':DOG_TYPE_ID,'
':AREA_ID,'
':AREA_UNIT_ID'
')')
DeleteSQL.Strings = (
'update clients set act=0 where id=:id')
Left = 216
Top = 24
end
object Clients_tr: TIBTransaction
Active = True
DefaultDatabase = DB
Params.Strings = (
'read_committed'
'rec_version'
'nowait')
AutoStopAction = saCommitRetaining
Left = 272
Top = 24
end
object DsClients: TDataSource
AutoEdit = False
DataSet = Clients
OnDataChange = DsWorkerDataChange
Left = 333
Top = 24
end
object DicStatusCli: TIBQuery
Database = DB
Transaction = DefTr
BufferChunks = 1000