labphysicalinventory.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 LabPhysicalInventory::init()
{
    productsTable->setLeftMargin( 0 ) ;
    productsTable->setFilter( "recid='-1'" ) ;
    productsTable->setColumnStretchable( 0, TRUE ) ;
    productsTable->setColumnStretchable( 1, TRUE ) ;
    productsTable->setColumnStretchable( 2, TRUE ) ;
    productsTable->setColumnStretchable( 3, TRUE ) ;
    productsTable->setColumnWidth( 0, 150 ) ;
    productsTable->setColumnWidth( 1, 350 ) ;
    productsTable->setColumnWidth( 2, 150 ) ;
    productsTable->setColumnWidth( 3, 150 ) ;
    productsTable->refresh( QDataTable::RefreshAll ) ;
    partsTable->setLeftMargin( 0 ) ;
    partsTable->setFilter( "recid='-1'" ) ;   
    partsTable->setColumnStretchable( 0, TRUE ) ;
    partsTable->setColumnStretchable( 1, TRUE ) ;
    partsTable->setColumnStretchable( 2, TRUE ) ;
    partsTable->setColumnStretchable( 3, TRUE ) ;
    partsTable->setColumnStretchable( 4, TRUE ) ;
    partsTable->setColumnStretchable( 5, TRUE ) ;
    partsTable->setColumnWidth( 0, 150 ) ;
    partsTable->setColumnWidth( 1, 70 ) ;
    partsTable->setColumnWidth( 2, 150 ) ;
    partsTable->setColumnWidth( 3, 150 ) ;
    partsTable->setColumnWidth( 4, 150 ) ;
    partsTable->setColumnWidth( 5, 100 ) ;
    
    partsTable->refresh( QDataTable::RefreshAll ) ;
}

void LabPhysicalInventory::showHelp()
{
   
}


void LabPhysicalInventory::findProduct()
{
    QString want = refBarcodeEdit->text().stripWhiteSpace() ;
    if ( !want.isEmpty() ) {
        QSqlCursor * t = new QSqlCursor( "Inv_parts", TRUE ) ;
        if ( want.left( 3 ) == "378" ) {
            // press...
            t->setFilter( QString( "serial LIKE '%1%'" ).arg( want.left( 8 ) ) ) ;
        } else {
            t->setFilter( QString( "serial='%1'" ).arg( want ) ) ;
        }
        t->select() ;
        if ( t->next() ) {
            QSqlCursor * u = new QSqlCursor( "Inv_products", TRUE ) ;
            u->setFilter( QString( "recid='%1'" ).arg( t->value( "prodid" ).toString() ) ) ;
            u->select() ;
            if ( u->next() ) {
                want = u->value( "prod_ref" ).toString() ;
            }
        }
        productsTable->setFilter( QString( "prod_ref LIKE '%1%'" ).arg( want ) ) ;
        productsTable->refresh() ;
        if ( productsTable->numRows() > 0 ) {
            productsTable->selectRow( 0 ) ;
        } else {
            // Unknown product. Must Create
            
        }
    }
}


void LabPhysicalInventory::productChanged( QSqlRecord * buffer )
{
    partsTable->setFilter( QString( "prodid='%1'" ).arg( buffer->value( "recid" ).toString() ) ) ;
    partsTable->refresh() ;
    partsTable->selectRow( 0 ) ;
}


void LabPhysicalInventory::beforeUpdatePart( QSqlRecord * buffer )
{
    QSqlCursor * t = new QSqlCursor( "Inv_products", TRUE ) ;
    t->setFilter( QString( "recid='%1'" ).arg( buffer->value( "prodid" ).toString() ) ) ;
    t->select() ;
    if ( t->next() ) {
        int qty = buffer->value( "stock" ).toInt() * buffer->value( "qty_unit" ).toInt() ;
        for ( int i = 0; i < partsTable->numRows(); i++ ) {
            if ( partsTable->text( i, 0 ) != buffer->value( "serial" ).toString() ) {
                qty += partsTable->text( i, 1 ).toInt() * partsTable->text( i, 5 ).toInt() ;
            }
        }
        QSqlQuery q( QString( "UPDATE Inv_products SET available='%1' WHERE recid='%2' ;" ).arg( qty ).arg( t->value( "recid" ).toString() ) ) ;
        productsTable->update() ;
        productsTable->refresh() ;
    }
}