#include "dbquery.h"

void DbQuery::addLogInfo(const QString &logType, const QString &logDate,
                          const QString &logTime, const QString &logContent)
{
    QString sql = "insert into LogInfo(LogType,LogDate,LogTime,LogContent) values('";
    sql += logType + "','";
    sql += logDate + "','";
    sql += logTime + "','";
    sql += logContent + "')";

    QSqlQuery query;
    query.exec(sql);
}

void DbQuery::addLogInfo(const QString &logType, const QString &logContent)
{
    addLogInfo(logType, QDATE, TIME, logContent);
}

void DbQuery::addLogInfo(const QString &logContent)
{
    addLogInfo("管理日志", logContent);
}

void DbQuery::loadUserInfo()
{
    AppConfig::UserInfo_Count = 0;
    AppConfig::UserInfo_UserID.clear();
    AppConfig::UserInfo_UserName.clear();
    AppConfig::UserInfo_UserPwd.clear();
    AppConfig::UserInfo_UserAdmin.clear();
    AppConfig::UserInfo_UserDoor.clear();
    AppConfig::UserInfo_UserFinger.clear();

    QString sql = "select UserID,UserName,UserPwd,UserAdmin,UserDoor,UserFinger from UserInfo";
    QSqlQuery query;
    query.exec(sql);
    while(query.next()) {
        AppConfig::UserInfo_Count++;
        AppConfig::UserInfo_UserID.append(query.value(0).toString());
        AppConfig::UserInfo_UserName.append(query.value(1).toString());
        AppConfig::UserInfo_UserPwd.append(query.value(2).toString());
        AppConfig::UserInfo_UserAdmin.append(query.value(3).toString());
        AppConfig::UserInfo_UserDoor.append(query.value(4).toString());
        AppConfig::UserInfo_UserFinger.append(query.value(5).toString());
    }
}

void DbQuery::addUserInfo(const QString &userID, const QString &userName,
                           const QString &userPwd, const QString &userAdmin,
                           const QString &userDoor, const QString &userFinger)
{
    QString sql = "insert into UserInfo(UserID,UserName,UserPwd,UserAdmin,UserDoor,UserFinger) values('";
    sql += userID + "','";
    sql += userName + "','";
    sql += userPwd + "','";
    sql += userAdmin + "','";
    sql += userDoor + "','";
    sql += userFinger + "')";

    QSqlQuery query;
    query.exec(sql);
}

void DbQuery::updateUserInfo(const QString &userID, const QString &userName,
                              const QString &userPwd, const QString &userAdmin,
                              const QString &userDoor, const QString &userFinger)
{
    QString sql = QString("update UserInfo set UserName='%1',UserPwd='%2',UserAdmin='%3',UserDoor='%4',UserFinger='%5' "
                          "where UserID='%6'").arg(userName).arg(userPwd).arg(userAdmin).arg(userDoor).arg(userFinger).arg(userID);
    QSqlQuery query;
    query.exec(sql);
}

void DbQuery::updateUserInfo(const QString &userID, const QString &userFinger)
{
    QString sql = QString("update UserInfo set UserFinger='%1' where UserID='%2'").arg(userFinger).arg(userID);
    QSqlQuery query;
    query.exec(sql);
}

void DbQuery::deleteUserInfo(const QString &userID)
{
    QString sql = QString("delete from UserInfo where UserID='%1'").arg(userID);
    QSqlQuery query;
    query.exec(sql);
}

bool DbQuery::existUser(const QString &userID)
{
    QString sql = QString("select count(*) from UserInfo where UserID='%1'").arg(userID);
    QSqlQuery query;
    query.exec(sql);
    query.next();
    return query.value(0).toInt() != 0;
}

bool DbQuery::getUserInfo(const QString &userID, QString &userFinger)
{
    QString sql = QString("select UserFinger from UserInfo "
                          "where UserID='%1'").arg(userID);
    QSqlQuery query;
    query.exec(sql);
    bool exist = query.next();
    if (exist) {
        userFinger = query.value(0).toString();
    }

    return exist;
}

bool DbQuery::getUserInfo(const QString &userID, QString &userName,
                           QString &userPwd, QString &userAdmin,
                           QString &userDoor, QString &userFinger)
{
    QString sql = QString("select UserName,UserPwd,UserAdmin,UserDoor,UserFinger from UserInfo "
                          "where UserID='%1'").arg(userID);
    QSqlQuery query;
    query.exec(sql);
    bool exist = query.next();
    if (exist) {
        userName = query.value(0).toString();
        userPwd = query.value(1).toString();
        userAdmin = query.value(2).toString();
        userDoor = query.value(3).toString();
        userFinger = query.value(4).toString();
    }

    return exist;
}

void DbQuery::addGoodsInfo(const QString &goodsID, const QString &goodsEPC,
                            const QString &goodsType, const QString &goodsContent)
{
    QString sql = "insert into GoodsInfo(GoodsID,GoodsEPC,GoodsType,GoodsContent) values('";
    sql += goodsID + "','";
    sql += goodsEPC + "','";
    sql += goodsType + "','";
    sql += goodsContent + "')";

    QSqlQuery query;
    query.exec(sql);
}

void DbQuery::addErrorInfo(const QString &errorType, const QString &errorContent)
{
    QString sql = "insert into ErrorInfo(ErrorType,ErrorContent) values('";
    sql += errorType + "','";
    sql += errorContent + "')";

    QSqlQuery query;
    query.exec(sql);
}