pressmanager.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 PressManager::init()
{
    prods = new QSqlCursor( "Inv_products", TRUE ) ;
    parts = new QSqlCursor( "Inv_parts", TRUE ) ;
    tmpx = new QSqlCursor( "Inv_pressio", TRUE ) ;
    readtxt->setText( "" ) ;
    historyTable->setLeftMargin( 0 ) ;
    historyTable->setColumnStretchable( 1, TRUE ) ;
    historyTable->setColumnWidth( 0, 150 ) ;
    historyTable->setColumnWidth( 1, 400 ) ;
    historyTable->setColumnWidth( 2, 100 ) ;
    historyTable->setColumnWidth( 3, 100 ) ;
    historyTable->setColumnWidth( 4, 0 ) ;
    historyTable->setColumnWidth( 5, 0 ) ;
    historyTable->refresh( QDataTable::RefreshAll ) ;
}

void PressManager::setMode( int mode )
{
    md = mode ;
    switch ( mode ) {
    case 0 : activeMode->setText( tr( "Receive" ) ) ; break ;
    case 1 : activeMode->setText( tr( "Return" ) ) ; break ;
    default : break ;
}
}


void PressManager::validateChanges()
{
    QString action = QObject::sender()->name() ;
    if ( action == "closeButton" ) {
        bool receive = FALSE ; 
        int qx = 0 ;
        switch ( md ) {
        case 0 : // Receive
            receive = TRUE ;
            break ;
        case 1 : // Return
            receive = FALSE;
            break ;
        }
        tmpx->setFilter( "" ) ;
        tmpx->select() ;
        while ( tmpx->next() ) {
            parts->setFilter( QString( "recid='%1'" ).arg( tmpx->value( "partid" ).toString() ) ) ;
            parts->select() ;
            parts->next() ;
            QSqlRecord * buffer = parts->primeUpdate() ;
            qx = buffer->value( "stock" ).toInt() ;
            if ( receive ) {
                qx += tmpx->value( "qty" ).toInt() ;
            } else {
                qx -= tmpx->value( "qty" ).toInt() ;        
            }
            buffer->setValue( "retail", tmpx->value( "price" ).toString() ) ;
            buffer->setValue( "stock", qx ) ;
            parts->update() ;
        }
        QSqlQuery q( "TRUNCATE TABLE Inv_pressio" ) ;
        accept() ;
    } else {
        QSqlQuery q( "TRUNCATE TABLE Inv_pressio" ) ;
        reject() ;
    }
}

void PressManager::findItem()
{
    QString want = reader->text().upper() ;
    readtxt->setText( want ) ;
    if ( want.left( 3 ) == "378" && want.length() >= 8 ) {
        // Found barcode
        QString serial = want.left( 8 ) ;
        // Do we have this ?
        if ( !getTmp( want ) && !getPart( want ) ) {
            // Must Create product & part...
        }
        title->setText( tmpx->value( "title" ).toString() ) ;
        qty->setValue( tmpx->value( "qty").toInt() ) ;
        retailShown->setText( tmpx->value( "price" ).toString() ) ;
    } else {
        // Should be a product ref.
        if ( !getProd( want ) ) {
        }
    }
    reader->setText( "" ) ;
}


void PressManager::mapQty( int newq )
{
    QSqlRecord * buffer = tmpx->primeUpdate() ;
    int recid = buffer->value( "recid" ).toInt() ;
    buffer->setValue( "qty", newq ) ;
    tmpx->update() ;
    tmpx->setFilter( QString( "recid='%1'" ).arg( recid ) );
    tmpx->select() ;
    tmpx->next() ;
    historyTable->refresh() ;
}


bool PressManager::getPart( const QString & want )
{
    parts->setFilter( QString( "serial LIKE '%1%'" ).arg( want.left( 8 ) ) ) ;
    parts->select() ;
    qDebug( parts->lastQuery() ) ;
    if ( parts->next() ) {
        qDebug( "Part Found..."  ) ;
        qDebug( QString( "%1, %2" ).arg( parts->value( "recid" ).toString() ).arg( parts->value( "serial" ).toString() ) ) ;
        // This part exists
        prods->setFilter( QString( "recid='%1'" ).arg( parts->value( "prodid" ).toString() ) ) ;
        prods->select() ;
        if( !prods->next() ) {
            qDebug( QString( "Product recid: %1 does not exist!" ).arg( parts->value( "recid" ).toString() ) ) ;
            QSqlRecord *dr = parts->primeDelete() ;
            parts->del() ;
            return getPart( want ) ;
        } else {
            QString retail = want.mid( 8, 4 ).insert( 2, "." ) ;
            retailShown->setText( retail ) ;
            QSqlRecord * buffer = tmpx->primeInsert() ;
            buffer->setValue( "serial", want ) ;
            buffer->setValue( "partid", parts->value( "recid" ).toInt() ) ;
            buffer->setValue( "reference", prods->value( "prod_ref" ).toString() ) ;
            buffer->setValue( "title", prods->value( "prod_name" ).toString() ) ;
            buffer->setValue( "price", retail ) ;
            buffer->setValue( "qty", 1 ) ;
            qDebug( buffer->value( "title" ).toString() ) ;
            tmpx->insert() ;
            historyTable->refresh() ;
            return getTmp( want ) ;
        }
    }
    return FALSE ;
}



bool PressManager::getTmp( const QString & want )
{
    for ( int i = 0; i < historyTable->numRows(); i++ ) {
        if ( historyTable->text( i, 5 ) == want ) {
            historyTable->setCurrentCell( i, 0 ) ;
            historyTable->selectRow( i ) ;
        }
    }
    return FALSE ;
}


bool PressManager::getProd( const QString & prod )
{
    prods->setFilter( QString( "prod_ref='%1'" ).arg( prod ) ) ;
    prods->select() ;
    if ( !prods->next() ) {
        return FALSE ;
    }
    parts->setFilter( QString( "prodid='%1'" ).arg( prods->value( "recid" ).toString() ) ) ;
    parts->select() ;
    if ( !parts->next() ) {
        return FALSE ;
    }
    reader->setText( parts->value( "serial" ).toString() ) ;
    findItem() ;
    return TRUE ;
}


void PressManager::recallOne( QSqlRecord * buffer )
{
    QString pri = buffer->value( "price" ).toString() ;
    pri = pri.replace( ".", "" ).rightJustify( 4, '0' ) ;
    reader->setText( QString( "%1%2" )
                     .arg( buffer->value( "serial" ).toString() )
                     .arg( pri ) ) ;
    findItem() ;
}


void PressManager::editItem()
{

}