nerdmain.cpp

#include "nerdmain.h"
#include "ui_nerdmain.h"

NerdMain::NerdMain(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::NerdMain){
    ui->setupUi(this);
    winRecord = new RecordWindow;

    toggleDataElem(false);

    connect(ui->menuAbout,SIGNAL(triggered()),this,SLOT(about()));
    connect(ui->btnOpen,SIGNAL(clicked()),this,SLOT(open()));
    connect(ui->menuOpen,SIGNAL(triggered()),this,SLOT(open()));
    connect(ui->menuExit,SIGNAL(triggered()),this,SLOT(close()));
    connect(ui->btnStart,SIGNAL(clicked()),this,SLOT(start()));
    connect(ui->menuHomepage,SIGNAL(triggered()),this,SLOT(openHomepage()));
    connect(winRecord,SIGNAL(finished(int)),this,SLOT(toggleStartStop()));
    connect(ui->tableData, SIGNAL(cellEntered(int,int)),this,SLOT(setCurrentRecord(int)));
    connect(ui->tableData, SIGNAL(cellDoubleClicked(int,int)),this,SLOT(setCurrentCell(int,int)));
    connect(ui->btnNext,SIGNAL(clicked()),this,SLOT(setNextRecord()));
    connect(ui->btnPrev,SIGNAL(clicked()),this,SLOT(setPrevRecord()));
    //connect(,SIGNAL(),,SLOT());

    // Create keyboard shortcuts
    ui->menuExit->setShortcut(Qt::CTRL + Qt::Key_Q);
    ui->menuOpen->setShortcut(Qt::CTRL + Qt::Key_O);
    ui->menuStart->setShortcut(Qt::CTRL + Qt::Key_D);
    ui->menuStart->setShortcut(Qt::CTRL + Qt::Key_S);
    ui->menuStop->setShortcut(Qt::CTRL + Qt::Key_H);
    ui->btnNext->setShortcut(Qt::CTRL + Qt::Key_N);
    ui->btnPrev->setShortcut(Qt::CTRL + Qt::Key_B);
}

NerdMain::~NerdMain(){
    delete ui;
}

void NerdMain::setFileLabel(QString label){
    ui->labCurrent->setText(label);
}

void NerdMain::setFile(){
    fileInfo = QFileDialog::getOpenFileName(this,tr("Open Excel File"), "/home/", tr("Excel Files (*.xlsx)"));
    if(fileInfo.fileName() != NULL) {
        toggleDataElem(true);
        dataStore = new QXlsx::Document(fileInfo.absoluteFilePath());
        range = new QXlsx::CellRange(dataStore->dimension());
        setFileLabel(fileInfo.fileName());
        setTable();
        winRecord->setRecords(dataStore);
    }
}

void NerdMain::setTable(){
    ui->tableData->setColumnCount(range->columnCount());  // must be run first
    ui->tableData->setRowCount(range->rowCount()-1);     // must be run first
    QStringList headerList;
    for(int i= 1;i <= range->columnCount();i++){
        headerList << dataStore->read(1,i).toString();
    }
    ui->tableData->setHorizontalHeaderLabels(headerList);
    ui->tableData->resizeRowsToContents();
    ui->tableData->resizeColumnsToContents();
    ui->tableData->verticalHeader()->setVisible(false);

    ui->tableData->setEditTriggers(QAbstractItemView::NoEditTriggers);
    ui->tableData->setSelectionBehavior(QAbstractItemView::SelectRows);
    ui->tableData->setSelectionMode(QAbstractItemView::SingleSelection);
    ui->tableData->setShowGrid(false);
    for(int i = 1; i <= range->rowCount()-1; i++){
        for(int k = 1; k <= range->columnCount();k++){
            ui->tableData->setItem(i-1,k-1,new QTableWidgetItem(dataStore->read(i+1,k).toString()));
        }
    }
}

void NerdMain::open(){
    if(fileInfo.fileName() != NULL){
        setFileLabel("None");
        toggleDataElem(false);
        setFile();
    } else {
        setFile();
    }
}

void NerdMain::start(){
    winRecord->show();
    toggleStartStop();
}

void NerdMain::toggleDataElem(bool isData){
    if(isData){
        ui->btnPrev->setEnabled(false);
        ui->tableData->setVisible(true);
        ui->btnOpen->setText("Change File");
        ui->btnStart->setVisible(true);
        this->setMinimumHeight(400);
        this->setMaximumHeight(400);
        ui->menuRun->setEnabled(true);
    } else {
        ui->btnPrev->setEnabled(false);
        ui->tableData->setVisible(false);
        ui->btnOpen->setText("Open File");
        ui->btnStart->setVisible(false);
        this->setMinimumHeight(84);
        this->setMaximumHeight(84);
        this->setMaximumWidth(400);
        this->setMinimumWidth(400);
        ui->menuRun->setEnabled(false);
    }
}

void NerdMain::toggleStartStop(){
    bool menu = ui->menuStart->isEnabled();
    if(menu){
       ui->menuSkip->setEnabled(true);
       ui->menuStop->setEnabled(true);
       ui->menuStart->setEnabled(false);
    } else {
        ui->menuSkip->setEnabled(false);
        ui->menuStop->setEnabled(false);
        ui->menuStart->setEnabled(true);
    }
}

void NerdMain::setCurrentRecord(int row){
    ui->tableData->selectRow(row);
    ui->tableData->setCurrentCell(row,1);
    winRecord->setRecordNum(row+1);
    if(0 == row){
        ui->btnPrev->setEnabled(false);
        ui->btnNext->setEnabled(true);
    } else if (range->rowCount()-2 == row){
        ui->btnPrev->setEnabled(true);
        ui->btnNext->setEnabled(false);
    }
}

void NerdMain::setCurrentCell(int row, int col){
    ui->tableData->setCurrentCell(row,col);
    ui->tableData->selectRow(row);
    if(row+1 != winRecord->getRecordNum()){
        winRecord->setRecordNum(row+1);
    }
    winRecord->setDataItem(col);
}

void NerdMain::setNextRecord(){
    int current = winRecord->getRecordNum();
    if(0 < current) {
        setCurrentRecord(current);
    }
}

void NerdMain::setPrevRecord(){
    int current = winRecord->getRecordNum()-1;
    if (current >= 0){
        if (current == 1) {
            ui->btnPrev->setEnabled(false);
        }
        setCurrentRecord(current-1);
    }
    if(!ui->btnNext->isEnabled()){
        ui->btnNext->setEnabled(true);
    }
}

void NerdMain::about(){
    AboutWindow *winAbout;
    winAbout = new AboutWindow;

    winAbout->show();
}

void NerdMain::openHomepage(){
    QDesktopServices::openUrl(QUrl("http://www.cci.edu", QUrl::TolerantMode));
}