1*cdf0e10cSrcweir /************************************************************************* 2*cdf0e10cSrcweir * 3*cdf0e10cSrcweir * The Contents of this file are made available subject to the terms of 4*cdf0e10cSrcweir * the BSD license. 5*cdf0e10cSrcweir * 6*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 7*cdf0e10cSrcweir * All rights reserved. 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * Redistribution and use in source and binary forms, with or without 10*cdf0e10cSrcweir * modification, are permitted provided that the following conditions 11*cdf0e10cSrcweir * are met: 12*cdf0e10cSrcweir * 1. Redistributions of source code must retain the above copyright 13*cdf0e10cSrcweir * notice, this list of conditions and the following disclaimer. 14*cdf0e10cSrcweir * 2. Redistributions in binary form must reproduce the above copyright 15*cdf0e10cSrcweir * notice, this list of conditions and the following disclaimer in the 16*cdf0e10cSrcweir * documentation and/or other materials provided with the distribution. 17*cdf0e10cSrcweir * 3. Neither the name of Sun Microsystems, Inc. nor the names of its 18*cdf0e10cSrcweir * contributors may be used to endorse or promote products derived 19*cdf0e10cSrcweir * from this software without specific prior written permission. 20*cdf0e10cSrcweir * 21*cdf0e10cSrcweir * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS 22*cdf0e10cSrcweir * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT 23*cdf0e10cSrcweir * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS 24*cdf0e10cSrcweir * FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE 25*cdf0e10cSrcweir * COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, 26*cdf0e10cSrcweir * INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, 27*cdf0e10cSrcweir * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS 28*cdf0e10cSrcweir * OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND 29*cdf0e10cSrcweir * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR 30*cdf0e10cSrcweir * TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE 31*cdf0e10cSrcweir * USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. 32*cdf0e10cSrcweir * 33*cdf0e10cSrcweir *************************************************************************/ 34*cdf0e10cSrcweir 35*cdf0e10cSrcweir /**************************************************************************/ 36*cdf0e10cSrcweir import com.sun.star.uno.*; 37*cdf0e10cSrcweir import com.sun.star.beans.*; 38*cdf0e10cSrcweir import com.sun.star.form.*; 39*cdf0e10cSrcweir import com.sun.star.lang.*; 40*cdf0e10cSrcweir import com.sun.star.sdb.*; 41*cdf0e10cSrcweir import com.sun.star.sdbc.*; 42*cdf0e10cSrcweir import com.sun.star.sdbcx.*; 43*cdf0e10cSrcweir import com.sun.star.container.*; 44*cdf0e10cSrcweir import com.sun.star.awt.*; 45*cdf0e10cSrcweir import com.sun.star.task.*; 46*cdf0e10cSrcweir 47*cdf0e10cSrcweir /**************************************************************************/ 48*cdf0e10cSrcweir /** helper class for validating a grid field before it is updated 49*cdf0e10cSrcweir 50*cdf0e10cSrcweir <p>Actually, the mechanism for validating the field is not restricted to 51*cdf0e10cSrcweir grid control fields. Instead, it can be used for any bound controls.</p> 52*cdf0e10cSrcweir */ 53*cdf0e10cSrcweir class GridFieldValidator implements XUpdateListener 54*cdf0e10cSrcweir { 55*cdf0e10cSrcweir private DocumentHelper m_aDocument; 56*cdf0e10cSrcweir private XComponentContext m_xCtx; 57*cdf0e10cSrcweir private XPropertySet m_xWatchedColumn; 58*cdf0e10cSrcweir 59*cdf0e10cSrcweir private boolean m_bWatching; 60*cdf0e10cSrcweir 61*cdf0e10cSrcweir /* ------------------------------------------------------------------ */ 62*cdf0e10cSrcweir public GridFieldValidator( XComponentContext xCtx, XPropertySet xWatchedGridColumn ) 63*cdf0e10cSrcweir { 64*cdf0e10cSrcweir // remember 65*cdf0e10cSrcweir m_xCtx = xCtx; 66*cdf0e10cSrcweir m_xWatchedColumn = xWatchedGridColumn; 67*cdf0e10cSrcweir m_aDocument = DocumentHelper.getDocumentForComponent(xWatchedGridColumn, 68*cdf0e10cSrcweir xCtx); 69*cdf0e10cSrcweir 70*cdf0e10cSrcweir m_bWatching = false; 71*cdf0e10cSrcweir } 72*cdf0e10cSrcweir 73*cdf0e10cSrcweir /* ------------------------------------------------------------------ */ 74*cdf0e10cSrcweir public void enableColumnWatch( boolean bEnable ) 75*cdf0e10cSrcweir { 76*cdf0e10cSrcweir if ( bEnable == m_bWatching ) 77*cdf0e10cSrcweir return; 78*cdf0e10cSrcweir 79*cdf0e10cSrcweir XUpdateBroadcaster xUpdate = (XUpdateBroadcaster)UnoRuntime.queryInterface( 80*cdf0e10cSrcweir XUpdateBroadcaster.class, m_xWatchedColumn ); 81*cdf0e10cSrcweir 82*cdf0e10cSrcweir if ( bEnable ) 83*cdf0e10cSrcweir xUpdate.addUpdateListener( this ); 84*cdf0e10cSrcweir else 85*cdf0e10cSrcweir xUpdate.removeUpdateListener( this ); 86*cdf0e10cSrcweir 87*cdf0e10cSrcweir m_bWatching = bEnable; 88*cdf0e10cSrcweir } 89*cdf0e10cSrcweir 90*cdf0e10cSrcweir /* ------------------------------------------------------------------ */ 91*cdf0e10cSrcweir /** shows a message that we can't do several things due to an implementation error 92*cdf0e10cSrcweir */ 93*cdf0e10cSrcweir private void showInvalidValueMessage( ) 94*cdf0e10cSrcweir { 95*cdf0e10cSrcweir try 96*cdf0e10cSrcweir { 97*cdf0e10cSrcweir // build the message we want to show 98*cdf0e10cSrcweir String sMessage = "The column \""; 99*cdf0e10cSrcweir sMessage += FLTools.getLabel( m_xWatchedColumn ); 100*cdf0e10cSrcweir sMessage += "\" is not allowed to contain empty strings."; 101*cdf0e10cSrcweir 102*cdf0e10cSrcweir SQLContext aError = new SQLContext( 103*cdf0e10cSrcweir new String( "Invalid Value Entered" ), 104*cdf0e10cSrcweir null, 105*cdf0e10cSrcweir new String( "S1000" ), 106*cdf0e10cSrcweir 0, 107*cdf0e10cSrcweir new Any( new Type(), null ), 108*cdf0e10cSrcweir sMessage 109*cdf0e10cSrcweir ); 110*cdf0e10cSrcweir 111*cdf0e10cSrcweir // instantiate an interaction handler who can handle SQLExceptions 112*cdf0e10cSrcweir XInteractionHandler xHandler = (XInteractionHandler)UnoRuntime.queryInterface( 113*cdf0e10cSrcweir XInteractionHandler.class, 114*cdf0e10cSrcweir m_xCtx.getServiceManager().createInstanceWithContext( 115*cdf0e10cSrcweir "com.sun.star.task.InteractionHandler", m_xCtx ) ); 116*cdf0e10cSrcweir 117*cdf0e10cSrcweir // create a new request and execute it 118*cdf0e10cSrcweir InteractionRequest aRequest = new InteractionRequest( aError ); 119*cdf0e10cSrcweir xHandler.handle( aRequest ); 120*cdf0e10cSrcweir } 121*cdf0e10cSrcweir catch( com.sun.star.uno.Exception e ) 122*cdf0e10cSrcweir { 123*cdf0e10cSrcweir System.out.println(e); 124*cdf0e10cSrcweir e.printStackTrace(); 125*cdf0e10cSrcweir } 126*cdf0e10cSrcweir } 127*cdf0e10cSrcweir 128*cdf0e10cSrcweir /* ------------------------------------------------------------------ */ 129*cdf0e10cSrcweir // XUpdateListener overridables 130*cdf0e10cSrcweir /* ------------------------------------------------------------------ */ 131*cdf0e10cSrcweir public boolean approveUpdate( EventObject aEvent ) throws com.sun.star.uno.RuntimeException 132*cdf0e10cSrcweir { 133*cdf0e10cSrcweir boolean bApproved = true; 134*cdf0e10cSrcweir try 135*cdf0e10cSrcweir { 136*cdf0e10cSrcweir // the control model which fired the event 137*cdf0e10cSrcweir XPropertySet xSourceProps = UNO.queryPropertySet( aEvent.Source ); 138*cdf0e10cSrcweir 139*cdf0e10cSrcweir String sNewText = (String)xSourceProps.getPropertyValue( "Text" ); 140*cdf0e10cSrcweir if ( 0 == sNewText.length() ) 141*cdf0e10cSrcweir { 142*cdf0e10cSrcweir // say that the value is invalid 143*cdf0e10cSrcweir showInvalidValueMessage( ); 144*cdf0e10cSrcweir bApproved = false; 145*cdf0e10cSrcweir 146*cdf0e10cSrcweir // reset the control value 147*cdf0e10cSrcweir // for this, we take the current value from the row set field the control 148*cdf0e10cSrcweir // is bound to, and forward it to the control model 149*cdf0e10cSrcweir XColumn xBoundColumn = UNO.queryColumn( xSourceProps.getPropertyValue( "BoundField" ) ); 150*cdf0e10cSrcweir if ( null != xBoundColumn ) 151*cdf0e10cSrcweir { 152*cdf0e10cSrcweir xSourceProps.setPropertyValue( "Text", xBoundColumn.getString() ); 153*cdf0e10cSrcweir } 154*cdf0e10cSrcweir } 155*cdf0e10cSrcweir } 156*cdf0e10cSrcweir catch( com.sun.star.uno.Exception e ) 157*cdf0e10cSrcweir { 158*cdf0e10cSrcweir System.out.println(e); 159*cdf0e10cSrcweir e.printStackTrace(); 160*cdf0e10cSrcweir } 161*cdf0e10cSrcweir return bApproved; 162*cdf0e10cSrcweir } 163*cdf0e10cSrcweir 164*cdf0e10cSrcweir /* ------------------------------------------------------------------ */ 165*cdf0e10cSrcweir public void updated( EventObject aEvent ) throws com.sun.star.uno.RuntimeException 166*cdf0e10cSrcweir { 167*cdf0e10cSrcweir } 168*cdf0e10cSrcweir 169*cdf0e10cSrcweir /* ------------------------------------------------------------------ */ 170*cdf0e10cSrcweir // XEventListener overridables 171*cdf0e10cSrcweir /* ------------------------------------------------------------------ */ 172*cdf0e10cSrcweir public void disposing( EventObject aEvent ) 173*cdf0e10cSrcweir { 174*cdf0e10cSrcweir // not interested in 175*cdf0e10cSrcweir } 176*cdf0e10cSrcweir }; 177