/***********************************************************************************************************************************
 * 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: www.phpeclipse.de
 **********************************************************************************************************************************/
package net.sourceforge.phpeclipse.actions;

import java.sql.SQLException;

import net.sourceforge.phpeclipse.phpeditor.PHPEditor;
import net.sourceforge.phpeclipse.ui.WebUI;
import net.sourceforge.phpeclipse.ui.overlaypages.ProjectPrefUtil;

import org.eclipse.core.resources.IContainer;
import org.eclipse.core.resources.IFile;
import org.eclipse.core.resources.IProject;
import org.eclipse.core.runtime.Path;
import org.eclipse.jface.action.IAction;
import org.eclipse.jface.text.BadLocationException;
import org.eclipse.jface.text.IDocument;
import org.eclipse.jface.text.ITextSelection;
import org.eclipse.jface.text.TextSelection;
import org.eclipse.jface.viewers.ISelection;
import org.eclipse.swt.graphics.Point;
import org.eclipse.ui.IEditorActionDelegate;
import org.eclipse.ui.IEditorPart;
import org.eclipse.ui.IFileEditorInput;
import org.eclipse.ui.IViewPart;
import org.eclipse.ui.IWorkbenchPage;
import org.eclipse.ui.IWorkbenchWindow;
import org.eclipse.ui.PartInitException;
import org.eclipse.ui.actions.ActionDelegate;

import com.quantum.ExternalInterface;
import com.quantum.QuantumPlugin;
import com.quantum.util.connection.NotConnectedException;

public class PHPOpenSQLTableEditorAction extends ActionDelegate implements IEditorActionDelegate {

  private IWorkbenchWindow fWindow;

  private PHPEditor fEditor;

  private IProject fProject;

  public void dispose() {
  }

  public void init(IWorkbenchWindow window) {
    this.fWindow = window;
  }

  public void selectionChanged(IAction action, ISelection selection) {
    if (!selection.isEmpty()) {
      if (selection instanceof TextSelection) {
        action.setEnabled(true);
      } else if (fWindow.getActivePage() != null && fWindow.getActivePage().getActivePart() != null) {
        //
      }
    }
  }

  private IWorkbenchPage getActivePage() {
    fWindow = fEditor.getEditorSite().getWorkbenchWindow();
    IWorkbenchPage page = fWindow.getActivePage();
    return page;
  }

  public IContainer getWorkingLocation(IFileEditorInput editorInput) {
    if (editorInput == null || editorInput.getFile() == null) {
      return null;
    }
    return editorInput.getFile().getParent();
  }

  private IFile getIncludeFile(IProject project, IFileEditorInput editorInput, String relativeFilename) {
    //		IContainer container = getWorkingLocation(editorInput);
    //		String fullPath = project.getLocation().toString();
    Path path = new Path(relativeFilename);
    IFile file = project.getFile(path);
    return file;
  }

  public void run(IAction action) {
    if (fEditor == null) {
      IEditorPart targetEditor = fWindow.getActivePage().getActiveEditor();
      if (targetEditor != null && (targetEditor instanceof PHPEditor)) {
        fEditor = (PHPEditor) targetEditor;
      }
    }
    if (fEditor != null) {
      fWindow = fEditor.getEditorSite().getWorkbenchWindow();
      IFile f = ((IFileEditorInput) fEditor.getEditorInput()).getFile();
      fProject = f.getProject();
      String bookmarkString = ProjectPrefUtil.getMiscProjectsPreferenceValue(fProject, WebUI.PHP_BOOKMARK_DEFAULT);
      if (bookmarkString != null && !bookmarkString.equals("")) {
        ITextSelection selection = (ITextSelection) fEditor.getSelectionProvider().getSelection();
        IDocument doc = fEditor.getDocumentProvider().getDocument(fEditor.getEditorInput());
        int pos = selection.getOffset();
        //  System.out.println(selection.getText());
        String tableName = getSQLTableName(doc, pos);
        if (tableName != null && tableName.length() > 0)
          try {
            ExternalInterface.displayTable(bookmarkString, tableName);
            
            IViewPart viewPart = null;
            String view = "com.quantum.view.tableview.TableView";
            try {
              IWorkbenchPage page = QuantumPlugin.getDefault().getActivePage();
              viewPart = page.findView(view);
              if (viewPart == null) {
                viewPart = page.showView(view);
              }
              page.bringToTop(viewPart);
            } catch (PartInitException e) {
              e.printStackTrace();
            }
          } catch (NotConnectedException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
          } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
          }
      }

      //
      //      IViewPart viewPart = null;
      //      String view = "com.quantum.view.tableview.TableView";
      //      try {
      //        IWorkbenchPage page = QuantumPlugin.getDefault().getActivePage();
      //        viewPart = page.findView(view);
      //        if (viewPart == null) {
      //          viewPart = page.showView(view);
      //        }
      //        page.bringToTop(viewPart);
      //        getTables((TableView) viewPart, fProject, tableName);
      //      } catch (PartInitException e) {
      //        e.printStackTrace();
      //      }

    }
  }

  public void setActiveEditor(IAction action, IEditorPart targetEditor) {
    if (targetEditor != null && (targetEditor instanceof PHPEditor)) {
      fEditor = (PHPEditor) targetEditor;
    }
  }

  private String getSQLTableName(IDocument doc, int pos) {
    Point word = null;
    int start = -1;
    int end = -1;

    try {

      int position = pos;
      char character;

      while (position >= 0) {
        character = doc.getChar(position);
        if (Character.isWhitespace(character) || (character == '\"') || (character == '\'') || (character == '\r')
            || (character == '\n'))
          break;
        --position;
      }

      start = position;

      position = pos;
      int length = doc.getLength();

      while (position < length) {
        character = doc.getChar(position);
        if (Character.isWhitespace(character) || (character == '\"') || (character == '\'') || (character == '\r')
            || (character == '\n'))
          break;
        ++position;
      }

      start++;
      end = position;

      if (end > start)
        word = new Point(start, end - start);

    } catch (BadLocationException x) {
    }

    if (word != null) {
      try {
        return doc.get(word.x, word.y);
      } catch (BadLocationException e) {
      }
    }
    return "";
  }

  //  public void getTables(TableView tableView, IProject project, String tableName) {
  //    // Get The Database bookmark from the Quantum SQL plugin:
  //    BookmarkCollection sqlBookMarks = BookmarkCollection.getInstance();
  //    if (sqlBookMarks != null) {
  //      String bookmarkString = ProjectPrefUtil.getMiscProjectsPreferenceValue(project,
  //          WebUI.PHP_BOOKMARK_DEFAULT);
  //      if (bookmarkString != null && !bookmarkString.equals("")) {
  //        Bookmark bookmark = sqlBookMarks.find(bookmarkString);
  //        ArrayList sqlList = 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();
  //            ConnectionUtil connectionUtil = new ConnectionUtil();
  //            Entity entity;
  //            DatabaseAdapter adapter;
  //
  //            if (metaData != null) {
  //              String columnName;
  //              String prefixWithoutDollar = tableName;
  //              if (prefixWithoutDollar.charAt(0) == '$') {
  //                prefixWithoutDollar = prefixWithoutDollar.substring(1);
  //              }
  //              ResultSet set;
  //              set = metaData.getTables(null, null, "%" + prefixWithoutDollar
  //                  + "%", null);
  //              while (set.next()) {
  //                tableName = set.getString("TABLE_NAME");
  //                tableName = (tableName == null) ? "" : tableName.trim();
  //                if (tableName != null && tableName.length() > 0) {
  //                  sqlList.add(tableName);
  //                }
  //              }
  //              set.close();
  //              EntityFactory entityFactory = EntityFactory.getInstance();
  //              if (sqlList.size() == 1) {
  //                adapter = bookmark.getAdapter();
  //                entity = entityFactory.create(bookmark, null, (String) sqlList
  //                    .get(0), Entity.TABLE_TYPE, false);
  //                String query = adapter.getTableQuery(entity.getQualifiedName());
  //
  //                try {
  //                  SQLResults results = MultiSQLServer.getInstance().execute(
  //                      bookmark, connectionUtil.connect(bookmark, fWindow.getShell()),
  //                      entity, query);
  //
  //                  if (results != null && results.isResultSet()) {
  //                    SQLResultSetCollection.getInstance().addSQLResultSet(
  //                        (SQLResultSetResults) results);
  //                  }
  //                } catch (SQLException e) {
  //                  ExceptionDisplayDialog.openError(fWindow.getShell(), null, null, e);
  //                }
  //                // tableView.loadTable(entityFactory.create(
  //                // bookmark, null,
  //                // (String) sqlList.get(0),
  //                // Entity.TABLE_TYPE));
  //              } else if (sqlList.size() > 1) {
  //                ListSelectionDialog listSelectionDialog = new ListSelectionDialog(
  //                    PHPeclipsePlugin.getDefault().getWorkbench()
  //                        .getActiveWorkbenchWindow().getShell(), sqlList,
  //                    new ListContentProvider(), new LabelProvider(),
  //                    "Select the SQL table to open.");
  //                listSelectionDialog.setTitle("Multiple tablenames found");
  //                if (listSelectionDialog.open() == Window.OK) {
  //                  Object[] locations = listSelectionDialog.getResult();
  //                  if (locations != null) {
  //                    for (int i = 0; i < locations.length; i++) {
  //                      adapter = bookmark.getAdapter();
  //                      entity = entityFactory.create(bookmark, null,
  //                          (String) locations[i], Entity.TABLE_TYPE, false);
  //                      String query = adapter.getTableQuery(entity
  //                          .getQualifiedName());
  //
  //                      try {
  //                        SQLResults results = MultiSQLServer.getInstance()
  //                            .execute(bookmark,
  //                                connectionUtil.connect(bookmark, fWindow.getShell()),
  //                                entity, query);
  //
  //                        if (results != null && results.isResultSet()) {
  //                          SQLResultSetCollection.getInstance().addSQLResultSet(
  //                              (SQLResultSetResults) results);
  //                        }
  //                      } catch (SQLException e) {
  //                        ExceptionDisplayDialog.openError(fWindow.getShell(), null, null, e);
  //                      }
  //
  //                      // tableView
  //                      // .loadTable(entityFactory
  //                      // .create(
  //                      // bookmark,
  //                      // null,
  //                      // (String) locations[i],
  //                      // Entity.TABLE_TYPE));
  //                    }
  //
  //                  }
  //                }
  //              }
  //            }
  //          } catch (NotConnectedException e) {
  //            // ignore this - not mission critical
  //          } catch (SQLException e) {
  //            e.printStackTrace();
  //          }
  //        }
  //      }
  //    }
  //  }

}