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()
{
    refer = new QSqlQuery() ;
    detailTable->setFilter( "recid=-1" ) ;
    detailTable->refresh() ;
    
}

void TicketHistory::ticketChanged( int row, int col )
{
    detailTable->setFilter( 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 ) ) ) ;
    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 )
{
    QString filter = QString( "received >= UNIX_TIMESTAMP( '%1' ) AND "
                              "received <= '%2'" )
            .arg( dt.toString( "yyyy-MM-dd 00:00:00" ) )
            .arg( dt.toString( "yyyy-MM-dd 23:59:59" ) ) ;
    refer->exec( QString( "SELECT DISTINCT ticket_num WHERE %1 ;" )
                 .arg( filter ) ) ;
    dateLabel->setText( dt.toString( "dd MM yyyy" ) ) ;
    fillTable() ;
}


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 ) ) ;
}