/*****
*
* TOra - An Oracle Toolkit for DBA's and developers
* Copyright (C) 2003-2005 Quest Software, Inc
* Portions Copyright (C) 2005 Other Contributors
* 
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License
* as published by the Free Software Foundation;  only version 2 of
* the License is valid for this program.
* 
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
* GNU General Public License for more details.
* 
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
*
*      As a special exception, you have permission to link this program
*      with the Oracle Client libraries and distribute executables, as long
*      as you follow the requirements of the GNU GPL in regard to all of the
*      software in the executable aside from Oracle client libraries.
*
*      Specifically you are not permitted to link this program with the
*      Qt/UNIX, Qt/Windows or Qt Non Commercial products of TrollTech.
*      And you are not permitted to distribute binaries compiled against
*      these libraries without written consent from Quest Software, Inc.
*      Observe that this does not disallow linking to the Qt Free Edition.
*
*      You may link this product with any GPL'd Qt library such as Qt/Free
*
* All trademarks belong to their respective owners.
*
*****/

#include "utils.h"

#include "tochangeconnection.h"
#include "toconf.h"
#include "toconnection.h"
#include "toextract.h"
#include "tohighlightedtext.h"
#include "toinvalid.h"
#include "tomain.h"
#include "toresultextract.h"
#include "toresultlong.h"
#include "toresultview.h"
#include "tosql.h"
#include "totool.h"


#ifdef TO_KDE
#  include <kmenubar.h>
#endif

#include <qlabel.h>
#include <qlineedit.h>
#include <qmenubar.h>
#include <qpopupmenu.h>
#include <qprogressdialog.h>
#include <qsplitter.h>
#include <qtoolbar.h>
#include <qtoolbutton.h>
#include <qworkspace.h>

#include "toinvalid.moc"

#include "icons/refresh.xpm"
#include "icons/toinvalid.xpm"
#include "icons/compile.xpm"

static toSQL SQLListInvalid("toInvalid:ListInvalid",
                            "SELECT owner \"Owner\",object_name \"Object\",object_type \"Type\",status \"Status\"\n"
                            "  FROM sys.all_objects\n"
                            " WHERE status <> 'VALID'",
                            "Get invalid objects, must have same first three columns.");

static toSQL SQLListSource("toInvalid:ListSource",
                           "SELECT Text FROM SYS.ALL_SOURCE\n"
                           " WHERE Owner = :f1<char[101]> AND Name = :f2<char[101]> AND type = :f3<char[101]>",
                           "List source of an object.");

static toSQL SQLReadErrors("toInvalid:ReadErrors",
                           "SELECT Line-1,Text FROM sys.All_Errors\n"
                           " WHERE OWNER = :f1<char[101]>\n"
                           "   AND NAME = :f2<char[101]>\n"
                           "   AND TYPE = :f3<char[101]>",
                           " ORDER BY Type,Line",
                           "Get lines with errors in object (Observe first line 0)");

class toInvalidTool : public toTool
{
    virtual const char **pictureXPM(void)
    {
        return const_cast<const char**>(toinvalid_xpm);
    }
public:
    toInvalidTool()
            : toTool(130, "Invalid Objects")
    { }
    virtual const char *menuItem()
    {
        return "Invalid Objects";
    }
    virtual QWidget *toolWindow(QWidget *parent, toConnection &connection)
    {
        return new toInvalid(parent, connection);
    }
};

static toInvalidTool InvalidTool;

toInvalid::toInvalid(QWidget *main, toConnection &connection)
        : toToolWidget(InvalidTool, "invalid.html", main, connection)
{
    QToolBar *toolbar = toAllocBar(this, tr("Invalid Objects"));

    new QToolButton(QPixmap(const_cast<const char**>(refresh_xpm)),
                    tr("Refresh list"),
                    tr("Refresh list"),
                    this, SLOT(refresh()),
                    toolbar);

    new QToolButton(QPixmap(const_cast<const char**>(compile_xpm)),
                    tr("Recompile all invalid"),
                    tr("Recompile all invalid"),
                    this, SLOT(recompileSelected()),
                    toolbar);

    toolbar->setStretchableWidget(new QLabel(toolbar, TO_KDE_TOOLBAR_WIDGET));
    new toChangeConnection(toolbar, TO_KDE_TOOLBAR_WIDGET);

    QSplitter *splitter = new QSplitter(Horizontal, this);

    Objects = new toResultLong(false, false, toQuery::Background, splitter);
    Objects->setSQL(SQLListInvalid);

    Objects->setSelectionMode(QListView::Single);
    connect(Objects, SIGNAL(selectionChanged()), this, SLOT(changeSelection()));

    Source = new toResultExtract(false, splitter);
    Source->setSQL(SQLListSource);

    connect(Source, SIGNAL(executed()), this, SLOT(refresh()));

#if 0

    {
        QValueList<int> sizes = splitter->sizes();
        sizes[0] = 300;
        splitter->setSizes(sizes);
        splitter->setResizeMode(Objects, QSplitter::KeepSize);
    }
#endif

    ToolMenu = NULL;
    connect(toMainWidget()->workspace(), SIGNAL(windowActivated(QWidget *)),
            this, SLOT(windowActivated(QWidget *)));

    refresh();
    setFocusProxy(Objects);
}

void toInvalid::recompileSelected(void)
{
    QProgressDialog progress(tr("Recompiling all invalid"),
                             tr("Cancel"), Objects->childCount(), this, "progress", true);
    progress.setCaption("Recompiling");
    progress.show();


    for (QListViewItem *item = Objects->firstChild();item;item = item->nextSibling())
    {
        toResultViewItem * ci = dynamic_cast<toResultViewItem *>(item);
        if (ci)
        {
            toConnection &conn = connection();
            progress.setLabelText("Recompiling " + ci->allText(1) + "." + ci->allText(2));
            progress.setProgress(progress.progress() + 1);
            qApp->processEvents();
            if (progress.wasCancelled())
                break;
            QString type = ci->allText(2);
            QString sql;
            if (type == "INDEX")
                sql = "ALTER " + ci->allText(2) + " " + conn.quote(ci->allText(0)) + "." + conn.quote(ci->allText(1)) + " REBUILD";
            else if (type == "PACKAGE BODY")
                sql = "ALTER PACKAGE " + conn.quote(ci->allText(0)) + "." + conn.quote(ci->allText(1)) + " COMPILE BODY";
            else
                sql = "ALTER " + ci->allText(2) + " " + conn.quote(ci->allText(0)) + "." + conn.quote(ci->allText(1)) + " COMPILE";
            try
            {
                conn.execute(sql);
            }
            catch (...)
            {}
        }
    }
    if (progress.isVisible())
        progress.close();
    qApp->processEvents();
    this->refresh();
}

void toInvalid::windowActivated(QWidget *widget)
{
    if (widget == this)
    {
        if (!ToolMenu)
        {
            ToolMenu = new QPopupMenu(this);
            ToolMenu->insertItem(QPixmap(const_cast<const char**>(refresh_xpm)), tr("&Refresh"),
                                 this, SLOT(refresh(void)),
                                 toKeySequence(tr("F5", "Invalid|Refresh")));

            toMainWidget()->menuBar()->insertItem(tr("&Invalid"), ToolMenu, -1, toToolMenuIndex());
        }
    }
    else
    {
        delete ToolMenu;
        ToolMenu = NULL;
    }
}

void toInvalid::refresh(void)
{
    QListViewItem *item = Objects->selectedItem();
    QString owner;
    QString object;
    QString type;
    if (item)
    {
        owner = item->text(0);
        object = item->text(1);
        type = item->text(2);
    }
    Objects->refresh();
    if (item)
    {
        for (item = Objects->firstChild();item;item = item->nextSibling())
        {
            if (item->text(0) == owner && item->text(1) == object && item->text(2) == type)
            {
                Objects->setSelected(item, true);
                break;
            }
        }
        changeSelection();
    }
}

void toInvalid::changeSelection(void)
{
    try
    {
        QListViewItem *item = Objects->selectedItem();
        if (item)
        {
            Source->changeParams(item->text(0), item->text(1), item->text(2));
            std::map<int, QString> Errors;

            toQuery errors(connection(), SQLReadErrors, item->text(0), item->text(1), item->text(2));
            while (!errors.eof())
            {
                int line = errors.readValue().toInt();
                Errors[line] += QString::fromLatin1(" ");
                Errors[line] += errors.readValue();
            }
            Source->editor()->setErrors(Errors);
        }
    }
    TOCATCH
}