| 1 | unit fReportsAdhocSubItem1;
 | 
|---|
| 2 | 
 | 
|---|
| 3 | interface
 | 
|---|
| 4 | 
 | 
|---|
| 5 | uses
 | 
|---|
| 6 |   Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
 | 
|---|
| 7 |   StdCtrls, ExtCtrls, ORCtrls, Buttons, ORfn, fAutoSz;
 | 
|---|
| 8 | 
 | 
|---|
| 9 | type
 | 
|---|
| 10 |   TfrmReportsAdhocSubItem1 = class(TfrmAutoSz)
 | 
|---|
| 11 |     GroupBox1: TGroupBox;
 | 
|---|
| 12 |     Splitter3: TSplitter;
 | 
|---|
| 13 |     pnl7Button: TKeyClickPanel;
 | 
|---|
| 14 |     SpeedButton7: TSpeedButton;
 | 
|---|
| 15 |     pnl8Button: TKeyClickPanel;
 | 
|---|
| 16 |     SpeedButton8: TSpeedButton;
 | 
|---|
| 17 |     ORComboBox2: TORComboBox;
 | 
|---|
| 18 |     ORListBox1: TORListBox;
 | 
|---|
| 19 |     Panel4: TPanel;
 | 
|---|
| 20 |     Label4: TLabel;
 | 
|---|
| 21 |     Label5: TLabel;
 | 
|---|
| 22 |     Panel5: TPanel;
 | 
|---|
| 23 |     btnCancel: TButton;
 | 
|---|
| 24 |     Panel8: TPanel;
 | 
|---|
| 25 |     btnAddSel: TButton;
 | 
|---|
| 26 |     btnRemoveSel: TButton;
 | 
|---|
| 27 |     btnRemoveAllSel: TButton;
 | 
|---|
| 28 |     btnOK: TButton;
 | 
|---|
| 29 |     Timer2: TTimer;
 | 
|---|
| 30 |     Label6: TStaticText;
 | 
|---|
| 31 |     lblLimit: TStaticText;
 | 
|---|
| 32 |     procedure btnCancelClick(Sender: TObject);
 | 
|---|
| 33 |     procedure FormCreate(Sender: TObject);
 | 
|---|
| 34 |     procedure ORListBox1EndDrag(Sender, Target: TObject; X, Y: Integer);
 | 
|---|
| 35 |     procedure ORListBox1DragDrop(Sender, Source: TObject; X, Y: Integer);
 | 
|---|
| 36 |     procedure ORListBox1DragOver(Sender, Source: TObject; X, Y: Integer;
 | 
|---|
| 37 |       State: TDragState; var Accept: Boolean);
 | 
|---|
| 38 |     procedure Timer2Timer(Sender: TObject);
 | 
|---|
| 39 |     procedure SpeedButton8Click(Sender: TObject);
 | 
|---|
| 40 |     procedure SpeedButton7Click(Sender: TObject);
 | 
|---|
| 41 |     procedure btnRemoveAllSelClick(Sender: TObject);
 | 
|---|
| 42 |     procedure btnRemoveSelClick(Sender: TObject);
 | 
|---|
| 43 |     procedure btnOKClick(Sender: TObject);
 | 
|---|
| 44 |     procedure btnAddSelClick(Sender: TObject);
 | 
|---|
| 45 |     procedure ORComboBox2KeyUp(Sender: TObject; var Key: Word;
 | 
|---|
| 46 |       Shift: TShiftState);
 | 
|---|
| 47 |     procedure ORComboBox2NeedData(Sender: TObject; const StartFrom: String;
 | 
|---|
| 48 |       Direction, InsertAt: Integer);
 | 
|---|
| 49 |     procedure pnl7ButtonEnter(Sender: TObject);
 | 
|---|
| 50 |     procedure pnl7ButtonExit(Sender: TObject);
 | 
|---|
| 51 |   private
 | 
|---|
| 52 |     { Private declarations }
 | 
|---|
| 53 |     GoingUp: Boolean;
 | 
|---|
| 54 |     OKPressed: Boolean;
 | 
|---|
| 55 |   public
 | 
|---|
| 56 |     { Public declarations }
 | 
|---|
| 57 |   end;
 | 
|---|
| 58 | 
 | 
|---|
| 59 | var
 | 
|---|
| 60 |   frmReportsAdhocSubItem1: TfrmReportsAdhocSubItem1;
 | 
|---|
| 61 | 
 | 
|---|
| 62 | function ExecuteForm2: Boolean;
 | 
|---|
| 63 | 
 | 
|---|
| 64 | implementation
 | 
|---|
| 65 | 
 | 
|---|
| 66 | uses fReportsAdhocComponent1, rReports;
 | 
|---|
| 67 | 
 | 
|---|
| 68 | {$R *.DFM}
 | 
|---|
| 69 | 
 | 
|---|
| 70 | function ExecuteForm2: Boolean;
 | 
|---|
| 71 | begin
 | 
|---|
| 72 |   Result := False;
 | 
|---|
| 73 |   frmReportsAdhocSubItem1 := TfrmReportsAdhocSubItem1.Create(Application);
 | 
|---|
| 74 |   try
 | 
|---|
| 75 |     ResizeFormToFont(TForm(frmReportsAdhocSubItem1));
 | 
|---|
| 76 |     frmReportsAdhocSubItem1.ShowModal;
 | 
|---|
| 77 |     if frmReportsAdhocSubItem1.OKPressed then
 | 
|---|
| 78 |       Result := True;
 | 
|---|
| 79 |   finally
 | 
|---|
| 80 |     frmReportsAdhocSubItem1.Release;
 | 
|---|
| 81 |   end;
 | 
|---|
| 82 | end;
 | 
|---|
| 83 | 
 | 
|---|
| 84 | procedure TfrmReportsAdhocSubItem1.btnCancelClick(Sender: TObject);
 | 
|---|
| 85 | begin
 | 
|---|
| 86 |   ORComboBox2.Clear;
 | 
|---|
| 87 |   ORListBox1.Clear;
 | 
|---|
| 88 |   close;
 | 
|---|
| 89 | end;
 | 
|---|
| 90 | 
 | 
|---|
| 91 | procedure TfrmReportsAdhocSubItem1.FormCreate(Sender: TObject);
 | 
|---|
| 92 | var
 | 
|---|
| 93 |   i: integer;
 | 
|---|
| 94 | begin
 | 
|---|
| 95 |   uLimitCount := 1;
 | 
|---|
| 96 |   OKPressed := False;
 | 
|---|
| 97 |   Panel8.Left := Splitter3.Left + Splitter3.Width;
 | 
|---|
| 98 |   Panel8.Align := Splitter3.Align;
 | 
|---|
| 99 |   ORListBox1.Left := Panel8.Left + Panel8.Width;
 | 
|---|
| 100 |   ORListBox1.Align := Panel8.Align;
 | 
|---|
| 101 |   RedrawSuspend(ORComboBox2.Handle);
 | 
|---|
| 102 |   ORComboBox2.InitLongList('');
 | 
|---|
| 103 |   RedrawActivate(ORComboBox2.Handle);
 | 
|---|
| 104 |   If uLimit>0 then
 | 
|---|
| 105 |         lblLimit.Caption := IntToStr(uLimit)
 | 
|---|
| 106 |       else
 | 
|---|
| 107 |         lblLimit.Caption := 'No Limit';
 | 
|---|
| 108 |   ORListBox1.Caption := 'File Entries Selected ( Selections Allowed: ' +
 | 
|---|
| 109 |     lblLimit.Caption + ')';
 | 
|---|
| 110 |   Caption := Piece(frmReportsAdhocComponent1.ORComboBox1.Items
 | 
|---|
| 111 |     [frmReportsAdhocComponent1.ORComboBox1.ItemIndex],'^',2);
 | 
|---|
| 112 |   for i := 0 to uComponents.Count-1 do
 | 
|---|
| 113 |     if piece(uComponents[i],'^',1) = IntToStr(uCurrentComponent) then
 | 
|---|
| 114 |       ORListBox1.Items.Add(Pieces(uComponents[i],'^',3,10));
 | 
|---|
| 115 | end;
 | 
|---|
| 116 | 
 | 
|---|
| 117 | procedure TfrmReportsAdhocSubItem1.ORListBox1EndDrag(Sender, Target: TObject; X, Y: Integer);
 | 
|---|
| 118 | begin
 | 
|---|
| 119 |   if (Sender = ORListBox1) and (Target = ORComboBox2) then
 | 
|---|
| 120 |     btnRemoveSelClick(nil);
 | 
|---|
| 121 |   Timer2.Enabled := False;
 | 
|---|
| 122 | end;
 | 
|---|
| 123 | 
 | 
|---|
| 124 | procedure TfrmReportsAdhocSubItem1.ORListBox1DragDrop(Sender, Source: TObject; X,
 | 
|---|
| 125 |   Y: Integer);
 | 
|---|
| 126 | var
 | 
|---|
| 127 |   NuPos: Integer;
 | 
|---|
| 128 | begin
 | 
|---|
| 129 |   with Sender as TORListbox do
 | 
|---|
| 130 |     begin
 | 
|---|
| 131 |       NuPos := ItemAtPos(Point(X,Y),False);
 | 
|---|
| 132 |       If NuPos >= Items.Count then Dec(NuPos);
 | 
|---|
| 133 |       Items.Move(ItemIndex, NuPos);
 | 
|---|
| 134 |       ItemIndex := NuPos;
 | 
|---|
| 135 |     end;
 | 
|---|
| 136 | end;
 | 
|---|
| 137 | 
 | 
|---|
| 138 | procedure TfrmReportsAdhocSubItem1.ORListBox1DragOver(Sender, Source: TObject; X, Y: Integer;
 | 
|---|
| 139 |   State: TDragState; var Accept: Boolean);
 | 
|---|
| 140 | begin
 | 
|---|
| 141 |   Accept := (Sender = Source) and (TORListBox(Sender).ItemAtPos(Point(x,y), False) >= 0);
 | 
|---|
| 142 |   if Accept then
 | 
|---|
| 143 |     with Sender as TORListbox do
 | 
|---|
| 144 |       if Y > Height - ItemHeight then
 | 
|---|
| 145 |         begin
 | 
|---|
| 146 |           GoingUp := False;
 | 
|---|
| 147 |           Timer2.Enabled := True;
 | 
|---|
| 148 |         end
 | 
|---|
| 149 |       else if Y < ItemHeight then
 | 
|---|
| 150 |         begin
 | 
|---|
| 151 |           GoingUp := True;
 | 
|---|
| 152 |           Timer2.Enabled := True;
 | 
|---|
| 153 |         end
 | 
|---|
| 154 |       else Timer2.Enabled := False;
 | 
|---|
| 155 | end;
 | 
|---|
| 156 | 
 | 
|---|
| 157 | procedure TfrmReportsAdhocSubItem1.Timer2Timer(Sender: TObject);
 | 
|---|
| 158 | begin
 | 
|---|
| 159 |  with ORListBox1 do
 | 
|---|
| 160 |     if GoingUp then
 | 
|---|
| 161 |       if TopIndex > 0 then TopIndex := TopIndex - 1
 | 
|---|
| 162 |       else Timer2.Enabled := False
 | 
|---|
| 163 |     else
 | 
|---|
| 164 |       if TopIndex < Items.Count - 1 then TopIndex := TopIndex + 1
 | 
|---|
| 165 |       else Timer2.Enabled := False;
 | 
|---|
| 166 | end;
 | 
|---|
| 167 | 
 | 
|---|
| 168 | procedure TfrmReportsAdhocSubItem1.SpeedButton8Click(Sender: TObject);
 | 
|---|
| 169 | var
 | 
|---|
| 170 |   i : Integer;
 | 
|---|
| 171 | begin
 | 
|---|
| 172 |   with ORListbox1 do
 | 
|---|
| 173 |     if (ItemIndex < Items.Count-1) and
 | 
|---|
| 174 |        (ItemIndex <> -1) then
 | 
|---|
| 175 |       begin
 | 
|---|
| 176 |         i := ItemIndex;
 | 
|---|
| 177 |         Items.Move(i, i+1);
 | 
|---|
| 178 |         ItemIndex := i+1;
 | 
|---|
| 179 |       end;
 | 
|---|
| 180 | end;
 | 
|---|
| 181 | 
 | 
|---|
| 182 | procedure TfrmReportsAdhocSubItem1.SpeedButton7Click(Sender: TObject);
 | 
|---|
| 183 | var
 | 
|---|
| 184 |   i:integer;
 | 
|---|
| 185 | begin
 | 
|---|
| 186 |   with ORListBox1 do
 | 
|---|
| 187 |     if ItemIndex > 0 then
 | 
|---|
| 188 |       begin
 | 
|---|
| 189 |         i := ItemIndex;
 | 
|---|
| 190 |         Items.Move(i, i-1);
 | 
|---|
| 191 |         ItemIndex := i-1;
 | 
|---|
| 192 |       end;
 | 
|---|
| 193 | end;
 | 
|---|
| 194 | 
 | 
|---|
| 195 | procedure TfrmReportsAdhocSubItem1.btnRemoveAllSelClick(Sender: TObject);
 | 
|---|
| 196 | var
 | 
|---|
| 197 |   i: integer;
 | 
|---|
| 198 | begin
 | 
|---|
| 199 |   If ORListBox1.Items.Count < 1 then
 | 
|---|
| 200 |     begin
 | 
|---|
| 201 |       InfoBox('There are no items to remove.', 'Information', MB_OK or MB_ICONINFORMATION);
 | 
|---|
| 202 |       Exit;
 | 
|---|
| 203 |     end;
 | 
|---|
| 204 |   if InfoBox('This button will remove all selected items. OK?',
 | 
|---|
| 205 |     'Confirmation', MB_YESNO or MB_ICONQUESTION) = IDYES then
 | 
|---|
| 206 |     begin
 | 
|---|
| 207 |       With ORListBox1 do
 | 
|---|
| 208 |         begin
 | 
|---|
| 209 |           for i := uComponents.Count-1 downto 0 do
 | 
|---|
| 210 |             uComponents.Delete(i);
 | 
|---|
| 211 |           for i := Items.Count-1 downto 0 do
 | 
|---|
| 212 |             Items.Delete(i);
 | 
|---|
| 213 |         end;
 | 
|---|
| 214 |       uLimitCount := 1;
 | 
|---|
| 215 |       SpeedButton7.Enabled := false;
 | 
|---|
| 216 |       SpeedButton8.Enabled := false;
 | 
|---|
| 217 |     end;
 | 
|---|
| 218 | end;
 | 
|---|
| 219 | 
 | 
|---|
| 220 | procedure TfrmReportsAdhocSubItem1.btnRemoveSelClick(Sender: TObject);
 | 
|---|
| 221 | var
 | 
|---|
| 222 |   i: integer;
 | 
|---|
| 223 |   chk: integer;
 | 
|---|
| 224 | begin
 | 
|---|
| 225 |   chk := 0;
 | 
|---|
| 226 |   If ORListBox1.Items.Count < 1 then
 | 
|---|
| 227 |     begin
 | 
|---|
| 228 |       InfoBox('There are no items to remove.', 'Information', MB_OK or MB_ICONINFORMATION);
 | 
|---|
| 229 |       Exit;
 | 
|---|
| 230 |     end
 | 
|---|
| 231 |   else
 | 
|---|
| 232 |     for i := 0 to ORListBox1.Items.Count - 1 do
 | 
|---|
| 233 |       if ORListBox1.Selected[i] then
 | 
|---|
| 234 |           chk := 1;
 | 
|---|
| 235 |     if chk = 0 then
 | 
|---|
| 236 |       begin
 | 
|---|
| 237 |         InfoBox('Please select the item you wish to remove', 'Information', MB_OK or MB_ICONINFORMATION);
 | 
|---|
| 238 |         Exit;
 | 
|---|
| 239 |       end;
 | 
|---|
| 240 |     With ORListBox1 do
 | 
|---|
| 241 |       begin
 | 
|---|
| 242 |         for i := uComponents.Count-1 downto 0 do
 | 
|---|
| 243 |           if piece(uComponents[i],'^',2) = Piece(Items[ItemIndex],'^',1) then
 | 
|---|
| 244 |             uComponents.Delete(i);
 | 
|---|
| 245 |         Items.Delete(ItemIndex);
 | 
|---|
| 246 |         uLimitCount := uLimitCount - 1;
 | 
|---|
| 247 |         if Items.Count < 1 then
 | 
|---|
| 248 |           begin
 | 
|---|
| 249 |             SpeedButton7.Enabled := false;
 | 
|---|
| 250 |             SpeedButton8.Enabled := false;
 | 
|---|
| 251 |           end;
 | 
|---|
| 252 |       end;
 | 
|---|
| 253 | end;
 | 
|---|
| 254 | 
 | 
|---|
| 255 | procedure TfrmReportsAdhocSubItem1.btnOKClick(Sender: TObject);
 | 
|---|
| 256 | var
 | 
|---|
| 257 |   i: integer;
 | 
|---|
| 258 |   uTestList: TStringList;
 | 
|---|
| 259 | begin
 | 
|---|
| 260 |   uTestList := TStringList.Create;
 | 
|---|
| 261 |   uTestList.Clear;
 | 
|---|
| 262 |   for i := 0 to ORListBox1.Items.Count-1 do
 | 
|---|
| 263 |     uTestList.Add(ORListBox1.Items[i]);
 | 
|---|
| 264 |   for i := uComponents.Count-1 downto 0 do
 | 
|---|
| 265 |     if piece(uComponents[i],'^',1)=IntToStr(uCurrentComponent) then
 | 
|---|
| 266 |       uComponents.Delete(i);
 | 
|---|
| 267 |   for i := 0 to uTestList.Count-1 do
 | 
|---|
| 268 |     if (uLimit = 0) or (i < uLimit) then
 | 
|---|
| 269 |       uComponents.Add(IntToStr(uCurrentComponent)
 | 
|---|
| 270 |         + '^' + uFile + '^' + uTestList[i]);
 | 
|---|
| 271 |   OKPressed := True;
 | 
|---|
| 272 |   ORListBox1.Clear;
 | 
|---|
| 273 |   uTestList.Free;
 | 
|---|
| 274 |   Close;
 | 
|---|
| 275 | end;
 | 
|---|
| 276 | 
 | 
|---|
| 277 | procedure TfrmReportsAdhocSubItem1.btnAddSelClick(Sender: TObject);
 | 
|---|
| 278 | var
 | 
|---|
| 279 |   i: integer;
 | 
|---|
| 280 |   uHSSubItems: TStringList;
 | 
|---|
| 281 | begin
 | 
|---|
| 282 |   If (uLimit <> 0) and (uLimitCount > uLimit) then
 | 
|---|
| 283 |     begin
 | 
|---|
| 284 |       Application.MessageBox(
 | 
|---|
| 285 |       'Sorry, you have reached the selection limit for this component',
 | 
|---|
| 286 |       'Selection Error',MB_OK + MB_DEFBUTTON1);
 | 
|---|
| 287 |       Exit;
 | 
|---|
| 288 |     end;
 | 
|---|
| 289 |   If ORComboBox2.ItemIndex < 0 then
 | 
|---|
| 290 |     begin
 | 
|---|
| 291 |       InfoBox('Please select an item to Add.', 'Information', MB_OK or MB_ICONINFORMATION);
 | 
|---|
| 292 |       Exit;
 | 
|---|
| 293 |     end;
 | 
|---|
| 294 |   If uFile = '60' then
 | 
|---|
| 295 |     begin
 | 
|---|
| 296 |       uHSSubItems := TStringList.Create;
 | 
|---|
| 297 |       HSSubItems(uHSSubItems,
 | 
|---|
| 298 |         Piece(ORComboBox2.Items[ORComboBox2.ItemIndex],'^',1));
 | 
|---|
| 299 |       If uHSSubItems.Count > 0 then
 | 
|---|
| 300 |         for i := 0 to uHSSubItems.Count-1 do
 | 
|---|
| 301 |           begin
 | 
|---|
| 302 |             ORListBox1.Items.Add(uHSSubItems[i]);
 | 
|---|
| 303 |             uLimitCount := uLimitCount + 1;
 | 
|---|
| 304 |           end
 | 
|---|
| 305 |       Else
 | 
|---|
| 306 |         begin
 | 
|---|
| 307 |           ORListBox1.Items.Add(ORComboBox2.Items[ORComboBox2.ItemIndex]);
 | 
|---|
| 308 |           uLimitCount := uLimitCount + 1;
 | 
|---|
| 309 |         end;
 | 
|---|
| 310 |       uHSSubItems.Free;
 | 
|---|
| 311 |     end
 | 
|---|
| 312 |   Else
 | 
|---|
| 313 |     begin
 | 
|---|
| 314 |       ORListBox1.Items.Add(ORComboBox2.Items[ORComboBox2.ItemIndex]);
 | 
|---|
| 315 |       uLimitCount := uLimitCount + 1;
 | 
|---|
| 316 |     end;
 | 
|---|
| 317 |   If (uLimit <> 0) and (uLimitCount > (uLimit+1)) then
 | 
|---|
| 318 |     ShowMessage(
 | 
|---|
| 319 |       'MAXIMUM SELECTION LIMIT EXCEEDED! Only the first '
 | 
|---|
| 320 |       + IntToStr(uLimit) + ' items in the list will be used');
 | 
|---|
| 321 |   If ORListBox1.Items.Count > 0 then
 | 
|---|
| 322 |     begin
 | 
|---|
| 323 |       SpeedButton7.Enabled := true;
 | 
|---|
| 324 |       SpeedButton8.Enabled := true;
 | 
|---|
| 325 |     end;
 | 
|---|
| 326 |   btnOK.SetFocus;
 | 
|---|
| 327 | end;
 | 
|---|
| 328 | 
 | 
|---|
| 329 | procedure TfrmReportsAdhocSubItem1.ORComboBox2KeyUp(Sender: TObject;
 | 
|---|
| 330 |   var Key: Word; Shift: TShiftState);
 | 
|---|
| 331 | begin
 | 
|---|
| 332 |   If Key = 13 then
 | 
|---|
| 333 |     with ORComboBox2 do
 | 
|---|
| 334 |       if (Text <> '') and (Items.IndexOf (Text) >= 0) then
 | 
|---|
| 335 |         begin
 | 
|---|
| 336 |           ItemIndex := Items.IndexOf(Text);
 | 
|---|
| 337 |           btnAddSelClick(nil);
 | 
|---|
| 338 |           Key := 0;
 | 
|---|
| 339 |         end;
 | 
|---|
| 340 | end;
 | 
|---|
| 341 | 
 | 
|---|
| 342 | procedure TfrmReportsAdhocSubItem1.ORComboBox2NeedData(Sender: TObject;
 | 
|---|
| 343 |   const StartFrom: String; Direction, InsertAt: Integer);
 | 
|---|
| 344 | begin
 | 
|---|
| 345 |   ORComboBox2.ForDataUse(HSFileLookup(uFile,StartFrom,Direction));
 | 
|---|
| 346 | end;
 | 
|---|
| 347 | 
 | 
|---|
| 348 | procedure TfrmReportsAdhocSubItem1.pnl7ButtonEnter(Sender: TObject);
 | 
|---|
| 349 | begin
 | 
|---|
| 350 |   inherited;
 | 
|---|
| 351 |   (sender as TPanel).BevelOuter := bvRaised;
 | 
|---|
| 352 | end;
 | 
|---|
| 353 | 
 | 
|---|
| 354 | procedure TfrmReportsAdhocSubItem1.pnl7ButtonExit(Sender: TObject);
 | 
|---|
| 355 | begin
 | 
|---|
| 356 |   inherited;
 | 
|---|
| 357 |   (sender as TPanel).BevelOuter := bvNone;
 | 
|---|
| 358 | end;
 | 
|---|
| 359 | 
 | 
|---|
| 360 | end.
 | 
|---|