home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Kompuutteri Kaikille K-CD 2002 #3
/
K-CD_2002-03.iso
/
OpenOffice
/
f_0018
/
FormWizard.xba
< prev
next >
Wrap
Extensible Markup Language
|
2001-10-12
|
12KB
|
318 lines
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd">
<script:module xmlns:script="http://openoffice.org/2000/script" script:name="FormWizard" script:language="StarBasic">Option Explicit
' Todo: Gruppieren der DBControls mit den Textfeldern einbinden
' Evtl k├╢nnte dies auch am Ende geschehen
Public DocumentName as String
Public FormPath$, FormDBName$, FormReturnValue$
Public TemplatePath$
Public WizardPath as String
Public WebWizardPath as String
Public WorkPath as String
Public TexturePath as String
Public sQueryName as String
Public NumberofStyles as Integer
Public oDBConnection as Object
Public bWithBackGraphic as Boolean
Public bNeedFieldRefresh as Boolean
Public oDBForm as Object
Public oColumns() as Object
Public sDatabaseList()
Public TableNames() as String
Public QueryNames() as String
Public FieldNames() as String
Public ImgFieldNames() as String
Public oDBContext as Object
Public oUcb as Object
Public oDocInfo as Object
Public WidthList(15,3)
Public ImgWidthList(3,3)
Public sDBName as String
Public Tablename as String
Public Const SBSIZETEXT = "The quick brown fox jumps over the lazy dog.The quick brown fox jumps over the lazy dog."
Public bDisposeDoc as Boolean
' Todo: Mit FS abschnacken, dass als CommandType Nur Queries und Tables zugelassen sind. Dabei müsste noch abgklärt werden
' wann ein Content ein 'Command' ist.
' The macro can be called in 4 possible scenarios:
' Scenario 1. No parameters at given
' Scenario 2: Only Datasourcename is given, but no connection and no Content
' Scenario 3: a data source and a connection are given
' Scenario 4: all parameters (data source name, connection, object type and object) are given
Sub Main()
Dim oLocDBContext as Object
Dim oLocConnection as Object
' Scenario 1. No parameters at given
MainWithDefault()
' Scenario 2: Only Datasourcename is given, but no connection and no Content
' MainWithDefault("Bibliography")
' Scenario 3: a data source and a connection are given
' oLocDBContext = CreateUnoService("com.sun.star.sdb.DatabaseContext")
' oLocConnection = oLocDBContext.GetByName("Bibliography").GetConnection("","")
' MainWithDefault("Bibliography", oLocConnection)
' Scenario 4: all parameters (data source name, connection, object type and object) are given
' oLocDBContext = CreateUnoService("com.sun.star.sdb.DatabaseContext")
' oLocConnection = oLocDBContext.GetByName("Bibliography").GetConnection("","")
' MainWithDefault("Bibliography", oLocConnection, com.sun.star.sdb.CommandType.TABLE, "biblio")
End Sub
Sub MainWithDefault(Optional DatasourceName as String, Optional oConnection as Object, Optional CommandType as Integer, Optional sContent as String)
Dim i as Integer
Dim SelCount as Integer
'On Local Error Goto GlobalError
BasicLibraries.LoadLibrary("Tools")
BasicLibraries.LoadLibrary("WebWizard")
' Todo: Variable is initialized due to Bug#88329
CurArrangement = 0
bControlsareCreated = False
bDisposeDoc = True
MaxIndex = -1
If Not InitResources("Formwizard","dbw") Then
Exit Sub
End If
oDBContext = CreateUnoService("com.sun.star.sdb.DatabaseContext")
oUcb = createUnoService("com.sun.star.ucb.SimpleFileAccess")
FormPath = GetOfficeSubPath("Template","wizard/bitmap")
WebWizardPath = GetOfficeSubPath("Template","wizard/web")
WizardPath = GetOfficeSubPath("Template","wizard/")
TexturePath = GetOfficeSubPath("Gallery", "www-back/")
WorkPath = GetPathSettings("Work")
OpenFormDocument()
GetDatabaseNames()
InitializeWidthList()
LoadLanguage
bNeedFieldRefresh = True
With oDialogModel
' .optIgnoreBinaries.State = True
.cmdBack.Enabled = False
.cmdGoOn.Enabled = False
.lblTables.Enabled = False
.lstSelFields.Tag = False
.Step = 1
.lstDatabases.StringItemList()= sDatabaseList()' = AddItem(sDatabaseList(i)
End With
If Not IsMissing(DataSourceName) Then
sDBName = DataSourceName
DlgFormDB.GetControl("lstDatabases").SelectItem(DataSourceName, True)
If Not IsMissing(oConnection) Then
' Scenario 3: a data source and a connection are given
Set oDBConnection = oConnection
oDataSource = oDBContext.GetByName(DataSourceName)
oDialogModel.lstTables.Enabled = True
oDialogModel.lblTables.Enabled = True
If GetDBMetaData() Then
oDialogModel.lstTables.StringItemList() = AddListToList(TableNames(), QueryNames())
iCommandTypes = CreateCommandTypeList()
If Not IsMissing(sContent) Then
' Scenario 4: all parameters (data source name, connection, object type and object) are given
iCommandTypes() = CreateCommandTypeList()
SelCount = CountItemsInArray(oDialogModel.lstTables.StringItemList(), sContent)
If SelCount = 1 Then
DlgFormDB.GetControl("lstTables").SelectItem(sContent, True)
Else ' Note: Here is no Error Handling in case that no valid content is transferred
If CommandType = com.sun.star.sdb.CommandType.QUERY Then
SelIndex = IndexInArray(sContent, QueryNames()
DlgFormDB.GetControl("lstTables").SelectItemPos(SelIndex, True)
ElseIf CommandType = com.sun.star.sdb.CommandType.TABLE Then
SelIndex = IndexInArray(sContent, TableNames()
DlgFormDB.GetControl("lstTables").SelectItemPos(Ubound(QueryNames()+1 + SelIndex, True)
End If
End If
CurCommandType = CommandType
FillUpFieldsListbox(False)
End If
End If
Else
' Scenario 2: Only Datasourcename is given, but no connection and no Content
GetSelectedDBMetaData()
End If
Else
' Scenario 1: No parameters are given
ToggleListboxControls(oDialogModel, False)
End If
DlgFormDB.Title = WizardTitle(1)
NumberofStyles = FillupWebListbox(oUcb, "/stl", DlgFormDB, "lstStyles", Styles())
ImportStyles()
ToggleWindow(True)
oDialogModel.imgTheme.ImageURL = FormPath & "FormWizard_1.bmp"
oDialogModel.cmdBack.Enabled = False
oDialogModel.cmdGoOn.Enabled = False
DlgFormDB.Execute()
DlgFormDB.Dispose
If Not IsNull(oDBConnection) Then
oDBConnection.Dispose()
End If
' If bDisposeDoc Then
' oDocument.Dispose
' End If
Exit Sub
GlobalError:
MsgBox(sMsgErrMsg , 16, sMsgWizardName)
ToggleWindow(True)
DlgFormDB.EndExecute()
End Sub
Sub FormGetFields()
Dim i as Integer
ToggleDatabasePage(False)
FillUpFieldsListbox(True)
ToggleDatabasePage(True)
End Sub
Sub FillUpFieldsListbox(bGetCommandType as Boolean)
Dim n as Integer
Dim SelIndex as Integer
Dim QueryIndex as Integer
n = Ubound(oDialogModel.lstTables.SelectedItems())
If n > -1 Then
SelIndex = oDialogModel.lstTables.SelectedItems(0)
If bGetCommandType Then
CurCommandType = iCommandTypes(SelIndex)
End If
If CurCommandType = com.sun.star.sdb.CommandType.QUERY Then
QueryIndex = SelIndex - Ubound(Tablenames()) - 1
Tablename = QueryNames(QueryIndex)
oColumns = oDBConnection.Queries.GetByName(TableName).Columns
Else
Tablename = Tablenames(SelIndex)
oColumns = oDBConnection.Tables.GetByName(Tablename).Columns
End If
GetSpecificFieldNames()
ToggleListboxControls(oDialogModel, True)
End If
Exit Sub
'TODO: Diese Fehlermarke sinnvoll einbinden
NOFIELDS:
MsgBox sMsgErrCouldNotOpenObject, 16, sMsgWizardName
End Sub
Sub CancelFormWizard()
DlgFormDB.EndExecute()
End Sub
Sub PreviousStep()
With oDialogModel
.Step = 1
.cmdBack.Enabled = False
.cmdGoOn.Enabled = True
.lstSelFields.Tag = Not bControlsareCreated
.cmdGoOn.Label = sGoOn
.imgTheme.ImageUrl = FormPath & "FormWizard_1.bmp"
End With
DlgFormDB.Title = WizardTitle(1)
End Sub
Sub NextStep()
Dim bOldVisible as Boolean
' Note: Unfortunately it is not possible to query the visibility of the imagecontrol directly
bOldVisible = oDialogModel.Height > 40
Select Case oDialogModel.Step
Case 1
bControlsAreCreated = Not (CBool(oDialogModel.lstSelFields.Tag))
If Not bControlsAreCreated Then
GetTableMetaData()
CreateDBForm()
RemoveShapes()
InitializeLayoutSettings()
oDBForm.Load
End If
oDialogModel.cmdGoOn.Label = sReady
oDialogModel.cmdBack.Enabled = True
oDialogModel.Step = 2
Case 2
StoreForm()
End Select
DlgFormDB.GetControl("imgTheme").Visible = bOldVisible
oDialogModel.imgTheme.ImageUrl = FormPath & "FormWizard_" & oDialogModel.Step & ".bmp"
DlgFormDB.Title = WizardTitle(oDialogModel.Step)
End Sub
Sub InitializeLayoutSettings()
If oPageStyle.BackGraphicLocation = com.sun.star.style.GraphicLocation.TILED Then
oDialogModel.optTiled.State = 1
Else
oDialogModel.optArea.State = 1
End If
SwitchArrangementButtons(cTabled)
SwitchAlignMode(SBALIGNLEFT)
SwitchBorderMode(SB3DBORDER)
ToggleBorderGroup(bControlsAreCreated)
ToggleAlignGroup(bControlsAreCreated)
ArrangeControls()
If OldAlignMode <> 0 Then
DlgFormDB.GetControl("optAlign2").Model.State = 0
End If
End Sub
Sub ToggleDatabasePage(bDoEnable as Boolean)
With oDialogModel
.cmdHelp.Enabled = bDoEnable
.cmdGoOn.Enabled = Ubound(oDialogModel.lstSelFields.StringItemList()) <> -1
.hlnBinaries.Enabled = ((bDoEnable = True) And (bEnableBinaryOptionGroup = True))
.optIgnoreBinaries.Enabled = ((bDoEnable = True) And (bEnableBinaryOptionGroup = True))
.optBinariesasGraphics.Enabled = ((bDoEnable = True) And (bEnableBinaryOptionGroup = True))
End With
End Sub
Sub StoreForm()
Dim bDocIsStored as Boolean
Dim FilterNames(1,2) as String
Dim oMasterKey as Object
Dim oFilters() as Object
Dim sTargetPath as String
Dim sBookmarkName as String
Dim oDBBookmarks as Object
Dim bLinkExists as Boolean
Dim i as Integer
Dim sBaseBookmarkName as String
oMasterKey = GetRegistryKeyContent("org.openoffice.Office.TypeDetection/")
oFilters() = oMasterKey.Types
FilterNames(0,0) = oFilters.GetByName("writer_StarOffice_XML_Writer").UIName
FilterNames(0,1) = "*.sxw"
FilterNames(0,2) = ""
FilterNames(1,0) = oFilters.GetByName("writer_StarOffice_XML_Writer_Template").UIName
FilterNames(1,1) = "*.stw"
FilterNames(1,2) = "swriter: writer_StarOffice_XML_Writer_Template"
sTargetPath = StoreDocument(oDocument, FilterNames(), "Form_" & sDBName & "." & TableName, WorkPath)
If sTargetPath <> "" Then
sBookmarkName = GetFileNamewithoutExtension(FileNameoutofPath(sTargetPath))
sBaseBookmarkName = sBookmarkName
oDBBookmarks = oDataSource.GetBookmarks()
i = 1
Do
bLinkExists = oDBBookmarks.HasbyName(sBookmarkName)
If bLinkExists Then
i = i + 1
sBookmarkName = sBaseBookmarkName & "_" & i
Else
oDBBookmarks.insertByName(sBookmarkName, sTargetPath)
End If
Loop Until Not bLinkExists
bDisposeDoc = False
DlgFormDB.EndExecute()
ToggleDesignMode(oDocument)
' Todo: evtl unsinnige Standardwerte f├╝r Controls rauswerfen
oDBForm.Reload()
End If
End Sub</script:module>