[800] | 1 | unit uLogic;
|
---|
| 2 |
|
---|
| 3 | interface
|
---|
| 4 |
|
---|
| 5 | uses
|
---|
| 6 | Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
|
---|
| 7 | Dialogs, StdCtrls, Buttons, ExtCtrls, ORNet, ORFn,ComCtrls,Trpcb, ORCtrls;
|
---|
| 8 |
|
---|
| 9 |
|
---|
| 10 | const
|
---|
| 11 | INT_COMPONENT_SPACING = 4;
|
---|
| 12 | INT_CBO_CONDITIONLEFT = 3;
|
---|
| 13 | INT_CBO_CONDITIONWIDTH = 50;
|
---|
| 14 |
|
---|
| 15 | INT_CBO_FILELEFT = INT_CBO_CONDITIONLEFT + INT_CBO_CONDITIONWIDTH + INT_COMPONENT_SPACING;
|
---|
| 16 | INT_CBO_FILEWIDTH = 177;
|
---|
| 17 |
|
---|
| 18 | INT_CBO_FIELDLEFT = INT_CBO_FILELEFT + INT_CBO_FILEWIDTH + INT_COMPONENT_SPACING;
|
---|
| 19 | INT_CBO_FIELDWIDTH = 177;
|
---|
| 20 |
|
---|
| 21 | INT_CBO_OPERATORLEFT = INT_CBO_FIELDLEFT + INT_CBO_FIELDWIDTH + INT_COMPONENT_SPACING;
|
---|
| 22 | INT_CBO_OPERATORWIDTH = 113;
|
---|
| 23 |
|
---|
| 24 | INT_EDIT_VALUELEFT = INT_CBO_OPERATORLEFT + INT_CBO_OPERATORWIDTH + INT_COMPONENT_SPACING;
|
---|
| 25 | INT_EDIT_VALUEWIDTH = 169;
|
---|
| 26 |
|
---|
| 27 | INT_EDIT_LOWERLEFT = INT_CBO_OPERATORLEFT + INT_CBO_OPERATORWIDTH + INT_COMPONENT_SPACING;
|
---|
| 28 | INT_EDIT_LOWERWIDTH = 100;
|
---|
| 29 |
|
---|
| 30 | INT_EDIT_UPPERLEFT = INT_EDIT_LOWERLEFT + INT_EDIT_LOWERWIDTH + INT_COMPONENT_SPACING;
|
---|
| 31 | INT_EDIT_UPPERWIDTH = 100;
|
---|
| 32 |
|
---|
| 33 | INT_BUTTON_LEFT = INT_EDIT_VALUELEFT + INT_EDIT_VALUEWIDTH + INT_COMPONENT_SPACING;
|
---|
| 34 | INT_BUTTON_SIZE = 23;
|
---|
| 35 |
|
---|
| 36 | INT_ADD_QUERYROW_BTN_LEFT = INT_CBO_CONDITIONLEFT;
|
---|
| 37 | INT_ADD_QUERYROW_LABEL_LEFT = INT_ADD_QUERYROW_BTN_LEFT + 30;
|
---|
| 38 | INT_ADD_QUERYROW_LABEL_CAPTION = 'Add another term to query';
|
---|
| 39 |
|
---|
| 40 | TAG_FILE_BOX = 0;
|
---|
| 41 | TAG_FIELD_BOX = 1;
|
---|
| 42 | TAG_RECORD_BOX = 2;
|
---|
| 43 |
|
---|
| 44 | LABEL_LEFT_OFFSET = 2;
|
---|
| 45 | FIELDS_TOP_OFFSET = 30;
|
---|
| 46 | INDENT_OFFSET = 30;
|
---|
| 47 | OPEN_BOX_HEIGHT = 120;
|
---|
| 48 | OPERATOR_BOX_HEIGHT = 150;
|
---|
| 49 | CLOSE_BOX_HEIGHT = 21;
|
---|
| 50 | ROW_HEIGHT = 30;
|
---|
| 51 | ADD_QUERY_OFFSET = OPEN_BOX_HEIGHT + INT_COMPONENT_SPACING;
|
---|
| 52 |
|
---|
| 53 | CL_LT_RED = $6C6CBA;
|
---|
| 54 | Colors : Array[false..true] of TColor = (clWindow, CL_LT_RED);
|
---|
| 55 | SearchCaption : Array[false..true,false..true] of String[30] = (
|
---|
| 56 | ('Search Value', 'Enter Lower ... Upper Value'), //Advanced Mode
|
---|
| 57 | ('Enter Value to Search For', 'Enter Lower && Upper Values') //Simple Mode
|
---|
| 58 | );
|
---|
| 59 |
|
---|
| 60 | COMB_EQUALS = '=^= EQUALS';
|
---|
| 61 | COMB_NOT_EQUAL = '''=^<>, DOES NOT EQUAL';
|
---|
| 62 | COMB_LESS_THAN = '<^<, LESS THAN';
|
---|
| 63 | COMB_LESS_THAN_OR_EQUALS = '<=^<=, LESS THAN OR EQUAL TO';
|
---|
| 64 | COMB_GREATER_THAN = '>^>, GREATER THAN';
|
---|
| 65 | COMB_GREATER_THAN_OR_EQUALS = '>=^>=, GREATER OR EQUAL TO';
|
---|
| 66 | COMB_IN_RANGE = '{^IN RANGE';
|
---|
| 67 | COMB_NOT_IN_RANGE = '''{^NOT IN RANGE';
|
---|
| 68 | COMB_CONTAINS = '[^CONTAINS';
|
---|
| 69 | COMB_NOT_CONTAINS = '''[^DOES NOT CONTAIN';
|
---|
| 70 |
|
---|
| 71 |
|
---|
| 72 | type
|
---|
| 73 | TValueMode = (vmUnknown,vmString,vmDate,vmNumeric,vmRange,vmSet,vmPointer);
|
---|
| 74 | TFieldDataType = (fdtUnknown,fdtText,fdtSet,fdtDate,fdtWP,fdtPointer);
|
---|
| 75 |
|
---|
| 76 | TLogicSet = class; //a forward
|
---|
| 77 | TLogicRow = class(TObject)
|
---|
| 78 | private
|
---|
| 79 | { Private declarations }
|
---|
| 80 | FIndentLevel : integer;
|
---|
| 81 | FSearchValueMode : TValueMode;
|
---|
| 82 | FSearchFileNumber : string;
|
---|
| 83 | FSearchFileName : string;
|
---|
| 84 | FParentSet : TLogicSet;
|
---|
| 85 | FRowNum : integer; //starts numbering at 0
|
---|
| 86 | FCurFieldDef : string;
|
---|
| 87 | FInfoPiece3 : string;
|
---|
| 88 | FVisible : boolean;
|
---|
| 89 | FTop : integer;
|
---|
| 90 | FSimpleMode : boolean;
|
---|
| 91 | FNewGroupStarter : boolean;
|
---|
| 92 | ValueEdit: TEdit; //Will double as Lower value if entering a range.
|
---|
| 93 | UpperValueEdit: TEdit;
|
---|
| 94 | DatePicker : TDateTimePicker;
|
---|
| 95 | UpperDatePicker : TDateTimePicker;
|
---|
| 96 | SetPicker : TComboBox;
|
---|
| 97 | RecordPickerBox : TORComboBox;
|
---|
| 98 | DelButton : TSpeedButton;
|
---|
| 99 | FRowOpen : boolean;
|
---|
| 100 | procedure SetIndentLevel(Value : integer);
|
---|
| 101 | procedure LoadOperator(CmbBox: TORComboBox);
|
---|
| 102 | procedure LoadCondition(CmbBox: TORComboBox);
|
---|
| 103 | procedure ConditionChange(Sender: TObject);
|
---|
| 104 | procedure DelButtonClick(Sender : TObject);
|
---|
| 105 | procedure ORBoxNeedData(Sender: TObject; const StartFrom: String;
|
---|
| 106 | Direction, InsertAt: Integer);
|
---|
| 107 | procedure FileBoxChange(Sender: TObject);
|
---|
| 108 | function SubSetOfAllowedFiles(SimpleMode : boolean;
|
---|
| 109 | FileNum: string; const StartFrom: string;
|
---|
| 110 | Direction: Integer ): TStrings;
|
---|
| 111 | function SubSetOfFile(FileNum: string; const StartFrom: string;
|
---|
| 112 | Direction: Integer ): TStrings;
|
---|
| 113 | procedure FieldBoxChange(Sender: TObject);
|
---|
| 114 | procedure RecordPickerBoxChange(Sender: TObject);
|
---|
| 115 | procedure DatePickerChange(Sender: TObject);
|
---|
| 116 | procedure OperatorBoxChange(Sender: TObject);
|
---|
| 117 | procedure EditBoxChange(Sender: TObject);
|
---|
| 118 | procedure SetPickerChange(Sender: TObject);
|
---|
| 119 | function SubSetOfFields(SimpleMode : boolean; FileNum: string;
|
---|
| 120 | const StartFrom: string; Direction: Integer): TStrings;
|
---|
| 121 | function ExtractNum (S : String; StartPos : integer) : string;
|
---|
| 122 | procedure EnsureProperValueFieldVisible;
|
---|
| 123 | function IsWPField(FileNum,FieldNum : string) : boolean;
|
---|
| 124 | procedure InitORComboBox(ORComboBox: TORComboBox; initValue : string; boxtype : string);
|
---|
| 125 | function GetSearchValue() : string;
|
---|
| 126 | procedure SetVisible(Value : Boolean);
|
---|
| 127 | procedure PrepSetPicker(setDef : string);
|
---|
| 128 | procedure SetNewGroupStarter(value : boolean);
|
---|
| 129 | procedure SetRowNum(value : integer); //This won't change position in parent LogicSet
|
---|
| 130 | procedure CheckVisibilityIsCorrect;
|
---|
| 131 | procedure SetSimpleMode(Value : boolean);
|
---|
| 132 | procedure SetRowColor(Color : TColor);
|
---|
| 133 | procedure SetSearchLabelCaption;
|
---|
| 134 | procedure SelectOperator(OperatorLine : string);
|
---|
| 135 | public
|
---|
| 136 | { Public declarations }
|
---|
| 137 | ConditionBox: TORComboBox;
|
---|
| 138 | FileBox: TORComboBox;
|
---|
| 139 | FieldBox: TORComboBox;
|
---|
| 140 | OperatorBox: TORComboBox;
|
---|
| 141 | OnSearchStringChange : TNotifyEvent;
|
---|
| 142 | OnRangeModeChange : TNotifyEvent;
|
---|
| 143 | constructor Create(SearchFileNumber,SearchFileName : string;
|
---|
| 144 | SimpleMode : Boolean;
|
---|
| 145 | AParent : TWinControl; AParentSet : TLogicSet; Row : integer);
|
---|
| 146 | Destructor Destroy;
|
---|
| 147 | procedure CloseRow;
|
---|
| 148 | procedure OpenRow;
|
---|
| 149 | function GetFieldDataType : TFieldDataType;
|
---|
| 150 | function GetFileNum : string;
|
---|
| 151 | function GetFieldNum : string;
|
---|
| 152 | function IsValid : boolean;
|
---|
| 153 | function GetSearchString(var LastFileNum : string) : string;
|
---|
| 154 | procedure IndentMore;
|
---|
| 155 | procedure IndentLess;
|
---|
| 156 | procedure Clear;
|
---|
| 157 | procedure SetFile(FileNumber,FileName : string);
|
---|
| 158 | property IndentLevel : integer read FIndentLevel write SetIndentLevel;
|
---|
| 159 | property SearchValueMode : TValueMode read FSearchValueMode;
|
---|
| 160 | property SearchValue : string read GetSearchValue;
|
---|
| 161 | property Visible : boolean read FVisible write SetVisible;
|
---|
| 162 | property NewGroupStarter : boolean read FNewGroupStarter write SetNewGroupStarter;
|
---|
| 163 | property Top : integer read FTop;
|
---|
| 164 | property RowNum : integer read FRowNum write SetRowNum;
|
---|
| 165 | Property SimpleMode : boolean read FSimpleMode write SetSimpleMode;
|
---|
| 166 | property RowOpen : boolean read FRowOpen;
|
---|
| 167 | end;
|
---|
| 168 |
|
---|
| 169 | TLogicSet = class (TObject)
|
---|
| 170 | private
|
---|
| 171 | { Private declarations }
|
---|
| 172 | Rows : TList;
|
---|
| 173 | FSearchFileNumber : string;
|
---|
| 174 | FSearchFileName : string;
|
---|
| 175 | FSearchString : string;
|
---|
| 176 | FParent : TWinControl;
|
---|
| 177 | FOwner : TComponent;
|
---|
| 178 | FSimpleMode : boolean;
|
---|
| 179 | FFileNumsStack : TStringList; //Will act as stack of filenumbers, based on indent level
|
---|
| 180 | lblAddAnother: TLabel;
|
---|
| 181 | btnIndentLess: TButton;
|
---|
| 182 | btnIndentMore: TButton;
|
---|
| 183 | function GetRow(Index : integer): TLogicRow;
|
---|
| 184 | procedure Handle1RowChange(Sender : TObject);
|
---|
| 185 | function GetSearchString : string;
|
---|
| 186 | function GetRowCount : integer;
|
---|
| 187 | procedure HandleIndentMore(Sender : TObject);
|
---|
| 188 | procedure HandleIndentLess(Sender : TObject);
|
---|
| 189 | procedure HandleAddQuery(Sender : TObject);
|
---|
| 190 | procedure UpdateButtonPlacement;
|
---|
| 191 | procedure SetSimpleMode(Value : boolean);
|
---|
| 192 | public
|
---|
| 193 | { Public declarations }
|
---|
| 194 | OnSearchStringChange : TNotifyEvent;
|
---|
| 195 | SearchStringEdit : TEdit; //not owned by this object;
|
---|
| 196 | lblFile : TLabel; //not owned by this object;
|
---|
| 197 | lblField : TLabel; //not owned by this object;
|
---|
| 198 | lblOperator : TLabel; //not owned by this object;
|
---|
| 199 | lblValue : TLabel; //not owned by this object;
|
---|
| 200 | DelBitmap : TBitmap; //IS owned by this object;
|
---|
| 201 | btnAddSrchField : TBitBtn;
|
---|
| 202 | constructor Create(SearchFileNumber,SearchFileName : string;
|
---|
| 203 | AParent : TWinControl; AOwner : TComponent);
|
---|
| 204 | Destructor Destroy;
|
---|
| 205 | function RowBefore (ARow : TLogicRow) : TLogicRow;
|
---|
| 206 | function PriorRow : TLogicRow; //Next to last row.
|
---|
| 207 | function LastRow : TLogicRow;
|
---|
| 208 | procedure IndentMore;
|
---|
| 209 | procedure IndentLess;
|
---|
| 210 | function AddRow : TLogicRow;
|
---|
| 211 | function IndexOf(ARow : TLogicRow) : integer;
|
---|
| 212 | procedure DeleteRow(Index : integer); overload;
|
---|
| 213 | procedure DeleteRow(ARow : TLogicRow); overload;
|
---|
| 214 | procedure SetFile(FileNumber,FileName : string);
|
---|
| 215 | procedure Clear;
|
---|
| 216 | property Row[Index : integer] : TLogicRow read GetRow;
|
---|
| 217 | property SearchString : string read FSearchString;
|
---|
| 218 | Property RowCount : integer read GetRowCount;
|
---|
| 219 | Property SimpleMode : boolean read FSimpleMode write SetSimpleMode;
|
---|
| 220 | end;
|
---|
| 221 |
|
---|
| 222 |
|
---|
| 223 | implementation
|
---|
| 224 |
|
---|
| 225 | uses FMErrorU;
|
---|
| 226 | //-----------------------------------------------------------------------
|
---|
| 227 | //TLogicRow
|
---|
| 228 | //-----------------------------------------------------------------------
|
---|
| 229 |
|
---|
| 230 | constructor TLogicRow.Create(SearchFileNumber,SearchFileName : string;
|
---|
| 231 | SimpleMode : Boolean;
|
---|
| 232 | AParent : TWinControl;
|
---|
| 233 | AParentSet : TLogicSet; Row : integer);
|
---|
| 234 | procedure InitBox(Box : TORComboBox; Row : integer; DropDown : boolean);
|
---|
| 235 | begin
|
---|
| 236 | with Box do begin
|
---|
| 237 | Visible := false;
|
---|
| 238 | Parent := AParent;
|
---|
| 239 | Top := FTop;
|
---|
| 240 | Delimiter := '^';
|
---|
| 241 | Pieces := '2';
|
---|
| 242 | if DropDown then begin
|
---|
| 243 | Style := orcsDropDown; //orcsSimple;
|
---|
| 244 | end else begin
|
---|
| 245 | Style := orcsSimple;
|
---|
| 246 | end;
|
---|
| 247 | Height := OPEN_BOX_HEIGHT;
|
---|
| 248 | AutoSelect := False;
|
---|
| 249 | CheckEntireLine := True;
|
---|
| 250 | LongList := True;
|
---|
| 251 | LookupPiece := 2;
|
---|
| 252 | end;
|
---|
| 253 | end;
|
---|
| 254 |
|
---|
| 255 | begin {constructor}
|
---|
| 256 | Inherited Create;
|
---|
| 257 | FRowNum := Row;
|
---|
| 258 | FSearchFileNumber := SearchFileNumber;
|
---|
| 259 | FSearchFileName := SearchFileName;
|
---|
| 260 | FParentSet := AParentSet;
|
---|
| 261 | FVisible := false;
|
---|
| 262 | FSimpleMode := SimpleMode;
|
---|
| 263 | FRowOpen := true;
|
---|
| 264 | FTop := FIELDS_TOP_OFFSET + ROW_HEIGHT * Row;
|
---|
| 265 | FNewGroupStarter := false;
|
---|
| 266 | OnSearchStringChange := nil;
|
---|
| 267 | OnRangeModeChange := nil;
|
---|
| 268 | ConditionBox := TORComboBox.Create(AParent); //Create condition box (e.g. AND, OR, NOT)
|
---|
| 269 | InitBox(ConditionBox,Row,true);
|
---|
| 270 | with ConditionBox do begin
|
---|
| 271 | Left := INT_CBO_CONDITIONLEFT;
|
---|
| 272 | Width := INT_CBO_CONDITIONWIDTH;
|
---|
| 273 | OnChange := ConditionChange;
|
---|
| 274 | end;
|
---|
| 275 | LoadCondition(ConditionBox);
|
---|
| 276 |
|
---|
| 277 | FileBox := TORComboBox.Create(AParent); //create the file box
|
---|
| 278 | InitBox(FileBox,Row,true);
|
---|
| 279 | with FileBox do begin
|
---|
| 280 | Left := INT_CBO_FILELEFT;
|
---|
| 281 | Width := INT_CBO_FILEWIDTH;
|
---|
| 282 | OnNeedData := ORBoxNeedData;
|
---|
| 283 | OnClick := FileBoxChange;
|
---|
| 284 | OnChange := FileBoxChange;
|
---|
| 285 | Tag := TAG_FILE_BOX;
|
---|
| 286 | end;
|
---|
| 287 |
|
---|
| 288 | FieldBox := TORComboBox.Create(AParent); //create the field box
|
---|
| 289 | InitBox(FieldBox,Row,false);
|
---|
| 290 | with FieldBox do begin
|
---|
| 291 | Left := INT_CBO_FIELDLEFT;
|
---|
| 292 | Width := INT_CBO_FIELDWIDTH;
|
---|
| 293 | OnNeedData := ORBoxNeedData;
|
---|
| 294 | OnChange := FieldBoxChange;
|
---|
| 295 | Tag := TAG_FIELD_BOX;
|
---|
| 296 | end;
|
---|
| 297 |
|
---|
| 298 | OperatorBox := TORComboBox.Create(AParent); //create the operator box (e.g. >, <, =, [ etc)
|
---|
| 299 | InitBox(OperatorBox,Row,true);
|
---|
| 300 | with OperatorBox do begin
|
---|
| 301 | Left := INT_CBO_OPERATORLEFT;
|
---|
| 302 | Width := INT_CBO_OPERATORWIDTH;
|
---|
| 303 | Height := OPERATOR_BOX_HEIGHT;
|
---|
| 304 | OnClick := OperatorBoxChange;
|
---|
| 305 | OnChange := OperatorBoxChange;
|
---|
| 306 | end;
|
---|
| 307 | LoadOperator(OperatorBox);
|
---|
| 308 |
|
---|
| 309 | ValueEdit := TEdit.Create(AParent); //create the Value edit box (also Lower limit box)
|
---|
| 310 | with ValueEdit do begin
|
---|
| 311 | Visible := false;
|
---|
| 312 | Parent := AParent;
|
---|
| 313 | Left := INT_EDIT_VALUELEFT;
|
---|
| 314 | Width := INT_EDIT_VALUEWIDTH;
|
---|
| 315 | Top := FTop;
|
---|
| 316 | OnChange := EditBoxChange;
|
---|
| 317 | end;
|
---|
| 318 |
|
---|
| 319 | UpperValueEdit := TEdit.Create(AParent); //create the lower limit box
|
---|
| 320 | with UpperValueEdit do begin
|
---|
| 321 | Visible := false;
|
---|
| 322 | Parent := AParent;
|
---|
| 323 | Left := INT_EDIT_LOWERLEFT;
|
---|
| 324 | Width := INT_EDIT_UPPERWIDTH;
|
---|
| 325 | Top := FTop;
|
---|
| 326 | OnChange := EditBoxChange;
|
---|
| 327 | end;
|
---|
| 328 |
|
---|
| 329 | DatePicker := TDateTimePicker.Create(AParent);
|
---|
| 330 | with DatePicker do begin
|
---|
| 331 | Visible := False;
|
---|
| 332 | Parent := AParent;
|
---|
| 333 | DateTime := Now;
|
---|
| 334 | Format := 'MM/dd/yyyy';
|
---|
| 335 | Width := INT_EDIT_VALUEWIDTH;
|
---|
| 336 | Top := FTop;
|
---|
| 337 | OnChange := DatePickerChange;
|
---|
| 338 | end;
|
---|
| 339 |
|
---|
| 340 | UpperDatePicker := TDateTimePicker.Create(AParent);
|
---|
| 341 | with UpperDatePicker do begin
|
---|
| 342 | Visible := False;
|
---|
| 343 | Parent := AParent;
|
---|
| 344 | DateTime := Now;
|
---|
| 345 | Format := 'MM/dd/yyyy';
|
---|
| 346 | Width := INT_EDIT_UPPERWIDTH;
|
---|
| 347 | Top := FTop;
|
---|
| 348 | OnChange := DatePickerChange;
|
---|
| 349 | end;
|
---|
| 350 |
|
---|
| 351 | RecordPickerBox := TORComboBox.Create(AParent);
|
---|
| 352 | InitBox(RecordPickerBox,Row,true);
|
---|
| 353 | with RecordPickerBox do begin
|
---|
| 354 | Width := INT_EDIT_VALUEWIDTH;
|
---|
| 355 | OnNeedData := ORBoxNeedData;
|
---|
| 356 | OnChange := RecordPickerBoxChange;
|
---|
| 357 | Tag := TAG_RECORD_BOX;
|
---|
| 358 | end;
|
---|
| 359 |
|
---|
| 360 | SetPicker := TComboBox.Create(AParent);
|
---|
| 361 | With SetPicker do begin
|
---|
| 362 | Visible := false;
|
---|
| 363 | Parent := AParent;
|
---|
| 364 | Width := INT_EDIT_VALUEWIDTH;
|
---|
| 365 | Top := FTop;
|
---|
| 366 | OnChange := SetPickerChange;
|
---|
| 367 | end;
|
---|
| 368 |
|
---|
| 369 | DelButton := TSpeedButton.Create(AParent);
|
---|
| 370 | with DelButton do begin
|
---|
| 371 | Visible := false;
|
---|
| 372 | Parent := AParent;
|
---|
| 373 | Height := INT_BUTTON_SIZE;
|
---|
| 374 | Width := INT_BUTTON_SIZE;
|
---|
| 375 | //Caption := '(x)'; //Will be assigned a bitmap by parentset
|
---|
| 376 | Top := FTop;
|
---|
| 377 | OnClick := DelButtonClick;
|
---|
| 378 | Hint := 'Delete row';
|
---|
| 379 | ShowHint := true;
|
---|
| 380 | ParentShowHint := False;
|
---|
| 381 | Visible := true;
|
---|
| 382 | end;
|
---|
| 383 |
|
---|
| 384 | SetIndentLevel(0);
|
---|
| 385 | InitORComboBox(FileBox,FSearchFileName,'file');
|
---|
| 386 | FileBoxChange(FileBox);
|
---|
| 387 | FieldBoxChange(FieldBox);
|
---|
| 388 | SetVisible(true);
|
---|
| 389 | SetSimpleMode(FSimpleMode);
|
---|
| 390 | end; {constructor}
|
---|
| 391 |
|
---|
| 392 | Destructor TLogicRow.Destroy;
|
---|
| 393 | begin
|
---|
| 394 | ConditionBox.Free;
|
---|
| 395 | FileBox.Free;
|
---|
| 396 | FieldBox.Free;
|
---|
| 397 | OperatorBox.Free;
|
---|
| 398 | ValueEdit.Free;
|
---|
| 399 | UpperValueEdit.Free;
|
---|
| 400 | DatePicker.Free;
|
---|
| 401 | UpperDatePicker.Free;
|
---|
| 402 | RecordPickerBox.Free;
|
---|
| 403 | SetPicker.Free;
|
---|
| 404 | DelButton.Free;
|
---|
| 405 | Inherited Destroy;
|
---|
| 406 | end;
|
---|
| 407 |
|
---|
| 408 | procedure TLogicRow.SetIndentLevel(Value : integer);
|
---|
| 409 | begin
|
---|
| 410 | FIndentLevel := Value;
|
---|
| 411 | ConditionBox.Left := INT_CBO_CONDITIONLEFT + INDENT_OFFSET * Value;
|
---|
| 412 | FileBox.Left := INT_CBO_FILELEFT + INDENT_OFFSET * Value;
|
---|
| 413 | FieldBox.Left := INT_CBO_FIELDLEFT + INDENT_OFFSET * Value;
|
---|
| 414 | OperatorBox.Left := INT_CBO_OPERATORLEFT + INDENT_OFFSET * Value;
|
---|
| 415 | ValueEdit.Left := INT_EDIT_VALUELEFT + INDENT_OFFSET * Value;
|
---|
| 416 | UpperValueEdit.Left := INT_EDIT_UPPERLEFT + INDENT_OFFSET * Value;
|
---|
| 417 | DatePicker.Left := INT_EDIT_VALUELEFT + INDENT_OFFSET * Value;
|
---|
| 418 | UpperDatePicker.Left:= INT_EDIT_UPPERLEFT + INDENT_OFFSET * Value;
|
---|
| 419 | RecordPickerBox.Left:= INT_EDIT_VALUELEFT + INDENT_OFFSET * Value;
|
---|
| 420 | SetPicker.Left := INT_EDIT_VALUELEFT + INDENT_OFFSET * Value;
|
---|
| 421 | DelButton.Left := INT_BUTTON_LEFT + INDENT_OFFSET * Value;
|
---|
| 422 | if FParentSet<> nil then begin
|
---|
| 423 | If FParentSet.lblFile <> nil then FParentSet.lblFile.Left := INT_CBO_FILELEFT
|
---|
| 424 | + LABEL_LEFT_OFFSET + INDENT_OFFSET * Value;
|
---|
| 425 | If FParentSet.lblField <> nil then FParentSet.lblField.Left := INT_CBO_FIELDLEFT
|
---|
| 426 | + LABEL_LEFT_OFFSET + INDENT_OFFSET * Value;
|
---|
| 427 | If FParentSet.lblOperator <> nil then FParentSet.lblOperator.Left := INT_CBO_OPERATORLEFT
|
---|
| 428 | + LABEL_LEFT_OFFSET + INDENT_OFFSET * Value;
|
---|
| 429 | If FParentSet.lblValue <> nil then FParentSet.lblValue.Left := INT_EDIT_VALUELEFT
|
---|
| 430 | + LABEL_LEFT_OFFSET + INDENT_OFFSET * Value;
|
---|
| 431 | end;
|
---|
| 432 | end;
|
---|
| 433 |
|
---|
| 434 | procedure TLogicRow.Clear;
|
---|
| 435 | //This just resets the row for use. It doesn't delete it.
|
---|
| 436 | begin
|
---|
| 437 | SetIndentLevel(0);
|
---|
| 438 | FileBox.ItemIndex := 0;
|
---|
| 439 | FileBox.Text := piece(FileBox.Items[0],'^',2);
|
---|
| 440 | FileBoxChange(FileBox);
|
---|
| 441 | FieldBox.ItemIndex := 0;
|
---|
| 442 | FieldBox.Text := piece(FieldBox.Items[0],'^',2);
|
---|
| 443 | FieldBoxChange(FieldBox);
|
---|
| 444 | ValueEdit.Text := '';
|
---|
| 445 | UpperValueEdit.Text := '';
|
---|
| 446 | DatePicker.DateTime := Now;
|
---|
| 447 | UpperDatePicker.DateTime := Now;
|
---|
| 448 | RecordPickerBox.Text := '';
|
---|
| 449 | RecordPickerBox.ItemIndex := 0;
|
---|
| 450 | SetPicker.Text := '';
|
---|
| 451 | ConditionBox.ItemIndex := 0;
|
---|
| 452 | ConditionBox.Text := piece(ConditionBox.Items[0],'^',2);
|
---|
| 453 | end;
|
---|
| 454 |
|
---|
| 455 | procedure TLogicRow.SetFile(FileNumber,FileName : string);
|
---|
| 456 | begin
|
---|
| 457 | if (FSearchFileNumber=FileNumber) and (FSearchFileName=FileName) then exit;
|
---|
| 458 | FSearchFileNumber := FileNumber;
|
---|
| 459 | FSearchFileName := FileName;
|
---|
| 460 | InitORComboBox(FileBox,FSearchFileName,'file');
|
---|
| 461 | FileBoxChange(FileBox);
|
---|
| 462 | FieldBoxChange(FieldBox);
|
---|
| 463 | end;
|
---|
| 464 |
|
---|
| 465 | procedure TLogicRow.SetRowColor(Color : TColor);
|
---|
| 466 | begin
|
---|
| 467 | ConditionBox.Color := Color;
|
---|
| 468 | FileBox.Color := Color;
|
---|
| 469 | FieldBox.Color := Color;
|
---|
| 470 | OperatorBox.Color := Color;
|
---|
| 471 | ValueEdit.Color := Color;
|
---|
| 472 | UpperValueEdit.Color := Color;
|
---|
| 473 | DatePicker.Color := Color;
|
---|
| 474 | UpperDatePicker.Color := Color;
|
---|
| 475 | SetPicker.Color := Color;
|
---|
| 476 | RecordPickerBox.Color := Color;
|
---|
| 477 | end;
|
---|
| 478 |
|
---|
| 479 | procedure TLogicRow.CloseRow;
|
---|
| 480 | procedure CloseORBox(Box : TORComboBox);
|
---|
| 481 | begin
|
---|
| 482 | Box.Style := orcsDropDown;
|
---|
| 483 | Box.Height := CLOSE_BOX_HEIGHT;
|
---|
| 484 | //Box.Color := clInactiveBorder;
|
---|
| 485 | end;
|
---|
| 486 |
|
---|
| 487 | begin
|
---|
| 488 | FRowOpen := false;
|
---|
| 489 | if FNewGroupStarter and (FVisible=false) then exit;
|
---|
| 490 | CloseORBox(ConditionBox);
|
---|
| 491 | CloseORBox(FileBox);
|
---|
| 492 | CloseORBox(FieldBox);
|
---|
| 493 | CloseORBox(RecordPickerBox);
|
---|
| 494 | SetRowColor(clInactiveBorder);
|
---|
| 495 | SetVisible(true);
|
---|
| 496 | end;
|
---|
| 497 |
|
---|
| 498 | procedure TLogicRow.OpenRow;
|
---|
| 499 | begin
|
---|
| 500 | FRowOpen := true;
|
---|
| 501 | SetRowColor(Colors[FSimpleMode]);
|
---|
| 502 | SetVisible(true);
|
---|
| 503 | end;
|
---|
| 504 |
|
---|
| 505 | procedure TLogicRow.SetRowNum(value : integer);
|
---|
| 506 | //This won't change position in parent LogicSet
|
---|
| 507 | var Top : integer;
|
---|
| 508 | begin
|
---|
| 509 | if value <> FRowNum then begin
|
---|
| 510 | FRowNum := Value;
|
---|
| 511 | Top := FIELDS_TOP_OFFSET + ROW_HEIGHT * FRowNum;
|
---|
| 512 | ConditionBox.Top := Top;
|
---|
| 513 | FileBox.Top := Top;
|
---|
| 514 | FieldBox.Top := Top;
|
---|
| 515 | OperatorBox.Top := Top;
|
---|
| 516 | ValueEdit.Top := Top;
|
---|
| 517 | UpperValueEdit.Top := Top;
|
---|
| 518 | DatePicker.Top := Top;
|
---|
| 519 | UpperDatePicker.Top := Top;
|
---|
| 520 | RecordPickerBox.Top := Top;
|
---|
| 521 | SetPicker.Top := Top;
|
---|
| 522 | DelButton.Top := Top;
|
---|
| 523 | end;
|
---|
| 524 | end;
|
---|
| 525 |
|
---|
| 526 | procedure TLogicRow.SetSearchLabelCaption;
|
---|
| 527 | begin
|
---|
| 528 | If FParentSet.lblValue <> nil then begin
|
---|
| 529 | FParentSet.lblValue.Caption := SearchCaption[FSimpleMode,(FSearchValueMode = vmRange)];
|
---|
| 530 | end;
|
---|
| 531 | end;
|
---|
| 532 |
|
---|
| 533 | procedure TLogicRow.SetSimpleMode(Value : boolean);
|
---|
| 534 | begin
|
---|
| 535 | if Value <> FSimpleMode then begin
|
---|
| 536 | SetRowColor(Colors[FSimpleMode]);
|
---|
| 537 | FSimpleMode := Value;
|
---|
| 538 | if FSimpleMode=true then begin
|
---|
| 539 | InitORComboBox(FileBox,'A','file'); //Populate File box
|
---|
| 540 | if FileBox.Items.Count > 0 then begin
|
---|
| 541 | FileBox.ItemIndex := 0;
|
---|
| 542 | FileBox.Text := piece(FileBox.Items[FileBox.ItemIndex],'^',2)
|
---|
| 543 | end;
|
---|
| 544 | end else begin
|
---|
| 545 | InitORComboBox(FileBox,FSearchFileName,'file'); //Populate File box
|
---|
| 546 | end;
|
---|
| 547 | SetSearchLabelCaption;
|
---|
| 548 | InitORComboBox(FieldBox,'A','field'); //Populate Field box
|
---|
| 549 | if Assigned(OnSearchStringChange) then OnSearchStringChange(self);
|
---|
| 550 | end;
|
---|
| 551 | end;
|
---|
| 552 |
|
---|
| 553 |
|
---|
| 554 | procedure TLogicRow.SetNewGroupStarter(Value : boolean);
|
---|
| 555 | begin
|
---|
| 556 | if Value = FNewGroupStarter then exit;
|
---|
| 557 | FNewGroupStarter := Value;
|
---|
| 558 | SetVisible(not FNewGroupStarter);
|
---|
| 559 | ConditionBox.Color := clWindow;
|
---|
| 560 | ConditionBox.Visible := true;
|
---|
| 561 | end;
|
---|
| 562 |
|
---|
| 563 |
|
---|
| 564 | procedure TLogicRow.SelectOperator(OperatorLine : string);
|
---|
| 565 | var index,i : integer;
|
---|
| 566 | begin
|
---|
| 567 | if OperatorBox.Items.Count = 0 then exit;
|
---|
| 568 | //not working, why? --> index := OperatorBox.Items.IndexOf(OperatorLine);
|
---|
| 569 | index := -1;
|
---|
| 570 | for i:= 0 to OperatorBox.Items.Count-1 do begin
|
---|
| 571 | if OperatorBox.Items[i] = OperatorLine then begin
|
---|
| 572 | index := i; break;
|
---|
| 573 | end;
|
---|
| 574 | end;
|
---|
| 575 | //if index = OperatorBox.ItemIndex then exit; //no change.
|
---|
| 576 | if index < 0 then index := 0;
|
---|
| 577 | OperatorBox.Text := piece(OperatorBox.Items[index],'^',2);
|
---|
| 578 | OperatorBox.ItemIndex := index;
|
---|
| 579 | OperatorBoxChange(Self);
|
---|
| 580 | end;
|
---|
| 581 |
|
---|
| 582 |
|
---|
| 583 | procedure TLogicRow.LoadOperator(CmbBox: TORComboBox);
|
---|
| 584 | //Load the operators, with the first piece being the mumps operator and
|
---|
| 585 | //the second piece the text in the operator box
|
---|
| 586 | begin
|
---|
| 587 | CmbBox.Items.Add(COMB_EQUALS);
|
---|
| 588 | CmbBox.Items.Add(COMB_NOT_EQUAL);
|
---|
| 589 | CmbBox.Items.Add(COMB_LESS_THAN);
|
---|
| 590 | CmbBox.Items.Add(COMB_LESS_THAN_OR_EQUALS);
|
---|
| 591 | CmbBox.Items.Add(COMB_GREATER_THAN);
|
---|
| 592 | CmbBox.Items.Add(COMB_GREATER_THAN_OR_EQUALS);
|
---|
| 593 | CmbBox.Items.Add(COMB_IN_RANGE);
|
---|
| 594 | CmbBox.Items.Add(COMB_NOT_IN_RANGE);
|
---|
| 595 | CmbBox.Items.Add(COMB_CONTAINS);
|
---|
| 596 | CmbBox.Items.Add(COMB_NOT_CONTAINS);
|
---|
| 597 | CmbBox.ItemIndex := 0;
|
---|
| 598 | CmbBox.Text := piece(CmbBox.Items[0],'^',2);
|
---|
| 599 | end;
|
---|
| 600 |
|
---|
| 601 | procedure TLogicRow.LoadCondition(CmbBox: TORComboBox);
|
---|
| 602 | //Load the conditions, with the first piece being the mumps conditional and
|
---|
| 603 | //the second piece the text in the conditions box
|
---|
| 604 | begin
|
---|
| 605 | CmbBox.Items.Add('&^AND');
|
---|
| 606 | CmbBox.Items.Add('!^OR');
|
---|
| 607 | CmbBox.Items.Add('NOT^NOT');
|
---|
| 608 | CmbBox.ItemIndex := 0;
|
---|
| 609 | CmbBox.Text := 'AND';
|
---|
| 610 | end;
|
---|
| 611 |
|
---|
| 612 | procedure TLogicRow.ORBoxNeedData(Sender: TObject; const StartFrom: String;
|
---|
| 613 | Direction, InsertAt: Integer);
|
---|
| 614 | var Result : TStrings;
|
---|
| 615 | FileNum : string;
|
---|
| 616 | ORComboBox : TORComboBox;
|
---|
| 617 | begin
|
---|
| 618 | ORComboBox := TORComboBox(Sender);
|
---|
| 619 | Case ORComboBox.Tag of
|
---|
| 620 | TAG_FILE_BOX : begin
|
---|
| 621 | FileNum := FSearchFileNumber;
|
---|
| 622 | Result := SubSetOfAllowedFiles(FSimpleMode,FileNum,
|
---|
| 623 | StartFrom, Direction);
|
---|
| 624 | end;
|
---|
| 625 | TAG_FIELD_BOX : begin
|
---|
| 626 | if FileBox.Items.count = 0 then exit;
|
---|
| 627 | if FileBox.ItemIndex = -1 then FileBox.ItemIndex := 0;
|
---|
| 628 | FileNum := piece(FileBox.Items[FileBox.ItemIndex],'^',1);
|
---|
| 629 | Result := SubSetOfFields(FSimpleMode, FileNum, StartFrom, Direction);
|
---|
| 630 | end;
|
---|
| 631 | TAG_RECORD_BOX: begin
|
---|
| 632 | FileNum := ExtractNum (FCurFieldDef,Pos('P',FCurFieldDef)+1);
|
---|
| 633 | Result := SubSetOfFile(FileNum, StartFrom, Direction);
|
---|
| 634 | end;
|
---|
| 635 | else Exit;
|
---|
| 636 | end; {case}
|
---|
| 637 | ORComboBox.ForDataUse(Result);
|
---|
| 638 | end;
|
---|
| 639 |
|
---|
| 640 | procedure TLogicRow.FileBoxChange(Sender: TObject);
|
---|
| 641 | begin
|
---|
| 642 | InitORComboBox(FieldBox,'A','field'); //Populate Field box
|
---|
| 643 | if Assigned(OnSearchStringChange) then OnSearchStringChange(self);
|
---|
| 644 | end;
|
---|
| 645 |
|
---|
| 646 | procedure TLogicRow.PrepSetPicker(setDef : string);
|
---|
| 647 | var oneOption : string;
|
---|
| 648 | begin
|
---|
| 649 | SetPicker.Items.Clear;
|
---|
| 650 | SetPicker.Text := '';
|
---|
| 651 | oneOption := 'x';
|
---|
| 652 | while (setDef <> '') and (oneOption <> '') do begin
|
---|
| 653 | oneOption := piece(setDef,';',1);
|
---|
| 654 | setDef := pieces(setDef,';',2,32);
|
---|
| 655 | oneOption := piece(oneOption,':',2);
|
---|
| 656 | if oneOption <> '' then begin
|
---|
| 657 | SetPicker.Items.Add(oneOption);
|
---|
| 658 | end;
|
---|
| 659 | end;
|
---|
| 660 | if SetPicker.Items.Count > 0 then begin
|
---|
| 661 | SetPicker.SelText := SetPicker.Items[0];
|
---|
| 662 | end else begin
|
---|
| 663 | SetPicker.Text := '(none defined)';
|
---|
| 664 | end;
|
---|
| 665 | end;
|
---|
| 666 |
|
---|
| 667 |
|
---|
| 668 | procedure TLogicRow.EnsureProperValueFieldVisible;
|
---|
| 669 | var
|
---|
| 670 | NewSearchValueMode : TValueMode;
|
---|
| 671 | CurDataType : TFieldDataType;
|
---|
| 672 | Operator : string;
|
---|
| 673 |
|
---|
| 674 | procedure ShowOnly(Control : TWinControl);
|
---|
| 675 | begin
|
---|
| 676 | ValueEdit.Visible := false;
|
---|
| 677 | UpperValueEdit.Visible := false;
|
---|
| 678 | DatePicker.Visible := false;
|
---|
| 679 | UpperDatePicker.visible := false;
|
---|
| 680 | RecordPickerBox.Visible := false;
|
---|
| 681 | SetPicker.Visible := false;
|
---|
| 682 | Control.Visible := true;
|
---|
| 683 | end;
|
---|
| 684 |
|
---|
| 685 | begin
|
---|
| 686 | CurDataType := GetFieldDataType;
|
---|
| 687 | Operator := OperatorBox.Text;
|
---|
| 688 | if Pos('IN RANGE',Operator) > 0 then begin
|
---|
| 689 | NewSearchValueMode := vmRange;
|
---|
| 690 | if CurDataType in [fdtPointer,fdtSet] then begin
|
---|
| 691 | MessageDlg('A RANGE can''t be used with this type of field.',mtError,[MBOK],0);
|
---|
| 692 | OperatorBox.Text := piece(OperatorBox.Items[0],'^',2); //should be EQUALS
|
---|
| 693 | OperatorBox.ItemIndex := 0;
|
---|
| 694 | exit;
|
---|
| 695 | end;
|
---|
| 696 | end else begin
|
---|
| 697 | Case CurDataType of
|
---|
| 698 | fdtUnknown : NewSearchValueMode := vmString;
|
---|
| 699 | fdtText : NewSearchValueMode := vmString;
|
---|
| 700 | fdtSet : NewSearchValueMode := vmSet;
|
---|
| 701 | fdtDate : NewSearchValueMode := vmDate;
|
---|
| 702 | fdtWP : NewSearchValueMode := vmString;
|
---|
| 703 | fdtPointer : NewSearchValueMode := vmPointer;
|
---|
| 704 | else NewSearchValueMode := vmString;
|
---|
| 705 | end; {case}
|
---|
| 706 | end;
|
---|
| 707 | if (NewSearchValueMode = FSearchValueMode)
|
---|
| 708 | and not (NewSearchValueMode in [vmPointer,vmSet]) then exit; //nothing to be done.
|
---|
| 709 | if (FSearchValueMode = vmRange) or (NewSearchValueMode = vmRange) then begin
|
---|
| 710 | if Assigned(OnRangeModeChange) then OnRangeModeChange(Self); //can be used to change labels.
|
---|
| 711 | end;
|
---|
| 712 | FSearchValueMode := NewSearchValueMode;
|
---|
| 713 | Case NewSearchValueMode of
|
---|
| 714 | vmRange: begin
|
---|
| 715 | if curDataType = fdtDate then begin
|
---|
| 716 | DatePicker.Width := INT_EDIT_LOWERWIDTH;
|
---|
| 717 | ShowOnly(DatePicker);
|
---|
| 718 | UpperDatePicker.Visible := true;
|
---|
| 719 | end else begin
|
---|
| 720 | ValueEdit.Width := INT_EDIT_LOWERWIDTH;
|
---|
| 721 | ShowOnly(ValueEdit);
|
---|
| 722 | UpperValueEdit.Visible := true;
|
---|
| 723 | end;
|
---|
| 724 | end;
|
---|
| 725 | vmString: Begin
|
---|
| 726 | ValueEdit.Width := INT_EDIT_VALUEWIDTH;
|
---|
| 727 | ShowOnly(ValueEdit);
|
---|
| 728 | end;
|
---|
| 729 | vmSet: begin
|
---|
| 730 | PrepSetPicker(FInfoPiece3);
|
---|
| 731 | ShowOnly(SetPicker);
|
---|
| 732 | end;
|
---|
| 733 | vmDate: begin
|
---|
| 734 | DatePicker.Width := INT_EDIT_VALUEWIDTH;
|
---|
| 735 | ShowOnly(DatePicker);
|
---|
| 736 | end;
|
---|
| 737 | vmPointer: begin
|
---|
| 738 | ShowOnly(RecordPickerBox);
|
---|
| 739 | InitORComboBox(RecordPickerBox,'A','record'); //Populate Field box
|
---|
| 740 | end;
|
---|
| 741 | end; {case}
|
---|
| 742 | SetSearchLabelCaption;
|
---|
| 743 | end;
|
---|
| 744 |
|
---|
| 745 | procedure TLogicRow.CheckVisibilityIsCorrect;
|
---|
| 746 | var RowPrior : TLogicRow;
|
---|
| 747 | begin
|
---|
| 748 | ConditionBox.Visible := (FRowNum>0);
|
---|
| 749 | RowPrior :=FParentSet.RowBefore(Self);
|
---|
| 750 | if (RowPrior <> nil) then if RowPrior.NewGroupStarter=true then begin
|
---|
| 751 | ConditionBox.Visible := false;
|
---|
| 752 | end;
|
---|
| 753 | DelButton.Visible := (FParentSet.RowCount>1);
|
---|
| 754 | end;
|
---|
| 755 |
|
---|
| 756 | procedure TLogicRow.SetVisible(Value : Boolean);
|
---|
| 757 | begin
|
---|
| 758 | FVisible := Value;
|
---|
| 759 | FileBox.Visible := Value;
|
---|
| 760 | FieldBox.Visible := Value;
|
---|
| 761 | OperatorBox.Visible := Value;
|
---|
| 762 | if Value = true then begin
|
---|
| 763 | EnsureProperValueFieldVisible;
|
---|
| 764 | CheckVisibilityIsCorrect;
|
---|
| 765 | end else begin
|
---|
| 766 | ConditionBox.Visible := False;
|
---|
| 767 | ValueEdit.Visible := false;
|
---|
| 768 | UpperValueEdit.Visible := false;
|
---|
| 769 | DatePicker.Visible := false;
|
---|
| 770 | UpperDatePicker.visible := false;
|
---|
| 771 | RecordPickerBox.Visible := false;
|
---|
| 772 | SetPicker.Visible := false;
|
---|
| 773 | end;
|
---|
| 774 | end;
|
---|
| 775 |
|
---|
| 776 |
|
---|
| 777 | function TLogicRow.GetSearchValue() : string;
|
---|
| 778 | var
|
---|
| 779 | CurDataType : TFieldDataType;
|
---|
| 780 |
|
---|
| 781 | begin
|
---|
| 782 | CurDataType := GetFieldDataType;
|
---|
| 783 | case FSearchValueMode of
|
---|
| 784 | vmRange: begin
|
---|
| 785 | if curDataType = fdtDate then begin
|
---|
| 786 | Result := DateToStr(DatePicker.DateTime) + '..' +
|
---|
| 787 | DateToStr(UpperDatePicker.DateTime);
|
---|
| 788 | end else begin
|
---|
| 789 | Result := ValueEdit.Text + '..' + UpperValueEdit.Text;
|
---|
| 790 | end;
|
---|
| 791 | end;
|
---|
| 792 | vmString: Begin
|
---|
| 793 | Result := ValueEdit.Text;
|
---|
| 794 | end;
|
---|
| 795 | vmSet: begin
|
---|
| 796 | Result := SetPicker.Text;
|
---|
| 797 | end;
|
---|
| 798 | vmDate: begin
|
---|
| 799 | Result := DateToStr(DatePicker.DateTime);
|
---|
| 800 | end;
|
---|
| 801 | vmPointer: begin
|
---|
| 802 | Result := RecordPickerBox.Text;
|
---|
| 803 | end;
|
---|
| 804 | else Result := '';
|
---|
| 805 | end; {case}
|
---|
| 806 | end;
|
---|
| 807 |
|
---|
| 808 | function TLogicRow.GetSearchString(var LastFileNum : string) : string;
|
---|
| 809 | var ThisFileNum : string;
|
---|
| 810 | NewFileNum : boolean;
|
---|
| 811 | Fld : string;
|
---|
| 812 | begin
|
---|
| 813 | Result := '';
|
---|
| 814 | NewFileNum := true; //default
|
---|
| 815 | if (IsValid=false)and(FNewGroupStarter=false) then exit;
|
---|
| 816 | ThisFileNum := piece(FileBox.Items[FileBox.ItemIndex],'^',1);
|
---|
| 817 | if LastFileNum <> ThisFileNum then begin
|
---|
| 818 | NewFileNum := true;
|
---|
| 819 | LastFileNum := ThisFileNum;
|
---|
| 820 | end;
|
---|
| 821 | if ConditionBox.Visible then begin
|
---|
| 822 | if (NewFileNum=false) and (ConditionBox.ItemIndex>-1) then begin
|
---|
| 823 | Result := Result + Piece(ConditionBox.Items[ConditionBox.ItemIndex],'^',1);
|
---|
| 824 | end else begin
|
---|
| 825 | Result := Result + ' ' + ConditionBox.Text + ' ';
|
---|
| 826 | end;
|
---|
| 827 | end;
|
---|
| 828 | if FNewGroupStarter then begin
|
---|
| 829 | Result := Result + '(';
|
---|
| 830 | end else begin
|
---|
| 831 | if FileBox.Items.Count = 0 then exit;
|
---|
| 832 | if FileBox.ItemIndex < 0 then FileBox.ItemIndex := 0;
|
---|
| 833 | if NewFileNum then Result := Result + ThisFileNum + ':';
|
---|
| 834 | if FSimpleMode then begin
|
---|
| 835 | if FieldBox.ItemIndex < 0 then exit;
|
---|
| 836 | Fld := FieldBox.Items[FieldBox.ItemIndex];
|
---|
| 837 | Result := Result + '(' + Piece(Fld,'^',1);
|
---|
| 838 | end else begin
|
---|
| 839 | Result := Result + '("' + FieldBox.Text + '"';
|
---|
| 840 | end;
|
---|
| 841 | Result := Result + Piece(OperatorBox.Items[OperatorBox.ItemIndex],'^',1);
|
---|
| 842 | Result := Result + '"' + GetSearchValue + '")';
|
---|
| 843 | end;
|
---|
| 844 | end;
|
---|
| 845 |
|
---|
| 846 |
|
---|
| 847 | procedure TLogicRow.OperatorBoxChange(Sender: TObject);
|
---|
| 848 | begin
|
---|
| 849 | EnsureProperValueFieldVisible; //If RANGE picked, then this will change edit fields.
|
---|
| 850 | if (OperatorBox.ItemIndex < 0) and (OperatorBox.Items.Count>0) then begin
|
---|
| 851 | OperatorBox.ItemIndex := 0;
|
---|
| 852 | OperatorBox.Text := piece(OperatorBox.Items[0],'^',2);
|
---|
| 853 | end;
|
---|
| 854 | // ParentSet.
|
---|
| 855 | end;
|
---|
| 856 |
|
---|
| 857 | function TLogicRow.GetFileNum : string;
|
---|
| 858 | begin
|
---|
| 859 | Result := IntToStr(FileBox.ItemIEN);
|
---|
| 860 | end;
|
---|
| 861 |
|
---|
| 862 | function TLogicRow.GetFieldNum : string;
|
---|
| 863 | begin
|
---|
| 864 | Result := IntToStr(FieldBox.ItemIEN);
|
---|
| 865 | end;
|
---|
| 866 |
|
---|
| 867 | function TLogicRow.GetFieldDataType : TFieldDataType;
|
---|
| 868 | var SubFileNum : string;
|
---|
| 869 | FileNum,FieldNum : string;
|
---|
| 870 | function IsSubFile(FieldDef: string) : boolean;
|
---|
| 871 | begin
|
---|
| 872 | SubFileNum := ExtractNum(FieldDef,1);
|
---|
| 873 | result := (SubFileNum <> '');
|
---|
| 874 | end;
|
---|
| 875 | begin
|
---|
| 876 | Result := fdtUnknown;
|
---|
| 877 | if Pos('F',FCurFieldDef)>0 then begin //Free text
|
---|
| 878 | Result := fdtText;
|
---|
| 879 | end else if Pos('D',FCurFieldDef)>0 then begin //date field
|
---|
| 880 | Result := fdtDate;
|
---|
| 881 | end else if Pos('S',FCurFieldDef)>0 then begin //Set of Codes
|
---|
| 882 | Result := fdtSet;
|
---|
| 883 | end else if Pos('P',FCurFieldDef)>0 then begin //Pointer to file.
|
---|
| 884 | Result := fdtPointer;
|
---|
| 885 | end else if IsSubFile(FCurFieldDef) then begin //Subfiles.
|
---|
| 886 | FileNum := GetFileNum; FieldNum := GetFieldNum;
|
---|
| 887 | if (FileNum <> '') and (FieldNum <> '') then begin
|
---|
| 888 | if IsWPField(FileNum,FieldNum) then Result := fdtWP;
|
---|
| 889 | end;
|
---|
| 890 | end;
|
---|
| 891 | end;
|
---|
| 892 |
|
---|
| 893 | procedure TLogicRow.FieldBoxChange(Sender: TObject);
|
---|
| 894 | var Info : string;
|
---|
| 895 | CurDataType : TFieldDataType;
|
---|
| 896 | begin
|
---|
| 897 | if FieldBox.ItemIndex >=0 then begin
|
---|
| 898 | Info := FieldBox.Items[FieldBox.ItemIndex];
|
---|
| 899 | end else Info := '';
|
---|
| 900 | FCurFieldDef := piece(Info,'^',3);
|
---|
| 901 | FInfoPiece3 := piece(Info,'^',4);
|
---|
| 902 | EnsureProperValueFieldVisible;
|
---|
| 903 | CurDataType := GetFieldDataType;
|
---|
| 904 | Case CurDataType of
|
---|
| 905 | fdtUnknown,
|
---|
| 906 | fdtPointer,
|
---|
| 907 | fdtSet : SelectOperator(COMB_EQUALS);
|
---|
| 908 | fdtText,
|
---|
| 909 | fdtWP : SelectOperator(COMB_CONTAINS);
|
---|
| 910 | fdtDate : SelectOperator(COMB_IN_RANGE);
|
---|
| 911 | end;
|
---|
| 912 | //OperatorBoxChange(Self);
|
---|
| 913 | if Assigned(OnSearchStringChange) then OnSearchStringChange(self);
|
---|
| 914 | end;
|
---|
| 915 |
|
---|
| 916 | procedure TLogicRow.EditBoxChange(Sender: TObject);
|
---|
| 917 | begin
|
---|
| 918 | if Assigned(OnSearchStringChange) then OnSearchStringChange(self);
|
---|
| 919 | end;
|
---|
| 920 |
|
---|
| 921 | procedure TLogicRow.SetPickerChange(Sender: TObject);
|
---|
| 922 | begin
|
---|
| 923 | if Assigned(OnSearchStringChange) then OnSearchStringChange(self);
|
---|
| 924 | end;
|
---|
| 925 |
|
---|
| 926 | procedure TLogicRow.ConditionChange(Sender: TObject);
|
---|
| 927 | begin
|
---|
| 928 | if Assigned(OnSearchStringChange) then OnSearchStringChange(self);
|
---|
| 929 | end;
|
---|
| 930 |
|
---|
| 931 | procedure TLogicRow.RecordPickerBoxChange(Sender: TObject);
|
---|
| 932 | begin
|
---|
| 933 | if Assigned(OnSearchStringChange) then OnSearchStringChange(self);
|
---|
| 934 | end;
|
---|
| 935 |
|
---|
| 936 | procedure TLogicRow.DatePickerChange(Sender: TObject);
|
---|
| 937 | begin
|
---|
| 938 | if Assigned(OnSearchStringChange) then OnSearchStringChange(self);
|
---|
| 939 | end;
|
---|
| 940 |
|
---|
| 941 | function TLogicRow.ExtractNum (S : String; StartPos : integer) : string;
|
---|
| 942 | var i : integer;
|
---|
| 943 | ch : char;
|
---|
| 944 | begin
|
---|
| 945 | result := '';
|
---|
| 946 | if (S = '') or (StartPos < 0) then exit;
|
---|
| 947 | i := StartPos;
|
---|
| 948 | repeat
|
---|
| 949 | ch := S[i];
|
---|
| 950 | i := i + 1;
|
---|
| 951 | if ch in ['0'..'9','.'] then begin
|
---|
| 952 | Result := Result + ch;
|
---|
| 953 | end;
|
---|
| 954 | until (i > length(S)) or not (ch in ['0'..'9','.'])
|
---|
| 955 | end;
|
---|
| 956 |
|
---|
| 957 |
|
---|
| 958 | function TLogicRow.SubSetOfFields(SimpleMode : Boolean; FileNum: string;
|
---|
| 959 | const StartFrom: string; Direction: Integer): TStrings;
|
---|
| 960 |
|
---|
| 961 | { returns a pointer to a list of file entries (for use in a long list box) -
|
---|
| 962 | The return value is a pointer to RPCBrokerV.Results, so the data must
|
---|
| 963 | be used BEFORE the next broker call! }
|
---|
| 964 | var
|
---|
| 965 | cmd,RPCResult,GetSimple : string;
|
---|
| 966 | begin
|
---|
| 967 | Result := nil; //default
|
---|
| 968 | RPCBrokerV.remoteprocedure := 'TMG SEARCH CHANNEL';
|
---|
| 969 | RPCBrokerV.Param[0].Value := '.X'; // not used
|
---|
| 970 | RPCBrokerV.param[0].ptype := list;
|
---|
| 971 | cmd := 'FIELD LIST SUBSET';
|
---|
| 972 | if SimpleMode then GetSimple :='1' else GetSimple :='0';
|
---|
| 973 | cmd := cmd + '^' + FileNum + '^' + StartFrom + '^' + IntToStr(Direction) + '^^' + GetSimple;
|
---|
| 974 | RPCBrokerV.Param[0].Mult['"REQUEST"'] := cmd;
|
---|
[801] | 975 | //RPCBrokerV.Call;
|
---|
| 976 | CallBroker;
|
---|
[800] | 977 | if RPCBrokerV.Results.Count > 0 then begin
|
---|
| 978 | RPCResult := RPCBrokerV.Results[0]; //returns: error: -1; success=1
|
---|
| 979 | if piece(RPCResult,'^',1)='-1' then begin
|
---|
| 980 | // handle error...
|
---|
| 981 | end else begin
|
---|
| 982 | RPCBrokerV.Results.Delete(0);
|
---|
| 983 | if RPCBrokerV.Results.Count=0 then begin
|
---|
| 984 | //RPCBrokerV.Results.Add('0^<NO DATA>');
|
---|
| 985 | end;
|
---|
| 986 | end;
|
---|
| 987 | Result := RPCBrokerV.Results;
|
---|
| 988 | end;
|
---|
| 989 | end;
|
---|
| 990 |
|
---|
| 991 | procedure TLogicRow.DelButtonClick(Sender : TObject);
|
---|
| 992 | begin
|
---|
| 993 | FParentSet.DeleteRow(Self);
|
---|
| 994 | end;
|
---|
| 995 |
|
---|
| 996 | function TLogicRow.IsWPField(FileNum,FieldNum : string) : boolean;
|
---|
| 997 | var RPCResult : string;
|
---|
| 998 | SrchStr : string;
|
---|
| 999 | //Idx: integer;
|
---|
| 1000 | begin
|
---|
| 1001 | SrchStr := FileNum + '^' + FieldNum + '^';
|
---|
| 1002 | //Idx := CachedWPField.IndexOf(SrchStr + 'YES');
|
---|
| 1003 | //if Idx > -1 then begin Result := true; exit; end;
|
---|
| 1004 | //Idx := CachedWPField.IndexOf(SrchStr + 'NO');
|
---|
| 1005 | //if Idx > -1 then begin Result := false; exit; end;
|
---|
| 1006 |
|
---|
| 1007 | result := false;
|
---|
| 1008 | RPCBrokerV.remoteprocedure := 'TMG CHANNEL';
|
---|
| 1009 | RPCBrokerV.param[0].ptype := list;
|
---|
| 1010 | RPCBrokerV.Param[0].Mult['"REQUEST"'] := 'IS WP FIELD^' + FileNum + '^' + FieldNum;
|
---|
[801] | 1011 | //RPCBrokerV.Call;
|
---|
| 1012 | CallBroker;
|
---|
[800] | 1013 | RPCResult := RPCBrokerV.Results[0]; //returns: error: -1; success=1
|
---|
| 1014 | if piece(RPCResult,'^',1)='-1' then begin
|
---|
| 1015 | FMErrorForm.Memo.Lines.Assign(RPCBrokerV.Results);
|
---|
| 1016 | FMErrorForm.PrepMessage;
|
---|
| 1017 | FMErrorForm.ShowModal;
|
---|
| 1018 | end else begin
|
---|
| 1019 | RPCResult := piece(RPCResult,'^',3);
|
---|
| 1020 | result := (RPCResult = 'YES');
|
---|
| 1021 | //CachedWPField.Add(SrchStr + RPCResult);
|
---|
| 1022 | end;
|
---|
| 1023 | end;
|
---|
| 1024 |
|
---|
| 1025 | function TLogicRow.IsValid() : boolean;
|
---|
| 1026 | var
|
---|
| 1027 | CurDataType : TFieldDataType;
|
---|
| 1028 |
|
---|
| 1029 | begin
|
---|
| 1030 | Result := false; //default to failure
|
---|
| 1031 | if (FRowNum>0) and (ConditionBox.Text = '') then exit;
|
---|
| 1032 | if FileBox.Text = '' then exit;
|
---|
| 1033 | if FieldBox.Text = '' then exit;
|
---|
| 1034 | if OperatorBox.Text = '' then exit;
|
---|
| 1035 | Case FSearchValueMode of
|
---|
| 1036 | vmUnknown : exit;
|
---|
| 1037 | vmRange : begin
|
---|
| 1038 | CurDataType := GetFieldDataType;
|
---|
| 1039 | if CurDataType <> fdtDate then begin
|
---|
| 1040 | if (ValueEdit.Text = '') or (UpperValueEdit.Text = '') then exit;
|
---|
| 1041 | end;
|
---|
| 1042 | end;
|
---|
| 1043 | vmString,vmNumeric : begin
|
---|
| 1044 | if (ValueEdit.Text = '') then exit;
|
---|
| 1045 | end;
|
---|
| 1046 | vmDate : begin
|
---|
| 1047 | //Date is always present...
|
---|
| 1048 | //if (DatePickerBox.Text = '') then exit;
|
---|
| 1049 | end;
|
---|
| 1050 | vmSet : begin
|
---|
| 1051 | if (SetPicker.Text = '') then exit;
|
---|
| 1052 | end;
|
---|
| 1053 | vmPointer : begin
|
---|
| 1054 | if (RecordPickerBox.Text = '') then exit;
|
---|
| 1055 | end;
|
---|
| 1056 | end; {case}
|
---|
| 1057 | Result := true;
|
---|
| 1058 | end;
|
---|
| 1059 |
|
---|
| 1060 |
|
---|
| 1061 | function TLogicRow.SubSetOfAllowedFiles(SimpleMode : boolean; FileNum: string;
|
---|
| 1062 | const StartFrom: string;
|
---|
| 1063 | Direction: Integer ): TStrings;
|
---|
| 1064 |
|
---|
| 1065 | { returns a pointer to a list of file entries (for use in a long list box) -
|
---|
| 1066 | The return value is a pointer to RPCBrokerV.Results, so the data must
|
---|
| 1067 | be used BEFORE the next broker call! }
|
---|
| 1068 | var
|
---|
| 1069 | cmd,RPCResult,GetSimple : string;
|
---|
| 1070 |
|
---|
| 1071 | begin
|
---|
| 1072 | RPCBrokerV.remoteprocedure := 'TMG SEARCH CHANNEL';
|
---|
| 1073 | RPCBrokerV.Param[0].Value := '.X'; // not used
|
---|
| 1074 | RPCBrokerV.param[0].ptype := list;
|
---|
| 1075 | cmd := 'ALLOWED FILES ENTRY SUBSET';
|
---|
| 1076 | if SimpleMode then GetSimple :='1' else GetSimple :='0';
|
---|
| 1077 | cmd := cmd + '^' + FileNum + '^' + StartFrom + '^' + IntToStr(Direction) + '^^' + GetSimple;
|
---|
| 1078 | RPCBrokerV.Param[0].Mult['"REQUEST"'] := cmd;
|
---|
[801] | 1079 | //RPCBrokerV.Call;
|
---|
| 1080 | CallBroker;
|
---|
[800] | 1081 | if RPCBrokerV.Results.Count > 0 then begin
|
---|
| 1082 | RPCResult := RPCBrokerV.Results[0]; //returns: error: -1; success=1
|
---|
| 1083 | if piece(RPCResult,'^',1)='-1' then begin
|
---|
| 1084 | // handle error...
|
---|
| 1085 | end else begin
|
---|
| 1086 | RPCBrokerV.Results.Delete(0);
|
---|
| 1087 | if RPCBrokerV.Results.Count=0 then begin
|
---|
| 1088 | //RPCBrokerV.Results.Add('0^<NO DATA>');
|
---|
| 1089 | end;
|
---|
| 1090 | end;
|
---|
| 1091 | end;
|
---|
| 1092 | Result := RPCBrokerV.Results;
|
---|
| 1093 | end;
|
---|
| 1094 |
|
---|
| 1095 | function TLogicRow.SubSetOfFile(FileNum: string;
|
---|
| 1096 | const StartFrom: string;
|
---|
| 1097 | Direction: Integer ): TStrings;
|
---|
| 1098 |
|
---|
| 1099 | { returns a pointer to a list of file entries (for use in a long list box) -
|
---|
| 1100 | The return value is a pointer to RPCBrokerV.Results, so the data must
|
---|
| 1101 | be used BEFORE the next broker call! }
|
---|
| 1102 | var
|
---|
| 1103 | cmd,RPCResult : string;
|
---|
| 1104 | begin
|
---|
| 1105 | RPCBrokerV.remoteprocedure := 'TMG CHANNEL';
|
---|
| 1106 | RPCBrokerV.Param[0].Value := '.X'; // not used
|
---|
| 1107 | RPCBrokerV.param[0].ptype := list;
|
---|
| 1108 | cmd := 'FILE ENTRY SUBSET';
|
---|
| 1109 | cmd := cmd + '^' + FileNum + '^' + StartFrom + '^' + IntToStr(Direction);
|
---|
| 1110 | RPCBrokerV.Param[0].Mult['"REQUEST"'] := cmd;
|
---|
[801] | 1111 | //RPCBrokerV.Call;
|
---|
| 1112 | CallBroker;
|
---|
[800] | 1113 | RPCResult := RPCBrokerV.Results[0]; //returns: error: -1; success=1
|
---|
| 1114 | if piece(RPCResult,'^',1)='-1' then begin
|
---|
| 1115 | // handle error...
|
---|
| 1116 | end else begin
|
---|
| 1117 | RPCBrokerV.Results.Delete(0);
|
---|
| 1118 | if RPCBrokerV.Results.Count=0 then begin
|
---|
| 1119 | //RPCBrokerV.Results.Add('0^<NO DATA>');
|
---|
| 1120 | end;
|
---|
| 1121 | end;
|
---|
| 1122 | Result := RPCBrokerV.Results;
|
---|
| 1123 | end;
|
---|
| 1124 |
|
---|
| 1125 |
|
---|
| 1126 | procedure TLogicRow.InitORComboBox(ORComboBox: TORComboBox; initValue : string; boxtype : string);
|
---|
| 1127 | begin
|
---|
| 1128 | ORComboBox.Items.Clear;
|
---|
| 1129 | ORComboBox.Text := ''; //initValue;
|
---|
| 1130 | ORComboBox.InitLongList(initValue);
|
---|
| 1131 | if ORComboBox.Items.Count > 0 then begin
|
---|
| 1132 | ORComboBox.ItemIndex := 0;
|
---|
| 1133 | ORComboBox.Text := Piece(ORComboBox.Items[0],'^',2);
|
---|
| 1134 | end else begin
|
---|
| 1135 | ORComboBox.Text := '<Begin by selecting ' + boxtype + '>';
|
---|
| 1136 | end;
|
---|
| 1137 | end;
|
---|
| 1138 |
|
---|
| 1139 | procedure TLogicRow.IndentMore;
|
---|
| 1140 | begin
|
---|
| 1141 | SetIndentLevel(FIndentLevel+1);
|
---|
| 1142 | end;
|
---|
| 1143 |
|
---|
| 1144 | procedure TLogicRow.IndentLess;
|
---|
| 1145 | begin
|
---|
| 1146 | if FIndentLevel>0 then SetIndentLevel(FIndentLevel-1);
|
---|
| 1147 | CheckVisibilityIsCorrect;
|
---|
| 1148 | end;
|
---|
| 1149 |
|
---|
| 1150 | //-----------------------------------------------------------------------
|
---|
| 1151 | // TLogicSet
|
---|
| 1152 | //-----------------------------------------------------------------------
|
---|
| 1153 |
|
---|
| 1154 | constructor TLogicSet.Create(SearchFileNumber,SearchFileName : string;
|
---|
| 1155 | AParent : TWinControl; AOwner : TComponent);
|
---|
| 1156 | begin
|
---|
| 1157 | Inherited Create;
|
---|
| 1158 | OnSearchStringChange := nil;
|
---|
| 1159 | SearchStringEdit := nil;
|
---|
| 1160 | DelBitmap := nil;
|
---|
| 1161 | Rows := TList.Create;
|
---|
| 1162 | FSimpleMode := True;
|
---|
| 1163 | FSearchFileNumber := SearchFileNumber;
|
---|
| 1164 | FSearchFileName := SearchFileName;
|
---|
| 1165 | FParent := AParent;
|
---|
| 1166 | FOwner := AOwner;
|
---|
| 1167 | FFileNumsStack := TStringList.Create;
|
---|
| 1168 | DelBitmap := TBitmap.Create;
|
---|
| 1169 |
|
---|
| 1170 | btnAddSrchField := TBitBtn.Create(AOwner);
|
---|
| 1171 | with btnAddSrchField do begin
|
---|
| 1172 | Visible := false;
|
---|
| 1173 | Parent := AParent;
|
---|
| 1174 | Height := 25;
|
---|
| 1175 | Width := 25;
|
---|
| 1176 | OnClick := HandleAddQuery;
|
---|
| 1177 | end;
|
---|
| 1178 |
|
---|
| 1179 | lblAddAnother := TLabel.Create(AOwner);
|
---|
| 1180 | with lblAddAnother do begin
|
---|
| 1181 | Visible := false;
|
---|
| 1182 | Parent := AParent;
|
---|
| 1183 | Caption := INT_ADD_QUERYROW_LABEL_CAPTION;
|
---|
| 1184 | Height := 15;
|
---|
| 1185 | Hint := 'Add More Search Terms';
|
---|
| 1186 | ShowHint := true;
|
---|
| 1187 | ParentShowHint := False;
|
---|
| 1188 | end;
|
---|
| 1189 |
|
---|
| 1190 | btnIndentMore := TButton.Create(AOwner);
|
---|
| 1191 | with btnIndentMore do begin
|
---|
| 1192 | Visible := false;
|
---|
| 1193 | Parent := AParent;
|
---|
| 1194 | Caption := '(';
|
---|
| 1195 | Height := 15;
|
---|
| 1196 | Width := 15;
|
---|
| 1197 | OnClick := HandleIndentMore;
|
---|
| 1198 | Hint := 'Start New Grouping';
|
---|
| 1199 | ShowHint := true;
|
---|
| 1200 | ParentShowHint := False;
|
---|
| 1201 | end;
|
---|
| 1202 |
|
---|
| 1203 | btnIndentLess := TButton.Create(AOwner);
|
---|
| 1204 | with btnIndentLess do begin
|
---|
| 1205 | Visible := false;
|
---|
| 1206 | Parent := AParent;
|
---|
| 1207 | Caption := ')';
|
---|
| 1208 | Height := 15;
|
---|
| 1209 | Width := 15;
|
---|
| 1210 | OnClick := HandleIndentLess;
|
---|
| 1211 | Hint := 'Close Grouping';
|
---|
| 1212 | ShowHint := true;
|
---|
| 1213 | ParentShowHint := False;
|
---|
| 1214 | end;
|
---|
| 1215 | //UpdateButtonPlacement; //Done in SetSimpleMode
|
---|
| 1216 | SetSimpleMode(FSimpleMode);
|
---|
| 1217 | end;
|
---|
| 1218 |
|
---|
| 1219 | Destructor TLogicSet.Destroy;
|
---|
| 1220 | var i : integer;
|
---|
| 1221 | ARow : TLogicRow;
|
---|
| 1222 | begin
|
---|
| 1223 | for i := 0 to Rows.Count-1 do begin
|
---|
| 1224 | ARow := GetRow(i); if ARow= nil then continue;
|
---|
| 1225 | ARow.Destroy;
|
---|
| 1226 | end;
|
---|
| 1227 | Rows.Free;
|
---|
| 1228 | FFileNumsStack.Free;
|
---|
| 1229 | btnAddSrchField.Free;
|
---|
| 1230 | lblAddAnother.Free;
|
---|
| 1231 | btnIndentMore.Free;
|
---|
| 1232 | btnIndentLess.Free;
|
---|
| 1233 | DelBitmap.Free;
|
---|
| 1234 | Inherited Destroy;
|
---|
| 1235 | end;
|
---|
| 1236 |
|
---|
| 1237 | function TLogicSet.GetRow(Index : integer): TLogicRow;
|
---|
| 1238 | begin
|
---|
| 1239 | if (Index > -1) and (Index < Rows.Count) then begin
|
---|
| 1240 | Result := TLogicRow(Rows.Items[Index]);
|
---|
| 1241 | end else Result := nil;
|
---|
| 1242 | end;
|
---|
| 1243 |
|
---|
| 1244 | function TLogicSet.GetRowCount : integer;
|
---|
| 1245 | begin
|
---|
| 1246 | Result := Rows.Count;
|
---|
| 1247 | end;
|
---|
| 1248 |
|
---|
| 1249 | function TLogicSet.IndexOf(ARow : TLogicRow) : integer;
|
---|
| 1250 | begin
|
---|
| 1251 | Result := Rows.IndexOf(ARow);
|
---|
| 1252 | end;
|
---|
| 1253 |
|
---|
| 1254 | function TLogicSet.AddRow : TLogicRow;
|
---|
| 1255 | var ALogicRow : TLogicRow;
|
---|
| 1256 | begin
|
---|
| 1257 | ALogicRow := TLogicRow.Create(FSearchFileNumber,FSearchFileName,FSimpleMode,
|
---|
| 1258 | FParent,Self,Rows.Count);
|
---|
| 1259 | ALogicRow.OnSearchStringChange := Handle1RowChange;
|
---|
| 1260 | if DelBitmap <> nil then ALogicRow.DelButton.Glyph.Assign(DelBitmap);
|
---|
| 1261 | Rows.Add(ALogicRow);
|
---|
| 1262 | Result := ALogicRow;
|
---|
| 1263 | if PriorRow <> nil then begin
|
---|
| 1264 | ALogicRow.IndentLevel := PriorRow.IndentLevel;
|
---|
| 1265 | PriorRow.CloseRow;
|
---|
| 1266 | end;
|
---|
| 1267 | UpdateButtonPlacement;
|
---|
| 1268 | end;
|
---|
| 1269 |
|
---|
| 1270 | procedure TLogicSet.DeleteRow(Index : integer);
|
---|
| 1271 | var ALogicRow, NextLogicRow : TLogicRow;
|
---|
| 1272 | i : integer;
|
---|
| 1273 | IndentLevel : integer;
|
---|
| 1274 | DeletingLastRow : boolean;
|
---|
| 1275 | GroupEmpty : boolean;
|
---|
| 1276 |
|
---|
| 1277 | begin
|
---|
| 1278 | If Rows.Count=1 then exit; //always leave at least one row present.
|
---|
| 1279 | if (Index < 0) or (Index > Rows.Count-1) then exit;
|
---|
| 1280 | DeletingLastRow := (Index = Rows.Count-1);
|
---|
| 1281 | ALogicRow := GetRow(Index);
|
---|
| 1282 | if ALogicRow <> nil then begin
|
---|
| 1283 | IndentLevel := ALogicRow.IndentLevel;
|
---|
| 1284 | ALogicRow.Destroy;
|
---|
| 1285 | end else begin
|
---|
| 1286 | IndentLevel := 0;
|
---|
| 1287 | end;
|
---|
| 1288 | Rows.Delete(Index);
|
---|
| 1289 | for i := 0 to Rows.Count-1 do begin
|
---|
| 1290 | ALogicRow := GetRow(i);
|
---|
| 1291 | if ALogicRow = nil then continue;
|
---|
| 1292 | ALogicRow.SetRowNum(i);
|
---|
| 1293 | ALogicRow.CheckVisibilityIsCorrect;
|
---|
| 1294 | end;
|
---|
| 1295 |
|
---|
| 1296 | //FIX!!! If row is a group starter, then all dependant rows should be
|
---|
| 1297 | // shifted leftward.
|
---|
| 1298 |
|
---|
| 1299 | //Check if row prior to that deleted was a group opener
|
---|
| 1300 | GroupEmpty := false; //default
|
---|
| 1301 | ALogicRow := GetRow(Index-1);
|
---|
| 1302 | NextLogicRow := GetRow(Index); //Next in list, that has pulled up into Index's position
|
---|
| 1303 | if (ALogicRow <> nil) and ALogicRow.NewGroupStarter then begin
|
---|
| 1304 | //Now see if group is now empty.
|
---|
| 1305 | if NextLogicRow=nil then begin
|
---|
| 1306 | GroupEmpty := true;
|
---|
| 1307 | end else if NextLogicRow.IndentLevel < IndentLevel then begin
|
---|
| 1308 | GroupEmpty := true;
|
---|
| 1309 | end;
|
---|
| 1310 | end;
|
---|
| 1311 | if GroupEmpty then begin
|
---|
| 1312 | if Rows.Count > 1 then begin
|
---|
| 1313 | DeleteRow(ALogicRow);
|
---|
| 1314 | end else begin
|
---|
| 1315 | ALogicRow.NewGroupStarter := false;
|
---|
| 1316 | end;
|
---|
| 1317 | end;
|
---|
| 1318 |
|
---|
| 1319 | if DeletingLastRow then begin
|
---|
| 1320 | ALogicRow := LastRow;
|
---|
| 1321 | if ALogicRow <> nil then begin
|
---|
| 1322 | ALogicRow.OpenRow;
|
---|
| 1323 | ALogicRow.CheckVisibilityIsCorrect;
|
---|
| 1324 | end;
|
---|
| 1325 | end;
|
---|
| 1326 | Handle1RowChange(self);
|
---|
| 1327 | UpdateButtonPlacement;
|
---|
| 1328 | end;
|
---|
| 1329 |
|
---|
| 1330 | procedure TLogicSet.DeleteRow(ARow : TLogicRow);
|
---|
| 1331 | //NOTE: Don't put details here. Put in OTHER DeleteRow above.
|
---|
| 1332 | var index : integer;
|
---|
| 1333 | begin
|
---|
| 1334 | index := IndexOf(ARow);
|
---|
| 1335 | DeleteRow(index);
|
---|
| 1336 | end;
|
---|
| 1337 |
|
---|
| 1338 | function TLogicSet.PriorRow : TLogicRow;
|
---|
| 1339 | begin
|
---|
| 1340 | if Rows.Count>1 then begin
|
---|
| 1341 | Result := TLogicRow(Rows.Items[Rows.Count-2]);
|
---|
| 1342 | end else Result := nil;
|
---|
| 1343 | end;
|
---|
| 1344 |
|
---|
| 1345 | function TLogicSet.LastRow : TLogicRow;
|
---|
| 1346 | begin
|
---|
| 1347 | if Rows.Count>0 then begin
|
---|
| 1348 | Result := TLogicRow(Rows.Items[Rows.Count-1]);
|
---|
| 1349 | end else Result := nil;
|
---|
| 1350 | end;
|
---|
| 1351 |
|
---|
| 1352 | function TLogicSet.RowBefore (ARow : TLogicRow) : TLogicRow;
|
---|
| 1353 | var index : integer;
|
---|
| 1354 | begin
|
---|
| 1355 | Result := nil;
|
---|
| 1356 | index := Rows.IndexOf(ARow);
|
---|
| 1357 | if index > 0 then Result := GetRow(Index-1);
|
---|
| 1358 | end;
|
---|
| 1359 |
|
---|
| 1360 | procedure TLogicSet.UpdateButtonPlacement;
|
---|
| 1361 | var ARow : TLogicRow;
|
---|
| 1362 | Left, Top : integer;
|
---|
| 1363 | begin
|
---|
| 1364 | ARow := LastRow;
|
---|
| 1365 | if ARow = nil then Top := 50 else Top := ARow.Top;
|
---|
| 1366 | If LastRow <> nil then Left := LastRow.FileBox.Left else Left := INT_ADD_QUERYROW_BTN_LEFT;
|
---|
| 1367 | btnAddSrchField.Top := Top + ADD_QUERY_OFFSET;
|
---|
| 1368 | btnAddSrchField.Left := Left;
|
---|
| 1369 | btnAddSrchField.Visible := true;
|
---|
| 1370 |
|
---|
| 1371 | lblAddAnother.Top := Top + ADD_QUERY_OFFSET + INT_COMPONENT_SPACING;
|
---|
| 1372 | lblAddAnother.Left := btnAddSrchField.Left + btnAddSrchField.Width + INT_COMPONENT_SPACING;
|
---|
| 1373 | lblAddAnother.Visible := true;
|
---|
| 1374 |
|
---|
| 1375 | btnIndentMore.Top := btnAddSrchField.Top + btnAddSrchField.Height + INT_COMPONENT_SPACING;
|
---|
| 1376 | btnIndentMore.Left := lblAddAnother.Left;
|
---|
| 1377 | btnIndentMore.Visible := not FSimpleMode;
|
---|
| 1378 |
|
---|
| 1379 | btnIndentLess.Top := btnIndentMore.Top;
|
---|
| 1380 | btnIndentLess.Left := btnIndentMore.Left + btnIndentMore.Width + + INT_COMPONENT_SPACING;
|
---|
| 1381 | btnIndentLess.Visible := not FSimpleMode;
|
---|
| 1382 | end;
|
---|
| 1383 |
|
---|
| 1384 |
|
---|
| 1385 | procedure TLogicSet.Handle1RowChange(Sender : TObject);
|
---|
| 1386 | begin
|
---|
| 1387 | FSearchString := GetSearchString;
|
---|
| 1388 | if Assigned(OnSearchStringChange) then OnSearchStringChange(Sender);
|
---|
| 1389 | if Assigned(SearchStringEdit) then SearchStringEdit.Text := FSearchString;
|
---|
| 1390 | end;
|
---|
| 1391 |
|
---|
| 1392 | procedure TLogicSet.HandleIndentMore(Sender : TObject);
|
---|
| 1393 | begin
|
---|
| 1394 | IndentMore;
|
---|
| 1395 | end;
|
---|
| 1396 |
|
---|
| 1397 | procedure TLogicSet.HandleIndentLess(Sender : TObject);
|
---|
| 1398 | begin
|
---|
| 1399 | IndentLess;
|
---|
| 1400 | end;
|
---|
| 1401 |
|
---|
| 1402 | procedure TLogicSet.HandleAddQuery(Sender : TObject);
|
---|
| 1403 | var ARow : TLogicRow;
|
---|
| 1404 | begin
|
---|
| 1405 | if RowCount > 0 then begin
|
---|
| 1406 | ARow := LastRow;
|
---|
| 1407 | if (ARow <> nil) and (ARow.IsValid=false) then begin
|
---|
| 1408 | MessageDlg('Please complete current row before adding a new one.',mtInformation,[mbOK],0);
|
---|
| 1409 | exit;
|
---|
| 1410 | end;
|
---|
| 1411 | end;
|
---|
| 1412 | AddRow;
|
---|
| 1413 | LastRow.Visible := true;
|
---|
| 1414 | UpdateButtonPlacement;
|
---|
| 1415 | end;
|
---|
| 1416 |
|
---|
| 1417 | procedure TLogicSet.IndentMore;
|
---|
| 1418 | var NewRow : TLogicRow;
|
---|
| 1419 | begin
|
---|
| 1420 | if LastRow.IsValid then begin
|
---|
| 1421 | NewRow := AddRow;
|
---|
| 1422 | end;
|
---|
| 1423 | LastRow.NewGroupStarter := true;
|
---|
| 1424 | NewRow := AddRow;
|
---|
| 1425 | NewRow.IndentMore;
|
---|
| 1426 | NewRow.Visible := true;
|
---|
| 1427 | end;
|
---|
| 1428 |
|
---|
| 1429 | procedure TLogicSet.IndentLess;
|
---|
| 1430 | var PriorRow, ARow : TLogicRow;
|
---|
| 1431 | begin
|
---|
| 1432 | ARow := LastRow;
|
---|
| 1433 | if ARow.IndentLevel = 0 then exit;
|
---|
| 1434 | if ARow.IsValid = true then begin
|
---|
| 1435 | ARow := AddRow;
|
---|
| 1436 | end;
|
---|
| 1437 | ARow.IndentLess;
|
---|
| 1438 | ARow.Visible := true;
|
---|
| 1439 | PriorRow := RowBefore(ARow);
|
---|
| 1440 | if PriorRow = nil then exit;
|
---|
| 1441 | if PriorRow.NewGroupStarter then begin
|
---|
| 1442 | DeleteRow(PriorRow);
|
---|
| 1443 | end;
|
---|
| 1444 | end;
|
---|
| 1445 |
|
---|
| 1446 | function TLogicSet.GetSearchString : string;
|
---|
| 1447 | var
|
---|
| 1448 | CurFile : string;
|
---|
| 1449 | ARow : TLogicRow;
|
---|
| 1450 | CurIndentLevel : integer;
|
---|
| 1451 | i : integer;
|
---|
| 1452 | begin
|
---|
| 1453 | FFileNumsStack.Clear;
|
---|
| 1454 | FFileNumsStack.Add('');
|
---|
| 1455 | Result := '';
|
---|
| 1456 | CurFile := '';
|
---|
| 1457 | CurIndentLevel := 0;
|
---|
| 1458 | for i := 0 to Rows.Count-1 do begin
|
---|
| 1459 | ARow := GetRow(i); if ARow = nil then continue;
|
---|
| 1460 | if ARow.IndentLevel > CurIndentLevel then begin
|
---|
| 1461 | Inc(CurIndentLevel);
|
---|
| 1462 | CurFile := '';
|
---|
| 1463 | FFileNumsStack.Add('');
|
---|
| 1464 | end else while (ARow.IndentLevel < CurIndentLevel) do begin
|
---|
| 1465 | Dec(CurIndentLevel);
|
---|
| 1466 | FFileNumsStack.Delete(FFileNumsStack.Count-1);
|
---|
| 1467 | CurFile := FFileNumsStack.Strings[FFileNumsStack.Count-1];
|
---|
| 1468 | Result := Result + ')';
|
---|
| 1469 | end;
|
---|
| 1470 | Result := Result + ARow.GetSearchString(CurFile);
|
---|
| 1471 | FFileNumsStack.Strings[FFileNumsStack.Count-1] := CurFile;
|
---|
| 1472 | end;
|
---|
| 1473 | while CurIndentLevel > 0 do begin
|
---|
| 1474 | Result := Result + ')';
|
---|
| 1475 | Dec(CurIndentLevel);
|
---|
| 1476 | end;
|
---|
| 1477 | end;
|
---|
| 1478 |
|
---|
| 1479 | procedure TLogicSet.SetSimpleMode(Value : boolean);
|
---|
| 1480 | begin
|
---|
| 1481 | FSimpleMode := Value;
|
---|
| 1482 | if Value = true then begin
|
---|
| 1483 | if Assigned(lblFile) then lblFile.Caption := 'Category';
|
---|
| 1484 | if Assigned(lblField) then lblField.Caption := 'Detail';
|
---|
| 1485 | if Assigned(lblOperator) then lblOperator.Visible := false;
|
---|
| 1486 | //if Assigned(lblValue) then lblValue.Caption := 'Value to Search For:';
|
---|
| 1487 | end else begin
|
---|
| 1488 | if Assigned(lblFile) then lblFile.Caption := 'Associated File';
|
---|
| 1489 | if Assigned(lblField) then lblField.Caption := 'Field';
|
---|
| 1490 | if Assigned(lblOperator) then lblOperator.Visible := True;
|
---|
| 1491 | //if Assigned(lblValue) then lblValue.Caption := 'Search Value';
|
---|
| 1492 | end;
|
---|
| 1493 | if Assigned(SearchStringEdit) then begin
|
---|
| 1494 | //SearchStringEdit.Visible := not Value;
|
---|
| 1495 | SearchStringEdit.ReadOnly := Value;
|
---|
| 1496 | SearchStringEdit.Enabled := not Value;
|
---|
| 1497 | SearchStringEdit.Color := Colors[not FSimpleMode];
|
---|
| 1498 | end;
|
---|
| 1499 | UpdateButtonPlacement;
|
---|
| 1500 | if LastRow <> nil then LastRow.SimpleMode := Value;
|
---|
| 1501 | end;
|
---|
| 1502 |
|
---|
| 1503 | procedure TLogicSet.SetFile(FileNumber,FileName : string);
|
---|
| 1504 | var i : integer;
|
---|
| 1505 | begin
|
---|
| 1506 | if (FSearchFileNumber=FileNumber) and (FSearchFileName=FileName) then exit;
|
---|
| 1507 | FSearchFileNumber := FileNumber;
|
---|
| 1508 | FSearchFileName := FileName;
|
---|
| 1509 | for i := 0 to Rows.Count - 1 do begin
|
---|
| 1510 | Self.Row[i].SetFile(FileNumber,FileName);
|
---|
| 1511 | end;
|
---|
| 1512 | end;
|
---|
| 1513 |
|
---|
| 1514 | procedure TLogicSet.Clear;
|
---|
| 1515 | begin
|
---|
| 1516 | while RowCount > 1 do begin
|
---|
| 1517 | DeleteRow(LastRow);
|
---|
| 1518 | end;
|
---|
| 1519 | if LastRow <> nil then LastRow.Clear;
|
---|
| 1520 | if Assigned(SearchStringEdit) then SearchStringEdit.Text := FSearchString;
|
---|
| 1521 | end;
|
---|
| 1522 |
|
---|
| 1523 |
|
---|
| 1524 | end.
|
---|
| 1525 |
|
---|