INTEGRATION: CWS qwizards1 (1.1.2); FILE ADDED

2004/04/06 10:28:52 bc 1.1.2.2: #111603# modifycellcontent routine embedded
2004/03/12 08:03:12 bc 1.1.2.1: #111603# subclass of Reportdocument now standalone

1 files changed, 356 insertions, 0 deletions

diff --git a/wizards/com/sun/star/wizards/report/DBColumn.java b/wizards/com/sun/star/wizards/report/DBColumn.java
new file mode 100644
index 000000000000..e4a1ea971651
--- /dev/null
+++ b/wizards/com/sun/star/wizards/report/DBColumn.java
@@ -0,0 +1,356 @@
+/*************************************************************************
+ *
+ *  RCSfile: DBColumn.java,v
+ *
+ *  Revision: 1.0
+ *
+ *  last change: Author: bc  Date: 08.03.2004 12:40:00
+ *
+ *  The Contents of this file are made available subject to the terms of
+ *  the BSD license.
+ *
+ *  Copyright (c) 2003 by Sun Microsystems, Inc.
+ *  All rights reserved.
+ *
+ *  Redistribution and use in source and binary forms, with or without
+ *  modification, are permitted provided that the following conditions
+ *  are met:
+ *  1. Redistributions of source code must retain the above copyright
+ *     notice, this list of conditions and the following disclaimer.
+ *  2. Redistributions in binary form must reproduce the above copyright
+ *     notice, this list of conditions and the following disclaimer in the
+ *     documentation and/or other materials provided with the distribution.
+ *  3. Neither the name of Sun Microsystems, Inc. nor the names of its
+ *     contributors may be used to endorse or promote products derived
+ *     from this software without specific prior written permission.
+ *
+ *  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
+ *  "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
+ *  LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
+ *  FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
+ *  COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
+ *  INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
+ *  BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS
+ *  OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
+ *  ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR
+ *  TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE
+ *  USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+ *
+ *************************************************************************/
+package com.sun.star.wizards.report;
+
+import com.sun.star.beans.PropertyState;
+import com.sun.star.beans.XPropertySet;
+import com.sun.star.beans.XPropertyState;
+import com.sun.star.container.XNameAccess;
+import com.sun.star.container.XNamed;
+import com.sun.star.style.ParagraphAdjust;
+import com.sun.star.table.XCell;
+import com.sun.star.table.XCellRange;
+import com.sun.star.table.XTableColumns;
+import com.sun.star.table.XTableRows;
+import com.sun.star.text.XDependentTextField;
+import com.sun.star.text.XTextCursor;
+import com.sun.star.text.XTextRange;
+import com.sun.star.text.XTextTable;
+import com.sun.star.uno.AnyConverter;
+import com.sun.star.uno.Exception;
+import com.sun.star.uno.UnoRuntime;
+import com.sun.star.util.XNumberFormats;
+import com.sun.star.wizards.db.*;
+import com.sun.star.wizards.common.*;
+import com.sun.star.wizards.text.TextDocument;
+import com.sun.star.wizards.text.TextTableHandler;
+import com.sun.star.wizards.text.TextFieldHandler;
+
+
+public class DBColumn {
+
+    public XCell xValCell;
+    public XTextRange xValTextCell;
+    public XTextCursor xValCellCursor;
+    public XNumberFormats xValCellNumberFormats;
+    public XCell xNameCell;
+    public XTextRange xNameTextCell;
+    public boolean bAlignLeft;
+    public Object DefaultValue;
+    public String CharFontName;
+    public int FormatKey;
+    public PropertyState PropertyState;
+    public int ValColumn = 1;
+    public int ValRow = 0;
+    public FieldColumn CurDBField;
+    private XTextTable xTextTable;
+    private XTableColumns xTableColumns;
+    private XCellRange xCellRange;
+    public XNamed xTableName;
+    private boolean bIsGroupColumn;
+    TextDocument oTextDocument;
+    RecordParser CurDBMetaData;
+    RecordTable CurRecordTable;
+    TextTableHandler  oTextTableHandler;
+
+    public DBColumn(TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, int i) throws Exception{
+        CurRecordTable = new RecordTable(_oTextTableHandler);
+        initializeRecordTableMembers(CurRecordTable, _oTextTableHandler, _CurDBMetaData, i);
+    }
+
+
+    public DBColumn(RecordTable _CurRecordTable, TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, int i) throws Exception{
+        initializeRecordTableMembers(_CurRecordTable, _oTextTableHandler, _CurDBMetaData, i);
+    }
+
+
+    private void initializeRecordTableMembers(RecordTable _CurRecordTable, TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, int i) throws Exception{
+        this.oTextTableHandler = _oTextTableHandler;
+        this.CurDBMetaData = _CurDBMetaData;
+        this.CurRecordTable = _CurRecordTable;
+        bIsGroupColumn = false;
+        if (CurDBMetaData.RecordFieldColumns != null)
+            setDBField(CurDBMetaData.RecordFieldColumns[i].DisplayFieldName);
+        else
+            setDBField(CurDBMetaData.RecordFieldNames[i]);
+        xNameCell = CurRecordTable.xCellRange.getCellByPosition(i,0);
+        String CellName = (String) Helper.getUnoPropertyValue(xNameCell, "CellName");
+        xNameTextCell = (XTextRange) UnoRuntime.queryInterface(XTextRange.class, xNameCell);
+        xValCell = CurRecordTable.xCellRange.getCellByPosition(i,1);
+        Desktop.setNumberFormat(xValCell, oTextTableHandler.NumberFormats, CurDBField.DBFormatKey);
+        xValTextCell = (XTextRange) UnoRuntime.queryInterface(XTextRange.class, xValCell);
+        xValCellCursor = TextDocument.createTextCursor(xValCell);
+    }
+
+
+    public DBColumn(TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, String _FieldName, int GroupIndex, String TableName, DBColumn OldDBColumn) throws Exception{
+        this.oTextTableHandler = _oTextTableHandler;
+        this.CurDBMetaData = _CurDBMetaData;
+        setDBField( _FieldName);
+        bIsGroupColumn = true;
+        String CurFieldString = "G" + String.valueOf(GroupIndex+1) + "xxx";
+        getTableColumns(TableName);
+        xNameCell = OldDBColumn.xNameCell;
+        xNameTextCell = OldDBColumn.xNameTextCell;
+        xValCell = OldDBColumn.xValCell;
+        xValTextCell = OldDBColumn.xValTextCell;
+        xValCellCursor = TextDocument.createTextCursor(xValCell);
+        ValColumn = OldDBColumn.ValColumn;
+        ValRow = OldDBColumn.ValRow;
+    }
+
+
+    public DBColumn(TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, String _FieldName, int GroupIndex, String TableName) throws Exception{
+        this.oTextTableHandler = _oTextTableHandler;
+        this.CurDBMetaData = _CurDBMetaData;
+        setDBField(_FieldName);
+        bIsGroupColumn = true;
+        XTextRange xTextCell;
+        XCell xCell;
+        String CellString;
+        String CurFieldString = "G" + String.valueOf(GroupIndex + 1) + "xxx";
+        getTableColumns(TableName);
+        XTableRows xRows = xTextTable.getRows();
+        for (int n = 0; n < xTableColumns.getCount(); n++){
+            for (int m = 0; m < xRows.getCount(); m++){
+                xCell = xCellRange.getCellByPosition(n,m);
+                xTextCell = (XTextRange) UnoRuntime.queryInterface(XTextRange.class, xCell);
+                CellString = xTextCell.getString();
+                String CompString = TableName.substring(4);
+                XTextCursor xLocCellCursor = TextDocument.createTextCursor(xCell);
+                if (isNameCell(xLocCellCursor, CurDBField.AliasName, CompString)){
+                    xNameCell = xCell;
+                    xNameTextCell = xTextCell;
+                }
+                else if (CellString.equals(CurFieldString)){
+                    xValCell = xCell;
+                    xValTextCell = xTextCell;
+                    xValCellCursor = xLocCellCursor;
+                    ValColumn = n;
+                    ValRow = m;
+                }
+            }
+        }
+    }
+
+
+
+    public void setDBField(String _FieldName){
+        CurDBField = CurDBMetaData.getFieldColumnByDisplayName(_FieldName);
+        CurDBField.DisplayFieldName = _FieldName;
+        CurDBField.FieldName = FieldColumn.getFieldName(CurDBField.DisplayFieldName);
+        CurDBField.AliasName = CurDBMetaData.getFieldTitle(_FieldName);
+    }
+
+
+    private void  getTableColumns(String TableName){
+    try {
+        XNameAccess xAllTextTables = oTextTableHandler.xTextTablesSupplier.getTextTables();
+        if (xAllTextTables.hasByName(TableName) == true){
+            Object oTextTable = xAllTextTables.getByName(TableName);
+            xCellRange = (XCellRange) UnoRuntime.queryInterface(XCellRange.class, oTextTable);
+            xTextTable = (XTextTable) UnoRuntime.queryInterface(XTextTable.class, oTextTable);
+            xTableName = (XNamed) UnoRuntime.queryInterface(XNamed.class, oTextTable);
+            xTableColumns = xTextTable.getColumns();
+        }
+
+    } catch (Exception e) {
+        e.printStackTrace();
+    }}
+
+
+    public void initializeNumberFormat(){
+        Desktop.setNumberFormat(xValCell, oTextTableHandler.NumberFormats, CurDBField.DBFormatKey);
+        setCellFont();
+    }
+
+
+    public void insertColumnData(TextFieldHandler oTextFieldHandler, boolean _bIsLandscape){
+        insertUserFieldToTableCell(oTextFieldHandler);
+        replaceValueCellofTable(_bIsLandscape);
+    }
+
+
+    public void insertUserFieldToTableCell(TextFieldHandler oTextFieldHandler){
+        XTextCursor xTextCursor = TextDocument.createTextCursor(xNameCell);
+        xTextCursor.gotoStart(false);
+        xTextCursor.gotoEnd(true);
+        xTextCursor.setString("");
+        oTextFieldHandler.insertUserField(xTextCursor, CurDBField.DisplayFieldName, CurDBField.AliasName);
+    }
+
+
+    public void formatValueCell(){
+        Desktop.setNumberFormat(xValCell, oTextTableHandler.NumberFormats, CurDBField.DBFormatKey);
+        if ((CurDBField.bIsNumberFormat) && (ValColumn == xTableColumns.getCount()-1)){
+            bAlignLeft = true;
+            setCellFont();
+        }
+    }
+
+
+    public void modifyCellContent(XCellRange xCellRange, Object CurGroupValue){
+    try{
+        xValCell = xCellRange.getCellByPosition(ValColumn, ValRow);
+        xValTextCell = (XTextRange) UnoRuntime.queryInterface(XTextRange.class, xValCell);
+        modifyCellContent(CurGroupValue);
+        if (bAlignLeft){
+            xValCellCursor = TextDocument.createTextCursor(xValCell);
+            Helper.setUnoPropertyValue(xValCellCursor, "ParaAdjust", new Integer(com.sun.star.style.ParagraphAdjust.LEFT_value));
+        }
+    }
+    catch( Exception exception ){
+        exception.printStackTrace(System.out);
+    }}
+
+
+    public void modifyCellContent(Object CurGroupValue){
+    double dblValue = 0;
+    String sString;
+    try{
+        if (xValCell != null){
+            if (AnyConverter.isString(CurGroupValue)){
+                String sValue = (String) AnyConverter.toString(CurGroupValue);
+                xValTextCell.setString(sValue);
+            }
+            else{
+                boolean bbla = AnyConverter.isVoid(CurGroupValue);
+                if (AnyConverter.isBoolean(CurGroupValue))
+                    dblValue = (double) AnyConverter.toInt(CurGroupValue);
+                if (AnyConverter.isByte(CurGroupValue))
+                    dblValue = (double) AnyConverter.toByte(CurGroupValue);
+                else if (AnyConverter.isDouble(CurGroupValue))
+                    dblValue = AnyConverter.toDouble(CurGroupValue);
+                else if (AnyConverter.isFloat(CurGroupValue))
+                    dblValue = (double) AnyConverter.toFloat(CurGroupValue);
+                else if (AnyConverter.isInt(CurGroupValue))
+                    dblValue = (double) AnyConverter.toInt(CurGroupValue);
+                else if (AnyConverter.isLong(CurGroupValue))
+                    dblValue = (double) AnyConverter.toLong(CurGroupValue);
+                else if (AnyConverter.isShort(CurGroupValue))
+                    dblValue = (double) AnyConverter.toShort(CurGroupValue);
+                xValCell.setValue(dblValue);
+            }
+        }
+    }
+    catch( Exception exception ){
+        System.err.println( exception);
+    }}
+
+
+    // If the parameter CurGroupValue is null the placeholders are inserted
+    public void replaceValueCellofTable(boolean _bIsLandscape){
+    try{
+        Object CurGroupValue;
+        if (bIsGroupColumn == false && CurDBField.bIsNumberFormat == false)
+            CurGroupValue = BlindtextCreator.adjustBlindTextlength(CurDBField.FieldTitle, CurDBField.FieldWidth, _bIsLandscape, bIsGroupColumn, CurDBMetaData.RecordFieldNames);
+        else
+            CurGroupValue = CurDBField.getDefaultValue();
+        modifyCellContent(CurGroupValue);
+//      xValCellCursor.gotoStart(false);
+//      xValCellCursor.gotoEnd(true);
+
+        if (bAlignLeft)
+        Helper.setUnoPropertyValue(xValCellCursor, "ParaAdjust", new Integer(ParagraphAdjust.LEFT_value));
+
+        if (CurDBField.FieldType == com.sun.star.sdbc.DataType.BIT){
+            CharFontName = "StarSymbol";
+            Helper.setUnoPropertyValue(xValCellCursor, "CharFontName", CharFontName);
+            if (bIsGroupColumn == false)
+                Helper.setUnoPropertyValue(xValCellCursor, "ParaAdjust", new Integer(ParagraphAdjust.CENTER_value));
+        }
+        else{
+            if (PropertyState == com.sun.star.beans.PropertyState.DEFAULT_VALUE){
+                XPropertyState xPropState = (XPropertyState) UnoRuntime.queryInterface(XPropertyState.class, xValCellCursor);
+                xPropState.setPropertyToDefault("CharFontName");
+            }
+            else{
+                if (PropertyState == com.sun.star.beans.PropertyState.DIRECT_VALUE)
+                Helper.setUnoPropertyValue(xValCellCursor, "CharFontName", CharFontName);
+            }
+        }
+    }
+    catch(com.sun.star.beans.UnknownPropertyException exception){
+        exception.printStackTrace(System.out);
+    }}
+
+
+    public void setCellFont(){
+    try{
+        XPropertyState xPropertyState;
+            int FieldType = CurDBField.FieldType;
+        if (FieldType == com.sun.star.sdbc.DataType.BIT){
+            CharFontName = "StarSymbol";
+            PropertyState = com.sun.star.beans.PropertyState.DIRECT_VALUE;
+        }
+        else{
+            xPropertyState = (XPropertyState) UnoRuntime.queryInterface(XPropertyState.class, xValCellCursor);
+            PropertyState = xPropertyState.getPropertyState("CharFontName");
+            CharFontName = AnyConverter.toString(Helper.getUnoPropertyValue(xValCellCursor, "CharFontName"));
+        }
+    }
+    catch(Exception exception){
+        exception.printStackTrace(System.out);
+    }}
+
+    private boolean isNameCell(XTextCursor xCellCursor, String CurFieldName, String CompString){
+    try{
+        xCellCursor.gotoStart(false);
+        XTextRange xTextRange = xCellCursor.getEnd();
+        Object oTextField = Helper.getUnoPropertyValue(xTextRange, "TextField");
+        if (AnyConverter.isVoid(oTextField))
+            return false;
+        else{
+            XDependentTextField xDependent = (XDependentTextField) UnoRuntime.queryInterface(XDependentTextField.class, oTextField);
+            XPropertySet xMaster = xDependent.getTextFieldMaster();
+            String UserFieldName = (String) xMaster.getPropertyValue("Name");
+            boolean bIsNameCell = ((UserFieldName.equals(CompString)) || (UserFieldName.equals(CurFieldName)));
+            return bIsNameCell;
+        }
+    }
+    // Todo: Insert a  resource; Exception should be thrown to the calling routine
+    catch( Exception exception){
+// TODO
+// Resource wieder rein!!       sMsgInvalidTextField = oResource.getResText(UIConsts.RID_REPORT + 73);
+//      SystemDialog.showMessageBox(oTextTableHandler.xMSFDoc, "ErrorBox", VclWindowPeerAttribute.OK, sMsgInvalidTextField);
+        exception.printStackTrace(System.out);
+        return true;    //most probably this is really the Namecell!!!!
+    }}
+}