projectstatus.cpp

Go to the documentation of this file.

#include "projectstatus.h"
#include <QSqlDatabase>
#include <QSqlQuery>
#include "common_definitions.h"
 
ProjectStatus::ProjectStatus(Ui::MainWindow* UI_Window)
{
    ui = UI_Window;
 
    QObject::connect(ui->ProjectStatus, SIGNAL(currentIndexChanged(int)), this, SLOT(StatusChanged(int)));
    QObject::connect(ui->IncrementStatus, SIGNAL(pressed()), this, SLOT(DoIncrement()));
    QObject::connect( ui->EnableStatusEditing, SIGNAL( stateChanged(int) ), this, SLOT( SetStatusEditing(int)));
    QObject::connect(ui->SetStatusDateNow, SIGNAL(pressed()), this, SLOT(DoStatusDateNow()));
}
 
void ProjectStatus::LoadStatus(void)
{
    // Clear the Development Family List
    ui->ProjectStatus->clear();
    // Get a List of the Development Families from Database
    QSqlQuery status_query( "select proj_status_index, status_name from project_status order by proj_status_index" );
 
    // Step through the Results
    int row_index = 0;
    while ( status_query.next() )
    {
        int status_index = status_query.value(0).toInt();
        QString status_entry = status_query.value(1).toString();
        ui->ProjectStatus->addItem( status_entry, status_index );
        row_index++;
    }
    if (row_index == 0)
    {
        LogAdd(LOG_ERROR, MODE_DATABASE, "Status List loading FAILED.");
    }
    else
    {
        LogAdd(LOG_DEBUG, MODE_DATABASE, QString("Status List loaded %1 item.").arg(QString::number(row_index)));
    }
}
 
void ProjectStatus::LogAdd(LOGGING_SEVERITY Severity, LOGGING_MODE Mode, const QString Message)
{
    REMOTE_LOG_ENTRY log_entry;
    log_entry.Severity = Severity;
    log_entry.Mode = Mode;
    log_entry.Message = Message;
    emit SendLogEntry(log_entry);
}
 
void ProjectStatus::StatusChanged(int NewStatus)
{
    SetNextStatusPrompt(NewStatus);
    LogAdd(LOG_DEBUG, MODE_OPERATOR, QString("Project Status Changed to %1").arg(ui->ProjectStatus->itemText(NewStatus)));
}
 
void ProjectStatus::SetNextStatusPrompt(int NewStatus)
{
    int current_index = ui->ProjectStatus->currentIndex();
    int top_item = ui->ProjectStatus->count();
 
    // Ignore the Status Selection that Occurs at Load Time
    if (top_item == 1) return;
 
    // Set the text for the Status Increment Button, but Not if it is "Inactive"
    if (current_index == (top_item - 1))
    {
        ui->IncrementStatus->setText("No More Levels");
    }
    else
    {
        ui->IncrementStatus->setText(QString("Set Status to %1").arg(ui->ProjectStatus->itemText(NewStatus+1)));
        if (!ui->EnableStatusEditing->isChecked()) ui->ProjectStatusDate->setDateTime(QDateTime::currentDateTime());
        PostStatus();
    }
}
 
void ProjectStatus::DoIncrement(void)
{
    int current_index = ui->ProjectStatus->currentIndex();
    int top_count = ui->ProjectStatus->count() - 1;
 
    if (current_index != top_count)
    {
        ui->ProjectStatus->setCurrentIndex(current_index + 1);
        SetNextStatusPrompt(current_index + 1);
    }
}
 
void ProjectStatus::SetStatusEditing(int EditStatus)
{
    bool is_checked = (bool)EditStatus;
 
    ui->ProjectStatus->setEnabled(is_checked);
    ui->ProjectStatusDate->setEnabled(is_checked);
    ui->SetStatusDateNow->setEnabled(is_checked);
}
 
void ProjectStatus::TriggerSendStatus(void)
{
    LogAdd(LOG_DEBUG, MODE_OPERATOR, "Request to Send Status Received.");
    emit SendStatus(ui->ProjectStatus->currentIndex());
}
 
void ProjectStatus::DoStatusDateNow(void)
{
    ui->ProjectStatusDate->setDateTime(QDateTime::currentDateTime());
}
 
void ProjectStatus::DoClear(void)
{
    LoadStatus();
    ui->IncrementStatus->setText(QString("Set Status to %1").arg(ui->ProjectStatus->itemText(1)));
}
 
void ProjectStatus::PostStatus(void)
{
    // Get the Status Information
    STATUS_INFO status_info;
    status_info.StatusName = ui->ProjectStatus->currentText();
    status_info.StatusIndex = ui->ProjectStatus->currentIndex() + 1;
    status_info.StatusDateTime = ui->ProjectStatusDate->dateTime();
    status_info.StatusDateTimeString = ui->ProjectStatusDate->dateTime().toString("hh:mm:ss dd-MMM-yyyy");
    //status_info.ProjectIndex = project_index;
 
    // Update the Project in the Database
    QString query_string = QString("update project set project_status = %1, status_date = '%2' where project_index = %3").
                           arg(QString::number(status_info.StatusIndex), status_info.StatusDateTime.toString(DATETIME_DATABASE_FORMAT), QString::number(project_index));
 
    QSqlQuery update_status_query;
    bool result = update_status_query.exec(query_string);
    if (result)
    {
        LogAdd(LOG_DEBUG, MODE_DATABASE, QString("Status Update to %1").arg(status_info.StatusName));
        emit SendStatusInfo(status_info);
    }
    else
    {
        LogAdd(LOG_ERROR, MODE_DATABASE, QString("Unable to update Status to %1").arg(status_info.StatusName));
    }
}
 
void ProjectStatus::ReadProjectInfo(PROJECT_INFORMATION* Info)
{
    project_index = Info->ProjectDesc.ProjectIndex;
    ui->ProjectStatus->setCurrentIndex(Info->StatusInfo.StatusIndex - 1);
    ui->ProjectStatusDate->setDateTime(Info->StatusInfo.StatusDateTime);
}