Пример #1
0
/// Called when we want to administrate our list of users
void App::adminUsers() {
    // Check if we have the rights
    dbo::ptr<User> user = userSession()->user();
    if (!user) {
        go(urls::home);
        setStatusText(WString::tr("access-denied"));
    }
}
Пример #2
0
int LoginData::userSession(QString user_name)
{
    for (int i = 0; i < numberOfUsers(); i++)
    {
        if (userName(i) == user_name)
        {
            return userSession(i);
        }
    }
    return -1;
}
Пример #3
0
bool Peminjaman::pinjamBuku(QString peminjam, QString kdbuku){
    QString tanggalPinjam = QDate().currentDate().toString("yyyy-MM-dd");
    QString tanggalTempo = QDate().currentDate().addDays(7).toString("yyyy-MM-dd");
    QSqlQuery querypinjam, querybuku;
    QSettings userSession("Chip-Project","Libska-User");
    QString idPetugas = userSession.value("USERID").toString();
    bool ret=false;

    querybuku.exec("SELECT * FROM tbl_buku WHERE kd_buku = \""+kdbuku+"\" ");
    querybuku.next();
    //qDebug()<<querybuku.lastQuery();

    QString countTersedia = "0";
    if(querybuku.size() != 0){
        countTersedia = querybuku.value(querybuku.record().indexOf("tersedia")).toString();
    }else{
        //messagePinjam = "Buku tersedia";
    }


    if( countTersedia.toInt() >= 1){

        QString sql = "INSERT INTO tbl_peminjaman SET siswa=\""+peminjam+"\", buku=\""+kdbuku+"\", tgl_tempo=\""+tanggalTempo+"\", tgl_pinjam=\""+tanggalPinjam+"\", id_petugas=\""+idPetugas+"\" ";
        if(!querypinjam.exec(sql)){
            qDebug() << "Peminjaman::pinjamBuku : Error Query insert";
            qDebug() << sql;
            ret = false;
        }else{
            //Query Buku
            querybuku.clear();
            if(querybuku.exec("SELECT * FROM tbl_buku WHERE kd_buku = \""+kdbuku+"\" ")){
                querybuku.next();
                QString tersedia = querybuku.value(querybuku.record().indexOf("tersedia")).toString();
                int newTersedia = tersedia.toInt() - 1;
                int newCount = querybuku.value(querybuku.record().indexOf("count")).toInt() + 1;

                if(querybuku.size() == 1){
                    querybuku.clear();
                    if(querybuku.exec("UPDATE tbl_buku SET tersedia = \""+QString::number(newTersedia)+"\", count = \""+QString::number(newCount)+"\" WHERE kd_buku = \""+kdbuku+"\" ")){
                        QSqlQuery querySiswa;
                        querySiswa.exec("SELECT * FROM tbl_anggota WHERE no_induk = \""+peminjam+"\" ");
                        querySiswa.next();

                        int newCountSiswa = querySiswa.value(querybuku.record().indexOf("tersedia")).toInt() + 1;
                        querybuku.clear();
                        if(querybuku.exec("UPDATE tbl_anggota SET count = \""+QString::number(newCountSiswa)+"\" WHERE no_induk = \""+peminjam+"\" ")){

                        }else{
                            qDebug()<<"Error udpate tbl anggota : "+querybuku.lastQuery();
                        }
                        ret = true;
                    }else{
                        qDebug()<<"pinjamBuku : Error update stock";
                        ret = false;
                    }
                }

            }else{
                qDebug()<<"pinjamBuku : Error count stock";
                ret = false;
            }

        }
    }else{
        ret = false;
    }
    return ret;
}