labcashbox.ui.h

static QMap< QString, QString > pgBtns ;
static QMap< QString, int > directActions ;
static QMap< QString, int > payStrategies ;

void LabCashbox::init()
{
        ticketViewTable->setLeftMargin( 0 ) ;
        ticketViewTable->setReadOnly( TRUE ) ;
        ticketViewTable->setColumnWidth( PRODID, 0 ) ; 
        ticketViewTable->setColumnWidth( SERIAL, 0 ) ; 
        ticketViewTable->setColumnWidth( PRODNAME, 150 ) ; 
        ticketViewTable->setColumnWidth( RETAIL, 50 ) ; 
        ticketViewTable->setColumnWidth( QTY, 50 ) ; 
        ticketViewTable->setColumnWidth( REBATE, 0 ) ; 
        ticketViewTable->setColumnWidth( TOTAL, 50 ) ; 
        ticketViewTable->setColumnWidth( VALID, 0 ) ; 
        ticketViewTable->setColumnWidth( LINE_TYPE, 0 ) ; 
        ticketViewTable->setColumnWidth( TWHEN, 0 ) ; 
        ticketViewTable->setColumnStretchable( PRODNAME, TRUE ) ;
        totalLCDNumber->display( currency( 0.00 ) ) ;
        PriceLCDNumber->display( currency( 0.00 ) ) ;
        quantity = 0 ;
        QObjectList  * paymodes = programmableGroup->queryList( "QButton", "paymode*" ) ;
        QObjectListIterator it( * paymodes ) ;
        QObject * obj ;
        while ( ( obj = it.current() ) != 0 ) {
                ++it ;
                QString accel = tr( (QString)( ( (QButton * )obj )->accel() ) ) ;
                QString label = tr( ( (QButton *)obj )->text() ) ;
                ( (QButton *)obj )->setText( QString( "%1\n[%2]" )
                                                                         .arg( label )
                                                                         .arg( accel ) ) ;
                ( (QButton *)obj )->setAccel( QKeySequence( accel ) ) ;
        }
        delete it ;
        QObjectList  * actbtns = stdactionGroup->queryList( "QButton" ) ;
        QObjectListIterator it2( * actbtns ) ;
        while ( ( obj = it2.current() ) != 0 ) {
                ++it2 ;
                QString accel = tr( (QString)( ( (QButton * )obj )->accel() ) ) ;
                QString label = tr( ( (QButton *)obj )->text() ) ;
                ( (QButton *)obj )->setText( QString( "%1\n[%2]" )
                                                                         .arg( label )
                                                                         .arg( accel ) ) ;
                ( (QButton *)obj )->setAccel( QKeySequence( accel ) ) ;
        }       
        parts = new QSqlCursor( "Inv_parts", TRUE ) ;
        prods = new QSqlCursor( "Inv_products", TRUE ) ;
        
        userID = LabUser->value( "recid" ).toInt() ;
        cashboxID = GetIniVar( "Cashbox", "ident" ).toInt() ;
        
        setFreeButtons() ;
        inInit = TRUE ;
        newTicket() ;
        inInit = FALSE ;
        resetGetter() ;
}

void LabCashbox::CloseBox()
{
        if ( QMessageBox::question( this, tr( "Cashbox Closing" ),
                                                                tr( "You asked for Closing your cashbox\n"
                                                                        "First, you'll have to count the values in box."
                                                                        "Are You Sure ?" ),
                                                                tr( "No" ), tr( "Yes" ), 0, 0, -1 ) == 1 ) {
                countBox( "Closing" ) ;
                close() ;
        }
}


void LabCashbox::PauseBox()
{
        if ( ticketViewTable->numRows() == 0 ) {
                activeMode = "Pause" ;
                currLineTextLabel->setText( tr( "Paused Cashbox" ) ) ;
                CurProd1TextLabel->setText( tr( "Password needed to resume" ) ) ;
                stdGetterLineEdit->setEchoMode( QLineEdit::Password ) ;
        }       
}


void LabCashbox::countBox( const QString & mode)
{
        CashboxCount * dialog = new CashboxCount( this, "Count Box", TRUE ) ;    
        dialog->setMode( mode ) ;
        dialog->exec() ;
}


void LabCashbox::withdrawalBox()
{
        countBox( "Withdrawal" ) ;
}


void LabCashbox::optionsBox()
{
        qDebug( "Specific options will be inserted here. Not yet implemented" ) ;
}


void LabCashbox::superviseMode()
{
        
}


void LabCashbox::doAction()
{
        QString line = stdGetterLineEdit->text().stripWhiteSpace() ;
        if ( line.isEmpty() ) return ;
        if ( activeMode == "Line" ) {
                findPart() ;
        } else if ( activeMode ==  "Payment" ) {
                if ( paymode == "Cashin" ) {
                        addPayLine( line.toDouble(), paymode ) ;
                        if ( paidval >= netvalue ) {
                                currLineTextLabel->setText( tr( "Refund" ) ) ;
                                CurProd1TextLabel->setText( tr( "Monney to refund to customer" ) ) ;
                                totalLCDNumber->display( currency( paidval - netvalue ) ) ;
                                addPayLine( paidval - netvalue, "Refund" ) ;
                                ticketEnd() ;
                        } else {
                                // We eceived less than wanted. Need another get
                                paymode = "" ;
                        }
                } else if ( paymode == "Cheque" || paymode == "CreditCard" || paymode == "Moneo" ) {
                        if ( fullPartial == "" ) {
                                if ( line == "1" || line == "2" ) {
                                        fullPartial = ( line == "1" ) ? "Full" : "Partial" ;
                                        if ( fullPartial == "Full" ) {
                                                addPayLine( netvalue - paidval, paymode ) ;
                                                ticketEnd() ;
                                        }
                                } else {
                                        CurProd1TextLabel->setText( tr( "Error! Type 1 for Full payment or 2 for Partial" ) ) ;
                                }
                        } else {
                                addPayLine( line.toDouble(), paymode ) ;
                                if ( paidval == netvalue ) {
                                        ticketEnd() ;
                                } else {
                                        paymode = "" ;
                                        fullPartial = "" ;
                                }
                        }
                } else if ( paymode == "Delayed" ) {
                        if ( line == "?" || line.isEmpty() ) {
                                line = "ZZZZZZZZZZZZZZZZ" ;
                        }
                        int cust = getCustomer( line ) ;
                        QString ordernum = "" ;
                        QString comment = "" ;
                        if ( cust == 0 ) {
                                CustDialog * dialog = new CustDialog( this, "CustomerSearch", TRUE ) ;
                                if ( dialog->exec() == QDialog::Accepted ) {
                                        cust = dialog->selected() ;
                                        ordernum = dialog->ordernum->text() ;
                                        comment = dialog->comment->text() ;
                                }
                                delete dialog ;
                        }
                        if ( cust > 0 ) {
                                addDelayedPayLine( cust, ordernum, comment ) ;
                                ticketEnd() ;
                        } else {
                                paymode = "" ;
                                fullPartial = "" ;
                        }
                }
        } else if ( activeMode == "Pause" ) {
                checkPass() ;
        }
        resetGetter() ;
}

void LabCashbox::doCount()
{
        countBox( "Cash Counting" ) ;
}


void LabCashbox::evalPayStrategy()
{
        QString mode = QObject::sender()->name() ;
        mode = mode.replace( "Button", "" ) ;
        if ( activeMode != "Payment" ) {
                activeMode = "Payment" ;
                addTotalLine() ;
                currLineTextLabel->setText( tr( "Grand Total" ) ) ;
        }
        CurProd1TextLabel->setText( "" ) ;
        if ( mode == "paymode1" ) {
                // Cash
                paymode = "Cashin" ;
                if ( totalLCDNumber->value() < 0.00 ) {
                        // sounds like a lottery refund...
                        currLineTextLabel->setText( tr( "Refund" ) ) ;
                        CurProd1TextLabel->setText( tr( "Negative total. You MUST refund the customer." ) ) ;
                        addPayLine( - totalLCDNumber->value(), "Refund" ) ;
                        ticketEnd() ;
                }
                CurProd1TextLabel->setText( tr( "Enter Pay Value" ) ) ;
        } else if ( mode == "paymode2" ) {
                // Cheque
                paymode = "Cheque" ;
                CurProd1TextLabel->setText( tr( "1 for Full, 2 for partial" ) ) ;
        } else if ( mode == "paymode3" ) {
                // CC
                paymode = "CreditCard" ;
                CurProd1TextLabel->setText( tr( "1 for Full, 2 for partial" ) ) ;
        } else if ( mode == "paymode4" ) {
                // Moneo
                paymode = "Moneo" ;
                CurProd1TextLabel->setText( tr( "1 for Full, 2 for partial" ) ) ;
        } else if ( mode == "paymode5" ) {
                // Deffered
                paymode = "Delayed" ;
                CurProd1TextLabel->setText( tr( "Customer Code, ? for search" ) ) ;
        }
}


void LabCashbox::evalFreeBtns()
{
        QString btn = QObject::sender()->name() ;
        stdGetterLineEdit->setText( pgBtns[btn] ) ;
        findPart() ;
}

void LabCashbox::newTicket()
{
        ticketViewTable->setNumRows( 0 ) ;
        currLineTextLabel->setText( tr( "Next Customer" ) ) ;
        CurProd1TextLabel->setText( "" ) ;
        qtyLabel->setText( "0" ) ;
        quantity = 1 ;
        QSqlCursor * tinfo = new QSqlCursor( "Cashbox_sequence", TRUE ) ;
        tinfo->select() ;
        tinfo->next() ;
        ticketID = tinfo->value( "seq_no" ).toInt() + 1 ;
        QSqlQuery q( QString( "UPDATE Cashbox_sequence SET seq_no='%1' ;" ).arg( ticketID ) ) ;
        ticketInfoLabel->setText( QString( "%1-%2-%3-%4" )
                                                          .arg( cashboxID ).arg( userID )
                                                          .arg( ( QString( "%1" ).arg( ticketID ) ).rightJustify( 7, '0' ) )
                                                          .arg( QDateTime::currentDateTime().toString( "yyyy.MM.dd hh:mm:ss" ) ) ) ;
        if ( !inInit ) {
                PriceLCDNumber->display( currency( 0.00 ) ) ;
                objectsLCDNumber->display( 0 ) ;
                totalLCDNumber->display( currency( 0.00 ) ) ;
        }
        stdGetterLineEdit->setText( "" ) ;
        netvalue = 0.0 ;
        paidval = 0.0 ;
        paymode = "" ;
        activeMode = "Line" ;
        fullPartial = "" ;
        showTotal() ;
}


void LabCashbox::setFreeButtons()
{
        QSqlCursor * opts = new QSqlCursor( "Cashbox_options", TRUE ) ;
        opts->setFilter( QString( "cashboxgroup='%1'" ).arg( GetIniVar( "Cashbox", "PrinterGroup" ) ) ) ;
        opts->select() ;
        opts->next() ;
        QStringList btns = QStringList::split( '|', opts->value( "bprogs" ).toString() ) ;
        // Initialize Free Buttons to some known state
        for ( int i = 0; i < 24; i++ ) {
                QPushButton * btn = (QPushButton *)this->child( QString( "free%1" ).arg( i + 1 ) );
                QFont free_font(  btn->font() );
                free_font.setBold( TRUE ) ;
                btn->setFont( free_font ) ; 
                btn->setEnabled( FALSE ) ;
                btn->setText( "" ) ;
        }
        for ( QStringList::Iterator it = btns.begin(); it != btns.end(); ++it ) {
                QString entry = *it ;
                // Set Button Name and grab widget
                QString btnname = entry.section( "=", 0, 0 ) ;
                // Grab button data
                QPushButton * btn = (QPushButton * )this->child( btnname ) ;
                QStringList btndata = QStringList::split( ';', entry.section( "{", 1, 1 ).replace( "}", "" ) ) ;
                for ( QStringList::Iterator it = btndata.begin(); it != btndata.end(); ++it ) {
                        QString item = *it ;
                        if ( item.left( 5 ) == "label" ) {
                                btn->setText( item.mid( 6 ) ) ;
                        } else if ( item.left( 5 ) == "value" ) {
                                connect( btn, SIGNAL( clicked() ), this, SLOT( evalFreeBtns() ) );
                                pgBtns.replace( btnname, item.mid( 6 ) ) ;                              
                        } else if ( item.left( 6 ) == "prefix" ) {
                                connect( btn, SIGNAL( clicked() ), this, SLOT( evalPrefixBtns() ) );
                                pgBtns.replace( btnname, item.mid( 7 ) ) ;                                                      
                        } else if ( item.left( 3 ) == "day" ) {
                                int today = QDate::currentDate().dayOfWeek() ;
                                int dd = item.mid( 4, 1 ).toInt() ;
                                if ( dd == today ) {
                                        connect( btn, SIGNAL( clicked() ), this, SLOT( evalFreeBtns() ) );
                                        pgBtns.replace( btnname, item.mid( 6, 255 ) ) ;
                                        break ; ;
                                }                               
                        } else if ( item.left( 3 ) == "def" ) {
                                connect( btn, SIGNAL( clicked() ), this, SLOT( evalFreeBtns() ) );
                                pgBtns.replace( btnname, item.mid( 4, 255 ) ) ;                         
                        } else if ( item.left( 6 ) == "action" ) {
                                pgBtns.replace( btnname, item.mid( 7, 255 ) ) ;                                                 
                                connect( btn, SIGNAL( clicked() ), this, SLOT( evalActionBtns() ) );
                        }
                }
                btn->setEnabled( TRUE ) ;
        }       
}


bool LabCashbox::findPart()
{
        bool unknownPress = FALSE ;
        QString want = stdGetterLineEdit->text().stripWhiteSpace().lower() ;
        parts->setFilter( QString( "serial='%1'" ).arg( want ) );
        parts->select() ;
        if ( parts->size() != 1 ) {
                // This is a problem... Let's tweak the fuckin' thing
                if ( want.left( 3 ) == "378" || want.left( 3 ) == "379" ) {
                        // Is this some press item ?
                        parts->setFilter( QString( "left( serial, 13 )='%1'" ).arg( want.left( 13 ) ) ) ;
                        parts->select() ;
                        if ( parts->size() != 1 ) {
                                // Sounds like this press item has not yet been created.
                                CurProd1TextLabel->setText( tr( "Unknow press Title... Doing my best." ) ) ;
                                unknownPress = TRUE ;
                                resetGetter() ;
                        }
                } else {
                        // Standard product. Must know why not here...
                        CurProd1TextLabel->setText( tr( "Unknow Product Code. Going to manual search." ) ) ;
                        resetGetter() ;
                        activateSearch() ;
                        return TRUE ;
                }
        }
        // Populate the Table.
        int row = numRows() ;
        if ( quantity == 0 ) quantity = 1 ;
        ticketViewTable->insertRows( row, 1 ) ;
        if ( unknownPress ) {
                ticketViewTable->setText( row, PRODID, "0" ) ;
                ticketViewTable->setText( row, SERIAL, want ) ;
                ticketViewTable->setText( row, PRODNAME, QString( "%1 - %2" ).arg( tr( "Press" ) ).arg( want ) ) ;
                ticketViewTable->setText( row, QTY, QString( "%1").arg( quantity ) ) ;
                double rprice = want.mid( 8, 4 ).insert( 2, "." ).toDouble()  ;
                ticketViewTable->setText( row, RETAIL, currency( rprice ) ) ;
                ticketViewTable->setText( row, TOTAL, currency( rprice * (double)quantity ) ) ;
                ticketViewTable->setText( row, REBATE, "0" ) ;
                ticketViewTable->setText( row, VALID, "1" ) ;
                ticketViewTable->setText( row, LINE_TYPE, "Line" ) ;
                ticketViewTable->setText( row, TWHEN, QDateTime::currentDateTime().toString( "yyyy-MM-dd hh:mm:ss" ) ) ;                
        } else {
                parts->next() ;
                // Get assoc product
                prods->setFilter( QString( "recid='%1'" ).arg( parts->value( "prodid" ).toInt() ) ) ;
                prods->select() ;
                if ( !prods->next() ) {
                        // bug ! Should not occur...
                        resetGetter() ;
                }
                ticketViewTable->setText( row, PRODID, parts->value( "prodid" ).toString() ) ;
                ticketViewTable->setText( row, SERIAL, parts->value( "serial" ).toString() ) ;
                ticketViewTable->setText( row, PRODNAME, prods->value( "prod_name" ).toString() ) ;
                ticketViewTable->setText( row, QTY, QString( "%1").arg( quantity ) ) ;
                if ( want.left( 3 ) == "378" || want.left( 3 ) == "379" ) {
                        double rprice = want.mid( 8, 4 ).insert( 2, "." ).toDouble()  ;
                        ticketViewTable->setText( row, RETAIL, currency( rprice ) ) ;
                        ticketViewTable->setText( row, TOTAL, currency( rprice * (double)quantity ) ) ;
                        if ( want.length() == 18 ) {
                                int release = want.mid( 14, 3 ).toInt() ;
                                ticketViewTable->setText( row, PRODNAME, QString( "%1 - %2 %3" )
                                                                          .arg( prods->value( "prod_name" ).toString().left( 20 ) )
                                                                          .arg( tr( "Num." ) )
                                                                          .arg( release ) );
                        }
                } else {
                        ticketViewTable->setText( row, RETAIL, currency( parts->value( "retail" ).toDouble() ) ) ;
                        ticketViewTable->setText( row, TOTAL, currency( parts->value( "retail" ).toDouble() * (double)quantity ) ) ;
                }
                ticketViewTable->setText( row, REBATE, parts->value( "savings" ).toString() ) ;
                ticketViewTable->setText( row, VALID, "1" ) ;
                ticketViewTable->setText( row, LINE_TYPE, "Line" ) ;
                ticketViewTable->setText( row, TWHEN, QDateTime::currentDateTime().toString( "yyyy-MM-dd hh:mm:ss" ) ) ;
        }
        ticketViewTable->ensureVisible( row, 0 ) ;
        ticketViewTable->selectRow( row ) ;
        currLineTextLabel->setText( ticketViewTable->text( row, PRODNAME ) ) ;
        PriceLCDNumber->display( currency( ticketViewTable->text( row, TOTAL ).toDouble() ) ) ;
        qtyLabel->setText( ticketViewTable->text( row, QTY ) ) ;
        showTotal() ;
        showItems() ;
        quantity = 1 ;
        resetGetter() ;
        return TRUE ;
}



void LabCashbox::showTotal()
{
        double ntot = calcTotal( "Line" ) ;
        totalLCDNumber->display( currency( ntot ) ) ;
        bool enable = ntot > 0 ;
        subTotalButton->setEnabled( enable ) ;
        totalButton->setEnabled( enable ) ;
        ticketCancelButton->setEnabled( numRows() > 0 ) ;
        immCancelButton->setEnabled( numRows() > 0 ) ;
        QObjectList  * paymodes = programmableGroup->queryList( "QButton", "paymode*" ) ;
        QObjectListIterator it( * paymodes ) ;
        QObject * obj ;
        while ( ( obj = it.current() ) != 0 ) {
                ++it ;
                ( (QButton *)obj )->setEnabled( numRows() > 0 ) ;
        }       
}

void LabCashbox::showItems()
{
        int items = 0 ;
        for ( int i = 0; i < numRows(); i++ ) {
                items += ticketViewTable->text( i, QTY ).toInt() ;
        }
        objectsLCDNumber->display( items ) ;
}

void LabCashbox::resetGetter()
{
        stdGetterLineEdit->setText( "" ) ;
        stdGetterLineEdit->setFocus() ;
}

void LabCashbox::setQuantity()
{
        QString qs = stdGetterLineEdit->text().stripWhiteSpace() ;
        if ( qs.right( 1 ) == "*" ) {
                qs = qs.left( qs.length() -1 ) ;
        }
        if ( qs.isEmpty() ) {
                quantity = 1 ;
        } else {
                quantity = qs.toInt() ;
                if ( QString( "%1" ).arg( quantity ) != qs ) {
                        quantity = 1 ;
                }
        }
        qtyLabel->setText( QString( "%1" ).arg( quantity ) ) ;
        CurProd1TextLabel->setText( "" ) ;
        resetGetter() ;
}

void LabCashbox::captureEvents( const QString & evt )
{
        if ( evt.isEmpty() ) return ;
        QString want = evt.right( 1 ) ;
        if ( want == "*" ) {
                setQuantity() ;
        } else if ( evt == "+" ) {
                duplicateLine( numRows() -1 ) ;
        }
}

// Specific Event Manager


void LabCashbox::addStaticLine()
{
        QString want = QObject::sender()->name() ;
        want = want.replace( "Button", "" ) ;
        double subt = 0.0 ;
        int nbsubs = 0 ;
        double tticket = 0.0 ;
        double res = 0.0 ;
        if ( want == "subTotal" ) {
                want = "Subtotal" ;
                // Calculate real subtotal
                subt = calcTotal( "Subtotal" ) ;
                nbsubs = countLines( "Subtotal" ) ;
                tticket = calcTotal( "Line" ) ;
                res = tticket - subt ;
        } else if ( want == "total" ) {
                want = "Total" ;
                subt = calcTotal( "Total" ) ;
                nbsubs = countLines( "Total" ) ;
                tticket = calcTotal( "Line" ) ;
                res = tticket ;
        } else {
                return ;
        }
        int row = numRows() ;
        ticketViewTable->insertRows( row, 1 ) ;
        ticketViewTable->setText( row, PRODID, "0" ) ;
        ticketViewTable->setText( row, SERIAL, "" ) ;
        ticketViewTable->setText( row, PRODNAME, QString( tr( "%1 %2" ) ).arg( want ).arg( nbsubs + 1 ) ) ;
        ticketViewTable->setText( row, RETAIL, "" ) ;
        ticketViewTable->setText( row, QTY, "" ) ;
        ticketViewTable->setText( row, REBATE, "0" ) ;
        ticketViewTable->setText( row, TOTAL, currency( res ) ) ;
        ticketViewTable->setText( row, VALID, "1" ) ;
        ticketViewTable->setText( row, LINE_TYPE, want ) ;
        ticketViewTable->setText( row, TWHEN, QDateTime::currentDateTime().toString( "yyyy-MM-dd hh:mm:ss" ) ) ;   
}


void LabCashbox::cancelTicket()
{
        if ( QMessageBox::question( this, tr( "Cancel Ticket" ),
                                                                tr( "You called me for cancelling all information\n"
                                                                        "from current ticket.\n\n"
                                                                        "Are you really sure you want to cancel this ticket" ),
                                                                tr( "No" ), tr( "Yes" ), 0, 0, 0 ) == 1 ) {
                int numlines = numRows() ;
                for ( int i = 0; i < numlines; i++ ) {
                        ticketViewTable->selectRow( i ) ;
                        cancelLine() ;
                }       
                int row = numRows() ;
                ticketViewTable->insertRows( row, 1 ) ;
                ticketViewTable->setText( row, PRODID, "0" ) ;
                ticketViewTable->setText( row, SERIAL, "" ) ;
                ticketViewTable->setText( row, PRODNAME, tr( "Cancelled Ticket" ) ) ;
                ticketViewTable->setText( row, RETAIL, "" ) ;
                ticketViewTable->setText( row, QTY, "" ) ;
                ticketViewTable->setText( row, REBATE, "0" ) ;
                ticketViewTable->setText( row, TOTAL, "0" ) ;
                ticketViewTable->setText( row, VALID, "1" ) ;
                ticketViewTable->setText( row, LINE_TYPE, "TicketCancel" ) ;
                ticketViewTable->setText( row, TWHEN, QDateTime::currentDateTime().toString( "yyyy-MM-dd hh:mm:ss" ) ) ;   
                
                CurProd1TextLabel->setText( tr( "<b>Ticket Cancel<b>: Informing Master Server" ) ) ;
                informMaster() ;
                CurProd1TextLabel->setText( "" ) ;
        }
}


void LabCashbox::cancelTransaction()
{
        TicketHistory * dialog = new TicketHistory( this, "TicketHistory", TRUE ) ;
        dialog->setDateValues( QDate::currentDate() ) ;
        dialog->setMessage( tr( "Select the transaction you want to cancel" ) ) ;
        if ( dialog->exec() == QDialog::Accepted ) {
        
        }
        delete dialog ;
}


void LabCashbox::addDirectEntry()
{
        DirectEntry * dialog = new DirectEntry( this, "DirectEntry", TRUE ) ;
        if ( dialog->exec() == QDialog::Accepted ) {
                int row = numRows() ;
                ticketViewTable->insertRows( row, 1 ) ;
                
                ticketViewTable->setText( row, PRODID, "0" ) ;
                ticketViewTable->setText( row, SERIAL, "manual_entry" ) ;
                ticketViewTable->setText( row, PRODNAME, dialog->designation->text() ) ;
                ticketViewTable->setText( row, RETAIL, dialog->retail->text() ) ;
                ticketViewTable->setText( row, QTY, dialog->qty->text() ) ;
                ticketViewTable->setText( row, REBATE, "0" ) ;
                ticketViewTable->setText( row, TOTAL, dialog->total->text() ) ;
                ticketViewTable->setText( row, VALID, "1" ) ;
                ticketViewTable->setText( row, LINE_TYPE, "Line" ) ;
                ticketViewTable->setText( row, TWHEN, QDateTime::currentDateTime().toString( "yyyy-MM-dd hh:mm:ss" ) ) ;
                if ( dialog->rebateSet() ) {
                        negateRow( row ) ;
                        ticketViewTable->setText( row, REBATE, "Rebate" ) ;
                }
                ticketViewTable->ensureVisible( row, 0 ) ;
                ticketViewTable->selectRow( row ) ;
                currLineTextLabel->setText( ticketViewTable->text( row, PRODNAME ) ) ;
                PriceLCDNumber->display( ticketViewTable->text( row, TOTAL ).toDouble() ) ;
                showTotal() ;
                showItems() ;
        }
        delete dialog ;
        resetGetter() ;
}


void LabCashbox::activateSearch()
{
        QuickSearcher * dialog = new QuickSearcher( this, "ProductSearch", TRUE ) ;
        if ( dialog->exec() == QDialog::Accepted ) {
                stdGetterLineEdit->setText( dialog->currBarcode->text() ) ;
                delete dialog ;
                findPart() ;
        } else {
                delete dialog ;
                
        }
}

void LabCashbox::cancelLine()
{
        int row = numRows() ;
        int todel = ticketViewTable->currentRow() ;
        if ( row > 0 ) {
                ticketViewTable->insertRows( row, 1 ) ;
                for ( int i = 0; i < ticketViewTable->numCols(); i++ ) {
                        ticketViewTable->setText( row, i, ticketViewTable->text( todel, i ) ) ;
                }
                ticketViewTable->setText( row, VALID, "0" ) ;
                ticketViewTable->setText( row, TWHEN, QDateTime::currentDateTime().toString( "yyyy-MM-dd hh:mm:ss" ) ) ;
                negateRow( row ) ;
                if ( activeMode == "Payment" ) {
                        QString lt = ticketViewTable->text( row, LINE_TYPE ) ;
                        if ( lt == "Refund" ) {
                                ticketViewTable->setText( row, PRODNAME, tr( "Refund Cancel" ) ) ;
                        } else if ( lt == "PayCancel" ) {
                                ticketViewTable->setText( row, LINE_TYPE, ticketViewTable->text( row, SERIAL ) ) ;
                                ticketViewTable->setText( row, PRODNAME, tr( ticketViewTable->text( row, SERIAL ) ) ) ;
                                paidval += ticketViewTable->text( row, TOTAL ).toDouble() ;
                        } else if ( lt == "LineCancel" ) {
                                showTotal() ;
                                showItems() ;
                        } else {
                                ticketViewTable->setText( row, SERIAL, ticketViewTable->text( row, LINE_TYPE ) ) ;
                                ticketViewTable->setText( row, LINE_TYPE, "PayCancel" ) ;
                                paidval += ticketViewTable->text( row, TOTAL ).toDouble() ;
                        }
                }
                resetGetter() ;
        }
}

void LabCashbox::negateRow( int row )
{
        if ( ticketViewTable->text( row, QTY ).left( 1 ) == "-" ) {
                ticketViewTable->setText( row, QTY, ticketViewTable->text( row, 4 ).remove( 0, 1 ) ) ;
                ticketViewTable->setText( row, TOTAL, ticketViewTable->text( row, 6 ).remove( 0, 1 ) ) ;
        } else {
                if ( ticketViewTable->text( row, QTY ) != "-" ) {
                        ticketViewTable->setText( row, QTY, ticketViewTable->text( row, 4 ).prepend( "-" ) ) ;
                }
                ticketViewTable->setText( row, TOTAL, ticketViewTable->text( row, 6 ).prepend( "-" ) ) ;
        }
        ticketViewTable->setText( row, TWHEN, QDateTime::currentDateTime().toString( "yyyy-MM-dd hh mm ss" ) ) ;
        ticketViewTable->ensureVisible( row, 0 ) ;
        ticketViewTable->selectRow( row ) ;
        currLineTextLabel->setText( ticketViewTable->text( row, PRODNAME ) ) ;
        PriceLCDNumber->display( ticketViewTable->text( row, TOTAL ).toDouble() ) ;
        qtyLabel->setText( ticketViewTable->text( row, QTY ) ) ;
        showTotal() ;
        showItems() ;
        resetGetter() ;
}

void LabCashbox::duplicateLine( int dup )
{
        int row = numRows() ;
        ticketViewTable->insertRows( row, 1 ) ;
        for ( int i = 0; i < ticketViewTable->numCols(); i++ ) {
                ticketViewTable->setText( row, i, ticketViewTable->text( dup, i ) ) ;
        }
        ticketViewTable->setText( row, TWHEN, QDateTime::currentDateTime().toString( "yyyy-MM-dd hh:mm:ss" ) ) ;
        currLineTextLabel->setText( ticketViewTable->text( row, PRODNAME ) ) ;
        PriceLCDNumber->display( ticketViewTable->text( row, TOTAL ).toDouble() ) ;
        qtyLabel->setText( ticketViewTable->text( row, QTY ) ) ;
        showTotal() ;
        showItems() ;
        resetGetter() ;
}

QString LabCashbox::currency( double val )
{
        return QString( "%1" ).arg( val, 0, 'f', 2 ) ;
}


double LabCashbox::calcTotal( const QString & md )
{
        double tx = 0.00 ;
        int rows = numRows() ;
        for ( int i = 0; i < rows; i++ ) {
                if ( ticketViewTable->text( i, LINE_TYPE ) == md ) {
                        tx += ticketViewTable->text( i, TOTAL ).toDouble() ;
                }
        }
        return tx ;
}


int LabCashbox::countItems( const QString & md )
{
        int ret = 0 ;
        int rows = numRows() ;
        for ( int i = 0; i < rows; i++ ) {
                if ( ticketViewTable->text( i, LINE_TYPE ) == md ) {
                        ret += ticketViewTable->text( i, QTY ).toInt() ;
                }
        }
        return ret ;    
}


int LabCashbox::countLines( const QString & md )
{
        int ret = 0 ;
        int rows = numRows() ;
        for ( int i = 0; i < rows; i++ ) {
                if ( ticketViewTable->text( i, LINE_TYPE ) == md ) {
                        ret++ ;
                }
        }
        return ret ;
}


int LabCashbox::numRows()
{
        return ticketViewTable->numRows() ;
}


void LabCashbox::informMaster()
{
        QSqlCursor * master = new QSqlCursor( "Ticket_receipts", TRUE ) ;
        int rows = numRows() ;
        for ( int i = 0; i < rows; i++ ) {
                QSqlRecord * buffer = master->primeInsert() ;
                buffer->setValue( "recid", SequenceGetNextValue( "Ticket_receipts" ) ) ;
                buffer->setValue( "cashbox", cashboxID ) ;
                buffer->setValue( "cashier", userID ) ;
                buffer->setValue( "ticket_num", ticketInfoLabel->text() ) ;
                buffer->setValue( "line_num", i + 1 ) ;
                buffer->setValue( "prodid", ticketViewTable->text( i, PRODID ).toInt() ) ;
                buffer->setValue( "serial", ticketViewTable->text( i, SERIAL ) ) ;
                buffer->setValue( "prodname", ticketViewTable->text( i, PRODNAME ) ) ;
                QString retail = ticketViewTable->text( i, RETAIL ) ;
                if ( retail.isEmpty() || retail == "-" ) {
                        retail = "0" ;
                }
                buffer->setValue( "retail", retail ) ;
                QString qty = ticketViewTable->text( i, QTY ) ;
                if ( qty.isEmpty() || qty == "-" ) {
                        qty = "0" ;
                }
                buffer->setValue( "qty", qty ) ;
                buffer->setValue( "rebate", ticketViewTable->text( i, REBATE ) ) ;
                buffer->setValue( "total", ticketViewTable->text( i, TOTAL ) ) ;
                buffer->setValue( "valid", ticketViewTable->text( i, VALID ) )  ;
                buffer->setValue( "line_type", ticketViewTable->text( i, LINE_TYPE ) ) ;
                buffer->setValue( "twhen", ticketViewTable->text( i, TWHEN ) ) ;
                buffer->setValue( "received", QDateTime::currentDateTime() ) ;
                master->insert() ;
        }
        newTicket() ;
}



void LabCashbox::addTotalLine()
{
        double res = calcTotal( "Line" ) ;
        
        int row = numRows() ;
        ticketViewTable->insertRows( row, 1 ) ;
        ticketViewTable->setText( row, PRODID, "0" ) ;
        ticketViewTable->setText( row, SERIAL, "" ) ;
        ticketViewTable->setText( row, PRODNAME, tr( "Grand Total" ) ) ;
        ticketViewTable->setText( row, RETAIL, "" ) ;
        ticketViewTable->setText( row, QTY, "" ) ;
        ticketViewTable->setText( row, REBATE, "0" ) ;
        ticketViewTable->setText( row, TOTAL, currency( res ) ) ;
        ticketViewTable->setText( row, VALID, "1" ) ;
        ticketViewTable->setText( row, LINE_TYPE, "Total" ) ;
        ticketViewTable->setText( row, TWHEN, QDateTime::currentDateTime().toString( "yyyy-MM-dd hh:mm:ss" ) ) ; 
        netvalue = res ;
}


void LabCashbox::addPayLine( double val, const QString & md )
{
        paidval += val ;
        int row = ticketViewTable->numRows() ;
        ticketViewTable->insertRows( row, 1 ) ;
        ticketViewTable->setText( row, PRODID, "0" ) ;
        ticketViewTable->setText( row, SERIAL, md ) ;
        ticketViewTable->setText( row, PRODNAME, tr( md ) ) ;
        ticketViewTable->setText( row, RETAIL, "" ) ;
        ticketViewTable->setText( row, QTY, "" ) ;
        ticketViewTable->setText( row, REBATE, "0" ) ;
        ticketViewTable->setText( row, TOTAL, currency( val ) ) ;
        ticketViewTable->setText( row, VALID, "1" ) ;
        ticketViewTable->setText( row, LINE_TYPE, md ) ;
        ticketViewTable->setText( row, TWHEN, QDateTime::currentDateTime().toString( "yyyy-MM-dd hh:mm:ss" ) ) ; 

}

                
void LabCashbox::ticketEnd()
{
        if ( QMessageBox::question( this, tr( "Ticket Validation" ),
                                                                tr( "Ticket Ready for Validation\n"
                                                                        "No will allow you to change paymode."
                                                                        "Validate ticket ?" ),
                                                                tr( "Yes" ), tr( "No" ), 0, 0, -1 ) == 0 ) {
                informMaster() ;
        } else {
                paymode = "" ;
                fullPartial = "" ;
        }
}


void LabCashbox::addDelayedPayLine( int cust, const QString ordernum, const QString comment )
{
        int row = ticketViewTable->numRows() ;
        ticketViewTable->insertRows( row, 1 ) ;
        ticketViewTable->setText( row, PRODID, QString( "%1" ).arg( cust ) ) ;
        ticketViewTable->setText( row, SERIAL,  QString( "%1 - %2" ).arg( ordernum ).arg( comment ) ) ;
        ticketViewTable->setText( row, PRODNAME, tr( "Delayed" ) ) ;
        ticketViewTable->setText( row, RETAIL, "" ) ;
        ticketViewTable->setText( row, QTY, "" ) ;
        ticketViewTable->setText( row, REBATE, "0" ) ;
        ticketViewTable->setText( row, TOTAL, currency( netvalue - paidval ) ) ;
        ticketViewTable->setText( row, VALID, "1" ) ;
        ticketViewTable->setText( row, LINE_TYPE, "Delayed" ) ;
        ticketViewTable->setText( row, TWHEN, QDateTime::currentDateTime().toString( "yyyy-MM-dd hh:mm:ss" ) ) ; 
}




int LabCashbox::getCustomer( const QString & want )
{
        QSqlCursor * cust = new QSqlCursor( "Contacts", TRUE ) ;
        cust->setFilter( QString( "contact_qa='%1' AND contact_xtype='Customer'" ).arg( want.upper() ) ) ;
        cust->select() ;
        if ( cust->next() ) {
                return cust->value( "recid" ).toInt() ;
        }
        return 0 ;
}


void LabCashbox::checkPass()
{
        QString want = stdGetterLineEdit->text().stripWhiteSpace() ;
        //SqlCursor * log = new QSqlCursor( "System_users", TRUE ) ;
        QSqlQuery md( QString( "SELECT md5( '%1' );" ).arg( want ) ) ;
        md.next() ;
        QString md5p = md.value( 0 ).toString() ;
        if ( LabUser->value( "password" ).toString() == md5p ) {
                stdGetterLineEdit->setEchoMode( QLineEdit::Normal ) ;
                activeMode = "Line" ;
                CurProd1TextLabel->setText( "" ) ;
                currLineTextLabel->setText( tr( "Box Open" ) ) ;
                newTicket() ;
        } else {
                CurProd1TextLabel->setText( tr( "***** ERROR ***** Bad pass. Retry" ) ) ;
                //for ( int i = 0; i < 1500000; i++ ) {
                //}
                //CurProd1TextLabel->setText( tr( "Password needed to resume" ) ) ;
        }
        resetGetter() ;
}


void LabCashbox::evalPrefixBtns()
{
        QString btn = QObject::sender()->name() ;
        QString prefix = pgBtns[btn] ;
        
        parts->setFilter( QString( "left( serial, %1 ) = '%2'" ).arg( prefix.length() ).arg( prefix ) ) ;
        parts->select() ;
        
        parts->setFilter( "" ) ;
}


void LabCashbox::evalActionBtns()
{

}