Open proposals only, if autoactivation character '>' contains to token '->'. See:
authoraxelcl <axelcl>
Sun, 21 Aug 2005 11:41:41 +0000 (11:41 +0000)
committeraxelcl <axelcl>
Sun, 21 Aug 2005 11:41:41 +0000 (11:41 +0000)
http://phpeclipse.de/tiki-view_forum_thread.php?forumId=5&comments_parentId=2027

net.sourceforge.phpeclipse/src/net/sourceforge/phpdt/ui/PreferenceConstants.java
net.sourceforge.phpeclipse/src/net/sourceforge/phpeclipse/phpeditor/php/PHPCompletionProcessor.java

index 45af042..220c27c 100644 (file)
@@ -2462,7 +2462,7 @@ public class PreferenceConstants {
     PreferenceConverter.setDefault(store, PreferenceConstants.CODEASSIST_PARAMETERS_FOREGROUND, new RGB(0, 0, 0));
     PreferenceConverter.setDefault(store, PreferenceConstants.CODEASSIST_REPLACEMENT_BACKGROUND, new RGB(255, 255, 0));
     PreferenceConverter.setDefault(store, PreferenceConstants.CODEASSIST_REPLACEMENT_FOREGROUND, new RGB(255, 0, 0));
-    store.setDefault(PreferenceConstants.CODEASSIST_AUTOACTIVATION_TRIGGERS_JAVA, "$"); //$NON-NLS-1$
+    store.setDefault(PreferenceConstants.CODEASSIST_AUTOACTIVATION_TRIGGERS_JAVA, "$>"); //$NON-NLS-1$
     store.setDefault(PreferenceConstants.CODEASSIST_AUTOACTIVATION_TRIGGERS_JAVADOC, "@"); //$NON-NLS-1$
     store.setDefault(PreferenceConstants.CODEASSIST_AUTOACTIVATION_TRIGGERS_HTML, "<&#"); //$NON-NLS-1$
     store.setDefault(PreferenceConstants.CODEASSIST_SHOW_VISIBLE_PROPOSALS, true);
index c0bdd55..2de1ec7 100644 (file)
@@ -71,921 +71,969 @@ import org.eclipse.swt.graphics.Point;
 import org.eclipse.ui.IEditorPart;
 import org.eclipse.ui.IFileEditorInput;
 
-//import com.quantum.ExternalInterface;
+// import com.quantum.ExternalInterface;
 // import com.quantum.util.connection.NotConnectedException;
 
 /**
  * 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.
-   */
-//  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)
-//     */
-//    public void install(IContextInformation info, ITextViewer viewer, int offset) {
-//      fInstallOffset = offset;
-//    }
-//
-//    /*
-//     * @see org.eclipse.jface.text.contentassist.IContextInformationPresenter#updatePresentation(int, TextPresentation)
-//     */
-//    public boolean updatePresentation(int documentPosition, TextPresentation presentation) {
-//      return false;
-//    }
-//  };
-
-  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()
-     */
-    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;
-    }
-  };
-
-  private class TableName {
-    String fTableName;
-
-    TableName() {
-      fTableName = null;
-    }
-
-    /**
-     * @return Returns the tableName.
-     */
-    public String getTableName() {
-      if (fTableName == null) {
-        return "<!--no-table-->";
-      }
-      return fTableName;
-    }
-
-    /**
-     * @param tableName
-     *          The tableName to set.
-     */
-    public void setTableName(String tableName) {
-      fTableName = tableName;
-    }
-  }
-
-  private char[] fProposalAutoActivationSet;
-
-  protected IContextInformationValidator fValidator = null;// = new Validator();
-
-  private TemplateEngine fTemplateEngine;
-
-  private PHPCompletionProposalComparator fComparator;
-
-  private int fNumberOfComputedResults = 0;
-
-  private IEditorPart fEditor;
-
-  protected IWorkingCopyManager fManager;
-
-  public PHPCompletionProcessor(IEditorPart editor) {
-    fEditor = editor;
-    fManager = PHPeclipsePlugin.getDefault().getWorkingCopyManager();
-    TemplateContextType contextType = PHPeclipsePlugin.getDefault().getTemplateContextRegistry().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.
-   */
-  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
-   */
-  public void setCompletionProposalAutoActivationCharacters(char[] activationSet) {
-    fProposalAutoActivationSet = activationSet;
-  }
-
-  /*
-   * (non-Javadoc) Method declared on IContentAssistProcessor
-   */
-  public ICompletionProposal[] computeCompletionProposals(ITextViewer viewer, int documentOffset) {
-    int contextInformationPosition = guessContextInformationPosition(viewer, documentOffset);
-    return internalComputeCompletionProposals(viewer, documentOffset, contextInformationPosition);
-  }
-
-  private int getLastToken(List list, ITextViewer viewer, int completionPosition, JavaContext context, TableName tableName) {
-    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);
-        tableName.setTableName(getLastSQLTableName(startText));
-        Scanner scanner = ToolFactory.createScanner(false, false, false);
-        scanner.setSource(startText.toCharArray());
-        scanner.setPHPMode(true);
-        int beforeLastToken = ITerminalSymbols.TokenNameEOF;
-        int lastToken = ITerminalSymbols.TokenNameEOF;
-        char[] ident = null;
-        try {
-          token = scanner.getNextToken();
-          lastToken = token;
-          while (token != ITerminalSymbols.TokenNameERROR && token != ITerminalSymbols.TokenNameEOF) {
-            beforeLastToken = lastToken;
-            if (token == ITerminalSymbols.TokenNameVariable) {
-              ident = scanner.getCurrentTokenSource();
-              if (ident.length == 5 && ident[0] == '$' && ident[1] == 't' && ident[2] == 'h' && ident[3] == 'i' && ident[4] == 's') {
-                token = ITerminalSymbols.TokenNamethis_PHP_COMPLETION;
-              }
-            }
-            lastToken = token;
-            // System.out.println(scanner.toStringAction(lastToken));
-            token = scanner.getNextToken();
-          }
-        } catch (InvalidInputException e1) {
-        } catch (SyntaxError e) {
-        }
-        switch (lastToken) {
-        case ITerminalSymbols.TokenNameMINUS_GREATER:
-          // dereferencing operator '->' found
-          lastSignificantToken = ITerminalSymbols.TokenNameMINUS_GREATER;
-          if (beforeLastToken == ITerminalSymbols.TokenNameVariable) {
-            lastSignificantToken = ITerminalSymbols.TokenNameVariable;
-            list.set(0, ident);
-          } else if (beforeLastToken == ITerminalSymbols.TokenNamethis_PHP_COMPLETION) {
-            lastSignificantToken = ITerminalSymbols.TokenNamethis_PHP_COMPLETION;
-            list.set(0, ident);
-          }
-          break;
-        case ITerminalSymbols.TokenNamenew:
-          lastSignificantToken = ITerminalSymbols.TokenNamenew;
-          break;
-        }
-      }
-    } catch (BadLocationException e) {
-    }
-    return lastSignificantToken;
-  }
-
-  String getSQLTableName(String sqlText, int start) {
-    int tableNameStart = -1;
-    int currentCharacterPosition = start + 1;
-    char ch;
-    try {
-      while (true) {
-        ch = sqlText.charAt(currentCharacterPosition++);
-        if (tableNameStart == -1 && Scanner.isPHPIdentifierStart(ch)) {
-          tableNameStart = currentCharacterPosition - 1;
-        } else {
-          if (!Scanner.isPHPIdentifierPart(ch)) {
-            return sqlText.substring(tableNameStart, currentCharacterPosition - 1);
-          }
-        }
-      }
-    } catch (IndexOutOfBoundsException e) {
-      if (tableNameStart >= 0) {
-        return sqlText.substring(tableNameStart, currentCharacterPosition - 1);
-      }
-    }
-    return "";
-  }
-
-  private String getLastSQLTableName(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 (Scanner.isSQLIdentifierPart(ch)) {
-//        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() >= 4 && 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 getSQLTableName(startText, identEnd);
-              } else if (ident.equals("into")) {
-                //                System.out.println("into");
-                token = ITerminalSymbols.TokenNameSQLinto;
-                return getSQLTableName(startText, identEnd);
-              }
-              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 getSQLTableName(startText, identEnd);
-              }
-              //                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 "<!--no-table-->";
-  }
-
-  /**
-   * 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;
-                //getSQLTableName();
-                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) {
-    ICompilationUnit unit = fManager.getWorkingCopy(fEditor.getEditorInput());
-    IDocument document = viewer.getDocument();
-    IFile file = null;
-    IProject project = null;
-    if (offset > 0) {
-      PHPEditor editor = null;
-      if (fEditor != null && (fEditor instanceof PHPEditor)) {
-        editor = (PHPEditor) fEditor;
-        file = ((IFileEditorInput) editor.getEditorInput()).getFile();
-        project = file.getProject();
-      }
-    }
-
-    Point selection = viewer.getSelectedRange();
-    // remember selected text
-    String selectedText = null;
-    if (selection.y != 0) {
-      try {
-        selectedText = document.get(selection.x, selection.y);
-      } catch (BadLocationException e) {
-      }
-    }
-
-    JavaContextType phpContextType = (JavaContextType) PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
-        "php"); //$NON-NLS-1$
-    JavaContext context = (JavaContext) phpContextType.createContext(document, offset, selection.y, unit);
-    context.setVariable("selection", selectedText); //$NON-NLS-1$
-    String prefix = context.getKey();
-
-    HashMap methodVariables = null;
-    HashMap typeVariables = null;
-    HashMap unitVariables = null;
-    ICompilationUnit compilationUnit = (ICompilationUnit) context.findEnclosingElement(IJavaElement.COMPILATION_UNIT);
-    //    if (compilationUnit != null) {
-    //      unitVariables = ((CompilationUnit) compilationUnit).variables;
-    //    }
-    IType type = (IType) context.findEnclosingElement(IJavaElement.TYPE);
-    //    if (type != null) {
-    //      typeVariables = ((SourceType) type).variables;
-    //    }
-    IMethod method = (IMethod) context.findEnclosingElement(IJavaElement.METHOD);
-    //    if (method != null) {
-    //      methodVariables = ((SourceMethod) method).variables;
-    //    }
-
-    boolean emptyPrefix = prefix == null || prefix.equals("");
-    IPHPCompletionProposal[] localVariableResults = new IPHPCompletionProposal[0];
-
-    if (!emptyPrefix && prefix.length() >= 1 && prefix.charAt(0) == '$') { // php Variable ?
-      String lowerCasePrefix = prefix.toLowerCase();
-      HashSet localVariables = new HashSet();
-      if (compilationUnit != null) {
-        unitVariables = getUnitVariables(unitVariables, compilationUnit);
-        getVariableProposals(localVariables, viewer, project, context, unitVariables, lowerCasePrefix, 94);
-      }
-      if (method != null) {
-        methodVariables = getMethodVariables(methodVariables, method);
-        getVariableProposals(localVariables, viewer, project, context, methodVariables, lowerCasePrefix, 99);
-      }
-      if (!localVariables.isEmpty()) {
-        localVariableResults = (IPHPCompletionProposal[]) localVariables.toArray(new IPHPCompletionProposal[localVariables.size()]);
-      }
-    }
-
-    TableName sqlTable = new TableName();
-    ArrayList list = new ArrayList();
-    list.add(null);
-    int lastSignificantToken = getLastToken(list, viewer, offset, context, sqlTable);
-    boolean useClassMembers = (lastSignificantToken == ITerminalSymbols.TokenNameMINUS_GREATER)
-        || (lastSignificantToken == ITerminalSymbols.TokenNameVariable) || (lastSignificantToken == ITerminalSymbols.TokenNamenew)
-        || (lastSignificantToken == ITerminalSymbols.TokenNamethis_PHP_COMPLETION);
-
-    if (fTemplateEngine != null) {
-      IPHPCompletionProposal[] templateResults = new IPHPCompletionProposal[0];
-      ICompletionProposal[] results;
-      if (!emptyPrefix) {
-        fTemplateEngine.reset();
-        fTemplateEngine.complete(viewer, offset, unit);
-        templateResults = fTemplateEngine.getResults();
-      }
-      // TODO delete this
-      IPHPCompletionProposal[] identifierResults = new IPHPCompletionProposal[0];
-
-      // declarations stored in file project.index on project level
-      IPHPCompletionProposal[] declarationResults = new IPHPCompletionProposal[0];
-      if (project != null) {
-        DeclarationEngine declarationEngine;
-        JavaContextType contextType = (JavaContextType) PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
-            "php"); //$NON-NLS-1$
-        if (contextType != null) {
-          IdentifierIndexManager indexManager = PHPeclipsePlugin.getDefault().getIndexManager(project);
-          SortedMap sortedMap;
-          declarationEngine = new DeclarationEngine(project, contextType, lastSignificantToken, file);
-          if (lastSignificantToken == ITerminalSymbols.TokenNamethis_PHP_COMPLETION) {
-            // complete '$this->'
-            sortedMap = indexManager.getIdentifiers(file);
-            declarationEngine.completeObject(viewer, offset, sortedMap, unit);
-          } else {
-            String typeRef = null;
-            char[] varName = (char[]) list.get(0);
-            if (varName != null) {
-              if (method != null) {
-                methodVariables = getMethodVariables(methodVariables, method);
-                VariableInfo info = (VariableInfo) methodVariables.get(new String(varName));
-                if (info != null && info.typeIdentifier != null) {
-                  typeRef = new String(info.typeIdentifier);
-                }
-
-              }
-            }
-            if (typeRef != null) {
-              // complete '$variable->' with type information
-              sortedMap = indexManager.getIdentifiers(typeRef);
-              declarationEngine.completeObject(viewer, offset, sortedMap, unit);
-            } else {
-              // complete '$variable->' without type information
-              sortedMap = indexManager.getIdentifierMap();
-              declarationEngine.complete(viewer, offset, sortedMap, unit);
-            }
-          }
-          declarationResults = declarationEngine.getResults();
-        }
-      }
-      // built in function names from phpsyntax.xml
-      ArrayList syntaxbuffer = PHPSyntaxRdr.getSyntaxData();
-      IPHPCompletionProposal[] builtinResults = new IPHPCompletionProposal[0];
-      if ((!useClassMembers) && syntaxbuffer != null) {
-        BuiltInEngine builtinEngine;
-        String proposal;
-        JavaContextType contextType = (JavaContextType) PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
-            "php"); //$NON-NLS-1$
-        if (contextType != null) {
-          builtinEngine = new BuiltInEngine(contextType);
-          builtinEngine.complete(viewer, offset, syntaxbuffer, unit);
-          builtinResults = builtinEngine.getResults();
-        }
-      }
-//      ICompletionProposal[] sqlResults = new ICompletionProposal[0];
-//      if (project != null) {
-//        sqlResults = getSQLProposals(viewer, project, context, prefix, sqlTable);
-//      }
-      // concatenate the result arrays
-      IPHPCompletionProposal[] total;
-      total = new IPHPCompletionProposal[localVariableResults.length + 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(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);
-//      System.arraycopy(localVariableResults, 0, total, templateResults.length + identifierResults.length + builtinResults.length
-//          + declarationResults.length + sqlResults.length, localVariableResults.length);
-      System.arraycopy(localVariableResults, 0, total, templateResults.length + identifierResults.length + builtinResults.length
-          + declarationResults.length, localVariableResults.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.
-       */
-      return order(results);
-    }
-    return new IPHPCompletionProposal[0];
-  }
-  /**
-   * @param unitVariables
-   * @param unit
-   */
-  private HashMap getUnitVariables(HashMap unitVariables, ICompilationUnit unit) {
-    if (unitVariables == null) {
-      try {
-        String unitText = unit.getSource();
-        unitVariables = new HashMap();
-        
-        ProblemReporter problemReporter = new ProblemReporter(DefaultErrorHandlingPolicies.exitAfterAllProblems(),
-            new CompilerOptions(JavaCore.getOptions()), new DefaultProblemFactory());
-        UnitParser parser = new UnitParser(problemReporter);
-        parser.compilationUnit = new CompilationUnitDeclaration(problemReporter, null, unitText.length());
-        parser.parse(unitText, unitVariables);
-        
-      } catch (Exception e) {
-        // TODO Auto-generated catch block
-        e.printStackTrace();
-        PHPeclipsePlugin.log(e);
-      }
-    }
-    return unitVariables;
-  }
-  
-  /**
-   * @param methodVariables
-   * @param method
-   */
-  private HashMap getMethodVariables(HashMap methodVariables, IMethod method) {
-    if (methodVariables == null) {
-      try {
-        String methodText = method.getSource();
-        methodVariables = new HashMap();
-        ProblemReporter problemReporter = new ProblemReporter(DefaultErrorHandlingPolicies.exitAfterAllProblems(),
-            new CompilerOptions(JavaCore.getOptions()), new DefaultProblemFactory());
-        UnitParser parser = new UnitParser(problemReporter);
-        parser.compilationUnit = new CompilationUnitDeclaration(problemReporter, null, methodText.length());
-        parser.parseFunction(methodText, methodVariables);
-      } catch (Exception e) {
-        // TODO Auto-generated catch block
-        e.printStackTrace();
-        PHPeclipsePlugin.log(e);
-      }
-    }
-    return methodVariables;
-  }
-
-  /**
-   * @param viewer
-   * @param project
-   * @param context
-   * @param prefix
-   * @return
-   */
-  private void getVariableProposals(HashSet localVariables, ITextViewer viewer, IProject project, JavaContext context,
-      HashMap variables, String prefix, int relevance) {
-//    try {
-      int start = context.getStart();
-      int end = context.getEnd();
-      IRegion region = new Region(start, end - start);
-      //      IMethod method = (IMethod) context.findEnclosingElement(IJavaElement.METHOD);
-      //      if (method != null && (method instanceof SourceMethod) && ((SourceMethod) method).variables != null) {
-      //        HashMap map = ((SourceMethod) method).variables;
-      Set set = variables.keySet();
-      Iterator iter = set.iterator();
-      String varName;
-      boolean matchesVarName;
-      while (iter.hasNext()) {
-        varName = (String) iter.next();
-        if (varName.length() >= prefix.length()) {
-          matchesVarName = true;
-          for (int i = 0; i < prefix.length(); i++) {
-            if (prefix.charAt(i) != Character.toLowerCase(varName.charAt(i))) {
-              matchesVarName = false;
-              break;
-            }
-          }
-          if (matchesVarName) {
-            LocalVariableProposal prop;
-            //            if (varName.length == prefix.length()) {
-            //              prop = new LocalVariableProposal(new String(varName), region, viewer, relevance-10);
-            //            } else {
-            prop = new LocalVariableProposal(new String(varName), region, viewer, relevance);
-            //            }
-            localVariables.add(prop);
-          }
-        }
-      }
-      //      }
-
-      //      char[] varName;
-      //      boolean matchesVarName;
-      //      if (method != null) {
-      //        ISourceRange range = method.getSourceRange();
-      //        char[] source = method.getSource().toCharArray();
-      //        Scanner scanner = new Scanner();
-      //        scanner.setSource(source);
-      //        scanner.phpMode = true;
-      //        int token = Scanner.TokenNameWHITESPACE;
-      //        while ((token = scanner.getNextToken()) != Scanner.TokenNameEOF) {
-      //          if (token == Scanner.TokenNameVariable) {
-      //            varName = scanner.getCurrentTokenSource();
-      //            if (varName.length >= prefix.length()) {
-      //              matchesVarName = true;
-      //              for (int i = 0; i < prefix.length(); i++) {
-      //                if (prefix.charAt(i) != varName[i]) {
-      //                  matchesVarName = false;
-      //                  break;
-      //                }
-      //              }
-      //              if (matchesVarName) {
-      //                LocalVariableProposal prop = new LocalVariableProposal(new String(varName), region, viewer);
-      //                if (varName.length == prefix.length()) {
-      //                  prop.setRelevance(98);
-      //                }
-      //                localVariables.add(prop);
-      //              }
-      //            }
-      //          }
-      //        }
-      //      }
-    //    } catch (Throwable e) {
-    //      // ignore - Syntax exceptions could occur, if there are syntax errors !
-    //    }
-  }
-
-  /**
-   * @param viewer
-   * @param project
-   * @param context
-   * @param prefix
-   * @param sqlTable
-   * @param sqlResults
-   * @return
-   */
-//  private ICompletionProposal[] getSQLProposals(ITextViewer viewer, IProject project, DocumentTemplateContext context,
-//      String prefix, TableName sqlTable) {
-//    ICompletionProposal[] sqlResults = new ICompletionProposal[0];
-//    // Get The Database bookmark from the Quantum SQL plugin:
-//    //    BookmarkCollection sqlBookMarks = BookmarkCollection.getInstance();
-//    //    if (sqlBookMarks != null) {
-//    String bookmarkString = ProjectPrefUtil.getMiscProjectsPreferenceValue(project, IPreferenceConstants.PHP_BOOKMARK_DEFAULT);
-//    if (bookmarkString != null && !bookmarkString.equals("")) {
-//      String[] bookmarks = ExternalInterface.getBookmarkNames();
-//      boolean foundBookmark = false;
-//      for (int i = 0; i < bookmarks.length; i++) {
-//        if (bookmarks[i].equals(bookmarkString)) {
-//          foundBookmark = true;
-//        }
-//      }
-//      if (!foundBookmark) {
-//        return sqlResults;
-//      }
-//      //        Bookmark bookmark = sqlBookMarks.find(bookmarkString);
-//      ArrayList sqlList = new ArrayList();
-//      if (!ExternalInterface.isBookmarkConnected(bookmarkString)) {
-//        ExternalInterface.connectBookmark(bookmarkString, null);
-//        if (!ExternalInterface.isBookmarkConnected(bookmarkString)) {
-//          return sqlResults;
-//        }
-//      }
-//      //      if (ExternalInterface.isBookmarkConnected(bookmarkString)) {
-//      try {
-//         int start = context.getStart();
-//        int end = context.getEnd();
-//        String foundSQLTableName = sqlTable.getTableName();
-//        String tableName;
-//        String columnName;
-//        String prefixWithoutDollar = prefix;
-//        boolean isDollarPrefix = false;
-//        if (prefix.length() > 0 && prefix.charAt(0) == '$') {
-//          prefixWithoutDollar = prefix.substring(1);
-//          isDollarPrefix = true;
-//        }
-//        IRegion region = new Region(start, end - start);
-//        ResultSet set;
-//        if (!isDollarPrefix) {
-//          String[] tableNames = ExternalInterface.getMatchingTableNames(null, bookmarkString, prefixWithoutDollar, null, false);
-//          for (int i = 0; i < tableNames.length; i++) {
-//            sqlList.add(new SQLProposal(tableNames[i], context, region, viewer, PHPUiImages.get(PHPUiImages.IMG_TABLE)));
-//          }
-//        }
-//
-//        String[] columnNames = ExternalInterface.getMatchingColumnNames(null, bookmarkString, prefixWithoutDollar, null, false);
-//        for (int i = 0; i < columnNames.length; i++) {
-//          sqlList.add(new SQLProposal(columnNames[i], context, region, viewer, PHPUiImages.get(PHPUiImages.IMG_TABLE)));
-//        }
-//        
-//        sqlResults = new IPHPCompletionProposal[sqlList.size()];
-//        for (int i = 0; i < sqlList.size(); i++) {
-//          sqlResults[i] = (SQLProposal) sqlList.get(i);
-//        }
-//      } catch (Exception /* NotConnectedException */ e) {
-//        
-//      }
-//      //      }
-//    }
-//    //    }
-//    return sqlResults;
-//  }
-
-  private boolean looksLikeMethod(PHPCodeReader reader) throws IOException {
-    int curr = reader.read();
-    while (curr != PHPCodeReader.EOF && Character.isWhitespace((char) curr))
-      curr = reader.read();
-
-    if (curr == PHPCodeReader.EOF)
-      return false;
-
-    return Scanner.isPHPIdentifierPart((char) curr);
-  }
-
-  private int guessContextInformationPosition(ITextViewer viewer, int offset) {
-    int contextPosition = offset;
-    IDocument document = viewer.getDocument();
-    try {
-
-      PHPCodeReader reader = new PHPCodeReader();
-      reader.configureBackwardReader(document, offset, true, true);
-
-      int nestingLevel = 0;
-
-      int curr = reader.read();
-      while (curr != PHPCodeReader.EOF) {
-
-        if (')' == (char) curr)
-          ++nestingLevel;
-
-        else if ('(' == (char) curr) {
-          --nestingLevel;
-
-          if (nestingLevel < 0) {
-            int start = reader.getOffset();
-            if (looksLikeMethod(reader))
-              return start + 1;
-          }
-        }
-
-        curr = reader.read();
-      }
-    } catch (IOException e) {
-    }
-    return contextPosition;
-  }
-
-  /**
-   * @see IContentAssistProcessor#computeContextInformation(ITextViewer, int)
-   */
-  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()]);
-  }
-
-  private List addContextInformations(ITextViewer viewer, int offset) {
-    ICompletionProposal[] proposals = internalComputeCompletionProposals(viewer, offset, -1);
-    List result = new ArrayList();
-    for (int i = 0; i < proposals.length; i++) {
-      IContextInformation contextInformation = proposals[i].getContextInformation();
-      if (contextInformation != null) {
-        ContextInformationWrapper wrapper = new ContextInformationWrapper(contextInformation);
-        wrapper.setContextInformationPosition(offset);
-        result.add(wrapper);
-      }
-    }
-    return result;
-  }
-
-  /**
-   * Order the given proposals.
-   */
-  private ICompletionProposal[] order(ICompletionProposal[] proposals) {
-    Arrays.sort(proposals, fComparator);
-    //    int len = proposals.length;
-    //    if (len > 10) {
-    //      len = 10;
-    //    }
-    //    for (int i = 0; i < len; i++) {
-    //      System.out.println(proposals[i].getDisplayString());
-    //    }
-    return proposals;
-  }
-
-  /*
-   * (non-Javadoc) Method declared on IContentAssistProcessor
-   */
-  public char[] getCompletionProposalAutoActivationCharacters() {
-    return fProposalAutoActivationSet;
-    //    return null; // new char[] { '$' };
-  }
-
-  /*
-   * (non-Javadoc) Method declared on IContentAssistProcessor
-   */
-  public char[] getContextInformationAutoActivationCharacters() {
-       return null;
-  }
-
-  /*
-   * (non-Javadoc) Method declared on IContentAssistProcessor
-   */
-  public IContextInformationValidator getContextInformationValidator() {
+       /**
+        * 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 int fInstallOffset;
+       //
+       // /*
+       // * @see IContextInformationValidator#isContextInformationValid(int)
+       // */
+       // public boolean isContextInformationValid(int offset) {
+       // return Math.abs(fInstallOffset - offset) < 5;
+       // }
+       //
+       // /*
+       // * @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)
+       // */
+       // public boolean updatePresentation(int documentPosition, TextPresentation
+       // presentation) {
+       // return false;
+       // }
+       // };
+       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()
+                */
+               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;
+               }
+       };
+
+       private class TableName {
+               String fTableName;
+
+               TableName() {
+                       fTableName = null;
+               }
+
+               /**
+                * @return Returns the tableName.
+                */
+               public String getTableName() {
+                       if (fTableName == null) {
+                               return "<!--no-table-->";
+                       }
+                       return fTableName;
+               }
+
+               /**
+                * @param tableName
+                *          The tableName to set.
+                */
+               public void setTableName(String tableName) {
+                       fTableName = tableName;
+               }
+       }
+
+       private char[] fProposalAutoActivationSet;
+
+       protected IContextInformationValidator fValidator = null;// = new
+
+       // Validator();
+
+       private TemplateEngine fTemplateEngine;
+
+       private PHPCompletionProposalComparator fComparator;
+
+       private int fNumberOfComputedResults = 0;
+
+       private IEditorPart fEditor;
+
+       protected IWorkingCopyManager fManager;
+
+       public PHPCompletionProcessor(IEditorPart editor) {
+               fEditor = editor;
+               fManager = PHPeclipsePlugin.getDefault().getWorkingCopyManager();
+               TemplateContextType contextType = PHPeclipsePlugin.getDefault().getTemplateContextRegistry().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.
+        */
+       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
+        */
+       public void setCompletionProposalAutoActivationCharacters(char[] activationSet) {
+               fProposalAutoActivationSet = activationSet;
+       }
+
+       /*
+        * (non-Javadoc) Method declared on IContentAssistProcessor
+        */
+       public ICompletionProposal[] computeCompletionProposals(ITextViewer viewer, int documentOffset) {
+               int contextInformationPosition = guessContextInformationPosition(viewer, documentOffset);
+               return internalComputeCompletionProposals(viewer, documentOffset, contextInformationPosition);
+       }
+
+       private int getLastToken(List list, ITextViewer viewer, int completionPosition, JavaContext context, TableName tableName) {
+               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);
+                               tableName.setTableName(getLastSQLTableName(startText));
+                               Scanner scanner = ToolFactory.createScanner(false, false, false);
+                               scanner.setSource(startText.toCharArray());
+                               scanner.setPHPMode(true);
+                               int beforeLastToken = ITerminalSymbols.TokenNameEOF;
+                               int lastToken = ITerminalSymbols.TokenNameEOF;
+                               char[] ident = null;
+                               try {
+                                       token = scanner.getNextToken();
+                                       lastToken = token;
+                                       while (token != ITerminalSymbols.TokenNameERROR && token != ITerminalSymbols.TokenNameEOF) {
+                                               beforeLastToken = lastToken;
+                                               if (token == ITerminalSymbols.TokenNameVariable) {
+                                                       ident = scanner.getCurrentTokenSource();
+                                                       if (ident.length == 5 && ident[0] == '$' && ident[1] == 't' && ident[2] == 'h' && ident[3] == 'i' && ident[4] == 's') {
+                                                               token = ITerminalSymbols.TokenNamethis_PHP_COMPLETION;
+                                                       }
+                                               }
+                                               lastToken = token;
+                                               // System.out.println(scanner.toStringAction(lastToken));
+                                               token = scanner.getNextToken();
+                                       }
+                               } catch (InvalidInputException e1) {
+                               } catch (SyntaxError e) {
+                               }
+                               switch (lastToken) {
+                               case ITerminalSymbols.TokenNameMINUS_GREATER:
+                                       // dereferencing operator '->' found
+                                       lastSignificantToken = ITerminalSymbols.TokenNameMINUS_GREATER;
+                                       if (beforeLastToken == ITerminalSymbols.TokenNameVariable) {
+                                               lastSignificantToken = ITerminalSymbols.TokenNameVariable;
+                                               list.set(0, ident);
+                                       } else if (beforeLastToken == ITerminalSymbols.TokenNamethis_PHP_COMPLETION) {
+                                               lastSignificantToken = ITerminalSymbols.TokenNamethis_PHP_COMPLETION;
+                                               list.set(0, ident);
+                                       }
+                                       break;
+                               case ITerminalSymbols.TokenNamenew:
+                                       lastSignificantToken = ITerminalSymbols.TokenNamenew;
+                                       break;
+                               }
+                       }
+               } catch (BadLocationException e) {
+               }
+               return lastSignificantToken;
+       }
+
+       String getSQLTableName(String sqlText, int start) {
+               int tableNameStart = -1;
+               int currentCharacterPosition = start + 1;
+               char ch;
+               try {
+                       while (true) {
+                               ch = sqlText.charAt(currentCharacterPosition++);
+                               if (tableNameStart == -1 && Scanner.isPHPIdentifierStart(ch)) {
+                                       tableNameStart = currentCharacterPosition - 1;
+                               } else {
+                                       if (!Scanner.isPHPIdentifierPart(ch)) {
+                                               return sqlText.substring(tableNameStart, currentCharacterPosition - 1);
+                                       }
+                               }
+                       }
+               } catch (IndexOutOfBoundsException e) {
+                       if (tableNameStart >= 0) {
+                               return sqlText.substring(tableNameStart, currentCharacterPosition - 1);
+                       }
+               }
+               return "";
+       }
+
+       private String getLastSQLTableName(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 (Scanner.isSQLIdentifierPart(ch)) {
+                                       // 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() >= 4 && 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 getSQLTableName(startText, identEnd);
+                                                       } else if (ident.equals("into")) {
+                                                               // System.out.println("into");
+                                                               token = ITerminalSymbols.TokenNameSQLinto;
+                                                               return getSQLTableName(startText, identEnd);
+                                                       }
+                                                       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 getSQLTableName(startText, identEnd);
+                                                       }
+                                                       // 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 "<!--no-table-->";
+       }
+
+       /**
+        * 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;
+                                                               // getSQLTableName();
+                                                               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) {
+               ICompilationUnit unit = fManager.getWorkingCopy(fEditor.getEditorInput());
+               IDocument document = viewer.getDocument();
+               IFile file = null;
+               IProject project = null;
+               if (offset > 0) {
+                       PHPEditor editor = null;
+                       if (fEditor != null && (fEditor instanceof PHPEditor)) {
+                               editor = (PHPEditor) fEditor;
+                               file = ((IFileEditorInput) editor.getEditorInput()).getFile();
+                               project = file.getProject();
+                       }
+               }
+
+               Point selection = viewer.getSelectedRange();
+               // remember selected text
+               String selectedText = null;
+               if (selection.y != 0) {
+                       try {
+                               selectedText = document.get(selection.x, selection.y);
+                       } catch (BadLocationException e) {
+                       }
+               }
+
+               if (offset > 2 && fProposalAutoActivationSet != null) {
+                       // restrict auto activation for '>' character to '->' token
+
+                       try {
+                               char ch = document.getChar(offset-1);
+                               if (ch == '>') {
+                                       for (int i = 0; i < fProposalAutoActivationSet.length; i++) {
+                                               ch = fProposalAutoActivationSet[i];
+                                               if (ch == '>') { // auto activation enabled
+                                                       ch = document.getChar(offset - 2);
+                                                       if (ch != '-') {
+                                                               return new IPHPCompletionProposal[0];
+                                                       }
+                                                       break;
+                                               }
+                                       }
+                               }
+                       } catch (BadLocationException e) {
+                               e.printStackTrace();
+                       }
+               }
+
+               JavaContextType phpContextType = (JavaContextType) PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
+                               "php"); //$NON-NLS-1$
+               JavaContext context = (JavaContext) phpContextType.createContext(document, offset, selection.y, unit);
+               context.setVariable("selection", selectedText); //$NON-NLS-1$
+               String prefix = context.getKey();
+
+               HashMap methodVariables = null;
+               // HashMap typeVariables = null;
+               HashMap unitVariables = null;
+               ICompilationUnit compilationUnit = (ICompilationUnit) context.findEnclosingElement(IJavaElement.COMPILATION_UNIT);
+               // if (compilationUnit != null) {
+               // unitVariables = ((CompilationUnit) compilationUnit).variables;
+               // }
+               // IType type = (IType) context.findEnclosingElement(IJavaElement.TYPE);
+               // if (type != null) {
+               // typeVariables = ((SourceType) type).variables;
+               // }
+               IMethod method = (IMethod) context.findEnclosingElement(IJavaElement.METHOD);
+               // if (method != null) {
+               // methodVariables = ((SourceMethod) method).variables;
+               // }
+
+               boolean emptyPrefix = prefix == null || prefix.equals("");
+               IPHPCompletionProposal[] localVariableResults = new IPHPCompletionProposal[0];
+
+               if (!emptyPrefix && prefix.length() >= 1 && prefix.charAt(0) == '$') { // php
+                       // Variable
+                       // ?
+                       String lowerCasePrefix = prefix.toLowerCase();
+                       HashSet localVariables = new HashSet();
+                       if (compilationUnit != null) {
+                               unitVariables = getUnitVariables(unitVariables, compilationUnit);
+                               getVariableProposals(localVariables, viewer, project, context, unitVariables, lowerCasePrefix, 94);
+                       }
+                       if (method != null) {
+                               methodVariables = getMethodVariables(methodVariables, method);
+                               getVariableProposals(localVariables, viewer, project, context, methodVariables, lowerCasePrefix, 99);
+                       }
+                       if (!localVariables.isEmpty()) {
+                               localVariableResults = (IPHPCompletionProposal[]) localVariables.toArray(new IPHPCompletionProposal[localVariables.size()]);
+                       }
+               }
+
+               TableName sqlTable = new TableName();
+               ArrayList list = new ArrayList();
+               list.add(null);
+               int lastSignificantToken = getLastToken(list, viewer, offset, context, sqlTable);
+               boolean useClassMembers = (lastSignificantToken == ITerminalSymbols.TokenNameMINUS_GREATER)
+                               || (lastSignificantToken == ITerminalSymbols.TokenNameVariable) || (lastSignificantToken == ITerminalSymbols.TokenNamenew)
+                               || (lastSignificantToken == ITerminalSymbols.TokenNamethis_PHP_COMPLETION);
+
+               if (fTemplateEngine != null) {
+                       IPHPCompletionProposal[] templateResults = new IPHPCompletionProposal[0];
+                       ICompletionProposal[] results;
+                       if (!emptyPrefix) {
+                               fTemplateEngine.reset();
+                               fTemplateEngine.complete(viewer, offset, unit);
+                               templateResults = fTemplateEngine.getResults();
+                       }
+                       // TODO delete this
+                       IPHPCompletionProposal[] identifierResults = new IPHPCompletionProposal[0];
+
+                       // declarations stored in file project.index on project level
+                       IPHPCompletionProposal[] declarationResults = new IPHPCompletionProposal[0];
+                       if (project != null) {
+                               DeclarationEngine declarationEngine;
+                               JavaContextType contextType = (JavaContextType) PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
+                                               "php"); //$NON-NLS-1$
+                               if (contextType != null) {
+                                       IdentifierIndexManager indexManager = PHPeclipsePlugin.getDefault().getIndexManager(project);
+                                       SortedMap sortedMap;
+                                       declarationEngine = new DeclarationEngine(project, contextType, lastSignificantToken, file);
+                                       if (lastSignificantToken == ITerminalSymbols.TokenNamethis_PHP_COMPLETION) {
+                                               // complete '$this->'
+                                               sortedMap = indexManager.getIdentifiers(file);
+                                               declarationEngine.completeObject(viewer, offset, sortedMap, unit);
+                                       } else {
+                                               String typeRef = null;
+                                               char[] varName = (char[]) list.get(0);
+                                               if (varName != null) {
+                                                       if (method != null) {
+                                                               methodVariables = getMethodVariables(methodVariables, method);
+                                                               VariableInfo info = (VariableInfo) methodVariables.get(new String(varName));
+                                                               if (info != null && info.typeIdentifier != null) {
+                                                                       typeRef = new String(info.typeIdentifier);
+                                                               }
+
+                                                       }
+                                               }
+                                               if (typeRef != null) {
+                                                       // complete '$variable->' with type information
+                                                       sortedMap = indexManager.getIdentifiers(typeRef);
+                                                       declarationEngine.completeObject(viewer, offset, sortedMap, unit);
+                                               } else {
+                                                       // complete '$variable->' without type information
+                                                       sortedMap = indexManager.getIdentifierMap();
+                                                       declarationEngine.complete(viewer, offset, sortedMap, unit);
+                                               }
+                                       }
+                                       declarationResults = declarationEngine.getResults();
+                               }
+                       }
+                       // built in function names from phpsyntax.xml
+                       ArrayList syntaxbuffer = PHPSyntaxRdr.getSyntaxData();
+                       IPHPCompletionProposal[] builtinResults = new IPHPCompletionProposal[0];
+                       if ((!useClassMembers) && syntaxbuffer != null) {
+                               BuiltInEngine builtinEngine;
+                               String proposal;
+                               JavaContextType contextType = (JavaContextType) PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
+                                               "php"); //$NON-NLS-1$
+                               if (contextType != null) {
+                                       builtinEngine = new BuiltInEngine(contextType);
+                                       builtinEngine.complete(viewer, offset, syntaxbuffer, unit);
+                                       builtinResults = builtinEngine.getResults();
+                               }
+                       }
+                       // ICompletionProposal[] sqlResults = new ICompletionProposal[0];
+                       // if (project != null) {
+                       // sqlResults = getSQLProposals(viewer, project, context, prefix,
+                       // sqlTable);
+                       // }
+                       // concatenate the result arrays
+                       IPHPCompletionProposal[] total;
+                       total = new IPHPCompletionProposal[localVariableResults.length + 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(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);
+                       // System.arraycopy(localVariableResults, 0, total, templateResults.length
+                       // + identifierResults.length + builtinResults.length
+                       // + declarationResults.length + sqlResults.length,
+                       // localVariableResults.length);
+                       System.arraycopy(localVariableResults, 0, total, templateResults.length + identifierResults.length + builtinResults.length
+                                       + declarationResults.length, localVariableResults.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.
+                        */
+                       return order(results);
+               }
+               return new IPHPCompletionProposal[0];
+       }
+
+       /**
+        * @param unitVariables
+        * @param unit
+        */
+       private HashMap getUnitVariables(HashMap unitVariables, ICompilationUnit unit) {
+               if (unitVariables == null) {
+                       try {
+                               String unitText = unit.getSource();
+                               unitVariables = new HashMap();
+
+                               ProblemReporter problemReporter = new ProblemReporter(DefaultErrorHandlingPolicies.exitAfterAllProblems(),
+                                               new CompilerOptions(JavaCore.getOptions()), new DefaultProblemFactory());
+                               UnitParser parser = new UnitParser(problemReporter);
+                               parser.compilationUnit = new CompilationUnitDeclaration(problemReporter, null, unitText.length());
+                               parser.parse(unitText, unitVariables);
+
+                       } catch (Exception e) {
+                               // TODO Auto-generated catch block
+                               e.printStackTrace();
+                               PHPeclipsePlugin.log(e);
+                       }
+               }
+               return unitVariables;
+       }
+
+       /**
+        * @param methodVariables
+        * @param method
+        */
+       private HashMap getMethodVariables(HashMap methodVariables, IMethod method) {
+               if (methodVariables == null) {
+                       try {
+                               String methodText = method.getSource();
+                               methodVariables = new HashMap();
+                               ProblemReporter problemReporter = new ProblemReporter(DefaultErrorHandlingPolicies.exitAfterAllProblems(),
+                                               new CompilerOptions(JavaCore.getOptions()), new DefaultProblemFactory());
+                               UnitParser parser = new UnitParser(problemReporter);
+                               parser.compilationUnit = new CompilationUnitDeclaration(problemReporter, null, methodText.length());
+                               parser.parseFunction(methodText, methodVariables);
+                       } catch (Exception e) {
+                               // TODO Auto-generated catch block
+                               e.printStackTrace();
+                               PHPeclipsePlugin.log(e);
+                       }
+               }
+               return methodVariables;
+       }
+
+       /**
+        * @param viewer
+        * @param project
+        * @param context
+        * @param prefix
+        * @return
+        */
+       private void getVariableProposals(HashSet localVariables, ITextViewer viewer, IProject project, JavaContext context,
+                       HashMap variables, String prefix, int relevance) {
+               // try {
+               int start = context.getStart();
+               int end = context.getEnd();
+               IRegion region = new Region(start, end - start);
+               // IMethod method = (IMethod)
+               // context.findEnclosingElement(IJavaElement.METHOD);
+               // if (method != null && (method instanceof SourceMethod) && ((SourceMethod)
+               // method).variables != null) {
+               // HashMap map = ((SourceMethod) method).variables;
+               Set set = variables.keySet();
+               Iterator iter = set.iterator();
+               String varName;
+               boolean matchesVarName;
+               while (iter.hasNext()) {
+                       varName = (String) iter.next();
+                       if (varName.length() >= prefix.length()) {
+                               matchesVarName = true;
+                               for (int i = 0; i < prefix.length(); i++) {
+                                       if (prefix.charAt(i) != Character.toLowerCase(varName.charAt(i))) {
+                                               matchesVarName = false;
+                                               break;
+                                       }
+                               }
+                               if (matchesVarName) {
+                                       LocalVariableProposal prop;
+                                       // if (varName.length == prefix.length()) {
+                                       // prop = new LocalVariableProposal(new String(varName), region,
+                                       // viewer, relevance-10);
+                                       // } else {
+                                       prop = new LocalVariableProposal(new String(varName), region, viewer, relevance);
+                                       // }
+                                       localVariables.add(prop);
+                               }
+                       }
+               }
+               // }
+
+               // char[] varName;
+               // boolean matchesVarName;
+               // if (method != null) {
+               // ISourceRange range = method.getSourceRange();
+               // char[] source = method.getSource().toCharArray();
+               // Scanner scanner = new Scanner();
+               // scanner.setSource(source);
+               // scanner.phpMode = true;
+               // int token = Scanner.TokenNameWHITESPACE;
+               // while ((token = scanner.getNextToken()) != Scanner.TokenNameEOF) {
+               // if (token == Scanner.TokenNameVariable) {
+               // varName = scanner.getCurrentTokenSource();
+               // if (varName.length >= prefix.length()) {
+               // matchesVarName = true;
+               // for (int i = 0; i < prefix.length(); i++) {
+               // if (prefix.charAt(i) != varName[i]) {
+               // matchesVarName = false;
+               // break;
+               // }
+               // }
+               // if (matchesVarName) {
+               // LocalVariableProposal prop = new LocalVariableProposal(new
+               // String(varName), region, viewer);
+               // if (varName.length == prefix.length()) {
+               // prop.setRelevance(98);
+               // }
+               // localVariables.add(prop);
+               // }
+               // }
+               // }
+               // }
+               // }
+               // } catch (Throwable e) {
+               // // ignore - Syntax exceptions could occur, if there are syntax errors !
+               // }
+       }
+
+       /**
+        * @param viewer
+        * @param project
+        * @param context
+        * @param prefix
+        * @param sqlTable
+        * @param sqlResults
+        * @return
+        */
+       // private ICompletionProposal[] getSQLProposals(ITextViewer viewer, IProject
+       // project, DocumentTemplateContext context,
+       // String prefix, TableName sqlTable) {
+       // ICompletionProposal[] sqlResults = new ICompletionProposal[0];
+       // // Get The Database bookmark from the Quantum SQL plugin:
+       // // BookmarkCollection sqlBookMarks = BookmarkCollection.getInstance();
+       // // if (sqlBookMarks != null) {
+       // String bookmarkString =
+       // ProjectPrefUtil.getMiscProjectsPreferenceValue(project,
+       // IPreferenceConstants.PHP_BOOKMARK_DEFAULT);
+       // if (bookmarkString != null && !bookmarkString.equals("")) {
+       // String[] bookmarks = ExternalInterface.getBookmarkNames();
+       // boolean foundBookmark = false;
+       // for (int i = 0; i < bookmarks.length; i++) {
+       // if (bookmarks[i].equals(bookmarkString)) {
+       // foundBookmark = true;
+       // }
+       // }
+       // if (!foundBookmark) {
+       // return sqlResults;
+       // }
+       // // Bookmark bookmark = sqlBookMarks.find(bookmarkString);
+       // ArrayList sqlList = new ArrayList();
+       // if (!ExternalInterface.isBookmarkConnected(bookmarkString)) {
+       // ExternalInterface.connectBookmark(bookmarkString, null);
+       // if (!ExternalInterface.isBookmarkConnected(bookmarkString)) {
+       // return sqlResults;
+       // }
+       // }
+       // // if (ExternalInterface.isBookmarkConnected(bookmarkString)) {
+       // try {
+       // int start = context.getStart();
+       // int end = context.getEnd();
+       // String foundSQLTableName = sqlTable.getTableName();
+       // String tableName;
+       // String columnName;
+       // String prefixWithoutDollar = prefix;
+       // boolean isDollarPrefix = false;
+       // if (prefix.length() > 0 && prefix.charAt(0) == '$') {
+       // prefixWithoutDollar = prefix.substring(1);
+       // isDollarPrefix = true;
+       // }
+       // IRegion region = new Region(start, end - start);
+       // ResultSet set;
+       // if (!isDollarPrefix) {
+       // String[] tableNames = ExternalInterface.getMatchingTableNames(null,
+       // bookmarkString, prefixWithoutDollar, null, false);
+       // for (int i = 0; i < tableNames.length; i++) {
+       // sqlList.add(new SQLProposal(tableNames[i], context, region, viewer,
+       // PHPUiImages.get(PHPUiImages.IMG_TABLE)));
+       // }
+       // }
+       //
+       // String[] columnNames = ExternalInterface.getMatchingColumnNames(null,
+       // bookmarkString, prefixWithoutDollar, null, false);
+       // for (int i = 0; i < columnNames.length; i++) {
+       // sqlList.add(new SQLProposal(columnNames[i], context, region, viewer,
+       // PHPUiImages.get(PHPUiImages.IMG_TABLE)));
+       // }
+       //        
+       // sqlResults = new IPHPCompletionProposal[sqlList.size()];
+       // for (int i = 0; i < sqlList.size(); i++) {
+       // sqlResults[i] = (SQLProposal) sqlList.get(i);
+       // }
+       // } catch (Exception /* NotConnectedException */ e) {
+       //        
+       // }
+       // // }
+       // }
+       // // }
+       // return sqlResults;
+       // }
+       private boolean looksLikeMethod(PHPCodeReader reader) throws IOException {
+               int curr = reader.read();
+               while (curr != PHPCodeReader.EOF && Character.isWhitespace((char) curr))
+                       curr = reader.read();
+
+               if (curr == PHPCodeReader.EOF)
+                       return false;
+
+               return Scanner.isPHPIdentifierPart((char) curr);
+       }
+
+       private int guessContextInformationPosition(ITextViewer viewer, int offset) {
+               int contextPosition = offset;
+               IDocument document = viewer.getDocument();
+               try {
+
+                       PHPCodeReader reader = new PHPCodeReader();
+                       reader.configureBackwardReader(document, offset, true, true);
+
+                       int nestingLevel = 0;
+
+                       int curr = reader.read();
+                       while (curr != PHPCodeReader.EOF) {
+
+                               if (')' == (char) curr)
+                                       ++nestingLevel;
+
+                               else if ('(' == (char) curr) {
+                                       --nestingLevel;
+
+                                       if (nestingLevel < 0) {
+                                               int start = reader.getOffset();
+                                               if (looksLikeMethod(reader))
+                                                       return start + 1;
+                                       }
+                               }
+
+                               curr = reader.read();
+                       }
+               } catch (IOException e) {
+               }
+               return contextPosition;
+       }
+
+       /**
+        * @see IContentAssistProcessor#computeContextInformation(ITextViewer, int)
+        */
+       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()]);
+       }
+
+       private List addContextInformations(ITextViewer viewer, int offset) {
+               ICompletionProposal[] proposals = internalComputeCompletionProposals(viewer, offset, -1);
+               List result = new ArrayList();
+               for (int i = 0; i < proposals.length; i++) {
+                       IContextInformation contextInformation = proposals[i].getContextInformation();
+                       if (contextInformation != null) {
+                               ContextInformationWrapper wrapper = new ContextInformationWrapper(contextInformation);
+                               wrapper.setContextInformationPosition(offset);
+                               result.add(wrapper);
+                       }
+               }
+               return result;
+       }
+
+       /**
+        * Order the given proposals.
+        */
+       private ICompletionProposal[] order(ICompletionProposal[] proposals) {
+               Arrays.sort(proposals, fComparator);
+               // int len = proposals.length;
+               // if (len > 10) {
+               // len = 10;
+               // }
+               // for (int i = 0; i < len; i++) {
+               // System.out.println(proposals[i].getDisplayString());
+               // }
+               return proposals;
+       }
+
+       /*
+        * (non-Javadoc) Method declared on IContentAssistProcessor
+        */
+       public char[] getCompletionProposalAutoActivationCharacters() {
+               return fProposalAutoActivationSet;
+               // return null; // new char[] { '$' };
+       }
+
+       /*
+        * (non-Javadoc) Method declared on IContentAssistProcessor
+        */
+       public char[] getContextInformationAutoActivationCharacters() {
+               return null;
+       }
+
+       /*
+        * (non-Javadoc) Method declared on IContentAssistProcessor
+        */
+       public IContextInformationValidator getContextInformationValidator() {
                if (fValidator == null)
-                       fValidator= new JavaParameterListValidator();
-    return fValidator;
-  }
-
-  /*
-   * (non-Javadoc) Method declared on IContentAssistProcessor
-   */
-  public String getErrorMessage() {
-    return null;
-  }
+                       fValidator = new JavaParameterListValidator();
+               return fValidator;
+       }
+
+       /*
+        * (non-Javadoc) Method declared on IContentAssistProcessor
+        */
+       public String getErrorMessage() {
+               return null;
+       }
 }
\ No newline at end of file