quicksearcher.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.
*****************************************************************************/

void QuickSearcher::init()
{
    prods = new QSqlCursor( "Inv_products", TRUE ) ;
    parts = new QSqlCursor( "Inv_parts", TRUE ) ;
    prodsTable->setLeftMargin( 0 ) ;
    prodsTable->setColumnStretchable( 1, TRUE ) ;
    prodsTable->setColumnWidth( 1, 200 ) ;
    partsTable->setLeftMargin( 0 ) ;
    prodsTable->setColumnStretchable( 0, TRUE ) ;
    prodsTable->setFilter( "recid='-1'" ) ;
    prodsTable->refresh( QDataTable::RefreshAll ) ;
    partsTable->setFilter( "recid='-1'" ) ;
    partsTable->refresh( QDataTable::RefreshAll ) ;
    clearSelection() ;
}

void QuickSearcher::requiredChanged( const QString & want )
{
    QString req = want.stripWhiteSpace() ;
    if ( req.isEmpty() ) {
        prodsTable->setFilter( "recid='-1'" ) ;
        prodsTable->refresh() ;
        partsTable->setFilter( "recid='-1'" ) ;
        partsTable->refresh() ;
        clearSelection() ;
    } else {
        req = req.upper() ;
        prodsTable->setFilter( QString( "prod_ref LIKE '%1%' OR prod_name LIKE '%%2%'" ).arg( req ).arg( req ) ) ;
        qDebug( prodsTable->filter() ) ;
        prodsTable->refresh() ;
        if ( prodsTable->numRows() > 0 ) {
            prodsTable->ensureCellVisible( 0, 0 ) ;
            prodsTable->selectRow( 0 ) ;
            okButton->setEnabled( TRUE ) ;          
        } else {
            partsTable->setFilter( "recid='-1'" ) ;
            partsTable->refresh() ;
            clearSelection() ;
        }
    }
}


void QuickSearcher::findParts( QSqlRecord * buffer )
{
    currSel->setText( buffer->value( "prod_name" ).toString() ) ;
    partsTable->setFilter( QString( "prodid='%1'" ).arg( buffer->value( "recid" ).toString() ) ) ;
    partsTable->refresh() ;
    if ( partsTable->numRows() > 0 ) {
        partsTable->ensureCellVisible( 0, 0 ) ;
        partsTable->selectRow( 0 ) ;
        okButton->setEnabled( TRUE ) ;
    } else {
        clearSelection() ;
    }
}


void QuickSearcher::showSelected( QSqlRecord * buffer )
{
    currBarcode->setText( buffer->value( "serial" ).toString() ) ;
    currRetail->setText( partsTable->text( partsTable->currentRow(), 1 ) ) ;
}


void QuickSearcher::selectedOK( int row, int col )
{
    partsTable->selectRow( row ) ;
    accept() ;
}


void QuickSearcher::clearSelection()
{
    currSel->setText( "" ) ;
    currBarcode->setText( "" ) ;
    currRetail->setText( "" ) ;
    okButton->setEnabled( FALSE ) ;
}


void QuickSearcher::okClicked()
{
    selectedOK( partsTable->currentRow(), 0 ) ;
}