Ejemplo n.º 1
0
int main(int argc, char * argv[])
{
    testDoc();
    return 0;
}
Ejemplo n.º 2
0
void docItem::openItem(){    
    if (list.size() == 0){
        ui.lineEdit_title->clear();
    } else if (list.size() > 0){
        QSqlQuery query(QString("select book_item.book, books.title, book_item.identifier  "
                                "from book_item,doc_item, books "
                                "where doc_item.book_item = book_item.id and books.id = book_item.book "
                                "and doc_item.id = \'%1\' ").arg(list.at(curr)));
        query.next();
        ui.spinBox_id_book->setValue(query.value(0).toInt());
        ui.lineEdit_title->setText(query.value(1).toString());
        //ui.spinBox_coun->setValue(query.value(2).toInt());
        ui.lineEdit_identifier->setText(query.value(2).toString());
    }
    viewItems();

    //test for deleting
    if (vid == 1){
        QSqlQuery testRead(QString("select Count(card_read.id) "
                                   "from card_read, book_item "
                                   "where card_read.book_item = book_item.id and book_item.identifier = \'%1\'")
                           .arg(ui.lineEdit_identifier->text()));
        testRead.next();
        QSqlQuery testDoc(QString("select Count(doc_item.id) "
                                  "from doc_item, docs, book_item "
                                  "where doc_item.book_item = book_item.id and doc_item.doc = docs.id and docs.vid = 2 "
                                  "and book_item.identifier = \'%1\'")
                          .arg(ui.lineEdit_identifier->text()));
        testDoc.next();
        if (testRead.value(0).toInt() == 0 and testDoc.value(0).toInt() == 0){
            ui.pushButton_del->setEnabled(true);
        } else if (testRead.value(0).toInt() > 0 or testDoc.value(0).toInt() > 0){
            ui.pushButton_del->setEnabled(false);
        }
    } else if (vid == 2){
        ui.pushButton_del->setEnabled(true);
    }

    //

    if (list.size() == 0){
        ui.pushButton_toFirst->setEnabled(false);
        ui.pushButton_toLast->setEnabled(false);
        ui.pushButton_toNext->setEnabled(false);
        ui.pushButton_toPrev->setEnabled(false);
    } else if (list.size() > 0) {
        if (curr == 0){
            ui.pushButton_toFirst->setEnabled(false);
            ui.pushButton_toPrev->setEnabled(false);
        } else {
            ui.pushButton_toFirst->setEnabled(true);
            ui.pushButton_toPrev->setEnabled(true);
        }
        if (curr == list.size() - 1){
            ui.pushButton_toLast->setEnabled(false);
            ui.pushButton_toNext->setEnabled(false);
        } else {
            ui.pushButton_toLast->setEnabled(true);
            ui.pushButton_toNext->setEnabled(true);
        }
    }
}