*

*  $RCSfile: ReportWizard.java,v $

*

*  $Revision: 1.54.28.1 $

*

*  last change: $Author: vg $ $Date: 2004/01/28 11:32:21 $

*

*  The Contents of this file are made available subject to the terms of

*  either of the following licenses

*

*         - GNU Lesser General Public License Version 2.1

*         - Sun Industry Standards Source License Version 1.1

*

*  Sun Microsystems Inc., October, 2000

*

*  GNU Lesser General Public License Version 2.1

*  =============================================

*  Copyright 2000 by Sun Microsystems, Inc.

*  901 San Antonio Road, Palo Alto, CA 94303, USA

*

*  This library is free software; you can redistribute it and/or

*  modify it under the terms of the GNU Lesser General Public

*  License version 2.1, as published by the Free Software Foundation.

*

*  This library is distributed in the hope that it will be useful,

*  but WITHOUT ANY WARRANTY; without even the implied warranty of

*  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU

*  Lesser General Public License for more details.

*

*  You should have received a copy of the GNU Lesser General Public

*  License along with this library; if not, write to the Free Software

*  Foundation, Inc., 59 Temple Place, Suite 330, Boston,

*  MA  02111-1307  USA

*

*

*  Sun Industry Standards Source License Version 1.1

*  =================================================

*  The contents of this file are subject to the Sun Industry Standards

*  Source License Version 1.1 (the "License"); You may not use this file

*  except in compliance with the License. You may obtain a copy of the

*  License at http://www.openoffice.org/license.html.

*

*  Software provided under this License is provided on an "AS IS" basis,

*  WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING,

*  WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS,

*  MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.

*  See the License for the specific provisions governing your rights and

*  obligations concerning the Software.

*

*  The Initial Developer of the Original Code is: Sun Microsystems, Inc.

*

*  Copyright: 2000 by Sun Microsystems, Inc.

*

*  All Rights Reserved.

*

*  Contributor(s): _______________________________________

*

*/

    XMultiServiceFactory xMSF;

    UNODialogs CurUNODialog;

    UNODialogs CurUNOProgressDialog;

    final String SOREPORTFORMNAME = "ReportSource";

    final int MAXSORTCRITERIA = 3;

   

    final int SOCMDCANCEL = 1;

    final int SOCMDHELP = 2;

    final int SOCMDBACK = 3;

    final int SOCMDGOON = 4;

    final int SOCMDMOVESEL = 5;

    final int SOCMDMOVEALL = 6;

    final int SOCMDREMOVESEL = 7;

    final int SOCMDREMOVEALL = 8;

    final int SOFLDSLST =  9;

    final int SODBLST =  10;

    final int SOTBLLST =  11;

    final int SOSELFLDSLST =  12;

    final int SOGROUPLST = 13;

   

    final int SOFIRSTSORTLST = 14;

    final int SOSECSORTLST = 15;

    final int SOTHIRDSORTLST = 16;

    final int SOFOURTHSORTLST = 17;

    final int[] SOSORTLST = new int[]{SOFIRSTSORTLST, SOSECSORTLST, SOTHIRDSORTLST, SOFOURTHSORTLST};

   

    final int SOFIRSTSORTASCOPT = 18;

    final int SOSECSORTASCOPT = 19;

    final int SOTHIRDSORTASCOPT = 20;

    final int SOFOURTHSORTASCOPT = 21;

   

    final int SOFIRSTSORTDESCOPT = 22;

    final int SOSECSORTDESCOPT = 23;

    final int SOTHIRDSORTDESCOPT = 24;

    final int SOFOURTHSORTDESCOPT = 25;

   

    final int[] SOSORTASCENDOPT = new int[] {SOFIRSTSORTASCOPT, SOSECSORTASCOPT, SOTHIRDSORTASCOPT, SOFOURTHSORTASCOPT};

    final int[] SOSORTDESCENDOPT = new int[] {SOFIRSTSORTDESCOPT, SOSECSORTDESCOPT, SOTHIRDSORTDESCOPT, SOFOURTHSORTDESCOPT};

   

    final int SOCMDGROUPIN = 26;

    final int SOCMDGROUPOUT = 27;

    final int SOTXTTITLE = 28;

    final int SOCONTENTLST = 29;

   

    final int SOOPTLANDSCAPE = 30;

    final int SOOPTPORTRAIT = 31;

    final int SOLAYOUTLST = 32;

    final int SOSELGROUPLST = 33;

    //     final int SOOPTSAVEASTEMPLATE = 34;

    //     final int SOOPTSAVEASDOCUMENT = 35;

   

    final int SOOPTSAVEASTEMPLATE = 40;

    final int SOOPTEDITTEMPLATE = 41;

    final int SOOPTUSEDOCUMENT = 42;

    final int SOOPTSAVEASDOCUMENT = 43;

   

    final int SOCMDFIRSTPATHSELECT = 44;

    final int SOCMDSECPATHSELECT = 45;

    final int SOTXTFIRSTSAVEPATH = 46;

    final int SOTXTSECSAVEPATH = 47;

    final int SOTXTCOLTITLE = 48;

    final int SOTITLESCROLLBAR = 49;

   

    final int[] SOCMDSELECTPATH = new int[] {SOCMDFIRSTPATHSELECT, SOCMDSECPATHSELECT};

    final int[] SOTXTSAVEPATH = new int[] {SOTXTFIRSTSAVEPATH, SOTXTSECSAVEPATH};

    final int SONULLPAGE = 0;

    final int SOMAINPAGE = 1;

    final int SOTITLEPAGE = 2;

    final int SOGROUPPAGE = 3;

    final int SOSORTPAGE = 4;

    final int SOTEMPLATEPAGE = 5;

    final int SOSTOREPAGE = 6;   

   

    short CurTabIndex;

    int MaxSortIndex = -1;

    int TextFieldCount;

    int PageAddCount;

    String[] sDatabaseList;

    static String[] TableNames;

    static String[] QueryNames;

    static String[] sSortHeader = new String[4];

    static String[] sSortAscend = new String[4];

    static String[] sSortDescend = new String[4];

    static short[] bOldSortValues = new short[4];

    XTextComponent xTitleTextBox;

    XTextComponent[] xSaveTextBox = new XTextComponent[2];

   

    XListBox xDBListBox;

    XListBox xTableListBox;

    XListBox xFieldsListBox;

    XListBox xSelFieldsListBox;

    XListBox xContentListBox;

    XListBox xSelGroupListBox;

    Object chkTemplate;

    XListBox[] xSortListBox = new XListBox[4];

    XListBox xGroupListBox;

    XListBox xLayoutListBox;

    Object lblHeaderText;

    XNameAccess xTableNames;

    XNameAccess xQueryNames;

   

    XTablesSupplier xDBTables;

    Object oDBTable;

    int[][] WidthList;

    int UITextFieldCount = 7;

    boolean bEnableBinaryOptionGroup;

    boolean bcreateTemplate;

    boolean buseTemplate;

    boolean bcreateLink;

    boolean[] baskbeforeOverwrite = new boolean[2];

    boolean[] bmodifiedbySaveAsDialog = new boolean[2];

    boolean bfinalaskbeforeOverwrite;

//    boolean[] bDataSourceIsSelected = new boolean[1];

    int iOldContentPos;

    int iOldLayoutPos;

    int ScrollBarValue;

    int CurSortItemIndex;

    String[] OriginalList = new String[]{""};

    static XDesktop xDesktop;

    ReportDocument CurReportDocument;

    ReportPaths CurReportPaths;

    String DefaultName;

    String OldDefaultName;

    java.util.Vector GroupFieldVector;

    String TemplatePath;

    String[] SavePath = new String[2];

   

    static String sMsgWizardName;

    static String scmdReady;

    static String scmdCancel;

    static String scmdBack;

    static String scmdHelp;

    static String scmdGoOn;

    static String slblDatabases;

    static String slblTables;

    static String slblFields;

    static String slblSelFields;

    static String sShowBinaryFields;

    static String slblDataStructure;

    static String slblPageLayout;

    static String sOrganizeFields;

    static String sNoSorting;

    static String sSortCriteriaisduplicate;

    static String sOrientationHeader;

    static String sOrientVertical;

    static String sOrientHorizontal;

    static String sSaveAsTemplate;

    static String sReportTitle;

    static String sSaveAsDocument;

    static String sSaveAs;

    static String sUseTemplate;

    static String sEditTemplate;

    static String sCreateLink;

    static String sCreateLinkAutomatically;

    static String sGroupings;

    static String[] WizardHeaderText = new String[6];

    static String[] WizardTitle = new String[6];

    static String sWriterFilterName;

    static String StorePath = "";

    static String slstDatabasesDefaultText;

    static String slstTablesDefaultText;

    static String AccessTextMoveSelected;

    static String AccessTextRemoveSelected;

    static String AccessTextMoveAll;

    static String AccessTextRemoveAll;

    static String sMsgErrorOccured;

    static String sMsgNoDatabaseAvailable;

    static String sMsgCommandCouldNotbeOpened;

    static String sMsgSavingImpossible;

    static String sMsgLinkCreationImpossible;

    static String sMsgNoTableInDatabase;

    static String sMsgNoConnection;

    // Progress display relevant Strings

    static String sProgressTitle;

    static String sStop;

    static String sProgressDBConnection;

    static String sProgressDataImport;

    static String sProgressBaseCurRecord;

    static String sProgressCurRecord;

    static String sReportFormNotExisting;

    static String slblColumnTitles;

    static String slblColumnNames;

    static String sMsgEndAutopilot;

    static String sMsgTableNotExisting;

    static String sMsgNoDBConnection;

    static String sMsgConnectionImpossible;

    static String sMsgNoConnectionforDataimport;

    static String sMsgQueryCreationImpossible;

    static String sMsgHiddenControlMissing;

    static String sMsgFilePathInvalid;

    static String sMsgCommonReportError;

    static String sMsgInvalidTextField;

    static String[] ReportMessages = new String[4];

    static String sBlindTextNote;

    boolean bCloseDocument;

   

    public ReportWizard() {

    }

   

    private void getSelectedDBMetaData(XMultiServiceFactory xMSF){

  try{

      boolean bGetConnection = false;

      short DBIndex = xDBListBox.getSelectedItemPos();

      if (DBIndex > -1){

    CurReportDocument.CurDBMetaData.DataSourceName = CurReportDocument.CurDBMetaData.DataSourceNames[DBIndex];

    if (CurReportDocument.CurDBMetaData.bConnectionOvergiven != true)

        bGetConnection = CurReportDocument.CurDBMetaData.getConnection(sMsgNoConnection, sMsgConnectionImpossible);

    else

        bGetConnection = true;

    fillupCommandListBox(CurReportDocument.CurDBMetaData, false);

      }

      if (bGetConnection == false)

    CurUNODialog.assignPropertyToDialogControl("lstDatabases", "SelectedItems", new short[]{});

      CurUNODialog.assignPropertyToDialogControl("cmdGoOn", "Enabled", new Boolean(false));

  }

  catch(Tools.TerminateWizardException exception){}

  catch(Exception exception) {

      exception.printStackTrace(System.out);

  }}

   

   

    // returns the selected entry index in the commandListbox

    private short fillupCommandListBox(DBMetaData CurDBMetaData, boolean bpreselectCommand) throws Tools.TerminateWizardException{

  short iSelPos = 0;

  short[] iSelArray = new short[0];

  boolean bgetFields = false;

  String[] ContentList = new String[0];

  boolean bgetConnection = CurDBMetaData.DBConnection != null;

  if (bpreselectCommand){

      ContentList = CurReportDocument.CurDBMetaData.getDBMetaData();

      iSelPos = (short) CurDBMetaData.getCommandTypeIndex();

      if (iSelPos > -1){

    bgetFields = true;

    iSelArray = new short[] {iSelPos};

      }

  }

  else{

      CurUNODialog.emptyFieldsListBoxes(xFieldsListBox, xSelFieldsListBox);

      ContentList = UNODialogs.combineListboxList(slstTablesDefaultText, CurReportDocument.CurDBMetaData.getDBMetaData());

      iSelArray = new short[]{(short) iSelPos};

  }

  CurUNODialog.assignPropertyToDialogControl("lstTables", "StringItemList", ContentList);

  CurUNODialog.assignPropertyToDialogControl("lstTables", "Enabled", new Boolean(bgetConnection));

  CurUNODialog.assignPropertyToDialogControl("lblTables", "Enabled", new Boolean(bgetConnection));

  CurUNODialog.assignPropertyToDialogControl("lstTables", "SelectedItems", iSelArray);

  if (bgetFields)

      fillUpFieldsListbox(CurDBMetaData, true);

  return iSelPos;

    }

   

   

    public int addFieldNamestoListBox(UNODialogs CurUNODialog){

  int FieldCount = 0;

  try{

      String[] LocList = (String[]) CurUNODialog.getPropertyOfDialogControl("lstTables", "StringItemList");

      if (LocList.length > 0){

    CurReportDocument.CurDBMetaData.getSpecificFieldNames(WidthList);

    FieldCount = CurReportDocument.CurDBMetaData.AllFieldNames.length;

    if (FieldCount > 0){

        bEnableBinaryOptionGroup = false;

        xFieldsListBox.removeItems((short) 0, xFieldsListBox.getItemCount());

        xFieldsListBox.addItems(CurReportDocument.CurDBMetaData.AllFieldNames, (short) 0);

        CurUNODialog.initializeListboxProcedures(xFieldsListBox, xSelFieldsListBox, OriginalList);

    }

      }

  }

  catch(Exception exception){

      exception.printStackTrace(System.out);

      FieldCount = 0;

  }

  return FieldCount;

    }

   

   

    private void fillUpFieldsListbox(DBMetaData CurDBMetaData, boolean bgetCommandType){

  try{

      //As the peer of the control might not yet exist we have to query the model for the SelectedItems

      short[] SelItems = (short[]) CurUNODialog.getPropertyOfDialogControl("lstTables", "SelectedItems");

      String[] sLocList = (String[]) CurUNODialog.getPropertyOfDialogControl("lstTables", "StringItemList");

      if (SelItems.length > 0) {

    int CurCommandType;

    int SelIndex = SelItems[0];

    if (SelIndex > -1){

        SelIndex = SelIndex ;

        if (xTableListBox.getItem((short) SelIndex).equals(slstTablesDefaultText)== false){

      if ((xTableListBox.getItem((short) 0).equals(slstTablesDefaultText) == true) && (SelIndex > 0))

          SelIndex = SelIndex -1;

      if (bgetCommandType == true){

          CurCommandType = CurDBMetaData.CommandTypes[SelIndex];

          if (CurCommandType == com.sun.star.sdb.CommandType.QUERY){

        int QueryIndex = SelIndex - TableNames.length;

        CurDBMetaData.MainCommandName = QueryNames[QueryIndex];

        oDBTable = CurDBMetaData.xQueryNames.getByName(CurDBMetaData.MainCommandName);

        CurDBMetaData.Command = AnyConverter.toString(Tools.getUNOPropertyValue(oDBTable, "Command"));

          }

          else{

        CurDBMetaData.MainCommandName = TableNames[SelIndex];

        oDBTable = CurDBMetaData.xTableNames.getByName(CurDBMetaData.MainCommandName);

          }

          CurDBMetaData.CommandType = CurCommandType;

          CurDBMetaData.OldMainCommandName = CurDBMetaData.MainCommandName;

          Tools.setUNOPropertyValue(CurReportDocument.xDocInfo, "Title", CurDBMetaData.MainCommandName);

          CurUNODialog.assignPropertyToDialogControl("txtTitle", "Text", CurReportDocument.CurDBMetaData.MainCommandName);

      }

      XColumnsSupplier xTableCols = (XColumnsSupplier) UnoRuntime.queryInterface(XColumnsSupplier.class, oDBTable);

      CurDBMetaData.xColumns = (XNameAccess) UnoRuntime.queryInterface(XNameAccess.class, xTableCols.getColumns());

      if (addFieldNamestoListBox(CurUNODialog) > 0){

          CurUNODialog.toggleListboxControls(xFieldsListBox, xSelFieldsListBox, new Boolean(true));

          return;

      }

        }

    }

      }

      CurUNODialog.emptyFieldsListBoxes(xFieldsListBox, xSelFieldsListBox);

  }

  catch(Exception exception){

      exception.printStackTrace(System.out);

  }}

   

   

    class TextListenerImpl implements com.sun.star.awt.XTextListener{

  public void textChanged(com.sun.star.awt.TextEvent EventObject){

      int iPos;

      try{

    int iKey  =  CurUNODialog.getControlKey(EventObject.Source, CurUNODialog.ControlList);

    switch (iKey) {

        case SOTXTFIRSTSAVEPATH:

      SavePath[0] = xSaveTextBox[0].getText();

      CurUNODialog.assignPropertyToDialogControl("cmdGoOn", "Enabled", new Boolean(SavePath[0].length() > 0));

      baskbeforeOverwrite[0] = (bmodifiedbySaveAsDialog[0] == false);

      bmodifiedbySaveAsDialog[0] = false;

      break;

     

        case SOTXTSECSAVEPATH:

      SavePath[1] = xSaveTextBox[1].getText();

      CurUNODialog.assignPropertyToDialogControl("cmdGoOn", "Enabled", new Boolean(SavePath[1].length() > 0));

      baskbeforeOverwrite[1] = (bmodifiedbySaveAsDialog[1] == false);

      bmodifiedbySaveAsDialog[1] = false;

      break;

        case SOTXTTITLE:

      String TitleName = xTitleTextBox.getText();

      CurReportDocument.updateReportTitle(xTitleTextBox);

      break;

        default:

      break;

    }

      }

      catch(Exception exception){

    exception.printStackTrace(System.out);

      }}

 

  public void disposing(com.sun.star.lang.EventObject EventObject) {

  }

    }

   

   

    class MouseListenerImpl implements com.sun.star.awt.XMouseListener{

 

  public void disposing(com.sun.star.lang.EventObject eventObject) {

  }

 

  public void mouseEntered(com.sun.star.awt.MouseEvent mouseEvent) {

  }

 

  public void mouseExited(com.sun.star.awt.MouseEvent mouseEvent) {

  }

 

 

  public void mousePressed(com.sun.star.awt.MouseEvent mouseEvent) {

      int iKey  =  CurUNODialog.getControlKey(mouseEvent.Source, CurUNODialog.ControlList);

      switch (iKey) {

    case SODBLST:

      CurUNODialog.deletefirstListboxEntry("lstDatabases", slstDatabasesDefaultText); //, bDataSourceIsSelected);

        break;

    case SOTBLLST:

        CurUNODialog.deletefirstListboxEntry("lstTables", slstTablesDefaultText);//, bCommandIsSelected);

        break;

    default:

        break;

      }

  }

 

  public void mouseReleased(com.sun.star.awt.MouseEvent mouseEvent) {

  }

    }

   

   

    class ItemListenerImpl implements com.sun.star.awt.XItemListener{

 

  public void itemStateChanged(ItemEvent EventObject){

      int iPos;

      Tools.setUNOPropertyValue(CurUNODialog.xDialogModel, "Enabled", new Boolean(false));

      CurReportDocument.xTextDocument.lockControllers();

     

      int iKey  =  CurUNODialog.getControlKey(EventObject.Source, CurUNODialog.ControlList);

      switch (iKey) {

    case SODBLST:

      CurUNODialog.deletefirstListboxEntry("lstDatabases", slstDatabasesDefaultText); //, bDataSourceIsSelected);

      getSelectedDBMetaData(xMSF);

        break;

       

    case SOTBLLST:

      CurUNODialog.deletefirstListboxEntry("lstTables", slstTablesDefaultText); //, bCommandIsSelected);

        fillUpFieldsListbox(CurReportDocument.CurDBMetaData, true);

        break;

   

    case SOFLDSLST:

        CurUNODialog.FormSetMoveRights(xFieldsListBox, xSelFieldsListBox, (short)-1, (short)-1);

        break;

       

    case SOSELFLDSLST:

        CurUNODialog.FormSetMoveRights(xFieldsListBox, xSelFieldsListBox, (short)-1, (short)-1);

        break;

               

    case SOGROUPLST:

        boolean bDoEnable = ((xGroupListBox.getSelectedItems().length > 0) && (GroupFieldVector.size() < 4));

        CurUNODialog.assignPropertyToDialogControl("cmdGroupOut", "Enabled", new Boolean(bDoEnable));

        break;

       

    case SOSELGROUPLST:

        toggleRemoveGroupButton();

        break;

       

    case SOFIRSTSORTLST:

        enableNextSortListBox(0);

        break;

       

    case SOSECSORTLST:

        enableNextSortListBox(1);

        break;

       

    case SOTHIRDSORTLST:

        enableNextSortListBox(2);

        break;

       

    case SOFOURTHSORTLST:

        enableNextSortListBox(3);

        break;

       

    case SOCONTENTLST:

        iPos = xContentListBox.getSelectedItemPos();

        if (iPos != iOldContentPos){

      iOldContentPos = iPos;

      CurReportDocument.swapContentTemplate(CurReportPaths.ContentFiles[1][iPos]);

        }

        break;

       

    case SOLAYOUTLST:

        iPos = xLayoutListBox.getSelectedItemPos();

        if (iPos != iOldLayoutPos){

      iOldLayoutPos = iPos;

      CurReportDocument.swapLayoutTemplate(CurReportPaths.LayoutFiles[1][iPos], CurReportPaths.BitmapPath, CurUNODialog);

        }

        break;

       

    default:

        break;

      }

      CurReportDocument.unlockallControllers();

      Tools.setUNOPropertyValue(CurUNODialog.xDialogModel, "Enabled", new Boolean(true));

  }

 

  public void disposing(EventObject eventObject) {

  }

    }

   

   

    class AdjustmentListenerImpl implements com.sun.star.awt.XAdjustmentListener{

 

  public void disposing(EventObject eventObject) {

  }

 

  public void adjustmentValueChanged(AdjustmentEvent AdjustEvent){

      try{

    scrollControls();

      }

      catch( Exception exception ){

    exception.printStackTrace(System.out);

      }

  }

    }

   

    class ActionListenerImpl implements com.sun.star.awt.XActionListener{

 

  public void disposing(EventObject eventObject){

  }

  public void actionPerformed(ActionEvent actionEvent){

      boolean bGoOn = true;

      try{

    int iKey  =  CurUNODialog.getControlKey(actionEvent.Source, CurUNODialog.ControlList);

    Tools.setUNOPropertyValue(CurUNODialog.xDialogModel, "Enabled", new Boolean(false));

    CurReportDocument.xTextDocument.lockControllers();

    switch (iKey){

        case SOFLDSLST:

      CurUNODialog.MoveSelectedListBox(xFieldsListBox, xSelFieldsListBox);

      break;

     

        case SOSELFLDSLST:

      CurUNODialog.MoveOrderedSelectedListBox(xFieldsListBox, xSelFieldsListBox, CurReportDocument.CurDBMetaData.AllFieldNames, false);

      break;

     

        case SOCMDMOVESEL:

      CurUNODialog.MoveSelectedListBox(xFieldsListBox, xSelFieldsListBox);

      break;

     

        case SOCMDMOVEALL:

      CurUNODialog.FormMoveAll(xFieldsListBox, xSelFieldsListBox, CurReportDocument.CurDBMetaData.AllFieldNames);

      break;

     

        case SOCMDREMOVESEL:

      CurUNODialog.MoveOrderedSelectedListBox(xFieldsListBox, xSelFieldsListBox, CurReportDocument.CurDBMetaData.AllFieldNames, false);

      break;

     

        case SOCMDREMOVEALL:

      CurUNODialog.MoveOrderedSelectedListBox(xFieldsListBox, xSelFieldsListBox, CurReportDocument.CurDBMetaData.AllFieldNames, true);

      break;

     

        case SOCMDGOON:

      gotoNextStep();

      break;

     

        case SOCMDBACK:

      gotoPrevStep();

      break;

     

        case SOGROUPLST:

      CurReportDocument.addGroupNametoDocument(xGroupListBox, xSelGroupListBox, GroupFieldVector, CurReportPaths.ReportPath);

      break;

     

        case SOSELGROUPLST:

      CurReportDocument.removeGroupName(xGroupListBox, xSelGroupListBox, GroupFieldVector);

      break;

     

        case SOCMDGROUPOUT:

      bGoOn = CurReportDocument.addGroupNametoDocument(xGroupListBox, xSelGroupListBox, GroupFieldVector, CurReportPaths.ReportPath);

      break;

     

        case SOCMDGROUPIN:

      CurReportDocument.removeGroupName(xGroupListBox, xSelGroupListBox, GroupFieldVector);

      break;

     

        case SOOPTLANDSCAPE:

      CurReportDocument.changePageOrientation(CurReportPaths.BitmapPath, CurUNODialog, true);

      break;

     

        case SOOPTPORTRAIT:

      CurReportDocument.changePageOrientation(CurReportPaths.BitmapPath, CurUNODialog, false);

      break;

     

        case SOOPTSAVEASTEMPLATE:

      toggleSaveControls();

      break;

     

        case SOOPTSAVEASDOCUMENT:

      toggleSaveControls();

      break;

     

        case SOCMDFIRSTPATHSELECT:

      insertStorePathToTextBox();

      break;

     

        case SOCMDSECPATHSELECT:

      insertStorePathToTextBox();

      break;

     

        case SOTITLESCROLLBAR:

      scrollControls();

      break;

     

        default:

      //               System.err.println( exception);

      break;

    }

    if (bGoOn == false){

        CurUNODialog.xDialog.endExecute();

    }

      }

      catch( Exception exception ){

    exception.printStackTrace(System.out);

      }

      CurReportDocument.unlockallControllers();

      Tools.setUNOPropertyValue(CurUNODialog.xDialogModel, "Enabled", new Boolean(true));

  }

    }

   

   

    public void gotoNextStep(){

  try{

      boolean bgoon = true;

      PageAddCount = 1;

      int PageCount = 6;

      int iPage = AnyConverter.toInt(Tools.getUNOPropertyValue(CurUNODialog.xDialogModel, "Step"));

      switch (iPage){

    case SOMAINPAGE:

        updateSecondStep(CurReportDocument.CurDBMetaData, iPage+1);

        break;

    case SOTITLEPAGE:

        scrollTextFieldInfo(ScrollBarValue);

        updateThirdStep(CurReportDocument.CurDBMetaData);

        break;

    case SOGROUPPAGE:

        if (updateFourthStep(CurReportDocument.CurDBMetaData))

      break;

    case SOSORTPAGE:

        bgoon = setupSortcriteria();

        if (bgoon){

      CurReportDocument.CurDBMetaData.RecordFieldNames = CurReportDocument.CurDBMetaData.setRecordFieldNames();

      CurReportDocument.CurDBMetaData.combineSelectStatement(CurReportDocument.CurDBMetaData.MainCommandName);

      //TODO: A message box should pop up when a single sorting criteria has been selected more than once

      CurReportDocument.xTextDocument.lockControllers();

      CurReportDocument.setupRecordSection(CurReportPaths.ReportPath + "/cnt-default.stw");

      updateFifthStep();

        }

        break;

       

    case SOTEMPLATEPAGE:

        CurUNODialog.assignPropertyToDialogControl("cmdGoOn", "Label", scmdReady);

        CurUNODialog.setFocus("optCreateReportTemplate");

        assignDocumentPathstoTextControl(xMSF);

        break;

    case SOSTOREPAGE:

        bcreateTemplate = ((Short)  CurUNODialog.getPropertyOfDialogControl("optCreateReportTemplate", "State")).shortValue() == (short) 1;

        boolean bDocisStored;

        StorePath = getStorePath();

        if (Tools.PathisValid(xMSF, StorePath, sMsgFilePathInvalid, bfinalaskbeforeOverwrite)){

      if (bcreateTemplate == true){

          CurReportDocument.createReportForm(SOREPORTFORMNAME);

          Tools.attachEventCall(CurReportDocument.xTextDocument, "OnNew", "Script", "service:com.sun.star.wizards.report.CallReportWizard?fill");

          buseTemplate = ((Short) CurUNODialog.getPropertyOfDialogControl("optUseTemplate", "State")).shortValue() == (short) 1;

          CurReportDocument.breakLinkofTextSections();

          bDocisStored = Tools.storeDocument(xMSF, CurReportDocument.xComponent , StorePath, "writer_StarOffice_XML_Writer_Template",

          buseTemplate, sMsgSavingImpossible + (char)13 + sMsgLinkCreationImpossible);

          if (bDocisStored == true)

        CurReportDocument.CurDBMetaData.createDBLink(CurReportDocument.CurDBMetaData.DataSource, StorePath);

      }

      else{

          bcreateLink = ((Short) CurUNODialog.getPropertyOfDialogControl("chkcreateLink", "State")).shortValue() == (short) 1;

      }

      bgoon = false;

      bCloseDocument = false;

      CurUNODialog.xDialog.endExecute();

        }

        else{

      if (bcreateTemplate)

          CurUNODialog.setFocus("txtSavePath_1");

      else

          CurUNODialog.setFocus("txtSavePath_2");

        }

        break;

    default:

        break;

      }

      CurReportDocument.unlockallControllers();

      if (bgoon == true){

    if (iPage < PageCount){

        Tools.setUNOPropertyValues(CurUNODialog.xDialogModel, new String[]{"Step", "Title"}, new Object[]{ new Integer(iPage + PageAddCount), WizardTitle[iPage]});

        CurUNODialog.assignPropertyToDialogControl("lblDialogHeader", "Label", WizardHeaderText[iPage]);

    }

      }

  }

  catch( Exception exception ){

      exception.printStackTrace(System.out);

  }}

   

   

    public void gotoPrevStep(){

  try{

      int iPage = AnyConverter.toInt(Tools.getUNOPropertyValue(CurUNODialog.xDialogModel, "Step"));

      switch (iPage){

    case SOTITLEPAGE:

            scrollTextFieldInfo(ScrollBarValue);

        CurReportDocument.CurDBMetaData.OldFieldTitles = Tools.copyStringArray(CurReportDocument.CurDBMetaData.FieldTitles);

        break;

       

    case SOGROUPPAGE:

        getGroupFieldNames(CurReportDocument.CurDBMetaData);

        break;

       

    case SOSORTPAGE:

        break;

       

    case SOTEMPLATEPAGE:

        CurReportDocument.removeTextSectionbyName("RecordSection");

        CurReportDocument.removeTextTablebyName("Tbl_RecordSection");

        break;

       

    case SOSTOREPAGE:

        CurUNODialog.assignPropertyToDialogControl("cmdGoOn", "Label", scmdGoOn);

        CurUNODialog.assignPropertyToDialogControl("cmdGoOn", "Enabled", new Boolean(true));

        break;

       

    default:

        break;

      }

      CurUNODialog.assignPropertyToDialogControl("cmdBack", "Enabled", new Boolean(iPage > 2));

      if (iPage > 1)

    Tools.setUNOPropertyValues(CurUNODialog.xDialogModel, new String[]{"Step", "Title"}, new Object[]{ new Integer(iPage - 1), WizardTitle[iPage-2]});

    CurUNODialog.assignPropertyToDialogControl("lblDialogHeader", "Label", WizardHeaderText[iPage-2]);

  }

  catch( Exception exception ){

      exception.printStackTrace(System.out);

  }}

   

   

    public void toggleRemoveGroupButton(){

  try{

      boolean bDoEnable = xSelGroupListBox.getSelectedItems().length > 0;

      CurUNODialog.assignPropertyToDialogControl("cmdGroupIn", "Enabled", new Boolean(true));

  }

  catch( Exception exception ){

      exception.printStackTrace(System.out);

  }}

   

   

  String CurFieldName;

  String CurFieldTitle;

  short iCurState;     

  int a = 0;

  CurReportDocument.CurDBMetaData.SortFieldNames = new String[MaxSortIndex+1][2];

  for (int i = 0; i <= MaxSortIndex; i++){

      if (xSortListBox[i].getSelectedItemPos() > 0){

    CurFieldTitle = xSortListBox[i].getSelectedItem();

    CurFieldName = CurReportDocument.CurDBMetaData.getFieldName(CurFieldTitle);

    iCurState = ((Short) CurUNODialog.getPropertyOfDialogControl("optAscend" + new Integer(i+1).toString(), "State")).shortValue();

    CurReportDocument.CurDBMetaData.SortFieldNames[a][0] = CurFieldName;         

    if (iCurState == 1)

        CurReportDocument.CurDBMetaData.SortFieldNames[a][1] = "ASC";

    else

        CurReportDocument.CurDBMetaData.SortFieldNames[a][1] = "DESC";

    a +=1;

      }

  }

    }*/

   

   

    public int getMaxSortIndex(){

        int LocMaxSortIndex = -1;

        for (int i = 0; i < 4; i++){

      if (xSortListBox[i].getSelectedItemPos() > 0)

          LocMaxSortIndex += 1;

      else

          break;

  }

  return LocMaxSortIndex;

    }

   

   

    public void enableNextSortListBox(int CurIndex){

    try{

  MaxSortIndex = getMaxSortIndex();

  boolean bDoEnable = (xSortListBox[CurIndex].getSelectedItemPos() != 0);

  if (!bDoEnable)

      disableListBoxesfromIndex(CurIndex);

  else

      toggleSortListBox(CurIndex + 1, true);

    }

    catch(Exception exception){

  exception.printStackTrace(System.out);

    }}   

       

   

    public boolean setupSortcriteria(){

    try{

  short iCurState;

  String CurFieldName;

  String CurFieldTitle;

  MaxSortIndex = getMaxSortIndex();

  CurReportDocument.CurDBMetaData.SortFieldNames = new String[MaxSortIndex+1][2];

  for (int i = 0; i <= MaxSortIndex; i++){

      CurFieldTitle = xSortListBox[i].getSelectedItem();

      CurFieldName = CurReportDocument.CurDBMetaData.getFieldName(CurFieldTitle);

      if (Tools.FieldInTable(CurReportDocument.CurDBMetaData.SortFieldNames, CurFieldName) == -1){

    CurReportDocument.CurDBMetaData.SortFieldNames[i][0] = CurFieldName;   

    iCurState = ((Short) CurUNODialog.getPropertyOfDialogControl("optAscend" + new Integer(i+1).toString(), "State")).shortValue();

    CurReportDocument.CurDBMetaData.SortFieldNames[i][0] = CurFieldName;         

    if (iCurState == 1)

        CurReportDocument.CurDBMetaData.SortFieldNames[i][1] = "ASC";

    else

        CurReportDocument.CurDBMetaData.SortFieldNames[i][1] = "DESC";     

      }

      else{

    String sLocSortCriteriaisduplicate = Tools.replaceSubString(sSortCriteriaisduplicate, CurFieldTitle, "<FIELDNAME>");         

    UNODialogs.showMessageBox(xMSF, "WarningBox", com.sun.star.awt.VclWindowPeerAttribute.OK, sLocSortCriteriaisduplicate);

    xSortListBox[i].selectItemPos((short) 0, true);

    return false;       

      }

  }

  return true;

    }

    catch(Exception exception){

  exception.printStackTrace(System.out);

  return false;

    }}

   

   

    public void disableListBoxesfromIndex(int CurIndex){

  if (CurIndex < MAXSORTCRITERIA){

      for (int i = CurIndex + 1; i <= MAXSORTCRITERIA; i++){

    toggleSortListBox(i, (false));

    if (i < MaxSortIndex)

        xSortListBox[i+1].selectItemPos((short)0, true);

      }

      CurReportDocument.CurUNODialog.setFocus("lblSort" + new Integer(CurIndex+1));

      MaxSortIndex = CurIndex-1;

  }   

    }

   

    public void moveupSortItems(int CurIndex, boolean bDoEnable){

  short iNextItemPos;

  if ((bDoEnable == false) && (MaxSortIndex > CurIndex)){

      for (int i= CurIndex; i < MaxSortIndex; i++){

    iNextItemPos = xSortListBox[i+1].getSelectedItemPos();

    if (iNextItemPos != 0){

        xSortListBox[i].selectItemPos(iNextItemPos,true);

        xSortListBox[i+1].selectItemPos(iNextItemPos,false);

        toggleSortListBox(i,true);

        xSortListBox[i+1].selectItemPos((short)0,true);

    }

      }

            MaxSortIndex = MaxSortIndex - 1;

            if (MaxSortIndex < xSortListBox.length -2)

                toggleSortListBox(MaxSortIndex + 2, false);

  }

  else

      toggleSortListBox(CurIndex+1, bDoEnable);

    }

   

   

   

    public void toggleSortListBox(int CurIndex, boolean bDoEnable){

  try{

      if (CurIndex < xSortListBox.length){

    CurUNODialog.assignPropertyToDialogControl("lblSort" + new Integer(CurIndex+1).toString(), "Enabled", new Boolean(bDoEnable));

    CurUNODialog.assignPropertyToDialogControl("lstSort" + new Integer(CurIndex+1).toString(), "Enabled", new Boolean(bDoEnable));

    CurUNODialog.assignPropertyToDialogControl("optAscend" + new Integer(CurIndex+1).toString(), "Enabled", new Boolean(bDoEnable));