// ****************************************************************************
// copyright (c) 2000-2005 Horst Knorr <hk_classes@knoda.org>
// This file is part of the hk_kdeclasses library.
// This file may be distributed and/or modified under the terms of the
// GNU Library Public License version 2 as published by the Free Software
// Foundation and appearing in the file LGPL included in the
// packaging of this file.
// This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE
// WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
// ****************************************************************************
// $Revision: 1.37 $

#include "hk_kdegridcolumndialog.h"

#include "hk_kdegrid.h"
#include "hk_kdeinterpreterdialog.h"
#include <hk_datasource.h>
#include <hk_class.h>
#include <hk_database.h>
#include <hk_presentation.h>
#include <qlineedit.h>
#include <qlistbox.h>
#include <qlistview.h>
#include <qtabwidget.h>
#include <qtoolbutton.h>
#include <qlabel.h>
#include <qimage.h>
#include <qpixmap.h>
#include <qscrollview.h>
#include <kglobal.h>
#include <kiconloader.h>
#include <klocale.h>
#include <qcombobox.h>
#include <qspinbox.h>

/*
 *  Constructs a hk_kdegridcolumndialog which is a child of 'parent', with the
 *  name 'name' and widget flags set to 'f'
 *
 *  The dialog will by default be modeless, unless you set 'modal' to
 *  TRUE to construct a modal dialog.
 */
hk_kdegridcolumndialog::hk_kdegridcolumndialog( hk_kdegrid* parent,  const char* name, bool modal, WFlags fl )
: hk_kdegridcolumndialogbase( parent, name, modal, fl )
{
    QString no=i18n("no");
    QString yes=i18n("yes");
    KIconLoader* loader=KGlobal::iconLoader();
    loader->addAppDir("hk_kdeclasses");
    p_grid=parent;
    leftlabel->setText(i18n("Invisible columns:"));
    rightlabel->setText(i18n("Shown columns:"));
    rightbox->addColumn( i18n( "Column" ) );
//    rightbox->addColumn( i18n( "Default value" ).c_str() );
    rightbox->addColumn( i18n( "Columntype" ) );
    rightbox->setSorting(-1);
    setCaption(i18n("Column select"));
    addbutton->setPixmap( loader->loadIcon("1rightarrow",KIcon::Desktop   ) );
    deletebutton->setPixmap( loader->loadIcon("1leftarrow",KIcon::Desktop   ) );
    settxt=i18n("set");
    notsettxt=i18n("not set");

    columntypefield->insertItem(i18n("edit"));
    columntypefield->insertItem(i18n("bool"));
    columntypefield->insertItem(i18n("combo"));
    listdatasourcetypefield->insertItem(i18n("table"));
    listdatasourcetypefield->insertItem(i18n("query"));
    listdatasourcetypefield->insertItem(i18n("view"));
    alignmentfield->insertItem(i18n("Left"));
    alignmentfield->insertItem(i18n("Center"));
    alignmentfield->insertItem(i18n("Right"));
    separatorfield->insertItem(yes);
    separatorfield->insertItem(no);
    readonlyfield->insertItem(yes);
    readonlyfield->insertItem(no);
    readonlylabel->setText(i18n("Read only:"));
    separatorlabel->setText(i18n("Separator:"));
    displaylabel->setText(i18n("Displayname:"));
    columntypelabel->setText(i18n("Columntype:"));
    digitlabel->setText(i18n("Digits:"));
    definitionlabel->setText(i18n("Columndefinition:"));
    listdatasourcetypelabel->setText(i18n("Listdatasourcetype:"));
    TabWidget->changeTab(formattab,i18n("&Format"));
    TabWidget->changeTab(combotab,i18n("&Combobox"));
    actiontab->setEnabled(p_grid->presentation()!=NULL);
    connect( columntypefield, SIGNAL( activated(int) ), this, SLOT( columntype_changed() ) );
    p_currentfieldit=fields.end();
    if (p_grid && p_grid->presentationdatasource()==-1) listdatasourcetype_changed();
    else   load_presentationdatasources();
    set_columnvalues();
    rightbox->setFocus();
    rightbox->setCurrentItem(0);
    rightbox->setSelected(rightbox->currentItem(),true);
    rightbox_selectionchanged(   rightbox->selectedItem());


    TabWidget->removePage(actiontab);

    p_actionscrollview=new QScrollView(TabWidget);
    TabWidget->insertTab(p_actionscrollview,"");
    actiontab->reparent(p_actionscrollview->viewport(),QPoint(0,0));
    p_actionscrollview->addChild(actiontab);
    TabWidget->changeTab(p_actionscrollview,i18n("&Action"));

    QSize s=actiontab->geometry().size();
    if (formattab->width()>s.width())s.setWidth(formattab->width());
    if (combotab->width()>s.width())s.setWidth(combotab->width());

    if (formattab->height()>s.height())s.setHeight(formattab->height());
    if (combotab->height()>s.height())s.setHeight(combotab->height());

    actiontab->setMinimumSize(s);
    /*tab_3->setMinimumSize(s);
    tab_4->setMinimumSize(s);*/

}


/*
 *  Destroys the object and frees any allocated resources
 */
hk_kdegridcolumndialog::~hk_kdegridcolumndialog()
{
// no need to delete child widgets, Qt does it all for us
}


/*
 * public slot
 */
void hk_kdegridcolumndialog::addbutton_clicked()
{
    if (leftbox->currentText().isEmpty())return;

    fieldstruct f;
    f.name=u2l(leftbox->currentText().utf8().data());
    fields.insert(fields.end(),f);
    rightbox->setSelected(rightbox->lastItem(),true);
    QListViewItem* feld=new QListViewItem(rightbox,rightbox->lastItem(),leftbox->currentText(),i18n("edit"));
    leftbox->removeItem(leftbox->currentItem());
    listentries_changed();
    rightbox->setSelected(feld,true);
}


/*
 * public slot
 */
void hk_kdegridcolumndialog::deletebutton_clicked()
{
    if (rightbox->currentItem()==NULL)return;

    QListViewItem* f=rightbox->currentItem();

//QListViewItem* p=NULL;
    if (f==NULL||p_currentfieldit==fields.end())  return;
    f->itemBelow();

    if (p_currentfieldit!=fields.end())
    {
        fields.erase(p_currentfieldit);
        p_currentfieldit=fields.end();
    };                                            //else cout <<"p_currentfieldit==end"<<endl;

    leftbox->insertItem(rightbox->currentItem()->text(0),leftbox->currentItem()+1);
//    rightbox->removeItem(rightbox->currentItem());
    QListViewItem* nextitem =rightbox->currentItem()->nextSibling();
    delete rightbox->currentItem();
    listentries_changed();

    if (!nextitem)  nextitem=rightbox->lastItem();

    rightbox->setCurrentItem(nextitem);
    rightbox->setSelected(nextitem,true);

}


/*
 * public slot
 */
void hk_kdegridcolumndialog::exitbutton_clicked()
{
    close();
}


/*
 * public slot
 */
void hk_kdegridcolumndialog::okbutton_clicked()
{
    list<hk_string> p_l;
    list<fieldstruct>::iterator it=fields.begin();
    while (it!=fields.end())
    {
        p_l.insert(p_l.end(),(*it).name);
        it++;
    }

    p_grid->set_gridcolumns(p_l);

    it=fields.begin();
    unsigned int k=0;
    while (it!=fields.end())
    {
        hk_dsgridcolumn* gc=p_grid->gridcolumn(k);
        if (gc!=NULL)
        {
//	    if((*it).defaultvalue.size()==0) gc->reset_default();
//	    else
            gc->set_defaultvalue((*it).defaultvalue);
            gc->set_columntype((*it).columntype);
            gc->set_alignment((*it).alignment);
            gc->set_numberformat((*it).use_separators,(*it).digits);
            gc->set_displayname((*it).displayname);
            gc->set_readonly((*it).readonly);

	    gc->set_on_click_action((*it).p_clickaction,true,true);
	    gc->set_on_doubleclick_action((*it).p_doubleclickaction,true,true);
	    gc->set_on_open_action((*it).p_onopenaction,true,true);
	    gc->set_on_close_action((*it).p_oncloseaction,true,true);
	    gc->set_before_row_change_action((*it).p_before_row_change_action,true,true);
	    gc->set_after_row_change_action((*it).p_after_row_change_action,true,true);
	    gc->set_before_delete_action((*it).p_before_delete_action,true,true);
	    gc->set_after_delete_action((*it).p_after_delete_action,true,true);
	    gc->set_before_update_action((*it).p_before_update_action,true,true);
	    gc->set_after_update_action((*it).p_after_update_action,true,true);
	    gc->set_before_insert_action((*it).p_before_insert_action,true,true);
	    gc->set_after_insert_action((*it).p_after_insert_action,true,true);
	    gc->set_on_getfocus_action((*it).p_on_getfocus_action,true,true);
	    gc->set_on_loosefocus_action((*it).p_on_loosefocus_action,true,true);
	    gc->set_on_key_action((*it).p_on_key_action,true,true);
	    gc->set_on_select_action((*it).p_on_select_action,true,true);

            if ((*it).columntype==hk_dsgridcolumn::columncombo)
            {
                if (p_grid->presentation())
                {                                 //cout <<"ds: "<<(*it).listdatasource<<endl;
                    hk_datasource* ds=p_grid->presentation()->get_datasource((*it).listdatasource);
                    if (ds) gc->set_listpresentationdatasource(ds->presentationnumber());
//else cout <<"listpresentationds == NULL!"<<endl;
                }

                gc->set_listdatasource((*it).listdatasource,(*it).listdatasourcetype);
                gc->set_listcolumnname((*it).listcolumn);
                gc->set_viewcolumnname((*it).viewcolumn);
            }
        }
        it++;k++;

    }

    accept();
}


void hk_kdegridcolumndialog::listentries_changed(void)
{
    addbutton->setEnabled(leftbox->count()>0);
    deletebutton->setEnabled(rightbox->childCount()>0);
    storebutton->setEnabled(rightbox->childCount()>0);
    bool b=(columntypefield->currentItem()==2);
    combotab->setEnabled(b);
    onselectactionbutton->setEnabled(b);
    listdatasourcetypefield->setEnabled((p_grid->presentationdatasource()==-1));
set_buttontext();
}


void hk_kdegridcolumndialog::set_columnvalues()
{
    if (p_grid==NULL) return;

    leftbox->clear();
    rightbox->clear();
    fields.erase(fields.begin(),fields.end());
    p_currentfieldit=fields.end();
    list<hk_string>* p_visiblelist =p_grid->visible_columns();
    list<hk_string>::iterator it=p_visiblelist->begin();
    int i=0;
    QString def,type;
    while (it!=p_visiblelist->end())
    {
        fieldstruct f;
        hk_dsgridcolumn* gc=p_grid->gridcolumn(i);
        if (gc==NULL) def="";
        else def=QString::fromUtf8 (l2u(gc->raw_defaultvalue()).c_str());

        switch (gc->columntype())
        {
            case hk_dsgridcolumn::columnbool : type =i18n("bool");
            break;
            case hk_dsgridcolumn::columncombo : type =i18n("combo");
            break;
            default : type =i18n("edit");
            break;

        }
        f.name=gc->columnname();
        f.defaultvalue=gc->raw_defaultvalue();
        f.alignment=gc->alignment();
        f.use_separators=gc->use_numberseparator();
        f.displayname=gc->displayname();
        f.readonly=gc->is_readonly();
        f.digits=gc->commadigits();
        f.listdatasourcetype=gc->listdatasourcetype();
        f.listdatasource=gc->listdatasourcename();
        f.listcolumn=gc->listcolumnname();
        f.viewcolumn=gc->viewcolumnname();
        f.columntype=gc->columntype();
	f.p_clickaction=gc->on_click_action();
	f.p_doubleclickaction=gc->on_doubleclick_action();
	f.p_onopenaction=gc->on_open_action();
	f.p_oncloseaction=gc->on_close_action();
	f.p_before_row_change_action=gc->before_row_change_action();
	f.p_after_row_change_action=gc->after_row_change_action();
	f.p_before_delete_action=gc->before_delete_action();
	f.p_after_delete_action=gc->after_delete_action();
	f.p_before_update_action=gc->before_update_action();
	f.p_after_update_action=gc->after_update_action();
	f.p_before_insert_action=gc->before_insert_action();
	f.p_after_insert_action=gc->after_insert_action();
	f.p_on_getfocus_action=gc->on_getfocus_action();
	f.p_on_loosefocus_action=gc->on_loosefocus_action();
	f.p_on_key_action=gc->on_key_action();
	f.p_on_select_action=gc->on_select_action();



	fields.insert(fields.end(),f);








        QListViewItem* feld=NULL;
        feld=new QListViewItem(rightbox,rightbox->lastItem(),QString::fromUtf8 (l2u((*it)).c_str()),type);
// rightbox->insertItem((*it).c_str());
        it++;i++;
    }

    list<hk_string>* p_nonvisiblelist =p_grid->nonvisible_columns();
    it=p_nonvisiblelist->begin();

    while (it!=p_nonvisiblelist->end())
    {
        leftbox->insertItem(QString::fromUtf8 (l2u((*it)).c_str()));
        it++;
    }

    listentries_changed();

}


void hk_kdegridcolumndialog::defaultvalue_changed()
{

    if (p_currentfieldit!=fields.end())
        (*p_currentfieldit).defaultvalue=u2l(defaultfield->text().utf8().data());

}


void hk_kdegridcolumndialog::columntype_changed()
{
    hk_dsgridcolumn::enum_columntype t=hk_dsgridcolumn::columnedit;
    switch (columntypefield->currentItem())
    {
        case 0 : t=hk_dsgridcolumn::columnedit;break;
        case 1 : t=hk_dsgridcolumn::columnbool;break;
        case 2 : t=hk_dsgridcolumn::columncombo;break;
        default : t=hk_dsgridcolumn::columnedit;
    }
    if (p_currentfieldit!=fields.end())
        (*p_currentfieldit).columntype=t;
    else cout <<"Warnung: p_currentfieldit==.end"<<endl;

    combotab->setEnabled(t==2);
    onselectactionbutton->setEnabled(t==2);

    rightbox->currentItem()->setText(1,columntypefield->currentText());
    listentries_changed();
}


void hk_kdegridcolumndialog::rightbox_selectionchanged(QListViewItem* i)
{

//      QListViewItem* i=rightbox->currentItem();
    if (i==NULL)return;

    list<fieldstruct>::iterator it=fields.begin();
    bool found=false;
    hk_string nn=u2l(i->text(0).utf8().data());
    while (it!=fields.end()&&!found)
    {
        if ((*it).name==nn)
        {
            p_currentfieldit=it;
            found=true;
        }
        it++;
    }
    if (p_currentfieldit==fields.end()) return;
    defaultfield->blockSignals(true);
    defaultfield->setText( QString::fromUtf8 (l2u((*p_currentfieldit).defaultvalue).c_str()));
    defaultfield->blockSignals(false);

    displayfield->blockSignals(true);
    displayfield->setText( QString::fromUtf8 (l2u((*p_currentfieldit).displayname).c_str()));
    displayfield->blockSignals(false);

    readonlyfield->blockSignals(true);
    readonlyfield->setCurrentItem( ((*p_currentfieldit).readonly?0:1));
    readonlyfield->blockSignals(false);

    columntypefield->blockSignals(true);
    int p=0;
    switch ((*p_currentfieldit).columntype)
    {
        case hk_dsgridcolumn::columnbool :p=1;break;
        case hk_dsgridcolumn::columncombo :p=2;break;
        default : p=0;
    }
    combotab->setEnabled(p==2);

    columntypefield->setCurrentItem(p);
    columntypefield->blockSignals(false);
    alignmentfield->blockSignals(true);
    p=0;
    switch ((*p_currentfieldit).alignment)
    {
        case hk_dsdatavisible::aligncenter :p=1;break;
        case hk_dsdatavisible::alignright :p=2;break;
        default : p=0;
    }

    alignmentfield->setCurrentItem(p);
    alignmentfield->blockSignals(false);

    separatorfield->blockSignals(true);
    separatorfield->setCurrentItem((*p_currentfieldit).use_separators?0:1);
    separatorfield->blockSignals(false);

    digitfield->blockSignals(true);
    digitfield->setValue((*p_currentfieldit).digits);
    digitfield->blockSignals(false);

    if (p_grid->presentationdatasource()==-1)
    {
        listdatasourcetypefield->blockSignals(true);
	int i=0;
	 switch ((*p_currentfieldit).listdatasourcetype)
	 {
	   case dt_query: i=1;break;
	   case dt_view: i=2;break;
	   default: i=0;
	 }
        listdatasourcetypefield->setCurrentItem(i);
        listdatasourcetypefield->blockSignals(false);
        listdatasourcetype_changed();
    }
    reload_listdatasource();
    set_currentlistdatasource();

    listcolumnfield->blockSignals(true);
    listcolumnfield->setCurrentText(QString::fromUtf8 (l2u((*p_currentfieldit).listcolumn).c_str()));
    listcolumnfield->blockSignals(false);

    viewcolumnfield->blockSignals(true);
    viewcolumnfield->setCurrentText(QString::fromUtf8 (l2u((*p_currentfieldit).viewcolumn).c_str()));
    viewcolumnfield->blockSignals(false);

    listentries_changed();
set_buttontext();

}


void hk_kdegridcolumndialog::alignment_changed()
{
    hk_dsdatavisible::alignmenttype a;
    switch (alignmentfield->currentItem())
    {
        case 1 :a=hk_dsdatavisible::aligncenter;
        break;
        case 2 : a=hk_dsdatavisible::alignright;
        break;
        default : a=hk_dsdatavisible::alignleft;
    }
    if (p_currentfieldit!=fields.end())
        (*p_currentfieldit).alignment=a;
}


void hk_kdegridcolumndialog::displayname_changed()
{
    if (p_currentfieldit!=fields.end())
        (*p_currentfieldit).displayname=u2l(displayfield->text().utf8().data());

}


void hk_kdegridcolumndialog::digits_changed()
{
    if (p_currentfieldit!=fields.end())
        (*p_currentfieldit).digits=digitfield->value();

}


void hk_kdegridcolumndialog::separator_changed()
{
    if (p_currentfieldit!=fields.end())
        (*p_currentfieldit).use_separators=(separatorfield->currentItem()==0);

}


void hk_kdegridcolumndialog::readonly_changed()
{
    if (p_currentfieldit!=fields.end())
        (*p_currentfieldit).readonly=(readonlyfield->currentItem()==0);

}


void hk_kdegridcolumndialog::listdatasource_changed()
{
    QString f=listdatasourcefield->currentText();
    if (f.isEmpty()) f="";
    if (p_currentfieldit!=fields.end())
    {
        (*p_currentfieldit).listdatasource=u2l(f.utf8().data());
//cout <<"(*p_currentfieldit).listdatasource gesetzt " <<(*p_currentfieldit).listdatasource<<endl;
    }
    reload_listdatasource();

}


void hk_kdegridcolumndialog::reload_listdatasource(void)
{

    listcolumnfield->blockSignals(true);
    listcolumnfield->clear();
    listcolumnfield->blockSignals(false);
    viewcolumnfield->blockSignals(true);
    viewcolumnfield->clear();
    viewcolumnfield->blockSignals(false);
    if (!p_grid) return;
    if (!p_grid->datasource())return;
    hk_datasource* ds= NULL;
    if ( !p_grid->presentation())
    {
//no presentation
//      cout <<"no presentation"<<endl;
        hk_database* db=p_grid->datasource()->database();
        if (db==NULL) return;
        QString f=listdatasourcefield->text(listdatasourcefield->currentItem());
        if (f.isEmpty()) f="";
        if (p_grid->presentation())p_grid->presentation()->get_datasource(u2l(f.utf8().data()));
        else
        {
	    datasourcetype dt=dt_table;
	     switch (listdatasourcetypefield->currentItem())
	     {
	       case 1: dt =dt_query;break;
	       case 2: dt =dt_view;break;
	       default: dt=dt_table;
	     }
            ds=db->load_datasource(u2l(f.utf8().data()),dt);
        }
        if (ds==NULL) return;
    }
    else
    {                                             // a presenation

    }

    list<hk_column*>* v=NULL;
    if (p_grid->presentation()&&p_currentfieldit!=fields.end())
    {
        ds=p_grid->presentation()->get_datasource((*p_currentfieldit).listdatasource);

//cout <<"ds: "<<ds <<" dsname: "<< (*p_currentfieldit).listdatasource<<endl;
    }
    hk_string tempfilter;
    bool usetempfilter=false;
    if(ds)
    {
        if (ds->type()!=hk_datasource::ds_table)
        {
            tempfilter=ds->temporaryfilter();
            usetempfilter=ds->use_temporaryfilter();
            ds->set_temporaryfilter("0=1");

            ds->set_use_temporaryfilter(true);
            ds->enable();
        }
        v=ds->columns();
    }
    if (v==NULL)
    {
        if (ds&& ds->type()!=hk_datasource::ds_table)
        {
            ds->disable();
            ds->set_temporaryfilter(tempfilter);
            ds->set_use_temporaryfilter(usetempfilter);
        }

        return;
    }
    listcolumnfield->blockSignals(true);
    viewcolumnfield->blockSignals(true);
    listcolumnfield->insertItem("");
    viewcolumnfield->insertItem("");
    list<hk_column*>::iterator it=v->begin();
    while (it!=v->end())
    {
        listcolumnfield->insertItem(QString::fromUtf8 (l2u((*it)->name()).c_str()));
        viewcolumnfield->insertItem(QString::fromUtf8 (l2u((*it)->name()).c_str()));
        it++;
    }
    listcolumnfield->blockSignals(false);
    viewcolumnfield->blockSignals(false);

    if (ds && ds->type()!=hk_datasource::ds_table)
    {
        ds->disable();
        ds->set_temporaryfilter(tempfilter);
        ds->set_use_temporaryfilter(usetempfilter);
    }

}


void hk_kdegridcolumndialog::listdatasourcetype_changed()
{
    if (!p_grid->datasource())return;
    hk_database* db=p_grid->datasource()->database();
    if (db==NULL) return;
    vector<hk_string>* v=NULL;
    switch (listdatasourcetypefield->currentItem())
    {
      case 1 : v=db->querylist();break;
      case 2 : v=db->viewlist();break;
      default: v=db->tablelist();
    }
    if (p_currentfieldit!=fields.end())
    {
        datasourcetype dt;
	switch (listdatasourcetypefield->currentItem())
	{
	  case 1: dt=dt_query;break;
	  case 2: dt=dt_view;break;
	  default: dt=dt_table;
	}
	(*p_currentfieldit).listdatasourcetype=dt;
    }
    listdatasourcefield->blockSignals(true);
    listdatasourcefield->clear();
    vector<hk_string>::iterator it=v->begin();
    int p=0;
    while (it!=v->end())
    {
        listdatasourcefield->insertItem(QString::fromUtf8 (l2u((*it)).c_str()));
    if (p_currentfieldit!=fields.end())
        if ((*p_currentfieldit).listdatasource==(*it))listdatasourcefield->setCurrentItem(p);
        it++;++p;
    }
    //listdatasourcefield->setCurrentItem(0);
    listdatasourcefield->blockSignals(false);
//   listdatasource_changed();
    reload_listdatasource();
    listdatasource_changed();
}


void hk_kdegridcolumndialog::set_currentlistdatasource(void)
{
    int current=0;
    int counter=0;
    int c= listdatasourcefield->count();
    while (counter<c)
    {
        if (p_currentfieldit!=fields.end())
        {
            if ( listdatasourcefield->text(counter)== QString::fromUtf8 (l2u((*p_currentfieldit).listdatasource).c_str()))
                current=counter;
        }                                         //else cout <<"p_currentfieldit!=fields.end()"<<endl;
        counter++;
    }
    listdatasourcefield->blockSignals(true);
    listdatasourcefield->setCurrentItem(current);
    listdatasourcefield->blockSignals(false);

}


void hk_kdegridcolumndialog::viewcolumn_changed()
{
    if (p_currentfieldit!=fields.end())
    {
        (*p_currentfieldit).viewcolumn=u2l(viewcolumnfield->currentText().utf8().data());
//cout <<"viewcolumn_changed auf  "<<(*p_currentfieldit).viewcolumn<<endl;
    }
}


void hk_kdegridcolumndialog::listcolumn_changed()
{
    if (p_currentfieldit!=fields.end())
    {
        (*p_currentfieldit).listcolumn=u2l(listcolumnfield->currentText().utf8().data());
//cout <<"listcolumn_changed auf  "<<(*p_currentfieldit).listcolumn<<endl;
    }
}


void hk_kdegridcolumndialog::load_presentationdatasources(void)
{

//load datasources from hk_presentation
//cout <<"mit presentation"<<endl;
    listdatasourcefield->blockSignals(true);
    listdatasourcefield->clear();
    listdatasourcefield->blockSignals(false);

    list<hk_datasource*>* dslist = p_grid->presentation()->datasources();
    if (dslist==NULL)   return;
    list<hk_datasource*>::iterator it=dslist->begin();
    while (it!=dslist->end())
    {
        QString name= QString::fromUtf8 (l2u(p_grid->presentation()->unique_datasourcename((*it)->presentationnumber())).c_str());
        listdatasourcefield->insertItem(name);
        it++;
    }

}



void hk_kdegridcolumndialog::onclickaction_clicked()
{
    if (p_currentfieldit==fields.end()) return;

    hk_string warning;
    int rownumber=0;

    hk_kdeinterpreterdialog* d = new hk_kdeinterpreterdialog(0,0,Qt::WShowModal);
    d->set_code((*p_currentfieldit).p_clickaction,false);
    d->set_caption(NULL,"on_click_action");
    int r=d->exec(rownumber,warning);
    if (r==hk_kdeinterpreterdialog::Accepted&&d->has_changed())
    {
      (*p_currentfieldit).p_clickaction=d->code();
    }

    delete d;
set_buttontext();


}

void hk_kdegridcolumndialog::ondoubleclickaction_clicked()
{
    if (p_currentfieldit==fields.end()) return;

    hk_string warning;
    int rownumber=0;

    hk_kdeinterpreterdialog* d = new hk_kdeinterpreterdialog(0,0,Qt::WShowModal);
    d->set_code((*p_currentfieldit).p_doubleclickaction,false);
    d->set_caption(NULL,"ondoubleclick_action");
    int r=d->exec(rownumber,warning);
    if (r==hk_kdeinterpreterdialog::Accepted&&d->has_changed())
    {
      (*p_currentfieldit).p_doubleclickaction=d->code();
    }

    delete d;
set_buttontext();


}

void hk_kdegridcolumndialog::onopenaction_clicked()
{
    if (p_currentfieldit==fields.end()) return;

    hk_string warning;
    int rownumber=0;

    hk_kdeinterpreterdialog* d = new hk_kdeinterpreterdialog(0,0,Qt::WShowModal);
    d->set_code((*p_currentfieldit).p_onopenaction,false);
    d->set_caption(NULL,"on_open_action");
    int r=d->exec(rownumber,warning);
    if (r==hk_kdeinterpreterdialog::Accepted&&d->has_changed())
    {
      (*p_currentfieldit).p_onopenaction=d->code();
    }

    delete d;

set_buttontext();

}

void hk_kdegridcolumndialog::oncloseaction_clicked()
{
    if (p_currentfieldit==fields.end()) return;

    hk_string warning;
    int rownumber=0;

    hk_kdeinterpreterdialog* d = new hk_kdeinterpreterdialog(0,0,Qt::WShowModal);
    d->set_code((*p_currentfieldit).p_oncloseaction,false);
    d->set_caption(NULL,"on_close_action");
    int r=d->exec(rownumber,warning);
    if (r==hk_kdeinterpreterdialog::Accepted&&d->has_changed())
    {
      (*p_currentfieldit).p_oncloseaction=d->code();
    }

    delete d;
set_buttontext();


}

void hk_kdegridcolumndialog::beforeupdateaction_clicked()
{
    if (p_currentfieldit==fields.end()) return;

    hk_string warning;
    int rownumber=0;

    hk_kdeinterpreterdialog* d = new hk_kdeinterpreterdialog(0,0,Qt::WShowModal);
    d->set_code((*p_currentfieldit).p_before_update_action,false);
    d->set_caption(NULL,"before_update_action");
    int r=d->exec(rownumber,warning);
    if (r==hk_kdeinterpreterdialog::Accepted&&d->has_changed())
    {
      (*p_currentfieldit).p_before_update_action=d->code();
    }

    delete d;
set_buttontext();

}

void hk_kdegridcolumndialog::afterupdateaction_clicked()
{
    if (p_currentfieldit==fields.end()) return;

    hk_string warning;
    int rownumber=0;

    hk_kdeinterpreterdialog* d = new hk_kdeinterpreterdialog(0,0,Qt::WShowModal);
    d->set_code((*p_currentfieldit).p_after_update_action,false);
    d->set_caption(NULL,"after_update_action");
    int r=d->exec(rownumber,warning);
    if (r==hk_kdeinterpreterdialog::Accepted&&d->has_changed())
    {
      (*p_currentfieldit).p_after_update_action=d->code();
    }

    delete d;
set_buttontext();


}

void hk_kdegridcolumndialog::beforerowchangeaction_changed()
{
    if (p_currentfieldit==fields.end()) return;

    hk_string warning;
    int rownumber=0;

    hk_kdeinterpreterdialog* d = new hk_kdeinterpreterdialog(0,0,Qt::WShowModal);
    d->set_code((*p_currentfieldit).p_before_row_change_action,false);
    d->set_caption(NULL,"before_row_change_action");
    int r=d->exec(rownumber,warning);
    if (r==hk_kdeinterpreterdialog::Accepted&&d->has_changed())
    {
      (*p_currentfieldit).p_before_row_change_action=d->code();
    }

    delete d;
set_buttontext();


}

void hk_kdegridcolumndialog::afterrowchangeaction_changed()
{
    if (p_currentfieldit==fields.end()) return;

    hk_string warning;
    int rownumber=0;

    hk_kdeinterpreterdialog* d = new hk_kdeinterpreterdialog(0,0,Qt::WShowModal);
    d->set_code((*p_currentfieldit).p_after_row_change_action,false);
    d->set_caption(NULL,"before_after_row_change_action");
    int r=d->exec(rownumber,warning);
    if (r==hk_kdeinterpreterdialog::Accepted&&d->has_changed())
    {
      (*p_currentfieldit).p_after_row_change_action=d->code();
    }

    delete d;
set_buttontext();


}

void hk_kdegridcolumndialog::beforedeleteaction_clicked()
{
    if (p_currentfieldit==fields.end()) return;

    hk_string warning;
    int rownumber=0;

    hk_kdeinterpreterdialog* d = new hk_kdeinterpreterdialog(0,0,Qt::WShowModal);
    d->set_code((*p_currentfieldit).p_before_delete_action,false);
    d->set_caption(NULL,"before_delete_action");
    int r=d->exec(rownumber,warning);
    if (r==hk_kdeinterpreterdialog::Accepted&&d->has_changed())
    {
      (*p_currentfieldit).p_before_delete_action=d->code();
    }

    delete d;
set_buttontext();


}

void hk_kdegridcolumndialog::afterdeleteaction_clicked()
{
    if (p_currentfieldit==fields.end()) return;

    hk_string warning;
    int rownumber=0;

    hk_kdeinterpreterdialog* d = new hk_kdeinterpreterdialog(0,0,Qt::WShowModal);
    d->set_code((*p_currentfieldit).p_after_delete_action,false);
    d->set_caption(NULL,"after_delete_action");
    int r=d->exec(rownumber,warning);
    if (r==hk_kdeinterpreterdialog::Accepted&&d->has_changed())
    {
      (*p_currentfieldit).p_after_delete_action=d->code();
    }

    delete d;
set_buttontext();


}

void hk_kdegridcolumndialog::beforeinsertaction_clicked()
{
    if (p_currentfieldit==fields.end()) return;

    hk_string warning;
    int rownumber=0;

    hk_kdeinterpreterdialog* d = new hk_kdeinterpreterdialog(0,0,Qt::WShowModal);
    d->set_code((*p_currentfieldit).p_before_insert_action,false);
    d->set_caption(NULL,"before_insert_action");
    int r=d->exec(rownumber,warning);
    if (r==hk_kdeinterpreterdialog::Accepted&&d->has_changed())
    {
      (*p_currentfieldit).p_before_insert_action=d->code();
    }

    delete d;
set_buttontext();


}

void hk_kdegridcolumndialog::afterinsertaction_clicked()
{
    if (p_currentfieldit==fields.end()) return;

    hk_string warning;
    int rownumber=0;

    hk_kdeinterpreterdialog* d = new hk_kdeinterpreterdialog(0,0,Qt::WShowModal);
    d->set_code((*p_currentfieldit).p_after_insert_action,false);
    d->set_caption(NULL,"after_insert_action");
    int r=d->exec(rownumber,warning);
    if (r==hk_kdeinterpreterdialog::Accepted&&d->has_changed())
    {
      (*p_currentfieldit).p_after_insert_action=d->code();
    }

    delete d;
set_buttontext();


}







void hk_kdegridcolumndialog::on_getfocusaction_clicked()
{
    if (p_currentfieldit==fields.end()) return;

    hk_string warning;
    int rownumber=0;

    hk_kdeinterpreterdialog* d = new hk_kdeinterpreterdialog(0,0,Qt::WShowModal);
    d->set_code((*p_currentfieldit).p_on_getfocus_action,false);
    d->set_caption(NULL,"on_getfocus_action");
    int r=d->exec(rownumber,warning);
    if (r==hk_kdeinterpreterdialog::Accepted&&d->has_changed())
    {
      (*p_currentfieldit).p_on_getfocus_action=d->code();
    }

    delete d;
set_buttontext();


}

void hk_kdegridcolumndialog::on_loosefocusaction_clicked()
{
    if (p_currentfieldit==fields.end()) return;

    hk_string warning;
    int rownumber=0;

    hk_kdeinterpreterdialog* d = new hk_kdeinterpreterdialog(0,0,Qt::WShowModal);
    d->set_code((*p_currentfieldit).p_on_loosefocus_action,false);
    d->set_caption(NULL,"on_loosefocus_action");
    int r=d->exec(rownumber,warning);
    if (r==hk_kdeinterpreterdialog::Accepted&&d->has_changed())
    {
      (*p_currentfieldit).p_on_loosefocus_action=d->code();
    }

    delete d;
set_buttontext();


}

void hk_kdegridcolumndialog::onkeybutton_clicked()
{
    if (p_currentfieldit==fields.end()) return;

    hk_string warning;
    int rownumber=0;

    hk_kdeinterpreterdialog* d = new hk_kdeinterpreterdialog(0,0,Qt::WShowModal);
    d->set_code((*p_currentfieldit).p_on_key_action,false);
    d->set_caption(NULL,"on_key_action");
    int r=d->exec(rownumber,warning);
    if (r==hk_kdeinterpreterdialog::Accepted&&d->has_changed())
    {
      (*p_currentfieldit).p_on_key_action=d->code();
    }

    delete d;
set_buttontext();


}


void hk_kdegridcolumndialog::onselectaction_clicked()
{
    if (p_currentfieldit==fields.end()) return;

    hk_string warning;
    int rownumber=0;

    hk_kdeinterpreterdialog* d = new hk_kdeinterpreterdialog(0,0,Qt::WShowModal);
    d->set_code((*p_currentfieldit).p_on_select_action,false);
    d->set_caption(NULL,"on_select_action");
    int r=d->exec(rownumber,warning);
    if (r==hk_kdeinterpreterdialog::Accepted&&d->has_changed())
    {
      (*p_currentfieldit).p_on_select_action=d->code();
    }

    delete d;
set_buttontext();


}








void hk_kdegridcolumndialog::set_buttontext(void)
{
    if (p_currentfieldit==fields.end()) return;
    onpushactionbutton->setText((*p_currentfieldit).p_clickaction.size()>0?settxt:notsettxt);
    ondoubleclickactionbutton->setText((*p_currentfieldit).p_doubleclickaction.size()>0?settxt:notsettxt);
    onopenactionbutton->setText((*p_currentfieldit).p_onopenaction.size()>0?settxt:notsettxt);
    oncloseactionbutton->setText((*p_currentfieldit).p_oncloseaction.size()>0?settxt:notsettxt);
    beforerowchangeactionbutton->setText((*p_currentfieldit).p_before_row_change_action.size()>0?settxt:notsettxt);
    afterrowchangeactionbutton->setText((*p_currentfieldit).p_after_row_change_action.size()>0?settxt:notsettxt);
    beforeupdateactionbutton->setText((*p_currentfieldit).p_before_update_action.size()>0?settxt:notsettxt);
    afterupdateactionbutton->setText((*p_currentfieldit).p_after_update_action.size()>0?settxt:notsettxt);
    beforedeleteactionbutton->setText((*p_currentfieldit).p_before_delete_action.size()>0?settxt:notsettxt);
    afterdeleteactionbutton->setText((*p_currentfieldit).p_after_delete_action.size()>0?settxt:notsettxt);
    beforeinsertactionbutton->setText((*p_currentfieldit).p_before_insert_action.size()>0?settxt:notsettxt);
    afterinsertactionbutton->setText((*p_currentfieldit).p_after_insert_action.size()>0?settxt:notsettxt);
    onselectactionbutton->setText((*p_currentfieldit).p_on_select_action.size()>0?settxt:notsettxt);

    ongetfocusbutton->setText((*p_currentfieldit).p_on_getfocus_action.size()>0?settxt:notsettxt);
    onloosefocusbutton->setText((*p_currentfieldit).p_on_loosefocus_action.size()>0?settxt:notsettxt);
    onkeybutton->setText((*p_currentfieldit).p_on_key_action.size()>0?settxt:notsettxt);
}