qlabcategorylist.ui.h

/****************************************************************************
** ui.h extension file, included from the uic-generated form implementation.
**
** If you wish to add, delete or rename functions or slots use
** Qt Designer which will update this file, preserving your code. Create an
** init() function in place of a constructor, and a destroy() function in
** place of a destructor.
*****************************************************************************/

static QSqlCursor * curs = new QSqlCursor( "System_categories", TRUE ) ;

void QlabCategoryList::init()
{
        categoryList->setColumnWidthMode( 0, QListView::Manual ) ;
        categoryList->setColumnWidthMode( 1, QListView::Maximum ) ;
        categoryList->setColumnWidth( 0, 100 ) ;
        categoryList->setColumnWidth( 1, 200 ) ;
        categoryList->setColumnWidth( 2, 0 ) ;
        if ( catType.isEmpty() || inInit ) {
                return ;
        }
        inInit = TRUE ;
        QSqlCursor * module = new QSqlCursor( "System_modules", TRUE ) ;
        module->setFilter( QString( "mod_name='%1'" ).arg( catType ) ) ;
        module->select() ;
        if ( module->next() ) {
                activeModule = module->value( "recid" ).toInt() ;
                QSqlCursor * catcursor = new QSqlCursor( "System_categories", TRUE ) ;
                catcursor->setFilter( QString( "cat_appname='%1' AND active='%2'" )
                                                          .arg( activeModule )
                                                          .arg( active ? 1 : 0 ) ) ;
                QStringList idx ;
                idx << "cat_parent" << "recid" ;
                catcursor->index( idx ) ;
                catcursor->select() ;
                QListViewItem * element ;
                categoryList->clear() ;
                element = new QListViewItem( categoryList, tr( "ROOT" ), tr( "Main" ), "0" ) ;
                while ( catcursor->next() ) {
                        element = categoryList->findItem( catcursor->value( "cat_parent").toString(), 2 ) ;
                        element = new QListViewItem( element,
                                                        catcursor->value( "cat_abridged" ).toString(),
                                                        catcursor->value( "cat_name" ).toString(),
                                                        catcursor->value( "recid" ).toString() ) ;
                }
                categoryList->setSelected( categoryList->firstChild(), TRUE ) ;
                categoryList->setOpen( categoryList->selectedItem(), TRUE ) ;
                categoryChanged( categoryList->currentItem() ) ;
        }
        inInit = FALSE ;
}


int QlabCategoryList::currentCategory()
{
        return categoryList->currentItem()->text( 2 ).toInt() ;
}


QString QlabCategoryList::categoryType() const
{
        return catType ;
}


void QlabCategoryList::setCategoryType( const QString & newType )
{
        catType = newType ;
        init() ;
}


void QlabCategoryList::setShowActive( bool act )
{
        active = act ;
        init() ;
        emit categoryViewChanged( active ) ;
}


void QlabCategoryList::refresh()
{
        init() ;
}


QSqlRecord * QlabCategoryList::addSubCategory()
{
        curs->setFilter( QString( "recid='%1'" ).arg( ( categoryList->selectedItem()->text(2) ).toInt() ) ) ;
        curs->select() ;
        curs->next() ;
        int cat_access = curs->value( "cat_access" ).toInt() ;
        QString cat_data = curs->value( "cat_data" ).toString() ;
        curs->setFilter( "" ) ;
        curs->select() ;
        buffer = curs->primeInsert() ;
        buffer->setValue( "recid", 0 ) ;
        buffer->setValue( "cat_appname", activeModule ) ;
        buffer->setValue( "cat_parent", ( categoryList->selectedItem()->text(2) ).toInt() ) ;
        buffer->setValue( "cat_access", cat_access ) ;
        buffer->setValue( "cat_data", cat_data ) ;
        buffer->setValue( "active", active ? 1 : 0 ) ;
        return buffer ;
}


QSqlRecord * QlabCategoryList::editCurrentCategory()
{
        curs->setFilter( QString( "recid='%1'" ).arg( ( categoryList->selectedItem()->text(2) ).toInt() ) ) ;
        curs->select() ;
        curs->next() ;
        buffer = curs->primeUpdate() ;
        return buffer ;
}


bool QlabCategoryList::deleteCurrentCategory()
{
        curs->setFilter( QString( "recid='%1' AND active='1'" )
                                         .arg( categoryList->currentItem()->text( 2 ) ) ) ;
        curs->select() ;
        if ( curs->next() ) {
                buffer = curs->primeUpdate() ;
                buffer->setValue( "active", active ? 0 : 1 ) ;
                curs->update() ;
                QListViewItem * elem = categoryList->selectedItem() ;
                categoryList->setCurrentItem( elem->parent() ) ;
                categoryList->ensureItemVisible( elem->parent() ) ;
                delete elem ;
        } else {
                refresh() ;
        }
        curs->setFilter( "" ) ;
        return TRUE ;
}


bool QlabCategoryList::validateChanges()
{
        buffer->setValue( "lastchanged", QDateTime::currentDateTime() ) ;
        buffer->setValue( "lastchangedID", LabUser->value( "recid" ).toInt() ) ;
        if ( buffer->value( "recid" ).toInt() == 0 ) {
                // Must insert
                buffer->setValue( "recid", SequenceGetNextValue( "System_categories" ) ) ;
                buffer->setValue( "created", QDateTime::currentDateTime() ) ;
                buffer->setValue( "lastchangedreason", "Creation" ) ;
                return ( curs->insert() == 1 ) ;
        } else {
                return ( curs->update() == 1 ) ;
        }
}


void QlabCategoryList::reparent( int source, int newParent )
{
        curs->setFilter( QString( "recid='%1'" ).arg( source ) ) ;
        curs->select() ;
        curs->next() ;
        QSqlRecord * buffer = curs->primeUpdate() ;
        buffer->setValue( "cat_parent", newParent ) ;
        curs->update() ;

        init() ;
        QListViewItem * element = categoryList->findItem( QString( "%1").arg( source ), 2 ) ;
        categoryList->setSelected( element, TRUE ) ;
        categoryList->setOpen( categoryList->selectedItem(), TRUE ) ;
        emit categoryRemapped( source ) ;
        curs->setFilter( "" ) ;
}


void QlabCategoryList::categoryChanged( QListViewItem * item )
{
        emit selectionChanged( item->text( 2 ).toInt() ) ;
}



bool QlabCategoryList::showActive() const
{
        return active ;
}