misc changes
[phpeclipse.git] / net.sourceforge.phpeclipse / src / net / sourceforge / phpeclipse / phpeditor / php / PHPCompletionProcessor.java
index dee6cca..ac3f814 100644 (file)
@@ -1,34 +1,51 @@
 /**********************************************************************
-Copyright (c) 2000, 2002 IBM Corp. and others.
-All rights reserved. This program and the accompanying materials
-are made available under the terms of the Common Public License v1.0
-which accompanies this distribution, and is available at
-http://www.eclipse.org/legal/cpl-v10.html
-
-Contributors:
-    IBM Corporation - Initial implementation
-    Klaus Hartlage - www.eclipseproject.de
-**********************************************************************/
+ Copyright (c) 2000, 2002 IBM Corp. and others.
+ All rights reserved. This program and the accompanying materials
+ are made available under the terms of the Common Public License v1.0
+ which accompanies this distribution, and is available at
+ http://www.eclipse.org/legal/cpl-v10.html
+
+ Contributors:
+ IBM Corporation - Initial implementation
+ Klaus Hartlage - www.eclipseproject.de
+ **********************************************************************/
 package net.sourceforge.phpeclipse.phpeditor.php;
-
+import java.sql.Connection;
+import java.sql.DatabaseMetaData;
+import java.sql.ResultSet;
+import java.sql.SQLException;
 import java.util.ArrayList;
 import java.util.Arrays;
 import java.util.List;
-
+import java.util.SortedMap;
+import net.sourceforge.phpdt.core.ToolFactory;
+import net.sourceforge.phpdt.core.compiler.ITerminalSymbols;
+import net.sourceforge.phpdt.core.compiler.InvalidInputException;
+import net.sourceforge.phpdt.internal.compiler.parser.Scanner;
 import net.sourceforge.phpdt.internal.corext.template.ContextType;
 import net.sourceforge.phpdt.internal.corext.template.ContextTypeRegistry;
+import net.sourceforge.phpdt.internal.corext.template.php.CompilationUnitContextType;
+import net.sourceforge.phpdt.internal.corext.template.php.PHPUnitContext;
+import net.sourceforge.phpdt.internal.ui.PHPUiImages;
 import net.sourceforge.phpdt.internal.ui.text.java.IPHPCompletionProposal;
 import net.sourceforge.phpdt.internal.ui.text.java.PHPCompletionProposalComparator;
 import net.sourceforge.phpdt.internal.ui.text.template.BuiltInEngine;
+import net.sourceforge.phpdt.internal.ui.text.template.DeclarationEngine;
 import net.sourceforge.phpdt.internal.ui.text.template.IdentifierEngine;
+import net.sourceforge.phpdt.internal.ui.text.template.IdentifierProposal;
 import net.sourceforge.phpdt.internal.ui.text.template.TemplateEngine;
+import net.sourceforge.phpeclipse.IPreferenceConstants;
 import net.sourceforge.phpeclipse.PHPeclipsePlugin;
-import net.sourceforge.phpeclipse.phpeditor.AbstractContentOutlinePage;
-import net.sourceforge.phpeclipse.phpeditor.PHPContentOutlinePage;
+import net.sourceforge.phpeclipse.builder.IdentifierIndexManager;
 import net.sourceforge.phpeclipse.phpeditor.PHPEditor;
-
+import net.sourceforge.phpeclipse.phpeditor.PHPSyntaxRdr;
+import org.eclipse.core.resources.IFile;
+import org.eclipse.core.resources.IProject;
+import org.eclipse.jface.text.BadLocationException;
 import org.eclipse.jface.text.IDocument;
+import org.eclipse.jface.text.IRegion;
 import org.eclipse.jface.text.ITextViewer;
+import org.eclipse.jface.text.Region;
 import org.eclipse.jface.text.TextPresentation;
 import org.eclipse.jface.text.contentassist.ICompletionProposal;
 import org.eclipse.jface.text.contentassist.IContentAssistProcessor;
@@ -38,356 +55,462 @@ import org.eclipse.jface.text.contentassist.IContextInformationPresenter;
 import org.eclipse.jface.text.contentassist.IContextInformationValidator;
 import org.eclipse.swt.graphics.Image;
 import org.eclipse.ui.IEditorPart;
-
+import org.eclipse.ui.IFileEditorInput;
+import net.sourceforge.phpeclipse.overlaypages.Util;
+import com.quantum.model.Bookmark;
+import com.quantum.model.BookmarkCollection;
+import com.quantum.model.NotConnectedException;
+import com.quantum.util.connection.ConnectionUtil;
 /**
  * Example PHP completion processor.
  */
 public class PHPCompletionProcessor implements IContentAssistProcessor {
-
   /**
-   * Simple content assist tip closer. The tip is valid in a range
-   * of 5 characters around its popup location.
+   * Simple content assist tip closer. The tip is valid in a range of 5
+   * characters around its popup location.
    */
-  protected static class Validator implements IContextInformationValidator, IContextInformationPresenter {
-
+  protected static class Validator
+      implements
+        IContextInformationValidator,
+        IContextInformationPresenter {
     protected int fInstallOffset;
-
     /*
      * @see IContextInformationValidator#isContextInformationValid(int)
      */
     public boolean isContextInformationValid(int offset) {
       return Math.abs(fInstallOffset - offset) < 5;
     }
-
     /*
-     * @see IContextInformationValidator#install(IContextInformation, ITextViewer, int)
+     * @see IContextInformationValidator#install(IContextInformation,
+     *      ITextViewer, int)
      */
     public void install(IContextInformation info, ITextViewer viewer, int offset) {
       fInstallOffset = offset;
     }
-
     /*
-     * @see org.eclipse.jface.text.contentassist.IContextInformationPresenter#updatePresentation(int, TextPresentation)
+     * @see org.eclipse.jface.text.contentassist.IContextInformationPresenter#updatePresentation(int,
+     *      TextPresentation)
      */
-    public boolean updatePresentation(int documentPosition, TextPresentation presentation) {
+    public boolean updatePresentation(int documentPosition,
+        TextPresentation presentation) {
       return false;
     }
   };
-
-  private static class ContextInformationWrapper implements IContextInformation, IContextInformationExtension {
-
+  private static class ContextInformationWrapper
+      implements
+        IContextInformation,
+        IContextInformationExtension {
     private final IContextInformation fContextInformation;
     private int fPosition;
-
     public ContextInformationWrapper(IContextInformation contextInformation) {
       fContextInformation = contextInformation;
     }
-
     /*
      * @see IContextInformation#getContextDisplayString()
      */
     public String getContextDisplayString() {
       return fContextInformation.getContextDisplayString();
     }
-
     /*
-    * @see IContextInformation#getImage()
-    */
+     * @see IContextInformation#getImage()
+     */
     public Image getImage() {
       return fContextInformation.getImage();
     }
-
     /*
      * @see IContextInformation#getInformationDisplayString()
      */
     public String getInformationDisplayString() {
       return fContextInformation.getInformationDisplayString();
     }
-
     /*
      * @see IContextInformationExtension#getContextInformationPosition()
      */
     public int getContextInformationPosition() {
       return fPosition;
     }
-
     public void setContextInformationPosition(int position) {
       fPosition = position;
     }
   };
-
-  //  public final class VariablesCompletionProposal implements IJavaCompletionProposal {
-  //    private String fDisplayString;
-  //    private String fReplacementString;
-  //    private int fReplacementOffset;
-  //    private int fReplacementLength;
-  //    private int fCursorPosition;
-  //    private Image fImage;
-  //    private IContextInformation fContextInformation;
-  //    private String fAdditionalProposalInfo;
-  //
-  //    /**
-  //     * Creates a new completion proposal based on the provided information.  The replacement string is
-  //     * considered being the display string too. All remaining fields are set to <code>null</code>.
-  //     *
-  //     * @param replacementString the actual string to be inserted into the document
-  //     * @param replacementOffset the offset of the text to be replaced
-  //     * @param replacementLength the length of the text to be replaced
-  //     * @param cursorPosition the position of the cursor following the insert relative to replacementOffset
-  //     */
-  //    public VariablesCompletionProposal(
-  //      String replacementString,
-  //      int replacementOffset,
-  //      int replacementLength,
-  //      int cursorPosition) {
-  //      this(replacementString, replacementOffset, replacementLength, cursorPosition, null, null, null, null);
-  //    }
-  //
-  //    /**
-  //     * Creates a new completion proposal. All fields are initialized based on the provided information.
-  //     *
-  //     * @param replacementString the actual string to be inserted into the document
-  //     * @param replacementOffset the offset of the text to be replaced
-  //     * @param replacementLength the length of the text to be replaced
-  //     * @param cursorPosition the position of the cursor following the insert relative to replacementOffset
-  //     * @param image the image to display for this proposal
-  //     * @param displayString the string to be displayed for the proposal
-  //     * @param contentInformation the context information associated with this proposal
-  //     * @param additionalProposalInfo the additional information associated with this proposal
-  //     */
-  //    public VariablesCompletionProposal(
-  //      String replacementString,
-  //      int replacementOffset,
-  //      int replacementLength,
-  //      int cursorPosition,
-  //      Image image,
-  //      String displayString,
-  //      IContextInformation contextInformation,
-  //      String additionalProposalInfo) {
-  //      //      Assert.isNotNull(replacementString);
-  //      //      Assert.isTrue(replacementOffset >= 0);
-  //      //      Assert.isTrue(replacementLength >= 0);
-  //      //      Assert.isTrue(cursorPosition >= 0);
-  //
-  //      fReplacementString = replacementString;
-  //      fReplacementOffset = replacementOffset;
-  //      fReplacementLength = replacementLength;
-  //      fCursorPosition = cursorPosition;
-  //      fImage = image;
-  //      fDisplayString = displayString;
-  //      fContextInformation = contextInformation;
-  //      fAdditionalProposalInfo = additionalProposalInfo;
-  //    }
-  //
-  //    /*
-  //     * @see ICompletionProposal#apply
-  //     */
-  //    public void apply(IDocument document) {
-  //      try {
-  //        document.replace(fReplacementOffset, fReplacementLength, fReplacementString);
-  //      } catch (BadLocationException x) {
-  //        // ignore
-  //      }
-  //    }
-  //
-  //    /*
-  //     * @see ICompletionProposal#getSelection
-  //     */
-  //    public Point getSelection(IDocument document) {
-  //      return new Point(fReplacementOffset + fCursorPosition, 0);
-  //    }
-  //
-  //    /*
-  //     * @see ICompletionProposal#getContextInformation()
-  //     */
-  //    public IContextInformation getContextInformation() {
-  //      return fContextInformation;
-  //    }
-  //
-  //    /*
-  //     * @see ICompletionProposal#getImage()
-  //     */
-  //    public Image getImage() {
-  //      return fImage;
-  //    }
-  //
-  //    /*
-  //     * @see ICompletionProposal#getDisplayString()
-  //     */
-  //    public String getDisplayString() {
-  //      if (fDisplayString != null)
-  //        return fDisplayString;
-  //      return fReplacementString;
-  //    }
-  //
-  //    /*
-  //     * @see ICompletionProposal#getAdditionalProposalInfo()
-  //     */
-  //    public String getAdditionalProposalInfo() {
-  //      return fAdditionalProposalInfo;
-  //    }
-  //    /**
-  //    * Returns the relevance of the proposal.
-  //    */
-  //    public int getRelevance() {
-  //      return 0;
-  //    }
-  //  }
-
-  protected final static String[] fgProposals = PHPFunctionNames.FUNCTION_NAMES;
-
   private char[] fProposalAutoActivationSet;
   protected IContextInformationValidator fValidator = new Validator();
   private TemplateEngine fTemplateEngine;
   private PHPCompletionProposalComparator fComparator;
   private int fNumberOfComputedResults = 0;
-
   public PHPCompletionProcessor() {
-
-    ContextType contextType = ContextTypeRegistry.getInstance().getContextType("php"); //$NON-NLS-1$
+    ContextType contextType = ContextTypeRegistry.getInstance().getContextType(
+        "php"); //$NON-NLS-1$
     if (contextType != null)
       fTemplateEngine = new TemplateEngine(contextType);
-
     fComparator = new PHPCompletionProposalComparator();
   }
-
   /**
    * Tells this processor to order the proposals alphabetically.
    * 
-   * @param order <code>true</code> if proposals should be ordered.
+   * @param order
+   *            <code>true</code> if proposals should be ordered.
    */
   public void orderProposalsAlphabetically(boolean order) {
     fComparator.setOrderAlphabetically(order);
   }
-
   /**
    * Sets this processor's set of characters triggering the activation of the
    * completion proposal computation.
    * 
-   * @param activationSet the activation set
+   * @param activationSet
+   *            the activation set
    */
   public void setCompletionProposalAutoActivationCharacters(char[] activationSet) {
     fProposalAutoActivationSet = activationSet;
   }
-  /* (non-Javadoc)
-   * Method declared on IContentAssistProcessor
+  /*
+   * (non-Javadoc) Method declared on IContentAssistProcessor
    */
-  public ICompletionProposal[] computeCompletionProposals(ITextViewer viewer, int documentOffset) {
-    //    IDocument document = viewer.getDocument();
-    //    if (documentOffset > 0) {
-    //      try {
-    //        ICompletionProposal[] result;
-    //        char character = document.getChar(documentOffset - 1);
-    //        if (character == '$') {
-    ////viewer.  .getActivePage().getActiveEditor();
-    //          result = new ICompletionProposal[fgProposals.length];
-    //          for (int i = 0; i < fgProposals.length; i++) {
-    //            IContextInformation info = new ContextInformation(fgProposals[i], MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.Proposal.ContextInfo.pattern"), new Object[] { fgProposals[i] })); //$NON-NLS-1$
-    //            result[i] = new CompletionProposal(fgProposals[i], documentOffset, 0, fgProposals[i].length(), null, fgProposals[i], info, MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.Proposal.hoverinfo.pattern"), new Object[] { fgProposals[i] })); //$NON-NLS-1$
-    //          }
-    //          return result;
-    //        }
-    //      } catch (BadLocationException e) {
-    //        return new ICompletionProposal[0];
-    //      }
-    //    }
-    //
-    //    ICompletionProposal[] result = new ICompletionProposal[fgProposals.length];
-    //    for (int i = 0; i < fgProposals.length; i++) {
-    //      IContextInformation info = new ContextInformation(fgProposals[i], MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.Proposal.ContextInfo.pattern"), new Object[] { fgProposals[i] })); //$NON-NLS-1$
-    //      result[i] = new CompletionProposal(fgProposals[i], documentOffset, 0, fgProposals[i].length(), null, fgProposals[i], info, MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.Proposal.hoverinfo.pattern"), new Object[] { fgProposals[i] })); //$NON-NLS-1$
-    //    }
-    //    return result;
-    int contextInformationPosition = guessContextInformationPosition(viewer, documentOffset);
-    return internalComputeCompletionProposals(viewer, documentOffset, contextInformationPosition);
-
+  public ICompletionProposal[] computeCompletionProposals(ITextViewer viewer,
+      int documentOffset) {
+    int contextInformationPosition = guessContextInformationPosition(viewer,
+        documentOffset);
+    return internalComputeCompletionProposals(viewer, documentOffset,
+        contextInformationPosition);
   }
-
-  private ICompletionProposal[] internalComputeCompletionProposals(ITextViewer viewer, int offset, int contextOffset) {
+  private int getLastToken(ITextViewer viewer, int completionPosition,
+      PHPUnitContext context) {
+    IDocument document = viewer.getDocument();
+    int start = context.getStart();
+    int end = context.getEnd();
+    String startText;
+    int lastSignificantToken = ITerminalSymbols.TokenNameEOF;
+    try {
+      // begin search 2 lines behind of this
+      int j = start;
+      if (j != 0) {
+        char ch;
+        while (j-- > 0) {
+          ch = document.getChar(j);
+          if (ch == '\n') {
+            break;
+          }
+        }
+        while (j-- > 0) {
+          ch = document.getChar(j);
+          if (ch == '\n') {
+            break;
+          }
+        }
+      }
+      if (j != start) {
+        // scan the line for the dereferencing operator '->'
+        startText = document.get(j, start - j);
+        if (Scanner.DEBUG) {
+          System.out.println(startText);
+        }
+        int token = ITerminalSymbols.TokenNameEOF;
+        
+        token = getLastSQLToken(startText);
+        
+        Scanner scanner = ToolFactory.createScanner(false, false, false);
+        scanner.setSource(startText.toCharArray());
+        scanner.setPHPMode(true);
+        
+        int beforeLastToken = ITerminalSymbols.TokenNameEOF;
+        int lastToken = ITerminalSymbols.TokenNameEOF;
+        try {
+          token = scanner.getNextToken();
+          lastToken = token;
+          while (token != ITerminalSymbols.TokenNameERROR
+              && token != ITerminalSymbols.TokenNameEOF) {
+            beforeLastToken = lastToken;
+            lastToken = token;
+            //                                                         System.out.println(scanner.toStringAction(lastToken));
+            token = scanner.getNextToken();
+          }
+        } catch (InvalidInputException e1) {
+        }
+        switch (lastToken) {
+          case ITerminalSymbols.TokenNameMINUS_GREATER :
+            // dereferencing operator '->' found
+            lastSignificantToken = ITerminalSymbols.TokenNameMINUS_GREATER;
+            if (beforeLastToken == ITerminalSymbols.TokenNameVariable) {
+              lastSignificantToken = ITerminalSymbols.TokenNameVariable;
+            }
+            break;
+          case ITerminalSymbols.TokenNamenew :
+            lastSignificantToken = ITerminalSymbols.TokenNamenew;
+            break;
+        }
+      }
+    } catch (BadLocationException e) {
+    }
+    return lastSignificantToken;
+  }
+  
+  /**
+   * Detect the last significant SQL token in the text before the completion
+   * 
+   * @param startText
+   */
+  private int getLastSQLToken(String startText) {
+    int token;
+    // scan for sql identifiers
+    char ch = ' ';
+    int currentSQLPosition = startText.length();
+    int identEnd = -1;
+    String ident = null;
+    boolean whiteSpace = true;
+    try {
+      while (true) {
+        ch = startText.charAt(--currentSQLPosition);
+        if (ch >= 'A' && ch <= 'Z') {
+          if (identEnd < 0) {
+            identEnd = currentSQLPosition + 1;
+          }
+        } else if (ch >= 'a' && ch <= 'z') {
+          if (identEnd < 0) {
+            identEnd = currentSQLPosition + 1;
+          }
+        } else if (identEnd >= 0) {
+          ident = startText.substring(currentSQLPosition + 1, identEnd);
+          // select -- from -- where --
+          // update -- set -- where --
+          // insert into -- ( -- ) values ( -- )
+          if (ident.length() >= 3 && ident.length() <= 6) {
+            ident = ident.toLowerCase();
+            switch (ident.length()) {
+              case 3 :
+                if (ident.equals("set")) {
+//                  System.out.println("set");
+                  token = ITerminalSymbols.TokenNameSQLset;
+                  return token;
+                }
+                break;
+              case 4 :
+                if (ident.equals("from")) {
+//                  System.out.println("from");
+                  token = ITerminalSymbols.TokenNameSQLfrom;
+                  return token;
+                } else if (ident.equals("into")) {
+//                System.out.println("into");
+                  token = ITerminalSymbols.TokenNameSQLinto;
+                  return token;
+                }
+                break;
+              case 5 :
+                if (ident.equals("where")) {
+//                  System.out.println("where");
+                  token = ITerminalSymbols.TokenNameSQLwhere;
+                  return token;
+                }
+                break;
+              case 6 :
+                if (ident.equals("select")) {
+//                  System.out.println("select");
+                  token = ITerminalSymbols.TokenNameSQLselect;
+                  return token;
+                } else if (ident.equals("insert")) {
+//                  System.out.println("insert");
+                  token = ITerminalSymbols.TokenNameSQLinsert;
+                  return token;
+                } else if (ident.equals("update")) {
+//                  System.out.println("update");
+                  token = ITerminalSymbols.TokenNameSQLupdate;
+                  return token;
+                } else if (ident.equals("values")) {
+//                System.out.println("values");
+                  token = ITerminalSymbols.TokenNameSQLvalues;
+                  return token;
+                }
+                break;
+            }
+          }
+          whiteSpace = false;
+          identEnd = -1;
+        } else if (Character.isWhitespace(ch)) {
+        } else {
+          whiteSpace = false;
+        }
+      }
+    } catch (IndexOutOfBoundsException e) {
+    }
+    return ITerminalSymbols.TokenNameEOF;
+  }
+  
+  private ICompletionProposal[] internalComputeCompletionProposals(
+      ITextViewer viewer, int offset, int contextOffset) {
     IDocument document = viewer.getDocument();
     Object[] identifiers = null;
+    IFile file = null;
+    IProject project = null;
     if (offset > 0) {
-
       PHPEditor editor = null;
-      AbstractContentOutlinePage outlinePage = null;
-
-      IEditorPart targetEditor = PHPeclipsePlugin.getActiveWorkbenchWindow().getActivePage().getActiveEditor();
+      //      JavaOutlinePage outlinePage = null;
+      IEditorPart targetEditor = PHPeclipsePlugin.getActiveWorkbenchWindow()
+          .getActivePage().getActiveEditor();
       if (targetEditor != null && (targetEditor instanceof PHPEditor)) {
         editor = (PHPEditor) targetEditor;
-        outlinePage = editor.getfOutlinePage();
-        if (outlinePage instanceof PHPContentOutlinePage) {
-          identifiers = ((PHPContentOutlinePage) outlinePage).getVariables();
-        }
+        file = ((IFileEditorInput) editor.getEditorInput()).getFile();
+        project = file.getProject();
+        //        outlinePage = editor.getfOutlinePage();
+        // TODO: get the identifiers from the new model
+        //        if (outlinePage instanceof PHPContentOutlinePage) {
+        //          identifiers = ((PHPContentOutlinePage) outlinePage).getVariables();
+        //        }
       }
     }
-
+    ContextType phpContextType = ContextTypeRegistry.getInstance()
+        .getContextType("php"); //$NON-NLS-1$
+    ((CompilationUnitContextType) phpContextType).setContextParameters(
+        document, offset, 0);
+    PHPUnitContext context = (PHPUnitContext) phpContextType.createContext();
+    String prefix = context.getKey();
+    int lastSignificantToken = getLastToken(viewer, offset, context);
+    boolean useClassMembers = (lastSignificantToken == ITerminalSymbols.TokenNameMINUS_GREATER)
+        || (lastSignificantToken == ITerminalSymbols.TokenNameVariable)
+        || (lastSignificantToken == ITerminalSymbols.TokenNamenew);
+    boolean emptyPrefix = prefix == null || prefix.equals("");
     if (fTemplateEngine != null) {
+      IPHPCompletionProposal[] templateResults = new IPHPCompletionProposal[0];
       ICompletionProposal[] results;
-      //      try {
-      fTemplateEngine.reset();
-      fTemplateEngine.complete(viewer, offset); //, unit);
-      //      } catch (JavaModelException x) {
-      //        Shell shell= viewer.getTextWidget().getShell();
-      //        ErrorDialog.openError(shell, JavaTextMessages.getString("CompletionProcessor.error.accessing.title"), JavaTextMessages.getString("CompletionProcessor.error.accessing.message"), x.getStatus()); //$NON-NLS-2$ //$NON-NLS-1$
-      //      }       
-
-      IPHPCompletionProposal[] templateResults = fTemplateEngine.getResults();
-
+      if (!emptyPrefix) {
+        fTemplateEngine.reset();
+        fTemplateEngine.complete(viewer, offset); //, unit);
+        templateResults = fTemplateEngine.getResults();
+      }
       IPHPCompletionProposal[] identifierResults = new IPHPCompletionProposal[0];
-      if (identifiers != null) {
+      if ((!useClassMembers) && identifiers != null) {
         IdentifierEngine identifierEngine;
-        String proposal;
-        // int j = 0;
-        //        for (int i = templateResults.length; i < templateResults.length + variables.length; i++) {
-        //          proposal = (String) variables[j++];
-        //          IContextInformation info = new ContextInformation(proposal, MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.Proposal.ContextInfo.pattern"), new Object[] { proposal })); //$NON-NLS-1$
-        //          results[i] = new VariablesCompletionProposal(proposal, offset, 0, proposal.length(), null, proposal, info, MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.Proposal.hoverinfo.pattern"), new Object[] { proposal })); //$NON-NLS-1$
-        //        }
-
-        ContextType contextType = ContextTypeRegistry.getInstance().getContextType("php"); //$NON-NLS-1$
+        ContextType contextType = ContextTypeRegistry.getInstance()
+            .getContextType("php"); //$NON-NLS-1$
         if (contextType != null) {
           identifierEngine = new IdentifierEngine(contextType);
           identifierEngine.complete(viewer, offset, identifiers);
           identifierResults = identifierEngine.getResults();
         }
       }
-
+      // declarations stored in file project.index on project level
+      IPHPCompletionProposal[] declarationResults = new IPHPCompletionProposal[0];
+      if (project != null) {
+        DeclarationEngine declarationEngine;
+        ContextType contextType = ContextTypeRegistry.getInstance()
+            .getContextType("php"); //$NON-NLS-1$
+        if (contextType != null) {
+          IdentifierIndexManager indexManager = PHPeclipsePlugin.getDefault()
+              .getIndexManager(project);
+          SortedMap sortedMap = indexManager.getIdentifierMap();
+          declarationEngine = new DeclarationEngine(contextType,
+              lastSignificantToken, file);
+          declarationEngine.complete(viewer, offset, sortedMap);
+          declarationResults = declarationEngine.getResults();
+        }
+      }
+      // built in function names from phpsyntax.xml
+      ArrayList syntaxbuffer = PHPSyntaxRdr.getSyntaxData();
       IPHPCompletionProposal[] builtinResults = new IPHPCompletionProposal[0];
-      if (PHPFunctionNames.FUNCTION_NAMES != null) {
+      if ((!useClassMembers) && syntaxbuffer != null) {
         BuiltInEngine builtinEngine;
         String proposal;
-
-        ContextType contextType = ContextTypeRegistry.getInstance().getContextType("php"); //$NON-NLS-1$
+        ContextType contextType = ContextTypeRegistry.getInstance()
+            .getContextType("php"); //$NON-NLS-1$
         if (contextType != null) {
           builtinEngine = new BuiltInEngine(contextType);
-          builtinEngine.complete(viewer, offset, PHPFunctionNames.FUNCTION_NAMES);
+          builtinEngine.complete(viewer, offset, syntaxbuffer);
           builtinResults = builtinEngine.getResults();
         }
       }
-
-      // concatenate arrays
+      IPHPCompletionProposal[] sqlResults = new IPHPCompletionProposal[0];
+      if (project != null) {
+        // Get The Database bookmark from the Quantum SQL plugin:
+        BookmarkCollection sqlBookMarks = BookmarkCollection.getInstance();
+        if (sqlBookMarks != null) {
+          String bookmarkString = Util.getMiscProjectsPreferenceValue(project,
+              IPreferenceConstants.PHP_BOOKMARK_DEFAULT);
+          if (bookmarkString != null && !bookmarkString.equals("")) {
+            Bookmark bookmark = sqlBookMarks.find(bookmarkString);
+            ArrayList list = new ArrayList();
+            if (bookmark != null && !bookmark.isConnected()) {
+              new ConnectionUtil().connect(bookmark, null);
+            }
+            if (bookmark != null && bookmark.isConnected()) {
+              try {
+                Connection connection = bookmark.getConnection();
+                DatabaseMetaData metaData = connection.getMetaData();
+                if (metaData != null) {
+                  int start = context.getStart();
+                  int end = context.getEnd();
+                  IRegion region = new Region(start, end - start);
+                  ResultSet set = metaData.getTables(null, null, prefix + "%",
+                      null);
+                  while (set.next()) {
+                    //                  String tempSchema = set.getString("TABLE_SCHEM");
+                    //                  tempSchema = (tempSchema == null) ? "" :
+                    // tempSchema.trim();
+                    String tableName = set.getString("TABLE_NAME");
+                    tableName = (tableName == null) ? "" : tableName.trim();
+                    if (tableName != null && tableName.length() > 0) {
+                      list.add(tableName);
+                    }
+                  }
+                  set.close();
+                  set = metaData.getColumns(null, null, "%", prefix + "%");
+                  while (set.next()) {
+                    String tableName = set.getString("COLUMN_NAME");
+                    tableName = (tableName == null) ? "" : tableName.trim();
+                    if (tableName != null && tableName.length() > 0) {
+                      list.add(tableName);
+                    }
+                    tableName = set.getString("TABLE_NAME");
+                    tableName = (tableName == null) ? "" : tableName.trim();
+                    if (tableName != null && tableName.length() > 0) {
+                      list.add(tableName);
+                    }
+                  }
+                  set.close();
+                  sqlResults = new IPHPCompletionProposal[list.size()];
+                  for (int i = 0; i < list.size(); i++) {
+                    sqlResults[i] = new IdentifierProposal(
+                        (String) list.get(i), context, region, viewer,
+                        PHPUiImages.get(PHPUiImages.IMG_FUN), PHPUiImages
+                            .get(PHPUiImages.IMG_VAR));
+                  }
+                }
+              } catch (NotConnectedException e) {
+                // ignore this - not mission critical
+              } catch (SQLException e) {
+                e.printStackTrace();
+              }
+            }
+          }
+        }
+      }
+      // concatenate the result arrays
       IPHPCompletionProposal[] total;
-      total = new IPHPCompletionProposal[templateResults.length + identifierResults.length + builtinResults.length];
+      total = new IPHPCompletionProposal[templateResults.length
+          + identifierResults.length + builtinResults.length
+          + declarationResults.length + sqlResults.length];
       System.arraycopy(templateResults, 0, total, 0, templateResults.length);
-      System.arraycopy(identifierResults, 0, total, templateResults.length, identifierResults.length);
-      System.arraycopy(builtinResults, 0, total, templateResults.length + identifierResults.length, builtinResults.length);
+      System.arraycopy(identifierResults, 0, total, templateResults.length,
+          identifierResults.length);
+      System.arraycopy(builtinResults, 0, total, templateResults.length
+          + identifierResults.length, builtinResults.length);
+      System.arraycopy(declarationResults, 0, total, templateResults.length
+          + identifierResults.length + builtinResults.length,
+          declarationResults.length);
+      System.arraycopy(sqlResults, 0, total, templateResults.length
+          + identifierResults.length + builtinResults.length
+          + declarationResults.length, sqlResults.length);
       results = total;
-
       fNumberOfComputedResults = (results == null ? 0 : results.length);
       /*
        * Order here and not in result collector to make sure that the order
-       * applies to all proposals and not just those of the compilation unit. 
+       * applies to all proposals and not just those of the compilation unit.
        */
       return order(results);
     }
     return new IPHPCompletionProposal[0];
   }
-
   private int guessContextInformationPosition(ITextViewer viewer, int offset) {
     int contextPosition = offset;
-
     IDocument document = viewer.getDocument();
-
     //    try {
     //
     //      PHPCodeReader reader= new PHPCodeReader();
@@ -395,7 +518,7 @@ public class PHPCompletionProcessor implements IContentAssistProcessor {
     //  
     //      int nestingLevel= 0;
     //
-    //      int curr= reader.read();    
+    //      int curr= reader.read();
     //      while (curr != PHPCodeReader.EOF) {
     //
     //        if (')' == (char) curr)
@@ -408,51 +531,58 @@ public class PHPCompletionProcessor implements IContentAssistProcessor {
     //            int start= reader.getOffset();
     //            if (looksLikeMethod(reader))
     //              return start + 1;
-    //          } 
+    //          }
     //        }
     //
-    //        curr= reader.read();          
+    //        curr= reader.read();
     //      }
     //    } catch (IOException e) {
     //    }
-
     return contextPosition;
   }
-
-  /* (non-Javadoc)
-   * Method declared on IContentAssistProcessor
+  /*
+   * (non-Javadoc) Method declared on IContentAssistProcessor
    */
-  //  public IContextInformation[] computeContextInformation(ITextViewer viewer, int documentOffset) {
+  //  public IContextInformation[] computeContextInformation(ITextViewer viewer,
+  // int documentOffset) {
   //    IContextInformation[] result = new IContextInformation[5];
   //    for (int i = 0; i < result.length; i++)
-  //      result[i] = new ContextInformation(MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.ContextInfo.display.pattern"), new Object[] { new Integer(i), new Integer(documentOffset)}), //$NON-NLS-1$
-  //      MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.ContextInfo.value.pattern"), new Object[] { new Integer(i), new Integer(documentOffset - 5), new Integer(documentOffset + 5)})); //$NON-NLS-1$
+  //      result[i] = new
+  // ContextInformation(MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.ContextInfo.display.pattern"),
+  // new Object[] { new Integer(i), new Integer(documentOffset)}),
+  // //$NON-NLS-1$
+  //      MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.ContextInfo.value.pattern"),
+  // new Object[] { new Integer(i), new Integer(documentOffset - 5), new
+  // Integer(documentOffset + 5)})); //$NON-NLS-1$
   //    return result;
   //  }
   /**
    * @see IContentAssistProcessor#computeContextInformation(ITextViewer, int)
    */
-  public IContextInformation[] computeContextInformation(ITextViewer viewer, int offset) {
-    int contextInformationPosition = guessContextInformationPosition(viewer, offset);
+  public IContextInformation[] computeContextInformation(ITextViewer viewer,
+      int offset) {
+    int contextInformationPosition = guessContextInformationPosition(viewer,
+        offset);
     List result = addContextInformations(viewer, contextInformationPosition);
-    return (IContextInformation[]) result.toArray(new IContextInformation[result.size()]);
+    return (IContextInformation[]) result
+        .toArray(new IContextInformation[result.size()]);
   }
-
   private List addContextInformations(ITextViewer viewer, int offset) {
-    ICompletionProposal[] proposals = internalComputeCompletionProposals(viewer, offset, -1);
-
+    ICompletionProposal[] proposals = internalComputeCompletionProposals(
+        viewer, offset, -1);
     List result = new ArrayList();
     for (int i = 0; i < proposals.length; i++) {
-      IContextInformation contextInformation = proposals[i].getContextInformation();
+      IContextInformation contextInformation = proposals[i]
+          .getContextInformation();
       if (contextInformation != null) {
-        ContextInformationWrapper wrapper = new ContextInformationWrapper(contextInformation);
+        ContextInformationWrapper wrapper = new ContextInformationWrapper(
+            contextInformation);
         wrapper.setContextInformationPosition(offset);
         result.add(wrapper);
       }
     }
     return result;
   }
-
   /**
    * Order the given proposals.
    */
@@ -460,32 +590,27 @@ public class PHPCompletionProcessor implements IContentAssistProcessor {
     Arrays.sort(proposals, fComparator);
     return proposals;
   }
-
-  /* (non-Javadoc)
-   * Method declared on IContentAssistProcessor
+  /*
+   * (non-Javadoc) Method declared on IContentAssistProcessor
    */
   public char[] getCompletionProposalAutoActivationCharacters() {
     return fProposalAutoActivationSet;
     //    return null; // new char[] { '$' };
   }
-
-  /* (non-Javadoc)
-   * Method declared on IContentAssistProcessor
+  /*
+   * (non-Javadoc) Method declared on IContentAssistProcessor
    */
   public char[] getContextInformationAutoActivationCharacters() {
-    return new char[] {
-    };
+    return new char[]{};
   }
-
-  /* (non-Javadoc)
-   * Method declared on IContentAssistProcessor
+  /*
+   * (non-Javadoc) Method declared on IContentAssistProcessor
    */
   public IContextInformationValidator getContextInformationValidator() {
     return fValidator;
   }
-
-  /* (non-Javadoc)
-   * Method declared on IContentAssistProcessor
+  /*
+   * (non-Javadoc) Method declared on IContentAssistProcessor
    */
   public String getErrorMessage() {
     return null;