tickethistory.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 TicketHistory::init()
{
        listTable->setLeftMargin( 0 ) ;
        listTable->setColumnWidth( BOXID, 0 ) ;
        listTable->setColumnWidth( CASHIER, 0 ) ;
        listTable->setColumnWidth( TICKETDATE, 0 ) ;
        listTable->setColumnStretchable( TICKETNO, TRUE ) ;
        detailTable->setFilter( "recid=-1" ) ;
        detailTable->refresh() ;
        
}

void TicketHistory::ticketChanged( int row, int col )
{
        if ( !inInit ) {
                detailTable->setFilter( QString( "ticket_num='%1-%2-%3-%4 %5'" ) 
                                                                .arg( listTable->text( row, BOXID ) )
                                                                .arg( listTable->text( row, CASHIER ) )
                                                                .arg( listTable->text( row, TICKETNO ) )
                                                                .arg( listTable->text( row, TICKETDATE ) )
                                                                .arg( listTable->text( row, TICKETTIME ) ) ) ;
                detailTable->refresh() ;
        }
}



void TicketHistory::fillTable()
{
        int row = 0 ;
        QString entry ;
        listTable->setNumRows( 0 ) ;
        while ( refer->next() ) {
                entry = refer->value( 0 ).toString() ;
                listTable->insertRows( row, 1 ) ;
                listTable->setText( row, 0, entry.section( "-", 0, 0 ) ) ;
                listTable->setText( row, 1, entry.section( "-", 1, 1 ) ) ;
                listTable->setText( row, 2, entry.section( "-", 2, 2 ) ) ;
                QString dt = entry.section( "-", 3, 3 ) ;
                listTable->setText( row, 3, dt.section( " ", 0, 0 ) ) ;
                listTable->setText( row, 4, dt.section( " ", 1, 1 ) ) ;
                row++ ;
        }
        if ( listTable->numRows() > 0 ) {
                listTable->setCurrentCell( 0, 0 ) ;
                listTable->selectRow( 0 ) ;
                ticketChanged( 0, 0 ) ;
        } else {
                applyButton->setEnabled( FALSE ) ;
                messageline->setText( tr( "No ticket means your criteria. Sorry" ) ) ;
        }
}


void TicketHistory::setDateValues( const QDate & dt )
{
        inInit = TRUE ;
        QString filter = QString( "received >= '%1' AND received <= '%2'" )
                                         .arg( dt.toString( "yyyyMMdd000000" ) )
                                         .arg( dt.toString( "yyyyMMdd235959" ) ) ;
        refer = new QSqlQuery ( QString( "SELECT DISTINCT ticket_num FROM Ticket_receipts "
                                                                         "WHERE %1 ;" ).arg( filter ) ) ;
        dateLabel->setText( dt.toString( "dd MMMM yyyy" ) ) ;
        //fillTable() ;
        int row = 0 ;
        QString entry ;
        listTable->setNumRows( 0 ) ;
        while ( refer->next() ) {
                entry = refer->value( 0 ).toString() ;
                listTable->insertRows( row, 1 ) ;
                listTable->setText( row, BOXID, entry.section( "-", 0, 0 ) ) ;
                listTable->setText( row, CASHIER, entry.section( "-", 1, 1 ) ) ;
                listTable->setText( row, TICKETNO, entry.section( "-", 2, 2 ) ) ;
                QString dt = entry.section( "-", 3, 3 ) ;
                listTable->setText( row, TICKETDATE, dt.section( " ", 0, 0 ) ) ;
                listTable->setText( row, TICKETTIME, dt.section( " ", 1, 1 ) ) ;
                row++ ;
        }
        if ( listTable->numRows() > 0 ) {
                listTable->setCurrentCell( 0, 0 ) ;
                listTable->selectRow( 0 ) ;
                inInit = FALSE ;
                ticketChanged( 0, 0 ) ;
        } else {
                applyButton->setEnabled( FALSE ) ;
                messageline->setText( tr( "No ticket means your criteria. Sorry" ) ) ;
        }
        inInit = FALSE ;        
}


void TicketHistory::setMessage( const QString & msg )
{
        messageline->setText( msg ) ;
}


QString TicketHistory::getResult()
{
        int row = listTable->currentRow() ;
        return QString( "ticket_num='%1-%2-%3-%4 %5" ) 
                        .arg( listTable->text( row, 0 ) )
                        .arg( listTable->text( row, 1 ) )
                        .arg( listTable->text( row, 2 ) )
                        .arg( listTable->text( row, 3 ) )
                        .arg( listTable->text( row, 4 ) ) ;
}