-
Notifications
You must be signed in to change notification settings - Fork 6
/
Copy pathuCategoriesLoader.pas
387 lines (344 loc) · 16.8 KB
/
uCategoriesLoader.pas
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
unit uCategoriesLoader;
{******************************************************************************}
{* Categories Loader Unit *}
{* Revolutionary Confederation of Anarcho Syndicalists *}
{* Written by: black.rabbit 2011 *}
{******************************************************************************}
interface
{$I 'std.inc'}
uses
Windows, SysUtils, Variants, Classes,
Controls, ComCtrls, Gauges,
{ utils }
DateUtils, Utils, Strings, VarRecs, Versions, EClasses,
DllThreads,
{ kernel }
Kernel, ProtoClasses, CryptoClasses, MetaClasses, ParaClasses,
HypoClasses, HyperClasses,
{ engine }
Engine,
{ SQLite }
SQLite3, SQLite3DLL, SQLiteTable3;
type
{ çàãðóç÷èê êàòåãîðèé }
{$M+}
CCategoriesLoader = class of TCategoriesLoader;
PCategoriesLoader = ^TCategoriesLoader;
TCategoriesLoader = class (TDllThread)
private
f_DBFileName: String; { ôàéë áàçû äàííûõ }
f_DB: TSQLiteDatabase; { îáúåêò áàçû äàííûõ }
f_TreeNodes: TTreeNodes; { äåðåâî }
f_Gauge: TGauge; { ïîêàçàòåëü ïðîãðåññà çàãðóçêè }
f_StatusPanel: TStatusPanel; { ñòðîêà ñîñòîÿíèÿ çàãðóçêè }
f_ParentNode: TTreeNode; { óçåë, ñîäåðæàùèé èäåíòèôèêàòîð ïðåäêà òåêóùåé êàòåãîðèè }
f_CategorieID: TID; { èäåíòèôèêàòîð òåêóùåé êàòåãîðèè }
f_Children: TCategories; { ïîòîìêè òåêóùåé êàòåãîðèè }
f_ChildIndex: LongInt; { ïîçèöèÿ â îáõîäå ïîòîìêîâ }
public
constructor Create (anArgs: array of const); override;
destructor Destroy; override;
public
procedure Main; override;
procedure Return; override;
protected
procedure WriteStatus (const aMessage: String); overload;
procedure WriteStatus (const aMessage: String;
aParams: array of const); overload;
public
property DBFileName: String read f_DBFileName;
property DB: TSQLiteDatabase read f_DB write f_DB;
property TreeNodes: TTreeNodes read f_TreeNodes write f_TreeNodes;
property Gauge: TGauge read f_Gauge write f_Gauge;
property StatusPanel: TStatusPanel read f_StatusPanel write f_StatusPanel;
property ParentNode: TTreeNode read f_ParentNode write f_ParentNode;
property CategorieID: TID read f_CategorieID write f_CategorieID;
property Children: TCategories read f_Children write f_Children;
property ChildIndex: LongInt read f_ChildIndex write f_ChildIndex;
end;
{$M-}
{ TCategoriesLoader Errors }
resourcestring
ERR_TCATEGORIESLOADER_INCORRECT_DATABASE = 'Íå èíèöèàëèçèðîâàí îáúåêò ÁÄ!';
ERR_TCATEGORIESLOADER_INCORRECT_NODES = 'Îáúåêò äåðåâà íå èíèöèàëèçèðîâàí!';
ERR_TCATEGORIESLOADER_INCORRECT_NODE = 'Îáúåêò óçëà äåðåâà íå èíèöèàëèçèðîâàí!';
ERR_TCATEGORIESLOADER_INCORRECT_ID = 'Óçåë äåðåâà ñîäåðæèò íåêîððåêòíûé èäåíòèôèêàòîð!';
ERR_TCATEGORIESLOADER_INCORRECT_GAUGE = 'Íå èíèöèàëèçèðîâàí ýëåìåíò êîíòðîëÿ ïðîãðåññà!';
ERR_TCATEGORIESLOADER_INCORRECT_STATUS_PANEL = 'Íå èíèöèàëèçèðîâàíà ñòðîêà ñîñòîÿíèÿ!';
ERR_TCATEGORIESLOADER_CREATE = 'Îøèáêà ñîçäàíèÿ ïîòîêà çàãðóçêè äåðåâà êàòåãîðèé!';
ERR_TCATEGORIESLOADER_DESTROY = 'Îøèáêà óíè÷òîæåíèÿ ïîòîêà çàãðóçêè äåðåâà êàòåãîðèé!';
ERR_TCATEGORIESLOADER_MAIN = 'Îøèáêà ãëàâíîé ôóíêöèè ïîòîêà!';
ERR_TCATEGORIESLOADER_RETURN = 'Îøèáêà ôóíêöèè âîçâðàòà ïîòîêà!';
ERR_TCATEGORIESLOADER_WRITE_STATUS = 'Îøèáêà îòîáðàæåíèÿ ñòàòóñà!';
{ TCategoriesLoader Hints }
resourcestring
MSG_TCATEGORIESLOADER_LOAD_OBJECT = 'Çàãðóçêà ''%s'' ...';
MSG_TCATEGORIESLOADER_LOAD_OBJECT_PROPERTY = 'Çàãðóçêà ''%s'' ... %s';
implementation
{ TCategoriesLoader }
constructor TCategoriesLoader.Create (anArgs: array of const);
var
I : Integer;
args : array_of_const;
OBJ : TObject;
begin
try
{ ïåðåäàåì ïàðàìåòðû ñîçäàíèÿ áàçîâîãî ïîòîêà,
íà÷èíàÿ ñ ñåäüìîãî àðãóìåíòà }
if ( High (anArgs) >= 6 ) then
begin
SetLength ( Args, High (anArgs)-6 +1 );
for I := 6 to High (anArgs) do
args [I-6] := anArgs [I];
end
else
args := _array_of_const ([]);
inherited Create (args);
{ ÿâíî óêàçûâàåì íà íåîáõîäèìîñòü óíè÷òîæåíèÿ ïîòîêà ïî îêîí÷àíèþ ðàáîòû }
FreeOnTerminate := TRUE;
{ èìÿ ïîòîêà }
Name := ClassName;
{ ïåðâûé ïàðàìåòð - ôàéë ÁÄ }
f_DBFileName := '';
f_DB := NIL;
if notEmpty (0,anArgs) then
begin
f_DBFileName := toString (anArgs [0]);
f_DB := TSQLiteDatabase.Create (f_DBFileName);
end;
if ( not Assigned (f_DB) ) then
raise Exception.Create (ERR_TCATEGORIESLOADER_INCORRECT_DATABASE);
{ âòîðîé ïàðàìåòð - TreeNodes
äåðåâî, êóäà áóäóò çàãðóæàòüñÿ êàòåãîðèè }
f_TreeNodes := NIL;
if notEmpty (1,anArgs) then
begin
OBJ := toObject (anArgs [1]);
if ( Assigned (OBJ) and OBJ.InheritsFrom (TTreeNodes) ) then
f_TreeNodes := TTreeNodes (OBJ);
end;
if ( not Assigned (f_TreeNodes) ) then
raise Exception.Create (ERR_TCATEGORIESLOADER_INCORRECT_NODES);
{ òðåòèé ïàðàìåòð - ParentNode
óçåë, ñîäåðæàùèé èäåíòèôèêàòîð ïðåäêà òåêóùåé êàòåãîðèè }
f_ParentNode := NIL;
if notEmpty (2,anArgs) then
begin
OBJ := toObject (anArgs [2]);
if ( Assigned (OBJ) and OBJ.InheritsFrom (TTreeNode) ) then
f_ParentNode := TTreeNode (OBJ);
end;
{if ( not Assigned (f_ParentNode) ) then
raise Exception.Create (ERR_TCATEGORIESLOADER_INCORRECT_NODE);}
{ ÷åòâåðòûé ïàðàìåòð - CategorieID
òåêóùàÿ êàòåãîðèÿ }
f_CategorieID := 0;
if notEmpty (3,anArgs) then
begin
f_CategorieID := toInt64 (anArgs [3]);
end;
if ( f_CategorieID <= 0 ) then
raise Exception.Create (ERR_TCATEGORIESLOADER_INCORRECT_ID);
{ ïÿòûé ïàðàìåòð - Gauge
ïîêàçàòåëü ïðîãðåññà çàãðóçêè }
f_Gauge := NIL;
if notEmpty (4,anArgs) then
begin
OBJ := toObject (anArgs [4]);
if ( Assigned (OBJ) and OBJ.InheritsFrom (TControl) ) then
f_Gauge := TGauge (OBJ);
end;
{if ( not Assigned (f_Gauge) ) then
raise Exception.Create (ERR_TCATEGORIESLOADER_INCORRECT_GAUGE);}
{ øåñòîé ïàðàìåòð - StatusPanel
ïîêàçàòåëü ïðîãðåññà çàãðóçêè }
f_StatusPanel := NIL;
if notEmpty (5,anArgs) then
begin
OBJ := toObject (anArgs [5]);
if ( Assigned (OBJ) and OBJ.InheritsFrom (TStatusPanel) ) then
f_StatusPanel := TStatusPanel (OBJ);
end;
{if ( not Assigned (f_StatusPanel) ) then
raise Exception.Create (ERR_TCATEGORIESLOADER_INCORRECT_STATUS_PANEL);}
f_Children := NIL;
f_ChildIndex := -1;
except on E: Exception do
_raise ([ 'Create', ERR_TCATEGORIESLOADER_CREATE, E, Exception (FatalException) ],
['{D1C22245-693F-44A1-B1D0-18EF3798C90C}']);
end;
end;
destructor TCategoriesLoader.Destroy;
begin
try
FreeAndNil (f_Children);
FreeAndNil (f_DB);
inherited Destroy;
except on E: Exception do
_raise ([ 'Destroy', ERR_TCATEGORIESLOADER_DESTROY, E, Exception (FatalException) ],
['{0A0FF0E4-5255-420A-892D-2C492BBBF52B}']);
end;
end;
procedure TCategoriesLoader.Main;
begin
try
if Terminated then Exit;
inherited Main;
if not Assigned (Children) then
f_Children := TCategories.Load (DB,[ _([]),
_([CategorieID]),
_([]),
_([USER_ID]),
_([]),
_([CATEGORIE_OPENED_STATUS_ID,
CATEGORIE_CLOSED_STATUS_ID]) ]) as TCategories;
except on E: Exception do
_raise ([ 'Main', ERR_TCATEGORIESLOADER_MAIN, E, Exception (FatalException) ],
['{FEE108D9-BDF2-4E0F-A99B-BC3F6400F47C}']);
end;
end;
procedure TCategoriesLoader.Return;
var
Node : TTreeNode;
begin
try
if Terminated then Exit;
if ( not Assigned (Children) or (Children.Count <= 0) ) then
begin
SetTabStatus (tabForum,tbsLoaded);
Terminate;
end
else if ChildIndex >= Children.Count-1 then
begin
SetTabStatus (tabForum,tbsLoaded);
Terminate;
end
else
try
inherited Return;
ChildIndex := ChildIndex + 1;
if Assigned (StatusPanel) then
StatusPanel.Text := Format (MSG_TCATEGORIESLOADER_LOAD_OBJECT,
[ Children.ItemAt [ChildIndex].Name ]);
Node := TreeNodes.AddChild ( ParentNode,
{Format (' %s '#13#10' %s ',
[ Children.ItemAt [ChildIndex].Name,
Children.ItemAt [ChildIndex].Description ])}
''
);
Node.ImageIndex := Children.ItemAt [ChildIndex].IndexPic*4 + 0;
Node.Data := CreateCategorieNode;
with PCategorieNode (Node.Data)^ do
begin
//WriteStatus (MSG_TCATEGORIESLOADER_LOAD_OBJECT_PROPERTY,
// [ Children.ItemAt [ChildIndex].Name,
// Children.ItemAt [ChildIndex].PropAt [_ctg_id].Caption ]);
ID := Children.ItemAt [ChildIndex].ID;
//WriteStatus (MSG_TCATEGORIESLOADER_LOAD_OBJECT_PROPERTY,
// [ Children.ItemAt [ChildIndex].Name,
// Children.ItemAt [ChildIndex].PropAt [_ctg_id_parent].Caption ]);
IDParent := Children.ItemAt [ChildIndex].IDparent;
//WriteStatus (MSG_TCATEGORIESLOADER_LOAD_OBJECT_PROPERTY,
// [ Children.ItemAt [ChildIndex].Name,
// Children.ItemAt [ChildIndex].PropAt [_ctg_id_author].Caption ]);
IDAuthor := Children.ItemAt [ChildIndex].IDAuthor;
//WriteStatus (MSG_TCATEGORIESLOADER_LOAD_OBJECT_PROPERTY,
// [ Children.ItemAt [ChildIndex].Name,
// Children.ItemAt [ChildIndex].PropAt [_ctg_id_type].Caption ]);
IDType := Children.ItemAt [ChildIndex].IDType;
//WriteStatus (MSG_TCATEGORIESLOADER_LOAD_OBJECT_PROPERTY,
// [ Children.ItemAt [ChildIndex].Name,
// Children.ItemAt [ChildIndex].PropAt [_ctg_id_status].Caption ]);
IDStatus := Children.ItemAt [ChildIndex].IDStatus;
//WriteStatus (MSG_TCATEGORIESLOADER_LOAD_OBJECT_PROPERTY,
// [ Children.ItemAt [ChildIndex].Name,
// Children.ItemAt [ChildIndex].PropAt [_ctg_id_pic].Caption ]);
IDPic := Children.ItemAt [ChildIndex].IDPic;
//WriteStatus (MSG_TCATEGORIESLOADER_LOAD_OBJECT_PROPERTY,
// [ Children.ItemAt [ChildIndex].Name,
// Children.ItemAt [ChildIndex].PropAt [_ctg_index_pic].Caption ]);
IndexPic := Children.ItemAt [ChildIndex].IndexPic;
//WriteStatus (MSG_TCATEGORIESLOADER_LOAD_OBJECT_PROPERTY,
// [ Children.ItemAt [ChildIndex].Name,
// Children.ItemAt [ChildIndex].PropAt [_ctg_name].Caption ]);
Name := Children.ItemAt [ChildIndex].Name;
//WriteStatus (MSG_TCATEGORIESLOADER_LOAD_OBJECT_PROPERTY,
// [ Children.ItemAt [ChildIndex].Name,
// Children.ItemAt [ChildIndex].PropAt [_ctg_description].Caption ]);
Description := Children.ItemAt [ChildIndex].Description;
//WriteStatus (MSG_TCATEGORIESLOADER_LOAD_OBJECT_PROPERTY,
// [ Children.ItemAt [ChildIndex].Name,
// Children.ItemAt [ChildIndex].Author.PropAt [_usr_login].Caption ]);
Author := Children.ItemAt [ChildIndex].Author.Login;
//WriteStatus (MSG_TCATEGORIESLOADER_LOAD_OBJECT_PROPERTY,
// [ Children.ItemAt [ChildIndex].Name,
// Children.ItemAt [ChildIndex].PropAt [_ctg_time_stamp_create].Caption ]);
TimeStampCreate := Children.ItemAt [ChildIndex].TimeStampCreate;
//WriteStatus (MSG_TCATEGORIESLOADER_LOAD_OBJECT_PROPERTY,
// [ Children.ItemAt [ChildIndex].Name,
// Children.ItemAt [ChildIndex].PropAt [_ctg_time_stamp_modify].Caption ]);
TimeStampModify := Children.ItemAt [ChildIndex].TimeStampModify;
//WriteStatus (MSG_TCATEGORIESLOADER_LOAD_OBJECT_PROPERTY,
// [ Children.ItemAt [ChildIndex].Name,
// Children.ItemAt [ChildIndex].PropAt [_ctg_time_stamp_public].Caption ]);
TimeStampPublic := Children.ItemAt [ChildIndex].TimeStampPublic;
//WriteStatus (MSG_TCATEGORIESLOADER_LOAD_OBJECT_PROPERTY,
// [ Children.ItemAt [ChildIndex].Name,
// Children.ItemAt [ChildIndex].PropAt [_ctg_key_hash].Caption ]);
KeyHash := Children.ItemAt [ChildIndex].KeyHash;
//WriteStatus (MSG_TCATEGORIESLOADER_LOAD_OBJECT_PROPERTY,
// [ Children.ItemAt [ChildIndex].Name,
// Children.ItemAt [ChildIndex].PropAt [_ctg_data_hash].Caption ]);
DataHash := Children.ItemAt [ChildIndex].DataHash;
// ïîäñ÷åò êîëè÷åñòâà ñîîáùåíèé
MsgCount := TMessages.GetCount (DB,[ _([]),
_([ Children.ItemAt [ChildIndex].ID ]),
_([]),
_([USER_ID]),
_([MESSAGE_FORUM_TYPE_ID]),
_([MESSAGE_ACTIVE_STATUS_ID]) ]);
end;
if Assigned (Gauge) then
Gauge.Progress := Gauge.Progress + 1;
{ ðàñïàðàëåëèâàåì ðåêóðñèþ }
if Assigned (Owner) then
Owner.Add ( TCategoriesLoader.Create ([ DBFileName,
TreeNodes,
Node,
Children.ItemAt [ChildIndex].ID,
Gauge,
StatusPanel,
FALSE,
TRUE ]) );
except on E: Exception do
WriteStatus (E.Message);
end;
except on E: Exception do
_raise ([ 'Return', ERR_TCATEGORIESLOADER_RETURN, E, Exception (FatalException) ],
['{21121ED6-8F56-4ED8-B2AA-FC1B7EACEF82}']);
end;
end;
procedure TCategoriesLoader.WriteStatus (const aMessage: String);
begin
try
if Assigned (StatusPanel) then
begin
StatusPanel.Text := aMessage;
ProcessMessages;
end;
except on E: Exception do
_raise (['WriteStatus',ERR_TCATEGORIESLOADER_WRITE_STATUS,E],
['{D589475D-1FD3-437E-94EC-CC9DCD834F17}']);
end;
end;
procedure TCategoriesLoader.WriteStatus (const aMessage: String;
aParams: array of const);
begin
try
WriteStatus ( Format (aMessage,aParams) );
except on E: Exception do
_raise (['WriteStatus',ERR_TCATEGORIESLOADER_WRITE_STATUS,E],
['{5587B7DB-F6AA-411B-B53F-249D7D510F16}']);
end;
end;
end.